Bharti Airtel Ltd

Bharti Airtel Ltd

₹ 1,229 0.31%
28 Mar - 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

Diversified Products & Services
The Company’s diversified service range includes mobile, voice and data solutions, using 2G, 3G and 4G 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,27,024 Cr.
  • Current Price 1,229
  • High / Low 1,245 / 742
  • Stock P/E 136
  • Book Value 144
  • Dividend Yield 0.33 %
  • ROCE 8.39 %
  • ROE -0.53 %
  • Face Value 5.00

Pros

Cons

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

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
16,936 16,330 16,114 17,104 17,964 19,546 20,228 21,058 21,606 21,829 22,651 23,258 23,866
9,511 8,726 8,266 8,535 9,087 9,881 10,026 10,165 10,359 10,371 10,515 10,786 10,942
Operating Profit 7,425 7,603 7,848 8,570 8,877 9,665 10,201 10,892 11,247 11,458 12,135 12,471 12,924
OPM % 44% 47% 49% 50% 49% 49% 50% 52% 52% 52% 54% 54% 54%
-3,665 1,630 1,000 780 114 -2,490 1,659 498 -3,937 138 185 -759 89
Interest 2,969 3,188 3,673 3,384 3,305 3,318 3,941 3,954 3,529 3,108 3,452 3,741 3,550
Depreciation 5,636 5,560 5,759 6,144 6,267 6,305 6,481 6,508 6,661 6,706 6,931 7,113 7,458
Profit before tax -4,845 486 -584 -178 -581 -2,447 1,439 929 -2,880 1,782 1,937 858 2,006
Tax % -72% 6% 25% 25% 23% 6% 24% 26% -12% 24% 25% 66% 29%
-8,346 456 -436 -133 -447 -2,297 1,095 684 -3,222 1,354 1,457 293 1,414
EPS in Rs -14.28 0.78 -0.74 -0.23 -0.76 -3.90 1.86 1.23 -5.79 2.43 2.61 0.52 2.51
Raw PDF

Profit & Loss

Standalone Figures in Rs. Crores / View Consolidated

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

Balance Sheet

Standalone Figures in Rs. Crores / View Consolidated

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 47,531 52,247 64,729 76,274 109,730 99,209 100,862 96,307 98,701 74,614 72,076 76,157 78,123
15,301 14,218 10,365 21,570 45,571 60,095 65,416 83,790 118,800 130,407 129,905 181,696 173,427
15,593 19,519 21,111 26,581 27,728 30,336 36,661 40,812 80,143 69,980 66,465 74,888 82,137
Total Liabilities 80,324 87,883 98,204 126,424 185,028 191,638 204,937 222,908 300,373 277,747 271,241 335,577 336,544
40,441 43,183 39,878 53,444 91,926 111,523 122,609 133,812 161,679 157,388 163,736 187,409 222,389
CWIP 4,466 1,031 1,244 9,067 3,830 9,600 5,543 5,636 1,259 1,306 3,386 40,556 9,371
Investments 12,338 28,199 34,524 43,117 69,983 45,959 48,128 37,580 38,727 52,273 46,726 46,700 43,412
23,079 15,471 22,558 20,796 19,289 24,556 28,657 45,879 98,708 66,779 57,393 60,913 61,372
Total Assets 80,324 87,883 98,204 126,424 185,028 191,638 204,937 222,908 300,373 277,747 271,241 335,577 336,544

Cash Flows

Standalone Figures in Rs. Crores / View Consolidated

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

Ratios

Standalone Figures in Rs. Crores / View Consolidated

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

Shareholding Pattern

Numbers in percentages

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

* 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