Projected Income Statement: Havells India Limited

Forecast Balance Sheet: Havells India Limited

Fiscal Period: March 2022 2023 2024 2025 2026 2027 2028 2029
Net Debt 1 -21,403 18,619 -27,123 -30,340 -20,858 -28,239 -35,486 -45,864
Change - 186.99% -245.67% -11.86% 31.25% -35.39% -25.66% -29.25%
Announcement Date 04/05/22 03/05/23 30/04/24 22/04/25 22/04/26 - - -
1INR in Million
Estimates

Cash Flow Forecast: Havells India Limited

Fiscal Period: March 2022 2023 2024 2025 2026 2027 2028 2029
CAPEX 1 2,583 5,878 7,860 7,526 14,844 9,370 8,837 8,851
Change - 127.57% 33.73% -4.26% 97.25% -36.88% -5.69% 0.16%
Free Cash Flow (FCF) 1 14,861 -230.3 11,731 8,081 1,022 11,020 15,355 19,194
Change - -101.55% 5,193.79% -31.12% -87.35% 978.4% 39.34% 25%
Announcement Date 04/05/22 03/05/23 30/04/24 22/04/25 22/04/26 - - -
1INR in Million
Estimates

Forecast Financial Ratios: Havells India Limited

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

Profitability

        
EBITDA Margin (%) 12.66% 9.5% 9.95% 9.88% 9.85% 10.14% 10.58% 10.75%
EBIT Margin (%) 10.78% 7.75% 8.12% 8.05% 7.94% 8.27% 8.78% 9.02%
EBT Margin (%) 11.55% 8.6% 9.22% 9.24% 9.91% 9.13% 9.62% 9.69%
Net margin (%) 8.6% 6.37% 6.86% 6.85% 7.59% 6.78% 7.17% 7.23%
FCF margin (%) 10.7% -0.14% 6.32% 3.72% 0.45% 4.24% 5.23% 5.82%
FCF / Net Income (%) 124.39% -2.14% 92.14% 54.27% 5.99% 62.59% 72.87% 80.55%

Profitability

        
ROA 12.36% 9.93% 10.81% 11.37% 11.97% 11.02% 11.36% 11.51%
ROE 21.42% 17.06% 18.12% 18.88% 19.15% 17.53% 18.69% 18.97%

Financial Health

        
Leverage (Debt/EBITDA) - 1.16x - - - - - -
Debt / Free cash flow - -80.85x - - - - - -

Capital Intensity

        
CAPEX / Current Assets (%) 1.86% 3.48% 4.24% 3.46% 6.61% 3.61% 3.01% 2.68%
CAPEX / EBITDA (%) 14.69% 36.67% 42.6% 35.03% 67.07% 35.59% 28.43% 24.97%
CAPEX / FCF (%) 17.38% -2,552.19% 67.01% 93.13% 1,452.63% 85.02% 57.55% 46.11%

Items per share

        
Cash flow per share 1 27.85 9.015 31.26 24.88 25.29 34.86 40.74 46.93
Change - -67.63% 246.75% -20.4% 1.61% 37.88% 16.85% 15.19%
Dividend per Share 1 7.5 7.5 9 10 10 11.37 13.29 14.32
Change - 0% 20% 11.11% 0% 13.72% 16.84% 7.76%
Book Value Per Share 1 95.62 105.6 118.7 132.9 151.1 168.3 189.1 210.6
Change - 10.42% 12.42% 11.96% 13.67% 11.42% 12.35% 11.35%
EPS 1 19.08 17.16 20.32 23.74 27.18 28.16 33.67 38.21
Change - -10.06% 18.41% 16.83% 14.49% 3.62% 19.56% 13.46%
Nbr of stocks (in thousands) 6,26,303 6,26,510 6,26,776 6,26,942 6,27,257 6,27,562 6,27,562 6,27,562
Announcement Date 04/05/22 03/05/23 30/04/24 22/04/25 22/04/26 - - -
1INR
Estimates
2027 *2028 *
P/E 42.2x 35.3x
PBR 7.05x 6.28x
EV / Sales 2.76x 2.41x
Yield 0.96% 1.12%

EPS & Dividend

Y-o-Y evolution of P/E

Year-on-year evolution of the Yield

Trader
Investor
Global
-
Quality
ESG MSCI
A

Quarterly revenue - Rate of surprise

  1. Stock Market
  2. Stocks
  3. HAVELLS Stock
  4. Financials Havells India Limited