You are saving for the college education of your two children. One child will enter college in 5 years, while the other child will enter college in 7 years. College costs are currently $10,000 per year and are expected to grow at a rate of 5 percent per year. All college costs are paid at the beginning of the year. You assume that each child will be in college for four years.
You currently have $50,000 in your educational fund. Your plan is to contribute a fixed amount to the fund over each of the next 5 years. Your first contribution will come at the end of this year, and your final contribution will come at the date at which you make the first tuition payment for your oldest child. You expect to invest your contributions into various investments which are expected to earn 8 percent per year. How much should you contribute each year in order to meet the expected cost of your children's education?© BrainMass Inc. brainmass.com June 3, 2020, 8:01 pm ad1c9bdddf
Calculations are done in Excel for you. No references.