Funding your retirement

Emily Jacob is 45 years old and has saved nothing for retirement. Fortunately, she just inherited $75,000. Emily plans to put a large portion of that money into an investment account earning an 11% return. She will let the money accumulate for 20 years, when she will be ready to retire. She would like to deposit enough money today so she could begin making withdrawals of $50,000 per year starting at age 66 (21 years from now) and continuing for 24 additional years, when she will make her last withdrawal at age 90. Whatever remains from her inheritance, Emily will spend on a shopping spree. Emily will continue to earn 11% on money in her investment account during her retirement years, and she wants the balance in her retirement account to be $0 after her withdrawal on her ninetieth birthday.

a. How much money must Emily set aside now to achieve that goal? It may be helpful to construct a timeline to visualize the details of this problem.

b. Emily realizes that once she retires she will want to have less risky investments that will earn a slightly lower rate of return, 8% rather than 11%. If Emily can earn 11% on her investments from now until age 65, but she earns just 8% on her investments from age 65 to 90, how much money does she need to set aside today to achieve her goal?

c. Suppose Emily puts all of the $75,000 that she inherited into the account earning 11%. As in part b, she will earn only an 8% return on her investments after age 65. If Emily withdraws $50,000 as planned on each birthday from age 66 to age 90, how much will be left in her account for her heirs after her last withdrawal?

I know that I need to use the future value, present value and annuity concepts but I am not sure how to start. I will be using Excel to figure out the formulas.

Thank you!Funding your retirementEmily Jacob is 45 years old and has saved nothing for retire-ment. Fortunately, she just inherited $75,000. Emily plans to put a large portion of that money into an investment account earning an 11% return. She will let the money accumulate for 20 years, when she will be ready to retire. She would like to deposit enough money today so she could begin making withdrawals of $50,000 per year starting at age 66 (21 years from now) and continuing for 24 additional years, when she will make her last withdrawal at age 90. Whatever remains from her inheritance, Emily will spend on a shopping spree. Emily will continue to earn 11% on money in her investment account during her retirement years, and she wants the balance in her retirement account to be $0 after her withdrawal on her ninetieth birthday.a. How much money must Emily set aside now to achieve that goal? It may be help-ful to construct a timeline to visualize the details of this problem.b. Emily realizes that once she retires she will want to have less risky investments that will earn a slightly lower rate of return, 8% rather than 11%. If Emily can earn 11% on her investments from now until age 65, but she earns just 8% on her investments from age 65 to 90, how much money does she need to set aside today to achieve her goal?c. Suppose Emily puts all of the $75,000 that she inherited into the account earning 11%. As in part b, she will earn only an 8% return on her investments after age 65. If Emily withdraws $50,000 as planned on each birthday from age 66 to age 90, how much will be left in her account for her heirs after her last withdrawal?