Adani Ports

343.15down-arrow2.55

Asian Paints

1717.25down-arrow31.00

Axis Bank

453.75down-arrow9.60

B P C L

376.75down-arrow-1.40

Bajaj Auto

2882down-arrow29.55

Bajaj Finance

3330down-arrow121.95

Bajaj Finserv

6569.2down-arrow163.80

Bharti Airtel

568.65down-arrow7.35

Bharti Infratel

214.55down-arrow-4.80

Britannia Inds.

3673.6down-arrow-11.40

Cipla

639.05down-arrow4.65

Coal India

130.4down-arrow-2.45

Dr Reddy's Labs

3896.6down-arrow9.90

Eicher Motors

19483.25down-arrow91.55

GAIL (India)

105.55down-arrow2.85

Grasim Inds

616.65down-arrow8.15

H D F C

1941.85down-arrow55.80

HCL Technologies

588.25down-arrow13.35

HDFC Bank

1124.95down-arrow14.60

Hero Motocorp

2691.45down-arrow-27.75

Hind. Unilever

2175.85down-arrow-10.20

Hindalco Inds.

164.8down-arrow9.80

I O C L

86.5down-arrow-0.45

ICICI Bank

370.35down-arrow1.40

IndusInd Bank

556.55down-arrow3.95

Infosys

781.7down-arrow7.00

ITC

195.45down-arrow-0.85

JSW Steel

197.45down-arrow2.10

Kotak Mah. Bank

1368.15down-arrow15.40

Larsen & Toubro

944.95down-arrow3.70

M & M

560.3down-arrow9.05

Maruti Suzuki

6002.35down-arrow-42.05

Nestle India

16759.1down-arrow-42.95

NTPC

91.2down-arrow0.20

O N G C

80.2down-arrow-1.10

Power Grid Corpn

171.55down-arrow1.80

Reliance Industr

1824.25down-arrow26.25

Shree Cement

22803.6down-arrow363.80

St Bk of India

199.1down-arrow7.20

Sun Pharma.Inds.

481.95down-arrow-0.55

Tata Motors

106.95down-arrow1.60

Tata Steel

344.5down-arrow10.30

TCS

2204.35down-arrow-14.55

Tech Mahindra

577.3down-arrow-6.15

Titan Company

991.6down-arrow0.45

UltraTech Cem.

3843.45down-arrow56.80

UPL

442.55down-arrow-1.45

Vedanta

112down-arrow1.60

Wipro

221.6down-arrow-1.50

Zee Entertainmen

171.9down-arrow-0.25

