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 Income Statement 
Quarterly Data

Dollar Tree Inc., common-size consolidated income statement (quarterly data)

Microsoft Excel
3 months ended: 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 sales 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00 100.00
Cost of sales -70.14 -68.60 -66.08 -69.80 -72.51 -70.65 -69.67 -68.20 -68.85 -69.48 -71.45 -68.96 -70.34 -71.28 -70.27 -69.19 -69.81 -69.89 -69.40 -66.97 -68.66 -69.18 -69.23 -67.93 -69.60 -69.73 -69.43
Gross profit 29.86% 31.40% 33.92% 30.20% 27.49% 29.35% 30.33% 31.80% 31.15% 30.52% 28.55% 31.04% 29.66% 28.72% 29.73% 30.81% 30.19% 30.11% 30.60% 33.03% 31.34% 30.82% 30.77% 32.07% 30.40% 30.27% 30.57%
Other revenue 0.05 0.05 0.04 0.05 0.04 0.05 0.04 0.01 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Selling, general and administrative expenses -24.41 -23.98 -23.35 -22.06 -22.69 -23.06 -22.34 -21.74 -23.62 -24.55 -22.73 -22.14 -23.43 -24.03 -23.10 -21.47 -23.18 -23.19 -22.72 -21.55 -23.34 -22.83 -22.46 -21.66 -23.55 -23.12 -22.33
Goodwill impairment 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 -4.96 0.00 0.00 0.00 -43.95 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Receivable impairment 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.55 0.00 -0.05 -0.96 0.00 0.00 0.00 0.00
Selling, general and administrative expenses -24.41% -23.98% -23.35% -22.06% -22.69% -23.06% -22.34% -21.74% -23.62% -24.55% -22.73% -27.09% -23.43% -24.03% -23.10% -65.42% -23.18% -23.19% -22.72% -20.99% -23.34% -22.88% -23.42% -21.66% -23.55% -23.12% -22.33%
Operating income (loss) 5.50% 7.47% 10.60% 8.18% 4.84% 6.34% 8.03% 10.07% 7.54% 5.97% 5.82% 3.95% 6.24% 4.68% 6.64% -34.61% 7.00% 6.92% 7.88% 12.04% 8.00% 7.94% 7.35% 10.41% 6.85% 7.15% 8.23%
Interest expense, net -0.47 -0.45 -0.49 -1.12 -0.52 -0.52 -0.51 -0.51 -0.62 -0.55 -0.64 -0.62 -0.72 -0.70 -0.71 -0.75 -0.86 -0.83 -4.14 -1.28 -1.31 -1.44 -1.41 -1.58 -2.24 -1.75 -1.72
Other income (expense), net 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 -0.01 -0.01 0.00 -0.01 0.00 -0.01 0.00 0.02 0.00 0.12 -0.01 0.00 -0.01 0.00 0.00 0.00 0.00
Income (loss) before income taxes 5.02% 7.02% 10.11% 7.05% 4.32% 5.82% 7.52% 9.57% 6.92% 5.41% 5.17% 3.32% 5.51% 3.98% 5.92% -35.36% 6.14% 6.11% 3.73% 10.87% 6.68% 6.51% 5.94% 8.83% 4.60% 5.40% 6.52%
Provision for income taxes -1.17 -1.70 -2.33 -0.64 -0.94 -1.37 -1.74 -2.14 -1.58 -1.25 -1.23 -1.37 -1.06 -0.84 -1.31 -1.82 -1.05 -1.15 -0.84 5.48 -2.17 -2.08 -2.14 -3.12 -1.17 -2.00 -1.94
Net income (loss) 3.85% 5.32% 7.77% 6.42% 3.38% 4.45% 5.78% 7.43% 5.34% 4.17% 3.94% 1.95% 4.45% 3.14% 4.61% -37.18% 5.09% 4.96% 2.89% 16.35% 4.51% 4.43% 3.79% 5.71% 3.43% 3.41% 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).


Gross Profit and Cost of Sales
Gross profit as a percentage of net sales generally fluctuated between approximately 28.5% and 33%, demonstrating some variability across the quarters. Notably, gross profit reached a peak of around 33.9% in April 2022, indicating improved cost management or pricing effectiveness in that quarter. Correspondingly, the cost of sales showed inverse movement, mostly ranging from -66% to -72%, with a notable trough in April 2022 at about -66.1%, signaling a reduction in cost burden during this period.
Selling, General and Administrative Expenses
These expenses largely maintained a range between approximately -21.5% and -24.5% of net sales, reflecting a relatively stable cost base in this category. There was an exceptional spike to about -65.4% in February 2019, coinciding with a significant goodwill impairment charge, which heavily affected the expense figures for that quarter. Aside from this outlier, expenses demonstrated moderate oscillations without a clear upward or downward trend.
Operating Income (Loss)
Operating income showed considerable volatility. Excluding the extreme loss in February 2019 (-34.61%), operating margins generally ranged from around 3.9% to 12%, with intermittent peaks such as 12.04% in February 2018 and 10.6% in April 2022. The data suggests that operating profitability was resilient despite fluctuations in gross profit and operating expenses, though occasional impairments had significant negative impacts.
Interest Expense, Net
Interest expenses were relatively stable and low, generally hovering between -0.45% and -1.7% of net sales. An anomaly occurred in February 2018 with a spike to -4.14%, which may indicate a one-time event or refinancing impact. Otherwise, this expense remained a minor portion of sales.
Income Before Income Taxes and Net Income
Income before taxes mirrored the patterns seen in operating income, with a similar sharp decline in February 2019 (-35.36%) likely driven by the impairment charge. Outside this quarter, income before taxes generally ranged between 3% and 10%, with several peaks above 9% during notable earnings quarters. Net income followed a consistent pattern, ranging mostly between about 3% and 7.8%, with a significant negative result in February 2019 (-37.18%), again aligned with extraordinary charges.
Provision for Income Taxes
The tax provision fluctuated across the periods, with percentages partly negative and partly positive. Most quarters showed a tax charge between -0.6% and -2.3%, except for a positive tax figure of 5.48% in February 2018, which suggests a tax benefit or adjustment during that quarter. The variability in this line item corresponds with fluctuations in pre-tax income and unusual items affecting taxable income.
Exceptional Items
The data highlights significant impairment losses recognized in certain periods, particularly goodwill impairment of -43.95% in November 2018 and -4.96% in February 2020. These non-recurring charges had an acute negative effect on profitability metrics and are responsible for the sharp deviations observed in those quarters. Additionally, a small receivable impairment occurred in October 2016 and February 2018, though its impact was minor relative to goodwill impairments.
Other Revenue and Other Income (Expense), Net
Other revenue was negligible, emerging near zero in recent quarters. Other income/expense was essentially minimal and fluctuated near zero, indicating these components did not materially influence financial outcomes during the periods analyzed.