Stock Analysis on Net

Best Buy Co. Inc. (NYSE:BBY)

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

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

Microsoft Excel

Two-Component Disaggregation of ROE

Best Buy Co. Inc., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = ROA × Financial Leverage
Oct 29, 2022 51.79% = 9.11% × 5.69
Jul 30, 2022 61.27% = 11.49% × 5.33
Apr 30, 2022 79.51% = 14.43% × 5.51
Jan 29, 2022 81.26% = 14.02% × 5.80
Oct 30, 2021 61.80% = 13.15% × 4.70
Jul 31, 2021 58.50% = 13.65% × 4.29
May 1, 2021 53.73% = 12.62% × 4.26
Jan 30, 2021 39.20% = 9.43% × 4.16
Oct 31, 2020 42.27% = 8.15% × 5.19
Aug 1, 2020 43.12% = 9.36% × 4.61
May 2, 2020 42.08% = 9.20% × 4.58
Feb 1, 2020 44.29% = 9.88% × 4.48
Nov 2, 2019 48.99% = 9.05% × 5.42
Aug 3, 2019 46.12% = 10.11% × 4.56
May 4, 2019 45.35% = 10.45% × 4.34
Feb 2, 2019 44.28% = 11.35% × 3.90
Nov 3, 2018 36.29% = 7.29% × 4.98
Aug 4, 2018 33.11% = 8.80% × 3.76
May 5, 2018 29.82% = 8.44% × 3.53
Feb 3, 2018 27.69% = 7.66% × 3.61
Oct 28, 2017 29.94% = 8.41% × 3.56
Jul 29, 2017 27.56% = 8.91% × 3.09
Apr 29, 2017 26.38% = 9.16% × 2.88

Based on: 10-Q (reporting date: 2022-10-29), 10-Q (reporting date: 2022-07-30), 10-Q (reporting date: 2022-04-30), 10-K (reporting date: 2022-01-29), 10-Q (reporting date: 2021-10-30), 10-Q (reporting date: 2021-07-31), 10-Q (reporting date: 2021-05-01), 10-K (reporting date: 2021-01-30), 10-Q (reporting date: 2020-10-31), 10-Q (reporting date: 2020-08-01), 10-Q (reporting date: 2020-05-02), 10-K (reporting date: 2020-02-01), 10-Q (reporting date: 2019-11-02), 10-Q (reporting date: 2019-08-03), 10-Q (reporting date: 2019-05-04), 10-K (reporting date: 2019-02-02), 10-Q (reporting date: 2018-11-03), 10-Q (reporting date: 2018-08-04), 10-Q (reporting date: 2018-05-05), 10-K (reporting date: 2018-02-03), 10-Q (reporting date: 2017-10-28), 10-Q (reporting date: 2017-07-29), 10-Q (reporting date: 2017-04-29).


Return on Assets (ROA)
The Return on Assets exhibits some variability over the periods analyzed. Beginning at 9.16% in April 2017, it decreased to a low of 7.29% by November 2018. Subsequently, ROA increased significantly reaching peaks above 13% in mid to late 2021, with the highest value observed at 14.43% in April 2022. Following this peak, there was a decline to 9.11% by October 2022. Overall, the trend suggests cycles of performance improvement and contraction in asset profitability, with notable growth phases in 2019 and 2021.
Financial Leverage
Financial Leverage showed an upward trend over the analyzed timeframe. Starting at a ratio of 2.88 in April 2017, there was consistent growth leading to a peak of 5.80 in January 2022. This indicates increased use of debt relative to equity over time. Slight fluctuations occurred, but the general movement was toward greater leverage, with notable increases during late 2018 and early 2022. The data suggests a strategic choice toward employing more leverage, potentially to fuel growth or returns, albeit with some volatility near 2019 and post early 2022.
Return on Equity (ROE)
Return on Equity demonstrates a strong upward trend from April 2017 through early 2022. Starting at 26.38%, ROE progressively increased, with marked acceleration after 2018. The highest levels were recorded in the range of 61.27% to 81.26% between January and April 2022, indicating exceptional equity returns during this period. Although there is a slight decline to around 51.79% in the most recent quarter, the general pattern underscores highly improving profitability from the shareholders’ perspective. This surge likely correlates with the increasing financial leverage, which magnifies equity returns when asset returns remain positive.
Summary Insights
Over the examined quarters, the company experienced cycles of asset profitability changes, with peaks in ROA occurring around 2021 and early 2022 before a downturn. Concurrently, financial leverage almost doubled, suggesting more aggressive debt use to enhance returns. This strategic deployment of leverage aligns with the substantial increase in ROE, which reached historical highs during the same periods. The data reflects a company successfully leveraging debt to boost shareholder returns, though with some risk indicated by recent declines in both ROA and ROE following their peak levels. Close monitoring of leverage and asset efficiency is advisable to sustain these elevated levels of equity returns.

