Private School Break-Even and Tuition Projection Model

What a good one includes

• Differentiated tuition tiers by grade level or program type to accurately reflect varying operational costs and market demand.
• A dynamic staffing calculator linked to enrollment metrics to automatically adjust teacher salaries and benefits as class sizes grow.
• A comprehensive breakdown of fixed facilities costs, including rent or mortgage, utilities, insurance, and campus maintenance.
• Granular estimates of variable, per-student expenses such as curriculum materials, technology fees, classroom supplies, and food services.
• A dedicated projection for financial aid, scholarships, and sibling discounts to show net tuition revenue rather than gross potential.
• A clear visual representation of the exact student enrollment threshold required to cover all operational costs.

Common mistakes to avoid

• Overestimating initial enrollment capacity without factoring in student attrition or the natural multi-year ramp-up period for new grade levels.
• Failing to account for the full cost of employee benefits and payroll taxes, which significantly increases the true cost of instructional staff.
• Relying on a static spreadsheet that cannot simulate different scenarios, such as a drop in enrollment or an unexpected rise in facility costs.
• Neglecting to build a capital reserve fund into the break-even calculations for future building repairs and technological upgrades.

Frequently asked questions