[CARING] QoQ TTM Result on 2017-02-28 [#3] View: Quarter
Cumulative
T4Q
Annualized
Annual (Unaudited)
Show? QoQ % Horiz. %
TTM Result 30/11/17 31/08/17 31/05/17 28/02/17 30/11/16 31/08/16 31/05/16 CAGR
Revenue 483,852 474,265 459,957 448,788 436,528 426,064 413,414 11.05% QoQ % 2.02% 3.11% 2.49% 2.81% 2.46% 3.06% - Horiz. % 117.04% 114.72% 111.26% 108.56% 105.59% 103.06% 100.00%
PBT 28,397 26,362 21,952 21,232 14,659 12,643 13,985 60.28% QoQ % 7.72% 20.09% 3.39% 44.84% 15.95% -9.60% - Horiz. % 203.05% 188.50% 156.97% 151.82% 104.82% 90.40% 100.00%
Tax -6,838 -6,340 -5,164 -6,201 -4,358 -3,792 -4,169 39.04% QoQ % -7.85% -22.77% 16.72% -42.29% -14.93% 9.04% - Horiz. % 164.02% 152.07% 123.87% 148.74% 104.53% 90.96% 100.00%
NP 21,559 20,022 16,788 15,031 10,301 8,851 9,816 68.88% QoQ % 7.68% 19.26% 11.69% 45.92% 16.38% -9.83% - Horiz. % 219.63% 203.97% 171.03% 153.13% 104.94% 90.17% 100.00%
NP to SH 17,172 15,662 13,129 11,508 7,840 6,692 7,886 67.92% QoQ % 9.64% 19.29% 14.09% 46.79% 17.15% -15.14% - Horiz. % 217.75% 198.61% 166.48% 145.93% 99.42% 84.86% 100.00%
Tax Rate 24.08 % 24.05 % 23.52 % 29.21 % 29.73 % 29.99 % 29.81 % -13.25% QoQ % 0.12% 2.25% -19.48% -1.75% -0.87% 0.60% - Horiz. % 80.78% 80.68% 78.90% 97.99% 99.73% 100.60% 100.00%
Total Cost 462,293 454,243 443,169 433,757 426,227 417,213 403,598 9.47% QoQ % 1.77% 2.50% 2.17% 1.77% 2.16% 3.37% - Horiz. % 114.54% 112.55% 109.80% 107.47% 105.61% 103.37% 100.00%
Net Worth 132,800 134,977 130,623 124,092 121,915 124,092 121,915 5.86% QoQ % -1.61% 3.33% 5.26% 1.79% -1.75% 1.79% - Horiz. % 108.93% 110.71% 107.14% 101.79% 100.00% 101.79% 100.00%
Dividend 30/11/17 31/08/17 31/05/17 28/02/17 30/11/16 31/08/16 31/05/16 CAGR
Div 13,062 9,796 9,796 6,531 6,531 3,265 3,265 151.77% QoQ % 33.33% 0.00% 50.00% 0.00% 100.00% 0.00% - Horiz. % 400.00% 300.00% 300.00% 200.00% 200.00% 100.00% 100.00%
Div Payout % 76.07 % 62.55 % 74.62 % 56.75 % 83.31 % 48.80 % 41.41 % 49.94% QoQ % 21.61% -16.18% 31.49% -31.88% 70.72% 17.85% - Horiz. % 183.70% 151.05% 180.20% 137.04% 201.18% 117.85% 100.00%
Equity 30/11/17 31/08/17 31/05/17 28/02/17 30/11/16 31/08/16 31/05/16 CAGR
Net Worth 132,800 134,977 130,623 124,092 121,915 124,092 121,915 5.86% QoQ % -1.61% 3.33% 5.26% 1.79% -1.75% 1.79% - Horiz. % 108.93% 110.71% 107.14% 101.79% 100.00% 101.79% 100.00%
NOSH 217,706 217,706 217,706 217,706 217,706 217,706 217,706 - QoQ % 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% - Horiz. % 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00%
Ratio Analysis 30/11/17 31/08/17 31/05/17 28/02/17 30/11/16 31/08/16 31/05/16 CAGR
NP Margin 4.46 % 4.22 % 3.65 % 3.35 % 2.36 % 2.08 % 2.37 % 52.37% QoQ % 5.69% 15.62% 8.96% 41.95% 13.46% -12.24% - Horiz. % 188.19% 178.06% 154.01% 141.35% 99.58% 87.76% 100.00%
ROE 12.93 % 11.60 % 10.05 % 9.27 % 6.43 % 5.39 % 6.47 % 58.59% QoQ % 11.47% 15.42% 8.41% 44.17% 19.29% -16.69% - Horiz. % 199.85% 179.29% 155.33% 143.28% 99.38% 83.31% 100.00%
Per Share 30/11/17 31/08/17 31/05/17 28/02/17 30/11/16 31/08/16 31/05/16 CAGR
RPS 222.25 217.85 211.27 206.14 200.51 195.71 189.90 11.05% QoQ % 2.02% 3.11% 2.49% 2.81% 2.45% 3.06% - Horiz. % 117.04% 114.72% 111.25% 108.55% 105.59% 103.06% 100.00%
EPS 7.89 7.19 6.03 5.29 3.60 3.07 3.62 68.02% QoQ % 9.74% 19.24% 13.99% 46.94% 17.26% -15.19% - Horiz. % 217.96% 198.62% 166.57% 146.13% 99.45% 84.81% 100.00%
DPS 6.00 4.50 4.50 3.00 3.00 1.50 1.50 151.77% QoQ % 33.33% 0.00% 50.00% 0.00% 100.00% 0.00% - Horiz. % 400.00% 300.00% 300.00% 200.00% 200.00% 100.00% 100.00%
NAPS 0.6100 0.6200 0.6000 0.5700 0.5600 0.5700 0.5600 5.86% QoQ % -1.61% 3.33% 5.26% 1.79% -1.75% 1.79% - Horiz. % 108.93% 110.71% 107.14% 101.79% 100.00% 101.79% 100.00%
Adjusted Per Share Value based on latest NOSH - 217,706 30/11/17 31/08/17 31/05/17 28/02/17 30/11/16 31/08/16 31/05/16 CAGR
RPS 222.25 217.85 211.27 206.14 200.51 195.71 189.90 11.05% QoQ % 2.02% 3.11% 2.49% 2.81% 2.45% 3.06% - Horiz. % 117.04% 114.72% 111.25% 108.55% 105.59% 103.06% 100.00%
EPS 7.89 7.19 6.03 5.29 3.60 3.07 3.62 68.02% QoQ % 9.74% 19.24% 13.99% 46.94% 17.26% -15.19% - Horiz. % 217.96% 198.62% 166.57% 146.13% 99.45% 84.81% 100.00%
DPS 6.00 4.50 4.50 3.00 3.00 1.50 1.50 151.77% QoQ % 33.33% 0.00% 50.00% 0.00% 100.00% 0.00% - Horiz. % 400.00% 300.00% 300.00% 200.00% 200.00% 100.00% 100.00%
NAPS 0.6100 0.6200 0.6000 0.5700 0.5600 0.5700 0.5600 5.86% QoQ % -1.61% 3.33% 5.26% 1.79% -1.75% 1.79% - Horiz. % 108.93% 110.71% 107.14% 101.79% 100.00% 101.79% 100.00%
Price Multiplier on Financial Quarter End Date 30/11/17 31/08/17 31/05/17 28/02/17 30/11/16 31/08/16 31/05/16 CAGR
Date 30/11/17 30/08/17 31/05/17 28/02/17 30/11/16 30/08/16 31/05/16 -
Price 1.9200 1.7000 1.8100 1.3700 1.3500 1.5600 1.7500 -
P/RPS 0.86 0.78 0.86 0.66 0.67 0.80 0.92 -4.39% QoQ % 10.26% -9.30% 30.30% -1.49% -16.25% -13.04% - Horiz. % 93.48% 84.78% 93.48% 71.74% 72.83% 86.96% 100.00%
P/EPS 24.34 23.63 30.01 25.92 37.49 50.75 48.31 -36.66% QoQ % 3.00% -21.26% 15.78% -30.86% -26.13% 5.05% - Horiz. % 50.38% 48.91% 62.12% 53.65% 77.60% 105.05% 100.00%
EY 4.11 4.23 3.33 3.86 2.67 1.97 2.07 57.91% QoQ % -2.84% 27.03% -13.73% 44.57% 35.53% -4.83% - Horiz. % 198.55% 204.35% 160.87% 186.47% 128.99% 95.17% 100.00%
DY 3.13 2.65 2.49 2.19 2.22 0.96 0.86 136.42% QoQ % 18.11% 6.43% 13.70% -1.35% 131.25% 11.63% - Horiz. % 363.95% 308.14% 289.53% 254.65% 258.14% 111.63% 100.00%
P/NAPS 3.15 2.74 3.02 2.40 2.41 2.74 3.13 0.43% QoQ % 14.96% -9.27% 25.83% -0.41% -12.04% -12.46% - Horiz. % 100.64% 87.54% 96.49% 76.68% 77.00% 87.54% 100.00%
Price Multiplier on Announcement Date 30/11/17 31/08/17 31/05/17 28/02/17 30/11/16 31/08/16 31/05/16 CAGR
Date 23/01/18 24/10/17 27/07/17 28/04/17 24/01/17 31/10/16 29/07/16 -
Price 1.9000 1.8000 1.7000 1.4800 1.3600 1.4100 1.6700 -
P/RPS 0.85 0.83 0.80 0.72 0.68 0.72 0.88 -2.28% QoQ % 2.41% 3.75% 11.11% 5.88% -5.56% -18.18% - Horiz. % 96.59% 94.32% 90.91% 81.82% 77.27% 81.82% 100.00%
P/EPS 24.09 25.02 28.19 28.00 37.77 45.87 46.10 -35.10% QoQ % -3.72% -11.25% 0.68% -25.87% -17.66% -0.50% - Horiz. % 52.26% 54.27% 61.15% 60.74% 81.93% 99.50% 100.00%
EY 4.15 4.00 3.55 3.57 2.65 2.18 2.17 54.01% QoQ % 3.75% 12.68% -0.56% 34.72% 21.56% 0.46% - Horiz. % 191.24% 184.33% 163.59% 164.52% 122.12% 100.46% 100.00%
DY 3.16 2.50 2.65 2.03 2.21 1.06 0.90 130.83% QoQ % 26.40% -5.66% 30.54% -8.14% 108.49% 17.78% - Horiz. % 351.11% 277.78% 294.44% 225.56% 245.56% 117.78% 100.00%
P/NAPS 3.11 2.90 2.83 2.60 2.43 2.47 2.98 2.88% QoQ % 7.24% 2.47% 8.85% 7.00% -1.62% -17.11% - Horiz. % 104.36% 97.32% 94.97% 87.25% 81.54% 82.89% 100.00%
PBT = Profit before Tax, NP = Net Profit, NP to SH = Net Profit Attributable to Shareholder, Div = Dividend, NP Margin = Net Profit Margin, ROE = Return on Equity, NOSH = Number of Shares, RPS = Revenue per Share, EPS = Earning Per Share, DPS = Dividend Per Share, NAPS = Net Asset Per Share, EOQ = End of Quarter, ANN = Announcement, P/RPS = Price/Revenue per Share, P/EPS = Price/Earning per Share, P/NAPS = Price/Net Asset per Share, EY = Earning Yield, DY = Dividend Yield.
NOSH is estimated based on the NP to SH and EPS. Div is an estimated figure based on the DPS and NOSH. Net Worth is an estimated figure based on the NAPS and NOSH.
Div Payout %, NP Margin, ROE, DY, QoQ Δ & YoY Δ figures in Percentage; RPS, EPS & DPS's figures in Cent; and NAPS's figures in Dollar.
All figures in '000 unless specified.
Be the first to like this.
Comment