Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Retirement COMPARISON: Your future employer will match your 401k investments 50%, but your high school counterpart does not receive help with their retirement plan from

image text in transcribed
Retirement COMPARISON: Your future employer will match your 401k investments 50%, but your high school counterpart does not receive help with their retirement plan from their employer. You and your high school counterpart are able to invest at least 5% of your salary in a 401k investments that will earn a 7% annual return. Use Excel to determine the balance in the accounts after 40 years of investments. Experts recommend having 10 times your salary in funds when you retire. How many years of investing would it take each of you to reach the ten times goal? Write down the total value of your 401k after 40 years of investment. Don't forget the criteria above. Write down the total value of the high school graduate's 401k after the 40 years of investment. Write down exactly what you typed in excel to determine the 40 years of investment for yourself. Write down exactly what you typed in excel to determine the 40 years of investment for the high school Braduate. What is 10 times your salary. Using Excel, determine how many years it will take to reach 10 times your salary. Include in your paper exactly what you typed in Excel. Now, do the same for the high school graduate. How many years it will take for the high school graduate to reach 10 times their salary. Include in your paper exactly what you typed in Excel. Reflect on the values you found, do these values meet your expectations, or will you change your investment strategy? What about the high school graduate

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

Accounting Business Reporting For Decision Making

Authors: Jacqueline Birt, Keryn Chalmers, Suzanne Maloney, Albie Brooks, Judy Oliver

6th Edition

978-0730363415, 0730363414

More Books

Students also viewed these Accounting questions

Question

Define Management by exception

Answered: 1 week ago

Question

Explain the importance of staffing in business organisations

Answered: 1 week ago

Question

What are the types of forms of communication ?

Answered: 1 week ago