Stock Analysis on Net

Dollar Tree Inc. (NASDAQ:DLTR)

$22.49

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

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 Google Pay
Visa Secure Mastercard Identity Check American Express SafeKey

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

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


Current Ratio
The current ratio exhibits a fluctuating trend over the analyzed periods. Initially, the ratio maintained a relatively stable level around 2.0 from April 2016 through November 2018, indicating a consistent ability to cover short-term liabilities with current assets. However, a notable decline occurred starting in early 2019, dropping to near 1.07-1.09 in mid to late 2019. This decline persisted with minor recovery phases but remained generally lower than earlier levels throughout 2020 and 2021. More recently, the ratio showed a gradual increase reaching approximately 1.46 by mid-2022, suggesting a modest improvement in liquidity but still below the earlier stable range observed in 2016-2018.
Quick Ratio
The quick ratio displayed significant volatility over the timeline with marked decreases in certain periods. Early values fluctuated between 0.35 and 0.52 until late 2018, indicating moderate liquidity excluding inventories. From early 2019 onward, there was a clear downward trend, with the ratio falling to as low as 0.10 in late 2019 and early 2020. Although it recovered somewhat in mid-2020, values generally remained low, mostly below 0.4, and demonstrated recurring declines through 2021 and 2022. The later periods show minimal recovery, approaching 0.09 by late 2022. This pattern suggests a weakening in the ability to meet short-term obligations through the most liquid assets, excluding inventory.
Cash Ratio
The cash ratio trends mirror those of the quick ratio exactly for all periods, reflecting identical values across every quarter observed. This indicates that cash and cash equivalents are the primary contributors to the quick ratio, with little to no influence from other quick assets. The pattern reveals an initial higher liquidity in cash terms around 0.46-0.52 before declining sharply to as low as 0.10 in late 2019, followed by fluctuating low levels slightly improving at certain points up to mid-2020 and then generally trending downward again. The ratio reached a low point of approximately 0.09 by late 2022, denoting a reduction in very liquid asset holdings relative to current liabilities over time.
Overall Liquidity Insights
The data indicates a general weakening of liquidity from 2019 onward, particularly in the quick and cash ratios, which reflect the company's cash and near-cash assets relative to liabilities. While the current ratio remains above 1 for the entire period, its decline from above 2 to around 1.3–1.4 suggests the company might be relying more on inventories or less liquid current assets to meet short-term obligations. The persistent low quick and cash ratios raise potential concerns regarding immediate liquidity challenges or changes in working capital management. The modest improvements seen in the current ratio during 2021 to 2022 imply attempts to strengthen liquidity; however, cash reserves remain at notably low levels.

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
Current liabilities
Liquidity Ratio
Current ratio1
Benchmarks
Current Ratio, Competitors2
Costco Wholesale Corp.
Target Corp.
Walmart 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
Current ratio = Current assets ÷ Current liabilities
= ÷ =

2 Click competitor name to see calculations.


The analysis of the quarterly financial data reveals distinct patterns and trends in the company’s liquidity position over the period from April 2016 to October 2022.

Current Assets
Current assets demonstrate fluctuations with a general upward tendency over the years. Starting at approximately $4.17 billion in April 2016, the value peaked around $6.44 billion by October 2022. Periodic dips occurred but were generally followed by recoveries, indicating some volatility but overall growth in current asset holdings.
Current Liabilities
Current liabilities similarly showed fluctuations with an increasing trend. Initially valued around $2.05 billion in April 2016, liabilities rose markedly, with some peaks notably in the range of $4.1 to $4.7 billion toward the end of the examined period, especially from mid-2019 onward. This indicates an increase in short-term obligations over time.
Current Ratio
The current ratio, an indicator of liquidity and short-term financial health, exhibits a declining trend from 2.04 in April 2016 to a low near 1.06 in mid to late 2019. This decline suggests a weakening ability to cover current liabilities with current assets during that period. However, after this low point, the current ratio gradually improves, reaching approximately 1.38 by October 2022, indicating a moderate recovery in liquidity, though remaining below the levels observed in the earlier years.

In summary, while current assets and current liabilities both increased over the period analyzed, the increase in liabilities outpaced assets notably around 2019, resulting in reduced liquidity as shown by the current ratio. Subsequent improvements in the current ratio through 2022 suggest ongoing efforts to enhance liquidity, albeit the ratio remains below the initial high levels observed in 2016. This pattern indicates a period of rising short-term obligations that were managed over time with some success but warrant continued attention to ensure sufficient liquidity.


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
Short-term investments
Total quick assets
 
