|
H World Group Limited (HTHT) DCF Valoración
CN | Consumer Cyclical | Travel Lodging | NASDAQ
|
- ✓ Completamente Editable: Adáptelo A Sus Necesidades En Excel O Sheets
- ✓ Diseño Profesional: Plantillas Confiables Y Estándares De La Industria
- ✓ Predeterminadas Para Un Uso Rápido Y Eficiente
- ✓ No Se Necesita Experiencia; Fáciles De Seguir
H World Group Limited (HTHT) Bundle
¡Obtenga información sobre su análisis de valoración H World Group Limited (HTHT) utilizando nuestra sofisticada calculadora DCF! Esta plantilla de Excel viene precisa con datos HTHT auténticos, lo que le permite ajustar los pronósticos y supuestos para un cálculo preciso del valor intrínseco de H World Group Limited.
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 | 1,536.4 | 1,397.2 | 1,752.2 | 1,899.6 | 2,998.6 | 3,617.9 | 4,365.1 | 5,266.6 | 6,354.3 | 7,666.7 |
| Revenue Growth, % | 0 | -9.06 | 25.41 | 8.41 | 57.86 | 20.65 | 20.65 | 20.65 | 20.65 | 20.65 |
| EBITDA | 424.7 | -52.6 | 228.4 | 75.2 | 979.5 | 532.1 | 642.0 | 774.6 | 934.6 | 1,127.6 |
| EBITDA, % | 27.64 | -3.77 | 13.04 | 3.96 | 32.67 | 14.71 | 14.71 | 14.71 | 14.71 | 14.71 |
| Depreciation | 139.6 | 186.6 | 206.0 | 199.5 | 193.8 | 370.2 | 446.7 | 538.9 | 650.3 | 784.6 |
| Depreciation, % | 9.09 | 13.36 | 11.75 | 10.5 | 6.46 | 10.23 | 10.23 | 10.23 | 10.23 | 10.23 |
| EBIT | 285.0 | -239.3 | 22.5 | -124.3 | 785.7 | 161.9 | 195.3 | 235.6 | 284.3 | 343.0 |
| EBIT, % | 18.55 | -17.12 | 1.28 | -6.54 | 26.2 | 4.47 | 4.47 | 4.47 | 4.47 | 4.47 |
| Total Cash | 841.7 | 1,497.6 | 1,055.8 | 736.0 | 1,251.8 | 2,138.4 | 2,580.0 | 3,112.9 | 3,755.8 | 4,531.5 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 32.2 | 56.0 | 71.4 | 152.5 | 103.5 | 156.7 | 189.1 | 228.2 | 275.3 | 332.1 |
| Account Receivables, % | 2.1 | 4.01 | 4.07 | 8.03 | 3.45 | 4.33 | 4.33 | 4.33 | 4.33 | 4.33 |
| Inventories | 7.8 | 12.2 | 12.1 | 9.6 | 8.1 | 20.6 | 24.8 | 30.0 | 36.1 | 43.6 |
| Inventories, % | 0.50838 | 0.87289 | 0.6882 | 0.50498 | 0.26963 | 0.56882 | 0.56882 | 0.56882 | 0.56882 | 0.56882 |
| Accounts Payable | 161.2 | 170.1 | 132.6 | 160.5 | 139.6 | 313.6 | 378.3 | 456.5 | 550.7 | 664.5 |
| Accounts Payable, % | 10.49 | 12.17 | 7.57 | 8.45 | 4.66 | 8.67 | 8.67 | 8.67 | 8.67 | 8.67 |
| Capital Expenditure | -210.3 | -243.4 | -229.5 | -144.3 | -123.5 | -404.6 | -488.2 | -589.0 | -710.7 | -857.5 |
| Capital Expenditure, % | -13.69 | -17.42 | -13.1 | -7.6 | -4.12 | -11.18 | -11.18 | -11.18 | -11.18 | -11.18 |
| Tax Rate, % | 23.43 | 23.43 | 23.43 | 23.43 | 23.43 | 23.43 | 23.43 | 23.43 | 23.43 | 23.43 |
| EBITAT | 196.6 | -216.7 | 23.1 | -140.3 | 601.6 | 141.2 | 170.3 | 205.5 | 248.0 | 299.2 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 247.0 | -292.7 | -53.1 | -135.9 | 701.7 | 214.9 | 157.0 | 189.4 | 228.5 | 275.7 |
| WACC, % | 6.52 | 6.81 | 6.94 | 6.94 | 6.62 | 6.77 | 6.77 | 6.77 | 6.77 | 6.77 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 869.1 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 281 | |||||||||
| Terminal Value | 5,896 | |||||||||
| Present Terminal Value | 4,250 | |||||||||
| Enterprise Value | 5,119 | |||||||||
| Net Debt | 3,965 | |||||||||
| Equity Value | 1,154 | |||||||||
| Diluted Shares Outstanding, MM | 335 | |||||||||
| Equity Value Per Share | 3.44 |
What You Will Get
- Real HTHT Financial Data: Pre-filled with H World Group Limited’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 H World Group Limited’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 Inputs: Adjust essential metrics such as occupancy rates, average daily rates, and operational costs.
- Instant DCF Valuation: Computes intrinsic value, net present value, and other financial metrics on the fly.
- High Precision Analysis: Leverages H World Group Limited's (HTHT) actual financial data for accurate valuation results.
- Effortless Scenario Testing: Evaluate various scenarios and analyze results with ease.
- Efficiency Booster: Remove the hassle of creating intricate valuation models from the ground up.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered H World Group Limited (HTHT) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for H World Group Limited’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for H World Group Limited (HTHT)?
- Accurate Data: Utilize real financials from H World Group Limited for dependable valuation outcomes.
- Customizable: Modify essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Pre-configured calculations save you the hassle of starting from the ground up.
- Professional-Grade Tool: Tailored for investors, analysts, and consultants in the hospitality sector.
- User-Friendly: Designed with an intuitive interface and clear instructions for ease of use by all users.
Who Should Use This Product?
- Professional Investors: Create comprehensive and accurate valuation models for portfolio assessment of H World Group Limited (HTHT).
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the organization.
- Consultants and Advisors: Deliver precise valuation insights for clients interested in H World Group Limited (HTHT).
- Students and Educators: Utilize real-time data to enhance learning and practice in financial modeling.
- Travel Industry Enthusiasts: Gain insights into how hospitality companies like H World Group Limited (HTHT) are valued in the market.
What the Template Contains
- Pre-Filled DCF Model: H World Group Limited’s (HTHT) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate H World Group Limited’s (HTHT) profitability, leverage, and efficiency.
- Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
- Financial Statements: Annual and quarterly reports to support detailed analysis.
- Interactive Dashboard: Easily visualize key valuation metrics and results.