Sri Lanka Equity Forum
Dear Reader,

Registration with the Sri Lanka Equity Forum would enable you to enjoy an array of other services such as Member Rankings, User Groups, Own Posts & Profile, Exclusive Research, Live Chat Box etc..

All information contained in this forum is subject to Disclaimer Notice published.


Thank You
Sri Lanka Equity Forum

Discussion Forum for Stock Market Investors in Sri Lanka

සිංහල පරිවර්තනය
Contribute
Submit Post

Latest topics

» LANKA IOC PLC (LIOC.N0000)
by Teller Today at 10:35 am

» Dhammika Perera Aquire ALUF @23 Now at 50%Discount
by ColomboCSE Today at 10:30 am

» Investment Advice
by Gajaya Today at 9:17 am

» කාලෙකට පස්සෙ එන අවස්තාවක් උදා වෙලා කියලයි - හැබැයි අවදානම තියනවා
by Kipling Yesterday at 9:31 pm

» LOLC FINANCE PLC (LOFC.N0000)
by wealth123 Yesterday at 9:07 pm

» Undervalued Stocks
by Promoney Yesterday at 6:43 pm

» VALLIBEL FINANCE PLC (VFIN.N0000)
by NANDANA2012 Yesterday at 4:47 pm

» ALLIANCE FINANCE COMPANY PLC (ALLI.N0000)
by Teller Yesterday at 1:54 pm

» MELSTACORP PLC (MELS.N0000)
by roshan1039 Yesterday at 12:43 pm

» OVERSEAS REALTY (CEYLON) PLC (OSEA.N000)
by KavinduTM Fri Dec 13, 2019 11:08 pm

» MANUFACTURING OF PORCEIAIN MOSATC TTLES FOR EXPORT MARKET
by engineer Fri Dec 13, 2019 10:17 pm

» Shares to Buy
by hammurabi Fri Dec 13, 2019 2:10 pm

» Recognize TRENDS
by target1 Fri Dec 13, 2019 12:57 pm

» LANKA ORIX LEASING COMPANY PLC
by Beta1 Fri Dec 13, 2019 10:59 am

» EAST WEST PROPERTIES PLC (EAST.N0000)
by Winner123 Fri Dec 13, 2019 10:51 am

» Sri Lanka facilitating first US$400mn investment at Port City: Cabraal
by ipo Fri Dec 13, 2019 9:34 am

» POSITIVE ECONOMIC & POLITICAL STABILITY
by Kipling Fri Dec 13, 2019 9:30 am

» COLO and DOCK Moving to 100
by Jay-Jay Fri Dec 13, 2019 9:00 am

» CITRUS LEISURE PLC (REEF.N0000)
by Hope123 Fri Dec 13, 2019 7:30 am

» Saudi Aramco shares surge 10% first day of trading
by Teller Thu Dec 12, 2019 9:39 pm

» Sri Lanka interest rates should go down, currency will not fall: Mark Mobius
by NANDANA2012 Thu Dec 12, 2019 7:03 pm

POPULAR COMPANIES
A

ABANS ELECTRICALS PLC

ACCESS ENGINEERING PLC Hot

ACL CABLES PLC

ACL PLASTICS PLC

ACME PRINTING & PACKAGING PLC

AGSTAR PLC

AITKEN SPENCE HOTEL HOLDINGS PLC

AITKEN SPENCE PLC

ANILANA HOTELS AND PROPERTIES PLC

ARPICO INSURANCE PLC

ASIA ASSET FINANCE PLC

ASIA CAPITAL PLC

B

BAIRAHA FARMS PLC

BALANGODA PLANTATIONS PLC

BIMPUTH FINANCE PLC

BLUE DIAMONDS JEWELLERY WORLDWIDE PLC

B P P L HOLDINGS PLC

BROWNS BEACH HOTELS PLC

BROWNS INVESTMENTS PLC

C

CARGO BOAT DEVELOPMENT COMPANY PLC

CENTRAL INDUSTRIES PLC

CEYLON COLD STORES PLC

CEYLON GRAIN ELEVATORS PLC Hot

CEYLON TEA BROKERS PLC

CEYLON TOBACCO COMPANY PLC

CHEVRON LUBRICANTS LANKA PLC

COLOMBO FORT LAND & BUILDING PLC

COMMERCIAL BANK OF CEYLON PLC

CITRUS LEISURE PLC Hot

COMMERCIAL CREDIT AND FINANCE PLC

D

DANKOTUWA PORCELAIN PLC

