Hotel seasonality: calculate monthly cash coverage from occupancy and room rate

Annual hotel coverage can look adequate while early-year payments consume cash that will not be earned until summer. To test this, translate occupancy and average daily rate into monthly room revenue, subtract costs using their actual drivers, and then apply the debt schedule. A flat annual margin divided by twelve misses both room-night economics and the sequence of cash needs.

Host Hotels’ 2025 Form 10-K reports occupancy, average room rate and RevPAR alongside operating results, with attention to comparability and major interruptions. Those metrics help describe operating activity; none is a substitute for cash after expenses and debt. Host Hotels & Resorts, 2025 Form 10-K

Use one room inventory and the actual calendar

Available room nights equal rentable rooms multiplied by days available. Occupied room nights equal available nights multiplied by occupancy. Room revenue equals occupied nights multiplied by average daily rate. If rooms are out of service, show the reduction in available inventory separately so a higher occupancy percentage does not disguise fewer revenue-producing rooms.

Different costs need different drivers. Housekeeping may vary with occupied rooms; some distribution fees vary with revenue; fixed staffing, insurance and property costs may continue through low occupancy. Use the operator’s actual cost definitions. The simplified example below is an arithmetic demonstration, not a hotel expense benchmark.

Hypothetical 50-room seasonal hotel

Assume all 50 rooms remain available throughout a non-leap calendar year. Variable cash cost is $25 per occupied room night, fixed cash operating cost is $25,000 each month, and an additional 4% of room revenue is set aside for recurring capital. There is no food-and-beverage or other revenue. Cash collections equal earned revenue, all costs are paid in the same month, and monthly debt service is $60,000.

The cash-flow column below is after those operating costs and the stated capital provision but before debt. It is not presented as a universal lender NOI definition. Amounts are rounded for display; calculations retain cents.

Annual cash before debt is $1,007,151.50 against $720,000 of debt service, or approximately 1.40×. Yet the borrower needs $92,258 of opening cash merely to avoid a negative month-end balance through March. A separate $40,000 minimum operating balance increases the opening requirement to $132,258. Taxes, payroll or other payments clustered within a month can require a more detailed schedule.

Reverse-solve the January break-even occupancy

For January, each occupied room night contributes $120 × 96% − $25 = $90.20 after the revenue-based provision and variable cost. Fixed operating expense plus debt is $85,000. With 1,550 available room nights, cash break-even occupancy is $85,000 ÷ (1,550 × $90.20), or approximately 60.80%.

This is a cash break-even under the entered assumptions, not a market demand prediction. It also changes with ADR. If January occupancy falls to 25% and ADR to $110, room revenue becomes $42,625 and cash before debt falls to $6,232.50. January cash after debt is then negative $53,767.50, a deterioration of $17,701 compared with the base case. Both price and volume change together; applying only one stress understates the combined effect.

Preserve the reserve through the strong season

A large summer cash balance does not automatically justify an equivalent distribution. The next winter, scheduled capital work and debt covenants may require that cash to remain available. Extend the schedule through the following low season and show proposed distributions as explicit cash uses. A reserve target should follow the forecast and actual lender conditions, not a generic number of months.

Reconcile advance group deposits, refunds and receivables separately when they are material. The example deliberately equates revenue and receipts; an actual hotel may collect deposits before the stay and settle credit-card or group balances afterward. Those timing differences can improve or worsen liquidity without changing earned room revenue.

Use the monthly model to support the financing request and ongoing reporting. The useful conclusion is the amount and timing of cash needed under defined operating assumptions, together with the evidence that supports those assumptions. Annual coverage remains relevant, but it should be presented alongside the seasonal path that makes debt payments possible.