|
GreenTree Hospitality Group Ltd. (GHG) DCF Valuation
CN | Consumer Cyclical | Travel Lodging | NYSE
|
- ✓ 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
GreenTree Hospitality Group Ltd. (GHG) Bundle
Explore the financial prospects of GreenTree Hospitality Group Ltd. (GHG) with our user-friendly DCF Calculator! Enter your assumptions regarding growth, profit margins, and expenses to derive the intrinsic value of GreenTree Hospitality Group Ltd. (GHG) and enhance your investment decision-making.
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 | 149.6 | 127.4 | 165.3 | 129.5 | 223.0 | 259.4 | 301.9 | 351.2 | 408.7 | 475.5 |
| Revenue Growth, % | 0 | -14.82 | 29.69 | -21.64 | 72.17 | 16.35 | 16.35 | 16.35 | 16.35 | 16.35 |
| EBITDA | 75.1 | 52.8 | 45.2 | -48.1 | 70.1 | 58.8 | 68.4 | 79.6 | 92.6 | 107.8 |
| EBITDA, % | 50.23 | 41.41 | 27.37 | -37.12 | 31.42 | 22.66 | 22.66 | 22.66 | 22.66 | 22.66 |
| Depreciation | 5.5 | 9.0 | 16.4 | 17.2 | 16.0 | 21.3 | 24.8 | 28.9 | 33.6 | 39.1 |
| Depreciation, % | 3.7 | 7.08 | 9.89 | 13.26 | 7.18 | 8.22 | 8.22 | 8.22 | 8.22 | 8.22 |
| EBIT | 69.6 | 43.7 | 28.9 | -65.3 | 54.0 | 37.5 | 43.6 | 50.7 | 59.0 | 68.6 |
| EBIT, % | 46.53 | 34.33 | 17.48 | -50.38 | 24.24 | 14.44 | 14.44 | 14.44 | 14.44 | 14.44 |
| Total Cash | 132.1 | 158.4 | 138.9 | 119.7 | 167.9 | 228.4 | 265.7 | 309.1 | 359.7 | 418.5 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 14.1 | 15.2 | 14.3 | 20.4 | 18.9 | 28.2 | 32.8 | 38.1 | 44.3 | 51.6 |
| Account Receivables, % | 9.43 | 11.9 | 8.66 | 15.79 | 8.49 | 10.85 | 10.85 | 10.85 | 10.85 | 10.85 |
| Inventories | .3 | .5 | .3 | .3 | 2.8 | 1.2 | 1.4 | 1.6 | 1.9 | 2.2 |
| Inventories, % | 0.23244 | 0.4091 | 0.19049 | 0.23659 | 1.26 | 0.46522 | 0.46522 | 0.46522 | 0.46522 | 0.46522 |
| Accounts Payable | 2.1 | 2.7 | 3.3 | 16.9 | 10.0 | 12.0 | 13.9 | 16.2 | 18.9 | 21.9 |
| Accounts Payable, % | 1.4 | 2.11 | 1.99 | 13.08 | 4.49 | 4.61 | 4.61 | 4.61 | 4.61 | 4.61 |
| Capital Expenditure | -13.7 | -15.5 | -76.9 | -9.5 | -12.1 | -41.8 | -48.7 | -56.6 | -65.9 | -76.6 |
| Capital Expenditure, % | -9.18 | -12.13 | -46.53 | -7.31 | -5.44 | -16.12 | -16.12 | -16.12 | -16.12 | -16.12 |
| Tax Rate, % | 28.94 | 28.94 | 28.94 | 28.94 | 28.94 | 28.94 | 28.94 | 28.94 | 28.94 | 28.94 |
| EBITAT | 49.2 | 32.3 | 19.5 | -58.6 | 38.4 | 27.9 | 32.5 | 37.8 | 44.0 | 51.2 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 28.7 | 25.2 | -39.3 | -43.4 | 34.4 | 1.8 | 5.8 | 6.8 | 7.9 | 9.2 |
| WACC, % | 4.98 | 5.05 | 4.92 | 5.4 | 4.99 | 5.07 | 5.07 | 5.07 | 5.07 | 5.07 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 26.5 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 9 | |||||||||
| Terminal Value | 306 | |||||||||
| Present Terminal Value | 239 | |||||||||
| Enterprise Value | 265 | |||||||||
| Net Debt | 146 | |||||||||
| Equity Value | 119 | |||||||||
| Diluted Shares Outstanding, MM | 102 | |||||||||
| Equity Value Per Share | 1.17 |
What You Will Get
- Real GreenTree Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for GreenTree Hospitality Group Ltd. (GHG).
- Full Customization: Adjust all critical parameters (yellow cells) such as WACC, growth %, and tax rates to fit your analysis.
- Instant Valuation Updates: Automatic recalculations to assess the impact of changes on GreenTree's fair value.
- Versatile Excel Template: Designed for quick edits, scenario testing, and comprehensive projections.
- Time-Saving and Accurate: Eliminate the need to build models from scratch while ensuring precision and flexibility.
Key Features
- Comprehensive Financial Data: Gain access to reliable pre-loaded historical figures and future forecasts for GreenTree Hospitality Group Ltd. (GHG).
- Tailored Forecast Assumptions: Modify highlighted cells for key inputs such as WACC, growth rates, and profit margins.
- Real-Time Calculations: Enjoy automatic updates for DCF, Net Present Value (NPV), and cash flow assessments.
- Interactive Dashboard: User-friendly charts and summaries to help you visualize your valuation findings.
- Designed for All Users: An intuitive layout suitable for investors, CFOs, and consultants, regardless of experience level.
How It Works
- Download the Template: Gain immediate access to the Excel-based GHG DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
- Instant Calculations: The model automatically recalculates GreenTree Hospitality Group Ltd.'s intrinsic value.
- Test Scenarios: Experiment with different assumptions to assess potential valuation shifts.
- Analyze and Decide: Utilize the findings to inform your investment or financial assessment.
Why Choose This Calculator for GreenTree Hospitality Group Ltd. (GHG)?
- Reliable Data: Access to accurate financial information ensures trustworthy valuation outcomes.
- Flexible Options: Tailor essential metrics like occupancy rates, revenue growth, and operating costs to align with your forecasts.
- Efficient: Built-in calculations save time and allow you to focus on analysis rather than setup.
- Expert-Level Tool: Crafted for investors, financial analysts, and industry consultants.
- Easy to Use: User-friendly design and clear guidance make it accessible for all experience levels.
Who Should Use This Product?
- Investors: Accurately estimate GreenTree Hospitality Group Ltd.'s (GHG) fair value before making investment decisions.
- CFOs: Utilize a professional-grade DCF model for financial reporting and analysis specific to GHG.
- Consultants: Quickly customize the template for valuation reports tailored to GHG clients.
- Entrepreneurs: Gain insights into financial modeling practices employed by leading hospitality firms.
- Educators: Use it as an educational resource to illustrate valuation methodologies relevant to the hospitality industry.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled GreenTree Hospitality Group Ltd. (GHG) 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 GreenTree Hospitality Group Ltd. (GHG).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.