MGM Resorts International (MGM) DCF Valuation
- ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
- ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
- ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
- ✓ Aucune Expertise N'Est Requise; Facile À Suivre
MGM Resorts International (MGM) Bundle
Whether you’re an investor or analyst, this MGM DCF Calculator is your go-to resource for accurate valuation. Preloaded with MGM Resorts International real data, you can adjust forecasts and observe the effects in real-time.
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 | 12,899.7 | 5,162.1 | 9,680.1 | 13,127.5 | 16,164.2 | 19,651.1 | 23,890.2 | 29,043.7 | 35,308.9 | 42,925.6 |
| Revenue Growth, % | 0 | -59.98 | 87.52 | 35.61 | 23.13 | 21.57 | 21.57 | 21.57 | 21.57 | 21.57 |
| EBITDA | 2,723.1 | 558.9 | 1,714.4 | 1,766.9 | 2,747.2 | 3,148.2 | 3,827.3 | 4,652.9 | 5,656.6 | 6,876.9 |
| EBITDA, % | 21.11 | 10.83 | 17.71 | 13.46 | 17 | 16.02 | 16.02 | 16.02 | 16.02 | 16.02 |
| Depreciation | 1,376.4 | 1,394.0 | 1,339.5 | 3,919.7 | 814.1 | 3,396.0 | 4,128.6 | 5,019.2 | 6,101.9 | 7,418.1 |
| Depreciation, % | 10.67 | 27 | 13.84 | 29.86 | 5.04 | 17.28 | 17.28 | 17.28 | 17.28 | 17.28 |
| EBIT | 1,346.7 | -835.1 | 374.9 | -2,152.8 | 1,933.1 | -247.8 | -301.2 | -366.2 | -445.2 | -541.3 |
| EBIT, % | 10.44 | -16.18 | 3.87 | -16.4 | 11.96 | -1.26 | -1.26 | -1.26 | -1.26 | -1.26 |
| Total Cash | 2,329.6 | 5,101.6 | 4,703.1 | 5,911.9 | 2,927.8 | 8,985.3 | 10,923.6 | 13,280.0 | 16,144.7 | 19,627.4 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 1,374.9 | 559.9 | 857.8 | 925.2 | 1,070.6 | 1,730.8 | 2,104.1 | 2,558.0 | 3,109.8 | 3,780.6 |
| Account Receivables, % | 10.66 | 10.85 | 8.86 | 7.05 | 6.62 | 8.81 | 8.81 | 8.81 | 8.81 | 8.81 |
| Inventories | 102.9 | 88.3 | 96.4 | 126.1 | 141.7 | 209.9 | 255.2 | 310.2 | 377.2 | 458.5 |
| Inventories, % | 0.7976 | 1.71 | 0.99558 | 0.96031 | 0.87649 | 1.07 | 1.07 | 1.07 | 1.07 | 1.07 |
| Accounts Payable | 235.4 | 142.5 | 286.2 | 369.8 | 461.7 | 519.4 | 631.5 | 767.7 | 933.3 | 1,134.6 |
| Accounts Payable, % | 1.83 | 2.76 | 2.96 | 2.82 | 2.86 | 2.64 | 2.64 | 2.64 | 2.64 | 2.64 |
| Capital Expenditure | -739.0 | -270.6 | -490.7 | -765.1 | -931.8 | -1,086.0 | -1,320.3 | -1,605.1 | -1,951.3 | -2,372.3 |
| Capital Expenditure, % | -5.73 | -5.24 | -5.07 | -5.83 | -5.76 | -5.53 | -5.53 | -5.53 | -5.53 | -5.53 |
| Tax Rate, % | 22.45 | 22.45 | 22.45 | 22.45 | 22.45 | 22.45 | 22.45 | 22.45 | 22.45 | 22.45 |
| EBITAT | 969.4 | -729.3 | 321.7 | -492.4 | 1,499.2 | -171.2 | -208.2 | -253.1 | -307.7 | -374.1 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 364.5 | 1,130.7 | 1,008.3 | 2,648.7 | 1,312.3 | 1,468.0 | 2,293.5 | 2,788.2 | 3,389.7 | 4,120.9 |
| WACC, % | 6.55 | 7.04 | 6.99 | 4.98 | 6.73 | 6.46 | 6.46 | 6.46 | 6.46 | 6.46 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 11,367.1 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 4,203 | |||||||||
| Terminal Value | 94,330 | |||||||||
| Present Terminal Value | 68,992 | |||||||||
| Enterprise Value | 80,359 | |||||||||
| Net Debt | 28,688 | |||||||||
| Equity Value | 51,671 | |||||||||
| Diluted Shares Outstanding, MM | 359 | |||||||||
| Equity Value Per Share | 144.08 |
What You Will Get
- Editable Forecast Inputs: Effortlessly modify key assumptions (growth %, margins, WACC) to generate various scenarios.
- Real-World Data: MGM Resorts International’s financial information pre-loaded to facilitate 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 evaluating projections, confirming strategies, and enhancing efficiency.
Key Features
- Comprehensive DCF Calculator: Offers detailed unlevered and levered DCF valuation models tailored for MGM Resorts International (MGM).
- WACC Calculator: Features a pre-built Weighted Average Cost of Capital sheet with adjustable inputs specific to the hospitality sector.
- Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates according to market conditions.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios relevant to MGM Resorts International (MGM).
- Interactive Dashboard and Charts: Visual representations summarize essential valuation metrics for straightforward analysis.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered MGM data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for MGM’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for MGM Resorts International (MGM)?
- Accurate Data: Access to real MGM financials provides dependable valuation outcomes.
- Customizable: Tailor essential parameters like growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Built-in calculations save you the hassle of starting from scratch.
- Professional-Grade Tool: Crafted for investors, analysts, and consultants in the hospitality sector.
- User-Friendly: An intuitive design and step-by-step guidance make it accessible for all users.
Who Should Use MGM Resorts International (MGM)?
- Travel Enthusiasts: Explore diverse entertainment options and luxurious accommodations across various destinations.
- Event Planners: Utilize our venues for exceptional conferences, weddings, and special events.
- Investors: Gain insights into the hospitality and gaming industry with our robust performance metrics.
- Families: Enjoy family-friendly activities and amenities designed for all ages.
- Business Travelers: Experience top-notch services and facilities tailored for corporate needs.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled MGM Resorts International (MGM) 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 MGM Resorts International (MGM).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.