Question

Assume you have chosen to invest the $1,000 monthly contributions at the end of each month. Once retired, you will adjust your investment allocation to be more conservative and expect to average a 4% return on the account each year, compounded monthly. While retired, you plan to draw $5,000 from the account at the end of each month to go towards living expenses. You expect your lifespan in retirement to be 30 years. EXCEL format

A. How much money will you need to have at the beginning of retirement to fund the $5,000 monthly withdrawals for 30 years?

B. How many months could $5,000 be withdrawn before the account would be out of money?

Answer 1

Please dont forget to upvote