0% found this document useful (0 votes)
79 views34 pages

Doddy Bicara Investasi

The document provides stock price and financial data for various companies listed on the Indonesian stock exchange. It includes metrics such as revenue growth, net income growth, return on equity, dividend payment streak, and earnings margins for the last 5 years. It also lists qualitative factors such as economic moat, growth prospects, and relative valuation multiples to determine intrinsic value and discount. The spreadsheet can be downloaded by clicking File > Download > Microsoft Excel (.xlsx).

Uploaded by

Amri Rijal
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
79 views34 pages

Doddy Bicara Investasi

The document provides stock price and financial data for various companies listed on the Indonesian stock exchange. It includes metrics such as revenue growth, net income growth, return on equity, dividend payment streak, and earnings margins for the last 5 years. It also lists qualitative factors such as economic moat, growth prospects, and relative valuation multiples to determine intrinsic value and discount. The spreadsheet can be downloaded by clicking File > Download > Microsoft Excel (.xlsx).

Uploaded by

Amri Rijal
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 34

Warning!!

untuk diskon yang lebih dari 50%, harus dikroscek ke intrinsic valuation, atau dianalisa apakah ada potensi

Warning!! setelah fundamental perusahaan masuk secara kuantitatif, silahkan dianalisa secara kualitatif (apa keunggu

Apabila ingin mendownload spreadsheet ini, silahkan klik File > Download > Microsoft Excel (.xlsx)
Update harga: real- QUALITY
time QUANTITATIVE

Dividend Average
Revenue Net Income Average
Payment Net Profit
Symbol Stock Price (Growth: 3 (Growth: 3 ROE 5 Year
Streak Margin 5
Year) Year) (%)
(Annual) Year

IDX:BBCA 8,125 9.0% 11.5% 12 18.9 34.3%


IDX:BBRI 4,870 9.3% 9.5% 12 20.06 28.8%
IDX:TLKM 4,620 8.5% 5.2% 11 21.45 15.8%
IDX:BMRI 8,950 6.0% 25.8% 12 14.42 23.8%
IDX:HMSP 970 3.6% 2.4% 11 44.11 12.6%
IDX:ASII 7,575 9.4% 12.7% 11 14.7 8.7%
IDX:ICBP 7,625 7.1% 11.9% 9 19.8 10.2%
IDX:GGRM 30,700 13.2% 17.7% 11 18.18 9.0%
IDX:CPIN 5,150 15.3% 17.9% 10 17.15 6.3%
IDX:BBNI 9,225 9.4% 10.7% 12 14.17 25.2%
IDX:KLBF 1,640 5.3% 2.9% 11 17.83 11.5%
IDX:UNVR 3,890 2.3% 5.0% 11 130.53 17.6%
IDX:INDF 6,300 4.7% 5.8% 11 13.21 5.7%
IDX:MYOR 1,750 10.9% 13.6% 11 19.8 6.7%
IDX:MEGA 6,200 6.6% 20.0% 6 10.6 21.2%
IDX:PTBA 3,820 15.7% 26.5% 11 25.59 18.9%
IDX:ACES 1,045 18.2% 13.2% 11 22.83 13.1%
IDX:MLBI 9,175 4.4% 7.1% 11 103.77 30.7%
IDX:SIDO 940 6.2% 18.9% 7 20.38 21.9%
IDX:PWON 560 15.3% 26.3% 8 23.16 39.1%
atau dianalisa apakah ada potensi penurunan laba permanen

lisa secara kualitatif (apa keunggulan kompetitifnya, bagaimana prospek ke depan, dsb)

oft Excel (.xlsx)


LITY
QUALITATIVE RELATIVE ( Earning and Book Va
Mean PE Mean PE
Debt to Standar Standar
Economic Current
Market Cap Equity INTRINSIC d d
Moat, EPS PE Ratio
(milyar) Ratio Deviatio Deviatio
prospect (TTM)
(Quarter) n (3 n (5
Year) Year)
991,594 0.02 1158.6 7.0 25.0 22.5
730,711 0.02 278.7 17.5 14.3 13.0
31 0.51 204.5 22.6 19.6 20.3
413,490 0.02 588.9 15.2 15.3 14.4
112,828 0.01 118.0 8.2 30.0 34.1
306,663 0.66 526.2 14.4 15.1 16.8
88,922 0.09 432.1 17.6 26.3 27.3
59,070 0.09 5702.4 5.4 17.2 17.7
84,450 0.24 221.7 23.2 25.6 26.3
170,313 0 825.0 11.2 10.2 10.1
76,875 0.07 55.1 29.8 29.0 30.9
148,404 0.28 196.8 19.8 46.5 48.8
55,317 0.62 559.0 11.3 15.1 16.4
39,128 0.6 88.9 19.7 33.0 31.9
72,362 0.08 314.3 19.7 21.3 21.6
44,009 0.01 331.8 11.5 8.2 9.2
17,922 0.03 60.1 17.4 27.6 25.7
19,332 0.89 525.0 17.5 27.6 28.1
28,414 0 55.4 17.0 20.3 19.4
26,969 0.35 60.5 9.3 13.7 14.3
VALUATION
ATIVE ( Earning and Book Value Multiples) RV1 RV2 RV3
Mean PE
Standar
Current
d Avg PE (3 Avg PE (5 Avg PE (10
BVPS PBV
Deviatio Year) Year) Year)
(TTM) Mean Mean Mean
n (10
PBV (3 PBV (5 PBV (10
Year)
Year) Year) Year)
20.6 7049.7 1.2 4.3 4.1 4.3 28,976 26,115 23,890
12.0 1671.0 2.9 2.5 2.5 2.9 3,996 3,617 3,352
16.9 1006.3 4.6 4.3 4.4 4.1 4,012 4,160 3,462
13.8 4375.0 2.0 1.9 1.9 2.4 9,004 8,457 8,097
28.8 306.5 3.2 12.3 15.9 19.0 3,541 4,024 3,398
15.6 3816.3 2.0 2.3 2.5 3.5 7,940 8,851 8,230
24.6 2167.8 3.5 5.4 5.5 5.0 11,363 11,800 10,616
19.8 27704.4 1.1 3.2 3.1 3.5 98,082 100,933 112,623
23.3 1285.3 4.0 4.4 4.3 5.6 5,670 5,838 5,173
11.3 6551.7 1.4 1.4 1.4 1.7 8,373 8,316 9,314
30.6 350.9 4.7 5.1 5.8 6.7 1,598 1,700 1,683
43.5 189.2 20.6 55.8 56.1 46.8 9,142 9,609 8,558
16.2 4301.9 1.5 2.0 2.1 2.4 8,424 9,145 9,028
27.2 432.0 4.1 7.0 6.6 5.8 2,932 2,839 2,416
16.9 2258.1 2.7 2.3 2.3 2.2 6,691 6,775 5,308
12.7 1716.7 2.2 2.5 2.3 3.9 2,704 3,059 4,204
26.1 275.9 3.8 6.5 6.0 6.2 1,655 1,541 1,565
28.0 609.4 15.1 39.5 37.0 37.6 14,490 14,768 14,694
20.9 219.9 4.3 4.4 3.9 3.9 1,125 1,073 1,158
20.1 299.2 1.9 2.6 2.9 4.0 830 864 1,217
RV4 RV5 RV6

Relative
Relative Discount
Fair Value Discount
Avg PBV (3 Avg PBV (5 Avg PBV (minimum Fair Value (minimum (median)
Year) Year) (10 Year) (median) )
)

30,455 28,622 30,455 23,890 28,799 66% 72%


4,244 4,127 4,913 3,352 4,062 -45% -20%
4,317 4,448 4,096 3,462 4,128 -33% -12%
8,356 8,356 10,544 8,097 8,406 -11% -6%
3,777 4,877 5,821 3,398 3,900 71% 75%
8,739 9,541 13,166 7,940 8,795 5% 14%
11,598 11,945 10,904 10,616 11,481 28% 34%
87,823 86,992 96,688 86,992 97,385 65% 68%
5,681 5,463 7,236 5,173 5,675 0% 9%
9,303 9,172 11,334 8,316 9,238 -11% 0%
1,804 2,032 2,361 1,598 1,752 -3% 6%
10,562 10,617 8,858 8,558 9,375 55% 59%
8,475 8,948 10,454 8,424 8,988 25% 30%
3,042 2,856 2,484 2,416 2,847 28% 39%
5,261 5,103 4,855 4,855 5,285 -28% -17%
4,240 4,017 6,661 2,704 4,111 -41% 7%
1,779 1,644 1,697 1,541 1,650 32% 37%
24,097 22,518 22,926 14,490 18,643 37% 51%
961 847 866 847 1,017 -11% 8%
769 868 1,206 769 866 27% 35%
Apabila ingin mendownload spreadsheet ini, silahkan klik File > Download > Microsoft Excel (.xlsx)

INTRINSIC VALUATION
BBCA
EPS = 1158
Growth 0 - 10
years = 9% p.a.
Discount Rate
= 8.50% nilai harus > 4.5% (BI Rate); ped
Growth after 10
years = 3% p.a.

Nilai intrinsik = 34,374


"dengan metode Discounted Cash Flow"

Proyeksi EPS
yang
Tahun ke - Proyeksi EPS disetarakan nilai
saat ini dengan
Discount Rate
1 1262 1163
2 1376 1169
3 1500 1174
4 1635 1179
5 1782 1185
6 1942 1190
7 2117 1196
8 2307 1201
9 2515 1207
10 2741 1212
11 2824 1151
12 2908 1093
13 2996 1037
14 3085 985
15 3178 935
16 3273 887
17 3372 842
18 3473 800
19 3577 759
20 3684 721
21 3795 684
22 3909 649
23 4026 617
24 4147 585
25 4271 556
26 4399 527
27 4531 501
28 4667 475
29 4807 451
30 4951 428
31 5100 407
32 5253 386
33 5410 366
34 5573 348
35 5740 330
36 5912 314
37 6089 298
38 6272 283
39 6460 268
40 6654 255
41 6854 242
42 7059 229
43 7271 218
44 7489 207
45 7714 196
46 7945 186
47 8184 177
48 8429 168
49 8682 159
50 8943 151
51 9211 144
52 9487 136
53 9772 129
54 10065 123
55 10367 117
56 10678 111
57 10998 105
58 11328 100
59 11668 95
60 12018 90
61 12379 85
62 12750 81
63 13132 77
64 13526 73
65 13932 69
66 14350 66
67 14781 63
68 15224 59
69 15681 56
70 16151 53
71 16636 51
72 17135 48
73 17649 46
74 18178 43
75 18724 41
76 19285 39
77 19864 37
78 20460 35
79 21074 33
80 21706 32
81 22357 30
82 23028 29
83 23719 27
84 24430 26
85 25163 25
86 25918 23
87 26696 22
88 27496 21
89 28321 20
90 29171 19
91 30046 18
92 30948 17
93 31876 16
94 32832 15
95 33817 15
96 34832 14
97 35877 13
98 36953 12
99 38062 12
100 39203 11
.5% (BI Rate); pedoman IHSG = 12%
Apabila ingin mendownload spreadsheet ini, silahkan klik File > Download > Microsoft Excel (.xlsx)

Rasio Campuran
1 Current Ratio = Aset lancar / Liabilitas Jangka Pendek

PWON DILD
Aset lancar = 9587 4762
Liabilitas Jangka Pendek = 3611 3651
Current Ratio = 2.65 1.30

2 Debt to Equity Ratio (DER) = Utang berbunga / Ekuitas entitas induk

PWON DILD
Utang berbunga = 5037 5202
Ekuitas Entitas Induk = 14410 5952
Debt to Equity Ratio = 0.35 0.87

3 Net Profit Margin (NPM) = Laba bersih periode berjalan / Pendapatan

PWON DILD
Laba bersih periode berjalan 2494 82.929
Pendapatan = 5240 1854
Net Profit Margin = 47.60% 4.47%

4 Return on Equity (ROE) = Laba bersih periode berjalan entitas induk / Eku

PWON DILD
Laba bersih periode berjalan
entitas induk = 2868 8.67
Ekuitas Entitas Induk = 14410 5952
Return on Equity (ROE) 19.90% 0.15%

5 Return on Capital (ROC) = Laba usaha / (Ekuitas + utang berbunga)

PWON DILD
Laba usaha = 3,529.33 322.67
Ekuitas = 17360 6515
Utang berbunga = 5037 5202
Return on Capital (ROC) 15.76% 2.75%
EPS 9M 44.65 * (Laba bersih berjalan yang diatribusikan kepada entitas induk)
=2150176250*1000/48159602400
EPS 1Y = 59.53

ntitas induk

n / Pendapatan

n entitas induk / Ekuitas entitas induk

ng berbunga)
Apabila ingin mendownload spreadsheet ini, silahkan klik File > Download > Microsoft Excel (.xlsx)

IDX:BBRI

price 4,870
jml lembar 123.35 Milyar P/E ratio 17.48
market cap 600,690 Milyar PBV 2.91
Net Profit 2019 34,372 Milyar
Ekuitas 2019 206,323 Milyar
Net profit per lembar 279
Ekuitas per lembar 1,673

IDX:BRIS

price 1,580
jml lembar 9.72 Milyar P/E ratio 207.45
market cap 15,351 Milyar PBV 3.02
Net Profit 2019 74 Milyar
Ekuitas 2019 5,088 Milyar
Net profit per lembar 8
Ekuitas per lembar 524
P/S ratio
Relative Valuation

Rata-rata P/E ratio

Q4 Q3 Q2 Q1
PBV

Q4 Q3 Q2 Q1
P/S ratio

Q4 Q3 Q2 Q1
Apabila ingin mendownload spreadsheet ini, silahkan klik File > Download > Microsoft Excel (.xlsx)

IDX:BBRI
Saat ini avg 5y avg 10+y
price 4,870 P/E ratio 17.48 12.8 11.3
jml lembar 123.35 Milyar PBV 2.91 2.5 2.77
market cap 600,690 Milyar
Net Profit Entitas Induk 2019 34,372 Milyar Nilai wajar
Ekuitas Entitas Induk 2019 206,323 Milyar P/E ratio 3,560 3,146
Net profit per lembar 279 PBV 4,182 4,633
Ekuitas per lembar 1,673 Konservatif 3,146
Moderat 3,880

MoS = 30% 2,716


Diskon saat ini = -25.5%

IDX:BBCA
Saat ini avg 5y avg 10+y
price 8,125 P/E ratio 34.71 21.8 19.4
jml lembar 122.04 Milyar PBV 5.70 4.005 4.17
market cap 991,594 Milyar
Net Profit Entitas Induk 2019 28,565 Milyar Nilai wajar
Ekuitas Entitas Induk 2019 174,042 Milyar P/E ratio 5,095 4,529
Net profit per lembar 234 PBV 5,711 5,947
Ekuitas per lembar 1,426 Konservatif 4,529
Moderat 5,321

MoS = 10% 4,789


Diskon saat ini = -52.7%

IDX:PWON
Saat ini avg 5y avg 10+y
price 560 P/E ratio 9.26 14.5 16.4
jml lembar 48.16 Milyar PBV 1.87 3 3.735
market cap 26,969 Milyar
Net Profit Entitas Induk 2019 2,913 Milyar Nilai wajar
Ekuitas Entitas Induk 2019 14,411 Milyar P/E ratio 879 992
Net profit per lembar 60 PBV 898 1,118
Ekuitas per lembar 299 Konservatif 879
Moderat 972

MoS = 50% 486


Diskon saat ini = 42.4%
Q4 Q3 Q2 Q1
2019 2019 2019 2019 2018 2018 2018 2018 2017 2017 2017 2017 2016 2016 2016
15.8 15.1 16.0 15.4 14.0 12.2 11.5 14.9 15.5 13.6 13.7 12.0 11.0 11.6 10.4
2.63 2.58 2.85 2.64 2.47 2.24 2.13 2.77 2.69 2.38 2.5 2.23 1.97 2.14 2

Q4 Q3 Q2 Q1
2019 2019 2019 2019 2018 2018 2018 2018 2017 2017 2017 2017 2016 2016 2016
28.9 26.5 27.1 25.9 24.8 23.8 21.9 24.1 23.2 22.4 20.8 19.4 18.6 19.6 17.2
4.74 4.46 4.63 4.31 4.23 4.15 3.87 4.21 4.11 3.93 3.71 3.45 3.4 3.55 3.18

Q4 Q3 Q2 Q1
2019 2019 2019 2019 2018 2018 2018 2018 2017 2017 2017 2017 2016 2016 2016
11.0 12.7 12.3 11.7 11.1 12.1 14.5 17.6 16.5 17.7 20.1 16.3 23.1 21.1
2.22 2.58 2.49 2.37 2.1 2.29 2.79 3.2 2.97 3.16 3.28 3.13 3.92 3.75
2016 2015 2015 2015 2015 2014 2014 2014 2014 2013 2013 2013 2013 2012 2012 2012 2012
11.1 11.1 8.7 10.5 13.4 11.9 10.7 11.1 10.6 8.4 8.5 9.5 11.1 9.2 10.3 9.2 10.7
2.5 2.5 1.99 2.5 3.41 2.95 2.82 3 2.99 2.26 2.43 2.79 3.34 2.65 3.07 2.84 3.14

2016 2015 2015 2015 2015 2014 2014 2014 2014 2013 2013 2013 2013 2012 2012 2012 2012
17.8 18.2 17.1 19.4 21.7 19.6 20.0 17.2 17.4 16.6 17.9 19.4 22.8 19.1 17.0 15.9 17.8
3.25 3.67 3.52 4.08 4.58 4.17 4.32 3.86 3.85 3.71 4.03 4.28 4.97 4.33 3.96 3.96 4.45

2016 2015 2015 2015 2015 2014 2014 2014 2014 2013 2013 2013 2013 2012 2012 2012 2012
15.8 18.9 6.7 8.8 10.1 9.9 12.5 12.0 13.9 11.5 12.9 16.3 20.9 14.5 18.2 17.5 24.5
3 3.31 2.35 3.09 3.82 4.02 3.91 3.68 3.95 3.35 3.77 4.92 5.76 3.72 4.75 3.7 4.11
2011 2011 2011 2011 2010 2010 2010 2010 2009 2009 2009 2009 2008
11.0 9.5 11.5 11.3 11.3 14.2 14.1 13.1 12.9 13.2 11.7 8.3 9.5
3.35 3.21 3.88 3.53 3.53 3.77 3.76 3.36 3.46 3.58 2.97 2.14 2.52

2011 2011 2011 2011 2010 2010 2010 2010 2009 2009 2009 2009 2008
18.2 18.9 20.3 20.0 18.6 21.1 19.6 19.1 17.6 16.6 13.1 12.2 13.9
4.7 4.77 5.08 4.75 4.63 5.09 4.86 4.55 4.29 4.22 3.46 3.05 3.44

2011 2011 2011 2011 2010 2010 2010 2010 2009 2009 2009 2009 2008
26.1 23.2 28.9 26.5 27.4 88.4 50.9 21.2 33.5 27.2 27.6 -33.0 ###
4.05 4.61 5.9 5.56 6.09 7.29 5.98 4.71 4.53 3.89 2.89 1.91 3.92
WEBINAR 3 - SIMULASI TABUNGAN RUTIN

Pengeluaran bulanan = Rp3 juta


Pengeluaran tahunan = Rp36 juta
Inflasi = 4%
Pensiun kita brp tahun lagi = 32 tahun

25 x pengeluaran = Rp900 juta

Dana Pensiun (FV) = Rp3,157.25 juta

Modal awal (PV) = Rp0 juta


Ekspektasi return investasi = 10%

Nabung rutin tahunan = Rp15.70 juta


Nabung rutin bulanan = Rp1.31 juta
Apabila ingin mendownload spreadsheet ini, silahkan klik File > Download > Microsoft Excel (.xlsx)

IDX:BBRI
Saat ini avg 5y avg 10+y
price 4,870 P/E ratio 17.48 12.16 11.28
jml lembar 123.35 Milyar PBV 3.39 2.5 2.73
market cap 730,711 Milyar
Net Profit Entitas Induk 2019 34,372 Milyar x Nilai wajar
Ekuitas Entitas Induk 2019 206,323 Milyar x P/E ratio 3,389 3,143
Net profit per lembar 279 PBV 3,593 3,923
Ekuitas per lembar 1,437 Konservatif 3,143
Moderat 3,512

MoS = 30% 2,458


Diskon saat ini = -38.7%

IDX:BBNI
Saat ini avg 5y avg 10+y
price 9,225 P/E ratio 11.06 9.8 10.6
jml lembar 18.46 Milyar PBV 1.60 1.345 1.64
market cap 170,313 Milyar
Net Profit Entitas Induk 2019 Milyar Nilai wajar
Ekuitas Entitas Induk 2019 Milyar P/E ratio 8,186 8,804
Net profit per lembar 834 PBV 7,751 9,452
Ekuitas per lembar 5,763 Konservatif 7,751
Moderat 8,548

MoS = 40% 5,129


Diskon saat ini = -7.9%

IDX:PWON
Saat ini avg 5y avg 10+y
price 560 P/E ratio 9.26 13.6 16.3
jml lembar 48.16 Milyar PBV 1.87 2.985 3.72
market cap 26,969 Milyar
Net Profit Entitas Induk 2019 2,913 Milyar Nilai wajar
Ekuitas Entitas Induk 2019 14,411 Milyar P/E ratio 822 986
Net profit per lembar 60 PBV 893 1,113
Ekuitas per lembar 299 Konservatif 822
Moderat 954

MoS = 50% 477


Diskon saat ini = 41.3%
Q1 Q4 Q3 Q2 Q1
2020 2019 2019 2019 2019 2018 2018 2018 2018 2017 2017 2017 2017 2016 2016
10.84 15.8 15.1 16.0 15.4 14.0 12.2 11.5 14.9 15.5 13.6 13.7 12.0 11.0 11.6
2.1 2.63 2.58 2.85 2.64 2.47 2.24 2.13 2.77 2.69 2.38 2.5 2.23 1.97 2.14

Q1 Q4 Q3 Q2 Q1
2020 2019 2019 2019 2019 2018 2018 2018 2018 2017 2017 2017 2017 2016 2016
4.6 9.5 8.8 11.3 11.4 10.9 9.3 9.0 11.5 13.6 10.0 9.2 10.4 9.1 9.6
0.66 1.19 1.15 1.5 1.55 1.52 1.36 1.34 1.67 1.87 1.45 1.35 1.38 1.18 1.22

Q4 Q3 Q2 Q1
2019 2019 2019 2019 2018 2018 2018 2018 2017 2017 2017 2017 2016 2016 2016
10.1 11.0 12.7 12.3 11.7 11.1 12.1 14.5 17.6 16.5 17.7 20.1 16.3 23.1 21.1
1.83 2.22 2.58 2.49 2.37 2.1 2.29 2.79 3.2 2.97 3.16 3.28 3.13 3.92 3.75
2016 2016 2015 2015 2015 2015 2014 2014 2014 2014 2013 2013 2013 2013 2012 2012 2012
10.4 11.1 11.1 8.7 10.5 13.4 11.9 10.7 11.1 10.6 8.4 8.5 9.5 11.1 9.2 10.3 9.2
2 2.5 2.5 1.99 2.5 3.41 2.95 2.82 3 2.99 2.26 2.43 2.79 3.34 2.65 3.07 2.84

2016 2016 2015 2015 2015 2015 2014 2014 2014 2014 2013 2013 2013 2013 2012 2012 2012
8.8 10.5 10.3 8.4 11.9 12.0 10.6 10.2 9.2 9.9 8.1 8.9 10.0 12.4 9.8 10.8 11.2
1.2 1.24 1.22 1.25 1.67 2.25 1.93 1.84 1.66 1.81 1.55 1.67 1.82 2.09 1.59 1.78 1.82

2016 2015 2015 2015 2015 2014 2014 2014 2014 2013 2013 2013 2013 2012 2012 2012 2012
15.8 18.9 6.7 8.8 10.1 9.9 12.5 12.0 13.9 11.5 12.9 16.3 20.9 14.5 18.2 17.5 24.5
3 3.31 2.35 3.09 3.82 4.02 3.91 3.68 3.95 3.35 3.77 4.92 5.76 3.72 4.75 3.7 4.11
2012 2011 2011 2011 2011 2010 2010 2010 2010 2009 2009 2009 2009 2008
10.7 11.0 9.5 11.5 11.3 11.3 14.2 14.1 13.1 12.9 13.2 11.7 8.3 9.5
3.14 3.35 3.21 3.88 3.53 3.53 3.77 3.76 3.36 3.46 3.58 2.97 2.14 2.52

2012 2011 2011 2011 2011 2010 2010 2010 2010 2009 2009 2009 2009 2008
12.2 12.2 13.3 14.8 17.1 17.6 14.8 10.6 11.5 11.5 13.7 12.5 6.1 8.04 8.08
1.91 1.88 1.95 2.13 2.18 2.18 2.5 1.71 1.64 1.5 1.67 1.42 0.63 0.64 0.94

2011 2011 2011 2011 2010 2010 2010 2010 2009 2009 2009 2009 2008
26.1 23.2 28.9 26.5 27.4 88.4 50.9 21.2 33.5 27.2 27.6 -33.0 ###
4.05 4.61 5.9 5.56 6.09 7.29 5.98 4.71 4.53 3.89 2.89 1.91 3.92
Apabila ingin mendownload spreadsheet ini, silahkan klik File > Download > Microsoft Excel (.xlsx)
Tahun
INTRINSIC VALUATION 2014
BBRI 2015
CAEPS = 241.58 2016
Discount Rate
= 10.00% = 7% + 0.6*(12%-7%) 2017
Growth 0 - 10
years = 6% p.a. 2018
Growth after 10
years = 3.0% p.a. 2019
Growth after 20
years = 2.0% p.a. 2020

Nilai intrinsik = 4,106


"dengan metode Discounted Cash Flow"

Proyeksi EPS
yang
Tahun ke - Proyeksi EPS disetarakan nilai
saat ini dengan
Discount Rate
1 139 127 asumsi laba 2020 -50%
2 209 173 asumsi laba 2021 +50%
3 288 216 asumsi normal
4 305 208
5 323 201
6 343 193
7 363 186
8 385 180
9 408 173
10 433 167
11 446 156
12 459 146
13 473 137
14 487 128
15 502 120
16 517 112
17 532 105
18 548 99
19 564 92
20 581 86
21 593 80
22 605 74
23 617 69
24 629 64
25 642 59
26 655 55
27 668 51
28 681 47
29 695 44
30 709 41
31 723 38
32 737 35
33 752 32
34 767 30
35 783 28
36 798 26
37 814 24
38 830 22
39 847 21
40 864 19
41 881 18
42 899 16
43 917 15
44 935 14
45 954 13
46 973 12
47 992 11
48 1012 10
49 1033 10
50 1053 9
51 1074 8
52 1096 8
53 1118 7
54 1140 7
55 1163 6
56 1186 6
57 1210 5
58 1234 5
59 1259 5
60 1284 4
61 1309 4
62 1336 4
63 1362 3
64 1390 3
65 1417 3
66 1446 3
67 1475 2
68 1504 2
69 1534 2
70 1565 2
71 1596 2
72 1628 2
73 1661 2
74 1694 1
75 1728 1
76 1762 1
77 1798 1
78 1834 1
79 1870 1
80 1908 1
81 1946 1
82 1985 1
83 2024 1
84 2065 1
85 2106 1
86 2148 1
87 2191 1
88 2235 1
89 2280 0
90 2325 0
91 2372 0
92 2419 0
93 2468 0
94 2517 0
95 2567 0
96 2619 0
97 2671 0
98 2725 0
99 2779 0
100 2835 0
Laba BBRI (inflation adj)
Laba BBRI Inflation CalcFaktor Inflasi = Laba BBRI x Faktor Inflasi

196.53 100.00 1.27 248.87 PE IHSG 14.93


205.91 108.36 1.17 240.62 PBV IHSG 1.3688
212.38 111.99 1.13 240.14 PS IHSG 1.2688

235.08 115.38 1.10 258.00 ROE 9.17%

262.28 119.54 1.06 277.84 NPM 8.50%

278.67 123.28 1.03 286.24

139.34 126.63 1.00 139.34


asumsi laba 2020 -50% Average = 241.58

NR BBRI = 3,512
NI BBRI = 4,106

NW BBRI = 3,809
Ini adalah request di Kolom Komentar WBI Ep. 19 untuk Mencari Bobot Saham IDX30
Update 4 Mei 2020, sumber: https://www.idx.co.id/data-pasar/data-saham/indeks-saham/
Free Float
Market Cap
Ticker Saham Lembar Harga (Milyar)
IDX:BBCA BBCA 5,566,812,058 8,125 45,230.35
IDX:BBRI BBRI 51,328,401,502 4,870 249,969.32
IDX:TLKM TLKM 45,318,430,440 4,620 209,371.15
IDX:BMRI BMRI 18,479,999,999 8,950 165,396.00
IDX:ASII ASII 18,254,034,111 7,575 138,274.31
IDX:UNVR UNVR 5,497,415,000 3,890 21,384.94
IDX:CPIN CPIN 6,578,877,600 5,150 33,881.22
IDX:BBNI BBNI 7,384,867,957 9,225 68,125.41
IDX:BRPT BRPT 24,773,325,538 850 21,057.33
IDX:KLBF KLBF 20,643,803,777 1,640 33,855.84
IDX:SMGR SMGR 2,904,665,344 6,400 18,589.86
IDX:INDF INDF 4,344,555,032 6,300 27,370.70
IDX:UNTR UNTR 1,508,093,635 30,275 45,657.53
IDX:INTP INTP 1,795,336,700 10,475 18,806.15
IDX:ICBP ICBP 2,332,381,600 7,625 17,784.41
IDX:ADRO ADRO 15,964,193,634 3,340 53,320.41
IDX:GGRM GGRM 330,173,501 30,700 10,136.33
IDX:HMSP HMSP 8,654,064,921 970 8,394.44
IDX:INKP INKP 2,196,052,553 7,575 16,635.10
IDX:PGAS PGAS 10,433,545,128 1,450 15,128.64
IDX:ACES ACES 6,865,145,000 1,045 7,174.08
IDX:PTBA PTBA 3,884,766,299 3,820 14,839.81
IDX:JPFA JPFA 5,525,562,235 1,450 8,012.07
IDX:MNCN MNCN 6,808,273,759 1,005 6,842.32
IDX:INCO INCO 2,014,095,859 7,300 14,702.90
IDX:ANTM ANTM 8,365,109,201 2,600 21,749.28
IDX:BBTN BBTN 4,193,640,000 1,845 7,737.27
IDX:WSKT WSKT 4,609,713,760 530 2,443.15
IDX:PTPP PTPP 3,037,949,703 935 2,840.48
IDX:ERAA ERAA 1,451,131,000 525 761.84

1,305,472.61
Saham IDX30
aham/indeks-saham/

Bobot
3.46%
19.15%
16.04%
12.67%
10.59%
1.64%
2.60%
5.22%
1.61%
2.59%
1.42%
2.10%
3.50%
1.44%
1.36%
4.08%
0.78%
0.64%
1.27%
1.16%
0.55%
1.14%
0.61%
0.52%
1.13%
1.67%
0.59%
0.19%
0.22%
0.06%

100.00%
Lower Risk Market Risk (IHSG)
Beta 0.5 0.75 1 1.5
1 ROE 25.0% 17.5% 10.0% 7.5%
2 DER 10.0% 25.0% 50.0% 100.0%
3 NPM 20.0% 10.0% 8.5% 5.0%
4 Profit Margin Stab (covariance) 2.5% 7.5% 10.0% 15.0%
5 Earning's Predictability (R) 97.5% 85.0% 75.0% 50.0%
6 Market cap (size, in Bio) 200 100 50 10
Higher Risk Input Value
2
5.0% 20.0% 0.67
200.0% 0.0% 0.50
2.5% 25.0% 0.50
20.0% 5.0% 0.63
25.0% 99.0% 0.50
1 250 0.50

BETA = 0.55
Adjustment = 0.00
FINAL BETA = 0.55

10Y Bond yield = 7.0%


IHSG = 12.0%

Discount rate = 9.74%

You might also like