
Explanation:
The excess return is the difference between the total return of the portfolio and the total return of the index.
. **Calculate the Total Index Return:** $\text{Index Return} = \sum (\text{Index Weight} \times \text{Index Sector Return})$ $= (0.15 \times 12.00\%) + (0.10 \times 15.00\%) + (0.25 \times 22.00\%) + (0.05 \times 5.00\%) + (0.25 \times 10.00\%) + (0.20 \times 12.00\%)$ $= 1.80\% + 1.50\% + 5.50\% + 0.25\% + 2.50\% + 2.40\% = 13.95\%\text{Excess Return} = \text{Portfolio Return} - \text{Index Return} = 14.90% - 13.95% = 0.95%$.The closest value is 0.95%, making Option C the correct answer.
Ultimate access to all questions.
No comments yet.
Q.7 A portfolio manager manages a portfolio for a large investment firm. The portfolio tracks the XY Z index. The composition of the index and the portfolio performance is given below:
| Index | Portfolio Weights | Return | Index XYZ Weights | Return |
|---|---|---|---|---|
| Infrastructures | 0.20 | 10.00% | 0.15 | 12.00% |
| Financial Services | 0.15 | 15.00% | 0.10 | 15.00% |
| Utilities | 0.20 | 20.00% | 0.25 | 22.00% |
| Energy | 0.10 | 8.00% | 0.05 | 5.00% |
| IT | 0.20 | 18.00% | 0.25 | 10.00% |
| Fixed income | 0.15 | 15.00% | 0.20 | 12.00% |
Which of the following is closest to the excess return generated by the portfolio manager?
A
1.00%
B
0.90%
C
0.95%
D
0.80%