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.

Open spreadsheet

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 return on Stock $x?$ Do not round

intermediate calculations. Round your answer to one decimal place.

$\%$

What is the required rate of return on Stock Y$?$ 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.