AI Tokens
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.

Analysis of Short-term (Operating) Activity Ratios

Microsoft Excel

Short-term Activity Ratios (Summary)

Turnover Ratios

Average No. Days

Time Warner Cable Inc., short-term (operating) activity ratios

Microsoft Excel
Dec 31, 2015 Dec 31, 2014 Dec 31, 2013 Dec 31, 2012 Dec 31, 2011
Turnover Ratios
Receivables turnover 25.87 24.04 23.19 24.22 25.65
Payables turnover 8.86 9.34 8.76 7.20 16.77
Working capital turnover — — — — 19.14
Average No. Days
Average receivable collection period 14 15 16 15 14
Average payables payment period 41 39 42 51 22

Based on: 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31), 10-K (reporting date: 2013-12-31), 10-K (reporting date: 2012-12-31), 10-K (reporting date: 2011-12-31).


An analysis of the operating activity ratios indicates a high level of stability in receivables management contrasted by a significant shift in payables strategy between 2011 and 2015.

Receivables Management
The receivables turnover ratio remained relatively stable over the five-year period, fluctuating between a low of 23.19 in 2013 and a high of 25.87 in 2015. This stability is mirrored in the average receivable collection period, which consistently ranged between 14 and 16 days. These figures suggest a highly efficient and consistent credit collection process, ensuring that cash is recovered from customers in approximately two weeks.
Payables Management
A pronounced shift in payables activity occurred after 2011. The payables turnover ratio decreased sharply from 16.77 in 2011 to 7.20 in 2012, subsequently stabilizing between 8.76 and 9.34 through 2015. Correspondingly, the average payables payment period expanded from 22 days in 2011 to a peak of 51 days in 2012, before settling into a range of 39 to 42 days. This trend indicates a strategic extension of payment terms to suppliers, which increases the company's reliance on trade credit to finance short-term operations.
Overall Operational Efficiency
The divergence between the stable, short collection cycle and the lengthened payment cycle suggests an improvement in the company's cash conversion cycle. By collecting receivables faster than it settles its obligations to suppliers, the entity has effectively optimized its short-term liquidity position.

AI Ask an analyst for more

Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.
Without a user account, I tend to respond rather slowly.

How can I help you?


Receivables Turnover

Time Warner Cable Inc., receivables turnover calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2015 Dec 31, 2014 Dec 31, 2013 Dec 31, 2012 Dec 31, 2011
Selected Financial Data (US$ in millions)
Revenue 23,697 22,812 22,120 21,386 19,675
Receivables, less allowances 916 949 954 883 767
Short-term Activity Ratio
Receivables turnover1 25.87 24.04 23.19 24.22 25.65
Benchmarks
Receivables Turnover, Competitors2
Alphabet Inc. — — — — —
Comcast Corp. — — — — —
Meta Platforms Inc. — — — — —
Netflix Inc. — — — — —
Walt Disney Co. — — — — —

Based on: 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31), 10-K (reporting date: 2013-12-31), 10-K (reporting date: 2012-12-31), 10-K (reporting date: 2011-12-31).

1 2015 Calculation
Receivables turnover = Revenue ÷ Receivables, less allowances
= 23,697 ÷ 916 = 25.87

2 Click competitor name to see calculations.


Revenue experienced a consistent upward trajectory from 2011 to 2015, increasing from 19,675 million US$ to 23,697 million US$. During the first three years of this period, receivables, less allowances, also rose, peaking at 954 million US$ in 2013 before beginning a gradual decline to 916 million US$ by the end of 2015.

Receivables Turnover Trend
The receivables turnover ratio exhibited a U-shaped pattern over the five-year period. A decline was observed between 2011 and 2013, where the ratio dropped from 25.65 to 23.19, suggesting a marginal decrease in the efficiency of credit collection relative to sales growth. However, this trend reversed starting in 2014, with the ratio recovering to 24.04 and eventually reaching a period high of 25.87 in 2015.
Operating Efficiency Analysis
The correlation between increasing revenue and decreasing net receivables from 2013 to 2015 indicates an improvement in the company's short-term asset management. The increase in the turnover ratio to 25.87 by 2015 suggests that receivables are being converted into cash more rapidly than in previous years, effectively offsetting the growth in total sales volume.
Collection Cycle Implications
The stability of the turnover ratio, which remained within a tight range of 23.19 to 25.87, reflects a consistent credit policy. The final increase in 2015 demonstrates an optimized collection cycle, as the company managed to increase its annual revenue while simultaneously reducing the absolute value of outstanding receivables.

