|
Valoración DCF de Longgeveron Inc. (LGVN)
US | Healthcare | Biotechnology | NASDAQ
|
- ✓ 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
Longeveron Inc. (LGVN) Bundle
¡Mejore sus estrategias de inversión con la calculadora DCF (LGVN)! Explore los datos financieros genuinos de Longeveron Inc., ajuste las proyecciones y gastos de crecimiento, y observe instantáneamente cómo estas modificaciones influyen en el valor intrínseco de (LGVN).
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 | 5.6 | 5.6 | 1.3 | 1.2 | .7 | .5 | .3 | .2 | .2 | .1 |
| Revenue Growth, % | 0 | -0.17617 | -76.8 | -6.43 | -41.98 | -31.35 | -31.35 | -31.35 | -31.35 | -31.35 |
| EBITDA | -2.2 | -2.9 | -16.2 | -17.2 | -20.1 | -.4 | -.3 | -.2 | -.1 | -.1 |
| EBITDA, % | -38.85 | -52.03 | -1239.28 | -1403.44 | -2829.34 | -78.18 | -78.18 | -78.18 | -78.18 | -78.18 |
| Depreciation | .8 | .8 | .9 | .9 | .9 | .3 | .2 | .1 | .1 | .1 |
| Depreciation, % | 13.63 | 13.95 | 69.98 | 73.08 | 133.43 | 54.13 | 54.13 | 54.13 | 54.13 | 54.13 |
| EBIT | -3.0 | -3.7 | -17.1 | -18.0 | -21.0 | -.4 | -.3 | -.2 | -.1 | -.1 |
| EBIT, % | -52.48 | -65.98 | -1309.26 | -1476.51 | -2962.76 | -83.69 | -83.69 | -83.69 | -83.69 | -83.69 |
| Total Cash | 1.9 | .8 | 35.0 | 19.7 | 5.4 | .3 | .2 | .2 | .1 | .1 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | .5 | .4 | .1 | .2 | .1 | .1 | .0 | .0 | .0 | .0 |
| Account Receivables, % | 8.01 | 7.47 | 4.21 | 17.84 | 15.66 | 10.64 | 10.64 | 10.64 | 10.64 | 10.64 |
| Inventories | .0 | .0 | .0 | -.6 | .0 | .0 | .0 | .0 | .0 | .0 |
| Inventories, % | 0 | 0 | 0 | -50.9 | 0 | -10.18 | -10.18 | -10.18 | -10.18 | -10.18 |
| Accounts Payable | 1.2 | 1.6 | .6 | 1.8 | .6 | .3 | .2 | .1 | .1 | .1 |
| Accounts Payable, % | 20.48 | 28.24 | 49.39 | 143.29 | 89.99 | 57.62 | 57.62 | 57.62 | 57.62 | 57.62 |
| Capital Expenditure | -.1 | -.3 | -1.3 | -.9 | -.7 | -.3 | -.2 | -.1 | -.1 | -.1 |
| Capital Expenditure, % | -2.22 | -4.65 | -100.31 | -70.05 | -97.88 | -54.96 | -54.96 | -54.96 | -54.96 | -54.96 |
| Tax Rate, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| EBITAT | -3.0 | -3.8 | -17.2 | -18.8 | -21.0 | -.4 | -.3 | -.2 | -.1 | -.1 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -1.6 | -2.8 | -18.2 | -17.2 | -22.4 | -.7 | -.4 | -.3 | -.2 | -.1 |
| WACC, % | 5.52 | 5.52 | 5.52 | 5.52 | 5.52 | 5.52 | 5.52 | 5.52 | 5.52 | 5.52 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -1.4 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 0 | |||||||||
| Terminal Value | -3 | |||||||||
| Present Terminal Value | -3 | |||||||||
| Enterprise Value | -4 | |||||||||
| Net Debt | -3 | |||||||||
| Equity Value | -1 | |||||||||
| Diluted Shares Outstanding, MM | 2 | |||||||||
| Equity Value Per Share | -0.53 |
What You Will Get
- Comprehensive LGVN Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Dynamic Calculations: Intrinsic value and NPV are computed automatically.
- Scenario Analysis: Explore various scenarios to assess Longeveron Inc.'s future performance.
- User-Friendly Design: Designed for professionals while remaining easy to navigate for newcomers.
Key Features
- Real-Life LGVN Data: Pre-filled with Longeveron Inc.'s historical financials and future projections.
- Fully Customizable Inputs: Modify revenue growth, profit margins, WACC, tax rates, and capital expenditures to suit your analysis.
- Dynamic Valuation Model: Automatically updates Net Present Value (NPV) and intrinsic value based on your customized inputs.
- Scenario Testing: Develop multiple forecasting scenarios to evaluate various valuation results.
- User-Friendly Design: Intuitive, organized, and tailored for both professionals and newcomers.
How It Works
- Step 1: Download the prebuilt Excel template featuring Longeveron Inc.'s (LGVN) 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 recalculated results, including Longeveron Inc.'s (LGVN) intrinsic value.
- Step 5: Use the outputs to make informed investment decisions or create reports.
Why Choose This Calculator for Longeveron Inc. (LGVN)?
- User-Friendly Interface: Tailored for both novices and seasoned professionals.
- Customizable Inputs: Adjust parameters easily to suit your financial analysis.
- Real-Time Valuation: Instantly view changes in Longeveron’s valuation as you modify inputs.
- Preloaded Data: Comes with Longeveron’s actual financial metrics for swift evaluations.
- Relied Upon by Experts: Favored by investors and analysts for making strategic decisions.
Who Should Use This Product?
- Healthcare Investors: Develop comprehensive valuation models for assessing Longeveron Inc. (LGVN) investments.
- Biotech Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the company.
- Consultants and Advisors: Deliver precise valuation insights for clients interested in Longeveron Inc. (LGVN).
- Students and Educators: Utilize current data to practice and teach financial modeling in the biotech sector.
- Biotech Enthusiasts: Gain insights into the valuation processes of innovative companies like Longeveron Inc. (LGVN).
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Longeveron Inc. (LGVN) 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 Longeveron Inc. (LGVN).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.