Excel Online Structured Activity: Historical Return: Expected and Required Rates of Return
You have observed the following returns over time:
Year | Stock X | Stock Y | Market | |||
2011 | 15 | % | 12 | % | 11 | % |
2012 | 19 | 6 | 11 | |||
2013 | -16 | -6 | -11 | |||
2014 | 2 | 1 | 2 | |||
2015 | 23 | 8 | 16 |
Assume that the risk-free rate is 4% and the market risk premium is 6%.
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.
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.
%
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.
%
USING EXCEL FORMULA TO CALCULATE BETA
You have observed the following returns over time: | ||||
A | B | C | D | |
1 | Year | Stock X | Stock Y | Market |
2 | 2011 | 15% | 12% | 11% |
3 | 2012 | 19% | 6% | 11% |
4 | 2013 | -16% | -6% | -11% |
5 | 2014 | 2% | 1% | 2% |
6 | 2015 | 23% | 8% | 16% |
Beta | 1.478891821 | 0.598504837 | ||
EXCEL FORMULA | SLOPE(B2:B6,D2:6) | SLOPE(C2:C6,D2:6) |
Beta of Stock X =1.48
Beta of Stock Y =0.60
b. Required rate of X =Risk free rate+Beta*(Market Return -Risk
free Rate) =4%+ 1.478891821*6% =12.8733% or 12.9%
Required rate of Y =Risk free rate+Beta*(Market Return -Risk free
Rate) =4%+ 0.598504837*6% =7.591% or 7.60%
c. Required rate of return of portfolio =80%*12.8733%+20%*7.591%
=11.8%
Excel Online Structured Activity: Historical Return: Expected and Required Rates of Return You have observed the...
Problem 6-14 Historical Returns: Expected and Required Rates of Return You have observed the following returns over time: 6. Problem 6-14 eBook Problem 6-14 Historical Returns: Expected and Required Rates of Return You have observed the following returns over time: Year Market Stock X 14% 21 -14 Stock Y 2012 2013 2014 2015 2016 12% 12% -14 2 15 -4 23 10 Assume that the risk-free rate is 3% and the market risk premium is 6%. Do not round intermediate...
Historical Returns: Expected and Required Rates of Return Year You have observed the following returns over time: Stock X Stock y Market 2014 12 11 13% 2015 2016 -16 2017 10 12 2018 Assume that the risk-free rate is 5% and the market risk premium is 4% 3. What are the betas of stocks X and Y? Do not round Intermediate calculations. Round your answers to two decimal places Stock X: Stock Y: b. What are the required rates of...
Historical Returns: Expected and Required Rates of Return You have observed the following returns over time: Market Stock Y 13% 11% Year 2014 2015 2016 2017 2018 Stock X 13% 18 -15 10 -10 Assume that the risk-free rate is 7% and the market risk premium is 5%. a. What are the betas of stocks X and Y? Do not round intermediate calculations. Round your answers to two decimal places Stock X: Stock Y: b. What are the required rates...
Historical Returns: Expected and Required Rates of Return You have observed the following returns over time: Stock y 13% Market 13% Year 2014 2015 2016 2017 2018 Stock X 15% 17 -12 -4 3 2 -12 3 18 Assume that the risk-free rate is 4% and the market risk premium is 3%. a. What are the betas of Stocks X and Y? Do not round intermediate calculations. Round your answers to two decimal places. Stock X: Stock Y: b. What...
Excel Online Structured Activity: Evaluating risk and return Stock X has a 9.5% expected return, a beta coefficient of 0.8, and a 40% standard deviation of expected returns. Stock Y has a 12.5% expected return, a beta coefficient of 1.2, and a 25.0% standard deviation. The risk-free rate is 6%, and the market risk premium is 5%. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the...
Excel Online Structured Activity: Evaluating risk and return Stock X has a 9.5% expected return, a beta coefficient of 0.8, and a 40% standard deviation of expected returns Stock Y has a 12.5% expected return, a beta coefficient of 1.2, and a 25.0% standard deviation. The risk-free rate is 6%, and the market risk premium is 5%. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the...
2-7: The Relationship between Risk and Return in the Capital Asset Pricing Model Problem 2-14 Historical Returns: Expected and required Rates of Return You have observed the following returns over time: Year Stock X Stock Y Market 2011 13% 13% 2012 2013 2014 2015 Assume that the risk-free rate is 6% and the market risk premium is 6%. Do not round Intermediate calculations. a. What is the beta of Stock X? Round your answer to two decimal places What is...
Excel Online Activity: Evaluating risk and return Question 1 0/10 Submit Excel Online Structured Activity: Evaluating risk and return Stock X has a 9.5% expected return, a beta coefficient of 0.8, and a 35% standard deviation of expected returns. Stock Y has a 12.0% expected return, a beta coefficient of 1.1, and a 25.0% standard deviation. The risk-free rate is 6%, and the market risk premium is 5%. The data has been collected in the Microsoft Excel Online file below....
Excel Online Structured Activity: Evaluating risk and return Stock X has a 10.0% expected return, a beta coeficient of 0.9, and a 30% standard deviation of expected returns. Stock Y has a 12.0% expected return, beta coefficient of 1.1, and a 20.0% standard deviation. The risk-free rate is 6%, and the market risk premium is 5%. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions...
7-20. Historical Returns: Expected and Required Rates of Return You have observed the following returns over time: Year 2011 2012 2013 2014 2015 Stock X Stock Y Market 14% 13% 12% 19 7 10 - 16 -5 -12 3 s11 20 11 15 - Assume that the risk-free rate is 4%, the market risk premium is 5%, the beta for Stock X is 1.50, and the beta for Stock Y is 0.46: a. What are the required rates of return...