CION Investment Corporation (CION) DCF Valuation

CION Investment Corporation (CION) DCF Valuation
  • ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
  • ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
  • ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
  • ✓ Aucune Expertise N'Est Requise; Facile À Suivre

CION Investment Corporation (CION) Bundle

DCF model
Get Full Bundle:
$25 $15
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7

TOTAL:

Enhance your investment choices with the CION Investment Corporation (CION) DCF Calculator! Utilize real financial data, adjust growth projections and expenses, and instantly observe how these changes affect the intrinsic value of 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
Account Receivables, % 64.15 -1076.32 18.49 47.13 15.02
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.

No products were found matching.