Get Stock Quotes

Get Quotes

BHARTI AIRTEL LTD.
Sector : Telecom Services


BSE  558.85   10.85   (1.98%)   BSE Code : 532454   NSE Code : BHARTIARTL

PREV. CLOSE
548.0
OPEN PRICE
550.2
CLOSE PRICE
558.85
VOLUME
344094
TODAY's LOW
546.6
TODAY's HIGH
560.3




Important Levels
Pivot Points - 555.25
Resistance 1 563.9
Resistance 2 568.95
Support 1 550.2
Support 2 541.55

Price History

Price History
Date Open High Low Close Gain / Loss % Volume
05/08/2020 550.2 560.3 546.6 558.85 1.98 344094
04/08/2020 548.0 553.05 545.0 548.8 0.33 303607
03/08/2020 551.55 556.05 546.5 547.25 -1.22 307688
31/07/2020 551.1 559.0 546.45 554.85 0.52 528109
30/07/2020 577.0 579.0 543.4 552.85 -2.32 1961500
29/07/2020 566.0 569.15 560.45 566.35 0.42 727234
27/07/2020 558.0 563.5 544.25 559.3 0.05 591926
24/07/2020 565.0 567.05 555.4 559.8 -1.27 329748
23/07/2020 570.0 575.65 564.25 567.1 -0.33 870853
22/07/2020 568.0 575.45 563.0 569.5 0.44 653165

Peer Comparison

Name   Current Price 5 Days Old 10 Days Old 15 Days Old 20 Days Old
BHARTI AIRTEL LTD. Price 558.85 552.85 569.5 589.1 567.15
Gain / Loss % 1.98 1.09 -1.87 -5.13 -1.46
IDEA CELLULAR LTD. Price 8.31 8.01 8.53 9.34 9.58
Gain / Loss % 3.88 3.75 -2.58 -11.03 -13.26
MAHANAGAR TELEPHONE NIGAM LTD. Price 9.2 9.2 9.88 9.72 10.94
Gain / Loss % 2.22 0 -6.88 -5.35 -15.9
RELIANCE COMMUNICATIONS LTD. Price 3.07 3.74 3.42 2.58 2.13
Gain / Loss % 2.33 -17.91 -10.23 18.99 44.13
TATA TELESERVICES (MAHARASHTRA) LTD. Price 3.51 3.36 3.62 3.56 3.84
Gain / Loss % 17 4.46 -3.04 -1.4 -8.59

Technical Indicators

Simple Moving Average
5 Days 552.52
10 Days 558.46
15 Days 562.93
25 Days 565.53
30 Days 565.81
Exponential Moving Average
5 Days 554.88
10 Days 557.89
12 Days 558.94
20 Days 561.44

MACD
12 Day EMA 558.94
26 Day EMA 561.87
MACD -2.93
Signal Line -0.71
Other Technical Indicators
Non - Smoothed RSI 31.99
Smoothed RSI 49.15
ROC -0.67
William %R -66.7
Upper Bollinger Band 586.41
Lower Bollinger Band 543.86
Middle Bollinger Band 565.13

Technical Analysis
Over Bought by RSI? No
Over Sold by RSI? No
Over Bought by ROC? No
Over Sold by ROC? No
Over Bought by W%R? No
Over Sold by W%R? No

CandleStick Chart

Financials

Balance Sheet

(Rs. in Crores)

