Bharti Airtel Ltd

NSE :BHARTIARTL   BSE :532454  Sector : Telecomm-Service
Buy, Sell or Hold BHARTIARTL? Ask The Analyst

BSE


prev close

OPEN PRICE

bid price (qty)

offer price (qty)

volume

Today's low / high

52 WK low / high

NSE


prev close

open price

bid price (qty)

offer price (qty)

volume

Today's' low / high

52 WK low / high

18 May
1347.75
(0.25%)
17 May
1344.45
(-0.05%)
16 May
1345.10
(2.69%)
15 May
1309.90
(1.99%)
14 May
1284.30
(-0.13%)
13 May
1285.95
(-1.17%)
10 May
1301.15
(2.01%)
09 May
1275.45
(-1.02%)
08 May
1288.60
(0.19%)
07 May
1286.15
(0.21%)
06 May
1283.40
(0.47%)
03 May
1277.40
(-2.04%)
02 May
1304.05
(-1.38%)
30 Apr
1322.30
(-0.76%)
29 Apr
1332.45
(0.49%)
26 Apr
1326.00
(-0.95%)
25 Apr
1338.70
(0.17%)
24 Apr
1336.40
(-0.44%)
23 Apr
1342.35
(3.45%)
22 Apr
1297.55
(0.66%)
19 Apr
1289.00
(1.84%)


Technical Analysis

Short Term Investors

Very Bullish

Medium Term Investors

Very Bullish

Long Term Investors

Very Bullish

Moving Averages

5 DMA
Bullish

1326.88


10 DMA
Bullish

1307.27


20 DMA
Bullish

1311.68


50 DMA
Bullish

1252.77


100 DMA
Bullish

1177.96


200 DMA
Bullish

1052.65



Intraday Support and Resistance
(Based on Pivot Points) |

Updated On May 18, 2024 04:00 PM For Next Trading Session

Pivots Classic Fibonacci Camarilla Woodie DM
R3 1361.56 1356.28 1350.38 - -
R2 1356.28 1352.63 1349.5 1356.54 -
R1 1352.01 1350.38 1348.63 1352.53 1354.15
P 1346.73 1346.73 1346.73 1346.99 1347.8
S1 1342.46 1343.08 1346.87 1342.98 1344.6
S2 1337.18 1340.83 1346 1337.44 -
S3 1332.91 1337.18 1345.12 - -

Key Metrics

EPS

10.37

P/E

130.01

P/B

7.52

Dividend Yield

0.57%

Market Cap

8,02,210 Cr.

Face Value

5

Book Value

179.38

ROE

17.04%

EBITDA Growth

18,055.5 Cr.

Debt/Equity

2.75

Shareholding Pattern

  53.49% Total Promoter Holding
11.05% Mutual Fund Holdings
24.35% FIIs
2.76% Non Institution
6.63% Insurance Companies
0.05% Custodians
1.67% Other Parties

Shareholding History


Quarterly Result (Figures in Rs. Crores)


Bharti Airtel Ltd Quaterly Results


Mar 2023Jun 2023Sep 2023Dec 2023Mar 2024
INCOME 36894.9 38378.2 37960.2 39042.5 38746.3
PROFIT 3005.6 4096.4 2175.02 2533.36 3899.7
EPS 5.3 2.84 2.36 4.27 3.61

Bharti Airtel Ltd Quaterly Results


Mar 2023Jun 2023Sep 2023Dec 2023Mar 2024
INCOME 21966.6 22835.5 23685 24224.3 24944
PROFIT 1354.2 1456.9 914.1 1604.04 1682.98
EPS 2.39 2.57 0.51 2.47 3.18

Profit & Loss (Figures in Rs. Crores)


Bharti Airtel Ltd Profit & Loss


Mar 2014Mar 2015Mar 2016Mar 2017Mar 2018Mar 2019Mar 2020Mar 2021Mar 2022Mar 2023
INCOME 88320.4 98691.3 103168.9 99662.8 85655.2 86245.2 90598.3 112386.1 122048.4 140833.5
PROFIT 2609.05 4510.62 4965.08 4431.19 1385.31 -377.2 5785.71 9811.6 3124.8 8842.87
EPS 6.53 10.21 15.53 9.56 4.92 3.8 -55.17 -22.1 14.86 21.66

