Question: please solve using excel functions. When you retire 40 years from now, you plan to make 10 withdrawals from your savings account. You will need

please solve using excel functions.
When you retire 40 years from now, you plan to make 10 withdrawals from your savings account. You will need $130,000 per year for 2 years, then $140,000 for 3 years and $160,000 for 5 years, in that order at the end of each year. You want to start saving for retirement now and plan to make end of year annual payments for 20 years into an account that yields 8 percent compounded annually. After these deposits you plan to leave the money in the savings account until retirement earning the same interest. What should these 20 equal annual payments be in order to satisfy your retirement needs
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
