Stock Analysis on Net

Comcast Corp. (NASDAQ:CMCSA)

Analysis of Solvency Ratios
Quarterly Data

Microsoft Excel

Solvency Ratios (Summary)

Comcast Corp., solvency ratios (quarterly data)

Microsoft Excel
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
Debt Ratios
Debt to equity 1.17 1.18 1.16 1.16 1.17 1.15 1.02 1.00 0.99 1.01 1.04 1.12 1.15 1.21 1.25 1.27 1.24 1.29 1.40 1.46
Debt to capital 0.54 0.54 0.54 0.54 0.54 0.54 0.51 0.50 0.50 0.50 0.51 0.53 0.53 0.55 0.56 0.56 0.55 0.56 0.58 0.59
Debt to assets 0.37 0.37 0.37 0.37 0.37 0.36 0.35 0.35 0.34 0.35 0.36 0.37 0.38 0.39 0.39 0.39 0.39 0.39 0.42 0.43
Financial leverage 3.20 3.16 3.12 3.15 3.18 3.17 2.92 2.89 2.87 2.89 2.92 3.01 3.03 3.12 3.18 3.22 3.18 3.28 3.34 3.42
Coverage Ratios
Interest coverage 6.01 5.97 3.79 3.50 3.38 3.35 5.43 5.57 5.46 5.67 4.94 4.54 4.07 3.94 4.26 4.29 4.72

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

Solvency ratio Description The company
Debt to equity ratio A solvency ratio calculated as total debt divided by total shareholders’ equity. Comcast Corp. debt to equity ratio deteriorated from Q2 2023 to Q3 2023 but then slightly improved from Q3 2023 to Q4 2023.
Debt to capital ratio A solvency ratio calculated as total debt divided by total debt plus shareholders’ equity. Comcast Corp. debt to capital ratio deteriorated from Q2 2023 to Q3 2023 but then slightly improved from Q3 2023 to Q4 2023.
Debt to assets ratio A solvency ratio calculated as total debt divided by total assets. Comcast Corp. debt to assets ratio deteriorated from Q2 2023 to Q3 2023 but then improved from Q3 2023 to Q4 2023 exceeding Q2 2023 level.
Financial leverage ratio A solvency ratio calculated as total assets divided by total shareholders’ equity. Comcast Corp. financial leverage ratio increased from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.

Solvency ratio Description The company
Interest coverage ratio A solvency ratio calculated as EBIT divided by interest payments. Comcast Corp. interest coverage ratio improved from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.

Debt to Equity

Comcast Corp., debt to equity calculation (quarterly data)

Microsoft Excel
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 portion of long-term debt 2,069 2,978 2,524 1,130 1,743 2,047 2,083 2,117 2,132 694 3,407 4,777 3,146 4,429 4,046 2,973 4,452 1,039 6,365 4,629
Long-term debt, less current portion 95,021 94,351 94,972 94,403 93,068 90,404 91,459 92,443 92,718 96,522 95,175 98,936 100,614 99,995 100,764 100,604 97,765 99,847 101,248 104,464
Total debt 97,090 97,329 97,496 95,533 94,811 92,451 93,542 94,560 94,850 97,216 98,582 103,713 103,760 104,424 104,810 103,577 102,217 100,886 107,613 109,093
 
Total Comcast Corporation shareholders’ equity 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
Solvency Ratio
Debt to equity1 1.17 1.18 1.16 1.16 1.17 1.15 1.02 1.00 0.99 1.01 1.04 1.12 1.15 1.21 1.25 1.27 1.24 1.29 1.40 1.46
Benchmarks
Debt to Equity, Competitors2
Alphabet Inc. 0.05 0.05 0.05 0.05 0.06 0.06 0.06 0.06 0.06 0.06 0.06 0.06 0.06 0.07 0.02 0.02 0.02 0.02 0.02 0.02
Meta Platforms Inc. 0.12 0.13 0.14 0.08 0.08 0.08 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Netflix Inc. 0.71 0.65 0.63 0.66 0.69 0.68 0.75 0.83 0.97 1.01 1.13 1.21 1.47 1.55 1.69 1.74 1.95 1.81 2.06 1.81
Walt Disney Co. 0.47 0.48 0.50 0.50 0.51 0.56 0.57 0.60 0.61 0.64 0.66 0.69 0.70 0.75 0.61 0.54 0.53 0.64 0.63 0.41

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
Debt to equity = Total debt ÷ Total Comcast Corporation shareholders’ equity
= 97,090 ÷ 82,703 = 1.17

2 Click competitor name to see calculations.

