Sharescart Research Club logo ×
Screener Research Unlisted Startup Funding New IPO New

  • Home
  • /
  • Bharti Airtel
Join Channel
Consolidated Standalone

Bharti Airtel

₹1599.5 15.3 | 1%

Market Cap ₹973795 Cr.

Stock P/E 113.8

P/B 11.1

Current Price ₹1599.5

Book Value ₹ 143.5

Face Value 5

52W High ₹1779

Dividend Yield 0.5%

52W Low ₹ 998.5

Edit Ratio

Bharti Airtel Research see more...

Overview Inc. Year: 1995Industry: Telecommunication - Service Provider

Bharti Airtel Limited is a global telecommunications agency with operations in 18 nations throughout Asia and Africa. Its segments are Mobile Services India, Mobile Services Africa, Mobile Services South Asia, Tower Infrastructure Services, Digital TV Services, Homes Services, Airtel Business and Others. The Mobile Services India segment consists of voice and data telecom offerings supplied through wireless technology (2G / 3G / 4G) in India. The Mobile Services Africa section consists of voice and records telecom offerings supplied via wi-fi era (2G / 3G / 4G) offered to customers in Africa. The Mobile Services South Asia segment consists of voice and information telecom services supplied through wireless generation (2G / 3G) in Sri Lanka. The Tower Infrastructure Services section consists of setting up, operating and maintaining wireless communication towers in India. The Digital TV Services section includes digital broadcasting offerings provided underneath the direct-to-home platform.

Read More..

Bharti Airtel Share Price

New

₹ | |

Volume
Price

Quarterly Price

Quarterly Monthly
Show Value Show %

Peer Comparison

Bharti Airtel Quarterly Results

#(Fig in Cr.) Jun 2022 Sep 2022 Dec 2022 Mar 2023 Jun 2023 Sep 2023 Dec 2023 Mar 2024 Jun 2024 Sep 2024
Net Sales 32805 34527 35804 36009 37440 37044 37900 37599 38506 41473
Other Income 192 202 258 285 348 330 440 317 364 255
Total Income 32997 34729 36062 36294 37788 37374 38339 37916 38870 41728
Total Expenditure 16275 16933 17351 17312 17842 17530 18085 18234 18799 19627
Operating Profit 16722 17796 18711 18982 19947 19844 20255 19682 20071 22101
Interest 4511 4940 4686 5163 5614 5186 6645 5203 5152 5424
Depreciation 8781 8947 9298 9406 9654 9734 10074 10075 10540 11000
Exceptional Income / Expenses 0 0 -670 0 -3416 -1570 -130 -2456 735 -854
Profit Before Tax 3429 3909 4058 4413 1263 3354 3405 1948 5114 4824
Provision for Tax 1123 1286 1076 788 333 1847 1232 710 1308 1744
Profit After Tax 2306 2622 2982 3625 930 1507 2173 1238 3806 3080
Adjustments -699 -477 -1394 -619 682 -167 269 834 354 514
Profit After Adjustments 1607 2145 1588 3006 1613 1341 2442 2072 4160 3593
Adjusted Earnings Per Share 2.9 3.8 2.8 5.3 2.8 2.3 4.3 3.6 7.2 6.2

Bharti Airtel Profit & Loss

#(Fig in Cr.) Mar 2014 Mar 2015 Mar 2016 Mar 2017 Mar 2018 Mar 2019 Mar 2020 Mar 2021 Mar 2022 Mar 2023 Mar 2024 TTM
Net Sales 85864 96101 96532 95468 82639 80780 84677 100616 116547 139145 149982 155478
Other Income 1041 2096 1720 1970 1531 2799 1536 643 534 937 1886 1376
Total Income 86904 98197 98252 97438 84170 83579 86212 101259 117081 140081 151868 156853
Total Expenditure 58087 62499 62650 60270 52602 56626 50423 55244 59013 67871 72141 74745
Operating Profit 28818 35698 35602 37168 31568 26954 35789 46015 58068 72210 79727 82109
Interest 5879 4447 8546 9547 9326 10622 14073 15091 16616 19300 22648 22424
Depreciation 15650 19858 17450 19773 19243 21348 27094 29404 33091 36432 39538 41689
Exceptional Income / Expenses 54 -853 2174 -1170 -793 2929 -40089 -15915 1699 -670 -7572 -2705
Profit Before Tax 7864 10540 12846 7723 3267 -1732 -46130 -14488 12483 16561 12679 15291
Provision for Tax 4845 5487 5953 3482 1084 -3419 -12512 8933 4178 4273 4121 4994
Profit After Tax 3019 5053 6893 4241 2184 1688 -33618 -23421 8305 12287 8558 10297
Adjustments -247 -432 -816 -442 -1085 -1278 1435 8337 -4050 -3942 -1091 1971
Profit After Adjustments 2773 4621 6077 3800 1099 410 -32183 -15084 4255 8346 7467 12267
Adjusted Earnings Per Share 6.2 10.4 13.7 8.6 2.5 0.9 -57.9 -26.9 7.6 14.7 13 21.3

