|
Playtika Holding Corp. (PLTK) Valoración de DCF
IL | Technology | Electronic Gaming & Multimedia | NASDAQ
|
- ✓ 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
Playtika Holding Corp. (PLTK) Bundle
¡Simplifique la valoración de Playtika Holding Corp. (PLTK) con esta calculadora DCF personalizable! Con el Real Playtika Holding Corp. (PLTK) Financials y las entradas de pronóstico ajustables, puede probar escenarios y descubrir el valor razonable de Playtika Holding Corp. (PLTK) 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 | 1,887.6 | 2,371.5 | 2,583.0 | 2,615.5 | 2,567.0 | 2,784.9 | 3,021.4 | 3,277.9 | 3,556.1 | 3,858.0 |
Revenue Growth, % | 0 | 25.64 | 8.92 | 1.26 | -1.85 | 8.49 | 8.49 | 8.49 | 8.49 | 8.49 |
EBITDA | 570.4 | 511.9 | 703.1 | 640.3 | 703.6 | 729.2 | 791.1 | 858.2 | 931.1 | 1,010.1 |
EBITDA, % | 30.22 | 21.59 | 27.22 | 24.48 | 27.41 | 26.18 | 26.18 | 26.18 | 26.18 | 26.18 |
Depreciation | 73.0 | 119.2 | 145.5 | 162.0 | 158.0 | 149.7 | 162.4 | 176.2 | 191.1 | 207.4 |
Depreciation, % | 3.87 | 5.03 | 5.63 | 6.19 | 6.16 | 5.38 | 5.38 | 5.38 | 5.38 | 5.38 |
EBIT | 497.4 | 392.7 | 557.6 | 478.3 | 545.6 | 579.5 | 628.7 | 682.0 | 740.0 | 802.8 |
EBIT, % | 26.35 | 16.56 | 21.59 | 18.29 | 21.25 | 20.81 | 20.81 | 20.81 | 20.81 | 20.81 |
Total Cash | 266.8 | 520.1 | 1,117.1 | 768.7 | 1,029.7 | 828.9 | 899.3 | 975.6 | 1,058.4 | 1,148.3 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 125.7 | 129.3 | 143.7 | 141.1 | 171.5 | 165.7 | 179.8 | 195.0 | 211.6 | 229.6 |
Account Receivables, % | 6.66 | 5.45 | 5.56 | 5.39 | 6.68 | 5.95 | 5.95 | 5.95 | 5.95 | 5.95 |
Inventories | 17.2 | 21.3 | 22.7 | 1.7 | .0 | 15.3 | 16.6 | 18.0 | 19.6 | 21.2 |
Inventories, % | 0.91121 | 0.89817 | 0.87882 | 0.06499713 | 0 | 0.55064 | 0.55064 | 0.55064 | 0.55064 | 0.55064 |
Accounts Payable | 54.1 | 34.6 | 45.7 | 50.7 | 65.0 | 58.8 | 63.8 | 69.3 | 75.1 | 81.5 |
Accounts Payable, % | 2.87 | 1.46 | 1.77 | 1.94 | 2.53 | 2.11 | 2.11 | 2.11 | 2.11 | 2.11 |
Capital Expenditure | -92.4 | -98.1 | -99.6 | -110.0 | -32.6 | -102.3 | -111.0 | -120.4 | -130.6 | -141.7 |
Capital Expenditure, % | -4.9 | -4.14 | -3.86 | -4.21 | -1.27 | -3.67 | -3.67 | -3.67 | -3.67 | -3.67 |
Tax Rate, % | 40.07 | 40.07 | 40.07 | 40.07 | 40.07 | 40.07 | 40.07 | 40.07 | 40.07 | 40.07 |
EBITAT | 329.4 | 186.0 | 421.2 | 365.0 | 327.0 | 377.1 | 409.1 | 443.8 | 481.5 | 522.4 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 221.2 | 179.9 | 462.4 | 445.6 | 438.0 | 408.8 | 450.2 | 488.4 | 529.8 | 574.8 |
WACC, % | 6.21 | 5.63 | 6.5 | 6.52 | 6.02 | 6.18 | 6.18 | 6.18 | 6.18 | 6.18 |
PV UFCF | ||||||||||
SUM PV UFCF | 2,035.2 | |||||||||
Long Term Growth Rate, % | 3.00 | |||||||||
Free cash flow (T + 1) | 592 | |||||||||
Terminal Value | 18,635 | |||||||||
Present Terminal Value | 13,809 | |||||||||
Enterprise Value | 15,844 | |||||||||
Net Debt | 1,494 | |||||||||
Equity Value | 14,350 | |||||||||
Diluted Shares Outstanding, MM | 367 | |||||||||
Equity Value Per Share | 39.12 |
What You Will Get
- Real PLTK 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: Explore various scenarios to assess Playtika's future performance.
- User-Friendly Design: Crafted for professionals while remaining approachable for newcomers.
Key Features
- Pre-Loaded Data: Playtika’s historical financial statements and pre-filled forecasts.
- Fully Adjustable Inputs: Customize WACC, tax rates, revenue growth, and EBITDA margins.
- Instant Results: View Playtika’s intrinsic value recalculated in real time.
- Clear Visual Outputs: Dashboard charts showcase valuation results and key metrics.
- Built for Accuracy: A professional tool designed for analysts, investors, and finance experts.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Playtika data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Playtika’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for Playtika Holding Corp. (PLTK)?
- Comprehensive Tool: Combines DCF, WACC, and financial ratio analyses specifically for Playtika Holding Corp. (PLTK).
- Customizable Inputs: Modify the yellow-highlighted cells to explore different scenarios for Playtika Holding Corp. (PLTK).
- Detailed Insights: Automatically computes Playtika Holding Corp.'s (PLTK) intrinsic value and Net Present Value.
- Preloaded Data: Access historical and forecasted data tailored to Playtika Holding Corp. (PLTK) for precise calculations.
- Professional Quality: Perfect for financial analysts, investors, and business consultants focusing on Playtika Holding Corp. (PLTK).
Who Should Use Playtika's Products?
- Game Developers: Leverage advanced tools to enhance game design and user experience.
- Data Analysts: Utilize robust analytics to gain insights into player behavior and trends.
- Marketing Professionals: Quickly tailor campaigns based on player engagement metrics.
- Investors: Make informed decisions with comprehensive data on market performance.
- Students and Educators: Use Playtika's resources as a practical case study in gaming and business courses.
What the Template Contains
- Preloaded PLTK 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.