``` ```
Access requires a valid link.
Calculate required savings for school fees, accounting for inflation and investment returns.
| Year | Contribution | Fee Payment | Investment Return | End Balance |
|---|
Money has time value: £1 today is worth more than £1 tomorrow because you can invest it and earn a return. This means we can't directly add or compare amounts at different points in time—we need to move them to the same point first.
Compounding (moving forward in time): If you have £100 today and earn 5% per year, in one year you have:
In two years:
Discounting (moving backward in time): If you need £100 in one year, how much must you set aside today at 5%?
This is the present value of that future £100.
Let's use concrete numbers:
Fees grow with inflation from today. If school starts in year 5, the fees for each school year are:
| School Year | Calendar Year | Fee Amount |
|---|---|---|
| 1st | Year 5 | \(A(1+g)^5 = £11{,}593\) |
| 2nd | Year 6 | \(A(1+g)^6 = £11{,}941\) |
| 3rd | Year 7 | \(A(1+g)^7 = £12{,}299\) |
| ... | ... | ... |
| 7th | Year 11 | \(A(1+g)^{11} = £13{,}842\) |
In general, a child starting in year \(Y\) pays a fee in their school year \(t\) (where \(t = 0, 1, 2, \ldots, n-1\)) of:
We want to know the total value of all fees in today's money. This is our "target" that we need to fund.
For the fee paid in calendar year \(Y + t\), we discount it back to today by dividing by \((1+r)^{Y+t}\):
The total present value is the sum over all school years. Let's write out the terms explicitly:
Factoring out \(A \left(\frac{1+g}{1+r}\right)^{Y}\):
The bracketed term is a geometric series with first term 1, common ratio \(\rho = \frac{1+g}{1+r}\), and \(n\) terms. The sum formula gives:
So the present value for one child is:
With our example numbers, \(\rho = \frac{1.03}{1.05} \approx 0.981\):
For multiple children starting in different years, we calculate each child's present value separately and sum them:
You want to make equal annual contributions of \(C\) for \(Y_{\min}\) years (until the first child starts), with contributions made at the end of each year.
The present value of these contributions, written out term by term:
Factoring out \(C\):
This is a geometric series with first term \(\frac{1}{1+r}\), ratio \(\frac{1}{1+r}\), and \(Y_{\min}\) terms. Using the sum formula:
The term \(\frac{1 - (1+r)^{-Y}}{r}\) is called the present value annuity factor.
Setting contributions equal to fees and solving for \(C\):
With our example (5 years of contributions):
Now you contribute from today until the last child finishes school. If the last child starts in year \(Y_{\max}\) and school lasts \(n\) years, you contribute for \(Y_{\max} + n\) years total.
The formula is the same, just with more years:
With our example (5 + 7 = 12 years of contributions):
This is roughly half the Mode 1 amount, which makes sense—you're contributing for roughly twice as many years.
The ratio \(\rho = \frac{1+g}{1+r}\) determines how fees grow relative to your investment returns:
When children start at different years, each generates their own stream of fee payments. We calculate each child's present value separately and sum them. For example:
Note that Child B's fees have lower present value because they're further in the future (more discounting).