DFCC BANK PLC

DIALOG AXIATA PLC

DIALOG FINANCE PLC

DIPPED PRODUCTS PLC

DISTILLERIES COMPANY OF SRI LANKA PLC

DUNAMIS CAPITAL PLC

E

EAST WEST PROPERTIES PLC Hot

EASTERN MERCHANTS PLC

EXPOLANKA HOLDINGS PLC

E-CHANNELLING PLC

F

FIRST CAPITAL HOLDINGS PLC

G

GALADARI HOTELS (LANKA) PLC

GUARDIAN CAPITAL PARTNERS PLC

H

HATTON NATIONAL BANK PLC

HAYLEYS PLC

HAYLEYS FABRIC PLC

HAYLEYS FIBRE PLC Hot

HEMAS HOLDINGS PLC

HIKKADUWA BEACH RESORT PLC

HNB ASSURANCE PLC

HVA FOODS PLC

J

JANASHAKTHI INSURANCE COMPANY PLC

JOHN KEELLS HOLDINGS PLC Hot

JOHN KEELLS HOTELS PLC

L

LANKA ASHOK LEYLAND PLC

LANKA IOC PLC

LANKEM CEYLON PLC

LANKEM DEVELOPMENTS PLC

LAUGFS GAS PLC

LAUGFS POWER LIMITED

LOLC FINANCE PLC

LOLC HOLDINGS PLC

LUCKY LANKA MILK PROCESSING COMPANY PLC

M

MELSTACORP PLC

N

NATIONAL DEVELOPMENT BANK PLC

NATION LANKA FINANCE PLC

NESTLE LANKA PLC

O

ORIENT FINANCE PLC

OVERSEAS REALTY (CEYLON) PLC

P

PANASIAN POWER PLC

PEOPLE'S LEASING & FINANCE PLC

PIRAMAL GLASS CEYLON PLC

PRIME FINANCE PLC

R

RAIGAM WAYAMBA SALTERNS PLC

RENUKA AGRI FOODS PLC

RENUKA CAPITAL PLC

RENUKA HOLDINGS PLC

RICHARD PIERIS AND COMPANY PLC

RICHARD PIERIS EXPORTS PLC Hot

ROYAL CERAMICS PLC

S

SAMPATH BANK PLC

SEYLAN BANK PLC

SIERRA CABLES PLC

SINGHE HOSPITALS PLC Hot

SMB LEASING PLC

SOFTLOGIC HOLDINGS PLC

SOFTLOGIC LIFE INSURANCE PLC

SRI LANKA TELECOM PLC

SWISSTEK (CEYLON) PLC Hot

T

TEEJAY LANKA PLC

TESS AGRO PLC

THREE ACRE FARMS PLC

TOKYO CEMENT COMPANY (LANKA) PLC Hot

U

UNION BANK OF COLOMBO PLC

V

VALLIBEL FINANCE PLC

VALLIBEL ONE PLC Hot

VALLIBEL POWER ERATHNA PLC

W

WASKADUWA BEACH RESORT PLC

Advertise

You are not connected. Please login or register

Sri Lanka Equity Forum » Stock Market Talk » AITKEN SPENCE HOTEL HOLDINGS PLC (AHUN.N0000)

AITKEN SPENCE HOTEL HOLDINGS PLC (AHUN.N0000)

Go to page : Previous  1, 2, 3  Next

Go down  Message [Page 2 of 3]

21AITKEN SPENCE HOTEL HOLDINGS PLC (AHUN.N0000) - Page 2 Empty AHUN, is this Undervalued? on Sat May 14, 2011 2:53 pm

xhora


Senior Manager - Equity Analytics
Senior Manager - Equity Analytics
I have done some research into AHUN.N as I brought this at 90.40. This is my first time publishing something like this so this may be completely wrong. And please correct me if I'm wrong. So here we go.

I have collected data from financial statements available from June 2009
Note that all figures in Millions and rounded to the nearest integer.







FY 2009/2010



Q4 March 2010



Q1 June 2010



Q2 Sep 2010



Q3 Dec 2010



Revenue



7,326



2,416



1,514



1,783



2,076



Oprating Prof.



1,152



698



5



195



351



Net Profit to

Equity Holders



523



419



18



152



272



NA



5189



5189



7585



8292



8549



Shares



38.4



38.4



48



48



336


Comparison of results between 2010 & 2009







Q1 June



Q2 September



Q3 December



Q4 March



2009/2010



(114)



8.5



210



419



2010/2011



18



152



272



