A 13-week cash flow forecast template for independent hotel groups.

01 Why hotel cash is not generic operating cash

A hotel group has cash dynamics that no other operating business shares. Reservations are paid in stages — deposit on contract, second deposit at cut-off, balance at stay, post-stay folio for incidentals. Group bookings carry pacing cash that arrives 60 to 120 days ahead of the actual stay, which means the cash flow document and the revenue document run on entirely different timelines. Banquet event order (BEO) revenue is often deposited 25–50% at contract and 90–100% by the seven-day final-guarantee mark, well before any of it hits the P&L. Loyalty point liability sits on the balance sheet and consumes cash unpredictably. FF&E reserve is a real cash obligation that USALI treats as a below-EBITDA accrual on the owner statement, but most boutique groups never fund in cash. None of these line up with how a generic 13-week cash template handles inflows and outflows.

The boards we work with miss the shoulder-season liquidity event because they read the P&L instead of the cash document. A boutique group can show a 32% GOP margin in the trailing twelve months and still trip a debt-yield test in October if the group deposit window closes before the November banquet calendar opens. The 13-week horizon exists for exactly that — to land the working-capital swings on the calendar lenders actually test against, not the calendar the P&L summarises against.

02 The 18 lines, hotel-specific

Most generic 13-week templates run twelve to fourteen lines and do not separate rooms revenue from F&B from banquet, do not break payroll by department, and treat FF&E reserve and capex as the same line. None of that works for hotels. The hotel variant we use runs eighteen lines, each chosen because something on the calendar requires it.

1. Beginning cash by entity and bank account, with restricted-account balances called out separately.
2. Rooms revenue collected — split into transient (collected at stay) and group (collected per deposit schedule, often 90-120 days ahead).
3. F&B outlet revenue collected — daily restaurant and bar, collected at point of sale.
4. Banquet and event revenue collected — driven by the BEO calendar with the 25/50/100% deposit ladder, often the largest single inflow in a peak month.
5. Ancillary revenue collected — spa, parking, resort fee, golf, marina, ski, depending on property.
6. OTA fees, GDS commissions, and credit card discount — netted against rooms revenue but tracked separately for visibility.
7. Cost of F&B sold — paid on a 14-30 day vendor cycle and one of the largest variable-cost lines.
8. Payroll by department — rooms, F&B, banquet, sales & marketing, A&G, engineering, with overtime and casual labour broken out.
9. Utilities — electricity, gas, water, internet — typically monthly but seasonally heavy and worth modelling weekly during peak.
10. Property tax and insurance accruals — usually paid in installments but accrued weekly so the cash hit is anticipated.
11. Rent, ground lease, or hotel-management lease payments.
12. Mortgage debt service — principal and interest separately, against the covenant schedule below.
13. FF&E reserve contribution — a cash transfer into a segregated reserve account, weekly, not a P&L accrual.
14. Capex draws — separate from FF&E reserve, modelled against an explicit 10-year CapEx calendar.
15. Income tax — federal, state/provincial, GST/HST/VAT.
16. Other operating expenses — franchise fees, marketing co-op contributions, loyalty redemption costs, brand-mandated fees if any.
17. Net cash change for the week.
18. Ending cash and available liquidity — including undrawn revolver capacity, against minimum-liquidity covenant.

Eighteen lines is the working version. We have seen operators try to compress it to twelve to fit a single screen and we have seen them stretch it to twenty-six to chase every reserve and accrual. Eighteen is the band where the GM, the group director of finance, and the owner can all read the same document and have the same conversation. It is also the band where the line-by-line variance investigation in the Monday meeting stays under thirty minutes.

03 FF&E reserve as a cash line, not an accrual

The single most consequential change we make to most independent groups' cash models is moving FF&E reserve from a P&L accrual to a cash contribution funded into a segregated account, weekly. USALI 11th edition places the Replacement Reserve below EBITDA on the owner-level statement, which is correct for reporting but does not say a word about whether cash actually moves. In branded institutional deals the management agreement requires the cash transfer; in independent and boutique deals it often does not, and the reserve becomes an accounting fiction by year three or four. Then the seven-year refresh comes due and the operator finds the reserve account holds twelve months of contributions because cash was raided to fund payroll in two soft shoulder seasons. We see this pattern in roughly half the boutique groups we open.

