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 ₹ 10,24,484 Cr.
- Current Price ₹ 1,710
- High / Low ₹ 1,779 / 895
- Stock P/E 172
- Book Value ₹ 178
- Dividend Yield 0.47 %
- 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 9.59 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.
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 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 | 96,386 | |
31,832 | 33,620 | 36,010 | 37,887 | 38,351 | 35,798 | 34,994 | 34,058 | 36,342 | 36,094 | 40,921 | 43,604 | 44,580 | |
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 | 51,806 |
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 | 1,101 | |
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,620 |
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 | 30,106 |
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 | 8,182 |
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 | 6,000 | |
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 | 10.60 |
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: | 11% |
Compounded Profit Growth | |
---|---|
10 Years: | -1% |
5 Years: | 44% |
3 Years: | 33% |
TTM: | 41% |
Stock Price CAGR | |
---|---|
10 Years: | 17% |
5 Years: | 38% |
3 Years: | 36% |
1 Year: | 85% |
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 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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 |
14,218 | 10,365 | 21,570 | 45,571 | 60,095 | 65,416 | 83,790 | 118,800 | 130,407 | 129,905 | 181,696 | 169,299 | |
19,519 | 21,111 | 26,581 | 27,728 | 30,336 | 36,661 | 40,812 | 80,143 | 69,980 | 66,465 | 74,888 | 81,652 | |
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 |
43,183 | 39,878 | 53,444 | 91,926 | 111,523 | 122,609 | 133,812 | 161,679 | 157,388 | 163,736 | 187,409 | 221,717 | |
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 |
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 |
15,471 | 22,558 | 20,796 | 19,289 | 24,556 | 28,657 | 45,879 | 98,708 | 66,779 | 57,393 | 60,913 | 60,437 | |
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 |
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% |
Documents
Announcements
-
Announcement under Regulation 30 (LODR)-Press Release / Media Release
4h - Airtel prepays Rs. 8,465 crores for spectrum liabilities.
-
Disclosure Under Regulation 30 Of SEBI (LODR) Regulations, 2015
2d - Disclosure of penalties imposed by DoT for subscriber verification violations.
-
Disclosure Under Regulation 30 Of SEBI (LODR) Regulations, 2015
27 Sep - Notice received for penalty on subscriber verification norms.
-
Disclosure Under Regulation 30 Of SEBI (LODR) Regulations, 2015
26 Sep - Notice of penalty for subscriber verification violation.
-
Announcement under Regulation 30 (LODR)-Press Release / Media Release
25 Sep - Airtel launches India's first AI-powered spam detection solution.
Annual reports
-
Financial Year 2024
from bse
-
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
Concalls
-
Sep 2024TranscriptNotesPPT
-
Aug 2024TranscriptPPT
-
May 2024TranscriptPPTREC
-
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]