You have observed the following returns over time:

Assume that the risk$-$free rate is $4\%$ and the market risk premium is $6\%.$ The data has

been collected in the Microsoft Excel Online file below. Open the spreadsheet and

perform the required analysis to answer the questions below.

a$.$ What is the beta of Stock X$?$ Do not round intermediate calculations. Round

your answer to two decimal places.

b$.$ What is the required rate of return on Stock $x?$ Do not round intermediate

calculations. Round your answer to one decimal place.

c$.$ What is the required rate of return on a portfolio consisting of $80\%$ of Stock X

and $20\%$ of Stock Y$?$ Do not round intermediate calculations. Round your

answer to one decimal place.