Unity Biotechnology, Inc. (UBX) 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
Unity Biotechnology, Inc. (UBX) Bundle
Discover the true value of Unity Biotechnology, Inc. (UBX) with our advanced DCF Calculator! Adjust key assumptions, explore various scenarios, and assess how changes affect Unity Biotechnology, Inc. (UBX) valuation – all within one convenient Excel template.
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 | 4.8 | .2 | .0 | .0 | .0 | .0 | .0 | .0 |
Revenue Growth, % | 0 | 0 | 0 | -95.07 | -100 | -48.77 | -48.77 | -48.77 | -48.77 | -48.77 |
EBITDA | -89.7 | -89.1 | -54.7 | -38.7 | -37.3 | .0 | .0 | .0 | .0 | .0 |
EBITDA, % | 100 | 100 | -1142.73 | -16411.44 | 100 | 20 | 20 | 20 | 20 | 20 |
Depreciation | 2.7 | 3.4 | 2.9 | 2.2 | 1.2 | .0 | .0 | .0 | .0 | .0 |
Depreciation, % | 100 | 100 | 60.2 | 923.73 | 100 | 92.04 | 92.04 | 92.04 | 92.04 | 92.04 |
EBIT | -92.3 | -92.6 | -57.5 | -40.9 | -38.5 | .0 | .0 | .0 | .0 | .0 |
EBIT, % | 100 | 100 | -1202.93 | -17335.17 | 100 | 20 | 20 | 20 | 20 | 20 |
Total Cash | 127.5 | 97.7 | 88.1 | 94.8 | 43.2 | .0 | .0 | .0 | .0 | .0 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | .0 | .0 | .0 | .2 | 1.6 | .0 | .0 | .0 | .0 | .0 |
Account Receivables, % | 100 | 100 | 0 | 99.58 | 100 | 79.92 | 79.92 | 79.92 | 79.92 | 79.92 |
Inventories | .0 | .0 | .0 | -.2 | .0 | .0 | .0 | .0 | .0 | .0 |
Inventories, % | 100 | 100 | 0 | -99.58 | 100 | 40.08 | 40.08 | 40.08 | 40.08 | 40.08 |
Accounts Payable | 5.2 | 2.6 | 2.0 | 1.8 | 1.4 | .0 | .0 | .0 | .0 | .0 |
Accounts Payable, % | 100 | 100 | 41.49 | 758.47 | 100 | 88.3 | 88.3 | 88.3 | 88.3 | 88.3 |
Capital Expenditure | -1.6 | -.6 | -.2 | -.1 | .0 | .0 | .0 | .0 | .0 | .0 |
Capital Expenditure, % | 100 | 100 | -4.08 | -40.68 | 100 | -8.95 | -8.95 | -8.95 | -8.95 | -8.95 |
Tax Rate, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
EBITAT | -84.1 | -90.6 | -56.9 | -39.4 | -38.5 | .0 | .0 | .0 | .0 | .0 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -77.8 | -90.4 | -54.8 | -37.5 | -39.3 | .2 | .0 | .0 | .0 | .0 |
WACC, % | 5.57 | 5.77 | 5.8 | 5.73 | 5.83 | 5.74 | 5.74 | 5.74 | 5.74 | 5.74 |
PV UFCF | ||||||||||
SUM PV UFCF | .2 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 0 | |||||||||
Terminal Value | 0 | |||||||||
Present Terminal Value | 0 | |||||||||
Enterprise Value | 0 | |||||||||
Net Debt | 7 | |||||||||
Equity Value | -7 | |||||||||
Diluted Shares Outstanding, MM | 15 | |||||||||
Equity Value Per Share | -0.47 |
What You Will Get
- Real Unity Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Unity Biotechnology, Inc. (UBX).
- Full Customization: Adjust all critical parameters (yellow cells) such as WACC, growth %, and tax rates to fit your analysis.
- Instant Valuation Updates: Automatic recalculations to assess the impact of changes on Unity’s fair value.
- Versatile Excel Template: Designed for quick edits, scenario testing, and detailed projections specific to Unity Biotechnology, Inc. (UBX).
- Time-Saving and Accurate: Avoid the hassle of building models from scratch while ensuring precision and flexibility.
Key Features
- Comprehensive Data: Unity Biotechnology's historical financial records and pre-filled projections.
- Customizable Inputs: Modify WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Real-Time Results: Observe Unity's intrinsic value recalculating instantly.
- Intuitive Visual Outputs: Dashboard graphs illustrate valuation outcomes and essential metrics.
- Designed for Precision: A professional-grade tool tailored for analysts, investors, and finance professionals.
How It Works
- 1. Open the Template: Download and access the Excel file featuring Unity Biotechnology, Inc.'s (UBX) preloaded data.
- 2. Edit Assumptions: Modify essential inputs such as growth rates, WACC, and capital investments.
- 3. View Results Instantly: The DCF model automatically computes intrinsic value and NPV.
- 4. Test Scenarios: Evaluate various forecasts to explore different valuation results.
- 5. Use with Confidence: Deliver professional valuation insights to enhance your decision-making.
Why Choose This Calculator for Unity Biotechnology, Inc. (UBX)?
- Accuracy: Utilizes real Unity Biotechnology financials for precise data.
- Flexibility: Allows users to easily test and modify inputs as needed.
- Time-Saving: Eliminate the complexities of constructing a DCF model from the ground up.
- Professional-Grade: Crafted with the precision and usability expected by CFOs.
- User-Friendly: Intuitive design makes it accessible for users with varying levels of financial modeling expertise.
Who Should Use This Product?
- Investors: Accurately estimate Unity Biotechnology’s fair value before making investment decisions.
- CFOs: Leverage a professional-grade DCF model for financial reporting and analysis related to (UBX).
- Consultants: Quickly adapt the template for valuation reports tailored to clients interested in (UBX).
- Entrepreneurs: Gain insights into financial modeling techniques utilized by leading biotech firms.
- Educators: Use it as a teaching tool to illustrate valuation methodologies specific to the biotechnology sector.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Unity Biotechnology, Inc. 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 Unity Biotechnology, Inc. (UBX).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.