A | B | C | D | E | F | G | H | I | J | K | |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | Information Source | http://www.bursamalaysia.com/market/listed-companies/company-announcements/#/?category=EA&sub_category=all&alphabetical=All&company=6599 | |||||||||
2 | |||||||||||
3 | |||||||||||
4 | |||||||||||
5 | |||||||||||
6 | |||||||||||
7 | |||||||||||
8 | |||||||||||
9 | |||||||||||
10 | |||||||||||
11 | Est.Growth Rate | Total Variance | |||||||||
12 | 12% | 0.01 | |||||||||
13 | Financial Year | Dividend | Bonus | Accm # of Shares | NormalizeDividend | Growth Rate | Estimated Dividend | Variance | |||
14 | 31-Dec-11 | 0.19 | 3.000 | 0.57 | 19% | 0.54 | 0.00 | ||||
15 | 31-Dec-10 | 0.16 | 3.000 | 0.48 | 33% | 0.48 | 0.00 | ||||
16 | 31-Dec-09 | 0.12 | 3.000 | 0.36 | 0% | 0.43 | 0.01 | ||||
17 | 31-Dec-08 | 0.12 | 1 | 3.000 | 0.36 | -14% | 0.39 | 0.00 | |||
18 | 31-Dec-07 | 0.21 | 2.000 | 0.42 | 31% | 0.35 | 0.01 | ||||
19 | 31-Dec-06 | 0.16 | 2.000 | 0.32 | 7% | 0.31 | 0.00 | ||||
20 | 28-Feb-06 | 0.15 | 2.000 | 0.30 | 25% | 0.28 | 0.00 | ||||
21 | 28-Feb-05 | 0.12 | 1 | 2.000 | 0.24 | 20% | 0.25 | 0.00 | |||
22 | 29-Feb-04 | 0.2 | 1.000 | 0.20 | 0% | 0.22 | 0.00 | ||||
23 | 28-Feb-03 | 0.2 | 1.000 | 0.20 | NA | 0.20 | 0.00 | ||||
24 | |||||||||||
25 | Risk Factor | 8% | Your cost of equity - should be higher than the risk free rate - I use something that > EPF rate | ||||||||
26 | Intrinsic Value | 6.62 | |||||||||
27 | Year | Growth Rate | Dividend | P.V. | Accm P.V. | ||||||
28 | 0 | 0.19 | |||||||||
29 | 1 | 15% | 0.22 | 0.20 | 0.20 | ||||||
30 | 2 | 10% | 0.24 | 0.21 | 0.41 | ||||||
31 | 3 | 10% | 0.26 | 0.21 | 0.62 | ||||||
32 | 4 | 10% | 0.29 | 0.21 | 0.83 | ||||||
33 | 5 | 10% | 0.32 | 0.22 | 1.05 | ||||||
34 | 6 | 10% | 0.35 | 0.22 | 1.27 | ||||||
35 | 7 | 10% | 0.39 | 0.23 | 1.50 | ||||||
36 | 8 | 10% | 0.43 | 0.23 | 1.73 | ||||||
37 | 9 | 10% | 0.47 | 0.23 | 1.96 | ||||||
38 | 10 | 10% | 0.52 | 0.24 | 2.20 | ||||||
39 | 11 | 8% | 0.56 | 0.24 | 2.44 | ||||||
40 | 12 | 5% | 0.58 | 0.23 | 2.67 | ||||||
41 | 13 | 5% | 0.61 | 0.23 | 2.90 | ||||||
42 | 14 | 5% | 0.64 | 0.22 | 3.12 | ||||||
43 | 15 | 5% | 0.68 | 0.21 | 3.33 | ||||||
44 | 16 | 5% | 0.71 | 0.21 | 3.54 | ||||||
45 | 17 | 5% | 0.75 | 0.20 | 3.74 | ||||||
46 | 18 | 5% | 0.78 | 0.20 | 3.93 | ||||||
47 | 19 | 5% | 0.82 | 0.19 | 4.12 | ||||||
48 | 20 | 5% | 0.86 | 0.19 | 4.31 | ||||||
49 | 21 | 0% | 0.86 | 0.17 | 4.48 | ||||||
50 | 22 | 0% | 0.86 | 0.16 | 4.64 | ||||||
51 | 23 | 0% | 0.86 | 0.15 | 4.79 | ||||||
52 | 24 | 0% | 0.86 | 0.14 | 4.92 | ||||||
53 | 25 | 0% | 0.86 | 0.13 | 5.05 | ||||||
54 | 26 | 0% | 0.86 | 0.12 | 5.17 | ||||||
55 | 27 | 0% | 0.86 | 0.11 | 5.27 | ||||||
56 | 28 | 0% | 0.86 | 0.10 | 5.37 | ||||||
57 | 29 | 0% | 0.86 | 0.09 | 5.47 | ||||||
58 | 30 | 0% | 0.86 | 0.09 | 5.55 | ||||||
59 | 31 | 0% | 0.86 | 0.08 | 5.63 | ||||||
60 | 32 | 0% | 0.86 | 0.07 | 5.71 | ||||||
61 | 33 | 0% | 0.86 | 0.07 | 5.77 | ||||||
62 | 34 | 0% | 0.86 | 0.06 | 5.84 | ||||||
63 | 35 | 0% | 0.86 | 0.06 | 5.89 | ||||||
64 | 36 | 0% | 0.86 | 0.05 | 5.95 | ||||||
65 | 37 | 0% | 0.86 | 0.05 | 6.00 | ||||||
66 | 38 | 0% | 0.86 | 0.05 | 6.05 | ||||||
67 | 39 | 0% | 0.86 | 0.04 | 6.09 | ||||||
68 | 40 | 0% | 0.86 | 0.04 | 6.13 | ||||||
69 | 41 | 0% | 0.86 | 0.04 | 6.16 | ||||||
70 | 42 | 0% | 0.86 | 0.03 | 6.20 | ||||||
71 | 43 | 0% | 0.86 | 0.03 | 6.23 | ||||||
72 | 44 | 0% | 0.86 | 0.03 | 6.26 | ||||||
73 | 45 | 0% | 0.86 | 0.03 | 6.29 | ||||||
74 | 46 | 0% | 0.86 | 0.03 | 6.31 | ||||||
75 | 47 | 0% | 0.86 | 0.02 | 6.33 | ||||||
76 | 48 | 0% | 0.86 | 0.02 | 6.36 | ||||||
77 | 49 | 0% | 0.86 | 0.02 | 6.38 | ||||||
78 | 50 | 0% | 0.86 | 0.02 | 6.39 | ||||||
79 | 51 | 0% | 0.86 | 0.02 | 6.41 | ||||||
80 | 52 | 0% | 0.86 | 0.02 | 6.43 | ||||||
81 | 53 | 0% | 0.86 | 0.01 | 6.44 | ||||||
82 | 54 | 0% | 0.86 | 0.01 | 6.46 | ||||||
83 | 55 | 0% | 0.86 | 0.01 | 6.47 | ||||||
84 | 56 | 0% | 0.86 | 0.01 | 6.48 | ||||||
85 | 57 | 0% | 0.86 | 0.01 | 6.49 | ||||||
86 | 58 | 0% | 0.86 | 0.01 | 6.50 | ||||||
87 | 59 | 0% | 0.86 | 0.01 | 6.51 | ||||||
88 | 60 | 0% | 0.86 | 0.01 | 6.52 | ||||||
89 | 61 | 0% | 0.86 | 0.01 | 6.53 | ||||||
90 | 62 | 0% | 0.86 | 0.01 | 6.53 | ||||||
91 | 63 | 0% | 0.86 | 0.01 | 6.54 | ||||||
92 | 64 | 0% | 0.86 | 0.01 | 6.55 | ||||||
93 | 65 | 0% | 0.86 | 0.01 | 6.55 | ||||||
94 | 66 | 0% | 0.86 | 0.01 | 6.56 | ||||||
95 | 67 | 0% | 0.86 | 0.00 | 6.56 | ||||||
96 | 68 | 0% | 0.86 | 0.00 | 6.57 | ||||||
97 | 69 | 0% | 0.86 | 0.00 | 6.57 | ||||||
98 | 70 | 0% | 0.86 | 0.00 | 6.58 | ||||||
99 | 71 | 0% | 0.86 | 0.00 | 6.58 | ||||||
100 | 72 | 0% | 0.86 | 0.00 | 6.58 |