|
In8bio, Inc. (INAB) Valoración de DCF
US | Healthcare | Biotechnology | NASDAQ
|
- ✓ Completamente Editable: Adáptelo A Sus Necesidades En Excel O Sheets
- ✓ Diseño Profesional: Plantillas Confiables Y Estándares De La Industria
- ✓ Predeterminadas Para Un Uso Rápido Y Eficiente
- ✓ No Se Necesita Experiencia; Fáciles De Seguir
IN8bio, Inc. (INAB) Bundle
¡Simplifique la valoración de In8bio, Inc. (INAB) con esta calculadora DCF personalizable! Con Real In8bio, Inc. (INAB) Financials y las entradas de pronóstico ajustables, puede probar escenarios y descubrir el valor razonable de In8bio, Inc. (INAB) en minutos.
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 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Revenue Growth, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
EBITDA | -5.0 | -8.5 | -14.4 | -27.4 | -28.5 | .0 | .0 | .0 | .0 | .0 |
EBITDA, % | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |
Depreciation | .1 | .1 | .3 | 1.1 | 1.8 | .0 | .0 | .0 | .0 | .0 |
Depreciation, % | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |
EBIT | -5.1 | -8.6 | -14.7 | -28.5 | -30.3 | .0 | .0 | .0 | .0 | .0 |
EBIT, % | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |
Total Cash | .6 | 18.0 | 37.0 | 18.2 | 21.3 | .0 | .0 | .0 | .0 | .0 |
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, % | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |
Inventories | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Inventories, % | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |
Accounts Payable | .6 | .6 | .4 | 2.1 | .9 | .0 | .0 | .0 | .0 | .0 |
Accounts Payable, % | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |
Capital Expenditure | -.3 | .0 | -.3 | -3.7 | -.6 | .0 | .0 | .0 | .0 | .0 |
Capital Expenditure, % | 100 | 100 | 100 | 100 | 100 | 0 | 0 | 0 | 0 | 0 |
Tax Rate, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
EBITAT | -5.1 | -8.6 | -14.7 | -27.4 | -30.3 | .0 | .0 | .0 | .0 | .0 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -4.8 | -8.4 | -14.9 | -28.3 | -30.3 | -.9 | .0 | .0 | .0 | .0 |
WACC, % | 5.04 | 5.04 | 5.04 | 4.97 | 5.04 | 5.02 | 5.02 | 5.02 | 5.02 | 5.02 |
PV UFCF | ||||||||||
SUM PV UFCF | -.9 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 0 | |||||||||
Terminal Value | 0 | |||||||||
Present Terminal Value | 0 | |||||||||
Enterprise Value | -1 | |||||||||
Net Debt | -16 | |||||||||
Equity Value | 16 | |||||||||
Diluted Shares Outstanding, MM | 30 | |||||||||
Equity Value Per Share | 0.52 |
What You Will Get
- Real INAB Financial Data: Pre-filled with IN8bio’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 IN8bio’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 INAB Data: Pre-loaded with IN8bio's historical financial performance and future projections.
- Customizable Financial Inputs: Modify revenue growth rates, profit margins, discount rates, tax assumptions, and capital investment figures.
- Interactive Valuation Model: Instant recalculations of Net Present Value (NPV) and intrinsic value based on user-defined parameters.
- Multiple Scenario Analysis: Develop various forecasting scenarios to evaluate differing valuation results.
- Intuitive User Interface: Clean, organized layout suitable for both seasoned professionals and newcomers.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review IN8bio, Inc.'s pre-filled financial data and forecasts.
- Step 3: Modify critical inputs like revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Watch the DCF model update instantly as you tweak assumptions.
- Step 5: Analyze the outputs and use the results for investment decisions.
Why Choose the IN8bio, Inc. (INAB) Calculator?
- Accuracy: Utilizes real IN8bio financial data for precise calculations.
- Flexibility: Tailored for users to easily test and adjust inputs as needed.
- Time-Saving: Eliminate the tedious process of creating a financial model from the ground up.
- Professional-Grade: Crafted with the expertise and usability expected at the CFO level.
- User-Friendly: Intuitive design makes it accessible for users without extensive financial modeling skills.
Who Should Use This Product?
- Investors: Evaluate IN8bio, Inc. (INAB) to make informed decisions on buying or selling shares.
- CFOs and Financial Analysts: Optimize valuation methodologies and assess financial forecasts for IN8bio, Inc. (INAB).
- Startup Founders: Discover valuation strategies by examining how companies like IN8bio, Inc. (INAB) are assessed.
- Consultants: Create detailed valuation reports for clients based on insights from IN8bio, Inc. (INAB).
- Students and Educators: Utilize current data from IN8bio, Inc. (INAB) to enhance learning and teaching of valuation principles.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled IN8bio, Inc. (INAB) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for IN8bio, Inc. (INAB).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.