Program Investasi Pensiun Dengan Saham.xlsx

Tabel Biaya Hidup per bulan(suami istri) 1

Saat Ini Tetap Konsumsi Listrik, air, internet Transportasi Kesehatan Asuransi Pendidikan anak Tidak tetap Hobi & Hiburan Pakaian Lain-lain

Masa Pensiun

2

IDR IDR IDR IDR IDR IDR

1,500,000 1,000,000 500,000 500,000 1,000,000 1,500,000

IDR IDR IDR IDR IDR IDR

1,100,000 1,000,000 300,000 2,000,000 -

IDR IDR IDR IDR IDR

500,000 300,000 200,000 7,000,000 84,000,000

IDR IDR IDR IDR IDR

1,000,000 300,000 300,000 6,000,000 72,000,000

Kalkulator Dana Pensiun 3

Lama dipakai 5 10 15 20 25 30 35 40 45 50

x x x x x x x x x x

4.58371361 8.25393024 11.19270245 13.54580116 15.42994637 16.93859671 18.14658527 19.11383149 19.88831338 20.50844731

Contoh: Pensiun usia 50 tahun dan dinikmati selama 45 Tahun Dana yang diperlukan adalah: IDR 532,817,996 19.88831338 IDR 10,596,851,278.68

4

Tahun 31 32 33 34

Kalkulator tabungan per bulan Asumsi 20% Asumsi 30% 13.38 29.7 49.6 73.86

5 14.14 33.15 58.73 93.13

Usia saat ini 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61

Asumsi 20% IDR 3,351,875 IDR 40,222,496 Usia 31

35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60

103.45 139.53 183.52 237.17 302.59 382.36 479.63 598.24 742.87 919.23 1134.29 1396.53 1716.3 2106.22 2581.69 3161.47 3868.46 4730.55 5781.77 7063.62 8626.7 10532.71 12856.88 15690.94 19146.78 23360.8

139.39 201.6 285.27 397.8 549.14 752.68 1026.41 1394.55 1889.66 2555.52 3451.04 4655.41 6275.14 8453.51 11383.18 15323.25 20622.21 27748.72 37333.09 50223 67558.49 90872.81 122227.96 164397.16 221110.05 297382.58

Contoh: Dari dana yang diperlukan sebesar IDR 10,596,851,278.68 Tabungan per bulan selama 20 tahun kedepan adalah Asumsi 20% IDR 3,351,875 per bulan IDR 40,222,496 per tahun Asumsi 30% IDR 691,554 Per bulan IDR 8,298,645 per tahun

32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76

77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93

Tabel Standar Hidup (asumsi inflasi 10%) Masa Produktif (ideal 20 tahun) Lanjutan Bulanan Tahunan Usia IDR 6,000,000 IDR 72,000,000 IDR 6,600,000 IDR 79,200,000 IDR 7,260,000 IDR 87,120,000 IDR 7,986,000 IDR 95,832,000 IDR 8,784,600 IDR 105,415,200 IDR 9,663,060 IDR 115,956,720 IDR 10,629,366 IDR 127,552,392 IDR 11,692,303 IDR 140,307,631 IDR 12,861,533 IDR 154,338,394 IDR 14,147,686 IDR 169,772,234 IDR 15,562,455 IDR 186,749,457 IDR 17,118,700 IDR 205,424,403 IDR 18,830,570 IDR 225,966,843 IDR 20,713,627 IDR 248,563,527 IDR 22,784,990 IDR 273,419,880 IDR 25,063,489 IDR 300,761,868 IDR 27,569,838 IDR 330,838,055 IDR 30,326,822 IDR 363,921,861 IDR 33,359,504 IDR 400,314,047 IDR 36,695,454 IDR 440,345,451 IDR 40,365,000 IDR 484,379,996 IDR 44,401,500 IDR 532,817,996 IDR 48,841,650 IDR 586,099,796 IDR 53,725,815 IDR 644,709,775 IDR 59,098,396 IDR 709,180,753 IDR 65,008,236 IDR 780,098,828 IDR 71,509,059 IDR 858,108,711 IDR 78,659,965 IDR 943,919,582 IDR 86,525,962 IDR 1,038,311,540 IDR 95,178,558 IDR 1,142,142,694 IDR 104,696,414 IDR 1,256,356,963

