|
Purple Biotech Ltd. (PPBT) DCF Valoración
IL | 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
Purple Biotech Ltd. (PPBT) Bundle
¡Descubra el verdadero potencial de Purple Biotech Ltd. (PPBT) con nuestra calculadora DCF avanzada! Ajuste los supuestos clave, explore varios escenarios y examine cómo los cambios afectan la valoración de Purple Biotech Ltd. (PPBT), todo dentro de una sola plantilla de Excel.
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 | 1.0 | 1.0 | -.3 | -.9 | .0 | .0 | .0 | .0 | .0 | .0 |
Revenue Growth, % | 0 | 0 | -132 | 184.38 | -100 | -25 | -25 | -25 | -25 | -25 |
EBITDA | -6.1 | -28.4 | -17.5 | -21.5 | -22.2 | .0 | .0 | .0 | .0 | .0 |
EBITDA, % | -613.7 | -2841 | 5473.75 | 2361.76 | 100 | 20 | 20 | 20 | 20 | 20 |
Depreciation | .2 | .2 | .2 | .2 | .2 | .0 | .0 | .0 | .0 | .0 |
Depreciation, % | 17.8 | 23.5 | -72.19 | -22.09 | 100 | 9.4 | 9.4 | 9.4 | 9.4 | 9.4 |
EBIT | -6.3 | -28.6 | -17.7 | -21.7 | -22.4 | .0 | .0 | .0 | .0 | .0 |
EBIT, % | -631.5 | -2864.5 | 5545.94 | 2383.85 | 100 | 20 | 20 | 20 | 20 | 20 |
Total Cash | 6.4 | 57.8 | 47.2 | 32.1 | 15.4 | .0 | .0 | .0 | .0 | .0 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 1.5 | .5 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables, % | 149.3 | 50 | 0 | 0 | 100 | 50 | 50 | 50 | 50 | 50 |
Inventories | -1.5 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Inventories, % | -149.3 | 0 | 0 | 0 | 100 | 0 | 0 | 0 | 0 | 0 |
Accounts Payable | 1.2 | 1.2 | 1.5 | 2.1 | 3.5 | .0 | .0 | .0 | .0 | .0 |
Accounts Payable, % | 124.5 | 119.8 | -460.31 | -234.29 | 100 | 20 | 20 | 20 | 20 | 20 |
Capital Expenditure | .0 | -.2 | -.1 | -.2 | .0 | .0 | .0 | .0 | .0 | .0 |
Capital Expenditure, % | -1.1 | -15.6 | 35.94 | 25.05 | 100 | -3.34 | -3.34 | -3.34 | -3.34 | -3.34 |
Tax Rate, % | 0.48556 | 0.48556 | 0.48556 | 0.48556 | 0.48556 | 0.48556 | 0.48556 | 0.48556 | 0.48556 | 0.48556 |
EBITAT | -6.5 | -12.7 | -18.4 | -20.8 | -22.3 | .0 | .0 | .0 | .0 | .0 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -5.1 | -13.1 | -17.5 | -20.1 | -20.7 | -3.5 | .0 | .0 | .0 | .0 |
WACC, % | 6.49 | 6.36 | 6.49 | 6.48 | 6.49 | 6.46 | 6.46 | 6.46 | 6.46 | 6.46 |
PV UFCF | ||||||||||
SUM PV UFCF | -3.3 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 0 | |||||||||
Terminal Value | 0 | |||||||||
Present Terminal Value | 0 | |||||||||
Enterprise Value | -3 | |||||||||
Net Debt | -14 | |||||||||
Equity Value | 11 | |||||||||
Diluted Shares Outstanding, MM | 221 | |||||||||
Equity Value Per Share | 0.05 |
What You Will Get
- Editable Forecast Inputs: Easily modify key assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: Purple Biotech Ltd. (PPBT) financial data pre-loaded to facilitate your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically.
- Customizable and Professional: A sleek Excel model tailored to meet your valuation requirements.
- Built for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and enhancing efficiency.
Key Features
- Comprehensive Financial Data: Access reliable pre-loaded historical performance and future forecasts for Purple Biotech Ltd. (PPBT).
- Adjustable Forecast Parameters: Modify highlighted cells for key metrics such as WACC, growth rates, and profit margins.
- Real-Time Calculations: Automatic updates for DCF, Net Present Value (NPV), and cash flow assessments.
- Interactive Dashboard: User-friendly charts and summaries to effectively visualize your valuation insights.
- Designed for All Users: A straightforward, intuitive layout suitable for investors, CFOs, and consultants alike.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Purple Biotech Ltd. (PPBT) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Purple Biotech Ltd.'s (PPBT) intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose Purple Biotech Ltd. (PPBT) Calculator?
- Accuracy: Utilizes real Purple Biotech financial data to ensure precision.
- Flexibility: Built for users to easily adjust and test various inputs.
- Time-Saving: Avoid the complexities of creating a financial model from the ground up.
- Professional-Grade: Crafted with the expertise and usability expected at the CFO level.
- User-Friendly: Intuitive design makes it accessible for users with varying financial backgrounds.
Who Should Use Purple Biotech Ltd. (PPBT)?
- Healthcare Investors: Develop comprehensive and accurate valuation models for assessing biotech investments.
- Corporate Strategy Teams: Evaluate valuation scenarios to inform strategic decisions within the biotech sector.
- Consultants and Advisors: Deliver precise valuation analyses for clients interested in Purple Biotech Ltd. (PPBT).
- Students and Educators: Utilize real-time data to enhance learning and practice in financial modeling related to biotech.
- Biotech Enthusiasts: Gain insights into how companies like Purple Biotech Ltd. (PPBT) are valued in the investment landscape.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Purple Biotech Ltd. (PPBT) 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 Purple Biotech Ltd. (PPBT).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.