Target Hospitality Corp. (TH) DCF Valuation
- ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
- ✓ Design Profissional: Modelos Confiáveis E Padrão Da Indústria
- ✓ Pré-Construídos Para Uso Rápido E Eficiente
- ✓ Não É Necessária Experiência; Fácil De Seguir
Target Hospitality Corp. (TH) Bundle
Designed for accuracy, our Target Hospitality Corp. (TH) DCF Calculator enables you to evaluate Target Hospitality Corp. valuation using real financial data and offers complete flexibility to modify all key parameters for improved projections.
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 | 321.1 | 225.1 | 291.3 | 502.0 | 563.6 | 682.1 | 825.5 | 999.1 | 1,209.1 | 1,463.3 |
Revenue Growth, % | 0 | -29.88 | 29.4 | 72.3 | 12.28 | 21.02 | 21.02 | 21.02 | 21.02 | 21.02 |
EBITDA | 112.1 | 68.1 | 106.3 | 224.3 | 332.6 | 280.2 | 339.1 | 410.3 | 496.6 | 601.0 |
EBITDA, % | 34.91 | 30.25 | 36.5 | 44.68 | 59.02 | 41.07 | 41.07 | 41.07 | 41.07 | 41.07 |
Depreciation | 59.1 | 65.2 | 70.3 | 80.1 | 85.6 | 140.0 | 169.5 | 205.1 | 248.2 | 300.4 |
Depreciation, % | 18.41 | 28.97 | 24.14 | 15.96 | 15.18 | 20.53 | 20.53 | 20.53 | 20.53 | 20.53 |
EBIT | 53.0 | 2.9 | 36.0 | 144.2 | 247.1 | 140.1 | 169.6 | 205.2 | 248.4 | 300.6 |
EBIT, % | 16.5 | 1.28 | 12.37 | 28.72 | 43.84 | 20.54 | 20.54 | 20.54 | 20.54 | 20.54 |
Total Cash | 6.8 | 7.0 | 23.4 | 181.7 | 103.9 | 92.6 | 112.1 | 135.6 | 164.1 | 198.7 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 48.5 | 28.2 | 28.8 | 42.2 | 67.1 | 78.8 | 95.4 | 115.5 | 139.8 | 169.1 |
Account Receivables, % | 15.1 | 12.52 | 9.88 | 8.4 | 11.9 | 11.56 | 11.56 | 11.56 | 11.56 | 11.56 |
Inventories | 1.1 | .9 | 1.6 | 2.0 | .0 | 2.3 | 2.8 | 3.4 | 4.1 | 4.9 |
Inventories, % | 0.34258 | 0.39974 | 0.54919 | 0.39842 | 0 | 0.33798 | 0.33798 | 0.33798 | 0.33798 | 0.33798 |
Accounts Payable | 7.8 | 10.6 | 11.8 | 17.6 | 20.9 | 25.1 | 30.4 | 36.8 | 44.5 | 53.9 |
Accounts Payable, % | 2.43 | 4.73 | 4.05 | 3.5 | 3.71 | 3.68 | 3.68 | 3.68 | 3.68 | 3.68 |
Capital Expenditure | -84.7 | -12.2 | -35.5 | -120.3 | -68.4 | -109.2 | -132.2 | -160.0 | -193.7 | -234.4 |
Capital Expenditure, % | -26.39 | -5.41 | -12.18 | -23.96 | -12.14 | -16.02 | -16.02 | -16.02 | -16.02 | -16.02 |
Tax Rate, % | 22.71 | 22.71 | 22.71 | 22.71 | 22.71 | 22.71 | 22.71 | 22.71 | 22.71 | 22.71 |
EBITAT | 23.9 | 2.2 | 61.7 | 100.3 | 191.0 | 103.2 | 124.9 | 151.2 | 183.0 | 221.4 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -43.5 | 78.6 | 96.4 | 52.1 | 188.5 | 124.2 | 150.4 | 182.0 | 220.3 | 266.6 |
WACC, % | 13 | 13.68 | 14.19 | 13.53 | 13.7 | 13.62 | 13.62 | 13.62 | 13.62 | 13.62 |
PV UFCF | ||||||||||
SUM PV UFCF | 622.9 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 272 | |||||||||
Terminal Value | 2,341 | |||||||||
Present Terminal Value | 1,236 | |||||||||
Enterprise Value | 1,859 | |||||||||
Net Debt | 97 | |||||||||
Equity Value | 1,762 | |||||||||
Diluted Shares Outstanding, MM | 105 | |||||||||
Equity Value Per Share | 16.73 |
What You Will Get
- Editable Forecast Inputs: Easily modify assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: Target Hospitality Corp.'s (TH) financial data pre-filled to accelerate your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value for you.
- Customizable and Professional: A refined Excel model that adjusts to your valuation needs.
- Built for Analysts and Investors: Perfect for testing projections, validating strategies, and enhancing efficiency.
Key Features
- 🔍 Real-Life TH Financials: Pre-filled historical and projected data for Target Hospitality Corp. (TH).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Target Hospitality’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Target Hospitality’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Target Hospitality Corp. (TH) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Target Hospitality Corp. (TH)’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose Target Hospitality Corp. (TH)?
- Streamlined Operations: Benefit from a ready-to-use platform that simplifies hospitality management.
- Enhanced Customer Experience: Our services are designed to improve guest satisfaction and retention.
- Flexible Solutions: Customize our offerings to meet the unique needs of your projects and clients.
- User-Friendly Interface: Intuitive design ensures ease of use for both staff and guests.
- Industry Expertise: Backed by a team of professionals dedicated to delivering high-quality service.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling Target Hospitality Corp. (TH) stock.
- Financial Analysts: Streamline valuation processes with ready-to-use financial models for Target Hospitality Corp. (TH).
- Consultants: Deliver professional valuation insights for Target Hospitality Corp. (TH) to clients quickly and accurately.
- Business Owners: Understand how companies like Target Hospitality Corp. (TH) are valued to inform your own business strategy.
- Finance Students: Learn valuation techniques using real-world data and scenarios related to Target Hospitality Corp. (TH).
What the Template Contains
- Comprehensive DCF Model: Editable template with detailed valuation calculations tailored for Target Hospitality Corp. (TH).
- Real-World Data: Target Hospitality’s historical and projected financials preloaded for analysis.
- Customizable Parameters: Adjust WACC, growth rates, and tax assumptions to test various scenarios.
- Financial Statements: Full annual and quarterly breakdowns for deeper insights into Target Hospitality Corp. (TH).
- Key Ratios: Built-in analysis for profitability, efficiency, and leverage specific to Target Hospitality.
- Dashboard with Visual Outputs: Charts and tables for clear, actionable results regarding Target Hospitality Corp. (TH).