[CARLSBG] QoQ TTM Result on 31-Mar-2007 [#1]

Stock

[CARLSBG] CARLSBERG BREWERY MALAYSIA BHD

Announcement Date

31-May-2007

Admission Sponsor

Sponsor

Financial Year

31-Dec-2007

Quarter

31-Mar-2007 [#1]

Profit Trend

QoQ- -25.12%

YoY- -33.71%

Quarter Report

Q1 2007 Interim Report.doc

Latest QR

Upcoming QR

CARLSBG's Result

CARLSBG's Financial Summary

View:

Show?

YoY %

Horiz. %

	31/12/07	30/09/07	30/06/07	31/03/07	31/12/06	30/09/06	30/06/06	CAGR
TTM Result
Revenue	897,510	872,425	884,453	919,092	929,744	913,779	910,863	-0.97%
YoY %	2.88%	-1.36%	-3.77%	-1.15%	1.75%	0.32%	-	-
Horiz. %	98.53%	95.78%	97.10%	100.90%	102.07%	100.32%	100.00%	-
PBT	97,705	74,472	74,063	82,712	110,423	126,327	131,837	-18.06%
YoY %	31.20%	0.55%	-10.46%	-25.10%	-12.59%	-4.18%	-	-
Horiz. %	74.11%	56.49%	56.18%	62.74%	83.76%	95.82%	100.00%	-
Tax	-19,212	-14,637	-16,493	-18,383	-24,519	-31,310	-30,872	-27.04%
YoY %	-31.26%	11.25%	10.28%	25.03%	21.69%	-1.42%	-	-
Horiz. %	62.23%	47.41%	53.42%	59.55%	79.42%	101.42%	100.00%	-
NP	78,493	59,835	57,570	64,329	85,904	95,017	100,965	-15.41%
YoY %	31.18%	3.93%	-10.51%	-25.12%	-9.59%	-5.89%	-	-
Horiz. %	77.74%	59.26%	57.02%	63.71%	85.08%	94.11%	100.00%	-
								-
YoY %	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	-	-
Horiz. %	-	-	-	-	-	-	-	-
NP to SH	78,493	59,835	57,570	64,329	85,904	95,017	100,965	-15.41%
YoY %	31.18%	3.93%	-10.51%	-25.12%	-9.59%	-5.89%	-	-
Horiz. %	77.74%	59.26%	57.02%	63.71%	85.08%	94.11%	100.00%	-
								-
YoY %	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	-	-
Horiz. %	-	-	-	-	-	-	-	-
Tax Rate	19.66%	19.65%	22.27%	22.23%	22.20%	24.78%	23.42%	-
YoY %	0.05%	-11.76%	0.18%	0.14%	-10.41%	5.81%	-	-
Horiz. %	83.95%	83.90%	95.09%	94.92%	94.79%	105.81%	100.00%	-
Total Cost	819,017	812,590	826,883	854,763	843,840	818,762	809,898	0.74%
YoY %	0.79%	-1.73%	-3.26%	1.29%	3.06%	1.09%	-	-
Horiz. %	101.13%	100.33%	102.10%	105.54%	104.19%	101.09%	100.00%	-
								-
YoY %	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	-	-
Horiz. %	-	-	-	-	-	-	-	-
Net Worth	470,964	458,593	431,216	486,092	476,845	489,114	464,861	0.87%
YoY %	2.70%	6.35%	-11.29%	1.94%	-2.51%	5.22%	-	-
Horiz. %	101.31%	98.65%	92.76%	104.57%	102.58%	105.22%	100.00%	-

	31/12/07	30/09/07	30/06/07	31/03/07	31/12/06	30/09/06	30/06/06	CAGR
Dividend
Div	91,899	97,967	97,967	120,751	120,751	91,970	91,970	-0.05%
YoY %	-6.19%	0.00%	-18.87%	0.00%	31.29%	0.00%	-	-
Horiz. %	99.92%	106.52%	106.52%	131.29%	131.29%	100.00%	100.00%	-
Div Payout %	117.08%	163.73%	170.17%	187.71%	140.57%	96.79%	91.09%	-
YoY %	-28.49%	-3.78%	-9.34%	33.53%	45.23%	6.26%	-	-
Horiz. %	128.53%	179.75%	186.82%	206.07%	154.32%	106.26%	100.00%	-

	31/12/07	30/09/07	30/06/07	31/03/07	31/12/06	30/09/06	30/06/06	CAGR
Equity
Net Worth	470,964	458,593	431,216	486,092	476,845	489,114	464,861	0.87%
YoY %	2.70%	6.35%	-11.29%	1.94%	-2.51%	5.22%	-	-
Horiz. %	101.31%	98.65%	92.76%	104.57%	102.58%	105.22%	100.00%	-
NOSH	305,820	305,729	305,827	305,718	305,670	305,696	305,830	-0.00%
YoY %	0.03%	-0.03%	0.04%	0.02%	-0.01%	-0.04%	-	-
Horiz. %	100.00%	99.97%	100.00%	99.96%	99.95%	99.96%	100.00%	-

	31/12/07	30/09/07	30/06/07	31/03/07	31/12/06	30/09/06	30/06/06	CAGR
Ratio Analysis
NP Margin	8.75%	6.86%	6.51%	7.00%	9.24%	10.40%	11.08%	-
YoY %	27.55%	5.38%	-7.00%	-24.24%	-11.15%	-6.14%	-	-
Horiz. %	78.97%	61.91%	58.75%	63.18%	83.39%	93.86%	100.00%	-
ROE	16.67%	13.05%	13.35%	13.23%	18.02%	19.43%	21.72%	-
YoY %	27.74%	-2.25%	0.91%	-26.58%	-7.26%	-10.54%	-	-
Horiz. %	76.75%	60.08%	61.46%	60.91%	82.97%	89.46%	100.00%	-

	31/12/07	30/09/07	30/06/07	31/03/07	31/12/06	30/09/06	30/06/06	CAGR
Per Share
RPS	293.48	285.36	289.20	300.63	304.17	298.92	297.83	-0.97%
YoY %	2.85%	-1.33%	-3.80%	-1.16%	1.76%	0.37%	-	-
Horiz. %	98.54%	95.81%	97.10%	100.94%	102.13%	100.37%	100.00%	-
EPS	25.67	19.57	18.82	21.04	28.10	31.08	33.01	-15.39%
YoY %	31.17%	3.99%	-10.55%	-25.12%	-9.59%	-5.85%	-	-
Horiz. %	77.76%	59.29%	57.01%	63.74%	85.13%	94.15%	100.00%	-
DPS	30.05	32.05	32.05	39.50	39.50	30.08	30.08	-0.06%
YoY %	-6.24%	0.00%	-18.86%	0.00%	31.32%	0.00%	-	-
Horiz. %	99.90%	106.55%	106.55%	131.32%	131.32%	100.00%	100.00%	-
NAPS	1.54	1.50	1.41	1.59	1.56	1.60	1.52	0.87%
YoY %	2.67%	6.38%	-11.32%	1.92%	-2.50%	5.26%	-	-
Horiz. %	101.32%	98.68%	92.76%	104.61%	102.63%	105.26%	100.00%	-

	31/12/07	30/09/07	30/06/07	31/03/07	31/12/06	30/09/06	30/06/06	CAGR
Adjusted Per Share Value based on latest NOSH - 305,718
RPS	293.56	285.35	289.28	300.61	304.10	298.88	297.92	-0.97%
YoY %	2.88%	-1.36%	-3.77%	-1.15%	1.75%	0.32%	-	-
Horiz. %	98.54%	95.78%	97.10%	100.90%	102.07%	100.32%	100.00%	-
EPS	25.67	19.57	18.83	21.04	28.10	31.08	33.02	-15.41%
YoY %	31.17%	3.93%	-10.50%	-25.12%	-9.59%	-5.88%	-	-
Horiz. %	77.74%	59.27%	57.03%	63.72%	85.10%	94.12%	100.00%	-
DPS	30.06	32.04	32.04	39.50	39.50	30.08	30.08	-0.04%
YoY %	-6.18%	0.00%	-18.89%	0.00%	31.32%	0.00%	-	-
Horiz. %	99.93%	106.52%	106.52%	131.32%	131.32%	100.00%	100.00%	-
NAPS	1.5404	1.50	1.4104	1.5899	1.5597	1.5998	1.5205	0.86%
YoY %	2.69%	6.35%	-11.29%	1.94%	-2.51%	5.22%	-	-
Horiz. %	101.31%	98.65%	92.76%	104.56%	102.58%	105.22%	100.00%	-

	31/12/07	30/09/07	30/06/07	31/03/07	31/12/06	30/09/06	30/06/06	CAGR
Price Multiplier on Financial Quarter End Date
Date	31/12/07	28/09/07	29/06/07	30/03/07	29/12/06	29/09/06	30/06/06	-
Price	4.24	4.64	4.84	5.40	5.10	5.00	5.00	-
P/RPS	1.44	1.63	1.67	1.80	1.68	1.67	1.68	-9.74%
YoY %	-11.66%	-2.40%	-7.22%	7.14%	0.60%	-0.60%	-	-
Horiz. %	85.71%	97.02%	99.40%	107.14%	100.00%	99.40%	100.00%	-
P/EPS	16.52	23.71	25.71	25.66	18.15	16.09	15.15	5.92%
YoY %	-30.32%	-7.78%	0.19%	41.38%	12.80%	6.20%	-	-
Horiz. %	109.04%	156.50%	169.70%	169.37%	119.80%	106.20%	100.00%	-
EY	6.05	4.22	3.89	3.90	5.51	6.22	6.60	-5.62%
YoY %	43.36%	8.48%	-0.26%	-29.22%	-11.41%	-5.76%	-	-
Horiz. %	91.67%	63.94%	58.94%	59.09%	83.48%	94.24%	100.00%	-
DY	7.09	6.91	6.62	7.31	7.75	6.02	6.02	11.49%
YoY %	2.60%	4.38%	-9.44%	-5.68%	28.74%	0.00%	-	-
Horiz. %	117.77%	114.78%	109.97%	121.43%	128.74%	100.00%	100.00%	-
P/NAPS	2.75	3.09	3.43	3.40	3.27	3.13	3.29	-11.23%
YoY %	-11.00%	-9.91%	0.88%	3.98%	4.47%	-4.86%	-	-
Horiz. %	83.59%	93.92%	104.26%	103.34%	99.39%	95.14%	100.00%	-

	31/12/07	30/09/07	30/06/07	31/03/07	31/12/06	30/09/06	30/06/06	CAGR
Price Multiplier on Announcement Date
Date	29/02/08	21/11/07	20/08/07	31/05/07	23/02/07	24/11/06	30/08/06	-
Price	4.02	4.38	4.86	4.98	5.50	5.20	5.00	-
P/RPS	1.37	1.53	1.68	1.66	1.81	1.74	1.68	-12.68%
YoY %	-10.46%	-8.93%	1.20%	-8.29%	4.02%	3.57%	-	-
Horiz. %	81.55%	91.07%	100.00%	98.81%	107.74%	103.57%	100.00%	-
P/EPS	15.66	22.38	25.82	23.67	19.57	16.73	15.15	2.22%
YoY %	-30.03%	-13.32%	9.08%	20.95%	16.98%	10.43%	-	-
Horiz. %	103.37%	147.72%	170.43%	156.24%	129.17%	110.43%	100.00%	-
EY	6.38	4.47	3.87	4.23	5.11	5.98	6.60	-2.22%
YoY %	42.73%	15.50%	-8.51%	-17.22%	-14.55%	-9.39%	-	-
Horiz. %	96.67%	67.73%	58.64%	64.09%	77.42%	90.61%	100.00%	-
DY	7.48	7.32	6.59	7.93	7.18	5.78	6.02	15.53%
YoY %	2.19%	11.08%	-16.90%	10.45%	24.22%	-3.99%	-	-
Horiz. %	124.25%	121.59%	109.47%	131.73%	119.27%	96.01%	100.00%	-
P/NAPS	2.61	2.92	3.45	3.13	3.53	3.25	3.29	-14.26%
YoY %	-10.62%	-15.36%	10.22%	-11.33%	8.62%	-1.22%	-	-
Horiz. %	79.33%	88.75%	104.86%	95.14%	107.29%	98.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.

Discussions

Be the first to like this. Showing 0 of 0 comments

Featured Posts

MQ Trader

Introducing MY's First IPO Fund for Sophisticated Investors!

MQ Chat

New Update. Discover investment communities that resonate with your ideas

MQ Trader

M & A Value Partners IPO Equity Fund has been launched - Targeted 13% Return p.a

Latest Videos