[HSL] YoY TTM Result on 31-Mar-2017 [#1]

	31/03/20	31/03/19	31/03/18	31/03/17	31/03/16	31/03/15	31/03/14	CAGR
TTM Result
Revenue	649,283	625,316	532,485	461,466	610,530	675,159	529,390	3.45%
YoY %	3.83%	17.43%	15.39%	-24.42%	-9.57%	27.54%	-	-
Horiz. %	122.65%	118.12%	100.58%	87.17%	115.33%	127.54%	100.00%	-
PBT	65,468	72,372	66,120	68,679	96,516	107,380	109,934	-8.26%
YoY %	-9.54%	9.46%	-3.73%	-28.84%	-10.12%	-2.32%	-	-
Horiz. %	59.55%	65.83%	60.15%	62.47%	87.79%	97.68%	100.00%	-
Tax	-16,729	-18,220	-16,997	-17,184	-23,688	-27,227	-27,827	-8.12%
YoY %	8.18%	-7.20%	1.09%	27.46%	13.00%	2.16%	-	-
Horiz. %	60.12%	65.48%	61.08%	61.75%	85.13%	97.84%	100.00%	-
NP	48,739	54,152	49,123	51,495	72,828	80,153	82,107	-8.31%
YoY %	-10.00%	10.24%	-4.61%	-29.29%	-9.14%	-2.38%	-	-
Horiz. %	59.36%	65.95%	59.83%	62.72%	88.70%	97.62%	100.00%	-
								-
YoY %	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	-	-
Horiz. %	-	-	-	-	-	-	-	-
NP to SH	48,666	54,063	49,037	51,439	72,828	80,153	82,107	-8.34%
YoY %	-9.98%	10.25%	-4.67%	-29.37%	-9.14%	-2.38%	-	-
Horiz. %	59.27%	65.84%	59.72%	62.65%	88.70%	97.62%	100.00%	-
								-
YoY %	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	-	-
Horiz. %	-	-	-	-	-	-	-	-
Tax Rate	25.55%	25.18%	25.71%	25.02%	24.54%	25.36%	25.31%	-
YoY %	1.47%	-2.06%	2.76%	1.96%	-3.23%	0.20%	-	-
Horiz. %	100.95%	99.49%	101.58%	98.85%	96.96%	100.20%	100.00%	-
Total Cost	600,544	571,164	483,362	409,971	537,702	595,006	447,283	5.02%
YoY %	5.14%	18.16%	17.90%	-23.75%	-9.63%	33.03%	-	-
Horiz. %	134.26%	127.70%	108.07%	91.66%	120.22%	133.03%	100.00%	-
								-
YoY %	0.00%	0.00%	0.00%	0.00%	0.00%	0.00%	-	-
Horiz. %	-	-	-	-	-	-	-	-
Net Worth	825,484	790,040	748,607	712,393	673,703	615,827	554,783	6.84%
YoY %	4.49%	5.53%	5.08%	5.74%	9.40%	11.00%	-	-
Horiz. %	148.79%	142.41%	134.94%	128.41%	121.44%	111.00%	100.00%	-

	31/03/20	31/03/19	31/03/18	31/03/17	31/03/16	31/03/15	31/03/14	CAGR
Dividend
Div	13,188	13,188	13,188	13,184	13,200	15,389	18,784	-5.71%
YoY %	0.00%	0.00%	0.03%	-0.12%	-14.22%	-18.07%	-	-
Horiz. %	70.21%	70.21%	70.21%	70.19%	70.27%	81.93%	100.00%	-
Div Payout %	27.10%	24.39%	26.89%	25.63%	18.13%	19.20%	22.88%	-
YoY %	11.11%	-9.30%	4.92%	41.37%	-5.57%	-16.08%	-	-
Horiz. %	118.44%	106.60%	117.53%	112.02%	79.24%	83.92%	100.00%	-

	31/03/20	31/03/19	31/03/18	31/03/17	31/03/16	31/03/15	31/03/14	CAGR
Equity
Net Worth	825,484	790,040	748,607	712,393	673,703	615,827	554,783	6.84%
YoY %	4.49%	5.53%	5.08%	5.74%	9.40%	11.00%	-	-
Horiz. %	148.79%	142.41%	134.94%	128.41%	121.44%	111.00%	100.00%	-
NOSH	582,676	582,676	582,676	582,676	549,155	549,747	552,188	0.89%
YoY %	0.00%	0.00%	0.00%	6.10%	-0.11%	-0.44%	-	-
Horiz. %	105.52%	105.52%	105.52%	105.52%	99.45%	99.56%	100.00%	-

	31/03/20	31/03/19	31/03/18	31/03/17	31/03/16	31/03/15	31/03/14	CAGR
Ratio Analysis
NP Margin	7.51%	8.66%	9.23%	11.16%	11.93%	11.87%	15.51%	-
YoY %	-13.28%	-6.18%	-17.29%	-6.45%	0.51%	-23.47%	-	-
Horiz. %	48.42%	55.83%	59.51%	71.95%	76.92%	76.53%	100.00%	-
ROE	5.90%	6.84%	6.55%	7.22%	10.81%	13.02%	14.80%	-
YoY %	-13.74%	4.43%	-9.28%	-33.21%	-16.97%	-12.03%	-	-
Horiz. %	39.86%	46.22%	44.26%	48.78%	73.04%	87.97%	100.00%	-

	31/03/20	31/03/19	31/03/18	31/03/17	31/03/16	31/03/15	31/03/14	CAGR
Per Share
RPS	118.16	113.79	96.90	83.98	111.18	122.81	95.87	3.54%
YoY %	3.84%	17.43%	15.38%	-24.46%	-9.47%	28.10%	-	-
Horiz. %	123.25%	118.69%	101.07%	87.60%	115.97%	128.10%	100.00%	-
EPS	8.86	9.84	8.92	9.36	13.26	14.58	14.87	-8.26%
YoY %	-9.96%	10.31%	-4.70%	-29.41%	-9.05%	-1.95%	-	-
Horiz. %	59.58%	66.17%	59.99%	62.95%	89.17%	98.05%	100.00%	-
DPS	2.40	2.40	2.40	2.40	2.40	2.80	3.40	-5.63%
YoY %	0.00%	0.00%	0.00%	0.00%	-14.29%	-17.65%	-	-
Horiz. %	70.59%	70.59%	70.59%	70.59%	70.59%	82.35%	100.00%	-
NAPS	1.5022	1.4377	1.3623	1.2964	1.2268	1.1202	1.0047	6.92%
YoY %	4.49%	5.53%	5.08%	5.67%	9.52%	11.50%	-	-
Horiz. %	149.52%	143.10%	135.59%	129.03%	122.11%	111.50%	100.00%	-

	31/03/20	31/03/19	31/03/18	31/03/17	31/03/16	31/03/15	31/03/14	CAGR
Adjusted Per Share Value based on latest NOSH - 582,676
RPS	111.43	107.32	91.39	79.20	104.78	115.87	90.85	3.45%
YoY %	3.83%	17.43%	15.39%	-24.41%	-9.57%	27.54%	-	-
Horiz. %	122.65%	118.13%	100.59%	87.18%	115.33%	127.54%	100.00%	-
EPS	8.35	9.28	8.42	8.83	12.50	13.76	14.09	-8.34%
YoY %	-10.02%	10.21%	-4.64%	-29.36%	-9.16%	-2.34%	-	-
Horiz. %	59.26%	65.86%	59.76%	62.67%	88.72%	97.66%	100.00%	-
DPS	2.26	2.26	2.26	2.26	2.27	2.64	3.22	-5.72%
YoY %	0.00%	0.00%	0.00%	-0.44%	-14.02%	-18.01%	-	-
Horiz. %	70.19%	70.19%	70.19%	70.19%	70.50%	81.99%	100.00%	-
NAPS	1.4167	1.3559	1.2848	1.2226	1.1562	1.0569	0.9521	6.84%
YoY %	4.48%	5.53%	5.09%	5.74%	9.40%	11.01%	-	-
Horiz. %	148.80%	142.41%	134.94%	128.41%	121.44%	111.01%	100.00%	-

	31/03/20	31/03/19	31/03/18	31/03/17	31/03/16	31/03/15	31/03/14	CAGR
Price Multiplier on Financial Quarter End Date
Date	31/03/20	29/03/19	30/03/18	31/03/17	31/03/16	31/03/15	31/03/14	-
Price	0.99	1.42	1.44	1.69	2.00	1.81	1.76	-
P/RPS	0.84	1.25	1.49	2.01	1.80	1.47	1.84	-12.24%
YoY %	-32.80%	-16.11%	-25.87%	11.67%	22.45%	-20.11%	-	-
Horiz. %	45.65%	67.93%	80.98%	109.24%	97.83%	79.89%	100.00%	-
P/EPS	11.18	14.43	16.14	18.05	15.08	12.41	11.84	-0.95%
YoY %	-22.52%	-10.59%	-10.58%	19.69%	21.51%	4.81%	-	-
Horiz. %	94.43%	121.88%	136.32%	152.45%	127.36%	104.81%	100.00%	-
EY	8.95	6.93	6.20	5.54	6.63	8.06	8.45	0.96%
YoY %	29.15%	11.77%	11.91%	-16.44%	-17.74%	-4.62%	-	-
Horiz. %	105.92%	82.01%	73.37%	65.56%	78.46%	95.38%	100.00%	-
DY	2.42	1.69	1.67	1.42	1.20	1.55	1.93	3.83%
YoY %	43.20%	1.20%	17.61%	18.33%	-22.58%	-19.69%	-	-
Horiz. %	125.39%	87.56%	86.53%	73.58%	62.18%	80.31%	100.00%	-
P/NAPS	0.66	0.99	1.06	1.30	1.63	1.62	1.75	-14.98%
YoY %	-33.33%	-6.60%	-18.46%	-20.25%	0.62%	-7.43%	-	-
Horiz. %	37.71%	56.57%	60.57%	74.29%	93.14%	92.57%	100.00%	-

	31/03/20	31/03/19	31/03/18	31/03/17	31/03/16	31/03/15	31/03/14	CAGR
Price Multiplier on Announcement Date
Date	18/06/20	23/05/19	24/05/18	25/05/17	19/05/16	21/05/15	22/05/14	-
Price	1.08	1.38	1.36	1.66	1.69	1.95	2.03	-
P/RPS	0.91	1.21	1.40	1.98	1.52	1.59	2.12	-13.13%
YoY %	-24.79%	-13.57%	-29.29%	30.26%	-4.40%	-25.00%	-	-
Horiz. %	42.92%	57.08%	66.04%	93.40%	71.70%	75.00%	100.00%	-
P/EPS	12.19	14.03	15.24	17.73	12.74	13.37	13.65	-1.86%
YoY %	-13.11%	-7.94%	-14.04%	39.17%	-4.71%	-2.05%	-	-
Horiz. %	89.30%	102.78%	111.65%	129.89%	93.33%	97.95%	100.00%	-
EY	8.20	7.13	6.56	5.64	7.85	7.48	7.32	1.90%
YoY %	15.01%	8.69%	16.31%	-28.15%	4.95%	2.19%	-	-
Horiz. %	112.02%	97.40%	89.62%	77.05%	107.24%	102.19%	100.00%	-
DY	2.22	1.74	1.76	1.45	1.42	1.44	1.67	4.85%
YoY %	27.59%	-1.14%	21.38%	2.11%	-1.39%	-13.77%	-	-
Horiz. %	132.93%	104.19%	105.39%	86.83%	85.03%	86.23%	100.00%	-
P/NAPS	0.72	0.96	1.00	1.28	1.38	1.74	2.02	-15.78%
YoY %	-25.00%	-4.00%	-21.88%	-7.25%	-20.69%	-13.86%	-	-
Horiz. %	35.64%	47.52%	49.50%	63.37%	68.32%	86.14%	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