Paying users zone. Data is covered by hidden.

  • Get to Home Depot Inc. for $19.99, or

  • get to entire website for at least 3 months from $49.99.


Visa Mastercard Maestro American Express Discover JCB    PayPal

Microsoft Excel LibreOffice Calc

Home Depot Inc. (HD)


Long-term Debt and Solvency Analysis

Difficulty: Beginner


Ratios (Summary)

Home Depot Inc., debt and solvency ratios

Microsoft Excel LibreOffice Calc
Jan 28, 2018 Jan 29, 2017 Jan 31, 2016 Feb 1, 2015 Feb 2, 2014 Feb 3, 2013
Debt to equity hidden hidden hidden hidden hidden hidden
Debt to capital hidden hidden hidden hidden hidden hidden
Interest coverage hidden hidden hidden hidden hidden hidden

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

Ratio Description The company
Debt-to-equity ratio A solvency ratio calculated as total debt divided by total shareholders’ equity. Home Depot Inc.’s debt-to-equity ratio deteriorated from 2016 to 2017 and from 2017 to 2018.
Debt-to-capital ratio A solvency ratio calculated as total debt divided by total debt plus shareholders’ equity. Home Depot Inc.’s debt-to-capital ratio deteriorated from 2016 to 2017 and from 2017 to 2018.

Ratio Description The company
Interest coverage ratio A solvency ratio calculated as EBIT divided by interest payments. Home Depot Inc.’s interest coverage ratio improved from 2016 to 2017 and from 2017 to 2018.

Debt to Equity

Home Depot Inc., debt to equity calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Jan 28, 2018 Jan 29, 2017 Jan 31, 2016 Feb 1, 2015 Feb 2, 2014 Feb 3, 2013
Selected Financial Data (USD $ in millions)
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 hidden hidden hidden hidden hidden hidden
Stockholders’ equity hidden hidden hidden hidden hidden hidden
Ratio
Debt to equity1 hidden hidden hidden hidden hidden hidden
Benchmarks
Debt to Equity, Competitors
Amazon.com Inc. hidden hidden hidden hidden hidden hidden
Costco Wholesale Corp. hidden hidden hidden hidden hidden hidden
eBay Inc. hidden hidden hidden hidden hidden hidden
Lowe’s Cos. Inc. hidden hidden hidden hidden hidden hidden
Netflix Inc. hidden hidden hidden hidden hidden hidden
Target Corp. hidden hidden hidden hidden hidden hidden
TJX Cos. Inc. hidden hidden hidden hidden hidden hidden
Walmart Inc. hidden hidden hidden hidden hidden hidden
Debt to Equity, Sector
General Retailers hidden hidden hidden hidden hidden hidden
Debt to Equity, Industry
Consumer Services hidden hidden hidden hidden hidden hidden

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

2018 Calculations

1 Debt to equity = Total debt ÷ Stockholders’ equity
= hidden ÷ hidden = hidden

Ratio Description The company
Debt-to-equity ratio A solvency ratio calculated as total debt divided by total shareholders’ equity. Home Depot Inc.’s debt-to-equity ratio deteriorated from 2016 to 2017 and from 2017 to 2018.

Debt to Capital

Home Depot Inc., debt to capital calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Jan 28, 2018 Jan 29, 2017 Jan 31, 2016 Feb 1, 2015 Feb 2, 2014 Feb 3, 2013
Selected Financial Data (USD $ in millions)
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 hidden hidden hidden hidden hidden hidden
Stockholders’ equity hidden hidden hidden hidden hidden hidden
Total capital hidden hidden hidden hidden hidden hidden
Ratio
Debt to capital1 hidden hidden hidden hidden hidden hidden
Benchmarks
Debt to Capital, Competitors
Amazon.com Inc. hidden hidden hidden hidden hidden hidden
Costco Wholesale Corp. hidden hidden hidden hidden hidden hidden
eBay Inc. hidden hidden hidden hidden hidden hidden
Lowe’s Cos. Inc. hidden hidden hidden hidden hidden hidden
Netflix Inc. hidden hidden hidden hidden hidden hidden
Target Corp. hidden hidden hidden hidden hidden hidden
TJX Cos. Inc. hidden hidden hidden hidden hidden hidden
Walmart Inc. hidden hidden hidden hidden hidden hidden
Debt to Capital, Sector
General Retailers hidden hidden hidden hidden hidden hidden
Debt to Capital, Industry
Consumer Services hidden hidden hidden hidden hidden hidden

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

2018 Calculations

1 Debt to capital = Total debt ÷ Total capital
= hidden ÷ hidden = hidden

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.’s debt-to-capital ratio deteriorated from 2016 to 2017 and from 2017 to 2018.

Interest Coverage

Home Depot Inc., interest coverage calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Jan 28, 2018 Jan 29, 2017 Jan 31, 2016 Feb 1, 2015 Feb 2, 2014 Feb 3, 2013
Selected Financial Data (USD $ 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
Ratio
Interest coverage1 hidden hidden hidden hidden hidden hidden
Benchmarks
Interest Coverage, Competitors
Amazon.com Inc. hidden hidden hidden hidden hidden hidden
Costco Wholesale Corp. hidden hidden hidden hidden hidden hidden
eBay Inc. hidden hidden hidden hidden hidden hidden
Lowe’s Cos. Inc. hidden hidden hidden hidden hidden hidden
Netflix Inc. hidden hidden hidden hidden hidden hidden
Target Corp. hidden hidden hidden hidden hidden hidden
TJX Cos. Inc. hidden hidden hidden hidden hidden hidden
Walmart Inc. hidden hidden hidden hidden hidden hidden
Interest Coverage, Sector
General Retailers hidden hidden hidden hidden hidden hidden
Interest Coverage, Industry
Consumer Services hidden hidden hidden hidden hidden hidden

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

2018 Calculations

1 Interest coverage = EBIT ÷ Interest expense
= hidden ÷ hidden = hidden

Ratio Description The company
Interest coverage ratio A solvency ratio calculated as EBIT divided by interest payments. Home Depot Inc.’s interest coverage ratio improved from 2016 to 2017 and from 2017 to 2018.