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

19 Nov
1525.50
(-0.75%)
18 Nov
1537.00
(-0.87%)
14 Nov
1550.50
(0.00%)
13 Nov
1550.45
(-0.33%)
12 Nov
1555.65
(-0.31%)
11 Nov
1560.55
(-0.60%)
08 Nov
1569.90
(-0.37%)
07 Nov
1575.80
(-1.44%)
06 Nov
1598.80
(1.29%)
05 Nov
1578.40
(-0.81%)
04 Nov
1591.25
(-1.56%)
01 Nov
1616.45
(0.24%)
31 Oct
1612.60
(-1.27%)
30 Oct
1633.35
(-0.23%)
29 Oct
1637.10
(-1.58%)
28 Oct
1663.35
(-0.16%)
25 Oct
1666.00
(-0.74%)
24 Oct
1678.45
(-0.44%)
23 Oct
1685.80
(-0.38%)
22 Oct
1692.25
(-0.02%)
21 Oct
1692.55
(-0.90%)


Technical Analysis

Short Term Investors

Very Bearish

Medium Term Investors

Very Bearish

Long Term Investors

Bullish

Moving Averages

5 DMA
Bearish

1544.05


10 DMA
Bearish

1560.4


20 DMA
Bearish

1603.96


50 DMA
Bearish

1650


100 DMA
Bearish

1564.37


200 DMA
Bullish

1412.27



Intraday Support and Resistance
(Based on Pivot Points) |

Updated On Nov 19, 2024 04:00 PM For Next Trading Session

Pivots Classic Fibonacci Camarilla Woodie DM
R3 1587.94 1572.97 1536.14 - -
R2 1572.97 1558.19 1532.6 1570.78 -
R1 1549.24 1549.05 1529.05 1544.86 1561.1
P 1534.27 1534.27 1534.27 1532.08 1540.2
S1 1510.54 1519.49 1521.95 1506.16 1522.4
S2 1495.57 1510.35 1518.41 1493.38 -
S3 1471.84 1495.57 1514.86 - -

Key Metrics

EPS

13.26

P/E

115.08

P/B

8.4

Dividend Yield

0.5%

Market Cap

9,12,291 Cr.

Face Value

5

Book Value

181.75

ROE

17.11%

EBITDA Growth

22,320.1 Cr.

Debt/Equity

2.77

Shareholding Pattern

  53.14% Total Promoter Holding
10.71% Mutual Fund Holdings
25.08% FIIs
2.9% Non Institution
6.34% Insurance Companies
0.07% Custodians
1.76% Other Parties

Shareholding History


Quarterly Result (Figures in Rs. Crores)


Bharti Airtel Ltd Quaterly Results


Sep 2023Dec 2023Mar 2024Jun 2024Sep 2024
INCOME 37960.2 39042.5 38746.3 40516.6 42801.9
PROFIT 2175.02 2533.36 3899.7 3584.43 4194.44
EPS 2.36 4.27 3.61 7.21 6.21

Bharti Airtel Ltd Quaterly Results


Sep 2023Dec 2023Mar 2024Jun 2024Sep 2024
INCOME 23685 24224.3 24944 26089.3 27392.5
PROFIT 914.1 1604.04 1682.98 1747.87 2517.6
EPS 0.51 2.47 3.18 4.28 4.35

Profit & Loss (Figures in Rs. Crores)


Bharti Airtel Ltd Profit & Loss


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

Bharti Airtel Ltd Profit & Loss


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

Balance Sheet (Figures in Rs. Crores)

