In: Finance
Richard and Sue wants to provide full funding for their 3 year old daughter who is expected to start college when she is 18. The current annual cost of a 4 year college is $38,000 which is expected to increase by 3.5% per year. They expect to earn 5% on their investment. They have already saved $13,000 in a college fund for this purpose. Calculate the additional amount they should save by the end of every year in order to accumulate funding for 4 years of college when their daughter turns 18.
answer: 10, 298 show how?
Year | Cost of college |
1 | 63663.2556 |
2 | 65891.4695 |
3 | 68197.6709 |
4 | 70584.5894 |
Present value | $249,247.96 |
This is the FV at year 18 | |
FV of initial savings | $27,026.07 |
Balance | $222,221.89 |
Annual savings | $10,298.27 |
WORKINGS