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 Bharti Infratel - Equitymaster
  • MyStocks

MEMBER'S LOGINX

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

IDEA CELLULAR vs BHARTI INFRATEL - 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

DO YOU LIKE THESE REPORTS? TELL US!

Current Valuations

    IDEA CELLULAR BHARTI INFRATEL IDEA CELLULAR/
BHARTI INFRATEL
 
P/E (TTM) x -18.4 33.5 - View Chart
P/BV x 1.2 4.0 29.7% View Chart
Dividend Yield % 0.0 4.7 -  

Financials

 IDEA CELLULAR   BHARTI INFRATEL
EQUITY SHARE DATA
    IDEA CELLULAR
Mar-17
BHARTI INFRATEL
Mar-17
IDEA CELLULAR/
BHARTI INFRATEL
5-Yr Chart
Click to enlarge
High Rs128413 31.0%   
Low Rs66283 23.3%   
Sales per share (Unadj.) Rs98.732.9 300.0%  
Earnings per share (Unadj.) Rs-1.114.9 -7.5%  
Cash flow per share (Unadj.) Rs20.621.4 96.1%  
Dividends per share (Unadj.) Rs016.00 0.0%  
Dividend yield (eoy) %04.6 0.0%  
Book value per share (Unadj.) Rs68.683.8 81.9%  
Shares outstanding (eoy) m3,605.331,849.61 194.9%   
Bonus/Rights/Conversions ESOS--  
Price / Sales ratio x1.010.6 9.3%   
Avg P/E ratio x-87.523.4 -373.8%  
P/CF ratio (eoy) x4.716.2 29.0%  
Price / Book Value ratio x1.44.2 34.1%  
Dividend payout %0107.7 0.0%   
Avg Mkt Cap Rs m349,897643,387 54.4%   
No. of employees `00011.81.3 934.5%   
Total wages/salary Rs m17,9772,746 654.6%   
Avg. sales/employee Rs Th30,189.948,253.0 62.6%   
Avg. wages/employee Rs Th1,525.52,177.6 70.1%   
Avg. net profit/employee Rs Th-339.221,784.3 -1.6%   
INCOME DATA
Net Sales Rs m355,75760,847 584.7%  
Other income Rs m3,069711 431.7%   
Total revenues Rs m358,82761,558 582.9%   
Gross profit Rs m102,47328,761 356.3%  
Depreciation Rs m78,27212,167 643.3%   
Interest Rs m40,121-6,542 -613.3%   
Profit before tax Rs m-12,85123,847 -53.9%   
Minority Interest Rs m4,21811,950 35.3%   
Prior Period Items Rs m00-   
Extraordinary Inc (Exp) Rs m00-   
Tax Rs m-4,6358,327 -55.7%   
Profit after tax Rs m-3,99727,470 -14.6%  
Gross profit margin %28.847.3 60.9%  
Effective tax rate %36.134.9 103.3%   
Net profit margin %-1.145.1 -2.5%  
BALANCE SHEET DATA
Current assets Rs m76,30947,118 162.0%   
Current liabilities Rs m170,61543,952 388.2%   
Net working cap to sales %-26.55.2 -509.5%  
Current ratio x0.41.1 41.7%  
Inventory Days Days10-  
Debtors Days Days139 148.3%  
Net fixed assets Rs m241,746114,036 212.0%   
Share capital Rs m36,05318,496 194.9%   
"Free" reserves Rs m211,269136,497 154.8%   
Net worth Rs m247,322154,993 159.6%   
Long term debt Rs m516,3780-   
Total assets Rs m967,047207,628 465.8%  
Interest coverage x0.7-2.6 -25.7%   
Debt to equity ratio x2.10-  
Sales to assets ratio x0.40.3 125.5%   
Return on assets %3.710.1 37.1%  
Return on equity %-1.617.7 -9.1%  
Return on capital %4.118.9 21.8%  
Exports to sales %00-   
Imports to sales %00-   
Exports (fob) Rs mNANA-   
Imports (cif) Rs mNANA-   
Fx inflow Rs m6,7380-   
Fx outflow Rs m35,3380-   
Net fx Rs m-28,6000-   
CASH FLOW
From Operations Rs m105,37328,662 367.6%  
From Investments Rs m-155,557-2,434 6,391.0%  
From Financial Activity Rs m44,445-26,648 -166.8%  
Net Cashflow Rs m-5,739-420 1,366.4%  

Share Holding

Indian Promoters % 42.9 79.4 54.1%  
Foreign collaborators % 0.0 0.0 -  
Indian inst/Mut Fund % 4.5 1.7 271.3%  
FIIs % 21.6 11.7 185.4%  
ADR/GDR % 0.0 0.0 -  
Free float % 30.9 7.3 423.3%  
Shareholders   266,634 27,584 966.6%  
Pledged promoter(s) holding % 0.0 0.0 -  
NM: Not Meaningful
Source: Company Annual Reports, Regulatory Filings, Equitymaster

Compare IDEA CELLULAR With:   TATA TELESERVICES  HIMACHAL FUTURISTIC  TATA COMM.  BHARTI AIRTEL  MTNL  

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



Today's Market

Indian Indices Trade Strong; Metal, Pharma Stocks Lead Gains(01:30 pm)

After opening the day in green, share markets in India have continued the momentum and are presently trading above the dotted line.

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.

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.

Bharti Infratel: A Good Quarter (Quarterly Results Update - Detailed)

Apr 8, 2016

Bharti Infratel has reported a 4.9% YoY growth in the topline and an increase of 11.5% YoY in the bottomline for the quarter ended December 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.

More Views on News

Most Popular

The Foundation for Sensex 100,000 is Laid(The 5 Minute Wrapup)

Feb 17, 2018

Top three reasons for Tanushree's presentation at Equitymaster Conference to be centered around a possible 30% correction.

India's Rs 1,66,276 Crore Problem(Vivek Kaul's Diary)

Feb 15, 2018

That's the loss, the government owned public sector enterprises are expected to make this year.

The Big Gamble(The Honest Truth)

Feb 15, 2018

Once you accept the fact that elections are round the corner and that this budget is geared to reach a 40% target, everything makes sense.

How I Beat the Index by 2x... And Why I Believe This Could Happen Again(Smart Contrarian)

Feb 12, 2018

Will Microcap Millionaires be able to replicate its past performance of beating the index by 2x?

NPAs Set to Rise Further with New RBI Rules(Chart Of The Day)

Feb 15, 2018

The RBI overhauls bad loan framework. Banks may come under additional pressure due to rising NPAs and increased provisioning.

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


Feb 23, 2018 03:35 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 5-YR ANALYSIS

COMPARE IDEA CELLULAR WITH

MARKET STATS