Private Cadet / Military Preparatory School Financial Model

Description

The model is a comprehensive planning tool for a private military-style boarding school, structured around a corps/company system that drives both enrollment and fee structures. It captures distinct revenue streams such as tuition differentiated by cadet rank, boarding and mess charges, mandatory uniform sales, and optional summer leadership camps. The cost side separately models military instructors with JROTC retirement pay scales, certified academic faculty, and the high fixed-cost base of parade grounds, obstacle courses, armories, and dormitory facilities.

Operational drivers are modeled in detail: a recruitment funnel with grade‑level attrition and mid‑year replacement, boarding capacity limited by barracks bed stock and dining hall seatings, and phased capital expansions linked to enrollment thresholds. The model also incorporates uniform procurement cycles with bulk discounts, food service contracts priced per boarder and day‑cadet meal, and insurance lines tailored to cadet activities. Accreditation fees, safety inspections, and state military school compliance costs are built in as semi‑variable expenses.

The financial output includes fully integrated three‑statement projections, cash flow with debt service and equity drawdowns, and key operating ratios such as cadet‑to‑instructor, boarding occupancy, and cost per cadet. Investors and school founders can stress‑test assumptions on enrollment growth, fee escalation, capital outlays, and retention to evaluate project viability without resorting to generic templates.

Modeling specifics

• Corps‑based enrollment model with separate intake for day and boarding cadets, capped by platoon/company size and dormitory bed stock, incorporating mid‑year attrition and replacement admissions.
• Multi‑tier tuition and fee schedule differentiated by cadet rank (e.g., private, corporal, sergeant) with automatic annual step‑up, sibling discounts, and loyalty rebates for multi‑year contracts.
• Military instructor staffing linked to JROTC instructor‑to‑cadet ratios and retirement pay scales, while academic faculty staffing adjusts to state teacher certification levels and class size limits.
• Auxiliary revenue streams from mandatory uniform/clothing store sales, summer leadership camps, and after‑school drill programs, each with separate cost drivers and seasonal cash‑flow patterns.
• Dynamic capital expenditure block that phases construction of barracks, dining hall, parade ground, obstacle course, and outdoor training facilities, with staged capacity activation and associated borrowing.
• Food service cost calculated from daily mess rates per boarder and day‑cadet meal participation, with separate contracts for kitchen operations and commodity price escalation.
• Accreditation and compliance module tracking state‑specific licensing, safety inspections, and insurance requirements (liability, accident, property) that directly affect fixed operating costs.
• Waterfall‑based student attrition and re‑enrollment modeling across grade levels, with impact on fee income, dormitory vacancy, and staff redundancy adjustments.

What's included in the base version

• Executive Dashboard with summary KPIs and financial charts
• Enrollment & Retention Model (day/boarding, grade-level, attrition, re-enrollment waterfall)
• Revenue Build‑up (tuition by rank, fees, uniforms, summer camps, auxiliary programs)
• Staffing & Payroll (military instructors, academic faculty, administration, support staff)
• Operating Expenses (facilities, food service, uniforms, insurance, accreditation, marketing)
• Capital Expenditure & Depreciation Schedule (phased campus build‑out)
• Debt & Equity Financing module with drawdowns and repayment structures
• Integrated Three‑Statement Model (P&L, Cash Flow, Balance Sheet)
• Investment Return Metrics (unlevered/levered IRRs, NPV, payback period)

Common modeling mistakes

• Assuming static enrollment without modeling mid‑year attrition and re‑enrollment — leads to overestimating annual tuition revenue by 10–18% and boarding occupancy by 15–25%.
• Treating military and academic staff as a single cost line with uniform salary growth — ignores JROTC pay scale regulations and instructor turnover, causing payroll underestimation by 12–20% over 5 years.
• Phasing all capital expenditures at project start instead of tying construction to enrollment milestones — distorts cash flows and can overstate pre‑opening funding needs by 30–50%.
• Overlooking uniform replacement cycles and bulk purchase discounts — results in overstatement of clothing store costs by 20–30% and underestimation of working capital.
• Neglecting separate seasonal modeling of summer camps and auxiliary programs — inflates operating margins by assuming year‑round activity and misses fixed staff carry‑through costs.