[CARLSBG] QoQ TTM Result on 2019-06-30 [#2] View: Quarter
Cumulative
T4Q
Annualized
Annual (Unaudited)
Show?
TTM Result 31/03/20 31/12/19 30/09/19 30/06/19 31/03/19 31/12/18 30/09/18 CAGR
Revenue 2,186,533 2,256,582 2,208,316 2,158,865 2,093,795 1,982,344 1,886,632 10.32% QoQ % -3.10% 2.19% 2.29% 3.11% 5.62% 5.07% - Horiz. % 115.90% 119.61% 117.05% 114.43% 110.98% 105.07% 100.00%
PBT 363,667 382,237 377,657 372,164 370,590 361,267 340,986 4.38% QoQ % -4.86% 1.21% 1.48% 0.42% 2.58% 5.95% - Horiz. % 106.65% 112.10% 110.75% 109.14% 108.68% 105.95% 100.00%
Tax -78,366 -81,853 -79,031 -77,650 -77,134 -74,503 -71,886 5.92% QoQ % 4.26% -3.57% -1.78% -0.67% -3.53% -3.64% - Horiz. % 109.01% 113.87% 109.94% 108.02% 107.30% 103.64% 100.00%
NP 285,301 300,384 298,626 294,514 293,456 286,764 269,100 3.97% QoQ % -5.02% 0.59% 1.40% 0.36% 2.33% 6.56% - Horiz. % 106.02% 111.63% 110.97% 109.44% 109.05% 106.56% 100.00%
NP to SH 276,394 291,041 289,490 285,285 283,941 277,161 259,719 4.23% QoQ % -5.03% 0.54% 1.47% 0.47% 2.45% 6.72% - Horiz. % 106.42% 112.06% 111.46% 109.84% 109.33% 106.72% 100.00%
Tax Rate 21.55 % 21.41 % 20.93 % 20.86 % 20.81 % 20.62 % 21.08 % 1.48% QoQ % 0.65% 2.29% 0.34% 0.24% 0.92% -2.18% - Horiz. % 102.23% 101.57% 99.29% 98.96% 98.72% 97.82% 100.00%
Total Cost 1,901,232 1,956,198 1,909,690 1,864,351 1,800,339 1,695,580 1,617,532 11.36% QoQ % -2.81% 2.44% 2.43% 3.56% 6.18% 4.83% - Horiz. % 117.54% 120.94% 118.06% 115.26% 111.30% 104.83% 100.00%
Net Worth 177,333 155,931 140,644 125,356 223,196 180,391 165,103 4.87% QoQ % 13.73% 10.87% 12.20% -43.84% 23.73% 9.26% - Horiz. % 107.41% 94.44% 85.19% 75.93% 135.19% 109.26% 100.00%
Dividend 31/03/20 31/12/19 30/09/19 30/06/19 31/03/19 31/12/18 30/09/18 CAGR
Div 240,012 305,748 314,614 311,557 310,334 305,747 393,497 -28.06% QoQ % -21.50% -2.82% 0.98% 0.39% 1.50% -22.30% - Horiz. % 60.99% 77.70% 79.95% 79.18% 78.87% 77.70% 100.00%
Div Payout % 86.84 % 105.05 % 108.68 % 109.21 % 109.30 % 110.31 % 151.51 % -30.98% QoQ % -17.33% -3.34% -0.49% -0.08% -0.92% -27.19% - Horiz. % 57.32% 69.34% 71.73% 72.08% 72.14% 72.81% 100.00%
Equity 31/03/20 31/12/19 30/09/19 30/06/19 31/03/19 31/12/18 30/09/18 CAGR
Net Worth 177,333 155,931 140,644 125,356 223,196 180,391 165,103 4.87% QoQ % 13.73% 10.87% 12.20% -43.84% 23.73% 9.26% - Horiz. % 107.41% 94.44% 85.19% 75.93% 135.19% 109.26% 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/03/20 31/12/19 30/09/19 30/06/19 31/03/19 31/12/18 30/09/18 CAGR
NP Margin 13.05 % 13.31 % 13.52 % 13.64 % 14.02 % 14.47 % 14.26 % -5.73% QoQ % -1.95% -1.55% -0.88% -2.71% -3.11% 1.47% - Horiz. % 91.51% 93.34% 94.81% 95.65% 98.32% 101.47% 100.00%
ROE 155.86 % 186.65 % 205.83 % 227.58 % 127.22 % 153.64 % 157.31 % -0.61% QoQ % -16.50% -9.32% -9.56% 78.89% -17.20% -2.33% - Horiz. % 99.08% 118.65% 130.84% 144.67% 80.87% 97.67% 100.00%
Per Share 31/03/20 31/12/19 30/09/19 30/06/19 31/03/19 31/12/18 30/09/18 CAGR
RPS 715.14 738.05 722.27 706.09 684.81 648.36 617.05 10.33% QoQ % -3.10% 2.18% 2.29% 3.11% 5.62% 5.07% - Horiz. % 115.90% 119.61% 117.05% 114.43% 110.98% 105.07% 100.00%
EPS 90.40 95.19 94.68 93.31 92.87 90.65 84.95 4.23% QoQ % -5.03% 0.54% 1.47% 0.47% 2.45% 6.71% - Horiz. % 106.42% 112.05% 111.45% 109.84% 109.32% 106.71% 100.00%
DPS 78.50 100.00 102.90 101.90 101.50 100.00 128.70 -28.06% QoQ % -21.50% -2.82% 0.98% 0.39% 1.50% -22.30% - Horiz. % 60.99% 77.70% 79.95% 79.18% 78.87% 77.70% 100.00%
NAPS 0.5800 0.5100 0.4600 0.4100 0.7300 0.5900 0.5400 4.87% QoQ % 13.73% 10.87% 12.20% -43.84% 23.73% 9.26% - Horiz. % 107.41% 94.44% 85.19% 75.93% 135.19% 109.26% 100.00%
Adjusted Per Share Value based on latest NOSH - 305,748 31/03/20 31/12/19 30/09/19 30/06/19 31/03/19 31/12/18 30/09/18 CAGR
RPS 715.14 738.05 722.27 706.09 684.81 648.36 617.05 10.33% QoQ % -3.10% 2.18% 2.29% 3.11% 5.62% 5.07% - Horiz. % 115.90% 119.61% 117.05% 114.43% 110.98% 105.07% 100.00%
EPS 90.40 95.19 94.68 93.31 92.87 90.65 84.95 4.23% QoQ % -5.03% 0.54% 1.47% 0.47% 2.45% 6.71% - Horiz. % 106.42% 112.05% 111.45% 109.84% 109.32% 106.71% 100.00%
DPS 78.50 100.00 102.90 101.90 101.50 100.00 128.70 -28.06% QoQ % -21.50% -2.82% 0.98% 0.39% 1.50% -22.30% - Horiz. % 60.99% 77.70% 79.95% 79.18% 78.87% 77.70% 100.00%
NAPS 0.5800 0.5100 0.4600 0.4100 0.7300 0.5900 0.5400 4.87% QoQ % 13.73% 10.87% 12.20% -43.84% 23.73% 9.26% - Horiz. % 107.41% 94.44% 85.19% 75.93% 135.19% 109.26% 100.00%
Price Multiplier on Financial Quarter End Date 31/03/20 31/12/19 30/09/19 30/06/19 31/03/19 31/12/18 30/09/18 CAGR
Date 31/03/20 31/12/19 30/09/19 28/06/19 29/03/19 31/12/18 28/09/18 -
Price 25.0000 29.4000 26.2600 25.6600 26.7400 19.6800 20.0000 -
P/RPS 3.50 3.98 3.64 3.63 3.90 3.04 3.24 5.28% QoQ % -12.06% 9.34% 0.28% -6.92% 28.29% -6.17% - Horiz. % 108.02% 122.84% 112.35% 112.04% 120.37% 93.83% 100.00%
P/EPS 27.66 30.89 27.73 27.50 28.79 21.71 23.54 11.34% QoQ % -10.46% 11.40% 0.84% -4.48% 32.61% -7.77% - Horiz. % 117.50% 131.22% 117.80% 116.82% 122.30% 92.23% 100.00%
EY 3.62 3.24 3.61 3.64 3.47 4.61 4.25 -10.14% QoQ % 11.73% -10.25% -0.82% 4.90% -24.73% 8.47% - Horiz. % 85.18% 76.24% 84.94% 85.65% 81.65% 108.47% 100.00%
DY 3.14 3.40 3.92 3.97 3.80 5.08 6.43 -37.96% QoQ % -7.65% -13.27% -1.26% 4.47% -25.20% -21.00% - Horiz. % 48.83% 52.88% 60.96% 61.74% 59.10% 79.00% 100.00%
P/NAPS 43.10 57.65 57.09 62.59 36.63 33.36 37.04 10.62% QoQ % -25.24% 0.98% -8.79% 70.87% 9.80% -9.94% - Horiz. % 116.36% 155.64% 154.13% 168.98% 98.89% 90.06% 100.00%
Price Multiplier on Announcement Date 31/03/20 31/12/19 30/09/19 30/06/19 31/03/19 31/12/18 30/09/18 CAGR
Date 29/05/20 21/02/20 26/11/19 15/08/19 16/05/19 14/02/19 30/11/18 -
Price 28.8800 38.9400 27.0000 24.0400 24.2400 21.5800 19.7200 -
P/RPS 4.04 5.28 3.74 3.40 3.54 3.33 3.20 16.80% QoQ % -23.48% 41.18% 10.00% -3.95% 6.31% 4.06% - Horiz. % 126.25% 165.00% 116.87% 106.25% 110.62% 104.06% 100.00%
P/EPS 31.95 40.91 28.52 25.76 26.10 23.81 23.21 23.72% QoQ % -21.90% 43.44% 10.71% -1.30% 9.62% 2.59% - Horiz. % 137.66% 176.26% 122.88% 110.99% 112.45% 102.59% 100.00%
EY 3.13 2.44 3.51 3.88 3.83 4.20 4.31 -19.19% QoQ % 28.28% -30.48% -9.54% 1.31% -8.81% -2.55% - Horiz. % 72.62% 56.61% 81.44% 90.02% 88.86% 97.45% 100.00%
DY 2.72 2.57 3.81 4.24 4.19 4.63 6.53 -44.20% QoQ % 5.84% -32.55% -10.14% 1.19% -9.50% -29.10% - Horiz. % 41.65% 39.36% 58.35% 64.93% 64.17% 70.90% 100.00%
P/NAPS 49.79 76.35 58.70 58.63 33.21 36.58 36.52 22.93% QoQ % -34.79% 30.07% 0.12% 76.54% -9.21% 0.16% - Horiz. % 136.34% 209.06% 160.73% 160.54% 90.94% 100.16% 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
Q2_2019_Interim Report.pdf 
