Arrowhead Pharmaceuticals, Inc. (ARWR) DCF Valuation

Arrowhead Pharmaceuticals, Inc. (ARWR) DCF Valuation
  • Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
  • Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
  • Pré-Construits Pour Une Utilisation Rapide Et Efficace
  • Aucune Expertise N'Est Requise; Facile À Suivre

Arrowhead Pharmaceuticals, Inc. (ARWR) 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:

Evaluate Arrowhead Pharmaceuticals, Inc.'s (ARWR) financial outlook like an expert! This (ARWR) DCF Calculator comes with pre-loaded financial data and provides you the flexibility to modify revenue growth, WACC, margins, and other critical assumptions to align with your projections.


Discounted Cash Flow (DCF) - (USD MM)

Year AY1
2020
AY2
2021
AY3
2022
AY4
2023
AY5
2024
FY1
2025
FY2
2026
FY3
2027
FY4
2028
FY5
2029
Revenue 88.0 138.3 243.2 240.7 3.6 3.8 4.2 4.5 4.9 5.3
Revenue Growth, % 0 57.16 75.89 -1.03 -98.52 8.37 8.37 8.37 8.37 8.37
EBITDA -87.2 -132.6 -162.3 -175.7 -561.5 -3.3 -3.6 -3.9 -4.3 -4.6
EBITDA, % -99.12 -95.87 -66.72 -72.97 -15812.81 -86.94 -86.94 -86.94 -86.94 -86.94
Depreciation 5.9 8.3 10.4 12.5 18.6 .9 1.0 1.1 1.2 1.3
Depreciation, % 6.75 5.98 4.28 5.19 523.66 24.44 24.44 24.44 24.44 24.44
EBIT -93.2 -140.8 -172.7 -188.2 -580.1 -3.5 -3.7 -4.1 -4.4 -4.8
EBIT, % -105.87 -101.85 -71.01 -78.16 -16336.47 -89.83 -89.83 -89.83 -89.83 -89.83
Total Cash 315.5 367.8 376.4 403.6 681.0 3.8 4.2 4.5 4.9 5.3
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables .8 10.3 1.4 .0 .0
Account Receivables, % 0.96108 7.42 0.5797 0 0
Inventories 4.3 4.4 -21.6 .0 .0 .0 .0 .0 .0 .0
Inventories, % 4.83 3.15 -8.89 0 0 -0.18018 -0.18018 -0.18018 -0.18018 -0.18018
Accounts Payable 6.8 9.5 2.9 35.9 11.4 1.0 1.1 1.2 1.3 1.4
Accounts Payable, % 7.76 6.84 1.18 14.9 320.7 26.14 26.14 26.14 26.14 26.14
Capital Expenditure -12.0 -23.6 -52.8 -176.7 -141.5 -1.7 -1.9 -2.0 -2.2 -2.4
Capital Expenditure, % -13.58 -17.04 -21.7 -73.42 -3983.92 -45.15 -45.15 -45.15 -45.15 -45.15
Tax Rate, % 2.12 2.12 2.12 2.12 2.12 2.12 2.12 2.12 2.12 2.12
EBITAT -93.2 -140.8 -176.5 -187.1 -567.8 -3.4 -3.7 -4.0 -4.4 -4.7
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF -97.4 -163.0 -190.6 -338.5 -715.2 -14.7 -4.5 -4.9 -5.3 -5.7
WACC, % 8.4 8.4 8.4 8.39 8.37 8.39 8.39 8.39 8.39 8.39
PV UFCF
SUM PV UFCF -28.9
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) -6
Terminal Value -92
Present Terminal Value -61
Enterprise Value -90
Net Debt 408
Equity Value -498
Diluted Shares Outstanding, MM 120
Equity Value Per Share -4.16

What You Will Get

  • Pre-Filled Financial Model: Arrowhead Pharmaceuticals’ actual data enables precise DCF valuation.
  • Full Forecast Control: Adjust revenue growth, margins, WACC, and other key drivers.
  • Instant Calculations: Automatic updates ensure you see results as you make changes.
  • Investor-Ready Template: A refined Excel file designed for professional-grade valuation.
  • Customizable and Reusable: Tailored for flexibility, allowing repeated use for detailed forecasts.

Key Features

  • Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for Arrowhead Pharmaceuticals, Inc. (ARWR).
  • WACC Calculator: Pre-configured Weighted Average Cost of Capital sheet with adjustable inputs specific to the biotech sector.
  • Customizable Forecast Assumptions: Adjust growth rates, research and development expenses, and discount rates as needed.
  • Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios for Arrowhead Pharmaceuticals, Inc. (ARWR).
  • Interactive Dashboard and Charts: Visual representations summarize essential valuation metrics for streamlined analysis.

How It Works

  1. Step 1: Download the Excel file for Arrowhead Pharmaceuticals, Inc. (ARWR).
  2. Step 2: Review Arrowhead's pre-filled financial data and projections.
  3. Step 3: Adjust key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
  4. Step 4: Observe the DCF model update in real-time as you modify assumptions.
  5. Step 5: Evaluate the outputs and leverage the results for your investment strategies.

Why Choose This Calculator for Arrowhead Pharmaceuticals, Inc. (ARWR)?

  • Comprehensive Tool: Integrates DCF, WACC, and financial ratio analyses tailored for ARWR.
  • Customizable Inputs: Modify the yellow-highlighted cells to explore different financial scenarios.
  • Detailed Insights: Automatically computes Arrowhead's intrinsic value and Net Present Value.
  • Preloaded Data: Features historical and forecasted data for precise evaluations.
  • Professional Quality: Perfect for financial analysts, investors, and business consultants focusing on ARWR.

Who Should Use This Product?

  • Investors: Accurately assess Arrowhead Pharmaceuticals’ fair value before making investment choices.
  • CFOs: Utilize a professional-grade DCF model for financial reporting and strategic analysis.
  • Consultants: Quickly customize the template for valuation reports tailored to clients.
  • Entrepreneurs: Acquire insights into financial modeling practices employed by leading biotech firms.
  • Educators: Implement it as a teaching resource to illustrate valuation techniques.

What the Template Contains

  • Historical Data: Includes Arrowhead Pharmaceuticals’ past financials and baseline forecasts.
  • DCF and Levered DCF Models: Detailed templates to calculate Arrowhead Pharmaceuticals’ intrinsic value.
  • WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
  • Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
  • Quarterly and Annual Statements: A complete breakdown of Arrowhead Pharmaceuticals’ financials.
  • Interactive Dashboard: Visualize valuation results and projections dynamically.