Stock Analysis on Net

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

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

Analysis of Profitability Ratios
Quarterly Data

Microsoft Excel

Profitability Ratios (Summary)

Estée Lauder Cos. Inc., profitability ratios (quarterly data)

Microsoft Excel
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
Return on Sales
Gross profit margin 71.31% 72.06% 73.91% 75.28% 75.73% 76.48% 76.28% 76.15% 76.36% 75.42% 75.25% 75.15% 75.15% 76.58% 77.27% 77.21% 77.21% 77.70% 78.07% 78.78% 79.22%
Operating profit margin 9.48% 10.04% 12.44% 16.76% 17.87% 18.36% 18.06% 16.71% 16.15% 12.52% 9.40% 3.81% 4.24% 8.83% 12.17% 16.02% 15.56% 16.30% 15.48% 15.33% 15.00%
Net profit margin 6.32% 6.88% 9.13% 12.66% 13.47% 18.53% 18.35% 17.83% 17.70% 9.45% 6.54% 4.38% 4.79% 8.43% 11.76% 12.34% 12.01% 12.45% 11.49% 8.48% 8.10%
Return on Investment
Return on equity (ROE) 18.01% 18.56% 25.30% 39.64% 42.75% 54.57% 52.33% 49.98% 47.38% 25.14% 17.12% 13.75% 17.38% 30.10% 40.75% 41.50% 40.70% 39.54% 37.88% 26.80% 23.63%
Return on assets (ROA) 4.30% 4.80% 7.20% 10.94% 11.43% 15.71% 14.74% 14.08% 13.06% 6.98% 4.74% 3.42% 3.85% 7.10% 10.39% 12.18% 13.57% 14.03% 12.87% 9.42% 8.82%

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).

Profitability ratio Description The company
Gross profit margin Gross profit margin indicates the percentage of revenue available to cover operating and other expenditures. Estée Lauder Cos. Inc. gross profit margin ratio deteriorated from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.
Operating profit margin A profitability ratio calculated as operating income divided by revenue. Estée Lauder Cos. Inc. operating profit margin ratio deteriorated from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.
Net profit margin An indicator of profitability, calculated as net income divided by revenue. Estée Lauder Cos. Inc. net profit margin ratio deteriorated from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.

Profitability ratio Description The company
ROE A profitability ratio calculated as net income divided by shareholders’ equity. Estée Lauder Cos. Inc. ROE deteriorated from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.
ROA A profitability ratio calculated as net income divided by total assets. Estée Lauder Cos. Inc. ROA deteriorated from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.

Gross Profit Margin

Estée Lauder Cos. Inc., gross profit margin calculation (quarterly data)

Microsoft Excel
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
Selected Financial Data (US$ in millions)
Gross profit 2,446 2,592 3,401 2,907 2,530 3,251 4,316 3,335 2,950 2,925 3,769 2,737 1,663 2,509 3,583 2,987 2,755 2,925 3,095 2,701 2,598 2,687 2,991 2,563
Net sales 3,609 3,751 4,620 3,930 3,561 4,245 5,539 4,392 3,936 3,864 4,853 3,562 2,430 3,345 4,624 3,895 3,590 3,744 4,005 3,524 3,295 3,370 3,744 3,274
Profitability Ratio
Gross profit margin1 71.31% 72.06% 73.91% 75.28% 75.73% 76.48% 76.28% 76.15% 76.36% 75.42% 75.25% 75.15% 75.15% 76.58% 77.27% 77.21% 77.21% 77.70% 78.07% 78.78% 79.22%
Benchmarks
Gross Profit Margin, Competitors2
Procter & Gamble Co. 47.86% 46.96% 46.60% 47.01% 47.43% 48.32% 49.27% 50.31% 51.25% 51.57% 51.26% 50.78% 50.32% 49.90% 49.77% 49.11% 48.63% 48.04% 48.03% 48.37% 48.73%

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).

1 Q4 2023 Calculation
Gross profit margin = 100 × (Gross profitQ4 2023 + Gross profitQ3 2023 + Gross profitQ2 2023 + Gross profitQ1 2023) ÷ (Net salesQ4 2023 + Net salesQ3 2023 + Net salesQ2 2023 + Net salesQ1 2023)
= 100 × (2,446 + 2,592 + 3,401 + 2,907) ÷ (3,609 + 3,751 + 4,620 + 3,930) = 71.31%

