Arbutus Biopharma Corporation (ABUS) DCF Valuation
- ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
- ✓ Design Profissional: Modelos Confiáveis E Padrão Da Indústria
- ✓ Pré-Construídos Para Uso Rápido E Eficiente
- ✓ Não É Necessária Experiência; Fácil De Seguir
Arbutus Biopharma Corporation (ABUS) Bundle
Evaluate Arbutus Biopharma Corporation's (ABUS) financial outlook like an expert! This (ABUS) DCF Calculator provides you with pre-filled financial data and the flexibility to modify revenue growth, WACC, margins, and other critical assumptions to align with your 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 | 6.0 | 6.9 | 11.0 | 39.0 | 18.1 | 23.6 | 30.7 | 40.0 | 52.0 | 67.6 |
Revenue Growth, % | 0 | 15.02 | 58.92 | 255.11 | -53.51 | 30.11 | 30.11 | 30.11 | 30.11 | 30.11 |
EBITDA | -147.3 | -57.8 | -71.6 | -61.9 | -71.0 | -23.6 | -30.7 | -40.0 | -52.0 | -67.6 |
EBITDA, % | -2450.86 | -836.07 | -651.96 | -158.54 | -391.3 | -100 | -100 | -100 | -100 | -100 |
Depreciation | 2.0 | 2.0 | 1.8 | 1.4 | 1.4 | 4.2 | 5.5 | 7.2 | 9.3 | 12.1 |
Depreciation, % | 33.74 | 28.61 | 15.95 | 3.66 | 7.74 | 17.94 | 17.94 | 17.94 | 17.94 | 17.94 |
EBIT | -149.3 | -59.8 | -73.4 | -63.3 | -72.4 | -23.6 | -30.7 | -40.0 | -52.0 | -67.6 |
EBIT, % | -2484.59 | -864.68 | -667.91 | -162.19 | -399.04 | -100 | -100 | -100 | -100 | -100 |
Total Cash | 90.8 | 123.3 | 155.3 | 146.9 | 126.0 | 23.6 | 30.7 | 40.0 | 52.0 | 67.6 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 1.2 | 1.3 | .9 | 1.4 | 1.8 | 2.9 | 3.7 | 4.8 | 6.3 | 8.2 |
Account Receivables, % | 20.03 | 18.98 | 8.18 | 3.46 | 9.79 | 12.09 | 12.09 | 12.09 | 12.09 | 12.09 |
Inventories | .0 | -3.1 | -4.4 | -2.9 | .0 | -4.4 | -5.7 | -7.4 | -9.7 | -12.6 |
Inventories, % | 0 | -45.18 | -40.45 | -7.37 | 0 | -18.6 | -18.6 | -18.6 | -18.6 | -18.6 |
Accounts Payable | 2.4 | 3.0 | 3.2 | 3.5 | 3.2 | 6.6 | 8.5 | 11.1 | 14.4 | 18.8 |
Accounts Payable, % | 39.89 | 43.3 | 28.89 | 9.02 | 17.77 | 27.77 | 27.77 | 27.77 | 27.77 | 27.77 |
Capital Expenditure | -.6 | -.2 | -.8 | -.5 | -1.0 | -1.3 | -1.7 | -2.2 | -2.8 | -3.7 |
Capital Expenditure, % | -9.8 | -3.31 | -7.36 | -1.31 | -5.56 | -5.47 | -5.47 | -5.47 | -5.47 | -5.47 |
Tax Rate, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
EBITAT | -138.0 | -61.2 | -74.5 | -67.6 | -72.4 | -23.2 | -30.2 | -39.3 | -51.2 | -66.6 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -135.4 | -55.8 | -71.6 | -68.4 | -75.6 | -13.7 | -24.0 | -31.2 | -40.6 | -52.8 |
WACC, % | 13.35 | 13.36 | 13.36 | 13.36 | 13.36 | 13.36 | 13.36 | 13.36 | 13.36 | 13.36 |
PV UFCF | ||||||||||
SUM PV UFCF | -104.9 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -54 | |||||||||
Terminal Value | -474 | |||||||||
Present Terminal Value | -253 | |||||||||
Enterprise Value | -358 | |||||||||
Net Debt | -18 | |||||||||
Equity Value | -341 | |||||||||
Diluted Shares Outstanding, MM | 166 | |||||||||
Equity Value Per Share | -2.05 |
What You Will Receive
- Comprehensive Financial Model: Leverage Arbutus Biopharma's actual data for accurate DCF valuation.
- Complete Forecasting Flexibility: Modify revenue growth, profit margins, WACC, and other critical 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 Reusable: Designed for versatility, allowing ongoing use for in-depth forecasting.
Key Features
- 🔍 Real-Life ABUS Financials: Pre-filled historical and projected data for Arbutus Biopharma Corporation (ABUS).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Arbutus Biopharma’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Arbutus Biopharma’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Step 1: Download the prebuilt Excel template containing Arbutus Biopharma Corporation’s (ABUS) data.
- Step 2: Navigate through 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 see the recalculated results, including Arbutus Biopharma Corporation’s (ABUS) intrinsic value.
- Step 5: Utilize the outputs to make informed investment decisions or create comprehensive reports.
Why Choose This Calculator?
- Accuracy: Utilizes authentic Arbutus Biopharma financials to guarantee data precision.
- Flexibility: Built for users to easily experiment and adjust inputs as needed.
- Time-Saving: Avoid the complexities of constructing a DCF model from the ground up.
- Professional-Grade: Crafted with the expertise and usability expected at the CFO level.
- User-Friendly: Intuitive design makes it accessible for users with varying levels of financial modeling skills.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and accurate valuation models for analyzing Arbutus Biopharma Corporation (ABUS).
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the organization.
- Consultants and Advisors: Offer clients precise valuation insights related to Arbutus Biopharma Corporation (ABUS) stock.
- Students and Educators: Utilize real-time data to enhance learning and practice in financial modeling.
- Biotech Enthusiasts: Gain insights into how biotech firms like Arbutus Biopharma Corporation (ABUS) are valued in the market.
What the Template Contains
- Pre-Filled DCF Model: Arbutus Biopharma Corporation’s (ABUS) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Arbutus Biopharma Corporation’s profitability, leverage, and efficiency.
- Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
- Financial Statements: Annual and quarterly reports to support detailed analysis.
- Interactive Dashboard: Easily visualize key valuation metrics and results.