Stock Analysis on Net

Comcast Corp. (NASDAQ:CMCSA)

Analysis of Short-term (Operating) Activity Ratios
Quarterly Data

Microsoft Excel

Short-term Activity Ratios (Summary)

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

Microsoft Excel
Dec 31, 2023 Sep 30, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 Jun 30, 2022 Mar 31, 2022 Dec 31, 2021 Sep 30, 2021 Jun 30, 2021 Mar 31, 2021 Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019
Turnover Ratios
Receivables turnover 8.80 9.42 9.29 9.78 9.58 10.17 10.18 9.77 9.69 9.50 9.81 9.48 9.03 10.11 10.32 10.06 9.65
Payables turnover 2.96 2.97 3.00 3.01 3.05 3.13 3.23 3.16 3.09 3.16 3.10 3.03 2.91 3.00 3.14 3.43 3.18
Working capital turnover 165.10
Average No. Days
Average receivable collection period 41 39 39 37 38 36 36 37 38 38 37 38 40 36 35 36 38
Average payables payment period 123 123 122 121 120 117 113 116 118 115 118 121 125 121 116 106 115

Based on: 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).

Short-term activity ratio Description The company
Receivables turnover An activity ratio equal to revenue divided by receivables. Comcast Corp. receivables turnover ratio improved from Q2 2023 to Q3 2023 but then deteriorated significantly from Q3 2023 to Q4 2023.
Payables turnover An activity ratio calculated as cost of goods sold divided by payables. Comcast Corp. payables turnover ratio decreased from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.

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

Comcast Corp., receivables turnover calculation (quarterly data)

Microsoft Excel
Dec 31, 2023 Sep 30, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 Jun 30, 2022 Mar 31, 2022 Dec 31, 2021 Sep 30, 2021 Jun 30, 2021 Mar 31, 2021 Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019
Selected Financial Data (US$ in millions)
Revenue 31,253 30,115 30,513 29,691 30,552 29,849 30,016 31,010 30,336 30,298 28,546 27,205 27,708 25,532 23,715 26,609 28,398 26,827 26,858 26,859
Receivables, net 13,813 12,835 12,980 12,287 12,672 11,918 11,956 12,300 12,008 11,974 11,110 10,986 11,466 10,310 10,227 10,800 11,292 10,684 10,835 10,736
Short-term Activity Ratio
Receivables turnover1 8.80 9.42 9.29 9.78 9.58 10.17 10.18 9.77 9.69 9.50 9.81 9.48 9.03 10.11 10.32 10.06 9.65
Benchmarks
Receivables Turnover, Competitors2
Alphabet Inc. 6.41 7.24 7.46 7.90 7.03 8.13 7.79 7.79 6.55 7.03 6.89 7.02 5.90 6.89 7.83 7.64 6.39
Charter Communications Inc. 18.42 18.61 19.04 19.11 18.49 18.85 19.13 20.70 20.04 19.32 19.35 20.41 21.85 22.84 23.39 22.14 20.55
Meta Platforms Inc. 8.34 9.81 9.63 10.63 8.66 10.52 10.36 10.51 8.40 9.29 8.96 9.19 7.58 9.84 10.04 10.06 7.43
Walt Disney Co. 7.21 6.70 6.81 6.03 6.54 5.93 5.57 4.90 5.04 4.76 4.66 4.32 5.15 5.53 5.38 4.39 4.49 4.13 4.10 5.87

Based on: 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).

1 Q4 2023 Calculation
Receivables turnover = (RevenueQ4 2023 + RevenueQ3 2023 + RevenueQ2 2023 + RevenueQ1 2023) ÷ Receivables, net
= (31,253 + 30,115 + 30,513 + 29,691) ÷ 13,813 = 8.80

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. receivables turnover ratio improved from Q2 2023 to Q3 2023 but then deteriorated significantly from Q3 2023 to Q4 2023.

Payables Turnover

Comcast Corp., payables turnover calculation (quarterly data)

Microsoft Excel
Dec 31, 2023 Sep 30, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 Jun 30, 2022 Mar 31, 2022 Dec 31, 2021 Sep 30, 2021 Jun 30, 2021 Mar 31, 2021 Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019
Selected Financial Data (US$ in millions)
Programming and production 10,257 8,652 8,849 9,004 9,807 8,949 8,887 10,570 9,880 10,395 9,256 8,919 9,438 8,565 6,817 8,301 9,300 8,316 8,255 8,569
Accounts payable and accrued expenses related to trade creditors 12,437 12,214 12,213 12,159 12,544 12,241 12,304 12,707 12,455 12,020 11,672 11,148 11,364 10,979 10,426 9,963 10,826 10,198 10,014 10,232
Short-term Activity Ratio
Payables turnover1 2.96 2.97 3.00 3.01 3.05 3.13 3.23 3.16 3.09 3.16 3.10 3.03 2.91 3.00 3.14 3.43 3.18
Benchmarks
Payables Turnover, Competitors2
Alphabet Inc. 17.79 22.59 24.29 30.41 24.61 19.65 27.29 33.89 18.38 22.54 20.72 18.72 15.16 18.14 18.73 18.26 12.93
Meta Platforms Inc. 5.35 6.08 8.44 6.90 5.06 6.01 5.82 7.25 5.55 9.80 20.49 20.92 12.54 13.54 15.15 16.18 9.37
Netflix Inc. 26.38 37.07 31.96 33.26 28.54 33.93 36.53 28.76 20.70 25.28 25.56 29.17 23.28 26.93 30.91 24.14 18.45

