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 79.5 -18.3 - View Chart
P/BV x 2.5 1.2 208.1% 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:   AGC NETWORKS  RELIANCE COMMUNICATIONS  BHARTI INFRATEL  TATA COMM.  TATA TELESERVICES  

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



Today's Market

Global Stock Markets Rebound After Sharp Weekly Drop(RoundUp)

Global financial markets rallied this week and brushed aside a rise in global borrowing costs while the dollar hit its lowest level since 2014.

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.

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.

More Views on News

Most Popular

Here's What You Should Do in this Market Crash(The 5 Minute Wrapup)

Feb 6, 2018

The market correction has provided a golden opportunity to buy five high-quality safe stocks.

As the Market Corrects... It's Time to Buy More(Smart Contrarian)

Feb 5, 2018

The recent sell off in the stock market offers buying opportunity in some quality small caps.

The Era of Easy Money is Coming to an End. What Happens Now?(Vivek Kaul's Diary)

Feb 9, 2018

The easy money policy of the Federal Reserve of the United States, which drove up stock markets all over the world, is ending, with the Federal Reserve looking to shrink its balance sheet.

When Small is Not Always Beautiful(Chart Of The Day)

Feb 6, 2018

Big companies enjoying tax deductions and exemptions have an edge over the small companies.

What Should Mutual Fund Investors Do After LTCG Tax Norms(Outside View)

Feb 6, 2018

PersonalFN explain what investors should after LTCG tax norms.

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


Feb 16, 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 - HIMACHAL FUTURISTIC COMPARISON

COMPARE BHARTI AIRTEL WITH

MARKET STATS