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?

Compute how much you need to save each month for your retirement goal from the financial planning assignment earlier this semester (Assignment 1). Assume an expected return of 8.8% per year.

Excel equations