ICON Public Limited Company (ICLR) DCF Valuation

ICON Public Limited Company (ICLR) DCF Valuation

IE | Healthcare | Medical - Diagnostics & Research | NASDAQ
ICON Public Limited Company (ICLR) DCF Valuation
  • ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
  • ✓ Professional Design: Trusted, Industry-Standard Templates
  • ✓ Pre-Built For Quick And Efficient Use
  • ✓ No Expertise Is Needed; Easy To Follow

ICON Public Limited Company (ICLR) Bundle

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 ICON Public Limited Company (ICLR) valuation analysis using our sophisticated DCF Calculator! This Excel template comes preloaded with actual ICLR data, enabling you to adjust forecasts and assumptions for accurately calculating the intrinsic value of ICON Public Limited Company.


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 2,805.8 2,797.3 5,480.8 7,741.4 8,120.2 10,998.1 14,896.0 20,175.4 27,325.9 37,010.7
Revenue Growth, % 0 -0.30476 95.93 41.24 4.89 35.44 35.44 35.44 35.44 35.44
EBITDA 532.2 488.8 739.4 1,412.3 1,521.4 1,911.8 2,589.3 3,507.0 4,750.0 6,433.5
EBITDA, % 18.97 17.48 13.49 18.24 18.74 17.38 17.38 17.38 17.38 17.38
Depreciation 91.9 94.6 360.3 614.7 586.0 624.5 845.8 1,145.5 1,551.5 2,101.4
Depreciation, % 3.28 3.38 6.57 7.94 7.22 5.68 5.68 5.68 5.68 5.68
EBIT 440.3 394.2 379.1 797.6 935.5 1,287.3 1,743.6 2,361.5 3,198.5 4,332.1
EBIT, % 15.69 14.09 6.92 10.3 11.52 11.7 11.7 11.7 11.7 11.7
Total Cash 569.9 842.0 753.9 290.5 380.1 1,597.0 2,163.0 2,929.6 3,967.9 5,374.2
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 1,013.5 1,144.0 2,073.0 2,801.5 2,899.3
Account Receivables, % 36.12 40.9 37.82 36.19 35.71
Inventories 3.2 4.8 .0 7.1 .0 8.3 11.2 15.2 20.6 27.9
Inventories, % 0.11405 0.17181 0.0000000182 0.09123689 0 0.07541881 0.07541881 0.07541881 0.07541881 0.07541881
Accounts Payable 24.1 51.1 90.8 81.2 131.6 154.2 208.8 282.8 383.1 518.9
Accounts Payable, % 0.85714 1.83 1.66 1.05 1.62 1.4 1.4 1.4 1.4 1.4
Capital Expenditure -50.6 -51.1 -93.8 -142.2 -140.7 -196.0 -265.4 -359.5 -486.9 -659.5
Capital Expenditure, % -1.8 -1.83 -1.71 -1.84 -1.73 -1.78 -1.78 -1.78 -1.78 -1.78
Tax Rate, % 1.94 1.94 1.94 1.94 1.94 1.94 1.94 1.94 1.94 1.94
EBITAT 385.6 338.1 295.3 709.7 917.3 1,128.4 1,528.4 2,070.0 2,803.7 3,797.4
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF -565.8 276.7 -322.7 437.1 1,322.2 363.1 704.7 954.4 1,292.7 1,750.8
WACC, % 9.83 9.8 9.68 9.85 9.99 9.83 9.83 9.83 9.83 9.83
PV UFCF
SUM PV UFCF 3,619.1
Long Term Growth Rate, % 3.50
Free cash flow (T + 1) 1,812
Terminal Value 28,624
Present Terminal Value 17,911
Enterprise Value 21,530
Net Debt 3,560
Equity Value 17,970
Diluted Shares Outstanding, MM 83
Equity Value Per Share 217.24

What You Will Get

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

Key Features

  • Comprehensive DCF Calculator: Features both unlevered and levered DCF valuation models tailored for ICON Public Limited Company (ICLR).
  • WACC Calculator: Pre-configured Weighted Average Cost of Capital sheet with adjustable inputs for personalized analysis.
  • Customizable Forecast Assumptions: Easily adjust growth rates, capital expenditures, and discount rates to fit your analysis.
  • Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specifically for ICON Public Limited Company (ICLR).
  • Interactive Dashboard and Charts: Visual representations that summarize essential valuation metrics for straightforward interpretation.

How It Works

  • Download: Obtain the pre-configured Excel file containing ICON Public Limited Company's (ICLR) financial data.
  • Customize: Modify projections such as revenue growth, EBITDA %, and WACC to fit your analysis.
  • Update Automatically: Enjoy real-time updates on intrinsic value and NPV calculations.
  • Test Scenarios: Generate various projections and instantly compare potential outcomes.
  • Make Decisions: Leverage the valuation insights to inform your investment choices.

Why Choose ICON Public Limited Company (ICLR)?

  • Time-Efficient: Access comprehensive financial tools without the hassle of starting from scratch.
  • Enhanced Precision: Utilize accurate financial data and methodologies to minimize valuation discrepancies.
  • Completely Customizable: Adjust the model to align with your specific assumptions and forecasts.
  • User-Friendly: Intuitive charts and outputs facilitate straightforward analysis of results.
  • Endorsed by Professionals: Crafted for experts who prioritize accuracy and ease of use.

Who Should Use This Product?

  • Professional Investors: Develop comprehensive and trustworthy valuation models for analyzing ICLR portfolios.
  • Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the organization.
  • Consultants and Advisors: Deliver precise valuation insights for clients interested in ICON Public Limited Company (ICLR).
  • Students and Educators: Utilize real-world data to enhance learning and practice in financial modeling.
  • Healthcare Sector Enthusiasts: Gain insights into how companies like ICON Public Limited Company (ICLR) are valued in the biotechnology market.

What the Template Contains

  • Operating and Balance Sheet Data: Pre-filled ICON Public Limited Company (ICLR) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
  • WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
  • DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
  • Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
  • Key Ratios: Includes profitability, leverage, and efficiency ratios for ICON Public Limited Company (ICLR).
  • Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.

Es wurden keine passenden Produkte gefunden.