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,181 -30,533 -39,110
Change - 186.99% -245.67% -11.86% 31.25% -20.73% -21.25% -28.09%
Announcement Date 5/4/22 A 5/3/23 A 4/30/24 A 4/22/25 A 4/22/26 A - - -
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 13,046 9,936 10,349
Change - 127.57% 33.73% -4.26% 97.25% -12.12% -23.84% 4.16%
Free Cash Flow (FCF) 1 14,861 -230.3 11,731 8,081 1,022 8,627 15,194 18,676
Change - -101.55% 5,193.79% -31.12% -87.35% 744.25% 76.11% 22.92%
Announcement Date 5/4/22 A 5/3/23 A 4/30/24 A 4/22/25 A 4/22/26 A - - -
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.74% 10.29% 10.4%
EBIT Margin (%) 10.78% 7.75% 8.12% 8.05% 7.94% 7.82% 8.43% 8.65%
EBT Margin (%) 11.55% 8.6% 9.22% 9.24% 9.91% 8.7% 9.29% 9.44%
Net margin (%) 8.6% 6.37% 6.86% 6.85% 7.59% 6.45% 6.91% 7.1%
FCF margin (%) 10.7% -0.14% 6.32% 3.72% 0.45% 3.31% 5.12% 5.58%
FCF / Net Income (%) 124.39% -2.14% 92.14% 54.27% 5.99% 51.28% 74.12% 78.58%

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.9% 18.43% 18.98%

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% 5.01% 3.35% 3.09%
CAPEX / EBITDA (%) 14.69% 36.67% 42.6% 35.03% 67.07% 51.38% 32.58% 29.72%
CAPEX / FCF (%) 17.38% -2,552.19% 67.01% 93.13% 1,452.63% 151.21% 65.39% 55.41%

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 10.99 12.49 14.63
Change - 0% 20% 11.11% 0% 9.89% 13.64% 17.18%
Book Value Per Share 1 95.62 105.6 118.7 132.9 151.1 167.3 187.5 210.1
Change - 10.42% 12.42% 11.96% 13.67% 10.76% 12.09% 12.05%
EPS 1 19.08 17.16 20.32 23.74 27.18 26.95 32.78 37.78
Change - -10.06% 18.41% 16.83% 14.49% -0.84% 21.64% 15.25%
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 A 5/3/23 A 4/30/24 A 4/22/25 A 4/22/26 A - - -
1INR
Estimates
2027 *2028 *
P/E 38.7x 31.8x
PBR 6.24x 5.56x
EV / Sales 2.42x 2.11x
Yield 1.05% 1.2%

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