Analysis of Short-term (Operating) Activity Ratios
Quarterly Data
Beginner level
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-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 Q3 2019 to Q4 2019 and from Q4 2019 to Q1 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)
| 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,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,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.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.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. | 39.64 | 44.36 | 40.49 | 35.83 | 38.37 | 43.55 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Walt Disney Co. | 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-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 Q1 2020 Calculation
Receivables turnover
= (RevenuesQ1 2020
+ RevenuesQ4 2019
+ RevenuesQ3 2019
+ RevenuesQ2 2019)
÷ Accounts receivable, less allowance for doubtful accounts
= (11,738 + 11,761 + 11,450 + 11,347)
÷ 2,091 = 22.14
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 Q3 2019 to Q4 2019 and from Q4 2019 to Q1 2020. |
Working Capital Turnover
Charter Communications Inc., working capital turnover calculation (quarterly data)
| 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 | 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 | 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 | (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,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. | — | — | — | — | — | 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-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 Q1 2020 Calculation
Working capital turnover
= (RevenuesQ1 2020
+ RevenuesQ4 2019
+ RevenuesQ3 2019
+ RevenuesQ2 2019)
÷ Working capital
= (11,738 + 11,761 + 11,450 + 11,347)
÷ -7,456 = —
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)
| 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.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 | 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 | 38 | 36 | 38 | 40 | 43 | 37 | 37 | 37 | 37 | 35 | 34 | 33 | 36 | 35 | 32 | 31 | 34 | — | — | — | |||||||
| Netflix Inc. | 9 | 8 | 9 | 10 | 10 | 8 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Walt Disney Co. | 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-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 Q1 2020 Calculation
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 22.14 = 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. |