Price
Financials
Consolidated, Rs crore| Mar 2014 | Jun 2014 | Sep 2014 | Dec 2014 | Mar 2015 | Jun 2015 | Sep 2015 | Dec 2015 | Mar 2016 | Jun 2016 | Sep 2016 | Dec 2016 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Sales | 5,049 | 4,483 | 3,982 | 3,504 | 2,677 | 2,627 | 2,242 | 2,039 | 1,717 | 1,885 | 2,039 | 2,149 |
| Expenses | 1,366 | 1,430 | 1,326 | 1,477 | 2,058 | 1,274 | 1,269 | 1,726 | 1,180 | 1,091 | 999 | 1,590 |
| Operating Profit | 3,683 | 3,052 | 2,656 | 2,027 | 619 | 1,353 | 973 | 313 | 537 | 794 | 1,039 | 560 |
| OPM % | 73% | 68% | 67% | 58% | 23% | 51% | 43% | 15% | 31% | 42% | 51% | 26% |
| Other Income | 164 | -1,611 | 586 | 516 | -148 | 291 | 323 | 393 | -493 | 404 | 599 | 445 |
| Interest | 11 | 2 | 5 | 8 | 5 | 13 | 16 | 16 | 26 | 18 | 19 | 29 |
| Depreciation | 637 | 720 | 703 | 891 | 256 | 866 | 902 | 1,012 | 742 | 810 | 782 | 726 |
| Profit before tax | 3,200 | 720 | 2,534 | 1,644 | 211 | 764 | 379 | -322 | -725 | 369 | 837 | 250 |
| Tax % | 5% | -52% | 10% | 18% | 214% | 34% | 14% | -5% | -22% | 3% | 7% | 68% |
| Net Profit | 3,035 | 1,093 | 2,278 | 1,350 | -241 | 501 | 326 | 41 | -564 | 360 | 779 | 604 |
| EPS in Rs | 15.91 | 5.83 | 12.15 | 7.20 | -1.28 | 2.67 | 1.74 | 0.22 | -3.01 | 1.92 | 4.15 | 3.22 |
| Dec 2006 5m | Dec 2007 | Mar 2009 15m | Mar 2010 | Mar 2011 | Mar 2012 | Mar 2013 | Mar 2014 | Mar 2015 | Mar 2016 | TTM | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Sales | 39 | 1,012 | 1,433 | 1,623 | 10,278 | 11,861 | 17,524 | 18,762 | 14,646 | 8,626 | 7,790 |
| Expenses | 57 | 1,016 | 1,108 | 989 | 2,024 | 2,606 | 4,491 | 5,076 | 3,996 | 5,261 | 4,860 |
| Operating Profit | -18 | -3 | 325 | 634 | 8,254 | 9,254 | 13,033 | 13,686 | 10,650 | 3,365 | 2,930 |
| OPM % | -47% | -0.3% | 23% | 39% | 80% | 78% | 74% | 73% | 73% | 39% | 38% |
| Other Income | 6 | 134 | 675 | 408 | 129 | 835 | 1,036 | 1,503 | -824 | -9,665 | 955 |
| Interest | 0 | 2 | 6 | 15 | 300 | 226 | 69 | 41 | 20 | 27 | 93 |
| Depreciation | 1 | 3 | 6 | 11 | 1,193 | 1,440 | 1,846 | 2,297 | 4,697 | 3,107 | 3,061 |
| Profit before tax | -13 | 126 | 988 | 1,016 | 6,890 | 8,423 | 12,155 | 12,850 | 5,109 | -9,435 | 731 |
| Tax % | 43% | 119% | 19% | -3% | 8% | 6% | 2% | 3% | 12% | -0% | |
| Net Profit | -19 | -25 | 803 | 1,051 | 6,334 | 7,938 | 11,920 | 12,432 | 4,480 | -9,432 | 1,178 |
| EPS in Rs | -0.12 | -0.14 | 4.24 | 5.54 | 33.31 | 41.62 | 62.40 | 65.17 | 23.89 | -50.31 | 6.28 |
| Dividend Payout % | 0% | 0% | 0% | 0% | 0% | 0% | 18% | 19% | 38% | -6% |
| 10 Years | 5 Years | 3 Years | TTM | 1 Year | Last Year | |
|---|---|---|---|---|---|---|
| Compounded Sales Growth | % | -3% | -21% | -19% | ||
| Compounded Profit Growth | % | -24% | -48% | 224% | ||
| Stock Price CAGR | 4% | % | % | % | ||
| Return on Equity | 11% | 15% | 12% | 3% |
| Dec 2006 | Dec 2007 | Mar 2009 | Mar 2010 | Mar 2011 | Mar 2012 | Mar 2013 | Mar 2014 | Mar 2015 | Mar 2016 | |
|---|---|---|---|---|---|---|---|---|---|---|
| Equity Capital | 1,765 | 1,778 | 1,897 | 1,897 | 1,902 | 1,907 | 1,910 | 1,908 | 1,875 | 1,875 |
| Reserves | 27,481 | 27,563 | 30,867 | 31,971 | 38,391 | 46,385 | 45,789 | 55,530 | 56,995 | 46,918 |
| Borrowings | 518 | 312 | 4,356 | 3,401 | 2,678 | 1,252 | 0 | 0 | 0 | 0 |
| Other Liabilities | 4,667 | 1,422 | 2,206 | 1,926 | 3,538 | 3,899 | 6,351 | 8,255 | 7,964 | 7,703 |
| Total Liabilities | 34,431 | 31,075 | 39,326 | 39,195 | 46,509 | 53,443 | 54,050 | 65,692 | 66,834 | 56,496 |
| Fixed Assets | 25,666 | 25,368 | 25,383 | 25,446 | 31,243 | 34,269 | 24,590 | 25,076 | 23,633 | 11,946 |
| CWIP | 1,712 | 2,906 | 6,504 | 9,663 | 6,067 | 4,500 | 4,385 | 5,697 | 5,907 | 4,340 |
| Investments | 11 | 713 | 171 | 1,712 | 1,094 | 1,836 | 10,382 | 16,364 | 15,233 | 15,054 |
| Other Assets | 7,041 | 2,088 | 7,268 | 2,373 | 8,105 | 12,838 | 14,693 | 18,556 | 22,061 | 25,156 |
| Total Assets | 34,431 | 31,075 | 39,326 | 39,195 | 46,509 | 53,443 | 54,050 | 65,692 | 66,834 | 56,496 |
| Dec 2006 | Dec 2007 | Mar 2009 | Mar 2010 | Mar 2011 | Mar 2012 | Mar 2013 | Mar 2014 | Mar 2015 | Mar 2016 | |
|---|---|---|---|---|---|---|---|---|---|---|
| Cash from Operating Activity | -60 | 550 | 968 | 110 | 6,338 | 7,069 | 11,056 | 11,094 | 9,520 | 4,134 |
| Cash from Investing Activity | -9,406 | -6,430 | -5,097 | -601 | -4,941 | -2,248 | -13,058 | -8,132 | -5,943 | -2,165 |
| Cash from Financing Activity | 15,601 | -104 | 6,152 | -1,045 | -873 | -1,522 | -2,398 | -2,924 | -3,433 | -720 |
| Net Cash Flow | 6,135 | -5,984 | 2,023 | -1,537 | 524 | 3,300 | -4,400 | 38 | 144 | 1,248 |
| Free Cash Flow | -60 | 533 | -2,045 | -3,256 | 3,773 | 4,113 | 9,424 | 8,393 | 3,946 | 2,485 |
| CFO/OP | 328% | -19,518% | 343% | 45% | 92% | 99% | 102% | 100% | 100% | 127% |
| Dec 2006 | Dec 2007 | Mar 2009 | Mar 2010 | Mar 2011 | Mar 2012 | Mar 2013 | Mar 2014 | Mar 2015 | Mar 2016 | |
|---|---|---|---|---|---|---|---|---|---|---|
| Debtor Days | 1,807 | 49 | 39 | 69 | 53 | 46 | 48 | 49 | 28 | 11 |
| Inventory Days | 15,801 | |||||||||
| Days Payable | 40,549 | |||||||||
| Cash Conversion Cycle | -22,941 | 49 | 39 | 69 | 53 | 46 | 48 | 49 | 28 | 11 |
| Working Capital Days | -31,993 | -63 | -232 | -48 | 17 | 38 | 7 | -8 | -45 | 305 |
| ROCE % | 0% | 3% | 3% | 18% | 19% | 25% | 24% | 12% | 3% |
| Jun 2016 | Sep 2016 | Dec 2016 | |
|---|---|---|---|
| Promoters | 59.88% | 59.86% | 59.85% |
| FIIs | 15.75% | 15.26% | 14.76% |
| DIIs | 10.12% | 10.91% | 11.96% |
| Government | 0.01% | 0.01% | 0.01% |
| Public | 14.23% | 13.96% | 13.42% |
| No. of Shareholders | 2,68,780 | 2,48,592 | 2,34,450 |
Fundamentals
Market Cap₹ 53,529 Cr.
Current Price₹ 285
Stock P/E24.3
Book Value₹ 262
ROCE3.43 %
ROE3.07 %
Dividend Yield0.00 %
Face Value₹ 10.0
Compounded Sales Growth (TTM)-19%
Compounded Profit Growth (TTM)224%
Consolidated figures.
Valuation
Market capRs 53,500 Cr
Enterprise valueRs 51,115 Cr
P/E (TTM)45.42x
Price to book1.10x
Price to sales6.87x
EV / EBITDA13.16x
EV / EBIT62.04x
EV / sales6.56x
Price to cash flow12.94x
Earnings yield2.20%
Dividend yield1.05%
P/E, 3-year average7.03x
P/B, 3-year average0.79x
P/E, 5-year average6.61x
P/B, 5-year average0.96x
Profitability
Operating margin (excl. other income)39.01%
Operating margin (incl. other income)-73.04%
EBITDA margin49.87%
Pre-tax margin9.39%
Net profit margin15.12%
Net margin, latest quarter28.09%
ROE-17.52%
ROCE-17.48%
ROA-15.30%
ROE, 3-year average4.61%
ROCE, 3-year average5.29%
ROA, 3-year average4.08%
ROE, 5-year average11.32%
ROCE, 5-year average11.94%
ROA, 5-year average10.06%
ROIC (approx.)1.77%
Tax rate0.03%
Other income / net worth-19.81%
Growth
Sales growth (latest year)-41.11%
Profit growth (latest year)-310.55%
Sales CAGR, 3 years-21.04%
Sales CAGR, 5 years-3.44%
Sales growth QoQ5.43%
Profit growth QoQ-22.47%
Sales growth YoY (latest quarter)5.39%
Profit growth YoY (latest quarter)1376.11%
Per share
EPS (TTM)Rs 6.28
EPS (latest year)Rs -50.31
EPS (latest quarter)Rs 3.22
EPS, 3-year averageRs 12.92
EPS, 5-year averageRs 28.55
Book value per shareRs 260.24
Sales per shareRs 41.55
Cash flow per shareRs 22.05
Free cash flow per shareRs 13.25
Dividend per share (latest year)Rs 3.00
Dividend per share, 3-year averageRs 8.17
Dividend per share, 5-year averageRs 9.00
Dividends
Dividend payout, 3-year average28.42%
Dividend payout, 5-year average25.09%
Efficiency
Asset turnover0.15x
Fixed asset turnover0.72x
Inventory turnover0.21x
Inventory days1776 days
Debtor days11 days
Debtors turnover33.55x
Creditor days40549 days
Cash conversion cycle11 days
Working capital days305 days
Leverage
Cash and bankRs 2,385 Cr
Net debtRs -2,385 Cr
Net debt / EBITDA-0.61x
Interest coverage8.89x
Owners' fund to total sources86.37%
Cash flow
Cash from Operating Activity (latest year)Rs 4,134 Cr
Cash from Investing Activity (latest year)Rs -2,165 Cr
Cash from Financing Activity (latest year)Rs -720 Cr
Net Cash Flow (latest year)Rs 1,248 Cr
Free cash flow (latest year)Rs 2,485 Cr
Cash from ops / profit, 5 years1.57x
Sales to cash flow2.09x
Statement figures
Net sales (TTM)Rs 7,790 Cr
Net sales (latest year)Rs 8,626 Cr
Sales (latest quarter)Rs 2,149 Cr
Operating profit excl. other income (latest year)Rs 3,365 Cr
Operating profit (latest quarter)Rs 560 Cr
Other income (TTM)Rs 955 Cr
EBITDA (TTM)Rs 3,884 Cr
PBDT (TTM)Rs 3,792 Cr
Profit before tax (TTM)Rs 731 Cr
Tax (latest year)Rs -3 Cr
Net profit (TTM)Rs 1,178 Cr
Net profit (latest year)Rs -9,432 Cr
Net profit (latest quarter)Rs 604 Cr
Depreciation (TTM)Rs 3,061 Cr
Depreciation (latest quarter)Rs 726 Cr
Interest (TTM)Rs 93 Cr
Cost of goods sold (latest year)Rs 96 Cr
Total expenditure (latest year)Rs 5,261 Cr
Total income (latest year)Rs -1,040 Cr
Share capitalRs 1,875 Cr
ReservesRs 46,918 Cr
Shareholders' fundsRs 48,793 Cr
Total assetsRs 56,496 Cr
Net blockRs 11,946 Cr
Capital work in progressRs 4,340 Cr
InvestmentsRs 15,054 Cr
ReceivablesRs 257 Cr
InventoryRs 468 Cr
Other liabilitiesRs 7,703 Cr
Shares outstanding (crore)187.49
Ownership
Promoter holding59.85%
Computed by MarketFriction from the consolidated statements. Returns use average balances.
Not enough history to build valuation bands (needs two years of profits and prices).
| Period | CAIRN | Nifty 50 | Difference |
|---|---|---|---|
| 1 week | +1.2% | -2.8% | +3.9 pts |
| 1 month | -4.8% | -6.8% | +2.0 pts |
| 3 months | +5.5% | -7.6% | +13.1 pts |
| 6 months | +21.0% | +0.4% | +20.6 pts |
| 1 year | +89.5% | -9.9% | +99.4 pts |
| 2 years | +20.6% | -13.6% | +34.2 pts |
| 3 years | -14.8% | +14.2% | -29.0 pts |
| 5 years | -17.8% | +27.9% | -45.7 pts |
Red flags
F-score 4 of 8No red flags in the latest statements and filings.
Checks on the latest reported years: cash vs profit, accruals, receivables and inventory vs sales, dilution, debt, interest cover, equity, other income, losses, and auditor, top-management, insolvency and regulator filings in the last 12 months. A flag asks for an explanation; it is not a verdict.
Latest quarter
Dec 2016Sales ₹2,149 Cr +5.4% vs Dec 2015.
Net profit ₹604 Cr +1373.2%.
Activity
CompareNo listed peers in this industry.
No bulk or block deals on record.
| Ex-date | Action | Factor |
|---|---|---|
| 2016-07-08 | Annual General Meeting/ Dividend - Rs 3/- Per Share | |
| 2015-07-08 | Annual General Meeting/ Dividend - Rs 4/- Per Share | |
| 2014-09-22 | Interim Dividend Rs.5/- Per Share (Purpose Revised) | |
| 2014-07-09 | Annual General Meeting And Dividend Rs. 6.50/- Per Share | |
| 2013-10-25 | Interim Dividend Rs.6/- Per Share | |
| 2013-07-10 | Annual General Meeting/Final Dividend Rs.6.50 Per Equity Share | |
| 2012-11-05 | Interim Dividend Rs.5/- Per Share (Purpose Revised) | |
| 2012-08-08 | Annual General Meeting | |
| 2011-08-09 | Annual General Meeting | |
| 2010-09-06 | Annual General Meeting | |
| 2009-08-07 | Annual General Meeting | |
| 2008-06-13 | Agm | |
| 2007-09-10 | Agm |
No announcements in our files yet.
Company filings to NSE, newest first. Routine notices (trading window, newspaper copies) are left out. Click a row for the filing.
No short selling reported to NSE in our files.
Short sales disclosed by brokers to NSE, by trade date. Collected since late September 2026.
Not on any NSE surveillance list in the latest file.
Quick answers
What is the market cap of Cairn India Ltd(Merged)?
Cairn India Ltd(Merged) (CAIRN) has a market capitalisation of Rs 53,529 Cr. at the 2017-04-25 close.
What is the P/E ratio of Cairn India Ltd(Merged)?
Cairn India Ltd(Merged) trades at a P/E of 24.3 on trailing twelve-month profit, at the 2017-04-25 close.
What were Cairn India Ltd(Merged)'s latest quarterly results?
In the Dec 2016 quarter, Cairn India Ltd(Merged) sales was Rs 2,149 Cr (+5.4% vs Dec 2015) and net profit was Rs 604 Cr.