Private School Operating and Financial ModelFree Financial Model Download
Build a private school operating model with grade-level enrollment, tuition revenue, payroll-to-revenue ratios, facility costs, and EBITDA. Supports tuition pricing strategy, campus expansion analysis, and benchmarking against peer schools.
Free download. No sign-up required.
About this model
Evaluate acquisition of a premium independent K–12 school by modeling enrollment dynamics, tuition escalation, and payroll-to-revenue ratios across a 5-year hold. This template projects student enrollment with annual intake/graduation/attrition, models tuition revenue with scholarship adjustments, and calculates staffing requirements using a student-teacher ratio that creates discrete cost steps (each new teacher adds a fixed salary cost when the ratio threshold is breached). Operating expenses include admin and support staff (% of revenue), facilities and utilities, and marketing costs.
The workbook contains enrollment roll-forward with capacity constraints, revenue sheets for tuition/enrolment fees/ancillary services, a staffing model with ROUNDUP() mechanics to capture teacher step-function costs, capex and depreciation schedules, debt amortisation, and a three-statement model. Key covenants include DSCR monitoring (typically ≥1.25x for educational borrowing) and per-student revenue/cost KPIs. The model assumes a going-concern asset (existing school acquired pre-revenue) with pre-existing campus PP&E and senior secured debt, no new debt issuance. Equity IRR is calculated from an equity cash flow stream: initial equity investment in Year 0, annual dividends, plus exit proceeds from an EV multiple applied to Year 5 EBITDA.
Target users are educational PE sponsors (Nord Anglia, GEMS, Cognita), family offices in education, and lenders evaluating premium international school acquisitions valued at $20M to $200M+.
Recolor to your brand.
Formatted to IB standards.
Named theme colors repaint the whole workbook in one click, on top of an investment-banking structure with blue inputs, black formulas, and green cross-sheet links.
- Brand-ready
- Institutional grade
- Fully auditable
What's included
- Student enrollment by grade level and retention rates
- Tuition pricing and revenue escalation assumptions
- Teacher and staff salary scales and staffing ratios
- Facility lease or ownership costs and maintenance
- Admissions, marketing expenses, and operating margin analysis
Enrollment-based revenue model
Link student enrollment by grade to tuition revenue and show sensitivity to attrition rates and annual pricing decisions.
Payroll and staffing architecture
Model teacher-to-student ratios, salary scales, and benefits to forecast compensation as a percentage of tuition revenue.
Campus expansion and breakeven analysis
Model enrollment ramp, breakeven analysis, and payback on campus capex to evaluate growth opportunities at existing or new locations.
Frequently asked
What is a private school financial model?+
A model that forecasts enrollment, tuition revenue, payroll, facility costs, and operating margin for an independent school, used by operators, investors, and boards.
What is a typical teacher-to-student ratio?+
Ratios range from 1:8 in early grades to 1:15 in secondary school, depending on pedagogy, grade level, and accreditation requirements.
How do I forecast student retention?+
Use historical attrition rates by grade, adjusted for competitive dynamics and planned program improvements that increase enrollment stickiness.
Can I model financial aid and scholarship programs?+
Yes. The model tracks gross tuition revenue and deducts scholarships and financial aid as a percentage of revenue or on a per-enrollment basis.
How do I model a new campus or grade expansion?+
The model supports enrollment ramp assumptions for new grades or campuses, showing incremental revenue, additional headcount, and breakeven timeline.
Alex Tapio
Founder of Finamodel • Professional Financial Modeller • Ex-Deloitte
Related templates
Hospital Operating Model
Operating model for hospital systems including inpatient/outpatient volumes, payer mix, DRG reimbursement, and staffing cost drivers.
Senior Living Facility Economics Model
Operating model for senior living communities with unit mix, occupancy, care levels, staffing, and profitability analysis.
University Endowment Model
Model endowment allocation, spending policy, and required returns to sustain university operations.
Gym and Fitness Studio Operating Model
Operating model for fitness franchises and independent gyms including membership revenue, class scheduling, and facility utilization.