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.

Cash Flow Statement 
Quarterly Data

The cash flow statement provides information about a company cash receipts and cash payments during an accounting period, showing how these cash flows link the ending cash balance to the beginning balance shown on the company balance sheet.

The cash flow statement consists of three parts: cash flows provided by (used in) operating activities, cash flows provided by (used in) investing activities, and cash flows provided by (used in) financing activities.

Dollar Tree Inc., consolidated cash flow statement (quarterly data)

US$ in thousands

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 income (loss) 266,900 359,900 536,400 454,200 216,800 282,400 374,500 502,800 330,000 261,500 247,600 123,000 255,800 180,300 267,900 (2,307,000) 281,800 273,900 160,500 1,040,100 239,900 233,800 200,500 321,800 171,600 170,100 232,700
Depreciation and amortization 189,000 193,500 188,900 188,700 178,500 176,100 172,700 182,900 170,100 168,100 165,500 179,100 160,000 155,100 151,200 166,700 150,400 152,500 151,500 156,600 149,400 151,300 153,900 155,700 157,600 161,900 162,300
Provision for deferred income taxes 38,600 4,500 74,300 (108,200) 67,700 (4,700) 22,000 (28,700) 35,800 (29,100) 52,700 (41,200) 41,300 6,000 3,000 (25,900) 23,200 (400) (9,000) (489,300) 22,600 16,200 (23,000) (33,000) (60,000) (10,700) (20,400)
Stock-based compensation expense 24,700 30,300 35,800 16,800 13,500 17,800 31,800 13,400 14,800 23,100 32,600 8,900 8,400 13,600 30,500
Amortization of debt discount and debt-issuance costs 1,100 1,200 1,100 4,000 1,600 1,700 1,600 900 1,000 1,000 1,100 2,000 1,600 1,700 1,600 3,500 2,000 2,000 49,700 3,400 3,600 4,800 3,600 15,700 30,000 4,800 4,700
Goodwill impairment 313,000 2,727,000
Receivable impairment (35,000) 2,600 50,900
Other non-cash adjustments to net income (loss) 7,600 3,100 15,700 2,600 2,600 4,800 1,200 11,600 3,700 1,700 2,000 300 6,900 14,400 2,900 7,600 14,200 15,500 33,600 15,000 12,400 16,300 32,900 12,400 15,500 15,400 27,700
Loss on debt extinguishment 43,800 114,700
Changes in operating assets and liabilities (314,400) (610,400) (313,700) (189,100) (198,100) (298,200) (47,600) 299,700 (258,700) 51,700 457,500 270,200 (303,500) (141,200) 157,000 143,200 (189,500) (62,300) (113,400) 226,800 (510,500) (180,500) 11,900 545,400 (339,700) 27,800 (96,000)
Adjustments to reconcile net income (loss) to net cash provided by operating activities (53,400) (377,800) 2,100 (41,400) 65,800 (102,500) 181,700 479,800 (33,300) 216,500 711,400 732,300 (85,300) 49,600 346,200 3,022,100 300 107,300 227,100 (122,500) (322,500) 10,700 230,200 696,200 (196,600) 199,200 78,300
Net cash provided by operating activities 213,500 (17,900) 538,500 412,800 282,600 179,900 556,200 982,600 296,700 478,000 959,000 855,300 170,500 229,900 614,100 715,100 282,100 381,200 387,600 917,600 (82,600) 244,500 430,700 1,018,000 (25,000) 369,300 311,000
Capital expenditures (391,200) (276,200) (253,400) (271,600) (295,600) (229,100) (224,900) (191,800) (238,700) (232,500) (235,800) (252,500) (279,800) (293,300) (209,200) (194,400) (228,400) (213,400) (180,900) (182,800) (177,700) (161,400) (110,300) (113,200) (95,600) (180,000) (175,900)
Proceeds from governmental grant 600 2,300 16,500
Purchase of restricted investments (36,100)
Proceeds from sale of unrestricted investments 4,000 118,100
Proceeds from (payments for) fixed asset disposition (1,300) (900) (2,900) (2,000) 200 400 (200) 9,600 2,300 (2,700) (100) 1,000 (200) (3,000) 300 (2,900) 3,700 (200) (200) 400 (2,200) (100) 2,200 (2,100) (300) 400 1,100
Net cash used in investing activities (392,500) (277,100) (256,300) (273,600) (294,800) (228,700) (222,800) (182,200) (236,400) (235,200) (235,900) (251,500) (280,000) (296,300) (192,400) (197,300) (224,700) (213,600) (181,100) (182,400) (175,900) (161,500) (108,100) (115,300) (95,900) (179,600) (92,800)
Proceeds from long-term debt, net of discount 1,197,400 4,775,800 2,962,500
Principal payments for long-term debt (1,000,000) (300,000) (250,000) (500,000) (782,000) (5,432,700) (48,300) (41,500) (541,500) (27,800) (777,700) (3,204,500) (33,200) (20,800)
Debt-issuance and debt extinguishment costs (59,300) (155,300) (5,400) (700)
Proceeds from revolving credit facility 440,000 750,000 50,000 140,000
Repayments of revolving credit facility (90,000) (500,000) (250,000) (50,000) (140,000)
Proceeds from stock issued pursuant to stock-based compensation plans 2,300 1,900 2,900 8,800 2,400 2,600 4,000 2,700 2,500 2,100 9,700 2,900 3,200 3,300 5,800 3,300 4,000 5,600 4,600 10,600 9,500 3,100 11,800 8,200 10,600 8,300 14,400
Cash paid for taxes on exercises/vesting of stock-based compensation (9,300) (300) (37,800) (1,800) (700) (600) (39,300) (100) (400) (300) (16,100) (700) (400) (600) (23,300) (600) (900) (500) (21,200) (200) (2,500) (7,100) (17,600) (1,000) (1,300) (1,500) (18,400)
Payments for repurchase of stock (397,500) (235,800) (14,200) (2,500) (706,200) (241,300) (205,800) (194,200) (60,800) (39,200) (100,000)
Net cash provided by (used in) financing activities (54,500) (234,200) (49,100) 145,100 (800) (704,200) (276,600) (503,200) (692,100) (248,200) 493,600 (497,800) (58,000) (36,500) (117,500) (779,300) 3,100 5,100 (828,800) (37,900) (34,500) (545,500) (33,600) (770,500) (238,100) (27,100) (24,800)
Effect of exchange rate changes on cash, cash equivalents and restricted cash (2,000) (300) 500 (800) 100 (100) 400 1,200 (200) 600 (700) (300) (500) 700 (400) (100) 500 (600) (300) 400 (200) 900 (500) 400 (400) 900 200
Net increase (decrease) in cash, cash equivalents and restricted cash (235,500) (529,500) 233,600 283,500 (12,900) (753,100) 57,200 298,400 (632,000) (4,800) 1,216,000 105,700 (168,000) (102,200) 303,800 (261,600) 61,000 172,100 (622,600) 697,700 (293,200) (461,600) 288,500 132,600 (359,400) 163,500 193,600

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


