Gold Mining (or other metal) Excel Financial Model

Description
Recently updated to include an adjustment input for change in price per ore type over time.

Includes a 3-statement model (Income Statement, Balance Sheet, Cash Flow Statement), capex schedule with depreciation, and a cap table as well as improved general global assumptions and formatting conventions.

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 template is also included in two bundles:

• All Models Bundle
• Industry-Specific Financial Models Bundle