Hours Back, Not Spent
This template cut my build time from a full weekend to an afternoon, so I could focus on site planning instead of wrestling with formulas.
This template cut my build time from a full weekend to an afternoon, so I could focus on site planning instead of wrestling with formulas.
I used the low, base, and high cases without rebuilding anything three times, and it made my planning meeting much easier to run. One clean sheet kept the options clear.
The margin and break-even tabs made the numbers finally click, and I walked into my lender call with a much clearer answer on profitability.
This editable Excel and Google Sheets models work for five years of skating visits, program records, prices, extra income, scenarios and related financial statements.
Use the model to plan public skating visits, group events, program records, stream prices, start time, monthly seasonality, additional income, costs, staff, cash flow and profitability.
Modified names of streams, start dates, annual or monthly visits and records, prices, seasonality and additional revenue related financial schedules.
The model provides that each visit, ticket, entry or program will operate independently, apply once a month seasonality, multiply the size at its adjusted price and once adds additional income.
Set up public skates, group events, programme records and comparable revenue streams of the ice rink separately.
Provide annual or monthly visits or records for each stream and the date of its launch, if applicable.
The annual stream data shall be transmitted in the framework of the monthly seasonality schedule exactly once.
Apply a matching ticket, visit, entry or price of the program and add the additional income of each stream once.
The sum of the income calculated by each stream and allowed additional income from entertainment.
View Revenue combines public skating visits, group visits, program entries, matching prices, start time, monthly seasonality and additional income.
GROUNDS FOR THE REVENUE
The worksheet COGS & Operational Expenses separates food and shop pro COGS, variable costs of the ice rink and fixed overhead costs of the facility with monthly forecasts.
OPERATING EXPENDITURE COGS
In the light of the analysis of the scenarios, the low, base and high results in terms of revenues, gross margin, premium margins and EBITDA were compared in the five-year forecast.
ANALYSIS SCENARIO
The dashboard combines model settings, scenarios results, basic finances, top revenue streams, profitability, cash flow and returns in one management view.
DASHBOARD
The structure is designed to fit independent revenue streams based on tickets, admissions, visits or transactions, while a significant difference in revenue logic or reporting may require custom modelling.
The template is the starting point of planning, not a guarantee of performance.
The Financial Models Laboratory can build or adjust a model when you need a different revenue logic, operating schedules or financial statements than the ready structure.
ORDER A CUSTOM FINANCIAL MODELAfter check-out, you will receive a fully-editable Ice Skate Rink Excel and Google Sheets financial model with five-year projections, Low/Base/High scenarios and related financial reports.
Update of revenue streams, start-up dates, volumes, prices, seasonality, additional income, costs, wages, capital and financial assumptions.
Review of monthly and annual projections under the five-year horizon for model planning.
Compare low, basic and high cases of revenue and main profitability measures.
Review of the income account, cash flow, balance sheet, Dashboard and supplementary reports.
The basic answers are visible in their entirety, without clicking on the accordion.
It provides that each revenue stream will be independent, multiply its size by a matching price, once applies monthly seasonality and once adds additional revenue to it.
You can change the names of streams, start dates, annual or monthly volumes, matching prices, monthly seasonality and separately introduced additional entertainment income.
In the light of the analysis of the scenarios, alternative paths for revenues, gross margin, premium margin and EBITDA were compared in the five-year forecast.
The workbook contains a statement of income, a statement of cash flows, a balance sheet, a navigational desk, scenarios, summary, break-even, ROIC, charts, KPIs, and supplementary reports.
Yes. Custom financial modelling can adjust revenue logic, work schedules and financial results when requirements differ from the finished structure.
This is a planned forecast based on assumptions for editing, not a guarantee of financial and business results.
This pre-built financial model for an ice skating facility includes everything you need to plan, fund, and launch your business.
Core inputs and core outputs
Three scenario analysis
Presentation ready
DuPont analysis
Researched revenue assumptions
Lender-friendly financial outputs
Revenue stream detailed view
Performance metrics benchmark