2 Click competitor name to see calculations.

Profitability ratio Description The company
Gross profit margin Gross profit margin indicates the percentage of revenue available to cover operating and other expenditures. Estée Lauder Cos. Inc. gross profit margin ratio deteriorated from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.

Operating Profit Margin

Estée Lauder Cos. Inc., operating profit margin calculation (quarterly data)

Microsoft Excel
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
Selected Financial Data (US$ in millions)
Operating income (5) 297 556 661 79 738 1,418 935 234 616 1,063 705 (543) 109 261 779 216 674 771 652 277 497 710 568
Net sales 3,609 3,751 4,620 3,930 3,561 4,245 5,539 4,392 3,936 3,864 4,853 3,562 2,430 3,345 4,624 3,895 3,590 3,744 4,005 3,524 3,295 3,370 3,744 3,274
Profitability Ratio
Operating profit margin1 9.48% 10.04% 12.44% 16.76% 17.87% 18.36% 18.06% 16.71% 16.15% 12.52% 9.40% 3.81% 4.24% 8.83% 12.17% 16.02% 15.56% 16.30% 15.48% 15.33% 15.00%
Benchmarks
Operating Profit Margin, Competitors2
Procter & Gamble Co. 22.11% 21.70% 21.61% 22.03% 22.21% 22.30% 22.36% 22.98% 23.63% 23.94% 23.79% 23.04% 22.14% 10.00% 9.78% 9.05% 8.11% 19.91% 20.06% 20.23% 20.52%

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).

1 Q4 2023 Calculation
Operating profit margin = 100 × (Operating incomeQ4 2023 + Operating incomeQ3 2023 + Operating incomeQ2 2023 + Operating incomeQ1 2023) ÷ (Net salesQ4 2023 + Net salesQ3 2023 + Net salesQ2 2023 + Net salesQ1 2023)
= 100 × (-5 + 297 + 556 + 661) ÷ (3,609 + 3,751 + 4,620 + 3,930) = 9.48%

2 Click competitor name to see calculations.

Profitability ratio Description The company
Operating profit margin A profitability ratio calculated as operating income divided by revenue. Estée Lauder Cos. Inc. operating profit margin ratio deteriorated from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.

Net Profit Margin

Estée Lauder Cos. Inc., net profit margin calculation (quarterly data)

Microsoft Excel
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
Selected Financial Data (US$ in millions)
Net earnings (loss) attributable to The Estée Lauder Companies Inc. (33) 156 394 489 52 558 1,088 692 1,018 456 873 523 (462) (6) 557 595 157 555 573 500 186 372 123 427
Net sales 3,609 3,751 4,620 3,930 3,561 4,245 5,539 4,392 3,936 3,864 4,853 3,562 2,430 3,345 4,624 3,895 3,590 3,744 4,005 3,524 3,295 3,370 3,744 3,274
Profitability Ratio
Net profit margin1 6.32% 6.88% 9.13% 12.66% 13.47% 18.53% 18.35% 17.83% 17.70% 9.45% 6.54% 4.38% 4.79% 8.43% 11.76% 12.34% 12.01% 12.45% 11.49% 8.48% 8.10%
Benchmarks
Net Profit Margin, Competitors2
Procter & Gamble Co. 17.87% 17.69% 17.79% 18.11% 18.38% 18.33% 18.52% 18.33% 18.79% 18.97% 18.72% 18.92% 18.36% 7.09% 6.92% 6.24% 5.76% 16.44% 16.13% 15.10% 14.59%

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).

1 Q4 2023 Calculation
Net profit margin = 100 × (Net earnings (loss) attributable to The Estée Lauder Companies Inc.Q4 2023 + Net earnings (loss) attributable to The Estée Lauder Companies Inc.Q3 2023 + Net earnings (loss) attributable to The Estée Lauder Companies Inc.Q2 2023 + Net earnings (loss) attributable to The Estée Lauder Companies Inc.Q1 2023) ÷ (Net salesQ4 2023 + Net salesQ3 2023 + Net salesQ2 2023 + Net salesQ1 2023)
= 100 × (-33 + 156 + 394 + 489) ÷ (3,609 + 3,751 + 4,620 + 3,930) = 6.32%

2 Click competitor name to see calculations.

