Alkermes plc (ALKS) 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
Alkermes plc (ALKS) Bundle
Evaluate Alkermes plc's financial outlook like an expert! This (ALKS) DCF Calculator provides you with pre-filled financial data and the complete flexibility to modify revenue growth, WACC, margins, and other essential assumptions to align with your projections.
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 | 1,170.9 | 1,038.8 | 1,173.8 | 1,111.8 | 1,663.4 | 1,854.9 | 2,068.4 | 2,306.5 | 2,572.0 | 2,868.0 |
| Revenue Growth, % | 0 | -11.29 | 13 | -5.28 | 49.61 | 11.51 | 11.51 | 11.51 | 11.51 | 11.51 |
| EBITDA | -103.0 | -6.0 | 176.4 | 59.8 | 519.5 | 156.8 | 174.8 | 194.9 | 217.4 | 242.4 |
| EBITDA, % | -8.8 | -0.57992 | 15.03 | 5.38 | 31.23 | 8.45 | 8.45 | 8.45 | 8.45 | 8.45 |
| Depreciation | 80.4 | 81.9 | 78.7 | 77.9 | 74.9 | 122.3 | 136.3 | 152.0 | 169.5 | 189.0 |
| Depreciation, % | 6.87 | 7.88 | 6.7 | 7 | 4.5 | 6.59 | 6.59 | 6.59 | 6.59 | 6.59 |
| EBIT | -183.5 | -87.9 | 97.7 | -18.1 | 444.6 | 34.5 | 38.5 | 42.9 | 47.8 | 53.3 |
| EBIT, % | -15.67 | -8.46 | 8.33 | -1.63 | 26.73 | 1.86 | 1.86 | 1.86 | 1.86 | 1.86 |
| Total Cash | 614.4 | 659.8 | 765.7 | 740.1 | 773.5 | 1,091.7 | 1,217.4 | 1,357.5 | 1,513.8 | 1,688.1 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 265.5 | 289.5 | 326.6 | 296.9 | 333.2 | 464.1 | 517.5 | 577.1 | 643.5 | 717.6 |
| Account Receivables, % | 22.67 | 27.87 | 27.82 | 26.7 | 20.03 | 25.02 | 25.02 | 25.02 | 25.02 | 25.02 |
| Inventories | 101.8 | 125.7 | 150.3 | 181.4 | 186.4 | 226.8 | 252.9 | 282.0 | 314.5 | 350.6 |
| Inventories, % | 8.69 | 12.1 | 12.81 | 16.32 | 11.21 | 12.23 | 12.23 | 12.23 | 12.23 | 12.23 |
| Accounts Payable | 54.3 | 46.0 | 55.7 | 32.8 | 65.6 | 76.8 | 85.7 | 95.6 | 106.5 | 118.8 |
| Accounts Payable, % | 4.63 | 4.43 | 4.75 | 2.95 | 3.95 | 4.14 | 4.14 | 4.14 | 4.14 | 4.14 |
| Capital Expenditure | -90.9 | -42.2 | -29.0 | -38.3 | -48.0 | -76.5 | -85.4 | -95.2 | -106.1 | -118.3 |
| Capital Expenditure, % | -7.77 | -4.06 | -2.47 | -3.44 | -2.89 | -4.13 | -4.13 | -4.13 | -4.13 | -4.13 |
| Tax Rate, % | 15.6 | 15.6 | 15.6 | 15.6 | 15.6 | 15.6 | 15.6 | 15.6 | 15.6 | 15.6 |
| EBITAT | -183.0 | -100.9 | 119.8 | -17.1 | 375.2 | 33.0 | 36.8 | 41.1 | 45.8 | 51.1 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -506.6 | -117.5 | 117.5 | -1.8 | 393.6 | -81.3 | 17.1 | 19.1 | 21.3 | 23.8 |
| WACC, % | 6.48 | 6.48 | 6.48 | 6.46 | 6.41 | 6.46 | 6.46 | 6.46 | 6.46 | 6.46 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -11.5 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 24 | |||||||||
| Terminal Value | 543 | |||||||||
| Present Terminal Value | 397 | |||||||||
| Enterprise Value | 385 | |||||||||
| Net Debt | -85 | |||||||||
| Equity Value | 471 | |||||||||
| Diluted Shares Outstanding, MM | 170 | |||||||||
| Equity Value Per Share | 2.77 |
What You Will Gain
- Authentic Alkermes Data: Preloaded financials – including revenue and EBIT – derived from actual and projected figures.
- Comprehensive Customization: Modify all essential parameters (yellow cells) such as WACC, growth %, and tax rates.
- Immediate Valuation Adjustments: Automatic recalculations to assess the impact of changes on Alkermes' fair value.
- Flexible Excel Template: Designed for quick modifications, scenario analysis, and detailed forecasts.
- Efficient and Precise: Bypass the hassle of building models from the ground up while ensuring accuracy and adaptability.
Key Features
- Accurate Alkermes Financial Data: Gain access to reliable historical data and future estimates tailored for Alkermes plc (ALKS).
- Flexible Forecast Inputs: Modify highlighted fields such as WACC, growth rates, and profit margins to suit your analysis.
- Real-Time Calculations: Enjoy automatic recalculations of DCF, Net Present Value (NPV), and cash flow metrics.
- User-Friendly Dashboard: Intuitive charts and summaries to help you easily interpret your valuation findings.
- Designed for All Skill Levels: A straightforward and accessible layout ideal for investors, CFOs, and consultants alike.
How It Works
- Step 1: Download the prebuilt Excel template featuring Alkermes plc's (ALKS) data.
- Step 2: Navigate through the pre-filled sheets to familiarize yourself with the essential metrics.
- Step 3: Modify forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly view the recalculated results, including Alkermes plc's (ALKS) intrinsic value.
- Step 5: Utilize the outputs to make informed investment decisions or generate comprehensive reports.
Why Choose This Calculator?
- Accurate Data: Real Alkermes plc (ALKS) financials provide dependable valuation outcomes.
- Customizable: Tailor essential parameters such as growth rates, WACC, and tax rates to fit your forecasts.
- Time-Saving: Ready-made calculations save you the hassle of starting from the ground up.
- Professional-Grade Tool: Crafted for investors, analysts, and consultants in the pharmaceutical sector.
- User-Friendly: An intuitive design and clear, step-by-step guidance make it accessible for all users.
Who Should Use Alkermes plc (ALKS)?
- Investors: Gain insights and make informed decisions with a comprehensive analysis of Alkermes plc (ALKS).
- Financial Analysts: Utilize detailed reports and data to streamline your financial assessments of Alkermes plc (ALKS).
- Consultants: Tailor your presentations or recommendations with up-to-date information on Alkermes plc (ALKS).
- Healthcare Enthusiasts: Explore the pharmaceutical landscape and enhance your knowledge of Alkermes plc (ALKS) and its products.
- Educators and Students: Incorporate real-world case studies of Alkermes plc (ALKS) into your finance and healthcare curriculum.
What the Template Contains
- Historical Data: Includes Alkermes plc’s (ALKS) past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Alkermes plc’s (ALKS) intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital specific to Alkermes plc (ALKS).
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions for Alkermes plc (ALKS).
- Quarterly and Annual Statements: A complete breakdown of Alkermes plc’s (ALKS) financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically for Alkermes plc (ALKS).