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
Sep 30, 2024 Jun 30, 2024 Mar 31, 2024 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.77 9.20 9.28 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 3.16 3.04 3.10 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 42 40 39 41 39 39 37 38 36 36 37 38 38 37 38 40 36 35 36 38
Average payables payment period 115 120 118 123 123 122 121 120 117 113 116 118 115 118 121 125 121 116 106 115

Based on: 10-Q (reporting date: 2024-09-30), 10-Q (reporting date: 2024-06-30), 10-Q (reporting date: 2024-03-31), 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 deteriorated from Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024.
Payables turnover An activity ratio calculated as cost of goods sold divided by payables. Comcast Corp. payables turnover ratio decreased from Q1 2024 to Q2 2024 but then increased from Q2 2024 to Q3 2024 exceeding Q1 2024 level.

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. number of days of receivables outstanding deteriorated from Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024.
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. number of days of payables outstanding increased from Q1 2024 to Q2 2024 but then decreased significantly from Q2 2024 to Q3 2024.

Receivables Turnover

Comcast Corp., receivables turnover calculation (quarterly data)

Microsoft Excel
Sep 30, 2024 Jun 30, 2024 Mar 31, 2024 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 32,070 29,688 30,058 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 14,036 13,167 13,144 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.77 9.20 9.28 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.92 6.97 7.14 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
Meta Platforms Inc. 10.63 10.33 10.63 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. 6.94 7.42 6.30 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

Based on: 10-Q (reporting date: 2024-09-30), 10-Q (reporting date: 2024-06-30), 10-Q (reporting date: 2024-03-31), 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 Q3 2024 Calculation
Receivables turnover = (RevenueQ3 2024 + RevenueQ2 2024 + RevenueQ1 2024 + RevenueQ4 2023) ÷ Receivables, net
= (32,070 + 29,688 + 30,058 + 31,253) ÷ 14,036 = 8.77

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 deteriorated from Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024.

Payables Turnover

Comcast Corp., payables turnover calculation (quarterly data)

Microsoft Excel
Sep 30, 2024 Jun 30, 2024 Mar 31, 2024 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,216 7,961 8,823 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 11,779 11,736 11,792 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 3.16 3.04 3.10 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. 20.32 22.98 22.01 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. 3.79 8.78 7.00 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. 32.06 34.06 32.75 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-Q (reporting date: 2024-09-30), 10-Q (reporting date: 2024-06-30), 10-Q (reporting date: 2024-03-31), 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 Q3 2024 Calculation
Payables turnover = (Programming and productionQ3 2024 + Programming and productionQ2 2024 + Programming and productionQ1 2024 + Programming and productionQ4 2023) ÷ Accounts payable and accrued expenses related to trade creditors
= (10,216 + 7,961 + 8,823 + 10,257) ÷ 11,779 = 3.16

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 Q1 2024 to Q2 2024 but then increased from Q2 2024 to Q3 2024 exceeding Q1 2024 level.

Working Capital Turnover

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

Microsoft Excel
Sep 30, 2024 Jun 30, 2024 Mar 31, 2024 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 27,186 23,452 23,978 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 37,786 35,342 40,324 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 (10,600) (11,890) (16,346) (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 32,070 29,688 30,058 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. 4.43 3.90 3.60 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
Meta Platforms Inc. 2.71 3.03 3.02 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. 26.43 55.26 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-Q (reporting date: 2024-09-30), 10-Q (reporting date: 2024-06-30), 10-Q (reporting date: 2024-03-31), 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 Q3 2024 Calculation
Working capital turnover = (RevenueQ3 2024 + RevenueQ2 2024 + RevenueQ1 2024 + RevenueQ4 2023) ÷ Working capital
= (32,070 + 29,688 + 30,058 + 31,253) ÷ -10,600 =

2 Click competitor name to see calculations.


Average Receivable Collection Period

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

Microsoft Excel
Sep 30, 2024 Jun 30, 2024 Mar 31, 2024 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.77 9.20 9.28 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 42 40 39 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. 53 52 51 57 50 49 46 52 45 47 47 56 52 53 52 62 53 47 48 57
Meta Platforms Inc. 34 35 34 44 37 38 34 42 35 35 35 43 39 41 40 48 37 36 36 49
Walt Disney Co. 53 49 58 51 55 54 61 56 62 65 74 72 77 78 84 71 66 68 83 81

Based on: 10-Q (reporting date: 2024-09-30), 10-Q (reporting date: 2024-06-30), 10-Q (reporting date: 2024-03-31), 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 Q3 2024 Calculation
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 8.77 = 42

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. number of days of receivables outstanding deteriorated from Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024.

Average Payables Payment Period

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

Microsoft Excel
Sep 30, 2024 Jun 30, 2024 Mar 31, 2024 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 3.16 3.04 3.10 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 115 120 118 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. 18 16 17 21 16 15 12 15 19 13 11 20 16 18 20 24 20 19 20 28
Meta Platforms Inc. 96 42 52 68 60 43 53 72 61 63 50 66 37 18 17 29 27 24 23 39
Netflix Inc. 11 11 11 14 10 11 11 13 11 10 13 18 14 14 13 16 14 12 15 20

Based on: 10-Q (reporting date: 2024-09-30), 10-Q (reporting date: 2024-06-30), 10-Q (reporting date: 2024-03-31), 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 Q3 2024 Calculation
Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ 3.16 = 115

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. number of days of payables outstanding increased from Q1 2024 to Q2 2024 but then decreased significantly from Q2 2024 to Q3 2024.