Bharti Airtel Ltd

Bharti Airtel Ltd

₹ 1,278 -2.04%
03 May 2:51 p.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 7,59,869 Cr.
  • Current Price 1,278
  • High / Low 1,364 / 780
  • Stock P/E 66.6
  • Book Value 138
  • Dividend Yield 0.31 %
  • ROCE 12.3 %
  • ROE 12.0 %
  • Face Value 5.00

Pros

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

Cons

  • Stock is trading at 9.30 times its book value
  • Company has low interest coverage ratio.
  • Promoter holding has decreased over last quarter: -1.08%
  • Company has a low return on equity of 12.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

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

Profit & Loss

Consolidated Figures in Rs. Crores / View Standalone

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

Balance Sheet

Consolidated Figures in Rs. Crores / View Standalone

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

Cash Flows

Consolidated Figures in Rs. Crores / View Standalone

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

Ratios

Consolidated Figures in Rs. Crores / View Standalone

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

Shareholding Pattern

Numbers in percentages

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

* 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