Stock Analysis on Net

Time Warner Inc. (NYSE:TWX)

$22.49

This company has been moved to the archive! The financial data has not been updated since April 26, 2018.

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

Microsoft Excel

Paying user area


We accept:

Visa Mastercard American Express Maestro Discover JCB PayPal Google Pay
Visa Secure Mastercard Identity Check American Express SafeKey

Two-Component Disaggregation of ROE

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

Microsoft Excel
ROE = ROA × Financial Leverage
Mar 31, 2018 = ×
Dec 31, 2017 = ×
Sep 30, 2017 = ×
Jun 30, 2017 = ×
Mar 31, 2017 = ×
Dec 31, 2016 = ×
Sep 30, 2016 = ×
Jun 30, 2016 = ×
Mar 31, 2016 = ×
Dec 31, 2015 = ×
Sep 30, 2015 = ×
Jun 30, 2015 = ×
Mar 31, 2015 = ×
Dec 31, 2014 = ×
Sep 30, 2014 = ×
Jun 30, 2014 = ×
Mar 31, 2014 = ×
Dec 31, 2013 = ×
Sep 30, 2013 = ×
Jun 30, 2013 = ×
Mar 31, 2013 = ×

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


The analysis of the financial ratios for the periods from March 2013 through March 2018 reveals notable trends in the company's profitability and leverage metrics.

Return on Assets (ROA)
ROA data begins from March 2014. Initially, the ROA was 5.43%, and it increased steadily over the following quarters, reaching peaks around 6.68% in September 2014 and approximately 6.83% in December 2016. The ratio fluctuates moderately in subsequent quarters but maintains values above 5.5%, generally trending upward. The highest values are observed in the first quarter of 2018, where ROA reaches 7.58% and then 7.92%, indicating improved efficiency in using assets to generate profit.
Financial Leverage
The financial leverage ratio demonstrates a slow but steady upward trend from 2.22 in the early quarters of 2013 to a peak of 2.71 in December 2016. After this peak, leverage gradually declines to 2.31 by March 2018. This pattern suggests an initial increase in debt utilization or asset base expansion relative to equity, followed by a cautious reduction in leverage over the last four quarters observed.
Return on Equity (ROE)
ROE data covers the same period as ROA. It starts at 12.34% in March 2014 and shows a fairly consistent upward trajectory, reaching a high of 18.49% in December 2016. Following this peak, ROE experiences some volatility but remains elevated, with values around 16-18% through the end of the period. The highest ROE reading is observed in the first quarter of 2018 at 18.49%, followed by a slight dip to 18.34%. This indicates strong returns to shareholders, supported by the combination of increased asset efficiency and manageable leverage levels.

Overall, the data indicate an improving profitability trend for the company, exemplified by rising ROA and ROE. The leverage peaked around late 2016 but has been reduced modestly since, potentially reflecting a strategic adjustment in capital structure to balance growth and financial risk.


Three-Component Disaggregation of ROE

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

Microsoft Excel
ROE = Net Profit Margin × Asset Turnover × Financial Leverage
Mar 31, 2018 = × ×
Dec 31, 2017 = × ×
Sep 30, 2017 = × ×
Jun 30, 2017 = × ×
Mar 31, 2017 = × ×
Dec 31, 2016 = × ×
Sep 30, 2016 = × ×
Jun 30, 2016 = × ×
Mar 31, 2016 = × ×
Dec 31, 2015 = × ×
Sep 30, 2015 = × ×
Jun 30, 2015 = × ×
Mar 31, 2015 = × ×
Dec 31, 2014 = × ×
Sep 30, 2014 = × ×
Jun 30, 2014 = × ×
Mar 31, 2014 = × ×
Dec 31, 2013 = × ×
Sep 30, 2013 = × ×
Jun 30, 2013 = × ×
Mar 31, 2013 = × ×

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


The analysis of the quarterly financial data reveals several notable trends in profitability, efficiency, and financial structure over the observed periods.

Net Profit Margin
The net profit margin shows a generally positive and stable trend starting from March 31, 2014. Initially, the margin increases from 12.39% to peak at 15.75% by September 30, 2016. After this peak, the margin experiences slight fluctuations but remains robust, with a notable increase toward the end of the period, reaching 17.33% by March 31, 2018. This indicates an improvement in the company’s ability to convert revenue into profit over time, with some minor volatility.
Asset Turnover
The asset turnover ratio remains relatively stable throughout the periods with values fluctuating narrowly between 0.43 and 0.46. This stability suggests that the efficiency of asset utilization in generating sales has been maintained consistently without significant improvements or declines.
Financial Leverage
Financial leverage ratios indicate some variability. The leverage starts at around 2.23 in early 2013 and gradually increases, peaking at 2.71 around September and December 2016. Subsequently, there is a downward trend in financial leverage, declining steadily to 2.31 by March 31, 2018. The increase in leverage through 2016 points to greater use of debt or liabilities in financing assets, followed by a reduction indicative of deleveraging efforts or changes in capital structure.
Return on Equity (ROE)
Return on Equity demonstrates a consistent upward trend from 12.34% in March 2014 to a high of 18.49% by December 2016, reflecting improved overall profitability and effective use of shareholders’ equity. After 2016, ROE slightly declines and fluctuates but remains strong, ending at 18.34% by March 2018. This pattern indicates a generally healthy return to shareholders with periods of minor variability.

In summary, the company exhibits strengthening profitability metrics over the timeframe, with net profit margins and ROE improving notably. Asset turnover remains steady, indicating consistent operational efficiency. The pattern in financial leverage shows an increase followed by a reduction, suggesting shifts in capital structure management strategies. Overall, the financial data reflect positive performance trends with sound profitability and controlled leverage.


Two-Component Disaggregation of ROA

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

Microsoft Excel
ROA = Net Profit Margin × Asset Turnover
Mar 31, 2018 = ×
Dec 31, 2017 = ×
Sep 30, 2017 = ×
Jun 30, 2017 = ×
Mar 31, 2017 = ×
Dec 31, 2016 = ×
Sep 30, 2016 = ×
Jun 30, 2016 = ×
Mar 31, 2016 = ×
Dec 31, 2015 = ×
Sep 30, 2015 = ×
Jun 30, 2015 = ×
Mar 31, 2015 = ×
Dec 31, 2014 = ×
Sep 30, 2014 = ×
Jun 30, 2014 = ×
Mar 31, 2014 = ×
Dec 31, 2013 = ×
Sep 30, 2013 = ×
Jun 30, 2013 = ×
Mar 31, 2013 = ×

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


Net Profit Margin
The net profit margin shows a positive trend over the observed periods. Starting at 12.39% in March 2014, it generally increased with minor fluctuations, reaching 17.33% by March 2018. The margin held relatively stable around 13% to 15% from mid-2014 through 2016, before showing a more pronounced upward trend during 2017 and early 2018. This indicates improving profitability relative to revenues over time.
Asset Turnover
The asset turnover ratio remained fairly consistent throughout the periods under review. Beginning at 0.44 in March 2014, it fluctuated slightly but stayed within a narrow range from 0.43 to 0.46. This stability suggests that the efficiency in using assets to generate sales did not undergo significant change during the timeframe, maintaining a moderate level of asset utilization.
Return on Assets (ROA)
The return on assets exhibited a gradual upward trend with some intermittent variability. Starting at 5.43% in March 2014, ROA increased to about 7.92% by March 2018. Although there were small declines and recoveries within some quarters, the overall movement points to enhanced effectiveness in converting assets into net income over the analyzed years.