Private Kindergarten Network Financial Model

Description

The model is built for a growing network of 3–15 private kindergartens operating under a unified brand and a central management company. It captures the full complexity of multi-site operations: distinct enrollment dynamics at each location, age-specific staffing requirements dictated by local childcare regulations, and the shared overhead costs that scale with the network. The structure allows an investor to see how profitability evolves as the portfolio expands, not just the economics of a single nursery.

Each kindergarten is modeled with its own capacity, group composition (infant, toddler, preschool, pre-K), and fee structure, including registration, monthly tuition, meal plans, and optional after-school clubs. Staffing calculations automatically apply legal educator‑to‑child ratios per age bracket and allow separate assumptions for full‑time teachers, assistants, floating staff, and administrative roles. Facility costs reflect the real-world constraints of operating childcare centers — minimum square footage per child, outdoor playground requirements, and compliance with fire‑safety and health‑code fit‑out standards.

The central hub consolidates site‑level operating results and adds network‑wide functions: executive management, curriculum development, enrollment marketing, transport coordination, and multi‑year capital investment planning. The model supports phasing of new sites with pre‑opening expenses, ramp‑up of enrollment via waitlists and seasonal intakes, and can test the impact of government subsidies or voucher programs on revenue. All drivers are exposed so that an operator can adapt the model to their specific regulatory environment and growth roadmap.

Modeling specifics

• Age‑group enrollment decomposition with dynamic capacity constraints per room, reflecting regulatory maximum group sizes and square‑footage limits
• Staffing engine that derives FULL‑TIME‑EQUIVALENT headcount from age‑specific educator‑to‑child ratios, supervision requirements, and lunch/break coverage rules
• Site‑level P&L with granular operating expenses: consumables, meals (in‑house or outsourced), utilities, learning materials, and ongoing fit‑out maintenance
• Centralised overhead allocation model that distributes shared costs (HR, curriculum, quality control, leadership) across sites using a user‑configurable driver (enrolment, headcount, square footage)
• Regulatory compliance logic that flags violations of minimum space per child, fire‑safety ratios, or outdoor area requirements before the model can solve, preventing unrealistic capacity assumptions
• Waitlist and seasonal enrollment pipeline with conversion curves that reproduce real intake cycles (September primary intake, secondary January intake) and avoid instantaneous fill assumptions
• Phased network expansion schedule where each new site triggers its own pre‑opening costs, soft‑opening loss period, and staggered capital expenditure, consolidated into a portfolio IRR
• Government voucher and subsidy passthrough module that accounts for payment‑lag, eligibility criteria per age group, and clawback risks under funding‑per‑child schemes

What's included in the base version

• Входные предпосылки (макро, по объектам, возрастные группы, штатное расписание)
• Посайтовый план набора с кривыми заполняемости, сезонностью и отсевом
• Блок доходов: плата за обучение, регистрационные сборы, питание, дополнительные кружки
• Штатный расчёт по возрастам с автоматическим подбором числа воспитателей, ассистентов, административного персонала
• Операционные расходы каждого сада: аренда, коммунальные платежи, питание, расходные материалы, текущий ремонт
• Централизованные расходы сети: администрация, маркетинг, подбор персонала, образовательная программа
• Инвестиционный план: строительство/фит-аут каждого объекта, первоначальное оснащение, оборотный капитал
• Бюджет доходов и расходов, Отчёт о движении денежных средств, Баланс для всей сети
• Инвестиционная сводка: NPV, IRR, срок окупаемости, потребность в финансировании
• Одностраничный анализ чувствительности по ключевым драйверам (средний чек, заполняемость, темп расширения)

Common modeling mistakes

• Applying a single flat educator-to-child ratio across all age groups — understates staffing costs by 30–50% in jurisdictions with strict infant/toddler ratios
• Assuming each site reaches target enrollment immediately — overstates Year-1 revenue by 15–25% and hides the true working-capital peak during the ramp phase
• Ignoring mandatory outdoor play area and minimum indoor square‑meter‑per‑child requirements — leads to capacity projections that violate licensing rules, making the modeled revenue physically unachievable
• Modeling only one consolidated P&L without site‑level visibility — masks underperforming locations and inflates the apparent margin of the whole network
• Treating government subsidies or vouchers as 100% cash‑in‑advance with no eligibility check — overstates operating cash flow and understates the receivables balance, distorting liquidity by 2–4 months of working capital
• Excluding pre‑opening and soft‑opening losses for new sites — shortens the portfolio’s breakeven by 6–12 months and seriously overstates IRR for growth‑phase networks