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
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 | 18.5 | 18.4 | 18.4 | 18.3 | 18.3 |
Account Receivables, % | 17.82 | 17.4 | 18.36 | 14.74 | 14.34 | 16.53 | 16.53 | 16.53 | 16.53 | 16.53 |
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
- Download the Template: Gain immediate access to the Excel-based HBIO DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and additional parameters.
- Instant Calculations: The model automatically recalculates Harvard Bioscience’s intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential changes in valuation.
- 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.