Estée Lauder DCF Financial Model Excel Template | Company Valuation, Forecasting & Investment Analysis

The Estée Lauder DCF Financial Model is a comprehensive valuation template designed to estimate the company’s intrinsic value through a structured Discounted Cash Flow approach. The model provides detailed financial forecasts from FY2025 to FY2034, allowing users to analyze Estée Lauder’s expected operating performance, free cash flow generation, and long-term valuation under different assumptions.

The template primarily uses a revenue-based forecasting approach, linking key income statement and cash flow items to projected revenue growth, while selected accounts incorporate operating drivers to improve forecasting detail. Revenue projections are developed across Estée Lauder’s major product segments, including Skin Care, Makeup, Fragrance, and Hair Care, providing a more granular view of future performance.

The model includes Bull, Base, and Bear scenarios, enabling users to assess how changes in revenue growth and operating assumptions affect valuation outcomes. It also features sensitivity analysis to illustrate the impact of changes in WACC and other key valuation assumptions on estimated equity value.

A complete WACC calculation is included, covering cost of equity, cost of debt, capital structure, and tax effects. The model also incorporates working capital, CapEx, depreciation and amortization, terminal value, enterprise value, equity value, and implied value per share.

This template is suitable for valuation practice, financial analysis, investment research, and DCF modeling applications. It offers a framework for understanding how operating forecasts and capital costs translate into company valuation.