Stock Analysis on Net

Bed Bath & Beyond Inc. (NASDAQ:BBBY)

This company has been moved to the archive! The financial data has not been updated since September 30, 2022.

DuPont Analysis: Disaggregation of ROE, ROA, and Net Profit Margin 

Microsoft Excel

Two-Component Disaggregation of ROE

Bed Bath & Beyond Inc., decomposition of ROE

Microsoft Excel
ROE = ROA × Financial Leverage
Feb 26, 2022 -321.35% = -10.91% × 29.46
Feb 27, 2021 -11.81% = -2.34% × 5.06
Feb 29, 2020 -34.78% = -7.88% × 4.41
Mar 2, 2019 -5.36% = -2.09% × 2.57
Mar 3, 2018 14.71% = 6.03% × 2.44
Feb 25, 2017 25.19% = 10.01% × 2.52

Based on: 10-K (reporting date: 2022-02-26), 10-K (reporting date: 2021-02-27), 10-K (reporting date: 2020-02-29), 10-K (reporting date: 2019-03-02), 10-K (reporting date: 2018-03-03), 10-K (reporting date: 2017-02-25).


Three-Component Disaggregation of ROE

Bed Bath & Beyond Inc., decomposition of ROE

Microsoft Excel
ROE = Net Profit Margin × Asset Turnover × Financial Leverage
Feb 26, 2022 -321.35% = -7.11% × 1.53 × 29.46
Feb 27, 2021 -11.81% = -1.63% × 1.43 × 5.06
Feb 29, 2020 -34.78% = -5.50% × 1.43 × 4.41
Mar 2, 2019 -5.36% = -1.14% × 1.83 × 2.57
Mar 3, 2018 14.71% = 3.44% × 1.75 × 2.44
Feb 25, 2017 25.19% = 5.61% × 1.78 × 2.52

Based on: 10-K (reporting date: 2022-02-26), 10-K (reporting date: 2021-02-27), 10-K (reporting date: 2020-02-29), 10-K (reporting date: 2019-03-02), 10-K (reporting date: 2018-03-03), 10-K (reporting date: 2017-02-25).


Five-Component Disaggregation of ROE

Bed Bath & Beyond Inc., decomposition of ROE

Microsoft Excel
ROE = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover × Financial Leverage
Feb 26, 2022 -321.35% = × × -5.19% × 1.53 × 29.46
Feb 27, 2021 -11.81% = × × -2.81% × 1.43 × 5.06
Feb 29, 2020 -34.78% = × × -6.27% × 1.43 × 4.41
Mar 2, 2019 -5.36% = × × -0.72% × 1.83 × 2.57
Mar 3, 2018 14.71% = 0.61 × 0.91 × 6.16% × 1.75 × 2.44
Feb 25, 2017 25.19% = 0.64 × 0.94 × 9.29% × 1.78 × 2.52

Based on: 10-K (reporting date: 2022-02-26), 10-K (reporting date: 2021-02-27), 10-K (reporting date: 2020-02-29), 10-K (reporting date: 2019-03-02), 10-K (reporting date: 2018-03-03), 10-K (reporting date: 2017-02-25).


Two-Component Disaggregation of ROA

Bed Bath & Beyond Inc., decomposition of ROA

Microsoft Excel
ROA = Net Profit Margin × Asset Turnover
Feb 26, 2022 -10.91% = -7.11% × 1.53
Feb 27, 2021 -2.34% = -1.63% × 1.43
Feb 29, 2020 -7.88% = -5.50% × 1.43
Mar 2, 2019 -2.09% = -1.14% × 1.83
Mar 3, 2018 6.03% = 3.44% × 1.75
Feb 25, 2017 10.01% = 5.61% × 1.78

Based on: 10-K (reporting date: 2022-02-26), 10-K (reporting date: 2021-02-27), 10-K (reporting date: 2020-02-29), 10-K (reporting date: 2019-03-02), 10-K (reporting date: 2018-03-03), 10-K (reporting date: 2017-02-25).


Four-Component Disaggregation of ROA

Bed Bath & Beyond Inc., decomposition of ROA

Microsoft Excel
ROA = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover
Feb 26, 2022 -10.91% = × × -5.19% × 1.53
Feb 27, 2021 -2.34% = × × -2.81% × 1.43
Feb 29, 2020 -7.88% = × × -6.27% × 1.43
Mar 2, 2019 -2.09% = × × -0.72% × 1.83
Mar 3, 2018 6.03% = 0.61 × 0.91 × 6.16% × 1.75
Feb 25, 2017 10.01% = 0.64 × 0.94 × 9.29% × 1.78

Based on: 10-K (reporting date: 2022-02-26), 10-K (reporting date: 2021-02-27), 10-K (reporting date: 2020-02-29), 10-K (reporting date: 2019-03-02), 10-K (reporting date: 2018-03-03), 10-K (reporting date: 2017-02-25).


Disaggregation of Net Profit Margin

Bed Bath & Beyond Inc., decomposition of net profit margin ratio

Microsoft Excel
Net Profit Margin = Tax Burden × Interest Burden × EBIT Margin
Feb 26, 2022 -7.11% = × × -5.19%
Feb 27, 2021 -1.63% = × × -2.81%
Feb 29, 2020 -5.50% = × × -6.27%
Mar 2, 2019 -1.14% = × × -0.72%
Mar 3, 2018 3.44% = 0.61 × 0.91 × 6.16%
Feb 25, 2017 5.61% = 0.64 × 0.94 × 9.29%

Based on: 10-K (reporting date: 2022-02-26), 10-K (reporting date: 2021-02-27), 10-K (reporting date: 2020-02-29), 10-K (reporting date: 2019-03-02), 10-K (reporting date: 2018-03-03), 10-K (reporting date: 2017-02-25).