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,02,302 Cr.
- Current Price ₹ 1,673
- High / Low ₹ 1,712 / 895
- Stock P/E 83.9
- Book Value ₹ 145
- Dividend Yield 0.48 %
- ROCE 13.1 %
- ROE 14.9 %
- Face Value ₹ 5.00
Pros
- Company has been maintaining a healthy dividend payout of 42.8%
Cons
- Stock is trading at 11.5 times its book value
- Company has low interest coverage ratio.
- Company has a low return on equity of 11.3% 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
Consolidated Figures in Rs. Crores / View Standalone
Profit & Loss
Consolidated Figures in Rs. Crores / View Standalone
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 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
76,947 | 85,864 | 96,101 | 96,532 | 95,468 | 82,639 | 80,780 | 87,539 | 100,616 | 116,547 | 139,145 | 149,982 | 151,049 | |
53,987 | 59,352 | 62,499 | 62,548 | 60,138 | 52,560 | 55,016 | 50,930 | 55,337 | 59,013 | 67,871 | 71,691 | 72,648 | |
Operating Profit | 22,960 | 26,512 | 33,602 | 33,984 | 35,330 | 30,079 | 25,764 | 36,610 | 45,279 | 57,534 | 71,274 | 78,292 | 78,401 |
OPM % | 30% | 31% | 35% | 35% | 37% | 36% | 32% | 42% | 45% | 49% | 51% | 52% | 52% |
1,159 | 2,881 | 1,243 | 4,858 | 1,713 | 1,756 | 4,474 | -37,775 | -4,215 | 4,656 | 1,019 | -3,428 | 1,061 | |
Interest | 4,519 | 5,879 | 4,446 | 8,546 | 9,547 | 9,326 | 10,622 | 13,992 | 15,091 | 16,616 | 19,300 | 22,648 | 22,186 |
Depreciation | 14,815 | 15,650 | 19,858 | 17,450 | 19,773 | 19,243 | 21,348 | 27,690 | 29,404 | 33,091 | 36,432 | 39,538 | 40,424 |
Profit before tax | 4,785 | 7,864 | 10,540 | 12,846 | 7,723 | 3,267 | -1,732 | -42,846 | -3,432 | 12,483 | 16,561 | 12,679 | 16,851 |
Tax % | 53% | 62% | 52% | 46% | 45% | 33% | -197% | -28% | 260% | 33% | 26% | 32% | |
2,267 | 3,019 | 5,048 | 6,893 | 4,241 | 2,184 | 1,688 | -30,664 | -12,364 | 8,305 | 12,287 | 8,558 | 11,755 | |
EPS in Rs | 4.32 | 5.04 | 8.41 | 11.05 | 6.91 | 2.00 | 0.74 | -55.06 | -25.63 | 7.23 | 14.97 | 13.20 | 17.70 |
Dividend Payout % | 17% | 26% | 33% | 9% | 11% | 194% | 244% | -3% | 0% | 39% | 27% | 62% |
Compounded Sales Growth | |
---|---|
10 Years: | 6% |
5 Years: | 13% |
3 Years: | 14% |
TTM: | 5% |
Compounded Profit Growth | |
---|---|
10 Years: | 16% |
5 Years: | 122% |
3 Years: | -2% |
TTM: | 8% |
Stock Price CAGR | |
---|---|
10 Years: | 16% |
5 Years: | 37% |
3 Years: | 33% |
1 Year: | 81% |
Return on Equity | |
---|---|
10 Years: | 9% |
5 Years: | 12% |
3 Years: | 11% |
Last Year: | 15% |
Balance Sheet
Consolidated Figures in Rs. Crores / View Standalone
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 | 48,423 | 57,757 | 37,778 | 64,771 | 65,458 | 67,536 | 69,424 | 74,417 | 56,207 | 63,759 | 74,726 | 79,142 |
66,736 | 75,896 | 83,415 | 100,646 | 107,288 | 111,334 | 125,428 | 148,228 | 162,785 | 169,678 | 226,020 | 215,592 | |
40,912 | 45,840 | 58,747 | 57,056 | 57,578 | 68,653 | 77,176 | 133,718 | 122,679 | 124,975 | 140,974 | 144,408 | |
Total Liabilities | 157,970 | 181,492 | 181,939 | 224,472 | 232,322 | 249,521 | 274,026 | 359,091 | 344,417 | 361,207 | 444,557 | 442,019 |
125,674 | 140,614 | 124,279 | 172,293 | 178,235 | 187,200 | 200,832 | 229,256 | 223,480 | 244,083 | 277,394 | 303,303 | |
CWIP | 2,992 | 0 | 17,415 | 5,702 | 10,838 | 9,751 | 9,634 | 4,282 | 5,726 | 5,955 | 49,425 | 16,904 |
Investments | 7,710 | 15,531 | 10,752 | 11,977 | 14,339 | 16,159 | 15,711 | 25,476 | 27,550 | 29,349 | 32,954 | 31,602 |
21,594 | 25,347 | 29,494 | 34,500 | 28,910 | 36,411 | 47,850 | 100,077 | 87,661 | 81,820 | 84,784 | 90,210 | |
Total Assets | 157,970 | 181,492 | 181,939 | 224,472 | 232,322 | 249,521 | 274,026 | 359,091 | 344,417 | 361,207 | 444,557 | 442,019 |
Cash Flows
Consolidated Figures in Rs. Crores / View Standalone
Mar 2013 | Mar 2014 | Mar 2015 | Mar 2016 | Mar 2017 | Mar 2018 | Mar 2019 | Mar 2020 | Mar 2021 | Mar 2022 | Mar 2023 | Mar 2024 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|
22,608 | 26,233 | 28,059 | 27,942 | 28,280 | 29,854 | 20,070 | 18,129 | 48,205 | 55,017 | 65,325 | 78,898 | |
-18,676 | -25,181 | -22,301 | -14,091 | -30,680 | -27,940 | -28,286 | -29,598 | -27,286 | -41,478 | -39,232 | -51,089 | |
-4,566 | 2,774 | -9,672 | -11,946 | -351 | 1,920 | 9,464 | 19,144 | -24,910 | -15,203 | -24,470 | -27,778 | |
Net Cash Flow | -634 | 3,826 | -3,914 | 1,905 | -2,752 | 3,835 | 1,248 | 7,675 | -3,991 | -1,664 | 1,623 | 31 |
Ratios
Consolidated Figures in Rs. Crores / View Standalone
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 | 32 | 27 | 20 | 21 | 18 | 26 | 19 | 19 | 13 | 13 | 10 | 12 |
Inventory Days | ||||||||||||
Days Payable | ||||||||||||
Cash Conversion Cycle | 32 | 27 | 20 | 21 | 18 | 26 | 19 | 19 | 13 | 13 | 10 | 12 |
Working Capital Days | -98 | -105 | -172 | -139 | -150 | -200 | -189 | -257 | -172 | -154 | -155 | -161 |
ROCE % | 7% | 10% | 11% | 13% | 10% | 7% | 3% | 5% | 7% | 11% | 12% | 13% |
Documents
Announcements
-
Disclosure Under Regulation 30 Of SEBI (LODR) Regulations, 2015
7h - Notice of penalty for subscriber verification violation.
-
Announcement under Regulation 30 (LODR)-Analyst / Investor Meet - Intimation
7h - The Company will participate in analysts/institutional investors'' meet as per enclosed schedule.
-
Disclosure Under Regulation 30 Of SEBI (LODR) Regulations, 2015
14h - Bharti Airtel disputes penalties from DoT for subscriber verification violations.
-
Announcement under Regulation 30 (LODR)-Press Release / Media Release
15h - Airtel and Cisco launch Airtel SD-Branch for enterprises.
-
Announcement under Regulation 30 (LODR)-Analyst / Investor Meet - Intimation
1d - Participation in J.P. Morgan India Investor Summit.
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]