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.

Analysis of Profitability Ratios 
Quarterly Data

Microsoft Excel

Profitability Ratios (Summary)

Colgate-Palmolive Co., profitability 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
Return on Sales
Gross profit margin 56.87% 56.65% 57.04% 57.68% 58.24% 59.00% 59.55% 60.31% 60.75% 60.95% 60.82% 60.56% 60.01% 59.74% 59.42% 59.16% 59.18% 59.06% 59.39%
Operating profit margin 16.23% 16.04% 16.10% 17.23% 17.38% 18.24% 19.13% 22.70% 23.34% 23.55% 23.59% 23.80% 23.12% 22.80% 22.65% 22.69% 22.93% 23.27% 23.76%
Net profit margin 8.02% 8.71% 9.93% 10.87% 10.98% 11.70% 12.43% 15.37% 15.98% 15.92% 16.36% 16.65% 16.13% 15.86% 15.08% 15.04% 14.77% 15.08% 15.44%
Return on Investment
Return on equity (ROE) 445.14% 309.97% 1,157.14% 636.76% 355.67% 450.93% 588.15% 1,015.65% 362.72% 412.10% 959.33% 2,023.08%
Return on assets (ROA) 9.23% 9.88% 11.35% 11.84% 12.37% 13.00% 14.40% 16.78% 17.06% 16.84% 16.93% 17.40% 16.98% 16.74% 15.74% 15.51% 17.30% 18.05% 19.74%

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

Profitability ratio Description The company
Gross profit margin Gross profit margin indicates the percentage of revenue available to cover operating and other expenditures. Colgate-Palmolive Co. gross profit margin ratio deteriorated from Q4 2022 to Q1 2023 but then improved from Q1 2023 to Q2 2023 not reaching Q4 2022 level.
Operating profit margin A profitability ratio calculated as operating income divided by revenue. Colgate-Palmolive Co. operating profit margin ratio deteriorated from Q4 2022 to Q1 2023 but then improved from Q1 2023 to Q2 2023 exceeding Q4 2022 level.
Net profit margin An indicator of profitability, calculated as net income divided by revenue. Colgate-Palmolive Co. net profit margin ratio deteriorated from Q4 2022 to Q1 2023 and from Q1 2023 to Q2 2023.

Profitability ratio Description The company
ROA A profitability ratio calculated as net income divided by total assets. Colgate-Palmolive Co. ROA deteriorated from Q4 2022 to Q1 2023 and from Q1 2023 to Q2 2023.

Gross Profit Margin

Colgate-Palmolive Co., gross profit margin 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)
Gross profit 2,787 2,712 2,574 2,548 2,554 2,572 2,559 2,623 2,556 2,637 2,643 2,540 2,369 2,465 2,414 2,316 2,308 2,287 2,253 2,269 2,301 2,408
Net sales 4,822 4,770 4,629 4,455 4,484 4,399 4,403 4,414 4,260 4,344 4,324 4,153 3,897 4,097 4,015 3,928 3,866 3,884 3,811 3,845 3,886 4,002
Profitability Ratio
Gross profit margin1 56.87% 56.65% 57.04% 57.68% 58.24% 59.00% 59.55% 60.31% 60.75% 60.95% 60.82% 60.56% 60.01% 59.74% 59.42% 59.16% 59.18% 59.06% 59.39%
Benchmarks
Gross Profit Margin, Competitors2
Procter & Gamble Co. 46.60% 47.01% 47.43% 48.32% 49.27% 50.31% 51.25% 51.57% 51.26% 50.78% 50.32% 49.90% 49.77% 49.11% 48.63%

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
Gross profit margin = 100 × (Gross profitQ2 2023 + Gross profitQ1 2023 + Gross profitQ4 2022 + Gross profitQ3 2022) ÷ (Net salesQ2 2023 + Net salesQ1 2023 + Net salesQ4 2022 + Net salesQ3 2022)
= 100 × (2,787 + 2,712 + 2,574 + 2,548) ÷ (4,822 + 4,770 + 4,629 + 4,455) = 56.87%

2 Click competitor name to see calculations.

Profitability ratio Description The company
Gross profit margin Gross profit margin indicates the percentage of revenue available to cover operating and other expenditures. Colgate-Palmolive Co. gross profit margin ratio deteriorated from Q4 2022 to Q1 2023 but then improved from Q1 2023 to Q2 2023 not reaching Q4 2022 level.

Operating Profit Margin

Colgate-Palmolive Co., operating profit margin 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)
Operating profit 974 909 202 947 884 860 365 967 996 1,004 969 1,018 946 952 931 856 888 879 891 874 946 983
Net sales 4,822 4,770 4,629 4,455 4,484 4,399 4,403 4,414 4,260 4,344 4,324 4,153 3,897 4,097 4,015 3,928 3,866 3,884 3,811 3,845 3,886 4,002
Profitability Ratio
Operating profit margin1 16.23% 16.04% 16.10% 17.23% 17.38% 18.24% 19.13% 22.70% 23.34% 23.55% 23.59% 23.80% 23.12% 22.80% 22.65% 22.69% 22.93% 23.27% 23.76%
Benchmarks
Operating Profit Margin, Competitors2
Procter & Gamble Co. 21.61% 22.03% 22.21% 22.30% 22.36% 22.98% 23.63% 23.94% 23.79% 23.04% 22.14% 10.00% 9.78% 9.05% 8.11%

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
Operating profit margin = 100 × (Operating profitQ2 2023 + Operating profitQ1 2023 + Operating profitQ4 2022 + Operating profitQ3 2022) ÷ (Net salesQ2 2023 + Net salesQ1 2023 + Net salesQ4 2022 + Net salesQ3 2022)
= 100 × (974 + 909 + 202 + 947) ÷ (4,822 + 4,770 + 4,629 + 4,455) = 16.23%