Tabel Program Investasi dan Evaluasi Asumsi 30% Tabungan Growth IDR 691,554 5% IDR 8,298,645 Saldo Tabungan IDR 40,222,496 IDR 40,222,496 IDR

62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93

Porto Growth 20% Akhir Tahun Rencana 48,266,996

Realisasi

IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR

48,266,996 100,154,016 164,530,121 243,998,713 341,689,151 461,362,211 607,536,645 785,641,066 1,002,196,225 1,265,033,764 1,583,558,725 1,969,064,588 2,435,111,330 2,997,979,112 3,677,212,726 4,496,274,952 5,483,330,607 6,672,187,427 8,103,425,145 9,825,750,419 11,209,644,507 12,783,129,014 14,603,012,842 16,713,126,582 19,164,210,554 22,016,357,003 25,340,863,168 29,222,394,042 33,761,566,914 39,078,043,768 45,314,232,339 52,635,768,055 61,338,691,356 71,499,443,618 83,481,647,731 97,628,524,207 114,349,830,670 134,134,958,589 157,568,628,269 185,349,699,682 218,313,719,953 257,459,952,312 303,983,779,979 359,315,556,901 425,167,191,299

IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR

42,233,621 44,345,302 46,562,567 48,890,696 51,335,230 53,901,992 56,597,092 59,426,946 62,398,293 65,518,208 68,794,118 72,233,824 75,845,516 79,637,791 83,619,681 87,800,665 92,190,698 96,800,233 101,640,245 484,379,996 557,036,996 613,951,645 675,407,357 742,951,121 817,246,384 898,971,030 988,868,133 1,087,754,947 1,196,530,441 1,316,183,485 1,451,092,293 1,520,191,926 1,755,821,674 1,931,403,842 2,124,544,226 2,336,998,648 2,570,698,513 2,827,768,364 3,110,545,201 3,421,599,721 3,763,759,693 4,140,135,662 4,554,149,229 5,009,564,151 5,510,520,567

IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR

100,154,016 164,530,121 243,998,713 341,689,151 461,362,211 607,536,645 785,641,066 1,002,196,225 1,265,033,764 1,583,558,725 1,969,064,588 2,435,111,330 2,997,979,112 3,677,212,726 4,496,274,952 5,483,330,607 6,672,187,427 8,103,425,145 9,825,750,419 11,209,644,507 12,783,129,014 14,603,012,842 16,713,126,582 19,164,210,554 22,016,357,003 25,340,863,168 29,222,394,042 33,761,566,914 39,078,043,768 45,314,232,339 52,635,768,055 61,338,691,356 71,499,443,618 83,481,647,731 97,628,524,207 114,349,830,670 134,134,958,589 157,568,628,269 185,349,699,682 218,313,719,953 257,459,952,312 303,983,779,979 359,315,556,901 425,167,191,299 503,588,004,879

IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR

503,588,004,879 597,031,718,707 708,436,786,586 841,322,740,455 833,254,787,293 989,256,046,578 1,175,392,587,903 1,397,584,970,695 1,662,927,216,565 1,979,920,436,782 2,358,753,078,734 2,811,637,104,535 3,353,211,276,502 4,001,024,957,968 4,776,118,518,345 5,703,719,647,674 6,814,078,745,436

IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR

6,061,572,623 6,667,729,886 7,334,502,874 8,067,953,162 8,874,748,478 9,762,223,325 10,738,445,658 11,812,290,224 12,993,519,246 14,292,871,171 15,722,158,288 17,294,374,117 19,023,811,528 20,926,192,681 23,018,811,949 25,320,693,144 27,852,762,459

IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR

597,031,718,707 708,436,786,586 841,322,740,455 833,254,787,293 989,256,046,578 1,175,392,587,903 1,397,584,970,695 1,662,927,216,565 1,979,920,436,782 2,358,753,078,734 2,811,637,104,535 3,353,211,276,502 4,001,024,957,968 4,776,118,518,345 5,703,719,647,674 6,814,078,745,436 8,143,471,179,573

Bulanan IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR

115,166,055 126,682,660 139,350,927 153,286,019 168,614,621 185,476,083 204,023,692 224,426,061 246,868,667 271,555,533 298,711,087 328,582,195 361,440,415 397,584,456 437,342,902 481,077,192 529,184,912 582,103,403 640,313,743 704,345,117 774,779,629 852,257,592 937,483,351 1,031,231,686 1,134,354,855 1,247,790,340 1,372,569,374 1,509,826,312 1,660,808,943 1,826,889,837 2,009,578,821 2,210,536,703

