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 Bharti Airtel with Idea Cellular - Equitymaster
  • MyStocks

MEMBER'S LOGINX

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

BHARTI AIRTEL vs IDEA CELLULAR - Comparison Results

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

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

    BHARTI AIRTEL IDEA CELLULAR BHARTI AIRTEL/
IDEA CELLULAR
 
P/E (TTM) x 94.4 -22.8 - View Chart
P/BV x 2.9 1.5 198.0% View Chart
Dividend Yield % 0.2 0.0 -  

Financials

 BHARTI AIRTEL   IDEA CELLULAR
EQUITY SHARE DATA
    BHARTI AIRTEL
Mar-17
IDEA CELLULAR
Mar-17
BHARTI AIRTEL/
IDEA CELLULAR
5-Yr Chart
Click to enlarge
High Rs401128 312.8%   
Low Rs28466 430.3%   
Sales per share (Unadj.) Rs238.898.7 242.0%  
Earnings per share (Unadj.) Rs10.6-1.1 -957.1%  
Cash flow per share (Unadj.) Rs60.120.6 291.6%  
Dividends per share (Unadj.) Rs1.000-  
Dividend yield (eoy) %0.30-  
Book value per share (Unadj.) Rs168.868.6 246.0%  
Shares outstanding (eoy) m3,997.403,605.33 110.9%   
Bonus/Rights/Conversions -ESOS-  
Price / Sales ratio x1.41.0 145.7%   
Avg P/E ratio x32.3-87.5 -36.9%  
P/CF ratio (eoy) x5.74.7 121.0%  
Price / Book Value ratio x2.01.4 143.4%  
Dividend payout %9.40-   
Avg Mkt Cap Rs m1,368,510349,897 391.1%   
No. of employees `0009.311.8 78.7%   
Total wages/salary Rs m43,03217,977 239.4%   
Avg. sales/employee Rs Th102,886.430,189.9 340.8%   
Avg. wages/employee Rs Th4,637.61,525.5 304.0%   
Avg. net profit/employee Rs Th4,571.0-339.2 -1,347.6%   
INCOME DATA
Net Sales Rs m954,683355,757 268.4%  
Other income Rs m1,2063,069 39.3%   
Total revenues Rs m955,889358,827 266.4%   
Gross profit Rs m380,920102,473 371.7%  
Depreciation Rs m197,73078,272 252.6%   
Interest Rs m95,46640,121 237.9%   
Profit before tax Rs m88,930-12,851 -692.0%   
Minority Interest Rs m04,218 0.0%   
Prior Period Items Rs m00-   
Extraordinary Inc (Exp) Rs m-11,6970-   
Tax Rs m34,819-4,635 -751.2%   
Profit after tax Rs m42,414-3,997 -1,061.2%  
Gross profit margin %39.928.8 138.5%  
Effective tax rate %39.236.1 108.5%   
Net profit margin %4.4-1.1 -395.4%  
BALANCE SHEET DATA
Current assets Rs m203,15076,309 266.2%   
Current liabilities Rs m629,447170,615 368.9%   
Net working cap to sales %-44.7-26.5 168.4%  
Current ratio x0.30.4 72.2%  
Inventory Days Days01 30.9%  
Debtors Days Days1913 141.3%  
Net fixed assets Rs m1,890,736241,746 782.1%   
Share capital Rs m19,98736,053 55.4%   
"Free" reserves Rs m654,576211,269 309.8%   
Net worth Rs m674,563247,322 272.7%   
Long term debt Rs m896,373516,378 173.6%   
Total assets Rs m2,327,502967,047 240.7%  
Interest coverage x1.90.7 284.2%   
Debt to equity ratio x1.32.1 63.6%  
Sales to assets ratio x0.40.4 111.5%   
Return on assets %5.93.7 158.6%  
Return on equity %6.3-1.6 -389.1%  
Return on capital %11.04.1 266.6%  
Exports to sales %00-   
Imports to sales %00-   
Exports (fob) Rs mNANA-   
Imports (cif) Rs mNANA-   
Fx inflow Rs m49,0606,738 728.1%   
Fx outflow Rs m116,27835,338 329.0%   
Net fx Rs m-67,218-28,600 235.0%   
CASH FLOW
From Operations Rs m292,309105,373 277.4%  
From Investments Rs m-315,554-155,557 202.9%  
From Financial Activity Rs m-3,51444,445 -7.9%  
Net Cashflow Rs m-26,759-5,739 466.3%  

Share Holding

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

Compare BHARTI AIRTEL With:   RELIANCE COMMUNICATIONS  TATA TELESERVICES  HIMACHAL FUTURISTIC  AGC NETWORKS  BHARTI INFRATEL  

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



Today's Market

Of Global Markets Hitting Record Highs and Top Stocks in Action During the Week(RoundUp)

Global stock markets ended the week on a positive note. Benchmark indices in US grew by 1% during the week. The Down Jones Industrial Average topped the 26,000.

Related Views on News

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.

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.

More Views on News

Most Popular

Retail Investors or Chickens Waiting to Get Slaughtered in the Stock Market?(Vivek Kaul's Diary)

Jan 9, 2018

The price to earnings ratio of the Nifty 50 is very close to all-time high levels.

Best ELSS Funds In 2018: Don't Blindly Chase Top Performers(Outside View)

Jan 10, 2018

As the tax-saving season begins, investors hunt for the best ELSS funds for 2018. PersonalFN provides a list of the top ELSS mutual funds of the past year.

Bitcoin Beginners Should Do These Three Things...(Smart Contrarian)

Jan 10, 2018

Three simple points to keep in mind before you consider buying bitcoin.

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

Resolutions for 2018 - by others(The Honest Truth)

Jan 8, 2018

Ten quirky new year resolutions. Guess by whom?

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

BHARTI AIRTEL SHARE PRICE


Jan 19, 2018 (Close)

TRACK BHARTI AIRTEL

  • Track your investment in BHARTI AIRTEL with Equitymaster's Portfolio Tracker. Set live price alerts, get research alerts and more. Get access now...
  • Add To MyStocks

BHARTI AIRTEL 8-QTR ANALYSIS

COMPARE BHARTI AIRTEL WITH

MARKET STATS