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

Intellectual Capital (IC)	7,618.27
Net Worth (NW)	1,594.16
Intrinsic Worth (IW)	9,212.43
Market Cap (MC)	34,071.64
Economic Value Added	156.80

Discount Rate	%
Liquidity Premium	%

Knowledge Basis (IC/IW)	82.70%
IC Gross Margin (EBITDA/IC)	17.20%
IC Net Margin (NPT/IC)	11.18%
Knowledge Turnover (Sales/IC)	0.60
Market to Intrinsic Value (MC/IW)	3.70

As Of	Intrinsic Value	Market Price
31 Mar 2020	Rs. 338.71	Rs. 1,252.70
29 May 2020	-	Rs. 1,391.50

Fundamental - medium term		Technical - near term		Combined outlook
EVA > 0 : Yes	Buy	10 DMA : Rs. 1,332.76	Buy	Strong Buy
KB > 50% : Yes		50 DMA : Rs. 1,315.43
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-17
S
1118.56
1131.01
234.27
196.98
196.98
136.38
135.60

Sep-17
S
1084.88
1093.73
309.46
270.29
270.29
177.57
176.78

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

* C - Consolidated, S - Standalone