In: Finance
Consider the following information on a portfolio of three stocks:
Rate of Return |
||||
State of Economy |
Probability of State Occurring |
Stock A (%) |
Stock B (%) |
Stock C (%) |
Boom |
.15 |
7 |
15 |
28 |
Normal |
.70 |
9 |
12 |
17 |
Bust |
.15 |
10 |
2 |
−35 |
The portfolio is invested 40 percent in each of Stock A and Stock B and the rest in Stock C.
a) First we need to calculate the expected return and standard deviation of the 3 stocks
States | Probability | A | Probability Weighted Return | P(X - Expected return of A)^2 |
Boom | 0.15 | 7.00% | 0.15x7%=1.05% | 0.15(0.07-0.0885)^2=0.00513374999999999% |
Normal | 0.7 | 9.00% | 0.7x9%=6.3% | 0.7(0.09-0.0885)^2=0.0001575% |
Bust | 0.15 | 10.00% | 0.15x10%=1.5% | 0.15(0.1-0.0885)^2=0.00198375% |
Expected Return = sum of Probability Weighted Return | 8.850% | |||
Variance= sum of P(X - Expected return of A)^2 | 0.007% | |||
Standard deviation = Square root of variance | 0.853% |
States | Probability | B | Probability Weighted Return | P(X - Expected return of B)^2 |
Boom | 0.15 | 15.00% | 0.15x15%=2.25% | 0.15(0.15-0.1095)^2=0.02460375% |
Normal | 0.7 | 12.00% | 0.7x12%=8.4% | 0.7(0.12-0.1095)^2=0.00771750000000001% |
Bust | 0.15 | 2.00% | 0.15x2%=0.3% | 0.15(0.02-0.1095)^2=0.12015375% |
Expected Return = sum of Probability Weighted Return | 10.950% | |||
Variance= sum of P(X - Expected return of B)^2 | 0.152% | |||
Standard deviation = Square root of variance | 3.905% |
States | Probability | C | Probability Weighted Return | P(X - Expected return of C)^2 |
Boom | 0.15 | 28.00% | 0.15x28%=4.2% | 0.15(0.28-0.1085)^2=0.44118375% |
Normal | 0.7 | 17.00% | 0.7x17%=11.9% | 0.7(0.17-0.1085)^2=0.2647575% |
Bust | 0.15 | -35.00% | 0.15x-35%=-5.25% | 0.15(-0.35-0.1085)^2=3.15333375% |
Expected Return = sum of Probability Weighted Return | 10.850% | |||
Variance= sum of P(X - Expected return of C)^2 | 3.859% | |||
Standard deviation = Square root of variance | 19.645% |
As A has the lowest standard deviation, it is the least risky
b)Portfolio Expected return is calcualted by solving the following equation:
If the T bill has the return of 4.03% then the excess return is 10.09-4.03 = 6.06%
b) First we need to calculate the covariance and correlation between the stocks to calculate portfolio standard deviation:
State | Probability | A | B | P(X - Expected return of A) x (X - Expected return of B) |
Boom | 0.15 | 7.00% | 15.00% | 0.15(0.07-0.0885)x(0.15-0.1095)=-0.01123875% |
Normal | 0.7 | 9.00% | 12.00% | 0.7(0.09-0.0885)x(0.12-0.1095)=0.0011025% |
Bust | 0.15 | 10.00% | 2.00% | 0.15(0.1-0.0885)x(0.02-0.1095)=-0.01543875% |
Expected return | 8.85% | 10.95% | ||
Standard Deviation | 0.85% | 3.90% | ||
Covariance = sum of P(X - Expected return of A) x (X - Expected return of B) | -0.03% | |||
Correlation= covariance/product of standard deviation | -0.77 |
State | Probability | A | C | P(X - Expected return of A) x (X - Expected return of C) |
Boom | 0.15 | 7.00% | 28.00% | 0.15(0.07-0.0885)x(0.28-0.1085)=-0.04759125% |
Normal | 0.7 | 9.00% | 17.00% | 0.7(0.09-0.0885)x(0.17-0.1085)=0.0064575% |
Bust | 0.15 | 10.00% | -35.00% | 0.15(0.1-0.0885)x(-0.35-0.1085)=-0.0790912500000001% |
Expected return | 8.85% | 10.85% | ||
Standard Deviation | 0.85% | 19.65% | ||
Covariance = sum of P(X - Expected return of A) x (X - Expected return of C) | -0.12% | |||
Correlation= covariance/product of standard deviation | -0.72 |
State | Probability | B | C | P(X - Expected return of B) x (X - Expected return of C) |
Boom | 0.15 | 15.00% | 28.00% | 0.15(0.15-0.1095)x(0.28-0.1085)=0.10418625% |
Normal | 0.7 | 12.00% | 17.00% | 0.7(0.12-0.1095)x(0.17-0.1085)=0.0452025% |
Bust | 0.15 | 2.00% | -35.00% | 0.15(0.02-0.1095)x(-0.35-0.1085)=0.61553625% |
Expected return | 10.95% | 10.85% | ||
Standard Deviation | 3.90% | 19.65% | ||
Covariance = sum of P(X - Expected return of A) x (X - Expected return of B) | 0.76% | |||
Correlation= covariance/product of standard deviation | 1 |
So we have the below correlation matrix:
Correlation Matrix | A | B | C |
A | 1.00 | -0.77 | -0.72 |
B | -0.77 | 1.00 | 1.00 |
C | -0.72 | 1.00 | 1.00 |
Using this we can calculate the portfolio standard deviation: