Stock Analysis on Net
Stock Analysis on Net
Microsoft Excel LibreOffice Calc

Home Depot Inc. (NYSE:HD)

Paying users zone. Data is hidden behind: .

  • 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.

Analysis of Liquidity Ratios

Beginner level

Liquidity Ratios (Summary)

Home Depot Inc., liquidity ratios

Microsoft Excel LibreOffice Calc
Jan 31, 2021 Feb 2, 2020 Feb 3, 2019 Jan 28, 2018 Jan 29, 2017 Jan 31, 2016
Current ratio
Quick ratio
Cash ratio

Based on: 10-K (filing date: 2021-03-24), 10-K (filing date: 2020-03-25), 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).

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 2019 to 2020 but then improved from 2020 to 2021 exceeding 2019 level.
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 2019 to 2020 and from 2020 to 2021.
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 2019 to 2020 and from 2020 to 2021.

Current Ratio

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

Microsoft Excel LibreOffice Calc
Jan 31, 2021 Feb 2, 2020 Feb 3, 2019 Jan 28, 2018 Jan 29, 2017 Jan 31, 2016
Selected Financial Data (US$ in millions)
Current assets
Current liabilities
Liquidity Ratio
Current ratio1
Benchmarks
Current Ratio, Competitors2
Amazon.com Inc.
Booking Holdings Inc.
Lowe’s Cos. Inc.
Target Corp.
TJX Cos. Inc.
Current Ratio, Sector
Retailing
Current Ratio, Industry
Consumer Discretionary

Based on: 10-K (filing date: 2021-03-24), 10-K (filing date: 2020-03-25), 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).

1 2021 Calculation
Current ratio = Current assets ÷ Current liabilities
= ÷ =

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 2019 to 2020 but then improved from 2020 to 2021 exceeding 2019 level.

Quick Ratio

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

Microsoft Excel LibreOffice Calc
Jan 31, 2021 Feb 2, 2020 Feb 3, 2019 Jan 28, 2018 Jan 29, 2017 Jan 31, 2016
Selected Financial Data (US$ in millions)
Cash and cash equivalents
Receivables, net
Total quick assets
 
Current liabilities
Liquidity Ratio
Quick ratio1
Benchmarks
Quick Ratio, Competitors2
Amazon.com Inc.
Booking Holdings Inc.
Lowe’s Cos. Inc.
Target Corp.
TJX Cos. Inc.
Quick Ratio, Sector
Retailing
Quick Ratio, Industry
Consumer Discretionary

Based on: 10-K (filing date: 2021-03-24), 10-K (filing date: 2020-03-25), 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).

1 2021 Calculation
Quick ratio = Total quick assets ÷ Current liabilities
= ÷ =

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 2019 to 2020 and from 2020 to 2021.

Cash Ratio

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

Microsoft Excel LibreOffice Calc
Jan 31, 2021 Feb 2, 2020 Feb 3, 2019 Jan 28, 2018 Jan 29, 2017 Jan 31, 2016
Selected Financial Data (US$ in millions)
Cash and cash equivalents
Total cash assets
 
Current liabilities
Liquidity Ratio
Cash ratio1
Benchmarks
Cash Ratio, Competitors2
Amazon.com Inc.
Booking Holdings Inc.
Lowe’s Cos. Inc.
Target Corp.
TJX Cos. Inc.
Cash Ratio, Sector
Retailing
Cash Ratio, Industry
Consumer Discretionary

Based on: 10-K (filing date: 2021-03-24), 10-K (filing date: 2020-03-25), 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).

1 2021 Calculation
Cash ratio = Total cash assets ÷ Current liabilities
= ÷ =

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 2019 to 2020 and from 2020 to 2021.