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 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.8 88.4 - View Chart
P/BV x 1.4 2.8 49.3% View Chart
Dividend Yield % 0.0 0.2 -  

Financials

 IDEA CELLULAR   BHARTI AIRTEL
EQUITY SHARE DATA
    IDEA CELLULAR
Mar-17
BHARTI AIRTEL
Mar-17
IDEA CELLULAR/
BHARTI AIRTEL
5-Yr Chart
Click to enlarge
High Rs128401 32.0%   
Low Rs66284 23.2%   
Sales per share (Unadj.) Rs98.7238.8 41.3%  
Earnings per share (Unadj.) Rs-1.110.6 -10.4%  
Cash flow per share (Unadj.) Rs20.660.1 34.3%  
Dividends per share (Unadj.) Rs01.00 0.0%  
Dividend yield (eoy) %00.3 0.0%  
Book value per share (Unadj.) Rs68.6168.8 40.7%  
Shares outstanding (eoy) m3,605.333,997.40 90.2%   
Bonus/Rights/Conversions ESOS--  
Price / Sales ratio x1.01.4 68.6%   
Avg P/E ratio x-87.532.3 -271.3%  
P/CF ratio (eoy) x4.75.7 82.7%  
Price / Book Value ratio x1.42.0 69.7%  
Dividend payout %09.4 0.0%   
Avg Mkt Cap Rs m349,8971,368,510 25.6%   
No. of employees `00011.89.3 127.0%   
Total wages/salary Rs m17,97743,032 41.8%   
Avg. sales/employee Rs Th30,189.9102,886.4 29.3%   
Avg. wages/employee Rs Th1,525.54,637.6 32.9%   
Avg. net profit/employee Rs Th-339.24,571.0 -7.4%   
INCOME DATA
Net Sales Rs m355,757954,683 37.3%  
Other income Rs m3,0691,206 254.5%   
Total revenues Rs m358,827955,889 37.5%   
Gross profit Rs m102,473380,920 26.9%  
Depreciation Rs m78,272197,730 39.6%   
Interest Rs m40,12195,466 42.0%   
Profit before tax Rs m-12,85188,930 -14.5%   
Minority Interest Rs m4,2180-   
Prior Period Items Rs m00-   
Extraordinary Inc (Exp) Rs m0-11,697 0.0%   
Tax Rs m-4,63534,819 -13.3%   
Profit after tax Rs m-3,99742,414 -9.4%  
Gross profit margin %28.839.9 72.2%  
Effective tax rate %36.139.2 92.1%   
Net profit margin %-1.14.4 -25.3%  
BALANCE SHEET DATA
Current assets Rs m76,309203,150 37.6%   
Current liabilities Rs m170,615629,447 27.1%   
Net working cap to sales %-26.5-44.7 59.4%  
Current ratio x0.40.3 138.6%  
Inventory Days Days10 323.3%  
Debtors Days Days1319 70.7%  
Net fixed assets Rs m241,7461,890,736 12.8%   
Share capital Rs m36,05319,987 180.4%   
"Free" reserves Rs m211,269654,576 32.3%   
Net worth Rs m247,322674,563 36.7%   
Long term debt Rs m516,378896,373 57.6%   
Total assets Rs m967,0472,327,502 41.5%  
Interest coverage x0.71.9 35.2%   
Debt to equity ratio x2.11.3 157.1%  
Sales to assets ratio x0.40.4 89.7%   
Return on assets %3.75.9 63.1%  
Return on equity %-1.66.3 -25.7%  
Return on capital %4.111.0 37.5%  
Exports to sales %00-   
Imports to sales %00-   
Exports (fob) Rs mNANA-   
Imports (cif) Rs mNANA-   
Fx inflow Rs m6,73849,060 13.7%   
Fx outflow Rs m35,338116,278 30.4%   
Net fx Rs m-28,600-67,218 42.5%   
CASH FLOW
From Operations Rs m105,373292,309 36.0%  
From Investments Rs m-155,557-315,554 49.3%  
From Financial Activity Rs m44,445-3,514 -1,264.8%  
Net Cashflow Rs m-5,739-26,759 21.4%  

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:   BHARTI INFRATEL  HIMACHAL FUTURISTIC  TATA COMM.  TATA TELESERVICES  MTNL  

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



Today's Market

Sensex Trades on a Volatile Note; Airtel, Idea Down by 5%(01:30 pm)

After opening the day in green share markets in India witnessed choppy trading activity 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 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.

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

Mutual Funds Clearly Tell Us That There is a Bubble in the Stock Market(Vivek Kaul's Diary)

Jan 11, 2018

The maximum amount of money ever has come into equity mutual funds during the current financial year.

Did GST and Notebandi Help? Sherlock Holmes Finds Out...(The 5 Minute Wrapup)

Jan 13, 2018

Discussions with my cousin helped me understand the situation on Ground Zero - after the demonetization and GST upheaval. Here's what that means for listed companies...

Nirvana denied: Has Value Failed?(The Honest Truth)

Jan 13, 2018

Should investors choose growth over value this year?

'Smart Money' Enters Bitcoin. Will You?(Smart Contrarian)

Jan 17, 2018

As institutional money enters bitcoin, the gains over the last year could just be the tip of the iceberg.

Increasing Divergence Between Bond Yields and Earnings Yield(Chart Of The Day)

Jan 11, 2018

Over the past couple of months, bond yields have risen, but earning yields have fallen, increasing divergence.

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


Jan 24, 2018 01:57 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