Rental Property ROI & Cash Flow Calculator Spreadsheet

Every experienced real estate investor has a story about the deal that “looked great on paper” until the numbers were run properly. The listing advertised an 8% cap rate. The agent pointed to the gross rent multiplier. The seller’s proforma showed strong cash flow. Then the buyer ran their own analysis — accounting for actual operating expenses, vacancy, capex reserves, and realistic financing terms — and the deal fell apart.

The distance between a seller’s proforma and an honest buyer’s analysis is where most bad deals live. A seller’s numbers assume full occupancy, minimal maintenance, and below-market expenses. A buyer’s spreadsheet must assume reality: vacancy happens, roofs need replacing, property management takes a percentage, and insurance premiums in 2026 are significantly higher than whatever the seller paid three years ago.

This spreadsheet is built for the buyer’s side of the table. It calculates every metric that matters — cap rate, cash-on-cash return, NOI, cash flow, and GRM — using conservative assumptions and your actual financing terms. It includes renovation cost modelling for value-add plays and a BRRRR analysis section for investors using the Buy, Rehab, Rent, Refinance, Repeat strategy.

Disclaimer: This calculator is provided for informational and educational purposes only. It does not constitute financial or investment advice. Real estate investments carry significant risk, including potential loss of capital. Consult a qualified financial advisor or real estate professional before making investment decisions. SpreadsheetTemplates.info is not responsible for decisions made based on the information provided.

Why Most Online ROI Calculators Are Inadequate#

The rental property calculators you find through a web search typically suffer from three problems that make them unreliable for actual investment decisions.

They Underestimate Operating Expenses#

Most online calculators ask for a few expense line items — property taxes, insurance, maybe property management — and call it done. They omit or underestimate vacancy, maintenance reserves, capital expenditure reserves, landscaping, pest control, HOA fees, legal/accounting costs, and the dozens of smaller expenses that erode gross rent.

The industry shorthand is the 50% Rule: over time, operating expenses (excluding debt service) tend to consume approximately 50% of gross rental income. This is not a precise figure for any individual property, but it is a reliable screening tool. If a deal does not cash flow at the 50% expense ratio, it almost certainly will not cash flow at actual expenses either.

This spreadsheet uses the 50% Rule as a quick-screening default while also allowing you to input detailed line-item expenses for a precise analysis.

They Ignore Capex Reserves#

A roof lasts 20–25 years. An HVAC system lasts 15–20 years. A water heater lasts 10–12 years. These are not “if” expenses — they are “when” expenses. If you do not reserve for them monthly, a single capital expenditure can wipe out years of positive cash flow in a single quarter.

The spreadsheet includes a capex reserve calculation based on the estimated remaining useful life of major systems (roof, HVAC, water heater, appliances, flooring, exterior paint). You enter the age of each system and the estimated replacement cost, and the tool calculates the monthly reserve needed to fund replacements without dipping into cash flow.

They Do Not Model Financing Accurately#

Cap rate is a useful screening metric, but it assumes an all-cash purchase. Most investors use leverage. The metric that matters for leveraged returns is cash-on-cash return — the annual pre-tax cash flow divided by total cash invested. The same property can have a 7% cap rate but a 12% cash-on-cash return with favourable leverage, or a 3% cash-on-cash return with unfavourable financing terms.

The spreadsheet models your specific financing: down payment percentage, interest rate, loan term, closing costs, and points. It then calculates cash-on-cash return based on your actual equity investment.

What the Spreadsheet Calculates#

Acquisition Analysis#

You enter the purchase price, closing costs (estimated or actual), any inspection or due diligence costs, and renovation/rehab budget if applicable. The tool calculates total acquisition cost — the real denominator for your return calculations.

Income Modelling#

Enter gross monthly rent (or projected rent for a vacant/value-add property), other income (laundry, parking, storage, pet fees), and your assumed vacancy rate. The default vacancy rate is 8% (roughly one month per year), which can be adjusted for your specific market. The spreadsheet calculates effective gross income after vacancy and other income adjustments.

Operating Expense Detail#

The spreadsheet provides line-item inputs for property taxes, insurance, property management fees (typically 8–12% of collected rent), maintenance and repairs, capex reserves, utilities (if landlord-paid), landscaping and lawn care, pest control, HOA or condo fees, legal and accounting, advertising and leasing costs, and a miscellaneous/contingency line. It also shows the 50% Rule estimate for comparison, so you can see whether your itemised expenses are above or below the industry benchmark.

Return Metrics#

The spreadsheet produces every standard return metric:

Net Operating Income (NOI): Effective gross income minus total operating expenses (excluding debt service). This is the fundamental measure of a property’s earning power independent of financing.

