MediWound Ltd. (MDWD) DCF Valuation
- ✓ 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
MediWound Ltd. (MDWD) Bundle
Whether you’re an investor or analyst, this (MDWD) DCF Calculator is your go-to resource for accurate valuation. Equipped with real data from MediWound Ltd., you can adjust forecasts and instantly observe the effects.
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 | 31.8 | 21.8 | 23.8 | 26.5 | 18.7 | 16.8 | 15.1 | 13.6 | 12.2 | 11.0 |
Revenue Growth, % | 0 | -31.54 | 9.19 | 11.5 | -29.48 | -10.08 | -10.08 | -10.08 | -10.08 | -10.08 |
EBITDA | 3.4 | -7.8 | -11.2 | -18.1 | -4.9 | -5.6 | -5.0 | -4.5 | -4.1 | -3.7 |
EBITDA, % | 10.77 | -35.61 | -47.22 | -68.27 | -26.19 | -33.3 | -33.3 | -33.3 | -33.3 | -33.3 |
Depreciation | 1.2 | 1.1 | 1.2 | 1.3 | 1.3 | .9 | .8 | .7 | .6 | .6 |
Depreciation, % | 3.62 | 5.01 | 5.21 | 4.8 | 6.97 | 5.12 | 5.12 | 5.12 | 5.12 | 5.12 |
EBIT | 2.3 | -8.8 | -12.5 | -19.4 | -6.2 | -6.5 | -5.8 | -5.2 | -4.7 | -4.2 |
EBIT, % | 7.15 | -40.62 | -52.43 | -73.06 | -33.16 | -38.42 | -38.42 | -38.42 | -38.42 | -38.42 |
Total Cash | 29.5 | 21.6 | 11.0 | 33.9 | 41.5 | 14.7 | 13.2 | 11.9 | 10.7 | 9.6 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 4.1 | 2.8 | 2.3 | 9.3 | 4.4 | 3.2 | 2.8 | 2.6 | 2.3 | 2.1 |
Account Receivables, % | 12.92 | 12.71 | 9.54 | 35.22 | 23.65 | 18.81 | 18.81 | 18.81 | 18.81 | 18.81 |
Inventories | 1.6 | 1.4 | 1.2 | 2.0 | 2.8 | 1.3 | 1.2 | 1.1 | 1.0 | .9 |
Inventories, % | 5.07 | 6.34 | 5.05 | 7.41 | 15.23 | 7.82 | 7.82 | 7.82 | 7.82 | 7.82 |
Accounts Payable | 4.1 | 3.0 | 4.7 | 5.7 | 5.5 | 3.3 | 2.9 | 2.6 | 2.4 | 2.1 |
Accounts Payable, % | 12.79 | 13.75 | 19.75 | 21.35 | 29.58 | 19.44 | 19.44 | 19.44 | 19.44 | 19.44 |
Capital Expenditure | -.8 | -.9 | -.5 | -.6 | -6.5 | -1.5 | -1.4 | -1.2 | -1.1 | -1.0 |
Capital Expenditure, % | -2.49 | -4.24 | -2.06 | -2.09 | -34.59 | -9.1 | -9.1 | -9.1 | -9.1 | -9.1 |
Tax Rate, % | -2.83 | -2.83 | -2.83 | -2.83 | -2.83 | -2.83 | -2.83 | -2.83 | -2.83 | -2.83 |
EBITAT | 4.1 | -9.1 | -12.5 | -19.4 | -6.4 | -6.5 | -5.8 | -5.2 | -4.7 | -4.2 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 2.8 | -8.5 | -9.4 | -25.6 | -7.6 | -6.6 | -6.3 | -5.7 | -5.1 | -4.6 |
WACC, % | 8.34 | 8.34 | 8.34 | 8.34 | 8.34 | 8.34 | 8.34 | 8.34 | 8.34 | 8.34 |
PV UFCF | ||||||||||
SUM PV UFCF | -22.6 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -5 | |||||||||
Terminal Value | -73 | |||||||||
Present Terminal Value | -49 | |||||||||
Enterprise Value | -72 | |||||||||
Net Debt | -6 | |||||||||
Equity Value | -66 | |||||||||
Diluted Shares Outstanding, MM | 9 | |||||||||
Equity Value Per Share | -7.36 |
What You Will Get
- Comprehensive MDWD 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 in real-time.
- Scenario Analysis: Evaluate various scenarios to assess MediWound's future performance.
- User-Friendly Design: Designed for professionals while remaining accessible for newcomers.
Key Features
- Comprehensive Data: MediWound Ltd.'s historical financial records and pre-filled projections.
- Customizable Inputs: Modify WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Real-Time Results: View MediWound Ltd.'s intrinsic value update instantly.
- Dynamic Visuals: Dashboard graphs showcase valuation outcomes and essential metrics.
- Designed for Precision: A reliable tool for analysts, investors, and finance professionals.
How It Works
- 1. Access the Template: Download and open the Excel file featuring MediWound Ltd.'s (MDWD) financial data.
- 2. Adjust Key Inputs: Modify essential parameters such as growth rates, WACC, and capital expenditures.
- 3. Analyze Results in Real-Time: The DCF model automatically computes intrinsic value and NPV based on your inputs.
- 4. Explore Different Scenarios: Evaluate various forecasts to assess different valuation possibilities.
- 5. Present with Assurance: Deliver professional valuation analyses to inform your strategic decisions.
Why Choose This Calculator for MediWound Ltd. (MDWD)?
- Accurate Data: Utilize real MediWound financials for dependable valuation outcomes.
- Customizable: Tailor key inputs such as growth projections, discount rates, and tax assumptions to fit your analysis.
- Time-Saving: Pre-configured calculations streamline the process, eliminating the need to build from the ground up.
- Professional-Grade Tool: Crafted for investors, analysts, and healthcare consultants.
- User-Friendly: An intuitive design and clear instructions ensure accessibility for all users.
Who Should Use This Product?
- Individual Investors: Gain insights to make informed decisions about buying or selling MediWound Ltd. (MDWD) stock.
- Financial Analysts: Enhance valuation processes with comprehensive financial models tailored for MediWound Ltd. (MDWD).
- Consultants: Provide clients with accurate and timely valuation insights related to MediWound Ltd. (MDWD).
- Business Owners: Learn how companies like MediWound Ltd. (MDWD) are valued to inform your own business strategy.
- Finance Students: Explore real-world data and scenarios to master valuation techniques relevant to MediWound Ltd. (MDWD).
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled MediWound Ltd. (MDWD) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), featuring parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models illustrating intrinsic value with comprehensive calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to facilitate analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for MediWound Ltd. (MDWD).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to simplify result analysis.