Bharti Airtel Ltd Profit & Loss


Mar 2014Mar 2015Mar 2016Mar 2017Mar 2018Mar 2019Mar 2020Mar 2021Mar 2022Mar 2023
INCOME 50790.2 60753.2 62044 64802.7 54740.3 55522.6 58113.6 66729.9 73073.6 87353.9
PROFIT 6591.06 10491.07 8369.34 3967.74 740.07 935.7 5579.2 -15742.28 -1960.3 -405
EPS 14.88 29.75 17.54 0 0.18 -4.22 -64.93 -45.03 -6.91 -0.16

Balance Sheet (Figures in Rs. Crores)

Mar 2023Mar 2022Mar 2021Mar 2020Mar 2019Mar 2018Mar 2017Mar 2016Mar 2015Mar 2014
SOURCES OF FUNDS :
Share Capital 2,836.62,7952,7462,727.81,998.71,998.71,998.71,998.71,998.71,998.7
Reserves Total 74,545.463,560.656,007.474,141.669,423.567,599.965,494.364,82337,778.357,757.3
Equity Application Money180.9198.7199.3275.40-64.2-36.7-52.400
Total Shareholders Funds77,562.966,554.358,952.777,144.871,422.269,534.467,456.366,769.339,77759,756
Minority Interest28,881.425,380.722,273.924,984.713,525.88,813.96,8755,498.16,890.64,210.2
Secured Loans 351.6379.6366.928.1307.12,192.51,203.84,397.710,495.211,586.9
Unsecured Loans 2,25,668.71,69,298.31,62,418.31,48,2001,25,121.21,09,1411,06,083.896,248.872,919.964,308.9
Total Debt2,26,020.31,69,677.91,62,785.21,48,228.11,25,428.31,11,333.51,07,287.61,00,646.583,415.175,895.8
Other Liabilities13,750.812,65515,885.710,027.28,819.57,990.84,8944,274.86,188.95,729.1
Total Liabilities3,46,215.42,74,267.92,59,897.52,60,384.82,19,195.81,97,672.61,86,512.91,77,188.71,36,271.61,45,591.1
APPLICATION OF FUNDS :
Gross Block 4,77,253.84,21,248.93,82,104.33,79,905.53,28,441.12,94,267.62,71,518.22,59,900.52,08,310.32,10,195.5
Less: Accumulated Depreciation1,99,8601,77,165.61,58,624.71,50,6501,27,609.61,07,067.293,283.187,34484,031.769,317.3
Less: Impairment of Assets0000000263.70263.7
Net Block2,77,393.82,44,083.32,23,479.62,29,255.52,00,831.51,87,200.41,78,235.11,72,292.81,24,278.61,40,614.5
Capital Work in Progress49,425.45,954.75,726.54,282.39,634.29,751.210,838.55,70217,414.80
Investments 32,953.929,349.127,550.425,476.515,71116,158.614,338.711,97710,75215,530.8
Inventories 257.6375266156.988.469.348.8169.2133.9142.2
Sundry Debtors 3,981.54,056.23,637.74,605.84,300.65,8834,740.25,503.95,207.26,244.1
Cash and Bank Balance13,418.613,494.313,466.115,892.78,0646,670.65,098.35,098.72,083.14,980.8
Loans and Advances 35,139.133,24133,30542,219.915,78813,978.36,624.210,467.56,481.64,792.1
Total Current Assets52,796.851,166.550,674.862,875.328,24126,601.216,511.521,239.313,905.816,159.2
Current Liabilities 70,815.260,521.959,483.752,245.353,337.650,504.244,46443,936.141,567.435,728.6
Provisions 27,526.426,417.425,035.946,461.21,492.91,344.21,345.43,347.22,036172.5
Total Current Liabilities & Provisions98,341.686,939.384,519.698,706.554,830.551,848.445,809.447,283.343,603.435,901.1
Net Current Assets-45,544.8-35,772.8-33,844.8-35,831.2-26,589.5-25,247.2-29,297.9-26,044-29,697.6-19,741.9
Deferred Tax Assets23,497.624,463.824,090.332,507.117,970.311,825.79,561.78,790.62,360.46,262.7
Deferred Tax Liability6,621.96,987.65,614.67,178.810,162.19,953.37,885.15,3684,424.41,685
Net Deferred Tax16,875.717,476.218,475.725,328.37,808.21,872.41,676.63,422.6-2,0644,577.7
Other Assets15,111.413,177.418,510.111,873.411,800.47,937.210,721.99,838.315,587.84,610
Total Assets3,46,215.42,74,267.92,59,897.52,60,384.82,19,195.81,97,672.61,86,512.91,77,188.71,36,271.61,45,591.1
Contingent Liabilities14,958.913,887.79,927.413,967.616,558.712,626.313,48220,823.620,573.814,183.6
Mar 2023Mar 2022Mar 2021Mar 2020Mar 2019Mar 2018Mar 2017Mar 2016Mar 2015Mar 2014
SOURCES OF FUNDS :
Share Capital 2,836.62,7952,7462,727.81,998.71,998.71,998.71,998.71,998.71,998.7
Reserves Total 75,802.671,721.374,259.998,347.296,307.21,00,862.299,208.61,09,730.476,274.264,729.3
Equity Application Money354.2354.2354.2354.2000000
Total Shareholders Funds78,993.474,870.577,360.11,01,429.298,305.91,02,860.91,01,207.31,11,729.178,272.966,728
Secured Loans 0000.112.93.121.91.4
Unsecured Loans 1,81,696.31,29,9051,30,407.41,18,800.483,788.965,412.960,091.645,568.721,567.810,364
Total Debt1,81,696.31,29,9051,30,407.41,18,800.583,789.965,415.860,094.745,570.721,569.710,365.4
Other Liabilities6,971.95,431.89,040.24,557.35,288.43,967.94,271.83,994.34,400.54,148.9
Total Liabilities2,67,661.62,10,207.32,16,807.72,24,7871,87,384.21,72,244.61,65,573.81,61,294.11,04,243.181,242.3
APPLICATION OF FUNDS :
Gross Block 3,43,0893,01,755.82,74,7482,65,4762,23,971.11,98,828.11,76,461.31,45,668.71,00,08779,574.3
Less : Accumulated Depreciation 1,55,679.91,38,020.11,17,359.61,03,796.790,159.276,218.764,938.553,743.246,642.639,696.1
Net Block 1,87,409.11,63,735.71,57,388.41,61,679.31,33,811.91,22,609.41,11,522.891,925.553,444.439,878.2
Capital Work in Progress40,555.73,385.71,306.31,258.75,636.55,542.79,600.23,830.39,066.91,244.2
Investments 46,699.546,72652,27338,726.837,579.848,128.245,95969,983.143,116.934,523.9
Inventories 00.40.83.116.33.95.39.41.1
Sundry Debtors 2,116.52,771.73,178.23,8103,840.34,319.63,211.83,172.43,3112,165.5
Cash and Bank Balance1,443341.41,036.53,397.6235.3545.1173.446.6388.7446
Loans and Advances 33,497.629,380.332,112.142,895.613,768.710,959.213,293.98,149.76,326.23,637.1
Total Current Assets37,057.132,493.836,327.650,106.317,845.315,830.216,68311,37410,035.36,249.7
Current Liabilities 46,62240,098.540,741.334,60035,189.732,321.825,546.222,830.619,873.615,069
Provisions 21,293.620,93520,198.140,985.8333.6370.9517.6903.31,234.9945.3
Total Current Liabilities & Provisions67,915.661,033.560,939.475,585.835,523.332,692.726,063.823,733.921,108.516,014.3
Net Current Assets-30,858.5-28,539.7-24,611.8-25,479.5-17,678-16,862.5-9,380.8-12,359.9-11,073.2-9,764.6
Deferred Tax Assets14,643.916,017.520,114.528,647.514,355.110,720.58,538.27,714.61,911.81,631.5
Deferred Tax Liability004,275.95,946.19,374.89,296.17,657.45,407.62,983.92,579
Net Deferred Tax14,643.916,017.515,838.622,701.44,980.31,424.4880.82,307-1,072.1-947.5
Other Assets9,211.98,882.114,613.225,900.323,053.711,402.46,991.85,608.110,760.216,308.1
Total Assets2,67,661.62,10,207.32,16,807.72,24,7871,87,384.21,72,244.61,65,573.81,61,294.11,04,243.181,242.3
Contingent Liabilities48,420.348,671.279,783.49,05613,668.78,245.68,095.75,181.51,00,767.887,232.1

