Cairn India Ltd. (Amalgamated) - Stock Valuation and Financial Performance

BSE: 532792 | NSE: CAIRN | Oil Exploration | Mid Cap

BSE Share Price
Not Listed

DeciZen - make an informed investing decision on Cairn India

M-Cap below 100cr DeciZen not available

Cairn India Ltd. (Amalgamated) stock performance -

mw4me loader
P/E Ratio (CD):
0.00
Market Cap:
53,538 Cr.
52-wk low:
280
52-wk high:
287.4

Is an attractive stock to invest in?

1. Is a good quality company?

Past 10 year's financial track record analysis by Moneyworks4me indicates that Cairn India Ltd. (Amalgamated) is a good quality company.

2. Is undervalued or overvalued?

No data found

3. Is a good buy now?

No data found

10 Year X-Ray of Cairn India:

Analysis of Financial Track Record

Data adjusted to bonus, split, extra-ordinary income, rights issue and change in financial year end
Data adjusted to bonus, split, extra-ordinary income, rights issue and change in financial year end

Data adjusted to bonus, split, extra-ordinary income, rights issue and change in financial year end.

Financial track record gives insight into the company's performance on key parameters over the past ten years. MoneyWorks4me’s proprietary colour codes make it easy for retail investors to gauge the company’s past performance.
Cairn India Ltd. (Amalgamated) has performed well in majority of the past ten years indicating its past ten year financial track record is very good

Value Creation

Value Creation Index Colour Code Guide

Dec'06Dec'07Mar'09Mar'10Mar'11Mar'12Mar'13Mar'14Mar'15Mar'16TTM
ROCE % -0.1%0.4%1.8%2.4%16.5%16.8%24.1%22.2%9.4%-3.8%-
Value Creation
Index
NANANANA0.30.30.60.5-0.4-1.3-

Growth Parameters

Growth Parameters Colour Code Guide

Sales 931,0121,1461,62310,27811,86117,52418,76214,6468,6267,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.30.72.54.733.739.861.261.129.2-11-49.1
YoY Gr.-NA274.2%89.5%619.4%18.3%53.5%-0.1%-52.2%-137.5%-
BVPS (₹) 0165138.2177.4211.3253.1249.6300312.8258.9268.1
Adj Net
Profit
-50.11184688886,4037,59911,68511,6585,472-2,052-9,207
Cash Flow from Ops. -1445507741106,3387,06911,05611,0949,5204,134-
Debt/CF from Ops. -8.60.64.5310.40.20000-

CAGR

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%
BVPSNA4.2%1.2%-17.2%
Share Price - - - -

Key Financial Parameters

Performance Ratio Colour Code Guide

Dec'06Dec'07Mar'09Mar'10Mar'11Mar'12Mar'13Mar'14Mar'15Mar'16TTM
Return on
Equity %
-0.10.41.92.717.317.224.422.29.4-3.8-18.6
Op. Profit
Mgn %
-46.120.331.439.181.378.874.472.958.23943.8
Net Profit
Mgn %
-47.311.740.854.762.364.166.762.137.4-23.8-118.2
Debt to
Equity
000.10.10.100000-
Working Cap
Days
034526330995145156252474931679
Cash Conv.
Cycle
0-94-473-572-89-36-28-2-7-19562

Recent Performance Summary

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 %

Latest Financials - Cairn India Ltd. (Amalgamated)

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 11.5

Management X-Ray of Cairn India:

Shareholding Pattern

Promoter's Holding & Share Pledging

Pledged *65.8165.8165.8157.4957.4957.4957.4957.4957.4957.49
* Pledged shares as % of Promoter's holding (%)

Event Update

Login/Register to view analysis.

Analyst's Notes

Key Ratios of Cairn India

Adj EPS (Rs.)

Sales (Cr.)

ROE (%)

ROCE (%)

Profit And Loss

