Short Term Rental Calculator | STR vs Long-Term Cash Flow Analyzer (Google Sheets, Excel)

Description

Short Term Rental Calculator — Stop guessing on short-term rentals. This analyzer tells you the cash flow, the occupancy and nightly rate you actually need, and the one thing most calculators skip – whether short-term really beats a long-term lease on the same property.

What’s inside your Short Term Rental Calculator

Editable in Google Sheets and Microsoft Excel. Set your season and your costs, and the whole deal updates: cash flow, cap rate, cash-on-cash, RevPAR and the verdict.

What It Does

• Dashboard: monthly cash flow and cash-on-cash front and center, with a GO / CAUTION / PASS verdict, your occupancy, ADR, RevPAR and cap rate, plus a revenue-by-month chart
• Property & Setup: purchase, financing, closing – and the furnishing/startup cost most new hosts forget
• Income (Seasonality): occupancy and nightly rate (ADR) month by month, with blended occupancy, ADR and RevPAR calculated for you
• Expenses: the costs long-term rentals don’t have – cleaning, supplies, host-paid utilities, platform fees and management
• STR vs Long-Term: the same property run as a long-term rental, side by side – the STR premium, and the break-even occupancy below which a long-term lease wins
• Scenarios: stress-test conservative / expected / optimistic + an occupancy x ADR sensitivity grid
• How to Use: every term explained

Calculates

• Monthly and annual cash flow (cross-checked two ways)
• Occupancy, ADR, RevPAR, cap rate and cash-on-cash return
• STR vs long-term premium and break-even occupancy
• Annual revenue from a real 12-month seasonality model (cross-checked two ways)

Save With The Bundle

Get all three real estate calculators – Fix & Flip, Rental & BRRRR, and Airbnb / STR – together in the Real Estate Investor Toolkit for $59 (a $77 value, save $18).

Who it’s for

Short-term rental hosts, real estate investors, and agents who run the numbers before they buy. Models Airbnb, VRBO and other short-term rental platforms.

Explore more in our Real Estate Calculators collection, or open it in Google Sheets.

Frequently asked questions

How is it delivered?
Instant download in Google Sheets, Excel & PDF — available right after checkout, with lifetime access.

Is it ready to use?
Yes — the formulas are built in. Enter your own numbers and it calculates automatically.