Stock Analysis on Net

Home Depot Inc. (NYSE:HD)

Analysis of Solvency Ratios
Quarterly Data

Microsoft Excel

Solvency Ratios (Summary)

Home Depot Inc., solvency ratios (quarterly data)

Microsoft Excel
Jan 28, 2024 Oct 29, 2023 Jul 30, 2023 Apr 30, 2023 Jan 29, 2023 Oct 30, 2022 Jul 31, 2022 May 1, 2022 Jan 30, 2022 Oct 31, 2021 Aug 1, 2021 May 2, 2021 Jan 31, 2021 Nov 1, 2020 Aug 2, 2020 May 3, 2020 Feb 2, 2020 Nov 3, 2019 Aug 4, 2019 May 5, 2019 Feb 3, 2019 Oct 28, 2018 Jul 29, 2018 Apr 29, 2018
Debt Ratios
Debt to equity 42.25 29.32 31.54 116.72 27.65 33.10 173.11 37.82 17.48 20.52 11.29 23.01 19.53 12.69 15.29
Debt to equity (including operating lease liability) 50.04 34.44 37.07 136.54 32.24 38.30 199.91 43.73 20.47 23.99 13.16 26.74 19.53 12.69 15.29
Debt to capital 0.98 0.97 0.97 0.99 0.97 0.97 0.99 1.04 1.04 0.97 0.95 0.95 0.92 0.96 1.01 1.11 1.11 1.04 1.04 1.08 1.07 0.95 0.93 0.94
Debt to capital (including operating lease liability) 0.98 0.97 0.97 0.99 0.97 0.97 1.00 1.04 1.04 0.98 0.95 0.96 0.93 0.96 1.01 1.09 1.09 1.03 1.03 1.07 1.07 0.95 0.93 0.94
Debt to assets 0.58 0.55 0.55 0.55 0.57 0.56 0.54 0.54 0.56 0.54 0.51 0.49 0.53 0.53 0.55 0.61 0.61 0.56 0.55 0.55 0.66 0.57 0.55 0.55
Debt to assets (including operating lease liability) 0.68 0.65 0.65 0.65 0.66 0.65 0.62 0.62 0.64 0.62 0.60 0.58 0.62 0.61 0.64 0.71 0.73 0.67 0.66 0.66 0.66 0.57 0.55 0.55
Financial leverage 73.30 52.85 57.22 211.01 48.94 59.22 319.94 70.56 34.20 41.51 21.39 43.60 34.24 23.01 27.65
Coverage Ratios
Interest coverage 11.25 11.94 12.82 13.81 14.90 16.02 16.58 16.83 17.14 16.63 15.94 15.29 13.60 13.38 13.08 12.61 13.25 13.68 14.26 14.67 14.85

Based on: 10-K (reporting date: 2024-01-28), 10-Q (reporting date: 2023-10-29), 10-Q (reporting date: 2023-07-30), 10-Q (reporting date: 2023-04-30), 10-K (reporting date: 2023-01-29), 10-Q (reporting date: 2022-10-30), 10-Q (reporting date: 2022-07-31), 10-Q (reporting date: 2022-05-01), 10-K (reporting date: 2022-01-30), 10-Q (reporting date: 2021-10-31), 10-Q (reporting date: 2021-08-01), 10-Q (reporting date: 2021-05-02), 10-K (reporting date: 2021-01-31), 10-Q (reporting date: 2020-11-01), 10-Q (reporting date: 2020-08-02), 10-Q (reporting date: 2020-05-03), 10-K (reporting date: 2020-02-02), 10-Q (reporting date: 2019-11-03), 10-Q (reporting date: 2019-08-04), 10-Q (reporting date: 2019-05-05), 10-K (reporting date: 2019-02-03), 10-Q (reporting date: 2018-10-28), 10-Q (reporting date: 2018-07-29), 10-Q (reporting date: 2018-04-29).

Solvency ratio Description The company
Debt to equity ratio A solvency ratio calculated as total debt divided by total shareholders’ equity. Home Depot Inc. debt to equity ratio improved from Q2 2024 to Q3 2024 but then deteriorated significantly from Q3 2024 to Q4 2024.
Debt to equity (including operating lease liability) ratio A solvency ratio calculated as total debt (including operating lease liability) divided by total shareholders’ equity. Home Depot Inc. debt to equity ratio (including operating lease liability) improved from Q2 2024 to Q3 2024 but then deteriorated significantly from Q3 2024 to Q4 2024.
Debt to capital ratio A solvency ratio calculated as total debt divided by total debt plus shareholders’ equity. Home Depot Inc. debt to capital ratio improved from Q2 2024 to Q3 2024 but then deteriorated significantly from Q3 2024 to Q4 2024.
Debt to capital (including operating lease liability) ratio A solvency ratio calculated as total debt (including operating lease liability) divided by total debt (including operating lease liability) plus shareholders’ equity. Home Depot Inc. debt to capital ratio (including operating lease liability) improved from Q2 2024 to Q3 2024 but then deteriorated significantly from Q3 2024 to Q4 2024.
Debt to assets ratio A solvency ratio calculated as total debt divided by total assets. Home Depot Inc. debt to assets ratio deteriorated from Q2 2024 to Q3 2024 and from Q3 2024 to Q4 2024.
Debt to assets (including operating lease liability) ratio A solvency ratio calculated as total debt (including operating lease liability) divided by total assets. Home Depot Inc. debt to assets ratio (including operating lease liability) deteriorated from Q2 2024 to Q3 2024 and from Q3 2024 to Q4 2024.
Financial leverage ratio A solvency ratio calculated as total assets divided by total shareholders’ equity. Home Depot Inc. financial leverage ratio decreased from Q2 2024 to Q3 2024 but then increased from Q3 2024 to Q4 2024 exceeding Q2 2024 level.

