Paying users zone. Data is covered by hidden.

  • Get to Facebook 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

Facebook 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 allowance for unbilled receivables hidden hidden hidden hidden hidden
After Adjustment
Adjusted current assets hidden hidden hidden hidden hidden

Based on: 10-K (filing date: 2018-02-01), 10-K (filing date: 2017-02-03), 10-K (filing date: 2016-01-28), 10-K (filing date: 2015-01-29), 10-K (filing date: 2014-01-31).


Adjustments to Total Assets

Facebook 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 allowance for unbilled receivables hidden hidden hidden hidden hidden
Less: Noncurrent deferred tax assets, net2 hidden hidden hidden hidden hidden
After Adjustment
Adjusted total assets hidden hidden hidden hidden hidden

Based on: 10-K (filing date: 2018-02-01), 10-K (filing date: 2017-02-03), 10-K (filing date: 2016-01-28), 10-K (filing date: 2015-01-29), 10-K (filing date: 2014-01-31).

1 Operating leased assets. See Details »

2 Noncurrent deferred tax assets, net. See Details »


Adjustments to Current Liabilities

Facebook 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: Current deferred revenue hidden hidden hidden hidden hidden
After Adjustment
Adjusted current liabilities hidden hidden hidden hidden hidden

Based on: 10-K (filing date: 2018-02-01), 10-K (filing date: 2017-02-03), 10-K (filing date: 2016-01-28), 10-K (filing date: 2015-01-29), 10-K (filing date: 2014-01-31).


Adjustments to Total Liabilities

Facebook 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: Noncurrent deferred tax liabilities2 hidden hidden hidden hidden hidden
Less: Deferred revenue hidden hidden hidden hidden hidden
After Adjustment
Adjusted total liabilities hidden hidden hidden hidden hidden

Based on: 10-K (filing date: 2018-02-01), 10-K (filing date: 2017-02-03), 10-K (filing date: 2016-01-28), 10-K (filing date: 2015-01-29), 10-K (filing date: 2014-01-31).

1 Operating lease obligations. See Details »

2 Noncurrent deferred tax liabilities. See Details »


Adjustments to Stockholders' Equity

Facebook 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 allowance for unbilled receivables hidden hidden hidden hidden hidden
Add: Deferred revenue hidden hidden hidden hidden hidden
After Adjustment
Adjusted stockholders' equity hidden hidden hidden hidden hidden

Based on: 10-K (filing date: 2018-02-01), 10-K (filing date: 2017-02-03), 10-K (filing date: 2016-01-28), 10-K (filing date: 2015-01-29), 10-K (filing date: 2014-01-31).

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


Adjustments to Capitalization Table

Facebook 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
Current portion of capital lease obligations hidden hidden hidden hidden hidden
Capital lease obligations, less current 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 allowance for unbilled receivables hidden hidden hidden hidden hidden
Add: Deferred revenue hidden hidden hidden hidden hidden
Adjusted stockholders' equity hidden hidden hidden hidden hidden
After Adjustment
Adjusted total capital hidden hidden hidden hidden hidden

Based on: 10-K (filing date: 2018-02-01), 10-K (filing date: 2017-02-03), 10-K (filing date: 2016-01-28), 10-K (filing date: 2015-01-29), 10-K (filing date: 2014-01-31).

1 Operating lease obligations. See Details »

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


Adjustments to Revenues

Facebook Inc., adjusted revenue

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
Revenue hidden hidden hidden hidden hidden
Adjustments
Add: Increase (decrease) in deferred revenue hidden hidden hidden hidden hidden
After Adjustment
Adjusted revenue hidden hidden hidden hidden hidden

Based on: 10-K (filing date: 2018-02-01), 10-K (filing date: 2017-02-03), 10-K (filing date: 2016-01-28), 10-K (filing date: 2015-01-29), 10-K (filing date: 2014-01-31).


Adjustments to Reported Income

Facebook Inc., adjusted net 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 allowance for unbilled receivables hidden hidden hidden hidden hidden
Add: Increase (decrease) in deferred revenue hidden hidden hidden hidden hidden
Add: Other comprehensive income (loss) hidden hidden hidden hidden hidden
After Adjustment
Adjusted net income hidden hidden hidden hidden hidden

Based on: 10-K (filing date: 2018-02-01), 10-K (filing date: 2017-02-03), 10-K (filing date: 2016-01-28), 10-K (filing date: 2015-01-29), 10-K (filing date: 2014-01-31).

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