Fortuna Silver Mines Inc. (FSM) DCF Valuation

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

DCF model
Get Full Bundle:
$25 $15
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7

TOTAL:

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
Account Receivables, % 19.54 27.44 4.29 3.52 8.86
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.