InCred Equities - Lupin Ltd

	Mar-24A	Mar-25A	Mar-26F	Mar-27F
Revenue (Rsm)	196,825	227,079	253,213	264,493
Operating EBITDA (Rsm)	34,965	53,967	63,123	63,780
Net Profit (Rsm)	16,302	32,816	40,299	40,114
Core EPS (Rs)	35.8	75.3	88.6	88.2
Core EPS Growth	279.1%	110.1%	17.6%	(0.5%)
FD Core P/E (x)	57.01	27.13	23.06	23.17
DPS (Rs)	7.5	8.5	8.5	8.5
Dividend Yield	0.37%	0.42%	0.42%	0.42%
EV/EBITDA (x)	26.76	17.38	14.47	13.68
P/FCFE (x)	28.41	13.35	12.84	8.01
Net Gearing	5.4%	5.1%	(7.9%)	(23.3%)
P/BV (x)	6.50	5.40	4.46	3.80
ROE	12.2%	21.8%	21.2%	17.7%
% Change In Core EPS Estimates
InCred Research/Consensus EPS (x)

(Rs mn)	Mar-24A	Mar-25A	Mar-26F	Mar-27F
Total Net Revenues	196,825	227,079	253,213	264,493
Gross Profit	130,390	158,657	177,502	183,822
Operating EBITDA	34,965	53,967	63,123	63,780
Depreciation And Amortisation	(11,968)	(11,693)	(12,000)	(12,500)
Operating EBIT	22,996	42,275	51,123	51,280
Financial Income/(Expense)	(3,116)	(2,949)	(3,500)	(3,300)
Pretax Income/(Loss) from Assoc.
Non-Operating Income/(Expense)	1,500	2,265	3,000	2,400
Profit Before Tax (pre-EI)	21,380	41,591	50,623	50,380
Exceptional Items
Pre-tax Profit	21,380	41,591	50,623	50,380
Taxation	(4,867)	(7,087)	(10,125)	(10,076)
Exceptional Income - post-tax		(1,441)
Profit After Tax	16,513	33,063	40,499	40,304
Minority Interests	(211)	(246)	(200)	(190)
Preferred Dividends
FX Gain/(Loss) - post tax
Other Adjustments - post-tax
Net Profit	16,302	32,816	40,299	40,114
Recurring Net Profit	16,302	34,257	40,299	40,114
Fully Diluted Recurring Net Profit	16,302	34,257	40,299	40,114

(Rs mn)	Mar-24A	Mar-25A	Mar-26F	Mar-27F
EBITDA	34,965	53,967	63,123	63,780
Cash Flow from Invt. & Assoc.
Change In Working Capital	855	(14,105)	(11,209)	4,417
(Incr)/Decr in Total Provisions
Other Non-Cash (Income)/Expense
Other Operating Cashflow	(4,372)	661	1,711	1,711
Net Interest (Paid)/Received	(1,125)	(1,611)	(1,611)	(1,611)
Tax Paid	(562)	(7,738)	(9,825)	(9,366)
Cashflow From Operations	29,760	31,174	42,190	58,931
Capex	(9,166)	(16,531)	(12,000)	(12,500)
Disposals Of FAs/subsidiaries
Acq. Of Subsidiaries/investments	(1,465)	(463)
Other Investing Cashflow
Cash Flow From Investing	19,129	14,181	30,190	46,431
Debt Raised/(repaid)	(16,171)	24,277		10,633
Proceeds From Issue Of Shares	146	399
Shares Repurchased
Dividends Paid	(1,828)	(3,653)	(3,879)	(3,879)
Preferred Dividends
Other Financing Cashflow	(4,828)	(12,535)	(500)	(900)
Cash Flow From Financing	(22,682)	8,488	(4,379)	5,854
Total Cash Generated	(3,553)	22,669	25,811	52,285
Free Cashflow To Equity	32,717	69,633	72,380	115,995
Free Cashflow To Firm	52,005	48,304	75,880	108,662

(Rs mn)	Mar-24A	Mar-25A	Mar-26F	Mar-27F
Total Cash And Equivalents	20,521	42,014	67,225	118,509
Total Debtors	46,921	54,971	63,303	60,833
Inventories	49,539	54,764	58,239	58,188
Total Other Current Assets	17,497	16,237	20,257	19,837
Total Current Assets	134,477	167,986	209,024	257,368
Fixed Assets	54,942	55,036	55,036	55,036
Total Investments	2,277	873	873	873
Intangible Assets	41,566	47,324	47,324	47,324
Total Other Non-Current Assets	6,710	20,830	20,830	20,830
Total Non-current Assets	105,495	124,063	124,063	124,063
Short-term Debt	26,699	33,104	33,104	33,104
Current Portion of Long-Term Debt
Total Creditors	29,581	29,582	31,838	32,312
Other Current Liabilities	28,735	26,928	29,291	30,293
Total Current Liabilities	85,015	89,614	94,233	95,709
Total Long-term Debt	1,553	17,662	17,662	28,295
Hybrid Debt - Debt Component
Total Other Non-Current Liabilities	9,670	11,829	11,829	11,829
Total Non-current Liabilities	11,222	29,491	29,491	40,124
Total Provisions
Total Liabilities	96,237	119,105	123,724	135,833
Shareholders Equity	142,903	172,035	208,254	244,299
Minority Interests	832	909	1,109	1,299
Total Equity	143,735	172,944	209,363	245,597

	Mar-24A	Mar-25A	Mar-26F	Mar-27F
Revenue Growth	18.3%	15.4%	11.5%	4.5%
Operating EBITDA Growth	103.2%	54.3%	17.0%	1.0%
Operating EBITDA Margin	17.8%	23.8%	24.9%	24.1%
Net Cash Per Share (Rs)	(17.00)	(19.24)	36.19	125.57
BVPS (Rs)	314.21	378.27	457.90	537.16
Gross Interest Cover	7.38	14.34	14.61	15.54
Effective Tax Rate	22.8%	17.0%	20.0%	20.0%
Net Dividend Payout Ratio
Accounts Receivables Days	85.05	81.89	85.24	85.65
Inventory Days	259.48	278.20	272.39	263.39
Accounts Payables Days	150.80	157.80	148.05	145.13
ROIC (%)	10.8%	16.4%	18.8%	19.2%
ROCE (%)	13.5%	21.4%	21.1%	18.1%
Return On Average Assets	8.0%	13.8%	13.8%	12.0%

(91) 22 4161 1566 yogesh.soni@incredresearch.com

More Reports

Market Data

Source: Bloomberg