Tata Steel's intrinsic value using Intellectual Capital analysis

Tata Steel

BSE : 500470

|

NSE : TATASTEEL

Industry : Steel

|

ISIN : INE081A01020

|

FreeFloat : 63.57%

|

FnO : Yes

|

LotSize : 5500

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 Metal | Nifty Metal | BSE Dividend Stability | BSE Enhanced Value | BSE Quality | Nifty Dividend Opp 50 | Nifty High Beta 50 | Nifty50 Value 20 | Nifty500 Value 50 | BSE 100 ESG | BSE CARBONEX | NIFTY 100 ESG Sector Leaders | Nifty100 Enhanced ESG | Nifty100 ESG | BSE India Manufacturing | Nifty Commodities | Nifty Housing | Nifty India Manufacturing

Intellectual Capital (IC)	300,927.80
Net Worth (NW)	109,238.30
Intrinsic Worth (IW)	410,166.20
Market Cap (MC)	137,697.20
Economic Value Added	-5,223.45

Discount Rate	%
Liquidity Premium	%

Knowledge Basis (IC/IW)	73.37%
IC Gross Margin (EBITDA/IC)	18.85%
IC Net Margin (NPT/IC)	8.36%
Knowledge Turnover (Sales/IC)	0.94
Market to Intrinsic Value (MC/IW)	0.34

As Of	Intrinsic Value	Market Price
31 Dec 2022	Rs. 335.56	Rs. 112.65
20 Mar 2023	----	Rs. 104.50
20 Mar 2023	----	-2.50 -2.39%

Fundamental - medium term		Technical - near term		Combined outlook
EVA > 0 : No	Sell	10 DMA : Rs. 106.68	Sell	Strong Sell
KB > 50% : Yes		50 DMA : Rs. 113.36
0 < M2IV < 1 : Yes		Vol-Price trend : Falling
Disclaimer: Stock outlook is based on data calculations only and does NOT constitute investment advice.

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-20
C
33769.95
35085.86
724.67
425.63
-1499.45
-1615.35
-1073.54

Jun-20
C
24288.51
24481.09
771.45
-1339.37
-3337.64
-4648.13
-4139.26

Sep-20
C
37153.99
37376.13
6449.63
4188.50
2248.26
1665.07
1739.97

Dec-20
C
39594.09
39809.05
9613.34
7338.58
5560.70
4010.94
3942.19

Mar-21
C
49977.40
50249.58
13615.54
11223.13
9356.86
7161.91
6718.02

Jun-21
C
53371.81
53534.04
16212.72
13888.18
12076.75
9768.34
9588.82

Sep-21
C
60282.78
60553.63
16912.23
14623.38
13603.61
12547.70
11918.14

Dec-21
C
60783.11
60842.72
15942.16
13698.07
12165.58
9598.16
9168.36

Mar-22
C
69323.50
69615.70
15481.16
13237.77
12139.26
9835.12
11411.49

Jun-22
C
63430.07
63698.15
15400.40
13163.61
11945.50
7714.00
4748.25

Sep-22
C
59877.52
60206.78
6491.44
4143.62
2624.55
1297.06
-1544.71

Dec-22
C
57083.56
57354.16
4378.93
2010.55
242.63
-2501.95
-791.57

* C - Consolidated, S - Standalone