AI Ask an analyst for more

Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.
Without a user account, I tend to respond rather slowly.

How can I help you?


Payables Turnover

Time Warner Cable Inc., payables turnover calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2015 Dec 31, 2014 Dec 31, 2013 Dec 31, 2012 Dec 31, 2011
Selected Financial Data (US$ in millions)
Programming and content 5,815 5,294 4,950 4,703 9,138
Accounts payable 656 567 565 653 545
Short-term Activity Ratio
Payables turnover1 8.86 9.34 8.76 7.20 16.77
Benchmarks
Payables Turnover, Competitors2
Alphabet Inc. — — — — —
Comcast Corp. — — — — —
Meta Platforms Inc. — — — — —
Netflix Inc. — — — — —
Walt Disney Co. — — — — —

Based on: 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31), 10-K (reporting date: 2013-12-31), 10-K (reporting date: 2012-12-31), 10-K (reporting date: 2011-12-31).

1 2015 Calculation
Payables turnover = Programming and content ÷ Accounts payable
= 5,815 ÷ 656 = 8.86

2 Click competitor name to see calculations.


The analysis of short-term operating activity reveals a significant shift in payables management between 2011 and 2015, characterized by an initial sharp decline in turnover followed by a period of relative stabilization.

Payables Turnover Trends
A substantial reduction in the payables turnover ratio occurred between 2011 and 2012, falling from 16.77 to 7.20. This indicates a marked change in the frequency with which obligations to suppliers were settled. Following this decline, the ratio experienced a moderate recovery and stabilization, peaking at 9.34 in 2014 before slightly receding to 8.86 in 2015.
Programming and Content Costs
Programming and content expenses showed high volatility in the early part of the period, dropping from 9,138 million USD in 2011 to 4,703 million USD in 2012. From 2012 through 2015, a consistent upward trend is observed, with costs rising steadily to reach 5,815 million USD by the end of the period.
Accounts Payable Dynamics
Accounts payable remained relatively stable compared to the volatility of programming costs. After an increase to 653 million USD in 2012, the balance fluctuated narrowly between 565 million USD and 656 million USD. The convergence of steadily increasing content costs and a relatively stable payables balance contributed to the stabilization of the turnover ratio after 2012.

AI Ask an analyst for more

Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.
Without a user account, I tend to respond rather slowly.

How can I help you?


Working Capital Turnover

Time Warner Cable Inc., working capital turnover calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2015 Dec 31, 2014 Dec 31, 2013 Dec 31, 2012 Dec 31, 2011
Selected Financial Data (US$ in millions)
Current assets 2,459 2,316 2,144 4,877 6,398
Less: Current liabilities 3,949 4,497 5,226 5,325 5,370
Working capital (1,490) (2,181) (3,082) (448) 1,028
 
Revenue 23,697 22,812 22,120 21,386 19,675
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-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31), 10-K (reporting date: 2013-12-31), 10-K (reporting date: 2012-12-31), 10-K (reporting date: 2011-12-31).

1 2015 Calculation
Working capital turnover = Revenue ÷ Working capital
= 23,697 ÷ -1,490 = —

2 Click competitor name to see calculations.


Revenue demonstrated a consistent upward trajectory from 2011 through 2015, increasing steadily from 19,675 million US dollars to 23,697 million US dollars. This indicates a sustained growth in top-line performance throughout the analyzed period.

Working Capital Dynamics
A significant transition in the liquidity position is observed after 2011. The company moved from a positive working capital position of 1,028 million US dollars in 2011 to a negative position starting in 2012. This deficit peaked in 2013 at -3,082 million US dollars, followed by a gradual reduction of the deficit to -2,181 million US dollars in 2014 and -1,490 million US dollars by the end of 2015.
Working Capital Turnover and Operational Efficiency
The working capital turnover ratio was 19.14 in 2011. No ratios are reported for the subsequent years, which correlates with the shift to negative working capital. The persistence of negative working capital from 2012 to 2015 suggests an operational strategy where current liabilities are utilized to finance assets and operations, a condition that renders traditional positive turnover ratios inapplicable for the latter four years of the period.

