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 Income Statement 
Quarterly Data

Colgate-Palmolive Co., common-size consolidated income statement (quarterly data)

Microsoft Excel
3 months ended: 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 sales 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
Cost of sales -42.20 -43.14 -44.39 -42.81 -43.04 -41.53 -41.88 -40.58 -40.00 -39.30 -38.88 -38.84 -39.21 -39.83 -39.88 -41.04 -40.30 -41.12 -40.88 -40.99 -40.79 -39.83
Gross profit 57.80% 56.86% 55.61% 57.19% 56.96% 58.47% 58.12% 59.42% 60.00% 60.70% 61.12% 61.16% 60.79% 60.17% 60.12% 58.96% 59.70% 58.88% 59.12% 59.01% 59.21% 60.17%
Selling, general and administrative expenses -36.67 -36.86 -35.28 -36.68 -36.95 -37.30 -36.29 -37.06 -36.81 -36.95 -37.77 -36.55 -35.80 -35.95 -35.17 -36.38 -35.41 -35.14 -34.85 -35.60 -33.45 -34.78
Other income (expense), net -0.93 -0.94 -0.39 0.74 -0.29 -1.61 -0.57 -0.45 0.19 -0.64 -0.95 -0.10 -0.72 -0.98 -1.77 -0.79 -1.32 -1.11 -0.89 -0.68 -1.42 -0.82
Goodwill and indefinite-lived intangible impairment charges 0.00 0.00 -15.58 0.00 0.00 0.00 -12.97 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Operating profit 20.20% 19.06% 4.36% 21.26% 19.71% 19.55% 8.29% 21.91% 23.38% 23.11% 22.41% 24.51% 24.28% 23.24% 23.19% 21.79% 22.97% 22.63% 23.38% 22.73% 24.34% 24.56%
Non-service related postretirement costs -0.60 -6.16 -0.32 -0.34 -0.27 -0.86 -0.41 -0.36 -0.42 -0.41 -0.42 -0.36 -0.51 -0.51 -0.72 -0.69 -0.70 -0.64 -0.58 -0.47 -0.59 -0.60
Interest income (expense), net -1.20 -1.13 -1.19 -0.90 -0.69 -0.61 -0.52 -2.22 -0.59 -0.67 -1.32 -0.87 -0.90 -0.88 -0.80 -0.89 -0.98 -1.03 -0.97 -0.94 -0.90 -0.87
Income before income taxes 18.39% 11.76% 2.85% 20.02% 18.76% 18.07% 7.36% 19.32% 22.37% 22.03% 20.68% 23.28% 22.86% 21.85% 21.67% 20.21% 21.29% 20.96% 21.83% 21.33% 22.85% 23.09%
Provision for income taxes -7.32 -3.08 -1.92 -4.71 -4.50 -4.36 -3.09 -3.90 -4.98 -5.27 -4.67 -5.35 -5.54 -3.59 -4.68 -4.25 -5.30 -5.51 -4.96 -6.71 -5.48 -6.15
Net income including noncontrolling interests 11.07% 8.68% 0.93% 15.31% 14.25% 13.71% 4.27% 15.43% 17.39% 16.76% 16.00% 17.94% 17.32% 18.26% 16.99% 15.96% 15.99% 15.45% 16.87% 14.62% 17.37% 16.94%
Net income attributable to noncontrolling interests -0.66 -0.88 -0.82 -1.44 -0.80 -1.00 -0.91 -1.06 -0.89 -1.08 -1.04 -1.13 -1.03 -0.81 -0.97 -1.25 -0.83 -1.03 -0.97 -1.01 -0.98 -1.10
Net income attributable to Colgate-Palmolive Company 10.41% 7.80% 0.11% 13.87% 13.45% 12.71% 3.36% 14.36% 16.50% 15.68% 14.96% 16.81% 16.29% 17.45% 16.01% 14.71% 15.16% 14.42% 15.90% 13.60% 16.39% 15.84%

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 data reveals several notable trends in the financial performance over the observed periods.

Gross Profit Margin
Gross profit as a percentage of net sales generally fluctuates between approximately 55.6% and 61.2%. Initially maintaining around 60%, there is a gradual decline starting in 2021 through 2023, dipping to a low of about 55.6% in the first quarter of 2023, indicating pressure on cost efficiency or pricing.
Cost of Sales
The cost of sales percentage shows some variability but tends to increase over time, rising from margins near 39.8% in early 2018 to peaks above 44% in late 2022 and early 2023. This rising trend aligns inversely with the declining gross profit margin, suggesting increased costs or reduced pricing power.
Selling, General and Administrative Expenses (SG&A)
SG&A expenses as a percentage of net sales largely remain between 33.5% and 37.8%, showing minor fluctuations without a clear upward or downward trajectory. The proportion remains a significant share of net sales, maintaining pressure on operating margins.
Operating Profit
Operating profit margins display variability, generally oscillating between the low teens and mid-twenties percentage points. A sharp decline occurs in the fourth quarter of 2021, dropping to 8.29%, and again in the first quarter of 2023 to 4.36%, likely influenced by substantial impairment charges identified in those periods. Following these troughs, operating margins show some recovery.
Goodwill and Indefinite-Lived Intangible Impairment Charges
Significant impairment charges are recorded in the fourth quarter of 2021 and the first quarter of 2023, indicated by large negative percentages (-12.97% and -15.58%, respectively). These charges correspond to the notable dips in operating and net income margins during the same periods.
Interest Income (Expense), Net
Interest expense steadily represents a small negative portion of net sales, generally around -0.6% to -1.3%, with no pronounced trend. There is a slight increase in negative expense in some periods but overall remains stable.
Income Before Income Taxes
This metric tends to track operating profit trends, with dips corresponding to periods of impairment charges and other expenses. Income before taxes dropped markedly in Q4 2021 and Q1 2023, consistent with the observed impairments and lower operating profit.
Provision for Income Taxes
The tax provision as a percentage of net sales varies from roughly -7.3% to -1.9%, demonstrating some volatility that may relate to changes in pre-tax income and tax strategies. The proportion of tax expense declined notably in early 2023 compared to previous periods.
Net Income
Net income attributable to the company follows a pattern similar to operating profit and pre-tax income, with declines corresponding to impairment-related quarters. After relatively stable margins ranging mostly between 13% and 17%, net income drops sharply in Q4 2021 and Q1 2023 to single-digit or near-zero percentages, followed by partial recovery.
Overall Observations
Across the observed quarterly periods, the company demonstrates stable revenue proportions but experiences margin compression due to increasing cost of sales and sustained SG&A expenses. The occurrence of goodwill impairment charges significantly impacts profitability in specific quarters, causing pronounced declines in operating and net income margins. Despite these impacts, core operating profitability shows resilience with a tendency to recover post-impairment quarters.