Solvency ratio Description The company
Interest coverage ratio A solvency ratio calculated as EBIT divided by interest payments. Home Depot Inc. interest coverage ratio deteriorated from Q2 2024 to Q3 2024 and from Q3 2024 to Q4 2024.

Debt to Equity

Home Depot Inc., debt to equity calculation (quarterly data)

Microsoft Excel
Jan 28, 2024 Oct 29, 2023 Jul 30, 2023 Apr 30, 2023 Jan 29, 2023 Oct 30, 2022 Jul 31, 2022 May 1, 2022 Jan 30, 2022 Oct 31, 2021 Aug 1, 2021 May 2, 2021 Jan 31, 2021 Nov 1, 2020 Aug 2, 2020 May 3, 2020 Feb 2, 2020 Nov 3, 2019 Aug 4, 2019 May 5, 2019 Feb 3, 2019 Oct 28, 2018 Jul 29, 2018 Apr 29, 2018
Selected Financial Data (US$ in millions)
Short-term debt 539 1,035 974 695 372 1,339 1,398 350
Current installments of long-term debt 1,368 1,362 1,352 1,338 1,231 1,224 1,218 2,463 2,447 2,436 2,428 1,164 1,416 2,491 2,476 4,200 1,839 1,818 1,315 1,084 1,056 1,054 2,203 1,199
Long-term debt, excluding current installments 42,743 40,567 40,754 40,915 41,962 41,740 39,271 39,158 36,604 36,712 33,746 34,697 35,822 32,831 32,370 31,622 28,670 26,597 27,064 26,804 26,807 23,332 23,295 24,244
Total debt 44,111 41,929 42,106 42,253 43,193 42,964 41,028 41,621 40,086 39,148 36,174 35,861 37,238 35,322 34,846 35,822 31,483 29,110 28,379 28,260 29,202 25,784 25,498 25,793
 
Stockholders’ equity (deficit) 1,044 1,430 1,335 362 1,562 1,298 237 (1,709) (1,696) 1,035 2,069 1,748 3,299 1,535 (414) (3,490) (3,116) (1,082) (1,160) (2,143) (1,878) 1,320 2,009 1,687
Solvency Ratio
Debt to equity1 42.25 29.32 31.54 116.72 27.65 33.10 173.11 37.82 17.48 20.52 11.29 23.01 19.53 12.69 15.29
Benchmarks
Debt to Equity, Competitors2
Amazon.com Inc. 0.39 0.43 0.48 0.54 0.59 0.58 0.62 0.53 0.54 0.63 0.67 0.58 0.66 0.73 0.83 0.78 0.83 0.90 0.93 0.99
Lowe’s Cos. Inc. 52.23 15.16 5.35 5.01 12.71 9.79 7.26 6.65 5.42 4.45 2.89 2.74 2.76
TJX Cos. Inc. 0.39 0.42 0.43 0.52 0.53 0.59 0.62 0.60 0.56 0.52 0.52 0.87 1.04 1.11 1.33 1.52 0.38 0.40 0.42 0.44 0.44 0.42 0.43 0.42

Based on: 10-K (reporting date: 2024-01-28), 10-Q (reporting date: 2023-10-29), 10-Q (reporting date: 2023-07-30), 10-Q (reporting date: 2023-04-30), 10-K (reporting date: 2023-01-29), 10-Q (reporting date: 2022-10-30), 10-Q (reporting date: 2022-07-31), 10-Q (reporting date: 2022-05-01), 10-K (reporting date: 2022-01-30), 10-Q (reporting date: 2021-10-31), 10-Q (reporting date: 2021-08-01), 10-Q (reporting date: 2021-05-02), 10-K (reporting date: 2021-01-31), 10-Q (reporting date: 2020-11-01), 10-Q (reporting date: 2020-08-02), 10-Q (reporting date: 2020-05-03), 10-K (reporting date: 2020-02-02), 10-Q (reporting date: 2019-11-03), 10-Q (reporting date: 2019-08-04), 10-Q (reporting date: 2019-05-05), 10-K (reporting date: 2019-02-03), 10-Q (reporting date: 2018-10-28), 10-Q (reporting date: 2018-07-29), 10-Q (reporting date: 2018-04-29).

1 Q4 2024 Calculation
Debt to equity = Total debt ÷ Stockholders’ equity (deficit)
= 44,111 ÷ 1,044 = 42.25

2 Click competitor name to see calculations.

Solvency ratio Description The company
Debt to equity ratio A solvency ratio calculated as total debt divided by total shareholders’ equity. Home Depot Inc. debt to equity ratio improved from Q2 2024 to Q3 2024 but then deteriorated significantly from Q3 2024 to Q4 2024.

Debt to Equity (including Operating Lease Liability)

Home Depot Inc., debt to equity (including operating lease liability) calculation (quarterly data)

