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-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).
| Short-term activity ratio | Description | The company |
|---|---|---|
| Receivables turnover | An activity ratio equal to revenue divided by receivables. | Charter Communications Inc. receivables turnover ratio deteriorated from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023. |
| 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)
| Dec 31, 2023 | Sep 30, 2023 | Jun 30, 2023 | Mar 31, 2023 | Dec 31, 2022 | Sep 30, 2022 | Jun 30, 2022 | Mar 31, 2022 | Dec 31, 2021 | Sep 30, 2021 | Jun 30, 2021 | Mar 31, 2021 | Dec 31, 2020 | Sep 30, 2020 | Jun 30, 2020 | Mar 31, 2020 | Dec 31, 2019 | Sep 30, 2019 | Jun 30, 2019 | Mar 31, 2019 | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | ||||||||||||||||||||||||||
| Revenues | 13,711) | 13,584) | 13,659) | 13,653) | 13,674) | 13,550) | 13,598) | 13,200) | 13,212) | 13,146) | 12,802) | 12,522) | 12,624) | 12,039) | 11,696) | 11,738) | 11,761) | 11,450) | 11,347) | 11,206) | ||||||
| Accounts receivable, less allowance for doubtful accounts | 2,965) | 2,932) | 2,864) | 2,851) | 2,921) | 2,841) | 2,779) | 2,530) | 2,579) | 2,645) | 2,583) | 2,395) | 2,201) | 2,068) | 1,994) | 2,091) | 2,227) | 2,284) | 2,070) | 1,578) | ||||||
| Short-term Activity Ratio | ||||||||||||||||||||||||||
| Receivables turnover1 | 18.42 | 18.61 | 19.04 | 19.11 | 18.49 | 18.85 | 19.13 | 20.70 | 20.04 | 19.32 | 19.35 | 20.41 | 21.85 | 22.84 | 23.39 | 22.14 | 20.55 | — | — | — | ||||||
| Benchmarks | ||||||||||||||||||||||||||
| Receivables Turnover, Competitors2 | ||||||||||||||||||||||||||
| Alphabet Inc. | 6.41 | 7.24 | 7.46 | 7.90 | 7.03 | 8.13 | 7.79 | 7.79 | 6.55 | 7.03 | 6.89 | 7.02 | 5.90 | 6.89 | 7.83 | 7.64 | 6.39 | — | — | — | ||||||
| Comcast Corp. | 8.80 | 9.42 | 9.29 | 9.78 | 9.58 | 10.17 | 10.18 | 9.77 | 9.69 | 9.50 | 9.81 | 9.48 | 9.03 | 10.11 | 10.32 | 10.06 | 9.65 | — | — | — | ||||||
| Meta Platforms Inc. | 8.34 | 9.81 | 9.63 | 10.63 | 8.66 | 10.52 | 10.36 | 10.51 | 8.40 | 9.29 | 8.96 | 9.19 | 7.58 | 9.84 | 10.04 | 10.06 | 7.43 | — | — | — | ||||||
| Walt Disney Co. | 7.21 | 6.70 | 6.81 | 6.03 | 6.54 | 5.93 | 5.57 | 4.90 | 5.04 | 4.76 | 4.66 | 4.32 | 5.15 | 5.53 | 5.38 | 4.39 | 4.49 | 4.13 | 4.10 | 5.87 | ||||||
Based on: 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).
1 Q4 2023 Calculation
Receivables turnover
= (RevenuesQ4 2023
+ RevenuesQ3 2023
+ RevenuesQ2 2023
+ RevenuesQ1 2023)
÷ Accounts receivable, less allowance for doubtful accounts
= (13,711 + 13,584 + 13,659 + 13,653)
÷ 2,965 = 18.42
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. receivables turnover ratio deteriorated from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023. |
Working Capital Turnover
Charter Communications Inc., working capital turnover calculation (quarterly data)
| Dec 31, 2023 | Sep 30, 2023 | Jun 30, 2023 | Mar 31, 2023 | Dec 31, 2022 | Sep 30, 2022 | Jun 30, 2022 | Mar 31, 2022 | Dec 31, 2021 | Sep 30, 2021 | Jun 30, 2021 | Mar 31, 2021 | Dec 31, 2020 | Sep 30, 2020 | Jun 30, 2020 | Mar 31, 2020 | Dec 31, 2019 | Sep 30, 2019 | Jun 30, 2019 | Mar 31, 2019 | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | ||||||||||||||||||||||||||
| Current assets | 4,132) | 4,116) | 3,929) | 4,067) | 4,017) | 3,754) | 3,738) | 5,516) | 3,566) | 3,498) | 4,682) | 3,663) | 3,906) | 4,060) | 4,765) | 5,759) | 6,471) | 3,388) | 3,340) | 3,751) | ||||||
| Less: Current liabilities | 13,214) | 12,625) | 11,975) | 12,242) | 12,065) | 11,595) | 11,395) | 13,929) | 12,458) | 12,237) | 10,038) | 9,916) | 9,875) | 10,256) | 9,142) | 13,215) | 12,385) | 11,982) | 9,875) | 11,950) | ||||||
| Working capital | (9,082) | (8,509) | (8,046) | (8,175) | (8,048) | (7,841) | (7,657) | (8,413) | (8,892) | (8,739) | (5,356) | (6,253) | (5,969) | (6,196) | (4,377) | (7,456) | (5,914) | (8,594) | (6,535) | (8,199) | ||||||
| Revenues | 13,711) | 13,584) | 13,659) | 13,653) | 13,674) | 13,550) | 13,598) | 13,200) | 13,212) | 13,146) | 12,802) | 12,522) | 12,624) | 12,039) | 11,696) | 11,738) | 11,761) | 11,450) | 11,347) | 11,206) | ||||||
| Short-term Activity Ratio | ||||||||||||||||||||||||||
| Working capital turnover1 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Benchmarks | ||||||||||||||||||||||||||
| Working Capital Turnover, Competitors2 | ||||||||||||||||||||||||||
| Alphabet Inc. | 3.43 | 3.30 | 3.18 | 3.06 | 2.96 | 2.82 | 2.51 | 2.33 | 2.08 | 1.96 | 1.84 | 1.69 | 1.55 | 1.48 | 1.58 | 1.56 | 1.51 | — | — | — | ||||||
| Comcast Corp. | — | — | — | — | — | — | — | — | — | 165.10 | — | — | — | — | — | — | — | — | — | — | ||||||
| Meta Platforms Inc. | 2.53 | 2.65 | 3.04 | 4.33 | 3.59 | 3.32 | 3.54 | 3.13 | 2.59 | 1.95 | 1.59 | 1.46 | 1.42 | 1.47 | 1.32 | 1.35 | 1.38 | — | — | — | ||||||
| Netflix Inc. | 31.89 | 13.41 | 11.35 | 14.73 | 23.67 | 29.95 | 91.06 | 84.84 | — | 20.95 | 15.57 | 12.30 | 12.78 | 12.62 | 24.13 | — | — | — | — | — | ||||||
| Walt Disney Co. | 54.74 | 45.26 | 420.20 | — | 3,308.88 | 112.96 | 41.96 | 25.38 | 26.13 | 9.70 | 9.36 | 7.30 | 7.58 | 6.70 | — | — | — | — | — | — | ||||||
Based on: 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).
1 Q4 2023 Calculation
Working capital turnover
= (RevenuesQ4 2023
+ RevenuesQ3 2023
+ RevenuesQ2 2023
+ RevenuesQ1 2023)
÷ Working capital
= (13,711 + 13,584 + 13,659 + 13,653)
÷ -9,082 = —
2 Click competitor name to see calculations.
Average Receivable Collection Period
Charter Communications Inc., average receivable collection period calculation (quarterly data)
| Dec 31, 2023 | Sep 30, 2023 | Jun 30, 2023 | Mar 31, 2023 | Dec 31, 2022 | Sep 30, 2022 | Jun 30, 2022 | Mar 31, 2022 | Dec 31, 2021 | Sep 30, 2021 | Jun 30, 2021 | Mar 31, 2021 | Dec 31, 2020 | Sep 30, 2020 | Jun 30, 2020 | Mar 31, 2020 | Dec 31, 2019 | Sep 30, 2019 | Jun 30, 2019 | Mar 31, 2019 | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data | ||||||||||||||||||||||||||
| Receivables turnover | 18.42 | 18.61 | 19.04 | 19.11 | 18.49 | 18.85 | 19.13 | 20.70 | 20.04 | 19.32 | 19.35 | 20.41 | 21.85 | 22.84 | 23.39 | 22.14 | 20.55 | — | — | — | ||||||
| Short-term Activity Ratio (no. days) | ||||||||||||||||||||||||||
| Average receivable collection period1 | 20 | 20 | 19 | 19 | 20 | 19 | 19 | 18 | 18 | 19 | 19 | 18 | 17 | 16 | 16 | 16 | 18 | — | — | — | ||||||
| Benchmarks (no. days) | ||||||||||||||||||||||||||
| Average Receivable Collection Period, Competitors2 | ||||||||||||||||||||||||||
| Alphabet Inc. | 57 | 50 | 49 | 46 | 52 | 45 | 47 | 47 | 56 | 52 | 53 | 52 | 62 | 53 | 47 | 48 | 57 | — | — | — | ||||||
| Comcast Corp. | 41 | 39 | 39 | 37 | 38 | 36 | 36 | 37 | 38 | 38 | 37 | 38 | 40 | 36 | 35 | 36 | 38 | — | — | — | ||||||
| Meta Platforms Inc. | 44 | 37 | 38 | 34 | 42 | 35 | 35 | 35 | 43 | 39 | 41 | 40 | 48 | 37 | 36 | 36 | 49 | — | — | — | ||||||
| Walt Disney Co. | 51 | 55 | 54 | 61 | 56 | 62 | 65 | 74 | 72 | 77 | 78 | 84 | 71 | 66 | 68 | 83 | 81 | 88 | 89 | 62 | ||||||
Based on: 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).
1 Q4 2023 Calculation
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 18.42 = 20
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. |