Paying users zone. Data is covered by hidden.

  • Get to Broadcom 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

Broadcom Inc., decomposition of ROE

Microsoft Excel LibreOffice Calc
ROE = ROA × Leverage
Oct 29, 2017 hidden% hidden% hidden
Oct 30, 2016 hidden% hidden% hidden
Nov 1, 2015 hidden% hidden% hidden
Nov 2, 2014 hidden% hidden% hidden
Nov 3, 2013 hidden% hidden% hidden
Oct 28, 2012 hidden% hidden% hidden

Source: Based on data from Broadcom Inc. Annual Reports

 


Three-Component Disaggregation of ROE

Broadcom Inc., decomposition of ROE

Microsoft Excel LibreOffice Calc
ROE = Net Profit Margin × Asset Turnover × Leverage
Oct 29, 2017 hidden% hidden% hidden hidden
Oct 30, 2016 hidden% hidden% hidden hidden
Nov 1, 2015 hidden% hidden% hidden hidden
Nov 2, 2014 hidden% hidden% hidden hidden
Nov 3, 2013 hidden% hidden% hidden hidden
Oct 28, 2012 hidden% hidden% hidden hidden

Source: Based on data from Broadcom Inc. Annual Reports

 


Five-Component Disaggregation of ROE

Broadcom Inc., decomposition of ROE

Microsoft Excel LibreOffice Calc
ROE = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover × Leverage
Oct 29, 2017 hidden% hidden hidden hidden% hidden hidden
Oct 30, 2016 hidden% hidden hidden hidden% hidden hidden
Nov 1, 2015 hidden% hidden hidden hidden% hidden hidden
Nov 2, 2014 hidden% hidden hidden hidden% hidden hidden
Nov 3, 2013 hidden% hidden hidden hidden% hidden hidden
Oct 28, 2012 hidden% hidden hidden hidden% hidden hidden

Source: Based on data from Broadcom Inc. Annual Reports

 


Two-Way Decomposition of ROA

Broadcom Inc., decomposition of ROA

Microsoft Excel LibreOffice Calc
ROA = Net Profit Margin × Asset Turnover
Oct 29, 2017 hidden% hidden% hidden
Oct 30, 2016 hidden% hidden% hidden
Nov 1, 2015 hidden% hidden% hidden
Nov 2, 2014 hidden% hidden% hidden
Nov 3, 2013 hidden% hidden% hidden
Oct 28, 2012 hidden% hidden% hidden

Source: Based on data from Broadcom Inc. Annual Reports

 


Four-Way Decomposition of ROA

Broadcom Inc., decomposition of ROA

Microsoft Excel LibreOffice Calc
ROA = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover
Oct 29, 2017 hidden% hidden hidden hidden% hidden
Oct 30, 2016 hidden% hidden hidden hidden% hidden
Nov 1, 2015 hidden% hidden hidden hidden% hidden
Nov 2, 2014 hidden% hidden hidden hidden% hidden
Nov 3, 2013 hidden% hidden hidden hidden% hidden
Oct 28, 2012 hidden% hidden hidden hidden% hidden

Source: Based on data from Broadcom Inc. Annual Reports

 


Decomposition of Net Profit Margin

Broadcom Inc., decomposition of Net Profit Margin

Microsoft Excel LibreOffice Calc
Net Profit Margin = Tax Burden × Interest Burden × EBIT Margin
Oct 29, 2017 hidden% hidden hidden hidden%
Oct 30, 2016 hidden% hidden hidden hidden%
Nov 1, 2015 hidden% hidden hidden hidden%
Nov 2, 2014 hidden% hidden hidden hidden%
Nov 3, 2013 hidden% hidden hidden hidden%
Oct 28, 2012 hidden% hidden hidden hidden%

Source: Based on data from Broadcom Inc. Annual Reports