How to Build a 5-Year Financial Model for Your School

What is a 5-year financial model?

A 5-year financial model is a structured projection of your school's finances across five years. It shows expected revenue, expenses, staffing costs, and cash position for each year - and tells the story of how your school grows from launch to sustainability. This isn't guesswork. It's a disciplined exercise that forces you to think through every major financial assumption: How many students will you enroll? What will you charge? How many teachers will you hire? What will rent cost in Year 3?

Why five years?

One year isn't enough. Lenders and authorizers need to see that your school can survive the early years (when enrollment is still ramping up) and reach financial stability. Five years is the standard because:

Most schools don't break even until Year 2 or 3
It takes time to build enrollment to capacity
Lenders want to see that you can service debt over time
It demonstrates that you've thought beyond the launch

Step 1: Define your school profile

Before you touch any numbers, document the basics:

School type - Charter, private, microschool, pod, co-op, or tutoring center
State - Funding formulas and regulations vary significantly by state
Grade levels - Which grades will you serve, and when will you add new ones?
Building capacity - How many students can your facility hold at maximum?
Operating status - Are you pre-launch, or already operating?

These details shape everything that follows. A charter school in Arizona has a completely different financial profile than a private school in Connecticut.

Step 2: Project enrollment year by year

Map out expected enrollment for each year. Be specific:

Year 1: Starting enrollment (be conservative - 60–75% of capacity)
Year 2–3: Growth phase (add grades, fill existing seats)
Year 4–5: Stabilization (approaching or at capacity)

Build in attrition - 5–10% of students may leave each year. And if you're adding grades over time, show exactly when each new grade opens.

Step 3: Build your revenue model

With enrollment set, calculate revenue for each year:

Tuition revenue = enrollment × tuition rate per student
Per-pupil funding = enrollment × state allocation (charter schools)
Grants = specific amounts with start and end dates
Fundraising = conservative annual targets
Other income = after-school programs, facility rentals, etc.

Apply annual increases where appropriate - tuition might increase 2–3% per year, and per-pupil funding often has an annual adjustment.

Step 4: Plan your staffing

Staffing is typically 50–65% of your budget. For each year, list:

Every position (title, FTE, salary)
Benefits cost (typically 20–30% of salary)
Any positions that phase in as enrollment grows

A common approach is ratio-based staffing: one teacher per 20 students, one admin per 100 students. As enrollment grows, your staffing grows with it - but in planned increments.

Step 5: Estimate operating expenses

For each category, estimate monthly or annual costs and apply escalation:

Rent - Often increases 2–3% per year per lease terms
Curriculum - May scale with enrollment
Technology - Per-student device costs plus infrastructure
Insurance - Typically increases 5–8% annually
Marketing - May decrease as enrollment stabilizes

Be thorough. Missing a category means your model understates expenses.

Step 6: Add capital and debt

If you're taking out loans for a facility or equipment:

Model the loan amount, interest rate, and term
Calculate annual debt service (principal + interest)
Show the debt declining over the five years

If you have major capital purchases, show them in the year they occur.

Step 7: Calculate key metrics

With all the pieces in place, calculate the metrics that lenders and authorizers look for:

Net income - Revenue minus all expenses, for each year
Net margin - Net income as a percentage of revenue
Break-even enrollment - The minimum number of students you need to cover expenses
Cash on hand - How many days of expenses you can cover with available cash
Debt service coverage ratio (DSCR) - Can you comfortably make your loan payments?
Staffing ratio - What percentage of revenue goes to staffing?

Step 8: Stress-test your assumptions

The best financial models aren't the optimistic ones - they're the ones that have already thought about what could go wrong. Test scenarios like:

Enrollment 20% below target
A grant you were counting on doesn't come through
Rent increases faster than expected
You need to hire an additional teacher

If your school can survive the downside scenarios, your model is strong.

Making it professional

A professional financial model includes:

Clear assumptions documented on a summary page
Year-over-year comparison tables
Charts showing revenue vs. expense trends
A cover page with school name and date
Operating statement, balance sheet projections, and cash flow

Tools like SchoolStack Budget generate all of this automatically - including lender-ready PDFs and Excel workbooks with live formulas.