Recently updated with comprehensive financial statements that are fully integrated as well as a cap table, capex schedule, and improved global control assumptions.
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
Revenue Inputs:
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)
Powder (kg/day)
Caps (#/day)
Primers (#/day)
Drill Bits (#/day)
Det. Cord (m/day)
Drillers
Blasters
Excavator Operators
Truck Drivers
Equipment Operators
Utility Operators
Mechanics
Laborers/Maintenance
Manager
Superintendent
Foreman
Engineer
Geologist
Supervisor
Technician
Accountant
Clerk
Personnel
Secretary
Security
Startup CapEx:
Equipment Purchase
Haul Roads / Site Work
Pre-production Stripping
Buildings
Electrical System
Sustaining Capital
Working Capital
Engineering
Contingency
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.