The 30-second pitch
The host who sells a property in panic is usually the one who got blindsided by a $6,000 furnace replacement in February. The cash flow was tight for months; nobody surfaced it; one repair pushed it into the red.
This workbook lays your next 12 months out month-by-month. Inflows + outflows + planned capex + mortgage. Months that go negative show up in red. You see them in May, when you still have 9 months to do something — not in February, when the furnace is already dead.
Who it’s for
- Portfolio operators running 2–12 properties with overlapping cash cycles
- Hosts who’ve sold a property under duress and want to make sure it doesn’t happen again
- Anyone considering an acquisition who wants to see how the new property changes the portfolio cash curve
Math that earns the price
Avoiding one forced sale of an STR — typical loss vs. patient sale: $15,000–$60,000. Workbook costs $47. The first time it surfaces a 3-month-out negative cash month, you start solving instead of reacting.
Related
- The Deal Analyzer
- 5-Year Pro Forma Builder
- Aspiring Host Bundle
- The P&L Tracker
- Escape the W2 Planner
What's inside
- Forward Booking Log — confirmed reservations + forecast bookings (% likelihood + ADR + occupancy). Per property.
- 12-Month Forward Cash Flow — monthly inflows from bookings, outflows from mortgage / utilities / cleaning / capex / tax escrows. Red rows = months that go negative.
- Capex Schedule — planned big-ticket items (HVAC, roof, paint, furniture refresh). Slot into months. Pre-flag the cash crunch.
- Mortgage + Tax Escrow Block — fixed-month outflows. Per-property amortization auto-fills.
- Sensitivity Scenarios — what if occupancy drops 15%? ADR drops 10%? Furnace replacement moves up 3 months? See the impact in 1 click.
- Reserve Recommendations — based on forecast + portfolio size, surfaces the minimum reserve to maintain. Most operators undersize this.
- Portfolio Roll-up — per-property cash flow rolls into portfolio. Cross-subsidization view (Property A funds Property B's capex).
- Settings — properties, seasonal definitions, reserve floor %, capex confidence intervals.
FAQ
- How accurate is the forecast?
- Confirmed bookings are 100%. Forecast bookings use your historical occupancy + ADR by month, weighted by booking-pace. Most portfolios land within 6–10% of actual at the 90-day horizon.
- Excel or Google Sheets?
- Both. Scenarios, conditional formatting, and the portfolio rollup work natively in either.
- How many properties?
- Up to 12 on the per-property sheets, with full portfolio roll-up. Beyond 12, duplicate the workbook.
- Does it integrate with my PMS or booking calendar?
- Manual paste from booking exports (Airbnb / VRBO / Hospitable / OwnerRez). No live API. Update weekly; the forecast updates with you.
- How is this different from FIN-001 (RevPAR Dashboard)?
- FIN-001 looks backward at performance per night. FIN-003 looks forward at cash. Many hosts use both — FIN-001 to know where you stand, FIN-003 to know if next March is the month you go negative.
- What's your refund policy?
- 14 days, no questions. Email hello@thestrledger.com.
Get the workbook
Format: Excel .xlsx + how-to PDF. Excel 2016+, Excel 365, Google Sheets compatible. Instant download after checkout. 14-day refund, no questions. Lifetime updates within v1.