Adani Ports

392.25down-arrow17.10

Asian Paints

2207.9down-arrow21.65

Axis Bank

619.65down-arrow24.05

B P C L

389.75down-arrow-4.70

Bajaj Auto

3095.7down-arrow17.95

Bajaj Finance

4810.65down-arrow-0.80

Bajaj Finserv

8859.7down-arrow85.35

Bharti Airtel

474.25down-arrow-3.00

Britannia Inds.

3562.25down-arrow4.85

Cipla

748.45down-arrow2.15

Coal India

123.25down-arrow0.50

Divi's Lab.

3537.05down-arrow-9.25

Dr Reddy's Labs

4915.5down-arrow86.75

Eicher Motors

2693.3down-arrow95.95

GAIL (India)

100.3down-arrow-0.60

Grasim Inds

853.25down-arrow-1.35

H D F C

2217.7down-arrow-33.10

HCL Technologies

840.5down-arrow1.30

HDFC Bank

1438.2down-arrow43.60

HDFC Life Insur.

664.15down-arrow2.85

Hero Motocorp

3074.15down-arrow14.40

Hind. Unilever

2157.35down-arrow27.95

Hindalco Inds.

226down-arrow7.95

I O C L

86.15down-arrow-0.30

ICICI Bank

478.2down-arrow9.95

IndusInd Bank

853.7down-arrow3.95

Infosys

1140.05down-arrow0.20

ITC

195.55down-arrow4.70

JSW Steel

340.85down-arrow3.10

Kotak Mah. Bank

1924.9down-arrow27.05

Larsen & Toubro

1135.5down-arrow9.65

M & M

729.35down-arrow23.90

Maruti Suzuki

7158.4down-arrow170.65

Nestle India

17677.6down-arrow-108.80

NTPC

94.15down-arrow0.50

O N G C

76.1down-arrow-0.40

Power Grid Corpn

194.5down-arrow-0.25

Reliance Industr

1964.05down-arrow13.35

SBI Life Insuran

838.95down-arrow7.35

Shree Cement

24243.55down-arrow-221.75

St Bk of India

243.85down-arrow5.15

Sun Pharma.Inds.

520.15down-arrow7.30

Tata Motors

172.05down-arrow1.35

Tata Steel

548.3down-arrow5.20

TCS

2722.05down-arrow-2.20

Tech Mahindra

877.65down-arrow11.90

Titan Company

1327.15down-arrow-20.45

UltraTech Cem.

4873.2down-arrow-16.30

UPL

427.45down-arrow1.00

Wipro

355.5down-arrow-0.35

