Real Estate Rental Property ROI & Cash Flow Analyzer
Rental Property ROI Calculator Excel with cash flow analysis, cap rate, cash-on-cash return, and a 5-year projection. Run the numbers before you buy — and compare 3 properties side by side. Built for real estate…
About this template
Rental Property ROI Calculator Excel with cash flow analysis, cap rate, cash-on-cash return, and a 5-year projection. Run the numbers before you buy — and compare 3 properties side by side. Built for real estate investors who want to know, before they make an offer, whether the rent covers the mortgage and which deal is actually the best one.
$49
Excel & Google Sheets template — instant download on Etsy
Property Inputs — enter purchase price, down payment, loan rate and term, closing costs, rehab, rent, vacancy, taxes, insurance, HOA, maintenance, management, utilities, and other costs for up to 3 properties. Loan amount, monthly mortgage, and total cash invested are calculated for you.
Cash Flow — monthly and annual effective gross income, operating expenses, net operating income, mortgage, and net cash flow, plus cash-on-cash return. It flags any property with negative cash flow.
ROI & Returns — cap rate, cash-on-cash, Year 1 principal paydown, appreciation, and total ROI, which counts cash flow plus principal paydown plus appreciation. Includes 1 percent and 2 percent rule checks and break-even rent.
Comparison — purchase price, cash invested, rent, cash flow, cash-on-cash, cap rate, total ROI, and break-even rent for all 3 properties, ranked by monthly cash flow and by cash-on-cash, with the best pick named.
5-Year Projection — Year 1 to Year 5 rent growth, expense growth, appreciation, loan balance, equity, and cumulative cash flow for each property, with a Year 5 summary.
Cover & How to Use — start here. Yellow cells are the only ones you edit.
Quick profit check — Real Estate Rental Property ROI & Cash Flow Analyzer
Try the headline numbers for a typical month. The full template does this job by job with a monthly P&L and dashboard.
Frequently asked questions
What does the Real Estate Rental Property ROI & Cash Flow Analyzer track?
The Real Estate Rental Property ROI & Cash Flow Analyzer tracks Property Inputs; Cash Flow; ROI & Returns; Comparison; 5-Year Projection.
What do the example numbers show?
The included example shows: Property A, Phoenix single-family home: purchase 360,000, rent 2,950 per month, monthly net cash flow 294.06, cash-on-cash 3.3 percent, cap rate 6.5 percent, break-even rent 2,612.00.
Does it work in Excel and Google Sheets?
Yes. The workbook works in Microsoft Excel and in Google Sheets (upload the .xlsx file to Google Drive to open it in Sheets). It is an instant digital download from Etsy — no physical item is shipped.