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 Liquidity Ratios 
Quarterly Data

Microsoft Excel

Liquidity Ratios (Summary)

Best Buy Co. Inc., liquidity 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
Current ratio 0.98 0.96 0.96 0.99 1.13 1.16 1.17 1.19 1.12 1.06 1.02 1.10 1.05 1.08 1.12 1.18 1.10 1.21 1.27 1.26 1.25 1.42 1.49 1.48 1.35 1.43 1.47
Quick ratio 0.19 0.19 0.17 0.37 0.38 0.50 0.54 0.62 0.52 0.62 0.53 0.42 0.23 0.34 0.33 0.40 0.22 0.45 0.50 0.53 0.47 0.63 0.71 0.74 0.53 0.64 0.66
Cash ratio 0.09 0.10 0.07 0.28 0.29 0.42 0.45 0.52 0.44 0.53 0.45 0.28 0.12 0.21 0.22 0.26 0.13 0.32 0.37 0.40 0.36 0.49 0.56 0.55 0.38 0.51 0.48

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

Liquidity ratio Description The company
Current ratio A liquidity ratio calculated as current assets divided by current liabilities. Best Buy Co. Inc. current ratio improved from Q1 2023 to Q2 2023 and from Q2 2023 to Q3 2023.
Quick ratio A liquidity ratio calculated as (cash plus short-term marketable investments plus receivables) divided by current liabilities. Best Buy Co. Inc. quick ratio improved from Q1 2023 to Q2 2023 and from Q2 2023 to Q3 2023.
Cash ratio A liquidity ratio calculated as (cash plus short-term marketable investments) divided by current liabilities. Best Buy Co. Inc. cash ratio improved from Q1 2023 to Q2 2023 but then slightly deteriorated from Q2 2023 to Q3 2023.

Current Ratio

Best Buy Co. Inc., current ratio 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)
Current assets 9,922 8,344 8,315 10,539 13,520 12,040 11,268 12,540 14,551 10,683 8,996 8,857 10,175 8,192 8,014 8,870 10,901 8,771 8,930 9,829 11,405 10,078 9,656 10,516 11,021 9,694 9,282
Current liabilities 10,170 8,650 8,635 10,674 11,946 10,357 9,641 10,521 12,945 10,080 8,804 8,060 9,726 7,576 7,171 7,513 9,933 7,229 7,055 7,817 9,152 7,105 6,470 7,122 8,166 6,800 6,334
Liquidity Ratio
Current ratio1 0.98 0.96 0.96 0.99 1.13 1.16 1.17 1.19 1.12 1.06 1.02 1.10 1.05 1.08 1.12 1.18 1.10 1.21 1.27 1.26 1.25 1.42 1.49 1.48 1.35 1.43 1.47
Benchmarks
Current Ratio, Competitors2
Amazon.com Inc. 0.98 0.95 0.92 0.94 0.94 0.95 0.96 1.14 1.12 1.20 1.05 1.05 1.11 1.18 1.08 1.10 1.10 1.10 1.09
Home Depot Inc. 1.39 1.18 1.11 1.01 1.13 1.06 1.10 1.23 1.36 1.30 1.17 1.08 1.08 1.10 1.04 1.11 1.09 1.13 1.17
Lowe’s Cos. Inc. 1.20 1.11 1.17 1.02 1.19 1.16 1.17 1.19 1.38 1.30 1.20 1.01 1.04 1.06 1.09 0.98 1.00 1.06 1.02
TJX Cos. Inc. 1.16 1.17 1.25 1.27 1.29 1.33 1.52 1.46 1.41 1.51 2.20 1.24 1.22 1.25 1.23 1.53 1.55 1.64 1.69

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
Current ratio = Current assets ÷ Current liabilities
= 9,922 ÷ 10,170 = 0.98

2 Click competitor name to see calculations.

Liquidity ratio Description The company
Current ratio A liquidity ratio calculated as current assets divided by current liabilities. Best Buy Co. Inc. current ratio improved from Q1 2023 to Q2 2023 and from Q2 2023 to Q3 2023.

Quick Ratio

Best Buy Co. Inc., quick ratio 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)
Cash and cash equivalents 932 840 640 2,936 3,465 4,340 4,278 5,494 5,136 5,305 3,919 2,229 1,205 1,289 1,561 1,980 1,228 1,865 1,848 1,101 1,103 1,365 1,651 2,240 1,341 1,861 1,845
Short-term investments 60 545 320 76 465 785 2,032 2,237 2,125 1,948 1,681 1,777 1,590 1,220
Receivables, net 1,050 840 804 1,042 1,016 883 850 1,061 1,028 906 749 1,149 1,056 966 833 1,015 921 915 860 1,049 971 965 1,011 1,347 1,174 926 1,097
Total quick assets 1,982 1,680 1,444 3,978 4,481 5,223 5,188 6,555 6,709 6,211 4,668 3,378 2,261 2,575 2,394 2,995 2,225 3,245 3,493 4,182 4,311 4,455 4,610 5,268 4,292 4,377 4,162
 
