Analysis of Profitability Ratios
Quarterly Data
Profitability ratios measure the company ability to generate profitable sales from its resources (assets).
Profitability Ratios (Summary)
Colgate-Palmolive Co., profitability ratios (quarterly data)
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)
| 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% | 48.04% | 48.03% | 48.37% | 48.73% | — | — | — | |||||||
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)
| 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% | 19.91% | 20.06% | 20.23% | 20.52% | — | — | — | |||||||
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)
| 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% | 16.44% | 16.13% | 15.10% | 14.59% | — | — | — | |||||||
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)
| 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% | 20.03% | 19.99% | 19.33% | 18.64% | — | — | — | |||||||
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)
| 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% | 9.06% | 8.73% | 8.52% | 8.24% | — | — | — | |||||||
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. |