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).
- Debt to Equity Ratio
- The debt to equity ratio demonstrated a steady decline from 1.57 in April 2016 to a low of 0.41 in April and July 2022, suggesting a strengthening equity base relative to debt. An uptick to 0.46 was observed in the final period (October 2022), indicating a slight increase in leverage.
- Debt to Equity Ratio Including Operating Lease Liability
- The ratio including operating lease liability showed an initial decline from 1.57 in early 2016 to 0.63 in November 2018, followed by a sharp increase peaking at 1.8 in May 2019. After this peak, there was a gradual decreasing trend down to a low of 1.19 in July 2022 before rising slightly to 1.25 in October 2022. This pattern reflects the impact of lease liabilities being accounted for and their influence on leverage metrics.
- Debt to Capital Ratio
- This ratio decreased steadily from 0.61 in April 2016 to 0.29 in April and July 2022, illustrating a reduction in debt as a portion of total capital employed. A minor increase to 0.31 in the last period indicates a slight uptick in leverage.
- Debt to Capital Ratio Including Operating Lease Liability
- Similar to the debt to equity including operating leases, this ratio remained relatively stable around 0.6–0.64 from May 2019 through the end of the period, signifying sustained capital structure levels when considering lease obligations.
- Debt to Assets Ratio
- The debt to assets ratio showed a consistent downward trend from 0.46 in April 2016 to around 0.15-0.16 by mid to late 2022. This indicates an overall reduction in debt relative to total assets, signifying improved asset coverage over liabilities.
- Debt to Assets Ratio Including Operating Lease Liability
- Including operating leases, the ratio escalated sharply from 0.3 in November 2018 to approximately 0.53 in May 2019 and remained near that level through the subsequent periods. This highlights the material impact of lease liabilities on the company's asset leverage.
- Financial Leverage Ratio
- Financial leverage decreased from a high of 3.44 in April 2016 to roughly 2.7-2.8 by late 2022, with a moderate rebound occurring between mid-2019 and mid-2021. The overall trend suggests a gradual reduction in reliance on debt financing relative to equity.
- Interest Coverage Ratio
- Interest coverage showed substantial variability with incomplete early data. From early 2017 to late 2018, ratios ranged between approximately 4.5 and 6.65, indicating comfortable earnings coverage of interest expenses. However, significant negative coverage values appeared from late 2018 to early 2020 (-2.54 to -6.71), signaling earnings insufficient to cover interest during this period. Thereafter, the ratio improved markedly, reaching high levels above 10 by early 2021 and sustaining strong coverage through to late 2022, reflecting an improved ability to meet interest obligations.
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 | 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 | — | — | — | — | — | — | — | — | ||||||||
| 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 | — | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| 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 | — | — | — | — | — | — | — | — | — | — | — | — | ||||||||
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.
The financial data reveals notable trends in the total debt, shareholders’ equity, and the debt to equity ratio over the analyzed periods. There is evidence of both fluctuations and structural changes that impact the company’s financial leverage and capital structure.
- Total Debt
- The total debt exhibits a general declining trend from April 2016 through January 2021. Initially, debt decreases steadily from approximately 7.33 billion US dollars in April 2016 to about 3.23 billion US dollars by January 2021. After this point, the figure stabilizes somewhat but shows a slight increase toward the last periods, rising from 3.23 billion to 3.77 billion US dollars by October 2022. The most significant reduction occurs in the first half of the timeline, indicating possible efforts to reduce leverage or repay outstanding obligations.
- Shareholders’ Equity
- Shareholders’ equity shows a generally increasing pattern alongside the timeline, with some exceptions. Starting from roughly 4.67 billion US dollars in April 2016, equity grows steadily and peaks above 7.96 billion US dollars by November 2018. However, a sharp decline follows, dropping to around 5.64 billion US dollars in February 2019. After this decrease, equity recommences an upward trajectory, reaching a peak of approximately 8.40 billion US dollars in July 2022. Towards the final periods, equity remains relatively stable but slightly dips in the last observation to around 8.28 billion US dollars. This pattern suggests episodes of capital appreciation possibly offset by interim losses, stock buybacks, or dividend distributions.
- Debt to Equity Ratio
- The debt to equity ratio demonstrates a clear downward trajectory with some intermittent fluctuations. Beginning at 1.57 in April 2016, the ratio steadily declines to 0.44 by May 2021, indicating a meaningful reduction in financial leverage and a stronger equity base relative to debt. Between early 2019 and mid-2020, there is a modest increase and variability in the ratio, reflecting the temporary drop in equity and fluctuations in debt during that period. From May 2021 onwards, the ratio remains within a narrow range—from 0.41 to 0.46—suggesting a relatively stable capital structure as of the last periods.
Overall, the data suggests a strategic focus on deleveraging through the observed timeline, with debt levels being reduced substantially in the first several years, accompanied by growth in equity that strengthens the balance sheet. Periodic fluctuations in equity and debt ratios indicate adjustments or external impacts influencing the company's financial position, but the prevailing trend conveys improved solvency and lower leverage risk over time.
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 | — | — | — | — | — | — | — | — | ||||||||
| 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 | — | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| 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 | — | — | — | — | — | — | — | — | — | — | — | — | ||||||||
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.
- Total Debt (including operating lease liability)
- Over the observed quarters, total debt exhibited a downward trend from approximately 7.33 billion USD in April 2016 to a low near 4.27 billion USD by early 2019. Subsequently, a substantial increase occurred, with debt peaking above 10.33 billion USD by late 2019 and maintaining elevated levels around 9.9 to 10.3 billion USD through late 2022. The initial sustained decrease may indicate strategic debt reduction efforts.
- Shareholders' Equity
- Shareholders' equity displayed a general upward trajectory from roughly 4.67 billion USD in April 2016 to a peak exceeding 7.94 billion USD by late 2018. This was followed by a notable decline to approximately 5.64 billion USD in early 2019, before resuming its rise steadily, reaching over 8.39 billion USD near the end of the recorded period. The dip around 2019 may reflect one-time items or market adjustments affecting equity position.
- Debt to Equity Ratio (including operating lease liability)
- The debt to equity ratio decreased from 1.57 in early 2016 to a low of 0.63 by late 2018, indicating an improvement in capital structure with less reliance on debt relative to equity. However, a sharp increase was observed in early 2019, with the ratio climbing to a peak of 1.80 and remaining elevated above 1.2 through 2022. Despite some fluctuations, the ratio remained significantly higher post-2019 compared to prior years, signaling a shift towards greater leverage.
- Overall Insights
- The data reveals two distinct phases: from 2016 to late 2018, the company consistently reduced debt levels while increasing equity, resulting in a strengthening capital base and lower leverage. From 2019 onwards, there was a marked reversal characterized by substantial increases in debt, a temporary dip in equity, and elevated leverage ratios. This shift may reflect strategic financing decisions, acquisitions, or external economic factors influencing capital structure. The company ended the period with higher absolute debt and equity, yet with a higher debt to equity ratio compared to the earlier years, implying a more leveraged financial posture.
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 | — | — | — | — | — | — | — | — | ||||||||
| 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 | — | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| 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 | — | — | — | — | — | — | — | — | — | — | — | — | ||||||||
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.
- Total Debt
- Over the observed periods, total debt exhibits a generally declining trend from April 2016 to January 2021, decreasing from approximately $7.33 billion to around $3.23 billion. This represents a substantial reduction in debt levels. However, from January 2021 onward, a slight increase in total debt is observed, rising from $3.23 billion to approximately $3.77 billion by October 2022.
- Total Capital
- Total capital fluctuates over the periods but shows an overall downward trend from around $12.0 billion in early 2016 to approximately $10.0 billion by early 2020. Thereafter, it gradually rises again, reaching about $12.0 billion by late 2022. This rebound suggests capital structure adjustments or growth in equity or other capital components after the 2020 low point.
- Debt to Capital Ratio
- The debt to capital ratio steadily decreases from 0.61 in April 2016 to a low of 0.29 by April and July 2022, indicating a reduction in leverage over this timeframe. The ratio dips consistently, reflecting a relative decline in debt compared to total capital. A minor uptick to 0.31 occurs in October 2022, echoing the marginal rise in total debt during the same period.
- Summary Insights
- The data indicates a deliberate reduction in leverage with the company lowering its total debt substantially over several years prior to 2021. This deleveraging effort coincides with relatively stable or fluctuating total capital levels, leading to sustained improvements in the debt to capital ratio. The increase in debt and capital levels after 2021 likely corresponds to strategic financing decisions, possibly influenced by market conditions or business needs. Overall, the movement suggests a focus on strengthening the balance sheet with cautious debt management while adjusting capital structure in response to evolving circumstances.
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 | — | — | — | — | — | — | — | — | ||||||||
| 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 | — | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| 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 | — | — | — | — | — | — | — | — | — | — | — | — | ||||||||
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.
- Total Debt (Including Operating Lease Liability)
-
The total debt level shows a fluctuating pattern over the analyzed quarters. From April 2016 to February 2019, there was a general downward trend where the debt decreased from approximately 7.33 billion to around 4.27 billion US dollars. This represents a significant reduction in debt during this period.
However, starting in May 2019, total debt increased sharply, reaching over 10 billion US dollars by that date. Following this spike, debt levels remained relatively stable but above 9.7 billion US dollars through October 2022, fluctuating slightly but without returning to the earlier lower levels.
- Total Capital (Including Operating Lease Liability)
-
Total capital shows variability but generally upward movement over the span of the data. From about 12 billion US dollars in early 2016, it decreased to roughly 9.9 billion by February 2019, coinciding with the reduction in debt observed during this time frame.
Post-February 2019, total capital increased markedly from under 10 billion to above 18.6 billion US dollars by October 2022. This rise parallels the increase in total debt, indicating an overall expansion in the company’s capital base in recent years.
- Debt to Capital Ratio
-
The debt-to-capital ratio exhibits a clear trend of decline from 0.61 in April 2016 to a low of 0.39 in November 2018, suggesting a reduction in leverage and an improvement in the capital structure during this period. This decreasing leverage is consistent with the decline in total debt and capital previously noted.
From early 2019 onwards, there was a sharp increase in this ratio to approximately 0.64 in May 2019, remaining elevated above 0.54 through the subsequent quarters. The higher ratio indicates increased leverage, reflecting the substantial growth in debt relative to capital observed after early 2019.
Although the ratio slightly declined after peaking, it stayed within a range of 0.54 to 0.58 during the last few quarters of the reporting period, suggesting a moderately higher leverage position compared to the pre-2019 period.
- Overall Insights
-
The data reveal two distinct phases in capital structure. The first phase, from 2016 to early 2019, is characterized by debt reduction and deleveraging, as indicated by falling total debt, declining total capital, and decreasing debt-to-capital ratio. This period likely reflects efforts to strengthen the financial position or reduce financing costs.
The second phase, beginning in 2019, shows a marked reversal with significant increases in both total debt and total capital, resulting in an elevated debt-to-capital ratio. This shift suggests a strategic change possibly involving increased borrowing to fund expansion, acquisitions, or other investments, leading to higher leverage.
While the company maintains a higher leverage level than in the earlier period, the fluctuations in the debt-to-capital ratio since 2019 indicate ongoing adjustments in financing strategy or capital structure management.
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 | — | — | — | — | — | — | — | — | ||||||||
| 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 | — | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| 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 | — | — | — | — | — | — | — | — | — | — | — | — | ||||||||
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.
- Total Debt
- Over the analyzed periods, total debt exhibited a general downward trend from April 2016 through early 2021, decreasing from approximately 7.33 billion USD to around 3.23 billion USD. This represents a significant reduction in the company's debt obligations over approximately five years. However, starting from early 2021, total debt showed slight increases, rising from around 3.23 billion USD to 3.77 billion USD by October 2022. Despite these modest rises, the debt levels remained well below those seen in the earlier periods.
- Total Assets
- Total assets fluctuated over the entire period but generally showed an increasing trend. Beginning at approximately 16.06 billion USD in April 2016, asset levels experienced some volatility, with notable variations around early 2019, where a significant drop to about 13.5 billion USD was recorded. After this dip, assets resumed an upward trajectory, peaking near 22.9 billion USD by the end of the analyzed timeline in October 2022. This overall asset growth suggests ongoing expansion or accumulation of resources.
- Debt to Assets Ratio
- The debt to assets ratio demonstrated a clear and consistent decline from April 2016 through early 2021. Starting at 0.46, the ratio steadily decreased to around 0.15 by mid-2021, indicating an improved balance sheet with less reliance on debt relative to total asset base. Through late 2022, the ratio remained relatively stable, fluctuating slightly between 0.15 and 0.16. The sustained low ratio reflects ongoing efforts to manage leverage prudently despite the modest increases in total debt observed in the latter periods.
- Summary
- The financial data reveals a strategic reduction in debt coupled with an overall increase in asset holdings over multiple years, effectively lowering the leverage ratio. After several years of consistent debt reduction, a slight uptick in debt levels in 2021 and beyond indicates potential new financing or investment activities but does not significantly impair the company's leveraged position. The stable and low debt to assets ratio towards the end of the series reflects sound capital structure management in the context of growing assets.
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 | — | — | — | — | — | — | — | — | ||||||||
| 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 | — | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| 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 | — | — | — | — | — | — | — | — | — | — | — | — | ||||||||
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.
- Total Debt (including operating lease liability)
- The total debt demonstrated a general decreasing trend from April 2016 to February 2019, falling from approximately 7.33 billion USD to about 4.27 billion USD. This decline indicates a significant reduction in leverage during this period. However, starting from May 2019, there was a sharp increase in total debt, peaking over 10 billion USD and remaining around that level through October 2022. This suggests a strategic shift toward higher leverage or increased capital expenditure commitments post-2019.
- Total Assets
- Total assets showed moderate fluctuations over the observed quarters. From April 2016 to February 2019, assets hovered around the mid-15 to mid-16 billion USD range, with a notable dip to approximately 13.5 billion USD in February 2019. Post this dip, there was a significant rise, with assets increasing steadily from about 19.35 billion USD in May 2019 to approximately 22.9 billion USD by October 2022. This upward trend reflects asset growth, possibly related to expansion or acquisition activities in recent years.
- Debt to Assets Ratio (including operating lease liability)
- The debt to assets ratio demonstrated a downward trajectory from April 2016 (0.46) until November 2018 (0.30), indicating an improvement in the company's capital structure and lower relative leverage. However, from early 2019 onwards, this ratio increased sharply to approximately 0.53 and has since remained relatively stable around 0.44 to 0.47. This pattern aligns with the rise in total debt and total assets post-2019 and suggests a re-balancing or acceptance of higher leverage levels during this period.
- Summary of Trends
- Overall, the financial data reveals an initial phase (2016 to early 2019) characterized by debt reduction and relatively stable assets, leading to improved leverage ratios. A marked change occurred in 2019, with substantial increases in both total debt and assets, resulting in a higher but stable debt to assets ratio. These developments may indicate a phase of strategic investment or expansion financed through increased borrowing, altering the company's financial risk profile.
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 | — | — | — | — | — | — | — | — | ||||||||
| 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 | — | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| 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 | — | — | — | — | — | — | — | — | — | — | — | — | ||||||||
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.
- Total Assets
- The total assets generally exhibit an upward trajectory over the reported periods. Starting at approximately 16.06 billion US dollars in April 2016, the value experienced fluctuations but maintained a predominantly increasing trend, reaching around 22.91 billion US dollars by October 2022. Notable observations include a distinct dip around February 2019, where total assets decreased to roughly 13.5 billion US dollars, followed by a rapid recovery and subsequent growth thereafter. This dip represents a significant deviation from the overall growth pattern and may suggest substantial asset disposals, revaluation, or accounting changes during that quarter.
- Shareholders’ Equity
- Shareholders’ equity shows a generally increasing pattern, moving from about 4.67 billion US dollars in April 2016 to a peak near 8.4 billion US dollars around August 2022. The equity decreased sharply to approximately 5.64 billion US dollars in February 2019, coinciding with the decline in total assets during the same period. This decrease suggests a considerable loss or distribution impacting equity at that time. Afterward, shareholders’ equity recovered and steadily increased, reflecting strengthening financial positions or retained earnings accumulation. Minor fluctuations occur but the overall trend remains positive.
- Financial Leverage Ratio
- The financial leverage ratio, defined as total assets divided by shareholders’ equity, displays variability throughout the periods. It starts relatively high at 3.44 in April 2016 and shows a gradual decline to around 2.10–2.39 between May 2018 and February 2019, correlating with the drop in both assets and equity. Subsequently, the ratio spikes back above 3.0 in mid-2019, indicating increased leverage or higher reliance on debt relative to equity in that timeframe. From early 2020 onwards, the ratio trends downward modestly again, stabilizing near 2.7 to 2.8 by late 2022. This pattern indicates fluctuations in the company’s capital structure, with periods of increased asset financing through liabilities followed by phases of reduced financial leverage.
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 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| 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 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| 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 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||||
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.
- Earnings before interest and tax (EBIT)
- The EBIT values exhibit notable fluctuation over the observed periods. Initially, EBIT remained within a range of approximately 340,000 to 590,000 US$ thousands from April 2016 through January 2017. A significant peak is observed in February 2018 with EBIT reaching 773,100 US$ thousands, followed by a sharp decline to negative 2,147,800 US$ thousands in February 2019. After this negative anomaly, EBIT returned to positive territory and stabilized at lower levels between 200,000 and 380,000 US$ thousands through early 2020. From mid-2020 onwards, EBIT shows a consistent upward trend, reaching peaks above 700,000 US$ thousands in April 2022 before declining again towards the end of 2022. This pattern suggests an irregular period around early 2019, possibly reflecting extraordinary events or adjustments, followed by recovery and gradual growth in operating earnings.
- Interest expense, net
- Interest expense has generally fluctuated within a moderate range of approximately 30,000 to 87,000 US$ thousands for most periods. Anomalies are apparent with a spike to 230,000 US$ thousands in May 2018 and 79,500 US$ thousands in April 2022, representing substantial increases relative to adjacent quarters. Apart from these spikes, interest expense remains relatively stable with minor variations. The spikes may correspond to changes in debt structure or refinancing activities that increased interest costs temporarily.
- Interest coverage ratio
- The interest coverage ratio is absent for the initial periods but is calculable from January 2017 onwards. Generally, the ratio remains above 4.5 in early periods, indicating adequate EBIT coverage of interest expenses. A marked decline occurs in February 2019 through November 2019, where the ratio turns negative, reflecting EBIT losses relative to interest expense. Following this low point, there is a robust recovery with the ratio increasing steadily from early 2020, peaking at a high of approximately 15 in late 2021. This suggests improved profitability and reduced risk related to interest obligations. The ratio dips somewhat in 2022 but stays comfortably above 10, implying strong earnings relative to interest costs throughout most recent periods.