Cipla Limited's intrinsic value using Intellectual Capital analysis

Cipla Limited

BSE : 500087

|

NSE : CIPLA

Industry : Pharmaceuticals

|

ISIN : INE059A01026

|

FreeFloat : 65.00%

|

FnO : Yes

|

LotSize : 1150

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 | Nifty Pharma | BSE Dividend Stability | BSE Low Volatility | Nifty Growth Sectors 15 | Nifty Low Volatility 50 | Nifty100 Low Volatility 30 | BSE 100 ESG | BSE CARBONEX | BSE GREENEX | Nifty100 Enhanced ESG | Nifty100 ESG | BSE India Manufacturing

Intellectual Capital (IC)	8,088.01
Net Worth (NW)	16,057.28
Intrinsic Worth (IW)	24,145.29
Market Cap (MC)	34,091.66
Economic Value Added	-322.52

Discount Rate	%
Liquidity Premium	%

Knowledge Basis (IC/IW)	33.50%
IC Gross Margin (EBITDA/IC)	44.39%
IC Net Margin (NPT/IC)	13.17%
Knowledge Turnover (Sales/IC)	2.20
Market to Intrinsic Value (MC/IW)	1.41

As Of	Intrinsic Value	Market Price
31 Mar 2020	Rs. 299.48	Rs. 422.85
29 May 2020	-	Rs. 648.15

Fundamental - medium term		Technical - near term		Combined outlook
EVA > 0 : No	Sell	10 DMA : Rs. 617.96	Buy	Hold
KB > 50% : No		50 DMA : Rs. 535.75
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
C
3525.05
3676.43
797.84
584.41
556.55
424.92
478.06

Sep-17
C
4082.41
4195.74
917.72
615.50
573.48
434.95
400.62

Dec-17
C
3913.82
3966.75
871.59
349.24
340.09
403.45
516.01

Mar-18
C
3697.97
3737.98
519.36
234.54
199.34
153.25
415.41

Jun-18
C
3938.99
4109.10
896.48
655.48
620.39
445.61
183.87

Sep-18
C
4011.90
4144.47
834.79
552.89
508.52
366.13
366.91

Dec-18
C
4007.54
4086.07
786.20
493.07
448.88
322.24
222.09

Mar-19
C
4403.98
4499.34
1056.41
546.13
501.35
357.68
354.23

Jun-19
C
3989.02
4067.39
983.01
715.01
662.89
478.19
446.87

Sep-19
C
4395.78
4496.30
1010.02
727.06
680.99
474.50
382.48

Dec-19
C
4371.00
4443.13
830.46
552.57
506.40
339.38
544.23

Mar-20
C
4376.19
4469.37
726.70
380.90
327.90
238.49
-3.46

* C - Consolidated, S - Standalone