Duluth Holdings Inc. (DLTH) DCF Valuation
- ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
- ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
- ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
- ✓ Aucune Expertise N'Est Requise; Facile À Suivre
Duluth Holdings Inc. (DLTH) Bundle
Explore the financial outlook of Duluth Holdings Inc. (DLTH) with our user-friendly DCF Calculator! Enter your projections for growth, margins, and expenses to determine the intrinsic value of Duluth Holdings Inc. (DLTH) and enhance your investment strategy.
Discounted Cash Flow (DCF) - (USD MM)
Year | AY1 2020 |
AY2 2021 |
AY3 2022 |
AY4 2023 |
AY5 2024 |
FY1 2025 |
FY2 2026 |
FY3 2027 |
FY4 2028 |
FY5 2029 |
---|---|---|---|---|---|---|---|---|---|---|
Revenue | 615.6 | 638.8 | 698.6 | 653.3 | 646.7 | 655.8 | 665.0 | 674.4 | 683.9 | 693.5 |
Revenue Growth, % | 0 | 3.76 | 9.36 | -6.48 | -1.01 | 1.41 | 1.41 | 1.41 | 1.41 | 1.41 |
EBITDA | 51.9 | 52.8 | 73.4 | 37.4 | 24.2 | 48.1 | 48.8 | 49.5 | 50.2 | 50.9 |
EBITDA, % | 8.44 | 8.27 | 10.5 | 5.73 | 3.75 | 7.34 | 7.34 | 7.34 | 7.34 | 7.34 |
Depreciation | 23.5 | 28.5 | 29.2 | 30.8 | 32.2 | 29.1 | 29.5 | 29.9 | 30.3 | 30.7 |
Depreciation, % | 3.82 | 4.46 | 4.18 | 4.72 | 4.97 | 4.43 | 4.43 | 4.43 | 4.43 | 4.43 |
EBIT | 28.4 | 24.3 | 44.2 | 6.6 | -7.9 | 19.0 | 19.3 | 19.6 | 19.9 | 20.1 |
EBIT, % | 4.61 | 3.8 | 6.32 | 1.01 | -1.22 | 2.9 | 2.9 | 2.9 | 2.9 | 2.9 |
Total Cash | .5 | 47.2 | 77.1 | 45.5 | 32.2 | 39.9 | 40.5 | 41.1 | 41.7 | 42.2 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 5.1 | 2.8 | 5.5 | 6.0 | 8.7 | 5.7 | 5.7 | 5.8 | 5.9 | 6.0 |
Account Receivables, % | 0.82079 | 0.44146 | 0.78087 | 0.92468 | 1.35 | 0.86365 | 0.86365 | 0.86365 | 0.86365 | 0.86365 |
Inventories | 147.8 | 149.1 | 122.7 | 154.9 | 125.8 | 141.7 | 143.7 | 145.8 | 147.8 | 149.9 |
Inventories, % | 24.02 | 23.33 | 17.56 | 23.71 | 19.45 | 21.61 | 21.61 | 21.61 | 21.61 | 21.61 |
Accounts Payable | 29.6 | 33.6 | 45.4 | 56.5 | 51.1 | 43.5 | 44.1 | 44.7 | 45.3 | 46.0 |
Accounts Payable, % | 4.81 | 5.27 | 6.5 | 8.66 | 7.91 | 6.63 | 6.63 | 6.63 | 6.63 | 6.63 |
Capital Expenditure | -30.8 | -12.3 | -10.4 | -22.8 | -49.1 | -25.6 | -25.9 | -26.3 | -26.7 | -27.0 |
Capital Expenditure, % | -5 | -1.92 | -1.48 | -3.49 | -7.59 | -3.9 | -3.9 | -3.9 | -3.9 | -3.9 |
Tax Rate, % | 22.46 | 22.46 | 22.46 | 22.46 | 22.46 | 22.46 | 22.46 | 22.46 | 22.46 | 22.46 |
EBITAT | 22.5 | 18.3 | 33.3 | 5.2 | -6.1 | 14.7 | 14.9 | 15.1 | 15.3 | 15.5 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -108.1 | 39.6 | 87.6 | -8.6 | -2.0 | -2.4 | 17.0 | 17.2 | 17.5 | 17.7 |
WACC, % | 6.05 | 5.94 | 5.94 | 6.02 | 6.01 | 5.99 | 5.99 | 5.99 | 5.99 | 5.99 |
PV UFCF | ||||||||||
SUM PV UFCF | 54.4 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 18 | |||||||||
Terminal Value | 452 | |||||||||
Present Terminal Value | 338 | |||||||||
Enterprise Value | 393 | |||||||||
Net Debt | 154 | |||||||||
Equity Value | 239 | |||||||||
Diluted Shares Outstanding, MM | 33 | |||||||||
Equity Value Per Share | 7.24 |
What You Will Get
- Real DLTH Financial Data: Pre-filled with Duluth Holdings Inc.’s historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See Duluth Holdings Inc.’s intrinsic value update instantly based on your changes.
- Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
- User-Friendly Design: Simple structure and clear instructions for all experience levels.
Key Features
- Customizable Financial Metrics: Adjust essential parameters such as sales growth, operating margin, and capital investments.
- Instant DCF Valuation: Quickly computes intrinsic value, NPV, and additional financial metrics.
- High-Precision Accuracy: Leverages Duluth Holdings Inc.'s (DLTH) actual financial data for dependable valuation results.
- Effortless Scenario Analysis: Explore various assumptions and evaluate results with ease.
- Efficiency Booster: Avoid the hassle of constructing intricate valuation models from the ground up.
How It Works
- Step 1: Download the prebuilt Excel template with Duluth Holdings Inc.'s (DLTH) data included.
- Step 2: Explore the pre-filled sheets and understand the key metrics.
- Step 3: Update forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly view recalculated results, including Duluth Holdings Inc.'s (DLTH) intrinsic value.
- Step 5: Make informed investment decisions or generate reports using the outputs.
Why Choose This Calculator for Duluth Holdings Inc. (DLTH)?
- Designed for Experts: A sophisticated tool tailored for analysts, CFOs, and financial consultants.
- Accurate Financials: Duluth Holdings’ historical and projected financial data preloaded for precision.
- Flexible Forecasting: Effortlessly simulate various scenarios and assumptions.
- Insightful Results: Automatically computes intrinsic value, NPV, and essential financial metrics.
- User-Friendly: Step-by-step guidance ensures a smooth experience throughout the process.
Who Should Use Duluth Holdings Inc. (DLTH)?
- Retail Investors: Gain insights into the apparel market with a trusted brand known for quality and durability.
- Market Analysts: Utilize data-driven insights to assess performance and market trends in the retail sector.
- Brand Consultants: Tailor strategies using Duluth's unique selling propositions for client projects.
- Outdoor Enthusiasts: Explore a wide range of functional clothing designed for comfort and utility.
- Students and Educators: Incorporate real-world case studies of retail strategies into business and marketing curricula.
What the Template Contains
- Comprehensive DCF Model: Editable template featuring detailed valuation calculations tailored for Duluth Holdings Inc. (DLTH).
- Real-World Data: Duluth Holdings’ historical and projected financials preloaded for thorough analysis.
- Customizable Parameters: Modify WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights.
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage metrics.
- Dashboard with Visual Outputs: Visualizations including charts and tables for clear, actionable results.