# The Child Care Center Owner: companion files

Julian R. Sterling

## What is here

- **ChildCare_1_Ratio_and_Capacity_Planner.xlsx** (Chapters 2 and 7; Workbook 1 of Appendix A): tabs Inputs, Planner, Checks. Slots room by room, rooms needed, functional capacity, slot hours and open places for one week (the first center's week 80: 20 slots, 900 slot hours, 14 open places).
- **ChildCare_2_Tuition_Subsidy_and_the_Gap.xlsx** (Chapters 4 and 5; Workbook 2): tabs Inputs, Billing, Checks. One week of revenue from children: tuition, the sibling discount, copayments and agency payments, with the subsidy gap kept apart as not revenue (week 80: revenue before registration fees $40,905, subsidy gap $1,744).
- **ChildCare_3_Classroom_Contribution.xlsx** (Chapter 10; Workbook 3): tabs Inputs, Classrooms, Checks. Classroom contribution and classroom result by age group for a fiscal year (the first center in FY2026: infants -$6,405, preschool $242,469).
- **ChildCare_4_Payroll_Overtime_and_Turnover.xlsx** (Chapters 7 and 8; Workbook 4): tabs Inputs, Payroll, Checks. One week of classroom pay, overtime premium and burden, and the year's cost of hiring (week 80: classroom labor $20,341; FY2026 hires $13,800).
- **ChildCare_5_Center_Break_Even.xlsx** (Chapter 11; Workbook 5): tabs Inputs, Break-Even, Checks. Contribution per child-week, break-even child-weeks and break-even average enrollment against the actual average (the first center in FY2026: 3,968 child-weeks, 76.3 children against 120.1).
- **ChildCare_6_Second_Center_Payback.xlsx** (Chapter 12; Workbook 6): tabs Inputs, Payback, Checks. Investment, run-rate and simple payback of the second center ($883,042, $236,720 a year, 44.8 months).
- **ChildCare_7_Offer_and_Valuation.xlsx** (Chapters 9 and 16; Workbook 7): tabs Inputs, Offer, Checks. The letter of intent from EBITDA to the cash paid at closing, and the landlord's offer read separately (enterprise value $2,405,431, paid at closing $1,417,499 before taxes and fees; rent yield 10.0 percent).
- **Child_Care_Center_Owner_Check_Lists.docx**: the 8 check-lists of Appendix B, editable, with a box to tick before each item (The license and the rooms (chapter 2); The weekly enrollment and staffing review (chapters 3 and 7); The rate card and collections (chapter 4); The subsidy file and the agency (chapters 5 and 6); Payroll, overtime and hiring (chapters 7 and 8); The lease, insurance and the landlord (chapter 9); Opening a second center (chapter 12); Before answering an offer (chapters 9, 15 and 16)).

## How to use the workbooks

Every workbook opens on its Inputs tab: blue type on a light yellow background is an input, and nothing else is typed by hand. The subject tab holds formulas only and is protected against overtyping, with no password. The Checks tab holds the three tests of Appendix A: each one shows OK or CHECK, and the cell All checks shows OK only when every test below it does. A comparison block informs and carries no OK or CHECK.

The arithmetic is plain: the only functions are SUM, ROUND, ROUNDUP, MIN, MAX, IF and AND, and ROUNDUP appears only in workbook 1. No cell holds a date: a week or a fiscal year is a label. Percentages are typed as percent (7.65, not 0.0765), and every division by an input that can be zero is wrapped in IF and shows 0 instead of an error. An empty input reads as zero in a sum, a product or a comparison, but a MIN over a range skips it. The last section of Appendix A lists, workbook by workbook, what the checks do not catch.

To use a workbook on your own center, start with a copy, replace every blue input from the record that owns each figure (the license and the state's licensing rules, the enrollment by room, the rate card, the agency's rate notice, the payroll register, the statements, the bank's schedule, the letter itself), keep every check at OK, and never edit a formula to turn a CHECK into OK.

The workbooks are separate files with no link between them: a figure two workbooks share (the functional capacity of workbook 1, an input of workbook 5) is typed again where it is used.

## A word of caution

Larkspire Early Learning, Inc., the town of Oskerby, Tamberline Properties, Ambersley Realty, Fennimere Community Bank and every party in the case are fictional. Ratios, group sizes, capacities, enrollments, tuition, agency rates, copayments, hours, wages, costs, loan terms, prices and multiples are teaching assumptions, not market norms, not the rule of any state and not recommendations. What a state requires for licensing, ratios and subsidies is for its own rules and its agencies; taxes are for the outside CPA; contracts are for counsel in the company's state. The files are provided as they are, without warranty of any kind.
