Projected Income Statement: Henkel AG & Co. KGaA

Forecast Balance Sheet: Henkel AG & Co. KGaA

Fiscal Period: December 2021 2022 2023 2024 2025 2026 2027 2028
Net Debt 1 1,036 1,819 318 -688 334 -680 -1,871 -3,017
Change - 75.58% -82.52% -316.35% 148.55% -303.59% -175.15% -61.25%
Announcement Date 2/23/22 3/7/23 3/4/24 3/11/25 3/11/26 - - -
1EUR in Million
Estimates

Cash Flow Forecast: Henkel AG & Co. KGaA

Fiscal Period: December 2021 2022 2023 2024 2025 2026 2027 2028
CAPEX 1 624 593 608 626 693 701.7 732.6 748.2
Change - -4.97% 2.53% 2.96% 10.7% 1.26% 4.39% 2.14%
Free Cash Flow (FCF) 1 1,478 654 2,647 2,494 1,842 1,939 2,044 2,151
Change - -55.75% 304.74% -5.78% -26.14% 5.26% 5.45% 5.21%
Announcement Date 2/23/22 3/7/23 3/4/24 3/11/25 3/11/26 - - -
1EUR in Million
Estimates

Forecast Financial Ratios: Henkel AG & Co. KGaA

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

Profitability

        
EBITDA Margin (%) 16.92% 12.3% 16.15% 17.6% 18.16% 18.02% 18.21% 18.2%
EBIT Margin (%) 13.39% 9.91% 11.88% 14.31% 14.76% 14.84% 15.05% 15.07%
EBT Margin (%) 10.71% 7.22% 8.78% 12.61% 13.32% 13.77% 14.08% 13.92%
Net margin (%) 8.14% 5.38% 6.13% 9.3% 9.93% 10.07% 10.23% 10.26%
FCF margin (%) 7.37% 2.8% 12.3% 11.55% 8.99% 9.39% 9.52% 9.79%
FCF / Net Income (%) 90.45% 51.95% 200.83% 124.27% 90.52% 93.22% 93.02% 95.43%

Profitability

        
ROA 5.2% 5.05% 4.06% 6.7% 6.51% 6.39% 6.55% 6.75%
ROE 9.1% 6.3% 6.6% 10.2% 9.4% 10.46% 10.56% 10.49%

Financial Health

        
Leverage (Debt/EBITDA) 0.31x 0.63x 0.09x - 0.09x - - -
Debt / Free cash flow 0.7x 2.78x 0.12x - 0.18x - - -

Capital Intensity

        
CAPEX / Current Assets (%) 3.11% 2.53% 2.83% 2.9% 3.38% 3.4% 3.41% 3.41%
CAPEX / EBITDA (%) 18.38% 20.6% 17.5% 16.48% 18.62% 18.85% 18.72% 18.7%
CAPEX / FCF (%) 42.22% 90.67% 22.97% 25.1% 37.62% 36.19% 35.83% 34.79%

Items per share

        
Cash flow per share 1 4.93 2.911 - 7.44 6.117 6.481 6.776 7.275
Change - -40.96% - - -17.78% 5.95% 4.55% 7.36%
Dividend per Share 1 1.83 1.85 1.85 2.04 2.072 2.114 2.224 2.293
Change - 1.09% 0% 10.27% 1.57% 2% 5.22% 3.11%
Book Value Per Share 1 45.4 47.58 - 51.82 49.45 52.04 56 58.26
Change - 4.81% - - -4.57% 5.23% 7.61% 4.04%
EPS 1 3.78 2.95 3.15 4.8 4.92 5.128 5.457 5.525
Change - -21.96% 6.78% 52.38% 2.5% 4.22% 6.43% 1.23%
Nbr of stocks (in thousands) 434,032 426,105 422,091 419,327 406,993 404,993 404,993 404,993
Announcement Date 2/23/22 3/7/23 3/4/24 3/11/25 3/11/26 - - -
1EUR
Estimates
2026 *2027 *
P/E ratio 12.8x 12x
PBR 1.26x 1.17x
EV / Sales 1.2x 1.1x
Yield 3.22% 3.39%

EPS & Dividend

Y-o-Y evolution of P/E

Year-on-year evolution of the Yield

Trader
Investor
Global
Quality
ESG MSCI
-
Sell
Consensus
Buy
Mean consensus
HOLD
Number of Analysts
18
Last Close Price
65.56EUR
Average target price
75.61EUR
Spread / Average Target
+15.34%

Quarterly revenue - Rate of surprise

  1. Stock Market
  2. Equities
  3. HEN3 Stock
  4. Financials Henkel AG & Co. KGaA