Canopy Growth Corporation (CGC) 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
Canopy Growth Corporation (CGC) Bundle
Evaluate Canopy Growth Corporation's financial outlook like an expert! This (CGC) DCF Calculator provides pre-filled financial data and offers full flexibility to modify revenue growth, WACC, margins, and other essential assumptions to align with your predictions.
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 | 276.7 | 379.4 | 361.1 | 279.6 | 206.2 | 197.7 | 189.5 | 181.7 | 174.1 | 166.9 |
| Revenue Growth, % | 0 | 37.08 | -4.82 | -22.57 | -26.25 | -4.14 | -4.14 | -4.14 | -4.14 | -4.14 |
| EBITDA | -911.1 | -1,038.0 | -84.1 | -1,998.6 | -217.1 | -167.3 | -160.4 | -153.8 | -147.4 | -141.3 |
| EBITDA, % | -329.24 | -273.62 | -23.28 | -714.8 | -105.28 | -84.66 | -84.66 | -84.66 | -84.66 | -84.66 |
| Depreciation | 86.8 | 88.2 | 79.4 | 55.5 | 36.9 | 45.2 | 43.3 | 41.5 | 39.8 | 38.2 |
| Depreciation, % | 31.35 | 23.25 | 21.99 | 19.86 | 17.9 | 22.87 | 22.87 | 22.87 | 22.87 | 22.87 |
| EBIT | -997.9 | -1,126.2 | -163.5 | -2,054.2 | -254.0 | -176.0 | -168.8 | -161.8 | -155.1 | -148.7 |
| EBIT, % | -360.59 | -296.88 | -45.27 | -734.67 | -123.17 | -89.05 | -89.05 | -89.05 | -89.05 | -89.05 |
| Total Cash | 1,371.6 | 1,595.6 | 951.9 | 543.1 | 141.2 | 185.2 | 177.6 | 170.2 | 163.2 | 156.4 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 62.6 | 64.1 | 47.3 | 47.5 | 31.2 | 33.5 | 32.1 | 30.8 | 29.5 | 28.3 |
| Account Receivables, % | 22.61 | 16.91 | 13.11 | 16.99 | 15.12 | 16.95 | 16.95 | 16.95 | 16.95 | 16.95 |
| Inventories | 271.4 | 255.4 | 141.8 | 103.3 | 53.6 | 105.8 | 101.4 | 97.2 | 93.2 | 89.4 |
| Inventories, % | 98.07 | 67.32 | 39.28 | 36.96 | 26.01 | 53.53 | 53.53 | 53.53 | 53.53 | 53.53 |
| Accounts Payable | 85.6 | 46.7 | 44.6 | 22.1 | 19.9 | 28.9 | 27.7 | 26.6 | 25.5 | 24.4 |
| Accounts Payable, % | 30.94 | 12.3 | 12.35 | 7.9 | 9.65 | 14.63 | 14.63 | 14.63 | 14.63 | 14.63 |
| Capital Expenditure | -501.0 | -120.8 | -33.4 | -7.3 | -2.8 | -57.4 | -55.0 | -52.7 | -50.5 | -48.4 |
| Capital Expenditure, % | -181.03 | -31.86 | -9.25 | -2.62 | -1.34 | -29.01 | -29.01 | -29.01 | -29.01 | -29.01 |
| Tax Rate, % | -39.44 | -39.44 | -39.44 | -39.44 | -39.44 | -39.44 | -39.44 | -39.44 | -39.44 | -39.44 |
| EBITAT | -917.5 | -1,117.4 | -159.0 | -2,051.2 | -354.2 | -171.9 | -164.8 | -158.0 | -151.5 | -145.2 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -1,580.0 | -1,174.6 | 15.2 | -1,987.2 | -256.2 | -229.5 | -171.9 | -164.8 | -158.0 | -151.4 |
| WACC, % | 13.99 | 14.78 | 14.57 | 14.85 | 14.87 | 14.61 | 14.61 | 14.61 | 14.61 | 14.61 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -608.7 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -154 | |||||||||
| Terminal Value | -1,225 | |||||||||
| Present Terminal Value | -619 | |||||||||
| Enterprise Value | -1,228 | |||||||||
| Net Debt | 345 | |||||||||
| Equity Value | -1,573 | |||||||||
| Diluted Shares Outstanding, MM | 75 | |||||||||
| Equity Value Per Share | -21.04 |
What You Will Get
- Real Canopy Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Canopy Growth Corporation (CGC).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates to fit your analysis.
- Instant Valuation Updates: Automatic recalculations to assess the impact of changes on Canopy Growth's fair value.
- Versatile Excel Template: Designed for quick edits, scenario testing, and detailed projections specific to Canopy Growth Corporation (CGC).
- Time-Saving and Accurate: Eliminate the need to build models from scratch while ensuring precision and flexibility.
Key Features
- Comprehensive Historical Data: Canopy Growth Corporation’s (CGC) past financial statements and projected forecasts included.
- Customizable Inputs: Modify WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Real-Time Results: Watch Canopy Growth Corporation’s (CGC) intrinsic value update instantly.
- Visual Performance Metrics: Interactive dashboard charts illustrate valuation outcomes and essential metrics.
- Designed for Precision: A robust tool tailored for analysts, investors, and finance professionals.
How It Works
- Step 1: Download the prebuilt Excel template containing Canopy Growth Corporation’s (CGC) 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 recalibrated results, including Canopy Growth Corporation’s (CGC) intrinsic value.
- Step 5: Make well-informed investment choices or create reports based on the outputs.
Why Choose This Calculator for Canopy Growth Corporation (CGC)?
- Designed for Industry Experts: A sophisticated tool tailored for analysts, investors, and financial advisors.
- Up-to-Date Data: Canopy Growth's historical and projected financials are preloaded for precise analysis.
- Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
- Comprehensive Outputs: Automatically computes intrinsic value, NPV, and essential financial metrics.
- User-Friendly Interface: Step-by-step guidance makes the process straightforward.
Who Should Use This Product?
- Investors: Accurately assess Canopy Growth Corporation’s (CGC) fair value before making investment choices.
- CFOs: Utilize a professional-grade DCF model for financial reporting and analysis specific to Canopy Growth Corporation (CGC).
- Consultants: Efficiently modify the template for valuation reports tailored to Canopy Growth Corporation (CGC) clients.
- Entrepreneurs: Acquire insights into financial modeling practices employed by leading companies in the cannabis industry, including Canopy Growth Corporation (CGC).
- Educators: Implement it as a teaching resource to illustrate valuation techniques relevant to Canopy Growth Corporation (CGC).
What the Template Contains
- Pre-Filled Data: Includes Canopy Growth Corporation’s historical financials and forecasts.
- 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 Canopy Growth Corporation’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.