Question

Ashley turned 30 today, and she is planning to save $3,000 per year for retirement, with the first deposit to be made one year from today. She will invest in a mutual fund, which she expects to provide a return of 8.20% per year throughout her lifetime. She plans to retire 35 years from today, when she turns 65, and she expects to live for 30 years after retirement, to age 95. Under these assumptions, how much can she spend in each year after she retires? Her first withdrawal will be made at the end of her first retirement year, and she plans on leaving no money to her heirs.

Your answer should be between 28,800.00 and 95,225.00.

Answer 1

Retirement Savings per year (PMT) = $ 3,000

Return from mutual fund (rate) = 8.2%

Number of years to retirement (nper) = 35 years

Retirement corpus once turned 65 (FV) = = $ 540,528.53

During retirement period ,

Present value of corpus (PV) = $ 540,528.53

Rate = 8.2%

Number of years (nper) = 30

Withdrawal amount per year (PMT) = = $ 48,922.64