Ski Resort Model
Consumer Financial Model (Free Excel Download)
Model ski-resort performance through skier visits, lift-ticket pricing, lodging, food and beverage, snowmaking, labor, weather sensitivity, capex, and cash flow.
professionals from Deloitte
Used by professionals from
About this model
A ski resort earns far more than lift-ticket revenue. Season passes, ski school, food and beverage, rentals, retail, and lodging all depend on how many guests visit and how well the mountain can serve them.
This model helps operators and investors connect demand, capacity, spending, and costs in one plan. Use it to evaluate growth initiatives, weather-sensitive scenarios, or the value of a destination resort business.
What every model includes
Live formulas, no hardcoded values
Outputs are driven by live formulas, so the workbook updates from its assumptions instead of relying on hardcoded results.
All assumptions in one tab
Inputs are clearly marked in the Assumptions tab and separated from calculations, making it clear what to change and what to leave intact.
Statements always balancing
For integrated-statement models, the balance sheet, cash flow, and supporting schedules tie through properly.
Distinct schedules for clarity
Debt, working capital, taxes, and cash flow can get messy quickly. We group calculations in clear schedules, not across disconnected tabs.
No hidden macros or external links
There are no unexplained external workbook links or macros to undermine auditability or portability.
Changes flow through the model
Update a key driver and see the impact carry through the forecast, financing, and return outputs. We never use hardcoded numbers in formulas.
What's inside the Ski Resort Model
- Capacity: skiable acres with terrain expansion, comfortable visits per acre
- Pricing: season pass price, lift ticket price, ski school, F&B, retail and lodging per-visit spend, price escalation
- Cost structure: mountain operations, snowmaking and grooming, cost of goods (% of F&B and retail), marketing, G&A, insurance (% of revenue), depreciation %, amortisation %, tax
- Capital and working capital: maintenance capex %, growth capex %, NWC % of revenue growth, base-year revenue
- Valuation: WACC, terminal growth, net debt, shares outstanding
- Utilisation metric: capacity utilisation as the operating constraint with on-track and watch thresholds
- Dashboard with EV, equity value, per share, EV/EBITDA, EBITDA margin, capacity utilisation, and revenue mix with traffic-light status
- Visitation engine: season-pass units, pass visits per pass, and day-ticket visits
How the Ski Resort Financial Model Works: Drivers, Cash Flow, and Valuation
This ski resort financial model template gives a clear view of how a destination resort's economics fit together. It covers seven years of operations, from season pass and day-ticket demand through capacity limits, revenue streams, cost structure, free cash flow, and a discounted valuation.
The overview below explains the logic so you can assess whether the template matches your planning needs.
Demand Drivers and Capacity Limits
The operating engine separates season pass units from day-ticket visits. Pass units grow on a network-effect input, while day-ticket visits grow more slowly and are scaled by a snow-year index.
- Pass visits are calculated from units multiplied by visits per pass, and they are unaffected by the current season's weather because they are pre-sold. Day-ticket visits represent the walk-up and destination cohort, making them the segment most exposed to actual conditions.
- Total skier visits are the sum of pass and day visits, capped by the resort's skier capacity. Capacity is skiable acres times a comfortable carrying capacity of 3.0 thousand visits per acre.
- Utilisation compares total visits to that capacity. Because total visits are capped, utilisation can never exceed 100 percent, even in an aggressive stress scenario.
A dashboard traffic light flags utilisation against comfortable and watch thresholds.
Revenue Streams and Cost Structure
Revenue comes from six streams, each escalated at a price-growth factor. Season pass revenue is pass units times pass price; lift ticket revenue is day visits times effective ticket price.
- Ski school, food and beverage, retail and rental, and lodging revenues are each driven by total skier visits multiplied by a per-visit spend. On the cost side, mountain operations and snowmaking and grooming form the resort cost base.
- Snowmaking and grooming cost intensity rises as the snow-year index falls below neutral, because a low-snow year requires more machine-made snow; a deep-snow year eases that cost. Cost of goods sold applies only to food, beverage, and retail revenue, keeping merchandise margin separate.
Marketing, general and administrative, and insurance and property costs are revenue-linked. EBITDA margin results from these relationships.
Free Cash Flow and Working Capital
The unlevered free-cash-flow bridge starts with EBIT, subtracts unlevered tax to reach NOPAT, adds back depreciation and amortisation, and then deducts maintenance capex and growth capex. The change in net working capital is modelled as a small negative percent of the year's absolute revenue change.
- This reflects the advance-commitment pass model: season passes are sold and collected before the ski season begins, so working capital releases cash as the business grows. The bridge is a grey-font row labelled as a revenue-change bridge rather than a headline growth-rate metric.
- Year-one unlevered free cash flow is approximately $623 million, rising to approximately $872 million by year seven under base-case assumptions.
Valuation and Practical Use
Valuation discounts the unlevered free cash flow stream at an 8.0 percent WACC and adds a Gordon-growth terminal value at 2.5 percent. This produces an enterprise value of approximately $13.3 billion.
- A net-debt bridge of $2.5 billion leads to an equity value of approximately $10.8 billion, or about $269.60 per share on 40 million shares. The implied EV/EBITDA multiple is 10.3 times, in line with the sector's high-single to low-double-digit range given the asset-heavy, weather-exposed model.
- The model is designed for operators and investors to evaluate growth initiatives, weather-sensitive scenarios, or the value of a destination resort business. Every driver is a single named-range input, so you can flex pass units, pricing, per-visit spends, cost stack, capex, the snow-year index, or the discount rate to test specific operators or conditions.
Formatted to IB standards
Named theme colors repaint the whole workbook in one click, on top of an investment-banking structure with clear input, output, and cross-sheet reference styling - brand-ready, institutional-grade, and fully auditable.
Created by ex-finance professionals
Hey, I’m Alex and I created Finamodel.
Over my years in the finance industry I kept building the same models over and over again. Same structure, same assumptions, different logo. So I started building frameworks to turn them into clean, reusable templates.
Every model here is one I’d actually use for a client, and I personally vet each one before it goes up.
I’m not an expert in every industry, but I’ve built enough models to know what belongs in one. And when something is completely foreign to me, I reach out to my network for experts to work on our models with us.
Having a template library on hand cuts a first build from hours to minutes.
Need help finding your model? You’ll find me in the Finamodel app!
Frequently asked
What is a ski-resort model?+
A ski-resort model captures the seven-year operating economics and intrinsic value of a mountain ski-resort operator - the destination-resort business that runs lift, pass, ski school, food and beverage, retail and lodging revenue across a terrain estate. It builds skier visits from season-pass units times visits per pass plus a day-ticket cohort, frames capacity against skiable acres, prices six revenue streams, runs the cost stack to EBITDA, and discounts an unlevered free-cash-flow stream to enterprise value, equity value, and value per share. It is how a private-equity associate, operator CFO, or lender values a resort.
Why is the season pass modelled separately from visits?+
The season pass is sold once before the season for unlimited or multi-day access, so pass revenue is driven by pass units times the pass price, not by how many days each holder skis. Ancillary revenue - ski school, food and beverage, retail and rental, and lodging - follows the actual skier visits a pass generates plus the day-ticket cohort. Keeping the two separate lets the model capture the advance-commitment pass economics and the pre-paid cash float without double-counting attendance.
Why is capacity utilisation the key operating metric?+
A resort carries a largely fixed terrain and lift base, so the incremental visit drops through at high margin until the mountain fills. Capacity utilisation - total visits over a comfortable carrying capacity of skiable acres times visits per acre - is the metric that signals whether a resort is under- or over-skied, and the model surfaces it on the dashboard against a traffic-light threshold so a visitation or expansion scenario shows up against the constraint.
Why an unlevered DCF instead of an EBITDA multiple?+
Resorts run healthy EBITDA margins but carry real depreciation and capex on lifts, snowmaking, and lodging, so EBITDA overstates cash. The model bridges to unlevered free cash flow - NOPAT plus D&A, less capex, less the change in working capital - and discounts it at a WACC, then adds a Gordon-growth terminal value. The implied EV/EBITDA falls out as a sanity check against the high-single to low-double-digit range the sector trades at rather than as the valuation input.
Can I make it a levered or single-resort model?+
The template is a multi-stream unlevered DCF. For an equity-IRR view, add a debt schedule and bridge to levered free cash flow; for a single resort, set the visitation, acres, and pricing to that mountain. The net-debt line already bridges enterprise value to equity value, so a financing layer slots in cleanly.
Why does the season pass matter so much?+
The advance-commitment pass (Epic, Ikon) is sold before the season, so it locks in revenue regardless of snowfall and smooths the weather risk that historically made ski operators volatile. Pass units are a core growth driver.
What is capacity utilisation in a ski resort?+
Skiable acres times a comfortable carrying capacity (visits per acre) set skier capacity; utilisation is total skier visits over that capacity. It is the operating constraint a resort manages with terrain investment.
What are the revenue streams?+
Season pass (units times pass price), lift tickets (day visits times ticket price), and four ancillary streams - ski school, food and beverage, retail and rental, and lodging - each driven off total skier visits times a per-visit spend.
What drives the valuation?+
Pass-unit growth, day-ticket visits, ticket and pass pricing, per-visit ancillary spend, and terrain capex, set against the operating cost base. The DCF flexes them together.
Who uses a ski resort operating model?+
Resort operators and CFOs running operating plans, leisure investors underwriting acquisitions, and equity research analysts covering the listed operators (Vail Resorts, Alterra/Ikon) and regional ski areas.
Have more financial modelling questions? Contact us
Related templates
Theme Park Operating Model
Model theme park revenues by operating season, attendance drivers, and operating expenses with leverage and returns.
Hotel Operating Model
Operating model for hotel properties including occupancy rates, average daily rate (ADR), RevPAR optimization, and facility-level profitability.
DCF Model
Discounted cash flow valuation model with explicit forecast, terminal value, and WACC.
Golf Course Model
Plan and value a golf course operator using rounds played, green fees, membership dues, operating costs, and a DCF.
