Stock Analysis on Net
Stock Analysis on Net

Best Buy Co. Inc. (NYSE:BBY)

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

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

Microsoft Excel

ROE分解では、純利益を株主資本で割ったものを構成比率の積として表します。

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

Best Buy Co. Inc.、 ROE の分解(四半期データ)

Microsoft Excel
ROE = ROA × 財務レバレッジ比率
2022/10/29 51.79% = 9.11% × 5.69
2022/07/30 61.27% = 11.49% × 5.33
2022/04/30 79.51% = 14.43% × 5.51
2022/01/29 81.26% = 14.02% × 5.80
2021/10/30 61.80% = 13.15% × 4.70
2021/07/31 58.50% = 13.65% × 4.29
2021/05/01 53.73% = 12.62% × 4.26
2021/01/30 39.20% = 9.43% × 4.16
2020/10/31 42.27% = 8.15% × 5.19
2020/08/01 43.12% = 9.36% × 4.61
2020/05/02 42.08% = 9.20% × 4.58
2020/02/01 44.29% = 9.88% × 4.48
2019/11/02 48.99% = 9.05% × 5.42
2019/08/03 46.12% = 10.11% × 4.56
2019/05/04 45.35% = 10.45% × 4.34
2019/02/02 44.28% = 11.35% × 3.90
2018/11/03 36.29% = 7.29% × 4.98
2018/08/04 33.11% = 8.80% × 3.76
2018/05/05 29.82% = 8.44% × 3.53
2018/02/03 27.69% = 7.66% × 3.61
2017/10/28 29.94% = 8.41% × 3.56
2017/07/29 27.56% = 8.91% × 3.09
2017/04/29 26.38% = 9.16% × 2.88
2017/01/28 26.08% = 8.86% × 2.94
2016/10/29 — = — × 3.41
2016/07/30 — = — × 3.07
2016/04/30 — = — × 2.91

レポートに基づく: 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)で測定した収益性の低下です。

ROEを3つの要素に分解

Best Buy Co. Inc.、 ROE の分解(四半期データ)

Microsoft Excel
ROE = 純利益率 × 資産回転率 × 財務レバレッジ比率
2022/10/29 51.79% = 3.23% × 2.82 × 5.69
2022/07/30 61.27% = 3.60% × 3.19 × 5.33
2022/04/30 79.51% = 4.33% × 3.33 × 5.51
2022/01/29 81.26% = 4.74% × 2.96 × 5.80
2021/10/30 61.80% = 5.05% × 2.60 × 4.70
2021/07/31 58.50% = 4.85% × 2.81 × 4.29
2021/05/01 53.73% = 4.44% × 2.84 × 4.26
2021/01/30 39.20% = 3.80% × 2.48 × 4.16
2020/10/31 42.27% = 3.79% × 2.15 × 5.19
2020/08/01 43.12% = 3.75% × 2.49 × 4.61
2020/05/02 42.08% = 3.33% × 2.76 × 4.58
2020/02/01 44.29% = 3.53% × 2.80 × 4.48
2019/11/02 48.99% = 3.54% × 2.55 × 5.42
2019/08/03 46.12% = 3.52% × 2.88 × 4.56
2019/05/04 45.35% = 3.54% × 2.95 × 4.34
2019/02/02 44.28% = 3.41% × 3.32 × 3.90
2018/11/03 36.29% = 2.52% × 2.90 × 4.98
2018/08/04 33.11% = 2.44% × 3.60 × 3.76
2018/05/05 29.82% = 2.39% × 3.54 × 3.53
2018/02/03 27.69% = 2.37% × 3.23 × 3.61
2017/10/28 29.94% = 3.09% × 2.72 × 3.56
2017/07/29 27.56% = 3.00% × 2.97 × 3.09
2017/04/29 26.38% = 3.01% × 3.05 × 2.88
2017/01/28 26.08% = 3.12% × 2.84 × 2.94
2016/10/29 — = — × — × 3.41
2016/07/30 — = — × — × 3.07
2016/04/30 — = — × — × 2.91

レポートに基づく: 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つの要素に分解

Best Buy Co. Inc.、 ROE の分解(四半期データ)

