Stock Analysis on Net

Dollar Tree Inc. (NASDAQ:DLTR)

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

Analysis of Liquidity Ratios
Quarterly Data

Microsoft Excel

Liquidity Ratios (Summary)

Dollar Tree 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 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
Quick ratio 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
Cash ratio 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

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)

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 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 1.02 1.01 1.00 0.98
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)

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 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 0.45 0.44 0.41 0.41
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)

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 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 0.36 0.36 0.31 0.34
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.