Get Stock Quotes

Get Quotes

IDEA CELLULAR LTD.
Sector : Telecom Services


BSE  8.86   0.86   (10.75%)   BSE Code : 532822   NSE Code : IDEA

PREV. CLOSE
8.0
OPEN PRICE
8.63
CLOSE PRICE
8.86
VOLUME
45913400
TODAY's LOW
8.53
TODAY's HIGH
9.03




Important Levels
Pivot Points - 8.81
Resistance 1 9.08
Resistance 2 9.31
Support 1 8.58
Support 2 8.31

Price History

Price History
Date Open High Low Close Gain / Loss % Volume
12/08/2020 8.63 9.03 8.53 8.86 10.75 45913400
11/08/2020 9.0 9.0 8.65 8.71 -3.22 27436800
10/08/2020 9.0 9.19 8.82 9.09 13.63 71981700
05/08/2020 8.6 8.74 8.15 8.31 3.88 60074600
04/08/2020 8.65 8.92 8.51 8.63 7.88 69686100
03/08/2020 8.4 8.81 8.05 8.72 9 103901000
31/07/2020 8.1 8.45 8.1 8.4 5 80743700
30/07/2020 8.22 8.47 7.96 8.01 0.13 102416000
29/07/2020 8.04 8.62 7.87 8.26 3.25 95978200
27/07/2020 8.22 8.4 8.02 8.07 0.87 51843800

Peer Comparison

Name   Current Price 5 Days Old 10 Days Old 15 Days Old 20 Days Old
BHARTI AIRTEL LTD. Price 548.55 548.8 559.3 575.75 574.7
Gain / Loss % -0.44 -0.05 -1.92 -4.72 -4.55
IDEA CELLULAR LTD. Price 8.86 8.63 8.07 9.04 9.75
Gain / Loss % 10.75 2.67 9.79 -1.99 -9.13
MAHANAGAR TELEPHONE NIGAM LTD. Price 9.41 9.16 9.24 10.09 10.75
Gain / Loss % 4.56 2.73 1.84 -6.74 -12.47
RELIANCE COMMUNICATIONS LTD. Price 2.4 3.23 3.94 3.11 2.35
Gain / Loss % 20 -25.7 -39.09 -22.83 2.13
TATA TELESERVICES (MAHARASHTRA) LTD. Price 3.77 3.52 3.42 3.66 3.73
Gain / Loss % 25.67 7.1 10.23 3.01 1.07

Technical Indicators

Simple Moving Average
5 Days 8.72
10 Days 8.51
15 Days 8.53
25 Days 8.86
30 Days 9.1
Exponential Moving Average
5 Days 8.74
10 Days 8.66
12 Days 8.67
20 Days 8.74

MACD
12 Day EMA 8.67
26 Day EMA 8.75
MACD -0.08
Signal Line -0.11
Other Technical Indicators
Non - Smoothed RSI 85.74
Smoothed RSI 88.68
ROC 3.87
William %R -25
Upper Bollinger Band 9.68
Lower Bollinger Band 7.65
Middle Bollinger Band 8.67

Technical Analysis
Over Bought by RSI? Yes
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-20 Mar-19 Mar-18 Mar-17 Mar-16
Liabilities
Share Capital 28801 8802.5 4359.32 3605.33 3600.51
Reserves & Surplus -19799.7 54702 21310.19 20118.43 20695.4
Net Worth 9001.3 63504.5 25669.51 23723.76 24295.91
Secured Loans 96434.6 8810.1 9394.84 7858.93 4099.59
Unsecured Loans 0 99713.5 47567.66 43812.55 33704.3
TOTAL LIABILITIES 105435.9 172028.1 82632 75395.24 62099.8
Assets
Gross Block 235652.5 216260.3 93983.07 85501.14 87988.56
(-) Acc. Depreciation 55594 39598.9 14275.14 9376.15 23072.24
Net Block 180058.5 176661.4 79707.93 76124.98 64916.32
Capital Work in Progress. 956.4 5076.8 3585.29 0 6038.83
Investments 4958.8 13351.4 6386.14 6251.31 2498.95
Inventories 0 0 33.86 54.21 85.15
Sundry Debtors 2919.1 3308.1 887.38 1258.1 1136.06
Cash And Bank 2533.8 784.4 22.24 31.27 757.66
Loans And Advances 37459.7 33871 6100.2 4513.36 4374.92
Total Current Assets 42912.6 37963.5 7043.68 5856.93 6353.78
Current Liabilities 123074.8 60648.7 13761.25 20019.91 17017.02
Provisions 375.6 376.3 329.78 347.27 691.06
Total Current Liabilities 123450.4 61025 14091.04 20367.18 17708.08
NET CURRENT ASSETS -80537.8 -23061.5 -7047.35 -14510.25 -11354.29
Misc. Expenses 0 0 0 0 0
TOTAL ASSETS 105435.9 172028.1 82632 67866.04 62099.8

Profit and Loss

(Rs. in Crores)

