Paying users zone. Data is hidden behind hidden.

  • Get 1-month access to Home Depot Inc. for $19.99, or

  • get full access to the entire website for at least 3 months from $49.99.


We accept:

Visa Mastercard American Express Maestro Discover JCB PayPal Apple Pay Google Pay
Verified by Visa MasterCard SecureCode American Express SafeKey

This is a one-time payment. There is no automatic renewal.

Microsoft Excel LibreOffice Calc

Home Depot Inc. (HD)


Adjustments to Financial Statements

High level of difficulty


Adjustments to Current Assets

Home Depot Inc., adjusted current assets

US$ in millions

Microsoft Excel LibreOffice Calc
Feb 3, 2019 Jan 28, 2018 Jan 29, 2017 Jan 31, 2016 Feb 1, 2015 Feb 2, 2014
As Reported
Current assets hidden hidden hidden hidden hidden hidden
Adjustments
Less: Current deferred tax assets (included in Other current assets)1 hidden hidden hidden hidden hidden hidden
After Adjustment
Adjusted current assets hidden hidden hidden hidden hidden hidden

Based on: 10-K (filing date: 2019-03-28), 10-K (filing date: 2018-03-22), 10-K (filing date: 2017-03-23), 10-K (filing date: 2016-03-24), 10-K (filing date: 2015-03-26), 10-K (filing date: 2014-03-27).

1 Current deferred tax assets (included in Other current assets). See Details »


Adjustments to Total Assets

Home Depot Inc., adjusted total assets

US$ in millions

Microsoft Excel LibreOffice Calc
Feb 3, 2019 Jan 28, 2018 Jan 29, 2017 Jan 31, 2016 Feb 1, 2015 Feb 2, 2014
As Reported
Total assets hidden hidden hidden hidden hidden hidden
Adjustments
Add: Operating lease right-of-use asset (before adoption of FASB Topic 842)1 hidden hidden hidden hidden hidden hidden
Less: Current deferred tax assets (included in Other current assets)2 hidden hidden hidden hidden hidden hidden
Less: Noncurrent deferred tax assets (included in Other assets)3 hidden hidden hidden hidden hidden hidden
After Adjustment
Adjusted total assets hidden hidden hidden hidden hidden hidden

Based on: 10-K (filing date: 2019-03-28), 10-K (filing date: 2018-03-22), 10-K (filing date: 2017-03-23), 10-K (filing date: 2016-03-24), 10-K (filing date: 2015-03-26), 10-K (filing date: 2014-03-27).

1 Operating lease right-of-use asset (before adoption of FASB Topic 842). See Details »

2 Current deferred tax assets (included in Other current assets). See Details »

3 Noncurrent deferred tax assets (included in Other assets). See Details »


Adjustments to Current Liabilities

Home Depot Inc., adjusted current liabilities

US$ in millions

Microsoft Excel LibreOffice Calc
Feb 3, 2019 Jan 28, 2018 Jan 29, 2017 Jan 31, 2016 Feb 1, 2015 Feb 2, 2014
As Reported
Current liabilities hidden hidden hidden hidden hidden hidden
Adjustments
Less: Current deferred tax liabilities (included in Other accrued expenses)1 hidden hidden hidden hidden hidden hidden
Less: Current deferred revenue hidden hidden hidden hidden hidden hidden
After Adjustment
Adjusted current liabilities hidden hidden hidden hidden hidden hidden

Based on: 10-K (filing date: 2019-03-28), 10-K (filing date: 2018-03-22), 10-K (filing date: 2017-03-23), 10-K (filing date: 2016-03-24), 10-K (filing date: 2015-03-26), 10-K (filing date: 2014-03-27).

1 Current deferred tax liabilities (included in Other accrued expenses). See Details »


Adjustments to Total Liabilities

Home Depot Inc., adjusted total liabilities

US$ in millions

Microsoft Excel LibreOffice Calc
Feb 3, 2019 Jan 28, 2018 Jan 29, 2017 Jan 31, 2016 Feb 1, 2015 Feb 2, 2014
As Reported
Total liabilities hidden hidden hidden hidden hidden hidden
Adjustments
Add: Operating lease liability (before adoption of FASB Topic 842)1 hidden hidden hidden hidden hidden hidden
Less: Current deferred tax liabilities (included in Other accrued expenses)2 hidden hidden hidden hidden hidden hidden
Less: Noncurrent deferred tax liabilities3 hidden hidden hidden hidden hidden hidden
Less: Deferred revenue hidden hidden hidden hidden hidden hidden
After Adjustment
Adjusted total liabilities hidden hidden hidden hidden hidden hidden

Based on: 10-K (filing date: 2019-03-28), 10-K (filing date: 2018-03-22), 10-K (filing date: 2017-03-23), 10-K (filing date: 2016-03-24), 10-K (filing date: 2015-03-26), 10-K (filing date: 2014-03-27).

