Unity Biotechnology, Inc. (UBX) DCF Valuation

Unity Biotechnology, Inc. (UBX) DCF Valuation
  • 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

Unity Biotechnology, Inc. (UBX) Bundle

DCF model
Get Full Bundle:
$25 $15
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7

TOTAL:

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
Account Receivables, % 100 100 0 99.58 100
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.