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 78.9 13.9 568.3% View Chart
P/BV x 2.1 0.7 285.6% View Chart
Dividend Yield % 0.7 0.0 -  

Financials

 BHARTI AIRTEL   IDEA CELLULAR
EQUITY SHARE DATA
    BHARTI AIRTEL
Mar-18
IDEA CELLULAR
Mar-17
BHARTI AIRTEL/
IDEA CELLULAR
5-Yr Chart
Click to enlarge
High Rs565128 441.1%   
Low Rs33366 505.0%   
Sales per share (Unadj.) Rs209.498.7 212.2%  
Earnings per share (Unadj.) Rs5.5-1.1 -492.7%  
Cash flow per share (Unadj.) Rs53.620.6 260.2%  
Dividends per share (Unadj.) Rs2.500-  
Dividend yield (eoy) %0.60-  
Book value per share (Unadj.) Rs173.968.6 253.6%  
Shares outstanding (eoy) m3,997.403,605.33 110.9%   
Bonus/Rights/Conversions -ESOS-  
Price / Sales ratio x2.11.0 218.1%   
Avg P/E ratio x82.2-87.5 -93.9%  
P/CF ratio (eoy) x8.44.7 177.9%  
Price / Book Value ratio x2.61.4 182.5%  
Dividend payout %45.80-   
Avg Mkt Cap Rs m1,795,432349,897 513.1%   
No. of employees `0008.511.8 71.7%   
Total wages/salary Rs m39,77117,977 221.2%   
Avg. sales/employee Rs Th99,003.830,189.9 327.9%   
Avg. wages/employee Rs Th4,705.01,525.5 308.4%   
Avg. net profit/employee Rs Th2,583.1-339.2 -761.6%   
INCOME DATA
Net Sales Rs m836,879355,757 235.2%  
Other income Rs m2,4883,069 81.1%   
Total revenues Rs m839,367358,827 233.9%   
Gross profit Rs m323,799102,473 316.0%  
Depreciation Rs m192,43178,272 245.8%   
Interest Rs m93,25540,121 232.4%   
Profit before tax Rs m40,601-12,851 -315.9%   
Minority Interest Rs m04,218 0.0%   
Prior Period Items Rs m00-   
Extraordinary Inc (Exp) Rs m-7,9310-   
Tax Rs m10,835-4,635 -233.7%   
Profit after tax Rs m21,835-3,997 -546.3%  
Gross profit margin %38.728.8 134.3%  
Effective tax rate %26.736.1 74.0%   
Net profit margin %2.6-1.1 -232.2%  
BALANCE SHEET DATA
Current assets Rs m334,99076,309 439.0%   
Current liabilities Rs m782,399170,615 458.6%   
Net working cap to sales %-53.5-26.5 201.7%  
Current ratio x0.40.4 95.7%  
Inventory Days Days01 50.1%  
Debtors Days Days2613 190.3%  
Net fixed assets Rs m2,056,355241,746 850.6%   
Share capital Rs m19,98736,053 55.4%   
"Free" reserves Rs m675,357211,269 319.7%   
Net worth Rs m695,344247,322 281.1%   
Long term debt Rs m849,420516,378 164.5%   
Total assets Rs m2,505,816967,047 259.1%  
Interest coverage x1.40.7 211.2%   
Debt to equity ratio x1.22.1 58.5%  
Sales to assets ratio x0.30.4 90.8%   
Return on assets %4.63.7 123.0%  
Return on equity %3.1-1.6 -194.3%  
Return on capital %8.24.1 197.7%  
Exports to sales %00-   
Imports to sales %00-   
Exports (fob) Rs mNANA-   
Imports (cif) Rs mNANA-   
Fx inflow Rs m45,0886,738 669.2%   
Fx outflow Rs m196,54035,338 556.2%   
Net fx Rs m-151,452-28,600 529.6%   
CASH FLOW
From Operations Rs m298,538105,373 283.3%  
From Investments Rs m-279,676-155,557 179.8%  
From Financial Activity Rs m19,20544,445 43.2%  
Net Cashflow Rs m38,348-5,739 -668.2%  

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

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



Today's Market

Sensex Opens Lower; Metal & Realty Stocks Drag(09:30 am)

Asian stock markets are lower today as Japanese and Hong Kong shares fall. The Nikkei 225 is off 0.1% while the Hang Seng is down 0.5%.

Related Views on News

IDEA CELLULAR Announces Quarterly Results (1QFY19); Net Profit Down 121.9% (Quarterly Result Update)

Jul 31, 2018 | Updated on Jul 31, 2018

For the quarter ended June 2018, IDEA CELLULAR has posted a net profit of Rs 2 bn (down 121.9% YoY). Sales on the other hand came in at Rs 59 bn (down 27.9% YoY). Read on for a complete analysis of IDEA CELLULAR's quarterly results.

BHARTI AIRTEL Announces Quarterly Results (1QFY19); Net Profit Down 14.9% (Quarterly Result Update)

Jul 30, 2018 | Updated on Jul 30, 2018

For the quarter ended June 2018, BHARTI AIRTEL has posted a net profit of Rs 3 bn (down 14.9% YoY). Sales on the other hand came in at Rs 201 bn (down 8.6% YoY). Read on for a complete analysis of BHARTI AIRTEL's quarterly results.

IDEA CELLULAR Announces Quarterly Results (4QFY18); Net Profit Down 343.4% (Quarterly Result Update)

Jul 20, 2018 | Updated on Jul 20, 2018

For the quarter ended March 2018, IDEA CELLULAR has posted a net profit of Rs 10 bn (down 343.4% YoY). Sales on the other hand came in at Rs 61 bn (down 24.5% YoY). Read on for a complete analysis of IDEA CELLULAR's quarterly results.

BHARTI AIRTEL Announces Quarterly Results (4QFY18); Net Profit Down 150.0% (Quarterly Result Update)

Jul 19, 2018 | Updated on Jul 19, 2018

For the quarter ended March 2018, BHARTI AIRTEL has posted a net profit of Rs 2 bn (down 150.0% YoY). Sales on the other hand came in at Rs 196 bn (down 10.5% YoY). Read on for a complete analysis of BHARTI AIRTEL's quarterly results.

More Views on News

Most Popular

How to Make Big Profits by Following India's Best Investors(The 5 Minute Wrapup)

Aug 3, 2018

In a time when stocks recommended by so-called 'gurus of the market' are crashing, let Kunal Thanvi guide you to the best gurus...and their best stocks.

The Biggest Mistake You Can Make in this Market (and 3 Stocks to Buy Now!)(Profit Hunter)

Aug 3, 2018

This price pattern can help you identify stocks on the verge of a turnaround.

Does This Indicator Tell Us the Sensex is Headed for a Correction?(Vivek Kaul's Diary)

Aug 3, 2018

To what extent have foreign flows influenced Indian stock markets? How do we see it panning out now?

Why HDFC Equity Fund Disappointed Its Investors(Outside View)

Aug 9, 2018

Though popular, HDFC Equity Fund is not among the best performers anymore. Here is the reason behind its underperformance that has left investors disappointed.

HDFC AMC Makes 65% Listing Gains! Should It Attract Mutual Fund Investors?(Outside View)

Aug 8, 2018

PersonalFN explains if investors should invest in schemes of HDFC Mutual Fund looking at the listing gains of HDFC AMC.

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


Aug 16, 2018 11:53 AM

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 5-YR ANALYSIS

COMPARE BHARTI AIRTEL WITH

MARKET STATS