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

16 Apr
1216.45
(-0.66%)
15 Apr
1224.55
(-0.08%)
12 Apr
1225.55
(-0.31%)
10 Apr
1229.40
(2.07%)
09 Apr
1204.45
(-0.02%)
08 Apr
1204.70
(1.15%)
05 Apr
1191.00
(-1.31%)
04 Apr
1206.85
(-1.54%)
03 Apr
1225.70
(1.44%)
02 Apr
1208.25
(-0.75%)
01 Apr
1217.35
(-0.92%)
28 Mar
1228.60
(0.31%)
27 Mar
1224.80
(0.96%)
26 Mar
1213.10
(-1.86%)
22 Mar
1236.10
(1.25%)
21 Mar
1220.80
(-0.89%)
20 Mar
1231.80
(0.28%)
19 Mar
1228.35
(0.25%)
18 Mar
1225.30
(0.43%)
15 Mar
1220.00
(2.13%)
14 Mar
1194.60
(2.21%)


Technical Analysis

Short Term Investors

Neutral

Medium Term Investors

Bullish

Long Term Investors

Very Bullish

Moving Averages

5 DMA
Bearish

1220.02


10 DMA
Bullish

1213.66


20 DMA
Bearish

1219.35


50 DMA
Bullish

1173.51


100 DMA
Bullish

1109.15


200 DMA
Bullish

1005.48



Intraday Support and Resistance
(Based on Pivot Points) |

Updated On Apr 16, 2024 04:00 PM For Next Trading Session

Pivots Classic Fibonacci Camarilla Woodie DM
R3 1251.49 1242.72 1222.47 - -
R2 1242.72 1234.35 1220.47 1241.63 -
R1 1229.59 1229.19 1218.46 1227.41 1236.15
P 1220.82 1220.82 1220.82 1219.73 1224.1
S1 1207.69 1212.45 1214.44 1205.51 1214.25
S2 1198.92 1207.29 1212.44 1197.83 -
S3 1185.79 1198.92 1210.43 - -

Key Metrics

EPS

9.4

P/E

129.44

P/B

8.25

Dividend Yield

0.31%

Market Cap

7,22,244 Cr.

Face Value

5

Book Value

147.47

ROE

17.04%

EBITDA Growth

20,826.6 Cr.

Debt/Equity

2.75

Shareholding Pattern

  54.57% Total Promoter Holding
11.29% Mutual Fund Holdings
22.68% FIIs
3.04% Non Institution
6.69% Insurance Companies
0.06% Custodians
1.67% Other Parties

Shareholding History


Quarterly Result (Figures in Rs. Crores)


Bharti Airtel Ltd Quaterly Results


Dec 2022Mar 2023Jun 2023Sep 2023Dec 2023
INCOME 36062 36894.9 38378.2 37960.2 39042.5
PROFIT 2062.72 3005.6 4096.4 2175.02 2533.36
EPS 2.81 5.3 2.84 2.36 4.27

Bharti Airtel Ltd Quaterly Results


Dec 2022Mar 2023Jun 2023Sep 2023Dec 2023
INCOME 21945.1 21966.6 22835.5 23685 24224.3
PROFIT 712.3 1354.2 1456.9 914.1 1604.04
EPS -5.69 2.39 2.57 0.51 2.47

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