Stock Analysis on Net

Comcast Corp. (NASDAQ:CMCSA)

Analysis of Liquidity Ratios
Quarterly Data

Microsoft Excel

Liquidity Ratios (Summary)

Comcast Corp., liquidity 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
Current ratio 0.59 0.60 0.70 0.76 0.69 0.78 0.84 0.88 0.86 0.85 1.03 0.92 0.96 0.93 0.93 0.97 0.87 0.84 0.86 0.69 0.73
Quick ratio 0.49 0.50 0.56 0.61 0.55 0.62 0.63 0.68 0.71 0.71 0.89 0.80 0.84 0.81 0.81 0.85 0.70 0.55 0.55 0.48 0.51
Cash ratio 0.16 0.15 0.19 0.22 0.17 0.17 0.20 0.25 0.30 0.30 0.44 0.42 0.49 0.41 0.46 0.49 0.31 0.18 0.13 0.13 0.13

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).

Liquidity ratio Description The company
Current ratio A liquidity ratio calculated as current assets divided by current liabilities. Comcast Corp. current ratio deteriorated from Q3 2023 to Q4 2023 and from Q4 2023 to Q1 2024.
Quick ratio A liquidity ratio calculated as (cash plus short-term marketable investments plus receivables) divided by current liabilities. Comcast Corp. quick ratio deteriorated from Q3 2023 to Q4 2023 and from Q4 2023 to Q1 2024.
Cash ratio A liquidity ratio calculated as (cash plus short-term marketable investments) divided by current liabilities. Comcast Corp. cash ratio deteriorated from Q3 2023 to Q4 2023 but then slightly improved from Q4 2023 to Q1 2024.

Current Ratio

Comcast Corp., current ratio 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)
Current assets 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
Current liabilities 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
Liquidity Ratio
Current ratio1 0.59 0.60 0.70 0.76 0.69 0.78 0.84 0.88 0.86 0.85 1.03 0.92 0.96 0.93 0.93 0.97 0.87 0.84 0.86 0.69 0.73
Benchmarks
Current Ratio, Competitors2
Alphabet Inc. 2.15 2.10 2.04 2.17 2.35 2.38 2.52 2.81 2.87 2.93 2.98 3.15 3.10 3.07 3.41 3.41 3.66 3.37 3.78 3.98 3.96
Meta Platforms Inc. 2.68 2.67 2.57 2.32 2.07 2.20 2.57 2.52 2.81 3.15 4.23 5.43 6.08 5.05 5.51 6.02 4.60 4.40 4.66 4.47 5.38
Netflix Inc. 1.07 1.12 1.29 1.33 1.26 1.17 1.14 1.05 1.05 0.95 1.17 1.23 1.27 1.25 1.24 1.12 0.82 0.90 0.73 0.85 0.61
Walt Disney Co. 0.84 1.05 1.07 1.01 0.99 1.00 1.02 1.06 1.10 1.08 1.24 1.23 1.31 1.32 1.34 0.94 0.80 0.90 0.70 0.77 1.00

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
Current ratio = Current assets ÷ Current liabilities
= 23,978 ÷ 40,324 = 0.59

2 Click competitor name to see calculations.

Liquidity ratio Description The company
Current ratio A liquidity ratio calculated as current assets divided by current liabilities. Comcast Corp. current ratio deteriorated from Q3 2023 to Q4 2023 and from Q4 2023 to Q1 2024.

Quick Ratio

Comcast Corp., quick ratio 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)
Cash and cash equivalents 6,515 6,215 6,435 7,146 5,535 4,749 5,695 6,822 8,880 8,711 11,806 12,378 14,950 11,740 13,707 13,935 8,516 5,500 3,507 3,919 3,498
Receivables, net 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
Total quick assets 19,659 20,028 19,270 20,126 17,822 17,421 17,613 18,778 21,180 20,719 23,780 23,488 25,936 23,206 24,017 24,162 19,316 16,792 14,191 14,754 14,234
 