Three-Component Disaggregation of ROE

Best Buy Co. Inc., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = Net Profit Margin × Asset Turnover × Financial Leverage
Oct 29, 2022 51.79% = 3.23% × 2.82 × 5.69
Jul 30, 2022 61.27% = 3.60% × 3.19 × 5.33
Apr 30, 2022 79.51% = 4.33% × 3.33 × 5.51
Jan 29, 2022 81.26% = 4.74% × 2.96 × 5.80
Oct 30, 2021 61.80% = 5.05% × 2.60 × 4.70
Jul 31, 2021 58.50% = 4.85% × 2.81 × 4.29
May 1, 2021 53.73% = 4.44% × 2.84 × 4.26
Jan 30, 2021 39.20% = 3.80% × 2.48 × 4.16
Oct 31, 2020 42.27% = 3.79% × 2.15 × 5.19
Aug 1, 2020 43.12% = 3.75% × 2.49 × 4.61
May 2, 2020 42.08% = 3.33% × 2.76 × 4.58
Feb 1, 2020 44.29% = 3.53% × 2.80 × 4.48
Nov 2, 2019 48.99% = 3.54% × 2.55 × 5.42
Aug 3, 2019 46.12% = 3.52% × 2.88 × 4.56
May 4, 2019 45.35% = 3.54% × 2.95 × 4.34
Feb 2, 2019 44.28% = 3.41% × 3.32 × 3.90
Nov 3, 2018 36.29% = 2.52% × 2.90 × 4.98
Aug 4, 2018 33.11% = 2.44% × 3.60 × 3.76
May 5, 2018 29.82% = 2.39% × 3.54 × 3.53
Feb 3, 2018 27.69% = 2.37% × 3.23 × 3.61
Oct 28, 2017 29.94% = 3.09% × 2.72 × 3.56
Jul 29, 2017 27.56% = 3.00% × 2.97 × 3.09
Apr 29, 2017 26.38% = 3.01% × 3.05 × 2.88

Based on: 10-Q (reporting date: 2022-10-29), 10-Q (reporting date: 2022-07-30), 10-Q (reporting date: 2022-04-30), 10-K (reporting date: 2022-01-29), 10-Q (reporting date: 2021-10-30), 10-Q (reporting date: 2021-07-31), 10-Q (reporting date: 2021-05-01), 10-K (reporting date: 2021-01-30), 10-Q (reporting date: 2020-10-31), 10-Q (reporting date: 2020-08-01), 10-Q (reporting date: 2020-05-02), 10-K (reporting date: 2020-02-01), 10-Q (reporting date: 2019-11-02), 10-Q (reporting date: 2019-08-03), 10-Q (reporting date: 2019-05-04), 10-K (reporting date: 2019-02-02), 10-Q (reporting date: 2018-11-03), 10-Q (reporting date: 2018-08-04), 10-Q (reporting date: 2018-05-05), 10-K (reporting date: 2018-02-03), 10-Q (reporting date: 2017-10-28), 10-Q (reporting date: 2017-07-29), 10-Q (reporting date: 2017-04-29).


