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)
Colgate-Palmolive Co., short-term (operating) activity ratios (quarterly data)
Based on: 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31).
| Short-term activity ratio | Description | The company |
|---|---|---|
| Inventory turnover | An activity ratio calculated as cost of goods sold divided by inventory. | Colgate-Palmolive Co. inventory turnover ratio improved from Q4 2022 to Q1 2023 and from Q1 2023 to Q2 2023. |
| Receivables turnover | An activity ratio equal to revenue divided by receivables. | Colgate-Palmolive Co. receivables turnover ratio deteriorated from Q4 2022 to Q1 2023 and from Q1 2023 to Q2 2023. |
| Payables turnover | An activity ratio calculated as cost of goods sold divided by payables. | Colgate-Palmolive Co. payables turnover ratio decreased from Q4 2022 to Q1 2023 but then increased from Q1 2023 to Q2 2023 exceeding Q4 2022 level. |
| Working capital turnover | An activity ratio calculated as revenue divided by working capital. | Colgate-Palmolive Co. working capital turnover ratio improved from Q4 2022 to Q1 2023 and from Q1 2023 to Q2 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. | Colgate-Palmolive Co. number of days of inventory outstanding improved from Q4 2022 to Q1 2023 and from Q1 2023 to Q2 2023. |
| Average receivable collection period | An activity ratio equal to the number of days in the period divided by receivables turnover. | |
| Operating cycle | Equal to average inventory processing period plus average receivables collection period. | |
| 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. | Colgate-Palmolive Co. number of days of payables outstanding increased from Q4 2022 to Q1 2023 but then decreased significantly from Q1 2023 to Q2 2023. |
| 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. | Colgate-Palmolive Co. cash conversion cycle improved from Q4 2022 to Q1 2023 and from Q1 2023 to Q2 2023. |
Inventory Turnover
Colgate-Palmolive Co., 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 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | |||||||||||||||||||||||||||||
| Cost of sales | 2,035) | 2,058) | 2,055) | 1,907) | 1,930) | 1,827) | 1,844) | 1,791) | 1,704) | 1,707) | 1,681) | 1,613) | 1,528) | 1,632) | 1,601) | 1,612) | 1,558) | 1,597) | 1,558) | 1,576) | 1,585) | 1,594) | |||||||
| Inventories | 2,039) | 2,110) | 2,074) | 2,073) | 2,012) | 1,924) | 1,692) | 1,670) | 1,700) | 1,676) | 1,673) | 1,578) | 1,524) | 1,301) | 1,400) | 1,371) | 1,322) | 1,278) | 1,250) | 1,245) | 1,254) | 1,312) | |||||||
| Short-term Activity Ratio | |||||||||||||||||||||||||||||
| Inventory turnover1 | 3.95 | 3.77 | 3.72 | 3.62 | 3.67 | 3.72 | 4.16 | 4.12 | 3.94 | 3.90 | 3.86 | 4.04 | 4.18 | 4.92 | 4.55 | 4.61 | 4.76 | 4.94 | 5.05 | — | — | — | |||||||
| Benchmarks | |||||||||||||||||||||||||||||
| Inventory Turnover, Competitors2 | |||||||||||||||||||||||||||||
| Procter & Gamble Co. | 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 | — | — | — | — | — | — | — | |||||||
Based on: 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31).
1 Q2 2023 Calculation
Inventory turnover
= (Cost of salesQ2 2023
+ Cost of salesQ1 2023
+ Cost of salesQ4 2022
+ Cost of salesQ3 2022)
÷ Inventories
= (2,035 + 2,058 + 2,055 + 1,907)
÷ 2,039 = 3.95
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. | Colgate-Palmolive Co. inventory turnover ratio improved from Q4 2022 to Q1 2023 and from Q1 2023 to Q2 2023. |
Receivables Turnover
Colgate-Palmolive Co., 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 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | |||||||||||||||||||||||||||||
| Net sales | 4,822) | 4,770) | 4,629) | 4,455) | 4,484) | 4,399) | 4,403) | 4,414) | 4,260) | 4,344) | 4,324) | 4,153) | 3,897) | 4,097) | 4,015) | 3,928) | 3,866) | 3,884) | 3,811) | 3,845) | 3,886) | 4,002) | |||||||
| Receivables, net of allowances | 1,656) | 1,590) | 1,504) | 1,425) | 1,490) | 1,532) | 1,297) | 1,424) | 1,443) | 1,402) | 1,264) | 1,292) | 1,231) | 1,551) | 1,440) | 1,495) | 1,590) | 1,547) | 1,400) | 1,532) | 1,545) | 1,644) | |||||||
| Short-term Activity Ratio | |||||||||||||||||||||||||||||
| Receivables turnover1 | 11.28 | 11.53 | 11.95 | 12.45 | 11.88 | 11.41 | 13.43 | 12.18 | 11.84 | 11.92 | 13.03 | 12.51 | 12.95 | 10.26 | 10.90 | 10.36 | 9.69 | 9.97 | 11.10 | — | — | — | |||||||
| Benchmarks | |||||||||||||||||||||||||||||
| Receivables Turnover, Competitors2 | |||||||||||||||||||||||||||||
| Procter & Gamble Co. | 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 | — | — | — | — | — | — | — | |||||||
Based on: 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31).
1 Q2 2023 Calculation
Receivables turnover
= (Net salesQ2 2023
+ Net salesQ1 2023
+ Net salesQ4 2022
+ Net salesQ3 2022)
÷ Receivables, net of allowances
= (4,822 + 4,770 + 4,629 + 4,455)
÷ 1,656 = 11.28
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. | Colgate-Palmolive Co. receivables turnover ratio deteriorated from Q4 2022 to Q1 2023 and from Q1 2023 to Q2 2023. |
Payables Turnover
Colgate-Palmolive Co., 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 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | |||||||||||||||||||||||||||||
| Cost of sales | 2,035) | 2,058) | 2,055) | 1,907) | 1,930) | 1,827) | 1,844) | 1,791) | 1,704) | 1,707) | 1,681) | 1,613) | 1,528) | 1,632) | 1,601) | 1,612) | 1,558) | 1,597) | 1,558) | 1,576) | 1,585) | 1,594) | |||||||
| Accounts payable | 1,544) | 1,609) | 1,551) | 1,541) | 1,507) | 1,582) | 1,479) | 1,258) | 1,272) | 1,306) | 1,393) | 1,225) | 1,189) | 1,216) | 1,237) | 1,188) | 1,209) | 1,215) | 1,222) | 1,158) | 1,121) | 1,209) | |||||||
| Short-term Activity Ratio | |||||||||||||||||||||||||||||
| Payables turnover1 | 5.22 | 4.94 | 4.98 | 4.87 | 4.91 | 4.53 | 4.76 | 5.47 | 5.27 | 5.00 | 4.63 | 5.20 | 5.36 | 5.27 | 5.15 | 5.32 | 5.20 | 5.20 | 5.17 | — | — | — | |||||||
| Benchmarks | |||||||||||||||||||||||||||||
| Payables Turnover, Competitors2 | |||||||||||||||||||||||||||||
| Procter & Gamble Co. | 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 | — | — | — | — | — | — | — | |||||||
Based on: 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31).
1 Q2 2023 Calculation
Payables turnover
= (Cost of salesQ2 2023
+ Cost of salesQ1 2023
+ Cost of salesQ4 2022
+ Cost of salesQ3 2022)
÷ Accounts payable
= (2,035 + 2,058 + 2,055 + 1,907)
÷ 1,544 = 5.22
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. | Colgate-Palmolive Co. payables turnover ratio decreased from Q4 2022 to Q1 2023 but then increased from Q1 2023 to Q2 2023 exceeding Q4 2022 level. |
Working Capital Turnover
Colgate-Palmolive Co., 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 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | |||||||||||||||||||||||||||||
| Current assets | 5,437) | 5,466) | 5,113) | 5,278) | 5,160) | 4,989) | 4,397) | 4,670) | 4,652) | 4,563) | 4,338) | 4,367) | 4,212) | 4,248) | 4,179) | 4,349) | 4,255) | 4,133) | 3,793) | 4,141) | 4,172) | 4,292) | |||||||
| Less: Current liabilities | 4,632) | 4,441) | 4,004) | 4,492) | 4,395) | 4,566) | 4,051) | 4,281) | 4,203) | 4,539) | 4,404) | 4,481) | 4,580) | 4,443) | 4,038) | 4,231) | 3,782) | 3,865) | 3,341) | 3,747) | 3,942) | 3,980) | |||||||
| Working capital | 805) | 1,025) | 1,109) | 786) | 765) | 423) | 346) | 389) | 449) | 24) | (66) | (114) | (368) | (195) | 141) | 118) | 473) | 268) | 452) | 394) | 230) | 312) | |||||||
| Net sales | 4,822) | 4,770) | 4,629) | 4,455) | 4,484) | 4,399) | 4,403) | 4,414) | 4,260) | 4,344) | 4,324) | 4,153) | 3,897) | 4,097) | 4,015) | 3,928) | 3,866) | 3,884) | 3,811) | 3,845) | 3,886) | 4,002) | |||||||
| Short-term Activity Ratio | |||||||||||||||||||||||||||||
| Working capital turnover1 | 23.20 | 17.89 | 16.20 | 22.57 | 23.14 | 41.31 | 50.35 | 44.58 | 38.04 | 696.58 | — | — | — | — | 111.30 | 131.26 | 32.57 | 57.56 | 34.39 | — | — | — | |||||||
| Benchmarks | |||||||||||||||||||||||||||||
| Working Capital Turnover, Competitors2 | |||||||||||||||||||||||||||||
| Procter & Gamble Co. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
Based on: 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31).
1 Q2 2023 Calculation
Working capital turnover
= (Net salesQ2 2023
+ Net salesQ1 2023
+ Net salesQ4 2022
+ Net salesQ3 2022)
÷ Working capital
= (4,822 + 4,770 + 4,629 + 4,455)
÷ 805 = 23.20
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. | Colgate-Palmolive Co. working capital turnover ratio improved from Q4 2022 to Q1 2023 and from Q1 2023 to Q2 2023. |
Average Inventory Processing Period
Colgate-Palmolive Co., 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 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data | |||||||||||||||||||||||||||||
| Inventory turnover | 3.95 | 3.77 | 3.72 | 3.62 | 3.67 | 3.72 | 4.16 | 4.12 | 3.94 | 3.90 | 3.86 | 4.04 | 4.18 | 4.92 | 4.55 | 4.61 | 4.76 | 4.94 | 5.05 | — | — | — | |||||||
| Short-term Activity Ratio (no. days) | |||||||||||||||||||||||||||||
| Average inventory processing period1 | 92 | 97 | 98 | 101 | 99 | 98 | 88 | 89 | 93 | 94 | 95 | 90 | 87 | 74 | 80 | 79 | 77 | 74 | 72 | — | — | — | |||||||
| Benchmarks (no. days) | |||||||||||||||||||||||||||||
| Average Inventory Processing Period, Competitors2 | |||||||||||||||||||||||||||||
| Procter & Gamble Co. | 64 | 65 | 60 | 63 | 61 | 60 | 59 | 60 | 60 | 58 | 57 | 55 | 58 | 57 | 53 | — | — | — | — | — | — | — | |||||||
Based on: 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31).
1 Q2 2023 Calculation
Average inventory processing period = 365 ÷ Inventory turnover
= 365 ÷ 3.95 = 92
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. | Colgate-Palmolive Co. number of days of inventory outstanding improved from Q4 2022 to Q1 2023 and from Q1 2023 to Q2 2023. |
Average Receivable Collection Period
Colgate-Palmolive Co., 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 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data | |||||||||||||||||||||||||||||
| Receivables turnover | 11.28 | 11.53 | 11.95 | 12.45 | 11.88 | 11.41 | 13.43 | 12.18 | 11.84 | 11.92 | 13.03 | 12.51 | 12.95 | 10.26 | 10.90 | 10.36 | 9.69 | 9.97 | 11.10 | — | — | — | |||||||
| Short-term Activity Ratio (no. days) | |||||||||||||||||||||||||||||
| Average receivable collection period1 | 32 | 32 | 31 | 29 | 31 | 32 | 27 | 30 | 31 | 31 | 28 | 29 | 28 | 36 | 33 | 35 | 38 | 37 | 33 | — | — | — | |||||||
| Benchmarks (no. days) | |||||||||||||||||||||||||||||
| Average Receivable Collection Period, Competitors2 | |||||||||||||||||||||||||||||
| Procter & Gamble Co. | 26 | 26 | 23 | 25 | 24 | 27 | 23 | 24 | 24 | 25 | 21 | 24 | 27 | 27 | 27 | — | — | — | — | — | — | — | |||||||
Based on: 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31).
1 Q2 2023 Calculation
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 11.28 = 32
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. |
Operating Cycle
Colgate-Palmolive Co., 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 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data | |||||||||||||||||||||||||||||
| Average inventory processing period | 92 | 97 | 98 | 101 | 99 | 98 | 88 | 89 | 93 | 94 | 95 | 90 | 87 | 74 | 80 | 79 | 77 | 74 | 72 | — | — | — | |||||||
| Average receivable collection period | 32 | 32 | 31 | 29 | 31 | 32 | 27 | 30 | 31 | 31 | 28 | 29 | 28 | 36 | 33 | 35 | 38 | 37 | 33 | — | — | — | |||||||
| Short-term Activity Ratio | |||||||||||||||||||||||||||||
| Operating cycle1 | 124 | 129 | 129 | 130 | 130 | 130 | 115 | 119 | 124 | 125 | 123 | 119 | 115 | 110 | 113 | 114 | 115 | 111 | 105 | — | — | — | |||||||
| Benchmarks | |||||||||||||||||||||||||||||
| Operating Cycle, Competitors2 | |||||||||||||||||||||||||||||
| Procter & Gamble Co. | 90 | 91 | 83 | 88 | 85 | 87 | 82 | 84 | 84 | 83 | 78 | 79 | 85 | 84 | 80 | — | — | — | — | — | — | — | |||||||
Based on: 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31).
1 Q2 2023 Calculation
Operating cycle = Average inventory processing period + Average receivable collection period
= 92 + 32 = 124
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. |
Average Payables Payment Period
Colgate-Palmolive Co., 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 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data | |||||||||||||||||||||||||||||
| Payables turnover | 5.22 | 4.94 | 4.98 | 4.87 | 4.91 | 4.53 | 4.76 | 5.47 | 5.27 | 5.00 | 4.63 | 5.20 | 5.36 | 5.27 | 5.15 | 5.32 | 5.20 | 5.20 | 5.17 | — | — | — | |||||||
| Short-term Activity Ratio (no. days) | |||||||||||||||||||||||||||||
| Average payables payment period1 | 70 | 74 | 73 | 75 | 74 | 81 | 77 | 67 | 69 | 73 | 79 | 70 | 68 | 69 | 71 | 69 | 70 | 70 | 71 | — | — | — | |||||||
| Benchmarks (no. days) | |||||||||||||||||||||||||||||
| Average Payables Payment Period, Competitors2 | |||||||||||||||||||||||||||||
| Procter & Gamble Co. | 120 | 127 | 129 | 126 | 130 | 135 | 135 | 122 | 122 | 122 | 125 | 108 | 113 | 114 | 118 | — | — | — | — | — | — | — | |||||||
Based on: 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31).
1 Q2 2023 Calculation
Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ 5.22 = 70
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. | Colgate-Palmolive Co. number of days of payables outstanding increased from Q4 2022 to Q1 2023 but then decreased significantly from Q1 2023 to Q2 2023. |
Cash Conversion Cycle
Colgate-Palmolive Co., 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 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data | |||||||||||||||||||||||||||||
| Average inventory processing period | 92 | 97 | 98 | 101 | 99 | 98 | 88 | 89 | 93 | 94 | 95 | 90 | 87 | 74 | 80 | 79 | 77 | 74 | 72 | — | — | — | |||||||
| Average receivable collection period | 32 | 32 | 31 | 29 | 31 | 32 | 27 | 30 | 31 | 31 | 28 | 29 | 28 | 36 | 33 | 35 | 38 | 37 | 33 | — | — | — | |||||||
| Average payables payment period | 70 | 74 | 73 | 75 | 74 | 81 | 77 | 67 | 69 | 73 | 79 | 70 | 68 | 69 | 71 | 69 | 70 | 70 | 71 | — | — | — | |||||||
| Short-term Activity Ratio | |||||||||||||||||||||||||||||
| Cash conversion cycle1 | 54 | 55 | 56 | 55 | 56 | 49 | 38 | 52 | 55 | 52 | 44 | 49 | 47 | 41 | 42 | 45 | 45 | 41 | 34 | — | — | — | |||||||
| Benchmarks | |||||||||||||||||||||||||||||
| Cash Conversion Cycle, Competitors2 | |||||||||||||||||||||||||||||
| Procter & Gamble Co. | -30 | -36 | -46 | -38 | -45 | -48 | -53 | -38 | -38 | -39 | -47 | -29 | -28 | -30 | -38 | — | — | — | — | — | — | — | |||||||
Based on: 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31).
1 Q2 2023 Calculation
Cash conversion cycle = Average inventory processing period + Average receivable collection period – Average payables payment period
= 92 + 32 – 70 = 54
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. | Colgate-Palmolive Co. cash conversion cycle improved from Q4 2022 to Q1 2023 and from Q1 2023 to Q2 2023. |