Werewolf Therapeutics, Inc. (HOWL) 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
Werewolf Therapeutics, Inc. (HOWL) Bundle
Explore Werewolf Therapeutics, Inc.'s (HOWL) financial outlook with our user-friendly DCF Calculator! Enter your projections for growth, margins, and expenses to determine Werewolf Therapeutics, Inc.'s (HOWL) intrinsic value and enhance your investment strategy.
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 | 16.4 | 19.9 | 21.0 | 22.2 | 23.4 | 24.6 | 25.9 |
Revenue Growth, % | 0 | 0 | 0 | 0 | 21.6 | 5.4 | 5.4 | 5.4 | 5.4 | 5.4 |
EBITDA | -9.4 | -14.3 | -49.2 | -51.3 | -32.5 | 4.2 | 4.4 | 4.7 | 4.9 | 5.2 |
EBITDA, % | 100 | 100 | 100 | -312.79 | -162.79 | 20 | 20 | 20 | 20 | 20 |
Depreciation | .5 | .8 | .7 | 2.5 | 1.8 | 13.6 | 14.4 | 15.1 | 16.0 | 16.8 |
Depreciation, % | 100 | 100 | 100 | 15.3 | 8.85 | 64.83 | 64.83 | 64.83 | 64.83 | 64.83 |
EBIT | -9.9 | -15.0 | -50.0 | -53.8 | -34.2 | 4.2 | 4.4 | 4.7 | 4.9 | 5.2 |
EBIT, % | 100 | 100 | 100 | -328.09 | -171.63 | 20 | 20 | 20 | 20 | 20 |
Total Cash | 17.9 | 92.6 | 157.5 | 129.3 | 134.3 | 21.0 | 22.2 | 23.4 | 24.6 | 25.9 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | .0 | .0 | .0 | 6.9 | 1.4 | 14.7 | 15.5 | 16.3 | 17.2 | 18.1 |
Account Receivables, % | 100 | 100 | 100 | 42.24 | 6.77 | 69.8 | 69.8 | 69.8 | 69.8 | 69.8 |
Inventories | .0 | .0 | .0 | .0 | .0 | 12.6 | 13.3 | 14.0 | 14.8 | 15.6 |
Inventories, % | 100 | 100 | 100 | 0.000012194378 | 0 | 60 | 60 | 60 | 60 | 60 |
Accounts Payable | .6 | 1.0 | 2.0 | 1.2 | 1.3 | 13.2 | 13.9 | 14.7 | 15.5 | 16.3 |
Accounts Payable, % | 100 | 100 | 100 | 7.44 | 6.7 | 62.83 | 62.83 | 62.83 | 62.83 | 62.83 |
Capital Expenditure | -.3 | -.6 | -.5 | -3.6 | -.8 | -1.1 | -1.1 | -1.2 | -1.3 | -1.3 |
Capital Expenditure, % | 100 | 100 | 100 | -22.02 | -3.86 | -5.17 | -5.17 | -5.17 | -5.17 | -5.17 |
Tax Rate, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
EBITAT | -10.6 | -14.9 | -49.8 | -51.6 | -34.2 | 4.2 | 4.4 | 4.6 | 4.9 | 5.1 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -9.8 | -14.3 | -48.5 | -60.4 | -27.5 | 2.6 | 16.8 | 17.7 | 18.7 | 19.7 |
WACC, % | 6.23 | 6.21 | 6.22 | 6.11 | 6.23 | 6.2 | 6.2 | 6.2 | 6.2 | 6.2 |
PV UFCF | ||||||||||
SUM PV UFCF | 61.5 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 20 | |||||||||
Terminal Value | 479 | |||||||||
Present Terminal Value | 355 | |||||||||
Enterprise Value | 416 | |||||||||
Net Debt | -82 | |||||||||
Equity Value | 498 | |||||||||
Diluted Shares Outstanding, MM | 36 | |||||||||
Equity Value Per Share | 13.98 |
What You Will Receive
- Customizable Excel Template: A fully adjustable Excel-based DCF Calculator featuring pre-filled real HOWL financial data.
- Authentic Data: Historical performance metrics and forward-looking projections (highlighted in the yellow cells).
- Flexible Forecasting: Modify key assumptions such as revenue growth, EBITDA %, and WACC.
- Instant Calculations: Quickly observe how your inputs affect Werewolf Therapeutics’ valuation.
- Professional Resource: Designed for investors, CFOs, consultants, and financial analysts.
- Intuitive Design: Organized for clarity and ease of navigation, complete with step-by-step guidance.
Key Features
- 🔍 Real-Life HOWL Financials: Pre-filled historical and projected data for Werewolf Therapeutics, Inc.
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Werewolf Therapeutics’ intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Werewolf Therapeutics’ valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- 1. Access the Template: Download and open the Excel file featuring Werewolf Therapeutics, Inc. (HOWL) preloaded data.
- 2. Modify Assumptions: Adjust essential inputs such as growth rates, WACC, and capital expenditures.
- 3. View Results Instantly: The DCF model automatically calculates intrinsic value and NPV in real-time.
- 4. Explore Scenarios: Analyze various forecasts to evaluate different valuation outcomes.
- 5. Present with Confidence: Deliver professional valuation insights to bolster your decision-making process.
Why Choose This Calculator for Werewolf Therapeutics, Inc. (HOWL)?
- Accurate Data: Utilize real Werewolf Therapeutics financials for dependable valuation outcomes.
- Customizable: Tailor essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Pre-configured calculations streamline your process, avoiding the need to begin from scratch.
- Professional-Grade Tool: Crafted for investors, analysts, and consultants in the biotech sector.
- User-Friendly: Easy-to-navigate design and step-by-step guidance cater to users of all experience levels.
Who Should Use This Product?
- Investors: Accurately assess Werewolf Therapeutics, Inc.'s (HOWL) fair value prior to making investment decisions.
- CFOs: Utilize a professional-grade DCF model for comprehensive financial reporting and analysis.
- Consultants: Easily customize the template for valuation reports tailored to clients in the biotech sector.
- Entrepreneurs: Acquire insights into financial modeling practices utilized by leading biotech firms.
- Educators: Employ it as a teaching resource to illustrate valuation methodologies specific to the pharmaceutical industry.
What the Template Contains
- Pre-Filled Data: Includes Werewolf Therapeutics’ historical financials and forecasts.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
- Key Financial Ratios: Analyze Werewolf Therapeutics’ profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
- Clear Dashboard: Charts and tables summarizing key valuation results.