uniQure N.V. (QURE) 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
uniQure N.V. (QURE) Bundle
Evaluate uniQure N.V.'s financial prospects like a professional! This (QURE) DCF Calculator provides pre-filled financial data and allows you to easily modify assumptions such as revenue growth, WACC, margins, and more to align with your predictions.
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 | 7.3 | 37.5 | 524.0 | 106.5 | 15.8 | 17.2 | 18.8 | 20.4 | 22.2 | 24.2 |
Revenue Growth, % | 0 | 415.23 | 1296.82 | -79.68 | -85.12 | 8.8 | 8.8 | 8.8 | 8.8 | 8.8 |
EBITDA | -113.8 | -127.0 | 319.0 | -108.0 | -253.1 | -11.7 | -12.7 | -13.8 | -15.1 | -16.4 |
EBITDA, % | -1562.85 | -338.46 | 60.88 | -101.44 | -1597.55 | -67.82 | -67.82 | -67.82 | -67.82 | -67.82 |
Depreciation | 6.6 | 10.6 | 7.3 | 8.5 | 11.9 | 7.0 | 7.6 | 8.3 | 9.0 | 9.8 |
Depreciation, % | 90.65 | 28.38 | 1.39 | 8.02 | 75.11 | 40.71 | 40.71 | 40.71 | 40.71 | 40.71 |
EBIT | -120.4 | -137.6 | 311.7 | -116.6 | -265.0 | -11.7 | -12.8 | -13.9 | -15.1 | -16.4 |
EBIT, % | -1653.5 | -366.84 | 59.48 | -109.46 | -1672.66 | -68.1 | -68.1 | -68.1 | -68.1 | -68.1 |
Total Cash | 377.8 | 244.9 | 556.3 | 352.8 | 617.9 | 17.2 | 18.8 | 20.4 | 22.2 | 24.2 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | .9 | 6.6 | 58.8 | 102.4 | 4.2 | 5.7 | 6.2 | 6.7 | 7.3 | 7.9 |
Account Receivables, % | 13.01 | 17.64 | 11.22 | 96.14 | 26.47 | 32.89 | 32.89 | 32.89 | 32.89 | 32.89 |
Inventories | 4.7 | 4.3 | 10.5 | 6.9 | 12.0 | 5.5 | 6.0 | 6.6 | 7.1 | 7.8 |
Inventories, % | 64.8 | 11.56 | 2.01 | 6.5 | 75.89 | 32.15 | 32.15 | 32.15 | 32.15 | 32.15 |
Accounts Payable | 5.7 | 3.8 | 2.5 | 11.0 | 6.6 | 4.8 | 5.3 | 5.7 | 6.2 | 6.8 |
Accounts Payable, % | 78.02 | 10.05 | 0.47748 | 10.32 | 41.57 | 28.09 | 28.09 | 28.09 | 28.09 | 28.09 |
Capital Expenditure | -6.6 | -9.5 | -17.4 | -17.7 | -7.2 | -6.3 | -6.8 | -7.4 | -8.1 | -8.8 |
Capital Expenditure, % | -91.29 | -25.28 | -3.33 | -16.61 | -45.16 | -36.33 | -36.33 | -36.33 | -36.33 | -36.33 |
Tax Rate, % | -0.62664 | -0.62664 | -0.62664 | -0.62664 | -0.62664 | -0.62664 | -0.62664 | -0.62664 | -0.62664 | -0.62664 |
EBITAT | -124.1 | -121.6 | 308.7 | -115.2 | -266.7 | -11.4 | -12.4 | -13.5 | -14.7 | -16.0 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -124.1 | -127.7 | 238.9 | -155.9 | -173.2 | -7.4 | -12.2 | -13.2 | -14.4 | -15.7 |
WACC, % | 11.74 | 11.24 | 11.7 | 11.69 | 11.74 | 11.62 | 11.62 | 11.62 | 11.62 | 11.62 |
PV UFCF | ||||||||||
SUM PV UFCF | -44.2 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -16 | |||||||||
Terminal Value | -166 | |||||||||
Present Terminal Value | -96 | |||||||||
Enterprise Value | -140 | |||||||||
Net Debt | -103 | |||||||||
Equity Value | -37 | |||||||||
Diluted Shares Outstanding, MM | 48 | |||||||||
Equity Value Per Share | -0.78 |
What You Will Get
- Real QURE Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust discount rates, tax implications, revenue projections, and capital investments.
- Dynamic Calculations: Automatically computes intrinsic value and NPV in real-time.
- Scenario Analysis: Evaluate various scenarios to assess uniQure’s future performance.
- User-Friendly Design: Designed for professionals while remaining approachable for newcomers.
Key Features
- 🔍 Real-Life QURE Financials: Pre-filled historical and projected data for uniQure N.V. (QURE).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate uniQure’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize uniQure’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Download: Obtain the pre-formatted Excel file containing uniQure N.V.’s (QURE) financial data.
- Customize: Modify projections, such as revenue growth, EBITDA %, and WACC.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Develop various forecasts and analyze results immediately.
- Make Decisions: Leverage the valuation outcomes to inform your investment approach.
Why Choose This Calculator for uniQure N.V. (QURE)?
- Accurate Data: Access to up-to-date uniQure financials guarantees trustworthy valuation outcomes.
- Customizable: Modify essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Built-in calculations save you the hassle of starting from square one.
- Professional-Grade Tool: Tailored for investors, analysts, and consultants focused on uniQure.
- User-Friendly: An intuitive design and clear instructions make it accessible for all users.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and trustworthy valuation models for analyzing portfolios involving uniQure N.V. (QURE).
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the organization.
- Consultants and Advisors: Deliver precise valuation insights to clients interested in uniQure N.V. (QURE) stock.
- Students and Educators: Utilize real-world data to enhance learning and practice in financial modeling.
- Biotech Enthusiasts: Gain insights into how biotech companies like uniQure N.V. (QURE) are valued in the financial markets.
What the Template Contains
- Historical Data: Includes uniQure N.V.'s past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate uniQure N.V.'s intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
- Quarterly and Annual Statements: A complete breakdown of uniQure N.V.'s financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.