Profitability ratio Description The company
Net profit margin An indicator of profitability, calculated as net income divided by revenue. Estée Lauder Cos. Inc. net profit margin ratio deteriorated from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.

Return on Equity (ROE)

Estée Lauder Cos. Inc., ROE calculation (quarterly data)

Microsoft Excel
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
Selected Financial Data (US$ in millions)
Net earnings (loss) attributable to The Estée Lauder Companies Inc. (33) 156 394 489 52 558 1,088 692 1,018 456 873 523 (462) (6) 557 595 157 555 573 500 186 372 123 427
Stockholders’ equity, The Estée Lauder Companies Inc. 5,585 5,877 5,902 5,517 5,590 6,150 6,218 6,081 6,057 5,528 5,421 4,452 3,935 4,329 4,574 4,530 4,386 4,588 4,306 4,406 4,688 4,711 4,565 4,731
Profitability Ratio
ROE1 18.01% 18.56% 25.30% 39.64% 42.75% 54.57% 52.33% 49.98% 47.38% 25.14% 17.12% 13.75% 17.38% 30.10% 40.75% 41.50% 40.70% 39.54% 37.88% 26.80% 23.63%
Benchmarks
ROE, Competitors2
Procter & Gamble Co. 31.33% 31.73% 32.12% 33.06% 31.64% 32.09% 32.52% 30.67% 30.85% 30.47% 28.74% 28.46% 28.00% 10.95% 10.57% 9.21% 8.26% 20.03% 19.99% 19.33% 18.64%

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).

1 Q4 2023 Calculation
ROE = 100 × (Net earnings (loss) attributable to The Estée Lauder Companies Inc.Q4 2023 + Net earnings (loss) attributable to The Estée Lauder Companies Inc.Q3 2023 + Net earnings (loss) attributable to The Estée Lauder Companies Inc.Q2 2023 + Net earnings (loss) attributable to The Estée Lauder Companies Inc.Q1 2023) ÷ Stockholders’ equity, The Estée Lauder Companies Inc.
= 100 × (-33 + 156 + 394 + 489) ÷ 5,585 = 18.01%

2 Click competitor name to see calculations.

Profitability ratio Description The company
ROE A profitability ratio calculated as net income divided by shareholders’ equity. Estée Lauder Cos. Inc. ROE deteriorated from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.

Return on Assets (ROA)

Estée Lauder Cos. Inc., ROA calculation (quarterly data)

Microsoft Excel
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
Selected Financial Data (US$ in millions)
Net earnings (loss) attributable to The Estée Lauder Companies Inc. (33) 156 394 489 52 558 1,088 692 1,018 456 873 523 (462) (6) 557 595 157 555 573 500 186 372 123 427
Total assets 23,415 22,715 20,731 19,989 20,910 21,359 22,078 21,580 21,971 19,900 19,595 17,903 17,781 18,363 17,937 15,431 13,156 12,931 12,676 12,543 12,567 12,772 12,604 12,202
Profitability Ratio
ROA1 4.30% 4.80% 7.20% 10.94% 11.43% 15.71% 14.74% 14.08% 13.06% 6.98% 4.74% 3.42% 3.85% 7.10% 10.39% 12.18% 13.57% 14.03% 12.87% 9.42% 8.82%
Benchmarks
ROA, Competitors2
Procter & Gamble Co. 12.13% 11.95% 12.13% 12.53% 12.58% 12.14% 11.95% 11.82% 11.99% 12.16% 11.53% 11.44% 10.79% 4.21% 4.31% 3.76% 3.39% 9.06% 8.73% 8.52% 8.24%

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).

1 Q4 2023 Calculation
ROA = 100 × (Net earnings (loss) attributable to The Estée Lauder Companies Inc.Q4 2023 + Net earnings (loss) attributable to The Estée Lauder Companies Inc.Q3 2023 + Net earnings (loss) attributable to The Estée Lauder Companies Inc.Q2 2023 + Net earnings (loss) attributable to The Estée Lauder Companies Inc.Q1 2023) ÷ Total assets
= 100 × (-33 + 156 + 394 + 489) ÷ 23,415 = 4.30%

2 Click competitor name to see calculations.

Profitability ratio Description The company
ROA A profitability ratio calculated as net income divided by total assets. Estée Lauder Cos. Inc. ROA deteriorated from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.