BHEL

Date Index Rm Rm-Rxm Security Price Ri Ri-Rxi

1-Jul-10 5251.4 NA NA 260.45 NA NA
2-Jul-10 5237.1 -0.27 -0.38 258.75 -0.65 -0.85
5-Jul-10 5235.9 -0.02 -0.13 260.35 0.62 0.42
6-Jul-10 5289.05 1.02 0.91 267.3 2.67 2.47
7-Jul-10 5241.1 -0.91 -1.02 264.2 -1.16 -1.36
8-Jul-10 5296.85 1.06 0.95 266 0.68 0.48
9-Jul-10 5352.45 1.05 0.94 276.15 3.82 3.62
12-Jul-10 5383 0.57 0.46 276.95 0.29 0.09
13-Jul-10 5400.65 0.33 0.22 281.05 1.48 1.28
14-Jul-10 5386.15 -0.27 -0.38 289.15 2.88 2.68
15-Jul-10 5378.75 -0.14 -0.25 288.55 -0.21 -0.41
16-Jul-10 5393.9 0.28 0.17 290.15 0.55 0.35
19-Jul-10 5386.45 -0.14 -0.25 287.4 -0.95 -1.15
20-Jul-10 5368 -0.34 -0.45 281.1 -2.19 -2.39
21-Jul-10 5399.35 0.58 0.47 284.65 1.26 1.06
22-Jul-10 5441.95 0.79 0.68 284.65 0.00 -0.20
23-Jul-10 5449.1 0.13 0.02 285.35 0.25 0.05
26-Jul-10 5418.6 -0.56 -0.67 284.05 -0.46 -0.66
27-Jul-10 5430.6 0.22 0.11 286.15 0.74 0.54
28-Jul-10 5397.55 -0.61 -0.72 284.6 -0.54 -0.74
29-Jul-10 5408.9 0.21 0.10 270.4 -4.99 -5.19
30-Jul-10 5367.6 -0.76 -0.87 270.75 0.13 -0.07
Sum 2.22 4.22
Average 0.11 0.20
Cov = (Rm-Rxm)(Ri-Rxi)/(n-1) = 0.45

Beta = (Cov/SD)= 1.35903400452

(Rm-Rxm)(Ri-Rxi) (Rm-Rxm)^2
NA NA
0.33 0.15
-0.06 0.02
2.24 0.82
1.38 1.03
0.46 0.91
3.40 0.88
0.04 0.21
0.28 0.05
-1.02 0.14
0.10 0.06
0.06 0.03
0.28 0.06
1.08 0.20
0.50 0.22
-0.14 0.46
0.00 0.00
0.44 0.45
0.06 0.01
0.53 0.52
-0.52 0.01
0.06 0.76
9.52 7.01

(Rm-Rxm)^2/(n-1)= 0.33
 Mahindra and Mahindra
Date Index Rm Rm-Rxm Security Price Rs Rs-Rxs (Rm-Rxm)(Rs-Rxs)
2-Aug-10 5431.65 NA NA 661.4 NA NA NA
3-Aug-10 5439.55 0.145444 0.122805 651.8 -1.451467 -1.212926586 -0.14895287273752
4-Aug-10 5467.85 0.520264 0.497624 656.85 0.774778 0.53623753912 0.266844838348025
5-Aug-10 5447.1 -0.379491 -0.40213 645.3 -1.758392 -1.996932327 0.803027063763804
6-Aug-10 5439.25 -0.144113 -0.166753 648.75 0.534635 0.29609505346 -0.04937464686405
9-Aug-10 5486.15 0.862251 0.839612 649.3 0.084778 -0.15376158 -0.044144123
10-Aug-10 5460.7 -0.463895 -0.486535 641.1 -1.262899 -1.5014385061 0.730502015793084
11-Aug-10 5420.6 -0.734338 -0.756977 626.95 -2.207144 -2.4456839713 1.85132748838092
12-Aug-10 5416.45 -0.07656 -0.099199 633.05 0.972964 0.73442435122 -0.07285423442702
13-Aug-10 5452.1 0.65818 0.635541 627.45 -0.884606 -1.1231462712 -0.71380535173332
16-Aug-10 5418.3 -0.619945 -0.642584 625.2 -0.358594 -0.5971343103 0.383708904540103
17-Aug-10 5414.15 -0.076592 -0.099232 620.2 -0.799744 -1.0382840819 0.103030588986321
18-Aug-10 5479.15 1.200558 1.177918 618.15 -0.330539 -0.569078536 -0.67032812883648
19-Aug-10 5540.2 1.114224 1.091585 616.05 -0.339723 -0.5782633681 -0.63122339451337
20-Aug-10 5530.65 -0.172376 -0.195016 617.7 0.267835 0.02929540297 -0.00571306520913
23-Aug-10 5543.5 0.232342 0.209702 624.15 1.044196 0.80565621175 0.16894794295535
24-Aug-10 5505.1 -0.692703 -0.715342 616.1 -1.289754 -1.5282940655 1.09325365955329
25-Aug-10 5462.35 -0.776553 -0.799192 615.15 -0.154196 -0.3927357474 0.313871251931303
26-Aug-10 5477.9 0.284676 0.262037 619.1 0.64212 0.40357980818 0.105752721184076
27-Aug-10 5408.7 -1.263258 -1.285897 611.8 -1.179131 -1.4176709966 1.82297906161366
30-Aug-10 5415.45 0.124799 0.10216 609.35 -0.400458 -0.6389976659 -0.06527976243248
31-Aug-10 5402.4 -0.240977 -0.263617 626.7 2.847296 2.60875629934 -0.68771123984919
Sum -0.498065 -5.248043 4.5538587174474
Average -0.022639 -0.23854

