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


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


Current Ratio Trend
The current ratio exhibits noticeable fluctuations over the periods analyzed. Starting at a relatively strong position above 1.9 in early 2017, it experienced minor declines and recoveries until early 2019, maintaining values around 2.0 or higher. From mid-2019 onwards, the ratio notably decreased to near 1.05, indicating a reduction in current assets relative to current liabilities. Subsequently, it showed a gradual increase through early 2022, reaching around 1.46 before slightly declining again near the end of 2022. Overall, the current ratio indicates some variability but generally remains above 1.0, suggesting adequate short-term liquidity with some periods of tighter working capital.
Quick Ratio Trend
The quick ratio demonstrates a pronounced downward trend throughout the time frame. Initially, it was relatively higher, around 0.5 in early 2017, but it dropped sharply during 2017 and into 2019, reaching values as low as 0.1 by late 2019. There was a modest rebound in 2020, with the ratio rising above 0.4 at times, but this recovery was not sustained. It declined again toward values near 0.1 in late 2022. These levels are quite low, indicating that the company holds a minimal proportion of liquid assets excluding inventories to cover its current liabilities.
Cash Ratio Trend
The cash ratio closely mirrors the quick ratio over the entire period, displaying the same general pattern of decline followed by partial recovery and subsequent decreases. Starting at around 0.5, the ratio fell to 0.1 in late 2019, improved somewhat in 2020, and then declined again to below 0.1 by the end of 2022. This suggests that the company’s cash and cash-equivalents relative to current liabilities have diminished substantially, indicating limited immediate cash liquidity.
Overall Liquidity Insights
While the current ratio shows that the company generally maintains current assets exceeding current liabilities, the significantly lower quick and cash ratios suggest that a large portion of current assets is likely tied up in inventories or other less liquid items. The downward trend in the quick and cash ratios signals increased reliance on inventories to meet short-term obligations, implying potential liquidity risk if those inventories cannot be converted to cash promptly. The modest recoveries in quick and cash ratios during 2020 may reflect temporary improvements in liquidity management, but the general trend remains downward.

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

1 Q3 2023 Calculation
Current ratio = Current assets ÷ Current liabilities
= ÷ =

2 Click competitor name to see calculations.


Current Assets
Current assets generally exhibit a fluctuating trend over the periods analyzed. Beginning at approximately 4.28 billion USD, there is a notable dip in July 2017 followed by a recovery and moderate fluctuations. From early 2020 onwards, current assets show a significant upward trajectory, peaking around 6.44 billion USD by late 2022. This increasing trend during this latter period may indicate an accumulation of liquid assets or receivables, which might be reflective of strategic inventory buildup or improved liquidity positions.
Current Liabilities
Current liabilities also demonstrate variability but with less striking volatility compared to current assets. Starting near 2.24 billion USD, liabilities stay in a relatively stable range until early 2019, when they sharply increase to approximately 4 billion USD. This elevated liability level persists with some fluctuations, reaching a peak around 4.68 billion USD by October 2022. The marked increase in liabilities around 2019 may reflect greater short-term obligations possibly due to operational or financing activities.
Current Ratio
The current ratio, which measures short-term liquidity by dividing current assets by current liabilities, shows a declining trend through most of 2017 and early 2018, dropping from 1.91 to as low as 1.6. It then improves significantly by mid-2018, reaching ratios above 2, indicating strong liquidity during that period. However, from mid-2019, the ratio declines sharply to around 1.06–1.09, indicating tighter liquidity conditions. Subsequent quarters reveal modest improvements, stabilizing around 1.3 to 1.46 through late 2022. The periods of decline suggest increasing pressure on short-term liquidity, while recent stabilization signals a potential balance between assets and liabilities in the short term.
Overall Insights
The financial data reflects an environment of growing current assets alongside increasing current liabilities, resulting in fluctuations in liquidity ratios. The initial period exhibits stronger liquidity that weakens around 2019, coinciding with rising liabilities. Following this, liquidity improves gradually but remains below earlier levels, suggesting a more cautious asset-liability management approach. Attention to the balance between current assets and liabilities remains crucial to maintain operational flexibility and short-term financial health.

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

1 Q3 2023 Calculation
Quick ratio = Total quick assets ÷ Current liabilities
= ÷ =

