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.
 


 

308  374  520  783 

ActiveGainersLosers
Top 10 Active Counters
 NameLastChange 
 PWRWELL 0.29+0.005 
 MTOUCHE-WC 0.01-0.015 
 HSI-H8K 0.195+0.06 
 DGB 0.13-0.005 
 MTOUCHE 0.17-0.005 
 HSI-C7K 0.275-0.12 
 VC 0.075-0.01 
 SAPNRG 0.27+0.005 
 XDL-WD 0.015-0.005 
 XDL 0.16-0.005 

FEATURED POSTS

1. Leveraged & Inverse ETF CMS
Partners & Brokers