Cov (Rm-Rxm)(Rs-Rxs)/(n-1) 0.21685 SD (Rm-Rxm)^2/(n-1)

Beta (COV/SD) 0.541

(Rm-Rxm)^2
NA
0.015080951255236
0.247629959370933
0.161708805573593
0.027806459851235
0.704948176600773
0.236716067880072
0.573014780746377
0.009840461378002
0.403912189949209
0.412914091355813
0.009846910110835
1.38749196524053
1.19155696589609
0.038031145773919
0.043975045432664
0.511714856716879
0.63870778961964
0.068663232228406
1.65353142130708
0.010436589142529
0.069493666118602
8.41702153154841

0.40081
 Reliance Infrastructure Ltd.
Date Index Rm Rm-Rxm Security Price Rs Rs-Rxs (Rm-Rxm)(Rs-Rxs)
2-Aug-10 5431.65 NA NA 1116.6 NA NA NA
3-Aug-10 5439.55 0.145444 0.122805 1120.9 0.385098 -0.096272 -0.01182268412934
4-Aug-10 5467.85 0.520264 0.497624 1140.15 1.71737 1.236 0.615063639300288
5-Aug-10 5447.1 -0.379491 -0.40213 1116.65 -2.061132 -2.542502 1.02241730213113
6-Aug-10 5439.25 -0.144113 -0.166753 1109.55 -0.63583 -1.1172 0.186296170322972
9-Aug-10 5486.15 0.862251 0.839612 1117.45 0.712 0.23063 0.193639999849379
10-Aug-10 5460.7 -0.463895 -0.486535 1113.45 -0.357958 -0.839328 0.40836217013905
11-Aug-10 5420.6 -0.734338 -0.756977 1094.7 -1.683955 -2.165325 1.63910229136689
12-Aug-10 5416.45 -0.07656 -0.099199 1094.3 -0.03654 -0.51791 0.051376175088291
13-Aug-10 5452.1 0.65818 0.635541 1083.75 -0.964087 -1.445457 -0.91864675611803
16-Aug-10 5418.3 -0.619945 -0.642584 1046.8 -3.409458 -3.890828 2.50018343580658
17-Aug-10 5414.15 -0.076592 -0.099232 1032.75 -1.342186 -1.823556 0.180954347664767
18-Aug-10 5479.15 1.200558 1.177918 1041.3 0.827887 0.346517 0.408168439519939
19-Aug-10 5540.2 1.114224 1.091585 1063.25 2.107942 1.626572 1.77554096123994
20-Aug-10 5530.65 -0.172376 -0.195016 1070.3 0.663061 0 0
23-Aug-10 5543.5 0.232342 0.209702 1045.15 -2.349808 -2.831178 -0.59370457374887
24-Aug-10 5505.1 -0.692703 -0.715342 1024.45 -1.980577 -2.461947 1.76113522532183
25-Aug-10 5462.35 -0.776553 -0.799192 1013.65 -1.054224 -1.535594 1.22723455341045
26-Aug-10 5477.9 0.284676 0.262037 1003.55 -0.996399 -1.477769 -0.38722975207192
27-Aug-10 5408.7 -1.263258 -1.285897 983.15 -2.032784 -2.514154 3.2329429145013
30-Aug-10 5415.45 0.124799 0.10216 998.1 1.520622 1.039252 0.106169645376258
31-Aug-10 5402.4 -0.240977 -0.263617 1001.9 0.380723 -0.100647 0.026532112519603
Sum -0.498065 -10.59023 -20.8807 13.4237156174905
Average -0.022639 0.48137

COV (Rm-Rxm)(Rs-Rxs)/(n-1) 0.6392 SD (Rm-Rxm)^2/(n-1)

Beta (COV/SD)= 1.59

(Rm-Rxm)^2
NA
0.015080951
0.247629959
0.161708806
0.02780646
0.704948177
0.236716068
0.573014781
0.009840461
0.40391219
0.412914091
0.00984691
1.387491965
1.191556966
0.038031146
0.043975045
0.511714857
0.63870779
0.068663232
1.653531421
0.010436589
0.069493666
8.417021532

0.4008