Stock Analysis on Net

Home Depot Inc. (NYSE:HD)

Adjustments to Financial Statements

Microsoft Excel

Adjustments to Total Assets

Home Depot Inc., adjusted total assets

US$ in millions

Microsoft Excel
Jan 28, 2024 Jan 29, 2023 Jan 30, 2022 Jan 31, 2021 Feb 2, 2020 Feb 3, 2019
As Reported
Total assets 76,530 76,445 71,876 70,581 51,236 44,003
Adjustments
Add: Operating lease right-of-use asset (before adoption of FASB Topic 842)1 4,750
Less: Deferred tax assets (included in Other assets)2 313 319 344 305 139 121
After Adjustment
Adjusted total assets 76,217 76,126 71,532 70,276 51,097 48,632

Based on: 10-K (reporting date: 2024-01-28), 10-K (reporting date: 2023-01-29), 10-K (reporting date: 2022-01-30), 10-K (reporting date: 2021-01-31), 10-K (reporting date: 2020-02-02), 10-K (reporting date: 2019-02-03).

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

2 Deferred tax assets (included in Other assets). See details »


Adjustments to Current Liabilities

Home Depot Inc., adjusted current liabilities

US$ in millions

Microsoft Excel
Jan 28, 2024 Jan 29, 2023 Jan 30, 2022 Jan 31, 2021 Feb 2, 2020 Feb 3, 2019
As Reported
Current liabilities 22,015 23,110 28,693 23,166 18,375 16,716
Adjustments
Less: Current deferred revenue 2,762 3,064 3,596 2,823 2,116 1,782
After Adjustment
Adjusted current liabilities 19,253 20,046 25,097 20,343 16,259 14,934

Based on: 10-K (reporting date: 2024-01-28), 10-K (reporting date: 2023-01-29), 10-K (reporting date: 2022-01-30), 10-K (reporting date: 2021-01-31), 10-K (reporting date: 2020-02-02), 10-K (reporting date: 2019-02-03).


Adjustments to Total Liabilities

Home Depot Inc., adjusted total liabilities

US$ in millions

Microsoft Excel
Jan 28, 2024 Jan 29, 2023 Jan 30, 2022 Jan 31, 2021 Feb 2, 2020 Feb 3, 2019
As Reported
Total liabilities 75,486 74,883 73,572 67,282 54,352 45,881
Adjustments
Add: Operating lease liability (before adoption of FASB Topic 842)1 4,750
Less: Deferred tax liabilities2 863 1,019 909 1,131 706 491
Less: Deferred revenue 2,762 3,064 3,596 2,823 2,116 1,782
After Adjustment
Adjusted total liabilities 71,861 70,800 69,067 63,328 51,530 48,358

Based on: 10-K (reporting date: 2024-01-28), 10-K (reporting date: 2023-01-29), 10-K (reporting date: 2022-01-30), 10-K (reporting date: 2021-01-31), 10-K (reporting date: 2020-02-02), 10-K (reporting date: 2019-02-03).

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

2 Deferred tax liabilities. See details »


Adjustments to Stockholders’ Equity

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

US$ in millions

Microsoft Excel
Jan 28, 2024 Jan 29, 2023 Jan 30, 2022 Jan 31, 2021 Feb 2, 2020 Feb 3, 2019
As Reported
Stockholders’ equity (deficit) 1,044 1,562 (1,696) 3,299 (3,116) (1,878)
Adjustments
Less: Net deferred tax assets (liabilities)1 (550) (700) (565) (826) (567) (370)
Add: Deferred revenue 2,762 3,064 3,596 2,823 2,116 1,782
After Adjustment
Adjusted stockholders’ equity (deficit) 4,356 5,326 2,465 6,948 (433) 274

Based on: 10-K (reporting date: 2024-01-28), 10-K (reporting date: 2023-01-29), 10-K (reporting date: 2022-01-30), 10-K (reporting date: 2021-01-31), 10-K (reporting date: 2020-02-02), 10-K (reporting date: 2019-02-03).

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


Adjustments to Capitalization Table

Home Depot Inc., adjusted capitalization table

US$ in millions

Microsoft Excel
Jan 28, 2024 Jan 29, 2023 Jan 30, 2022 Jan 31, 2021 Feb 2, 2020 Feb 3, 2019
As Reported
Short-term debt 1,035 974 1,339
Current installments of long-term debt 1,368 1,231 2,447 1,416 1,839 1,056
Long-term debt, excluding current installments 42,743 41,962 36,604 35,822 28,670 26,807
Total reported debt 44,111 43,193 40,086 37,238 31,483 29,202
Stockholders’ equity (deficit) 1,044 1,562 (1,696) 3,299 (3,116) (1,878)
Total reported capital 45,155 44,755 38,390 40,537 28,367 27,324
Adjustments to Debt
Add: Operating lease liability (before adoption of FASB Topic 842)1 4,750
Add: Current operating lease liabilities2 1,050 945 830 828 828
Add: Long-term operating lease liabilities3 7,082 6,226 5,353 5,356 5,066
Adjusted total debt 52,243 50,364 46,269 43,422 37,377 33,952
Adjustments to Equity
Less: Net deferred tax assets (liabilities)4 (550) (700) (565) (826) (567) (370)
Add: Deferred revenue 2,762 3,064 3,596 2,823 2,116 1,782
Adjusted stockholders’ equity (deficit) 4,356 5,326 2,465 6,948 (433) 274
After Adjustment
Adjusted total capital 56,599 55,690 48,734 50,370 36,944 34,226

Based on: 10-K (reporting date: 2024-01-28), 10-K (reporting date: 2023-01-29), 10-K (reporting date: 2022-01-30), 10-K (reporting date: 2021-01-31), 10-K (reporting date: 2020-02-02), 10-K (reporting date: 2019-02-03).

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
12 months ended: Jan 28, 2024 Jan 29, 2023 Jan 30, 2022 Jan 31, 2021 Feb 2, 2020 Feb 3, 2019
As Reported
Net sales 152,669 157,403 151,157 132,110 110,225 108,203
Adjustment
Add: Increase (decrease) in deferred revenue (302) (532) 773 707 334 (23)
After Adjustment
Adjusted net sales 152,367 156,871 151,930 132,817 110,559 108,180

Based on: 10-K (reporting date: 2024-01-28), 10-K (reporting date: 2023-01-29), 10-K (reporting date: 2022-01-30), 10-K (reporting date: 2021-01-31), 10-K (reporting date: 2020-02-02), 10-K (reporting date: 2019-02-03).


Adjustments to Reported Income

Home Depot Inc., adjusted net earnings

US$ in millions

Microsoft Excel
12 months ended: Jan 28, 2024 Jan 29, 2023 Jan 30, 2022 Jan 31, 2021 Feb 2, 2020 Feb 3, 2019
As Reported
Net earnings 15,143 17,105 16,433 12,866 11,242 11,121
Adjustments
Add: Deferred income tax expense (benefit)1 (230) 138 (254) (607) 191 24
Add: Increase (decrease) in deferred revenue (302) (532) 773 707 334 (23)
Add: Other comprehensive income (loss), net of tax 241 (14) (33) 68 64 (206)
After Adjustment
Adjusted net earnings 14,852 16,697 16,919 13,034 11,831 10,916

Based on: 10-K (reporting date: 2024-01-28), 10-K (reporting date: 2023-01-29), 10-K (reporting date: 2022-01-30), 10-K (reporting date: 2021-01-31), 10-K (reporting date: 2020-02-02), 10-K (reporting date: 2019-02-03).

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