Cairn India Financials
NSE: CAIRN | BSE: 532792
₹285.35
As on 25-Apr-2017IST
Market cap
₹53,538 Cr
Revenue (TTM)
₹7,790 Cr
P/E Ratio
--
P/B Ratio
1.1
Div. Yield
1.1 %
Income Statement (₹ Cr) |
TTM | Mar-16 | Mar-15 | Mar-14 | Mar-13 | Mar-12 | Mar-11 | Mar-10 | Mar-09 | Dec-07 | Dec-06 |
|---|---|---|---|---|---|---|---|---|---|---|---|
|
Operating Revenue
|
7,789.89
|
8,625.57
|
14,646.20
|
18,761.70
|
17,524.15
|
11,860.65
|
|||||
|
Total Income
|
10,194.54
|
10,764.13
|
16,474.45
|
20,264.41
|
18,697.04
|
12,798.66
|
|||||
|
Total Expenditure
|
4,579.27
|
5,390.85
|
6,142.55
|
5,075.98
|
4,490.99
|
2,606.24
|
|||||
|
EBITDA
|
3,210.62
|
3,234.72
|
8,503.65
|
13,685.72
|
13,033.16
|
9,254.41
|
|||||
|
Depreciation
|
2,791.30
|
3,107.15
|
2,569.47
|
2,297.36
|
1,845.92
|
1,440.30
|
|||||
|
EBIT
|
419.32
|
127.57
|
5,934.18
|
11,388.36
|
11,187.24
|
7,814.11
|
|||||
|
Interest
|
81.33
|
26.96
|
20.34
|
41.48
|
68.66
|
225.80
|
|||||
|
Other Income
|
2,404.65
|
2,138.56
|
1,828.25
|
1,502.71
|
1,172.89
|
938.01
|
|||||
|
Exceptional Items
|
--
|
-11,673.80
|
-2,633.00
|
--
|
--
|
-102.85
|
|||||
|
Profit before Tax
|
-8,931.16
|
-9,434.63
|
5,109.09
|
12,849.59
|
12,291.47
|
8,423.47
|
|||||
|
Provision for Tax
|
275.08
|
-2.75
|
629.49
|
417.80
|
235.08
|
485.73
|
|||||
|
Profit after Tax
|
-9,206.24
|
-9,431.88
|
4,479.60
|
12,431.79
|
12,056.39
|
7,937.74
|
|||||
|
Minority Interest
|
--
|
--
|
--
|
--
|
--
|
--
|
|||||
|
Share of Associate
|
--
|
--
|
--
|
--
|
--
|
--
|
|||||
|
Consolidated Profit
|
-9,206.24
|
-9,431.88
|
4,479.60
|
12,431.79
|
12,056.39
|
7,937.74
|
Liabilities (₹ Cr) |
TTM | Mar-16 | Mar-15 | Mar-14 | Mar-13 | Mar-12 | Mar-11 | Mar-10 | Mar-09 | Dec-07 | Dec-06 |
|---|---|---|---|---|---|---|---|---|---|---|---|
|
Shareholder's Funds
|
49,077.50
|
48,792.55
|
58,870.20
|
57,437.69
|
47,699.43
|
48,292.07
|
|||||
|
Minority Interest
|
--
|
--
|
--
|
--
|
--
|
--
|
|||||
|
Non-Current Liabilities
|
1,517.61
|
2,927.22
|
2,890.08
|
3,848.73
|
2,868.14
|
2,547.73
|
|||||
|
Current Liabilities
|
4,937.52
|
4,775.81
|
5,074.03
|
4,405.81
|
3,482.72
|
2,603.39
|
|||||
|
Total Liabilities
|
55,532.63
|
56,495.58
|
66,834.31
|
65,692.23
|
54,050.29
|
53,443.19
|
Assets (₹ Cr) |
TTM | Mar-16 | Mar-15 | Mar-14 | Mar-13 | Mar-12 | Mar-11 | Mar-10 | Mar-09 | Dec-07 | Dec-06 |
|---|---|---|---|---|---|---|---|---|---|---|---|
|
Non-Current Assets
|
26,952.10
|
27,072.73
|
47,476.46
|
43,558.12
|
34,287.37
|
41,998.19
|
|||||
|
Current Assets
|
26,603.85
|
29,422.85
|
19,357.85
|
22,134.11
|
19,762.92
|
11,445.00
|
|||||
|
Total Assets
|
55,532.63
|
56,495.58
|
66,834.31
|
65,692.23
|
54,050.29
|
53,443.19
|
|||||
|
Total Debt*
|
--
|
--
|
--
|
--
|
--
|
1,251.84
|
|||||
|
Net Current Assets
|
21,666.33
|
24,647.04
|
14,283.82
|
17,728.30
|
16,280.20
|
8,841.61
|
|||||
|
Contingent Liabilities
|
--
|
21,991.48
|
21,535.71
|
25,539.29
|
614.58
|
591.54
|
Cashflow (₹ Cr) |
TTM | Mar-16 | Mar-15 | Mar-14 | Mar-13 | Mar-12 | Mar-11 | Mar-10 | Mar-09 | Dec-07 | Dec-06 |
|---|---|---|---|---|---|---|---|---|---|---|---|
|
Cash From Operating Activities
|
--
|
4,133.88
|
9,520.18
|
11,094.20
|
11,055.63
|
7,068.95
|
|||||
|
Cash Flow from Investing Activities
|
--
|
-2,168.13
|
-5,941.35
|
-8,129.08
|
-13,058.06
|
-2,728.53
|
|||||
|
Cash from Financing Activities
|
--
|
-720.20
|
-3,433.36
|
-2,924.20
|
-2,397.73
|
-1,521.62
|
|||||
|
Net Cash Inflow / Outflow
|
--
|
1,245.55
|
145.47
|
40.92
|
-4,400.16
|
2,818.80
|
Financials Ratios |
TTM | Mar-16 | Mar-15 | Mar-14 | Mar-13 | Mar-12 | Mar-11 | Mar-10 | Mar-09 | Dec-07 | Dec-06 |
|---|---|---|---|---|---|---|---|---|---|---|---|
|
Adjusted EPS (₹)
|
13.37
|
-50.31
|
23.89
|
65.17
|
63.11
|
41.62
|
|||||
|
Cash EPS (₹)
|
--
|
-33.73
|
37.60
|
77.21
|
72.78
|
49.17
|
|||||
|
Adjusted Book Value (₹)
|
--
|
258.92
|
312.78
|
300.00
|
249.61
|
253.13
|
|||||
|
Dividend per Share (₹)
|
--
|
3.00
|
9.00
|
12.50
|
11.50
|
--
|
|||||
|
Cash Flow per Share (₹)
|
--
|
22.05
|
50.78
|
58.16
|
57.88
|
37.06
|
|||||
|
Free Cash Flow per Share (₹)
|
--
|
-39.69
|
22.69
|
55.06
|
61.46
|
33.82
|
Profitability Ratios |
TTM | Mar-16 | Mar-15 | Mar-14 | Mar-13 | Mar-12 | Mar-11 | Mar-10 | Mar-09 | Dec-07 | Dec-06 |
|---|---|---|---|---|---|---|---|---|---|---|---|
|
ROCE (%)
|
--
|
-17.48
|
8.82
|
24.52
|
25.42
|
18.71
|
|||||
|
ROE (%)
|
5.12
|
-17.60
|
7.73
|
23.70
|
25.13
|
17.95
|
|||||
|
ROA (%)
|
-14.81
|
-15.30
|
6.76
|
20.76
|
22.43
|
15.88
|
|||||
|
EBIT Margin (%)
|
5.38
|
1.48
|
40.52
|
60.70
|
63.84
|
65.88
|
|||||
|
Net Margin (%)
|
-90.31
|
-87.62
|
27.19
|
61.35
|
64.48
|
62.02
|
|||||
|
Cash Profit Margin (%)
|
--
|
-73.33
|
48.13
|
78.51
|
79.33
|
79.07
|
Growth Ratios |
TTM | Mar-16 | Mar-15 | Mar-14 | Mar-13 | Mar-12 | Mar-11 | Mar-10 | Mar-09 | Dec-07 | Dec-06 |
|---|---|---|---|---|---|---|---|---|---|---|---|
|
Revenue Growth (%)
|
-18.74
|
-41.11
|
-21.94
|
7.06
|
47.75
|
15.40
|
|||||
|
EBIT Growth (%)
|
12.66
|
-97.85
|
-47.89
|
1.80
|
43.17
|
10.66
|
|||||
|
Net Profit Growth (%)
|
4,953.16
|
-310.55
|
-63.97
|
3.11
|
51.89
|
25.31
|
|||||
|
EPS Growth (%)
|
-1,568.52
|
-310.55
|
-63.34
|
3.25
|
51.66
|
24.95
|
|||||
|
Book Value Growth (%)
|
--
|
-17.22
|
2.47
|
20.02
|
-1.24
|
20.15
|
Valuation Ratios |
TTM | Mar-16 | Mar-15 | Mar-14 | Mar-13 | Mar-12 | Mar-11 | Mar-10 | Mar-09 | Dec-07 | Dec-06 |
|---|---|---|---|---|---|---|---|---|---|---|---|
|
Price / Earnings
|
--
|
--
|
8.95
|
5.11
|
4.31
|
8.02
|
|||||
|
Price / Book Value
|
1.08
|
0.60
|
0.68
|
1.11
|
1.09
|
1.32
|
|||||
|
Dividend Yield (%)
|
1.05
|
1.94
|
4.21
|
3.76
|
4.23
|
--
|
|||||
|
EV/EBITDA
|
9.11
|
4.94
|
3.80
|
4.06
|
3.27
|
5.68
|
|||||
|
Close Price (₹)
|
242.15
|
153.85
|
213.85
|
333.00
|
272.45
|
333.90
|
|||||
|
High Price (₹)
|
269.20
|
239.80
|
386.00
|
339.30
|
367.00
|
401.10
|
|||||
|
Low Price (₹)
|
106.50
|
106.50
|
209.00
|
272.55
|
267.70
|
249.30
|
|||||
|
Market Cap (₹ Cr)
|
53,537.95
|
28,938.47
|
40,093.66
|
63,485.93
|
51,987.18
|
63,621.32
|
Solvency Ratios |
TTM | Mar-16 | Mar-15 | Mar-14 | Mar-13 | Mar-12 | Mar-11 | Mar-10 | Mar-09 | Dec-07 | Dec-06 |
|---|---|---|---|---|---|---|---|---|---|---|---|
|
Debt to Equity
|
--
|
--
|
--
|
--
|
--
|
0.03
|
|||||
|
Short term debt to equity ratio
|
--
|
--
|
--
|
--
|
--
|
--
|
|||||
|
Current Ratio
|
5.39
|
6.16
|
3.82
|
5.02
|
5.67
|
4.40
|
|||||
|
Quick Ratio
|
5.30
|
6.06
|
3.75
|
4.96
|
5.62
|
4.34
|
|||||
|
Interest Coverage
|
-108.81
|
-348.95
|
252.18
|
310.78
|
180.02
|
38.31
|
Operating Efficiency Ratios |
TTM | Mar-16 | Mar-15 | Mar-14 | Mar-13 | Mar-12 | Mar-11 | Mar-10 | Mar-09 | Dec-07 | Dec-06 |
|---|---|---|---|---|---|---|---|---|---|---|---|
|
Debtors to sales (%)
|
5.01
|
2.98
|
7.68
|
13.39
|
13.04
|
12.62
|
|||||
|
Asset Turnover
|
0.13
|
0.14
|
0.22
|
0.31
|
0.33
|
0.24
|
|||||
|
Receivable days
|
--
|
29.24
|
45.32
|
46.67
|
39.39
|
45.85
|
|||||
|
Inventory Days
|
--
|
17.18
|
7.99
|
4.80
|
3.46
|
3.49
|
|||||
|
Payable days
|
--
|
65.42
|
60.38
|
53.86
|
-7,613.02
|
85.56
|
|||||
|
Cash Conversion Cycle
|
--
|
-19.00
|
-7.06
|
-2.39
|
7,655.86
|
-36.22
|