1 answer

Millhouse graduated 5 years ago with a degree in business administration and is currently employed as...

Question:

Millhouse graduated 5 years ago with a degree in business administration and is currently employed as a middle level manager for the same firecracker company his dad already worked for. His current annual salary of $60,000 has increased at an average rate of 5% per year and is projected to increase at that rate for the future. The firm has had a voluntary retirement savings program in place, whereby, employees can contribute up to 11% of their gross annual salary (up to a maximum of $11,000 per year) and the company will match every dollar that the employee contributes. Unfortunately, Millhouse did not listen to his finance instructor (which is understandable, because you can’t really trust those Germans) and has not yet taken advantage of the retirement savings program. He opted instead to buy a new car, rent an expensive apartment and go out to Moe’s every night. However, with wedding plans on the horizon, Millhouse has finally come to the realization (with the help of his fiancée Lisa) that he had better start putting away some money. Millhouse figures that the two largest expenses down the road would be those related to the wedding and down payment on a house. He estimates that the wedding, which will take place in twelve months, should cost about $10,000. Furthermore, he plans to move into a $200,000 house in 5 years and would need 20% for a down payment. Millhouse knows that an automatic payroll deduction is probably the best way to go since he is not a very disciplined investor.

1) Had Millhouse availed of the company’s voluntary retirement plan up to the maximum every year for the past five years, how much money would he currently have accumulated in his retirement account, assuming monthly deposits and a rate of return of 6% with interest compounded monthly? How much more would he have, had he opted for a higher risk alternative which was expected to yield 10%, compounded monthly?


Answers

5 years ago.Salary was $ 60000 annually , the per month salary is $5000 and the total contribution (including employer) would be 22% i.e. $ 1100. This would increase eveery 2nd year by 5% . The 5th year contribution by the employer would b e

= 11% of annual salary = 11% of 60000 *(1.05)4 =$8022.34

As this does not exceed $ 11000 the company would contine to pay 11% of salary

Hence , we have to find the future value of all the contributions for last 5 years (60 months) at 6% monthly compounded i.e. 0.5% per month)

FV of first contribution = 1100 * (1+0.005)59   (assuming end of month contribution so compounding period is 59 months)

FV of second contribution = 1100 * (1+0.005)58

and so on till

FV of 12th contribution = 1100 * (1+0.005)48

FV of 13th contribution = 1100 * 1.05 * (1+0.005)48

and so on

Adding

FV = 1100 * (1.00559+ 1.00558 + ....

1.00548) + 1100 *1.05 * (1.00547+ ... 1.00536) +..... + 1100*1.054 * (1.00511+....+1)

Writing the 12 month terms in reverse and Applying the sum of GP formula

= 1100 * 1.00548 * (1.00512-1)/(1.005-1) + 1100*1.05 *1.00536 * (1.00512-1)/(1.005-1) +... + 1100*1.054 * (1.00512-1)/(1.005-1)

= 17239.42 +17049.79+16862.26+16676.78+16493.35

= $84321.60

Millhouse would have accumulated $84321.60 by now had he followed the company policy

If Millhouse had opted for a higher risk alternative of 10% , we can forget his company's contribution and only his contribution of 550 per month would be present . Monthly interest rate = 10/12 = 0.83333%

So , by the same formula as above , the amount accumulated by now would have been

FV = 550 * 1.00833348 * (1.00833312-1)/(1.008333-1) + 550*1.05 *1.00833336 * (1.00833312-1)/(1.008333-1) +...

+ 550*1.054 * (1.00833312-1)/(1.008333-1)

= 10293.02 +9783.24+9298.70+8838.16+8400.44

= $46613.56

Millhouse would have accumulated $46613.56 by now had he followed the higher risk option

.

Similar Solved Questions

