Projected Income Statement: Estee Lauder

Forecast Balance Sheet: Estee Lauder

Forecast Balance Sheet - Estee Lauder
Fiscal Period: June 2022 2023 2024 2025 2026 2027 2028 2029
Net Debt 1 1,455 4,085 4,376 4,396 3,808 4,493 3,729 2,886
Change - 180.76% 7.12% 0.46% -13.38% 17.99% -17% -22.61%
Announcement Date 18/08/22 18/08/23 19/08/24 20/08/25 19/08/26 - - -
1USD in Million
Estimates

Cash Flow Forecast: Estee Lauder

Fiscal Period: June 2022 2023 2024 2025 2026 2027 2028 2029
CAPEX 1 1,040 1,003 919 602 457 630 656 686.5
Change - -3.56% -8.37% -34.49% -24.09% 37.85% 4.14% 4.64%
Free Cash Flow (FCF) 1 2,000 728 1,441 670 1,316 847.2 1,642 1,755
Change - -63.6% 97.94% -53.5% 96.42% -35.62% 93.83% 6.87%
Announcement Date 18/08/22 18/08/23 19/08/24 20/08/25 19/08/26 - - -
1USD in Million
Estimates

Forecast Financial Ratios: Estee Lauder

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

Profitability

        
EBITDA Margin (%) 23.83% 16.11% 15.46% 13.79% 16.5% 17.97% 19.46% 20.22%
EBIT Margin (%) 19.73% 11.44% 10.17% 8% 11.21% 13.17% 14.5% 15.32%
EBT Margin (%) 17.11% 8.77% 4.95% -7.26% 3.44% 10.5% 13.08% 13.76%
Net margin (%) 13.47% 6.31% 2.5% -7.91% 1.21% 6.8% 8.55% 8.98%
FCF margin (%) 11.27% 4.57% 9.23% 4.68% 8.74% 5.38% 10.01% 10.19%
FCF / Net Income (%) 83.68% 72.37% 369.49% -59.14% 723.08% 79.22% 117.03% 113.48%

Profitability

        
ROA 11.15% 5.63% 4.14% 2.62% 4.62% 6.12% 7.35% 7.7%
ROE 40.92% 22.35% 17.15% 11.85% 23.87% 29.94% 31.72% 31.17%

Financial Health

        
Leverage (Debt/EBITDA) 0.34x 1.59x 1.81x 2.23x 1.53x 1.59x 1.17x 0.83x
Debt / Free cash flow 0.73x 5.61x 3.04x 6.56x 2.89x 5.3x 2.27x 1.64x

Capital Intensity

        
CAPEX / Current Assets (%) 5.86% 6.29% 5.89% 4.2% 3.04% 4% 4% 3.99%
CAPEX / EBITDA (%) 24.6% 39.07% 38.09% 30.48% 18.41% 22.28% 20.55% 19.72%
CAPEX / FCF (%) 52% 137.77% 63.78% 89.85% 34.73% 74.36% 39.95% 39.12%

Items per share

        
Cash flow per share 1 8.331 4.796 6.541 3.532 4.86 3.904 5.604 6.905
Change - -42.43% 36.38% -46% 37.59% -19.67% 43.53% 23.22%
Dividend per Share 1 2.33 2.58 2.64 1.71 1.4 1.548 1.651 1.835
Change - 10.73% 2.33% -35.23% -18.13% 10.6% 6.65% 11.13%
Book Value Per Share 1 15.32 15.48 14.73 10.73 10.48 11.86 13.5 15.13
Change - 1.02% -4.83% -27.13% -2.34% 13.19% 13.77% 12.06%
EPS 1 6.55 2.79 1.08 -3.15 0.5 2.917 3.852 4.4
Change - -57.4% -61.29% -391.67% 115.87% 483.48% 32.02% 14.23%
Nbr of stocks (in thousands) 357,347 357,413 358,564 359,752 361,795 361,799 361,799 361,799
Announcement Date 18/08/22 18/08/23 19/08/24 20/08/25 19/08/26 - - -
1USD
Estimates
2027 *2028 *
P/E 37.2x 28.2x
PBR 9.16x 8.05x
EV / Sales 2.78x 2.62x
Yield 1.42% 1.52%

EPS & Dividend

EPS & Dividend - Estee Lauder


Y-o-Y evolution of P/E

Valuation ratios - P/E - Estee Lauder
 

Year-on-year evolution of the Yield

Valuation ratios - Yield - Estee Lauder
Trader
Investor
Global
Quality
ESG MSCI
A
MarketScreener Ratings - Estee Lauder
Sell
Consensus
Buy
Mean consensus
OUTPERFORM
Number of Analysts
30
Last Close Price
108.67USD
Average target price
110.05USD
Spread / Average Target
+1.27%

Quarterly revenue - Rate of surprise

Rate of surprise - Net sales - Quarterly - Estee Lauder
  1. Stock Market
  2. Stocks
  3. EL Stock
  4. Financials Estee Lauder