Solvency ratio Description The company
Debt to equity ratio A solvency ratio calculated as total debt divided by total shareholders’ equity. Comcast Corp. debt to equity ratio deteriorated from Q2 2023 to Q3 2023 but then slightly improved from Q3 2023 to Q4 2023.

Debt to Capital

Comcast Corp., debt to capital calculation (quarterly data)

Microsoft Excel
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 portion of long-term debt 2,069 2,978 2,524 1,130 1,743 2,047 2,083 2,117 2,132 694 3,407 4,777 3,146 4,429 4,046 2,973 4,452 1,039 6,365 4,629
Long-term debt, less current portion 95,021 94,351 94,972 94,403 93,068 90,404 91,459 92,443 92,718 96,522 95,175 98,936 100,614 99,995 100,764 100,604 97,765 99,847 101,248 104,464
Total debt 97,090 97,329 97,496 95,533 94,811 92,451 93,542 94,560 94,850 97,216 98,582 103,713 103,760 104,424 104,810 103,577 102,217 100,886 107,613 109,093
Total Comcast Corporation shareholders’ equity 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
Total capital 179,793 179,954 181,615 177,954 175,754 172,747 184,968 189,253 190,942 192,998 193,517 196,288 194,083 190,600 188,424 185,083 184,943 179,030 184,463 184,052
Solvency Ratio
Debt to capital1 0.54 0.54 0.54 0.54 0.54 0.54 0.51 0.50 0.50 0.50 0.51 0.53 0.53 0.55 0.56 0.56 0.55 0.56 0.58 0.59
Benchmarks
Debt to Capital, Competitors2
Alphabet Inc. 0.04 0.05 0.05 0.05 0.05 0.05 0.05 0.06 0.06 0.06 0.06 0.06 0.06 0.06 0.02 0.02 0.02 0.02 0.02 0.02
Meta Platforms Inc. 0.11 0.11 0.12 0.07 0.07 0.07 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Netflix Inc. 0.41 0.39 0.39 0.40 0.41 0.40 0.43 0.45 0.49 0.50 0.53 0.55 0.60 0.61 0.63 0.64 0.66 0.64 0.67 0.64
Walt Disney Co. 0.32 0.33 0.33 0.33 0.34 0.36 0.36 0.38 0.38 0.39 0.40 0.41 0.41 0.43 0.38 0.35 0.35 0.39 0.39 0.29

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
Debt to capital = Total debt ÷ Total capital
= 97,090 ÷ 179,793 = 0.54

2 Click competitor name to see calculations.

Solvency ratio Description The company
Debt to capital ratio A solvency ratio calculated as total debt divided by total debt plus shareholders’ equity. Comcast Corp. debt to capital ratio deteriorated from Q2 2023 to Q3 2023 but then slightly improved from Q3 2023 to Q4 2023.

Debt to Assets

Comcast Corp., debt to assets calculation (quarterly data)

Microsoft Excel
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 portion of long-term debt 2,069 2,978 2,524 1,130 1,743 2,047 2,083 2,117 2,132 694 3,407 4,777 3,146 4,429 4,046 2,973 4,452 1,039 6,365 4,629
Long-term debt, less current portion 95,021 94,351 94,972 94,403 93,068 90,404 91,459 92,443 92,718 96,522 95,175 98,936 100,614 99,995 100,764 100,604 97,765 99,847 101,248 104,464
Total debt 97,090 97,329 97,496 95,533 94,811 92,451 93,542 94,560 94,850 97,216 98,582 103,713 103,760 104,424 104,810 103,577 102,217 100,886 107,613 109,093
 
Total assets 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
Solvency Ratio
Debt to assets1 0.37 0.37 0.37 0.37 0.37 0.36 0.35 0.35 0.34 0.35 0.36 0.37 0.38 0.39 0.39 0.39 0.39 0.39 0.42 0.43
Benchmarks
Debt to Assets, Competitors2
Alphabet Inc. 0.03 0.03 0.04 0.04 0.04 0.04 0.04 0.04 0.04 0.04 0.04 0.04 0.04 0.05 0.01 0.02 0.02 0.02 0.02 0.02
Meta Platforms Inc. 0.08 0.08 0.09 0.05 0.05 0.06 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Netflix Inc. 0.30 0.29 0.28 0.29 0.30 0.29 0.31 0.32 0.35 0.36 0.38 0.39 0.42 0.42 0.42 0.42 0.43 0.40 0.42 0.38
Walt Disney Co. 0.23 0.23 0.24 0.24 0.24 0.25 0.26 0.27 0.27 0.28 0.28 0.29 0.29 0.31 0.27 0.24 0.24 0.28 0.27 0.21

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
Debt to assets = Total debt ÷ Total assets
= 97,090 ÷ 264,811 = 0.37