Microsoft Excel
Jan 28, 2024 Oct 29, 2023 Jul 30, 2023 Apr 30, 2023 Jan 29, 2023 Oct 30, 2022 Jul 31, 2022 May 1, 2022 Jan 30, 2022 Oct 31, 2021 Aug 1, 2021 May 2, 2021 Jan 31, 2021 Nov 1, 2020 Aug 2, 2020 May 3, 2020 Feb 2, 2020 Nov 3, 2019 Aug 4, 2019 May 5, 2019 Feb 3, 2019 Oct 28, 2018 Jul 29, 2018 Apr 29, 2018
Selected Financial Data (US$ in millions)
Short-term debt 539 1,035 974 695 372 1,339 1,398 350
Current installments of long-term debt 1,368 1,362 1,352 1,338 1,231 1,224 1,218 2,463 2,447 2,436 2,428 1,164 1,416 2,491 2,476 4,200 1,839 1,818 1,315 1,084 1,056 1,054 2,203 1,199
Long-term debt, excluding current installments 42,743 40,567 40,754 40,915 41,962 41,740 39,271 39,158 36,604 36,712 33,746 34,697 35,822 32,831 32,370 31,622 28,670 26,597 27,064 26,804 26,807 23,332 23,295 24,244
Total debt 44,111 41,929 42,106 42,253 43,193 42,964 41,028 41,621 40,086 39,148 36,174 35,861 37,238 35,322 34,846 35,822 31,483 29,110 28,379 28,260 29,202 25,784 25,498 25,793
Current operating lease liabilities 1,050 1,026 1,011 966 945 942 919 859 830 827 814 803 828 842 831 853 828 828 831 793
Long-term operating lease liabilities 7,082 6,300 6,376 6,209 6,226 5,807 5,431 5,335 5,353 5,290 5,360 5,279 5,356 4,880 4,895 5,075 5,066 5,113 5,263 5,145
Total debt (including operating lease liability) 52,243 49,255 49,493 49,428 50,364 49,713 47,378 47,815 46,269 45,265 42,348 41,943 43,422 41,044 40,572 41,750 37,377 35,051 34,473 34,198 29,202 25,784 25,498 25,793
 
Stockholders’ equity (deficit) 1,044 1,430 1,335 362 1,562 1,298 237 (1,709) (1,696) 1,035 2,069 1,748 3,299 1,535 (414) (3,490) (3,116) (1,082) (1,160) (2,143) (1,878) 1,320 2,009 1,687
Solvency Ratio
Debt to equity (including operating lease liability)1 50.04 34.44 37.07 136.54 32.24 38.30 199.91 43.73 20.47 23.99 13.16 26.74 19.53 12.69 15.29
Benchmarks
Debt to Equity (including Operating Lease Liability), Competitors2
Amazon.com Inc. 0.77 0.84 0.91 1.00 1.06 1.05 1.08 0.97 0.96 1.07 1.07 0.98 1.08 1.16 1.23 1.20 1.25 1.32 1.35 1.43
Lowe’s Cos. Inc. 62.29 18.24 6.44 6.01 15.28 12.04 9.07 8.37 6.83 4.45 2.89 2.74 2.76
TJX Cos. Inc. 1.72 1.83 1.90 2.00 2.00 2.23 2.34 2.27 2.08 1.99 2.01 2.42 2.66 2.81 3.36 3.48 1.93 2.07 2.14 2.18 0.44 0.42 0.43 0.42

Based on: 10-K (reporting date: 2024-01-28), 10-Q (reporting date: 2023-10-29), 10-Q (reporting date: 2023-07-30), 10-Q (reporting date: 2023-04-30), 10-K (reporting date: 2023-01-29), 10-Q (reporting date: 2022-10-30), 10-Q (reporting date: 2022-07-31), 10-Q (reporting date: 2022-05-01), 10-K (reporting date: 2022-01-30), 10-Q (reporting date: 2021-10-31), 10-Q (reporting date: 2021-08-01), 10-Q (reporting date: 2021-05-02), 10-K (reporting date: 2021-01-31), 10-Q (reporting date: 2020-11-01), 10-Q (reporting date: 2020-08-02), 10-Q (reporting date: 2020-05-03), 10-K (reporting date: 2020-02-02), 10-Q (reporting date: 2019-11-03), 10-Q (reporting date: 2019-08-04), 10-Q (reporting date: 2019-05-05), 10-K (reporting date: 2019-02-03), 10-Q (reporting date: 2018-10-28), 10-Q (reporting date: 2018-07-29), 10-Q (reporting date: 2018-04-29).

1 Q4 2024 Calculation
Debt to equity (including operating lease liability) = Total debt (including operating lease liability) ÷ Stockholders’ equity (deficit)
= 52,243 ÷ 1,044 = 50.04

2 Click competitor name to see calculations.

Solvency ratio Description The company
Debt to equity (including operating lease liability) ratio A solvency ratio calculated as total debt (including operating lease liability) divided by total shareholders’ equity. Home Depot Inc. debt to equity ratio (including operating lease liability) improved from Q2 2024 to Q3 2024 but then deteriorated significantly from Q3 2024 to Q4 2024.

Debt to Capital

Home Depot Inc., debt to capital calculation (quarterly data)

