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 -25,208 -30,634 -44,192
Change - 186.99% -245.67% -11.86% 31.25% -20.86% -21.52% -44.26%
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 11,840 9,408 9,863
Change - 127.57% 33.73% -4.26% 97.25% -20.24% -20.54% 4.83%
Free Cash Flow (FCF) 1 14,861 -230.3 11,731 8,081 1,022 9,436 14,473 17,695
Change - -101.55% 5,193.79% -31.12% -87.35% 823.33% 53.39% 22.26%
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% 9.75% 10.33% 10.44%
EBIT Margin (%) 10.78% 7.75% 8.12% 8.05% 7.94% 7.83% 8.45% 8.67%
EBT Margin (%) 11.55% 8.6% 9.22% 9.24% 9.91% 8.71% 9.31% 9.46%
Net margin (%) 8.6% 6.37% 6.86% 6.85% 7.59% 6.46% 6.92% 7.11%
FCF margin (%) 10.7% -0.14% 6.32% 3.72% 0.45% 3.62% 4.87% 5.27%
FCF / Net Income (%) 124.39% -2.14% 92.14% 54.27% 5.99% 56.02% 70.39% 74.13%

Profitability

        
ROA 12.36% 9.93% 10.81% 11.37% 11.97% 10.39% 10.94% 11.22%
ROE 21.42% 17.06% 18.12% 18.88% 19.15% 16.89% 18.41% 18.96%

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% 4.54% 3.17% 2.94%
CAPEX / EBITDA (%) 14.69% 36.67% 42.6% 35.03% 67.07% 46.54% 30.67% 28.14%
CAPEX / FCF (%) 17.38% -2,552.19% 67.01% 93.13% 1,452.63% 125.49% 65% 55.74%

Items per share

        
Cash flow per share 1 27.85 9.015 31.26 24.88 25.29 33.67 40.62 46.7
Change - -67.63% 246.75% -20.4% 1.61% 33.17% 20.63% 14.98%
Dividend per Share 1 7.5 7.5 9 10 10 11 12.53 14.71
Change - 0% 20% 11.11% 0% 10.01% 13.93% 17.33%
Book Value Per Share 1 95.62 105.6 118.7 132.9 151.1 167.4 187.7 210.6
Change - 10.42% 12.42% 11.96% 13.67% 10.79% 12.17% 12.18%
EPS 1 19.08 17.16 20.32 23.74 27.18 26.99 32.87 37.94
Change - -10.06% 18.41% 16.83% 14.49% -0.71% 21.82% 15.41%
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 44.5x 36.5x
PBR 7.17x 6.39x
EV / Sales 2.79x 2.43x
Yield 0.92% 1.04%

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. 517354 Stock
  5. Financials Havells India Limited