Growth Rates

# 1 Year 3 Year 5 Year 10 Year
Sales CAGR 8% 14% 13% 6%
Operating Profit CAGR 10% 20% 24% 11%
PAT CAGR -30% 0% 38% 11%
# 1 Year 3 Year 5 Year 10 Year
Share Price CAGR 60% 33% 29% 17%
ROE Average 11% 14% -8% 0%
ROCE Average 15% 15% 6% 8%

Bharti Airtel Balance Sheet

#(Fig in Cr.) Mar 2014 Mar 2015 Mar 2016 Mar 2017 Mar 2018 Mar 2019 Mar 2020 Mar 2021 Mar 2022 Mar 2023 Mar 2024
Shareholder's Funds 59756 39777 66769 67456 69534 71422 77145 58953 66554 77563 82019
Minority's Interest 4210 6891 5498 6875 8814 13526 24985 22274 25381 28881 23545
Borrowings 54992 61116 89269 89637 84942 82490 91079 110560 113535 151569 130963
Other Non-Current Liabilities 1151 8253 853 3217 6118 5767 9067 22519 24235 47705 50094
Total Current Liabilities 56805 84531 58828 63460 78240 93013 131488 111564 114026 121964 138668
Total Liabilities 176915 200567 221321 230646 247649 266218 333763 325941 343731 427681 425288
Fixed Assets 140615 124279 172293 178235 187200 200832 229256 223480 244083 277394 303303
Other Non-Current Assets 13914 35746 25901 34207 26949 32522 27864 47709 47620 92786 63709
Total Current Assets 22386 40543 22439 18204 33499 32864 76643 54553 52028 57501 58276
Total Assets 176915 200567 221321 230646 247649 266218 333763 325941 343731 427681 425288

Bharti Airtel Cash Flow

#(Fig in Cr.) Mar 2014 Mar 2015 Mar 2016 Mar 2017 Mar 2018 Mar 2019 Mar 2020 Mar 2021 Mar 2022 Mar 2023 Mar 2024
Opening Cash & Cash Equivalents 131 5112 -141 1764 -988 4131 5379 13054 9063 7399 9021
Cash Flow from Operating Activities 26233 28059 27942 28280 29854 20070 18129 48205 55017 65325 78898
Cash Flow from Investing Activities -24973 -22305 -14226 -30604 -27968 -28501 -30492 -26888 -41870 -39080 -50204
Cash Flow from Financing Activities 2774 -9672 -11946 -351 1921 9464 19144 -24910 -15203 -24470 -27779
Net Cash Inflow / Outflow 4034 -3919 1771 -2676 3807 1033 6781 -3594 -2056 1775 916
Closing Cash & Cash Equivalent 3958 1198 1764 -988 2847 5379 13054 9063 7399 9021 9052

Bharti Airtel Ratios

