Bharti Airtel Ltd
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]
- Market Cap ₹ 7,74,409 Cr.
- Current Price ₹ 1,301
- High / Low ₹ 1,364 / 784
- Stock P/E 145
- Book Value ₹ 144
- Dividend Yield 0.31 %
- ROCE 8.39 %
- ROE -0.53 %
- Face Value ₹ 5.00
Pros
Cons
- Stock is trading at 9.04 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 -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.
Peer comparison
Sector: Telecomm-Service Industry: Telecommunications - Service Provider
Quarterly Results
Standalone Figures in Rs. Crores / View Consolidated
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: | 33% |
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% |
Documents
Announcements
-
Announcement under Regulation 30 (LODR)-Analyst / Investor Meet - Intimation
4h - Schedule of Earnings Call to be held on Wednesday, May 15, 2024 in respect of the audited financial results of the Company for the fourth …
- Update on board meeting 1d
-
Announcement under Regulation 30 (LODR)-Press Release / Media Release
1d - Press release dated May 09, 2024 titled ''Airtel expands its network footprint in Sabarkantha District under its rural network expansion project'' being issued by the …
-
Announcement under Regulation 30 (LODR)-Press Release / Media Release
1d - Press release dated May 09, 2024 titled ''Airtel celebrates 2.5 million 5G customers in North East and Assam'' being issued by the Company.
-
Announcement under Regulation 30 (LODR)-Press Release / Media Release
7 May - Press releases dated May 07, 2024 being issued by the Company titled: (a) ''Airtel expands its network footprint in Haora District under its rural enhancement …
Annual reports
-
Financial Year 2023
from bse
-
Financial Year 2022
from bse
-
Financial Year 2021
from bse
-
Financial Year 2020
from bse
-
Financial Year 2019
from bse
-
Financial Year 2018
from bse
-
Financial Year 2017
from bse
-
Financial Year 2016
from bse
-
Financial Year 2015
from bse
-
Financial Year 2014
from bse
-
Financial Year 2013
from bse
-
Financial Year 2012
from bse
-
Financial Year 2011
from nse
-
Financial Year 2011
from bse
-
Financial Year 2010
from bse
Concalls
-
Feb 2024TranscriptPPT
-
Nov 2023TranscriptPPT
-
Aug 2023TranscriptPPT
-
May 2023TranscriptPPT
-
Mar 2023TranscriptNotesPPT
-
Feb 2023TranscriptPPT
-
Nov 2022TranscriptPPT
-
Aug 2022Transcript PPT
-
May 2022TranscriptPPT
-
Mar 2022TranscriptNotesPPT
-
Nov 2021TranscriptNotesPPT
-
Nov 2018TranscriptNotesPPT
-
Sep 2018TranscriptNotesPPT
-
Sep 2018TranscriptNotesPPT
-
Sep 2018TranscriptNotesPPT
-
Aug 2018TranscriptNotesPPT
-
Jun 2018TranscriptNotesPPT
-
Feb 2018TranscriptNotesPPT
-
Dec 2017TranscriptNotesPPT
-
Nov 2017TranscriptNotesPPT
-
Nov 2017TranscriptNotesPPT
-
Nov 2017TranscriptNotesPPT
-
Sep 2017TranscriptNotesPPT
-
Sep 2017TranscriptNotesPPT
-
Jun 2017TranscriptNotesPPT
-
Jun 2017TranscriptNotesPPT
-
Mar 2017TranscriptNotesPPT
-
Sep 2016TranscriptNotesPPT
-
Jun 2016TranscriptNotesPPT
-
Jun 2016TranscriptNotesPPT
-
Dec 2015TranscriptNotesPPT
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]