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 -29,016 -36,348 -47,027
Change - 186.99% -245.67% -11.86% 31.25% -39.11% -25.27% -29.38%
Announcement Date 5/4/22 5/3/23 4/30/24 4/22/25 4/22/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,207
Change - 127.57% 33.73% -4.26% 97.25% -36.88% -5.69% -7.13%
Free Cash Flow (FCF) 1 14,861 -230.3 11,731 8,081 1,022 11,081 15,268 19,510
Change - -101.55% 5,193.79% -31.12% -87.35% 984.39% 37.78% 27.78%
Announcement Date 5/4/22 5/3/23 4/30/24 4/22/25 4/22/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.17% 10.6% 10.68%
EBIT Margin (%) 10.78% 7.75% 8.12% 8.05% 7.94% 8.33% 8.86% 8.9%
EBT Margin (%) 11.55% 8.6% 9.22% 9.24% 9.91% 9.19% 9.65% 9.64%
Net margin (%) 8.6% 6.37% 6.86% 6.85% 7.59% 6.83% 7.21% 7.17%
FCF margin (%) 10.7% -0.14% 6.32% 3.72% 0.45% 4.26% 5.16% 5.9%
FCF / Net Income (%) 124.39% -2.14% 92.14% 54.27% 5.99% 62.31% 71.54% 82.28%

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.77% 18.89% 18.95%

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.6% 2.98% 2.48%
CAPEX / EBITDA (%) 14.69% 36.67% 42.6% 35.03% 67.07% 35.37% 28.15% 23.24%
CAPEX / FCF (%) 17.38% -2,552.19% 67.01% 93.13% 1,452.63% 84.55% 57.88% 42.07%

Items per share

        
Cash flow per share 1 27.85 9.015 31.26 24.88 25.29 35.5 41.54 47.66
Change - -67.63% 246.75% -20.4% 1.61% 40.4% 17% 14.75%
Dividend per Share 1 7.5 7.5 9 10 10 11.49 13.44 14.34
Change - 0% 20% 11.11% 0% 14.87% 17.03% 6.65%
Book Value Per Share 1 95.62 105.6 118.7 132.9 151.1 168.1 189 211
Change - 10.42% 12.42% 11.96% 13.67% 11.26% 12.45% 11.63%
EPS 1 19.08 17.16 20.32 23.74 27.18 28.41 34.05 38.02
Change - -10.06% 18.41% 16.83% 14.49% 4.54% 19.85% 11.64%
Nbr of stocks (in thousands) 626,303 626,510 626,776 626,942 627,257 627,562 627,562 627,562
Announcement Date 5/4/22 5/3/23 4/30/24 4/22/25 4/22/26 - - -
1INR
Estimates
2027 *2028 *
P/E 41.5x 34.6x
PBR 7.01x 6.23x
EV / Sales 2.73x 2.37x
Yield 0.97% 1.14%

EPS & Dividend

Y-o-Y evolution of P/E

Year-on-year evolution of the Yield

Trader
Investor
Global
-
Quality
ESG MSCI
BBB

Quarterly revenue - Rate of surprise

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