Microsoft Excel LibreOffice Calc

Adjustments to Financial Statements

Difficulty: Advanced


Adjustments to Current Assets

eBay 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 7,743  8,875  7,904  26,531  23,283 
Adjustments
Add: Allowance for doubtful accounts and authorized credits 102  81  84  102  106 
After Adjustment
Adjusted current assets 7,845  8,956  7,988  26,633  23,389 

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


Adjustments to Total Assets

eBay 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 25,981  23,847  17,785  45,132  41,488 
Adjustments
Add: Operating leased assets1 281  212  206  419  408 
Add: Allowance for doubtful accounts and authorized credits 102  81  84  102  106 
Less: Deferred tax assets2 5,195  4,608  –  –  – 
After Adjustment
Adjusted total assets 21,169  19,532  18,075  45,653  42,002 

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

1 Operating leased assets. See Details »

2 Deferred tax assets. See Details »


Adjustments to Current Liabilities

eBay 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 3,539  3,847  2,263  17,531  12,639 
Adjustments
Less: Current deferred revenue 117  110  106  188  158 
After Adjustment
Adjusted current liabilities 3,422  3,737  2,157  17,343  12,481 

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


Adjustments to Total Liabilities

eBay 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 17,918  13,308  11,209  25,226  17,841 
Adjustments
Add: Operating lease obligations1 281  212  206  419  408 
Less: Deferred revenue 117  110  106  188  158 
After Adjustment
Adjusted total liabilities 18,082  13,410  11,309  25,457  18,091 

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

1 Operating lease obligations. See Details »


Adjustments to Stockholders' Equity

eBay 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 8,063  10,539  6,576  19,906  23,647 
Adjustments
Less: Net deferred tax assets and liabilities1 1,769  3,155  (1,669) (3,188) (638)
Add: Allowance for doubtful accounts and authorized credits 102  81  84  102  106 
Add: Deferred revenue 117  110  106  188  158 
After Adjustment
Adjusted stockholders' equity 6,513  7,575  8,435  23,384  24,549 

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

1 Net deferred tax assets and liabilities. See Details »


Adjustments to Capitalization Table

eBay 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 781  1,451  –  850 
Long-term debt 9,234  7,509  6,779  6,777  4,117 
Total reported debt 10,015  8,960  6,779  7,627  4,123 
Stockholders' equity 8,063  10,539  6,576  19,906  23,647 
Total reported capital 18,078  19,499  13,355  27,533  27,770 
Adjustments to Debt
Add: Operating lease obligations1 281  212  206  419  408 
Adjusted total debt 10,296  9,172  6,985  8,046  4,531 
Adjustments to Equity
Less: Net deferred tax assets and liabilities2 1,769  3,155  (1,669) (3,188) (638)
Add: Allowance for doubtful accounts and authorized credits 102  81  84  102  106 
Add: Deferred revenue 117  110  106  188  158 
Adjusted stockholders' equity 6,513  7,575  8,435  23,384  24,549 
After Adjustment
Adjusted total capital 16,809  16,747  15,420  31,430  29,080 

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

1 Operating lease obligations. See Details »

2 Net deferred tax assets and liabilities. See Details »


Adjustments to Revenues

eBay Inc., adjusted net 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
Net revenues 9,567  8,979  8,592  17,902  16,047 
Adjustments
Add: Increase (decrease) in deferred revenue (2) 30  21 
After Adjustment
Adjusted net revenues 9,574  8,983  8,590  17,932  16,068 

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


Adjustments to Reported Income

eBay Inc., adjusted net income (loss)

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 (loss) (1,016) 7,266  1,725  46  2,856 
Adjustments
Add: Deferred income tax expense (benefit)1 1,729  (4,556) (32) 2,808  (31)
Add: Increase (decrease) in allowance for doubtful accounts and authorized credits 21  (3) (2) (4) 17 
Add: Increase (decrease) in deferred revenue (2) 30  21 
Less: Loss from discontinued operations, net of income taxes (4) (19) (222) –  – 
Add: Other comprehensive income (loss), net tax 841  (650) (633) 15  300 
After Adjustment
Adjusted net income (loss) 1,586  2,080  1,278  2,895  3,163 

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

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