Activity ratios measure how efficiently a company performs day-to-day tasks, such us the collection of receivables and management of inventory.
Short-term Activity Ratios (Summary)
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
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
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
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
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
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. |