N/A



Change %



220%



160%



30%



N/A


The drop in profitability in June quarter is evident from results as far as from 2008. This maybe due to low tourist arrivals in summer season. But overall we can see that profitability has gone up. And AHUN has expanded it's portfolio of hotels in the past year.

Trailing PE calculation

Profits attributable to Equity Holders
419+18+152+272 = 861 Million

Weighted average Shares
38.4X3/12 + 48 X 6/12 + 336 X 3/12 = 117.6 million

So EPS as per accounting Standers using weighted average
861/117.6 = 7.32

Using current shares of 336 million
EPS would be 861/336 = 2.56

Using the latest closing price of Rs.91.20
Accounting PE (91.20/7.32) = 12.46
Normal PE (91.20/2.56) = 35.63

Expected Earnings
With the growth of overall tourism sector and considering the peak tourist arrivals in March quarter it would be safe to assume that we can see at least 20% growth in March 2010 quarter with respect to March 2009 results.

So Expected Profits = 419 X 120% = 503

With this expected earnings for FY 2010/2011
18+152+272+503 = 945
This is a 80% growth compared to last year.

Weighted average shares
48 X 6/12 +336 X 6/12 = 192

Accounting EPS = 945/192 = 4.92
Corresponding PE ration (91.20/4.92) = 18.53

Normal EPS (945/336) = 2.81
Corresponding PE ration (91.20/2.81) = 32.45

Technical Analysis

AITKEN SPENCE HOTEL HOLDINGS PLC (AHUN.N0000) - Page 2 Ahun10

I'm not a master of Technical Analysis but yesterday AHUN has formed a pattern called "MORNING STAR" Pattern. This is a bullish reversal Indication. And also note that the MACD has crossed over and volumes are growing. Is this a start of a Bullish run from AHUN? If so what will be the upper limit for this counter?

Summery







Accounting



Normal



Trialling PE



12.46



35.63



Expected PE



18.53



32.45


Experts what is a suitable PE ratio for Hotel industry?
According to CSE, Hotel and Travel sector has a PE ration of around 100. And Most of the resorts that are similar to AHUN has PE around 40~50.

Is this share overvalued at the current price? What will be the future of AHUN?

Slstock


Director - Equity Analytics
Director - Equity Analytics
Xhora

Very good effort and analysis. Rep from me though I don';t own this share as of now.


I admit I did not have time to look at all your numbers. I cannot say AHUN is undervalued still. Maybe compared to most other hotel sector shares which are highly overvalued to start with. Some trade at amazing PEs . Everybody is paying premium still expecting higher growth from this sector.

However out of the big bunch , AHUN is a solid hotel stock which paying a premium will not prove not too bad for long term. They have clear growth plans and as I recall they the sixth sense project etc will bring more profit in the future. If you can hold long term AHUN is a decent bet.



Last edited by slstock on Sat May 14, 2011 3:27 pm; edited 1 time in total

StocksWatch


Assistant Vice President - Equity Analytics
Assistant Vice President - Equity Analytics
Xhora, very good post. + Rep from me as well.

In general, I am not interested in investing in Hotel stocks for sometime as most of them are massively overvalued. (Other than RENU which is not based on generating revenue from only hotel operations)

Assuming your calculations are correct (no doubt though), AHUN seems to be a better selection in the sector. But nothing can be said for short term.

seyon


Assistant Vice President - Equity Analytics
Assistant Vice President - Equity Analytics
Nice analysis xhora.......

Nine months as of 31.12.2009 consolidated profit.... 508Mn and EPS for the nine months about 1.51...( 508Mn/336Mn),Further if expect 400Mn for the last quarter then PE would be in the range of 32x-35x.... Which is slightly high comparing with the Mkt PE (27X). However when u compare with REEF, MARA, STAF and others.... this is a good choice for the long term.. Further AHUN is joint partners of Six Senses hotel project which is worth of USD 35-40 Mn http://www.cse.lk/cmt/uploadAnnounceFiles/1741285843549_521.pdf and recent BBH take over also will boost the group earnings....

I guess that most of the hotels are reflected their future earning in their value... Some of the hotels are under refurbishment ( PALM,BHR,MARA) We do not know that how long time take to break even their cost of refurbishment... So do more analysis before enter to hotel sector...

Happy Trading

Monster


Senior Vice President - Equity Analytics
Senior Vice President - Equity Analytics
Excellent analysis xhora. Even I do not hold AHUN. But AHUN is one of the best stock in the hotel sector. +Rep from me as well for your hard work.

