Edition:
United Kingdom

Idea Cellular Ltd (IDEA.NS)

IDEA.NS on National Stock Exchange of India

54.65INR
11:29am BST
Change (% chg)

Rs-0.25 (-0.46%)
Prev Close
Rs54.90
Open
Rs55.00
Day's High
Rs56.10
Day's Low
Rs54.05
Volume
11,624,433
Avg. Vol
14,952,460
52-wk High
Rs118.90
52-wk Low
Rs50.10

Revenue & Earnings Per Share

    Revenue* Earnings Per Share**
FY 2018 Mar '18 60,336.00 -3.010
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) -- 36.22 19.29
P/E High - Last 5 Yrs. -- 46.67 42.82
P/E Low - Last 5 Yrs. -- 21.31 15.71
Beta -- 0.80 0.73
Price to Sales (TTM) -- 1.22 2.65
Price to Book (MRQ) -- 1.65 3.28
Price to Tangible Book (MRQ) -- 1.75 3.55
Price to Cash Flow (TTM) -- 4.44 6.53
% Owned Institutions -- 0.53 0.21

Dividends

  Company industry sector
Dividend Yield -- 1.70 4.05
Dividend Yield - 5 Year Avg -- 1.32 2.74
Dividend 5 Year Growth Rate -- 6.56 13.65
Payout Ratio(TTM) -- 40.22 73.29

Growth Rates

  Company industry sector
Sales (MRQ) vs Qtr. 1 Yr. Ago -- -1.80 3.29
Sales (TTM) vs TTM 1 Yr. Ago -- 3.04 6.79
Sales - 5 Yr. Growth Rate -- 7.68 10.03
EPS (MRQ) vs Qtr. 1 Yr. Ago -- -103.35 -1.95
EPS (TTM) vs TTM 1 Yr. Ago -- -- --
EPS - 5 Yr. Growth Rate -- 3.37 11.91
Capital Spending - 5 Yr. Growth Rate -- 2.33 22.66

Financial Strength

  Company industry sector
Quick Ratio (MRQ) -- 0.89 1.04
Current Ratio (MRQ) -- 0.94 1.13
LT Debt to Equity (MRQ) -- 109.23 75.56
Total Debt to Equity (MRQ) -- 140.80 89.21
Interest Coverage (TTM) -- 60.46 45.58

Profitability Ratios

  Company industry sector
Gross Margin (TTM) -- 60.94 67.11
Gross Margin - 5 Yr. Avg. -- 55.15 67.57
EBITD Margin (TTM) -- -- --
EBITD - 5 Yr. Avg -- 34.01 49.16
Operating Margin (TTM) -- 13.20 31.57
Operating Margin - 5 Yr. Avg. -- 12.49 32.12
Pre-Tax Margin (TTM) -- 8.03 27.18
Pre-Tax Margin - 5 Yr. Avg. -- 7.65 28.10
Net Profit Margin (TTM) -- 7.86 22.81
Net Profit Margin - 5 Yr. Avg. -- 5.78 21.79
Effective Tax Rate (TTM) -- -38.47 5.33
Effective Tax Rate - 5 Yr. Avg. -- -175.22 -12.81

Efficiency

  Company industry sector
Revenue/Employee (TTM) -- 4,454,555,981 5,117,417,096
Net Income/Employee (TTM) -- 74,925,420 1,203,871,412
Receivable Turnover (TTM) -- 17.81 12.21
Inventory Turnover (TTM) -- 66.31 58.53
Asset Turnover (TTM) -- 0.50 0.58

Management Effectiveness

  Company industry sector
Return on Assets (TTM) -- 4.19 12.67
Return on Assets - 5 Yr. Avg. -- 3.43 12.77
Return on Investment (TTM) -- 5.59 18.47
Return on Investment - 5 Yr. Avg. -- 4.54 18.97
Return on Equity (TTM) -- 10.44 23.00
Return on Equity - 5 Yr. Avg. -- 9.16 22.23
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 -- -- -- 5
13 Week -- -- -- 5
26 Week -- -- -- 1
52 Week -- -- -- 4
YTD -- -- -- 6
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.