Average occupancy for the whole year
Seventy percent in summer and fifteen in winter is not the same as forty every month. Cash gaps hide in the difference.
Financial model template
Guest house and small hotel financial model with seasonality
A guest house earns most of its year in a few months. The template calculates nights from rooms and seasonal occupancy, deducts booking platform fees, cleaning and staff, and shows whether summer money lasts through winter.
The model answers
- Whether the high season covers the low one
- What occupancy you need at your nightly rate
- How much reserve to keep for winter
What is inside the template
Each line is a block with plain fields. Change the numbers, delete blocks or add new ones.
- Room nights from the number of rooms, occupancy and nightly rate
- Seasonality by month
- Booking platform commission as a share of revenue
- Cleaning, laundry and seasonal staff
- Utilities and upkeep
- Construction and furniture as an investment, with a loan
Numbers to watch
- Occupancy by month
- The single biggest driver. Use real data for your region.
- Booking fees
- Platforms often take 15–18% of the booking. That is a direct cut of revenue.
- Winter cash
- The lowest point of the cash curve usually comes at the end of the low season.
- Revenue per room per year
- Compare it with the cost of the building and renovation.
Common mistakes in this kind of model
No platform fees
Most bookings come through platforms with a commission.
Staff costs flat all year
Seasonal staff can be planned only for the high season.
AI assistant
Check the template against your market
Tell the assistant your city and format. It looks up prices, rent and salaries online, compares them with the template and proposes changes as cards with the effect on profit and cash. You decide what to apply.
Questions
How do I account for seasonality?
Add the seasonality block and set a coefficient for each month. Revenue and occupancy follow it automatically.
Can I compare two locations?
Yes. Duplicate the model and change rent, nightly rate and occupancy, then compare the dashboards.
Related reading
Cash flow gap: how to spot it before it happens
What a cash flow gap is, the typical causes (stock, payment terms, seasonality, loans), how to find it in a monthly forecast and six ways to close it.
Break-even point: how to calculate it and use it
What the break-even point is, the formula in units and in money, a worked example, and why monthly break-even differs from payback. Plus how to lower it.
Similar templates
Open the guest house or small hotel template now
The demo works without sign-up. To save your model, start the free trial.