Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I'm not sure how to input the data on excel. I should have 3 tabs. One for Need, another for Accumalate, and lastly one for

image text in transcribed

I'm not sure how to input the data on excel. I should have 3 tabs. One for Need, another for Accumalate, and lastly one for Withdrawal.

John Doe, a 23 years young newly graduated engineer just got a job in a major engineering firm. Human resources told him that he could join the company's 401K Plan, and his maximum contribution can't exceed 10% of his gross annual salary and the company will match 5% to his contribution. He is paid $35 per hour and he gets a 3% raise every other year, after 20 years of work he is laid off. Roth IRA is S5500 per year during this period. (Age23-42) He finds another job with an annual salary of $120000 per year and works till his retirement (43-67), The new company doesn't have a retirement plan and he can only save in his Personal IRA S15000 per year on the average. During second half of his career the salary increase is only 4% every two years and there are no medical benefits either. John is assuming that at retirement he has paid off his mortgage and he doesn't have major consumer debt and based on today's buying power he only needs $5'000 $6'000 to live well. For this project you are required to examine 1. How much money he needs during retirement? His life expectancy is 95 years 2. How much does he need to retireage 677 3. At what age he could take early retirement if he wants to retire sooner when should he start his investments in Roth IRA account? 4. You may go to Morningstar.com or AmericanFunds.com to research and use the funds that their performance is about 10% or more and show the source 5. Must use Ms-Excel to show work. John Doe, a 23 years young newly graduated engineer just got a job in a major engineering firm. Human resources told him that he could join the company's 401K Plan, and his maximum contribution can't exceed 10% of his gross annual salary and the company will match 5% to his contribution. He is paid $35 per hour and he gets a 3% raise every other year, after 20 years of work he is laid off. Roth IRA is S5500 per year during this period. (Age23-42) He finds another job with an annual salary of $120000 per year and works till his retirement (43-67), The new company doesn't have a retirement plan and he can only save in his Personal IRA S15000 per year on the average. During second half of his career the salary increase is only 4% every two years and there are no medical benefits either. John is assuming that at retirement he has paid off his mortgage and he doesn't have major consumer debt and based on today's buying power he only needs $5'000 $6'000 to live well. For this project you are required to examine 1. How much money he needs during retirement? His life expectancy is 95 years 2. How much does he need to retireage 677 3. At what age he could take early retirement if he wants to retire sooner when should he start his investments in Roth IRA account? 4. You may go to Morningstar.com or AmericanFunds.com to research and use the funds that their performance is about 10% or more and show the source 5. Must use Ms-Excel to show work

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

International Finance

Authors: Keith Pilbeam

3rd Edition

1403948372, 978-1403948373

More Books

Students also viewed these Finance questions

Question

What is a supply alliance?

Answered: 1 week ago

Question

How do media shape our thinking?

Answered: 1 week ago

Question

Describe Elizabeths credibilityinitial, derived, and terminal.

Answered: 1 week ago