Stock Analysis on Net

Estée Lauder Cos. Inc. (NYSE:EL)

$22.49

This company has been moved to the archive! The financial data has not been updated since August 18, 2023.

Common-Size Income Statement
Quarterly Data

Paying user area

The data is hidden behind: . Unhide it.

This is a one-time payment. There is no automatic renewal.


We accept:

Visa Mastercard American Express Maestro Discover JCB PayPal Google Pay
Visa Secure Mastercard Identity Check American Express SafeKey

Estée Lauder Cos. Inc., common-size consolidated income statement (quarterly data)

Microsoft Excel
3 months ended: Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 Jun 30, 2022 Mar 31, 2022 Dec 31, 2021 Sep 30, 2021 Jun 30, 2021 Mar 31, 2021 Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017
Net sales
Cost of sales
Gross profit
Selling, general and administrative
Restructuring and other charges
Goodwill impairment
Impairment of other intangible assets
Operating expenses
Operating income
Interest expense
Interest income and investment income, net
Other components of net periodic benefit cost
Other income
Earnings before income taxes
Provision for income taxes
Net earnings (loss)
Net (earnings) loss attributable to noncontrolling interests and redeemable noncontrolling interest
Net earnings (loss) attributable to The Estée Lauder Companies Inc.

Based on: 10-K (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-Q (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-K (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-Q (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-K (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-Q (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-K (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-Q (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-K (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-Q (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-K (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-Q (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30).


The analysis of the quarterly financial data reveals distinct patterns and fluctuations over the examined periods in several key financial metrics expressed as a percentage of net sales.

Cost of Sales
The cost of sales generally fluctuates between approximately -20% and -32% of net sales, with noticeable increases during certain quarters, particularly from March 2020 onwards, where costs peaked substantially, reflecting potential supply chain pressures or increased product costs. The highest values were observed in mid-2020 and again in late 2022, indicating periods of increased expense burden relative to sales.
Gross Profit
Gross profit margins mostly remain robust, generally between 67% and 79%, but there was a significant dip during mid-2020, dropping to approximately 68%. This decline aligns with the period of increased cost of sales, indicative of margin compression during challenging operational conditions. Subsequently, margins partially recovered but did not return to the prior highest levels, suggesting continued pricing or cost pressures.
Selling, General and Administrative Expenses (SG&A)
SG&A expenses exhibit considerable volatility, fluctuating mostly between -52% and -69% of net sales. A notable spike occurs in mid-2020, where SG&A expenses rose sharply to nearly -78%, reflecting increased operational costs possibly related to restructuring, marketing, or adaptation to external challenges. The trend post-2020 indicates attempts to control these expenses as they generally reduced but showed signs of rising again by mid-2023.
Restructuring and Other Charges
These charges are generally minor relative to net sales but show intermittent spikes, such as in Q2 2019 and Q1 2021, suggesting occasional restructuring activities or other extraordinary expenses impacting profitability negatively in these periods.
Goodwill and Intangible Asset Impairments
There are sporadic impairments notable from late 2018 through 2022, especially declining sharply in certain quarters like Q4 2019 and Q1 2020. These impairments indicate periodic assessments leading to write-downs, potentially affecting operating results and signaling revaluation of acquired assets during these intervals.
Operating Expenses and Income
Operating expenses closely mirror SG&A trends, with significant surges in mid-2020, reflecting combined effects of recurring and extraordinary costs. Operating income demonstrates pronounced volatility, with strong performance in most quarters before 2020, including peaks above 20% of net sales. However, a sharp decline occurs in mid-2020 with negative operating income, coinciding with COVID-19 impacts. Recovery follows with some fluctuations through 2023, though operating income does not consistently reach prior peak levels, indicating ongoing margin pressure.
Interest Expense and Income
Interest expense remains relatively stable, hovering below -1.5% of net sales but showing an uptick in periods such as mid-2020 and late 2022 to mid-2023, possibly due to increased debt or refinancing costs. Interest and investment income are modest but generally positive, with a gradual increase noted in 2023, potentially reflecting improved investment performance or cash management.
Other Income and Expenses
Other income shows significant positive spikes in certain quarters (notably Q1 2019 and Q3 2020), offsetting some operational losses and indicating occasional gains from non-core activities or asset sales.
Earnings Before Income Taxes (EBIT) and Net Earnings
EBIT follows a pattern similar to operating income, with strong positive margins prior to 2020, a steep decline to negative territory amid the global crisis, and partial recovery thereafter. Net earnings demonstrate a comparable trend, with notable quarterly swings, including negative earnings in Q2 2020 and modest to strong profits before and after this period. Earnings attributable to the parent company align closely with consolidated net earnings, confirming consistent ownership effects.
Provision for Income Taxes
Tax provisions as a percentage of net sales vary markedly, including negative values which infer tax benefits or credits during certain quarters. This variability suggests fluctuating taxable income levels and possibly changes in tax strategies or regulations impacting the effective tax rate.

Overall, the data reflects a company experiencing stable revenue generation with consistent variability in cost management and profitability largely influenced by external economic conditions, notably mid-2020 disruptions. Post-crisis, there is evidence of operational recovery, though challenges remain in controlling costs and restoring prior profitability levels fully.