Stock Analysis on Net

Comcast Corp. (NASDAQ:CMCSA)

Analysis of Liquidity Ratios

Microsoft Excel

Liquidity Ratios (Summary)

Comcast Corp., liquidity ratios

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Current ratio 0.60 0.78 0.85 0.93 0.84
Quick ratio 0.50 0.62 0.71 0.81 0.55
Cash ratio 0.15 0.17 0.30 0.41 0.18

Based on: 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), 10-K (reporting date: 2019-12-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 2021 to 2022 and from 2022 to 2023.
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 2021 to 2022 and from 2022 to 2023.
Cash ratio A liquidity ratio calculated as (cash plus short-term marketable investments) divided by current liabilities. Comcast Corp. cash ratio deteriorated from 2021 to 2022 and from 2022 to 2023.

Current Ratio

Comcast Corp., current ratio calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data (US$ in millions)
Current assets 23,987 21,826 24,807 26,741 25,392
Current liabilities 40,198 27,887 29,348 28,796 30,292
Liquidity Ratio
Current ratio1 0.60 0.78 0.85 0.93 0.84
Benchmarks
Current Ratio, Competitors2
Alphabet Inc. 2.10 2.38 2.93 3.07 3.37
Meta Platforms Inc. 2.67 2.20 3.15 5.05 4.40
Netflix Inc. 1.12 1.17 0.95 1.25 0.90
Walt Disney Co. 1.05 1.00 1.08 1.32 0.90
Current Ratio, Sector
Media & Entertainment 1.67 1.76 2.08 2.38 2.16
Current Ratio, Industry
Communication Services 1.30 1.28 1.41 1.74 1.49

Based on: 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), 10-K (reporting date: 2019-12-31).

1 2023 Calculation
Current ratio = Current assets ÷ Current liabilities
= 23,987 ÷ 40,198 = 0.60

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 2021 to 2022 and from 2022 to 2023.

Quick Ratio

Comcast Corp., quick ratio calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data (US$ in millions)
Cash and cash equivalents 6,215 4,749 8,711 11,740 5,500
Receivables, net 13,813 12,672 12,008 11,466 11,292
Total quick assets 20,028 17,421 20,719 23,206 16,792
 
Current liabilities 40,198 27,887 29,348 28,796 30,292
Liquidity Ratio
Quick ratio1 0.50 0.62 0.71 0.81 0.55
Benchmarks
Quick Ratio, Competitors2
Alphabet Inc. 1.94 2.22 2.79 2.95 3.21
Meta Platforms Inc. 2.55 2.01 2.94 4.89 4.28
Netflix Inc. 1.07 1.12 0.91 1.22 0.87
Walt Disney Co. 0.85 0.83 0.94 1.15 0.67
Quick Ratio, Sector
Media & Entertainment 1.53 1.61 1.94 2.25 1.97
Quick Ratio, Industry
Communication Services 1.11 1.08 1.22 1.53 1.26

Based on: 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), 10-K (reporting date: 2019-12-31).

1 2023 Calculation
Quick ratio = Total quick assets ÷ Current liabilities
= 20,028 ÷ 40,198 = 0.50

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 2021 to 2022 and from 2022 to 2023.

Cash Ratio

Comcast Corp., cash ratio calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data (US$ in millions)
Cash and cash equivalents 6,215 4,749 8,711 11,740 5,500
Total cash assets 6,215 4,749 8,711 11,740 5,500
 
Current liabilities 40,198 27,887 29,348 28,796 30,292
Liquidity Ratio
Cash ratio1 0.15 0.17 0.30 0.41 0.18
Benchmarks
Cash Ratio, Competitors2
Alphabet Inc. 1.36 1.64 2.17 2.41 2.65
Meta Platforms Inc. 2.05 1.51 2.27 4.14 3.64
Netflix Inc. 0.81 0.76 0.71 1.05 0.73
Walt Disney Co. 0.46 0.40 0.51 0.67 0.17
Cash Ratio, Sector
Media & Entertainment 1.05 1.10 1.42 1.75 1.48
Cash Ratio, Industry
Communication Services 0.68 0.64 0.80 1.07 0.81

Based on: 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), 10-K (reporting date: 2019-12-31).

1 2023 Calculation
Cash ratio = Total cash assets ÷ Current liabilities
= 6,215 ÷ 40,198 = 0.15

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 2021 to 2022 and from 2022 to 2023.