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.

Common-Size Balance Sheet: Assets
Quarterly Data

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

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
Receivables, net of allowances
Inventories
Other current assets
Current assets
Property, plant and equipment, cost
Accumulated depreciation
Property, plant and equipment, net
Goodwill
Other intangible assets, net
Deferred income taxes
Other assets
Non-current assets
Total assets

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


Cash and cash equivalents
Cash and cash equivalents as a percentage of total assets experienced moderate fluctuations, mostly staying within the 5% to 6.7% range. A slight decline is observable from early 2022 to mid-2023, where the ratio decreased from approximately 5.58% to around 5.05%.
Receivables, net of allowances
Receivables showed a downward trend from 12.5% in early 2018 to a trough below 8% during 2020, before trending upward again to exceed 10% by mid-2023. The data indicates a reduction in receivables relative to assets during the pandemic period, followed by a recovery thereafter.
Inventories
Inventories, as a proportion of total assets, decreased slightly from nearly 10% in early 2018 to about 8.6% in early 2020, then demonstrated a steady increase to peak above 13% by the end of 2022, followed by a minor decline to around 12.6% in mid-2023. This suggests higher stock levels in recent periods.
Other current assets
Other current assets fluctuated between 3% and 5.7%, with a marked increase beginning in early 2022 and continuing into 2023, growing from approximately 4.2% to a higher level near 5.7% by mid-2023. This reflects a growing share of miscellaneous current assets.
Current assets
The aggregate proportion of current assets declined from around 33% in 2018 to roughly 28% in 2019 and early 2020, then gradually increased to stabilize around 33.5% by mid-2023. This pattern indicates an initial contraction followed by gradual expansion in current asset holdings.
Property, plant and equipment (cost)
The cost of property, plant, and equipment showed a decline from a high of over 68% of total assets in late 2018 to just above 54% by 2020, followed by a recovery trend peaking near 61.5% in mid-2023. The initial decline suggests asset disposals or lower capital expenditures before renewed investment or revaluation.
Accumulated depreciation
Accumulated depreciation remained consistently negative, fluctuating around -31% to -36% of total assets. The highest negative impact was observed between 2018 and 2019, easing less negative toward 2022, and then slightly deepening again in 2023. This pattern reflects depreciation accumulation relative to asset base changes.
Property, plant and equipment (net)
Net PPE as a percentage of total assets declined from about 31% in 2018 to around 22.5% in 2019, hitting the low mark near 22.8% in 2021, followed by an increasing trend to roughly 27.3% by mid-2023. This corresponds with cost and depreciation trends, indicating asset base renewal or valuation increases.
Goodwill
Goodwill accounted for roughly 20% of total assets throughout the period, peaking at about 24% in 2020, followed by a decline to just below 21% in the most recent quarters. This suggests stable acquisition-related intangible assets but some downward adjustment or dilution over time.
Other intangible assets, net
Other intangible assets decreased steadily from approximately 13.5% in early 2018 to nearly 11.7% by mid-2023. The decline demonstrates amortization or disposals impacting intangible asset values over the period.
Deferred income taxes
Deferred income taxes fluctuated between 0.8% and 1.8%, with no clear trend and occasional peaks in 2020 and 2021. The variability suggests changing tax positions or timing differences relative to the asset base.
Other assets
Other assets increased notably from around 1.4% in 2018 to a range between 5.3% and 6.9% in subsequent years, peaking in early 2022, then stabilizing near 5.5% by mid-2023. This reflects either new asset categories or reclassification inflating this category over time.
Non-current assets
Non-current assets maintained a relatively stable proportion of total assets between 66% and 72%, with a minor decline from about 72% in 2019 and 2020 to roughly 66% by mid-2023. This denotes a slight shift towards more current assets or asset base rebalancing during the period.