Stock Analysis on Net
AI Tokens
Stock Analysis on Net

Colgate-Palmolive Co. (NYSE:CL)

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

Common-Size Balance Sheet: Assets
Quarterly Data

Colgate-Palmolive Co., common-size consolidated balance sheet: assets (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
Cash and cash equivalents 5.05 5.36 4.93 5.76 5.46 5.58 5.53 6.03 5.86 6.30 5.58 6.39 6.58 5.67 5.87 6.31 6.56 6.54 5.97 6.69 6.58 6.47
Receivables, net of allowances 10.21 9.83 9.56 8.75 9.48 9.74 8.62 8.97 9.02 8.87 7.94 8.35 8.13 10.29 9.58 9.95 12.09 12.01 11.51 12.19 12.21 12.51
Inventories 12.57 13.05 13.18 12.73 12.81 12.24 11.25 10.52 10.63 10.61 10.51 10.20 10.07 8.63 9.31 9.12 10.05 9.92 10.28 9.90 9.91 9.98
Other current assets 5.69 5.56 4.83 5.17 5.09 4.17 3.83 3.89 3.58 3.10 3.22 3.28 3.04 3.60 3.03 3.56 3.65 3.61 3.43 4.16 4.27 3.69
Current assets 33.51% 33.80% 32.50% 32.40% 32.84% 31.73% 29.24% 29.41% 29.08% 28.88% 27.25% 28.24% 27.82% 28.19% 27.80% 28.94% 32.35% 32.08% 31.19% 32.94% 32.98% 32.65%
Property, plant and equipment, cost 61.55 60.69 60.92 57.21 57.37 57.51 59.17 55.59 55.30 54.66 54.97 54.18 54.14 54.19 57.07 55.83 64.45 65.19 68.55 67.23 66.47 65.79
Accumulated depreciation -34.25 -33.71 -33.54 -31.89 -33.41 -33.65 -34.37 -32.71 -32.40 -31.82 -31.63 -31.51 -31.13 -31.06 -32.13 -31.28 -35.61 -35.53 -36.63 -36.43 -35.57 -34.70
Property, plant and equipment, net 27.31% 26.98% 27.38% 25.31% 23.96% 23.86% 24.80% 22.88% 22.91% 22.84% 23.34% 22.67% 23.00% 23.14% 24.94% 24.55% 28.84% 29.66% 31.91% 30.79% 30.89% 31.09%
Goodwill 20.79 20.87 21.31 21.72 20.61 20.94 21.84 23.21 23.46 23.42 24.02 23.99 23.96 23.62 23.33 23.51 19.28 19.54 20.80 20.20 19.63 19.57
Other intangible assets, net 11.72 11.86 12.21 13.62 14.73 15.36 16.37 17.12 17.42 17.64 18.18 18.35 18.41 18.73 17.74 16.87 12.23 12.51 13.46 13.20 13.72 13.56
Deferred income taxes 1.15 1.11 0.86 1.12 1.20 1.23 1.28 1.64 1.77 1.27 1.83 1.34 1.48 1.19 1.18 1.10 1.27 1.27 1.25 1.31 1.23 1.42
Other assets 5.54 5.39 5.75 5.82 6.66 6.88 6.48 5.75 5.37 5.95 5.38 5.41 5.33 5.14 5.01 5.03 6.01 4.94 1.38 1.55 1.55 1.70
Non-current assets 66.49% 66.20% 67.50% 67.60% 67.16% 68.27% 70.76% 70.59% 70.92% 71.12% 72.75% 71.76% 72.18% 71.81% 72.20% 71.06% 67.65% 67.92% 68.81% 67.06% 67.02% 67.35%
Total assets 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00%

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 asset composition of the organization exhibits a notable shift in liquidity and capital allocation between March 2018 and June 2023. While the total asset base is normalized to 100%, the internal distribution reveals a transition from a higher reliance on fixed physical assets toward a more balanced mix of current assets and intangible valuations, punctuated by a period of significant restructuring in 2019 and 2020.

Current Asset Dynamics
Current assets fluctuated from a peak of 32.98% in mid-2018 to a low of 27.25% by December 2020, before recovering to 33.51% by June 2023. A critical shift is observed within the components of current assets; receivables decreased from 12.51% to 10.21%, while inventories showed a steady upward trajectory, rising from 9.98% in March 2018 to a peak of 13.18% in December 2022. This suggests a strategic shift toward higher inventory holdings relative to the total asset base, potentially indicating changes in supply chain management or market demand forecasting.
Cash and cash equivalents remained relatively stable but trended gradually downward, moving from 6.47% to 5.05% over the analyzed period, reflecting a slight reduction in immediate liquidity as a percentage of total assets.
Non-Current Asset Trends
Non-current assets experienced an increase in prominence between 2019 and 2020, peaking at 72.75% in December 2020, before returning to 66.49% by June 2023. Net Property, Plant, and Equipment (PP&E) saw a marked decline from 31.09% in early 2018 to a low of 22.67% in September 2020, followed by a partial recovery to 27.31% by mid-2023. The accumulated depreciation as a percentage of total assets remained high, consistently offsetting a significant portion of the gross PP&E cost.
Intangible assets and goodwill showed significant volatility. Goodwill increased from 19.57% to a peak of 24.02% in December 2020 before stabilizing around 20.79%. Other net intangible assets followed a similar pattern, rising from 13.56% to 18.73% in March 2020, but subsequently declining to 11.72% by June 2023, suggesting a cycle of acquisition followed by amortization or impairment.
Structural Asset Allocation
A long-term trend is observed in "Other assets," which grew from 1.70% in March 2018 to 5.54% by June 2023. This indicates a growing portion of the balance sheet is tied to miscellaneous non-current items. Overall, the balance sheet has transitioned from a heavy weighting in net physical assets and receivables toward a higher proportion of inventories and miscellaneous non-current assets, while maintaining a consistent baseline of goodwill.

AI Ask an analyst for more

My previous chats

Add tokens

Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.
Without a user account, I tend to respond rather slowly.

How can I help you?