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.)

EBK CONTEMPORARY FINANCIAL MANAGEMENT
14th Edition
ISBN:9781337514835
Author:MOYER
Publisher:MOYER
Chapter5: The Time Value Of Money
Section: Chapter Questions
Problem 44P
icon
Related questions
icon
Concept explainers
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

Trending now

This is a popular solution!

steps

Step by step

Solved in 10 steps with 3 images

Blurred answer
Knowledge Booster
Retirement Income
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Pfin (with Mindtap, 1 Term Printed Access Card) (…
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…
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
Personal Finance
Finance
ISBN:
9781337669214
Author:
GARMAN
Publisher:
Cengage
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Corporate Fin Focused Approach
Corporate Fin Focused Approach
Finance
ISBN:
9781285660516
Author:
EHRHARDT
Publisher:
Cengage