Stock Analysis on Net

Charter Communications Inc. (NASDAQ:CHTR)

Analysis of Short-term (Operating) Activity Ratios 

Microsoft Excel

Short-term Activity Ratios (Summary)

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

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Turnover Ratios
Receivables turnover 20.04 21.85 20.55 25.18 25.43
Payables turnover 43.48 39.23 37.18 36.75 35.87
Working capital turnover
Average No. Days
Average receivable collection period 18 17 18 14 14
Average payables payment period 8 9 10 10 10

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-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 improved from 2019 to 2020 but then deteriorated significantly from 2020 to 2021.
Payables turnover An activity ratio calculated as cost of goods sold divided by payables. Charter Communications Inc. payables turnover ratio increased from 2019 to 2020 and from 2020 to 2021.

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.
Average payables payment period An estimate of the average number of days it takes a company to pay its suppliers; equal to the number of days in the period divided by payables turnover ratio for the period. Charter Communications Inc. number of days of payables outstanding decreased from 2019 to 2020 and from 2020 to 2021.

Receivables Turnover

Charter Communications Inc., receivables turnover calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Selected Financial Data (US$ in millions)
Revenues 51,682  48,097  45,764  43,634  41,581 
Accounts receivable, less allowance for doubtful accounts 2,579  2,201  2,227  1,733  1,635 
Short-term Activity Ratio
Receivables turnover1 20.04 21.85 20.55 25.18 25.43
Benchmarks
Receivables Turnover, Competitors2
Alphabet Inc. 6.55 5.90 6.39 6.57 6.05
Comcast Corp. 9.69 9.03 9.65 8.51 9.89
Meta Platforms Inc. 8.40 7.58 7.43 7.36 6.97
Netflix Inc. 36.92 40.92 44.36 43.55
Twitter Inc. 4.17 3.57 4.07 3.86 3.68
Walt Disney Co. 5.04 5.15 4.49 6.37 6.39
Receivables Turnover, Sector
Media & Entertainment 7.75 7.32 7.37 7.91 7.95
Receivables Turnover, Industry
Communication Services 7.98 7.44 7.28 7.17 7.88

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).

1 2021 Calculation
Receivables turnover = Revenues ÷ Accounts receivable, less allowance for doubtful accounts
= 51,682 ÷ 2,579 = 20.04

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 improved from 2019 to 2020 but then deteriorated significantly from 2020 to 2021.

Payables Turnover

Charter Communications Inc., payables turnover calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Selected Financial Data (US$ in millions)
Operating costs and expenses 31,482  29,930  29,224  27,860  26,541 
Accounts payable, trade 724  763  786  758  740 
Short-term Activity Ratio
Payables turnover1 43.48 39.23 37.18 36.75 35.87
Benchmarks
Payables Turnover, Competitors2
Alphabet Inc. 18.38 15.16 12.93 13.60 14.53
Comcast Corp. 3.09 2.91 3.18 3.50 3.67
Meta Platforms Inc. 5.55 12.54 9.37 11.41 14.35
Netflix Inc. 20.70 23.28 18.45 17.70 21.30
Twitter Inc. 8.85 7.03 7.06 6.65 5.04
Walt Disney Co. 2.76 3.33 3.05 5.03 4.67
Payables Turnover, Sector
Media & Entertainment 6.58 6.80 6.15 7.85 7.79
Payables Turnover, Industry
Communication Services 5.12 4.98 4.83 5.27 5.16

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).

1 2021 Calculation
Payables turnover = Operating costs and expenses ÷ Accounts payable, trade
= 31,482 ÷ 724 = 43.48

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Payables turnover An activity ratio calculated as cost of goods sold divided by payables. Charter Communications Inc. payables turnover ratio increased from 2019 to 2020 and from 2020 to 2021.

Working Capital Turnover

Charter Communications Inc., working capital turnover calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Selected Financial Data (US$ in millions)
Current assets 3,566  3,906  6,471  2,730  2,555 
Less: Current liabilities 12,458  9,875  12,385  12,095  11,090 
Working capital (8,892) (5,969) (5,914) (9,365) (8,535)
 
Revenues 51,682  48,097  45,764  43,634  41,581 
Short-term Activity Ratio
Working capital turnover1
Benchmarks
Working Capital Turnover, Competitors2
Alphabet Inc. 2.08 1.55 1.51 1.35 1.11
Comcast Corp.
Meta Platforms Inc. 2.59 1.42 1.38 1.28 0.91
Netflix Inc. 12.78 4.93 5.31
Twitter Inc. 0.77 0.56 0.51 0.54 0.52
Walt Disney Co. 26.13 7.58
Working Capital Turnover, Sector
Media & Entertainment 3.92 2.74 3.19 2.98 2.59
Working Capital Turnover, Industry
Communication Services 8.16 4.57 6.66 6.34 5.34

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).

1 2021 Calculation
Working capital turnover = Revenues ÷ Working capital
= 51,682 ÷ -8,892 =

2 Click competitor name to see calculations.


Average Receivable Collection Period

Charter Communications Inc., average receivable collection period calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Selected Financial Data
Receivables turnover 20.04 21.85 20.55 25.18 25.43
Short-term Activity Ratio (no. days)
Average receivable collection period1 18 17 18 14 14
Benchmarks (no. days)
Average Receivable Collection Period, Competitors2
Alphabet Inc. 56 62 57 56 60
Comcast Corp. 38 40 38 43 37
Meta Platforms Inc. 43 48 49 50 52
Netflix Inc. 10 9 8 8
Twitter Inc. 88 102 90 95 99
Walt Disney Co. 72 71 81 57 57
Average Receivable Collection Period, Sector
Media & Entertainment 47 50 49 46 46
Average Receivable Collection Period, Industry
Communication Services 46 49 50 51 46

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).

1 2021 Calculation
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 20.04 = 18

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.

Average Payables Payment Period

Charter Communications Inc., average payables payment period calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Selected Financial Data
Payables turnover 43.48 39.23 37.18 36.75 35.87
Short-term Activity Ratio (no. days)
Average payables payment period1 8 9 10 10 10
Benchmarks (no. days)
Average Payables Payment Period, Competitors2
Alphabet Inc. 20 24 28 27 25
Comcast Corp. 118 125 115 104 100
Meta Platforms Inc. 66 29 39 32 25
Netflix Inc. 18 16 20 21 17
Twitter Inc. 41 52 52 55 72
Walt Disney Co. 132 110 120 73 78
Average Payables Payment Period, Sector
Media & Entertainment 55 54 59 46 47
Average Payables Payment Period, Industry
Communication Services 71 73 76 69 71

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).

1 2021 Calculation
Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ 43.48 = 8

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Average payables payment period An estimate of the average number of days it takes a company to pay its suppliers; equal to the number of days in the period divided by payables turnover ratio for the period. Charter Communications Inc. number of days of payables outstanding decreased from 2019 to 2020 and from 2020 to 2021.