$14.50$29 · Google Sheets + Excel · Instant download
Analyze any rental property before you buy it. Enter the price, rent, loan terms and expenses, and the analyzer calculates cash flow, cap rate, cash-on-cash return and the 1% rule check. Compare up to five properties side by side to find the best deal.
What's inside
Cash flow, cap rate and cash-on-cash return
Mortgage and closing cost calculator
Vacancy, repairs and capital expense reserves
5-property side-by-side comparison
10-year equity and appreciation projection
Google Sheets and Excel
Perfect for
New real estate investors
House hackers and BRRRR investors
Agents who serve investor clients
Who Rental Property Investment Analyzer is for
For new and experienced real estate investors comparing rental properties, house hacks or short-term rentals. If you want to know whether a property cash flows before you make an offer, this analyzer runs the numbers in minutes.
How to use it in 4 steps
Enter the purchase price, down payment, interest rate and closing costs.
Add expected rent, vacancy rate and monthly expenses.
Review cash flow, cap rate and cash-on-cash return.
Duplicate the tab to compare several properties side by side.
Format and compatibility
You get a Google Sheets link to make your own copy and an .xlsx file for Microsoft Excel. Both versions have the same tabs and formulas. Sheets works free in any browser and in the Google Sheets app on iPhone and Android, so you can update it from anywhere. Excel works on Windows and Mac.