Problem 7-14 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 Portfolio Factor 1 Factor 2 Factor 3 B 1 1.11% 0.00% 0.03% -0.98% -1.62% 2 7.60 6.61 6.88 0.32 -1.25 3 5.02 6.07 4.80 -1.55 1.99 4 1.26 0.39 0.70 0.34 0.22 5 -1.95 -1.62 -3.05 -3.60 4.22 6 4.30 2.34 2.79 -3.35 -1.61 7 -0.80 -2.40 -2.82 -4.48 -1.89 8 -15.44 -15.42 - 16.02 -6.00 5.78 9 6.06 4.12 6.00 0.01 -3.75 10 7.67 6.73 7.02 -3.37 -2.93 11 7.79 5.59 5.86 1.38 -3.73 12 9.62 4.95 5.90 -0.38 -5.04 13 5.15 2.72 3.37 1.05 -6.25 -3.18 -0.50 -4.08 -5.66 1.59 15 5.41 2.69 3.24 -3.92 -2.96 16 2.40 7.20 4.48 2.83 2.90 17 -2.92 0.13 -2.43 3.47 3.09 18 6.47 3.74 4.77 3.33 -4.35 19 -3.45 -0.69 -3.47 1.93 0.69 20 -1.27 .4.06 - 1.26 -1.22 -1.21 21 -1.56 0.19 -2.72 3.22 -3.27 22 5.91 5.33 5.72 -6.49 -3.12 23 2.13 2.36 3.19 7.78 -8.01 24 7.13 7.01 7.80 7.05 -8.98 25 -4.76 -2.71 -4.39 4.00 -0.18 26 0.92 -1.98 2,48 21.56 -12.03 27 9.13 5.28 5.20 - 16.61 7.89 28 -4.33 -2.93 -6.27 -7.55 8.61 29 -3.39 -0.63 -4.17 -5.89 5.39 30 3.78 1.83 4.75 13.39 -8.87 2. Using regression analysis, calculate the factor betas of each stock associated with each of the common risk factors. Which of these coefficients are statistically significant at 5% level of significance? Fill in the table below. Use a minus sign to enter negative values, if any. Do not round intermediate calculations. Round your answers for factor betas to three decimal places and answers for t-statistics to two decimal places. a. Using regression analysis, calculate the factor betas of each stock associated with each of th common risk factors. Which of these coefficients are statistically significant at 5% level of significance? Fill in the table below. Use a minus sign to enter negative values, if any. Do no round intermediate calculations. Round your answers for factor betas to three decimal place and answers for t-statistics to two decimal places. bi t-statistic Significance Regression for Portfolio A Constant -Select- Factor 1 -Select- 4 Factor 2 -Select- Factor 3 -Select- Regression for Portfolio B Constant -Select- Factor 1 -Select- Factor 2 -Select- -Select- Factor 3 b. How well does the factor model explain the variation in portfolio returns? On what basis can you make an evaluation of this nature? The factor models explain -Select-, as the -Select- values in both regressions are -Select- C. Suppose you are now told that the three factors used in the models represent the risk exposures in the Fama-French characteristic-based model (i.e., excess market, SMB, and HML). Based on your regression results, which one of these factors is the most likely to be the market factor? Explain why. -Select- is the most likely candidate for the market factor, because it has -Select- effect on both portfolios. d. Suppose it is further revealed that Factor 3 is the HML factor. Which of the two portfolios is most likely to be a growth-oriented fund and which is a value-oriented fund? Explain why. -Select- is the more likely candidate for the value-oriented portfolio as it has a -Select- loading on this factor. -Select- is the more likely candidate for the growth-oriented portfolio as it has a -Select- loading on this factor. Problem 7-14 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 Portfolio Factor 1 Factor 2 Factor 3 B 1 1.11% 0.00% 0.03% -0.98% -1.62% 2 7.60 6.61 6.88 0.32 -1.25 3 5.02 6.07 4.80 -1.55 1.99 4 1.26 0.39 0.70 0.34 0.22 5 -1.95 -1.62 -3.05 -3.60 4.22 6 4.30 2.34 2.79 -3.35 -1.61 7 -0.80 -2.40 -2.82 -4.48 -1.89 8 -15.44 -15.42 - 16.02 -6.00 5.78 9 6.06 4.12 6.00 0.01 -3.75 10 7.67 6.73 7.02 -3.37 -2.93 11 7.79 5.59 5.86 1.38 -3.73 12 9.62 4.95 5.90 -0.38 -5.04 13 5.15 2.72 3.37 1.05 -6.25 -3.18 -0.50 -4.08 -5.66 1.59 15 5.41 2.69 3.24 -3.92 -2.96 16 2.40 7.20 4.48 2.83 2.90 17 -2.92 0.13 -2.43 3.47 3.09 18 6.47 3.74 4.77 3.33 -4.35 19 -3.45 -0.69 -3.47 1.93 0.69 20 -1.27 .4.06 - 1.26 -1.22 -1.21 21 -1.56 0.19 -2.72 3.22 -3.27 22 5.91 5.33 5.72 -6.49 -3.12 23 2.13 2.36 3.19 7.78 -8.01 24 7.13 7.01 7.80 7.05 -8.98 25 -4.76 -2.71 -4.39 4.00 -0.18 26 0.92 -1.98 2,48 21.56 -12.03 27 9.13 5.28 5.20 - 16.61 7.89 28 -4.33 -2.93 -6.27 -7.55 8.61 29 -3.39 -0.63 -4.17 -5.89 5.39 30 3.78 1.83 4.75 13.39 -8.87 2. Using regression analysis, calculate the factor betas of each stock associated with each of the common risk factors. Which of these coefficients are statistically significant at 5% level of significance? Fill in the table below. Use a minus sign to enter negative values, if any. Do not round intermediate calculations. Round your answers for factor betas to three decimal places and answers for t-statistics to two decimal places. a. Using regression analysis, calculate the factor betas of each stock associated with each of th common risk factors. Which of these coefficients are statistically significant at 5% level of significance? Fill in the table below. Use a minus sign to enter negative values, if any. Do no round intermediate calculations. Round your answers for factor betas to three decimal place and answers for t-statistics to two decimal places. bi t-statistic Significance Regression for Portfolio A Constant -Select- Factor 1 -Select- 4 Factor 2 -Select- Factor 3 -Select- Regression for Portfolio B Constant -Select- Factor 1 -Select- Factor 2 -Select- -Select- Factor 3 b. How well does the factor model explain the variation in portfolio returns? On what basis can you make an evaluation of this nature? The factor models explain -Select-, as the -Select- values in both regressions are -Select- C. Suppose you are now told that the three factors used in the models represent the risk exposures in the Fama-French characteristic-based model (i.e., excess market, SMB, and HML). Based on your regression results, which one of these factors is the most likely to be the market factor? Explain why. -Select- is the most likely candidate for the market factor, because it has -Select- effect on both portfolios. d. Suppose it is further revealed that Factor 3 is the HML factor. Which of the two portfolios is most likely to be a growth-oriented fund and which is a value-oriented fund? Explain why. -Select- is the more likely candidate for the value-oriented portfolio as it has a -Select- loading on this factor. -Select- is the more likely candidate for the growth-oriented portfolio as it has a -Select- loading on this factor