Analysis of Long-term (Investment) Activity Ratios
Quarterly Data
Activity ratios measure how efficiently a company performs day-to-day tasks, such us the collection of receivables and management of inventory.
Long-term Activity Ratios (Summary)
Comcast Corp., long-term (investment) activity ratios (quarterly data)
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).
| Long-term activity ratio | Description | The company |
|---|---|---|
| Net fixed asset turnover | An activity ratio calculated as total revenue divided by net fixed assets. | Comcast Corp. net fixed asset turnover ratio deteriorated from Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024. |
| Total asset turnover | An activity ratio calculated as total revenue divided by total assets. | Comcast Corp. total asset turnover ratio deteriorated from Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024. |
| Equity turnover | An activity ratio calculated as total revenue divided by shareholders’ equity. | Comcast Corp. equity turnover ratio deteriorated from Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024. |
Net Fixed Asset Turnover
Comcast Corp., net fixed asset turnover calculation (quarterly data)
| 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) | |||||||
| Property and equipment, net of accumulated depreciation | 61,775) | 60,507) | 59,918) | 59,686) | 58,165) | 56,851) | 56,279) | 55,485) | 53,555) | 53,508) | 53,820) | 54,047) | 52,809) | 52,769) | 52,317) | 51,995) | 50,466) | 48,985) | 48,442) | 48,322) | 46,790) | 46,047) | 45,721) | |||||||
| Long-term Activity Ratio | ||||||||||||||||||||||||||||||
| Net fixed asset turnover1 | 1.99 | 2.00 | 2.04 | 2.04 | 2.08 | 2.12 | 2.13 | 2.19 | 2.26 | 2.27 | 2.23 | 2.15 | 2.15 | 2.07 | 1.99 | 1.99 | 2.07 | 2.15 | 2.24 | 2.25 | — | — | — | |||||||
| Benchmarks | ||||||||||||||||||||||||||||||
| Net Fixed Asset Turnover, Competitors2 | ||||||||||||||||||||||||||||||
| Alphabet Inc. | 2.11 | 2.17 | 2.22 | 2.29 | 2.36 | 2.39 | 2.42 | 2.51 | 2.60 | 2.62 | 2.59 | 2.64 | 2.53 | 2.40 | 2.25 | 2.15 | 2.10 | 2.11 | 2.17 | 2.20 | — | — | — | |||||||
| Meta Platforms Inc. | 1.39 | 1.45 | 1.44 | 1.40 | 1.38 | 1.37 | 1.39 | 1.47 | 1.60 | 1.77 | 1.94 | 2.04 | 2.09 | 2.06 | 1.98 | 1.88 | 1.87 | 1.93 | 1.98 | 2.00 | — | — | — | |||||||
| Netflix Inc. | 23.97 | 24.03 | 23.27 | 22.61 | 21.85 | 21.83 | 22.58 | 22.61 | 22.93 | 22.78 | 21.97 | 22.44 | 23.47 | 24.91 | 25.99 | 26.03 | — | — | — | — | — | — | — | |||||||
| Walt Disney Co. | 2.50 | 2.51 | 2.52 | 2.54 | 2.54 | 2.52 | 2.47 | 2.46 | 2.42 | 2.33 | 2.23 | 2.07 | 1.96 | 1.82 | 1.88 | 2.04 | 2.19 | 2.43 | 2.36 | 2.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
Net fixed asset turnover
= (RevenueQ3 2024
+ RevenueQ2 2024
+ RevenueQ1 2024
+ RevenueQ4 2023)
÷ Property and equipment, net of accumulated depreciation
= (32,070 + 29,688 + 30,058 + 31,253)
÷ 61,775 = 1.99
2 Click competitor name to see calculations.
| Long-term activity ratio | Description | The company |
|---|---|---|
| Net fixed asset turnover | An activity ratio calculated as total revenue divided by net fixed assets. | Comcast Corp. net fixed asset turnover ratio deteriorated from Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024. |
Total Asset Turnover
Comcast Corp., total asset turnover calculation (quarterly data)
| 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) | |||||||
| Total assets | 269,871) | 262,555) | 263,601) | 264,811) | 261,072) | 262,147) | 259,429) | 257,275) | 254,308) | 267,032) | 274,074) | 275,905) | 277,061) | 277,004) | 278,511) | 273,869) | 268,940) | 265,978) | 262,421) | 263,414) | 256,374) | 256,555) | 256,189) | |||||||
| Long-term Activity Ratio | ||||||||||||||||||||||||||||||
| Total asset turnover1 | 0.46 | 0.46 | 0.46 | 0.46 | 0.46 | 0.46 | 0.46 | 0.47 | 0.48 | 0.46 | 0.44 | 0.42 | 0.41 | 0.39 | 0.37 | 0.38 | 0.39 | 0.40 | 0.41 | 0.41 | — | — | — | |||||||
| Benchmarks | ||||||||||||||||||||||||||||||
| Total Asset Turnover, Competitors2 | ||||||||||||||||||||||||||||||
| Alphabet Inc. | 0.79 | 0.79 | 0.78 | 0.76 | 0.75 | 0.76 | 0.77 | 0.77 | 0.79 | 0.78 | 0.76 | 0.72 | 0.69 | 0.66 | 0.60 | 0.57 | 0.57 | 0.60 | 0.61 | 0.59 | — | — | — | |||||||
| Meta Platforms Inc. | 0.61 | 0.65 | 0.64 | 0.59 | 0.59 | 0.58 | 0.64 | 0.63 | 0.66 | 0.70 | 0.73 | 0.71 | 0.66 | 0.61 | 0.58 | 0.54 | 0.54 | 0.54 | 0.53 | 0.53 | — | — | — | |||||||
| Netflix Inc. | 0.72 | 0.74 | 0.72 | 0.69 | 0.66 | 0.63 | 0.64 | 0.65 | 0.66 | 0.67 | 0.67 | 0.67 | 0.67 | 0.67 | 0.66 | 0.64 | — | — | — | — | — | — | — | |||||||
| Walt Disney Co. | 0.46 | 0.46 | 0.45 | 0.43 | 0.43 | 0.42 | 0.42 | 0.41 | 0.40 | 0.38 | 0.36 | 0.33 | 0.31 | 0.29 | 0.30 | 0.32 | 0.34 | 0.38 | 0.37 | 0.36 | — | — | — | |||||||
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
Total asset turnover
= (RevenueQ3 2024
+ RevenueQ2 2024
+ RevenueQ1 2024
+ RevenueQ4 2023)
÷ Total assets
= (32,070 + 29,688 + 30,058 + 31,253)
÷ 269,871 = 0.46
2 Click competitor name to see calculations.
| Long-term activity ratio | Description | The company |
|---|---|---|
| Total asset turnover | An activity ratio calculated as total revenue divided by total assets. | Comcast Corp. total asset turnover ratio deteriorated from Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024. |
Equity Turnover
Comcast Corp., equity turnover calculation (quarterly data)
| 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) | |||||||
| Total Comcast Corporation shareholders’ equity | 85,774) | 83,219) | 82,549) | 82,703) | 82,625) | 84,119) | 82,421) | 80,943) | 80,296) | 91,426) | 94,693) | 96,092) | 95,782) | 94,935) | 92,575) | 90,323) | 86,176) | 83,614) | 81,506) | 82,726) | 78,144) | 76,850) | 74,959) | |||||||
| Long-term Activity Ratio | ||||||||||||||||||||||||||||||
| Equity turnover1 | 1.43 | 1.46 | 1.48 | 1.47 | 1.46 | 1.43 | 1.46 | 1.50 | 1.51 | 1.33 | 1.27 | 1.21 | 1.19 | 1.15 | 1.13 | 1.15 | 1.21 | 1.26 | 1.33 | 1.32 | — | — | — | |||||||
| Benchmarks | ||||||||||||||||||||||||||||||
| Equity Turnover, Competitors2 | ||||||||||||||||||||||||||||||
| Alphabet Inc. | 1.08 | 1.09 | 1.09 | 1.08 | 1.09 | 1.08 | 1.09 | 1.10 | 1.11 | 1.09 | 1.06 | 1.02 | 0.98 | 0.93 | 0.86 | 0.82 | 0.81 | 0.80 | 0.82 | 0.80 | — | — | — | |||||||
| Meta Platforms Inc. | 0.95 | 0.96 | 0.95 | 0.88 | 0.89 | 0.90 | 0.94 | 0.93 | 0.95 | 0.95 | 0.97 | 0.94 | 0.84 | 0.76 | 0.71 | 0.67 | 0.67 | 0.68 | 0.70 | 0.70 | — | — | — | |||||||
| Netflix Inc. | 1.65 | 1.64 | 1.63 | 1.64 | 1.48 | 1.41 | 1.46 | 1.52 | 1.53 | 1.63 | 1.73 | 1.87 | 1.87 | 1.99 | 2.05 | 2.26 | — | — | — | — | — | — | — | |||||||
| Walt Disney Co. | 0.89 | 0.90 | 0.88 | 0.90 | 0.90 | 0.89 | 0.88 | 0.87 | 0.88 | 0.85 | 0.81 | 0.76 | 0.73 | 0.68 | 0.72 | 0.78 | 0.81 | 0.87 | 0.84 | 0.78 | — | — | — | |||||||
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
Equity turnover
= (RevenueQ3 2024
+ RevenueQ2 2024
+ RevenueQ1 2024
+ RevenueQ4 2023)
÷ Total Comcast Corporation shareholders’ equity
= (32,070 + 29,688 + 30,058 + 31,253)
÷ 85,774 = 1.43
2 Click competitor name to see calculations.
| Long-term activity ratio | Description | The company |
|---|---|---|
| Equity turnover | An activity ratio calculated as total revenue divided by shareholders’ equity. | Comcast Corp. equity turnover ratio deteriorated from Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024. |