Analysis of Short-term (Operating) Activity Ratios
Quarterly Data
Activity ratios measure how efficiently a company performs day-to-day tasks, such us the collection of receivables and management of inventory.
Short-term Activity Ratios (Summary)
Dollar Tree Inc., short-term (operating) activity ratios (quarterly data)
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).
| Short-term activity ratio | Description | The company |
|---|---|---|
| Inventory turnover | An activity ratio calculated as cost of goods sold divided by inventory. | Dollar Tree Inc. inventory turnover ratio deteriorated from Q1 2023 to Q2 2023 and from Q2 2023 to Q3 2023. |
| Payables turnover | An activity ratio calculated as cost of goods sold divided by payables. | Dollar Tree Inc. payables turnover ratio decreased from Q1 2023 to Q2 2023 but then increased from Q2 2023 to Q3 2023 not reaching Q1 2023 level. |
| Working capital turnover | An activity ratio calculated as revenue divided by working capital. | Dollar Tree Inc. working capital turnover ratio improved from Q1 2023 to Q2 2023 and from Q2 2023 to Q3 2023. |
| Short-term activity ratio | Description | The company |
|---|---|---|
| Average inventory processing period | An activity ratio equal to the number of days in the period divided by inventory turnover over the period. | Dollar Tree Inc. number of days of inventory outstanding deteriorated from Q1 2023 to Q2 2023 and from Q2 2023 to Q3 2023. |
| Average payables payment period | An estimate of the average number of days it takes a company to pay its suppliers; equal to the number of days in the period divided by payables turnover ratio for the period. | Dollar Tree Inc. number of days of payables outstanding increased from Q1 2023 to Q2 2023 but then slightly decreased from Q2 2023 to Q3 2023 not reaching Q1 2023 level. |
Inventory Turnover
Dollar Tree Inc., inventory turnover calculation (quarterly data)
| 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) | |||||||||||||||||||||||||||||||||||
| Cost of sales | 4,865,100) | 4,640,900) | 4,559,600) | 4,940,300) | 4,651,700) | 4,479,200) | 4,512,700) | 4,615,100) | 4,252,600) | 4,361,400) | 4,491,900) | 4,354,800) | 4,041,700) | 4,092,100) | 4,081,500) | 4,293,100) | 3,866,900) | 3,861,700) | 3,854,100) | 4,259,600) | 3,650,600) | 3,653,400) | 3,660,000) | 3,828,300) | 3,481,100) | 3,483,900) | 3,531,200) | ||||||||
| Merchandise inventories | 5,657,700) | 5,422,200) | 4,801,100) | 4,367,300) | 4,316,000) | 3,667,700) | 3,604,600) | 3,427,000) | 3,792,300) | 3,275,700) | 3,198,500) | 3,522,000) | 3,882,900) | 3,470,900) | 3,325,500) | 3,536,000) | 3,715,600) | 3,288,200) | 3,248,200) | 3,169,300) | 3,397,800) | 2,928,500) | 2,878,400) | 2,865,800) | 3,273,900) | 2,975,100) | 2,929,500) | ||||||||
| Short-term Activity Ratio | |||||||||||||||||||||||||||||||||||
| Inventory turnover1 | 3.36 | 3.47 | 3.88 | 4.26 | 4.23 | 4.87 | 4.92 | 5.17 | 4.60 | 5.27 | 5.31 | 4.70 | 4.25 | 4.71 | 4.84 | 4.49 | 4.26 | 4.75 | 4.75 | 4.80 | 4.35 | 4.99 | 5.02 | 5.00 | — | — | — | ||||||||
| Benchmarks | |||||||||||||||||||||||||||||||||||
| Inventory Turnover, Competitors2 | |||||||||||||||||||||||||||||||||||
| Costco Wholesale Corp. | 12.68 | 12.82 | 10.94 | 11.13 | 10.81 | 11.14 | 10.46 | 12.01 | 11.62 | 11.19 | 10.08 | 11.84 | 12.70 | 11.63 | 9.73 | 11.66 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| Dollar General Corp. | 3.49 | 3.49 | 3.91 | 4.17 | 4.37 | 4.33 | 4.48 | 4.39 | 4.42 | 4.90 | 4.99 | 4.12 | 4.22 | 4.20 | 4.43 | 4.35 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| Target Corp. | 4.73 | 5.19 | 5.09 | 5.39 | 4.86 | 6.22 | 6.49 | 6.21 | 4.94 | 6.78 | 6.65 | 6.10 | 4.80 | 5.95 | 5.95 | 5.61 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| Walmart Inc. | 7.01 | 7.40 | 7.06 | 7.59 | 7.46 | 8.88 | 9.09 | 9.35 | 7.96 | 9.94 | 9.79 | 8.88 | 7.60 | 8.81 | 8.64 | 8.70 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
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
Inventory turnover
= (Cost of salesQ3 2023
+ Cost of salesQ2 2023
+ Cost of salesQ1 2023
+ Cost of salesQ4 2022)
÷ Merchandise inventories
= (4,865,100 + 4,640,900 + 4,559,600 + 4,940,300)
÷ 5,657,700 = 3.36
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Inventory turnover | An activity ratio calculated as cost of goods sold divided by inventory. | Dollar Tree Inc. inventory turnover ratio deteriorated from Q1 2023 to Q2 2023 and from Q2 2023 to Q3 2023. |
Payables Turnover
Dollar Tree Inc., payables turnover calculation (quarterly data)
| 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) | |||||||||||||||||||||||||||||||||||
| Cost of sales | 4,865,100) | 4,640,900) | 4,559,600) | 4,940,300) | 4,651,700) | 4,479,200) | 4,512,700) | 4,615,100) | 4,252,600) | 4,361,400) | 4,491,900) | 4,354,800) | 4,041,700) | 4,092,100) | 4,081,500) | 4,293,100) | 3,866,900) | 3,861,700) | 3,854,100) | 4,259,600) | 3,650,600) | 3,653,400) | 3,660,000) | 3,828,300) | 3,481,100) | 3,483,900) | 3,531,200) | ||||||||
| Accounts payable | 1,864,200) | 2,011,300) | 1,794,100) | 1,884,200) | 1,984,800) | 1,559,600) | 1,520,700) | 1,480,500) | 1,587,200) | 1,481,000) | 1,336,900) | 1,336,500) | 1,473,100) | 1,455,400) | 1,186,500) | 1,416,400) | 1,365,100) | 1,241,700) | 1,181,500) | 1,174,800) | 1,181,300) | 1,196,300) | 1,223,900) | 1,119,600) | 1,266,400) | 1,351,500) | 1,260,300) | ||||||||
| Short-term Activity Ratio | |||||||||||||||||||||||||||||||||||
| Payables turnover1 | 10.20 | 9.34 | 10.38 | 9.86 | 9.20 | 11.45 | 11.67 | 11.97 | 11.00 | 11.65 | 12.70 | 12.40 | 11.21 | 11.22 | 13.57 | 11.21 | 11.61 | 12.58 | 13.05 | 12.96 | 12.52 | 12.22 | 11.81 | 12.79 | — | — | — | ||||||||
| Benchmarks | |||||||||||||||||||||||||||||||||||
| Payables Turnover, Competitors2 | |||||||||||||||||||||||||||||||||||
| Costco Wholesale Corp. | 12.28 | 12.56 | 11.07 | 11.17 | 10.80 | 10.74 | 9.06 | 10.49 | 10.45 | 10.79 | 8.83 | 10.23 | 12.93 | 12.45 | 9.31 | 11.38 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| Dollar General Corp. | 6.04 | 5.56 | 6.09 | 6.26 | 6.55 | 6.79 | 6.93 | 6.37 | 5.90 | 6.33 | 6.94 | 6.73 | 6.67 | 6.80 | 7.42 | 7.47 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| Target Corp. | 5.25 | 5.34 | 5.46 | 4.84 | 4.47 | 5.54 | 5.88 | 5.15 | 4.42 | 5.61 | 5.94 | 5.53 | 4.86 | 5.93 | 6.45 | 5.46 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| Walmart Inc. | 7.93 | 8.18 | 8.17 | 7.76 | 7.50 | 8.55 | 8.75 | 8.55 | 7.62 | 8.81 | 9.15 | 8.40 | 7.87 | 8.48 | 8.57 | 8.19 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
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
Payables turnover
= (Cost of salesQ3 2023
+ Cost of salesQ2 2023
+ Cost of salesQ1 2023
+ Cost of salesQ4 2022)
÷ Accounts payable
= (4,865,100 + 4,640,900 + 4,559,600 + 4,940,300)
÷ 1,864,200 = 10.20
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Payables turnover | An activity ratio calculated as cost of goods sold divided by payables. | Dollar Tree Inc. payables turnover ratio decreased from Q1 2023 to Q2 2023 but then increased from Q2 2023 to Q3 2023 not reaching Q1 2023 level. |
Working Capital Turnover
Dollar Tree Inc., working capital turnover calculation (quarterly data)
| 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) | |||||||||||||||||||||||||||||||||||
| Current assets | 6,446,600) | 6,377,300) | 6,282,300) | 5,609,200) | 5,374,500) | 4,648,100) | 5,304,900) | 5,050,800) | 5,171,000) | 5,232,500) | 5,165,400) | 4,269,400) | 4,572,300) | 4,340,800) | 4,246,100) | 4,293,300) | 4,749,500) | 4,272,800) | 4,042,000) | 4,576,300) | 3,972,600) | 3,815,200) | 4,278,100) | 3,938,000) | 4,342,400) | 4,449,400) | 4,172,100) | ||||||||
| Less: Current liabilities | 4,683,100) | 4,380,500) | 4,289,900) | 4,176,600) | 4,291,200) | 3,722,700) | 3,902,200) | 3,730,300) | 4,042,300) | 4,278,800) | 4,504,200) | 3,546,500) | 4,179,700) | 4,094,000) | 3,979,300) | 2,095,700) | 2,135,700) | 1,907,400) | 1,917,200) | 2,859,100) | 2,039,900) | 2,084,700) | 2,240,600) | 2,105,900) | 2,134,200) | 2,180,000) | 2,049,100) | ||||||||
| Working capital | 1,763,500) | 1,996,800) | 1,992,400) | 1,432,600) | 1,083,300) | 925,400) | 1,402,700) | 1,320,500) | 1,128,700) | 953,700) | 661,200) | 722,900) | 392,600) | 246,800) | 266,800) | 2,197,600) | 2,613,800) | 2,365,400) | 2,124,800) | 1,717,200) | 1,932,700) | 1,730,500) | 2,037,500) | 1,832,100) | 2,208,200) | 2,269,400) | 2,123,000) | ||||||||
| 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) | ||||||||
| Short-term Activity Ratio | |||||||||||||||||||||||||||||||||||
| Working capital turnover1 | 15.70 | 13.60 | 13.42 | 18.37 | 24.00 | 27.84 | 18.32 | 19.32 | 22.20 | 25.82 | 36.43 | 32.66 | 59.86 | 94.38 | 86.50 | 10.39 | 8.79 | 9.62 | 10.59 | 12.95 | 11.13 | 12.25 | 10.27 | 11.31 | — | — | — | ||||||||
| Benchmarks | |||||||||||||||||||||||||||||||||||
| Working Capital Turnover, Competitors2 | |||||||||||||||||||||||||||||||||||
| Costco Wholesale Corp. | 89.52 | 126.82 | 209.37 | 319.10 | 183.50 | 202.13 | 391.97 | 3,000.81 | — | — | — | 49.82 | 63.59 | 153.67 | 400.20 | 602.22 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| Dollar General Corp. | 23.97 | 304.43 | — | 105.46 | 77.00 | 65.54 | 46.40 | 28.04 | 19.72 | 14.31 | 13.76 | 43.75 | 48.44 | 43.95 | 41.68 | 15.56 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| Target Corp. | — | — | — | — | — | 122.42 | 72.70 | 146.43 | 91.95 | 48.30 | 389.66 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| Walmart Inc. | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||||
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
Working capital turnover
= (Net salesQ3 2023
+ Net salesQ2 2023
+ Net salesQ1 2023
+ Net salesQ4 2022)
÷ Working capital
= (6,936,600 + 6,765,300 + 6,900,100 + 7,077,400)
÷ 1,763,500 = 15.70
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Working capital turnover | An activity ratio calculated as revenue divided by working capital. | Dollar Tree Inc. working capital turnover ratio improved from Q1 2023 to Q2 2023 and from Q2 2023 to Q3 2023. |
Average Inventory Processing Period
Dollar Tree Inc., average inventory processing period calculation (quarterly data)
| 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 | |||||||||||||||||||||||||||||||||||
| Inventory turnover | 3.36 | 3.47 | 3.88 | 4.26 | 4.23 | 4.87 | 4.92 | 5.17 | 4.60 | 5.27 | 5.31 | 4.70 | 4.25 | 4.71 | 4.84 | 4.49 | 4.26 | 4.75 | 4.75 | 4.80 | 4.35 | 4.99 | 5.02 | 5.00 | — | — | — | ||||||||
| Short-term Activity Ratio (no. days) | |||||||||||||||||||||||||||||||||||
| Average inventory processing period1 | 109 | 105 | 94 | 86 | 86 | 75 | 74 | 71 | 79 | 69 | 69 | 78 | 86 | 78 | 75 | 81 | 86 | 77 | 77 | 76 | 84 | 73 | 73 | 73 | — | — | — | ||||||||
| Benchmarks (no. days) | |||||||||||||||||||||||||||||||||||
| Average Inventory Processing Period, Competitors2 | |||||||||||||||||||||||||||||||||||
| Costco Wholesale Corp. | 29 | 28 | 33 | 33 | 34 | 33 | 35 | 30 | 31 | 33 | 36 | 31 | 29 | 31 | 37 | 31 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| Dollar General Corp. | 105 | 104 | 93 | 88 | 84 | 84 | 82 | 83 | 83 | 74 | 73 | 89 | 87 | 87 | 82 | 84 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| Target Corp. | 77 | 70 | 72 | 68 | 75 | 59 | 56 | 59 | 74 | 54 | 55 | 60 | 76 | 61 | 61 | 65 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| Walmart Inc. | 52 | 49 | 52 | 48 | 49 | 41 | 40 | 39 | 46 | 37 | 37 | 41 | 48 | 41 | 42 | 42 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
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
Average inventory processing period = 365 ÷ Inventory turnover
= 365 ÷ 3.36 = 109
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Average inventory processing period | An activity ratio equal to the number of days in the period divided by inventory turnover over the period. | Dollar Tree Inc. number of days of inventory outstanding deteriorated from Q1 2023 to Q2 2023 and from Q2 2023 to Q3 2023. |
Average Payables Payment Period
Dollar Tree Inc., average payables payment period calculation (quarterly data)
| 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 | |||||||||||||||||||||||||||||||||||
| Payables turnover | 10.20 | 9.34 | 10.38 | 9.86 | 9.20 | 11.45 | 11.67 | 11.97 | 11.00 | 11.65 | 12.70 | 12.40 | 11.21 | 11.22 | 13.57 | 11.21 | 11.61 | 12.58 | 13.05 | 12.96 | 12.52 | 12.22 | 11.81 | 12.79 | — | — | — | ||||||||
| Short-term Activity Ratio (no. days) | |||||||||||||||||||||||||||||||||||
| Average payables payment period1 | 36 | 39 | 35 | 37 | 40 | 32 | 31 | 30 | 33 | 31 | 29 | 29 | 33 | 33 | 27 | 33 | 31 | 29 | 28 | 28 | 29 | 30 | 31 | 29 | — | — | — | ||||||||
| Benchmarks (no. days) | |||||||||||||||||||||||||||||||||||
| Average Payables Payment Period, Competitors2 | |||||||||||||||||||||||||||||||||||
| Costco Wholesale Corp. | 30 | 29 | 33 | 33 | 34 | 34 | 40 | 35 | 35 | 34 | 41 | 36 | 28 | 29 | 39 | 32 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| Dollar General Corp. | 60 | 66 | 60 | 58 | 56 | 54 | 53 | 57 | 62 | 58 | 53 | 54 | 55 | 54 | 49 | 49 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| Target Corp. | 70 | 68 | 67 | 75 | 82 | 66 | 62 | 71 | 83 | 65 | 61 | 66 | 75 | 62 | 57 | 67 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| Walmart Inc. | 46 | 45 | 45 | 47 | 49 | 43 | 42 | 43 | 48 | 41 | 40 | 43 | 46 | 43 | 43 | 45 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
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
Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ 10.20 = 36
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Average payables payment period | An estimate of the average number of days it takes a company to pay its suppliers; equal to the number of days in the period divided by payables turnover ratio for the period. | Dollar Tree Inc. number of days of payables outstanding increased from Q1 2023 to Q2 2023 but then slightly decreased from Q2 2023 to Q3 2023 not reaching Q1 2023 level. |