Stock Analysis on Net

Target Corp. (NYSE:TGT)

デュポンの分析: ROE、ROA、純利益率の内訳 
四半期データ

Microsoft Excel

ROEを2つのコンポーネントに分解

Target Corp.、 ROE の分解(四半期データ)

Microsoft Excel
ROE = ROA × 財務レバレッジ比率
2025/02/01 27.89% = 7.08% × 3.94
2024/11/02 30.16% = 7.47% × 4.04
2024/08/03 31.10% = 8.01% × 3.88
2024/05/04 29.84% = 7.49% × 3.98
2024/02/03 30.81% = 7.48% × 4.12
2023/10/28 29.02% = 6.46% × 4.49
2023/07/29 28.13% = 6.34% × 4.44
2023/04/29 23.45% = 5.22% × 4.49
2023/01/28 24.75% = 5.21% × 4.75
2022/10/29 31.29% = 6.20% × 5.05
2022/07/30 39.88% = 8.05% × 4.95
2022/04/30 54.37% = 11.52% × 4.72
2022/01/29 54.15% = 12.91% × 4.20
2021/10/30 49.13% = 12.46% × 3.94
2021/07/31 42.45% = 12.28% × 3.46
2021/05/01 41.32% = 12.25% × 3.37
2021/01/30 30.25% = 8.52% × 3.55
2020/10/31 28.70% = 7.54% × 3.80
2020/08/01 28.00% = 7.34% × 3.82
2020/05/02 24.80% = 6.18% × 4.01
2020/02/01 27.73% = 7.67% × 3.62
2019/11/02 = × 3.79
2019/08/03 = × 3.51
2019/05/04 = × 3.65

レポートに基づく: 10-K (報告日: 2025-02-01), 10-Q (報告日: 2024-11-02), 10-Q (報告日: 2024-08-03), 10-Q (報告日: 2024-05-04), 10-K (報告日: 2024-02-03), 10-Q (報告日: 2023-10-28), 10-Q (報告日: 2023-07-29), 10-Q (報告日: 2023-04-29), 10-K (報告日: 2023-01-28), 10-Q (報告日: 2022-10-29), 10-Q (報告日: 2022-07-30), 10-Q (報告日: 2022-04-30), 10-K (報告日: 2022-01-29), 10-Q (報告日: 2021-10-30), 10-Q (報告日: 2021-07-31), 10-Q (報告日: 2021-05-01), 10-K (報告日: 2021-01-30), 10-Q (報告日: 2020-10-31), 10-Q (報告日: 2020-08-01), 10-Q (報告日: 2020-05-02), 10-K (報告日: 2020-02-01), 10-Q (報告日: 2019-11-02), 10-Q (報告日: 2019-08-03), 10-Q (報告日: 2019-05-04).

2025年第4 四半期に株主資本利益率(ROE)が低下した主な理由は、総資産利益率(ROA)で測定した収益性の低下です。


ROEを3つの要素に分解

Target Corp.、 ROE の分解(四半期データ)

Microsoft Excel
ROE = 純利益率 × 資産回転率 × 財務レバレッジ比率
2025/02/01 27.89% = 3.84% × 1.84 × 3.94
2024/11/02 30.16% = 4.06% × 1.84 × 4.04
2024/08/03 31.10% = 4.18% × 1.92 × 3.88
2024/05/04 29.84% = 3.87% × 1.93 × 3.98
2024/02/03 30.81% = 3.85% × 1.94 × 4.12
2023/10/28 29.02% = 3.40% × 1.90 × 4.49
2023/07/29 28.13% = 3.12% × 2.03 × 4.44
2023/04/29 23.45% = 2.49% × 2.10 × 4.49
2023/01/28 24.75% = 2.55% × 2.05 × 4.75
2022/10/29 31.29% = 3.17% × 1.95 × 5.05
2022/07/30 39.88% = 3.92% × 2.06 × 4.95
2022/04/30 54.37% = 5.48% × 2.10 × 4.72
2022/01/29 54.15% = 6.55% × 1.97 × 4.20
2021/10/30 49.13% = 6.56% × 1.90 × 3.94
2021/07/31 42.45% = 6.29% × 1.95 × 3.46
2021/05/01 41.32% = 6.30% × 1.94 × 3.37
2021/01/30 30.25% = 4.67% × 1.83 × 3.55
2020/10/31 28.70% = 4.31% × 1.75 × 3.80
2020/08/01 28.00% = 4.16% × 1.76 × 3.82
2020/05/02 24.80% = 3.46% × 1.79 × 4.01
2020/02/01 27.73% = 4.20% × 1.83 × 3.62
2019/11/02 = × × 3.79
2019/08/03 = × × 3.51
2019/05/04 = × × 3.65

