Bharti Airtel Ltd

₹ 771 -1.63%
23 Sep - close price
About

Bharti Airtel Ltd is one of the world’s leading providers of telecommunication services with presence in 18 countries representing India, Sri
Lanka, 14 countries in Africa. [1]

Key Points

Revenue Breakup[1]
Mobile (India) – 49.8%
Africa – 25.8%
Airtel business – 12.9%
Homes – 2.1%
Digital Services – 2.7%
Towers – 6.4%

  • Market Cap 443,921 Cr.
  • Current Price 771
  • High / Low 797 / 629
  • Stock P/E 90.0
  • Book Value 113
  • Dividend Yield 0.39 %
  • ROCE 12.0 %
  • ROE 5.86 %
  • Face Value 5.00

Pros

Cons

  • Stock is trading at 6.82 times its book value
  • Company has low interest coverage ratio.
  • The company has delivered a poor sales growth of 4.07% over past five years.
  • Company has a low return on equity of 2.86% for last 3 years.
  • Promoter holding has decreased over last 3 years: -6.80%

* The pros and cons are machine generated. Pros / cons are based on a checklist to highlight important points. Please exercise caution and do your own analysis.

Loading peers table ...

Quarterly Results

Consolidated Figures in Rs. Crores / View Standalone

Jun 2019 Sep 2019 Dec 2019 Mar 2020 Jun 2020 Sep 2020 Dec 2020 Mar 2021 Jun 2021 Sep 2021 Dec 2021 Mar 2022 Jun 2022
20,738 21,131 21,344 23,019 23,939 25,060 26,518 25,747 26,854 28,326 29,867 31,500 32,805
12,504 12,294 12,829 13,526 13,531 14,283 14,685 13,415 13,873 14,516 15,164 15,460 16,275
Operating Profit 8,234 8,837 8,515 9,493 10,408 10,777 11,832 12,332 12,980 13,810 14,703 16,040 16,529
OPM % 40% 42% 40% 41% 43% 43% 45% 48% 48% 49% 49% 51% 50%
-1,082 -30,049 -36 -5,614 -11,099 680 5,299 1,052 735 1,430 853 1,638 355
Interest 3,393 3,187 3,289 4,147 3,456 3,791 3,972 3,861 4,226 3,964 4,367 4,059 4,511
Depreciation 6,759 6,935 6,818 6,862 7,227 7,286 7,503 7,502 7,714 8,247 8,547 8,583 8,781
Profit before tax -2,999 -31,334 -1,629 -7,129 -11,374 380 5,657 2,021 1,776 3,029 2,642 5,037 3,592
Tax % 20% 27% 71% 30% -34% 109% 76% 25% 47% 34% 38% 26% 31%
Net Profit -2,392 -22,830 -465 -4,977 -15,191 -34 1,350 1,511 941 1,998 1,651 3,715 2,469
EPS in Rs -5.21 -41.91 -1.88 -8.96 -27.26 -1.31 1.46 1.29 0.48 1.93 1.41 3.41 2.73
Raw PDF

Profit & Loss

Consolidated Figures in Rs. Crores / View Standalone

Mar 2011 Mar 2012 Mar 2013 Mar 2014 Mar 2015 Mar 2016 Mar 2017 Mar 2018 Mar 2019 Mar 2020 Mar 2021 Mar 2022 TTM
59,602 71,506 76,947 85,864 96,101 96,532 95,468 82,639 80,780 84,676 100,616 116,547 122,498
39,438 47,965 53,987 59,352 62,499 62,548 60,138 52,560 55,016 51,086 55,337 59,013 61,415
Operating Profit 20,164 23,541 22,960 26,512 33,602 33,984 35,330 30,079 25,764 33,591 45,279 57,534 61,083
OPM % 34% 33% 30% 31% 35% 35% 37% 36% 32% 40% 45% 49% 50%
255 428 1,159 2,881 1,243 4,858 1,713 1,756 4,474 -35,600 -4,215 4,656 4,276
Interest 2,535 4,083 4,519 5,879 4,446 8,546 9,547 9,326 10,622 14,073 15,091 16,616 16,901
Depreciation 10,207 13,368 14,815 15,650 19,858 17,450 19,773 19,243 21,348 27,094 29,404 33,091 34,158
Profit before tax 7,678 6,518 4,785 7,864 10,540 12,846 7,723 3,267 -1,732 -43,177 -3,432 12,483 14,299
Tax % 23% 35% 53% 62% 52% 46% 45% 33% 197% 29% -260% 33%
Net Profit 5,899 4,258 2,267 3,019 5,048 6,893 4,241 2,184 1,688 -30,664 -12,364 8,305 9,833
EPS in Rs 11.01 8.15 4.32 5.04 8.41 11.05 6.91 2.00 0.74 -55.06 -25.63 7.23 9.48
Dividend Payout % 7% 9% 17% 26% 33% 9% 11% 194% 244% -3% 0% 39%
Compounded Sales Growth
10 Years: 5%
5 Years: 4%
3 Years: 13%
TTM: 18%
Compounded Profit Growth
10 Years: -1%
5 Years: -3%
3 Years: 156%
TTM: 171%
Stock Price CAGR
10 Years: 12%
5 Years: 17%
3 Years: 31%
1 Year: 6%
Return on Equity
10 Years: 4%
5 Years: 2%
3 Years: 3%
Last Year: 6%

