Microsoft Excel LibreOffice Calc

Comcast Corp. (CMCSA)


Adjustments to Financial Statements

Advanced level


Adjustments to Current Assets

Comcast Corp., adjusted current assets

US$ in millions

Microsoft Excel LibreOffice Calc
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
As Reported
Current assets 21,848  16,060  16,361  12,303  13,531 
Adjustments
Add: Allowance for doubtful accounts 352  288  250  226  205 
After Adjustment
Adjusted current assets 22,200  16,348  16,611  12,529  13,736 

Based on: 10-K (filing date: 2019-01-31), 10-K (filing date: 2018-01-31), 10-K (filing date: 2017-02-03), 10-K (filing date: 2016-02-05), 10-K (filing date: 2015-02-27).


Adjustments to Total Assets

Comcast Corp., adjusted total assets

US$ in millions

Microsoft Excel LibreOffice Calc
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
As Reported
Total assets 251,684  186,949  180,500  166,574  159,339 
Adjustments
Add: Operating lease right-of-use asset (before adoption of FASB Topic 842)1 4,384  3,335  3,189  2,730  1,855 
Add: Allowance for doubtful accounts 352  288  250  226  205 
After Adjustment
Adjusted total assets 256,420  190,572  183,939  169,530  161,399 

Based on: 10-K (filing date: 2019-01-31), 10-K (filing date: 2018-01-31), 10-K (filing date: 2017-02-03), 10-K (filing date: 2016-02-05), 10-K (filing date: 2015-02-27).

1 Operating lease right-of-use asset (before adoption of FASB Topic 842). See details »


Adjustments to Current Liabilities

Comcast Corp., adjusted current liabilities

US$ in millions

Microsoft Excel LibreOffice Calc
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
As Reported
Current liabilities 27,603  21,561  21,535  18,178  17,410 
Adjustments
Less: Current deferred revenue 2,182  1,552  1,132  1,302  915 
After Adjustment
Adjusted current liabilities 25,421  20,009  20,403  16,876  16,495 

Based on: 10-K (filing date: 2019-01-31), 10-K (filing date: 2018-01-31), 10-K (filing date: 2017-02-03), 10-K (filing date: 2016-02-05), 10-K (filing date: 2015-02-27).


Adjustments to Total Liabilities

Comcast Corp., adjusted total liabilities

US$ in millions

Microsoft Excel LibreOffice Calc
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
As Reported
Total liabilities 177,866  116,143  122,880  111,375  105,205 
Adjustments
Add: Operating lease liability (before adoption of FASB Topic 842)1 4,384  3,335  3,189  2,730  1,855 
Less: Deferred income taxes2 27,589  24,256  34,854  33,566  32,959 
Less: Deferred revenue 2,832  1,552  1,132  1,302  915 
After Adjustment
Adjusted total liabilities 151,829  93,670  90,083  79,237  73,186 

Based on: 10-K (filing date: 2019-01-31), 10-K (filing date: 2018-01-31), 10-K (filing date: 2017-02-03), 10-K (filing date: 2016-02-05), 10-K (filing date: 2015-02-27).

1 Operating lease liability (before adoption of FASB Topic 842). See details »

2 Deferred income taxes. See details »


Adjustments to Stockholders’ Equity

Comcast Corp., adjusted total Comcast Corporation shareholders’ equity

US$ in millions

Microsoft Excel LibreOffice Calc
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
As Reported
Total Comcast Corporation shareholders’ equity 71,613  68,606  53,943  52,269  52,711 
Adjustments
Less: Net deferred tax asset (liability)1 (26,369) (24,202) (34,813) (33,566) (32,764)
Add: Allowance for doubtful accounts 352  288  250  226  205 
Add: Deferred revenue 2,832  1,552  1,132  1,302  915 
Add: Redeemable noncontrolling interests and redeemable subsidiary preferred stock 1,316  1,357  1,446  1,221  1,066 
Add: Noncontrolling interests 889  843  2,231  1,709  357 
After Adjustment
Adjusted total equity 103,371  96,848  93,815  90,293  88,018 

