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


Related 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
ADVERTISEMENT