Microsoft Excel LibreOffice Calc

Comcast Corp. (CMCSA)

Short-term (Operating) Activity Analysis
Quarterly Data

Difficulty: Beginner

Activity ratios measure how efficiently a company performs day-to-day tasks, such us the collection of receivables and management of inventory.

Ratios (Summary)

Comcast Corp., short-term (operating) activity ratios (quarterly data)

Microsoft Excel LibreOffice Calc
Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014
Turnover Ratios
Receivables turnover 9.57 9.18 8.51 9.86 9.88 9.92 9.89 10.57 10.70 10.91 10.11 10.44 11.33 11.83 10.80 11.18 10.14 11.27 10.88 — — —
Payables turnover 3.27 3.01 3.50 3.88 3.85 3.64 3.67 3.59 3.86 3.77 3.54 3.60 3.51 3.56 3.63 3.68 3.62 3.32 3.71 — — —
Working capital turnover — — — 24.75 — — — — — — — — — — — — — — — — — —
Average No. of Days
Average receivable collection period 38 40 43 37 37 37 37 35 34 33 36 35 32 31 34 33 36 32 34 — — —
Average payables payment period 111 121 104 94 95 100 100 102 95 97 103 101 104 103 101 99 101 110 98 — — —

Based on: 10-Q (filing date: 2019-07-25), 10-Q (filing date: 2019-04-25), 10-K (filing date: 2019-01-31), 10-Q (filing date: 2018-10-25), 10-Q (filing date: 2018-07-26), 10-Q (filing date: 2018-04-25), 10-K (filing date: 2018-01-31), 10-Q (filing date: 2017-10-26), 10-Q (filing date: 2017-07-27), 10-Q (filing date: 2017-04-27), 10-K (filing date: 2017-02-03), 10-Q (filing date: 2016-10-26), 10-Q (filing date: 2016-07-27), 10-Q (filing date: 2016-04-27), 10-K (filing date: 2016-02-05), 10-Q (filing date: 2015-10-27), 10-Q (filing date: 2015-07-23), 10-Q (filing date: 2015-05-04), 10-K (filing date: 2015-02-27), 10-Q (filing date: 2014-10-23), 10-Q (filing date: 2014-07-24), 10-Q (filing date: 2014-04-22).

Ratio Description The company
Receivables turnover An activity ratio equal to revenue divided by receivables. Comcast Corp.’s receivables turnover improved from Q4 2018 to Q1 2019 and from Q1 2019 to Q2 2019.
Payables turnover An activity ratio calculated as cost of goods sold divided by payables. Comcast Corp.’s payables turnover declined from Q4 2018 to Q1 2019 but then increased from Q1 2019 to Q2 2019 not reaching Q4 2018 level.
Working capital turnover An activity ratio calculated as revenue divided by working capital.
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 average receivable collection period improved from Q4 2018 to Q1 2019 and from Q1 2019 to Q2 2019.
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 average payables payment period increased from Q4 2018 to Q1 2019 but then slightly declined from Q1 2019 to Q2 2019 not reaching Q4 2018 level.

Receivables Turnover

Comcast Corp., receivables turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014
Selected Financial Data (US$ in millions)
Revenue 26,858  26,859  27,846  22,135  21,735  22,791  21,915  20,983  21,165  20,463  21,025  21,319  19,269  18,790  19,245  18,669  18,743  17,853  17,732  16,791  16,844  17,408 
Receivables, net 10,835  10,736  11,104  8,983  8,847  8,759  8,546  7,915  7,849  7,525  7,955  7,533  6,708  6,375  6,896  6,527  7,016  6,144  6,321  6,172  6,232  6,151 
Ratio
Receivables turnover1 9.57 9.18 8.51 9.86 9.88 9.92 9.89 10.57 10.70 10.91 10.11 10.44 11.33 11.83 10.80 11.18 10.14 11.27 10.88 — — —
Benchmarks
Receivables Turnover, Competitors2
Charter Communications Inc. 21.58 28.00 25.18 24.77 26.29 29.86 25.43 24.97 27.42 27.95 20.25 17.10 10.19 39.22 34.96 32.88 29.40 35.11 31.96 — — —
Walt Disney Co. 4.10 5.87 6.37 5.75 5.88 5.63 6.39 5.76 5.98 5.59 6.14 6.25 6.18 5.27 6.54 6.41 6.21 5.81 6.24 6.36 6.21 5.74

Based on: 10-Q (filing date: 2019-07-25), 10-Q (filing date: 2019-04-25), 10-K (filing date: 2019-01-31), 10-Q (filing date: 2018-10-25), 10-Q (filing date: 2018-07-26), 10-Q (filing date: 2018-04-25), 10-K (filing date: 2018-01-31), 10-Q (filing date: 2017-10-26), 10-Q (filing date: 2017-07-27), 10-Q (filing date: 2017-04-27), 10-K (filing date: 2017-02-03), 10-Q (filing date: 2016-10-26), 10-Q (filing date: 2016-07-27), 10-Q (filing date: 2016-04-27), 10-K (filing date: 2016-02-05), 10-Q (filing date: 2015-10-27), 10-Q (filing date: 2015-07-23), 10-Q (filing date: 2015-05-04), 10-K (filing date: 2015-02-27), 10-Q (filing date: 2014-10-23), 10-Q (filing date: 2014-07-24), 10-Q (filing date: 2014-04-22).

