Bharti Airtel Ltd

Bharti Airtel Ltd

₹ 1,682 4.42%
13 Dec - 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

Segments & Presence[1]
Mobile, Broadband, DTH and Bank.
The company has operations in India, Africa, Bangladesh and Sri Lanka.

  • Market Cap 10,07,452 Cr.
  • Current Price 1,682
  • High / Low 1,779 / 960
  • Stock P/E 71.0
  • Book Value 153
  • Dividend Yield 0.48 %
  • 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 11.0 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

Sep 2021 Dec 2021 Mar 2022 Jun 2022 Sep 2022 Dec 2022 Mar 2023 Jun 2023 Sep 2023 Dec 2023 Mar 2024 Jun 2024 Sep 2024
28,326 29,867 31,500 32,805 34,527 35,804 36,009 37,440 37,044 37,900 37,599 38,506 41,473
14,516 15,164 15,460 16,275 16,933 17,720 17,312 17,842 17,530 18,085 18,234 18,799 19,627
Operating Profit 13,810 14,703 16,040 16,529 17,594 18,085 18,697 19,598 19,514 19,815 19,365 19,708 21,846
OPM % 49% 49% 51% 50% 51% 51% 52% 52% 53% 52% 52% 51% 53%
1,430 853 1,638 355 559 -412 886 -2,478 -654 1,013 -1,308 2,010 475
Interest 3,964 4,367 4,059 4,511 4,940 4,686 5,163 5,614 5,186 6,645 5,203 5,152 5,424
Depreciation 8,247 8,547 8,583 8,781 8,947 9,298 9,406 9,654 9,734 10,074 10,075 10,540 11,000
Profit before tax 3,029 2,642 5,037 3,592 4,265 3,689 5,014 1,853 3,940 4,108 2,778 6,025 5,897
Tax % 34% 38% 26% 31% 30% 29% 16% 18% 47% 30% 26% 22% 30%
1,998 1,651 3,715 2,469 2,979 2,614 4,226 1,520 2,093 2,876 2,068 4,718 4,153
EPS in Rs 1.93 1.41 3.41 2.73 3.86 2.85 5.39 2.89 2.39 4.34 3.66 7.31 6.31
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 TTM
76,947 85,864 96,101 96,532 95,468 82,639 80,780 87,539 100,616 116,547 139,145 149,982 155,478
53,987 59,352 62,499 62,548 60,138 52,560 55,016 50,930 55,337 59,013 67,871 71,691 74,745
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 80,733
OPM % 30% 31% 35% 35% 37% 36% 32% 42% 45% 49% 51% 52% 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 2,190
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 22,424
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 41,690
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 18,809
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 13,816
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 21.62
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: 6%
Compounded Profit Growth
10 Years: 16%
5 Years: 122%
3 Years: -2%
TTM: 32%
Stock Price CAGR
10 Years: 18%
5 Years: 31%
3 Years: 35%
1 Year: 69%
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 Sep 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 2,896
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 84,202
66,736 75,896 83,415 100,646 107,288 111,334 125,428 148,228 162,785 169,678 226,020 215,592 225,541
40,912 45,840 58,747 57,056 57,578 68,653 77,176 133,718 122,679 124,975 140,974 144,408 148,344
Total Liabilities 157,970 181,492 181,939 224,472 232,322 249,521 274,026 359,091 344,417 361,207 444,557 442,019 460,982
125,674 140,614 124,279 172,293 178,235 187,200 200,832 229,256 223,480 244,083 277,394 303,303 330,199
CWIP 2,992 0 17,415 5,702 10,838 9,751 9,634 4,282 5,726 5,955 49,425 16,904 8,753
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 34,438
21,594 25,347 29,494 34,500 28,910 36,411 47,850 100,077 87,661 81,820 84,784 90,210 87,592
Total Assets 157,970 181,492 181,939 224,472 232,322 249,521 274,026 359,091 344,417 361,207 444,557 442,019 460,982

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 -51,089
-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 31

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

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

* 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