PLAYSTUDIOS, Inc. (MYPS) DCF Valuation
- ✓ 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
PLAYSTUDIOS, Inc. (MYPS) Bundle
Whether you’re an investor or an analyst, this MYPS DCF Calculator is your go-to tool for accurate valuation. Preloaded with PLAYSTUDIOS, Inc. real data, you can adjust forecasts and observe the effects in real-time.
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 | 239.4 | 269.9 | 287.4 | 290.3 | 310.9 | 332.1 | 354.8 | 379.0 | 404.9 | 432.6 |
Revenue Growth, % | 0 | 12.72 | 6.5 | 1.01 | 7.09 | 6.83 | 6.83 | 6.83 | 6.83 | 6.83 |
EBITDA | 43.0 | 33.5 | 27.5 | 20.5 | 43.4 | 40.5 | 43.2 | 46.2 | 49.3 | 52.7 |
EBITDA, % | 17.96 | 12.4 | 9.56 | 7.06 | 13.95 | 12.19 | 12.19 | 12.19 | 12.19 | 12.19 |
Depreciation | 25.2 | 22.2 | 27.4 | 35.6 | 45.3 | 36.6 | 39.1 | 41.7 | 44.6 | 47.6 |
Depreciation, % | 10.51 | 8.22 | 9.53 | 12.25 | 14.56 | 11.01 | 11.01 | 11.01 | 11.01 | 11.01 |
EBIT | 17.9 | 11.3 | .1 | -15.1 | -1.9 | 3.9 | 4.2 | 4.4 | 4.8 | 5.1 |
EBIT, % | 7.46 | 4.18 | 0.03200902 | -5.19 | -0.61212 | 1.17 | 1.17 | 1.17 | 1.17 | 1.17 |
Total Cash | 31.0 | 48.9 | 213.5 | 134.0 | 132.9 | 129.0 | 137.9 | 147.3 | 157.3 | 168.1 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 14.2 | 23.6 | 22.8 | 28.4 | 33.9 | 28.8 | 30.7 | 32.8 | 35.1 | 37.5 |
Account Receivables, % | 5.95 | 8.74 | 7.94 | 9.78 | 10.9 | 8.66 | 8.66 | 8.66 | 8.66 | 8.66 |
Inventories | .0 | 2.4 | 5.1 | 5.1 | .0 | 2.9 | 3.1 | 3.4 | 3.6 | 3.8 |
Inventories, % | 0 | 0.90002 | 1.76 | 1.77 | 0 | 0.88669 | 0.88669 | 0.88669 | 0.88669 | 0.88669 |
Accounts Payable | 5.4 | 4.7 | 7.8 | 4.4 | 1.9 | 5.9 | 6.3 | 6.7 | 7.2 | 7.6 |
Accounts Payable, % | 2.23 | 1.75 | 2.71 | 1.52 | 0.61341 | 1.77 | 1.77 | 1.77 | 1.77 | 1.77 |
Capital Expenditure | -25.3 | -27.0 | -40.9 | -33.4 | -6.3 | -32.1 | -34.3 | -36.6 | -39.1 | -41.8 |
Capital Expenditure, % | -10.56 | -10.01 | -14.23 | -11.5 | -2.04 | -9.67 | -9.67 | -9.67 | -9.67 | -9.67 |
Tax Rate, % | -669.56 | -669.56 | -669.56 | -669.56 | -669.56 | -669.56 | -669.56 | -669.56 | -669.56 | -669.56 |
EBITAT | 13.8 | 13.0 | .1 | -11.3 | -14.6 | 3.5 | 3.8 | 4.0 | 4.3 | 4.6 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 4.8 | -4.2 | -12.2 | -18.2 | 21.4 | 14.1 | 6.8 | 7.2 | 7.7 | 8.3 |
WACC, % | 7.21 | 7.25 | 7.25 | 7.21 | 7.25 | 7.24 | 7.24 | 7.24 | 7.24 | 7.24 |
PV UFCF | ||||||||||
SUM PV UFCF | 36.7 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 8 | |||||||||
Terminal Value | 161 | |||||||||
Present Terminal Value | 114 | |||||||||
Enterprise Value | 150 | |||||||||
Net Debt | -123 | |||||||||
Equity Value | 273 | |||||||||
Diluted Shares Outstanding, MM | 133 | |||||||||
Equity Value Per Share | 2.05 |
What You Will Get
- Authentic MYPS Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Real-Time Calculations: Intrinsic value and NPV are calculated automatically.
- Scenario Analysis: Explore various scenarios to assess PLAYSTUDIOS' future performance.
- User-Friendly Design: Designed for professionals while being approachable for newcomers.
Key Features
- Comprehensive Financial Data: PLAYSTUDIOS, Inc.'s historical financial statements and pre-filled projections.
- Customizable Parameters: Adjust WACC, tax rates, revenue growth, and EBITDA margins to fit your analysis.
- Real-Time Valuation: Observe PLAYSTUDIOS, Inc.'s intrinsic value update instantly.
- Intuitive Visualizations: Dashboard charts illustrate valuation outcomes and essential metrics.
- Designed for Precision: A professional-grade tool for analysts, investors, and finance specialists.
How It Works
- Download: Obtain the pre-configured Excel file featuring PLAYSTUDIOS, Inc.'s (MYPS) financial data.
- Customize: Modify projections, such as revenue growth, EBITDA %, and WACC as per your analysis.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time for accuracy.
- Test Scenarios: Develop various projections and evaluate results immediately.
- Make Decisions: Leverage the valuation insights to inform your investment strategy.
Why Choose This Calculator for PLAYSTUDIOS, Inc. (MYPS)?
- Accurate Data: Real PLAYSTUDIOS financials ensure reliable valuation results.
- Customizable: Adjust key parameters like growth rates, WACC, and tax rates to align with your projections.
- Time-Saving: Pre-built calculations eliminate the hassle of starting from scratch.
- Professional-Grade Tool: Tailored for investors, analysts, and consultants in the gaming industry.
- User-Friendly: Intuitive design and step-by-step guidance make it accessible for all users.
Who Should Use This Product?
- Investors: Assess PLAYSTUDIOS, Inc. (MYPS) valuation prior to making stock transactions.
- CFOs and Financial Analysts: Optimize valuation methodologies and evaluate financial forecasts.
- Startup Founders: Understand the valuation strategies of successful gaming companies like PLAYSTUDIOS, Inc. (MYPS).
- Consultants: Provide detailed valuation analyses and reports for clients in the gaming industry.
- Students and Educators: Utilize real-time data to learn and teach valuation principles effectively.
What the Template Contains
- Preloaded MYPS Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
- DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
- Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.