Every rental property looks profitable on a Zillow listing. The trouble starts when you actually run the numbers on a rental property — and that’s where most investors quietly lose money. The difference between a portfolio that compounds and one that bleeds cash usually isn’t market timing or luck. It’s whether the investor knew how to do the math before they bought.
In this post, you’ll learn the five most common mistakes investors make when they run the numbers on a rental property, the right formulas to use instead, and a simple 5-minute screening framework you can apply to every deal before you sign anything.
Why Running the Numbers Matters More Than the Pretty Photos
A rental property is, financially speaking, a tiny business. It has revenue (rent), operating costs (taxes, insurance, repairs, management), debt service (your mortgage), and capital expenses (roof, HVAC, paint). If any one of those line items is wrong, your projected return is wrong — and once you close, the math doesn’t get more forgiving. The same discipline that helps small business owners avoid cash flow mistakes that kill profitability applies just as directly to landlords.
The investors who build real wealth with rentals share one habit: they run the numbers conservatively, completely, and twice. The five mistakes below are the ones I see most often when analyzing rental properties with coaching clients — and each one can turn what looks like a “good deal” into a slow-bleed money pit.
Mistake #1: Forgetting Vacancy and Bad Debt
The number one shortcut that destroys rental property math is assuming 100% occupancy. No property is rented every day for the next 30 years. Tenants leave. Units sit empty during turnover. Some renters don’t pay.
The right way: bake a vacancy and credit loss factor of 5–10% into every projection. In some markets, you’ll need 10–15%. Pull your local rate from the U.S. Census Bureau’s Housing Vacancy Survey rather than guessing.
The formula:
Effective Gross Income = Gross Scheduled Rent × (1 − Vacancy Rate %)
If your gross rent is $24,000/year and you assume 8% vacancy, your real income to plan around is $22,080 — not $24,000. That $1,920 difference is often the gap between healthy cash flow and surprise calls to your lender.
Mistake #2: Underestimating Operating Expenses
Newer investors often plug in property taxes and insurance, then call it done. That’s how you discover, six months in, that you forgot:
- Property management (typically 8–10% of collected rent)
- Repairs and maintenance (5–10% of rent, more for older homes)
- Capital expenditure reserves for roof, HVAC, water heater (5–10%)
- Lawn care, snow removal, pest control
- Utilities, if owner-paid
- HOA dues
- Vacancy turnover costs (paint, cleaning, leasing fees)
A useful rule of thumb is the 50% rule — assume operating expenses (excluding the mortgage) will eat about 50% of your gross rent. It’s a screening tool, not a substitute for a real budget. For a complete walkthrough of every line item to plan for, see the step-by-step rental property budget guide.
Mistake #3: Confusing Cap Rate with Cash-on-Cash Return
These two metrics measure very different things, and using the wrong one is one of the fastest ways to misjudge a deal.
Cap rate measures the property’s return as if you paid all cash. It tells you how the building performs independent of how you finance it.
Cap Rate = Net Operating Income ÷ Purchase Price
Cash-on-cash return measures your return on the actual cash you put into the deal — including the leverage from your mortgage.
Cash-on-Cash Return = Annual Pre-Tax Cash Flow ÷ Total Cash Invested
A property can have a mediocre 5% cap rate but produce a great 12% cash-on-cash return because of financing — or vice versa. Both numbers matter. Use cap rate to compare properties apples-to-apples, and use cash-on-cash return to evaluate whether your money is working hard enough. For a deeper look at when cap rate helps and when it misleads, see the complete guide to cap rate.
Mistake #4: Ignoring CapEx and Reserves
Operating expenses pay for the things that happen every month. CapEx — capital expenditures — pays for the things that happen once a decade and cost five figures. Roof: $8,000–$15,000. HVAC: $5,000–$10,000. Water heater: $1,500. Exterior paint: $4,000–$8,000.
If you’re not setting aside money for these every month, you’re not actually cash-flowing — you’re borrowing from your future self. A simple rule: estimate the lifespan and replacement cost of each major system, divide by months of useful life, and reserve that amount monthly.
For a 30-year roof costing $12,000, that’s about $33/month. Do this for every major system and you’ll often find another $100–$200/month that needs to come out of your projected “cash flow.”
Mistake #5: Forgetting About Taxes (Both Kinds)
Property taxes aren’t fixed. When you buy, the assessed value usually resets — and your tax bill can jump significantly. Always project the property tax bill post-purchase, not based on the seller’s last assessment. Your local county assessor’s website will tell you the formula.
Income taxes matter too — usually in your favor. Depreciation lets you write off a portion of the property’s value every year against your rental income. The IRS allows residential rental property to be depreciated over 27.5 years. On a $250,000 building (excluding land), that’s roughly $9,000/year of paper deductions that can dramatically improve your after-tax return.
The mistake is doing your math entirely pre-tax. The deal that looks marginal might shine after depreciation — and the deal that looks great might lose appeal once you account for a higher tax bracket without it.
How to Run the Numbers in 5 Minutes
Before you go deep on any rental property, run this quick screen:
- Estimate gross rent from comparable rentals — not the listing’s optimistic projections.
- Subtract vacancy at 8–10%.
- Apply the 50% rule — assume half of effective gross income covers operating expenses.
- Subtract debt service at your actual interest rate, not what the listing assumes.
- Calculate cash-on-cash return on your total cash in (down payment + closing + initial repairs).
If the cash-on-cash is below 6–8%, you probably don’t have a deal. If it clears 10%+, it’s worth pulling out a real spreadsheet and stress-testing the assumptions.
Run the Numbers the Same Way Every Time
The investors who get this right share one habit: they use a template instead of guessing. A good rental property analysis spreadsheet enforces the discipline — vacancy gets included, CapEx reserves get budgeted, taxes get re-projected, and cash-on-cash gets calculated correctly. Without a template, every deal becomes a fresh chance to forget something expensive. With one, the math stays consistent across every property you evaluate, so you can compare deals apples-to-apples and walk away from bad ones faster.
Get the Free Rental Property Deal Analyzer
Skip the spreadsheet building and get straight to evaluating deals. Book a free 15-minute consult and I’ll walk you through the rental property deal analyzer Simply Spreadsheets uses with every coaching client. It includes built-in vacancy assumptions, CapEx reserves, both cap rate and cash-on-cash calculations, and a sensitivity table so you can stress-test rent and interest-rate scenarios before you commit.
About Simply Spreadsheets
Simply Spreadsheets is trusted by small business owners and real estate investors who want better numbers and clearer decisions. We build custom spreadsheets, offer fractional CFO services, and coach investors through analyzing deals with confidence. If you’re tired of guessing whether a property cash flows, we’d love to help.
Simply Spreadsheets 
Leave a comment