Your five year old daughter has just announced that she would like to attend college The College Board has reported that the average cost of tuition, room, board, and other expenses at public four year colleges is $21,370 in the 20182019 academic year The cost has risen 2 8 over the last year You believe that you can earn a rate of 8 on investments to meet this goal If costs continue to rise at 2 8 per year, how much will it cost for the first year of tuition in 13 years Assuming that you plan to have enough money saved in 13 years to cover all four years of college costs, how much will you need to have accumulated by that time Note that the cost of tuition, room, and board is a graduated annuity growing 2 8 per year, and assume that you will pay all costs at the beginning of each year If you were to invest a lump sum today in hopes of covering your daughters college costs, how much would you have to invest If you decided to invest annually instead, how much would you have to invest each year What if you make investments monthly You just learned of a $10,000 inheritance and plan to invest it in your daughters college fund Given this new source of funds, how much will you now have to invest each year Show Excel Functions B $ 21,370 2 80 30,600 $ 8 13 4 10,000 $ A 1 Cost of College Today 2 Annual Rate of Increase 3 First Year Cost of College 4 Annual Rate of Return 5 Years until college 6 Years in College 7 Inheritance 8 9 Assuming First Cash Flow in Period 1 10 Amount needed in 12 years 11 Lump sum required today 12 Annual investment required (ending in year 12) 13 Annual investment with inheritance (ending in year 12) 14 Annual investment required (ending in year 16) 15 Annual investment with inheritance (ending in year 16) 16 17 18 19 20 21 22 23 24 Assuming First Cash Flow in Period 0 25 Amount needed in 13 years 26 Lump sum required today 27 Annual investment required (ending in year 12) 28 Annual investment with inheritance (ending in year 12) 29 Annual investment required (ending in year 15) 30 Annual investment with inheritance (ending in year 16) 31

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Oct 03, 2024

Your five-year-old daughter has just announced that she would like to attend college. The College Board has reported that the average cost of tuition, room,

Your five-year-old daughter has just announced that she would like to attend college. The College Board has reported that the average cost of tuition, room, board, and other expenses at public four-year colleges is $21,370 in the 20182019 academic year.* The cost has risen 2.8% over the last year. You believe that you can earn a rate of 8% on investments to meet this goal.
1. If costs continue to rise at 2.8% per year, how much will it cost for the first year of tuition in 13 years?
2. Assuming that you plan to have enough money saved in 13 years to cover all four years of college costs, how much will you need to have accumulated by that time? Note that the cost of tuition, room, and board is a graduated annuity growing 2.8% per year, and assume that you will pay all costs at the beginning of each year.
3. If you were to invest a lump sum today in hopes of covering your daughters college costs, how much would you have to invest?
4. If you decided to invest annually instead, how much would you have to invest each year? What if you make investments monthly?
5. You just learned of a $10,000 inheritance and plan to invest it in your daughters college fund. Given this new source of funds, how much will you now have to invest each year? Show Excel Functions

B $ 21,370 2.80% 30,600 $ 8% 13 4 10,000 $ A 1 Cost of College Today 2 Annual Rate of Increase 3. First Year Cost of College 4 Annual Rate of Return 5 Years until college 6 Years in College 7 Inheritance 8 9 Assuming First Cash Flow in Period 1 10 Amount needed in 12 years 11 Lump sum required today 12 Annual investment required (ending in year 12) 13 Annual investment with inheritance (ending in year 12) 14 Annual investment required (ending in year 16) 15 Annual investment with inheritance (ending in year 16) 16 17 18 19 20 21 22 23 24 Assuming First Cash Flow in Period 0 25 Amount needed in 13 years 26 Lump sum required today 27 Annual investment required (ending in year 12) 28 Annual investment with inheritance (ending in year 12) 29 Annual investment required (ending in year 15) 30 Annual investment with inheritance (ending in year 16) 31