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 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 Portfolio A 1.03% 7.54 5.00 1.09 -1.95 4.17 -0.74 -15.41 5.97 7.61 7.75 9.53 5.16 -3.13 5.44 2.36 -2.88 6.58 -3.37 -1.30 -1.56 6.10 2.07 7.10 -4.81 0.98 9.13 -4.26 -3.29 3.83 Portfolio B 0.00% 6.66 5.97 0.26 -1.67 2.31 -2.43 -15.42 4.00 6.70 5.57 4.97 2.69 -0.55 2.54 7.31 0.11 3.68 -0.70 -3.96 0.12 5.22 2.19 7.07 -2.83 -2.06 5.32 -3.00 -0.64 1.79 Factor 1 0.01% 6.80 4.85 0.69 -2.88 2.83 -2.71 16.17 5.89 7.18 5.88 5.93 3.51 -4.14 3.39 4.46 -2.38 4.67 -3.35 -1.44 -2.77 5.84 3.12 7.74 -4.40 2.46 5.12 -6.21 -4.25 4.69 Factor 2 -0.93% 0.20 -1.55 0.50 -3.58 -3.42 -4.59 -5.95 0.02 -3.43 1.27 -0.35 1.14 -5.54 -3.76 2.94 3.48 3.44 1.96 -1.11 3.17 -6.44 7.78 7.08 4.16 21.51 -16.76 -7.43 -5.76 13.35 Factor 3 -1.72% -1.25 2.00 0.16 4.26 -1.49 -1.85 5.78 -3.69 -2.81 -3.77 -4.92 -6.19 1.65 -3.00 2.89 3.10 -4.26 0.61 -1.18 -3.25 -3.18 -8.09 -9.15 -0.24 -12.13 7.74 8.67 5.38 -8.70 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. Correlation between 1 & 2: Monthly: Average Std Dev Annual: Average Std Dev Correlation between 1 & 3: Portfolio A Correlation between 2 & 3: % % % % Portfolio B % % % % Factor 1 % % 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- % % Factor 2 % % % % 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. Factor 3 Portfolio A earned a -Select- ✓ return and a [-Select- ✓ standard deviation than Portfolio B. Therefore, it -Select- clear that one portfolio outperformed the other over this time period. c. 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. % % % % 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 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 Portfolio A 1.03% 7.54 5.00 1.09 -1.95 4.17 -0.74 -15.41 5.97 7.61 7.75 9.53 5.16 -3.13 5.44 2.36 -2.88 6.58 -3.37 -1.30 -1.56 6.10 2.07 7.10 -4.81 0.98 9.13 -4.26 -3.29 3.83 Portfolio B 0.00% 6.66 5.97 0.26 -1.67 2.31 -2.43 -15.42 4.00 6.70 5.57 4.97 2.69 -0.55 2.54 7.31 0.11 3.68 -0.70 -3.96 0.12 5.22 2.19 7.07 -2.83 -2.06 5.32 -3.00 -0.64 1.79 Factor 1 0.01% 6.80 4.85 0.69 -2.88 2.83 -2.71 16.17 5.89 7.18 5.88 5.93 3.51 -4.14 3.39 4.46 -2.38 4.67 -3.35 -1.44 -2.77 5.84 3.12 7.74 -4.40 2.46 5.12 -6.21 -4.25 4.69 Factor 2 -0.93% 0.20 -1.55 0.50 -3.58 -3.42 -4.59 -5.95 0.02 -3.43 1.27 -0.35 1.14 -5.54 -3.76 2.94 3.48 3.44 1.96 -1.11 3.17 -6.44 7.78 7.08 4.16 21.51 -16.76 -7.43 -5.76 13.35 Factor 3 -1.72% -1.25 2.00 0.16 4.26 -1.49 -1.85 5.78 -3.69 -2.81 -3.77 -4.92 -6.19 1.65 -3.00 2.89 3.10 -4.26 0.61 -1.18 -3.25 -3.18 -8.09 -9.15 -0.24 -12.13 7.74 8.67 5.38 -8.70 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. Correlation between 1 & 2: Monthly: Average Std Dev Annual: Average Std Dev Correlation between 1 & 3: Portfolio A Correlation between 2 & 3: % % % % Portfolio B % % % % Factor 1 % % 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- % % Factor 2 % % % % 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. Factor 3 Portfolio A earned a -Select- ✓ return and a [-Select- ✓ standard deviation than Portfolio B. Therefore, it -Select- clear that one portfolio outperformed the other over this time period. c. 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. % % % %
Expert Answer:
Related Book For
Investment Analysis and Portfolio Management
ISBN: 978-0538482387
10th Edition
Authors: Frank K. Reilly, Keith C. Brown
Posted Date:
Students also viewed these finance questions
-
Lillian Jordon is considering using some of the cash generated from her mail-order business to open a retail store. The fixed investment in the store is expected to be $3.5 million. The investment...
-
A nutritionist at the Food and Drug Administration is studying the effects of cereal marketing on family meal choices. In particular, she would like to understand how cereal manufacturers market...
-
A thin ring is loaded by two equal and opposite forces F in part a of the figure. A free-body diagram of one quadrant is shown in part b. This is a statically indeterminate problem, because the...
-
Match each of the following control activities with its appropriate description. 1. Authorization of transactions and activities 2. Segregation of duties 3. Documentation 4. Physical controls 5....
-
A railroad car that has an inertia of \(5.04 \times 10^{4} \mathrm{~kg}\) is moving to the right at \(4.25 \mathrm{~m} / \mathrm{s}\) when it collides and couples with three identical railroad cars...
-
Rick Kleckner Corporation recorded a finance lease at $300,000 on January 1, 2012. The interest rate is 12%. Kleckner Corporation made the first lease payment of $53,920 on January 1, 2012. The lease...
-
During the procurement process, how does the ERP system determine which vendor account to use? Explain.
-
This is the code followed by the questions :) // Execute in strict mode to prevent some common mistakes "use strict"; /** * Make diary data item * @param type Type of item to create, either "text" or...
-
Design a forward converter such that the output is 5 V when the input is 170 V. The output current is 5 A. The output voltage ripple must not exceed 1 percent. Choose the transformer turns ratio,...
-
How can one identify one term plan goal from the list that they are imagining they are working on as well as identifying at least one support activity such as Capstone Intensive that will best assist...
-
Village Farms is a North American green-house producer of tomatoes. VFF operates four greenhouses: three in Texas and one in British Columbia. The combined area under cultivation is 220 acres. Last...
-
Thelma and Louise were taking a road trip to escape their dreary lives when they were involved in a serious car accident. They come to you for representation and want you to represent both of them in...
-
Suppose you are exactly 25 years old and you are planning to save for your retirement which will happen in 40 years. You plan to deposit equal amount at the beginning of each month in your retirement...
-
Consider the following premerger information about two firms. Firm A is the acquiring firm and Firm B is the target firm. Assume that both firms have no debt outstanding. The synergistic benefits...
-
(10 kO) FIGURE 10.3 7. Remove power, and connect a 10 ka load to the wiper arm. Apply power, and adjust the potentiometer until V - 2.7 V, which is 90% of VL- (Note: A volt- age divider is considered...
-
A stock has had returns of 8 percent, 26 percent, 14 percent, 17 percent, 31 percent, and 1 percent over the last six years. What are the arithmetic and geometric average returns for the stock?
-
When examining a firm's financial structure, would you be concerned with the firm's business risk? Why or why not?
-
Consider Commodity Z, which has both exchange-traded futures and option contracts associated with it. As you look in todays paper, you find the following put and call prices for options that expire...
-
The current rate of inflation is 3 percent, and long-term Treasury bonds are yielding 7 percent. You estimate that the rate of inflation will increase to 6 percent. What do you expect to happen to...
-
Find the two eigenvalues of an operator associated with a \(2 \times 2\) matrix with arbitrary elements.
-
Discretize the product of two functions, as compared to discretizing each function independently, and describe what that means in the language of kets.
-
Suppose that the probability of finding some particle 1 at \(x_{1}\) is a Gaussian around \(x_{1}\), with standard deviation \(\sigma_{1}\), and the probability of finding another particle 2 at...
Study smarter with the SolutionInn App