|
Valoración de DCF de Studio City International Holdings Limited (MSC)
HK | Consumer Cyclical | Gambling, Resorts & Casinos | NYSE
|
- ✓ 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
Studio City International Holdings Limited (MSC) Bundle
¡Valoración de Studio Studio City International Holdings Limited (MSC) utilizando nuestra calculadora DCF personalizable! Con el acceso a finanzas de MSC reales y entradas de pronóstico ajustable, puede explorar fácilmente varios escenarios y determinar el valor razonable de MSC en solo unos minutos.
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 | 626.7 | 49.2 | 106.9 | 11.5 | 445.5 | 466.3 | 488.1 | 510.8 | 534.6 | 559.6 |
| Revenue Growth, % | 0 | -92.16 | 117.36 | -89.19 | 3758.14 | 4.66 | 4.66 | 4.66 | 4.66 | 4.66 |
| EBITDA | 348.7 | -141.0 | -83.9 | -141.6 | 152.8 | -175.8 | -184.0 | -192.6 | -201.6 | -211.0 |
| EBITDA, % | 55.63 | -286.72 | -78.47 | -1226.28 | 34.3 | -37.71 | -37.71 | -37.71 | -37.71 | -37.71 |
| Depreciation | 171.9 | 160.3 | 127.6 | 127.0 | 169.4 | 340.8 | 356.7 | 373.4 | 390.8 | 409.0 |
| Depreciation, % | 27.43 | 326.1 | 119.43 | 1099.38 | 38.02 | 73.09 | 73.09 | 73.09 | 73.09 | 73.09 |
| EBIT | 176.7 | -301.3 | -211.5 | -268.6 | -16.6 | -257.0 | -268.9 | -281.5 | -294.6 | -308.3 |
| EBIT, % | 28.2 | -612.82 | -197.9 | -2325.66 | -3.73 | -55.11 | -55.11 | -55.11 | -55.11 | -55.11 |
| Total Cash | 299.4 | 573.2 | 499.3 | 509.5 | 228.0 | 372.1 | 389.4 | 407.6 | 426.6 | 446.5 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 63.4 | 10.8 | 15.9 | .5 | 43.3 | 56.8 | 59.5 | 62.3 | 65.2 | 68.2 |
| Account Receivables, % | 10.11 | 22.02 | 14.92 | 4.19 | 9.71 | 12.19 | 12.19 | 12.19 | 12.19 | 12.19 |
| Inventories | 9.8 | 9.3 | 5.8 | 5.1 | 5.8 | 66.8 | 69.9 | 73.1 | 76.5 | 80.1 |
| Inventories, % | 1.56 | 18.93 | 5.45 | 44.35 | 1.29 | 14.32 | 14.32 | 14.32 | 14.32 | 14.32 |
| Accounts Payable | 3.3 | .2 | .2 | .5 | 2.5 | 5.6 | 5.9 | 6.2 | 6.5 | 6.8 |
| Accounts Payable, % | 0.53244 | 0.41898 | 0.19744 | 4.34 | 0.55079 | 1.21 | 1.21 | 1.21 | 1.21 | 1.21 |
| Capital Expenditure | -78.6 | -188.5 | -404.5 | -452.1 | -156.8 | -324.3 | -339.4 | -355.3 | -371.8 | -389.2 |
| Capital Expenditure, % | -12.54 | -383.46 | -378.49 | -3915.19 | -35.2 | -69.55 | -69.55 | -69.55 | -69.55 | -69.55 |
| Tax Rate, % | 8.65 | 8.65 | 8.65 | 8.65 | 8.65 | 8.65 | 8.65 | 8.65 | 8.65 | 8.65 |
| EBITAT | 134.7 | -300.6 | -211.2 | -268.9 | -15.2 | -240.1 | -251.3 | -263.0 | -275.3 | -288.1 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 158.3 | -278.9 | -489.7 | -577.6 | -44.0 | -295.0 | -239.5 | -250.7 | -262.3 | -274.6 |
| WACC, % | 4.62 | 5.47 | 5.47 | 5.47 | 5.16 | 5.24 | 5.24 | 5.24 | 5.24 | 5.24 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -1,138.2 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -280 | |||||||||
| Terminal Value | -8,650 | |||||||||
| Present Terminal Value | -6,701 | |||||||||
| Enterprise Value | -7,840 | |||||||||
| Net Debt | 2,120 | |||||||||
| Equity Value | -9,960 | |||||||||
| Diluted Shares Outstanding, MM | 193 | |||||||||
| Equity Value Per Share | -51.72 |
What You Will Get
- Real MSC Financial Data: Pre-filled with Studio City International Holdings 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 MSC’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
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for Studio City International Holdings Limited (MSC).
- WACC Calculator: Pre-configured Weighted Average Cost of Capital sheet with adjustable inputs specific to MSC.
- Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates to fit MSC's financial outlook.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios relevant to Studio City International Holdings Limited (MSC).
- Interactive Dashboard and Charts: Visual representations that summarize essential valuation metrics for straightforward analysis.
How It Works
- Download the Template: Gain immediate access to the Excel-based MSC DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and additional parameters.
- Instant Calculations: The model automatically recalculates the intrinsic value of Studio City International Holdings Limited (MSC).
- Test Scenarios: Experiment with various assumptions to assess potential changes in valuation.
- Analyze and Decide: Utilize the results to inform your investment or financial analysis decisions.
Why Choose This Calculator for Studio City International Holdings Limited (MSC)?
- User-Friendly Interface: Tailored for both novices and seasoned professionals.
- Customizable Inputs: Adjust parameters effortlessly to suit your financial analysis.
- Real-Time Valuation: Observe immediate updates to MSC's valuation as you modify inputs.
- Preloaded Data: Comes with Studio City’s actual financial metrics for swift evaluations.
- Relied Upon by Experts: Favored by investors and analysts for making well-informed choices.
Who Should Use This Product?
- Investors: Assess the intrinsic value of Studio City International Holdings Limited (MSC) to inform investment choices.
- CFOs: Utilize a high-quality DCF model for accurate financial reporting and analysis.
- Consultants: Easily customize the template for client valuation reports related to (MSC).
- Entrepreneurs: Discover financial modeling techniques employed by leading companies, including (MSC).
- Educators: Implement it as a resource for teaching valuation methods in finance courses.
What the Template Contains
- Comprehensive DCF Model: Editable template featuring detailed valuation calculations for Studio City International Holdings Limited (MSC).
- Real-World Data: Historical and projected financials for Studio City International Holdings Limited (MSC) preloaded for in-depth analysis.
- Customizable Parameters: Tailor WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights into Studio City International Holdings Limited (MSC).
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage specific to Studio City International Holdings Limited (MSC).
- Dashboard with Visual Outputs: Charts and tables designed for clear, actionable results related to Studio City International Holdings Limited (MSC).