Stock Analysis on Net
Stock Analysis on Net
Microsoft Excel LibreOffice Calc

Charter Communications Inc. (NASDAQ:CHTR)

Analysis of Short-term (Operating) Activity Ratios

Beginner level


Short-term Activity Ratios (Summary)

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

Microsoft Excel LibreOffice Calc
Dec 31, 2019 Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015
Turnover Ratios
Receivables turnover 20.55 25.18 25.43 20.25 34.96
Payables turnover 37.18 36.75 35.87 41.09 47.96
Working capital turnover
Average No. Days
Average receivable collection period 18 14 14 18 10
Average payables payment period 10 10 10 9 8

Based on: 10-K (filing date: 2020-01-31), 10-K (filing date: 2019-01-31), 10-K (filing date: 2018-02-02), 10-K (filing date: 2017-02-16), 10-K (filing date: 2016-02-10).

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 deteriorated from 2017 to 2018 and from 2018 to 2019.
Payables turnover An activity ratio calculated as cost of goods sold divided by payables. Charter Communications Inc.’s payables turnover ratio increased from 2017 to 2018 and from 2018 to 2019.
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.
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.

Receivables Turnover

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

Microsoft Excel LibreOffice Calc
Dec 31, 2019 Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015
Selected Financial Data (US$ in millions)
Revenues 45,764  43,634  41,581  29,003  9,754 
Accounts receivable, less allowance for doubtful accounts 2,227  1,733  1,635  1,432  279 
Short-term Activity Ratio
Receivables turnover1 20.55 25.18 25.43 20.25 34.96
Benchmarks
Receivables Turnover, Competitors2
Comcast Corp. 9.65 8.51 9.89 10.11 10.80
Netflix Inc. 44.36 43.55
Walt Disney Co. 4.49 6.37 6.39 6.14 6.54
Receivables Turnover, Sector
Media 8.30 9.47 10.25 9.42 9.45
Receivables Turnover, Industry
Consumer Services 21.80 23.51 25.93 27.17 27.51

Based on: 10-K (filing date: 2020-01-31), 10-K (filing date: 2019-01-31), 10-K (filing date: 2018-02-02), 10-K (filing date: 2017-02-16), 10-K (filing date: 2016-02-10).

1 2019 Calculation
Receivables turnover = Revenues ÷ Accounts receivable, less allowance for doubtful accounts
= 45,764 ÷ 2,227 = 20.55

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 deteriorated from 2017 to 2018 and from 2018 to 2019.

Payables Turnover

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

Microsoft Excel LibreOffice Calc
Dec 31, 2019 Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015
Selected Financial Data (US$ in millions)
Operating costs and expenses 29,224  27,860  26,541  18,655  6,426 
Accounts payable, trade 786  758  740  454  134 
Short-term Activity Ratio
Payables turnover1 37.18 36.75 35.87 41.09 47.96
Benchmarks
Payables Turnover, Competitors2
Comcast Corp. 3.18 3.50 3.67 3.54 3.63
Netflix Inc. 18.45 17.70 21.30 19.27 18.11
Walt Disney Co. 3.05 5.03 4.67 4.37 5.15
Payables Turnover, Sector
Media 4.53 6.14 6.19 5.44 5.12
Payables Turnover, Industry
Consumer Services 7.09 7.42 7.62 8.25 8.24

Based on: 10-K (filing date: 2020-01-31), 10-K (filing date: 2019-01-31), 10-K (filing date: 2018-02-02), 10-K (filing date: 2017-02-16), 10-K (filing date: 2016-02-10).

1 2019 Calculation
Payables turnover = Operating costs and expenses ÷ Accounts payable, trade
= 29,224 ÷ 786 = 37.18

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.’s payables turnover ratio increased from 2017 to 2018 and from 2018 to 2019.

Working Capital Turnover

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

Microsoft Excel LibreOffice Calc
Dec 31, 2019 Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015
Selected Financial Data (US$ in millions)
Current assets 6,471  2,730  2,555  3,300  345 
Less: Current liabilities 12,385  12,095  11,090  9,572  1,972 
Working capital (5,914) (9,365) (8,535) (6,272) (1,627)
 
Revenues 45,764  43,634  41,581  29,003  9,754 
Short-term Activity Ratio
Working capital turnover1
Benchmarks
Working Capital Turnover, Competitors2
Comcast Corp.
Netflix Inc. 4.93 5.31 7.79 3.56
Walt Disney Co. 448.65 123.74
Working Capital Turnover, Sector
Media
Working Capital Turnover, Industry
Consumer Services 103.44 51.34

Based on: 10-K (filing date: 2020-01-31), 10-K (filing date: 2019-01-31), 10-K (filing date: 2018-02-02), 10-K (filing date: 2017-02-16), 10-K (filing date: 2016-02-10).

1 2019 Calculation
Working capital turnover = Revenues ÷ Working capital
= 45,764 ÷ -5,914 =

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, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Dec 31, 2019 Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015
Selected Financial Data
Receivables turnover 20.55 25.18 25.43 20.25 34.96
Short-term Activity Ratio (no. days)
Average receivable collection period1 18 14 14 18 10
Benchmarks (no. days)
Average Receivable Collection Period, Competitors2
Comcast Corp. 38 43 37 36 34
Netflix Inc. 8 8
Walt Disney Co. 81 57 57 59 56
Average Receivable Collection Period, Sector
Media 44 39 36 39 39
Average Receivable Collection Period, Industry
Consumer Services 17 16 14 13 13

Based on: 10-K (filing date: 2020-01-31), 10-K (filing date: 2019-01-31), 10-K (filing date: 2018-02-02), 10-K (filing date: 2017-02-16), 10-K (filing date: 2016-02-10).

1 2019 Calculation
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 20.55 = 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 LibreOffice Calc
Dec 31, 2019 Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015
Selected Financial Data
Payables turnover 37.18 36.75 35.87 41.09 47.96
Short-term Activity Ratio (no. days)
Average payables payment period1 10 10 10 9 8
Benchmarks (no. days)
Average Payables Payment Period, Competitors2
Comcast Corp. 115 104 100 103 101
Netflix Inc. 20 21 17 19 20
Walt Disney Co. 120 73 78 83 71
Average Payables Payment Period, Sector
Media 81 59 59 67 71
Average Payables Payment Period, Industry
Consumer Services 51 49 48 44 44

Based on: 10-K (filing date: 2020-01-31), 10-K (filing date: 2019-01-31), 10-K (filing date: 2018-02-02), 10-K (filing date: 2017-02-16), 10-K (filing date: 2016-02-10).

1 2019 Calculation
Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ 37.18 = 10

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.