Paying users zone. Data is hidden behind hidden.

  • Get 1-month access to Colgate-Palmolive Co. for $15.99, or

  • get full access to the entire website for at least 3 months from $49.99.


We accept:

Visa Mastercard American Express Maestro Discover JCB PayPal Apple Pay Google Pay
Verified by Visa MasterCard SecureCode American Express SafeKey

This is a one-time payment. There is no automatic renewal.

Colgate-Palmolive Co. (CL)


DuPont Analysis: Disaggregation of ROE, ROA, and Net Profit Margin
Quarterly Data

Low level of difficulty


Two-Component Disaggregation of ROE

Colgate-Palmolive Co., decomposition of ROE (quarterly data)

Microsoft Excel LibreOffice Calc
ROE = ROA × Financial Leverage
Sep 30, 2019 hidden = hidden × hidden
Jun 30, 2019 hidden = hidden × hidden
Mar 31, 2019 hidden = hidden × hidden
Dec 31, 2018 hidden = hidden × hidden
Sep 30, 2018 hidden = hidden × hidden
Jun 30, 2018 hidden = hidden × hidden
Mar 31, 2018 hidden = hidden × hidden
Dec 31, 2017 hidden = hidden × hidden
Sep 30, 2017 hidden = hidden × hidden
Jun 30, 2017 hidden = hidden × hidden
Mar 31, 2017 hidden = hidden × hidden
Dec 31, 2016 hidden = hidden × hidden
Sep 30, 2016 hidden = hidden × hidden
Jun 30, 2016 hidden = hidden × hidden
Mar 31, 2016 hidden = hidden × hidden
Dec 31, 2015 hidden = hidden × hidden
Sep 30, 2015 hidden = hidden × hidden
Jun 30, 2015 hidden = hidden × hidden
Mar 31, 2015 hidden = hidden × hidden
Dec 31, 2014 hidden = hidden × hidden
Sep 30, 2014 hidden = hidden × hidden
Jun 30, 2014 hidden = hidden × hidden
Mar 31, 2014 hidden = hidden × hidden

Based on: 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), 10-K (filing date: 2015-02-19), 10-Q (filing date: 2014-10-24), 10-Q (filing date: 2014-07-31), 10-Q (filing date: 2014-04-25).


Three-Component Disaggregation of ROE

Colgate-Palmolive Co., decomposition of ROE (quarterly data)

Microsoft Excel LibreOffice Calc
ROE = Net Profit Margin × Asset Turnover × Financial Leverage
Sep 30, 2019 hidden = hidden × hidden × hidden
Jun 30, 2019 hidden = hidden × hidden × hidden
Mar 31, 2019 hidden = hidden × hidden × hidden
Dec 31, 2018 hidden = hidden × hidden × hidden
Sep 30, 2018 hidden = hidden × hidden × hidden
Jun 30, 2018 hidden = hidden × hidden × hidden
Mar 31, 2018 hidden = hidden × hidden × hidden
Dec 31, 2017 hidden = hidden × hidden × hidden
Sep 30, 2017 hidden = hidden × hidden × hidden
Jun 30, 2017 hidden = hidden × hidden × hidden
Mar 31, 2017 hidden = hidden × hidden × hidden
Dec 31, 2016 hidden = hidden × hidden × hidden
Sep 30, 2016 hidden = hidden × hidden × hidden
Jun 30, 2016 hidden = hidden × hidden × hidden
Mar 31, 2016 hidden = hidden × hidden × hidden
Dec 31, 2015 hidden = hidden × hidden × hidden
Sep 30, 2015 hidden = hidden × hidden × hidden
Jun 30, 2015 hidden = hidden × hidden × hidden
Mar 31, 2015 hidden = hidden × hidden × hidden
Dec 31, 2014 hidden = hidden × hidden × hidden
Sep 30, 2014 hidden = hidden × hidden × hidden
Jun 30, 2014 hidden = hidden × hidden × hidden
Mar 31, 2014 hidden = hidden × hidden × hidden

Based on: 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), 10-K (filing date: 2015-02-19), 10-Q (filing date: 2014-10-24), 10-Q (filing date: 2014-07-31), 10-Q (filing date: 2014-04-25).


Two-Component Disaggregation of ROA

Colgate-Palmolive Co., decomposition of ROA (quarterly data)

Microsoft Excel LibreOffice Calc
ROA = Net Profit Margin × Asset Turnover
Sep 30, 2019 hidden = hidden × hidden
Jun 30, 2019 hidden = hidden × hidden
Mar 31, 2019 hidden = hidden × hidden
Dec 31, 2018 hidden = hidden × hidden
Sep 30, 2018 hidden = hidden × hidden
Jun 30, 2018 hidden = hidden × hidden
Mar 31, 2018 hidden = hidden × hidden
Dec 31, 2017 hidden = hidden × hidden
Sep 30, 2017 hidden = hidden × hidden
Jun 30, 2017 hidden = hidden × hidden
Mar 31, 2017 hidden = hidden × hidden
Dec 31, 2016 hidden = hidden × hidden
Sep 30, 2016 hidden = hidden × hidden
Jun 30, 2016 hidden = hidden × hidden
Mar 31, 2016 hidden = hidden × hidden
Dec 31, 2015 hidden = hidden × hidden
Sep 30, 2015 hidden = hidden × hidden
Jun 30, 2015 hidden = hidden × hidden
Mar 31, 2015 hidden = hidden × hidden
Dec 31, 2014 hidden = hidden × hidden
Sep 30, 2014 hidden = hidden × hidden
Jun 30, 2014 hidden = hidden × hidden
Mar 31, 2014 hidden = hidden × hidden

Based on: 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), 10-K (filing date: 2015-02-19), 10-Q (filing date: 2014-10-24), 10-Q (filing date: 2014-07-31), 10-Q (filing date: 2014-04-25).

The primary reason for the decrease in return on assets ratio (ROA) over Q3 2019 is the decrease in asset turnover ratio.