Question: Problem 1 Mr. & Mrs. Jones are planning for the education of their young child. They plan to save a fixed amount of money every
Problem 1 Mr. & Mrs. Jones are planning for the education of their young child. They plan to save a fixed amount of money every month for the next 10 years. Once the kid goes to college, they expect to spend $2,500 per month for 4 years to cover all college-related expenses, such as tuition and living expense. The grandparents plan to contribute a lump sum investment today (periodo) in the amount of $5,000 and an additional $200 per month over the next 10 years. The expected rate of return is 2.0% per year, with monthly compounding. Below is the timeline in years. Spending stage 10'11 14 + Saving stage Note that you are solving the problem from scratch. You can organize the spreadsheet as you see fit. However, all the calculations should be done in Excel. Please show all your work for full credit. 1. Calculate how much money Mr. and Mrs. Jones will need to have 10 years from now, right before their kid goes to college. Please use formulas. 2. Calculate how much Mr. and Mrs. Jones need to save every month from year 1 to year 10 so they can achieve their goal and send their kid to college for 4 years. Do not forget to take into account the contributions of the grandparents. Please use formulas
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
