Lupin Limited's intrinsic value using Intellectual Capital analysis

Lupin Limited

BSE : 500257

|

NSE : LUPIN

Industry : Pharma Drugs

|

ISIN : INE326A01037

|

FreeFloat : 55.00%

|

FnO : Yes

|

LotSize : 850

BSE 100 | BSE 100 Largecap TMC | BSE 200 | BSE 250 LargeMidcap | BSE Largecap | BSE LargeMidcap | BSE SENSEX Next 50 | Nifty 100 | Nifty 200 | Nifty LargeMidcap 250 | Nifty Next 50 | Nifty100 Equal Weight | Nifty Alpha Low Volatility 30 | Nifty Pharma | BSE Dividend Stability | BSE Low Volatility | Nifty Low Volatility 50 | Nifty100 Alpha 30 | Nifty200 Momentum 30 | BSE 100 ESG | BSE CARBONEX | BSE GREENEX | Nifty100 ESG | BSE India Manufacturing

Intellectual Capital (IC)	-3,763.10
Net Worth (NW)	12,764.69
Intrinsic Worth (IW)	9,001.59
Market Cap (MC)	45,659.43
Economic Value Added	-167.04

Discount Rate	%
Liquidity Premium	%

Knowledge Basis (IC/IW)	-41.80%
IC Gross Margin (EBITDA/IC)	-62.05%
IC Net Margin (NPT/IC)	3.82%
Knowledge Turnover (Sales/IC)	-4.23
Market to Intrinsic Value (MC/IW)	5.07

As Of	Intrinsic Value	Market Price
30 Sep 2020	Rs. 198.61	Rs. 1,007.40
22 Jan 2021	-	Rs. 1,079.25

Fundamental - medium term		Technical - near term		Combined outlook
EVA > 0 : No	Sell	10 DMA : Rs. 1,079.03	Buy	Hold
KB > 50% : No		50 DMA : Rs. 971.50
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

Dec-17
C
3975.62
4004.04
717.35
437.00
383.00
222.23
195.89

Mar-18
C
4033.83
4178.75
-662.10
-934.93
-940.78
-777.60
-783.54

Jun-18
C
3855.93
4040.13
711.86
452.88
384.16
203.02
-67.47

Sep-18
C
3951.06
4181.74
780.67
515.18
441.36
268.45
242.73

Dec-18
C
4504.85
4548.29
454.97
175.21
95.44
-152.36
-130.06

Mar-19
C
4406.32
4492.82
962.51
681.73
596.21
296.37
336.59

Jun-19
C
4418.38
4490.59
933.42
616.33
530.71
303.05
377.60

Sep-19
C
4359.55
4492.92
318.79
-2.68
-89.14
-127.07
-214.23

Dec-19
C
3716.09
3769.27
235.01
-18.22
-106.82
-835.00
-891.98

Mar-20
C
3845.74
4054.34
818.00
603.74
496.36
391.29
-148.95

Jun-20
C
3527.86
3571.14
531.92
317.28
273.02
106.90
183.54

Sep-20
C
3835.00
3859.96
606.56
393.83
360.21
211.02
239.61

* C - Consolidated, S - Standalone