Celcuity Inc. (CELC) DCF Valuation
- ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
- ✓ Professional Design: Trusted, Industry-Standard Templates
- ✓ Pre-Built For Quick And Efficient Use
- ✓ No Expertise Is Needed; Easy To Follow
Celcuity Inc. (CELC) Bundle
Looking to calculate the intrinsic value of Celcuity Inc.? Our CELC DCF Calculator integrates real-world data with extensive customization features, allowing you to adjust projections and enhance your investment strategies.
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 | -7.5 | -9.2 | -28.1 | -39.2 | -58.3 | .0 | .0 | .0 | .0 | .0 |
| EBITDA, % | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |
| Depreciation | .3 | .4 | .3 | .2 | .1 | .0 | .0 | .0 | .0 | .0 |
| Depreciation, % | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |
| EBIT | -7.8 | -9.6 | -28.4 | -39.4 | -58.5 | .0 | .0 | .0 | .0 | .0 |
| EBIT, % | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |
| Total Cash | 18.7 | 11.6 | 84.3 | 168.6 | 180.6 | .0 | .0 | .0 | .0 | .0 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | .2 | .2 | .3 | .0 | .8 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables, % | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |
| Inventories | -.2 | -.2 | -.3 | -.2 | .0 | .0 | .0 | .0 | .0 | .0 |
| Inventories, % | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |
| Accounts Payable | .1 | .2 | 1.5 | 2.6 | 5.1 | .0 | .0 | .0 | .0 | .0 |
| Accounts Payable, % | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |
| Capital Expenditure | -.4 | -.1 | -.1 | -.2 | -.1 | .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 | -7.4 | -9.2 | -29.3 | -40.3 | -58.5 | .0 | .0 | .0 | .0 | .0 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -7.3 | -8.8 | -27.8 | -39.0 | -57.0 | -4.3 | .0 | .0 | .0 | .0 |
| WACC, % | 7.62 | 7.63 | 7.64 | 7.64 | 7.64 | 7.64 | 7.64 | 7.64 | 7.64 | 7.64 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -4.0 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 0 | |||||||||
| Terminal Value | 0 | |||||||||
| Present Terminal Value | 0 | |||||||||
| Enterprise Value | -4 | |||||||||
| Net Debt | 7 | |||||||||
| Equity Value | -11 | |||||||||
| Diluted Shares Outstanding, MM | 24 | |||||||||
| Equity Value Per Share | -0.45 |
What You Will Receive
- Pre-Populated Financial Model: Celcuity Inc.’s actual data facilitates accurate DCF valuation.
- Comprehensive Forecast Control: Modify revenue growth, profit margins, WACC, and other essential metrics.
- Real-Time Calculations: Automatic updates provide immediate feedback as you adjust inputs.
- Professional-Grade Template: A polished Excel file crafted for high-quality valuation.
- Flexible and Reusable: Designed for adaptability, allowing for repeated use in detailed forecasting.
Key Features
- Comprehensive CELC Data: Pre-loaded with Celcuity Inc.'s historical performance and future projections.
- Customizable Assumptions: Modify growth rates, profit margins, discount rates, tax assumptions, and capital investments.
- Interactive Valuation Framework: Real-time updates to Net Present Value (NPV) and intrinsic value based on your adjustments.
- Scenario Analysis: Develop various forecasting scenarios to evaluate different valuation possibilities.
- Intuitive User Interface: Designed for ease of use, catering to both industry professionals and newcomers.
How It Works
- Download: Obtain the ready-to-use Excel file featuring Celcuity Inc.'s (CELC) financial metrics.
- Customize: Tailor forecasts, including revenue projections, EBITDA %, and WACC.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Generate multiple projections and evaluate results immediately.
- Make Decisions: Utilize the valuation insights to inform your investment approach.
Why Choose This Calculator for Celcuity Inc. (CELC)?
- Designed for Experts: A sophisticated tool utilized by analysts, CFOs, and industry consultants.
- Comprehensive Data: Celcuity’s historical and projected financials preloaded for precise analysis.
- Flexible Scenario Analysis: Easily simulate various forecasts and assumptions.
- Insightful Outputs: Automatically computes intrinsic value, NPV, and essential metrics.
- User-Friendly: Step-by-step guidance to help you navigate the process effortlessly.
Who Should Use This Product?
- Investors: Evaluate Celcuity Inc.’s (CELC) market performance before making investment decisions.
- CFOs and Financial Analysts: Optimize valuation methodologies and assess financial forecasts for Celcuity Inc. (CELC).
- Startup Founders: Understand how emerging biotech companies like Celcuity Inc. (CELC) are valued in the market.
- Consultants: Create detailed valuation analyses and reports for clients focusing on Celcuity Inc. (CELC).
- Students and Educators: Utilize real-time data from Celcuity Inc. (CELC) to enhance learning in valuation practices.
What the Template Contains
- Pre-Filled DCF Model: Celcuity Inc.’s (CELC) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Celcuity Inc.’s (CELC) profitability, leverage, and efficiency.
- Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
- Financial Statements: Annual and quarterly reports to support detailed analysis.
- Interactive Dashboard: Easily visualize key valuation metrics and results.