(All Figures are in Crores.)
PARTICULARSDec'06Dec'07Mar'09Mar'10Mar'11Mar'12Mar'13Mar'14Mar'15Mar'16
Sales38.741,012.261,432.671,623.0310,277.9311,860.6517,524.1518,761.7014,646.208,625.57
Operating Expenses 57.051,013.76983.15988.692,023.532,606.244,490.995,075.986,142.555,390.85
Manufacturing Costs7.05295.32281.49346.76592.08735.02978.011,323.561,954.422,242.81
Material Costs2.89-11.1722.23-36.60-26.36-26.26-27.42-14.13-1.14-48.59
Employee Cost 40.48323.32114.38109.62110.3888.86103.25274.12110.4699.07
Other Costs 6.63406.29565.04568.901,347.421,808.623,437.153,492.434,078.813,097.56
Operating Profit -18.31-1.50449.52634.348,254.409,254.4113,033.1613,685.728,503.653,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.22132.41551.03407.66128.80938.011,172.891,502.711,828.252,138.56
Interest 0.271.626.4114.80300.26225.8068.6641.4820.3426.96
Depreciation 0.653.376.2610.861,192.961,440.301,845.922,297.362,569.473,107.15
Exceptional Items 00000-102.8500-2,633-11,673.80
Profit Before Tax -13.01125.92987.891,016.346,889.978,423.4712,291.4712,849.595,109.09-9,434.63
Tax 5.64150.47184.44-34.77555.57485.73235.08417.80629.49-2.75
Profit After Tax -18.66-24.54803.451,051.116,334.407,937.7412,056.3912,431.794,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.14.25.533.341.663.165.223.9-50.3
Dividend Payout Ratio (%)0%0%0%0%0%0%18%19%38%-6%

Balance Sheet

(All Figures are in Crores.)
PARTICULARSDec'06Dec'07Mar'09Mar'10Mar'11Mar'12Mar'13Mar'14Mar'15Mar'16

Equity and Liabilities

Shareholders Fund 29,245.9229,341.0932,763.4333,821.9340,237.7548,281.0947,682.3157,229.6558,641.0748,544.69
Share Capital 1,765.311,778.401,896.671,896.971,901.921,907.401,910.241,907.631,874.851,874.86
Reserves 27,480.6127,562.6930,866.7631,924.9638,335.8446,373.6945,772.0755,322.0256,766.2246,669.83
Minority Interest0000000000
Debt517.89312.444,356.393,400.712,673.8200000
Long Term Debt517.89312.444,356.393,400.712,673.8200000
Short Term Debt0000000000
Trade Payables321.06358.78864.79865.25462.56607.16536.67620.77919.231,038.42
Others Liabilities 4,345.791,364.591,608.571,573.853,135.184,554.945,831.317,841.817,274.016,912.47
Total Liabilities 34,430.6631,376.9039,593.1839,661.7446,509.3253,443.1954,050.2965,692.2366,834.3156,495.58

Fixed Assets

Gross Block25,749.5625,867.4825,764.1126,041.5034,058.1735,703.8530,765.1433,595.7136,885.0539,701.98
Accumulated Depreciation83.1460.6180.1895.81730.381,434.566,175.148,519.8913,251.8616,366.64
Net Fixed Assets25,666.4325,806.8725,683.9325,945.7033,327.7934,269.2924,59025,075.8223,633.1923,335.34
CWIP 1,712.242,467.036,202.739,163.463,981.884,500.164,384.995,696.895,906.674,340.18
Investments 10.53712.89171.281,712.411,094.451,835.5710,382.2616,363.8415,233.4215,054.09
Inventories125.11121.60168.28290.9490.48136.07196.09297.05343.88468.29
Trade Receivables191.75134.86151.64306.751,482.861,496.842,285.192,512.401,124.97257.08
Cash Equivalents 6,134.781,331.796,527.07929.424,426.987,013.515,556.821,763.38851.692,385.45
Others Assets589.83801.86688.251,313.062,104.884,191.756,654.9413,982.8519,740.4910,655.15
Total Assets 34,430.6631,376.9039,593.1839,661.7446,509.3253,443.1954,050.2965,692.2366,834.3156,495.58

Cash Flow

(All Figures are in Crores.)
PARTICULARSDec'06Dec'07Mar'09Mar'10Mar'11Mar'12Mar'13Mar'14Mar'15Mar'16
Cash Flow From Operating Activity -60.10550.41968.05109.696,338.127,068.9511,055.6311,094.209,520.184,133.88
PBT -13.01125.92987.891,016.346,889.978,423.4712,154.8212,849.595,109.09-9,434.63
Adjustment 46.58597.24-3.67-23.201,716.14777.441,742.482,277.204,904.5813,231.31
Changes in Working Capital -93.66-90.77129.6-708.2-1008.83-2.9-572.98-1409.89593.83488.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.36666.18-1,541.66624.07-678.47-8,329.04-5,615.461,821.43596.40
Others -9,617.33-5,710.81-3,026.684,297.08-2,977.55905.74-3,097.70187.40-2,188.35-1,115.45
Cash Flow From Financing Activity 15,601.13-104.466,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.13209.362,552.342.0467.0556.5558.8714.8114.690.01
Net Proceeds from Borrowing 101.80-148.683,762.02-680.49-701.86-1,414-1,250000
Interest Paid 0-2.45-146.46-167.82-230.23-160.02-94.97-35.83-16.86-34.63
Dividend Paid 000000-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.401,746.39-1,546.39546.852,818.80-4,400.1640.92145.471,245.55
PARTICULARSDec'06Dec'07Mar'09Mar'10Mar'11Mar'12Mar'13Mar'14Mar'15Mar'16
Ratios
ROE (%)-0.06-0.082.593.1717.1617.9525.1323.77.73-17.6
ROCE (%)-0.040.432.972.7817.9718.7125.4224.528.82-17.48
Asset Turnover Ratio00.030.040.040.240.240.330.310.220.14
PAT to CFO Conversion(x)N/AN/A1.20.110.890.920.892.13N/A
Working Capital Days
Receivable Days1,807593752324639474529
Inventory Days1,1794437527335817
Payable Days000-8,626-9,194-7,434-7,61300-7,353

