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.

DuPont Analysis: Disaggregation of ROE, ROA, and Net Profit Margin 
Quarterly Data

Microsoft Excel

Decomposing ROE involves expressing net income divided by shareholders’ equity as the product of component ratios.


Two-Component Disaggregation of ROE

Colgate-Palmolive Co., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = ROA × Financial Leverage
Jun 30, 2023 = 9.23% ×
Mar 31, 2023 = 9.88% ×
Dec 31, 2022 445.14% = 11.35% × 39.23
Sep 30, 2022 309.97% = 11.84% × 26.19
Jun 30, 2022 1,157.14% = 12.37% × 93.52
Mar 31, 2022 636.76% = 13.00% × 48.98
Dec 31, 2021 355.67% = 14.40% × 24.70
Sep 30, 2021 450.93% = 16.78% × 26.87
Jun 30, 2021 588.15% = 17.06% × 34.48
Mar 31, 2021 1,015.65% = 16.84% × 60.31
Dec 31, 2020 362.72% = 16.93% × 21.43
Sep 30, 2020 412.10% = 17.40% × 23.68
Jun 30, 2020 959.33% = 16.98% × 56.50
Mar 31, 2020 = 16.74% ×
Dec 31, 2019 2,023.08% = 15.74% × 128.50
Sep 30, 2019 = 15.51% ×
Jun 30, 2019 = 17.30% ×
Mar 31, 2019 = 18.05% ×

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


Return on Assets (ROA)
The ROA generally demonstrated a decreasing trend over the periods examined. Starting at 18.05% in March 2019, it declined intermittently through the years, dipping to 9.23% by June 2023. There were moderate fluctuations, with slight recoveries observed around mid-2020 and mid-2021. However, the overall trajectory was downward, indicating a gradual reduction in the efficiency with which assets are generating profits.
Financial Leverage
Financial leverage figures were inconsistent and sporadic across the observed dates. Notably high values were recorded in March 2020 (128.5) and June 2022 (93.52), suggesting episodes of significantly increased debt or equity multiplier effects during specific quarters. Other periods featured moderate to low leverage ratios, such as 21.43 in December 2019 and 24.7 in December 2021. These fluctuations indicate variable capital structure strategies or changes in debt utilization over time, lacking a clear upward or downward trend.
Return on Equity (ROE)
ROE exhibited extremely high and volatile values during the periods it was reported, with especially elevated figures in March 2020 (2023.08%) and June 2022 (1157.14%). The data indicates substantial spikes in equity profitability at these points, which quickly normalized yet remained elevated in subsequent quarters. The pattern reflects significant variability in returns to shareholders, potentially influenced by unusual financial events, accounting adjustments, or leverage effects that amplified equity returns.
Summary Insights
Overall, the company's asset profitability demonstrated a clear decline over the years, while its equity profitability was marked by extreme volatility and high peaks. Financial leverage ratios fluctuated erratically, potentially impacting the volatility observed in return metrics. The combined analysis suggests increased financial risk and variability in returns to equity holders, despite a downward trend in asset-based efficiency.

Three-Component Disaggregation of ROE

Colgate-Palmolive Co., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = Net Profit Margin × Asset Turnover × Financial Leverage
Jun 30, 2023 = 8.02% × 1.15 ×
Mar 31, 2023 = 8.71% × 1.13 ×
Dec 31, 2022 445.14% = 9.93% × 1.14 × 39.23
Sep 30, 2022 309.97% = 10.87% × 1.09 × 26.19
Jun 30, 2022 1,157.14% = 10.98% × 1.13 × 93.52
Mar 31, 2022 636.76% = 11.70% × 1.11 × 48.98
Dec 31, 2021 355.67% = 12.43% × 1.16 × 24.70
Sep 30, 2021 450.93% = 15.37% × 1.09 × 26.87
Jun 30, 2021 588.15% = 15.98% × 1.07 × 34.48
Mar 31, 2021 1,015.65% = 15.92% × 1.06 × 60.31
Dec 31, 2020 362.72% = 16.36% × 1.03 × 21.43
Sep 30, 2020 412.10% = 16.65% × 1.05 × 23.68
Jun 30, 2020 959.33% = 16.13% × 1.05 × 56.50
Mar 31, 2020 = 15.86% × 1.06 ×
Dec 31, 2019 2,023.08% = 15.08% × 1.04 × 128.50
Sep 30, 2019 = 15.04% × 1.03 ×
Jun 30, 2019 = 14.77% × 1.17 ×
Mar 31, 2019 = 15.08% × 1.20 ×

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


The analysis of the quarterly financial ratios reveals several important trends in profitability, efficiency, and capital structure over the observed periods.