2 Click competitor name to see calculations.

Profitability ratio Description The company
Operating profit margin A profitability ratio calculated as operating income divided by revenue. Colgate-Palmolive Co. operating profit margin ratio deteriorated from Q4 2022 to Q1 2023 but then improved from Q1 2023 to Q2 2023 exceeding Q4 2022 level.

Net Profit Margin

Colgate-Palmolive Co., net profit margin 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 income attributable to Colgate-Palmolive Company 502 372 5 618 603 559 148 634 703 681 647 698 635 715 643 578 586 560 606 523 637 634
Net sales 4,822 4,770 4,629 4,455 4,484 4,399 4,403 4,414 4,260 4,344 4,324 4,153 3,897 4,097 4,015 3,928 3,866 3,884 3,811 3,845 3,886 4,002
Profitability Ratio
Net profit margin1 8.02% 8.71% 9.93% 10.87% 10.98% 11.70% 12.43% 15.37% 15.98% 15.92% 16.36% 16.65% 16.13% 15.86% 15.08% 15.04% 14.77% 15.08% 15.44%
Benchmarks
Net Profit Margin, Competitors2
Procter & Gamble Co. 17.79% 18.11% 18.38% 18.33% 18.52% 18.33% 18.79% 18.97% 18.72% 18.92% 18.36% 7.09% 6.92% 6.24% 5.76%

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 profit margin = 100 × (Net income attributable to Colgate-Palmolive CompanyQ2 2023 + Net income attributable to Colgate-Palmolive CompanyQ1 2023 + Net income attributable to Colgate-Palmolive CompanyQ4 2022 + Net income attributable to Colgate-Palmolive CompanyQ3 2022) ÷ (Net salesQ2 2023 + Net salesQ1 2023 + Net salesQ4 2022 + Net salesQ3 2022)
= 100 × (502 + 372 + 5 + 618) ÷ (4,822 + 4,770 + 4,629 + 4,455) = 8.02%

2 Click competitor name to see calculations.

Profitability ratio Description The company
Net profit margin An indicator of profitability, calculated as net income divided by revenue. Colgate-Palmolive Co. net profit margin ratio deteriorated from Q4 2022 to Q1 2023 and from Q1 2023 to Q2 2023.

Return on Equity (ROE)

Colgate-Palmolive Co., ROE 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 income attributable to Colgate-Palmolive Company 502 372 5 618 603 559 148 634 703 681 647 698 635 715 643 578 586 560 606 523 637 634
Total Colgate-Palmolive Company shareholders’ equity (64) (6) 401 622 168 321 609 591 464 262 743 653 268 (113) 117 (324) (347) (552) (102) (430) (523) (249)
Profitability Ratio
ROE1 445.14% 309.97% 1,157.14% 636.76% 355.67% 450.93% 588.15% 1,015.65% 362.72% 412.10% 959.33% 2,023.08%
Benchmarks
ROE, Competitors2
Procter & Gamble Co. 32.12% 33.06% 31.64% 32.09% 32.52% 30.67% 30.85% 30.47% 28.74% 28.46% 28.00% 10.95% 10.57% 9.21% 8.26%

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
ROE = 100 × (Net income attributable to Colgate-Palmolive CompanyQ2 2023 + Net income attributable to Colgate-Palmolive CompanyQ1 2023 + Net income attributable to Colgate-Palmolive CompanyQ4 2022 + Net income attributable to Colgate-Palmolive CompanyQ3 2022) ÷ Total Colgate-Palmolive Company shareholders’ equity
= 100 × (502 + 372 + 5 + 618) ÷ -64 =

2 Click competitor name to see calculations.


Return on Assets (ROA)

Colgate-Palmolive Co., ROA 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 income attributable to Colgate-Palmolive Company 502 372 5 618 603 559 148 634 703 681 647 698 635 715 643 578 586 560 606 523 637 634
Total assets 16,227 16,173 15,731 16,288 15,711 15,723 15,040 15,880 15,999 15,801 15,920 15,466 15,141 15,070 15,034 15,026 13,151 12,883 12,161 12,571 12,650 13,144
Profitability Ratio
ROA1 9.23% 9.88% 11.35% 11.84% 12.37% 13.00% 14.40% 16.78% 17.06% 16.84% 16.93% 17.40% 16.98% 16.74% 15.74% 15.51% 17.30% 18.05% 19.74%
Benchmarks
ROA, Competitors2
Procter & Gamble Co. 12.13% 12.53% 12.58% 12.14% 11.95% 11.82% 11.99% 12.16% 11.53% 11.44% 10.79% 4.21% 4.31% 3.76% 3.39%

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
ROA = 100 × (Net income attributable to Colgate-Palmolive CompanyQ2 2023 + Net income attributable to Colgate-Palmolive CompanyQ1 2023 + Net income attributable to Colgate-Palmolive CompanyQ4 2022 + Net income attributable to Colgate-Palmolive CompanyQ3 2022) ÷ Total assets
= 100 × (502 + 372 + 5 + 618) ÷ 16,227 = 9.23%

2 Click competitor name to see calculations.

Profitability ratio Description The company
ROA A profitability ratio calculated as net income divided by total assets. Colgate-Palmolive Co. ROA deteriorated from Q4 2022 to Q1 2023 and from Q1 2023 to Q2 2023.