Excel financial planning template for dance studio. The online worksheet illustrations use a separate website scenario; review the selected product's file specification and delivery terms before buying.
4 online worksheet illustrations, described below
Opening budget, scenario assumptions and dashboard views
Online five-year scenario and monthly operating sensitivity
Excel template sold separately; review the selected file specification
The online preview illustrates 4 planning sections using this website's scenario. These illustrations are separate from the downloadable workbook.
01Revenue and tuition inputsThe product-specific preview uses group places, occupancy and monthly fees, with optional extra monthly revenue per place. Our tuition calendar requires a separate billing-to-lessons bridge.Explore layout ↓
02Payroll and operating costsThe listed Payroll and COGS/OPEX areas support staffing and recurring expenses. StartFigures separately funds owner work, hired teaching, reception, burden and cover.Explore layout ↓
03Opening capital and fundingThe listed CAPEX, Capital and financing areas organize opening investment and funding. Reserve cash and construction contingency serve separate purposes.Explore layout ↓
04Financial statements and scenariosThe matching description lists five-year reporting, financial statements and Low, Base and High scenarios. The website's operating forecast is an independently authored case.Explore layout ↓
Explore the online worksheet illustrations
Open each section to read the operating assumptions and illustration. These web views are not screenshots or downloadable Excel files.
Dance StudioHTML illustration
EBITDA = Revenue − operating costs
Illustrative workbook layout · annual USD
Income statement
Year 1
Year 2
Year 3
Revenue
$176,752
$243,796
$243,796
Payment fees and lesson-linked supplies
$10,605
$14,628
$14,628
Owner, instructors, reception, burden and cover
$120,000
$120,000
$120,000
Rent, utilities, cleaning and operating overhead
$84,000
$84,000
$84,000
EBITDA
−$37,853
$25,168
$25,168
EBITDA margin
-21.4%
10.3%
10.3%
Online scenario illustration; not a screenshot of the purchased workbook. Costs are shown as positive outflows; EBITDA excludes interest, tax, depreciation and amortization.
01Revenue and tuition inputsOperating assumptions
Revenue and tuition inputs
Scenario purpose: The product-specific preview uses group places, occupancy and monthly fees, with optional extra monthly revenue per place. Our tuition calendar requires a separate billing-to-lessons bridge.
Inputs
Opening date and active or billable periods
Places by enrollment group and occupied share
Monthly tuition and optional additional revenue per occupied place
Published teaching calendar and installment terms for this case
Outputs
Modeled occupied billing places and group tuition
Revenue by period and scenario
Scope and limitations
Preview inputs and page description were inspected; native workbook cell formulas and delivered files were not audited
Set extra revenue to zero for this instruction-only case
Ten installments and thirty-six taught weeks are authored case inputs, not copied workbook defaults
02Payroll and operating costsOperating assumptions
Payroll and operating costs
Scenario purpose: The listed Payroll and COGS/OPEX areas support staffing and recurring expenses. StartFigures separately funds owner work, hired teaching, reception, burden and cover.
Inputs
Paid owner role and scheduled hired teaching
Preparation, turnover and reception hours
Employer costs, substitute cover and recurring overhead
Processing and lesson-linked supplies
Outputs
Paid staffing cost and operating expense forecast
Coverage against contribution from tuition
Scope and limitations
The case's wages, burden and lease expense require local offers and quotes
A staffed class timetable does not establish paid independent management
03Opening capital and fundingOperating assumptions
Opening capital and funding
Scenario purpose: The listed CAPEX, Capital and financing areas organize opening investment and funding. Reserve cash and construction contingency serve separate purposes.
Inputs
Dance floor, alterations, equipment and setup uses
Deposits, pre-opening activity, contingency and operating reserve
Funding sources and cash timing
Outputs
Opening funding requirement and modeled cash needs
Capital and financing schedules
Scope and limitations
This case assumes no borrowing or property purchase
Vendor floor prices are materials context rather than a complete construction quote
Native financing formulas were not audited
04Financial statements and scenariosOperating assumptions
Financial statements and scenarios
Scenario purpose: The matching description lists five-year reporting, financial statements and Low, Base and High scenarios. The website's operating forecast is an independently authored case.
Inputs
Tuition, occupied places, calendar and ramp
Staffing, recurring costs, capital and financing assumptions
Selected scenario changes
Outputs
Forecast income statement, cash flow and balance sheet
Dashboard and scenario comparisons
Scope and limitations
The website's EBITDA-style result excludes depreciation, debt, income tax, replacement capital and distributions
Annualized calculator months do not establish seasonal cash receipts
The visible preview and description are not a formula-level audit of purchased attachments
Ways to prepare your files
Template
Current product · Shopify checkout
Edit the financial model with your own assumptions.
Define the revenue drivers, operating modules, outputs and review criteria before agreeing the work.
Project quote · Schedule agreed with you
Assumptions you can change
Use the Excel template to compare your financial assumptions. Review the selected version's input structure and outputs before adapting it. The online inputs and outputs on this page explain this website's price, volume, cost and opening-budget assumptions; they do not edit or verify a workbook. Range endpoints represent modeled scopes or sensitivities, not measured national averages.
Neither template establishes local demand, licensing compliance, financing approval or available owner cash.
Dance Studio input assumptions · USD unless stated
Driver
Base input
Scenario range / treatment
Role in the calculation
Realized tuition per paid scheduled lesson place
$23.00
$18.00 – $27.00
Revenue per sold unit
Annualized paid lesson places per equivalent open day
34
22 – 40
Daily throughput in the stated operating scope
Operating days per week
6
5 – 6
Trading schedule
Fixed operating costs / month
$17,000
Held constant
Operating break-even threshold
Contribution margin
94.0%
Held constant
Share of sales available for fixed costs
Starting share of mature volume
45.0%
Base ramp input
Opening month revenue
Mature volume added / month
5.0%
Base ramp input
Monthly ramp increment, capped at mature volume
Ramp horizon
24 months
Base ramp input
Period checked for operating break-even
The opening budget and annual expense inputs also need local quotes and staffing estimates. This page shows fixed examples; the free calculator lets you change price, volume and trading days.
Volume-only sensitivity · revenue at mature volume · monthly USD
Scenario
Daily units
Monthly revenue
Break-even revenue
First operating break-even
Lower volume
22
$13,146
$18,085
Not reached
Base volume
34
$20,316
$18,085
Month 10
Higher volume
40
$23,902
$18,085
Month 8
Only annualized paid lesson places per equivalent open day changes. Realized tuition per paid scheduled lesson place: $23.00; 6 operating days per week. Fixed costs and contribution margin stay constant. “Not reached” means no operating break-even within the 24-month ramp. Years 1–3 and the opening calculator ramp use one operating base within whole-dollar rounding. Years 4–5 follow the stated annual assumptions. Slider cases do not change the annual forecast or measure cash payback.
Sample outputs from the current case
These results are calculated from the website’s illustrative assumptions. They illustrate planning calculations; they do not establish the purchased workbook’s formula behavior.
01 / Annual forecast
Revenue across five years
$176.8k
Year 1
$243.8k
Year 2
$243.8k
Year 3
$256.4k
Year 4
$269.4k
Year 5
Annual USD. Full values appear in the Dashboard presentation.
02 / Opening allocation
Where the opening budget goes
Site alterations and professional dance-floor assembly$68,000
Mirrors, barres and audio equipment$16,000
Design, permits, legal and insurance setup$10,000
Lease deposit and pre-opening occupancy$12,000
Reception, storage, booking, website and security setup$12,000
Pre-opening payroll, training and launch marketing$10,000
Construction and opening contingency$12,000
Operating cash reserve$90,000
One-time budget: $230,000. This allocation is not a cumulative cash-flow forecast.
03 / Operating earnings
Year 3 costs and EBITDA
Against annual revenue of $243,796.
Payment fees and lesson-linked supplies$14,628
Owner, instructors, reception, burden and cover$120,000
Rent, utilities, cleaning and operating overhead$84,000
EBITDA$25,168
EBITDA margin: 10.3%. EBITDA is not cash available to the owner.
04 / Operating threshold
Volume needed to break even
Required whole units per day
31
Break-even revenue / month
$18,085
Base revenue / month at maturity
$20,316
First operating break-even
Month 10
Units mean annualized paid lesson places per equivalent open day. The ramp covers 24 months; operating break-even does not measure recovery of opening capital.
Years 1–3 and the opening calculator ramp use one operating base within whole-dollar rounding. Years 4–5 follow the stated annual assumptions. The website does not yet supply a complete funding, debt, tax and working-capital schedule for a cumulative cash-flow or payback chart. Read the full input basis and limitations.
Annual forecast and monthly operating reconciliation
Years 1–3 and the opening calculator ramp use one operating base within whole-dollar rounding. Years 4–5 follow the stated annual assumptions.
Original inputs · annual USD · whole-dollar rounding tolerance $5
Check
Annual forecast
Monthly calculator base
Year 1 revenue
$176,752
$176,752
Year 1 operating result
−$37,853
−$37,853
Year 2 revenue
$243,796
$243,796
Year 2 operating result
$25,168
$25,169
Year 3 revenue
$243,796
$243,796
Year 3 operating result
$25,168
$25,169
Year 3 / full-volume annual revenue
$243,796
$243,796
Year 3 / full-volume annual operating result
$25,168
$25,169
Year 1 uses months 1–12, Year 2 months 13–24 and Year 3 months 25–36. Full-volume rows use mature monthly sales and operating result × 12. The calculator holds price, days, contribution and fixed costs constant; an annual price, staffing or cost change can explain a separate path. Sliders do not change this comparison. Neither column measures cash flow, owner distributions or payback. Agreement tests arithmetic, not demand or cash funding. Input basis.
Both products in one cart
Model + Business Plan
Write the strategy and test the assumptions for your dance studio together. Update the narrative when you change the forecast.
The Business Plan uses Word and the Financial Model uses Excel. The online illustrations use this website's scenario data and may differ from the purchased files.
Listed file format
XLSX
Editor
Microsoft Excel
Editing
Adapt forecast assumptions in Excel. Check the selected version's forecast length, worksheets and formula permissions; the online illustrations use a separate scenario.
Other software
Compatibility with alternative editors has not been verified.
Delivery and terms
Review the product description, delivery details, license and final total in Shopify before paying.
Use the purchase button to buy the Dance Studio Financial Model for $109 through Shopify. This is a one-time price in USD before any applicable taxes.
What do the online previews show?
The online preview explains Revenue and tuition inputs, Payroll and operating costs, Opening capital and funding, Financial statements and scenarios using this website's illustrative case. It is separate from the downloadable Excel model.
Are these previews pages from a finished file?
The web previews are rendered from the website's case record. They illustrate planning concepts and calculations; they are not screenshots or a page-by-page inventory of the downloadable product.
What would I need to change for my business?
Review realized tuition per paid scheduled lesson place, annualized paid lesson places per equivalent open day, the operating schedule, opening budget and costs. These web previews do not edit a workbook. Test the website's price and volume assumptions in the business idea page's calculator.
Is the written business plan included?
The Financial Model is sold separately. The $168 Bundle adds the $59 Business Plan and $109 Financial Model for the same business to one cart, one of each.
Do the figures establish what my business will earn?
No. The figures describe an illustrative U.S. operating case, not measured industry averages or a prediction for your location. EBITDA is not owner cash, and operating break-even does not recover the opening investment. Check local costs, capacity and demand before using the assumptions.
Do the web previews reproduce the purchased files?
The online outlines, tables and worksheet illustrations use this website's scenario. They are not screenshots, a verified page count or a confirmed worksheet inventory of the purchased files. Check the selected product's specification before buying.
How are the files delivered?
Review the selected item's delivery method and license in Shopify before paying. These pages do not document a completed purchase or download test.
