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
Feb 2, 2025 Jan 28, 2024 Jan 29, 2023 Jan 30, 2022 Jan 31, 2021 Feb 2, 2020
As Reported
Total assets 96,119 76,530 76,445 71,876 70,581 51,236
Adjustments
Add: Operating lease right-of-use asset (before adoption of FASB Topic 842)1
Less: Deferred tax assets (included in Other assets)2 269 313 319 344 305 139
After Adjustment
Adjusted total assets 95,850 76,217 76,126 71,532 70,276 51,097

Based on: 10-K (reporting date: 2025-02-02), 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).

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
Feb 2, 2025 Jan 28, 2024 Jan 29, 2023 Jan 30, 2022 Jan 31, 2021 Feb 2, 2020
As Reported
Current liabilities 28,661 22,015 23,110 28,693 23,166 18,375
Adjustments
Less: Current deferred revenue 2,610 2,762 3,064 3,596 2,823 2,116
After Adjustment
Adjusted current liabilities 26,051 19,253 20,046 25,097 20,343 16,259

Based on: 10-K (reporting date: 2025-02-02), 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).


Adjustments to Total Liabilities

Home Depot Inc., adjusted total liabilities

US$ in millions

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

Based on: 10-K (reporting date: 2025-02-02), 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).

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
Feb 2, 2025 Jan 28, 2024 Jan 29, 2023 Jan 30, 2022 Jan 31, 2021 Feb 2, 2020
As Reported
Stockholders’ equity (deficit) 6,640 1,044 1,562 (1,696) 3,299 (3,116)
Adjustments
Less: Net deferred tax assets (liabilities)1 (1,693) (550) (700) (565) (826) (567)
Add: Deferred revenue 2,610 2,762 3,064 3,596 2,823 2,116
After Adjustment
Adjusted stockholders’ equity (deficit) 10,943 4,356 5,326 2,465 6,948 (433)

Based on: 10-K (reporting date: 2025-02-02), 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).

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


Adjustments to Capitalization Table

Home Depot Inc., adjusted capitalization table

US$ in millions

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

Based on: 10-K (reporting date: 2025-02-02), 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).

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

Based on: 10-K (reporting date: 2025-02-02), 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).


Adjustments to Reported Income

Home Depot Inc., adjusted net earnings

US$ in millions

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

Based on: 10-K (reporting date: 2025-02-02), 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).

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