Stock Analysis on Net
Stock Analysis on Net

Comcast Corp. (NASDAQ:CMCSA)

Analysis of Long-term (Investment) Activity Ratios
Quarterly Data

Microsoft Excel

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)

Microsoft Excel
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
Net fixed asset turnover 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 — — —
Total asset turnover 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 — — —
Equity turnover 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 — — —

Based on: 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 Q3 2023 to Q4 2023 and from Q4 2023 to Q1 2024.
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Comcast Corp. total asset turnover ratio deteriorated from Q3 2023 to Q4 2023 but then improved from Q4 2023 to Q1 2024 not reaching Q3 2023 level.
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Comcast Corp. equity turnover ratio improved from Q3 2023 to Q4 2023 and from Q4 2023 to Q1 2024.

Net Fixed Asset Turnover

Comcast Corp., net fixed asset turnover calculation (quarterly data)

Microsoft Excel
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 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 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 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.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.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.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 28.76 30.09 32.90 35.66 — — —
Walt Disney Co. 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 2.06 1.93 1.99

Based on: 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 Q1 2024 Calculation
Net fixed asset turnover = (RevenueQ1 2024 + RevenueQ4 2023 + RevenueQ3 2023 + RevenueQ2 2023) ÷ Property and equipment, net of accumulated depreciation
= (30,058 + 31,253 + 30,115 + 30,513) ÷ 59,918 = 2.04

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 Q3 2023 to Q4 2023 and from Q4 2023 to Q1 2024.

Total Asset Turnover

Comcast Corp., total asset turnover calculation (quarterly data)

Microsoft Excel
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 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 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.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.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.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.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 0.62 0.61 0.61 0.59 — — —
Walt Disney Co. 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 0.31 0.28 0.59

Based on: 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 Q1 2024 Calculation
Total asset turnover = (RevenueQ1 2024 + RevenueQ4 2023 + RevenueQ3 2023 + RevenueQ2 2023) ÷ Total assets
= (30,058 + 31,253 + 30,115 + 30,513) ÷ 263,601 = 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 Q3 2023 to Q4 2023 but then improved from Q4 2023 to Q1 2024 not reaching Q3 2023 level.

Equity Turnover

Comcast Corp., equity turnover calculation (quarterly data)

Microsoft Excel
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 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 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.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.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.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.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 2.31 2.42 2.55 2.66 — — —
Walt Disney Co. 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 0.72 0.66 1.18

Based on: 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 Q1 2024 Calculation
Equity turnover = (RevenueQ1 2024 + RevenueQ4 2023 + RevenueQ3 2023 + RevenueQ2 2023) ÷ Total Comcast Corporation shareholders’ equity
= (30,058 + 31,253 + 30,115 + 30,513) ÷ 82,549 = 1.48

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 improved from Q3 2023 to Q4 2023 and from Q4 2023 to Q1 2024.