expected and required rate of return

ity: 2.14 Historical Return: Expected and Required Rates of Return Excel Online Structured Activity: Historical Return: Expected and Required Rates of Retum You haye observed the following returns over time: Assume that the risk-free rate is 5% and the market risk ptemium is 6%. The dato has been collected in the Microsoft Excel Online file below open the spreadsheet and parfor Open sareadsheet a. What is the beta of stock X? Do not round intermediate calculations. Round your answer to two decimal places. What is the beta of Stock Y Do not round intermediate calculations, Round your answer to two decimal places. b. What is the required rate of retum on stock x>0 o not round intermedlate calculaticns, Rourid your answer to one decimal place. What is the required rate of return on 5t0ck Y D0 not round intermediate calculations. Round your answer to ope decimal place. c. What is the required rate of retum on a portfollo consisting of tow of Stock X and 20% of stock Y Do bok round intermediate calculations, Reund your answer to one deci