Daycare Financial Model Template

Start with the Assumptions sheet — it drives everything else. Enter your licensed capacity by age group, your current or planned tuition rates, and your occupancy assumptions. If you're modeling an existing center, use your current enrollment numbers and tuition schedule. If you're planning a new center, research your local competitors' rates and set conservative occupancy targets: 70% in year one, 85% by year two is a reasonable baseline for most markets. Once your assumptions are in, the revenue sheet will populate automatically.

Move to the Expense Model next and fill in your payroll data. The model pre-builds staffing ratios by age group based on common state licensing requirements — adjust these to match your state's specific ratios. Enter your hourly wage rates for lead teachers, assistant teachers, and directors separately, since these typically differ. Then work through the remaining expense categories: rent and utilities from your lease, food costs from your CACFP reimbursement rates and any co-pay, and fixed overhead items like insurance and licensing fees.

Once both the revenue and expense inputs are complete, review the P&L and Cash Flow sheets to see your projected performance. The KPI Dashboard will show your occupancy rate and labor cost ratio — if labor is running above 65% of revenue, go back to the Assumptions sheet and model scenarios like increasing tuition, improving occupancy, or adjusting staffing ratios. The model is built for iteration: daycare finances are sensitive enough that running three or four scenarios before committing to a plan is worth the extra 30 minutes.

Running a daycare without a financial model is operating on gut feel in an industry where margins are thin and expenses are locked in. Payroll alone runs 50–65% of revenue at most childcare centers, and because state licensing ratios require minimum staffing regardless of enrollment, a center that drops from 90% occupancy to 75% can swing from profitable to break-even in a single month. The only way to see that exposure ahead of time is to model it — and that means having a connected spreadsheet that links your enrollment assumptions to your staffing costs and cash position.

Daycare revenue has structural complexity that generic financial templates don't handle. Most centers collect tuition from private-pay families and government subsidies through CCAP, CCDF, or local childcare voucher programs, and these two income streams behave very differently. Private-pay is collected weekly or monthly and predictable. Subsidies arrive on state reimbursement cycles that lag enrollment by weeks, vary by child, and come with utilization requirements. A good daycare financial model separates these streams so you know your subsidy dependency ratio — the share of revenue that depends on government funding — and can stress-test what happens if subsidy rates change or reimbursements are delayed.

The financial model also clarifies the path to growth. Adding an age group, opening a second room, or hiring a full-time director all have direct revenue implications tied to capacity and licensing ratios. This template lets you model those decisions before you make them: add six infant slots, see how the required 1:4 staffing ratio changes your labor line, and check whether the additional tuition revenue covers the cost. That kind of before-and-after analysis is what turns a financial model from a reporting tool into a planning tool.