Stock Analysis on Net

Colgate-Palmolive Co. (NYSE:CL)

$22.49

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

Analysis of Long-term (Investment) Activity Ratios
Quarterly Data

Microsoft Excel

Activity ratios measure how efficiently a company performs day-to-day tasks, such us the collection of receivables and management of inventory.

Paying user area

The data is hidden behind: . Unhide it.

This is a one-time payment. There is no automatic renewal.


We accept:

Visa Mastercard American Express Maestro Discover JCB PayPal Google Pay
Visa Secure Mastercard Identity Check American Express SafeKey

Long-term Activity Ratios (Summary)

Colgate-Palmolive Co., long-term (investment) activity 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
Net fixed asset turnover
Total asset turnover
Equity turnover

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


The financial ratios exhibit various trends over the analyzed periods. Key observations and patterns are outlined below:

Net Fixed Asset Turnover
This ratio is absent in the earliest reported periods but begins at 4.01 in March 2018 and shows a generally stable to slightly increasing trend until mid-2021, peaking at 4.77 in December 2021. Subsequently, a modest decline is observed through 2022, reaching approximately 4.17 by September 2022, before stabilizing around 4.2 by mid-2023. This pattern suggests consistent efficiency in generating sales from fixed assets with some fluctuations possibly influenced by external or operational factors.
Total Asset Turnover
Starting from March 2018 at 1.28, there is a slight decline until December 2018, where it records a low around 1.03. From 2019 through 2021, the ratio fluctuates mildly between approximately 1.03 and 1.09, indicating a relatively stable utilization of total assets in revenue generation. Notably, a gradual upward trend begins in early 2022, reaching 1.15 by June 2023. This upward movement may signal improved overall asset management or better sales performance relative to asset base during recent periods.
Equity Turnover
The equity turnover ratio presents significant volatility and sporadic data points. It is unreported in the initial quarters but shows an extremely high figure of 134.13 in December 2019, followed by a steep drop to values such as 59.47 and 24.75 in subsequent quarters. The ratio repeatedly fluctuates, with peak values at 63.81 in June 2021 and notably 105.36 in March 2023. These sharp variations suggest inconsistency in equity utilization or potentially extraordinary accounting items or share equity changes affecting this metric. The irregular pattern prevents firm conclusions on long-term trends but indicates significant short-term shifts in shareholder equity turnover.

Net Fixed Asset Turnover

Colgate-Palmolive Co., net fixed asset turnover 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
Selected Financial Data (US$ in millions)
Net sales
Property, plant and equipment, net
Long-term Activity Ratio
Net fixed asset turnover1
Benchmarks
Net Fixed Asset 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
Net fixed asset turnover = (Net salesQ2 2023 + Net salesQ1 2023 + Net salesQ4 2022 + Net salesQ3 2022) ÷ Property, plant and equipment, net
= ( + + + ) ÷ =

2 Click competitor name to see calculations.


Net Sales

Net sales exhibited some fluctuations but generally showed an upward trend over the analyzed period. Starting at 4002 million US dollars at the end of Q1 2018, sales experienced a slight decline through 2018, reaching a low of 3811 million by year-end. In 2019, sales stabilized and showed moderate growth, culminating in 4015 million by Q4. The upward momentum continued into 2020 and 2021, with net sales increasing steadily to peak at 4414 million in Q1 2021.

Following this, sales remained relatively stable through 2021 with a minor dip in Q2 but resumed growth thereafter. From Q1 2022 onward, net sales consistently strengthened, closing at 4822 million in Q2 2023. This represents overall growth over the six-year period, with occasional short-term variability likely reflecting market or seasonal factors.

Property, Plant and Equipment, net

The net value of property, plant, and equipment demonstrated a general declining trend initially, moving from 4087 million US dollars at the close of Q1 2018 down to 3487 million in Q1 2020. This reduction could indicate asset disposals, depreciation, or a slowdown in capital expenditure during this time.

From mid-2020 onward, the figure showed signs of stabilization and a gradual increase, with values rising to 4431 million by Q2 2023. This recovery suggests renewed investment or acquisition of fixed assets, reversing the earlier contraction phase.

Net Fixed Asset Turnover Ratio

The net fixed asset turnover ratio, a measure of sales generated per unit of fixed assets, was consistently in the range of approximately 4.0 to 4.7 throughout the period for which data was available. Starting at 4.01 in Q3 2018, the ratio improved slightly to a peak near 4.77 by Q3 2021, indicating increasing efficiency in asset utilization.

