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.

Common-Size Balance Sheet: Assets 

Dollar Tree Inc., common-size consolidated balance sheet: assets

Microsoft Excel
Jan 29, 2022 Jan 30, 2021 Feb 1, 2020 Feb 2, 2019 Feb 3, 2018 Jan 28, 2017
Cash and cash equivalents 4.53 6.85 2.75 3.13 6.72 5.52
Short-term investments 0.00 0.00 0.00 0.00 0.00 0.03
Merchandise inventories 20.11 16.56 17.99 26.19 19.40 18.25
Accounts receivable, net 0.00 0.00 0.58 0.75 0.55 0.52
Other 1.18 1.00 0.48 1.74 1.34 0.41
Accounts receivable, divestiture-related 0.00 0.00 0.00 0.00 0.00 0.36
Other current assets 1.18% 1.00% 1.06% 2.48% 1.89% 1.29%
Current assets 25.82% 24.40% 21.81% 31.80% 28.02% 25.08%
Property, plant and equipment, net of accumulated depreciation 20.61 19.89 19.83 25.52 19.60 19.84
Restricted cash 0.25 0.23 0.24 0.18 0.00 0.00
Operating lease right-of-use assets 29.58 30.56 31.80 0.00 0.00 0.00
Goodwill 9.14 9.59 10.13 17.01 30.77 31.99
Favorable lease rights, net of accumulated amortization 0.00 0.00 0.00 2.14 2.30 2.98
Trade name intangible asset 14.27 14.98 15.84 22.96 18.98 19.74
Deferred tax asset 0.09 0.11 0.12 0.00 0.00 0.00
Other assets 0.24 0.24 0.22 0.39 0.34 0.35
Noncurrent assets 74.18% 75.60% 78.19% 68.20% 71.98% 74.92%
Total assets 100.00% 100.00% 100.00% 100.00% 100.00% 100.00%

Based on: 10-K (reporting date: 2022-01-29), 10-K (reporting date: 2021-01-30), 10-K (reporting date: 2020-02-01), 10-K (reporting date: 2019-02-02), 10-K (reporting date: 2018-02-03), 10-K (reporting date: 2017-01-28).


Cash and Cash Equivalents
Presented a fluctuating trend, initially rising from 5.52% in early 2017 to a peak of 6.85% in early 2021, followed by a decline to 4.53% in early 2022. This indicates variability in liquid asset holdings relative to total assets over the period.
Merchandise Inventories
Exhibited considerable volatility throughout the periods. Starting at 18.25% in early 2017, it increased significantly to 26.19% by early 2019, then dropped notably to 16.56% in early 2021 before rising again to 20.11% in early 2022. This suggests changes in inventory management or demand fluctuations.
Accounts Receivable, Net
Showed a modest increase initially from 0.52% in early 2017 to 0.75% in early 2019, followed by a decline to 0.58% in early 2020, and then data becomes unavailable afterward. The small values imply receivables form a minor portion of total assets.
Other and Other Current Assets
Both categories displayed slight increases over the years. Other current assets increased from 1.29% in early 2017 to around 1.18% in early 2022 after peaking at 2.48% in 2019. The "Other" category fluctuated but hovered around 1% in the latest periods, indicating moderate variability in miscellaneous current assets.
Current Assets
Current assets as a percentage of total assets rose from 25.08% in early 2017 to a high of 31.8% in early 2019, then sharply declined to 21.81% in early 2020, before rebounding to 25.82% in early 2022. This highlights an overall dynamic management of current resources relative to total asset base.
Property, Plant and Equipment (Net)
Maintained relative stability around approximately 20% of total assets, with a peak at 25.52% in early 2019 and minor fluctuations thereafter. This reflects consistent investment levels in physical assets.
Restricted Cash
Data was unavailable prior to 2019, but from then rose slightly from 0.18% in early 2019 to 0.25% in early 2022, suggesting a small but growing portion of assets held with usage restrictions.
Operating Lease Right-of-Use Assets
First recorded in 2020 at 31.8% of total assets and showed a gradual decline to 29.58% by early 2022. This indicates significant recognition of lease assets beginning in 2020, likely due to accounting standard changes, with a slight reduction more recently.
Goodwill
Displayed a marked decrease from 31.99% in early 2017 to 9.14% in early 2022, indicative of either impairment charges, asset disposals, or changes in acquisition activity impacting intangible assets classified as goodwill.
Favorable Lease Rights, Net
Showed a downward trend from 2.98% in early 2017 to 2.14% in early 2019, with data absent thereafter, reflecting diminishing recognized lease-related asset values prior to 2020.
Trade Name Intangible Asset
Generally declined over the period from 19.74% in early 2017 to 14.27% in early 2022, reflecting amortization or partial impairment affecting this category of intangible assets.
Deferred Tax Asset
Reported only from 2020 onwards at minimal levels between 0.09% and 0.12%, suggesting a small portion of total assets was attributed to deferred tax benefits during these years.
Other Assets
Remained stable around 0.22% to 0.39% throughout the periods, indicating a minor but consistent component of total assets.
Noncurrent Assets
As a percentage of total assets, noncurrent assets decreased from 74.92% in early 2017 to 68.2% in early 2019, then increased sharply to 78.19% in early 2020 before slowly declining to 74.18% in early 2022. This fluctuation correlates with changes in goodwill, operating lease assets, and property investments, highlighting shifting emphasis on long-term asset composition.

AI Ask an analyst for more