12-Month Cash Flow Forecaster for Airbnb Hosts — STR Portfolio Cash Runway Spreadsheet — Excel + Sheets

See the months that go negative — before they happen. 12-month rolling cash flow forecaster for Airbnb / STR portfolios. Solves the "ran out of cash in February" failure mode. Excel + Google Sheets.

Seasonal STRs run out of operating cash every February. Bookings are thin,
mortgage is still due, insurance just renewed, the cleaner still wants to be
paid. The host who doesn't see it coming panic-lists at low rates and tanks
their search ranking.

This workbook is the forward-looking forecast that surfaces those months
before you hit them. Confirmed bookings + seasonal projection + recurring
expenses + planned one-offs + quarterly tax payments — all 12 months ahead
of you, with negative-month flags so you can move expenses or pull from
reserves before the panic.

═══════════════════════════════════════════
WHAT'S INCLUDED
═══════════════════════════════════════════

📋 Property Roster + current cash position
📋 Confirmed Bookings tab — paste next 90 days from Airbnb / VRBO / direct
📋 Seasonal Projection — month-by-month occupancy + ADR for unbooked nights
· Pre-loaded with reasonable patterns by market (beach, mountain, city)
📋 Recurring Expenses — mortgage, insurance, utilities, software, PM
📋 One-Off Expenses — planned renovations, furniture, big maintenance
📋 Tax Payments — Q1 / Q2 / Q3 / Q4 estimated tax (feeds from TAX-005)
📋 12-Month Forecast — monthly cash flow per property + portfolio
📋 Negative-Month Flag — red bar = planning trigger
📋 Cumulative Cash Position — running runway from current cash

═══════════════════════════════════════════
WHO THIS IS FOR
═══════════════════════════════════════════

· STR portfolio operators (3+ properties)
· Seasonal-market hosts (beach, ski, mountain) with revenue concentration
· Hosts who've ever moved a payment date because cash got tight
· Anyone who's run a property at 25% occupancy in February + thought "can I afford this?"

═══════════════════════════════════════════
HOW IT WORKS
═══════════════════════════════════════════

1. Open monthly on the 1st. Update Confirmed Bookings (paste from platforms).
2. Refresh expense schedule if anything was rescheduled.
3. Read the 12-month forecast. Negative-month flags = action items.
4. For flagged months: move expenses, pull from reserves, or tighten next month's spend.

═══════════════════════════════════════════
FILE COMPATIBILITY
═══════════════════════════════════════════

✅ Microsoft Excel 2016+ (Windows and Mac) · ✅ Excel 365 · ✅ Google Sheets

═══════════════════════════════════════════
REFUNDS + SUPPORT
═══════════════════════════════════════════

14-day refund, no questions asked. Email hello [!at] thestrledger.com.

═══════════════════════════════════════════

⚠ Digital product. Not financial advice. Forecasts are estimates — actual results vary.