Net Profit Margin
The net profit margin exhibited moderate fluctuations over the analyzed quarters. Initially, it ranged between approximately 2.37% and 3.54%, showing a generally stable performance in profitability. From early 2020 onward, there was a noticeable increase, peaking around 5.05% in late 2021. However, this upward trend slowed and reversed slightly in subsequent quarters, declining to approximately 3.23% by late 2022. This pattern suggests a period of improving operational efficiency or pricing power followed by some contraction in profitability margins.
Asset Turnover
Asset turnover ratios showed considerable variability throughout the periods. Early values fluctuated between 2.55 and 3.54, indicating variations in how effectively the company utilized its assets to generate sales. There was a downward trend mid-period, particularly in 2020 when ratios dropped below 2.5, signaling decreased efficiency in asset utilization. Although some recovery is noted in 2022 with ratios rising above 3.0, the overall trend indicates challenges in maintaining consistent asset productivity.
Financial Leverage
Financial leverage steadily increased over the quarters, starting at around 2.88 and reaching values as high as 5.8. This rising leverage level indicates a growing reliance on debt or other liabilities to finance the company’s assets. The trend suggests an increasing risk profile but also potential opportunities for enhanced returns due to leverage effects. The company appears to have sustained higher leverage levels through the most recent periods, implying ongoing strategic use of debt financing.
Return on Equity (ROE)
ROE demonstrated a strong upward trajectory for much of the period, beginning near 26% and reaching an exceptionally high peak above 81% in early 2022. This marked increase implies significant improvements in overall profitability relative to shareholders’ equity, potentially driven by both operational improvements and increased financial leverage. The subsequent decline to around 52% by late 2022 still reflects robust profitability, although the decrease may highlight the impact of reduced profit margins or asset turnover, or changes in capital structure.

Five-Component Disaggregation of ROE

Best Buy Co. Inc., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover × Financial Leverage
Oct 29, 2022 51.79% = 0.79 × 0.99 × 4.18% × 2.82 × 5.69
Jul 30, 2022 61.27% = 0.78 × 0.99 × 4.68% × 3.19 × 5.33
Apr 30, 2022 79.51% = 0.81 × 0.99 × 5.39% × 3.33 × 5.51
Jan 29, 2022 81.26% = 0.81 × 0.99 × 5.90% × 2.96 × 5.80
Oct 30, 2021 61.80% = 0.81 × 0.99 × 6.31% × 2.60 × 4.70
Jul 31, 2021 58.50% = 0.80 × 0.99 × 6.11% × 2.81 × 4.29
May 1, 2021 53.73% = 0.76 × 0.99 × 5.89% × 2.84 × 4.26
Jan 30, 2021 39.20% = 0.76 × 0.98 × 5.14% × 2.48 × 4.16
Oct 31, 2020 42.27% = 0.75 × 0.98 × 5.18% × 2.15 × 5.19
Aug 1, 2020 43.12% = 0.76 × 0.97 × 5.06% × 2.49 × 4.61
May 2, 2020 42.08% = 0.76 × 0.97 × 4.51% × 2.76 × 4.58
Feb 1, 2020 44.29% = 0.77 × 0.97 × 4.71% × 2.80 × 4.48
Nov 2, 2019 48.99% = 0.77 × 0.97 × 4.78% × 2.55 × 5.42
Aug 3, 2019 46.12% = 0.78 × 0.97 × 4.66% × 2.88 × 4.56
May 4, 2019 45.35% = 0.78 × 0.96 × 4.74% × 2.95 × 4.34
Feb 2, 2019 44.28% = 0.78 × 0.96 × 4.57% × 3.32 × 3.90
Nov 3, 2018 36.29% = 0.61 × 0.96 × 4.28% × 2.90 × 4.98
Aug 4, 2018 33.11% = 0.59 × 0.96 × 4.35% × 3.60 × 3.76
May 5, 2018 29.82% = 0.57 × 0.96 × 4.35% × 3.54 × 3.53
Feb 3, 2018 27.69% = 0.55 × 0.96 × 4.49% × 3.23 × 3.61
Oct 28, 2017 29.94% = 0.68 × 0.96 × 4.70% × 2.72 × 3.56
Jul 29, 2017 27.56% = 0.67 × 0.96 × 4.64% × 2.97 × 3.09
Apr 29, 2017 26.38% = 0.67 × 0.96 × 4.65% × 3.05 × 2.88

Based on: 10-Q (reporting date: 2022-10-29), 10-Q (reporting date: 2022-07-30), 10-Q (reporting date: 2022-04-30), 10-K (reporting date: 2022-01-29), 10-Q (reporting date: 2021-10-30), 10-Q (reporting date: 2021-07-31), 10-Q (reporting date: 2021-05-01), 10-K (reporting date: 2021-01-30), 10-Q (reporting date: 2020-10-31), 10-Q (reporting date: 2020-08-01), 10-Q (reporting date: 2020-05-02), 10-K (reporting date: 2020-02-01), 10-Q (reporting date: 2019-11-02), 10-Q (reporting date: 2019-08-03), 10-Q (reporting date: 2019-05-04), 10-K (reporting date: 2019-02-02), 10-Q (reporting date: 2018-11-03), 10-Q (reporting date: 2018-08-04), 10-Q (reporting date: 2018-05-05), 10-K (reporting date: 2018-02-03), 10-Q (reporting date: 2017-10-28), 10-Q (reporting date: 2017-07-29), 10-Q (reporting date: 2017-04-29).


