1 / 14
Tap any image to enlarge, then swipe or use the arrows to page through every sheet.
What this does that other real-estate spreadsheets do not: it puts every strategy in a single file. Most templates analyze one thing — a rental, or a flip, or an Airbnb — and you buy three separate files or a $12–15/month app to cover them all. This workbook runs buy-and-hold, BRRRR/refinance, fix-and-flip and short-term rental side by side, off the same inputs, so you can compare what a property does as a rental versus a flip versus an Airbnb before you make an offer.
The buy-and-hold analyzer is complete: purchase price, closing and rehab, your loan, rents and every operating expense roll up into NOI, annual cash flow, cap rate, cash-on-cash, DSCR, GRM and the 1% rule, plus the maximum offer to hit a target return. Financing carries the full amortization schedule with extra-payment support, and the Projection sheet forecasts cash flow and equity year by year, then the sale, and returns the deal IRR, MIRR, NPV and the equity multiple — the numbers cheap templates leave out.
For the other strategies: Fix & Flip applies the 70% rule, your rehab, holding and selling costs and shows net profit and ROI with a clear AT/UNDER-MAO or OVER-MAO verdict; the Airbnb/STR analyzer turns ADR and occupancy into revenue, RevPAR and a P&L, and tells you the break-even occupancy you must hold to cover costs — a figure hosts ask for and templates rarely compute. A Bookkeeping sheet logs income and expenses to Schedule-E categories with real straight-line depreciation for your accountant, a two-way Sensitivity table shows what cash flow does as the rate and rent move, and the Dashboard ties the headline returns together.
Built for Excel 2016+ and Google Sheets with classic, compatible functions only (PMT, IRR, NPV, SUMIFS, depreciation) — no macros, no add-ons, nothing locked. Any currency (numbers carry no symbol). A real, fictional $250k rental is filled in so every number and chart is alive on first open; clear the yellow cells and it is yours. Every headline figure in this listing was measured from the built file, recalculated by LibreOffice and checked against an independent financial model.
What you get
- Four strategies in ONE file: buy-and-hold, BRRRR/refinance, fix-and-flip, Airbnb/STR — no competitor combines them
- Cap rate, cash-on-cash, NOI, DSCR, GRM, 1% rule and max-allowable-offer on the buy-and-hold analyzer
- Full loan amortization to payoff; 30-year projection with cash flow, equity, IRR, MIRR, NPV and the equity multiple
- Fix & Flip: 70% rule, MAO, rehab + holding + selling costs, net profit and ROI; BRRRR cash-out refinance
- Airbnb/STR: ADR, occupancy, RevPAR, a P&L and the break-even occupancy
- Schedule-E bookkeeping with straight-line depreciation; two-way sensitivity table (rate × rent)
- 12 sheets, hundreds of live formulas; dashboard with a projection chart
- Any currency · no macros · Excel 2016+ and Google Sheets · instant download
- Recalculated by LibreOffice and checked against an independent model — 0 errors
Preview every page
Click any page to zoom.
What's inside
Questions
How is this different from a free rental calculator?
Free calculators do one strategy and stop at cash-on-cash. This file does buy-and-hold, BRRRR, fix-and-flip and Airbnb in one place, adds the full amortization, a 30-year IRR/NPV projection, Schedule-E depreciation and a sensitivity table — the parts investors actually need to decide, that free tools and most paid templates leave out.
Does it work in Google Sheets?
Yes. Upload the .xlsx to Google Drive and choose File → Save as Google Sheets. PMT, IRR, NPV, SUMIFS and the depreciation math are all Sheets-compatible. A short PDF walks you through it.
Which currency does it use?
Any. Numbers carry no currency symbol, so it works in any country — format the money columns to your currency if you like.
Can it analyze a short-term rental (Airbnb)?
Yes. The Airbnb STR sheet turns your average daily rate and occupancy into revenue, RevPAR, a P&L and the break-even occupancy you need to cover costs.
Does it handle a fix-and-flip?
Yes. Fix & Flip applies the 70% rule, computes the maximum allowable offer, totals rehab, holding and selling costs, and shows net profit and ROI with an AT/UNDER-MAO verdict.
Is anything locked or macro-based?
No. No macros, no protected sheets, no external links. Blue-on-yellow cells are your inputs; black cells are formulas.
Business license for use in your own business. No resale or redistribution. Delivered as a ZIP download immediately after payment. No physical item will be shipped.
Real Estate Investment & Rental Analyzer
Every real-estate strategy in one file — buy-and-hold, BRRRR, fix-and-flip and Airbnb — with cap rate, cash-on-cash, IRR, amortization and a dashboard. Excel & Google Sheets, any currency, no subscription.
Pay by card, Apple Pay or Google Pay
- Works in any country · your own currency
- Download link on the confirmation page and by email
- What you need: Excel 2016+ · Google Sheets
- Refund within 14 days, for any purchase
- 12 sheets · 2,185 formulas
- Formats: .xlsx (Excel 2016+, Google Sheets) + PDF guide
- ZIP: 209 KB
Any purchase is refunded if you ask within 14 days of payment. Files that will not open, and anything that does not match its description, are refunded in full at any time, with no time limit.

