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

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 Momentum 30 | Nifty200 Quality 30 | BSE 100 ESG | BSE CARBONEX | Nifty100 Enhanced ESG | Nifty100 ESG | Nifty India Consumption

Intellectual Capital (IC)	9,729.29
Net Worth (NW)	1,632.95
Intrinsic Worth (IW)	11,362.24
Market Cap (MC)	38,989.14
Economic Value Added	229.15

Discount Rate	%
Liquidity Premium	%

Knowledge Basis (IC/IW)	85.63%
IC Gross Margin (EBITDA/IC)	14.26%
IC Net Margin (NPT/IC)	9.41%
Knowledge Turnover (Sales/IC)	0.48
Market to Intrinsic Value (MC/IW)	3.43

As Of	Intrinsic Value	Market Price
30 Sep 2020	Rs. 417.75	Rs. 1,433.50
15 Jan 2021	-	Rs. 1,562.20

Fundamental - medium term		Technical - near term		Combined outlook
EVA > 0 : Yes	Buy	10 DMA : Rs. 1,599.24	Sell	Avoid
KB > 50% : Yes		50 DMA : Rs. 1,557.09
0 < M2IV < 1 : No		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
1033.32
1042.36
291.46
251.89
251.89
170.65
169.87

Mar-18
S
1091.66
1100.14
304.35
263.87
263.87
188.77
192.20

Jun-18
S
1041.30
1050.46
324.87
285.48
285.48
189.51
189.51

Sep-18
S
1168.03
1176.67
338.21
298.38
298.38
196.37
196.37

Dec-18
S
1091.63
1107.26
322.37
281.77
281.77
192.10
192.10

Mar-19
S
1153.75
1165.70
318.78
279.43
276.93
197.59
197.69

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

* C - Consolidated, S - Standalone