Tax Burden
The tax burden ratio shows a moderate fluctuation over the periods, starting around 0.67 and gradually increasing to about 0.79 in the later quarters. Notably, there is an observable rise from early 2019 to 2022, indicating an increasing proportion of earnings retained after tax relative to pre-tax income throughout the later periods.
Interest Burden
The interest burden remains remarkably stable and high across all quarters, consistently near 0.96 to 0.99. This suggests that interest expenses have a minimal impact on the company's earnings before tax, maintaining a steady financial cost relative to earnings.
EBIT Margin
The EBIT margin declines slightly in the initial periods, dropping from approximately 4.7% to a low point near 4.28%, but then gradually improves to a peak above 6% around mid-2021. After this peak, it decreases steadily again, falling to about 4.18% by late 2022. This pattern illustrates some volatility in operational profitability, with a significant improvement phase followed by a downward correction.
Asset Turnover
Asset turnover ratio demonstrates notable variability, fluctuating between about 2.15 and 3.6 over the quarters. Early peaks occur around mid-2018, but a declining trend manifests between 2020 and early 2021. A recovery appears thereafter, with turnover ratios increasing again up to mid-2022 before falling moderately in the last observed quarter. This indicates changes in how effectively the company utilizes its assets to generate sales, with periods of both improved and diminished efficiency.
Financial Leverage
Financial leverage increases consistently throughout the time frame, beginning near 2.88 and rising to values exceeding 5.5 by late 2022. The upward trend suggests an increased use of debt or other liabilities relative to equity, reflecting a strategic decision to potentially amplify returns but also increased financial risk.
Return on Equity (ROE)
Return on equity shows a strong upward trend overall, starting at about 26% and reaching very high levels above 80% in early 2022. Despite some decline following this peak, ROE remains elevated relative to the early periods, finishing near 52%. The increase is likely driven by the combined effects of higher financial leverage and operational profitability improvements earlier in the period, though recent declines in EBIT margin and asset turnover possibly contribute to the decrease in ROE toward the end.
Overall Summary
The company exhibits increasing financial leverage alongside stable interest burden, suggesting confidence in leveraging to enhance returns. Operational efficiency and profitability show periods of both growth and contraction, impacting the EBIT margin and asset turnover. The pronounced increase in return on equity reflects effective use of leverage and operational performance improvements, although recent declines in some metrics warrant cautious monitoring. Tax efficiency has modestly improved over time, supporting bottom-line results. Overall, the financial data reveals dynamic performance with strengths in leverage management offset by fluctuations in operational profitability and asset utilization.

Two-Component Disaggregation of ROA

Best Buy Co. Inc., decomposition of ROA (quarterly data)

Microsoft Excel
ROA = Net Profit Margin × Asset Turnover
Oct 29, 2022 9.11% = 3.23% × 2.82
Jul 30, 2022 11.49% = 3.60% × 3.19
Apr 30, 2022 14.43% = 4.33% × 3.33
Jan 29, 2022 14.02% = 4.74% × 2.96
Oct 30, 2021 13.15% = 5.05% × 2.60
Jul 31, 2021 13.65% = 4.85% × 2.81
May 1, 2021 12.62% = 4.44% × 2.84
Jan 30, 2021 9.43% = 3.80% × 2.48
Oct 31, 2020 8.15% = 3.79% × 2.15
Aug 1, 2020 9.36% = 3.75% × 2.49
May 2, 2020 9.20% = 3.33% × 2.76
Feb 1, 2020 9.88% = 3.53% × 2.80
Nov 2, 2019 9.05% = 3.54% × 2.55
Aug 3, 2019 10.11% = 3.52% × 2.88
May 4, 2019 10.45% = 3.54% × 2.95
Feb 2, 2019 11.35% = 3.41% × 3.32
Nov 3, 2018 7.29% = 2.52% × 2.90
Aug 4, 2018 8.80% = 2.44% × 3.60
May 5, 2018 8.44% = 2.39% × 3.54
Feb 3, 2018 7.66% = 2.37% × 3.23
Oct 28, 2017 8.41% = 3.09% × 2.72
Jul 29, 2017 8.91% = 3.00% × 2.97
Apr 29, 2017 9.16% = 3.01% × 3.05

