Question: Adam is 24 years old and has a 401(k) plan through his employer, a large financial institution. His company matches 50% of his contributions up

Adam is 24 years old and has a 401(k) plan through his employer, a large financial institution. His company matches 50% of his contributions up to 6% of his salary. He currently contributes the maximum amount he can. In his 401(k), he has three funds. Investment A is a large-cap index fund, which has had an average annual growth over the past ten years of 6.63%. Investment B is a mid-cap index fund with a ten-year average annual growth of 9.89%. Finally, Investment C is a small-cap index fund with a ten-year average annual growth rate of 8.55%. Fifty percent of his contribution is directed to Investment A, 25% to Investment B, and 25% to Investment C. His current salary is $48,000, and based on a compensation survey of financial institutions, he expects an average raise of 2.7% each year. Develop a spreadsheet model that predicts his retirement balance at age 65.

Step by Step Solution

3.41 Rating (154 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Adams Retirement Plan Retirement Contribution of salary 6 Employer Match 50 Mix Annual Salary Increase 270 Investment A 663 50 Investment B 989 25 Investment C 855 25 Investment Balances Age Salary Sa... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Business Analytics Data Questions!