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 Reportable Segments

Microsoft Excel

Segment Profit Margin

Dollar Tree Inc., profit margin by reportable segment

Microsoft Excel
Jan 29, 2022 Jan 30, 2021 Feb 1, 2020 Feb 2, 2019 Feb 3, 2018 Jan 28, 2017
Dollar Tree 11.54% 12.05% 13.25% 14.05% 13.27% 12.87%
Family Dollar 4.38% 5.35% -0.73% -20.88% 4.67% 3.78%

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

Segment profitability ratio Reportable segment The company
Segment profit margin Dollar Tree Dollar Tree segment profit margin ratio deteriorated from 2020 to 2021 and from 2021 to 2022.
Family Dollar Family Dollar segment profit margin ratio improved from 2020 to 2021 but then slightly deteriorated from 2021 to 2022.

Segment Profit Margin: Dollar Tree

Dollar Tree Inc.; Dollar Tree; segment profit margin calculation

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)
Operating income (loss) 1,607,000 1,598,000 1,657,800 1,645,900 1,481,900 1,305,300
Net sales 13,922,100 13,265,000 12,507,900 11,712,100 11,164,400 10,138,700
Segment Profitability Ratio
Segment profit margin1 11.54% 12.05% 13.25% 14.05% 13.27% 12.87%

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
Segment profit margin = 100 × Operating income (loss) ÷ Net sales
= 100 × 1,607,000 ÷ 13,922,100 = 11.54%

Segment profitability ratio Reportable segment The company
Segment profit margin Dollar Tree Dollar Tree segment profit margin ratio deteriorated from 2020 to 2021 and from 2021 to 2022.

Segment Profit Margin: Family Dollar

Dollar Tree Inc.; Family Dollar; segment profit margin calculation

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)
Operating income (loss) 543,100 655,600 (81,000) (2,320,000) 517,200 399,500
Net sales 12,387,700 12,243,400 11,102,900 11,111,200 11,081,100 10,580,500
Segment Profitability Ratio
Segment profit margin1 4.38% 5.35% -0.73% -20.88% 4.67% 3.78%

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
Segment profit margin = 100 × Operating income (loss) ÷ Net sales
= 100 × 543,100 ÷ 12,387,700 = 4.38%

Segment profitability ratio Reportable segment The company
Segment profit margin Family Dollar Family Dollar segment profit margin ratio improved from 2020 to 2021 but then slightly deteriorated from 2021 to 2022.

Segment Return on Assets (Segment ROA)

Dollar Tree Inc., ROA by reportable segment

Microsoft Excel
Jan 29, 2022 Jan 30, 2021 Feb 1, 2020 Feb 2, 2019 Feb 3, 2018 Jan 28, 2017
Dollar Tree 17.17% 18.43% 21.55% 41.22% 36.03% 35.23%
Family Dollar 4.57% 5.67% -0.71% -25.37% 4.23% 3.33%

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

Segment profitability ratio Reportable segment The company
Segment ROA Dollar Tree Dollar Tree segment ROA deteriorated from 2020 to 2021 and from 2021 to 2022.
Family Dollar Family Dollar segment ROA improved from 2020 to 2021 but then slightly deteriorated from 2021 to 2022.

Segment ROA: Dollar Tree

Dollar Tree Inc.; Dollar Tree; segment ROA calculation

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)
Operating income (loss) 1,607,000 1,598,000 1,657,800 1,645,900 1,481,900 1,305,300
Total assets 9,358,400 8,669,300 7,694,000 3,992,600 4,113,400 3,705,500
Segment Profitability Ratio
Segment ROA1 17.17% 18.43% 21.55% 41.22% 36.03% 35.23%

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
Segment ROA = 100 × Operating income (loss) ÷ Total assets
= 100 × 1,607,000 ÷ 9,358,400 = 17.17%

Segment profitability ratio Reportable segment The company
Segment ROA Dollar Tree Dollar Tree segment ROA deteriorated from 2020 to 2021 and from 2021 to 2022.

Segment ROA: Family Dollar

