Operated by Perco Ltd · 71–75 Shelton Street, Covent Garden, London, WC2H 9JQ, United Kingdom · Orders & product help: hello@gettidycents.com · Partnerships & business: inf@perco.world

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.

Real Estate Investment & Rental Analyzer — Page 1
1 / 12
Real Estate Investment & Rental Analyzer — Page 2
2 / 12
Real Estate Investment & Rental Analyzer — Page 3
3 / 12
Real Estate Investment & Rental Analyzer — Page 4
4 / 12

What's inside

Buy & HoldDeal inputs → NOI, cash flow, cap rate, cash-on-cash, DSCR, GRM, 1% rule and the max offer for a target return.
FinancingLoan payment and the full amortization schedule, with an optional extra monthly payment.
ProjectionYear-by-year cash flow and equity to your hold length, the sale, and the deal IRR, MIRR, NPV and equity multiple.
Fix & Flip70% rule, maximum allowable offer, rehab, holding and selling costs, net profit and ROI.
Airbnb STRADR and occupancy → revenue, RevPAR, a short-term-rental P&L and break-even occupancy.
BRRRRCash-out refinance: refi loan, cash pulled out, cash left in, cash-on-cash and equity after refi.
BookkeepingIncome and expenses by Schedule-E category with straight-line depreciation and year totals.
SensitivityA two-way table of annual cash flow as the interest rate and the rent change.
DashboardThe headline returns for the deal, the flip and the STR, plus a projection chart.
ChecksNine live self-checks; every row reads OK.

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.

Excel & Google Sheets · Excel 2016+ · Google Sheets

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.

$19
Included in PRO with every app and tool, from $19 a week

Pay by card, Apple Pay or Google Pay

VISAMastercardAMEXApple PayGoogle 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
Also in The Everything Bundle Get 48 products for $59 — you save $602.78 vs buying separately. View bundle →
♡ Refund within 14 days, for any purchase

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.