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.

Enterprise Value to FCFF (EV/FCFF)

Microsoft Excel

Paying user area

The data is hidden behind: . Unhide it.

This is a one-time payment. There is no automatic renewal.


We accept:

Visa Mastercard American Express Maestro Discover JCB PayPal Google Pay
Visa Secure Mastercard Identity Check American Express SafeKey

Free Cash Flow to The Firm (FCFF)

Dollar Tree Inc., FCFF calculation

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
Net income (loss)
Net noncash charges
Changes in operating assets and liabilities
Net cash provided by operating activities
Cash paid for interest, net of amounts capitalized, net of tax1
Capitalized interest, net of tax2
Capital expenditures
Free cash flow to the firm (FCFF)

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).


The analysis of the financial data over the six-year period reveals notable fluctuations in cash flow metrics for the company.

Net cash provided by operating activities
This metric exhibits overall variability with a general upward trend until the fiscal year ending January 30, 2021, before declining significantly the following year. Starting at 1,673,300 thousand US dollars in early 2017, it decreased slightly to 1,510,200 thousand in early 2018. It then increased steadily to reach a peak of 2,716,300 thousand by early 2021, representing a substantial improvement in cash generated from core business operations during these years. However, in the subsequent period ending January 29, 2022, there is a marked reduction to 1,431,500 thousand, indicating a slowdown or increased operational challenges impacting cash inflows.
Free cash flow to the firm (FCFF)
This measure, reflecting cash available after capital expenditures, follows a somewhat inconsistent pattern. It started at 1,332,031 thousand US dollars in early 2017, then declined to 1,073,229 thousand the next year. Following this, it rose to 1,255,104 thousand in early 2019, but dropped notably to 964,968 thousand in early 2020, the lowest in the early years reported. A strong recovery is seen in early 2021, peaking at 1,937,853 thousand, even surpassing initial levels. Nonetheless, this positive momentum was not sustained, as the FCFF plunged significantly to 554,541 thousand in the most recent period, which suggests increased capital spending, reduced cash flow from operations, or both.

In summary, while the operating cash flow generally trended upward through 2021 before declining, the free cash flow reveals more volatility with steep decreases in certain years. The sharp declines in the latest fiscal year for both metrics could signal emerging financial pressures or strategic investment shifts that warrant further investigation. The strong performance in 2021 followed by the downturn highlights the need to analyze external factors or internal changes influencing cash flow generation and utilization.


Interest Paid, Net of Tax

Dollar Tree Inc., interest paid, net of tax calculation

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
Effective Income Tax Rate (EITR)
EITR1
Interest Paid, Net of Tax
Cash paid for interest, net of amounts capitalized, before tax
Less: Cash paid for interest, net of amounts capitalized, tax2
Cash paid for interest, net of amounts capitalized, net of tax
Interest Costs Capitalized, Net of Tax
Capitalized interest, before tax
Less: Capitalized interest, tax3
Capitalized interest, net of tax

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).

1 See details »

2 2022 Calculation
Cash paid for interest, net of amounts capitalized, tax = Cash paid for interest, net of amounts capitalized × EITR
= × =

3 2022 Calculation
Capitalized interest, tax = Capitalized interest × EITR
= × =


The analysis of the financial data reveals several notable trends across the covered periods.

Effective Income Tax Rate (EITR)
The effective income tax rate exhibited a decreasing trend over the six-year span. Starting at 32.6% in early 2017, the rate remained relatively stable in the next year at 32.4%. However, a significant decline occurred in 2019, dropping to 21%. Following that, there was a slight increase to 24.7% in 2020, then a gradual reduction again to 22.9% in 2021 and further down to 18.6% by early 2022. This pattern indicates a general effort or occurrence of reduced tax burdens or improved tax efficiencies over time.
Cash Paid for Interest, Net of Amounts Capitalized, Net of Tax (US$ in thousands)
This value showed notable fluctuations throughout the period. Beginning at approximately $221.8 million in 2017, the cash paid for interest decreased slightly to $193.7 million in 2018. However, in 2019 there was a substantial increase, reaching $302.9 million. Following this peak, the amount decreased significantly for two successive years, recording $128.2 million in 2020 and $117.9 million in 2021. In 2022, there was a modest rebound to $143.3 million. These changes may reflect varying financing costs, debt levels, or interest rate environments.
Capitalized Interest, Net of Tax (US$ in thousands)
Capitalized interest values were comparatively lower and more variable. The figure started at $1.6 million in 2017, slightly decreasing to $1.55 million in 2018. A marked increase to $3.3 million occurred in 2019, followed by declines in the next two years, registering $1.8 million in 2020 and $2.5 million in 2021. In 2022, capitalized interest substantially fell to $0.9 million, the lowest amount in the data set. This pattern suggests fluctuating levels of capital investment or capitalization policies over the period analyzed.

Enterprise Value to FCFF Ratio, Current

Dollar Tree Inc., current EV/FCFF calculation, comparison to benchmarks

Microsoft Excel
Selected Financial Data (US$ in thousands)
Enterprise value (EV)
Free cash flow to the firm (FCFF)
Valuation Ratio
EV/FCFF
Benchmarks
EV/FCFF, Competitors1
Costco Wholesale Corp.
Target Corp.
Walmart Inc.
EV/FCFF, Sector
Consumer Staples Distribution & Retail
EV/FCFF, Industry
Consumer Staples

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

1 Click competitor name to see calculations.

If the company EV/FCFF is lower then the EV/FCFF of benchmark then company is relatively undervalued.
Otherwise, if the company EV/FCFF is higher then the EV/FCFF of benchmark then company is relatively overvalued.


Enterprise Value to FCFF Ratio, Historical

Dollar Tree Inc., historical EV/FCFF calculation, comparison to benchmarks

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)
Enterprise value (EV)1
Free cash flow to the firm (FCFF)2
Valuation Ratio
EV/FCFF3
Benchmarks
EV/FCFF, Competitors4
Costco Wholesale Corp.
Target Corp.
Walmart Inc.
EV/FCFF, Sector
Consumer Staples Distribution & Retail
EV/FCFF, Industry
Consumer Staples

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).

1 See details »

2 See details »

3 2022 Calculation
EV/FCFF = EV ÷ FCFF
= ÷ =

4 Click competitor name to see calculations.


Enterprise Value (EV)
The enterprise value exhibited an overall upward trend from 2017 to 2022, increasing from approximately $23.54 billion in early 2017 to about $36.44 billion by early 2022. Notably, there was a decline in 2020, where the value dropped to $21.22 billion from $28.67 billion in 2019, followed by a recovery and significant growth in the subsequent years.
Free Cash Flow to the Firm (FCFF)
Free cash flow to the firm fluctuated over the period. Starting at around $1.33 billion in 2017, it saw a dip in 2018 to about $1.07 billion, then a modest increase in 2019 to $1.26 billion. However, it decreased again in 2020 to approximately $0.96 billion, followed by a peak in 2021 at $1.94 billion. This was succeeded by a sharp decline in 2022 to $0.55 billion, the lowest point in the observed timeframe.
EV/FCFF Ratio
The EV/FCFF ratio demonstrated notable volatility. It started at 17.67 in 2017, rose sharply to 25.44 in 2018, and slightly decreased to 22.84 in 2019. The ratio remained relatively stable in 2020 at 21.99, then dropped significantly to 14.07 in 2021, indicating improved valuation relative to free cash flow. However, there was an abrupt and substantial increase to 65.71 in 2022, suggesting a marked divergence between enterprise value and free cash flow, driven primarily by the significant reduction in free cash flow during that year.