From time to time, I encounter interesting software applications related to the mining industry. I recently became aware of NPV One, an Australian based, cloud hosted application used to calculate mineral project economics. Their website is https://npvone.com/npvone/
NPV One is targeting to replace the typical Excel based cashflow model with an online cloud model. It reminds me of personal income tax software, where one simply inputs the income and expense information, and then the software takes over doing all the calculations and outputting the result.
NPV One may be well suited for those not comfortable with Excel modelling, or not comfortable building Excel logic for depreciation, income tax, or financing calculations. These calculations are already built in the NPV One application.
I had a quick review of NPV One, being given free access to test it out. I spent a bit of time looking at the input menus and outputs, but by no means am I proficient in the software after this short review.
Like everything, I saw some very good aspects and some possible limitations. However, my observations may be a bit skewed since I do a lot of Excel modelling and have a strong comfort level with it. Nevertheless, Excel cashflow modelling has its own pro’s and con’s, some of which have been irritants for years.
NPV One – Pros and Cons
Pros
-
NPV One develops financial models that are in a standardized format. Models will be very similar to one another regardless of who creates it. We are familiar with Excel “artists” that have their own modelling style that can make sharing working models difficult. NPV One might be a good standard solution for large collaborative teams looking at multiple projects while working in multiple offices.
-
NPV One, I have been assured, is error free. A drawback with Excel modelling is the possibility of formula errors in a model, either during the initial model build or by a collaborator overwriting a cell on purpose (or inadvertently).
-
With NPV One, a user doesn’t need to be an Excel or tax modelling expert to run an economic analysis since it handles all the calculations internally.
-
NPV One allows the uploading of large input data sets; for example life-of-mine production schedules with multiple ore grades per year. This means technical teams can still generate their output (production schedules, annual cost summaries, etc.) in Excel. They can then simply import the relevant rows of data into NPV One using user-created templates in CSV format.
-
As NPV One evolves over time with more client input, functionality and usability may improve as new features are added or modified.
Cons
Like anything, nothing is perfect and NPV may have a few issues for me.
-
Since I live and breathe with Excel, working with an input-based model can be uncomfortable and take time to get accustomed to. Unlike Excel, in NPV One, one cannot see the entire model at once and scroll down a specific year to see production, processing, revenue, costs, and cashflow. With NPV jump to. If you’re not an avid Excel user, this issue may not be a big deal.
-
In Excel one can see the individual formulas as to how a value is being calculated. Excel allows one to follow a mathematical trail if one is uncertain which parameters are being used. With NPV One the calculations are built in. I have been assured there are no errors in NPV One, so accuracy is not the issue for me. It’s more the lack of ability to dissect a calculation to learn how it is done.
-
With NPV One, a team of people may be involved in using it. That’s the benefit of collaborative cloud software. However that means there will be a learning curve or training sessions that would be required before giving anyone access to the NPV One model. Although much of NPV One is intuitive, one still needs to be shown how to input and adjust certain parameters.
-
Currently NPV One does not have the functionality to run Monte Carlo simulations, like Excel does with @Risk. I understand NPV One can introduce this functionality if there is user demand for it. There will likely be ongoing conflict to try to keep the software simple to use versus accommodating the requests of customers to tailor the software to their specific needs.
Conclusion
The NPV One software is an option for those wishing to standardize or simplify their financial modelling.
Whether using Excel or NPV One, I would recommend that a single person is still responsible for the initial development and maintenance of a financial model. The evaluation of alternate scenarios must be managed to avoid it becoming a modelling team free for all.
Regarding the cost for NPV One, I understand they are moving away from a fixed purchase price arrangement to a subscription based model. I don’t have the details for their new pricing strategy as of May 2023. Contact Christian Kunze (ck@npvone.com) who can explain more, give you a demo, and maybe even provide a trial access period to test drive the software.
To clarify I received no compensation for writing this blog post, it is solely my personal opinion.
Regarding Excel model complexity mentioned earlier, I have written a previous blog about the desire to keep cashflow models simple and not works of art. You can read that blog at “Mine Financial Modelling – Please Think of Others”.
As with any new mining software, I had also posted some concerns with QP responsibilities as pertaining to new software and 43-101. You can read that post at the appropriately titled “New Mining Software and 43-101 Legal Issues”.
Note: You can sign up for the KJK mailing list to get notified when new blogs are posted. Follow me on Twitter at @KJKLtd for updates and other mining posts. The entire blog post library can be found at https://kuchling.com/library/
I remember in the late fall of that year, the company had a chance to bid on a larger project in Gros Morne National Park, Newfoundland. So our President, Frank Nolan (he was a brother to Fred Nolan, the infamous land-owner at Oak Island, by the way), decided he wanted to see the site and he chartered a Bell 106 helicopter to fly us there from Deer Lake. It was December (they say “December month” in that province) and when we got close to the Park, we ran into a sudden snow squall.
The QMM field office In Port Dauphin, Madagascar was located near the edge of town, and I typically walked from my lodging to the office each morning when I was there, about the time when school started for the children. Typically I passed dozens and dozens of tiny bamboo huts with corrugated metal roofs, and dirt floors each about 2 meters square.
It is one thing to briefly visit a remote project as part of a review team. It is another thing to be there as part of a design team trying to solve a problem and engineer a solution. I know of many engineers and geologists that would have similar work life experiences as part of their careers. However John has taken the initiative to write it all down.
The majority of mining projects tend to consist of either open pit only or underground only operations. However there are instances where the orebody is such that eventually the mine must transition from open pit to underground. Open pit stripping ratios can reach uneconomic levels hence the need for the change in direction.
There are several reasons why open pit and underground can be considered as two different projects within the same project.
An underground mine that uses a backfilling method will be able to dispose of some tailings underground. Conversely moving towards a larger open pit will require a larger tailings pond, larger waste dumps and overall larger footprint. This helps make the case for underground mining, particularly where surface area is restricted or local communities are anti-open pit.
Open pit and underground operations will require different skill sets from the perspective of supervision, technical, and operations. Underground mining can be a highly specialized skill while open pit mining is similar to earthworks construction where skilled labour is more readily available globally. Do local people want to learn underground mining skills? Do management teams have the capability and desire to manage both these mining approaches at the same time?
As you can see from the foregoing discussion, there are a multitude of factors playing off one another when examining the open pit to underground cross-over point. It can be like trying to mesh two different projects together.
This pessimism training started early in my career while working as a geotechnical engineer. Geotechnical engineers were always looking at failure modes and the potential causes of failure when assessing factors of safety.
When undertaking a due diligence, particularly for a major company or financier, we are not hired to tell them how great the project is. We are hired to look for fatal flaws, identify poorly based design assumptions or errors and omissions in the technical work. We are mainly looking for negatives or red flags.
It has been my experience that digging in a data room or speaking with the engineering consultants can reveal issues not identifiable in a 43-101 report. Possibly some of these issues were mentioned or glossed over in the report, but you won’t understand the full extent of the issues until digging deeper.
My hesitance in investing in some companies unfortunately can be penalizing. I may end up sitting on the sidelines while watching the rising stock price. Junior mining investors tend to be a positive bunch, when combined with good promotion can result in investors piling into a stock.
Most times the issue is something we couldn’t fully address given the level of study. We might have been forced to make best guess assumptions to move forward. The review engineers will have their opinions about what assumptions they would have used. Typically the common comment is that our assumption is too optimistic and their assumption would have been more conservative or realistic (in their view).
While waiting for various third-party due diligences to be completed, the company continue to do exploration drilling. There were still a lot of untested showings on the property and geologists need to stay busy.
With regards to the Heap Leach PEA, we did not wish to complicate the Feasibility Study by adding a new feed supply to that plant from mixed CIL/HL pits. The heap leach project was therefore considered as a separate satellite operation.
I have updated and simplified the trade-off analysis for this blog. Table 1 provides the costs and recoveries used herein, including increasing the gold price to $1500/oz.
These cross-over points described in Table 2 are relevant only for the costs shown in Table 1 and will be different for each project.
Normally I don’t write about mining stock markets, preferring instead to focus on technical matters. However I have seen some recent discussions on Twitter about stock price trends. For every stock there are a wide range of price expectations. Ultimately some of the expectations and realizations can be linked back to the Lassonde Curve.
Stage 5 is the start-up and commercial production period, possibly nerve-racking for some investors. This is where the rubber hits the road. The stock price can fall if milled grades, operating costs, or production rates are not as expected.
Some corporate presentations will highlight the Lassonde Curve, particularly when they are rising in Stage 1. You are less likely to see the curve presented when they are rolling along in Stages 2 or 3.
Concentrate handling systems may not differ much between model options since roughly the same amount of final concentrate is (hopefully) generated.
4. The head grade of the deposit also determines how economically risky pre-concentration might be. In higher grade ore bodies, the negative impact of any metal loss in pre-concentration may be offset by accepting higher cost for grinding (see chart on the right).
I had a grade tonnage curve, including the tonnes of ore and waste, for a designed pit. This data is shown graphically on the right. Essentially the mineable reserve is 62 Mt @ 0.94 g/t Pd with a strip ratio of 0.6 at a breakeven cutoff grade of 0.35 g/t. It’s a large tonnage, low strip ratio, and low grade deposit. The total pit tonnage is 100 Mt of combined ore and waste.
The Hill of Value is an interesting optimization concept to apply to a project. In the example I have provided, the optimal project varies depending on what the financial objective is. I don’t know if this would be the case with all projects, however I suspect so.
One of the questions I have been asked is how valid is the 1D approach compared to the standard 2D cashflow model. In order to examine that, I have randomly selected several recent 43-101 studies and plugged their reserve and cost parameters into the 1D model.
There is surprisingly good agreement on both the discounted and undiscounted cases. Even the before and after tax cases look reasonably close.
Perhaps with technology, like Zoom, one can replicate the personal feel of a trade show booth. One can still have back and forth conversations with investors rather than just doing lecture style webinars.
Management teams should introduce more than just the CEO or COO. Include VP’s of geology, engineering, corporate development, from time to time. Don’t hesitate to let the public meet more of your team. Trade show booths are often manned by different team members.
Better communication with investors can increase confidence in a management team. Although some investors may not enjoy technical discussions, I think there is a subset that will find them very helpful and interesting. There will likely be an audience out there.
As an aside, if you are using Zoom make sure the host has configured the right settings. There are instances where anonymous participants can suddenly share their own computer screen, i.e. with questionable videos, to the group. It’s been referred to as “zoom bombing”.