Puma Biotechnology, Inc. (PBYI) DCF Valuation

Puma Biotechnology, Inc. (PBYI) DCF Valuation
  • Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
  • Design Profissional: Modelos Confiáveis ​​E Padrão Da Indústria
  • Pré-Construídos Para Uso Rápido E Eficiente
  • Não É Necessária Experiência; Fácil De Seguir

Puma Biotechnology, Inc. (PBYI) 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:

Optimize your time and improve precision with our [PBYI] DCF Calculator! Equipped with real data from Puma Biotechnology, Inc. and customizable assumptions, this tool empowers you to forecast, analyze, and evaluate [Company] as a seasoned investor would.


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 272.3 225.1 253.2 228.0 235.6 228.9 222.3 216.0 209.8 203.8
Revenue Growth, % 0 -17.33 12.48 -9.95 3.35 -2.86 -2.86 -2.86 -2.86 -2.86
EBITDA -55.7 -38.5 -5.4 21.0 47.5 -4.7 -4.6 -4.5 -4.3 -4.2
EBITDA, % -20.46 -17.12 -2.13 9.2 20.17 -2.07 -2.07 -2.07 -2.07 -2.07
Depreciation 4.8 7.2 10.6 8.9 11.5 8.2 8.0 7.8 7.5 7.3
Depreciation, % 1.76 3.2 4.19 3.91 4.89 3.59 3.59 3.59 3.59 3.59
EBIT -60.5 -45.7 -16.0 12.0 36.0 -13.0 -12.6 -12.2 -11.9 -11.5
EBIT, % -22.23 -20.32 -6.32 5.28 15.28 -5.66 -5.66 -5.66 -5.66 -5.66
Total Cash 60.0 85.3 63.1 76.2 95.9 72.8 70.7 68.7 66.7 64.8
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 28.9 25.5 32.5 40.4 48.5
Account Receivables, % 10.61 11.35 12.85 17.7 20.58
Inventories 3.2 3.5 7.1 4.5 7.1 4.8 4.7 4.5 4.4 4.3
Inventories, % 1.16 1.53 2.81 1.99 3 2.1 2.1 2.1 2.1 2.1
Accounts Payable 19.2 12.1 11.2 6.4 6.9 10.3 10.0 9.7 9.5 9.2
Accounts Payable, % 7.04 5.36 4.41 2.82 2.92 4.51 4.51 4.51 4.51 4.51
Capital Expenditure -.3 -20.0 .0 -7.0 -12.6 -8.0 -7.8 -7.5 -7.3 -7.1
Capital Expenditure, % -0.11238 -8.91 0 -3.07 -5.36 -3.49 -3.49 -3.49 -3.49 -3.49
Tax Rate, % 4.78 4.78 4.78 4.78 4.78 4.78 4.78 4.78 4.78 4.78
EBITAT -66.2 -45.9 -16.2 22.0 34.3 -12.8 -12.5 -12.1 -11.8 -11.4
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF -74.6 -62.8 -17.1 13.9 22.9 8.1 -11.4 -11.1 -10.8 -10.5
WACC, % 10.59 10.59 10.59 10.59 10.34 10.54 10.54 10.54 10.54 10.54
PV UFCF
SUM PV UFCF -23.8
Long Term Growth Rate, % 3.00
Free cash flow (T + 1) -11
Terminal Value -143
Present Terminal Value -87
Enterprise Value -111
Net Debt 27
Equity Value -138
Diluted Shares Outstanding, MM 48
Equity Value Per Share -2.89

What You Will Receive

  • Authentic PBYI Financial Data: Pre-filled with Puma Biotechnology’s historical and projected figures for accurate analysis.
  • Customizable Template: Easily adjust key inputs such as revenue growth, WACC, and EBITDA %.
  • Instant Calculations: Witness PBYI’s intrinsic value update in real-time as you make changes.
  • Expert Valuation Tool: Tailored for investors, analysts, and consultants aiming for precise DCF outcomes.
  • Intuitive Design: Clear layout and straightforward instructions suitable for all skill levels.

Key Features

  • Real-Life PBYI Data: Pre-filled with Puma Biotechnology’s historical financials and forward-looking projections.
  • Fully Customizable Inputs: Adjust revenue growth, margins, WACC, tax rates, and capital expenditures.
  • Dynamic Valuation Model: Automatic updates to Net Present Value (NPV) and intrinsic value based on your inputs.
  • Scenario Testing: Create multiple forecast scenarios to analyze different valuation outcomes.
  • User-Friendly Design: Simple, structured, and designed for professionals and beginners alike.

How It Works

  • 1. Download the Template: Obtain and open the Excel file featuring Puma Biotechnology, Inc.'s (PBYI) preloaded data.
  • 2. Adjust Assumptions: Modify key variables such as growth rates, WACC, and capital expenditures.
  • 3. View Immediate Results: The DCF model calculates intrinsic value and NPV in real-time.
  • 4. Explore Different Scenarios: Analyze various forecasts to evaluate different valuation outcomes.
  • 5. Present with Assurance: Share professional valuation insights to back your strategic decisions.

Why Choose This Calculator for Puma Biotechnology, Inc. (PBYI)?

  • Designed for Experts: A sophisticated tool utilized by analysts, CFOs, and industry consultants.
  • Accurate Data: Puma Biotechnology’s historical and projected financials are preloaded for precision.
  • Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
  • Detailed Outputs: Automatically computes intrinsic value, NPV, and essential metrics.
  • User-Friendly: Step-by-step guidance ensures a smooth experience throughout the process.

Who Should Use This Product?

  • Investors: Evaluate Puma Biotechnology’s valuation before making stock transactions.
  • CFOs and Financial Analysts: Enhance valuation methodologies and assess financial forecasts.
  • Startup Founders: Understand the valuation strategies of established biotech firms like Puma Biotechnology.
  • Consultants: Create detailed valuation reports for your clients in the biotech sector.
  • Students and Educators: Utilize current data to explore and teach valuation principles.

What the Template Contains

  • Pre-Filled Data: Includes Puma Biotechnology’s historical financials and projections.
  • Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations tailored for (PBYI).
  • Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on customized inputs for (PBYI).
  • Key Financial Ratios: Analyze Puma Biotechnology’s profitability, efficiency, and leverage.
  • Customizable Inputs: Easily edit revenue growth, margins, and tax rates specific to (PBYI).
  • Clear Dashboard: Charts and tables summarizing key valuation results for (PBYI).