Cerus Corporation (CERS) 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
Cerus Corporation (CERS) Bundle
Engineered for accuracy, our (CERS) DCF Calculator enables you to evaluate Cerus Corporation's valuation using up-to-date financial data, while offering complete flexibility to modify all key 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 | 74.6 | 91.9 | 130.9 | 162.0 | 156.4 | 189.9 | 230.7 | 280.2 | 340.3 | 413.3 |
| Revenue Growth, % | 0 | 23.14 | 42.36 | 23.83 | -3.51 | 21.46 | 21.46 | 21.46 | 21.46 | 21.46 |
| EBITDA | -64.6 | -51.4 | -46.0 | -34.1 | -26.5 | -81.9 | -99.5 | -120.8 | -146.7 | -178.2 |
| EBITDA, % | -86.56 | -55.89 | -35.14 | -21.03 | -16.97 | -43.12 | -43.12 | -43.12 | -43.12 | -43.12 |
| Depreciation | 2.4 | 4.5 | 4.6 | 4.6 | 2.6 | 6.1 | 7.4 | 9.0 | 10.9 | 13.3 |
| Depreciation, % | 3.22 | 4.85 | 3.49 | 2.81 | 1.66 | 3.21 | 3.21 | 3.21 | 3.21 | 3.21 |
| EBIT | -67.0 | -55.8 | -50.6 | -38.6 | -29.1 | -88.0 | -106.9 | -129.8 | -157.6 | -191.5 |
| EBIT, % | -89.77 | -60.73 | -38.63 | -23.84 | -18.63 | -46.32 | -46.32 | -46.32 | -46.32 | -46.32 |
| Total Cash | 85.7 | 133.6 | 129.4 | 102.2 | 65.9 | 153.5 | 186.4 | 226.4 | 274.9 | 333.9 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 16.9 | 21.2 | 25.1 | 34.4 | 35.5 | 41.3 | 50.2 | 61.0 | 74.0 | 89.9 |
| Account Receivables, % | 22.62 | 23.03 | 19.2 | 21.24 | 22.7 | 21.76 | 21.76 | 21.76 | 21.76 | 21.76 |
| Inventories | 19.5 | 23.3 | 26.8 | 29.0 | 39.9 | 43.8 | 53.2 | 64.6 | 78.5 | 95.3 |
| Inventories, % | 26.11 | 25.3 | 20.47 | 17.9 | 25.5 | 23.06 | 23.06 | 23.06 | 23.06 | 23.06 |
| Accounts Payable | 22.2 | 24.2 | 35.6 | 33.0 | 23.8 | 45.2 | 54.8 | 66.6 | 80.9 | 98.3 |
| Accounts Payable, % | 29.72 | 26.34 | 27.21 | 20.37 | 15.25 | 23.78 | 23.78 | 23.78 | 23.78 | 23.78 |
| Capital Expenditure | -8.9 | -1.6 | -.9 | -2.0 | -4.6 | -7.1 | -8.6 | -10.4 | -12.7 | -15.4 |
| Capital Expenditure, % | -11.97 | -1.76 | -0.6954 | -1.23 | -2.94 | -3.72 | -3.72 | -3.72 | -3.72 | -3.72 |
| Tax Rate, % | -0.44746 | -0.44746 | -0.44746 | -0.44746 | -0.44746 | -0.44746 | -0.44746 | -0.44746 | -0.44746 | -0.44746 |
| EBITAT | -67.3 | -56.1 | -50.9 | -39.1 | -29.3 | -88.0 | -106.9 | -129.8 | -157.6 | -191.5 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -88.0 | -59.3 | -43.3 | -50.6 | -52.4 | -77.4 | -116.6 | -141.6 | -172.0 | -208.9 |
| WACC, % | 9.76 | 9.76 | 9.76 | 9.76 | 9.76 | 9.76 | 9.76 | 9.76 | 9.76 | 9.76 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -524.0 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -213 | |||||||||
| Terminal Value | -2,745 | |||||||||
| Present Terminal Value | -1,723 | |||||||||
| Enterprise Value | -2,247 | |||||||||
| Net Debt | 84 | |||||||||
| Equity Value | -2,331 | |||||||||
| Diluted Shares Outstanding, MM | 180 | |||||||||
| Equity Value Per Share | -12.93 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real CERS financials.
- Real-World Data: Historical data and forward-looking estimates (as highlighted in the yellow cells).
- Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Instantly observe the effects of your inputs on Cerus Corporation’s valuation.
- Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Design: Organized for clarity and ease of use, complete with step-by-step instructions.
Key Features
- Comprehensive Financial Data: Cerus Corporation’s (CERS) historical financial statements and pre-filled projections.
- Customizable Parameters: Adjust WACC, tax rates, revenue growth, and EBITDA margins to fit your analysis.
- Real-Time Valuation: Instantly view Cerus Corporation’s (CERS) intrinsic value updates as you modify inputs.
- Intuitive Visualizations: Dynamic dashboard charts illustrate valuation outcomes and essential metrics.
- Designed for Precision: A reliable tool tailored for analysts, investors, and finance professionals.
How It Works
- Step 1: Download the prebuilt Excel template featuring Cerus Corporation's (CERS) data.
- Step 2: Navigate through the pre-filled sheets to grasp the essential metrics.
- Step 3: Modify forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly view the updated results, including Cerus Corporation's (CERS) intrinsic value.
- Step 5: Make well-informed investment decisions or create reports based on the outputs.
Why Choose This Calculator for Cerus Corporation (CERS)?
- Accurate Data: Up-to-date Cerus Corporation financials provide dependable valuation outcomes.
- Customizable: Tailor essential parameters such as growth rates, WACC, and tax rates to fit your forecasts.
- Time-Saving: Ready-to-use calculations save you the hassle of starting from the ground up.
- Professional-Grade Tool: Crafted for investors, analysts, and consultants in the biotech sector.
- User-Friendly: Streamlined design and clear instructions make it accessible for all users.
Who Should Use This Product?
- Healthcare Professionals: Understand the latest advancements in medical technologies and their market implications.
- Researchers: Utilize data on Cerus Corporation (CERS) for academic studies and clinical research.
- Investors: Evaluate your investment strategies by analyzing the performance and growth potential of Cerus Corporation (CERS).
- Market Analysts: Enhance your analysis with comprehensive data and insights on Cerus Corporation (CERS).
- Biotech Entrepreneurs: Learn from the operational strategies of established companies like Cerus Corporation (CERS).
What the Template Contains
- Pre-Filled Data: Includes Cerus Corporation’s historical financials and forecasts.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
- Key Financial Ratios: Analyze Cerus Corporation’s profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
- Clear Dashboard: Charts and tables summarizing key valuation results.