Home › Templates › Analysis Calculator
Rental Property Analysis Calculator
Know what a rental will earn before you make an offer.
Enter up to 5 deals. You'll see the cash you need, monthly cash flow and the return ratios lenders and investors use, all side by side.
- Excel
- Google Sheets
- Instant download
$19
Up to 5 deals · Buy & hold, BRRRR, STR · Excel & Google Sheets
Gumroad: secure checkout, instant download link by email. Etsy: download from You › Purchases.
What's inside
- Dashboard: 6 headline figures, a comparison table and 4 charts
- Three strategies per deal: Buy & hold, BRRRR (holding costs, cash-out refinance, cash left in) and short-term rental (nightly rate, occupancy, cleaning, platform fees, furnishing)
- Returns: cash-on-cash, cap rate, return on cost, DSCR, break-even ratio, 1% rule, GRM, equity
- 10-year projection: with IRR, equity multiple and profit if sold
- What-If grids: for rent, interest rate and cost changes
- Rehab budget: per deal, with contingency
- Your own targets: with a check showing how many each deal meets
You get: The calculator with 4 made-up sample deals, a blank copy, and a 9-page PDF guide.
Works in: Microsoft Excel 2010+ (desktop or web) and Google Sheets.
Screenshots from the real file
Frequently asked questions
Which strategies does it cover?
Buy & hold (long-term rentals), BRRRR (buy, rehab, rent, refinance, repeat) and short-term or vacation rentals. You pick the strategy per deal.
Can I analyse a cash purchase?
Yes. Set the down payment to 100%. The loan payment becomes $0 and DSCR shows "No loan".
Does it tell me whether to buy a property?
No. It calculates the numbers from your own assumptions and compares them with targets you set. It is not financial advice.
Can I compare more than 5 deals?
Make a copy of the file for the next group of deals.
Does it work in Google Sheets?
Yes. Upload the .xlsx file to Google Drive and open it with Google Sheets (File › Save as Google Sheets). Formulas, dropdowns and highlights work. Charts may look slightly different, and you may want to re-apply sheet protection (right-click a tab › Protect sheet).
Which version of Excel do I need?
Excel 2010 or newer, on Windows, Mac or the web. There are no macros or add-ons. Apple Numbers is not supported.
How do I get the files?
Right after payment, Gumroad shows a download page and emails you a link. On Etsy, go to You › Purchases and reviews › Download Files.
Can I use another currency?
Yes. Amounts display in $, but the math works for any currency.
Can I get a refund?
Because these are digital downloads, refunds aren't usually offered. If something doesn't work, email us and we'll help you get it working.
Can I share or resell the files?
They're licensed for your personal use with your own properties. Please don't resell or share them.
Calculation tool, not financial, investment, tax or legal advice. Results are estimates based on your own assumptions. Not affiliated with Airbnb or any booking platform. Personal-use licence; please don't resell or share the files. Made by Spruce Sheets with the help of AI tools; every formula was tested before release.
Related guides
You might also need
Landlord Bundle
Analyse a rental before you buy. Keep the books once you own it.
2 workbooks · Analyse deals, then keep the books · Excel & Google Sheets
$29 $38
Landlord Complete Bundle
Analyse it. Collect the rent. Keep the books through tax time.
3 workbooks · Analyse, collect rent, keep the books · Excel & Google Sheets
$39 $55
Rental Property Bookkeeping Spreadsheet
Know exactly what each rental earns, without accounting software.
Up to 10 properties · Excel & Google Sheets · Instant download
$19