2 Click competitor name to see calculations.


Analysis of Total Quick Assets
The total quick assets demonstrate significant volatility over the observed periods. Initial values start relatively high and then experience sharp declines and recoveries intermittently. Notably, there are prominent peaks around early 2020, reflecting a substantial increase in liquid assets. However, following this peak, the quick assets trend downward, reaching lower levels by late 2022. This variability suggests fluctuating liquidity positions, potentially influenced by operational factors or broader market conditions.
Analysis of Current Liabilities
Current liabilities maintain a generally elevated and rising trend throughout the periods analyzed. Early data show moderately high figures, which increase steadily with some fluctuations, peaking intermittently, particularly during mid to late 2019 and early 2020. Despite slight declines at times, the overall trajectory remains upward, culminating in the highest liability levels by the end of 2022. This pattern indicates an incremental buildup of short-term obligations, which may impose pressure on liquidity and operational flexibility.
Analysis of Quick Ratio
The quick ratio, indicative of the company’s immediate liquidity, generally remains below the ideal benchmark of 1. It exhibits considerable decline through 2017 and 2018, reaching notably low ratios around late 2019. Although there is a resurgence in early 2020, ratios tend to fluctuate with a downward bias towards the latter part of the dataset, hitting a low point near the end of 2022. This persistent suboptimal quick ratio reflects constrained short-term liquidity relative to current liabilities, emphasizing continued challenges in covering immediate obligations without relying on inventory liquidation.
Overall Insights
The combination of decreasing or unstable quick assets, rising current liabilities, and a generally weak quick ratio indicates tightening liquidity conditions during the examined timeframe. While occasional periods show improvement in liquid asset levels, these are often offset by increases in short-term liabilities, resulting in inadequate quick ratio metrics. The trend underscores a potential risk in short-term financial stability, signaling a need for enhanced liquidity management to ensure sufficient coverage of current obligations.

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

1 Q3 2023 Calculation
Cash ratio = Total cash assets ÷ Current liabilities
= ÷ =

2 Click competitor name to see calculations.


The financial data reveals distinct trends in cash assets, current liabilities, and the cash ratio over multiple quarters. A detailed review of each metric indicates variations reflective of the company's liquidity and short-term financial stability.

Total Cash Assets (US$ in thousands)

The total cash assets exhibit considerable fluctuations across the periods analyzed. Initially, cash balances were relatively high, peaking at over 1.15 billion USD in April 2017. Following this, there is a general downtrend toward the end of 2017, reaching a low point of approximately 400 million USD in October 2017. Subsequently, cash levels show volatility, with notable increases in early 2020, where cash assets reached a maximum of around 1.76 billion USD in May and August 2020. Conversely, later periods, particularly from mid-2021 onward, show a downward shift again, with cash assets declining from around 1.47 billion USD in May 2021 to approximately 439 million USD by October 2022.

Current Liabilities (US$ in thousands)

Current liabilities demonstrate a generally increasing trend over the examined timeframe. Starting at about 2.24 billion USD in April 2017, liabilities fluctuate moderately but show a clear upward movement from early 2019, surging to nearly 4.98 billion USD by October 2022. This increase suggests rising short-term obligations that could affect liquidity management and operational flexibility if not balanced by corresponding asset growth.

Cash Ratio (ratio)

The cash ratio, which measures the company's ability to cover current liabilities directly with cash assets, reflects notable volatility and an overall downward pressure in certain periods. Initially moderate at 0.52 in April 2017, the ratio sharply decreases to a low of 0.1 by November 2019, indicating a diminishing ability to meet short-term liabilities solely through cash holdings. Although there is a recovery during 2020, with the ratio rising again to approximately 0.39-0.41, it declines once more in subsequent quarters. By October 2022, the cash ratio falls to 0.09, the lowest in the analyzed series, underscoring potential concerns regarding liquidity given the concurrently rising current liabilities.

Overall, the data suggest a pattern of increasing short-term liabilities without consistent supporting growth in cash assets, resulting in a weakening cash ratio over the long term. Periods of improved liquidity, especially in 2020, appear temporary relative to the broader trend. This pattern may indicate growing pressure on the company's liquid resources, necessitating ongoing monitoring and possibly strategic adjustments to enhance short-term financial resilience.