PureTech Health plc (PRTC) 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
PureTech Health plc (PRTC) Bundle
Reveal the true value of PureTech Health plc with our professional-grade DCF Calculator! Adjust key assumptions, explore various scenarios, and examine how changes affect PureTech Health plc (PRTC) valuation – all within a single Excel template.
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 | 8.7 | 8.3 | 10.0 | 2.1 | 3.3 | 3.3 | 3.3 | 3.2 | 3.2 | 3.2 |
Revenue Growth, % | 0 | -3.99 | 19.64 | -79.06 | 59.33 | -1.02 | -1.02 | -1.02 | -1.02 | -1.02 |
EBITDA | 458.5 | 62.7 | -47.0 | -52.2 | -11.6 | -.7 | -.7 | -.6 | -.6 | -.6 |
EBITDA, % | 5276.82 | 751.55 | -470.51 | -2497.03 | -349.16 | -20 | -20 | -20 | -20 | -20 |
Depreciation | 6.7 | 6.7 | 7.2 | 8.9 | 4.9 | 2.8 | 2.8 | 2.8 | 2.7 | 2.7 |
Depreciation, % | 76.72 | 79.79 | 72.53 | 425.5 | 148.14 | 85.81 | 85.81 | 85.81 | 85.81 | 85.81 |
EBIT | 451.8 | 56.0 | -54.2 | -61.1 | -16.6 | -.7 | -.7 | -.6 | -.6 | -.6 |
EBIT, % | 5200.1 | 671.77 | -543.04 | -2922.54 | -497.3 | -20 | -20 | -20 | -20 | -20 |
Total Cash | 162.4 | 403.9 | 465.7 | 350.1 | 327.1 | 3.3 | 3.3 | 3.2 | 3.2 | 3.2 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 2.3 | 2.9 | 3.6 | 12.3 | 2.4 | 1.8 | 1.8 | 1.7 | 1.7 | 1.7 |
Account Receivables, % | 26.78 | 35.24 | 35.97 | 589.33 | 71.35 | 53.87 | 53.87 | 53.87 | 53.87 | 53.87 |
Inventories | .0 | 7.5 | 28.0 | .0 | .0 | 1.3 | 1.2 | 1.2 | 1.2 | 1.2 |
Inventories, % | 0.000011510129 | 90.26 | 280.58 | 0.00004784689 | 0 | 38.05 | 38.05 | 38.05 | 38.05 | 38.05 |
Accounts Payable | 11.1 | 8.9 | 11.3 | 26.5 | 14.6 | 3.3 | 3.3 | 3.2 | 3.2 | 3.2 |
Accounts Payable, % | 127.74 | 106.34 | 113.69 | 1268.09 | 439.52 | 100 | 100 | 100 | 100 | 100 |
Capital Expenditure | -12.5 | -5.4 | -5.7 | -2.2 | -.2 | -2.2 | -2.1 | -2.1 | -2.1 | -2.1 |
Capital Expenditure, % | -144.31 | -65.03 | -56.73 | -104.11 | -7.36 | -65.82 | -65.82 | -65.82 | -65.82 | -65.82 |
Tax Rate, % | -81.97 | -81.97 | -81.97 | -81.97 | -81.97 | -81.97 | -81.97 | -81.97 | -81.97 | -81.97 |
EBITAT | 397.7 | 13.5 | -57.6 | -24.4 | -30.1 | -.5 | -.5 | -.5 | -.5 | -.4 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 400.6 | 4.4 | -74.7 | 16.7 | -27.4 | -11.8 | .2 | .2 | .2 | .2 |
WACC, % | 9.29 | 9.14 | 9.32 | 9.17 | 9.32 | 9.25 | 9.25 | 9.25 | 9.25 | 9.25 |
PV UFCF | ||||||||||
SUM PV UFCF | -10.2 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 0 | |||||||||
Terminal Value | 3 | |||||||||
Present Terminal Value | 2 | |||||||||
Enterprise Value | -9 | |||||||||
Net Debt | -166 | |||||||||
Equity Value | 157 | |||||||||
Diluted Shares Outstanding, MM | 276 | |||||||||
Equity Value Per Share | 0.57 |
What You Will Get
- Comprehensive PRTC Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Real-Time Calculations: Intrinsic value and NPV are calculated automatically.
- Scenario Analysis: Evaluate multiple scenarios to assess PureTech Health’s future performance.
- User-Friendly Design: Crafted for professionals while remaining approachable for newcomers.
Key Features
- Comprehensive Data: PureTech Health plc's (PRTC) historical financial records and pre-filled projections.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Real-Time Results: View PureTech Health plc's (PRTC) intrinsic value recalculating instantly.
- Intuitive Visual Outputs: Dashboard graphs showcase valuation outcomes and essential metrics.
- Designed for Precision: A professional-grade tool for analysts, investors, and financial professionals.
How It Works
- Step 1: Download the prebuilt Excel template featuring PureTech Health plc’s (PRTC) data.
- Step 2: Navigate through the pre-filled sheets to grasp the essential metrics.
- Step 3: Revise forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly access recalculated results, including PureTech Health plc’s (PRTC) intrinsic value.
- Step 5: Make well-informed investment decisions or create reports based on the outputs.
Why Choose This Calculator for PureTech Health plc (PRTC)?
- All-in-One Solution: Features DCF, WACC, and financial ratio analyses tailored for PureTech Health plc (PRTC).
- Flexible Inputs: Modify the yellow-highlighted cells to explore different financial scenarios.
- In-Depth Analysis: Automatically computes PureTech Health plc's (PRTC) intrinsic value and Net Present Value.
- Preloaded Information: Historical and projected data provide reliable foundational insights.
- Expert-Level Tool: Perfect for financial analysts, investors, and business advisors focusing on PureTech Health plc (PRTC).
Who Should Use PureTech Health plc (PRTC)?
- Investors: Gain insights into innovative healthcare solutions with a trusted partner.
- Healthcare Analysts: Streamline your research with access to comprehensive market data and analysis.
- Consultants: Easily modify reports and presentations to showcase client opportunities in biotech.
- Biotech Enthusiasts: Enhance your knowledge of emerging therapies and their market potential.
- Educators and Students: Utilize it as a case study in biotechnology and healthcare investment courses.
What the Template Contains
- Preloaded PRTC Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
- DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
- Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.