University Endowment ModelFree Financial Model Download

Model a mid-sized private university with tuition revenue (undergraduate and postgraduate), government grants, research income, auxiliary revenue (housing, dining), and endowment returns. Net tuition is driven by gross tuition × (1 - discount rate), where discount rates account for institutional financial aid. Undergraduate enrollment is modeled with retention curves (typically 80–92% year-over-year); postgraduate programs grow faster (3–6% annually) but have lower discount rates.

The workbook projects faculty and administrative headcount based on student-to-faculty ratios (target 10–20:1), applies salary escalation, and models benefits burdens (25–30% of salaries). Fixed costs include facilities maintenance (8–12% of revenue), student services (3–5%), and marketing (3–5%). Capex is significant (8–15% of revenue) due to deferred maintenance and lab/building upgrades. Debt service is modeled assuming senior tax-exempt bonds at 3–5% rates; DSCR covenants typically require minimum 1.20–1.50x coverage.

Key metrics: revenue per student ($25–80k for a US private), operating margin (3–10% for well-managed institutions), faculty cost ratio (30–45% of revenue). Enrollment trends dominate sensitivity: 5% enrollment decline reduces net tuition by 5–7% (after fixed cost deleverage), compressing margins 200–400 bps. The demographic cliff (declining 18-year-old population in many Western countries from 2025 onward) is the dominant macro headwind.