Based on: 10-Q (reporting date: 2022-10-29), 10-Q (reporting date: 2022-07-30), 10-Q (reporting date: 2022-04-30), 10-K (reporting date: 2022-01-29), 10-Q (reporting date: 2021-10-30), 10-Q (reporting date: 2021-07-31), 10-Q (reporting date: 2021-05-01), 10-K (reporting date: 2021-01-30), 10-Q (reporting date: 2020-10-31), 10-Q (reporting date: 2020-08-01), 10-Q (reporting date: 2020-05-02), 10-K (reporting date: 2020-02-01), 10-Q (reporting date: 2019-11-02), 10-Q (reporting date: 2019-08-03), 10-Q (reporting date: 2019-05-04), 10-K (reporting date: 2019-02-02), 10-Q (reporting date: 2018-11-03), 10-Q (reporting date: 2018-08-04), 10-Q (reporting date: 2018-05-05), 10-K (reporting date: 2018-02-03), 10-Q (reporting date: 2017-10-28), 10-Q (reporting date: 2017-07-29), 10-Q (reporting date: 2017-04-29).


The quarterly financial ratios reveal several noteworthy trends over the observed periods. The net profit margin experienced generally moderate fluctuations, beginning around 3.0% in early 2017 and demonstrating a gradual increase to a peak near 5.05% in late 2021. Following this peak, the ratio declined to approximately 3.23% by late 2022, indicating some volatility in profitability towards the end of the period.

Regarding asset turnover, the ratio displayed more variability without a clear directional trend. Initial values near 3.05 in early 2017 oscillated over the quarters, declining to about 2.15 in late 2020 before partially recovering and reaching around 3.33 by mid-2022. The variability suggests shifts in how efficiently the company utilized assets to generate revenue across different quarters.

The return on assets (ROA) generally tracked improvements paralleling the trends in net profit margin but displayed more pronounced peaks and troughs. Starting at approximately 9.16% in early 2017, ROA dipped during some quarters but surged to a peak of 14.43% around mid-2022. This was followed by a decline to about 9.11% towards the end of the analyzed period. Such fluctuations indicate that overall profitability relative to asset base experienced periods of significant enhancement as well as regression.

Net Profit Margin
Showed an upward trend from near 3.0% in 2017 to a peak above 5% in late 2021, followed by a notable decrease into 2022, implying fluctuating profitability margins over time.
Asset Turnover
Varied between approximately 2.15 and 3.33 with no consistent trend, reflecting inconsistent efficiency in converting assets into revenue across quarters.
Return on Assets (ROA)
Improved from around 9% in 2017 to highs above 14% in 2022 before declining late in the period, signifying cyclical trends in asset profitability performance.

Overall, the data suggests a business experiencing cycles in profitability and asset utilization effectiveness, with stronger financial performance emerging primarily during 2021 and early 2022, followed by signs of some deterioration in late 2022. Monitoring these ratios will be important for assessing ongoing operational efficiency and profitability dynamics.


Four-Component Disaggregation of ROA

Best Buy Co. Inc., decomposition of ROA (quarterly data)

