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 Long-term (Investment) Activity Ratios
Quarterly Data

Microsoft Excel

Long-term Activity Ratios (Summary)

Dollar Tree Inc., long-term (investment) activity 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
Net fixed asset turnover 5.74 5.84 5.92 5.88 5.94 6.06 6.14 6.20 6.12 6.11 6.08 6.08 6.17 6.35 6.55 6.62 6.75 6.86 6.93 6.95 6.77 6.81 6.76 6.65
Net fixed asset turnover (including operating lease, right-of-use asset) 2.46 2.45 2.46 2.41 2.41 2.43 2.44 2.44 2.44 2.41 2.38 2.34 2.43 2.41 2.40 6.62 6.75 6.86 6.93 6.95 6.77 6.81 6.76 6.65
Total asset turnover 1.21 1.20 1.19 1.21 1.22 1.26 1.22 1.23 1.21 1.19 1.18 1.21 1.19 1.19 1.19 1.69 1.38 1.41 1.42 1.36 1.37 1.37 1.31 1.32
Equity turnover 3.34 3.23 3.24 3.41 3.59 3.67 3.47 3.50 3.60 3.61 3.69 3.77 3.84 3.97 4.01 4.04 2.89 2.98 3.06 3.10 3.52 3.62 3.73 3.84

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

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Dollar Tree Inc. net fixed asset turnover ratio deteriorated from Q1 2023 to Q2 2023 and from Q2 2023 to Q3 2023.
Net fixed asset turnover (including operating lease, right-of-use asset) An activity ratio calculated as total revenue divided by net fixed assets (including operating lease, right-of-use asset). Dollar Tree Inc. net fixed asset turnover ratio (with operating lease, right-of-use asset) deteriorated from Q1 2023 to Q2 2023 but then improved from Q2 2023 to Q3 2023 exceeding Q1 2023 level.
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Dollar Tree Inc. total asset turnover ratio improved from Q1 2023 to Q2 2023 and from Q2 2023 to Q3 2023.
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Dollar Tree Inc. equity turnover ratio deteriorated from Q1 2023 to Q2 2023 but then improved from Q2 2023 to Q3 2023 exceeding Q1 2023 level.

Net Fixed Asset Turnover

Dollar Tree Inc., net fixed asset turnover 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)
Net sales 6,936,600 6,765,300 6,900,100 7,077,400 6,415,400 6,340,200 6,476,800 6,767,300 6,176,700 6,277,600 6,286,800 6,315,300 5,746,200 5,740,600 5,808,700 6,205,200 5,538,800 5,525,600 5,553,700 6,360,600 5,316,600 5,281,200 5,287,100 5,635,500 5,001,600 4,996,300 5,085,800
Property, plant and equipment, net of accumulated depreciation 4,823,900 4,652,900 4,514,000 4,477,300 4,377,400 4,250,200 4,182,400 4,116,300 4,095,600 4,032,600 3,964,800 3,881,800 3,810,700 3,666,200 3,525,000 3,445,300 3,406,200 3,316,100 3,249,700 3,200,700 3,178,900 3,115,400 3,093,900 3,115,800 3,176,300 3,174,200 3,153,200
Long-term Activity Ratio
Net fixed asset turnover1 5.74 5.84 5.92 5.88 5.94 6.06 6.14 6.20 6.12 6.11 6.08 6.08 6.17 6.35 6.55 6.62 6.75 6.86 6.93 6.95 6.77 6.81 6.76 6.65
Benchmarks
Net Fixed Asset Turnover, Competitors2
Costco Wholesale Corp. 8.91 8.94 9.02 9.04 8.84 8.57 8.34 8.18 7.89 7.77 7.60 7.48 7.31 7.21 7.12 7.15
Dollar General Corp. 7.37 7.60 7.77 7.87 8.13 8.20 8.43 8.65 8.78 8.88 8.91 8.47 8.70 8.83 8.69 8.63
Target Corp. 3.47 3.57 3.68 3.71 3.65 3.64 3.62 3.44 3.27 3.13 2.97 2.93 2.91 2.92 2.93 2.92
Walmart Inc. 5.82 5.79 5.75 5.74 5.88 5.87 5.88 5.77 5.08 5.08 4.98 4.74 4.77 4.73 4.72 4.58

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
Net fixed asset turnover = (Net salesQ3 2023 + Net salesQ2 2023 + Net salesQ1 2023 + Net salesQ4 2022) ÷ Property, plant and equipment, net of accumulated depreciation
= (6,936,600 + 6,765,300 + 6,900,100 + 7,077,400) ÷ 4,823,900 = 5.74

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Dollar Tree Inc. net fixed asset turnover ratio deteriorated from Q1 2023 to Q2 2023 and from Q2 2023 to Q3 2023.

Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset)

