Question
In: Finance
The table lists the monthly total returns on Dish Network Corp. common stock and the market...
The table lists the monthly total returns on Dish Network Corp. common stock and the market rates of return for a 24-month period. Observation Month Dish rate of return (%) Market rate of return (%) 1 Aug 2014 4.75 4.18 2 Sep 2014 -0.35 -2.11 3 Oct 2014 -1.44 2.74 4 Nov 2014 24.76 2.43 5 Dec 2014 -8.21 -0.01 6 Jan 2015 -3.48 -2.77 7 Feb 2015 6.67 5.78 8 Mar 2015 -6.64 -1.01 9 Apr 2015 -3.43 0.42 10 May 2015 4.63 1.39 11 Jun 2015 -4.35 -1.70 12 Jul 2015 -4.58 1.65 13 Aug 2015 -8.26 -6.00 14 Sep 2015 -1.57 -2.95 15 Oct 2015 7.94 7.86 16 Nov 2015 -0.41 0.56 17 Dec 2015 -8.82 -2.04 18 Jan 2016 -15.58 -5.67 19 Feb 2016 -2.36 -0.02 20 Mar 2016 -1.85 7.03 21 Apr 2016 6.55 0.63 22 May 2016 1.24 1.79 23 Jun 2016 5.01 0.23 24 Jul 2016 1.95 3.97 Estimate beta to two decimal places for Dish Network based on this data. If beta is negative, then include a minus sign. Hint: see Examples 16 and 17 in the lecture. Group of answer choices
Solutions
Expert Solution
| Period | Dish Network Corp. | Market return |
| 1 | 4.75 | 4.18 |
| 2 | -0.35 | -2.11 |
| 3 | -1.44 | 2.74 |
| 4 | 24.76 | 2.43 |
| 5 | -8.21 | -0.01 |
| 6 | -3.48 | -2.77 |
| 7 | 6.67 | 5.78 |
| 8 | -6.64 | -1.01 |
| 9 | -3.43 | 0.42 |
| 10 | 4.69 | 1.39 |
| 11 | -4.35 | -1.7 |
| 12 | -4.58 | 1.65 |
| 13 | -8.26 | -6.00 |
| 14 | -1.57 | -2.95 |
| 15 | 7.94 | 7.86 |
| 16 | -0.41 | 0.56 |
| 17 | -8.82 | -2.04 |
| 18 | -15.58 | -5.67 |
| 19 | -2.36 | -0.02 |
| 20 | -1.85 | 7.03 |
| 21 | 6.55 | 0.63 |
| 22 | 1.24 | 1.79 |
| 23 | 5.01 | 0.23 |
| 24 | 1.95 | 3.97 |
formula along with cells
jeff jeffy answered 2 years agoRelated Solutions
The table lists the monthly total returns on Adobe Systems Inc. common stock and the market...
The table lists the monthly total returns on Adobe Systems Inc.
common stock and the market rates of return for a 24-month period.
Observation Month Adobe rate of return (%) Market rate of return
(%) 1 Aug 2014 3.83 4.18 2 Sep 2014 -3.77 -2.11 3 Oct 2014 1.34
2.74 4 Nov 2014 5.08 2.43 5 Dec 2014 -1.33 -0.01 6 Jan 2015 -3.54
-2.77 7 Feb 2015 12.79 5.78 8 Mar 2015 -6.52 -1.01 9 Apr 2015 2.87
0.42...
Consider the data contained in the table below, which lists 30 monthly excess returns to two...
Consider the data contained in the table below, which lists 30
monthly excess returns to two different actively managed stock
portfolios (A and B) and three different common risk factors (1, 2,
and 3). (Note: You may find it useful to use a computer spreadsheet
program such as Microsoft Excel to calculate your answers.)
Period
Portfolio A
Portfolio B
Factor 1
Factor 2
Factor 3
1
1.00
%
0.00
%
0.02
%
-0.99
%
-1.73
%
2
7.52
6.61
6.85...
The following table lists returns on the market portfolio and on Microsoft, each year from 1989...
The following table lists returns on the market portfolio and
on Microsoft, each year from 1989 to 1998.
Year
Microsoft (%)
Market Portfolio (%)
1989
80.95
31.49
1990
-47.37
-3.17
1991
31
30.57
1992
132.44
7.58
1993
32.02
10.36
1994
25.37
2.55
1995
-28.57
37.57
1996
0.00
22.68
1997
11.67
33.10
1998
36.19
28.32
A) Estimate the covariance in returns between Microsoft and the
market portfolio.
B) Estimate the variances in returns on both investments.
C) Estimate the beta for...
You have just done a regression of monthly stock returns of Royal Inc., on monthly market...
You have just done a regression of monthly stock returns of
Royal Inc., on monthly market returns over the past five years and
have come up with the following regression: ?" =0.03+1.4×?+ The
variance of the stock is 50%, and the variance of the market is
20%. The current risk-free rate is 3% (it was 5% one year ago) and
the market risk premium is 8.76%. The stock is currently selling
for $50, down $4 over the past year; it...
Assume that stock market returns have the market index as a common factor, and that all...
Assume that stock
market returns have the market index as a common factor, and that
all stocks in the economy have a beta of 1.3 on the market index.
Firm-specific returns all have a standard deviation of 35%.
Suppose that an
analyst studies 20 stocks, and finds that half have an alpha of
+1.8%, and the other half an alpha of –1.8%. Suppose the analyst
buys $2.0 million of an equally weighted portfolio of the positive
alpha stocks and shorts...
Assume that stock market returns have the market index as a common factor, and that all...
Assume that stock market returns have the market index as a
common factor, and that all stocks in the economy have a beta of
1.6 on the market index. Firm-specific returns all have a standard
deviation of 20%. Suppose that an analyst studies 20 stocks and
finds that one-half of them have an alpha of +2.4%, and the other
half have an alpha of −2.4%. Suppose the analyst invests $1.0
million in an equally weighted portfolio of the positive alpha...
Assume that stock market returns have the market index as a common factor, and that all...
Assume that stock market returns have the market index as a
common factor, and that all stocks in the economy have a beta of
1.9 on the market index. Firm-specific returns all have a standard
deviation of 40%.
Suppose that an analyst studies 20 stocks and finds that
one-half of them have an alpha of +2.8%, and the other half have an
alpha of −2.8%. Suppose the analyst invests $1.0 million in an
equally weighted portfolio of the positive alpha...
Assume that stock market returns have the market index as a common factor, and that all...
Assume that stock market returns have the market index as a
common factor, and that all stocks in the economy have a beta of
1.8 on the market index. Firm-specific returns all have a standard
deviation of 40%.
Suppose that an analyst studies 20 stocks and finds that one-half
of them have an alpha of +2.8%, and the other half have an alpha of
−2.8%. Suppose the analyst invests $1.0 million in an equally
weighted portfolio of the positive alpha...
Assume that stock market returns have the market index as a common factor, and that all...
Assume that stock market returns have the market index as a
common factor, and that all stocks in the economy have a beta of
1.2 on the market index. Firm-specific returns all have a standard
deviation of 25%.
Suppose that an analyst studies 20 stocks and finds that
one-half of them have an alpha of +1.6%, and the other half have an
alpha of −1.6%. Suppose the analyst invests $1.0 million in an
equally weighted portfolio of the positive alpha...
Assume that stock market returns have the market index as a common factor, and that all...
Assume that stock market returns have the market index as a
common factor, and that all stocks in the economy have a beta of
1.9 on the market index. Firm-specific returns all have a standard
deviation of 40%. Suppose that an analyst studies 20 stocks and
finds that one-half of them have an alpha of +2.8%, and the other
half have an alpha of −2.8%. Suppose the analyst invests $1.0
million in an equally weighted portfolio of the positive alpha...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Write a program that prints and calls two methods. 1. Compute and return the future value...
- Assume you have been selected to lead your team in the development of a quality management...
- java You are creating an array where each element is an (age, name) pair representing guests...
- Joni is a financial planner for ABC firm. She provided all of her clients with the...
- Suppose you plan to retire in 40 years. If you make 10 annual investments of $...
- PLEASE DONT FORGET TO SOLVE THE ASSIGNMENT QUESTION MOST IMP: Ex1) Download the code from the...
- Customer is saying website is running slow when his end clients are trying to access the...
ADVERTISEMENT