|
Valoración de DCF de Ironwood Pharmaceuticals, Inc. (IRWD)
US | Healthcare | Drug Manufacturers - Specialty & Generic | NASDAQ
|
- ✓ 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
Ironwood Pharmaceuticals, Inc. (IRWD) Bundle
¡Descubra el verdadero potencial de Ironwood Pharmaceuticals, Inc. (IRWD) con nuestra calculadora DCF avanzada! Personalice los supuestos clave, explore varios escenarios y evalúe cómo los diferentes cambios afectan la valoración de Ironwood Pharmaceuticals, Inc. (IRWD), todo dentro de una plantilla de Excel fácil de usar.
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 | 428.4 | 389.5 | 413.8 | 410.6 | 442.7 | 447.4 | 452.1 | 456.9 | 461.7 | 466.5 |
Revenue Growth, % | 0 | -9.08 | 6.22 | -0.76302 | 7.83 | 1.05 | 1.05 | 1.05 | 1.05 | 1.05 |
EBITDA | 101.1 | 141.9 | 233.3 | 261.4 | -924.9 | 71.7 | 72.4 | 73.2 | 74.0 | 74.7 |
EBITDA, % | 23.6 | 36.43 | 56.39 | 63.67 | -208.9 | 16.02 | 16.02 | 16.02 | 16.02 | 16.02 |
Depreciation | 5.6 | 3.6 | 1.5 | 1.4 | 1.6 | 2.9 | 3.0 | 3.0 | 3.0 | 3.1 |
Depreciation, % | 1.3 | 0.91497 | 0.36809 | 0.34535 | 0.35574 | 0.65733 | 0.65733 | 0.65733 | 0.65733 | 0.65733 |
EBIT | 95.5 | 138.3 | 231.8 | 260.0 | -926.4 | 69.1 | 69.8 | 70.5 | 71.3 | 72.0 |
EBIT, % | 22.3 | 35.51 | 56.03 | 63.33 | -209.25 | 15.43 | 15.43 | 15.43 | 15.43 | 15.43 |
Total Cash | 177.0 | 362.6 | 620.1 | 656.2 | 92.2 | 317.8 | 321.2 | 324.6 | 328.0 | 331.4 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 117.2 | 122.4 | 114.0 | 115.5 | 129.1 | 128.5 | 129.9 | 131.2 | 132.6 | 134.0 |
Account Receivables, % | 27.37 | 31.41 | 27.56 | 28.12 | 29.16 | 28.73 | 28.73 | 28.73 | 28.73 | 28.73 |
Inventories | .6 | .0 | 1.3 | 1.3 | .0 | .7 | .7 | .7 | .7 | .7 |
Inventories, % | 0.15126 | 0.000000257 | 0.30211 | 0.30444 | 0 | 0.15156 | 0.15156 | 0.15156 | 0.15156 | 0.15156 |
Accounts Payable | 5.5 | .7 | .9 | .5 | 7.8 | 3.2 | 3.2 | 3.3 | 3.3 | 3.3 |
Accounts Payable, % | 1.28 | 0.16969 | 0.22598 | 0.11763 | 1.77 | 0.71253 | 0.71253 | 0.71253 | 0.71253 | 0.71253 |
Capital Expenditure | -7.2 | -1.8 | -.3 | -.1 | -.3 | -2.1 | -2.1 | -2.1 | -2.1 | -2.2 |
Capital Expenditure, % | -1.68 | -0.47289 | -0.06404787 | -0.03312258 | -0.06166217 | -0.46195 | -0.46195 | -0.46195 | -0.46195 | -0.46195 |
Tax Rate, % | -5.71 | -5.71 | -5.71 | -5.71 | -5.71 | -5.71 | -5.71 | -5.71 | -5.71 | -5.71 |
EBITAT | -24.8 | 134.9 | 610.5 | 180.3 | -979.4 | 50.7 | 51.2 | 51.7 | 52.3 | 52.8 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -138.8 | 127.4 | 619.1 | 179.7 | -983.1 | 46.8 | 50.8 | 51.3 | 51.8 | 52.4 |
WACC, % | 3.29 | 5.5 | 5.55 | 4.86 | 5.55 | 4.95 | 4.95 | 4.95 | 4.95 | 4.95 |
PV UFCF | ||||||||||
SUM PV UFCF | 218.9 | |||||||||
Long Term Growth Rate, % | 0.50 | |||||||||
Free cash flow (T + 1) | 53 | |||||||||
Terminal Value | 1,183 | |||||||||
Present Terminal Value | 929 | |||||||||
Enterprise Value | 1,148 | |||||||||
Net Debt | 623 | |||||||||
Equity Value | 525 | |||||||||
Diluted Shares Outstanding, MM | 155 | |||||||||
Equity Value Per Share | 3.38 |
What You Will Get
- Real IRWD Financial Data: Pre-filled with Ironwood 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 Ironwood 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
- Customizable Forecast Inputs: Adjust essential metrics such as revenue growth, EBITDA %, and R&D expenditures.
- Instant DCF Valuation: Automatically computes intrinsic value, NPV, and other key financial indicators.
- High-Precision Accuracy: Leverages Ironwood's actual financial data for dependable valuation results.
- Effortless Scenario Analysis: Easily evaluate various assumptions and analyze different outcomes.
- Efficiency Booster: Streamline your workflow by avoiding the complexity of creating valuation models from the ground up.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Ironwood Pharmaceuticals data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Ironwood Pharmaceuticals’ intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose Ironwood Pharmaceuticals, Inc. (IRWD)?
- Innovative Solutions: Cutting-edge therapies tailored to meet patient needs.
- Proven Track Record: Strong clinical results and a commitment to quality.
- Patient-Centric Approach: Focused on enhancing the patient experience and outcomes.
- Expert Team: A dedicated group of professionals driving research and development.
- Industry Recognition: A trusted name in pharmaceuticals with numerous accolades.
Who Should Use This Product?
- Investors: Assess the fair value of Ironwood Pharmaceuticals (IRWD) to inform your investment choices.
- CFOs: Utilize a sophisticated DCF model for accurate financial reporting and analysis.
- Consultants: Easily customize the template for client valuation reports.
- Entrepreneurs: Understand financial modeling techniques employed by leading pharmaceutical companies.
- Educators: Implement it as a resource to teach valuation methods effectively.
What the Template Contains
- Historical Data: Includes Ironwood Pharmaceuticals’ past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Ironwood Pharmaceuticals’ intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
- Quarterly and Annual Statements: A complete breakdown of Ironwood Pharmaceuticals’ financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.