Stock Analysis on Net

Dollar Tree Inc. (NASDAQ:DLTR)

この会社は アーカイブに移されました! 財務データは2022年11月22日以降更新されていません。

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

Microsoft Excel

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

Dollar Tree Inc.、 ROE の分解(四半期データ)

Microsoft Excel
ROE = ROA × 財務レバレッジ比率
2022/10/29 19.54% = 7.06% × 2.77
2022/07/30 18.67% = 6.91% × 2.70
2022/04/30 18.08% = 6.66% × 2.71
2022/01/29 17.20% = 6.11% × 2.81
2021/10/30 19.00% = 6.44% × 2.95
2021/07/31 21.25% = 7.29% × 2.92
2021/05/01 19.82% = 6.98% × 2.84
2021/01/30 18.42% = 6.48% × 2.84
2020/10/31 13.82% = 4.66% × 2.97
2020/08/01 13.03% = 4.30% × 3.03
2020/05/02 12.37% = 3.94% × 3.14
2020/02/01 13.22% = 4.22% × 3.13
2019/11/02 -26.19% = -8.12% × 3.23
2019/08/03 -26.89% = -8.09% × 3.32
2019/05/04 -25.77% = -7.66% × 3.36
2019/02/02 -28.19% = -11.78% × 2.39
2018/11/03 22.11% = 10.55% × 2.10
2018/08/04 22.42% = 10.65% × 2.11
2018/05/05 22.76% = 10.58% × 2.15
2018/02/03 23.87% = 10.50% × 2.27
2017/10/28 16.28% = 6.33% × 2.57
2017/07/29 15.83% = 5.97% × 2.65
2017/04/29 15.40% = 5.40% × 2.85
2017/01/28 16.63% = 5.71% × 2.91
2016/10/29 = × 3.21
2016/07/30 = × 3.36
2016/04/30 = × 3.44

レポートに基づく: 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), 10-K (報告日: 2019-02-02), 10-Q (報告日: 2018-11-03), 10-Q (報告日: 2018-08-04), 10-Q (報告日: 2018-05-05), 10-K (報告日: 2018-02-03), 10-Q (報告日: 2017-10-28), 10-Q (報告日: 2017-07-29), 10-Q (報告日: 2017-04-29), 10-K (報告日: 2017-01-28), 10-Q (報告日: 2016-10-29), 10-Q (報告日: 2016-07-30), 10-Q (報告日: 2016-04-30).

2023年第3 四半期の株主資本利益率(ROE)が上昇した主な理由は、財務レバレッジ比率の上昇です。


ROEを3つの要素に分解

Dollar Tree Inc.、 ROE の分解(四半期データ)

Microsoft Excel
ROE = 純利益率 × 資産回転率 × 財務レバレッジ比率
2022/10/29 19.54% = 5.84% × 1.21 × 2.77
2022/07/30 18.67% = 5.77% × 1.20 × 2.70
2022/04/30 18.08% = 5.57% × 1.19 × 2.71
2022/01/29 17.20% = 5.05% × 1.21 × 2.81
2021/10/30 19.00% = 5.29% × 1.22 × 2.95
2021/07/31 21.25% = 5.78% × 1.26 × 2.92
2021/05/01 19.82% = 5.72% × 1.22 × 2.84
2021/01/30 18.42% = 5.26% × 1.23 × 2.84
2020/10/31 13.82% = 3.84% × 1.21 × 2.97
2020/08/01 13.03% = 3.61% × 1.19 × 3.03
2020/05/02 12.37% = 3.35% × 1.18 × 3.14
2020/02/01 13.22% = 3.50% × 1.21 × 3.13
2019/11/02 -26.19% = -6.82% × 1.19 × 3.23
2019/08/03 -26.89% = -6.77% × 1.19 × 3.32
2019/05/04 -25.77% = -6.43% × 1.19 × 3.36
2019/02/02 -28.19% = -6.97% × 1.69 × 2.39
2018/11/03 22.11% = 7.64% × 1.38 × 2.10
2018/08/04 22.42% = 7.53% × 1.41 × 2.11
2018/05/05 22.76% = 7.44% × 1.42 × 2.15
2018/02/03 23.87% = 7.71% × 1.36 × 2.27
2017/10/28 16.28% = 4.63% × 1.37 × 2.57
2017/07/29 15.83% = 4.37% × 1.37 × 2.65
2017/04/29 15.40% = 4.13% × 1.31 × 2.85
2017/01/28 16.63% = 4.33% × 1.32 × 2.91
2016/10/29 = × × 3.21
2016/07/30 = × × 3.36
2016/04/30 = × × 3.44