The 4% of revenue convention is also wrong for boutique. The ISHC CapEx study has total industry capital spend running near 9% of revenue at record highs, with Amerail recommending 8% for major upgrades plus 15-25% for FF&E and maintenance and repairs combined. For design-driven boutique groups with case-goods cycles compressed to 8-12 years (versus 10-14 for midscale) and soft-goods refresh on a 5-7 year cadence, our template defaults FF&E reserve cash contribution at 5-6% of total revenues. The owner sees the higher charge on the cash document immediately. The operating team feels the cost of the refresh cycle inside the year-one operating budget — not at the refresh year, when the gap is only addressable by mezzanine debt or scope cuts that compromise ADR positioning.

The discipline matters because boutique repositioning frequently runs 20-40% over a simple per-room FF&E model. Select-service refresh lands at $10k-$20k per key for full soft-goods plus selective case-goods; boutique upscale routinely runs $20k-$40k per key once design, A&V, and back-of-house upgrades are scoped properly. A 100-key boutique that funded reserves at 4% for seven years and now needs $25k per key for a refresh is short roughly $700k-$1.0M against what the reserve account holds. That gap shows up at exactly the wrong moment — when ADR is starting to slip versus comp set because the rooms product is out of date and the lender is sharpening pencils on debt yield. Moving FF&E to a cash line at 5-6% solves the underfunding problem mathematically; the operating discipline to keep the segregated account segregated solves it culturally. Both have to happen.

For owners considering whether to move to a funded reserve mid-stream: yes, even if the operating team objects. The way the conversation usually lands is that the GM resists because the 5-6% line compresses GOP margin on the management report. The right answer is that the GOP margin was always wrong — the operator was running with a 4% accrual that the operating cash never funded, which means the GOP margin was overstated by the difference. Moving to a real-funded 5-6% line is not a margin compression, it is a margin re-statement. Once the GM's incentive plan resets to the new line the conversation moves on. The further reading is the boutique-CFO playbook covering GOP, NOI, and FF&E sequencing for independents that we publish for new engagements.

04 The shoulder-season stress test

The 13-week horizon is built to absorb the shoulder season. We run two layers of the document for every engagement — a base case that uses the property's historical pacing curve adjusted for known group books, and a stress case that flattens occupancy 10-12 percentage points below the trailing three-year shoulder average and cuts ADR by 5-10% on top. Most boutique groups have never seen this case modelled before week one. The output is not a forecast; it is a trigger schedule — the precise dates and metric thresholds at which revolver draws, capex deferrals, group-rate concessions, and lender conversations are pre-authorised so the decision is not improvised in the moment.

The covenant thresholds the stress case is calibrated against

Hotel-loan covenants cluster in narrow bands. For CMBS loans, hard cash management or cash trap typically springs at 1.10x-1.20x DSCR on the trailing 3-6 or 12 months; technical default sits below 1.00x persistent. Bank hotel loans set covenant defaults around 1.20x-1.25x DSCR with waiver consideration at 1.10x-1.20x when sponsor liquidity is strong. Life companies underwrite at 1.35x-1.50x and start serious conversations below 1.25x-1.30x. Debt yield at origination runs 13.5%+ for CMBS, 12%+ for banks, and 14-15%+ for life companies; the soft yellow line for refinancing is approximately 10%, with 8-9% being effectively non-refinanceable in the current environment. The 13-week stress case models forward DSCR and debt yield against these explicit bands.

The liquidity rule the cash document defends

For seasonally volatile independent groups, the best-practice liquidity rule is to preserve at least six months of all-in cash burn — debt service plus essential opex plus minimum FF&E contribution — after the worst shoulder month. Larger groups with committed revolvers target 9-12 months including undrawn capacity. The 13-week document tracks this explicitly: every week shows cash plus undrawn revolver against the six-month forward burn requirement, and the stress case shows where the gap opens. Revolver-draw triggers in our default playbook fire when (a) three-month forward unrestricted cash falls below three months of debt service, or (b) total liquidity falls below six months of debt service plus payroll, utilities, and franchise fees, or (c) rolling 6-12 month DSCR is projected below 1.20x with a covenant test inside two periods. None of those is improvised; all of them are pre-authorised in the operating board minutes the week the document goes live.

