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 Long-term (Investment) Activity Ratios

Beginner level


Long-term Activity Ratios (Summary)

Home Depot Inc., long-term (investment) activity ratios

Microsoft Excel LibreOffice Calc
Feb 2, 2020 Feb 3, 2019 Jan 28, 2018 Jan 29, 2017 Jan 31, 2016 Feb 1, 2015
Net fixed asset turnover
Net fixed asset turnover (including operating lease, right-of-use asset)
Total asset turnover
Equity turnover

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

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 improved from 2018 to 2019 and from 2019 to 2020.
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) improved from 2018 to 2019 but then deteriorated significantly from 2019 to 2020.
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Home Depot Inc.’s total asset turnover ratio improved from 2018 to 2019 but then deteriorated significantly from 2019 to 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, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Feb 2, 2020 Feb 3, 2019 Jan 28, 2018 Jan 29, 2017 Jan 31, 2016 Feb 1, 2015
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.
Dollar General Corp.
Lowe’s Cos. Inc.
Target Corp.
TJX Cos. Inc.
Walmart Inc.
Net Fixed Asset Turnover, Sector
General Retailers
Net Fixed Asset Turnover, Industry
Consumer Services

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

1 2020 Calculation
Net fixed asset turnover = Net sales ÷ 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 improved from 2018 to 2019 and from 2019 to 2020.

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, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Feb 2, 2020 Feb 3, 2019 Jan 28, 2018 Jan 29, 2017 Jan 31, 2016 Feb 1, 2015
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.
Dollar General Corp.
Lowe’s Cos. Inc.
Target Corp.
TJX Cos. Inc.
Walmart Inc.
Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset), Sector
General Retailers
Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset), Industry
Consumer Services

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

1 2020 Calculation
Net fixed asset turnover (including operating lease, right-of-use asset) = Net sales ÷ 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) improved from 2018 to 2019 but then deteriorated significantly from 2019 to 2020.

Total Asset Turnover

Home Depot Inc., total asset turnover calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Feb 2, 2020 Feb 3, 2019 Jan 28, 2018 Jan 29, 2017 Jan 31, 2016 Feb 1, 2015
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.
Dollar General Corp.
Lowe’s Cos. Inc.
Target Corp.
TJX Cos. Inc.
Walmart Inc.
Total Asset Turnover, Sector
General Retailers
Total Asset Turnover, Industry
Consumer Services

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

1 2020 Calculation
Total asset turnover = Net sales ÷ 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 improved from 2018 to 2019 but then deteriorated significantly from 2019 to 2020.

Equity Turnover

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

Microsoft Excel LibreOffice Calc
Feb 2, 2020 Feb 3, 2019 Jan 28, 2018 Jan 29, 2017 Jan 31, 2016 Feb 1, 2015
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.
Dollar General Corp.
Lowe’s Cos. Inc.
Target Corp.
TJX Cos. Inc.
Walmart Inc.
Equity Turnover, Sector
General Retailers
Equity Turnover, Industry
Consumer Services

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

1 2020 Calculation
Equity turnover = Net sales ÷ 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.