IDR 12,000,000,000

IDR 10,000,000,000

IDR 8,000,000,000

Tahunan IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR IDR

1,381,992,660 1,520,191,926 1,672,211,118 1,839,432,230 2,023,375,453 2,225,712,998 2,448,284,298 2,693,112,728 2,962,424,001 3,258,666,401 3,584,533,041 3,942,986,345 4,337,284,980 4,771,013,478 5,248,114,825 5,772,926,308 6,350,218,939 6,985,240,833 7,683,764,916 8,452,141,407 9,297,355,548 10,227,091,103 11,249,800,213 12,374,780,234 13,612,258,258 14,973,484,084 16,470,832,492 18,117,915,741 19,929,707,315 21,922,678,047 24,114,945,852 26,526,440,437

IDR 10,000,000,000

IDR 8,000,000,000

Rencana Realisasi

IDR 6,000,000,000

IDR 4,000,000,000

IDR 2,000,000,000

IDR 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50

0

Rencana Realisasi

Big Cap No

Code

1 BBCA 2 BBRI 3 UNVR 4 TLKM 5 BMRI 6 BBNI 7 GGRM 8 CPIN 9 TPIA 10 INDF 11 INKP

Market Cap 627,597,000,000,000 446,527,000,000,000 426,517,000,000,000 372,465,600,000,000 334,857,250,000,000 161,788,750,000,000 160,372,734,800,000 108,636,750,000,000 100,739,500,000,000 64,536,134,775,000 63,463,402,115,600

Tradable Share 24,660,000,000 123,350,000,000 7,630,000,000 99,060,000,000 46,670,000,000 18,650,000,000 1,924,088,000 16,398,000,000 17,830,000,000 8,780,426,500 5,470,982,941

Equity 143,710,000,000,000 175,400,000,000,000 8,970,000,000,000 106,290,000,000,000 176,280,000,000,000 104,020,000,000,000 42,930,000,000,000 18,240,000,000,000 25,955,000,000,000 48,550,000,000,000 5,350,500,000,000

EPS 2013

2014

578.13 173.12 701.52 140.92 390 485.52 2249.76 154.343 35.90 285.162

668.66 196.53 752.1 145.21 425.8 578.19 2790.19 106.525 68.31 442.504

492.52

286.82

Medium Cap

No

Code

1 ADRO 2 TKIM 3 TOWR 4 JSMR 5 PNBN 6 BBTN 7 JPFA 8 WSKT 9 AALI 10 ITMG 11 BNGA 12 NISP 13 AKRA 14 LPPF 15 BNII 16 WIKA 17 POWR 18 PTPP 19 WSBP 20 DSSA

Market Cap 39,822,522,690,000 34,167,628,680,750 33,921,650,000,000 31,789,475,856,000 26,980,800,000,000 27,048,978,000,000 23,811,900,000,000 23,754,287,200,000 23,664,000,000,000 22,485,507,500,000 22,114,400,000,000 19,622,250,000,000 17,147,089,917,600 16,996,872,816,000 15,701,320,000,000 15,428,316,359,840 13,984,513,110,000 11,748,805,485,830 10,439,018,383,464 10,402,456,320,000

Tradable Share

Equity

31,985,962,000 62,350,000,000,000 3,113,223,570 17,980,000,000,000 51,010,000,000 7,910,000,000,000 7,257,871,200 18,850,000,000,000 24,090,000,000 38,960,000,000,000 10,484,100,000 23,250,000,000,000 11,730,000,000 9,680,000,000,000 13,573,878,400 27,010,000,000,000 1,920,000,000 19,140,000,000,000 1,129,925,000 14,500,000,000,000 25,130,000,000 38,480,000,000,000 22,950,000,000 23,530,000,000,000 4,006,329,420 9,570,000,000,000 2,917,918,080 2,490,000,000,000 76,220,000,000 23,840,000,000,000 8,969,951,372 15,380,000,000,000 16,074,153,000 9,382,660,000,000 6,199,897,354 15,260,000,000,000 26,361,157,534 7,450,000,000,000 770,552,320 22,040,000,000,000

EPS 2013

2014

87.36

69.29

246.48

95.34

3.3 196.51

16.47 206.46

93.82 147.89 55.83 38.21

97.8 105.56 31.17 51.55

35.90

68.31

