Oil and Natural Gas Corporation's intrinsic value using Intellectual Capital analysis

Oil and Natural Gas Corporation

BSE : 500312

|

NSE : ONGC

Industry : Oil Exploration

|

ISIN : INE213A01029

|

FreeFloat : 25.00%

|

FnO : Yes

|

LotSize : 4100

BSE SENSEX | BSE SENSEX 50 | Nifty 50 | Nifty50 Equal Weight | BSE 100 | BSE 100 Largecap TMC | BSE 200 | BSE 250 LargeMidcap | BSE Largecap | BSE LargeMidcap | Nifty 100 | Nifty 200 | Nifty LargeMidcap 250 | Nifty100 Equal Weight | Nifty100 Liquid 15 | Nifty Alpha Quality Value Low Voltlty 30 | BSE Oil & Gas | Nifty Energy | Nifty Oil and Gas | BSE Dividend Stability | BSE Enhanced Value | Nifty Dividend Opp 50 | Nifty50 Value 20 | Nifty500 Value 50 | BSE CARBONEX | BSE Bharat 22 | BSE India Infra | BSE PSU | Nifty Commodities | Nifty CPSE | Nifty PSE

Intellectual Capital (IC)	330,025.40
Net Worth (NW)	255,474.10
Intrinsic Worth (IW)	585,499.50
Market Cap (MC)	162,034.00
Economic Value Added	-5,163.13

Discount Rate	%
Liquidity Premium	%

Knowledge Basis (IC/IW)	56.37%
IC Gross Margin (EBITDA/IC)	23.28%
IC Net Margin (NPT/IC)	7.21%
Knowledge Turnover (Sales/IC)	1.67
Market to Intrinsic Value (MC/IW)	0.28

As Of	Intrinsic Value	Market Price
31 Dec 2019	Rs. 465.41	Rs. 128.80
22 May 2020	-	Rs. 76.15

Fundamental - medium term		Technical - near term		Combined outlook
EVA > 0 : No	Sell	10 DMA : Rs. 76.51	Sell	Strong Sell
KB > 50% : Yes		50 DMA : Rs. 71.48
0 < M2IV < 1 : Yes		Vol-Price trend : Falling

Question 3 - Is this stock undervalued?

Question 2 - Does this business have significant knowledge assets?

Question 1 - Is this business generating enough profits to cover its cost of capital?

* EVA is a registered trademark of Stern Stewart and Co.

Quarterly Results (Rs. Cr)

Quarter

Type*

Sales

Income

EBITDA

EBIT

PBT

PAT

NPT

Mar-17
S
21714.02
26233.56
9062.08
5857.25
5537.10
4340.18
8799.78

Jun-17
S
19073.54
19927.93
9677.76
6214.70
5937.77
3884.73
3564.81

Sep-17
S
18964.85
20896.32
11067.51
7561.73
7234.29
5130.74
6646.47

Dec-17
S
22995.88
24122.42
12045.76
7789.88
7479.95
5014.67
4857.79

Mar-18
S
23969.83
27703.54
12080.08
8834.63
8240.46
5915.12
1693.48

Jun-18
C
110367.10
111469.00
20548.04
14475.26
13968.03
8423.80
8287.15

Sep-18
C
113471.20
115295.80
19195.07
13620.35
14008.02
7808.08
8270.61

Dec-18
C
117305.80
119977.80
17515.64
11447.29
12758.42
9023.94
9556.23

Mar-19
C
112316.40
114866.80
17385.33
11074.96
10604.42
5202.85
4380.97

Jun-19
C
109514.80
111116.70
16887.35
11039.80
11121.45
6772.58
6693.61

Sep-19
C
101554.30
103236.60
15998.62
9273.63
9204.28
5485.97
5275.51

Dec-19
C
109443.40
111187.80
15655.46
8141.01
8348.90
4898.68
4903.68

* C - Consolidated, S - Standalone