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 | 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)	88,847.77
Net Worth (NW)	224,780.50
Intrinsic Worth (IW)	313,628.30
Market Cap (MC)	85,923.31
Economic Value Added	-16,417.42

Discount Rate	%
Liquidity Premium	%

Knowledge Basis (IC/IW)	28.33%
IC Gross Margin (EBITDA/IC)	61.15%
IC Net Margin (NPT/IC)	17.75%
Knowledge Turnover (Sales/IC)	4.48
Market to Intrinsic Value (MC/IW)	0.27

As Of	Intrinsic Value	Market Price
31 Mar 2020	Rs. 249.30	Rs. 68.30
3 Aug 2020	-	Rs. 75.90

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

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

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

* C - Consolidated, S - Standalone