Biogen Inc. (BIIB) DCF Valuation

Biogen Inc. (BIIB) 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

Biogen Inc. (BIIB) 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:

As an investor or analyst, this [Symbol] DCF Calculator serves as your go-to resource for accurate valuation. Loaded with real data from Biogen Inc., you can easily adjust forecasts and instantly observe the effects.


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 14,377.9 13,444.6 10,981.7 10,173.4 9,835.6 8,962.9 8,167.7 7,443.0 6,782.6 6,180.8
Revenue Growth, % 0 -6.49 -18.32 -7.36 -3.32 -8.87 -8.87 -8.87 -8.87 -8.87
EBITDA 7,777.9 5,730.3 2,486.1 4,357.1 2,377.0 3,340.5 3,044.1 2,774.0 2,527.9 2,303.6
EBITDA, % 54.1 42.62 22.64 42.83 24.17 37.27 37.27 37.27 37.27 37.27
Depreciation 464.6 457.0 487.3 518.7 494.8 380.0 346.3 315.5 287.5 262.0
Depreciation, % 3.23 3.4 4.44 5.1 5.03 4.24 4.24 4.24 4.24 4.24
EBIT 7,313.3 5,273.3 1,998.8 3,838.4 1,882.2 2,960.5 2,697.9 2,458.5 2,240.3 2,041.6
EBIT, % 50.86 39.22 18.2 37.73 19.14 33.03 33.03 33.03 33.03 33.03
Total Cash 4,475.9 2,610.1 3,802.5 4,892.8 1,049.9 2,580.2 2,351.3 2,142.7 1,952.5 1,779.3
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 2,470.7 2,327.3 1,961.7 2,136.4 2,100.0
Account Receivables, % 17.18 17.31 17.86 21 21.35
Inventories 804.2 1,068.6 1,351.5 1,344.4 2,527.4 1,160.9 1,057.9 964.0 878.5 800.5
Inventories, % 5.59 7.95 12.31 13.21 25.7 12.95 12.95 12.95 12.95 12.95
Accounts Payable 459.4 454.9 589.2 491.5 403.3 374.2 341.0 310.8 283.2 258.1
Accounts Payable, % 3.2 3.38 5.37 4.83 4.1 4.18 4.18 4.18 4.18 4.18
Capital Expenditure -669.5 -551.8 -294.9 -243.2 -311.4 -304.8 -277.7 -253.1 -230.6 -210.2
Capital Expenditure, % -4.66 -4.1 -2.69 -2.39 -3.17 -3.4 -3.4 -3.4 -3.4 -3.4
Tax Rate, % 10.46 10.46 10.46 10.46 10.46 10.46 10.46 10.46 10.46 10.46
EBITAT 6,043.4 4,179.6 1,782.2 3,256.1 1,685.2 2,519.0 2,295.5 2,091.8 1,906.2 1,737.1
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 3,023.0 3,959.3 2,191.6 3,266.3 633.8 4,333.9 2,584.4 2,355.1 2,146.1 1,955.7
WACC, % 4.97 4.93 5.04 4.99 5.04 4.99 4.99 4.99 4.99 4.99
PV UFCF
SUM PV UFCF 11,806.2
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 1,995
Terminal Value 66,666
Present Terminal Value 52,254
Enterprise Value 64,060
Net Debt 6,288
Equity Value 57,772
Diluted Shares Outstanding, MM 146
Equity Value Per Share 396.78

What You Will Get

  • Editable Forecast Inputs: Easily modify key assumptions (growth %, margins, WACC) to explore various scenarios.
  • Real-World Data: Biogen Inc.’s (BIIB) financial data pre-loaded to facilitate your analysis.
  • Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically.
  • Customizable and Professional: A refined Excel model that tailors to your valuation requirements.
  • Built for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and enhancing efficiency.

Key Features

  • Comprehensive Biogen Financials: Gain access to precise pre-loaded historical data and future forecasts.
  • Adjustable Forecast Assumptions: Modify yellow-highlighted cells including WACC, growth rates, and profit margins.
  • Real-Time Calculations: Automatic updates for DCF, Net Present Value (NPV), and cash flow assessments.
  • Interactive Dashboard: User-friendly charts and summaries to clearly illustrate your valuation findings.
  • Suitable for All Experience Levels: An intuitive layout designed for investors, CFOs, and consultants alike.

How It Works

  • Download: Obtain the ready-to-use Excel file containing Biogen Inc.'s (BIIB) financial data.
  • Customize: Modify forecasts, such as revenue growth, EBITDA %, and WACC.
  • Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
  • Test Scenarios: Generate various projections and compare results instantly.
  • Make Decisions: Leverage the valuation outcomes to inform your investment strategy.

Why Choose This Calculator for Biogen Inc. (BIIB)?

  • Designed for Experts: A sophisticated tool utilized by researchers, financial analysts, and healthcare consultants.
  • Comprehensive Data: Biogen’s historical and projected financials are preloaded for precise analysis.
  • Flexible Scenario Analysis: Effortlessly model various forecasts and assumptions.
  • Insightful Outputs: Automatically computes intrinsic value, NPV, and essential metrics.
  • User-Friendly: Step-by-step guidance simplifies the calculation process.

Who Should Use This Product?

  • Investors: Accurately assess Biogen Inc.'s (BIIB) fair value prior to making investment choices.
  • CFOs: Utilize a professional-grade DCF model for financial analysis and reporting.
  • Consultants: Efficiently modify the template for client valuation reports.
  • 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

  • Pre-Filled Data: Includes Biogen Inc.’s historical financials and forecasts.
  • Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
  • Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
  • Key Financial Ratios: Analyze Biogen Inc.’s profitability, efficiency, and leverage.
  • Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
  • Clear Dashboard: Charts and tables summarizing key valuation results.

No products were found matching.