Indian Hotels Company's intrinsic value using Intellectual Capital analysis

Indian Hotels Company

BSE : 500850

|

NSE : INDHOTEL

Industry : Hospitality

|

ISIN : INE053A01029

|

FreeFloat : 61.80%

|

FnO : Yes

|

LotSize : 2000

BSE 200 | BSE 250 LargeMidcap | BSE LargeMidcap | Nifty 200 | Nifty LargeMidcap 250 | Nifty Midcap Liquid 15 | BSE 150 Midcap | BSE Midcap | BSE Midcap Select | Nifty Midcap 100 | Nifty Midcap 150 | Nifty Midcap 50 | Nifty Midcap Select | BSE Momentum | Nifty Alpha 50 | Nifty Midcap150 Momentum 50 | Nifty200 Alpha 30 | Nifty200 Momentum 30 | BSE CARBONEX | Nifty Infrastructure | Nifty MidSmall India Consumption | Nifty Non-Cyclical Consumer

Intellectual Capital (IC)	-3,087.29
Net Worth (NW)	8,353.40
Intrinsic Worth (IW)	5,266.11
Market Cap (MC)	45,261.06
Economic Value Added	-24.18

Discount Rate	%
Liquidity Premium	%

Knowledge Basis (IC/IW)	-58.63%
IC Gross Margin (EBITDA/IC)	-37.56%
IC Net Margin (NPT/IC)	-10.94%
Knowledge Turnover (Sales/IC)	-1.31
Market to Intrinsic Value (MC/IW)	8.59

As Of	Intrinsic Value	Market Price
31 Dec 2022	Rs. 37.07	Rs. 318.65
20 Mar 2023	----	Rs. 315.10
20 Mar 2023	----	-6.75 -2.14%

Fundamental - medium term		Technical - near term		Combined outlook
EVA > 0 : No	Sell	10 DMA : Rs. 318.71	Sell	Strong Sell
KB > 50% : No		50 DMA : Rs. 311.87
0 < M2IV < 1 : No		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
1062.98
1101.02
286.06
182.94
98.18
66.81
-34.08

Jun-20
C
143.61
175.34
-148.19
-248.33
-336.22
-312.60
-300.72

Sep-20
C
256.67
323.54
199.61
96.77
-262.59
-252.09
-275.02

Dec-20
C
559.86
614.53
65.97
-36.35
-148.40
-133.22
-98.54

Mar-21
C
615.02
626.47
108.11
3.78
-102.33
-97.72
-92.74

Jun-21
C
344.55
370.30
-102.74
-205.28
-315.02
-301.58
-262.39

Sep-21
C
728.37
752.28
85.92
-15.84
-129.69
-130.92
-166.16

Dec-21
C
1111.22
1133.92
334.21
234.34
109.45
95.96
97.40

Mar-22
C
872.08
954.88
233.63
131.75
52.57
71.57
107.21

Jun-22
C
1266.07
1293.19
419.71
317.13
254.78
180.84
169.84

Sep-22
C
1232.61
1257.57
324.15
221.58
161.58
129.59
84.60

Dec-22
C
1685.80
1743.51
679.56
576.25
519.53
403.56
549.95

* C - Consolidated, S - Standalone