Stock Analysis on Net

Bed Bath & Beyond Inc. (NASDAQ:BBBY)

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

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

Microsoft Excel

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

Bed Bath & Beyond Inc.、 ROE の分解(四半期データ)

Microsoft Excel
ROE = ROA × 財務レバレッジ比率
2022/08/27 = -24.84% ×
2022/05/28 = -17.51% ×
2022/02/26 -321.35% = -10.91% × 29.46
2021/11/27 -70.71% = -6.92% × 10.22
2021/08/28 -20.39% = -3.14% × 6.49
2021/05/29 9.09% = 1.66% × 5.47
2021/02/27 -11.81% = -2.34% × 5.06
2020/11/28 -16.09% = -3.22% × 4.99
2020/08/29 -11.10% = -2.53% × 4.38
2020/05/30 -37.30% = -7.08% × 5.27
2020/02/29 -34.78% = -7.88% × 4.41
2019/11/30 -43.40% = -10.01% × 4.34
2019/08/31 -38.83% = -9.34% × 4.16
2019/06/01 -26.76% = -6.91% × 3.87
2019/03/02 -5.36% = -2.09% × 2.57
2018/12/01 10.70% = 4.12% × 2.60
2018/09/01 11.97% = 4.75% × 2.52
2018/06/02 13.54% = 5.61% × 2.42
2018/03/03 14.71% = 6.03% × 2.44
2017/11/25 18.17% = 6.95% × 2.62
2017/08/26 20.75% = 8.33% × 2.49
2017/05/27 23.86% = 9.28% × 2.57
2017/02/25 25.19% = 10.01% × 2.52
2016/11/26 = × 2.77
2016/08/27 = × 2.59
2016/05/28 = × 2.60

レポートに基づく: 10-Q (報告日: 2022-08-27), 10-Q (報告日: 2022-05-28), 10-K (報告日: 2022-02-26), 10-Q (報告日: 2021-11-27), 10-Q (報告日: 2021-08-28), 10-Q (報告日: 2021-05-29), 10-K (報告日: 2021-02-27), 10-Q (報告日: 2020-11-28), 10-Q (報告日: 2020-08-29), 10-Q (報告日: 2020-05-30), 10-K (報告日: 2020-02-29), 10-Q (報告日: 2019-11-30), 10-Q (報告日: 2019-08-31), 10-Q (報告日: 2019-06-01), 10-K (報告日: 2019-03-02), 10-Q (報告日: 2018-12-01), 10-Q (報告日: 2018-09-01), 10-Q (報告日: 2018-06-02), 10-K (報告日: 2018-03-03), 10-Q (報告日: 2017-11-25), 10-Q (報告日: 2017-08-26), 10-Q (報告日: 2017-05-27), 10-K (報告日: 2017-02-25), 10-Q (報告日: 2016-11-26), 10-Q (報告日: 2016-08-27), 10-Q (報告日: 2016-05-28).


ROEを3つの要素に分解

Bed Bath & Beyond Inc.、 ROE の分解(四半期データ)

Microsoft Excel
ROE = 純利益率 × 資産回転率 × 財務レバレッジ比率
2022/08/27 = -16.98% × 1.46 ×
2022/05/28 = -11.74% × 1.49 ×
2022/02/26 -321.35% = -7.11% × 1.53 × 29.46
2021/11/27 -70.71% = -4.64% × 1.49 × 10.22
2021/08/28 -20.39% = -2.08% × 1.51 × 6.49
2021/05/29 9.09% = 1.02% × 1.63 × 5.47
2021/02/27 -11.81% = -1.63% × 1.43 × 5.06
2020/11/28 -16.09% = -2.32% × 1.39 × 4.99
2020/08/29 -11.10% = -1.91% × 1.33 × 4.38
2020/05/30 -37.30% = -5.51% × 1.29 × 5.27
2020/02/29 -34.78% = -5.50% × 1.43 × 4.41
2019/11/30 -43.40% = -7.06% × 1.42 × 4.34
2019/08/31 -38.83% = -6.36% × 1.47 × 4.16
2019/06/01 -26.76% = -4.66% × 1.48 × 3.87
2019/03/02 -5.36% = -1.14% × 1.83 × 2.57
2018/12/01 10.70% = 2.50% × 1.65 × 2.60
2018/09/01 11.97% = 2.81% × 1.69 × 2.52
2018/06/02 13.54% = 3.18% × 1.76 × 2.42
2018/03/03 14.71% = 3.44% × 1.75 × 2.44
2017/11/25 18.17% = 4.11% × 1.69 × 2.62
2017/08/26 20.75% = 4.64% × 1.79 × 2.49
2017/05/27 23.86% = 5.22% × 1.78 × 2.57
2017/02/25 25.19% = 5.61% × 1.78 × 2.52
2016/11/26 = × × 2.77
2016/08/27 = × × 2.59
2016/05/28 = × × 2.60