Microsoft Excel
Jan 28, 2024 Oct 29, 2023 Jul 30, 2023 Apr 30, 2023 Jan 29, 2023 Oct 30, 2022 Jul 31, 2022 May 1, 2022 Jan 30, 2022 Oct 31, 2021 Aug 1, 2021 May 2, 2021 Jan 31, 2021 Nov 1, 2020 Aug 2, 2020 May 3, 2020 Feb 2, 2020 Nov 3, 2019 Aug 4, 2019 May 5, 2019 Feb 3, 2019 Oct 28, 2018 Jul 29, 2018 Apr 29, 2018
Selected Financial Data (US$ in millions)
Short-term debt 539 1,035 974 695 372 1,339 1,398 350
Current installments of long-term debt 1,368 1,362 1,352 1,338 1,231 1,224 1,218 2,463 2,447 2,436 2,428 1,164 1,416 2,491 2,476 4,200 1,839 1,818 1,315 1,084 1,056 1,054 2,203 1,199
Long-term debt, excluding current installments 42,743 40,567 40,754 40,915 41,962 41,740 39,271 39,158 36,604 36,712 33,746 34,697 35,822 32,831 32,370 31,622 28,670 26,597 27,064 26,804 26,807 23,332 23,295 24,244
Total debt 44,111 41,929 42,106 42,253 43,193 42,964 41,028 41,621 40,086 39,148 36,174 35,861 37,238 35,322 34,846 35,822 31,483 29,110 28,379 28,260 29,202 25,784 25,498 25,793
Stockholders’ equity (deficit) 1,044 1,430 1,335 362 1,562 1,298 237 (1,709) (1,696) 1,035 2,069 1,748 3,299 1,535 (414) (3,490) (3,116) (1,082) (1,160) (2,143) (1,878) 1,320 2,009 1,687
Total capital 45,155 43,359 43,441 42,615 44,755 44,262 41,265 39,912 38,390 40,183 38,243 37,609 40,537 36,857 34,432 32,332 28,367 28,028 27,219 26,117 27,324 27,104 27,507 27,480
Solvency Ratio
Debt to capital1 0.98 0.97 0.97 0.99 0.97 0.97 0.99 1.04 1.04 0.97 0.95 0.95 0.92 0.96 1.01 1.11 1.11 1.04 1.04 1.08 1.07 0.95 0.93 0.94
Benchmarks
Debt to Capital, Competitors2
Amazon.com Inc. 0.28 0.30 0.32 0.35 0.37 0.37 0.38 0.35 0.35 0.39 0.40 0.37 0.40 0.42 0.45 0.44 0.45 0.47 0.48 0.50
Lowe’s Cos. Inc. 1.72 1.73 1.68 1.67 1.72 1.62 1.41 1.31 1.24 1.06 1.01 0.98 0.94 0.84 0.83 0.93 0.91 0.88 0.87 0.84 0.82 0.74 0.73 0.73
TJX Cos. Inc. 0.28 0.30 0.30 0.34 0.35 0.37 0.38 0.37 0.36 0.34 0.34 0.46 0.51 0.53 0.57 0.60 0.27 0.29 0.30 0.30 0.31 0.30 0.30 0.30

Based on: 10-K (reporting date: 2024-01-28), 10-Q (reporting date: 2023-10-29), 10-Q (reporting date: 2023-07-30), 10-Q (reporting date: 2023-04-30), 10-K (reporting date: 2023-01-29), 10-Q (reporting date: 2022-10-30), 10-Q (reporting date: 2022-07-31), 10-Q (reporting date: 2022-05-01), 10-K (reporting date: 2022-01-30), 10-Q (reporting date: 2021-10-31), 10-Q (reporting date: 2021-08-01), 10-Q (reporting date: 2021-05-02), 10-K (reporting date: 2021-01-31), 10-Q (reporting date: 2020-11-01), 10-Q (reporting date: 2020-08-02), 10-Q (reporting date: 2020-05-03), 10-K (reporting date: 2020-02-02), 10-Q (reporting date: 2019-11-03), 10-Q (reporting date: 2019-08-04), 10-Q (reporting date: 2019-05-05), 10-K (reporting date: 2019-02-03), 10-Q (reporting date: 2018-10-28), 10-Q (reporting date: 2018-07-29), 10-Q (reporting date: 2018-04-29).

1 Q4 2024 Calculation
Debt to capital = Total debt ÷ Total capital
= 44,111 ÷ 45,155 = 0.98

2 Click competitor name to see calculations.

Solvency ratio Description The company
Debt to capital ratio A solvency ratio calculated as total debt divided by total debt plus shareholders’ equity. Home Depot Inc. debt to capital ratio improved from Q2 2024 to Q3 2024 but then deteriorated significantly from Q3 2024 to Q4 2024.

Debt to Capital (including Operating Lease Liability)

Home Depot Inc., debt to capital (including operating lease liability) calculation (quarterly data)

