Gold Mining (or other metal) Excel Financial Model
Originally published: 04/04/2018 16:49
Last version published: 17/01/2019 09:43
Publication number: ELQ-97529-5
View all versions & Certificate

Gold Mining (or other metal) Excel Financial Model

Model up to 50 years of mining activity with up to 28 types of materials going at once.

This is a comprehensive way to forecast what your initial investment, revenue, and expenses look like in an open-pit mine. There is the possibility to account for mining over 28 types of materials including ruby, gold, silver, gravel, copper, iron, clay, limestone, and Beryl.

You can define the amount of material expected to be mined in tonnes and the expected break-down of each type of material you expect. For example, you can say 1,000 Tonnes per day and x% is gravel, x% is gold, x% is etc.....the assumptions would allow you to account for a % that is mined and has no value at all.

Cost and wage assumptions are dynamic and fit to this particular type of endeavor. Everything will populate on an annual P&L / cash flow sheet and change as you change the assumptions about what you are mining, your initial investment, and on-going costs.

The returns tab will show you IRR and ROI figures and there are charts to show expense break-downs per year as well as accumulated cash flow.

There is also a dynamic debt schedule that flows through the model if you plan on financing a % of your initial investment.

Finally, you are going to be able to set the current market price of each material in order to drive revenues.

This Best Practice includes
1 Excel template and 1 tutorial video

Acquire business license for $45.00

Add to cart

Add to bookmarks


Further information

Provide insight into the financial performance of a mining operation given various assumptions.

When modeling out a mining operation.

A non-mining operation.


  • Rate this Downloadable Best Practice

    Write a review

  • Oliver PEIJIE DAI(last updated: 10/10/2020 09:56)
  • Mohammed D(last updated: 03/07/2020 20:47)


More Best Practices from Jason Varner

See all

Discussion feed for Gold Mining (or Other Metal) Excel Financial Model

The user community and author are here to help. Go ahead!

  • Bailey Dunn
    HI Jason, could you please add an investment component into this excel you have amazingly created, please?
    arrow_drop_uparrow_drop_downReply reply
    • Jason Varner
      There is a 'returns' section that has all the values related to an investment: i.e. initial investment required, ROI, total cash returned, DCF analysis. There is also an area to input the values that result in the initial investment in the 'costs' tab cell c14 to C22. Is there something else you are talking about?
      arrow_drop_uparrow_drop_downReply reply
      • Jason Varner
        Note more features and updates have been done to the template since the video was made.
        arrow_drop_uparrow_drop_downReply reply

    5.0 / 5 (2 votes)

    please wait...