Microsoft Excel
ROA = Tax Burden × Interest Burden × EBIT Margin × Asset Turnover
Oct 29, 2022 9.11% = 0.79 × 0.99 × 4.18% × 2.82
Jul 30, 2022 11.49% = 0.78 × 0.99 × 4.68% × 3.19
Apr 30, 2022 14.43% = 0.81 × 0.99 × 5.39% × 3.33
Jan 29, 2022 14.02% = 0.81 × 0.99 × 5.90% × 2.96
Oct 30, 2021 13.15% = 0.81 × 0.99 × 6.31% × 2.60
Jul 31, 2021 13.65% = 0.80 × 0.99 × 6.11% × 2.81
May 1, 2021 12.62% = 0.76 × 0.99 × 5.89% × 2.84
Jan 30, 2021 9.43% = 0.76 × 0.98 × 5.14% × 2.48
Oct 31, 2020 8.15% = 0.75 × 0.98 × 5.18% × 2.15
Aug 1, 2020 9.36% = 0.76 × 0.97 × 5.06% × 2.49
May 2, 2020 9.20% = 0.76 × 0.97 × 4.51% × 2.76
Feb 1, 2020 9.88% = 0.77 × 0.97 × 4.71% × 2.80
Nov 2, 2019 9.05% = 0.77 × 0.97 × 4.78% × 2.55
Aug 3, 2019 10.11% = 0.78 × 0.97 × 4.66% × 2.88
May 4, 2019 10.45% = 0.78 × 0.96 × 4.74% × 2.95
Feb 2, 2019 11.35% = 0.78 × 0.96 × 4.57% × 3.32
Nov 3, 2018 7.29% = 0.61 × 0.96 × 4.28% × 2.90
Aug 4, 2018 8.80% = 0.59 × 0.96 × 4.35% × 3.60
May 5, 2018 8.44% = 0.57 × 0.96 × 4.35% × 3.54
Feb 3, 2018 7.66% = 0.55 × 0.96 × 4.49% × 3.23
Oct 28, 2017 8.41% = 0.68 × 0.96 × 4.70% × 2.72
Jul 29, 2017 8.91% = 0.67 × 0.96 × 4.64% × 2.97
Apr 29, 2017 9.16% = 0.67 × 0.96 × 4.65% × 3.05

Based on: 10-Q (reporting date: 2022-10-29), 10-Q (reporting date: 2022-07-30), 10-Q (reporting date: 2022-04-30), 10-K (reporting date: 2022-01-29), 10-Q (reporting date: 2021-10-30), 10-Q (reporting date: 2021-07-31), 10-Q (reporting date: 2021-05-01), 10-K (reporting date: 2021-01-30), 10-Q (reporting date: 2020-10-31), 10-Q (reporting date: 2020-08-01), 10-Q (reporting date: 2020-05-02), 10-K (reporting date: 2020-02-01), 10-Q (reporting date: 2019-11-02), 10-Q (reporting date: 2019-08-03), 10-Q (reporting date: 2019-05-04), 10-K (reporting date: 2019-02-02), 10-Q (reporting date: 2018-11-03), 10-Q (reporting date: 2018-08-04), 10-Q (reporting date: 2018-05-05), 10-K (reporting date: 2018-02-03), 10-Q (reporting date: 2017-10-28), 10-Q (reporting date: 2017-07-29), 10-Q (reporting date: 2017-04-29).


Tax Burden
The tax burden ratio exhibits an overall upward trend from 2017 through early 2022, increasing from approximately 0.67 to a peak above 0.80. This indicates a diminishing proportion of income lost to taxes over time, suggesting improved tax efficiency or favorable tax conditions in later periods.
Interest Burden
The interest burden ratio remains relatively stable and consistently high, close to 0.96-0.99 throughout the observed periods. This stability implies that interest expenses have had a minimal and steady impact on earnings before tax, reflecting effective interest management and low leverage costs.
EBIT Margin
The EBIT margin shows moderate fluctuations, with values mostly ranging between 4.2% and 6.3%. After a general period of stability around 4.3-4.7%, there is a noticeable increase starting in early 2020, peaking at over 6.3% around mid-2021, followed by a decline toward 4.18% by late 2022. This pattern suggests periods of enhanced operational profitability, possibly driven by cost controls or pricing strategies, followed by some contraction in the most recent quarters.
Asset Turnover
Asset turnover demonstrates variability over time without a clear directional trend. Initial periods show values around 3.0, with peaks above 3.5 mostly before 2019 and a trough near 2.15 in late 2020. The metric tends to rebound thereafter, ending near 2.8 in late 2022. Such fluctuations highlight changes in the efficiency with which assets generate sales, potentially influenced by asset base adjustments or sales volume changes.
Return on Assets (ROA)
ROA experiences notable volatility throughout the timeline, starting in the 8-9% range in 2017 and 2018, with a marked spike to above 14% in early 2022. This peak is followed by a decline to approximately 9% by late 2022. The variations in ROA reflect the combined effects of changing EBIT margins and asset turnover, indicating periods of strong profitability relative to asset base, interspersed with softer performance.

Disaggregation of Net Profit Margin

Best Buy Co. Inc., decomposition of net profit margin ratio (quarterly data)

