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

Bharti Airtel

₹1599.5 15.3 | 1%

Market Cap ₹973795 Cr.

Stock P/E 113.8

P/B 9.4

Current Price ₹1599.5

Book Value ₹ 170.4

Face Value 5

52W High ₹1779

Dividend Yield 0.5%

52W Low ₹ 998.5

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

Show Value Show %

Bharti Airtel Quarterly Results

#(Fig in Cr.)
Net Sales
Other Income
Total Income
Total Expenditure
Operating Profit
Interest
Depreciation
Exceptional Income / Expenses
Profit Before Tax
Provision for Tax
Profit After Tax
Adjustments
Profit After Adjustments
Adjusted Earnings Per Share

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 49919 55496 60300 62276 53663 49606 54317 64326 70795 84720 94120
Other Income 853 5193 1744 2526 1077 4102 2243 2892 604 2634 1902
Total Income 50772 60689 62044 64803 54740 53708 56560 67218 71399 87354 96022
Total Expenditure 33620 36065 37989 38583 35858 38789 34184 36342 36095 40921 44116
Operating Profit 17152 24624 24055 26219 18882 14919 22376 30876 35305 46433 51906
Interest 1336 1409 3545 5255 5911 7848 11463 12321 13221 14532 14405
Depreciation 7231 7560 9575 12203 13049 15120 20392 21998 24330 26355 29109
Exceptional Income / Expenses -207 0 -680 -17271 -604 2805 -41542 -15023 -2010 -4276 -1276
Profit Before Tax 8377 15655 10254 -8510 -681 -5244 -51021 -18465 -4256 1269 7116
Provision for Tax 1777 2455 2474 1416 -760 -3375 -14933 6732 -392 1359 2128
Profit After Tax 6600 13201 7780 -9926 79 -1869 -36088 -25198 -3864 -90 4988
Adjustments 0 0 0 0 0 0 0 0 0 0 0
Profit After Adjustments 6600 13201 7780 -9926 79 -1869 -36088 -25198 -3864 -90 4988
Adjusted Earnings Per Share 14.9 29.7 17.5 -22.4 0.2 -4.2 -64.9 -45 -6.9 -0.2 8.7

Growth Rates

