This Metal Mining model is used to provide a forecast and valuation of a metal mining project. This has 3 pricing scenarios for gold and silver metals. Included in the template you will find:
• An Assumptions Section specific to metal mining like production schedule, reserves, mill capacity, and royalties
• A Mining Section with a mining and milling schedule
• Financial Statement Section with the Profit & Loss of the mining operation and Asset Level Balance Sheet items
• DCF Valuation of the asset with IRR, NPV, and Payback Period
• Sensitivity Analysis of IRR and NPV, and Charts/Graphs for Cash Flow, Payback and Gold Production
The model starts with an Assumptions Section where you can enter information specific to metal mining. The pricing scenarios can be adjusted using the drop-down menu in cell F24. There are sections for conversion rates, production schedule, reserves & resources, mill capacity, royalties, payability for each metal, and associated costs for the project.
Below the assumptions, the Mining Section breaks down the mining and milling schedule where the ore milled is stripped down and the gold/silver metals are recovered based on the assumptions above. After that, the Financials Section forecasts the revenue and costs associated with the mining operation. This also contains the asset level balance sheet items to consider.
The DCF Model takes the financials from above to calculate the Free Cash Flow, Asset and Transaction level NPVs, and IRRS along with the Payback on the operation. The model contains two Sensitivity Analysis tables for IRR and NPV. For visualization, there are graphs to display cash flows over the valuation period, payback period, and gold production.
All cells in blue font are input cells where custom information can be entered. All cells in black font are formulas set to streamline the model. Sections are grouped to condense the model to view sections individually.
Similar Products
Other customers were also interested in...
Discounted Cash Flow DCF Valuation Model Template ...
This is a detailed and user-friendly financial model with the three financial statements i.e. Income... Read more
Gold Mining Company DCF Valuation Model Template
This is a detailed and user-friend financial model with the three financial statements, i.e., Income... Read more
Gold Mining Investment Project – 10 year Fin...
Financial Model providing forecast and valuation analysis of a Gold Mining Project. The... Read more
Upstream Oil & Gas Project Analysis
The Upstream Oil & Gas Project Financial Model Template in Excel empowers you to project and dissect... Read more
Private Equity Oil and Gas Financial Model
The Private Equity Oil and Gas Financial Model evaluates the financial feasibility and investor retu... Read more
Oil & Gas Financial Model – Dynamic 10 Y...
Financial Model providing forecast and valuation analysis of an upstream Oil & Gas Project. T... Read more
Industry Based Financial Models (Variety Bundle)
There are currently 52 unique financial models included in this bundle. Nearly all of that include a... Read more
Economic Model for Oil and Gas Extraction Feasibil...
This model runs for 20 years and makes it easy to create a financial plan and feasibility study for ... Read more
Oil & Gas Marketing and Distribution DCF Valu...
A detailed and user friend financial model that captures 5 years of Historical + 1 Year of Budget + ... Read more
Oil and Gas Project Finance Model
Oil and Gas Project Finance Modeling Template. This is a project finance model for an oil and gas up... Read more
You must log in to submit a review.