Microsoft Excel
Net Profit Margin = Tax Burden × Interest Burden × EBIT Margin
Oct 29, 2022 3.23% = 0.79 × 0.99 × 4.18%
Jul 30, 2022 3.60% = 0.78 × 0.99 × 4.68%
Apr 30, 2022 4.33% = 0.81 × 0.99 × 5.39%
Jan 29, 2022 4.74% = 0.81 × 0.99 × 5.90%
Oct 30, 2021 5.05% = 0.81 × 0.99 × 6.31%
Jul 31, 2021 4.85% = 0.80 × 0.99 × 6.11%
May 1, 2021 4.44% = 0.76 × 0.99 × 5.89%
Jan 30, 2021 3.80% = 0.76 × 0.98 × 5.14%
Oct 31, 2020 3.79% = 0.75 × 0.98 × 5.18%
Aug 1, 2020 3.75% = 0.76 × 0.97 × 5.06%
May 2, 2020 3.33% = 0.76 × 0.97 × 4.51%
Feb 1, 2020 3.53% = 0.77 × 0.97 × 4.71%
Nov 2, 2019 3.54% = 0.77 × 0.97 × 4.78%
Aug 3, 2019 3.52% = 0.78 × 0.97 × 4.66%
May 4, 2019 3.54% = 0.78 × 0.96 × 4.74%
Feb 2, 2019 3.41% = 0.78 × 0.96 × 4.57%
Nov 3, 2018 2.52% = 0.61 × 0.96 × 4.28%
Aug 4, 2018 2.44% = 0.59 × 0.96 × 4.35%
May 5, 2018 2.39% = 0.57 × 0.96 × 4.35%
Feb 3, 2018 2.37% = 0.55 × 0.96 × 4.49%
Oct 28, 2017 3.09% = 0.68 × 0.96 × 4.70%
Jul 29, 2017 3.00% = 0.67 × 0.96 × 4.64%
Apr 29, 2017 3.01% = 0.67 × 0.96 × 4.65%

Based on: 10-Q (reporting date: 2022-10-29), 10-Q (reporting date: 2022-07-30), 10-Q (reporting date: 2022-04-30), 10-K (reporting date: 2022-01-29), 10-Q (reporting date: 2021-10-30), 10-Q (reporting date: 2021-07-31), 10-Q (reporting date: 2021-05-01), 10-K (reporting date: 2021-01-30), 10-Q (reporting date: 2020-10-31), 10-Q (reporting date: 2020-08-01), 10-Q (reporting date: 2020-05-02), 10-K (reporting date: 2020-02-01), 10-Q (reporting date: 2019-11-02), 10-Q (reporting date: 2019-08-03), 10-Q (reporting date: 2019-05-04), 10-K (reporting date: 2019-02-02), 10-Q (reporting date: 2018-11-03), 10-Q (reporting date: 2018-08-04), 10-Q (reporting date: 2018-05-05), 10-K (reporting date: 2018-02-03), 10-Q (reporting date: 2017-10-28), 10-Q (reporting date: 2017-07-29), 10-Q (reporting date: 2017-04-29).


Tax Burden
The tax burden ratio initially fluctuated slightly around 0.67 before showing a notable decline to 0.55 at the beginning of 2018. Subsequently, the ratio gradually increased and stabilized in the range of approximately 0.76 to 0.81 from early 2019 onward, indicating a steadier and somewhat higher proportion of earnings retained after tax in recent periods.
Interest Burden
The interest burden ratio remained remarkably stable over the entire period, hovering consistently around 0.96 to 0.99. This suggests a stable interest expense relative to earnings before interest and taxes, indicating consistent debt servicing costs without significant volatility.
EBIT Margin
The EBIT margin exhibited moderate fluctuations during the earlier quarters, remaining between roughly 4.3% and 4.7%. Starting from mid-2020, there was a noticeable upward trend, reaching a peak above 6% in late 2021. However, following this peak, the margin showed a decline back toward values near 4.2% by late 2022. This pattern indicates a period of improving operating profitability followed by some contraction.
Net Profit Margin
The net profit margin declined from around 3.0% in the initial periods to a low near 2.37% in early 2018. From that point, a gradual and consistent increase was observed, peaking near 5.05% toward late 2021. After this peak, a subsequent decrease occurred with margins falling to just above 3.2% by the last reported quarter. This trend suggests an overall improvement in bottom-line profitability over the medium term, with some recent softness.