Current liabilities
Liquidity Ratio
Quick ratio1
Benchmarks
Quick Ratio, Competitors2
Costco Wholesale Corp.
Target Corp.
Walmart 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
Quick ratio = Total quick assets ÷ Current liabilities
= ÷ =

2 Click competitor name to see calculations.


Trend in Total Quick Assets
Total quick assets exhibit significant volatility throughout the periods. Initial values started near 933,700 thousand USD and fluctuated considerably, peaking at 1,755,100 thousand USD in May 2020. After this peak, the amount decreased and again showed fluctuations with values ranging between approximately 439,000 and 1,218,500 thousand USD toward the latest periods. This pattern indicates inconsistency in liquid assets available to meet short-term obligations.
Trend in Current Liabilities
Current liabilities have generally increased over the observed timeframe. Starting at approximately 2,049,100 thousand USD, liabilities climbed with minor fluctuations to reach over 4,683,100 thousand USD by the end of the period. A notable surge can be observed around mid 2019, continuing into 2020 and beyond, reflecting escalating short-term obligations or potentially changes in operational financing needs.
Trend in Quick Ratio
The quick ratio remains consistently below 1.0, demonstrating limited liquidity relative to current liabilities throughout all quarters. It started at 0.46, declined to a low near 0.09 by October 2022, with brief intervals of moderate improvement, such as around early to mid-2020 when it approached 0.39 to 0.41. The overall downward trend highlights a declining capacity to cover immediate liabilities with highly liquid assets, suggesting increased liquidity risk.
Overall Liquidity Analysis
The combined analysis of total quick assets and current liabilities indicates a deteriorating liquidity position over time. Despite occasional increases in quick assets, the faster and more pronounced growth in current liabilities has caused the quick ratio to fall, generally signifying constrained short-term financial flexibility. The minimal quick ratio values in recent periods warrant attention to the company's ability to satisfy short-term financial commitments without needing to liquidate inventory or secure additional financing.

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
Short-term investments
Total cash assets
 
Current liabilities
Liquidity Ratio
Cash ratio1
Benchmarks
Cash Ratio, Competitors2
Costco Wholesale Corp.
Target Corp.
Walmart 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
Cash ratio = Total cash assets ÷ Current liabilities
= ÷ =

2 Click competitor name to see calculations.


Total cash assets
The total cash assets exhibit substantial fluctuations throughout the periods analyzed. Initially, cash levels were near 933.7 million USD in April 2016, experiencing a peak above 1.15 billion USD in April 2017 before declining sharply to 400.1 million USD by October 2017. A notable surge occurred in May and August 2020 where cash assets peaked at over 1.75 billion USD, representing the highest values recorded. This interval reflects an unusual liquidity accumulation, possibly linked to external economic conditions or company strategy. Subsequently, cash levels receded again to below 500 million USD by late 2022, indicating variability in the company's liquid resources with no clear upward or downward long-term trend.
Current liabilities
Current liabilities showed a generally increasing trajectory with periodic variations. Starting at approximately 2.05 billion USD in early 2016, liabilities rose steadily with some minor cyclical declines corresponding to seasonal or quarterly factors. A significant jump is observed around May 2019, with current liabilities exceeding 3.9 billion USD, and this elevated level remains relatively consistent through the later periods, culminating near 4.7 billion USD by October 2022. The upward trend over multiple years suggests expanding short-term obligations, which could imply increased operational scale or higher short-term financing.
Cash ratio
The cash ratio declined considerably over the observed time frame, indicating a reduction in the company's immediate liquidity relative to current liabilities. Early periods in 2016 and early 2017 show ratios around 0.4 to 0.5, reflecting a fairly strong liquidity position. However, from mid-2017 onwards, the ratio diminished sharply, often dropping below 0.2, reaching the lowest points around 0.09 in late 2022. Short-term liquidity appears constrained relative to obligations, which may impact financial flexibility or risk profile, especially when coupled with rising current liabilities.
Summary
The analysis reveals divergent trends between cash assets and current liabilities, with the latter steadily increasing and the former showing volatility without sustained growth. Consequently, the cash ratio's decline suggests weakening liquidity coverage for short-term liabilities. While occasional spikes in cash assets, particularly during 2020, indicate periods of enhanced liquidity, these were not sustained through subsequent quarters. The overall pattern highlights growing short-term liabilities outpacing readily available cash, which may warrant close monitoring of liquidity risk and working capital management.