Consider the following information regarding the performance of a money manager in a recent month. The table represents the actual return of each sector of the manager’s portfolio in column 1, the fraction of the portfolio allocated to each sector in column 2, the benchmark or neutral sector allocations in column 3, and the returns of sector indices in column 4.
Actual Return | Actual Weight | Benchmark Weight | Index Return | |||||||||
Equity | 2 | % | 0.5 | 0.4 | 2.5% (S&P 500) | |||||||
Bonds | 1.8 | 0.3 | 0.4 | 2 (Barclay’s Aggregate) | ||||||||
Cash | 0.6 | 0.2 | 0.2 | 0.7 | ||||||||
a-1. What was the manager’s return in the month? (Do not round intermediate calculations. Input all amounts as positive values. Round your answer to 2 decimal places.)
a-2. What was her overperformance or underperformance? (Do not round intermediate calculations. Input all amounts as positive values. Round your answer to 2 decimal places.)
b. What was the contribution of security selection to relative performance? (Do not round intermediate calculations. Round your answer to 2 decimal places. Negative amount should be indicated by a minus sign.)
c. What was the contribution of asset allocation to relative performance? (Do not round intermediate calculations. Round your answer to 2 decimal places. Negative amount should be indicated by a minus sign.)
EXCEL FORMULA:
FEEL FREE TO ASK DOUBTS. THUMBS UP PLEASE
Consider the following information regarding the performance of a money manager in a recent month. The...
Consider the following information regarding the performance of a money manager in a recent month. The table represents the actual return of each sector of the manager’s portfolio in column 1, the fraction of the portfolio allocated to each sector in column 2, the benchmark or neutral sector allocations in column 3, and the returns of sector indices in column 4. Actual Return Actual Weight Benchmark Weight Index Return Equity 2.3 % 0.5 0.3 2.8% (S&P 500) Bonds 1.3 0.4...
Consider the following information regarding the performance of a money manager in a recent month. The table represents the actual return of each sector of the manager's portfolio in column 1, the fraction of the portfolie allocated to each sector in column 2, the benchmark or neutral sector allocations in column 3, and the returns of sector indices in column 4. Actual Return 2.2% 1.2 0.5 Actual Weight Benchmark Weight 0.4 0.3 0.3 Index Return Equity Bonds 0.6 2.7% (...
Consider the following information regarding the performance of a money manager in a recent month. The table represents the actual return of each sector of the manager's portfolio in column 1, the fraction of the portfolio allocated to each sector in column 2, the benchmark or neutral sector allocations in column 3, and the returns of sector indices in column 4 Benchmark Weight 0.4 Equity Bonds Cash Actual Return 2.25 1.2 0.5 Actual Weight 0.6 0.2 Index Return 2.76 (S&P...
Consider the following information regarding the performance of a money manager in a recent month. The table represents the actual return of each sector of the manager's portfolio in column 1, the fraction of the portfolie allocated to each sector in column 2, the benchmark or neutral sector allocations in column 3, and the returns of sector indices in column 4. Actual Return 2.2% 1.2 0.5 Actual Weight Benchmark Weight 0.4 0.3 0.3 Index Return Equity Bonds 0.6 2.7% (...
Consider the following information regarding the performance of a money manager in a recent month. The table represents the actual return of each sector of the manager's portfolio in column 1, the fraction of the portfolio allocated to each sector in column 2, the benchmark or neutral sector allocations in column 3, and the returns of sector indices in column 4. Equity Bonds Cash Actual Return 2.5% 1.4 0.8 Actual Weight 0.5 0.2 Benchmark Weight 0.7 0.2 Index Return 3%...
Consider the following information regarding the performance of a money manager in a recent month. The table represents the actual return of each sector of the manager's portfolio in column 1, the fraction of the portfolio allocated to each sector in column 2. the benchmark or neutral sector allocations in column 3, and the returns of sector indices in column 4. Equity Bonds Cash Actual Return 2.51 1.5 Actual Weight 0.6 0.1 0.3 Benchmark Weight 0.6 0.1 0.3 Index Return...
Consider the following information regarding the performance of a money manager in a recent month. The table represents the actual return of each sector of the manager's portfolio in column 1, the fraction of the portfolio allocated to each sector in column 2. the benchmark or neutral sector allocations in column 3, and the returns of sector indices in column 4. Actual Weight Actual Return 2.5 1.5 Equity Bonds Cash 2.6 Benchmark Weight e.5 e. 1 Index Return 3% (S&P...
Consider the following information regarding the performance of a money manager in a recent month. The table presents the actual return of each sector of the manager’s portfolio in column (1), the fraction of the portfolio allocated to each sector in column (2), the benchmark or neutral sector allocations in column (3), and the returns of sector indexes in column (4). (1) Actual Return (2) Actual Weight (3) Benchmark Weight (4) Index Return Equity 3.1% 0.70 0.50 3.9% (S&P 500)...
Consider the following information regarding the performance of a money manager in a recent month. The table represents the actual return of each sector of the manager's portfolio in column 1, the fraction of the portfolio allocated to each sector in column 2, the benchmark or neutral sector allocations in column 3, and the returns of sector indexes in column 4. Actual Return Actual Weight e.5 Benchmark Weight Equity Bonds Cash Index Return 2.8%(S&P/TSX Composite) .4 (FTSE TMX Universe) a-1....
Consider the following information regarding the performance of a money manager in a recent month. The table presents the actual return of each sector of the manager's portfolio in column (1), the fraction of the portfolio allocated to each sector in column (2), the benchmark or neutral sector allocations in column (3), and the returns of sector indexes in column (4) (1) Actual (2) Actual Benchmark (3) (4) Index Weight O.80 Return Weight 0.50 Return 4.0% (S&P 500) (Aggregate Bond...