Paying users zone. Data is covered by hidden.

  • Get to Ford Motor Co. for $13.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

Ford Motor Co., 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: Allowances for doubtful receivables hidden hidden hidden hidden hidden
Add: LIFO reserve1 hidden hidden hidden hidden hidden
After Adjustment
Adjusted current assets hidden hidden hidden hidden hidden

Based on: 10-K (filing date: 2018-02-08), 10-K (filing date: 2017-02-09), 10-K (filing date: 2016-02-11), 10-K (filing date: 2015-02-13), 10-K (filing date: 2014-02-18).

1 LIFO reserve. See Details »


Adjustments to Total Assets

Ford Motor Co., 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: Allowances for doubtful receivables hidden hidden hidden hidden hidden
Add: LIFO reserve2 hidden hidden hidden hidden hidden
Less: Non-current deferred tax assets3 hidden hidden hidden hidden hidden
After Adjustment
Adjusted total assets hidden hidden hidden hidden hidden

Based on: 10-K (filing date: 2018-02-08), 10-K (filing date: 2017-02-09), 10-K (filing date: 2016-02-11), 10-K (filing date: 2015-02-13), 10-K (filing date: 2014-02-18).

1 Operating leased assets. See Details »

2 LIFO reserve. See Details »

3 Non-current deferred tax assets. See Details »


Adjustments to Current Liabilities

Ford Motor Co., 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-08), 10-K (filing date: 2017-02-09), 10-K (filing date: 2016-02-11), 10-K (filing date: 2015-02-13), 10-K (filing date: 2014-02-18).


Adjustments to Total Liabilities

Ford Motor Co., 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: Non-current deferred tax liabilities2 hidden hidden hidden hidden hidden
Less: Deferred revenue hidden hidden hidden hidden hidden
Less: Accrual related to warranty costs and field service actions hidden hidden hidden hidden hidden
After Adjustment
Adjusted total liabilities hidden hidden hidden hidden hidden

Based on: 10-K (filing date: 2018-02-08), 10-K (filing date: 2017-02-09), 10-K (filing date: 2016-02-11), 10-K (filing date: 2015-02-13), 10-K (filing date: 2014-02-18).

1 Operating lease obligations. See Details »

2 Non-current deferred tax liabilities. See Details »


Adjustments to Stockholders' Equity

Ford Motor Co., adjusted total 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
Equity attributable to Ford Motor Company hidden hidden hidden hidden hidden
Adjustments
Less: Net deferred tax assets (liabilities)1 hidden hidden hidden hidden hidden
Add: Allowances for doubtful receivables hidden hidden hidden hidden hidden
Add: LIFO reserve2 hidden hidden hidden hidden hidden
Add: Deferred revenue hidden hidden hidden hidden hidden
Add: Accrual related to warranty costs and field service actions hidden hidden hidden hidden hidden
Add: Redeemable noncontrolling interest hidden hidden hidden hidden hidden
Add: Equity attributable to noncontrolling interests hidden hidden hidden hidden hidden
After Adjustment
Adjusted total equity hidden hidden hidden hidden hidden

Based on: 10-K (filing date: 2018-02-08), 10-K (filing date: 2017-02-09), 10-K (filing date: 2016-02-11), 10-K (filing date: 2015-02-13), 10-K (filing date: 2014-02-18).

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

2 LIFO reserve. See Details »


Adjustments to Capitalization Table

Ford Motor Co., 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
Automotive debt payable within one year hidden hidden hidden hidden hidden
Financial Services debt payable within one year hidden hidden hidden hidden hidden
Automotive long-term debt payable after one year hidden hidden hidden hidden hidden
Financial Services long-term debt payable after one year hidden hidden hidden hidden hidden
Total reported debt hidden hidden hidden hidden hidden
Equity attributable to Ford Motor Company 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: Allowances for doubtful receivables hidden hidden hidden hidden hidden
Add: LIFO reserve3 hidden hidden hidden hidden hidden
Add: Deferred revenue hidden hidden hidden hidden hidden
Add: Accrual related to warranty costs and field service actions hidden hidden hidden hidden hidden
Add: Redeemable noncontrolling interest hidden hidden hidden hidden hidden
Add: Equity attributable to noncontrolling interests hidden hidden hidden hidden hidden
Adjusted total equity hidden hidden hidden hidden hidden
After Adjustment
Adjusted total capital hidden hidden hidden hidden hidden

Based on: 10-K (filing date: 2018-02-08), 10-K (filing date: 2017-02-09), 10-K (filing date: 2016-02-11), 10-K (filing date: 2015-02-13), 10-K (filing date: 2014-02-18).

1 Operating lease obligations. See Details »

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

3 LIFO reserve. See Details »


Adjustments to Revenues

Ford Motor Co., adjusted automotive sales

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

Based on: 10-K (filing date: 2018-02-08), 10-K (filing date: 2017-02-09), 10-K (filing date: 2016-02-11), 10-K (filing date: 2015-02-13), 10-K (filing date: 2014-02-18).


Adjustments to Reported Income

Ford Motor Co., 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 attributable to Ford Motor Company hidden hidden hidden hidden hidden
Adjustments
Add: Deferred income tax expense (benefit)1 hidden hidden hidden hidden hidden
Add: Increase (decrease) in allowances for doubtful receivables hidden hidden hidden hidden hidden
Add: Increase (decrease) in LIFO reserve2 hidden hidden hidden hidden hidden
Add: Increase (decrease) in deferred revenue hidden hidden hidden hidden hidden
Add: Increase (decrease) in accrual related to warranty costs and field service actions hidden hidden hidden hidden hidden
Add: Other comprehensive income (loss), net of tax hidden hidden hidden hidden hidden
Add: Comprehensive income (loss), net of tax, attributable to noncontrolling interest hidden hidden hidden hidden hidden
After Adjustment
Adjusted comprehensive income hidden hidden hidden hidden hidden

Based on: 10-K (filing date: 2018-02-08), 10-K (filing date: 2017-02-09), 10-K (filing date: 2016-02-11), 10-K (filing date: 2015-02-13), 10-K (filing date: 2014-02-18).

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

2 Increase (decrease) in LIFO reserve. See Details »