a. The manager's return in the month is 1.46%.
b. The manager underperformed by 1.14%.
c. The contribution of asset allocation to relative performance is 1.78%.
How did we get these values?
a. In order to calculate the manager's return in the month, sum up the product of the actual weight and actual return for each sector:
![\[ \text{Manager's Return} = \sum (\text{Actual Weight} * \text{Actual Return}) \]](https://img.qammunity.org/2024/formulas/business/high-school/v4gflnjslix8c2df0vzmfuorobw90lls2y.png)
Manager's Return = (0.5 x 2.1) + (0.2 x 1) + (0.3 x 0.7)
Manager's Return = 1.05 + 0.2 + 0.21
Manager's Return = 1.46
So, the manager's return in the month is 1.46%.
Finding the overperformance or underperformance, subtract the benchmark return from the manager's return:
Overperformance/Underperformance} = Manager's Return - Benchmark Return
Overperformance/Underperformance = 1.46% - 2.6%
Overperformance/Underperformance = -1.14%
So, the manager underperformed by 1.14%.
b. Calculating the contribution of security selection to relative performance is by summing up the product of the benchmark weight, the difference between the actual return and index return for each sector:
![\[ \text{Contribution of Security Selection} = \sum (\text{Benchmark Weight} * (\text{Actual Return} - \text{Index Return})) \]](https://img.qammunity.org/2024/formulas/business/high-school/v9x3fxajs2rla7fh3y4f8m38hg2gs2xqdb.png)
Contribution of Security Selection} = (0.5 x (2.1% - 2.6%)) + (0.2 x (1% - 1.2%)) + (0.3 x (0.7% - 0.8%))
![\[ \text{Contribution of Security Selection} = (-0.25\%) + (-0.04\%) + (-0.03\%) \]](https://img.qammunity.org/2024/formulas/business/high-school/4bl7hshqdptwiw6v54t5w3fo1myjfog04m.png)
Contribution of Security Selection} = -0.32%
So, the contribution of security selection to relative performance is -0.32%.
c. The contribution of asset allocation to relative performance is the difference between the total manager's return and the contribution of security selection:
![\[ \text{Contribution of Asset Allocation} = \text{Manager's Return} - \text{Contribution of Security Selection} \]](https://img.qammunity.org/2024/formulas/business/high-school/7bhojyzy4964pkz6i72wz4aktud41gfxku.png)
Contribution of Asset Allocation = 1.46% - (-0.32%)
Contribution of Asset Allocation}= 1.78%
So, the contribution of asset allocation to relative performance is 1.78%.