Paying users zone. Data is covered by hidden.

  • Get to Colgate-Palmolive Co. for $13.99, or

  • get to whole website for at least 3 months from $49.99.

DuPont Analysis: Decomposition of ROE
Quarterly Data

Difficulty: Beginner


Two-Component Disaggregation of ROE

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

Microsoft Excel LibreOffice Calc
ROE = ROA × Leverage
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
Dec 31, 2013 hidden% hidden% hidden
Sep 30, 2013 hidden% hidden% hidden
Jun 30, 2013 hidden% hidden% hidden
Mar 31, 2013 hidden% hidden% hidden

Source: Based on data from Colgate-Palmolive Co. Quarterly and Annual Reports

 


Three-Component Disaggregation of ROE

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

Microsoft Excel LibreOffice Calc
ROE = Net Profit Margin × Asset Turnover × Leverage
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
Dec 31, 2013 hidden% hidden% hidden hidden
Sep 30, 2013 hidden% hidden% hidden hidden
Jun 30, 2013 hidden% hidden% hidden hidden
Mar 31, 2013 hidden% hidden% hidden hidden

Source: Based on data from Colgate-Palmolive Co. Quarterly and Annual Reports

 


Two-Way Decomposition of ROA

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

Microsoft Excel LibreOffice Calc
ROA = Net Profit Margin × Asset Turnover
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
Dec 31, 2013 hidden% hidden% hidden
Sep 30, 2013 hidden% hidden% hidden
Jun 30, 2013 hidden% hidden% hidden
Mar 31, 2013 hidden% hidden% hidden

Source: Based on data from Colgate-Palmolive Co. Quarterly and Annual Reports

 

The primary reason for the decrease in Return on Assets (ROA) over Q1 2018 is the decrease in Asset Turnover.