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 Liquidity Ratios
Quarterly Data

Microsoft Excel

Liquidity Ratios (Summary)

Time Warner Cable Inc., liquidity ratios (quarterly data)

Microsoft Excel
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
Current ratio 0.68 0.62 0.50 0.50 0.48 0.52 0.41 0.38 0.49 0.41 0.54 0.66 0.78 0.92 0.97 0.89 0.70 1.19 1.44 1.44 1.46
Quick ratio 0.56 0.53 0.38 0.36 0.33 0.37 0.29 0.25 0.37 0.28 0.41 0.58 0.69 0.81 0.86 0.78 0.59 1.11 1.35 1.34 1.33
Cash ratio 0.34 0.30 0.13 0.12 0.13 0.16 0.10 0.08 0.24 0.10 0.23 0.46 0.56 0.65 0.70 0.63 0.47 0.96 1.20 1.12 1.10

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

Liquidity ratio Description The company
Current ratio A liquidity ratio calculated as current assets divided by current liabilities. Time Warner Cable Inc. current ratio improved from Q3 2015 to Q4 2015 and from Q4 2015 to Q1 2016.
Quick ratio A liquidity ratio calculated as (cash plus short-term marketable investments plus receivables) divided by current liabilities. Time Warner Cable Inc. quick ratio improved from Q3 2015 to Q4 2015 and from Q4 2015 to Q1 2016.
Cash ratio A liquidity ratio calculated as (cash plus short-term marketable investments) divided by current liabilities. Time Warner Cable Inc. cash ratio improved from Q3 2015 to Q4 2015 and from Q4 2015 to Q1 2016.

Current Ratio

Time Warner Cable Inc., current ratio calculation (quarterly data)

Microsoft Excel
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
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
Liquidity Ratio
Current ratio1 0.68 0.62 0.50 0.50 0.48 0.52 0.41 0.38 0.49 0.41 0.54 0.66 0.78 0.92 0.97 0.89 0.70 1.19 1.44 1.44 1.46
Benchmarks
Current Ratio, 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
Current ratio = Current assets ÷ Current liabilities
= 2,619 ÷ 3,853 = 0.68

2 Click competitor name to see calculations.

Liquidity ratio Description The company
Current ratio A liquidity ratio calculated as current assets divided by current liabilities. Time Warner Cable Inc. current ratio improved from Q3 2015 to Q4 2015 and from Q4 2015 to Q1 2016.

Quick Ratio

Time Warner Cable Inc., quick ratio calculation (quarterly data)

Microsoft Excel
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)
Cash and equivalents 1,297 1,170 485 480 547 707 526 403 1,557 525 876 2,623 2,793 3,304 3,853 3,226 2,629 5,177 5,573 3,510 3,033
Short-term investments in U.S. Treasury securities 250 575 475 150
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
Total quick assets 2,143 2,086 1,420 1,509 1,358 1,656 1,476 1,309 2,393 1,479 2,018 4,056 4,030 4,337 4,752 4,017 3,276 5,944 6,281 4,214 3,665
 
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
Liquidity Ratio
Quick ratio1 0.56 0.53 0.38 0.36 0.33 0.37 0.29 0.25 0.37 0.28 0.41 0.58 0.69 0.81 0.86 0.78 0.59 1.11 1.35 1.34 1.33
Benchmarks
Quick Ratio, 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
Quick ratio = Total quick assets ÷ Current liabilities
= 2,143 ÷ 3,853 = 0.56

2 Click competitor name to see calculations.

Liquidity ratio Description The company
Quick ratio A liquidity ratio calculated as (cash plus short-term marketable investments plus receivables) divided by current liabilities. Time Warner Cable Inc. quick ratio improved from Q3 2015 to Q4 2015 and from Q4 2015 to Q1 2016.

Cash Ratio

Time Warner Cable Inc., cash ratio calculation (quarterly data)

Microsoft Excel
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)
Cash and equivalents 1,297 1,170 485 480 547 707 526 403 1,557 525 876 2,623 2,793 3,304 3,853 3,226 2,629 5,177 5,573 3,510 3,033
Short-term investments in U.S. Treasury securities 250 575 475 150
Total cash assets 1,297 1,170 485 480 547 707 526 403 1,557 525 1,126 3,198 3,268 3,454 3,853 3,226 2,629 5,177 5,573 3,510 3,033
 
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
Liquidity Ratio
Cash ratio1 0.34 0.30 0.13 0.12 0.13 0.16 0.10 0.08 0.24 0.10 0.23 0.46 0.56 0.65 0.70 0.63 0.47 0.96 1.20 1.12 1.10
Benchmarks
Cash Ratio, 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
Cash ratio = Total cash assets ÷ Current liabilities
= 1,297 ÷ 3,853 = 0.34

2 Click competitor name to see calculations.

Liquidity ratio Description The company
Cash ratio A liquidity ratio calculated as (cash plus short-term marketable investments) divided by current liabilities. Time Warner Cable Inc. cash ratio improved from Q3 2015 to Q4 2015 and from Q4 2015 to Q1 2016.