|
Playags, Inc. (AGS) Valoración de DCF
US | Consumer Cyclical | Gambling, Resorts & Casinos | NYSE
|
- ✓ Completamente Editable: Adáptelo A Sus Necesidades En Excel O Sheets
- ✓ Diseño Profesional: Plantillas Confiables Y Estándares De La Industria
- ✓ Predeterminadas Para Un Uso Rápido Y Eficiente
- ✓ No Se Necesita Experiencia; Fáciles De Seguir
PlayAGS, Inc. (AGS) Bundle
¡Simplifique la valoración de Playags, Inc. (AGS) con esta calculadora DCF personalizable! Con Real Playags, Inc. (AGS) financieras y entradas de pronóstico ajustables, puede probar escenarios y descubrir Playags, Inc. (AGS) valor razonable en minutos.
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 | 304.7 | 167.0 | 259.7 | 309.4 | 356.5 | 396.4 | 440.6 | 489.9 | 544.6 | 605.4 |
Revenue Growth, % | 0 | -45.19 | 55.5 | 19.15 | 15.22 | 11.17 | 11.17 | 11.17 | 11.17 | 11.17 |
EBITDA | 110.8 | 36.4 | 93.5 | 105.9 | 136.1 | 132.0 | 146.8 | 163.2 | 181.4 | 201.6 |
EBITDA, % | 36.35 | 21.8 | 36.01 | 34.21 | 38.17 | 33.31 | 33.31 | 33.31 | 33.31 | 33.31 |
Depreciation | 91.5 | 85.7 | 73.9 | 75.5 | 76.9 | 123.5 | 137.3 | 152.6 | 169.7 | 188.7 |
Depreciation, % | 30.02 | 51.33 | 28.47 | 24.4 | 21.58 | 31.16 | 31.16 | 31.16 | 31.16 | 31.16 |
EBIT | 19.3 | -49.3 | 19.6 | 30.3 | 59.1 | 8.5 | 9.5 | 10.5 | 11.7 | 13.0 |
EBIT, % | 6.33 | -29.53 | 7.54 | 9.81 | 16.59 | 2.15 | 2.15 | 2.15 | 2.15 | 2.15 |
Total Cash | 13.2 | 81.7 | 95.0 | 37.9 | 50.9 | 92.2 | 102.5 | 114.0 | 126.7 | 140.9 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 61.2 | 41.7 | 49.4 | 59.9 | 68.5 | 81.4 | 90.5 | 100.6 | 111.8 | 124.3 |
Account Receivables, % | 20.09 | 24.99 | 19.03 | 19.36 | 19.21 | 20.54 | 20.54 | 20.54 | 20.54 | 20.54 |
Inventories | 32.9 | 26.9 | 27.5 | 35.4 | 36.1 | 46.8 | 52.0 | 57.9 | 64.3 | 71.5 |
Inventories, % | 10.79 | 16.11 | 10.6 | 11.44 | 10.12 | 11.81 | 11.81 | 11.81 | 11.81 | 11.81 |
Accounts Payable | 15.6 | 9.5 | 9.4 | 15.2 | 5.4 | 16.6 | 18.4 | 20.5 | 22.8 | 25.3 |
Accounts Payable, % | 5.12 | 5.72 | 3.63 | 4.93 | 1.52 | 4.18 | 4.18 | 4.18 | 4.18 | 4.18 |
Capital Expenditure | -71.1 | -35.7 | -51.5 | -69.2 | -61.9 | -82.7 | -91.9 | -102.2 | -113.6 | -126.3 |
Capital Expenditure, % | -23.32 | -21.38 | -19.84 | -22.38 | -17.37 | -20.86 | -20.86 | -20.86 | -20.86 | -20.86 |
Tax Rate, % | 75.01 | 75.01 | 75.01 | 75.01 | 75.01 | 75.01 | 75.01 | 75.01 | 75.01 | 75.01 |
EBITAT | 13.1 | -46.1 | 17.8 | 23.8 | 14.8 | 6.1 | 6.7 | 7.5 | 8.3 | 9.2 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -45.0 | 23.3 | 31.8 | 17.5 | 10.7 | 34.4 | 39.7 | 44.1 | 49.0 | 54.5 |
WACC, % | 10.68 | 12.15 | 12.01 | 11.28 | 8.22 | 10.87 | 10.87 | 10.87 | 10.87 | 10.87 |
PV UFCF | ||||||||||
SUM PV UFCF | 160.6 | |||||||||
Long Term Growth Rate, % | 4.00 | |||||||||
Free cash flow (T + 1) | 57 | |||||||||
Terminal Value | 825 | |||||||||
Present Terminal Value | 493 | |||||||||
Enterprise Value | 653 | |||||||||
Net Debt | 514 | |||||||||
Equity Value | 139 | |||||||||
Diluted Shares Outstanding, MM | 38 | |||||||||
Equity Value Per Share | 3.64 |
What You Will Get
- Real AGS Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Dynamic Calculations: Intrinsic value and NPV are computed in real-time.
- Scenario Analysis: Evaluate various scenarios to assess PlayAGS, Inc.'s future performance.
- User-Friendly Design: Tailored for professionals while remaining approachable for newcomers.
Key Features
- Comprehensive DCF Calculator: Offers detailed unlevered and levered DCF valuation frameworks.
- WACC Calculator: Features a pre-configured Weighted Average Cost of Capital sheet with adjustable inputs.
- Customizable Forecast Assumptions: Easily alter growth rates, capital expenditures, and discount rates.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios for PlayAGS, Inc. (AGS).
- Visual Dashboard and Charts: Graphical representations summarize essential valuation metrics for straightforward analysis.
How It Works
- Step 1: Download the prebuilt Excel template featuring PlayAGS, Inc.'s (AGS) data.
- Step 2: Navigate through the pre-filled sheets to familiarize yourself with the essential metrics.
- Step 3: Adjust forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly see the recalculated results, including PlayAGS, Inc.'s (AGS) intrinsic value.
- Step 5: Utilize the outputs to make informed investment decisions or create reports.
Why Choose This Calculator for PlayAGS, Inc. (AGS)?
- Accurate Data: Access real PlayAGS financials for trustworthy valuation outcomes.
- Customizable: Tailor essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Built-in calculations streamline the process, so you don’t have to start from scratch.
- Professional-Grade Tool: Crafted for investors, analysts, and consultants in the gaming industry.
- User-Friendly: Easy-to-navigate layout and clear, step-by-step guidance cater to all users.
Who Should Use This Product?
- Gaming Industry Students: Explore game development strategies and apply them using real-world examples.
- Researchers: Integrate industry best practices and analytics into academic projects.
- Investors: Evaluate your own insights and assess valuation metrics for PlayAGS, Inc. (AGS).
- Market Analysts: Enhance your analysis with a tailored, ready-to-use financial model.
- Entrepreneurs: Understand how gaming companies like PlayAGS, Inc. (AGS) are valued in the market.
What the Template Contains
- Pre-Filled DCF Model: PlayAGS, Inc.'s (AGS) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate PlayAGS, Inc.'s (AGS) 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.