Mar 2024Mar 2023Mar 2022Mar 2021Mar 2020Mar 2019Mar 2018Mar 2017Mar 2016Mar 2015
SOURCES OF FUNDS :
Share Capital 2,876.62,836.62,7952,7462,727.81,998.71,998.71,998.71,998.71,998.7
Reserves Total 79,038.574,545.463,560.656,007.474,141.669,423.567,599.965,494.364,82337,778.3
Equity Application Money103.7180.9198.7199.3275.40-64.2-36.7-52.40
Total Shareholders Funds82,018.877,562.966,554.358,952.777,144.871,422.269,534.467,456.366,769.339,777
Minority Interest23,545.128,881.425,380.722,273.924,984.713,525.88,813.96,8755,498.16,890.6
Secured Loans 1,162.7359.8379.6366.928.1307.12,192.51,203.84,397.710,495.2
Unsecured Loans 2,14,429.62,25,660.51,69,298.31,62,418.31,48,2001,25,121.21,09,1411,06,083.896,248.872,919.9
Total Debt2,15,592.32,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.1
Other Liabilities12,897.813,750.812,65515,885.710,027.28,819.57,990.84,8944,274.86,188.9
Total Liabilities3,34,0543,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.6
APPLICATION OF FUNDS :
Gross Block 5,13,016.64,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.3
Less: Accumulated Depreciation2,09,713.51,99,8601,77,165.61,58,624.71,50,6501,27,609.61,07,067.293,283.187,34484,031.7
Less: Impairment of Assets00000000263.70
Net Block3,03,303.12,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.6
Capital Work in Progress16,904.149,425.45,954.75,726.54,282.39,634.29,751.210,838.55,70217,414.8
Investments 31,602.332,953.929,349.127,550.425,476.515,71116,158.614,338.711,97710,752
Inventories 363.9257.6375266156.988.469.348.8169.2133.9
Sundry Debtors 4,727.73,981.54,056.23,637.74,605.84,300.65,8834,740.25,503.95,207.2
Cash and Bank Balance16,339.913,418.613,494.313,466.115,892.78,0646,670.65,098.35,098.72,083.1
Loans and Advances 36,575.135,139.133,24133,30542,219.915,78813,978.36,624.210,467.56,481.6
Total Current Assets58,006.652,796.851,166.550,674.862,875.328,24126,601.216,511.521,239.313,905.8
Current Liabilities 76,333.970,815.260,521.959,483.752,245.353,337.650,504.244,46443,936.141,567.4
Provisions 31,631.327,526.426,417.425,035.946,461.21,492.91,344.21,345.43,347.22,036
Total Current Liabilities & Provisions1,07,965.298,341.686,939.384,519.698,706.554,830.551,848.445,809.447,283.343,603.4
Net Current Assets-49,958.6-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
Deferred Tax Assets22,721.223,497.624,463.824,090.332,507.117,970.311,825.79,561.78,790.62,360.4
Deferred Tax Liability5,990.26,621.96,987.65,614.67,178.810,162.19,953.37,885.15,3684,424.4
Net Deferred Tax16,73116,875.717,476.218,475.725,328.37,808.21,872.41,676.63,422.6-2,064
Other Assets15,472.115,111.413,177.418,510.111,873.411,800.47,937.210,721.99,838.315,587.8
Total Assets3,34,0543,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.6
Contingent Liabilities16,404.414,958.913,887.79,927.413,967.616,558.712,626.313,48220,823.620,573.8
Mar 2024Mar 2023Mar 2022Mar 2021Mar 2020Mar 2019Mar 2018Mar 2017Mar 2016Mar 2015
SOURCES OF FUNDS :
Share Capital 2,876.62,836.62,7952,7462,727.81,998.71,998.71,998.71,998.71,998.7
Reserves Total 97,631.175,802.671,721.374,259.998,347.296,307.21,00,862.299,208.61,09,730.476,274.2
Equity Application Money354.2354.2354.2354.2354.200000
Total Shareholders Funds1,00,861.978,993.474,870.577,360.11,01,429.298,305.91,02,860.91,01,207.31,11,729.178,272.9
Secured Loans 00000.112.93.121.9
Unsecured Loans 1,69,299.11,81,696.31,29,9051,30,407.41,18,800.483,788.965,412.960,091.645,568.721,567.8
Total Debt1,69,299.11,81,696.31,29,9051,30,407.41,18,800.583,789.965,415.860,094.745,570.721,569.7
Other Liabilities6,2706,971.95,431.89,040.24,557.35,288.43,967.94,271.83,994.34,400.5
Total Liabilities2,76,4312,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.1
APPLICATION OF FUNDS :
Gross Block 3,91,112.23,43,0893,01,755.82,74,7482,65,4762,23,971.11,98,828.11,76,461.31,45,668.71,00,087
Less : Accumulated Depreciation 1,69,394.81,55,679.91,38,020.11,17,359.61,03,796.790,159.276,218.764,938.553,743.246,642.6
Net Block 2,21,717.41,87,409.11,63,735.71,57,388.41,61,679.31,33,811.91,22,609.41,11,522.891,925.553,444.4
Capital Work in Progress12,011.740,555.73,385.71,306.31,258.75,636.55,542.79,600.23,830.39,066.9
Investments 57,647.146,699.546,72652,27338,726.837,579.848,128.245,95969,983.143,116.9
Inventories 000.40.83.116.33.95.39.4
Sundry Debtors 2,500.32,116.52,771.73,178.23,8103,840.34,319.63,211.83,172.43,311
Cash and Bank Balance740.81,443341.41,036.53,397.6235.3545.1173.446.6388.7
Loans and Advances 34,793.333,497.629,380.332,112.142,895.613,768.710,959.213,293.98,149.76,326.2
Total Current Assets38,034.437,057.132,493.836,327.650,106.317,845.315,830.216,68311,37410,035.3
Current Liabilities 50,832.546,62240,098.540,741.334,60035,189.732,321.825,546.222,830.619,873.6
Provisions 24,549.821,293.620,93520,198.140,985.8333.6370.9517.6903.31,234.9
Total Current Liabilities & Provisions75,382.367,915.661,033.560,939.475,585.835,523.332,692.726,063.823,733.921,108.5
Net Current Assets-37,347.9-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
Deferred Tax Assets12,993.814,643.916,017.520,114.528,647.514,355.110,720.58,538.27,714.61,911.8
Deferred Tax Liability0004,275.95,946.19,374.89,296.17,657.45,407.62,983.9
Net Deferred Tax12,993.814,643.916,017.515,838.622,701.44,980.31,424.4880.82,307-1,072.1
Other Assets9,408.99,211.98,882.114,613.225,900.323,053.711,402.46,991.85,608.110,760.2
Total Assets2,76,4312,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.1
Contingent Liabilities49,238.248,420.348,671.279,783.49,05613,668.78,245.68,095.75,181.51,00,767.8

