How Do Schools Forecast Tuition Revenue? A Practical Guide for Finance Teams

Accuracy comes from working through the steps in order, with a separate assumption at each one. Most schools follow a version of this sequence:

1. Start with forecast enrolment by year level: the student numbers from your enrolment forecast, split by year level.
2. Apply the fee for each year level: including the planned fee change for next year.
3. Subtract sibling and staff discounts: based on the number of families who qualify.
4. Subtract scholarships and bursaries: using awards already made and an allowance for those still to come.
5. Allow for payment plans: so you know not only how much arrives, but when.
6. Apply a collection assumption and bad debt allowance: based on your own history and current receivables.
7. Record each assumption and test it: with a source, an owner and a date, and at least one scenario.

A tuition forecast can describe three different figures, and it helps to show all three:

Each adjustment is small on its own, but together they make a real difference between the headline and the result. Here is an illustrative example, starting with the 10,480,000 gross tuition from the enrolment example and applying simple assumptions:

In this example the school expects to collect about 92.1% of the headline fee total in the year, which is roughly 826,000 less than the gross figure suggests. The sensitivity is also worth noticing. A one percentage point change in the scholarship allowance moves gross tuition by 104,800, before any collection effects.

Fee changes work in the other direction. A planned increase applies to every student, so it is usually the biggest single lever in the forecast, and it should be checked against both the discount assumptions and the enrolment outlook.

Payment plans do not change how much tuition is billed, but they change when it is received. Families who pay annually in advance bring cash in early, families who pay each term spread it across the year, and families on monthly instalments spread it further.

Here is a simple example. If 20% of families pay upfront, 50% pay each term and 30% pay monthly, then term one receives 40% of the year's collectible tuition, and each of the other three terms receives 20%. A forecast that assumes an even quarter in each term would understate early cash and overstate later cash, which matters when the school is planning for payroll and capital payments.

Your own history is the best starting point. Look at how much of the net billed tuition was collected within the year over recent years, how much arrived after the year end, and how much was eventually written off. Keeping those two amounts separate is useful, because late collection is a timing difference while a write-off is a permanent loss.

Then adjust for what is happening now. The receivables report and the age of outstanding balances give early signs of whether collection is holding up. If families are under more financial pressure than in previous years, the forecast should say so, rather than quietly carrying last year's rate forward.

Because the inputs change in different places and at different times. Enrolments move as confirmations arrive, the fee schedule changes once a year, scholarships are awarded in batches, and collection results come in every month. Each change has to be carried into the revenue forecast, which in a file-based process usually means updating more than one workbook.

None of this reflects a lack of skill. Finance teams do careful work with the information they are given. The strain comes from the structure, where the pieces of the forecast live in separate files that have to be kept in step.

You can make tuition revenue planning easier without changing any tools. These habits help, and they are the thinking behind the calculator and assumption sheet at the end of this post:

1. Record the source, owner and date for every assumption: so anyone can see where a number came from and when it was last checked.
2. Forecast gross, net billed and collected separately: so the effect of each adjustment is visible.
3. Keep discounts, scholarships and bursaries on separate lines: because they are decided by different people and behave differently.
4. Compare the collection assumption with actual receivables each term: so drift is caught early.
5. Update the forecast when enrolment or fees change: so revenue never lags behind the decisions that drive it.

Imagine changing the fee increase once and watching gross tuition, net billed tuition, expected collections and cash by term all update together. When enrolment changes, the revenue forecast follows without anyone copying numbers across. The assumptions sit in one place, each with its source and date, so the next person to pick up the forecast knows where everything came from.

That's what PULSE is built to support: a planning, budgeting, forecasting and reporting platform built for schools, where enrolment, fees and collection assumptions feed one connected forecast. It works alongside the school's finance system, existing workbooks can be the starting point, and the finance team keeps control of every assumption.

The judgement about what the assumptions should be still comes from people who know the school and its families. The difference is that more of their time goes into that judgement, and less into carrying changes from file to file.