2486.33 2204.32 170.4 93.2 99.60 116.11 167.04 206.99 394.17 486.34 10.31 92.82 100.19 86.87

109.85

-247.43

99.73

Small Cap

No

Code

Market Cap

Tradable Share

Equity

EPS 2013

2014

1 JRPT 2 PNLF 3 INDY 4 BUMI 5 SRIL 6 ASRI 7 CMNP 8 TBLA 9 PNIN 10 HRUM 11 BMTR 12 WTON 13 APLN 14 ELSA 15 MTDL 16 PJAA 17 BEST 18 PTRO 19 SCCO 20 MLIA 21 UNIC 22 RDTX 23 CFIN 24 KBLI 25 ADMG 26 WOMF 27 LPCK 28 ACST 29 SMDR

9,487,500,000,000 8,902,136,375,454 8,648,918,720,000 7,387,550,898,512 7,280,200,000,000 6,366,409,451,712 4,633,600,000,000 4,487,363,108,760 4,271,740,116,000 3,839,140,400,000 3,833,627,783,940 3,259,584,508,400 3,116,136,800,000 2,481,490,000,000 2,025,685,956,525 1,999,999,995,000 1,948,756,852,300 1,810,445,975,000 1,788,575,580,000 1,567,755,000,000 1,506,492,256,590 1,478,400,000,000 1,251,139,423,498 1,234,228,412,956 1,182,310,585,936 1,086,222,221,760 1,075,320,000,000 1,074,500,000,000 1,015,287,200,000

13,750,000,000 32,022,073,293 5,210,192,000 65,376,556,624 20,450,000,000 19,649,411,888 3,620,000,000 5,342,098,939 4,068,323,920 2,703,620,000 14,198,621,422 8,715,466,600 20,500,900,000 7,298,500,000 2,455,376,917 1,599,999,996 9,647,311,150 1,008,605,000 205,583,400 1,323,000,000 383,331,363 268,800,000 3,984,520,457 4,007,235,107 3,889,179,559 3,481,481,480 696,000,000 700,000,000 3,275,120,000

6,320,000,000,000 23,130,000,000,000 17,400,000,000,000 7,211,575,000,000 7,255,365,000,000 9,220,000,000,000 6,120,000,000,000 4,380,000,000,000 25,640,000,000,000 5,472,445,000,000 14,110,000,000,000 2,930,000,000,000 11,840,000,000,000 3,250,000,000,000 2,440,000,000,000 2,070,000,000,000 3,910,000,000,000 2,692,360,000,000 2,850,000,000,000 1,840,000,000,000 2,501,250,000,000 2,240,000,000,000 4,260,000,000,000 1,830,000,000,000 3,667,485,000,000 1,100,000,000,000 7,540,000,000,000 1,510,000,000,000 4,359,425,000,000

39.78 41.55 -146.18

52.54 40.21 -65.69

44.62

33.79 55.84

17.07 196.10 188.66 44.14 41.53 32.61 50.64 120.11 77.22 209.16 508.98 272.61 737.47 101.43 18.34 3.27 33.17 848.58 198.71 25

81.14 229.58 1.89 49.65 37.69 41.7 56.50 79.99 146.97 40.53 27.78 665.23 94.49 91.72 829.83 99.76 17.48 -77.15 18.16 1212.82 209.37 30

Mini Cap

No

Code

1 SOCI 2 LTLS 3 BULL 4 TPMA 5 BNBA 6 GTBO 7 EKAD 8 DPUM 9 ASRM 10 PEGE 11 IGAR 12 KDSI

Market Cap 924,860,000,000 912,600,000,000 854,100,000,000 653,058,400,000 635,758,200,000 610,000,000,000 604,440,375,000 541,377,330,000 504,214,641,700 495,250,000,000 369,437,710,000 340,200,000,000

Tradable Share 7,060,000,000 1,560,000,000 7,300,000,000 2,633,300,000 2,286,900,000 2,500,000,000 698,775,000 4,164,441,000 214,559,422 2,830,000,000 972,204,500 405,000,000

Equity 4,646,380,000,000 2,020,000,000,000 2,467,900,000,000 1,069,665,000,000 1,400,000,000,000 769,080,000,000 725,810,000,000 1,440,000,000,000 393,600,000,000 511,120,000,000 468,920,000,000 539,240,000,000

EPS 2013 109.50 -28.77 37.10 24.32 55.60 157.15 30.93 20.28 88.89

