- Home
- About
- Team
- Today's Market
- Premium
- Research it
- Outlook
- Portfolio
- Mobile
- Trust Equitymaster
- Help
- Free Reports
MEMBER'S LOGINX
| Login Failure | ||||||||
|
||||||||
| Sign Up | Forgot Password? | ||||||||
- Home
- Research It
- IDEA CELLULAR LIMITED (telecom)
- IDEA CELLULAR LIMITED Financial Data
Idea Cellular Fact Sheet 
(IDEA)
Here is the latest financial fact sheet of Idea Cellular. For more details, see the Idea Cellular quarterly results and Idea Cellular share price and chart. For a sector overview, read our telecom sector report.
IDEA CELLULAR Price History
| % ch | % | -1.0 |
| No. of shares | m | 3,601.03 |
| % ch week | % | -5.2 |
| % ch 1-mth | % | -0.2 |
| % ch 12-mth | % | -39.7 |
| 52 week H/L | Rs | 118.0/48.4 |
IDEA CELLULAR Financials
| No. of Mths Year Ending |
12 Mar-13* |
12 Mar-14* |
12 Mar-15* |
12 Mar-16* |
12 Mar-17* |
5-Yr Chart Click to enlarge
|
|---|
| IDEA CELLULAR EQUITY SHARE DATA | |||||||
|---|---|---|---|---|---|---|---|
| High | Rs | 124 | 188 | 187 | 204 | 128 | |
| Low | Rs | 71 | 101 | 143 | 98 | 66 | |
| Sales per share (Unadj.) | Rs | 67.6 | 79.6 | 87.6 | 99.8 | 98.7 | |
| Earnings per share (Unadj.) | Rs | 3.1 | 5.9 | 8.9 | 7.6 | -1.1 | |
| Diluted earnings per share | Rs | 2.8 | 5.5 | 8.9 | 7.6 | -1.1 | |
| Cash flow per share (Unadj.) | Rs | 13.5 | 19.5 | 23.6 | 25.0 | 20.6 | |
| Dividends per share (Unadj.) | Rs | 0.30 | 0.40 | 0.60 | 0.60 | 0 | |
| Adj. dividends per share | Rs | 0.28 | 0.37 | 0.60 | 0.60 | 0.00 | |
| Dividend yield (eoy) | % | 0.3 | 0.3 | 0.4 | 0.4 | 0 | |
| Book value per share (Unadj.) | Rs | 43.2 | 49.8 | 58.6 | 65.4 | 68.6 | |
| Adj. book value per share | Rs | 39.7 | 45.9 | 58.5 | 65.4 | 68.7 | |
| Shares outstanding (eoy) | m | 3,314.32 | 3,319.63 | 3,597.84 | 3,600.51 | 3,605.33 | |
| Bonus/Rights/Conversions | ESOS | ESOS | - | ESOS | ESOS | ||
| Price / Sales ratio | x | 1.4 | 1.8 | 1.9 | 1.5 | 1.0 | |
| Avg P/E ratio | x | 32.0 | 24.4 | 18.6 | 19.9 | -87.5 | |
| P/CF ratio (eoy) | x | 7.2 | 7.4 | 7.0 | 6.0 | 4.7 | |
| Price / Book Value ratio | x | 2.3 | 2.9 | 2.8 | 2.3 | 1.4 | |
| Dividend payout | % | 9.8 | 6.7 | 6.8 | 7.9 | 0 | |
| Avg Mkt Cap | Rs m | 323,478 | 480,516 | 594,723 | 542,777 | 349,897 | |
| No. of employees | `000 | 9.7 | 10.5 | 10.9 | 12.5 | 11.8 | |
| Total wages/salary | Rs m | 11,225 | 13,121 | 15,299 | 16,119 | 17,977 | |
| Avg. sales/employee | Rs Th | 22,991.4 | 25,161.3 | 28,990.2 | 28,780.2 | 30,189.9 | |
| Avg. wages/employee | Rs Th | 1,151.8 | 1,249.0 | 1,406.8 | 1,290.4 | 1,525.5 | |
| Avg. net profit/employee | Rs Th | 1,037.3 | 1,873.2 | 2,936.0 | 2,184.1 | -339.2 | |
| IDEA CELLULAR INCOME DATA | |||||||
|---|---|---|---|---|---|---|---|
| Net Sales | Rs m | 224,074 | 264,320 | 315,269 | 359,494 | 355,757 | |
| Other income | Rs m | 1,165 | 2,721 | 4,875 | 2,131 | 3,069 | |
| Total revenues | Rs m | 225,239 | 267,041 | 320,144 | 361,625 | 358,827 | |
| Gross profit | Rs m | 59,543 | 82,468 | 107,938 | 116,502 | 102,473 | |
| Depreciation | Rs m | 34,778 | 45,194 | 53,036 | 62,561 | 78,272 | |
| Interest | Rs m | 10,157 | 9,552 | 10,452 | 17,788 | 40,121 | |
| Profit before tax | Rs m | 15,773 | 30,443 | 49,325 | 38,285 | -12,851 | |
| Minority Interest | Rs m | 0 | 0 | 0 | 4,217 | 4,218 | |
| Prior Period Items | Rs m | 0 | 0 | 0 | 0 | 0 | |
| Extraordinary Inc (Exp) | Rs m | 0 | 0 | 0 | 0 | 0 | |
| Tax | Rs m | 5,664 | 10,764 | 17,396 | 15,220 | -4,635 | |
| Profit after tax | Rs m | 10,109 | 19,678 | 31,929 | 27,281 | -3,997 | |
| Gross profit margin | % | 26.6 | 31.2 | 34.2 | 32.4 | 28.8 | |
| Effective tax rate | % | 35.9 | 35.4 | 35.3 | 39.8 | 36.1 | |
| Net profit margin | % | 4.5 | 7.4 | 10.1 | 7.6 | -1.1 | |
| IDEA CELLULAR BALANCE SHEET DATA | |||||||
|---|---|---|---|---|---|---|---|
| Current assets | Rs m | 32,890 | 24,942 | 156,055 | 44,814 | 76,309 | |
| Current liabilities | Rs m | 80,412 | 86,673 | 192,288 | 155,887 | 170,615 | |
| Net working cap to sales | % | -21.2 | -23.4 | -11.5 | -30.9 | -26.5 | |
| Current ratio | x | 0.4 | 0.3 | 0.8 | 0.3 | 0.4 | |
| Inventory Days | Days | 1 | 1 | 1 | 1 | 1 | |
| Debtors Days | Days | 16 | 11 | 11 | 12 | 13 | |
| Net fixed assets | Rs m | 300,350 | 410,153 | 189,021 | 218,384 | 241,746 | |
| Share capital | Rs m | 33,143 | 33,196 | 35,978 | 36,005 | 36,053 | |
| "Free" reserves | Rs m | 109,583 | 131,652 | 174,764 | 199,500 | 211,269 | |
| Net worth | Rs m | 143,034 | 165,250 | 210,743 | 235,505 | 247,322 | |
| Long term debt | Rs m | 118,047 | 181,284 | 157,991 | 359,040 | 516,378 | |
| Total assets | Rs m | 363,781 | 465,575 | 583,148 | 801,255 | 967,047 | |
| Interest coverage | x | 2.6 | 4.2 | 5.7 | 3.2 | 0.7 | |
| Debt to equity ratio | x | 0.8 | 1.1 | 0.7 | 1.5 | 2.1 | |
| Sales to assets ratio | x | 0.6 | 0.6 | 0.5 | 0.4 | 0.4 | |
| Return on assets | % | 5.6 | 6.3 | 7.3 | 5.6 | 3.7 | |
| Return on equity | % | 7.1 | 11.9 | 15.2 | 11.6 | -1.6 | |
| Return on capital | % | 9.9 | 11.5 | 16.2 | 10.1 | 4.1 | |
| Exports to sales | % | 0 | 0 | 0 | 0 | 0 | |
| Imports to sales | % | 5.7 | 5.1 | 4.2 | 9.1 | 0 | |
| Exports (fob) | Rs m | 0 | 0 | 0 | 0 | 0 | |
| Imports (cif) | Rs m | 12,864 | 13,572 | 13,196 | 32,595 | 0 | |
| Fx inflow | Rs m | 2,970 | 3,826 | 4,855 | 7,485 | 6,738 | |
| Fx outflow | Rs m | 17,679 | 18,661 | 17,647 | 36,916 | 35,338 | |
| Net fx | Rs m | -14,709 | -14,834 | -12,792 | -29,431 | -28,600 | |
| IDEA CELLULAR CASH FLOW | |||||||
|---|---|---|---|---|---|---|---|
| From Operations | Rs m | 62,971 | 82,192 | 104,179 | 109,486 | 105,373 | |
| From Investments | Rs m | -34,109 | -65,642 | -57,256 | -23,890 | -155,557 | |
| From Financial Activity | Rs m | -19,653 | -24,661 | 80,280 | -93,301 | 44,445 | |
| Net Cashflow | Rs m | 9,209 | -8,111 | 127,202 | -7,705 | -5,739 | |
Share Holding
|
Company Information
|
|||||||||||||||||||||||||||||||||||||||||
| CHM: Kumar Mangalam Birla | COMP SEC: Pankaj Kapdeo | YEAR OF INC: 1995 | BSE CODE: 532822 | FV (Rs): 10 | DIV YIELD (%): - |
More Telecom Company Fact Sheets: RELIANCE COMMUNICATIONS MTNL GTL LTD TATA TELESERVICES HIMACHAL FUTURISTIC
Compare IDEA CELLULAR With: RELIANCE COMMUNICATIONS MTNL GTL LTD TATA TELESERVICES HIMACHAL FUTURISTIC
Compare IDEA CELLULAR With: TELEKOM INDO. (Indonesia) FRANCE TELECOM (France) VERIZON (US) CHINA MOBILE (Hong Kong)
|
| |
Today's Market
Sensex Ends 207 Points Higher; Healthcare Stocks Witness Buying(Closing)
Indian share markets continued to trade in the green during the closing hours of the trading session and ended the day on a positive note.
Views on news
IDEA CELLULAR Announces Quarterly Results (1QFY19); Net Profit Down 121.9% (Quarterly Result Update)
Jul 31, 2018 | Updated on Jul 31, 2018For 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.
IDEA CELLULAR Announces Quarterly Results (4QFY18); Net Profit Down 343.4% (Quarterly Result Update)
Jul 20, 2018 | Updated on Jul 20, 2018For 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.
Stock for An Antifragile Portfolio (Profit Hunter)
Nov 17, 2017Stocks that will gain from disruption - and make you profits while other sink.
More Views on NewsMost Popular
How to Make Big Profits by Following India's Best Investors(The 5 Minute Wrapup)
Aug 3, 2018In 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, 2018This 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, 2018To what extent have foreign flows influenced Indian stock markets? How do we see it panning out now?
Is Franklin India Smaller Companies Fund Worth Your Money(Outside View)
Aug 2, 2018Although positioned as a small cap fund, Franklin India Smaller Companies Fund has been investing a significant portion of its assets in mid-caps along with a nominal exposure to large caps.
Why HDFC Equity Fund Disappointed Its Investors(Outside View)
Aug 9, 2018Though popular, HDFC Equity Fund is not among the best performers anymore. Here is the reason behind its underperformance that has left investors disappointed.
More|
| |
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
MORE ON IDEA CELLULAR
IDEA CELLULAR 8-QTR ANALYSIS
COMPARE IDEA CELLULAR WITH
OTHER USEFUL LINKS
MARKET STATS
ABOUT EQUITYMASTER
Since 1996, Equitymaster has been the source for honest and credible opinions on investing in India. With solid research and in-depth analysis Equitymaster is dedicated towards making its readers- smarter, more confident and richer every day. Here's why hundreds of thousands of readers spread across more than 70 countries Trust Equitymaster.
FREE NEWSLETTERS
PREMIUM PRODUCTS
QUICK LINKS
APPS
FOLLOW
Copyright © Equitymaster Agora Research Private Limited.
Whitelist | Refer | Terms | Privacy | Contact | About | Sitemap
Equitymaster Agora Research Private Limited. 103, Regent Chambers, Above Status Restaurant, Nariman Point, Mumbai - 400 021. India.
Telephone: +91-22-61434055. Fax: +91-22-22028550. Email: info@equitymaster.com. Website: www.equitymaster.com. CIN:U74999MH2007PTC175407
All rights reserved. Any act of copying, reproducing or distributing this newsletter whether wholly or in part, for any purpose without the permission of Equitymaster is strictly prohibited and shall be deemed to be copyright infringement.
LEGAL DISCLAIMER: Equitymaster Agora Research Private Limited (hereinafter referred as 'Equitymaster') is an independent equity research Company. Equitymaster is not an Investment Adviser. Information herein should be regarded as a resource only and should be used at one's own risk. This is not an offer to sell or solicitation to buy any securities and Equitymaster will not be liable for any losses incurred or investment(s) made or decisions taken/or not taken based on the information provided herein. Information contained herein does not constitute investment advice or a personal recommendation or take into account the particular investment objectives, financial situations, or needs of individual subscribers. Before acting on any recommendation, subscribers should consider whether it is suitable for their particular circumstances and, if necessary, seek an independent professional advice. This is not directed for access or use by anyone in a country, especially, USA, Canada or the European Union countries, where such use or access is unlawful or which may subject Equitymaster or its affiliates to any registration or licensing requirement. All content and information is provided on an 'As Is' basis by Equitymaster. Information herein is believed to be reliable but Equitymaster does not warrant its completeness or accuracy and expressly disclaims all warranties and conditions of any kind, whether express or implied. Equitymaster may hold shares in the company/ies discussed herein. As a condition to accessing Equitymaster content and website, you agree to our Terms and Conditions of Use, available here. The performance data quoted represents past performance and does not guarantee future results.
SEBI (Research Analysts) Regulations 2014, Registration No. INH000000537.