Microsoft Excel
ROE = 税負担 × 利息負担 × EBITマージン × 資産回転率 × 財務レバレッジ比率
2022/10/29 51.79% = 0.79 × 0.99 × 4.18% × 2.82 × 5.69
2022/07/30 61.27% = 0.78 × 0.99 × 4.68% × 3.19 × 5.33
2022/04/30 79.51% = 0.81 × 0.99 × 5.39% × 3.33 × 5.51
2022/01/29 81.26% = 0.81 × 0.99 × 5.90% × 2.96 × 5.80
2021/10/30 61.80% = 0.81 × 0.99 × 6.31% × 2.60 × 4.70
2021/07/31 58.50% = 0.80 × 0.99 × 6.11% × 2.81 × 4.29
2021/05/01 53.73% = 0.76 × 0.99 × 5.89% × 2.84 × 4.26
2021/01/30 39.20% = 0.76 × 0.98 × 5.14% × 2.48 × 4.16
2020/10/31 42.27% = 0.75 × 0.98 × 5.18% × 2.15 × 5.19
2020/08/01 43.12% = 0.76 × 0.97 × 5.06% × 2.49 × 4.61
2020/05/02 42.08% = 0.76 × 0.97 × 4.51% × 2.76 × 4.58
2020/02/01 44.29% = 0.77 × 0.97 × 4.71% × 2.80 × 4.48
2019/11/02 48.99% = 0.77 × 0.97 × 4.78% × 2.55 × 5.42
2019/08/03 46.12% = 0.78 × 0.97 × 4.66% × 2.88 × 4.56
2019/05/04 45.35% = 0.78 × 0.96 × 4.74% × 2.95 × 4.34
2019/02/02 44.28% = 0.78 × 0.96 × 4.57% × 3.32 × 3.90
2018/11/03 36.29% = 0.61 × 0.96 × 4.28% × 2.90 × 4.98
2018/08/04 33.11% = 0.59 × 0.96 × 4.35% × 3.60 × 3.76
2018/05/05 29.82% = 0.57 × 0.96 × 4.35% × 3.54 × 3.53
2018/02/03 27.69% = 0.55 × 0.96 × 4.49% × 3.23 × 3.61
2017/10/28 29.94% = 0.68 × 0.96 × 4.70% × 2.72 × 3.56
2017/07/29 27.56% = 0.67 × 0.96 × 4.64% × 2.97 × 3.09
2017/04/29 26.38% = 0.67 × 0.96 × 4.65% × 3.05 × 2.88
2017/01/28 26.08% = 0.67 × 0.96 × 4.84% × 2.84 × 2.94
2016/10/29 — = — × — × — × — × 3.41
2016/07/30 — = — × — × — × — × 3.07
2016/04/30 — = — × — × — × — × 2.91

レポートに基づく: 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つのコンポーネントに分解

Best Buy Co. Inc.、 ROA の分解(四半期データ)

Microsoft Excel
ROA = 純利益率 × 資産回転率
2022/10/29 9.11% = 3.23% × 2.82
2022/07/30 11.49% = 3.60% × 3.19
2022/04/30 14.43% = 4.33% × 3.33
2022/01/29 14.02% = 4.74% × 2.96
2021/10/30 13.15% = 5.05% × 2.60
2021/07/31 13.65% = 4.85% × 2.81
2021/05/01 12.62% = 4.44% × 2.84
2021/01/30 9.43% = 3.80% × 2.48
2020/10/31 8.15% = 3.79% × 2.15
2020/08/01 9.36% = 3.75% × 2.49
2020/05/02 9.20% = 3.33% × 2.76
2020/02/01 9.88% = 3.53% × 2.80
2019/11/02 9.05% = 3.54% × 2.55
2019/08/03 10.11% = 3.52% × 2.88
2019/05/04 10.45% = 3.54% × 2.95
2019/02/02 11.35% = 3.41% × 3.32
2018/11/03 7.29% = 2.52% × 2.90
2018/08/04 8.80% = 2.44% × 3.60
2018/05/05 8.44% = 2.39% × 3.54
2018/02/03 7.66% = 2.37% × 3.23
2017/10/28 8.41% = 3.09% × 2.72
2017/07/29 8.91% = 3.00% × 2.97
2017/04/29 9.16% = 3.01% × 3.05
2017/01/28 8.86% = 3.12% × 2.84
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つの要素に分解

Best Buy Co. Inc.、 ROA の分解(四半期データ)

