Daycare Sales Forecast Template

Start with the Assumptions sheet. Enter your licensed capacity for each age group, your current tuition rates for full-time and part-time slots, your subsidy reimbursement rate, and your current occupancy percentage by age group. Infant rooms typically run at 90%+ occupancy because demand outstrips supply; preschool rooms may run lower during summer. If you have 12 months of enrollment history, use your actual monthly enrollment as the starting occupancy rates — this takes about 20-30 minutes and gives you a baseline grounded in reality rather than wishful thinking.

With your base assumptions set, review the Monthly Forecast sheet to check whether the projections look right for each month. Apply seasonal adjustment factors where you know enrollment shifts — August and September see enrollment surges as families get on schedules before school starts, while June and July often see school-age enrollment drop. If you're planning to add capacity mid-year (opening a new room, hiring to accommodate a waitlist), set the capacity increase in the Assumptions sheet with the month it takes effect. The Scenario Comparison sheet is worth filling out next: set a conservative downside at 10-15% lower occupancy to understand your revenue floor before committing to expenses.

The real value comes from the Actual vs Forecast sheet. After each month, pull your enrollment report and tuition ledger — most childcare management software (Brightwheel, Procare, HiMama) can export a monthly revenue summary. Enter those actuals alongside the forecast, and the variance calculations will show you exactly where projections drifted from reality. If subsidy reimbursements consistently come in lower than forecast, your reimbursement rate assumption may need adjustment. If toddler enrollment tracks below expectation while infants are at a waitlist, that's a signal about how you're marketing your toddler program. Most daycare directors find 20-25 minutes per month is enough to keep the forecast useful.

Daycare revenue forecasting is simpler than most operators think, but it requires building from the right drivers. Total tuition revenue is enrollment × tuition rate, repeated across each age group — because infant rates can be 50-70% higher than preschool rates due to required staff-to-child ratios, mixing age groups into a single revenue number hides the real economics. A center with 12 infants at $400/week and 20 preschoolers at $250/week generates very different revenue per dollar of labor than one with 8 infants and 28 preschoolers. A driver-based forecast makes those differences visible.

The two most important forecast variables for a daycare are occupancy rate by age group and the private pay vs subsidy split. Occupancy should target 85-95% for a financially stable center — below 80% and you're likely covering fixed costs with little margin. The subsidy split matters because government subsidy reimbursement rates are typically 10-30% lower than private tuition rates and involve a payment lag; centers that budget assuming private-pay rates on all enrolled children consistently underestimate cash flow needs. A well-built daycare forecast separates these streams and models them at their actual rates rather than blending them together.

A sales forecast becomes an operational tool when you use it to manage enrollment pipeline. Most daycare operators know their current enrollment but don't forecast far enough ahead to anticipate gaps. If a preschool classroom has 4 children aging out in March, you need waitlist inquiries in January to fill those spots by April. The monthly enrollment projections in this template, compared against your actual waitlist depth, tell you when to start marketing more aggressively and when you can relax. Directors who review their forecast monthly consistently maintain higher occupancy rates because they're reacting to trends before they become vacancies.