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 12.4 -36.8 - View Chart
P/BV x 0.7 29.8 2.2% View Chart
Dividend Yield % 0.0 0.9 -  

Financials

 IDEA CELLULAR   TATA COMM.
EQUITY SHARE DATA
    IDEA CELLULAR
Mar-17
TATA COMM.
Mar-18
IDEA CELLULAR/
TATA COMM.
5-Yr Chart
Click to enlarge
High Rs128774 16.5%   
Low Rs66571 11.6%   
Sales per share (Unadj.) Rs98.7584.2 16.9%  
Earnings per share (Unadj.) Rs-1.1-11.4 9.7%  
Cash flow per share (Unadj.) Rs20.655.5 37.1%  
Dividends per share (Unadj.) Rs04.50 0.0%  
Dividend yield (eoy) %00.7 0.0%  
Book value per share (Unadj.) Rs68.617.5 391.5%  
Shares outstanding (eoy) m3,605.33285.00 1,265.0%   
Bonus/Rights/Conversions ESOS--  
Price / Sales ratio x1.01.2 85.5%   
Avg P/E ratio x-87.5-58.9 148.7%  
P/CF ratio (eoy) x4.712.1 38.9%  
Price / Book Value ratio x1.438.4 3.7%  
Dividend payout %0-39.4 0.0%   
Avg Mkt Cap Rs m349,897191,648 182.6%   
No. of employees `00011.84.5 260.9%   
Total wages/salary Rs m17,97729,775 60.4%   
Avg. sales/employee Rs Th30,189.936,862.6 81.9%   
Avg. wages/employee Rs Th1,525.56,591.8 23.1%   
Avg. net profit/employee Rs Th-339.2-720.9 47.1%   
INCOME DATA
Net Sales Rs m355,757166,508 213.7%  
Other income Rs m3,0693,805 80.7%   
Total revenues Rs m358,827170,314 210.7%   
Gross profit Rs m102,47322,914 447.2%  
Depreciation Rs m78,27219,063 410.6%   
Interest Rs m40,1213,445 1,164.8%   
Profit before tax Rs m-12,8514,211 -305.1%   
Minority Interest Rs m4,2180-   
Prior Period Items Rs m0-163 0.0%   
Extraordinary Inc (Exp) Rs m0-3,755 0.0%   
Tax Rs m-4,6353,549 -130.6%   
Profit after tax Rs m-3,997-3,256 122.8%  
Gross profit margin %28.813.8 209.3%  
Effective tax rate %36.184.3 42.8%   
Net profit margin %-1.1-2.0 57.5%  
BALANCE SHEET DATA
Current assets Rs m76,30949,922 152.9%   
Current liabilities Rs m170,61592,374 184.7%   
Net working cap to sales %-26.5-25.5 104.0%  
Current ratio x0.40.5 82.8%  
Inventory Days Days11 102.0%  
Debtors Days Days1363 21.3%  
Net fixed assets Rs m241,746113,169 213.6%   
Share capital Rs m36,0532,850 1,265.0%   
"Free" reserves Rs m211,2692,143 9,857.7%   
Net worth Rs m247,3224,993 4,953.2%   
Long term debt Rs m516,37858,983 875.5%   
Total assets Rs m967,047196,028 493.3%  
Interest coverage x0.72.2 30.6%   
Debt to equity ratio x2.111.8 17.7%  
Sales to assets ratio x0.40.8 43.3%   
Return on assets %3.70.1 3,886.7%  
Return on equity %-1.6-65.2 2.5%  
Return on capital %4.15.8 70.6%  
Exports to sales %00-   
Imports to sales %00-   
Exports (fob) Rs mNANA-   
Imports (cif) Rs mNANA-   
Fx inflow Rs m6,7387,282 92.5%   
Fx outflow Rs m35,3384,653 759.5%   
Net fx Rs m-28,6002,629 -1,087.7%   
CASH FLOW
From Operations Rs m105,37317,128 615.2%  
From Investments Rs m-155,557-5,037 3,088.5%  
From Financial Activity Rs m44,445-9,591 -463.4%  
Net Cashflow Rs m-5,7392,536 -226.3%  

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:   TELEKOM INDO. (Indonesia)  FRANCE TELECOM (France)  VERIZON (US)  CHINA MOBILE (Hong Kong)  



Today's Market

Sensex Ends 170 Points Lower, Realty and FMCG Stocks Witness Selling(Closing)

After opening the day on a positive note, share markets in India witnessed volatile trading activity and ended in red.

Related Views on News

TATA COMM. Announces Quarterly Results (1QFY19); Net Profit Down 260.3% (Quarterly Result Update)

Aug 13, 2018 | Updated on Aug 13, 2018

For the quarter ended June 2018, TATA COMM. has posted a net profit of Rs 580 m (down 260.3% YoY). Sales on the other hand came in at Rs 39 bn (down 9.2% YoY). Read on for a complete analysis of TATA COMM.'s quarterly results.

IDEA CELLULAR Announces Quarterly Results (1QFY19); Net Profit Down 121.9% (Quarterly Result Update)

Jul 31, 2018 | Updated on Jul 31, 2018

For the quarter ended June 2018, IDEA CELLULAR has posted a net profit of Rs 2 bn (down 121.9% YoY). Sales on the other hand came in at Rs 59 bn (down 27.9% YoY). Read on for a complete analysis of IDEA CELLULAR's quarterly results.

TATA COMM. Announces Quarterly Results (4QFY18); Net Profit Down 88.3% (Quarterly Result Update)

Jul 20, 2018 | Updated on Jul 20, 2018

For the quarter ended March 2018, TATA COMM. has posted a net profit of Rs 1 bn (down 88.3% YoY). Sales on the other hand came in at Rs 40 bn (down 6.6% YoY). Read on for a complete analysis of TATA COMM.'s quarterly results.

IDEA CELLULAR Announces Quarterly Results (4QFY18); Net Profit Down 343.4% (Quarterly Result Update)

Jul 20, 2018 | Updated on Jul 20, 2018

For the quarter ended March 2018, IDEA CELLULAR has posted a net profit of Rs 10 bn (down 343.4% YoY). Sales on the other hand came in at Rs 61 bn (down 24.5% YoY). Read on for a complete analysis of IDEA CELLULAR's quarterly results.

More Views on News

Most Popular

Is It the Right Time to Buy Pharma Stocks Now?(The 5 Minute Wrapup)

Sep 12, 2018

Is the pharma sector poised for a comeback? Is the worst over? I believe so.

Want Bigger Returns Than You Thought Possible? This is Where You Should Look(Profit Hunter)

Sep 12, 2018

Richa has discovered the single most profitable opportunity in the market - read on to discover more...

The Secret Of Mirae Asset India Equity Fund's Increasing Popularity(Outside View)

Sep 7, 2018

The prudent investment strategies followed at the fund house has helped Mirae Asset India Equity Fund earn a tag of being a consistent performer, which is in turn gaining popularity among investors.

Should You Be Worried About the Rising Dollar?(Chart Of The Day)

Sep 7, 2018

While the rupee has deprecated by about 5% annually since 1990 against the dollar, the BSE Sensex has returned 14% annually in the same period.

Revenge of the Ratings Agencies(Vivek Kaul's Diary)

Sep 7, 2018

Do you remember when ratings agencies ruled financial markets? Nick explains why he thinks it's time to prepare yourselves for a comeback of the ratings agencies.

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


Sep 19, 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 - RELIANCE COMMUNICATIONS COMPARISON

COMPARE IDEA CELLULAR WITH

MARKET STATS