レポートに基づく: 10-Q (報告日: 2022-08-27), 10-Q (報告日: 2022-05-28), 10-K (報告日: 2022-02-26), 10-Q (報告日: 2021-11-27), 10-Q (報告日: 2021-08-28), 10-Q (報告日: 2021-05-29), 10-K (報告日: 2021-02-27), 10-Q (報告日: 2020-11-28), 10-Q (報告日: 2020-08-29), 10-Q (報告日: 2020-05-30), 10-K (報告日: 2020-02-29), 10-Q (報告日: 2019-11-30), 10-Q (報告日: 2019-08-31), 10-Q (報告日: 2019-06-01), 10-K (報告日: 2019-03-02), 10-Q (報告日: 2018-12-01), 10-Q (報告日: 2018-09-01), 10-Q (報告日: 2018-06-02), 10-K (報告日: 2018-03-03), 10-Q (報告日: 2017-11-25), 10-Q (報告日: 2017-08-26), 10-Q (報告日: 2017-05-27), 10-K (報告日: 2017-02-25), 10-Q (報告日: 2016-11-26), 10-Q (報告日: 2016-08-27), 10-Q (報告日: 2016-05-28).


ROEを5つの要素に分解

Bed Bath & Beyond Inc.、 ROE の分解(四半期データ)

Microsoft Excel
ROE = 税負担 × 利息負担 × EBITマージン × 資産回転率 × 財務レバレッジ比率
2022/08/27 = × × -13.72% × 1.46 ×
2022/05/28 = × × -9.15% × 1.49 ×
2022/02/26 -321.35% = × × -5.19% × 1.53 × 29.46
2021/11/27 -70.71% = × × -3.15% × 1.49 × 10.22
2021/08/28 -20.39% = × × -3.30% × 1.51 × 6.49
2021/05/29 9.09% = 1.89 × 0.41 × 1.31% × 1.63 × 5.47
2021/02/27 -11.81% = × × -2.81% × 1.43 × 5.06
2020/11/28 -16.09% = × × -3.27% × 1.39 × 4.99
2020/08/29 -11.10% = × × -2.27% × 1.33 × 4.38
2020/05/30 -37.30% = × × -7.62% × 1.29 × 5.27
2020/02/29 -34.78% = × × -6.27% × 1.43 × 4.41
2019/11/30 -43.40% = × × -8.06% × 1.42 × 4.34
2019/08/31 -38.83% = × × -7.19% × 1.47 × 4.16
2019/06/01 -26.76% = × × -4.85% × 1.48 × 3.87
2019/03/02 -5.36% = × × -0.72% × 1.83 × 2.57
2018/12/01 10.70% = 0.65 × 0.87 × 4.40% × 1.65 × 2.60
2018/09/01 11.97% = 0.64 × 0.90 × 4.90% × 1.69 × 2.52
2018/06/02 13.54% = 0.62 × 0.91 × 5.63% × 1.76 × 2.42
2018/03/03 14.71% = 0.61 × 0.91 × 6.16% × 1.75 × 2.44
2017/11/25 18.17% = 0.63 × 0.92 × 7.02% × 1.69 × 2.62
2017/08/26 20.75% = 0.64 × 0.93 × 7.87% × 1.79 × 2.49
2017/05/27 23.86% = 0.64 × 0.93 × 8.75% × 1.78 × 2.57
2017/02/25 25.19% = 0.64 × 0.94 × 9.29% × 1.78 × 2.52
2016/11/26 = × × × × 2.77
2016/08/27 = × × × × 2.59
2016/05/28 = × × × × 2.60

レポートに基づく: 10-Q (報告日: 2022-08-27), 10-Q (報告日: 2022-05-28), 10-K (報告日: 2022-02-26), 10-Q (報告日: 2021-11-27), 10-Q (報告日: 2021-08-28), 10-Q (報告日: 2021-05-29), 10-K (報告日: 2021-02-27), 10-Q (報告日: 2020-11-28), 10-Q (報告日: 2020-08-29), 10-Q (報告日: 2020-05-30), 10-K (報告日: 2020-02-29), 10-Q (報告日: 2019-11-30), 10-Q (報告日: 2019-08-31), 10-Q (報告日: 2019-06-01), 10-K (報告日: 2019-03-02), 10-Q (報告日: 2018-12-01), 10-Q (報告日: 2018-09-01), 10-Q (報告日: 2018-06-02), 10-K (報告日: 2018-03-03), 10-Q (報告日: 2017-11-25), 10-Q (報告日: 2017-08-26), 10-Q (報告日: 2017-05-27), 10-K (報告日: 2017-02-25), 10-Q (報告日: 2016-11-26), 10-Q (報告日: 2016-08-27), 10-Q (報告日: 2016-05-28).


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

