.DuPont Analysis: Decomposition of ROE
Difficulty: Beginner
Decomposing ROE involves expressing net income divided by shareholders' equity as the product of component ratios.
Two-Component Disaggregation of ROE
Colgate-Palmolive Co., decomposition of ROE
| | | | |||
| ROE | = | ROA | × | Leverage | |
|---|---|---|---|---|---|
| Dec 31, 2017 | % | % | |||
| Dec 31, 2016 | % | % | |||
| Dec 31, 2015 | % | % | |||
| Dec 31, 2014 | % | % | |||
| Dec 31, 2013 | % | % |
Source: Based on data from Colgate-Palmolive Co. Annual Reports
Three-Component Disaggregation of ROE
Colgate-Palmolive Co., decomposition of ROE
| | | | | ||||
| ROE | = | Net Profit Margin | × | Asset Turnover | × | Leverage | |
|---|---|---|---|---|---|---|---|
| Dec 31, 2017 | % | % | |||||
| Dec 31, 2016 | % | % | |||||
| Dec 31, 2015 | % | % | |||||
| Dec 31, 2014 | % | % | |||||
| Dec 31, 2013 | % | % |
Source: Based on data from Colgate-Palmolive Co. Annual Reports
Five-Component Disaggregation of ROE
Colgate-Palmolive Co., decomposition of ROE
| | | | | | | ||||||
| ROE | = | Tax Burden | × | Interest Burden | × | EBIT Margin | × | Asset Turnover | × | Leverage | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Dec 31, 2017 | % | % | |||||||||
| Dec 31, 2016 | % | % | |||||||||
| Dec 31, 2015 | % | % | |||||||||
| Dec 31, 2014 | % | % | |||||||||
| Dec 31, 2013 | % | % |
Source: Based on data from Colgate-Palmolive Co. Annual Reports
Two-Way Decomposition of ROA
Colgate-Palmolive Co., decomposition of ROA
| | | | |||
| ROA | = | Net Profit Margin | × | Asset Turnover | |
|---|---|---|---|---|---|
| Dec 31, 2017 | % | % | |||
| Dec 31, 2016 | % | % | |||
| Dec 31, 2015 | % | % | |||
| Dec 31, 2014 | % | % | |||
| Dec 31, 2013 | % | % |
Source: Based on data from Colgate-Palmolive Co. Annual Reports
The primary reason for the decrease in Return on Assets (ROA) over 2017 year is the decrease in profitability measured by Net Profit Margin.
Four-Way Decomposition of ROA
Colgate-Palmolive Co., decomposition of ROA
| | | | | | |||||
| ROA | = | Tax Burden | × | Interest Burden | × | EBIT Margin | × | Asset Turnover | |
|---|---|---|---|---|---|---|---|---|---|
| Dec 31, 2017 | % | % | |||||||
| Dec 31, 2016 | % | % | |||||||
| Dec 31, 2015 | % | % | |||||||
| Dec 31, 2014 | % | % | |||||||
| Dec 31, 2013 | % | % |
Source: Based on data from Colgate-Palmolive Co. Annual Reports
The primary reason for the decrease in Return on Assets (ROA) over 2017 year is the decrease in effect of taxes measured by Tax Burden.
Decomposition of Net Profit Margin
Colgate-Palmolive Co., decomposition of Net Profit Margin
| | | | | ||||
| Net Profit Margin | = | Tax Burden | × | Interest Burden | × | EBIT Margin | |
|---|---|---|---|---|---|---|---|
| Dec 31, 2017 | % | % | |||||
| Dec 31, 2016 | % | % | |||||
| Dec 31, 2015 | % | % | |||||
| Dec 31, 2014 | % | % | |||||
| Dec 31, 2013 | % | % |
Source: Based on data from Colgate-Palmolive Co. Annual Reports
The primary reason for the decrease in Net Profit Margin over 2017 year is the decrease in effect of taxes measured by Tax Burden.
