Corporate Finance
Corporate Finance
Name ID
Md. Mohiuddin Khan 16-025
Nasib Imroz 16-258
Titu Chowdhury 16-031
Amir Hamza Chowdhury 16-109
Azharul Islam 16-067
Md. Kofiluddin 16-043
Company name
Bay Leasing & Investment Ltd
BD. Autocars
AMCL PRAN This company is chosen by us instead of BDBUILDING. Because it was listed in Stock exchang
BDCOM Online Ltd
t was listed in Stock exchange in 2013 ( Data Unavailabilty)
Face Value 10
cash Stock
dividend dividend
adjusted no.of adjusted
Price Cash div price Stock Div stocks price
January 0 1 0
February 0 1 0
March 0 1 0
April 0 1 0
May 0 1 0
June 0 1 0
2003 July 0 1 0
August 0 1 0
September 0 1 0
October 0 1 0
November 0 1 0
December 0 1 0
January 0 1 0
February 0 1 0
March 0 1 0
April 0 1 0
May 0 1 0
June 0 1 0
2004 July 0 1 0
August 0 1 0
September 0 1 0
October 0 1 0
November 0 1 0
December 0 1 0
January 0 1 0
February 0 1 0
March 0 1 0
April 0 1 0
May 0 1 0
June 0 1 0
2005 July 0 1 0
August 0 1 0
September 0 1 0
October 0 1 0
November 0 1 0
December 0 1 0
January 0 1 0
February 0 1 0
March 0 1 0
April 0 1 0
May 0 1 0
June 0 1 0
2006 July 0 1 0
August 0 1 0
September 0 1 0
October 0 1 0
November 0 1 0
December 0 1 0
January 0 1 0
February 0 1 0
March 0 1 0
April 0 1 0
May 0 1 0
June 0 1 0
2007 July 0 1 0
August 0 1 0
September 0 1 0
October 0 1 0
November 0 1 0
December 0 1 0
January 0 1 0
February 0 1 0
March 0 1 0
April 0 1 0
May 0 1 0
June 0 1 0
2008 July 0 1 0
August 0 1 0
September 0 1 0
October 0 1 0
November 0 1 0
December 0 1 0
January 0 1 0
February 0 1 0
March 0 1 0
April 722.75 722.75 1 722.75
May 856.25 856.25 1 856.25
June 886.25 886.25 1 886.25
2009 July 859.25 859.25 1 859.25
August 916.25 916.25 1 916.25
September 1,069.50 1069.5 1 1069.5
October 1,309.50 1309.5 1 1309.5
November 1721.5 1721.5 1 1721.5
December 1721.5 1721.5 1 1721.5
January 1,663.50 1663.5 1 1663.5
February 1,764.75 1764.75 1 1764.75
March 1,728.75 1728.75 1 1728.75
April 1,431.75 1431.75 0.5 1.5 2147.625
May 1798 1798 1 1798
June 1833.25 1833.25 1 1833.25
2010 July 2,166.75 2166.75 1 2166.75
August 2,879.25 2879.25 1 2879.25
September 1,806.00 1806 1 1806
October 2,682.00 2682 1 2682
November 3,069.00 3069 1 3069
December 2,926.25 2926.25 1 2926.25
January 2,704.75 2704.75 1 2704.75
February 1,904.50 1904.5 1 1904.5
March 1,904.50 1904.5 1 1904.5
April 1,848.50 1848.5 1 1848.5
May 1,155.00 10 1165 0.55 1.55 1805.75
June 1,122.00 1122 1 1122
2011 July 1,077.00 1077 1 1077
August 1,023.00 1023 1 1023
September 884.50 884.5 1 884.5
October 681.50 681.5 1 681.5
November 710.50 710.5 1 710.5
December 70.10 70.1 1 70.1
January 49.2 49.2 1 49.2
February 58.5 58.5 1 58.5
March 61.9 61.9 1 61.9
April 55.2 1.5 56.7 0.2 1.2 68.04
May 49.9 49.9 1 49.9
June 44.9 44.9 1 44.9
2012 July 39 39 1 39
August 42.7 42.7 1 42.7
September 47 47 1 47
October 39.3 39.3 1 39.3
November 36.7 36.7 1 36.7
December 35.3 35.3 1 35.3
Mean
10 10
cash Stock
Stock split dividend dividend
adjusted Average adjusted no.of adjusted Average
price Returns Price Cash div price Stock Div stocks price Return Price
0 53.50 0.2 53.70 1 53.7 353.50
0 #DIV/0! 49.00 49.00 1 49 -0.091593 354.75
0 #DIV/0! 41.00 41.00 1 41 -0.178248 337.50
0 #DIV/0! 62.25 62.25 1 62.25 0.417586 369.75
0 #DIV/0! 64.00 64.00 1 64 0.027725 389.00
0 #DIV/0! 60.00 60.00 1 60 -0.064539 416.25
0 #DIV/0! 58.00 58.00 1 58 -0.033902 399.25
0 #DIV/0! 50.50 50.50 1 50.5 -0.13847 401.00
0 #DIV/0! 59.25 59.25 1 59.25 0.159792 398.25
0 #DIV/0! 56.75 56.75 1 56.75 -0.04311 407.00
0 #DIV/0! 66.25 66.25 1 66.25 0.15478 417.25
0 #DIV/0! 58.00 58.00 1 58 -0.132992 425.50
0 #DIV/0! 61.00 61.00 1 61 0.050431 413.75
0 #DIV/0! 58.75 58.75 1 58.75 -0.037583 405.75
0 #DIV/0! 57.25 57.25 1 57.25 -0.025864 394.25
0 #DIV/0! 52.25 52.25 1 52.25 -0.091388 463.00
0 #DIV/0! 60.00 60.00 1 60 0.138305 451.50
0 #DIV/0! 60.00 60.00 1 60 0 517.00
0 #DIV/0! 58.50 58.50 1 58.5 -0.025318 554.25
0 #DIV/0! 59.00 59.00 1 59 0.008511 567.75
0 #DIV/0! 72.00 72.00 1 72 0.199129 726.75
0 #DIV/0! 55.00 0.3 55.30 1 55.3 -0.263893 635.25
0 #DIV/0! 54.25 54.25 1 54.25 -0.01917 620.25
0 #DIV/0! 48.25 48.25 1 48.25 -0.117207 591.50
0 #DIV/0! 50.25 50.25 1 50.25 0.040615 507.50
0 #DIV/0! 49.50 49.50 1 49.5 -0.015038 503.25
0 #DIV/0! 45.50 45.50 1 45.5 -0.08426 519.00
0 #DIV/0! 43.25 43.25 1 43.25 -0.050715 468.25
0 #DIV/0! 45.50 45.50 1 45.5 0.050715 513.25
0 #DIV/0! 43.50 43.50 1 43.5 -0.044951 514.50
0 #DIV/0! 39.00 39.00 1 39 -0.109199 455.25
0 #DIV/0! 40.75 40.75 1 40.75 0.043894 491.75
0 #DIV/0! 40.00 40.00 1 40 -0.018576 490.75
0 #DIV/0! 42.00 0.3 42.30 1 42.3 0.055908 470.50
0 #DIV/0! 38.00 38.00 1 38 -0.107201 433.00
0 #DIV/0! 35.00 35.00 1 35 -0.082238 400.75
0 #DIV/0! 41.00 41.00 1 41 0.158224 391.25
0 #DIV/0! 49.00 49.00 1 49 0.178248 378.50
0 #DIV/0! 67 67.00 1 67 0.312872 377.25
0 #DIV/0! 59 59.00 1 59 -0.127155 372
0 #DIV/0! 57.75 57.75 1 57.75 -0.021414 377.00
0 #DIV/0! 52.00 52.00 1 52 -0.10488 386.00
0 #DIV/0! 46.75 46.75 1 46.75 -0.106429 402.25
0 #DIV/0! 54.50 54.50 1 54.5 0.153386 418.75
0 #DIV/0! 51.00 51.00 1 51 -0.066375 411.75
0 #DIV/0! 58.50 0.3 58.80 1 58.8 0.142316 415.00
0 #DIV/0! 47 47.00 1 47 -0.223994 365.75
0 #DIV/0! 54.25 54.25 1 54.25 0.143455 363.25
0 #DIV/0! 56.5 56.50 1 56.5 0.040638 397
0 #DIV/0! 69.75 69.75 1 69.75 0.210677 390.75
0 #DIV/0! 63.25 63.25 1 63.25 -0.097822 392.25
0 #DIV/0! 64.75 64.75 1 64.75 0.023439 392.25
0 #DIV/0! 60.25 60.25 1 60.25 -0.072031 388.5
0 #DIV/0! 63.75 63.75 1 63.75 0.056467 400.25
0 #DIV/0! 68 68.00 1 68 0.064539 536.5
0 #DIV/0! 72.25 72.25 1 72.25 0.060625 521.75
0 #DIV/0! 76 76.00 1 76 0.050601 621.75
0 #DIV/0! 72.75 0.3 73.05 1 73.05 -0.039589 732.25
0 #DIV/0! 74 74.00 1 74 0.012921 652.75
0 #DIV/0! 128.25 128.25 1 128.25 0.549916 580.5
0 #DIV/0! 116 116.00 1 116 -0.100391 587.25
0 #DIV/0! 107.75 107.75 1 107.75 -0.073776 570.75
0 #DIV/0! 204.50 204.50 1 204.5 0.640754 831.50
0 #DIV/0! 202.25 202.25 1 202.25 -0.011063 1060.50
0 #DIV/0! 192.25 192.25 1 192.25 -0.050708 1271.25
0 #DIV/0! 161.75 161.75 1 161.75 -0.172745 1138.50
0 #DIV/0! 161.5 161.50 1 161.5 -0.001547 990
0 #DIV/0! 162.5 162.50 1 162.5 0.006173 981.5
0 #DIV/0! 159.25 159.25 1 159.25 -0.020203 1096.25
0 #DIV/0! 158.75 0.3 159.05 1 159.05 -0.001257 1,088.25
0 #DIV/0! 115.75 115.75 1 115.75 -0.317786 859.25
0 #DIV/0! 135.5 135.50 1 135.5 0.157539 1013.75
0 #DIV/0! 189 189.00 1 189 0.332775 1091.25
0 #DIV/0! 312 312.00 1 312 0.501256 1192.25
0 #DIV/0! 516.25 516.25 1 516.25 0.503588 1386.25
72.275 #DIV/0! 405 405.00 1 405 -0.242704 1196.5
85.625 0.169499 443 443.00 1 443 0.089683 1253.5
88.625 0.034437 409.00 409.00 1 409 -0.079855 1,364.75
85.925 -0.030939 424.50 424.50 1 424.5 0.037197 1,352.00
91.625 0.064229 509.25 509.25 1 509.25 0.182027 1,368.25
106.95 0.154657 608.75 608.75 1 608.75 0.178469 1,490.25
130.95 0.202454 513.00 0.3 513.30 1 513.3 -0.170547 1,623.00
172.15 0.273551 506.25 506.25 1 506.25 -0.01383 1657.5
172.15 0 406.00 406.00 1 406 -0.220677 1533.75
166.35 -0.034272 496.25 496.25 1 496.25 0.200727 1,698.50
176.475 0.059085 411.75 411.75 1 411.75 -0.186663 1,600.00
172.875 -0.02061 437.50 437.50 1 437.5 0.06066 1,630.75
214.7625 0.216964 438.00 438.00 1 438 0.001142 1,858.00
179.8 -0.177688 381 381.00 1 381 -0.13942 1807.25
183.325 0.019415 296.5 296.50 1 296.5 -0.250752 1714.5
216.675 0.167138 353.75 353.75 1 353.75 0.176543 1,831.25
287.925 0.284301 412.00 412.00 1 412 0.152433 1,948.75
180.6 -0.466415 489.00 489.00 1 489 0.171339 1,882.50
268.2 0.395448 523.00 523.00 0.05 1.05 549.15 0.116009 1,852.00
306.9 0.134789 783.00 783.00 1 783 0.354761 1984
292.625 -0.04763 556.75 556.75 1 556.75 -0.341016 1,761.25
270.475 -0.078712 510.25 510.25 1 510.25 -0.087216 1,604.75
190.45 -0.35079 280.75 280.75 1 280.75 -0.597436 1,120.50
190.45 0 579.00 579.00 1 579 0.723838 1,628.00
184.85 -0.029845 543.75 543.75 1 543.75 -0.062813 1,579.75
180.575 -0.023398 495.25 495.25 1 495.25 -0.093427 1,455.50
112.2 -0.475863 460.25 460.25 1 460.25 -0.073293 1,526.75
107.7 -0.040933 475.50 475.50 1 475.5 0.032597 1,597.50
102.3 -0.05144 516.75 516.75 1 516.75 0.083192 1,522.50
88.45 -0.145472 640.50 640.50 1 640.5 0.21469 1,536.00
68.15 -0.260726 338.75 338.75 1 338.75 -0.636987 1,296.25
71.05 0.041673 397.75 397.75 1 397.75 0.160561 1,282.00
70.1 -0.013461 56.50 56.50 1 56.5 -1.951583 138.50
49.2 -0.354029 50.3 50.30 1 50.3 -0.116236 109.4
58.5 0.173133 49.8 49.80 1 49.8 -0.00999 117.7
61.9 0.056493 50.3 50.30 1 50.3 0.00999 130.9
68.04 0.094576 42.4 42.40 1 42.4 -0.170857 130.3
49.9 -0.310075 37.5 37.50 1 37.5 -0.122807 122
44.9 -0.105583 37.8 37.80 1 37.8 0.007968 128
39 -0.140876 31.3 31.30 1 31.3 -0.188691 122.1
42.7 0.090637 35.6 35.60 1 35.6 0.128728 127.9
47 0.095949 41.4 41.40 1 41.4 0.150935 139.5
39.3 -0.178923 35.5 35.50 1 35.5 -0.153748 134
36.7 -0.068448 34.6 34.60 1 34.6 -0.025679 124.6
35.3 -0.038894 29.3 29.30 1 29.3 -0.166266 122
-0.016286 -0.005091
10
0.010409
COM Online Ltd
Stock
dividend
no.of adjusted Average DGEN
Stock Div stocks price Return DGEN Return
1 12.9 807.60
1 12.6 -0.02353 806.92 -0.000842
1 11.4 -0.100083 750.84 -0.072032
1 12.3 0.075986 787.94 0.048229
1 14.1 0.136576 791.70 0.004761
1 14.5 0.027974 830.46 0.047797
1 13.3 -0.086385 799.98 -0.037393
1 11.4 -0.154151 793.12 -0.008612
1 10.6 -0.072759 789.74 -0.004271
1 12.6 0.172843 801.27 0.014494
1 13.9 0.098192 920.61 0.138839
1 12.4 -0.114192 967.88 0.050072
1 12.1 -0.024491 961.18 -0.006946
1 11.9 -0.016667 953.81 -0.007697
1 11.7 -0.01695 973.88 0.020824
1 11.7 0 1,112.19 0.132798
1 12.4 0.058108 1,185.83 0.064112
1 12.9 0.039531 1,318.92 0.10637
1 12.9 0 1,289.14 -0.022838
1 13.5 0.045462 1,513.29 0.160311
1 15.2 0.118606 1,633.02 0.076145
1 16.5 0.082065 1,710.45 0.046325
1 15.5 -0.06252 1,877.05 0.092945
1 25.4 0.493909 1,971.31 0.048997
1 21.4 -0.171358 1,843.95 -0.066789
1 24.7 0.143412 1,835.62 -0.004526
1 23.3 -0.05835 1,919.25 0.044553
1 23.7 0.017022 1,537.87 -0.221538
1 24.3 0.025001 1,789.80 0.151706
1 23 -0.054982 1,713.17 -0.043758
1 17 -0.302281 1,510.11 -0.126163
1 19.9 0.157506 1,613.17 0.066019
1 20.2 0.014963 1,673.21 0.036543
1 20.6 0.019608 1,694.62 0.012713
1 22.1 0.070287 1,694.42 -0.000117
1 18.5 -0.177807 1,677.35 -0.010125
1 18.6 0.005391 1,643.34 -0.020484
1 17.1 -0.084083 1,531.43 -0.070529
1 19.4 0.126195 1,491.77 -0.026239
1 17.5 -0.103072 1,361.27 -0.091545
1 17.2 -0.017291 1,355.04 -0.004587
1 16.1 -0.06609 1,339.52 -0.01152
1 16.2 0.006192 1,406.81 0.049013
1 17 0.048202 1,587.08 0.120571
1 16.3 -0.042048 1,562.53 -0.01559
1 13.5 -0.188475 1,541.65 -0.013453
1 11.6 -0.151685 1,527.29 -0.009358
1 13.3 0.136759 1,609.51 0.052435
1 15.1 0.126931 1,805.12 0.114697
1 19.3 0.24541 1,791.54 -0.007549
1 15.6 -0.212834 1,760.88 -0.017267
1 16.6 0.062132 1,743.33 -0.010015
1 18.5 0.108368 2,003.58 0.139142
1 18.9 0.021391 2,149.32 0.070212
1 23 0.196332 2,384.18 0.103706
1 20.1 -0.134774 2,455.09 0.029306
1 21.2 0.053281 2,548.19 0.03722
0.12 1.12 29.904 0.343991 2,850.81 0.112223
1 20 -0.40226 2,971.11 0.041332
1 19.3 -0.035627 3,017.21 0.015398
1 19.9 0.030615 2,907.17 -0.037155
1 23.6 0.170527 2,931.38 0.008296
1 26.4 0.112117 3,016.49 0.028619
1 26.9 0.018762 3,072.85 0.018512
1 26 -0.03403 3,167.99 0.030493
1 28 0.074108 3,000.50 -0.05432
1 28.6 0.021202 2,801.43 -0.068648
1 33.3 0.152151 2,791.21 -0.003655
0.1 1.1 34.32 0.030171 2,966.82 0.061015
1 35.5 0.033804 2,748.60 -0.076399
1 25.1 -0.346665 2,468.92 -0.107311
1 34 0.303493 2,795.34 0.124172
1 37.1 0.087256 2,649.49 -0.053583
1 36.6 -0.013569 2,570.96 -0.030088
1 47.9 0.269067 2,446.92 -0.04945
1 42.2 -0.126695 2,554.36 0.042969
1 45.3 0.070887 2,572.18 0.006954
1 47.9 0.055808 3,010.26 0.157274
1 53.5 0.110566 2,914.53 -0.032318
1 2 113.2 0.749475 2,941.28 0.009136
1 37.3 -1.110163 3,083.89 0.047344
1 83.8 0.80944 3,364.26 0.087018
1 74.7 -0.114953 4,380.95 0.264057
1 65.2 -0.136021 4,535.53 0.034677
1 75.7 0.149319 5,367.11 0.168347
1 60.8 -0.219188 5,560.56 0.03541
1 62.3 0.024372 5,582.33 0.003908
1 61.9 -0.006441 5,654.88 0.012911
1 51.5 -0.183938 6,107.81 0.077051
1 51.6 0.00194 6,153.68 0.007481
1 55.5 0.072861 6,342.76 0.030264
1 63.3 0.131502 6,657.97 0.048502
1 65.4 0.032637 7,097.38 0.063911
0.13 1.13 66.218 0.01243 7,957.12 0.114341
1 54.8 -0.189262 8,602.44 0.077979
1 50.1 -0.089669 8,290.41 -0.036946
1 45.1 -0.105139 7,484.23 -0.102302
1 28.1 -0.473113 5,203.08 -0.363546
1 45.1 0.473113 6,352.10 0.199534
1 41 -0.09531 6,050.85 -0.048588
1 37.7 -0.083912 5,758.26 -0.049562
1 36.3 -0.037842 6,117.23 0.060474
1 40.7 0.11441 6,459.62 0.054461
1 36 -0.122709 6,212.00 -0.039089
1 32.3 -0.108452 5,910.20 -0.049802
0.05 1.05 22.26 -0.372276 5,036.50 -0.159969
1 29.8 0.291717 5,268.55 0.045045
1 26.1 -0.132573 4,996.34 -0.05305
1 20.2 -0.256253 4153.96 -0.184643
1 23 0.129812 4695.41 0.122522
1 23.2 0.008658 4990.32 0.060916
1 22.8 -0.017392 5098.90 0.021525
1 20.4 -0.111226 4734.33 -0.074185
1 20.3 -0.004914 4572.88 -0.034698
1 17.9 -0.12582 4159.17 -0.094828
1 20.3 0.12582 4446.87 0.066886
1 26.2 0.255139 4544.41 0.021697
1 27 0.030077 4493.92 -0.011172
1 20.3 -0.285216 4210.58 -0.065125
1 19.1 -0.060933 4219.31 0.002072
0.003298
Average Monthly return
AMCL
PRAN BDCOM
average average
Company Name Bay Leasing avBD.Autocars averareturn return
Company Name Bay Leasing averagBD.Autocars averAMCL PRAN average retBDCOM average return
BDCOM
5.30
0.04
0.21
Bay leasing BD Autocars AMCL PRAN BDCOM
Year Month Ri - E(Ri) Ri - E(Ri) Ri - E(Ri) Ri - E(Ri)
2003 January C*D C*E
February -0.086501733 -0.0068796 -0.02682849 0 0
March -0.173157261 -0.06025724 -0.10338145 0 0
April 0.4226774391 0.080852157 0.07268792 0 0
May 0.0328155185 0.040342808 0.13327754 0 0
June -0.059447551 0.11335397 0.02467586 0 0
July -0.028810581 -0.10816439 -0.08968261 0 0
August -0.133378704 -0.00603579 -0.15744867 0 0
September 0.1648834142 -0.01729091 -0.07605735 0 0
October -0.038019153 0.011323803 0.16954482 0 0
November 0.159870779 0.014462943 0.09489403 0 0
December -0.127901484 0.009169951 -0.11749036 0 0
2004 January 0.0555218241 -0.03841246 -0.02778901 0 0
February -0.032491741 -0.02993415 -0.01996504 0 0
March -0.02077254 -0.03916141 -0.02024755 0 0
April -0.086296781 0.150332394 -0.00329799 0 0
May 0.1433956418 -0.03556112 0.05480964 0 0
June 0.0050909705 0.170434472 0.03623285 0 0
July -0.020226838 0.013787136 -0.00329799 0 0
August 0.0136016601 0.013655898 0.04216438 0 0
September 0.2042196456 0.236491924 0.11530775 0 0
October -0.25880224 -0.14497335 0.07876696 0 0
November -0.014078946 -0.03430543 -0.06581835 0 0
December -0.112116194 -0.05787037 0.49061116 0 0
2005 January 0.0457056896 -0.16357441 -0.17465624 0 0
February -0.009946907 -0.01881908 0.14011433 0 0
March -0.079169373 0.020407385 -0.06164787 0 0
April -0.045624122 -0.11331098 0.0137237 0 0
May 0.055806063 0.081351281 0.02170331 0 0
June -0.039860417 -0.00797693 -0.05828013 0 0
July -0.104108321 -0.13275827 -0.30557886 0 0
August 0.048985164 0.066714305 0.1542084 0 0
September -0.013485415 0.039179307 0.01166488 0 0
October 0.0609986024 -0.10417267 0.01631048 0 0
November -0.102109956 -0.09346767 0.06698854 0 0
December -0.077147128 -0.08780937 -0.18110487 0 0
2006 January 0.1633149757 -0.03440048 0.00209286 0 0
February 0.1833392019 -0.0435401 -0.08738111 0 0
March 0.3179632917 -0.01371741 0.12289661 0 0
April -0.122064205 -0.02442368 -0.10637018 0 0
May -0.016323124 0.002941899 -0.02058949 0 0
June -0.09978866 0.013182748 -0.0693881 0 0
July -0.101338492 0.030826982 0.00289398 0 0
August 0.1584774164 0.029790863 0.04490411 0 0
September -0.061284098 -0.02726715 -0.04534623 0 0
October 0.1474071926 -0.00254728 -0.19177341 0 0
November -0.218903283 -0.06806407 -0.15498258 0 0
December 0.1485463612 -0.08594201 0.13346095 0 0
2007 January 0.0457286162 0.078435544 0.12363272 0 0
February 0.215767753 -0.02627775 0.24211236 0 0
March -0.092731323 -0.00657801 -0.21613217 0 0
April 0.0285295434 -0.01040943 0.05883379 0 0
May -0.066940158 -0.02001566 0.10507004 0 0
June 0.0615575821 0.019386748 0.0180932 0 0
July 0.0696294916 0.282567776 0.1930343 0 0
August 0.0657155923 -0.03828745 -0.13807239 0 0
September 0.0556919838 0.164940103 0.04998337 0 0
October -0.034498232 0.153174469 0.34069308 0 0
November 0.0180119255 -0.08627855 -0.40555797 0 0
December 0.5550073613 -0.1667725 -0.03892517 0 0
2008 January -0.095300322 0.001151388 0.02731664 0 0
February -0.068685492 -0.03890877 0.16722899 0 0
March 0.645845217 0.365870579 0.10881931 0 0
April -0.005972449 0.232855041 0.01546428 0 0
May -0.045616977 0.170850739 -0.03732774 0 0
June -0.167653705 -0.1206985 0.07080998 0 0
July 0.0035441797 -0.15017138 0.01790422 0 0
August 0.0112638296 -0.01903236 0.14885269 0 0
September -0.015111737 0.100159096 0.02687289 0 0
October 0.0038342942 -0.0177338 0.03050643 0 0
November -0.312694955 -0.21460882 -0.34996284 0 0
December 0.1626299178 0.12287538 0.30019469 0 0
2009 January 0.3378663452 0.063258068 0.08395845 0 0
February 0.5063471432 0.078109016 -0.01686672 0 0
March 0.5086789269 0.140350547 0.26576927 0 0
April -0.237613107 -0.15761107 -0.12999328 0 0
May 0.18578527 0.0947736734 0.036129576 0.06758882 0.017608 0.00671234
June 0.05072295 -0.074763644 0.074622189 0.05251048 -0.003792 0.00378506
July -0.0146529 0.0422878202 -0.01979572 0.10726816 -0.00062 0.00029006
August 0.08051559 0.1871180198 0.001538139 0.74617652 0.015066 0.00012384
September 0.17094353 0.1835595898 0.075001906 -1.11346083 0.031378 0.01282109
October 0.21874039 -0.165456234 0.09263335 0.80614169 -0.036192 0.02026266
November 0.28983688 -0.008738881 -0.00708567 -0.11825091 -0.002533 -0.00205369
December 0.01628626 -0.215586488 -0.08800416 -0.13931862 -0.003511 -0.00143326
2010 January -0.01798593 0.2058176429 0.091620358 0.1460207 -0.003702 -0.00164788
February 0.07537148 -0.181572492 -0.07015131 -0.22248636 -0.013685 -0.00528741
March -0.00432418 0.0657513072 0.008626968 0.02107365 -0.000284 -3.7305E-05
April 0.23325023 0.006233175 0.120051175 -0.00973924 0.001454 0.02800196
May -0.16140139 -0.134328565 -0.03810372 -0.18723636 0.021681 0.00614999
June 0.03570167 -0.245661186 -0.06309429 -0.00135813 -0.008771 -0.00225257
July 0.18342426 0.181634201 0.055467867 0.06956336 0.033316 0.01017415
August 0.30058775 0.1575238709 0.051779914 0.12820432 0.04735 0.01556441
September -0.45012913 0.1764301106 -0.04499689 0.02933894 -0.079416 0.02025441
October 0.41173459 0.1211001092 -0.02674398 0.00913208 0.049861 -0.01101142
November 0.15107525 0.3598520382 0.073447224 -0.19256013 0.054365 0.01109606
December -0.03134378 -0.335925419 -0.14450844 -0.09296718 0.010529 0.00452944
2011 January -0.062426 -0.082124534 -0.10346524 -0.10843675 0.005127 0.00645892
February -0.33450372 -0.592345238 -0.3696024 -0.47641066 0.198142 0.12363338
March 0.01628626 0.7289288544 0.363167819 0.46981468 0.011872 0.00591464
April -0.01355875 -0.057721925 -0.04049509 -0.09860817 0.000783 0.00054906
May -0.00711222 -0.088335926 -0.09232656 -0.08720996 0.000628 0.00065665
June -0.45957695 -0.068201895 0.037382375 -0.04114034 0.031344 -0.01718008
July -0.02464715 0.0376880323 0.03488918 0.11111236 -0.000929 -0.00085992
August -0.03515365 0.088283287 -0.05849562 -0.12600715 -0.003103 0.00205633
September -0.12918599 0.2197808932 -0.00158152 -0.1117497 -0.028393 0.00020431
October -0.24444001 -0.631895779 -0.18011559 -0.37557388 0.154461 0.04402746
November 0.05795895 0.1656522655 -0.02146356 0.28841906 0.009601 -0.00124401
December 0.0028252 -1.946492059 0.066869347 -0.13587107 -0.005499 0.00018892
2012 January -0.33774291 -0.111144591 -0.24626887 -0.2595507 0.037538 0.08317557
February 0.18941939 -0.004899123 0.06271869 0.12651362 -0.000928 0.01188014
March 0.07277968 0.0150810635 0.095885225 0.00536007 0.001098 0.0069785
April 0.11086185 -0.165765744 -0.01500362 -0.02068973 -0.018377 -0.00166333
May -0.29378851 -0.117716459 -0.07622787 -0.11452363 0.034584 0.02239487
June -0.08929695 0.0130591401 0.037599785 -0.00821201 -0.001166 -0.00335755
July -0.12458989 -0.183600035 -0.05759932 -0.12911816 0.022875 0.00717629
August 0.10692353 0.1338185108 0.035998893 0.12252218 0.014308 0.00384913
September 0.11223494 0.1560262134 0.076406459 0.25184053 0.017512 0.00857547
October -0.16263683 -0.148657214 -0.05063424 0.02677946 0.024177 0.00823499
November -0.05216151 -0.020588044 -0.08314063 -0.28851397 0.001074 0.00433674
December -0.02260753 -0.161175196 -0.031497 -0.06423054 0.003644 0.00071207
1
2
3
1
2
3
4
5
6
Bay leasing BD AutocarsAMCL PRANBDCOM
Year Month Ri - E(Ri) Ri - E(Ri) Ri - E(Ri) Ri - E(Ri)
2003 January C*D C*E C*F
February -8.65% -0.69% -2.68% 0.00% 0.00% 0.00%
March -17.32% -6.03% -10.34% 0.00% 0.00% 0.00%
April 42.27% 8.09% 7.27% 0.00% 0.00% 0.00%
May 3.28% 4.03% 13.33% 0.00% 0.00% 0.00%
June -5.94% 11.34% 2.47% 0.00% 0.00% 0.00%
July -2.88% -10.82% -8.97% 0.00% 0.00% 0.00%
August -13.34% -0.60% -15.74% 0.00% 0.00% 0.00%
September 16.49% -1.73% -7.61% 0.00% 0.00% 0.00%
October -3.80% 1.13% 16.95% 0.00% 0.00% 0.00%
November 15.99% 1.45% 9.49% 0.00% 0.00% 0.00%
December -12.79% 0.92% -11.75% 0.00% 0.00% 0.00%
2004 January 5.55% -3.84% -2.78% 0.00% 0.00% 0.00%
February -3.25% -2.99% -2.00% 0.00% 0.00% 0.00%
March -2.08% -3.92% -2.02% 0.00% 0.00% 0.00%
April -8.63% 15.03% -0.33% 0.00% 0.00% 0.00%
May 14.34% -3.56% 5.48% 0.00% 0.00% 0.00%
June 0.51% 17.04% 3.62% 0.00% 0.00% 0.00%
July -2.02% 1.38% -0.33% 0.00% 0.00% 0.00%
August 1.36% 1.37% 4.22% 0.00% 0.00% 0.00%
September 20.42% 23.65% 11.53% 0.00% 0.00% 0.00%
October -25.88% -14.50% 7.88% 0.00% 0.00% 0.00%
November -1.41% -3.43% -6.58% 0.00% 0.00% 0.00%
December -11.21% -5.79% 49.06% 0.00% 0.00% 0.00%
2005 January 4.57% -16.36% -17.47% 0.00% 0.00% 0.00%
February -0.99% -1.88% 14.01% 0.00% 0.00% 0.00%
March -7.92% 2.04% -6.16% 0.00% 0.00% 0.00%
April -4.56% -11.33% 1.37% 0.00% 0.00% 0.00%
May 5.58% 8.14% 2.17% 0.00% 0.00% 0.00%
June -3.99% -0.80% -5.83% 0.00% 0.00% 0.00%
July -10.41% -13.28% -30.56% 0.00% 0.00% 0.00%
August 4.90% 6.67% 15.42% 0.00% 0.00% 0.00%
September -1.35% 3.92% 1.17% 0.00% 0.00% 0.00%
October 6.10% -10.42% 1.63% 0.00% 0.00% 0.00%
November -10.21% -9.35% 6.70% 0.00% 0.00% 0.00%
December -7.71% -8.78% -18.11% 0.00% 0.00% 0.00%
2006 January 16.33% -3.44% 0.21% 0.00% 0.00% 0.00%
February 18.33% -4.35% -8.74% 0.00% 0.00% 0.00%
March 31.80% -1.37% 12.29% 0.00% 0.00% 0.00%
April -12.21% -2.44% -10.64% 0.00% 0.00% 0.00%
May -1.63% 0.29% -2.06% 0.00% 0.00% 0.00%
June -9.98% 1.32% -6.94% 0.00% 0.00% 0.00%
July -10.13% 3.08% 0.29% 0.00% 0.00% 0.00%
August 15.85% 2.98% 4.49% 0.00% 0.00% 0.00%
September -6.13% -2.73% -4.53% 0.00% 0.00% 0.00%
October 14.74% -0.25% -19.18% 0.00% 0.00% 0.00%
November -21.89% -6.81% -15.50% 0.00% 0.00% 0.00%
December 14.85% -8.59% 13.35% 0.00% 0.00% 0.00%
2007 January 4.57% 7.84% 12.36% 0.00% 0.00% 0.00%
February 21.58% -2.63% 24.21% 0.00% 0.00% 0.00%
March -9.27% -0.66% -21.61% 0.00% 0.00% 0.00%
April 2.85% -1.04% 5.88% 0.00% 0.00% 0.00%
May -6.69% -2.00% 10.51% 0.00% 0.00% 0.00%
June 6.16% 1.94% 1.81% 0.00% 0.00% 0.00%
July 6.96% 28.26% 19.30% 0.00% 0.00% 0.00%
August 6.57% -3.83% -13.81% 0.00% 0.00% 0.00%
September 5.57% 16.49% 5.00% 0.00% 0.00% 0.00%
October -3.45% 15.32% 34.07% 0.00% 0.00% 0.00%
November 1.80% -8.63% -40.56% 0.00% 0.00% 0.00%
December 55.50% -16.68% -3.89% 0.00% 0.00% 0.00%
2008 January -9.53% 0.12% 2.73% 0.00% 0.00% 0.00%
February -6.87% -3.89% 16.72% 0.00% 0.00% 0.00%
March 64.58% 36.59% 10.88% 0.00% 0.00% 0.00%
April -0.60% 23.29% 1.55% 0.00% 0.00% 0.00%
May -4.56% 17.09% -3.73% 0.00% 0.00% 0.00%
June -16.77% -12.07% 7.08% 0.00% 0.00% 0.00%
July 0.35% -15.02% 1.79% 0.00% 0.00% 0.00%
August 1.13% -1.90% 14.89% 0.00% 0.00% 0.00%
September -1.51% 10.02% 2.69% 0.00% 0.00% 0.00%
October 0.38% -1.77% 3.05% 0.00% 0.00% 0.00%
November -31.27% -21.46% -35.00% 0.00% 0.00% 0.00%
December 16.26% 12.29% 30.02% 0.00% 0.00% 0.00%
2009 January 33.79% 6.33% 8.40% 0.00% 0.00% 0.00%
February 50.63% 7.81% -1.69% 0.00% 0.00% 0.00%
March 50.87% 14.04% 26.58% 0.00% 0.00% 0.00%
April -23.76% -15.76% -13.00% 0.00% 0.00% 0.00%
May 18.58% 9.48% 3.61% 6.76% 1.76% 0.67% 1.26%
June 5.07% -7.48% 7.46% 5.25% -0.38% 0.38% 0.27%
July -1.47% 4.23% -1.98% 10.73% -0.06% 0.03% -0.16%
August 8.05% 18.71% 0.15% 74.62% 1.51% 0.01% 6.01%
September 17.09% 18.36% 7.50% -111.35% 3.14% 1.28% -19.03%
October 21.87% -16.55% 9.26% 80.61% -3.62% 2.03% 17.63%
November 28.98% -0.87% -0.71% -11.83% -0.25% -0.21% -3.43%
December 1.63% -21.56% -8.80% -13.93% -0.35% -0.14% -0.23%
2010 January -1.80% 20.58% 9.16% 14.60% -0.37% -0.16% -0.26%
February 7.54% -18.16% -7.02% -22.25% -1.37% -0.53% -1.68%
March -0.43% 6.58% 0.86% 2.11% -0.03% 0.00% -0.01%
April 23.33% 0.62% 12.01% -0.97% 0.15% 2.80% -0.23%
May -16.14% -13.43% -3.81% -18.72% 2.17% 0.61% 3.02%
June 3.57% -24.57% -6.31% -0.14% -0.88% -0.23% 0.00%
July 18.34% 18.16% 5.55% 6.96% 3.33% 1.02% 1.28%
August 30.06% 15.75% 5.18% 12.82% 4.73% 1.56% 3.85%
September -45.01% 17.64% -4.50% 2.93% -7.94% 2.03% -1.32%
October 41.17% 12.11% -2.67% 0.91% 4.99% -1.10% 0.38%
November 15.11% 35.99% 7.34% -19.26% 5.44% 1.11% -2.91%
December -3.13% -33.59% -14.45% -9.30% 1.05% 0.45% 0.29%
2011 January -6.24% -8.21% -10.35% -10.84% 0.51% 0.65% 0.68%
February -33.45% -59.23% -36.96% -47.64% 19.81% 12.36% 15.94%
March 1.63% 72.89% 36.32% 46.98% 1.19% 0.59% 0.77%
April -1.36% -5.77% -4.05% -9.86% 0.08% 0.05% 0.13%
May -0.71% -8.83% -9.23% -8.72% 0.06% 0.07% 0.06%
June -45.96% -6.82% 3.74% -4.11% 3.13% -1.72% 1.89%
July -2.46% 3.77% 3.49% 11.11% -0.09% -0.09% -0.27%
August -3.52% 8.83% -5.85% -12.60% -0.31% 0.21% 0.44%
September -12.92% 21.98% -0.16% -11.17% -2.84% 0.02% 1.44%
October -24.44% -63.19% -18.01% -37.56% 15.45% 4.40% 9.18%
November 5.80% 16.57% -2.15% 28.84% 0.96% -0.12% 1.67%
December 0.28% -194.65% 6.69% -13.59% -0.55% 0.02% -0.04%
2012 January -33.77% -11.11% -24.63% -25.96% 3.75% 8.32% 8.77%
February 18.94% -0.49% 6.27% 12.65% -0.09% 1.19% 2.40%
March 7.28% 1.51% 9.59% 0.54% 0.11% 0.70% 0.04%
April 11.09% -16.58% -1.50% -2.07% -1.84% -0.17% -0.23%
May -29.38% -11.77% -7.62% -11.45% 3.46% 2.24% 3.36%
June -8.93% 1.31% 3.76% -0.82% -0.12% -0.34% 0.07%
July -12.46% -18.36% -5.76% -12.91% 2.29% 0.72% 1.61%
August 10.69% 13.38% 3.60% 12.25% 1.43% 0.38% 1.31%
September 11.22% 15.60% 7.64% 25.18% 1.75% 0.86% 2.83%
October -16.26% -14.87% -5.06% 2.68% 2.42% 0.82% -0.44%
November -5.22% -2.06% -8.31% -28.85% 0.11% 0.43% 1.50%
December -2.26% -16.12% -3.15% -6.42% 0.36% 0.07% 0.15%
1
2
1
2
3
4
Excess return BD Autocars Risk free rate Excess return AMCL PRAN Risk free rate Excess return
0.25% 0.25%
-0.0915927 0.25% -9.41% 0.003529831 0.25% 0.10%
-0.17824823 0.25% -18.07% -0.04984781 0.25% -5.23%
0.417586469 0.25% 41.51% 0.091261591 0.25% 8.88%
0.027724548 0.25% 2.52% 0.050752242 0.25% 4.83%
-0.06453852 0.25% -6.70% 0.123763404 0.25% 12.13%
-0.03390155 0.25% -3.64% -0.09775496 0.25% -10.03%
-0.13846967 0.25% -14.10% 0.00437364 0.25% 0.19%
0.159792444 0.25% 15.73% -0.00688148 0.25% -0.94%
-0.04311012 0.25% -4.56% 0.021733237 0.25% 1.92%
0.154779809 0.25% 15.23% 0.024872377 0.25% 2.24%
-0.13299245 0.25% -13.55% 0.019579385 0.25% 1.71%
0.050430854 0.25% 4.79% -0.02800302 0.25% -3.05%
-0.03758271 0.25% -4.01% -0.01952472 0.25% -2.20%
-0.02586351 0.25% -2.84% -0.02875198 0.25% -3.13%
-0.09138775 0.25% -9.39% 0.160741828 0.25% 15.82%
0.138304671 0.25% 13.58% -0.02515168 0.25% -2.77%
0 0.25% -0.25% 0.180843906 0.25% 17.83%
-0.02531781 0.25% -2.78% 0.02419657 0.25% 2.17%
0.00851069 0.25% 0.60% 0.024065332 0.25% 2.16%
0.199128675 0.25% 19.66% 0.246901358 0.25% 24.44%
-0.26389321 0.25% -26.64% -0.13456392 0.25% -13.71%
-0.01916992 0.25% -2.17% -0.023896 0.25% -2.64%
-0.11720716 0.25% -11.97% -0.04746094 0.25% -5.00%
0.040614719 0.25% 3.81% -0.15316497 0.25% -15.57%
-0.01503788 0.25% -1.75% -0.00840965 0.25% -1.09%
-0.08426034 0.25% -8.68% 0.030816819 0.25% 2.83%
-0.05071509 0.25% -5.32% -0.10290154 0.25% -10.54%
0.050715093 0.25% 4.82% 0.091760715 0.25% 8.93%
-0.04495139 0.25% -4.75% 0.002432499 0.25% -0.01%
-0.10919929 0.25% -11.17% -0.12234884 0.25% -12.48%
0.043894194 0.25% 4.14% 0.077123739 0.25% 7.46%
-0.01857639 0.25% -2.11% 0.049588741 0.25% 4.71%
0.055907632 0.25% 5.34% -0.09376324 0.25% -9.63%
-0.10720093 0.25% -10.97% -0.08305823 0.25% -8.56%
-0.0822381 0.25% -8.47% -0.07739994 0.25% -7.99%
0.158224005 0.25% 15.57% -0.02399105 0.25% -2.65%
0.178248231 0.25% 17.57% -0.03313067 0.25% -3.56%
0.312872321 0.25% 31.04% -0.00330798 0.25% -0.58%
-0.12715518 0.25% -12.97% -0.01401424 0.25% -1.65%
-0.02141409 0.25% -2.39% 0.013351333 0.25% 1.09%
-0.10487963 0.25% -10.74% 0.023592182 0.25% 2.11%
-0.10642946 0.25% -10.89% 0.041236416 0.25% 3.87%
0.153386446 0.25% 15.09% 0.040200297 0.25% 3.77%
-0.06637507 0.25% -6.89% -0.01685771 0.25% -1.94%
0.142316222 0.25% 13.98% 0.007862151 0.25% 0.54%
-0.22399425 0.25% -22.65% -0.05765464 0.25% -6.02%
0.143455391 0.25% 14.10% -0.07553258 0.25% -7.80%
0.040637646 0.25% 3.81% 0.088844978 0.25% 8.63%
0.210676783 0.25% 20.82% -0.01586831 0.25% -1.84%
-0.09782229 0.25% -10.03% 0.003831422 0.25% 0.13%
0.023438573 0.25% 2.09% 0 0.25% -0.25%
-0.07203113 0.25% -7.45% -0.00960622 0.25% -1.21%
0.056466612 0.25% 5.40% 0.029796182 0.25% 2.73%
0.064538521 0.25% 6.20% 0.29297721 0.25% 29.05%
0.060624622 0.25% 5.81% -0.02787802 0.25% -3.04%
0.050601013 0.25% 4.81% 0.175349537 0.25% 17.28%
-0.0395892 0.25% -4.21% 0.163583903 0.25% 16.11%
0.012920955 0.25% 1.04% -0.07586911 0.25% -7.84%
0.549916391 0.25% 54.74% -0.15636307 0.25% -15.89%
-0.10039129 0.25% -10.29% 0.011560822 0.25% 0.91%
-0.07377646 0.25% -7.63% -0.02849934 0.25% -3.10%
0.640754246 0.25% 63.83% 0.376280013 0.25% 37.38%
-0.01106342 0.25% -1.36% 0.243264475 0.25% 24.08%
-0.05070795 0.25% -5.32% 0.181260173 0.25% 17.88%
-0.17274468 0.25% -17.52% -0.11028906 0.25% -11.28%
-0.00154679 0.25% -0.40% -0.13976194 0.25% -14.23%
0.006172859 0.25% 0.37% -0.00862293 0.25% -1.11%
-0.02020271 0.25% -2.27% 0.11056853 0.25% 10.81%
-0.00125668 0.25% -0.38% -0.00732436 0.25% -0.98%
-0.31778593 0.25% -32.03% -0.20419939 0.25% -20.67%
0.157538947 0.25% 15.50% 0.133284814 0.25% 13.08%
0.332775375 0.25% 33.03% 0.073667502 0.25% 7.12%
0.501256173 0.25% 49.88% 0.08851845 0.25% 8.60%
0.503587956 0.25% 50.11% 0.150759981 0.25% 14.83%
-0.24270408 0.25% -24.52% -0.14720163 0.25% -14.97%
16.70% 0.089682703 0.25% 8.72% 0.04653901 0.25% 4.40%
3.19% -0.07985461 0.25% -8.24% 0.085031623 0.25% 8.25%
-3.34% 0.03719685 0.25% 3.47% -0.00938628 0.25% -1.19%
6.17% 0.182027049 0.25% 17.95% 0.011947573 0.25% 0.94%
15.22% 0.178468619 0.25% 17.60% 0.08541134 0.25% 8.29%
20.00% -0.1705472 0.25% -17.30% 0.103042784 0.25% 10.05%
27.11% -0.01382985 0.25% -1.63% 0.003323768 0.25% 0.08%
-0.25% -0.22067746 0.25% -22.32% -0.07759473 0.25% -8.01%
-3.68% 0.200726672 0.25% 19.82% 0.102029792 0.25% 9.95%
5.66% -0.18666346 0.25% -18.92% -0.05974188 0.25% -6.22%
-2.31% 0.060660337 0.25% 5.82% 0.019036402 0.25% 1.65%
21.45% 0.001142205 0.25% -0.14% 0.130460609 0.25% 12.80%
-18.02% -0.13941954 0.25% -14.19% -0.02769429 0.25% -3.02%
1.69% -0.25075216 0.25% -25.33% -0.05268486 0.25% -5.52%
16.46% 0.176543231 0.25% 17.40% 0.065877301 0.25% 6.34%
28.18% 0.1524329 0.25% 14.99% 0.062189348 0.25% 5.97%
-46.89% 0.17133914 0.25% 16.88% -0.03458746 0.25% -3.71%
39.29% 0.116009139 0.25% 11.35% -0.01633454 0.25% -1.88%
13.23% 0.354761068 0.25% 35.23% 0.083856658 0.25% 8.14%
-5.01% -0.34101639 0.25% -34.35% -0.13409901 0.25% -13.66%
-8.12% -0.0872155 0.25% -8.97% -0.0930558 0.25% -9.56%
-35.33% -0.59743621 0.25% -59.99% -0.35919297 0.25% -36.17%
-0.25% 0.723837884 0.25% 72.13% 0.373577253 0.25% 37.11%
-3.23% -0.0628129 0.25% -6.53% -0.03008566 0.25% -3.26%
-2.59% -0.0934269 0.25% -9.59% -0.08191712 0.25% -8.44%
-47.84% -0.07329287 0.25% -7.58% 0.047791809 0.25% 4.53%
-4.34% 0.032597062 0.25% 3.01% 0.045298614 0.25% 4.28%
-5.39% 0.083192317 0.25% 8.07% -0.04808619 0.25% -5.06%
-14.80% 0.214689923 0.25% 21.22% 0.008827914 0.25% 0.63%
-26.32% -0.63698675 0.25% -63.95% -0.16970615 0.25% -17.22%
3.92% 0.160561295 0.25% 15.81% -0.01105412 0.25% -1.36%
-1.60% -1.95158303 0.25% -195.41% 0.077278781 0.25% 7.48%
-35.65% -0.11623556 0.25% -11.87% -0.23585944 0.25% -23.84%
17.06% -0.00999009 0.25% -1.25% 0.073128124 0.25% 7.06%
5.40% 0.009990093 0.25% 0.75% 0.106294659 0.25% 10.38%
9.21% -0.17085671 0.25% -17.34% -0.00459419 0.25% -0.71%
-31.26% -0.12280743 0.25% -12.53% -0.06581844 0.25% -6.83%
-10.81% 0.00796817 0.25% 0.55% 0.048009219 0.25% 4.55%
-14.34% -0.18869101 0.25% -19.12% -0.04718988 0.25% -4.97%
8.81% 0.12872754 0.25% 12.62% 0.046408327 0.25% 4.39%
9.34% 0.150935243 0.25% 14.84% 0.086815893 0.25% 8.43%
-18.14% -0.15374818 0.25% -15.62% -0.0402248 0.25% -4.27%
-7.09% -0.02567901 0.25% -2.82% -0.07273119 0.25% -7.52%
-4.14% -0.16626617 0.25% -16.88% -0.02108756 0.25% -2.36%
1
2
1
2
3
4
BDCOM Risk free rate Excess return
0.25%
-0.02353 0.25% -2.60%
-0.100083 0.25% -10.26%
0.075986 0.25% 7.35%
0.136576 0.25% 13.41%
0.027974 0.25% 2.55%
-0.086385 0.25% -8.89%
-0.154151 0.25% -15.67%
-0.072759 0.25% -7.53%
0.172843 0.25% 17.03%
0.098192 0.25% 9.57%
-0.114192 0.25% -11.67%
-0.024491 0.25% -2.70%
-0.016667 0.25% -1.92%
-0.01695 0.25% -1.94%
0 0.25% -0.25%
0.058108 0.25% 5.56%
0.039531 0.25% 3.70%
0 0.25% -0.25%
0.045462 0.25% 4.30%
0.118606 0.25% 11.61%
0.082065 0.25% 7.96%
-0.06252 0.25% -6.50%
0.493909 0.25% 49.14%
-0.171358 0.25% -17.39%
0.143412 0.25% 14.09%
-0.05835 0.25% -6.08%
0.017022 0.25% 1.45%
0.025001 0.25% 2.25%
-0.054982 0.25% -5.75%
-0.302281 0.25% -30.48%
0.157506 0.25% 15.50%
0.014963 0.25% 1.25%
0.019608 0.25% 1.71%
0.070287 0.25% 6.78%
-0.177807 0.25% -18.03%
0.005391 0.25% 0.29%
-0.084083 0.25% -8.66%
0.126195 0.25% 12.37%
-0.103072 0.25% -10.56%
-0.017291 0.25% -1.98%
-0.06609 0.25% -6.86%
0.006192 0.25% 0.37%
0.048202 0.25% 4.57%
-0.042048 0.25% -4.45%
-0.188475 0.25% -19.10%
-0.151685 0.25% -15.42%
0.136759 0.25% 13.43%
0.126931 0.25% 12.44%
0.24541 0.25% 24.29%
-0.212834 0.25% -21.53%
0.062132 0.25% 5.96%
0.108368 0.25% 10.59%
0.021391 0.25% 1.89%
0.196332 0.25% 19.38%
-0.134774 0.25% -13.73%
0.053281 0.25% 5.08%
0.343991 0.25% 34.15%
-0.40226 0.25% -40.48%
-0.035627 0.25% -3.81%
0.030615 0.25% 2.81%
0.170527 0.25% 16.80%
0.112117 0.25% 10.96%
0.018762 0.25% 1.63%
-0.03403 0.25% -3.65%
0.074108 0.25% 7.16%
0.021202 0.25% 1.87%
0.152151 0.25% 14.97%
0.030171 0.25% 2.77%
0.033804 0.25% 3.13%
-0.346665 0.25% -34.92%
0.303493 0.25% 30.10%
0.087256 0.25% 8.48%
-0.013569 0.25% -1.61%
0.269067 0.25% 26.66%
-0.126695 0.25% -12.92%
0.070887 0.25% 6.84%
0.055808 0.25% 5.33%
0.110566 0.25% 10.81%
0.749475 0.25% 74.70%
-1.110163 0.25% -111.27%
0.80944 0.25% 80.69%
-0.114953 0.25% -11.75%
-0.136021 0.25% -13.85%
0.149319 0.25% 14.68%
-0.219188 0.25% -22.17%
0.024372 0.25% 2.19%
-0.006441 0.25% -0.89%
-0.183938 0.25% -18.64%
0.00194 0.25% -0.06%
0.072861 0.25% 7.04%
0.131502 0.25% 12.90%
0.032637 0.25% 3.01%
0.01243 0.25% 0.99%
-0.189262 0.25% -19.18%
-0.089669 0.25% -9.22%
-0.105139 0.25% -10.76%
-0.473113 0.25% -47.56%
0.473113 0.25% 47.06%
-0.09531 0.25% -9.78%
-0.083912 0.25% -8.64%
-0.037842 0.25% -4.03%
0.11441 0.25% 11.19%
-0.122709 0.25% -12.52%
-0.108452 0.25% -11.10%
-0.372276 0.25% -37.48%
0.291717 0.25% 28.92%
-0.132573 0.25% -13.51%
-0.256253 0.25% -25.88%
0.129812 0.25% 12.73%
0.008658 0.25% 0.62%
-0.017392 0.25% -1.99%
-0.111226 0.25% -11.37%
-0.004914 0.25% -0.74%
-0.12582 0.25% -12.83%
0.12582 0.25% 12.33%
0.255139 0.25% 25.26%
0.030077 0.25% 2.76%
-0.285216 0.25% -28.77%
-0.060933 0.25% -6.34%
SUMMARY OUTPUT
Regression Statistics
Multiple R 0.529428
R Square 0.280294
Adjusted R 0.263158
Standard E 0.163134
Observatio 44
ANOVA
df SS MS F Significance F
Regression 1 0.435305 0.435305 16.35713 0.00022
Residual 42 1.117728 0.026613
Total 43 1.553033
Coefficients
Standard Error t Stat P-value Lower 95%Upper 95%Lower 95.0%
Upper 95.0%
Intercept -0.027347 0.024684 -1.107857 0.274228 -0.077161 0.022468 -0.077161 0.022468
X Variable 0.961166 0.237654 4.044395 0.00022 0.481561 1.440771 0.481561 1.440771
SUMMARY OUTPUT
Regression Statistics
Multiple R 0.307238
R Square 0.094395
Adjusted R 0.086655
Standard E 0.256646
Observatio 119
ANOVA
df SS MS F Significance F
Regression 1 0.803279 0.803279 12.19543 0.000677
Residual 117 7.706463 0.065867
Total 118 8.509742
Coefficients
Standard Error t Stat P-value Lower 95%Upper 95%Lower 95.0%
Upper 95.0%
Intercept -0.018838 0.023746 -0.793291 0.429214 -0.065865 0.02819 -0.065865 0.02819
X Variable 0.987081 0.282653 3.492196 0.000677 0.427301 1.546862 0.427301 1.546862
SUMMARY OUTPUT
Regression Statistics
Multiple R 0.592368
R Square 0.350899
Adjusted R 0.345351
Standard E 0.087564
Observatio 119
ANOVA
df SS MS F Significance F
Regression 1 0.484959 0.484959 63.24939 1.283E-12
Residual 117 0.897088 0.007667
Total 118 1.382047
Coefficients
Standard Error t Stat P-value Lower 95%Upper 95%Lower 95.0%
Upper 95.0%
Intercept -0.000829 0.008102 -0.10234 0.918662 -0.016874 0.015216 -0.016874 0.015216
X Variable 0.766959 0.096437 7.952949 1.283E-12 0.575971 0.957948 0.575971 0.957948
SUMMARY OUTPUT
Regression Statistics
Multiple R 0.371336
R Square 0.137891
Adjusted R 0.130522
Standard E 0.197665
Observatio 119
ANOVA
df SS MS F Significance F
Regression 1 0.731169 0.731169 18.71364 3.215E-05
Residual 117 4.571357 0.039071
Total 118 5.302526
Coefficients
Standard Error t Stat P-value Lower 95%Upper 95%Lower 95.0%
Upper 95.0%
Intercept -0.009932 0.018289 -0.543058 0.588123 -0.046152 0.026288 -0.046152 0.026288
X Variable 0.941734 0.217695 4.325926 3.215E-05 0.5106 1.372869 0.5106 1.372869
CAPM
1
2
3
4
1
2
3
4
Minimum Variance portfolio with short sale allowed
Highe
No short sale is needed investm
AMCL PRAN BDCOM
0.889152964 0.0540509
Covariance Covariance
0.009835012 0.01317908 weight
0.010702549 0.01550704 0.053153
0.01161384 0.00924622 0.003643
0.009246222 0.04455904 0.889153
0.054051 1
2
3
4
Weights
Highest
investment
Minimum variance portfolio without short sale
Company name Bay leasing BD Autocars AMCL PRAN
Weight 0.05321344 0.0036247 0.8890838735
Company name Return Risk free rate Excess return Covariance Covariance Covariance
Bay leasing -0.016286 0.0025 -0.018786257363 0.03529621 0.01455617 0.0098350118
BD Autocars -0.005091 0.0025 -0.007590970466 0.01455617 0.07151044 0.0107025488
AMCL PRAN 0.010409 0.0025 0.007909434054 0.00983501 0.01070255 0.0116138397
BDCOM 0.003298 0.0025 0.000797991796 0.01317908 0.01550704 0.0092462217
1
2
3
4
Optimal risky portfolio with maximum theta
All
investment
in AMCL
PRAN
Optimal risky portfolio with given return
1
2
3
4
Weights