Analysis of Short-term (Operating) 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.
Short-term Activity Ratios (Summary)
Time Warner Cable Inc., short-term (operating) 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).
| Short-term activity ratio | Description | The company |
|---|---|---|
| Receivables turnover | An activity ratio equal to revenue divided by receivables. | Time Warner Cable Inc. receivables turnover ratio improved from Q3 2015 to Q4 2015 and from Q4 2015 to Q1 2016. |
| Payables turnover | An activity ratio calculated as cost of goods sold divided by payables. | Time Warner Cable Inc. payables turnover ratio decreased from Q3 2015 to Q4 2015 but then slightly increased from Q4 2015 to Q1 2016. |
| Short-term activity ratio | Description | The company |
|---|---|---|
| Average receivable collection period | An activity ratio equal to the number of days in the period divided by receivables turnover. | Time Warner Cable Inc. number of days of receivables outstanding improved from Q3 2015 to Q4 2015 and from Q4 2015 to Q1 2016. |
| Average payables payment period | An estimate of the average number of days it takes a company to pay its suppliers; equal to the number of days in the period divided by payables turnover ratio for the period. | Time Warner Cable Inc. number of days of payables outstanding increased from Q3 2015 to Q4 2015 but then slightly decreased from Q4 2015 to Q1 2016. |
Receivables Turnover
Time Warner Cable Inc., receivables 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) | |||||||
| Receivables, less allowances | 846) | 916) | 935) | 1,029) | 811) | 949) | 950) | 906) | 836) | 954) | 892) | 858) | 762) | 883) | 899) | 791) | 647) | 767) | 708) | 704) | 632) | |||||||
| Short-term Activity Ratio | ||||||||||||||||||||||||||||
| Receivables turnover1 | 28.50 | 25.87 | 25.04 | 22.55 | 28.37 | 24.04 | 23.79 | 24.73 | 26.59 | 23.19 | 24.70 | 25.49 | 28.51 | 24.22 | 23.24 | 25.84 | 30.88 | 25.65 | — | — | — | |||||||
| Benchmarks | ||||||||||||||||||||||||||||
| Receivables Turnover, Competitors2 | ||||||||||||||||||||||||||||
| Alphabet Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Comcast Corp. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Meta Platforms 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
Receivables turnover
= (RevenueQ1 2016
+ RevenueQ4 2015
+ RevenueQ3 2015
+ RevenueQ2 2015)
÷ Receivables, less allowances
= (6,191 + 6,072 + 5,922 + 5,926)
÷ 846 = 28.50
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Receivables turnover | An activity ratio equal to revenue divided by receivables. | Time Warner Cable Inc. receivables turnover ratio improved from Q3 2015 to Q4 2015 and from Q4 2015 to Q1 2016. |
Payables Turnover
Time Warner Cable Inc., payables 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) | ||||||||||||||||||||||||||||
| Programming and content | 1,551) | 1,446) | 1,461) | 1,489) | 1,419) | 1,318) | 1,326) | 1,341) | 1,309) | 1,231) | 1,210) | 1,234) | 1,275) | 2,565) | 2,499) | 2,474) | 2,404) | 2,283) | 2,286) | 2,297) | 2,272) | |||||||
| Accounts payable | 624) | 656) | 482) | 496) | 446) | 567) | 462) | 565) | 445) | 565) | 468) | 521) | 511) | 653) | 458) | 399) | 352) | 545) | 331) | 300) | 290) | |||||||
| Short-term Activity Ratio | ||||||||||||||||||||||||||||
| Payables turnover1 | 9.53 | 8.86 | 11.80 | 11.19 | 12.12 | 9.34 | 11.27 | 9.01 | 11.20 | 8.76 | 13.43 | 14.54 | 17.25 | 15.23 | 21.09 | 23.68 | 26.34 | 16.77 | — | — | — | |||||||
| Benchmarks | ||||||||||||||||||||||||||||
| Payables Turnover, Competitors2 | ||||||||||||||||||||||||||||
| Alphabet Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Comcast Corp. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Meta Platforms Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Netflix Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
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
Payables turnover
= (Programming and contentQ1 2016
+ Programming and contentQ4 2015
+ Programming and contentQ3 2015
+ Programming and contentQ2 2015)
÷ Accounts payable
= (1,551 + 1,446 + 1,461 + 1,489)
÷ 624 = 9.53
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Payables turnover | An activity ratio calculated as cost of goods sold divided by payables. | Time Warner Cable Inc. payables turnover ratio decreased from Q3 2015 to Q4 2015 but then slightly increased from Q4 2015 to Q1 2016. |
Working Capital Turnover
Time Warner Cable Inc., working capital 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) | ||||||||||||||||||||||||||||
| Current assets | 2,619) | 2,459) | 1,889) | 2,074) | 2,006) | 2,316) | 2,074) | 1,988) | 3,114) | 2,144) | 2,656) | 4,610) | 4,604) | 4,877) | 5,362) | 4,586) | 3,888) | 6,398) | 6,687) | 4,531) | 4,042) | |||||||
| Less: Current liabilities | 3,853) | 3,949) | 3,763) | 4,155) | 4,159) | 4,497) | 5,019) | 5,274) | 6,399) | 5,226) | 4,964) | 7,006) | 5,874) | 5,325) | 5,534) | 5,153) | 5,584) | 5,370) | 4,645) | 3,141) | 2,765) | |||||||
| Working capital | (1,234) | (1,490) | (1,874) | (2,081) | (2,153) | (2,181) | (2,945) | (3,286) | (3,285) | (3,082) | (2,308) | (2,396) | (1,270) | (448) | (172) | (567) | (1,696) | 1,028) | 2,042) | 1,390) | 1,277) | |||||||
| 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) | |||||||
| Short-term Activity Ratio | ||||||||||||||||||||||||||||
| Working capital turnover1 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | 19.14 | — | — | — | |||||||
| Benchmarks | ||||||||||||||||||||||||||||
| Working Capital 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
Working capital turnover
= (RevenueQ1 2016
+ RevenueQ4 2015
+ RevenueQ3 2015
+ RevenueQ2 2015)
÷ Working capital
= (6,191 + 6,072 + 5,922 + 5,926)
÷ -1,234 = —
2 Click competitor name to see calculations.
Average Receivable Collection Period
Time Warner Cable Inc., average receivable collection period 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 | ||||||||||||||||||||||||||||
| Receivables turnover | 28.50 | 25.87 | 25.04 | 22.55 | 28.37 | 24.04 | 23.79 | 24.73 | 26.59 | 23.19 | 24.70 | 25.49 | 28.51 | 24.22 | 23.24 | 25.84 | 30.88 | 25.65 | — | — | — | |||||||
| Short-term Activity Ratio (no. days) | ||||||||||||||||||||||||||||
| Average receivable collection period1 | 13 | 14 | 15 | 16 | 13 | 15 | 15 | 15 | 14 | 16 | 15 | 14 | 13 | 15 | 16 | 14 | 12 | 14 | — | — | — | |||||||
| Benchmarks (no. days) | ||||||||||||||||||||||||||||
| Average Receivable Collection Period, Competitors2 | ||||||||||||||||||||||||||||
| Alphabet Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Comcast Corp. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Meta Platforms 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
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 28.50 = 13
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Average receivable collection period | An activity ratio equal to the number of days in the period divided by receivables turnover. | Time Warner Cable Inc. number of days of receivables outstanding improved from Q3 2015 to Q4 2015 and from Q4 2015 to Q1 2016. |
Average Payables Payment Period
Time Warner Cable Inc., average payables payment period 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 | ||||||||||||||||||||||||||||
| Payables turnover | 9.53 | 8.86 | 11.80 | 11.19 | 12.12 | 9.34 | 11.27 | 9.01 | 11.20 | 8.76 | 13.43 | 14.54 | 17.25 | 15.23 | 21.09 | 23.68 | 26.34 | 16.77 | — | — | — | |||||||
| Short-term Activity Ratio (no. days) | ||||||||||||||||||||||||||||
| Average payables payment period1 | 38 | 41 | 31 | 33 | 30 | 39 | 32 | 41 | 33 | 42 | 27 | 25 | 21 | 24 | 17 | 15 | 14 | 22 | — | — | — | |||||||
| Benchmarks (no. days) | ||||||||||||||||||||||||||||
| Average Payables Payment Period, Competitors2 | ||||||||||||||||||||||||||||
| Alphabet Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Comcast Corp. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Meta Platforms Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Netflix Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
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
Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ 9.53 = 38
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Average payables payment period | An estimate of the average number of days it takes a company to pay its suppliers; equal to the number of days in the period divided by payables turnover ratio for the period. | Time Warner Cable Inc. number of days of payables outstanding increased from Q3 2015 to Q4 2015 but then slightly decreased from Q4 2015 to Q1 2016. |