Edition:
United Kingdom

Idea Cellular Ltd (IDEA.NS)

IDEA.NS on National Stock Exchange of India

93.90INR
15 Dec 2017
Change (% chg)

-- (--)
Prev Close
Rs93.90
Open
--
Day's High
--
Day's Low
--
Volume
--
Avg. Vol
13,319,743
52-wk High
Rs123.50
52-wk Low
Rs66.30

Revenue & Earnings Per Share

    Revenue* Earnings Per Share**
FY 2018 Sep 73,491.00 -3.430
Jun 80,541.00 -2.560
FY 2017 Mar '17 80,316.00 -1.270
Dec 85,723.90 -1.367
Sep 92,252.80 -0.120
Jun 94,493.00 0.450
FY 2016 Mar '16 94,355.20 1.190
Dec 89,710.40 1.760
Sep 86,413.90 2.050
Jun 87,557.40 2.330
FY 2015 Mar '15 83,578.20 2.323
Dec 79,428.20 1.840
Sep 74,940.30 1.848
Jun 74,848.00 1.813
 
*Note: Units in Millions ofRupee
**Note: Units in Rupee

Consensus Estimates Analysis

No consensus analysis data available.

Valuation Ratios

  Company industry sector
P/E Ratio (TTM) -- 59.27 27.87
P/E High - Last 5 Yrs. -- 58.03 45.33
P/E Low - Last 5 Yrs. -- 19.89 14.74
Beta -- 0.71 0.78
Price to Sales (TTM) -- 1.60 3.83
Price to Book (MRQ) -- 2.25 5.36
Price to Tangible Book (MRQ) -- 3.10 6.39
Price to Cash Flow (TTM) -- 5.15 9.70
% Owned Institutions -- 0.33 0.13

Dividends

  Company industry sector
Dividend Yield -- 1.18 2.56
Dividend Yield - 5 Year Avg -- 1.01 2.63
Dividend 5 Year Growth Rate -- 4.54 15.85
Payout Ratio(TTM) -- 23.05 41.02

Growth Rates

  Company industry sector
Sales (MRQ) vs Qtr. 1 Yr. Ago -- 6.27 11.62
Sales (TTM) vs TTM 1 Yr. Ago -- 1.20 9.87
Sales - 5 Yr. Growth Rate -- 6.42 11.04
EPS (MRQ) vs Qtr. 1 Yr. Ago -- 63.39 16.16
EPS (TTM) vs TTM 1 Yr. Ago -- -- --
EPS - 5 Yr. Growth Rate -- -6.95 12.07
Capital Spending - 5 Yr. Growth Rate -- 3.20 11.54

Financial Strength

  Company industry sector
Quick Ratio (MRQ) -- 0.79 0.89
Current Ratio (MRQ) -- 0.83 1.02
LT Debt to Equity (MRQ) -- 99.48 93.39
Total Debt to Equity (MRQ) -- 129.98 119.49
Interest Coverage (TTM) -- 402.04 90.39

Profitability Ratios

  Company industry sector
Gross Margin (TTM) -- 68.12 71.26
Gross Margin - 5 Yr. Avg. -- 62.09 69.77
EBITD Margin (TTM) -- -- --
EBITD - 5 Yr. Avg -- 37.22 51.05
Operating Margin (TTM) -- 12.90 35.33
Operating Margin - 5 Yr. Avg. -- 12.12 33.16
Pre-Tax Margin (TTM) -- 7.22 31.01
Pre-Tax Margin - 5 Yr. Avg. -- 5.69 28.31
Net Profit Margin (TTM) -- 5.88 23.48
Net Profit Margin - 5 Yr. Avg. -- 3.91 21.48
Effective Tax Rate (TTM) -- 11.84 22.15
Effective Tax Rate - 5 Yr. Avg. -- 16.21 23.04

Efficiency

  Company industry sector
Revenue/Employee (TTM) -- 5,791,814,282 5,292,922,469
Net Income/Employee (TTM) -- 163,120,852 1,243,624,235
Receivable Turnover (TTM) -- 16.70 10.59
Inventory Turnover (TTM) -- 64.44 38.49
Asset Turnover (TTM) -- 0.53 0.61

Management Effectiveness

  Company industry sector
Return on Assets (TTM) -- 3.63 14.20
Return on Assets - 5 Yr. Avg. -- 2.51 12.61
Return on Investment (TTM) -- 4.97 20.68
Return on Investment - 5 Yr. Avg. -- 3.31 18.84
Return on Equity (TTM) -- 9.45 24.13
Return on Equity - 5 Yr. Avg. -- 5.86 21.20
Note: Units in Millions of US Dollars

Performance for Idea Cellular Ltd

Period %
Actual
% vs.
S&P 500
Rank In
Industry
Industry
Rank
4 Week -- -- -- 16
13 Week -- -- -- 53
26 Week -- -- -- 35
52 Week -- -- -- 37
YTD -- -- -- 53
Note:: Rank is a percentile that ranges from 0 to 99, with 99 = best.

Institutional Holders

NYSE and AMEX quotes delayed by at least 20 minutes. NASDAQ delayed by at least 15 minutes. For a complete list of exchanges and delays, please click here.