2 Click competitor name to see calculations.

Solvency ratio Description The company
Debt to assets ratio A solvency ratio calculated as total debt divided by total assets. Comcast Corp. debt to assets ratio deteriorated from Q2 2023 to Q3 2023 but then improved from Q3 2023 to Q4 2023 exceeding Q2 2023 level.

Financial Leverage

Comcast Corp., financial leverage calculation (quarterly data)

Microsoft Excel
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)
Total assets 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
Total Comcast Corporation shareholders’ equity 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
Solvency Ratio
Financial leverage1 3.20 3.16 3.12 3.15 3.18 3.17 2.92 2.89 2.87 2.89 2.92 3.01 3.03 3.12 3.18 3.22 3.18 3.28 3.34 3.42
Benchmarks
Financial Leverage, Competitors2
Alphabet Inc. 1.42 1.45 1.43 1.42 1.43 1.41 1.39 1.41 1.43 1.42 1.41 1.42 1.44 1.41 1.34 1.34 1.37 1.35 1.34 1.34
Meta Platforms Inc. 1.50 1.51 1.54 1.48 1.48 1.44 1.35 1.33 1.33 1.27 1.23 1.22 1.24 1.24 1.26 1.31 1.32 1.32 1.32 1.27
Netflix Inc. 2.37 2.24 2.23 2.27 2.34 2.32 2.43 2.58 2.81 2.79 2.96 3.11 3.55 3.74 3.98 4.17 4.48 4.51 4.94 4.77
Walt Disney Co. 2.07 2.09 2.09 2.10 2.14 2.21 2.23 2.26 2.30 2.33 2.34 2.40 2.41 2.42 2.28 2.24 2.18 2.32 2.38 1.99

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
Financial leverage = Total assets ÷ Total Comcast Corporation shareholders’ equity
= 264,811 ÷ 82,703 = 3.20

2 Click competitor name to see calculations.

Solvency ratio Description The company
Financial leverage ratio A solvency ratio calculated as total assets divided by total shareholders’ equity. Comcast Corp. financial leverage ratio increased from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.

Interest Coverage

Comcast Corp., interest coverage calculation (quarterly data)

Microsoft Excel
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)
Net income (loss) attributable to Comcast Corporation 3,260 4,046 4,248 3,834 3,023 (4,598) 3,396 3,549 3,057 4,035 3,738 3,329 3,380 2,019 2,988 2,147 3,162 3,217 3,125 3,553
Add: Net income attributable to noncontrolling interest (106) (49) (59) (67) (149) (68) (155) (73) (77) (104) (108) (37) 57 12 21 77 38 71 78 79
Add: Income tax expense 890 1,468 1,537 1,476 796 1,014 1,261 1,288 906 1,235 2,000 1,119 979 739 946 700 861 775 961 1,076
Add: Interest expense 1,019 1,060 998 1,010 975 960 968 993 1,120 1,050 1,093 1,018 1,044 1,220 1,112 1,212 1,113 1,167 1,137 1,150
Earnings before interest and tax (EBIT) 5,063 6,525 6,724 6,253 4,645 (2,692) 5,470 5,757 5,006 6,216 6,723 5,429 5,460 3,990 5,067 4,136 5,174 5,230 5,301 5,858
Solvency Ratio
Interest coverage1 6.01 5.97 3.79 3.50 3.38 3.35 5.43 5.57 5.46 5.67 4.94 4.54 4.07 3.94 4.26 4.29 4.72
Benchmarks
Interest Coverage, Competitors2
Netflix Inc. 9.87 8.33 7.95 7.86 8.45 8.97 8.83 8.62 8.63 8.49 7.41 6.71 5.17 4.80 5.21 4.64 4.29

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
Interest coverage = (EBITQ4 2023 + EBITQ3 2023 + EBITQ2 2023 + EBITQ1 2023) ÷ (Interest expenseQ4 2023 + Interest expenseQ3 2023 + Interest expenseQ2 2023 + Interest expenseQ1 2023)
= (5,063 + 6,525 + 6,724 + 6,253) ÷ (1,019 + 1,060 + 998 + 1,010) = 6.01

2 Click competitor name to see calculations.

Solvency ratio Description The company
Interest coverage ratio A solvency ratio calculated as EBIT divided by interest payments. Comcast Corp. interest coverage ratio improved from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.