|
Cumberland Pharmaceuticals Inc. (CPIX) DCF Valuation
US | Healthcare | Drug Manufacturers - Specialty & Generic | NASDAQ
|
- ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
- ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
- ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
- ✓ Aucune Expertise N'Est Requise; Facile À Suivre
Cumberland Pharmaceuticals Inc. (CPIX) Bundle
Save time and improve precision with our [CPIX] DCF Calculator! Utilizing real Cumberland Pharmaceuticals Inc. data and customizable assumptions, this tool allows you to forecast, analyze, and evaluate Cumberland Pharmaceuticals like a seasoned investor.
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 | 34.4 | 37.4 | 36.0 | 42.0 | 39.6 | 41.1 | 42.8 | 44.5 | 46.2 | 48.1 |
| Revenue Growth, % | 0 | 8.88 | -3.89 | 16.75 | -5.85 | 3.97 | 3.97 | 3.97 | 3.97 | 3.97 |
| EBITDA | -4.6 | -1.6 | -.9 | .3 | .2 | -1.6 | -1.6 | -1.7 | -1.7 | -1.8 |
| EBITDA, % | -13.49 | -4.16 | -2.38 | 0.79246 | 0.38763 | -3.77 | -3.77 | -3.77 | -3.77 | -3.77 |
| Depreciation | 4.4 | 4.7 | 4.6 | 5.3 | 5.8 | 5.4 | 5.6 | 5.8 | 6.1 | 6.3 |
| Depreciation, % | 12.81 | 12.68 | 12.8 | 12.68 | 14.59 | 13.11 | 13.11 | 13.11 | 13.11 | 13.11 |
| EBIT | -9.0 | -6.3 | -5.5 | -5.0 | -5.6 | -6.9 | -7.2 | -7.5 | -7.8 | -8.1 |
| EBIT, % | -26.3 | -16.84 | -15.18 | -11.89 | -14.2 | -16.88 | -16.88 | -16.88 | -16.88 | -16.88 |
| Total Cash | 28.2 | 24.8 | 27.0 | 19.8 | 18.3 | 26.0 | 27.1 | 28.2 | 29.3 | 30.4 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 7.9 | 12.4 | 6.9 | 13.2 | 9.8 | 10.8 | 11.2 | 11.6 | 12.1 | 12.6 |
| Account Receivables, % | 22.85 | 33.06 | 19.11 | 31.33 | 24.67 | 26.21 | 26.21 | 26.21 | 26.21 | 26.21 |
| Inventories | 8.9 | 10.6 | 8.4 | 9.4 | 4.6 | 9.2 | 9.5 | 9.9 | 10.3 | 10.7 |
| Inventories, % | 25.8 | 28.41 | 23.43 | 22.37 | 11.65 | 22.33 | 22.33 | 22.33 | 22.33 | 22.33 |
| Accounts Payable | 10.0 | 13.4 | 9.6 | 10.8 | 14.0 | 12.6 | 13.1 | 13.6 | 14.1 | 14.7 |
| Accounts Payable, % | 29.06 | 35.78 | 26.79 | 25.75 | 35.49 | 30.58 | 30.58 | 30.58 | 30.58 | 30.58 |
| Capital Expenditure | -1.0 | -2.1 | -.4 | -2.1 | -.5 | -1.3 | -1.3 | -1.4 | -1.4 | -1.5 |
| Capital Expenditure, % | -2.96 | -5.65 | -0.98503 | -4.94 | -1.15 | -3.14 | -3.14 | -3.14 | -3.14 | -3.14 |
| Tax Rate, % | 0.09032622 | 0.09032622 | 0.09032622 | 0.09032622 | 0.09032622 | 0.09032622 | 0.09032622 | 0.09032622 | 0.09032622 | 0.09032622 |
| EBITAT | -9.0 | -6.4 | -5.5 | -5.1 | -5.6 | -6.9 | -7.2 | -7.5 | -7.8 | -8.1 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -12.3 | -6.6 | 2.7 | -7.9 | 11.1 | -9.9 | -3.2 | -3.4 | -3.5 | -3.6 |
| WACC, % | 5.1 | 5.11 | 5.11 | 5.11 | 5.11 | 5.11 | 5.11 | 5.11 | 5.11 | 5.11 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -20.9 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -4 | |||||||||
| Terminal Value | -119 | |||||||||
| Present Terminal Value | -93 | |||||||||
| Enterprise Value | -114 | |||||||||
| Net Debt | 0 | |||||||||
| Equity Value | -114 | |||||||||
| Diluted Shares Outstanding, MM | 14 | |||||||||
| Equity Value Per Share | -7.96 |
What You Will Get
- Real Cumberland Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Cumberland Pharmaceuticals Inc. (CPIX).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates for Cumberland Pharmaceuticals Inc. (CPIX).
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on Cumberland Pharmaceuticals Inc. (CPIX)’s fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections specific to Cumberland Pharmaceuticals Inc. (CPIX).
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility for Cumberland Pharmaceuticals Inc. (CPIX).
Key Features
- Real-Life CPIX Data: Pre-filled with Cumberland Pharmaceuticals’ historical financials and forward-looking projections.
- Fully Customizable Inputs: Adjust revenue growth, margins, WACC, tax rates, and capital expenditures.
- Dynamic Valuation Model: Automatic updates to Net Present Value (NPV) and intrinsic value based on your inputs.
- Scenario Testing: Create multiple forecast scenarios to analyze different valuation outcomes.
- User-Friendly Design: Simple, structured, and designed for professionals and beginners alike.
How It Works
- Download: Get the pre-built Excel file containing Cumberland Pharmaceuticals Inc.'s (CPIX) financial data.
- Customize: Modify projections, such as revenue growth, EBITDA %, and WACC.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Generate various forecasts and evaluate results instantly.
- Make Decisions: Leverage the valuation insights to inform your investment choices.
Why Choose This Calculator for Cumberland Pharmaceuticals Inc. (CPIX)?
- Designed for Industry Experts: A sophisticated tool tailored for analysts, CFOs, and healthcare consultants.
- Accurate Data Integration: Historical and projected financials for Cumberland Pharmaceuticals preloaded for precision.
- Flexible Scenario Analysis: Effortlessly test various forecasts and assumptions.
- Comprehensive Outputs: Automatically computes intrinsic value, NPV, and essential financial metrics.
- User-Friendly Interface: Step-by-step guidance ensures a seamless experience.
Who Should Use This Product?
- Healthcare Investors: Develop comprehensive valuation models for assessing Cumberland Pharmaceuticals Inc. (CPIX) stock.
- Pharmaceutical Finance Teams: Evaluate valuation scenarios to inform corporate strategies and decisions.
- Consultants and Advisors: Deliver precise valuation insights for clients interested in Cumberland Pharmaceuticals Inc. (CPIX).
- Students and Educators: Utilize real-world data to enhance learning in financial modeling and analysis.
- Biotech Enthusiasts: Gain insights into how pharmaceutical companies like Cumberland Pharmaceuticals Inc. (CPIX) are valued in the market.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Cumberland Pharmaceuticals Inc. (CPIX) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for Cumberland Pharmaceuticals Inc. (CPIX).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.