AI Ask an analyst for more

Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.
Without a user account, I tend to respond rather slowly.

How can I help you?


Average Receivable Collection Period

Time Warner Cable Inc., average receivable collection period calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2015 Dec 31, 2014 Dec 31, 2013 Dec 31, 2012 Dec 31, 2011
Selected Financial Data
Receivables turnover 25.87 24.04 23.19 24.22 25.65
Short-term Activity Ratio (no. days)
Average receivable collection period1 14 15 16 15 14
Benchmarks (no. days)
Average Receivable Collection Period, Competitors2
Alphabet Inc. — — — — —
Comcast Corp. — — — — —
Meta Platforms Inc. — — — — —
Netflix Inc. — — — — —
Walt Disney Co. — — — — —

Based on: 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31), 10-K (reporting date: 2013-12-31), 10-K (reporting date: 2012-12-31), 10-K (reporting date: 2011-12-31).

1 2015 Calculation
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 25.87 = 14

2 Click competitor name to see calculations.


The analysis of short-term operating activity reveals a high level of stability and efficiency in the management of accounts receivable between 2011 and 2015. The company maintained a consistent ability to convert receivables into cash, with fluctuations remaining minimal over the observed period.

Receivables Turnover Ratio
A slight downward trend was observed from 2011 to 2013, with the ratio decreasing from 25.65 to 23.19. This was followed by a recovery phase, where the ratio climbed to 24.04 in 2014 and reached a period high of 25.87 by December 31, 2015. This indicates a return to, and slight improvement upon, the initial efficiency levels seen at the start of the period.
Average Receivable Collection Period
The collection period mirrors the movement of the turnover ratio, showing a marginal increase from 14 days in 2011 to a peak of 16 days in 2013. Subsequently, the period contracted to 15 days in 2014 and returned to 14 days in 2015. The narrow variance of only two days suggests a highly controlled and predictable credit collection process.

AI Ask an analyst for more

Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.
Without a user account, I tend to respond rather slowly.

How can I help you?


Average Payables Payment Period

Time Warner Cable Inc., average payables payment period calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2015 Dec 31, 2014 Dec 31, 2013 Dec 31, 2012 Dec 31, 2011
Selected Financial Data
Payables turnover 8.86 9.34 8.76 7.20 16.77
Short-term Activity Ratio (no. days)
Average payables payment period1 41 39 42 51 22
Benchmarks (no. days)
Average Payables Payment Period, Competitors2
Alphabet Inc. — — — — —
Comcast Corp. — — — — —
Meta Platforms Inc. — — — — —
Netflix Inc. — — — — —
Walt Disney Co. — — — — —

Based on: 10-K (reporting date: 2015-12-31), 10-K (reporting date: 2014-12-31), 10-K (reporting date: 2013-12-31), 10-K (reporting date: 2012-12-31), 10-K (reporting date: 2011-12-31).

1 2015 Calculation
Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ 8.86 = 41

2 Click competitor name to see calculations.


The analysis of short-term operating activity reveals a significant structural shift in the management of accounts payable between 2011 and 2012, followed by a period of relative stabilization through 2015. A substantial extension of the payment cycle occurred during the first year of the observed period, indicating a change in working capital management or a shift in supplier credit terms.

Payables Turnover
A sharp contraction in the payables turnover ratio is observed between 2011 and 2012, decreasing from 16.77 to 7.20. Following this decline, the ratio experienced a modest recovery, increasing to 8.76 in 2013 and peaking at 9.34 in 2014, before settling at 8.86 by the end of 2015.
Average Payables Payment Period
The duration for settling obligations to suppliers more than doubled from 22 days in 2011 to 51 days in 2012. This peak was followed by a corrective downward trend, reducing to 42 days in 2013 and 39 days in 2014. The period concluded with a slight increase to 41 days in 2015.

The inverse correlation between the turnover ratio and the payment period is consistent across the reporting years. The transition from a 22-day payment cycle to a range of 39 to 42 days suggests a long-term increase in the average time taken to pay vendors, which effectively preserves more cash within the operations compared to the 2011 baseline.

AI Ask an analyst for more

Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.
Without a user account, I tend to respond rather slowly.

How can I help you?