|
Valoración de DCF de Madrigal Pharmaceuticals, Inc. (MDGL)
US | Healthcare | Biotechnology | 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
Madrigal Pharmaceuticals, Inc. (MDGL) Bundle
¡Mejore sus estrategias de inversión con la calculadora DCF de Madrigal Pharmaceuticals, Inc. (MDGL)! Explore datos financieros genuinos, ajuste las predicciones y gastos de crecimiento, y observe instantáneamente cómo estas alteraciones influyen en el valor intrínseco de los productos farmacéuticos madrigales (MDGL).
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 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Revenue Growth, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
EBITDA | -94.9 | -206.2 | -242.1 | -293.1 | -380.0 | .0 | .0 | .0 | .0 | .0 |
EBITDA, % | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |
Depreciation | .1 | .5 | .4 | .5 | .5 | .0 | .0 | .0 | .0 | .0 |
Depreciation, % | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |
EBIT | -95.0 | -206.7 | -242.5 | -293.6 | -380.5 | .0 | .0 | .0 | .0 | .0 |
EBIT, % | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |
Total Cash | 439.0 | 284.1 | 270.3 | 358.8 | 634.1 | .0 | .0 | .0 | .0 | .0 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables, % | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |
Inventories | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Inventories, % | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |
Accounts Payable | 1.2 | 1.0 | 21.4 | 23.8 | 28.0 | .0 | .0 | .0 | .0 | .0 |
Accounts Payable, % | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |
Capital Expenditure | -.2 | -.3 | -.2 | -.2 | -1.5 | .0 | .0 | .0 | .0 | .0 |
Capital Expenditure, % | 100 | 100 | 100 | 100 | 100 | 0 | 0 | 0 | 0 | 0 |
Tax Rate, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
EBITAT | -82.4 | -201.8 | -241.7 | -297.5 | -380.5 | .0 | .0 | .0 | .0 | .0 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -81.3 | -201.8 | -221.2 | -294.8 | -377.2 | -28.0 | .0 | .0 | .0 | .0 |
WACC, % | 5.47 | 5.5 | 5.5 | 5.5 | 5.5 | 5.49 | 5.49 | 5.49 | 5.49 | 5.49 |
PV UFCF | ||||||||||
SUM PV UFCF | -26.6 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 0 | |||||||||
Terminal Value | 0 | |||||||||
Present Terminal Value | 0 | |||||||||
Enterprise Value | -27 | |||||||||
Net Debt | 17 | |||||||||
Equity Value | -44 | |||||||||
Diluted Shares Outstanding, MM | 19 | |||||||||
Equity Value Per Share | -2.35 |
What You Will Get
- Real MDGL Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Automated Calculations: Intrinsic value and NPV are computed in real-time.
- Scenario Analysis: Evaluate various scenarios to assess Madrigal Pharmaceuticals' future outlook.
- Clear and User-Friendly Design: Designed for professionals while remaining easy for newcomers.
Key Features
- 🔍 Real-Life MDGL Financials: Pre-filled historical and projected data for Madrigal Pharmaceuticals, Inc.
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Madrigal's intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Madrigal’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Step 1: Download the Excel file for Madrigal Pharmaceuticals, Inc. (MDGL).
- Step 2: Review Madrigal’s pre-filled financial data and forecasts.
- Step 3: Modify key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you adjust your assumptions.
- Step 5: Evaluate the outputs and leverage the results for your investment decisions.
Why Choose This Calculator for Madrigal Pharmaceuticals, Inc. (MDGL)?
- Comprehensive Tool: Offers DCF, WACC, and financial ratio analyses tailored for Madrigal Pharmaceuticals.
- Customizable Inputs: Modify yellow-highlighted cells to explore different financial scenarios for MDGL.
- Detailed Insights: Automatically computes Madrigal’s intrinsic value and Net Present Value for informed decision-making.
- Preloaded Data: Access to historical and projected data ensures reliable starting points for analysis.
- Professional Quality: Perfect for financial analysts, investors, and business consultants focusing on MDGL.
Who Should Use This Product?
- Investors: Evaluate Madrigal Pharmaceuticals' valuation before making stock transactions.
- CFOs and Financial Analysts: Optimize valuation processes and assess financial forecasts.
- Startup Founders: Understand the valuation methods applied to biopharmaceutical companies like Madrigal.
- Consultants: Provide detailed valuation reports for clients in the healthcare sector.
- Students and Educators: Utilize real-world case studies to learn and teach valuation strategies.
What the Template Contains
- Historical Data: Includes Madrigal Pharmaceuticals' past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Madrigal 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 Madrigal Pharmaceuticals' financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.