Microsoft Excel LibreOffice Calc

Charter Communications Inc. (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, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Turnover Ratios
Receivables turnover 25.18 25.43 20.25 34.96 31.96
Payables turnover 36.75 35.87 41.09 47.96 42.66
Working capital turnover
Average No. Days
Average receivable collection period 14 14 18 10 11
Average payables payment period 10 10 9 8 9

Based on: 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), 10-K (filing date: 2015-02-24).

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 2016 to 2017 but then slightly deteriorated from 2017 to 2018.
Payables turnover An activity ratio calculated as cost of goods sold divided by payables. Charter Communications Inc.’s payables turnover ratio decreased from 2016 to 2017 but then slightly increased from 2017 to 2018.
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, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Selected Financial Data (US$ in millions)
Revenues 43,634  41,581  29,003  9,754  9,108 
Accounts receivable, less allowance for doubtful accounts 1,733  1,635  1,432  279  285 
Short-term Activity Ratio
Receivables turnover1 25.18 25.43 20.25 34.96 31.96
Benchmarks
Receivables Turnover, Competitors2
Comcast Corp. 8.51 9.89 10.11 10.80 10.88
Walt Disney Co. 6.37 6.39 6.14 6.54 6.24
Receivables Turnover, Sector
Media 8.91 9.63 8.94 9.00 8.78
Receivables Turnover, Industry
Consumer Services 22.75 24.75 25.96 26.45 28.93

Based on: 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), 10-K (filing date: 2015-02-24).

1 2018 Calculation
Receivables turnover = Revenues ÷ Accounts receivable, less allowance for doubtful accounts
= 43,634 ÷ 1,733 = 25.18

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 2016 to 2017 but then slightly deteriorated from 2017 to 2018.

Payables Turnover

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

Microsoft Excel LibreOffice Calc
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Selected Financial Data (US$ in millions)
Operating costs and expenses 27,860  26,541  18,655  6,426  5,973 
Accounts payable, trade 758  740  454  134  140 
Short-term Activity Ratio
Payables turnover1 36.75 35.87 41.09 47.96 42.66
Benchmarks
Payables Turnover, Competitors2
Comcast Corp. 3.50 3.67 3.54 3.63 3.71
Walt Disney Co. 5.03 4.67 4.37 5.15 4.92
Payables Turnover, Sector
Media 5.73 5.81 5.14 4.84 4.78
Payables Turnover, Industry
Consumer Services 7.46 7.61 8.26 8.24 8.77

Based on: 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), 10-K (filing date: 2015-02-24).

1 2018 Calculation
Payables turnover = Operating costs and expenses ÷ Accounts payable, trade
= 27,860 ÷ 758 = 36.75

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 decreased from 2016 to 2017 but then slightly increased from 2017 to 2018.

Working Capital Turnover

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

Microsoft Excel LibreOffice Calc
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Selected Financial Data (US$ in millions)
Current assets 2,730  2,555  3,300  345  371 
Less: Current liabilities 12,095  11,090  9,572  1,972  1,635 
Working capital (9,365) (8,535) (6,272) (1,627) (1,264)
 
Revenues 43,634  41,581  29,003  9,754  9,108 
Short-term Activity Ratio
Working capital turnover1
Benchmarks
Working Capital Turnover, Competitors2
Comcast Corp.
Walt Disney Co. 448.65 123.74 25.91
Working Capital Turnover, Sector
Media
Working Capital Turnover, Industry
Consumer Services 179.52 68.53 57.53

Based on: 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), 10-K (filing date: 2015-02-24).

1 2018 Calculation
Working capital turnover = Revenues ÷ Working capital
= 43,634 ÷ -9,365 =

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, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Selected Financial Data
Receivables turnover 25.18 25.43 20.25 34.96 31.96
Short-term Activity Ratio (no. days)
Average receivable collection period1 14 14 18 10 11
Benchmarks (no. days)
Average Receivable Collection Period, Competitors2
Comcast Corp. 43 37 36 34 34
Walt Disney Co. 57 57 59 56 58
Average Receivable Collection Period, Sector
Media 41 38 41 41 42
Average Receivable Collection Period, Industry
Consumer Services 16 15 14 14 13

Based on: 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), 10-K (filing date: 2015-02-24).

1 2018 Calculation
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 25.18 = 14

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, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Selected Financial Data
Payables turnover 36.75 35.87 41.09 47.96 42.66
Short-term Activity Ratio (no. days)
Average payables payment period1 10 10 9 8 9
Benchmarks (no. days)
Average Payables Payment Period, Competitors2
Comcast Corp. 104 100 103 101 98
Walt Disney Co. 73 78 83 71 74
Average Payables Payment Period, Sector
Media 64 63 71 75 76
Average Payables Payment Period, Industry
Consumer Services 49 48 44 44 42

Based on: 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), 10-K (filing date: 2015-02-24).

1 2018 Calculation
Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ 36.75 = 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.