Short-Let Profit & Cash Flow Forecasting Toolkit
Turn seasonal occupancy, nightly rates and real running costs into a clear 12-month cash forecast.
£29.00
Build a single-property, January-to-December forecast rather than guessing from a headline nightly rate. Enter available nights, monthly occupancy and ADR, then see accommodation and guest-cleaning revenue alongside channel fees, cleaning, laundry, consumables, management, rent, utilities and a maintenance cash reserve.
Eight connected sheets include detailed instructions, editable assumptions, seasonal planning, monthly cash flow, downside/base/upside scenarios, a flat occupancy/ADR sensitivity grid, an annual dashboard and reconciliation checks. Optional amortising finance separates interest, principal and debt service. Opening cash, setup spend and monthly capital spending make funding gaps visible.
The workbook starts with a clearly fictional English two-bedroom coastal flat. All sample prices, costs and occupancy assumptions are illustrative, not market evidence or recommended targets. Expected nights and stays can be fractional. Cash break-even includes debt and capital spending; non-viable assumptions are flagged rather than hidden.
This is a pre-tax cash-budget tool, not a tax return, regulated financial advice or a guarantee of income. It excludes income/corporation tax, depreciation, deposits, refunds, within-month payment timing, interest-only loans and refinancing. Use gross supplier costs including any irrecoverable VAT and seek property-specific professional advice. £29 GBP, no VAT added; currently available to UK customers only when separately approved for sale.
What's included
- One genuine XLSX workbook with 8 connected worksheets and 737 formulas
- 12-month seasonal occupancy, ADR, revenue, costs and cash forecast
- Optional amortising loan interest/principal and cash roll-forward
- Editable downside/base/upside scenarios and 25-cell sensitivity grid
- Annual dashboard with chart, break-even interpretation and reconciliation checks
- Detailed instructions, fictional sample assumptions, input validation and editable-input protection
- Format
- XLSX (8 worksheets, no macros)
- Works with
- Designed for Excel 2019/2021/365 desktop; recalculated and opened with LibreOffice in QA. Native Excel desktop/Mac/iOS acceptance testing remains outstanding. Google Sheets import not verified.
- Made for
- UK short-let owners and managers forecasting one property at a time
- Licence
- Single-business internal-use licence for properties you own or manage; copy per property. Do not resell, redistribute or publish the file. Version 1, prepared 13 October 2026. Support: hoststack.uk/contact. This is not financial, tax or legal advice.