Edition:
United Kingdom

Idea Cellular Ltd (IDEA.NS)

IDEA.NS on National Stock Exchange of India

50.60INR
16 Aug 2018
Change (% chg)

Rs-1.40 (-2.69%)
Prev Close
Rs52.00
Open
Rs51.95
Day's High
Rs52.35
Day's Low
Rs50.45
Volume
8,490,892
Avg. Vol
17,539,543
52-wk High
Rs118.90
52-wk Low
Rs48.30

Revenue & Earnings Per Share

    Revenue* Earnings Per Share**
FY 2019 Jun 58,268.00 1.330
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) -- 60.95 27.92
P/E High - Last 5 Yrs. -- 59.86 44.17
P/E Low - Last 5 Yrs. -- 20.31 14.76
Beta -- 0.68 0.78
Price to Sales (TTM) -- 1.63 3.85
Price to Book (MRQ) -- 2.19 5.37
Price to Tangible Book (MRQ) -- 3.33 6.46
Price to Cash Flow (TTM) -- 5.37 9.76
% Owned Institutions -- 0.61 0.18

Dividends

  Company industry sector
Dividend Yield -- 1.36 2.60
Dividend Yield - 5 Year Avg -- 1.17 2.66
Dividend 5 Year Growth Rate -- 4.90 16.00
Payout Ratio(TTM) -- 25.98 41.65

Growth Rates

  Company industry sector
Sales (MRQ) vs Qtr. 1 Yr. Ago -- 6.51 11.70
Sales (TTM) vs TTM 1 Yr. Ago -- 1.34 9.96
Sales - 5 Yr. Growth Rate -- 4.75 10.81
EPS (MRQ) vs Qtr. 1 Yr. Ago -- 75.79 17.98
EPS (TTM) vs TTM 1 Yr. Ago -- -- --
EPS - 5 Yr. Growth Rate -- -8.73 11.91
Capital Spending - 5 Yr. Growth Rate -- 1.79 11.38

Financial Strength

  Company industry sector
Quick Ratio (MRQ) -- 0.85 0.90
Current Ratio (MRQ) -- 0.90 1.04
LT Debt to Equity (MRQ) -- 76.15 89.55
Total Debt to Equity (MRQ) -- 100.24 114.58
Interest Coverage (TTM) -- 625.06 125.13

Profitability Ratios

  Company industry sector
Gross Margin (TTM) -- 70.33 71.65
Gross Margin - 5 Yr. Avg. -- 63.73 70.11
EBITD Margin (TTM) -- -- --
EBITD - 5 Yr. Avg -- 37.77 51.25
Operating Margin (TTM) -- 13.25 35.57
Operating Margin - 5 Yr. Avg. -- 12.30 33.35
Pre-Tax Margin (TTM) -- 8.13 31.32
Pre-Tax Margin - 5 Yr. Avg. -- 5.66 28.47
Net Profit Margin (TTM) -- 6.14 23.65
Net Profit Margin - 5 Yr. Avg. -- 3.86 21.60
Effective Tax Rate (TTM) -- 19.90 23.56
Effective Tax Rate - 5 Yr. Avg. -- 15.67 22.94

Efficiency

  Company industry sector
Revenue/Employee (TTM) -- 6,042,540,466 5,334,484,846
Net Income/Employee (TTM) -- 170,413,419 1,253,575,806
Receivable Turnover (TTM) -- 18.51 10.81
Inventory Turnover (TTM) -- 64.72 38.37
Asset Turnover (TTM) -- 0.54 0.62

Management Effectiveness

  Company industry sector
Return on Assets (TTM) -- 3.93 14.33
Return on Assets - 5 Yr. Avg. -- 2.61 12.70
Return on Investment (TTM) -- 5.31 20.86
Return on Investment - 5 Yr. Avg. -- 3.37 18.97
Return on Equity (TTM) -- 8.47 24.08
Return on Equity - 5 Yr. Avg. -- 4.34 21.07
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 -- -- -- 10
13 Week -- -- -- 53
26 Week -- -- -- 31
52 Week -- -- -- 31
YTD -- -- -- 52
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.