Bharti Airtel Ltd.

SECTOR: Telecommunication - Service Provider

489.05
₹ 27.45 (5.95%)
Today's High: 492 Today's Low : 468
52 Week High: 568.60 52 Week Low : 305.69
 FinStar
FinStar Indicates the overall health and quality of a stock based on Finology Research.
Ownership Very Stable
High level of belief in company’s potential exhibited by insiders.
ValuationAttractive
The stock is considerably attractive based on intrinsic value.
EfficiencyPoor
The company seems highly inefficient in case of asset management.
FinancialsWeak
Watch out! The company might not be able to sustain any adverse condition.

 Company Essentials

Market Cap

266804.032446275 Cr.

P/E

0

P/B

2.47

Face Value

₹5

Div. Yield

0.75%

Book Value (TTM)

198.0327

Enterprise Value

350374.332446275 Cr.

CASH

219.6 Cr.

DEBT

83789.9 Cr.

Promoter Holding

62.7%

EPS (TTM)

-53.6002

Sales Growth

-7.56 %

ROE

-1.82 %

ROCE

1.51 %

Profit Growth

-2409.34 %

No. of Shares

545.5557355 Cr.

Add your own Ratio
* Total debt includes long term borrowing, short term borrowing plus current maturities of long-term borrowing
* Ratios are based on latest Audited Financial Result.

 Price Chart 1w1m3m6m1Yr3Yr5Yr

* Prices are based on daily market changes.

 Valuation Chart 1w1m3m6m1Yr3Yr5Yr

* The chart is based on the standalone earnings of the company.

 Peer Comparison

View Full Peer Comparison
* The Peers list includes companies operating in the same industry and having comparable market cap.

 Sales Growth

1 Year-7.56%
3 Year-6.3%
5 Year-0.12%

 Profit Growth

1 Year-2409.34%
3 Year-161.72%
5 Year-177.36%

 ROE

1 Year-1.82%
3 Year-3.7%
5 Year3.08%

 ROCE

1 Year1.51%
3 Year0.88%
5 Year6.54%

 Debt Equity

0.85

 Price to Cash Flow

26.06

  Interest Cover Ratio

0.34

 CFO/PAT

39.5145486921635

 Share Holding Pattern

 Promoter Pledging %

Date Promoter % Pledge %
Dec 2019 62.7 0
Sep 2019 62.7 0
Jun 2019 62.71 0
Mar 2019 67.14 0
Dec 2018 67.14 0
* Figures given above are % of equity capital

 Strengths

  • The Company has been maintaining an effective average operating margins of 33.01% in the last 5 years.
  • The company has an efficient Cash Conversion Cycle of -108.42 days.
  • The company has a high promoter holding of 62.7%.

 Limitations

  • The company has shown a poor profit growth of -161.717139283195% for the Past 3 years.
  • The company has shown a poor revenue growth of -6.29903106098141% for the Past 3 years.
  • Company has a poor ROE of -3.7% over the past 3 years.
  • Company has a poor ROCE of 0.88% over the past 3 years
  • Company has low Interest coverage ratio of 0.34.

 Quarterly Result (All Figures are in Crores.)

Particulars Dec 2018 Mar 2019 Jun 2019 Sep 2019 Dec 2019
Net Sales 12313.7 12522 12833.1 13012.9 13479.7
Other Income 1566.6 326.5 641.6 411.6 454.1
Total Expenditure 9730.8 9269.1 8415.3 8420.8 8299.4
Operating Profit 4149.5 3579.4 5059.4 5003.7 5634.4
Interest 1813.4 2157.4 2376.6 2400.8 2925.8
Depreciation 3825 3880 5017 4983.2 5226.4
Exceptional Items 1151.1 1946.9 -212.7 -30815 -2722
Profit Before Tax -337.8 -511.1 -2546.9 -33195.3 -5239.8
Tax -562.4 -474.5 -1243.2 -8681.8 -1851.7
Profit After Tax 224.6 -36.6 -1303.7 -24513.5 -3388.1

 Profit & Loss (All Figures are in Crores except Adjusted EPS in Rs.)

Particulars Mar 2015 Mar 2016 Mar 2017 Mar 2018 Mar 2019
Net Sales 55496.4 60300.3 62276.3 53663 49608
Other Income 5193 1743.7 2526.4 1077.3 4096.9
Total Expenditure 36065.3 37989.1 38583.4 35858.1 38782.2
Operating Profit 24624.1 24054.9 26219.3 18882.2 14922.7
Interest 1409.1 3545.3 5254.6 5910.7 7843.7
Depreciation 7559.7 9575.3 12203.4 13048.6 15087.6
Exceptional Items 0 -679.9 -17270.8 -604.1 2804.9
Profit Before Tax 15655.3 10254.4 -8509.5 -681.2 -5203.7
Tax 2454.8 2474.1 1416.1 -760.4 -3374.7
Net Profit 13200.5 7780.3 -9925.6 79.2 -1829
Adjusted EPS 30 18 -23 0 -4

 Balance Sheet (All Figures are in Crores.)

