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:
This is a one-time payment. There is no automatic renewal.
Home Depot Inc. (HD)
Analysis of Long-term (Investment) Activity Ratios
Quarterly Data
Beginner level
Activity ratios measure how efficiently a company performs day-to-day tasks, such us the collection of receivables and management of inventory.
Long-term Activity Ratios (Summary)
Home Depot Inc., long-term (investment) activity ratios (quarterly data)
Based on: 10-Q (filing date: 2019-11-26), 10-Q (filing date: 2019-08-27), 10-Q (filing date: 2019-05-29), 10-K (filing date: 2019-03-28), 10-Q (filing date: 2018-11-20), 10-Q (filing date: 2018-08-21), 10-Q (filing date: 2018-05-22), 10-K (filing date: 2018-03-22), 10-Q (filing date: 2017-11-21), 10-Q (filing date: 2017-08-22), 10-Q (filing date: 2017-05-23), 10-K (filing date: 2017-03-23), 10-Q (filing date: 2016-11-22), 10-Q (filing date: 2016-08-23), 10-Q (filing date: 2016-05-24), 10-K (filing date: 2016-03-24), 10-Q (filing date: 2015-11-24), 10-Q (filing date: 2015-08-25), 10-Q (filing date: 2015-05-27), 10-K (filing date: 2015-03-26), 10-Q (filing date: 2014-11-25), 10-Q (filing date: 2014-08-27), 10-Q (filing date: 2014-05-28), 10-K (filing date: 2014-03-27), 10-Q (filing date: 2013-11-27), 10-Q (filing date: 2013-08-28), 10-Q (filing date: 2013-05-29).
| Long-term activity ratio | Description | The company |
|---|---|---|
| Net fixed asset turnover | An activity ratio calculated as total revenue divided by net fixed assets. | Home Depot Inc.’s net fixed asset turnover ratio deteriorated from Q1 2020 to Q2 2020 but then improved from Q2 2020 to Q3 2020 exceeding Q1 2020 level. |
| Net fixed asset turnover (including operating lease, right-of-use asset) | An activity ratio calculated as total revenue divided by net fixed assets (including operating lease, right-of-use asset). | Home Depot Inc.’s net fixed asset turnover ratio (with operating lease, right-of-use asset) deteriorated from Q1 2020 to Q2 2020 but then improved from Q2 2020 to Q3 2020 exceeding Q1 2020 level. |
| Total asset turnover | An activity ratio calculated as total revenue divided by total assets. | Home Depot Inc.’s total asset turnover ratio deteriorated from Q1 2020 to Q2 2020 but then slightly improved from Q2 2020 to Q3 2020. |
| Equity turnover | An activity ratio calculated as total revenue divided by shareholders’ equity. |
Net Fixed Asset Turnover
Home Depot Inc., net fixed asset turnover calculation (quarterly data)
| Nov 3, 2019 | Aug 4, 2019 | May 5, 2019 | Feb 3, 2019 | Oct 28, 2018 | Jul 29, 2018 | Apr 29, 2018 | Jan 28, 2018 | Oct 29, 2017 | Jul 30, 2017 | Apr 30, 2017 | Jan 29, 2017 | Oct 30, 2016 | Jul 31, 2016 | May 1, 2016 | Jan 31, 2016 | Nov 1, 2015 | Aug 2, 2015 | May 3, 2015 | Feb 1, 2015 | Nov 2, 2014 | Aug 3, 2014 | May 4, 2014 | Feb 2, 2014 | Nov 3, 2013 | Aug 4, 2013 | May 5, 2013 | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | ||||||||||||||||||||||||||||
| Net sales | |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Net property and equipment | |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Long-term Activity Ratio | ||||||||||||||||||||||||||||
| Net fixed asset turnover1 | |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Benchmarks | ||||||||||||||||||||||||||||
| Net Fixed Asset Turnover, Competitors2 | ||||||||||||||||||||||||||||
| Amazon.com Inc. | |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Costco Wholesale Corp. | |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Lowe’s Cos. Inc. | |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Netflix Inc. | |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Target Corp. | |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| TJX Cos. Inc. | |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Walmart Inc. | |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Based on: 10-Q (filing date: 2019-11-26), 10-Q (filing date: 2019-08-27), 10-Q (filing date: 2019-05-29), 10-K (filing date: 2019-03-28), 10-Q (filing date: 2018-11-20), 10-Q (filing date: 2018-08-21), 10-Q (filing date: 2018-05-22), 10-K (filing date: 2018-03-22), 10-Q (filing date: 2017-11-21), 10-Q (filing date: 2017-08-22), 10-Q (filing date: 2017-05-23), 10-K (filing date: 2017-03-23), 10-Q (filing date: 2016-11-22), 10-Q (filing date: 2016-08-23), 10-Q (filing date: 2016-05-24), 10-K (filing date: 2016-03-24), 10-Q (filing date: 2015-11-24), 10-Q (filing date: 2015-08-25), 10-Q (filing date: 2015-05-27), 10-K (filing date: 2015-03-26), 10-Q (filing date: 2014-11-25), 10-Q (filing date: 2014-08-27), 10-Q (filing date: 2014-05-28), 10-K (filing date: 2014-03-27), 10-Q (filing date: 2013-11-27), 10-Q (filing date: 2013-08-28), 10-Q (filing date: 2013-05-29).
1 Q3 2020 Calculation
Net fixed asset turnover
= (Net salesQ3 2020
+ Net salesQ2 2020
+ Net salesQ1 2020
+ Net salesQ4 2019)
÷ Net property and equipment
= ( + + + )
÷ =
2 Click competitor name to see calculations.
| Long-term activity ratio | Description | The company |
|---|---|---|
| Net fixed asset turnover | An activity ratio calculated as total revenue divided by net fixed assets. | Home Depot Inc.’s net fixed asset turnover ratio deteriorated from Q1 2020 to Q2 2020 but then improved from Q2 2020 to Q3 2020 exceeding Q1 2020 level. |
Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset)
Home Depot Inc., net fixed asset turnover (including operating lease, right-of-use asset) calculation (quarterly data)
| Nov 3, 2019 | Aug 4, 2019 | May 5, 2019 | Feb 3, 2019 | Oct 28, 2018 | Jul 29, 2018 | Apr 29, 2018 | Jan 28, 2018 | Oct 29, 2017 | Jul 30, 2017 | Apr 30, 2017 | Jan 29, 2017 | Oct 30, 2016 | Jul 31, 2016 | May 1, 2016 | Jan 31, 2016 | Nov 1, 2015 | Aug 2, 2015 | May 3, 2015 | Feb 1, 2015 | Nov 2, 2014 | Aug 3, 2014 | May 4, 2014 | Feb 2, 2014 | Nov 3, 2013 | Aug 4, 2013 | May 5, 2013 | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | ||||||||||||||||||||||||||||
| Net sales | |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Net property and equipment | |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Operating lease right-of-use assets | |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Net property and equipment (including operating lease, right-of-use asset) | |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Long-term Activity Ratio | ||||||||||||||||||||||||||||
| Net fixed asset turnover (including operating lease, right-of-use asset)1 | |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Benchmarks | ||||||||||||||||||||||||||||
| Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset), Competitors2 | ||||||||||||||||||||||||||||
| Amazon.com Inc. | |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Costco Wholesale Corp. | |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Lowe’s Cos. Inc. | |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Target Corp. | |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| TJX Cos. Inc. | |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Walmart Inc. | |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Based on: 10-Q (filing date: 2019-11-26), 10-Q (filing date: 2019-08-27), 10-Q (filing date: 2019-05-29), 10-K (filing date: 2019-03-28), 10-Q (filing date: 2018-11-20), 10-Q (filing date: 2018-08-21), 10-Q (filing date: 2018-05-22), 10-K (filing date: 2018-03-22), 10-Q (filing date: 2017-11-21), 10-Q (filing date: 2017-08-22), 10-Q (filing date: 2017-05-23), 10-K (filing date: 2017-03-23), 10-Q (filing date: 2016-11-22), 10-Q (filing date: 2016-08-23), 10-Q (filing date: 2016-05-24), 10-K (filing date: 2016-03-24), 10-Q (filing date: 2015-11-24), 10-Q (filing date: 2015-08-25), 10-Q (filing date: 2015-05-27), 10-K (filing date: 2015-03-26), 10-Q (filing date: 2014-11-25), 10-Q (filing date: 2014-08-27), 10-Q (filing date: 2014-05-28), 10-K (filing date: 2014-03-27), 10-Q (filing date: 2013-11-27), 10-Q (filing date: 2013-08-28), 10-Q (filing date: 2013-05-29).
1 Q3 2020 Calculation
Net fixed asset turnover (including operating lease, right-of-use asset)
= (Net salesQ3 2020
+ Net salesQ2 2020
+ Net salesQ1 2020
+ Net salesQ4 2019)
÷ Net property and equipment (including operating lease, right-of-use asset)
= ( + + + )
÷ =
2 Click competitor name to see calculations.
| Long-term activity ratio | Description | The company |
|---|---|---|
| Net fixed asset turnover (including operating lease, right-of-use asset) | An activity ratio calculated as total revenue divided by net fixed assets (including operating lease, right-of-use asset). | Home Depot Inc.’s net fixed asset turnover ratio (with operating lease, right-of-use asset) deteriorated from Q1 2020 to Q2 2020 but then improved from Q2 2020 to Q3 2020 exceeding Q1 2020 level. |
Total Asset Turnover
Home Depot Inc., total asset turnover calculation (quarterly data)
| Nov 3, 2019 | Aug 4, 2019 | May 5, 2019 | Feb 3, 2019 | Oct 28, 2018 | Jul 29, 2018 | Apr 29, 2018 | Jan 28, 2018 | Oct 29, 2017 | Jul 30, 2017 | Apr 30, 2017 | Jan 29, 2017 | Oct 30, 2016 | Jul 31, 2016 | May 1, 2016 | Jan 31, 2016 | Nov 1, 2015 | Aug 2, 2015 | May 3, 2015 | Feb 1, 2015 | Nov 2, 2014 | Aug 3, 2014 | May 4, 2014 | Feb 2, 2014 | Nov 3, 2013 | Aug 4, 2013 | May 5, 2013 | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | ||||||||||||||||||||||||||||
| Net sales | |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Total assets | |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Long-term Activity Ratio | ||||||||||||||||||||||||||||
| Total asset turnover1 | |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Benchmarks | ||||||||||||||||||||||||||||
| Total Asset Turnover, Competitors2 | ||||||||||||||||||||||||||||
| Amazon.com Inc. | |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Costco Wholesale Corp. | |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Lowe’s Cos. Inc. | |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Netflix Inc. | |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Target Corp. | |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| TJX Cos. Inc. | |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Walmart Inc. | |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Based on: 10-Q (filing date: 2019-11-26), 10-Q (filing date: 2019-08-27), 10-Q (filing date: 2019-05-29), 10-K (filing date: 2019-03-28), 10-Q (filing date: 2018-11-20), 10-Q (filing date: 2018-08-21), 10-Q (filing date: 2018-05-22), 10-K (filing date: 2018-03-22), 10-Q (filing date: 2017-11-21), 10-Q (filing date: 2017-08-22), 10-Q (filing date: 2017-05-23), 10-K (filing date: 2017-03-23), 10-Q (filing date: 2016-11-22), 10-Q (filing date: 2016-08-23), 10-Q (filing date: 2016-05-24), 10-K (filing date: 2016-03-24), 10-Q (filing date: 2015-11-24), 10-Q (filing date: 2015-08-25), 10-Q (filing date: 2015-05-27), 10-K (filing date: 2015-03-26), 10-Q (filing date: 2014-11-25), 10-Q (filing date: 2014-08-27), 10-Q (filing date: 2014-05-28), 10-K (filing date: 2014-03-27), 10-Q (filing date: 2013-11-27), 10-Q (filing date: 2013-08-28), 10-Q (filing date: 2013-05-29).
1 Q3 2020 Calculation
Total asset turnover
= (Net salesQ3 2020
+ Net salesQ2 2020
+ Net salesQ1 2020
+ Net salesQ4 2019)
÷ Total assets
= ( + + + )
÷ =
2 Click competitor name to see calculations.
| Long-term activity ratio | Description | The company |
|---|---|---|
| Total asset turnover | An activity ratio calculated as total revenue divided by total assets. | Home Depot Inc.’s total asset turnover ratio deteriorated from Q1 2020 to Q2 2020 but then slightly improved from Q2 2020 to Q3 2020. |
Equity Turnover
Home Depot Inc., equity turnover calculation (quarterly data)
| Nov 3, 2019 | Aug 4, 2019 | May 5, 2019 | Feb 3, 2019 | Oct 28, 2018 | Jul 29, 2018 | Apr 29, 2018 | Jan 28, 2018 | Oct 29, 2017 | Jul 30, 2017 | Apr 30, 2017 | Jan 29, 2017 | Oct 30, 2016 | Jul 31, 2016 | May 1, 2016 | Jan 31, 2016 | Nov 1, 2015 | Aug 2, 2015 | May 3, 2015 | Feb 1, 2015 | Nov 2, 2014 | Aug 3, 2014 | May 4, 2014 | Feb 2, 2014 | Nov 3, 2013 | Aug 4, 2013 | May 5, 2013 | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in millions) | ||||||||||||||||||||||||||||
| Net sales | |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Stockholders’ equity (deficit) | |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Long-term Activity Ratio | ||||||||||||||||||||||||||||
| Equity turnover1 | |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Benchmarks | ||||||||||||||||||||||||||||
| Equity Turnover, Competitors2 | ||||||||||||||||||||||||||||
| Amazon.com Inc. | |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Costco Wholesale Corp. | |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Lowe’s Cos. Inc. | |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Netflix Inc. | |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Target Corp. | |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| TJX Cos. Inc. | |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Walmart Inc. | |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Based on: 10-Q (filing date: 2019-11-26), 10-Q (filing date: 2019-08-27), 10-Q (filing date: 2019-05-29), 10-K (filing date: 2019-03-28), 10-Q (filing date: 2018-11-20), 10-Q (filing date: 2018-08-21), 10-Q (filing date: 2018-05-22), 10-K (filing date: 2018-03-22), 10-Q (filing date: 2017-11-21), 10-Q (filing date: 2017-08-22), 10-Q (filing date: 2017-05-23), 10-K (filing date: 2017-03-23), 10-Q (filing date: 2016-11-22), 10-Q (filing date: 2016-08-23), 10-Q (filing date: 2016-05-24), 10-K (filing date: 2016-03-24), 10-Q (filing date: 2015-11-24), 10-Q (filing date: 2015-08-25), 10-Q (filing date: 2015-05-27), 10-K (filing date: 2015-03-26), 10-Q (filing date: 2014-11-25), 10-Q (filing date: 2014-08-27), 10-Q (filing date: 2014-05-28), 10-K (filing date: 2014-03-27), 10-Q (filing date: 2013-11-27), 10-Q (filing date: 2013-08-28), 10-Q (filing date: 2013-05-29).
1 Q3 2020 Calculation
Equity turnover
= (Net salesQ3 2020
+ Net salesQ2 2020
+ Net salesQ1 2020
+ Net salesQ4 2019)
÷ Stockholders’ equity (deficit)
= ( + + + )
÷ =
2 Click competitor name to see calculations.
| Long-term activity ratio | Description | The company |
|---|---|---|
| Equity turnover | An activity ratio calculated as total revenue divided by shareholders’ equity. |