2014 58.51 104.42 -11.31 56.70 22.42 -22.93 50.30 9 271.81 30.92 33.52 109.85

13 TBMS 14 NELY 15 INAI 16 MICE 17 ASDM 18 ASJT 19 CLPI 20 TIFA 21 BTON 22 BCIP 23 SDPC 24 INCI 25 ICON

323,259,200,000 310,200,000,000 266,112,000,000 235,200,000,000 223,680,000,000 216,000,000,000 199,120,025,000 170,592,600,000 162,720,000,000 130,122,312,775 123,190,000,000 113,749,600,000 108,975,000,000

367,340,000 2,350,000,000 633,600,000 600,000,000 192,000,000 600,000,000 306,338,500 1,079,700,000 720,000,000 1,429,915,525 1,270,000,000 196,120,000 1,089,750,000

570,140,000,000 410,240,000,000 287,130,000,000 624,400,000,000 303,020,000,000 208,110,000,000 434,670,000,000 340,620,000,000 182,640,000,000 409,140,000,000 228,550,000,000 289,130,000,000 206,340,000,000

12.52 16 66.74 171.04 18.84 76.08 29.24 143.79 22.63 14.07 57.07

2916 9.95 35 64.35 196.53 58.47 195.99 33.61 42.39 20.98 10.05 60.91 1.09

EPS 2015

2016

2017

730.83 205.92 766.95 153.66 435.75 486.18 3347.73 112.02 110.53 338.02

835.76 212.37 837.57 191.98 295.85 608.02 3470.26 135.42 1226.36 472.02

953 235 918 220 442.5 730 4030 152.00 232.7 475

561.74

497.82

981.5

2018

0.065333 0.217294 0.152072 0.275179 0.205907 0.040465 0.011779 0.993064 0.158006 0.095173 1824 0.009673

1009 253.8 1276 188 517 818 3992 282.00 189.95 428

EPS 2015

2016

2017

PEG

2018

PEG

65.74

140.56

196.3

188.5 0.061508

7.5

38.49

132.6

57.8 213.14

59.58 260.31

41 303

58.41 174.91 43.92 77.2

99.86 247.3 180.94 126.22

100 287 87 286

393

1274

1044

770.46 1554.72 17.02 82.93 176 209 261.74 253.22 610.31 692.17 20 34 101.65 112.8 81.25 152.88 165.06 13 24.08 -93.8 969.36

3018 118 255 300 654 32 134 87.1 234 38 1444

1540 0.042522 45 0.383838 325 0.121534 117 0.999233 282 0.066244 190 0.206378 366 0.018126 779 0.016565 3411.5 0.009557 138 -0.13175 317 0.016074 431 0.062393 683 0.032107 35 0.180543 128 0.336106 72 0.143712 188 0.073079 45 0.22335 2569.4 0.002742

EPS 2015

2016

2017

2018

PEG

PER 25.22 14.26 43.81 20.00 13.88 10.61 20.88 23.49 29.74 17.17 6.36

PER 6.60 7.13 14.78 13.48 9.57 9.15 10.68 4.78 15.82 5.83 6.38 2.70 9.93 8.53 5.89 13.44 12.08 10.08 8.80 5.25

PER

PBV 4.37 2.55 47.55 3.50 1.90 1.56 3.74 5.96 3.88 1.33 11.86

PBV 0.64 1.90 4.29 1.69 0.69 1.16 2.46 0.88 1.24 1.55 0.57 0.83 1.79 6.83 0.66 1.00 1.49 0.77 1.40 0.47

PBV

2017 23.67 23.19 180.53 31.85 16.51 18.41 24.51 21.23 25.55 17.83 17.13

ROE 2016 24.44 23.85 181.13 30.58 12.24 17.35 22.55 20.94 35.24 19.07 9.59

2018 9.67 26.66 29.02 12.51 7.23 12.72 23.02 18.39 7.81 26.58 9.01 30.92 18.04 80.04 11.19 7.47 12.33 7.64 15.92 8.98

2017 18.58 3.65 39.43 19.43 9.47 18.63 14.44 36.95 14.84 35.16 10.74 13.32 21.20 109.23 11.75 12.69 22.36 16.92 18.23 8.63

ROE 2016 14.18 1.09 37.85 18.42 10.14 18.25 31.13 20.64 15.62 19.21 8.11 12.23 19.76 145.15 13.66 11.88 22.92 13.93 11.43 6.32

