Stock Analysis on Net
Stock Analysis on Net

Charter Communications Inc. (NASDAQ:CHTR)

Analysis of Liquidity Ratios
Quarterly Data

Beginner level

Liquidity Ratios (Summary)

Charter Communications Inc., liquidity ratios (quarterly data)

Microsoft Excel LibreOffice Calc
Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 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
Current ratio 0.40 0.52 0.44 0.52 0.28 0.34 0.31 0.23 0.23 0.20 0.21 0.23 0.40 0.32 0.49 0.34 0.32 0.26 0.84 0.17 0.22 0.28 0.88
Quick ratio 0.33 0.45 0.38 0.46 0.23 0.28 0.25 0.19 0.20 0.17 0.17 0.20 0.37 0.27 0.44 0.31 0.28 0.22 0.80 0.14 0.16 0.21 0.86
Cash ratio 0.13 0.23 0.22 0.28 0.04 0.07 0.12 0.05 0.05 0.06 0.05 0.06 0.21 0.09 0.31 0.16 0.13 0.06 0.66 0.00 0.00 0.02 0.83

Based on: 10-Q (filing date: 2020-10-30), 10-Q (filing date: 2020-07-31), 10-Q (filing date: 2020-05-01), 10-K (filing date: 2020-01-31), 10-Q (filing date: 2019-10-25), 10-Q (filing date: 2019-07-26), 10-Q (filing date: 2019-04-30), 10-K (filing date: 2019-01-31), 10-Q (filing date: 2018-10-26), 10-Q (filing date: 2018-07-31), 10-Q (filing date: 2018-04-27), 10-K (filing date: 2018-02-02), 10-Q (filing date: 2017-10-26), 10-Q (filing date: 2017-07-27), 10-Q (filing date: 2017-05-02), 10-K (filing date: 2017-02-16), 10-Q (filing date: 2016-11-03), 10-Q (filing date: 2016-08-09), 10-Q (filing date: 2016-04-28), 10-K (filing date: 2016-02-10), 10-Q (filing date: 2015-10-29), 10-Q (filing date: 2015-08-04), 10-Q (filing date: 2015-05-01).

Liquidity ratio Description The company
Current ratio A liquidity ratio calculated as current assets divided by current liabilities. Charter Communications Inc.’s current ratio improved from Q1 2020 to Q2 2020 but then deteriorated significantly from Q2 2020 to Q3 2020.
Quick ratio A liquidity ratio calculated as (cash plus short-term marketable investments plus receivables) divided by current liabilities. Charter Communications Inc.’s quick ratio improved from Q1 2020 to Q2 2020 but then deteriorated significantly from Q2 2020 to Q3 2020.
Cash ratio A liquidity ratio calculated as (cash plus short-term marketable investments) divided by current liabilities. Charter Communications Inc.’s cash ratio improved from Q1 2020 to Q2 2020 but then deteriorated significantly from Q2 2020 to Q3 2020.

Current Ratio

Charter Communications Inc., current ratio calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 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
Selected Financial Data (US$ in millions)
Current assets 4,060  4,765  5,759  6,471  3,388  3,340  3,751  2,730  2,729  2,750  2,398  2,555  4,132  2,564  4,666  3,300  2,781  2,325  1,612  345  406  456  7,502 
Current liabilities 10,256  9,142  13,215  12,385  11,982  9,875  11,950  12,095  11,850  14,024  11,602  11,090  10,419  8,123  9,520  9,572  8,647  8,807  1,925  1,972  1,829  1,636  8,569 
Liquidity Ratio
Current ratio1 0.40 0.52 0.44 0.52 0.28 0.34 0.31 0.23 0.23 0.20 0.21 0.23 0.40 0.32 0.49 0.34 0.32 0.26 0.84 0.17 0.22 0.28 0.88
Benchmarks
Current Ratio, Competitors2
Comcast Corp. 0.93 0.97 0.87 0.84 0.86 0.69 0.73 0.79 1.18 0.96 0.98 0.74 0.74 0.67 0.80 0.76 0.84 0.84 0.80 0.68 0.66 0.76 0.70
Netflix Inc. 1.24 1.12 0.82 0.90 0.73 0.85 0.61 1.49 1.39 1.54 1.30 1.40 1.20 1.31 1.15 1.25 1.18 1.33 1.41 1.54 1.67 1.74 1.84
Walt Disney Co. 1.34 0.94 0.80 0.90 0.70 0.77 1.00 0.94 0.88 0.85 0.87 0.81 1.00 0.94 0.86 1.01 0.97 1.00 0.95 1.03 1.11 1.17 1.03

