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)
Charter Communications Inc., short-term (operating) activity ratios (quarterly data)
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).
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 Q1 2020 to Q2 2020 but then slightly deteriorated from Q2 2020 to Q3 2020. |
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)
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) | ||||||||||||||||||||||||||||||
Revenues | 12,039 | 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 | 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 | |||||||
Short-term Activity Ratio | ||||||||||||||||||||||||||||||
Receivables turnover1 | 22.84 | 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.11 | 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 | — | — | — | |||||||
Walt Disney Co. | 5.53 | 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 | — | — | — |
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
Receivables turnover
= (RevenuesQ3 2020
+ RevenuesQ2 2020
+ RevenuesQ1 2020
+ RevenuesQ4 2019)
÷ Accounts receivable, less allowance for doubtful accounts
= (12,039 + 11,696 + 11,738 + 11,761)
÷ 2,068 = 22.84
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 Q1 2020 to Q2 2020 but then slightly deteriorated from Q2 2020 to Q3 2020. |
Working Capital Turnover
Charter Communications Inc., working capital turnover calculation (quarterly data)
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 | |||||||
Less: 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 | |||||||
Working capital | (6,196) | (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 | 12,039 | 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. | 12.62 | 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. | 6.70 | — | — | — | — | — | — | — | — | — | — | — | 973.68 | — | — | 448.65 | — | — | — | 123.74 | — | — | — |
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
Working capital turnover
= (RevenuesQ3 2020
+ RevenuesQ2 2020
+ RevenuesQ1 2020
+ RevenuesQ4 2019)
÷ Working capital
= (12,039 + 11,696 + 11,738 + 11,761)
÷ -6,196 = —
2 Click competitor name to see calculations.
Average Receivable Collection Period
Charter Communications Inc., average receivable collection period calculation (quarterly data)
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 | ||||||||||||||||||||||||||||||
Receivables turnover | 22.84 | 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 | 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. | 36 | 35 | 36 | 38 | 36 | 38 | 40 | 43 | 37 | 37 | 37 | 37 | 35 | 34 | 33 | 36 | 35 | 32 | 31 | 34 | — | — | — | |||||||
Walt Disney Co. | 66 | 68 | 83 | 81 | 88 | 89 | 62 | 57 | 63 | 62 | 65 | 57 | 63 | 61 | 65 | 59 | 58 | 59 | 69 | 56 | — | — | — |
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
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 22.84 = 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. |