Daycare Pro Forma Template

Start with the Assumptions sheet. Enter your licensed capacity for each room type, the weekly tuition rates you plan to charge by age group, and your expected enrollment pace for the first 12 months. If you don't have firm numbers yet, start with the defaults — they reflect typical market rates for a mid-size urban or suburban center — and adjust from there. The Assumptions sheet controls everything else in the model, so spending 20 minutes getting those inputs right before touching any other sheet will save you a lot of time later.

Once your assumptions are set, review the Enrollment Projections and Revenue sheets to make sure the numbers look realistic. A common mistake is modeling full occupancy too quickly — most centers take 12–18 months to reach 85% capacity even with strong marketing. Stress-test your revenue by lowering the enrollment ramp in the conservative scenario and checking whether you still have enough cash to get through Year 1. The Break-Even Analysis sheet will show you exactly which month you cross into positive cash flow under each scenario.

When you're ready to share the model with a lender or investor, the Pro Forma Income Statement and Startup Costs sheets are formatted to be included directly in a business plan or loan application. Most SBA lenders want to see 3 years of projected financials alongside a startup cost summary and a clear explanation of your enrollment assumptions. Export those sheets as PDFs or send the full .xlsx file — all the formulas are visible and auditable, which builds credibility with reviewers who want to understand how you arrived at your numbers.

Opening or expanding a daycare center requires more upfront capital and more careful financial planning than most small businesses. A new center typically needs $150,000 to $500,000 just to open — buildout, equipment, licensing, and working capital — before a single tuition payment arrives. Banks and SBA lenders require projections before approving financing, and landlords of commercial space often ask for financial statements to evaluate whether you can sustain the lease. A well-built pro forma is not optional; it's the document that determines whether the project moves forward.

The financial structure of a daycare is driven by two variables more than any others: licensed capacity and occupancy rate. Licensed capacity sets your revenue ceiling — a center licensed for 80 children can only generate tuition from 80 children, no matter how efficient your operations are. Occupancy rate determines how close you get to that ceiling. Most centers operate between 75% and 90% occupancy once stabilized; getting there typically takes 12–24 months. Your pro forma needs to model this ramp-up period honestly, because it's during those early months — before enrollment is full but while payroll and rent are running — that cash flow is most vulnerable.

Staffing costs are the biggest variable in any daycare pro forma and the hardest to estimate without a framework. State licensing regulations set minimum staff-to-child ratios by age group: typically 1:4 for infants, 1:6 for toddlers, and 1:10 to 1:12 for preschoolers. These ratios create a direct link between your enrollment projections and your payroll costs — as you add children, you must add staff. This template builds that linkage into the model so your payroll projections scale realistically with enrollment rather than being entered as a flat number that doesn't reflect how the business actually operates.