Avino Silver & Gold Mines Ltd. (ASM) DCF Valuation
- ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
- ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
- ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
- ✓ Aucune Expertise N'Est Requise; Facile À Suivre
Avino Silver & Gold Mines Ltd. (ASM) Bundle
Discover the true potential of Avino Silver & Gold Mines Ltd. (ASM) with our premium DCF Calculator! Adjust key assumptions, explore various scenarios, and assess how different changes influence Avino's valuation – all within one convenient Excel template.
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 | 31.7 | 16.0 | 11.2 | 44.2 | 43.9 | 46.1 | 48.4 | 50.8 | 53.3 | 55.9 |
Revenue Growth, % | 0 | -49.53 | -29.92 | 293.54 | -0.67441 | 4.97 | 4.97 | 4.97 | 4.97 | 4.97 |
EBITDA | 1.0 | -6.8 | .5 | 9.9 | 2.8 | -.5 | -.6 | -.6 | -.6 | -.6 |
EBITDA, % | 3.21 | -42.34 | 4.65 | 22.35 | 6.36 | -1.16 | -1.16 | -1.16 | -1.16 | -1.16 |
Depreciation | 3.9 | 2.3 | 2.1 | 2.1 | 2.9 | 5.3 | 5.6 | 5.8 | 6.1 | 6.4 |
Depreciation, % | 12.34 | 14.52 | 19.09 | 4.85 | 6.65 | 11.49 | 11.49 | 11.49 | 11.49 | 11.49 |
EBIT | -2.9 | -9.1 | -1.6 | 7.7 | -.1 | -5.8 | -6.1 | -6.4 | -6.7 | -7.1 |
EBIT, % | -9.12 | -56.87 | -14.45 | 17.5 | -0.29392 | -12.65 | -12.65 | -12.65 | -12.65 | -12.65 |
Total Cash | 9.6 | 11.7 | 24.8 | 11.2 | 2.7 | 21.7 | 22.7 | 23.9 | 25.0 | 26.3 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 7.0 | 5.6 | 4.6 | 2.7 | 10.0 | 11.6 | 12.2 | 12.8 | 13.5 | 14.1 |
Account Receivables, % | 21.92 | 34.78 | 40.72 | 6.05 | 22.78 | 25.25 | 25.25 | 25.25 | 25.25 | 25.25 |
Inventories | 5.6 | 1.7 | 5.2 | 6.3 | 8.8 | 10.0 | 10.5 | 11.0 | 11.5 | 12.1 |
Inventories, % | 17.61 | 10.35 | 46.13 | 14.17 | 20.11 | 21.67 | 21.67 | 21.67 | 21.67 | 21.67 |
Accounts Payable | 4.9 | 2.1 | 3.1 | 9.5 | 11.7 | 9.6 | 10.0 | 10.5 | 11.0 | 11.6 |
Accounts Payable, % | 15.46 | 12.91 | 27.27 | 21.43 | 26.61 | 20.73 | 20.73 | 20.73 | 20.73 | 20.73 |
Capital Expenditure | -3.3 | -2.0 | -1.9 | -7.8 | -7.4 | -6.9 | -7.2 | -7.6 | -7.9 | -8.3 |
Capital Expenditure, % | -10.32 | -12.57 | -17.04 | -17.73 | -16.8 | -14.89 | -14.89 | -14.89 | -14.89 | -14.89 |
Tax Rate, % | 206.27 | 206.27 | 206.27 | 206.27 | 206.27 | 206.27 | 206.27 | 206.27 | 206.27 | 206.27 |
EBITAT | -2.3 | -7.7 | -2.1 | 3.1 | .1 | -3.5 | -3.7 | -3.9 | -4.1 | -4.3 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -9.3 | -4.9 | -3.4 | 4.6 | -12.0 | -10.0 | -6.0 | -6.2 | -6.6 | -6.9 |
WACC, % | 13.85 | 13.87 | 13.94 | 13.69 | 13.53 | 13.78 | 13.78 | 13.78 | 13.78 | 13.78 |
PV UFCF | ||||||||||
SUM PV UFCF | -25.2 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -7 | |||||||||
Terminal Value | -60 | |||||||||
Present Terminal Value | -31 | |||||||||
Enterprise Value | -56 | |||||||||
Net Debt | 1 | |||||||||
Equity Value | -57 | |||||||||
Diluted Shares Outstanding, MM | 125 | |||||||||
Equity Value Per Share | -0.46 |
What You Will Get
- Real ASM Financial Data: Pre-filled with Avino Silver & Gold Mines Ltd.'s historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See ASM's intrinsic value update instantly based on your changes.
- Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
- User-Friendly Design: Simple structure and clear instructions for all experience levels.
Key Features
- Customizable Mining Parameters: Adjust essential inputs such as silver and gold prices, production costs, and resource estimates.
- Instant DCF Valuation: Quickly computes intrinsic value, NPV, and other financial metrics.
- High-Precision Accuracy: Incorporates Avino’s actual financial data for reliable valuation results.
- Effortless Scenario Analysis: Explore various assumptions and evaluate different outcomes with ease.
- Efficiency Booster: Streamline the valuation process without the need for complex model creation.
How It Works
- Download the Template: Gain immediate access to the Excel-based ASM DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
- Instant Calculations: The model automatically recalculates Avino Silver & Gold Mines Ltd.'s intrinsic value.
- Test Scenarios: Experiment with different assumptions to assess potential valuation shifts.
- Analyze and Decide: Leverage the results to inform your investment or financial analysis.
Why Choose This Calculator for Avino Silver & Gold Mines Ltd. (ASM)?
- User-Friendly Interface: Tailored for both novice users and seasoned professionals.
- Customizable Inputs: Adjust parameters easily to suit your financial analysis needs.
- Real-Time Valuation: Observe immediate updates to Avino's valuation as you change the inputs.
- Preloaded Data: Comes with Avino’s latest financial figures for swift evaluations.
- Endorsed by Experts: Favored by investors and analysts for making well-informed decisions.
Who Should Use This Product?
- Mining Investors: Develop comprehensive and accurate valuation models for analyzing Avino Silver & Gold Mines Ltd. (ASM).
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the mining sector.
- Consultants and Advisors: Deliver precise valuation insights for clients interested in Avino Silver & Gold Mines Ltd. (ASM).
- Students and Educators: Utilize real-world mining data to practice and teach financial modeling techniques.
- Resource Sector Enthusiasts: Gain insights into how mining companies like Avino Silver & Gold Mines Ltd. (ASM) are valued in the market.
What the Template Contains
- Pre-Filled DCF Model: Avino Silver & Gold Mines Ltd.'s (ASM) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Avino Silver & Gold Mines Ltd.'s (ASM) 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.