[TROP] QoQ Annualized Quarter Result on 30-Sep-2017 [#3]

	30/06/18	31/03/18	31/12/17	30/09/17	30/06/17	31/03/17	31/12/16	CAGR
Annualized Quarter Result
Revenue	1,468,866	1,812,020	1,908,768	1,719,638	1,652,526	1,494,728	1,459,405	0.43%
YoY %	-18.94%	-5.07%	11.00%	4.06%	10.56%	2.42%	-	-
Horiz. %	100.65%	124.16%	130.79%	117.83%	113.23%	102.42%	100.00%	-
PBT	300,814	341,768	291,766	236,702	256,972	162,192	168,053	47.58%
YoY %	-11.98%	17.14%	23.26%	-7.89%	58.44%	-3.49%	-	-
Horiz. %	179.00%	203.37%	173.62%	140.85%	152.91%	96.51%	100.00%	-
Tax	-111,422	-132,936	-91,778	-69,736	-78,310	-49,088	-53,052	64.22%
YoY %	16.18%	-44.85%	-31.61%	10.95%	-59.53%	7.47%	-	-
Horiz. %	210.02%	250.58%	173.00%	131.45%	147.61%	92.53%	100.00%	-
NP	189,392	208,832	199,988	166,966	178,662	113,104	115,001	39.58%
YoY %	-9.31%	4.42%	19.78%	-6.55%	57.96%	-1.65%	-	-
Horiz. %	164.69%	181.59%	173.90%	145.19%	155.36%	98.35%	100.00%	-
								-
YoY %	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	-	-
Horiz. %	-	-	-	-	-	-	-	-
NP to SH	168,806	185,612	190,475	161,144	170,732	108,232	112,537	31.13%
YoY %	-9.05%	-2.55%	18.20%	-5.62%	57.75%	-3.83%	-	-
Horiz. %	150.00%	164.93%	169.26%	143.19%	151.71%	96.17%	100.00%	-
								-
YoY %	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	-	-
Horiz. %	-	-	-	-	-	-	-	-
Tax Rate	37.04%	38.90%	31.46%	29.46%	30.47%	30.27%	31.57%	-
YoY %	-4.78%	23.65%	6.79%	-3.31%	0.66%	-4.12%	-	-
Horiz. %	117.33%	123.22%	99.65%	93.32%	96.52%	95.88%	100.00%	-
Total Cost	1,279,474	1,603,188	1,708,780	1,552,672	1,473,864	1,381,624	1,344,404	-3.25%
YoY %	-20.19%	-6.18%	10.05%	5.35%	6.68%	2.77%	-	-
Horiz. %	95.17%	119.25%	127.10%	115.49%	109.63%	102.77%	100.00%	-
								-
YoY %	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	-	-
Horiz. %	-	-	-	-	-	-	-	-
Net Worth	3,379,201	3,337,397	3,301,337	3,245,233	3,221,417	2,867,748	3,126,514	5.33%
YoY %	1.25%	1.09%	1.73%	0.74%	12.33%	-8.28%	-	-
Horiz. %	108.08%	106.74%	105.59%	103.80%	103.04%	91.72%	100.00%	-

	30/06/18	31/03/18	31/12/17	30/09/17	30/06/17	31/03/17	31/12/16	CAGR
Dividend
Div	46,811	93,681	29,215	38,981	58,306	-	35,690	19.88%
YoY %	-50.03%	220.66%	-25.05%	-33.14%	0.00%	-	-	-
Horiz. %	131.16%	262.49%	81.86%	109.22%	163.37%	-	100.00%	-
Div Payout %	27.73%	50.47%	15.34%	24.19%	34.15%	-	31.71%	-
YoY %	-45.06%	229.01%	-36.59%	-29.17%	0.00%	-	-	-
Horiz. %	87.45%	159.16%	48.38%	76.29%	107.69%	-	100.00%	-

	30/06/18	31/03/18	31/12/17	30/09/17	30/06/17	31/03/17	31/12/16	CAGR
Equity
Net Worth	3,379,201	3,337,397	3,301,337	3,245,233	3,221,417	2,867,748	3,126,514	5.33%
YoY %	1.25%	1.09%	1.73%	0.74%	12.33%	-8.28%	-	-
Horiz. %	108.08%	106.74%	105.59%	103.80%	103.04%	91.72%	100.00%	-
NOSH	1,470,417	1,470,417	1,470,417	1,465,761	1,465,761	1,465,761	1,447,466	1.05%
YoY %	0.00%	0.00%	0.32%	0.00%	0.00%	1.26%	-	-
Horiz. %	101.59%	101.59%	101.59%	101.26%	101.26%	101.26%	100.00%	-

	30/06/18	31/03/18	31/12/17	30/09/17	30/06/17	31/03/17	31/12/16	CAGR
Ratio Analysis
NP Margin	12.89%	11.52%	10.48%	9.71%	10.81%	7.57%	7.88%	-
YoY %	11.89%	9.92%	7.93%	-10.18%	42.80%	-3.93%	-	-
Horiz. %	163.58%	146.19%	132.99%	123.22%	137.18%	96.07%	100.00%	-
ROE	5.00%	5.56%	5.77%	4.97%	5.30%	3.77%	3.60%	-
YoY %	-10.07%	-3.64%	16.10%	-6.23%	40.58%	4.72%	-	-
Horiz. %	138.89%	154.44%	160.28%	138.06%	147.22%	104.72%	100.00%	-

	30/06/18	31/03/18	31/12/17	30/09/17	30/06/17	31/03/17	31/12/16	CAGR
Per Share
RPS	100.41	123.79	130.67	117.64	113.37	104.24	102.23	-1.19%
YoY %	-18.89%	-5.27%	11.08%	3.77%	8.76%	1.97%	-	-
Horiz. %	98.22%	121.09%	127.82%	115.07%	110.90%	101.97%	100.00%	-
EPS	11.54	12.68	13.10	11.11	11.80	7.56	7.87	29.15%
YoY %	-8.99%	-3.21%	17.91%	-5.85%	56.08%	-3.94%	-	-
Horiz. %	146.63%	161.12%	166.45%	141.17%	149.94%	96.06%	100.00%	-
DPS	3.20	6.40	2.00	2.67	4.00	0.00	2.50	17.94%
YoY %	-50.00%	220.00%	-25.09%	-33.25%	0.00%	0.00%	-	-
Horiz. %	128.00%	256.00%	80.00%	106.80%	160.00%	0.00%	100.00%	-
NAPS	2.31	2.28	2.26	2.22	2.21	2.00	2.19	3.63%
YoY %	1.32%	0.88%	1.80%	0.45%	10.50%	-8.68%	-	-
Horiz. %	105.48%	104.11%	103.20%	101.37%	100.91%	91.32%	100.00%	-

	30/06/18	31/03/18	31/12/17	30/09/17	30/06/17	31/03/17	31/12/16	CAGR
Adjusted Per Share Value based on latest NOSH - 1,465,761
RPS	63.92	78.85	83.06	74.83	71.91	65.05	63.51	0.43%
YoY %	-18.93%	-5.07%	11.00%	4.06%	10.55%	2.42%	-	-
Horiz. %	100.65%	124.15%	130.78%	117.82%	113.23%	102.42%	100.00%	-
EPS	7.35	8.08	8.29	7.01	7.43	4.71	4.90	31.13%
YoY %	-9.03%	-2.53%	18.26%	-5.65%	57.75%	-3.88%	-	-
Horiz. %	150.00%	164.90%	169.18%	143.06%	151.63%	96.12%	100.00%	-
DPS	2.04	4.08	1.27	1.70	2.54	0.00	1.55	20.15%
YoY %	-50.00%	221.26%	-25.29%	-33.07%	0.00%	0.00%	-	-
Horiz. %	131.61%	263.23%	81.94%	109.68%	163.87%	0.00%	100.00%	-
NAPS	1.4705	1.4523	1.4367	1.4122	1.4019	1.248	1.3606	5.32%
YoY %	1.25%	1.09%	1.73%	0.73%	12.33%	-8.28%	-	-
Horiz. %	108.08%	106.74%	105.59%	103.79%	103.04%	91.72%	100.00%	-

	30/06/18	31/03/18	31/12/17	30/09/17	30/06/17	31/03/17	31/12/16	CAGR
Price Multiplier on Financial Quarter End Date
Date	29/06/18	30/03/18	29/12/17	29/09/17	30/06/17	31/03/17	30/12/16	-
Price	0.855	0.89	0.915	0.94	0.97	1.00	1.00	-
P/RPS	0.85	0.72	0.70	0.80	0.86	0.96	0.98	-9.07%
YoY %	18.06%	2.86%	-12.50%	-6.98%	-10.42%	-2.04%	-	-
Horiz. %	86.73%	73.47%	71.43%	81.63%	87.76%	97.96%	100.00%	-
P/EPS	7.41	7.02	7.02	8.53	8.28	13.25	12.69	-30.20%
YoY %	5.56%	0.00%	-17.70%	3.02%	-37.51%	4.41%	-	-
Horiz. %	58.39%	55.32%	55.32%	67.22%	65.25%	104.41%	100.00%	-
EY	13.50	14.25	14.25	11.73	12.08	7.55	7.88	43.31%
YoY %	-5.26%	0.00%	21.48%	-2.90%	60.00%	-4.19%	-	-
Horiz. %	171.32%	180.84%	180.84%	148.86%	153.30%	95.81%	100.00%	-
DY	3.74	7.19	2.19	2.84	4.12	0.00	2.50	30.90%
YoY %	-47.98%	228.31%	-22.89%	-31.07%	0.00%	0.00%	-	-
Horiz. %	149.60%	287.60%	87.60%	113.60%	164.80%	0.00%	100.00%	-
P/NAPS	0.37	0.39	0.40	0.42	0.44	0.50	0.46	-13.54%
YoY %	-5.13%	-2.50%	-4.76%	-4.55%	-12.00%	8.70%	-	-
Horiz. %	80.43%	84.78%	86.96%	91.30%	95.65%	108.70%	100.00%	-

	30/06/18	31/03/18	31/12/17	30/09/17	30/06/17	31/03/17	31/12/16	CAGR
Price Multiplier on Announcement Date
Date	23/08/18	22/05/18	28/02/18	30/11/17	29/08/17	26/05/17	27/02/17	-
Price	0.88	0.885	0.895	0.90	0.95	0.965	0.985	-
P/RPS	0.88	0.71	0.68	0.77	0.84	0.93	0.96	-5.65%
YoY %	23.94%	4.41%	-11.69%	-8.33%	-9.68%	-3.12%	-	-
Horiz. %	91.67%	73.96%	70.83%	80.21%	87.50%	96.88%	100.00%	-
P/EPS	7.63	6.98	6.86	8.16	8.11	12.78	12.50	-28.10%
YoY %	9.31%	1.75%	-15.93%	0.62%	-36.54%	2.24%	-	-
Horiz. %	61.04%	55.84%	54.88%	65.28%	64.88%	102.24%	100.00%	-
EY	13.11	14.33	14.57	12.25	12.33	7.82	8.00	39.12%
YoY %	-8.51%	-1.65%	18.94%	-0.65%	57.67%	-2.25%	-	-
Horiz. %	163.88%	179.12%	182.12%	153.12%	154.12%	97.75%	100.00%	-
DY	3.64	7.23	2.23	2.96	4.21	0.00	2.54	27.19%
YoY %	-49.65%	224.22%	-24.66%	-29.69%	0.00%	0.00%	-	-
Horiz. %	143.31%	284.65%	87.80%	116.54%	165.75%	0.00%	100.00%	-
P/NAPS	0.38	0.39	0.40	0.41	0.43	0.48	0.45	-10.68%
YoY %	-2.56%	-2.50%	-2.44%	-4.65%	-10.42%	6.67%	-	-
Horiz. %	84.44%	86.67%	88.89%	91.11%	95.56%	106.67%	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