X

Sign up for Equitymaster's free daily newsletter, The 5 Minute WrapUp and get access to our latest Multibagger guide (2018 Edition) on picking money-making stocks.

This is an entirely free service. No payments are to be made.


Download Now Subscribe to our free daily e-letter, The 5 Minute WrapUp and get this complimentary report.
We hate spam as much as you do. Check out our Privacy Policy and Terms Of Use.
Compare Idea Cellular with Tata Comm. - Equitymaster

Helping You Build Wealth With Honest Research
Since 1996. Try Now

  • MyStocks

MEMBER'S LOGINX

     
Login Failure
   
     
   
     
 
 
 
(Please do not use this option on a public machine)
 
     
 
 
 
  Sign Up | Forgot Password?  

IDEA CELLULAR vs TATA COMM. - Comparison Results

IDEA CELLULAR    Change

Idea Cellular is the third largest operator in the GSM space with 12.3% share of the Indian wireless telecom market (as at the end of FY12) and having a subscriber base of over 112.7 m. The company provides services in all the 22 telecom circles. Ide... More

TATA COMM. 
   Change

Tata Communications (erstwhile VSNL) is the largest and incumbent international long distance (ILD) telephony services operator in the country. Being the pioneer of Internet services in the country, VSNL provides international telecommunication servi... More

DO YOU LIKE THESE REPORTS? TELL US!

Current Valuations

    IDEA CELLULAR TATA COMM. IDEA CELLULAR/
TATA COMM.
 
P/E (TTM) x 93.6 -55.7 - View Chart
P/BV x 0.9 10.7 8.3% View Chart
Dividend Yield % 0.0 1.0 -  

Financials

 IDEA CELLULAR   TATA COMM.
EQUITY SHARE DATA
    IDEA CELLULAR
