The Rental ROI Calculator is a comprehensive Excel spreadsheet designed for real estate investors to analyze potential rental property investments. Calculate your expected returns before you buy, compare multiple properties side by side, and understand your true cash flow after all expenses. This free rental property ROI calculator helps you make data-driven investment decisions by breaking down every aspect of rental property profitability—from cash-on-cash return to cap rate analysis.
What's included
- Cash-on-cash return calculation with detailed breakdown
- Cap rate analysis for property valuation
- Monthly and annual cash flow projections
- Complete expense breakdown (taxes, insurance, maintenance, vacancy)
- Built-in mortgage payment calculator with amortization
- Multiple property comparison side-by-side
- Sensitivity analysis for different rent and expense scenarios
- Break-even analysis and payback period calculation
What is ROI in Real Estate Investing?
Return on Investment (ROI) in real estate measures how much profit you make relative to your investment. Unlike stocks where ROI is straightforward, rental property ROI involves multiple metrics: cash-on-cash return (annual cash flow divided by cash invested), cap rate (property income relative to value), and total ROI (including appreciation and principal paydown). The rental ROI calculator helps you understand all three metrics so you can compare properties accurately and make informed investment decisions.
ROI vs Cash Flow vs Cap Rate: What's the Difference?
Cash-on-cash return measures your actual cash profit relative to the cash you invested—it's the most relevant metric for leveraged investors. Cap rate ignores financing and shows how the property performs relative to its price—useful for comparing properties across markets. Monthly cash flow is the actual dollars hitting your bank account after all expenses. Our rental ROI calculator computes all three so you can see the complete picture. Pro investors typically target 8-12% cash-on-cash return, 5-8% cap rates in stable markets, and positive monthly cash flow of at least $200/door.
The Complete Rental ROI Formula Explained
To calculate rental property ROI accurately, start with gross rental income. Subtract vacancy allowance (typically 5-8%), property management (8-10%), maintenance reserves (1-2% of property value annually), property taxes, insurance, HOA fees, and your mortgage payment. The remaining amount is your monthly cash flow. Multiply by 12 for annual cash flow, then divide by your total cash invested (down payment + closing costs + initial repairs). This gives you your cash-on-cash return—the most important ROI metric for rental investors.
Common Rental ROI Calculation Mistakes
The biggest mistake new investors make is underestimating expenses. They calculate rent minus mortgage and call it 'cash flow.' Real cash flow must account for vacancy, repairs, capital expenditures, property management, and reserves. Another common error is ignoring the opportunity cost of your down payment—that money could earn returns elsewhere. Our rental ROI calculator automatically includes all expense categories so you get realistic numbers, not rosy projections that fall apart in year one.
Key formulas
ROI (Cash-on-Cash Return) Formula: Cash-on-Cash Return = (Annual Pre-Tax Cash Flow / Total Cash Invested) × 100 Example: $6,000 annual cash flow ÷ $50,000 invested = 12% CoC return Cap Rate Formula: Cap Rate = (Net Operating Income / Property Value) × 100 Example: $12,000 NOI ÷ $150,000 value = 8% cap rate Monthly Cash Flow Formula: Monthly Cash Flow = Gross Rent - (PITI + Operating Expenses) Where PITI = Principal + Interest + Taxes + Insurance
Real Example: Analyzing a $200K Rental Property
- Purchase Price: $200,000 with 20% down ($40,000 + $5,000 closing costs = $45,000 cash invested)
- Monthly Rent: $1,800 → Annual Gross Income: $21,600
- Vacancy Allowance (5%): -$1,080 → Effective Gross Income: $20,520
- Operating Expenses: Property Tax ($2,400), Insurance ($1,200), Management 8% ($1,728), Maintenance ($2,400), CapEx Reserve ($1,200) = $8,928 total
- Net Operating Income (NOI): $20,520 - $8,928 = $11,592
- Mortgage Payment (30yr @ 7%): $1,064/month = $12,768/year
- Annual Cash Flow: $11,592 - $12,768 = -$1,176 (negative!)
Cash-on-Cash Return: -2.6% | Cap Rate: 5.8% | This deal doesn't work at current terms. Need to negotiate price down or find higher rent.
Frequently Asked Questions
What is a good rental ROI?
A good cash-on-cash return for rental properties is typically 8-12% in most markets. However, this varies by location—investors in appreciation-focused markets like California might accept 4-6%, while cash flow markets like the Midwest can yield 10-15%. Cap rates of 5-8% are considered healthy for single-family rentals. The key is ensuring positive cash flow after all expenses.
What expenses should I include in rental ROI calculation?
Include all operating expenses: property taxes, insurance, property management (8-10% of rent even if self-managing), maintenance (1-2% of property value), vacancy allowance (5-10%), CapEx reserves for major repairs (5-10%), HOA fees, lawn care, and any utilities you pay. Don't forget to include your mortgage payment (PITI) when calculating cash flow. Our rental ROI calculator includes all these categories automatically.
How do I use this rental ROI calculator?
Download the Excel file and enter your property details: purchase price, expected rent, down payment percentage, interest rate, and estimated expenses by category. The calculator automatically computes your cash-on-cash return, cap rate, monthly cash flow, and break-even analysis. Use the comparison tab to analyze multiple properties side by side.
What's the difference between ROI and cash-on-cash return?
Total ROI includes all returns: cash flow, appreciation, principal paydown, and tax benefits. Cash-on-cash return only measures annual cash flow divided by cash invested—it's a pure measure of your money working for you. Most investors focus on cash-on-cash return because it's tangible and predictable, while appreciation is speculative.
Should I include appreciation in ROI calculations?
For conservative analysis, calculate ROI without appreciation—this shows you whether the property cash flows on its own. Appreciation is a bonus, not a guarantee. However, for total return projections over 5-10 years, you can model 2-4% annual appreciation in strong markets. Our calculator focuses on cash flow metrics but you can add appreciation assumptions in the advanced section.
Educational tool only — results are hypothetical projections from your assumptions, not financial, tax, legal or investment advice.