Analysis of Solvency Ratios
Quarterly Data
Solvency ratios also known as long-term debt ratios measure a company ability to meet long-term obligations.
Solvency Ratios (Summary)
Dollar Tree Inc., solvency 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).
| Solvency ratio | Description | The company |
|---|---|---|
| Debt to equity ratio | A solvency ratio calculated as total debt divided by total shareholders’ equity. | Dollar Tree Inc. debt to equity ratio improved from Q1 2023 to Q2 2023 but then deteriorated significantly from Q2 2023 to Q3 2023. |
| Debt to equity (including operating lease liability) ratio | A solvency ratio calculated as total debt (including operating lease liability) divided by total shareholders’ equity. | Dollar Tree Inc. debt to equity ratio (including operating lease liability) improved from Q1 2023 to Q2 2023 but then deteriorated significantly from Q2 2023 to Q3 2023. |
| Debt to capital ratio | A solvency ratio calculated as total debt divided by total debt plus shareholders’ equity. | Dollar Tree Inc. debt to capital ratio improved from Q1 2023 to Q2 2023 but then deteriorated significantly from Q2 2023 to Q3 2023. |
| Debt to capital (including operating lease liability) ratio | A solvency ratio calculated as total debt (including operating lease liability) divided by total debt (including operating lease liability) plus shareholders’ equity. | Dollar Tree Inc. debt to capital ratio (including operating lease liability) improved from Q1 2023 to Q2 2023 but then deteriorated significantly from Q2 2023 to Q3 2023. |
| Debt to assets ratio | A solvency ratio calculated as total debt divided by total assets. | Dollar Tree Inc. debt to assets ratio improved from Q1 2023 to Q2 2023 but then deteriorated significantly from Q2 2023 to Q3 2023. |
| Debt to assets (including operating lease liability) ratio | A solvency ratio calculated as total debt (including operating lease liability) divided by total assets. | Dollar Tree Inc. debt to assets ratio (including operating lease liability) improved from Q1 2023 to Q2 2023 but then deteriorated significantly from Q2 2023 to Q3 2023. |
| Financial leverage ratio | A solvency ratio calculated as total assets divided by total shareholders’ equity. | Dollar Tree Inc. financial leverage ratio decreased from Q1 2023 to Q2 2023 but then increased from Q2 2023 to Q3 2023 exceeding Q1 2023 level. |
| Solvency ratio | Description | The company |
|---|---|---|
| Interest coverage ratio | A solvency ratio calculated as EBIT divided by interest payments. | Dollar Tree Inc. interest coverage ratio improved from Q1 2023 to Q2 2023 and from Q2 2023 to Q3 2023. |
Debt to Equity
Dollar Tree Inc., debt to equity 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 portion of long-term debt | 350,000) | —) | —) | —) | —) | —) | —) | —) | 300,000) | 800,000) | 1,050,000) | 250,000) | 750,000) | 750,000) | 750,000) | —) | —) | —) | —) | 915,900) | 165,900) | 165,900) | 165,900) | 152,100) | 145,800) | 145,500) | 120,500) | ||||||||
| Long-term debt, net, excluding current portion | 3,420,400) | 3,419,300) | 3,418,100) | 3,417,000) | 3,231,100) | 3,229,500) | 3,227,800) | 3,226,200) | 3,225,300) | 3,224,300) | 3,223,300) | 3,522,200) | 3,520,200) | 3,518,600) | 3,516,900) | 4,265,300) | 5,043,800) | 5,041,800) | 5,040,100) | 4,762,100) | 5,557,000) | 5,595,000) | 6,131,700) | 6,169,700) | 6,938,000) | 7,155,700) | 7,209,800) | ||||||||
| Total debt | 3,770,400) | 3,419,300) | 3,418,100) | 3,417,000) | 3,231,100) | 3,229,500) | 3,227,800) | 3,226,200) | 3,525,300) | 4,024,300) | 4,273,300) | 3,772,200) | 4,270,200) | 4,268,600) | 4,266,900) | 4,265,300) | 5,043,800) | 5,041,800) | 5,040,100) | 5,678,000) | 5,722,900) | 5,760,900) | 6,297,600) | 6,321,800) | 7,083,800) | 7,301,200) | 7,330,300) | ||||||||
| Shareholders’ equity | 8,275,300) | 8,396,500) | 8,241,500) | 7,718,500) | 7,244,400) | 7,011,700) | 7,411,300) | 7,285,300) | 6,961,100) | 6,813,600) | 6,520,600) | 6,254,800) | 6,121,300) | 5,865,700) | 5,755,900) | 5,642,900) | 7,943,100) | 7,647,500) | 7,355,700) | 7,182,300) | 6,116,500) | 5,860,200) | 5,609,000) | 5,389,500) | 5,047,700) | 4,856,900) | 4,669,600) | ||||||||
| Solvency Ratio | |||||||||||||||||||||||||||||||||||
| Debt to equity1 | 0.46 | 0.41 | 0.41 | 0.44 | 0.45 | 0.46 | 0.44 | 0.44 | 0.51 | 0.59 | 0.66 | 0.60 | 0.70 | 0.73 | 0.74 | 0.76 | 0.63 | 0.66 | 0.69 | 0.79 | 0.94 | 0.98 | 1.12 | 1.17 | 1.40 | 1.50 | 1.57 | ||||||||
| Benchmarks | |||||||||||||||||||||||||||||||||||
| Debt to Equity, Competitors2 | |||||||||||||||||||||||||||||||||||
| Costco Wholesale Corp. | 0.28 | 0.29 | 0.30 | 0.32 | 0.33 | 0.34 | 0.40 | 0.43 | 0.46 | 0.49 | 0.51 | 0.42 | 0.54 | 0.34 | 0.43 | 0.45 | 0.45 | 0.47 | 0.49 | — | — | — | — | — | — | — | — | ||||||||
| Dollar General Corp. | 0.98 | 0.84 | 0.81 | 0.67 | 0.67 | 0.68 | 0.66 | 0.62 | 0.59 | 0.56 | 0.55 | 0.43 | 0.42 | 0.38 | 0.42 | 0.45 | 0.46 | 0.44 | 0.46 | — | — | — | — | — | — | — | — | ||||||||
| Target Corp. | 1.49 | 1.43 | 1.34 | 1.07 | 0.92 | 0.86 | 0.85 | 0.88 | 0.95 | 1.14 | 1.28 | 0.97 | 1.01 | 0.97 | 1.12 | 1.00 | 1.05 | 1.00 | 1.02 | — | — | — | — | — | — | — | — | ||||||||
| Walmart Inc. | 0.71 | 0.65 | 0.68 | 0.51 | 0.52 | 0.58 | 0.62 | 0.60 | 0.62 | 0.69 | 0.85 | 0.73 | 0.82 | 0.81 | 0.85 | 0.80 | 0.85 | 0.76 | 0.61 | — | — | — | — | — | — | — | — | ||||||||
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
Debt to equity = Total debt ÷ Shareholders’ equity
= 3,770,400 ÷ 8,275,300 = 0.46
2 Click competitor name to see calculations.
| Solvency ratio | Description | The company |
|---|---|---|
| Debt to equity ratio | A solvency ratio calculated as total debt divided by total shareholders’ equity. | Dollar Tree Inc. debt to equity ratio improved from Q1 2023 to Q2 2023 but then deteriorated significantly from Q2 2023 to Q3 2023. |
Debt to Equity (including Operating Lease Liability)
Dollar Tree Inc., debt to equity (including operating lease liability) 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 portion of long-term debt | 350,000) | —) | —) | —) | —) | —) | —) | —) | 300,000) | 800,000) | 1,050,000) | 250,000) | 750,000) | 750,000) | 750,000) | —) | —) | —) | —) | 915,900) | 165,900) | 165,900) | 165,900) | 152,100) | 145,800) | 145,500) | 120,500) | ||||||||
| Long-term debt, net, excluding current portion | 3,420,400) | 3,419,300) | 3,418,100) | 3,417,000) | 3,231,100) | 3,229,500) | 3,227,800) | 3,226,200) | 3,225,300) | 3,224,300) | 3,223,300) | 3,522,200) | 3,520,200) | 3,518,600) | 3,516,900) | 4,265,300) | 5,043,800) | 5,041,800) | 5,040,100) | 4,762,100) | 5,557,000) | 5,595,000) | 6,131,700) | 6,169,700) | 6,938,000) | 7,155,700) | 7,209,800) | ||||||||
| Total debt | 3,770,400) | 3,419,300) | 3,418,100) | 3,417,000) | 3,231,100) | 3,229,500) | 3,227,800) | 3,226,200) | 3,525,300) | 4,024,300) | 4,273,300) | 3,772,200) | 4,270,200) | 4,268,600) | 4,266,900) | 4,265,300) | 5,043,800) | 5,041,800) | 5,040,100) | 5,678,000) | 5,722,900) | 5,760,900) | 6,297,600) | 6,321,800) | 7,083,800) | 7,301,200) | 7,330,300) | ||||||||
| Current portion of operating lease liabilities | 1,426,700) | 1,428,300) | 1,406,700) | 1,407,800) | 1,388,000) | 1,368,600) | 1,355,600) | 1,348,200) | 1,296,500) | 1,284,600) | 1,265,000) | 1,279,300) | 1,202,600) | 1,215,000) | 1,215,900) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
| Operating lease liabilities, long-term | 5,155,900) | 5,139,500) | 5,087,900) | 5,145,500) | 5,151,000) | 5,078,700) | 5,099,200) | 5,065,500) | 4,962,100) | 4,981,600) | 4,885,200) | 4,979,500) | 4,636,000) | 4,767,400) | 4,849,500) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
| Total debt (including operating lease liability) | 10,353,000) | 9,987,100) | 9,912,700) | 9,970,300) | 9,770,100) | 9,676,800) | 9,682,600) | 9,639,900) | 9,783,900) | 10,290,500) | 10,423,500) | 10,031,000) | 10,108,800) | 10,251,000) | 10,332,300) | 4,265,300) | 5,043,800) | 5,041,800) | 5,040,100) | 5,678,000) | 5,722,900) | 5,760,900) | 6,297,600) | 6,321,800) | 7,083,800) | 7,301,200) | 7,330,300) | ||||||||
| Shareholders’ equity | 8,275,300) | 8,396,500) | 8,241,500) | 7,718,500) | 7,244,400) | 7,011,700) | 7,411,300) | 7,285,300) | 6,961,100) | 6,813,600) | 6,520,600) | 6,254,800) | 6,121,300) | 5,865,700) | 5,755,900) | 5,642,900) | 7,943,100) | 7,647,500) | 7,355,700) | 7,182,300) | 6,116,500) | 5,860,200) | 5,609,000) | 5,389,500) | 5,047,700) | 4,856,900) | 4,669,600) | ||||||||
| Solvency Ratio | |||||||||||||||||||||||||||||||||||
| Debt to equity (including operating lease liability)1 | 1.25 | 1.19 | 1.20 | 1.29 | 1.35 | 1.38 | 1.31 | 1.32 | 1.41 | 1.51 | 1.60 | 1.60 | 1.65 | 1.75 | 1.80 | 0.76 | 0.63 | 0.66 | 0.69 | 0.79 | 0.94 | 0.98 | 1.12 | 1.17 | 1.40 | 1.50 | 1.57 | ||||||||
| Benchmarks | |||||||||||||||||||||||||||||||||||
| Debt to Equity (including Operating Lease Liability), Competitors2 | |||||||||||||||||||||||||||||||||||
| Costco Wholesale Corp. | 0.38 | 0.40 | 0.42 | 0.44 | 0.45 | 0.48 | 0.55 | 0.58 | 0.62 | 0.66 | 0.69 | 0.56 | 0.69 | 0.48 | 0.58 | 0.45 | 0.45 | 0.47 | 0.49 | — | — | — | — | — | — | — | — | ||||||||
| Dollar General Corp. | 2.70 | 2.50 | 2.52 | 2.28 | 2.28 | 2.27 | 2.20 | 2.04 | 1.93 | 1.80 | 1.79 | 1.75 | 1.71 | 1.63 | 1.65 | 0.45 | 0.46 | 0.44 | 0.46 | — | — | — | — | — | — | — | — | ||||||||
| Target Corp. | 1.73 | 1.67 | 1.58 | 1.26 | 1.11 | 1.03 | 1.00 | 1.03 | 1.11 | 1.31 | 1.48 | 1.16 | 1.20 | 1.15 | 1.30 | 1.18 | 1.24 | 1.18 | 1.20 | — | — | — | — | — | — | — | — | ||||||||
| Walmart Inc. | 0.90 | 0.84 | 0.87 | 0.69 | 0.70 | 0.76 | 0.80 | 0.78 | 0.84 | 0.92 | 1.11 | 0.97 | 1.06 | 1.06 | 1.11 | 0.80 | 0.85 | 0.76 | 0.61 | — | — | — | — | — | — | — | — | ||||||||
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
Debt to equity (including operating lease liability) = Total debt (including operating lease liability) ÷ Shareholders’ equity
= 10,353,000 ÷ 8,275,300 = 1.25
2 Click competitor name to see calculations.
| Solvency ratio | Description | The company |
|---|---|---|
| Debt to equity (including operating lease liability) ratio | A solvency ratio calculated as total debt (including operating lease liability) divided by total shareholders’ equity. | Dollar Tree Inc. debt to equity ratio (including operating lease liability) improved from Q1 2023 to Q2 2023 but then deteriorated significantly from Q2 2023 to Q3 2023. |
Debt to Capital
Dollar Tree Inc., debt to capital 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 portion of long-term debt | 350,000) | —) | —) | —) | —) | —) | —) | —) | 300,000) | 800,000) | 1,050,000) | 250,000) | 750,000) | 750,000) | 750,000) | —) | —) | —) | —) | 915,900) | 165,900) | 165,900) | 165,900) | 152,100) | 145,800) | 145,500) | 120,500) | ||||||||
| Long-term debt, net, excluding current portion | 3,420,400) | 3,419,300) | 3,418,100) | 3,417,000) | 3,231,100) | 3,229,500) | 3,227,800) | 3,226,200) | 3,225,300) | 3,224,300) | 3,223,300) | 3,522,200) | 3,520,200) | 3,518,600) | 3,516,900) | 4,265,300) | 5,043,800) | 5,041,800) | 5,040,100) | 4,762,100) | 5,557,000) | 5,595,000) | 6,131,700) | 6,169,700) | 6,938,000) | 7,155,700) | 7,209,800) | ||||||||
| Total debt | 3,770,400) | 3,419,300) | 3,418,100) | 3,417,000) | 3,231,100) | 3,229,500) | 3,227,800) | 3,226,200) | 3,525,300) | 4,024,300) | 4,273,300) | 3,772,200) | 4,270,200) | 4,268,600) | 4,266,900) | 4,265,300) | 5,043,800) | 5,041,800) | 5,040,100) | 5,678,000) | 5,722,900) | 5,760,900) | 6,297,600) | 6,321,800) | 7,083,800) | 7,301,200) | 7,330,300) | ||||||||
| Shareholders’ equity | 8,275,300) | 8,396,500) | 8,241,500) | 7,718,500) | 7,244,400) | 7,011,700) | 7,411,300) | 7,285,300) | 6,961,100) | 6,813,600) | 6,520,600) | 6,254,800) | 6,121,300) | 5,865,700) | 5,755,900) | 5,642,900) | 7,943,100) | 7,647,500) | 7,355,700) | 7,182,300) | 6,116,500) | 5,860,200) | 5,609,000) | 5,389,500) | 5,047,700) | 4,856,900) | 4,669,600) | ||||||||
| Total capital | 12,045,700) | 11,815,800) | 11,659,600) | 11,135,500) | 10,475,500) | 10,241,200) | 10,639,100) | 10,511,500) | 10,486,400) | 10,837,900) | 10,793,900) | 10,027,000) | 10,391,500) | 10,134,300) | 10,022,800) | 9,908,200) | 12,986,900) | 12,689,300) | 12,395,800) | 12,860,300) | 11,839,400) | 11,621,100) | 11,906,600) | 11,711,300) | 12,131,500) | 12,158,100) | 11,999,900) | ||||||||
| Solvency Ratio | |||||||||||||||||||||||||||||||||||
| Debt to capital1 | 0.31 | 0.29 | 0.29 | 0.31 | 0.31 | 0.32 | 0.30 | 0.31 | 0.34 | 0.37 | 0.40 | 0.38 | 0.41 | 0.42 | 0.43 | 0.43 | 0.39 | 0.40 | 0.41 | 0.44 | 0.48 | 0.50 | 0.53 | 0.54 | 0.58 | 0.60 | 0.61 | ||||||||
| Benchmarks | |||||||||||||||||||||||||||||||||||
| Debt to Capital, Competitors2 | |||||||||||||||||||||||||||||||||||
| Costco Wholesale Corp. | 0.22 | 0.22 | 0.23 | 0.24 | 0.25 | 0.26 | 0.29 | 0.30 | 0.32 | 0.33 | 0.34 | 0.29 | 0.35 | 0.25 | 0.30 | 0.31 | 0.31 | 0.32 | 0.33 | — | — | — | — | — | — | — | — | ||||||||
| Dollar General Corp. | 0.50 | 0.46 | 0.45 | 0.40 | 0.40 | 0.40 | 0.40 | 0.38 | 0.37 | 0.36 | 0.35 | 0.30 | 0.29 | 0.28 | 0.29 | 0.31 | 0.31 | 0.30 | 0.31 | — | — | — | — | — | — | — | — | ||||||||
| Target Corp. | 0.60 | 0.59 | 0.57 | 0.52 | 0.48 | 0.46 | 0.46 | 0.47 | 0.49 | 0.53 | 0.56 | 0.49 | 0.50 | 0.49 | 0.53 | 0.50 | 0.51 | 0.50 | 0.51 | — | — | — | — | — | — | — | — | ||||||||
| Walmart Inc. | 0.42 | 0.40 | 0.40 | 0.34 | 0.34 | 0.37 | 0.38 | 0.38 | 0.38 | 0.41 | 0.46 | 0.42 | 0.45 | 0.45 | 0.46 | 0.44 | 0.46 | 0.43 | 0.38 | — | — | — | — | — | — | — | — | ||||||||
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
Debt to capital = Total debt ÷ Total capital
= 3,770,400 ÷ 12,045,700 = 0.31
2 Click competitor name to see calculations.
| Solvency ratio | Description | The company |
|---|---|---|
| Debt to capital ratio | A solvency ratio calculated as total debt divided by total debt plus shareholders’ equity. | Dollar Tree Inc. debt to capital ratio improved from Q1 2023 to Q2 2023 but then deteriorated significantly from Q2 2023 to Q3 2023. |
Debt to Capital (including Operating Lease Liability)
Dollar Tree Inc., debt to capital (including operating lease liability) 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 portion of long-term debt | 350,000) | —) | —) | —) | —) | —) | —) | —) | 300,000) | 800,000) | 1,050,000) | 250,000) | 750,000) | 750,000) | 750,000) | —) | —) | —) | —) | 915,900) | 165,900) | 165,900) | 165,900) | 152,100) | 145,800) | 145,500) | 120,500) | ||||||||
| Long-term debt, net, excluding current portion | 3,420,400) | 3,419,300) | 3,418,100) | 3,417,000) | 3,231,100) | 3,229,500) | 3,227,800) | 3,226,200) | 3,225,300) | 3,224,300) | 3,223,300) | 3,522,200) | 3,520,200) | 3,518,600) | 3,516,900) | 4,265,300) | 5,043,800) | 5,041,800) | 5,040,100) | 4,762,100) | 5,557,000) | 5,595,000) | 6,131,700) | 6,169,700) | 6,938,000) | 7,155,700) | 7,209,800) | ||||||||
| Total debt | 3,770,400) | 3,419,300) | 3,418,100) | 3,417,000) | 3,231,100) | 3,229,500) | 3,227,800) | 3,226,200) | 3,525,300) | 4,024,300) | 4,273,300) | 3,772,200) | 4,270,200) | 4,268,600) | 4,266,900) | 4,265,300) | 5,043,800) | 5,041,800) | 5,040,100) | 5,678,000) | 5,722,900) | 5,760,900) | 6,297,600) | 6,321,800) | 7,083,800) | 7,301,200) | 7,330,300) | ||||||||
| Current portion of operating lease liabilities | 1,426,700) | 1,428,300) | 1,406,700) | 1,407,800) | 1,388,000) | 1,368,600) | 1,355,600) | 1,348,200) | 1,296,500) | 1,284,600) | 1,265,000) | 1,279,300) | 1,202,600) | 1,215,000) | 1,215,900) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
| Operating lease liabilities, long-term | 5,155,900) | 5,139,500) | 5,087,900) | 5,145,500) | 5,151,000) | 5,078,700) | 5,099,200) | 5,065,500) | 4,962,100) | 4,981,600) | 4,885,200) | 4,979,500) | 4,636,000) | 4,767,400) | 4,849,500) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
| Total debt (including operating lease liability) | 10,353,000) | 9,987,100) | 9,912,700) | 9,970,300) | 9,770,100) | 9,676,800) | 9,682,600) | 9,639,900) | 9,783,900) | 10,290,500) | 10,423,500) | 10,031,000) | 10,108,800) | 10,251,000) | 10,332,300) | 4,265,300) | 5,043,800) | 5,041,800) | 5,040,100) | 5,678,000) | 5,722,900) | 5,760,900) | 6,297,600) | 6,321,800) | 7,083,800) | 7,301,200) | 7,330,300) | ||||||||
| Shareholders’ equity | 8,275,300) | 8,396,500) | 8,241,500) | 7,718,500) | 7,244,400) | 7,011,700) | 7,411,300) | 7,285,300) | 6,961,100) | 6,813,600) | 6,520,600) | 6,254,800) | 6,121,300) | 5,865,700) | 5,755,900) | 5,642,900) | 7,943,100) | 7,647,500) | 7,355,700) | 7,182,300) | 6,116,500) | 5,860,200) | 5,609,000) | 5,389,500) | 5,047,700) | 4,856,900) | 4,669,600) | ||||||||
| Total capital (including operating lease liability) | 18,628,300) | 18,383,600) | 18,154,200) | 17,688,800) | 17,014,500) | 16,688,500) | 17,093,900) | 16,925,200) | 16,745,000) | 17,104,100) | 16,944,100) | 16,285,800) | 16,230,100) | 16,116,700) | 16,088,200) | 9,908,200) | 12,986,900) | 12,689,300) | 12,395,800) | 12,860,300) | 11,839,400) | 11,621,100) | 11,906,600) | 11,711,300) | 12,131,500) | 12,158,100) | 11,999,900) | ||||||||
| Solvency Ratio | |||||||||||||||||||||||||||||||||||
| Debt to capital (including operating lease liability)1 | 0.56 | 0.54 | 0.55 | 0.56 | 0.57 | 0.58 | 0.57 | 0.57 | 0.58 | 0.60 | 0.62 | 0.62 | 0.62 | 0.64 | 0.64 | 0.43 | 0.39 | 0.40 | 0.41 | 0.44 | 0.48 | 0.50 | 0.53 | 0.54 | 0.58 | 0.60 | 0.61 | ||||||||
| Benchmarks | |||||||||||||||||||||||||||||||||||
| Debt to Capital (including Operating Lease Liability), Competitors2 | |||||||||||||||||||||||||||||||||||
| Costco Wholesale Corp. | 0.28 | 0.29 | 0.30 | 0.30 | 0.31 | 0.32 | 0.35 | 0.37 | 0.38 | 0.40 | 0.41 | 0.36 | 0.41 | 0.33 | 0.37 | 0.31 | 0.31 | 0.32 | 0.33 | — | — | — | — | — | — | — | — | ||||||||
| Dollar General Corp. | 0.73 | 0.71 | 0.72 | 0.69 | 0.69 | 0.69 | 0.69 | 0.67 | 0.66 | 0.64 | 0.64 | 0.64 | 0.63 | 0.62 | 0.62 | 0.31 | 0.31 | 0.30 | 0.31 | — | — | — | — | — | — | — | — | ||||||||
| Target Corp. | 0.63 | 0.62 | 0.61 | 0.56 | 0.53 | 0.51 | 0.50 | 0.51 | 0.53 | 0.57 | 0.60 | 0.54 | 0.55 | 0.54 | 0.57 | 0.54 | 0.55 | 0.54 | 0.55 | — | — | — | — | — | — | — | — | ||||||||
| Walmart Inc. | 0.48 | 0.46 | 0.46 | 0.41 | 0.41 | 0.43 | 0.45 | 0.44 | 0.46 | 0.48 | 0.53 | 0.49 | 0.51 | 0.52 | 0.53 | 0.44 | 0.46 | 0.43 | 0.38 | — | — | — | — | — | — | — | — | ||||||||
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
Debt to capital (including operating lease liability) = Total debt (including operating lease liability) ÷ Total capital (including operating lease liability)
= 10,353,000 ÷ 18,628,300 = 0.56
2 Click competitor name to see calculations.
| Solvency ratio | Description | The company |
|---|---|---|
| Debt to capital (including operating lease liability) ratio | A solvency ratio calculated as total debt (including operating lease liability) divided by total debt (including operating lease liability) plus shareholders’ equity. | Dollar Tree Inc. debt to capital ratio (including operating lease liability) improved from Q1 2023 to Q2 2023 but then deteriorated significantly from Q2 2023 to Q3 2023. |
Debt to Assets
Dollar Tree Inc., debt to assets 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 portion of long-term debt | 350,000) | —) | —) | —) | —) | —) | —) | —) | 300,000) | 800,000) | 1,050,000) | 250,000) | 750,000) | 750,000) | 750,000) | —) | —) | —) | —) | 915,900) | 165,900) | 165,900) | 165,900) | 152,100) | 145,800) | 145,500) | 120,500) | ||||||||
| Long-term debt, net, excluding current portion | 3,420,400) | 3,419,300) | 3,418,100) | 3,417,000) | 3,231,100) | 3,229,500) | 3,227,800) | 3,226,200) | 3,225,300) | 3,224,300) | 3,223,300) | 3,522,200) | 3,520,200) | 3,518,600) | 3,516,900) | 4,265,300) | 5,043,800) | 5,041,800) | 5,040,100) | 4,762,100) | 5,557,000) | 5,595,000) | 6,131,700) | 6,169,700) | 6,938,000) | 7,155,700) | 7,209,800) | ||||||||
| Total debt | 3,770,400) | 3,419,300) | 3,418,100) | 3,417,000) | 3,231,100) | 3,229,500) | 3,227,800) | 3,226,200) | 3,525,300) | 4,024,300) | 4,273,300) | 3,772,200) | 4,270,200) | 4,268,600) | 4,266,900) | 4,265,300) | 5,043,800) | 5,041,800) | 5,040,100) | 5,678,000) | 5,722,900) | 5,760,900) | 6,297,600) | 6,321,800) | 7,083,800) | 7,301,200) | 7,330,300) | ||||||||
| Total assets | 22,909,500) | 22,676,300) | 22,372,300) | 21,721,800) | 21,390,000) | 20,445,200) | 21,050,700) | 20,696,000) | 20,652,200) | 20,671,000) | 20,471,800) | 19,574,600) | 19,742,100) | 19,493,800) | 19,354,300) | 13,501,200) | 16,649,300) | 16,103,600) | 15,827,100) | 16,332,800) | 15,730,200) | 15,532,300) | 15,994,700) | 15,701,600) | 16,195,000) | 16,329,400) | 16,060,900) | ||||||||
| Solvency Ratio | |||||||||||||||||||||||||||||||||||
| Debt to assets1 | 0.16 | 0.15 | 0.15 | 0.16 | 0.15 | 0.16 | 0.15 | 0.16 | 0.17 | 0.19 | 0.21 | 0.19 | 0.22 | 0.22 | 0.22 | 0.32 | 0.30 | 0.31 | 0.32 | 0.35 | 0.36 | 0.37 | 0.39 | 0.40 | 0.44 | 0.45 | 0.46 | ||||||||
| Benchmarks | |||||||||||||||||||||||||||||||||||
| Debt to Assets, Competitors2 | |||||||||||||||||||||||||||||||||||
| Costco Wholesale Corp. | 0.10 | 0.10 | 0.10 | 0.10 | 0.10 | 0.11 | 0.12 | 0.13 | 0.13 | 0.14 | 0.13 | 0.14 | 0.18 | 0.11 | 0.13 | 0.15 | 0.15 | 0.15 | 0.15 | — | — | — | — | — | — | — | — | ||||||||
| Dollar General Corp. | 0.21 | 0.18 | 0.18 | 0.16 | 0.16 | 0.16 | 0.16 | 0.16 | 0.16 | 0.16 | 0.16 | 0.13 | 0.12 | 0.12 | 0.13 | 0.22 | 0.22 | 0.21 | 0.23 | — | — | — | — | — | — | — | — | ||||||||
| Target Corp. | 0.30 | 0.29 | 0.28 | 0.25 | 0.23 | 0.25 | 0.25 | 0.25 | 0.25 | 0.30 | 0.32 | 0.27 | 0.27 | 0.28 | 0.31 | 0.27 | 0.27 | 0.28 | 0.29 | — | — | — | — | — | — | — | — | ||||||||
| Walmart Inc. | 0.21 | 0.21 | 0.21 | 0.17 | 0.18 | 0.19 | 0.20 | 0.19 | 0.20 | 0.22 | 0.25 | 0.23 | 0.24 | 0.24 | 0.25 | 0.26 | 0.27 | 0.26 | 0.23 | — | — | — | — | — | — | — | — | ||||||||
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
Debt to assets = Total debt ÷ Total assets
= 3,770,400 ÷ 22,909,500 = 0.16
2 Click competitor name to see calculations.
| Solvency ratio | Description | The company |
|---|---|---|
| Debt to assets ratio | A solvency ratio calculated as total debt divided by total assets. | Dollar Tree Inc. debt to assets ratio improved from Q1 2023 to Q2 2023 but then deteriorated significantly from Q2 2023 to Q3 2023. |
Debt to Assets (including Operating Lease Liability)
Dollar Tree Inc., debt to assets (including operating lease liability) 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 portion of long-term debt | 350,000) | —) | —) | —) | —) | —) | —) | —) | 300,000) | 800,000) | 1,050,000) | 250,000) | 750,000) | 750,000) | 750,000) | —) | —) | —) | —) | 915,900) | 165,900) | 165,900) | 165,900) | 152,100) | 145,800) | 145,500) | 120,500) | ||||||||
| Long-term debt, net, excluding current portion | 3,420,400) | 3,419,300) | 3,418,100) | 3,417,000) | 3,231,100) | 3,229,500) | 3,227,800) | 3,226,200) | 3,225,300) | 3,224,300) | 3,223,300) | 3,522,200) | 3,520,200) | 3,518,600) | 3,516,900) | 4,265,300) | 5,043,800) | 5,041,800) | 5,040,100) | 4,762,100) | 5,557,000) | 5,595,000) | 6,131,700) | 6,169,700) | 6,938,000) | 7,155,700) | 7,209,800) | ||||||||
| Total debt | 3,770,400) | 3,419,300) | 3,418,100) | 3,417,000) | 3,231,100) | 3,229,500) | 3,227,800) | 3,226,200) | 3,525,300) | 4,024,300) | 4,273,300) | 3,772,200) | 4,270,200) | 4,268,600) | 4,266,900) | 4,265,300) | 5,043,800) | 5,041,800) | 5,040,100) | 5,678,000) | 5,722,900) | 5,760,900) | 6,297,600) | 6,321,800) | 7,083,800) | 7,301,200) | 7,330,300) | ||||||||
| Current portion of operating lease liabilities | 1,426,700) | 1,428,300) | 1,406,700) | 1,407,800) | 1,388,000) | 1,368,600) | 1,355,600) | 1,348,200) | 1,296,500) | 1,284,600) | 1,265,000) | 1,279,300) | 1,202,600) | 1,215,000) | 1,215,900) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
| Operating lease liabilities, long-term | 5,155,900) | 5,139,500) | 5,087,900) | 5,145,500) | 5,151,000) | 5,078,700) | 5,099,200) | 5,065,500) | 4,962,100) | 4,981,600) | 4,885,200) | 4,979,500) | 4,636,000) | 4,767,400) | 4,849,500) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
| Total debt (including operating lease liability) | 10,353,000) | 9,987,100) | 9,912,700) | 9,970,300) | 9,770,100) | 9,676,800) | 9,682,600) | 9,639,900) | 9,783,900) | 10,290,500) | 10,423,500) | 10,031,000) | 10,108,800) | 10,251,000) | 10,332,300) | 4,265,300) | 5,043,800) | 5,041,800) | 5,040,100) | 5,678,000) | 5,722,900) | 5,760,900) | 6,297,600) | 6,321,800) | 7,083,800) | 7,301,200) | 7,330,300) | ||||||||
| Total assets | 22,909,500) | 22,676,300) | 22,372,300) | 21,721,800) | 21,390,000) | 20,445,200) | 21,050,700) | 20,696,000) | 20,652,200) | 20,671,000) | 20,471,800) | 19,574,600) | 19,742,100) | 19,493,800) | 19,354,300) | 13,501,200) | 16,649,300) | 16,103,600) | 15,827,100) | 16,332,800) | 15,730,200) | 15,532,300) | 15,994,700) | 15,701,600) | 16,195,000) | 16,329,400) | 16,060,900) | ||||||||
| Solvency Ratio | |||||||||||||||||||||||||||||||||||
| Debt to assets (including operating lease liability)1 | 0.45 | 0.44 | 0.44 | 0.46 | 0.46 | 0.47 | 0.46 | 0.47 | 0.47 | 0.50 | 0.51 | 0.51 | 0.51 | 0.53 | 0.53 | 0.32 | 0.30 | 0.31 | 0.32 | 0.35 | 0.36 | 0.37 | 0.39 | 0.40 | 0.44 | 0.45 | 0.46 | ||||||||
| Benchmarks | |||||||||||||||||||||||||||||||||||
| Debt to Assets (including Operating Lease Liability), Competitors2 | |||||||||||||||||||||||||||||||||||
| Costco Wholesale Corp. | 0.13 | 0.14 | 0.14 | 0.14 | 0.14 | 0.15 | 0.16 | 0.17 | 0.18 | 0.19 | 0.17 | 0.18 | 0.22 | 0.16 | 0.18 | 0.15 | 0.15 | 0.15 | 0.15 | — | — | — | — | — | — | — | — | ||||||||
| Dollar General Corp. | 0.57 | 0.55 | 0.56 | 0.54 | 0.54 | 0.55 | 0.54 | 0.53 | 0.51 | 0.51 | 0.52 | 0.51 | 0.51 | 0.50 | 0.51 | 0.22 | 0.22 | 0.21 | 0.23 | — | — | — | — | — | — | — | — | ||||||||
| Target Corp. | 0.34 | 0.34 | 0.34 | 0.30 | 0.28 | 0.30 | 0.30 | 0.29 | 0.29 | 0.34 | 0.37 | 0.32 | 0.32 | 0.33 | 0.36 | 0.32 | 0.31 | 0.33 | 0.34 | — | — | — | — | — | — | — | — | ||||||||
| Walmart Inc. | 0.26 | 0.26 | 0.27 | 0.23 | 0.24 | 0.26 | 0.27 | 0.25 | 0.27 | 0.29 | 0.32 | 0.31 | 0.32 | 0.32 | 0.32 | 0.26 | 0.27 | 0.26 | 0.23 | — | — | — | — | — | — | — | — | ||||||||
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
Debt to assets (including operating lease liability) = Total debt (including operating lease liability) ÷ Total assets
= 10,353,000 ÷ 22,909,500 = 0.45
2 Click competitor name to see calculations.
| Solvency ratio | Description | The company |
|---|---|---|
| Debt to assets (including operating lease liability) ratio | A solvency ratio calculated as total debt (including operating lease liability) divided by total assets. | Dollar Tree Inc. debt to assets ratio (including operating lease liability) improved from Q1 2023 to Q2 2023 but then deteriorated significantly from Q2 2023 to Q3 2023. |
Financial Leverage
Dollar Tree Inc., financial leverage 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) | |||||||||||||||||||||||||||||||||||
| Total assets | 22,909,500) | 22,676,300) | 22,372,300) | 21,721,800) | 21,390,000) | 20,445,200) | 21,050,700) | 20,696,000) | 20,652,200) | 20,671,000) | 20,471,800) | 19,574,600) | 19,742,100) | 19,493,800) | 19,354,300) | 13,501,200) | 16,649,300) | 16,103,600) | 15,827,100) | 16,332,800) | 15,730,200) | 15,532,300) | 15,994,700) | 15,701,600) | 16,195,000) | 16,329,400) | 16,060,900) | ||||||||
| Shareholders’ equity | 8,275,300) | 8,396,500) | 8,241,500) | 7,718,500) | 7,244,400) | 7,011,700) | 7,411,300) | 7,285,300) | 6,961,100) | 6,813,600) | 6,520,600) | 6,254,800) | 6,121,300) | 5,865,700) | 5,755,900) | 5,642,900) | 7,943,100) | 7,647,500) | 7,355,700) | 7,182,300) | 6,116,500) | 5,860,200) | 5,609,000) | 5,389,500) | 5,047,700) | 4,856,900) | 4,669,600) | ||||||||
| Solvency Ratio | |||||||||||||||||||||||||||||||||||
| Financial leverage1 | 2.77 | 2.70 | 2.71 | 2.81 | 2.95 | 2.92 | 2.84 | 2.84 | 2.97 | 3.03 | 3.14 | 3.13 | 3.23 | 3.32 | 3.36 | 2.39 | 2.10 | 2.11 | 2.15 | 2.27 | 2.57 | 2.65 | 2.85 | 2.91 | 3.21 | 3.36 | 3.44 | ||||||||
| Benchmarks | |||||||||||||||||||||||||||||||||||
| Financial Leverage, Competitors2 | |||||||||||||||||||||||||||||||||||
| Costco Wholesale Corp. | 2.83 | 2.93 | 3.08 | 3.11 | 3.20 | 3.25 | 3.47 | 3.37 | 3.47 | 3.51 | 4.05 | 3.04 | 3.08 | 2.94 | 3.24 | 2.98 | 3.02 | 3.09 | 3.33 | — | — | — | — | — | — | — | — | ||||||||
| Dollar General Corp. | 4.76 | 4.56 | 4.52 | 4.20 | 4.19 | 4.15 | 4.04 | 3.88 | 3.74 | 3.51 | 3.45 | 3.41 | 3.37 | 3.25 | 3.24 | 2.06 | 2.06 | 2.03 | 2.00 | — | — | — | — | — | — | — | — | ||||||||
| Target Corp. | 5.05 | 4.95 | 4.72 | 4.20 | 3.94 | 3.46 | 3.37 | 3.55 | 3.80 | 3.82 | 4.01 | 3.62 | 3.79 | 3.51 | 3.65 | 3.65 | 3.93 | 3.58 | 3.49 | — | — | — | — | — | — | — | — | ||||||||
| Walmart Inc. | 3.43 | 3.19 | 3.20 | 2.94 | 2.98 | 2.96 | 3.02 | 3.12 | 3.08 | 3.15 | 3.41 | 3.17 | 3.35 | 3.34 | 3.44 | 3.02 | 3.15 | 2.89 | 2.71 | — | — | — | — | — | — | — | — | ||||||||
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
Financial leverage = Total assets ÷ Shareholders’ equity
= 22,909,500 ÷ 8,275,300 = 2.77
2 Click competitor name to see calculations.
| Solvency ratio | Description | The company |
|---|---|---|
| Financial leverage ratio | A solvency ratio calculated as total assets divided by total shareholders’ equity. | Dollar Tree Inc. financial leverage ratio decreased from Q1 2023 to Q2 2023 but then increased from Q2 2023 to Q3 2023 exceeding Q1 2023 level. |
Interest Coverage
Dollar Tree Inc., interest coverage 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) | |||||||||||||||||||||||||||||||||||
| 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,700) | 171,600) | 170,200) | 232,700) | ||||||||
| Add: Income tax expense | 81,500) | 114,800) | 161,100) | 45,000) | 60,100) | 86,800) | 112,400) | 144,600) | 97,300) | 78,400) | 77,600) | 86,500) | 61,100) | 48,100) | 76,000) | 112,900) | 58,200) | 63,800) | 46,900) | (348,600) | 115,200) | 109,800) | 113,300) | 176,000) | 58,600) | 99,700) | 98,900) | ||||||||
| Add: Interest expense, net | 32,700) | 30,600) | 34,000) | 79,500) | 33,400) | 33,000) | 33,000) | 34,200) | 38,100) | 34,800) | 40,200) | 39,200) | 41,400) | 40,100) | 41,400) | 46,300) | 47,600) | 46,100) | 230,000) | 81,600) | 69,700) | 75,800) | 74,700) | 88,800) | 112,100) | 87,300) | 87,300) | ||||||||
| Earnings before interest and tax (EBIT) | 381,100) | 505,300) | 731,500) | 578,700) | 310,300) | 402,200) | 519,900) | 681,600) | 465,400) | 374,700) | 365,400) | 248,700) | 358,300) | 268,500) | 385,300) | (2,147,800) | 387,600) | 383,800) | 437,400) | 773,100) | 424,800) | 419,400) | 388,500) | 586,500) | 342,300) | 357,200) | 418,900) | ||||||||
| Solvency Ratio | |||||||||||||||||||||||||||||||||||
| Interest coverage1 | 12.42 | 11.98 | 11.24 | 10.12 | 14.33 | 14.96 | 14.57 | 12.81 | 9.55 | 8.66 | 7.71 | 7.78 | -6.71 | -6.31 | -5.46 | -2.54 | 4.89 | 4.72 | 4.50 | 6.65 | 5.89 | 4.94 | 4.61 | 4.54 | — | — | — | ||||||||
| Benchmarks | |||||||||||||||||||||||||||||||||||
| Interest Coverage, Competitors2 | |||||||||||||||||||||||||||||||||||
| Costco Wholesale Corp. | 53.89 | 54.62 | 52.73 | 50.62 | 48.01 | 45.54 | 41.68 | 40.06 | 37.81 | 35.56 | 36.58 | 34.54 | 33.40 | 33.57 | 33.16 | 32.77 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| Dollar General Corp. | 18.24 | 19.45 | 19.50 | 20.45 | 20.69 | 21.22 | 22.44 | 23.64 | 25.08 | 26.09 | 25.27 | 22.89 | 22.18 | 21.62 | 21.16 | 21.18 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| Target Corp. | 10.70 | 13.46 | 18.76 | 22.16 | 21.38 | 9.43 | 9.08 | 6.68 | 5.92 | 10.51 | 8.47 | 9.78 | 9.86 | 9.42 | 9.09 | 8.97 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| Walmart Inc. | 7.63 | 11.00 | 10.43 | 10.38 | 7.37 | 8.59 | 9.31 | 9.88 | 11.98 | 10.50 | 9.08 | 8.74 | 8.69 | 8.11 | 6.54 | 5.88 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
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
Interest coverage
= (EBITQ3 2023
+ EBITQ2 2023
+ EBITQ1 2023
+ EBITQ4 2022)
÷ (Interest expenseQ3 2023
+ Interest expenseQ2 2023
+ Interest expenseQ1 2023
+ Interest expenseQ4 2022)
= (381,100 + 505,300 + 731,500 + 578,700)
÷ (32,700 + 30,600 + 34,000 + 79,500)
= 12.42
2 Click competitor name to see calculations.
| Solvency ratio | Description | The company |
|---|---|---|
| Interest coverage ratio | A solvency ratio calculated as EBIT divided by interest payments. | Dollar Tree Inc. interest coverage ratio improved from Q1 2023 to Q2 2023 and from Q2 2023 to Q3 2023. |