Question: please use excel functions to solve this question. Problem 5-41 Retirement Savings (L03) A couple will retire in 40 years; they plan to spend about

please use excel functions to solve this question.please use excel functions to solve this question. Problem 5-41 Retirement Savings

Problem 5-41 Retirement Savings (L03) A couple will retire in 40 years; they plan to spend about $29,000 a year in retirement, which should last about 20 years. They believe that they can earn 9% interest on retirement savings. a. If they make annual payments into a savings plan, how much will they need to save each year? Assume the first payment comes in 1 year. (Do not round intermediate calculations. Round your answer to 2 decimal places.) Annual savings b. How would the answer to part (a) change if the couple also realize that in 15 years they will need to spend $59,000 on their child's college education? (Do not round intermediate calculations. Round your answer to 2 decimal places.) Annual savings

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!