Ice Skating Rink Excel Financial Model for Startups

The exact statements, ratios, and scenarios a lender or investor would expect are already built. You bring the assumptions. We bring the math.
Ice Skating Rink Financial Model head image summarizing the model’s purpose, scope and key outputs to guide projections, cash runway, profitability and investor-ready reporting.
Fully Editable
Instant Download
Professional Design
Pre-Built
No Expertise Is Needed
Ice Skating Rink Financial Model head image summarizing the model’s purpose, scope and key outputs to guide projections, cash runway, profitability and investor-ready reporting.
Industry Benchmarks
Projected balance sheet
Capital expenditure plan
Capitalization table
Cash flow forecast
Financial charts
COGS & Operating expense forecast
Financial model dashboard
DuPont analysis
Projected income statement
Payroll forecast
Financial ratio analysis
Return on invested capital analysis
Revenue forecast
Financial scenario analysis
Sources and uses of funds
Financial model summary
Top expense analysis
Top revenue streams
Business valuation analysis
Fully Editable
Instant Download
Professional Design
Pre-Built
No Expertise Is Needed
Ice Skating Rink Bundle
See included products:
Financial Model iIce Skating Rink Bundle Financial Model template included in this product.
$149 $109
ADD TO YOUR ORDER
Business Plan iIce Skating Rink Bundle Business Plan template included in this product.
$79 $59
Pitch Deck iIce Skating Rink Bundle Pitch Deck template included in this product.
$49 $29
YOU SAVE $0 TODAY
30-Day Money-Back Guarantee
Created by a Former CFO
Updated for 2026
One-Time Purchase
Description

The Ice Skating Rink Financial Model is an Excel template for planning revenue, operating costs and EBITDA for a year-round indoor rink. Its 2026–2030 illustration models one 200-by-85-foot ice sheet in an approximately 30,000-square-foot equipped leased arena in a US Midwest suburban market.

Edit capacity, utilization, seasonality, the mix of five exclusive products, realized prices, staffing and startup spending to build financial projections. The example assumes the landlord supplies the operating refrigeration plant, slab, boards, locker rooms and installed HVAC.

Forecast
5years
Ice sheets
1shared capacity pool
Revenue streams
5product categories
WORKBOOK CONTENTS

Editable Schedules Connect Rink Operations and Reports

The workbook combines operating inputs with financial statements, funding schedules and decision reports.

Revenue & Calc

Set launch timing, capacity, monthly seasonality, utilization, product shares and yields; monthly calculations consolidate five revenue streams without allocating the same capacity twice.

COGS & OPEX + Payroll

Adjust revenue-linked supplies and transaction costs, fixed facility expenses and role-level staffing to see their effect on operating earnings.

CAPEX, CapTable & Debt

Schedule asset purchases and owner contributions, then evaluate financing through the Dashboard debt controls and Debt schedules if funding assumptions are entered.

Dashboard, Statements & Checks

Review scenario controls, IS, CF, BS, Summary and reconciliation alerts together; the supplied rink case documents numeric operating results through EBITDA.

REVENUE FORECAST

Five Products Share One Pool of Ice Capacity

Revenue comes from sold rink-hour equivalents allocated once across public skating, pass redemptions, lessons, hockey rentals and private events.

Each of the 12 daily one-hour blocks includes 50 skating minutes and 10 minutes for resurfacing or turnover. Thirty average operating days per month provide 4,320 annual blocks; utilization increases from 42% in 2026 to 62% in 2030.

Revenue Forecast

The Revenue Forecast connects available blocks, utilization and January–December seasonality with revenue by stream. Monthly multipliers range from 0.70 to 1.20 and total 12; product shares total 100%, preventing duplicated capacity.

ice skating rink financial model revenue fml30
Illustrative allocation and revenue yield per sold rink-hour equivalent
Product Pool share Hourly yield Yield basis
Public single-entry skating 35% $780 60 visits × $13
Prepaid pass redemptions 15% $600 60 redemptions × $10
Group skating lessons 20% $600 30 learners × $20
Hockey club ice rental 20% $350 Exclusive block
Private rink events 10% $425 Exclusive block

Public, pass and lesson yields include rental skates; participant counts explain the allocated yield rather than adding another demand forecast.

2026 capacity-to-revenue calculation

4,320 blocks × 42% utilization × $595.50 weighted yield = approximately $1,080,475 annual revenue.

COSTS AND STAFFING

Revenue-Linked Costs and Fixed Staffing Determine EBITDA

Direct and variable costs scale with revenue, while fixed expenses and base salaries remain unchanged in the illustrated case.

COGS equals 2.5% of revenue: 1.5% for ice and resurfacing consumables plus 1% for rental gear and lesson supplies. Variable expenses add 4.5%: 3% payment processing and 1.5% sales-linked promotion and booking fees.

COGS and Operating Expenses

The COGS and Operating Expense Forecast separates direct supplies, transaction-linked costs and fixed facility spending. Annual fixed expenses total $480,000, including the $15,000 monthly equipped arena lease and property charges; refrigeration electricity, gas, water, maintenance and insurance are also within that annual total.

ice skating rink financial model cogs opex fml30
Illustrative annual-average staffing and base salary assumptions
Role FTE Annual base per FTE
Working rink manager 1 $70,000
Ice and facility technicians 2 $52,000
Skate rental and rink attendants 3 $34,000
Group skating instructors 0.75 $50,000
Daily cleaning custodian 0.5 $32,000

Payroll Forecast by Staff Role

The Payroll Forecast calculates personnel expense from role-level FTE and base pay. The case uses 7.25 annual-average FTE and $329,500 in annual salaries, counted once in Payroll; employer taxes, benefits and personal taxes are excluded.

ice skating rink financial model payroll fml30
STARTUP AND FUNDING

