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 Airtel - 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 AIRTEL - 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

BHARTI AIRTEL 
   Change

Bharti Airtel is the largest mobile telephony operator in the GSM space with 19.8% share of the Indian wireless market (as at the end of FY12). The company, apart from being the largest player in the mobile segment with subscribers in all the 22-tele... More

DO YOU LIKE THESE REPORTS? TELL US!

Current Valuations

    IDEA CELLULAR BHARTI AIRTEL IDEA CELLULAR/
BHARTI AIRTEL
 
P/E (TTM) x -20.2 61.6 - View Chart
P/BV x 1.3 2.6 48.1% View Chart
Dividend Yield % 0.7 0.3 210.4%  

Financials

 IDEA CELLULAR   BHARTI AIRTEL
EQUITY SHARE DATA
    IDEA CELLULAR
Mar-16
BHARTI AIRTEL
Mar-16
IDEA CELLULAR/
BHARTI AIRTEL
5-Yr Chart
Click to enlarge
High Rs204453 45.1%   
Low Rs98282 34.6%   
Sales per share (Unadj.) Rs99.8241.5 41.3%  
Earnings per share (Unadj.) Rs8.613.7 62.4%  
Cash flow per share (Unadj.) Rs23.057.4 40.1%  
Dividends per share (Unadj.) Rs0.601.36 44.1%  
Dividend yield (eoy) %0.40.4 107.5%  
Book value per share (Unadj.) Rs71.6164.2 43.6%  
Shares outstanding (eoy) m3,600.513,997.40 90.1%   
Bonus/Rights/Conversions ESOS--  
Price / Sales ratio x1.51.5 99.3%   
Avg P/E ratio x17.626.8 65.8%  
P/CF ratio (eoy) x6.66.4 102.4%  
Price / Book Value ratio x2.12.2 94.1%  
Dividend payout %7.09.9 70.8%   
Avg Mkt Cap Rs m542,7771,468,645 37.0%   
No. of employees `00012.5NA-   
Total wages/salary Rs m16,59949,112 33.8%   
Avg. sales/employee Rs Th28,768.9NM-  
Avg. wages/employee Rs Th1,328.9NM-  
Avg. net profit/employee Rs Th2,465.7NM-  
INCOME DATA
Net Sales Rs m359,353965,321 37.2%  
Other income Rs m2,27111,098 20.5%   
Total revenues Rs m361,624976,419 37.0%   
Gross profit Rs m115,751369,147 31.4%  
Depreciation Rs m51,959174,498 29.8%   
Interest Rs m18,81685,042 22.1%   
Profit before tax Rs m47,247120,705 39.1%   
Minority Interest Rs m0-6,495 0.0%   
Prior Period Items Rs m00-   
Extraordinary Inc (Exp) Rs m00-   
Tax Rs m16,44759,368 27.7%   
Profit after tax Rs m30,79954,842 56.2%  
Gross profit margin %32.238.2 84.2%  
Effective tax rate %34.849.2 70.8%   
Net profit margin %8.65.7 150.9%  
BALANCE SHEET DATA
Current assets Rs m46,397221,737 20.9%   
Current liabilities Rs m133,212582,321 22.9%   
Net working cap to sales %-24.2-37.4 64.7%  
Current ratio x0.30.4 91.5%  
Inventory Days Days11 169.1%  
Debtors Days Days1228 43.3%  
Net fixed assets Rs m743,904654,183 113.7%   
Share capital Rs m36,00519,987 180.1%   
"Free" reserves Rs m220,456588,554 37.5%   
Net worth Rs m257,656656,301 39.3%   
Long term debt Rs m365,685527,341 69.3%   
Total assets Rs m826,5012,248,672 36.8%  
Interest coverage x3.52.4 145.1%   
Debt to equity ratio x1.40.8 176.6%  
Sales to assets ratio x0.40.4 101.3%   
Return on assets %6.06.2 96.5%  
Return on equity %12.08.4 143.1%  
Return on capital %10.616.8 63.0%  
Exports to sales %00-   
Imports to sales %9.17.6 118.8%   
Exports (fob) Rs mNANA-   
Imports (cif) Rs m32,59573,702 44.2%   
Fx inflow Rs m7,48541,868 17.9%   
Fx outflow Rs m36,916109,605 33.7%   
Net fx Rs m-29,431-67,737 43.4%   
CASH FLOW
From Operations Rs m118,147283,205 41.7%  
From Investments Rs m-129,928-146,036 89.0%  
From Financial Activity Rs m-97,486-119,461 81.6%  
Net Cashflow Rs m-109,26717,708 -617.0%  

Share Holding

Indian Promoters % 42.9 43.7 98.2%  
Foreign collaborators % 0.0 21.7 -  
Indian inst/Mut Fund % 4.5 7.2 62.9%  
FIIs % 21.6 17.7 122.0%  
ADR/GDR % 0.0 0.0 -  
Free float % 30.9 9.7 318.6%  
Shareholders   266,634 260,508 102.4%  
Pledged promoter(s) holding % 0.0 0.0 -  
NM: Not Meaningful
Source: Company Annual Reports, Regulatory Filings, Equitymaster

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

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



Today's Market

Sensex Finishes on a Strong Note; Bank & Realty Stocks Rally(Closing)

Indian share markets surged further in the afternoon session and finished in the green for the second straight session on heavy buying in realty stocks, metal stocks and bank stocks.

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 Airtel: Revenues Rise Profits Fall (Quarterly Results Update - Detailed)

Feb 4, 2016

Bharti Airtel has reported a 3.8% YoY growth in the topline and a decrease of 22.2% YoY in the bottomline for the quarter ended December 2015.

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.

The Most Important Innovation in Finance Since Gold Coins(Vivek Kaul's Diary)

Aug 10, 2017

Bill connects the dots...between money and growth, real money and real resources, gold and cryptocurrencies...and between gold, cryptocurrencies, and time.

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?

Bitcoin Continues Stellar Rise(Chart Of The Day)

Aug 10, 2017

Bitcoin hits an all-time high, is there more upside left?

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!

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

COMPARE IDEA CELLULAR WITH

MARKET STATS