In: Finance
18. There are four scenarios with probabilities 0.05, 0.25, 0.4 and 0.3. A stock fund has returns -37, -11, 14, 30 respectively, while a bond fund has returns -9, 15, 8, -5 respectively. The correlation between the two funds is (a) -0.49 (b) 0.49 (c) 0.89 (d) -0.89
Calculation of expected return:
| Probability | Return of A | 
 Expected return of A Probability*return of A  | 
Return of bond | 
 Expected return of bond Probability*return of Bond  | 
| 0.05 | -37 | -1.85 | -9 | -0.45 | 
| 0.25 | -11 | -2.75 | 15 | 3.75 | 
| 0.4 | 14 | 5.6 | 8 | 3.2 | 
| 0.3 | 30 | 9 | -5 | -1.5 | 
| Expected return | 10 | 5 | 
Calculation of covariance of stock and bond:
| Probability (1) | Return of A (2) | Return of A-Expected return of A (3) | Return of bond (4) | Return of bond -Expected return of bond (5) | Covariance of stock and bond (6) (1*3*5) | 
| 0.05 | -37 | -37-10 = -47 | -9 | -9-5 = -14 | 32.9 | 
| 0.25 | -11 | -11-10 = -21 | 15 | 15-5 =10 | -52.5 | 
| 0.4 | 14 | 14-10 = 4 | 8 | 8-5 =3 | 4.8 | 
| 0.3 | 30 | 30-10 = 20 | -5 | -5-5 = -10 | -60 | 
| Covariance of stock and bond | -74.8 | 
Calculation of standard deviation of stock and bond:
Standard deviation of stock:
| Probability (1) | Return of A- Expected return of A (2) | Square of Return of A- Expected return of A (3) | Variance of Stock (4) (1*3) | 
| 0.05 | -47 | -47*-47 = 2209 | 110.45 | 
| 0.25 | -21 | -21*-21 =441 | 110.25 | 
| 0.4 | 4 | 4*4 =16 | 6.4 | 
| 0.3 | 20 | 20*20 =400 | 120 | 
| Variance of Stock | 347.1 | 
* Return of A- Expected return of A, For calculation see covariance table
Standard deviation of stock = square root of Variance
= square root of 347.1 = 18.63
Standard deviation of Bond:
| Probability (1) | Return of bond- Expected return of bond (2) | Sqaure of return of bond - expected return of bond (3) | Variance of bond (4) (1*3) | 
| 0.05 | -14 | -14*-14=196 | 9.8 | 
| 0.25 | 10 | 10*10=100 | 25 | 
| 0.4 | 3 | 3*3 =9 | 3.6 | 
| 0.3 | -10 | -10*-10=100 | 30 | 
| Variance of Bond | 68.4 | 
* for calculation of return of bond- expected return of bond, see the covariance table
Standard deviation of bond = square root of Variance
= square root of 68.4 = 8.27
Correlation between two funds = covariance of bond and stock/ standard deviation of bond*standard deviation of stock
= -74.8/8.27*18.63
=-74.8/154.0701
= -0.485
Approxiamately -0.49
Correct Answer : A (-0.49)