Answered step by step
Verified Expert Solution
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
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 workStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started