Stock Analysis on Net

Alphabet Inc. (NASDAQ:GOOG)

Adjustments to Financial Statements

Microsoft Excel

Adjustments to Current Assets

Alphabet Inc., 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 171,530 164,795 188,143 174,296 152,578
Adjustments
Add: Allowance for credit losses on accounts receivable 771 754 550 789 753
After Adjustment
Adjusted current assets 172,301 165,549 188,693 175,085 153,331

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

Alphabet Inc., 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 402,392 365,264 359,268 319,616 275,909
Adjustments
Add: Operating lease right-of-use asset (before adoption of FASB Topic 842)1
Add: Allowance for credit losses on accounts receivable 771 754 550 789 753
Less: Deferred tax assets2 12,169 5,261 1,284 1,084 721
After Adjustment
Adjusted total assets 390,994 360,757 358,534 319,321 275,941

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

Alphabet Inc., 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 81,814 69,300 64,254 56,834 45,221
Adjustments
Less: Deferred revenue, current 4,137 3,908 3,288 2,543 1,908
After Adjustment
Adjusted current liabilities 77,677 65,392 60,966 54,291 43,313

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

Alphabet Inc., 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 119,013 109,120 107,633 97,072 74,467
Adjustments
Add: Operating lease liability (before adoption of FASB Topic 842)1
Less: Deferred tax liabilities2 485 514 5,257 3,561 1,701
Less: Deferred revenue 5,048 4,507 3,823 3,024 2,266
Less: Severance charges and related accruals 77
After Adjustment
Adjusted total liabilities 113,403 104,099 98,553 90,487 70,500

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

Alphabet Inc., adjusted stockholders’ equity

US$ in millions

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
As Reported
Stockholders’ equity 283,379 256,144 251,635 222,544 201,442
Adjustments
Less: Net deferred tax assets (liabilities)1 11,684 4,747 (3,973) (2,477) (980)
Add: Allowance for credit losses on accounts receivable 771 754 550 789 753
Add: Deferred revenue 5,048 4,507 3,823 3,024 2,266
Add: Severance charges and related accruals 77
After Adjustment
Adjusted stockholders’ equity 277,591 256,658 259,981 228,834 205,441

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 assets (liabilities). See details »


Adjustments to Capitalization Table

Alphabet Inc., 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 notes 1,000 999
Current portion of future finance lease payments, net and other current debt 363 298 113 101 115
Long-term debt, excluding current portion 13,253 14,701 14,817 13,932 4,554
Total reported debt 14,616 14,999 14,930 15,032 4,669
Stockholders’ equity 283,379 256,144 251,635 222,544 201,442
Total reported capital 297,995 271,143 266,565 237,576 206,111
Adjustments to Debt
Add: Operating lease liability (before adoption of FASB Topic 842)1
Add: Current operating lease liabilities2 2,791 2,477 2,189 1,694 1,199
Add: Long-term operating lease liabilities3 12,460 12,501 11,389 11,146 10,214
Adjusted total debt 29,867 29,977 28,508 27,872 16,082
Adjustments to Equity
Less: Net deferred tax assets (liabilities)4 11,684 4,747 (3,973) (2,477) (980)
Add: Allowance for credit losses on accounts receivable 771 754 550 789 753
Add: Deferred revenue 5,048 4,507 3,823 3,024 2,266
Add: Severance charges and related accruals 77
Adjusted stockholders’ equity 277,591 256,658 259,981 228,834 205,441
After Adjustment
Adjusted total capital 307,458 286,635 288,489 256,706 221,523

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. 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
12 months ended: Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
As Reported
Revenues 307,394 282,836 257,637 182,527 161,857
Adjustment
Add: Increase (decrease) in deferred revenue 541 684 799 758 86
After Adjustment
Adjusted revenues 307,935 283,520 258,436 183,285 161,943

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

Alphabet Inc., adjusted net income

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 73,795 59,972 76,033 40,269 34,343
Adjustments
Add: Deferred income tax expense (benefit)1 (7,729) (8,198) 1,883 1,337 145
Add: Increase (decrease) in allowance for credit losses on accounts receivable 17 204 (239) 514 24
Add: Increase (decrease) in deferred revenue 541 684 799 758 86
Add: Increase (decrease) in severance charges and related accruals 77
Add: Other comprehensive income (loss) 3,201 (5,980) (2,256) 1,865 1,104
After Adjustment
Adjusted net income 69,902 46,682 76,220 44,743 35,702

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 »