Projected Income Statement: Estee Lauder

Forecast Balance Sheet: Estee Lauder

Fiscal Period: June 2020 2021 2022 2023 2024 2025 2026 2027
Net Debt 1 1,114 611 1,455 4,085 4,376 4,962 5,124 4,914
Change - -45.15% 138.13% 180.76% 7.12% 13.39% 3.26% -4.1%
Announcement Date 20/08/20 19/08/21 18/08/22 18/08/23 19/08/24 - - -
1USD in Million
Estimates

Cash Flow Forecast: Estee Lauder

Fiscal Period: June 2020 2021 2022 2023 2024 2025 2026 2027
CAPEX 1 623 637 1,040 1,003 919 604.9 701.3 708.9
Change - 2.25% 63.27% -3.56% -8.37% -34.18% 15.93% 1.09%
Free Cash Flow (FCF) 1 1,657 2,994 2,000 728 1,441 411.1 1,137 1,291
Change - 80.69% -33.2% -63.6% 97.94% -71.47% 176.63% 13.52%
Announcement Date 20/08/20 19/08/21 18/08/22 18/08/23 19/08/24 - - -
1USD in Million
Estimates

Forecast Financial Ratios: Estee Lauder

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

Profitability

        
EBITDA Margin (%) 18.95% 22.94% 23.83% 16.11% 15.46% 13.46% 15.16% 16.71%
EBIT Margin (%) 14.68% 18.93% 19.73% 11.44% 10.17% 7.76% 9.52% 11.4%
EBT Margin (%) 7.32% 20.52% 17.11% 8.77% 4.95% -4.45% 7.85% 9.1%
Net margin (%) 4.79% 17.68% 13.47% 6.31% 2.5% -4.17% 5.2% 6.81%
FCF margin (%) 11.59% 18.45% 11.27% 4.57% 9.23% 2.88% 7.79% 8.47%
FCF / Net Income (%) 242.25% 104.32% 83.68% 72.37% 369.49% -68.98% 149.91% 124.35%

Profitability

        
ROA 9.76% 11.95% 11.15% 5.63% 4.14% 2.52% 3.83% 5%
ROE 36.07% 47.27% 40.92% 22.35% 17.15% 11.02% 17.91% 22.23%

Financial Health

        
Leverage (Debt/EBITDA) 0.41x 0.16x 0.34x 1.59x 1.81x 2.58x 2.32x 1.93x
Debt / Free cash flow 0.67x 0.2x 0.73x 5.61x 3.04x 12.07x 4.51x 3.81x

Capital Intensity

        
CAPEX / Current Assets (%) 4.36% 3.93% 5.86% 6.29% 5.89% 4.23% 4.8% 4.65%
CAPEX / EBITDA (%) 23% 17.11% 24.6% 39.07% 38.09% 31.45% 31.68% 27.84%
CAPEX / FCF (%) 37.6% 21.28% 52% 137.77% 63.78% 147.13% 61.66% 54.91%

Items per share

        
Cash flow per share 1 6.214 9.864 8.331 4.796 6.541 3.01 4.247 5.219
Change - 58.74% -15.54% -42.43% 36.38% -53.98% 41.07% 22.91%
Dividend per Share 1 1.39 2.07 2.33 2.58 2.64 1.713 1.479 1.647
Change - 48.92% 12.56% 10.73% 2.33% -35.13% -13.67% 11.36%
Book Value Per Share 1 10.99 16.54 15.32 15.48 14.73 11.37 11.65 12.2
Change - 50.56% -7.39% 1.02% -4.83% -22.83% 2.49% 4.72%
EPS 1 1.86 7.79 6.55 2.79 1.08 -1.621 2.157 2.914
Change - 318.82% -15.92% -57.4% -61.29% -250.05% 233.13% 35.08%
Nbr of stocks (in thousands) 359,999 362,512 357,347 357,413 358,564 359,752 359,752 359,752
Announcement Date 20/08/20 19/08/21 18/08/22 18/08/23 19/08/24 - - -
1USD
Estimates
2025 *2026 *
P/E ratio -46.2x 34.7x
PBR 6.58x 6.42x
EV / Sales 2.23x 2.19x
Yield 2.29% 1.98%
More valuation ratios * Estimated data

EPS & Dividend

Year-on-year evolution of the PER

Year-on-year evolution of the Yield

Trading Rating
Investor Rating
ESG MSCI
A
More Ratings
Sell
Consensus
Buy
Mean consensus
HOLD
Number of Analysts
27
Last Close Price
74.79USD
Average target price
69.08USD
Spread / Average Target
-7.63%
Consensus

Quarterly revenue - Rate of surprise

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