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).
- Debt to Equity
- The debt to equity ratio demonstrated a clear downward trend from April 2017 through the end of 2020, moving from 1.12 down to a low of 0.44 in early 2021. This indicates a reduction in the relative amount of debt financing compared to equity over this period. From 2021 onward, the ratio remained relatively stable around 0.4 to 0.46, suggesting maintenance of a conservative debt level relative to equity.
- Debt to Equity Including Operating Lease Liability
- When including operating lease liabilities, the debt to equity ratio was initially identical with the standard debt to equity measures up to early 2019. However, from May 2019 onward, it surged significantly, peaking around 1.8 before gradually trending downward to approximately 1.2 by mid-2022. This pattern reflects the impact of including lease obligations, highlighting additional leverage not captured in the traditional debt measure and showing a gradual deleveraging trend after the spike.
- Debt to Capital
- A downward trend in the debt to capital ratio is evident from 0.53 in early 2017 down to around 0.29 by mid-2022. This signifies a steady decrease in the proportion of debt within the company’s capital structure, favoring equity financing over time. The gradual decline indicates improved capital structure stability and lower risk from debt financing.
- Debt to Capital Including Operating Lease Liability
- The comparable measure including operating lease liabilities reveals a similar pattern to debt to equity inclusive of leases. It began near 0.53, then increased to around 0.64 by mid-2019 before gradually declining to approximately 0.55 by late 2022. This pattern suggests that lease obligations have materially increased the firm's capital leverage, but there has been an effort to reduce this extent of leverage recently.
- Debt to Assets
- The standard debt to assets ratio steadily decreased from 0.39 in early 2017 to a low of 0.15 to 0.16 in the 2021–2022 period. This reduction indicates an increasing share of assets financed by equity rather than debt, reflecting potential strengthening of the balance sheet and reduced financial risk.
- Debt to Assets Including Operating Lease Liability
- Including operating lease liabilities, the debt to assets ratio increased sharply from 0.3 in early 2019 to above 0.5 and remained relatively stable near 0.44 to 0.46 from 2021 onwards. This shows that when lease obligations are accounted for as liabilities, the company's asset financing reveals substantially higher leverage, although this too exhibits a slight declining trend in recent quarters.
- Financial Leverage
- Financial leverage, measured as total assets divided by equity, decreased from 2.85 in early 2017 to a low of about 2.7 by mid-2022, with some fluctuations in between. Peaks were noted around mid-2019 when it approached 3.36. Overall, this suggests a decrease in reliance on debt relative to equity, aligning with other leverage measures indicating a more conservative capital structure over time.
- Interest Coverage
- The interest coverage ratio showed significant volatility across the periods. Initially, it improved from 4.61 in early 2017 to a high near 6.65 in early 2018 before a sharp negative downturn between early and late 2019, reaching negative values as low as -6.71. This likely indicates operational difficulties or extraordinary items impacting earnings relative to interest expense during that time. However, from early 2020 onward, interest coverage improved substantially, climbing to levels well above 10 by the end of 2021 and into 2022, reflecting strong earnings relative to interest obligations and enhanced financial health in recent periods.
Debt Ratios
Coverage Ratios
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 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||||||
| 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) | |||||||
| 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) | |||||||
| 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) | |||||||
| 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 | |||||||
| 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 | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Target Corp. | 1.49 | 1.43 | 1.34 | 1.07 | 0.92 | 0.86 | 0.85 | 0.88 | 0.95 | 1.14 | 1.28 | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Walmart Inc. | 0.71 | 0.65 | 0.68 | 0.51 | 0.52 | 0.58 | 0.62 | 0.60 | 0.62 | 0.69 | 0.85 | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
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).
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.
- Total Debt
-
Total debt demonstrates an overall declining trend from April 2017 through January 2021, decreasing from approximately 6.3 billion USD to about 3.2 billion USD. There is some variability within individual quarters, but the downward trajectory is evident. After January 2021, total debt remains relatively stable until a slight increase is observed in October 2022, reaching around 3.8 billion USD.
- Shareholders’ Equity
-
Shareholders' equity generally shows a growth trend across the same period, increasing from about 5.6 billion USD in April 2017 to approximately 7.7 billion USD by April 2022. A period of decline is observed between November 2018 and February 2020, dropping from roughly 7.9 billion USD to around 6.3 billion USD, after which equity resumes its upward momentum. The equity peaks near 8.4 billion USD in July 2022, followed by a slight decrease by October 2022.
- Debt to Equity Ratio
-
The debt to equity ratio consistently declines from 1.12 in April 2017 to a low of 0.41 in July 2022. This indicates an improving capital structure with reduced reliance on debt financing relative to shareholders' equity. The ratio exhibits minor fluctuations but maintains the downward trend until October 2022, where it rises modestly to 0.46. This ratio movement aligns with the observed reduction in total debt and the increase in equity over the period.
- Summary Insights
-
The financial structure reveals a strategic deleveraging approach over the five-year span, reflecting a sustained effort to lower debt obligations while strengthening equity. The decreased debt and increased equity contribute to a healthier leverage profile, as illustrated by the falling debt to equity ratio. The minor uptick in total debt and the ratio in late 2022 may warrant further monitoring to assess any emerging changes in financial strategy or market conditions.
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 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||||||
| 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) | |||||||
| 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) | |||||||
| 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) | |||||||
| 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) | |||||||
| 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 | |||||||
| 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 | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Target Corp. | 1.73 | 1.67 | 1.58 | 1.26 | 1.11 | 1.03 | 1.00 | 1.03 | 1.11 | 1.31 | 1.48 | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Walmart Inc. | 0.90 | 0.84 | 0.87 | 0.69 | 0.70 | 0.76 | 0.80 | 0.78 | 0.84 | 0.92 | 1.11 | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
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).
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.
The financial data reveals several key trends regarding the company's debt, equity, and leverage position over the observed periods.
- Total Debt (including operating lease liability)
- The total debt exhibited a fluctuating pattern throughout the periods. Initially, there was a decrease from approximately 6.3 billion US dollars to around 4.3 billion by early 2019. This was followed by a significant increase to over 10 billion by mid-2019, maintaining levels near or above this amount through late 2022. The sharp rise around mid-2019 indicates a possible major financing event or increased leverage during that timeframe.
- Shareholders' Equity
- Shareholders' equity generally showed a positive trend, with initial growth from about 5.6 billion US dollars in early 2017 to a peak near 7.9 billion by late 2018. This was then followed by a decline to around 5.6 billion in early 2019, likely correlated with the increased debt levels during the same period. After this dip, equity rebounded steadily from 2020 onwards, reaching approximately 8.4 billion by mid-2022 before slightly retreating toward the end of 2022. This suggests recovery and strengthening of the equity base in recent periods.
- Debt to Equity Ratio (including operating lease liability)
- The leverage ratio experienced notable fluctuations consistent with movements in debt and equity. From a level slightly above 1.1 at the beginning of the timeline, it declined progressively to a low around 0.63 by late 2018, denoting reduced leverage at that point. However, the ratio then surged dramatically, hitting a high near 1.8 in mid-2019, implying a significant increase in debt relative to equity. Subsequently, it gradually decreased throughout 2020 and 2021, reaching levels near 1.19, indicating improved leverage and possibly deleveraging efforts or equity growth. Toward the end of the observation period, a slight uptick to 1.25 was noted, suggesting a modest increase in leverage.
In summary, the company experienced substantial shifts in capital structure characterized by a steep increase in debt around mid-2019, which corresponded with a dip in shareholders’ equity and a peak in the leverage ratio. Following this period, the firm demonstrated recovery and strengthening of equity along with gradual reduction of leverage. The recent slight increase in the debt to equity ratio warrants attention to monitor potential changes in financial risk going forward.
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 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||||||
| 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) | |||||||
| 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) | |||||||
| 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) | |||||||
| 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) | |||||||
| 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 | |||||||
| 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 | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Target Corp. | 0.60 | 0.59 | 0.57 | 0.52 | 0.48 | 0.46 | 0.46 | 0.47 | 0.49 | 0.53 | 0.56 | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Walmart Inc. | 0.42 | 0.40 | 0.40 | 0.34 | 0.34 | 0.37 | 0.38 | 0.38 | 0.38 | 0.41 | 0.46 | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
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).
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.
- Total Debt
- The total debt exhibited a general downward trend over the observed periods from April 2017 to October 2022. Initially, total debt stood at approximately 6.3 billion USD and gradually decreased to around 3.5 billion USD by early 2021. Following this decline, the debt level remained relatively stable with minor fluctuations, ending near 3.8 billion USD by October 2022. This indicates a significant reduction of almost 40% in total debt over the five and a half years, suggesting ongoing efforts to deleverage or optimize the capital structure.
- Total Capital
- Total capital showed variability throughout the timeline, beginning at roughly 11.9 billion USD in April 2017 with several periods of increase and decrease. Notably, total capital fell sharply between November 2018 and February 2019, dropping from about 13 billion USD to just under 10 billion USD. Thereafter, total capital experienced moderate recovery and gradual growth, especially from early 2020 onwards, recovering to approximately 12 billion USD by the last reported period in October 2022. The fluctuations imply periods of capital restructuring or changes in equity and debt financing balances.
- Debt to Capital Ratio
- The debt to capital ratio consistently declined from 0.53 in April 2017 to a low point of around 0.29 in mid-2022, indicating an improving leverage position and potentially lower financial risk. Noteworthy is the steady decrease sustained over multiple quarters, punctuated by minor rebounds around early 2019 and late 2022, where the ratio slightly increased but remained below 0.32. Overall, the trend suggests an enhanced capital structure with reduced reliance on debt financing relative to total capital.
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 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||||||
| 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) | |||||||
| 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) | |||||||
| 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) | |||||||
| 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) | |||||||
| 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) | |||||||
| 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 | |||||||
| 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 | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Target Corp. | 0.63 | 0.62 | 0.61 | 0.56 | 0.53 | 0.51 | 0.50 | 0.51 | 0.53 | 0.57 | 0.60 | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Walmart Inc. | 0.48 | 0.46 | 0.46 | 0.41 | 0.41 | 0.43 | 0.45 | 0.44 | 0.46 | 0.48 | 0.53 | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
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).
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.
- Total Debt (including operating lease liability)
- The total debt demonstrated a declining trend from April 2017 through February 2019, decreasing from approximately $6.3 billion to about $4.3 billion. However, from May 2019 onwards, a sharp increase is observed, with the debt exceeding $10 billion and fluctuating around this level through to October 2022, ending at approximately $10.35 billion. This suggests a significant rise in the company's leverage starting mid-2019, maintaining a high level thereafter.
- Total Capital (including operating lease liability)
- Total capital showed relatively stable fluctuations between April 2017 and February 2019, generally ranging between about $9.9 billion and $13 billion. A notable increase occurred in May 2019, with total capital jumping to over $16 billion and gradually growing to approximately $18.6 billion by October 2022. This increase in total capital aligns with the rise in total debt, indicating an expansion in the company's capital structure during this period.
- Debt to Capital Ratio (including operating lease liability)
- The debt to capital ratio steadily decreased from 0.53 in April 2017 to a low of 0.39 in November 2018, reflecting an improved capital structure with less reliance on debt. Beginning May 2019, the ratio rose sharply to around 0.64, indicating increased indebtedness relative to the company's capital. Following this peak, the ratio trended downward slightly but remained in a range between 0.54 and 0.62 through October 2022, suggesting a consistently elevated leverage level compared to the earlier period.
- Overall Analysis
- The data indicates a strategic shift starting mid-2019 where leverage was substantially increased. Total debt and total capital both expanded markedly, with debt rising proportionally more to maintain a higher debt to capital ratio. Prior to this, the company exhibited a deleveraging trend with diminishing debt levels and an improved debt to capital ratio. The elevated leverage level from 2019 onward implies greater financial risk or possibly increased investment or acquisition activity financed by debt. The relative stability of the debt to capital ratio after the initial increase suggests the company has maintained this adjusted capital structure rather than continuing to increase leverage.
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 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||||||
| 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) | |||||||
| 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) | |||||||
| 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) | |||||||
| 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 | |||||||
| 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 | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Target Corp. | 0.30 | 0.29 | 0.28 | 0.25 | 0.23 | 0.25 | 0.25 | 0.25 | 0.25 | 0.30 | 0.32 | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Walmart Inc. | 0.21 | 0.21 | 0.21 | 0.17 | 0.18 | 0.19 | 0.20 | 0.19 | 0.20 | 0.22 | 0.25 | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
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).
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.
- Total Debt
- Over the observed periods, total debt shows a general downward trend from approximately 6.30 billion US dollars to around 3.77 billion US dollars. Initial quarters indicate a steady decline from 6.30 billion to about 5.04 billion, followed by some fluctuations with a notable decrease continuing through early 2021 to nearly 3.23 billion. A modest increase appears toward the end of the timeline, reaching approximately 3.77 billion. This pattern suggests sustained efforts in reducing leverage over time, with occasional short-term increases.
- Total Assets
- Total assets demonstrate an overall upward trajectory throughout the periods. Starting from roughly 16.0 billion US dollars, assets peak at around 21.9 billion in early 2022 and continue modestly increasing to about 22.9 billion by the final period. There is some volatility visible between periods, such as a dip around early 2019 followed by a strong recovery. This indicates asset growth over time, reflecting possible expansion, asset acquisitions, or appreciation in asset values despite short-term fluctuations.
- Debt to Assets Ratio
- The debt to assets ratio consistently decreases from 0.39 to approximately 0.16 over the examined timeframe. This decline reflects a reduction in leverage, meaning that, relative to its asset base, the company has reduced its reliance on debt financing. The ratio diminishes steadily despite some minor oscillations, reinforcing the interpretation of improved financial stability and a stronger balance sheet position.
- Overall Analysis
- The financial data reveals a clear strategic pattern of debt reduction accompanied by asset growth, leading to a significantly improved debt to asset ratio. The movement suggests enhanced solvency and financial flexibility. The increasing asset base combined with lowered debt indicates prudent financial management and potentially improved creditworthiness. The modest rise in debt during late periods may be indicative of new financing activities aligned with growth objectives, but it does not substantially affect the declining leverage trend.
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 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||||||
| 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) | |||||||
| 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) | |||||||
| 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) | |||||||
| 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) | |||||||
| 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 | |||||||
| 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 | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Target Corp. | 0.34 | 0.34 | 0.34 | 0.30 | 0.28 | 0.30 | 0.30 | 0.29 | 0.29 | 0.34 | 0.37 | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Walmart Inc. | 0.26 | 0.26 | 0.27 | 0.23 | 0.24 | 0.26 | 0.27 | 0.25 | 0.27 | 0.29 | 0.32 | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
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).
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.
- Total Debt (Including Operating Lease Liability)
- The total debt level exhibited a general decline from April 2017 to February 2019, decreasing from approximately $6.3 billion to around $4.3 billion. This downward trend was followed by a significant increase beginning in May 2019, when total debt nearly doubled to over $10 billion. Subsequently, total debt fluctuated but remained near this higher level through October 2022, with values ranging between roughly $9.7 billion and $10.4 billion. This pattern suggests an initial period of deleveraging followed by a substantial rise in leverage that stabilized at an elevated level.
- Total Assets
- Total assets displayed a relatively stable trend between April 2017 and February 2019, fluctuating modestly within the $15.5 billion to $16.6 billion range. However, from May 2019 onward, assets increased notably, reaching approximately $22.9 billion by October 2022. This indicates a phase of asset growth starting mid-2019, possibly linked to business expansion or acquisitions.
- Debt to Assets Ratio (Including Operating Lease Liability)
- The debt to assets ratio showed a declining trend from 0.39 in April 2017 down to a low of about 0.30 in November 2018, indicating improved capital structure with less leverage relative to asset base. Starting May 2019, the ratio sharply increased to about 0.53 and remained close to that level until early 2020. Thereafter, it slightly declined but consistently stayed near the 0.44 to 0.47 range through October 2022. This movement reflects a significant increase in leverage relative to assets beginning in mid-2019, stabilizing at a higher ratio than earlier years.
- Overall Analysis
- The analyzed period reveals two distinct phases. The first phase (2017 to early 2019) displays a reduction in total debt and leverage, alongside stable asset levels, suggesting a conservative financial approach or efforts to strengthen the balance sheet. The second phase (mid-2019 onwards) is characterized by a marked increase in both total debt and total assets, with leverage ratios peaking and then stabilizing at elevated levels. This likely corresponds to strategic financial decisions involving leveraging increased assets, potentially reflecting growth initiatives or changes in capital structure policy. The sustained higher debt to assets ratio indicates continued reliance on debt financing relative to asset base in recent quarters.
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 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||||||
| 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) | |||||||
| 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 | |||||||
| 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 | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Target Corp. | 5.05 | 4.95 | 4.72 | 4.20 | 3.94 | 3.46 | 3.37 | 3.55 | 3.80 | 3.82 | 4.01 | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Walmart Inc. | 3.43 | 3.19 | 3.20 | 2.94 | 2.98 | 2.96 | 3.02 | 3.12 | 3.08 | 3.15 | 3.41 | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
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).
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.
- Total Assets
- The total assets exhibit a general upward trend over the periods analyzed, increasing from approximately 15.99 billion USD to around 22.91 billion USD. However, there is a noticeable dip in early 2019 where assets decline sharply to about 13.50 billion USD before continuing the upward trajectory. After this decline, the total assets recover and sustain growth steadily through to late 2022, indicative of ongoing asset accumulation or acquisition activity.
- Shareholders' Equity
- Shareholders' equity also shows an overall increase from approximately 5.61 billion USD initially to roughly 8.28 billion USD by the end of the period. There is a significant decrease in equity value evident around early 2019, dropping from about 7.94 billion USD to 5.64 billion USD, mirroring the dip seen in total assets. Post this period, equity gradually recovers and surpasses previous highs, suggesting a strengthening of the company's net worth despite fluctuations.
- Financial Leverage
- The financial leverage ratio demonstrates variability with an initial decline from 2.85 to 2.10 by late 2018, implying a reduced reliance on debt relative to equity. However, this ratio then increases sharply to a peak of approximately 3.36 in mid-2019, coinciding with the drop in assets and equity, which indicates increased leverage, possibly through elevated debt levels or decreased equity base. Subsequently, the ratio trends downward with minor fluctuations, maintaining a range between roughly 2.70 and 2.95 toward the end of the periods. This pattern suggests a cautious approach to leverage management following the mid-2019 peak.
- Overall Insights
- The data illustrates a period of volatility around early 2019, characterized by a marked reduction in total assets and shareholders' equity along with a pronounced increase in financial leverage. This could reflect a significant restructuring, divestiture, or impact of an external event affecting the company's financial position. Following this period, both assets and equity recover and grow steadily, while financial leverage stabilizes at a moderate level. The general trend points to ongoing growth and prudent leverage control in subsequent quarters.
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 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||||||
| 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) | |||||||
| 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) | |||||||
| 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) | |||||||
| 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 | |||||||
| 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 | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Target Corp. | 10.70 | 13.46 | 18.76 | 22.16 | 21.38 | 9.43 | 9.08 | 6.68 | 5.92 | 10.51 | 8.47 | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
| Walmart Inc. | 7.63 | 11.00 | 10.43 | 10.38 | 7.37 | 8.59 | 9.31 | 9.88 | 11.98 | 10.50 | 9.08 | — | — | — | — | — | — | — | — | — | — | — | — | |||||||
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).
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.
The analysis of the financial data reveals notable fluctuations in earnings before interest and tax (EBIT), interest expense, and interest coverage ratios over the observed periods.
- Earnings Before Interest and Tax (EBIT)
- EBIT shows significant variability across the quarters. Initially, EBIT remains relatively stable with moderate growth, increasing from approximately 388.5 million US dollars in April 2017 to about 773.1 million US dollars in February 2018. This peak is followed by a sharp decline, with EBIT dropping to negative 2.148 billion US dollars in February 2019, indicating a substantial loss. Subsequent quarters show a recovery trend, with EBIT returning to positive values and demonstrating growth, reaching up to 731.5 million US dollars by April 2022 before declining again to around 381.1 million US dollars in October 2022. Overall, the pattern suggests episodic volatility possibly related to extraordinary events or operational challenges.
- Interest Expense, Net
- The net interest expense exhibits some fluctuations but remains within a narrower range compared to EBIT. Most quarters report values between approximately 30.6 million and 75 million US dollars. A notable spike occurs in May 2018, where net interest expense rises significantly to 230 million US dollars, twice the usual levels, before returning to more stable figures in subsequent quarters. This isolated surge might indicate refinancing activities or changes in debt structure during that period.
- Interest Coverage Ratio
- The interest coverage ratio, calculated as EBIT divided by interest expense, reflects the company’s ability to meet its interest obligations. The ratio starts at a moderate level around 4.6 in April 2017 and steadily improves until early 2018. The ratio then experiences a dramatic drop into negative territory in February 2019, concurrent with the negative EBIT, reaching a low of approximately -6.71. This indicates that earnings were insufficient to cover interest costs during that time, suggesting financial distress or extraordinary losses. Following this low, the coverage ratio rebounds significantly, peaking above 14 by mid to late 2021, indicating a strong improvement in earnings relative to interest expenses. The ratio remains above 10 towards the end of the period, signifying a relatively solid capacity to cover interest costs.