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

Colgate-Palmolive Co. (NYSE:CL)

Analysis of Long-term (Investment) Activity Ratios
Quarterly Data

Beginner level

Activity ratios measure how efficiently a company performs day-to-day tasks, such us the collection of receivables and management of inventory.

Long-term Activity Ratios (Summary)

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

Microsoft Excel LibreOffice Calc
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 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015
Net fixed asset turnover 4.61 4.58 4.56 4.18 4.20 4.06 4.04 4.01 4.04 4.03 3.84 3.80 3.82 3.86 3.91 3.96 4.01 4.05 4.12 4.22 — — —
Total asset turnover 1.05 1.05 1.06 1.04 1.03 1.17 1.20 1.28 1.24 1.25 1.19 1.22 1.20 1.21 1.22 1.25 1.22 1.24 1.26 1.34 — — —
Equity turnover 24.75 59.47 — 134.13 — — — — — — — — — — — — — — — — — — —

Based on: 10-Q (filing date: 2020-10-30), 10-Q (filing date: 2020-07-31), 10-Q (filing date: 2020-05-01), 10-K (filing date: 2020-02-21), 10-Q (filing date: 2019-11-01), 10-Q (filing date: 2019-07-26), 10-Q (filing date: 2019-04-26), 10-K (filing date: 2019-02-21), 10-Q (filing date: 2018-10-26), 10-Q (filing date: 2018-07-27), 10-Q (filing date: 2018-04-27), 10-K (filing date: 2018-02-15), 10-Q (filing date: 2017-10-27), 10-Q (filing date: 2017-07-21), 10-Q (filing date: 2017-04-28), 10-K (filing date: 2017-02-23), 10-Q (filing date: 2016-10-27), 10-Q (filing date: 2016-07-28), 10-Q (filing date: 2016-04-28), 10-K (filing date: 2016-02-18), 10-Q (filing date: 2015-10-30), 10-Q (filing date: 2015-07-30), 10-Q (filing date: 2015-04-30).

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 Q1 2020 to Q2 2020 and from Q2 2020 to Q3 2020.
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Colgate-Palmolive Co.’s total asset turnover ratio deteriorated from Q1 2020 to Q2 2020 and from Q2 2020 to Q3 2020.
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Colgate-Palmolive Co.’s equity turnover ratio improved from Q1 2020 to Q2 2020 but then slightly deteriorated from Q2 2020 to Q3 2020 not reaching Q1 2020 level.

Net Fixed Asset Turnover

Colgate-Palmolive Co., net fixed asset turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
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 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015
Selected Financial Data (US$ in millions)
Net sales 4,153  3,897  4,097  4,015  3,928  3,866  3,884  3,811  3,845  3,886  4,002  3,892  3,974  3,826  3,762  3,721  3,867  3,845  3,762  3,899  3,999  4,066  4,070 
Property, plant and equipment, net 3,506  3,483  3,487  3,750  3,689  3,793  3,821  3,881  3,871  3,908  4,087  4,072  3,999  3,930  3,883  3,840  3,837  3,825  3,820  3,796  3,959  4,039  3,968 
Long-term Activity Ratio
Net fixed asset turnover1 4.61 4.58 4.56 4.18 4.20 4.06 4.04 4.01 4.04 4.03 3.84 3.80 3.82 3.86 3.91 3.96 4.01 4.05 4.12 4.22 — — —
Benchmarks
Net Fixed Asset Turnover, Competitors2
Estée Lauder Cos. Inc. 7.39 7.60 7.55 7.19 7.70 7.64 7.58 7.51 7.70 7.39 7.22 7.08 7.35 7.28 7.20 7.11 7.38 7.39 7.48 7.23 — — —
Kimberly-Clark Corp. 2.52 2.56 2.61 2.48 2.58 2.55 2.58 2.58 2.63 2.63 2.53 2.46 2.49 2.51 2.51 2.54 2.53 2.55 2.56 2.62 — — —
Nike Inc. 8.63 8.74 8.63 8.25 8.26 8.30 8.31 8.17 8.21 8.44 8.41 8.61 8.94 9.40 9.24 9.20 9.59 9.69 9.97 10.16 — — —

