Paying users zone. Data is covered by hidden.


We accept:

Visa Mastercard American Express Maestro Discover JCB PayPal Apple Pay Google Pay
Verified by Visa MasterCard SecureCode American Express SafeKey

Microsoft Excel LibreOffice Calc

Home Depot Inc. (HD)


Profitability Analysis

Difficulty: Beginner


Ratios (Summary)

Home Depot Inc., profitability ratios

Microsoft Excel LibreOffice Calc
Feb 3, 2019 Jan 28, 2018 Jan 29, 2017 Jan 31, 2016 Feb 1, 2015 Feb 2, 2014
Return on Sales
Gross profit margin hidden hidden hidden hidden hidden hidden
Operating profit margin hidden hidden hidden hidden hidden hidden
Net profit margin hidden hidden hidden hidden hidden hidden
Return on Investment
Return on equity (ROE) hidden hidden hidden hidden hidden hidden
Return on assets (ROA) 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).

Ratio Description The company
Gross profit margin Gross profit margin indicates the percentage of revenue available to cover operating and other expenditures. Home Depot Inc.’s gross profit margin deteriorated from 2017 to 2018 but then improved from 2018 to 2019 exceeding 2017 level.
Operating profit margin A profitability ratio calculated as operating income divided by revenue. Home Depot Inc.’s operating profit margin improved from 2017 to 2018 but then slightly deteriorated from 2018 to 2019 not reaching 2017 level.
Net profit margin An indicator of profitability, calculated as net income divided by revenue. Home Depot Inc.’s net profit margin improved from 2017 to 2018 and from 2018 to 2019.

Ratio Description The company
ROE A profitability ratio calculated as net income divided by shareholders’ equity. Home Depot Inc.’s ROE improved from 2017 to 2018 but then deteriorated significantly from 2018 to 2019.
ROA A profitability ratio calculated as net income divided by total assets. Home Depot Inc.’s ROA improved from 2017 to 2018 and from 2018 to 2019.

Gross Profit Margin

Home Depot Inc., gross profit margin 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)
Gross profit hidden hidden hidden hidden hidden hidden
Net sales hidden hidden hidden hidden hidden hidden
Ratio
Gross profit margin1 hidden hidden hidden hidden hidden hidden
Benchmarks
Gross Profit Margin, Competitors
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

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 Gross profit margin = 100 × Gross profit ÷ Net sales
= 100 × hidden ÷ hidden = hidden

Ratio Description The company
Gross profit margin Gross profit margin indicates the percentage of revenue available to cover operating and other expenditures. Home Depot Inc.’s gross profit margin deteriorated from 2017 to 2018 but then improved from 2018 to 2019 exceeding 2017 level.

Operating Profit Margin

Home Depot Inc., operating profit margin 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)
Operating income hidden hidden hidden hidden hidden hidden
Net sales hidden hidden hidden hidden hidden hidden
Ratio
Operating profit margin1 hidden hidden hidden hidden hidden hidden
Benchmarks
Operating Profit Margin, Competitors
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
Operating Profit Margin, Sector
General Retailers hidden hidden hidden hidden hidden hidden
Operating Profit Margin, 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).

2019 Calculations

1 Operating profit margin = 100 × Operating income ÷ Net sales
= 100 × hidden ÷ hidden = hidden

Ratio Description The company
Operating profit margin A profitability ratio calculated as operating income divided by revenue. Home Depot Inc.’s operating profit margin improved from 2017 to 2018 but then slightly deteriorated from 2018 to 2019 not reaching 2017 level.

Net Profit Margin

Home Depot Inc., net profit margin 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 earnings hidden hidden hidden hidden hidden hidden
Net sales hidden hidden hidden hidden hidden hidden
Ratio
Net profit margin1 hidden hidden hidden hidden hidden hidden
Benchmarks
Net Profit Margin, Competitors
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
Net Profit Margin, Sector
General Retailers hidden hidden hidden hidden hidden hidden
Net Profit Margin, 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).

2019 Calculations

1 Net profit margin = 100 × Net earnings ÷ Net sales
= 100 × hidden ÷ hidden = hidden

Ratio Description The company
Net profit margin An indicator of profitability, calculated as net income divided by revenue. Home Depot Inc.’s net profit margin improved from 2017 to 2018 and from 2018 to 2019.

Return on Equity (ROE)

Home Depot Inc., ROE 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 earnings hidden hidden hidden hidden hidden hidden
Stockholders’ equity (deficit) hidden hidden hidden hidden hidden hidden
Ratio
ROE1 hidden hidden hidden hidden hidden hidden
Benchmarks
ROE, Competitors
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
ROE, Sector
General Retailers hidden hidden hidden hidden hidden hidden
ROE, 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).

2019 Calculations

1 ROE = 100 × Net earnings ÷ Stockholders’ equity (deficit)
= 100 × hidden ÷ hidden = hidden

Ratio Description The company
ROE A profitability ratio calculated as net income divided by shareholders’ equity. Home Depot Inc.’s ROE improved from 2017 to 2018 but then deteriorated significantly from 2018 to 2019.

Return on Assets (ROA)

Home Depot Inc., ROA 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 earnings hidden hidden hidden hidden hidden hidden
Total assets hidden hidden hidden hidden hidden hidden
Ratio
ROA1 hidden hidden hidden hidden hidden hidden
Benchmarks
ROA, Competitors
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
ROA, Sector
General Retailers hidden hidden hidden hidden hidden hidden
ROA, 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).

2019 Calculations

1 ROA = 100 × Net earnings ÷ Total assets
= 100 × hidden ÷ hidden = hidden

Ratio Description The company
ROA A profitability ratio calculated as net income divided by total assets. Home Depot Inc.’s ROA improved from 2017 to 2018 and from 2018 to 2019.