Draganfly Inc. (DPRO) 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
Draganfly Inc. (DPRO) Bundle
Evaluate Draganfly Inc.'s financial prospects like an expert! This (DPRO) DCF Calculator offers pre-filled financial data and complete flexibility to modify revenue growth, WACC, margins, and other crucial assumptions to align with your forecasts.
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 | 1.0 | 3.0 | 4.9 | 5.3 | 4.6 | 6.3 | 8.8 | 12.2 | 16.9 | 23.5 |
Revenue Growth, % | 0 | 216.1 | 61.66 | 7.81 | -13.81 | 38.92 | 38.92 | 38.92 | 38.92 | 38.92 |
EBITDA | -2.3 | -5.5 | -13.2 | -18.7 | -15.2 | -6.3 | -8.8 | -12.2 | -16.9 | -23.5 |
EBITDA, % | -238.23 | -180.37 | -268.89 | -353.47 | -333.31 | -100 | -100 | -100 | -100 | -100 |
Depreciation | .0 | .1 | .2 | .5 | .4 | .4 | .5 | .7 | 1.0 | 1.4 |
Depreciation, % | 3.6 | 3.5 | 4.41 | 10.16 | 8.34 | 6 | 6 | 6 | 6 | 6 |
EBIT | -2.3 | -5.6 | -13.4 | -19.2 | -15.5 | -6.3 | -8.8 | -12.2 | -16.9 | -23.5 |
EBIT, % | -241.82 | -183.87 | -273.3 | -363.63 | -341.65 | -100 | -100 | -100 | -100 | -100 |
Total Cash | 1.7 | 1.4 | 16.0 | 5.5 | 2.1 | 5.0 | 6.9 | 9.6 | 13.3 | 18.5 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | .2 | .6 | 1.1 | 1.6 | .5 | 1.2 | 1.7 | 2.4 | 3.3 | 4.6 |
Account Receivables, % | 16.28 | 18.58 | 22.64 | 29.69 | 9.91 | 19.42 | 19.42 | 19.42 | 19.42 | 19.42 |
Inventories | .0 | .9 | 2.4 | .7 | 1.1 | 1.5 | 2.1 | 2.9 | 4.0 | 5.6 |
Inventories, % | 3.52 | 28.27 | 48.07 | 13.88 | 24.36 | 23.62 | 23.62 | 23.62 | 23.62 | 23.62 |
Accounts Payable | .5 | .6 | .3 | .5 | .9 | 1.3 | 1.8 | 2.5 | 3.5 | 4.8 |
Accounts Payable, % | 49.86 | 18.65 | 5.14 | 9.88 | 19.22 | 20.55 | 20.55 | 20.55 | 20.55 | 20.55 |
Capital Expenditure | -.1 | .0 | -.1 | -.1 | -.3 | -.2 | -.3 | -.5 | -.6 | -.9 |
Capital Expenditure, % | -6.36 | -0.54745 | -3.01 | -1.11 | -7.48 | -3.7 | -3.7 | -3.7 | -3.7 | -3.7 |
Tax Rate, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
EBITAT | -2.4 | -6.5 | -10.9 | -20.2 | -15.5 | -6.1 | -8.5 | -11.7 | -16.3 | -22.7 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -2.1 | -7.6 | -13.2 | -18.3 | -14.4 | -6.7 | -8.8 | -12.2 | -17.0 | -23.6 |
WACC, % | 11.69 | 11.69 | 11.63 | 11.69 | 11.69 | 11.68 | 11.68 | 11.68 | 11.68 | 11.68 |
PV UFCF | ||||||||||
SUM PV UFCF | -46.3 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -24 | |||||||||
Terminal Value | -249 | |||||||||
Present Terminal Value | -143 | |||||||||
Enterprise Value | -189 | |||||||||
Net Debt | -2 | |||||||||
Equity Value | -188 | |||||||||
Diluted Shares Outstanding, MM | 2 | |||||||||
Equity Value Per Share | -111.33 |
What You Will Get
- Comprehensive DPRO Financials: Access 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 Draganfly's future performance.
- User-Friendly Interface: Designed for experts while remaining approachable for newcomers.
Key Features
- Customizable Financial Metrics: Adjust essential inputs such as revenue projections, profit margins, and investment costs.
- Instant DCF Valuation: Quickly computes intrinsic value, net present value, and additional financial metrics.
- High Precision Results: Leverages Draganfly Inc.'s real-world financial data for accurate valuation assessments.
- Effortless Scenario Analysis: Easily explore various assumptions and evaluate different financial outcomes.
- Efficiency Booster: Remove the hassle of constructing intricate valuation models from the ground up.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Draganfly Inc. (DPRO) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Draganfly Inc.'s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose Draganfly Inc. (DPRO)?
- Innovative Technology: Cutting-edge solutions that lead the industry in drone applications.
- Proven Track Record: Established history of successful deployments and satisfied clients.
- Comprehensive Support: Dedicated customer service to assist you every step of the way.
- Scalable Solutions: Flexible products that grow with your business needs.
- Industry Recognition: A trusted name among professionals in the aerospace and technology sectors.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling Draganfly Inc. (DPRO) stock.
- Financial Analysts: Streamline valuation processes with ready-to-use financial models for Draganfly Inc. (DPRO).
- Consultants: Deliver professional valuation insights on Draganfly Inc. (DPRO) to clients quickly and accurately.
- Business Owners: Understand how innovative companies like Draganfly Inc. (DPRO) are valued to guide your own strategy.
- Finance Students: Learn valuation techniques using real-world data and scenarios involving Draganfly Inc. (DPRO).
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Draganfly Inc. (DPRO) 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 Draganfly Inc. (DPRO).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.