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.

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

Microsoft Excel

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 20.20 21.24 22.55 23.00 23.20 23.48 22.54 20.91 20.10 19.07 18.79 18.74 18.33 18.24 18.39 17.08 17.20 17.75 17.92 17.41 17.12 17.14 17.27 17.18
Net fixed asset turnover (including operating lease, right-of-use asset) 9.27 9.63 10.25 10.55 10.59 10.68 10.50 9.70 9.18 8.61 8.75 8.66 8.46 8.39 8.51 17.08 17.20 17.75 17.92 17.41 17.12 17.14 17.27 17.18
Total asset turnover 2.82 3.19 3.33 2.96 2.60 2.81 2.84 2.48 2.15 2.49 2.76 2.80 2.55 2.88 2.95 3.32 2.90 3.60 3.54 3.23 2.72 2.97 3.05 2.84
Equity turnover 16.01 17.03 18.35 17.14 12.23 12.06 12.11 10.30 11.14 11.50 12.63 12.54 13.84 13.11 12.79 12.97 14.42 13.55 12.49 11.67 9.70 9.18 8.78 8.37

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).

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Best Buy Co. Inc. net fixed asset turnover ratio deteriorated from Q1 2023 to Q2 2023 and from Q2 2023 to Q3 2023.
Net fixed asset turnover (including operating lease, right-of-use asset) An activity ratio calculated as total revenue divided by net fixed assets (including operating lease, right-of-use asset). Best Buy Co. Inc. net fixed asset turnover ratio (with operating lease, right-of-use asset) deteriorated from Q1 2023 to Q2 2023 and from Q2 2023 to Q3 2023.
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Best Buy Co. Inc. total asset turnover ratio deteriorated from Q1 2023 to Q2 2023 and from Q2 2023 to Q3 2023.
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Best Buy Co. Inc. equity turnover ratio deteriorated from Q1 2023 to Q2 2023 and from Q2 2023 to Q3 2023.

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 10,587 10,329 10,647 16,365 11,910 11,849 11,637 16,937 11,853 9,910 8,562 15,196 9,764 9,536 9,142 14,801 9,590 9,379 9,109 15,363 9,320 8,940 8,528 13,482 8,945 8,533 8,443
Property and equipment, net 2,373 2,319 2,251 2,250 2,256 2,226 2,233 2,260 2,265 2,277 2,291 2,328 2,359 2,361 2,334 2,510 2,525 2,432 2,385 2,421 2,352 2,327 2,287 2,293 2,298 2,295 2,332
Long-term Activity Ratio
Net fixed asset turnover1 20.20 21.24 22.55 23.00 23.20 23.48 22.54 20.91 20.10 19.07 18.79 18.74 18.33 18.24 18.39 17.08 17.20 17.75 17.92 17.41 17.12 17.14 17.27 17.18
Benchmarks
Net Fixed Asset Turnover, Competitors2
Amazon.com Inc. 2.82 2.78 2.75 2.75 2.83 2.80 2.84 2.93 3.11 3.32 3.45 3.41 3.48 3.72 3.81 3.86
Home Depot Inc. 6.23 6.15 6.06 6.00 5.92 5.83 5.73 5.35 5.27 5.10 4.94 4.84 4.94 4.91 4.92 4.84
Lowe’s Cos. Inc. 5.55 5.10 5.05 5.05 5.03 4.97 4.95 4.68 4.57 4.32 4.00 3.86 3.91 3.94 3.95 3.87
TJX Cos. Inc. 8.84 9.21 9.43 9.21 8.84 8.46 7.46 6.38 6.67 6.61 7.08 7.83 7.74 7.94 7.88 7.42

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
= (10,587 + 10,329 + 10,647 + 16,365) ÷ 2,373 = 20.20

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Best Buy Co. Inc. net fixed asset turnover ratio deteriorated from Q1 2023 to Q2 2023 and from Q2 2023 to Q3 2023.

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 10,587 10,329 10,647 16,365 11,910 11,849 11,637 16,937 11,853 9,910 8,562 15,196 9,764 9,536 9,142 14,801 9,590 9,379 9,109 15,363 9,320 8,940 8,528 13,482 8,945 8,533 8,443
 
