|
Great Elm Capital Corp. (GECC) DCF Valoración
US | Financial Services | Asset Management | 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
Great Elm Capital Corp. (GECC) Bundle
¿Busca evaluar el valor intrínseco de Great Elm Capital Corp.? Nuestra calculadora GECC DCF integra datos del mundo real con extensas características de personalización, lo que le permite refinar sus proyecciones y mejorar sus opciones de inversión.
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.8 | -28.9 | -6.6 | -16.1 | 35.8 | 37.9 | 40.0 | 42.3 | 44.7 | 47.3 |
| Revenue Growth, % | 0 | 505.14 | -77.16 | 143.82 | -322.86 | 5.71 | 5.71 | 5.71 | 5.71 | 5.71 |
| EBITDA | 22.4 | 17.0 | 17.3 | -15.3 | .0 | -12.4 | -13.1 | -13.9 | -14.6 | -15.5 |
| EBITDA, % | -469.14 | -59.03 | -262.51 | 95.37 | 0 | -32.73 | -32.73 | -32.73 | -32.73 | -32.73 |
| Depreciation | 35.7 | 36.0 | 15.4 | -97.0 | .0 | -15.1 | -16.0 | -16.9 | -17.9 | -18.9 |
| Depreciation, % | -747.92 | -124.58 | -233.79 | 603.27 | 0 | -40 | -40 | -40 | -40 | -40 |
| EBIT | -13.3 | -18.9 | 1.9 | 81.6 | .0 | 2.8 | 2.9 | 3.1 | 3.3 | 3.5 |
| EBIT, % | 278.78 | 65.55 | -28.71 | -507.9 | 0 | 7.37 | 7.37 | 7.37 | 7.37 | 7.37 |
| Total Cash | 4.6 | 52.6 | 9.1 | .6 | 1.0 | -22.5 | -23.8 | -25.2 | -26.6 | -28.1 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 3.0 | 3.3 | 4.3 | 4.9 | 4.0 | -12.0 | -12.7 | -13.4 | -14.2 | -15.0 |
| Account Receivables, % | -62.81 | -11.29 | -64.77 | -30.65 | 11.12 | -31.68 | -31.68 | -31.68 | -31.68 | -31.68 |
| Inventories | 93.3 | 131.4 | 213.4 | 81.6 | .0 | -30.3 | -32.0 | -33.9 | -35.8 | -37.8 |
| Inventories, % | -1956.71 | -455.36 | -3236.92 | -507.88 | 0 | -80 | -80 | -80 | -80 | -80 |
| Accounts Payable | 72.7 | 65.6 | 197.7 | 68.4 | 4.1 | -29.4 | -31.1 | -32.9 | -34.8 | -36.7 |
| Accounts Payable, % | -1525.14 | -227.16 | -2998.77 | -425.6 | 11.5 | -77.7 | -77.7 | -77.7 | -77.7 | -77.7 |
| Capital Expenditure | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Capital Expenditure, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Tax Rate, % | 1.12 | 1.12 | 1.12 | 1.12 | 1.12 | 1.12 | 1.12 | 1.12 | 1.12 | 1.12 |
| EBITAT | -13.7 | -18.9 | 1.9 | 83.0 | .0 | 2.8 | 2.9 | 3.1 | 3.3 | 3.5 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -1.6 | -28.5 | 66.5 | -12.2 | 18.3 | .4 | -12.3 | -13.0 | -13.8 | -14.6 |
| WACC, % | 9.69 | 9.69 | 9.69 | 9.69 | 9.63 | 9.67 | 9.67 | 9.67 | 9.67 | 9.67 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -38.5 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -15 | |||||||||
| Terminal Value | -194 | |||||||||
| Present Terminal Value | -122 | |||||||||
| Enterprise Value | -161 | |||||||||
| Net Debt | 139 | |||||||||
| Equity Value | -300 | |||||||||
| Diluted Shares Outstanding, MM | 8 | |||||||||
| Equity Value Per Share | -39.44 |
What You Will Receive
- Pre-Loaded Financial Model: Great Elm Capital Corp.'s (GECC) real data facilitates accurate DCF valuation.
- Comprehensive Forecast Control: Modify revenue growth, profit margins, WACC, and other essential factors.
- Real-Time Calculations: Automatic updates provide immediate results as you make adjustments.
- Professional-Grade Template: A polished Excel file crafted for high-quality valuation.
- Flexible and Reusable: Designed for adaptability, allowing repeated application for in-depth forecasts.
Key Features
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation frameworks specifically for Great Elm Capital Corp. (GECC).
- WACC Calculator: Pre-configured Weighted Average Cost of Capital sheet with adjustable parameters tailored for GECC.
- Customizable Forecast Assumptions: Easily alter growth projections, capital investments, and discount rates.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios pertinent to Great Elm Capital Corp. (GECC).
- Interactive Dashboard and Charts: Visual representations that condense essential valuation metrics for straightforward analysis.
How It Works
- Step 1: Download the prebuilt Excel template with Great Elm Capital Corp.'s (GECC) data included.
- Step 2: Explore the pre-filled sheets and familiarize yourself with the key metrics.
- Step 3: Update forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly view recalculated results, including Great Elm Capital Corp.'s (GECC) intrinsic value.
- Step 5: Make informed investment decisions or generate reports using the outputs.
Why Choose This Calculator for Great Elm Capital Corp. (GECC)?
- Comprehensive Tool: Integrates DCF, WACC, and financial ratio analyses tailored for Great Elm Capital Corp. (GECC).
- Customizable Inputs: Modify yellow-highlighted cells to explore different investment scenarios.
- Detailed Insights: Automatically computes Great Elm Capital Corp. (GECC)'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 focused on Great Elm Capital Corp. (GECC).
Who Should Use This Product?
- Finance Students: Master valuation techniques and apply them using real-world data from Great Elm Capital Corp. (GECC).
- Academics: Integrate professional financial models into your coursework or research focused on Great Elm Capital Corp. (GECC).
- Investors: Validate your investment hypotheses and analyze valuation outcomes for Great Elm Capital Corp. (GECC).
- Analysts: Enhance your efficiency with a customizable DCF model tailored for Great Elm Capital Corp. (GECC).
- Small Business Owners: Discover how large public companies like Great Elm Capital Corp. (GECC) are evaluated and analyzed.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Great Elm Capital Corp. (GECC) 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 Great Elm Capital Corp. (GECC).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.