Bharti Airtel Ltd

Bharti Airtel Ltd

₹ 1,453 -0.82%
23 Jul 11:53 a.m.
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

Diversified Products & Services
The Company’s diversified service range includes mobile, voice and data solutions, using 2G, 3G and 4G & 5G technologies. It provides telecom services under wireless and fixed line technology, national and international long-distance connectivity, broadband services, Digital TV and complete integrated telecom solutions to its enterprise customers. Airtel Money (known as ‘Airtel Payments Bank’ in India) extends the Company’s product portfolio to further its financial inclusion agenda and offers convenience of payments and money transfers on mobile phones over secure and stable platforms in India, and across all 14 countries in Africa. [1]

  • Market Cap 8,68,656 Cr.
  • Current Price 1,453
  • High / Low 1,539 / 847
  • Stock P/E 72.9
  • Book Value 145
  • Dividend Yield 0.27 %
  • ROCE 13.1 %
  • ROE 14.9 %
  • Face Value 5.00

Pros

  • Company has been maintaining a healthy dividend payout of 42.8%

Cons

  • Stock is trading at 10.1 times its book value
  • Company has low interest coverage ratio.
  • Company has a low return on equity of 11.3% over last 3 years.

* 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

Mar 2021 Jun 2021 Sep 2021 Dec 2021 Mar 2022 Jun 2022 Sep 2022 Dec 2022 Mar 2023 Jun 2023 Sep 2023 Dec 2023 Mar 2024
25,747 26,854 28,326 29,867 31,500 32,805 34,527 35,804 36,009 37,440 37,044 37,900 37,599
13,415 13,873 14,516 15,164 15,460 16,275 16,933 17,720 17,312 17,842 17,530 18,085 18,234
Operating Profit 12,332 12,980 13,810 14,703 16,040 16,529 17,594 18,085 18,697 19,598 19,514 19,815 19,365
OPM % 48% 48% 49% 49% 51% 50% 51% 51% 52% 52% 53% 52% 52%
1,052 735 1,430 853 1,638 355 559 -412 886 -2,478 -654 1,013 -1,308
Interest 3,861 4,226 3,964 4,367 4,059 4,511 4,940 4,686 5,163 5,614 5,186 6,645 5,203
Depreciation 7,502 7,714 8,247 8,547 8,583 8,781 8,947 9,298 9,406 9,654 9,734 10,074 10,075
Profit before tax 2,021 1,776 3,029 2,642 5,037 3,592 4,265 3,689 5,014 1,853 3,940 4,108 2,778
Tax % 25% 47% 34% 38% 26% 31% 30% 29% 16% 18% 47% 30% 26%
1,511 941 1,998 1,651 3,715 2,469 2,979 2,614 4,226 1,520 2,093 2,876 2,068
EPS in Rs 1.29 0.48 1.93 1.41 3.41 2.73 3.86 2.85 5.39 2.89 2.39 4.34 3.66
Raw PDF

Profit & Loss

Consolidated Figures in Rs. Crores / View Standalone

Mar 2013 Mar 2014 Mar 2015 Mar 2016 Mar 2017 Mar 2018 Mar 2019 Mar 2020 Mar 2021 Mar 2022 Mar 2023 Mar 2024
76,947 85,864 96,101 96,532 95,468 82,639 80,780 87,539 100,616 116,547 139,145 149,982
53,987 59,352 62,499 62,548 60,138 52,560 55,016 50,930 55,337 59,013 67,871 71,691
Operating Profit 22,960 26,512 33,602 33,984 35,330 30,079 25,764 36,610 45,279 57,534 71,274 78,292
OPM % 30% 31% 35% 35% 37% 36% 32% 42% 45% 49% 51% 52%
1,159 2,881 1,243 4,858 1,713 1,756 4,474 -37,775 -4,215 4,656 1,019 -3,428
Interest 4,519 5,879 4,446 8,546 9,547 9,326 10,622 13,992 15,091 16,616 19,300 22,648
Depreciation 14,815 15,650 19,858 17,450 19,773 19,243 21,348 27,690 29,404 33,091 36,432 39,538
Profit before tax 4,785 7,864 10,540 12,846 7,723 3,267 -1,732 -42,846 -3,432 12,483 16,561 12,679
Tax % 53% 62% 52% 46% 45% 33% -197% -28% 260% 33% 26% 32%
2,267 3,019 5,048 6,893 4,241 2,184 1,688 -30,664 -12,364 8,305 12,287 8,558
EPS in Rs 4.32 5.04 8.41 11.05 6.91 2.00 0.74 -55.06 -25.63 7.23 14.97 13.20
Dividend Payout % 17% 26% 33% 9% 11% 194% 244% -3% 0% 39% 27% 62%
Compounded Sales Growth
10 Years: 6%
5 Years: 13%
3 Years: 14%
TTM: 8%
Compounded Profit Growth
10 Years: 16%
5 Years: 122%
3 Years: -2%
TTM: 37%
Stock Price CAGR
10 Years: 16%
5 Years: 35%
3 Years: 40%
1 Year: 65%
Return on Equity
10 Years: 9%
5 Years: 12%
3 Years: 11%
Last Year: 15%

