Fidus Investment Corporation (FDUS) DCF Valuation

Fidus Investment Corporation (FDUS) DCF Valuation
  • ✓ 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

Fidus Investment Corporation (FDUS) 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:

Whether you’re an investor or analyst, this (FDUS) DCF Calculator is your go-to tool for accurate valuation. Loaded with real data from Fidus Investment Corporation, you can adjust forecasts and observe the effects in real-time.


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 53.9 40.0 127.3 53.0 154.2 198.8 256.3 330.4 426.0 549.3
Revenue Growth, % 0 -25.9 218.36 -58.39 191.18 28.93 28.93 28.93 28.93 28.93
EBITDA .0 -7.1 .0 -2.7 .0 -9.1 -11.7 -15.1 -19.5 -25.1
EBITDA, % 0 -17.82 0 -5.05 0 -4.57 -4.57 -4.57 -4.57 -4.57
Depreciation 9.4 31.5 4.2 93.2 .0 79.3 102.3 131.8 170.0 219.1
Depreciation, % 17.38 78.84 3.27 176.04 0 39.9 39.9 39.9 39.9 39.9
EBIT -9.4 -38.6 -4.2 -95.9 .0 -86.4 -111.4 -143.6 -185.2 -238.7
EBIT, % -17.38 -96.66 -3.27 -181.08 0 -43.46 -43.46 -43.46 -43.46 -43.46
Total Cash 15.0 124.3 169.4 62.4 119.1 161.1 207.6 267.7 345.2 445.0
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 6.3 7.5 8.2 11.8 12.0
Account Receivables, % 11.74 18.88 6.47 22.33 7.76
Inventories .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Inventories, % 0.00000185398 0 0 0.000001888538 0 0.000000749 0.000000749 0.000000749 0.000000749 0.000000749
Accounts Payable 3.9 4.0 5.3 5.5 6.7 14.4 18.6 24.0 30.9 39.8
Accounts Payable, % 7.32 9.99 4.18 10.46 4.32 7.25 7.25 7.25 7.25 7.25
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, % 3.37 3.37 3.37 3.37 3.37 3.37 3.37 3.37 3.37 3.37
EBITAT -9.3 -36.9 -4.1 -72.1 .0 -80.2 -103.4 -133.3 -171.8 -221.5
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF -2.3 -6.6 .7 17.7 1.0 -7.9 -4.7 -6.0 -7.8 -10.0
WACC, % 8.1 8.03 8.08 7.62 8.06 7.98 7.98 7.98 7.98 7.98
PV UFCF
SUM PV UFCF -28.6
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) -10
Terminal Value -171
Present Terminal Value -116
Enterprise Value -145
Net Debt 347
Equity Value -492
Diluted Shares Outstanding, MM 26
Equity Value Per Share -18.67

What You Will Receive

  • Authentic Fidus Data: Preloaded financial metrics – from revenue to EBIT – based on actual and projected figures.
  • Comprehensive Customization: Modify all essential parameters (yellow cells) such as WACC, growth %, and tax rates.
  • Immediate Valuation Adjustments: Automatic recalculations to assess the influence of changes on Fidus Investment Corporation’s (FDUS) fair value.
  • Flexible Excel Template: Designed for quick modifications, scenario analysis, and thorough projections.
  • Efficient and Precise: Avoid constructing models from the ground up while ensuring accuracy and adaptability.

Key Features

  • Comprehensive Financial Data: Fidus Investment Corporation’s (FDUS) historical financial reports and pre-filled projections.
  • Customizable Parameters: Modify WACC, tax rates, revenue growth, and EBITDA margins to fit your analysis.
  • Real-Time Valuation: Watch Fidus Investment Corporation’s (FDUS) intrinsic value update instantly.
  • Intuitive Visualizations: Dashboard graphs illustrate valuation outcomes and essential metrics.
  • Designed for Precision: A robust tool tailored for analysts, investors, and finance professionals.

How It Works

  • Step 1: Download the prebuilt Excel template featuring Fidus Investment Corporation’s (FDUS) data.
  • Step 2: Review the pre-filled sheets to familiarize yourself with the essential metrics.
  • Step 3: Modify forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
  • Step 4: Instantly see the recalculated results, including Fidus Investment Corporation’s (FDUS) intrinsic value.
  • Step 5: Make well-informed investment choices or create reports based on the outputs.

Why Choose This Calculator for Fidus Investment Corporation (FDUS)?

  • All-in-One Solution: Combines DCF, WACC, and financial ratio analyses tailored for (FDUS).
  • Flexible Inputs: Modify the highlighted cells to explore different investment scenarios for (FDUS).
  • In-Depth Analysis: Automatically computes the intrinsic value and Net Present Value specifically for (FDUS).
  • Data-Rich Environment: Access historical and projected data for reliable analysis of (FDUS).
  • Expert-Level Tool: Perfect for financial analysts, investors, and consultants focusing on (FDUS).

Who Should Use Fidus Investment Corporation (FDUS)?

  • Investors: Gain insights and make informed decisions with a reliable investment platform.
  • Financial Analysts: Streamline your analysis with comprehensive data and tools tailored for efficiency.
  • Consultants: Easily modify our resources for impactful client presentations and strategic reports.
  • Finance Enthusiasts: Enhance your knowledge of investment strategies through practical applications and case studies.
  • Educators and Students: Utilize our offerings as a hands-on educational resource in finance-related studies.

What the Template Contains

  • Pre-Filled Data: Contains Fidus Investment Corporation's historical financials and projections.
  • Discounted Cash Flow Model: An editable DCF valuation model with automated calculations.
  • Weighted Average Cost of Capital (WACC): A specific sheet for calculating WACC based on user-defined inputs.
  • Key Financial Ratios: Assess Fidus Investment Corporation's profitability, efficiency, and leverage.
  • Customizable Inputs: Easily modify revenue growth, profit margins, and tax rates.
  • Clear Dashboard: Visual representations and tables summarizing essential valuation outcomes.

No products were found matching.