Codexis, Inc. (CDXS) DCF Valuation
- ✓ 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
Codexis, Inc. (CDXS) Bundle
Evaluate Codexis, Inc. (CDXS) financial prospects like a professional! This (CDXS) DCF Calculator provides pre-filled financial data and full flexibility to modify revenue growth, WACC, margins, and other critical assumptions to align with your predictions.
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 | 68.5 | 69.1 | 104.8 | 138.6 | 70.1 | 76.4 | 83.1 | 90.5 | 98.5 | 107.3 |
| Revenue Growth, % | 0 | 0.87353 | 51.69 | 32.3 | -49.39 | 8.87 | 8.87 | 8.87 | 8.87 | 8.87 |
| EBITDA | -8.0 | -19.4 | -16.8 | -23.1 | -49.3 | -21.8 | -23.7 | -25.8 | -28.1 | -30.6 |
| EBITDA, % | -11.67 | -28.04 | -15.99 | -16.64 | -70.26 | -28.52 | -28.52 | -28.52 | -28.52 | -28.52 |
| Depreciation | 4.8 | 4.6 | 5.9 | 10.3 | 9.9 | 6.2 | 6.8 | 7.4 | 8.0 | 8.7 |
| Depreciation, % | 6.96 | 6.59 | 5.68 | 7.4 | 14.15 | 8.16 | 8.16 | 8.16 | 8.16 | 8.16 |
| EBIT | -12.8 | -23.9 | -22.7 | -33.3 | -59.2 | -28.0 | -30.5 | -33.2 | -36.1 | -39.3 |
| EBIT, % | -18.63 | -34.64 | -21.67 | -24.04 | -84.41 | -36.68 | -36.68 | -36.68 | -36.68 | -36.68 |
| Total Cash | 90.5 | 150.1 | 116.8 | 114.0 | 65.1 | 72.6 | 79.0 | 86.0 | 93.6 | 101.9 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 20.2 | 29.3 | 37.7 | 40.9 | 19.9 | 25.3 | 27.6 | 30.0 | 32.7 | 35.6 |
| Account Receivables, % | 29.44 | 42.41 | 35.94 | 29.49 | 28.41 | 33.14 | 33.14 | 33.14 | 33.14 | 33.14 |
| Inventories | .4 | 1.0 | 1.2 | 2.0 | 2.7 | 1.3 | 1.4 | 1.5 | 1.6 | 1.8 |
| Inventories, % | 0.54194 | 1.4 | 1.11 | 1.46 | 3.83 | 1.67 | 1.67 | 1.67 | 1.67 | 1.67 |
| Accounts Payable | 2.6 | 3.0 | 3.0 | 3.2 | 5.9 | 3.3 | 3.6 | 3.9 | 4.3 | 4.7 |
| Accounts Payable, % | 3.83 | 4.3 | 2.86 | 2.34 | 8.48 | 4.36 | 4.36 | 4.36 | 4.36 | 4.36 |
| Capital Expenditure | -3.7 | -3.7 | -13.8 | -8.3 | -4.4 | -5.6 | -6.0 | -6.6 | -7.2 | -7.8 |
| Capital Expenditure, % | -5.45 | -5.43 | -13.2 | -5.99 | -6.3 | -7.27 | -7.27 | -7.27 | -7.27 | -7.27 |
| Tax Rate, % | -0.09058566 | -0.09058566 | -0.09058566 | -0.09058566 | -0.09058566 | -0.09058566 | -0.09058566 | -0.09058566 | -0.09058566 | -0.09058566 |
| EBITAT | -12.8 | -24.3 | -22.9 | -33.6 | -59.3 | -28.0 | -30.5 | -33.2 | -36.1 | -39.3 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -29.6 | -32.8 | -39.3 | -35.5 | -30.8 | -33.9 | -31.8 | -34.6 | -37.7 | -41.1 |
| WACC, % | 13.79 | 13.79 | 13.79 | 13.79 | 13.79 | 13.79 | 13.79 | 13.79 | 13.79 | 13.79 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -121.9 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -42 | |||||||||
| Terminal Value | -355 | |||||||||
| Present Terminal Value | -186 | |||||||||
| Enterprise Value | -308 | |||||||||
| Net Debt | -49 | |||||||||
| Equity Value | -259 | |||||||||
| Diluted Shares Outstanding, MM | 68 | |||||||||
| Equity Value Per Share | -3.80 |
What You Will Get
- Real CDXS Financials: Includes historical and forecasted data for precise valuation.
- Adjustable Inputs: Modify WACC, tax rates, revenue growth, and capital expenditures.
- Automatic Calculations: Intrinsic value and NPV are calculated dynamically.
- Scenario Analysis: Test multiple scenarios to assess Codexis’ future performance.
- Clear and Intuitive Design: Designed for professionals while remaining user-friendly for beginners.
Key Features
- Advanced DCF Calculator: Features comprehensive unlevered and levered DCF valuation models tailored for Codexis, Inc. (CDXS).
- WACC Calculator: Ready-to-use Weighted Average Cost of Capital sheet with adjustable inputs specific to Codexis, Inc. (CDXS).
- Editable Forecast Assumptions: Customize growth rates, capital expenditures, and discount rates for Codexis, Inc. (CDXS).
- Built-In Financial Ratios: Evaluate profitability, leverage, and efficiency ratios relevant to Codexis, Inc. (CDXS).
- Dashboard and Charts: Visual representations summarize essential valuation metrics for straightforward analysis of Codexis, Inc. (CDXS).
How It Works
- Step 1: Download the Excel file for Codexis, Inc. (CDXS).
- Step 2: Examine the pre-filled financial data and forecasts for Codexis.
- 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 your assumptions.
- Step 5: Evaluate the results and leverage the findings for your investment strategies.
Why Choose This Calculator for Codexis, Inc. (CDXS)?
- Designed for Experts: A sophisticated tool utilized by financial analysts, CFOs, and industry consultants.
- Accurate Data: Codexis’ historical and forecasted financials are preloaded for precise analysis.
- Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
- Comprehensive Outputs: Instantly calculates intrinsic value, NPV, and essential financial metrics.
- User-Friendly: Step-by-step guidance ensures a smooth calculation experience.
Who Should Use This Product?
- Investors: Accurately estimate Codexis, Inc.'s (CDXS) fair value before making investment decisions.
- CFOs: Leverage a professional-grade DCF model for financial reporting and analysis related to Codexis, Inc. (CDXS).
- Consultants: Quickly adapt the template for valuation reports for clients focused on Codexis, Inc. (CDXS).
- Entrepreneurs: Gain insights into financial modeling used by leading biotech companies like Codexis, Inc. (CDXS).
- Educators: Use it as a teaching tool to demonstrate valuation methodologies relevant to Codexis, Inc. (CDXS).
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Codexis 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 Codexis, Inc. (CDXS).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.