1 Q2 2019 Calculation
Receivables turnover = (RevenueQ2 2019 + RevenueQ1 2019 + RevenueQ4 2018 + RevenueQ3 2018) ÷ Receivables, net
= (26,858 + 26,859 + 27,846 + 22,135) ÷ 10,835 = 9.57

2 Click competitor name to see calculations.

Ratio Description The company
Receivables turnover An activity ratio equal to revenue divided by receivables. Comcast Corp.’s receivables turnover improved from Q4 2018 to Q1 2019 and from Q1 2019 to Q2 2019.

Payables Turnover

Comcast Corp., payables turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014
Selected Financial Data (US$ in millions)
Programming and production 8,255  8,569  9,252  6,711  6,300  7,429  6,892  6,077  6,341  6,074  6,537  7,003  5,492  5,431  5,836  5,582  5,669  5,463  5,358  4,772  4,874  5,908 
Accounts payable and accrued expenses related to trade creditors 10,014  10,232  8,494  7,036  6,940  7,349  6,926  6,976  6,730  6,658  6,915  6,594  6,359  6,333  6,215  5,996  5,880  6,157  5,638  5,680  5,432  5,534 
Ratio
Payables turnover1 3.27 3.01 3.50 3.88 3.85 3.64 3.67 3.59 3.86 3.77 3.54 3.60 3.51 3.56 3.63 3.68 3.62 3.32 3.71 — — —

Based on: 10-Q (filing date: 2019-07-25), 10-Q (filing date: 2019-04-25), 10-K (filing date: 2019-01-31), 10-Q (filing date: 2018-10-25), 10-Q (filing date: 2018-07-26), 10-Q (filing date: 2018-04-25), 10-K (filing date: 2018-01-31), 10-Q (filing date: 2017-10-26), 10-Q (filing date: 2017-07-27), 10-Q (filing date: 2017-04-27), 10-K (filing date: 2017-02-03), 10-Q (filing date: 2016-10-26), 10-Q (filing date: 2016-07-27), 10-Q (filing date: 2016-04-27), 10-K (filing date: 2016-02-05), 10-Q (filing date: 2015-10-27), 10-Q (filing date: 2015-07-23), 10-Q (filing date: 2015-05-04), 10-K (filing date: 2015-02-27), 10-Q (filing date: 2014-10-23), 10-Q (filing date: 2014-07-24), 10-Q (filing date: 2014-04-22).

1 Q2 2019 Calculation
Payables turnover = (Programming and productionQ2 2019 + Programming and productionQ1 2019 + Programming and productionQ4 2018 + Programming and productionQ3 2018) ÷ Accounts payable and accrued expenses related to trade creditors
= (8,255 + 8,569 + 9,252 + 6,711) ÷ 10,014 = 3.27

Ratio Description The company
Payables turnover An activity ratio calculated as cost of goods sold divided by payables. Comcast Corp.’s payables turnover declined from Q4 2018 to Q1 2019 but then increased from Q1 2019 to Q2 2019 not reaching Q4 2018 level.

Working Capital Turnover

Comcast Corp., working capital turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014
Selected Financial Data (US$ in millions)
Current assets 21,361  20,273  21,848  23,206  18,215  18,753  16,060  15,960  14,832  15,245  16,361  15,228  14,777  15,180  12,303  11,501  13,319  12,921  13,531  13,936  12,772  14,043 
Less: Current liabilities 31,008  27,917  27,603  19,627  19,007  19,179  21,561  21,449  22,276  19,074  21,535  18,038  17,601  19,084  18,178  17,359  17,565  18,502  17,410  17,084  17,375  17,803 
Working capital (9,647) (7,644) (5,755) 3,579  (792) (426) (5,501) (5,489) (7,444) (3,829) (5,174) (2,810) (2,824) (3,904) (5,875) (5,858) (4,246) (5,581) (3,879) (3,148) (4,603) (3,760)
Revenue 26,858  26,859  27,846  22,135  21,735  22,791  21,915  20,983  21,165  20,463  21,025  21,319  19,269  18,790  19,245  18,669  18,743  17,853  17,732  16,791  16,844  17,408 
Ratio
Working capital turnover1 — — — 24.75 — — — — — — — — — — — — — — — — — —
Benchmarks
Working Capital Turnover, Competitors2
Charter Communications Inc. — — — — — — — — — — — — — — — — — — — — — —
Walt Disney Co. — — — — — — — 973.68 — — 448.65 — — — 123.74 30.45 22.68 114.44 25.91 25.89 — 686.70

