Paying users zone. Data is covered by hidden.

  • Get to Caterpillar Inc. for $15.99, or

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

Microsoft Excel LibreOffice Calc


DuPont Analysis: Decomposition of ROE

Difficulty: Beginner


Two-Component Disaggregation of ROE

Caterpillar Inc., decomposition of ROE

Microsoft Excel LibreOffice Calc
ROE = ROA × Leverage
Dec 31, 2017 hidden% hidden% hidden
Dec 31, 2016 hidden% hidden% hidden
Dec 31, 2015 hidden% hidden% hidden
Dec 31, 2014 hidden% hidden% hidden
Dec 31, 2013 hidden% hidden% hidden

Source: Based on data from Caterpillar Inc. Annual Reports

 


Three-Component Disaggregation of ROE

Caterpillar Inc., decomposition of ROE

Microsoft Excel LibreOffice Calc
ROE = Net Profit Margin × Asset Turnover × Leverage
Dec 31, 2017 hidden% hidden% hidden hidden
Dec 31, 2016 hidden% hidden% hidden hidden
Dec 31, 2015 hidden% hidden% hidden hidden
Dec 31, 2014 hidden% hidden% hidden hidden
Dec 31, 2013 hidden% hidden% hidden hidden

Source: Based on data from Caterpillar Inc. Annual Reports

 


Five-Component Disaggregation of ROE

Caterpillar Inc., decomposition of ROE

Microsoft Excel LibreOffice Calc
ROE = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover × Leverage
Dec 31, 2017 hidden% hidden hidden hidden% hidden hidden
Dec 31, 2016 hidden% hidden hidden hidden% hidden hidden
Dec 31, 2015 hidden% hidden hidden hidden% hidden hidden
Dec 31, 2014 hidden% hidden hidden hidden% hidden hidden
Dec 31, 2013 hidden% hidden hidden hidden% hidden hidden

Source: Based on data from Caterpillar Inc. Annual Reports

 


Two-Way Decomposition of ROA

Caterpillar Inc., decomposition of ROA

Microsoft Excel LibreOffice Calc
ROA = Net Profit Margin × Asset Turnover
Dec 31, 2017 hidden% hidden% hidden
Dec 31, 2016 hidden% hidden% hidden
Dec 31, 2015 hidden% hidden% hidden
Dec 31, 2014 hidden% hidden% hidden
Dec 31, 2013 hidden% hidden% hidden

Source: Based on data from Caterpillar Inc. Annual Reports

 


Four-Way Decomposition of ROA

Caterpillar Inc., decomposition of ROA

Microsoft Excel LibreOffice Calc
ROA = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover
Dec 31, 2017 hidden% hidden hidden hidden% hidden
Dec 31, 2016 hidden% hidden hidden hidden% hidden
Dec 31, 2015 hidden% hidden hidden hidden% hidden
Dec 31, 2014 hidden% hidden hidden hidden% hidden
Dec 31, 2013 hidden% hidden hidden hidden% hidden

Source: Based on data from Caterpillar Inc. Annual Reports

 


Decomposition of Net Profit Margin

Caterpillar Inc., decomposition of Net Profit Margin

Microsoft Excel LibreOffice Calc
Net Profit Margin = Tax Burden × Interest Burden × EBIT Margin
Dec 31, 2017 hidden% hidden hidden hidden%
Dec 31, 2016 hidden% hidden hidden hidden%
Dec 31, 2015 hidden% hidden hidden hidden%
Dec 31, 2014 hidden% hidden hidden hidden%
Dec 31, 2013 hidden% hidden hidden hidden%

Source: Based on data from Caterpillar Inc. Annual Reports