Edesa Biotech, Inc. (EDSA) 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
Edesa Biotech, Inc. (EDSA) Bundle
Explore Edesa Biotech, Inc. (EDSA) financial future with our user-friendly DCF Calculator! Enter your projections for growth, margins, and expenses to calculate the intrinsic value of Edesa Biotech, Inc. (EDSA) and refine your investment strategy.
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 | .3 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Revenue Growth, % | 0 | -100 | 0 | 0 | 0 | -25 | -25 | -25 | -25 | -25 |
| EBITDA | -6.3 | -13.2 | -17.4 | -8.2 | -6.1 | .0 | .0 | .0 | .0 | .0 |
| EBITDA, % | -1929.83 | 100 | 100 | 100 | 100 | 60 | 60 | 60 | 60 | 60 |
| Depreciation | .1 | .1 | .1 | .2 | .2 | .0 | .0 | .0 | .0 | .0 |
| Depreciation, % | 17.51 | 100 | 100 | 100 | 100 | 83.5 | 83.5 | 83.5 | 83.5 | 83.5 |
| EBIT | -6.4 | -13.3 | -17.5 | -8.4 | -6.3 | .0 | .0 | .0 | .0 | .0 |
| EBIT, % | -1947.33 | 100 | 100 | 100 | 100 | 60 | 60 | 60 | 60 | 60 |
| Total Cash | 7.2 | 7.8 | 7.1 | 5.4 | 1.0 | .0 | .0 | .0 | .0 | .0 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | .1 | 3.3 | 1.3 | .6 | .3 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables, % | 26.6 | 100 | 100 | 100 | 100 | 85.32 | 85.32 | 85.32 | 85.32 | 85.32 |
| Inventories | -.1 | .0 | -1.3 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Inventories, % | -26.6 | 100 | 100 | 100 | 100 | 74.68 | 74.68 | 74.68 | 74.68 | 74.68 |
| Accounts Payable | 1.5 | 1.4 | 2.1 | 1.7 | .0 | .0 | .0 | .0 | .0 | .0 |
| Accounts Payable, % | 444.08 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |
| Capital Expenditure | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Capital Expenditure, % | -10.44 | 100 | 100 | 100 | 100 | -2.09 | -2.09 | -2.09 | -2.09 | -2.09 |
| Tax Rate, % | -0.01296755 | -0.01296755 | -0.01296755 | -0.01296755 | -0.01296755 | -0.01296755 | -0.01296755 | -0.01296755 | -0.01296755 | -0.01296755 |
| EBITAT | -6.4 | -13.3 | -17.5 | -8.4 | -6.3 | .0 | .0 | .0 | .0 | .0 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -4.9 | -16.6 | -13.4 | -9.2 | -7.5 | .3 | .0 | .0 | .0 | .0 |
| WACC, % | 8.39 | 8.39 | 8.39 | 8.39 | 8.39 | 8.39 | 8.39 | 8.39 | 8.39 | 8.39 |
| PV UFCF | ||||||||||
| SUM PV UFCF | .2 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 0 | |||||||||
| Terminal Value | 0 | |||||||||
| Present Terminal Value | 0 | |||||||||
| Enterprise Value | 0 | |||||||||
| Net Debt | -1 | |||||||||
| Equity Value | 1 | |||||||||
| Diluted Shares Outstanding, MM | 3 | |||||||||
| Equity Value Per Share | 0.40 |
What You Will Get
- Editable Forecast Inputs: Easily adjust key assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: Edesa Biotech, Inc. (EDSA) financial data pre-loaded to facilitate your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value for you.
- Customizable and Professional: A refined Excel model that caters to your valuation requirements.
- Built for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and enhancing efficiency.
Key Features
- Comprehensive Historical Data: Edesa Biotech’s past financial statements and pre-populated projections.
- Customizable Parameters: Adjust WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Real-Time Insights: Monitor Edesa Biotech’s intrinsic value recalculating instantly.
- Intuitive Visualizations: Dashboard graphs illustrate valuation outcomes and essential metrics.
- Designed for Precision: A professional-grade tool for analysts, investors, and finance professionals.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Edesa Biotech data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Edesa Biotech’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for Edesa Biotech, Inc. (EDSA)?
- Accuracy: Utilizes real Edesa financial data for precise calculations.
- Flexibility: Allows users to easily adjust and test various input parameters.
- Time-Saving: Eliminates the need to create a DCF model from the ground up.
- Professional-Grade: Crafted with the expertise and precision expected at the CFO level.
- User-Friendly: Intuitive design makes it accessible for users with varying levels of financial knowledge.
Who Should Use This Product?
- Investors: Evaluate Edesa Biotech's valuation before making investment decisions.
- CFOs and Financial Analysts: Enhance valuation methodologies and assess financial forecasts.
- Startup Founders: Understand the valuation processes of biotech companies like Edesa Biotech.
- Consultants: Provide detailed valuation analyses and reports for clients in the biotech sector.
- Students and Educators: Utilize current market data to learn and teach valuation strategies.
What the Template Contains
- Historical Data: Includes Edesa Biotech’s past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Edesa Biotech’s intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
- Quarterly and Annual Statements: A complete breakdown of Edesa Biotech’s financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.