Stock Analysis on Net
Stock Analysis on Net

Time Warner Cable Inc. (NYSE:TWC)

This company has been moved to the archive! The financial data has not been updated since April 28, 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

Time Warner Cable Inc., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = ROA × Financial Leverage
Mar 31, 2016 20.09% = 3.78% × 5.32
Dec 31, 2015 20.50% = 3.74% × 5.48
Sep 30, 2015 21.86% = 3.92% × 5.57
Jun 30, 2015 23.20% = 4.04% × 5.75
Mar 31, 2015 24.69% = 4.16% × 5.94
Dec 31, 2014 25.35% = 4.19% × 6.05
Sep 30, 2014 25.52% = 4.15% × 6.15
Jun 30, 2014 27.67% = 4.23% × 6.54
Mar 31, 2014 28.64% = 4.13% × 6.93
Dec 31, 2013 28.14% = 4.05% × 6.95
Sep 30, 2013 28.93% = 4.06% × 7.12
Jun 30, 2013 32.84% = 4.48% × 7.34
Mar 31, 2013 31.33% = 4.41% × 7.11
Dec 31, 2012 29.61% = 4.33% × 6.84
Sep 30, 2012 28.99% = 4.40% × 6.58
Jun 30, 2012 23.84% = 3.51% × 6.79
Mar 31, 2012 22.91% = 3.49% × 6.56
Dec 31, 2011 22.11% = 3.45% × 6.41
Sep 30, 2011 — = — × 6.29
Jun 30, 2011 — = — × 5.71
Mar 31, 2011 — = — × 5.23

Based on: 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).

The primary reason for the decrease in return on equity ratio (ROE) over Q1 2016 is the decrease in financial leverage ratio.

Three-Component Disaggregation of ROE

Time Warner Cable Inc., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = Net Profit Margin × Asset Turnover × Financial Leverage
Mar 31, 2016 20.09% = 7.80% × 0.48 × 5.32
Dec 31, 2015 20.50% = 7.78% × 0.48 × 5.48
Sep 30, 2015 21.86% = 8.17% × 0.48 × 5.57
Jun 30, 2015 23.20% = 8.51% × 0.47 × 5.75
Mar 31, 2015 24.69% = 8.74% × 0.48 × 5.94
Dec 31, 2014 25.35% = 8.90% × 0.47 × 6.05
Sep 30, 2014 25.52% = 8.93% × 0.46 × 6.15
Jun 30, 2014 27.67% = 9.15% × 0.46 × 6.54
Mar 31, 2014 28.64% = 9.14% × 0.45 × 6.93
Dec 31, 2013 28.14% = 8.83% × 0.46 × 6.95
Sep 30, 2013 28.93% = 8.75% × 0.46 × 7.12
Jun 30, 2013 32.84% = 10.07% × 0.44 × 7.34
Mar 31, 2013 31.33% = 10.01% × 0.44 × 7.11
Dec 31, 2012 29.61% = 10.08% × 0.43 × 6.84
Sep 30, 2012 28.99% = 10.56% × 0.42 × 6.58
Jun 30, 2012 23.84% = 8.58% × 0.41 × 6.79
Mar 31, 2012 22.91% = 8.62% × 0.41 × 6.56
Dec 31, 2011 22.11% = 8.46% × 0.41 × 6.41
Sep 30, 2011 — = — × — × 6.29
Jun 30, 2011 — = — × — × 5.71
Mar 31, 2011 — = — × — × 5.23

Based on: 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).

The primary reason for the decrease in return on equity ratio (ROE) over Q1 2016 is the decrease in financial leverage ratio.

Two-Component Disaggregation of ROA

Time Warner Cable Inc., decomposition of ROA (quarterly data)

Microsoft Excel
ROA = Net Profit Margin × Asset Turnover
Mar 31, 2016 3.78% = 7.80% × 0.48
Dec 31, 2015 3.74% = 7.78% × 0.48
Sep 30, 2015 3.92% = 8.17% × 0.48
Jun 30, 2015 4.04% = 8.51% × 0.47
Mar 31, 2015 4.16% = 8.74% × 0.48
Dec 31, 2014 4.19% = 8.90% × 0.47
Sep 30, 2014 4.15% = 8.93% × 0.46
Jun 30, 2014 4.23% = 9.15% × 0.46
Mar 31, 2014 4.13% = 9.14% × 0.45
Dec 31, 2013 4.05% = 8.83% × 0.46
Sep 30, 2013 4.06% = 8.75% × 0.46
Jun 30, 2013 4.48% = 10.07% × 0.44
Mar 31, 2013 4.41% = 10.01% × 0.44
Dec 31, 2012 4.33% = 10.08% × 0.43
Sep 30, 2012 4.40% = 10.56% × 0.42
Jun 30, 2012 3.51% = 8.58% × 0.41
Mar 31, 2012 3.49% = 8.62% × 0.41
Dec 31, 2011 3.45% = 8.46% × 0.41
Sep 30, 2011 — = — × —
Jun 30, 2011 — = — × —
Mar 31, 2011 — = — × —

Based on: 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).

The primary reason for the increase in return on assets ratio (ROA) over Q1 2016 is the increase in asset turnover ratio.