[CARLSBG] QoQ Annualized Quarter Result on 2018-12-31 [#4] View: Quarter
Cumulative
T4Q
Annualized
Annual (Unaudited)
Show? QoQ % Horiz. %
Annualized Quarter Result 30/09/19 30/06/19 31/03/19 31/12/18 30/09/18 30/06/18 31/03/18 CAGR
Revenue 2,243,553 2,280,890 2,639,684 1,982,342 1,942,257 1,927,848 2,193,880 1.50% QoQ % -1.64% -13.59% 33.16% 2.06% 0.75% -12.13% - Horiz. % 102.26% 103.97% 120.32% 90.36% 88.53% 87.87% 100.00%
PBT 385,864 398,436 455,264 361,260 363,997 376,642 417,972 -5.18% QoQ % -3.16% -12.48% 26.02% -0.75% -3.36% -9.89% - Horiz. % 92.32% 95.33% 108.92% 86.43% 87.09% 90.11% 100.00%
Tax -81,260 -85,078 -98,216 -74,503 -75,224 -78,784 -87,692 -4.95% QoQ % 4.49% 13.38% -31.83% 0.96% 4.52% 10.16% - Horiz. % 92.67% 97.02% 112.00% 84.96% 85.78% 89.84% 100.00%
NP 304,604 313,358 357,048 286,757 288,773 297,858 330,280 -5.25% QoQ % -2.79% -12.24% 24.51% -0.70% -3.05% -9.82% - Horiz. % 92.23% 94.88% 108.10% 86.82% 87.43% 90.18% 100.00%
NP to SH 296,033 305,716 350,412 277,154 279,602 289,468 323,292 -5.70% QoQ % -3.17% -12.76% 26.43% -0.88% -3.41% -10.46% - Horiz. % 91.57% 94.56% 108.39% 85.73% 86.49% 89.54% 100.00%
Tax Rate 21.06 % 21.35 % 21.57 % 20.62 % 20.67 % 20.92 % 20.98 % 0.25% QoQ % -1.36% -1.02% 4.61% -0.24% -1.20% -0.29% - Horiz. % 100.38% 101.76% 102.81% 98.28% 98.52% 99.71% 100.00%
Total Cost 1,938,949 1,967,532 2,282,636 1,695,585 1,653,484 1,629,990 1,863,600 2.68% QoQ % -1.45% -13.80% 34.62% 2.55% 1.44% -12.54% - Horiz. % 104.04% 105.58% 122.49% 90.98% 88.73% 87.46% 100.00%
Net Worth 140,644 125,356 223,196 180,391 165,103 162,046 388,299 -49.16% QoQ % 12.20% -43.84% 23.73% 9.26% 1.89% -58.27% - Horiz. % 36.22% 32.28% 57.48% 46.46% 42.52% 41.73% 100.00%
Dividend 30/09/19 30/06/19 31/03/19 31/12/18 30/09/18 30/06/18 31/03/18 CAGR
Div 222,584 229,922 262,943 305,748 210,762 218,304 244,598 -6.09% QoQ % -3.19% -12.56% -14.00% 45.07% -3.45% -10.75% - Horiz. % 91.00% 94.00% 107.50% 125.00% 86.17% 89.25% 100.00%
Div Payout % 75.19 % 75.21 % 75.04 % 110.32 % 75.38 % 75.42 % 75.66 % -0.41% QoQ % -0.03% 0.23% -31.98% 46.35% -0.05% -0.32% - Horiz. % 99.38% 99.41% 99.18% 145.81% 99.63% 99.68% 100.00%
Equity 30/09/19 30/06/19 31/03/19 31/12/18 30/09/18 30/06/18 31/03/18 CAGR
Net Worth 140,644 125,356 223,196 180,391 165,103 162,046 388,299 -49.16% QoQ % 12.20% -43.84% 23.73% 9.26% 1.89% -58.27% - Horiz. % 36.22% 32.28% 57.48% 46.46% 42.52% 41.73% 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 30/09/19 30/06/19 31/03/19 31/12/18 30/09/18 30/06/18 31/03/18 CAGR
NP Margin 13.58 % 13.74 % 13.53 % 14.47 % 14.87 % 15.45 % 15.05 % -6.62% QoQ % -1.16% 1.55% -6.50% -2.69% -3.75% 2.66% - Horiz. % 90.23% 91.30% 89.90% 96.15% 98.80% 102.66% 100.00%
ROE 210.48 % 243.88 % 157.00 % 153.64 % 169.35 % 178.63 % 83.26 % 85.47% QoQ % -13.70% 55.34% 2.19% -9.28% -5.20% 114.54% - Horiz. % 252.80% 292.91% 188.57% 184.53% 203.40% 214.54% 100.00%
Per Share 30/09/19 30/06/19 31/03/19 31/12/18 30/09/18 30/06/18 31/03/18 CAGR
RPS 733.79 746.00 863.35 648.36 635.25 630.54 717.55 1.50% QoQ % -1.64% -13.59% 33.16% 2.06% 0.75% -12.13% - Horiz. % 102.26% 103.96% 120.32% 90.36% 88.53% 87.87% 100.00%
EPS 96.83 99.98 114.60 90.65 91.45 94.68 105.72 -5.68% QoQ % -3.15% -12.76% 26.42% -0.87% -3.41% -10.44% - Horiz. % 91.59% 94.57% 108.40% 85.75% 86.50% 89.56% 100.00%
DPS 72.80 75.20 86.00 100.00 68.93 71.40 80.00 -6.09% QoQ % -3.19% -12.56% -14.00% 45.07% -3.46% -10.75% - Horiz. % 91.00% 94.00% 107.50% 125.00% 86.16% 89.25% 100.00%
NAPS 0.4600 0.4100 0.7300 0.5900 0.5400 0.5300 1.2700 -49.16% QoQ % 12.20% -43.84% 23.73% 9.26% 1.89% -58.27% - Horiz. % 36.22% 32.28% 57.48% 46.46% 42.52% 41.73% 100.00%
Adjusted Per Share Value based on latest NOSH - 305,748 30/09/19 30/06/19 31/03/19 31/12/18 30/09/18 30/06/18 31/03/18 CAGR
RPS 733.79 746.00 863.35 648.36 635.25 630.54 717.55 1.50% QoQ % -1.64% -13.59% 33.16% 2.06% 0.75% -12.13% - Horiz. % 102.26% 103.96% 120.32% 90.36% 88.53% 87.87% 100.00%
EPS 96.83 99.98 114.60 90.65 91.45 94.68 105.72 -5.68% QoQ % -3.15% -12.76% 26.42% -0.87% -3.41% -10.44% - Horiz. % 91.59% 94.57% 108.40% 85.75% 86.50% 89.56% 100.00%
DPS 72.80 75.20 86.00 100.00 68.93 71.40 80.00 -6.09% QoQ % -3.19% -12.56% -14.00% 45.07% -3.46% -10.75% - Horiz. % 91.00% 94.00% 107.50% 125.00% 86.16% 89.25% 100.00%
NAPS 0.4600 0.4100 0.7300 0.5900 0.5400 0.5300 1.2700 -49.16% QoQ % 12.20% -43.84% 23.73% 9.26% 1.89% -58.27% - Horiz. % 36.22% 32.28% 57.48% 46.46% 42.52% 41.73% 100.00%
Price Multiplier on Financial Quarter End Date 30/09/19 30/06/19 31/03/19 31/12/18 30/09/18 30/06/18 31/03/18 CAGR
Date 30/09/19 28/06/19 29/03/19 31/12/18 28/09/18 29/06/18 30/03/18 -
Price 26.2600 25.6600 26.7400 19.6800 20.0000 19.3000 18.8800 -
P/RPS 3.58 3.44 3.10 3.04 3.15 3.06 2.63 22.80% QoQ % 4.07% 10.97% 1.97% -3.49% 2.94% 16.35% - Horiz. % 136.12% 130.80% 117.87% 115.59% 119.77% 116.35% 100.00%
P/EPS 27.12 25.66 23.33 21.71 21.87 20.39 17.86 32.08% QoQ % 5.69% 9.99% 7.46% -0.73% 7.26% 14.17% - Horiz. % 151.85% 143.67% 130.63% 121.56% 122.45% 114.17% 100.00%
EY 3.69 3.90 4.29 4.61 4.57 4.91 5.60 -24.26% QoQ % -5.38% -9.09% -6.94% 0.88% -6.92% -12.32% - Horiz. % 65.89% 69.64% 76.61% 82.32% 81.61% 87.68% 100.00%
DY 2.77 2.93 3.22 5.08 3.45 3.70 4.24 -24.69% QoQ % -5.46% -9.01% -36.61% 47.25% -6.76% -12.74% - Horiz. % 65.33% 69.10% 75.94% 119.81% 81.37% 87.26% 100.00%
P/NAPS 57.09 62.59 36.63 33.36 37.04 36.42 14.87 144.99% QoQ % -8.79% 70.87% 9.80% -9.94% 1.70% 144.92% - Horiz. % 383.93% 420.91% 246.33% 224.34% 249.09% 244.92% 100.00%
Price Multiplier on Announcement Date 30/09/19 30/06/19 31/03/19 31/12/18 30/09/18 30/06/18 31/03/18 CAGR
Date 26/11/19 15/08/19 16/05/19 14/02/19 30/11/18 16/08/18 17/05/18 -
Price 27.0000 24.0400 24.2400 21.5800 19.7200 19.0000 19.6200 -
P/RPS 3.68 3.22 2.81 3.33 3.10 3.01 2.73 22.01% QoQ % 14.29% 14.59% -15.62% 7.42% 2.99% 10.26% - Horiz. % 134.80% 117.95% 102.93% 121.98% 113.55% 110.26% 100.00%
P/EPS 27.89 24.04 21.15 23.81 21.56 20.07 18.56 31.16% QoQ % 16.01% 13.66% -11.17% 10.44% 7.42% 8.14% - Horiz. % 150.27% 129.53% 113.95% 128.29% 116.16% 108.14% 100.00%
EY 3.59 4.16 4.73 4.20 4.64 4.98 5.39 -23.71% QoQ % -13.70% -12.05% 12.62% -9.48% -6.83% -7.61% - Horiz. % 66.60% 77.18% 87.76% 77.92% 86.09% 92.39% 100.00%
DY 2.70 3.13 3.55 4.63 3.50 3.76 4.08 -24.04% QoQ % -13.74% -11.83% -23.33% 32.29% -6.91% -7.84% - Horiz. % 66.18% 76.72% 87.01% 113.48% 85.78% 92.16% 100.00%
P/NAPS 58.70 58.63 33.21 36.58 36.52 35.85 15.45 143.29% QoQ % 0.12% 76.54% -9.21% 0.16% 1.87% 132.04% - Horiz. % 379.94% 379.48% 214.95% 236.76% 236.38% 232.04% 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