Stock Analysis on Net

Best Buy Co. Inc. (NYSE:BBY)

$22.49

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

Analysis of Long-term (Investment) Activity Ratios
Quarterly Data

Microsoft Excel

Paying user area

The data is hidden behind: . Unhide it.

This is a one-time payment. There is no automatic renewal.


We accept:

Visa Mastercard American Express Maestro Discover JCB PayPal Apple Pay Google Pay
Visa Secure Mastercard Identity Check American Express SafeKey

Long-term Activity Ratios (Summary)

Best Buy Co. Inc., long-term (investment) activity ratios (quarterly data)

Microsoft Excel
Oct 29, 2022 Jul 30, 2022 Apr 30, 2022 Jan 29, 2022 Oct 30, 2021 Jul 31, 2021 May 1, 2021 Jan 30, 2021 Oct 31, 2020 Aug 1, 2020 May 2, 2020 Feb 1, 2020 Nov 2, 2019 Aug 3, 2019 May 4, 2019 Feb 2, 2019 Nov 3, 2018 Aug 4, 2018 May 5, 2018 Feb 3, 2018 Oct 28, 2017 Jul 29, 2017 Apr 29, 2017 Jan 28, 2017 Oct 29, 2016 Jul 30, 2016 Apr 30, 2016
Net fixed asset turnover
Net fixed asset turnover (including operating lease, right-of-use asset)
Total asset turnover
Equity turnover

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), 10-K (reporting date: 2017-01-28), 10-Q (reporting date: 2016-10-29), 10-Q (reporting date: 2016-07-30), 10-Q (reporting date: 2016-04-30).


The analysis of the quarterly financial ratios reveals distinctive patterns and trends over the reporting periods, highlighting changes in operational efficiency and asset utilization.

Net Fixed Asset Turnover
The net fixed asset turnover ratio remained steady around the 17.1 to 17.9 range from early 2017 through early 2018. Following this period, a gradual increase is observed, peaking at 23.48 in July 2021 before experiencing a slight decline to approximately 20.2 by October 2022. This upward trend until mid-2021 indicates an improvement in the company's ability to generate sales from its fixed assets, followed by some reduction in efficiency in the latest quarters.
Net Fixed Asset Turnover (Including Operating Lease, Right-of-Use Asset)
This ratio exhibits a noticeable shift around early 2019, declining sharply from levels comparable to the traditional metric (around 17) to a range near 8.4 to 8.75 during 2019 and 2020. Subsequent quarters show a modest recovery to a peak of 10.68 in October 2021, followed by a gradual decrease to 9.27 by the latest period. The decline corresponds to the incorporation of operating lease assets, suggesting a change in asset composition or accounting treatment, with a relative reduction in turnover efficiency when these leased assets are included.
Total Asset Turnover
Total asset turnover ratios demonstrate volatility across the analyzed time frame. Initial values in 2017 fluctuate between approximately 2.7 and 3.6, indicating varying efficiency in generating revenue from total assets. A declining trend is visible from mid-2018 through 2020, bottoming around 2.15 in August 2020, before recovering to a higher level of 3.33 in April 2022. The ratio then slightly tapers off to about 2.82 toward the end of 2022. This pattern reflects periods of lowered asset utilization alternating with recovery phases, potentially impacted by operational adjustments or external market factors.
Equity Turnover
Equity turnover shows a generally increasing trajectory until mid-2018, rising from roughly 8.4 to above 14 by early 2018, indicating a strengthening ability to generate sales relative to equity. Subsequent fluctuations occur, with a decrease to around 10.3 in October 2020, followed by a marked increase to a peak of 18.35 in July 2022. The last quarters show a mild decrease but remain elevated compared to earlier years. This suggests enhanced efficiency in using shareholders' equity to produce sales, particularly notable in the years after 2020.

