Stock Analysis on Net
Stock Analysis on Net

Charter Communications Inc. (NASDAQ:CHTR)

Analysis of Short-term (Operating) Activity Ratios
Quarterly Data

Beginner level


Short-term Activity Ratios (Summary)

Charter Communications Inc., short-term (operating) activity ratios (quarterly data)

Microsoft Excel LibreOffice Calc
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
Turnover Ratios
Receivables turnover 23.39 22.14 20.55 19.80 21.58 28.00 25.18 24.77 26.29 29.86 25.43 24.97 27.42 27.95 20.25 17.10 10.19 39.22 34.96
Working capital turnover
Average No. Days
Average receivable collection period 16 16 18 18 17 13 14 15 14 12 14 15 13 13 18 21 36 9 10

Based on: 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).

Short-term activity ratio Description The company
Receivables turnover An activity ratio equal to revenue divided by receivables. Charter Communications Inc.’s receivables turnover ratio improved from Q4 2019 to Q1 2020 and from Q1 2020 to Q2 2020.
Working capital turnover An activity ratio calculated as revenue divided by working capital.

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.

Receivables Turnover

Charter Communications Inc., receivables turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
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)
Revenues 11,696  11,738  11,761  11,450  11,347  11,206  11,231  10,892  10,854  10,657  10,602  10,458  10,357  10,164  10,275  10,037  6,161  2,530  2,512  2,450  2,430  2,362 
Accounts receivable, less allowance for doubtful accounts 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 
Short-term Activity Ratio
Receivables turnover1 23.39 22.14 20.55 19.80 21.58 28.00 25.18 24.77 26.29 29.86 25.43 24.97 27.42 27.95 20.25 17.10 10.19 39.22 34.96
Benchmarks
Receivables Turnover, Competitors2
Comcast Corp. 10.32 10.06 9.65 10.15 9.57 9.18 8.51 9.86 9.88 9.92 9.89 10.57 10.70 10.91 10.11 10.44 11.33 11.83 10.80
Netflix Inc. 40.00 39.64 44.36 40.49 35.83 38.37 43.55
Walt Disney Co. 5.38 4.39 4.49 4.13 4.10 5.87 6.37 5.75 5.88 5.63 6.39 5.76 5.98 5.59 6.14 6.25 6.18 5.27 6.54 6.41 6.21 5.81

Based on: 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 Q2 2020 Calculation
Receivables turnover = (RevenuesQ2 2020 + RevenuesQ1 2020 + RevenuesQ4 2019 + RevenuesQ3 2019) ÷ Accounts receivable, less allowance for doubtful accounts
= (11,696 + 11,738 + 11,761 + 11,450) ÷ 1,994 = 23.39

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. Charter Communications Inc.’s receivables turnover ratio improved from Q4 2019 to Q1 2020 and from Q1 2020 to Q2 2020.

Working Capital Turnover

Charter Communications Inc., working capital turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
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,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 
Less: Current liabilities 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 
Working capital (4,377) (7,456) (5,914) (8,594) (6,535) (8,199) (9,365) (9,121) (11,274) (9,204) (8,535) (6,287) (5,559) (4,854) (6,272) (5,866) (6,482) (313) (1,627) (1,423) (1,180) (1,067)
 
Revenues 11,696  11,738  11,761  11,450  11,347  11,206  11,231  10,892  10,854  10,657  10,602  10,458  10,357  10,164  10,275  10,037  6,161  2,530  2,512  2,450  2,430  2,362 
Short-term Activity Ratio
Working capital turnover1
Benchmarks
Working Capital Turnover, Competitors2
Comcast Corp. 24.75
Netflix Inc. 24.13 4.93 6.12 4.25 7.04 5.31 10.13 6.46 12.69 7.79 10.45 5.71 4.45 3.56
Walt Disney Co. 973.68 448.65 123.74 30.45 22.68 114.44

Based on: 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 Q2 2020 Calculation
Working capital turnover = (RevenuesQ2 2020 + RevenuesQ1 2020 + RevenuesQ4 2019 + RevenuesQ3 2019) ÷ Working capital
= (11,696 + 11,738 + 11,761 + 11,450) ÷ -4,377 =

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Working capital turnover An activity ratio calculated as revenue divided by working capital.

Average Receivable Collection Period

Charter Communications Inc., average receivable collection period calculation (quarterly data)

Microsoft Excel LibreOffice Calc
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
Receivables turnover 23.39 22.14 20.55 19.80 21.58 28.00 25.18 24.77 26.29 29.86 25.43 24.97 27.42 27.95 20.25 17.10 10.19 39.22 34.96
Short-term Activity Ratio (no. days)
Average receivable collection period1 16 16 18 18 17 13 14 15 14 12 14 15 13 13 18 21 36 9 10
Benchmarks (no. days)
Average Receivable Collection Period, Competitors2
Comcast Corp. 35 36 38 36 38 40 43 37 37 37 37 35 34 33 36 35 32 31 34
Netflix Inc. 9 9 8 9 10 10 8
Walt Disney Co. 68 83 81 88 89 62 57 63 62 65 57 63 61 65 59 58 59 69 56 57 59 63

Based on: 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 Q2 2020 Calculation
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 23.39 = 16

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.