Microsoft Excel
Jan 28, 2024 Oct 29, 2023 Jul 30, 2023 Apr 30, 2023 Jan 29, 2023 Oct 30, 2022 Jul 31, 2022 May 1, 2022 Jan 30, 2022 Oct 31, 2021 Aug 1, 2021 May 2, 2021 Jan 31, 2021 Nov 1, 2020 Aug 2, 2020 May 3, 2020 Feb 2, 2020 Nov 3, 2019 Aug 4, 2019 May 5, 2019 Feb 3, 2019 Oct 28, 2018 Jul 29, 2018 Apr 29, 2018
Selected Financial Data (US$ in millions)
Short-term debt 539 1,035 974 695 372 1,339 1,398 350
Current installments of long-term debt 1,368 1,362 1,352 1,338 1,231 1,224 1,218 2,463 2,447 2,436 2,428 1,164 1,416 2,491 2,476 4,200 1,839 1,818 1,315 1,084 1,056 1,054 2,203 1,199
Long-term debt, excluding current installments 42,743 40,567 40,754 40,915 41,962 41,740 39,271 39,158 36,604 36,712 33,746 34,697 35,822 32,831 32,370 31,622 28,670 26,597 27,064 26,804 26,807 23,332 23,295 24,244
Total debt 44,111 41,929 42,106 42,253 43,193 42,964 41,028 41,621 40,086 39,148 36,174 35,861 37,238 35,322 34,846 35,822 31,483 29,110 28,379 28,260 29,202 25,784 25,498 25,793
Current operating lease liabilities 1,050 1,026 1,011 966 945 942 919 859 830 827 814 803 828 842 831 853 828 828 831 793
Long-term operating lease liabilities 7,082 6,300 6,376 6,209 6,226 5,807 5,431 5,335 5,353 5,290 5,360 5,279 5,356 4,880 4,895 5,075 5,066 5,113 5,263 5,145
Total debt (including operating lease liability) 52,243 49,255 49,493 49,428 50,364 49,713 47,378 47,815 46,269 45,265 42,348 41,943 43,422 41,044 40,572 41,750 37,377 35,051 34,473 34,198 29,202 25,784 25,498 25,793
Stockholders’ equity (deficit) 1,044 1,430 1,335 362 1,562 1,298 237 (1,709) (1,696) 1,035 2,069 1,748 3,299 1,535 (414) (3,490) (3,116) (1,082) (1,160) (2,143) (1,878) 1,320 2,009 1,687
Total capital (including operating lease liability) 53,287 50,685 50,828 49,790 51,926 51,011 47,615 46,106 44,573 46,300 44,417 43,691 46,721 42,579 40,158 38,260 34,261 33,969 33,313 32,055 27,324 27,104 27,507 27,480
Solvency Ratio
Debt to capital (including operating lease liability)1 0.98 0.97 0.97 0.99 0.97 0.97 1.00 1.04 1.04 0.98 0.95 0.96 0.93 0.96 1.01 1.09 1.09 1.03 1.03 1.07 1.07 0.95 0.93 0.94
Benchmarks
Debt to Capital (including Operating Lease Liability), Competitors2
Amazon.com Inc. 0.43 0.46 0.48 0.50 0.51 0.51 0.52 0.49 0.49 0.52 0.52 0.49 0.52 0.54 0.55 0.54 0.56 0.57 0.57 0.59
Lowe’s Cos. Inc. 1.60 1.61 1.57 1.57 1.60 1.51 1.34 1.26 1.20 1.05 1.01 0.98 0.95 0.87 0.86 0.94 0.92 0.90 0.89 0.87 0.82 0.74 0.73 0.73
TJX Cos. Inc. 0.63 0.65 0.66 0.67 0.67 0.69 0.70 0.69 0.68 0.67 0.67 0.71 0.73 0.74 0.77 0.78 0.66 0.67 0.68 0.69 0.31 0.30 0.30 0.30

Based on: 10-K (reporting date: 2024-01-28), 10-Q (reporting date: 2023-10-29), 10-Q (reporting date: 2023-07-30), 10-Q (reporting date: 2023-04-30), 10-K (reporting date: 2023-01-29), 10-Q (reporting date: 2022-10-30), 10-Q (reporting date: 2022-07-31), 10-Q (reporting date: 2022-05-01), 10-K (reporting date: 2022-01-30), 10-Q (reporting date: 2021-10-31), 10-Q (reporting date: 2021-08-01), 10-Q (reporting date: 2021-05-02), 10-K (reporting date: 2021-01-31), 10-Q (reporting date: 2020-11-01), 10-Q (reporting date: 2020-08-02), 10-Q (reporting date: 2020-05-03), 10-K (reporting date: 2020-02-02), 10-Q (reporting date: 2019-11-03), 10-Q (reporting date: 2019-08-04), 10-Q (reporting date: 2019-05-05), 10-K (reporting date: 2019-02-03), 10-Q (reporting date: 2018-10-28), 10-Q (reporting date: 2018-07-29), 10-Q (reporting date: 2018-04-29).

1 Q4 2024 Calculation
Debt to capital (including operating lease liability) = Total debt (including operating lease liability) ÷ Total capital (including operating lease liability)
= 52,243 ÷ 53,287 = 0.98

2 Click competitor name to see calculations.

Solvency ratio Description The company
Debt to capital (including operating lease liability) ratio A solvency ratio calculated as total debt (including operating lease liability) divided by total debt (including operating lease liability) plus shareholders’ equity. Home Depot Inc. debt to capital ratio (including operating lease liability) improved from Q2 2024 to Q3 2024 but then deteriorated significantly from Q3 2024 to Q4 2024.

Debt to Assets

Home Depot Inc., debt to assets calculation (quarterly data)

Microsoft Excel
Jan 28, 2024 Oct 29, 2023 Jul 30, 2023 Apr 30, 2023 Jan 29, 2023 Oct 30, 2022 Jul 31, 2022 May 1, 2022 Jan 30, 2022 Oct 31, 2021 Aug 1, 2021 May 2, 2021 Jan 31, 2021 Nov 1, 2020 Aug 2, 2020 May 3, 2020 Feb 2, 2020 Nov 3, 2019 Aug 4, 2019 May 5, 2019 Feb 3, 2019 Oct 28, 2018 Jul 29, 2018 Apr 29, 2018
Selected Financial Data (US$ in millions)
Short-term debt 539 1,035 974 695 372 1,339 1,398 350
Current installments of long-term debt 1,368 1,362 1,352 1,338 1,231 1,224 1,218 2,463 2,447 2,436 2,428 1,164 1,416 2,491 2,476 4,200 1,839 1,818 1,315 1,084 1,056 1,054 2,203 1,199
Long-term debt, excluding current installments 42,743 40,567 40,754 40,915 41,962 41,740 39,271 39,158 36,604 36,712 33,746 34,697 35,822 32,831 32,370 31,622 28,670 26,597 27,064 26,804 26,807 23,332 23,295 24,244
Total debt 44,111 41,929 42,106 42,253 43,193 42,964 41,028 41,621 40,086 39,148 36,174 35,861 37,238 35,322 34,846 35,822 31,483 29,110 28,379 28,260 29,202 25,784 25,498 25,793
 
