Question

In: Economics

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 0.34 -1.18
3 5.12 5.91 4.71 -1.52 1.92
4 1.08 0.28 0.68 0.44 0.32
5 -1.99 -1.60 -2.89 -3.57 4.28
6 4.16 2.48 2.80 -3.40 -1.57
7 -0.80 -2.46 -2.69 -4.42 -1.89
8 -15.53 -15.42 -16.02 -5.96 5.62
9 6.14 4.12 5.85 0.02 -3.73
10 7.73 6.81 7.01 -3.38 -2.77
11 7.82 5.45 5.79 1.44 -3.78
12 9.62 4.94 5.84 -0.25 -4.91
13 5.24 2.73 3.39 1.25 -6.20
14 -3.10 -0.52 -4.20 -5.57 1.73
15 5.39 2.66 3.40 -3.87 -2.96
16 2.34 7.28 4.50 2.84 2.80
17 -2.82 0.13 -2.32 3.44 2.99
18 6.42 3.71 4.64 3.44 -4.36
19 -3.41 -0.60 -3.41 2.08 0.62
20 -1.18 -4.12 -1.38 -1.26 -1.28
21 -1.49 0.17 -2.72 3.16 -3.11
22 6.02 5.31 5.87 -6.43 -3.14
23 2.00 2.30 3.24 7.64 -8.01
24 7.25 6.99 7.78 7.06 -9.04
25 -4.89 -2.82 -4.47 4.08 -0.21
26 0.94 -2.00 2.54 21.45 -11.97
27 9.04 5.22 5.11 -16.77 7.81
28 -4.31 -3.06 -6.14 -7.59 8.65
29 -3.29 -0.56 -4.34 -5.78 5.32
30 3.78 1.80 4.59 13.23 -8.71
  1. Compute the average monthly return and monthly standard return deviation for each portfolio and all three risk factors. Also state these values on an annualized basis. (Hint: Monthly returns can be annualized by multiplying them by 12, while monthly standard deviations can be annualized by multiplying them by the square root of 12.) Use a minus sign to enter negative values, if any. Do not round intermediate calculations. Round your answers to three decimal places.
    Portfolio A Portfolio B Factor 1 Factor 2 Factor 3
    Monthly:
    Average   %   %   %   %   %
    Std Dev   %   %   %   %   %
    Annual:
    Average   %   %   %   %   %
    Std Dev   %   %   %   %   %
  2. Based on the return and standard deviation calculations for the two portfolios from Part a, is it clear whether one portfolio outperformed the other over this time period? Do not make any additional calculations to answer this question.

    Portfolio A earned a -Select-higherlowerItem 21 return and a -Select-higherlowerItem 22 standard deviation than Portfolio B. Therefore, it -Select-isis notItem 23 clear that one portfolio outperformed the other over this time period.

  3. Calculate the correlation coefficients between each pair of the common risk factors (i.e., 1 & 2, 1 & 3, and 2 & 3). Use a minus sign to enter negative values, if any. Do not round intermediate calculations. Round your answers to four decimal places.

    Correlation between 1 & 2:

    Correlation between 1 & 3:

    Correlation between 2 & 3:

  4. In theory, what should be the value of the correlation coefficient between the common risk factors? Explain why.

    In theory the correlations should be -Select-equal to 0equal to 1equal to -1indefiniteItem 27 because we want the factors to be -Select-independent of each otherhighly correlatedItem 28 .

Solutions

Expert Solution

Question a. Average monthly return and monthly standard deviation for portfolio return

Answer:

Portfolio A

Portfolio B

Factor 1

Factor 2

Factor 3

Monthly return

Average

0.794

0.377

0.015

-1.417

-2.027

Std Dev

5.576

4.720

5.325

6.506

4.834

Annual return

Average

9.526

4.527

0.182

-16.999

-24.323

Std Dev

19.293

16.332

18.426

22.511

16.727

Question b. Based on the return and standard deviation calculations for the two portfolios from Part a, is it clear whether one portfolio outperformed the other over this time period?

Answer: Portfolio A earned on average 0.794 monthly return and 5.576 standard deviation, both are higher than portfolio B. Therefore it is not clear that one portfolio outperformed the other over this time period

Question a. Correlation between each pair of the common risk factors

Answer:

Correlation between 1&2: 0.22.9

Correlation between 1&3: -5465

Correlation between 2&3: -7556

Question d: In theory, what should be the value of the correlation coefficient between the common risk factors?