レポートに基づく: 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), 10-K (報告日: 2019-02-02), 10-Q (報告日: 2018-11-03), 10-Q (報告日: 2018-08-04), 10-Q (報告日: 2018-05-05), 10-K (報告日: 2018-02-03), 10-Q (報告日: 2017-10-28), 10-Q (報告日: 2017-07-29), 10-Q (報告日: 2017-04-29), 10-K (報告日: 2017-01-28), 10-Q (報告日: 2016-10-29), 10-Q (報告日: 2016-07-30), 10-Q (報告日: 2016-04-30).

2023年第3 四半期の株主資本利益率(ROE)が上昇した主な理由は、財務レバレッジ比率の上昇です。


ROEを5つの要素に分解

Dollar Tree Inc.、 ROE の分解(四半期データ)

Microsoft Excel
ROE = 税負担 × 利息負担 × EBITマージン × 資産回転率 × 財務レバレッジ比率
2022/10/29 19.54% = 0.80 × 0.92 × 7.94% × 1.21 × 2.77
2022/07/30 18.67% = 0.80 × 0.92 × 7.83% × 1.20 × 2.70
2022/04/30 18.08% = 0.81 × 0.91 × 7.57% × 1.19 × 2.71
2022/01/29 17.20% = 0.81 × 0.90 × 6.88% × 1.21 × 2.81
2021/10/30 19.00% = 0.77 × 0.93 × 7.36% × 1.22 × 2.95
2021/07/31 21.25% = 0.77 × 0.93 × 8.03% × 1.26 × 2.92
2021/05/01 19.82% = 0.77 × 0.93 × 7.94% × 1.22 × 2.84
2021/01/30 18.42% = 0.77 × 0.92 × 7.40% × 1.23 × 2.84
2020/10/31 13.82% = 0.74 × 0.90 × 5.80% × 1.21 × 2.97
2020/08/01 13.03% = 0.75 × 0.88 × 5.47% × 1.19 × 3.03
2020/05/02 12.37% = 0.75 × 0.87 × 5.15% × 1.18 × 3.14
2020/02/01 13.22% = 0.75 × 0.87 × 5.34% × 1.21 × 3.13
2019/11/02 -26.19% = × × -4.83% × 1.19 × 3.23
2019/08/03 -26.89% = × × -4.75% × 1.19 × 3.32
2019/05/04 -25.77% = × × -4.29% × 1.19 × 3.36
2019/02/02 -28.19% = × × -4.11% × 1.69 × 2.39
2018/11/03 22.11% = 1.11 × 0.80 × 8.62% × 1.38 × 2.10
2018/08/04 22.42% = 1.08 × 0.79 × 8.87% × 1.41 × 2.11
2018/05/05 22.76% = 1.05 × 0.78 × 9.13% × 1.42 × 2.15
2018/02/03 23.87% = 1.01 × 0.85 × 9.02% × 1.36 × 2.27
2017/10/28 16.28% = 0.66 × 0.83 × 8.45% × 1.37 × 2.57
2017/07/29 15.83% = 0.67 × 0.80 × 8.19% × 1.37 × 2.65
2017/04/29 15.40% = 0.66 × 0.78 × 8.00% × 1.31 × 2.85
2017/01/28 16.63% = 0.67 × 0.78 × 8.23% × 1.32 × 2.91
2016/10/29 = × × × × 3.21
2016/07/30 = × × × × 3.36
2016/04/30 = × × × × 3.44

レポートに基づく: 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), 10-K (報告日: 2019-02-02), 10-Q (報告日: 2018-11-03), 10-Q (報告日: 2018-08-04), 10-Q (報告日: 2018-05-05), 10-K (報告日: 2018-02-03), 10-Q (報告日: 2017-10-28), 10-Q (報告日: 2017-07-29), 10-Q (報告日: 2017-04-29), 10-K (報告日: 2017-01-28), 10-Q (報告日: 2016-10-29), 10-Q (報告日: 2016-07-30), 10-Q (報告日: 2016-04-30).

