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.

Reviews Add a review
No reviews yet

More From smarthelping

Browse our top rated business templates. See All
Stock / Crypto Fund Portfolio Tracker: Multi-member Capable
This tool was designed for a multi-member fund to keep track of trading activity, the resulting distributions to investors, and…
Volume Discounts: Sensitivity Analysis
Any business that wants to offer discounts for higher volume purchases will benefit from this volume discount template. Simply enter…
Retirement Planning Financial Model
This is a retirement planner based on expected investments and the cash flow that produces against expected expenses (including taxes)…
Job Costing Tracker for Managers
This is a job costing tracker for any business that wants to see weekly and monthly total number of hours…
PPC Advertising Financial Calculator and Sensitivity Analysis
This is a sensitivity analysis calculator to help anyone who is doing PPC (pay per click) direct marketing or PPC…
IRR Target Investment Calculator
Investors can be confused with terminology that is used on deals and in offerings. The difference between IRR and ROI…
See All