Avid Bioservices, Inc. (CDMO) 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
Avid Bioservices, Inc. (CDMO) Bundle
Evaluate Avid Bioservices, Inc.'s financial outlook like an expert! This (CDMO) DCF Calculator provides you with pre-filled financials while allowing you the flexibility to modify revenue growth, WACC, margins, and other critical assumptions to align with your predictions.
Discounted Cash Flow (DCF) - (USD MM)
| Year | AY1 2020 |
AY2 2021 |
AY3 2022 |
AY4 2023 |
AY5 2024 |
FY1 2025 |
FY2 2026 |
FY3 2027 |
FY4 2028 |
FY5 2029 |
|---|---|---|---|---|---|---|---|---|---|---|
| Revenue | 59.7 | 95.9 | 119.6 | 149.3 | 139.9 | 176.2 | 222.0 | 279.7 | 352.3 | 443.8 |
| Revenue Growth, % | 0 | 60.58 | 24.75 | 24.81 | -6.27 | 25.97 | 25.97 | 25.97 | 25.97 | 25.97 |
| EBITDA | -7.4 | 15.7 | 19.9 | 10.9 | -11.5 | 7.0 | 8.8 | 11.1 | 13.9 | 17.5 |
| EBITDA, % | -12.35 | 16.37 | 16.64 | 7.31 | -8.21 | 3.95 | 3.95 | 3.95 | 3.95 | 3.95 |
| Depreciation | 3.1 | 3.5 | 4.5 | 7.2 | 11.1 | 8.9 | 11.2 | 14.1 | 17.8 | 22.4 |
| Depreciation, % | 5.18 | 3.6 | 3.75 | 4.83 | 7.94 | 5.06 | 5.06 | 5.06 | 5.06 | 5.06 |
| EBIT | -10.5 | 12.2 | 15.4 | 3.7 | -22.6 | -1.9 | -2.5 | -3.1 | -3.9 | -4.9 |
| EBIT, % | -17.53 | 12.77 | 12.89 | 2.48 | -16.15 | -1.11 | -1.11 | -1.11 | -1.11 | -1.11 |
| Total Cash | 36.3 | 169.9 | 126.2 | 38.5 | 38.1 | 110.6 | 139.3 | 175.5 | 221.1 | 278.5 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 11.9 | 25.0 | 25.9 | 27.9 | 29.0 | 37.7 | 47.5 | 59.9 | 75.4 | 95.0 |
| Account Receivables, % | 19.94 | 26.03 | 21.67 | 18.7 | 20.73 | 21.41 | 21.41 | 21.41 | 21.41 | 21.41 |
| Inventories | 10.9 | 11.9 | 26.1 | 43.9 | 30.4 | 36.5 | 46.0 | 57.9 | 72.9 | 91.9 |
| Inventories, % | 18.23 | 12.38 | 21.79 | 29.42 | 21.71 | 20.71 | 20.71 | 20.71 | 20.71 | 20.71 |
| Accounts Payable | 5.9 | 9.3 | 9.5 | 24.6 | 20.7 | 20.7 | 26.1 | 32.9 | 41.4 | 52.2 |
| Accounts Payable, % | 9.93 | 9.66 | 7.95 | 16.48 | 14.77 | 11.76 | 11.76 | 11.76 | 11.76 | 11.76 |
| Capital Expenditure | -3.8 | -9.9 | -56.4 | -77.6 | -31.8 | -48.8 | -61.5 | -77.5 | -97.6 | -123.0 |
| Capital Expenditure, % | -6.39 | -10.29 | -47.17 | -52.01 | -22.73 | -27.72 | -27.72 | -27.72 | -27.72 | -27.72 |
| Tax Rate, % | -422.72 | -422.72 | -422.72 | -422.72 | -422.72 | -422.72 | -422.72 | -422.72 | -422.72 | -422.72 |
| EBITAT | -7.3 | 12.2 | 155.5 | 1.0 | -118.1 | -1.5 | -2.0 | -2.5 | -3.1 | -3.9 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -24.8 | -4.9 | 88.7 | -74.1 | -130.3 | -56.3 | -66.2 | -83.3 | -105.0 | -132.2 |
| WACC, % | 9.39 | 9.68 | 9.68 | 9 | 9.68 | 9.48 | 9.48 | 9.48 | 9.48 | 9.48 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -327.2 | |||||||||
| Long Term Growth Rate, % | 4.00 | |||||||||
| Free cash flow (T + 1) | -138 | |||||||||
| Terminal Value | -2,508 | |||||||||
| Present Terminal Value | -1,594 | |||||||||
| Enterprise Value | -1,921 | |||||||||
| Net Debt | 170 | |||||||||
| Equity Value | -2,091 | |||||||||
| Diluted Shares Outstanding, MM | 63 | |||||||||
| Equity Value Per Share | -33.09 |
What You Will Receive
- Comprehensive Financial Model: Avid Bioservices' actual data supports accurate DCF valuation.
- Complete Forecast Flexibility: Modify revenue growth, profit margins, WACC, and other essential factors.
- Real-Time Calculations: Automatic updates provide immediate feedback as you adjust inputs.
- Professional-Grade Template: A polished Excel file crafted for high-quality valuation presentations.
- Adaptable and Repeatable: Designed for versatility, allowing for ongoing use in detailed forecasting.
Key Features
- Comprehensive Data: Avid Bioservices’ historical financial statements and pre-filled forecasts.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Real-Time Insights: Monitor Avid Bioservices’ intrinsic value recalculating instantly.
- Intuitive Visual Outputs: Dashboard charts present valuation results and essential metrics clearly.
- Designed for Precision: A professional-grade tool for analysts, investors, and finance professionals.
How It Works
- Download: Obtain the ready-to-use Excel file containing Avid Bioservices, Inc.'s (CDMO) financial data.
- Customize: Tailor your forecasts, including revenue growth, EBITDA %, and WACC specifics.
- Update Automatically: Watch as the intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Generate various projections and compare results instantly.
- Make Decisions: Leverage the valuation findings to inform your investment strategy.
Why Choose This Calculator?
- User-Friendly Interface: Perfect for both newcomers and seasoned professionals.
- Customizable Inputs: Easily adjust parameters to tailor your analysis.
- Real-Time Feedback: Watch Avid Bioservices, Inc. (CDMO) valuation change instantly as you modify inputs.
- Preloaded Data: Comes with Avid Bioservices, Inc. (CDMO) actual financial metrics for efficient analysis.
- Widely Recognized: Valued by investors and analysts for making strategic decisions.
Who Should Use This Product?
- Biotech Investors: Gain insights for making informed decisions regarding investments in Avid Bioservices, Inc. (CDMO).
- Financial Analysts: Enhance your analysis with comprehensive financial models tailored for Avid Bioservices, Inc. (CDMO).
- Consultants: Provide clients with accurate and timely valuation assessments of Avid Bioservices, Inc. (CDMO).
- Pharmaceutical Entrepreneurs: Learn how companies like Avid Bioservices, Inc. (CDMO) are valued to shape your business strategy.
- Life Sciences Students: Explore valuation methodologies using real-world examples from Avid Bioservices, Inc. (CDMO).
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Avid Bioservices, Inc. (CDMO) 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 Avid Bioservices, Inc. (CDMO).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.