Cairn India Ltd. (Amalgamated) Stock News

Cairn India Ltd. (Amalgamated) FAQs

Company share prices are keep on changing according to the market conditions. The closing price of Cairn India on 01-Jan-1970 05:30 is ₹0.00.
Market capitalization or market cap is determined by multiplying the current market price of a company's shares with the total number of shares outstanding. As of 01-Jan-1970 05:30 the market cap of Cairn India stood at ₹53,538.
The latest P/E ratio of Cairn India as of 01-Jan-1970 05:30 is 36.69.
The latest P/B ratio of Cairn India as of 01-Jan-1970 05:30 is 1.32.
The 52-week high of Cairn India is ₹287.4 and the 52-week low is ₹279.9.
The TTM revenue is Trailing Twelve Months sales. The TTM revenue/sales of Cairn India is ₹4,151 ( Cr.) .

About Cairn India Ltd. (Amalgamated)

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 has been felicitated with the Golden Peacock Award for Business Excellence 2014.
  • Cairn India was felicitated with BusinessWorld Award for India’s Fastest Growing Company in middleweight category. Cairn India was ranked as India’s fastest growing company in Middleweight category (revenues in the range of Rs 5,000 crore to Rs 9,999 crore) for FY2014.
  • Cairn India’s Ravva asset was awarded the prestigious CII Southern Region "Excellence Award in EHS 2013"awards.
  • Cairn India was awarded the prestigious ‘FICCI Corporate Social Responsibility Award - 2013’ under ‘Category : Private Sector Companies with INR 3001 Crores per annum and above turnover’.
  • With a three-year CAGR of 121%, Cairn India Ltd was named as the world’s fastest growing energy company, for the second year in a row, in the Platts Top 250 Global Energy Company Rankings 2013.
  •  
  • 2012 -Cairn India won PetroFed Pipeline Transportation Award.

             -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.

  • Cairn India's Mangala Development Pipeline Project stood runners up in the 'Project of the Year Award' at the Project Management National conference 2011 held on 8 September, 2011 in Bangalore.
  • Cairn India was accorded the 'Superbrand' status on 27 July, 2011.
  • Cairn India won the ‘Golden Peacock Award for Corporate Social Responsibility’ for the year 2011.
  • Cairn India and ONGC joint venture commissioned the world’s longest continuously heated and insulated pipeline in June, 2010.
  • 2010 - Cairn India Ltd has been awarded ''CARE AAA (Triple A)'' rating by the Credit Analysis and Research Limited (CARE) for its INR 4,000 crore domestic borrowing, which is helping to finance the development of its world class oil fields In Rajasthan.
  • -Cairn India’s Managing Director & CEO, Rahul Dhir, received the prestigious Young Entrepreneur Award in the OCEANTEX World Expo 2010. -Cairn India received the Oil & Gas Deal of the Year - 2009 award for Asia Pacific region by Project Finance International (part of the Thomson Reuters Group) for having completed the financing arrangements for USD 1.6 billion at competitive pricing.-Cairn India tops the Platts ranking of Global Energy Companies; Reliance Industries Ltd and ONGC slips down. -Cairn India wins Spotlight Awards by League of American Communications Professionals -Cairn India won the 'Golden Peacock Award for Corporate Social Responsibility' during the year -Cairn India was awarded the 'Superbrand' status on 27 July, 2011. The award was received by Manu Kapoor, Director - Corporate Communication, Affairs & CSR, Cairn India from Planning Commission Deputy Chairman Montek Singh Ahluwalia at a grand ceremony in New Delhi.'

 

Read More Read Less
You have 2 views remaining as a Guest User. To get DeciZen Rating of 3,500+ Stocks based on their Quality, Valuation and Price Trend Login Now
© 2024 The Alchemists Ark Pvt. Ltd. All rights reserved. MoneyWorks4Me ® is a registered trademark of The Alchemists Ark Pvt.Ltd.