Shattuck Labs, Inc. (STTK) DCF Valuation
- ✓ 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
Shattuck Labs, Inc. (STTK) Bundle
Explore the financial potential of Shattuck Labs, Inc. (STTK) with our user-friendly DCF Calculator! Enter your projections for growth, margins, and expenses to determine the intrinsic value of Shattuck Labs, Inc. (STTK) and refine your investment approach.
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 | 9.9 | 9.9 | 30.0 | .7 | 1.7 | 2.1 | 2.6 | 3.3 | 4.1 | 5.2 |
Revenue Growth, % | 0 | 0.47537 | 202.16 | -97.83 | 154.14 | 25.66 | 25.66 | 25.66 | 25.66 | 25.66 |
EBITDA | -24.5 | -36.3 | -43.9 | -100.3 | -87.6 | -2.1 | -2.6 | -3.3 | -4.1 | -5.2 |
EBITDA, % | -248.1 | -365.54 | -146.21 | -15376.69 | -5287.57 | -100 | -100 | -100 | -100 | -100 |
Depreciation | .5 | .6 | 1.4 | 3.4 | 4.0 | .9 | 1.1 | 1.4 | 1.8 | 2.2 |
Depreciation, % | 5.43 | 6.22 | 4.6 | 517.64 | 243.93 | 43.25 | 43.25 | 43.25 | 43.25 | 43.25 |
EBIT | -25.1 | -36.9 | -45.3 | -103.6 | -91.7 | -2.1 | -2.6 | -3.3 | -4.1 | -5.2 |
EBIT, % | -253.53 | -371.76 | -150.81 | -15894.33 | -5531.5 | -100 | -100 | -100 | -100 | -100 |
Total Cash | 39.1 | 335.4 | 268.8 | 161.3 | 130.6 | 2.1 | 2.6 | 3.3 | 4.1 | 5.2 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Inventories | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Inventories, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Accounts Payable | 3.1 | 1.8 | 10.0 | 7.2 | 1.6 | 1.2 | 1.5 | 1.8 | 2.3 | 2.9 |
Accounts Payable, % | 30.86 | 17.66 | 33.35 | 1099.69 | 95.78 | 55.53 | 55.53 | 55.53 | 55.53 | 55.53 |
Capital Expenditure | -.5 | -.7 | -7.9 | -11.6 | -.4 | -.7 | -.9 | -1.1 | -1.3 | -1.7 |
Capital Expenditure, % | -4.75 | -7.32 | -26.41 | -1781.29 | -24.56 | -32.61 | -32.61 | -32.61 | -32.61 | -32.61 |
Tax Rate, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
EBITAT | -25.0 | -35.8 | -44.6 | -102.2 | -91.7 | -2.1 | -2.6 | -3.2 | -4.1 | -5.1 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -21.8 | -37.2 | -42.9 | -113.3 | -93.6 | -2.3 | -2.0 | -2.5 | -3.2 | -4.0 |
WACC, % | 12.59 | 12.58 | 12.59 | 12.59 | 12.6 | 12.59 | 12.59 | 12.59 | 12.59 | 12.59 |
PV UFCF | ||||||||||
SUM PV UFCF | -9.5 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -4 | |||||||||
Terminal Value | -38 | |||||||||
Present Terminal Value | -21 | |||||||||
Enterprise Value | -31 | |||||||||
Net Debt | -121 | |||||||||
Equity Value | 91 | |||||||||
Diluted Shares Outstanding, MM | 43 | |||||||||
Equity Value Per Share | 2.13 |
What You Will Get
- Real STTK Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: 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 Shattuck Labs' future performance.
- User-Friendly Design: Designed for professionals but easy for beginners to navigate.
Key Features
- Comprehensive DCF Calculator: Features in-depth unlevered and levered DCF valuation models tailored for Shattuck Labs, Inc. (STTK).
- WACC Calculator: Pre-designed Weighted Average Cost of Capital sheet with adjustable parameters for precise analysis.
- Customizable Forecast Assumptions: Easily alter growth projections, capital expenditures, and discount rates to fit your analysis.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specifically for Shattuck Labs, Inc. (STTK).
- Interactive Dashboard and Charts: Visual representations provide a clear overview of essential valuation metrics for streamlined analysis.
How It Works
- Step 1: Download the prebuilt Excel template featuring Shattuck Labs, Inc. (STTK) data.
- Step 2: Review the pre-filled sheets to familiarize yourself with the key metrics.
- Step 3: Modify forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly see recalculated results, including Shattuck Labs, Inc. (STTK)'s intrinsic value.
- Step 5: Make informed investment decisions or create reports based on the outputs.
Why Choose the Shattuck Labs, Inc. (STTK) Calculator?
- All-in-One Solution: Combines DCF, WACC, and financial ratio analyses tailored for Shattuck Labs.
- Flexible Inputs: Modify yellow-highlighted cells to explore different financial scenarios.
- In-Depth Analysis: Automatically computes Shattuck Labs’ intrinsic value and Net Present Value.
- Ready-to-Use Data: Historical and projected data provide reliable starting points for analysis.
- High-Quality Standards: Perfect for financial analysts, investors, and business consultants focused on Shattuck Labs.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and precise valuation models for analyzing Shattuck Labs, Inc. (STTK).
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the organization.
- Consultants and Advisors: Deliver clients accurate valuation insights for Shattuck Labs, Inc. (STTK).
- Students and Educators: Utilize real-world data to enhance learning and practice in financial modeling.
- Biotech Enthusiasts: Gain insights into how biotech firms like Shattuck Labs, Inc. (STTK) are valued in the marketplace.
What the Template Contains
- Comprehensive DCF Model: Editable template featuring detailed valuation calculations specific to Shattuck Labs, Inc. (STTK).
- Real-World Data: Shattuck Labs' historical and projected financials preloaded for thorough analysis.
- Customizable Parameters: Modify WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights into performance.
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage metrics.
- Dashboard with Visual Outputs: Charts and tables designed for clear, actionable results.