A lender-grade acquisition & underwriting model for short-term rentals — DSCR computed the way lenders actually compute it, 5-year pro forma, seasonal cash flow and a full sensitivity matrix. Excel + Google Sheets.
Not a "rental calculator". The underwriting logic a DSCR lender runs on your file — in a workbook you control.
Stabilized basis with your ramp-up kept separate — the detail most templates get wrong, and the first thing an underwriter checks.
Twelve monthly ADR and occupancy inputs — not one fake average. See the winter dip before it sees you.
The single number that tells you how much cushion you really have if bookings soften.
Year-by-year returns on your real cash in, with exit assumptions you control.
ADR ±20% × occupancy ±20%, color-coded on both cash-on-cash and DSCR. Know your downside in one glance.
KPI cards and charts formatted to share with your lender or partners — no cleanup needed.
The model ships with a realistic $400k purchase financed with a DSCR loan at 7.5%/30y — credible numbers, not brochure fantasy. Replace them with yours in minutes.
Sample output from the included default scenario. Your results depend entirely on your inputs and market.
Purchase price, financing, your market's ADR and occupancy by month. Everything else is locked logic.
DSCR, cash-on-cash, IRR, break-even occupancy and the sensitivity grid update instantly.
Formatted outputs your loan officer can read without translation. Negotiate from numbers, not vibes.
Yes. The workbook uses only Sheets-compatible functions — no macros, no add-ins, no external links. Upload the .xlsx via File → Import and everything recalculates.
That's exactly who it's built for. You only ever type in the yellow input cells; the START HERE sheet walks you through your first pro forma in about 10 minutes, and the 13-page guide explains every output in plain English.
Free tools give you one average month and a single ROI number. This model underwrites like a lender: stabilized DSCR, seasonal monthly cash flow, financing scenarios, break-even occupancy and a full sensitivity matrix — with every formula visible and machine-verified.
30-day money-back guarantee through Gumroad. No questions, no friction.
Yes — you buy v1.0 and future updates to this model are free. Gumroad notifies you automatically when a new version ships.
One bad assumption costs more than this model. Get the numbers right before you sign.
I want this — $99Instant download · Excel + Google Sheets · 30-day money-back guarantee