EXEL spreadsheet

ity, CAPM, portfolio risk, and return Video Excel Online Structur Consider the following information for three stocks, Stocks A, returns on the tt correlated. (That is, each of the correlation coefficients is between 0 and 1.). tfolio risk, and return B, and C. The returns on the three stocks are positively correlated, but they are not perfectly 7.94 % 16% 16 16 9.62 11.30 Fund p has one-third o its funds invested in each of the three stocks. The risk free rate is 5%, and the market is in equilibrium. That is, required returns equal expected returns.) The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the Open s et risk premium (rw- rer)? Round your to two decimal places Round your answer to two decimal places. b. What is the beta of Fund P? Do not round intermediate calculat re to search 111, equal to 16%