Repare Therapeutics Inc. (RPTX) 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
Repare Therapeutics Inc. (RPTX) Bundle
Evaluate Repare Therapeutics Inc. (RPTX) financial outlook like an expert! This (RPTX) DCF Calculator provides you with pre-filled financial data and total flexibility to modify revenue growth, WACC, margins, and other essential assumptions to align with your projections.
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 | .1 | 7.6 | 131.8 | 51.1 | 68.9 | 92.8 | 125.0 | 168.3 | 226.7 |
Revenue Growth, % | 0 | 0 | 5529.63 | 1634.61 | -61.21 | 34.7 | 34.7 | 34.7 | 34.7 | 34.7 |
EBITDA | -25.5 | -53.4 | -107.2 | -17.8 | -114.3 | -29.4 | -39.6 | -53.4 | -71.9 | -96.8 |
EBITDA, % | 100 | -39559.26 | -1410.38 | -13.52 | -223.48 | -42.7 | -42.7 | -42.7 | -42.7 | -42.7 |
Depreciation | 1.0 | 1.8 | 3.3 | 4.2 | 2.0 | 34.6 | 46.6 | 62.7 | 84.5 | 113.8 |
Depreciation, % | 100 | 1323.7 | 44 | 3.17 | 3.82 | 50.2 | 50.2 | 50.2 | 50.2 | 50.2 |
EBIT | -26.5 | -55.2 | -110.5 | -22.0 | -116.2 | -29.8 | -40.2 | -54.2 | -72.9 | -98.3 |
EBIT, % | 100 | -40882.96 | -1454.38 | -16.69 | -227.3 | -43.34 | -43.34 | -43.34 | -43.34 | -43.34 |
Total Cash | 94.8 | 333.7 | 341.9 | 343.9 | 223.6 | 68.9 | 92.8 | 125.0 | 168.3 | 226.7 |
Total Cash, percent | .0 | .2 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 3.1 | 6.2 | 3.2 | 4.3 | 15.3 | 38.0 | 51.2 | 68.9 | 92.8 | 125.0 |
Account Receivables, % | 100 | 4565.93 | 42.55 | 3.28 | 29.95 | 55.16 | 55.16 | 55.16 | 55.16 | 55.16 |
Inventories | .0 | .0 | .0 | -2.8 | .0 | 13.5 | 18.2 | 24.5 | 32.9 | 44.4 |
Inventories, % | 100 | 0 | 0 | -2.13 | 0 | 19.57 | 19.57 | 19.57 | 19.57 | 19.57 |
Accounts Payable | 2.1 | 2.3 | 2.3 | .5 | 2.4 | 32.4 | 43.7 | 58.8 | 79.2 | 106.7 |
Accounts Payable, % | 100 | 1667.41 | 30.29 | 0.34969 | 4.69 | 47.07 | 47.07 | 47.07 | 47.07 | 47.07 |
Capital Expenditure | -1.3 | -2.2 | -1.7 | -.6 | -1.9 | -17.4 | -23.5 | -31.6 | -42.6 | -57.4 |
Capital Expenditure, % | 100 | -1657.04 | -22.24 | -0.45665 | -3.79 | -25.3 | -25.3 | -25.3 | -25.3 | -25.3 |
Tax Rate, % | 9.09 | 9.09 | 9.09 | 9.09 | 9.09 | 9.09 | 9.09 | 9.09 | 9.09 | 9.09 |
EBITAT | -26.6 | -53.9 | -108.8 | -46.0 | -105.7 | -29.1 | -39.2 | -52.7 | -71.0 | -95.7 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -27.9 | -57.3 | -104.2 | -42.5 | -117.5 | -18.1 | -22.7 | -30.5 | -41.1 | -55.4 |
WACC, % | 7.62 | 7.61 | 7.61 | 7.62 | 7.59 | 7.61 | 7.61 | 7.61 | 7.61 | 7.61 |
PV UFCF | ||||||||||
SUM PV UFCF | -129.9 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -56 | |||||||||
Terminal Value | -1,007 | |||||||||
Present Terminal Value | -698 | |||||||||
Enterprise Value | -828 | |||||||||
Net Debt | -108 | |||||||||
Equity Value | -720 | |||||||||
Diluted Shares Outstanding, MM | 42 | |||||||||
Equity Value Per Share | -17.11 |
What You Will Get
- Real RPTX Financial Data: Pre-filled with Repare Therapeutics Inc.’s historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See Repare Therapeutics Inc.’s intrinsic value update instantly based on your changes.
- Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
- User-Friendly Design: Simple structure and clear instructions for all experience levels.
Key Features
- Comprehensive Data: Repare Therapeutics Inc.'s (RPTX) historical financial reports and pre-filled projections.
- Customizable Inputs: Modify WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Real-Time Insights: Observe Repare's intrinsic value recalculating instantly.
- Intuitive Visual Outputs: Dashboard graphs showcase valuation results and essential metrics.
- Designed for Precision: A professional-grade tool tailored for analysts, investors, and finance professionals.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Repare Therapeutics data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Repare Therapeutics’ intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for Repare Therapeutics Inc. (RPTX)?
- Designed for Industry Experts: A sophisticated tool tailored for analysts, investors, and biotech professionals.
- Comprehensive Data: Repare Therapeutics’ historical and projected financials preloaded for precision.
- Flexible Scenario Analysis: Easily simulate various forecasts and assumptions to assess different outcomes.
- Insightful Outputs: Automatically calculates intrinsic value, NPV, and essential financial metrics.
- User-Friendly Interface: Step-by-step guidance ensures a smooth and efficient calculation process.
Who Should Use This Product?
- Biotech Students: Explore drug development processes and apply them using real-world data on Repare Therapeutics Inc. (RPTX).
- Researchers: Integrate cutting-edge models into your studies or publications related to cancer therapies.
- Investors: Validate your investment strategies and assess the potential of Repare Therapeutics Inc. (RPTX) in the biotech market.
- Market Analysts: Optimize your analysis with a tailored, user-friendly model for evaluating biotech companies.
- Healthcare Professionals: Understand how innovative companies like Repare Therapeutics Inc. (RPTX) are assessed in the industry.
What the Template Contains
- Pre-Filled Data: Includes Repare Therapeutics Inc.'s historical financials and projections.
- Discounted Cash Flow Model: Editable DCF valuation model with automated calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on user-defined inputs.
- Key Financial Ratios: Evaluate Repare Therapeutics Inc.'s profitability, efficiency, and leverage.
- Customizable Inputs: Easily modify revenue growth, profit margins, and tax rates.
- Clear Dashboard: Visual representations and tables summarizing essential valuation outcomes.