PlayAGS, Inc. (AGS) 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
PlayAGS, Inc. (AGS) Bundle
Simplify PlayAGS, Inc. (AGS) valuation with this customizable DCF Calculator! Featuring real PlayAGS, Inc. (AGS) financials and adjustable forecast inputs, you can test scenarios and uncover PlayAGS, Inc. (AGS) fair value in minutes.
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.