In: Finance
Q1. Babu is saving for his son’s college tuition. His son is currently 11 years old and will begin college in seven years. Babu has an index fund investment worth $7,500 that is earning 9.5 percent annually. Total expenses at the Black Hills State University, where his son says he plans to go, currently total $15,000 per year, but are expected to grow at roughly 6 percent each year. Babu plans to invest in a mutual fund that will earn 11 percent annually to make up the difference between the college expenses and his current savings. In total, Babu will make seven equal investments with the first starting today and with the last being made a year before his son begins college. (12 points)
1.
Age of Babu's Son | Tuition Fees per year | PV of the Tuition Fees when babu's son is 18 |
18 | $ 22,554.45 | $ 22,554.45 |
19 | $ 23,907.72 | $ 22,661.35 |
20 | $ 25,342.18 | $ 22,768.75 |
21 | $ 26,862.72 | $ 22,876.66 |
Value of Fees when Babu's son is 18= | $ 90,861.20 |
2.
Value of Index Fund when Babu's Son is 11 | $ 7,500.00 |
Value of Index Fund when Babu's Son is 18 | $ 14,156.64 |
3.
Amount needs to be saved will be equal to the amount of Value of Fees when Babu's son is 18 which we calculaed above in part (1) i.e. $90,861.20.
4.