# Private School Operating and Financial Model 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. - Canonical: https://finamodel.com/templates/private-school-model - Excel download: https://finamodel.com/templates/private-school.xlsx - Category: Healthcare - Model type: Fund / Waterfall - Difficulty: Beginner - Audiences: Founders & operators, Public sector, School operators, Education investors, Nonprofit board members, Consultants - Tags: education, school-operations, enrollment, tuition-revenue, nonprofit ## Overview 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+. ## 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 - Admissions and marketing expenses - Operating margin and cash generation analysis ## How the Private School Operating and Financial Model Works This private school model is a 5-year three-statement acquisition tool for premium K-12 schools. It projects enrolment, tuition revenue, staffing, debt and cash flow to test whether an acquisition earns an acceptable equity return. This explanation covers the operating drivers, calculation flow, outputs and practical use for evaluating the template. ### Enrolment mechanics and revenue build Enrolment is the master driver. Each year opens with the prior closing balance, adds new intake, subtracts graduates and attrition, and caps the result at maximum campus capacity of 1,200 students. - Default assumptions start at 800 students with 180 annual intake growing at 2% per year, 8% graduation and 3% attrition, both calculated on opening enrolment. Closing enrolment feeds three revenue streams: gross tuition at the base fee escalated annually, net tuition after a scholarship rate of 5%, one-off enrolment fees on each new student, and ancillary revenue per student. - This structure makes revenue sensitive to retention and intake assumptions rather than to price alone. ### Cost structure and margin behaviour Teaching staff is the largest cost and is driven by a student-teacher ratio of 12, with required teachers rounded up to whole positions. That rounding creates step-function cost increases at enrolment thresholds, so margin can compress when a new teacher is triggered. - Each teacher carries a fully loaded cost inflated at 3.5% annually. Admin, facilities, marketing and IT costs are set as percentages of revenue, which lets fixed-cost leverage improve margins as the school scales. - Maintenance capex is also a percentage of revenue, with no growth capex because the base case remains below capacity. The model's margin profile targets typical mature-campus ranges, though actual results depend entirely on the assumptions entered. ### Debt, cash flow and returns The school is modelled as a going concern at acquisition, with pre-existing campus assets, a term loan and share capital. No new debt or equity is raised during the five-year projection. - Debt amortises straight-line, interest is calculated on the opening balance to avoid circularity, and a DSCR covenant of at least 1.25 times is tested each year. Cash flow combines net income, depreciation and working capital movements, less maintenance capex, debt repayment and dividends paid at a 50% payout of positive net income. - The returns section builds an equity IRR from the initial outflow, annual dividends and Year 5 exit proceeds, giving a leveraged return on the acquisition. ### Practical use and validation The model is designed to answer a specific acquisition question: whether buying a premium private K-12 school produces an acceptable equity return over a five-year hold. - It includes per-student KPIs, an exit multiple assumption and a validation checks sheet covering balance sheet balance, cash never turning negative, enrolment within capacity, DSCR compliance, staff cost ratio and IRR numeric checks. - A compact operating dashboard summarises enrolment, revenue per student and EBITDA per student for quick review. - The public download here is a values-only preview, so users can inspect the structure and logic, while the underlying template supports editing inputs and viewing calculated outputs in Excel. ## 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. ## 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. ## Features - **Enrollment-based revenue model:** Links student enrollment by grade to tuition revenue and shows sensitivity to attrition and pricing. - **Payroll architecture:** Models teacher-to-student ratios, salary scales, and benefits to forecast compensation as a percentage of revenue. - **Facility and operating cost tracking:** Captures facility costs, technology, curriculum materials, and services to forecast all-in operating expense. ## Use cases - **School expansion and new campus planning:** Model enrollment ramp, breakeven analysis, and payback on campus capex to evaluate growth opportunities. - **Tuition strategy and pricing analysis:** Forecast revenue sensitivity to tuition increases, discounting, and enrollment growth to optimize pricing. - **Operational efficiency and cost benchmarking:** Compare staff ratios and cost-to-revenue against peer schools to identify improvement opportunities. ## Frequently asked questions ### 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. ## Related templates - [Hospital Operating Model](https://finamodel.com/templates/hospital-model) - [Senior Living Facility Economics Model](https://finamodel.com/templates/senior-living-model) - [University Endowment Model](https://finamodel.com/templates/university-model)