CORPORATE INFORMATION   
Bharti Airtel Ltd
Industry :  Telecommunications - Service Provider
BSE Code
ISIN Demat
Book Value()
532454
INE397D01024
152.2128231
NSE Symbol
P/E(TTM)
Mar.Cap( Cr.)
BHARTIARTL
0
258675.25
EPS(TTM)
Face Value()
Div & Yield %
0
5
0.42
Detailed Quotes
BSE NSE
Last Price() 474.15 arrowDown
Nov 24,2020 EOD
474.25 arrowDown
Nov 24,2020 EOD
Today's Change( ) -2.90 (-0.61%) arrowDown -3.00 (-0.63%) arrowDown
Open( ) 480.00 478.40
Prev Close( ) 477.05 477.25
Volume 242,879.00 9,173,967.00
Today's Range( ) 481.35 - 471.45 481.25 - 471.20
52-Week Range( ) 611.70 - 381.05 612.00 - 361.75
Buy (Size) N.A 474.25(×674)
Sell (Size) N.A N.A
Company Background
Incorporation Year 1995
Registered Office Bharti Airtel Limited,1 Nelson Mandela Road Phase II,
New Delhi,
New Delhi-110070
Telephone 91-11-46666100
Fax 91-11-46666137
Chairman Sunil B Mittal
Managing Director Gopal Vittal
Company Secretary Pankaj Tewari
Auditor Deloitte Haskins & Sells LLP/ANB & Co
Face Value 5
Market Lot 1
Listing BSE,MSEI ,NSEBSE,MSEI ,NSE
Registrar KFin Techologies Pvt Ltd
Karvy Selenium Tow-B,31&32 Financial Dist,Nanakramguda ,Hyderabad-500032
Board of Directors
Chairman Sunil B Mittal
Director Chua Sock Koong
Independent Director Craig Edward Ehrlich
Manish Kejriwal
Managing Director Gopal Vittal
Independent Director V K Viswanathan
Dinesh Kumar Mittal
Shishir Priyadarshi
Director Rakesh Bharti Mittal
Company Secretary Pankaj Tewari
Addtnl Independent Director Kimsuka Narasimhan
Additional Director Tao Yih Arthur Lang
Balance Sheet
Particulars (Sources Of Funds)Mar 2020
( Cr)
Mar 2019
( Cr)
Mar 2018
( Cr)
Mar 2017
( Cr)
Mar 2016
( Cr)
Mar 2015
( Cr)
Share Capital 2727.801998.701998.701998.701998.701998.70
Reserves Total 98701.4096307.20100862.2099208.60109730.4076274.20
Equity Share Warrants0.000.000.000.000.000.00
Equity Application Money0.000.000.000.000.000.00
Total Shareholders Funds101429.2098305.90102860.90101207.30111729.1078272.90
Secured Loans 0.101.002.903.102.001.90
Unsecured Loans 118800.4083788.9065412.9060091.6045568.7021567.80
Total Debt118800.5083789.9065415.8060094.7045570.7021569.70
Other Liabilities4557.305288.403967.904271.803994.304400.50
Total Liabilities224787.00187384.20172244.60165573.80161294.10104243.10
APPLICATION OF FUNDS :
Gross Block 265476.00223971.10198828.10176461.30145668.70100087.00
Less : Accumulated Depreciation 103796.7090159.2076218.7064938.5053743.2046642.60
Less:Impairment of Assets0.000.000.000.000.000.00
Net Block 161679.30133811.90122609.40111522.8091925.5053444.40
Lease Adjustment0.000.000.000.000.000.00
Capital Work in Progress1258.705636.505542.709600.203830.309066.90
Producing Properties0.000.000.000.000.000.00
Investments 38726.8037579.8048128.2045959.0069983.1043116.90
Current Assets, Loans & Advances
Inventories 3.101.006.303.905.309.40
Sundry Debtors 3810.003840.304319.603211.803172.403311.00
Cash and Bank Balance3397.60235.30545.10173.4046.60388.70
Loans and Advances 42895.6013768.7010959.2013293.908149.706326.20
Total Current Assets50106.3017845.3015830.2016683.0011374.0010035.30
Less : Current Liabilities and Provisions
Current Liabilities 34600.0035189.7032321.8025546.2022830.6019873.60
Provisions 40985.80333.60370.90517.60903.301234.90
Total Current Liabilities & Provisions75585.8035523.3032692.7026063.8023733.9021108.50
Net Current Assets-25479.50-17678.00-16862.50-9380.80-12359.90-11073.20
Miscellaneous Expenses not written off 0.000.000.000.000.000.00
Deferred Tax Assets28647.5014355.1010720.508538.207714.601911.80
Deferred Tax Liability5946.109374.809296.107657.405407.602983.90
Net Deferred Tax22701.404980.301424.40880.802307.00-1072.10
Other Assets25900.3023053.7011402.406991.805608.1010760.20
Total Assets224787.00187384.20172244.60165573.80161294.10104243.10
Contingent Liabilities9056.0013668.708245.608095.705181.50100767.80
Profit and Loss
Particulars(INCOME)Mar 2020
( Cr)
Mar 2019
( Cr)
Mar 2018
( Cr)
Mar 2017
( Cr)
Mar 2016
( Cr)
Mar 2015
( Cr)
Sales Turnover 54317.1049606.0053663.0062276.3060300.3055496.40
Excise Duty0.000.000.000.000.000.00
Net Sales54317.1049606.0053663.0062276.3060300.3055496.40
Other Income 3796.505916.601077.302526.401743.705193.00
Stock Adjustments 0.000.000.000.000.0063.80
Total Income58113.6055522.6054740.3064802.7062044.0060753.20
EXPENDITURE :
Raw Materials 0.000.000.000.000.0071.40
Power & Fuel Cost6165.705556.004564.704552.605758.904115.10
Employee Cost 1520.201471.001720.901738.501864.801691.50
Other Manufacturing Expenses 22393.0024528.7023441.4025574.7023054.6018003.70
Selling & Administrative Expenses 2580.403371.703782.404142.004677.8011211.10
Miscellaneous Expenses 44620.002871.202952.8019846.403312.901036.30
Less : Pre-operative Expenses Capitalised 0.000.000.000.000.000.00
Total Expenditure77279.3037798.6036462.2055854.2038669.0036129.10
Operating Profit-19165.7017724.0018278.108948.5023375.0024624.10
Interest 11463.107847.705910.705254.603545.301409.10
Gross Profit-30628.809876.3012367.403693.9019829.7023215.00
Depreciation20392.1015120.2013048.6012203.409575.307559.70
Profit Before Tax-51020.90-5243.90-681.20-8509.5010254.4015655.30
Tax0.001.50-220.40-4.502055.802330.20
Fringe Benefit tax0.000.000.000.000.000.00
Deferred Tax-14932.70-3376.20-540.001420.60418.30124.60
Reported Net Profit-36088.20-1869.2079.20-9925.607780.3013200.50
Extraordinary Items -41541.80-2804.90-660.87-13893.34-589.042709.43
Adjusted Net Profit5453.60935.70740.073967.748369.3410491.07
Adjustment below Net Profit -2000.80-1205.503089.30-74.50-945.90-41.10
P & L Balance brought forward79474.6084548.1082927.8093473.5087526.3048496.50
Statutory Appropriations0.000.000.000.000.000.00
Appropriations 0.001998.801535.00545.60887.201597.60
P & L Balance carried down41385.6079474.6084561.3082927.8093473.5060058.30
Dividend0.000.002134.65399.70887.201539.00
Preference Dividend0.000.000.000.000.000.00
Equity Dividend %40.0050.00106.8020.0027.2077.00
Dividend Per Share(Rs)2.002.505.341.001.363.85
Earnings Per Share-Unit Curr0.000.000.200.0019.4633.02
Earnings Per Share(Adj)-Unit Curr0.000.000.180.0017.8630.31
Book Value-Unit Curr185.92245.92257.32253.18279.50195.80
Book Value(Adj)-Unit Curr185.92225.75236.22232.42256.58179.74
Quarterly Results
 