Based on: 10-Q (filing date: 2020-10-30), 10-Q (filing date: 2020-07-31), 10-Q (filing date: 2020-05-01), 10-K (filing date: 2020-01-31), 10-Q (filing date: 2019-10-25), 10-Q (filing date: 2019-07-26), 10-Q (filing date: 2019-04-30), 10-K (filing date: 2019-01-31), 10-Q (filing date: 2018-10-26), 10-Q (filing date: 2018-07-31), 10-Q (filing date: 2018-04-27), 10-K (filing date: 2018-02-02), 10-Q (filing date: 2017-10-26), 10-Q (filing date: 2017-07-27), 10-Q (filing date: 2017-05-02), 10-K (filing date: 2017-02-16), 10-Q (filing date: 2016-11-03), 10-Q (filing date: 2016-08-09), 10-Q (filing date: 2016-04-28), 10-K (filing date: 2016-02-10), 10-Q (filing date: 2015-10-29), 10-Q (filing date: 2015-08-04), 10-Q (filing date: 2015-05-01).

1 Q3 2020 Calculation
Current ratio = Current assets ÷ Current liabilities
= 4,060 ÷ 10,256 = 0.40

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. Charter Communications Inc.’s current ratio improved from Q1 2020 to Q2 2020 but then deteriorated significantly from Q2 2020 to Q3 2020.

Quick Ratio

Charter Communications Inc., quick ratio calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 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
Selected Financial Data (US$ in millions)
Cash and cash equivalents 1,283  2,097  2,908  3,483  508  696  1,451  551  612  773  576  621  2,164  694  2,920  1,535  1,165  555  1,278  —  30  20 
Restricted cash and cash equivalents —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  7,112 
Accounts receivable, less allowance for doubtful accounts 2,068  1,994  2,091  2,227  2,284  2,070  1,578  1,733  1,736  1,619  1,409  1,635  1,652  1,489  1,311  1,432  1,242  1,340  253  279  292  321  264 
Total quick assets 3,351  4,091  4,999  5,710  2,792  2,766  3,029  2,284  2,348  2,392  1,985  2,256  3,816  2,183  4,231  2,967  2,407  1,895  1,531  284  292  351  7,396 
 
Current liabilities 10,256  9,142  13,215  12,385  11,982  9,875  11,950  12,095  11,850  14,024  11,602  11,090  10,419  8,123  9,520  9,572  8,647  8,807  1,925  1,972  1,829  1,636  8,569 
Liquidity Ratio
Quick ratio1 0.33 0.45 0.38 0.46 0.23 0.28 0.25 0.19 0.20 0.17 0.17 0.20 0.37 0.27 0.44 0.31 0.28 0.22 0.80 0.14 0.16 0.21 0.86
Benchmarks
Quick Ratio, Competitors2
Comcast Corp. 0.81 0.85 0.70 0.55 0.55 0.48 0.51 0.54 1.00 0.77 0.77 0.56 0.56 0.47 0.61 0.52 0.57 0.65 0.63 0.51 0.49 0.60 0.54
Netflix Inc. 1.06 0.94 0.66 0.73 0.61 0.72 0.49 0.58 0.49 0.64 0.43 0.52 0.33 0.42 0.27 0.38 0.30 0.45 0.53 0.65 0.78 0.87 0.98
Walt Disney Co. 1.16 0.81 0.69 0.67 0.50 0.56 0.83 0.75 0.71 0.70 0.73 0.65 0.82 0.75 0.70 0.81 0.78 0.81 0.78 0.75 0.84 0.89 0.81

