Evaluating a rental property deal
The numbers to run before you buy. NOI, vacancy, reserves, and the spreadsheet approach that separates serious investors from impulse buyers.
The difference between a good rental investment and a financial disaster is almost always in the analysis done before the purchase. Most bad deals looked great to someone who didn't run the numbers carefully. Here's the framework experienced investors use — not to predict the future, but to stress-test the present.
Step 1: Estimate gross rental income
Look at comparable rentals within a half-mile radius on Zillow, Rentometer, or local property management websites. Don't use the seller's claimed rents — verify independently. If the property is a duplex with two units renting at $1,200 each, gross potential rent is $28,800/year. Then subtract vacancy. Use 5% minimum for strong rental markets, 8–10% for average ones, and 10–15% if the neighborhood has high turnover. At 8% vacancy, your effective gross income is $26,496.
Step 2: Calculate operating expenses
- Property taxes: Pull from the county assessor's website. Don't trust listing data.
- Insurance: Get an actual quote for a landlord policy. Budget $1,200–$2,500/year for a single-family rental.
- Maintenance and repairs: Budget 5–10% of gross rent. Older properties need more.
- Capital expenditures (CapEx): Roof, HVAC, water heater, appliances — big-ticket replacements. Budget another 5–10% of gross rent in a reserve fund.
- Property management: 8–10% of collected rent if you hire a manager. If you self-manage, be honest about what your time is worth.
- Utilities: Any utilities you pay (water, trash, lawn care in some markets).
- HOA fees: If applicable, these can destroy cash flow. A $400/month HOA on a condo rental is a dealbreaker in most markets.
Step 3: Determine NOI and debt service
Net Operating Income (NOI) is your effective gross income minus all operating expenses (but not the mortgage). If your effective gross is $26,496 and operating expenses total $11,000, your NOI is $15,496. Now subtract your annual mortgage payment (principal + interest). On a $240,000 loan at 7% over 30 years, that's roughly $19,200/year. Your pre-tax cash flow is $15,496 minus $19,200 = negative $3,704. This deal does not cash-flow. Many deals in 2024-era interest rate environments don't. The question becomes whether appreciation, principal paydown, and tax benefits justify a small monthly loss.
Step 4: Stress-test the deal
Run the numbers three ways: your base case, a pessimistic case (rents 10% lower, vacancy 5% higher, one major repair in year one), and a worst case (extended vacancy, rate increase on refinance, major CapEx). If the pessimistic case causes you to drain savings or miss mortgage payments, the deal is too thin. Real estate is unforgiving to investors with no margin. The properties that look slightly boring on a spreadsheet — the ones with conservative assumptions that still work — are the ones that build wealth over 20 years.
The full analysis on one page
| Line item | Optimistic seller math | Conservative buyer math |
|---|---|---|
| Gross potential rent | $28,800 | $28,800 |
| Vacancy | $0 | -$2,304 (8%) |
| Taxes + insurance | -$5,200 | -$5,800 (reassessed) |
| Maintenance + capex | -$1,500 | -$4,300 (15%) |
| Management | $0 | -$2,120 (8%) |
| NOI | $22,100 | $14,276 |
| Debt service | -$19,200 | -$19,200 |
| Cash flow | +$2,900 | -$4,924 |
Same property, same price, same loan — a $7,800 swing in projected cash flow, entirely from assumptions. This is why two investors can look at one listing and reach opposite conclusions, and why the seller's pro forma always looks better than your spreadsheet. The conservative column is not pessimism; it is the version of the deal most likely to actually happen over a ten-year average. If a deal only works in the left column, you are not buying an investment — you are buying the seller's optimism at full price.
The offer price is an output, not an input
Beginners start with the asking price and check whether the deal works. Experienced investors run the math backward: decide the cash flow and return you require, then solve for the price that produces it. If the duplex above needs to generate $200/month of conservative cash flow to justify your time and risk, that might mean your maximum offer is $255,000 — and if the seller will not take it, the correct move is nothing. There are no prizes for winning a negotiation into a losing deal. Write your walk-away number down before the showing, because granite countertops have a documented ability to add $30,000 to a buyer's maximum price in under twenty minutes.
Common analysis mistakes
- Using the seller's property tax bill. Many jurisdictions reassess at sale — your bill can jump 30–60% over the number in the listing.
- Forgetting rent-ready costs. Most 'tenant-occupied, cash-flowing' properties need $3,000–8,000 of deferred maintenance the day the inherited tenant leaves.
- Counting appreciation as certain. Model it at zero for the buy decision; let it be upside, not load-bearing.
- Analyzing one scenario. A deal you would only buy in the base case is a deal you should not buy at all.
- Skipping the sewer scope and roof inspection to save $500 — the two most expensive surprises in residential real estate cost less than a car payment to discover in advance.
Finally, keep the analysis alive after closing. Re-run the same spreadsheet on the property's actual numbers every year: real vacancy, real repairs, real taxes. The gap between your underwriting and reality is the most valuable education in real estate — it calibrates every future offer you make, and it tells you, with numbers instead of feelings, whether this property is a keeper, a refinance candidate, or next spring's listing. Deal analysis is not a gate you pass through once at purchase; it is the ongoing discipline that separates a portfolio from a pile of houses, and the investors who practice it annually are the ones still buying calmly when everyone else is guessing.
Check your understanding
1 of 4Not quite — try again.
Get smarter about money every week
One email, no spam — practical guides and Worth updates. Unsubscribe anytime.
Put this into practice
Worth tracks your accounts, budgets, and goals — so the concepts in this article aren't just theory.
Start free trial