レポートに基づく: 10-K (報告日: 2025-02-01), 10-Q (報告日: 2024-11-02), 10-Q (報告日: 2024-08-03), 10-Q (報告日: 2024-05-04), 10-K (報告日: 2024-02-03), 10-Q (報告日: 2023-10-28), 10-Q (報告日: 2023-07-29), 10-Q (報告日: 2023-04-29), 10-K (報告日: 2023-01-28), 10-Q (報告日: 2022-10-29), 10-Q (報告日: 2022-07-30), 10-Q (報告日: 2022-04-30), 10-K (報告日: 2022-01-29), 10-Q (報告日: 2021-10-30), 10-Q (報告日: 2021-07-31), 10-Q (報告日: 2021-05-01), 10-K (報告日: 2021-01-30), 10-Q (報告日: 2020-10-31), 10-Q (報告日: 2020-08-01), 10-Q (報告日: 2020-05-02), 10-K (報告日: 2020-02-01), 10-Q (報告日: 2019-11-02), 10-Q (報告日: 2019-08-03), 10-Q (報告日: 2019-05-04).

2025年第4 四半期に株主資本利益率(ROE)が低下した主な理由は、純利益率で測定した収益性の低下です。


ROEを5つの要素に分解

Target Corp.、 ROE の分解(四半期データ)

Microsoft Excel
ROE = 税負担 × 利息負担 × EBITマージン × 資産回転率 × 財務レバレッジ比率
2025/02/01 27.89% = 0.78 × 0.93 × 5.32% × 1.84 × 3.94
2024/11/02 30.16% = 0.77 × 0.93 × 5.64% × 1.84 × 4.04
2024/08/03 31.10% = 0.78 × 0.93 × 5.79% × 1.92 × 3.88
2024/05/04 29.84% = 0.78 × 0.92 × 5.41% × 1.93 × 3.98
2024/02/03 30.81% = 0.78 × 0.91 × 5.40% × 1.94 × 4.12
2023/10/28 29.02% = 0.80 × 0.90 × 4.75% × 1.90 × 4.49
2023/07/29 28.13% = 0.80 × 0.89 × 4.42% × 2.03 × 4.44
2023/04/29 23.45% = 0.81 × 0.87 × 3.56% × 2.10 × 4.49
2023/01/28 24.75% = 0.81 × 0.88 × 3.57% × 2.05 × 4.75
2022/10/29 31.29% = 0.79 × 0.91 × 4.46% × 1.95 × 5.05
2022/07/30 39.88% = 0.78 × 0.93 × 5.40% × 2.06 × 4.95
2022/04/30 54.37% = 0.78 × 0.95 × 7.45% × 2.10 × 4.72
2022/01/29 54.15% = 0.78 × 0.95 × 8.80% × 1.97 × 4.20
2021/10/30 49.13% = 0.79 × 0.95 × 8.75% × 1.90 × 3.94
2021/07/31 42.45% = 0.79 × 0.89 × 8.93% × 1.95 × 3.46
2021/05/01 41.32% = 0.79 × 0.89 × 8.96% × 1.94 × 3.37
2021/01/30 30.25% = 0.79 × 0.85 × 6.97% × 1.83 × 3.55
2020/10/31 28.70% = 0.79 × 0.83 × 6.61% × 1.75 × 3.80
2020/08/01 28.00% = 0.79 × 0.91 × 5.85% × 1.76 × 3.82
2020/05/02 24.80% = 0.79 × 0.88 × 4.96% × 1.79 × 4.01
2020/02/01 27.73% = 0.78 × 0.90 × 5.99% × 1.83 × 3.62
2019/11/02 = × × × × 3.79
2019/08/03 = × × × × 3.51
2019/05/04 = × × × × 3.65

レポートに基づく: 10-K (報告日: 2025-02-01), 10-Q (報告日: 2024-11-02), 10-Q (報告日: 2024-08-03), 10-Q (報告日: 2024-05-04), 10-K (報告日: 2024-02-03), 10-Q (報告日: 2023-10-28), 10-Q (報告日: 2023-07-29), 10-Q (報告日: 2023-04-29), 10-K (報告日: 2023-01-28), 10-Q (報告日: 2022-10-29), 10-Q (報告日: 2022-07-30), 10-Q (報告日: 2022-04-30), 10-K (報告日: 2022-01-29), 10-Q (報告日: 2021-10-30), 10-Q (報告日: 2021-07-31), 10-Q (報告日: 2021-05-01), 10-K (報告日: 2021-01-30), 10-Q (報告日: 2020-10-31), 10-Q (報告日: 2020-08-01), 10-Q (報告日: 2020-05-02), 10-K (報告日: 2020-02-01), 10-Q (報告日: 2019-11-02), 10-Q (報告日: 2019-08-03), 10-Q (報告日: 2019-05-04).

