Stock Analysis on Net
Stock Analysis on Net
Microsoft Excel LibreOffice Calc

Colgate-Palmolive Co. (NYSE:CL)

Analysis of Long-term (Investment) Activity Ratios

Beginner level

Long-term Activity Ratios (Summary)

Colgate-Palmolive Co., long-term (investment) activity ratios

Microsoft Excel LibreOffice Calc
Dec 31, 2019 Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015
Net fixed asset turnover 4.18 4.01 3.80 3.96 4.22
Net fixed asset turnover (including operating lease, right-of-use asset) 3.69 4.01 3.80 3.96 4.22
Total asset turnover 1.04 1.28 1.22 1.25 1.34
Equity turnover 134.13

Based on: 10-K (filing date: 2020-02-21), 10-K (filing date: 2019-02-21), 10-K (filing date: 2018-02-15), 10-K (filing date: 2017-02-23), 10-K (filing date: 2016-02-18).

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Colgate-Palmolive Co.’s net fixed asset turnover ratio improved from 2017 to 2018 and from 2018 to 2019.
Net fixed asset turnover (including operating lease, right-of-use asset) An activity ratio calculated as total revenue divided by net fixed assets (including operating lease, right-of-use asset). Colgate-Palmolive Co.’s net fixed asset turnover ratio (with operating lease, right-of-use asset) improved from 2017 to 2018 but then deteriorated significantly from 2018 to 2019.
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Colgate-Palmolive Co.’s total asset turnover ratio improved from 2017 to 2018 but then deteriorated significantly from 2018 to 2019.
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity.

Net Fixed Asset Turnover

Colgate-Palmolive Co., net fixed asset turnover calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Dec 31, 2019 Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015
Selected Financial Data (US$ in millions)
Net sales 15,693  15,544  15,454  15,195  16,034 
Property, plant and equipment, net 3,750  3,881  4,072  3,840  3,796 
Long-term Activity Ratio
Net fixed asset turnover1 4.18 4.01 3.80 3.96 4.22
Benchmarks
Net Fixed Asset Turnover, Competitors2
Estée Lauder Cos. Inc. 7.19 7.51 7.08 7.11 7.23
Kimberly-Clark Corp. 2.48 2.58 2.46 2.54 2.62
Nike Inc. 8.25 8.17 8.61 9.20 10.16
Net Fixed Asset Turnover, Sector
Personal Goods 4.89 4.86 4.65 4.78 4.94
Net Fixed Asset Turnover, Industry
Consumer Goods 4.47 4.65 4.63 4.73 4.71

Based on: 10-K (filing date: 2020-02-21), 10-K (filing date: 2019-02-21), 10-K (filing date: 2018-02-15), 10-K (filing date: 2017-02-23), 10-K (filing date: 2016-02-18).

1 2019 Calculation
Net fixed asset turnover = Net sales ÷ Property, plant and equipment, net
= 15,693 ÷ 3,750 = 4.18

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Colgate-Palmolive Co.’s net fixed asset turnover ratio improved from 2017 to 2018 and from 2018 to 2019.

Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset)

Colgate-Palmolive Co., net fixed asset turnover (including operating lease, right-of-use asset) calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Dec 31, 2019 Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015
Selected Financial Data (US$ in millions)
Net sales 15,693  15,544  15,454  15,195  16,034 
 
Property, plant and equipment, net 3,750  3,881  4,072  3,840  3,796 
Operating lease right-of use assets (included in Other assets) 502  —  —  —  — 
Property, plant and equipment, net (including operating lease, right-of-use asset) 4,252  3,881  4,072  3,840  3,796 
Long-term Activity Ratio
Net fixed asset turnover (including operating lease, right-of-use asset)1 3.69 4.01 3.80 3.96 4.22
Benchmarks
Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset), Competitors2
Estée Lauder Cos. Inc. 7.19 7.51 7.08 7.11 7.23
Kimberly-Clark Corp. 2.35 2.58 2.46 2.54 2.62
Nike Inc. 8.25 8.17 8.61 9.20 10.16
Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset), Sector
Personal Goods 4.66 4.86 4.65 4.78 4.94
Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset), Industry
Consumer Goods 4.20 4.65 4.63 4.73 4.71

Based on: 10-K (filing date: 2020-02-21), 10-K (filing date: 2019-02-21), 10-K (filing date: 2018-02-15), 10-K (filing date: 2017-02-23), 10-K (filing date: 2016-02-18).

1 2019 Calculation
Net fixed asset turnover (including operating lease, right-of-use asset) = Net sales ÷ Property, plant and equipment, net (including operating lease, right-of-use asset)
= 15,693 ÷ 4,252 = 3.69

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Net fixed asset turnover (including operating lease, right-of-use asset) An activity ratio calculated as total revenue divided by net fixed assets (including operating lease, right-of-use asset). Colgate-Palmolive Co.’s net fixed asset turnover ratio (with operating lease, right-of-use asset) improved from 2017 to 2018 but then deteriorated significantly from 2018 to 2019.

Total Asset Turnover

Colgate-Palmolive Co., total asset turnover calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Dec 31, 2019 Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015
Selected Financial Data (US$ in millions)
Net sales 15,693  15,544  15,454  15,195  16,034 
Total assets 15,034  12,161  12,676  12,123  11,958 
Long-term Activity Ratio
Total asset turnover1 1.04 1.28 1.22 1.25 1.34
Benchmarks
Total Asset Turnover, Competitors2
Estée Lauder Cos. Inc. 1.13 1.09 1.02 1.22 1.31
Kimberly-Clark Corp. 1.21 1.27 1.21 1.25 1.25
Nike Inc. 1.65 1.62 1.48 1.51 1.42
Total Asset Turnover, Sector
Personal Goods 1.31 1.36 1.28 1.34 1.34
Total Asset Turnover, Industry
Consumer Goods 0.67 0.66 0.64 0.65 0.67

Based on: 10-K (filing date: 2020-02-21), 10-K (filing date: 2019-02-21), 10-K (filing date: 2018-02-15), 10-K (filing date: 2017-02-23), 10-K (filing date: 2016-02-18).

1 2019 Calculation
Total asset turnover = Net sales ÷ Total assets
= 15,693 ÷ 15,034 = 1.04

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Colgate-Palmolive Co.’s total asset turnover ratio improved from 2017 to 2018 but then deteriorated significantly from 2018 to 2019.

Equity Turnover

Colgate-Palmolive Co., equity turnover calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Dec 31, 2019 Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015
Selected Financial Data (US$ in millions)
Net sales 15,693  15,544  15,454  15,195  16,034 
Total Colgate-Palmolive Company shareholders’ equity 117  (102) (60) (243) (299)
Long-term Activity Ratio
Equity turnover1 134.13
Benchmarks
Equity Turnover, Competitors2
Estée Lauder Cos. Inc. 3.39 2.92 2.70 3.15 2.96
Kimberly-Clark Corp. 29.03
Nike Inc. 4.33 3.71 2.77 2.64 2.41
Equity Turnover, Sector
Personal Goods 6.52 5.96 4.60 4.97 4.79
Equity Turnover, Industry
Consumer Goods 2.33 2.18 1.98 2.05 2.07

Based on: 10-K (filing date: 2020-02-21), 10-K (filing date: 2019-02-21), 10-K (filing date: 2018-02-15), 10-K (filing date: 2017-02-23), 10-K (filing date: 2016-02-18).

1 2019 Calculation
Equity turnover = Net sales ÷ Total Colgate-Palmolive Company shareholders’ equity
= 15,693 ÷ 117 = 134.13

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity.