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

Anadarko Petroleum Corp., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = ROA × Financial Leverage
Sep 30, 2017 -18.06% = -4.51% × 4.00
Jun 30, 2017 -18.11% = -4.69% × 3.87
Mar 31, 2017 -19.86% = -5.27% × 3.77
Dec 31, 2016 -25.15% = -6.74% × 3.73
Sep 30, 2016 -30.21% = -8.38% × 3.60
Jun 30, 2016 -46.19% = -11.83% × 3.90
Mar 31, 2016 -38.15% = -9.30% × 4.10
Dec 31, 2015 -52.20% = -14.42% × 3.62
Sep 30, 2015 -41.46% = -11.87% × 3.49
Jun 30, 2015 -15.35% = -4.83% × 3.18
Mar 31, 2015 -14.38% = -4.43% × 3.24
Dec 31, 2014 -8.87% = -2.84% × 3.13
Sep 30, 2014 -10.28% = -3.50% × 2.93
Jun 30, 2014 -15.67% = -5.19% × 3.02
Mar 31, 2014 -12.18% = -4.01% × 3.04
Dec 31, 2013 3.66% = 1.44% × 2.55
Sep 30, 2013 7.94% = 3.21% × 2.47
Jun 30, 2013 7.72% = 3.10% × 2.49
Mar 31, 2013 3.30% = 1.30% × 2.54
Dec 31, 2012 11.59% = 4.55% × 2.55
Sep 30, 2012 — = — × 2.59
Jun 30, 2012 — = — × 2.64
Mar 31, 2012 — = — × 2.69

Based on: 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31), 10-K (reporting date: 2016-12-31), 10-Q (reporting date: 2016-09-30), 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).

Three-Component Disaggregation of ROE

Anadarko Petroleum Corp., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = Net Profit Margin × Asset Turnover × Financial Leverage
Sep 30, 2017 -18.06% = -18.54% × 0.24 × 4.00
Jun 30, 2017 -18.11% = -20.48% × 0.23 × 3.87
Mar 31, 2017 -19.86% = -24.25% × 0.22 × 3.77
Dec 31, 2016 -25.15% = -36.36% × 0.19 × 3.73
Sep 30, 2016 -30.21% = -48.15% × 0.17 × 3.60
Jun 30, 2016 -46.19% = -66.10% × 0.18 × 3.90
Mar 31, 2016 -38.15% = -52.23% × 0.18 × 4.10
Dec 31, 2015 -52.20% = -70.55% × 0.20 × 3.62
Sep 30, 2015 -41.46% = -53.68% × 0.22 × 3.49
Jun 30, 2015 -15.35% = -19.54% × 0.25 × 3.18
Mar 31, 2015 -14.38% = -16.06% × 0.28 × 3.24
Dec 31, 2014 -8.87% = -10.69% × 0.27 × 3.13
Sep 30, 2014 -10.28% = -12.59% × 0.28 × 2.93
Jun 30, 2014 -15.67% = -18.44% × 0.28 × 3.02
Mar 31, 2014 -12.18% = -15.03% × 0.27 × 3.04
Dec 31, 2013 3.66% = 5.39% × 0.27 × 2.55
Sep 30, 2013 7.94% = 12.35% × 0.26 × 2.47
Jun 30, 2013 7.72% = 12.37% × 0.25 × 2.49
Mar 31, 2013 3.30% = 5.11% × 0.25 × 2.54
Dec 31, 2012 11.59% = 17.97% × 0.25 × 2.55
Sep 30, 2012 — = — × — × 2.59
Jun 30, 2012 — = — × — × 2.64
Mar 31, 2012 — = — × — × 2.69

Based on: 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31), 10-K (reporting date: 2016-12-31), 10-Q (reporting date: 2016-09-30), 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).

Five-Component Disaggregation of ROE

Anadarko Petroleum Corp., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover × Financial Leverage
Sep 30, 2017 -18.06% = — × — × -13.94% × 0.24 × 4.00
Jun 30, 2017 -18.11% = — × — × -14.19% × 0.23 × 3.87
Mar 31, 2017 -19.86% = — × — × -20.63% × 0.22 × 3.77
Dec 31, 2016 -25.15% = — × — × -37.91% × 0.19 × 3.73
Sep 30, 2016 -30.21% = — × — × -57.46% × 0.17 × 3.60
Jun 30, 2016 -46.19% = — × — × -84.04% × 0.18 × 3.90
Mar 31, 2016 -38.15% = — × — × -64.41% × 0.18 × 4.10
Dec 31, 2015 -52.20% = — × — × -92.18% × 0.20 × 3.62
Sep 30, 2015 -41.46% = — × — × -67.65% × 0.22 × 3.49
Jun 30, 2015 -15.35% = — × — × -19.30% × 0.25 × 3.18
Mar 31, 2015 -14.38% = — × — × -13.56% × 0.28 × 3.24
Dec 31, 2014 -8.87% = — × -0.21 × 3.90% × 0.27 × 3.13
Sep 30, 2014 -10.28% = — × -2.08 × 1.43% × 0.28 × 2.93
Jun 30, 2014 -15.67% = — × — × -6.55% × 0.28 × 3.02
Mar 31, 2014 -12.18% = — × — × -1.61% × 0.27 × 3.04
Dec 31, 2013 3.66% = 0.41 × 0.74 × 17.84% × 0.27 × 2.55
Sep 30, 2013 7.94% = 0.52 × 0.83 × 28.46% × 0.26 × 2.47
Jun 30, 2013 7.72% = 0.51 × 0.83 × 29.18% × 0.25 × 2.49
Mar 31, 2013 3.30% = 0.36 × 0.73 × 19.39% × 0.25 × 2.54
Dec 31, 2012 11.59% = 0.68 × 0.83 × 31.96% × 0.25 × 2.55
Sep 30, 2012 — = — × — × — × — × 2.59
Jun 30, 2012 — = — × — × — × — × 2.64
Mar 31, 2012 — = — × — × — × — × 2.69

Based on: 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31), 10-K (reporting date: 2016-12-31), 10-Q (reporting date: 2016-09-30), 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).

Two-Component Disaggregation of ROA

Anadarko Petroleum Corp., decomposition of ROA (quarterly data)

Microsoft Excel
ROA = Net Profit Margin × Asset Turnover
Sep 30, 2017 -4.51% = -18.54% × 0.24
Jun 30, 2017 -4.69% = -20.48% × 0.23
Mar 31, 2017 -5.27% = -24.25% × 0.22
Dec 31, 2016 -6.74% = -36.36% × 0.19
Sep 30, 2016 -8.38% = -48.15% × 0.17
Jun 30, 2016 -11.83% = -66.10% × 0.18
Mar 31, 2016 -9.30% = -52.23% × 0.18
Dec 31, 2015 -14.42% = -70.55% × 0.20
Sep 30, 2015 -11.87% = -53.68% × 0.22
Jun 30, 2015 -4.83% = -19.54% × 0.25
Mar 31, 2015 -4.43% = -16.06% × 0.28
Dec 31, 2014 -2.84% = -10.69% × 0.27
Sep 30, 2014 -3.50% = -12.59% × 0.28
Jun 30, 2014 -5.19% = -18.44% × 0.28
Mar 31, 2014 -4.01% = -15.03% × 0.27
Dec 31, 2013 1.44% = 5.39% × 0.27
Sep 30, 2013 3.21% = 12.35% × 0.26
Jun 30, 2013 3.10% = 12.37% × 0.25
Mar 31, 2013 1.30% = 5.11% × 0.25
Dec 31, 2012 4.55% = 17.97% × 0.25
Sep 30, 2012 — = — × —
Jun 30, 2012 — = — × —
Mar 31, 2012 — = — × —

Based on: 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31), 10-K (reporting date: 2016-12-31), 10-Q (reporting date: 2016-09-30), 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).

Four-Component Disaggregation of ROA