Mar-17
TATA COMM.
Mar-17
IDEA CELLULAR/
TATA COMM.
5-Yr Chart
Click to enlarge
High Rs128784 16.3%   
Low Rs66373 17.7%   
Sales per share (Unadj.) Rs98.7618.2 16.0%  
Earnings per share (Unadj.) Rs-1.1-26.7 4.1%  
Cash flow per share (Unadj.) Rs20.638.7 53.2%  
Dividends per share (Unadj.) Rs06.00 0.0%  
Dividend yield (eoy) %01.0 0.0%  
Book value per share (Unadj.) Rs68.656.5 121.4%  
Shares outstanding (eoy) m3,605.33285.00 1,265.0%   
Bonus/Rights/Conversions ESOS--  
Price / Sales ratio x1.00.9 105.1%   
Avg P/E ratio x-87.5-21.7 404.2%  
P/CF ratio (eoy) x4.714.9 31.5%  
Price / Book Value ratio x1.410.2 13.8%  
Dividend payout %0-22.5 0.0%   
Avg Mkt Cap Rs m349,897164,915 212.2%   
No. of employees `00011.84.1 290.0%   
Total wages/salary Rs m17,97728,394 63.3%   
Avg. sales/employee Rs Th30,189.943,355.6 69.6%   
Avg. wages/employee Rs Th1,525.56,986.7 21.8%   
Avg. net profit/employee Rs Th-339.2-1,873.5 18.1%   
INCOME DATA
Net Sales Rs m355,757176,197 201.9%  
Other income Rs m3,0693,603 85.2%   
Total revenues Rs m358,827179,800 199.6%   
Gross profit Rs m102,47324,059 425.9%  
Depreciation Rs m78,27218,658 419.5%   
Interest Rs m40,1213,672 1,092.6%   
Profit before tax Rs m-12,8515,332 -241.0%   
Minority Interest Rs m4,2180-   
Prior Period Items Rs m051 0.0%   
Extraordinary Inc (Exp) Rs m0-10,633 0.0%   
Tax Rs m-4,6352,364 -196.1%   
Profit after tax Rs m-3,997-7,614 52.5%  
Gross profit margin %28.813.7 210.9%  
Effective tax rate %36.144.3 81.4%   
Net profit margin %-1.1-4.3 26.0%  
BALANCE SHEET DATA
Current assets Rs m76,30951,858 147.2%   
Current liabilities Rs m170,61583,922 203.3%   
Net working cap to sales %-26.5-18.2 145.7%  
Current ratio x0.40.6 72.4%  
Inventory Days Days10 151.7%  
Debtors Days Days1354 25.1%  
Net fixed assets Rs m241,746116,794 207.0%   
Share capital Rs m36,0532,850 1,265.0%   
"Free" reserves Rs m211,26913,253 1,594.2%   
Net worth Rs m247,32216,103 1,535.9%   
Long term debt Rs m516,37868,113 758.1%   
Total assets Rs m967,047211,023 458.3%  
Interest coverage x0.72.5 27.7%   
Debt to equity ratio x2.14.2 49.4%  
Sales to assets ratio x0.40.8 44.1%   
Return on assets %3.7-1.9 -200.0%  
Return on equity %-1.6-47.3 3.4%  
Return on capital %4.1-1.9 -220.0%  
Exports to sales %00-   
Imports to sales %03.5 0.0%   
Exports (fob) Rs mNANA-   
Imports (cif) Rs mNA6,231 0.0%   
Fx inflow Rs m6,7388,985 75.0%   
Fx outflow Rs m35,3386,231 567.1%   
Net fx Rs m-28,6002,753 -1,038.7%   
CASH FLOW
From Operations Rs m105,37323,935 440.2%  
From Investments Rs m-155,5579,432 -1,649.2%  
From Financial Activity Rs m44,445-32,757 -135.7%  
Net Cashflow Rs m-5,739610 -940.6%  

Share Holding

Indian Promoters % 42.9 75.0 57.2%  
Foreign collaborators % 0.0 0.0 -  
Indian inst/Mut Fund % 4.5 11.6 39.1%  
FIIs % 21.6 7.9 273.4%  
ADR/GDR % 0.0 0.0 -  
Free float % 30.9 5.5 561.8%  
Shareholders   266,634 56,463 472.2%  
Pledged promoter(s) holding % 0.0 4.7 -  
NM: Not Meaningful
Source: Company Annual Reports, Regulatory Filings, Equitymaster

Compare IDEA CELLULAR With:   BHARTI AIRTEL  TATA TELESERVICES  HIMACHAL FUTURISTIC  RELIANCE COMMUNICATIONS  BHARTI INFRATEL  

Compare IDEA CELLULAR With:   TELEKOM INDO. (Indonesia)  FRANCE TELECOM (France)  VERIZON (US)  CHINA MOBILE (Hong Kong)  



Today's Market

Of Analysis of IPOs Launched in 2018, Governments Effort to Boost Aviation Infrastructure and Key Stocks in Action Today(Pre-Open)

The returns from initial public offers (IPOs) launched in 2018 are mixed. Comparing the gain/ (loss) since the listing date as mentioned in the last column, seven stocks are in the negative territory.

Related Views on News

Idea Cellular: Interest Costs Hurt Profits (Quarterly Results Update - Detailed)

Jul 4, 2016

Idea Cellular has reported a 12.4% YoY growth in the topline and a decrease of 0.4% YoY in the bottomline for the quarter ended March 2016.

Idea Cellular: Interest Costs Hurt Profits (Quarterly Results Update - Detailed)

Jul 4, 2016

Idea Cellular has reported a 12.4% YoY growth in the topline and a decrease of 0.4% YoY in the bottomline for the quarter ended March 2016.

More Views on News

Most Popular

Alert: Pharma Stocks Are About to Shoot Up - And a Superb Stock for Trading(Profit Hunter)

Jun 13, 2018

The ailing pharma stocks are bouncing back to health. Read this to find out the best way to profit from them.

Will You Dump Your Client if You're Busy? Inox Wind's Auditor Just Did...(The 5 Minute Wrapup)

Jun 14, 2018

After Inox Wind, you may see more auditors resigning And the reasons can be as funny as they can get.

GST Will Not Solve Problem of High Prices of Petrol and Diesel(Vivek Kaul's Diary)

Jun 13, 2018

Though it will bring transparency in their pricing and that in itself will be a welcome move.

Has the Market Bottomed Out?(Sector Info)

Jun 11, 2018

The yield spread is an effective barometer that can indicate the direction the markets are headed.

Should You Invest In Mirae Asset Healthcare Fund?(Outside View)

Jun 15, 2018

Mirae Asset Mutual Fund launches NFO - Mirae Asset Helathcare Fund.

More

Small Investments
BIG Returns

Zero To Millions Guide 2018
Get our special report, Zero To Millions
(2018 Edition) Now!
We will never sell or rent your email id.
Please read our Terms

IDEA CELLULAR SHARE PRICE


Jun 21, 2018 (Close)

TRACK IDEA CELLULAR

  • Track your investment in IDEA CELLULAR with Equitymaster's Portfolio Tracker. Set live price alerts, get research alerts and more. Get access now...
  • Add To MyStocks

IDEA CELLULAR 5-YR ANALYSIS

COMPARE IDEA CELLULAR WITH

MARKET STATS