Real Estate & Landlords
Rental Property ROI Calculator
Enter a property's price, rent and costs to see cap rate, cash-on-cash return and monthly cash flow.
- Delivery
- Instant download
- Purchase
- One-time payment
- Format
- Google Sheets
- Excel
- Updated
- August 2026
Cash-on-cash return
0.9%
Monthly cash flow
$47
- Purchase price$285,000
- Monthly rent$2,300
- Cap rate6.4%
Sample data preview of the Rental Property ROI Calculator spreadsheet, shown for illustration only.
What this spreadsheet does
Comparing rental deals by gut feel misses how financing, taxes and vacancy actually change the real return.
What you can do with it
- Decide whether a listed property meets your return target
- Compare cap rate across multiple properties
- Model how a different down payment changes cash-on-cash return
What's included
Sheet tabs
- Instructions
- Deal Summary
- Cash Flow
- Compare Properties
Features
- Purchase price, financing and closing cost inputs
- Automatic cap rate and cash-on-cash return calculation
- Monthly cash flow projection including vacancy allowance
- Side-by-side comparison for up to 3 properties
How it works
- 1Enter purchase price, financing terms and expected rent
- 2Add operating costs and a vacancy allowance
- 3Review cap rate, cash-on-cash return and monthly cash flow
Who it's for
Investors evaluating a rental property purchase.
This spreadsheet is a planning tool and does not replace professional financial or investment advice.
Frequently asked questions
Does this account for financing?
Yes. Down payment, interest rate and loan term all feed into the cash-on-cash return and monthly cash flow.
Can I compare more than one property?
The Compare Properties tab holds three properties side by side. Duplicate the tab for more.
What's the difference between cap rate and cash-on-cash return?
Cap rate measures return based on the full purchase price. Cash-on-cash return measures return based on the actual cash you invested, including financing.
You might also need
Rental Property Income & Expense Tracker
Log rent collected and expenses paid across your properties.
- Google Sheets
- Excel
Property Comparison Spreadsheet
Compare price, condition and return across multiple listings.
- Google Sheets
- Excel
Tenant Screening & Application Log
Track every rental applicant's screening status and income-to-rent ratio in one log.
- Google Sheets
- Excel
Landlord Maintenance Tracker
Log repair requests, status and cost for every unit.
- Google Sheets
- Excel