A rental property analysis spreadsheet calculates cash flow, cap rate, cash-on-cash return, and DSCR from property inputs, giving you a buy/pass decision in 10 minutes instead of 2 hours of back-of-napkin math.
The 5 Numbers That Determine Every Deal
Every rental analysis comes down to five metrics. Your spreadsheet should calculate all five automatically from the same inputs.
1. Monthly Cash Flow
Formula: Gross Rent − All Expenses − Mortgage Payment
- Positive cash flow = property pays for itself
- Target: $200+ per door for single-family, $100+ per unit for multifamily
- Below $100/month: one vacancy or one repair wipes out a full year of profit
2. Cap Rate
Formula: (Annual NOI ÷ Purchase Price) × 100
- Measures return independent of financing
- 5-7% cap: typical for stable markets (Phoenix, Dallas, Tampa)
- 7-10% cap: higher cash flow markets (Memphis, Cleveland, Indianapolis)
- Below 5%: you're betting on appreciation, not cash flow
3. Cash-on-Cash Return
Formula: (Annual Cash Flow ÷ Total Cash Invested) × 100
- Measures return on YOUR money, including leverage
- Target: 8-12% for buy-and-hold
- Below 6%: your money earns similar returns in index funds with zero landlord headaches (see our guide on what makes a good cash-on-cash return)
- Above 15%: double-check your assumptions
4. DSCR (Debt Service Coverage Ratio)
Formula: NOI ÷ Annual Debt Service
- Lenders require 1.20-1.25 minimum for investment property loans
- Below 1.0: property doesn't cover its own debt
- Above 1.5: strong buffer for vacancies and repairs
5. The 1% Rule (Quick Filter)
Formula: Monthly Rent ÷ Purchase Price
- 1% or higher: likely cash flows at current rates (see our 1% rule breakdown)
- 0.8-1%: might work with low taxes/insurance
- Below 0.7%: rarely cash flows in any scenario
Inputs Your Spreadsheet Needs
Your spreadsheet is only as good as its inputs. Here's what goes in, organized by tab.
Property Data
| Input | Where to Find It | Example |
|---|---|---|
| Purchase price | Listing or offer price | $195,000 |
| Monthly rent | Market comps, Zillow, Rentometer | $1,650 |
| Property taxes | County assessor website | $2,340/year |
| Insurance | Quote from agent or estimate | $1,200/year |
| HOA fees | Listing or HOA office | $0 |
Financing Assumptions
| Input | Typical Range | Example |
|---|---|---|
| Down payment % | 20-25% for investment | 25% ($48,750) |
| Interest rate | Get a real quote, don't guess | 7.43% (Oct 2026 avg) |
| Loan term | 30 years standard | 30 years |
| Closing costs | 2-5% of purchase price | 3% ($5,850) |
Operating Expenses
| Input | % of Rent or Value | Example |
|---|---|---|
| Property management | 8-10% of rent | 8% ($132/mo) |
| Vacancy | 5-8% of annual rent | 5% ($83/mo) |
| Repairs | 1% of property value | $163/mo |
| CapEx reserves | 1% of property value | $163/mo |
| Utilities (if landlord-paid) | Varies | $0 |
Worked Example: $195,000 Single-Family Rental
Let's run the full analysis on a 3-bed/2-bath in Indianapolis listed at $195,000 with estimated rent of $1,650/month.
Step 1: Calculate NOI
| Line Item | Monthly | Annual |
|---|---|---|
| Gross rent | $1,650 | $19,800 |
| Vacancy (5%) | -$83 | -$990 |
| Property taxes | -$195 | -$2,340 |
| Insurance | -$100 | -$1,200 |
| Property management (8%) | -$132 | -$1,584 |
| Repairs (1% of value) | -$163 | -$1,950 |
| CapEx (1% of value) | -$163 | -$1,950 |
| NOI | $815 | $9,786 |
Step 2: Calculate mortgage payment
- Loan amount: $195,000 × 75% = $146,250
- Rate: 7.43%, 30-year fixed (national average as of October 2026)
- Monthly P&I: $1,016
Step 3: Calculate all five metrics
| Metric | Calculation | Result | Verdict |
|---|---|---|---|
| Monthly cash flow | $815 NOI − $1,016 P&I | -$201 | Negative with PM |
| Cap rate | $9,786 ÷ $195,000 | 5.0% | Low for Indianapolis |
| Cash-on-cash return | -$2,412 ÷ $54,600 | -4.4% | Fails |
| DSCR | $9,786 ÷ $12,192 | 0.80 | Below 1.0 — won't qualify |
| 1% rule | $1,650 ÷ $195,000 | 0.85% | Below 1% threshold |
Verdict: Pass. This property doesn't cash flow with professional management at current rates. The DSCR is below 1.0, meaning it can't cover its own debt service.
What Would Make This Deal Work?
Your spreadsheet should have a sensitivity tab that answers this question automatically.
| Scenario | Monthly Cash Flow | Cash-on-Cash | DSCR |
|---|---|---|---|
| Purchase at $195K, 7.43% rate | -$201 | -4.4% | 0.80 |
| Negotiate to $175K | -$43 | -1.0% | 0.95 |
| $175K + self-manage (no PM fee) | $89 | 2.2% | 1.10 |
| $175K + self-manage + rate drops to 6.43% | $177 | 4.3% | 1.22 |
| Rent hits $1,850 (value-add) | -$26 | -0.6% | 0.97 |
At $195,000 and 7.43% (October 2026), no scenario with professional management produces meaningful cash flow. You'd need a purchase price around $137,000 or rent closer to $2,300 to see an 8%+ CoC return.
This is exactly why running the spreadsheet matters: the listing looks reasonable, but the math says otherwise.
Red Flags Your Spreadsheet Should Auto-Flag
Build conditional formatting or warning rules for these:
Cash flow under $100/month: One repair or one vacancy month turns it into a break-even year, so you're working for free.
DSCR under 1.25: You won't qualify for most investment property loans. Even if you have the cash to buy outright, a sub-1.25 DSCR signals the property barely covers its costs.
Cash-on-cash under 6%: Your money earns similar returns in a total stock market index fund with zero landlord headaches, no vacancy risk, and perfect liquidity.
Vacancy at 0%: No property achieves 0% vacancy over a 10-year hold. Budget 5% minimum, 8% in markets with seasonal demand.
Repairs at $0: Every property needs repairs. Budget 1% of property value annually at minimum. Older properties (pre-1980) need 1.5-2%.
Rent estimate without comps: If your rent number comes from the seller, the listing agent, or your gut, it's wrong. Pull actual comps for the same bedroom count, condition, and neighborhood within the last 90 days.
Worked Example 2: A Deal That Works
Same market, different property. A 3-bed/1.5-bath in a B-class Indianapolis neighborhood listed at $155,000 with comps showing $1,550/month rent.
| Line Item | Monthly | Annual |
|---|---|---|
| Gross rent | $1,550 | $18,600 |
| Vacancy (5%) | -$78 | -$930 |
| Property taxes | -$155 | -$1,860 |
| Insurance | -$92 | -$1,100 |
| Property management (8%) | -$124 | -$1,488 |
| Repairs (1%) | -$129 | -$1,550 |
| CapEx (1%) | -$129 | -$1,550 |
| NOI | $844 | $10,122 |
| Metric | Calculation | Result | Verdict |
|---|---|---|---|
| Mortgage (75% LTV, 7.43%) | $116,250 loan | $807/mo | — |
| Monthly cash flow | $844 − $807 | $37 | Thin but positive |
| Cap rate | $10,122 ÷ $155,000 | 6.5% | Solid for market |
| Cash-on-cash (self-managed) | ($37 + $124) × 12 ÷ $43,400 | 4.5% | Borderline |
| DSCR | $10,122 ÷ $9,684 | 1.05 | Below 1.25 — tight |
| 1% rule | $1,550 ÷ $155,000 | 1.0% | Hits the threshold |
The numbers are still thin with management. Self-managed, though, cash flow is $161/month ($1,932/year), and the CoC rises to 4.5%. If you negotiate the price to $145,000 and self-manage, CoC jumps to 7.1% with a 1.07% rent-to-price ratio.
The difference between the $195K property and the $155K property is obvious in a spreadsheet. Without one, both "look like deals," even though only one of them is.
Beyond the Buy: Post-Purchase Monitoring
Your analysis spreadsheet answers one question: should I buy this property?
Things can change 18 months after you close. Your $200/month cash flow property might be $50/month if:
- Market rents rose 12% and you didn't raise rent at renewal
- Property taxes increased after reassessment
- Insurance premiums jumped 20% (common in storm-prone states)
A deal that passed analysis on Day 1 can slowly lose ground without ongoing monitoring. The most costly version of this is when your rents are $200/month below market across 5 properties. That's $12,000/year in missed cash flow, and at a 7% cap rate, $171,000 in suppressed portfolio value.
FAQ
What should a rental property analysis spreadsheet include?
A rental property analysis spreadsheet should calculate five core metrics: monthly cash flow, cap rate, cash-on-cash return, DSCR, and the 1% rent-to-price ratio. Required inputs include purchase price, estimated rent (from market comps), property taxes, insurance, financing terms, and operating expense percentages for vacancy (5-8%), repairs (1% of value), CapEx (1%), and property management (8-10%).
What is a good cash-on-cash return for rental property?
Target 8-12% cash-on-cash return for buy-and-hold rental properties. Below 6%, your capital earns similar returns in passive index funds without landlord responsibilities. Above 15% is excellent, but verify your assumptions, because overly optimistic rent or expense projections can inflate this number. With 30-year fixed rates averaging 7.43% as of October 2026, achieving 8%+ CoC requires either lower purchase prices or self-management.
How do I estimate rent for a property I haven't bought yet?
Pull actual rental comps: use listings with the same bedroom count, similar condition, and the same neighborhood (not Zillow Zestimates), ideally from the last 90 days. Check Zillow rentals, Apartments.com, and Craigslist for active listings. Operator pulls live market rent comps for any address, which removes the guesswork that can make or break your analysis.
What is DSCR and why does it matter?
DSCR (Debt Service Coverage Ratio) = Net Operating Income ÷ Annual Debt Payments. A 1.25 DSCR means the property generates 25% more income than its mortgage costs. Most investment property lenders require 1.20-1.25 minimum. Below 1.0 means the property doesn't cover its own debt, so you're putting in cash every month.
How does Operator compare to a rental property analysis spreadsheet?
Operator calculates NOI and DSCR for any address, shows cap rate and cash-on-cash for the properties you own, and checks your rents against live market comps every month. Plans start at $49/mo with a 7-day free trial.



