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 Liquidity Ratios

Low level of difficulty


Liquidity Ratios (Summary)

Home Depot Inc., liquidity ratios

Microsoft Excel LibreOffice Calc
Feb 3, 2019 Jan 28, 2018 Jan 29, 2017 Jan 31, 2016 Feb 1, 2015 Feb 2, 2014
Current ratio hidden hidden hidden hidden hidden hidden
Quick ratio hidden hidden hidden hidden hidden hidden
Cash ratio 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).

Liquidity ratio Description The company
Current ratio A liquidity ratio calculated as current assets divided by current liabilities. Home Depot Inc.’s current ratio deteriorated from 2017 to 2018 and from 2018 to 2019.
Quick ratio A liquidity ratio calculated as (cash plus short-term marketable investments plus receivables) divided by current liabilities. Home Depot Inc.’s quick ratio improved from 2017 to 2018 but then deteriorated significantly from 2018 to 2019.
Cash ratio A liquidity ratio calculated as (cash plus short-term marketable investments) divided by current liabilities. Home Depot Inc.’s cash ratio improved from 2017 to 2018 but then deteriorated significantly from 2018 to 2019.

Current Ratio

Home Depot Inc., current ratio calculation, comparison to benchmarks

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)
Current assets hidden hidden hidden hidden hidden hidden
Current liabilities hidden hidden hidden hidden hidden hidden
Liquidity Ratio
Current ratio1 hidden hidden hidden hidden hidden hidden
Benchmarks
Current Ratio, Competitors2
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
Current Ratio, Sector
General Retailers hidden hidden hidden hidden hidden hidden
Current Ratio, Industry
Consumer Services 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).

1 2019 Calculation
Current ratio = Current assets ÷ Current liabilities
= hidden ÷ hidden = hidden

2 Click competitor name to see calculations.

Liquidity ratio Description The company
Current ratio A liquidity ratio calculated as current assets divided by current liabilities. Home Depot Inc.’s current ratio deteriorated from 2017 to 2018 and from 2018 to 2019.

Quick Ratio

Home Depot Inc., quick ratio calculation, comparison to benchmarks

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)
Cash and cash equivalents hidden hidden hidden hidden hidden hidden
Receivables, net hidden hidden hidden hidden hidden hidden
Total quick assets hidden hidden hidden hidden hidden hidden
 
Current liabilities hidden hidden hidden hidden hidden hidden
Liquidity Ratio
Quick ratio1 hidden hidden hidden hidden hidden hidden
Benchmarks
Quick Ratio, Competitors2
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
Quick Ratio, Sector
General Retailers hidden hidden hidden hidden hidden hidden
Quick Ratio, Industry
Consumer Services 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).

1 2019 Calculation
Quick ratio = Total quick assets ÷ Current liabilities
= hidden ÷ hidden = hidden

2 Click competitor name to see calculations.

Liquidity ratio Description The company
Quick ratio A liquidity ratio calculated as (cash plus short-term marketable investments plus receivables) divided by current liabilities. Home Depot Inc.’s quick ratio improved from 2017 to 2018 but then deteriorated significantly from 2018 to 2019.

Cash Ratio

Home Depot Inc., cash ratio calculation, comparison to benchmarks

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)
Cash and cash equivalents hidden hidden hidden hidden hidden hidden
Total cash assets hidden hidden hidden hidden hidden hidden
 
Current liabilities hidden hidden hidden hidden hidden hidden
Liquidity Ratio
Cash ratio1 hidden hidden hidden hidden hidden hidden
Benchmarks
Cash Ratio, Competitors2
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
Cash Ratio, Sector
General Retailers hidden hidden hidden hidden hidden hidden
Cash Ratio, Industry
Consumer Services 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).

1 2019 Calculation
Cash ratio = Total cash assets ÷ Current liabilities
= hidden ÷ hidden = hidden

2 Click competitor name to see calculations.

Liquidity ratio Description The company
Cash ratio A liquidity ratio calculated as (cash plus short-term marketable investments) divided by current liabilities. Home Depot Inc.’s cash ratio improved from 2017 to 2018 but then deteriorated significantly from 2018 to 2019.