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

Microsoft Excel

Long-term Activity Ratios (Summary)

Dollar Tree Inc., long-term (investment) activity ratios

Microsoft Excel
Jan 29, 2022 Jan 30, 2021 Feb 1, 2020 Feb 2, 2019 Feb 3, 2018 Jan 28, 2017
Net fixed asset turnover 5.88 6.20 6.08 6.62 6.95 6.65
Net fixed asset turnover (including operating lease, right-of-use asset) 2.41 2.44 2.34 6.62 6.95 6.65
Total asset turnover 1.21 1.23 1.21 1.69 1.36 1.32
Equity turnover 3.41 3.50 3.77 4.04 3.10 3.84

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

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 improved from 2020 to 2021 but then deteriorated significantly from 2021 to 2022.
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) improved from 2020 to 2021 but then slightly deteriorated from 2021 to 2022.
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Dollar Tree Inc. total asset turnover ratio improved from 2020 to 2021 but then slightly deteriorated from 2021 to 2022 not reaching 2020 level.
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Dollar Tree Inc. equity turnover ratio deteriorated from 2020 to 2021 and from 2021 to 2022.

Net Fixed Asset Turnover

Dollar Tree Inc., net fixed asset turnover calculation, comparison to benchmarks

Microsoft Excel
Jan 29, 2022 Jan 30, 2021 Feb 1, 2020 Feb 2, 2019 Feb 3, 2018 Jan 28, 2017
Selected Financial Data (US$ in thousands)
Net sales 26,309,800 25,508,400 23,610,800 22,823,300 22,245,500 20,719,200
Property, plant and equipment, net of accumulated depreciation 4,477,300 4,116,300 3,881,800 3,445,300 3,200,700 3,115,800
Long-term Activity Ratio
Net fixed asset turnover1 5.88 6.20 6.08 6.62 6.95 6.65
Benchmarks
Net Fixed Asset Turnover, Competitors2
Costco Wholesale Corp. 8.48 7.84 7.29 7.03 6.92
Target Corp. 3.71 3.44 2.93 2.92
Walmart Inc. 5.74 5.77 4.74 4.58
Net Fixed Asset Turnover, Sector
Consumer Staples Distribution & Retail 5.84 5.69 4.80 4.64
Net Fixed Asset Turnover, Industry
Consumer Staples 5.30 5.14 4.44 4.34

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

1 2022 Calculation
Net fixed asset turnover = Net sales ÷ Property, plant and equipment, net of accumulated depreciation
= 26,309,800 ÷ 4,477,300 = 5.88

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 improved from 2020 to 2021 but then deteriorated significantly from 2021 to 2022.

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, comparison to benchmarks

Microsoft Excel
Jan 29, 2022 Jan 30, 2021 Feb 1, 2020 Feb 2, 2019 Feb 3, 2018 Jan 28, 2017
Selected Financial Data (US$ in thousands)
Net sales 26,309,800 25,508,400 23,610,800 22,823,300 22,245,500 20,719,200
 
Property, plant and equipment, net of accumulated depreciation 4,477,300 4,116,300 3,881,800 3,445,300 3,200,700 3,115,800
Operating lease right-of-use assets 6,425,300 6,324,100 6,225,000
Property, plant and equipment, net of accumulated depreciation (including operating lease, right-of-use asset) 10,902,600 10,440,400 10,106,800 3,445,300 3,200,700 3,115,800
Long-term Activity Ratio
Net fixed asset turnover (including operating lease, right-of-use asset)1 2.41 2.44 2.34 6.62 6.95 6.65
Benchmarks
Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset), Competitors2
Costco Wholesale Corp. 7.67 7.01 6.48 7.03 6.92
Target Corp. 3.40 3.17 2.70 2.71
Walmart Inc. 5.04 5.05 4.09 4.58
Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset), Sector
Consumer Staples Distribution & Retail 5.19 5.05 4.21 4.58
Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset), Industry
Consumer Staples 4.77 4.62 3.96 4.24

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

1 2022 Calculation
Net fixed asset turnover (including operating lease, right-of-use asset) = Net sales ÷ Property, plant and equipment, net of accumulated depreciation (including operating lease, right-of-use asset)
= 26,309,800 ÷ 10,902,600 = 2.41

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) improved from 2020 to 2021 but then slightly deteriorated from 2021 to 2022.

Total Asset Turnover

Dollar Tree Inc., total asset turnover calculation, comparison to benchmarks

Microsoft Excel
Jan 29, 2022 Jan 30, 2021 Feb 1, 2020 Feb 2, 2019 Feb 3, 2018 Jan 28, 2017
Selected Financial Data (US$ in thousands)
Net sales 26,309,800 25,508,400 23,610,800 22,823,300 22,245,500 20,719,200
Total assets 21,721,800 20,696,000 19,574,600 13,501,200 16,332,800 15,701,600
Long-term Activity Ratio
Total asset turnover1 1.21 1.23 1.21 1.69 1.36 1.32
Benchmarks
Total Asset Turnover, Competitors2
Costco Wholesale Corp. 3.47 3.24 2.94 3.29 3.39
Target Corp. 1.94 1.80 1.80 1.80
Walmart Inc. 2.32 2.20 2.20 2.33
Total Asset Turnover, Sector
Consumer Staples Distribution & Retail 2.47 2.31 2.27 2.40
Total Asset Turnover, Industry
Consumer Staples 1.50 1.40 1.31 1.37

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

1 2022 Calculation
Total asset turnover = Net sales ÷ Total assets
= 26,309,800 ÷ 21,721,800 = 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 2020 to 2021 but then slightly deteriorated from 2021 to 2022 not reaching 2020 level.

Equity Turnover

Dollar Tree Inc., equity turnover calculation, comparison to benchmarks

Microsoft Excel
Jan 29, 2022 Jan 30, 2021 Feb 1, 2020 Feb 2, 2019 Feb 3, 2018 Jan 28, 2017
Selected Financial Data (US$ in thousands)
Net sales 26,309,800 25,508,400 23,610,800 22,823,300 22,245,500 20,719,200
Shareholders’ equity 7,718,500 7,285,300 6,254,800 5,642,900 7,182,300 5,389,500
Long-term Activity Ratio
Equity turnover1 3.41 3.50 3.77 4.04 3.10 3.84
Benchmarks
Equity Turnover, Competitors2
Costco Wholesale Corp. 10.79 10.93 8.93 9.80 10.82
Target Corp. 8.16 6.40 6.52 6.59
Walmart Inc. 6.82 6.86 6.96 7.04
Equity Turnover, Sector
Consumer Staples Distribution & Retail 7.67 7.44 7.26 7.41
Equity Turnover, Industry
Consumer Staples 5.11 4.84 4.60 4.48

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

1 2022 Calculation
Equity turnover = Net sales ÷ Shareholders’ equity
= 26,309,800 ÷ 7,718,500 = 3.41

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 2020 to 2021 and from 2021 to 2022.