Set Capacity
Enter available places for each lesson group and planned capacity additions.
It is an editable five-year financial model for Excel and Google Sheets, linking lesson capacity, occupancy, fees, costs, scenarios, and statements.
Use the model to plan how available lesson places, occupancy, pricing, and capacity additions translate into monthly operating and financial results.
Editable assumptions flow through revenue, COGS and operating expenses, staffing and capital schedules, then into scenario analysis and the core statements.
Revenue comes from occupied lesson places multiplied by monthly fees, plus optional extra revenue per occupied place across active groups and months.
Enter available places for each lesson group and planned capacity additions.
Multiply available places by the occupancy rate or occupancy ramp.
Multiply occupied places by the monthly fee for each group.
Add extra monthly revenue per occupied place when that input is enabled.
Sum group revenue across active months after launch timing and any seasonal pattern.
The Revenue worksheet lets you set launch timing, lesson-group places, occupancy, monthly fees, and extra revenue used to calculate monthly sales.
REVENUE
The COGS & OPEX worksheet separates direct costs, variable expenses, and recurring fixed spending across the forecast.
COGS & OPEX
The Scenarios worksheet compares Low, Base, and High results for revenue, gross margin, contribution margin, and EBITDA over five years.
SCENARIOS
The Dashboard combines model setup, scenario multipliers, key metrics, core financials, cash flow, revenue mix, profitability, and investment payback charts.
DASHBOARD
It fits lesson businesses driven by finite places, occupancy, monthly fees, and optional ancillary revenue; materially different operating logic may need custom modeling.
The template is a planning starting point, not a guarantee of performance.
Financial Models Lab can build or adapt a model when your revenue logic, operating schedules, or reporting requirements need a different structure.
ORDER A CUSTOM FINANCIAL MODELYou receive an instantly downloadable, editable Excel financial model with five-year monthly and annual projections, scenarios, and financial statements.
Update lesson capacity, occupancy, pricing, costs, staffing, capital, and other model assumptions.
Review monthly and annual projections across the model’s five-year forecast horizon.
Compare Low, Base, and High cases across revenue, margins, and EBITDA.
Review projected income statement, cash flow, balance sheet, summary, and management outputs.
The essential answers are visible in full, with no accordion clicks required.
It multiplies available places by occupancy, then applies monthly fees and optional extra revenue per occupied place across active lesson groups.
You can change launch timing, places by group, occupancy, monthly fees, extra revenue, capacity additions, active months, and seasonality when used.
You can compare how the three cases change revenue, gross margin, contribution margin, and EBITDA over the forecast.
The product shows projected income statement, cash flow, balance sheet, summary reporting, dashboard metrics, and additional financial analysis views.
Yes. Financial Models Lab offers custom modeling when you need different revenue logic, operating schedules, or reporting.
It is a planning forecast based on editable assumptions, not a guarantee of business performance or financial results.
This downloadable excel financial plan for arts teachers provides a comprehensive, all-in-one solution for planning, forecasting, and managing the finances of your ventriloquism teaching business.
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
One broken formula used to throw off the whole model, and this template kept the sheet stable while I tested inputs. I saved about 6 hours of rework and could trust the numbers before sharing them.
I wasn’t sure what investors would expect, but the structure made the key outputs obvious. It helped me pull together a cleaner deck and book a meeting with our advisor faster.
Pricing, costs, and growth were all over the place until I plugged them into this model. Everything finally sat in one place, and I cut an afternoon of spreadsheet cleanup down to under an hour.