Stock Analysis on Net
Stock Analysis on Net

Apache Corp. (NYSE:APA)

This company has been moved to the archive! The financial data has not been updated since August 4, 2016.

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

Apache Corp., decomposition of ROE

Microsoft Excel
ROE = ROA × Financial Leverage
Dec 31, 2015 -900.97% = -122.70% × 7.34
Dec 31, 2014 -20.83% = -9.66% × 2.16
Dec 31, 2013 6.68% = 3.62% × 1.85
Dec 31, 2012 6.39% = 3.29% × 1.94
Dec 31, 2011 15.81% = 8.81% × 1.80

Based on: 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), 10-K (reporting date: 2011-12-31).

Three-Component Disaggregation of ROE

Apache Corp., decomposition of ROE

Microsoft Excel
ROE = Net Profit Margin × Asset Turnover × Financial Leverage
Dec 31, 2015 -900.97% = -362.20% × 0.34 × 7.34
Dec 31, 2014 -20.83% = -39.30% × 0.25 × 2.16
Dec 31, 2013 6.68% = 13.61% × 0.27 × 1.85
Dec 31, 2012 6.39% = 11.81% × 0.28 × 1.94
Dec 31, 2011 15.81% = 27.27% × 0.32 × 1.80

Based on: 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), 10-K (reporting date: 2011-12-31).

Five-Component Disaggregation of ROE

Apache Corp., decomposition of ROE

Microsoft Excel
ROE = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover × Financial Leverage
Dec 31, 2015 -900.97% = — × — × -443.82% × 0.34 × 7.34
Dec 31, 2014 -20.83% = — × — × -26.40% × 0.25 × 2.16
Dec 31, 2013 6.68% = 0.54 × 0.95 × 26.56% × 0.27 × 1.85
Dec 31, 2012 6.39% = 0.41 × 0.97 × 29.81% × 0.28 × 1.94
Dec 31, 2011 15.81% = 0.57 × 0.98 × 49.16% × 0.32 × 1.80

Based on: 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), 10-K (reporting date: 2011-12-31).

Two-Component Disaggregation of ROA

Apache Corp., decomposition of ROA

Microsoft Excel
ROA = Net Profit Margin × Asset Turnover
Dec 31, 2015 -122.70% = -362.20% × 0.34
Dec 31, 2014 -9.66% = -39.30% × 0.25
Dec 31, 2013 3.62% = 13.61% × 0.27
Dec 31, 2012 3.29% = 11.81% × 0.28
Dec 31, 2011 8.81% = 27.27% × 0.32

Based on: 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), 10-K (reporting date: 2011-12-31).

Four-Component Disaggregation of ROA

Apache Corp., decomposition of ROA

Microsoft Excel
ROA = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover
Dec 31, 2015 -122.70% = — × — × -443.82% × 0.34
Dec 31, 2014 -9.66% = — × — × -26.40% × 0.25
Dec 31, 2013 3.62% = 0.54 × 0.95 × 26.56% × 0.27
Dec 31, 2012 3.29% = 0.41 × 0.97 × 29.81% × 0.28
Dec 31, 2011 8.81% = 0.57 × 0.98 × 49.16% × 0.32

Based on: 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), 10-K (reporting date: 2011-12-31).

Disaggregation of Net Profit Margin

Apache Corp., decomposition of net profit margin ratio

Microsoft Excel
Net Profit Margin = Tax Burden × Interest Burden × EBIT Margin
Dec 31, 2015 -362.20% = — × — × -443.82%
Dec 31, 2014 -39.30% = — × — × -26.40%
Dec 31, 2013 13.61% = 0.54 × 0.95 × 26.56%
Dec 31, 2012 11.81% = 0.41 × 0.97 × 29.81%
Dec 31, 2011 27.27% = 0.57 × 0.98 × 49.16%

Based on: 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), 10-K (reporting date: 2011-12-31).