2018

2017

ROE 2016

2018 17.31 17.85 108.54 17.52 13.69 14.67 17.89 25.35 13.05 7.74 186.51

63.94 73.49 28.27 47.97 -118.16 -174.31 -725.18 24.83 41.3 42.9 30.36 25.89 165.14 175.25 36.88 115.21 153.83 381.02 -98.2 66.34 3.67 14 19.95 31.26 39.46 31 51.43 42.6 98.1 92.86 181.79 81.77 21.94 34.83 -173.96 -105.69 772.92 1656.22 -117.85 6.83 -10.23 801.8 953.36 967.3 71.87 51.49 28.79 83.43 -85.65 -78.14 4.5 17.32 1308.3 775.6 83.84 97.61 30 44

81 46 837.2 74.1 48.1 70 204 178 257 218.4 35 39 71 34 101 138 50 106.6 1310 36 426.4 919 59 90 -27.3 52 523 220 39

67 62 416.15 60 66.7 43 203 134 296 162.4 36 43 21 40 104 135 21 340.75 1278 132 904.8 984 76 35 43.5 58 5502 174 39.15

EPS 2015 79.97 2.61 56.76 10.25 24.65 -88.52 49.68 16.51 297.62 32.66 31.07 28.23

2016 40.35 38.52 2.68 7.68 34.1 -27.94 125.67 22 295 34.29 48.12 116.36

2017 40.3 96 23.4 24.7 39 0 108 25 284 45 54 170

2018 18.85 100 39.15 43.5 35 43.5 132 22 358 108 46 175

0.268051 0.586127 0.004436 0.026422 0.102998 0.377121 0.030939 0.041206 0.051635 0.47162 -0.83893 0.218535 0.371756 3.281853 0.155665 0.535527 -0.29131 -0.09452 0.008567 0.162632 0.017411 0.028733 -0.10586 0.145071 -0.42587 0.268563 0.000419 0.729681 0.564381

PEG 0.192991 -0.46063 0.054022 -0.65986 0.572252 0.644735 0.114563 0.242176 0.046341 0.060756 0.257188 0.058458

10.30 4.48 3.99 1.88 5.34 7.53 6.31 6.27 3.55 8.74 7.50 8.70 7.24 8.50 7.93 9.26 9.62 5.27 6.81 8.98 4.34 5.59 4.13 8.80 6.99 5.38 0.28 8.82 7.92

PER 6.95 5.85 2.99 5.70 7.94 5.61 6.55 5.91 6.56 1.62 8.26 4.80

1.50 0.38 0.50 1.02 1.00 0.69 0.76 1.02 0.17 0.70 0.27 1.11 0.26 0.76 0.83 0.97 0.50 0.67 0.63 0.85 0.60 0.66 0.29 0.67 0.32 0.99 0.14 0.71 0.23

PBV 0.20 0.45 0.35 0.61 0.45 0.79 0.83 0.38 1.28 0.97 0.79 0.63

14.58 8.58 12.46 54.39 18.80 9.16 12.01 16.34 4.70 8.02 3.62 12.79 3.64 8.98 10.47 10.43 5.18 12.77 9.22 9.49 13.87 11.81 7.11 7.66 4.61 18.36 50.79 8.07 2.94

25.94 28.67 9.74 11.1 48.37 (15.3) (113.41) (3.32) 20.52 23.91 21.74 9.84 17.65 14.48 31.73 24.17 10.79 17.4433 19.15 6.31 7.12 16.80 15 20.82 10.81 14.6 21.60 22.62 15.82 10.27 16.76 13.22 6.16 (6.21) 13.19 37.39 3.61 0.75 10.96 18.96 16.02 18.96 7.82 7.2 29.90 33.74 (4.52) (12.28) 24.34 9.86 6.4 17.25 14.58 7 6.08 7.87

2018 2.86 7.72 11.58 10.71 5.72 14.14 12.71 6.36 19.52 59.80 9.54 13.14

ROE 2016 9.58 5.56 0.66 3.03 8.1 (14.62) 20.53 14.44 26.11 14.97

2017 9.15 12.24 7.88 9.3 8.76 15.69 10.08 22.8 16.97 21.99 18.94

1633.01 12.09 45 38.91 230.59 29.69 135.9 18.58 35.13 3.32 16.36 93.69 -1.06

