Projected Income Statement: Legrand

Forecast Balance Sheet: Legrand

Forecast Balance Sheet - Legrand
Fiscal Period: December 2021 2022 2023 2024 2025 2026 2027 2028
Net Debt 1 2,524 2,319 2,006 3,006 4,223 4,987 4,634 4,243
Change - -8.12% -13.5% 49.85% 40.49% 18.1% -7.08% -8.44%
Announcement Date 2/10/22 2/9/23 2/15/24 2/13/25 2/12/26 - - -
1EUR in Million
Estimates

Cash Flow Forecast: Legrand

Fiscal Period: December 2021 2022 2023 2024 2025 2026 2027 2028
CAPEX 1 170.5 177.6 253.3 239.6 248.7 279.8 297.1 315.4
Change - 4.16% 42.62% -5.41% 3.8% 12.51% 6.18% 6.17%
Free Cash Flow (FCF) 1 952.4 1,036 1,585 1,290 1,331 1,559 1,772 1,948
Change - 8.73% 53.05% -18.57% 3.12% 17.13% 13.68% 9.92%
Announcement Date 2/10/22 2/9/23 2/15/24 2/13/25 2/12/26 - - -
1EUR in Million
Estimates

Forecast Financial Ratios: Legrand

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

Profitability

        
EBITDA Margin (%) 23.6% 22.29% 23.31% 23.67% 23.78% 23.67% 24.05% 24.15%
EBIT Margin (%) 20.5% 20.4% 21.03% 20.53% 20.7% 20.41% 20.94% 21.35%
EBT Margin (%) 17.97% 16.59% 18.41% 18.24% 17.84% 18.03% 19% 19.63%
Net margin (%) 12.93% 11.99% 13.65% 13.49% 13.13% 13.18% 13.74% 14.05%
FCF margin (%) 13.62% 12.42% 18.83% 14.92% 14.04% 14.09% 14.35% 14.47%
FCF / Net Income (%) 105.3% 103.6% 137.99% 110.64% 106.93% 106.94% 104.48% 102.95%

Profitability

        
ROA 6.72% 7.03% 8.76% 7.56% 7.39% 8.23% 8.99% 9.61%
ROE 17.05% 16.18% 19.17% 16.37% 16.79% 20.34% 20.65% 20.68%

Financial Health

        
Leverage (Debt/EBITDA) 1.53x 1.25x 1.02x 1.47x 1.87x 1.9x 1.56x 1.3x
Debt / Free cash flow 2.65x 2.24x 1.27x 2.33x 3.17x 3.2x 2.62x 2.18x

Capital Intensity

        
CAPEX / Current Assets (%) 2.44% 2.13% 3.01% 2.77% 2.62% 2.53% 2.41% 2.34%
CAPEX / EBITDA (%) 10.33% 9.55% 12.91% 11.7% 11.03% 10.68% 10% 9.7%
CAPEX / FCF (%) 17.9% 17.15% 15.98% 18.57% 18.69% 17.95% 16.77% 16.19%

Items per share

        
Cash flow per share 1 4.141 4.608 6.882 5.776 5.961 6.643 7.712 8.705
Change - 11.27% 49.35% -16.06% 3.19% 11.45% 16.08% 12.88%
Dividend per Share 1 1.42 1.65 1.9 2.09 2.2 2.696 3.099 3.511
Change - 16.2% 15.15% 10% 5.26% 22.55% 14.95% 13.28%
Book Value Per Share 1 21.37 24.88 25.19 28.56 27.38 31.28 34.93 39
Change - 16.38% 1.28% 13.35% -4.13% 14.24% 11.68% 11.66%
EPS 1 3.366 3.726 4.304 4.423 4.705 5.524 6.406 7.204
Change - 10.7% 15.51% 2.76% 6.38% 17.42% 15.96% 12.46%
Nbr of stocks (in thousands) 266,749 266,669 262,133 262,145 261,662 262,136 262,136 262,136
Announcement Date 2/10/22 2/9/23 2/15/24 2/13/25 2/12/26 - - -
1EUR
Estimates
2026 *2027 *
P/E 25.3x 21.8x
PBR 4.46x 4x
EV / Sales 3.76x 3.34x
Yield 1.93% 2.22%

EPS & Dividend

EPS & Dividend - Legrand


Y-o-Y evolution of P/E

Valuation ratios - P/E - Legrand
 

Year-on-year evolution of the Yield

Valuation ratios - Yield - Legrand
Trader
Investor
Global
Quality
ESG MSCI
AA
Ratings Surperformance© - Legrand
Sell
Consensus
Buy
Mean consensus
OUTPERFORM
Number of Analysts
18
Last Close Price
139.60EUR
Average target price
169.22EUR
Spread / Average Target
+21.22%

Quarterly revenue - Rate of surprise

Rate of surprise - Net sales - Quarterly - Legrand