|
ARVINAS, Inc. (ARVN) 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
Arvinas, Inc. (ARVN) Bundle
¡Simplifique la valoración de Arvinas, Inc. (ARVN) con esta calculadora DCF personalizable! Con el Real Arvinas, Inc. (ARVN) Financials y las entradas de pronóstico ajustables, puede probar escenarios y descubrir el valor razonable de Arvinas, Inc. (ARVN) 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 | 43.0 | 21.8 | 46.7 | 131.4 | 78.5 | 100.2 | 127.8 | 163.2 | 208.2 | 265.7 |
Revenue Growth, % | 0 | -49.27 | 114.2 | 181.37 | -40.26 | 27.62 | 27.62 | 27.62 | 27.62 | 27.62 |
EBITDA | -68.0 | -117.6 | -183.6 | -256.9 | -394.8 | -100.2 | -127.8 | -163.2 | -208.2 | -265.7 |
EBITDA, % | -158.12 | -539.41 | -393.15 | -195.51 | -502.93 | -100 | -100 | -100 | -100 | -100 |
Depreciation | 2.3 | 4.0 | 6.0 | 8.2 | 6.7 | 10.3 | 13.1 | 16.7 | 21.4 | 27.3 |
Depreciation, % | 5.24 | 18.46 | 12.85 | 6.24 | 8.54 | 10.27 | 10.27 | 10.27 | 10.27 | 10.27 |
EBIT | -70.2 | -121.6 | -189.6 | -265.1 | -401.5 | -100.2 | -127.8 | -163.2 | -208.2 | -265.7 |
EBIT, % | -163.36 | -557.87 | -406 | -201.75 | -511.46 | -100 | -100 | -100 | -100 | -100 |
Total Cash | 280.9 | 688.5 | 1,502.6 | 1,205.3 | 1,261.0 | 100.2 | 127.8 | 163.2 | 208.2 | 265.7 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 6.3 | 1.0 | 25.7 | 8.0 | 7.2 | 17.9 | 22.9 | 29.2 | 37.3 | 47.6 |
Account Receivables, % | 14.61 | 4.59 | 55.03 | 6.09 | 9.17 | 17.9 | 17.9 | 17.9 | 17.9 | 17.9 |
Inventories | .0 | .0 | 4.5 | 5.5 | .0 | 2.8 | 3.5 | 4.5 | 5.8 | 7.3 |
Inventories, % | 0 | 0 | 9.64 | 4.19 | 0 | 2.76 | 2.76 | 2.76 | 2.76 | 2.76 |
Accounts Payable | 4.6 | 7.1 | 31.3 | 5.7 | 17.8 | 27.5 | 35.1 | 44.8 | 57.1 | 72.9 |
Accounts Payable, % | 10.6 | 32.57 | 67.02 | 4.34 | 22.68 | 27.44 | 27.44 | 27.44 | 27.44 | 27.44 |
Capital Expenditure | -6.2 | -6.4 | -4.7 | -6.8 | -2.9 | -12.6 | -16.1 | -20.6 | -26.3 | -33.5 |
Capital Expenditure, % | -14.53 | -29.57 | -10.06 | -5.18 | -3.69 | -12.61 | -12.61 | -12.61 | -12.61 | -12.61 |
Tax Rate, % | -0.93432 | -0.93432 | -0.93432 | -0.93432 | -0.93432 | -0.93432 | -0.93432 | -0.93432 | -0.93432 | -0.93432 |
EBITAT | -62.1 | -113.9 | -181.9 | -287.2 | -405.3 | -95.8 | -122.2 | -156.0 | -199.0 | -254.0 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -67.8 | -108.5 | -185.6 | -294.7 | -383.1 | -101.9 | -123.3 | -157.4 | -200.9 | -256.3 |
WACC, % | 13.7 | 13.71 | 13.71 | 13.71 | 13.71 | 13.71 | 13.71 | 13.71 | 13.71 | 13.71 |
PV UFCF | ||||||||||
SUM PV UFCF | -547.1 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -261 | |||||||||
Terminal Value | -2,234 | |||||||||
Present Terminal Value | -1,175 | |||||||||
Enterprise Value | -1,722 | |||||||||
Net Debt | -309 | |||||||||
Equity Value | -1,414 | |||||||||
Diluted Shares Outstanding, MM | 56 | |||||||||
Equity Value Per Share | -25.48 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real ARVN financials.
- Real-World Data: Historical data and forward-looking estimates (as indicated in the yellow cells).
- Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Instantly observe the effect of your inputs on Arvinas, Inc.'s valuation.
- Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Design: Organized for clarity and ease of use, complete with step-by-step instructions.
Key Features
- Pre-Loaded Data: Arvinas, Inc.'s historical financial statements and pre-filled forecasts.
- Fully Adjustable Inputs: Modify WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Instant Results: View Arvinas, Inc.'s intrinsic value recalculating in real time.
- Clear Visual Outputs: Dashboard charts illustrate valuation results and essential metrics.
- Built for Accuracy: A professional tool designed for analysts, investors, and finance experts.
How It Works
- 1. Access the Template: Download and open the Excel file containing Arvinas, Inc.'s (ARVN) preloaded data.
- 2. Adjust Assumptions: Modify key parameters such as growth rates, WACC, and capital expenditures.
- 3. View Results Instantly: The DCF model automatically calculates the intrinsic value and NPV.
- 4. Explore Scenarios: Evaluate multiple forecasts to assess various valuation outcomes.
- 5. Present with Confidence: Deliver professional valuation insights to back your decisions.
Why Choose Arvinas, Inc. (ARVN) Calculator?
- Save Time: Skip the hassle of building a model from the ground up – it's ready for immediate use.
- Enhance Accuracy: Dependable financial data and formulas minimize valuation errors.
- Fully Customizable: Adjust the model to align with your specific assumptions and forecasts.
- Simple to Understand: Intuitive charts and outputs facilitate easy analysis of results.
- Endorsed by Professionals: Crafted for experts who prioritize precision and functionality.
Who Should Use This Product?
- Biotech Students: Explore drug development processes and analyze real-world data.
- Researchers: Utilize advanced models for studies related to biopharmaceuticals.
- Investors: Evaluate your investment strategies and assess valuation metrics for Arvinas, Inc. (ARVN).
- Market Analysts: Enhance your analysis with a customizable financial model tailored for biotech firms.
- Healthcare Entrepreneurs: Understand the valuation techniques applied to leading biotech companies like Arvinas, Inc. (ARVN).
What the Template Contains
- Pre-Filled Data: Features Arvinas, Inc.'s historical financials and projections.
- Discounted Cash Flow Model: Customizable DCF valuation model with automated calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on user-defined inputs.
- Key Financial Ratios: Evaluate Arvinas, Inc.'s profitability, efficiency, and leverage.
- Customizable Inputs: Modify revenue growth, profit margins, and tax rates effortlessly.
- Clear Dashboard: Visuals and tables summarizing essential valuation outcomes.