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 ₹ 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.
Peer comparison
Sector: Telecomm-Service Industry: Telecommunications - Service Provider
Part of BSE Sensex Nifty 50 BSE 500 BSE 100 BSE 200
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 | 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% |
Documents
Announcements
- Closure of Trading Window 5h
-
Disclosure Under Regulation 30 Of SEBI (LODR) Regulations, 2015
21 Dec - Disclosure of penalty imposed by DoT for violations.
-
Announcement under Regulation 30 (LODR)-Press Release / Media Release
20 Dec - Airtel partners with Zee5 to offer content to WiFi customers.
-
Announcement under Regulation 30 (LODR)-Press Release / Media Release
19 Dec - Bharti Airtel prepays Rs. 3,626 crores for spectrum liabilities.
-
Announcement under Regulation 30 (LODR)-Newspaper Publication
18 Dec - Newspaper advertisement of notice published on December 18, 2024 - Information regarding Postal Ballot
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
-
Nov 2024TranscriptPPT
-
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
Segments & Presence[1]
Mobile, Broadband, DTH and Bank.
The company has operations in India, Africa, Bangladesh and Sri Lanka.