Fortuna Silver Mines Inc. (FSM) 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
Fortuna Silver Mines Inc. (FSM) Bundle
Explore Fortuna Silver Mines Inc. (FSM)'s financial outlook with our user-friendly DCF Calculator! Enter your projections for growth, margins, and expenses to calculate the intrinsic value of Fortuna Silver Mines Inc. (FSM) and enhance your investment approach.
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 | 257.2 | 279.0 | 599.9 | 681.5 | 842.4 | 1,149.3 | 1,567.9 | 2,138.9 | 2,918.0 | 3,980.8 |
Revenue Growth, % | 0 | 8.47 | 115.03 | 13.61 | 23.62 | 36.42 | 36.42 | 36.42 | 36.42 | 36.42 |
EBITDA | 94.2 | 106.6 | 277.8 | 59.2 | 230.8 | 361.4 | 493.0 | 672.6 | 917.6 | 1,251.8 |
EBITDA, % | 36.63 | 38.22 | 46.31 | 8.68 | 27.4 | 31.45 | 31.45 | 31.45 | 31.45 | 31.45 |
Depreciation | 47.7 | 48.6 | 125.0 | 168.2 | 219.7 | 247.2 | 337.3 | 460.1 | 627.7 | 856.3 |
Depreciation, % | 18.54 | 17.42 | 20.83 | 24.69 | 26.08 | 21.51 | 21.51 | 21.51 | 21.51 | 21.51 |
EBIT | 46.5 | 58.0 | 152.8 | -109.1 | 11.1 | 114.2 | 155.8 | 212.5 | 289.9 | 395.5 |
EBIT, % | 18.09 | 20.8 | 25.47 | -16 | 1.32 | 9.94 | 9.94 | 9.94 | 9.94 | 9.94 |
Total Cash | 83.4 | 133.0 | 107.5 | 80.6 | 128.1 | 287.4 | 392.1 | 534.9 | 729.8 | 995.6 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 50.3 | 76.6 | 25.7 | 24.0 | 74.6 | 146.3 | 199.6 | 272.3 | 371.5 | 506.8 |
Account Receivables, % | 19.54 | 27.44 | 4.29 | 3.52 | 8.86 | 12.73 | 12.73 | 12.73 | 12.73 | 12.73 |
Inventories | 14.5 | 35.3 | 85.8 | 92.0 | 115.8 | 137.5 | 187.6 | 256.0 | 349.2 | 476.4 |
Inventories, % | 5.63 | 12.64 | 14.31 | 13.5 | 13.75 | 11.97 | 11.97 | 11.97 | 11.97 | 11.97 |
Accounts Payable | 41.0 | 31.6 | 82.5 | 72.6 | 100.4 | 146.1 | 199.3 | 272.0 | 371.0 | 506.2 |
Accounts Payable, % | 15.93 | 11.32 | 13.76 | 10.65 | 11.92 | 12.71 | 12.71 | 12.71 | 12.71 | 12.71 |
Capital Expenditure | -224.1 | -114.3 | -152.3 | -251.2 | -217.3 | -496.9 | -677.9 | -924.8 | -1,261.6 | -1,721.2 |
Capital Expenditure, % | -87.15 | -40.98 | -25.39 | -36.87 | -25.8 | -43.24 | -43.24 | -43.24 | -43.24 | -43.24 |
Tax Rate, % | -360.01 | -360.01 | -360.01 | -360.01 | -360.01 | -360.01 | -360.01 | -360.01 | -360.01 | -360.01 |
EBITAT | 25.2 | 21.2 | 82.5 | -118.5 | 51.1 | 78.7 | 107.4 | 146.5 | 199.9 | 272.7 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -175.0 | -101.0 | 106.4 | -215.9 | 6.8 | -218.6 | -283.4 | -386.6 | -527.4 | -719.5 |
WACC, % | 10.85 | 10.59 | 10.84 | 11.51 | 11.51 | 11.06 | 11.06 | 11.06 | 11.06 | 11.06 |
PV UFCF | ||||||||||
SUM PV UFCF | -1,481.4 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -734 | |||||||||
Terminal Value | -8,102 | |||||||||
Present Terminal Value | -4,796 | |||||||||
Enterprise Value | -6,277 | |||||||||
Net Debt | 136 | |||||||||
Equity Value | -6,413 | |||||||||
Diluted Shares Outstanding, MM | 295 | |||||||||
Equity Value Per Share | -21.73 |
What You Will Receive
- Customizable Excel Template: A fully adjustable Excel-based DCF Calculator featuring pre-filled real FSM financials.
- Actual Market Data: Historical performance data and future projections (as indicated in the highlighted cells).
- Flexible Forecasting: Adjust forecast parameters such as revenue growth, EBITDA %, and WACC.
- Instant Calculations: Quickly observe how your inputs influence Fortuna’s valuation.
- Professional Resource: Designed for investors, CFOs, consultants, and financial analysts.
- Intuitive Layout: Organized for clarity and simplicity, complete with step-by-step guidance.
Key Features
- Customizable Forecast Inputs: Adjust essential parameters such as silver production, operating costs, and capital investments.
- Instant DCF Valuation: Quickly computes intrinsic value, NPV, and other financial metrics.
- Industry-Leading Precision: Incorporates Fortuna Silver Mines Inc.'s (FSM) actual financial data for accurate valuation results.
- Effortless Scenario Analysis: Easily evaluate various scenarios and analyze their impacts on outcomes.
- Efficiency Booster: Avoid the complexities of creating intricate valuation models from the ground up.
How It Works
- 1. Access the Template: Download and open the Excel file containing Fortuna Silver Mines Inc.'s (FSM) preloaded data.
- 2. Modify Assumptions: Adjust critical inputs such as growth rates, WACC, and capital expenditures.
- 3. View Results Instantly: The DCF model automatically calculates the intrinsic value and NPV.
- 4. Explore Scenarios: Analyze various forecasts to evaluate different valuation results.
- 5. Present with Confidence: Showcase professional valuation insights to bolster your decision-making.
Why Choose This Calculator for Fortuna Silver Mines Inc. (FSM)?
- Comprehensive Tool: Integrates DCF, WACC, and financial ratio analyses tailored for Fortuna Silver Mines.
- Customizable Inputs: Modify the yellow-highlighted cells to explore different investment scenarios.
- Detailed Insights: Automatically computes Fortuna Silver Mines’ intrinsic value and Net Present Value.
- Preloaded Data: Access historical and projected data for accurate analysis.
- Professional Quality: Perfect for financial analysts, investors, and consultants focusing on mining sectors.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling Fortuna Silver Mines Inc. (FSM) stock.
- Financial Analysts: Streamline valuation processes with ready-to-use financial models specific to Fortuna Silver Mines Inc. (FSM).
- Consultants: Deliver professional valuation insights on Fortuna Silver Mines Inc. (FSM) to clients quickly and accurately.
- Business Owners: Understand how mining companies like Fortuna Silver Mines Inc. (FSM) are valued to guide your own strategy.
- Finance Students: Learn valuation techniques using real-world data and scenarios related to Fortuna Silver Mines Inc. (FSM).
What the Template Contains
- Pre-Filled Data: Contains Fortuna Silver Mines Inc.'s (FSM) historical financials and projections.
- Discounted Cash Flow Model: Editable DCF valuation model featuring automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for WACC calculations based on custom inputs.
- Key Financial Ratios: Assess Fortuna Silver Mines Inc.'s (FSM) profitability, efficiency, and leverage.
- Customizable Inputs: Easily modify revenue growth, margins, and tax rates.
- Clear Dashboard: Visuals and tables summarizing essential valuation outcomes.