Particulars Mar-18 Mar-17 Mar-16 Mar-15 Mar-14
Liabilities
Share Capital 1998.7 1998.7 1998.7 1998.7 1998.7
Reserves & Surplus 100862.2 99208.6 82446 76272.1 64729.3
Net Worth 102860.9 101207.3 84446.8 78272.9 66728
Secured Loans 65415.8 1.6 2 1.9 1.4
Unsecured Loans 0 56888.3 42398.1 20250.7 8521.3
TOTAL LIABILITIES 168276.7 158097.2 126846.9 98525.5 75250.7
Assets
Gross Block 180754.6 163428 136859.3 93021.6 73949.2
(-) Acc. Depreciation 58145.2 51905.2 45044.8 39577.2 34071
Net Block 122609.4 111522.8 91812.4 53442.3 39878.2
Capital Work in Progress. 5542.7 0 3796.6 9066.9 1244.2
Investments 48128.2 45959 43026.9 43116.9 34523.9
Inventories 6.3 3.9 5.3 9.4 1.1
Sundry Debtors 4319.6 3211.8 3793 3311 2165.5
Cash And Bank 545.1 108.7 52.1 388.7 446
Loans And Advances 23786 20335.2 19450.4 17086.4 19945.2
Total Current Assets 28657 23659.6 23300.8 20795.5 22557.8
Current Liabilities 36351.4 32282.3 34093 26466.4 21798.6
Provisions 309.2 362.1 998.9 1431.8 1154.8
Total Current Liabilities 36660.6 32644.4 35091.9 27898.2 22953.4
NET CURRENT ASSETS -8003.6 -8984.8 -11791.1 -7102.7 -395.6
Misc. Expenses 0 0 0 0 0
TOTAL ASSETS 168276.7 148497 126846.9 98525.5 75250.7

Profit and Loss

(Rs. in Crores)

Particulars Mar-18 Mar-17 Mar-16 Mar-15 Mar-14
INCOME:
Sales Turnover 53663.00 62276.30 60300.20 55496.40 49918.50
Excise Duty 0.00 0.00 0.00 0.00 0.00
NET SALES 53663.00 62276.30 60300.20 55496.40 49918.50
Other Income 0.00 0.00 0.00 0.00 0.00
TOTAL INCOME 53898.60 62460.60 61785.80 60689.40 50771.90
EXPENDITURE:
Manufacturing Expenses 13951.20 29528.10 19113.40 18717.60 16941.60
Material Consumed 0.00 0.00 51.60 71.40 0.00
Personal Expenses 1720.90 1738.50 1869.30 1691.50 1648.10
Selling Expenses 151.60 720.00 0.00 0.00 0.00
Administrative Expenses 20034.40 6596.80 16929.70 15584.80 15030.00
Expenses Capitalised 0.00 0.00 0.00 0.00 0.00
Provisions Made 0.00 0.00 0.00 0.00 0.00
TOTAL EXPENDITURE 35858.10 38583.40 37964.00 36065.30 33619.70
Operating Profit 17804.90 23692.90 22336.20 19431.10 16298.80
EBITDA 18040.50 23877.20 23821.80 24624.10 17152.20
Depreciation 13048.60 12203.40 9543.10 7559.70 7231.30
Other Write-offs 0.00 0.00 0.00 0.00 0.00
EBIT 4991.90 11673.80 14278.70 17064.40 9920.90
Interest 5069.00 2912.50 3559.00 1409.10 1336.40
EBT -77.10 8761.30 10719.70 15655.30 8584.50
Taxes -760.40 1416.10 2493.30 2454.80 1777.20
Profit and Loss for the Year 683.30 7345.20 8226.40 13200.50 6807.30
Non Recurring Items -598.40 -17270.80 -679.90 0.00 -207.10
Other Non Cash Adjustments 0.00 0.00 0.00 0.00 0.00
Other Adjustments -5.70 0.00 0.00 0.00 0.00
REPORTED PAT 79.20 -9925.60 7546.50 13200.50 6600.20
KEY ITEMS
Preference Dividend 0.00 0.00 0.00 0.00 0.00
Equity Dividend 463.60 253.80 613.60 1480.40 657.30
Equity Dividend (%) 23.19 12.69 30.69 74.06 32.88
Shares in Issue (Lakhs) 39974.00 39974.00 39974.00 39974.00 39974.00
EPS - Annualised (Rs) 0.20 -24.83 18.88 33.02 16.51

Quarterly

(Rs. in Crores)

