In a previous article I outlined my thoughts on the usefulness of early stage financial modelling (“Early Stage “What-if” Economic Analysis – How Useful Is It?”). My observation was that it is useful to take a few days to build a simple cashflow model yourself to help you understand your project.
By “simple” I mean simple.
This blog describes one of the techniques that I use to take a quick look at any project; whether it is for a client wishing to understand his project at a high level; or whether it is a project that I have read about. There is no study nor production schedule available yet.
It takes about 10 minutes to plug the numbers into my template to get quick results. The image below is an example of the simple model that I use, but anyone can build one for themselves.
Screenshot of Simple Economic Model
I term this a one dimensional (“1D”) model since it doesn’t require the typical X-Y matrix with years across the top and production data down the page.
The 1D model simply relies on life of mine (“LOM”) totals to estimate the total revenue, total operating cost, and total profit. This determines how much capital expenditure the project can tolerate.
The only caveat is that you need to have some sense for operating and capital costs for similar projects. The analysis can be on both a pre-tax and simple after-tax basis.
Using estimated metal prices and recoveries, the first step is to calculate the incremental revenue generated by each tonne of ore (see a previous article “11. Rock Value Calculator – What’s My Rock Worth?”).
Next that revenue per tonne is multiplied by the total ore tonnage to arrive at the total revenue over the life of mine.
The second step is to determine the life of mine operating cost, and again this simple calculation is based on estimated unit operating costs multiplied by the total tonnages being handled.
The third step is to calculate the life of mine profit based on total revenue minus total operating cost.
The potential net cashflow would be calculated by deducting an assumed capital cost from the life-of-mine profit. The average annual cashflow is estimated based on the net cashflow divided by the mine life. An approximate NPV can be calculated by determining the Present Value of a series of annual payments at a certain discount rate.
You need to understand your project
One can easily evaluate the potential impact of changing metal prices, changing recoveries, ore tonnages, operating costs, etc. to show what the economic or operational drivers are for this project. This can help you understand what you might need in order to make the project viable.
Update: Interestingly there is a Mining Intelligence website that provides an online calculator for evaluating mining project economics. It is a black box approach, in that you simply input your parameters and it outputs the results. I have not used it nor do I know what the cost is. Unfortunately the website does not provide information on the qualifications or backgrounds of the people who have built the model but it seems to be affiliated with InfoMine. If anyone has experience using the economic modelling service, please share your thoughts.
The bottom line is that a 1D economic calculation is very simplistic but still provides a vision for the project. The next step in the economic modelling process would be a 2D model based on an annual production schedule. The 1D approach is just a quick first step in looking at a potential project. You can do it even when you just know the head grades and some generalized orebody information.
Note: If you would like to get notified when new blogs are posted, then sign up on the KJK mailing list on the website. Otherwise I post notices on LinkedIn, so follow me at: https://www.linkedin.com/in/kenkuchling/.