Stock Analysis on Net

Dollar Tree Inc. (NASDAQ:DLTR)

$22.49

This company has been moved to the archive! The financial data has not been updated since November 22, 2022.

Analysis of Debt

Microsoft Excel

Total Debt (Carrying Amount)

Dollar Tree Inc., balance sheet: debt

US$ in thousands

Microsoft Excel
Jan 29, 2022 Jan 30, 2021 Feb 1, 2020 Feb 2, 2019 Feb 3, 2018 Jan 28, 2017
Current portion of long-term debt
Long-term debt, net, excluding current portion
Total long-term debt (carrying amount)

Based on: 10-K (reporting date: 2022-01-29), 10-K (reporting date: 2021-01-30), 10-K (reporting date: 2020-02-01), 10-K (reporting date: 2019-02-02), 10-K (reporting date: 2018-02-03), 10-K (reporting date: 2017-01-28).

Debt item Description The company
Total long-term debt (carrying amount) Sum of the carrying values as of the balance sheet date of all debt plus capital lease obligations. Dollar Tree Inc. total debt decreased from 2020 to 2021 but then slightly increased from 2021 to 2022.

Total Debt (Fair Value)

Microsoft Excel
Jan 29, 2022
Selected Financial Data (US$ in thousands)
Senior Notes
Revolving Credit Facility
Term Loans
Forgivable Promissory Note
Total long-term debt (fair value)
Financial Ratio
Debt, fair value to carrying amount ratio

Based on: 10-K (reporting date: 2022-01-29).


Weighted-average Interest Rate on Debt

Weighted-average interest rate on long-term debt:

Interest rate Debt amount1 Interest rate × Debt amount Weighted-average interest rate2
Total

Based on: 10-K (reporting date: 2022-01-29).

1 US$ in thousands

2 Weighted-average interest rate = 100 × ÷ =


Interest Costs Incurred

Dollar Tree Inc., interest costs incurred

US$ in thousands

Microsoft Excel
12 months ended: Jan 29, 2022 Jan 30, 2021 Feb 1, 2020 Feb 2, 2019 Feb 3, 2018 Jan 28, 2017
Interest expense, net
Capitalized interest
Interest costs incurred

Based on: 10-K (reporting date: 2022-01-29), 10-K (reporting date: 2021-01-30), 10-K (reporting date: 2020-02-01), 10-K (reporting date: 2019-02-02), 10-K (reporting date: 2018-02-03), 10-K (reporting date: 2017-01-28).

Debt item Description The company
Interest expense, net Amount of the cost of borrowed funds accounted for as interest expense for debt. Dollar Tree Inc. interest expense, net decreased from 2020 to 2021 but then increased from 2021 to 2022 exceeding 2020 level.
Capitalized interest Amount of interest costs capitalized disclosed as an adjusting item to interest costs incurred. Dollar Tree Inc. capitalized interest increased from 2020 to 2021 but then decreased significantly from 2021 to 2022.
Interest costs incurred Total interest costs incurred during the period and either capitalized or charged against earnings. Dollar Tree Inc. interest costs incurred decreased from 2020 to 2021 but then increased from 2021 to 2022 exceeding 2020 level.

Adjusted Interest Coverage Ratio

Microsoft Excel
Jan 29, 2022 Jan 30, 2021 Feb 1, 2020 Feb 2, 2019 Feb 3, 2018 Jan 28, 2017
Selected Financial Data (US$ in thousands)
Net income (loss)
Add: Income tax expense
Add: Interest expense, net
Earnings before interest and tax (EBIT)
 
Interest costs incurred
Financial Ratio With and Without Capitalized Interest
Interest coverage ratio (without capitalized interest)1
Adjusted interest coverage ratio (with capitalized interest)2

Based on: 10-K (reporting date: 2022-01-29), 10-K (reporting date: 2021-01-30), 10-K (reporting date: 2020-02-01), 10-K (reporting date: 2019-02-02), 10-K (reporting date: 2018-02-03), 10-K (reporting date: 2017-01-28).

2022 Calculations

1 Interest coverage ratio (without capitalized interest) = EBIT ÷ Interest expense, net
= ÷ =

2 Adjusted interest coverage ratio (with capitalized interest) = EBIT ÷ Interest costs incurred
= ÷ =


Solvency ratio Description The company
Adjusted interest coverage ratio A solvency ratio calculated as EBIT divided by interest payments (including capitalized interest). Dollar Tree Inc. adjusted interest coverage ratio improved from 2020 to 2021 but then slightly deteriorated from 2021 to 2022 not reaching 2020 level.