|
NuCana plc (NCNA) DCF Valuation
GB | Healthcare | Biotechnology | NASDAQ
|
- ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
- ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
- ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
- ✓ Aucune Expertise N'Est Requise; Facile À Suivre
NuCana plc (NCNA) Bundle
Looking to determine NuCana plc's intrinsic value? Our (NCNA) DCF Calculator integrates real-world data with extensive customization features, enabling you to adjust forecasts and enhance your investment strategies.
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 | .0 | .0 | .0 | -65.3 | -36.2 | .0 | .0 | .0 | .0 | .0 |
| EBITDA, % | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |
| Depreciation | .0 | 1.1 | 1.2 | .9 | .7 | .0 | .0 | .0 | .0 | .0 |
| Depreciation, % | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |
| EBIT | .0 | -1.1 | -1.2 | -66.2 | -36.9 | .0 | .0 | .0 | .0 | .0 |
| EBIT, % | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |
| Total Cash | 65.0 | 109.3 | 75.4 | 52.4 | 21.6 | .0 | .0 | .0 | .0 | .0 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | .0 | .0 | .0 | .0 | 7.3 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables, % | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |
| Inventories | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Inventories, % | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |
| Accounts Payable | 3.0 | 2.8 | 2.3 | 6.0 | 4.2 | .0 | .0 | .0 | .0 | .0 |
| Accounts Payable, % | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |
| Capital Expenditure | -1.6 | -2.0 | -1.3 | -.6 | -.6 | .0 | .0 | .0 | .0 | .0 |
| Capital Expenditure, % | 100 | 100 | 100 | 100 | 100 | 0 | 0 | 0 | 0 | 0 |
| Tax Rate, % | 13.73 | 13.73 | 13.73 | 13.73 | 13.73 | 13.73 | 13.73 | 13.73 | 13.73 | 13.73 |
| EBITAT | .0 | -.9 | -1.0 | -55.1 | -31.8 | .0 | .0 | .0 | .0 | .0 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 1.5 | -2.1 | -1.7 | -51.1 | -40.8 | 3.1 | .0 | .0 | .0 | .0 |
| WACC, % | 41.06 | 41.59 | 41.58 | 40.98 | 42.16 | 41.47 | 41.47 | 41.47 | 41.47 | 41.47 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 2.2 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 0 | |||||||||
| Terminal Value | 0 | |||||||||
| Present Terminal Value | 0 | |||||||||
| Enterprise Value | 2 | |||||||||
| Net Debt | -21 | |||||||||
| Equity Value | 23 | |||||||||
| Diluted Shares Outstanding, MM | 2 | |||||||||
| Equity Value Per Share | 11.02 |
What You Will Get
- Comprehensive NCNA Financials: Access to historical and projected data for precise valuation.
- Customizable Parameters: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Dynamic Calculations: Intrinsic value and NPV are computed in real-time.
- Scenario Analysis: Explore various scenarios to assess NuCana's future performance.
- User-Friendly Interface: Designed for professionals while remaining approachable for newcomers.
Key Features
- Customizable Clinical Parameters: Adjust key metrics such as trial phases, patient demographics, and treatment regimens.
- Instant DCF Analysis: Provides immediate calculations of intrinsic value, NPV, and other financial metrics.
- High Precision Results: Utilizes NuCana plc's (NCNA) actual financial data for accurate valuation assessments.
- Simplified Scenario Testing: Easily evaluate various hypotheses and analyze results side-by-side.
- Efficiency Booster: Removes the necessity of constructing intricate valuation models from the ground up.
How It Works
- Step 1: Download the Excel file for NuCana plc (NCNA).
- Step 2: Review NuCana’s pre-filled financial data and forecasts.
- Step 3: Modify key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you adjust your assumptions.
- Step 5: Analyze the outputs and leverage the results for your investment decisions.
Why Choose This Calculator for NuCana plc (NCNA)?
- User-Friendly Interface: Tailored for both novice and experienced users.
- Customizable Inputs: Adjust parameters to accurately represent your financial analysis.
- Real-Time Feedback: Observe immediate updates to NuCana's valuation as you change inputs.
- Preloaded Data: Comes with NuCana's actual financial metrics for efficient evaluation.
- Relied Upon by Experts: Utilized by analysts and investors for strategic decision-making.
Who Should Use This Product?
- Pharmaceutical Students: Understand drug development processes and apply them using real-world case studies.
- Researchers: Utilize advanced models for analyzing clinical trial data and outcomes.
- Investors: Evaluate your investment strategies and assess the potential of NuCana plc (NCNA) stock.
- Market Analysts: Enhance your analysis with a customizable model tailored for biotech companies.
- Healthcare Professionals: Gain insights into how innovative biotech firms like NuCana plc (NCNA) are assessed in the market.
What the Template Contains
- Pre-Filled Data: Contains NuCana plc's historical financials and projections.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations for ease of use.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC using custom inputs.
- Key Financial Ratios: Evaluate NuCana plc's profitability, efficiency, and leverage metrics.
- Customizable Inputs: Easily modify revenue growth, margins, and tax rates as needed.
- Clear Dashboard: Visual representations such as charts and tables summarizing essential valuation outcomes.