264.34 5.92 56 34.58 203.39 39.5 206.61 16.3 -8 34 15.25 55.18 2.62

267.8 10 61 111 210 38 131 21 16 37 11 92 2

147.9 22 60 55 133 72 67 29 52 44 18 110 28

0.024403 -50 0.15625 0.215586 0.371791 0.192604 0.23033 -0.82052 -0.03604 0.131147 -3.22688 0.136847 0.496032

5.95 6.00 7.00 7.13 8.76 5.00 9.70 5.45 4.35 2.07 5.39 5.27 3.57

0.57 0.76 0.93 0.38 0.74 1.04 0.46 0.50 0.89 0.32 0.54 0.39 0.53

9.53 12.60 13.24 5.29 8.43 20.76 4.72 9.19 20.50 15.38 10.00 7.46 14.79

27.69 8.4 18.58 14.63 18.18 14.3 12.19 9.48 9.8 19.85 8.89 8.22 10.75

33.3 5.04 18.37 5.06 19.13 17.22 19.68 7.64 (5.55) 10.34 5.48 3.23

ROE 2015 26.88 30.01 161.63 27.49 23.16 15.82 22.66 19.52 3.99 14.51 11.33

2014 28.3 33.1304 166.378 28.7837 25.8098 24.3379 21.63 21.3173 2.79349 20.1573 6.98468

ROE 2015 7.09 0.20 51.36 18.55 6.62 17.81 11.12 14.63 7.31 10.08 1.99 12.19 22.63 214.66 9.79 19.05 22.53 (0.84)

2014 8.58684 2.93122 23.9645 18.9731 14.9747 12.1859 9.11104 23.5214 29.2332 29.7073 10.9792 11.9154 20.0375 1,065.5 6.44887 20.5596 29.6862 1.09259

ROE 2015

2014

NPM 30.96 23.08 23.16 14.34 20.85 21.78 8.24 8.81 8.89% 5.15 20.58

NPM

DER 455.98 574.67 122.94 92.77 565.8 634.02 55.5 46.25 70.91 97.7 136.21

DER

11.72 66.12 30.32 136.71 39.26 190.58 6.46 300.57 14.67 424.26 12.41 1071.21 6.59 133.71 10.28 378.45 8.16 42.74 14.09 47.02 13.84 577.28 20.32 596.95 7.71 114.95 19.23 101.11 11.48 627.02 4.09 269.82 14.21 101.99 5.91 218.58 16.46 119.81 7.28 119

NPM

DER

Div Yield 1 2.95 2.01 4.45 2.77 2.95 3.12 0.85 3.63 3.22 5.32

2013 2014 9100 9800 1410 1460 21850 26800 1790 2125 4125 4050 3725 3950 55500 42750 3600 3525 3550 2875 5800 6700 720 1420

Price 2015 2016 2017 13225 13225 21900 2330 2295 3640 32525 36000 45475 2860 3140 4440 5412 4625 8000 6100 4890 9900 61800 53725 83800 3800 2615 3000 3000 3445 6000 7450 5300 7625 1100 930 5400

Price Div Yield 2013 2014 2015 2016 2017 8.64 1750 1060 1040 494 1860 0.27 2025 1840 865 495 2920 3.56 460 700 802 930 800 1.38 5550 4725 7000 5025 6400 610 630 1145 760 1140 2.22 1480 900 1225 1295 3570 2.46 1230 1270 950 605 1300 3.27 430 420 1465 1620 2210 3.82 15850 16775 13150 15.78 42150 28100 15900 5725 20700 2.71 1110 920 880 580 1350 750 615 675 627 1875 4.67 4125 4475 4500 7200 6350 7.85 2700 11300 14775 17275 10000 2.59 405 310 208 174 264 1.56 1530 1660 3675 2615 1550 6.8 1540 1300 2.47 810 1190 3590 3795 2640 7.73 540 408 13600 13500 12900 11500 13900

Div Yield

2013

2014

Price 2015 2016

2017

29.43 8.76 (9.12) 92.24 26.82 12.32 15.06 9.19 9.71 (9.43) 0.65 10.51 15.84 19.24 27.40 23.06 9.28 (9.52) 23.12 (18.64) (0.27) 21.5 10.61 14.97 (12.01) 2.76 33.77 8.42 5.43