Based on: 10-Q (filing date: 2020-10-30), 10-Q (filing date: 2020-07-31), 10-Q (filing date: 2020-05-01), 10-K (filing date: 2020-02-21), 10-Q (filing date: 2019-11-01), 10-Q (filing date: 2019-07-26), 10-Q (filing date: 2019-04-26), 10-K (filing date: 2019-02-21), 10-Q (filing date: 2018-10-26), 10-Q (filing date: 2018-07-27), 10-Q (filing date: 2018-04-27), 10-K (filing date: 2018-02-15), 10-Q (filing date: 2017-10-27), 10-Q (filing date: 2017-07-21), 10-Q (filing date: 2017-04-28), 10-K (filing date: 2017-02-23), 10-Q (filing date: 2016-10-27), 10-Q (filing date: 2016-07-28), 10-Q (filing date: 2016-04-28), 10-K (filing date: 2016-02-18), 10-Q (filing date: 2015-10-30), 10-Q (filing date: 2015-07-30), 10-Q (filing date: 2015-04-30).

1 Q3 2020 Calculation
Net fixed asset turnover = (Net salesQ3 2020 + Net salesQ2 2020 + Net salesQ1 2020 + Net salesQ4 2019) ÷ Property, plant and equipment, net
= (4,153 + 3,897 + 4,097 + 4,015) ÷ 3,506 = 4.61

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 Q1 2020 to Q2 2020 and from Q2 2020 to Q3 2020.

Total Asset Turnover

Colgate-Palmolive Co., total asset turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
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 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015
Selected Financial Data (US$ in millions)
Net sales 4,153  3,897  4,097  4,015  3,928  3,866  3,884  3,811  3,845  3,886  4,002  3,892  3,974  3,826  3,762  3,721  3,867  3,845  3,762  3,899  3,999  4,066  4,070 
Total assets 15,466  15,141  15,070  15,034  15,026  13,151  12,883  12,161  12,571  12,650  13,144  12,676  12,775  12,580  12,448  12,123  12,623  12,515  12,448  11,958  13,563  13,660  13,156 
Long-term Activity Ratio
Total asset turnover1 1.05 1.05 1.06 1.04 1.03 1.17 1.20 1.28 1.24 1.25 1.19 1.22 1.20 1.21 1.22 1.25 1.22 1.24 1.26 1.34 — — —
Benchmarks
Total Asset Turnover, Competitors2
Estée Lauder Cos. Inc. 0.84 0.88 0.99 1.13 1.13 1.12 1.11 1.09 1.04 1.01 1.00 1.02 1.01 1.01 1.21 1.22 1.26 1.29 1.30 1.31 — — —
Kimberly-Clark Corp. 1.14 1.17 1.20 1.21 1.23 1.20 1.21 1.27 1.27 1.27 1.21 1.21 1.21 1.21 1.23 1.25 1.22 1.24 1.24 1.25 — — —
Nike Inc. 1.57 1.53 1.52 1.65 1.69 1.68 1.66 1.62 1.56 1.44 1.45 1.48 1.46 1.48 1.56 1.51 1.52 1.39 1.49 1.42 — — —

Based on: 10-Q (filing date: 2020-10-30), 10-Q (filing date: 2020-07-31), 10-Q (filing date: 2020-05-01), 10-K (filing date: 2020-02-21), 10-Q (filing date: 2019-11-01), 10-Q (filing date: 2019-07-26), 10-Q (filing date: 2019-04-26), 10-K (filing date: 2019-02-21), 10-Q (filing date: 2018-10-26), 10-Q (filing date: 2018-07-27), 10-Q (filing date: 2018-04-27), 10-K (filing date: 2018-02-15), 10-Q (filing date: 2017-10-27), 10-Q (filing date: 2017-07-21), 10-Q (filing date: 2017-04-28), 10-K (filing date: 2017-02-23), 10-Q (filing date: 2016-10-27), 10-Q (filing date: 2016-07-28), 10-Q (filing date: 2016-04-28), 10-K (filing date: 2016-02-18), 10-Q (filing date: 2015-10-30), 10-Q (filing date: 2015-07-30), 10-Q (filing date: 2015-04-30).

