Stock Analysis on Net

Target Corp. (NYSE:TGT)

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.


Return on Invested Capital (ROIC)

Target Corp., ROIC calculation, comparison to benchmarks

Microsoft Excel
Feb 3, 2024 Jan 28, 2023 Jan 29, 2022 Jan 30, 2021 Feb 1, 2020 Feb 2, 2019
Selected Financial Data (US$ in millions)
Net operating profit after taxes (NOPAT)1 4,953 3,821 7,872 5,024 3,896 3,683
Invested capital2 34,307 30,226 30,151 30,495 27,256 26,047
Performance Ratio
ROIC3 14.44% 12.64% 26.11% 16.47% 14.30% 14.14%
Benchmarks
ROIC, Competitors4
Costco Wholesale Corp. 16.31% 20.27% 18.56% 14.65% 16.61%
Walmart Inc. 11.92% 9.28% 9.80% 11.03% 10.88% 5.72%

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

1 NOPAT. See details »

2 Invested capital. See details »

3 2024 Calculation
ROIC = 100 × NOPAT ÷ Invested capital
= 100 × 4,953 ÷ 34,307 = 14.44%

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. Target Corp. ROIC deteriorated from 2022 to 2023 but then slightly improved from 2023 to 2024.

Decomposition of ROIC

Target Corp., decomposition of ROIC

Microsoft Excel
ROIC = OPM1 × TO2 × 1 – CTR3
Feb 3, 2024 14.44% = 5.62% × 3.08 × 83.22%
Jan 28, 2023 12.64% = 3.72% × 3.56 × 95.55%
Jan 29, 2022 26.11% = 9.00% × 3.47 × 83.58%
Jan 30, 2021 16.47% = 7.15% × 3.03 × 76.01%
Feb 1, 2020 14.30% = 6.17% × 2.83 × 81.88%
Feb 2, 2019 14.14% = 5.67% × 2.86 × 87.24%

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

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 increase in return on invested capital (ROIC) over 2024 year is the increase in profitability measured by operating profit margin (OPM) ratio.


Operating Profit Margin (OPM)

Target Corp., OPM calculation, comparison to benchmarks

Microsoft Excel
Feb 3, 2024 Jan 28, 2023 Jan 29, 2022 Jan 30, 2021 Feb 1, 2020 Feb 2, 2019
Selected Financial Data (US$ in millions)
Net operating profit after taxes (NOPAT)1 4,953 3,821 7,872 5,024 3,896 3,683
Add: Cash operating taxes2 998 178 1,546 1,585 862 539
Net operating profit before taxes (NOPBT) 5,951 3,999 9,418 6,609 4,759 4,222
 
Sales 105,803 107,588 104,611 92,400 77,130 74,433
Profitability Ratio
OPM3 5.62% 3.72% 9.00% 7.15% 6.17% 5.67%
Benchmarks
OPM, Competitors4
Costco Wholesale Corp. 3.28% 3.79% 3.58% 3.37% 3.30%
Walmart Inc. 3.88% 3.26% 3.77% 4.26% 4.52% 2.84%

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

1 NOPAT. See details »

2 Cash operating taxes. See details »

3 2024 Calculation
OPM = 100 × NOPBT ÷ Sales
= 100 × 5,951 ÷ 105,803 = 5.62%

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. Target Corp. OPM deteriorated from 2022 to 2023 but then slightly improved from 2023 to 2024.

Turnover of Capital (TO)

Target Corp., TO calculation, comparison to benchmarks

Microsoft Excel
Feb 3, 2024 Jan 28, 2023 Jan 29, 2022 Jan 30, 2021 Feb 1, 2020 Feb 2, 2019
Selected Financial Data (US$ in millions)
Sales 105,803 107,588 104,611 92,400 77,130 74,433
Invested capital1 34,307 30,226 30,151 30,495 27,256 26,047
Efficiency Ratio
TO2 3.08 3.56 3.47 3.03 2.83 2.86
Benchmarks
TO, Competitors3
Costco Wholesale Corp. 6.81 7.03 6.74 5.62 6.23
Walmart Inc. 4.14 4.05 3.63 3.38 3.11 3.21

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

1 Invested capital. See details »

2 2024 Calculation
TO = Sales ÷ Invested capital
= 105,803 ÷ 34,307 = 3.08

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. Target Corp. TO improved from 2022 to 2023 but then deteriorated significantly from 2023 to 2024.

Effective Cash Tax Rate (CTR)

Target Corp., CTR calculation, comparison to benchmarks

Microsoft Excel
Feb 3, 2024 Jan 28, 2023 Jan 29, 2022 Jan 30, 2021 Feb 1, 2020 Feb 2, 2019
Selected Financial Data (US$ in millions)
Net operating profit after taxes (NOPAT)1 4,953 3,821 7,872 5,024 3,896 3,683
Add: Cash operating taxes2 998 178 1,546 1,585 862 539
Net operating profit before taxes (NOPBT) 5,951 3,999 9,418 6,609 4,759 4,222
Tax Rate
CTR3 16.78% 4.45% 16.42% 23.99% 18.12% 12.76%
Benchmarks
CTR, Competitors4
Costco Wholesale Corp. 27.04% 23.89% 23.00% 22.65% 19.18%
Walmart Inc. 25.66% 29.71% 28.43% 23.29% 22.54% 37.20%

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

1 NOPAT. See details »

2 Cash operating taxes. See details »

3 2024 Calculation
CTR = 100 × Cash operating taxes ÷ NOPBT
= 100 × 998 ÷ 5,951 = 16.78%

4 Click competitor name to see calculations.

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