Balance Sheet

Consolidated Figures in Rs. Crores / View Standalone

Mar 2011 Mar 2012 Mar 2013 Mar 2014 Mar 2015 Mar 2016 Mar 2017 Mar 2018 Mar 2019 Mar 2020 Mar 2021 Mar 2022
1,899 1,899 1,899 1,999 1,999 1,999 1,999 1,999 1,999 2,728 2,746 2,795
Reserves 46,868 48,712 48,423 57,757 37,778 64,823 65,494 67,600 69,424 74,417 56,207 63,759
58,749 69,023 66,736 75,896 83,415 100,646 107,288 111,334 125,428 148,228 162,785 169,678
37,742 36,265 40,912 45,840 58,747 57,004 57,542 68,589 77,176 133,718 122,679 124,975
Total Liabilities 145,258 155,900 157,970 181,492 181,939 224,472 232,322 249,521 274,026 359,091 344,417 361,207
124,051 129,168 125,674 140,614 124,279 172,293 178,235 187,200 200,832 229,256 223,480 244,083
CWIP 4,823 4,414 2,992 0 17,415 5,702 10,838 9,751 9,634 4,282 5,726 5,955
Investments 622 1,836 7,710 15,531 10,752 11,977 14,339 16,159 15,711 25,476 27,550 29,349
15,761 20,482 21,594 25,347 29,494 34,500 28,910 36,411 47,850 100,077 87,661 81,820
Total Assets 145,258 155,900 157,970 181,492 181,939 224,472 232,322 249,521 274,026 359,091 344,417 361,207

Cash Flows

Consolidated Figures in Rs. Crores / View Standalone

Mar 2011 Mar 2012 Mar 2013 Mar 2014 Mar 2015 Mar 2016 Mar 2017 Mar 2018 Mar 2019 Mar 2020 Mar 2021 Mar 2022
18,851 22,593 22,608 26,233 28,059 27,942 28,280 29,854 20,070 18,129 48,205 55,017
-60,462 -18,380 -18,676 -25,181 -22,301 -14,091 -30,680 -27,940 -28,286 -29,598 -27,286 -41,478
39,715 -4,011 -4,566 2,774 -9,672 -11,946 -351 1,920 9,464 19,144 -24,910 -15,203
Net Cash Flow -1,895 203 -634 3,826 -3,914 1,905 -2,752 3,835 1,248 7,675 -3,991 -1,664

Ratios

Consolidated Figures in Rs. Crores / View Standalone

Mar 2011 Mar 2012 Mar 2013 Mar 2014 Mar 2015 Mar 2016 Mar 2017 Mar 2018 Mar 2019 Mar 2020 Mar 2021 Mar 2022
Debtor Days 34 33 32 27 20 21 18 26 19 20 13 13
Inventory Days
Days Payable
Cash Conversion Cycle 34 33 32 27 20 21 18 26 19 20 13 13
Working Capital Days -134 -95 -98 -105 -172 -139 -150 -200 -189 -265 -172 -154
ROCE % 13% 9% 8% 11% 11% 13% 11% 8% 3% 5% 12% 12%

Shareholding Pattern

Numbers in percentages

19 recently
Sep 2019 Dec 2019 Mar 2020 Jun 2020 Sep 2020 Dec 2020 Mar 2021 Jun 2021 Sep 2021 Dec 2021 Mar 2022 Jun 2022
62.70 62.70 58.98 56.23 56.23 56.23 55.86 55.86 55.86 55.93 55.93 55.93
22.33 16.40 20.29 20.15 17.57 17.75 18.57 18.12 19.87 19.37 19.36 18.54
13.20 14.14 15.83 18.37 21.72 21.78 20.35 20.64 19.15 19.48 19.50 20.22
1.74 6.71 4.87 5.21 4.45 4.18 5.16 5.32 5.08 5.16 5.16 5.26
0.03 0.05 0.04 0.04 0.03 0.06 0.06 0.06 0.05 0.05 0.05 0.05

Documents

Concalls