Question
In: Finance
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 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.
Solutions
Expert Solution
| Year | X | Y | Market |
| 2011 | 15.00% | 14.00% | 12.00% |
| 2012 | 20.00% | 7.00% | 8.00% |
| 2013 | -13.00% | -4.00% | -12.00% |
| 2014 | 3.00% | 1.00% | 1.00% |
| 2015 | 21.00% | 11.00% | 14.00% |
| Variance of Market Data | 0.011 | 0.011 | |
| Covariance | 0.015 | 0.007 | |
| Beta | 1.312 | 0.662 | |
| Risk Free Rate | 4.00% | ||
| Market Risk Premium | 6.00% | ||
| Expected Return through CAPM | 11.87% | 7.97% | |
| Weights | 80.00% | 20.00% | |
| Portfolio Return | 11.09% |
Formulaes:-
Excel Formulaes of Variance:- =VAR.S(Data)
Excel Formula for Covariance:- =COVARIANCE.S(Stock Data, Market Data)
Beta Formula:- Covariance / Variance
Required Rate of Return of A:- Risk Free Rate + Beta of Stock A * Market Risk Premium
Portfolio Return:- Weight of Stock A * Required Rate of Return A + Weight of Stock B * Required Rate of Return B
Using above formulaes:-
1. 1.312
2. 0.662
3. 11.87%
4. 7.97%
5. 11.09%
jeff jeffy answered 2 years agoRelated Solutions
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: 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 %...
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...
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: 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%...
Use the following returns for X and Y. Returns Year X Y 1 21.9 % 26.7...
Use the following returns for X and
Y.
Returns
Year
X
Y
1
21.9
%
26.7
%
2
–
16.9
–3.9
3
9.9
28.7
4
19.8
–14.8
5
4.9
32.7
Calculate the average returns for X and Y.
(Do not round intermediate calculations and enter your
answers as a percent rounded to 2 decimal places, e.g.,
32.16.)
Average returns
X
%
Y
%
Calculate the variances for X and Y. (Do
not round intermediate calculations and round your answers...
Use the following returns for X and Y. Returns Year X Y 1 22.0 % 27.0...
Use the following returns for X and Y. Returns Year X Y 1 22.0 %
27.0 % 2 – 17.0 – 4.0 3 10.0 29.0 4 20.0 – 15.0 5 5.0 33.0
Requirement 1: Calculate the average returns for X and Y. (Do not
round intermediate calculations. Enter your answers as a percentage
rounded to 2 decimal places (e.g., 32.16).) Average returns X % Y %
Requirement 2: Calculate the variances for X and Y. (Do not round
intermediate calculations....
You are given the following information concerning a stock and the market: Returns Year Market Stock...
You are given the following information concerning a stock and
the market:
Returns
Year
Market
Stock
2011
14
%
26
%
2012
10
10
2013
20
3
2014
−15
−31
2015
35
16
2016
15
18
a. Calculate the average return and standard
deviation for the market and the stock.
b. Calculate the correlation between the stock
and the market, as well as the stock’s beta.
You run a regression of X’ Company stock's returns against the market returns over a five-year...
You run a regression of X’ Company stock's returns against the
market returns over a five-year time period (using monthly data)
and come up with the following output: Intercept = .20%, Slope =
1.20 Your stock had an annualized standard deviation of returns of
40% whereas the market standard deviation was only 20%. The
annualized risk-free rate, on average, over the last five years has
been 6% and it is currently at 7%. The risk premium = 8.5%. The
annualized...
You run a regression of X’ Company stock's returns against the market returns over a five-year...
You run a regression of X’ Company stock's returns
against the market returns over a five-year time period (using
monthly data) and come up with the following output: Intercept =
.20%, Slope = 1.20
Your stock had an annualized standard deviation of
returns of 40% whereas the market standard deviation was only 20%.
The annualized risk-free rate, on average, over the last five years
has been 6% and it is currently at 7%. The risk premium = 8.5%. The
annualized...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- What are the SHDN, LNA in opamp What are the TXCO coding algorithm for binary and...
- Need to program a maze traversal program using dynamic array and stacks. The problem is faced...
- what were some of Ida B Wells significant contributions to the civil rights movement?
- In 2007, there were many people in Sri Lanka who have an opinion that the government...
- Example #2: Write the following set of four linear equations with 4 unknowns x1, x2, x3,...
- "In the digital age, our personal and collective privacy is threatened like it never has been...
- when i type those python code below, i got True, but when i type not a...
ADVERTISEMENT