Owner Funding Covers Assets and Opening Cash

The estimated $962,613 owner contribution covers startup assets, separate prelaunch cash, opening working capital and an operating reserve.

Capital Expenditure Plan

The Capital Expenditure Plan schedules equipment spending and tracks depreciation for depreciable assets. Refrigeration controls, ventilation improvements, protective flooring and the electric resurfacer total $550,000; rental skates, training equipment and POS assets are additional startup items.

ice skating rink financial model capex fml30

Separate preopening cash includes refundable deposits, commissioning, permits, launch marketing, preopening pay and ice-making energy. Working-capital controls are 2 receivable days, 30 payable days and 45 inventory days.

Sources and Uses of Funds

Sources and Uses of Funds reconciles funding sources with cash allocation over a selected period. The case includes no confirmed non-owner funding; its reserve covers three months of first-year recurring operating cash outflows as a planning policy, not a tested peak cash requirement.

ice skating rink financial model sources uses fml30
ILLUSTRATIVE FINANCIAL PROJECTIONS

Higher Utilization Increases the Illustrated Operating Earnings

The estimated operating case projects revenue and expenses through EBITDA for each calendar year from 2026 to 2030.

Illustrative annual forecast, US dollars
Year Revenue Operating Expenses EBITDA
2026 $1,080,475 $885,133 $195,342
2027 $1,234,829 $895,938 $338,891
2028 $1,389,182 $906,743 $482,440
2029 $1,492,085 $913,946 $578,139
2030 $1,594,987 $921,149 $673,838

Illustrative projections, not historical results or industry averages; whole-dollar rounding can cause small differences between displayed totals.

Growth comes from higher utilization with unchanged product mix and yields, while fixed expenses and payroll stay flat. EBITDA rises from $195,342 to $673,838 under those assumptions; this operating result excludes depreciation, interest and tax and does not establish net profit.

Cash Flow Forecast

The Cash Flow Forecast separates operating receipts and payments from asset purchases, equity contributions and debt flows. Use it to evaluate liquidity and payment timing; the illustrated EBITDA figures do not establish closing cash balances or cash sufficiency.

ice skating rink financial model cf fml30
BREAK-EVEN AND RETURNS

Evaluate Cost Coverage Separately From Investment Recovery

The Returns report supports distinct assessments of operating cost coverage, cash timing, investment recovery and annual capital efficiency.

Break-Even, Payback and ROIC

The Returns report compares sales with break-even requirements and tracks cash break-even, investment payback and annual ROIC. Sales break-even measures operating cost coverage; cash break-even concerns cash timing, payback concerns cumulative project cash recovery, and annual ROIC measures returns on invested capital.

ice skating rink financial model returns fml30

Use Dashboard Low, Base and High multipliers for revenue, COGS, variable expenses, fixed expenses and payroll to compare operating profitability. Return values require the relevant cash-flow and invested-capital calculations; no payback date or ROIC result is supplied for this illustration.

MODEL FIT

Designed for an Equipped Single-Sheet Arena Lease

This template fits a commercial rink combining scheduled public skating with lessons and exclusive ice rentals.

The case excludes land acquisition, new arena construction, unlimited memberships, separately charged skate rentals, concessions, pro-shop sales, sponsorship and spectator tickets. Operators planning those activities should adapt the revenue structure, capacity allocation and startup budget before relying on the projections.

FREQUENTLY ASKED QUESTIONS

Questions About the Ice Skating Rink Model

These answers clarify the editable inputs and the scope of the supplied operating case.

Which operating assumptions can I change?

Edit launch timing, ice capacity, bookable blocks, operating days, utilization, seasonality, product shares and yields, alongside cost, staffing and startup assumptions.

Does the model forecast prepaid pass sales separately?

The documented revenue stream uses prepaid ten-visit pass redemptions at a $10 per-visit yield, so redemptions should not be treated as a separate forecast of pass cash collections.

Are rental skates included in customer pricing?

Yes, rental skates are included in public single-entry, pass-redemption and lesson yields; the case has no separate skate-rental revenue stream.

Are the figures verified industry benchmarks?

No, the inputs are estimated planning selections and the outputs are illustrative projections, not observed industry averages.

Is the owner contribution an operating expense?

No, the estimated $962,613 owner contribution is funding for startup and opening cash needs, separate from recurring operating expenses and EBITDA.

Does positive EBITDA prove the rink has enough cash?

No, cash sufficiency depends on collection and payment timing, asset purchases and financing flows, so assess the cash flow reports rather than using EBITDA as a cash balance.

What Does the Ice Skating Rink Financial Model Contain?

ice skating rink financial model dashboard fml30

Financial Dashboard

KPIs, forecasts, and cash flow at a glance.

ice skating rink financial model revenue fml30

Revenue Engine

Key assumptions and calculations driving revenue forecasts.

ice skating rink financial model sources uses fml30

Sources & Uses

Funding sources, spending, and closing cash.

ice skating rink financial model returns fml30

Returns & Break-Even

Cash break-even, payback, and ROIC.

ice skating rink financial model valuation fml30

Business Valuation

DCF valuation and sensitivity analysis.

ice skating rink financial model top expenses fml30

Expense Breakdown

Largest costs and spending trends.

ice skating rink financial model summary fml30

Financial Summary

Annual and monthly financial performance.

ice skating rink financial model benchmarks fml30

KPI Benchmarks

Compare margins and returns to benchmarks.

Trusted by 25,000+ startup founders, investors and CPAs

Hours Back, Not Spent

Megan Carter, TX

5 star rating

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.

Scenario Planning Made Simple

Daniel Brooks, FL

4 star rating

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.

Break-Even Was Easy To See

Priya Shah, NJ

4 star rating

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.