|
Cion Investment Corporation (Cion) DCF Valoración
US | Financial Services | Asset Management | NYSE
|
- ✓ 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
CION Investment Corporation (CION) Bundle
¡Mejore sus opciones de inversión con la calculadora DCF de Cion Investment Corporation (Cion)! Utilice datos financieros reales, ajuste las proyecciones y gastos de crecimiento, y observe instantáneamente cómo estos cambios afectan el valor intrínseco del Cion.
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 | 59.6 | -2.2 | 132.0 | 61.1 | 251.0 | 154.6 | 95.2 | 58.6 | 36.1 | 22.2 |
Revenue Growth, % | 0 | -103.7 | -6088.2 | -53.68 | 310.56 | -38.42 | -38.42 | -38.42 | -38.42 | -38.42 |
EBITDA | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
EBITDA, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Depreciation | 74.8 | 68.2 | 7.3 | 62.0 | .0 | 32.6 | 20.1 | 12.4 | 7.6 | 4.7 |
Depreciation, % | 125.63 | -3092.33 | 5.51 | 101.43 | 0 | 21.1 | 21.1 | 21.1 | 21.1 | 21.1 |
EBIT | -74.8 | -68.2 | -7.3 | -62.0 | .0 | -32.6 | -20.1 | -12.4 | -7.6 | -4.7 |
EBIT, % | -125.63 | 3092.33 | -5.51 | -101.43 | 0 | -21.1 | -21.1 | -21.1 | -21.1 | -21.1 |
Total Cash | 6.1 | 19.9 | 3.8 | 82.7 | 121.9 | 19.1 | 11.7 | 7.2 | 4.5 | 2.7 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 38.2 | 23.7 | 24.4 | 28.8 | 37.7 | 13.8 | 8.5 | 5.3 | 3.2 | 2.0 |
Account Receivables, % | 64.15 | -1076.32 | 18.49 | 47.13 | 15.02 | 8.96 | 8.96 | 8.96 | 8.96 | 8.96 |
Inventories | 73.9 | .0 | 116.1 | .0 | .0 | 58.1 | 35.8 | 22.0 | 13.6 | 8.4 |
Inventories, % | 124.03 | -0.000045372051 | 87.96 | 0.000001635617 | 0 | 37.59 | 37.59 | 37.59 | 37.59 | 37.59 |
Accounts Payable | 5.5 | 3.3 | 17.6 | 23.8 | 26.8 | -8.6 | -5.3 | -3.3 | -2.0 | -1.2 |
Accounts Payable, % | 9.31 | -150.95 | 13.33 | 38.87 | 10.68 | -5.56 | -5.56 | -5.56 | -5.56 | -5.56 |
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, % | -0.05668696 | -0.05668696 | -0.05668696 | -0.05668696 | -0.05668696 | -0.05668696 | -0.05668696 | -0.05668696 | -0.05668696 | -0.05668696 |
EBITAT | -74.8 | -68.2 | -7.3 | -61.6 | .0 | -32.6 | -20.0 | -12.3 | -7.6 | -4.7 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -106.5 | 86.1 | -102.5 | 118.3 | -5.8 | -69.6 | 31.0 | 19.1 | 11.8 | 7.2 |
WACC, % | 8.61 | 8.61 | 8.59 | 8.57 | 8.61 | 8.6 | 8.6 | 8.6 | 8.6 | 8.6 |
PV UFCF | ||||||||||
SUM PV UFCF | -9.7 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 7 | |||||||||
Terminal Value | 112 | |||||||||
Present Terminal Value | 74 | |||||||||
Enterprise Value | 64 | |||||||||
Net Debt | 1,073 | |||||||||
Equity Value | -1,009 | |||||||||
Diluted Shares Outstanding, MM | 55 | |||||||||
Equity Value Per Share | -18.45 |
What You Will Get
- Comprehensive Financial Model: CION Investment Corporation’s (CION) actual data allows for accurate DCF valuation.
- Complete Forecasting Control: Modify revenue growth, profit margins, WACC, and other essential metrics.
- Real-Time Calculations: Automatic updates provide immediate results as you adjust inputs.
- Professional-Grade Template: A polished Excel file crafted for high-quality valuation analysis.
- Flexible and Reusable: Designed for adaptability, enabling repeated use for in-depth forecasting.
Key Features
- Accurate Financial Data: Gain access to reliable pre-loaded historical figures and future estimates for CION Investment Corporation (CION).
- Adjustable Forecast Parameters: Modify highlighted cells for key metrics such as WACC, growth rates, and profit margins.
- Real-Time Calculations: Enjoy automatic updates for DCF, Net Present Value (NPV), and cash flow assessments.
- Interactive Dashboard: Clear and informative charts and summaries to help visualize your valuation findings.
- Designed for All Levels: An easy-to-navigate layout tailored for investors, CFOs, and consultants alike.
How It Works
- Step 1: Download the prebuilt Excel template featuring CION Investment Corporation’s (CION) data.
- Step 2: Navigate through the pre-filled sheets to familiarize yourself with the essential metrics.
- Step 3: Adjust forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly see the recalculated results, including CION’s intrinsic value.
- Step 5: Use the outputs to make informed investment decisions or create detailed reports.
Why Choose CION Investment Corporation (CION)?
- Comprehensive Investment Solutions: Offers a wide range of investment strategies tailored for diverse portfolios.
- Customizable Investment Plans: Tailor your investment strategy based on your financial goals and risk tolerance.
- In-Depth Market Analysis: Provides detailed insights into market trends and performance metrics for informed decision-making.
- Robust Data Resources: Access to historical and projected data to facilitate accurate investment assessments.
- Expert Guidance: Ideal for individual investors, institutional clients, and financial advisors seeking professional support.
Who Should Use This Product?
- Investors: Evaluate CION’s valuation prior to making investment decisions.
- CFOs and Financial Analysts: Enhance valuation methodologies and assess financial forecasts.
- Startup Founders: Discover how established firms like CION are appraised in the market.
- Consultants: Provide expert valuation assessments for clients leveraging CION's data.
- Students and Educators: Utilize current market information to learn and teach valuation practices.
What the Template Contains
- Pre-Filled Data: Contains CION Investment Corporation's historical financials and projections.
- Discounted Cash Flow Model: An editable DCF valuation model with automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC using custom inputs.
- Key Financial Ratios: Evaluate CION's profitability, efficiency, and leverage metrics.
- Customizable Inputs: Easily modify revenue growth, margins, and tax rates.
- Clear Dashboard: Visuals and tables summarizing essential valuation outcomes.