Dollar Tree Inc., net fixed asset turnover (including operating lease, right-of-use asset) 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)
Net sales 6,936,600 6,765,300 6,900,100 7,077,400 6,415,400 6,340,200 6,476,800 6,767,300 6,176,700 6,277,600 6,286,800 6,315,300 5,746,200 5,740,600 5,808,700 6,205,200 5,538,800 5,525,600 5,553,700 6,360,600 5,316,600 5,281,200 5,287,100 5,635,500 5,001,600 4,996,300 5,085,800
 
Property, plant and equipment, net of accumulated depreciation 4,823,900 4,652,900 4,514,000 4,477,300 4,377,400 4,250,200 4,182,400 4,116,300 4,095,600 4,032,600 3,964,800 3,881,800 3,810,700 3,666,200 3,525,000 3,445,300 3,406,200 3,316,100 3,249,700 3,200,700 3,178,900 3,115,400 3,093,900 3,115,800 3,176,300 3,174,200 3,153,200
Operating lease right-of-use assets 6,413,300 6,433,600 6,364,900 6,425,300 6,424,000 6,341,200 6,356,500 6,324,100 6,185,100 6,204,100 6,147,000 6,225,000 5,864,600 6,014,300 6,111,000
Property, plant and equipment, net of accumulated depreciation (including operating lease, right-of-use asset) 11,237,200 11,086,500 10,878,900 10,902,600 10,801,400 10,591,400 10,538,900 10,440,400 10,280,700 10,236,700 10,111,800 10,106,800 9,675,300 9,680,500 9,636,000 3,445,300 3,406,200 3,316,100 3,249,700 3,200,700 3,178,900 3,115,400 3,093,900 3,115,800 3,176,300 3,174,200 3,153,200
Long-term Activity Ratio
Net fixed asset turnover (including operating lease, right-of-use asset)1 2.46 2.45 2.46 2.41 2.41 2.43 2.44 2.44 2.44 2.41 2.38 2.34 2.43 2.41 2.40 6.62 6.75 6.86 6.93 6.95 6.77 6.81 6.76 6.65
Benchmarks
Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset), Competitors2
Costco Wholesale Corp. 8.04 8.05 8.12 8.12 7.94 7.67 7.43 7.28 7.02 6.88 6.75 6.64 6.48 6.43 6.35 7.15
Dollar General Corp. 2.36 2.36 2.36 2.37 2.40 2.42 2.48 2.52 2.49 2.47 2.41 2.30 2.31 2.33 2.34 8.63
Target Corp. 3.20 3.29 3.38 3.40 3.35 3.33 3.32 3.17 3.02 2.89 2.74 2.70 2.69 2.70 2.72 2.71
Walmart Inc. 5.15 5.09 5.04 5.04 5.14 5.13 5.14 5.05 4.38 4.38 4.30 4.09 4.12 4.08 4.09 4.58

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
Net fixed asset turnover (including operating lease, right-of-use asset) = (Net salesQ3 2023 + Net salesQ2 2023 + Net salesQ1 2023 + Net salesQ4 2022) ÷ Property, plant and equipment, net of accumulated depreciation (including operating lease, right-of-use asset)
= (6,936,600 + 6,765,300 + 6,900,100 + 7,077,400) ÷ 11,237,200 = 2.46

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Net fixed asset turnover (including operating lease, right-of-use asset) An activity ratio calculated as total revenue divided by net fixed assets (including operating lease, right-of-use asset). Dollar Tree Inc. net fixed asset turnover ratio (with operating lease, right-of-use asset) deteriorated from Q1 2023 to Q2 2023 but then improved from Q2 2023 to Q3 2023 exceeding Q1 2023 level.

Total Asset Turnover

