Tuition and capacity planning
Revenue and Calc combine lesson-hour availability, utilization, seasonality, service mix and hourly rates into the monthly tuition forecast.
Music School 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
The Music School Financial Model is an Excel template for planning monthly tuition revenue, teacher payroll, operating expenses, startup investment, and financial statements for an independent music school. The illustrative 2026–2030 case models a six-room, one-to-one teaching business in San Antonio, Texas, in U.S. dollars.
Room-hour capacity rather than an invented student count drives the revenue forecast. The school offers piano, guitar, voice, violin and drum lessons billed as prepaid monthly teaching hours, without instrument retail, rentals, degree programs or additional recital revenue.
- Teaching rooms
- 6private lesson rooms
- Lesson types
- 5one-to-one disciplines
- Service weeks
- 50per operating year
- Forecast
- 5years, 2026 to 2030
WHAT IS INCLUDED
What Is Included in the Excel Model?
The workbook links teaching capacity and tuition assumptions to monthly costs, financial statements, funding schedules and decision reports.
Personnel and operating costs
Payroll plans teachers, the director and administration by role; COGS & OPEX separates consumables, revenue-linked charges and fixed premises expenses.
Investment and statements
CAPEX, CapTable and Debt organize asset spending and financing inputs, with IS, CF and BS translating the calculations into projected financial statements.
Management review and checks
Dashboard, Scenarios, Summary, Returns and Checks support case comparisons, break-even and investment analysis, financial review and model reconciliations.
REVENUE FORECAST
How Does the Music School Forecast Tuition?
Annual tuition comes from available room-hours, utilization, normalized seasonal demand, lesson category mix and the hourly teaching price.
Six rooms with 32 bookable hours per week over 50 teaching weeks provide 9,600 available room-hours annually. Utilization grows from 45% in 2026 to 78% in 2030, giving 4,320 and 7,488 annual paid lesson-hours, respectively, in the example.
The five shares total 100%: piano 35% at $80 per hour, guitar 20% at $75, voice 20% at $85, violin 15% at $90 and drums 10% at $80. This mix produces a $81.50 weighted hourly tuition rate.
Revenue Forecast
The Revenue Forecast organizes available teaching hours, forecast utilization, seasonal weighting and the five tuition categories. Its inputs feed Calc, which allocates lesson activity and tuition revenue across the forecast months.
2026 illustrative annual tuition
9,600 bookable room-hours × 45% utilization × $81.50 average tuition = $352,080 annual revenue.
June and July each have a 0.80 seasonal multiplier, while several school-year months use 1.05. The full twelve-month multiplier profile averages 1.00, redistributing prepaid tuition across months without adding to annual room capacity.
COSTS AND STAFFING
How Are Teaching Costs and Payroll Modeled?
The case deducts direct consumables, revenue-linked fees, fixed operating costs and separately budgeted base salaries to calculate EBITDA.
COGS and Operating Expenses
The COGS and Operating Expenses forecast sets teaching consumables at 1% of tuition, payment processing at 3%, and ongoing student marketing at 2%. Its fixed categories cover rent, utilities, insurance, software, cleaning and other school operating expenses.
Fixed nonpayroll costs total $83,400 annually, including estimated rent and premises charges of $4,500 per month. These costs are independent of enrollment in the selected case; salaries belong only in the separate Payroll schedule.
Payroll Forecast by Staff Role
The Payroll Forecast models fixed base pay and annual-average FTE for teachers, the director and the enrollment administrator. The plan assumes approximately 5.19 teacher FTE, 0.8 director FTE and 0.5 administrator FTE, with $388,000 total annual payroll.
Teachers receive base pay for reserved teaching schedules, vacancies and paid preparation, not commissions per lesson sold. As a result, payroll stays high during the 2026–2027 enrollment ramp; employer payroll taxes, employee benefits and personal taxes are excluded from the stated example.
STARTUP AND FUNDING
What Startup Investment Does the Case Include?
Opening investment combines teaching assets, preopening cash payments, initial stock and a reserve rather than treating startup spending as EBITDA expense.
Capital Expenditure Plan
The Capital Expenditure Plan records $78,000 of opening assets: $18,000 for teaching instruments, $45,000 for sound isolation and improvements, $9,000 for furniture and $6,000 for computers, audio and security hardware.
Separate preopening cash items total $34,500, covering the refundable deposit, formation, launch, staff setup, occupancy and branding. Working-capital controls assume zero receivable days, zero payable days and 14 inventory days; tuition is prepaid monthly.
Sources and Uses of Funds
The Sources and Uses of Funds report reconciles planned financing with opening spending and retained cash. The case includes $235,766 estimated initial owner funding, allocated to assets, other opening cash, about $135 in stock and a $123,131 three-month policy reserve.
FIVE-YEAR PROJECTIONS
What Does the Illustrated Forecast Produce?
The example generates higher tuition as room utilization rises and first reaches positive annual EBITDA in 2028.
| Year | Revenue | Operating Expenses | EBITDA |
|---|---|---|---|
| 2026 | $352,080 | $492,525 | -$140,445 |
| 2027 | $430,320 | $497,219 | -$66,899 |
| 2028 | $508,560 | $501,914 | $6,646 |
| 2029 | $563,328 | $505,200 | $58,128 |
| 2030 | $610,272 | $508,016 | $102,256 |
Illustrative projections rounded to whole dollars; displayed rows may not add exactly because calculations retain cents.
In this case, utilization increases every year while room count, available weekly hours and stated teaching prices remain fixed. 2028 EBITDA of $6,646 is operating earnings before depreciation, interest and tax, not net profit, free cash flow or an investment payback estimate.
The workbook has IS, BS and Summary reports for broader accounting projections, but the supplied case confirms only the annual revenue, total operating expenses and EBITDA amounts shown. No net earnings, balance-sheet totals or closing cash amounts are inferred here.
Cash Flow Forecast
The Cash Flow Forecast traces tuition receipts, operating payments, asset spending and equity or debt financing into month-by-month liquidity. Its reconciliations help test whether enrollment-ramp losses and preopening expenditures create a funding shortage.
Dashboard Scenario Controls allow Low, Base and High assumptions for revenue, COGS, variable expenses, fixed expenses and payroll. The Scenarios report compares operating outcomes, including EBITDA, when those drivers change; alternative scenarios have no asserted results here.
BREAK-EVEN AND RETURNS
How Can You Evaluate Break-Even and Payback?
Returns tools distinguish covering operating costs from achieving positive cash flow and recovering upfront invested capital.
Break-Even, Payback and ROIC
The Returns analysis covers revenue break-even, cash break-even timing, project investment payback and annual return on invested capital (ROIC). These are distinct tests: the modeled shift to positive EBITDA in 2028 does not establish a payback month or ROIC percentage.
Sales break-even asks how much tuition must cover the operating cost base; cash break-even asks when the business stops consuming net cash. Payback tracks cumulative project free cash flow against investment, while annual ROIC compares after-tax operating profit with invested capital.
The Dashboard also includes four debt facility controls, and the workbook has financing schedules and valuation sensitivity analysis. This example includes no committed outside borrowing, so any debt-funded growth, valuation or investment return needs separate assumptions and review.
HOW TO USE THE MODEL
Who Is This Music School Template For?
It is suited to owners and financial planners evaluating private-lesson capacity, teacher commitments and startup funding.
Use the model to test hourly tuition, room utilization, summer demand and staffing commitments before signing a long-term lease or increasing teaching capacity. Its six-room, 2,000-square-foot case begins January 31, 2026 and excludes instrument sales, degree credentials and recital income.
All 2026–2030 figures are illustrative planning estimates rather than observed San Antonio operating results or verified industry averages. Replace the example costs, tuition and enrollment ramp with your own assumptions, and check liquidity rather than relying on positive EBITDA alone.
FREQUENTLY ASKED QUESTIONS
Questions About the Music School Financial Model
Quick answers about editing the model, billing lessons, staffing commitments and interpreting the financial projections.
Can I change tuition rates and lesson mix?
Yes. Edit each discipline’s hourly tuition and percentage mix along with room capacity, utilization and seasonality to recalculate monthly and annual revenue.
How does the school bill its students?
The example assumes prepaid monthly lesson-hour tuition for five private-lesson categories, not separate instrument rentals, retail sales, registration or recital charges.
Do teachers get paid during vacant hours?
Yes. The illustrated fixed base-pay schedule covers reserved teaching time, vacancies and four weekly preparation hours rather than commissions tied to delivered lessons.
Are payroll taxes and benefits included?
No. The supplied operating assumptions exclude employer taxes and benefits, although the wider workbook contains payroll-tax inputs that can be configured.
Is the initial owner funding sufficient?
Not established. The $123,131 policy reserve is smaller than the first two years’ combined EBITDA losses, and peak monthly cash needs were not tested.
When does the example become EBITDA-positive?
In 2028, with illustrative EBITDA of $6,646. This is not the same as positive net income, cash break-even or recovery of the startup investment.
Are cash flow and scenarios included?
Yes. CF models monthly cash flows and Dashboard Scenario Controls compare Low, Base and High revenue and cost assumptions; resulting cash balances are not specified in the case.
What Does the Music School 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
Hours Saved On Forecasts
Building the model from scratch would've eaten days, and this template cut that down fast. I had a clean first draft in under an hour and could finally focus on enrollment assumptions instead of formulas.
Scenario Planning Made Simple
I used to dread building low, base, and high cases by hand. This template made the scenario setup much clearer, and I was able to compare all three in one meeting without reshuffling the sheet.
Cash Flow Looked Clearer
I could see runway and shortfalls much earlier with this model, which made planning feel a lot less shaky. It helped me spot a cash gap three months sooner and adjust tuition timing before it became a problem.