Overall, the data suggest improvements in asset and equity utilization efficiency up to mid-2021 or mid-2022, with some recent declines in fixed asset turnover metrics. The inclusion of operating lease assets alters the turnover measurement, indicating potential accounting or operational changes that affect asset base representation. Volatility in total asset turnover may warrant further investigation into asset management and sales dynamics during the fluctuating periods.


Net Fixed Asset Turnover

Best Buy Co. Inc., net fixed asset turnover calculation (quarterly data)

Microsoft Excel
Oct 29, 2022 Jul 30, 2022 Apr 30, 2022 Jan 29, 2022 Oct 30, 2021 Jul 31, 2021 May 1, 2021 Jan 30, 2021 Oct 31, 2020 Aug 1, 2020 May 2, 2020 Feb 1, 2020 Nov 2, 2019 Aug 3, 2019 May 4, 2019 Feb 2, 2019 Nov 3, 2018 Aug 4, 2018 May 5, 2018 Feb 3, 2018 Oct 28, 2017 Jul 29, 2017 Apr 29, 2017 Jan 28, 2017 Oct 29, 2016 Jul 30, 2016 Apr 30, 2016
Selected Financial Data (US$ in millions)
Revenue
Property and equipment, net
Long-term Activity Ratio
Net fixed asset turnover1
Benchmarks
Net Fixed Asset Turnover, Competitors2
Amazon.com Inc.
Home Depot Inc.
Lowe’s Cos. Inc.
TJX Cos. Inc.

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), 10-K (reporting date: 2017-01-28), 10-Q (reporting date: 2016-10-29), 10-Q (reporting date: 2016-07-30), 10-Q (reporting date: 2016-04-30).

1 Q3 2023 Calculation
Net fixed asset turnover = (RevenueQ3 2023 + RevenueQ2 2023 + RevenueQ1 2023 + RevenueQ4 2022) ÷ Property and equipment, net
= ( + + + ) ÷ =

2 Click competitor name to see calculations.


Revenue
The revenue figures exhibit a recurring seasonal pattern with notable peaks in the January quarters, indicating strong performance during that period. For instance, large spikes occur in the quarters ending January 28, 2017 (US$ 13,482 million), February 3, 2018 (US$ 15,363 million), and January 30, 2021 (US$ 16,937 million). Between these peaks, revenue remains relatively stable, fluctuating around the 8,500 to 10,000 million range. There is a gradual upward trend in off-peak quarters over the years, suggesting incremental growth, particularly visible in the quarters ending August 1, 2020 (US$ 9,910 million) and July 31, 2021 (US$ 11,849 million). Despite this, the early 2022 quarters show a slight decline compared to mid-2021 levels, indicating some softening in revenue.
Property and Equipment, Net
The net property and equipment balance shows relative stability over the observed period with values generally ranging between US$ 2,250 million and US$ 2,500 million. Minor fluctuations occur without a clear upward or downward trend, suggesting limited capital expenditure or asset disposals during this time. The balance peaked at US$ 2,525 million at the quarter ending November 3, 2018, then experienced a gradual decline to around US$ 2,226 million by July 31, 2021, before increasing slightly again to US$ 2,373 million by the quarter ending October 29, 2022.
Net Fixed Asset Turnover Ratio
The net fixed asset turnover shows a consistent and strong increasing trend across the quarters where data is available, starting from approximately 17.18 and rising steadily to 23.48 by the quarter ending July 31, 2021. This indicates improved efficiency in utilizing fixed assets to generate revenue over time. The ratio slightly declines in the last two quarters to around 20.2 by October 29, 2022, which may reflect either changes in asset utilization or fluctuations in revenue relative to assets.
Overall Insights
Revenue demonstrates clear seasonal peaks associated with specific quarters, likely linked to market or holiday cycles, and generally trends upward outside peak periods until early 2022. Property and equipment balances remain stable with minor variability, suggesting a steady state of capital investment. The increasing net fixed asset turnover ratio reflects enhanced asset productivity, indicating effective use of fixed assets to support revenue growth. However, the recent slight downturn in asset turnover paired with softer revenue growth in early 2022 could merit further investigation into operational efficiency or market conditions in that period.

Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset)

