BSE: 532792 | NSE: CAIRN | Oil Exploration | Mid Cap
Past 10 year's financial track record analysis by Moneyworks4me indicates that Cairn India Ltd. (Amalgamated) is a good quality company.
No data found
No data found
Data adjusted to bonus, split, extra-ordinary income, rights issue and change in financial year end.
| Dec'06 | Dec'07 | Mar'09 | Mar'10 | Mar'11 | Mar'12 | Mar'13 | Mar'14 | Mar'15 | Mar'16 | TTM | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| ROCE % ⓘ | -0% | 0.4% | 3% | 2.8% | 18% | 18.7% | 25.4% | 24.5% | 8.8% | -17.5% | - |
| Value Creation Index ⓘ | NA | NA | NA | NA | 0.4 | 0.4 | 0.7 | 0.6 | -0.4 | -2.2 | - |
Growth Parameters ⓘGrowth Parameters Colour Code Guide ⓘ | |||||||||||
| Sales ⓘ | 93 | 1,012 | 1,146 | 1,623 | 10,278 | 11,861 | 17,524 | 18,762 | 14,646 | 8,626 | 7,790 |
| Sales YoY Gr. | - | 988.7% | 13.2% | 41.6% | 533.3% | 15.4% | 47.8% | 7.1% | -21.9% | -41.1% | - |
| Adj EPS ⓘ | -0.3 | 0.7 | 2.5 | 4.7 | 33.7 | 39.8 | 61.2 | 61.1 | 29.2 | -11 | -49.1 |
| YoY Gr. | - | NA | 274.2% | 89.5% | 619.4% | 18.3% | 53.5% | -0.1% | -52.2% | -137.5% | - |
| BVPS (₹) ⓘ | 0 | 165 | 138.2 | 177.4 | 211.3 | 253.1 | 249.6 | 300 | 312.8 | 258.9 | 268.1 |
| Adj Net Profit ⓘ | -50.1 | 118 | 468 | 888 | 6,403 | 7,599 | 11,685 | 11,658 | 5,472 | -2,052 | -9,207 |
| Cash Flow from Ops. ⓘ | -144 | 550 | 774 | 110 | 6,338 | 7,069 | 11,056 | 11,094 | 9,520 | 4,134 | - |
| Debt/CF from Ops. ⓘ | -8.6 | 0.6 | 4.5 | 31 | 0.4 | 0.2 | 0 | 0 | 0 | 0 | - |
CAGR Colour Code Guide ⓘ
| 9 Years | 5 Years | 3 Years | 1 Years | |||||
|---|---|---|---|---|---|---|---|---|
| Sales ⓘ | 65.4% | -3.4% | -21% | -41.1% | ||||
| Adj EPS ⓘ | NA | -179.9% | -156.4% | -137.5% | ||||
| BVPSⓘ | NA | 4.2% | 1.2% | -17.2% | ||||
| Share Price | - | - | - | - | ||||
Performance Ratio Colour Code Guide ⓘ
| Dec'06 | Dec'07 | Mar'09 | Mar'10 | Mar'11 | Mar'12 | Mar'13 | Mar'14 | Mar'15 | Mar'16 | TTM | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Return on Equity % ⓘ | -0.1 | 0.4 | 1.9 | 2.7 | 17.3 | 17.2 | 24.4 | 22.2 | 9.4 | -3.8 | -18.6 |
| Op. Profit Mgn % ⓘ | -46.1 | 20.3 | 31.4 | 39.1 | 81.3 | 78.8 | 74.4 | 72.9 | 58.2 | 39 | 43.8 |
| Net Profit Mgn % ⓘ | -47.3 | 11.7 | 40.8 | 54.7 | 62.3 | 64.1 | 66.7 | 62.1 | 37.4 | -23.8 | -118.2 |
| Debt to Equity ⓘ | 0 | 0 | 0.1 | 0.1 | 0.1 | 0 | 0 | 0 | 0 | 0 | - |
| Working Cap Days ⓘ | 0 | 345 | 263 | 309 | 95 | 145 | 156 | 252 | 474 | 931 | 679 |
| Cash Conv. Cycle ⓘ | 0 | -94 | -473 | -572 | -89 | -36 | -28 | -2 | -7 | -19 | 562 |
No data to display
Return on Equity has declined versus last 3 years average to %
Sales growth has been subdued in last 3 years %
Sales growth is not so good in last 4 quarters at %
| Standalone | Consolidated | |
|---|---|---|
| TTM EPS (₹) | 7.8 | -49.1 |
| TTM Sales (₹ Cr.) | 4,151 | 7,790 |
| BVPS (₹.) ⓘ | 216.1 | 268.1 |
| Reserves (₹ Cr.) ⓘ | 38,669 | 48,412 |
| P/BV ⓘ | 1.32 | 1.06 |
| PE ⓘ | 36.69 | 0.00 |
| From the Market | |
|---|---|
| 52 Week Low / High (₹) | 279.95 / 287.40 |
| All Time Low / High (₹) | 88.15 / 400.95 |
| Market Cap (₹ Cr.) | 53,538 |
| Equity (₹ Cr.) | 1,875.9 |
| Face Value (₹) | 10 |
| Industry PE ⓘ | 8.5 |
| Pledged * | 65.81 | 65.81 | 65.81 | 57.49 | 57.49 | 57.49 | 57.49 | 57.49 | 57.49 | 57.49 |
| PARTICULARS | Dec'06 | Dec'07 | Mar'09 | Mar'10 | Mar'11 | Mar'12 | Mar'13 | Mar'14 | Mar'15 | Mar'16 |
|---|---|---|---|---|---|---|---|---|---|---|
| Sales | 38.74 | 1,012.26 | 1,432.67 | 1,623.03 | 10,277.93 | 11,860.65 | 17,524.15 | 18,761.70 | 14,646.20 | 8,625.57 |
| Operating Expenses ⓘ | 57.05 | 1,013.76 | 983.15 | 988.69 | 2,023.53 | 2,606.24 | 4,490.99 | 5,075.98 | 6,142.55 | 5,390.85 |
| Manufacturing Costs | 7.05 | 295.32 | 281.49 | 346.76 | 592.08 | 735.02 | 978.01 | 1,323.56 | 1,954.42 | 2,242.81 |
| Material Costs | 2.89 | -11.17 | 22.23 | -36.60 | -26.36 | -26.26 | -27.42 | -14.13 | -1.14 | -48.59 |
| Employee Cost | 40.48 | 323.32 | 114.38 | 109.62 | 110.38 | 88.86 | 103.25 | 274.12 | 110.46 | 99.07 |
| Other Costs ⓘ | 6.63 | 406.29 | 565.04 | 568.90 | 1,347.42 | 1,808.62 | 3,437.15 | 3,492.43 | 4,078.81 | 3,097.56 |
| Operating Profit ⓘ | -18.31 | -1.50 | 449.52 | 634.34 | 8,254.40 | 9,254.41 | 13,033.16 | 13,685.72 | 8,503.65 | 3,234.72 |
| Operating Profit Margin (%) | -47.3% | -0.1% | 31.4% | 39.1% | 80.3% | 78.0% | 74.4% | 72.9% | 58.1% | 37.5% |
| Other Income ⓘ | 6.22 | 132.41 | 551.03 | 407.66 | 128.80 | 938.01 | 1,172.89 | 1,502.71 | 1,828.25 | 2,138.56 |
| Interest ⓘ | 0.27 | 1.62 | 6.41 | 14.80 | 300.26 | 225.80 | 68.66 | 41.48 | 20.34 | 26.96 |
| Depreciation ⓘ | 0.65 | 3.37 | 6.26 | 10.86 | 1,192.96 | 1,440.30 | 1,845.92 | 2,297.36 | 2,569.47 | 3,107.15 |
| Exceptional Items ⓘ | 0 | 0 | 0 | 0 | 0 | -102.85 | 0 | 0 | -2,633 | -11,673.80 |
| Profit Before Tax ⓘ | -13.01 | 125.92 | 987.89 | 1,016.34 | 6,889.97 | 8,423.47 | 12,291.47 | 12,849.59 | 5,109.09 | -9,434.63 |
| Tax ⓘ | 5.64 | 150.47 | 184.44 | -34.77 | 555.57 | 485.73 | 235.08 | 417.80 | 629.49 | -2.75 |
| Profit After Tax | -18.66 | -24.54 | 803.45 | 1,051.11 | 6,334.40 | 7,937.74 | 12,056.39 | 12,431.79 | 4,479.60 | -9,431.88 |
| PAT Margin (%) | -48.2% | -2.4% | 56.1% | 64.8% | 61.6% | 66.9% | 68.8% | 66.3% | 30.6% | -109.0% |
| Adjusted EPS (₹) | -0.1 | -0.1 | 4.2 | 5.5 | 33.3 | 41.6 | 63.1 | 65.2 | 23.9 | -50.3 |
| Dividend Payout Ratio (%) | 0% | 0% | 0% | 0% | 0% | 0% | 18% | 19% | 38% | -6% |
| PARTICULARS | Dec'06 | Dec'07 | Mar'09 | Mar'10 | Mar'11 | Mar'12 | Mar'13 | Mar'14 | Mar'15 | Mar'16 |
|---|---|---|---|---|---|---|---|---|---|---|
Equity and Liabilities | ||||||||||
| Shareholders Fund | 29,245.92 | 29,341.09 | 32,763.43 | 33,821.93 | 40,237.75 | 48,281.09 | 47,682.31 | 57,229.65 | 58,641.07 | 48,544.69 |
| Share Capital ⓘ | 1,765.31 | 1,778.40 | 1,896.67 | 1,896.97 | 1,901.92 | 1,907.40 | 1,910.24 | 1,907.63 | 1,874.85 | 1,874.86 |
| Reserves ⓘ | 27,480.61 | 27,562.69 | 30,866.76 | 31,924.96 | 38,335.84 | 46,373.69 | 45,772.07 | 55,322.02 | 56,766.22 | 46,669.83 |
| Minority Interest | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Debt | 517.89 | 312.44 | 4,356.39 | 3,400.71 | 2,673.82 | 0 | 0 | 0 | 0 | 0 |
| Long Term Debt | 517.89 | 312.44 | 4,356.39 | 3,400.71 | 2,673.82 | 0 | 0 | 0 | 0 | 0 |
| Short Term Debt | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Trade Payables | 321.06 | 358.78 | 864.79 | 865.25 | 462.56 | 607.16 | 536.67 | 620.77 | 919.23 | 1,038.42 |
| Others Liabilities ⓘ | 4,345.79 | 1,364.59 | 1,608.57 | 1,573.85 | 3,135.18 | 4,554.94 | 5,831.31 | 7,841.81 | 7,274.01 | 6,912.47 |
| Total Liabilities ⓘ | 34,430.66 | 31,376.90 | 39,593.18 | 39,661.74 | 46,509.32 | 53,443.19 | 54,050.29 | 65,692.23 | 66,834.31 | 56,495.58 |
Fixed Assets | ||||||||||
| Gross Block | 25,749.56 | 25,867.48 | 25,764.11 | 26,041.50 | 34,058.17 | 35,703.85 | 30,765.14 | 33,595.71 | 36,885.05 | 39,701.98 |
| Accumulated Depreciation | 83.14 | 60.61 | 80.18 | 95.81 | 730.38 | 1,434.56 | 6,175.14 | 8,519.89 | 13,251.86 | 16,366.64 |
| Net Fixed Assetsⓘ | 25,666.43 | 25,806.87 | 25,683.93 | 25,945.70 | 33,327.79 | 34,269.29 | 24,590 | 25,075.82 | 23,633.19 | 23,335.34 |
| CWIP ⓘ | 1,712.24 | 2,467.03 | 6,202.73 | 9,163.46 | 3,981.88 | 4,500.16 | 4,384.99 | 5,696.89 | 5,906.67 | 4,340.18 |
| Investmentsⓘ | 10.53 | 712.89 | 171.28 | 1,712.41 | 1,094.45 | 1,835.57 | 10,382.26 | 16,363.84 | 15,233.42 | 15,054.09 |
| Inventories | 125.11 | 121.60 | 168.28 | 290.94 | 90.48 | 136.07 | 196.09 | 297.05 | 343.88 | 468.29 |
| Trade Receivables | 191.75 | 134.86 | 151.64 | 306.75 | 1,482.86 | 1,496.84 | 2,285.19 | 2,512.40 | 1,124.97 | 257.08 |
| Cash Equivalents | 6,134.78 | 1,331.79 | 6,527.07 | 929.42 | 4,426.98 | 7,013.51 | 5,556.82 | 1,763.38 | 851.69 | 2,385.45 |
| Others Assetsⓘ | 589.83 | 801.86 | 688.25 | 1,313.06 | 2,104.88 | 4,191.75 | 6,654.94 | 13,982.85 | 19,740.49 | 10,655.15 |
| Total Assets ⓘ | 34,430.66 | 31,376.90 | 39,593.18 | 39,661.74 | 46,509.32 | 53,443.19 | 54,050.29 | 65,692.23 | 66,834.31 | 56,495.58 |
| PARTICULARS | Dec'06 | Dec'07 | Mar'09 | Mar'10 | Mar'11 | Mar'12 | Mar'13 | Mar'14 | Mar'15 | Mar'16 |
|---|---|---|---|---|---|---|---|---|---|---|
| Cash Flow From Operating Activity ⓘ | -60.10 | 550.41 | 968.05 | 109.69 | 6,338.12 | 7,068.95 | 11,055.63 | 11,094.20 | 9,520.18 | 4,133.88 |
| PBT ⓘ | -13.01 | 125.92 | 987.89 | 1,016.34 | 6,889.97 | 8,423.47 | 12,154.82 | 12,849.59 | 5,109.09 | -9,434.63 |
| Adjustment ⓘ | 46.58 | 597.24 | -3.67 | -23.20 | 1,716.14 | 777.44 | 1,742.48 | 2,277.20 | 4,904.58 | 13,231.31 |
| Changes in Working Capital ⓘ | -93.66 | -90.77 | 129.6 | -708.2 | -1008.83 | -2.9 | -572.98 | -1409.89 | 593.83 | 488.24 |
| Tax Paid ⓘ | 0 | -81.98 | -145.77 | -175.26 | -1,259.16 | -2,129.06 | -2,268.69 | -2,622.70 | -1,087.32 | -151.04 |
| Cash Flow From Investing Activity ⓘ | -9,617.33 | -6,430.35 | -5,373.80 | -610.77 | -4,918.27 | -2,728.53 | -13,058.06 | -8,129.08 | -5,941.35 | -2,168.13 |
| Capex | 0 | -17.18 | -3,013.29 | -3,366.18 | -2,564.79 | -2,955.80 | -1,631.32 | -2,701.02 | -5,574.43 | -1,649.08 |
| Net Investments | 0 | -702.36 | 666.18 | -1,541.66 | 624.07 | -678.47 | -8,329.04 | -5,615.46 | 1,821.43 | 596.40 |
| Others ⓘ | -9,617.33 | -5,710.81 | -3,026.68 | 4,297.08 | -2,977.55 | 905.74 | -3,097.70 | 187.40 | -2,188.35 | -1,115.45 |
| Cash Flow From Financing Activityⓘ | 15,601.13 | -104.46 | 6,152.14 | -1,045.31 | -873 | -1,521.62 | -2,397.73 | -2,924.20 | -3,433.36 | -720.20 |
| Net Proceeds from Shares ⓘ | 15,551.13 | 209.36 | 2,552.34 | 2.04 | 67.05 | 56.55 | 58.87 | 14.81 | 14.69 | 0.01 |
| Net Proceeds from Borrowing ⓘ | 101.80 | -148.68 | 3,762.02 | -680.49 | -701.86 | -1,414 | -1,250 | 0 | 0 | 0 |
| Interest Paid ⓘ | 0 | -2.45 | -146.46 | -167.82 | -230.23 | -160.02 | -94.97 | -35.83 | -16.86 | -34.63 |
| Dividend Paid ⓘ | 0 | 0 | 0 | 0 | 0 | 0 | -954.88 | -2,388.05 | -1,943.09 | -676.04 |
| Others ⓘ | -51.80 | -162.70 | -15.76 | -199.03 | -7.96 | -4.15 | -156.75 | -515.13 | -1,488.10 | -9.54 |
| Net Cash Flow ⓘ | 5,923.70 | -5,984.40 | 1,746.39 | -1,546.39 | 546.85 | 2,818.80 | -4,400.16 | 40.92 | 145.47 | 1,245.55 |
| PARTICULARS | Dec'06 | Dec'07 | Mar'09 | Mar'10 | Mar'11 | Mar'12 | Mar'13 | Mar'14 | Mar'15 | Mar'16 |
|---|---|---|---|---|---|---|---|---|---|---|
| Ratios | ||||||||||
| ROE (%) | -0.06 | -0.08 | 2.59 | 3.17 | 17.16 | 17.95 | 25.13 | 23.7 | 7.73 | -17.6 |
| ROCE (%) | -0.04 | 0.43 | 2.97 | 2.78 | 17.97 | 18.71 | 25.42 | 24.52 | 8.82 | -17.48 |
| Asset Turnover Ratio | 0 | 0.03 | 0.04 | 0.04 | 0.24 | 0.24 | 0.33 | 0.31 | 0.22 | 0.14 |
| PAT to CFO Conversion(x) | N/A | N/A | 1.2 | 0.1 | 1 | 0.89 | 0.92 | 0.89 | 2.13 | N/A | Working Capital Days |
| Receivable Days | 1,807 | 59 | 37 | 52 | 32 | 46 | 39 | 47 | 45 | 29 |
| Inventory Days | 1,179 | 44 | 37 | 52 | 7 | 3 | 3 | 5 | 8 | 17 |
| Payable Days | 0 | 0 | 0 | -8,626 | -9,194 | -7,434 | -7,613 | 0 | 0 | -7,353 |
Cairn India is one of the largest independent oil and gas exploration and production companies in India with a market capitalisation of nearly US$ 10 billion. Cairn India was rated as the fastest-growing energy company in the world, as per 2012 & 2013 Platts Top 250 Global Energy Company Rankings.
Cairn India operates around 30 per cent of India’s domestic crude oil production. Cairn India is part of the Vedanta Group, a globally diversified natural resources group with wide ranging interests in aluminium, copper, zinc, lead, silver, iron ore, etc. Through its affiliates, Cairn India has been operating for close to 20 years playing an active role in developing India’s oil and gas resources. To date, Cairn India has opened 4 frontier basins with over 40 discoveries, 31 in Rajasthan alone.
The Mangala field in Rajasthan, discovered in January 2004, is the largest onshore oil discovery in India in more than two decades. Mangala, Bhagyam and Aishwariya fields - major discoveries in the Rajasthan blockhaave gross ultimate oil recovery of over 1 billion barrels.
Cairn India has a portfolio of 9 blocks - one block in Rajasthan, which contains multiple assets, two on the west coast and four on the east coast of India and one each in Sri Lanka and South Africa. Oil and gas is currently being produced from Rajasthan, Ravva and Cambay.
During June 2010, Cairn India and ONGC, the 70:30 joint venture partners in the Rajasthan Block, RJ-ON-90/1, commenced sales through the world’s longest continuously heated and insulated crude oil pipeline.
In Mach 2011, the Government of Sri Lanka (GOSL) signed Memorandum of Understanding (MoU) with Cairn Lanka, wholly owned subsidiary of Cairn India, to help in the construction and setting up of libraries at a number of schools identified by the GOSL in the Moneragala district for the benefit of children in the area.
The company has received ISO 14001 certified and OSHAS 18001 certification for its operating sites.
Awards
-Cairn India was awarded the Blue Dart Global CSR Award for 'Best Corporate Social Responsibility Practice Overall'. The award was presented by the Corporate Affairs Minister M Veerappa Moily at the Global CSR awards in Mumbai.
MoneyWorks4Me rating and ranking of funds for SIP is available to subscribers only. Moneyworks4Me is not a rating and ranking agency, however it is required that users have a way of selecting funds and building a Portfolio. The method used by it are described below to enable users to understand the logic behind the rating and ranking Subscriber will find more details on this in the various content made available from time to time. In case you need more please write to besafe@moneyworks4Me.com
MoneyWorks4Me rates and ranks mutual funds based on the following data-driven system:
Funds ranking in screeners: Performance Consistency and Quality are two parameters used for ranking funds for SIP. The ranking as follows GG, GO, GR, OG, OO, OR, RG, RO and RR.
With the same color-coded funds, the one with the higher Average 3-year rolling returns (over 5 to 10 years), the number that appears in the Performance tag, ranks higher.
Here is the summary:
The third tag Upside Potential is not relevant for SIP. It is relevant for lumpsum investments in Mutual Funds.
Make an informed decision for Stocks
Invest using an intelligent system with powerful data-driven tools that help you identify opportunities and make informed buy-hold-sell decisions
Buy quality Stocks when they are available at reasonable prices and supported by an upward price trend and Sell when they are Overvalued using the Decizen Rating System. Covers 3500+ stocks
Claim your FREE 15-day access to the most practical investing handbook.
Hurry, limited to the first 10 users today!
Become a savvy and confident
stock investor.
Don't miss out! First 10 users today get it FREE
Download APP
