123

profilearchmage
finance.xlsx
Home>Business & Finance homework help>Accounting homework help>123

Sheet2

Stock A Stock B RF 0.015 Period ALL ORDS ACCUM INDEX RETURN ON STOCK A RETURN ON STOCK B
Expected Return 0.0622916667 0.0502833333 STOCK A STOCK B D 212.17
Variance 0.0128963281 0.004806387 WEIGHT 50% 50% J 274.08 0.11570 0.07290
Standard Deviation 0.1135620012 0.069328111 F 284.02 -0.00410 0.08350
Coefficient of Variation 1.8230689148 1.3787493065 M 291.70 0.05420 0.08410
Covariance 0.004 A 298.36 -0.00400 0.06660
Correlation Coefficient 0.5129444498 M 290.10 -0.03630 -0.00080
Portfolio Return 0.0562875 J 304.00 0.14640 0.02250
Portfolio Variance 0.0064448946 J 318.66 0.09630 -0.00920
Portfolio Std. Deviation 0.0802801009 A 329.80 0.02030 0.04580
S 300.00 -0.05630 -0.09810
O 320.00 0.31320 0.18740
N 310.00 -0.07770 0.09590
D 350.00 0.17980 0.05280