Stock Analysis on Net

Charter Communications Inc. (NASDAQ:CHTR)

This company has been moved to the archive! The financial data has not been updated since February 2, 2024.

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

Microsoft Excel

Short-term Activity Ratios (Summary)

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

Microsoft Excel
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
Turnover Ratios
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
Working capital turnover
Average No. Days
Average receivable collection period 20 20 19 19 20 19 19 18 18 19 19 18 17 16 16 16 18

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)

Microsoft Excel
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)

Microsoft Excel
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)

Microsoft Excel
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.