Quibit

Quibit
Senior Vice President - Equity Analytics
Senior Vice President - Equity Analytics
I am beginning to believe in hotel stocks. AHUN is undoubtedly one of best Srilankan hotel chains. Thanks!! + from me for your wonderful contribution and look forward in seen more contribution from you.

RockStock


Manager - Equity Analytics
Manager - Equity Analytics
Great analysis, + rep from me as well

smallville

smallville
Associate Director - Equity Analytics
Associate Director - Equity Analytics
Good report..

Since there was a sub division of 1:7, last quarter EPs could be calculated as per the original no of shares for the last qtr..
EPS in each quarter for last 3 qtrs = 18/48 + 152/48 + 272/(336/7) = 0.375 + 3.16 + 5.66 = 9.195
If annualised =12.26.. So accordingly other calculations follow..

Gaja


Associate Director - Equity Analytics
Associate Director - Equity Analytics
Presently i don't have any hotel stock in my portfolio, in my personal opinion AHUN and KHL is UNDER VALUED SHARES FOR THE LONG TERM INVESTMENTS and if anyone think for short term gains don't touch it these

xhora

xhora
Senior Manager - Equity Analytics
Senior Manager - Equity Analytics
@smallville wrote:Good report..

Since there was a sub division of 1:7, last quarter EPs could be calculated as per the original no of shares for the last qtr..
EPS in each quarter for last 3 qtrs = 18/48 + 152/48 + 272/(336/7) = 0.375 + 3.16 + 5.66 = 9.195
If annualised =12.26.. So accordingly other calculations follow..

I don't understand the rationale behind taking 48 million shares as for the entire year. according to your calculation EPS would be (91.2/12.26) 7.44 Way bellow average.

But since I believe we always has to account for the conditions that will be prevailing in the foreseeable future because share prices are always valued for future earnings. So I think taking 336 million shares is the best approach.

udeni

udeni
Manager - Equity Analytics
Manager - Equity Analytics
xhora,
Thanks for the very informative post. Hope to see many more of this calibre reports.

smallville

smallville
Associate Director - Equity Analytics
Associate Director - Equity Analytics
@xhora wrote:
@smallville wrote:Good report..

Since there was a sub division of 1:7, last quarter EPs could be calculated as per the original no of shares for the last qtr..
EPS in each quarter for last 3 qtrs = 18/48 + 152/48 + 272/(336/7) = 0.375 + 3.16 + 5.66 = 9.195
If annualised =12.26.. So accordingly other calculations follow..

I don't understand the rationale behind taking 48 million shares as for the entire year. according to your calculation EPS would be (91.2/12.26) 7.44 Way bellow average.

But since I believe we always has to account for the conditions that will be prevailing in the foreseeable future because share prices are always valued for future earnings. So I think taking 336 million shares is the best approach.

From this calc (91.2/12.26) = 7.44, wat u get as 7.44 is the P/E not EPS..

Taking 48 mil was due to the last subdiv happen on dec qtr and we only have 3 qtr results so far.. from Q2, u can take the new 336 Mil shares for calculations.. This is becuz the financial year ends on 31 March and its not fair to dilute the EPS in the middle.. well thats how I think..
When companies do subs, EPS gets diluted... Approaches are different from person to person..

Slstock

Slstock
Director - Equity Analytics
Director - Equity Analytics
@smallville wrote:
@xhora wrote:
@smallville wrote:Good report..

Since there was a sub division of 1:7, last quarter EPs could be calculated as per the original no of shares for the last qtr..
EPS in each quarter for last 3 qtrs = 18/48 + 152/48 + 272/(336/7) = 0.375 + 3.16 + 5.66 = 9.195
If annualised =12.26.. So accordingly other calculations follow..

I don't understand the rationale behind taking 48 million shares as for the entire year. according to your calculation EPS would be (91.2/12.26) 7.44 Way bellow average.

But since I believe we always has to account for the conditions that will be prevailing in the foreseeable future because share prices are always valued for future earnings. So I think taking 336 million shares is the best approach.

From this calc (91.2/12.26) = 7.44, wat u get as 7.44 is the P/E not EPS..

Taking 48 mil was due to the last subdiv happen on dec qtr and we only have 3 qtr results so far.. from Q2, u can take the new 336 Mil shares for calculations.. This is becuz the financial year ends on 31 March and its not fair to dilute the EPS in the middle.. well thats how I think..
When companies do subs, EPS gets diluted... Approaches are different from person to person..

