Colgate Palmolive India's intrinsic value using Intellectual Capital analysis

Colgate Palmolive India

BSE : 500830

|

NSE : COLPAL

Industry : Personal Care MNC

|

ISIN : INE259A01022

|

FreeFloat : 50.00%

|

FnO : Yes

|

LotSize : 350

BSE 100 | BSE 100 Largecap TMC | BSE 200 | BSE 250 LargeMidcap | BSE LargeMidcap | BSE SENSEX Next 50 | Nifty 100 | Nifty 200 | Nifty LargeMidcap 250 | Nifty Next 50 | Nifty100 Equal Weight | BSE Midcap | BSE Midcap Select | Nifty Alpha Low Volatility 30 | Nifty Alpha Quality Low Volatility 30 | Nifty Alpha Quality Value Low Voltlty 30 | Nifty Quality Low Volatility 30 | Nifty FMCG | Nifty MNC | BSE Low Volatility | BSE Quality | Nifty Dividend Opp 50 | Nifty Low Volatility 50 | Nifty100 Low Volatility 30 | Nifty100 Quality 30 | Nifty200 Quality 30 | BSE 100 ESG | BSE CARBONEX | Nifty100 Enhanced ESG | Nifty100 ESG | Nifty India Consumption | Nifty Non-Cyclical Consumer

Intellectual Capital (IC)	14,653.17
Net Worth (NW)	1,734.68
Intrinsic Worth (IW)	16,387.85
Market Cap (MC)	41,946.98
Economic Value Added	273.01

Discount Rate	%
Liquidity Premium	%

Knowledge Basis (IC/IW)	89.41%
IC Gross Margin (EBITDA/IC)	11.77%
IC Net Margin (NPT/IC)	8.24%
Knowledge Turnover (Sales/IC)	0.36
Market to Intrinsic Value (MC/IW)	2.56

As Of	Intrinsic Value	Market Price
31 Mar 2022	Rs. 602.53	Rs. 1,542.25
26 May 2022	----	Rs. 1,609.05
26 May 2022	----	37.80 2.35%

Fundamental - medium term		Technical - near term		Combined outlook
EVA > 0 : Yes	Buy	10 DMA : Rs. 1,583.29	Buy	Strong Buy
KB > 50% : Yes		50 DMA : Rs. 1,566.73
0 < M2IV < 1 : No		Vol-Price trend : Rising

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-19
S
1084.86
1100.03
314.97
265.12
262.81
169.11
169.11

Sep-19
S
1213.21
1230.43
331.60
281.18
278.77
244.11
244.11

Dec-19
S
1136.02
1152.97
321.85
270.35
267.43
199.10
199.10

Mar-20
S
1071.26
1090.90
282.51
236.34
234.36
204.15
188.62

Jun-20
S
1040.62
1046.90
314.26
268.88
266.89
198.18
198.18

Sep-20
S
1285.48
1293.05
416.86
370.75
368.93
274.19
274.19

Dec-20
S
1231.93
1241.81
380.49
334.93
333.04
248.36
248.36

Mar-21
S
1283.19
1289.81
428.37
382.92
381.36
314.66
314.66

Jun-21
S
1165.97
1171.18
360.43
315.73
314.19
233.23
233.23

Sep-21
S
1352.42
1358.93
407.27
362.38
360.88
269.17
269.17

Dec-21
S
1280.12
1285.80
386.23
342.31
340.80
252.33
252.33

Mar-22
S
1301.27
1310.13
438.28
394.47
393.12
323.57
323.57

* C - Consolidated, S - Standalone