Question

Stan is going to work for the next 30 years and then retire. Starting the day he retires, he would like to withdraw $90,000 per year (in monthly installments) from an investment account for a twenty-five year retirement. At the end of his retirement, he would like to leave a bequest of $100,000 to his heirs. He currently has $10,000 in his investment account for these purposes. Stan plans to save for retirement by making monthly deposits into the investment account, beginning two years from now and ending the month before he retires. The investment account pays 9 percent compounded monthly. Construct a flexible spreadsheet model to answer the following questions:

1. How much must Stan invest each month to accomplish his retirement goals?
2. If Stan's employer will contribute $0.50 for every $1.00 he invests, how much of the deposit in #1 will Stan have to contribute?

Answer 1

Stan is going to work for the next 30 years and then retire. Starting the day he retires, he would like to withdraw 90,000 per year (in monthly installments) from an investment account for a twenty-five year retirement. At the end of his retirement, he would like to leave a bequest of90,000peryear(inmonthlyinstallments)fromaninvestmentaccountforatwenty−fiveyearretirement.Attheendofhisretirement,hewouldliketoleaveabequestof100,000 to his heirs. He currently has $10,000 in his investment account for these purposes. Stan plans to save for retirement by making monthly deposits into the investment account, beginning two years from now and ending the month before he retires. The investment account pays 9 percent compounded monthly. Construct a flexible spreadsheet model to answer the following questions:

1. How much must Stan invest each month to accomplish his retirement goals?

2. If Stan's employer will contribute 0.50 for every0.50forevery1.00 he invests, how much of the deposit in #1 will Stan have to contribute?