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.

Return on Capital (ROC)

Microsoft Excel

Return on capital (ROC) is after tax rate of return on net business assets. ROIC is unaffected by changes in interest rates or company debt and equity structure. It measures business productivity performance.


Return on Invested Capital (ROIC)

Colgate-Palmolive Co., ROIC calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018
Selected Financial Data (US$ in millions)
Net operating profit after taxes (NOPAT)1 2,048 2,361 2,814 2,572 2,711
Invested capital2 14,460 13,505 13,943 13,859 11,791
Performance Ratio
ROIC3 14.17% 17.48% 20.18% 18.56% 22.99%
Benchmarks
ROIC, Competitors4
Procter & Gamble Co. 15.53% 15.02% 12.65% 4.19% 9.16%

Based on: 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31).

1 NOPAT. See details »

2 Invested capital. See details »

3 2022 Calculation
ROIC = 100 × NOPAT ÷ Invested capital
= 100 × 2,048 ÷ 14,460 = 14.17%

4 Click competitor name to see calculations.

Performance ratio Description The company
ROIC A measure of the periodic, after tax, cash-on-cash yield earned in the business. Colgate-Palmolive Co. ROIC deteriorated from 2020 to 2021 and from 2021 to 2022.

Decomposition of ROIC

Colgate-Palmolive Co., decomposition of ROIC

Microsoft Excel
ROIC = OPM1 × TO2 × 1 – CTR3
Dec 31, 2022 14.17% = 16.37% × 1.24 × 69.66%
Dec 31, 2021 17.48% = 18.21% × 1.29 × 74.41%
Dec 31, 2020 20.18% = 22.97% × 1.18 × 74.37%
Dec 31, 2019 18.56% = 21.43% × 1.13 × 76.48%
Dec 31, 2018 22.99% = 23.14% × 1.32 × 75.35%

Based on: 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31).

1 Operating profit margin (OPM). See calculations »

2 Turnover of capital (TO). See calculations »

3 Effective cash tax rate (CTR). See calculations »

The primary reason for the decrease in return on invested capital (ROIC) over 2022 year is the decrease in profitability measured by operating profit margin (OPM) ratio.


Operating Profit Margin (OPM)

Colgate-Palmolive Co., OPM calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018
Selected Financial Data (US$ in millions)
Net operating profit after taxes (NOPAT)1 2,048 2,361 2,814 2,572 2,711
Add: Cash operating taxes2 892 812 970 791 887
Net operating profit before taxes (NOPBT) 2,941 3,173 3,784 3,363 3,597
 
Net sales 17,967 17,421 16,471 15,693 15,544
Profitability Ratio
OPM3 16.37% 18.21% 22.97% 21.43% 23.14%
Benchmarks
OPM, Competitors4
Procter & Gamble Co. 22.79% 23.52% 22.81% 9.38% 20.71%

Based on: 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31).

1 NOPAT. See details »

2 Cash operating taxes. See details »

3 2022 Calculation
OPM = 100 × NOPBT ÷ Net sales
= 100 × 2,941 ÷ 17,967 = 16.37%

4 Click competitor name to see calculations.

Profitability ratio Description The company
OPM The operating profit margin (OPM) is the ratio of pretax economic earnings, or NOPBT, to sales. Colgate-Palmolive Co. OPM deteriorated from 2020 to 2021 and from 2021 to 2022.

Turnover of Capital (TO)

Colgate-Palmolive Co., TO calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018
Selected Financial Data (US$ in millions)
Net sales 17,967 17,421 16,471 15,693 15,544
Invested capital1 14,460 13,505 13,943 13,859 11,791
Efficiency Ratio
TO2 1.24 1.29 1.18 1.13 1.32
Benchmarks
TO, Competitors3
Procter & Gamble Co. 0.85 0.80 0.70 0.75 0.72

Based on: 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31).

1 Invested capital. See details »

2 2022 Calculation
TO = Net sales ÷ Invested capital
= 17,967 ÷ 14,460 = 1.24

3 Click competitor name to see calculations.

Efficiency ratio Description The company
TO The turnover of capital (TO) is the ratio of sales to invested capital. Capital turnover is a function of the efficiency of working capital management and of net fixed assets. Colgate-Palmolive Co. TO improved from 2020 to 2021 but then slightly deteriorated from 2021 to 2022.

Effective Cash Tax Rate (CTR)

Colgate-Palmolive Co., CTR calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018
Selected Financial Data (US$ in millions)
Net operating profit after taxes (NOPAT)1 2,048 2,361 2,814 2,572 2,711
Add: Cash operating taxes2 892 812 970 791 887
Net operating profit before taxes (NOPBT) 2,941 3,173 3,784 3,363 3,597
Tax Rate
CTR3 30.34% 25.59% 25.63% 23.52% 24.65%
Benchmarks
CTR, Competitors4
Procter & Gamble Co. 20.19% 20.23% 21.01% 40.67% 38.93%

Based on: 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31).

1 NOPAT. See details »

2 Cash operating taxes. See details »

3 2022 Calculation
CTR = 100 × Cash operating taxes ÷ NOPBT
= 100 × 892 ÷ 2,941 = 30.34%

4 Click competitor name to see calculations.

Tax rate Description The company
CTR Effective cash tax rate on operating income. Colgate-Palmolive Co. CTR decreased from 2020 to 2021 but then increased from 2021 to 2022 exceeding 2020 level.