Please solve using excel showing formulas used. Thank you!

Benefits of diversification. Sally Rogers has decided to invest her wealth equally across the following three assets: a. What are her expected returns and the risk from her investment in the three assets? How do they compare with investing in asset M alone? Hint Find the standard deviations of asset M and of the portfolio equally invested in assets M, N, and O. b. Could Sally reduce her total risk even more by using assets M and N only, assets M and O only, or assets N and O only? Use a 50/50 split between the asset pairs, and find the standard deviation of each asset pair. a. What is the expected return of investing equally in all three assets M, N, and O? i X - Data Table 9.42% (Round to two decimal places.) What is the expected return of investing in asset Malone? Asset Return 7.41 % (Round to two decimal places.) 0% States Boom Normal Recession Probability 28% 45% 27% Asset M Return 12% 9% 0% Asset N Return 23% 14% 3% What is the standard deviation of the portfolio that invests equally in all three assets M, N, and O? 9% 12% 2.72 % (Round to two decimal places.) What is the standard deviation of asset M? Print Done 4.68 % (Round to two decimal places.) By investing in the portfolio that invests equally in all three assets M, N, and O rather than asset M alone, Sally can benefit by increasing her return by 2.01 % and decrease her risk by 1.96 %. (Round to two decimal places.) b. What is the expected return of a portfolio of 50% asset M and 50% asset N? % (Round to two decimal places.) b. 1- What is the expected return of a portfolio of 50% asset M and 50% asset N? % (Round to two decimal places.) 2- What is the expected return of a portfolio of 50% asset M and 50% asset O? % (Round to two decimal places.) 3- What is the expected return of a portfolio of 50% asset N and 50% asset O? % (Round to two decimal places.) 4- What is the standard deviation of a portfolio of 50% asset Mand 50% asset N? % (Round to two decimal places.) 5. What is the standard deviation of a portfolio of 50% asset Mand 50% asset O? % (Round to two decimal places.) 6- What is the standard deviation of a portfolio of 50% asset N and 50% asset O? % (Round to two decimal places.) 7- Could Sally reduce her total risk even more by using assets M and N only, assets M and O only, or assets N and O only? (Select the best response.) A. No, none of the portfolios using a 50-50 split reduce risk. B. Yes, a portfolio of 50% of asset Mand 50% of asset N could reduce the risk to 1.49%. C. There is not enough information to answer this question. D. Yes, a portfolio of 50% of asset Mand 50% of asset O could reduce the risk to 1.49%. Benefits of diversification. Sally Rogers has decided to invest her wealth equally across the following three assets: a. What are her expected returns and the risk from her investment in the three assets? How do they compare with investing in asset M alone? Hint Find the standard deviations of asset M and of the portfolio equally invested in assets M, N, and O. b. Could Sally reduce her total risk even more by using assets M and N only, assets M and O only, or assets N and O only? Use a 50/50 split between the asset pairs, and find the standard deviation of each asset pair. a. What is the expected return of investing equally in all three assets M, N, and O? i X - Data Table 9.42% (Round to two decimal places.) What is the expected return of investing in asset Malone? Asset Return 7.41 % (Round to two decimal places.) 0% States Boom Normal Recession Probability 28% 45% 27% Asset M Return 12% 9% 0% Asset N Return 23% 14% 3% What is the standard deviation of the portfolio that invests equally in all three assets M, N, and O? 9% 12% 2.72 % (Round to two decimal places.) What is the standard deviation of asset M? Print Done 4.68 % (Round to two decimal places.) By investing in the portfolio that invests equally in all three assets M, N, and O rather than asset M alone, Sally can benefit by increasing her return by 2.01 % and decrease her risk by 1.96 %. (Round to two decimal places.) b. What is the expected return of a portfolio of 50% asset M and 50% asset N? % (Round to two decimal places.) b. 1- What is the expected return of a portfolio of 50% asset M and 50% asset N? % (Round to two decimal places.) 2- What is the expected return of a portfolio of 50% asset M and 50% asset O? % (Round to two decimal places.) 3- What is the expected return of a portfolio of 50% asset N and 50% asset O? % (Round to two decimal places.) 4- What is the standard deviation of a portfolio of 50% asset Mand 50% asset N? % (Round to two decimal places.) 5. What is the standard deviation of a portfolio of 50% asset Mand 50% asset O? % (Round to two decimal places.) 6- What is the standard deviation of a portfolio of 50% asset N and 50% asset O? % (Round to two decimal places.) 7- Could Sally reduce her total risk even more by using assets M and N only, assets M and O only, or assets N and O only? (Select the best response.) A. No, none of the portfolios using a 50-50 split reduce risk. B. Yes, a portfolio of 50% of asset Mand 50% of asset N could reduce the risk to 1.49%. C. There is not enough information to answer this question. D. Yes, a portfolio of 50% of asset Mand 50% of asset O could reduce the risk to 1.49%