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.
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.
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
Three sheets. Blue type on a yellow fill is an input; black type is a formula, protected against overtyping with no password.
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.
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.
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.