|
IDEAYA Biosciences, Inc. (IDYA) DCF Valuation
US | Healthcare | Biotechnology | NASDAQ
|
- ✓ 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
IDEAYA Biosciences, Inc. (IDYA) Bundle
Looking to determine the intrinsic value of IDEAYA Biosciences, Inc.? Our IDYA DCF Calculator integrates real-world data with extensive customization features, allowing you to refine your 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 | 19.5 | 27.9 | 50.9 | 23.4 | 27.5 | 32.5 | 38.2 | 45.0 | 53.0 |
Revenue Growth, % | 0 | 0 | 43.01 | 82.28 | -54.08 | 17.8 | 17.8 | 17.8 | 17.8 | 17.8 |
EBITDA | -43.0 | -34.0 | -48.5 | -60.4 | -130.4 | -16.5 | -19.5 | -22.9 | -27.0 | -31.8 |
EBITDA, % | 100 | -173.83 | -173.73 | -118.59 | -557.71 | -60 | -60 | -60 | -60 | -60 |
Depreciation | 1.2 | 1.4 | 1.7 | 2.1 | 4.0 | 7.4 | 8.7 | 10.3 | 12.1 | 14.3 |
Depreciation, % | 100 | 7.07 | 6.17 | 4.13 | 17.14 | 26.9 | 26.9 | 26.9 | 26.9 | 26.9 |
EBIT | -44.3 | -35.3 | -50.3 | -62.5 | -134.4 | -16.5 | -19.5 | -22.9 | -27.0 | -31.8 |
EBIT, % | 100 | -180.9 | -179.91 | -122.72 | -574.85 | -60 | -60 | -60 | -60 | -60 |
Total Cash | 100.5 | 283.6 | 368.1 | 373.1 | 525.1 | 27.5 | 32.5 | 38.2 | 45.0 | 53.0 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | .0 | 1.9 | 1.1 | .2 | .0 | 6.3 | 7.4 | 8.7 | 10.3 | 12.1 |
Account Receivables, % | 100 | 9.61 | 3.95 | 0.41429 | 0.07697242 | 22.81 | 22.81 | 22.81 | 22.81 | 22.81 |
Inventories | .0 | .0 | -121.3 | -8.3 | .0 | -.9 | -1.1 | -1.2 | -1.5 | -1.7 |
Inventories, % | 100 | 0 | -434.1 | -16.33 | 0 | -3.27 | -3.27 | -3.27 | -3.27 | -3.27 |
Accounts Payable | .7 | 1.0 | 2.1 | 4.3 | 6.6 | 8.2 | 9.7 | 11.4 | 13.4 | 15.8 |
Accounts Payable, % | 100 | 4.88 | 7.52 | 8.4 | 28.21 | 29.8 | 29.8 | 29.8 | 29.8 | 29.8 |
Capital Expenditure | -1.4 | -.5 | -2.6 | -3.4 | -2.4 | -1.6 | -1.9 | -2.2 | -2.6 | -3.1 |
Capital Expenditure, % | 100 | -2.52 | -9.46 | -6.76 | -10.13 | -5.77 | -5.77 | -5.77 | -5.77 | -5.77 |
Tax Rate, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
EBITAT | -40.5 | -33.1 | -48.0 | -58.4 | -134.4 | -15.7 | -18.5 | -21.7 | -25.6 | -30.2 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -39.9 | -33.8 | 74.3 | -169.6 | -138.6 | -13.6 | -11.1 | -13.1 | -15.4 | -18.1 |
WACC, % | 8.49 | 8.49 | 8.49 | 8.49 | 8.49 | 8.49 | 8.49 | 8.49 | 8.49 | 8.49 |
PV UFCF | ||||||||||
SUM PV UFCF | -55.4 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -19 | |||||||||
Terminal Value | -285 | |||||||||
Present Terminal Value | -190 | |||||||||
Enterprise Value | -245 | |||||||||
Net Debt | -154 | |||||||||
Equity Value | -91 | |||||||||
Diluted Shares Outstanding, MM | 58 | |||||||||
Equity Value Per Share | -1.58 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real IDEAYA Biosciences, Inc. (IDYA) financials.
- Real-World Data: Historical data and forward-looking estimates (highlighted in the yellow cells).
- Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Instantly observe the effect of your inputs on IDEAYA's valuation.
- Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Design: Organized for clarity and ease of use, complete with step-by-step instructions.
Key Features
- 🔍 Real-Life IDYA Financials: Pre-filled historical and projected data for IDEAYA Biosciences, Inc. (IDYA).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate IDEAYA’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize IDEAYA’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered IDEAYA Biosciences data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for IDEAYA Biosciences' intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for IDEAYA Biosciences, Inc. (IDYA)?
- Designed for Experts: An advanced tool tailored for biotech analysts, investors, and researchers.
- Accurate Data: IDEAYA's historical and forecasted financial information preloaded for precision.
- Flexible Scenario Analysis: Easily test various projections and assumptions.
- Comprehensive Outputs: Automatically computes intrinsic value, NPV, and essential metrics.
- User-Friendly: Step-by-step guidance simplifies the calculation process.
Who Should Use IDEAYA Biosciences, Inc. (IDYA)?
- Biotechnology Students: Explore drug development processes and apply theoretical knowledge to real-world scenarios.
- Researchers: Integrate cutting-edge research findings into academic projects or studies.
- Investors: Evaluate your investment strategies and assess the potential of IDEAYA's pipeline.
- Healthcare Analysts: Enhance your analysis with a detailed understanding of IDEAYA's clinical trials and market positioning.
- Pharmaceutical Professionals: Gain insights into the biotech landscape and how companies like IDEAYA operate within it.
What the Template Contains
- Preloaded IDYA Data: Historical and projected financial data, including revenue, EBIT, and research and development 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.