- 01The deal funnel approach: start with 100 listings, filter to 10 with the 1% rule, deep-dive 3, offer on 1
- 02Cash-on-cash return is the metric that matters most for rental investors — it tells you what your actual cash investment earns each year
- 03AI tools like the GPT Cash Flow Calculator can analyze a deal in 30 seconds that would take 45 minutes on a spreadsheet
- 04Never trust a seller's pro forma — always run your own numbers with conservative assumptions (5% vacancy, 5% maintenance, 10% management)
Show Notes
Show Notes
I'm Martin Maxwell. How many deals did you analyze last month? Fewer than ten means you're not looking at enough. A hundred with no offers means you're drowning in analysis paralysis. Both problems have the same root cause — no filtering system. Today I'm giving you that system: the deal funnel, paired with AI tools that cut hours of spreadsheet work down to minutes.
The Deal Funnel: 100 → 10 → 3 → 1
Top of funnel: 100 listings from Zillow, MLS alerts, wholesaler lists, off-market leads. First filter: the 1% rule. Monthly rent divided by purchase price — if it hits 1%, it passes. A $200,000 property renting for $2,000/month passes; $1,400/month at 0.7% gets cut. This single filter eliminates 80-90% of listings. In expensive coastal markets, adjust to 0.8% and accept that returns come more from appreciation.
From 10 survivors, pick the three strongest for full analysis — NOI, cap rate, cash-on-cash return, debt service, reserves. One deal emerges as the winner. Make your offer. Rejected? Refill the funnel. Do it weekly.
Cash-on-Cash Return — The Metric That Matters
Annual pre-tax cash flow divided by total cash invested. Example: $250,000 rental, $50,000 down, $5,000 closing costs, $3,000 repairs — $58,000 total cash in. Rent at $2,100/month, expenses at $2,065/month (mortgage, taxes, insurance, 5% vacancy, 5% maintenance, 10% management). Monthly cash flow: $35. Annual: $420. Cash-on-cash: 0.72%. That's worse than a savings account.
Same property at $2,400/month rent: $335/month cash flow, $4,020 annually, 6.9% cash-on-cash. Above 8% and you've got something worth pursuing. Running real numbers with conservative assumptions is what separates good deals from bad ones.
AI-Powered Analysis
The GPT Cash Flow Calculator runs a full deal analysis in 30 seconds — NOI, cap rate, cash-on-cash, debt service coverage, monthly cash flow. It also flags bad assumptions: type 0% vacancy and it pushes back. Budget below 5% maintenance and it warns you. The tool keeps you honest when you're excited about a deal.
Spreadsheets are still great for scenario modeling — what if rates climb, rents drop 10%, you add a bedroom? But for the first-pass analysis on those ten funnel survivors, AI tools save hours.
Conservative Assumptions That Protect You
Vacancy: 5% (roughly 2.5 weeks empty per year). Maintenance: 5%. Capital expenditures: 5% (roof, water heater, driveway — budget now or get blindsided). Management: 10%, even if you self-manage, because someday you'll want to stop. Rent growth: 0% in initial analysis — upside if it happens, but the deal must work at today's rents.
Add those up: 25% of gross rent goes to expenses before the mortgage. When a seller hands you a pro forma showing 95% occupancy and 2% maintenance, you know it's fiction.
Your Challenge This Week
Analyze one real listing in your target market. Run the 1% rule. If it passes, plug numbers into a calculator using the 5/5/5/10/0 assumptions. Cash-on-cash above 8%? Worth pursuing. Between 5-8%? Depends on appreciation. Below 5%? Move on. Do this weekly, and within a month you'll eyeball a listing and know in ten seconds whether it deserves a deeper look.
Resources Mentioned
- Cap Rate vs. Cash-on-Cash Return — the two metrics that tell you whether a deal actually works
- Rental Property Spreadsheet Template — what to track and how to build your own analysis tool
- The Investor's Guide to Effective Yield — see the real return on your money after financing
- How to Find Off-Market Rental Deals — sourcing strategies to fill the top of your deal funnel
- ChatGPT — the AI platform powering the GPT Cash Flow Calculator referenced in this episode
Cash-on-cash return measures your annual pre-tax cash flow as a percentage of the total cash you actually invested in a property.
Read definition →Cap rate measures a property's annual net operating income as a percentage of its purchase price or current market value, assuming an all-cash purchase.
Read definition →NOI (net operating income) is what a property earns from operations each year. Rental revenue minus vacancy loss and operating expenses. Before you subtract the mortgage, CapEx, or taxes.
Read definition →Monthly rent should hit at least 1% of what you paid. That's the 1% rule. A $185,000 house? $1,850/month or more. Quick screen — not a full analysis.
Read definition →Cash flow is what's left in your pocket after a rental pays all its expenses — including the mortgage. NOI minus debt service. What actually hits your bank account each month or year.
Read definition →
