The ONE Group Hospitality, Inc. (STKS) DCF Valuation
- ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
- ✓ Professional Design: Trusted, Industry-Standard Templates
- ✓ Pre-Built For Quick And Efficient Use
- ✓ No Expertise Is Needed; Easy To Follow
The ONE Group Hospitality, Inc. (STKS) Bundle
Looking to determine the intrinsic value of The ONE Group Hospitality, Inc.? Our (STKS) DCF Calculator integrates real-world data with comprehensive customization features, enabling you to refine your forecasts and enhance your investment strategies.
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 | 120.7 | 141.9 | 277.2 | 316.6 | 332.8 | 442.8 | 589.1 | 783.9 | 1,043.0 | 1,387.8 |
| Revenue Growth, % | 0 | 17.62 | 95.27 | 14.24 | 5.09 | 33.06 | 33.06 | 33.06 | 33.06 | 33.06 |
| EBITDA | 17.3 | 6.8 | 38.6 | 31.4 | 34.0 | 47.1 | 62.7 | 83.4 | 111.0 | 147.6 |
| EBITDA, % | 14.37 | 4.78 | 13.92 | 9.9 | 10.22 | 10.64 | 10.64 | 10.64 | 10.64 | 10.64 |
| Depreciation | 5.4 | 10.1 | 10.8 | 12.1 | 15.7 | 21.3 | 28.3 | 37.7 | 50.1 | 66.7 |
| Depreciation, % | 4.48 | 7.13 | 3.89 | 3.83 | 4.71 | 4.81 | 4.81 | 4.81 | 4.81 | 4.81 |
| EBIT | 11.9 | -3.3 | 27.8 | 19.2 | 18.4 | 25.8 | 34.4 | 45.7 | 60.8 | 80.9 |
| EBIT, % | 9.89 | -2.34 | 10.02 | 6.07 | 5.52 | 5.83 | 5.83 | 5.83 | 5.83 | 5.83 |
| Total Cash | 12.3 | 24.4 | 23.6 | 55.1 | 21.0 | 52.8 | 70.3 | 93.5 | 124.5 | 165.6 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 10.7 | 6.2 | 11.7 | 15.6 | 17.6 | 24.5 | 32.6 | 43.4 | 57.7 | 76.8 |
| Account Receivables, % | 8.86 | 4.33 | 4.23 | 4.93 | 5.3 | 5.53 | 5.53 | 5.53 | 5.53 | 5.53 |
| Inventories | 3.1 | 2.5 | 3.9 | 5.7 | 6.2 | 8.3 | 11.0 | 14.7 | 19.5 | 26.0 |
| Inventories, % | 2.53 | 1.75 | 1.41 | 1.81 | 1.86 | 1.87 | 1.87 | 1.87 | 1.87 | 1.87 |
| Accounts Payable | 8.3 | 7.4 | 11.1 | 13.1 | 19.1 | 23.0 | 30.6 | 40.7 | 54.1 | 72.0 |
| Accounts Payable, % | 6.86 | 5.22 | 4 | 4.12 | 5.74 | 5.19 | 5.19 | 5.19 | 5.19 | 5.19 |
| Capital Expenditure | -4.4 | -5.8 | -11.5 | -32.6 | -53.6 | -33.8 | -45.0 | -59.9 | -79.7 | -106.1 |
| Capital Expenditure, % | -3.61 | -4.08 | -4.14 | -10.3 | -16.09 | -7.64 | -7.64 | -7.64 | -7.64 | -7.64 |
| Tax Rate, % | -108.21 | -108.21 | -108.21 | -108.21 | -108.21 | -108.21 | -108.21 | -108.21 | -108.21 | -108.21 |
| EBITAT | 24.9 | -2.4 | 26.0 | 18.3 | 38.2 | 23.8 | 31.6 | 42.1 | 56.0 | 74.5 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 20.5 | 6.2 | 22.0 | -5.9 | 3.9 | 6.1 | 11.7 | 15.5 | 20.7 | 27.5 |
| WACC, % | 8.08 | 7.22 | 7.89 | 7.94 | 8.08 | 7.84 | 7.84 | 7.84 | 7.84 | 7.84 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 62.2 | |||||||||
| Long Term Growth Rate, % | 3.00 | |||||||||
| Free cash flow (T + 1) | 28 | |||||||||
| Terminal Value | 585 | |||||||||
| Present Terminal Value | 401 | |||||||||
| Enterprise Value | 463 | |||||||||
| Net Debt | 179 | |||||||||
| Equity Value | 284 | |||||||||
| Diluted Shares Outstanding, MM | 32 | |||||||||
| Equity Value Per Share | 8.79 |
What You Will Get
- Editable Forecast Inputs: Easily modify assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: The ONE Group Hospitality, Inc.'s (STKS) financial data pre-filled to kickstart your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically.
- Customizable and Professional: A refined Excel model that adjusts to your valuation requirements.
- Built for Analysts and Investors: Perfect for assessing projections, validating strategies, and enhancing efficiency.
Key Features
- Comprehensive Financial Data: The ONE Group Hospitality, Inc.'s historical financial statements and pre-filled projections.
- Customizable Variables: Adjust WACC, tax rates, revenue growth, and EBITDA margins to fit your analysis.
- Real-Time Valuation: Instantly see the intrinsic value of The ONE Group Hospitality, Inc. recalculated.
- Intuitive Visualizations: Dashboard charts showcase valuation results and essential metrics clearly.
- Designed for Precision: A professional-grade tool tailored for analysts, investors, and finance professionals.
How It Works
- Step 1: Download the Excel file for The ONE Group Hospitality, Inc. (STKS).
- Step 2: Review the pre-filled financial data and forecasts for The ONE Group.
- Step 3: Adjust key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you modify your assumptions.
- Step 5: Evaluate the outputs and leverage the results for your investment strategies.
Why Choose The ONE Group Hospitality, Inc. (STKS)?
- Streamlined Experience: Enjoy a hassle-free process with our ready-to-use solutions.
- Enhanced Precision: Dependable data and methodologies minimize valuation discrepancies.
- Completely Adaptable: Modify our offerings to align with your unique business strategies and forecasts.
- User-Friendly Insights: Intuitive visuals and outputs facilitate straightforward analysis of results.
- Endorsed by Industry Leaders: Crafted for professionals who prioritize accuracy and functionality.
Who Should Use This Product?
- Investors: Make informed investment choices with insights from The ONE Group Hospitality, Inc. (STKS).
- Financial Analysts: Streamline your workflow with a customizable financial model tailored for the hospitality sector.
- Consultants: Efficiently modify the template for client presentations or in-depth reports on hospitality trends.
- Finance Enthusiasts: Enhance your knowledge of the hospitality industry through practical examples and case studies.
- Educators and Students: Utilize this resource as a hands-on learning tool in hospitality and finance courses.
What the Template Contains
- Comprehensive DCF Model: Editable template with detailed valuation calculations tailored for The ONE Group Hospitality, Inc. (STKS).
- Real-World Data: The ONE Group's historical and projected financials preloaded for in-depth analysis.
- Customizable Parameters: Modify WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights into performance.
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage specific to The ONE Group Hospitality, Inc. (STKS).
- Dashboard with Visual Outputs: Charts and tables providing clear, actionable results for informed decision-making.