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
Unlock

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

Microsoft Excel LibreOffice Calc

Home Depot Inc. (NYSE:HD)

Adjustments to Financial Statements

Advanced level

Adjustments to Current Assets

Home Depot Inc., adjusted current assets

US$ in millions

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

Based on: 10-K (filing date: 2020-03-25), 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).

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 2, 2020 Feb 3, 2019 Jan 28, 2018 Jan 29, 2017 Jan 31, 2016 Feb 1, 2015
As Reported
Total assets
Adjustments
Add: Operating lease right-of-use asset (before adoption of FASB Topic 842)1
Less: Current deferred tax assets (included in Other current assets)2
Less: Noncurrent deferred tax assets (included in Other assets)3
After Adjustment
Adjusted total assets

Based on: 10-K (filing date: 2020-03-25), 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).

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 2, 2020 Feb 3, 2019 Jan 28, 2018 Jan 29, 2017 Jan 31, 2016 Feb 1, 2015
As Reported
Current liabilities
Adjustments
Less: Current deferred tax liabilities (included in Other accrued expenses)1
Less: Current deferred revenue
After Adjustment
Adjusted current liabilities

Based on: 10-K (filing date: 2020-03-25), 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).

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 2, 2020 Feb 3, 2019 Jan 28, 2018 Jan 29, 2017 Jan 31, 2016 Feb 1, 2015
As Reported
Total liabilities
Adjustments
Add: Operating lease liability (before adoption of FASB Topic 842)1
Less: Current deferred tax liabilities (included in Other accrued expenses)2
Less: Noncurrent deferred tax liabilities3
Less: Deferred revenue
After Adjustment
Adjusted total liabilities

Based on: 10-K (filing date: 2020-03-25), 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).

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 2, 2020 Feb 3, 2019 Jan 28, 2018 Jan 29, 2017 Jan 31, 2016 Feb 1, 2015
As Reported
Stockholders’ equity (deficit)
Adjustments
Less: Net deferred tax assets (liabilities)1
Add: Deferred revenue
After Adjustment
Adjusted stockholders’ equity (deficit)

Based on: 10-K (filing date: 2020-03-25), 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).

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 2, 2020 Feb 3, 2019 Jan 28, 2018 Jan 29, 2017 Jan 31, 2016 Feb 1, 2015
As Reported
Short-term debt
Current installments of long-term debt
Long-term debt, excluding current installments
Total reported debt
Stockholders’ equity (deficit)
Total reported capital
Adjustments to Debt
Add: Operating lease liability (before adoption of FASB Topic 842)1
Add: Current operating lease liabilities2
Add: Long-term operating lease liabilities3
Adjusted total debt
Adjustments to Equity
Less: Net deferred tax assets (liabilities)4
Add: Deferred revenue
Adjusted stockholders’ equity (deficit)
After Adjustment
Adjusted total capital

Based on: 10-K (filing date: 2020-03-25), 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).

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

2 Current operating lease liabilities. See details »

3 Long-term operating lease liabilities. See details »

4 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 2, 2020 Feb 3, 2019 Jan 28, 2018 Jan 29, 2017 Jan 31, 2016 Feb 1, 2015
As Reported
Net sales
Adjustment
Add: Increase (decrease) in deferred revenue
After Adjustment
Adjusted net sales

Based on: 10-K (filing date: 2020-03-25), 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).

Adjustments to Reported Income

Home Depot Inc., adjusted net earnings

US$ in millions

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

Based on: 10-K (filing date: 2020-03-25), 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).

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