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,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.
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: | 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% |
Documents
Announcements
- Disclosure Under Regulation 30 Of SEBI (LODR) Regulations, 2015 9h
- Disclosure Under Regulation 30 Of SEBI (LODR) Regulations, 2015 11h
-
Announcement under Regulation 30 (LODR)-Press Release / Media Release
14h - Press releases dated March 28, 2024 being issued by the Company titled: (a) ''Airtel expands its network footprint in Purba and Paschim Bardhaman District under …
- Disclosure Under Regulation 30 Of SEBI (LODR) Regulations, 2015 1d
- Disclosure Under Regulation 30 Of SEBI (LODR) Regulations, 2015 1d
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 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]