Paying users zone. Data is covered by hidden.

  • Get to Alphabet Inc. for $19.99, or

  • get to whole website for at least 3 months from $49.99.

Microsoft Excel LibreOffice Calc


Adjustments to Financial Statements

Difficulty: Advanced


Adjustments to Current Assets

Alphabet Inc., adjusted current assets

USD $ in millions

Microsoft Excel LibreOffice Calc
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
As Reported
Current assets hidden hidden hidden hidden hidden
Adjustments
Add: Allowance for doubtful accounts and sales credits hidden hidden hidden hidden hidden
Less: Deferred tax assets, current1 hidden hidden hidden hidden hidden
After Adjustment
Adjusted current assets hidden hidden hidden hidden hidden

Source: Based on data from Alphabet Inc. Annual Reports

1 Deferred tax assets, current. See Details »


Adjustments to Total Assets

Alphabet Inc., adjusted total assets

USD $ in millions

Microsoft Excel LibreOffice Calc
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
As Reported
Total assets hidden hidden hidden hidden hidden
Adjustments
Add: Operating leased assets1 hidden hidden hidden hidden hidden
Add: Allowance for doubtful accounts and sales credits hidden hidden hidden hidden hidden
Less: Deferred tax assets, current2 hidden hidden hidden hidden hidden
Less: Deferred tax assets, non-current3 hidden hidden hidden hidden hidden
After Adjustment
Adjusted total assets hidden hidden hidden hidden hidden

Source: Based on data from Alphabet Inc. Annual Reports

1 Operating leased assets. See Details »

2 Deferred tax assets, current. See Details »

3 Deferred tax assets, non-current. See Details »


Adjustments to Current Liabilities

Alphabet Inc., adjusted current liabilities

USD $ in millions

Microsoft Excel LibreOffice Calc
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
As Reported
Current liabilities hidden hidden hidden hidden hidden
Adjustments
Less: Deferred revenue, current hidden hidden hidden hidden hidden
After Adjustment
Adjusted current liabilities hidden hidden hidden hidden hidden

Source: Based on data from Alphabet Inc. Annual Reports


Adjustments to Total Liabilities

Alphabet Inc., adjusted total liabilities

USD $ in millions

Microsoft Excel LibreOffice Calc
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
As Reported
Total liabilities hidden hidden hidden hidden hidden
Adjustments
Add: Operating lease obligations1 hidden hidden hidden hidden hidden
Less: Deferred tax liabilities, non-current2 hidden hidden hidden hidden hidden
Less: Deferred revenue hidden hidden hidden hidden hidden
Less: Restructuring accruals hidden hidden hidden hidden hidden
After Adjustment
Adjusted total liabilities hidden hidden hidden hidden hidden

Source: Based on data from Alphabet Inc. Annual Reports

1 Operating lease obligations. See Details »

2 Deferred tax liabilities, non-current. See Details »


Adjustments to Stockholders' Equity

Alphabet Inc., adjusted stockholders' equity

USD $ in millions

Microsoft Excel LibreOffice Calc
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
As Reported
Stockholders' equity hidden hidden hidden hidden hidden
Adjustments
Less: Net deferred tax assets (liabilities)1 hidden hidden hidden hidden hidden
Add: Allowance for doubtful accounts and sales credits hidden hidden hidden hidden hidden
Add: Deferred revenue hidden hidden hidden hidden hidden
Add: Restructuring accruals hidden hidden hidden hidden hidden
After Adjustment
Adjusted stockholders' equity hidden hidden hidden hidden hidden

Source: Based on data from Alphabet Inc. Annual Reports

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


Adjustments to Capitalization Table

Alphabet Inc., adjusted capitalization table

USD $ in millions

Microsoft Excel LibreOffice Calc
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
As Reported
Short-term debt hidden hidden hidden hidden hidden
Long-term debt, excluding short-term portion hidden hidden hidden hidden hidden
Total reported debt hidden hidden hidden hidden hidden
Stockholders' equity hidden hidden hidden hidden hidden
Total reported capital hidden hidden hidden hidden hidden
Adjustments to Debt
Add: Operating lease obligations1 hidden hidden hidden hidden hidden
Adjusted total debt hidden hidden hidden hidden hidden
Adjustments to Equity
Less: Net deferred tax assets (liabilities)2 hidden hidden hidden hidden hidden
Add: Allowance for doubtful accounts and sales credits hidden hidden hidden hidden hidden
Add: Deferred revenue hidden hidden hidden hidden hidden
Add: Restructuring accruals hidden hidden hidden hidden hidden
Adjusted stockholders' equity hidden hidden hidden hidden hidden
After Adjustment
Adjusted total capital hidden hidden hidden hidden hidden

Source: Based on data from Alphabet Inc. Annual Reports

1 Operating lease obligations. See Details »

2 Net deferred tax assets (liabilities). See Details »


Adjustments to Revenues

Alphabet Inc., adjusted revenues

USD $ in millions

Microsoft Excel LibreOffice Calc
12 months ended Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
As Reported
Revenues hidden hidden hidden hidden hidden
Adjustments
Add: Increase (decrease) in deferred revenue hidden hidden hidden hidden hidden
After Adjustment
Adjusted revenues hidden hidden hidden hidden hidden

Source: Based on data from Alphabet Inc. Annual Reports


Adjustments to Reported Income

Alphabet Inc., adjusted comprehensive income

USD $ in millions

Microsoft Excel LibreOffice Calc
12 months ended Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
As Reported
Net income hidden hidden hidden hidden hidden
Adjustments
Add: Deferred income tax expense (benefit)1 hidden hidden hidden hidden hidden
Add: Increase (decrease) in allowance for doubtful accounts and sales credits hidden hidden hidden hidden hidden
Add: Increase (decrease) in deferred revenue hidden hidden hidden hidden hidden
Add: Increase (decrease) in restructuring accruals hidden hidden hidden hidden hidden
Less: Net income from discontinued operations hidden hidden hidden hidden hidden
Add: Other comprehensive income (loss) hidden hidden hidden hidden hidden
After Adjustment
Adjusted comprehensive income hidden hidden hidden hidden hidden

Source: Based on data from Alphabet Inc. Annual Reports

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