# Use Excel to solve the following problem. Assume that you are 39 years old planning for your future retirement at age 65. You think that you will be comfortable living on the proceeds from a \$1,000,000 401K Retirement Account.a. If your investments grow at an average rate of 6% annually how much must you invest monthly to achieve your projected retirement fund total by the time you retire in 26 years?b. Assuming that when you do retire, you will re-direct your \$1,000,000 investment portfolio into less volatile and more secure mutual funds. You expect that, invested in these sources, your portfolio will securely earn 4.5% annually. Based on your assumptions and the normal life expectancy of an American male or female (I determined this to be 81 years old), without consuming any of your principal, how much money will you have on a monthly basis to support your life?(I have worked this problem out on my own, I just want to be sure I applied the formulas and concepts correctly.)

Question

Use Excel to solve the following problem. Assume that you are 39 years old planning for your future retirement at age 65. You think that you will be comfortable living on the proceeds from a \$1,000,000 401K Retirement Account.
a. If your investments grow at an average rate of 6% annually how much must you invest monthly to achieve your projected retirement fund total by the time you retire in 26 years?
b. Assuming that when you do retire, you will re-direct your \$1,000,000 investment portfolio into less volatile and more secure mutual funds. You expect that, invested in these sources, your portfolio will securely earn 4.5% annually. Based on your assumptions and the normal life expectancy of an American male or female (I determined this to be 81 years old), without consuming any of your principal, how much money will you have on a monthly basis to support your life?
(I have worked this problem out on my own, I just want to be sure I applied the formulas and concepts correctly.)

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 10 steps with 3 images

Knowledge Booster
Recommended textbooks for you
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Pfin (with Mindtap, 1 Term Printed Access Card) (…
Finance
ISBN:
9780357033609
Author:
Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Publisher:
Cengage Learning
PFIN (with PFIN Online, 1 term (6 months) Printed…
Finance
ISBN:
9781337117005
Author:
Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Publisher:
Cengage Learning
Personal Finance
Finance
ISBN:
9781337669214
Author:
GARMAN
Publisher:
Cengage
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Corporate Fin Focused Approach
Finance
ISBN:
9781285660516
Author:
EHRHARDT
Publisher:
Cengage