Golden Minerals Company (AUMN) 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
Golden Minerals Company (AUMN) Bundle
Optimize your time and improve precision with our (AUMN) DCF Calculator! Equipped with up-to-date Golden Minerals Company data and customizable assumptions, this tool allows you to forecast, analyze, and evaluate (AUMN) just like a seasoned investor.
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 | 7.7 | 5.6 | 25.6 | 23.3 | 12.0 | 12.5 | 12.9 | 13.4 | 14.0 | 14.5 |
| Revenue Growth, % | 0 | -27.08 | 354.07 | -9.03 | -48.46 | 3.86 | 3.86 | 3.86 | 3.86 | 3.86 |
| EBITDA | -4.0 | -7.7 | -.4 | -9.2 | -8.4 | -6.6 | -6.8 | -7.1 | -7.3 | -7.6 |
| EBITDA, % | -52.07 | -136.51 | -1.51 | -39.32 | -69.91 | -52.56 | -52.56 | -52.56 | -52.56 | -52.56 |
| Depreciation | 1.3 | 1.2 | .9 | .7 | .8 | 1.3 | 1.3 | 1.4 | 1.4 | 1.5 |
| Depreciation, % | 17.15 | 21.48 | 3.41 | 2.8 | 6.89 | 10.35 | 10.35 | 10.35 | 10.35 | 10.35 |
| EBIT | -5.4 | -8.9 | -1.3 | -9.8 | -9.2 | -7.3 | -7.6 | -7.9 | -8.2 | -8.5 |
| EBIT, % | -69.22 | -157.99 | -4.92 | -42.12 | -76.8 | -58.61 | -58.61 | -58.61 | -58.61 | -58.61 |
| Total Cash | 4.6 | 9.8 | 12.3 | 3.8 | 3.8 | 6.4 | 6.6 | 6.9 | 7.1 | 7.4 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | .4 | .3 | 1.3 | .0 | 3.1 | 1.1 | 1.1 | 1.1 | 1.2 | 1.2 |
| Account Receivables, % | 5.8 | 5.62 | 4.91 | 0 | 26.12 | 8.49 | 8.49 | 8.49 | 8.49 | 8.49 |
| Inventories | .2 | .3 | 1.6 | 1.4 | .8 | .7 | .7 | .7 | .8 | .8 |
| Inventories, % | 2.99 | 5.04 | 6.15 | 5.89 | 6.92 | 5.4 | 5.4 | 5.4 | 5.4 | 5.4 |
| Accounts Payable | .7 | .5 | 1.5 | 1.8 | 2.5 | 1.3 | 1.3 | 1.4 | 1.4 | 1.5 |
| Accounts Payable, % | 9.18 | 8.37 | 5.86 | 7.65 | 20.71 | 10.36 | 10.36 | 10.36 | 10.36 | 10.36 |
| Capital Expenditure | .0 | -.5 | -1.6 | -.1 | .0 | -.4 | -.4 | -.4 | -.4 | -.4 |
| Capital Expenditure, % | -0.49159 | -8.34 | -6.33 | -0.22332 | 0 | -3.08 | -3.08 | -3.08 | -3.08 | -3.08 |
| Tax Rate, % | -0.11934 | -0.11934 | -0.11934 | -0.11934 | -0.11934 | -0.11934 | -0.11934 | -0.11934 | -0.11934 | -0.11934 |
| EBITAT | -5.4 | -9.0 | -1.6 | -9.9 | -9.2 | -7.3 | -7.6 | -7.9 | -8.2 | -8.5 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -4.1 | -8.4 | -3.6 | -7.6 | -10.3 | -5.4 | -6.7 | -6.9 | -7.2 | -7.5 |
| WACC, % | 5.4 | 5.4 | 5.4 | 5.4 | 5.4 | 5.4 | 5.4 | 5.4 | 5.4 | 5.4 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -28.6 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -8 | |||||||||
| Terminal Value | -224 | |||||||||
| Present Terminal Value | -172 | |||||||||
| Enterprise Value | -201 | |||||||||
| Net Debt | -3 | |||||||||
| Equity Value | -197 | |||||||||
| Diluted Shares Outstanding, MM | 9 | |||||||||
| Equity Value Per Share | -23.07 |
What You Will Get
- Editable Forecast Inputs: Easily modify assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: Golden Minerals Company's (AUMN) financial data pre-filled to kickstart your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically.
- Customizable and Professional: A refined Excel model that adjusts to your valuation requirements.
- Built for Analysts and Investors: Perfect for testing forecasts, validating strategies, and enhancing efficiency.
Key Features
- Comprehensive AUMN Data: Pre-populated with Golden Minerals Company's historical performance and future forecasts.
- Customizable Financial Inputs: Modify assumptions for revenue growth, profit margins, discount rates, tax implications, and capital investments.
- Adaptive Valuation Framework: Instant updates to Net Present Value (NPV) and intrinsic value in response to your adjustments.
- Scenario Analysis: Develop various projection scenarios to evaluate different valuation possibilities.
- Intuitive Interface: Designed for ease of use, suitable for both seasoned professionals and newcomers.
How It Works
- Download the Template: Get instant access to the Excel-based AUMN Valuation Calculator.
- Input Your Assumptions: Adjust the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
- Instant Calculations: The model automatically updates Golden Minerals Company's intrinsic value.
- Test Scenarios: Simulate various assumptions to assess potential changes in valuation.
- Analyze and Decide: Utilize the results to inform your investment or financial analysis.
Why Choose This Calculator for Golden Minerals Company (AUMN)?
- Accurate Data: Utilize real Golden Minerals financials for dependable valuation outcomes.
- Customizable: Modify essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Pre-configured calculations save you the effort of building from the ground up.
- Professional-Grade Tool: Tailored for the needs of investors, analysts, and consultants.
- User-Friendly: A straightforward design and guided instructions ensure accessibility for all users.
Who Should Use This Product?
- Mining Investors: Develop comprehensive and accurate valuation models for investment analysis in Golden Minerals Company (AUMN).
- 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 Golden Minerals Company (AUMN).
- Students and Educators: Utilize real-world data to enhance learning and practice in financial modeling related to mining companies.
- Resource Sector Enthusiasts: Gain insights into how mining companies like Golden Minerals Company (AUMN) are valued in the market.
What the Template Contains
- Historical Data: Includes Golden Minerals Company's (AUMN) past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Golden Minerals Company's (AUMN) intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
- Quarterly and Annual Statements: A complete breakdown of Golden Minerals Company's (AUMN) financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.