[MASTER] QoQ TTM Result on 2017-09-30 [#3] View: Quarter
Cumulative
T4Q
Annualized
Annual (Unaudited)
Show? QoQ % Horiz. %
TTM Result 30/06/18 31/03/18 31/12/17 30/09/17 30/06/17 31/03/17 31/12/16 CAGR
Revenue 131,728 127,637 115,960 104,718 92,310 84,709 82,465 36.77% QoQ % 3.21% 10.07% 10.74% 13.44% 8.97% 2.72% - Horiz. % 159.74% 154.78% 140.62% 126.98% 111.94% 102.72% 100.00%
PBT 6,363 6,170 5,387 4,999 4,409 3,678 3,512 48.78% QoQ % 3.13% 14.53% 7.76% 13.38% 19.87% 4.73% - Horiz. % 181.18% 175.68% 153.39% 142.34% 125.54% 104.73% 100.00%
Tax -1,501 -1,479 -1,451 -971 -1,070 -967 -956 35.20% QoQ % -1.49% -1.93% -49.43% 9.25% -10.65% -1.15% - Horiz. % 157.01% 154.71% 151.78% 101.57% 111.92% 101.15% 100.00%
NP 4,862 4,691 3,936 4,028 3,339 2,711 2,556 53.70% QoQ % 3.65% 19.18% -2.28% 20.63% 23.16% 6.06% - Horiz. % 190.22% 183.53% 153.99% 157.59% 130.63% 106.06% 100.00%
NP to SH 4,870 4,700 3,945 4,097 3,615 3,126 3,067 36.22% QoQ % 3.62% 19.14% -3.71% 13.33% 15.64% 1.92% - Horiz. % 158.79% 153.24% 128.63% 133.58% 117.87% 101.92% 100.00%
Tax Rate 23.59 % 23.97 % 26.94 % 19.42 % 24.27 % 26.29 % 27.22 % -9.12% QoQ % -1.59% -11.02% 38.72% -19.98% -7.68% -3.42% - Horiz. % 86.66% 88.06% 98.97% 71.34% 89.16% 96.58% 100.00%
Total Cost 126,866 122,946 112,024 100,690 88,971 81,998 79,909 36.21% QoQ % 3.19% 9.75% 11.26% 13.17% 8.50% 2.61% - Horiz. % 158.76% 153.86% 140.19% 126.01% 111.34% 102.61% 100.00%
Net Worth 77,560 77,014 75,375 74,283 73,737 72,644 72,098 5.00% QoQ % 0.71% 2.17% 1.47% 0.74% 1.50% 0.76% - Horiz. % 107.58% 106.82% 104.55% 103.03% 102.27% 100.76% 100.00%
Dividend 30/06/18 31/03/18 31/12/17 30/09/17 30/06/17 31/03/17 31/12/16 CAGR
Div 819 546 546 546 546 0 546 31.13% QoQ % 50.00% 0.00% 0.00% 0.00% 0.00% 0.00% - Horiz. % 150.00% 100.00% 100.00% 100.00% 100.00% 0.00% 100.00%
Div Payout % 16.82 % 11.62 % 13.85 % 13.33 % 15.11 % - % 17.81 % -3.75% QoQ % 44.75% -16.10% 3.90% -11.78% 0.00% 0.00% - Horiz. % 94.44% 65.24% 77.77% 74.85% 84.84% 0.00% 100.00%
Equity 30/06/18 31/03/18 31/12/17 30/09/17 30/06/17 31/03/17 31/12/16 CAGR
Net Worth 77,560 77,014 75,375 74,283 73,737 72,644 72,098 5.00% QoQ % 0.71% 2.17% 1.47% 0.74% 1.50% 0.76% - Horiz. % 107.58% 106.82% 104.55% 103.03% 102.27% 100.76% 100.00%
NOSH 54,620 54,620 54,620 54,620 54,620 54,620 54,620 - 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/06/18 31/03/18 31/12/17 30/09/17 30/06/17 31/03/17 31/12/16 CAGR
NP Margin 3.69 % 3.68 % 3.39 % 3.85 % 3.62 % 3.20 % 3.10 % 12.35% QoQ % 0.27% 8.55% -11.95% 6.35% 13.12% 3.23% - Horiz. % 119.03% 118.71% 109.35% 124.19% 116.77% 103.23% 100.00%
ROE 6.28 % 6.10 % 5.23 % 5.52 % 4.90 % 4.30 % 4.25 % 29.82% QoQ % 2.95% 16.63% -5.25% 12.65% 13.95% 1.18% - Horiz. % 147.76% 143.53% 123.06% 129.88% 115.29% 101.18% 100.00%
Per Share 30/06/18 31/03/18 31/12/17 30/09/17 30/06/17 31/03/17 31/12/16 CAGR
RPS 241.17 233.68 212.30 191.72 169.00 155.09 150.98 36.77% QoQ % 3.21% 10.07% 10.73% 13.44% 8.97% 2.72% - Horiz. % 159.74% 154.78% 140.61% 126.98% 111.94% 102.72% 100.00%
EPS 8.92 8.60 7.22 7.50 6.62 5.72 5.62 36.18% QoQ % 3.72% 19.11% -3.73% 13.29% 15.73% 1.78% - Horiz. % 158.72% 153.02% 128.47% 133.45% 117.79% 101.78% 100.00%
DPS 1.50 1.00 1.00 1.00 1.00 0.00 1.00 31.13% QoQ % 50.00% 0.00% 0.00% 0.00% 0.00% 0.00% - Horiz. % 150.00% 100.00% 100.00% 100.00% 100.00% 0.00% 100.00%
NAPS 1.4200 1.4100 1.3800 1.3600 1.3500 1.3300 1.3200 5.00% QoQ % 0.71% 2.17% 1.47% 0.74% 1.50% 0.76% - Horiz. % 107.58% 106.82% 104.55% 103.03% 102.27% 100.76% 100.00%
Adjusted Per Share Value based on latest NOSH - 54,620 30/06/18 31/03/18 31/12/17 30/09/17 30/06/17 31/03/17 31/12/16 CAGR
RPS 241.17 233.68 212.30 191.72 169.00 155.09 150.98 36.77% QoQ % 3.21% 10.07% 10.73% 13.44% 8.97% 2.72% - Horiz. % 159.74% 154.78% 140.61% 126.98% 111.94% 102.72% 100.00%
EPS 8.92 8.60 7.22 7.50 6.62 5.72 5.62 36.18% QoQ % 3.72% 19.11% -3.73% 13.29% 15.73% 1.78% - Horiz. % 158.72% 153.02% 128.47% 133.45% 117.79% 101.78% 100.00%
DPS 1.50 1.00 1.00 1.00 1.00 0.00 1.00 31.13% QoQ % 50.00% 0.00% 0.00% 0.00% 0.00% 0.00% - Horiz. % 150.00% 100.00% 100.00% 100.00% 100.00% 0.00% 100.00%
NAPS 1.4200 1.4100 1.3800 1.3600 1.3500 1.3300 1.3200 5.00% QoQ % 0.71% 2.17% 1.47% 0.74% 1.50% 0.76% - Horiz. % 107.58% 106.82% 104.55% 103.03% 102.27% 100.76% 100.00%
Price Multiplier on Financial Quarter End Date 30/06/18 31/03/18 31/12/17 30/09/17 30/06/17 31/03/17 31/12/16 CAGR
Date 29/06/18 30/03/18 29/12/17 29/09/17 30/06/17 31/03/17 30/12/16 -
Price 0.5900 0.5800 0.6400 0.6850 0.6600 0.5850 0.5100 -
P/RPS 0.24 0.25 0.30 0.36 0.39 0.38 0.34 -20.77% QoQ % -4.00% -16.67% -16.67% -7.69% 2.63% 11.76% - Horiz. % 70.59% 73.53% 88.24% 105.88% 114.71% 111.76% 100.00%
P/EPS 6.62 6.74 8.86 9.13 9.97 10.22 9.08 -19.04% QoQ % -1.78% -23.93% -2.96% -8.43% -2.45% 12.56% - Horiz. % 72.91% 74.23% 97.58% 100.55% 109.80% 112.56% 100.00%
EY 15.11 14.84 11.29 10.95 10.03 9.78 11.01 23.57% QoQ % 1.82% 31.44% 3.11% 9.17% 2.56% -11.17% - Horiz. % 137.24% 134.79% 102.54% 99.46% 91.10% 88.83% 100.00%
DY 2.54 1.72 1.56 1.46 1.52 0.00 1.96 18.92% QoQ % 47.67% 10.26% 6.85% -3.95% 0.00% 0.00% - Horiz. % 129.59% 87.76% 79.59% 74.49% 77.55% 0.00% 100.00%
P/NAPS 0.42 0.41 0.46 0.50 0.49 0.44 0.39 5.08% QoQ % 2.44% -10.87% -8.00% 2.04% 11.36% 12.82% - Horiz. % 107.69% 105.13% 117.95% 128.21% 125.64% 112.82% 100.00%
Price Multiplier on Announcement Date 30/06/18 31/03/18 31/12/17 30/09/17 30/06/17 31/03/17 31/12/16 CAGR
Date 24/08/18 14/05/18 28/02/18 24/11/17 23/08/17 24/05/17 27/02/17 -
Price 0.6350 0.6400 0.6300 0.6850 0.6250 0.6750 0.6200 -
P/RPS 0.26 0.27 0.30 0.36 0.37 0.44 0.41 -26.25% QoQ % -3.70% -10.00% -16.67% -2.70% -15.91% 7.32% - Horiz. % 63.41% 65.85% 73.17% 87.80% 90.24% 107.32% 100.00%
P/EPS 7.12 7.44 8.72 9.13 9.44 11.79 11.04 -25.41% QoQ % -4.30% -14.68% -4.49% -3.28% -19.93% 6.79% - Horiz. % 64.49% 67.39% 78.99% 82.70% 85.51% 106.79% 100.00%
EY 14.04 13.45 11.46 10.95 10.59 8.48 9.06 34.02% QoQ % 4.39% 17.36% 4.66% 3.40% 24.88% -6.40% - Horiz. % 154.97% 148.45% 126.49% 120.86% 116.89% 93.60% 100.00%
DY 2.36 1.56 1.59 1.46 1.60 0.00 1.61 29.13% QoQ % 51.28% -1.89% 8.90% -8.75% 0.00% 0.00% - Horiz. % 146.58% 96.89% 98.76% 90.68% 99.38% 0.00% 100.00%
P/NAPS 0.45 0.45 0.46 0.50 0.46 0.51 0.47 -2.87% QoQ % 0.00% -2.17% -8.00% 8.70% -9.80% 8.51% - Horiz. % 95.74% 95.74% 97.87% 106.38% 97.87% 108.51% 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