Particulars 2019-12 2019-09 2019-06 2019-03 2018-12
INCOME:
Net Sales Turnover 13479.7 13012.9 12833.1 12522 12314
Other Income 72.6 66.9 76.9 73.5 60.2
TOTAL INCOME 13552.3 13079.8 12910 12595.5 12374.2
EXPENDITURE:
Stock Adjustments 0 0 0 0 0
Raw Material Consumed 0 0 0 0 0
Power and Fuel 0 0 0 0 0
Employee Expenses 370.6 381 365.2 373.4 405.4
Administration and Selling Expenses 467.1 353.5 494.2 660.3 672.5
Research and Development Expenses 0 0 0 0 0
Expenses Capitalised 0 0 0 0 0
Other Expenses 7461.7 7686.3 7555.9 8235.4 8642.8
Provisions Made 0 0 0 0 0
TOTAL EXPENSES 8299.4 8420.8 8415.3 9269.1 9720.7
Operating Profit 5180.3 4592.1 4417.8 3252.9 2593.3
EBITDA 5252.9 4659 4494.7 3326.4 2653.5
Depreciation 5226.4 4983.2 5017 3880 3823
EBIT 26.5 -324.2 -522.3 -553.6 -1169.5
Interest 2544.3 2056.1 1811.9 1904.4 316.9
EBT -2517.8 -2380.3 -2334.2 -2458 -1486.4
Taxes -1851.7 -8681.8 -1243.2 -474.5 -562.4
Profit and Loss for the Year -666.1 6301.5 -1091 -1983.5 -924
Extraordinary Items 0 0 0 0 0
Prior Year Adjustment 0 0 0 0 0
Other Adjustments 0 0 0 0 0
REPORTED PAT -3388.1 -24513.5 -1303.7 -36.6 227.1
KEY ITEMS:
Reserves Written Back 0 0 0 0 0
Equity capital 2566 2566 2565.5 1998.7 1998.7
Reserves and Surplus 91114.6 94460 117334.3 96360.6 97701.6
Equity Dividend Rate 0 0 0 0 0
Agg. Non-Promoter Shares(lacks) 0 0 0 0 0
Agg. Non-Promoter Holding (%) 0 0 0 0 0
Government Share 0 0 0 0 0
Capital Adequacy Ratio 0 0 0 0 0
EPS (Rs.) 0 0 0 0 0

Key Ratios

Key Financial ratios of BHARTI AIRTEL LTD. Mar-18 Mar-17 Mar-16 Mar-15 Mar-14
Key Stats
Earnings Per Share 0.2 -24.83 18.88 33.02 16.51
Profitability Ratios
Operating Profit Margin(%) 33.18 38.04 37.04 35.01 32.65
Profit Before Interest And Tax Margin(%) 9.3 18.75 23.68 30.75 19.87
Net Profit Margin(%) 0.15 -15.94 12.51 23.79 13.22
Return On Capital Employed(%) 0.52 6.32 8.87 18.32 12.74
Return On Net Worth(%) 0.08 -9.81 8.94 16.86 9.89
Return on Assets(%) 0.05 -6.68 5.95 13.4 8.77
Tax Rate(%) 986.25 16.16 23.26 15.68 20.7
Liquidity And Solvency Ratios
Current Ratio 0.78 0.72 0.66 0.75 0.98
Quick Ratio 0.78 0.72 0.66 0.75 0.98
Debt Equity Ratio 0.64 0.56 0.5 0.26 0.13
Liquidity And Solvency Ratios
Interest Coverage Ratio 0.98 4.01 4.01 12.11 7.42
Management Efficiency Ratios
Inventory Turnover Ratio 8517.94 15968.28 11377.4 5903.87 45380.45
Total Assets Turnover Ratio 0.32 0.42 0.48 0.56 0.66
Margin Ratios
Core EBITDA Margin(%) 33.47 38.23 38.56 40.57 33.78
EBIT Margin(%) 9.26 18.69 23.11 28.12 19.54
PAT Margin(%) 0.15 -15.94 12.51 23.79 13.22