International Game Technology PLC (IGT) DCF Valuation
- ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
- ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
- ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
- ✓ Aucune Expertise N'Est Requise; Facile À Suivre
International Game Technology PLC (IGT) Bundle
As an investor or analyst, the International Game Technology PLC (IGT) DCF Calculator serves as your essential tool for accurate valuation. Equipped with real data from IGT, you can modify 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 | 4,785.8 | 3,115.5 | 4,089.0 | 4,223.0 | 4,310.0 | 4,328.1 | 4,346.4 | 4,364.7 | 4,383.0 | 4,401.5 |
| Revenue Growth, % | 0 | -34.9 | 31.25 | 3.28 | 2.06 | 0.42098 | 0.42098 | 0.42098 | 0.42098 | 0.42098 |
| EBITDA | 1,165.2 | 136.4 | 1,409.0 | 1,576.0 | 1,585.0 | 1,188.3 | 1,193.3 | 1,198.3 | 1,203.4 | 1,208.4 |
| EBITDA, % | 24.35 | 4.38 | 34.46 | 37.32 | 36.77 | 27.46 | 27.46 | 27.46 | 27.46 | 27.46 |
| Depreciation | 613.9 | 566.2 | 526.0 | 685.0 | 523.0 | 625.2 | 627.8 | 630.4 | 633.1 | 635.8 |
| Depreciation, % | 12.83 | 18.17 | 12.86 | 16.22 | 12.13 | 14.44 | 14.44 | 14.44 | 14.44 | 14.44 |
| EBIT | 551.3 | -429.8 | 883.0 | 891.0 | 1,062.0 | 563.1 | 565.5 | 567.9 | 570.3 | 572.7 |
| EBIT, % | 11.52 | -13.8 | 21.59 | 21.1 | 24.64 | 13.01 | 13.01 | 13.01 | 13.01 | 13.01 |
| Total Cash | 662.9 | 907.0 | 591.0 | 590.0 | 572.0 | 732.9 | 735.9 | 739.0 | 742.1 | 745.3 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 1,149.7 | 1,231.3 | 1,122.0 | 1,038.0 | 965.0 | 1,194.2 | 1,199.2 | 1,204.3 | 1,209.3 | 1,214.4 |
| Account Receivables, % | 24.02 | 39.52 | 27.44 | 24.58 | 22.39 | 27.59 | 27.59 | 27.59 | 27.59 | 27.59 |
| Inventories | 161.8 | 169.2 | 183.0 | 254.0 | 317.0 | 230.8 | 231.7 | 232.7 | 233.7 | 234.7 |
| Inventories, % | 3.38 | 5.43 | 4.48 | 6.01 | 7.35 | 5.33 | 5.33 | 5.33 | 5.33 | 5.33 |
| Accounts Payable | 1,041.8 | 1,126.0 | 1,035.0 | 731.0 | 797.0 | 1,030.3 | 1,034.7 | 1,039.0 | 1,043.4 | 1,047.8 |
| Accounts Payable, % | 21.77 | 36.14 | 25.31 | 17.31 | 18.49 | 23.81 | 23.81 | 23.81 | 23.81 | 23.81 |
| Capital Expenditure | -442.1 | -254.7 | -238.0 | -317.0 | -399.0 | -346.2 | -347.7 | -349.1 | -350.6 | -352.1 |
| Capital Expenditure, % | -9.24 | -8.18 | -5.82 | -7.51 | -9.26 | -8 | -8 | -8 | -8 | -8 |
| Tax Rate, % | 75.2 | 75.2 | 75.2 | 75.2 | 75.2 | 75.2 | 75.2 | 75.2 | 75.2 | 75.2 |
| EBITAT | 216.2 | -443.9 | 425.6 | 466.7 | 263.4 | 298.0 | 299.3 | 300.5 | 301.8 | 303.1 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 118.3 | -137.2 | 718.2 | 543.7 | 463.4 | 667.3 | 577.7 | 580.2 | 582.6 | 585.0 |
| WACC, % | 6.38 | 8.39 | 6.68 | 6.82 | 5.9 | 6.84 | 6.84 | 6.84 | 6.84 | 6.84 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 2,474.1 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 597 | |||||||||
| Terminal Value | 12,341 | |||||||||
| Present Terminal Value | 8,867 | |||||||||
| Enterprise Value | 11,341 | |||||||||
| Net Debt | 5,352 | |||||||||
| Equity Value | 5,989 | |||||||||
| Diluted Shares Outstanding, MM | 203 | |||||||||
| Equity Value Per Share | 29.50 |
What You Will Get
- Real IGT Financial Data: Pre-filled with International Game Technology's historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See IGT's intrinsic value update instantly based on your changes.
- Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
- User-Friendly Design: Simple structure and clear instructions for all experience levels.
Key Features
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for International Game Technology PLC (IGT).
- WACC Calculator: Pre-configured Weighted Average Cost of Capital sheet with adjustable inputs for precise calculations.
- Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates to fit specific scenarios.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specific to International Game Technology PLC (IGT).
- Interactive Dashboard and Charts: Visual representations summarize essential valuation metrics for straightforward analysis.
How It Works
- Download the Template: Gain immediate access to the Excel-based IGT DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and more.
- Instant Calculations: The model automatically recalculates IGT’s intrinsic value.
- Test Scenarios: Experiment with different assumptions to assess potential valuation shifts.
- Analyze and Decide: Leverage the results to inform your investment or financial analysis.
Why Choose This Calculator for International Game Technology PLC (IGT)?
- User-Friendly Interface: Suitable for both novices and seasoned professionals.
- Customizable Inputs: Modify parameters easily to tailor your financial analysis.
- Real-Time Valuation: Observe immediate updates to IGT’s valuation as you change inputs.
- Preloaded Data: Comes with IGT’s actual financial metrics for swift evaluations.
- Relied Upon by Experts: Utilized by investors and analysts for making well-informed choices.
Who Should Use This Product?
- Investors: Evaluate IGT’s valuation to make informed decisions on stock trades.
- CFOs and Financial Analysts: Enhance valuation methodologies and assess future projections.
- Game Developers: Understand how leading gaming companies like IGT are valued in the market.
- Consultants: Provide detailed valuation analyses and reports for clients in the gaming industry.
- Students and Educators: Utilize current data to learn and teach valuation strategies in gaming and entertainment.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled International Game Technology PLC (IGT) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for International Game Technology PLC (IGT).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.