Quarters
ParticularsSep 2020 ( Cr)Jun 2020 ( Cr)Mar 2020 ( Cr)
Gross Sales16011.4015049.2014991.40
Other Operating Income0.000.000.00
Other Income 386.70610.90735.20
Total Income16398.1015660.1015726.60
Total Expenditure 9206.3020495.3016840.10
PBIDT7191.80-4835.20-1113.50
Interest 2868.802791.603759.90
PBDT4323.00-7626.80-4873.40
Depreciation5487.605314.305165.50
Tax0.00-131.200.00
Fringe Benefit Tax0.000.000.00
Deferred Tax-318.603651.90-3156.00
Reported Profit After Tax-846.00-16461.80-6882.90
Extra-ordinary Items 0.00-8324.47-7792.10
Adjusted Profit After Extra-ordinary item-846.00-8137.33909.20
EPS (Unit Curr.)-1.55-30.17-12.73
EPS (Adj) (Unit Curr.)-1.55-30.17-12.73
Calculated EPS (Unit Curr.)-1.55-30.17-12.62
Calculated EPS (Adj) (Unit Curr.)-1.55-30.17-12.62
Calculated EPS (Ann.) (Unit Curr.)-6.20-120.70-50.46
Calculated EPS (Adj) (Ann.) (Unit Curr.)-6.20-120.70-50.46
Book Value (Unit Curr.)0.000.000.00
Dividend (%)0.000.000.00
Equity2727.802727.802727.80
Reserve & Surplus80312.8082246.1098701.40
Face Value5.005.005.00
Public Shareholding (No. Of Shares)0.000.000.00
Public Shareholding (% in Equity)0.000.000.00
Pledged/Encumbered - No. of Shares0.000.000.00
Pledged/Encumbered - % in Total Promoters Holding0.000.000.00
Pledged/Encumbered - % in Total Equity0.000.000.00
Non Encumbered - No. of Shares0.000.000.00
Non Encumbered - % in Total Promoters Holding0.000.000.00
Non Encumbered - % in Total Equity0.000.000.00
PBIDTM(%)44.92-32.13-7.43
PBDTM(%)27.00-50.68-32.51
PATM(%)-5.28-109.39-45.91
Financial Ratios
   ParticularsMar 2020Mar 2019Mar 2018Mar 2017Mar 2016
