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 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 -20.1 31.3 - View Chart
P/BV x 1.3 4.0 31.7% View Chart
Dividend Yield % 0.7 0.8 87.4%  

Financials

 IDEA CELLULAR   BHARTI INFRATEL
EQUITY SHARE DATA
    IDEA CELLULAR
Mar-16
BHARTI INFRATEL
Mar-16
IDEA CELLULAR/
BHARTI INFRATEL
5-Yr Chart
Click to enlarge
High Rs204505 40.4%   
Low Rs98342 28.6%   
Sales per share (Unadj.) Rs99.864.9 153.8%  
Earnings per share (Unadj.) Rs8.612.6 68.1%  
Cash flow per share (Unadj.) Rs23.024.5 93.7%  
Dividends per share (Unadj.) Rs0.603.00 20.0%  
Dividend yield (eoy) %0.40.7 56.2%  
Book value per share (Unadj.) Rs71.696.7 74.0%  
Shares outstanding (eoy) m3,600.511,896.67 189.8%   
Bonus/Rights/Conversions ESOS--  
Price / Sales ratio x1.56.5 23.2%   
Avg P/E ratio x17.633.7 52.3%  
P/CF ratio (eoy) x6.617.3 38.0%  
Price / Book Value ratio x2.14.4 48.1%  
Dividend payout %7.023.9 29.4%   
Avg Mkt Cap Rs m542,777802,860 67.6%   
No. of employees `00012.51.3 999.3%   
Total wages/salary Rs m16,5994,316 384.6%   
Avg. sales/employee Rs Th28,768.998,467.2 29.2%   
Avg. wages/employee Rs Th1,328.93,452.8 38.5%   
Avg. net profit/employee Rs Th2,465.719,056.0 12.9%   
INCOME DATA
Net Sales Rs m359,353123,084 292.0%  
Other income Rs m2,2717,438 30.5%   
Total revenues Rs m361,624130,522 277.1%   
Gross profit Rs m115,75153,660 215.7%  
Depreciation Rs m51,95922,693 229.0%   
Interest Rs m18,8162,198 856.1%   
Profit before tax Rs m47,24736,207 130.5%   
Minority Interest Rs m00-   
Prior Period Items Rs m00-   
Extraordinary Inc (Exp) Rs m00-   
Tax Rs m16,44712,387 132.8%   
Profit after tax Rs m30,79923,820 129.3%  
Gross profit margin %32.243.6 73.9%  
Effective tax rate %34.834.2 101.8%   
Net profit margin %8.619.4 44.3%  
BALANCE SHEET DATA
Current assets Rs m46,39762,244 74.5%   
Current liabilities Rs m133,21238,597 345.1%   
Net working cap to sales %-24.219.2 -125.7%  
Current ratio x0.31.6 21.6%  
Inventory Days Days10-  
Debtors Days Days126 210.5%  
Net fixed assets Rs m743,904147,113 505.7%   
Share capital Rs m36,00518,967 189.8%   
"Free" reserves Rs m220,456164,390 134.1%   
Net worth Rs m257,656183,479 140.4%   
Long term debt Rs m365,68510,767 3,396.3%   
Total assets Rs m826,501269,189 307.0%  
Interest coverage x3.517.5 20.1%   
Debt to equity ratio x1.40.1 2,418.6%  
Sales to assets ratio x0.40.5 95.1%   
Return on assets %6.09.7 62.1%  
Return on equity %12.013.0 92.1%  
Return on capital %10.619.8 53.6%  
Exports to sales %00-   
Imports to sales %9.10-   
Exports (fob) Rs mNANA-   
Imports (cif) Rs m32,595NA-   
Fx inflow Rs m7,4850-   
Fx outflow Rs m36,9165 738,318.0%   
Net fx Rs m-29,431-5 588,628.0%   
CASH FLOW
From Operations Rs m118,14743,947 268.8%  
From Investments Rs m-129,9282,478 -5,243.3%  
From Financial Activity Rs m-97,486-26,273 371.1%  
Net Cashflow Rs m-109,26720,152 -542.2%  

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:   BHARTI AIRTEL  HIMACHAL FUTURISTIC  MTNL  RELIANCE COMMUNICATIONS  TATA COMM.  

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



Today's Market

Global Markets Remain Volatile Ahead of US Growth Concerns(RoundUp)

Benchmark indices in US corrected marginally by 0.8% during the week. Minutes of Federal Reserve's July meeting are out and the situation looks to be in favor of the emerging markets.

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 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.

More Views on News

Most Popular

Demonetisation Barely Made Any Difference to Tax Collections(Vivek Kaul's Diary)

Aug 7, 2017

The data tells us quite a different story from the one the government is trying to project.

A 'Backdoor' to Multibaggers: It's Like Investing in Asian Paints Ten Years Ago(The 5 Minute Wrapup)

Aug 10, 2017

Don't miss these proxy bets on growing companies or in a few years you will be looking back with regret.

Should You Invest In Bharat-22 ETF? Know Here...(Outside View)

Aug 8, 2017

Bharat-22 is one of the most diverse ETFs offered so far by the Government. Know here if you should invest...

Signs of Life in the India VIX(Daily Profit Hunter)

Aug 12, 2017

The India VIX is up 36% in the last week. Fear has gone up but is still low by historical standards.

7 Financial Gifts For Your Sister This Raksha Bandhan(Outside View)

Aug 7, 2017

Raksha Bandhan signifies the brother-sister bond. Here are 7 thoughtful financial gifts for sisters...

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 18, 2017 (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 8-QTR ANALYSIS

COMPARE IDEA CELLULAR WITH

MARKET STATS