Role: Data Analyst / Revenue Analyst
Industry: Professional Sports (Ice Hockey)
Tools: Excel, Financial Modeling, Scenario Analysis
Project Type: Business Case / Decision-Support Model
๐ [Download full Excel model] ๐ [View full presentation]
Scenario-Based Profitability Modeling for Playoff Home Games
Role: Data Analyst / Revenue Analyst
Industry: Professional Sports (Ice Hockey)
Tools: Excel, Financial Modeling, Scenario Analysis
Project Type: Business Case / Decision-Support Model
๐ [Download full Excel model] ๐ [View full presentation]
This project delivers a scenario-based financial model designed to evaluate the profitability of playoff home games for a Liiga ice hockey team. The model supports decision-making under uncertainty by quantifying financial risk, break-even points, and upside potential across different playoff outcomes.
The primary objective was to move beyond intuition and provide management with a structured, transparent tool for playoff budgeting and risk assessment.
Playoff games represent one of the most financially volatile periods for a professional sports organization:
Despite the importance of playoffs, financial planning is often based on rough estimates rather than structured scenario analysis.
Management needs clear answers to three critical questions:
This project addresses those questions through a flexible, scenario-driven model.
The model is designed to be used both before and during playoffs.
The project aims to achieve the following objectives:
This is a scenario-based financial model, not a historical prediction model.
Key characteristics:
Explicit assumptions ensure transparency and allow rapid iteration as new information becomes available.
High-level structure:
The modular structure allows fast updates without breaking downstream logic.
The analysis reveals three key insights:
The model enables:
The framework is directly transferable to other teams, leagues, and event-driven businesses.
Current limitations:
Planned extensions: