Question

duction to Financial Management - Solutions Names: of Money Homan Lau tion, room, board and fees for Harvard is $69,607 for academic year 2019-2020. The average & son since inception in 1929 has been about 3% per var You have a newborn child and would like to be con pay for four years of college. She will begin college at the age of 17. Calculate the tuition for each other four ars of college. You are considering investing in Fidelity's Spartan fund which has an average lifetime return of 8.91%. Assume the fund continues to perform at 8.91% per year. How much money do you have to deposit today to pay the tuition for all four years? For simplification, assume that you want to have all of the money when she begins college, so just add the values for all four years of tuition that you calculated in #1. This is how much money you want to have in 17 years. Now assume that you invested the value that you calculated in the previous question. Instead of 8.91% year, assume that the actual return for the Spartan Fund was 3.6% per year. This means that you will ne all the money that you want in 17 years. By how much would you be short of your goal?

Answer 1

Year	Fees ($)			PV (Present Value)	$109,509.00			Year	start principal	start balance	interest	end balance	end principal
1	69607			N (Number of Periods)	17			1	$109,509.00	$109,509.00	$9,757.25	$119,266.25	$109,509.00
2	71695.21			I/Y (Interest Rate)	8.91			2	$109,509.00	$119,266.25	$10,626.62	$129,892.87	$109,509.00
3	73846.07			PMT (Periodic Deposit)	$0.00			3	$109,509.00	$129,892.87	$11,573.46	$141,466.33	$109,509.00
4	76061.45			Starting Amount	$109,509.00			4	$109,509.00	$141,466.33	$12,604.65	$154,070.98	$109,509.00
5	78343.29			Total Periodic Deposits	$0.00			5	$109,509.00	$154,070.98	$13,727.72	$167,798.70	$109,509.00
6	80693.59			Total Interest	$357,797.37			6	$109,509.00	$167,798.70	$14,950.86	$182,749.57	$109,509.00
7	83114.4							7	$109,509.00	$182,749.57	$16,282.99	$199,032.56	$109,509.00
8	85607.83			Future Value:	$467,306.37			8	$109,509.00	$199,032.56	$17,733.80	$216,766.36	$109,509.00
9	88176.07							9	$109,509.00	$216,766.36	$19,313.88	$236,080.24	$109,509.00
10	90821.35							10	$109,509.00	$236,080.24	$21,034.75	$257,114.99	$109,509.00
11	93545.99							11	$109,509.00	$257,114.99	$22,908.95	$280,023.93	$109,509.00
12	96352.37							12	$109,509.00	$280,023.93	$24,950.13	$304,974.07	$109,509.00
13	99242.94							13	$109,509.00	$304,974.07	$27,173.19	$332,147.26	$109,509.00
14	102220.2			Total fees for Four years 17-20				14	$109,509.00	$332,147.26	$29,594.32	$361,741.58	$109,509.00
15	105286.8			467306.1202				15	$109,509.00	$361,741.58	$32,231.17	$393,972.75	$109,509.00
16	108445.4							16	$109,509.00	$393,972.75	$35,102.97	$429,075.72	$109,509.00
17	111698.8							17	$109,509.00	$429,075.72	$38,230.65	$467,306.37	$109,509.00
18	115049.8										$357,797.36
19	118501.3
20	122056.3
				PV (Present Value)	$109,509.00			Year	start principal	start balance	interest	end balance	end principal
				N (Number of Periods)	17			1	$109,509.00	$109,509.00	$3,942.32	$113,451.32	$109,509.00
				I/Y (Interest Rate)	3.6			2	$109,509.00	$113,451.32	$4,084.25	$117,535.57	$109,509.00
				PMT (Periodic Deposit)	$0.00			3	$109,509.00	$117,535.57	$4,231.28	$121,766.85	$109,509.00
				Starting Amount	$109,509.00			4	$109,509.00	$121,766.85	$4,383.61	$126,150.46	$109,509.00
				Total Periodic Deposits	$0.00			5	$109,509.00	$126,150.46	$4,541.42	$130,691.88	$109,509.00
				Total Interest	$90,277.28			6	$109,509.00	$130,691.88	$4,704.91	$135,396.78	$109,509.00
								7	$109,509.00	$135,396.78	$4,874.28	$140,271.07	$109,509.00
				Future Value:	$199,786.28			8	$109,509.00	$140,271.07	$5,049.76	$145,320.83	$109,509.00
								9	$109,509.00	$145,320.83	$5,231.55	$150,552.38	$109,509.00
								10	$109,509.00	$150,552.38	$5,419.89	$155,972.26	$109,509.00
								11	$109,509.00	$155,972.26	$5,615.00	$161,587.26	$109,509.00
								12	$109,509.00	$161,587.26	$5,817.14	$167,404.40	$109,509.00
				Short of goal if growth rate 3.6%				13	$109,509.00	$167,404.40	$6,026.56	$173,430.96	$109,509.00
				$267,520.09				14	$109,509.00	$173,430.96	$6,243.51	$179,674.48	$109,509.00
								15	$109,509.00	$179,674.48	$6,468.28	$186,142.76	$109,509.00
								16	$109,509.00	$186,142.76	$6,701.14	$192,843.90	$109,509.00
								17	$109,509.00	$192,843.90	$6,942.38	$199,786.28	$109,509.00
											$90,277.28