Question 2. Upon starting your new job after college, you'vebeen confronted with selecting the investments for your 401(k)retirement plan. You have four choices for investing yourmoney:
- a money market fund that has historically returned about 0.50%per year.
- A long-term bond fund that has earned an average annual returnof 4.0%
- A conservative common-stock fund that has earned 6.0% peryear.
- An aggressive common-stock fund that has earned 9.0% peryear.
a. If you were to contribute $5,500 per year for the next 35years, how much would you accumulate in each of the abovefunds?
b. Now, change your worksheet so that it allows for less thanannual investments (monthly, weekly, etc.). The annual investmentwill be the same, but it will be made in smaller, more frequent,amounts.
c. Set up a scenario analysis that shows your accumulated valuein each fund if you were to invest quarterly, monthly, biweekly,and weekly. Create a scenario summary table of your results.
d. What relationship do you notice between the frequency ofinvestment and future value? Create a column chart of the resultsthat more clearly shows the outcome from more frequentlyinvesting.
I need to know the excel formula step by step to get this done.I have A but need B C and D
