Free Excel templates

A free child care center break-even and ratio planner in Excel

Rooms, ratios and enrollment turned into teacher slots room by room, the places left under the lower of the license and the rooms, and the enrollment a center needs to cover its fixed costs. One sheet of inputs, live formulas and three checks.

The file opens on the book's fictional first center in one week of April 2026: 126 children in 10 rooms need 20 teacher slots, or 900 slot hours at 45 hours a slot, and the license of 132 leaves 6 open places. Over FY2026 each child-week left $142.45 after direct costs, so the center broke even at 3,968 child-weeks, 76.3 children on average, against an actual 120.1.

Get the planner

One Excel file, no macros, nothing locked on the Inputs tab. Free: enter your email address and the download opens at once, along with the other free models.

Child_Care_Center_Break_Even_and_Ratio_Planner.xlsx (11 KB)

You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.

The book behind this planner

This file is drawn from workbooks 1 and 5 of The Child Care Center Owner, which follows one fictional company with two licensed centers through two fiscal years: capacity and ratios, enrollment by classroom, tuition and subsidies, payroll and overtime, rent, the classroom P&L, the break-even, a second center built with an SBA loan, and a letter of intent from a buyer.

DRM-free PDF, $19.99 → · Paperback, $32.99, shipped worldwide

What is in the file

Three sheets. Blue type on a yellow fill is an input; black type is a formula, protected against overtyping with no password.

Inputs
For each age group (infants, toddlers, twos, preschool, school-age): the ratio, the group size, the rooms open and the children in each room; the licensed capacity, the hours one slot covers and the lead teacher hours; then one fiscal year of revenue, direct costs, child-weeks, center operating expenses and weeks.
Planner
Slots room by room (children divided by the ratio, rounded up), places left before the next teacher in each room, teachers needed, functional capacity, slot hours and assistant hours, the ceiling (the lower of the license and the rooms) and the open places under it; contribution per child-week, break-even child-weeks, break-even and actual average enrollment, and break-even as a share of functional capacity (54.5 percent in the case).
Checks
Each age group within its rooms times the group size, total enrollment within the license, contribution per child-week above zero, and an All checks cell.

Three things to try

Take one school-age child away. The school-age room holds 16 children at a ratio of one teacher for every 15, so it needs 2 teachers; type 15 and it needs 1. One child is a whole slot, 45 hours a week: slots move in steps, not child by child.

Fill a preschool room. A preschool room of 17 at one teacher for every 10 has 3 places before its next teacher. Those are the cheapest children the center can add.

Raise the fixed costs. Add a year of rent increase to center operating expenses and watch the break-even enrollment move; then type next year's tuition into revenue and see how much of it the increase eats.

Questions

Does it know my state's ratios?

No. The ratios and group sizes in the file are the book's teaching assumptions, not the rule of any state. Type the ratios and group sizes of your state's licensing rules and of your license over them, and ask the licensing office when in doubt.

Why does break-even use child-weeks?

A child-week is one child enrolled for one week. Tuition, subsidies, food and supplies all move with it, so it is the unit in which a center's contribution can be counted. Teacher pay moves in steps of one slot, which is why the result is an average, not a promise.

Related reading