2023年第3 四半期の株主資本利益率(ROE)が上昇した主な理由は、財務レバレッジ比率の上昇です。


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

Dollar Tree Inc.、 ROA の分解(四半期データ)

Microsoft Excel
ROA = 純利益率 × 資産回転率
2022/10/29 7.06% = 5.84% × 1.21
2022/07/30 6.91% = 5.77% × 1.20
2022/04/30 6.66% = 5.57% × 1.19
2022/01/29 6.11% = 5.05% × 1.21
2021/10/30 6.44% = 5.29% × 1.22
2021/07/31 7.29% = 5.78% × 1.26
2021/05/01 6.98% = 5.72% × 1.22
2021/01/30 6.48% = 5.26% × 1.23
2020/10/31 4.66% = 3.84% × 1.21
2020/08/01 4.30% = 3.61% × 1.19
2020/05/02 3.94% = 3.35% × 1.18
2020/02/01 4.22% = 3.50% × 1.21
2019/11/02 -8.12% = -6.82% × 1.19
2019/08/03 -8.09% = -6.77% × 1.19
2019/05/04 -7.66% = -6.43% × 1.19
2019/02/02 -11.78% = -6.97% × 1.69
2018/11/03 10.55% = 7.64% × 1.38
2018/08/04 10.65% = 7.53% × 1.41
2018/05/05 10.58% = 7.44% × 1.42
2018/02/03 10.50% = 7.71% × 1.36
2017/10/28 6.33% = 4.63% × 1.37
2017/07/29 5.97% = 4.37% × 1.37
2017/04/29 5.40% = 4.13% × 1.31
2017/01/28 5.71% = 4.33% × 1.32
2016/10/29 = ×
2016/07/30 = ×
2016/04/30 = ×

レポートに基づく: 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), 10-K (報告日: 2019-02-02), 10-Q (報告日: 2018-11-03), 10-Q (報告日: 2018-08-04), 10-Q (報告日: 2018-05-05), 10-K (報告日: 2018-02-03), 10-Q (報告日: 2017-10-28), 10-Q (報告日: 2017-07-29), 10-Q (報告日: 2017-04-29), 10-K (報告日: 2017-01-28), 10-Q (報告日: 2016-10-29), 10-Q (報告日: 2016-07-30), 10-Q (報告日: 2016-04-30).

2023年第3 四半期の総資産利益率(ROA)が上昇した主な理由は、純利益率で測定した収益性の向上です。


ROAを4つの要素に分解

Dollar Tree Inc.、 ROA の分解(四半期データ)

Microsoft Excel
ROA = 税負担 × 利息負担 × EBITマージン × 資産回転率
2022/10/29 7.06% = 0.80 × 0.92 × 7.94% × 1.21
2022/07/30 6.91% = 0.80 × 0.92 × 7.83% × 1.20
2022/04/30 6.66% = 0.81 × 0.91 × 7.57% × 1.19
2022/01/29 6.11% = 0.81 × 0.90 × 6.88% × 1.21
2021/10/30 6.44% = 0.77 × 0.93 × 7.36% × 1.22
2021/07/31 7.29% = 0.77 × 0.93 × 8.03% × 1.26
2021/05/01 6.98% = 0.77 × 0.93 × 7.94% × 1.22
2021/01/30 6.48% = 0.77 × 0.92 × 7.40% × 1.23
2020/10/31 4.66% = 0.74 × 0.90 × 5.80% × 1.21
2020/08/01 4.30% = 0.75 × 0.88 × 5.47% × 1.19
2020/05/02 3.94% = 0.75 × 0.87 × 5.15% × 1.18
2020/02/01 4.22% = 0.75 × 0.87 × 5.34% × 1.21
2019/11/02 -8.12% = × × -4.83% × 1.19
2019/08/03 -8.09% = × × -4.75% × 1.19
2019/05/04 -7.66% = × × -4.29% × 1.19
2019/02/02 -11.78% = × × -4.11% × 1.69
2018/11/03 10.55% = 1.11 × 0.80 × 8.62% × 1.38
2018/08/04 10.65% = 1.08 × 0.79 × 8.87% × 1.41
2018/05/05 10.58% = 1.05 × 0.78 × 9.13% × 1.42
2018/02/03 10.50% = 1.01 × 0.85 × 9.02% × 1.36
2017/10/28 6.33% = 0.66 × 0.83 × 8.45% × 1.37
2017/07/29 5.97% = 0.67 × 0.80 × 8.19% × 1.37
2017/04/29 5.40% = 0.66 × 0.78 × 8.00% × 1.31
2017/01/28 5.71% = 0.67 × 0.78 × 8.23% × 1.32
2016/10/29 = × × ×
2016/07/30 = × × ×
2016/04/30 = × × ×

