Microsoft Excel LibreOffice Calc

Comcast Corp. (CMCSA)


Analysis of Short-term (Operating) Activity Ratios

Beginner level


Short-term Activity Ratios (Summary)

Comcast Corp., 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 8.51 9.89 10.11 10.80 10.88
Payables turnover 3.50 3.67 3.54 3.63 3.71
Working capital turnover
Average No. Days
Average receivable collection period 43 37 36 34 34
Average payables payment period 104 100 103 101 98

Based on: 10-K (filing date: 2019-01-31), 10-K (filing date: 2018-01-31), 10-K (filing date: 2017-02-03), 10-K (filing date: 2016-02-05), 10-K (filing date: 2015-02-27).

Short-term activity ratio Description The company
Receivables turnover An activity ratio equal to revenue divided by receivables. Comcast Corp.’s receivables turnover ratio deteriorated from 2016 to 2017 and from 2017 to 2018.
Payables turnover An activity ratio calculated as cost of goods sold divided by payables. Comcast Corp.’s payables turnover ratio increased from 2016 to 2017 but then decreased significantly 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. Comcast Corp.’s number of days of receivables outstanding deteriorated from 2016 to 2017 and from 2017 to 2018.
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. Comcast Corp.’s number of days of payables outstanding decreased from 2016 to 2017 but then increased from 2017 to 2018 exceeding 2016 level.

Receivables Turnover

Comcast Corp., 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)
Revenue 94,507  84,526  80,403  74,510  68,775 
Receivables, net 11,104  8,546  7,955  6,896  6,321 
Short-term Activity Ratio
Receivables turnover1 8.51 9.89 10.11 10.80 10.88
Benchmarks
Receivables Turnover, Competitors2
Charter Communications Inc. 25.18 25.43 20.25 34.96 31.96
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-01-31), 10-K (filing date: 2017-02-03), 10-K (filing date: 2016-02-05), 10-K (filing date: 2015-02-27).

1 2018 Calculation
Receivables turnover = Revenue ÷ Receivables, net
= 94,507 ÷ 11,104 = 8.51

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. Comcast Corp.’s receivables turnover ratio deteriorated from 2016 to 2017 and from 2017 to 2018.

Payables Turnover

Comcast Corp., 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)
Programming and production 29,692  25,384  24,463  22,550  20,912 
Accounts payable and accrued expenses related to trade creditors 8,494  6,926  6,915  6,215  5,638 
Short-term Activity Ratio
Payables turnover1 3.50 3.67 3.54 3.63 3.71
Benchmarks
Payables Turnover, Competitors2
Charter Communications Inc. 36.75 35.87 41.09 47.96 42.66
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-01-31), 10-K (filing date: 2017-02-03), 10-K (filing date: 2016-02-05), 10-K (filing date: 2015-02-27).

1 2018 Calculation
Payables turnover = Programming and production ÷ Accounts payable and accrued expenses related to trade creditors
= 29,692 ÷ 8,494 = 3.50

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. Comcast Corp.’s payables turnover ratio increased from 2016 to 2017 but then decreased significantly from 2017 to 2018.

Working Capital Turnover

Comcast Corp., 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 21,848  16,060  16,361  12,303  13,531 
Less: Current liabilities 27,603  21,561  21,535  18,178  17,410 
Working capital (5,755) (5,501) (5,174) (5,875) (3,879)
 
Revenue 94,507  84,526  80,403  74,510  68,775 
Short-term Activity Ratio
Working capital turnover1
Benchmarks
Working Capital Turnover, Competitors2
Charter Communications Inc.
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-01-31), 10-K (filing date: 2017-02-03), 10-K (filing date: 2016-02-05), 10-K (filing date: 2015-02-27).

1 2018 Calculation
Working capital turnover = Revenue ÷ Working capital
= 94,507 ÷ -5,755 =

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

Comcast Corp., 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 8.51 9.89 10.11 10.80 10.88
Short-term Activity Ratio (no. days)
Average receivable collection period1 43 37 36 34 34
Benchmarks (no. days)
Average Receivable Collection Period, Competitors2
Charter Communications Inc. 14 14 18 10 11
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-01-31), 10-K (filing date: 2017-02-03), 10-K (filing date: 2016-02-05), 10-K (filing date: 2015-02-27).

1 2018 Calculation
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 8.51 = 43

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. Comcast Corp.’s number of days of receivables outstanding deteriorated from 2016 to 2017 and from 2017 to 2018.

Average Payables Payment Period

Comcast Corp., 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 3.50 3.67 3.54 3.63 3.71
Short-term Activity Ratio (no. days)
Average payables payment period1 104 100 103 101 98
Benchmarks (no. days)
Average Payables Payment Period, Competitors2
Charter Communications Inc. 10 10 9 8 9
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-01-31), 10-K (filing date: 2017-02-03), 10-K (filing date: 2016-02-05), 10-K (filing date: 2015-02-27).

1 2018 Calculation
Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ 3.50 = 104

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. Comcast Corp.’s number of days of payables outstanding decreased from 2016 to 2017 but then increased from 2017 to 2018 exceeding 2016 level.