MannKind Corporation (MNKD) 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
MannKind Corporation (MNKD) Bundle
Designed for accuracy, our MNKD DCF Calculator enables you to evaluate MannKind Corporation's valuation using real-world financial data, offering complete flexibility to modify all essential parameters for improved 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 | 63.0 | 65.1 | 75.4 | 99.8 | 199.0 | 274.0 | 377.3 | 519.5 | 715.4 | 985.2 |
Revenue Growth, % | 0 | 3.34 | 15.81 | 32.25 | 99.42 | 37.7 | 37.7 | 37.7 | 37.7 | 37.7 |
EBITDA | -38.2 | -45.0 | -61.1 | -56.3 | 15.1 | -142.2 | -195.9 | -269.7 | -371.4 | -511.4 |
EBITDA, % | -60.62 | -69.09 | -80.98 | -56.47 | 7.6 | -51.91 | -51.91 | -51.91 | -51.91 | -51.91 |
Depreciation | 2.8 | 3.0 | 3.3 | 6.3 | 4.5 | 12.0 | 16.5 | 22.7 | 31.3 | 43.1 |
Depreciation, % | 4.41 | 4.57 | 4.32 | 6.3 | 2.28 | 4.38 | 4.38 | 4.38 | 4.38 | 4.38 |
EBIT | -41.0 | -48.0 | -64.3 | -62.6 | 10.6 | -154.2 | -212.4 | -292.4 | -402.7 | -554.5 |
EBIT, % | -65.04 | -73.66 | -85.3 | -62.78 | 5.32 | -56.29 | -56.29 | -56.29 | -56.29 | -56.29 |
Total Cash | 49.9 | 67.0 | 204.1 | 170.8 | 295.1 | 262.5 | 361.5 | 497.8 | 685.6 | 944.0 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 3.5 | 4.2 | 5.0 | 16.8 | 14.9 | 23.6 | 32.4 | 44.7 | 61.5 | 84.7 |
Account Receivables, % | 5.57 | 6.47 | 6.62 | 16.84 | 7.49 | 8.6 | 8.6 | 8.6 | 8.6 | 8.6 |
Inventories | 4.2 | 5.0 | 7.2 | 21.8 | 28.5 | 32.8 | 45.2 | 62.2 | 85.7 | 118.0 |
Inventories, % | 6.59 | 7.63 | 9.48 | 21.82 | 14.35 | 11.97 | 11.97 | 11.97 | 11.97 | 11.97 |
Accounts Payable | 4.8 | 5.6 | 7.0 | 11.1 | 9.6 | 22.6 | 31.1 | 42.9 | 59.1 | 81.3 |
Accounts Payable, % | 7.6 | 8.57 | 9.22 | 11.08 | 4.81 | 8.26 | 8.26 | 8.26 | 8.26 | 8.26 |
Capital Expenditure | -2.6 | -4.8 | -11.5 | -7.6 | -42.4 | -30.4 | -41.9 | -57.7 | -79.5 | -109.4 |
Capital Expenditure, % | -4.07 | -7.34 | -15.2 | -7.61 | -21.33 | -11.11 | -11.11 | -11.11 | -11.11 | -11.11 |
Tax Rate, % | -15.04 | -15.04 | -15.04 | -15.04 | -15.04 | -15.04 | -15.04 | -15.04 | -15.04 | -15.04 |
EBITAT | -47.2 | -47.8 | -73.0 | -80.4 | 12.2 | -154.1 | -212.2 | -292.2 | -402.4 | -554.1 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -49.8 | -50.3 | -82.8 | -104.0 | -32.1 | -172.4 | -250.3 | -344.7 | -474.7 | -653.7 |
WACC, % | 9.88 | 9.87 | 9.88 | 9.88 | 9.88 | 9.87 | 9.87 | 9.87 | 9.87 | 9.87 |
PV UFCF | ||||||||||
SUM PV UFCF | -1,358.1 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -667 | |||||||||
Terminal Value | -8,467 | |||||||||
Present Terminal Value | -5,288 | |||||||||
Enterprise Value | -6,646 | |||||||||
Net Debt | 144 | |||||||||
Equity Value | -6,790 | |||||||||
Diluted Shares Outstanding, MM | 267 | |||||||||
Equity Value Per Share | -25.43 |
What You Will Receive
- Pre-Filled Financial Model: MannKind Corporation’s actual data allows for accurate DCF valuation.
- Comprehensive Forecast Control: Modify revenue growth, profit margins, WACC, and other essential factors.
- Real-Time Calculations: Automatic updates provide immediate results as you adjust inputs.
- Investor-Ready Template: A polished Excel file crafted for high-quality valuation analysis.
- Customizable and Reusable: Designed for adaptability, enabling repeated use for in-depth forecasts.
Key Features
- Authentic MannKind Financials: Gain access to reliable pre-loaded historical data and future forecasts.
- Adjustable Forecast Parameters: Modify highlighted cells such as WACC, growth rates, and profit margins.
- Real-Time Calculations: Instant updates to DCF, Net Present Value (NPV), and cash flow assessments.
- Intuitive Visual Dashboard: Clear charts and summaries to help you interpret your valuation findings.
- Suitable for All Skill Levels: A straightforward, user-friendly design tailored for investors, CFOs, and consultants.
How It Works
- Step 1: Download the Excel file for MannKind Corporation (MNKD).
- Step 2: Review MannKind's pre-filled financial data and projections.
- Step 3: Adjust key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you modify assumptions.
- Step 5: Evaluate the outputs and leverage the results for investment decisions.
Why Choose This Calculator for MannKind Corporation (MNKD)?
- Designed for Experts: A sophisticated tool tailored for analysts, CFOs, and industry consultants.
- Accurate Data: MannKind's historical and projected financials are preloaded for precision.
- Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
- Clear Results: Automatically computes intrinsic value, NPV, and essential metrics.
- User-Friendly: Comprehensive step-by-step instructions help you navigate the process.
Who Should Use MannKind Corporation (MNKD)?
- Healthcare Students: Explore the intricacies of biopharmaceutical valuation and apply theories with real-world data.
- Researchers: Utilize advanced models in studies related to diabetes and pulmonary diseases.
- Investors: Evaluate your investment strategies and assess the market potential of MannKind Corporation (MNKD).
- Market Analysts: Enhance your analysis process with a customizable financial model tailored for biopharma companies.
- Entrepreneurs: Understand how public biotech firms like MannKind Corporation (MNKD) navigate market challenges.
What the Template Contains
- Pre-Filled Data: Contains MannKind Corporation’s historical financials and projections.
- Discounted Cash Flow Model: An editable DCF valuation model featuring automated calculations.
- Weighted Average Cost of Capital (WACC): A specific sheet for calculating WACC using customized inputs.
- Key Financial Ratios: Evaluate MannKind’s profitability, efficiency, and leverage metrics.
- Customizable Inputs: Easily adjust revenue growth, margins, and tax rates.
- Clear Dashboard: Visual representations and tables summarizing essential valuation outcomes.