Revenue and Calc
Set session capacity, utilization, seasonal multipliers, six visit shares and earned yields. Monthly calculations consolidate admissions into projected revenue.
Roller Skate Rink Financial Projections Template in Excel
Fully Editable
Instant Download
Professional Design
Pre-Built
No Expertise Is Needed
Fully Editable
Instant Download
Professional Design
Pre-Built
No Expertise Is Needed
Description
This Roller Skating Rink Financial Model is an Excel template forecasting admissions, revenue, expenses and EBITDA for one independent indoor rink. It links guest-place capacity and utilization to six visit classes, staffing and facility costs across 2026–2030.
The illustrative setting is a leased 20,000-square-foot suburban Raleigh–Durham rink with a 12,000-square-foot skating floor, 400 rental skate pairs, cafe and party area. Amounts are nominal U.S. dollars, net of sales tax, not observed results.
- Forecast
- 5years, 2026 to 2030
- Visit channels
- 6exclusive guest classes
- Guest capacity
- 250places per session
- Monthly sessions
- 40planned sessions
WORKBOOK CONTENTS
What Is Included in the Rink Model?
The workbook links rink-specific operating inputs to monthly calculations and financial reports, with separate controls for scenarios, investment and financing.
COGS & OPEX and Payroll
Edit food and skate consumables, payment charges, promotions, occupancy costs and role-level staffing to understand their effects on operating EBITDA.
Financial Statements
Use the Income Statement, Cash Flow Statement and Balance Sheet to assess accounting profit, movements in cash and monthly financial position.
Dashboard and Scenarios
Review annual KPIs and compare Low, Base and High multipliers for revenue and cost categories without treating scenarios as observed results.
RINK ADMISSIONS
How Does the Model Forecast Roller Rink Revenue?
Guest visits are driven by 250 practical places per skating session, 40 monthly sessions, annual utilization and a recurring monthly seasonality profile.
Utilization rises from 25% in 2026 to 47% in 2030. January has a 1.15 seasonal multiplier and June 0.85; the twelve factors total 12, redistributing monthly visits without changing annual capacity.
Each visit is allocated only once: 22% own-skate open admission, 38% rental bundles, 12% adult theme sessions, 12% birthday parties, 10% school and group visits, and a 6% residual for group lessons. Applicable rental and cafe receipts are already included in each visit yield.
Revenue Forecast
The Revenue Forecast combines session capacity, utilization, visit shares and earned yields. Monthly Calc counts the selected launch month in full, applies seasonal factors and projects each guest class without double-counting visits.
Illustrative 2026 annual revenue build
30,000 guest visits × $20.66 weighted revenue per visit = $619,800 projected 2026 revenue.
The 2026 visit count reflects 10,000 available places per month at 25% utilization, with seasonal factors averaging 1.0. The weighted $20.66 yield combines the six selected 2026 visit prices, including $15 own-skate admission and $21 rental-bundle visits.
OPERATING COSTS
How Are Rink Expenses and Staffing Calculated?
The operating model separates revenue-linked direct and variable expenses from monthly facility costs and fixed role-based payroll.
COGS is 8.5% of revenue: food ingredients 6%, party supplies 1%, sanitation 0.8% and current skate-fleet parts 0.7%. Variable expenses add 3.1% payment processing and 4% sales-linked promotion, independent of fixed occupancy costs and payroll.
COGS and Operating Expenses
The COGS and Operating Expenses report separates direct costs, variable charges and fixed items such as lease, utilities, cleaning, insurance, floor maintenance, music licensing and software. It allows expense rates and timing to be tested against the same revenue forecast.
Lease and occupancy rises from $18,000 a month in 2026 to $20,259 in 2030. Total annual fixed expenses increase from $333,000 to $374,794, excluding payroll.
Payroll Forecast by Staff Role
The Payroll Forecast lists annual-average FTE and base salary for the manager, attendants, reception and cafe staff, and party hosts and instructors. Staffing increases from 6 to 8 FTE, with annual base payroll rising from $235,000 to $306,000.
STARTUP INVESTMENT
How Much Opening Funding Is Modeled?
The example uses $742,210 of estimated initial owner funding for assets, distinct preopening payments, opening working capital and an operating reserve.
Estimated startup assets total $460,000, including a $160,000 installed skating floor, $140,000 in leasehold and safety improvements, $60,000 of rental skates and racks, and $35,000 of sound and effects lighting. Other assets cover cafe equipment, furniture, POS, security and signage.
Capital Expenditure Plan
The Capital Expenditure Plan records individual asset budgets, spending dates and depreciation treatment. Opening rink infrastructure and future equipment spending can therefore be tracked separately from recurring operating expenses and cash receipts.
Funding also covers $114,000 of prelaunch cash, $2,038 of opening net working capital and a $166,172 three-month reserve. Receivables and payables are zero days; inventory is 14 days. Peak cash requirements remain untested.
Sources and Uses of Funds
The Sources and Uses of Funds report reconciles funding entered into the workbook with operating payments, investment spending and retained cash over a selected period. The sample opening amount is owner funding, not evidence of a committed loan or available outside capital.
FIVE-YEAR OUTLOOK
What Does the Illustrative Forecast Show?
The selected assumptions produce annual revenue and operating-expense projections through EBITDA, not verified rink results or a net-profit forecast.
| Year | Revenue | Operating Expenses | EBITDA |
|---|---|---|---|
| 2026 | $619,800 | $664,689 | -$44,889 |
| 2027 | $817,144 | $724,465 | $92,680 |
| 2028 | $999,488 | $779,700 | $219,788 |
| 2029 | $1,164,973 | $835,114 | $329,859 |
| 2030 | $1,311,526 | $885,392 | $426,133 |
Illustrative planning outputs rounded to whole dollars; display rounding can create small differences.
In this example, 2026 EBITDA is a loss of $44,889 as the rink ramps up. The illustrative 2027 EBITDA turns positive at $92,680, and 2030 EBITDA reaches $426,133 as utilization and visit yields grow; these are scenario projections, not guaranteed outcomes.
Cash Flow Forecast
The Cash Flow Forecast tracks operating, investing and financing cash movements, with a reconciliation from opening to closing cash. It helps test the timing effects of capital purchases, owner contributions, optional debt and working capital, which EBITDA alone cannot show.
DECISION ANALYSIS
Can the Workbook Evaluate Break-Even and Payback?
Returns calculations distinguish revenue needed to cover costs, cash break-even timing, investment payback and annual return on invested capital.
Sales break-even measures required revenue; cash break-even considers cumulative project cash. Payback tracks recovery of invested funds, while annual ROIC measures returns relative to invested capital. No payback dates or ROIC percentages are established.
Break-Even, Payback and ROIC
The Returns report brings together sales break-even, cash break-even, project free cash flow, cumulative investment payback and annual ROIC. It provides distinct ways to assess operating scale and capital recovery without substituting an EBITDA figure for cash-based returns.
Dashboard controls compare Low, Base and High revenue and cost assumptions. Debt controls model four optional facilities; valuation uses discounted free cash flow and sensitivity analysis. None implies committed funding or a stated valuation.
MODEL FIT
Who Is This Roller Rink Template For?
The template suits planning for a single session-driven indoor skating rink with admissions, rentals, parties, groups and lessons.
Owners and advisors can test attendance, rental mix, party demand, wages and occupancy expenses for a single rink. The example excludes arcade sales, alcohol, a pro shop and memberships; replace its estimated assumptions, launch date and funding inputs before making decisions.
COMMON QUESTIONS
Roller Skating Rink Financial Model FAQ
These answers cover the operating inputs, financial statements and limitations of the template.
Can I change the rink capacity and number of sessions?
Yes. The Revenue inputs use practical guest places, sessions per month, utilization and seasonal multipliers to calculate monthly visits.
Are skate rentals and cafe sales counted separately?
No. In this example, applicable skate rental and food receipts are included once in each visit category’s average earned yield.
Can I edit the birthday, group and lesson mix?
Yes. Each guest is allocated to one of six classes, with group lessons using the residual share of projected visits.
Does the template include a cash flow statement?
Yes. The Cash Flow Statement covers operating, investing and financing cash flows and reconciles opening to closing cash.
Does the example guarantee a profitable rink?
No. The five-year figures are illustrative projections. EBITDA is not net profit, cash flow, an investment return or a guarantee.
Can I compare scenarios and financing arrangements?
Yes. Dashboard controls support Low, Base and High operating cases and four optional debt facilities with financing schedules.
Is the initial owner funding a confirmed financing offer?
No. The $742,210 opening funding is an estimated equity input, and the example has no committed external funding or tested peak cash need.
What Does the Roller Skating Rink Financial Model Contain?
Financial Dashboard
KPIs, forecasts, and cash flow at a glance.
Revenue Engine
Key assumptions and calculations driving revenue forecasts.
Sources & Uses
Funding sources, spending, and closing cash.
Returns & Break-Even
Cash break-even, payback, and ROIC.
Business Valuation
DCF valuation and sensitivity analysis.
Expense Breakdown
Largest costs and spending trends.
Financial Summary
Annual and monthly financial performance.
KPI Benchmarks
Compare margins and returns to benchmarks.
Trusted by 25,000+ startup founders, investors and CPAs
Cash Flow Got Easier
This template helped me map runway and spot shortfalls before they became a problem, so I could plan funding with more confidence. I saved about 6 hours of guesswork in the first week.
No More Blank Spreadsheet
I was stuck staring at an empty file, and this gave me a clear starting point fast. I had a full first pass of the model done in an afternoon instead of spending days building from scratch.
Cleaner Assumptions, Faster Planning
All the pricing, cost, and growth inputs were finally in one place, which made the model much easier to follow. I cut my assumption cleanup time by half and could explain the numbers without digging through tabs.