20 Selected Securities For Portfolio Construction: Industry Company Name Fuel & Power
20 Selected Securities For Portfolio Construction: Industry Company Name Fuel & Power
20 Selected Securities For Portfolio Construction: Industry Company Name Fuel & Power
HEIDELBCEM
531
520
493
499
491
504
450
463
506
570
635
603
640
604
566
562
550
541
501
525
537
522
550
534.9
542.3
544.8
549.5
552.3
550.6
552.2
517.1
479.5
447.3
449
454.6
428.4
428.6
407.6
408.8
424.9
408.7
390.5
376.4
375.9
343
360.6
351.4
345.2
346.2
345.3
337.9
334.7
349.9
352.5
344
247
239.5
242.2
193.8
208.5
197.9
Stock Number 1 2 3 4
Industry Name
Year Month ISLAMIBANKEBL BRACBANK DAFODILCOM
2014 September
October
November
December
2015 January
February
March 20%
April 15% 20%
May
June
July
August
September
October
November 12%
December
2016 January
February
March
April 20%
May 10% 25%
June
July
August
September
October
November 15%
December
2017 January
February
March
April 10% 10%
May 20%
June
July
August
September
October
November 18%
December
2018 January
February
March
April
May 10% 20%
June
July
August
September
October
November 12%
2019 December
January
February
March
April
May 10%
June 20%
July
August
September
5 6 7 8 9
45% 32%
5% 10%
20%
35% 32%
20% 15%
30% 32%
30%
30% 32%
7.50%
20%
30%
32%
7% 15%
30%
10 11 12 13 14 15
20%
15%
110%
100%
20%
200%
15%
30%
15%
110%
115%
18%
200%
20%
40%
75% 15%
110%
20%
200%
25%
375%
26%
16 17 18 19 20
175%
65%
380%
80% 105%
80%
30%
215%
60%
300%
85% 105%
40%
225%
40% 90%
300%
105%
105%
90% 35%
230%
100%
335% 150%
95% 36%
280%
345% 75%
90%
Stock Number 1 2 3
Industry Name
Year Month ISLAMIBANK EBL BRACBANK
2014 September
October
November
December
2015 January
February
March
April
May
June 15%
July
August
September
October
November
December
2016 January
February
March
April
May
June 5%
July
August
September
October
November
December
2017 January
February
March
April 20%
May
June
July
August
September
October
November
December
2018 January
February
March
April 25%
May
June
July
August
September
October
November
2019 December
January
February
March
April 15%
May
June 10
July
August
September
4 5 6 7 8
10% 10%
20% 15%
20%
5%
20%
7.50%
5%
8%
9 10 11 12 13
35%
20%
50%
5%
125%
15%
14 15 16 17 18
15% 20%
12.5%
10% 15%
10%
10%
7.5%
10%
3.50% 15% 7%
19 20
GP HEIDELBCEM
Stock Number 1 2 3 4
Industry Name
Year Month ISLAMIBANK EBL BRACBANK DAFODILCOM
2014 September
October
November
December
2015 January
February
March
April
May
June
July
August
September
October
November
December
2016 January
February
March
April
May
June
July
August
September
October
November
December
2017 January
February
March
April
May
June
July
August
September
October
November
December
2018 January
February
March
April
May
June
July
August
September
October
November
2019 December
January
February
March
April
May
June
July
August
September
5 6 7 8 9
50.00%
Stock Number 1 2 3 4
Industry Name
Year Month ISLAMIBANK EBL BRACBANK DAFODILCOM
2014 September
October
November
December
2015 January
February
March
April
May
June
July
August
September
October
November
December
2016 January
February
March
April
May
June
July
August
September
October
November
December
2017 January
February
March
April
May
June
July
August
September
October
November
December
2018 January
February
March
April
May
June
July
August
September
October
November
2019 December
January
February
March
April
May
June
July
August
September
5 6 7 8 9
20.00
Stock Number 1 2 3 4
Industry Name
Year Month ISLAMIBANK EBL BRACBANK DAFODILCOM
2014 September 1 1 1 1
October 1 1 1 1
November 1 1 1 1
December 1 1 1 1
2015 January 1 1 1 1
February 1 1 1 1
March 1 1 1 1
April 1 1 1 1
May 1 1 1 1
June 1 1 1 1
July 1 1 1 1
August 1 1 1 1
September 1 1 1 1
October 1 1 1 1
November 1 1 1 1
December 1 1 1 1
2016 January 1 1 1 1
February 1 1 1 1
March 1 1 1 1
April 1 1 1 1
May 1 1 1 1
June 1 1 1 1
July 1 1 1 1
August 1 1 1 1
September 1 1 1 1
October 1 1 1 1
November 1 1 1 1
December 1 1 1 1
2017 January 1 1 1 1
February 1 1 1 1
March 1 1 1 1
April 1 1 1 1
May 1 1 1 1
June 1 1 1 1
July 1 1 1 1
August 1 1 1 1
September 1 1 1 1
October 1 1 1 1
November 1 1 1 1
December 1 1 1 1
2018 January 1 1 1 1
February 1 1 1 1
March 1 1 1 1
April 1 1 1 1
May 1 1 1 1
June 1 1 1 1
July 1 1 1 1
August 1 1 1 1
September 1 1 1 1
October 1 1 1 1
November 1 1 1 1
2019 December 1 1 1 1
January 1 1 1 1
February 1 1 1 1
March 1 1 1 1
April 1 1 1 1
May 1 1 1 1
June 1 1 1 1
July 1 1 1 1
August 1 1 1 1
September 1 1 1 1
5 6 7 8 9
HEIDELBCEM
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
Stock Number 1 2 3 4 5
Industry Name
Year Month ISLAMIBANKEBL BRACBANK DAFODILCOM BDLAMPS
2014 September
October 0.00% 0.00% 0.00% 0.00% 0.00%
November 0.00% 0.00% 0.00% 0.00% 0.00%
December 0.00% 0.00% 0.00% 0.00% 0.00%
2015 January 0.00% 0.00% 0.00% 0.00% 0.00%
February 0.00% 0.00% 0.00% 0.00% 0.00%
March 0.00% 0.00% 0.87% 0.00% 0.00%
April 0.94% 0.90% 0.00% 0.00% 0.19%
May 0.00% 0.00% 0.00% 0.00% 0.00%
June 0.00% 0.00% 0.00% 0.00% 0.00%
July 0.00% 0.00% 0.00% 0.00% 0.00%
August 0.00% 0.00% 0.00% 0.00% 0.00%
September 0.00% 0.00% 0.00% 0.00% 0.00%
October 0.00% 0.00% 0.00% 0.00% 0.00%
November 0.00% 0.00% 0.00% 0.67% 0.00%
December 0.00% 0.00% 0.00% 0.00% 0.00%
2016 January 0.00% 0.00% 0.00% 0.00% 0.00%
February 0.00% 0.00% 0.00% 0.00% 0.00%
March 0.00% 0.00% 0.00% 0.00% 0.11%
April 0.00% 0.83% 0.00% 0.00% 0.00%
May 0.38% 0.00% 0.81% 0.00% 0.00%
June 0.00% 0.00% 0.00% 0.00% 0.00%
July 0.00% 0.00% 0.00% 0.00% 0.00%
August 0.00% 0.00% 0.00% 0.00% 0.00%
September 0.00% 0.00% 0.00% 0.00% 0.00%
October 0.00% 0.00% 0.00% 0.00% 0.00%
November 0.00% 0.00% 0.00% 0.45% 0.00%
December 0.00% 0.00% 0.00% 0.00% 0.00%
2017 January 0.00% 0.00% 0.00% 0.00% 0.00%
February 0.00% 0.00% 0.00% 0.00% 0.00%
March 0.00% 0.00% 0.00% 0.00% 0.00%
April 0.31% 0.00% 0.17% 0.00% 0.00%
May 0.00% 0.63% 0.00% 0.00% 0.00%
June 0.00% 0.00% 0.00% 0.00% 0.00%
July 0.00% 0.00% 0.00% 0.00% 0.00%
August 0.00% 0.00% 0.00% 0.00% 0.17%
September 0.00% 0.00% 0.00% 0.00% 0.00%
October 0.00% 0.00% 0.00% 0.00% 0.00%
November 0.00% 0.00% 0.00% 0.38% 0.00%
December 0.00% 0.00% 0.00% 0.00% 0.00%
2018 January 0.00% 0.00% 0.00% 0.00% 0.00%
February 0.00% 0.00% 0.00% 0.00% 0.00%
March 0.00% 0.00% 0.00% 0.00% 0.00%
April 0.00% 0.00% 0.00% 0.00% 0.00%
May 0.43% 0.56% 0.00% 0.00% 0.00%
June 0.00% 0.00% 0.00% 0.00% 0.00%
July 0.00% 0.00% 0.00% 0.00% 0.00%
August 0.00% 0.00% 0.00% 0.00% 0.00%
September 0.00% 0.00% 0.00% 0.00% 0.00%
October 0.00% 0.00% 0.00% 0.00% 0.09%
November 0.00% 0.00% 0.00% 0.34% 0.00%
2019 December 0.00% 0.00% 0.00% 0.00% 0.00%
January 0.00% 0.00% 0.00% 0.00% 0.00%
February 0.00% 0.00% 0.00% 0.00% 0.00%
March 0.00% 0.00% 0.00% 0.00% 0.00%
April 0.00% 0.00% 0.00% 0.00% 0.00%
May 0.40% 0.00% 0.00% 0.00% 0.00%
June 0.00% 0.53% 0.00% 0.00% 0.00%
July 0.00% 0.00% 0.00% 0.00% 0.00%
August 0.00% 0.00% 0.00% 0.00% 0.16%
September 0.00% 0.00% 0.00% 0.00% 0.00%
6 7 8 9 10
Total Weight 1
Total Weight 1
1. Portfolio Return 2%
Company Name Mean Return Weight
ISLAMIBANK 0.42% 0.0306869355972
EBL 18.07% 0.0056525933163
BRACBANK 3.15% 0.0755768167857
DAFODILCOM 2.96% 0.2060966330732
BDLAMPS 1.38% 0.0783380551832
IPDC 11.50% 0.0158752913925
ICB 0.01% 0
LANKABAFIN 0.89% 0
AMCL 0.08% 0
GEMINISEA 6.38% 0.0466786302885
OLYMPIC 1.93% 0.0442219842403
LINDEBD 1.07% 0.1474014826627
DELTALIFE -0.87% 0
ACI 0.68% 0
ORIONPHARM -0.77% 0
RENATA 1.87% 3.1822822404E-05
SQURPHARMA 0.67% 0.144571798783
BATASHOE 0.53% 0.2048679558551
GP 0.12% 0
HEIDELBCEM -1.37% 0
Total Weight 1
return 2%
Monthly risk free rate 0.0075
Portfolio Retrun 2.00%
Portfolio Variance 0.11%
Portfolio standard dev 3.29%
Sharpe Ratio or Slope 38.03%
ORIONPHARM RENATA SQURPHARMA BATASHOE GP
0.002766782320645 0.002665999 0.00242439148 0.00016567907835 0.001238439701333
-0.001547274516387 0.0004428547 0.00552550846 0.00524763916038 0.004870075134225
0.000325348355155 0.0008646857 0.00092803957 -6.637705644E-05 0.001211644627982
0.001218935189403 0.001335198 0.00131263601 0.00011281779144 0.000821062084547
0.002311794630369 0.0030016215 0.00150750958 0.00170934416256 0.000754292127556
0.000215370092725 -0.0022194786 -0.0037414469 -0.0048946383139 -0.007957806975113
0.003698761950806 0.0025011879 0.00197650943 0.00017591545666 0.001482892233826
0.005688154353579 0.0007516763 0.00137062021 -0.0011591497268 0.002058748232146
0.001784398174433 0.0010676935 0.00131499866 -0.000163321831 0.000681453337128
-0.001276827433958 0.0011396158 0.00257029688 0.00077665479545 -9.581835457195E-05
-2.078772895841E-05 0.0012897558 0.0007675129 -0.0005605284701 -0.000136624030284
0.001196774664286 0.0025847906 0.00095036661 0.00040688316362 0.000351319550043
0.002951289012214 0.0008524466 0.00096829614 -0.0003987204587 0.001523653335189
0.002546665406314 0.0020723376 0.00013345986 0.00155938790211 0.000982480695622
0.066298010262731 0.0016875996 0.00126348775 -0.0002687848077 0.000904216282316
0.001687599619081 0.0196094619 0.00174815034 0.00073917869146 0.000885931389487
0.001263487749724 0.0017481503 0.00515555878 0.00045099539339 0.001302010147068
-0.000268784807676 0.0007391787 0.00045099539 0.001877152547 0.000265238069557
0.000904216282316 0.0008859314 0.00130201015 0.00026523806956 0.00419086216781
0.001142484151872 0.0015985781 0.0007796129 0.00181026205036 0.001160847514417
1 Total Weight 1
Monthly risk free rate 0.75% Monthly risk free rate 0.75%
Portfolio Retrun 4.00% Portfolio Retrun 4.50%
Portfolio Variance 0.24% Portfolio Variance 0.31%
Portfolio standard deviat 4.93% Portfolio standard devia 5.55%
Sharpe Ratio or Slope 65.87% Sharpe Ratio or Slope 67.52%
turn 4.5% 7. Portfolio Return 5%
Weight Company Name Mean Return Weight
0 ISLAMIBANK 0.42% 0
0.0236897 EBL 18.07% 0.0324768
0.4558013 BRACBANK 3.15% 0.4055787
0.2827009 DAFODILCOM 2.96% 0.2571759
0 BDLAMPS 1.38% 0
0.0645229 IPDC 11.50% 0.0845672
0 ICB 0.01% 0
0 LANKABAFIN 0.89% 0
0 AMCL 0.08% 0
0.1631269 GEMINISEA 6.38% 0.2202015
0.0101583 OLYMPIC 1.93% 0
0 LINDEBD 1.07% 0
0 DELTALIFE -0.87% 0
0 ACI 0.68% 0
0 ORIONPHARM -0.77% 0
0 RENATA 1.87% 0
0 SQURPHARMA 0.67% 0
0 BATASHOE 0.53% 0
0 GP 0.12% 0
0 HEIDELBCEM -1.37% 0
1 Total Weight 1
1 Total Weight 1
Expected Return
4.31% 3.50% 4.00%
4.93% 4.00%
3.00%
5.55% 4.50%
5.37% 5.00% 2.00%
5.31% 5.50%
5.48% 6.00% 1.00%
5.84% 6.50%
0.00%
-1.00% 0.00% 1.00% 2.00% 3.00% 4.00%
Tangency Portfolio 0.00% 0.75%
5.33% 4.29% Risk
isk free Lending and Borrowing Allowed
Risk
ISLAMIBANK EBL
ISLAMIBANK 0.0076488964 -0.006066287488187
EBL -0.006066287 0.007410752800939
BRACBANK 0.0006595661 0.000195370374201
DAFODILCOM 0.0024460731 -0.008046883375959
BDLAMPS 0.0049917148 0.013166210289219
IPDC -0.000429725 -0.060345115259458
ICB 0.008080957 -0.00158999602748
LANKABAFIN 0.005942672 -0.005946562683504
AMCL 0.0030547485 -0.001313505999628
GEMINISEA 0.000855649 -0.003837314147328
OLYMPIC 0.0017529453 0.004766414723729
LINDEBD 0.0017328836 0.004046927966374
DELTALIFE 0.002741232 0.005742384043342
ACI 0.0024103398 0.015462458668017
ORIONPHARM 0.0027667823 -0.001547274516387
RENATA 0.002665999 0.000442854690224
SQURPHARMA 0.0024243915 0.005525508461731
BATASHOE 0.0001656791 0.005247639160381
GP 0.0012384397 0.004870075134225
HEIDELBCEM 0.0021270545 0.004194182812776
Total Weight 1
Total Weight
1 Total Weight
1 Total Weight 1
Monthly risk free rate 0.0067 Monthly risk free rate 0.0075
Portfolio Retrun 0.0600 Portfolio Retrun 0.1000
Portfolio Variance -0.0011 Portfolio Variance -0.0001
Portfolio standard deviation Err:502 Portfolio standard devi Err:502
Sharpe Ratio or Slope Err:502 Sharpe Ratio or Slope Err:502
rf= 5% and PR= 1% Rf= 5%
Company Name Mean ReturWeight Company NMean ReturWeight
ISLAMIBANK 0.0041993 0.1677206 ISLAMIBA0.0041993 0.3086901
EBL 0.1807492 0 EBL 0.1807492 -0.269332
BRACBANK 0.0314594 0.0418502 BRACBAN0.0314594 -0.612928
DAFODILCOM 0.0295779 0.0424127 DAFODIL 0.0295779 0.0665734
BDLAMPS 0.0138357 0.0471191 BDLAMPS 0.0138357 0.0998208
IPDC 0.114988 0.0168783 IPDC 0.114988 -0.101378
ICB 9.086E-05 0.0512283 ICB 9.086E-05 0.2228244
LANKABAFIN 0.0089424 0.048582 LANKABA0.0089424 -0.044977
AMCL 0.0008265 0.0510083 AMCL 0.0008265 -0.030311
GEMINISEA 0.0637616 0.0321931 GEMINISE 0.0637616 0.4219028
OLYMPIC 0.0193498 0.0454706 OLYMPIC 0.0193498 0.1202857
LINDEBD 0.0107133 0.0480526 LINDEBD 0.0107133 0.3197724
DELTALIFE -0.00866 0.0538444 DELTALIF -0.00866 -0.002416
ACI 0.0067737 0.0492304 ACI 0.0067737 0.0915951
ORIONPHARM -0.007726 0.0535653 ORIONPH -0.007726 0.2566965
RENATA 0.0186683 0.0456743 RENATA 0.0186683 -0.091301
SQURPHARMA 0.0066921 0.0492547 SQURPHA 0.0066921 0.1303843
BATASHOE 0.0053028 0.0496701 BATASHO 0.0053028 0.2001751
GP 0.001197 0.0508976 GP 0.001197 0.0214993
HEIDELBCEM -0.013688 0.0553476 HEIDELB -0.013688 -0.107576
Total Weight 1
0.0075
-0.0528
0.0090
0.0948
-0.6366
Efficient Frontier Determination when Short Sale Allowed and Risk-free Lending
and Borrowing NotAllowed
Expected Return
5.00%
-69.98% 4.00%
7.97% 3.00%
11.91% 2.00%
-14.07% 1.00%
0.00%
27.41%
-1.00% 0.00% 1.00% 2.00% 3.00% 4.00% 5.00% 6.00% 7.00% 8.00%
-1.00%
1.34%
-3.02% Risk
50.11%
12.12%
32.45% 0.00%
1.04% Rf 7.00% Err:502
11.17%
19.60% 0.00%
-12.73% Rf 5% Err:502
14.93%
24.98% 0.00%
3.02% Rf 6% Err:502
-18.86%
0.00%
0.75% Rf 8% Err:502
5.95%
0.36% 0.00%
6.01% Rf 9% Err:502
86.63%
0.0041667 0.005 0.0066667 0.0075
0.0509753 0.0527537 0.0569838 0.0595339
0.0025482 0.0027473 0.0032652 0.0036075
0.0504796 0.0524149 0.0571418 0.0600622
0.9272768 0.9110711 0.8805663 0.8663344
orrowing X Axis Y Axis
Risk Return
4.76% 1.00%
Err:502 3.00%
Err:502 4.00%
Err:502 Err:502
Err:502 10.00%
7.00% 8.00%
0.75%
9.76%
0.42%
3.00%
0.50%
4.00%
0.67%
6.00%
0.75%
6.00%
ISLAMIBANK EBL BRACBANK
ISLAMIBANK 0.013881 0.000666 0.002530
EBL 0.000666 1.689597 0.002148
BRACBANK 0.002530 0.002148 0.009143
DAFODILCOM -0.000852 0.001838 0.000938
BDLAMPS 0.001324 -0.001406 0.003789
IPDC 0.000329 -0.000723 0.000789
ICB 0.001808 0.000963 0.004236
LANKABAFIN 0.001062 0.003227 0.001878
AMCL 0.000815 0.004971 0.002407
GEMINISEA 0.000422 0.004010 0.005654
OLYMPIC -0.000202 0.001509 0.002337
LINDEBD 0.000479 0.002636 0.002462
DELTALIFE 0.000018 -0.000505 0.001163
ACI 0.000081 0.003972 0.000884
ORIONPHARM 0.000328 0.001909 0.000758
RENATA 0.000068 0.002616 0.003110
SQURPHARMA 0.001223 0.001249 0.001861
BATASHOE -0.000698 0.002193 0.000178
GP 0.001500 -0.001119 0.002202
HEIDELBCEM 0.001782 -0.000294 0.003582
Total Weight 1
Total Weight 1
1. Portfolio Return 1%
Company Name Mean Return Weight
ISLAMIBANK 0.42% 8.71%
EBL 18.07% 0.00%
BRACBANK 3.15% 4.98%
DAFODILCOM 2.96% 0.00%
BDLAMPS 1.38% 0.00%
IPDC 11.50% 6.15%
ICB 0.01% 0.00%
LANKABAFIN 0.89% 0.00%
AMCL 0.08% 7.55%
GEMINISEA 6.38% 0.00%
OLYMPIC 1.93% 0.58%
LINDEBD 1.07% 0.00%
DELTALIFE -0.87% 0.00%
ACI 0.68% 0.00%
ORIONPHARM -0.77% 41.69%
RENATA 1.87% 1.36%
SQURPHARMA 0.67% 0.00%
BATASHOE 0.53% 0.00%
GP 0.12% 0.00%
HEIDELBCEM -1.37% 28.97%
Total Weight 1
Total Weight 1
Monthly risk free rate 0.75% Monthly risk free rate 0.75%
Portfolio Retrun 1.36% Portfolio Retrun 1.43%
Portfolio Variance 0.39% Portfolio Variance 0.27%
Portfolio standard deviatio 6.21% Portfolio standard devi 5.19%
Sharpe Ratio or Slope 9.89% Sharpe Ratio or Slope 13.01%
urn 2.5% 5. Portfolio Return 3%
Weight Company Name Mean Return Weight
16.88% ISLAMIBANK 0.42% 16.77%
0.00% EBL 18.07% 0.00%
0.00% BRACBANK 3.15% 0.00%
3.58% DAFODILCOM 2.96% 5.15%
2.08% BDLAMPS 1.38% 5.21%
4.67% IPDC 11.50% 0.54%
0.00% ICB 0.01% 0.00%
0.00% LANKABAFIN 0.89% 2.27%
0.00% AMCL 0.08% 0.00%
9.55% GEMINISEA 6.38% 13.51%
4.45% OLYMPIC 1.93% 2.13%
8.47% LINDEBD 1.07% 5.43%
2.86% DELTALIFE -0.87% 2.91%
2.52% ACI 0.68% 3.75%
25.09% ORIONPHARM -0.77% 17.66%
0.00% RENATA 1.87% 0.00%
1.62% SQURPHARMA 0.67% 0.00%
15.91% BATASHOE 0.53% 24.26%
2.32% GP 0.12% 0.42%
0.00% HEIDELBCEM -1.37% 0.00%
1 Total Weight 1
Total Weight 1
Expected Return
1.50%
5.19% 1.43%
4.81% 1.33%
1.00%
5.45% 1.68%
6.40% 2.13%
0.50%
0.00%
0.00% 1.00% 2.00% 3.00% 4.00% 5.00%
Total Weight 1
Total Weight 1
1. Portfolio Return 1%
Company Name Mean Return Weight
ISLAMIBANK 0.004199272152801 8.72%
EBL 0.180749245366916 0.00%
BRACBANK 0.031459436884968 4.99%
DAFODILCOM 0.029577914808602 0.00%
BDLAMPS 0.01383573877653 0.00%
IPDC 0.114988010963866 6.18%
ICB 9.08553724035E-05 0.00%
LANKABAFIN 0.008942367151188 0.00%
AMCL 0.000826482582193 7.57%
GEMINISEA 0.063761620051525 0.00%
OLYMPIC 0.019349772870705 0.60%
LINDEBD 0.010713280161871 0.00%
DELTALIFE -0.00865971926078 0.00%
ACI 0.006773654127729 0.00%
ORIONPHARM -0.00772629727516 41.68%
RENATA 0.018668284785301 1.29%
SQURPHARMA 0.006692088916111 0.00%
BATASHOE 0.005302754588602 0.00%
GP 0.001196973736868 0.00%
HEIDELBCEM -0.01368794664759 28.98%
Total Weight 1
Total Weight 1
Monthly risk free rate 0.0075 Monthly risk free rate 0.0075
Portfolio Retrun 0.0089 Portfolio Retrun 0.0136
Portfolio Variance 0.0040 Portfolio Variance 0.0039
Portfolio standard deviati 0.0632 Portfolio standard devi 0.0621
Sharpe Ratio or Slope 0.0217 Sharpe Ratio or Slope 0.0987
Return 2% 5. Portfolio Return 2.25% 6. Portfolio Return 2.5%
Weight Company Name Mean ReturWeight Company Name Mean Retur
0.1613803 ISLAMIBANK 0.0041993 0.1668289 ISLAMIBANK 0.0041993
0 EBL 0.1807492 0 EBL 0.1807492
0 BRACBANK 0.0314594 0 BRACBANK 0.0314594
0.0214925 DAFODILCOM 0.0295779 0.0283348 DAFODILCOM 0.0295779
0 BDLAMPS 0.0138357 0.0045609 BDLAMPS 0.0138357
0.0765491 IPDC 0.114988 0.0647169 IPDC 0.114988
0 ICB 9.086E-05 0 ICB 9.086E-05
0 LANKABAFIN 0.0089424 0 LANKABAFIN 0.0089424
0 AMCL 0.0008265 0 AMCL 0.0008265
0.0482786 GEMINISEA 0.0637616 0.0729126 GEMINISEA 0.0637616
0.066626 OLYMPIC 0.0193498 0.0561477 OLYMPIC 0.0193498
0.1100898 LINDEBD 0.0107133 0.0967488 LINDEBD 0.0107133
0.0224578 DELTALIFE -0.00866 0.0281722 DELTALIFE -0.00866
0.0080644 ACI 0.0067737 0.0191509 ACI 0.0067737
0.3195765 ORIONPHARM -0.007726 0.283349 ORIONPHARM -0.007726
0 RENATA 0.0186683 0 RENATA 0.0186683
0.0483422 SQURPHARMA 0.0066921 0.0328809 SQURPHARMA 0.0066921
0.0705988 BATASHOE 0.0053028 0.1142338 BATASHOE 0.0053028
0.0346939 GP 0.001197 0.0319627 GP 0.001197
0.01185 HEIDELBCEM -0.013688 0 HEIDELBCEM -0.013688
1 Total Weight 1
Total Weight 1
Expected Return
0.00% 5.98% 0.44% 1.50%
12.12% 6.32% 0.89%
0.00% 6.21% 1.36%
1.00%
21.22% 5.76% 1.44%
0.00% 5.18% 1.42%
0.00% 4.81% 1.33% 0.50%
0.00% 5.10% 1.46%
7.17% 5.45% 1.68%
0.00%
0.00% 6.40% 2.13% 4.60% 4.80% 5.00% 5.20% 5.40
0.00%
0.00% 0.00% 0.75%
39.15% 6.33% 1.27%
0.00%
0.00%
0.75%
2.13%
0.41%
6.40%
21.57%
ale And Risk free Lending and Borrowing Not
d
%
%
4.60% 4.80% 5.00% 5.20% 5.40% 5.60% 5.80% 6.00% 6.20% 6.40% 6.60%
Risk
Year Month Risk Free Rate DSEX Index ISLAMIBANEBL
2014 September 12.22% 1.02% 5,074.30 25.00 24.27
October 12.20% 1.02% 5,173.23 27.00 24.60
November 12.22% 1.02% 4,769.42 25.00 22.44
December 12.22% 1.02% 4,864.96 23.00 22.53
2015 January 12.16% 1.01% 4,724.04 24.00 23.60
February 12.16% 1.01% 4,763.21 24.00 23.60
March 12.16% 1.01% 4,530.48 20.00 21.53
April 12.10% 1.01% 4,047.28 16.00 22.11
May 11.75% 0.98% 4,586.95 18.00 22.61
June 11.75% 0.98% 4,583.10 17.00 21.53
July 11.67% 0.97% 4,792.30 22.00 21.04
August 11.67% 0.97% 4,768.66 30.00 20.70
September 11.59% 0.97% 4,852.08 31.00 22.03
October 11.35% 0.95% 4,564.48 28.00 23.27
November 11.00% 0.92% 4,580.99 28.00 23.52
December 10.92% 0.91% 4,604.91 28.00 23.69
2016 January 10.92% 0.91% 4,540.89 26.00 23.93
February 11.00% 0.92% 4,511.96 24.00 24.84
March 10.88% 0.91% 4,357.53 23.00 24.76
April 10.85% 0.90% 4,195.69 22.00 24.19
May 10.82% 0.90% 4,419.39 26.00 25.43
June 10.72% 0.89% 4,507.58 29.00 27.81
July 10.72% 0.89% 4,525.34 32.00 26.95
August 10.72% 0.89% 4,526.57 29.70 27.33
September 9.79% 0.82% 4,695.18 31.00 28.00
October 8.39% 0.70% 4,592.17 30.90 27.52
November 8.18% 0.68% 4,801.24 30.00 27.62
December 8.00% 0.67% 5,036.05 29.70 27.62
2017 January 6.79% 0.57% 5,468.34 45.10 31.62
February 7.40% 0.62% 5,612.69 44.20 32.29
March 7.39% 0.62% 5,719.61 41.10 31.33
April 5.95% 0.50% 5,475.55 32.20 30.60
May 6.64% 0.55% 5,403.11 31.20 31.70
June 6.94% 0.58% 5,656.04 32.20 35.00
July 7.05% 0.59% 5,860.64 35.50 39.50
August 7.29% 0.61% 6,006.43 33.00 45.00
September 7.59% 0.63% 6,092.84 34.50 45.40
October 7.36% 0.61% 6,019.59 33.00 47.30
November 7.25% 0.60% 6,306.86 33.80 53.70
December 6.98% 0.58% 6,244.52 36.60 51.10
2018 January 6.89% 0.57% 6,039.78 34.10 43.80
February 6.89% 0.57% 5,804.94 31.70 41.40
March 6.77% 0.56% 5,597.44 27.30 40.20
April 6.30% 0.53% 5,739.22 25.50 38.50
May 6.30% 0.53% 5,343.87 23.50 36.00
June 6.30% 0.53% 5,405.46 23.80 33.80
July 6.30% 0.53% 5,302.63 22.80 31.60
August 6.86% 0.57% 5,600.64 23.50 37.00
September 6.96% 0.58% 5,368.95 23.70 33.30
October 6.96% 0.58% 5,284.12 23.50 35.00
November 6.99% 0.58% 5,281.25 23.50 34.70
December 7.00% 0.58% 5,385.64 24.20 36.00
2019 January 7.00% 0.58% 5,821.01 27.20 35.91
February 7.24% 0.60% 5,711.82 25.10 34.91
March 7.39% 0.62% 5,491.90 26.00 33.73
April 7.39% 0.62% 5,202.85 24.90 37.09
May 7.35% 0.61% 5,377.74 24.70 37.30
June 7.11% 0.59% 5,421.62 23.60 37.80
July 6.84% 0.57% 5,138.79 22.70 37.10
August 7.50% 0.63% 5,095.77 22.40 34.40
September 7.00% 0.58% 4,947.63 21.60 34.90
Price Data
BRACBANK DAFODILC BDLAMPS IPDC ICB LANKABAFIAMCL GEMINISEAOLYMPIC
21.47 14.00 121.00 1.75 135.55 24.00 226.30 97.00 145.03
23.27 15.00 126.00 1.94 148.62 21.16 226.30 101.00 154.38
24.27 11.00 120.00 1.81 138.88 19.47 199.70 128.00 171.98
24.80 13.00 118.00 1.92 131.15 20.11 196.10 140.00 180.40
26.33 14.00 104.00 1.84 128.52 18.78 200.50 159.00 185.64
25.73 14.00 121.00 1.86 131.33 18.28 210.70 131.00 179.29
22.87 12.00 113.00 1.70 124.00 15.89 203.70 125.00 176.43
22.00 11.00 103.00 1.55 93.43 12.12 175.70 168.00 167.38
23.27 12.00 104.00 1.82 104.19 15.84 191.40 160.00 174.44
26.20 13.00 105.00 1.74 119.62 13.98 191.00 167.00 186.35
26.80 14.00 156.00 2.01 120.57 14.98 197.70 196.00 219.44
26.07 18.00 166.00 2.16 130.29 14.23 231.60 267.00 219.05
27.47 17.00 204.00 2.34 129.62 17.60 226.20 265.00 240.16
30.93 19.00 193.00 2.67 124.00 14.98 192.90 297.00 227.46
32.07 18.00 194.00 3.14 106.95 14.03 185.10 222.00 237.05
32.47 19.00 260.00 3.09 101.81 14.58 204.20 210.00 246.86
31.67 24.00 246.00 3.40 95.90 13.83 197.90 215.00 249.14
28.73 23.00 236.00 3.19 97.81 20.51 195.70 372.00 271.24
29.80 21.00 181.00 15.83 95.14 20.00 192.80 513.00 279.24
27.60 20.00 169.00 15.76 86.95 18.50 194.00 672.00 289.24
30.93 24.00 167.00 17.57 90.00 16.42 194.80 633.00 311.05
35.33 23.00 170.00 16.94 107.43 16.30 195.70 606.00 328.86
42.53 21.00 187.00 20.35 100.10 16.42 206.90 737.00 323.14
40.60 21.80 190.10 25.42 99.71 16.36 222.60 885.93 287.62
39.93 26.30 184.70 27.57 99.90 19.37 215.30 817.00 291.62
39.93 32.10 170.70 25.69 93.33 15.61 199.90 759.30 287.62
43.60 33.60 176.40 29.03 95.05 16.48 203.70 748.00 295.60
42.73 43.00 174.50 29.65 99.52 20.12 207.60 713.30 307.90
45.13 39.50 173.40 29.51 156.29 27.81 219.00 641.60 308.90
44.67 39.70 176.80 37.43 159.33 36.71 217.20 674.60 307.30
57.80 36.40 170.50 41.50 182.19 42.49 209.50 613.60 287.60
58.24 42.70 167.90 36.58 182.86 35.24 210.00 572.20 277.20
62.08 38.30 171.70 33.58 170.95 32.65 210.10 548.30 268.00
64.56 41.00 173.30 37.67 166.38 37.03 216.50 581.50 278.50
70.24 51.30 183.80 40.33 185.05 39.23 214.90 575.70 287.20
68.64 48.90 180.60 39.25 171.62 40.36 217.90 273.33 273.70
68.72 45.90 167.80 37.33 170.38 40.69 209.70 263.64 271.70
80.48 52.00 169.10 35.83 176.86 42.55 206.70 422.36 256.10
87.84 46.80 175.50 40.50 167.30 47.44 223.10 487.80 285.40
86.72 43.40 186.80 41.75 160.00 44.47 222.00 454.70 288.30
77.44 41.50 178.00 41.58 151.70 38.51 213.30 388.30 284.70
73.28 38.20 188.80 40.60 138.50 32.47 215.40 404.80 259.40
77.76 32.60 172.80 34.40 123.40 29.40 214.30 401.40 275.00
87.70 37.70 181.40 33.80 130.10 29.70 225.10 415.40 264.00
74.50 36.70 167.30 30.90 123.40 26.20 211.60 383.10 237.30
71.20 39.40 248.30 31.00 151.80 26.80 233.30 455.00 224.40
65.70 43.80 249.30 29.30 139.30 25.30 235.40 413.90 206.50
66.96 42.30 233.90 40.74 121.13 30.00 242.40 351.30 201.70
62.43 36.70 222.00 35.56 109.09 26.10 237.90 333.39 205.00
61.22 32.10 216.20 36.57 109.70 23.30 225.30 283.13 218.50
63.22 34.90 200.70 34.91 102.18 22.60 232.10 322.30 217.90
63.22 43.60 197.00 35.28 105.64 22.90 240.60 316.10 216.20
68.26 47.40 237.70 39.72 111.64 27.00 246.50 337.50 240.40
70.61 49.50 234.20 36.02 109.27 26.00 259.20 335.30 232.00
67.65 46.30 232.40 35.90 106.09 22.30 250.40 315.70 232.10
61.70 50.40 173.70 34.40 95.55 20.30 244.60 269.60 224.10
64.60 46.50 189.90 34.80 107.64 22.10 243.80 273.00 225.80
66.10 45.40 208.20 26.30 105.36 21.10 241.50 285.90 236.30
62.90 51.30 191.30 24.30 96.55 17.40 227.20 254.10 222.50
57.90 53.10 193.00 23.40 92.82 17.30 222.00 224.18 207.30
61.50 51.70 180.10 22.90 87.82 16.60 216.10 249.09 204.40
LINDEBD DELTALIFE ACI ORIONPHA RENATA SQURPHARBATASHOE GP
865.00 188.00 343.94 54.00 697.00 232.00 1120.00 382.00
902.00 181.00 326.05 54.00 741.00 248.00 1244.00 374.00
899.00 148.00 273.52 46.00 703.00 224.00 1127.00 319.00
915.00 150.00 280.20 46.00 713.00 230.00 1172.00 362.00
896.00 135.00 255.84 43.00 723.00 226.00 1231.00 329.00
936.00 147.00 313.33 44.00 828.00 234.00 1380.00 335.00
911.00 146.00 384.62 42.00 834.00 234.00 1355.00 358.00
815.00 112.00 383.76 33.00 746.00 219.00 1144.00 324.00
825.00 112.00 435.54 38.00 777.00 219.00 1180.00 324.00
956.00 106.00 427.36 41.00 869.00 233.00 1260.00 330.00
1207.00 108.00 483.64 39.00 1081.00 242.00 1323.00 330.00
1109.00 107.00 452.07 37.00 1050.00 253.00 1305.00 317.00
1305.00 106.00 479.83 38.00 1087.00 249.00 1358.00 285.00
1187.00 91.00 459.50 35.00 1049.00 243.00 1352.00 249.00
1199.00 102.00 419.34 34.00 1086.00 254.00 1331.00 266.00
1138.00 122.00 464.13 37.00 1072.00 254.00 1318.00 253.00
1136.00 109.00 450.91 36.00 1076.00 259.00 1303.00 257.00
1123.00 104.00 458.84 39.00 1084.00 264.00 1236.00 257.00
1065.00 112.00 448.60 38.00 1071.00 251.00 1170.00 227.00
1200.00 91.00 434.13 34.00 1078.00 253.00 1170.00 246.00
1374.00 97.00 416.00 37.00 1106.00 260.00 1170.00 255.00
1437.00 96.00 413.73 37.00 1185.00 266.00 1205.00 255.00
1438.00 94.00 409.18 37.00 1124.00 267.00 1186.00 276.00
1386.80 98.60 395.36 37.30 1099.90 238.45 1180.70 263.90
1418.80 97.00 397.18 38.00 1104.20 244.18 1180.30 269.80
1315.90 92.30 376.55 35.30 1088.10 243.45 1171.40 273.20
1348.00 99.70 372.00 41.50 1091.20 244.90 1172.50 283.40
1296.00 100.60 350.45 42.10 1085.50 249.10 1142.00 284.10
1273.30 109.70 430.64 47.80 1100.90 259.90 1140.10 301.60
1282.90 109.60 423.00 53.20 1108.70 268.20 1130.40 309.00
1217.70 113.90 435.91 49.10 1088.40 277.90 1115.60 332.10
1224.40 104.60 456.27 46.30 1104.50 283.70 1129.30 337.60
1311.20 94.50 470.00 48.10 1098.70 282.00 1132.50 328.70
1277.50 99.00 469.55 50.80 1157.10 290.10 1131.30 344.40
1296.50 98.80 471.36 49.60 1135.60 282.80 1211.40 379.50
1241.80 102.00 508.73 48.80 991.57 266.14 1151.60 389.60
1217.90 108.90 526.46 47.90 1012.96 284.65 1149.50 415.30
1217.10 106.40 518.00 48.60 1041.91 276.65 1151.50 438.30
1279.50 115.80 470.40 49.10 1093.40 301.80 1155.30 471.40
1284.70 107.60 459.80 48.70 1124.20 301.80 1171.80 470.80
1278.90 100.60 429.20 47.20 1230.20 326.00 1181.70 502.40
1228.10 100.70 410.50 47.80 1261.10 313.30 1171.00 478.70
1225.80 107.50 399.10 47.80 1233.90 310.00 1184.30 462.00
1267.70 105.50 362.50 44.50 1261.90 306.90 1141.60 469.60
1248.40 100.60 337.20 40.90 1208.90 282.20 1133.80 414.80
1257.10 100.00 347.80 41.40 1296.50 293.10 1137.20 388.90
1214.50 97.70 363.00 41.20 1247.40 267.60 1110.30 390.20
1198.10 97.20 354.11 39.50 1058.70 259.25 1111.40 386.60
1160.10 102.80 328.50 38.20 1066.35 254.86 1094.90 370.40
1119.20 116.60 337.78 36.60 1108.00 249.72 1090.90 379.80
1224.00 107.20 325.20 36.50 1142.00 263.50 1131.40 362.70
1198.40 109.80 326.20 36.80 1141.60 254.20 1116.40 367.30
1268.60 111.90 299.30 37.80 1139.60 263.30 1121.40 398.20
1350.80 109.80 305.30 36.40 1167.00 273.80 1121.80 393.50
1188.10 105.30 305.30 33.30 1188.60 266.90 1150.30 409.20
1151.40 92.50 245.60 31.80 1176.70 259.90 960.20 358.70
1169.20 97.90 250.50 34.00 1171.30 254.80 992.60 355.10
1207.10 100.00 274.70 33.20 1198.40 264.30 1026.90 364.70
1192.00 94.00 255.40 32.30 1170.50 250.90 965.40 332.40
1330.10 96.30 286.10 32.50 1080.18 235.42 978.20 312.00
1301.20 91.10 255.20 28.90 1147.18 220.65 935.20 352.40
HEIDELBCEM Risk Free Rate
531.00
520.00 -0.16%
493.00 0.16%
499.00 0.00%
491.00 -0.49%
504.00 0.00%
450.00 0.00%
463.00 -0.49%
506.00 -2.89%
570.00 0.00%
635.00 -0.68%
603.00 0.00%
640.00 -0.69%
604.00 -2.07%
566.00 -3.08%
562.00 -0.73%
550.00 0.00%
541.00 0.73%
501.00 -1.09%
525.00 -0.28%
537.00 -0.28%
522.00 -0.92%
550.00 0.00%
534.90 0.00%
542.30 -8.68%
544.80 -14.30%
549.50 -2.50%
552.30 -2.20%
550.60 -15.13%
552.20 8.98%
517.10 -0.14%
479.50 -19.49%
447.30 11.60%
449.00 4.52%
454.60 1.59%
428.40 3.40%
428.60 4.12%
407.60 -3.03%
408.80 -1.49%
424.90 -3.72%
408.70 -1.29%
390.50 0.00%
376.40 -1.74%
375.90 -6.94%
343.00 0.00%
360.60 0.00%
351.40 0.00%
345.20 8.89%
346.20 1.46%
345.30 0.00%
337.90 0.43%
334.70 0.14%
349.90 0.00%
352.50 3.43%
344.00 2.07%
247.00 0.00%
239.50 -0.54%
242.20 -3.27%
193.80 -3.80%
208.50 9.65%
197.90 -6.67%
0.05%
0.55%
Total Weight 1
Optimum Portfolio using S
DSEX Index ISLAMIBANK EBL BRACBANK DAFODILC BDLAMPS IPDC ICB
0.55% 5.04% 216.90% 37.75% 35.49% 16.60% 137.99% 0.11%
14.69% 41.16% 454.08% 33.40% 42.87% 44.18% 223.90% 38.75%
10.07% 14.56% 226.42% 47.27% 45.01% 26.12% 147.51% 9.63%
22.75% 46.22% 455.48% 41.73% 49.95% 46.84% 223.96% 46.93%
0.00% 0.47% 205.25% 35.59% 32.33% 16.01% 145.70% -6.38%
1.0000 1.3990 2.1020 1.1602 1.2596 1.0044 0.1797 1.5899
0.00% 35.66% 453.03% 28.73% 38.67% 41.64% 223.88% 30.91%
3.86% 4.35% 0.00% 4.54% 3.72% 0.00% 0.83%
Total Weight 1
Historical Return
LANKABAFIAMCL GEMINISEAOLYMPIC LINDEBD DELTALIFE ACI ORIONPHARM
l Weight Portfolio
LANKABAAMCL GEMINISEOLYMPIC LINDEBD DELTALIFE ACI ORIONPHAR
10.73% 0.99% 76.51% 23.22% 12.86% -10.39% 8.13% -9.27%
50.41% 18.89% 85.94% 31.60% 23.51% 27.22% 31.65% 23.82%
20.25% 10.51% 86.03% 32.74% 22.38% -0.87% 17.65% 0.25%
52.09% 25.16% 87.09% 36.46% 27.34% 31.93% 35.83% 28.60%
5.78% 1.83% 83.44% 25.60% 15.42% -10.66% 8.54% -9.85%
1.4367 0.8621 0.2574 0.7089 0.6912 0.9718 0.9042 1.0033
45.78% 14.01% 85.86% 29.83% 21.20% 23.18% 28.72% 18.71%
0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05
Portfolio using Solver
LANKABAFIAMCL GEMINISEAOLYMPIC LINDEBD DELTALIFE ACI ORIONPHARM
10.73% 0.99% 76.51% 23.22% 12.86% -10.39% 8.13% -9.27%
50.41% 18.89% 85.94% 31.60% 23.51% 27.22% 31.65% 23.82%
20.25% 10.51% 86.03% 32.74% 22.38% -0.87% 17.65% 0.25%
52.09% 25.16% 87.09% 36.46% 27.34% 31.93% 35.83% 28.60%
5.78% 1.83% 83.44% 25.60% 15.42% -10.66% 8.54% -9.85%
1.4367 0.8621 0.2574 0.7089 0.6912 0.9718 0.9042 1.0033
45.78% 14.01% 85.86% 29.83% 21.20% 23.18% 28.72% 18.71%
15.34% 1.92% 9.50% 4.24% 6.91% 1.80% 5.79% 20.32%
RENATA SQURPHARBATASHOE GP HEIDELBCEM Risk Free Rate
RF 0.75% RF 0.75%
bp 0.9875 bp 0.9875
Ratio 0.2995 Ratio 0.0262
Rm 0.05% Rm 0.05%
Ratio 0.3028 Ratio 0.0329
RF 9.00% RF 9.00%
bp 0.9875 bp 0.9655
Ratio 0.2071 Ratio 0.1428
Rm 0.55% Rm 0.55%
Ratio 0.2880 Ratio 0.2195
8.16%
5.02%
5.66%
10.28%
3.36%
4.78%
1.03%
0.71%
0.02%
0.03%
4.52%
2.00%
14.89%
0.41%
0.24%
14.77%
1.85%
2.27%
0.34%
1,948,574.81
Investable Amount 1,000,000
-0.87% -
0.68% -
-0.77% -
1.87% -
- #DIV/0!
0.67% -
0.53% 13.76
13.76 0.53%
0.12% -
-1.37% -
0.00 #DIV/0!
2.44%
Portfolio Weight Sector Benchmark Weight Portfolio Return Sector Benchmark Return
0.26% 19.67% 0.53% 0.75%
8.16% -0.68%
0.00% 5.02% #DIV/0! -0.08%
0.00% 5.66% #DIV/0! 1.61%
1.98% 10.28% 6.38% 1.18%
0.79% 3.36% 11.50% 0.41%
4.78% 1.57%
1.03% 0.45%
0.71% 1.47%
0.02% 9.25%
0.48% 0.03% 1.93% 0.59%
4.52% 0.81%
2.00% -2.59%
9.81% 14.89% 3.51% 0.03%
0.41% -0.95%
0.24% 1.59%
0.00% 14.77% #DIV/0! -0.13%
1.85% -0.78%
2.27% -1.48%
0.34% -1.07%
86.69% 0.00% 0.05%
100.00% 100.00% #DIV/0! 0.32%
Value Added Retrun
Wpj*Rpj Wbj*Rbj Pure Sector Allocation Allocation/Selection Interaction
0.00% 0.15% -0.083% 0.04%
0.00% -0.06% 0.082% -0.06%
#DIV/0! 0.00% 0.020% #DIV/0!
#DIV/0! 0.09% -0.073% #DIV/0!
0.13% 0.12% -0.071% -0.43%
0.09% 0.01% -0.002% -0.29%
0.00% 0.07% -0.059% 0.07%
0.00% 0.00% -0.001% 0.00%
0.00% 0.01% -0.008% 0.01%
0.00% 0.00% -0.001% 0.00%
0.01% 0.00% 0.001% 0.01%
0.00% 0.04% -0.022% 0.04%
0.00% -0.05% 0.058% -0.05%
0.34% 0.00% 0.015% -0.18%
0.00% 0.00% 0.005% 0.00%
0.00% 0.00% -0.003% 0.00%
#DIV/0! -0.02% 0.067% #DIV/0!
0.00% -0.01% 0.020% -0.01%
0.00% -0.03% 0.041% -0.03%
0.00% 0.00% 0.005% 0.00%
0.00% 0.00% -0.241% -0.04%
#DIV/0! 0.32% -0.25% #DIV/0!
#DIV/0!
Within Sector Selection Total Value Added
-0.04% -0.083%
0.06% 0.082%
#DIV/0! #DIV/0!
#DIV/0! #DIV/0!
0.53% 0.031%
0.37% 0.085%
-0.07% -0.059%
0.00% -0.001%
-0.01% -0.008%
0.00% -0.001%
0.00% 0.008%
-0.04% -0.022%
0.05% 0.058%
0.52% 0.357%
0.00% 0.005%
0.00% -0.003%
#DIV/0! #DIV/0!
0.01% 0.020%
0.03% 0.041%
0.00% 0.005%
0.00% -0.281%
#DIV/0! #DIV/0!
Investable Amount 1,000,000
Scenario 3: Short Sale Not Allowed and Risk free Lending and Borro
Sector Portfolio Weight Invested amount Weight in Portfolio
10-Year T-Bond 96.26% 962,571.36
-0.87% (1.69)
0.68% 15.95
-0.77% (7.45)
1.87% -
6.81 0.19%
0.67% -
0.53% 67.70
67.70 0.53%
0.12% -
-1.37% -
0.00 0.00%
2.44%
Portfolio Weight Sector Benchmark Weight Portfolio Return Sector Benchmark Return
1.28% 19.67% 0.53% 0.75%
8.16% -0.68%
0.00% 5.02% 0.00% -0.08%
0.35% 5.66% 0.19% 1.61%
1.09% 10.28% 4.22% 1.18%
0.28% 3.36% 1.38% 0.41%
4.78% 1.57%
1.03% 0.45%
0.71% 1.47%
0.02% 9.25%
0.00% 0.03% 0.00% 0.59%
4.52% 0.81%
2.00% -2.59%
0.75% 14.89% 1.41% 0.03%
0.41% -0.95%
0.24% 1.59%
0.00% 14.77% 0.00% -0.13%
1.85% -0.78%
2.27% -1.48%
0.34% -1.07%
96.26% 0.00% 0.05%
100.00% 100.00% 0.07% 0.32%
Value Added Retrun
Wpj*Rpj Wbj*Rbj Pure Sector Allocation Allocation/Selection Interaction
0.01% 0.15% -0.078% 0.04%
0.00% -0.06% 0.082% -0.06%
0.00% 0.00% 0.020% 0.00%
0.00% 0.09% -0.068% 0.08%
0.05% 0.12% -0.079% -0.28%
0.00% 0.01% -0.003% -0.03%
0.00% 0.07% -0.059% 0.07%
0.00% 0.00% -0.001% 0.00%
0.00% 0.01% -0.008% 0.01%
0.00% 0.00% -0.001% 0.00%
0.00% 0.00% 0.000% 0.00%
0.00% 0.04% -0.022% 0.04%
0.00% -0.05% 0.058% -0.05%
0.01% 0.00% 0.042% -0.19%
0.00% 0.00% 0.005% 0.00%
0.00% 0.00% -0.003% 0.00%
0.00% -0.02% 0.067% -0.02%
0.00% -0.01% 0.020% -0.01%
0.00% -0.03% 0.041% -0.03%
0.00% 0.00% 0.005% 0.00%
0.00% 0.00% -0.268% -0.04%
0.07% 0.32% -0.25% -0.49%
-0.26%
Within Sector Selection Total Value Added
-0.04% -0.081%
0.06% 0.082%
0.00% 0.020%
-0.08% -0.073%
0.31% -0.046%
0.03% 0.000%
-0.07% -0.059%
0.00% -0.001%
-0.01% -0.008%
0.00% -0.001%
0.00% 0.000%
-0.04% -0.022%
0.05% 0.058%
0.21% 0.052%
0.00% 0.005%
0.00% -0.003%
0.02% 0.067%
0.01% 0.020%
0.03% 0.041%
0.00% 0.005%
0.00% -0.312%
0.48% -0.26%
1 2
Weight 0.05 0.05
DSEX Index RetISLAMIBANK EBL
1.95% 8.00% 1.36%
-7.81% -7.41% -8.78%
2.00% -8.00% 0.40%
-2.90% 4.35% 4.75%
0.83% 0.00% 0.00%
-4.89% -16.67% -8.77%
-10.67% -19.06% 3.60%
13.33% 12.50% 2.26%
-0.08% -5.56% 9.51%
4.56% 29.41% -2.28%
-0.49% 36.36% -1.62%
1.75% 3.33% 6.43%
-5.93% -9.68% 5.63%
0.36% 0.00% 1.07%
0.52% 0.00% 0.72%
-1.39% -7.14% 1.01%
-0.64% -7.69% 3.80%
-3.42% -4.17% -0.32%
-3.71% -4.35% -1.48%
5.33% 18.57% 5.13%
2.00% 11.54% 14.83%
0.39% 10.34% -3.09%
0.03% -7.19% 1.41%
3.72% 4.38% 2.45%
-2.19% -0.32% -1.71%
4.55% -2.91% 0.36%
4.89% -1.00% 0.00%
8.58% 51.85% 14.48%
2.64% -2.00% 2.12%
1.90% -7.01% -2.97%
-4.27% -21.34% -2.33%
-1.32% -3.11% 4.23%
4.68% 3.21% 10.41%
3.62% 10.25% 12.86%
2.49% -7.04% 13.92%
1.44% 4.55% 0.89%
-1.20% -4.35% 4.19%
4.77% 2.42% 13.53%
-0.99% 8.28% -4.84%
-3.28% -6.83% -14.29%
-3.89% -7.04% -5.48%
-3.57% -13.88% -2.90%
2.53% -6.59% -4.23%
-6.89% -7.42% -5.94%
1.15% 1.28% -6.11%
-1.90% -4.20% -6.51%
5.62% 3.07% 17.09%
-4.14% 0.85% -10.00%
-1.58% -0.84% 5.11%
-0.05% 0.00% -0.86%
1.98% 2.98% 3.75%
8.08% 12.40% -0.25%
-1.88% -7.72% -2.78%
-3.85% 3.59% -3.38%
-5.26% -4.23% 9.96%
3.36% -0.40% 0.57%
0.82% -4.45% 1015.27%
-5.22% -3.81% -1.85%
-0.84% -1.32% -7.28%
-2.91% -3.57% 1.45%
11 12
coef of intercept 0.23450064091231 0.01924234851 0.5064002972
Std error of X variable 0.28067841594838 0.01180663454 0.1992529179
r 0.01189177152749 0.09144837455 0.1002059785
F 0.69802348439164 58 6.4591969012
SS of reg 0.00583743443035 0.48504270205 0.0272221142
P Value 0.4069
12 13 14
0.01048129901 0.9856936 -0.009111263872 0.815258964 0.006400185326
0.00838150085 0.2059748 0.0086642537427 0.261776987 0.011011552884
0.06491897642 0.283075 0.0671090409983 0.143266878 0.085290063735
58 22.901067 58 9.699028478 58
0.24443946298 0.1031378 0.261210156255 0.070554564 0.421914908369
0.0137 0.0000 0.0029
Significant
Significant
Significant
Significant
Significant
11 12 13 14 15 16 17 18 19 20
0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05 0.05
OLYMPIC LINDEBD DELTALIFACI ORIONPH RENATA SQURPHABATASHOGP HEIDELBCEM
6.45% 4.28% -3.72% -5.20% 0.00% 6.31% 6.90% 11.07% -2.09% -2.07%
50.51% -0.33% -18.23% -16.11% -14.81% -5.13% -9.68% -9.41% -14.71% -5.19%
4.90% 1.78% 1.35% 2.44% 0.33% 1.42% 2.68% 4.14% 13.48% 1.22%
2.90% -2.08% -10.00% -8.69% -6.52% 1.40% -1.74% 5.03% -9.12% -1.60%
-3.42% 4.46% 8.89% 22.47% 2.33% 14.52% 3.54% 12.10% 2.02% 2.65%
-1.60% -2.55% -0.68% 22.75% -4.55% 0.72% 0.00% -1.81% 6.87% -9.87%
-5.13% -10.54% -23.29% -0.22% -21.43% -10.55% -6.41% 25.90% -9.50% 2.89%
4.22% 1.23% 0.00% 30.75% 15.15% 25.09% 0.00% 3.24% 0.00% 9.29%
6.83% 15.88% -5.17% -1.88% 7.89% 11.84% 6.39% 6.78% 1.85% 12.65%
17.76% 26.26% 1.89% 13.17% -4.88% 24.40% 3.86% 5.00% 0.24% 11.40%
-0.18% -7.94% -0.93% -6.53% -5.13% -2.87% 17.73% -1.36% -3.94% -5.04%
9.64% 17.67% -0.93% 6.14% 2.70% 3.52% -1.58% 4.06% -10.09% 6.14%
-5.29% -9.04% -14.15% -4.24% -7.89% -3.50% -2.41% -0.44% -12.63% -5.63%
25.19% 1.01% 12.09% -8.74% -2.86% 3.53% 4.53% -1.55% 6.83% -6.29%
4.14% -5.09% 19.61% 10.68% 9.23% -1.29% 0.00% -0.81% -4.89% -0.71%
0.92% -0.18% -10.66% -2.85% -2.70% 0.37% 1.97% -1.14% 1.58% -2.14%
8.87% -1.14% -4.59% 1.76% 8.33% 0.74% 1.93% -5.14% 0.23% -1.64%
2.95% -5.06% 7.69% -2.23% -2.56% -1.20% -4.92% -5.34% -11.67% -6.79%
3.58% 12.68% -18.75% -3.23% -10.53% 0.65% 0.80% 0.00% 8.37% 4.79%
7.54% 14.50% 6.59% 5.68% 8.82% 18.06% 2.77% 0.09% 3.66% 2.29%
5.73% 4.59% -0.84% -0.55% 0.00% 7.14% 2.31% 2.99% 0.00% -2.79%
-1.74% 0.07% -2.08% -1.10% 0.00% -5.15% 0.38% -1.58% 8.24% 5.36%
-10.99% -3.42% 4.89% -3.38% 0.81% -2.14% -10.69% -0.45% -4.38% -2.75%
1.39% 2.31% -1.62% 0.46% 1.88% 0.39% 2.40% -0.03% 2.24% 1.38%
-1.37% -7.25% -4.85% -5.19% -7.11% -1.46% -0.30% -0.75% 1.26% 0.46%
8.05% 2.44% 8.02% -1.21% 17.56% 0.28% 10.82% 0.09% 3.73% 0.86%
4.16% -3.86% 0.90% -5.58% 1.80% -0.52% 1.71% -2.40% 0.25% 0.51%
0.32% -1.75% 9.05% 22.88% 13.54% 1.42% 4.34% -0.17% 6.16% -0.31%
-0.52% 0.75% -0.09% -1.77% 11.30% 0.74% 3.19% -0.85% 2.74% 0.29%
-6.41% -4.99% 3.92% 3.05% -7.71% -1.83% 3.62% -1.31% 7.48% -5.78%
-3.62% 0.55% -8.17% 4.67% -5.70% 1.48% 2.09% 1.23% 1.66% -7.27%
-3.32% 7.09% -9.44% 13.31% 3.89% -0.53% -0.60% 0.38% -2.64% -6.72%
3.92% -2.57% 4.76% -0.10% 5.61% 5.32% 2.87% -0.11% 4.78% 0.38%
3.12% 1.49% -0.20% 0.39% -2.36% -1.86% -2.52% 7.08% 10.19% 1.25%
-4.70% -4.06% 3.24% 7.93% -1.61% -12.68% -5.89% -4.94% 2.93% -5.76%
-0.73% -1.92% 6.76% 3.49% -1.84% 2.16% 6.95% -0.18% 6.60% 0.05%
-5.74% -0.07% -2.30% -1.61% 1.46% 2.86% -2.81% 0.17% 5.54% -4.90%
11.60% 5.13% 8.83% -9.10% 1.33% 5.02% 17.39% 0.33% 7.55% 0.29%
1.02% 0.41% -7.08% -2.25% -0.81% 2.82% 0.00% 1.62% -0.13% 3.94%
-1.25% -0.45% -6.51% -6.66% -3.08% 9.43% 8.02% 0.84% 6.71% -3.81%
-8.89% -3.97% 0.10% -4.36% 1.27% 2.51% -3.90% -0.91% -4.51% -4.45%
6.01% 0.09% 6.75% -2.78% 0.00% -2.16% -1.05% 1.14% -3.49% -3.61%
-4.00% 3.42% -1.86% -9.17% -6.90% 2.27% -1.00% -3.61% 1.65% -0.13%
-10.11% -1.52% -4.64% 2.32% -8.09% -4.20% -8.05% -0.39% -11.67% -8.32%
-5.44% 0.70% -0.35% 3.14% 1.22% 7.25% 3.86% 0.30% -6.24% 5.13%
-7.98% -3.39% -2.30% 4.37% -0.48% -3.79% -8.70% -2.37% 0.33% -2.55%
-2.32% -1.35% -0.51% -2.45% -4.13% -15.13% -3.12% 0.10% -0.92% -1.76%
1.64% -3.17% 5.76% -7.23% -3.29% 0.72% -1.69% -1.48% -4.19% 0.29%
6.59% -3.53% 13.42% 2.82% -4.19% 3.91% -2.02% -0.37% 2.54% -0.26%
-0.08% 9.36% -8.06% 0.00% 0.14% 18.61% 13.04% 3.71% -4.50% -2.14%
-0.78% -2.09% 2.43% 0.31% 0.82% -0.04% -3.53% -1.33% 1.27% -0.95%
11.19% 5.86% 1.91% -8.25% 2.72% -0.18% 3.58% 0.45% 8.41% 4.54%
-3.49% 6.48% -1.88% 2.00% -3.70% 2.40% 3.99% 0.04% -0.47% 0.74%
0.04% -11.73% -4.10% 0.00% -8.52% 1.85% -2.52% 2.54% 3.99% -2.41%
0.05% 4.05% -12.16% -19.55% -4.50% -1.00% -2.62% -16.53% -12.34% -28.20%
3.40% 3.40% 5.84% 2.00% 6.92% -0.46% -1.96% 3.72% -1.00% -2.72%
4.65% 3.24% 2.15% 9.66% -2.35% 2.31% 3.73% 3.46% 2.70% 1.13%
-5.84% -1.25% -5.72% -7.03% -2.71% -2.33% -5.07% -5.99% -8.86% -19.98%
-6.83% 11.59% 2.45% 12.02% 0.62% -7.72% -6.17% 1.33% -5.85% 7.59%
-1.40% -2.17% -5.40% -10.80% -11.08% 6.20% -6.27% -4.40% 12.95% -5.08%
5 6 7 8
1.1482654 0.0133097 -0.332053 0.1151401 1.4897449 -0.000592 2.3482164
0.3648503 0.0153473 2.0003406 0.0841436 0.285706 0.0120181 0.3284769
0.1458657 0.1188726 0.0004749 0.6517348 0.3191568 0.0930864 0.4684038
9.9050132 58 0.0275554 58 27.188482 58 51.105369
0.1399647 0.8195802 0.0117044 24.63598 0.2355905 0.5025749 0.5853427
0.0026 0.8687 0.0000
15 16 17 18
1.126358 -0.008242 0.6415771 0.0183744 0.5275312 0.0064504 0.0591321
0.1531215 0.006441 0.2101471 0.0088398 0.1622732 0.006826 0.1668763
0.4826526 0.0498888 0.1384529 0.0684684 0.1541273 0.0528706 0.0021602
54.110355 58 9.320751 58 10.568238 58 0.1255618
0.134675 0.1443559 0.043695 0.2718997 0.0295413 0.1621271 0.0003712
0.0000 0.0034 0.0019
HEIDELBCEM
8 9 10
0.0078667 0.728574 0.0004927 -0.543656 0.0640107
0.0138173 0.139078 0.0058503 0.7646406 0.0321643
0.1070217 0.321184 0.0453134 0.0086404 0.249129
58 27.44 58 0.5055137 58
0.6643113 0.056348 0.1190915 0.0313748 3.599786
0.0000 0.0000 0.4799
18 19 20
0.0052757 0.705414 0.0008738 0.6898149 -0.014004
0.0070196 0.179614 0.0075554 0.1732528 0.0072878
0.0543703 0.210072 0.0585204 0.2146535 0.0564478
58 15.4244 58 15.852748 58
0.1714554 0.052823 0.1986288 0.0505125 0.1848087
0.7244 0.0002 0.0002