An Investor wants to Invest $$300,000$ in a portfolio of three mutual funds. The annual fund returns are normally distributed with a mean

of $4\%$ and standard deviation of $0\mathrm{.}5\%$ for the short$-$term Investment fund, a mean of $7\%$ and standard deviation of $4\%$ for the

Intermediate$-$term fund, and a mean of $8\mathrm{.}3\%$ and standard deviation of $3\%$ for the long$-$term fund. An Inltial plan for the investment

allocation is $45\%$ in the short$-$term fund, $35\%$ in the intermedlate$-$term fund, and $20\%$ in the long$-$term fund.

a$.$ Use Analysis ToolPak, with a seed of $1,$ to develop a Monte Carlo simulation with $1000$ trlals to estimate the mean ending balance

after the first year.

Note: Round the final answer to two decimal places.

Mean ending balance after the first year

b$.$ If the allocation is changed to $30\%$ short$-$term, $55\%$ intermediate$-$term, and $15\%$ long$-$term, estimate the ending balance after the first

year.

Note: Round the flinal answer to two decimal places.

Mean ending balance after the first year

c$.$ Compare the two Investment strategles in parts a and b and choose the most approprlate answer from the following choices.

On average, the Investment strategy in part a is more risky and ylelds a lower return.

On average, the investment strategy in part a is less risky and ylelds a higher return.

On average, the investment strategy in part a is less risky but ylelds a lower return.

On average, the investment strategy in part a is more risky but ylelds a higher return.