Melco Resorts & Entertainment Limited (MLCO) 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
Melco Resorts & Entertainment Limited (MLCO) Bundle
Looking to assess the intrinsic value of Melco Resorts & Entertainment Limited? Our (MLCO) DCF Calculator integrates real-world data with comprehensive customization features, allowing you to tailor 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 | 5,736.8 | 1,727.9 | 2,012.4 | 1,350.0 | 3,775.2 | 3,904.2 | 4,037.6 | 4,175.5 | 4,318.2 | 4,465.7 |
| Revenue Growth, % | 0 | -69.88 | 16.46 | -32.92 | 179.65 | 3.42 | 3.42 | 3.42 | 3.42 | 3.42 |
| EBITDA | 1,344.0 | -513.1 | -35.0 | -209.5 | 615.6 | -56.4 | -58.3 | -60.3 | -62.4 | -64.5 |
| EBITDA, % | 23.43 | -29.69 | -1.74 | -15.52 | 16.31 | -1.44 | -1.44 | -1.44 | -1.44 | -1.44 |
| Depreciation | 628.5 | 595.6 | 557.0 | 499.3 | 543.4 | 972.0 | 1,005.2 | 1,039.6 | 1,075.1 | 1,111.8 |
| Depreciation, % | 10.96 | 34.47 | 27.68 | 36.98 | 14.39 | 24.9 | 24.9 | 24.9 | 24.9 | 24.9 |
| EBIT | 715.4 | -1,108.7 | -592.0 | -708.8 | 72.2 | -1,028.4 | -1,063.6 | -1,099.9 | -1,137.5 | -1,176.3 |
| EBIT, % | 12.47 | -64.17 | -29.42 | -52.51 | 1.91 | -26.34 | -26.34 | -26.34 | -26.34 | -26.34 |
| Total Cash | 1,444.4 | 1,755.4 | 1,652.9 | 1,812.7 | 1,310.7 | 2,670.7 | 2,762.0 | 2,856.3 | 2,953.9 | 3,054.8 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 284.8 | 129.6 | 54.9 | 56.6 | 92.4 | 170.5 | 176.3 | 182.3 | 188.6 | 195.0 |
| Account Receivables, % | 4.96 | 7.5 | 2.73 | 4.19 | 2.45 | 4.37 | 4.37 | 4.37 | 4.37 | 4.37 |
| Inventories | 44.0 | 37.3 | 29.6 | 26.4 | 29.4 | 55.7 | 57.6 | 59.5 | 61.6 | 63.7 |
| Inventories, % | 0.76626 | 2.16 | 1.47 | 1.96 | 0.77947 | 1.43 | 1.43 | 1.43 | 1.43 | 1.43 |
| Accounts Payable | 21.9 | 9.5 | 6.0 | 6.7 | 11.8 | 15.9 | 16.5 | 17.0 | 17.6 | 18.2 |
| Accounts Payable, % | 0.38143 | 0.54881 | 0.29776 | 0.49853 | 0.31129 | 0.40756 | 0.40756 | 0.40756 | 0.40756 | 0.40756 |
| Capital Expenditure | -449.9 | -463.9 | -679.4 | -622.1 | -263.9 | -948.9 | -981.3 | -1,014.8 | -1,049.5 | -1,085.4 |
| Capital Expenditure, % | -7.84 | -26.85 | -33.76 | -46.08 | -6.99 | -24.3 | -24.3 | -24.3 | -24.3 | -24.3 |
| Tax Rate, % | 18.66 | 18.66 | 18.66 | 18.66 | 18.66 | 18.66 | 18.66 | 18.66 | 18.66 | 18.66 |
| EBITAT | 663.2 | -1,106.5 | -593.8 | -712.2 | 58.7 | -974.6 | -1,007.9 | -1,042.4 | -1,078.0 | -1,114.8 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 534.9 | -825.3 | -637.2 | -832.9 | 304.4 | -1,051.6 | -991.2 | -1,025.0 | -1,060.0 | -1,096.3 |
| WACC, % | 6.82 | 7.16 | 7.17 | 7.17 | 6.27 | 6.92 | 6.92 | 6.92 | 6.92 | 6.92 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -4,285.0 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -1,118 | |||||||||
| Terminal Value | -22,732 | |||||||||
| Present Terminal Value | -16,269 | |||||||||
| Enterprise Value | -20,554 | |||||||||
| Net Debt | 6,458 | |||||||||
| Equity Value | -27,012 | |||||||||
| Diluted Shares Outstanding, MM | 438 | |||||||||
| Equity Value Per Share | -61.64 |
What You Will Receive
- Authentic MLCO Financial Data: Pre-filled with Melco Resorts’ historical and projected data for accurate analysis.
- Completely Customizable Template: Easily adjust key inputs such as revenue growth, WACC, and EBITDA %.
- Instant Calculations: Witness Melco Resorts' intrinsic value update in real-time as you make changes.
- Professional Valuation Tool: Tailored for investors, analysts, and consultants aiming for precise DCF outcomes.
- User-Friendly Interface: Intuitive layout and straightforward instructions suitable for all skill levels.
Key Features
- Real-Life MLCO Data: Pre-filled with Melco Resorts & Entertainment Limited’s historical financials and future projections.
- Fully Customizable Inputs: Modify revenue growth, profit margins, WACC, tax rates, and capital expenditures to suit your analysis.
- Dynamic Valuation Model: Automatic recalculations of Net Present Value (NPV) and intrinsic value based on your specified inputs.
- Scenario Testing: Develop various forecast scenarios to explore different valuation results.
- User-Friendly Design: Intuitive, organized, and tailored for both professionals and newcomers.
How It Works
- 1. Access the Template: Download and open the Excel file containing Melco Resorts & Entertainment Limited’s (MLCO) preloaded data.
- 2. Modify Assumptions: Adjust essential inputs such as growth rates, WACC, and capital expenditures.
- 3. View Results Instantly: The DCF model automatically calculates intrinsic value and NPV in real-time.
- 4. Explore Scenarios: Analyze various forecasts to evaluate different valuation results.
- 5. Present with Confidence: Deliver professional valuation insights to enhance your decision-making.
Why Choose Melco Resorts & Entertainment Limited (MLCO)?
- Exceptional Experience: Enjoy world-class entertainment and hospitality in premier destinations.
- Strong Financial Performance: Benefit from a company with a proven track record of profitability and growth.
- Innovative Offerings: Explore cutting-edge facilities and unique attractions that set us apart.
- Sustainable Practices: Committed to responsible tourism and environmental stewardship.
- Expert Leadership: Led by a team of industry veterans dedicated to excellence and customer satisfaction.
Who Should Use This Product?
- Investors: Accurately assess Melco Resorts & Entertainment Limited’s (MLCO) fair value prior to making investment choices.
- CFOs: Utilize a top-tier DCF model for comprehensive financial reporting and analysis.
- Consultants: Efficiently customize the template for valuation reports tailored to clients.
- Entrepreneurs: Acquire knowledge of financial modeling techniques employed by leading companies in the entertainment sector.
- Educators: Implement it as a teaching resource to illustrate various valuation methodologies.
What the Template Contains
- Historical Data: Includes Melco Resorts & Entertainment Limited’s (MLCO) past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Melco’s intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
- Quarterly and Annual Statements: A complete breakdown of Melco’s financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.