Bharti Airtel Ltd

Bharti Airtel Ltd

₹ 1,600 0.98%
26 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 9,57,146 Cr.
  • Current Price 1,600
  • High / Low 1,779 / 1,007
  • Stock P/E 127
  • Book Value 182
  • Dividend Yield 0.50 %
  • ROCE 8.59 %
  • ROE 6.54 %
  • Face Value 5.00

Pros

  • Company has delivered good profit growth of 44.4% CAGR over last 5 years

Cons

  • Stock is trading at 8.80 times its book value
  • Company has low interest coverage ratio.
  • Company has a low return on equity of 1.43% 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

Standalone Figures in Rs. Crores / View Consolidated

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
17,104 17,964 19,546 20,228 21,058 21,606 21,829 22,651 23,258 23,866 24,345 24,917 26,984
8,535 9,087 9,881 10,026 10,165 10,359 10,371 10,515 10,786 10,942 11,360 11,491 12,032
Operating Profit 8,570 8,877 9,665 10,201 10,892 11,247 11,458 12,135 12,471 12,924 12,986 13,426 14,953
OPM % 50% 49% 49% 50% 52% 52% 52% 54% 54% 54% 53% 54% 55%
780 114 -2,490 1,659 498 -3,937 138 185 -759 89 599 1,172 408
Interest 3,384 3,305 3,318 3,941 3,954 3,529 3,108 3,452 3,741 3,550 3,662 3,668 3,872
Depreciation 6,144 6,267 6,305 6,481 6,508 6,661 6,706 6,931 7,113 7,458 7,607 7,928 8,137
Profit before tax -178 -581 -2,447 1,439 929 -2,880 1,782 1,937 858 2,006 2,315 3,002 3,352
Tax % -25% -23% -6% 24% 26% 12% 24% 25% 66% 29% 21% 18% 25%
-133 -447 -2,297 1,095 684 -3,222 1,354 1,457 293 1,414 1,824 2,469 2,518
EPS in Rs -0.23 -0.76 -3.90 1.86 1.23 -5.79 2.43 2.61 0.52 2.51 3.23 4.34 4.42
Raw PDF

Profit & Loss

Standalone Figures in Rs. Crores / View Consolidated

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
45,351 49,918 55,496 60,300 62,276 53,663 49,606 54,317 64,326 70,795 84,720 94,120 100,113
31,832 33,620 36,010 37,887 38,351 35,798 34,994 34,058 36,342 36,094 40,921 43,604 45,825
Operating Profit 13,519 16,299 19,486 22,413 23,925 17,864 14,612 20,259 27,984 34,700 43,799 50,516 54,288
OPM % 30% 33% 35% 37% 38% 33% 29% 37% 44% 49% 52% 54% 54%
1,415 646 5,138 962 -14,977 414 3,112 -39,425 -12,635 -1,406 -1,643 114 2,268
Interest 1,652 1,336 1,409 3,545 5,255 5,911 7,848 11,463 11,817 13,221 14,532 14,405 14,751
Depreciation 6,827 7,231 7,560 9,575 12,203 13,049 15,120 20,392 21,998 24,330 26,355 29,108 31,130
Profit before tax 6,455 8,377 15,655 10,254 -8,510 -681 -5,244 -51,021 -18,465 -4,256 1,269 7,116 10,675
Tax % 21% 21% 16% 24% 17% -112% -64% -29% 36% -9% 107% 30%
5,096 6,600 13,200 7,780 -9,926 79 -1,869 -36,088 -25,198 -3,864 -90 4,988 8,225
EPS in Rs 9.76 12.01 24.01 14.15 -18.05 0.14 -3.40 -61.74 -42.82 -6.57 -0.16 8.82 14.50
Dividend Payout % 7% 11% 12% 7% -4% 2,695% -53% -3% 0% -43% -2,533% 92%
Compounded Sales Growth
10 Years: 7%
5 Years: 14%
3 Years: 14%
TTM: 12%
Compounded Profit Growth
10 Years: -1%
5 Years: 44%
3 Years: 33%
TTM: 70%
Stock Price CAGR
10 Years: 18%
5 Years: 29%
3 Years: 33%
1 Year: 57%
Return on Equity
10 Years: 2%
5 Years: -2%
3 Years: 1%
Last Year: 7%

Balance Sheet

Standalone Figures in Rs. Crores / View Consolidated

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 52,247 64,729 76,274 109,730 99,209 100,862 96,307 98,701 74,614 72,076 76,157 97,985 100,589
14,218 10,365 21,570 45,571 60,095 65,416 83,790 118,800 130,407 129,905 181,696 169,299 168,762
19,519 21,111 26,581 27,728 30,336 36,661 40,812 80,143 69,980 66,465 74,888 81,652 83,480
Total Liabilities 87,883 98,204 126,424 185,028 191,638 204,937 222,908 300,373 277,747 271,241 335,577 351,813 355,726
43,183 39,878 53,444 91,926 111,523 122,609 133,812 161,679 157,388 163,736 187,409 221,717 236,234
CWIP 1,031 1,244 9,067 3,830 9,600 5,543 5,636 1,259 1,306 3,386 40,556 12,012 4,390
Investments 28,199 34,524 43,117 69,983 45,959 48,128 37,580 38,727 52,273 46,726 46,700 57,647 60,075
15,471 22,558 20,796 19,289 24,556 28,657 45,879 98,708 66,779 57,393 60,913 60,437 55,027
Total Assets 87,883 98,204 126,424 185,028 191,638 204,937 222,908 300,373 277,747 271,241 335,577 351,813 355,726

Cash Flows

Standalone Figures in Rs. Crores / View Consolidated

Mar 2013 Mar 2014 Mar 2015 Mar 2016 Mar 2017 Mar 2018 Mar 2019 Mar 2020 Mar 2021 Mar 2022 Mar 2023 Mar 2024
13,885 16,022 17,940 19,450 21,166 15,954 10,812 4,026 34,392 36,754 43,583 53,209
-10,726 -17,086 -12,801 -21,989 -24,283 -17,211 -20,456 -22,272 -13,223 -33,170 -30,006 -34,877
-3,186 1,182 -5,196 1,898 3,456 1,637 9,398 21,114 -23,218 -4,289 -12,500 -19,184
Net Cash Flow -27 118 -57 -641 338 380 -246 2,869 -2,049 -704 1,076 -852

Ratios

Standalone Figures in Rs. Crores / View Consolidated

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 18 16 22 19 19 29 28 26 18 14 9 10
Inventory Days
Days Payable
Cash Conversion Cycle 18 16 22 19 19 29 28 26 18 14 9 10
Working Capital Days -93 -88 -84 -96 -70 -138 -148 -225 -146 -149 -139 -148
ROCE % 12% 13% 15% 11% 9% 4% 3% 1% 4% 5% 9% 9%

Shareholding Pattern

Numbers in percentages

6 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