Most rental deals fail on a spreadsheet, not in real life. The investors who lose money rarely buy a bad building. They buy a good building at the wrong number, because they skipped the math or trusted a listing agent’s “projected” rent. Rental property analysis is the discipline that keeps that from happening to you.
This is the complete guide to rental property analysis: the exact metrics, the formulas behind them, and a full worked example you can copy on your next deal. By the end you will be able to look at any listing and know, in about ten minutes, whether it is worth a second look or a hard pass.
What Is Rental Property Analysis?
Rental property analysis is the process of estimating what a property will actually earn after every real cost is paid, then comparing that return against what you put in. It turns a list price and a rent estimate into the numbers that matter: net operating income, cap rate, cash flow, and cash-on-cash return.
Done right, it answers three questions. Will the property cover its own costs every month? Is the price fair for the income it produces? And is your cash earning a better return here than it would somewhere else? A property can pass one test and fail the others, which is exactly why investors who lean on a single rule of thumb get burned.
The 6 Numbers Every Rental Property Analysis Needs
You do not need twenty metrics. You need six, in order, each one building on the last. We cover the full set in 7 Numbers Every Rental Property Analysis Needs, but these are the load-bearing ones.
1. Gross rent and the 1% rule
Start with the rent the property will realistically command, not the optimistic number on the listing. Pull comparable rents from the same neighborhood and property type. The 1% rule is a fast first filter: monthly rent should be at least 1% of the purchase price. A $320,000 property would need to rent for $3,200 a month to pass. Most markets in 2026 no longer hit that, so treat a miss as a reason to dig deeper, not an automatic no. We break down where it still works in The 1% Rule for Rental Property: Does It Still Work in 2026?
2. Net operating income (NOI)
NOI is annual rental income minus annual operating expenses, before the mortgage. Operating expenses include property taxes, insurance, maintenance, vacancy, property management, and a capital expenditure reserve for the roof and systems you will eventually replace. The single most common analysis error is leaving expenses out, which is why the 50% rule exists: over time, operating costs tend to eat roughly half of gross rent. If your expense estimate comes in far below that, recheck it.
3. Cap rate
Cap rate is NOI divided by purchase price, expressed as a percentage. It tells you the unleveraged yield, which makes it the cleanest way to compare two properties side by side. According to BiggerPockets, a healthy cap rate for a long-term rental in 2026 generally lands between 5% and 8%, with multifamily across all classes averaging about 5.6% in the first quarter of the year. Lower is not automatically bad in a strong appreciation market, but you should know what you are trading.
4. Cash flow
Cash flow is what is left each month after the mortgage and every expense are paid. This is the number that keeps you solvent when a furnace dies or a tenant leaves. Thin cash flow is fragile cash flow, and the same discipline that protects a small business protects a landlord. The 5 cash flow mistakes that quietly kill small businesses apply almost word for word to a rental portfolio: underestimating costs, ignoring reserves, and confusing revenue with profit.
5. Cash-on-cash return
Cash-on-cash return is annual pre-tax cash flow divided by the actual cash you invested: down payment, closing costs, and any upfront repairs. It answers the real question, which is what your money earns, not what the building earns. A 6% cap rate can still produce a weak cash-on-cash return once financing is layered on. We walk through the full calculation in Cash-on-Cash Return Explained.
6. Debt service and your financing reality
Your mortgage terms can make or break an otherwise solid deal. Investment property loans typically price above owner-occupied rates, and with the 30-year fixed averaging in the mid-6% range in mid-2026 per Freddie Mac, a quarter-point swing changes your monthly payment and your cash flow more than most buyers expect. Always run the analysis at the rate you will actually be quoted, not the headline rate.
A Step-by-Step Rental Property Analysis Walkthrough
Numbers make this concrete. Here is a full rental property analysis on a realistic 2026 deal.
The property: a single-family rental listed at $320,000. You put 25% down ($80,000), finance $240,000 at 7% on a 30-year fixed, and estimate $8,000 in closing costs. Market rent is $2,600 a month.
Step 1, gross annual rent: $2,600 x 12 = $31,200.
Step 2, the 1% check: 1% of $320,000 is $3,200. Rent of $2,600 falls short, so this is not a slam-dunk on rent alone. Keep going.
Step 3, operating expenses: property taxes $3,000, insurance $1,500, maintenance $1,600, vacancy at 5% ($1,560), property management at 8% ($2,496), and a CapEx reserve of $1,500. Total operating expenses: $11,656. That is 37% of gross rent, a little under the 50% rule, which is plausible for a newer single-family home but worth pressure-testing.
Step 4, NOI: $31,200 minus $11,656 = $19,544.
Step 5, cap rate: $19,544 divided by $320,000 = 6.1%. Right in the healthy range.
Step 6, debt service: $240,000 at 7% over 30 years is about $1,597 a month, or $19,164 a year.
Step 7, annual cash flow: $19,544 NOI minus $19,164 debt service = $380 a year, roughly $32 a month.
Step 8, cash-on-cash return: $380 divided by $88,000 invested ($80,000 down plus $8,000 closing) = 0.4%.
Here is the lesson. The property has a respectable 6.1% cap rate and still produces almost no cash flow, because financing absorbs nearly all of the NOI. A clean cap rate hid a thin deal. You would need a lower price, a larger down payment, higher rent, or a better rate to make this work. That gap is invisible until you run all six numbers, which is the entire point of doing the analysis.
The Mistakes That Wreck a Rental Property Analysis
Most bad deals trace back to the same handful of errors: trusting a seller’s rent and expense figures, omitting CapEx and vacancy, forgetting that out-of-state markets carry costs you cannot see from a listing, and overlooking the tax side of the return. On taxes alone, investors routinely leave money on the table, as we cover in 9 Landlord Tax Deductions Most Investors Miss and, for remote deals, 6 Out-of-State Rental Property Mistakes. For a deeper look at the analysis errors themselves, see How to Run the Numbers on a Rental Property.
Your Rental Property Analysis Checklist
Run this sequence on every deal before you make an offer:
- Confirm realistic market rent from comparable units, not the listing’s projection.
- Apply the 1% rule as a first filter, then keep analyzing regardless of the result.
- Build a full operating expense list, including vacancy and a CapEx reserve.
- Calculate NOI, then cap rate, to judge the price independent of financing.
- Layer in your actual quoted loan terms and compute monthly cash flow.
- Finish with cash-on-cash return to see what your invested dollars truly earn.
- Stress-test the deal: what happens at 8% vacancy, a rate 0.5% higher, or rent $150 lower?
Run Your Next Deal With Confidence
Rental property analysis is a repeatable process, not a gut feeling. Once you have the six numbers and a checklist, every listing becomes a quick yes or no instead of a guess. If you want the math done for you, our ready-made rental property spreadsheet templates calculate cap rate, cash flow, and cash-on-cash automatically, and the free real estate calculators are a fast place to start.
Want a second set of eyes on a specific deal? Book a free 20-minute consultation or learn more about real estate investing coaching, and we will run the numbers together before you commit a dollar.
About Simply Spreadsheets: Led by fractional CFO Erin Onsager, Simply Spreadsheets helps real estate investors and small business owners turn messy numbers into clear decisions. From rental property analysis and deal modeling to fractional CFO services, we build the financial tools that make growth measurable.
Simply Spreadsheets 
Leave a comment