A short-term-rental underwriting spreadsheet that models real seasonality, every STR cost, and how far occupancy or nightly rate can fall before the deal stops cash-flowing.
Margin of safety
Nightly rate →
Annual cash flow across occupancy × nightly rate.
Illustrative worked example — every cell shows its dollar figure, not just a color.
Generic rental math hides seasonality, cleaning turnover, management, and vacancy — the things that quietly turn an STR negative.
Overpaying on a six-figure purchase is the risk.
12-month seasonality, not a flat average.
Cleaning, management, furnishing, platform fees, vacancy.
A sensitivity grid of cash flow across occupancy × nightly rate.
01
Enter your property’s numbers.
02
The model computes cash flow, cash-on-cash, cap rate, DSCR, and break-even.
03
Read the sensitivity grid and decide.
No testimonials or sales figures — there are no customers yet. Instead, a labeled worked example demonstrates the tool flagging a losing deal, and the free lite lets you verify quality before paying.
WORKED EXAMPLE — A DEAL THAT DOESN’T WORK
−$4,277
Annual cash flow
0.76
DSCR
The model flags it: this deal loses money and can’t cover its debt.
VERIFY BEFORE YOU PAY
Nothing is hidden or locked — and a free lite version lets you check a single scenario yourself before deciding.
Try the free lite versionEvery formula is visible and was independently verified.
You enter your own ADR and occupancy.
Those use a flat rate and skip seasonality and sensitivity; this is a real underwriting model.
Instant download · Excel, imports into Google Sheets