Total assets 76,530 75,577 76,387 76,386 76,445 76,866 75,825 76,567 71,876 73,031 70,769 72,567 70,581 66,919 63,349 58,737 51,236 52,309 52,010 51,515 44,003 45,200 46,232 46,650
Solvency Ratio
Debt to assets1 0.58 0.55 0.55 0.55 0.57 0.56 0.54 0.54 0.56 0.54 0.51 0.49 0.53 0.53 0.55 0.61 0.61 0.56 0.55 0.55 0.66 0.57 0.55 0.55
Benchmarks
Debt to Assets, Competitors2
Amazon.com Inc. 0.15 0.16 0.17 0.18 0.19 0.19 0.19 0.17 0.18 0.20 0.21 0.19 0.19 0.22 0.24 0.23 0.23 0.25 0.26 0.27
Lowe’s Cos. Inc. 0.86 0.84 0.82 0.80 0.78 0.71 0.62 0.58 0.55 0.53 0.49 0.45 0.47 0.43 0.42 0.48 0.49 0.45 0.43 0.41 0.47 0.42 0.43 0.41
TJX Cos. Inc. 0.10 0.09 0.10 0.12 0.12 0.12 0.12 0.12 0.12 0.11 0.12 0.18 0.20 0.20 0.23 0.28 0.09 0.09 0.10 0.10 0.16 0.15 0.16 0.16

Based on: 10-K (reporting date: 2024-01-28), 10-Q (reporting date: 2023-10-29), 10-Q (reporting date: 2023-07-30), 10-Q (reporting date: 2023-04-30), 10-K (reporting date: 2023-01-29), 10-Q (reporting date: 2022-10-30), 10-Q (reporting date: 2022-07-31), 10-Q (reporting date: 2022-05-01), 10-K (reporting date: 2022-01-30), 10-Q (reporting date: 2021-10-31), 10-Q (reporting date: 2021-08-01), 10-Q (reporting date: 2021-05-02), 10-K (reporting date: 2021-01-31), 10-Q (reporting date: 2020-11-01), 10-Q (reporting date: 2020-08-02), 10-Q (reporting date: 2020-05-03), 10-K (reporting date: 2020-02-02), 10-Q (reporting date: 2019-11-03), 10-Q (reporting date: 2019-08-04), 10-Q (reporting date: 2019-05-05), 10-K (reporting date: 2019-02-03), 10-Q (reporting date: 2018-10-28), 10-Q (reporting date: 2018-07-29), 10-Q (reporting date: 2018-04-29).

1 Q4 2024 Calculation
Debt to assets = Total debt ÷ Total assets
= 44,111 ÷ 76,530 = 0.58

2 Click competitor name to see calculations.

Solvency ratio Description The company
Debt to assets ratio A solvency ratio calculated as total debt divided by total assets. Home Depot Inc. debt to assets ratio deteriorated from Q2 2024 to Q3 2024 and from Q3 2024 to Q4 2024.

Debt to Assets (including Operating Lease Liability)

Home Depot Inc., debt to assets (including operating lease liability) calculation (quarterly data)

Microsoft Excel
Jan 28, 2024 Oct 29, 2023 Jul 30, 2023 Apr 30, 2023 Jan 29, 2023 Oct 30, 2022 Jul 31, 2022 May 1, 2022 Jan 30, 2022 Oct 31, 2021 Aug 1, 2021 May 2, 2021 Jan 31, 2021 Nov 1, 2020 Aug 2, 2020 May 3, 2020 Feb 2, 2020 Nov 3, 2019 Aug 4, 2019 May 5, 2019 Feb 3, 2019 Oct 28, 2018 Jul 29, 2018 Apr 29, 2018
Selected Financial Data (US$ in millions)
Short-term debt 539 1,035 974 695 372 1,339 1,398 350
Current installments of long-term debt 1,368 1,362 1,352 1,338 1,231 1,224 1,218 2,463 2,447 2,436 2,428 1,164 1,416 2,491 2,476 4,200 1,839 1,818 1,315 1,084 1,056 1,054 2,203 1,199
Long-term debt, excluding current installments 42,743 40,567 40,754 40,915 41,962 41,740 39,271 39,158 36,604 36,712 33,746 34,697 35,822 32,831 32,370 31,622 28,670 26,597 27,064 26,804 26,807 23,332 23,295 24,244
Total debt 44,111 41,929 42,106 42,253 43,193 42,964 41,028 41,621 40,086 39,148 36,174 35,861 37,238 35,322 34,846 35,822 31,483 29,110 28,379 28,260 29,202 25,784 25,498 25,793
Current operating lease liabilities 1,050 1,026 1,011 966 945 942 919 859 830 827 814 803 828 842 831 853 828 828 831 793
Long-term operating lease liabilities 7,082 6,300 6,376 6,209 6,226 5,807 5,431 5,335 5,353 5,290 5,360 5,279 5,356 4,880 4,895 5,075 5,066 5,113 5,263 5,145
Total debt (including operating lease liability) 52,243 49,255 49,493 49,428 50,364 49,713 47,378 47,815 46,269 45,265 42,348 41,943 43,422 41,044 40,572 41,750 37,377 35,051 34,473 34,198 29,202 25,784 25,498 25,793
 
