Vanda Pharmaceuticals Inc. (VNDA) DCF Valuation

Vanda Pharmaceuticals Inc. (VNDA) 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

Vanda Pharmaceuticals Inc. (VNDA) 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:

Gain mastery over your Vanda Pharmaceuticals Inc. (VNDA) valuation analysis with our state-of-the-art DCF Calculator! Equipped with actual VNDA data, this Excel template enables you to adjust forecasts and assumptions to accurately determine the intrinsic value of Vanda Pharmaceuticals Inc.


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 227.2 248.2 268.7 254.4 192.6 186.8 181.2 175.7 170.4 165.2
Revenue Growth, % 0 9.23 8.27 -5.32 -24.27 -3.02 -3.02 -3.02 -3.02 -3.02
EBITDA 25.7 30.1 45.0 9.1 -10.9 14.2 13.8 13.4 13.0 12.6
EBITDA, % 11.31 12.13 16.75 3.56 -5.68 7.62 7.62 7.62 7.62 7.62
Depreciation 2.9 2.9 2.8 2.7 3.0 2.3 2.2 2.2 2.1 2.0
Depreciation, % 1.27 1.15 1.06 1.07 1.56 1.22 1.22 1.22 1.22 1.22
EBIT 22.8 27.2 42.2 6.3 -14.0 11.9 11.6 11.2 10.9 10.6
EBIT, % 10.04 10.98 15.69 2.49 -7.24 6.39 6.39 6.39 6.39 6.39
Total Cash 312.1 367.7 432.8 466.9 388.3 186.8 181.2 175.7 170.4 165.2
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 26.4 30.0 32.5 33.5 34.2
Account Receivables, % 11.61 12.1 12.08 13.17 17.73
Inventories 1.1 1.3 1.0 1.2 1.4 1.0 .9 .9 .9 .9
Inventories, % 0.50179 0.51578 0.38149 0.46937 0.70442 0.51457 0.51457 0.51457 0.51457 0.51457
Accounts Payable 1.7 1.0 .9 12.7 7.1 3.8 3.7 3.6 3.5 3.4
Accounts Payable, % 0.73639 0.4227 0.34427 4.99 3.71 2.04 2.04 2.04 2.04 2.04
Capital Expenditure -1.0 -1.8 -.6 -.7 -.4 -.7 -.7 -.6 -.6 -.6
Capital Expenditure, % -0.44853 -0.7233 -0.20545 -0.26692 -0.19882 -0.3686 -0.3686 -0.3686 -0.3686 -0.3686
Tax Rate, % 60.42 60.42 60.42 60.42 60.42 60.42 60.42 60.42 60.42 60.42
EBITAT 90.8 20.1 33.0 3.5 -5.5 8.3 8.0 7.8 7.6 7.3
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 66.8 16.7 33.0 16.1 -9.2 16.2 10.3 9.9 9.6 9.4
WACC, % 7.95 7.91 7.92 7.89 7.86 7.91 7.91 7.91 7.91 7.91
PV UFCF
SUM PV UFCF 45.2
Long Term Growth Rate, % 4.00
Free cash flow (T + 1) 10
Terminal Value 249
Present Terminal Value 170
Enterprise Value 215
Net Debt -126
Equity Value 342
Diluted Shares Outstanding, MM 58
Equity Value Per Share 5.94

What You Will Get

  • Real VNDA Financial Data: Pre-filled with Vanda Pharmaceuticals’ historical and projected data for precise analysis.
  • Fully Editable Template: Easily modify key inputs such as revenue growth, WACC, and EBITDA %.
  • Automatic Calculations: Instantly see Vanda Pharmaceuticals’ intrinsic value update based on your adjustments.
  • Professional Valuation Tool: Tailored for investors, analysts, and consultants looking for accurate DCF results.
  • User-Friendly Design: A straightforward structure and clear instructions suitable for all experience levels.

Key Features

  • Comprehensive Data: Vanda Pharmaceuticals Inc.'s historical financial statements and pre-filled projections.
  • Customizable Inputs: Modify WACC, tax rates, revenue growth, and EBITDA margins as needed.
  • Real-Time Updates: View Vanda Pharmaceuticals Inc.'s intrinsic value recalculating instantly.
  • Intuitive Visual Outputs: Dashboard charts showcase valuation results and essential metrics.
  • Designed for Precision: A reliable tool tailored for analysts, investors, and finance professionals.

How It Works

  1. Step 1: Download the Excel file.
  2. Step 2: Review pre-entered Vanda Pharmaceuticals Inc. (VNDA) data (historical and projected).
  3. Step 3: Adjust key assumptions (yellow cells) based on your analysis.
  4. Step 4: View automatic recalculations for Vanda Pharmaceuticals Inc. (VNDA)’s intrinsic value.
  5. Step 5: Use the outputs for investment decisions or reporting.

Why Choose Vanda Pharmaceuticals Inc. (VNDA)?

  • Innovative Solutions: Pioneering treatments that address unmet medical needs.
  • Proven Track Record: A history of successful product development and market introduction.
  • Patient-Centric Approach: Focused on improving the quality of life for patients.
  • Strong Research Pipeline: Committed to advancing science through ongoing research and development.
  • Expert Team: Led by experienced professionals dedicated to pharmaceutical excellence.

Who Should Use This Product?

  • Professional Investors: Develop comprehensive and accurate valuation models for assessing Vanda Pharmaceuticals Inc. (VNDA).
  • Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the organization.
  • Consultants and Advisors: Deliver precise valuation insights to clients regarding Vanda Pharmaceuticals Inc. (VNDA).
  • Students and Educators: Utilize real-time data to enhance learning and practice in financial modeling.
  • Healthcare Sector Enthusiasts: Gain insights into how pharmaceutical companies like Vanda Pharmaceuticals Inc. (VNDA) are valued in the market.

What the Template Contains

  • Pre-Filled DCF Model: Vanda Pharmaceuticals’ financial data preloaded for immediate use.
  • WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
  • Financial Ratios: Evaluate Vanda Pharmaceuticals’ profitability, leverage, and efficiency.
  • Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
  • Financial Statements: Annual and quarterly reports to support detailed analysis.
  • Interactive Dashboard: Easily visualize key valuation metrics and results.

No products were found matching.