Cap Rate: NOI divided by purchase price (or current market value for existing holdings). A good cap rate in 2026 typically falls between 4–7% in major metro areas and 6–10% in secondary markets, depending on property type and condition.

Cash Flow: NOI minus annual debt service. This is the actual money in your pocket each month after all expenses and mortgage payments.

Cash-on-Cash Return: Annual pre-tax cash flow divided by total cash invested (down payment + closing costs + rehab costs). This is the metric that tells you what your equity is earning. Most investors target 8–12% cash-on-cash, though acceptable returns vary by market and strategy.

Gross Rent Multiplier (GRM): Purchase price divided by annual gross rent. A lower GRM indicates a better income-to-price ratio. GRM is a fast screening tool — not a replacement for full analysis, but useful for quickly comparing deals in the same market.

Total ROI (Annualised): Incorporates cash flow, principal paydown through mortgage amortisation, and estimated appreciation. This is the most complete return metric but also the most assumption-dependent (appreciation is speculative).

BRRRR Analysis Section#

For investors using the Buy, Rehab, Rent, Refinance, Repeat strategy, the spreadsheet includes a dedicated BRRRR section. You enter the purchase price, rehab budget, after-repair value (ARV), refinance loan-to-value ratio (typically 70–75% of ARV), and refinance interest rate. The tool calculates how much cash you recover through the refinance, your remaining equity in the deal, and the cash-on-cash return based on money left in the deal after refinance — not the original acquisition cost.

How to Use the Spreadsheet#

Step 1: Screen with the 50% Rule. Before investing time in a detailed analysis, run the quick screen. If the property’s gross monthly rent, multiplied by 0.5, minus the estimated monthly mortgage payment, produces a negative number or near-zero cash flow, the deal is unlikely to work. Move on.

Step 2: Enter acquisition details. Purchase price, estimated closing costs (budget 2–3% for investor loans), and any planned renovation costs.

Step 3: Enter income and expenses. Use actual rents (from the seller’s rent rolls or current lease agreements) or market-rate estimates from Zillow Rental Manager, Rentometer, or comparable listings. Enter each expense line item. If you do not have property-specific data, use the 50% Rule default and refine as you gather information during due diligence.

Step 4: Enter financing terms. Down payment percentage (typically 20–25% for investment properties), interest rate (currently 7–8% for investor loans in April 2026), and loan term. The spreadsheet calculates your monthly debt service.

Step 5: Review the metrics. Focus on cash-on-cash return (your equity’s earnings rate), monthly cash flow (does the property pay you or cost you each month?), and cap rate (how does this property compare to others in the market?). If the numbers work, proceed with due diligence. If they do not, walk away.

Download: Rental Property ROI Calculator — Excel (.xlsx)

Key Metrics at a Glance#

Understanding what each metric tells you — and what it does not — prevents the most common analytical mistakes.

Cap rate tells you the property’s income yield independent of financing. It is useful for comparing properties but says nothing about your leveraged return. A 6% cap rate property might deliver 10%+ cash-on-cash return with favourable leverage.

Cash-on-cash return tells you what your invested cash is earning annually. This is the most relevant metric for leveraged investors. It accounts for financing but not appreciation or principal paydown.

Monthly cash flow is the practical measure. It answers the question: does this property put money in my pocket each month, or does it require me to feed it from other income? Negative cash flow is not always a deal-breaker (in high-appreciation markets, some investors accept it), but it requires a deliberate strategy and sufficient reserves.

GRM is a screening shortcut. It cannot tell you whether a deal is good, but it can tell you quickly whether a deal is worth analysing further. In most markets, a GRM below 10 warrants a closer look; above 15 suggests the property is priced for appreciation, not income.

The Five Most Common Analytical Mistakes#

Spreadsheets only produce accurate results if the inputs are honest. These are the mistakes that turn a profitable-looking deal into a money-losing one.

Using the seller’s expense numbers without verification. The seller’s proforma is a marketing document, not a financial statement. Property taxes may be based on an outdated assessment that will reset to the purchase price. Insurance costs from two years ago may be 30–40% below current rates. Management expenses may assume self-management. Always build your own expense estimate from scratch.

Ignoring vacancy. A property that generates $2,000/month in gross rent generates $2,000/month only if it is occupied every day. Budget for vacancy — 5% in a strong market, 8% in a normal market, 10%+ in a weak market. That 8% vacancy assumption on a $2,000/month property costs $160/month or $1,920/year. Ignoring it makes every return metric artificially high.

Omitting capex reserves. The roof will need replacing. The HVAC will fail. The water heater will die. These are certainties, not risks. If you do not reserve monthly for future capital expenditures, a single replacement can consume years of accumulated cash flow. Budget $100–$200/month per unit.

