Cairn India Key Ratios
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 %
Key Ratios and Highlights
| Growth Score (%) | Quarterly | Annual (TTM) | |||
|---|---|---|---|---|---|
| Particulars | QoQ | YoY | 1-Year | 3-Years | 5-Years |
| Revenue | 5.43 | 5.39 | -18.74 | -24.47 | -9.90 |
| EBIT | 8.37 | 179.16 | 12.66 | -65.94 | -45.98 |
| Net Profit | -22.47 | 1,376.11 | 4,953.16 | -40.60 | -23.23 |
| EPS | -22.48 | 1,375.65 | -1,568.52 | -192.72 | -202.62 |
| Book Value | -- | -- | -17.22 | 1.23 | 4.15 |
| Key Ratios (%) | Average | Annual (TTM) | |||
|---|---|---|---|---|---|
| Particulars | 3-Years | 5-Years | TTM | Mar-16 | Mar-15 |
| EBIT-Margin
| 34.23 | 46.48 | 5.38 | 1.48 | 40.52 |
| Net Margin
| 0.31 | 25.48 | -90.31 | -87.62 | 27.19 |
| Return on equity
| 4.61 | 11.38 | 5.12 | -17.60 | 7.73 |
| Return on Capital
| 5.29 | 12.00 | -- | -17.48 | 8.82 |
| Return on Assets
| 4.08 | 10.11 | -14.81 | -15.30 | 6.76 |
| Debt to Equity (x)
| -- | -- | 0.00 | 0.00 | 0.00 |
Profitability
ROCE
--
--
Earning before interest and taxes / (Average net worth + Average total Debt) * 100
|
Company Name
|
TTM
|
Mar-16
|
Mar-15
|
Mar-14
|
Mar-13
|
|---|---|---|---|---|---|
|
Cairn India
|
--
|
-17.48
|
8.82
|
24.52
|
25.42
|
|
Peer Median
|
--
|
--
|
--
|
--
|
--
|
ROE
5.12
Lower than Peers by 6.05
Profit after tax / Average Net worth * 100
|
Company Name
|
TTM
|
Mar-16
|
Mar-15
|
Mar-14
|
Mar-13
|
|---|---|---|---|---|---|
|
Cairn India
|
5.12
|
-17.60
|
7.73
|
23.70
|
25.13
|
|
Peer Median
|
11.17
|
--
|
--
|
--
|
--
|
ROA
-14.81
Lower than Peers by 21.86
Profit after tax / Average Total assets * 100
|
Company Name
|
TTM
|
Mar-16
|
Mar-15
|
Mar-14
|
Mar-13
|
|---|---|---|---|---|---|
|
Cairn India
|
-14.81
|
-15.30
|
6.76
|
20.76
|
22.43
|
|
Peer Median
|
7.05
|
--
|
--
|
--
|
--
|
EBIT Margin
5.38
Lower than Peers by 14.49
Operating profit (EBIT) / Net Sales * 100
|
Company Name
|
TTM
|
Mar-16
|
Mar-15
|
Mar-14
|
Mar-13
|
|---|---|---|---|---|---|
|
Cairn India
|
5.38
|
1.48
|
40.52
|
60.70
|
63.84
|
|
Peer Median
|
19.88
|
--
|
--
|
--
|
--
|
Net Margin
-90.31
Lower than Peers by 106.61
Net profit / Total Income (Net sales plus other income) * 100
|
Company Name
|
TTM
|
Mar-16
|
Mar-15
|
Mar-14
|
Mar-13
|
|---|---|---|---|---|---|
|
Cairn India
|
-90.31
|
-87.62
|
27.19
|
61.35
|
64.48
|
|
Peer Median
|
16.30
|
--
|
--
|
--
|
--
|
Cash Profit Margin
--
--
(Net profit + Depreciation) / Gross Sales * 100
|
Company Name
|
TTM
|
Mar-16
|
Mar-15
|
Mar-14
|
Mar-13
|
|---|---|---|---|---|---|
|
Cairn India
|
--
|
-73.33
|
48.13
|
78.51
|
79.33
|
|
Peer Median
|
--
|
--
|
--
|
--
|
--
|
Revenue Growth
-18.74
Lower than Peers by 21.58
Year on year growth in net sales
|
Company Name
|
TTM
|
Mar-16
|
Mar-15
|
Mar-14
|
Mar-13
|
|---|---|---|---|---|---|
|
Cairn India
|
-18.74
|
-41.11
|
-21.94
|
7.06
|
47.75
|
|
Peer Median
|
2.84
|
--
|
--
|
--
|
--
|
EBIT Growth
12.66
Higher than Peers by 21.78
Year on year growth in operating profit (EBIT)
|
Company Name
|
TTM
|
Mar-16
|
Mar-15
|
Mar-14
|
Mar-13
|
|---|---|---|---|---|---|
|
Cairn India
|
12.66
|
-97.85
|
-47.89
|
1.80
|
43.17
|
|
Peer Median
|
-9.12
|
--
|
--
|
--
|
--
|
Net Profit Growth
4,953.16
Higher than Peers by 4,945.91
Year on year growth in profit after tax
|
Company Name
|
TTM
|
Mar-16
|
Mar-15
|
Mar-14
|
Mar-13
|
|---|---|---|---|---|---|
|
Cairn India
|
4,953.16
|
-310.55
|
-63.97
|
3.11
|
51.89
|
|
Peer Median
|
7.26
|
--
|
--
|
--
|
--
|
EPS Growth
-1,568.52
Lower than Peers by 1,557.11
Year on year growth in earnings per share
|
Company Name
|
TTM
|
Mar-16
|
Mar-15
|
Mar-14
|
Mar-13
|
|---|---|---|---|---|---|
|
Cairn India
|
-1,568.52
|
-310.55
|
-63.34
|
3.25
|
51.66
|
|
Peer Median
|
-11.41
|
--
|
--
|
--
|
--
|
Book Value Growth
--
--
Year on year growth in book value per share
|
Company Name
|
TTM
|
Mar-16
|
Mar-15
|
Mar-14
|
Mar-13
|
|---|---|---|---|---|---|
|
Cairn India
|
--
|
-17.22
|
2.47
|
20.02
|
-1.24
|
|
Peer Median
|
--
|
--
|
--
|
--
|
--
|
Solvency
Debt to Equity
--
--
Total debt / Net worth
|
Company Name
|
TTM
|
Mar-16
|
Mar-15
|
Mar-14
|
Mar-13
|
|---|---|---|---|---|---|
|
Cairn India
|
--
|
--
|
--
|
--
|
--
|
|
Peer Median
|
0.09
|
--
|
--
|
--
|
--
|
Short term debt to equity ratio
--
--
(Short term borrowings / Net worth)
|
Company Name
|
TTM
|
Mar-16
|
Mar-15
|
Mar-14
|
Mar-13
|
|---|---|---|---|---|---|
|
Cairn India
|
--
|
--
|
--
|
--
|
--
|
|
Peer Median
|
--
|
--
|
--
|
--
|
--
|
Current Ratio
5.39
Higher than Peers by 3.85
Current Assets / Current Liabilities and Provisions
|
Company Name
|
TTM
|
Mar-16
|
Mar-15
|
Mar-14
|
Mar-13
|
|---|---|---|---|---|---|
|
Cairn India
|
5.39
|
6.16
|
3.82
|
5.02
|
5.67
|
|
Peer Median
|
1.54
|
--
|
--
|
--
|
--
|
Quick Ratio
5.30
Higher than Peers by 3.98
(Current Assets - Inventory) / Current Liabilities and Provisions
|
Company Name
|
TTM
|
Mar-16
|
Mar-15
|
Mar-14
|
Mar-13
|
|---|---|---|---|---|---|
|
Cairn India
|
5.30
|
6.06
|
3.75
|
4.96
|
5.62
|
|
Peer Median
|
1.31
|
--
|
--
|
--
|
--
|
Interest Coverage
-108.81
Lower than Peers by 117.46
Earning before interest and taxes (EBIT) / Interest Expenses
|
Company Name
|
TTM
|
Mar-16
|
Mar-15
|
Mar-14
|
Mar-13
|
|---|---|---|---|---|---|
|
Cairn India
|
-108.81
|
-348.95
|
252.18
|
310.78
|
180.02
|
|
Peer Median
|
8.65
|
--
|
--
|
--
|
--
|
Operating Efficiency
Debtors to sales
5.01
Lower than Peers by 6.90
Debtors outstanding / Net Sales * 100
|
Company Name
|
TTM
|
Mar-16
|
Mar-15
|
Mar-14
|
Mar-13
|
|---|---|---|---|---|---|
|
Cairn India
|
5.01
|
2.98
|
7.68
|
13.39
|
13.04
|
|
Peer Median
|
11.91
|
--
|
--
|
--
|
--
|
Asset Turnover
0.13
Lower than Peers by 0.28
Sales / Average Total Assets
|
Company Name
|
TTM
|
Mar-16
|
Mar-15
|
Mar-14
|
Mar-13
|
|---|---|---|---|---|---|
|
Cairn India
|
0.13
|
0.14
|
0.22
|
0.31
|
0.33
|
|
Peer Median
|
0.40
|
--
|
--
|
--
|
--
|
Receivable days
--
--
Average Debtors / Sales * 365
|
Company Name
|
TTM
|
Mar-16
|
Mar-15
|
Mar-14
|
Mar-13
|
|---|---|---|---|---|---|
|
Cairn India
|
--
|
29.24
|
45.32
|
46.67
|
39.39
|
|
Peer Median
|
--
|
--
|
--
|
--
|
--
|
Inventory Days
--
--
Average Inventory / Sales * 365
|
Company Name
|
TTM
|
Mar-16
|
Mar-15
|
Mar-14
|
Mar-13
|
|---|---|---|---|---|---|
|
Cairn India
|
--
|
17.18
|
7.99
|
4.80
|
3.46
|
|
Peer Median
|
--
|
--
|
--
|
--
|
--
|
Payable days
--
--
Average Creditors / Cost of goods sold * 365
|
Company Name
|
TTM
|
Mar-16
|
Mar-15
|
Mar-14
|
Mar-13
|
|---|---|---|---|---|---|
|
Cairn India
|
--
|
65.42
|
60.38
|
53.86
|
-7,613.02
|
|
Peer Median
|
--
|
--
|
--
|
--
|
--
|
Cash Conversion Cycle
--
--
Receivable Days + Inventory Days - Payable Days
|
Company Name
|
TTM
|
Mar-16
|
Mar-15
|
Mar-14
|
Mar-13
|
|---|---|---|---|---|---|
|
Cairn India
|
--
|
-19.00
|
-7.06
|
-2.39
|
7,655.86
|
|
Peer Median
|
--
|
--
|
--
|
--
|
--
|
Valuation
Price / Earnings
--
--
Current share price divided by earning per share in the last twelve months
|
Company Name
|
TTM
|
Mar-16
|
Mar-15
|
Mar-14
|
Mar-13
|
|---|---|---|---|---|---|
|
Cairn India
|
--
|
--
|
8.95
|
5.11
|
4.31
|
|
Peer Median
|
8.70
|
--
|
--
|
--
|
--
|
Price / Book Value
1.08
Lower than Peers by 0.15
Current share price divided by book value per share in the latest financial year
|
Company Name
|
TTM
|
Mar-16
|
Mar-15
|
Mar-14
|
Mar-13
|
|---|---|---|---|---|---|
|
Cairn India
|
1.08
|
0.60
|
0.68
|
1.11
|
1.09
|
|
Peer Median
|
1.23
|
--
|
--
|
--
|
--
|
Dividend Yield
1.05
Lower than Peers by 1.40
Dividend per share in the past twelve months divided by current share price
|
Company Name
|
TTM
|
Mar-16
|
Mar-15
|
Mar-14
|
Mar-13
|
|---|---|---|---|---|---|
|
Cairn India
|
1.05
|
1.94
|
4.21
|
3.76
|
4.23
|
|
Peer Median
|
2.46
|
--
|
--
|
--
|
--
|
EV/EBITDA
9.11
--
Enterprise Value (Current Market Capitalisation + Total Debt - Cash & Equivalents) / Earnings before interest, taxes, depreciation and taxes (EBITDA)
|
Company Name
|
TTM
|
Mar-16
|
Mar-15
|
Mar-14
|
Mar-13
|
|---|---|---|---|---|---|
|
Cairn India
|
9.11
|
4.94
|
3.80
|
4.06
|
3.27
|
|
Peer Median
|
--
|
--
|
--
|
--
|
--
|
Market Cap
53,538
Lower than Peers by 22,644
Current Share price multiplied by latest total number of shares outstanding
|
Company Name
|
TTM
|
Mar-16
|
Mar-15
|
Mar-14
|
Mar-13
|
|---|---|---|---|---|---|
|
Cairn India
|
53,538
|
28,938
|
40,094
|
63,486
|
51,987
|
|
Peer Median
|
76,182
|
--
|
--
|
--
|
--
|