CORPORATE INFORMATION   
Bharti Airtel Ltd
Industry :  Telecommunications - Service Provider
BSE Code
ISIN Demat
Book Value()
532454
INE397D01024
185.9190035
NSE Symbol
P/E(TTM)
Mar.Cap( Cr.)
BHARTIARTL
56.89
310339.38
EPS(TTM)
Face Value()
Div & Yield %
10
5
0.35
Detailed Quotes
BSE NSE
Last Price() 568.85 arrowupp
Jul 09,2020 EOD
568.65 arrowupp
Jul 09,2020 EOD
Today's Change( ) 7.60 (1.35%) arrowupp 7.35 (1.31%) arrowupp
Open( ) 563.00 564.00
Prev Close( ) 561.25 561.30
Volume 255,685.00 8,452,964.00
Today's Range( ) 570.25 - 560.50 570.25 - 560.30
52-Week Range( ) 611.70 - 321.60 612.00 - 321.15
Buy (Size) N.A 568.65(×35250)
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
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
ChairmanSunil B Mittal
DirectorChua Sock Koong
Independent DirectorCraig Edward Ehrlich
DirectorTan Yong Choo
Independent DirectorManish Kejriwal
Managing Director & CEOGopal Vittal
Independent DirectorBen Verwaayen
V K Viswanathan
Dinesh Kumar Mittal
Shishir Priyadarshi
DirectorRakesh Bharti Mittal
Company SecretaryPankaj Tewari
Alternate DirectorTao Yih Arthur Lang
Addtnl Independent DirectorKimsuka Narasimhan
Balance Sheet
Particulars (Sources Of Funds)Mar 2019
( Cr)
Mar 2018
( Cr)
Mar 2017
( Cr)
Mar 2016
( Cr)
Mar 2015
( Cr)
Mar 2014
( Cr)
Share Capital 1998.701998.701998.701998.701998.701998.70
Reserves Total 96360.60100862.2099208.60109730.4076274.2064729.30
Equity Share Warrants0.000.000.000.000.000.00
Equity Application Money0.000.000.000.000.000.00
Total Shareholders Funds98359.30102860.90101207.30111729.1078272.9066728.00
Secured Loans 1.002.903.102.001.901.40
Unsecured Loans 83788.9065412.9060091.6045568.7021567.8010364.00
Total Debt83789.9065415.8060094.7045570.7021569.7010365.40
Other Liabilities5213.703967.904271.803994.304400.504148.90
Total Liabilities187362.90172244.60165573.80161294.10104243.1081242.30
APPLICATION OF FUNDS :
Gross Block 221856.50198828.10176461.30145668.70100087.0079574.30
Less : Accumulated Depreciation 90122.5076218.7064938.5053743.2046642.6039696.10
Less:Impairment of Assets0.000.000.000.000.000.00
Net Block 131734.00122609.40111522.8091925.5053444.4039878.20
Lease Adjustment0.000.000.000.000.000.00
Capital Work in Progress5567.305542.709600.203830.309066.901244.20
Producing Properties0.000.000.000.000.000.00
Investments 38476.8048128.2045959.0069983.1043116.9034523.90
Current Assets, Loans & Advances
Inventories 1.006.303.905.309.401.10
Sundry Debtors 3849.004319.603211.803172.403311.002165.50
Cash and Bank Balance219.60545.10173.4046.60388.70446.00
Loans and Advances 14781.4010959.2013293.908149.706326.203637.10
Total Current Assets18851.0015830.2016683.0011374.0010035.306249.70
Less : Current Liabilities and Provisions
Current Liabilities 34989.0032321.8025546.2022830.6019873.6015069.00
Provisions 333.60370.90517.60903.301234.90945.30
Total Current Liabilities & Provisions35322.6032692.7026063.8023733.9021108.5016014.30
Net Current Assets-16471.60-16862.50-9380.80-12359.90-11073.20-9764.60
Miscellaneous Expenses not written off 0.000.000.000.000.000.00
Deferred Tax Assets14355.1010720.508538.207714.601911.801631.50
Deferred Tax Liability9203.909296.107657.405407.602983.902579.00
Net Deferred Tax5151.201424.40880.802307.00-1072.10-947.50
Other Assets22905.2011402.406991.805608.1010760.2016308.10
Total Assets187362.90172244.60165573.80161294.10104243.1081242.30
Contingent Liabilities13668.608245.608095.705181.50100767.8087232.10
Profit and Loss
Particulars(INCOME)Mar 2019
( Cr)
Mar 2018
( Cr)
Mar 2017
( Cr)
Mar 2016
( Cr)
Mar 2015
( Cr)
Mar 2014
( Cr)
Sales Turnover 49608.0053663.0062276.3060300.3055496.4049918.50
Excise Duty0.000.000.000.000.000.00
Net Sales49608.0053663.0062276.3060300.3055496.4049918.50
Other Income 5905.001077.302526.401743.705193.00853.40
Stock Adjustments 0.000.000.000.0063.8018.30
Total Income55513.0054740.3064802.7062044.0060753.2050790.20
EXPENDITURE :
Raw Materials 0.000.000.000.0071.4020.50
Power & Fuel Cost4684.704564.704552.605758.904115.104169.70
Employee Cost 1471.001720.901738.501864.801691.501648.10
Other Manufacturing Expenses 25323.7023441.4025574.7023054.6018003.7016137.40
Selling & Administrative Expenses 3197.103782.404142.004677.8011211.1010456.70
Miscellaneous Expenses 3108.902952.8019846.403312.901036.301412.70
Less : Pre-operative Expenses Capitalised 0.000.000.000.000.000.00
Total Expenditure37785.4036462.2055854.2038669.0036129.1033845.10
Operating Profit17727.6018278.108948.5023375.0024624.1016945.10
Interest 7843.705910.705254.603545.301409.101336.40
Gross Profit9883.9012367.403693.9019829.7023215.0015608.70
Depreciation15087.6013048.6012203.409575.307559.707231.30
Profit Before Tax-5203.70-681.20-8509.5010254.4015655.308377.40
Tax1.50-220.40-4.502055.802330.201980.00
Fringe Benefit tax0.000.000.000.000.000.00
Deferred Tax-3376.20-540.001420.60418.30124.60-202.80
Reported Net Profit-1829.0079.20-9925.607780.3013200.506600.20
Extraordinary Items 2615.90-660.87-13893.34-589.042709.439.14
Adjusted Net Profit-4444.90740.073967.748369.3410491.076591.06
Adjustment below Net Profit -1205.503089.30-74.50-945.90-41.100.00
P & L Balance brought forward84561.3082927.8093473.5087526.3048496.5042678.00
Statutory Appropriations0.000.000.000.000.000.00
Appropriations 1998.801535.00545.60887.201597.60781.70
P & L Balance carried down79528.0084561.3082927.8093473.5060058.3048496.50
Dividend999.352134.65399.70887.201539.00719.50
Preference Dividend0.000.000.000.000.000.00
Equity Dividend %50.00106.8020.0027.2077.0036.00
Dividend Per Share(Rs)2.505.341.001.363.851.80
Earnings Per Share-Unit Curr0.000.200.0019.4633.0216.51
Earnings Per Share(Adj)-Unit Curr0.000.180.0017.8630.3115.16
Book Value-Unit Curr246.06257.32253.18279.50195.80166.92
Book Value(Adj)-Unit Curr225.88236.22232.42256.58179.74153.23
Quarterly Results
 
