Amarin Corporation plc (AMRN) 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
Amarin Corporation plc (AMRN) Bundle
Explore Amarin Corporation plc's (AMRN) financial outlook with our user-friendly DCF Calculator! Simply enter your projections for growth, margins, and expenses to calculate Amarin's (AMRN) intrinsic value and enhance your investment approach.
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 | 429.8 | 614.1 | 583.2 | 369.2 | 306.9 | 294.9 | 283.3 | 272.2 | 261.5 | 251.2 |
| Revenue Growth, % | 0 | 42.89 | -5.03 | -36.69 | -16.87 | -3.93 | -3.93 | -3.93 | -3.93 | -3.93 |
| EBITDA | -15.1 | -12.7 | 14.3 | -100.6 | -50.9 | -27.7 | -26.6 | -25.6 | -24.6 | -23.6 |
| EBITDA, % | -3.5 | -2.07 | 2.45 | -27.26 | -16.59 | -9.39 | -9.39 | -9.39 | -9.39 | -9.39 |
| Depreciation | .9 | 2.1 | 2.9 | 3.1 | 3.0 | 1.7 | 1.6 | 1.5 | 1.5 | 1.4 |
| Depreciation, % | 0.20071 | 0.33447 | 0.48984 | 0.83807 | 0.96608 | 0.56583 | 0.56583 | 0.56583 | 0.56583 | 0.56583 |
| EBIT | -15.9 | -14.8 | 11.4 | -103.7 | -53.9 | -29.4 | -28.2 | -27.1 | -26.0 | -25.0 |
| EBIT, % | -3.7 | -2.4 | 1.96 | -28.1 | -17.55 | -9.96 | -9.96 | -9.96 | -9.96 | -9.96 |
| Total Cash | 644.6 | 500.9 | 454.1 | 309.4 | 320.7 | 261.4 | 251.1 | 241.3 | 231.8 | 222.7 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 116.4 | 154.6 | 163.7 | 131.0 | 133.6 | 94.0 | 90.3 | 86.7 | 83.3 | 80.0 |
| Account Receivables, % | 27.09 | 25.17 | 28.06 | 35.48 | 43.52 | 31.87 | 31.87 | 31.87 | 31.87 | 31.87 |
| Inventories | 76.8 | 188.9 | 234.7 | 228.7 | 258.6 | 138.6 | 133.2 | 128.0 | 122.9 | 118.1 |
| Inventories, % | 17.86 | 30.76 | 40.24 | 61.95 | 84.26 | 47.02 | 47.02 | 47.02 | 47.02 | 47.02 |
| Accounts Payable | 50.0 | 105.9 | 114.9 | 64.6 | 52.8 | 49.1 | 47.2 | 45.3 | 43.5 | 41.8 |
| Accounts Payable, % | 11.62 | 17.24 | 19.71 | 17.5 | 17.19 | 16.65 | 16.65 | 16.65 | 16.65 | 16.65 |
| Capital Expenditure | -2.5 | -.3 | .0 | -.6 | -.5 | -.6 | -.5 | -.5 | -.5 | -.5 |
| Capital Expenditure, % | -0.57661 | -0.04103834 | -0.000685804625 | -0.16225 | -0.17367 | -0.19085 | -0.19085 | -0.19085 | -0.19085 | -0.19085 |
| Tax Rate, % | -10.14 | -10.14 | -10.14 | -10.14 | -10.14 | -10.14 | -10.14 | -10.14 | -10.14 | -10.14 |
| EBITAT | -16.0 | -15.4 | 7.8 | -105.7 | -59.3 | -27.5 | -26.4 | -25.4 | -24.4 | -23.4 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -160.9 | -107.9 | -35.2 | -115.0 | -101.2 | 129.5 | -18.2 | -17.5 | -16.8 | -16.1 |
| WACC, % | 13.14 | 13.14 | 13.08 | 13.14 | 13.14 | 13.13 | 13.13 | 13.13 | 13.13 | 13.13 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 69.3 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -16 | |||||||||
| Terminal Value | -148 | |||||||||
| Present Terminal Value | -80 | |||||||||
| Enterprise Value | -10 | |||||||||
| Net Debt | -191 | |||||||||
| Equity Value | 180 | |||||||||
| Diluted Shares Outstanding, MM | 408 | |||||||||
| Equity Value Per Share | 0.44 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real AMRN financials.
- Real-World Data: Historical data and forward-looking estimates (highlighted in the yellow cells).
- Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Instantly observe how your inputs affect Amarin’s valuation.
- Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Design: Organized for clarity and ease of use, complete with step-by-step instructions.
Key Features
- Accurate Financial Data: Gain access to reliable pre-loaded historical data and future forecasts for Amarin Corporation plc (AMRN).
- Adjustable Forecast Parameters: Modify highlighted cells such as WACC, growth rates, and profit margins to suit your analysis.
- Real-Time Calculations: Enjoy automatic updates for DCF, Net Present Value (NPV), and cash flow assessments.
- Interactive Dashboard: Utilize user-friendly charts and summaries to clearly present your valuation findings.
- Designed for All Skill Levels: A straightforward, intuitive layout tailored for investors, CFOs, and consultants alike.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Amarin Corporation data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Amarin Corporation’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for Amarin Corporation plc (AMRN)?
- Designed for Experts: A sophisticated tool utilized by financial analysts, investment managers, and industry consultants.
- Comprehensive Data: Amarin’s historical and projected financials are preloaded for precision.
- Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
- Transparent Outputs: Instantly calculates intrinsic value, NPV, and essential financial metrics.
- User-Friendly: Step-by-step guidance ensures a smooth experience throughout.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and accurate valuation models for assessing Amarin Corporation plc (AMRN) investments.
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the organization.
- Consultants and Advisors: Deliver precise valuation insights to clients interested in Amarin Corporation plc (AMRN) stock.
- Students and Educators: Leverage real-world data to enhance learning and practice in financial modeling.
- Biotech Enthusiasts: Gain insights into how biotech firms like Amarin Corporation plc (AMRN) are valued in the healthcare market.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Amarin Corporation 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 Amarin Corporation.
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.