Stock Analysis on Net
Stock Analysis on Net

Anadarko Petroleum Corp. (NYSE:APC)

This company has been moved to the archive! The financial data has not been updated since October 31, 2017.

DuPont Analysis: Disaggregation of ROE, ROA, and Net Profit Margin

Microsoft Excel

Decomposing ROE involves expressing net income divided by shareholders’ equity as the product of component ratios.

Two-Component Disaggregation of ROE

Anadarko Petroleum Corp., decomposition of ROE

Microsoft Excel
ROE = ROA × Financial Leverage
Dec 31, 2016 -25.15% = -6.74% × 3.73
Dec 31, 2015 -52.20% = -14.42% × 3.62
Dec 31, 2014 -8.87% = -2.84% × 3.13
Dec 31, 2013 3.66% = 1.44% × 2.55
Dec 31, 2012 11.59% = 4.55% × 2.55

Based on: 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31), 10-K (reporting date: 2013-12-31), 10-K (reporting date: 2012-12-31).

Three-Component Disaggregation of ROE

Anadarko Petroleum Corp., decomposition of ROE

Microsoft Excel
ROE = Net Profit Margin × Asset Turnover × Financial Leverage
Dec 31, 2016 -25.15% = -36.36% × 0.19 × 3.73
Dec 31, 2015 -52.20% = -70.55% × 0.20 × 3.62
Dec 31, 2014 -8.87% = -10.69% × 0.27 × 3.13
Dec 31, 2013 3.66% = 5.39% × 0.27 × 2.55
Dec 31, 2012 11.59% = 17.97% × 0.25 × 2.55

Based on: 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31), 10-K (reporting date: 2013-12-31), 10-K (reporting date: 2012-12-31).

Five-Component Disaggregation of ROE

Anadarko Petroleum Corp., decomposition of ROE

Microsoft Excel
ROE = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover × Financial Leverage
Dec 31, 2016 -25.15% = — × — × -37.91% × 0.19 × 3.73
Dec 31, 2015 -52.20% = — × — × -92.18% × 0.20 × 3.62
Dec 31, 2014 -8.87% = — × -0.21 × 3.90% × 0.27 × 3.13
Dec 31, 2013 3.66% = 0.41 × 0.74 × 17.84% × 0.27 × 2.55
Dec 31, 2012 11.59% = 0.68 × 0.83 × 31.96% × 0.25 × 2.55

Based on: 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31), 10-K (reporting date: 2013-12-31), 10-K (reporting date: 2012-12-31).

Two-Component Disaggregation of ROA

Anadarko Petroleum Corp., decomposition of ROA

Microsoft Excel
ROA = Net Profit Margin × Asset Turnover
Dec 31, 2016 -6.74% = -36.36% × 0.19
Dec 31, 2015 -14.42% = -70.55% × 0.20
Dec 31, 2014 -2.84% = -10.69% × 0.27
Dec 31, 2013 1.44% = 5.39% × 0.27
Dec 31, 2012 4.55% = 17.97% × 0.25

Based on: 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31), 10-K (reporting date: 2013-12-31), 10-K (reporting date: 2012-12-31).

Four-Component Disaggregation of ROA

Anadarko Petroleum Corp., decomposition of ROA

Microsoft Excel
ROA = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover
Dec 31, 2016 -6.74% = — × — × -37.91% × 0.19
Dec 31, 2015 -14.42% = — × — × -92.18% × 0.20
Dec 31, 2014 -2.84% = — × -0.21 × 3.90% × 0.27
Dec 31, 2013 1.44% = 0.41 × 0.74 × 17.84% × 0.27
Dec 31, 2012 4.55% = 0.68 × 0.83 × 31.96% × 0.25

Based on: 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31), 10-K (reporting date: 2013-12-31), 10-K (reporting date: 2012-12-31).

Disaggregation of Net Profit Margin

Anadarko Petroleum Corp., decomposition of net profit margin ratio

Microsoft Excel
Net Profit Margin = Tax Burden × Interest Burden × EBIT Margin
Dec 31, 2016 -36.36% = — × — × -37.91%
Dec 31, 2015 -70.55% = — × — × -92.18%
Dec 31, 2014 -10.69% = — × -0.21 × 3.90%
Dec 31, 2013 5.39% = 0.41 × 0.74 × 17.84%
Dec 31, 2012 17.97% = 0.68 × 0.83 × 31.96%

Based on: 10-K (reporting date: 2016-12-31), 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31), 10-K (reporting date: 2013-12-31), 10-K (reporting date: 2012-12-31).