Quarters
ParticularsMar 2020 ( Cr)Dec 2019 ( Cr)Sep 2019 ( Cr)
Gross Sales14991.4013479.7013012.90
Other Operating Income0.000.000.00
Other Income 96.8072.6066.90
Total Income15088.2013552.3013079.80
Total Expenditure 16840.1011021.4039235.80
PBIDT-1751.902530.90-26156.00
Interest 3121.502544.302056.10
PBDT-4873.40-13.40-28212.10
Depreciation5165.505226.404983.20
Tax0.000.000.00
Fringe Benefit Tax0.000.000.00
Deferred Tax-3156.00-1851.70-8681.80
Reported Profit After Tax-6882.90-3388.10-24513.50
Extra-ordinary Items -7792.10-2722.00-30815.00
Adjusted Profit After Extra-ordinary item909.20-666.106301.50
EPS (Unit Curr.)-12.73-6.60-47.77
EPS (Adj) (Unit Curr.)-12.73-6.60-47.77
Calculated EPS (Unit Curr.)-12.62-6.60-47.77
Calculated EPS (Adj) (Unit Curr.)-12.62-6.60-47.77
Calculated EPS (Ann.) (Unit Curr.)-50.46-26.41-191.06
Calculated EPS (Adj) (Ann.) (Unit Curr.)-50.46-26.41-191.06
Book Value (Unit Curr.)0.000.000.00
Dividend (%)0.000.000.00
Equity2727.802566.002566.00
Reserve & Surplus98701.4091114.6094460.00
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(%)-11.6918.78-201.00
PBDTM(%)-32.51-0.10-216.80
PATM(%)-45.91-25.13-188.38
Financial Ratios
   ParticularsMar 2019Mar 2018Mar 2017Mar 2016Mar 2015
Debt-Equity Ratio0.740.620.500.350.22
Long Term Debt-Equity Ratio0.560.510.430.320.19
Current Ratio0.490.540.580.520.42
Fixed Assets0.240.290.390.490.62
Inventory13591.2310522.1613538.338204.1210570.74
Debtors12.1514.2519.5118.6020.27
Interest Cover Ratio0.001.002.713.899.69
PBIDTM (%)30.4635.3042.4738.7638.22
PBITM (%)0.0510.9822.8822.8824.60
PBDTM (%)14.6524.2834.0432.8835.68
CPM (%)21.4525.6925.9728.7832.53
APATM (%)-8.961.386.3712.9018.90
ROCE (%)0.013.498.7210.3914.72
RONW (%)-4.420.733.738.1914.47
Share Price
Year High () Low () Close () P/E High P/E Low P/E Close Mkt Cap.( In Cr.)
Jun 2020 593.70 537.00 559.65 0.00 0.00 0.00 305,320.27
May 2020 611.70 499.00 552.40 0.00 0.00 0.00 301,364.99
Apr 2020 536.00 412.60 514.35 0.00 0.00 0.00 280,606.59
Mar 2020 535.95 381.05 440.60 0.00 0.00 0.00 240,371.86
Feb 2020 568.60 483.70 524.05 0.00 0.00 0.00 285,898.48
Jan 2020 527.20 435.40 496.70 0.00 0.00 0.00 270,977.53
Share Prices Of 2019
Dec 2019 485.75 417.90 455.80 0.00 0.00 0.00 233,914.82
Nov 2019 455.65 350.50 442.30 0.00 0.00 0.00 226,986.67
Oct 2019 396.55 325.60 374.40 0.00 0.00 0.00 192,140.65
Sep 2019 374.60 332.65 367.25 0.00 0.00 0.00 188,471.30
Aug 2019 378.75 321.60 347.05 0.00 0.00 0.00 178,104.74
Jul 2019 371.00 328.15 337.80 0.00 0.00 0.00 173,357.67
Jun 2019 366.20 334.80 346.70 0.00 0.00 0.00 177,891.46
May 2019 356.00 312.95 348.50 0.00 0.00 0.00 178,815.04
Apr 2019 335.55 304.78 320.20 0.00 0.00 0.00 164,294.34
Mar 2019 327.18 277.79 305.60 0.00 0.00 0.00 133,073.45
Feb 2019 300.05 269.25 291.88 181.49 150.93 171.74 127,097.34
Jan 2019 316.71 270.63 281.96 192.86 155.64 165.90 122,780.14
Share Prices Of 2018
Dec 2018 312.12 259.11 287.24 199.94 148.33 169.01 125,078.65
Nov 2018 311.89 263.97 287.84 190.11 152.53 169.36 125,338.48

NASDAQ 10492.50
148.61 1.44%
DJIA 26067.28
177.10 0.68%
S&P 500 3169.94
24.62 0.78%
HANG SENG 26210.16
80.98 0.31%
NIKKEI 225 22529.29
90.64 0.40%
STRAITS TIMES 2652.65
-16.84 -0.63%
FTSE 100 6049.62
-106.54 -1.73%
KLSE COMPOSITE 1583.25
-0.25 -0.02%
JAKARTA COMPOSITE 5052.79
-23.38 -0.46%
BSE SENSEX 36737.69
408.68 1.12%
NIFTY 10813.45
107.70 1.01%