Stock Analysis on Net

Comcast Corp. (NASDAQ:CMCSA)

Adjustments to Financial Statements

Microsoft Excel

Adjustments to Current Assets

Comcast Corp., adjusted current assets

US$ in millions

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
As Reported
Current assets 23,987 21,826 24,807 26,741 25,392
Adjustments
Add: Allowance for credit losses 698 735 658 807 419
After Adjustment
Adjusted current assets 24,685 22,561 25,465 27,548 25,811

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


Adjustments to Total Assets

Comcast Corp., adjusted total assets

US$ in millions

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
As Reported
Total assets 264,811 257,275 275,905 273,869 263,414
Adjustments
Add: Operating lease right-of-use asset (before adoption of FASB Topic 842)1
Add: Allowance for credit losses 698 735 658 807 419
Less: Deferred tax assets2 109 205 282 219 87
After Adjustment
Adjusted total assets 265,400 257,805 276,281 274,457 263,746

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 Operating lease right-of-use asset (before adoption of FASB Topic 842). See details »

2 Deferred tax assets. See details »


Adjustments to Current Liabilities

Comcast Corp., adjusted current liabilities

US$ in millions

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
As Reported
Current liabilities 40,198 27,887 29,348 28,796 30,292
Adjustments
Less: Current deferred revenue 3,242 2,380 3,040 2,963 2,768
After Adjustment
Adjusted current liabilities 36,956 25,507 26,308 25,833 27,524

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


Adjustments to Total Liabilities

Comcast Corp., adjusted total liabilities

US$ in millions

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
As Reported
Total liabilities 181,344 175,236 177,896 180,851 178,168
Adjustments
Add: Operating lease liability (before adoption of FASB Topic 842)1
Less: Deferred tax liabilities2 26,003 28,714 30,041 28,051 28,180
Less: Deferred revenue 3,860 3,115 3,735 3,713 3,386
After Adjustment
Adjusted total liabilities 151,481 143,407 144,120 149,087 146,602

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 Operating lease liability (before adoption of FASB Topic 842). See details »

2 Deferred tax liabilities. See details »


Adjustments to Stockholders’ Equity

Comcast Corp., adjusted total Comcast Corporation shareholders’ equity

US$ in millions

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
As Reported
Total Comcast Corporation shareholders’ equity 82,703 80,943 96,092 90,323 82,726
Adjustments
Less: Net deferred tax asset (liability)1 (25,894) (28,509) (29,759) (27,832) (28,093)
Add: Allowance for credit losses 698 735 658 807 419
Add: Deferred revenue 3,860 3,115 3,735 3,713 3,386
Add: Redeemable noncontrolling interests 241 411 519 1,280 1,372
Add: Noncontrolling interests 523 684 1,398 1,415 1,148
After Adjustment
Adjusted total equity 113,919 114,397 132,161 125,370 117,144

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 Net deferred tax asset (liability). See details »


Adjustments to Capitalization Table

Comcast Corp., adjusted capitalization table

US$ in millions

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
As Reported
Current portion of long-term debt 2,069 1,743 2,132 3,146 4,452
Long-term debt, less current portion 95,021 93,068 92,718 100,614 97,765
Total reported debt 97,090 94,811 94,850 103,760 102,217
Total Comcast Corporation shareholders’ equity 82,703 80,943 96,092 90,323 82,726
Total reported capital 179,793 175,754 190,942 194,083 184,943
Adjustments to Debt
Add: Operating lease liability (before adoption of FASB Topic 842)1
Add: Current operating lease liabilities (included in Accrued expenses and other current liabilities)2 748 675 766 718 715
Add: Noncurrent operating lease liabilities (included in Other noncurrent liabilities)3 5,838 6,107 6,473 3,740 3,891
Adjusted total debt 103,676 101,593 102,089 108,218 106,823
Adjustments to Equity
Less: Net deferred tax asset (liability)4 (25,894) (28,509) (29,759) (27,832) (28,093)
Add: Allowance for credit losses 698 735 658 807 419
Add: Deferred revenue 3,860 3,115 3,735 3,713 3,386
Add: Redeemable noncontrolling interests 241 411 519 1,280 1,372
Add: Noncontrolling interests 523 684 1,398 1,415 1,148
Adjusted total equity 113,919 114,397 132,161 125,370 117,144
After Adjustment
Adjusted total capital 217,595 215,990 234,250 233,588 223,967

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 Operating lease liability (before adoption of FASB Topic 842). See details »

2 Current operating lease liabilities (included in Accrued expenses and other current liabilities). See details »

3 Noncurrent operating lease liabilities (included in Other noncurrent liabilities). See details »

4 Net deferred tax asset (liability). See details »


Adjustments to Revenues

Comcast Corp., adjusted revenue

US$ in millions

Microsoft Excel
12 months ended: Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
As Reported
Revenue 121,572 121,427 116,385 103,564 108,942
Adjustment
Add: Increase (decrease) in deferred revenue 745 (620) 22 327 554
After Adjustment
Adjusted revenue 122,317 120,807 116,407 103,891 109,496

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


Adjustments to Reported Income

Comcast Corp., adjusted net income attributable to Comcast Corporation

US$ in millions

Microsoft Excel
12 months ended: Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
As Reported
Net income attributable to Comcast Corporation 15,388 5,370 14,159 10,534 13,057
Adjustments
Add: Deferred income tax expense (benefit)1 (2,739) (834) 1,892 (550) 563
Add: Increase (decrease) in allowance for credit losses (38) 77 (149) 388 67
Add: Increase (decrease) in deferred revenue 745 (620) 22 327 554
Add: Other comprehensive income (loss) 1,338 (4,120) (397) 897 1,402
Add: Comprehensive income (loss), net of tax, attributable to noncontrolling interest (301) (475) (319) 227 253
After Adjustment
Adjusted net income 14,393 (602) 15,208 11,823 15,896

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 Deferred income tax expense (benefit). See details »