Stock Analysis on Net

Home Depot Inc. (NYSE:HD)

$24.99

Return on Capital (ROC)

Microsoft Excel

Return on capital (ROC) is after tax rate of return on net business assets. ROIC is unaffected by changes in interest rates or company debt and equity structure. It measures business productivity performance.

Paying users area

The data is hidden behind: . Unhide it.

  • Get 1-month access to Home Depot Inc. for $24.99, or

  • get full access to the entire website for at least 3 months from $62.19.

This is a one-time payment. There is no automatic renewal.


We accept:

Visa Mastercard American Express Maestro Discover JCB PayPal Apple Pay Google Pay
Visa Secure Mastercard Identity Check American Express SafeKey

Return on Invested Capital (ROIC)

Home Depot Inc., ROIC calculation, comparison to benchmarks

Microsoft Excel
Jan 28, 2024 Jan 29, 2023 Jan 30, 2022 Jan 31, 2021 Feb 2, 2020 Feb 3, 2019
Selected Financial Data (US$ in millions)
Net operating profit after taxes (NOPAT)1
Invested capital2
Performance Ratio
ROIC3
Benchmarks
ROIC, Competitors4
Amazon.com Inc.
Lowe’s Cos. Inc.
TJX Cos. Inc.

Based on: 10-K (reporting date: 2024-01-28), 10-K (reporting date: 2023-01-29), 10-K (reporting date: 2022-01-30), 10-K (reporting date: 2021-01-31), 10-K (reporting date: 2020-02-02), 10-K (reporting date: 2019-02-03).

1 NOPAT. See details »

2 Invested capital. See details »

3 2024 Calculation
ROIC = 100 × NOPAT ÷ Invested capital
= 100 × ÷ =

4 Click competitor name to see calculations.

Performance ratio Description The company
ROIC A measure of the periodic, after tax, cash-on-cash yield earned in the business. Home Depot Inc. ROIC deteriorated from 2022 to 2023 and from 2023 to 2024.

Decomposition of ROIC

Home Depot Inc., decomposition of ROIC

Microsoft Excel
ROIC = OPM1 × TO2 × 1 – CTR3
Jan 28, 2024 = × ×
Jan 29, 2023 = × ×
Jan 30, 2022 = × ×
Jan 31, 2021 = × ×
Feb 2, 2020 = × ×
Feb 3, 2019 = × ×

Based on: 10-K (reporting date: 2024-01-28), 10-K (reporting date: 2023-01-29), 10-K (reporting date: 2022-01-30), 10-K (reporting date: 2021-01-31), 10-K (reporting date: 2020-02-02), 10-K (reporting date: 2019-02-03).

1 Operating profit margin (OPM). See calculations »

2 Turnover of capital (TO). See calculations »

3 Effective cash tax rate (CTR). See calculations »

The primary reason for the decrease in return on invested capital (ROIC) over 2024 year is the decrease in profitability measured by operating profit margin (OPM) ratio.


Operating Profit Margin (OPM)

Home Depot Inc., OPM calculation, comparison to benchmarks

Microsoft Excel
Jan 28, 2024 Jan 29, 2023 Jan 30, 2022 Jan 31, 2021 Feb 2, 2020 Feb 3, 2019
Selected Financial Data (US$ in millions)
Net operating profit after taxes (NOPAT)1
Add: Cash operating taxes2
Net operating profit before taxes (NOPBT)
 
Net sales
Add: Increase (decrease) in deferred revenue
Adjusted net sales
Profitability Ratio
OPM3
Benchmarks
OPM, Competitors4
Amazon.com Inc.
Lowe’s Cos. Inc.
TJX Cos. Inc.

Based on: 10-K (reporting date: 2024-01-28), 10-K (reporting date: 2023-01-29), 10-K (reporting date: 2022-01-30), 10-K (reporting date: 2021-01-31), 10-K (reporting date: 2020-02-02), 10-K (reporting date: 2019-02-03).

1 NOPAT. See details »

2 Cash operating taxes. See details »

3 2024 Calculation
OPM = 100 × NOPBT ÷ Adjusted net sales
= 100 × ÷ =

4 Click competitor name to see calculations.

Profitability ratio Description The company
OPM The operating profit margin (OPM) is the ratio of pretax economic earnings, or NOPBT, to sales. Home Depot Inc. OPM deteriorated from 2022 to 2023 and from 2023 to 2024.

Turnover of Capital (TO)

Home Depot Inc., TO calculation, comparison to benchmarks

Microsoft Excel
Jan 28, 2024 Jan 29, 2023 Jan 30, 2022 Jan 31, 2021 Feb 2, 2020 Feb 3, 2019
Selected Financial Data (US$ in millions)
Net sales
Add: Increase (decrease) in deferred revenue
Adjusted net sales
 
Invested capital1
Efficiency Ratio
TO2
Benchmarks
TO, Competitors3
Amazon.com Inc.
Lowe’s Cos. Inc.
TJX Cos. Inc.

Based on: 10-K (reporting date: 2024-01-28), 10-K (reporting date: 2023-01-29), 10-K (reporting date: 2022-01-30), 10-K (reporting date: 2021-01-31), 10-K (reporting date: 2020-02-02), 10-K (reporting date: 2019-02-03).

1 Invested capital. See details »

2 2024 Calculation
TO = Adjusted net sales ÷ Invested capital
= ÷ =

3 Click competitor name to see calculations.

Efficiency ratio Description The company
TO The turnover of capital (TO) is the ratio of sales to invested capital. Capital turnover is a function of the efficiency of working capital management and of net fixed assets. Home Depot Inc. TO deteriorated from 2022 to 2023 and from 2023 to 2024.

Effective Cash Tax Rate (CTR)

Home Depot Inc., CTR calculation, comparison to benchmarks

Microsoft Excel
Jan 28, 2024 Jan 29, 2023 Jan 30, 2022 Jan 31, 2021 Feb 2, 2020 Feb 3, 2019
Selected Financial Data (US$ in millions)
Net operating profit after taxes (NOPAT)1
Add: Cash operating taxes2
Net operating profit before taxes (NOPBT)
Tax Rate
CTR3
Benchmarks
CTR, Competitors4
Amazon.com Inc.
Lowe’s Cos. Inc.
TJX Cos. Inc.

Based on: 10-K (reporting date: 2024-01-28), 10-K (reporting date: 2023-01-29), 10-K (reporting date: 2022-01-30), 10-K (reporting date: 2021-01-31), 10-K (reporting date: 2020-02-02), 10-K (reporting date: 2019-02-03).

1 NOPAT. See details »

2 Cash operating taxes. See details »

3 2024 Calculation
CTR = 100 × Cash operating taxes ÷ NOPBT
= 100 × ÷ =

4 Click competitor name to see calculations.

Tax rate Description The company
CTR Effective cash tax rate on operating income. Home Depot Inc. CTR decreased from 2022 to 2023 but then increased from 2023 to 2024 exceeding 2022 level.