Based on: 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).

1 Q4 2023 Calculation
Payables turnover = (Programming and productionQ4 2023 + Programming and productionQ3 2023 + Programming and productionQ2 2023 + Programming and productionQ1 2023) ÷ Accounts payable and accrued expenses related to trade creditors
= (10,257 + 8,652 + 8,849 + 9,004) ÷ 12,437 = 2.96

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. payables turnover ratio decreased from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.

Working Capital Turnover

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

Microsoft Excel
Dec 31, 2023 Sep 30, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 Jun 30, 2022 Mar 31, 2022 Dec 31, 2021 Sep 30, 2021 Jun 30, 2021 Mar 31, 2021 Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019
Selected Financial Data (US$ in millions)
Current assets 23,987 24,141 24,922 22,377 21,826 23,416 24,192 25,381 24,807 27,427 27,046 29,438 26,741 27,369 27,485 24,084 25,392 22,323 21,361 20,273
Less: Current liabilities 40,198 34,468 32,925 32,415 27,887 27,999 27,585 29,657 29,348 26,738 29,314 30,811 28,796 29,511 28,445 27,600 30,292 25,989 31,008 27,917
Working capital (16,211) (10,327) (8,003) (10,038) (6,061) (4,583) (3,393) (4,276) (4,541) 689 (2,268) (1,373) (2,055) (2,142) (960) (3,516) (4,900) (3,666) (9,647) (7,644)
 
Revenue 31,253 30,115 30,513 29,691 30,552 29,849 30,016 31,010 30,336 30,298 28,546 27,205 27,708 25,532 23,715 26,609 28,398 26,827 26,858 26,859
Short-term Activity Ratio
Working capital turnover1 165.10
Benchmarks
Working Capital Turnover, Competitors2
Alphabet Inc. 3.43 3.30 3.18 3.06 2.96 2.82 2.51 2.33 2.08 1.96 1.84 1.69 1.55 1.48 1.58 1.56 1.51
Charter Communications Inc.
Meta Platforms Inc. 2.53 2.65 3.04 4.33 3.59 3.32 3.54 3.13 2.59 1.95 1.59 1.46 1.42 1.47 1.32 1.35 1.38
Netflix Inc. 31.89 13.41 11.35 14.73 23.67 29.95 91.06 84.84 20.95 15.57 12.30 12.78 12.62 24.13
Walt Disney Co. 54.74 45.26 420.20 3,308.88 112.96 41.96 25.38 26.13 9.70 9.36 7.30 7.58 6.70

Based on: 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).

1 Q4 2023 Calculation
Working capital turnover = (RevenueQ4 2023 + RevenueQ3 2023 + RevenueQ2 2023 + RevenueQ1 2023) ÷ Working capital
= (31,253 + 30,115 + 30,513 + 29,691) ÷ -16,211 =

2 Click competitor name to see calculations.


Average Receivable Collection Period

Comcast Corp., average receivable collection period calculation (quarterly data)

Microsoft Excel
Dec 31, 2023 Sep 30, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 Jun 30, 2022 Mar 31, 2022 Dec 31, 2021 Sep 30, 2021 Jun 30, 2021 Mar 31, 2021 Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019
Selected Financial Data
Receivables turnover 8.80 9.42 9.29 9.78 9.58 10.17 10.18 9.77 9.69 9.50 9.81 9.48 9.03 10.11 10.32 10.06 9.65
Short-term Activity Ratio (no. days)
Average receivable collection period1 41 39 39 37 38 36 36 37 38 38 37 38 40 36 35 36 38
Benchmarks (no. days)
Average Receivable Collection Period, Competitors2
Alphabet Inc. 57 50 49 46 52 45 47 47 56 52 53 52 62 53 47 48 57
Charter Communications Inc. 20 20 19 19 20 19 19 18 18 19 19 18 17 16 16 16 18
Meta Platforms Inc. 44 37 38 34 42 35 35 35 43 39 41 40 48 37 36 36 49
Walt Disney Co. 51 55 54 61 56 62 65 74 72 77 78 84 71 66 68 83 81 88 89 62

Based on: 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).

1 Q4 2023 Calculation
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 8.80 = 41

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

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

Microsoft Excel
Dec 31, 2023 Sep 30, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 Jun 30, 2022 Mar 31, 2022 Dec 31, 2021 Sep 30, 2021 Jun 30, 2021 Mar 31, 2021 Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019
Selected Financial Data
Payables turnover 2.96 2.97 3.00 3.01 3.05 3.13 3.23 3.16 3.09 3.16 3.10 3.03 2.91 3.00 3.14 3.43 3.18
Short-term Activity Ratio (no. days)
Average payables payment period1 123 123 122 121 120 117 113 116 118 115 118 121 125 121 116 106 115
Benchmarks (no. days)
Average Payables Payment Period, Competitors2
Alphabet Inc. 21 16 15 12 15 19 13 11 20 16 18 20 24 20 19 20 28
Meta Platforms Inc. 68 60 43 53 72 61 63 50 66 37 18 17 29 27 24 23 39
Netflix Inc. 14 10 11 11 13 11 10 13 18 14 14 13 16 14 12 15 20

Based on: 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).

1 Q4 2023 Calculation
Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ 2.96 = 123

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.