Balance Sheet

Consolidated Figures in Rs. Crores / View Standalone

Mar 2013 Mar 2014 Mar 2015 Mar 2016 Mar 2017 Mar 2018 Mar 2019 Mar 2020 Mar 2021 Mar 2022 Mar 2023 Mar 2024
Equity Capital 1,899 1,999 1,999 1,999 1,999 1,999 1,999 2,728 2,746 2,795 2,837 2,877
Reserves 48,423 57,757 37,778 64,771 65,458 67,536 69,424 74,417 56,207 63,759 74,726 79,142
66,736 75,896 83,415 100,646 107,288 111,334 125,428 148,228 162,785 169,678 226,020 215,592
40,912 45,840 58,747 57,056 57,578 68,653 77,176 133,718 122,679 124,975 140,974 146,920
Total Liabilities 157,970 181,492 181,939 224,472 232,322 249,521 274,026 359,091 344,417 361,207 444,557 444,531
125,674 140,614 124,279 172,293 178,235 187,200 200,832 229,256 223,480 244,083 277,394 311,300
CWIP 2,992 0 17,415 5,702 10,838 9,751 9,634 4,282 5,726 5,955 49,425 8,908
Investments 7,710 15,531 10,752 11,977 14,339 16,159 15,711 25,476 27,550 29,349 32,954 31,602
21,594 25,347 29,494 34,500 28,910 36,411 47,850 100,077 87,661 81,820 84,784 92,722
Total Assets 157,970 181,492 181,939 224,472 232,322 249,521 274,026 359,091 344,417 361,207 444,557 444,531

Cash Flows

Consolidated Figures in Rs. Crores / View Standalone

Mar 2013 Mar 2014 Mar 2015 Mar 2016 Mar 2017 Mar 2018 Mar 2019 Mar 2020 Mar 2021 Mar 2022 Mar 2023 Mar 2024
22,608 26,233 28,059 27,942 28,280 29,854 20,070 18,129 48,205 55,017 65,325 78,898
-18,676 -25,181 -22,301 -14,091 -30,680 -27,940 -28,286 -29,598 -27,286 -41,478 -39,232 -50,204
-4,566 2,774 -9,672 -11,946 -351 1,920 9,464 19,144 -24,910 -15,203 -24,470 -27,778
Net Cash Flow -634 3,826 -3,914 1,905 -2,752 3,835 1,248 7,675 -3,991 -1,664 1,623 916

Ratios

Consolidated Figures in Rs. Crores / View Standalone

Mar 2013 Mar 2014 Mar 2015 Mar 2016 Mar 2017 Mar 2018 Mar 2019 Mar 2020 Mar 2021 Mar 2022 Mar 2023 Mar 2024
Debtor Days 32 27 20 21 18 26 19 19 13 13 10 12
Inventory Days
Days Payable
Cash Conversion Cycle 32 27 20 21 18 26 19 19 13 13 10 12
Working Capital Days -98 -105 -172 -139 -150 -200 -189 -257 -172 -154 -155 -161
ROCE % 7% 10% 11% 13% 10% 7% 3% 5% 7% 11% 12% 13%

Shareholding Pattern

Numbers in percentages

1 Recently
Sep 2021Dec 2021Mar 2022Jun 2022Sep 2022Dec 2022Mar 2023Jun 2023Sep 2023Dec 2023Mar 2024Jun 2024
55.86% 55.93% 55.93% 55.93% 55.14% 55.12% 55.02% 54.97% 54.75% 54.57% 53.48% 53.17%
19.87% 19.37% 19.36% 18.54% 21.87% 21.70% 20.97% 21.48% 21.87% 22.69% 24.35% 24.62%
19.15% 19.48% 19.50% 20.22% 18.76% 19.02% 19.78% 19.55% 19.69% 19.51% 19.20% 19.13%
0.00% 0.00% 0.00% 0.00% 0.12% 0.12% 0.12% 0.12% 0.12% 0.12% 0.12% 0.12%
5.08% 5.16% 5.16% 5.26% 4.06% 4.00% 4.05% 3.82% 3.53% 3.07% 2.80% 2.89%
0.05% 0.05% 0.05% 0.05% 0.04% 0.05% 0.05% 0.05% 0.04% 0.06% 0.05% 0.06%
No. of Shareholders 6,81,9757,50,2417,67,5787,86,1697,79,9967,54,9617,58,7157,09,9526,85,5296,77,6906,94,2977,62,266

* The classifications might have changed from Sep'2022 onwards. The new XBRL format added more details from Sep'22 onwards.

Classifications such as banks and foreign portfolio investors were not available earlier. The sudden changes in FII or DII can be because of these changes.

Click on the line-items to see the names of individual entities.

Documents

Concalls