Consider the data contained in the table below, which lists 30 monthly excess returns to two...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 1 1.07% 0.00% 0.01% -0.97% Factor 3 -1.60% 2 7.56 6.54 6.89 0.31 -1.26 3 5.02 5.92 4.77 -1.36 1.90 4 1.23 0.26 0.67 0.49 0.15 5 -1.96 -1.57 -3.02 -3.69 4.26 6 4.17 2.39 2.92 -3.34 -1.48 7 -0.75 -2.53 -2.65 -4.53 -1.76 8 -15.50 -15.42 -16.20 -5.84 5.59 9 6.12 4.02 5.90 0.03 -3.66 10 7.71 6.84 7.11 -3.42 -2.94 11 7.83 5.48 5.89 1.42 -3.73 12 9.53 4.89 5.88 -0.24 -5.00 13 5.22 2.67 3.42 1.13 -6.21 14 -3.09 -0.45 -4.20 -5.54 1.72 15 5.45 2.49 3.31 -3.89 -2.98 16 2.37 7.21 4.54 2.84 2.78 17 -2.91 0.13 -2.45 3.47 3.15 18 6.46 3.69 4.82 3.45 -4.37 19 -3.28 -0.58 -3.40 2.00 0.63 20 -1.24 -3.99 -1.37 -1.18 -1.27 21 -1.48 0.07 -2.64 3.18 -3.10 22 5.97 5.38 5.72 -6.47 -3.26 23 2.04 2.22 3.28 7.75 -8.07 24 7.29 7.17 7.74 6.95 -8.97 25 -4.82 -2.69 -4.45 4.17 -0.11 26 0.96 -1.94 2.50 21.52 -12.10 27 9.11 5.33 5.03 -16.61 7.90 28 -4.41 -3.03 -6.17 -7.46 8.57 29 -3.31 -0.58 -4.31 -5.79 5.36 30 3.93 1.79 4.62 13.35 -8.73 a. 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 % % % % % % % % % % % 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? Do not make any additional calculations to answer this question. Portfolio A earned a -Select- return and a -Select- standard deviation than Portfolio B. Therefore, it -Select- dear that one portfolio outperformed the other over this time period. c. Calculate the correlation coefficients between each pair of the common risk factors (l.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: d. 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- because we want the factors to be -Select- 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 1 1.07% 0.00% 0.01% -0.97% Factor 3 -1.60% 2 7.56 6.54 6.89 0.31 -1.26 3 5.02 5.92 4.77 -1.36 1.90 4 1.23 0.26 0.67 0.49 0.15 5 -1.96 -1.57 -3.02 -3.69 4.26 6 4.17 2.39 2.92 -3.34 -1.48 7 -0.75 -2.53 -2.65 -4.53 -1.76 8 -15.50 -15.42 -16.20 -5.84 5.59 9 6.12 4.02 5.90 0.03 -3.66 10 7.71 6.84 7.11 -3.42 -2.94 11 7.83 5.48 5.89 1.42 -3.73 12 9.53 4.89 5.88 -0.24 -5.00 13 5.22 2.67 3.42 1.13 -6.21 14 -3.09 -0.45 -4.20 -5.54 1.72 15 5.45 2.49 3.31 -3.89 -2.98 16 2.37 7.21 4.54 2.84 2.78 17 -2.91 0.13 -2.45 3.47 3.15 18 6.46 3.69 4.82 3.45 -4.37 19 -3.28 -0.58 -3.40 2.00 0.63 20 -1.24 -3.99 -1.37 -1.18 -1.27 21 -1.48 0.07 -2.64 3.18 -3.10 22 5.97 5.38 5.72 -6.47 -3.26 23 2.04 2.22 3.28 7.75 -8.07 24 7.29 7.17 7.74 6.95 -8.97 25 -4.82 -2.69 -4.45 4.17 -0.11 26 0.96 -1.94 2.50 21.52 -12.10 27 9.11 5.33 5.03 -16.61 7.90 28 -4.41 -3.03 -6.17 -7.46 8.57 29 -3.31 -0.58 -4.31 -5.79 5.36 30 3.93 1.79 4.62 13.35 -8.73 a. 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 % % % % % % % % % % % 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? Do not make any additional calculations to answer this question. Portfolio A earned a -Select- return and a -Select- standard deviation than Portfolio B. Therefore, it -Select- dear that one portfolio outperformed the other over this time period. c. Calculate the correlation coefficients between each pair of the common risk factors (l.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: d. 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- because we want the factors to be -Select-
Expert Answer:
Posted Date:
Students also viewed these finance questions
-
A marketing researcher wants to estimate the mean amount spent per year ($) on a web site by membership member shoppers. Suppose a random sample of 150 membership member shoppers who recently made a...
-
Find the impedance, Z, shown in figure at a frequency of 400Hz. 10 mH 10 F ww
-
XBRL is independent of a. Software and GAAP. b. Hardware and GAAP. c. Software and hardware. d. Software, hardware, and GAAP.
-
Adjustment for Depreciation CORNERSTONE 3.6 LaGarde Company has a machine that it purchased for \(\$ 125,000\) on January 1. Annual depreciation on the machine is estimated to be \(\$ 14,500\)....
-
Pinder Co. produces and sells high-quality video equipment. To finance its operations, Pinder Co. issued $25,000,000 of five-year, 7% bonds, with interest payable semiannually, at a market...
-
2 DECIMALS PLEASE, thank you Dudley Savings Bank wishes to take a position in Treasury bond futures contracts, which currently have a quote of 108 100. Dudley Savings thinks interest rates will go...
-
Because both sides have much at stake in an arbitration decision, arbitrators will often split the decision so both sides can come away with a win. Group of answer choices True False
-
Workers compensation is a reimbursement program for employees with work-related injuries. These programs are administered on a state-by-state basis.
-
There are two kinds of union security contracts: Closed-shop contracts provide that only members of a particular union may be hired. Union-shop contracts hold that continued employment is dependent...
-
Post, Inc., had a receivable from a foreign customer that is payable in the customers local currency. On December 31, 2011, Post correctly included this receivable for 200,000 local currency units...
-
Health maintenance organizations (HMOs) are the most highly regulated form of managed care organization (MCO) and are health systems that are responsible for the financing and delivery of a wide...
-
This question is based on an ACCA question in their Advanced Audit and Assurance Paper P7, June 2012. Snipe Ltd has in place a defined benefit pension plan for its employees. An actuarial valuation...
-
Percy invaded the property of Splendid Inflatable Boats Inc., a boat manufacturing company, without permission, to steal aluminum sheets from the company's manufacturing plant. This is an example of...
-
The diagram shows the two forces acting on a small object. Which of the following is the resultant force on the object? A. 8 N downwards B. 8 N upwards C. 2 N downwards D. 2 N upwards 3 N 5 N
-
Sole proprietorship, partnership, and corporation are the three principal forms of business organization. The advantages of the first two include the ease and low cost of formation. The advantages of...
-
Short-term rates are more volatile because (1) the Fed operates mainly in the short-term sector, hence Federal Reserve intervention has its major effect here, and (2) long-term rates reflect the...
-
The three primary determinants of a firm's cash flows are: (1) sales revenues; (2) operating expenses, such as raw materials costs and labor costs; and (3) the necessary investments in operating...
Study smarter with the SolutionInn App