Edition:
India

Idea Cellular Ltd (IDEA.NS)

IDEA.NS on National Stock Exchange of India

99.50INR
22 Jan 2018
Change (% chg)

Rs-2.80 (-2.74%)
Prev Close
Rs102.30
Open
Rs102.20
Day's High
Rs102.20
Day's Low
Rs99.10
Volume
7,526,353
Avg. Vol
15,901,349
52-wk High
Rs123.50
52-wk Low
Rs70.40

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
 
*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.15 27.86
P/E High - Last 5 Yrs. -- 58.07 45.34
P/E Low - Last 5 Yrs. -- 19.86 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.09 6.39
Price to Cash Flow (TTM) -- 5.16 9.70
% Owned Institutions -- 0.46 0.16

Dividends

  Company industry sector
Dividend Yield -- 1.19 2.56
Dividend Yield - 5 Year Avg -- 1.02 2.63
Dividend 5 Year Growth Rate -- 4.53 15.84
Payout Ratio(TTM) -- 23.17 41.04

Growth Rates

  Company industry sector
Sales (MRQ) vs Qtr. 1 Yr. Ago -- 6.25 11.61
Sales (TTM) vs TTM 1 Yr. Ago -- 1.20 9.87
Sales - 5 Yr. Growth Rate -- 6.41 11.04
EPS (MRQ) vs Qtr. 1 Yr. Ago -- 63.35 16.15
EPS (TTM) vs TTM 1 Yr. Ago -- -- --
EPS - 5 Yr. Growth Rate -- -6.88 12.08
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.52 93.40
Total Debt to Equity (MRQ) -- 129.96 119.50
Interest Coverage (TTM) -- 400.95 90.35

Profitability Ratios

  Company industry sector
Gross Margin (TTM) -- 68.07 71.25
Gross Margin - 5 Yr. Avg. -- 62.05 69.76
EBITD Margin (TTM) -- -- --
EBITD - 5 Yr. Avg -- 37.19 51.04
Operating Margin (TTM) -- 12.90 35.32
Operating Margin - 5 Yr. Avg. -- 12.11 33.15
Pre-Tax Margin (TTM) -- 7.23 31.00
Pre-Tax Margin - 5 Yr. Avg. -- 5.69 28.30
Net Profit Margin (TTM) -- 5.89 23.47
Net Profit Margin - 5 Yr. Avg. -- 3.91 21.47
Effective Tax Rate (TTM) -- 11.93 22.16
Effective Tax Rate - 5 Yr. Avg. -- 16.23 23.04

Efficiency

  Company industry sector
Revenue/Employee (TTM) -- 5,775,890,410 5,290,421,941
Net Income/Employee (TTM) -- 162,672,464 1,243,036,662
Receivable Turnover (TTM) -- 16.69 10.59
Inventory Turnover (TTM) -- 64.28 38.47
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.60
Return on Investment (TTM) -- 4.97 20.68
Return on Investment - 5 Yr. Avg. -- 3.30 18.84
Return on Equity (TTM) -- 9.45 24.12
Return on Equity - 5 Yr. Avg. -- 5.86 21.19
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 -- -- -- 15
13 Week -- -- -- 53
26 Week -- -- -- 34
52 Week -- -- -- 36
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.