Total assets 76,530 75,577 76,387 76,386 76,445 76,866 75,825 76,567 71,876 73,031 70,769 72,567 70,581 66,919 63,349 58,737 51,236 52,309 52,010 51,515 44,003 45,200 46,232 46,650
Solvency Ratio
Debt to assets (including operating lease liability)1 0.68 0.65 0.65 0.65 0.66 0.65 0.62 0.62 0.64 0.62 0.60 0.58 0.62 0.61 0.64 0.71 0.73 0.67 0.66 0.66 0.66 0.57 0.55 0.55
Benchmarks
Debt to Assets (including Operating Lease Liability), Competitors2
Amazon.com Inc. 0.29 0.32 0.32 0.33 0.33 0.34 0.34 0.32 0.31 0.34 0.34 0.31 0.31 0.34 0.35 0.35 0.34 0.37 0.37 0.39
Lowe’s Cos. Inc. 0.96 0.94 0.91 0.88 0.87 0.81 0.72 0.68 0.66 0.63 0.58 0.54 0.56 0.52 0.51 0.57 0.60 0.56 0.54 0.51 0.47 0.42 0.43 0.41
TJX Cos. Inc. 0.42 0.41 0.43 0.45 0.45 0.44 0.47 0.46 0.44 0.43 0.45 0.49 0.50 0.50 0.59 0.65 0.47 0.47 0.50 0.50 0.16 0.15 0.16 0.16

Based on: 10-K (reporting date: 2024-01-28), 10-Q (reporting date: 2023-10-29), 10-Q (reporting date: 2023-07-30), 10-Q (reporting date: 2023-04-30), 10-K (reporting date: 2023-01-29), 10-Q (reporting date: 2022-10-30), 10-Q (reporting date: 2022-07-31), 10-Q (reporting date: 2022-05-01), 10-K (reporting date: 2022-01-30), 10-Q (reporting date: 2021-10-31), 10-Q (reporting date: 2021-08-01), 10-Q (reporting date: 2021-05-02), 10-K (reporting date: 2021-01-31), 10-Q (reporting date: 2020-11-01), 10-Q (reporting date: 2020-08-02), 10-Q (reporting date: 2020-05-03), 10-K (reporting date: 2020-02-02), 10-Q (reporting date: 2019-11-03), 10-Q (reporting date: 2019-08-04), 10-Q (reporting date: 2019-05-05), 10-K (reporting date: 2019-02-03), 10-Q (reporting date: 2018-10-28), 10-Q (reporting date: 2018-07-29), 10-Q (reporting date: 2018-04-29).

1 Q4 2024 Calculation
Debt to assets (including operating lease liability) = Total debt (including operating lease liability) ÷ Total assets
= 52,243 ÷ 76,530 = 0.68

2 Click competitor name to see calculations.

Solvency ratio Description The company
Debt to assets (including operating lease liability) ratio A solvency ratio calculated as total debt (including operating lease liability) divided by total assets. Home Depot Inc. debt to assets ratio (including operating lease liability) deteriorated from Q2 2024 to Q3 2024 and from Q3 2024 to Q4 2024.

Financial Leverage

Home Depot Inc., financial leverage calculation (quarterly data)

Microsoft Excel
Jan 28, 2024 Oct 29, 2023 Jul 30, 2023 Apr 30, 2023 Jan 29, 2023 Oct 30, 2022 Jul 31, 2022 May 1, 2022 Jan 30, 2022 Oct 31, 2021 Aug 1, 2021 May 2, 2021 Jan 31, 2021 Nov 1, 2020 Aug 2, 2020 May 3, 2020 Feb 2, 2020 Nov 3, 2019 Aug 4, 2019 May 5, 2019 Feb 3, 2019 Oct 28, 2018 Jul 29, 2018 Apr 29, 2018
Selected Financial Data (US$ in millions)
Total assets 76,530 75,577 76,387 76,386 76,445 76,866 75,825 76,567 71,876 73,031 70,769 72,567 70,581 66,919 63,349 58,737 51,236 52,309 52,010 51,515 44,003 45,200 46,232 46,650
Stockholders’ equity (deficit) 1,044 1,430 1,335 362 1,562 1,298 237 (1,709) (1,696) 1,035 2,069 1,748 3,299 1,535 (414) (3,490) (3,116) (1,082) (1,160) (2,143) (1,878) 1,320 2,009 1,687
Solvency Ratio
Financial leverage1 73.30 52.85 57.22 211.01 48.94 59.22 319.94 70.56 34.20 41.51 21.39 43.60 34.24 23.01 27.65
Benchmarks
Financial Leverage, Competitors2
Amazon.com Inc. 2.61 2.66 2.83 3.01 3.17 3.12 3.19 3.07 3.04 3.17 3.14 3.13 3.44 3.41 3.50 3.39 3.63 3.52 3.61 3.68
Lowe’s Cos. Inc. 115.06 32.52 12.49 11.88 26.71 20.02 16.18 15.41 13.36 9.47 6.81 6.42 6.66
TJX Cos. Inc. 4.07 4.44 4.38 4.47 4.45 5.02 5.02 4.95 4.74 4.67 4.49 4.94 5.28 5.67 5.70 5.36 4.06 4.38 4.31 4.38 2.84 2.86 2.70 2.66

