Projecting school enrollment: the number that makes or breaks the annual budget
For a private K-12 school — family-owned or part of an education group (Sidwell Friends in DC, Harker in the Bay Area, Dwight-Englewood in NJ, or regional bilingual schools in LatAm) — enrollment projection is not an academic exercise. It is the figure that drives payroll, infrastructure spend, and the decision to open or close a section. Missing by 20 students in a 800-student school means roughly a million dollars of revenue gone or three teachers contracted who don't have classrooms to teach. This calculator models the complete enrollment funnel with the standards NCES (US), IMESCO (LatAm), and OECD Education at a Glance recognize.
The enrollment funnel: inquiry → applied → admitted → enrolled
- Inquiry. Family that requested info — site visits, open-house events, referrals. Inquiry → application conversion: 25-45% in independent K-12 schools with an active admissions process.
- Application. Family that completed the formal process: testing, interview, documentation. The drop here reveals either process friction or a socioeconomic mismatch with tuition.
- Admission. School offers a seat. Admissions rate: 60-85% in schools with spare capacity, 30-50% in oversubscribed schools with structural waitlists.
- Yield rate (admitted → enrolled). Critical metric borrowed from higher-ed. Typical US independent K-12 range: 55-75%. Yields above 70% signal strong brand and tuition fit; below 55% means families use your school as a backup.
- Final enrollment = enrolled students who actually started the school year. Expect 3-8% additional attrition between spring contract-signing and August start from relocations, late acceptances elsewhere, or economic changes.
Grade-to-grade retention — the biggest lever nobody models
NCES (US) and IMESCO (LatAm) both converge: grade-to-grade retention (the % of students moving from 3rd grade to 4th in the same school) explains 70-80% of next-year enrollment. A school with 820 students and 92% grade-to-grade retention starts the next year with 754 returning students; it only needs 66 new admits to hold enrollment flat. The same school with 84% retention starts with 689 returners and needs 131 new admits — nearly twice the admissions effort for zero growth. Schools that track retention by section and by family (siblings) can anticipate headcount 9-12 months out.
Transition attrition — the typical cliffs
- PreK → Kindergarten. Loss 15-25% when families look at alternative elementary schools.
- Elementary → Middle school (5th → 6th). Loss 8-18%. Schools without an integrated upper school lose more again around 8th grade.
- Middle → Upper school (8th → 9th). Loss 10-20% toward schools perceived as better college-prep pipelines (Ivy-feeder independents, top public magnets, IB programs).
Tuition elasticity — what OECD documents
OECD Education at a Glance 2024 reports price elasticity between -0.4 and -0.8 for private K-12 in developed markets under normal conditions — raising tuition 10% reduces enrollment 4-8% when the school has a clear value proposition. Under economic stress (2020 COVID, 2022-2024 post-pandemic inflation) elasticity rises to -1.2 to -1.8: families migrate to less expensive independents, charter schools, or public options. Modeling this before raising tuition prevents losing 3-5% of enrollment that can cost more than the tuition increase brings in.
Financial aid impact
Financial aid impact in US independent K-12: a financial-aid program covering 14-22% of total tuition (partial awards of 25-50% to qualifying families) typically lifts gross enrollment 8-15 points by rescuing families who would otherwise go public or charter. The net cost (award × aided students) is recovered within two academic cycles through economies of scale (same teacher, same classroom, marginal student at near-zero cost).
Siblings enrollment — the hidden multiplier
NCES and NAIS converge: families with 2+ school-age children enroll younger siblings in the same school at 75-85% when the older sibling's experience is positive. The younger sibling is nearly zero CAC. Schools that ignore 'average children per family' leave 8-20% of organic growth on the table. US independent K-12: 1.6-1.9 children/family is typical in urban markets, 1.9-2.4 in suburban Catholic and classical schools.
Declining birth rates: the structural enrollment headwind in LATAM and Spain
OECD's Education at a Glance 2024 and IMESCO LatAm Private School Benchmarks both flag the same structural trend: declining birth rates in urban LATAM (Mexico City TFR 1.5, Bogotá 1.6, Santiago 1.4) and Spain (TFR 1.15 in 2023 — lowest in the EU) mean that the pool of school-age children is contracting in most markets where private K-12 schools compete.
The enrollment impact is lagged by 3-6 years (births today become Kindergarten students in 5-6 years). Schools that modeled enrollment 2023-2026 without incorporating 2017-2019 birth-rate data missed the contraction. The implication: in a shrinking pool, enrollment is increasingly a market-share game — the school's percentage of a smaller pie must grow, or absolute enrollment falls even with constant market share.
Competitive response strategies: (1) feeder-school pipeline agreements with daycare centers and preschools to capture students before they enter primary; (2) geographic expansion of recruitment radius via online open-house events; (3) international student programs that compensate for local demographic decline with international demand; (4) rethinking the section structure (smaller sections, not fewer sections) to maintain teacher continuity while accommodating lower headcount without layout disruption.
The feeder-school analysis: upstream demand intelligence
For schools with Kindergarten entry points, the feeder-school analysis — mapping which preschools and daycares send students to your school — is the equivalent of a B2B sales pipeline analysis. Key data: (1) current enrollment by feeder school; (2) estimated population of 5-year-olds graduating from each feeder this year; (3) your capture rate per feeder (current K enrollment from feeder / total graduating from feeder). A feeder sending 45 children from which you capture 8 (18% capture rate) is an untapped opportunity if your satisfaction scores from parents of existing students from that feeder are high.
Formal feeder-school partnerships — visits, open-day invitations for preschool teachers, priority admissions windows for feeder-school graduates — lift capture rates from a typical 10-25% to 30-45% within 2-3 cycles. At scale (a 600-student school serving 15 feeder schools), a 10-percentage-point lift in capture rate across feeders translates to 15-25 additional Kindergarteners — without any marketing spend on brand awareness.
LATAM context: bilingual schools and the premium segment
In Mexico, Colombia, and Chile, the growth segment in private K-12 is bilingual and trilingual education (Spanish-English, Spanish-English-French). These schools command a 40-120% tuition premium over standard private schools and have been growing enrollment at 3-7% annually despite overall private school stagnation. The demand driver: professional-class families who see English fluency as a non-negotiable requirement for their children's global competitiveness.
For bilingual schools in Mexico (Colegio Americano, The American School, Lomas Hill, regional chains), the enrollment model is more sophisticated: it must account for the English-proficiency progression (entering students at different levels, remediation cost per level), the bilingual teaching staff supply constraint (certified bilingual teachers are scarce and churn frequently), and the reputational risk of not delivering genuine bilingual outcomes (families self-select out when the promise isn't kept).
Differentiation vs SIS reports and Excel projections
Student information systems (Blackbaud, PowerSchool, Veracross, FACTS, Alma) report current enrollment and re-enrollment intent but don't project yield rate, tuition elasticity, or siblings impact in a single unified dashboard. Excel templates solve the static exercise but die on the second projection — no scenario sensitivity, no economic stress test, no one updates the elasticities when the region's tuition market shifts. This simulator integrates the enrollment funnel, grade-to-grade retention, siblings, financial aid impact, and tuition elasticity into one flow, with outputs in the language boards of trustees and CFOs of education groups recognize during the annual budget review.
How to use this simulator
Enter current students by grade, historical grade-to-grade retention, expected new admits by grade, capacity per section, and tuition. The engine projects three scenarios (conservative, base, optimistic) over the next 3 academic cycles, returning total enrollment, projected revenue, and early alerts when a section falls below its break-even point. Use it to decide hires, section openings, and budget with 6-9 months of lead time — the minimum needed to react without paying overtime premiums.