Inspired Entertainment, Inc. (INSE) 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
Inspired Entertainment, Inc. (INSE) Bundle
As an investor or analyst, this (INSE) DCF Calculator serves as your go-to resource for accurate valuation. Featuring real data from Inspired Entertainment, Inc., you can adjust forecasts and immediately observe the effects.
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 | 153.4 | 199.8 | 208.9 | 285.4 | 323.0 | 391.3 | 474.1 | 574.3 | 695.8 | 843.0 |
Revenue Growth, % | 0 | 30.25 | 4.55 | 36.62 | 13.17 | 21.15 | 21.15 | 21.15 | 21.15 | 21.15 |
EBITDA | 32.5 | 53.0 | 53.9 | 90.7 | 84.0 | 102.8 | 124.5 | 150.8 | 182.7 | 221.4 |
EBITDA, % | 21.19 | 26.53 | 25.8 | 31.78 | 26.01 | 26.26 | 26.26 | 26.26 | 26.26 | 26.26 |
Depreciation | 43.0 | 55.9 | 53.3 | 43.4 | 43.7 | 86.3 | 104.5 | 126.7 | 153.4 | 185.9 |
Depreciation, % | 28.03 | 27.98 | 25.51 | 15.21 | 13.53 | 22.05 | 22.05 | 22.05 | 22.05 | 22.05 |
EBIT | -10.5 | -2.9 | .6 | 47.3 | 40.3 | 16.5 | 19.9 | 24.2 | 29.3 | 35.5 |
EBIT, % | -6.84 | -1.45 | 0.28722 | 16.57 | 12.48 | 4.21 | 4.21 | 4.21 | 4.21 | 4.21 |
Total Cash | 29.1 | 47.1 | 47.8 | 25.0 | 40.0 | 67.8 | 82.1 | 99.4 | 120.5 | 145.9 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 39.5 | 35.7 | 31.7 | 58.4 | 64.6 | 77.7 | 94.1 | 114.0 | 138.1 | 167.3 |
Account Receivables, % | 25.75 | 17.87 | 15.17 | 20.46 | 20 | 19.85 | 19.85 | 19.85 | 19.85 | 19.85 |
Inventories | 18.8 | 17.6 | 16.9 | 31.0 | 32.3 | 39.1 | 47.4 | 57.5 | 69.6 | 84.3 |
Inventories, % | 12.26 | 8.81 | 8.09 | 10.86 | 10 | 10 | 10 | 10 | 10 | 10 |
Accounts Payable | 22.2 | 17.9 | 20.8 | 23.7 | 41.9 | 42.8 | 51.8 | 62.8 | 76.1 | 92.2 |
Accounts Payable, % | 14.47 | 8.96 | 9.96 | 8.3 | 12.97 | 10.93 | 10.93 | 10.93 | 10.93 | 10.93 |
Capital Expenditure | -27.5 | -29.9 | -25.4 | -39.8 | -47.8 | -57.8 | -70.0 | -84.8 | -102.7 | -124.4 |
Capital Expenditure, % | -17.93 | -14.96 | -12.16 | -13.95 | -14.8 | -14.76 | -14.76 | -14.76 | -14.76 | -14.76 |
Tax Rate, % | 39.68 | 39.68 | 39.68 | 39.68 | 39.68 | 39.68 | 39.68 | 39.68 | 39.68 | 39.68 |
EBITAT | -10.5 | -2.9 | .6 | 38.2 | 24.3 | 14.4 | 17.4 | 21.1 | 25.6 | 31.0 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -31.1 | 23.8 | 36.1 | 3.9 | 30.9 | 23.9 | 36.3 | 44.0 | 53.3 | 64.6 |
WACC, % | 10.11 | 10.11 | 9.89 | 9.1 | 8.03 | 9.45 | 9.45 | 9.45 | 9.45 | 9.45 |
PV UFCF | ||||||||||
SUM PV UFCF | 164.1 | |||||||||
Long Term Growth Rate, % | 3.00 | |||||||||
Free cash flow (T + 1) | 67 | |||||||||
Terminal Value | 1,032 | |||||||||
Present Terminal Value | 657 | |||||||||
Enterprise Value | 821 | |||||||||
Net Debt | 292 | |||||||||
Equity Value | 530 | |||||||||
Diluted Shares Outstanding, MM | 29 | |||||||||
Equity Value Per Share | 18.14 |
What You Will Get
- Real INSE Financial Data: Pre-filled with Inspired Entertainment’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 Inspired Entertainment’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 Inspired Entertainment, Inc. (INSE).
- WACC Calculator: Includes a pre-built Weighted Average Cost of Capital sheet with customizable inputs specific to the gaming industry.
- Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates to fit market conditions.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios for Inspired Entertainment, Inc. (INSE).
- Interactive Dashboard and Charts: Visual outputs present key valuation metrics for straightforward analysis.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Inspired Entertainment data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Inspired Entertainment’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for Inspired Entertainment, Inc. (INSE)?
- Comprehensive Tool: Offers DCF, WACC, and financial ratio analyses all in one convenient package.
- Customizable Inputs: Modify yellow-highlighted cells to explore different financial scenarios.
- Detailed Insights: Automatically computes Inspired Entertainment's intrinsic value and Net Present Value.
- Preloaded Data: Historical and projected data provide reliable starting points for analysis.
- Professional Quality: Perfect for financial analysts, investors, and business consultants focusing on (INSE).
Who Should Use This Product?
- Investors: Evaluate Inspired Entertainment, Inc.'s (INSE) market potential before making investment decisions.
- CFOs and Financial Analysts: Optimize valuation assessments and validate financial forecasts for Inspired Entertainment, Inc. (INSE).
- Startup Founders: Understand the valuation methods applied to companies like Inspired Entertainment, Inc. (INSE).
- Consultants: Provide detailed valuation insights and reports for clients regarding Inspired Entertainment, Inc. (INSE).
- Students and Educators: Utilize real-time data from Inspired Entertainment, Inc. (INSE) to enhance learning and valuation practice.
What the Template Contains
- Historical Data: Includes Inspired Entertainment’s past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Inspired Entertainment’s intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
- Quarterly and Annual Statements: A complete breakdown of Inspired Entertainment’s financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.