|
The Marcus Corporation (MCS) DCF Valuation
US | Communication Services | Entertainment | NYSE
|
- ✓ 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
The Marcus Corporation (MCS) Bundle
Evaluate The Marcus Corporation's (MCS) financial prospects like an expert! This (MCS) DCF Calculator provides pre-filled financial data and offers complete flexibility to modify revenue growth, WACC, margins, and other essential assumptions to align with your predictions.
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 | 820.9 | 237.7 | 458.2 | 677.4 | 729.6 | 870.5 | 1,038.7 | 1,239.4 | 1,478.8 | 1,764.5 |
| Revenue Growth, % | 0 | -71.04 | 92.79 | 47.82 | 7.7 | 19.32 | 19.32 | 19.32 | 19.32 | 19.32 |
| EBITDA | 141.7 | -104.5 | 31.8 | 74.5 | 101.7 | 9.0 | 10.8 | 12.9 | 15.4 | 18.3 |
| EBITDA, % | 17.26 | -43.95 | 6.95 | 11 | 13.94 | 1.04 | 1.04 | 1.04 | 1.04 | 1.04 |
| Depreciation | 750.8 | 391.4 | 493.9 | 667.6 | 67.3 | 695.1 | 829.4 | 989.6 | 1,180.8 | 1,408.9 |
| Depreciation, % | 91.46 | 164.68 | 107.79 | 98.55 | 9.22 | 79.85 | 79.85 | 79.85 | 79.85 | 79.85 |
| EBIT | -609.1 | -495.9 | -462.1 | -593.0 | 34.4 | -621.6 | -741.7 | -885.0 | -1,056.0 | -1,260.0 |
| EBIT, % | -74.2 | -208.64 | -100.84 | -87.55 | 4.71 | -71.41 | -71.41 | -71.41 | -71.41 | -71.41 |
| Total Cash | 25.6 | 6.7 | 17.7 | 21.7 | 61.0 | 37.2 | 44.4 | 53.0 | 63.2 | 75.4 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 9.3 | .4 | 31.4 | 6.7 | 7.6 | 17.8 | 21.2 | 25.3 | 30.2 | 36.0 |
| Account Receivables, % | 1.14 | 0.17039 | 6.86 | 0.99012 | 1.05 | 2.04 | 2.04 | 2.04 | 2.04 | 2.04 |
| Inventories | 5.7 | 3.4 | 4.9 | 5.7 | 5.9 | 8.5 | 10.1 | 12.0 | 14.4 | 17.1 |
| Inventories, % | 0.6911 | 1.44 | 1.07 | 0.83585 | 0.81061 | 0.97089 | 0.97089 | 0.97089 | 0.97089 | 0.97089 |
| Accounts Payable | 49.4 | 13.2 | 35.8 | 32.2 | 37.4 | 50.9 | 60.7 | 72.5 | 86.5 | 103.2 |
| Accounts Payable, % | 6.01 | 5.54 | 7.81 | 4.75 | 5.12 | 5.85 | 5.85 | 5.85 | 5.85 | 5.85 |
| Capital Expenditure | -64.1 | -21.4 | -17.1 | -36.8 | -38.8 | -54.5 | -65.0 | -77.5 | -92.5 | -110.4 |
| Capital Expenditure, % | -7.81 | -8.99 | -3.73 | -5.44 | -5.31 | -6.26 | -6.26 | -6.26 | -6.26 | -6.26 |
| Tax Rate, % | 31.67 | 31.67 | 31.67 | 31.67 | 31.67 | 31.67 | 31.67 | 31.67 | 31.67 | 31.67 |
| EBITAT | -470.1 | -316.2 | -339.1 | -2,744.8 | 23.5 | -475.8 | -567.7 | -677.3 | -808.2 | -964.3 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 250.9 | 28.8 | 127.9 | -2,093.7 | 56.0 | 165.7 | 201.5 | 240.4 | 286.9 | 342.3 |
| WACC, % | 9.04 | 8.86 | 8.98 | 9.34 | 8.92 | 9.03 | 9.03 | 9.03 | 9.03 | 9.03 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 932.3 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 349 | |||||||||
| Terminal Value | 4,969 | |||||||||
| Present Terminal Value | 3,226 | |||||||||
| Enterprise Value | 4,158 | |||||||||
| Net Debt | 323 | |||||||||
| Equity Value | 3,834 | |||||||||
| Diluted Shares Outstanding, MM | 41 | |||||||||
| Equity Value Per Share | 93.55 |
What You Will Receive
- Customizable Excel Template: A fully adjustable Excel-based DCF Calculator featuring pre-filled real MCS financials.
- Authentic Data: Historical figures and future projections (highlighted in the yellow cells).
- Forecast Adaptability: Modify forecast parameters such as revenue growth, EBITDA %, and WACC.
- Instant Calculations: Quickly observe how your inputs affect Marcus Corporation’s valuation.
- Professional Resource: Designed for investors, CFOs, consultants, and financial analysts.
- Intuitive Layout: Organized for clarity and simplicity, complete with step-by-step guidance.
Key Features
- Accurate Marcus Financials: Gain access to reliable pre-loaded historical data and future forecasts.
- Adjustable Forecast Parameters: Modify yellow-highlighted cells such as WACC, growth rates, and profit margins.
- Real-Time Calculations: Instant updates to DCF, Net Present Value (NPV), and cash flow assessments.
- Intuitive Visual Dashboard: User-friendly charts and summaries to help you visualize your valuation outcomes.
- Designed for All Users: A straightforward, intuitive layout tailored for investors, CFOs, and consultants alike.
How It Works
- 1. Access the Template: Download and open the Excel file containing The Marcus Corporation's (MCS) preloaded data.
- 2. Adjust Assumptions: Modify key inputs such as growth rates, WACC, and capital expenditures to fit your analysis.
- 3. Instant Results: The DCF model automatically calculates the intrinsic value and NPV for The Marcus Corporation (MCS).
- 4. Explore Scenarios: Evaluate multiple forecasts to assess various valuation outcomes for The Marcus Corporation (MCS).
- 5. Present with Assurance: Deliver professional valuation insights to enhance your decision-making regarding The Marcus Corporation (MCS).
Why Choose This Calculator for The Marcus Corporation (MCS)?
- User-Friendly Interface: Perfectly crafted for both novices and seasoned users.
- Customizable Inputs: Effortlessly adjust parameters to suit your analysis needs.
- Real-Time Feedback: Instantly observe changes in The Marcus Corporation’s valuation as you modify inputs.
- Pre-Configured Data: Comes with The Marcus Corporation’s actual financial metrics for swift evaluations.
- Relied Upon by Experts: Employed by investors and analysts for making well-informed choices.
Who Should Use The Marcus Corporation (MCS)?
- Investors: Gain insights into a leading hospitality and entertainment company to make informed investment choices.
- Financial Analysts: Utilize comprehensive financial reports and performance metrics to streamline your analysis.
- Consultants: Easily customize presentations or reports using data from a reputable industry player.
- Finance Enthusiasts: Explore the dynamics of the hospitality sector and enhance your understanding of market trends.
- Educators and Students: Leverage real-world case studies from The Marcus Corporation (MCS) in finance and business courses.
What the Template Contains
- Pre-Filled DCF Model: The Marcus Corporation’s financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate The Marcus Corporation’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.