Net income (loss)
The net income demonstrates significant volatility across the periods, with generally positive values interrupted by a notable loss of -2.3 billion in February 2019. Following this, profits resumed and exhibited upward trends, with peaks reaching over 500 million in early 2021 and mid-2022, indicating recovery and growth phases.
Depreciation and amortization
Depreciation and amortization remain relatively stable, fluctuating moderately between approximately 150 million and 190 million, with a slight increasing tendency towards later periods, suggesting consistent capital asset utilization and amortization of intangibles.
Provision for deferred income taxes
The provision for deferred income taxes is inconsistent, with both positive and negative values, including a substantial negative adjustment of nearly -489 million in early 2018 and a large negative adjustment of -108 million in April 2022. These fluctuations indicate variable tax timing differences impacting reported earnings.
Stock-based compensation expense
This expense appears intermittently from early 2019 onward, with amounts ranging from about 8 million to 36 million. The expense shows some episodic spikes, implying varying stock compensation grants or accounting adjustments during these intervals.
Amortization of debt discount and debt-issuance costs
With some spikes, notably a 49.7 million amount in May 2018, this expense is generally stable but occasionally elevated, reflecting episodic financing activities and associated amortization.
Goodwill impairment
A major goodwill impairment occurred in November 2018 with an amount exceeding 2.7 billion, and a smaller impairment of 313 million in early 2020, signaling significant asset write-downs and possible restructuring or impairment events during these times.
Receivable impairment
Recorded only in a few periods around 2017, with a peak impairment of 50.9 million and some recoveries, evidencing occasional credit losses or adjustments related to receivables.
Other non-cash adjustments to net income (loss)
This category varies broadly but generally remains positive, with amounts mostly between 1 million and 33 million, showing regular non-cash earnings adjustments affecting reported net income.
Loss on debt extinguishment
Reported notably in early 2018 with 114.7 million and again in October 2022 with 43.8 million, reflecting one-time costs related to debt refinancing or retirement activities during those periods.
Changes in operating assets and liabilities
Substantial swings are observed, ranging from large negative values such as -610 million in July 2022 to significant positive adjustments like 545 million in January 2017, indicating considerable working capital fluctuations impacting operating cash flows.
Adjustments to reconcile net income (loss) to net cash provided by operating activities
These adjustments display broad variability, often large and positive, peaking at over 3 billion in February 2019, likely driven by major non-cash charges such as goodwill impairment and working capital changes during that timeframe.
Net cash provided by operating activities
Operating cash flows are highly variable, with negative cash flow noted in several quarters (e.g., October 2016 and July 2022), but generally show recovery and strong positive inflows exceeding 900 million in several periods, indicating episodic operational performance swings but overall operational cash generation.
Capital expenditures
Consistently negative and substantial, capital expenditures generally range from approximately 110 million to 390 million per quarter, indicating ongoing and significant investments in property, plant, and equipment, with a trend toward higher spending in recent quarters.
Proceeds from governmental grant
Sparse and relatively low values are observed in a few periods, suggesting occasional government assistance or grants contributing marginally to cash inflows.
Purchase and sale of investments and fixed assets disposition
These activities are intermittent and generally modest, contributing minor positive or negative cash impacts, reflecting routine investment portfolio and asset management transactions.
Net cash used in investing activities
Investing cash flows consistently show outflows, reflecting ongoing capital expenditure commitments and investment activities, ranging mostly from around -90 million to nearly -400 million per quarter, with an increasing outflow trend in later periods.
Long-term debt activities
Substantial long-term debt issuances occur in February 2017 and February 2018, with proceeds of approximately 2.9 billion and 4.8 billion respectively, offset by significant repayments in other periods, indicating active debt financing and refinancing strategies.
Revolving credit facility activities
Utilizations and repayments fluctuate, with notable borrowings such as 750 million in August 2021 and repayments up to 500 million in other quarters, reflecting short-term liquidity management practices.
Proceeds from stock issued and stock-based compensation related cash flows
Issuance proceeds from stock-based compensation plans occur regularly but at relatively low magnitudes compared to other cash flows, partially offset by tax payments related to stock compensation exercises, indicating moderate influence on financing cash flow.
Payments for repurchase of stock
Significant stock repurchase activities occur predominantly from late 2018 through 2021, with amounts peaking at over 700 million in the first quarter of 2020, reflecting an aggressive share buyback program during this period.
Net cash provided by (used in) financing activities
The financing cash flows exhibit large negative values in multiple periods, highlighting heavy debt repayments and share buybacks, with occasional positive inflows due to debt issuances or stock issuance. The variability underscores dynamic capital structure management.
Effect of exchange rate changes on cash
Exchange rate effects are minimal and mostly fluctuate around zero, indicating limited impact of foreign currency on cash balances.
Net increase (decrease) in cash, cash equivalents, and restricted cash
The net cash position experiences marked volatility, with some quarters showing very large increases (e.g., over 1.2 billion in May 2020) and others showing substantial decreases (e.g., -753 million in July 2021), reflecting the combined impact of the company's operational, investing, and financing activities.