In: Finance
You have a two stock portfolio with $3,000 in stock A and $7,000 in stock B. You believe the following probability distribution exists for your stocks.
State of the Economy | Probability of State Occurring | Market Rate of Return of Stock A | Market Rate of Return of Stock B | Portfolio Return |
---|---|---|---|---|
Boom | 0.3 | -25% | 25% | |
Normal | 0.5 | 10% | 15% | |
Recession | 0.2 | 30% | 5% |
1. Calculate Expected rate of Return, Risk, and CV of Stock A
2. Calculate portfolio expected rate of return, portfolio risk , and portfolio CV. Note: expected rate of Return , risk, and CV of Stock B are 16,7, and 0.44 respectively .
Total Portfolio value = Value of Stock A + Value of Stock B |
=3000+7000 |
=10000 |
Weight of Stock A = Value of Stock A/Total Portfolio Value |
= 3000/10000 |
=0.3 |
Weight of Stock B = Value of Stock B/Total Portfolio Value |
= 7000/10000 |
=0.7 |
Stock A | |||||
Scenario | Probability | Return% | =rate of return% * probability | Actual return -expected return(A)% | (A)^2* probability |
Boom | 0.3 | -25 | -7.5 | -28.5 | 0.0243675 |
Normal | 0.5 | 10 | 5 | 6.5 | 0.0021125 |
Recession | 0.2 | 30 | 6 | 26.5 | 0.014045 |
Expected return %= | sum of weighted return = | 3.5 | Sum=Variance Stock A= | 0.04053 | |
Standard deviation of Stock A% | =(Variance)^(1/2) | 20.13 | |||
Coefficient of variation= | Std. dev./return= | 5.7514 | |||
Stock B | |||||
Scenario | Probability | Return% | =rate of return% * probability | Actual return -expected return(A)% | (B)^2* probability |
Boom | 0.3 | 25 | 7.5 | 9 | 0.00243 |
Normal | 0.5 | 15 | 7.5 | -1 | 0.00005 |
Recession | 0.2 | 5 | 1 | -11 | 0.00242 |
Expected return %= | sum of weighted return = | 16 | Sum=Variance Stock B= | 0.0049 | |
Standard deviation of Stock B% | =(Variance)^(1/2) | 7 | |||
Coefficient of variation= | Std. dev./return= | 0.4375 | |||
Covariance Stock A Stock B: | |||||
Scenario | Probability | Actual return% -expected return% for A(A) | Actual return% -expected return% For B(B) | (A)*(B)*probability | |
Boom | 0.3 | -28.5 | 9 | -0.007695 | |
Normal | 0.5 | 6.5 | -1 | -0.000325 | |
Recession | 0.2 | 26.5 | -11 | -0.00583 | |
Covariance=sum= | -0.01385 | ||||
Correlation A&B= | Covariance/(std devA*std devB)= | -0.982856743 | |||
Expected return%= | Wt Stock A*Return Stock A+Wt Stock B*Return Stock B | ||||
Expected return%= | 0.3*3.5+0.7*16 | ||||
Expected return%= | 12.25 | ||||
Variance | =( w2A*σ2(RA) + w2B*σ2(RB) + 2*(wA)*(wB)*Cor(RA, RB)*σ(RA)*σ(RB)) | ||||
Variance | =0.3^2*0.20131^2+0.7^2*0.07^2+2*0.3*0.7*0.20131*0.07*-0.98286 | ||||
Variance | 0.00023 | ||||
Standard deviation= | (variance)^0.5 | ||||
Standard deviation= | 1.52% |