Cash Flow (Figures in Rs. Crores)

Net Profit before Tax and Extr...16,560.7
Depreciation36,431.8
Interest (Net)18,535.4
Dividend Received1,399.2
P/L on Sales of Assets2.2
Prov. and W/O (Net)566.4
Others-504.1
Total Adjustments (PBT and Ext...55,667.4
Operating Profit before Workin...72,228.1
Trade and 0ther Receivables-558.3
Inventories-115.7
Trade Payables1,267.1
Total Adjustments (OP before W...-3,112
Cash Generated from/(used in) ...69,116.1
Direct Taxes Paid-3,791.5
Total Adjustments(Cash Generat...-3,791.5
Cash Flow before Extraordinary...65,324.6
Net Cash from Operating Activi...65,324.6
Purchased of Fixed Assets-26,538.5
Sale of Fixed Assets88.5
Purchase of Investments-1,232.3
Sale of Investments31.1
Interest Received350.8
Investment in Group Cos.-810.6
Net Cash used in Investing Act...-39,232.4
Proceeds from Issue of shares ...5,224.5
Proceed from 0ther Long Term B...13,607.7
Of the Long Tem Borrowings-17,822.7
Of the Short Term Borrowings-7,097.2
Of Financial Liabilities-7,598.6
Dividend Paid-3,589.8
Interest Paid-6,689.3
Net Cash used in Financing Act...-24,469.5
Net Profit before Tax and Extr...1,269.3
Depreciation26,355
Interest (Net)14,147.4
Dividend Received1,518.1
P/L on Sales of Assets-6.1
Prov. and W/O (Net)274.1
Total Adjustments (PBT and Ext...43,155.6
Operating Profit before Workin...44,424.9
Trade and 0ther Receivables373.8
Inventories-2
Trade Payables-1,103.3
Total Adjustments (OP before W...-653.3
Cash Generated from/(used in) ...43,771.6
Direct Taxes Paid-189
Total Adjustments(Cash Generat...-189
Cash Flow before Extraordinary...43,582.6
Net Cash from Operating Activi...43,582.6
Purchased of Fixed Assets-24,768.8
Sale of Fixed Assets82.7
Purchase of Investments-2,549.1
Interest Received118
Loans to Subsidiaires-4,790.8
Acquisition of Companies-1,183.2
Net Cash used in Investing Act...-30,006.3
Proceeds from Issue of shares ...5,224.5
Proceed from 0ther Long Term B...5,738.3
Of the Long Tem Borrowings-6,812.4
Of the Short Term Borrowings-6,950.1
Of Financial Liabilities-4,449.9
Dividend Paid-1,763
Interest Paid-3,487.8
Net Cash used in Financing Act...-12,500.4

Company Details

Registered Office
AddressAirtel center Plot No 16,
Udyog Vihar Phase IV
CityGurgaon
StateHaryana
Pin Code122015
Tel. No.91-124-4222222
Fax. No.91-124-4248063
Emailcompliance.officer@bharti.in
Internethttp://www.airtel.in
Registrars
AddressAirtel center Plot No 16
CityGurgaon
StateHaryana
Pin Code122015
Tel. No.91-124-4222222
Fax. No.91-124-4248063
Emailcompliance.officer@bharti.in
Internethttp://www.airtel.in
Management
Name Designation
Sunil B MittalChairman & Executive Director & CFO
Chua Sock KoongNon-Exec & Non-Independent Dir
Gopal VittalManaging Director & CEO
Dinesh Kumar MittalNon-Exec. & Independent Dir.
Rakesh Bharti MittalNon-Exec & Non-Independent Dir
Pankaj TewariCompany Sec. & Compli. Officer
Kimsuka NarasimhanNon-Exec. & Independent Dir.
Tao Yih Arthur LangNon-Exec & Non-Independent Dir
NISABA ADI GODREJNon-Exec. & Independent Dir.
Pradeep Kumar SinhaIndependent Director
Shyamal MukherjeeIndependent Director