Short-Term Rental Analyzer

Airbnb/VRBO underwriting: 3 scenarios, cash flow, cap rate, DSCR, break-even occupancy and an ADR x occupancy grid.

Know if an Airbnb or VRBO deal works before you buy it.

Three scenarios side by side (Conservative, Base, Optimistic, or three different properties): nightly rate, occupancy, blocked nights, average stay, cleaning fees, platform fee, cleaning cost, management, maintenance, CapEx reserve and every monthly bill.

Calculated for you

• gross revenue (nightly + cleaning fees), operating expenses and NOI
• mortgage P&I, annual debt service and cash flow (annual and monthly)
• cash-on-cash return, cap rate, DSCR and RevPAR
• break-even occupancy: the occupancy you need just to cover costs and the mortgage

Sensitivity grid: annual cash flow at occupancy 40–85% and nightly rate −$40 to +$40, colored red/green, so you can see your margin of safety at a glance.

Includes a blank analyzer, a worked SAMPLE ($350,000 property, three scenarios) and a PDF guide that explains every input.

Works in Excel 2010+, Google Sheets and LibreOffice. No macros.

Tested: every calculated cell was recalculated in LibreOffice and matched an independent Python model across the sample, nine randomized scenarios and all 90 sensitivity cells.

Not tax, legal or investment advice. Check local short-term rental rules before you buy.

Built with AI assistance and tested by running it end to end (details in the guide).

Refunds: 30-day refund if it doesn't work as described (refund policy).

Learn the method (free)

• Short-Term Rental Calculator Spreadsheet: Airbnb Cash Flow, Break-Even Occupancy and Nightly Rate (Excel & Google Sheets)

  Build an Airbnb/VRBO deal analyzer that works out gross revenue, NOI, cash flow after the mortgage, cash-on-cash, cap rate, DSCR, RevPAR, and the occupancy and nightly rate you need to break even. Exact formulas, tested by recalculating a sample workbook in LibreOffice and checking it against an independent model.

Related free tools

• Free Rental Property Calculator: Cash Flow, Cap Rate, Cash-on-Cash, DSCR

  Instant rental deal math in your browser: monthly cash flow, NOI, cap rate, cash-on-cash return, DSCR, GRM, 1% rule and break-even occupancy.

Checkout, delivery, receipts and sales tax are handled by Gumroad. Questions after purchase: reply to your Gumroad receipt email. Not tax, legal or financial advice.