CAIRN
India Ltd.
A Brief
Value Investing Research Report
14th January, 2017
Download
Company history and
business:
Cairn
India is one of the largest independent oil and gas exploration and production
companies in India with a market capitalisation of Rs.49531 crores.
Cairn India had 27% of India’s domestic crude oil production in
FY 2015-16. Through its affiliates, the company has been operating for over 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 numerous discoveries, 38 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, the three major discoveries in the Rajasthan
block, together, have a gross hydrocarbons initially-in-place of about 2.2
billion barrels of oil equivalent.
Cairn India has a portfolio of 8 blocks of which 7 blocks are in
India - one in Rajasthan with multiple assets, two on the west coast and four
on the east coast - and one in block in South Africa. Oil and gas is currently
being produced from Rajasthan, Ravva in Andhra Pradesh and Cambay in Gujarat.
The company is headquartered in Gurgaon in the National Capital
Region with domestic offices operating across India in Andhra Pradesh, Gujarat,
Rajasthan, and Tamil Nadu.
Basic Filtering Criteria:
|
CAIRN India Share's Market Snapshot |
|
(Rs. Crore/ Rs. 10 million)
|
Minimum Required
|
Actual
|
|
1
|
Turnover
|
1000
|
8,625
|
Pass
|
2
|
Market Capitalization
|
1000
|
49532
|
Pass
|
3
|
Price to Earnings Ratio
|
Less than 15
|
104.8
|
Fail
|
4
|
Price to Book Value
|
Less than 1.5
|
1.01
|
Pass
|
5
|
Dividend Yield
|
4-5%
|
1.14%
|
Fail
|
As
per basic value investing filtering criteria Cairn India’s share can be taken
up as it passes three out of the five filtering criteria.
A. Company Performance
Profitability
Analysis
Consolidated Profit & Loss Account (Rs. Crore/ Rs. 10 million)
|
Mar ' 16
|
Mar ' 15
|
Q2 Sep 2016
|
Revenue from Operations
|
8625.57
|
14646.2
|
2038.59
|
|
|
|
|
Cess on crude oil
|
2604.95
|
2799.43
|
495.06
|
Share of expenses from producing oil and gas
blocks
|
2093.49
|
1767.24
|
464.48
|
(Increase)/ Decrease in inventories of
finished goods
|
-48.59
|
-1.14
|
-18.6
|
Employee Costs
|
99.07
|
110.46
|
17.81
|
Exploration costs written off
|
260.04
|
1098.04
|
1.11
|
Other Expenses
|
251.75
|
349.54
|
39.61
|
Total Operating Expenses
|
5260.71
|
6123.57
|
999.47
|
EBDITA
|
3364.86
|
8522.63
|
1039.12
|
Depletion, depreciation and amortization
expense
|
3107.15
|
2569.47
|
781.82
|
Finance Costs
|
26.96
|
20.34
|
19.28
|
Earnings Before Tax (EBT)
|
230.75
|
5932.82
|
238.02
|
Non-Operating Income
|
2008.42
|
1809.27
|
599.31
|
Profit Before Tax and Exceptional items
|
2239.17
|
7742.09
|
837.33
|
Exceptional Items
|
11673.80
|
2633.00
|
0
|
(Loss)/ Profit Before Tax (PBT)
|
-9434.63
|
5109.09
|
837.33
|
Tax Expenses
|
-2.75
|
629.49
|
58.63
|
Profit After Tax (PAT)
|
-9431.88
|
4479.60
|
778.70
|
|
|
|
|
EBDITA Margin - % of Sales
|
39.01%
|
58.19%
|
50.97%
|
Interest Cost - % of Sales
|
0.31%
|
0.14%
|
0.95%
|
EBT Margin - % of Sales
|
2.68%
|
40.51%
|
11.68%
|
PBT&E Margin - % of Sales
|
25.96%
|
52.86%
|
41.07%
|
PBT Margin - % of Sales
|
-109.38%
|
34.88%
|
41.07%
|
PAT Margin - % of Sales
|
-109.35%
|
30.59%
|
38.20%
|
Highlights:
- Crude oil prices had a taken hit throughout
the world. From about US$ 114 a barrel it had plunged to below US$ 20 barrel
briefly.
- EBDITA has fallen in the financial year
2015-16 compared to the previous year, in the light of price hit but still it
is very good at 39%.
- EBT margin has been pulled down in FY
2015-16 by depreciation, a major non-cash expense of Cairn, being a fairly new
player with relatively latest and high cost assets. High price realisation in
FY 2014-15 could absorb the depreciation charge and still could produce a very
good EBT mark-up. Presently oil prices having stabilised at around US$ 40 a
barrel, for the quarter ending 30th September 2016, CAIRN’s EBT
again has gained respectability and stands at a decent 11.68% and PAT stands at
38.20% - better than the results of FY 2014-15.
- Finance cost is negligible as the company
is generally cash-rich and carries no borrowing on the books.
- CAIRN
has a large and significant non-operating
income comprising of interest and dividends from current investments created
from huge accumulated profits of yester years, that can protect investors
dividends even during troubled times as it has done during in last financial
year. It had also restored the PBT&E ratio to a very good 25.96%.
- The huge exceptional item of Rs.11,673.80
crores, which has resulted in a loss represents non-cash write down of acquisition goodwill in the light of the low
crude oil price realisation. This is a good and conservative move by the
company, which has effectively wiped off almost all the intangible asset
goodwill. Even though the profit and loss account shows a huge hole, the cash
flow statement is still very healthy.
On profitability parameter the company’s performance
appears poor, accentuated by the huge exceptional write-off, but it is temporary and as the oil prices gain
the company has already come back to profitability and going forward its
prospects can only be better.
Balance
Sheet Analysis
CAIRN India Ltd.
Consolidated Balance Sheet (Rs. Crore/ Rs. 10 million)
|
Mar ' 16
|
Mar ' 15
|
LIABILITIES
|
|
|
Share Capital
|
1874.86
|
1874.85
|
Reserves and Surplus
|
46917.69
|
56995.35
|
Total Net Worth
|
48792.55
|
58870.20
|
Long-term Borrowings
|
|
|
Other
Long-term Liabilities (Deferred Tax)
|
1102.83
|
1271.83
|
Long-term
Provisions
|
1824.39
|
1618.25
|
Total
Long Term Liabilities
|
2927.22
|
2890.08
|
Short-term
Borrowings
|
0.00
|
0.00
|
Trades
Payable
|
1038.42
|
919.23
|
Other
Current Liabilities
|
3019.42
|
3098.77
|
Short-term
Provisions
|
717.97
|
1056.03
|
Total
Current Liabilities
|
4775.81
|
5074.03
|
Total
Liabilities
|
56495.58
|
66834.31
|
ASSEST
|
|
|
Fixed
Assets
|
8165.85
|
8454.75
|
Capital
Work-in-Progress (CWIP)
|
1324.07
|
2352.39
|
Total
|
9489.92
|
10807.14
|
Non-Current
Investments
|
0.00
|
0.00
|
Deferred
Tax Assets
|
0.00
|
0.00
|
Long-term
Loans & Advances
|
7754.65
|
16273.43
|
Other
Non-Current Assets
|
3032.19
|
1663.17
|
Total
|
10786.84
|
17936.60
|
Current
Investments
|
15054.09
|
15233.42
|
Inventories
|
468.29
|
343.88
|
Trade
Receivables
|
257.08
|
1124.97
|
Cash
& Cash Equivalents
|
2385.45
|
851.69
|
Short-term
Loans & Advances
|
10875.63
|
1576.37
|
Other
Current Assets
|
382.31
|
227.52
|
Total
|
29422.85
|
19357.85
|
Intangible
assets
|
3779.86
|
15178.44
|
Goodwill
on Consolidation
|
3016.11
|
3554.28
|
Total
|
6795.97
|
18732.72
|
Total
Assets
|
56495.58
|
66834.31
|
Highlights:
- The reserves have fallen by about
Rs.10,000 crores because of the exceptional write-off. However since the write-off
had reduced the intangible asset
goodwill, the tangible net worth (TNW) has actually improved and improved the
important TOL/ TNW Ratio from 1.74 to 1.41. Value investing requirement is
below 3 and lesser the better.
- The current ratio, which measures the
short-term liquidity, has almost doubled to 6.16 from 3.82, the norm being
above 2 and higher the better.
- Long-term debt equity ratio of 0.06 is
very, very healthy and indicates that company has not borrowed long-term funds.
Overall,
the Balance Sheet of CAIRN India demonstrates immense strength.
Cash Flow Analysis:
Consolidated Cash Flow Statement (Rs. Crore/ Rs. 10 million)
|
Mar ' 16
|
Mar ' 15
|
Net
Cash from Operating Activities
|
4133.88
|
9520.18
|
Interest
|
-34.63
|
-16.86
|
Adjusted
Net Operating Cash Flows (Free Cash Flows)
|
4099.25
|
9503.32
|
|
|
|
Purchase
of Fixed Assets & CWIP
|
-1649.08
|
-5574.43
|
Proceeds
from Sale/ Maturity of current investments
|
596.40
|
1821.43
|
Loans
given to related party
|
0.00
|
-7742.50
|
Fixed
Deposits
|
-1640.30
|
5045.66
|
Interest
Received
|
610.63
|
545.76
|
Others
|
-85.78
|
-37.27
|
Net
Cash Used in Investing Activities
|
-2168.13
|
-5941.35
|
|
|
|
Long-term
Borrowings
|
0.00
|
0.00
|
Proceeds
from Issue of Equity Share Capital
|
0.01
|
14.69
|
Buy
Back of equity shares
|
143.13
|
-1121.76
|
Repayment
of Long-term Borrowings
|
0.00
|
0.00
|
Payment
of Dividends
|
-676.04
|
-1943.09
|
Tax on
dividend paid
|
-152.67
|
-366.34
|
Net
Cash Flow from Financing Activities
|
-685.57
|
-3416.50
|
|
|
|
Net (Decrease)/ Increase in Cash for the Year
|
1245.55
|
145.47
|
|
|
145.47
|
Dividend
Distribution as a % of PB&ET
|
30.19%
|
25.10%
|
Highlights:
- The cash flow analysis shows strong
generation of free cash flows from operations despite losses. The reasons for
this is that the losses are primarily due to non-cash depreciation, amortisation and exceptional write-down
charges. As the oil prices improve the cash generation will become even more
profound.
- Though subdued compared to the previous
year, cash invested in creation of new fixed assets is decent.
- Interest received is a welcome and
significant cash generation component supporting the almost equal amount of
dividend paid.
- Dividend paid accounts for a very healthy
30% of the profits before tax and exceptional items.
Overall
CARN’s cash flows are not only very strong but one of the main attractions of
the company.
B. Market Conditions:
Price to Earnings Ratio:
A PE Ratio of
104.80 is not favourable.
The reason for
the high PE multiple is more owing to low earnings per share (EPS) rather than
high market price.
Market
condition on this parameter is not favourable.
Price to Book Value per Share:
With a price to book value ratio at 1.01
the market condition is below the maximum permitted 1.5 and therefore is
favourable. Of course the assets are not available on a discount – they are just
available at their full value and there is no premium attached either.
Market
condition on this parameter is favourable.
Dividend Yield:
Dividend yield
of 1.14% is poor. The low dividend is caused by low oil prices and consequent
losses and not on account of high market price. Company has to be praised for
shelling out over 30% of profits before tax and exception items even after
overall loss.
Market
condition on this parameter is unfavourable, but the company can be forgiven for the unusually harsh market conditions.
Distance from 52 week high:
The share price is far away from the 52
week low and very near the 52 week high.
Market condition on
this parameter is unfavourable.
Five-year price graph:
|
Graph shows CAIRN India Share Price Movement in the last five years |
The price graph
clearly shows that after falling steeply the share price started climbing too,
steeply. In the middle of January 2016 the price was just Rs.110. In one year
it has more than doubled. Still it is nowhere near its peak of Rs.392 seen in
February 2012.
Thus even
though the price has increased in the last 12 months, there is still a lot of
scope for further gains and therefore
current market condition is still favourable.
Five-year share price return:
|
Table shows Returns or Increase in CAIRN India's share price |
Table shows that even though the share
price of Cairn has appreciated over 100% in the last 12 months, still it is
lower by about 20% compared to those prevailing in the last three and five
years.
On
this parameter the market condition even though is not ideal but is still favourable.
C. Final Conclusions:
- Cairn India Ltd. is a wonderful company
that has been currently struggling to maintain profitability in the face of severe
market conditions for crude oil, the product of the company. However the oil
prices are stabilizing and the prospects again brighten for the company.
- Cairn has shown loss in the previous
financial year but this is on account of an exceptional write-down goodwill to the huge extent of Rs.11,000 crores (US$
1.57 Billions). For the second quarter ending 30th September 2016,
Cairn has crawled back into profits on the back of stabilizing crude oil
prices.
- Cairn’s balance sheet is very strong
despite losses.
- Company’s cash flows are robust despite
losses because the losses are caused by non-cash
write-offs.
- A robust non-operating income out of
investments of accumulated profits is the company’s big strength and attraction.
- Due to the short period of existence of
the company, the uninterrupted dividend paying history is short.
- The dividend yield is low because the
quantum of dividend paid in the financial year 2015-16 is low on account of
losses. However the company has paid out an appreciable over 30% of its profits
before tax and exceptional items.
- Market conditions are not highly
attractive but not bad either. PE Ratio is too high but the culprit is low
profits. Price to book value (P2BV) ratio is in the attractive zone.
D.
Final Investment Advice:
CAIRN
India Ltd. is a wonderful company. Assets are available at face value – there is
no discount or premium.
Start
buying and accumulating this stock. If the price falls and P2BV drops below 1,
buy more. Similarly as the PE Ratio improves and falls below 15, buy more.
Post Disclaimer: Opinions expressed here are the author’s personal opinions. Market conditions have a great bearing on many end results discussed in this report. No disrespect is intended towards the company, it’s management. Investors are advised not rely blindly on the opinions expressed herein but to exercise their own judgment. Neither the author nor the blog shall be responsible for any loss suffered by either acting or not acting based on the opinions expressed herein.