Dollar Tree Inc.; Family Dollar; segment ROA calculation

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)
Operating income (loss) 543,100 655,600 (81,000) (2,320,000) 517,200 399,500
Total assets 11,871,800 11,562,200 11,484,900 9,144,700 12,219,400 11,996,100
Segment Profitability Ratio
Segment ROA1 4.57% 5.67% -0.71% -25.37% 4.23% 3.33%

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
Segment ROA = 100 × Operating income (loss) ÷ Total assets
= 100 × 543,100 ÷ 11,871,800 = 4.57%

Segment profitability ratio Reportable segment The company
Segment ROA Family Dollar Family Dollar segment ROA improved from 2020 to 2021 but then slightly deteriorated from 2021 to 2022.

Segment Asset Turnover

Dollar Tree Inc., asset turnover by reportable segment

Microsoft Excel
Jan 29, 2022 Jan 30, 2021 Feb 1, 2020 Feb 2, 2019 Feb 3, 2018 Jan 28, 2017
Dollar Tree 1.49 1.53 1.63 2.93 2.71 2.74
Family Dollar 1.04 1.06 0.97 1.22 0.91 0.88

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

Segment activity ratio Reportable segment The company
Segment asset turnover Dollar Tree Dollar Tree segment asset turnover ratio deteriorated from 2020 to 2021 and from 2021 to 2022.
Family Dollar Family Dollar segment asset turnover ratio improved from 2020 to 2021 but then slightly deteriorated from 2021 to 2022.

Segment Asset Turnover: Dollar Tree

Dollar Tree Inc.; Dollar Tree; segment asset turnover calculation

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 13,922,100 13,265,000 12,507,900 11,712,100 11,164,400 10,138,700
Total assets 9,358,400 8,669,300 7,694,000 3,992,600 4,113,400 3,705,500
Segment Activity Ratio
Segment asset turnover1 1.49 1.53 1.63 2.93 2.71 2.74

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
Segment asset turnover = Net sales ÷ Total assets
= 13,922,100 ÷ 9,358,400 = 1.49

Segment activity ratio Reportable segment The company
Segment asset turnover Dollar Tree Dollar Tree segment asset turnover ratio deteriorated from 2020 to 2021 and from 2021 to 2022.

Segment Asset Turnover: Family Dollar

Dollar Tree Inc.; Family Dollar; segment asset turnover calculation

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 12,387,700 12,243,400 11,102,900 11,111,200 11,081,100 10,580,500
Total assets 11,871,800 11,562,200 11,484,900 9,144,700 12,219,400 11,996,100
Segment Activity Ratio
Segment asset turnover1 1.04 1.06 0.97 1.22 0.91 0.88

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
Segment asset turnover = Net sales ÷ Total assets
= 12,387,700 ÷ 11,871,800 = 1.04

Segment activity ratio Reportable segment The company
Segment asset turnover Family Dollar Family Dollar segment asset turnover ratio improved from 2020 to 2021 but then slightly deteriorated from 2021 to 2022.

Segment Capital Expenditures to Depreciation

Dollar Tree Inc., capital expenditures to depreciation by reportable segment

Microsoft Excel
Jan 29, 2022 Jan 30, 2021 Feb 1, 2020 Feb 2, 2019 Feb 3, 2018 Jan 28, 2017
Dollar Tree 1.51 1.56 1.97 1.79 1.52 1.68
Family Dollar 1.35 1.03 1.25 0.72 0.69 0.40

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

Segment financial ratio Reportable segment The company
Segment capital expenditures to depreciation Dollar Tree Dollar Tree segment capital expenditures to depreciation ratio deteriorated from 2020 to 2021 and from 2021 to 2022.
Family Dollar Family Dollar segment capital expenditures to depreciation ratio deteriorated from 2020 to 2021 but then improved from 2021 to 2022 exceeding 2020 level.

Segment Capital Expenditures to Depreciation: Dollar Tree

Dollar Tree Inc.; Dollar Tree; segment capital expenditures to depreciation calculation

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)
Additions to property, plant and equipment 477,100 470,400 547,500 455,600 383,100 404,900
Depreciation and amortization expense 316,000 302,300 277,700 254,000 251,800 241,300
Segment Financial Ratio
Segment capital expenditures to depreciation1 1.51 1.56 1.97 1.79 1.52 1.68

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
Segment capital expenditures to depreciation = Additions to property, plant and equipment ÷ Depreciation and amortization expense
= 477,100 ÷ 316,000 = 1.51

