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)
Colgate-Palmolive Co., long-term (investment) 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).
| Long-term activity ratio | Description | The company |
|---|---|---|
| Net fixed asset turnover | An activity ratio calculated as total revenue divided by net fixed assets. | Colgate-Palmolive Co. net fixed asset turnover ratio improved from Q4 2022 to Q1 2023 and from Q1 2023 to Q2 2023. |
| Total asset turnover | An activity ratio calculated as total revenue divided by total assets. | Colgate-Palmolive Co. total asset turnover ratio deteriorated from Q4 2022 to Q1 2023 but then improved from Q1 2023 to Q2 2023 exceeding Q4 2022 level. |
Net Fixed Asset Turnover
Colgate-Palmolive Co., 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 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||||||
| Property, plant and equipment, net | 4,431) | 4,363) | 4,307) | 4,123) | 3,765) | 3,752) | 3,730) | 3,633) | 3,665) | 3,609) | 3,716) | 3,506) | 3,483) | 3,487) | 3,750) | 3,689) | 3,793) | 3,821) | 3,881) | 3,871) | 3,908) | 4,087) | |||||||
| Long-term Activity Ratio | |||||||||||||||||||||||||||||
| Net fixed asset turnover1 | 4.21 | 4.20 | 4.17 | 4.30 | 4.70 | 4.66 | 4.67 | 4.77 | 4.66 | 4.63 | 4.43 | 4.61 | 4.58 | 4.56 | 4.18 | 4.20 | 4.06 | 4.04 | 4.01 | — | — | — | |||||||
| Benchmarks | |||||||||||||||||||||||||||||
| Net Fixed Asset Turnover, Competitors2 | |||||||||||||||||||||||||||||
| Procter & Gamble Co. | 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 | 3.20 | 3.21 | 3.25 | 3.24 | — | — | — | |||||||
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
Net fixed asset turnover
= (Net salesQ2 2023
+ Net salesQ1 2023
+ Net salesQ4 2022
+ Net salesQ3 2022)
÷ Property, plant and equipment, net
= (4,822 + 4,770 + 4,629 + 4,455)
÷ 4,431 = 4.21
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. | Colgate-Palmolive Co. net fixed asset turnover ratio improved from Q4 2022 to Q1 2023 and from Q1 2023 to Q2 2023. |
Total Asset Turnover
Colgate-Palmolive Co., 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 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||||||
| Total assets | 16,227) | 16,173) | 15,731) | 16,288) | 15,711) | 15,723) | 15,040) | 15,880) | 15,999) | 15,801) | 15,920) | 15,466) | 15,141) | 15,070) | 15,034) | 15,026) | 13,151) | 12,883) | 12,161) | 12,571) | 12,650) | 13,144) | |||||||
| Long-term Activity Ratio | |||||||||||||||||||||||||||||
| Total asset turnover1 | 1.15 | 1.13 | 1.14 | 1.09 | 1.13 | 1.11 | 1.16 | 1.09 | 1.07 | 1.06 | 1.03 | 1.05 | 1.05 | 1.06 | 1.04 | 1.03 | 1.17 | 1.20 | 1.28 | — | — | — | |||||||
| Benchmarks | |||||||||||||||||||||||||||||
| Total Asset Turnover, Competitors2 | |||||||||||||||||||||||||||||
| Procter & Gamble Co. | 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 | 0.55 | 0.54 | 0.56 | 0.56 | — | — | — | |||||||
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
Total asset turnover
= (Net salesQ2 2023
+ Net salesQ1 2023
+ Net salesQ4 2022
+ Net salesQ3 2022)
÷ Total assets
= (4,822 + 4,770 + 4,629 + 4,455)
÷ 16,227 = 1.15
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. | Colgate-Palmolive Co. total asset turnover ratio deteriorated from Q4 2022 to Q1 2023 but then improved from Q1 2023 to Q2 2023 exceeding Q4 2022 level. |
Equity Turnover
Colgate-Palmolive Co., 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 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||||||
| Total Colgate-Palmolive Company shareholders’ equity | (64) | (6) | 401) | 622) | 168) | 321) | 609) | 591) | 464) | 262) | 743) | 653) | 268) | (113) | 117) | (324) | (347) | (552) | (102) | (430) | (523) | (249) | |||||||
| Long-term Activity Ratio | |||||||||||||||||||||||||||||
| Equity turnover1 | — | — | 44.81 | 28.52 | 105.36 | 54.44 | 28.61 | 29.34 | 36.81 | 63.81 | 22.17 | 24.75 | 59.47 | — | 134.13 | — | — | — | — | — | — | — | |||||||
| Benchmarks | |||||||||||||||||||||||||||||
| Equity Turnover, Competitors2 | |||||||||||||||||||||||||||||
| Procter & Gamble Co. | 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 | 1.22 | 1.24 | 1.28 | 1.28 | — | — | — | |||||||
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
Equity turnover
= (Net salesQ2 2023
+ Net salesQ1 2023
+ Net salesQ4 2022
+ Net salesQ3 2022)
÷ Total Colgate-Palmolive Company shareholders’ equity
= (4,822 + 4,770 + 4,629 + 4,455)
÷ -64 = —
2 Click competitor name to see calculations.