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)


Analysis of Debt

High level of difficulty


Debt Accounting Policy

Home Depot records any premiums or discounts associated with an issuance of long-term debt as a direct addition or deduction to the carrying value of the related senior notes. Home Depot also records debt issuance costs associated with an issuance of long-term debt as a direct deduction to the carrying value of the related senior notes. Premium, discount, and debt issuance costs are amortized over the term of the respective notes using the effective interest rate method.

Source: 10-K (filing date: 2019-03-28).


Total Debt (Carrying Amount)

Home Depot Inc., balance sheet: debt

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
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 debt (carrying amount) 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).

Debt item Description The company
Total debt (carrying amount) Sum of the carrying values as of the balance sheet date of all debt plus capital lease obligations. Home Depot Inc.’s total debt increased from 2017 to 2018 and from 2018 to 2019.

Total Debt (Fair Value)

Microsoft Excel LibreOffice Calc
Feb 3, 2019
Selected Financial Data (US$ in millions)
Commercial paper hidden
Senior notes hidden
Capital lease obligations hidden
Other debt hidden
Total debt (fair value) hidden
Financial Ratio
Debt, fair value to carrying amount ratio hidden

Based on: 10-K (filing date: 2019-03-28).


Weighted-average Interest Rate on Debt

Weighted-average interest rate on debt: hidden

Interest Rate Debt Amount1 Interest Rate × Debt Amount Weighted-average Interest Rate2
hidden hidden hidden
hidden hidden hidden
hidden hidden hidden
hidden hidden hidden
hidden hidden hidden
hidden hidden hidden
hidden hidden hidden
hidden hidden hidden
hidden hidden hidden
hidden hidden hidden
hidden hidden hidden
hidden hidden hidden
hidden hidden hidden
hidden hidden hidden
hidden hidden hidden
hidden hidden hidden
hidden hidden hidden
hidden hidden hidden
hidden hidden hidden
hidden hidden hidden
hidden hidden hidden
hidden hidden hidden
hidden hidden hidden
hidden hidden hidden
hidden hidden hidden
hidden hidden hidden
Total hidden hidden
hidden

Based on: 10-K (filing date: 2019-03-28).

1 US$ in millions

2 Weighted-average interest rate = 100 × hidden ÷ hidden = hidden


Interest Costs Incurred

Home Depot Inc., interest costs incurred

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
Interest expense hidden hidden hidden hidden hidden hidden
Interest capitalized hidden hidden hidden hidden hidden hidden
Interest costs incurred 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).

Debt item Description The company
Interest expense Amount of the cost of borrowed funds accounted for as interest expense for debt. Home Depot Inc.’s interest expense increased from 2017 to 2018 but then slightly declined from 2018 to 2019.
Interest capitalized Amount of interest costs capitalized disclosed as an adjusting item to interest costs incurred.
Interest costs incurred Total interest costs incurred during the period and either capitalized or charged against earnings. Home Depot Inc.’s interest costs incurred increased from 2017 to 2018 but then slightly declined from 2018 to 2019.

Adjusted Interest Coverage Ratio

Microsoft Excel LibreOffice Calc
Feb 3, 2019 Jan 28, 2018 Jan 29, 2017 Jan 31, 2016 Feb 1, 2015 Feb 2, 2014
Selected Financial Data (US$ in millions)
Net earnings hidden hidden hidden hidden hidden hidden
Add: Income tax expense hidden hidden hidden hidden hidden hidden
Add: Interest expense hidden hidden hidden hidden hidden hidden
Earnings before interest and tax (EBIT) hidden hidden hidden hidden hidden hidden
 
Interest costs incurred hidden hidden hidden hidden hidden hidden
Financial Ratio With and Without Capitalized Interest
Interest coverage ratio (without capitalized interest)1 hidden hidden hidden hidden hidden hidden
Adjusted interest coverage ratio (with capitalized interest)2 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).

2019 Calculations

1 Interest coverage ratio (without capitalized interest) = EBIT ÷ Interest expense
= hidden ÷ hidden = hidden

2 Adjusted interest coverage ratio (with capitalized interest) = EBIT ÷ Interest costs incurred
= hidden ÷ hidden = hidden


Solvency ratio Description The company
Adjusted interest coverage ratio A solvency ratio calculated as EBIT divided by interest payments (including capitalized interest). Home Depot Inc.’s adjusted interest coverage ratio improved from 2017 to 2018 and from 2018 to 2019.