Highlights

[CARLSBG] QoQ TTM Result on 2017-12-31 [#4]

Stock [CARLSBG]: CARLSBERG BREWERY MALAYSIA BHD
Announcement Date 14-Feb-2018
Admission Sponsor -
Sponsor -
Financial Year 31-Dec-2017
Quarter 31-Dec-2017  [#4]
Profit Trend QoQ -     1.35%    YoY -     7.90%
Quarter Report


View:


Show?  QoQ % Horiz. %

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 1,886,632 1,817,369 1,814,057 1,768,223 1,772,928 1,742,726 1,726,409 6.09%
  QoQ % 3.81% 0.18% 2.59% -0.27% 1.73% 0.95% -
  Horiz. % 109.28% 105.27% 105.08% 102.42% 102.69% 100.95% 100.00%
PBT 340,986 311,636 311,282 294,792 308,043 310,648 293,786 10.43%
  QoQ % 9.42% 0.11% 5.59% -4.30% -0.84% 5.74% -
  Horiz. % 116.07% 106.08% 105.96% 100.34% 104.85% 105.74% 100.00%
Tax -71,886 -65,149 -64,857 -62,414 -79,488 -82,071 -78,638 -5.80%
  QoQ % -10.34% -0.45% -3.91% 21.48% 3.15% -4.37% -
  Horiz. % 91.41% 82.85% 82.48% 79.37% 101.08% 104.37% 100.00%
NP 269,100 246,487 246,425 232,378 228,555 228,577 215,148 16.07%
  QoQ % 9.17% 0.03% 6.04% 1.67% -0.01% 6.24% -
  Horiz. % 125.08% 114.57% 114.54% 108.01% 106.23% 106.24% 100.00%
NP to SH 259,719 237,587 234,599 221,165 218,227 218,989 209,427 15.41%
  QoQ % 9.32% 1.27% 6.07% 1.35% -0.35% 4.57% -
  Horiz. % 124.01% 113.45% 112.02% 105.60% 104.20% 104.57% 100.00%
Tax Rate 21.08 % 20.91 % 20.84 % 21.17 % 25.80 % 26.42 % 26.77 % -14.71%
  QoQ % 0.81% 0.34% -1.56% -17.95% -2.35% -1.31% -
  Horiz. % 78.74% 78.11% 77.85% 79.08% 96.38% 98.69% 100.00%
Total Cost 1,617,532 1,570,882 1,567,632 1,535,845 1,544,373 1,514,149 1,511,261 4.63%
  QoQ % 2.97% 0.21% 2.07% -0.55% 2.00% 0.19% -
  Horiz. % 107.03% 103.95% 103.73% 101.63% 102.19% 100.19% 100.00%
Net Worth 165,103 162,046 388,299 311,862 262,943 256,828 397,472 -44.30%
  QoQ % 1.89% -58.27% 24.51% 18.60% 2.38% -35.38% -
  Horiz. % 41.54% 40.77% 97.69% 78.46% 66.15% 64.62% 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 393,497 344,577 327,150 266,000 235,425 235,425 220,138 47.23%
  QoQ % 14.20% 5.33% 22.99% 12.99% 0.00% 6.94% -
  Horiz. % 178.75% 156.53% 148.61% 120.83% 106.94% 106.94% 100.00%
Div Payout % 151.51 % 145.03 % 139.45 % 120.27 % 107.88 % 107.51 % 105.11 % 27.58%
  QoQ % 4.47% 4.00% 15.95% 11.48% 0.34% 2.28% -
  Horiz. % 144.14% 137.98% 132.67% 114.42% 102.64% 102.28% 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 165,103 162,046 388,299 311,862 262,943 256,828 397,472 -44.30%
  QoQ % 1.89% -58.27% 24.51% 18.60% 2.38% -35.38% -
  Horiz. % 41.54% 40.77% 97.69% 78.46% 66.15% 64.62% 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/18 30/06/18 31/03/18 31/12/17 30/09/17 30/06/17 31/03/17 CAGR
NP Margin 14.26 % 13.56 % 13.58 % 13.14 % 12.89 % 13.12 % 12.46 % 9.40%
  QoQ % 5.16% -0.15% 3.35% 1.94% -1.75% 5.30% -
  Horiz. % 114.45% 108.83% 108.99% 105.46% 103.45% 105.30% 100.00%
ROE 157.31 % 146.62 % 60.42 % 70.92 % 82.99 % 85.27 % 52.69 % 107.20%
  QoQ % 7.29% 142.67% -14.81% -14.54% -2.67% 61.83% -
  Horiz. % 298.56% 278.27% 114.67% 134.60% 157.51% 161.83% 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 617.05 594.40 593.32 578.33 579.87 569.99 564.65 6.09%
  QoQ % 3.81% 0.18% 2.59% -0.27% 1.73% 0.95% -
  Horiz. % 109.28% 105.27% 105.08% 102.42% 102.70% 100.95% 100.00%
EPS 84.95 77.71 76.73 72.34 71.37 71.62 68.50 15.41%
  QoQ % 9.32% 1.28% 6.07% 1.36% -0.35% 4.55% -
  Horiz. % 124.01% 113.45% 112.01% 105.61% 104.19% 104.55% 100.00%
DPS 128.70 112.70 107.00 87.00 77.00 77.00 72.00 47.23%
  QoQ % 14.20% 5.33% 22.99% 12.99% 0.00% 6.94% -
  Horiz. % 178.75% 156.53% 148.61% 120.83% 106.94% 106.94% 100.00%
NAPS 0.5400 0.5300 1.2700 1.0200 0.8600 0.8400 1.3000 -44.30%
  QoQ % 1.89% -58.27% 24.51% 18.60% 2.38% -35.38% -
  Horiz. % 41.54% 40.77% 97.69% 78.46% 66.15% 64.62% 100.00%
Adjusted Per Share Value based on latest NOSH - 305,748
30/09/18 30/06/18 31/03/18 31/12/17 30/09/17 30/06/17 31/03/17 CAGR
RPS 617.05 594.40 593.32 578.33 579.87 569.99 564.65 6.09%
  QoQ % 3.81% 0.18% 2.59% -0.27% 1.73% 0.95% -
  Horiz. % 109.28% 105.27% 105.08% 102.42% 102.70% 100.95% 100.00%
EPS 84.95 77.71 76.73 72.34 71.37 71.62 68.50 15.41%
  QoQ % 9.32% 1.28% 6.07% 1.36% -0.35% 4.55% -
  Horiz. % 124.01% 113.45% 112.01% 105.61% 104.19% 104.55% 100.00%
DPS 128.70 112.70 107.00 87.00 77.00 77.00 72.00 47.23%
  QoQ % 14.20% 5.33% 22.99% 12.99% 0.00% 6.94% -
  Horiz. % 178.75% 156.53% 148.61% 120.83% 106.94% 106.94% 100.00%
NAPS 0.5400 0.5300 1.2700 1.0200 0.8600 0.8400 1.3000 -44.30%
  QoQ % 1.89% -58.27% 24.51% 18.60% 2.38% -35.38% -
  Horiz. % 41.54% 40.77% 97.69% 78.46% 66.15% 64.62% 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 20.0000 19.3000 18.8800 15.3000 14.8400 15.0000 15.0000 -
P/RPS 3.24 3.25 3.18 2.65 2.56 2.63 2.66 14.04%
  QoQ % -0.31% 2.20% 20.00% 3.52% -2.66% -1.13% -
  Horiz. % 121.80% 122.18% 119.55% 99.62% 96.24% 98.87% 100.00%
P/EPS 23.54 24.84 24.61 21.15 20.79 20.94 21.90 4.93%
  QoQ % -5.23% 0.93% 16.36% 1.73% -0.72% -4.38% -
  Horiz. % 107.49% 113.42% 112.37% 96.58% 94.93% 95.62% 100.00%
EY 4.25 4.03 4.06 4.73 4.81 4.77 4.57 -4.72%
  QoQ % 5.46% -0.74% -14.16% -1.66% 0.84% 4.38% -
  Horiz. % 93.00% 88.18% 88.84% 103.50% 105.25% 104.38% 100.00%
DY 6.43 5.84 5.67 5.69 5.19 5.13 4.80 21.50%
  QoQ % 10.10% 3.00% -0.35% 9.63% 1.17% 6.87% -
  Horiz. % 133.96% 121.67% 118.12% 118.54% 108.12% 106.88% 100.00%
P/NAPS 37.04 36.42 14.87 15.00 17.26 17.86 11.54 117.44%
  QoQ % 1.70% 144.92% -0.87% -13.09% -3.36% 54.77% -
  Horiz. % 320.97% 315.60% 128.86% 129.98% 149.57% 154.77% 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 30/11/18 16/08/18 17/05/18 14/02/18 30/11/17 17/08/17 17/05/17 -
Price 19.7200 19.0000 19.6200 16.6600 15.1600 14.7000 14.8000 -
P/RPS 3.20 3.20 3.31 2.88 2.61 2.58 2.62 14.25%
  QoQ % 0.00% -3.32% 14.93% 10.34% 1.16% -1.53% -
  Horiz. % 122.14% 122.14% 126.34% 109.92% 99.62% 98.47% 100.00%
P/EPS 23.21 24.45 25.57 23.03 21.24 20.52 21.61 4.87%
  QoQ % -5.07% -4.38% 11.03% 8.43% 3.51% -5.04% -
  Horiz. % 107.40% 113.14% 118.32% 106.57% 98.29% 94.96% 100.00%
EY 4.31 4.09 3.91 4.34 4.71 4.87 4.63 -4.66%
  QoQ % 5.38% 4.60% -9.91% -7.86% -3.29% 5.18% -
  Horiz. % 93.09% 88.34% 84.45% 93.74% 101.73% 105.18% 100.00%
DY 6.53 5.93 5.45 5.22 5.08 5.24 4.86 21.74%
  QoQ % 10.12% 8.81% 4.41% 2.76% -3.05% 7.82% -
  Horiz. % 134.36% 122.02% 112.14% 107.41% 104.53% 107.82% 100.00%
P/NAPS 36.52 35.85 15.45 16.33 17.63 17.50 11.38 117.41%
  QoQ % 1.87% 132.04% -5.39% -7.37% 0.74% 53.78% -
  Horiz. % 320.91% 315.03% 135.76% 143.50% 154.92% 153.78% 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.
 


APPS
I3 Messenger
Individual or Group chat with anyone on I3investor
MQ Trader
Earn MQ Points while trading with MQ Traders Group
MQ Affiliate
Earn side income from MQ Affiliate Program
 
 

457  576  569  492 

ActiveGainersLosers
Top 10 Active Counters
 NameLastChange 
 VSOLAR 0.040.00 
 SAMAIDEN 1.72+0.04 
 PNEPCB 0.34-0.04 
 PA 0.1750.00 
 CYPARK 1.38+0.04 
 ARBB 0.29+0.015 
 KTG 0.265-0.005 
 QES 0.335-0.02 
 CONNECT 0.2250.00 
 SUNZEN 0.235+0.015 

FEATURED POSTS

1. The Equity Market Index Benchmark in Malaysia CMS
2. Trading Scenarios of Derivatives Bursa Derivatives Education Series
3. Derivatives 101 Bursa Derivatives Education Series
4. Why Trade FKLI? Bursa Derivatives Education Series
5. MQ Trader - Introduction to MQ Trader Affiliate Program MQ Trader Announcement!
PARTNERS & BROKERS