Tuition funding gap with fee inflation · Calculation guide

Estimate the cash needed at enrolment for a four-year course.

Calculation guide

First tuition bill is due at enrolment. Three further annual bills increase by the entered fee inflation. Existing savings grow until enrolment only and then earn zero while spent. No future contributions or living costs.

gap = max(0,fee*(1+inflation/100)^wait*(1+(1+inflation/100)+(1+inflation/100)^2+(1+inflation/100)^3)-funds*(1+rate/100)^wait); first = fee*(1+inflation/100)^wait; total = first*(1+(1+inflation/100)+(1+inflation/100)^2+(1+inflation/100)^3); available = funds*(1+rate/100)^wait

Inputs

One year of tuition at today’s price

Example entry 10000 (in the selected currency).

Annual tuition increase

Example entry 5 %. Allowed range -99.0 to 100.0.

Years until enrolment

Example entry 2. Allowed range 0.0 to 80.0. Use whole numbers.

Savings available today

Example entry 30000 (in the selected currency).

Annual savings return until enrolment

Example entry 0 %. Allowed range -99.0 to 100.0.

Worked example

InputValue
One year of tuition at today’s price10,000
Annual tuition increase5%
Years until enrolment2
Savings available today30,000
Annual savings return until enrolment0%
ResultValue
Amount still needed at enrolment17,519.128125
First-year tuition11,025
Four-year tuition total47,519.128125
Savings at enrolment30,000

Calculation steps

Amount still needed at enrolment = max(0, (((One year of tuition at today’s price × ((1 + (Annual tuition increase ÷ 100)) ^ Years until enrolment)) × (((1 + (1 + (Annual tuition increase ÷ 100))) + ((1 + (Annual tuition increase ÷ 100)) ^ 2)) + ((1 + (Annual tuition increase ÷ 100)) ^ 3))) − (Savings available today × ((1 + (Annual savings return until enrolment ÷ 100)) ^ Years until enrolment))))

max(0, (((10,000 × ((1 + (5 ÷ 100)) ^ 2)) × (((1 + (1 + (5 ÷ 100))) + ((1 + (5 ÷ 100)) ^ 2)) + ((1 + (5 ÷ 100)) ^ 3))) − (30,000 × ((1 + (0 ÷ 100)) ^ 2)))) = 17,519.128125

First-year tuition = (One year of tuition at today’s price × ((1 + (Annual tuition increase ÷ 100)) ^ Years until enrolment))

(10,000 × ((1 + (5 ÷ 100)) ^ 2)) = 11,025

Four-year tuition total = (First-year tuition × (((1 + (1 + (Annual tuition increase ÷ 100))) + ((1 + (Annual tuition increase ÷ 100)) ^ 2)) + ((1 + (Annual tuition increase ÷ 100)) ^ 3)))

(11,025 × (((1 + (1 + (5 ÷ 100))) + ((1 + (5 ÷ 100)) ^ 2)) + ((1 + (5 ÷ 100)) ^ 3))) = 47,519.128125

Savings at enrolment = (Savings available today × ((1 + (Annual savings return until enrolment ÷ 100)) ^ Years until enrolment))

(30,000 × ((1 + (0 ÷ 100)) ^ 2)) = 30,000

How each input affects this example

Each row starts from the worked example and changes one input.

InputOriginal inputNew inputAffected resultOriginal resultNew result
One year of tuition at today’s price10,00011,000Amount still needed at enrolment17,519.12812522,271.040938
Annual tuition increase5%6%Amount still needed at enrolment17,519.12812519,153.185376
Years until enrolment23Amount still needed at enrolment17,519.12812519,895.084531
Savings available today30,00033,000Amount still needed at enrolment17,519.12812514,519.128125
Annual savings return until enrolment0%1%Amount still needed at enrolment17,519.12812516,916.128125
Tuition funding gap with fee inflation →