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

Helping You Build Wealth With Honest Research
Since 1996. Try Now

  • 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 97.7 84.2 116.0% View Chart
P/BV x 2.1 0.8 265.7% View Chart
Dividend Yield % 0.3 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:   BHARTI INFRATEL  HIMACHAL FUTURISTIC  TATA COMM.  TATA TELESERVICES  MTNL  

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



Today's Market

Sensex Ends Day in Red; SBI Up 3.7%(Closing)

After opening the day in green, share markets in India witnessed volatile trading activity throughout the day and ended the day on a negative note.

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

More Views on News

Most Popular

My Top Five Stocks After the Karnataka Elections(The 5 Minute Wrapup)

May 16, 2018

The markets seem confused. They're neither going up nor down. What should investors do? Consider Safe Stocks. Here's the top 5 Safe Stocks in the market today.

How A Storm Destroyed Rain Industries... And a Superb Small Cap Stock I Recommend(Profit Hunter)

May 17, 2018

A mutual fund regulation could cause small cap prices to tank - If you haven't been paying attention to your small caps - now is the time to catch the opportunities that start pouring in.

Has the Indian Home Buyer Become Smarter?(Vivek Kaul's Diary)

May 17, 2018

Home loans continue to grow, despite falling sales. What explains this phenomenon?

Looking Beyond the Colourful Prism of This Airline Company(Sector Info)

May 10, 2018

Can Interglobe Aviation Safely Fly Out of Turbulence?

Beware of Inflated Stock Market Angels(Sector Info)

May 17, 2018

The stock of Vakrangee helps us understand why it's a bad idea to chase high-flying stocks.

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


May 23, 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