Edition:
United Kingdom

Idea Cellular Ltd (IDEA.NS)

IDEA.NS on National Stock Exchange of India

83.10INR
21 Feb 2018
Change (% chg)

-- (--)
Prev Close
Rs83.10
Open
--
Day's High
--
Day's Low
--
Volume
--
Avg. Vol
17,050,662
52-wk High
Rs123.50
52-wk Low
Rs71.45

Revenue & Earnings Per Share

    Revenue* Earnings Per Share**
FY 2018 Dec 63,919.00 -3.960
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) -- 55.53 27.66
P/E High - Last 5 Yrs. -- 54.78 44.92
P/E Low - Last 5 Yrs. -- 19.07 14.67
Beta -- 0.73 0.79
Price to Sales (TTM) -- 1.56 3.79
Price to Book (MRQ) -- 2.28 5.32
Price to Tangible Book (MRQ) -- 2.84 6.29
Price to Cash Flow (TTM) -- 5.11 9.62
% Owned Institutions -- 0.43 0.16

Dividends

  Company industry sector
Dividend Yield -- 1.14 2.53
Dividend Yield - 5 Year Avg -- 0.99 2.60
Dividend 5 Year Growth Rate -- 4.31 15.63
Payout Ratio(TTM) -- 21.99 40.55

Growth Rates

  Company industry sector
Sales (MRQ) vs Qtr. 1 Yr. Ago -- 5.97 11.48
Sales (TTM) vs TTM 1 Yr. Ago -- 1.12 9.72
Sales - 5 Yr. Growth Rate -- 7.70 11.21
EPS (MRQ) vs Qtr. 1 Yr. Ago -- 50.55 14.50
EPS (TTM) vs TTM 1 Yr. Ago -- -- --
EPS - 5 Yr. Growth Rate -- -4.52 12.23
Capital Spending - 5 Yr. Growth Rate -- 4.16 11.59

Financial Strength

  Company industry sector
Quick Ratio (MRQ) -- 0.79 0.89
Current Ratio (MRQ) -- 0.84 1.02
LT Debt to Equity (MRQ) -- 116.05 96.54
Total Debt to Equity (MRQ) -- 150.97 123.53
Interest Coverage (TTM) -- 368.25 88.99

Profitability Ratios

  Company industry sector
Gross Margin (TTM) -- 65.77 70.78
Gross Margin - 5 Yr. Avg. -- 60.29 69.32
EBITD Margin (TTM) -- -- --
EBITD - 5 Yr. Avg -- 36.48 50.70
Operating Margin (TTM) -- 12.93 34.99
Operating Margin - 5 Yr. Avg. -- 12.17 32.84
Pre-Tax Margin (TTM) -- 7.06 30.61
Pre-Tax Margin - 5 Yr. Avg. -- 6.25 28.06
Net Profit Margin (TTM) -- 6.08 23.24
Net Profit Margin - 5 Yr. Avg. -- 4.32 21.29
Effective Tax Rate (TTM) -- 5.49 20.82
Effective Tax Rate - 5 Yr. Avg. -- 17.26 23.12

Efficiency

  Company industry sector
Revenue/Employee (TTM) -- 5,315,152,733 5,212,457,987
Net Income/Employee (TTM) -- 150,254,629 1,224,428,178
Receivable Turnover (TTM) -- 15.75 10.50
Inventory Turnover (TTM) -- 60.33 38.13
Asset Turnover (TTM) -- 0.52 0.61

Management Effectiveness

  Company industry sector
Return on Assets (TTM) -- 3.60 14.03
Return on Assets - 5 Yr. Avg. -- 2.63 12.47
Return on Investment (TTM) -- 4.93 20.43
Return on Investment - 5 Yr. Avg. -- 3.50 18.64
Return on Equity (TTM) -- 10.44 24.08
Return on Equity - 5 Yr. Avg. -- 7.40 21.24
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 -- -- -- 18
13 Week -- -- -- 52
26 Week -- -- -- 34
52 Week -- -- -- 38
YTD -- -- -- 50
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.