Property and equipment, net 2,373 2,319 2,251 2,250 2,256 2,226 2,233 2,260 2,265 2,277 2,291 2,328 2,359 2,361 2,334 2,510 2,525 2,432 2,385 2,421 2,352 2,327 2,287 2,293 2,298 2,295 2,332
Operating lease assets 2,799 2,796 2,704 2,654 2,688 2,670 2,563 2,612 2,692 2,770 2,631 2,709 2,751 2,774 2,708
Property and equipment, net (including operating lease, right-of-use asset) 5,172 5,115 4,955 4,904 4,944 4,896 4,796 4,872 4,957 5,047 4,922 5,037 5,110 5,135 5,042 2,510 2,525 2,432 2,385 2,421 2,352 2,327 2,287 2,293 2,298 2,295 2,332
Long-term Activity Ratio
Net fixed asset turnover (including operating lease, right-of-use asset)1 9.27 9.63 10.25 10.55 10.59 10.68 10.50 9.70 9.18 8.61 8.75 8.66 8.46 8.39 8.51 17.08 17.20 17.75 17.92 17.41 17.12 17.14 17.27 17.18
Benchmarks
Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset), Competitors2
Amazon.com Inc. 2.07 2.04 2.03 2.03 2.10 2.09 2.13 2.17 2.30 2.51 2.61 2.56 2.59 2.80 2.85 2.87
Home Depot Inc. 4.95 4.95 4.90 4.85 4.79 4.70 4.63 4.31 4.29 4.14 3.96 3.89 3.95 3.90 3.93 4.84
Lowe’s Cos. Inc. 4.62 4.17 4.15 4.15 4.12 4.14 4.11 3.90 3.79 3.59 3.31 3.20 3.23 3.24 3.25 3.87
TJX Cos. Inc. 3.38 3.45 3.47 3.44 3.19 3.02 2.66 2.29 2.38 2.38 2.58 2.90 2.84 2.86 2.86 7.42

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)
= (10,587 + 10,329 + 10,647 + 16,365) ÷ 5,172 = 9.27

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Net fixed asset turnover (including operating lease, right-of-use asset) An activity ratio calculated as total revenue divided by net fixed assets (including operating lease, right-of-use asset). Best Buy Co. Inc. net fixed asset turnover ratio (with operating lease, right-of-use asset) deteriorated from Q1 2023 to Q2 2023 and from Q2 2023 to Q3 2023.

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 10,587 10,329 10,647 16,365 11,910 11,849 11,637 16,937 11,853 9,910 8,562 15,196 9,764 9,536 9,142 14,801 9,590 9,379 9,109 15,363 9,320 8,940 8,528 13,482 8,945 8,533 8,443
Total assets 17,021 15,419 15,251 17,504 20,102 18,579 17,705 19,067 21,202 17,412 15,605 15,591 16,926 14,978 14,550 12,901 15,000 11,993 12,082 13,049 14,785 13,444 12,955 13,856 14,542 13,254 12,901
Long-term Activity Ratio
Total asset turnover1 2.82 3.19 3.33 2.96 2.60 2.81 2.84 2.48 2.15 2.49 2.76 2.80 2.55 2.88 2.95 3.32 2.90 3.60 3.54 3.23 2.72 2.97 3.05 2.84
Benchmarks
Total Asset Turnover, Competitors2
Amazon.com Inc. 1.14 1.13 1.13 1.11 1.17 1.16 1.16 1.12 1.20 1.23 1.30 1.20 1.23 1.25 1.34 1.25
Home Depot Inc. 2.05 2.05 1.99 2.10 2.02 2.04 1.95 1.87 1.88 1.88 1.91 2.15 2.12 2.12 2.13 2.46
Lowe’s Cos. Inc. 2.04 2.04 1.92 2.16 1.93 1.92 1.84 1.92 1.68 1.55 1.62 1.83 1.80 1.76 1.66 2.07
TJX Cos. Inc. 1.73 1.83 1.80 1.71 1.52 1.50 1.25 1.04 1.06 1.27 1.45 1.73 1.67 1.75 1.76 2.72

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
= (10,587 + 10,329 + 10,647 + 16,365) ÷ 17,021 = 2.82

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Best Buy Co. Inc. total asset turnover ratio deteriorated from Q1 2023 to Q2 2023 and from Q2 2023 to Q3 2023.

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 10,587 10,329 10,647 16,365 11,910 11,849 11,637 16,937 11,853 9,910 8,562 15,196 9,764 9,536 9,142 14,801 9,590 9,379 9,109 15,363 9,320 8,940 8,528 13,482 8,945 8,533 8,443
Equity 2,993 2,892 2,767 3,020 4,278 4,335 4,158 4,587 4,086 3,778 3,410 3,479 3,125 3,285 3,354 3,306 3,012 3,186 3,420 3,612 4,152 4,347 4,499 4,709 4,261 4,319 4,426
Long-term Activity Ratio
Equity turnover1 16.01 17.03 18.35 17.14 12.23 12.06 12.11 10.30 11.14 11.50 12.63 12.54 13.84 13.11 12.79 12.97 14.42 13.55 12.49 11.67 9.70 9.18 8.78 8.37
Benchmarks
Equity Turnover, Competitors2
Amazon.com Inc. 3.03 3.19 3.40 3.52 3.65 3.70 3.57 3.40 3.80 3.86 4.06 4.13 4.20 4.36 4.54 4.52
Home Depot Inc. 121.18 655.02 142.70 69.80 80.86 40.05 81.84
Lowe’s Cos. Inc. 212.01 62.35 20.95 18.46 43.17 36.59 29.20 27.19 22.15 19.57
TJX Cos. Inc. 8.70 9.20 8.91 8.09 7.08 6.75 6.16 5.51 6.00 7.24 7.78 7.01 7.33 7.55 7.71 7.72

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
= (10,587 + 10,329 + 10,647 + 16,365) ÷ 2,993 = 16.01

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Best Buy Co. Inc. equity turnover ratio deteriorated from Q1 2023 to Q2 2023 and from Q2 2023 to Q3 2023.