|
Great Elm Capital Corp. (GECC) DCF Valuation
US | Financial Services | Asset Management | NASDAQ
|
- ✓ 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
Great Elm Capital Corp. (GECC) Bundle
Looking to assess the intrinsic value of Great Elm Capital Corp.? Our GECC DCF Calculator integrates real-world data with extensive customization features, enabling you to refine your projections and enhance your investment choices.
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.