Cairn India Ltd(Merged)
Tapetide Score
Data-driven rating, 0–100. How it works →
No Tapetide Score has been computed for this stock yet.
Key Insights
Strengths
2- Company is almost debt free.
- Stock is trading at 1.09 times its book value
Weaknesses
4- The company has delivered a poor sales growth of -3.44% over past five years.
- Tax rate seems low
- Company has a low return on equity of 11.9% over last 3 years.
- Working capital days have increased from 84.1 days to 305 days
Technical Indicators
Oscillators
Bullish
Overall
Bearish
Moving Averages
Bearish
Growth Rate
change over 1 year
change over 1 year
Quarterly Results
| Particulars | Dec 2013 | 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,000 | 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,408 | 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,592 | 3,683 | 3,052 | 2,656 | 2,027 | 619 | 1,353 | 973 | 313 | 537 | 794 | 1,039 | 560 |
| OPM % | 72% | 73% | 68% | 67% | 58% | 23% | 51% | 43% | 15% | 31% | 42% | 51% | 26% |
| Other Income | 11 | 164 | -1,611 | 586 | 516 | -148 | 291 | 323 | 393 | -493 | 404 | 599 | 445 |
| Interest | 9 | 11 | 2 | 5 | 8 | 5 | 13 | 16 | 16 | 26 | 18 | 19 | 29 |
| Depreciation | 595 | 637 | 720 | 703 | 891 | 256 | 866 | 902 | 1,012 | 742 | 810 | 782 | 726 |
| PBT | 2,999 | 3,200 | 720 | 2,534 | 1,644 | 211 | 764 | 379 | -322 | -725 | 369 | 837 | 250 |
| Tax % | 4% | 5% | -52% | 10% | 18% | 214% | 34% | 14% | -5% | -22% | 3% | 7% | 68% |
| Net Profit | 2,884 | 3,035 | 1,093 | 2,278 | 1,350 | -241 | 501 | 326 | 41 | -564 | 360 | 779 | 604 |
| EPS (₹) | 15.09 | 15.91 | 5.83 | 12.15 | 7.2 | -1.28 | 2.67 | 1.74 | 0.22 | -3.01 | 1.92 | 4.15 | 3.22 |
Profit & Loss
| Particulars | 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 |
| PBT | -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 (₹) | -0.12 | -0.14 | 4.24 | 5.54 | 33.31 | 41.62 | 62.4 | 65.17 | 23.89 | -50.31 | 6.28 |
| Div. Payout % | 0% | 0% | 0% | 0% | 0% | 0% | 18% | 19% | 38% | -6% | — |
Balance Sheet
| Particulars | 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 |
Cash Flow
| Particulars | Dec 2006 | Dec 2007 | Mar 2009 | Mar 2010 | Mar 2011 | Mar 2012 | Mar 2013 | Mar 2014 | Mar 2015 | Mar 2016 |
|---|---|---|---|---|---|---|---|---|---|---|
| Operating | -60 | 550 | 968 | 110 | 6,338 | 7,069 | 11,056 | 11,094 | 9,520 | 4,134 |
| Investing | -9,406 | -6,430 | -5,097 | -601 | -4,941 | -2,248 | -13,058 | -8,132 | -5,943 | -2,165 |
| Financing | 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 |
Ratios
| Particulars | 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% |
Insights
BetaAI-extracted from concalls & annual reports · figures as reported, with sources
Log in to view Cairn India Ltd(Merged) insights
52 extracted metrics + investor summaries across FY06–FY17.
Documents
Frequently Asked Questions about Cairn India Ltd(Merged)
What does Cairn India Ltd(Merged) do?
Where is Cairn India Ltd(Merged) (CAIRN) listed?
Company Information
Cairn India is an oil and gas exploration, and production company. The Company is primarily engaged in the business of surveying, prospecting, drilling, exploring, acquiring, developing, producing, maintaining, refining, storing, trading, supplying, transporting, marketing, distributing, importing, exporting and generally dealing in minerals, oils, petroleum, gas and related by-products and other activities.
For AI agents and developers
Reading this as an AI agent, LLM or automated pipeline? Every page on Tapetide is also published as clean Markdown — no navigation, no scripts, just the data. Fetch https://tapetide.com/stocks/CAIRN.md for Cairn India Ltd(Merged): company profile, latest price, key fundamentals, the Tapetide Score, growth rates, quarterly and annual financial statements, shareholding pattern, technical indicators, analyst ratings and exchange filings.
Append .md to any Tapetide URL for the
same treatment. A full index of what we publish is at /llms.txt and /llms-full.txt. For
live, structured queries instead of documents, use our Indian stock market MCP server.