1 answer
Identify two changes that would shift the marginal product of capital curve INWARD
Identify two changes that would shift the marginal product of capital curve INWARD...
1 answer
Draw the major product of the following reaction sequence. VL1.CO2 SOCI2 OH 2. H30+ pyridine pyridine...
Draw the major product of the following reaction sequence. VL1.CO2 SOCI2 OH 2. H30+ pyridine pyridine Create OscerSketch Answer 1...
1 answer
Two years ago, you purchased 100 shares of General Mills Corporation. Your purchase price was $59...
Two years ago, you purchased 100 shares of General Mills Corporation. Your purchase price was $59 a share, plus a total commission of $29 to purchase the stock. During the last two years, you have received the following dividend amounts: $1.60 per share for the first year and $1.71 per share the sec...
1 answer
8. A uniform ladder of mass (m = 14.5 kg) and length (L) leans against a...
8. A uniform ladder of mass (m = 14.5 kg) and length (L) leans against a frictionless wall, see figure. If the angle θ = 70.0°, find the static friction force between the ladder and the floor when a 80.0-kg person stands half way up the ladder? N...
1 answer
Mickley Company's plantwide predetermined overhead rate is $21.00 per direct labor-hour and its direct labor wage...
Mickley Company's plantwide predetermined overhead rate is $21.00 per direct labor-hour and its direct labor wage rate is $14.00 per hour. The following information pertains to Job A-500: Direct materials Direct labor $300 $140 Required: 1. What is the total manufacturing cost assigned to Job A-...
1 answer
If the reserve ratio was 20% and someone depositeu an additional $8,000, what would be the...
If the reserve ratio was 20% and someone depositeu an additional $8,000, what would be the maximum increase in total deposits over time? $60,000 $266,667 $600,000 $6,000 $40,000...
1 answer
Novak Corp. was organized on January 1, 2017, It is authorized to issue 24,000 shares of...
Novak Corp. was organized on January 1, 2017, It is authorized to issue 24,000 shares of 5%, $53 par value preferred stock and 460,000 shares of no-par common stock with a stated value of $1 per share. The following stock transactions were completed during the first year. Jan. 10 Issued 70,000 share...
1 answer
The angle is 15.11 degrees A 1295 Kg car a 2000 kg pickup truck approach a...
The angle is 15.11 degrees A 1295 Kg car a 2000 kg pickup truck approach a curve on the expressway that has a radius of 292 m. As the car and truck around the curve at 62.2 mph, find the normal force on the car due to the highway surface. Express your answer to three significant figures. N_cat = A t...
1 answer
A 60mm diameter pipe contains glycerin with a density of 1258 kg/m³ at 8.5 m³/hr. The...
A 60mm diameter pipe contains glycerin with a density of 1258 kg/m³ at 8.5 m³/hr. The pressure are 1 atm and 3.8 atm for A and B consecutively. B is 12m higher than A. (1 atm = 101.4 kPa) Compute the glycerin flowing inside the pipe, the Reynolds number if μ = 1.49, and the head loss fo...
1 answer
006 10.0 points You place a box weighing 386.7 N on an in- clined plane that...
006 10.0 points You place a box weighing 386.7 N on an in- clined plane that makes a 39.7 angle with the horizontal. ompute the component of the gravita- tional force acting down the inclined plane. Answer in units of N....
1 answer
Water flows through a pipe of diameter 2.0 cm with a speed of 4.00m/s and pressure...
Water flows through a pipe of diameter 2.0 cm with a speed of 4.00m/s and pressure 2.00x104Pa. What will be its speed and pressure if the pipe diameter changes to 6.00cm...
1 answer
The result from part one is in pen i just need help with parts 2 and...
the result from part one is in pen i just need help with parts 2 and 3 thanks! For the expression you derived in question 1, show that the maximum/minimum value of the function you obtained is at the midpoint between the two coils. Is the midpoint between the two coils a maximum or a minimum? Show ...
1 answer
> Moving to another question will save this response. « Question 6 of 25 > >>...
> Moving to another question will save this response. « Question 6 of 25 > >> Question 6 4 points Saved Penn Inc. needs to borrow $250,000 for the next 6 months. The company has a line of credit with a bank that allows the company to borrow funds with an 7% interest rate subject to...
1 answer
Write out the complete functional forms of all three of the 2p orbitals
Write out the complete functional forms of all three of the 2p orbitals...
1 answer
Given your understanding of the health behavior and what you have learned from the behavior change...
Given your understanding of the health behavior and what you have learned from the behavior change literature, describe a novel intervention approach or combination of approaches to changing HIV that you believe might be successful. Provide a rationale for your approach and discuss how it is guided ...
1 answer
3. If P(A) = 0.6, P(B) = 0.55 and P() = 0.2, find P ( (A...
3. If P(A) = 0.6, P(B) = 0.55 and P() = 0.2, find P ( (A U B) \ () ). Please show using diagrams, and what does the symbol " \ " mean? We were unable to transcribe this imageWe were unable to transcribe this image...