If you are looking at starting any sort of mining operation, Gold / other metals / gravel / rock / gems, this template will give you a good foundation for planning out startup costs, operating costs, and an in-depth yield schedule for potential revenue based on ore production.
This is an annual-only model for larger scale mining. The following outputs will be displayed based on all revenue and expense assumptions:
Return Summary (ROI, IRR per years operated, cash returned, cash required)
Annual Pro Forma (driving down to operating income and cash flow as well as displaying break-even year)
5 Visualizations to better digest the financial requirements and forecast in general
Define daily ore production
Define the expected % of each metal/gem/material that is in each tonne on average
Define the value per tonne for each material (up to 28 materials)
Cost Inputs (operational):
Diesel Fuel (liter per day)
Electricity (kWh per day)
Drill Bits (#/day)
Det. Cord (m/day)
Haul Roads / Site Work
The user can define various inputs for the above in order to get an accurate expected annual operating cost budget. Expected active days per year, hourly wages, count, cost per gallon / per watts / etc.. are all configurable.