31.865 13.2826 (5.2989) 28.9078 23.9164 23.6202 15.6798 0.1904 8.33923 20.2192 17.6925 21.5522 29.1614 20.6475 18.3048 1.55787 22.5512 12.6126 2.65791 22.0018 16.2748 9.93245 (10.895) 8.85816 42.261 21.6374 10.7753

ROE 2015 19.6 0.38 13.0146 4.03 6.15 (40.65) 17.39 8.59 31.06 14.89 20.69 4.04

2014 18.63 15.9083 (24.05) 25.5779 11.4764 (8.9631) 21.0195 33.6423 15.3933 26.0687 14.9607

41.41 55.13 5.14 24.88 9.22 19.94 23.08 8.54 30.29 9.75 4.46 6.81 8.11 4.76 2.14 17.47 29.47 5.44 5.48 2.79 6.68 65.78 15.69 4.04 2.92 7.74 31.56 3.33 2.04

NPM 7.16 2.45 14.46 18.18 12.09 18.69 12.37 5.95 7.77 98.46 5.62 2.99

64.49 17.89 207.48 666.91 163.85 128.14 96.6 263.58 16.14 22.98 105.17 164.99 145.57 78.23 95.64 106.7 47.45 177.58 48.66 178.53 36.65 11.95 155.1 76.15 21.98 709.56 24.66 419.24 1.82

3.77 6.51 2.3

8.93 17.57 1.85 1.51 1.41 1.88 4.16 4.9 3.45 4.02 2.34 1 2.6 4.97 5.73 6.45

215 135 1570 620 250 610 1760 495 520 6600 2400 385 175 163 810 710 1510 4150 235 2000 4375 3600 186 365 182 3175 2825 200

210 199 600 305 235 455 3150 480 670 2750 1900 760 225 335 285 1110 440 1180 4475 430 1910 5000 3525 142 225 235 5250 1950 145

149 303 515 87 162 580 2965 745 730 1715 1420 1270 337 670 610 1775 765 930 3950 515 1650 5300 3800 145 164 192 10650 3650 733

65 184 110 50 404 331 2200 515 525 680 1095 800 334 240 655 2025 289 290 3500 515 1380 5475 2615 120 89 78 7025 2900 253

900 248 3060 270 380 356 1540 1225 880 2050 590 500 210 372 650 1320 250 1660 9000 590 3420 6000 280 426 246 196 3140 2460 390

Price Div Yield 2013 2014 2015 2016 2017 104.01 1.53 620 650 475 236 211.1 5.13 760 680 1800 490 500 83.85 50 50 300 65 141 51.07 4.84 345 300 438 239 165 408.4 3.6 169 168 150 175 268 15.03 4275 1165 379 169 18.19 2.08 355 395 515 401 695 50.12 825 900 278 292.72 4.24 960 990 1200 2200 2280 41.53 5.71 220 270 209 210 300 23.04 1.05 385 295 324 212 378 146.19 490 355 370 200 550

DER

13.35 10.5 15.91 5.89 23.91 14.29 14.69 9.03 5.65 2.53 11.82 14.68 (1.33)

29.3885 9.20772 20.1667 10.8721 22.3666 15.1712 25.1959 16.8618 6.93791 16.3054 8.01227 10.7237 1.37448

0.76 23.47 3.83 5.36 13.67 10.98 2.84 14.56 33.7 29.76 0.98 6.14 14.24

323.16 9.2 381.91 42.77 283.36 141.4 48.25 375.18 19.27 105.51 383.55 17.17 115.31

4.55 6.55 2.5 5.92 5.25 9.83 3.8

2.06 0

405 197 450 385 730 210 1520 240 173 250 92 245 405

375 160 580 415 660 200 590 300 165 470 96 250 365

475 163 354 353 1150 149 805 215 123 780 89 230 450

300 138 403 367 1145 157 635 140 104 795 69 315 550

900 114 378 350 1015 600 860 192 113 125 110 408 139

2018 25450 3620 55900 3760 7175 8675 83350 6625 5650 7350 11600

2018 1245 10975 665 4380 1120 2580 2030 1750 12325 19900 880 855 4280 5825 206 1720 870 1895 396 13500

2018

690 278 1660 113 356 324 1280 840 1050 1420 270 374 152 340 825 1250 202 1795 8700 1185 3930 5500 314 308 304 312 1545 1535 310

2018 131 585 117 248 278 244 865 130 2350 175 380 840

880 132 420 392 1165 360 650 158 226 91 97 580 100