Current liabilities 10,170 8,650 8,635 10,674 11,946 10,357 9,641 10,521 12,945 10,080 8,804 8,060 9,726 7,576 7,171 7,513 9,933 7,229 7,055 7,817 9,152 7,105 6,470 7,122 8,166 6,800 6,334
Liquidity Ratio
Quick ratio1 0.19 0.19 0.17 0.37 0.38 0.50 0.54 0.62 0.52 0.62 0.53 0.42 0.23 0.34 0.33 0.40 0.22 0.45 0.50 0.53 0.47 0.63 0.71 0.74 0.53 0.64 0.66
Benchmarks
Quick Ratio, Competitors2
Amazon.com Inc. 0.44 0.43 0.44 0.45 0.42 0.43 0.48 0.68 0.64 0.76 0.63 0.67 0.67 0.76 0.62 0.63 0.60 0.60 0.58
Home Depot Inc. 0.26 0.18 0.22 0.20 0.32 0.30 0.37 0.47 0.68 0.69 0.48 0.23 0.23 0.26 0.21 0.22 0.22 0.31 0.33
Lowe’s Cos. Inc. 0.18 0.09 0.17 0.07 0.32 0.29 0.31 0.28 0.52 0.60 0.34 0.06 0.06 0.13 0.18 0.05 0.12 0.18 0.11
TJX Cos. Inc. 0.35 0.40 0.49 0.64 0.65 0.77 0.95 1.01 0.93 0.92 0.96 0.50 0.33 0.39 0.40 0.61 0.52 0.63 0.70

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
Quick ratio = Total quick assets ÷ Current liabilities
= 1,982 ÷ 10,170 = 0.19

2 Click competitor name to see calculations.

Liquidity ratio Description The company
Quick ratio A liquidity ratio calculated as (cash plus short-term marketable investments plus receivables) divided by current liabilities. Best Buy Co. Inc. quick ratio improved from Q1 2023 to Q2 2023 and from Q2 2023 to Q3 2023.

Cash Ratio

Best Buy Co. Inc., cash ratio 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)
Cash and cash equivalents 932 840 640 2,936 3,465 4,340 4,278 5,494 5,136 5,305 3,919 2,229 1,205 1,289 1,561 1,980 1,228 1,865 1,848 1,101 1,103 1,365 1,651 2,240 1,341 1,861 1,845
Short-term investments 60 545 320 76 465 785 2,032 2,237 2,125 1,948 1,681 1,777 1,590 1,220
Total cash assets 932 840 640 2,936 3,465 4,340 4,338 5,494 5,681 5,305 3,919 2,229 1,205 1,609 1,561 1,980 1,304 2,330 2,633 3,133 3,340 3,490 3,599 3,921 3,118 3,451 3,065
 
Current liabilities 10,170 8,650 8,635 10,674 11,946 10,357 9,641 10,521 12,945 10,080 8,804 8,060 9,726 7,576 7,171 7,513 9,933 7,229 7,055 7,817 9,152 7,105 6,470 7,122 8,166 6,800 6,334
Liquidity Ratio
Cash ratio1 0.09 0.10 0.07 0.28 0.29 0.42 0.45 0.52 0.44 0.53 0.45 0.28 0.12 0.21 0.22 0.26 0.13 0.32 0.37 0.40 0.36 0.49 0.56 0.55 0.38 0.51 0.48
Benchmarks
Cash Ratio, Competitors2
Amazon.com Inc. 0.44 0.43 0.44 0.45 0.42 0.43 0.48 0.68 0.64 0.76 0.63 0.67 0.67 0.76 0.62 0.63 0.60 0.60 0.58
Home Depot Inc. 0.10 0.05 0.09 0.08 0.19 0.17 0.24 0.34 0.58 0.58 0.37 0.12 0.11 0.14 0.10 0.11 0.10 0.19 0.20
Lowe’s Cos. Inc. 0.18 0.09 0.17 0.07 0.32 0.29 0.31 0.28 0.52 0.60 0.34 0.06 0.06 0.13 0.18 0.05 0.12 0.18 0.11
TJX Cos. Inc. 0.30 0.35 0.43 0.59 0.60 0.71 0.89 0.97 0.90 0.87 0.92 0.45 0.27 0.33 0.34 0.55 0.45 0.56 0.63

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
Cash ratio = Total cash assets ÷ Current liabilities
= 932 ÷ 10,170 = 0.09

2 Click competitor name to see calculations.

Liquidity ratio Description The company
Cash ratio A liquidity ratio calculated as (cash plus short-term marketable investments) divided by current liabilities. Best Buy Co. Inc. cash ratio improved from Q1 2023 to Q2 2023 but then slightly deteriorated from Q2 2023 to Q3 2023.