Microsoft Excel LibreOffice Calc

Home Depot Inc. (HD)


Long-term (Investment) Activity Analysis

Difficulty: Beginner


Ratios (Summary)

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

Microsoft Excel LibreOffice Calc
Feb 3, 2019 Jan 28, 2018 Jan 29, 2017 Jan 31, 2016 Feb 1, 2015 Feb 2, 2014
Net fixed asset turnover 4.84 4.57 4.32 3.99 3.66 3.38
Total asset turnover 2.46 2.27 2.20 2.08 2.08 1.95
Equity turnover 69.40 21.83 14.02 8.92 6.29

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

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

Net Fixed Asset Turnover

Home Depot Inc., net fixed asset turnover 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 (USD $ in millions)
Net sales 108,203  100,904  94,595  88,519  83,176  78,812 
Net property and equipment 22,375  22,075  21,914  22,191  22,720  23,348 
Ratio
Net fixed asset turnover1 4.84 4.57 4.32 3.99 3.66 3.38
Benchmarks
Net Fixed Asset Turnover, Competitors
Amazon.com Inc. 3.77 3.64 4.67 4.90 5.24
Costco Wholesale Corp. 7.03 6.95 6.81 7.38 7.43
eBay Inc. 6.73 5.99 5.92 5.53 6.17
Lowe’s Cos. Inc. 3.87 3.48 3.26 3.02 2.81 2.56
Netflix Inc. 37.76 36.61 35.27 39.09 36.73
Target Corp. 2.92 2.87 2.82 2.93 2.80 2.31
TJX Cos. Inc. 7.42 7.16 7.32 7.48 7.52 7.63
Walmart Inc. 4.58 4.32 4.22 4.11 4.13 4.01
Net Fixed Asset Turnover, Sector
General Retailers 4.33 4.21 4.25 4.20 4.00
Net Fixed Asset Turnover, Industry
Consumer Services 3.92 3.85 3.84 3.93 3.75

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

2019 Calculations

1 Net fixed asset turnover = Net sales ÷ Net property and equipment
= 108,203 ÷ 22,375 = 4.84

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 improved from 2017 to 2018 and from 2018 to 2019.

Total Asset Turnover

Home Depot Inc., total asset turnover 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 (USD $ in millions)
Net sales 108,203  100,904  94,595  88,519  83,176  78,812 
Total assets 44,003  44,529  42,966  42,549  39,946  40,518 
Ratio
Total asset turnover1 2.46 2.27 2.20 2.08 2.08 1.95
Benchmarks
Total Asset Turnover, Competitors
Amazon.com Inc. 1.43 1.35 1.63 1.64 1.63
Costco Wholesale Corp. 3.39 3.47 3.50 3.40 3.34
eBay Inc. 0.47 0.37 0.38 0.48 0.40
Lowe’s Cos. Inc. 2.07 1.94 1.89 1.89 1.77 1.63
Netflix Inc. 0.61 0.61 0.65 0.66 0.78
Target Corp. 1.80 1.84 1.86 1.83 1.75 1.63
TJX Cos. Inc. 2.72 2.55 2.58 2.69 2.61 2.69
Walmart Inc. 2.33 2.42 2.42 2.40 2.37 2.31
Total Asset Turnover, Sector
General Retailers 1.99 1.98 2.09 2.11 1.96
Total Asset Turnover, Industry
Consumer Services 1.20 1.31 1.30 1.41 1.42

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

2019 Calculations

1 Total asset turnover = Net sales ÷ Total assets
= 108,203 ÷ 44,003 = 2.46

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 improved from 2017 to 2018 and from 2018 to 2019.

Equity Turnover

Home Depot Inc., equity turnover 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 (USD $ in millions)
Net sales 108,203  100,904  94,595  88,519  83,176  78,812 
Stockholders’ equity (deficit) (1,878) 1,454  4,333  6,316  9,322  12,522 
Ratio
Equity turnover1 69.40 21.83 14.02 8.92 6.29
Benchmarks
Equity Turnover, Competitors
Amazon.com Inc. 5.35 6.42 7.05 8.00 8.28
Costco Wholesale Corp. 10.82 11.71 9.61 10.71 8.96
eBay Inc. 1.71 1.19 0.85 1.31 0.90
Lowe’s Cos. Inc. 19.57 11.68 10.11 7.72 5.64 4.51
Netflix Inc. 3.01 3.26 3.30 3.05 2.96
Target Corp. 6.59 6.14 6.34 5.69 5.19 4.47
TJX Cos. Inc. 7.72 6.97 7.36 7.18 6.82 6.48
Walmart Inc. 7.04 6.37 6.19 5.94 5.92 6.20
Equity Turnover, Sector
General Retailers 6.89 6.93 6.40 6.32 5.59
Equity Turnover, Industry
Consumer Services 4.23 4.19 4.02 4.23 3.87

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

2019 Calculations

1 Equity turnover = Net sales ÷ Stockholders’ equity (deficit)
= 108,203 ÷ -1,878 =

Ratio Description The company
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Home Depot Inc.’s equity turnover improved from 2017 to 2018 but then deteriorated significantly from 2018 to 2019.