Cash Flow (Figures in Rs. Crores)

Net Profit before Tax and Extr...12,679
Depreciation39,537.6
Interest (Net)21,284.4
Dividend Received107.2
P/L on Sales of Assets4.4
Prov. and W/O (Net)427.8
Others272.6
Total Adjustments (PBT and Ext...66,686.2
Operating Profit before Workin...79,365.2
Trade and 0ther Receivables-1,494.1
Inventories-77.1
Trade Payables639.8
Total Adjustments (OP before W...2,413.6
Cash Generated from/(used in) ...81,778.8
Direct Taxes Paid-2,880.6
Total Adjustments(Cash Generat...-2,880.6
Cash Flow before Extraordinary...78,898.2
Net Cash from Operating Activi...78,898.2
Purchased of Fixed Assets-40,051.5
Sale of Fixed Assets122.8
Purchase of Investments-30.4
Sale of Investments1,908.4
Interest Received567.1
Investment in Group Cos.-30
Acquisition of Companies-642.8
Net Cash used in Investing Act...-51,089
Proceeds from Issue of shares ...0.6
Proceed from 0ther Long Term B...6,712.3
Proceed from Short Tem Borrowi...1,551.6
On Redemption of Debenture-169.3
Of the Long Tem Borrowings-10,080.3
Of Financial Liabilities-7,855.2
Dividend Paid-4,184.5
Interest Paid-14,026.3
Net Cash used in Financing Act...-27,778.5
Net Profit before Tax and Extr...7,116.1
Depreciation29,108.5
Interest (Net)13,583.7
Dividend Received52.5
P/L on Sales of Assets0.7
Prov. and W/O (Net)253.5
Total Adjustments (PBT and Ext...44,198.3
Operating Profit before Workin...51,314.4
Trade and 0ther Receivables-618.7
Trade Payables809.4
Total Adjustments (OP before W...1,556.6
Cash Generated from/(used in) ...52,871
Direct Taxes Paid337.8
Total Adjustments(Cash Generat...337.8
Cash Flow before Extraordinary...53,208.8
Net Cash from Operating Activi...53,208.8
Purchased of Fixed Assets-38,604.6
Sale of Fixed Assets111.3
Purchase of Investments-23
Sale of Investments2,869.9
Interest Received764.4
Invest.In Subsidiaires-14,457.8
Loans to Subsidiaires-2,011.6
Cancellation of Investment in ...14,440.2
Acquisition of Companies-30
Net Cash used in Investing Act...-34,876.8
Proceeds from Issue of shares ...0.6
Proceed from 0ther Long Term B...307.7
Proceed from Short Tem Borrowi...1,457.6
Of the Long Tem Borrowings-4,030
Of Financial Liabilities-4,662
Dividend Paid-2,276.3
Interest Paid-9,981.3
Net Cash used in Financing Act...-19,183.7

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
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.
Shyamal MukherjeeIndependent Director
Arjan Kumar SikriIndependent Director
Doug BaillieIndependent Director