You can get my latest update on share analysis at Telegram Channel ==> https://t.me/davidshare
Disclaimer:
This writing is based on my own assumptions and estimations. It is strictly for sharing purpose, not a buy or sell call of the company.
Highlights:
Worry about high jet fuel price effect on Airasia’s profit?
Many may think high fuel price (specifically is jet fuel) will affect Airasia’s profit. No doubt Airasia cost is correlated to jet fuel cost but I would like to show you that there is a way to mitigate the fuel cost by increasing the carried capacity (more aircrafts, more available seat, lower cost per unit). To understand airline operation cost, it is important to know what is Cost per ASK (Available Seat Kilometers). ASK of an airline refer to passenger carrying capacity or in other word is equal to the number of seats available multiplied by the number of or kilometers flown. Cost per ASK can give us of an airline Unit Cost (include jet fuel cost). Let us go through the cost per ASK for Airasia when it experienced high jet fuel cost in 1Q2018 as below:
Source: 1Q18 report
What I can notice from the table above is Cost / ASK (sen) dropped to 13.55 sen as compared to 13.61 YoY when Average Fuel Price (US / barrel) has increased from 76 to 83 (increased 9%)
How Airasia can maintain this low Cost / ASK while jet fuel cost is at high level of US83 per barrel? Airasia manage to maintain low Cost / ASK in 1Q18 is due to the following reasons:
This exhibit high efficiency of Airasia in control their cost and at the same time increase their revenue which achieved an operation profit of RM640M in 1Q18 (refer to report of 1Q18). In addition, their net gearing has improved to 0.9x (net debt of 7.1 billion) from previously 1.11x (4Q17). Net cash inflow in the quarter amounted to RM170.5 million.
Airasia only hedged about 12% of its FY18F jet fuel needs at US$69/ barrel. The higher average jet fuel cost may pressure Airasia’s earnings but the impact maybe not so big in view of its efficiency in cost control (by higher aircraft utilization, higher passenger carried and load factor). Let see the June 2018 statistic of KLIA2 passengers as published by Airport Berhad Malaysia (Theedge news) as below:
Source: http://www.theedgemarkets.com/article/strong-load-factor-seen-aviation-industry
The traffic in May and June should be helped by General Election 14, Ramadan and Hari Raya Aidifiltri travelling where Airasia has increased their flights frequently during these periods.
Remember, Airasia still achieved relative good profit under Jet fuel price of USD83 in 1Q18 while MAS reduced 263 weekly flights and Malindo reduce 364 weekly flights (Domestic and Int). Source: Refer to page no 4 of the Airasia 1Q2018 result presentation slides.
How to do a stock Valuation?
For me, valuation of a stock is a combination of Math and art. By using Math, one may calculate its PE, discounted cash flow, NTA (net tangible asset) etc to get a valuation. By using art, one needs to imagine the future growth (may due to expansion), future profit catalyst, future new products, future product selling price and cost. By combining these two valuation methods can lead to a more comprehensive quantitative and qualitative analysis.
Anyway, there is a lot of assumption need to be made for both methods of valuation. I normally feel comfortable with the assumptions and my investment decision may not solely depend on valuation. The assumptions could be wrong and can lead the wrong valuation sometime. Valuation is only good when you are plan to dispose the assets or for valuer to judge the NTA or book value. Personally I treat book value just as a guideline but not as the rule to follow. Practicing valuation is more for us to understand the margin of safety of our investment.
3 types of value in a Stock
The question is how to translate your expectation of the company into numbers?
How do I value Airasia?
Method 1: By current earning power (PE)
Due to Airasia is in the mid of rationalization of its non-core assets (two assets already sold, AAC in the final stage of disposal), so PE valuation method is applicable to some of the Airasia non-core assets. Let see what are the Airasia's subsidiaries, Joint venture (including digital venture) and associate companies as below:
Price tag and enterprise value for each business of Airasia
AirAsia has sealed a deal to dispose its aircraft leasing operations (under AAC) to BBAM (namely Herondell, Incline B and FLY Leasing) for a total consideration of US$1,185M (RM4.536billion), inclusive of cash US$1,085m (RM4.2bn). The enterprise value (EV) of AAC operation is US$2,846.2m (RM11.1bn). The disposal of AAC includes existing 80 aircrafts, up-coming 4 new aircrafts and existing 14 aircraft engines.
Based on the EV valuation, AAC is valued at PE of 17x for FY17 (estimated US$68m profit contribution to AirAsia), substantially higher than AirAsia PE of about 10x (based on EPS of 30.7sen which excludes remeasurement gain on GTR and disposal gain, include these gain, PE is about 5x).
The interesting part of completion of AAC sales is Airasia group will become a net cash airline company, where transfer of debt of RM6.5 billion to BBAM and part of the proceeds will be used to repay its borrowings. The impact to sales of AAC includes loss of income and higher lease expenses of about RM403M, which can be offset by savings of RM110M finance costs and RM206M depreciations (depreciation goes to new owner BBAM) for Airasia.
From the table of enterprise value, the estimated profit of Airasia for FY2019 (after AAC sales and special div) is about 1.260 billion, which translated to EPS of 36 sen. With PE multiple valuation of 11x, Airasia should worth RM3.96 per share. This is just solely based on current earning power from airline business of Airasia without considering its digital venture businesses potential. Table below is a comparison for different budget airlines in the world (sector average PEx is 15x).
Source: Bloomberg and Airasia 1Q2018 result presentation slides
Method 2: By Future Growth value (PEG)
The price/earnings to growth ratio (PEG ratio) is a stock's price-to-earnings (P/E) ratio divided by the growth rate of its earnings for a specified time period. The PEG ratio is used to determine a stock's value while taking the company's future earnings growth into account and is considered to provide a more complete picture for a growing company.
The PEG ratio formula for a company is as follows:
PEG Ratio = Price-to-Earnings (PE) / Annual Earnings Per Share Growth
The is coming from the future growth potential of the company and the value is the collection of cash flow generated from the company in the future. However, the future is uncertain but huge potential.
Airasia Digital Transformation (BIG PAY, OURSHOP, Rokki etc using Big Data and AI Technology)
Most of the young generation lifestyle is digital-oriented. Before I talk about digital transformation of Airasia, let me show you some of the companies that running digital related businesses. Some of the big name of these companies including Alibaba (Alipay, 支付宝 is not listed under Alibaba), Tencent (Wechat pay), Amazon (Amazon pay, its platform), Grab (Grab pay), Paypal. Some of the local cashless payment solution providers in Bursa including Ghlsys and Revenue. Let see market valuation of these e-commerce and digital pay related companies.
Source: Investing.com and Malaysiastockbiz.com
What I can observe the above companies (except GHL and Revenue) is they possess a big database of customer and they can sell products/services to them. As of the 2016 report, Amazon had 310 million active customers. In the most recently reported quarter, Tencent's WeChat had 963 million monthly active users. For Alibaba, its online shopping customers as of the third quarter of 2017 is 488 million active buyers who ever access its Taobao platform in the previous twelve months. For Paypal, in the first quarter of 2018, there was 237 million customers active worldwide.
Findings:
Let see how big the customer database of Airasia as table and figure below:
Source: Annual report of 2015, 2016, 2017
Source: Annual report of 2017
From the table, we can observe that Airasia has carried 65.5 mil passengers in 2017 and expected to carry 89 mil passengers in 2018. Besides, their airasia.com website has 125 mil page views per month and 27 mil unique visitors per month. What I can forecast it their expected customer database in 2018 easily reach 89 mil and this figure may reach 100 mil in 2019-2020.
FYI, Airaisa current revenue via internet rate (mainly from ticket sales) is 70.4% (source from AR 2017). What Airasia want to do in in 2018-2020 is digitalization or digital venture that extend to or leverage on the same customer database to other businesses like logistic (via red cargo & red box), online duty-free retails marketplace (Ourshop, newly launched in July), mobile payment (BIG PAY), online remittance (BIG PAY, future project), Inflight Wifi (Rokki), Inflight food & beverage (Santan), online financing (provide loan, future project) and other related services.
All these services (especially online duty-free retail) can be helped by using the power of Big Data analytic. Big Data can help in analyze Airasia huge customer database (80M+ passengers) by predicting their future purchasing behavior which resulting higher sales (based on their search, travel destination or past purchase products records)
All these services can help in increasing Airasia Ancillary revenue which they have achieved about RM47 per pax in 1Q18 (including baggage fee). If exclude baggage fee, the ancillary revenue generated by these services is about 262mil in 1Q18 (10% of their 1Q revenue, 11% YoY improvement vs 1Q17). I expect higher contribution from newly introduced online duty-free retail, mobile payment and online remittance services in 2018-2020 revenue.
Let me has a simple forecast on the possible future revenue from online duty-free retail (Ourshop) and mobile payment or e-Wallet (Big Pay) services as table below:
Passenger database size |
*2018 – 89mil *(forecast) |
*2019 – 95mil |
*2020 – 105mil |
Online duty-free retails marketplace (Ourshop) |
Assume 2% of passengers spend RM100 --> RM178 mil revenue |
Assume 3% of passengers spend RM100 --> RM285 mil revenue |
Assume 5% of passengers spend RM100 --> RM525 mil revenue |
Mobile payment (Big Pay) – provide discount on retails, waive on bank/credit card transaction fee on ticket buying, collect BIG points to be used in other platform purchase (like Groupon) |
Assume 1% of passengers using BIG PAY --> Gain 0.89 mil users and collected prepaid some amount of fund (Big Pay is a debit card), Improve Cashflow and future ticket & retail biz. |
Assume 2% of passengers using BIG PAY -->Gain 1.9 mil users and collected prepaid some amount of fund (Big Pay is a debit card), Improve Cashflow and future ticket & retail biz. |
Assume 5% of passengers using BIG PAY --> Gain 5.25 mil users and collected prepaid some amount of fund (Big Pay is a debit card), Further Improve Cashflow and future ticket & retail biz. |
By assuming 10% net profit margin from online duty-free retails and zero profit contribution from Big Pay (due to promotion to attract more customer) in 2018-2020, they will be about 525 mil revenues from and can increase Airasia revenue and net profit by about 5%. Remember, this is just from 1 digital service and there are a few promising services like e-remittance which can send money to their home countries for foreign workers in Malaysia. The advantage of e-remittance is it can reduce the agent transfer fee (money changers, banks) and the transaction can be done through mobile apps. Airasia customer database covers 21 countries (mostly in Asia) and a lot of the customers from middle class and low-income people that work in overseas.
The estimated EPS or profit growth rate for Airasia could be in the range of 10% in 2018 (capacity expansion, exclude one-off asset disposal profit), 12% in 2019 (capacity expansion, cost saving on new aircraft and digital biz contribution) and 15% in 2020 (cost saving using AI and IoT and digital biz contribution). Let assume 10-15% of growth rate in EPS in 2018-2020 to calculate Airasia PEG as table below:
|
2018E* (*estimated) |
2019E* (*estimated) |
2020E* (*estimated) |
PE |
8.7 based on current price of 3.15 |
10 |
12 |
Growth |
10% |
12% |
15% |
EPS (exclude one-off gain on AAC n expedia disposal |
39.6 sen |
40.3 sen |
41.4 sen |
PEG |
0.87 |
0.83 |
0.8 |
A rule of thumb is that any PEG ratio below 1.0 is considered to be a good value. Airasia current valuation still consider cheap based on its forward PE ratio and future growth rate. The PEG ratio of 0.83 for FY2018 indicates that it is still undervalue relative to its growth potential.
|
2018E |
2019E |
PEx |
10-11 |
11-12 |
EPS (exclude one-off disposal gain |
39.5 sen |
40.3 sen |
Fair Price |
RM3.95 -4.35 |
RM4.35 -4.8 |
Let see the last 15 year Airasia carried passenger and its aircraft fleet expansion (CAGR more than 20%) as per chart below.
Risk
I may cover part 2 report of Airasia soon but some data may not for public.
If you interested on my future analysis reports, please contact me at davidlimtsi3@gmail.com
You can get my latest update on share analysis at Telegram Channel ==> https://t.me/davidshare
Disclaimer:
This writing is based on my own assumptions and estimations. It is strictly for sharing purpose, not a buy or sell call of the company.
Appendix 1 (other Appendices are Not for public)
Chart | Stock Name | Last | Change | Volume |
---|
Created by davidtslim | Oct 03, 2020
Created by davidtslim | Aug 28, 2020
Created by davidtslim | Aug 06, 2020
Created by davidtslim | Aug 04, 2020
Created by davidtslim | May 15, 2019
Appreciate you great effort and thank you for sharing.
Btw, have you stopped analysing HengYuan ?
2018-07-27 18:21
Why has Airasia dropped for continuos 3 quarters after this article come out?
2019-08-29 12:28
RenegadeMaster
Great analysis. Many thanks for your efforts and for sharing.
2018-07-27 12:29