Based on: 10-K (reporting date: 2024-01-28), 10-Q (reporting date: 2023-10-29), 10-Q (reporting date: 2023-07-30), 10-Q (reporting date: 2023-04-30), 10-K (reporting date: 2023-01-29), 10-Q (reporting date: 2022-10-30), 10-Q (reporting date: 2022-07-31), 10-Q (reporting date: 2022-05-01), 10-K (reporting date: 2022-01-30), 10-Q (reporting date: 2021-10-31), 10-Q (reporting date: 2021-08-01), 10-Q (reporting date: 2021-05-02), 10-K (reporting date: 2021-01-31), 10-Q (reporting date: 2020-11-01), 10-Q (reporting date: 2020-08-02), 10-Q (reporting date: 2020-05-03), 10-K (reporting date: 2020-02-02), 10-Q (reporting date: 2019-11-03), 10-Q (reporting date: 2019-08-04), 10-Q (reporting date: 2019-05-05), 10-K (reporting date: 2019-02-03), 10-Q (reporting date: 2018-10-28), 10-Q (reporting date: 2018-07-29), 10-Q (reporting date: 2018-04-29).

1 Q4 2024 Calculation
Financial leverage = Total assets ÷ Stockholders’ equity (deficit)
= 76,530 ÷ 1,044 = 73.30

2 Click competitor name to see calculations.

Solvency ratio Description The company
Financial leverage ratio A solvency ratio calculated as total assets divided by total shareholders’ equity. Home Depot Inc. financial leverage ratio decreased from Q2 2024 to Q3 2024 but then increased from Q3 2024 to Q4 2024 exceeding Q2 2024 level.

Interest Coverage

Home Depot Inc., interest coverage calculation (quarterly data)

Microsoft Excel
Jan 28, 2024 Oct 29, 2023 Jul 30, 2023 Apr 30, 2023 Jan 29, 2023 Oct 30, 2022 Jul 31, 2022 May 1, 2022 Jan 30, 2022 Oct 31, 2021 Aug 1, 2021 May 2, 2021 Jan 31, 2021 Nov 1, 2020 Aug 2, 2020 May 3, 2020 Feb 2, 2020 Nov 3, 2019 Aug 4, 2019 May 5, 2019 Feb 3, 2019 Oct 28, 2018 Jul 29, 2018 Apr 29, 2018
Selected Financial Data (US$ in millions)
Net earnings 2,801 3,810 4,659 3,873 3,362 4,339 5,173 4,231 3,352 4,129 4,807 4,145 2,857 3,432 4,332 2,245 2,481 2,769 3,479 2,513 2,344 2,867 3,506 2,404
Add: Income tax expense 884 1,158 1,502 1,237 982 1,403 1,658 1,329 1,150 1,340 1,511 1,303 899 1,091 1,398 724 630 898 1,134 811 769 779 1,149 738
Add: Interest expense 513 487 469 474 451 413 381 372 341 341 326 339 337 340 346 324 309 302 302 288 269 249 272 261
Earnings before interest and tax (EBIT) 4,198 5,455 6,630 5,584 4,795 6,155 7,212 5,932 4,843 5,810 6,644 5,787 4,093 4,863 6,076 3,293 3,420 3,969 4,915 3,612 3,382 3,895 4,927 3,403
Solvency Ratio
Interest coverage1 11.25 11.94 12.82 13.81 14.90 16.02 16.58 16.83 17.14 16.63 15.94 15.29 13.60 13.38 13.08 12.61 13.25 13.68 14.26 14.67 14.85
Benchmarks
Interest Coverage, Competitors2
Amazon.com Inc. 12.80 8.24 5.60 2.27 -1.51 5.61 6.57 13.02 22.09 18.81 21.05 19.96 15.69 13.12 10.78 8.85 9.73

Based on: 10-K (reporting date: 2024-01-28), 10-Q (reporting date: 2023-10-29), 10-Q (reporting date: 2023-07-30), 10-Q (reporting date: 2023-04-30), 10-K (reporting date: 2023-01-29), 10-Q (reporting date: 2022-10-30), 10-Q (reporting date: 2022-07-31), 10-Q (reporting date: 2022-05-01), 10-K (reporting date: 2022-01-30), 10-Q (reporting date: 2021-10-31), 10-Q (reporting date: 2021-08-01), 10-Q (reporting date: 2021-05-02), 10-K (reporting date: 2021-01-31), 10-Q (reporting date: 2020-11-01), 10-Q (reporting date: 2020-08-02), 10-Q (reporting date: 2020-05-03), 10-K (reporting date: 2020-02-02), 10-Q (reporting date: 2019-11-03), 10-Q (reporting date: 2019-08-04), 10-Q (reporting date: 2019-05-05), 10-K (reporting date: 2019-02-03), 10-Q (reporting date: 2018-10-28), 10-Q (reporting date: 2018-07-29), 10-Q (reporting date: 2018-04-29).

1 Q4 2024 Calculation
Interest coverage = (EBITQ4 2024 + EBITQ3 2024 + EBITQ2 2024 + EBITQ1 2024) ÷ (Interest expenseQ4 2024 + Interest expenseQ3 2024 + Interest expenseQ2 2024 + Interest expenseQ1 2024)
= (4,198 + 5,455 + 6,630 + 5,584) ÷ (513 + 487 + 469 + 474) = 11.25

2 Click competitor name to see calculations.

Solvency ratio Description The company
Interest coverage ratio A solvency ratio calculated as EBIT divided by interest payments. Home Depot Inc. interest coverage ratio deteriorated from Q2 2024 to Q3 2024 and from Q3 2024 to Q4 2024.