Stock Analysis on Net
Stock Analysis on Net
Microsoft Excel LibreOffice Calc

Alphabet Inc. (NASDAQ:GOOG)

Adjustments to Financial Statements

Advanced level

Adjustments to Current Assets

Alphabet Inc., adjusted current assets

US$ in millions

Microsoft Excel LibreOffice Calc
Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017 Dec 31, 2016
As Reported
Current assets 174,296  152,578  135,676  124,308  105,408 
Adjustments
Add: Allowance for credit losses on accounts receivable 789  753  729  674  467 
After Adjustment
Adjusted current assets 175,085  153,331  136,405  124,982  105,875 

Based on: 10-K (filing date: 2021-02-03), 10-K (filing date: 2020-02-04), 10-K (filing date: 2019-02-05), 10-K (filing date: 2018-02-06), 10-K (filing date: 2017-02-03).


Adjustments to Total Assets

Alphabet Inc., adjusted total assets

US$ in millions

Microsoft Excel LibreOffice Calc
Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017 Dec 31, 2016
As Reported
Total assets 319,616  275,909  232,792  197,295  167,497 
Adjustments
Add: Operating lease right-of-use asset (before adoption of FASB Topic 842)1 —  —  8,872  7,693  6,884 
Add: Allowance for credit losses on accounts receivable 789  753  729  674  467 
Less: Deferred tax assets2 1,084  721  737  680  383 
After Adjustment
Adjusted total assets 319,321  275,941  241,656  204,982  174,465 

Based on: 10-K (filing date: 2021-02-03), 10-K (filing date: 2020-02-04), 10-K (filing date: 2019-02-05), 10-K (filing date: 2018-02-06), 10-K (filing date: 2017-02-03).

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

Alphabet Inc., adjusted current liabilities

US$ in millions

Microsoft Excel LibreOffice Calc
Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017 Dec 31, 2016
As Reported
Current liabilities 56,834  45,221  34,620  24,183  16,756 
Adjustments
Less: Deferred revenue, current 2,543  1,908  1,784  1,432  1,099 
After Adjustment
Adjusted current liabilities 54,291  43,313  32,836  22,751  15,657 

Based on: 10-K (filing date: 2021-02-03), 10-K (filing date: 2020-02-04), 10-K (filing date: 2019-02-05), 10-K (filing date: 2018-02-06), 10-K (filing date: 2017-02-03).


Adjustments to Total Liabilities

Alphabet Inc., adjusted total liabilities

US$ in millions

Microsoft Excel LibreOffice Calc
Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017 Dec 31, 2016
As Reported
Total liabilities 97,072  74,467  55,164  44,793  28,461 
Adjustments
Add: Operating lease liability (before adoption of FASB Topic 842)1 —  —  8,872  7,693  6,884 
Less: Deferred tax liabilities2 3,561  1,701  1,264  430  226 
Less: Deferred revenue 3,024  2,266  2,180  1,772  1,301 
After Adjustment
Adjusted total liabilities 90,487  70,500  60,592  50,284  33,818 

Based on: 10-K (filing date: 2021-02-03), 10-K (filing date: 2020-02-04), 10-K (filing date: 2019-02-05), 10-K (filing date: 2018-02-06), 10-K (filing date: 2017-02-03).

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

2 Deferred tax liabilities. See details »


Adjustments to Stockholders’ Equity

Alphabet Inc., adjusted stockholders’ equity

US$ in millions

Microsoft Excel LibreOffice Calc
Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017 Dec 31, 2016
As Reported
Stockholders’ equity 222,544  201,442  177,628  152,502  139,036 
Adjustments
Less: Net deferred tax assets (liabilities)1 (2,477) (980) (527) 250  157 
Add: Allowance for credit losses on accounts receivable 789  753  729  674  467 
Add: Deferred revenue 3,024  2,266  2,180  1,772  1,301 
After Adjustment
Adjusted stockholders’ equity 228,834  205,441  181,064  154,698  140,647 

Based on: 10-K (filing date: 2021-02-03), 10-K (filing date: 2020-02-04), 10-K (filing date: 2019-02-05), 10-K (filing date: 2018-02-06), 10-K (filing date: 2017-02-03).

1 Net deferred tax assets (liabilities). See details »


Adjustments to Capitalization Table

Alphabet Inc., adjusted capitalization table

US$ in millions

Microsoft Excel LibreOffice Calc
Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017 Dec 31, 2016
As Reported
Current portion of Notes 999  —  —  —  — 
Current portion future finance lease payments, net 101  115  —  —  — 
Long-term debt, excluding current portion 13,932  4,554  4,012  3,969  3,935 
Total reported debt 15,032  4,669  4,012  3,969  3,935 
Stockholders’ equity 222,544  201,442  177,628  152,502  139,036 
Total reported capital 237,576  206,111  181,640  156,471  142,971 
Adjustments to Debt
Add: Operating lease liability (before adoption of FASB Topic 842)1 —  —  8,872  7,693  6,884 
Add: Current operating lease liabilities2 1,694  1,199  —  —  — 
Add: Long-term operating lease liabilities3 11,146  10,214  —  —  — 
Adjusted total debt 27,872  16,082  12,884  11,662  10,819 
Adjustments to Equity
Less: Net deferred tax assets (liabilities)4 (2,477) (980) (527) 250  157 
Add: Allowance for credit losses on accounts receivable 789  753  729  674  467 
Add: Deferred revenue 3,024  2,266  2,180  1,772  1,301 
Adjusted stockholders’ equity 228,834  205,441  181,064  154,698  140,647 
After Adjustment
Adjusted total capital 256,706  221,523  193,948  166,360  151,466 

Based on: 10-K (filing date: 2021-02-03), 10-K (filing date: 2020-02-04), 10-K (filing date: 2019-02-05), 10-K (filing date: 2018-02-06), 10-K (filing date: 2017-02-03).

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

2 Current operating lease liabilities. See details »

3 Long-term operating lease liabilities. See details »

4 Net deferred tax assets (liabilities). See details »


Adjustments to Revenues

Alphabet Inc., adjusted revenues

US$ in millions

Microsoft Excel LibreOffice Calc
12 months ended: Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017 Dec 31, 2016
As Reported
Revenues 182,527  161,857  136,819  110,855  90,272 
Adjustment
Add: Increase (decrease) in deferred revenue 758  86  408  471  362 
After Adjustment
Adjusted revenues 183,285  161,943  137,227  111,326  90,634 

Based on: 10-K (filing date: 2021-02-03), 10-K (filing date: 2020-02-04), 10-K (filing date: 2019-02-05), 10-K (filing date: 2018-02-06), 10-K (filing date: 2017-02-03).


Adjustments to Reported Income

Alphabet Inc., adjusted net income

US$ in millions

Microsoft Excel LibreOffice Calc
12 months ended: Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017 Dec 31, 2016
As Reported
Net income 40,269  34,343  30,736  12,662  19,478 
Adjustments
Add: Deferred income tax expense (benefit)1 1,337  145  773  177  (120)
Add: Increase (decrease) in allowance for credit losses on accounts receivable 514  24  55  207  171 
Add: Increase (decrease) in deferred revenue 758  86  408  471  362 
Add: Other comprehensive income (loss) 1,865  1,104  (1,216) 1,410  (528)
After Adjustment
Adjusted net income 44,743  35,702  30,756  14,927  19,363 

Based on: 10-K (filing date: 2021-02-03), 10-K (filing date: 2020-02-04), 10-K (filing date: 2019-02-05), 10-K (filing date: 2018-02-06), 10-K (filing date: 2017-02-03).

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