Particulars Mar-20 Mar-19 Mar-18 Mar-17 Mar-16
INCOME:
Sales Turnover 44715.00 36858.80 27828.64 35278.65 35816.54
Excise Duty .00 .00 0.00 0.00 0.00
NET SALES 44715.00 36858.80 27828.64 35278.65 35816.54
Other Income 1086.1000 1073.3000 0.00 0.00 0.00
TOTAL INCOME 45801.10 37932.10 28126.80 35475.67 35999.99
EXPENDITURE:
Manufacturing Expenses 24819.00 28915.00 19062.55 22135.95 21169.26
Material Consumed .00 .00 0.00 0.00 0.00
Personal Expenses 1972.60 2120.90 1396.81 1625.64 1464.44
Selling Expenses 1170.70 .00 402.36 455.40 0.00
Administrative Expenses 2135.30 1944.00 1321.11 966.82 1358.59
Expenses Capitalised .00 .00 0.00 0.00 0.00
Provisions Made .00 .00 0.00 0.00 0.00
TOTAL EXPENDITURE 30097.60 32979.90 22182.84 25183.80 23992.29
Operating Profit 14617.40 3878.90 5645.81 10094.84 11824.26
EBITDA 15703.50 4952.20 5943.96 10291.87 12007.70
Depreciation 23888.80 14409.80 8316.12 7700.02 6199.50
Other Write-offs .00 .00 0.00 0.00 0.00
EBIT -8185.30 -9457.60 -2372.15 2591.85 5808.20
Interest 15377.20 9471.30 4924.53 4010.85 1797.96
EBT -23562.50 -18928.90 -7296.68 -1419.00 4010.24
Taxes 10844.80 -3636.20 -2515.90 -587.93 1393.59
Profit and Loss for the Year -34407.30 -15292.70 -4780.78 -831.08 2616.66
Non Recurring Items -38731.00 1271.40 28.03 0.00 0.00
Other Non Cash Adjustments .00 .00 0.00 0.00 0.00
Other Adjustments 6.80 -34.70 -28.03 0.00 0.00
REPORTED PAT -73131.50 -14056.00 -4780.78 -831.08 2616.66
KEY ITEMS
Preference Dividend .00 .00 0.00 0.00 0.00
Equity Dividend .00 .00 0.00 0.00 172.12
Equity Dividend (%) .00 .00 0.00 0.00 4.78
Shares in Issue (Lakhs) 287353.89 87355.58 43593.21 36053.28 36005.09
EPS - Annualised (Rs) -11.97384173 -17.50626577 -10.97 -2.31 7.27

Quarterly

(Rs. in Crores)

Particulars 2020-09 2020-06 2020-03 2019-12 2019-09
INCOME:
Net Sales Turnover 10723.5 10593.9 11671.9 11029.8 10804.5
Other Income 27 164 162 311.1 316.2
TOTAL INCOME 10750.5 10757.9 11833.9 11340.9 11120.7
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 468.2 530.3 279.3 567.1 594.1
Administration and Selling Expenses 0 0 0 0 0
Research and Development Expenses 0 0 0 0 0
Expenses Capitalised 0 0 0 0 0
Other Expenses 6188.5 6043.6 7106.6 7151.1 6904.9
Provisions Made 0 0 0 0 0
TOTAL EXPENSES 6656.7 6573.9 7385.9 7718.2 7499
Operating Profit 4066.8 4020 4286 3311.6 3305.5
EBITDA 4093.8 4184 4448 3622.7 3621.7
Depreciation 5844 5793.8 5847.9 5692.6 6266.2
EBIT -1750.2 -1609.8 -1399.9 -2069.9 -2644.5
Interest 4697.1 3800.9 4173.2 3717.1 3650.8
EBT -6447.3 -5410.7 -5573.1 -5787 -6295.3
Taxes 0 0 0 0 12660.7
Profit and Loss for the Year -6447.3 -5410.7 -5573.1 -5787 -18956
Extraordinary Items 0 0 0 0 0
Prior Year Adjustment 0 0 0 0 0
Other Adjustments 0 0 0 0 0
REPORTED PAT -7215.6 -25333.9 -11948.8 -6417.9 -49727.4
KEY ITEMS:
Reserves Written Back 0 0 0 0 0
Equity capital 28735.4 28735.4 28735.4 28735.4 28735.4
Reserves and Surplus 0 0 0 0 0
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 IDEA CELLULAR LTD. Mar-20 Mar-19 Mar-18 Mar-17 Mar-16
Key Stats
Earnings Per Share -11.97 -17.51 -10.97 -2.31 7.27
Profitability Ratios
Operating Profit Margin(%) 32.69 10.52 20.29 28.61 33.01
Profit Before Interest And Tax Margin(%) -18.31 -25.66 -8.52 7.35 16.22
Net Profit Margin(%) -163.55 -38.13 -17.18 -2.36 7.31
Return On Capital Employed(%) 195.06 -13.73 -6.94 -1.74 5.8
Return On Net Worth(%) -812.45 -22.13 -18.62 -3.5 10.77
Return on Assets(%) -69.36 -8.17 -5.79 -1.22 4.21
Tax Rate(%) -46.03 19.21 34.48 41.43 34.75
Liquidity And Solvency Ratios
Current Ratio 0.35 0.62 0.5 0.29 0.36
Quick Ratio 0.35 0.62 0.5 0.28 0.35
Debt Equity Ratio 10.71 1.71 2.22 2.18 1.56
Liquidity And Solvency Ratios
Interest Coverage Ratio -0.53 -1 -0.48 0.65 3.23
Management Efficiency Ratios
Inventory Turnover Ratio ? ? 821.87 650.78 420.63
Total Assets Turnover Ratio 0.42 0.21 0.34 0.52 0.58
Margin Ratios
Core EBITDA Margin(%) 34.29 13.06 21.13 29.01 33.35
EBIT Margin(%) -17.87 -24.93 -8.43 7.31 16.13
PAT Margin(%) -163.55 -38.13 -17.18 -2.36 7.31