Dollar Tree, Inc. (DLTR) DCF Valuation
- ✓ Completamente Editable: Adáptelo A Sus Necesidades En Excel O Sheets
- ✓ Diseño Profesional: Plantillas Confiables Y Estándares De La Industria
- ✓ Predeterminadas Para Un Uso Rápido Y Eficiente
- ✓ No Se Necesita Experiencia; Fáciles De Seguir
Dollar Tree, Inc. (DLTR) Bundle
Looking to estimate the intrinsic value of Dollar Tree, Inc.? Our (DLTR) DCF Calculator integrates real-world data with comprehensive customization options, enabling you to refine your forecasts and enhance your investment decisions.
Discounted Cash Flow (DCF) - (USD MM)
| Year | AY1 2019 |
AY2 2020 |
AY3 2021 |
AY4 2022 |
AY5 2023 |
FY1 2024 |
FY2 2025 |
FY3 2026 |
FY4 2027 |
FY5 2028 |
|---|---|---|---|---|---|---|---|---|---|---|
| Revenue | 23,610.8 | 25,509.3 | 26,321.2 | 28,331.7 | 30,603.8 | 32,660.5 | 34,855.4 | 37,197.8 | 39,697.7 | 42,365.5 |
| Revenue Growth, % | 0 | 8.04 | 3.18 | 7.64 | 8.02 | 6.72 | 6.72 | 6.72 | 6.72 | 6.72 |
| EBITDA | 1,895.6 | 2,566.3 | 2,521.6 | 3,003.2 | -40.9 | 2,491.0 | 2,658.4 | 2,837.1 | 3,027.8 | 3,231.2 |
| EBITDA, % | 8.03 | 10.06 | 9.58 | 10.6 | -0.13364 | 7.63 | 7.63 | 7.63 | 7.63 | 7.63 |
| Depreciation | 634.8 | 679.2 | 710.5 | 767.3 | 841.0 | 882.3 | 941.6 | 1,004.8 | 1,072.4 | 1,144.4 |
| Depreciation, % | 2.69 | 2.66 | 2.7 | 2.71 | 2.75 | 2.7 | 2.7 | 2.7 | 2.7 | 2.7 |
| EBIT | 1,260.8 | 1,887.1 | 1,811.1 | 2,235.9 | -881.9 | 1,608.8 | 1,716.9 | 1,832.3 | 1,955.4 | 2,086.8 |
| EBIT, % | 5.34 | 7.4 | 6.88 | 7.89 | -2.88 | 4.93 | 4.93 | 4.93 | 4.93 | 4.93 |
| Total Cash | 539.2 | 1,416.7 | 984.9 | 642.8 | 684.9 | 1,050.8 | 1,121.4 | 1,196.7 | 1,277.2 | 1,363.0 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 113.3 | .0 | .0 | .0 | .0 | 31.3 | 33.5 | 35.7 | 38.1 | 40.7 |
| Account Receivables, % | 0.47987 | 0 | 0 | 0 | 0 | 0.09597303 | 0.09597303 | 0.09597303 | 0.09597303 | 0.09597303 |
| Inventories | 3,522.0 | 3,427.0 | 4,367.3 | 5,449.3 | 5,112.8 | 5,283.4 | 5,638.5 | 6,017.4 | 6,421.8 | 6,853.4 |
| Inventories, % | 14.92 | 13.43 | 16.59 | 19.23 | 16.71 | 16.18 | 16.18 | 16.18 | 16.18 | 16.18 |
| Accounts Payable | 1,336.5 | 1,480.5 | 1,884.2 | 1,899.8 | 2,063.8 | 2,095.0 | 2,235.8 | 2,386.0 | 2,546.4 | 2,717.5 |
| Accounts Payable, % | 5.66 | 5.8 | 7.16 | 6.71 | 6.74 | 6.41 | 6.41 | 6.41 | 6.41 | 6.41 |
| Capital Expenditure | -1,036.7 | -898.8 | -1,022.8 | -1,253.8 | -2,107.6 | -1,509.7 | -1,611.2 | -1,719.4 | -1,835.0 | -1,958.3 |
| Capital Expenditure, % | -4.39 | -3.52 | -3.89 | -4.43 | -6.89 | -4.62 | -4.62 | -4.62 | -4.62 | -4.62 |
| Tax Rate, % | -0.98109 | -0.98109 | -0.98109 | -0.98109 | -0.98109 | -0.98109 | -0.98109 | -0.98109 | -0.98109 | -0.98109 |
| EBITAT | 949.0 | 1,455.5 | 1,473.4 | 1,711.3 | -890.6 | 1,320.1 | 1,408.9 | 1,503.5 | 1,604.6 | 1,712.4 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -1,751.7 | 1,588.2 | 624.5 | 158.4 | -1,656.7 | 521.9 | 522.9 | 558.0 | 595.5 | 635.5 |
| WACC, % | 6.57 | 6.6 | 6.67 | 6.59 | 6.99 | 6.69 | 6.69 | 6.69 | 6.69 | 6.69 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 2,327.6 | |||||||||
| Long Term Growth Rate, % | 3.00 | |||||||||
| Free cash flow (T + 1) | 655 | |||||||||
| Terminal Value | 17,760 | |||||||||
| Present Terminal Value | 12,850 | |||||||||
| Enterprise Value | 15,178 | |||||||||
| Net Debt | 9,702 | |||||||||
| Equity Value | 5,476 | |||||||||
| Diluted Shares Outstanding, MM | 220 | |||||||||
| Equity Value Per Share | 24.95 |
What You Will Receive
- Adjustable Forecast Inputs: Effortlessly modify assumptions (growth %, margins, WACC) to explore various scenarios.
- Comprehensive Data: Dollar Tree, Inc.'s (DLTR) financial data pre-loaded to facilitate your analysis.
- Instant DCF Calculations: The template computes Net Present Value (NPV) and intrinsic value automatically.
- Tailored and Professional: A sleek Excel model that caters to your valuation requirements.
- Designed for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and enhancing efficiency.
Key Features
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for Dollar Tree, Inc. (DLTR).
- WACC Calculator: Pre-configured Weighted Average Cost of Capital sheet with adjustable inputs for accurate assessments.
- Customizable Forecast Assumptions: Easily adjust growth rates, capital expenditures, and discount rates to fit your analysis.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specific to Dollar Tree, Inc. (DLTR).
- Interactive Dashboard and Charts: Visual representations that summarize essential valuation metrics for straightforward analysis.
How It Works
- Download the Template: Gain immediate access to the Excel-based DLTR DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and more.
- Instant Calculations: The model automatically updates Dollar Tree’s intrinsic value.
- Test Scenarios: Experiment with different assumptions to assess potential valuation changes.
- Analyze and Decide: Utilize the results to inform your investment or financial analysis.
Why Choose This Calculator for Dollar Tree, Inc. (DLTR)?
- Comprehensive Tool: Features DCF, WACC, and financial ratio analyses, all in one convenient package.
- Customizable Inputs: Modify the yellow-highlighted cells to explore different financial scenarios.
- Detailed Insights: Automatically computes Dollar Tree’s intrinsic value and Net Present Value.
- Preloaded Data: Historical and projected data provide accurate starting points for analysis.
- Professional Quality: Perfect for financial analysts, investors, and business consultants focused on Dollar Tree, Inc. (DLTR).
Who Should Use Dollar Tree, Inc. (DLTR)?
- Retail Investors: Make informed investment choices with insights into Dollar Tree's market performance.
- Market Analysts: Streamline your analysis with comprehensive data on Dollar Tree's financial health.
- Consultants: Efficiently tailor reports and presentations focused on Dollar Tree's business strategies.
- Value Shoppers: Enhance your understanding of discount retail strategies and their impact on consumer behavior.
- Students and Educators: Utilize as a case study in retail management and business courses.
What the Template Contains
- Historical Data: Includes Dollar Tree’s past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Dollar Tree’s intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
- Quarterly and Annual Statements: A complete breakdown of Dollar Tree’s financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.