Using a mortgage payment calculator instead of a full analysis. A mortgage calculator tells you the P&I payment. It does not tell you whether the property is a good investment. The P&I payment is one line item among many. Without modelling all operating expenses, the mortgage payment is meaningless for investment analysis.

Conflating cap rate with return. A 7% cap rate does not mean you earn 7% on your money. It means the property earns 7% on its total value — as if purchased in cash. Your actual return depends on how you finance the purchase and how leverage affects the net income flowing to your equity.

The 2026 Rental Market Context#

Several factors are shaping rental property investment decisions this year.

Mortgage rates for investment properties remain elevated at 7–8% for 30-year fixed loans, significantly higher than owner-occupied rates. This compresses cash flow and makes cash-on-cash return harder to achieve. Properties that cash-flowed comfortably at 4–5% investor rates in 2020–2021 may break even or run negative at current rates.

Cap rates nationally sit between 4–7% for residential rental properties in most markets, though secondary and tertiary markets may offer 6–8%+. The compression of cap rates in major metros — driven by high demand and institutional competition — means that income-focused investors are finding better opportunities in mid-size cities and suburban markets.

Insurance costs have risen dramatically and are a frequently underestimated expense in rental property analysis. If you are relying on the seller’s insurance costs from two years ago, your actual expense is likely 20–40% higher. Use our home insurance comparison spreadsheet to get accurate quotes before finalising your analysis.

For investors evaluating whether to refinance existing properties at current rates, our mortgage refinance calculator models the break-even point. And for a comprehensive overview of all the real estate analysis tools available on this site, see our complete guide to real estate investment spreadsheet tools.

Frequently Asked Questions#

What is a good cash-on-cash return for a rental property?

Most investors target 8–12% cash-on-cash return. In the current high-rate environment, achieving 8%+ is more difficult than it was in 2020–2021. Some investors accept 6–7% in strong-appreciation markets where they expect significant value growth to supplement income returns. Below 6%, the risk-adjusted return may not justify the illiquidity and effort of real estate compared to passive investments.

How accurate is the 50% Rule?

Surprisingly accurate as a long-term average, though individual properties vary. Newer properties in good condition with low property taxes may run at 35–40% expenses. Older properties, high-tax jurisdictions, and properties with landlord-paid utilities can exceed 60%. The 50% Rule is a screening tool, not a substitute for line-item analysis. Use it to quickly discard bad deals, then verify good deals with detailed numbers.

Should I include my own management time as an expense?

If you self-manage, it is worth modelling the deal both ways: with and without a management fee. Self-management saves 8–12% of collected rent but costs you time and effort. If you would not buy the property with a management fee included, it only “works” because you are subsidising it with unpaid labour. That is a valid choice, but it should be a conscious one.

How do I estimate renovation costs for a value-add deal?

Get contractor bids during the due diligence period before closing. For initial screening, budget $15–$30 per square foot for cosmetic renovations (paint, flooring, fixtures, appliances) and $40–$75+ per square foot for more extensive work (kitchen and bathroom remodels, structural repairs). Always add a 15–20% contingency for unexpected issues — they are not unexpected if you plan for them.

What vacancy rate should I assume?

In strong rental markets, 5% (roughly 2.5 weeks vacant per year) is reasonable. In average markets, 8% is a standard assumption. In weaker markets or for less desirable properties, 10–12% may be appropriate. Check your local market’s current vacancy rate data (available through the Census Bureau’s Housing Vacancy Survey or local MLS data) and use the higher of the market rate or your conservative estimate.

How does the BRRRR strategy change the return calculation?

BRRRR dramatically changes cash-on-cash return because it reduces (sometimes eliminates) the cash left in the deal. If you buy for $150,000, rehab for $30,000, achieve an ARV of $250,000, and refinance at 75% LTV ($187,500 loan), you recover $7,500 more than your total investment. Your cash-on-cash return becomes theoretically infinite because your money is no longer in the deal. The spreadsheet models this correctly, using money-left-in-deal as the denominator.

Should I use current market value or purchase price for the cap rate?

For acquisition analysis, use the purchase price — this tells you the return you are buying. For ongoing portfolio evaluation, use current market value — this tells you the return your equity is earning, which matters for deciding whether to hold or sell.

How do I account for property tax reassessment after purchase?

Many jurisdictions reassess property taxes based on the sale price. If the property has not sold in years, the current tax bill may be based on an outdated assessment. Budget for reassessment by checking your jurisdiction’s tax rate and applying it to your purchase price. This is one of the most commonly missed expenses in rental property analysis.