1 Operating lease liability (before adoption of FASB Topic 842). See Details »

2 Current deferred tax liabilities (included in Other accrued expenses). See Details »

3 Noncurrent deferred tax liabilities. See Details »


Adjustments to Stockholders’ Equity

Home Depot Inc., adjusted stockholders’ equity (deficit)

US$ in millions

Microsoft Excel LibreOffice Calc
Feb 3, 2019 Jan 28, 2018 Jan 29, 2017 Jan 31, 2016 Feb 1, 2015 Feb 2, 2014
As Reported
Stockholders’ equity (deficit) hidden hidden hidden hidden hidden hidden
Adjustments
Less: Net deferred tax assets (liabilities)1 hidden hidden hidden hidden hidden hidden
Add: Deferred revenue hidden hidden hidden hidden hidden hidden
After Adjustment
Adjusted stockholders’ equity (deficit) hidden hidden hidden hidden hidden hidden

Based on: 10-K (filing date: 2019-03-28), 10-K (filing date: 2018-03-22), 10-K (filing date: 2017-03-23), 10-K (filing date: 2016-03-24), 10-K (filing date: 2015-03-26), 10-K (filing date: 2014-03-27).

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


Adjustments to Capitalization Table

Home Depot Inc., adjusted capitalization table

US$ in millions

Microsoft Excel LibreOffice Calc
Feb 3, 2019 Jan 28, 2018 Jan 29, 2017 Jan 31, 2016 Feb 1, 2015 Feb 2, 2014
As Reported
Short-term debt hidden hidden hidden hidden hidden hidden
Current installments of long-term debt hidden hidden hidden hidden hidden hidden
Long-term debt, excluding current installments hidden hidden hidden hidden hidden hidden
Total reported debt hidden hidden hidden hidden hidden hidden
Stockholders’ equity (deficit) hidden hidden hidden hidden hidden hidden
Total reported capital hidden hidden hidden hidden hidden hidden
Adjustments to Debt
Add: Operating lease liability (before adoption of FASB Topic 842)1 hidden hidden hidden hidden hidden hidden
Adjusted total debt hidden hidden hidden hidden hidden hidden
Adjustments to Equity
Less: Net deferred tax assets (liabilities)2 hidden hidden hidden hidden hidden hidden
Add: Deferred revenue hidden hidden hidden hidden hidden hidden
Adjusted stockholders’ equity (deficit) hidden hidden hidden hidden hidden hidden
After Adjustment
Adjusted total capital hidden hidden hidden hidden hidden hidden

Based on: 10-K (filing date: 2019-03-28), 10-K (filing date: 2018-03-22), 10-K (filing date: 2017-03-23), 10-K (filing date: 2016-03-24), 10-K (filing date: 2015-03-26), 10-K (filing date: 2014-03-27).

1 Operating lease liability (before adoption of FASB Topic 842). See Details »

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


Adjustments to Revenues

Home Depot Inc., adjusted net sales

US$ in millions

Microsoft Excel LibreOffice Calc
12 months ended Feb 3, 2019 Jan 28, 2018 Jan 29, 2017 Jan 31, 2016 Feb 1, 2015 Feb 2, 2014
As Reported
Net sales hidden hidden hidden hidden hidden hidden
Adjustments
Add: Increase (decrease) in deferred revenue hidden hidden hidden hidden hidden hidden
After Adjustment
Adjusted net sales hidden hidden hidden hidden hidden hidden

Based on: 10-K (filing date: 2019-03-28), 10-K (filing date: 2018-03-22), 10-K (filing date: 2017-03-23), 10-K (filing date: 2016-03-24), 10-K (filing date: 2015-03-26), 10-K (filing date: 2014-03-27).


Adjustments to Reported Income

Home Depot Inc., adjusted net earnings

US$ in millions

Microsoft Excel LibreOffice Calc
12 months ended Feb 3, 2019 Jan 28, 2018 Jan 29, 2017 Jan 31, 2016 Feb 1, 2015 Feb 2, 2014
As Reported
Net earnings hidden hidden hidden hidden hidden hidden
Adjustments
Add: Deferred income tax expense (benefit)1 hidden hidden hidden hidden hidden hidden
Add: Increase (decrease) in deferred revenue hidden hidden hidden hidden hidden hidden
Add: Other comprehensive income (loss) hidden hidden hidden hidden hidden hidden
After Adjustment
Adjusted net earnings hidden hidden hidden hidden hidden hidden

Based on: 10-K (filing date: 2019-03-28), 10-K (filing date: 2018-03-22), 10-K (filing date: 2017-03-23), 10-K (filing date: 2016-03-24), 10-K (filing date: 2015-03-26), 10-K (filing date: 2014-03-27).

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