Based on: 10-Q (filing date: 2020-10-30), 10-Q (filing date: 2020-07-31), 10-Q (filing date: 2020-05-01), 10-K (filing date: 2020-01-31), 10-Q (filing date: 2019-10-25), 10-Q (filing date: 2019-07-26), 10-Q (filing date: 2019-04-30), 10-K (filing date: 2019-01-31), 10-Q (filing date: 2018-10-26), 10-Q (filing date: 2018-07-31), 10-Q (filing date: 2018-04-27), 10-K (filing date: 2018-02-02), 10-Q (filing date: 2017-10-26), 10-Q (filing date: 2017-07-27), 10-Q (filing date: 2017-05-02), 10-K (filing date: 2017-02-16), 10-Q (filing date: 2016-11-03), 10-Q (filing date: 2016-08-09), 10-Q (filing date: 2016-04-28), 10-K (filing date: 2016-02-10), 10-Q (filing date: 2015-10-29), 10-Q (filing date: 2015-08-04), 10-Q (filing date: 2015-05-01).

1 Q3 2020 Calculation
Quick ratio = Total quick assets ÷ Current liabilities
= 3,351 ÷ 10,256 = 0.33

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. Charter Communications Inc.’s quick ratio improved from Q1 2020 to Q2 2020 but then deteriorated significantly from Q2 2020 to Q3 2020.

Cash Ratio

Charter Communications Inc., cash ratio calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 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
Selected Financial Data (US$ in millions)
Cash and cash equivalents 1,283  2,097  2,908  3,483  508  696  1,451  551  612  773  576  621  2,164  694  2,920  1,535  1,165  555  1,278  —  30  20 
Restricted cash and cash equivalents —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  7,112 
Total cash assets 1,283  2,097  2,908  3,483  508  696  1,451  551  612  773  576  621  2,164  694  2,920  1,535  1,165  555  1,278  —  30  7,132 
 
Current liabilities 10,256  9,142  13,215  12,385  11,982  9,875  11,950  12,095  11,850  14,024  11,602  11,090  10,419  8,123  9,520  9,572  8,647  8,807  1,925  1,972  1,829  1,636  8,569 
Liquidity Ratio
Cash ratio1 0.13 0.23 0.22 0.28 0.04 0.07 0.12 0.05 0.05 0.06 0.05 0.06 0.21 0.09 0.31 0.16 0.13 0.06 0.66 0.00 0.00 0.02 0.83
Benchmarks
Cash Ratio, Competitors2
Comcast Corp. 0.46 0.49 0.31 0.18 0.13 0.13 0.13 0.14 0.54 0.30 0.31 0.16 0.19 0.12 0.21 0.15 0.16 0.27 0.29 0.13 0.11 0.20 0.21
Netflix Inc. 1.06 0.94 0.66 0.73 0.61 0.72 0.49 0.58 0.49 0.64 0.43 0.52 0.33 0.42 0.27 0.38 0.30 0.45 0.53 0.65 0.78 0.87 0.98
Walt Disney Co. 0.75 0.40 0.20 0.17 0.15 0.23 0.25 0.23 0.21 0.21 0.24 0.21 0.25 0.22 0.19 0.27 0.29 0.29 0.23 0.26 0.30 0.28 0.30

Based on: 10-Q (filing date: 2020-10-30), 10-Q (filing date: 2020-07-31), 10-Q (filing date: 2020-05-01), 10-K (filing date: 2020-01-31), 10-Q (filing date: 2019-10-25), 10-Q (filing date: 2019-07-26), 10-Q (filing date: 2019-04-30), 10-K (filing date: 2019-01-31), 10-Q (filing date: 2018-10-26), 10-Q (filing date: 2018-07-31), 10-Q (filing date: 2018-04-27), 10-K (filing date: 2018-02-02), 10-Q (filing date: 2017-10-26), 10-Q (filing date: 2017-07-27), 10-Q (filing date: 2017-05-02), 10-K (filing date: 2017-02-16), 10-Q (filing date: 2016-11-03), 10-Q (filing date: 2016-08-09), 10-Q (filing date: 2016-04-28), 10-K (filing date: 2016-02-10), 10-Q (filing date: 2015-10-29), 10-Q (filing date: 2015-08-04), 10-Q (filing date: 2015-05-01).

1 Q3 2020 Calculation
Cash ratio = Total cash assets ÷ Current liabilities
= 1,283 ÷ 10,256 = 0.13

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. Charter Communications Inc.’s cash ratio improved from Q1 2020 to Q2 2020 but then deteriorated significantly from Q2 2020 to Q3 2020.