All companies
Estée Lauder Companies logo
StaplesEL

Estée Lauder Companies (EL) Financial Forecast Calculator

Interactive 5-year forecast and DCF for Estée Lauder Companies. Adjust revenue growth, gross margin, capex intensity, WACC, and terminal growth - see revenue, free cash flow, and enterprise value update in real time. Seeded from Estée Lauder Companies’s most recent SEC filings.

Revenue FY30
$17.32B
from $15.91B
FCF FY30
$1.85B
Margin 10.7%
Enterprise value
$27.58B
1.7× LTM revenue
Equity value
$23.77B
Net debt $3.81B
Revenue & free cash flow - history and 5-year forecast
Line (area)
Bars
Historicals from SEC EDGAR (grey). Forecast years (color) update live as you move the sliders.

Assumptions

Revenue growth (annual)
1.7%
-10.0%baseline 1.7%40.0%
Gross margin
75.2%
5.0%baseline 75.2%90.0%
Capex % of revenue
5.1%
0.0%baseline 5.1%30.0%
WACC (discount rate)
9.00%
4.0%baseline 9.0%18.0%
Terminal growth
2.50%
0.0%baseline 2.5%5.0%

Need this as an Excel model?

Keep iterating on the Estée Lauder Companies forecast in Excel. The downloadable sample has every assumption you see here plus a fully integrated income statement, balance sheet, cash flow, and debt schedule - five years of SEC historicals and live formulas in a fully editable workbook.

income_statement.xlsx
Income statement, brown brand palette
income_statement.xlsx
Income statement, green brand palette
income_statement.xlsx
Income statement, red brand palette

Frequently asked

How does Estée Lauder generate its revenue across different product segments?+

Estée Lauder generates revenue primarily from Skin Care (~45%), Makeup (~28%), Fragrance (~22%), and Hair Care (~5%) segments. Revenue growth for these segments is driven by volume and price/mix realization, with significant exposure to Asia Travel Retail and strong seasonality in fiscal Q2 due to holiday gifting.

What are the key revenue growth assumptions in the financial model for Estée Lauder Companies?+

The financial model for Estée Lauder Companies assumes a Revenue_Growth of approximately 1.7%. This forecast considers the company's Profit Recovery and Growth Plan (PRGP) and its aim to restore historical double-digit operating margins.

What is the assumed capital expenditure percentage of revenue in the Estée Lauder financial model?+

The financial model for Estée Lauder Companies assumes Capex_Pct_Revenue to be approximately 5.1%. This capital expenditure is divided into roughly 40% for maintenance and 60% for growth, focusing on supply chain optimization and digital/e-commerce platform enhancements.

What is the primary objective of the Estée Lauder Companies financial model?+

The model's primary objective is to evaluate whether The Estée Lauder Companies' Profit Recovery and Growth Plan (PRGP) will successfully restore historical double-digit operating margins. It also assesses if the plan can drive sufficient free cash flow to justify an equity investment following recent severe earnings compression.

Is an Excel financial model available for download for Estée Lauder Companies (EL)?+

Yes, an Excel financial model for Estée Lauder Companies (EL) is available for download. This model provides a forecast horizon from FY2026 to FY2030, allowing users to analyze the company's projected financials and key assumptions.

Have more financial modelling questions? Contact us

Go further

Build the financial model you need with Fina

Browse templates, examples, and downloadable Excel models for the analysis you are trying to build. If you can't find your model, ask Fina to build a model for your specific needs.

Start for free
Excel financial model spreadsheet preview showing Customer Rollforward
Fina interactive chat interface preview