Cairn India Ltd(Merged)

Cairn India Summary Chart Analysis Peers Quarters Profit & Loss Balance Sheet Cash Flow Ratios Investors Documents

Cairn India Ltd(Merged)

₹ 285 0.81%
25 Apr 2017
cairnindia.com BSE: 532792 NSE: CAIRN
About

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.

[ add key points ]
Website BSE NSE
  • Market Cap ₹ 53,529 Cr.
  • Current Price ₹ 285
  • High / Low ₹ /
  • Stock P/E 24.3
  • Book Value ₹ 262
  • Dividend Yield 0.00 %
  • ROCE 3.43 %
  • ROE 3.07 %
  • Face Value ₹ 10.0
Edit ratios

Pros

  • Company is almost debt free.
  • Stock is trading at 1.09 times its book value

Cons

  • 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

* The pros and cons are machine generated. Pros / cons are based on a checklist to highlight important points. Please exercise caution and do your own analysis.

Peer comparison

Sector: Crude Oil & Natural Gas Industry: Oil Drilling / Allied Services

Edit Columns
Loading peers table ...

Quarterly Results

Consolidated Figures in Rs. Crores / View Standalone

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
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
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%
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
Profit before tax 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%
2,884 3,035 1,093 2,278 1,350 -241 501 326 41 -564 360 779 604
EPS in Rs 15.09 15.91 5.83 12.15 7.20 -1.28 2.67 1.74 0.22 -3.01 1.92 4.15 3.22
Raw PDF

Profit & Loss

Consolidated Figures in Rs. Crores / View Standalone

Dec 2006 5m Dec 2007 Mar 2009 15m Mar 2010 Mar 2011 Mar 2012 Mar 2013 Mar 2014 Mar 2015 Mar 2016 TTM
39 1,012 1,433 1,623 10,278 11,861 17,524 18,762 14,646 8,626 7,790
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% 23% 39% 80% 78% 74% 73% 73% 39% 38%
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%
-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%
Compounded Sales Growth
10 Years: %
5 Years: -3%
3 Years: -21%
TTM: -19%
Compounded Profit Growth
10 Years: %
5 Years: -24%
3 Years: -48%
TTM: 224%
Stock Price CAGR
10 Years: 2%
5 Years: %
3 Years: %
1 Year: %
Return on Equity
10 Years: %
5 Years: 15%
3 Years: 12%
Last Year: 3%

Balance Sheet

Consolidated Figures in Rs. Crores / View Standalone

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
518 312 4,356 3,401 2,678 1,252 0 0 0 0
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
25,666 25,368 25,383 25,446 31,243 31,249 21,253 21,211 21,100 8,635
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
7,041 2,088 7,268 2,373 8,105 15,859 18,030 22,420 24,595 28,467
Total Assets 34,431 31,075 39,326 39,195 46,509 53,443 54,050 65,692 66,834 56,496

Cash Flows

Consolidated Figures in Rs. Crores / View Standalone

Dec 2006 Dec 2007 Mar 2009 Mar 2010 Mar 2011 Mar 2012 Mar 2013 Mar 2014 Mar 2015 Mar 2016
-60 550 968 110 6,338 7,069 11,056 11,094 9,520 4,134
-9,406 -6,430 -5,097 -601 -4,941 -2,248 -13,058 -8,132 -5,943 -2,165
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

Ratios

Consolidated Figures in Rs. Crores / View Standalone

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%

Shareholding Pattern

Numbers in percentages

Jun 2016Sep 2016Dec 2016
59.88% 59.86% 59.85%
15.75% 15.26% 14.76%
10.12% 10.91% 11.96%
0.01% 0.01% 0.01%
14.23% 13.96% 13.42%
No. of Shareholders 2,68,7802,48,5922,34,450

* The classifications might have changed from Sep'2022 onwards. The new XBRL format added more details from Sep'22 onwards.

Classifications such as banks and foreign portfolio investors were not available earlier. The sudden changes in FII or DII can be because of these changes.

Click on the line-items to see the names of individual entities.

Documents

Announcements

Annual reports

Concalls

  • Feb 2017
    Transcript
    Notes
    PPT
  • Jul 2016
    Transcript
    Notes
    PPT
  • Jan 2016
    Transcript
    Notes
    PPT