Paying users zone. Data is covered by hidden.

  • Get to Merck & Co. Inc. for $19.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

Merck & Co. Inc., decomposition of ROE (quarterly data)

Microsoft Excel LibreOffice Calc
ROE = ROA × Leverage
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
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 Merck & Co. Inc. Quarterly and Annual Reports

 

The primary reason for the decrease in Return on Equity (ROE) over Q2 2018 is the decrease in profitability measured by Return on Assets (ROA).


Three-Component Disaggregation of ROE

Merck & Co. Inc., decomposition of ROE (quarterly data)

Microsoft Excel LibreOffice Calc
ROE = Net Profit Margin × Asset Turnover × Leverage
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
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 Merck & Co. Inc. Quarterly and Annual Reports

 

The primary reason for the decrease in Return on Equity (ROE) over Q2 2018 is the decrease in profitability measured by Net Profit Margin.


Two-Way Decomposition of ROA

Merck & Co. Inc., decomposition of ROA (quarterly data)

Microsoft Excel LibreOffice Calc
ROA = Net Profit Margin × Asset Turnover
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
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 Merck & Co. Inc. Quarterly and Annual Reports

 

The primary reason for the decrease in Return on Assets (ROA) over Q2 2018 is the decrease in profitability measured by Net Profit Margin.