Estée Lauder Companies Financial Model
Consumer Goods Company Financials Example (Free Excel Download)
The Estée Lauder Companies Inc. is a global leader in prestige beauty, manufacturing and marketing skin care, makeup, fragrance, and hair care products under brands like La Mer, MAC, and Clinique.
professionals from Deloitte
Used by professionals from
About this model
This model evaluates whether The Estée Lauder Companies' Profit Recovery and Growth Plan (PRGP) will successfully restore historical double-digit operating margins and drive sufficient free cash flow to justify an equity investment following recent severe earnings compression.
- The Estée Lauder Companies Inc. is a global leader in prestige beauty, manufacturing and marketing skin care, makeup, fragrance, and hair care products under brands like La Mer, MAC, and Clinique.
- Business segments: Skin Care (~45%), Makeup (~28%), Fragrance (~22%), Hair Care (~5%).
- Key geographies: Americas (~30%), Europe, Middle East & Africa (EMEA) (~40%, heavily skewed by Global Travel Retail), Asia/Pacific (~30%).
- Business model type: Asset-light manufacturing with heavy marketing and advertising spend, selling through department stores, specialty multi-brand retailers, travel retail, and direct-to-consumer online channels.
- Competitive position: The second-largest pure-play beauty company globally behind L'Oréal, holding significant market share in prestige categories.
- Recent major events: A CEO transition to Stéphane de La Faverie in early 2026, a massive $1.29 billion impairment charge in fiscal 2025, and the expansion of the Profit Recovery and Growth Plan (PRGP) aiming to cut up to 7,000 positions and generate $800 million to $1 billion in annual savings by fiscal 2027.
The downloadable Estée Lauder Companies financial model includes SEC-sourced historical financials, forecast assumptions, core operating schedules, and valuation outputs in an Excel workbook built for review and scenario analysis.
A turnkey financial model
Live formulas, no hardcoded values
Outputs are driven by live formulas, so the workbook updates from its assumptions instead of relying on hardcoded results.
All assumptions in one tab
Inputs are clearly marked in the Assumptions tab and separated from calculations, making it clear what to change and what to leave intact.
Statements always balancing
For integrated-statement models, the balance sheet, cash flow, and supporting schedules tie through properly.
Distinct schedules for clarity
Debt, working capital, taxes, and cash flow can get messy quickly. We group calculations in clear schedules, not across disconnected tabs.
No hidden macros or external links
There are no unexplained external workbook links or macros to undermine auditability or portability.
Changes flow through the model
Update a key driver and see the impact carry through the forecast, financing, and return outputs. We never use hardcoded numbers in formulas.
Historicals & AssumptionsEstée Lauder Companies financial modelCompany, Historicals & Assumptions used
Source: SEC EDGAR · values in USD
| Line item | FY2022 | FY2023 | FY2024 | FY2025 | FY2026 |
|---|---|---|---|---|---|
| Revenue | $17.74B | $15.91B | $15.61B | $14.33B | $15.05B |
| Gross profit | $13.43B | $11.35B | $11.18B | $10.60B | $11.36B |
| Operating income | $3.17B | $1.51B | $970.0M | -$785.0M | $780.0M |
| Net income | $2.41B | $1.01B | $409.0M | -$1.13B | $182.0M |
Forecast assumptions
Defaults used in the downloadable model. Forecast horizon: FY2026–FY2030.
See 8 moreSee less
How to build a detailed financial model for Estée Lauder Companies
A complete walkthrough of every driver, margin, working-capital input, and capital-allocation assumption used in the downloadable model.
Revenue Deep Dive
- Skin Care
- Segment name: Skin Care
- Revenue driver formula: Skin Care Volume x Price/Mix Realisation
- Historical growth rate: -12% in FY25, recovering to +6% in Q2 FY26.
- Key growth levers and headwinds: Driven by La Mer and The Ordinary; heavily exposed to headwinds in Asia Travel Retail and Chinese consumer sentiment.
- Pricing dynamics: High pricing power (prestige positioning), though promotional discipline is required to protect brand equity.
- Revenue recognition notes: Recognised upon transfer of control to retailers or direct-to-consumer delivery; net of estimated returns and allowances.
- Seasonality: Strongest in fiscal Q2 (October to December) due to holiday gifting, particularly for premium sets.
- Makeup
- Segment name: Makeup
- Revenue driver formula: Makeup Volume x Price/Mix Realisation
- Historical growth rate: -6% in FY25, flat to -1% in Q2 FY26.
- Key growth levers and headwinds: Driven by MAC, Clinique, and Bobbi Brown; faces headwinds from the Tom Ford brand transition and shifting consumer preferences towards skincare.
- Pricing dynamics: Highly competitive, requiring constant innovation and trend-led product drops to maintain pricing.
- Revenue recognition notes: Standard point-of-sale or delivery recognition, with significant accruals for estimated returns on seasonal colour palettes.
- Seasonality: Peaks in fiscal Q2 for holiday collections and fiscal Q4 for summer launches.
- Fragrance
- Segment name: Fragrance
- Revenue driver formula: Fragrance Volume x Price/Mix Realisation
- Historical growth rate: Flat in FY25, +6% in Q2 FY26.
- Key growth levers and headwinds: High-single-digit growth from luxury brands like Tom Ford, Le Labo, and Jo Malone London; highly resilient category.
- Pricing dynamics: Exceptional pricing power in the artisanal and luxury fragrance tiers.
- Revenue recognition notes: Standard recognition upon transfer of control.
- Seasonality: Highly concentrated in fiscal Q2 (holiday season) and fiscal Q4 (Mother's Day and Father's Day).
- Hair Care
- Segment name: Hair Care
- Revenue driver formula: Hair Care Volume x Price/Mix Realisation
- Historical growth rate: -10% in FY25, +5% in Q2 FY26.
- Key growth levers and headwinds: Driven by Aveda and Bumble and bumble; growth relies on salon distribution expansion and new product launches like The Ordinary's hair serums.
- Pricing dynamics: Premium salon pricing, vulnerable to consumer trade-down in recessionary environments.
- Revenue recognition notes: Standard recognition.
- Seasonality: Relatively stable throughout the year compared to other categories.
Cost Structure
Variable Costs / COGS
- Line-by-line breakdown: Raw materials (ingredients), packaging components, third-party manufacturing costs, and supply chain overhead.
- Gross margin range: 71% to 76% (FY25 was lower, Q2 FY26 recovered to 76.5%).
- Key input costs: Specialty chemicals, natural extracts, glass and plastic packaging, and freight.
- How COGS scales: High operating leverage. Gross margin expands significantly when promotional discounting and inventory obsolescence are minimised (a key focus of the PRGP).
Operating Expenses
- R&D: Not capitalised; expensed as incurred. Typically 1.5% to 2.0% of revenue, covering formulation and clinical testing.
- SG&A: The largest expense category. Includes advertising and promotional activities (typically 20% to 25% of sales), store operating costs, selling expenses, and general administrative overhead.
- Depreciation & Amortisation: Typically 4% to 5% of revenue, split between tangible retail fixtures and intangible brand amortisation.
- Stock-Based Compensation: Typically 1% to 2% of revenue.
- Restructuring / one-time charges: Highly material. The PRGP includes $1.2 billion to $1.6 billion in restructuring charges spanning FY25 to FY27, alongside a $1.286 billion impairment charge recorded in FY25.
Margin Profile
- Gross margin: 71% to 76%.
- EBITDA margin: Historically 18% to 22%, compressed to below 10% in FY24/FY25, targeting a return to mid-teens.
- Operating margin: Historically 15% to 20%, fell to low single digits in FY25, recovering to 14.4% (adjusted) in Q2 FY26.
- Margin trend: Expanding from a trough. The PRGP aims to restore double-digit operating margins by stripping out non-consumer-facing expenses.
Balance Sheet Structure
- Total assets: Approximately $19 billion to $20 billion.
- Key asset categories: Inventory (highly material due to prestige product lifecycles), Goodwill and Intangible Assets (from acquisitions like Tom Ford and Deciem), and Cash.
- Goodwill & intangibles: Approximately 25% to 30% of total assets, even after the massive FY25 impairments.
- Working capital profile:
- Days Sales Outstanding (DSO): 40 to 50 days.
- Days Inventory Outstanding (DIO): 180 to 200 days (very high due to global supply chains and prestige product ranges).
- Days Payable Outstanding (DPO): 100 to 120 days.
- Net working capital as % of revenue: Typically 15% to 20%.
- Is working capital positive or negative? Working capital is positive and represents a use of cash during growth phases, primarily driven by inventory builds ahead of the holiday season.
- PP&E: Approximately $3 billion, consisting of manufacturing facilities, distribution centres, and retail store buildouts.
- Right-of-use assets / operating leases: Material, approximately $1.8 billion to $2.0 billion, representing leases for freestanding retail stores and corporate offices.
Capital Expenditure & Investment
- Capex as % of revenue: 4.0% to 5.0%.
- Maintenance capex vs. growth capex: Approximately 40% maintenance (facility upkeep) and 60% growth (IT infrastructure, digital capabilities, and new retail store formats).
- Major capex programmes: Supply chain optimisation and digital/e-commerce platform enhancements under the Beauty Reimagined strategy.
- Capitalised software / development costs: Material component of capex as the company modernises its enterprise resource planning systems.
- M&A pattern: Historically a bolt-on acquirer of high-growth prestige brands (e.g., Le Labo, The Ordinary, Tom Ford beauty license buyout).
- Typical acquisition multiple paid: High revenue multiples (often 4x to 6x sales) for fast-growing prestige brands.
Debt & Capital Structure
- Total debt: Approximately $7.3 billion in long-term debt and $5.0 billion in current liabilities (including current portion of debt and payables).
- Debt/EBITDA ratio: Spiked above 3.0x recently due to EBITDA compression; target is below 2.0x.
- Credit rating: Investment grade, though rating agencies have placed negative outlooks due to recent leverage increases (total debt to capitalisation rose to 65% in FY25).
- Key debt instruments: Senior unsecured notes and a commercial paper programme backed by a revolving credit facility.
- Maturity profile: Staggered bond maturities over the next 10 to 30 years.
- Interest rate profile: Predominantly fixed-rate bonds with a weighted average cost of debt around 3.5% to 4.5%.
- Covenants: Standard investment-grade interest coverage and leverage covenants.
- Share repurchase programme: Historically active but paused or minimised recently to preserve liquidity during the turnaround.
- Dividend policy: Maintained at $0.35 per share quarterly, yielding approximately 1.5% to 2.0% depending on the depressed share price.
Cash Flow Characteristics
- Operating cash flow conversion: Historically >1.0x, but highly volatile recently due to inventory fluctuations and restructuring cash outlays.
- Free cash flow margin: Historically 10% to 15%, compressed to low single digits in FY24/FY25, recovering in FY26.
- Major non-cash items: Depreciation, amortisation, stock-based compensation, and the $1.286 billion goodwill/intangible impairment in FY25.
- Working capital cash flow impact: Significant use of cash in Q1 (inventory build) and source of cash in Q2/Q3 (receivables collection from holiday sales).
- Capex intensity: Moderate (4% of sales), allowing for strong free cash flow generation when margins are normalised.
- Cash tax rate vs. GAAP effective tax rate: The GAAP rate has been highly volatile (spiking to 51% in Q2 FY26 on a reported basis, 36% to 40% adjusted) due to valuation allowances on foreign tax credits and geographic earnings mix.
Sheet Structure
- Assumptions: Macro drivers, segment growth rates, margin targets, PRGP savings targets, working capital days, and tax rates.
- Income Statement: Consolidated view from Net Sales down to Net Earnings, including EPS and Diluted EPS.
- Revenue & Margin Build: Net sales and operating income broken out by the four reporting segments (Skin Care, Makeup, Fragrance, Hair Care).
- Geographic Revenue Build: Net sales broken out by Americas, EMEA, and Asia/Pacific.
- SG&A & Restructuring Schedule: Detailed build of Advertising & Promotion, General & Administrative, and the specific cash and non-cash charges related to the PRGP.
- Balance Sheet: Standard assets, liabilities, and equity, mirroring the 10-K presentation.
- Cash Flow Statement: Indirect method starting from Net Earnings, adjusting for impairments, and detailing working capital changes.
- Working Capital Schedule: Calculation of receivables, inventory, and payables based on DSO, DIO, and DPO.
- Debt & Interest Schedule: Tranches of senior notes, commercial paper, interest expense calculation, and debt paydown logic.
- PP&E & Intangibles: Capex, depreciation, amortisation, and a schedule for the recent goodwill impairments.
- DCF Valuation: Unlevered free cash flow build, WACC calculation, terminal value, and implied share price.
Key Financial Relationships
- Skin Care Net Sales = Prior Year Skin Care Net Sales * (1 + Skin Care Organic Growth Rate)
- EMEA Net Sales = Prior Year EMEA Net Sales * (1 + EMEA Organic Growth Rate)
- Consolidated Net Sales = Skin Care Net Sales + Makeup Net Sales + Fragrance Net Sales + Hair Care Net Sales + Other Net Sales
- Gross Profit = Consolidated Net Sales * Gross Margin Percentage
- Advertising & Promotion Expense = Consolidated Net Sales * Advertising & Promotion %
- PRGP Restructuring Charges = Hardcoded schedule of expected charges (targeting $1.2 billion to $1.6 billion total by FY27)
- Adjusted Operating Income = Reported Operating Income + PRGP Restructuring Charges + Goodwill/Intangible Impairments
- Interest Expense = Average Total Debt Balance * Weighted Average Interest Rate
- Ending Inventory = (COGS / 365) * Days Inventory Outstanding (DIO)
- Free Cash Flow = Cash Flow from Operations - Capital Expenditures
- Adjusted Effective Tax Rate = Adjusted Provision for Income Taxes / Adjusted Earnings Before Taxes
Cross-Sheet Dependencies
- The Assumptions sheet dictates the growth rates and margin profiles on the Revenue & Margin Build and SG&A & Restructuring Schedule.
- The Revenue & Margin Build feeds the top line and gross profit of the Income Statement.
- The SG&A & Restructuring Schedule feeds the operating expenses on the Income Statement and the add-backs on the Cash Flow Statement.
- The Income Statement generates Net Earnings, which begins the Cash Flow Statement.
- The Working Capital Schedule calculates the change in operating assets and liabilities, feeding the Cash Flow Statement.
- The Cash Flow Statement determines the ending cash balance and debt requirements, feeding the Balance Sheet and Debt & Interest Schedule.
- A circularity exists between the Debt & Interest Schedule (interest expense) and the Income Statement (net income), which impacts cash flow and the subsequent need for debt.
Sign Convention
- Revenue, Assets, and Equity are entered and displayed as positive numbers.
- Expenses (COGS, SG&A, Interest) are entered as positive numbers and subtracted in formulas to calculate profit subtotals.
- Liabilities are entered as positive numbers.
- On the Cash Flow Statement, cash inflows are positive and cash outflows (including Capex and dividends) are negative.
Things Most Likely to Go Wrong
- EMEA segment distortion: The EMEA segment includes Global Travel Retail (sales in airports worldwide), meaning its performance is heavily tied to Asian travelling consumers, not just European domestic demand.
- Ignoring PRGP adjustments: Failing to separate the $1.2 billion to $1.6 billion in restructuring charges from core SG&A will severely distort run-rate margin forecasting.
- Impairment add-backs: The fiscal 2025 results include a $1.286 billion non-cash impairment. If this is not added back, historical operating margins will look structurally broken rather than cyclically depressed.
- Inventory dynamics: The company runs very high Days Inventory Outstanding (180 to 200 days). Assuming standard consumer packaged goods inventory turns will break the working capital cash flow logic.
- Seasonality: Fiscal Q2 (ending December 31) is massively outsized due to holiday gifting. Annualising Q1 or Q3 results will result in highly inaccurate full-year forecasts.
- Tax rate volatility: The reported effective tax rate has spiked erratically (over 50% in recent quarters) due to valuation allowances on foreign tax credits. The model must use the management-guided adjusted tax rate of approximately 36% to 40% for forecasting.
- Capital expenditure phasing: Capex is heavily weighted towards the second half of the fiscal year.
- Stock-based compensation: This runs at a material percentage of revenue and must be treated as a non-cash add-back in the cash flow statement, but included in the diluted share count calculation.
Validation Checks
- Gross margin should remain in the 73% to 77% range; flag if it drops below 70% or exceeds 78%.
- Adjusted Operating Margin should trend from current high-single digits towards the PRGP target of 14% to 15% by FY27.
- Capex as a percentage of revenue should consistently run between 4.0% and 5.0%.
- Days Inventory Outstanding (DIO) should remain above 160 days; flag if the model assumes an unrealistic sudden improvement in inventory turns.
- The Balance Sheet must balance perfectly in every forecasted period (Total Assets = Total Liabilities + Equity).
- Debt/EBITDA should peak in FY25/FY26 and decline below 2.5x by FY27 as profitability recovers.
- The effective tax rate should normalise to the 36% to 40% range in the forecast period.
- Dividend payout must be covered by Free Cash Flow in the terminal year.
Key Assumptions (Default Values)
| Assumption | Default Value | Unit | Rationale |
|---|---|---|---|
| Skin Care Revenue Growth | 3.0 | % | Reflects moderate recovery in Asia Travel Retail and La Mer brand momentum |
| Makeup Revenue Growth | 1.0 | % | Reflects competitive pressures offset by new product launches |
| Fragrance Revenue Growth | 5.0 | % | Reflects strong ongoing demand for luxury and artisanal fragrances |
| Hair Care Revenue Growth | 4.0 | % | Reflects distribution expansion of The Ordinary hair products |
| Gross Margin | 75.5 | % | Aligns with Q2 FY26 adjusted gross margin and PRGP efficiency targets |
| Advertising & Promotion | 22.0 | % of Sales | Required consumer-facing investment to defend market share |
| Other SG&A | 39.0 | % of Sales | Reflects PRGP cost savings stripping out non-consumer-facing expenses |
| Adjusted Effective Tax Rate | 36.0 | % | Management guidance for the fiscal 2026 full year |
| Days Sales Outstanding (DSO) | 45 | Days | Historical average for wholesale and retail receivables |
| Days Inventory Outstanding (DIO) | 185 | Days | Reflects long supply chains and prestige product lifecycles |
| Days Payable Outstanding (DPO) | 110 | Days | Historical average reflecting strong supplier negotiation power |
| Capex as % of Revenue | 4.0 | % | Management guidance for normalised investment levels |
| Weighted Average Interest Rate | 4.2 | % | Based on current yields of outstanding senior unsecured notes |
| Quarterly Dividend per Share | 0.35 | $ | Maintained at current declared levels to preserve cash |
| WACC | 8.5 | % | Standard discount rate for a large-cap consumer staples equity |
| Terminal Growth Rate | 2.5 | % | Aligns with long-term global prestige beauty market growth |
Data Sources & Benchmarks
- Where to find this company's filings: SEC EDGAR (The Estée Lauder Companies Inc., Ticker: EL) and the EL investor relations page.
- Key peers for benchmarking: L'Oréal S.A. (OR.PA), Coty Inc. (COTY), Shiseido Company (4911.T), and e.l.f. Beauty (ELF).
- Industry data sources: Circana (formerly NPD Group) for US prestige beauty market share data, and Generation Research for global travel retail data.
- Consensus estimates source: Bloomberg or FactSet for tracking analyst expectations on PRGP margin recovery targets.
- Proprietary data: SimilarWeb for direct-to-consumer web traffic trends; airport passenger volume data for forecasting Global Travel Retail recovery.
Sources
- The Estée Lauder Companies Inc. Fiscal 2025 Form 10-K (SEC EDGAR).
- The Estée Lauder Companies Inc. Q1 Fiscal 2026 Earnings Release and 10-Q (October 2025).
- The Estée Lauder Companies Inc. Q2 Fiscal 2026 Earnings Release (February 5, 2026).
- Management commentary from the Q2 Fiscal 2026 Earnings Call regarding the Profit Recovery and Growth Plan (PRGP) and Beauty Reimagined strategy.
- Trefis and Seeking Alpha analyst reports on Estée Lauder's margin recovery and travel retail exposure (2025-2026).
Do more with the Estée Lauder Companies model
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
Created by ex-finance professionals
Hey, I’m Alex and I created Finamodel.
Over my years in the finance industry I kept building the same models over and over again. Same structure, same assumptions, different logo. So I started building frameworks to turn them into clean, reusable templates.
Every model here is one I’d actually use for a client, and I personally vet each one before it goes up.
I’m not an expert in every industry, but I’ve built enough models to know what belongs in one. And when something is completely foreign to me, I reach out to my network for experts to work on our models with us.
Having a template library on hand cuts a first build from hours to minutes.
Need help finding your model? You’ll find me in the Finamodel app!
Other Consumer Goods Company Financial Models
Browse another company in the same sector.
Church & Dwight
Church & Dwight Co., Inc.
Colgate-Palmolive
Colgate-Palmolive is a leading global consumer products company focused on the production, distribution, and provision of household, health care, personal care, and veterinary products.
Clorox
The Clorox Company is a leading multinational manufacturer and marketer of consumer and professional products.
Deckers Brands
Deckers Brands is a global footwear, apparel, and accessories designer and distributor, best known for its powerhouse brands UGG and HOKA.
Kimberly-Clark
Kimberly-Clark is a global consumer packaged goods company that manufactures and markets personal care and consumer tissue products under iconic brands such as Huggies, Kleenex, Kotex, and Scott.
Kenvue
Kenvue is the world's largest pure-play consumer health company by revenue, manufacturing and marketing a portfolio of iconic, science-backed brands including Tylenol, Neutrogena, Listerine, and Band-Aid.
Lululemon Athletica
Lululemon Athletica is a premium athletic apparel, footwear, and accessories company that designs and retails products for yoga, running, training, and other sweaty pursuits.
Altria
Altria is the leading manufacturer and seller of tobacco products in the United States, spanning smokeable products, oral tobacco products, and e-vapor products.
Explore more Consumer financial model templates.
