Agenus Inc. (AGEN) 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
Agenus Inc. (AGEN) Bundle
Designed for accuracy, our (AGEN) DCF Calculator enables you to evaluate Agenus Inc. valuation using real-world financial data and offers 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 | 150.0 | 88.2 | 295.7 | 98.0 | 156.3 | 176.4 | 199.1 | 224.6 | 253.5 | 286.0 |
Revenue Growth, % | 0 | -41.24 | 235.34 | -66.85 | 59.47 | 12.84 | 12.84 | 12.84 | 12.84 | 12.84 |
EBITDA | -63.4 | -114.6 | 44.0 | -161.8 | -145.9 | -113.2 | -127.7 | -144.1 | -162.6 | -183.5 |
EBITDA, % | -42.28 | -130.01 | 14.89 | -165.11 | -93.35 | -64.15 | -64.15 | -64.15 | -64.15 | -64.15 |
Depreciation | 6.7 | 7.2 | 6.8 | 6.9 | 13.6 | 10.8 | 12.2 | 13.8 | 15.5 | 17.5 |
Depreciation, % | 4.44 | 8.14 | 2.3 | 7.09 | 8.69 | 6.13 | 6.13 | 6.13 | 6.13 | 6.13 |
EBIT | -70.1 | -121.8 | 37.2 | -168.8 | -159.5 | -117.9 | -133.0 | -150.1 | -169.4 | -191.1 |
EBIT, % | -46.72 | -138.16 | 12.59 | -172.2 | -102.05 | -66.83 | -66.83 | -66.83 | -66.83 | -66.83 |
Total Cash | 61.8 | 99.9 | 306.9 | 193.4 | 76.1 | 137.5 | 155.2 | 175.1 | 197.6 | 223.0 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 16.3 | 1.2 | 1.5 | 2.7 | 25.8 | 11.3 | 12.7 | 14.4 | 16.2 | 18.3 |
Account Receivables, % | 10.86 | 1.31 | 0.51342 | 2.8 | 16.53 | 6.4 | 6.4 | 6.4 | 6.4 | 6.4 |
Inventories | 7.4 | 10.7 | 20.4 | 13.8 | .0 | 13.5 | 15.2 | 17.1 | 19.3 | 21.8 |
Inventories, % | 4.95 | 12.19 | 6.89 | 14.11 | 0 | 7.63 | 7.63 | 7.63 | 7.63 | 7.63 |
Accounts Payable | 13.6 | 17.0 | 30.5 | 40.9 | 61.4 | 42.2 | 47.7 | 53.8 | 60.7 | 68.5 |
Accounts Payable, % | 9.04 | 19.3 | 10.31 | 41.76 | 39.31 | 23.94 | 23.94 | 23.94 | 23.94 | 23.94 |
Capital Expenditure | -4.7 | -3.5 | -33.8 | -53.1 | -10.0 | -27.9 | -31.4 | -35.5 | -40.0 | -45.2 |
Capital Expenditure, % | -3.1 | -3.93 | -11.44 | -54.13 | -6.37 | -15.79 | -15.79 | -15.79 | -15.79 | -15.79 |
Tax Rate, % | 4.54 | 4.54 | 4.54 | 4.54 | 4.54 | 4.54 | 4.54 | 4.54 | 4.54 | 4.54 |
EBITAT | -93.7 | -159.9 | 122.7 | -198.7 | -152.3 | -116.8 | -131.8 | -148.7 | -167.8 | -189.4 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -101.9 | -141.0 | 99.2 | -229.0 | -137.4 | -152.0 | -148.8 | -167.9 | -189.5 | -213.8 |
WACC, % | 81.22 | 81.22 | 81.22 | 81.22 | 77.73 | 80.53 | 80.53 | 80.53 | 80.53 | 80.53 |
PV UFCF | ||||||||||
SUM PV UFCF | -187.4 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -218 | |||||||||
Terminal Value | -278 | |||||||||
Present Terminal Value | -14 | |||||||||
Enterprise Value | -202 | |||||||||
Net Debt | 2 | |||||||||
Equity Value | -204 | |||||||||
Diluted Shares Outstanding, MM | 18 | |||||||||
Equity Value Per Share | -11.39 |
What You Will Get
- Real AGEN Financial Data: Pre-filled with Agenus Inc.’s historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See Agenus Inc.’s intrinsic value update instantly based on your changes.
- Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
- User-Friendly Design: Simple structure and clear instructions for all experience levels.
Key Features
- Comprehensive Agenus Financials: Gain access to precise pre-loaded historical data and future forecasts.
- Adjustable Forecast Parameters: Modify yellow-highlighted cells such as WACC, growth rates, and profit margins.
- Real-Time Calculations: Automatic updates for DCF, Net Present Value (NPV), and cash flow assessments.
- Interactive Dashboard: User-friendly charts and summaries to help visualize your valuation outcomes.
- Designed for All Skill Levels: An intuitive layout tailored for investors, CFOs, and consultants alike.
How It Works
- Step 1: Download the prebuilt Excel template featuring Agenus Inc. (AGEN) data.
- Step 2: Review the pre-filled sheets to familiarize yourself with the essential metrics.
- Step 3: Modify forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly access recalculated results, including Agenus Inc.'s (AGEN) intrinsic value.
- Step 5: Make informed investment decisions or create reports based on the outputs.
Why Choose Agenus Inc. (AGEN) Calculator?
- Save Time: Instantly access a comprehensive DCF model without starting from scratch.
- Enhance Accuracy: Utilize dependable financial data and formulas to minimize valuation errors.
- Fully Customizable: Adjust the model to align with your specific assumptions and forecasts.
- Easy to Understand: Intuitive charts and outputs simplify the analysis of results.
- Endorsed by Professionals: Crafted for experts who prioritize precision and functionality.
Who Should Use This Product?
- Finance Students: Explore advanced valuation techniques and apply them using real-time data for Agenus Inc. (AGEN).
- Academics: Integrate industry-standard models into your coursework or research focused on biotechnology.
- Investors: Validate your investment hypotheses and evaluate valuation scenarios for Agenus Inc. (AGEN).
- Analysts: Enhance your analysis process with a ready-to-use, customizable DCF model tailored for Agenus Inc. (AGEN).
- Biotech Enthusiasts: Understand the analytical methods used for evaluating companies like Agenus Inc. (AGEN).
What the Template Contains
- Pre-Filled Data: Includes Agenus Inc.'s historical financials and projections.
- 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 Agenus Inc.'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.