Question

In: Finance

Expected and Required Rates of Return You have observed the following returns over time: Year Stock...

Expected and Required Rates of Return

You have observed the following returns over time:

Year

Stock X

Stock Y

Market

2015

14

%

14

%

10

%

2016

18

8

8

2017

-17

-5

-11

2018

5

2

3

2019

24

8

14

Assume that the risk-free rate is 5% and the market risk premium is 4%.

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

What are the required rates of return on Stocks X and Y? Do not round intermediate calculations. Round your answers to two decimal places.

Stock X

Stock Y

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 two decimal places.

Solutions

Expert Solution

Ans :-

Table of Calculation :-

Returns(%)
X Y Market X - X̅ (X - X̅)² Y - Y̅ (Y - Y̅)² M - M̅ (M - M̅)² (X - X̅) - (M - M̅) (Y - Y̅) - (M - M̅)
2015 14 14 10 5.2 27.04 8.6 73.96 5.2 27.04 27.04 44.72
2016 18 8 8 9.2 84.64 2.6 6.76 3.2 10.24 29.44 8.32
2017 -17 -5 -11 -25.8 665.64 -10.4 108.16 -15.8 249.64 407.64 164.32
2018 5 2 3 -3.8 14.44 -3.4 11.56 -1.8 3.24 6.84 6.12
2019 24 8 14 15.2 231.04 2.6 6.76 9.2 84.64 139.84 23.92
Total 44 27 24 1022.8 207.2 374.8 610.8 247.4
No. of Years 5 5 5
Avg Returns 8.8 5.4 4.8
X̅ Y̅ M̅

Calculation Of Beta :-

Required Returns: -

Required return of the Portfolio :-

Working Notes :-


Related Solutions

Historical Returns: Expected and Required Rates of Return You have observed the following returns over time:...
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% 13% 2012 17 7 12 2013 -13 -5 -13 2014 4 2 2 2015 19 13 12 Assume that the risk-free rate is 4% and the market risk premium is 6%. Do not round intermediate calculations. What is the beta of Stock X? Round your answer to two decimal places. What is the beta of...
You have observed the following returns over time:    Year Stock X Stock Y Market 2015...
You have observed the following returns over time:    Year Stock X Stock Y Market 2015 15% 14% 13% 2016 18 5 9 2017 -16 -3 -11 2018 2 2 2 2019 20 12 17 Assume that the risk-free rate is 6% and the market risk premium is 4%. a. What are the betas of Stocks X and Y? Stock X: 1.3 Stock Y: b. What are the required rates of return on Stocks X and Y? Stock X:  11.2 %...
You have observed the following returns over time: Year Stock X Stock Y Market 2011 15...
You have observed the following returns over time: Year Stock X Stock Y Market 2011 15 % 14 % 12 % 2012 20 7 8 2013 -13 -4 -12 2014 3 1 1 2015 21 11 14 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. What is the beta...
You have observed the following returns over time: Year Stock X Stock Y Market 2011 13...
You have observed the following returns over time: Year Stock X Stock Y Market 2011 13 % 11 % 10 % 2012 20 7 9 2013 -13 -6 -10 2014 3 1 1 2015 20 11 17 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...
You have observed the following returns over time: Assume the risk-free rate is 3.55% and the...
You have observed the following returns over time: Assume the risk-free rate is 3.55% and the market risk premium is 4.60%. Year Stock A Stock B Market INPUT DATA rRF 3.55% Market Risk Premium 4.60% 1997 14.000% 15.000% 13.143% a. What are the betas of Stocks A and B? 1998 11.000% 9.000% 11.029% bA bB 1999 -2.500% 5.000% 4.109% 2000 14.000% 7.500% 5.097% b. What are the required rates of return for Stocks A and B? 2001 20.000% 13.500% 19.926%...
REALIZED RATES OF RETURN Stocks A and B have the following historical returns: Year Stock A's...
REALIZED RATES OF RETURN Stocks A and B have the following historical returns: Year Stock A's Returns, rA Stock B's Returns, rB 2011 - 15.90% - 16.50% 2012 33.50 21.20 2013 11.25 31.60 2014 - 6.00 - 8.80 2015 34.00 29.35 Calculate the average rate of return for stock A during the period 2011 through 2015. Round your answer to two decimal places. % Calculate the average rate of return for stock B during the period 2011 through 2015. Round...
The stock has the following returns and probabilities of those returns. What is the expected return...
The stock has the following returns and probabilities of those returns. What is the expected return and risk of the stock using the data? Use your knowledge (weighted average of returns to calculate expected return and standard deviation of returns to calculate risk). return probability 6% 70% 15% 30% Also, How do you calculate portfolio beta? I have this problem and have not been able to calculate the correct answer. Using the table below what is the beta of the...
Consider the following: You have Stock A and Stock B Expected Return of A is  25% Expected...
Consider the following: You have Stock A and Stock B Expected Return of A is  25% Expected Return of B is 35% Standard Deviation (volatility) of A is 17% Standard Deviation (volatility) of B is 28% a) Calculate the expected return and standard deviation of your portfolio if you invest $4,000 in A and $6,000 in B. The correlation between A and B is 0.40. b) Do you derive any diversification benefits by investing in both A and B? Why or...
You are given the returns for the following three stocks: Return Year Stock A Stock B...
You are given the returns for the following three stocks: Return Year Stock A Stock B Stock C 1 8% 7% -22% 2 8% 15% 35% 3 8% 3% 15% 4 8% 12% 3% 5 8% 3% 9% Calculate the arithmetic return, geometric return, and standard deviation for each stock. Do you notice anything about the relationship between an asset’s arithmetic return, standard deviation, and geometric return? Do you think this relationship will always hold?
(Expected return and risk) The following data represend returns for the common stocks over a one-year period.
(Expected return and risk) The following data represend returns for the common stocks over a one-year period. The mean (expected) return of Google is _______%. (Keep the sign and two decimal numbers.)
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT