Analysis of Long-term (Investment) Activity Ratios
Quarterly Data
Activity ratios measure how efficiently a company performs day-to-day tasks, such us the collection of receivables and management of inventory.
Long-term Activity Ratios (Summary)
Estée Lauder Cos. Inc., long-term (investment) activity ratios (quarterly data)
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).
| Long-term activity ratio | Description | The company |
|---|---|---|
| Net fixed asset turnover | An activity ratio calculated as total revenue divided by net fixed assets. | Estée Lauder Cos. Inc. net fixed asset turnover ratio deteriorated from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023. |
| Net fixed asset turnover (including operating lease, right-of-use asset) | An activity ratio calculated as total revenue divided by net fixed assets (including operating lease, right-of-use asset). | Estée Lauder Cos. Inc. net fixed asset turnover ratio (with operating lease, right-of-use asset) deteriorated from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023. |
| Total asset turnover | An activity ratio calculated as total revenue divided by total assets. | Estée Lauder Cos. Inc. total asset turnover ratio deteriorated from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023. |
| Equity turnover | An activity ratio calculated as total revenue divided by shareholders’ equity. | Estée Lauder Cos. Inc. equity turnover ratio deteriorated from Q2 2023 to Q3 2023 but then improved from Q3 2023 to Q4 2023 exceeding Q2 2023 level. |
Net Fixed Asset Turnover
Estée Lauder Cos. Inc., net fixed asset turnover calculation (quarterly data)
| 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 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) | |||||||
| Property, plant and equipment, net | 3,179) | 3,026) | 2,908) | 2,654) | 2,650) | 2,493) | 2,451) | 2,358) | 2,280) | 2,106) | 2,142) | 2,077) | 2,055) | 2,092) | 2,086) | 2,018) | 2,068) | 1,891) | 1,859) | 1,838) | 1,823) | 1,726) | 1,728) | 1,695) | |||||||
| Long-term Activity Ratio | |||||||||||||||||||||||||||||||
| Net fixed asset turnover1 | 5.00 | 5.24 | 5.62 | 6.51 | 6.69 | 7.27 | 7.23 | 7.23 | 7.11 | 6.98 | 6.62 | 6.72 | 6.96 | 7.39 | 7.60 | 7.55 | 7.19 | 7.70 | 7.64 | 7.58 | 7.51 | — | — | — | |||||||
| Benchmarks | |||||||||||||||||||||||||||||||
| Net Fixed Asset Turnover, Competitors2 | |||||||||||||||||||||||||||||||
| Procter & Gamble Co. | 3.74 | 3.75 | 3.79 | 3.91 | 3.78 | 3.73 | 3.67 | 3.61 | 3.51 | 3.55 | 3.45 | 3.47 | 3.43 | 3.44 | 3.28 | 3.29 | 3.18 | — | — | — | — | — | — | — | |||||||
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 fixed asset turnover
= (Net salesQ4 2023
+ Net salesQ3 2023
+ Net salesQ2 2023
+ Net salesQ1 2023)
÷ Property, plant and equipment, net
= (3,609 + 3,751 + 4,620 + 3,930)
÷ 3,179 = 5.00
2 Click competitor name to see calculations.
| Long-term activity ratio | Description | The company |
|---|---|---|
| Net fixed asset turnover | An activity ratio calculated as total revenue divided by net fixed assets. | Estée Lauder Cos. Inc. net fixed asset turnover ratio deteriorated from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023. |
Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset)
Estée Lauder Cos. Inc., net fixed asset turnover (including operating lease, right-of-use asset) calculation (quarterly data)
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 fixed asset turnover (including operating lease, right-of-use asset)
= (Net salesQ4 2023
+ Net salesQ3 2023
+ Net salesQ2 2023
+ Net salesQ1 2023)
÷ Property, plant and equipment, net (including operating lease, right-of-use asset)
= (3,609 + 3,751 + 4,620 + 3,930)
÷ 4,976 = 3.20
| Long-term activity ratio | Description | The company |
|---|---|---|
| Net fixed asset turnover (including operating lease, right-of-use asset) | An activity ratio calculated as total revenue divided by net fixed assets (including operating lease, right-of-use asset). | Estée Lauder Cos. Inc. net fixed asset turnover ratio (with operating lease, right-of-use asset) deteriorated from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023. |
Total Asset Turnover
Estée Lauder Cos. Inc., total asset turnover calculation (quarterly data)
| 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 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) | |||||||
| 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) | |||||||
| Long-term Activity Ratio | |||||||||||||||||||||||||||||||
| Total asset turnover1 | 0.68 | 0.70 | 0.79 | 0.86 | 0.85 | 0.85 | 0.80 | 0.79 | 0.74 | 0.74 | 0.72 | 0.78 | 0.80 | 0.84 | 0.88 | 0.99 | 1.13 | 1.13 | 1.12 | 1.11 | 1.09 | — | — | — | |||||||
| Benchmarks | |||||||||||||||||||||||||||||||
| Total Asset Turnover, Competitors2 | |||||||||||||||||||||||||||||||
| Procter & Gamble Co. | 0.68 | 0.68 | 0.68 | 0.69 | 0.68 | 0.66 | 0.65 | 0.64 | 0.64 | 0.64 | 0.62 | 0.60 | 0.59 | 0.59 | 0.62 | 0.60 | 0.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
Total asset turnover
= (Net salesQ4 2023
+ Net salesQ3 2023
+ Net salesQ2 2023
+ Net salesQ1 2023)
÷ Total assets
= (3,609 + 3,751 + 4,620 + 3,930)
÷ 23,415 = 0.68
2 Click competitor name to see calculations.
| Long-term activity ratio | Description | The company |
|---|---|---|
| Total asset turnover | An activity ratio calculated as total revenue divided by total assets. | Estée Lauder Cos. Inc. total asset turnover ratio deteriorated from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023. |
Equity Turnover
Estée Lauder Cos. Inc., equity turnover calculation (quarterly data)
| 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 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) | |||||||
| 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) | |||||||
| Long-term Activity Ratio | |||||||||||||||||||||||||||||||
| Equity turnover1 | 2.85 | 2.70 | 2.77 | 3.13 | 3.17 | 2.95 | 2.85 | 2.80 | 2.68 | 2.66 | 2.62 | 3.14 | 3.63 | 3.57 | 3.47 | 3.36 | 3.39 | 3.18 | 3.30 | 3.16 | 2.92 | — | — | — | |||||||
| Benchmarks | |||||||||||||||||||||||||||||||
| Equity Turnover, Competitors2 | |||||||||||||||||||||||||||||||
| Procter & Gamble Co. | 1.75 | 1.79 | 1.81 | 1.83 | 1.72 | 1.75 | 1.76 | 1.67 | 1.64 | 1.61 | 1.54 | 1.50 | 1.53 | 1.54 | 1.53 | 1.48 | 1.43 | — | — | — | — | — | — | — | |||||||
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
Equity turnover
= (Net salesQ4 2023
+ Net salesQ3 2023
+ Net salesQ2 2023
+ Net salesQ1 2023)
÷ Stockholders’ equity, The Estée Lauder Companies Inc.
= (3,609 + 3,751 + 4,620 + 3,930)
÷ 5,585 = 2.85
2 Click competitor name to see calculations.
| Long-term activity ratio | Description | The company |
|---|---|---|
| Equity turnover | An activity ratio calculated as total revenue divided by shareholders’ equity. | Estée Lauder Cos. Inc. equity turnover ratio deteriorated from Q2 2023 to Q3 2023 but then improved from Q3 2023 to Q4 2023 exceeding Q2 2023 level. |