Bharti Airtel Ltd


BSE: 532454 | NSE: BHARTIARTL | ISIN: INE397D01024 
Market Cap: [Rs.Cr.] 113,413 | Face Value: [Rs.] 5
Industry: Telecommunications - Service Provider

 Discuss this stock

Balance Sheet

(Rs. in Crores)
ParticularsMar-11Mar-10Mar-09Mar-08Mar-07Mar-06
SOURCES OF FUNDS :      
Share Capital 1,898.801,898.801,898.241,897.911,895.931,893.88
Reserves Total 41,934.2034,652.3025,745.4318,342.359,517.335,439.55
Total Shareholders Funds43,833.0036,551.1027,643.6720,240.2611,413.267,333.43
Secured Loans 17.1039.4051.7352.42266.452,863.37
Unsecured Loans 11,880.404,999.507,661.926,517.925,044.361,932.92
Total Debt11,897.505,038.907,713.656,570.345,310.814,796.29
Total Liabilities55,730.5041,590.0035,357.3226,810.6016,724.0712,129.72
APPLICATION OF FUNDS :      
Gross Block 61,437.5044,212.5037,266.7028,115.6526,509.9317,951.74
Less : Accumulated Depreciation 20,736.7016,187.5012,253.349,085.007,204.304,944.86
Less:Impairment of Assets0.000.000.000.000.00NA
Net Block 40,700.8028,025.0025,013.3619,030.6519,305.63NA
Lease Adjustment0.000.000.000.000.000.00
Capital Work in Progress6,497.601,594.702,566.672,751.082,375.822,341.25
Investments 11,813.0015,773.3011,777.7610,952.85705.82719.70
Current Assets, Loans & Advances      
Inventories 34.4027.2062.1556.8651.5518.59
Sundry Debtors 2,375.802,105.002,550.052,776.461,873.301,076.17
Cash and Bank133.80816.702,251.60502.94780.46307.43
Loans and Advances 10,405.206,381.004,561.212,923.612,587.251,857.82
Total Current Assets12,949.209,329.909,425.016,259.875,292.563,260.01
Less : Current Liabilities and Provisions      
Current Liabilities 14,796.3012,284.8013,117.9811,909.079,459.426,477.71
Provisions 627.60658.70634.40209.881,262.33539.30
Total Current Liabilities15,423.9012,943.5013,752.3812,118.9510,721.757,017.01
Net Current Assets-2,474.70-3,613.60-4,327.37-5,859.08-5,429.19-3,757.00
Miscellaneous Expenses not written off 0.000.000.080.202.667.94
Deferred Tax Assets780.90796.30917.31436.30143.7480.73
Deferred Tax Liability1,308.50799.60590.20500.17380.41269.78
Net Deferred Tax-527.60-3.30327.11-63.87-236.67-189.05
Total Assets56,009.1041,776.1035,357.6126,811.8316,724.0712,129.72
Contingent Liabilities50,037.005,396.403,241.162,148.871,615.171,501.51

Peer Comparison

Company Market Cap
(Rs. in Cr.)
P/E (TTM)
(x)
P/BV (TTM)
(x)
EV/EBIDTA
(x)
ROE
(%)
ROCE
(%)
D/E
(x)
Bharti Airtel 113,412.93 19.79 2.29 11.13 19.1 18.5 0.21
Idea Cellular 25,680.63 44.60 1.99 10.95 4.6 8.2 0.64
Rel. Comm. 13,539.97 0.00 0.28 31.54 -2.5 -0.6 0.57
Tata Comm 6,096.15 35.59 0.88 8.38 2.4 4.0 0.34
Tata Tele. Mah. 2,379.09 0.00 -2.10 6.78 -90.5 -9.3 0.00
M T N L 1,442.70 0.00 0.55 0.00 -34.8 -19.7 0.46
Tulip Telecom 1,137.53 3.61 0.74 5.33 28.9 19.5 1.37
OnMobile Global 515.78 10.26 0.62 8.65 8.3 8.0 0.17
Quadrant Tele. 219.80 0.00 -0.30 0.00 0.0 0.0 0.00
Nettlinx 11.12 0.00 0.65 0.00 -11.8 -7.4 0.20
Vital Comm. 2.54 0.00 0.06 0.00 0.0 0.0 0.03

Futures & Options Quote

 
Expiry Date
299.00 0.55  (0.2%)
Instrument: FUTSTK
Expiry Date: 31 May 2012
Open Price: 300.10
Average Price: 299.85
No. of Contracts Traded: 3,711,000
Open Interest: 8,017,000
Underlying: BHARTIARTL
Market Lot: 1000
Previous Close: 299.00
Day’s High | Low: 302.70 | 296.65
Turnover (Cr.): 111.27
Open Int. Change: -716,000.00 ( [8.2]% )
View detailed F& O quotes >>

Key Information

Key Executives:

Sunil Bharti Mittal , Chairman & Managing Director 

Akhil Gupta , Director 

Ajay Lal , Director 

Chua Sock Koong , Director 


Company Head Office / Quarters:
Bharti Crescent Vasant Kunj,
1 Nelson Mandela Road Phase II,
New Delhi,
New Delhi-110070
Phone : 91-11-46666100/6500/6255
Fax : 91-11-46666137
E-mail : compliance.officer@bharti.in
Web : http://www.airtel.com
Registrars:
Karvy Computershare Pvt Ltd
Plot No 17-24
Vittal Rao Nagar
Madhapur
Hyderabad-500081

Calendar

May-2012
M T W T F S S
21 22 23 24 25 26 27
IPO
listNo IPO today
Economic Events
list No economic event today
Results
list Videocon Inds. | Rel. Comm.