Affimed N.V. (AFMD) DCF Valuation

Affimed N.V. (AFMD) 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

Affimed N.V. (AFMD) 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:

Evaluate Affimed N.V.'s financial prospects like an expert! This (AFMD) DCF Calculator offers pre-filled financial data and allows you the flexibility to modify revenue growth, WACC, margins, and other critical assumptions to align with your predictions.


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 22.3 29.6 42.1 43.1 8.6 8.6 8.5 8.5 8.4 8.3
Revenue Growth, % 0 32.58 42.33 2.45 -79.99 -0.65771 -0.65771 -0.65771 -0.65771 -0.65771
EBITDA -32.3 -35.7 -66.7 -84.9 -106.7 -8.6 -8.5 -8.5 -8.4 -8.3
EBITDA, % -144.79 -120.69 -158.56 -197.02 -1237.22 -100 -100 -100 -100 -100
Depreciation .9 1.1 1.4 3.0 1.8 .7 .7 .7 .7 .7
Depreciation, % 4.22 3.66 3.44 6.88 21.14 7.87 7.87 7.87 7.87 7.87
EBIT -33.2 -36.8 -68.2 -87.9 -108.5 -8.6 -8.5 -8.5 -8.4 -8.3
EBIT, % -149.01 -124.36 -162 -203.9 -1258.36 -100 -100 -100 -100 -100
Total Cash 108.5 153.1 206.0 198.3 76.0 8.6 8.5 8.5 8.4 8.3
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 1.5 2.5 5.0 2.8 5.6
Account Receivables, % 6.93 8.6 11.91 6.52 64.37
Inventories .3 .3 .4 .7 .5 .2 .2 .2 .2 .2
Inventories, % 1.38 0.86742 1.04 1.52 5.6 2.08 2.08 2.08 2.08 2.08
Accounts Payable 11.1 11.9 19.7 19.9 19.7 4.8 4.8 4.8 4.8 4.7
Accounts Payable, % 49.9 40.18 46.72 46.13 228.59 56.59 56.59 56.59 56.59 56.59
Capital Expenditure -1.5 -.5 -4.0 -.7 -3.9 -1.1 -1.1 -1.1 -1.1 -1.1
Capital Expenditure, % -6.89 -1.55 -9.54 -1.68 -45.06 -12.95 -12.95 -12.95 -12.95 -12.95
Tax Rate, % -0.00283193 -0.00283193 -0.00283193 -0.00283193 -0.00283193 -0.00283193 -0.00283193 -0.00283193 -0.00283193 -0.00283193
EBITAT -33.2 -36.8 -68.2 -87.9 -108.5 -8.6 -8.5 -8.5 -8.4 -8.3
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF -24.6 -36.3 -65.6 -83.4 -113.3 -19.7 -9.0 -8.9 -8.8 -8.8
WACC, % 11.79 11.79 11.79 11.79 11.79 11.79 11.79 11.79 11.79 11.79
PV UFCF
SUM PV UFCF -41.9
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) -9
Terminal Value -92
Present Terminal Value -52
Enterprise Value -94
Net Debt -20
Equity Value -74
Diluted Shares Outstanding, MM 15
Equity Value Per Share -4.98

What You Will Get

  • Comprehensive AFMD Financials: Access to historical and projected data for precise valuation.
  • Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
  • Real-Time Calculations: Intrinsic value and NPV are computed automatically.
  • Scenario Simulation: Evaluate various scenarios to analyze Affimed’s potential future performance.
  • User-Friendly Interface: Designed for professionals while remaining approachable for newcomers.

Key Features

  • Customizable Clinical Parameters: Adjust key inputs such as trial phases, patient demographics, and treatment efficacy.
  • Instant Valuation Metrics: Quickly computes intrinsic value, net present value (NPV), and other financial indicators.
  • High-Precision Analytics: Leverages Affimed N.V.'s (AFMD) real-world data for accurate valuation insights.
  • Streamlined Scenario Testing: Effortlessly explore various hypotheses and assess their implications.
  • Efficiency Booster: Removes the hassle of constructing intricate valuation models from the ground up.

How It Works

  • Step 1: Download the prebuilt Excel template featuring Affimed N.V.'s (AFMD) data.
  • Step 2: Navigate through the pre-filled sheets to grasp 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 Affimed N.V.'s (AFMD) intrinsic value.
  • Step 5: Use the outputs to make informed investment decisions or generate detailed reports.

Why Choose This Calculator for Affimed N.V. (AFMD)?

  • Designed for Experts: A sophisticated tool tailored for analysts, CFOs, and consultants.
  • Accurate Data: Affimed's historical and projected financials preloaded for precision.
  • Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
  • Comprehensive Outputs: Automatically computes intrinsic value, NPV, and essential metrics.
  • User-Friendly: Step-by-step guidance to help you navigate the process effortlessly.

Who Should Use This Product?

  • Individual Investors: Make informed decisions about buying or selling Affimed N.V. (AFMD) stock.
  • Financial Analysts: Enhance valuation processes with ready-to-use financial models specific to Affimed N.V. (AFMD).
  • Consultants: Provide professional valuation insights on Affimed N.V. (AFMD) to clients efficiently and accurately.
  • Business Owners: Gain insights into how biotech companies like Affimed N.V. (AFMD) are valued to inform your own business strategy.
  • Finance Students: Explore valuation techniques using real-world data and scenarios related to Affimed N.V. (AFMD).

What the Template Contains

  • Comprehensive DCF Model: Editable template featuring in-depth valuation calculations.
  • Real-World Data: Affimed N.V.'s (AFMD) historical and projected financials preloaded for analysis.
  • Customizable Parameters: Modify WACC, growth rates, and tax assumptions to explore various scenarios.
  • Financial Statements: Complete annual and quarterly breakdowns for enhanced insights.
  • Key Ratios: Integrated analysis for profitability, efficiency, and leverage metrics.
  • Dashboard with Visual Outputs: Charts and tables designed for clear, actionable results.

No products were found matching.