In: Finance
Assume that the % expected return for security A and the market M for a good, normal and bad economy (probabilities .3,.4,.3) are 20, 16, and 10 for A and 8, 4, and 12 for M. Also assume that you invest 40% in A and 60% in M. Compute the covariance between A and M.
Stock A | |||||
Scenario | Probability | Return% | =rate of return% * probability | Actual return -expected return(A)% | (A)^2* probability |
Good | 0.3 | 20 | 6 | 4.6 | 0.0006348 |
Normal | 0.4 | 16 | 6.4 | 0.6 | 0.0000144 |
Bad | 0.3 | 10 | 3 | -5.4 | 0.0008748 |
Expected return %= | sum of weighted return = | 15.4 | Sum=Variance Stock A= | 0.00152 | |
Standard deviation of Stock A% | =(Variance)^(1/2) | 3.9 | |||
Stock M | |||||
Scenario | Probability | Return% | =rate of return% * probability | Actual return -expected return(A)% | (B)^2* probability |
Good | 0.3 | 8 | 2.4 | 0.4 | 4.8E-06 |
Normal | 0.4 | 4 | 1.6 | -3.6 | 0.0005184 |
Bad | 0.3 | 12 | 3.6 | 4.4 | 0.0005808 |
Expected return %= | sum of weighted return = | 7.6 | Sum=Variance Stock M= | 0.0011 | |
Standard deviation of Stock M% | =(Variance)^(1/2) | 3.32 | |||
Covariance Stock A Stock M: | |||||
Scenario | Probability | Actual return% -expected return% for A(A) | Actual return% -expected return% For B(B) | (A)*(B)*probability | |
Good | 0.3 | 4.6 | 0.4 | 0.0000552 | |
Normal | 0.4 | 0.6 | -3.6 | -8.64E-05 | |
Bad | 0.3 | -5.4 | 4.4 | -0.0007128 | |
Covariance=sum= | -0.000744 |