Based on: 10-Q (filing date: 2019-07-25), 10-Q (filing date: 2019-04-25), 10-K (filing date: 2019-01-31), 10-Q (filing date: 2018-10-25), 10-Q (filing date: 2018-07-26), 10-Q (filing date: 2018-04-25), 10-K (filing date: 2018-01-31), 10-Q (filing date: 2017-10-26), 10-Q (filing date: 2017-07-27), 10-Q (filing date: 2017-04-27), 10-K (filing date: 2017-02-03), 10-Q (filing date: 2016-10-26), 10-Q (filing date: 2016-07-27), 10-Q (filing date: 2016-04-27), 10-K (filing date: 2016-02-05), 10-Q (filing date: 2015-10-27), 10-Q (filing date: 2015-07-23), 10-Q (filing date: 2015-05-04), 10-K (filing date: 2015-02-27), 10-Q (filing date: 2014-10-23), 10-Q (filing date: 2014-07-24), 10-Q (filing date: 2014-04-22).

1 Q2 2019 Calculation
Working capital turnover = (RevenueQ2 2019 + RevenueQ1 2019 + RevenueQ4 2018 + RevenueQ3 2018) ÷ Working capital
= (26,858 + 26,859 + 27,846 + 22,135) ÷ -9,647 = —

2 Click competitor name to see calculations.

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 (quarterly data)

Microsoft Excel LibreOffice Calc
Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014
Selected Financial Data
Receivables turnover 9.57 9.18 8.51 9.86 9.88 9.92 9.89 10.57 10.70 10.91 10.11 10.44 11.33 11.83 10.80 11.18 10.14 11.27 10.88 — — —
Ratio (no. of days)
Average receivable collection period1 38 40 43 37 37 37 37 35 34 33 36 35 32 31 34 33 36 32 34 — — —
Benchmarks (no. of days)
Average Receivable Collection Period, Competitors2
Charter Communications Inc. 17 13 14 15 14 12 14 15 13 13 18 21 36 9 10 11 12 10 11 — — —
Walt Disney Co. 89 62 57 63 62 65 57 63 61 65 59 58 59 69 56 57 59 63 58 57 59 64

Based on: 10-Q (filing date: 2019-07-25), 10-Q (filing date: 2019-04-25), 10-K (filing date: 2019-01-31), 10-Q (filing date: 2018-10-25), 10-Q (filing date: 2018-07-26), 10-Q (filing date: 2018-04-25), 10-K (filing date: 2018-01-31), 10-Q (filing date: 2017-10-26), 10-Q (filing date: 2017-07-27), 10-Q (filing date: 2017-04-27), 10-K (filing date: 2017-02-03), 10-Q (filing date: 2016-10-26), 10-Q (filing date: 2016-07-27), 10-Q (filing date: 2016-04-27), 10-K (filing date: 2016-02-05), 10-Q (filing date: 2015-10-27), 10-Q (filing date: 2015-07-23), 10-Q (filing date: 2015-05-04), 10-K (filing date: 2015-02-27), 10-Q (filing date: 2014-10-23), 10-Q (filing date: 2014-07-24), 10-Q (filing date: 2014-04-22).

1 Q2 2019 Calculation
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 9.57 = 38

2 Click competitor name to see calculations.

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 average receivable collection period improved from Q4 2018 to Q1 2019 and from Q1 2019 to Q2 2019.

Average Payables Payment Period

Comcast Corp., average payables payment period calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014
Selected Financial Data
Payables turnover 3.27 3.01 3.50 3.88 3.85 3.64 3.67 3.59 3.86 3.77 3.54 3.60 3.51 3.56 3.63 3.68 3.62 3.32 3.71 — — —
Ratio (no. of days)
Average payables payment period1 111 121 104 94 95 100 100 102 95 97 103 101 104 103 101 99 101 110 98 — — —

Based on: 10-Q (filing date: 2019-07-25), 10-Q (filing date: 2019-04-25), 10-K (filing date: 2019-01-31), 10-Q (filing date: 2018-10-25), 10-Q (filing date: 2018-07-26), 10-Q (filing date: 2018-04-25), 10-K (filing date: 2018-01-31), 10-Q (filing date: 2017-10-26), 10-Q (filing date: 2017-07-27), 10-Q (filing date: 2017-04-27), 10-K (filing date: 2017-02-03), 10-Q (filing date: 2016-10-26), 10-Q (filing date: 2016-07-27), 10-Q (filing date: 2016-04-27), 10-K (filing date: 2016-02-05), 10-Q (filing date: 2015-10-27), 10-Q (filing date: 2015-07-23), 10-Q (filing date: 2015-05-04), 10-K (filing date: 2015-02-27), 10-Q (filing date: 2014-10-23), 10-Q (filing date: 2014-07-24), 10-Q (filing date: 2014-04-22).

1 Q2 2019 Calculation
Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ 3.27 = 111

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 average payables payment period increased from Q4 2018 to Q1 2019 but then slightly declined from Q1 2019 to Q2 2019 not reaching Q4 2018 level.