X

Sign up for Equitymaster's free daily newsletter, The 5 Minute WrapUp and get access to our latest Multibagger guide (2017 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
  • 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 -20.1 -21.2 - View Chart
P/BV x 1.3 11.4 11.1% View Chart
Dividend Yield % 0.7 0.9 71.3%  

Financials

 IDEA CELLULAR   TATA COMM.
EQUITY SHARE DATA
    IDEA CELLULAR
Mar-16
TATA COMM.
Mar-17
IDEA CELLULAR/
TATA COMM.
5-Yr Chart
Click to enlarge
High Rs204784 26.0%   
Low Rs98373 26.1%   
Sales per share (Unadj.) Rs99.8618.2 16.1%  
Earnings per share (Unadj.) Rs8.6-26.7 -32.0%  
Cash flow per share (Unadj.) Rs23.038.7 59.3%  
Dividends per share (Unadj.) Rs0.606.00 10.0%  
Dividend yield (eoy) %0.41.0 38.4%  
Book value per share (Unadj.) Rs71.656.5 126.7%  
Shares outstanding (eoy) m3,600.51285.00 1,263.3%   
Bonus/Rights/Conversions ESOS--  
Price / Sales ratio x1.50.9 161.4%   
Avg P/E ratio x17.6-21.7 -81.4%  
P/CF ratio (eoy) x6.614.9 43.9%  
Price / Book Value ratio x2.110.2 20.6%  
Dividend payout %7.0-22.5 -31.2%   
Avg Mkt Cap Rs m542,777164,915 329.1%   
No. of employees `00012.54.1 307.4%   
Total wages/salary Rs m16,59928,394 58.5%   
Avg. sales/employee Rs Th28,768.943,355.6 66.4%   
Avg. wages/employee Rs Th1,328.96,986.7 19.0%   
Avg. net profit/employee Rs Th2,465.7-1,873.5 -131.6%   
INCOME DATA
Net Sales Rs m359,353176,197 203.9%  
Other income Rs m2,2713,603 63.0%   
Total revenues Rs m361,624179,800 201.1%   
Gross profit Rs m115,75124,059 481.1%  
Depreciation Rs m51,95918,658 278.5%   
Interest Rs m18,8163,672 512.4%   
Profit before tax Rs m47,2475,332 886.0%   
Minority Interest Rs m00-   
Prior Period Items Rs m051 0.0%   
Extraordinary Inc (Exp) Rs m0-10,633 0.0%   
Tax Rs m16,4472,364 695.8%   
Profit after tax Rs m30,799-7,614 -404.5%  
Gross profit margin %32.213.7 235.9%  
Effective tax rate %34.844.3 78.5%   
Net profit margin %8.6-4.3 -198.3%  
BALANCE SHEET DATA
Current assets Rs m46,39751,858 89.5%   
Current liabilities Rs m133,21283,922 158.7%   
Net working cap to sales %-24.2-18.2 132.8%  
Current ratio x0.30.6 56.4%  
Inventory Days Days10 272.1%  
Debtors Days Days1254 22.3%  
Net fixed assets Rs m743,904116,794 636.9%   
Share capital Rs m36,0052,850 1,263.3%   
"Free" reserves Rs m220,45613,253 1,663.5%   
Net worth Rs m257,65616,103 1,600.1%   
Long term debt Rs m365,68568,113 536.9%   
Total assets Rs m826,501211,023 391.7%  
Interest coverage x3.52.5 143.2%   
Debt to equity ratio x1.44.2 33.6%  
Sales to assets ratio x0.40.8 52.1%   
Return on assets %6.0-1.9 -321.3%  
Return on equity %12.0-47.3 -25.3%  
Return on capital %10.6-1.9 -565.5%  
Exports to sales %00-   
Imports to sales %9.13.5 256.5%   
Exports (fob) Rs mNANA-   
Imports (cif) Rs m32,5956,231 523.1%   
Fx inflow Rs m7,4858,985 83.3%   
Fx outflow Rs m36,9166,231 592.4%   
Net fx Rs m-29,4312,753 -1,068.9%   
CASH FLOW
From Operations Rs m118,14723,935 493.6%  
From Investments Rs m-129,9289,432 -1,377.5%  
From Financial Activity Rs m-97,486-32,757 297.6%  
Net Cashflow Rs m-109,267610 -17,909.7%  

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 INFRATEL  HIMACHAL FUTURISTIC  MTNL  BHARTI AIRTEL  TATA TELESERVICES  

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



Today's Market

Indian Indices Trade Marginally Higher; Pharma Sector Up 2.4%(11:30 am)

Stock markets in India are presently trading near the dotted line with positive bias. Sectoral indices are trading on a mixed note with stocks in the healthcare sector.

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: Profits Remain Flat (Quarterly Results Update - Detailed)

Apr 8, 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 December 2015.

Idea Cellular: Profits below par (Quarterly Results Update - Detailed)

Nov 23, 2015

Idea Cellular has reported a 14.8% YoY growth in the topline and an increase of 7.1% YoY in the bottomline for the quarter ended September 2015.

Bharti Airtel: A Good Quarterly Performance (Quarterly Results Update - Detailed)

May 6, 2016

Bharti Airtel has reported a8.4% YoY growth in the topline and an increase of 2.8% YoY in the bottomline for the quarter ended March 2016.

Bharti Infratel: Ends the Year Positively (Quarterly Results Update - Detailed)

Apr 27, 2016

Bharti Infratel has reported a 7.3% YoY growth in the topline and an increase of 18.7% YoY in the bottomline for the quarter ended March 2016.

More Views on News

Most Popular

This Small Cap Can Drive Chinese Players Out of India (and Make a Fortune in the Process)(The 5 Minute Wrapup)

Aug 17, 2017

A small-cap Indian company with high-return potential and blue-chip-like stability is set to supplant the Chinese players in this niche segment.

Dear PM Modi, India is Already Land of Self-Employed, and It Ain't Working(Vivek Kaul's Diary)

Aug 21, 2017

Most Indians who cannot find jobs, look at becoming self-employed.

It's the Best Time to Buy IT Stocks(Daily Profit Hunter)

Aug 16, 2017

The IT Sector could be in an uptrend till February 2019. Are you prepared to ride the trend?

5 Steps To Become Financially Independent(Outside View)

Aug 16, 2017

Ensure your financial Independence, and pledge to start the journey towards financial freedom today!

Think Twice Before You Keep Money In A Savings Bank Account(Outside View)

Aug 22, 2017

Post demonetisation, a cut in bank savings deposits rates was in the offing.

More

Become A Smarter Investor In
Just 5 Minutes

Multibagger Stocks Guide 2017
Get our special report, Multibagger Stocks Guide (2017 Edition) Now!
We will never sell or rent your email id.
Please read our Terms

IDEA CELLULAR SHARE PRICE


Aug 24, 2017 12:55 PM

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 - TATA COMM. COMPARISON

COMPARE IDEA CELLULAR WITH

MARKET STATS