Harvard Bioscience, Inc. (HBIO) DCF Valuation

Harvard Bioscience, Inc. (HBIO) 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

Harvard Bioscience, Inc. (HBIO) 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 Harvard Bioscience, Inc. (HBIO)'s financial outlook like an expert! This (HBIO) DCF Calculator provides pre-filled financial data and full flexibility to modify revenue growth, WACC, margins, and other critical assumptions to align with your projections.


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 116.2 102.1 118.9 113.3 112.3 111.9 111.5 111.2 110.8 110.4
Revenue Growth, % 0 -12.12 16.46 -4.68 -0.95734 -0.32467 -0.32467 -0.32467 -0.32467 -0.32467
EBITDA 7.5 5.5 11.3 .9 8.0 6.6 6.5 6.5 6.5 6.5
EBITDA, % 6.46 5.38 9.51 0.83293 7.16 5.87 5.87 5.87 5.87 5.87
Depreciation 7.7 7.6 7.6 7.6 7.0 7.5 7.5 7.4 7.4 7.4
Depreciation, % 6.66 7.48 6.41 6.68 6.23 6.69 6.69 6.69 6.69 6.69
EBIT -.2 -2.1 3.7 -6.6 1.0 -.9 -.9 -.9 -.9 -.9
EBIT, % -0.19884 -2.1 3.1 -5.85 0.92205 -0.82444 -0.82444 -0.82444 -0.82444 -0.82444
Total Cash 8.3 8.3 7.8 4.5 4.3 6.6 6.6 6.6 6.6 6.6
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 20.7 17.8 21.8 16.7 16.1
Account Receivables, % 17.82 17.4 18.36 14.74 14.34
Inventories 22.1 22.3 27.6 26.4 24.7 24.5 24.4 24.3 24.2 24.2
Inventories, % 18.99 21.8 23.2 23.33 22.02 21.87 21.87 21.87 21.87 21.87
Accounts Payable 5.3 6.0 4.9 6.4 5.6 5.6 5.6 5.6 5.6 5.6
Accounts Payable, % 4.6 5.85 4.13 5.69 4.95 5.04 5.04 5.04 5.04 5.04
Capital Expenditure -1.2 -1.2 -1.3 -1.6 -2.3 -1.5 -1.5 -1.5 -1.5 -1.5
Capital Expenditure, % -1.05 -1.13 -1.13 -1.4 -2.06 -1.35 -1.35 -1.35 -1.35 -1.35
Tax Rate, % -33.61 -33.61 -33.61 -33.61 -33.61 -33.61 -33.61 -33.61 -33.61 -33.61
EBITAT -.2 -2.3 7.6 -6.9 1.4 -.9 -.9 -.9 -.9 -.9
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF -31.1 7.6 3.4 6.9 7.5 3.0 5.2 5.2 5.1 5.1
WACC, % 9.47 9.89 9.89 9.89 9.89 9.8 9.8 9.8 9.8 9.8
PV UFCF
SUM PV UFCF 17.7
Long Term Growth Rate, % 4.00
Free cash flow (T + 1) 5
Terminal Value 92
Present Terminal Value 58
Enterprise Value 75
Net Debt 38
Equity Value 37
Diluted Shares Outstanding, MM 42
Equity Value Per Share 0.87

What You Will Get

  • Comprehensive HBIO Financials: Access to both historical and projected data for precise valuation.
  • Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures to fit your analysis.
  • Real-Time Calculations: Dynamic computation of intrinsic value and NPV at your fingertips.
  • Scenario Analysis: Evaluate various scenarios to assess Harvard Bioscience's future performance.
  • User-Friendly Interface: Designed for professionals while remaining approachable for newcomers.

Key Features

  • Customizable Research Parameters: Adjust essential inputs such as revenue projections, R&D spending, and operational costs.
  • Instant DCF Valuation: Quickly computes intrinsic value, NPV, and other financial metrics.
  • Industry-Leading Precision: Leverages Harvard Bioscience's (HBIO) actual financial data for accurate valuation results.
  • Effortless Scenario Testing: Evaluate various hypotheses and analyze results with ease.
  • Efficiency Booster: Streamline the valuation process without the hassle of constructing intricate models from the ground up.

How It Functions

  1. Download the Template: Gain immediate access to the Excel-based HBIO DCF Calculator.
  2. Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and additional parameters.
  3. Instant Calculations: The model automatically recalculates Harvard Bioscience’s intrinsic value.
  4. Test Scenarios: Experiment with various assumptions to assess potential changes in valuation.
  5. Analyze and Decide: Utilize the outcomes to inform your investment or financial analysis.

Why Choose This Calculator for Harvard Bioscience, Inc. (HBIO)?

  • Designed for Experts: A sophisticated tool favored by researchers, lab managers, and financial analysts.
  • Comprehensive Data: Historical and projected financials for Harvard Bioscience preloaded for precision.
  • Flexible Scenario Analysis: Easily test various forecasts and assumptions to suit your needs.
  • Insightful Results: Automatically computes intrinsic value, NPV, and essential metrics.
  • User-Friendly: Clear, step-by-step instructions make navigation simple.

Who Should Use This Product?

  • Life Science Researchers: Utilize advanced tools for experimental design and data analysis.
  • Academics: Integrate cutting-edge technologies into teaching and research projects.
  • Laboratory Managers: Optimize workflows and improve efficiency with our innovative solutions.
  • Investors: Analyze market trends and performance metrics for Harvard Bioscience, Inc. (HBIO).
  • Healthcare Professionals: Enhance diagnostic capabilities with state-of-the-art equipment and resources.

What the Template Contains

  • Pre-Filled Data: Includes Harvard Bioscience’s historical financials and forecasts.
  • Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
  • Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
  • Key Financial Ratios: Analyze Harvard Bioscience’s profitability, efficiency, and leverage.
  • Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
  • Clear Dashboard: Charts and tables summarizing key valuation results.