2025年第4 四半期に株主資本利益率(ROE)が低下した主な理由は、EBITマージン率で測定した営業利益率の低下です。


ROAを2つのコンポーネントに分解

Target Corp.、 ROA の分解(四半期データ)

Microsoft Excel
ROA = 純利益率 × 資産回転率
2025/02/01 7.08% = 3.84% × 1.84
2024/11/02 7.47% = 4.06% × 1.84
2024/08/03 8.01% = 4.18% × 1.92
2024/05/04 7.49% = 3.87% × 1.93
2024/02/03 7.48% = 3.85% × 1.94
2023/10/28 6.46% = 3.40% × 1.90
2023/07/29 6.34% = 3.12% × 2.03
2023/04/29 5.22% = 2.49% × 2.10
2023/01/28 5.21% = 2.55% × 2.05
2022/10/29 6.20% = 3.17% × 1.95
2022/07/30 8.05% = 3.92% × 2.06
2022/04/30 11.52% = 5.48% × 2.10
2022/01/29 12.91% = 6.55% × 1.97
2021/10/30 12.46% = 6.56% × 1.90
2021/07/31 12.28% = 6.29% × 1.95
2021/05/01 12.25% = 6.30% × 1.94
2021/01/30 8.52% = 4.67% × 1.83
2020/10/31 7.54% = 4.31% × 1.75
2020/08/01 7.34% = 4.16% × 1.76
2020/05/02 6.18% = 3.46% × 1.79
2020/02/01 7.67% = 4.20% × 1.83
2019/11/02 = ×
2019/08/03 = ×
2019/05/04 = ×

レポートに基づく: 10-K (報告日: 2025-02-01), 10-Q (報告日: 2024-11-02), 10-Q (報告日: 2024-08-03), 10-Q (報告日: 2024-05-04), 10-K (報告日: 2024-02-03), 10-Q (報告日: 2023-10-28), 10-Q (報告日: 2023-07-29), 10-Q (報告日: 2023-04-29), 10-K (報告日: 2023-01-28), 10-Q (報告日: 2022-10-29), 10-Q (報告日: 2022-07-30), 10-Q (報告日: 2022-04-30), 10-K (報告日: 2022-01-29), 10-Q (報告日: 2021-10-30), 10-Q (報告日: 2021-07-31), 10-Q (報告日: 2021-05-01), 10-K (報告日: 2021-01-30), 10-Q (報告日: 2020-10-31), 10-Q (報告日: 2020-08-01), 10-Q (報告日: 2020-05-02), 10-K (報告日: 2020-02-01), 10-Q (報告日: 2019-11-02), 10-Q (報告日: 2019-08-03), 10-Q (報告日: 2019-05-04).

2025年第4 四半期に総資産利益率(ROA)が低下した主な理由は、純利益率で測定した収益性の低下です。


ROAを4つの要素に分解

Target Corp.、 ROA の分解(四半期データ)

Microsoft Excel
ROA = 税負担 × 利息負担 × EBITマージン × 資産回転率
2025/02/01 7.08% = 0.78 × 0.93 × 5.32% × 1.84
2024/11/02 7.47% = 0.77 × 0.93 × 5.64% × 1.84
2024/08/03 8.01% = 0.78 × 0.93 × 5.79% × 1.92
2024/05/04 7.49% = 0.78 × 0.92 × 5.41% × 1.93
2024/02/03 7.48% = 0.78 × 0.91 × 5.40% × 1.94
2023/10/28 6.46% = 0.80 × 0.90 × 4.75% × 1.90
2023/07/29 6.34% = 0.80 × 0.89 × 4.42% × 2.03
2023/04/29 5.22% = 0.81 × 0.87 × 3.56% × 2.10
2023/01/28 5.21% = 0.81 × 0.88 × 3.57% × 2.05
2022/10/29 6.20% = 0.79 × 0.91 × 4.46% × 1.95
2022/07/30 8.05% = 0.78 × 0.93 × 5.40% × 2.06
2022/04/30 11.52% = 0.78 × 0.95 × 7.45% × 2.10
2022/01/29 12.91% = 0.78 × 0.95 × 8.80% × 1.97
2021/10/30 12.46% = 0.79 × 0.95 × 8.75% × 1.90
2021/07/31 12.28% = 0.79 × 0.89 × 8.93% × 1.95
2021/05/01 12.25% = 0.79 × 0.89 × 8.96% × 1.94
2021/01/30 8.52% = 0.79 × 0.85 × 6.97% × 1.83
2020/10/31 7.54% = 0.79 × 0.83 × 6.61% × 1.75
2020/08/01 7.34% = 0.79 × 0.91 × 5.85% × 1.76
2020/05/02 6.18% = 0.79 × 0.88 × 4.96% × 1.79
2020/02/01 7.67% = 0.78 × 0.90 × 5.99% × 1.83
2019/11/02 = × × ×
2019/08/03 = × × ×
2019/05/04 = × × ×