Based on: 10-K (filing date: 2019-01-31), 10-K (filing date: 2018-01-31), 10-K (filing date: 2017-02-03), 10-K (filing date: 2016-02-05), 10-K (filing date: 2015-02-27).

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


Adjustments to Capitalization Table

Comcast Corp., adjusted capitalization table

US$ in millions

Microsoft Excel LibreOffice Calc
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
As Reported
Current portion of long-term debt 4,398  5,134  5,480  3,627  4,217 
Long-term debt, less current portion 107,345  59,422  55,566  48,994  44,017 
Total reported debt 111,743  64,556  61,046  52,621  48,234 
Total Comcast Corporation shareholders’ equity 71,613  68,606  53,943  52,269  52,711 
Total reported capital 183,356  133,162  114,989  104,890  100,945 
Adjustments to Debt
Add: Operating lease liability (before adoption of FASB Topic 842)1 4,384  3,335  3,189  2,730  1,855 
Adjusted total debt 116,127  67,891  64,235  55,351  50,089 
Adjustments to Equity
Less: Net deferred tax asset (liability)2 (26,369) (24,202) (34,813) (33,566) (32,764)
Add: Allowance for doubtful accounts 352  288  250  226  205 
Add: Deferred revenue 2,832  1,552  1,132  1,302  915 
Add: Redeemable noncontrolling interests and redeemable subsidiary preferred stock 1,316  1,357  1,446  1,221  1,066 
Add: Noncontrolling interests 889  843  2,231  1,709  357 
Adjusted total equity 103,371  96,848  93,815  90,293  88,018 
After Adjustment
Adjusted total capital 219,498  164,739  158,050  145,644  138,107 

Based on: 10-K (filing date: 2019-01-31), 10-K (filing date: 2018-01-31), 10-K (filing date: 2017-02-03), 10-K (filing date: 2016-02-05), 10-K (filing date: 2015-02-27).

1 Operating lease liability (before adoption of FASB Topic 842). See details »

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


Adjustments to Revenues

Comcast Corp., adjusted revenue

US$ in millions

Microsoft Excel LibreOffice Calc
12 months ended Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
As Reported
Revenue 94,507  84,526  80,403  74,510  68,775 
Adjustment
Add: Increase (decrease) in deferred revenue 648  420  (170) 387  17 
After Adjustment
Adjusted revenue 95,155  84,946  80,233  74,897  68,792 

Based on: 10-K (filing date: 2019-01-31), 10-K (filing date: 2018-01-31), 10-K (filing date: 2017-02-03), 10-K (filing date: 2016-02-05), 10-K (filing date: 2015-02-27).


Adjustments to Reported Income

Comcast Corp., adjusted net income attributable to Comcast Corporation

US$ in millions

Microsoft Excel LibreOffice Calc
12 months ended Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
As Reported
Net income attributable to Comcast Corporation 11,731  22,714  8,695  8,163  8,380 
Adjustments
Add: Deferred income tax expense (benefit)1 290  (10,655) 1,444  958  1,165 
Add: Increase (decrease) in allowance for doubtful accounts 64  38  24  21  (16)
Add: Increase (decrease) in deferred revenue 648  420  (170) 387  17 
Add: Other comprehensive income (loss) (864) 168  346  (57) (202)
Add: Comprehensive income (loss), net of tax, attributable to noncontrolling interest 90  267  424  221  212 
After Adjustment
Adjusted net income 11,959  12,952  10,763  9,693  9,556 

Based on: 10-K (filing date: 2019-01-31), 10-K (filing date: 2018-01-31), 10-K (filing date: 2017-02-03), 10-K (filing date: 2016-02-05), 10-K (filing date: 2015-02-27).

1 Deferred income tax expense (benefit). See details »