Solvency ratios also known as long-term debt ratios measure a company ability to meet long-term obligations.
Solvency Ratios (Summary)
Based on: 10-Q (reporting date: 2023-04-29), 10-K (reporting date: 2023-01-28), 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 Ratio
- The Debt to Equity ratio exhibits significant volatility over the observed periods. Initially, the ratio is low at 0.89 in April 2017 but is followed by missing data. A notably high value occurs around early 2018 at 102.71, which sharply decreases in subsequent quarters. From early 2019 onwards, the ratio stabilizes within a narrower range between approximately 1.29 and 3.98, signaling a moderation in financial leverage compared to the earlier spike.
- Debt to Equity Ratio (Including Operating Lease Liability)
- This ratio follows a pattern similar to the standard Debt to Equity ratio but with consistently higher values throughout the periods where data is available. The presence of operating lease liabilities increases the ratio significantly, especially notable are the peaks exceeding 90 in early 2020, followed by a decrease to a range between 2.03 and 4.72 in the latest periods. This indicates that operating leases constitute a substantial component of the company's leverage during these periods.
- Debt to Capital Ratio
- The Debt to Capital ratio remains relatively high throughout, starting at 0.47 in April 2017 and fluctuating close to or above 1 in the following quarters up to early 2020. Post this period, the ratio trends downward, reaching as low as 0.56 by late 2021 before rising slightly again to around 0.79 in April 2023. This trend suggests a gradual reduction in debt relative to total capital, indicating potential deleveraging efforts or capital base growth.
- Debt to Capital Ratio (Including Operating Lease Liability)
- Inclusion of operating lease liabilities again results in higher values for this ratio compared to the standard Debt to Capital ratio. The ratio remains close to or above 1 until early 2020, similar to the standard measure, but shows a modest increase towards the end of the data period, with values reaching approximately 0.81 by April 2023. This identifies operating leases as a consistent contributor to overall capital structure debt consideration.
- Debt to Assets Ratio
- The Debt to Assets ratio shows a moderate upward trend from 0.29 in April 2017 to a peak of 0.66 in May 2019, followed by a gradual decline to 0.31 in late 2021. A rebound is observed afterward, with values rising back to around 0.58 by April 2023. This pattern suggests variability in asset financing, with periods of increased reliance on debt before a reduction and a subsequent uptick.
- Debt to Assets Ratio (Including Operating Lease Liability)
- This ratio follows similar cyclical fluctuations but at generally higher levels, highlighting the impact of operating leases on asset-related leverage. Peaks near 0.85 and 0.82 occur in mid-2019, with a subsequent decline to about 0.49 to 0.52 in late 2021, before climbing again to 0.7 by the latest period. This increased leverage including leases indicates a notable adjustment in asset financing structure involving lease obligations.
- Financial Leverage
- Financial leverage demonstrates extreme fluctuations, with very high ratios such as 202.38 and 131.13 observed in earlier periods around 2018 and 2020, likely linked to exceptional debt levels or accounting treatments. Following these spikes, the ratio settles at lower but variable levels, ranging between approximately 4.14 and 6.77 from 2019 to 2023. This decreasing pattern indicates a movement towards reduced net leverage or an increase in equity base relative to total assets.
Debt Ratios
Debt to Equity
Apr 29, 2023 | Jan 28, 2023 | 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) | |||||||||||||||||||||||||||||||||
Convertible senior notes due 2024, net | —) | —) | —) | —) | —) | 3,600) | 56,365) | 66,503) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
Convertible senior notes due 2023, net | 1,694) | 1,696) | 1,702) | 1,704) | —) | 9,389) | 53,242) | 172,141) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
Convertible senior notes due 2020, net | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | 295,574) | 290,532) | 285,570) | 280,688) | —) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
Convertible senior notes due 2019, net | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | 347,918) | 343,789) | 339,707) | 335,670) | —) | —) | —) | —) | —) | ||||||||
Convertible senior notes repurchase obligation | —) | —) | —) | —) | 313,706) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
Asset based credit facility | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | 91,600) | 10,000) | —) | —) | 145,000) | —) | 57,500) | 107,500) | —) | 219,000) | 199,970) | 341,000) | 283,000) | —) | ||||||||
Term loan B, net | 1,932,356) | 1,936,529) | 1,940,701) | 1,944,870) | 1,949,038) | 1,953,203) | 1,957,366) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
Term loan B-2, net | 469,091) | 469,245) | 469,396) | 469,546) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
FILO term loan, net | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | 89,408) | 119,086) | 119,065) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
Second lien term loan, net | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | 197,262) | 197,140) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
Term loan, net | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | 79,528) | 79,499) | 79,471) | 176,363) | —) | ||||||||
Real estate loans | 17,905) | 17,909) | 17,912) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
Equipment promissory notes, net | —) | —) | —) | —) | —) | 1,129) | 1,625) | 2,115) | 3,739) | 14,614) | 20,363) | 26,047) | 28,475) | 31,053) | 36,613) | 42,113) | 40,208) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
Convertible senior notes due 2024, net | 41,751) | 41,724) | 41,696) | 41,668) | 80,388) | 184,461) | 181,805) | 223,547) | 285,721) | 281,454) | 277,247) | 273,100) | 269,012) | 264,982) | 261,010) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
Convertible senior notes due 2023, net | —) | —) | —) | —) | 19,658) | 59,002) | 62,214) | 93,867) | 288,136) | 282,956) | 280,536) | 275,837) | 271,211) | 266,658) | 262,177) | 257,766) | 253,424) | 249,151) | 244,944) | 240,804) | —) | —) | —) | —) | —) | ||||||||
Convertible senior notes due 2020, net | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | 275,884) | 271,157) | 266,506) | 261,929) | 257,425) | 252,994) | 248,633) | 244,342) | 240,120) | ||||||||
Convertible senior notes due 2019, net | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | 331,678) | 327,731) | 323,828) | 319,969) | 316,153) | ||||||||
Non-current finance lease liabilities | 648,792) | 653,050) | 656,643) | 661,001) | 594,728) | 560,550) | 549,098) | 523,797) | 501,118) | 485,481) | 488,660) | 492,136) | 439,470) | 442,988) | 431,379) | 433,591) | 436,228) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
Total debt | 3,111,589) | 3,120,153) | 3,128,050) | 3,118,789) | 2,957,518) | 2,771,334) | 2,861,715) | 1,081,970) | 1,078,714) | 1,064,505) | 1,066,806) | 1,158,720) | 1,313,742) | 1,296,213) | 1,366,157) | 1,475,506) | 1,669,867) | 921,597) | 958,657) | 838,403) | 887,631) | 860,194) | 992,932) | 1,023,674) | 556,273) | ||||||||
Stockholders’ equity (deficit) | 839,386) | 784,661) | 1,293,947) | 1,220,244) | 1,341,790) | 1,170,277) | 1,021,375) | 836,858) | 594,462) | 447,026) | 296,869) | 128,491) | 19,132) | 18,651) | (63,220) | (177,918) | (247,373) | (22,962) | 32,020) | 146,061) | 8,642) | (7,336) | (25,276) | (46,784) | 622,778) | ||||||||
Solvency Ratio | |||||||||||||||||||||||||||||||||
Debt to equity1 | 3.71 | 3.98 | 2.42 | 2.56 | 2.20 | 2.37 | 2.80 | 1.29 | 1.81 | 2.38 | 3.59 | 9.02 | 68.67 | 69.50 | — | — | — | — | 29.94 | 5.74 | 102.71 | — | — | — | 0.89 | ||||||||
Benchmarks | |||||||||||||||||||||||||||||||||
Debt to Equity, Competitors2 | |||||||||||||||||||||||||||||||||
Amazon.com Inc. | 0.36 | 0.39 | 0.43 | 0.48 | 0.54 | 0.59 | 0.58 | 0.62 | 0.53 | 0.54 | 0.63 | 0.67 | 0.58 | 0.66 | 0.73 | 0.83 | 0.78 | — | — | — | — | — | — | — | — | ||||||||
Home Depot Inc. | 116.72 | 27.65 | 33.10 | 173.11 | — | — | 37.82 | 17.48 | 20.52 | 11.29 | 23.01 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||||
Lowe’s Cos. Inc. | — | — | — | — | — | — | — | — | 52.23 | 15.16 | 5.35 | 5.01 | 12.71 | 9.79 | 7.26 | 6.65 | 5.42 | — | — | — | — | — | — | — | — | ||||||||
TJX Cos. Inc. | 0.52 | 0.53 | 0.59 | 0.62 | 0.60 | 0.56 | 0.52 | 0.52 | 0.87 | 1.04 | 1.11 | 1.33 | 1.52 | 0.38 | 0.40 | 0.42 | 0.44 | — | — | — | — | — | — | — | — |
Based on: 10-Q (reporting date: 2023-04-29), 10-K (reporting date: 2023-01-28), 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 Q1 2024 Calculation
Debt to equity = Total debt ÷ Stockholders’ equity (deficit)
= 3,111,589 ÷ 839,386 = 3.71
2 Click competitor name to see calculations.
The analysis of the quarterly financial data reveals several notable trends relating to the company's debt levels, stockholders' equity, and debt-to-equity ratio over the observed periods.
- Total Debt
-
Total debt exhibited considerable volatility. Initially, it increased sharply from approximately $556 million to over $1 billion by July 2017. Subsequently, there was some fluctuation but debt remained near or above the $800 million mark until early 2019. Starting in May 2019, total debt surged significantly, peaking above $3.1 billion in the last quarters of the dataset. This suggests an increased reliance on debt financing in recent years.
- Stockholders’ Equity (Deficit)
-
Stockholders' equity began positively at approximately $623 million but dropped drastically to negative values from mid-2017 through early 2018. From mid-2018 onward, equity levels generally improved, transitioning from negative to positive territory by mid-2018 and increasing steadily thereafter. The company recorded its highest equity around $1.34 billion in mid-2021, followed by some decline and renewed growth, ending at approximately $839 million in April 2023. These fluctuations indicate periods of financial stress followed by recovery and capitalization enhancement.
- Debt to Equity Ratio
-
The debt-to-equity ratio data is incomplete in the earlier periods but shows extreme values in 2018, reaching as high as over 100 in May 2018, likely driven by the equity deficit during that time. After mid-2019, ratios generally trended lower, reflecting improvements in equity alongside continued debt accumulation. Post-2019, the ratio stabilized mostly between 1.2 and 4.0, indicating a more balanced capital structure, though the ratio increased slightly toward early 2023. Notably, the ratio spikes correlate with periods of low or negative equity, emphasizing leverage risk during those times.
Overall, the financial data indicates that the company underwent a phase of financial distress marked by negative equity and high leverage around 2017-2018. Thereafter, it appears to have improved its equity base substantially while simultaneously increasing total debt, resulting in a more normalized but still elevated leverage position. The trends imply active financial management aimed at balancing growth funding through debt while strengthening shareholder equity.
Debt to Equity (including Operating Lease Liability)
Apr 29, 2023 | Jan 28, 2023 | 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) | |||||||||||||||||||||||||||||||||
Convertible senior notes due 2024, net | —) | —) | —) | —) | —) | 3,600) | 56,365) | 66,503) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
Convertible senior notes due 2023, net | 1,694) | 1,696) | 1,702) | 1,704) | —) | 9,389) | 53,242) | 172,141) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
Convertible senior notes due 2020, net | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | 295,574) | 290,532) | 285,570) | 280,688) | —) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
Convertible senior notes due 2019, net | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | 347,918) | 343,789) | 339,707) | 335,670) | —) | —) | —) | —) | —) | ||||||||
Convertible senior notes repurchase obligation | —) | —) | —) | —) | 313,706) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
Asset based credit facility | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | 91,600) | 10,000) | —) | —) | 145,000) | —) | 57,500) | 107,500) | —) | 219,000) | 199,970) | 341,000) | 283,000) | —) | ||||||||
Term loan B, net | 1,932,356) | 1,936,529) | 1,940,701) | 1,944,870) | 1,949,038) | 1,953,203) | 1,957,366) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
Term loan B-2, net | 469,091) | 469,245) | 469,396) | 469,546) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
FILO term loan, net | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | 89,408) | 119,086) | 119,065) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
Second lien term loan, net | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | 197,262) | 197,140) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
Term loan, net | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | 79,528) | 79,499) | 79,471) | 176,363) | —) | ||||||||
Real estate loans | 17,905) | 17,909) | 17,912) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
Equipment promissory notes, net | —) | —) | —) | —) | —) | 1,129) | 1,625) | 2,115) | 3,739) | 14,614) | 20,363) | 26,047) | 28,475) | 31,053) | 36,613) | 42,113) | 40,208) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
Convertible senior notes due 2024, net | 41,751) | 41,724) | 41,696) | 41,668) | 80,388) | 184,461) | 181,805) | 223,547) | 285,721) | 281,454) | 277,247) | 273,100) | 269,012) | 264,982) | 261,010) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
Convertible senior notes due 2023, net | —) | —) | —) | —) | 19,658) | 59,002) | 62,214) | 93,867) | 288,136) | 282,956) | 280,536) | 275,837) | 271,211) | 266,658) | 262,177) | 257,766) | 253,424) | 249,151) | 244,944) | 240,804) | —) | —) | —) | —) | —) | ||||||||
Convertible senior notes due 2020, net | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | 275,884) | 271,157) | 266,506) | 261,929) | 257,425) | 252,994) | 248,633) | 244,342) | 240,120) | ||||||||
Convertible senior notes due 2019, net | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | 331,678) | 327,731) | 323,828) | 319,969) | 316,153) | ||||||||
Non-current finance lease liabilities | 648,792) | 653,050) | 656,643) | 661,001) | 594,728) | 560,550) | 549,098) | 523,797) | 501,118) | 485,481) | 488,660) | 492,136) | 439,470) | 442,988) | 431,379) | 433,591) | 436,228) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
Total debt | 3,111,589) | 3,120,153) | 3,128,050) | 3,118,789) | 2,957,518) | 2,771,334) | 2,861,715) | 1,081,970) | 1,078,714) | 1,064,505) | 1,066,806) | 1,158,720) | 1,313,742) | 1,296,213) | 1,366,157) | 1,475,506) | 1,669,867) | 921,597) | 958,657) | 838,403) | 887,631) | 860,194) | 992,932) | 1,023,674) | 556,273) | ||||||||
Current operating lease liabilities | 81,262) | 80,384) | 77,858) | 75,289) | 74,309) | 73,834) | 74,706) | 74,074) | 72,442) | 71,524) | 64,879) | 63,866) | 61,997) | 58,924) | 55,753) | 57,162) | 56,601) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
Non-current operating lease liabilities | 504,479) | 505,809) | 521,093) | 527,445) | 533,074) | 540,513) | 538,886) | 542,510) | 532,142) | 448,169) | 405,432) | 406,012) | 395,641) | 409,930) | 412,247) | 415,803) | 427,961) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
Total debt (including operating lease liability) | 3,697,330) | 3,706,346) | 3,727,001) | 3,721,523) | 3,564,901) | 3,385,681) | 3,475,307) | 1,698,554) | 1,683,298) | 1,584,198) | 1,537,117) | 1,628,598) | 1,771,380) | 1,765,067) | 1,834,157) | 1,948,471) | 2,154,429) | 921,597) | 958,657) | 838,403) | 887,631) | 860,194) | 992,932) | 1,023,674) | 556,273) | ||||||||
Stockholders’ equity (deficit) | 839,386) | 784,661) | 1,293,947) | 1,220,244) | 1,341,790) | 1,170,277) | 1,021,375) | 836,858) | 594,462) | 447,026) | 296,869) | 128,491) | 19,132) | 18,651) | (63,220) | (177,918) | (247,373) | (22,962) | 32,020) | 146,061) | 8,642) | (7,336) | (25,276) | (46,784) | 622,778) | ||||||||
Solvency Ratio | |||||||||||||||||||||||||||||||||
Debt to equity (including operating lease liability)1 | 4.40 | 4.72 | 2.88 | 3.05 | 2.66 | 2.89 | 3.40 | 2.03 | 2.83 | 3.54 | 5.18 | 12.67 | 92.59 | 94.64 | — | — | — | — | 29.94 | 5.74 | 102.71 | — | — | — | 0.89 | ||||||||
Benchmarks | |||||||||||||||||||||||||||||||||
Debt to Equity (including Operating Lease Liability), Competitors2 | |||||||||||||||||||||||||||||||||
Amazon.com Inc. | 0.71 | 0.77 | 0.84 | 0.91 | 1.00 | 1.06 | 1.05 | 1.08 | 0.97 | 0.96 | 1.07 | 1.07 | 0.98 | 1.08 | 1.16 | 1.23 | 1.20 | — | — | — | — | — | — | — | — | ||||||||
Home Depot Inc. | 136.54 | 32.24 | 38.30 | 199.91 | — | — | 43.73 | 20.47 | 23.99 | 13.16 | 26.74 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||||
Lowe’s Cos. Inc. | — | — | — | — | — | — | — | — | 62.29 | 18.24 | 6.44 | 6.01 | 15.28 | 12.04 | 9.07 | 8.37 | 6.83 | — | — | — | — | — | — | — | — | ||||||||
TJX Cos. Inc. | 2.00 | 2.00 | 2.23 | 2.34 | 2.27 | 2.08 | 1.99 | 2.01 | 2.42 | 2.66 | 2.81 | 3.36 | 3.48 | 1.93 | 2.07 | 2.14 | 2.18 | — | — | — | — | — | — | — | — |
Based on: 10-Q (reporting date: 2023-04-29), 10-K (reporting date: 2023-01-28), 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 Q1 2024 Calculation
Debt to equity (including operating lease liability) = Total debt (including operating lease liability) ÷ Stockholders’ equity (deficit)
= 3,697,330 ÷ 839,386 = 4.40
2 Click competitor name to see calculations.
- Total Debt (including operating lease liability)
- The total debt shows considerable volatility throughout the periods analyzed. Initially, from April 2017 to August 2017, the debt nearly doubled from approximately 556 million USD to over 1 billion USD. Following this peak, the debt fluctuates, experiencing moderate decreases and increases until early 2019. From May 2019, there is a pronounced surge, with debt more than doubling to a peak exceeding 3.4 billion USD by October 2021. Subsequently, the debt remains relatively stable but at elevated levels, fluctuating slightly around 3.6 to 3.7 billion USD through April 2023.
- Stockholders’ Equity (Deficit)
- Stockholders' equity displays significant instability in the initial periods, with a striking transition from a positive 622 million USD in April 2017 to negative values through parts of 2017 and early 2018. Equity then recovers substantially starting mid-2018, moving into positive territory consistently and demonstrating a general upward trend through to early 2022. Between 2022 and early 2023, equity fluctuates but remains positive, peaking above 1.3 billion USD before a notable drop to approximately 784 million USD in April 2023, followed by a small recovery to 839 million USD.
- Debt to Equity Ratio (Including Operating Lease Liability)
- The debt to equity ratio shows extreme fluctuation and high values in certain periods, particularly during times of negative or low equity. In 2017, after the initial ratio of 0.89, several periods lack data, but where available, the ratio spikes as high as 102.71 and 29.94, reflecting significant leverage driven by negative or minimal equity. From mid-2019 onward, the ratio stabilizes somewhat, with figures typically ranging between approximately 2.03 and 5.18. Notably, there are peaks near 4.72 and 4.40 in the last quarters, indicating increased leverage but a more controlled range compared to earlier periods. Overall, the trend reflects fluctuating but generally high leverage corresponding with equity volatility and rising debt levels.
- Summary of Financial Trends
- The data indicates a company experiencing significant financial restructuring or volatility, with an overall increase in total debt over the long term accompanied by a recovery and strengthening of stockholders’ equity after a period of deficit. The elevated debt levels and corresponding high debt to equity ratios in multiple periods suggest a strategy reliant on leveraging, possibly for expansion or financial restructuring. Despite the equity recovery, the consistently high debt and debt to equity ratio in recent years highlight ongoing risks related to leverage. The dip in equity near the end of the analyzed period could warrant attention, although it is followed by a partial rebound.
Debt to Capital
Apr 29, 2023 | Jan 28, 2023 | 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) | |||||||||||||||||||||||||||||||||
Convertible senior notes due 2024, net | —) | —) | —) | —) | —) | 3,600) | 56,365) | 66,503) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
Convertible senior notes due 2023, net | 1,694) | 1,696) | 1,702) | 1,704) | —) | 9,389) | 53,242) | 172,141) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
Convertible senior notes due 2020, net | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | 295,574) | 290,532) | 285,570) | 280,688) | —) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
Convertible senior notes due 2019, net | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | 347,918) | 343,789) | 339,707) | 335,670) | —) | —) | —) | —) | —) | ||||||||
Convertible senior notes repurchase obligation | —) | —) | —) | —) | 313,706) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
Asset based credit facility | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | 91,600) | 10,000) | —) | —) | 145,000) | —) | 57,500) | 107,500) | —) | 219,000) | 199,970) | 341,000) | 283,000) | —) | ||||||||
Term loan B, net | 1,932,356) | 1,936,529) | 1,940,701) | 1,944,870) | 1,949,038) | 1,953,203) | 1,957,366) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
Term loan B-2, net | 469,091) | 469,245) | 469,396) | 469,546) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
FILO term loan, net | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | 89,408) | 119,086) | 119,065) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
Second lien term loan, net | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | 197,262) | 197,140) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
Term loan, net | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | 79,528) | 79,499) | 79,471) | 176,363) | —) | ||||||||
Real estate loans | 17,905) | 17,909) | 17,912) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
Equipment promissory notes, net | —) | —) | —) | —) | —) | 1,129) | 1,625) | 2,115) | 3,739) | 14,614) | 20,363) | 26,047) | 28,475) | 31,053) | 36,613) | 42,113) | 40,208) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
Convertible senior notes due 2024, net | 41,751) | 41,724) | 41,696) | 41,668) | 80,388) | 184,461) | 181,805) | 223,547) | 285,721) | 281,454) | 277,247) | 273,100) | 269,012) | 264,982) | 261,010) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
Convertible senior notes due 2023, net | —) | —) | —) | —) | 19,658) | 59,002) | 62,214) | 93,867) | 288,136) | 282,956) | 280,536) | 275,837) | 271,211) | 266,658) | 262,177) | 257,766) | 253,424) | 249,151) | 244,944) | 240,804) | —) | —) | —) | —) | —) | ||||||||
Convertible senior notes due 2020, net | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | 275,884) | 271,157) | 266,506) | 261,929) | 257,425) | 252,994) | 248,633) | 244,342) | 240,120) | ||||||||
Convertible senior notes due 2019, net | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | 331,678) | 327,731) | 323,828) | 319,969) | 316,153) | ||||||||
Non-current finance lease liabilities | 648,792) | 653,050) | 656,643) | 661,001) | 594,728) | 560,550) | 549,098) | 523,797) | 501,118) | 485,481) | 488,660) | 492,136) | 439,470) | 442,988) | 431,379) | 433,591) | 436,228) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
Total debt | 3,111,589) | 3,120,153) | 3,128,050) | 3,118,789) | 2,957,518) | 2,771,334) | 2,861,715) | 1,081,970) | 1,078,714) | 1,064,505) | 1,066,806) | 1,158,720) | 1,313,742) | 1,296,213) | 1,366,157) | 1,475,506) | 1,669,867) | 921,597) | 958,657) | 838,403) | 887,631) | 860,194) | 992,932) | 1,023,674) | 556,273) | ||||||||
Stockholders’ equity (deficit) | 839,386) | 784,661) | 1,293,947) | 1,220,244) | 1,341,790) | 1,170,277) | 1,021,375) | 836,858) | 594,462) | 447,026) | 296,869) | 128,491) | 19,132) | 18,651) | (63,220) | (177,918) | (247,373) | (22,962) | 32,020) | 146,061) | 8,642) | (7,336) | (25,276) | (46,784) | 622,778) | ||||||||
Total capital | 3,950,975) | 3,904,814) | 4,421,997) | 4,339,033) | 4,299,308) | 3,941,611) | 3,883,090) | 1,918,828) | 1,673,176) | 1,511,531) | 1,363,675) | 1,287,211) | 1,332,874) | 1,314,864) | 1,302,937) | 1,297,588) | 1,422,494) | 898,635) | 990,677) | 984,464) | 896,273) | 852,858) | 967,656) | 976,890) | 1,179,051) | ||||||||
Solvency Ratio | |||||||||||||||||||||||||||||||||
Debt to capital1 | 0.79 | 0.80 | 0.71 | 0.72 | 0.69 | 0.70 | 0.74 | 0.56 | 0.64 | 0.70 | 0.78 | 0.90 | 0.99 | 0.99 | 1.05 | 1.14 | 1.17 | 1.03 | 0.97 | 0.85 | 0.99 | 1.01 | 1.03 | 1.05 | 0.47 | ||||||||
Benchmarks | |||||||||||||||||||||||||||||||||
Debt to Capital, Competitors2 | |||||||||||||||||||||||||||||||||
Amazon.com Inc. | 0.26 | 0.28 | 0.30 | 0.32 | 0.35 | 0.37 | 0.37 | 0.38 | 0.35 | 0.35 | 0.39 | 0.40 | 0.37 | 0.40 | 0.42 | 0.45 | 0.44 | — | — | — | — | — | — | — | — | ||||||||
Home Depot Inc. | 0.99 | 0.97 | 0.97 | 0.99 | 1.04 | 1.04 | 0.97 | 0.95 | 0.95 | 0.92 | 0.96 | 1.01 | 1.11 | 1.11 | 1.04 | 1.04 | 1.08 | — | — | — | — | — | — | — | — | ||||||||
Lowe’s Cos. Inc. | 1.67 | 1.72 | 1.62 | 1.41 | 1.31 | 1.24 | 1.06 | 1.01 | 0.98 | 0.94 | 0.84 | 0.83 | 0.93 | 0.91 | 0.88 | 0.87 | 0.84 | — | — | — | — | — | — | — | — | ||||||||
TJX Cos. Inc. | 0.34 | 0.35 | 0.37 | 0.38 | 0.37 | 0.36 | 0.34 | 0.34 | 0.46 | 0.51 | 0.53 | 0.57 | 0.60 | 0.27 | 0.29 | 0.30 | 0.30 | — | — | — | — | — | — | — | — |
Based on: 10-Q (reporting date: 2023-04-29), 10-K (reporting date: 2023-01-28), 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 Q1 2024 Calculation
Debt to capital = Total debt ÷ Total capital
= 3,111,589 ÷ 3,950,975 = 0.79
2 Click competitor name to see calculations.
The financial data reveals several notable trends and fluctuations in the company's debt and capital structure over the observed periods.
- Total Debt
- Total debt exhibits significant volatility throughout the timeline. Beginning at approximately 556 million US dollars in April 2017, it more than doubled to a peak of nearly 1.02 billion by July 2017. This increase was followed by slight declines and moderate fluctuations until early 2019. A marked surge occurred again around May 2019, reaching over 1.66 billion, and continued to fluctuate between approximately 1.15 billion and 1.37 billion US dollars through early 2021. From mid-2021 onwards, a substantial increase is observed, with total debt rising sharply to levels exceeding 3 billion by October 2021 and remaining relatively stable around that figure through April 2023.
- Total Capital
- Total capital demonstrates less volatility compared to total debt but still shows considerable changes. The period starts near 1.18 billion US dollars in April 2017, dips slightly in the following quarters, then steadies around 850 to 990 million through early 2019. From mid-2019 to early 2021, capital grows steadily, peaking near 1.92 billion US dollars by July 2021. Subsequently, a dramatic increase is recorded, with capital surpassing 4 billion US dollars between October 2021 and January 2023, before experiencing a slight dip towards April 2023.
- Debt to Capital Ratio
- The debt to capital ratio starts below 0.5 in April 2017, indicating a conservative leverage position at that time. There is a sharp increase to above 1.0 by mid-2017, suggesting debt levels exceeding total capital, which persists with minor fluctuations until early 2021. From that point, the ratio declines steadily, dropping to a low of around 0.56 by October 2021, reflecting improved capital structure and reduced leverage relative to capital. However, this diminuition reverses afterward, with the ratio increasing back to approximately 0.79 by April 2023, signaling an uptick in leverage.
Overall, the company experienced notable increases in both debt and capital, especially from mid-2021 onward. Despite moments of high leverage earlier in the dataset, the company succeeded in reducing its debt to capital ratio significantly by late 2021, implying stronger capitalization during that period. This improvement, however, appears to have moderated subsequently, with leverage ratios rising slightly but maintaining levels below earlier peaks. The interplay of these dynamics suggests strategic adjustments in financing decisions, possibly balancing growth investments and debt management.
Debt to Capital (including Operating Lease Liability)
Apr 29, 2023 | Jan 28, 2023 | 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) | |||||||||||||||||||||||||||||||||
Convertible senior notes due 2024, net | —) | —) | —) | —) | —) | 3,600) | 56,365) | 66,503) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
Convertible senior notes due 2023, net | 1,694) | 1,696) | 1,702) | 1,704) | —) | 9,389) | 53,242) | 172,141) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
Convertible senior notes due 2020, net | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | 295,574) | 290,532) | 285,570) | 280,688) | —) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
Convertible senior notes due 2019, net | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | 347,918) | 343,789) | 339,707) | 335,670) | —) | —) | —) | —) | —) | ||||||||
Convertible senior notes repurchase obligation | —) | —) | —) | —) | 313,706) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
Asset based credit facility | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | 91,600) | 10,000) | —) | —) | 145,000) | —) | 57,500) | 107,500) | —) | 219,000) | 199,970) | 341,000) | 283,000) | —) | ||||||||
Term loan B, net | 1,932,356) | 1,936,529) | 1,940,701) | 1,944,870) | 1,949,038) | 1,953,203) | 1,957,366) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
Term loan B-2, net | 469,091) | 469,245) | 469,396) | 469,546) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
FILO term loan, net | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | 89,408) | 119,086) | 119,065) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
Second lien term loan, net | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | 197,262) | 197,140) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
Term loan, net | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | 79,528) | 79,499) | 79,471) | 176,363) | —) | ||||||||
Real estate loans | 17,905) | 17,909) | 17,912) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
Equipment promissory notes, net | —) | —) | —) | —) | —) | 1,129) | 1,625) | 2,115) | 3,739) | 14,614) | 20,363) | 26,047) | 28,475) | 31,053) | 36,613) | 42,113) | 40,208) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
Convertible senior notes due 2024, net | 41,751) | 41,724) | 41,696) | 41,668) | 80,388) | 184,461) | 181,805) | 223,547) | 285,721) | 281,454) | 277,247) | 273,100) | 269,012) | 264,982) | 261,010) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
Convertible senior notes due 2023, net | —) | —) | —) | —) | 19,658) | 59,002) | 62,214) | 93,867) | 288,136) | 282,956) | 280,536) | 275,837) | 271,211) | 266,658) | 262,177) | 257,766) | 253,424) | 249,151) | 244,944) | 240,804) | —) | —) | —) | —) | —) | ||||||||
Convertible senior notes due 2020, net | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | 275,884) | 271,157) | 266,506) | 261,929) | 257,425) | 252,994) | 248,633) | 244,342) | 240,120) | ||||||||
Convertible senior notes due 2019, net | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | 331,678) | 327,731) | 323,828) | 319,969) | 316,153) | ||||||||
Non-current finance lease liabilities | 648,792) | 653,050) | 656,643) | 661,001) | 594,728) | 560,550) | 549,098) | 523,797) | 501,118) | 485,481) | 488,660) | 492,136) | 439,470) | 442,988) | 431,379) | 433,591) | 436,228) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
Total debt | 3,111,589) | 3,120,153) | 3,128,050) | 3,118,789) | 2,957,518) | 2,771,334) | 2,861,715) | 1,081,970) | 1,078,714) | 1,064,505) | 1,066,806) | 1,158,720) | 1,313,742) | 1,296,213) | 1,366,157) | 1,475,506) | 1,669,867) | 921,597) | 958,657) | 838,403) | 887,631) | 860,194) | 992,932) | 1,023,674) | 556,273) | ||||||||
Current operating lease liabilities | 81,262) | 80,384) | 77,858) | 75,289) | 74,309) | 73,834) | 74,706) | 74,074) | 72,442) | 71,524) | 64,879) | 63,866) | 61,997) | 58,924) | 55,753) | 57,162) | 56,601) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
Non-current operating lease liabilities | 504,479) | 505,809) | 521,093) | 527,445) | 533,074) | 540,513) | 538,886) | 542,510) | 532,142) | 448,169) | 405,432) | 406,012) | 395,641) | 409,930) | 412,247) | 415,803) | 427,961) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
Total debt (including operating lease liability) | 3,697,330) | 3,706,346) | 3,727,001) | 3,721,523) | 3,564,901) | 3,385,681) | 3,475,307) | 1,698,554) | 1,683,298) | 1,584,198) | 1,537,117) | 1,628,598) | 1,771,380) | 1,765,067) | 1,834,157) | 1,948,471) | 2,154,429) | 921,597) | 958,657) | 838,403) | 887,631) | 860,194) | 992,932) | 1,023,674) | 556,273) | ||||||||
Stockholders’ equity (deficit) | 839,386) | 784,661) | 1,293,947) | 1,220,244) | 1,341,790) | 1,170,277) | 1,021,375) | 836,858) | 594,462) | 447,026) | 296,869) | 128,491) | 19,132) | 18,651) | (63,220) | (177,918) | (247,373) | (22,962) | 32,020) | 146,061) | 8,642) | (7,336) | (25,276) | (46,784) | 622,778) | ||||||||
Total capital (including operating lease liability) | 4,536,716) | 4,491,007) | 5,020,948) | 4,941,767) | 4,906,691) | 4,555,958) | 4,496,682) | 2,535,412) | 2,277,760) | 2,031,224) | 1,833,986) | 1,757,089) | 1,790,512) | 1,783,718) | 1,770,937) | 1,770,553) | 1,907,056) | 898,635) | 990,677) | 984,464) | 896,273) | 852,858) | 967,656) | 976,890) | 1,179,051) | ||||||||
Solvency Ratio | |||||||||||||||||||||||||||||||||
Debt to capital (including operating lease liability)1 | 0.81 | 0.83 | 0.74 | 0.75 | 0.73 | 0.74 | 0.77 | 0.67 | 0.74 | 0.78 | 0.84 | 0.93 | 0.99 | 0.99 | 1.04 | 1.10 | 1.13 | 1.03 | 0.97 | 0.85 | 0.99 | 1.01 | 1.03 | 1.05 | 0.47 | ||||||||
Benchmarks | |||||||||||||||||||||||||||||||||
Debt to Capital (including Operating Lease Liability), Competitors2 | |||||||||||||||||||||||||||||||||
Amazon.com Inc. | 0.42 | 0.43 | 0.46 | 0.48 | 0.50 | 0.51 | 0.51 | 0.52 | 0.49 | 0.49 | 0.52 | 0.52 | 0.49 | 0.52 | 0.54 | 0.55 | 0.54 | — | — | — | — | — | — | — | — | ||||||||
Home Depot Inc. | 0.99 | 0.97 | 0.97 | 1.00 | 1.04 | 1.04 | 0.98 | 0.95 | 0.96 | 0.93 | 0.96 | 1.01 | 1.09 | 1.09 | 1.03 | 1.03 | 1.07 | — | — | — | — | — | — | — | — | ||||||||
Lowe’s Cos. Inc. | 1.57 | 1.60 | 1.51 | 1.34 | 1.26 | 1.20 | 1.05 | 1.01 | 0.98 | 0.95 | 0.87 | 0.86 | 0.94 | 0.92 | 0.90 | 0.89 | 0.87 | — | — | — | — | — | — | — | — | ||||||||
TJX Cos. Inc. | 0.67 | 0.67 | 0.69 | 0.70 | 0.69 | 0.68 | 0.67 | 0.67 | 0.71 | 0.73 | 0.74 | 0.77 | 0.78 | 0.66 | 0.67 | 0.68 | 0.69 | — | — | — | — | — | — | — | — |
Based on: 10-Q (reporting date: 2023-04-29), 10-K (reporting date: 2023-01-28), 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 Q1 2024 Calculation
Debt to capital (including operating lease liability) = Total debt (including operating lease liability) ÷ Total capital (including operating lease liability)
= 3,697,330 ÷ 4,536,716 = 0.81
2 Click competitor name to see calculations.
- Total Debt (including operating lease liability)
- The total debt level shows considerable fluctuations over the observed periods. Beginning at 556,273 thousand USD in April 2017, debt rose sharply to peak at over 1 million USD by mid-2017. After a period of relative stability around 850,000 to 960,000 thousand USD through early 2019, debt experienced a significant surge, more than doubling to over 2 million USD by May 2019. This elevated level persisted with minor decreases, followed by gradual declines from early 2020 into early 2021. Subsequently, debt held relatively steady between approximately 1.5 million and 1.7 million thousand USD until mid-2021, when it again increased substantially to reach over 3.4 million thousand USD by late 2021. The amount remained elevated with minor variations through the latest reported quarter, maintaining just under 3.7 million thousand USD.
- Total Capital (including operating lease liability)
- Total capital similarly exhibited fluctuations, starting near 1.18 million thousand USD in April 2017 and initially declining to approximately 850,000 to 990,000 thousand USD during late 2017 to early 2019. Capital then nearly doubled in mid-2019, reaching about 1.9 million thousand USD and continued a modest upward trend, peaking at roughly 2.5 million thousand USD by late 2021. At this point, a sharp increase occurred, with total capital surging to above 4.5 million thousand USD from late 2021 through mid-2023. The capital levels showed some volatility, but overall remained near this elevated plateau at the end of the period.
- Debt to Capital Ratio (including operating lease liability)
- The debt to capital ratio experienced marked variability throughout the period, beginning at 0.47 in early 2017. The ratio spiked above 1.0 several times between mid-2017 and early 2019, indicating debt levels exceeding capital during those quarters. After late 2019, the ratio generally trended downward, moving from near 1.0 to approximately 0.67 by late 2021, suggesting a relative decline in leverage. Despite this, the ratio rebounded to near 0.8 by early 2023. This pattern indicates phases of aggressive leverage followed by partial deleveraging, then renewed increases in debt relative to capital most recently.
- Overall Trends and Insights
- The data reveals a pattern of substantial financial volatility characterized by abrupt increases in both debt and capital, particularly around mid-2019 and again near late 2021. The sharp rises in total capital may reflect capital raises or asset growth, while corresponding surges in total debt suggest increased borrowing and financial leverage. Notably, the debt to capital ratio's exceedance of 1.0 during multiple quarters implies periods of very high financial risk, where debt obligations outpaced invested capital. The subsequent lowering of this ratio until 2021 indicates efforts at improving the capital structure, possibly through debt repayment or capital infusion. However, the most recent uptick in leverage points to a renewed reliance on debt financing. Overall, the data indicates a dynamic capital management approach in response to changing operational or strategic needs, with periods of elevated leverage that may warrant close monitoring from a risk perspective.
Debt to Assets
Apr 29, 2023 | Jan 28, 2023 | 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) | |||||||||||||||||||||||||||||||||
Convertible senior notes due 2024, net | —) | —) | —) | —) | —) | 3,600) | 56,365) | 66,503) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
Convertible senior notes due 2023, net | 1,694) | 1,696) | 1,702) | 1,704) | —) | 9,389) | 53,242) | 172,141) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
Convertible senior notes due 2020, net | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | 295,574) | 290,532) | 285,570) | 280,688) | —) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
Convertible senior notes due 2019, net | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | 347,918) | 343,789) | 339,707) | 335,670) | —) | —) | —) | —) | —) | ||||||||
Convertible senior notes repurchase obligation | —) | —) | —) | —) | 313,706) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
Asset based credit facility | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | 91,600) | 10,000) | —) | —) | 145,000) | —) | 57,500) | 107,500) | —) | 219,000) | 199,970) | 341,000) | 283,000) | —) | ||||||||
Term loan B, net | 1,932,356) | 1,936,529) | 1,940,701) | 1,944,870) | 1,949,038) | 1,953,203) | 1,957,366) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
Term loan B-2, net | 469,091) | 469,245) | 469,396) | 469,546) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
FILO term loan, net | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | 89,408) | 119,086) | 119,065) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
Second lien term loan, net | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | 197,262) | 197,140) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
Term loan, net | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | 79,528) | 79,499) | 79,471) | 176,363) | —) | ||||||||
Real estate loans | 17,905) | 17,909) | 17,912) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
Equipment promissory notes, net | —) | —) | —) | —) | —) | 1,129) | 1,625) | 2,115) | 3,739) | 14,614) | 20,363) | 26,047) | 28,475) | 31,053) | 36,613) | 42,113) | 40,208) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
Convertible senior notes due 2024, net | 41,751) | 41,724) | 41,696) | 41,668) | 80,388) | 184,461) | 181,805) | 223,547) | 285,721) | 281,454) | 277,247) | 273,100) | 269,012) | 264,982) | 261,010) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
Convertible senior notes due 2023, net | —) | —) | —) | —) | 19,658) | 59,002) | 62,214) | 93,867) | 288,136) | 282,956) | 280,536) | 275,837) | 271,211) | 266,658) | 262,177) | 257,766) | 253,424) | 249,151) | 244,944) | 240,804) | —) | —) | —) | —) | —) | ||||||||
Convertible senior notes due 2020, net | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | 275,884) | 271,157) | 266,506) | 261,929) | 257,425) | 252,994) | 248,633) | 244,342) | 240,120) | ||||||||
Convertible senior notes due 2019, net | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | 331,678) | 327,731) | 323,828) | 319,969) | 316,153) | ||||||||
Non-current finance lease liabilities | 648,792) | 653,050) | 656,643) | 661,001) | 594,728) | 560,550) | 549,098) | 523,797) | 501,118) | 485,481) | 488,660) | 492,136) | 439,470) | 442,988) | 431,379) | 433,591) | 436,228) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
Total debt | 3,111,589) | 3,120,153) | 3,128,050) | 3,118,789) | 2,957,518) | 2,771,334) | 2,861,715) | 1,081,970) | 1,078,714) | 1,064,505) | 1,066,806) | 1,158,720) | 1,313,742) | 1,296,213) | 1,366,157) | 1,475,506) | 1,669,867) | 921,597) | 958,657) | 838,403) | 887,631) | 860,194) | 992,932) | 1,023,674) | 556,273) | ||||||||
Total assets | 5,319,830) | 5,309,289) | 5,883,715) | 5,831,447) | 5,887,937) | 5,540,470) | 5,420,025) | 3,467,152) | 3,237,317) | 2,898,313) | 2,679,250) | 2,506,409) | 2,429,893) | 2,445,694) | 2,362,013) | 2,387,808) | 2,545,832) | 1,806,034) | 1,843,325) | 1,814,107) | 1,748,961) | 1,732,866) | 1,801,566) | 1,819,409) | 1,948,386) | ||||||||
Solvency Ratio | |||||||||||||||||||||||||||||||||
Debt to assets1 | 0.58 | 0.59 | 0.53 | 0.53 | 0.50 | 0.50 | 0.53 | 0.31 | 0.33 | 0.37 | 0.40 | 0.46 | 0.54 | 0.53 | 0.58 | 0.62 | 0.66 | 0.51 | 0.52 | 0.46 | 0.51 | 0.50 | 0.55 | 0.56 | 0.29 | ||||||||
Benchmarks | |||||||||||||||||||||||||||||||||
Debt to Assets, Competitors2 | |||||||||||||||||||||||||||||||||
Amazon.com Inc. | 0.15 | 0.15 | 0.16 | 0.17 | 0.18 | 0.19 | 0.19 | 0.19 | 0.17 | 0.18 | 0.20 | 0.21 | 0.19 | 0.19 | 0.22 | 0.24 | 0.23 | — | — | — | — | — | — | — | — | ||||||||
Home Depot Inc. | 0.55 | 0.57 | 0.56 | 0.54 | 0.54 | 0.56 | 0.54 | 0.51 | 0.49 | 0.53 | 0.53 | 0.55 | 0.61 | 0.61 | 0.56 | 0.55 | 0.55 | — | — | — | — | — | — | — | — | ||||||||
Lowe’s Cos. Inc. | 0.80 | 0.78 | 0.71 | 0.62 | 0.58 | 0.55 | 0.53 | 0.49 | 0.45 | 0.47 | 0.43 | 0.42 | 0.48 | 0.49 | 0.45 | 0.43 | 0.41 | — | — | — | — | — | — | — | — | ||||||||
TJX Cos. Inc. | 0.12 | 0.12 | 0.12 | 0.12 | 0.12 | 0.12 | 0.11 | 0.12 | 0.18 | 0.20 | 0.20 | 0.23 | 0.28 | 0.09 | 0.09 | 0.10 | 0.10 | — | — | — | — | — | — | — | — |
Based on: 10-Q (reporting date: 2023-04-29), 10-K (reporting date: 2023-01-28), 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 Q1 2024 Calculation
Debt to assets = Total debt ÷ Total assets
= 3,111,589 ÷ 5,319,830 = 0.58
2 Click competitor name to see calculations.
- Total debt
- The total debt shows considerable fluctuations over the periods analysed. Initially, there was a significant rise from around 556 million to over 1 billion in mid-2017, followed by a general decline reaching approximately 830 million by mid-2018. Afterwards, the trend alternates between increases and decreases, reaching a peak of approximately 2.9 billion in late 2021 before slightly stabilizing around 3.1 billion in early 2023.
- Total assets
- Total assets demonstrate a generally increasing trend throughout the periods. Starting just below 2 billion in early 2017, assets moderately declined and fluctuated slightly until early 2019. From that point onward, assets saw a progressive increase, peaking above 5.8 billion in late 2022, with a slight dip subsequently but remaining above 5.3 billion through April 2023.
- Debt to assets ratio
- The debt to assets ratio reflects varying leverage levels. Initially, the ratio rose sharply from 0.29 to above 0.5 in mid-2017, then fluctuated between 0.46 and 0.56 until early 2019. Post-2019, the ratio exhibits a decline to around 0.31 by late 2021, indicating reduced leverage relative to assets. However, from late 2021 to early 2023, the ratio increased again, stabilizing around 0.58 to 0.59, suggesting increased reliance on debt compared to total assets during this period.
- Overall analysis
- The data suggests a period of increasing asset accumulation coupled with periods of variable debt levels, leading to fluctuations in leverage as measured by the debt to assets ratio. The initial years show aggressive debt increase followed by consolidation, whereas recent periods indicate both significant asset growth and a higher proportion of debt financing, possibly reflecting strategic financial adjustments or market conditions influencing capital structure decisions.
Debt to Assets (including Operating Lease Liability)
Apr 29, 2023 | Jan 28, 2023 | 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) | |||||||||||||||||||||||||||||||||
Convertible senior notes due 2024, net | —) | —) | —) | —) | —) | 3,600) | 56,365) | 66,503) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
Convertible senior notes due 2023, net | 1,694) | 1,696) | 1,702) | 1,704) | —) | 9,389) | 53,242) | 172,141) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
Convertible senior notes due 2020, net | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | 295,574) | 290,532) | 285,570) | 280,688) | —) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
Convertible senior notes due 2019, net | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | 347,918) | 343,789) | 339,707) | 335,670) | —) | —) | —) | —) | —) | ||||||||
Convertible senior notes repurchase obligation | —) | —) | —) | —) | 313,706) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
Asset based credit facility | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | 91,600) | 10,000) | —) | —) | 145,000) | —) | 57,500) | 107,500) | —) | 219,000) | 199,970) | 341,000) | 283,000) | —) | ||||||||
Term loan B, net | 1,932,356) | 1,936,529) | 1,940,701) | 1,944,870) | 1,949,038) | 1,953,203) | 1,957,366) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
Term loan B-2, net | 469,091) | 469,245) | 469,396) | 469,546) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
FILO term loan, net | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | 89,408) | 119,086) | 119,065) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
Second lien term loan, net | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | 197,262) | 197,140) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
Term loan, net | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | 79,528) | 79,499) | 79,471) | 176,363) | —) | ||||||||
Real estate loans | 17,905) | 17,909) | 17,912) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
Equipment promissory notes, net | —) | —) | —) | —) | —) | 1,129) | 1,625) | 2,115) | 3,739) | 14,614) | 20,363) | 26,047) | 28,475) | 31,053) | 36,613) | 42,113) | 40,208) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
Convertible senior notes due 2024, net | 41,751) | 41,724) | 41,696) | 41,668) | 80,388) | 184,461) | 181,805) | 223,547) | 285,721) | 281,454) | 277,247) | 273,100) | 269,012) | 264,982) | 261,010) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
Convertible senior notes due 2023, net | —) | —) | —) | —) | 19,658) | 59,002) | 62,214) | 93,867) | 288,136) | 282,956) | 280,536) | 275,837) | 271,211) | 266,658) | 262,177) | 257,766) | 253,424) | 249,151) | 244,944) | 240,804) | —) | —) | —) | —) | —) | ||||||||
Convertible senior notes due 2020, net | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | 275,884) | 271,157) | 266,506) | 261,929) | 257,425) | 252,994) | 248,633) | 244,342) | 240,120) | ||||||||
Convertible senior notes due 2019, net | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | —) | 331,678) | 327,731) | 323,828) | 319,969) | 316,153) | ||||||||
Non-current finance lease liabilities | 648,792) | 653,050) | 656,643) | 661,001) | 594,728) | 560,550) | 549,098) | 523,797) | 501,118) | 485,481) | 488,660) | 492,136) | 439,470) | 442,988) | 431,379) | 433,591) | 436,228) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
Total debt | 3,111,589) | 3,120,153) | 3,128,050) | 3,118,789) | 2,957,518) | 2,771,334) | 2,861,715) | 1,081,970) | 1,078,714) | 1,064,505) | 1,066,806) | 1,158,720) | 1,313,742) | 1,296,213) | 1,366,157) | 1,475,506) | 1,669,867) | 921,597) | 958,657) | 838,403) | 887,631) | 860,194) | 992,932) | 1,023,674) | 556,273) | ||||||||
Current operating lease liabilities | 81,262) | 80,384) | 77,858) | 75,289) | 74,309) | 73,834) | 74,706) | 74,074) | 72,442) | 71,524) | 64,879) | 63,866) | 61,997) | 58,924) | 55,753) | 57,162) | 56,601) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
Non-current operating lease liabilities | 504,479) | 505,809) | 521,093) | 527,445) | 533,074) | 540,513) | 538,886) | 542,510) | 532,142) | 448,169) | 405,432) | 406,012) | 395,641) | 409,930) | 412,247) | 415,803) | 427,961) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||||
Total debt (including operating lease liability) | 3,697,330) | 3,706,346) | 3,727,001) | 3,721,523) | 3,564,901) | 3,385,681) | 3,475,307) | 1,698,554) | 1,683,298) | 1,584,198) | 1,537,117) | 1,628,598) | 1,771,380) | 1,765,067) | 1,834,157) | 1,948,471) | 2,154,429) | 921,597) | 958,657) | 838,403) | 887,631) | 860,194) | 992,932) | 1,023,674) | 556,273) | ||||||||
Total assets | 5,319,830) | 5,309,289) | 5,883,715) | 5,831,447) | 5,887,937) | 5,540,470) | 5,420,025) | 3,467,152) | 3,237,317) | 2,898,313) | 2,679,250) | 2,506,409) | 2,429,893) | 2,445,694) | 2,362,013) | 2,387,808) | 2,545,832) | 1,806,034) | 1,843,325) | 1,814,107) | 1,748,961) | 1,732,866) | 1,801,566) | 1,819,409) | 1,948,386) | ||||||||
Solvency Ratio | |||||||||||||||||||||||||||||||||
Debt to assets (including operating lease liability)1 | 0.70 | 0.70 | 0.63 | 0.64 | 0.61 | 0.61 | 0.64 | 0.49 | 0.52 | 0.55 | 0.57 | 0.65 | 0.73 | 0.72 | 0.78 | 0.82 | 0.85 | 0.51 | 0.52 | 0.46 | 0.51 | 0.50 | 0.55 | 0.56 | 0.29 | ||||||||
Benchmarks | |||||||||||||||||||||||||||||||||
Debt to Assets (including Operating Lease Liability), Competitors2 | |||||||||||||||||||||||||||||||||
Amazon.com Inc. | 0.29 | 0.29 | 0.32 | 0.32 | 0.33 | 0.33 | 0.34 | 0.34 | 0.32 | 0.31 | 0.34 | 0.34 | 0.31 | 0.31 | 0.34 | 0.35 | 0.35 | — | — | — | — | — | — | — | — | ||||||||
Home Depot Inc. | 0.65 | 0.66 | 0.65 | 0.62 | 0.62 | 0.64 | 0.62 | 0.60 | 0.58 | 0.62 | 0.61 | 0.64 | 0.71 | 0.73 | 0.67 | 0.66 | 0.66 | — | — | — | — | — | — | — | — | ||||||||
Lowe’s Cos. Inc. | 0.88 | 0.87 | 0.81 | 0.72 | 0.68 | 0.66 | 0.63 | 0.58 | 0.54 | 0.56 | 0.52 | 0.51 | 0.57 | 0.60 | 0.56 | 0.54 | 0.51 | — | — | — | — | — | — | — | — | ||||||||
TJX Cos. Inc. | 0.45 | 0.45 | 0.44 | 0.47 | 0.46 | 0.44 | 0.43 | 0.45 | 0.49 | 0.50 | 0.50 | 0.59 | 0.65 | 0.47 | 0.47 | 0.50 | 0.50 | — | — | — | — | — | — | — | — |
Based on: 10-Q (reporting date: 2023-04-29), 10-K (reporting date: 2023-01-28), 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 Q1 2024 Calculation
Debt to assets (including operating lease liability) = Total debt (including operating lease liability) ÷ Total assets
= 3,697,330 ÷ 5,319,830 = 0.70
2 Click competitor name to see calculations.
- Total debt (including operating lease liability)
- The total debt exhibited significant fluctuations throughout the analyzed periods. Initially, there was a sharp increase from approximately $556 million in April 2017 to over $1 billion by July 2017. This peak was followed by a gradual decline until early 2019, with debt levels fluctuating around $840 million to $960 million. A marked increase occurred in May 2019, reaching a peak of approximately $2.15 billion, sustained at elevated levels through late 2019 and early 2020. Subsequently, debt levels showed a moderate decline and some volatility, ranging between $1.53 billion and $1.7 billion until mid-2021. Another significant rise was apparent from October 2021 onward, with debt increasing sharply to over $3.6 billion by 2022, before stabilizing near $3.7 billion towards the most recent period.
- Total assets
- Total assets displayed a generally increasing trend across the timeline, despite some short-term fluctuations. Starting at roughly $1.95 billion in April 2017, asset values experienced a slight dip and oscillations through 2018 and early 2019. From May 2019, assets grew substantially, reaching in excess of $2.5 billion, and continued rising steadily, surpassing $3 billion by mid-2021. A pronounced increase occurred during late 2021 and early 2022, with total assets peaking at above $5.5 billion in 2022. However, this growth was followed by a moderate decrease, with assets lowering to around $5.3 billion in the most recent period analyzed.
- Debt to assets ratio (including operating lease liability)
- The debt to assets ratio mirrored the volatility observed in the total debt figures, indicating changes in financial leverage. Initially, the ratio rose sharply from 0.29 to 0.56 between April and July 2017, followed by a gradual decrease to approximately 0.46 in mid-2018. The ratio then increased again to around 0.52 by late 2018. A notable surge occurred in May 2019, with the ratio peaking at 0.85, implying significantly higher leverage during this period. Subsequently, leverage decreased progressively, falling to 0.49 by late 2021. A subsequent upward trend was observed beginning in late 2021, with the ratio rising to about 0.7 by early 2023, suggesting an increase in debt relative to assets during this timeframe.
Financial Leverage
Apr 29, 2023 | Jan 28, 2023 | 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 | 5,319,830) | 5,309,289) | 5,883,715) | 5,831,447) | 5,887,937) | 5,540,470) | 5,420,025) | 3,467,152) | 3,237,317) | 2,898,313) | 2,679,250) | 2,506,409) | 2,429,893) | 2,445,694) | 2,362,013) | 2,387,808) | 2,545,832) | 1,806,034) | 1,843,325) | 1,814,107) | 1,748,961) | 1,732,866) | 1,801,566) | 1,819,409) | 1,948,386) | ||||||||
Stockholders’ equity (deficit) | 839,386) | 784,661) | 1,293,947) | 1,220,244) | 1,341,790) | 1,170,277) | 1,021,375) | 836,858) | 594,462) | 447,026) | 296,869) | 128,491) | 19,132) | 18,651) | (63,220) | (177,918) | (247,373) | (22,962) | 32,020) | 146,061) | 8,642) | (7,336) | (25,276) | (46,784) | 622,778) | ||||||||
Solvency Ratio | |||||||||||||||||||||||||||||||||
Financial leverage1 | 6.34 | 6.77 | 4.55 | 4.78 | 4.39 | 4.73 | 5.31 | 4.14 | 5.45 | 6.48 | 9.03 | 19.51 | 127.01 | 131.13 | — | — | — | — | 57.57 | 12.42 | 202.38 | — | — | — | 3.13 | ||||||||
Benchmarks | |||||||||||||||||||||||||||||||||
Financial Leverage, Competitors2 | |||||||||||||||||||||||||||||||||
Amazon.com Inc. | 2.45 | 2.61 | 2.66 | 2.83 | 3.01 | 3.17 | 3.12 | 3.19 | 3.07 | 3.04 | 3.17 | 3.14 | 3.13 | 3.44 | 3.41 | 3.50 | 3.39 | — | — | — | — | — | — | — | — | ||||||||
Home Depot Inc. | 211.01 | 48.94 | 59.22 | 319.94 | — | — | 70.56 | 34.20 | 41.51 | 21.39 | 43.60 | — | — | — | — | — | — | — | — | — | — | — | — | — | — | ||||||||
Lowe’s Cos. Inc. | — | — | — | — | — | — | — | — | 115.06 | 32.52 | 12.49 | 11.88 | 26.71 | 20.02 | 16.18 | 15.41 | 13.36 | — | — | — | — | — | — | — | — | ||||||||
TJX Cos. Inc. | 4.47 | 4.45 | 5.02 | 5.02 | 4.95 | 4.74 | 4.67 | 4.49 | 4.94 | 5.28 | 5.67 | 5.70 | 5.36 | 4.06 | 4.38 | 4.31 | 4.38 | — | — | — | — | — | — | — | — |
Based on: 10-Q (reporting date: 2023-04-29), 10-K (reporting date: 2023-01-28), 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 Q1 2024 Calculation
Financial leverage = Total assets ÷ Stockholders’ equity (deficit)
= 5,319,830 ÷ 839,386 = 6.34
2 Click competitor name to see calculations.
The analysis of the quarterly financial data reveals several notable trends in total assets, stockholders’ equity, and financial leverage over the period under review.
- Total Assets
- Total assets exhibited a generally increasing trend across the periods. Starting at approximately 1.95 billion USD in April 2017, total assets showed some fluctuations during 2017 and early 2018, remaining relatively stable around 1.7 to 1.8 billion USD. A substantial increase began in the period ending May 2019, where total assets rose sharply from around 1.8 billion USD to exceed 5.4 billion USD by October 2021. Following this peak, total assets experienced slight variations but generally sustained a high level, stabilizing around the 5.3 billion USD mark in the most recent quarters. This upward trend indicates significant asset growth over the timeframe, particularly from 2019 onward.
- Stockholders’ Equity (Deficit)
- Stockholders’ equity demonstrated considerable volatility and shifts between deficit and positive values. Initially, equity was robust at approximately 623 million USD in April 2017. However, it rapidly declined thereafter, dipping into negative territory in mid to late 2017 and early 2018, reaching deficits as large as -247 million USD in May 2019. From the second half of 2019, equity steadily recovered, turning positive by February 2020 and increasing substantially over subsequent quarters. By October 2021, equity reached over 1 billion USD, indicating a strong recovery and significant capitalization improvements. Nonetheless, a notable decline occurred after January 2022, with equity decreasing to around 784 million USD by April 2023, suggesting some erosion in stockholders’ equity in the most recent periods.
- Financial Leverage
- Financial leverage ratios displayed extreme fluctuations initially and then settled into a more stable pattern. Early data shows unusually high and erratic leverage ratios, including values exceeding 200. This likely reflects the impact of negative or very low equity figures during those quarters, causing leverage to spike dramatically. Starting from approximately mid-2019, leverage ratios normalized and trended downward, indicating reduced reliance on debt relative to equity. The ratios moved from elevated levels (around 127) down to a range between 4 and 7 in the later periods. This trend aligns with the equity recovery and asset growth previously noted, suggesting an improved capital structure and risk profile in recent quarters.
In summary, the company experienced significant asset growth accompanied initially by equity volatility and high financial leverage. Over time, equity recovered strongly, leading to normalized leverage levels. The latter periods show a stable and strengthened financial position, although a slight recent decline in equity warrants monitoring.