レポートに基づく: 10-K (報告日: 2025-02-01), 10-Q (報告日: 2024-11-02), 10-Q (報告日: 2024-08-03), 10-Q (報告日: 2024-05-04), 10-K (報告日: 2024-02-03), 10-Q (報告日: 2023-10-28), 10-Q (報告日: 2023-07-29), 10-Q (報告日: 2023-04-29), 10-K (報告日: 2023-01-28), 10-Q (報告日: 2022-10-29), 10-Q (報告日: 2022-07-30), 10-Q (報告日: 2022-04-30), 10-K (報告日: 2022-01-29), 10-Q (報告日: 2021-10-30), 10-Q (報告日: 2021-07-31), 10-Q (報告日: 2021-05-01), 10-K (報告日: 2021-01-30), 10-Q (報告日: 2020-10-31), 10-Q (報告日: 2020-08-01), 10-Q (報告日: 2020-05-02), 10-K (報告日: 2020-02-01), 10-Q (報告日: 2019-11-02), 10-Q (報告日: 2019-08-03), 10-Q (報告日: 2019-05-04).

2025年第4 四半期に総資産利益率(ROA)が低下した主な理由は、EBITマージン率で測定した営業利益率の低下です。


当期純利益率の分解

Target Corp.、純利益率の分解(四半期データ)

Microsoft Excel
純利益率 = 税負担 × 利息負担 × EBITマージン
2025/02/01 3.84% = 0.78 × 0.93 × 5.32%
2024/11/02 4.06% = 0.77 × 0.93 × 5.64%
2024/08/03 4.18% = 0.78 × 0.93 × 5.79%
2024/05/04 3.87% = 0.78 × 0.92 × 5.41%
2024/02/03 3.85% = 0.78 × 0.91 × 5.40%
2023/10/28 3.40% = 0.80 × 0.90 × 4.75%
2023/07/29 3.12% = 0.80 × 0.89 × 4.42%
2023/04/29 2.49% = 0.81 × 0.87 × 3.56%
2023/01/28 2.55% = 0.81 × 0.88 × 3.57%
2022/10/29 3.17% = 0.79 × 0.91 × 4.46%
2022/07/30 3.92% = 0.78 × 0.93 × 5.40%
2022/04/30 5.48% = 0.78 × 0.95 × 7.45%
2022/01/29 6.55% = 0.78 × 0.95 × 8.80%
2021/10/30 6.56% = 0.79 × 0.95 × 8.75%
2021/07/31 6.29% = 0.79 × 0.89 × 8.93%
2021/05/01 6.30% = 0.79 × 0.89 × 8.96%
2021/01/30 4.67% = 0.79 × 0.85 × 6.97%
2020/10/31 4.31% = 0.79 × 0.83 × 6.61%
2020/08/01 4.16% = 0.79 × 0.91 × 5.85%
2020/05/02 3.46% = 0.79 × 0.88 × 4.96%
2020/02/01 4.20% = 0.78 × 0.90 × 5.99%
2019/11/02 = × ×
2019/08/03 = × ×
2019/05/04 = × ×

レポートに基づく: 10-K (報告日: 2025-02-01), 10-Q (報告日: 2024-11-02), 10-Q (報告日: 2024-08-03), 10-Q (報告日: 2024-05-04), 10-K (報告日: 2024-02-03), 10-Q (報告日: 2023-10-28), 10-Q (報告日: 2023-07-29), 10-Q (報告日: 2023-04-29), 10-K (報告日: 2023-01-28), 10-Q (報告日: 2022-10-29), 10-Q (報告日: 2022-07-30), 10-Q (報告日: 2022-04-30), 10-K (報告日: 2022-01-29), 10-Q (報告日: 2021-10-30), 10-Q (報告日: 2021-07-31), 10-Q (報告日: 2021-05-01), 10-K (報告日: 2021-01-30), 10-Q (報告日: 2020-10-31), 10-Q (報告日: 2020-08-01), 10-Q (報告日: 2020-05-02), 10-K (報告日: 2020-02-01), 10-Q (報告日: 2019-11-02), 10-Q (報告日: 2019-08-03), 10-Q (報告日: 2019-05-04).

2025年第4 四半期から純利益率が低下した主な理由は、EBITマージン率で測定した営業利益率の低下です。