[LPI] QoQ TTM Result on 30-Jun-2013 [#2]

	31/03/14	31/12/13	30/09/13	30/06/13	31/03/13	31/12/12	30/09/12	CAGR
TTM Result
Revenue	1,138,353	1,119,022	1,096,302	1,069,101	1,051,732	1,039,326	1,006,720	8.54%
YoY %	1.73%	2.07%	2.54%	1.65%	1.19%	3.24%	-	-
Horiz. %	113.08%	111.16%	108.90%	106.20%	104.47%	103.24%	100.00%	-
PBT	268,384	256,801	248,114	235,282	227,306	214,036	203,413	20.31%
YoY %	4.51%	3.50%	5.45%	3.51%	6.20%	5.22%	-	-
Horiz. %	131.94%	126.25%	121.98%	115.67%	111.75%	105.22%	100.00%	-
Tax	-58,475	-55,361	-51,681	-51,574	-49,746	-47,111	-44,539	19.92%
YoY %	-5.62%	-7.12%	-0.21%	-3.67%	-5.59%	-5.77%	-	-
Horiz. %	131.29%	124.30%	116.04%	115.80%	111.69%	105.77%	100.00%	-
NP	209,909	201,440	196,433	183,708	177,560	166,925	158,874	20.42%
YoY %	4.20%	2.55%	6.93%	3.46%	6.37%	5.07%	-	-
Horiz. %	132.12%	126.79%	123.64%	115.63%	111.76%	105.07%	100.00%	-
								-
YoY %	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	-	-
Horiz. %	-	-	-	-	-	-	-	-
NP to SH	209,909	201,440	196,433	183,708	177,560	166,925	158,874	20.42%
YoY %	4.20%	2.55%	6.93%	3.46%	6.37%	5.07%	-	-
Horiz. %	132.12%	126.79%	123.64%	115.63%	111.76%	105.07%	100.00%	-
								-
YoY %	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	-	-
Horiz. %	-	-	-	-	-	-	-	-
Tax Rate	21.79%	21.56%	20.83%	21.92%	21.89%	22.01%	21.90%	-
YoY %	1.07%	3.50%	-4.97%	0.14%	-0.55%	0.50%	-	-
Horiz. %	99.50%	98.45%	95.11%	100.09%	99.95%	100.50%	100.00%	-
Total Cost	928,444	917,582	899,869	885,393	874,172	872,401	847,846	6.24%
YoY %	1.18%	1.97%	1.63%	1.28%	0.20%	2.90%	-	-
Horiz. %	109.51%	108.23%	106.14%	104.43%	103.11%	102.90%	100.00%	-
								-
YoY %	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	-	-
Horiz. %	-	-	-	-	-	-	-	-
Net Worth	1,525,889	1,605,939	1,457,533	1,391,487	1,305,009	1,372,534	1,216,466	16.32%
YoY %	-4.98%	10.18%	4.75%	6.63%	-4.92%	12.83%	-	-
Horiz. %	125.44%	132.02%	119.82%	114.39%	107.28%	112.83%	100.00%	-

	31/03/14	31/12/13	30/09/13	30/06/13	31/03/13	31/12/12	30/09/12	CAGR
Dividend
Div	154,178	154,178	149,806	149,806	143,196	143,196	143,229	5.03%
YoY %	0.00%	2.92%	0.00%	4.62%	0.00%	-0.02%	-	-
Horiz. %	107.64%	107.64%	104.59%	104.59%	99.98%	99.98%	100.00%	-
Div Payout %	73.45%	76.54%	76.26%	81.55%	80.65%	85.78%	90.15%	-
YoY %	-4.04%	0.37%	-6.49%	1.12%	-5.98%	-4.85%	-	-
Horiz. %	81.48%	84.90%	84.59%	90.46%	89.46%	95.15%	100.00%	-

	31/03/14	31/12/13	30/09/13	30/06/13	31/03/13	31/12/12	30/09/12	CAGR
Equity
Net Worth	1,525,889	1,605,939	1,457,533	1,391,487	1,305,009	1,372,534	1,216,466	16.32%
YoY %	-4.98%	10.18%	4.75%	6.63%	-4.92%	12.83%	-	-
Horiz. %	125.44%	132.02%	119.82%	114.39%	107.28%	112.83%	100.00%	-
NOSH	220,300	220,226	220,281	220,335	220,366	220,292	220,314	-0.00%
YoY %	0.03%	-0.02%	-0.02%	-0.01%	0.03%	-0.01%	-	-
Horiz. %	99.99%	99.96%	99.99%	100.01%	100.02%	99.99%	100.00%	-

	31/03/14	31/12/13	30/09/13	30/06/13	31/03/13	31/12/12	30/09/12	CAGR
Ratio Analysis
NP Margin	18.44%	18.00%	17.92%	17.18%	16.88%	16.06%	15.78%	-
YoY %	2.44%	0.45%	4.31%	1.78%	5.11%	1.77%	-	-
Horiz. %	116.86%	114.07%	113.56%	108.87%	106.97%	101.77%	100.00%	-
ROE	13.76%	12.54%	13.48%	13.20%	13.61%	12.16%	13.06%	-
YoY %	9.73%	-6.97%	2.12%	-3.01%	11.92%	-6.89%	-	-
Horiz. %	105.36%	96.02%	103.22%	101.07%	104.21%	93.11%	100.00%	-

	31/03/14	31/12/13	30/09/13	30/06/13	31/03/13	31/12/12	30/09/12	CAGR
Per Share
RPS	516.73	508.12	497.68	485.21	477.27	471.79	456.95	8.54%
YoY %	1.69%	2.10%	2.57%	1.66%	1.16%	3.25%	-	-
Horiz. %	113.08%	111.20%	108.91%	106.18%	104.45%	103.25%	100.00%	-
EPS	95.28	91.47	89.17	83.38	80.57	75.77	72.11	20.43%
YoY %	4.17%	2.58%	6.94%	3.49%	6.33%	5.08%	-	-
Horiz. %	132.13%	126.85%	123.66%	115.63%	111.73%	105.08%	100.00%	-
DPS	70.00	70.00	68.00	68.00	65.00	65.00	65.00	5.06%
YoY %	0.00%	2.94%	0.00%	4.62%	0.00%	0.00%	-	-
Horiz. %	107.69%	107.69%	104.62%	104.62%	100.00%	100.00%	100.00%	-
NAPS	6.9264	7.2922	6.6167	6.3153	5.922	6.2305	5.5215	16.33%
YoY %	-5.02%	10.21%	4.77%	6.64%	-4.95%	12.84%	-	-
Horiz. %	125.44%	132.07%	119.84%	114.38%	107.25%	112.84%	100.00%	-

	31/03/14	31/12/13	30/09/13	30/06/13	31/03/13	31/12/12	30/09/12	CAGR
Adjusted Per Share Value based on latest NOSH - 220,335
RPS	285.74	280.89	275.19	268.36	264.00	260.89	252.70	8.54%
YoY %	1.73%	2.07%	2.55%	1.65%	1.19%	3.24%	-	-
Horiz. %	113.07%	111.16%	108.90%	106.20%	104.47%	103.24%	100.00%	-
EPS	52.69	50.56	49.31	46.11	44.57	41.90	39.88	20.42%
YoY %	4.21%	2.53%	6.94%	3.46%	6.37%	5.07%	-	-
Horiz. %	132.12%	126.78%	123.65%	115.62%	111.76%	105.07%	100.00%	-
DPS	38.70	38.70	37.60	37.60	35.94	35.94	35.95	5.04%
YoY %	0.00%	2.93%	0.00%	4.62%	0.00%	-0.03%	-	-
Horiz. %	107.65%	107.65%	104.59%	104.59%	99.97%	99.97%	100.00%	-
NAPS	3.8302	4.0311	3.6586	3.4928	3.2758	3.4453	3.0535	16.32%
YoY %	-4.98%	10.18%	4.75%	6.62%	-4.92%	12.83%	-	-
Horiz. %	125.44%	132.02%	119.82%	114.39%	107.28%	112.83%	100.00%	-

	31/03/14	31/12/13	30/09/13	30/06/13	31/03/13	31/12/12	30/09/12	CAGR
Price Multiplier on Financial Quarter End Date
Date	31/03/14	31/12/13	30/09/13	28/06/13	29/03/13	31/12/12	28/09/12	-
Price	16.60	17.44	15.30	15.20	13.60	14.54	13.30	-
P/RPS	3.21	3.43	3.07	3.13	2.85	3.08	2.91	6.76%
YoY %	-6.41%	11.73%	-1.92%	9.82%	-7.47%	5.84%	-	-
Horiz. %	110.31%	117.87%	105.50%	107.56%	97.94%	105.84%	100.00%	-
P/EPS	17.42	19.07	17.16	18.23	16.88	19.19	18.44	-3.72%
YoY %	-8.65%	11.13%	-5.87%	8.00%	-12.04%	4.07%	-	-
Horiz. %	94.47%	103.42%	93.06%	98.86%	91.54%	104.07%	100.00%	-
EY	5.74	5.24	5.83	5.49	5.92	5.21	5.42	3.90%
YoY %	9.54%	-10.12%	6.19%	-7.26%	13.63%	-3.87%	-	-
Horiz. %	105.90%	96.68%	107.56%	101.29%	109.23%	96.13%	100.00%	-
DY	4.22	4.01	4.44	4.47	4.78	4.47	4.89	-9.36%
YoY %	5.24%	-9.68%	-0.67%	-6.49%	6.94%	-8.59%	-	-
Horiz. %	86.30%	82.00%	90.80%	91.41%	97.75%	91.41%	100.00%	-
P/NAPS	2.40	2.39	2.31	2.41	2.30	2.33	2.41	-0.27%
YoY %	0.42%	3.46%	-4.15%	4.78%	-1.29%	-3.32%	-	-
Horiz. %	99.59%	99.17%	95.85%	100.00%	95.44%	96.68%	100.00%	-

	31/03/14	31/12/13	30/09/13	30/06/13	31/03/13	31/12/12	30/09/12	CAGR
Price Multiplier on Announcement Date
Date	08/04/14	08/01/14	08/10/13	08/07/13	08/04/13	08/01/13	09/10/12	-
Price	16.60	17.84	15.44	15.64	13.54	14.72	13.50	-
P/RPS	3.21	3.51	3.10	3.22	2.84	3.12	2.95	5.79%
YoY %	-8.55%	13.23%	-3.73%	13.38%	-8.97%	5.76%	-	-
Horiz. %	108.81%	118.98%	105.08%	109.15%	96.27%	105.76%	100.00%	-
P/EPS	17.42	19.50	17.31	18.76	16.80	19.43	18.72	-4.68%
YoY %	-10.67%	12.65%	-7.73%	11.67%	-13.54%	3.79%	-	-
Horiz. %	93.06%	104.17%	92.47%	100.21%	89.74%	103.79%	100.00%	-
EY	5.74	5.13	5.78	5.33	5.95	5.15	5.34	4.93%
YoY %	11.89%	-11.25%	8.44%	-10.42%	15.53%	-3.56%	-	-
Horiz. %	107.49%	96.07%	108.24%	99.81%	111.42%	96.44%	100.00%	-
DY	4.22	3.92	4.40	4.35	4.80	4.42	4.81	-8.36%
YoY %	7.65%	-10.91%	1.15%	-9.38%	8.60%	-8.11%	-	-
Horiz. %	87.73%	81.50%	91.48%	90.44%	99.79%	91.89%	100.00%	-
P/NAPS	2.40	2.45	2.33	2.48	2.29	2.36	2.44	-1.09%
YoY %	-2.04%	5.15%	-6.05%	8.30%	-2.97%	-3.28%	-	-
Horiz. %	98.36%	100.41%	95.49%	101.64%	93.85%	96.72%	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