BioCardia, Inc. (BCDA) DCF Valuation
- ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
- ✓ Design Profissional: Modelos Confiáveis E Padrão Da Indústria
- ✓ Pré-Construídos Para Uso Rápido E Eficiente
- ✓ Não É Necessária Experiência; Fácil De Seguir
BioCardia, Inc. (BCDA) Bundle
Evaluate BioCardia, Inc.'s (BCDA) financial outlook with expert precision! This (BCDA) DCF Calculator comes with pre-filled financial data and offers you the flexibility to modify revenue growth, WACC, margins, and other crucial 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 | .7 | .1 | 1.0 | 1.4 | .5 | .5 | .5 | .4 | .4 | .4 |
| Revenue Growth, % | 0 | -79.58 | 600 | 33.2 | -64.72 | -2.77 | -2.77 | -2.77 | -2.77 | -2.77 |
| EBITDA | -14.0 | -14.4 | -12.6 | -11.8 | -11.6 | -.5 | -.5 | -.4 | -.4 | -.4 |
| EBITDA, % | -1978.31 | -9955.17 | -1238.42 | -874.19 | -2423.48 | -100 | -100 | -100 | -100 | -100 |
| Depreciation | .6 | .6 | .6 | .4 | .1 | .3 | .3 | .3 | .2 | .2 |
| Depreciation, % | 77.61 | 390.34 | 63.05 | 27.88 | 17.61 | 57.23 | 57.23 | 57.23 | 57.23 | 57.23 |
| EBIT | -14.6 | -15.0 | -13.2 | -12.2 | -11.6 | -.5 | -.5 | -.4 | -.4 | -.4 |
| EBIT, % | -2055.92 | -10345.52 | -1301.48 | -902.07 | -2441.09 | -100 | -100 | -100 | -100 | -100 |
| Total Cash | 5.6 | 21.4 | 12.9 | 7.4 | 1.1 | .5 | .5 | .4 | .4 | .4 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | .1 | .9 | .1 | .2 | .1 | .2 | .1 | .1 | .1 | .1 |
| Account Receivables, % | 20.7 | 586.21 | 14.48 | 14.87 | 13.21 | 32.65 | 32.65 | 32.65 | 32.65 | 32.65 |
| Inventories | .0 | -.9 | .0 | -.2 | .0 | -.1 | -.1 | -.1 | -.1 | -.1 |
| Inventories, % | 0.56338 | -586.21 | 0.000098522167 | -14.87 | 0 | -22.86 | -22.86 | -22.86 | -22.86 | -22.86 |
| Accounts Payable | .9 | .7 | .5 | .7 | .9 | .4 | .4 | .4 | .3 | .3 |
| Accounts Payable, % | 128.73 | 514.48 | 49.95 | 50.52 | 186.58 | 80.09 | 80.09 | 80.09 | 80.09 | 80.09 |
| Capital Expenditure | -.1 | .0 | -.1 | -.1 | .0 | -.1 | -.1 | -.1 | -.1 | -.1 |
| Capital Expenditure, % | -20.56 | -22.07 | -11.43 | -5.18 | -2.52 | -12.35 | -12.35 | -12.35 | -12.35 | -12.35 |
| Tax Rate, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| EBITAT | -14.7 | -15.0 | -13.2 | -12.2 | -11.6 | -.5 | -.5 | -.4 | -.4 | -.4 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -13.5 | -14.5 | -13.1 | -11.6 | -11.4 | -.8 | -.3 | -.3 | -.2 | -.2 |
| WACC, % | 8.81 | 8.81 | 8.8 | 8.81 | 8.81 | 8.81 | 8.81 | 8.81 | 8.81 | 8.81 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -1.4 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 0 | |||||||||
| Terminal Value | -4 | |||||||||
| Present Terminal Value | -2 | |||||||||
| Enterprise Value | -4 | |||||||||
| Net Debt | 0 | |||||||||
| Equity Value | -4 | |||||||||
| Diluted Shares Outstanding, MM | 1 | |||||||||
| Equity Value Per Share | -2.82 |
What You Will Get
- Editable Forecast Inputs: Easily modify assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: BioCardia, Inc.'s (BCDA) financial data pre-loaded to kickstart your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically.
- Customizable and Professional: A refined Excel model that adjusts to your valuation requirements.
- Built for Analysts and Investors: Perfect for evaluating projections, validating strategies, and enhancing efficiency.
Key Features
- Comprehensive BCDA Data: Pre-filled with BioCardia's historical performance metrics and future growth projections.
- Customizable Assumptions: Tailor inputs for revenue growth, profit margins, discount rates, tax considerations, and capital investments.
- Interactive Valuation Model: Automatic recalculations of Net Present Value (NPV) and intrinsic value based on your specified parameters.
- Scenario Analysis: Develop various forecasting scenarios to evaluate different valuation possibilities.
- Intuitive User Interface: Designed for ease of use, catering to both experienced professionals and newcomers.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered BioCardia data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for BioCardia’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for BioCardia, Inc. (BCDA)?
- All-in-One Solution: Features DCF, WACC, and financial ratio analyses tailored for BioCardia, Inc. (BCDA).
- Flexible Inputs: Modify the highlighted cells to explore different financial scenarios.
- In-Depth Analysis: Automatically computes BioCardia, Inc.'s (BCDA) intrinsic value and Net Present Value.
- Preloaded Information: Historical and projected data provide reliable starting points for analysis.
- Expert-Level Tool: Perfect for financial analysts, investors, and consultants focusing on BioCardia, Inc. (BCDA).
Who Should Use This Product?
- Individual Investors: Make informed decisions regarding the purchase or sale of BioCardia stock (BCDA).
- Financial Analysts: Enhance valuation processes with ready-to-implement financial models specific to BioCardia.
- Consultants: Provide clients with professional valuation insights on BioCardia quickly and accurately.
- Business Owners: Gain insights into how biotech companies like BioCardia are valued to inform your own business strategies.
- Finance Students: Explore valuation techniques using real-world data and case studies related to BioCardia.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled BioCardia historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for BioCardia, Inc. (BCDA).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.