Net Profit Margin
The net profit margin showed a relatively stable pattern from early 2019 through 2020, consistently hovering around 15% to 16.6%. However, starting in 2021, there was a noticeable decline, with the margin decreasing from approximately 15.9% in the first quarter of 2021 to about 8.0% by mid-2023. This decline suggests growing pressure on profitability, possibly due to increased costs, pricing pressures, or other operational challenges.
Asset Turnover
The asset turnover ratio, which measures the efficiency of asset use in generating sales, remained fairly stable throughout the period, fluctuating slightly between 1.03 and 1.16. Notably, there was a slight upward trend starting in late 2020 through mid-2023, improving from around 1.03 to approximately 1.15. This indicates gradual improvements in asset utilization over time despite the decline in profitability.
Financial Leverage
Financial leverage data shows considerable volatility and periods of missing information. Early values are extremely high, with a ratio of 128.5 in early 2019 and a sharp decline to lower levels such as 23.68 and 21.43 towards late 2019 and early 2020. Thereafter, leverage fluctuated, spiking to levels above 90 in mid-2022 before declining back to around 26–39 in 2023. The wide range and instability in leverage indicate significant changes in the company’s capital structure, possibly due to debt management strategies or asset revaluation.
Return on Equity (ROE)
The ROE values exhibit extreme volatility, with several extremely high values reported, such as over 2000% in late 2019 and near 1157% in mid-2022. These spikes suggest anomalies or possibly extraordinary items impacting equity or earnings. Despite fluctuations, the trend suggests a generally high but unstable return on equity throughout the periods examined. The large swings and missing data complicate reliable interpretation but imply substantial leverage of equity returns during certain periods.

In summary, the company demonstrates strong yet decreasing profitability as reflected in the net profit margin, modest improvements in asset efficiency, and highly variable financial leverage and ROE figures. The financial leverage volatility coupled with extreme ROE spikes indicates significant capital structure and earnings volatility that warrants further investigation to understand underlying causes and sustainability.


Two-Component Disaggregation of ROA

Colgate-Palmolive Co., decomposition of ROA (quarterly data)

Microsoft Excel
ROA = Net Profit Margin × Asset Turnover
Jun 30, 2023 9.23% = 8.02% × 1.15
Mar 31, 2023 9.88% = 8.71% × 1.13
Dec 31, 2022 11.35% = 9.93% × 1.14
Sep 30, 2022 11.84% = 10.87% × 1.09
Jun 30, 2022 12.37% = 10.98% × 1.13
Mar 31, 2022 13.00% = 11.70% × 1.11
Dec 31, 2021 14.40% = 12.43% × 1.16
Sep 30, 2021 16.78% = 15.37% × 1.09
Jun 30, 2021 17.06% = 15.98% × 1.07
Mar 31, 2021 16.84% = 15.92% × 1.06
Dec 31, 2020 16.93% = 16.36% × 1.03
Sep 30, 2020 17.40% = 16.65% × 1.05
Jun 30, 2020 16.98% = 16.13% × 1.05
Mar 31, 2020 16.74% = 15.86% × 1.06
Dec 31, 2019 15.74% = 15.08% × 1.04
Sep 30, 2019 15.51% = 15.04% × 1.03
Jun 30, 2019 17.30% = 14.77% × 1.17
Mar 31, 2019 18.05% = 15.08% × 1.20

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


Net Profit Margin
The net profit margin experienced a gradual increase from early 2019 through 2020, peaking at around 16.65% in the third quarter of 2020. Following this period, there was a steady decline in profitability margins, particularly notable from late 2021 onward. By mid-2023, the net profit margin had decreased to approximately 8.02%, indicating a significant reduction in profitability relative to revenue compared to earlier periods.
Asset Turnover
The asset turnover ratio demonstrated relative stability with minor fluctuations throughout the observed period. Early 2019 started with a ratio close to 1.20, followed by a slight decrease in late 2019. From 2021 onward, asset turnover showed a modest upward trend, peaking at around 1.16 in the last quarter of 2021. The ratio remained fairly consistent around 1.13 to 1.15 during the subsequent quarters in 2022 and 2023, reflecting a steady level of efficiency in asset utilization over time.
Return on Assets (ROA)
The return on assets followed a pattern similar to that of net profit margin. Beginning at a high point of around 18.05% in early 2019, ROA declined gradually through 2019. It rose again during 2020, reaching approximately 17.40% in the third quarter. However, from late 2021, ROA exhibited a continuous downward trend, falling to around 9.23% by mid-2023. This decline suggests diminishing overall profitability relative to the company's asset base in recent quarters.
Summary Insights
The data indicates that while asset turnover and efficiency in using assets have remained relatively stable with a slight improvement in recent years, both profitability metrics—net profit margin and return on assets—have declined significantly since late 2021. This divergence suggests that although the company maintains its operational efficiency, external or internal factors may be adversely impacting its profitability. The downward trend in profitability ratios warrants further investigation into cost management, pricing strategies, or market conditions affecting earnings.