Best Buy Co. Inc., net fixed asset turnover (including operating lease, right-of-use asset) calculation (quarterly data)

Microsoft Excel
Oct 29, 2022 Jul 30, 2022 Apr 30, 2022 Jan 29, 2022 Oct 30, 2021 Jul 31, 2021 May 1, 2021 Jan 30, 2021 Oct 31, 2020 Aug 1, 2020 May 2, 2020 Feb 1, 2020 Nov 2, 2019 Aug 3, 2019 May 4, 2019 Feb 2, 2019 Nov 3, 2018 Aug 4, 2018 May 5, 2018 Feb 3, 2018 Oct 28, 2017 Jul 29, 2017 Apr 29, 2017 Jan 28, 2017 Oct 29, 2016 Jul 30, 2016 Apr 30, 2016
Selected Financial Data (US$ in millions)
Revenue
 
Property and equipment, net
Operating lease assets
Property and equipment, net (including operating lease, right-of-use asset)
Long-term Activity Ratio
Net fixed asset turnover (including operating lease, right-of-use asset)1
Benchmarks
Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset), Competitors2
Amazon.com Inc.
Home Depot Inc.
Lowe’s Cos. Inc.
TJX Cos. Inc.

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), 10-K (reporting date: 2017-01-28), 10-Q (reporting date: 2016-10-29), 10-Q (reporting date: 2016-07-30), 10-Q (reporting date: 2016-04-30).

1 Q3 2023 Calculation
Net fixed asset turnover (including operating lease, right-of-use asset) = (RevenueQ3 2023 + RevenueQ2 2023 + RevenueQ1 2023 + RevenueQ4 2022) ÷ Property and equipment, net (including operating lease, right-of-use asset)
= ( + + + ) ÷ =

2 Click competitor name to see calculations.


Revenue Trends
Revenue exhibits a clear seasonal pattern, with significant peaks typically occurring in the first quarter of each fiscal year, coinciding with the holiday sales season. Revenue values in these peak quarters range between approximately 13.4 billion and 16.9 billion US dollars. Outside these peak quarters, revenue stabilizes around 8.5 to 10 billion US dollars. Over the entire period observed, there is a general upward trend in revenue peaks, with some fluctuations in the off-peak quarters. For instance, from Apr 30, 2016, to Jan 29, 2022, peak quarter revenues generally increase slightly, although intermittent declines are seen in the most recent quarters ending Apr 30, 2022, and Jul 30, 2022.
Property and Equipment (Net) Trends
The net value of property and equipment remains relatively stable across the periods observed from Apr 30, 2016, to Oct 29, 2018, fluctuating narrowly around 2.3 to 2.5 billion US dollars. However, from May 4, 2019, a substantial increase is noted, where values approximately double to around 5 billion US dollars and remain near this level through to the last period ending Oct 29, 2022. This marked increase suggests either significant asset acquisitions or a change in accounting treatment, possibly related to including right-of-use assets due to lease accounting changes.
Net Fixed Asset Turnover (Including Operating Lease, Right-of-Use Asset)
The net fixed asset turnover ratio shows markedly different levels in two distinct periods. Initially, in the quarters before and including Feb 2, 2019, the ratio is very high, ranging generally between 17.08 and 17.92. Subsequently, starting from May 4, 2019, the ratio drops sharply to values between approximately 8.39 and 10.68, indicating a decrease in revenue generated per unit of net fixed asset. This shift aligns with the timing of the significant increase in property and equipment net values, suggesting an increase in asset base size without a proportional increase in revenue, possibly due to changes in lease accounting impacting the asset base.
Insight Summary
Overall, the data reflects a business with strong seasonal revenue patterns and a stable asset base through early periods, followed by an accounting or operational change causing a significant rise in reported net property and equipment. This change affects asset turnover ratios, reducing efficiency metrics when calculated using newly capitalized lease assets. Revenue growth, while present, is moderate considering the increase in asset base, indicating the necessity to evaluate the impacts of accounting changes separately from operational performance. The recent quarters show some softening in revenue levels, warranting further monitoring of market conditions and operational effectiveness.

