Rental Property ROI Calculator
Cap rateCash-on-cashNOIDSCR5-year return
Run the numbers before you make an offer. Cap rate, cash-on-cash return, NOI, DSCR, monthly cash flow and a 5-year total return for rentals up…
$24Excel + Google Sheets
Home / Templates / Real Estate
Real Estate · Excel + Google Sheets
BRRRR Deal Analyzer
Buy, rehab, rent, refinance, repeat. See how much cash you need, how much comes back at the refinance and how much stays in the deal, with hard money costs, a rehab budget and what-if tables.
What's inside
- Purchase, hard money or private loan, points and holding costs
- Rehab budget with quantities, unit costs and contingency
- Cash-out refinance at your LTV, rate and closing costs
- Cash left in the deal, cash-on-cash return and DSCR after the refi
- 70% rule check for your maximum offer
- What-if tables for ARV, rehab cost, rent and interest rate
Real screenshots
Try the free brrrr calculator
Run a quick version in your browser, then get the template for the full analysis.
Questions
Does it work in Google Sheets?
Yes. Your download includes the Excel file and a PDF with a link that makes your own private Google Sheets copy in one click. Both versions work the same way.
Which version of Excel do I need?
Excel 2016 or later on Windows or Mac, or Excel for the web. No macros, add-ins or subscriptions are needed.
How do I get it after I buy?
You check out on Etsy and download the files right away from your Etsy purchases page. Etsy also emails you the download link.
Is there a Spanish version?
Yes. Análisis BRRRR y Refinanciamiento is the same template, fully in Spanish.
Is this financial advice?
No. The template is an educational tool that organizes and calculates your own numbers.
More real estate templates
Landlord Income and Expense Tracker
Rent roll1,000-row ledgerSchedule E10 properties
Log rent and expenses for up to 10 rental properties in one ledger. The dashboard shows income vs. expenses by month, and the Schedule E summary…
$19Excel + Google Sheets