|
FG Financial Group, Inc. (FGF) DCF Valoración
US | Financial Services | Insurance - Diversified | 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
FG Financial Group, Inc. (FGF) Bundle
Ya sea que sea un inversor o un analista, esta calculadora DCF (FGF) es su herramienta esencial para una valoración precisa. Precedidos con los datos reales de FG Financial Group, Inc., puede ajustar los pronósticos y observar los efectos en tiempo real.
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 | 5.5 | -17.2 | 7.6 | 20.1 | 26.8 | 22.4 | 18.7 | 15.6 | 13.0 | 10.8 |
| Revenue Growth, % | 0 | -412.15 | -144.27 | 164.58 | 33.58 | -16.61 | -16.61 | -16.61 | -16.61 | -16.61 |
| EBITDA | 2.4 | -22.5 | .0 | 1.1 | 3.4 | 7.2 | 6.0 | 5.0 | 4.2 | 3.5 |
| EBITDA, % | 43.36 | 130.9 | 0 | 5.41 | 12.79 | 32.31 | 32.31 | 32.31 | 32.31 | 32.31 |
| Depreciation | 1.1 | 1.1 | 1.3 | 1.4 | .0 | 1.7 | 1.4 | 1.2 | 1.0 | .8 |
| Depreciation, % | 20.18 | -6.13 | 17.2 | 6.95 | 0 | 7.64 | 7.64 | 7.64 | 7.64 | 7.64 |
| EBIT | 1.3 | -23.5 | -1.3 | -.3 | 3.4 | 5.2 | 4.4 | 3.7 | 3.0 | 2.5 |
| EBIT, % | 23.18 | 137.02 | -17.2 | -1.54 | 12.79 | 23.45 | 23.45 | 23.45 | 23.45 | 23.45 |
| Total Cash | 28.5 | 12.1 | 15.5 | 3.0 | 2.4 | 6.9 | 5.7 | 4.8 | 4.0 | 3.3 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 1.3 | .0 | .0 | 9.3 | 21.6 | 6.7 | 5.6 | 4.7 | 3.9 | 3.3 |
| Account Receivables, % | 23.85 | 0 | 0 | 46.13 | 80.36 | 30.07 | 30.07 | 30.07 | 30.07 | 30.07 |
| Inventories | -29.8 | -13.9 | -15.5 | 12.6 | .0 | -2.5 | -2.1 | -1.8 | -1.5 | -1.2 |
| Inventories, % | -542.58 | 80.76 | -204.63 | 62.5 | 0 | -11.35 | -11.35 | -11.35 | -11.35 | -11.35 |
| Accounts Payable | .4 | .5 | .5 | .7 | .2 | .7 | .6 | .5 | .4 | .3 |
| Accounts Payable, % | 7.28 | -2.65 | 6.61 | 3.6 | 0.76745 | 3.12 | 3.12 | 3.12 | 3.12 | 3.12 |
| Capital Expenditure | .0 | .0 | .0 | -.1 | .0 | .0 | .0 | .0 | .0 | .0 |
| Capital Expenditure, % | -0.05458515 | 0.07577524 | -0.18433 | -0.40309 | 0 | -0.1284 | -0.1284 | -0.1284 | -0.1284 | -0.1284 |
| Tax Rate, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| EBITAT | 1.0 | -22.8 | -1.5 | -.2 | 3.4 | 4.7 | 3.9 | 3.2 | 2.7 | 2.3 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 31.0 | -36.4 | 1.5 | -36.1 | 3.2 | 24.2 | 5.9 | 4.9 | 4.1 | 3.4 |
| WACC, % | 9.96 | 9.97 | 9.97 | 9.96 | 9.97 | 9.97 | 9.97 | 9.97 | 9.97 | 9.97 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 35.5 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 3 | |||||||||
| Terminal Value | 44 | |||||||||
| Present Terminal Value | 27 | |||||||||
| Enterprise Value | 63 | |||||||||
| Net Debt | -2 | |||||||||
| Equity Value | 65 | |||||||||
| Diluted Shares Outstanding, MM | 0 | |||||||||
| Equity Value Per Share | 162.54 |
What You Will Get
- Comprehensive FGF Financials: Access 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 computed automatically.
- Scenario Analysis: Evaluate various scenarios to assess FG Financial Group, Inc.'s future performance.
- User-Friendly Interface: Designed for professionals while remaining accessible to newcomers.
Key Features
- Comprehensive Financial Analysis Tool: Offers in-depth unlevered and levered DCF valuation models tailored for FG Financial Group, Inc. (FGF).
- WACC Calculation Module: Features a pre-configured Weighted Average Cost of Capital sheet with adjustable parameters.
- Customizable Forecast Inputs: Easily alter growth projections, capital expenditures, and discount rates to suit your analysis.
- Integrated Financial Metrics: Evaluate profitability, leverage, and efficiency ratios specifically for FG Financial Group, Inc. (FGF).
- Interactive Dashboard and Visualizations: Graphical representations highlight essential valuation metrics for straightforward interpretation.
How It Works
- 1. Access the Template: Download and open the Excel file containing FG Financial Group, Inc.'s (FGF) preloaded data.
- 2. Modify Assumptions: Adjust key inputs such as growth rates, WACC, and capital expenditures.
- 3. Observe Results Instantly: The DCF model automatically calculates intrinsic value and NPV.
- 4. Explore Scenarios: Analyze various forecasts to evaluate different valuation outcomes.
- 5. Utilize with Assurance: Present expert valuation insights to back your decisions.
Why Choose FG Financial Group, Inc. ([Symbol])?
- Streamlined Process: Skip the hassle of building complex financial models – our tools are ready for immediate use.
- Enhanced Precision: Access to accurate financial data and robust formulas minimizes valuation errors.
- Completely Adaptable: Modify the model to suit your specific assumptions and forecasts.
- User-Friendly: Intuitive charts and outputs simplify the analysis of results.
- Endorsed by Professionals: Crafted for experts who prioritize accuracy and functionality.
Who Should Use FG Financial Group, Inc. (FGF)?
- Investors: Gain insights and make informed choices with our comprehensive financial services.
- Financial Analysts: Streamline your analysis with our robust tools designed for efficiency and accuracy.
- Consultants: Effortlessly tailor our solutions for client briefings and strategic reports.
- Finance Enthusiasts: Enhance your knowledge of financial strategies and market trends through our resources.
- Educators and Students: Utilize our offerings as a hands-on resource for finance education and practical applications.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled FG Financial Group, Inc. (FGF) 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 FG Financial Group, Inc. (FGF).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.