1. Is FF&E reserve modelled as a cash contribution into a segregated account, weekly, or as a P&L accrual the operating account quietly raids?
2. Where on the 13-week timeline does the shoulder-season stress case break the covenant test, and what is the pre-approved playbook for that exact trigger date?
3. Group booking pacing — is it in the cash document with explicit deposit and final-payment dates, or is the pacing report sitting in the revenue manager's pipeline only?
4. BEO revenue — at what point on the BEO calendar does each event's 25/50/100% deposit ladder hit the cash document, and which events are below the historical pickup curve at 90 and 60 days out?
5. Liquidity — is the six-month forward cash + revolver capacity tracked weekly against the covenant minimum, and is the revolver draw pre-authorised at the trigger?

The stress case also reveals the capex deferral sequence. The triage we use, least to most sensitive: non-essential cosmetic projects defer 6-18 months; discretionary amenity expansion 12-24 months; room soft-goods upgrades phased by floor; systems and back-of-house efficiency deferrable but with opex consequence; brand-mandated PIP items non-deferrable without consent (push for phased completion); life-safety and structural never deferred. Lenders accept the first four with documentation, push back on the fifth, and will not engage on the sixth. Knowing the sequence before the stress event lands is the entire point of the document.

05 The group deposit ladder — where most of the cash actually lives

Independent and boutique hotels run group business at 20-35% of total revenue, with weddings and social groups often hitting the higher end and corporate / MICE clustering in the middle. The Cendyn / Amadeus Group Index has now printed ten consecutive quarters of YoY growth through Q1 2025, with group ADR up 4.7% and the events volume index at 114.6%. For independents this is the structurally most cash-favourable revenue segment, because the deposit ladder pulls cash forward by 90-180 days on average. The 13-week document either models this explicitly per group, or it gives you the wrong answer every shoulder season.

The default deposit ladder for a 90-120 day lead time

For a typical 90-120 day group with combined rooms and banquet revenue of $40,000-$200,000, the ladder we default to is: 20-25% at contract (T-90 to T-120), bringing initial cash in. A second deposit at the cut-off date — typically T-30 to T-45 — bringing cumulative payment to 50-75%. Final payment at the seven-day BEO guarantee for banquet revenue and on departure for the master account on rooms. For weddings and major social events with high F&B attach (frequently 2-3x rooms revenue), the deposit cash is even more front-loaded — 90-100% of expected BEO revenue typically in hand before the function day. For corporate / MICE groups with credit terms, the master-account room revenue can lag 7-30 days past departure, which the document has to model explicitly.

The attrition clause is a cash document line, not a contract footnote

Attrition penalty terms — typically requiring 70-80% pickup of the contracted block, with shortfall billed on a re-sell-adjusted basis — show up in the 13-week document as a contingent receivable. We model the expected penalty at probability-weighted recovery (typically 40-60% of the gross penalty due to settlement negotiations and re-sell credits), and we surface it on the cash document as a separate sub-line under banquet revenue. Operators consistently underestimate this line at the moment of contract, and consistently overestimate it at the moment of stay. Modelling it explicitly forces both conversations to happen with the data on the table.

Why pacing actuals beat the booking calendar every time

STR pacing reports and the property's own PMS pickup curves are the input the document needs, not the contracted group calendar. A typical group room pickup curve runs at 30-40% of eventual on-the-books nights at 180 days out, 60-75% at 90 days, and 80-95% at 30 days. When pickup is materially below curve at 90 days, the conversation in the Monday meeting is not whether to chase — it is whether to release the block to transient at a higher ADR, hold for a value-add concession, or proactively re-cut the BEO down to the realistic event size. The document does not make the decision; it makes the decision impossible to defer. That linkage to the unit-economics work we cover in the multi-unit RevPAR and cash flow piece is what makes the document operational rather than diagnostic.

06 What the FRED data says — rate is doing the work, labour capacity is not

The macro context that frames the 2026 cash document is uncomfortable for anyone modelling on volume. The FRED PPI for hotels and motels (series PCU721110721110) printed 187.868 in April 2026 versus 173.129 in April 2025 — a +8.5% YoY move, with February 2026 at 188.915 (+6.9% YoY) and March 2026 at 192.058 (+5.3%). Hotel pricing power is intact and meaningfully above CPI. Meanwhile US accommodation employment (FRED CES7072100001) peaked at 1,946.2 thousand in April 2025 and has retraced to 1,919.1 thousand by April 2026 — a 1.4% drop over twelve months in seasonally adjusted headcount. Capacity is not expanding, rate is.