Microsoft Excel
ROA = 税負担 × 利息負担 × EBITマージン × 資産回転率
2022/10/29 9.11% = 0.79 × 0.99 × 4.18% × 2.82
2022/07/30 11.49% = 0.78 × 0.99 × 4.68% × 3.19
2022/04/30 14.43% = 0.81 × 0.99 × 5.39% × 3.33
2022/01/29 14.02% = 0.81 × 0.99 × 5.90% × 2.96
2021/10/30 13.15% = 0.81 × 0.99 × 6.31% × 2.60
2021/07/31 13.65% = 0.80 × 0.99 × 6.11% × 2.81
2021/05/01 12.62% = 0.76 × 0.99 × 5.89% × 2.84
2021/01/30 9.43% = 0.76 × 0.98 × 5.14% × 2.48
2020/10/31 8.15% = 0.75 × 0.98 × 5.18% × 2.15
2020/08/01 9.36% = 0.76 × 0.97 × 5.06% × 2.49
2020/05/02 9.20% = 0.76 × 0.97 × 4.51% × 2.76
2020/02/01 9.88% = 0.77 × 0.97 × 4.71% × 2.80
2019/11/02 9.05% = 0.77 × 0.97 × 4.78% × 2.55
2019/08/03 10.11% = 0.78 × 0.97 × 4.66% × 2.88
2019/05/04 10.45% = 0.78 × 0.96 × 4.74% × 2.95
2019/02/02 11.35% = 0.78 × 0.96 × 4.57% × 3.32
2018/11/03 7.29% = 0.61 × 0.96 × 4.28% × 2.90
2018/08/04 8.80% = 0.59 × 0.96 × 4.35% × 3.60
2018/05/05 8.44% = 0.57 × 0.96 × 4.35% × 3.54
2018/02/03 7.66% = 0.55 × 0.96 × 4.49% × 3.23
2017/10/28 8.41% = 0.68 × 0.96 × 4.70% × 2.72
2017/07/29 8.91% = 0.67 × 0.96 × 4.64% × 2.97
2017/04/29 9.16% = 0.67 × 0.96 × 4.65% × 3.05
2017/01/28 8.86% = 0.67 × 0.96 × 4.84% × 2.84
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)の低下の主な理由は、資産回転率で測定される効率性の低下です。

当期純利益率の分解

Best Buy Co. Inc.、純利益率の分解(四半期データ)

Microsoft Excel
純利益率 = 税負担 × 利息負担 × EBITマージン
2022/10/29 3.23% = 0.79 × 0.99 × 4.18%
2022/07/30 3.60% = 0.78 × 0.99 × 4.68%
2022/04/30 4.33% = 0.81 × 0.99 × 5.39%
2022/01/29 4.74% = 0.81 × 0.99 × 5.90%
2021/10/30 5.05% = 0.81 × 0.99 × 6.31%
2021/07/31 4.85% = 0.80 × 0.99 × 6.11%
2021/05/01 4.44% = 0.76 × 0.99 × 5.89%
2021/01/30 3.80% = 0.76 × 0.98 × 5.14%
2020/10/31 3.79% = 0.75 × 0.98 × 5.18%
2020/08/01 3.75% = 0.76 × 0.97 × 5.06%
2020/05/02 3.33% = 0.76 × 0.97 × 4.51%
2020/02/01 3.53% = 0.77 × 0.97 × 4.71%
2019/11/02 3.54% = 0.77 × 0.97 × 4.78%
2019/08/03 3.52% = 0.78 × 0.97 × 4.66%
2019/05/04 3.54% = 0.78 × 0.96 × 4.74%
2019/02/02 3.41% = 0.78 × 0.96 × 4.57%
2018/11/03 2.52% = 0.61 × 0.96 × 4.28%
2018/08/04 2.44% = 0.59 × 0.96 × 4.35%
2018/05/05 2.39% = 0.57 × 0.96 × 4.35%
2018/02/03 2.37% = 0.55 × 0.96 × 4.49%
2017/10/28 3.09% = 0.68 × 0.96 × 4.70%
2017/07/29 3.00% = 0.67 × 0.96 × 4.64%
2017/04/29 3.01% = 0.67 × 0.96 × 4.65%
2017/01/28 3.12% = 0.67 × 0.96 × 4.84%
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マージン率で測定した営業利益率の低下です。