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
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
Get step-by-step solutions from verified subject matter experts