answer:I n theory the correlations should be equal -1 for 1&2, because we want the factors to be  independent of each other. Highly correlated factors are 2&3.


Related Solutions

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...
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 stocks of two companies A and B, the table below gives their expected returns and...
Consider stocks of two companies A and B, the table below gives their expected returns and standard deviation Expected return for Stock A 10% Expected return for Stock B 25% Standard deviation for Stock A 12% Standard deviation for Stock B 30% Plot the risk and expected return of portfolio of these two stocks for the following correlation coefficient : -1.0,-0.5,0.0,0.5,1.0
Consider the data contained in the Excel worksheet named Cell Phones. This data set contains monthly...
Consider the data contained in the Excel worksheet named Cell Phones. This data set contains monthly phone bills (in dollars) for a random sample of 50 cell phone users. a. Use the data set to conduct a one sample t-test to determine whether the expected bill amount equals $65 or is greater than $65. What is the p-value associated with the test? b. Construct a 95% confidence interval on expected bill amount. c. Do the data provide sufficient evidence to...
The following table shows a portion of the monthly returns data (in percent) for 2010–2016 for...
The following table shows a portion of the monthly returns data (in percent) for 2010–2016 for two of Vanguard’s mutual funds: the Vanguard Energy Fund and the Vanguard Healthcare Fund. [You may find it useful to reference the t table.] Date Energy Healthcare Jan-10 -4.89 -0.11 Feb-10 1.6 0.54 Mar-10 2.27 1.37 Apr-10 2.99 -3.84 May-10 -11.6 -5.16 Jun-10 -5.77 -0.52 Jul-10 8.69 1.52 Aug-10 -6.02 -1.08 Sep-10 10.2 8.24 Oct-10 3.85 2.3 Nov-10 2.82 -2.5 Dec-10 5.55 2 Jan-16...
The following table shows a portion of the monthly returns data (in percent) for 2010–2016 for...
The following table shows a portion of the monthly returns data (in percent) for 2010–2016 for two of Vanguard’s mutual funds: the Vanguard Energy Fund and the Vanguard Healthcare Fund. [You may find it useful to reference the t table.] Date Energy Healthcare Jan-10 −4.86 −0.08 Feb-10 1.90 0.56 ⋮ ⋮ ⋮ Dec-16 0.10 −5.30 SOURCE: www.finance.yahoo.com. Click here for the Excel Data File a. Calculate the sample correlation coefficient rxy. (Round intermediate calculations to at least 4 decimal places...
The table below lists pitches in a baseball game for two pitchers and the breakdown of...
The table below lists pitches in a baseball game for two pitchers and the breakdown of “strikes” and “balls” (good pitches and bad pitches). The summary statistics are also listed. Pitcher Strikes Balls Total Bumgarner 76 32 108 Cueto 76 41 117   Bumgarner                  Cueto             Sample Mean (pitches per inning) 12.0                              13.0             Sample Variance (pitches per inning) 3.5 8             Sample Size (# of innings) 9 9              (an “inning” is one of the rounds in a...
Consider the data provided in the table below, which shows years of education and income for...
Consider the data provided in the table below, which shows years of education and income for ten individuals. Education Income(1) Income(2) 10 15,000 15 12 20,000 20 12 35,000 35 12 40,000 40 12 60,000 60 16 50,000 50 16 60,000 60 16 70,000 70 18 60,000 60 21 80,000 80 A) Calculate the covariance and correlation of education and income, using the “Income1” column for income, which is measured in dollars. B) Calculate the covariance and correlation of education...
Consider the following hypothetical data in the table below describing a survey in which dog and...
Consider the following hypothetical data in the table below describing a survey in which dog and cat owners are asked whether they go for daily walks. Assume that we want to use a 0.01 significance level to test the claim that whether you own a dog or a cat is independent of whether you take a daily walk (based on Concepts and Applications of two-way table hypothesis tests, Daily walk No Daily walk Dog owner 95 15 Cat owner 40...
Consider the two empirical models for excess returns (Ri-Rf) of stocks A and B. The risk...
Consider the two empirical models for excess returns (Ri-Rf) of stocks A and B. The risk free rate (Rf) over the period was 6%, and the market’s average return (Rm) was 14%. Stock A Stock B Estimated market models Ri-Rf= 1% + 1.2(Rm – Rf) Ri-Rf = 2% + 0.8(Rm – Rf) Standard deviation of excess returns 21.6% 24.9% Find the following for each stock: i) Alpha ii) Sharpe ratio iii) Treynor ratio
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT