Monarch Casino & Resort, Inc. (MCRI) 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
Monarch Casino & Resort, Inc. (MCRI) Bundle
Explore the financial future of Monarch Casino & Resort, Inc. (MCRI) with our user-friendly DCF Calculator! Enter your projections for growth, margins, and expenses to calculate the intrinsic value of Monarch Casino & Resort, Inc. (MCRI) and enhance your investment strategy.
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 | 249.2 | 184.4 | 395.4 | 477.9 | 501.5 | 626.6 | 783.0 | 978.4 | 1,222.5 | 1,527.6 |
| Revenue Growth, % | 0 | -25.99 | 114.4 | 20.86 | 4.94 | 24.95 | 24.95 | 24.95 | 24.95 | 24.95 |
| EBITDA | 54.5 | 32.6 | 128.3 | 154.9 | 157.4 | 170.2 | 212.6 | 265.7 | 332.0 | 414.8 |
| EBITDA, % | 21.85 | 17.68 | 32.45 | 32.41 | 31.4 | 27.16 | 27.16 | 27.16 | 27.16 | 27.16 |
| Depreciation | 14.9 | 17.3 | 38.4 | 43.4 | 47.3 | 54.6 | 68.3 | 85.3 | 106.6 | 133.2 |
| Depreciation, % | 5.97 | 9.39 | 9.72 | 9.09 | 9.43 | 8.72 | 8.72 | 8.72 | 8.72 | 8.72 |
| EBIT | 39.6 | 15.3 | 89.9 | 111.4 | 110.2 | 115.5 | 144.4 | 180.4 | 225.4 | 281.6 |
| EBIT, % | 15.88 | 8.28 | 22.73 | 23.32 | 21.97 | 18.44 | 18.44 | 18.44 | 18.44 | 18.44 |
| Total Cash | 60.5 | 28.3 | 33.5 | 38.8 | 43.4 | 81.3 | 101.6 | 127.0 | 158.7 | 198.2 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 5.5 | 28.6 | 35.8 | 34.6 | 13.0 | 45.9 | 57.3 | 71.6 | 89.5 | 111.8 |
| Account Receivables, % | 2.19 | 15.52 | 9.06 | 7.23 | 2.59 | 7.32 | 7.32 | 7.32 | 7.32 | 7.32 |
| Inventories | 6.7 | 7.8 | 7.2 | 7.6 | 7.6 | 14.9 | 18.6 | 23.2 | 29.0 | 36.2 |
| Inventories, % | 2.7 | 4.24 | 1.81 | 1.58 | 1.52 | 2.37 | 2.37 | 2.37 | 2.37 | 2.37 |
| Accounts Payable | 17.0 | 11.7 | 18.6 | 14.4 | 23.1 | 31.9 | 39.9 | 49.9 | 62.3 | 77.8 |
| Accounts Payable, % | 6.84 | 6.32 | 4.7 | 3.02 | 4.6 | 5.1 | 5.1 | 5.1 | 5.1 | 5.1 |
| Capital Expenditure | -125.4 | -88.7 | -46.9 | -39.5 | -49.0 | -160.8 | -200.9 | -251.0 | -313.7 | -392.0 |
| Capital Expenditure, % | -50.31 | -48.08 | -11.87 | -8.26 | -9.77 | -25.66 | -25.66 | -25.66 | -25.66 | -25.66 |
| Tax Rate, % | 24.03 | 24.03 | 24.03 | 24.03 | 24.03 | 24.03 | 24.03 | 24.03 | 24.03 | 24.03 |
| EBITAT | 31.8 | 24.1 | 72.1 | 89.4 | 83.7 | 96.3 | 120.3 | 150.4 | 187.9 | 234.8 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -73.8 | -76.9 | 64.0 | 90.1 | 112.1 | -41.1 | -19.5 | -24.3 | -30.4 | -38.0 |
| WACC, % | 12.67 | 12.69 | 12.67 | 12.67 | 12.66 | 12.67 | 12.67 | 12.67 | 12.67 | 12.67 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -108.7 | |||||||||
| Long Term Growth Rate, % | 3.00 | |||||||||
| Free cash flow (T + 1) | -39 | |||||||||
| Terminal Value | -405 | |||||||||
| Present Terminal Value | -223 | |||||||||
| Enterprise Value | -332 | |||||||||
| Net Debt | -23 | |||||||||
| Equity Value | -309 | |||||||||
| Diluted Shares Outstanding, MM | 20 | |||||||||
| Equity Value Per Share | -15.73 |
What You Will Get
- Real Monarch Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Monarch Casino & Resort, Inc. (MCRI).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates to fit your analysis.
- Instant Valuation Updates: Automatic recalculations to assess the impact of changes on the fair value of Monarch Casino & Resort, Inc. (MCRI).
- Versatile Excel Template: Designed for quick edits, scenario testing, and comprehensive projections.
- Time-Saving and Accurate: Avoid building models from scratch while ensuring precision and flexibility in your analysis.
Key Features
- Comprehensive Financial Data: Monarch Casino & Resort, Inc.’s historical financial statements and pre-populated projections.
- Customizable Parameters: Adjust WACC, tax rates, revenue growth, and EBITDA margins to fit your analysis.
- Real-Time Insights: Monitor Monarch’s intrinsic value recalculating instantly as inputs change.
- Intuitive Visualizations: Dashboard graphs present valuation outcomes and essential metrics clearly.
- Designed for Precision: A robust tool tailored for analysts, investors, and finance professionals.
How It Works
- 1. Access the Template: Download and open the Excel file featuring Monarch Casino & Resort, Inc.'s (MCRI) preloaded data.
- 2. Modify Assumptions: Adjust essential inputs such as growth rates, WACC, and capital expenditures.
- 3. View Results in Real-Time: The DCF model automatically calculates intrinsic value and NPV.
- 4. Evaluate Scenarios: Analyze various forecasts to explore different valuation results.
- 5. Utilize with Assurance: Present expert valuation insights to back your decision-making process.
Why Choose This Calculator for Monarch Casino & Resort, Inc. (MCRI)?
- Accuracy: Utilizes precise financial data from Monarch Casino & Resort, Inc. for reliable results.
- Flexibility: Allows users to easily adjust and experiment with various input parameters.
- Time-Saving: Eliminates the need to start a DCF model from the ground up.
- Professional-Grade: Crafted with the expertise and standards expected by CFOs.
- User-Friendly: Intuitive interface suitable for users without extensive financial modeling skills.
Who Should Use This Product?
- Investors: Accurately assess Monarch Casino & Resort, Inc.'s (MCRI) fair value prior to making investment choices.
- CFOs: Utilize a professional-grade DCF model for financial reporting and analysis specific to Monarch Casino & Resort, Inc. (MCRI).
- Consultants: Efficiently modify the template for valuation reports tailored to clients in the gaming and hospitality industry.
- Entrepreneurs: Acquire knowledge on financial modeling practices employed by leading casino and resort companies.
- Educators: Implement it as a teaching resource to illustrate valuation techniques in the context of the gaming sector.
What the Template Contains
- Pre-Filled DCF Model: Monarch Casino & Resort, Inc. (MCRI)’s financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Monarch Casino & Resort, Inc. (MCRI)’s 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.