Ionis Pharmaceuticals, Inc. (IONS) 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
Ionis Pharmaceuticals, Inc. (IONS) Bundle
Whether you’re an investor or an analyst, this [IONS] DCF Calculator is your go-to resource for accurate valuation. Equipped with Ionis Pharmaceuticals, Inc. real data, you can adjust forecasts and observe the effects in real-time.
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,123.0 | 729.0 | 810.0 | 587.0 | 787.6 | 753.5 | 720.9 | 689.7 | 659.8 | 631.2 |
Revenue Growth, % | 0 | -35.08 | 11.11 | -27.53 | 34.18 | -4.33 | -4.33 | -4.33 | -4.33 | -4.33 |
EBITDA | 411.5 | -107.9 | -.2 | -227.8 | -230.0 | -69.6 | -66.6 | -63.7 | -60.9 | -58.3 |
EBITDA, % | 36.65 | -14.8 | -0.02950617 | -38.8 | -29.2 | -9.24 | -9.24 | -9.24 | -9.24 | -9.24 |
Depreciation | 16.0 | 17.2 | 19.6 | 22.1 | 22.5 | 19.3 | 18.5 | 17.7 | 16.9 | 16.2 |
Depreciation, % | 1.42 | 2.35 | 2.41 | 3.77 | 2.86 | 2.56 | 2.56 | 2.56 | 2.56 | 2.56 |
EBIT | 395.5 | -125.0 | -19.8 | -249.9 | -252.5 | -88.9 | -85.1 | -81.4 | -77.9 | -74.5 |
EBIT, % | 35.22 | -17.15 | -2.44 | -42.57 | -32.06 | -11.8 | -11.8 | -11.8 | -11.8 | -11.8 |
Total Cash | 2,500.0 | 1,892.0 | 2,115.0 | 1,987.0 | 2,331.2 | 753.5 | 720.9 | 689.7 | 659.8 | 631.2 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 63.0 | 76.2 | 61.9 | 25.5 | 97.8 | 61.0 | 58.4 | 55.8 | 53.4 | 51.1 |
Account Receivables, % | 5.61 | 10.45 | 7.64 | 4.35 | 12.41 | 8.09 | 8.09 | 8.09 | 8.09 | 8.09 |
Inventories | 18.2 | 22.0 | 24.8 | 22.0 | 28.4 | 22.7 | 21.7 | 20.8 | 19.9 | 19.0 |
Inventories, % | 1.62 | 3.01 | 3.06 | 3.75 | 3.61 | 3.01 | 3.01 | 3.01 | 3.01 | 3.01 |
Accounts Payable | 16.1 | 17.2 | 11.9 | 17.9 | 26.0 | 17.5 | 16.7 | 16.0 | 15.3 | 14.7 |
Accounts Payable, % | 1.43 | 2.36 | 1.47 | 3.05 | 3.3 | 2.32 | 2.32 | 2.32 | 2.32 | 2.32 |
Capital Expenditure | -36.3 | -41.0 | -17.9 | -20.1 | -28.0 | -27.2 | -26.0 | -24.9 | -23.8 | -22.8 |
Capital Expenditure, % | -3.23 | -5.63 | -2.21 | -3.42 | -3.56 | -3.61 | -3.61 | -3.61 | -3.61 | -3.61 |
Tax Rate, % | -9.68 | -9.68 | -9.68 | -9.68 | -9.68 | -9.68 | -9.68 | -9.68 | -9.68 | -9.68 |
EBITAT | 335.1 | -358.2 | -19.1 | -261.5 | -276.9 | -85.6 | -81.9 | -78.4 | -75.0 | -71.7 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 249.7 | -397.9 | -11.3 | -214.3 | -353.0 | -59.5 | -86.6 | -82.8 | -79.2 | -75.8 |
WACC, % | 5.74 | 5.89 | 5.86 | 5.89 | 5.89 | 5.86 | 5.86 | 5.86 | 5.86 | 5.86 |
PV UFCF | ||||||||||
SUM PV UFCF | -323.5 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -77 | |||||||||
Terminal Value | -2,006 | |||||||||
Present Terminal Value | -1,509 | |||||||||
Enterprise Value | -1,832 | |||||||||
Net Debt | 1,054 | |||||||||
Equity Value | -2,887 | |||||||||
Diluted Shares Outstanding, MM | 143 | |||||||||
Equity Value Per Share | -20.16 |
What You Will Get
- Real IONS Financial Data: Pre-filled with Ionis Pharmaceuticals’ historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See Ionis Pharmaceuticals’ 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
- Accurate Ionis Financials: Gain access to reliable pre-loaded historical data and future projections for Ionis Pharmaceuticals, Inc. (IONS).
- Customizable Forecast Assumptions: Modify highlighted cells such as WACC, growth rates, and profit margins to tailor your analysis.
- Dynamic Calculations: Enjoy automatic updates to DCF, Net Present Value (NPV), and cash flow assessments.
- Visual Dashboard: Utilize clear charts and summaries to effectively visualize your valuation outcomes.
- For Professionals and Beginners: Designed with a user-friendly structure suitable for investors, CFOs, and consultants alike.
How It Works
- Download: Obtain the pre-built Excel file featuring Ionis Pharmaceuticals' financial data.
- Customize: Modify projections, including revenue growth, EBITDA %, and WACC.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Generate various forecasts and analyze results immediately.
- Make Decisions: Leverage the valuation insights to inform your investment approach.
Why Choose This Calculator?
- Designed for Experts: A sophisticated tool utilized by analysts, CFOs, and industry consultants.
- Accurate Data: Ionis Pharmaceuticals' historical and projected financials preloaded for precision.
- Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
- Comprehensive Outputs: Automatically calculates intrinsic value, NPV, and essential metrics.
- User-Friendly: Step-by-step guidance to navigate through the calculations.
Who Should Use This Product?
- Individual Investors: Gain insights to make informed decisions about trading Ionis Pharmaceuticals stock (IONS).
- Financial Analysts: Enhance valuation accuracy with comprehensive financial models tailored for Ionis Pharmaceuticals.
- Consultants: Provide clients with expert valuation analysis and insights on Ionis Pharmaceuticals efficiently.
- Business Owners: Learn how biotech companies like Ionis Pharmaceuticals are valued to inform your own business strategies.
- Finance Students: Acquire practical valuation skills using real-world data from Ionis Pharmaceuticals.
What the Template Contains
- Pre-Filled Data: Contains Ionis Pharmaceuticals' historical financials and projections.
- Discounted Cash Flow Model: Editable DCF valuation model featuring automatic calculations.
- Weighted Average Cost of Capital (WACC): A specialized sheet for calculating WACC based on user-defined inputs.
- Key Financial Ratios: Evaluate Ionis Pharmaceuticals' profitability, efficiency, and leverage metrics.
- Customizable Inputs: Easily modify revenue growth rates, profit margins, and tax assumptions.
- Clear Dashboard: Visual representations and tables summarizing essential valuation outcomes.