Activity Resort Financial Model

Description

The model is purpose-built for an all-in-one activity resort that combines accommodation, multiple recreational activities, dining, and retail. Unlike a generic hotel template, it captures the operational layers specific to resorts where revenue is driven by both room occupancy and per-guest activity participation, each with distinct demand drivers, capacity constraints, and seasonal profiles. The total capital investment required for a mid-size resort typically falls in the several-million-dollar range (illustrative order of magnitude).

Operational modelling is granular: up to 15+ activities (zip-lining, mountain biking, water sports, climbing, eco-tours, etc.) are treated as separate profit centers with their own pricing, session schedules, guide ratios, and equipment wear. Staffing is driven by the number of sessions running per day—certified guides, instructors, and support staff are rostered separately, with seasonal hiring and layoffs. The lodging block generates room revenue, package bundles, and group events, with occupancy dynamically linked to season and marketing spend.

Seasonality is central. The model uses a monthly timeline (up to 20 years) where weather-dependent open/closed months, shoulder-season utilisation curves, and off-peak discounting are fully adjustable. A realistic ramp-up path simulates first-year low awareness, gradual occupancy growth, and eventual plateau. Three demand scenarios (base, upside, downside) can be activated with a single switch, automatically adjusting utilisation and occupancy across all revenue streams.

Capital expenditure is modelled in phases—initial construction, pre-opening, and later rounds for additional attractions or capacity expansion. The model distinguishes fixed assets from movable activity equipment, each with its own depreciation and replacement logic, and handles working capital seasonality. Financing can include equity, senior debt, and mezzanine with tailored covenants and sculpted repayments. Key outputs highlight seasonally accurate cash flows, debt service coverage, and equity returns, including off-season liquidity gaps that are often overlooked.

Modeling specifics

• Multi-activity operational cores: each activity is a self-contained unit with capacity (sessions per day, max participants), pricing tiers (adult/child, peak/off-peak), and required guide-to-guest ratios—automatically calculates revenue and direct costs from utilisation assumptions.
• Activity-linked staffing engine: staff levels are driven by the number of sessions running, not fixed headcount. The model allocates guides per activity per shift, respects certification requirements, differentiates wage rates for specialist roles, and models seasonal layoff/rehire cycles.
• Weather-dependent seasonality and shoulder months: monthly availability for each outdoor activity can be toggled open/closed based on climate data, with utilisation curves that taper during shoulder seasons. Variable costs are adjusted proportionally, preventing overstatement of revenue in bad-weather months.
• Package and dynamic pricing engine: room-activity bundles, all-inclusive rates, and early-bird discounts are modelled with take-up rates. The engine shows how bundling impacts net revenue per guest and avoids double-counting or cannibalization errors.
• Equipment fleet management: activity gear (bikes, kayaks, harnesses) is treated as a separate asset class with purchase, maintenance, and replacement schedules based on usage cycles (hours in service), not simple straight-line depreciation, ensuring realistic capex reserves.
• Phased expansion with modular infrastructure: new activities or accommodation blocks can be added in later years, with construction periods, pre-opening marketing spend, and ramp-up of utilisation. The model shows step-change impacts on returns and cash flows, linked to financing draws.
• Off-season cash flow stress testing: by isolating fixed costs and debt service in months with minimal revenue, the model reveals liquidity troughs and tests whether the working capital facility is adequately sized—one of the most critical blind spots in resort investing.
• F&B and retail sub-models: restaurant and bar revenues are separated by guest type (in-house, activity-only, external), with meal-plan inclusions correctly allocated. Retail is modelled as a per-participant spend plus impulse purchases, each with distinct gross margins.

What's included in the base version

• Lodging revenue model with daily occupancy and ADR, room-type mix, and seasonal pricing
• Activity revenue module for up to 10 distinct activities, each with own pricing and capacity settings
• Seasonal staffing and salary calculator with guide ratios, shift patterns, and wage tiers
• Activity equipment CapEx and replacement reserve based on usage cycles
• F&B and retail revenue projections with guest-source segmentation and margin analysis
• Phased investment and expansion scheduler with construction timelines and financing draws
• Integrated monthly financial statements (P&L, Cash Flow, Balance Sheet) over 15–20 years
• Debt financing module supporting senior and mezzanine tranches, sculpted repayments, and covenants
• Scenario manager (base, upside, downside) with automatic adjustment of utilisation and occupancy
• Executive dashboard with KPIs (RevPAR, TrevPAR, activity yield, DSCR, IRR, payback period)

Common modeling mistakes

• Applying uniform annual occupancy to all activities without seasonality — inflates revenue by 20–40% in temperate climates and even more in seasonal destinations, because off-peak utilisation is heavily overestimated.
• Treating guides as fixed salaried staff rather than variable per-session labour — understates operating expenses by 15–25%, making margins and EBITDA falsely attractive.
• Ignoring equipment replacement cycles and only using straight-line depreciation on original cost — misses periodic lump-sum cash outflows, overstating free cash flow by 10–18% and under-accruing future capex needs.
• Modelling room revenue without deducting bundled activity packages — overstates lodging ADR by 5–15% and misallocates the true demand effect on activity capacity, distorting total revenue per guest.
• Assuming immediate high occupancy from opening — overestimates first-year revenue by 30–50% and shortens the true payback period by 1–2 years, often leading to overly aggressive financing structures.
• Neglecting off-season minimum staffing and semi-fixed costs — cash flow projections show positive liquidity in low months that in reality require a working capital line, potentially masking a cash shortfall of 20–30% of peak season cash.