Debt-Equity Ratio1.010.740.620.500.35
Long Term Debt-Equity Ratio0.800.560.510.430.32
Current Ratio0.660.480.540.580.52
Fixed Assets0.220.230.290.390.49
Inventory26496.1513590.6810522.1613538.338204.12
Debtors14.2012.1614.2519.5118.60
Interest Cover Ratio0.170.691.002.713.89
PBIDTM (%)41.2041.3835.3042.4738.76
PBITM (%)3.6510.9010.9822.8822.88
PBDTM (%)20.0925.5624.2834.0432.88
CPM (%)47.5832.3725.6925.9728.78
APATM (%)10.041.891.386.3712.90
ROCE (%)0.963.013.498.7210.39
RONW (%)5.460.930.733.738.19
Share Price
Year High () Low () Close () P/E High P/E Low P/E Close Mkt Cap.( In Cr.)
Oct 2020 487.80 394.05 433.60 52.73 39.10 43.38 236,552.97
Sep 2020 558.95 414.95 420.90 56.78 41.12 42.11 229,624.41
Aug 2020 565.05 508.50 513.95 57.20 49.06 51.41 280,388.37
Jul 2020 596.60 543.40 554.85 60.44 53.43 55.50 302,701.60
Jun 2020 593.70 537.00 559.65 60.30 52.95 55.99 305,320.27
May 2020 611.70 499.00 552.40 63.01 46.80 55.26 301,364.99
Apr 2020 536.00 412.60 514.35 56.36 40.44 51.45 280,606.59
Mar 2020 535.95 381.05 440.60 55.41 32.65 44.08 240,371.86
Feb 2020 568.60 483.70 524.05 344.14 274.28 305.55 285,898.48
Jan 2020 527.20 435.40 496.70 309.23 226.55 289.60 270,977.53
Share Prices Of 2019
Dec 2019 485.75 417.90 455.80 282.22 217.71 249.99 233,914.82
Nov 2019 455.65 350.50 442.30 252.32 185.80 242.58 226,986.67
Oct 2019 396.55 325.60 374.40 219.18 156.12 205.34 192,140.65
Sep 2019 374.60 332.65 367.25 209.57 178.58 201.42 188,471.30
Aug 2019 378.75 321.60 347.05 211.39 175.11 190.34 178,104.74
Jul 2019 371.00 328.15 337.80 206.87 176.40 185.27 173,357.67
Jun 2019 366.20 334.80 346.70 202.52 179.86 190.12 177,891.46
May 2019 356.00 312.95 348.50 196.71 170.11 191.10 178,815.04
Apr 2019 335.55 304.78 320.20 159.72 169.12 175.58 164,294.34
Mar 2019 327.18 277.79 305.60 160.86 127.40 142.22 133,073.45

NASDAQ 11880.63
25.66 0.22%
DJIA 29591.27
327.79 1.12%
S&P 500 3577.59
20.05 0.56%
HANG SENG 26588.20
102.00 0.39%
NIKKEI 225 26165.59
638.22 2.50%
STRAITS TIMES 2891.63
42.85 1.50%
FTSE 100 6432.17
98.33 1.55%
KLSE COMPOSITE 1578.39
-19.09 -1.20%
JAKARTA COMPOSITE 5701.03
48.26 0.85%
BSE SENSEX 44523.02
445.87 1.01%
NIFTY 13055.15
128.70 1.00%