Bed Bath & Beyond Inc.、 ROA の分解(四半期データ)

Microsoft Excel
ROA = 純利益率 × 資産回転率
2022/08/27 -24.84% = -16.98% × 1.46
2022/05/28 -17.51% = -11.74% × 1.49
2022/02/26 -10.91% = -7.11% × 1.53
2021/11/27 -6.92% = -4.64% × 1.49
2021/08/28 -3.14% = -2.08% × 1.51
2021/05/29 1.66% = 1.02% × 1.63
2021/02/27 -2.34% = -1.63% × 1.43
2020/11/28 -3.22% = -2.32% × 1.39
2020/08/29 -2.53% = -1.91% × 1.33
2020/05/30 -7.08% = -5.51% × 1.29
2020/02/29 -7.88% = -5.50% × 1.43
2019/11/30 -10.01% = -7.06% × 1.42
2019/08/31 -9.34% = -6.36% × 1.47
2019/06/01 -6.91% = -4.66% × 1.48
2019/03/02 -2.09% = -1.14% × 1.83
2018/12/01 4.12% = 2.50% × 1.65
2018/09/01 4.75% = 2.81% × 1.69
2018/06/02 5.61% = 3.18% × 1.76
2018/03/03 6.03% = 3.44% × 1.75
2017/11/25 6.95% = 4.11% × 1.69
2017/08/26 8.33% = 4.64% × 1.79
2017/05/27 9.28% = 5.22% × 1.78
2017/02/25 10.01% = 5.61% × 1.78
2016/11/26 = ×
2016/08/27 = ×
2016/05/28 = ×

レポートに基づく: 10-Q (報告日: 2022-08-27), 10-Q (報告日: 2022-05-28), 10-K (報告日: 2022-02-26), 10-Q (報告日: 2021-11-27), 10-Q (報告日: 2021-08-28), 10-Q (報告日: 2021-05-29), 10-K (報告日: 2021-02-27), 10-Q (報告日: 2020-11-28), 10-Q (報告日: 2020-08-29), 10-Q (報告日: 2020-05-30), 10-K (報告日: 2020-02-29), 10-Q (報告日: 2019-11-30), 10-Q (報告日: 2019-08-31), 10-Q (報告日: 2019-06-01), 10-K (報告日: 2019-03-02), 10-Q (報告日: 2018-12-01), 10-Q (報告日: 2018-09-01), 10-Q (報告日: 2018-06-02), 10-K (報告日: 2018-03-03), 10-Q (報告日: 2017-11-25), 10-Q (報告日: 2017-08-26), 10-Q (報告日: 2017-05-27), 10-K (報告日: 2017-02-25), 10-Q (報告日: 2016-11-26), 10-Q (報告日: 2016-08-27), 10-Q (報告日: 2016-05-28).


ROAを4つの要素に分解

Bed Bath & Beyond Inc.、 ROA の分解(四半期データ)

Microsoft Excel
ROA = 税負担 × 利息負担 × EBITマージン × 資産回転率
2022/08/27 -24.84% = × × -13.72% × 1.46
2022/05/28 -17.51% = × × -9.15% × 1.49
2022/02/26 -10.91% = × × -5.19% × 1.53
2021/11/27 -6.92% = × × -3.15% × 1.49
2021/08/28 -3.14% = × × -3.30% × 1.51
2021/05/29 1.66% = 1.89 × 0.41 × 1.31% × 1.63
2021/02/27 -2.34% = × × -2.81% × 1.43
2020/11/28 -3.22% = × × -3.27% × 1.39
2020/08/29 -2.53% = × × -2.27% × 1.33
2020/05/30 -7.08% = × × -7.62% × 1.29
2020/02/29 -7.88% = × × -6.27% × 1.43
2019/11/30 -10.01% = × × -8.06% × 1.42
2019/08/31 -9.34% = × × -7.19% × 1.47
2019/06/01 -6.91% = × × -4.85% × 1.48
2019/03/02 -2.09% = × × -0.72% × 1.83
2018/12/01 4.12% = 0.65 × 0.87 × 4.40% × 1.65
2018/09/01 4.75% = 0.64 × 0.90 × 4.90% × 1.69
2018/06/02 5.61% = 0.62 × 0.91 × 5.63% × 1.76
2018/03/03 6.03% = 0.61 × 0.91 × 6.16% × 1.75
2017/11/25 6.95% = 0.63 × 0.92 × 7.02% × 1.69
2017/08/26 8.33% = 0.64 × 0.93 × 7.87% × 1.79
2017/05/27 9.28% = 0.64 × 0.93 × 8.75% × 1.78
2017/02/25 10.01% = 0.64 × 0.94 × 9.29% × 1.78
2016/11/26 = × × ×
2016/08/27 = × × ×
2016/05/28 = × × ×

