A 50 year old employee contributes 20000 per year to her 401k, and her employer matches...

A 50 year old employee contributes 20000 per year to her 401k, and her employer matches her contributions by 40%. The investment company has provided her with two options:

	Option 1	Option 2
Equity	60%	40%
Bond	30%	40%
Money Market Fund	10%	20%

The employee wants to retire at 65. The average rates of return presented are 5% on equity, 3% on bonds, and 1% on money market funds. Calculate the total amount of money at the time of retirement under each option.

Solutions

Expert Solution

Step to calculate fund value at retirement

Calculate average return of each option
Calculate the Future value of annual contribution (employee+employer) at average return of option.

Please refer to below spreadsheet for calculation and answer. Cell reference also provided.

Cell reference -

Hope this will help, please do comment if you need any further explanation. Your feedback would be appreciated.

jeff jeffy answered 4 months ago

Next > < Previous

Related Solutions

Steven is contributing to his 401(k) retirement plan. He contributes $3100 per year. His employer matches...

Steven is contributing to his 401(k) retirement plan. He contributes $3100 per year. His employer matches 50% of his contribution. If Steven can earn a 6% rate of return, how much (approximately) will he have in his account after 6 years?(Round your answer). $18433. $32435. $30806. $28572.

Your employer is going to invest $75 per month in a 401k for you and promised...

Your employer is going to invest $75 per month in a 401k for you and promised to average a 5% return over the next 20 years. What would I type into Excel to estimate how much money should be in the 401k after 20 years?

When changing jobs, the preferred way of handling your 401K account balance with your old employer...

When changing jobs, the preferred way of handling your 401K account balance with your old employer is to: a) Convert your account balance with your old employer to cash and use it to pay off your mortgage balance. b) Have the 401k service provider at your new place of employment arrange to have your old account balance placed in an account at your new employer’s 401K plan in what is known as a provider to provider rollover. c) Have your...

C. GrabBag 9. Eriko earns $45,755 per year. She contributes 8% of her income to her...

C. GrabBag 9. Eriko earns $45,755 per year. She contributes 8% of her income to her 401(k) plan at work. In her tax bracket, she would pay 37% of her income in state and federal income taxes. a. How much is she saving this year on her taxes by making these 401(k) plan contributions? b. Suppose that instead of contributing to her 401(k) plan, she decides instead to deposit the same amount of money to a Roth IRA. What would...

Dad has $25,000 in his 401k account and contributes 5% of his salary ever year. His...

Dad has $25,000 in his 401k account and contributes 5% of his salary ever year. His employer will match up to 10% dollar for dollar. He currently has 100% of his 401k invested in the fixed rate fund earning 2%. How much money will dad have after 30 years when he is going to retire? Dad, 35, is an electrical engineer and earns $60,000 per year working for a local aerospace company. He has been getting a 3% raise every...

9) Eriko earns $45,755 per year. She contributes 8% of her income to her 401(k) plan...

9) Eriko earns $45,755 per year. She contributes 8% of her income to her 401(k) plan at work. In her tax bracket, she would pay 37% of her income in state and federal income taxes. A) How much is she saving this year on her taxes by making these 401(k) plan contributions? B) Suppose that instead of contributing to her 401(k) plan, she decides instead to deposit the same amount of money to a Roth IRA. What would her tax...

The mean investment that employees put into their companies 401K per year is $10,000 with a...

The mean investment that employees put into their companies 401K per year is $10,000 with a standard deviation of $500. Assuming the investments follow a normal distribution, determine the following. a. What proportion of employees put between $9,500 and $11,000 into the 401K per year. b. What proportion of employees put more than $11,500 into the 401K per year? c. What proportion of employees put less than $11,000 into the 401K per year? d. What proportion of employees put more...

A 50 year old female was shot in the right side of her chest .she is...

A 50 year old female was shot in the right side of her chest .she is currently in the progrsssive care unit . Her arterial blood gases are as follows : pH -7.30 .PaO2 - 88 mmHg. PaCO2 -50 mmHg. Bicarbonate 26 mEg/L . Lactate 5 mg/dL. 1- does she have an acid base imbalance ? If so what type of imbalance ? 2- what likely caused her to have this condition ? 3 - Her condition continues to deteriorate...

Lisa earns $65,000 per year. She is married and claims three allowances. Assume that her employer...

Lisa earns $65,000 per year. She is married and claims three allowances. Assume that her employer uses wage bracket tables method. Use withholding allowance, wage bracket table and IRS Publication 15. a.If she is paid weekly, what is her withholding per paycheck? b.If she is paid monthly, what is her withholding per paycheck? c.If she is paid biweekly, what is her withholding per paycheck? d.If she is paid semimonthly, what is her withholding per paycheck?

An employee earned $155,000 working for an employer in the current year. The current rate for...

An employee earned $155,000 working for an employer in the current year. The current rate for FICA Social Security is 6.2% payable on earnings up to $127,200 maximum per year and the rate for FICA Medicare 1.45% of all earnings. The employee’s total FICA payroll tax is: A.$11,857.50. B.$9,730.80. C.$10,133.90. D.$2,247.50. E.$0, since the FICA tax is paid entirely by the employer.

Subjects