Welcome to Sana Securities! Login | Subscribe Now.

Bharti Airtel Equity Research

HomeCompanyBharti Airtel Equity Research

Date of Research – 13 January 2016

Price – Rs. 306.35

About the Company

Founded in 1995, Bharti Airtel Limited (“Bharti Airtel” or the “Company” is an integrated telecommunications company with operations in 20 countries across Asia and Africa. Headquartered in New Delhi, India, the Company ranks amongst the top 5 mobile service providers globally in terms of subscribers.

In India, the Company’s product offerings include 2G, 3G and 4G services, fixed line, high speed broadband through DTH, enterprise services including national & international long distance services to carriers. In the rest of the geographies, it offers 2G, 3G mobile services. All these services are rendered under a unified brand “airtel”. The Company also manages passive infrastructure pertaining to telecom operations through its subsidiary and joint venture entity.

Bharti Airtel had over 262 million customers across its operations at the end of March 2014. The operations of Bharti Airtel in India and South Asia are divided into two distinct customer business units with clear focus on B2C (Business to Customer) and B2B (Business to Business) segments. B2C services includes mobile services; telemedia services; and digital TV services. B2B services includes airtel business; and passive infrastructure services.

Key Financial Figures

Consolidated (Rs. Cr)
Particulars FY 2013 FY 2014 FY 2015 FY 2016  FY 2017
Total Income from Operations 80,359.00 85,863.50 92,135.10 96,619.20  95,468.30 
Expenses 55,488.60 58,086.50 60,746.80 62,525.90   57,376.30  
Earnings Before Other Income, Interest, Tax and Depreciation (Operating Profit) 24,870.40 27,777.00 31,388.30 34,093.30   38,092.00  
Depreciation 15,496.40 15,649.60 15,531.10 17,449.80   19,773.00
Finance Costs 4,384.40 4,838.00 5,013.30 6,023.50   9,546.60  
Other income –  120.60  
Exceptional items (53.80) 853.20 (1,450.50)  1,169.70
PBT 4,989.60 7,343.20 9,990.70 12,070.50   7,723.30  
Tax 2,715.10 4,844.90 5,404.70 5,936.80   3,481.90  
PAT (before Minority Interest and share of Associates) 2,274.50 2,498.30 4,586.00 6,133.70   4,241.40  
Profit/ (loss) attributable to Minority Interest (8.80) 246.70 124.80 649.50   – 
Share of profit / (loss) of Associates 7.60 (521.10) (722.30) –  – 
Consolidated Profit / (Loss) for the year 2,275.70 2,772.70 5,183.50 5,484.20   4,241.40

Profitability Analysis

Consolidated (%)
Particulars FY 2013 FY 2014 FY 2015 FY 2016  FY 2017
Operating Profit Margin Ratio 30.95 32.35 34.07 35.29   39.90
Net Profit Margin Ratio 2.83 2.91 4.98 6.35   4.44

Operating profit margin is a measurement of the proportion of a company’s revenue that is left over after paying for production costs such as raw materials, salaries and administrative costs. Net profit margin is arrived at by deducting non operating expenses such as depreciation, finance costs and taxes out of operating profit and shows what is left for the shareholders as a percentage of net sales. Together these ratios help in understanding the cost and profit structure of the firm and analysing business inefficiencies.

Key Balance Sheet Figures

Sources of Funds / Liabilities (Rs. Cr)
Particulars FY 2012 FY 2013 FY 2014 FY 2015 FY 2016
Share Capital 1,898.80 1,898.80 1,998.70 1,998.70 1,998.70
Treasury shares (28.20) (34.20) (11.40)
Share premium 5,649.90 12,345.60 12,345.60
Foreign currency translation reserve (602.60) (1,677.70)
Other components of equity 4,125.20 3,406.90 321.00
Reserves & Surplus 39,568.20 48,422.90 43,716.70 47,302.50 40,298.90
Deferred revenue 289.20 1,401.00 1,791.70
Net worth (shareholders funds) 50,611.30 50,321.70 61,157.00 63,748.10 42,297.60
Minority Interest 2,769.50 4,088.60 4,210.20 4,852.50 7,446.50
Long term borrowings 49,715.40 72,960.80 54,991.90 45,228.30 89,774.50
Derivative financial liabilities 40.10 431.30 16.40
Current liabilities 48,887.30 39,952.10 56,805.00 62,899.00 59,428.60
Other long term liabilities and provisions 3,586.70 3,896.80 17,526.50 6,393.80
Deferred Tax Liabilities 1,162.10 1,685.00 1,511.00 4,602.80
Total Liabilities 1,57,061.60 1,27,371.10 1,83,177.20 1,95,781.80 2,09,943.80

 

Application of Funds / Assets (Rs. Cr)
Particulars FY 2012 FY 2013 FY 2014 FY 2015 FY 2016
Fixed Assets 1,33,582.10 1,36,923.80 1,46,284.70 1,50,144.00 1,67,819.90
Investments in associates 2.40 6,769.30 3,634.10 4,625.70 2,432.50
Derivative financial assets 275.60 730.30
Current assets 14,808.40 8,483.40 22,385.70 22,201.00 20,806.50
Long term advances and other noncurrent assets 3,265.40 15,146.70 4,610.00 12,130.60 18,120.60
Deferred Tax Assets 5,127.70 6,262.70 5,950.20 764.30
Total assets 1,57,061.60 1,27,371.10 1,83,177.20 1,95,781.80 2,09,943.80

Efficiency Analysis

  (%)
Particulars FY 2012 FY 2013 FY 2014 FY 2015 FY 2016
ROCE 23.00 22.35 23.08 27.57 24.44
ROE / RONW 8.42 8.05 4.53 8.13 14.50

Return on Capital Employed (ROCE) measures a company’s profitability from its overall operations by calculating the return generated on the total capital invested in the business (i.e. equity + debt). Return on Equity (ROE) or Return on Net Worth (RONW) measures the amount of profit which the company generates on money invested by the equity shareholders. In short, ROE draws attention to the return generated by the shareholders on their investment in the business. Together these ratios can be used in comparing the profitability of the company with other companies in the same industry.

Valuation Analysis

Consolidated
Particulars FY 2013 FY 2014 FY 2015 FY 2016 FY 2017
Total Income from Operations (Rs. Cr.) 80,359.00 85,863.50 92,135.10 96,619.20  95,468.30 
Growth (%) 12.38 % 6.85 % 7.30 % 4.87 %  (1.19 %) 
PAT (Rs. Cr.) 2,274.50 2,498.30 4,586.00 6,133.70   4,241.40  
Growth (%) (46.68 %) 9.84 % 83.56 % 33.75 %  (30.85 %) 
Earnings Per Share – Basic (Rs. ) 6.00 7.02 12.97 13.72  9.51 
Earning Per Share – Diluted (Rs. ) 6.00 7.01 12.97 13.72  9.51 
Price to Earnings 48.63 46.74 30.34 28.39  38.72 

Dividend History

The Company has maintained an average dividend yield of 0.49 % over the last 5 financial years.

Liquidity and Credit Analysis

Current Ratio

Higher current ratio implies healthier short term liquidity comfort level. A current ratio below 1 indicates that the company may not be able to meet its obligations in the short run. However, it is not always a matter of worry if this ratio temporarily falls below 1 as many times companies squeeze out short term cash sources to achieve a capital intensive plan with a longer term outlook.

Bharti Airtel’s average current ratio over the last 5 financial years has been 0.31 times which indicates that the Company has been facing liquidity problems to meet its short term obligations.

Long term Debt to Equity Ratio

Companies operating with high debt to equity on their balance sheets are vulnerable to economic cycles. In times of slowdown in economy, companies with high levels of debt find it increasingly difficult to service the interest on their borrowings as profit margins decline. We believe that long term debt to equity ratio higher than 0.6 – 0.8 could affect the business of a company and its results of operations.

Bharti Airtel’s average long term debt to equity ratio over the last 5 financial years has been 0.96 times which indicates that the Company is comfortably placed to meet its obligations.

Interest Coverage ratio

Interest coverage ratio indicates the comfort with which the company may be able to service the interest expense (i.e. finance charges) on its outstanding debt. Higher interest coverage ratio indicates that the company can easily meet the interest expense pertaining to its debt obligations. In our view, interest coverage ratio of below 1.5 should raise doubts about the company’s ability to meet the expenses on its borrowings. Interest coverage ratio below 1 indicates that the company is just not generating enough to service its debt obligations.

Bharti Airtel’s average interest coverage ratio over the last 5 financial years has been 6.61 times which indicates that the company has been generating enough for the shareholders after servicing its debt obligations.

Ownership pattern

In its latest stock exchange filing dated 31 March 2017, Bharti Airtel reported a promoter holding of 67.14 %. Large promoter holding indicates conviction and sincerity of the promoters. We believe that a greater than 35 % promoter holding offers safety to the retail investors.

At the same time, institutional holding in the Company stood at 25.60 % (FII+DII). Large institutional holding indicates the confidence of seasoned investors. At the same time, it can also lead to high volatility in the stock price as institutions buy and sell larger stakes than retail participants.

About the Author

Rajat Sharma pictureRajat Sharma is a well known stock market analyst and commentator. He has covered Indian markets for over a decade and is regarded for consistently identifying early stage investment opportunities. Attorney by qualification, Rajat has done extensive work for improving corporate governance and disclosure standards.

 

Leave a Comment