Current liabilities 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
Liquidity Ratio
Quick ratio1 0.49 0.50 0.56 0.61 0.55 0.62 0.63 0.68 0.71 0.71 0.89 0.80 0.84 0.81 0.81 0.85 0.70 0.55 0.55 0.48 0.51
Benchmarks
Quick Ratio, Competitors2
Alphabet Inc. 1.98 1.94 1.87 2.02 2.20 2.22 2.29 2.62 2.72 2.79 2.85 3.01 2.94 2.95 3.27 3.26 3.46 3.21 3.62 3.84 3.80
Meta Platforms Inc. 2.55 2.55 2.43 2.20 1.91 2.01 2.34 2.34 2.62 2.94 3.94 5.09 5.86 4.89 5.33 5.81 4.48 4.28 4.50 4.32 5.22
Netflix Inc. 0.76 0.81 0.94 0.99 0.94 0.76 0.79 0.78 0.78 0.71 0.94 0.99 1.06 1.05 1.06 0.94 0.66 0.73 0.61 0.72 0.49
Walt Disney Co. 0.69 0.85 0.87 0.83 0.83 0.83 0.87 0.91 0.98 0.94 1.07 1.07 1.17 1.15 1.16 0.81 0.69 0.67 0.50 0.56 0.83

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
Quick ratio = Total quick assets ÷ Current liabilities
= 19,659 ÷ 40,324 = 0.49

2 Click competitor name to see calculations.

Liquidity ratio Description The company
Quick ratio A liquidity ratio calculated as (cash plus short-term marketable investments plus receivables) divided by current liabilities. Comcast Corp. quick ratio deteriorated from Q3 2023 to Q4 2023 and from Q4 2023 to Q1 2024.

Cash Ratio

Comcast Corp., cash ratio 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)
Cash and cash equivalents 6,515 6,215 6,435 7,146 5,535 4,749 5,695 6,822 8,880 8,711 11,806 12,378 14,950 11,740 13,707 13,935 8,516 5,500 3,507 3,919 3,498
Total cash assets 6,515 6,215 6,435 7,146 5,535 4,749 5,695 6,822 8,880 8,711 11,806 12,378 14,950 11,740 13,707 13,935 8,516 5,500 3,507 3,919 3,498
 
Current liabilities 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
Liquidity Ratio
Cash ratio1 0.16 0.15 0.19 0.22 0.17 0.17 0.20 0.25 0.30 0.30 0.44 0.42 0.49 0.41 0.46 0.49 0.31 0.18 0.13 0.13 0.13
Benchmarks
Cash Ratio, Competitors2
Alphabet Inc. 1.40 1.36 1.39 1.52 1.67 1.64 1.76 2.04 2.16 2.17 2.30 2.44 2.44 2.41 2.75 2.77 2.92 2.65 3.09 3.27 3.25
Meta Platforms Inc. 2.07 2.05 2.00 1.79 1.48 1.51 1.84 1.82 2.08 2.27 3.26 4.31 5.05 4.14 4.66 5.15 4.00 3.64 3.92 3.74 4.57
Netflix Inc. 0.76 0.81 0.94 0.99 0.94 0.76 0.79 0.78 0.78 0.71 0.94 0.99 1.06 1.05 1.06 0.94 0.66 0.73 0.61 0.72 0.49
Walt Disney Co. 0.23 0.46 0.41 0.37 0.31 0.40 0.42 0.45 0.48 0.51 0.59 0.60 0.64 0.67 0.75 0.40 0.20 0.17 0.15 0.23 0.25

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
Cash ratio = Total cash assets ÷ Current liabilities
= 6,515 ÷ 40,324 = 0.16

2 Click competitor name to see calculations.

Liquidity ratio Description The company
Cash ratio A liquidity ratio calculated as (cash plus short-term marketable investments) divided by current liabilities. Comcast Corp. cash ratio deteriorated from Q3 2023 to Q4 2023 but then slightly improved from Q4 2023 to Q1 2024.