# Mar 2014 Mar 2015 Mar 2016 Mar 2017 Mar 2018 Mar 2019 Mar 2020 Mar 2021 Mar 2022 Mar 2023 Mar 2024
Earnings Per Share (Rs) 6.25 10.41 13.69 8.56 2.48 0.92 -57.88 -26.95 7.61 14.71 12.98
CEPS(Rs) 42.06 56.13 54.85 54.11 48.28 51.9 -11.73 10.69 74.05 85.88 83.6
DPS(Rs) 1.62 3.47 1.22 0.9 4.81 2.25 1.96 0 3 4 8
Book NAV/Share(Rs) 134.64 89.32 149.28 151.07 156.5 160.76 138.62 105.16 118.88 136.41 142.2
Core EBITDA Margin(%) 32.35 34.97 35.1 36.87 36.35 29.9 40.45 45.09 49.37 51.22 51.9
EBIT Margin(%) 16.01 15.59 22.16 18.09 15.24 11.01 -37.86 0.6 24.97 25.77 23.55
Pre Tax Margin(%) 9.16 10.97 13.31 8.09 3.95 -2.14 -54.48 -14.4 10.71 11.9 8.45
PAT Margin (%) 3.52 5.26 7.14 4.44 2.64 2.09 -39.7 -23.28 7.13 8.83 5.71
Cash Profit Margin (%) 21.74 25.92 25.22 25.15 25.93 28.52 -7.7 5.95 35.52 35.01 32.07
ROA(%) 1.83 2.68 3.27 1.88 0.91 0.66 -11.21 -7.1 2.48 3.19 2.01
ROE(%) 5.49 10.17 13.02 6.36 3.2 2.4 -45.3 -34.46 13.25 17.08 10.75
ROCE(%) 10.88 11.58 14.73 10.1 7.08 4.77 -16.57 0.31 14.99 16.21 14.81
Receivable days 27.69 21.75 20.25 19.58 23.46 23.01 19.2 14.96 12.05 10.54 10.6
Inventory Days 0.54 0.98 1.54 0.94 0.26 0.36 0.53 0.77 1 0.83 0.76
Payable days 0 0 0 0 9807.47 8938.78 7137.84 5246.73 4075.29 3379.84 3120.12
PER(x) 45.98 34.08 23.08 36.81 145.09 324.96 0 0 99.24 50.91 94.7
Price/Book(x) 2.13 3.97 2.12 2.09 2.3 1.87 3.12 4.83 6.35 5.49 8.64
Dividend Yield(%) 0.56 0.98 0.39 0.29 1.34 0.75 0.45 0 0.4 0.53 0.65
EV/Net Sales(x) 2.31 2.48 2.44 2.54 3.2 3.04 4.04 3.98 4.65 4.15 5.62
EV/Core EBITDA(x) 6.88 6.69 6.62 6.51 8.37 9.12 9.56 8.7 9.33 7.99 10.57
Net Sales Growth(%) 11.59 11.92 0.45 -1.1 -13.44 -2.25 4.82 18.82 15.83 19.39 7.79
EBIT Growth(%) 47.71 9.05 42.75 -19.27 -27.08 -29.4 -460.58 101.88 4727.36 23.24 -1.49
PAT Growth(%) 33.2 67.35 36.41 -38.47 -48.52 -22.72 -2092.18 30.33 135.46 47.95 -30.35
EPS Growth(%) 15.75 66.65 31.51 -37.47 -71.08 -62.74 -6372.69 53.44 128.25 93.27 -11.77
Debt/Equity(x) 1.27 2.1 1.52 1.6 1.6 1.69 1.53 2.2 2 2.14 1.86
Current Ratio(x) 0.39 0.48 0.38 0.29 0.43 0.35 0.58 0.49 0.46 0.47 0.42
Quick Ratio(x) 0.39 0.48 0.37 0.29 0.43 0.35 0.58 0.49 0.45 0.47 0.42
Interest Cover(x) 2.34 3.37 2.5 1.81 1.35 0.84 -2.28 0.04 1.75 1.86 1.56
Total Debt/Mcap(x) 0.6 0.53 0.72 0.77 0.7 0.91 0.49 0.46 0.3 0.37 0.2

Bharti Airtel Shareholding Pattern

# Jun 2022 Sep 2022 Dec 2022 Mar 2023 Jun 2023 Sep 2023 Dec 2023 Mar 2024 Jun 2024 Sep 2024
Promoter 55.93 55.13 55.12 55.02 54.97 54.75 54.57 53.49 53.17 53.14
FII 18.54 21.87 21.7 20.98 21.48 21.87 22.68 24.35 24.62 25.08
DII 20.22 18.89 19.13 19.91 19.66 19.81 19.62 19.31 19.25 18.78
Public 5.31 4.1 4.04 4.09 3.88 3.58 3.13 2.85 2.95 3.01
Others 0 0 0 0 0 0 0 0 0 0
Total 100 100 100 100 100 100 100 100 100 100

Pros

  • Company has delivered good profit growth of 38% CAGR over last 5 years
  • Debtor days have improved from 3379.84 to 3120.12days.
  • Company has reduced debt.

Cons

  • Company has a low return on equity of 14% over the last 3 years.
  • Stock is trading at 11.1 times its book value.

* 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.

Bharti Airtel News

IPO

Companies Open Date Close Date Issue Price Cost of 1 Lot GMP Expected Listing Listing Gain(%) Listing Price Current Price Type Exchange

View more.....

Companies Open Date Close Date Issue Price Cost of 1 Lot GMP Expected Listing Listing Gain(%) Listing Price Current Price Type Exchange

View more.....

Companies Open Date Close Date Issue Price Cost of 1 Lot GMP Expected Listing Listing Gain(%) Listing Price Current Price Type Exchange

View more.....

Companies Open Date Close Date Issue Price Cost of 1 Lot GMP Expected Listing Listing Gain(%) Listing Price Current Price Type Exchange

View more.....

Companies Open Date Close Date Issue Price Cost of 1 Lot GMP Expected Listing Listing Gain(%) Listing Price Current Price Type Exchange

View more.....

You May Also Know About

Unlisted Shares Pre-IPO Shares ESOP Shares Delisted Shares

Please Login!

Click to Login
OR
Get free Account

Error!