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 
Quarterly Data

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 (quarterly data)

Microsoft Excel
ROE = ROA × Financial Leverage
Jun 30, 2016 -188.80% = -55.38% × 3.41
Mar 31, 2016 -252.85% = -76.17% × 3.32
Dec 31, 2015 -900.97% = -122.70% × 7.34
Sep 30, 2015 -211.23% = -74.50% × 2.84
Jun 30, 2015 -105.47% = -46.43% × 2.27
Mar 31, 2015 -48.51% = -21.15% × 2.29
Dec 31, 2014 -20.83% = -9.66% × 2.16
Sep 30, 2014 -1.35% = -0.68% × 1.98
Jun 30, 2014 3.73% = 2.00% × 1.87
Mar 31, 2014 5.29% = 2.86% × 1.85
Dec 31, 2013 6.68% = 3.62% × 1.85
Sep 30, 2013 8.27% = 4.53% × 1.83
Jun 30, 2013 7.95% = 4.10% × 1.94
Mar 31, 2013 6.01% = 3.11% × 1.93
Dec 31, 2012 6.39% = 3.29% × 1.94
Sep 30, 2012 8.21% = 4.29% × 1.91
Jun 30, 2012 10.90% = 5.84% × 1.87
Mar 31, 2012 14.29% = 7.98% × 1.79
Dec 31, 2011 15.81% = 8.81% × 1.80
Sep 30, 2011 — = — × 1.70
Jun 30, 2011 — = — × 1.74
Mar 31, 2011 — = — × 1.78

Based on: 10-Q (reporting date: 2016-06-30), 10-Q (reporting date: 2016-03-31), 10-K (reporting date: 2015-12-31), 10-Q (reporting date: 2015-09-30), 10-Q (reporting date: 2015-06-30), 10-Q (reporting date: 2015-03-31), 10-K (reporting date: 2014-12-31), 10-Q (reporting date: 2014-09-30), 10-Q (reporting date: 2014-06-30), 10-Q (reporting date: 2014-03-31), 10-K (reporting date: 2013-12-31), 10-Q (reporting date: 2013-09-30), 10-Q (reporting date: 2013-06-30), 10-Q (reporting date: 2013-03-31), 10-K (reporting date: 2012-12-31), 10-Q (reporting date: 2012-09-30), 10-Q (reporting date: 2012-06-30), 10-Q (reporting date: 2012-03-31), 10-K (reporting date: 2011-12-31), 10-Q (reporting date: 2011-09-30), 10-Q (reporting date: 2011-06-30), 10-Q (reporting date: 2011-03-31).

Three-Component Disaggregation of ROE

Apache Corp., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = Net Profit Margin × Asset Turnover × Financial Leverage
Jun 30, 2016 -188.80% = -256.06% × 0.22 × 3.41
Mar 31, 2016 -252.85% = -323.05% × 0.24 × 3.32
Dec 31, 2015 -900.97% = -362.20% × 0.34 × 7.34
Sep 30, 2015 -211.23% = -256.18% × 0.29 × 2.84
Jun 30, 2015 -105.47% = -164.21% × 0.28 × 2.27
Mar 31, 2015 -48.51% = -87.65% × 0.24 × 2.29
Dec 31, 2014 -20.83% = -39.30% × 0.25 × 2.16
Sep 30, 2014 -1.35% = -2.85% × 0.24 × 1.98
Jun 30, 2014 3.73% = 7.88% × 0.25 × 1.87
Mar 31, 2014 5.29% = 11.01% × 0.26 × 1.85
Dec 31, 2013 6.68% = 13.61% × 0.27 × 1.85
Sep 30, 2013 8.27% = 15.97% × 0.28 × 1.83
Jun 30, 2013 7.95% = 15.48% × 0.27 × 1.94
Mar 31, 2013 6.01% = 11.55% × 0.27 × 1.93
Dec 31, 2012 6.39% = 11.81% × 0.28 × 1.94
Sep 30, 2012 8.21% = 14.97% × 0.29 × 1.91
Jun 30, 2012 10.90% = 19.68% × 0.30 × 1.87
Mar 31, 2012 14.29% = 24.42% × 0.33 × 1.79
Dec 31, 2011 15.81% = 27.27% × 0.32 × 1.80
Sep 30, 2011 — = — × — × 1.70
Jun 30, 2011 — = — × — × 1.74
Mar 31, 2011 — = — × — × 1.78

