In: Finance
Year |
HCA |
WLMT |
2017 |
35% |
3% |
2016 |
20% |
5% |
2015 |
3% |
9% |
2014 |
-12% |
15% |
(Return in %) | |||||
Year | HCL(x) | WLMT(y) | (x-(∑x/n))^2 | (y-(∑y/n))^2 | (x-(∑x/n))(y-(∑y/n)) |
2014 | -12 | 15 | 552.25 | 49.00 | -164.5 |
2015 | 3 | 9 | 72.25 | 1.00 | -8.5 |
2016 | 20 | 5 | 72.25 | 9.00 | -25.5 |
2017 | 35 | 3 | 552.25 | 25.00 | -117.5 |
Total | 46 | 32 | 1249.00 | 84.00 | 828 |
Ans a.
HCL(x) | WLMT(y) | |||
Expected Return = ∑x/n | Total return/total years | 11.50 | 8.00 |
Ans b
Standard deviation= | Formula | ((∑(x-(∑x/n))^2)/n)^(1/2) | ((∑(y-(∑y/n))^2)/n)^(1/2) | |
S.D | 17.67 | 4.58 | ||
Working | (1249/4)^(1/2) | (84/4)^(1/2) |
Ans c
Expected Return of Portfolio= | (Return of stock A* weight of stock A) + (Return of stock B* weight of stock B) | |||
(11.5*0.5)+(8*0.5) | ||||
9.75 |
Ans d
covariance (x,y)= | (∑(x-(∑x/n))(y-(∑y/n)))/n | |
207 | (828/4) |
Standard Deviation of Portfolio= | [{(weight of A)^2 * (sigma of A)^2} + {(weight of B)^2 + (sigma of B)^2} + {2*(weight of A)*(weight of B)*Covariance of A&B }^(1/2) | ||||
= | (((0.5^2)*(17.67^2))+((0.5^2)*(4.58^2))+(2*0.5*0.5*207))^(1/2) | ||||
= | 13.67 |