In: Finance
Consider the following performance of an actively managed portfolio
| Actively managed portfolio | Benchmark portfolio | |||
| Component | Weight | Return | Weight | Return | 
| Equity | 0.7 | 7.00% | 0.5 | 4.00% | 
| Bonds | 0.15 | 2.00% | 0.25 | 1.80% | 
| Cash | 0.15 | 0.30% | 0.25 | 0.30% | 
What is the attribution of excess return by asset allocation for this portfolio?
| A. | 
 0.78%  | 
|
| B. | 
 0.59%  | 
|
| C. | 
 2.72%  | 
|
| D. | 
 None of the options.  | 
|
| E. | 
 2.13%  | 
The correct answer is C.2.72 %
We need to calculate the excess return earned by the actively managed portfolio over benchmark portfolio.
Excess Return = Return from Actively managed portfolio - Return from Benchmark portfolio
Expected return = Weighted average of returns
= Weight allocated to equity * Return from equity + Weight allocated to Bonds * Return from bond + Weight allocated to cash * Return from cash
Expected return of Actively managed portfolio
= 0.7 * 7 + 0.15 * 2 + 0.15 * 0.30
= 4.9 + 0.3 + 0.045
= 5.245 %
Expected return of Benchmark portfolio
= 0.5 * 4 + 0.25 * 1.80 + 0.25 * 0.30
= 2 + 0.45 + 0.075
= 2.525 %
Therefore excess return
= 5.245% - 2.525%
= 2.72%