PolyPid Ltd. (PYPD) DCF Valuation
- ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
- ✓ Professional Design: Trusted, Industry-Standard Templates
- ✓ Pre-Built For Quick And Efficient Use
- ✓ No Expertise Is Needed; Easy To Follow
PolyPid Ltd. (PYPD) Bundle
Explore the financial prospects of PolyPid Ltd. (PYPD) with our user-friendly DCF Calculator! Enter your assumptions regarding growth, margins, and expenses to calculate the intrinsic value of PolyPid Ltd. (PYPD) and enhance your investment strategy.
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 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Revenue Growth, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
EBITDA | -5.9 | -35.9 | -41.5 | -36.4 | -20.3 | .0 | .0 | .0 | .0 | .0 |
EBITDA, % | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |
Depreciation | .9 | 1.0 | 1.1 | 1.7 | 1.8 | .0 | .0 | .0 | .0 | .0 |
Depreciation, % | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |
EBIT | -6.9 | -36.9 | -42.6 | -38.1 | -22.1 | .0 | .0 | .0 | .0 | .0 |
EBIT, % | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |
Total Cash | 26.6 | 44.5 | 32.2 | 12.6 | 5.6 | .0 | .0 | .0 | .0 | .0 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | .0 | -.3 | .0 | -.2 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables, % | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |
Inventories | .4 | .6 | -22.5 | .2 | .0 | .0 | .0 | .0 | .0 | .0 |
Inventories, % | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |
Accounts Payable | 1.6 | 1.0 | 4.1 | 1.1 | .8 | .0 | .0 | .0 | .0 | .0 |
Accounts Payable, % | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |
Capital Expenditure | -.9 | -1.2 | -3.0 | -1.8 | -.2 | .0 | .0 | .0 | .0 | .0 |
Capital Expenditure, % | 100 | 100 | 100 | 100 | 100 | 0 | 0 | 0 | 0 | 0 |
Tax Rate, % | -0.28996 | -0.28996 | -0.28996 | -0.28996 | -0.28996 | -0.28996 | -0.28996 | -0.28996 | -0.28996 | -0.28996 |
EBITAT | 4.7 | -35.3 | -41.0 | -38.2 | -22.1 | .0 | .0 | .0 | .0 | .0 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 6.0 | -36.1 | -16.8 | -63.7 | -20.9 | -.8 | .0 | .0 | .0 | .0 |
WACC, % | 2.73 | 13.08 | 13.12 | 13.54 | 13.54 | 11.2 | 11.2 | 11.2 | 11.2 | 11.2 |
PV UFCF | ||||||||||
SUM PV UFCF | -.7 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 0 | |||||||||
Terminal Value | 0 | |||||||||
Present Terminal Value | 0 | |||||||||
Enterprise Value | -1 | |||||||||
Net Debt | 6 | |||||||||
Equity Value | -7 | |||||||||
Diluted Shares Outstanding, MM | 1 | |||||||||
Equity Value Per Share | -4.89 |
What You Will Get
- Comprehensive PYPD Financials: Access to both historical and projected data for precise valuation.
- Customizable Inputs: Adjust parameters like WACC, tax rates, revenue growth, and capital expenditures.
- Dynamic Calculations: Intrinsic value and NPV are computed in real-time.
- Scenario Analysis: Evaluate various scenarios to assess PolyPid's future performance.
- User-Friendly Interface: Designed for experts but easy for newcomers to navigate.
Key Features
- Comprehensive DCF Calculator: Offers detailed unlevered and levered DCF valuation models tailored for PolyPid Ltd. (PYPD).
- WACC Calculator: Pre-designed Weighted Average Cost of Capital sheet with adjustable inputs specific to PYPD.
- Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates to fit PolyPid's projections.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios relevant to PolyPid Ltd. (PYPD).
- Visual Dashboard and Charts: Graphical representations summarize essential valuation metrics for straightforward analysis.
How It Works
- 1. Access the Model: Download and open the Excel file containing PolyPid Ltd.'s (PYPD) financial data.
- 2. Adjust Variables: Modify essential inputs such as revenue growth, discount rates, and operating expenses.
- 3. Analyze Results Immediately: The DCF model automatically computes the intrinsic value and net present value (NPV).
- 4. Explore Scenarios: Evaluate various projections to understand different valuation possibilities.
- 5. Present with Assurance: Deliver expert valuation insights to enhance your strategic decisions.
Why Choose This Calculator for PolyPid Ltd. (PYPD)?
- Designed for Experts: A sophisticated tool utilized by industry analysts, financial officers, and strategic consultants.
- Accurate Financial Insights: PolyPid’s historical and projected financial data preloaded for precise analysis.
- Flexible Scenario Analysis: Effortlessly model various forecasts and assumptions to explore outcomes.
- Comprehensive Outputs: Automatically computes intrinsic value, NPV, and essential financial metrics.
- User-Friendly Interface: Step-by-step guidance ensures a smooth calculation experience.
Who Should Use This Product?
- Healthcare Investors: Develop comprehensive valuation models for assessing PolyPid Ltd. (PYPD) investment opportunities.
- Biotech Corporate Teams: Evaluate valuation scenarios to inform strategic decisions within the company.
- Consultants and Advisors: Offer clients precise valuation analyses for PolyPid Ltd. (PYPD) stock.
- Students and Educators: Utilize real-time data to learn and teach financial modeling in the biotech sector.
- Pharmaceutical Enthusiasts: Gain insights into how biotech firms like PolyPid Ltd. (PYPD) are valued in the market.
What the Template Contains
- Pre-Filled Data: Contains PolyPid Ltd.'s historical financials and projections.
- Discounted Cash Flow Model: Editable DCF valuation model featuring automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC with user-defined inputs.
- Key Financial Ratios: Assess PolyPid Ltd.'s profitability, efficiency, and leverage metrics.
- Customizable Inputs: Easily modify revenue growth, profit margins, and tax rates.
- Clear Dashboard: Visuals and tables that summarize essential valuation outcomes.