Stock Analysis on Net

Comcast Corp. (NASDAQ:CMCSA)

Analysis of Short-term (Operating) Activity Ratios 

Microsoft Excel

Short-term Activity Ratios (Summary)

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

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Turnover Ratios
Receivables turnover 9.06 8.80 9.58 9.69 9.03
Payables turnover 3.27 2.96 3.05 3.09 2.91
Working capital turnover
Average No. Days
Average receivable collection period 40 41 38 38 40
Average payables payment period 112 123 120 118 125

Based on: 10-K (reporting date: 2024-12-31), 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-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 2022 to 2023 but then slightly improved from 2023 to 2024.
Payables turnover An activity ratio calculated as cost of goods sold divided by payables. Comcast Corp. payables turnover ratio decreased from 2022 to 2023 but then increased from 2023 to 2024 exceeding 2022 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 2022 to 2023 but then slightly improved from 2023 to 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 2022 to 2023 but then decreased significantly from 2023 to 2024.

Receivables Turnover

Comcast Corp., receivables turnover calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Selected Financial Data (US$ in millions)
Revenue 123,731 121,572 121,427 116,385 103,564
Receivables, net 13,661 13,813 12,672 12,008 11,466
Short-term Activity Ratio
Receivables turnover1 9.06 8.80 9.58 9.69 9.03
Benchmarks
Receivables Turnover, Competitors2
Alphabet Inc. 6.69 6.41 7.03 6.55 5.90
Meta Platforms Inc. 9.68 8.34 8.66 8.40 7.58
Netflix Inc. 29.21 26.20 31.97 36.92 40.92
Walt Disney Co. 7.18 7.21 6.54 5.04 5.15
Receivables Turnover, Sector
Media & Entertainment 7.50 7.94 7.41 6.90
Receivables Turnover, Industry
Communication Services 7.76 8.07 7.77 7.20

Based on: 10-K (reporting date: 2024-12-31), 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31).

1 2024 Calculation
Receivables turnover = Revenue ÷ Receivables, net
= 123,731 ÷ 13,661 = 9.06

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 2022 to 2023 but then slightly improved from 2023 to 2024.

Payables Turnover

Comcast Corp., payables turnover calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Selected Financial Data (US$ in millions)
Programming and production 37,026 36,762 38,213 38,450 33,121
Accounts payable and accrued expenses related to trade creditors 11,321 12,437 12,544 12,455 11,364
Short-term Activity Ratio
Payables turnover1 3.27 2.96 3.05 3.09 2.91
Benchmarks
Payables Turnover, Competitors2
Alphabet Inc. 18.32 17.79 24.61 18.38 15.16
Meta Platforms Inc. 3.92 5.35 5.06 5.55 12.54
Netflix Inc. 23.38 26.38 28.54 20.70 23.28
Walt Disney Co. 3.97 3.91 3.36 2.76 3.33
Payables Turnover, Sector
Media & Entertainment 6.76 6.66 5.90 6.03
Payables Turnover, Industry
Communication Services 4.91 4.73 4.79 4.63

Based on: 10-K (reporting date: 2024-12-31), 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31).

1 2024 Calculation
Payables turnover = Programming and production ÷ Accounts payable and accrued expenses related to trade creditors
= 37,026 ÷ 11,321 = 3.27

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 2022 to 2023 but then increased from 2023 to 2024 exceeding 2022 level.

Working Capital Turnover

Comcast Corp., working capital turnover calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Selected Financial Data (US$ in millions)
Current assets 26,801 23,987 21,826 24,807 26,741
Less: Current liabilities 39,581 40,198 27,887 29,348 28,796
Working capital (12,780) (16,211) (6,061) (4,541) (2,055)
 
Revenue 123,731 121,572 121,427 116,385 103,564
Short-term Activity Ratio
Working capital turnover1
Benchmarks
Working Capital Turnover, Competitors2
Alphabet Inc. 4.69 3.43 2.96 2.08 1.55
Meta Platforms Inc. 2.48 2.53 3.59 2.59 1.42
Netflix Inc. 16.63 31.89 23.67 12.78
Walt Disney Co. 54.74 3,308.88 26.13 7.58
Working Capital Turnover, Sector
Media & Entertainment 5.30 5.15 3.53 2.48
Working Capital Turnover, Industry
Communication Services 10.57 11.82 7.57 4.32

Based on: 10-K (reporting date: 2024-12-31), 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31).

1 2024 Calculation
Working capital turnover = Revenue ÷ Working capital
= 123,731 ÷ -12,780 =

2 Click competitor name to see calculations.


Average Receivable Collection Period

Comcast Corp., average receivable collection period calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Selected Financial Data
Receivables turnover 9.06 8.80 9.58 9.69 9.03
Short-term Activity Ratio (no. days)
Average receivable collection period1 40 41 38 38 40
Benchmarks (no. days)
Average Receivable Collection Period, Competitors2
Alphabet Inc. 55 57 52 56 62
Meta Platforms Inc. 38 44 42 43 48
Netflix Inc. 12 14 11 10 9
Walt Disney Co. 51 51 56 72 71
Average Receivable Collection Period, Sector
Media & Entertainment 49 46 49 53
Average Receivable Collection Period, Industry
Communication Services 47 45 47 51

Based on: 10-K (reporting date: 2024-12-31), 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31).

1 2024 Calculation
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 9.06 = 40

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 2022 to 2023 but then slightly improved from 2023 to 2024.

Average Payables Payment Period

Comcast Corp., average payables payment period calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Selected Financial Data
Payables turnover 3.27 2.96 3.05 3.09 2.91
Short-term Activity Ratio (no. days)
Average payables payment period1 112 123 120 118 125
Benchmarks (no. days)
Average Payables Payment Period, Competitors2
Alphabet Inc. 20 21 15 20 24
Meta Platforms Inc. 93 68 72 66 29
Netflix Inc. 16 14 13 18 16
Walt Disney Co. 92 93 109 132 110
Average Payables Payment Period, Sector
Media & Entertainment 54 55 62 61
Average Payables Payment Period, Industry
Communication Services 74 77 76 79

Based on: 10-K (reporting date: 2024-12-31), 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31).

1 2024 Calculation
Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ 3.27 = 112

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 2022 to 2023 but then decreased significantly from 2023 to 2024.