Projected Income Statement: Lupin Limited

Forecast Balance Sheet: Lupin Limited

Fiscal Period: March 2021 2022 2023 2024 2025 2026 2027 2028
Net Debt 1 13,231 27,460 29,509 14,674 19,343 -26,139 -42,535 -76,379
Change - 107.54% 7.46% -50.27% 31.82% -235.13% -221.65% -79.57%
Announcement Date 12/05/21 18/05/22 09/05/23 06/05/24 14/05/25 07/05/26 - -
1INR in Million
Estimates

Cash Flow Forecast: Lupin Limited

Fiscal Period: March 2021 2022 2023 2024 2025 2026 2027 2028
CAPEX 1 6,776 9,051 14,996 9,289 16,824 20,548 20,188 14,736
Change - 33.57% 65.69% -38.06% 81.12% 22.14% 31.09% -27.01%
Free Cash Flow (FCF) 1 11,441 -5,378 3,974 27,195 13,175 52,796 35,813 45,656
Change - -147% 173.89% 584.38% -51.55% 300.73% 2.07% 27.49%
Announcement Date 12/05/21 18/05/22 09/05/23 06/05/24 14/05/25 07/05/26 - -
1INR in Million
Estimates

Forecast Financial Ratios: Lupin Limited

Fiscal Period: March 2021 2022 2023 2024 2025 2026 2027 2028

Profitability

        
EBITDA Margin (%) 16.93% 13.2% 10.34% 18.99% 23.24% 29.18% 25.57% 24.48%
EBIT Margin (%) 11.08% 3.09% 5.05% 13.01% 18.09% 24.27% 20.41% 19.28%
EBT Margin (%) 11.06% -8.37% 4.31% 12.1% 17.68% 24.58% 20.67% 20.03%
Net margin (%) 8.02% -9.31% 2.58% 9.57% 14.45% 19.07% 15.51% 15.01%
FCF margin (%) 7.55% -3.28% 2.39% 13.59% 5.8% 18.88% 12.08% 14.62%
FCF / Net Income (%) 94.05% 35.19% 92.39% 142.05% 40.15% 99% 77.88% 97.42%

Profitability

        
ROA 5.01% -6.73% 1.92% 8.15% 12.34% 15.78% 11.21% 10.8%
ROE 9.24% -11.77% 3.49% 14.31% 20.96% 26.9% 18.62% 16.33%

Financial Health

        
Leverage (Debt/EBITDA) 0.52x 1.27x 1.72x 0.39x 0.37x - - -
Debt / Free cash flow 1.16x -5.11x 7.43x 0.54x 1.47x - - -

Capital Intensity

        
CAPEX / Current Assets (%) 4.47% 5.52% 9.01% 4.64% 7.41% 7.35% 6.81% 4.72%
CAPEX / EBITDA (%) 26.4% 41.79% 87.16% 24.44% 31.88% 25.18% 26.63% 19.28%
CAPEX / FCF (%) 59.23% -168.3% 377.4% 34.16% 127.7% 38.92% 56.37% 32.28%

Items per share

        
Cash flow per share 1 40.01 8.082 41.51 79.79 65.7 160.4 121.8 125.2
Change - -79.8% 413.58% 92.24% -17.66% 144.17% 8.03% 2.83%
Dividend per Share 1 6.5 4 4 8 12 18 13.06 12.51
Change - -38.46% 0% 100% 50% 50% -1.73% -4.2%
Book Value Per Share 1 304.2 267.4 274 313.6 374.8 491 573.9 660.6
Change - -12.11% 2.45% 14.47% 19.51% 31.01% 22.84% 15.12%
EPS 1 26.72 -33.65 9.41 41.87 71.69 116.4 100.7 102.6
Change - -225.94% 127.96% 344.95% 71.22% 62.42% -7.48% 1.94%
Nbr of stocks (in thousands) 453,680 454,475 454,981 455,679 456,565 457,216 457,216 457,216
Announcement Date 12/05/21 18/05/22 09/05/23 06/05/24 14/05/25 07/05/26 - -
1INR
Estimates
2026 2027 *
P/E ratio 19.9x 22.5x
PBR 4.71x 3.95x
EV / Sales 3.69x 3.35x
Yield 0.78% 0.58%

EPS & Dividend

Y-o-Y evolution of P/E

Year-on-year evolution of the Yield

Trader
Investor
Global
Quality
ESG MSCI
BBB
Sell
Consensus
Buy
Mean consensus
OUTPERFORM
Number of Analysts
37
Last Close Price
2,268.10INR
Average target price
2,468.53INR
Spread / Average Target
+8.84%

Quarterly revenue - Rate of surprise

  1. Stock Market
  2. Equities
  3. 500257 Stock
  4. Financials Lupin Limited