[MELEWAR] YoY Cumulative Quarter Result on 30-Jun-2007 [#4]

	30/06/10	30/06/09	30/06/08	30/06/07	31/01/06	31/01/05	31/01/04	CAGR
Cumulative Result
Revenue	707,147	599,545	703,345	810,242	566,920	598,722	462,255	6.84%
YoY %	17.95%	-14.76%	-13.19%	42.92%	-5.31%	29.52%	-	-
Horiz. %	152.98%	129.70%	152.16%	175.28%	122.64%	129.52%	100.00%	-
PBT	91,622	-246,698	56,478	189,169	35,523	72,664	80,553	2.02%
YoY %	137.14%	-536.80%	-70.14%	432.53%	-51.11%	-9.79%	-	-
Horiz. %	113.74%	-306.26%	70.11%	234.84%	44.10%	90.21%	100.00%	-
Tax	-12,606	73,991	-725	-74,329	11,392	-26,120	-16,113	-3.75%
YoY %	-117.04%	10,305.66%	99.02%	-752.47%	143.61%	-62.11%	-	-
Horiz. %	78.23%	-459.20%	4.50%	461.30%	-70.70%	162.11%	100.00%	-
NP	79,016	-172,707	55,753	114,840	46,915	46,544	64,440	3.22%
YoY %	145.75%	-409.77%	-51.45%	144.78%	0.80%	-27.77%	-	-
Horiz. %	122.62%	-268.01%	86.52%	178.21%	72.80%	72.23%	100.00%	-
								-
YoY %	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	-	-
Horiz. %	-	-	-	-	-	-	-	-
NP to SH	67,629	-155,975	44,854	104,423	46,915	46,544	64,440	0.75%
YoY %	143.36%	-447.74%	-57.05%	122.58%	0.80%	-27.77%	-	-
Horiz. %	104.95%	-242.05%	69.61%	162.05%	72.80%	72.23%	100.00%	-
								-
YoY %	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	-	-
Horiz. %	-	-	-	-	-	-	-	-
Tax Rate	13.76%	-	1.28%	39.29%	-32.07%	35.95%	20.00%	-
YoY %	0.00%	-	-96.74%	222.51%	-189.21%	79.75%	-	-
Horiz. %	68.80%	-	6.40%	196.45%	-160.35%	179.75%	100.00%	-
Total Cost	628,131	772,252	647,592	695,402	520,005	552,178	397,815	7.37%
YoY %	-18.66%	19.25%	-6.88%	33.73%	-5.83%	38.80%	-	-
Horiz. %	157.90%	194.12%	162.79%	174.81%	130.72%	138.80%	100.00%	-
								-
YoY %	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	-	-
Horiz. %	-	-	-	-	-	-	-	-
Net Worth	520,916	455,661	615,952	576,623	562,264	351,093	358,878	5.97%
YoY %	14.32%	-26.02%	6.82%	2.55%	60.15%	-2.17%	-	-
Horiz. %	145.15%	126.97%	171.63%	160.67%	156.67%	97.83%	100.00%	-

	30/06/10	30/06/09	30/06/08	30/06/07	31/01/06	31/01/05	31/01/04	CAGR
Dividend
Div	4,510	-	9,024	13,514	4,875	15,074	64,139	-33.88%
YoY %	0.00%	-	-33.22%	177.21%	-67.66%	-76.50%	-	-
Horiz. %	7.03%	-	14.07%	21.07%	7.60%	23.50%	100.00%	-
Div Payout %	6.67%	-	20.12%	12.94%	10.39%	32.39%	99.53%	-
YoY %	0.00%	-	55.49%	24.54%	-67.92%	-67.46%	-	-
Horiz. %	6.70%	-	20.22%	13.00%	10.44%	32.54%	100.00%	-

	30/06/10	30/06/09	30/06/08	30/06/07	31/01/06	31/01/05	31/01/04	CAGR
Equity
Net Worth	520,916	455,661	615,952	576,623	562,264	351,093	358,878	5.97%
YoY %	14.32%	-26.02%	6.82%	2.55%	60.15%	-2.17%	-	-
Horiz. %	145.15%	126.97%	171.63%	160.67%	156.67%	97.83%	100.00%	-
NOSH	225,505	225,575	225,623	225,243	162,504	161,051	158,096	5.69%
YoY %	-0.03%	-0.02%	0.17%	38.61%	0.90%	1.87%	-	-
Horiz. %	142.64%	142.68%	142.71%	142.47%	102.79%	101.87%	100.00%	-

	30/06/10	30/06/09	30/06/08	30/06/07	31/01/06	31/01/05	31/01/04	CAGR
Ratio Analysis
NP Margin	11.17%	-28.81%	7.93%	14.17%	8.28%	7.77%	13.94%	-
YoY %	138.77%	-463.30%	-44.04%	71.14%	6.56%	-44.26%	-	-
Horiz. %	80.13%	-206.67%	56.89%	101.65%	59.40%	55.74%	100.00%	-
ROE	12.98%	-34.23%	7.28%	18.11%	8.34%	13.26%	17.96%	-
YoY %	137.92%	-570.19%	-59.80%	117.15%	-37.10%	-26.17%	-	-
Horiz. %	72.27%	-190.59%	40.53%	100.84%	46.44%	73.83%	100.00%	-

	30/06/10	30/06/09	30/06/08	30/06/07	31/01/06	31/01/05	31/01/04	CAGR
Per Share
RPS	313.58	265.79	311.73	359.72	348.86	371.76	292.39	1.09%
YoY %	17.98%	-14.74%	-13.34%	3.11%	-6.16%	27.15%	-	-
Horiz. %	107.25%	90.90%	106.61%	123.03%	119.31%	127.15%	100.00%	-
EPS	29.99	-69.14	19.88	46.36	28.87	28.90	40.76	-4.66%
YoY %	143.38%	-447.79%	-57.12%	60.58%	-0.10%	-29.10%	-	-
Horiz. %	73.58%	-169.63%	48.77%	113.74%	70.83%	70.90%	100.00%	-
DPS	2.00	0.00	4.00	6.00	3.00	9.36	40.57	-37.44%
YoY %	0.00%	0.00%	-33.33%	100.00%	-67.95%	-76.93%	-	-
Horiz. %	4.93%	0.00%	9.86%	14.79%	7.39%	23.07%	100.00%	-
NAPS	2.31	2.02	2.73	2.56	3.46	2.18	2.27	0.27%
YoY %	14.36%	-26.01%	6.64%	-26.01%	58.72%	-3.96%	-	-
Horiz. %	101.76%	88.99%	120.26%	112.78%	152.42%	96.04%	100.00%	-

	30/06/10	30/06/09	30/06/08	30/06/07	31/01/06	31/01/05	31/01/04	CAGR
Adjusted Per Share Value based on latest NOSH - 225,227
RPS	196.73	166.79	195.67	225.41	157.72	166.56	128.60	6.84%
YoY %	17.95%	-14.76%	-13.19%	42.92%	-5.31%	29.52%	-	-
Horiz. %	152.98%	129.70%	152.15%	175.28%	122.64%	129.52%	100.00%	-
EPS	18.81	-43.39	12.48	29.05	13.05	12.95	17.93	0.74%
YoY %	143.35%	-447.68%	-57.04%	122.61%	0.77%	-27.77%	-	-
Horiz. %	104.91%	-242.00%	69.60%	162.02%	72.78%	72.23%	100.00%	-
DPS	1.25	0.00	2.51	3.76	1.36	4.19	17.84	-33.91%
YoY %	0.00%	0.00%	-33.24%	176.47%	-67.54%	-76.51%	-	-
Horiz. %	7.01%	0.00%	14.07%	21.08%	7.62%	23.49%	100.00%	-
NAPS	1.4492	1.2676	1.7136	1.6042	1.5642	0.9767	0.9984	5.97%
YoY %	14.33%	-26.03%	6.82%	2.56%	60.15%	-2.17%	-	-
Horiz. %	145.15%	126.96%	171.63%	160.68%	156.67%	97.83%	100.00%	-

	30/06/10	30/06/09	30/06/08	30/06/07	31/01/06	31/01/05	31/01/04	CAGR
Price Multiplier on Financial Quarter End Date
Date	30/06/10	30/06/09	30/06/08	29/06/07	27/01/06	31/01/05	30/01/04	-
Price	0.67	0.61	0.77	1.24	0.98	2.17	2.56	-
P/RPS	0.21	0.23	0.25	0.34	0.28	0.58	0.88	-20.01%
YoY %	-8.70%	-8.00%	-26.47%	21.43%	-51.72%	-34.09%	-	-
Horiz. %	23.86%	26.14%	28.41%	38.64%	31.82%	65.91%	100.00%	-
P/EPS	2.23	-0.88	3.87	2.67	3.39	7.51	6.28	-14.90%
YoY %	353.41%	-122.74%	44.94%	-21.24%	-54.86%	19.59%	-	-
Horiz. %	35.51%	-14.01%	61.62%	42.52%	53.98%	119.59%	100.00%	-
EY	44.76	-113.35	25.82	37.39	29.46	13.32	15.92	17.48%
YoY %	139.49%	-539.00%	-30.94%	26.92%	121.17%	-16.33%	-	-
Horiz. %	281.16%	-712.00%	162.19%	234.86%	185.05%	83.67%	100.00%	-
DY	2.99	0.00	5.19	4.84	3.06	4.31	15.85	-22.89%
YoY %	0.00%	0.00%	7.23%	58.17%	-29.00%	-72.81%	-	-
Horiz. %	18.86%	0.00%	32.74%	30.54%	19.31%	27.19%	100.00%	-
P/NAPS	0.29	0.30	0.28	0.48	0.28	1.00	1.13	-19.10%
YoY %	-3.33%	7.14%	-41.67%	71.43%	-72.00%	-11.50%	-	-
Horiz. %	25.66%	26.55%	24.78%	42.48%	24.78%	88.50%	100.00%	-

	30/06/10	30/06/09	30/06/08	30/06/07	31/01/06	31/01/05	31/01/04	CAGR
Price Multiplier on Announcement Date
Date	26/08/10	28/08/09	26/08/08	28/08/07	29/03/06	24/03/05	26/03/04	-
Price	0.77	0.62	0.70	1.48	0.90	2.03	2.82	-
P/RPS	0.25	0.23	0.22	0.41	0.26	0.55	0.96	-18.91%
YoY %	8.70%	4.55%	-46.34%	57.69%	-52.73%	-42.71%	-	-
Horiz. %	26.04%	23.96%	22.92%	42.71%	27.08%	57.29%	100.00%	-
P/EPS	2.57	-0.90	3.52	3.19	3.12	7.02	6.92	-14.30%
YoY %	385.56%	-125.57%	10.34%	2.24%	-55.56%	1.45%	-	-
Horiz. %	37.14%	-13.01%	50.87%	46.10%	45.09%	101.45%	100.00%	-
EY	38.95	-111.53	28.40	31.32	32.08	14.24	14.45	16.71%
YoY %	134.92%	-492.71%	-9.32%	-2.37%	125.28%	-1.45%	-	-
Horiz. %	269.55%	-771.83%	196.54%	216.75%	222.01%	98.55%	100.00%	-
DY	2.60	0.00	5.71	4.05	3.33	4.61	14.39	-23.40%
YoY %	0.00%	0.00%	40.99%	21.62%	-27.77%	-67.96%	-	-
Horiz. %	18.07%	0.00%	39.68%	28.14%	23.14%	32.04%	100.00%	-
P/NAPS	0.33	0.31	0.26	0.58	0.26	0.93	1.24	-18.64%
YoY %	6.45%	19.23%	-55.17%	123.08%	-72.04%	-25.00%	-	-
Horiz. %	26.61%	25.00%	20.97%	46.77%	20.97%	75.00%	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 Chat

New Update. Discover investment communities that resonate with your ideas

Latest Videos