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

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?  

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 11.6 76.2 15.3% View Chart
P/BV x 0.6 2.1 30.4% View Chart
Dividend Yield % 0.0 0.7 -  

Financials

 IDEA CELLULAR   BHARTI AIRTEL
EQUITY SHARE DATA
    IDEA CELLULAR
Mar-17
BHARTI AIRTEL
Mar-18
IDEA CELLULAR/
BHARTI AIRTEL
5-Yr Chart
Click to enlarge
High Rs128565 22.7%   
Low Rs66333 19.8%   
Sales per share (Unadj.) Rs98.7209.4 47.1%  
Earnings per share (Unadj.) Rs-1.15.5 -20.3%  
Cash flow per share (Unadj.) Rs20.653.6 38.4%  
Dividends per share (Unadj.) Rs02.50 0.0%  
Dividend yield (eoy) %00.6 0.0%  
Book value per share (Unadj.) Rs68.6173.9 39.4%  
Shares outstanding (eoy) m3,605.333,997.40 90.2%   
Bonus/Rights/Conversions ESOS--  
Price / Sales ratio x1.02.1 45.8%   
Avg P/E ratio x-87.582.2 -106.5%  
P/CF ratio (eoy) x4.78.4 56.2%  
Price / Book Value ratio x1.42.6 54.8%  
Dividend payout %045.8 0.0%   
Avg Mkt Cap Rs m349,8971,795,432 19.5%   
No. of employees `00011.88.5 139.4%   
Total wages/salary Rs m17,97739,771 45.2%   
Avg. sales/employee Rs Th30,189.999,003.8 30.5%   
Avg. wages/employee Rs Th1,525.54,705.0 32.4%   
Avg. net profit/employee Rs Th-339.22,583.1 -13.1%   
INCOME DATA
Net Sales Rs m355,757836,879 42.5%  
Other income Rs m3,0692,488 123.4%   
Total revenues Rs m358,827839,367 42.7%   
Gross profit Rs m102,473323,799 31.6%  
Depreciation Rs m78,272192,431 40.7%   
Interest Rs m40,12193,255 43.0%   
Profit before tax Rs m-12,85140,601 -31.7%   
Minority Interest Rs m4,2180-   
Prior Period Items Rs m00-   
Extraordinary Inc (Exp) Rs m0-7,931 0.0%   
Tax Rs m-4,63510,835 -42.8%   
Profit after tax Rs m-3,99721,835 -18.3%  
Gross profit margin %28.838.7 74.4%  
Effective tax rate %36.126.7 135.2%   
Net profit margin %-1.12.6 -43.1%  
BALANCE SHEET DATA
Current assets Rs m76,309334,990 22.8%   
Current liabilities Rs m170,615782,399 21.8%   
Net working cap to sales %-26.5-53.5 49.6%  
Current ratio x0.40.4 104.5%  
Inventory Days Days10 199.6%  
Debtors Days Days1326 52.5%  
Net fixed assets Rs m241,7462,056,355 11.8%   
Share capital Rs m36,05319,987 180.4%   
"Free" reserves Rs m211,269675,357 31.3%   
Net worth Rs m247,322695,344 35.6%   
Long term debt Rs m516,378849,420 60.8%   
Total assets Rs m967,0472,505,816 38.6%  
Interest coverage x0.71.4 47.4%   
Debt to equity ratio x2.11.2 170.9%  
Sales to assets ratio x0.40.3 110.2%   
Return on assets %3.74.6 81.3%  
Return on equity %-1.63.1 -51.5%  
Return on capital %4.18.2 50.6%  
Exports to sales %00-   
Imports to sales %00-   
Exports (fob) Rs mNANA-   
Imports (cif) Rs mNANA-   
Fx inflow Rs m6,73845,088 14.9%   
Fx outflow Rs m35,338196,540 18.0%   
Net fx Rs m-28,600-151,452 18.9%   
CASH FLOW
From Operations Rs m105,373298,538 35.3%  
From Investments Rs m-155,557-279,676 55.6%  
From Financial Activity Rs m44,44519,205 231.4%  
Net Cashflow Rs m-5,73938,348 -15.0%  

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

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



Today's Market

Sensex Opens Lower; Realty & Auto Stocks Top Losers(09:30 am)

Asian shares eased in holiday-thinned trading on Monday and the safe haven yen gained as China canceled upcoming tariff talks with the United States.

Related Views on News

IDEA CELLULAR Plunges by 5%; BSE 500 Index Down 0.8% (Market Updates)

Sep 24, 2018 | Updated on Sep 24, 2018

IDEA CELLULAR share price has plunged by 5% and its current market price is Rs 45. The BSE 500 is down by 0.8%. The top gainers in the BSE 500 Index are ASAHI INDIA (up 3.1%) and ENTERTAINMENT NETWORK (up 2.8%). The top losers are IDEA CELLULAR (down 5.1%) and PNB HOUSING FINANCE LTD (down 7.1%).

BHARTI AIRTEL 2017-18 Annual Report Analysis (Annual Result Update)

Aug 17, 2018 | Updated on Aug 17, 2018

Here's an analysis of the annual report of BHARTI AIRTEL for 2017-18. It includes a full income statement, balance sheet and cash flow analysis of BHARTI AIRTEL. Also includes updates on the valuation of BHARTI AIRTEL.

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.

More Views on News

Most Popular

My First Pharma Stock Recommendation!(The 5 Minute Wrapup)

Sep 21, 2018

This company has not only created a niche in the pharma space, it has done so profitably.

Want Bigger Returns Than You Thought Possible? This is Where You Should Look(Profit Hunter)

Sep 12, 2018

Richa has discovered the single most profitable opportunity in the market - read on to discover more...

Are You Blindly Investing In Equities? Read This...(Outside View)

Sep 11, 2018

PersonalFN explains how blindly investing in equities can prove hazardous to your wealth and health.

Investors Are Redeeming From Equity Mutual Funds Now. Should You?(Outside View)

Sep 12, 2018

PersonalFN elucidates if you should redeem from equity mutual fund now, and the approach to follow before you decide to sell mutual funds.

Outperformance of Strong Established Brands in the Indian Stock market(Chart Of The Day)

Sep 14, 2018

Strong Well established Indian Brands have comfortably outperformed the index in the decade post the global financial crisis.

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


Sep 24, 2018 12:39 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 8-QTR ANALYSIS

COMPARE IDEA CELLULAR WITH

MARKET STATS