Total Asset Turnover

Best Buy Co. Inc., total asset turnover calculation (quarterly data)

Microsoft Excel
Oct 29, 2022 Jul 30, 2022 Apr 30, 2022 Jan 29, 2022 Oct 30, 2021 Jul 31, 2021 May 1, 2021 Jan 30, 2021 Oct 31, 2020 Aug 1, 2020 May 2, 2020 Feb 1, 2020 Nov 2, 2019 Aug 3, 2019 May 4, 2019 Feb 2, 2019 Nov 3, 2018 Aug 4, 2018 May 5, 2018 Feb 3, 2018 Oct 28, 2017 Jul 29, 2017 Apr 29, 2017 Jan 28, 2017 Oct 29, 2016 Jul 30, 2016 Apr 30, 2016
Selected Financial Data (US$ in millions)
Revenue
Total assets
Long-term Activity Ratio
Total asset turnover1
Benchmarks
Total Asset Turnover, Competitors2
Amazon.com Inc.
Home Depot Inc.
Lowe’s Cos. Inc.
TJX Cos. Inc.

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), 10-K (reporting date: 2017-01-28), 10-Q (reporting date: 2016-10-29), 10-Q (reporting date: 2016-07-30), 10-Q (reporting date: 2016-04-30).

1 Q3 2023 Calculation
Total asset turnover = (RevenueQ3 2023 + RevenueQ2 2023 + RevenueQ1 2023 + RevenueQ4 2022) ÷ Total assets
= ( + + + ) ÷ =

2 Click competitor name to see calculations.


The revenue data demonstrates a recurring seasonal pattern with notable peaks in the first quarter of each fiscal year (January to March period). These peaks correspond to the highest revenue points observed in the respective years, indicating strong sales performance in these quarters, likely driven by holiday season sales and promotions. Between these peaks, revenue declines in the subsequent quarters, showing typical seasonal fluctuations. Over the multi-year period, the revenue trend remains relatively consistent with some growth in peak quarters, though the amplitude of seasonal variation fluctuates.

Total assets exhibit a general upward trend with some periodic declines. Initial years reveal moderate growth in total assets, followed by a sharper increase beginning around late 2019 into 2020, reaching a peak during the pandemic period (2020). This growth in assets could reflect strategic investments, increased inventory, or capital expenditures aligned with changing market conditions. After the peak, total assets saw a decline in 2021 and 2022 but remained above earlier years' levels, suggesting an adjustment phase or asset optimization.

The total asset turnover ratio, which measures how efficiently the company uses its assets to generate revenue, shows significant fluctuation across the quarters. The ratio tends to peak around fiscal first quarters, aligning with revenue peaks, but it demonstrates a decreasing trend from 2016 through to 2020. This decline suggests that despite increasing asset bases, the efficiency in utilizing these assets to produce sales has diminished over this period. However, from mid-2021 onwards, the ratio shows some recovery, indicating improved asset utilization efficiency. The oscillation of this ratio likely reflects changes in sales volume relative to asset levels and may indicate variations in operational effectiveness throughout the fiscal cycles.

In summary, the data reveals a company affected by strong seasonality in revenue, a steadily increasing but volatile asset base with significant growth during the pandemic, and fluctuating but somewhat improving asset utilization efficiency in recent periods. The patterns suggest adaptive operational strategies in response to market conditions and changes in consumer behavior, with potential ongoing efforts to enhance asset productivity following investment expansions.


Equity Turnover

Best Buy Co. Inc., equity turnover calculation (quarterly data)

