Upon starting your new job after college, you've been confronted with selecting the investments for your $401(k)$ retirement plan. You have four choices for investing your money:

A money market fund that has historically returned about $1\%$ per year.

A long$-$term bond fund that has earned an average annual return of $4\mathrm{.}5\%.$

A conservative common$-$stock fund that has earned $6\mathrm{.}5\%$ per year.

An aggressive common$-$stock fund that has earned $9\mathrm{.}0\%$ per year.

a$.$ If you were to contribute $$5,500$ per year for the next $35$ years, how much would you accumulate in each of the above funds?

b$.$ Now, change your worksheet so that it allows for less than annual investments $($monthly$,$ biweekly, etc.$).$ The annual investment will be the same, but it will be made in smaller, more frequent, amounts.

c$.$ Set up a scenario analysis that shows your accumulated value in each fund if you were to invest quarterly, monthly, biweekly, and weekly. Create a scenario summary of your results.

d$.$ What relationship do you notice between the frequency of investment and the future value? Create a column chart of the results that more clearly shows the outcome from more frequently investing.

I ONLY NEED HELP ON PART B PLEASE SHOW ON EXCEL WITH FORMULAS THANK YOU!