# 1 Year 3 Year 5 Year 10 Year
Sales CAGR 11% 14% 14% 7%
Operating Profit CAGR 12% 19% 28% 12%
PAT CAGR 0% 0% 0% -3%
# 1 Year 3 Year 5 Year 10 Year
Share Price CAGR 60% 33% 29% 17%
ROE Average 6% 0% -13% -3%
ROCE Average 10% 8% -1% 4%

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 66728 78273 111729 101207 102861 98306 101429 77360 74871 78993 100862
Minority's Interest 0 0 0 0 0 0 0 0 0 0 0
Borrowings 7272 19627 41457 50342 54468 58612 70471 89909 97323 136230 119500
Other Non-Current Liabilities 5096 5473 1688 3391 2544 308 12581 23200 6849 27465 30167
Total Current Liabilities 29995 37028 27913 35816 43640 60701 93211 71439 76181 78245 88291
Total Liabilities 109091 140400 182787 190757 203513 217927 277692 261909 255223 320933 338820
Fixed Assets 39878 53444 91926 111523 122609 133812 161679 157388 163736 187409 221717
Other Non-Current Assets 51587 58223 79375 62530 65073 64601 57232 64448 58196 92947 79068
Total Current Assets 17626 28732 11487 15331 15830 19515 58781 40072 33291 40577 38034
Total Assets 109091 140400 182787 190757 203513 217927 277692 261909 255223 320933 338820

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 328 446 385 -256 82 417 171 3040 1014 310 1386
Cash Flow from Operating Activities 16022 17940 19450 21166 15954 10812 4026 34392 36754 43583 53209
Cash Flow from Investing Activities -17086 -12801 -21989 -24283 -17211 -20456 -22272 -13223 -33170 -30006 -34877
Cash Flow from Financing Activities 1182 -5196 1898 3456 1637 9398 21114 -23218 -4289 -12500 -19184
Net Cash Inflow / Outflow 118 -57 -641 338 380 -246 2869 -2049 -704 1076 -852
Closing Cash & Cash Equivalent 446 389 -256 82 463 171 3040 991 310 1386 534

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) 14.87 29.74 17.53 -22.36 0.18 -4.21 -64.9 -45.02 -6.91 -0.16 8.67
CEPS(Rs) 31.16 46.78 39.11 5.13 29.58 29.86 -28.23 -5.72 36.61 46.3 59.27
DPS(Rs) 1.62 3.47 1.22 0.9 4.81 2.25 1.96 0 3 4 8
Book NAV/Share(Rs) 149.81 176.19 250.88 227.14 231.61 221.35 182.31 138.05 133.77 138.95 175
Core EBITDA Margin(%) 32.65 35.01 37 38.04 33.18 21.81 37.07 43.5 49.02 51.7 53.13
EBIT Margin(%) 19.46 30.75 22.89 -5.23 9.75 5.25 -72.83 -9.55 12.66 18.65 22.87
Pre Tax Margin(%) 16.78 28.21 17.01 -13.66 -1.27 -10.57 -93.93 -28.71 -6.01 1.5 7.56
PAT Margin (%) 13.22 23.79 12.9 -15.94 0.15 -3.77 -66.44 -39.17 -5.46 -0.11 5.3
Cash Profit Margin (%) 27.71 37.41 28.78 3.66 24.46 26.71 -28.9 -4.97 28.91 31 36.23
ROA(%) 6.4 10.58 4.81 -5.31 0.04 -0.89 -14.56 -9.34 -1.49 -0.03 1.51
ROE(%) 10.97 18.25 8.21 -9.36 0.08 -1.86 -36.16 -28.21 -5.08 -0.12 5.56
ROCE(%) 13.36 19.29 10.74 -2.04 3.17 1.49 -21.63 -3.46 5.06 7.86 9.64
Receivable days 16.13 18.01 19.62 18.71 25.61 30.02 25.7 19.83 15.34 10.53 8.95
Inventory Days 0.35 0.33 0.39 0.22 0.03 0.03 0.01 0.01 0 0 0
Payable days 0 0 0 0 0 0 0 0 0 0 0
PER(x) 19.31 11.93 18.03 0 2013.91 0 0 0 0 0 141.75
Price/Book(x) 1.92 2.01 1.26 1.39 1.55 1.35 2.37 3.68 5.65 5.39 7.02
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.75 3.22 3.08 3.21 4.18 4.37 5.88 5.87 7.48 6.66 8.84
EV/Core EBITDA(x) 8.01 7.25 7.72 7.62 11.88 14.52 14.27 12.23 15 12.15 16.04
Net Sales Growth(%) 10.07 11.17 8.66 3.28 -13.83 -7.56 9.5 18.43 10.06 19.67 11.1
EBIT Growth(%) 19.82 75.67 -19.13 -123.59 260.67 -50.21 -1619.23 84.47 245.9 76.25 36.2
PAT Growth(%) 29.51 100 -41.06 -227.57 100.8 -2460.1 -1830.68 30.18 84.67 97.68 5667.19
EPS Growth(%) 23.04 100 -41.06 -227.57 100.8 -2460.76 -1441 30.64 84.65 97.72 5591.01
Debt/Equity(x) 0.16 0.28 0.41 0.6 0.64 0.85 0.81 1.22 1.44 1.78 1.25
Current Ratio(x) 0.59 0.78 0.41 0.43 0.36 0.32 0.63 0.56 0.44 0.52 0.43
Quick Ratio(x) 0.59 0.77 0.41 0.43 0.36 0.32 0.63 0.56 0.44 0.52 0.43
Interest Cover(x) 7.27 12.11 3.89 -0.62 0.88 0.33 -3.45 -0.5 0.68 1.09 1.49
Total Debt/Mcap(x) 0.08 0.14 0.32 0.43 0.41 0.63 0.34 0.33 0.24 0.31 0.17

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 reduced debt.

Cons

  • Company has a low return on equity of 0% over the last 3 years.
  • Stock is trading at 9.4 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.....