1 Q3 2020 Calculation
Total asset turnover = (Net salesQ3 2020 + Net salesQ2 2020 + Net salesQ1 2020 + Net salesQ4 2019) ÷ Total assets
= (4,153 + 3,897 + 4,097 + 4,015) ÷ 15,466 = 1.05

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 deteriorated from Q1 2020 to Q2 2020 and from Q2 2020 to Q3 2020.

Equity Turnover

Colgate-Palmolive Co., equity turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
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 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015
Selected Financial Data (US$ in millions)
Net sales 4,153  3,897  4,097  4,015  3,928  3,866  3,884  3,811  3,845  3,886  4,002  3,892  3,974  3,826  3,762  3,721  3,867  3,845  3,762  3,899  3,999  4,066  4,070 
Total Colgate-Palmolive Company shareholders’ equity 653  268  (113) 117  (324) (347) (552) (102) (430) (523) (249) (60) (108) (242) (313) (243) (133) (281) (370) (299) 255  454  460 
Long-term Activity Ratio
Equity turnover1 24.75 59.47 — 134.13 — — — — — — — — — — — — — — — — — — —
Benchmarks
Equity Turnover, Competitors2
Estée Lauder Cos. Inc. 3.57 3.47 3.36 3.39 3.18 3.30 3.16 2.92 2.82 2.80 2.59 2.70 2.81 3.00 3.09 3.15 2.92 3.07 3.15 2.96 — — —
Kimberly-Clark Corp. 56.38 70.31 — — — — — — — — 58.38 29.03 70.35 178.19 133.89 — 60.86 93.47 168.59 — — — —
Nike Inc. 4.56 4.36 4.33 4.33 4.32 4.36 4.15 3.71 3.61 2.95 2.86 2.77 2.67 2.72 2.71 2.64 2.59 2.34 2.41 2.41 — — —

Based on: 10-Q (filing date: 2020-10-30), 10-Q (filing date: 2020-07-31), 10-Q (filing date: 2020-05-01), 10-K (filing date: 2020-02-21), 10-Q (filing date: 2019-11-01), 10-Q (filing date: 2019-07-26), 10-Q (filing date: 2019-04-26), 10-K (filing date: 2019-02-21), 10-Q (filing date: 2018-10-26), 10-Q (filing date: 2018-07-27), 10-Q (filing date: 2018-04-27), 10-K (filing date: 2018-02-15), 10-Q (filing date: 2017-10-27), 10-Q (filing date: 2017-07-21), 10-Q (filing date: 2017-04-28), 10-K (filing date: 2017-02-23), 10-Q (filing date: 2016-10-27), 10-Q (filing date: 2016-07-28), 10-Q (filing date: 2016-04-28), 10-K (filing date: 2016-02-18), 10-Q (filing date: 2015-10-30), 10-Q (filing date: 2015-07-30), 10-Q (filing date: 2015-04-30).

1 Q3 2020 Calculation
Equity turnover = (Net salesQ3 2020 + Net salesQ2 2020 + Net salesQ1 2020 + Net salesQ4 2019) ÷ Total Colgate-Palmolive Company shareholders’ equity
= (4,153 + 3,897 + 4,097 + 4,015) ÷ 653 = 24.75

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. Colgate-Palmolive Co.’s equity turnover ratio improved from Q1 2020 to Q2 2020 but then slightly deteriorated from Q2 2020 to Q3 2020 not reaching Q1 2020 level.