It would be easier to go with the EPS calculation AHUN already did for us considering shares in the market during different periods

9 Month EPS as at DEC is 1.29

If expecting profit of 503 mil for march then : March eps = 503 / 336 = 1.497
( but we need to remember to leave out any minority interest also)

SO Annual eps = 1.29 + 1.497= 2.79

PE = 91.2/2.78=32.68

Thats why I mentioned "I cannot say AHUN is undervalued still. Maybe compared to most other hotel sector shares which are highly overvalued to start with. Some trade at amazing PEs . Everybody is paying premium still expecting higher growth from this sector.

However out of the big bunch , AHUN is a solid hotel stock which paying a premium will not prove not too bad for long term. They have clear growth plans and as I recall they the sixth sense project etc will bring more profit in the future. If you can hold long term AHUN is a decent bet. "

xhora

xhora
Senior Manager - Equity Analytics
Senior Manager - Equity Analytics
AHUN has exceeded my expected earnings figure and had made a Billion rupee profit for the year
http://www.cse.lk/cmt/upload_report_file/521_1306748885393.pdf

35AITKEN SPENCE HOTEL HOLDINGS PLC (AHUN.N0000) - Page 2 Empty AHUN.N0000 Reports on Sun Jun 02, 2013 12:19 pm

worthiness


Senior Vice President - Equity Analytics
Senior Vice President - Equity Analytics

Please insert the pdf file or latest financial statements of AHUN.N0000.
Be grateful for inserting the comments based on latest performance.
Thanks

Redbulls

Redbulls
Director - Equity Analytics
Director - Equity Analytics

salt

salt
Vice President - Equity Analytics
Vice President - Equity Analytics
They have done well. But, valuation are exorbitant

besthope


Manager - Equity Analytics
Manager - Equity Analytics
@salt wrote:They have done well. But, valuation are exorbitant

your saltiness, what is meaning of word exorbitant ?
is it out of orbit
OR BIT by ANT before ?

cseguide

cseguide
Assistant Vice President - Equity Analytics
Assistant Vice President - Equity Analytics
@besthope wrote:
@salt wrote:They have done well. But, valuation are exorbitant

your saltiness, what is meaning of word exorbitant ?
is it out of orbit
OR BIT by ANT before ?
yes what is the problem of valuation?

salt

salt
Vice President - Equity Analytics
Vice President - Equity Analytics
I am not an expert of English language
You may refer to a dictionary

This the definition from Cambridge Advanced Learner's Dictionary

exorbitant /Ig"zO:.bI.t@nt/ /-"z:Or.b@.º@nt/ adjective
Exorbitant prices and demands, etc. are much too large:
The bill for dinner was exorbitant.




cseguide

cseguide
Assistant Vice President - Equity Analytics
Assistant Vice President - Equity Analytics
@salt wrote:I am not an expert of English language
You may refer to a dictionary

This the definition from Cambridge Advanced Learner's Dictionary

exorbitant /Ig"zO:.bI.t@nt/ /-"z:Or.b@.º@nt/ adjective
Exorbitant prices and demands, etc. are much too large:
The bill for dinner was exorbitant.




@salt
you mean their hotel charges are high or any other ?

salt

salt
Vice President - Equity Analytics
Vice President - Equity Analytics
@cseguide
My apologies, if i have misled you
I was referring to share price
The valuation of share is expensive

Annual EPS Rs. 5.26
NAVPS 37.95

Share trades almost 80.00. Unjustifiable valuation, isn't it?

cseguide

cseguide
Assistant Vice President - Equity Analytics
Assistant Vice President - Equity Analytics
@salt wrote:@cseguide
My apologies, if i have misled you
I was referring to share price
The valuation of share is expensive

Annual EPS Rs. 5.26
NAVPS 37.95

Share trades almost 80.00. Unjustifiable valuation, isn't it?
I don't think so. This counter values
Reasons
1)80/5.26 = PER =15
2) on of the best managed hotel group
3) well diversified around different geographical areas
etc.

besthope


Manager - Equity Analytics
Manager - Equity Analytics
@salty - how about AHUN profile of investors ? hondai the ?

salt

salt
Vice President - Equity Analytics
Vice President - Equity Analytics
@besthope
If its lazy sunday afternoon & nobody at home, i just look at profile of next door residents ( opposite gender)
Very Happy

Sponsored content


Back to top  Message [Page 2 of 3]

Go to page : Previous  1, 2, 3  Next

Permissions in this forum:
You cannot reply to topics in this forum