Key Takeaways
- Use realized weighted tuition, not the highest posted rate.
- Classify classroom staffing as step-fixed when another cohort requires a teacher or room.
- Use the capacity actually available under the license, room configuration, ratios, and staffing plan.
- A result above 100% signals that the entered model cannot break even within capacity.
- Build classroom and payer cases around the sitewide answer before underwriting a transaction.
How the break-even formula works
The calculator subtracts weekly variable cost per child from average weekly tuition, multiplies the difference by operating weeks, and calls the result annual contribution per enrolled child. It divides annual fixed and step-fixed costs by that contribution to estimate break-even enrollment, then divides enrollment by licensed capacity.
| Input | Definition | Evidence |
|---|---|---|
| Weighted weekly tuition | Realized revenue per average enrolled child | Contracts, invoices, subsidy records, discounts |
| Variable cost per child | Cost that changes with one more enrolled child | Food, consumables, defined transaction fees |
| Fixed and step-fixed cost | Cost present at the tested scale | Staffing floor, rent, administration, insurance |
| Licensed capacity | Authorized ceiling under stated conditions | Current license and room approvals |
| Operating weeks | Billable weeks in the modeled year | Calendar and family contracts |
If weekly tuition is not greater than entered variable cost, the calculation stops because each additional child supplies no positive contribution under those assumptions.
Why labor needs special treatment
Child-care payroll is neither perfectly fixed nor smoothly variable. One additional child may fit within an existing ratio and add little immediate payroll; the next may require an entire additional shift. Group-size limits, room configuration, age mix, qualifications, breaks, opening and closing coverage, and director duties create further steps.
Build a staffing grid for several enrollment bands. Put the required payroll for each band into fixed and step-fixed cost, then rerun the model. The break-even point can jump when a classroom opens. A single sitewide variable labor percentage hides that operational threshold.
Build realized tuition by cohort and payer
Calculate private-pay, subsidy, employee-discount, sibling-discount, scholarship, part-time, and full-time arrangements separately. Match subsidy revenue to service months and include family copays. Exclude an unverified waitlist and future tuition increases from the base case.
| Scenario | Tuition assumption | Cost assumption | Use |
|---|---|---|---|
| Current | Recent realized rate | Current staffing band | Reconciles operating history |
| Downside | Lower occupancy or payer mix | Sticky payroll and facility cost | Tests liquidity risk |
| Next room | Cohort-specific revenue | Adds teacher and room step | Tests expansion economics |
| Stabilized | Supported mature mix | Sustainable wages and coverage | Frames potential, not current value |
The stabilized case should remain separate from historical earnings used in valuation. A buyer pays for transferable evidence, not automatic achievement of a modeled scenario.
Interpret results above and below capacity
A 70% result means the entered model reaches arithmetic break-even at average enrollment equal to 70% of licensed capacity. It does not mean every 70% configuration works. Seventy infants and toddlers can require very different rooms and labor from seventy preschool and school-age children.
A result above 100% is useful rather than erroneous. It shows that some combination of tuition realization, capacity, labor design, facility expense, or other fixed cost must change before the scenario becomes viable. Do not solve it by entering capacity that the license or facility cannot support.
A very low result deserves verification too. Check whether major costs were omitted, owner labor was removed without replacement, property occupancy cost is below market, payroll burden is missing, or tuition was set at the published maximum instead of realized average.
Apply the output in transaction diligence
Compare modeled break-even enrollment with monthly paid FTE enrollment, classroom rosters, starts and withdrawals, billing, bank receipts, and subsidy claims. Identify the cash low point, not only the annual average. A center can look profitable over a year and still face payroll pressure during a seasonal enrollment trough or reimbursement delay.
For a buyer, tie the model to the first 13 weeks after closing and the license-transition calendar. For a seller, document why current staffing and room use support the reported margin. Both sides should keep deposits, prepaid tuition, receivables, and working capital separate from gross revenue.
Common mistakes
- Treating all payroll as variable with enrollment.
- Using design capacity instead of current licensed and operable capacity.
- Entering posted tuition without discounts, subsidy terms, or bad debt.
- Ignoring classroom and age mix behind a sitewide occupancy figure.
- Omitting owner replacement, rent normalization, or recurring repairs.
- Reading break-even as a prediction instead of an assumption-driven scenario.
Frequently asked questions
What does break-even occupancy mean?
It is the modeled average enrollment required for annual contribution margin to cover the entered fixed and step-fixed costs, divided by entered licensed capacity.
Which costs are variable per child?
Include only costs that change reliably with another enrolled child, such as defined consumables or meals. Classroom labor is often step-fixed and should not be treated as smoothly variable.
Where should classroom payroll be entered?
Put the staffing floor and other payroll required at the tested operating scale in annual fixed costs. Model a separate cost step when enrollment requires another room or teacher.
Can break-even occupancy exceed 100%?
Yes. That result means the entered economics cannot break even within licensed capacity. Recheck tuition realization, capacity, staffing, facility cost, and the cost classification.
Should subsidy and private-pay tuition be averaged?
Use a weighted realized rate only after reconciling reimbursement, family copays, discounts, denials, and timing. Separate scenarios may be more useful when payer economics differ materially.
Is the result a forecast of profit?
No. It is a simplified break-even scenario. Actual results depend on classroom mix, staffing steps, collections, closures, seasonality, capital needs, and other costs.