[MASTER] QoQ TTM Result on 2017-12-31 [#4] View: Quarter
Cumulative
T4Q
Annualized
Annual (Unaudited)
Show?
TTM Result 30/09/18 30/06/18 31/03/18 31/12/17 30/09/17 30/06/17 31/03/17 CAGR
Revenue 137,186 131,728 127,637 115,960 104,718 92,310 84,709 37.87% QoQ % 4.14% 3.21% 10.07% 10.74% 13.44% 8.97% - Horiz. % 161.95% 155.51% 150.68% 136.89% 123.62% 108.97% 100.00%
PBT 6,776 6,363 6,170 5,387 4,999 4,409 3,678 50.23% QoQ % 6.49% 3.13% 14.53% 7.76% 13.38% 19.87% - Horiz. % 184.23% 173.00% 167.75% 146.47% 135.92% 119.87% 100.00%
Tax -1,671 -1,501 -1,479 -1,451 -971 -1,070 -967 43.95% QoQ % -11.33% -1.49% -1.93% -49.43% 9.25% -10.65% - Horiz. % 172.80% 155.22% 152.95% 150.05% 100.41% 110.65% 100.00%
NP 5,105 4,862 4,691 3,936 4,028 3,339 2,711 52.43% QoQ % 5.00% 3.65% 19.18% -2.28% 20.63% 23.16% - Horiz. % 188.31% 179.34% 173.04% 145.19% 148.58% 123.16% 100.00%
NP to SH 5,113 4,870 4,700 3,945 4,097 3,615 3,126 38.78% QoQ % 4.99% 3.62% 19.14% -3.71% 13.33% 15.64% - Horiz. % 163.56% 155.79% 150.35% 126.20% 131.06% 115.64% 100.00%
Tax Rate 24.66 % 23.59 % 23.97 % 26.94 % 19.42 % 24.27 % 26.29 % -4.17% QoQ % 4.54% -1.59% -11.02% 38.72% -19.98% -7.68% - Horiz. % 93.80% 89.73% 91.18% 102.47% 73.87% 92.32% 100.00%
Total Cost 132,081 126,866 122,946 112,024 100,690 88,971 81,998 37.37% QoQ % 4.11% 3.19% 9.75% 11.26% 13.17% 8.50% - Horiz. % 161.08% 154.72% 149.94% 136.62% 122.80% 108.50% 100.00%
Net Worth 78,653 77,560 77,014 75,375 74,283 73,737 72,644 5.44% QoQ % 1.41% 0.71% 2.17% 1.47% 0.74% 1.50% - Horiz. % 108.27% 106.77% 106.02% 103.76% 102.26% 101.50% 100.00%
Dividend 30/09/18 30/06/18 31/03/18 31/12/17 30/09/17 30/06/17 31/03/17 CAGR
Div 819 819 546 546 546 546 0 - QoQ % 0.00% 50.00% 0.00% 0.00% 0.00% 0.00% - Horiz. % 150.00% 150.00% 100.00% 100.00% 100.00% 100.00% -
Div Payout % 16.02 % 16.82 % 11.62 % 13.85 % 13.33 % 15.11 % - % - QoQ % -4.76% 44.75% -16.10% 3.90% -11.78% 0.00% - Horiz. % 106.02% 111.32% 76.90% 91.66% 88.22% 100.00% -
Equity 30/09/18 30/06/18 31/03/18 31/12/17 30/09/17 30/06/17 31/03/17 CAGR
Net Worth 78,653 77,560 77,014 75,375 74,283 73,737 72,644 5.44% QoQ % 1.41% 0.71% 2.17% 1.47% 0.74% 1.50% - Horiz. % 108.27% 106.77% 106.02% 103.76% 102.26% 101.50% 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/09/18 30/06/18 31/03/18 31/12/17 30/09/17 30/06/17 31/03/17 CAGR
NP Margin 3.72 % 3.69 % 3.68 % 3.39 % 3.85 % 3.62 % 3.20 % 10.55% QoQ % 0.81% 0.27% 8.55% -11.95% 6.35% 13.12% - Horiz. % 116.25% 115.31% 115.00% 105.94% 120.31% 113.12% 100.00%
ROE 6.50 % 6.28 % 6.10 % 5.23 % 5.52 % 4.90 % 4.30 % 31.68% QoQ % 3.50% 2.95% 16.63% -5.25% 12.65% 13.95% - Horiz. % 151.16% 146.05% 141.86% 121.63% 128.37% 113.95% 100.00%
Per Share 30/09/18 30/06/18 31/03/18 31/12/17 30/09/17 30/06/17 31/03/17 CAGR
RPS 251.16 241.17 233.68 212.30 191.72 169.00 155.09 37.86% QoQ % 4.14% 3.21% 10.07% 10.73% 13.44% 8.97% - Horiz. % 161.94% 155.50% 150.67% 136.89% 123.62% 108.97% 100.00%
EPS 9.36 8.92 8.60 7.22 7.50 6.62 5.72 38.82% QoQ % 4.93% 3.72% 19.11% -3.73% 13.29% 15.73% - Horiz. % 163.64% 155.94% 150.35% 126.22% 131.12% 115.73% 100.00%
DPS 1.50 1.50 1.00 1.00 1.00 1.00 0.00 - QoQ % 0.00% 50.00% 0.00% 0.00% 0.00% 0.00% - Horiz. % 150.00% 150.00% 100.00% 100.00% 100.00% 100.00% -
NAPS 1.4400 1.4200 1.4100 1.3800 1.3600 1.3500 1.3300 5.44% QoQ % 1.41% 0.71% 2.17% 1.47% 0.74% 1.50% - Horiz. % 108.27% 106.77% 106.02% 103.76% 102.26% 101.50% 100.00%
Adjusted Per Share Value based on latest NOSH - 54,620 30/09/18 30/06/18 31/03/18 31/12/17 30/09/17 30/06/17 31/03/17 CAGR
RPS 251.16 241.17 233.68 212.30 191.72 169.00 155.09 37.86% QoQ % 4.14% 3.21% 10.07% 10.73% 13.44% 8.97% - Horiz. % 161.94% 155.50% 150.67% 136.89% 123.62% 108.97% 100.00%
EPS 9.36 8.92 8.60 7.22 7.50 6.62 5.72 38.82% QoQ % 4.93% 3.72% 19.11% -3.73% 13.29% 15.73% - Horiz. % 163.64% 155.94% 150.35% 126.22% 131.12% 115.73% 100.00%
DPS 1.50 1.50 1.00 1.00 1.00 1.00 0.00 - QoQ % 0.00% 50.00% 0.00% 0.00% 0.00% 0.00% - Horiz. % 150.00% 150.00% 100.00% 100.00% 100.00% 100.00% -
NAPS 1.4400 1.4200 1.4100 1.3800 1.3600 1.3500 1.3300 5.44% QoQ % 1.41% 0.71% 2.17% 1.47% 0.74% 1.50% - Horiz. % 108.27% 106.77% 106.02% 103.76% 102.26% 101.50% 100.00%
Price Multiplier on Financial Quarter End Date 30/09/18 30/06/18 31/03/18 31/12/17 30/09/17 30/06/17 31/03/17 CAGR
Date 28/09/18 29/06/18 30/03/18 29/12/17 29/09/17 30/06/17 31/03/17 -
Price 0.6050 0.5900 0.5800 0.6400 0.6850 0.6600 0.5850 -
P/RPS 0.24 0.24 0.25 0.30 0.36 0.39 0.38 -26.37% QoQ % 0.00% -4.00% -16.67% -16.67% -7.69% 2.63% - Horiz. % 63.16% 63.16% 65.79% 78.95% 94.74% 102.63% 100.00%
P/EPS 6.46 6.62 6.74 8.86 9.13 9.97 10.22 -26.33% QoQ % -2.42% -1.78% -23.93% -2.96% -8.43% -2.45% - Horiz. % 63.21% 64.77% 65.95% 86.69% 89.33% 97.55% 100.00%
EY 15.47 15.11 14.84 11.29 10.95 10.03 9.78 35.72% QoQ % 2.38% 1.82% 31.44% 3.11% 9.17% 2.56% - Horiz. % 158.18% 154.50% 151.74% 115.44% 111.96% 102.56% 100.00%
DY 2.48 2.54 1.72 1.56 1.46 1.52 0.00 - QoQ % -2.36% 47.67% 10.26% 6.85% -3.95% 0.00% - Horiz. % 163.16% 167.11% 113.16% 102.63% 96.05% 100.00% -
P/NAPS 0.42 0.42 0.41 0.46 0.50 0.49 0.44 -3.05% QoQ % 0.00% 2.44% -10.87% -8.00% 2.04% 11.36% - Horiz. % 95.45% 95.45% 93.18% 104.55% 113.64% 111.36% 100.00%
Price Multiplier on Announcement Date 30/09/18 30/06/18 31/03/18 31/12/17 30/09/17 30/06/17 31/03/17 CAGR
Date 23/11/18 24/08/18 14/05/18 28/02/18 24/11/17 23/08/17 24/05/17 -
Price 0.6400 0.6350 0.6400 0.6300 0.6850 0.6250 0.6750 -
P/RPS 0.25 0.26 0.27 0.30 0.36 0.37 0.44 -31.38% QoQ % -3.85% -3.70% -10.00% -16.67% -2.70% -15.91% - Horiz. % 56.82% 59.09% 61.36% 68.18% 81.82% 84.09% 100.00%
P/EPS 6.84 7.12 7.44 8.72 9.13 9.44 11.79 -30.42% QoQ % -3.93% -4.30% -14.68% -4.49% -3.28% -19.93% - Horiz. % 58.02% 60.39% 63.10% 73.96% 77.44% 80.07% 100.00%
EY 14.63 14.04 13.45 11.46 10.95 10.59 8.48 43.80% QoQ % 4.20% 4.39% 17.36% 4.66% 3.40% 24.88% - Horiz. % 172.52% 165.57% 158.61% 135.14% 129.13% 124.88% 100.00%
DY 2.34 2.36 1.56 1.59 1.46 1.60 0.00 - QoQ % -0.85% 51.28% -1.89% 8.90% -8.75% 0.00% - Horiz. % 146.25% 147.50% 97.50% 99.38% 91.25% 100.00% -
P/NAPS 0.44 0.45 0.45 0.46 0.50 0.46 0.51 -9.37% QoQ % -2.22% 0.00% -2.17% -8.00% 8.70% -9.80% - Horiz. % 86.27% 88.24% 88.24% 90.20% 98.04% 90.20% 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
MPGB - Announcement 4Q17.pdf 