レポートに基づく: 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), 10-K (報告日: 2019-02-02), 10-Q (報告日: 2018-11-03), 10-Q (報告日: 2018-08-04), 10-Q (報告日: 2018-05-05), 10-K (報告日: 2018-02-03), 10-Q (報告日: 2017-10-28), 10-Q (報告日: 2017-07-29), 10-Q (報告日: 2017-04-29), 10-K (報告日: 2017-01-28), 10-Q (報告日: 2016-10-29), 10-Q (報告日: 2016-07-30), 10-Q (報告日: 2016-04-30).

2023年第3 四半期の総資産利益率(ROA)が上昇した主な理由は、EBITマージン率で測定した営業利益率の増加です。


純利益率の分解

Dollar Tree Inc.、純利益率の分解(四半期データ)

Microsoft Excel
純利益率 = 税負担 × 利息負担 × EBITマージン
2022/10/29 5.84% = 0.80 × 0.92 × 7.94%
2022/07/30 5.77% = 0.80 × 0.92 × 7.83%
2022/04/30 5.57% = 0.81 × 0.91 × 7.57%
2022/01/29 5.05% = 0.81 × 0.90 × 6.88%
2021/10/30 5.29% = 0.77 × 0.93 × 7.36%
2021/07/31 5.78% = 0.77 × 0.93 × 8.03%
2021/05/01 5.72% = 0.77 × 0.93 × 7.94%
2021/01/30 5.26% = 0.77 × 0.92 × 7.40%
2020/10/31 3.84% = 0.74 × 0.90 × 5.80%
2020/08/01 3.61% = 0.75 × 0.88 × 5.47%
2020/05/02 3.35% = 0.75 × 0.87 × 5.15%
2020/02/01 3.50% = 0.75 × 0.87 × 5.34%
2019/11/02 -6.82% = × × -4.83%
2019/08/03 -6.77% = × × -4.75%
2019/05/04 -6.43% = × × -4.29%
2019/02/02 -6.97% = × × -4.11%
2018/11/03 7.64% = 1.11 × 0.80 × 8.62%
2018/08/04 7.53% = 1.08 × 0.79 × 8.87%
2018/05/05 7.44% = 1.05 × 0.78 × 9.13%
2018/02/03 7.71% = 1.01 × 0.85 × 9.02%
2017/10/28 4.63% = 0.66 × 0.83 × 8.45%
2017/07/29 4.37% = 0.67 × 0.80 × 8.19%
2017/04/29 4.13% = 0.66 × 0.78 × 8.00%
2017/01/28 4.33% = 0.67 × 0.78 × 8.23%
2016/10/29 = × ×
2016/07/30 = × ×
2016/04/30 = × ×

レポートに基づく: 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), 10-K (報告日: 2019-02-02), 10-Q (報告日: 2018-11-03), 10-Q (報告日: 2018-08-04), 10-Q (報告日: 2018-05-05), 10-K (報告日: 2018-02-03), 10-Q (報告日: 2017-10-28), 10-Q (報告日: 2017-07-29), 10-Q (報告日: 2017-04-29), 10-K (報告日: 2017-01-28), 10-Q (報告日: 2016-10-29), 10-Q (報告日: 2016-07-30), 10-Q (報告日: 2016-04-30).

2023年第3 四半期に純利益率が上昇した主な理由は、EBITマージン率で測定した営業利益率の増加です。