Question: Please help me solve this problem in Excel using financial functions. Retirement Savings. A couple will retire in 50 years; they plan to spend about
Please help me solve this problem in Excel using financial functions.
Retirement Savings. A couple will retire in 50 years; they plan to spend about $30,000 a year in retirement, which should last about 25 years. They believe that they can earn 8% interest on retirement savings. (LO5-3)
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.
b. How would the answer to part (a) change if the couple also realize that in 20 years they will need to spend $60,000 on their childs college education?
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