Dollar Tree Inc., total asset turnover 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)
Net sales 6,936,600 6,765,300 6,900,100 7,077,400 6,415,400 6,340,200 6,476,800 6,767,300 6,176,700 6,277,600 6,286,800 6,315,300 5,746,200 5,740,600 5,808,700 6,205,200 5,538,800 5,525,600 5,553,700 6,360,600 5,316,600 5,281,200 5,287,100 5,635,500 5,001,600 4,996,300 5,085,800
Total assets 22,909,500 22,676,300 22,372,300 21,721,800 21,390,000 20,445,200 21,050,700 20,696,000 20,652,200 20,671,000 20,471,800 19,574,600 19,742,100 19,493,800 19,354,300 13,501,200 16,649,300 16,103,600 15,827,100 16,332,800 15,730,200 15,532,300 15,994,700 15,701,600 16,195,000 16,329,400 16,060,900
Long-term Activity Ratio
Total asset turnover1 1.21 1.20 1.19 1.21 1.22 1.26 1.22 1.23 1.21 1.19 1.18 1.21 1.19 1.19 1.19 1.69 1.38 1.41 1.42 1.36 1.37 1.37 1.31 1.32
Benchmarks
Total Asset Turnover, Competitors2
Costco Wholesale Corp. 3.46 3.44 3.43 3.47 3.34 3.27 3.10 3.24 3.19 3.19 2.81 2.94 3.04 3.18 2.94 3.29
Dollar General Corp. 1.25 1.25 1.28 1.30 1.31 1.32 1.34 1.30 1.24 1.21 1.19 1.22 1.22 1.22 1.23 1.94
Target Corp. 1.93 2.03 2.08 1.94 1.87 1.93 1.92 1.80 1.73 1.74 1.77 1.80 1.75 1.83 1.85 1.80
Walmart Inc. 2.40 2.36 2.32 2.32 2.32 2.35 2.36 2.20 2.17 2.27 2.28 2.20 2.16 2.19 2.18 2.33

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
Total asset turnover = (Net salesQ3 2023 + Net salesQ2 2023 + Net salesQ1 2023 + Net salesQ4 2022) ÷ Total assets
= (6,936,600 + 6,765,300 + 6,900,100 + 7,077,400) ÷ 22,909,500 = 1.21

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Dollar Tree Inc. total asset turnover ratio improved from Q1 2023 to Q2 2023 and from Q2 2023 to Q3 2023.

Equity Turnover

Dollar Tree Inc., equity turnover 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)
Net sales 6,936,600 6,765,300 6,900,100 7,077,400 6,415,400 6,340,200 6,476,800 6,767,300 6,176,700 6,277,600 6,286,800 6,315,300 5,746,200 5,740,600 5,808,700 6,205,200 5,538,800 5,525,600 5,553,700 6,360,600 5,316,600 5,281,200 5,287,100 5,635,500 5,001,600 4,996,300 5,085,800
Shareholders’ equity 8,275,300 8,396,500 8,241,500 7,718,500 7,244,400 7,011,700 7,411,300 7,285,300 6,961,100 6,813,600 6,520,600 6,254,800 6,121,300 5,865,700 5,755,900 5,642,900 7,943,100 7,647,500 7,355,700 7,182,300 6,116,500 5,860,200 5,609,000 5,389,500 5,047,700 4,856,900 4,669,600
Long-term Activity Ratio
Equity turnover1 3.34 3.23 3.24 3.41 3.59 3.67 3.47 3.50 3.60 3.61 3.69 3.77 3.84 3.97 4.01 4.04 2.89 2.98 3.06 3.10 3.52 3.62 3.73 3.84
Benchmarks
Equity Turnover, Competitors2
Costco Wholesale Corp. 9.80 10.09 10.56 10.79 10.69 10.62 10.78 10.93 11.10 11.18 11.40 8.93 9.37 9.32 9.54 9.80
Dollar General Corp. 5.96 5.71 5.80 5.46 5.49 5.49 5.39 5.07 4.65 4.25 4.10 4.14 4.10 3.95 3.98 3.99
Target Corp. 9.73 10.04 9.80 8.16 7.39 6.66 6.48 6.40 6.57 6.65 7.08 6.52 6.65 6.41 6.77 6.59
Walmart Inc. 8.23 7.51 7.42 6.82 6.89 6.98 7.13 6.86 6.69 7.14 7.78 6.96 7.22 7.31 7.50 7.04

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
Equity turnover = (Net salesQ3 2023 + Net salesQ2 2023 + Net salesQ1 2023 + Net salesQ4 2022) ÷ Shareholders’ equity
= (6,936,600 + 6,765,300 + 6,900,100 + 7,077,400) ÷ 8,275,300 = 3.34

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Dollar Tree Inc. equity turnover ratio deteriorated from Q1 2023 to Q2 2023 but then improved from Q2 2023 to Q3 2023 exceeding Q1 2023 level.