[CARLSBG] QoQ TTM Result on 2018-03-31 [#1] View: Quarter
Cumulative
T4Q
Annualized
Annual (Unaudited)
Show?
TTM Result 31/12/18 30/09/18 30/06/18 31/03/18 31/12/17 30/09/17 30/06/17 CAGR
Revenue 1,982,344 1,886,632 1,817,369 1,814,057 1,768,223 1,772,928 1,742,726 8.94% QoQ % 5.07% 3.81% 0.18% 2.59% -0.27% 1.73% - Horiz. % 113.75% 108.26% 104.28% 104.09% 101.46% 101.73% 100.00%
PBT 361,267 340,986 311,636 311,282 294,792 308,043 310,648 10.56% QoQ % 5.95% 9.42% 0.11% 5.59% -4.30% -0.84% - Horiz. % 116.29% 109.77% 100.32% 100.20% 94.90% 99.16% 100.00%
Tax -74,503 -71,886 -65,149 -64,857 -62,414 -79,488 -82,071 -6.23% QoQ % -3.64% -10.34% -0.45% -3.91% 21.48% 3.15% - Horiz. % 90.78% 87.59% 79.38% 79.03% 76.05% 96.85% 100.00%
NP 286,764 269,100 246,487 246,425 232,378 228,555 228,577 16.27% QoQ % 6.56% 9.17% 0.03% 6.04% 1.67% -0.01% - Horiz. % 125.46% 117.73% 107.84% 107.81% 101.66% 99.99% 100.00%
NP to SH 277,161 259,719 237,587 234,599 221,165 218,227 218,989 16.96% QoQ % 6.72% 9.32% 1.27% 6.07% 1.35% -0.35% - Horiz. % 126.56% 118.60% 108.49% 107.13% 100.99% 99.65% 100.00%
Tax Rate 20.62 % 21.08 % 20.91 % 20.84 % 21.17 % 25.80 % 26.42 % -15.19% QoQ % -2.18% 0.81% 0.34% -1.56% -17.95% -2.35% - Horiz. % 78.05% 79.79% 79.14% 78.88% 80.13% 97.65% 100.00%
Total Cost 1,695,580 1,617,532 1,570,882 1,567,632 1,535,845 1,544,373 1,514,149 7.81% QoQ % 4.83% 2.97% 0.21% 2.07% -0.55% 2.00% - Horiz. % 111.98% 106.83% 103.75% 103.53% 101.43% 102.00% 100.00%
Net Worth 180,391 165,103 162,046 388,299 311,862 262,943 256,828 -20.93% QoQ % 9.26% 1.89% -58.27% 24.51% 18.60% 2.38% - Horiz. % 70.24% 64.29% 63.10% 151.19% 121.43% 102.38% 100.00%
Dividend 31/12/18 30/09/18 30/06/18 31/03/18 31/12/17 30/09/17 30/06/17 CAGR
Div 305,747 393,497 344,577 327,150 266,000 235,425 235,425 18.98% QoQ % -22.30% 14.20% 5.33% 22.99% 12.99% 0.00% - Horiz. % 129.87% 167.14% 146.36% 138.96% 112.99% 100.00% 100.00%
Div Payout % 110.31 % 151.51 % 145.03 % 139.45 % 120.27 % 107.88 % 107.51 % 1.72% QoQ % -27.19% 4.47% 4.00% 15.95% 11.48% 0.34% - Horiz. % 102.60% 140.93% 134.90% 129.71% 111.87% 100.34% 100.00%
Equity 31/12/18 30/09/18 30/06/18 31/03/18 31/12/17 30/09/17 30/06/17 CAGR
Net Worth 180,391 165,103 162,046 388,299 311,862 262,943 256,828 -20.93% QoQ % 9.26% 1.89% -58.27% 24.51% 18.60% 2.38% - Horiz. % 70.24% 64.29% 63.10% 151.19% 121.43% 102.38% 100.00%
NOSH 305,748 305,748 305,748 305,748 305,748 305,748 305,748 - 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 31/12/18 30/09/18 30/06/18 31/03/18 31/12/17 30/09/17 30/06/17 CAGR
NP Margin 14.47 % 14.26 % 13.56 % 13.58 % 13.14 % 12.89 % 13.12 % 6.73% QoQ % 1.47% 5.16% -0.15% 3.35% 1.94% -1.75% - Horiz. % 110.29% 108.69% 103.35% 103.51% 100.15% 98.25% 100.00%
ROE 153.64 % 157.31 % 146.62 % 60.42 % 70.92 % 82.99 % 85.27 % 47.91% QoQ % -2.33% 7.29% 142.67% -14.81% -14.54% -2.67% - Horiz. % 180.18% 184.48% 171.95% 70.86% 83.17% 97.33% 100.00%
Per Share 31/12/18 30/09/18 30/06/18 31/03/18 31/12/17 30/09/17 30/06/17 CAGR
RPS 648.36 617.05 594.40 593.32 578.33 579.87 569.99 8.94% QoQ % 5.07% 3.81% 0.18% 2.59% -0.27% 1.73% - Horiz. % 113.75% 108.26% 104.28% 104.09% 101.46% 101.73% 100.00%
EPS 90.65 84.95 77.71 76.73 72.34 71.37 71.62 16.96% QoQ % 6.71% 9.32% 1.28% 6.07% 1.36% -0.35% - Horiz. % 126.57% 118.61% 108.50% 107.13% 101.01% 99.65% 100.00%
DPS 100.00 128.70 112.70 107.00 87.00 77.00 77.00 18.98% QoQ % -22.30% 14.20% 5.33% 22.99% 12.99% 0.00% - Horiz. % 129.87% 167.14% 146.36% 138.96% 112.99% 100.00% 100.00%
NAPS 0.5900 0.5400 0.5300 1.2700 1.0200 0.8600 0.8400 -20.93% QoQ % 9.26% 1.89% -58.27% 24.51% 18.60% 2.38% - Horiz. % 70.24% 64.29% 63.10% 151.19% 121.43% 102.38% 100.00%
Adjusted Per Share Value based on latest NOSH - 305,748 31/12/18 30/09/18 30/06/18 31/03/18 31/12/17 30/09/17 30/06/17 CAGR
RPS 648.36 617.05 594.40 593.32 578.33 579.87 569.99 8.94% QoQ % 5.07% 3.81% 0.18% 2.59% -0.27% 1.73% - Horiz. % 113.75% 108.26% 104.28% 104.09% 101.46% 101.73% 100.00%
EPS 90.65 84.95 77.71 76.73 72.34 71.37 71.62 16.96% QoQ % 6.71% 9.32% 1.28% 6.07% 1.36% -0.35% - Horiz. % 126.57% 118.61% 108.50% 107.13% 101.01% 99.65% 100.00%
DPS 100.00 128.70 112.70 107.00 87.00 77.00 77.00 18.98% QoQ % -22.30% 14.20% 5.33% 22.99% 12.99% 0.00% - Horiz. % 129.87% 167.14% 146.36% 138.96% 112.99% 100.00% 100.00%
NAPS 0.5900 0.5400 0.5300 1.2700 1.0200 0.8600 0.8400 -20.93% QoQ % 9.26% 1.89% -58.27% 24.51% 18.60% 2.38% - Horiz. % 70.24% 64.29% 63.10% 151.19% 121.43% 102.38% 100.00%
Price Multiplier on Financial Quarter End Date 31/12/18 30/09/18 30/06/18 31/03/18 31/12/17 30/09/17 30/06/17 CAGR
Date 31/12/18 28/09/18 29/06/18 30/03/18 29/12/17 29/09/17 30/06/17 -
Price 19.6800 20.0000 19.3000 18.8800 15.3000 14.8400 15.0000 -
P/RPS 3.04 3.24 3.25 3.18 2.65 2.56 2.63 10.11% QoQ % -6.17% -0.31% 2.20% 20.00% 3.52% -2.66% - Horiz. % 115.59% 123.19% 123.57% 120.91% 100.76% 97.34% 100.00%
P/EPS 21.71 23.54 24.84 24.61 21.15 20.79 20.94 2.43% QoQ % -7.77% -5.23% 0.93% 16.36% 1.73% -0.72% - Horiz. % 103.68% 112.42% 118.62% 117.53% 101.00% 99.28% 100.00%
EY 4.61 4.25 4.03 4.06 4.73 4.81 4.77 -2.24% QoQ % 8.47% 5.46% -0.74% -14.16% -1.66% 0.84% - Horiz. % 96.65% 89.10% 84.49% 85.12% 99.16% 100.84% 100.00%
DY 5.08 6.43 5.84 5.67 5.69 5.19 5.13 -0.65% QoQ % -21.00% 10.10% 3.00% -0.35% 9.63% 1.17% - Horiz. % 99.03% 125.34% 113.84% 110.53% 110.92% 101.17% 100.00%
P/NAPS 33.36 37.04 36.42 14.87 15.00 17.26 17.86 51.50% QoQ % -9.94% 1.70% 144.92% -0.87% -13.09% -3.36% - Horiz. % 186.79% 207.39% 203.92% 83.26% 83.99% 96.64% 100.00%
Price Multiplier on Announcement Date 31/12/18 30/09/18 30/06/18 31/03/18 31/12/17 30/09/17 30/06/17 CAGR
Date 14/02/19 30/11/18 16/08/18 17/05/18 14/02/18 30/11/17 17/08/17 -
Price 21.5800 19.7200 19.0000 19.6200 16.6600 15.1600 14.7000 -
P/RPS 3.33 3.20 3.20 3.31 2.88 2.61 2.58 18.49% QoQ % 4.06% 0.00% -3.32% 14.93% 10.34% 1.16% - Horiz. % 129.07% 124.03% 124.03% 128.29% 111.63% 101.16% 100.00%
P/EPS 23.81 23.21 24.45 25.57 23.03 21.24 20.52 10.39% QoQ % 2.59% -5.07% -4.38% 11.03% 8.43% 3.51% - Horiz. % 116.03% 113.11% 119.15% 124.61% 112.23% 103.51% 100.00%
EY 4.20 4.31 4.09 3.91 4.34 4.71 4.87 -9.37% QoQ % -2.55% 5.38% 4.60% -9.91% -7.86% -3.29% - Horiz. % 86.24% 88.50% 83.98% 80.29% 89.12% 96.71% 100.00%
DY 4.63 6.53 5.93 5.45 5.22 5.08 5.24 -7.90% QoQ % -29.10% 10.12% 8.81% 4.41% 2.76% -3.05% - Horiz. % 88.36% 124.62% 113.17% 104.01% 99.62% 96.95% 100.00%
P/NAPS 36.58 36.52 35.85 15.45 16.33 17.63 17.50 63.26% QoQ % 0.16% 1.87% 132.04% -5.39% -7.37% 0.74% - Horiz. % 209.03% 208.69% 204.86% 88.29% 93.31% 100.74% 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
Q1_2018_Interim Report.pdf 
