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 : 7700

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 | 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)	13,403.21
Net Worth (NW)	229,789.30
Intrinsic Worth (IW)	243,192.50
Market Cap (MC)	87,118.44
Economic Value Added	-1,402.59

Discount Rate	%
Liquidity Premium	%

Knowledge Basis (IC/IW)	5.51%
IC Gross Margin (EBITDA/IC)	388.81%
IC Net Margin (NPT/IC)	104.79%
Knowledge Turnover (Sales/IC)	28.53
Market to Intrinsic Value (MC/IW)	0.36

As Of	Intrinsic Value	Market Price
30 Sep 2020	Rs. 193.31	Rs. 69.25
15 Jan 2021	-	Rs. 101.40

Fundamental - medium term		Technical - near term		Combined outlook
EVA > 0 : No	Sell	10 DMA : Rs. 100.51	Reduce	Sell
KB > 50% : No		50 DMA : Rs. 87.82
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

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

Mar-20
C
104489.00
108014.30
-1565.84
-8337.62
-10528.96
-6576.68
-7112.48

Jun-20
C
62496.60
63575.47
9357.82
3509.88
2012.22
1090.03
909.31

Sep-20
C
83619.16
85577.85
15240.15
9616.45
8569.53
5800.82
5636.35

* C - Consolidated, S - Standalone