レポートに基づく: 10-Q (報告日: 2022-08-27), 10-Q (報告日: 2022-05-28), 10-K (報告日: 2022-02-26), 10-Q (報告日: 2021-11-27), 10-Q (報告日: 2021-08-28), 10-Q (報告日: 2021-05-29), 10-K (報告日: 2021-02-27), 10-Q (報告日: 2020-11-28), 10-Q (報告日: 2020-08-29), 10-Q (報告日: 2020-05-30), 10-K (報告日: 2020-02-29), 10-Q (報告日: 2019-11-30), 10-Q (報告日: 2019-08-31), 10-Q (報告日: 2019-06-01), 10-K (報告日: 2019-03-02), 10-Q (報告日: 2018-12-01), 10-Q (報告日: 2018-09-01), 10-Q (報告日: 2018-06-02), 10-K (報告日: 2018-03-03), 10-Q (報告日: 2017-11-25), 10-Q (報告日: 2017-08-26), 10-Q (報告日: 2017-05-27), 10-K (報告日: 2017-02-25), 10-Q (報告日: 2016-11-26), 10-Q (報告日: 2016-08-27), 10-Q (報告日: 2016-05-28).


純利益率の分解

Bed Bath & Beyond Inc.、純利益率の分解(四半期データ)

Microsoft Excel
純利益率 = 税負担 × 利息負担 × EBITマージン
2022/08/27 -16.98% = × × -13.72%
2022/05/28 -11.74% = × × -9.15%
2022/02/26 -7.11% = × × -5.19%
2021/11/27 -4.64% = × × -3.15%
2021/08/28 -2.08% = × × -3.30%
2021/05/29 1.02% = 1.89 × 0.41 × 1.31%
2021/02/27 -1.63% = × × -2.81%
2020/11/28 -2.32% = × × -3.27%
2020/08/29 -1.91% = × × -2.27%
2020/05/30 -5.51% = × × -7.62%
2020/02/29 -5.50% = × × -6.27%
2019/11/30 -7.06% = × × -8.06%
2019/08/31 -6.36% = × × -7.19%
2019/06/01 -4.66% = × × -4.85%
2019/03/02 -1.14% = × × -0.72%
2018/12/01 2.50% = 0.65 × 0.87 × 4.40%
2018/09/01 2.81% = 0.64 × 0.90 × 4.90%
2018/06/02 3.18% = 0.62 × 0.91 × 5.63%
2018/03/03 3.44% = 0.61 × 0.91 × 6.16%
2017/11/25 4.11% = 0.63 × 0.92 × 7.02%
2017/08/26 4.64% = 0.64 × 0.93 × 7.87%
2017/05/27 5.22% = 0.64 × 0.93 × 8.75%
2017/02/25 5.61% = 0.64 × 0.94 × 9.29%
2016/11/26 = × ×
2016/08/27 = × ×
2016/05/28 = × ×

レポートに基づく: 10-Q (報告日: 2022-08-27), 10-Q (報告日: 2022-05-28), 10-K (報告日: 2022-02-26), 10-Q (報告日: 2021-11-27), 10-Q (報告日: 2021-08-28), 10-Q (報告日: 2021-05-29), 10-K (報告日: 2021-02-27), 10-Q (報告日: 2020-11-28), 10-Q (報告日: 2020-08-29), 10-Q (報告日: 2020-05-30), 10-K (報告日: 2020-02-29), 10-Q (報告日: 2019-11-30), 10-Q (報告日: 2019-08-31), 10-Q (報告日: 2019-06-01), 10-K (報告日: 2019-03-02), 10-Q (報告日: 2018-12-01), 10-Q (報告日: 2018-09-01), 10-Q (報告日: 2018-06-02), 10-K (報告日: 2018-03-03), 10-Q (報告日: 2017-11-25), 10-Q (報告日: 2017-08-26), 10-Q (報告日: 2017-05-27), 10-K (報告日: 2017-02-25), 10-Q (報告日: 2016-11-26), 10-Q (報告日: 2016-08-27), 10-Q (報告日: 2016-05-28).