Based on: 10-Q (reporting date: 2016-06-30), 10-Q (reporting date: 2016-03-31), 10-K (reporting date: 2015-12-31), 10-Q (reporting date: 2015-09-30), 10-Q (reporting date: 2015-06-30), 10-Q (reporting date: 2015-03-31), 10-K (reporting date: 2014-12-31), 10-Q (reporting date: 2014-09-30), 10-Q (reporting date: 2014-06-30), 10-Q (reporting date: 2014-03-31), 10-K (reporting date: 2013-12-31), 10-Q (reporting date: 2013-09-30), 10-Q (reporting date: 2013-06-30), 10-Q (reporting date: 2013-03-31), 10-K (reporting date: 2012-12-31), 10-Q (reporting date: 2012-09-30), 10-Q (reporting date: 2012-06-30), 10-Q (reporting date: 2012-03-31), 10-K (reporting date: 2011-12-31), 10-Q (reporting date: 2011-09-30), 10-Q (reporting date: 2011-06-30), 10-Q (reporting date: 2011-03-31).

Two-Component Disaggregation of ROA

Apache Corp., decomposition of ROA (quarterly data)

Microsoft Excel
ROA = Net Profit Margin × Asset Turnover
Jun 30, 2016 -55.38% = -256.06% × 0.22
Mar 31, 2016 -76.17% = -323.05% × 0.24
Dec 31, 2015 -122.70% = -362.20% × 0.34
Sep 30, 2015 -74.50% = -256.18% × 0.29
Jun 30, 2015 -46.43% = -164.21% × 0.28
Mar 31, 2015 -21.15% = -87.65% × 0.24
Dec 31, 2014 -9.66% = -39.30% × 0.25
Sep 30, 2014 -0.68% = -2.85% × 0.24
Jun 30, 2014 2.00% = 7.88% × 0.25
Mar 31, 2014 2.86% = 11.01% × 0.26
Dec 31, 2013 3.62% = 13.61% × 0.27
Sep 30, 2013 4.53% = 15.97% × 0.28
Jun 30, 2013 4.10% = 15.48% × 0.27
Mar 31, 2013 3.11% = 11.55% × 0.27
Dec 31, 2012 3.29% = 11.81% × 0.28
Sep 30, 2012 4.29% = 14.97% × 0.29
Jun 30, 2012 5.84% = 19.68% × 0.30
Mar 31, 2012 7.98% = 24.42% × 0.33
Dec 31, 2011 8.81% = 27.27% × 0.32
Sep 30, 2011 — = — × —
Jun 30, 2011 — = — × —
Mar 31, 2011 — = — × —

Based on: 10-Q (reporting date: 2016-06-30), 10-Q (reporting date: 2016-03-31), 10-K (reporting date: 2015-12-31), 10-Q (reporting date: 2015-09-30), 10-Q (reporting date: 2015-06-30), 10-Q (reporting date: 2015-03-31), 10-K (reporting date: 2014-12-31), 10-Q (reporting date: 2014-09-30), 10-Q (reporting date: 2014-06-30), 10-Q (reporting date: 2014-03-31), 10-K (reporting date: 2013-12-31), 10-Q (reporting date: 2013-09-30), 10-Q (reporting date: 2013-06-30), 10-Q (reporting date: 2013-03-31), 10-K (reporting date: 2012-12-31), 10-Q (reporting date: 2012-09-30), 10-Q (reporting date: 2012-06-30), 10-Q (reporting date: 2012-03-31), 10-K (reporting date: 2011-12-31), 10-Q (reporting date: 2011-09-30), 10-Q (reporting date: 2011-06-30), 10-Q (reporting date: 2011-03-31).