Analysis of Liquidity Ratios
Quarterly Data
Liquidity ratios measure the company ability to meet its short-term obligations.
Liquidity Ratios (Summary)
Dollar Tree Inc., liquidity ratios (quarterly data)
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. | Dollar Tree Inc. current ratio deteriorated 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. | Dollar Tree Inc. quick ratio deteriorated 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. | Dollar Tree Inc. cash ratio deteriorated from Q1 2023 to Q2 2023 and from Q2 2023 to Q3 2023. |
Current Ratio
Dollar Tree Inc., current ratio calculation (quarterly data)
| 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 thousands) | |||||||||||||||||||||||||||||||||||
| Current assets | 6,446,600) | 6,377,300) | 6,282,300) | 5,609,200) | 5,374,500) | 4,648,100) | 5,304,900) | 5,050,800) | 5,171,000) | 5,232,500) | 5,165,400) | 4,269,400) | 4,572,300) | 4,340,800) | 4,246,100) | 4,293,300) | 4,749,500) | 4,272,800) | 4,042,000) | 4,576,300) | 3,972,600) | 3,815,200) | 4,278,100) | 3,938,000) | 4,342,400) | 4,449,400) | 4,172,100) | ||||||||
| Current liabilities | 4,683,100) | 4,380,500) | 4,289,900) | 4,176,600) | 4,291,200) | 3,722,700) | 3,902,200) | 3,730,300) | 4,042,300) | 4,278,800) | 4,504,200) | 3,546,500) | 4,179,700) | 4,094,000) | 3,979,300) | 2,095,700) | 2,135,700) | 1,907,400) | 1,917,200) | 2,859,100) | 2,039,900) | 2,084,700) | 2,240,600) | 2,105,900) | 2,134,200) | 2,180,000) | 2,049,100) | ||||||||
| Liquidity Ratio | |||||||||||||||||||||||||||||||||||
| Current ratio1 | 1.38 | 1.46 | 1.46 | 1.34 | 1.25 | 1.25 | 1.36 | 1.35 | 1.28 | 1.22 | 1.15 | 1.20 | 1.09 | 1.06 | 1.07 | 2.05 | 2.22 | 2.24 | 2.11 | 1.60 | 1.95 | 1.83 | 1.91 | 1.87 | 2.03 | 2.04 | 2.04 | ||||||||
| Benchmarks | |||||||||||||||||||||||||||||||||||
| Current Ratio, Competitors2 | |||||||||||||||||||||||||||||||||||
| Costco Wholesale Corp. | 1.08 | 1.06 | 1.03 | 1.02 | 1.04 | 1.03 | 1.02 | 1.00 | 1.00 | 0.99 | 0.98 | 1.13 | 1.11 | 1.04 | 1.01 | 1.01 | 0.98 | 0.96 | 1.02 | — | — | — | — | — | — | — | — | ||||||||
| Dollar General Corp. | 1.23 | 1.02 | 0.97 | 1.05 | 1.08 | 1.09 | 1.14 | 1.21 | 1.28 | 1.40 | 1.44 | 1.14 | 1.12 | 1.14 | 1.16 | 1.55 | 1.55 | 1.55 | 1.65 | — | — | — | — | — | — | — | — | ||||||||
| Target Corp. | 0.86 | 0.82 | 0.87 | 0.99 | 0.97 | 1.04 | 1.07 | 1.03 | 1.05 | 1.11 | 1.01 | 0.89 | 0.83 | 0.84 | 0.88 | 0.83 | 0.83 | 0.82 | 0.90 | — | — | — | — | — | — | — | — | ||||||||
| Walmart Inc. | 0.86 | 0.84 | 0.86 | 0.93 | 0.95 | 0.96 | 0.95 | 0.97 | 0.84 | 0.79 | 0.77 | 0.79 | 0.81 | 0.76 | 0.77 | 0.80 | 0.81 | 0.93 | 0.73 | — | — | — | — | — | — | — | — | ||||||||
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
= 6,446,600 ÷ 4,683,100 = 1.38
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. | Dollar Tree Inc. current ratio deteriorated from Q1 2023 to Q2 2023 and from Q2 2023 to Q3 2023. |
Quick Ratio
Dollar Tree Inc., quick ratio calculation (quarterly data)
| 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 thousands) | |||||||||||||||||||||||||||||||||||
| Cash and cash equivalents | 439,000) | 688,900) | 1,218,500) | 984,900) | 701,400) | 720,800) | 1,473,900) | 1,416,700) | 1,118,300) | 1,750,300) | 1,755,100) | 539,200) | 433,700) | 623,400) | 725,800) | 422,100) | 708,300) | 647,300) | 475,200) | 1,097,800) | 400,100) | 693,300) | 1,154,900) | 866,400) | 733,800) | 1,093,200) | 929,700) | ||||||||
| Short-term investments | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | 4,000) | 4,000) | 4,000) | 4,000) | 4,000) | 4,000) | ||||||||
| Total quick assets | 439,000) | 688,900) | 1,218,500) | 984,900) | 701,400) | 720,800) | 1,473,900) | 1,416,700) | 1,118,300) | 1,750,300) | 1,755,100) | 539,200) | 433,700) | 623,400) | 725,800) | 422,100) | 708,300) | 647,300) | 475,200) | 1,097,800) | 400,100) | 697,300) | 1,158,900) | 870,400) | 737,800) | 1,097,200) | 933,700) | ||||||||
| Current liabilities | 4,683,100) | 4,380,500) | 4,289,900) | 4,176,600) | 4,291,200) | 3,722,700) | 3,902,200) | 3,730,300) | 4,042,300) | 4,278,800) | 4,504,200) | 3,546,500) | 4,179,700) | 4,094,000) | 3,979,300) | 2,095,700) | 2,135,700) | 1,907,400) | 1,917,200) | 2,859,100) | 2,039,900) | 2,084,700) | 2,240,600) | 2,105,900) | 2,134,200) | 2,180,000) | 2,049,100) | ||||||||
| Liquidity Ratio | |||||||||||||||||||||||||||||||||||
| Quick ratio1 | 0.09 | 0.16 | 0.28 | 0.24 | 0.16 | 0.19 | 0.38 | 0.38 | 0.28 | 0.41 | 0.39 | 0.15 | 0.10 | 0.15 | 0.18 | 0.20 | 0.33 | 0.34 | 0.25 | 0.38 | 0.20 | 0.33 | 0.52 | 0.41 | 0.35 | 0.50 | 0.46 | ||||||||
| Benchmarks | |||||||||||||||||||||||||||||||||||
| Quick Ratio, Competitors2 | |||||||||||||||||||||||||||||||||||
| Costco Wholesale Corp. | 0.51 | 0.50 | 0.42 | 0.42 | 0.43 | 0.46 | 0.46 | 0.47 | 0.45 | 0.42 | 0.49 | 0.60 | 0.58 | 0.47 | 0.45 | 0.47 | 0.43 | 0.41 | 0.43 | — | — | — | — | — | — | — | — | ||||||||
| Dollar General Corp. | 0.06 | 0.04 | 0.05 | 0.06 | 0.09 | 0.06 | 0.13 | 0.24 | 0.37 | 0.55 | 0.55 | 0.05 | 0.06 | 0.06 | 0.07 | 0.08 | 0.09 | 0.09 | 0.11 | — | — | — | — | — | — | — | — | ||||||||
| Target Corp. | 0.04 | 0.05 | 0.05 | 0.27 | 0.25 | 0.38 | 0.42 | 0.42 | 0.31 | 0.46 | 0.32 | 0.18 | 0.06 | 0.12 | 0.09 | 0.10 | 0.05 | 0.08 | 0.09 | — | — | — | — | — | — | — | — | ||||||||
| Walmart Inc. | 0.20 | 0.21 | 0.20 | 0.26 | 0.27 | 0.36 | 0.35 | 0.26 | 0.23 | 0.27 | 0.24 | 0.20 | 0.17 | 0.18 | 0.18 | 0.18 | 0.17 | 0.29 | 0.15 | — | — | — | — | — | — | — | — | ||||||||
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
= 439,000 ÷ 4,683,100 = 0.09
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. | Dollar Tree Inc. quick ratio deteriorated from Q1 2023 to Q2 2023 and from Q2 2023 to Q3 2023. |
Cash Ratio
Dollar Tree Inc., cash ratio calculation (quarterly data)
| 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 thousands) | |||||||||||||||||||||||||||||||||||
| Cash and cash equivalents | 439,000) | 688,900) | 1,218,500) | 984,900) | 701,400) | 720,800) | 1,473,900) | 1,416,700) | 1,118,300) | 1,750,300) | 1,755,100) | 539,200) | 433,700) | 623,400) | 725,800) | 422,100) | 708,300) | 647,300) | 475,200) | 1,097,800) | 400,100) | 693,300) | 1,154,900) | 866,400) | 733,800) | 1,093,200) | 929,700) | ||||||||
| Short-term investments | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | 4,000) | 4,000) | 4,000) | 4,000) | 4,000) | 4,000) | ||||||||
| Total cash assets | 439,000) | 688,900) | 1,218,500) | 984,900) | 701,400) | 720,800) | 1,473,900) | 1,416,700) | 1,118,300) | 1,750,300) | 1,755,100) | 539,200) | 433,700) | 623,400) | 725,800) | 422,100) | 708,300) | 647,300) | 475,200) | 1,097,800) | 400,100) | 697,300) | 1,158,900) | 870,400) | 737,800) | 1,097,200) | 933,700) | ||||||||
| Current liabilities | 4,683,100) | 4,380,500) | 4,289,900) | 4,176,600) | 4,291,200) | 3,722,700) | 3,902,200) | 3,730,300) | 4,042,300) | 4,278,800) | 4,504,200) | 3,546,500) | 4,179,700) | 4,094,000) | 3,979,300) | 2,095,700) | 2,135,700) | 1,907,400) | 1,917,200) | 2,859,100) | 2,039,900) | 2,084,700) | 2,240,600) | 2,105,900) | 2,134,200) | 2,180,000) | 2,049,100) | ||||||||
| Liquidity Ratio | |||||||||||||||||||||||||||||||||||
| Cash ratio1 | 0.09 | 0.16 | 0.28 | 0.24 | 0.16 | 0.19 | 0.38 | 0.38 | 0.28 | 0.41 | 0.39 | 0.15 | 0.10 | 0.15 | 0.18 | 0.20 | 0.33 | 0.34 | 0.25 | 0.38 | 0.20 | 0.33 | 0.52 | 0.41 | 0.35 | 0.50 | 0.46 | ||||||||
| Benchmarks | |||||||||||||||||||||||||||||||||||
| Cash Ratio, Competitors2 | |||||||||||||||||||||||||||||||||||
| Costco Wholesale Corp. | 0.43 | 0.42 | 0.35 | 0.35 | 0.37 | 0.39 | 0.40 | 0.41 | 0.40 | 0.35 | 0.44 | 0.54 | 0.52 | 0.38 | 0.38 | 0.41 | 0.36 | 0.32 | 0.35 | — | — | — | — | — | — | — | — | ||||||||
| Dollar General Corp. | 0.06 | 0.04 | 0.05 | 0.06 | 0.09 | 0.06 | 0.13 | 0.24 | 0.37 | 0.55 | 0.55 | 0.05 | 0.06 | 0.06 | 0.07 | 0.08 | 0.09 | 0.09 | 0.11 | — | — | — | — | — | — | — | — | ||||||||
| Target Corp. | 0.04 | 0.05 | 0.05 | 0.27 | 0.25 | 0.38 | 0.42 | 0.42 | 0.31 | 0.46 | 0.32 | 0.18 | 0.06 | 0.12 | 0.09 | 0.10 | 0.05 | 0.08 | 0.09 | — | — | — | — | — | — | — | — | ||||||||
| Walmart Inc. | 0.11 | 0.14 | 0.12 | 0.17 | 0.18 | 0.28 | 0.28 | 0.19 | 0.16 | 0.21 | 0.18 | 0.12 | 0.10 | 0.12 | 0.12 | 0.10 | 0.11 | 0.22 | 0.10 | — | — | — | — | — | — | — | — | ||||||||
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
= 439,000 ÷ 4,683,100 = 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. | Dollar Tree Inc. cash ratio deteriorated from Q1 2023 to Q2 2023 and from Q2 2023 to Q3 2023. |