Excel financial planning template for music school. The online worksheet illustrations use a separate website scenario; review the selected product's file specification and delivery terms before buying.
6 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 6 planning sections using this website's scenario. These illustrations are separate from the downloadable workbook.
01RevenueThe actual Revenue preview shows occupied places by lesson category and monthly fees. For this private-lesson adaptation, each place is one recurring weekly slot; extra income is zero.Explore layout ↓
02COGS & OPEXThe current seller page and Revenue navigation show direct, variable and fixed cost schedules. Keep student-linked materials/processing separate from the committed paid teaching roster.Explore layout ↓
03PayrollThe visible Payroll tab and seller description provide a staff-cost planning schedule. Adapt it to the complete paid instructor and owner week, with substitute cover.Explore layout ↓
04CAPEX and capital fundingThe visible CAPEX, CapTable and Capital tabs support opening-investment and funding inputs; this online case separates setup commitments from held operating cash.Explore layout ↓
05ScenariosThe seller page confirms low/base/high comparison and the visible Scenarios tab. Test net tuition, occupied weekly places, cost commitments and a slower ramp within physical capacity.Explore layout ↓
06Statements and dashboardCurrent seller content describes five-year monthly/annual reporting, income statement, cash flow, balance sheet and dashboard; the preview visibly includes IS, CF, BS, Summary and Dashboard tabs.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.
Music SchoolHTML illustration
EBITDA = Revenue − operating costs
Illustrative workbook layout · annual USD
Income statement
Year 1
Year 2
Year 3
Revenue
$297,540
$410,400
$410,400
Student-linked materials and collection costs
$14,877
$20,520
$20,520
Paid instructors, working owner and substitute cover
$268,800
$268,800
$268,800
Year-round premises, systems and operating overhead
$66,000
$66,000
$66,000
EBITDA
−$52,137
$55,080
$55,080
EBITDA margin
-17.5%
13.4%
13.4%
Online scenario illustration; not a screenshot of the purchased workbook. Costs are shown as positive outflows; EBITDA excludes interest, tax, depreciation and amortization.
01RevenueOperating assumptions
Revenue
Scenario purpose: The actual Revenue preview shows occupied places by lesson category and monthly fees. For this private-lesson adaptation, each place is one recurring weekly slot; extra income is zero.
Inputs
Opening date
Available weekly places by compatible category
Occupancy assumptions
Monthly tuition per occupied place
Extra monthly revenue per place
Outputs
Occupied places
Monthly tuition revenue
Annual revenue path
Scope and limitations
Displayed categories use group instruction; relabel and constrain them for private weekly slots.
A student is not counted again every teaching day.
Teacher, room, makeup, withdrawal and refund schedules were not verified in the native workbook.
02COGS & OPEXOperating assumptions
COGS & OPEX
Scenario purpose: The current seller page and Revenue navigation show direct, variable and fixed cost schedules. Keep student-linked materials/processing separate from the committed paid teaching roster.
Inputs
Student-linked materials
Payment channel and fees
Year-round lease and systems
Maintenance and other operating costs
Outputs
Direct costs
Variable expenses
Fixed operating expenses
Scope and limitations
The online selected cost share is not a vendor quote.
Scheduled teaching payroll belongs once in the paid roster; replacement capital needs separate cash timing.
03PayrollOperating assumptions
Payroll
Scenario purpose: The visible Payroll tab and seller description provide a staff-cost planning schedule. Adapt it to the complete paid instructor and owner week, with substitute cover.
Inputs
Instructor pay and whole paid hours
Owner compensation
Employer costs
Paid weeks and leave
Substitute clock-hours and rate
Outputs
Gross and burdened payroll
Monthly staffing cost
Scope and limitations
No native teacher-to-room scheduling, instrument matching or labor-classification checker was verified.
Budgeted substitutes do not prove qualified availability or owner-management backup.
04CAPEX and capital fundingOperating assumptions
CAPEX and capital funding
Scenario purpose: The visible CAPEX, CapTable and Capital tabs support opening-investment and funding inputs; this online case separates setup commitments from held operating cash.
Inputs
Instrument and premises opening uses
Deposits and contingency
Operating reserve
Debt/equity and opening balances
Outputs
Opening funding questions
Capital expenditure and financing projections
Scope and limitations
Complete native formulas and attachments were not audited.
Do not count the reserve, loan proceeds or deposits as tuition revenue or duplicate operating expenses.
05ScenariosOperating assumptions
Scenarios
Scenario purpose: The seller page confirms low/base/high comparison and the visible Scenarios tab. Test net tuition, occupied weekly places, cost commitments and a slower ramp within physical capacity.
Inputs
Low/base/high tuition and occupancy
Cost and pay sensitivities
Opening timing and reserve
Outputs
Revenue comparisons
Gross and contribution margins
EBITDA comparisons
Scope and limitations
No retained-student cohort, peak-time calendar or refund/liability adapter was verified.
A scenario is not a probability, local demand measure or funding guarantee.
06Statements and dashboardOperating assumptions
Statements and dashboard
Scenario purpose: Current seller content describes five-year monthly/annual reporting, income statement, cash flow, balance sheet and dashboard; the preview visibly includes IS, CF, BS, Summary and Dashboard tabs.
Inputs
Selected operating case
Asset and financing terms
Recognition, refunds and cash timing
Opening balances and taxes
Outputs
Income statement
Cash flow
Balance sheet
Summary and dashboard
Scope and limitations
Page and gallery evidence establish seller-described modules, not a native formula audit or completed paid delivery.
A positive operating proxy does not establish owner distributions, investment payback or ability to fulfill the lesson contract.
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.
Music School input assumptions · USD unless stated
Driver
Base input
Scenario range / treatment
Role in the calculation
Tuition per reference lesson equivalent
$43.879908
$34.642032 – $48.498845
Revenue per sold unit
Reference lesson equivalents per day, school-wide
30
25 – 33
Daily throughput in the stated operating scope
Operating days per week
6
6 – 6
Trading schedule
Fixed operating costs / month
$27,900
Held constant
Operating break-even threshold
Contribution margin
95.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
25
$28,500
$29,368
Not reached
Base volume
30
$34,200
$29,368
Month 10
Higher volume
33
$37,620
$29,368
Month 8
Only reference lesson equivalents per day, school-wide changes. Tuition per reference lesson equivalent: $43.879908; 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
$297.5k
Year 1
$410.4k
Year 2
$410.4k
Year 3
$437.5k
Year 4
$465.4k
Year 5
Annual USD. Full values appear in the Dashboard presentation.
02 / Opening allocation
Where the opening budget goes
Teaching-room, acoustic and access work$35,000
Instruments, teaching equipment and furniture$23,000
Lease deposits and preopening rent$15,000
Permissions, legal, insurance setup and recruitment$6,000
Billing, website, office and security setup$5,000
Paid onboarding, initial materials and launch outreach$11,000
Setup contingency$5,000
Operating cash reserve$85,000
One-time budget: $185,000. This allocation is not a cumulative cash-flow forecast.
03 / Operating earnings
Year 3 costs and EBITDA
Against annual revenue of $410,400.
Student-linked materials and collection costs$20,520
Paid instructors, working owner and substitute cover$268,800
Year-round premises, systems and operating overhead$66,000
EBITDA$55,080
EBITDA margin: 13.4%. EBITDA is not cash available to the owner.
04 / Operating threshold
Volume needed to break even
Required whole units per day
26
Break-even revenue / month
$29,368
Base revenue / month at maturity
$34,200
First operating break-even
Month 10
Units mean reference lesson equivalents per day, school-wide. 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
$297,540
$297,540
Year 1 operating result
−$52,137
−$52,137
Year 2 revenue
$410,400
$410,400
Year 2 operating result
$55,080
$55,080
Year 3 revenue
$410,400
$410,400
Year 3 operating result
$55,080
$55,080
Year 3 / full-volume annual revenue
$410,400
$410,400
Year 3 / full-volume annual operating result
$55,080
$55,080
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 music school 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 Music School 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, COGS & OPEX, Payroll, CAPEX and capital funding, Scenarios, Statements and dashboard 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 tuition per reference lesson equivalent, reference lesson equivalents per day, school-wide, 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.