For the cash document, this matters in three places. First, the labour-percent-of-revenue line tightens during peak windows when group volume picks up faster than headcount can scale — overtime and casual labour spike, and the cash document has to capture that on the week-of, not in the month-end review. Second, the rate-driven RevPAR trajectory means the FF&E reserve at 5-6% of revenue translates to more absolute dollars year over year — the underfunding gap on 4% accrual grows faster than the operator notices. Third, the PPI volatility (a 192.058 March print followed by 187.868 in April — a 2.2% sequential drop) is exactly the kind of shoulder dynamic the stress case has to model. The base case follows the trailing pacing curve; the stress case overlays the PPI volatility as an ADR cut.

The labour line specifically deserves a paragraph. The right way to model it in a hotel cash document is by department and by mix — fixed core team plus variable casual labour driven by occupancy and event volume, with overtime explicitly modelled at 1.5x or 2.0x against forecast hours. We cover the operating cadence in the labour-percent-of-revenue piece for hospitality; the short version is that monthly labour reviews miss the shoulder-week spike, and the 13-week document has to surface it before payroll runs.

07 The Monday rhythm — and what the meeting actually decides

The 13-week document is updated every Monday from the prior week's actuals — STR pacing data, PMS pickup curves, F&B and banquet revenue, payroll, and bank balances. The GM of each property, the group director of finance, and the owner-operator sit for thirty minutes weekly. The conversation is not a recap; it is a set of pre-defined decisions against pre-defined triggers. Monthly is too slow for hospitality cash — by the time a monthly review surfaces a pacing miss, the lead-time window to recover the group has already closed.

The Monday meeting drives four operational decisions on a regular cadence: (a) ad-spend deployment by channel, against transient pickup versus pace; (b) group rate concessions or value-add deployments, against group pickup at 90/60/30 days; (c) F&B and banquet labour staffing for the coming three weeks, against the BEO calendar and reservation manifest; (d) timing of any capex or FF&E draw, against the trigger schedule from the stress case. None of these is "discuss and decide later." All four are tracked through to closure on the same document week-over-week so the conversation cumulates.

The further reading on tying revenue management into FP&A on the same cadence is the RevPAR-married-to-FP&A piece — that is the companion document for groups that want to push the integration deeper than the 13-week cash forecast alone supports. For groups benchmarking themselves against the public hotel REITs, the hotel-REIT benchmark on GOP, RevPAR, and FF&E capex is the comparable cohort the cash document gets compared to in board reviews.

08 Rollout — week one through week thirteen

For a new engagement, the rollout calendar we follow is consistent across geography and property type.

1. 01
   Week 1 — build and load. We build the 18-line template against the group's chart of accounts, load the prior 13 weeks of actuals to establish the seasonal baseline, and reconcile cash to bank. The FF&E reserve gets moved from accrual to a separately tracked cash line on day one, even if the segregated account does not exist yet. By end of week one, the document is reporting accurate beginning cash for every entity in the portfolio.
2. 02
   Weeks 2-4 — pacing and BEO integration. We integrate the STR pacing report, the PMS group pickup curve, and the BEO calendar with explicit deposit dates. Group revenue moves from "monthly bucket" to "weekly cash by date," which is the largest single change to the document's usefulness. By end of week four the GM is reading the same group risk the revenue manager is reading.
3. 03
   Weeks 5-8 — stress case and trigger calibration. We build the stress case at -10 to -12 percentage points occupancy and -5 to -10% ADR, run forward DSCR and debt yield against the covenant schedule, and set the explicit trigger thresholds for revolver draws, capex deferrals, and group concessions. The owner and operating board sign the trigger schedule by end of week eight. After this the document operates against a written playbook, not a verbal one.
4. 04
   Weeks 9-13 — operating discipline. The Monday meeting cadence is now stable. The document is updating against actuals each Sunday night, the meeting is running thirty minutes, and the decisions are being tracked through to closure. By week thirteen the group has a full quarter of weekly cash actuals against forecast and the variance discipline is in place. The document is now portable to the next engagement, the next acquisition, or the next financing review.

After week thirteen the document continues running, with the stress case re-calibrated quarterly against the trailing pacing curve and the covenant schedule re-tested at every loan-document anniversary. The Day-1-to-100 integration playbook for DSO and multi-unit groups translates the same rollout calendar to medical and dental DSO contexts where the deposit and pacing dynamics are different but the discipline is the same.