Stock Analysis on Net

Time Warner Inc. (NYSE:TWX)

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

Analysis of Long-term (Investment) Activity Ratios
Quarterly Data

Microsoft Excel

Long-term Activity Ratios (Summary)

Time Warner Inc., long-term (investment) activity ratios (quarterly data)

Microsoft Excel
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
Net fixed asset turnover 11.45 11.55 11.96 12.23 12.08 11.68 11.49 11.09 11.12 10.83 11.12 11.00 10.73 10.30 10.60 10.68 9.21 7.79
Total asset turnover 0.46 0.45 0.45 0.46 0.45 0.44 0.43 0.44 0.45 0.44 0.46 0.45 0.45 0.43 0.45 0.45 0.43 0.44
Equity turnover 1.06 1.10 1.12 1.16 1.17 1.20 1.17 1.17 1.19 1.19 1.21 1.18 1.14 1.12 1.13 1.12 0.99 1.00

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

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Time Warner Inc. net fixed asset turnover ratio deteriorated from Q3 2017 to Q4 2017 and from Q4 2017 to Q1 2018.
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Time Warner Inc. total asset turnover ratio improved from Q3 2017 to Q4 2017 and from Q4 2017 to Q1 2018.
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Time Warner Inc. equity turnover ratio deteriorated from Q3 2017 to Q4 2017 and from Q4 2017 to Q1 2018.

Net Fixed Asset Turnover

Time Warner Inc., net fixed asset turnover calculation (quarterly data)

Microsoft Excel
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
Selected Financial Data (US$ in millions)
Revenues 7,996 8,611 7,595 7,330 7,735 7,891 7,167 6,952 7,308 7,079 6,564 7,348 7,127 7,525 6,243 6,788 6,803 8,565 6,856 7,435 6,939
Property, plant and equipment, net 2,753 2,707 2,555 2,464 2,462 2,510 2,482 2,516 2,546 2,596 2,569 2,567 2,580 2,655 2,678 2,716 3,219 3,825 3,692 3,704 3,769
Long-term Activity Ratio
Net fixed asset turnover1 11.45 11.55 11.96 12.23 12.08 11.68 11.49 11.09 11.12 10.83 11.12 11.00 10.73 10.30 10.60 10.68 9.21 7.79
Benchmarks
Net Fixed Asset Turnover, Competitors2
Alphabet Inc.
Comcast Corp.
Meta Platforms Inc.
Netflix Inc.
Walt Disney Co.

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

1 Q1 2018 Calculation
Net fixed asset turnover = (RevenuesQ1 2018 + RevenuesQ4 2017 + RevenuesQ3 2017 + RevenuesQ2 2017) ÷ Property, plant and equipment, net
= (7,996 + 8,611 + 7,595 + 7,330) ÷ 2,753 = 11.45

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Time Warner Inc. net fixed asset turnover ratio deteriorated from Q3 2017 to Q4 2017 and from Q4 2017 to Q1 2018.

Total Asset Turnover

Time Warner Inc., total asset turnover calculation (quarterly data)

Microsoft Excel
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
Selected Financial Data (US$ in millions)
Revenues 7,996 8,611 7,595 7,330 7,735 7,891 7,167 6,952 7,308 7,079 6,564 7,348 7,127 7,525 6,243 6,788 6,803 8,565 6,856 7,435 6,939
Total assets 68,997 69,209 68,343 66,096 65,649 65,966 65,764 64,127 63,254 63,848 62,674 63,425 62,195 63,259 63,095 64,490 68,199 67,994 66,453 66,322 66,947
Long-term Activity Ratio
Total asset turnover1 0.46 0.45 0.45 0.46 0.45 0.44 0.43 0.44 0.45 0.44 0.46 0.45 0.45 0.43 0.45 0.45 0.43 0.44
Benchmarks
Total Asset Turnover, Competitors2
Alphabet Inc.
Comcast Corp.
Meta Platforms Inc.
Netflix Inc.
Walt Disney Co.

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

1 Q1 2018 Calculation
Total asset turnover = (RevenuesQ1 2018 + RevenuesQ4 2017 + RevenuesQ3 2017 + RevenuesQ2 2017) ÷ Total assets
= (7,996 + 8,611 + 7,595 + 7,330) ÷ 68,997 = 0.46

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Time Warner Inc. total asset turnover ratio improved from Q3 2017 to Q4 2017 and from Q4 2017 to Q1 2018.

Equity Turnover

Time Warner Inc., equity turnover calculation (quarterly data)

Microsoft Excel
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
Selected Financial Data (US$ in millions)
Revenues 7,996 8,611 7,595 7,330 7,735 7,891 7,167 6,952 7,308 7,079 6,564 7,348 7,127 7,525 6,243 6,788 6,803 8,565 6,856 7,435 6,939
Total Time Warner Inc. shareholders’ equity 29,805 28,375 27,267 25,987 25,425 24,335 24,278 23,888 23,843 23,619 23,648 24,025 24,198 24,476 25,230 25,907 30,044 29,904 29,929 29,782 29,991
Long-term Activity Ratio
Equity turnover1 1.06 1.10 1.12 1.16 1.17 1.20 1.17 1.17 1.19 1.19 1.21 1.18 1.14 1.12 1.13 1.12 0.99 1.00
Benchmarks
Equity Turnover, Competitors2
Alphabet Inc.
Comcast Corp.
Meta Platforms Inc.
Netflix Inc.
Walt Disney Co.

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

1 Q1 2018 Calculation
Equity turnover = (RevenuesQ1 2018 + RevenuesQ4 2017 + RevenuesQ3 2017 + RevenuesQ2 2017) ÷ Total Time Warner Inc. shareholders’ equity
= (7,996 + 8,611 + 7,595 + 7,330) ÷ 29,805 = 1.06

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Time Warner Inc. equity turnover ratio deteriorated from Q3 2017 to Q4 2017 and from Q4 2017 to Q1 2018.