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.
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
| Input | Value |
|---|---|
| One year of tuition at today’s price | 10,000 |
| Annual tuition increase | 5% |
| Years until enrolment | 2 |
| Savings available today | 30,000 |
| Annual savings return until enrolment | 0% |
| Result | Value |
|---|---|
| Amount still needed at enrolment | 17,519.128125 |
| First-year tuition | 11,025 |
| Four-year tuition total | 47,519.128125 |
| Savings at enrolment | 30,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.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| One year of tuition at today’s price | 10,000 | 11,000 | Amount still needed at enrolment | 17,519.128125 | 22,271.040938 |
| Annual tuition increase | 5% | 6% | Amount still needed at enrolment | 17,519.128125 | 19,153.185376 |
| Years until enrolment | 2 | 3 | Amount still needed at enrolment | 17,519.128125 | 19,895.084531 |
| Savings available today | 30,000 | 33,000 | Amount still needed at enrolment | 17,519.128125 | 14,519.128125 |
| Annual savings return until enrolment | 0% | 1% | Amount still needed at enrolment | 17,519.128125 | 16,916.128125 |
