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
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 | 33.5 | 32.5 | 31.6 | 30.7 | 29.8 |
Account Receivables, % | 10.61 | 11.35 | 12.85 | 17.7 | 20.58 | 14.62 | 14.62 | 14.62 | 14.62 | 14.62 |
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).