Analysis of Short-term (Operating) 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.
Short-term Activity Ratios (Summary)
Estée Lauder Cos. Inc., short-term (operating) 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).
| Short-term activity ratio | Description | The company |
|---|---|---|
| Inventory turnover | An activity ratio calculated as cost of goods sold divided by inventory. | Estée Lauder Cos. Inc. inventory turnover ratio improved from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023. |
| Receivables turnover | An activity ratio equal to revenue divided by receivables. | Estée Lauder Cos. Inc. receivables turnover ratio deteriorated from Q2 2023 to Q3 2023 but then improved from Q3 2023 to Q4 2023 exceeding Q2 2023 level. |
| Payables turnover | An activity ratio calculated as cost of goods sold divided by payables. | Estée Lauder Cos. Inc. payables turnover ratio increased from Q2 2023 to Q3 2023 but then decreased significantly from Q3 2023 to Q4 2023. |
| Working capital turnover | An activity ratio calculated as revenue divided by working capital. | Estée Lauder Cos. Inc. working capital turnover ratio improved from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023. |
| Short-term activity ratio | Description | The company |
|---|---|---|
| Average inventory processing period | An activity ratio equal to the number of days in the period divided by inventory turnover over the period. | Estée Lauder Cos. Inc. number of days of inventory outstanding improved from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023. |
| Average receivable collection period | An activity ratio equal to the number of days in the period divided by receivables turnover. | Estée Lauder Cos. Inc. number of days of receivables outstanding deteriorated from Q2 2023 to Q3 2023 but then improved from Q3 2023 to Q4 2023 exceeding Q2 2023 level. |
| Operating cycle | Equal to average inventory processing period plus average receivables collection period. | Estée Lauder Cos. Inc. operating cycle improved from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023. |
| Average payables payment period | An estimate of the average number of days it takes a company to pay its suppliers; equal to the number of days in the period divided by payables turnover ratio for the period. | Estée Lauder Cos. Inc. number of days of payables outstanding decreased from Q2 2023 to Q3 2023 but then increased from Q3 2023 to Q4 2023 exceeding Q2 2023 level. |
| Cash conversion cycle | A financial metric that measures the length of time required for a company to convert cash invested in its operations to cash received as a result of its operations; equal to average inventory processing period plus average receivables collection period minus average payables payment period. | Estée Lauder Cos. Inc. cash conversion cycle improved from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023. |
Inventory Turnover
Estée Lauder Cos. Inc., inventory 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) | |||||||||||||||||||||||||||||||
| Cost of sales | 1,163) | 1,159) | 1,219) | 1,023) | 1,031) | 994) | 1,223) | 1,057) | 986) | 939) | 1,084) | 825) | 767) | 836) | 1,041) | 908) | 835) | 819) | 910) | 823) | 697) | 683) | 753) | 711) | |||||||
| Inventory and promotional merchandise | 2,979) | 3,097) | 3,069) | 3,018) | 2,920) | 2,830) | 2,612) | 2,633) | 2,505) | 2,134) | 2,116) | 2,204) | 2,062) | 2,087) | 2,058) | 2,055) | 2,006) | 1,814) | 1,651) | 1,681) | 1,618) | 1,533) | 1,445) | 1,518) | |||||||
| Short-term Activity Ratio | |||||||||||||||||||||||||||||||
| Inventory turnover1 | 1.53 | 1.43 | 1.39 | 1.42 | 1.47 | 1.51 | 1.61 | 1.54 | 1.53 | 1.69 | 1.66 | 1.57 | 1.72 | 1.73 | 1.75 | 1.69 | 1.69 | 1.79 | 1.89 | 1.76 | 1.76 | — | — | — | |||||||
| Benchmarks | |||||||||||||||||||||||||||||||
| Inventory Turnover, Competitors2 | |||||||||||||||||||||||||||||||
| Procter & Gamble Co. | 6.05 | 5.74 | 5.69 | 5.62 | 6.09 | 5.79 | 5.96 | 6.08 | 6.20 | 6.04 | 6.05 | 6.25 | 6.41 | 6.61 | 6.33 | 6.41 | 6.93 | 6.51 | 6.58 | 6.66 | 7.23 | — | — | — | |||||||
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
Inventory turnover
= (Cost of salesQ4 2023
+ Cost of salesQ3 2023
+ Cost of salesQ2 2023
+ Cost of salesQ1 2023)
÷ Inventory and promotional merchandise
= (1,163 + 1,159 + 1,219 + 1,023)
÷ 2,979 = 1.53
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Inventory turnover | An activity ratio calculated as cost of goods sold divided by inventory. | Estée Lauder Cos. Inc. inventory turnover ratio improved from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023. |
Receivables Turnover
Estée Lauder Cos. Inc., receivables 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) | |||||||
| Accounts receivable, net | 1,452) | 1,904) | 1,932) | 2,156) | 1,629) | 2,209) | 2,079) | 2,265) | 1,702) | 1,735) | 1,972) | 1,812) | 1,194) | 1,846) | 2,225) | 2,294) | 1,831) | 2,036) | 2,000) | 2,214) | 1,487) | 1,761) | 1,699) | 1,799) | |||||||
| Short-term Activity Ratio | |||||||||||||||||||||||||||||||
| Receivables turnover1 | 10.96 | 8.33 | 8.47 | 8.01 | 10.89 | 8.20 | 8.53 | 7.53 | 9.53 | 8.48 | 7.20 | 7.70 | 11.97 | 8.37 | 7.12 | 6.64 | 8.12 | 7.16 | 7.10 | 6.29 | 9.20 | — | — | — | |||||||
| Benchmarks | |||||||||||||||||||||||||||||||
| Receivables Turnover, Competitors2 | |||||||||||||||||||||||||||||||
| Procter & Gamble Co. | 14.99 | 14.80 | 13.92 | 14.07 | 15.59 | 14.44 | 14.95 | 13.62 | 16.11 | 15.40 | 15.35 | 14.37 | 16.98 | 15.16 | 13.39 | 13.38 | 13.67 | 12.91 | 13.24 | 13.28 | 14.26 | — | — | — | |||||||
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
Receivables turnover
= (Net salesQ4 2023
+ Net salesQ3 2023
+ Net salesQ2 2023
+ Net salesQ1 2023)
÷ Accounts receivable, net
= (3,609 + 3,751 + 4,620 + 3,930)
÷ 1,452 = 10.96
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Receivables turnover | An activity ratio equal to revenue divided by receivables. | Estée Lauder Cos. Inc. receivables turnover ratio deteriorated from Q2 2023 to Q3 2023 but then improved from Q3 2023 to Q4 2023 exceeding Q2 2023 level. |
Payables Turnover
Estée Lauder Cos. Inc., payables 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) | |||||||||||||||||||||||||||||||
| Cost of sales | 1,163) | 1,159) | 1,219) | 1,023) | 1,031) | 994) | 1,223) | 1,057) | 986) | 939) | 1,084) | 825) | 767) | 836) | 1,041) | 908) | 835) | 819) | 910) | 823) | 697) | 683) | 753) | 711) | |||||||
| Accounts payable | 1,670) | 1,520) | 1,507) | 1,392) | 1,822) | 1,470) | 1,639) | 1,485) | 1,692) | 1,277) | 1,299) | 1,178) | 1,177) | 1,162) | 1,137) | 1,071) | 1,490) | 1,068) | 995) | 913) | 1,182) | 884) | 738) | 679) | |||||||
| Short-term Activity Ratio | |||||||||||||||||||||||||||||||
| Payables turnover1 | 2.73 | 2.92 | 2.83 | 3.07 | 2.36 | 2.90 | 2.57 | 2.74 | 2.27 | 2.83 | 2.70 | 2.94 | 3.02 | 3.12 | 3.17 | 3.24 | 2.27 | 3.04 | 3.13 | 3.24 | 2.41 | — | — | — | |||||||
| Benchmarks | |||||||||||||||||||||||||||||||
| Payables Turnover, Competitors2 | |||||||||||||||||||||||||||||||
| Procter & Gamble Co. | 2.93 | 3.11 | 3.03 | 2.87 | 2.83 | 2.90 | 2.81 | 2.70 | 2.70 | 2.99 | 3.00 | 2.99 | 2.92 | 3.37 | 3.24 | 3.20 | 3.09 | 3.42 | 3.39 | 3.37 | 3.31 | — | — | — | |||||||
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
Payables turnover
= (Cost of salesQ4 2023
+ Cost of salesQ3 2023
+ Cost of salesQ2 2023
+ Cost of salesQ1 2023)
÷ Accounts payable
= (1,163 + 1,159 + 1,219 + 1,023)
÷ 1,670 = 2.73
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Payables turnover | An activity ratio calculated as cost of goods sold divided by payables. | Estée Lauder Cos. Inc. payables turnover ratio increased from Q2 2023 to Q3 2023 but then decreased significantly from Q3 2023 to Q4 2023. |
Working Capital Turnover
Estée Lauder Cos. Inc., working capital 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) | |||||||||||||||||||||||||||||||
| Current assets | 9,139) | 11,247) | 9,367) | 8,866) | 9,298) | 9,500) | 9,955) | 9,486) | 9,768) | 10,997) | 10,291) | 8,795) | 8,892) | 9,233) | 8,348) | 7,022) | 7,212) | 7,160) | 6,440) | 6,249) | 6,168) | 6,169) | 5,975) | 5,507) | |||||||
| Less: Current liabilities | 6,240) | 7,700) | 5,655) | 5,271) | 5,815) | 5,414) | 5,762) | 5,319) | 5,298) | 5,197) | 5,420) | 4,744) | 5,179) | 5,681) | 4,953) | 4,590) | 4,605) | 4,231) | 3,776) | 3,563) | 3,310) | 3,388) | 3,403) | 3,142) | |||||||
| Working capital | 2,899) | 3,547) | 3,712) | 3,595) | 3,483) | 4,086) | 4,193) | 4,167) | 4,470) | 5,800) | 4,871) | 4,051) | 3,713) | 3,552) | 3,395) | 2,432) | 2,607) | 2,929) | 2,664) | 2,686) | 2,858) | 2,781) | 2,572) | 2,365) | |||||||
| 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) | |||||||
| Short-term Activity Ratio | |||||||||||||||||||||||||||||||
| Working capital turnover1 | 5.49 | 4.47 | 4.41 | 4.81 | 5.09 | 4.43 | 4.23 | 4.09 | 3.63 | 2.54 | 2.91 | 3.45 | 3.85 | 4.35 | 4.67 | 6.26 | 5.70 | 4.97 | 5.33 | 5.19 | 4.79 | — | — | — | |||||||
| Benchmarks | |||||||||||||||||||||||||||||||
| Working Capital Turnover, Competitors2 | |||||||||||||||||||||||||||||||
| Procter & Gamble Co. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
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
Working capital turnover
= (Net salesQ4 2023
+ Net salesQ3 2023
+ Net salesQ2 2023
+ Net salesQ1 2023)
÷ Working capital
= (3,609 + 3,751 + 4,620 + 3,930)
÷ 2,899 = 5.49
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Working capital turnover | An activity ratio calculated as revenue divided by working capital. | Estée Lauder Cos. Inc. working capital turnover ratio improved from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023. |
Average Inventory Processing Period
Estée Lauder Cos. Inc., average inventory processing period 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 | |||||||||||||||||||||||||||||||
| Inventory turnover | 1.53 | 1.43 | 1.39 | 1.42 | 1.47 | 1.51 | 1.61 | 1.54 | 1.53 | 1.69 | 1.66 | 1.57 | 1.72 | 1.73 | 1.75 | 1.69 | 1.69 | 1.79 | 1.89 | 1.76 | 1.76 | — | — | — | |||||||
| Short-term Activity Ratio (no. days) | |||||||||||||||||||||||||||||||
| Average inventory processing period1 | 238 | 255 | 263 | 258 | 248 | 242 | 227 | 236 | 238 | 215 | 220 | 232 | 212 | 210 | 208 | 216 | 216 | 204 | 194 | 208 | 208 | — | — | — | |||||||
| Benchmarks (no. days) | |||||||||||||||||||||||||||||||
| Average Inventory Processing Period, Competitors2 | |||||||||||||||||||||||||||||||
| Procter & Gamble Co. | 60 | 64 | 64 | 65 | 60 | 63 | 61 | 60 | 59 | 60 | 60 | 58 | 57 | 55 | 58 | 57 | 53 | 56 | 55 | 55 | 50 | — | — | — | |||||||
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
Average inventory processing period = 365 ÷ Inventory turnover
= 365 ÷ 1.53 = 238
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Average inventory processing period | An activity ratio equal to the number of days in the period divided by inventory turnover over the period. | Estée Lauder Cos. Inc. number of days of inventory outstanding improved from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023. |
Average Receivable Collection Period
Estée Lauder Cos. Inc., average receivable collection period 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 | |||||||||||||||||||||||||||||||
| Receivables turnover | 10.96 | 8.33 | 8.47 | 8.01 | 10.89 | 8.20 | 8.53 | 7.53 | 9.53 | 8.48 | 7.20 | 7.70 | 11.97 | 8.37 | 7.12 | 6.64 | 8.12 | 7.16 | 7.10 | 6.29 | 9.20 | — | — | — | |||||||
| Short-term Activity Ratio (no. days) | |||||||||||||||||||||||||||||||
| Average receivable collection period1 | 33 | 44 | 43 | 46 | 34 | 45 | 43 | 49 | 38 | 43 | 51 | 47 | 30 | 44 | 51 | 55 | 45 | 51 | 51 | 58 | 40 | — | — | — | |||||||
| Benchmarks (no. days) | |||||||||||||||||||||||||||||||
| Average Receivable Collection Period, Competitors2 | |||||||||||||||||||||||||||||||
| Procter & Gamble Co. | 24 | 25 | 26 | 26 | 23 | 25 | 24 | 27 | 23 | 24 | 24 | 25 | 21 | 24 | 27 | 27 | 27 | 28 | 28 | 27 | 26 | — | — | — | |||||||
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
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 10.96 = 33
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Average receivable collection period | An activity ratio equal to the number of days in the period divided by receivables turnover. | Estée Lauder Cos. Inc. number of days of receivables outstanding deteriorated from Q2 2023 to Q3 2023 but then improved from Q3 2023 to Q4 2023 exceeding Q2 2023 level. |
Operating Cycle
Estée Lauder Cos. Inc., operating cycle calculation (quarterly data)
No. days
| 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 | |||||||||||||||||||||||||||||||
| Average inventory processing period | 238 | 255 | 263 | 258 | 248 | 242 | 227 | 236 | 238 | 215 | 220 | 232 | 212 | 210 | 208 | 216 | 216 | 204 | 194 | 208 | 208 | — | — | — | |||||||
| Average receivable collection period | 33 | 44 | 43 | 46 | 34 | 45 | 43 | 49 | 38 | 43 | 51 | 47 | 30 | 44 | 51 | 55 | 45 | 51 | 51 | 58 | 40 | — | — | — | |||||||
| Short-term Activity Ratio | |||||||||||||||||||||||||||||||
| Operating cycle1 | 271 | 299 | 306 | 304 | 282 | 287 | 270 | 285 | 276 | 258 | 271 | 279 | 242 | 254 | 259 | 271 | 261 | 255 | 245 | 266 | 248 | — | — | — | |||||||
| Benchmarks | |||||||||||||||||||||||||||||||
| Operating Cycle, Competitors2 | |||||||||||||||||||||||||||||||
| Procter & Gamble Co. | 84 | 89 | 90 | 91 | 83 | 88 | 85 | 87 | 82 | 84 | 84 | 83 | 78 | 79 | 85 | 84 | 80 | 84 | 83 | 82 | 76 | — | — | — | |||||||
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 cycle = Average inventory processing period + Average receivable collection period
= 238 + 33 = 271
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Operating cycle | Equal to average inventory processing period plus average receivables collection period. | Estée Lauder Cos. Inc. operating cycle improved from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023. |
Average Payables Payment Period
Estée Lauder Cos. Inc., average payables payment period 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 | |||||||||||||||||||||||||||||||
| Payables turnover | 2.73 | 2.92 | 2.83 | 3.07 | 2.36 | 2.90 | 2.57 | 2.74 | 2.27 | 2.83 | 2.70 | 2.94 | 3.02 | 3.12 | 3.17 | 3.24 | 2.27 | 3.04 | 3.13 | 3.24 | 2.41 | — | — | — | |||||||
| Short-term Activity Ratio (no. days) | |||||||||||||||||||||||||||||||
| Average payables payment period1 | 134 | 125 | 129 | 119 | 154 | 126 | 142 | 133 | 161 | 129 | 135 | 124 | 121 | 117 | 115 | 113 | 161 | 120 | 117 | 113 | 152 | — | — | — | |||||||
| Benchmarks (no. days) | |||||||||||||||||||||||||||||||
| Average Payables Payment Period, Competitors2 | |||||||||||||||||||||||||||||||
| Procter & Gamble Co. | 125 | 117 | 120 | 127 | 129 | 126 | 130 | 135 | 135 | 122 | 122 | 122 | 125 | 108 | 113 | 114 | 118 | 107 | 108 | 108 | 110 | — | — | — | |||||||
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
Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ 2.73 = 134
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Average payables payment period | An estimate of the average number of days it takes a company to pay its suppliers; equal to the number of days in the period divided by payables turnover ratio for the period. | Estée Lauder Cos. Inc. number of days of payables outstanding decreased from Q2 2023 to Q3 2023 but then increased from Q3 2023 to Q4 2023 exceeding Q2 2023 level. |
Cash Conversion Cycle
Estée Lauder Cos. Inc., cash conversion cycle calculation (quarterly data)
No. days
| 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 | |||||||||||||||||||||||||||||||
| Average inventory processing period | 238 | 255 | 263 | 258 | 248 | 242 | 227 | 236 | 238 | 215 | 220 | 232 | 212 | 210 | 208 | 216 | 216 | 204 | 194 | 208 | 208 | — | — | — | |||||||
| Average receivable collection period | 33 | 44 | 43 | 46 | 34 | 45 | 43 | 49 | 38 | 43 | 51 | 47 | 30 | 44 | 51 | 55 | 45 | 51 | 51 | 58 | 40 | — | — | — | |||||||
| Average payables payment period | 134 | 125 | 129 | 119 | 154 | 126 | 142 | 133 | 161 | 129 | 135 | 124 | 121 | 117 | 115 | 113 | 161 | 120 | 117 | 113 | 152 | — | — | — | |||||||
| Short-term Activity Ratio | |||||||||||||||||||||||||||||||
| Cash conversion cycle1 | 137 | 174 | 177 | 185 | 128 | 161 | 128 | 152 | 115 | 129 | 136 | 155 | 121 | 137 | 144 | 158 | 100 | 135 | 128 | 153 | 96 | — | — | — | |||||||
| Benchmarks | |||||||||||||||||||||||||||||||
| Cash Conversion Cycle, Competitors2 | |||||||||||||||||||||||||||||||
| Procter & Gamble Co. | -41 | -28 | -30 | -36 | -46 | -38 | -45 | -48 | -53 | -38 | -38 | -39 | -47 | -29 | -28 | -30 | -38 | -23 | -25 | -26 | -34 | — | — | — | |||||||
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
Cash conversion cycle = Average inventory processing period + Average receivable collection period – Average payables payment period
= 238 + 33 – 134 = 137
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Cash conversion cycle | A financial metric that measures the length of time required for a company to convert cash invested in its operations to cash received as a result of its operations; equal to average inventory processing period plus average receivables collection period minus average payables payment period. | Estée Lauder Cos. Inc. cash conversion cycle improved from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023. |