Galapagos NV (GLPG) DCF Valuation

Galapagos NV (GLPG) 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

Galapagos NV (GLPG) 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 the financial prospects of Galapagos NV like an expert! This (GLPG) DCF Calculator comes with pre-filled financial data and offers you the flexibility to modify revenue growth, WACC, margins, and other crucial assumptions to align with your predictions.


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 880.8 498.3 505.4 526.7 249.9 193.5 149.8 115.9 89.7 69.5
Revenue Growth, % 0 -43.42 1.42 4.21 -52.56 -22.59 -22.59 -22.59 -22.59 -22.59
EBITDA 390.1 -307.0 -105.2 -34.8 53.2 -9.1 -7.0 -5.4 -4.2 -3.3
EBITDA, % 44.29 -61.61 -20.82 -6.6 21.29 -4.69 -4.69 -4.69 -4.69 -4.69
Depreciation 11.3 17.7 22.2 31.2 45.5 12.9 10.0 7.7 6.0 4.6
Depreciation, % 1.28 3.55 4.39 5.92 18.21 6.67 6.67 6.67 6.67 6.67
EBIT 378.9 -324.7 -127.4 -66.0 7.7 -22.0 -17.0 -13.2 -10.2 -7.9
EBIT, % 43.01 -65.16 -25.21 -12.52 3.08 -11.36 -11.36 -11.36 -11.36 -11.36
Total Cash 6,026.1 5,380.4 4,902.7 4,267.8 3,840.8 193.5 149.8 115.9 89.7 69.5
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 83.5 180.8 134.1 80.6 68.4
Account Receivables, % 9.48 36.27 26.52 15.31 27.39
Inventories .3 .4 21.4 55.2 77.1 17.7 13.7 10.6 8.2 6.3
Inventories, % 0.03017801 0.07425955 4.24 10.47 30.86 9.14 9.14 9.14 9.14 9.14
Accounts Payable 148.6 178.6 140.0 139.0 140.4 63.0 48.8 37.8 29.2 22.6
Accounts Payable, % 16.87 35.84 27.7 26.38 56.17 32.59 32.59 32.59 32.59 32.59
Capital Expenditure -47.6 -95.2 -60.3 -38.5 -20.1 -20.0 -15.5 -12.0 -9.3 -7.2
Capital Expenditure, % -5.41 -19.1 -11.94 -7.31 -8.04 -10.36 -10.36 -10.36 -10.36 -10.36
Tax Rate, % -3663.5 -3663.5 -3663.5 -3663.5 -3663.5 -3663.5 -3663.5 -3663.5 -3663.5 -3663.5
EBITAT 378.3 -326.0 -129.9 -66.8 290.1 -22.0 -17.0 -13.2 -10.2 -7.9
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 406.7 -470.8 -181.0 -55.5 307.2 -23.0 -22.7 -17.6 -13.6 -10.5
WACC, % 5.46 5.46 5.46 5.46 5.46 5.46 5.46 5.46 5.46 5.46
PV UFCF
SUM PV UFCF -76.4
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) -11
Terminal Value -311
Present Terminal Value -238
Enterprise Value -315
Net Debt -164
Equity Value -151
Diluted Shares Outstanding, MM 66
Equity Value Per Share -2.29

What You Will Get

  • Real GLPG Financial Data: Pre-filled with Galapagos NV’s historical and projected data for precise analysis.
  • Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
  • Automatic Calculations: See Galapagos NV’s intrinsic value update instantly based on your changes.
  • Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
  • User-Friendly Design: Simple structure and clear instructions for all experience levels.

Key Features

  • 🔍 Real-Life GLPG Financials: Pre-filled historical and projected data for Galapagos NV.
  • ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
  • 📊 Professional DCF Valuation: Built-in formulas calculate Galapagos’ intrinsic value using the Discounted Cash Flow method.
  • ⚡ Instant Results: Visualize Galapagos’ valuation instantly after making changes.
  • Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.

How It Works

  • Download: Obtain the ready-to-use Excel file containing Galapagos NV’s (GLPG) 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 multiple projections and compare results instantly.
  • Make Decisions: Utilize the valuation outcomes to inform your investment strategy.

Why Choose This Calculator for Galapagos NV (GLPG)?

  • User-Friendly Interface: Tailored for both novices and seasoned professionals.
  • Customizable Parameters: Adjust inputs effortlessly to suit your financial analysis.
  • Real-Time Feedback: Observe immediate updates to Galapagos NV’s valuation as you tweak inputs.
  • Pre-Configured: Comes with Galapagos NV’s actual financial metrics for swift evaluation.
  • Relied Upon by Experts: Favored by investors and analysts for making well-informed choices.

Who Should Use Galapagos NV (GLPG)?

  • Investors: Make informed decisions with a robust analysis of Galapagos NV's market potential.
  • Financial Analysts: Streamline your research with comprehensive data on Galapagos NV's financial performance.
  • Pharmaceutical Consultants: Tailor the insights for client presentations or strategic reports focused on biotech.
  • Biotech Enthusiasts: Enhance your knowledge of drug development and market dynamics using Galapagos NV as a case study.
  • Researchers and Students: Utilize it as a resource for in-depth studies in biotechnology and finance-related disciplines.

What the Template Contains

  • Pre-Filled Data: Contains Galapagos NV's historical financials and projections.
  • Discounted Cash Flow Model: Editable DCF valuation model featuring automatic calculations.
  • Weighted Average Cost of Capital (WACC): A dedicated sheet for WACC calculations based on user-defined inputs.
  • Key Financial Ratios: Assess Galapagos NV's profitability, efficiency, and leverage metrics.
  • Customizable Inputs: Easily modify revenue growth, margins, and tax rates.
  • Clear Dashboard: Visual representations and tables summarizing essential valuation outcomes.

No products were found matching.