Projected Income Statement: Estee Lauder

Forecast Balance Sheet: Estee Lauder

Fiscal Period: June 2021 2022 2023 2024 2025 2026 2027 2028
Net Debt 1 611 1,455 4,085 4,376 4,396 4,183 3,659 3,702
Change - 138.13% 180.76% 7.12% 0.46% -4.85% -12.53% 1.18%
Announcement Date 19/08/21 18/08/22 18/08/23 19/08/24 20/08/25 - - -
1USD in Million
Estimates

Cash Flow Forecast: Estee Lauder

Fiscal Period: June 2021 2022 2023 2024 2025 2026 2027 2028
CAPEX 1 637 1,040 1,003 919 602 571.5 660.7 667.6
Change - 63.27% -3.56% -8.37% -34.49% -5.07% 15.61% 1.04%
Free Cash Flow (FCF) 1 2,994 2,000 728 1,441 670 573.3 1,337 1,656
Change - -33.2% -63.6% 97.94% -53.5% -14.44% 133.15% 23.86%
Announcement Date 19/08/21 18/08/22 18/08/23 19/08/24 20/08/25 - - -
1USD in Million
Estimates

Forecast Financial Ratios: Estee Lauder

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

Profitability

        
EBITDA Margin (%) 22.94% 23.83% 16.11% 15.46% 13.79% 15.41% 17.11% 18.08%
EBIT Margin (%) 18.93% 19.73% 11.44% 10.17% 8% 9.81% 11.81% 13.15%
EBT Margin (%) 20.52% 17.11% 8.77% 4.95% -7.26% 7% 10.24% 12.73%
Net margin (%) 17.68% 13.47% 6.31% 2.5% -7.91% 4.45% 6.98% 9.09%
FCF margin (%) 18.45% 11.27% 4.57% 9.23% 4.68% 3.84% 8.62% 10.21%
FCF / Net Income (%) 104.32% 83.68% 72.37% 369.49% -59.14% 86.24% 123.55% 112.3%

Profitability

        
ROA 11.95% 11.15% 5.63% 4.14% 2.62% 3.45% 5.61% 6.91%
ROE 47.27% 40.92% 22.35% 17.15% 11.85% 19.5% 25.4% 28.76%

Financial Health

        
Leverage (Debt/EBITDA) 0.16x 0.34x 1.59x 1.81x 2.23x 1.82x 1.38x 1.26x
Debt / Free cash flow 0.2x 0.73x 5.61x 3.04x 6.56x 7.3x 2.74x 2.24x

Capital Intensity

        
CAPEX / Current Assets (%) 3.93% 5.86% 6.29% 5.89% 4.2% 3.83% 4.26% 4.12%
CAPEX / EBITDA (%) 17.11% 24.6% 39.07% 38.09% 30.48% 24.84% 24.9% 22.77%
CAPEX / FCF (%) 21.28% 52% 137.77% 63.78% 89.85% 99.69% 49.43% 40.32%

Items per share

        
Cash flow per share 1 9.864 8.331 4.796 6.541 3.532 4.128 4.796 5.999
Change - -15.54% -42.43% 36.38% -46% 16.87% 16.18% 25.09%
Dividend per Share 1 2.07 2.33 2.58 2.64 1.71 1.451 1.528 1.655
Change - 12.56% 10.73% 2.33% -35.23% -15.14% 5.28% 8.37%
Book Value Per Share 1 16.54 15.32 15.48 14.73 10.73 11.83 12.46 13.59
Change - -7.39% 1.02% -4.83% -27.13% 10.24% 5.3% 9.05%
EPS 1 7.79 6.55 2.79 1.08 -3.15 1.706 2.894 3.801
Change - -15.92% -57.4% -61.29% -391.67% 154.15% 69.67% 31.34%
Nbr of stocks (in thousands) 362,512 357,347 357,413 358,564 359,752 360,360 360,360 360,360
Announcement Date 19/08/21 18/08/22 18/08/23 19/08/24 20/08/25 - - -
1USD
Estimates
2026 *2027 *
P/E ratio 60.2x 35.5x
PBR 8.67x 8.24x
EV / Sales 2.76x 2.62x
Yield 1.41% 1.49%
More valuation ratios * Estimated data

EPS & Dividend

Y-o-Y evolution of P/E

Year-on-year evolution of the Yield

Trader
Investor
Global
Quality
ESG MSCI
A
More Ratings
Sell
Consensus
Buy
Mean consensus
OUTPERFORM
Number of Analysts
26
Last Close Price
102.64USD
Average target price
102.17USD
Spread / Average Target
-0.45%
Consensus

Quarterly revenue - Rate of surprise

  1. Stock Market
  2. Equities
  3. EL Stock
  4. Financials Estee Lauder