Time Value Money / using excel sheet At retirement, an investor plans to withdraw $40,000 per year. The investor assumes that he/she can earn an average 6% return over the 25 years they expect to make withdrawals. How much must this investor have accumulated in order to achieve their objective of withdrawing $40,000 per year? What if the investor in question 4 wants to withdraw $3,600 per month?

An investor can afford to set aside $900 per month for retirement. He/she anticipates earning an average 8% return over a 30-year period. This investor would like to have $2,000,000 at retirement in 30 years. Will this investor meet this goal given the $900 per month contribution? How much more must this person set aside each month to meet the goal of $2,000,000 at retirement? If the investor cannot afford the additional contribution needed to meet the goal, what are some other options in planning for his/her retirement?