Particulars Mar 2015 Mar 2016 Mar 2017 Mar 2018 Mar 2019
Equity and Liabilities
Share Capital 1998.7 1998.7 1998.7 1998.7 1998.7
Total Reserves 76274.2 109730.4 99208.6 100862.2 96360.6
Borrowings 19626.7 41457 50342.1 54468.1 58649.4
Other N/C liabilities 5472.6 1688.1 3391 2543.5 62.5
Current liabilities 37027.5 27912.7 35816.4 43640.4 60463.1
Total Liabilities 140399.7 182786.9 190756.8 203512.9 217534.3
Assets
Net Block 53444.4 91925.5 111522.8 122609.4 131734
Capital WIP 2656.1 2858.8 1181.8 2738.7 5297
Investments 38395.8 69896.5 45959 48128.2 36807.2
Loans & Advances 8848.7 5548.2 6747.4 11154.6 20887.3
Other N/C Assets 8322.3 1071 8662.8 3051.8 2288.2
Current Assets 28732.4 11486.9 16683 15830.2 20520.6
Total Assets 140399.7 182786.9 190756.8 203512.9 217534.3
* Other Non-current Liabilities include Net deferred Liabilities

 Cash Flows (All Figures are in Crores.)

Particulars Mar 2015 Mar 2016 Mar 2017 Mar 2018 Mar 2019
Profit Before Tax 15655.3 10254.2 -8509.5 -681.2 -5203.7
Adjustment 3958.5 11321.6 31200.5 19555.2 18559.5
Working Capital Changes 1179.6 53.8 -81.6 -2679.3 -4067.2
Tax Paid -2853.6 -2179.7 -1443.9 -240.4 948.2
Operating Cash Flow 17939.8 19449.9 21165.5 15954.3 10236.8
Investing Cash Flow -12801.2 -21989.3 -24283.2 -17210.8 -19928.8
Financing Cash Flow -5195.7 1898.4 3455.7 1636.9 9401.6
Net Cash Flow -57.1 -641 338 380.4 -290.4

 Corporate Actions

 Ratings & Research Reports

 Company Presentations

 Bharti Airtel Stock Price Analysis and Quick Research Report

Is Bharti Airtel an attractive stock to invest in?

 

Stock investing requires careful analysis of financial data to find out the company's true net worth. This is generally done by examining the company's profit and loss account, balance sheet and cash flow statement. This can be time-consuming and cumbersome. An easier way to find out about a company's performance is to look at its financial ratios, which can help to make sense of the overwhelming amount of information that can be found in a company's financial statements.

Here are the few indispensable tools that should be a part of every investor’s research process.

  • PE ratio: - Price to Earnings' ratio, which indicates for every rupee of earnings how much an investor is willing to pay for a share. A general rule of thumb is that shares trading at a low P/E are undervalued (it depends on other factors too). Bharti Airtel has a PE ratio of 0 which is low and comparatively undervalued .

  • Return on Assets (ROA): - Return on Assets measures how effectively a company can earn a return on its investment in assets. In other words, ROA shows how efficiently a company can convert the money used to purchase assets into net income or profits. Bharti Airtel has ROA of -0.868786207342075 % which is a bad sign for future performance. (higher values are always desirable)

  • Current ratio: - The current ratio measures a company's ability to pay its short-term liabilities with its short-term assets. A higher current ratio is desirable so that the company could be stable to unexpected bumps in business and economy. Bharti Airtel has a Current ratio of 0.339390471213021 .

  • Return on equity: - ROE measures the ability of a firm to generate profits from its shareholders investments in the company. In other words, the return on equity ratio shows how much profit each rupee of common stockholders’ equity generates. Bharti Airtel has a ROE of -1.8191076923689 % .(higher is better)

  • Debt to equity ratio: - It is a good metric to check out the capital structure along with its performance. Bharti Airtel has a D/E ratio of 0.852444256346032 which means that the company has low proportion of debt in its capital.

  • Inventory turnover ratio: - Inventory Turnover ratio is an activity ratio and is a tool to evaluate the liquidity of a company's inventory. It measures how many times a company has sold and replaced its inventory during a certain period of time. Bharti Airtel has an Inventory turnover ratio of 13591.2328767123 which shows that the management is efficient in relation to its Inventory and working capital management.

  • Sales growth: - Bharti Airtel has reported revenue growth of -7.56 % which is poor in relation to its growth and performance.

  • Operating Margin: - This will tell you about the operational efficiency of the company. The operating margin of Bharti Airtel for the current financial year is 21.8226898887276 %.

  • Dividend Yield: - It tells us how much dividend we will receive in relation to the price of the stock. The current year dividend for Bharti Airtel is Rs 2.5 and the yield is 0.750976269149895 %.

X