|
Valoración de DCF de Liquidia Corporation (LQDA)
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
Liquidia Corporation (LQDA) Bundle
¡Optimice su tiempo y mejore la precisión con nuestra calculadora DCF de Liquidia Corporation (LQDA)! Utilizando datos reales de Liquidia y supuestos personalizables, esta herramienta le permite pronosticar, analizar y evaluar Liquidia Corporation (LQDA) al igual que un inversor experimentado.
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 | 8.1 | .7 | 12.9 | 15.9 | 17.5 | 19.4 | 21.4 | 23.7 | 26.3 | 29.1 |
Revenue Growth, % | 0 | -90.84 | 1637.81 | 23.98 | 9.75 | 10.72 | 10.72 | 10.72 | 10.72 | 10.72 |
EBITDA | -43.4 | -55.8 | -27.9 | -34.7 | -70.1 | -19.4 | -21.4 | -23.7 | -26.3 | -29.1 |
EBITDA, % | -537.86 | -7542.79 | -217.18 | -217.88 | -400.57 | -100 | -100 | -100 | -100 | -100 |
Depreciation | 2.8 | 3.1 | 5.8 | 4.0 | 2.2 | 8.4 | 9.3 | 10.3 | 11.4 | 12.7 |
Depreciation, % | 34.6 | 421.32 | 45.51 | 24.84 | 12.45 | 43.48 | 43.48 | 43.48 | 43.48 | 43.48 |
EBIT | -46.2 | -58.9 | -33.8 | -38.7 | -72.2 | -19.4 | -21.4 | -23.7 | -26.3 | -29.1 |
EBIT, % | -572.46 | -7964.11 | -262.68 | -242.72 | -413.02 | -100 | -100 | -100 | -100 | -100 |
Total Cash | 55.8 | 65.3 | 57.5 | 93.3 | 83.7 | 19.4 | 21.4 | 23.7 | 26.3 | 29.1 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | .0 | .0 | 3.0 | 5.0 | 4.1 | 3.0 | 3.3 | 3.7 | 4.1 | 4.5 |
Account Receivables, % | 0 | 0 | 23.26 | 31.48 | 23.22 | 15.59 | 15.59 | 15.59 | 15.59 | 15.59 |
Inventories | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Inventories, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Accounts Payable | 3.5 | 3.7 | 1.1 | 2.2 | 1.4 | 6.7 | 7.4 | 8.2 | 9.1 | 10.1 |
Accounts Payable, % | 43.33 | 504.88 | 8.32 | 13.79 | 7.98 | 34.69 | 34.69 | 34.69 | 34.69 | 34.69 |
Capital Expenditure | -1.9 | -.8 | -.1 | -.6 | -1.3 | -5.2 | -5.8 | -6.4 | -7.1 | -7.8 |
Capital Expenditure, % | -22.92 | -101.68 | -0.83418 | -3.72 | -7.38 | -26.97 | -26.97 | -26.97 | -26.97 | -26.97 |
Tax Rate, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
EBITAT | -45.1 | -56.7 | -29.1 | -36.2 | -72.2 | -18.3 | -20.3 | -22.5 | -24.9 | -27.5 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -40.6 | -54.1 | -29.0 | -33.7 | -71.2 | -8.8 | -16.4 | -18.1 | -20.1 | -22.2 |
WACC, % | 6.2 | 6.19 | 6.11 | 6.17 | 6.22 | 6.18 | 6.18 | 6.18 | 6.18 | 6.18 |
PV UFCF | ||||||||||
SUM PV UFCF | -70.1 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -23 | |||||||||
Terminal Value | -542 | |||||||||
Present Terminal Value | -402 | |||||||||
Enterprise Value | -472 | |||||||||
Net Debt | -80 | |||||||||
Equity Value | -392 | |||||||||
Diluted Shares Outstanding, MM | 65 | |||||||||
Equity Value Per Share | -6.03 |
What You Will Get
- Real Liquidia Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Liquidia Corporation (LQDA).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates tailored for Liquidia Corporation.
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on Liquidia's fair value.
- Versatile Excel Template: Designed for quick edits, scenario testing, and detailed projections specific to Liquidia Corporation (LQDA).
- Time-Saving and Accurate: Avoid building models from scratch while ensuring precision and flexibility for Liquidia Corporation (LQDA).
Key Features
- Real-Life LQDA Data: Pre-filled with Liquidia Corporation’s historical financials and forward-looking projections.
- Fully Customizable Inputs: Adjust revenue growth, margins, WACC, tax rates, and capital expenditures.
- Dynamic Valuation Model: Automatic updates to Net Present Value (NPV) and intrinsic value based on your inputs.
- Scenario Testing: Create multiple forecast scenarios to analyze different valuation outcomes.
- User-Friendly Design: Simple, structured, and designed for professionals and beginners alike.
How It Works
- Step 1: Download the Excel file for Liquidia Corporation (LQDA).
- Step 2: Review the pre-filled financial data and forecasts for Liquidia Corporation.
- Step 3: Adjust key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you modify your assumptions.
- Step 5: Evaluate the outputs and apply the results to your investment strategies.
Why Choose This Calculator for Liquidia Corporation (LQDA)?
- Accuracy: Utilizes real Liquidia financial data to ensure precise calculations.
- Flexibility: Allows users to easily test and adjust inputs according to their needs.
- Time-Saving: Eliminates the need to create a DCF model from the ground up.
- Professional-Grade: Crafted with the precision and usability expected by CFOs.
- User-Friendly: Designed for ease of use, even for individuals without extensive financial modeling skills.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling Liquidia Corporation (LQDA) stock.
- Financial Analysts: Streamline valuation processes with ready-to-use financial models specific to Liquidia Corporation (LQDA).
- Consultants: Deliver professional valuation insights on Liquidia Corporation (LQDA) to clients quickly and accurately.
- Business Owners: Understand how companies like Liquidia Corporation (LQDA) are valued to guide your own strategic decisions.
- Finance Students: Learn valuation techniques using real-world data and scenarios related to Liquidia Corporation (LQDA).
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Liquidia Corporation (LQDA) 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 Liquidia Corporation (LQDA).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.