No More Spreadsheet Guessing
One broken cell used to throw off my whole projection, and this template made the formulas easy to trust. I spent less time tracing errors and more time reviewing the plan.
One broken cell used to throw off my whole projection, and this template made the formulas easy to trust. I spent less time tracing errors and more time reviewing the plan.
Before this, pricing, payroll, and enrollment growth were scattered across notes and tabs. Now the assumptions are in one place, and I cut my planning time by about 6 hours.
I am not strong in Excel, so advanced modeling usually feels out of reach. This file was straightforward enough that I could update it myself and book a lender meeting the same day.
This editable Excel models dance class space, coverings, monthly fees, additional incomes, five-year forecasts, financial statements, scenarios and reporting of dashboards.
Use the model to plan a dance school around limited capacity of monthly classes, covering, group prices, extra income, costs, staff, capital needs and funding.
Editable assumptions are the basis of monthly calculations and are included in annual forecasts, three financial statements, comparisons of scenarios and management reports throughout the five-year forecast.
The revenue starts with the available seats by group, covers the occupancy, the prices of the seats occupied, adds optional additional revenue and then brings the months active in annual amounts.
Define available sites by group, start time, active months and planned add-on capabilities.
Multiplying sites at the population rate or ramps per group.
Multiplied places occupied by the monthly fee for the occupied place for basic income.
Adds additional monthly income to the occupied place and sums up revenue in different groups.
Total of active monthly revenues on an annual basis after launch, the occupancy ramp and any seasonality patterns.
The revenue working sheet organises a schedule of mobilisation, class capacity by group, enrolment, monthly fees and additional revenue which form the basis for the calculation of the capacity to occupy.
REVENUE
The COGS & OPEX worksheet separates direct costs, variable expenditure and fixed operating costs from time and periodicity control for forecast planning.
COGS & OPEX
The Scenarios compared low, base and high cases of five-year revenues, gross margin, premium margins and trends of EBITDA to the analysis of the decision.
SCENARIOS
The board contains global settings, scenario controls, key finances, revenue mix, profitability, cash flow and return on investment in one management view.
DASHBOARD
The model is designed to fit dance schools that sell limited seats per month, while structurally different revenue logic, schedules, or reporting may require custom modeling.
The template is the starting point of planning, not a guarantee of performance.
The Lab financial models can build or adapt a model when you need different revenue logic, operational schedules or financial reporting.
ORDER A CUSTOM FINANCIAL MODELAfter the order you will receive an editable Excel workbook for monthly and annual planning, with scenarios, statements and management reports.
Change the provided operational and financial assumptions to match the planned dance school.
Review of monthly and annual projections under the five-year horizon for model planning.
Compare low, base and high revenue, margin and EBITDA.
Use income account, cash flow, balance sheet, dashboard and summary results.
The basic answers are visible in their entirety, without clicking on the accordion.
It multiplys available seats by betting, prices occupied by monthly fees, adds additional revenue and adds up active monthly income in different groups.
You can change the start date, places by group, location, monthly fees, additional revenue, bandwidth, category definitions, active months and seasonality when used.
The Scenarios’ opinion compares three cases in the five years of income, gross margin, premium margins and trends of EBITDA.
The workbook contains a statement of income, a statement of cash flows, a balance sheet, a navigational desk, scenarios, a summary and additional financial statements shown in the workbook gallery.
Yes. The financial models Lab offers custom financial modelling for various revenue logic, operational schedules, or reporting requirements.
This is a forecast based on the possible editing assumptions, not a guarantee of the results of business activity or financial results.
This pre-written dance school financial projection template provides everything you need to build a complete financial plan, from initial startup costs to five-year profit forecasts and cash flow statements.
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