Microsoft Excel
Oct 29, 2022 Jul 30, 2022 Apr 30, 2022 Jan 29, 2022 Oct 30, 2021 Jul 31, 2021 May 1, 2021 Jan 30, 2021 Oct 31, 2020 Aug 1, 2020 May 2, 2020 Feb 1, 2020 Nov 2, 2019 Aug 3, 2019 May 4, 2019 Feb 2, 2019 Nov 3, 2018 Aug 4, 2018 May 5, 2018 Feb 3, 2018 Oct 28, 2017 Jul 29, 2017 Apr 29, 2017 Jan 28, 2017 Oct 29, 2016 Jul 30, 2016 Apr 30, 2016
Selected Financial Data (US$ in millions)
Revenue
Equity
Long-term Activity Ratio
Equity turnover1
Benchmarks
Equity Turnover, Competitors2
Amazon.com Inc.
Home Depot Inc.
Lowe’s Cos. Inc.
TJX Cos. Inc.

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), 10-K (reporting date: 2017-01-28), 10-Q (reporting date: 2016-10-29), 10-Q (reporting date: 2016-07-30), 10-Q (reporting date: 2016-04-30).

1 Q3 2023 Calculation
Equity turnover = (RevenueQ3 2023 + RevenueQ2 2023 + RevenueQ1 2023 + RevenueQ4 2022) ÷ Equity
= ( + + + ) ÷ =

2 Click competitor name to see calculations.


The analyzed financial data reveals several notable trends regarding revenue, equity, and equity turnover over the observed periods.

Revenue

Revenue demonstrates a pronounced seasonal pattern, with significant increases consistently appearing in the first fiscal quarter of each year (January through March), corresponding to holiday sales and post-holiday periods. For example, revenue peaks in early 2017 (Jan 28, 2017: 13,482 million USD), early 2018 (Feb 3, 2018: 15,363 million USD), early 2019 (Feb 2, 2019: 14,801 million USD), early 2020 (Feb 1, 2020: 15,196 million USD), early 2021 (Jan 30, 2021: 16,937 million USD), and early 2022 (Jan 29, 2022: 16,365 million USD).

Aside from these peaks, revenue in other quarters remains relatively steady but shows moderate growth over the years. However, there is an observable dip around the second quarter of 2020 (May 2, 2020: 8,562 million USD) likely influenced by external macroeconomic factors impacting business operations during that period.

Overall, revenue shows long-term growth with fluctuations related to seasonal factors, maintaining a strong performance through successive fiscal years.

Equity

Equity levels follow a generally declining trend from 2016 through early 2019, dropping from 4,426 million USD in April 2016 to a low of 3,012 million USD in November 2018. This decrease may reflect increased shareholder distributions, share repurchases, or other financial strategies impacting equity.

From early 2019 onward, equity stabilizes with minor fluctuations and a slight recovery up to 4,587 million USD in January 2021, followed by a subsequent decline into 2022, reaching approximately 2,992 million USD by October 2022. The overall trend suggests a reduction in equity base over the long term, with intermittent periods of recovery.

Equity Turnover

Equity turnover begins being recorded in January 2017, starting at 8.37 and generally rising throughout the period observed. This ratio peaks around the beginning of 2022 (January 29, 2022: 17.14), indicating an increasing efficiency in using equity to generate revenue.

There is a notable spike in equity turnover in mid-2022 (July 30, 2022: 18.35), followed by a slight decline later in the year, yet remaining at elevated levels compared to earlier years. The rising trend in equity turnover, coupled with the declining equity base, suggests enhanced asset utilization effectiveness and potentially improved operational performance.

In summary, revenue exhibits clear seasonality with growth over time, equity shows a prominent declining trend with periods of stabilization, and equity turnover increases significantly, indicating improved capital utilization. These patterns collectively suggest a focus on optimizing resource use while maintaining revenue growth despite a shrinking equity base.