Century Casinos, Inc. (CNTY) DCF Valuation
- ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
- ✓ Design Profissional: Modelos Confiáveis E Padrão Da Indústria
- ✓ Pré-Construídos Para Uso Rápido E Eficiente
- ✓ Não É Necessária Experiência; Fácil De Seguir
Century Casinos, Inc. (CNTY) Bundle
Discover the true value of Century Casinos, Inc. (CNTY) with our professional-grade DCF Calculator! Adjust key assumptions, evaluate various scenarios, and analyze how changes affect Century Casinos, Inc. (CNTY) valuation – all within one convenient Excel template.
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 | 218.2 | 304.3 | 388.5 | 430.5 | 550.2 | 695.6 | 879.5 | 1,112.0 | 1,405.9 | 1,777.5 |
| Revenue Growth, % | 0 | 39.43 | 27.69 | 10.82 | 27.8 | 26.43 | 26.43 | 26.43 | 26.43 | 26.43 |
| EBITDA | 13.7 | 30.0 | 101.8 | 103.0 | 115.4 | 121.4 | 153.5 | 194.0 | 245.3 | 310.1 |
| EBITDA, % | 6.3 | 9.86 | 26.2 | 23.91 | 20.97 | 17.45 | 17.45 | 17.45 | 17.45 | 17.45 |
| Depreciation | 16.7 | 30.2 | 30.8 | 31.1 | 45.3 | 57.0 | 72.1 | 91.1 | 115.2 | 145.7 |
| Depreciation, % | 7.67 | 9.92 | 7.93 | 7.23 | 8.23 | 8.2 | 8.2 | 8.2 | 8.2 | 8.2 |
| EBIT | -3.0 | -.2 | 71.0 | 71.8 | 70.1 | 64.4 | 81.4 | 102.9 | 130.1 | 164.4 |
| EBIT, % | -1.38 | -0.06047333 | 18.27 | 16.69 | 12.74 | 9.25 | 9.25 | 9.25 | 9.25 | 9.25 |
| Total Cash | 54.8 | 63.4 | 107.8 | 101.8 | 171.3 | 178.7 | 226.0 | 285.7 | 361.2 | 456.7 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 11.4 | 8.2 | 9.4 | 9.1 | 18.3 | 21.9 | 27.7 | 35.1 | 44.3 | 56.1 |
| Account Receivables, % | 5.21 | 2.71 | 2.42 | 2.11 | 3.32 | 3.15 | 3.15 | 3.15 | 3.15 | 3.15 |
| Inventories | 2.0 | 1.7 | 1.4 | 1.5 | 4.7 | 4.3 | 5.4 | 6.8 | 8.6 | 10.9 |
| Inventories, % | 0.93756 | 0.54557 | 0.37142 | 0.35538 | 0.8455 | 0.61109 | 0.61109 | 0.61109 | 0.61109 | 0.61109 |
| Accounts Payable | 5.2 | 12.9 | 12.7 | 15.3 | 15.3 | 22.5 | 28.5 | 36.0 | 45.6 | 57.6 |
| Accounts Payable, % | 2.38 | 4.23 | 3.26 | 3.56 | 2.78 | 3.24 | 3.24 | 3.24 | 3.24 | 3.24 |
| Capital Expenditure | -24.0 | -10.7 | -10.0 | -19.6 | -60.2 | -45.3 | -57.3 | -72.5 | -91.6 | -115.9 |
| Capital Expenditure, % | -11.02 | -3.52 | -2.58 | -4.55 | -10.93 | -6.52 | -6.52 | -6.52 | -6.52 | -6.52 |
| Tax Rate, % | -18.32 | -18.32 | -18.32 | -18.32 | -18.32 | -18.32 | -18.32 | -18.32 | -18.32 | -18.32 |
| EBITAT | -4.1 | -.2 | 52.0 | 163.4 | 82.9 | 60.9 | 77.0 | 97.4 | 123.1 | 155.7 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -19.6 | 30.5 | 71.6 | 177.9 | 55.7 | 76.6 | 90.8 | 114.8 | 145.2 | 183.5 |
| WACC, % | 9.83 | 9.83 | 7.58 | 9.83 | 9.83 | 9.38 | 9.38 | 9.38 | 9.38 | 9.38 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 452.3 | |||||||||
| Long Term Growth Rate, % | 0.50 | |||||||||
| Free cash flow (T + 1) | 184 | |||||||||
| Terminal Value | 2,077 | |||||||||
| Present Terminal Value | 1,327 | |||||||||
| Enterprise Value | 1,779 | |||||||||
| Net Debt | 849 | |||||||||
| Equity Value | 930 | |||||||||
| Diluted Shares Outstanding, MM | 30 | |||||||||
| Equity Value Per Share | 30.71 |
What You Will Get
- Pre-Filled Financial Model: Century Casinos’ actual data allows for accurate DCF valuation.
- Full Forecast Control: Modify revenue growth, profit margins, WACC, and other essential drivers.
- Instant Calculations: Real-time updates ensure you see results immediately as adjustments are made.
- Investor-Ready Template: A polished Excel file crafted for high-quality valuation presentations.
- Customizable and Reusable: Designed for adaptability, enabling repeated use for comprehensive forecasts.
Key Features
- Comprehensive Financial Data: Gain access to precise pre-loaded historical figures and future forecasts for Century Casinos, Inc. (CNTY).
- Adjustable Forecast Parameters: Modify highlighted cells for key metrics such as WACC, growth rates, and profit margins.
- Real-Time Calculations: Enjoy automatic updates for DCF, Net Present Value (NPV), and cash flow assessments.
- Intuitive Visual Dashboard: Utilize clear charts and summaries to effectively visualize your valuation outcomes.
- Designed for All Skill Levels: A user-friendly layout tailored for investors, CFOs, and consultants alike.
How It Works
- Step 1: Download the Excel file for Century Casinos, Inc. (CNTY).
- Step 2: Review Century Casinos' pre-filled financial data and forecasts.
- Step 3: Modify key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you adjust your assumptions.
- Step 5: Analyze the outputs and leverage the results for your investment decisions.
Why Choose This Calculator?
- Accurate Data: Reliable financials from Century Casinos, Inc. ensure trustworthy valuation results.
- Customizable: Tailor key metrics such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Pre-configured calculations save you the hassle of starting from the ground up.
- Professional-Grade Tool: Crafted for investors, analysts, and consultants in the gaming industry.
- User-Friendly: Easy-to-navigate design and clear instructions cater to users of all experience levels.
Who Should Use This Product?
- Casino Management Students: Understand gaming operations and financial analysis using real industry data.
- Researchers: Utilize advanced models for studies related to the gaming and hospitality sectors.
- Investors: Evaluate your own strategies and assess valuation metrics for Century Casinos, Inc. (CNTY).
- Financial Analysts: Enhance your analysis with a customizable financial model tailored for the gaming industry.
- Entrepreneurs: Discover how public gaming companies like Century Casinos, Inc. (CNTY) are assessed and valued.
What the Century Casinos Template Contains
- Comprehensive DCF Model: Editable template featuring detailed valuation calculations for Century Casinos, Inc. (CNTY).
- Real-World Data: Century Casinos' historical and projected financials preloaded for in-depth analysis.
- Customizable Parameters: Modify WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights into the company's performance.
- Key Ratios: Integrated analysis for assessing profitability, efficiency, and leverage specific to Century Casinos.
- Dashboard with Visual Outputs: Graphs and tables designed for clear, actionable results tailored to Century Casinos, Inc. (CNTY).