Analysis of Long-term (Investment) Activity Ratios
Quarterly Data
Activity ratios measure how efficiently a company performs day-to-day tasks, such us the collection of receivables and management of inventory.
Long-term Activity Ratios (Summary)
Time Warner Cable Inc., long-term (investment) activity ratios (quarterly data)
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).
| 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 Cable Inc. net fixed asset turnover ratio improved from Q3 2015 to Q4 2015 but then deteriorated significantly from Q4 2015 to Q1 2016. |
| Total asset turnover | An activity ratio calculated as total revenue divided by total assets. | Time Warner Cable Inc. total asset turnover ratio improved from Q3 2015 to Q4 2015 and from Q4 2015 to Q1 2016. |
| Equity turnover | An activity ratio calculated as total revenue divided by shareholders’ equity. | Time Warner Cable Inc. equity turnover ratio deteriorated from Q3 2015 to Q4 2015 and from Q4 2015 to Q1 2016. |
Net Fixed Asset Turnover
Time Warner Cable Inc., net fixed asset turnover calculation (quarterly data)
| 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 | Dec 31, 2012 | Sep 30, 2012 | Jun 30, 2012 | Mar 31, 2012 | Dec 31, 2011 | Sep 30, 2011 | Jun 30, 2011 | Mar 31, 2011 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | ||||||||||||||||||||||||||||
| Revenue | 6,191) | 6,072) | 5,922) | 5,926) | 5,777) | 5,790) | 5,714) | 5,726) | 5,582) | 5,577) | 5,518) | 5,550) | 5,475) | 5,485) | 5,363) | 5,404) | 5,134) | 4,993) | 4,911) | 4,944) | 4,827) | |||||||
| Property, plant and equipment, net | 17,276) | 16,945) | 16,746) | 16,604) | 16,207) | 15,990) | 15,794) | 15,604) | 15,077) | 15,056) | 14,627) | 14,690) | 14,653) | 14,742) | 14,510) | 14,526) | 14,542) | 13,905) | 13,506) | 13,583) | 13,562) | |||||||
| Long-term Activity Ratio | ||||||||||||||||||||||||||||
| Net fixed asset turnover1 | 1.40 | 1.40 | 1.40 | 1.40 | 1.42 | 1.43 | 1.43 | 1.44 | 1.47 | 1.47 | 1.51 | 1.49 | 1.48 | 1.45 | 1.44 | 1.41 | 1.37 | 1.41 | — | — | — | |||||||
| Benchmarks | ||||||||||||||||||||||||||||
| Net Fixed Asset Turnover, Competitors2 | ||||||||||||||||||||||||||||
| Alphabet Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Comcast Corp. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Meta Platforms Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Netflix Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Walt Disney Co. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
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).
1 Q1 2016 Calculation
Net fixed asset turnover
= (RevenueQ1 2016
+ RevenueQ4 2015
+ RevenueQ3 2015
+ RevenueQ2 2015)
÷ Property, plant and equipment, net
= (6,191 + 6,072 + 5,922 + 5,926)
÷ 17,276 = 1.40
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 Cable Inc. net fixed asset turnover ratio improved from Q3 2015 to Q4 2015 but then deteriorated significantly from Q4 2015 to Q1 2016. |
Total Asset Turnover
Time Warner Cable Inc., total asset turnover calculation (quarterly data)
| 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 | Dec 31, 2012 | Sep 30, 2012 | Jun 30, 2012 | Mar 31, 2012 | Dec 31, 2011 | Sep 30, 2011 | Jun 30, 2011 | Mar 31, 2011 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | ||||||||||||||||||||||||||||
| Revenue | 6,191) | 6,072) | 5,922) | 5,926) | 5,777) | 5,790) | 5,714) | 5,726) | 5,582) | 5,577) | 5,518) | 5,550) | 5,475) | 5,485) | 5,363) | 5,404) | 5,134) | 4,993) | 4,911) | 4,944) | 4,827) | |||||||
| Total assets | 49,751) | 49,277) | 48,721) | 48,886) | 48,330) | 48,501) | 48,636) | 48,456) | 49,153) | 48,273) | 47,431) | 49,228) | 49,299) | 49,809) | 50,085) | 49,937) | 49,296) | 48,276) | 48,113) | 45,904) | 45,139) | |||||||
| Long-term Activity Ratio | ||||||||||||||||||||||||||||
| Total asset turnover1 | 0.48 | 0.48 | 0.48 | 0.47 | 0.48 | 0.47 | 0.46 | 0.46 | 0.45 | 0.46 | 0.46 | 0.44 | 0.44 | 0.43 | 0.42 | 0.41 | 0.41 | 0.41 | — | — | — | |||||||
| Benchmarks | ||||||||||||||||||||||||||||
| Total Asset Turnover, Competitors2 | ||||||||||||||||||||||||||||
| Alphabet Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Comcast Corp. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Meta Platforms Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Netflix Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Walt Disney Co. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
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).
1 Q1 2016 Calculation
Total asset turnover
= (RevenueQ1 2016
+ RevenueQ4 2015
+ RevenueQ3 2015
+ RevenueQ2 2015)
÷ Total assets
= (6,191 + 6,072 + 5,922 + 5,926)
÷ 49,751 = 0.48
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 Cable Inc. total asset turnover ratio improved from Q3 2015 to Q4 2015 and from Q4 2015 to Q1 2016. |
Equity Turnover
Time Warner Cable Inc., equity turnover calculation (quarterly data)
| 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 | Dec 31, 2012 | Sep 30, 2012 | Jun 30, 2012 | Mar 31, 2012 | Dec 31, 2011 | Sep 30, 2011 | Jun 30, 2011 | Mar 31, 2011 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | ||||||||||||||||||||||||||||
| Revenue | 6,191) | 6,072) | 5,922) | 5,926) | 5,777) | 5,790) | 5,714) | 5,726) | 5,582) | 5,577) | 5,518) | 5,550) | 5,475) | 5,485) | 5,363) | 5,404) | 5,134) | 4,993) | 4,911) | 4,944) | 4,827) | |||||||
| Total TWC shareholders’ equity | 9,357) | 8,995) | 8,745) | 8,508) | 8,140) | 8,013) | 7,905) | 7,410) | 7,094) | 6,943) | 6,662) | 6,708) | 6,938) | 7,279) | 7,609) | 7,357) | 7,518) | 7,530) | 7,647) | 8,041) | 8,632) | |||||||
| Long-term Activity Ratio | ||||||||||||||||||||||||||||
| Equity turnover1 | 2.58 | 2.63 | 2.68 | 2.73 | 2.83 | 2.85 | 2.86 | 3.02 | 3.13 | 3.19 | 3.31 | 3.26 | 3.13 | 2.94 | 2.75 | 2.78 | 2.66 | 2.61 | — | — | — | |||||||
| Benchmarks | ||||||||||||||||||||||||||||
| Equity Turnover, Competitors2 | ||||||||||||||||||||||||||||
| Alphabet Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Comcast Corp. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Meta Platforms Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Netflix Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Walt Disney Co. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
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).
1 Q1 2016 Calculation
Equity turnover
= (RevenueQ1 2016
+ RevenueQ4 2015
+ RevenueQ3 2015
+ RevenueQ2 2015)
÷ Total TWC shareholders’ equity
= (6,191 + 6,072 + 5,922 + 5,926)
÷ 9,357 = 2.58
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 Cable Inc. equity turnover ratio deteriorated from Q3 2015 to Q4 2015 and from Q4 2015 to Q1 2016. |