Aurora Cannabis Inc. (ACB) DCF Valuation
- ✓ Completamente Editable: Adáptelo A Sus Necesidades En Excel O Sheets
- ✓ Diseño Profesional: Plantillas Confiables Y Estándares De La Industria
- ✓ Predeterminadas Para Un Uso Rápido Y Eficiente
- ✓ No Se Necesita Experiencia; Fáciles De Seguir
Aurora Cannabis Inc. (ACB) Bundle
Whether you're an investor or analyst, this (ACB) DCF Calculator is your go-to resource for accurate valuation. Loaded with real data from Aurora Cannabis Inc., you can easily adjust forecasts and observe the effects in real-time.
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 | 193.6 | 170.2 | 153.6 | 161.9 | 187.6 | 187.3 | 187.1 | 186.8 | 186.5 | 186.3 |
| Revenue Growth, % | 0 | -12.07 | -9.75 | 5.4 | 15.86 | -0.14029 | -0.14029 | -0.14029 | -0.14029 | -0.14029 |
| EBITDA | -272.9 | -95.2 | -99.3 | -146.3 | 14.2 | -113.6 | -113.5 | -113.3 | -113.2 | -113.0 |
| EBITDA, % | -140.99 | -55.94 | -64.65 | -90.34 | 7.58 | -60.67 | -60.67 | -60.67 | -60.67 | -60.67 |
| Depreciation | 79.7 | 68.1 | 65.0 | 30.2 | 23.0 | 57.8 | 57.8 | 57.7 | 57.6 | 57.5 |
| Depreciation, % | 41.19 | 39.99 | 42.32 | 18.68 | 12.24 | 30.88 | 30.88 | 30.88 | 30.88 | 30.88 |
| EBIT | -352.6 | -163.3 | -164.3 | -176.5 | -8.7 | -150.1 | -149.9 | -149.7 | -149.4 | -149.2 |
| EBIT, % | -182.18 | -95.93 | -106.96 | -109.01 | -4.66 | -80.12 | -80.12 | -80.12 | -80.12 | -80.12 |
| Total Cash | 117.5 | 295.1 | 304.8 | 208.8 | 81.5 | 151.4 | 151.2 | 151.0 | 150.8 | 150.6 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 37.6 | 39.2 | 32.7 | 28.7 | 31.5 | 36.8 | 36.7 | 36.7 | 36.6 | 36.6 |
| Account Receivables, % | 19.4 | 23.03 | 21.26 | 17.72 | 16.8 | 19.64 | 19.64 | 19.64 | 19.64 | 19.64 |
| Inventories | 109.1 | 95.6 | 97.1 | 89.4 | 129.3 | 112.4 | 112.2 | 112.1 | 111.9 | 111.7 |
| Inventories, % | 56.39 | 56.15 | 63.22 | 55.22 | 68.96 | 59.99 | 59.99 | 59.99 | 59.99 | 59.99 |
| Accounts Payable | 66.3 | 9.2 | 9.6 | 15.2 | 14.1 | 23.6 | 23.5 | 23.5 | 23.5 | 23.4 |
| Accounts Payable, % | 34.27 | 5.41 | 6.26 | 9.41 | 7.52 | 12.57 | 12.57 | 12.57 | 12.57 | 12.57 |
| Capital Expenditure | -246.4 | -36.8 | -22.4 | -8.4 | -11.8 | -55.3 | -55.2 | -55.2 | -55.1 | -55.0 |
| Capital Expenditure, % | -127.29 | -21.64 | -14.55 | -5.2 | -6.27 | -29.53 | -29.53 | -29.53 | -29.53 | -29.53 |
| Tax Rate, % | -16.32 | -16.32 | -16.32 | -16.32 | -16.32 | -16.32 | -16.32 | -16.32 | -16.32 | -16.32 |
| EBITAT | -345.0 | -161.8 | -164.1 | -158.5 | -10.2 | -146.1 | -145.9 | -145.6 | -145.4 | -145.2 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -592.0 | -175.8 | -116.0 | -119.4 | -42.9 | -122.4 | -143.2 | -143.0 | -142.8 | -142.6 |
| WACC, % | 16.14 | 16.19 | 16.22 | 15.86 | 16.22 | 16.13 | 16.13 | 16.13 | 16.13 | 16.13 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -448.8 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -145 | |||||||||
| Terminal Value | -1,029 | |||||||||
| Present Terminal Value | -487 | |||||||||
| Enterprise Value | -936 | |||||||||
| Net Debt | -6 | |||||||||
| Equity Value | -930 | |||||||||
| Diluted Shares Outstanding, MM | 47 | |||||||||
| Equity Value Per Share | -19.62 |
What You Will Get
- Real ACB Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Dynamic Calculations: Intrinsic value and NPV are computed automatically.
- Scenario Analysis: Evaluate various scenarios to assess Aurora’s future performance.
- User-Friendly Design: Crafted for professionals but easy for beginners to navigate.
Key Features
- Comprehensive Data: Aurora Cannabis Inc.'s (ACB) historical financial statements and pre-populated forecasts.
- Customizable Parameters: Adjust WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Real-Time Insights: Monitor Aurora's (ACB) intrinsic value recalculating instantly.
- Visual Analytics: Interactive dashboard charts present valuation results and essential metrics.
- Designed for Precision: A professional-grade tool tailored for analysts, investors, and finance professionals.
How It Works
- 1. Access the Template: Download and open the Excel file containing Aurora Cannabis Inc. (ACB)'s preloaded data.
- 2. Modify Assumptions: Adjust key inputs such as growth rates, WACC, and capital expenditures.
- 3. Analyze Results Instantly: The DCF model automatically calculates intrinsic value and NPV.
- 4. Explore Scenarios: Evaluate various forecasts to assess different valuation outcomes.
- 5. Present with Assurance: Share professional valuation insights to enhance your decision-making process.
Why Choose This Calculator for Aurora Cannabis Inc. (ACB)?
- All-in-One Solution: Features DCF, WACC, and financial ratio analyses tailored for the cannabis industry.
- Flexible Inputs: Modify yellow-highlighted cells to explore different investment scenarios.
- In-Depth Analysis: Automatically computes Aurora’s intrinsic value and Net Present Value.
- Integrated Data: Access historical and projected data for reliable analysis.
- High-Quality Standards: Perfect for financial analysts, investors, and cannabis industry consultants.
Who Should Use This Product?
- Investors: Accurately estimate Aurora Cannabis Inc.’s (ACB) fair value before making investment decisions.
- CFOs: Leverage a professional-grade DCF model for financial reporting and analysis related to Aurora Cannabis Inc. (ACB).
- Consultants: Quickly adapt the template for valuation reports tailored to clients interested in Aurora Cannabis Inc. (ACB).
- Entrepreneurs: Gain insights into financial modeling techniques used by leading companies in the cannabis industry, including Aurora Cannabis Inc. (ACB).
- Educators: Use it as a teaching tool to demonstrate valuation methodologies applicable to companies like Aurora Cannabis Inc. (ACB).
What the Template Contains
- Preloaded ACB Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
- DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
- Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.