please use excel and show formulas in cells

(Use the following data to answer the next two questions.) A newly developed fund has total capital of $5 million invested in five stocks, Stock Investment Stock's Beta A $1.5 million 0.5 B 0.8 million 0.8 C 0.7 million 1.4 D 1.0 million 1.6 E 1.0 million 1.8 The current risk-free rate is 2 percent, whereas market returns have the following estimated probability distribution for the next period: 0.2 I Probability Market Return 0.1 10% 12% 0.4 13% 0.2 16% 0.1 17% 24. Compute the fund's required rate of return for the next period. 25. Suppose there is an investment opportunity with its beta coefficient of 1.8. Currently, the expected return on the opportunity is 15%. Would you invest in the opportunity