Following the peak, the ratio showed a gradual decline, falling to around 4.17 in Q1 2023 before stabilizing near 4.21 in Q2 2023. This decrease may reflect the addition of fixed assets outpacing sales growth temporarily or variations in operational efficiency. Overall, the ratio's relatively narrow range signals steady asset productivity with moderate fluctuations aligned with changes in sales and asset base.

Summary

The data reveals that net sales steadily increased over the long term, albeit with short-term variances, indicating healthy demand or market expansion. The fixed asset base initially contracted but later expanded, suggesting phased capital investment aligning with strategic needs. The net fixed asset turnover ratio implies consistent asset utilization efficiency, though recent slight declines warrant monitoring to ensure sustained operational effectiveness.


Total Asset Turnover

Colgate-Palmolive Co., total asset turnover 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
Selected Financial Data (US$ in millions)
Net sales
Total assets
Long-term Activity Ratio
Total asset turnover1
Benchmarks
Total Asset 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
Total asset turnover = (Net salesQ2 2023 + Net salesQ1 2023 + Net salesQ4 2022 + Net salesQ3 2022) ÷ Total assets
= ( + + + ) ÷ =

2 Click competitor name to see calculations.


Net Sales
The net sales demonstrate a generally upward trend over the observed periods. Starting from 4002 million US$ in March 2018, sales exhibit minor fluctuations with a slight dip in the middle of 2018 but recover steadily thereafter. There is a notable increase from 4097 million US$ in March 2020 to 4822 million US$ by June 2023. This reflects consistent growth in revenue, with occasional seasonal variation but no prolonged downturns.
Total Assets
Total assets also show gradual growth across the timeline, beginning at 13,144 million US$ in March 2018. After some fluctuations through 2019 and 2020, assets peak around the range of 15,900 million US$ in late 2020 and early 2021. Despite minor declines in 2021 and early 2022, assets stabilize around 16,000 million US$ by mid-2023, indicating a stable asset base with modest expansion over the period.
Total Asset Turnover
Data for total asset turnover is available from December 2018 onward. The ratio starts at 1.28, indicating high efficiency in generating sales from assets. Following this, there is a decline to around 1.03 by December 2019, which then remains relatively stable just above 1.00 until early 2021. Beginning mid-2021, the turnover ratio shows a steady improvement, rising to 1.15 by June 2023. This trend suggests increasing asset utilization efficiency over the recent periods, moving closer to the initial higher levels.
Overall Insights
Across the data range, the company exhibits steady growth in both sales and total assets. The improving trend in total asset turnover from 2021 onward suggests better management or more effective use of assets to generate revenue. The earlier dip in asset turnover around 2019-2020 may reflect external challenges or investment phases, but recent quarters show recovery and enhanced operational efficiency. Maintaining this trajectory could support continuing revenue growth and improved financial performance.

Equity Turnover

Colgate-Palmolive Co., equity turnover 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
Selected Financial Data (US$ in millions)
Net sales
Total Colgate-Palmolive Company shareholders’ equity
Long-term Activity Ratio
Equity turnover1
Benchmarks
Equity 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
Equity turnover = (Net salesQ2 2023 + Net salesQ1 2023 + Net salesQ4 2022 + Net salesQ3 2022) ÷ Total Colgate-Palmolive Company shareholders’ equity
= ( + + + ) ÷ =

2 Click competitor name to see calculations.


Net Sales
Net sales exhibit a general upward trend over the analyzed quarters, increasing from approximately 4,002 million USD in the first quarter of 2018 to 4,822 million USD by the second quarter of 2023. There are fluctuations within this period, including a dip in mid-2020, likely influenced by external market conditions, followed by recovery and consistent growth from late 2020 through 2023. This indicates overall resilience and expansion in revenue generation.
Total Shareholders’ Equity
Total shareholders’ equity displays significant volatility throughout the period. Starting at a negative value of 249 million USD in early 2018, it fluctuates with multiple quarters showing negative equity until reaching positive territory sporadically, such as 653 million USD in the third quarter of 2020. However, these positive periods are interspersed with declines back into negative figures, culminating in negative equity figures again by the first half of 2023. This volatility suggests instability or restructuring in equity capital, which may warrant further investigation into the underlying causes.
Equity Turnover
The equity turnover ratio data is incomplete, yet the available figures indicate extremely high and fluctuating values. Ratios reach a peak of 134.13, followed by a marked decrease to figures such as 24.75 and 22.17, then again rising to over 100 in early 2022 before declining. These pronounced swings suggest significant changes in either net sales relative to equity or changes in the equity base itself. The erratic pattern aligns with the observed volatility in shareholders’ equity and may reflect operational efficiency variations or capital structure adjustments.