Question: 61 quarterly return data is provided for three assets: US Equities and Portfolio are provided in Excel file Quiz 2.xlsx tab MV. Calculate the active

61 quarterly return data is provided for three assets: US Equities and Portfolio are provided in Excel file "Quiz 2.xlsx" tab "MV". Calculate the active risk and active returns using the difference method only. The active return and active risk are:

No correct choice (answer) is provided

-0.04% and 2.48% per quarter

1.67% and 9.75% per quarter

Not enough information is provided to calculate the correct answer.

1.71% and 9.24% per quarter

61 quarterly return data is provided for three assets: US Equities and

Portfolio are provided in Excel file "Quiz 2.xlsx" tab "MV". Calculate the

Quarter EM EAFE US Portfolio 1 -0.64 4.16 7.67 5.306 2 -1.36 4.05 5.67 3.937 3 6.04 2.92 6.44 5.657 4 4.10 1.64 3.74 3.394 5 -3.69 -0.05 2.27 0.615 6 -0.59 1.65 7.28 4.579 7 8.13 -1.51 1.13 2.004 8 8.21 12.27 15.84 13.602 9 -9.40 -0.64 8.96 3.369 10 -19.26 -8.08 1.66 -4.470 11 6.01 13.79 12.88 11.685 12 -26.92 1.12 2.35 -3.751 13 -24.86 -15.26 -16.28 -17.790 14 16.54 18.85 22.68 20.686 15 11.72 1.45 3.83 4.932 1 16 21.83 2.58 7.53 9.397 17 -5.29 4.36 -7.53 -4.701 18 22.67 15.75 14.24 16.229 19 2.39 4.89 3.404 -0.05 -3.98 20 -10.72 -2.01 -4.145 -4.915 21 -13.93 -8.35 -0.77 22 -14.39 -2.65 -8.96 -8.785 23 -7.10 -15.51 -14.47 -13.205 24 5.82 0.80 8.81 6.611 25 -25.05 -16.66 -18.01 -19.149 26 24.04 7.54 11.50 13.217 27 10.46 1.01 0.90 2.835 28 -8.73 -2.23 -16.35 -12.001 29 -16.40 -21.95 -12.95 -15.439 30 8.51 6.14 4.13 5.411 31 -5.52 -7.55 -1.93 -3.769 32 21.67 16.80 14.63 16.474 33 13.13 9.89 4.81 7.493 34 15.41 13.91 9.53 11.578 35 9.88 5.60 2.84 4.800 36 -10.50 -0.86 -0.39 -2.508 37 9.13 1.08 0.70 2.460 38 14.52 12.58 7.17 9.722 39 3.23 0.50 -1.85 -0.365 40 3.37 -1.37 3.16 2.295 41 16.10 9.81 3.59 7.334 42 7.05 4.82 2.02 3.588 43 13.10 9.90 5.26 7.758 44 -4.59 0.33 -1.31 -1.636 45 3.68 4.13 3.36 3.582 46 15.90 9.18 7.27 9.382 47 2.21 4.28 1.54 2.219 48 15.39 6.97 6.45 8.343 49 13.39 2.07 1.82 4.181 50 2.53 -2.31 -4.79 -2.833 51 -10.76 -8.32 -6.55 -7.747 52 -3.35 -4.53 -4.83 -4.471 53 -29.67 -20.31 -10.05 -16.027 54 -31.94 -23.16 -25.26 -26.177 55 2.70 -13.50 -9.80 -8.041 56 29.56 23.01 14.49 19.207 57 17.26 14.58 11.80 13.449 58 8.51 4.02 8.46 7.584 59 4.11 2.12 6.54 5.172 60 -11.29 -16.72 -13.17 -13.501 61 18.61 16.48 11.73 14.058 Quarter EM EAFE US Portfolio 1 -0.64 4.16 7.67 5.306 2 -1.36 4.05 5.67 3.937 3 6.04 2.92 6.44 5.657 4 4.10 1.64 3.74 3.394 5 -3.69 -0.05 2.27 0.615 6 -0.59 1.65 7.28 4.579 7 8.13 -1.51 1.13 2.004 8 8.21 12.27 15.84 13.602 9 -9.40 -0.64 8.96 3.369 10 -19.26 -8.08 1.66 -4.470 11 6.01 13.79 12.88 11.685 12 -26.92 1.12 2.35 -3.751 13 -24.86 -15.26 -16.28 -17.790 14 16.54 18.85 22.68 20.686 15 11.72 1.45 3.83 4.932 1 16 21.83 2.58 7.53 9.397 17 -5.29 4.36 -7.53 -4.701 18 22.67 15.75 14.24 16.229 19 2.39 4.89 3.404 -0.05 -3.98 20 -10.72 -2.01 -4.145 -4.915 21 -13.93 -8.35 -0.77 22 -14.39 -2.65 -8.96 -8.785 23 -7.10 -15.51 -14.47 -13.205 24 5.82 0.80 8.81 6.611 25 -25.05 -16.66 -18.01 -19.149 26 24.04 7.54 11.50 13.217 27 10.46 1.01 0.90 2.835 28 -8.73 -2.23 -16.35 -12.001 29 -16.40 -21.95 -12.95 -15.439 30 8.51 6.14 4.13 5.411 31 -5.52 -7.55 -1.93 -3.769 32 21.67 16.80 14.63 16.474 33 13.13 9.89 4.81 7.493 34 15.41 13.91 9.53 11.578 35 9.88 5.60 2.84 4.800 36 -10.50 -0.86 -0.39 -2.508 37 9.13 1.08 0.70 2.460 38 14.52 12.58 7.17 9.722 39 3.23 0.50 -1.85 -0.365 40 3.37 -1.37 3.16 2.295 41 16.10 9.81 3.59 7.334 42 7.05 4.82 2.02 3.588 43 13.10 9.90 5.26 7.758 44 -4.59 0.33 -1.31 -1.636 45 3.68 4.13 3.36 3.582 46 15.90 9.18 7.27 9.382 47 2.21 4.28 1.54 2.219 48 15.39 6.97 6.45 8.343 49 13.39 2.07 1.82 4.181 50 2.53 -2.31 -4.79 -2.833 51 -10.76 -8.32 -6.55 -7.747 52 -3.35 -4.53 -4.83 -4.471 53 -29.67 -20.31 -10.05 -16.027 54 -31.94 -23.16 -25.26 -26.177 55 2.70 -13.50 -9.80 -8.041 56 29.56 23.01 14.49 19.207 57 17.26 14.58 11.80 13.449 58 8.51 4.02 8.46 7.584 59 4.11 2.12 6.54 5.172 60 -11.29 -16.72 -13.17 -13.501 61 18.61 16.48 11.73 14.058

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!