Menghitung Valuasi BRNA dengan data Devidend

Menghitung Valuasi BRNA dengan data Devidend

Ada yg mau bantuin hitung Valuasi BRNA dengan data Devidend dibawah ini ?

Devidend BRNA:
Thn 2007 = 50, EPS 150, Payout Ratio = 33%, Yield 5% Thn 2008 = 87, EPS 140, PR = 57%, Yield 27% Thn 2009 = 87, EPS 146, PR = 59%, Yield 14,5% Thn 2010 , EPS 182 (9 month)

Terlihat BRNA juga rajin kasih devidend dengan Payout Ratio yang tinggi yaitu 59%

Data keuangan BRNA:

BRNA Date : 18-11-10
Financial Performance (in billion Rp)
www.investdata.net

2010 2009| 2008|
18-11-10 ....Q3 ....Q2 ....Q1|....Q4 ....Q3 ....Q2 ....Q1|....Q4|
---------- ------ ------ ------ ====== ------ ------ ------ ====== ------
Sales 427 286 145 537 389 245 115 479
COGS 333 224 113 430 312 198 92 387
Gross Marg 93 61 32 106 76 46 22 91
GM (%) 21 21 22 19 19 19 19 19
Opr Profit 48 29 16| 49 36 20 10| 40
OP (%) 11 10 11 9 9 8 8 8
Net Profit 25 15 8| 20 12 6 2| 19
NP (%) 5 5 5 3 3 2 1 4
---------- ------ ------ ------ ====== ------ ------ ------ ====== ------
Stk Price 1.590 1.290 980 650| 600 630 630 405| 310
Book Value 1.393 1.408 1.353| 1.302 1.265 1.330 1.354| 1.302
PBV 1,14 0,93 0,70 0,48| 0,46 0,50 0,47 0,30| 0,24
DER 1,72 1,65 1,74| 1,82 1,73 1,59 1,55| 1,40
---------- ------ ------ ------ ====== ------ ------ ------ ====== ------
ROE (%) 17 16 18| 11 9 6 4| 10
ROE (Qtr) 19 14 18 18 13 9 4 43
ROA (%) 6 6 6| 3 3 2 1| 4
Opr prof/share 351 217 116| 356 261 150 72| 292
EPS 182 113 62| 146 87 45 14| 140
EPS (Qtr) 68 51 62| 59 41 30 14| 140
EPS (Annu) 243 227 248| 146 116 90 58| 140
PER 6,54 5,30 4,31 2,62| 4,09 5,42 6,93 6,89| 2,20
PER (Qtr) 5,78 4,69 4,74 2,62| 2,52 3,77 5,12 6,89| 0,55
---------- ------ ------ ------ ====== ------ ------ ------ ====== ------
COP (year) 3,39 2,75 2,26 1,39 1,68 1,81 2,09 1,39 1,06
CLOP(year) 8,51 7,87 7,62 6,43 8,33 8,11 9,09 8,61 7,32
CLOP(Qtr) 7,41 6,85 8,26 6,43 7,79 6,39 8,78 8,61 1,83
---------- ------ ------ ------ ====== ------ ------ ------ ====== ------
Sales Growth(%) 9 16 26 11
Op.Prof Growth(%) 34 43 60 22
Net.Prof/EPS Grow 109 149 321 4
PEG (<1) 0,05 0,03 0,01| 0,93
---------- ------ ------ ------ ====== ------ ------ ------ ====== ------
Sales(Qtr) 141 140 145 147 143 130 115 479
COGS (Qtr) 109 111 113 117 114 106 92 387
Gross Marg(Qtr) 31 29 32 30 29 24 22 91
GM (%) 22 20 22 20 20 18 19 19
OP.PR (Qtr) 18 13 16 13 15 10 10 40
OP % 13 9 11 8 10 8 8 8
NET.PR (Qtr) 9 7 8 8 5 4 2 19
NP % 6 5 5 5 4 3 1 4
---------- ------ ------ ------ ====== ------ ------ ------ ====== ------
Asset 523 515 512| 507 477 475 476| 432
Liability 331 321 325| 327 302 291 289| 252
Equity 192 194 186| 179 174 183 186| 179
Capitalis. 219 178 135 89| 82 86 86 55| 42
Share(mil) 138 138 138 138 138 138 138 138
---------- ------ ------ ------ ====== ------ ------ ------ ====== ------

See ERROR and OMISSION
- http://www.investdata.net/QQCBRNA.TXT

Date: 18-11-10 FINANCIAL RATIO COMPARISON
Sector: PLASTIK/PACKAGING
Ranked by: ROE
www.investdata.net

|-- ---- ------- --- --- --- ---- ---- --- ---------- ===--------- ===------ --------- ----------- ----------- ----- ------ --------
| | | |(1) (2) (3)| (4) (5)|(6)| (7) | (10) | (8) | (9) |(11)(12)(13|(14)(15)(16| (17)| (18) | MARKET|
| | | SALES |GRS OPR NET| |ROA| ROE | PER | COP | CLOP |YoY GROWTH |Q3/Q2 GROWT| | LAST | CAP. |
|NO|STOC|bio Rp |MAR PRF PRF| PBV DER| | |*LAST*| | | | OPR NET| OPR NET| PEG |PRICE |bio Rp |
| | |mio USD| % % % | | | Q2 Q3|QUARTR|TDY Q3 Q2|TDY Q3 Q2|TDY Q3 Q2|SAL PRF PRF|SAL PRF PRF| | |mio Usd|
|-- ---- ------- === === === ==== ==== === === ---****** --- -- -- === -- -- === -- -- --- --- === --- *** *** =====|======|=======|
| 1 BRNA 427| 21 11 5| 1,1| 1,7| 6| 16 17|19 5| 6| 5 4| 3| 2 2| 8| 7 7| 9 34|109| 0 34| 33| 0,06| 1.590| 219|
|-- ---- ------- === === === ==== ==== === === --- ====== -- -- -- === -- -- === -- -- --- --- === --- --- === =====|======|=======|

1. GRS MRG: Gross Margin to Sales (in %)
2. OPR PRF: Operating Profit to Sales (in %)
3. NET PRF: Net Profit to Sales (in %)
4. PBV: Stock Price to Book value
5. DER: Debt Equity Ratio
6. ROA: Return On Asset (in %)
7. ROE: Return On Equity (in %)
QTR: ROE Quartely, using Most Recent Quarter's Net Profit
8. COP: Capitalisation to Operating Profit (in years)
9. CLOP: Capitalisation + Liability to Operating profit (in years)
10. PER: Price Earning Ratio
QTR: PER using Most Recent Quarter's Net Profit
11. Sales Growth in % (Year on Year comparison)
12. Operating Profit Growth in % (YOY comparison)
13. Net Profit Growth in % - (YOY comparison)
14. Sales Growth in % - (Most Recent Quarter comparison)
15. Operating Profit Growth in % - (MRQ comparison)
16. Net Profit Growth in % - (MRQ comparison)
17. PEG = PER / Net Profit Growth
- http://www.investdata.net/QZA3PLA6.TXT