Tile Shop Holdings, Inc. (TTSH) 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
Tile Shop Holdings, Inc. (TTSH) Bundle
Whether you’re an investor or an analyst, this (TTSH) DCF Calculator is your go-to resource for accurate valuation. Loaded with real data from Tile Shop Holdings, Inc., you can adjust forecasts and instantly observe the effects.
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 | 340.4 | 325.1 | 370.7 | 394.7 | 377.1 | 388.1 | 399.3 | 410.8 | 422.7 | 435.0 |
| Revenue Growth, % | 0 | -4.49 | 14.04 | 6.47 | -4.45 | 2.89 | 2.89 | 2.89 | 2.89 | 2.89 |
| EBITDA | 32.2 | 6.4 | 72.8 | 73.5 | 37.4 | 46.3 | 47.6 | 49.0 | 50.4 | 51.9 |
| EBITDA, % | 9.46 | 1.96 | 19.64 | 18.63 | 9.91 | 11.92 | 11.92 | 11.92 | 11.92 | 11.92 |
| Depreciation | 33.5 | 55.4 | 52.2 | 50.9 | 21.2 | 46.2 | 47.5 | 48.9 | 50.3 | 51.8 |
| Depreciation, % | 9.86 | 17.03 | 14.08 | 12.9 | 5.63 | 11.9 | 11.9 | 11.9 | 11.9 | 11.9 |
| EBIT | -1.3 | -49.0 | 20.6 | 22.6 | 16.2 | .1 | .1 | .1 | .1 | .1 |
| EBIT, % | -0.39518 | -15.07 | 5.56 | 5.73 | 4.28 | 0.02146165 | 0.02146165 | 0.02146165 | 0.02146165 | 0.02146165 |
| Total Cash | 9.1 | 9.6 | 9.4 | 5.9 | 8.6 | 9.3 | 9.5 | 9.8 | 10.1 | 10.4 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 6.5 | 11.1 | 10.1 | 7.3 | 3.0 | 8.3 | 8.5 | 8.8 | 9.0 | 9.3 |
| Account Receivables, % | 1.9 | 3.41 | 2.73 | 1.84 | 0.79836 | 2.14 | 2.14 | 2.14 | 2.14 | 2.14 |
| Inventories | 97.6 | 74.3 | 97.2 | 121.0 | 93.7 | 103.4 | 106.4 | 109.5 | 112.6 | 115.9 |
| Inventories, % | 28.68 | 22.86 | 26.21 | 30.64 | 24.84 | 26.65 | 26.65 | 26.65 | 26.65 | 26.65 |
| Accounts Payable | 18.2 | 15.4 | 30.9 | 23.5 | 23.3 | 23.7 | 24.4 | 25.1 | 25.8 | 26.6 |
| Accounts Payable, % | 5.34 | 4.73 | 8.33 | 5.96 | 6.19 | 6.11 | 6.11 | 6.11 | 6.11 | 6.11 |
| Capital Expenditure | -27.0 | -2.0 | -11.1 | -14.0 | -15.3 | -14.9 | -15.3 | -15.7 | -16.2 | -16.6 |
| Capital Expenditure, % | -7.93 | -0.60543 | -2.99 | -3.55 | -4.06 | -3.83 | -3.83 | -3.83 | -3.83 | -3.83 |
| Tax Rate, % | 28.03 | 28.03 | 28.03 | 28.03 | 28.03 | 28.03 | 28.03 | 28.03 | 28.03 | 28.03 |
| EBITAT | -1.2 | -65.6 | 15.3 | 16.9 | 11.6 | .1 | .1 | .1 | .1 | .1 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -80.5 | 3.7 | 50.0 | 25.5 | 48.9 | 16.8 | 29.8 | 30.6 | 31.5 | 32.4 |
| WACC, % | 8.98 | 9.16 | 8.8 | 8.8 | 8.77 | 8.9 | 8.9 | 8.9 | 8.9 | 8.9 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 107.7 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 33 | |||||||||
| Terminal Value | 479 | |||||||||
| Present Terminal Value | 313 | |||||||||
| Enterprise Value | 421 | |||||||||
| Net Debt | 131 | |||||||||
| Equity Value | 289 | |||||||||
| Diluted Shares Outstanding, MM | 44 | |||||||||
| Equity Value Per Share | 6.63 |
What You Will Receive
- Comprehensive Financial Model: Tile Shop Holdings, Inc. (TTSH)’s real data supports accurate DCF valuation.
- Complete Forecast Flexibility: Modify revenue growth, profit margins, WACC, and other essential factors.
- Real-Time Calculations: Instant updates allow you to view outcomes as you make adjustments.
- Professional-Grade Template: A polished Excel file crafted for high-standard valuation.
- Adaptable and Reusable: Designed for versatility, enabling repeated use for in-depth forecasting.
Key Features
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for Tile Shop Holdings, Inc. (TTSH).
- WACC Calculator: Pre-configured Weighted Average Cost of Capital sheet with adjustable inputs specific to TTSH.
- Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates to suit your analysis of TTSH.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios relevant to Tile Shop Holdings, Inc. (TTSH).
- Interactive Dashboard and Charts: Visual representations highlight key valuation metrics for streamlined analysis of TTSH.
How It Works
- Download the Template: Get instant access to the Excel-based TTSH DCF Calculator.
- Input Your Assumptions: Adjust yellow-highlighted cells for growth rates, WACC, margins, and more.
- Instant Calculations: The model automatically updates Tile Shop Holdings' intrinsic value.
- Test Scenarios: Simulate different assumptions to evaluate potential valuation changes.
- Analyze and Decide: Use the results to guide your investment or financial analysis.
Why Choose This Calculator for Tile Shop Holdings, Inc. (TTSH)?
- Comprehensive Tool: Features DCF, WACC, and financial ratio analyses all in one convenient package.
- Customizable Inputs: Modify yellow-highlighted cells to explore different financial scenarios.
- Detailed Insights: Automatically computes Tile Shop Holdings’ intrinsic value and Net Present Value.
- Preloaded Data: Access to historical and projected data ensures reliable starting points.
- Professional Quality: Perfect for financial analysts, investors, and business consultants focusing on TTSH.
Who Should Use Tile Shop Holdings, Inc. (TTSH)?
- Homeowners: Enhance your living spaces with high-quality tiles and design ideas.
- Interior Designers: Access a wide selection of stylish tiles for diverse projects.
- Contractors: Source reliable materials for installations and renovations efficiently.
- DIY Enthusiasts: Find inspiration and resources for your home improvement projects.
- Retailers: Partner with us to offer premium tile products to your customers.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Tile Shop Holdings, Inc. (TTSH) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for Tile Shop Holdings, Inc. (TTSH).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.