Excel Online Structured Activity: Historical Return: Expected and Required Rates of Return

You have observed the following returns over time:

the questions below.

X$$

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.