Segment financial ratio Reportable segment The company
Segment capital expenditures to depreciation Dollar Tree Dollar Tree segment capital expenditures to depreciation ratio deteriorated from 2020 to 2021 and from 2021 to 2022.

Segment Capital Expenditures to Depreciation: Family Dollar

Dollar Tree Inc.; Family Dollar; segment capital expenditures to depreciation calculation

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)
Additions to property, plant and equipment 498,900 362,100 425,200 251,000 249,100 159,800
Depreciation and amortization expense 369,800 352,600 339,100 346,500 359,700 396,500
Segment Financial Ratio
Segment capital expenditures to depreciation1 1.35 1.03 1.25 0.72 0.69 0.40

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
Segment capital expenditures to depreciation = Additions to property, plant and equipment ÷ Depreciation and amortization expense
= 498,900 ÷ 369,800 = 1.35

Segment financial ratio Reportable segment The company
Segment capital expenditures to depreciation Family Dollar Family Dollar segment capital expenditures to depreciation ratio deteriorated from 2020 to 2021 but then improved from 2021 to 2022 exceeding 2020 level.

Net sales

Dollar Tree Inc., net sales by reportable segment

US$ in thousands

Microsoft Excel
Jan 29, 2022 Jan 30, 2021 Feb 1, 2020 Feb 2, 2019 Feb 3, 2018 Jan 28, 2017
Dollar Tree 13,922,100 13,265,000 12,507,900 11,712,100 11,164,400 10,138,700
Family Dollar 12,387,700 12,243,400 11,102,900 11,111,200 11,081,100 10,580,500
Consolidated 26,309,800 25,508,400 23,610,800 22,823,300 22,245,500 20,719,200

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


Operating income (loss)

Dollar Tree Inc., operating income (loss) by reportable segment

US$ in thousands

Microsoft Excel
Jan 29, 2022 Jan 30, 2021 Feb 1, 2020 Feb 2, 2019 Feb 3, 2018 Jan 28, 2017
Dollar Tree 1,607,000 1,598,000 1,657,800 1,645,900 1,481,900 1,305,300
Family Dollar 543,100 655,600 (81,000) (2,320,000) 517,200 399,500
Corporate, support and Other (338,700) (365,700) (314,600) (265,400)
Consolidated 1,811,400 1,887,900 1,262,200 (939,500) 1,999,100 1,704,800

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


Depreciation and amortization expense

Dollar Tree Inc., depreciation and amortization expense by reportable segment

US$ in thousands

Microsoft Excel
Jan 29, 2022 Jan 30, 2021 Feb 1, 2020 Feb 2, 2019 Feb 3, 2018 Jan 28, 2017
Dollar Tree 316,000 302,300 277,700 254,000 251,800 241,300
Family Dollar 369,800 352,600 339,100 346,500 359,700 396,500
Corporate, support and Other 30,200 31,800 28,900 20,900
Consolidated 716,000 686,700 645,700 621,400 611,500 637,800

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


Total assets

Dollar Tree Inc., total assets by reportable segment

US$ in thousands

Microsoft Excel
Jan 29, 2022 Jan 30, 2021 Feb 1, 2020 Feb 2, 2019 Feb 3, 2018 Jan 28, 2017
Dollar Tree 9,358,400 8,669,300 7,694,000 3,992,600 4,113,400 3,705,500
Family Dollar 11,871,800 11,562,200 11,484,900 9,144,700 12,219,400 11,996,100
Corporate, support and Other 491,600 464,500 395,700 363,900
Consolidated 21,721,800 20,696,000 19,574,600 13,501,200 16,332,800 15,701,600

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


Additions to property, plant and equipment

Dollar Tree Inc., additions to property, plant and equipment by reportable segment

US$ in thousands

Microsoft Excel
Jan 29, 2022 Jan 30, 2021 Feb 1, 2020 Feb 2, 2019 Feb 3, 2018 Jan 28, 2017
Dollar Tree 477,100 470,400 547,500 455,600 383,100 404,900
Family Dollar 498,900 362,100 425,200 251,000 249,100 159,800
Corporate, support and Other 45,200 66,300 62,100 110,500
Consolidated 1,021,200 898,800 1,034,800 817,100 632,200 564,700

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