Jill would like to plan for her son's college education. She would like for her son, who was born today, to attend college for 5 years, beginning at age 18. Tuition is currently $12,000 per year and tuition inflation is 6%. Jill can earn an after-tax rate of return of 9%. How much must Jill save at the end of each year, if she wants to make the last payment at the beginning of her son's first year of college?
$3,145.81 |
||
$3,924.55 |
||
$4,406.75 |
||
$4,854.07 |
First we need to calculate amount required at age 18
Age 18 = 12000 * (1+0.06)^18 = $34252.07
Age 19 = $34252.07 * 1.06 = $36307.19
Age 20 = $34252.07 * (1.06^2) = $38485.63
Age 21 = $34252.07 * (1.06^3) = $40794.76
Age 22 = $34252.07 * (1.06^4) = $43242.45
Calculation of PV required at age 18
Requirement | Discounting factor | PV | |
1 | 34252.07 | 1 | 34252.069835 |
2 | 36307.19 | 0.917431193 | 33309.352317 |
3 | 38485.63 | 0.841679993 | 32392.581152 |
4 | 40794.76 | 0.77218348 | 31501.042221 |
5 | 43242.45 | 0.708425211 | 30634.041059 |
Total | 162089.086584 |
Calculation of FV of annuity
FV of annuity = P[(1+r)^n - 1] / r
162089.086584 = P[(1+0.09)^18 - 1]/0.09
162089.086584 = P(4.71712 - 1)/0.09
P = 162089.086584/41.30134
P = 3924.55
Therefore correct answer is $3924.55
Get Answers For Free
Most questions answered within 1 hours.