Anadarko Petroleum Corp., decomposition of ROA (quarterly data)

Microsoft Excel
ROA = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover
Sep 30, 2017 -4.51% = — × — × -13.94% × 0.24
Jun 30, 2017 -4.69% = — × — × -14.19% × 0.23
Mar 31, 2017 -5.27% = — × — × -20.63% × 0.22
Dec 31, 2016 -6.74% = — × — × -37.91% × 0.19
Sep 30, 2016 -8.38% = — × — × -57.46% × 0.17
Jun 30, 2016 -11.83% = — × — × -84.04% × 0.18
Mar 31, 2016 -9.30% = — × — × -64.41% × 0.18
Dec 31, 2015 -14.42% = — × — × -92.18% × 0.20
Sep 30, 2015 -11.87% = — × — × -67.65% × 0.22
Jun 30, 2015 -4.83% = — × — × -19.30% × 0.25
Mar 31, 2015 -4.43% = — × — × -13.56% × 0.28
Dec 31, 2014 -2.84% = — × -0.21 × 3.90% × 0.27
Sep 30, 2014 -3.50% = — × -2.08 × 1.43% × 0.28
Jun 30, 2014 -5.19% = — × — × -6.55% × 0.28
Mar 31, 2014 -4.01% = — × — × -1.61% × 0.27
Dec 31, 2013 1.44% = 0.41 × 0.74 × 17.84% × 0.27
Sep 30, 2013 3.21% = 0.52 × 0.83 × 28.46% × 0.26
Jun 30, 2013 3.10% = 0.51 × 0.83 × 29.18% × 0.25
Mar 31, 2013 1.30% = 0.36 × 0.73 × 19.39% × 0.25
Dec 31, 2012 4.55% = 0.68 × 0.83 × 31.96% × 0.25
Sep 30, 2012 — = — × — × — × —
Jun 30, 2012 — = — × — × — × —
Mar 31, 2012 — = — × — × — × —

Based on: 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31), 10-K (reporting date: 2016-12-31), 10-Q (reporting date: 2016-09-30), 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).

Disaggregation of Net Profit Margin

Anadarko Petroleum Corp., decomposition of net profit margin ratio (quarterly data)

Microsoft Excel
Net Profit Margin = Tax Burden × Interest Burden × EBIT Margin
Sep 30, 2017 -18.54% = — × — × -13.94%
Jun 30, 2017 -20.48% = — × — × -14.19%
Mar 31, 2017 -24.25% = — × — × -20.63%
Dec 31, 2016 -36.36% = — × — × -37.91%
Sep 30, 2016 -48.15% = — × — × -57.46%
Jun 30, 2016 -66.10% = — × — × -84.04%
Mar 31, 2016 -52.23% = — × — × -64.41%
Dec 31, 2015 -70.55% = — × — × -92.18%
Sep 30, 2015 -53.68% = — × — × -67.65%
Jun 30, 2015 -19.54% = — × — × -19.30%
Mar 31, 2015 -16.06% = — × — × -13.56%
Dec 31, 2014 -10.69% = — × -0.21 × 3.90%
Sep 30, 2014 -12.59% = — × -2.08 × 1.43%
Jun 30, 2014 -18.44% = — × — × -6.55%
Mar 31, 2014 -15.03% = — × — × -1.61%
Dec 31, 2013 5.39% = 0.41 × 0.74 × 17.84%
Sep 30, 2013 12.35% = 0.52 × 0.83 × 28.46%
Jun 30, 2013 12.37% = 0.51 × 0.83 × 29.18%
Mar 31, 2013 5.11% = 0.36 × 0.73 × 19.39%
Dec 31, 2012 17.97% = 0.68 × 0.83 × 31.96%
Sep 30, 2012 — = — × — × —
Jun 30, 2012 — = — × — × —
Mar 31, 2012 — = — × — × —

Based on: 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31), 10-K (reporting date: 2016-12-31), 10-Q (reporting date: 2016-09-30), 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).