H V.lee Excel Online Structured Activity CA portok, and return Consider the following formation for three stocks, Stock, and the return the area constated, but they are that of the creation contain Stoch Expected Return Standard deviation Beta 3.04 144 01 10.23 14 11 C 12.31 14 1,6 Fund has one third of funds invested of the three to the tree tatele., indem e datos colected in the Me Online fillow. Open the spread and perform the analysis to the bow Open spreadsheet What is the market rerum do wode Wat is the best fund do not rould mean Round your own de peces Wat is the red return of und die we were d. pet the standardeve fund te belet 144, 145 than Her than 14 141 Excel Online Structured Activity: CAPM, portfolio risk, and retum Consider the following information for three stocks, Stocks A, B, and C. The returns on the three stocks are positively correlated, but they are not perfec Stock Standard Deviation Beta A Expected Return 8.94% 10.23 14% 0.8 B 14 1.1 12.38 14 1.6 Fund P has one-third of its funds invested in each of the three stock. The risk-free rate is 5.5%, and the market in equilibrium. (That is required retu Online file below. Open the spreadsheet and perform the required analysis to answer the questions below HHI Open spreadsheet a. What is the market risk premium (M-T7 Round your answer to two decimal places. a. What is the market risk premium (M-PRF)? Round your answer to two decimal places. b. What is the beta of Fund P? Do not round intermediate calculations. Round your answer to two decimal places. c. What is the required return of Fund P? Do not round intermediate calculations. Round your answer to two decimal places. d. Would you expect the standard deviation of Fund P to be less than 14%, equal to 14%, or greater than 14%? 1. less than 14% II. greater than 14% III. equal to 14% Het problem Hviles Bel Online Structured Activity: CAP portfolio risk and return conder the following information for the stocks, Stod and C. The returns the three socks are provely colated, but they were perfectly correlated. That who the correlation with and 1) Stock Expected Return Standard Deviation Beta 8,944 0, 10.23 14 11 14 1. Fund Phasone third al es tunds vested in each of the three stads. The ne free rate is 13, med the market is in om. (That is reditum corpeted returna) The dans les collected the most en Online file below. Open the spreadsheet derform the required to the stone below Open space 1. What is the market rik promound your wwwer to two decin on what the beta dl rund do not und keturmediate cuentation round you come to two decimet places What is the received return Fund Pro retroud intermediate calotton. Found your tower to the decimal aces . Would you expect the standard deviation und to be ben tan senco 14%, than 1*? 1. less than 14 treater than 14 El equal to 14 CAPM, portfolio risk and return anche Video Excel Online Stridered Activity: CAFM portfolio risk and return Consider the following information for the stocks Stads A, I, and C. The returns on the three stocks are positively related, but they are not perfectly conced. That is, each of the correlation consisten and 15 Stock Expected Return Standard Deviation A 0.94 14 0. 10.23 14 1.1 12.30 14 Fund Phas one-third of its funds invested in each of the three stocks. The streets 5.5, and the markets in guru (That is required tume equal pected turs.) The data has become in the Moon Online fille below. Open the spreadsheet and perform the required walysis to www the insbe Open seasheet What is the market rok premium - al Round your answer to two decimal places b. What is the best of und P? Do not round intermediate calculations. Round your answer to two decimal places What is the required return of Fund P7 Do not found immediate calculations. Nound your answer to two decimal place Would you expect the standard deviation of Fund to be than 14%, qual to 14. or breater than 14 1. less than 14 t.create than 14 equal to 145 Check My Work Resett GEO