PCMINSIM: Discounted Cash Flow Rate of Return (DCFROR) Template for Use with Lotus 1-2-3. Documentation

摘要

A MINe SIMulator model is used by the Bureau of Mines to evaluate the economics of a mineral recovery operation. The document explains the computations performed in the discounted cash flow rate-of-return (DCFROR) procedure and the use of a LOTUS 1-2-3 (R) template version (PCMINSIM) of the model. A MINSIM evaluation combines reserve tonnage and grade estimates and the associated capital and operating costs with information about financial and tax conditions to simulate the DCFROR that can be expected over the life of the mine. Solution options include the Net Present Value (NPV) of the property, the average total production cost over the life of the operation, or the after-tax rate of return expected at an assumed selling price for the marketable product. Running PCMINSIM is simplified by 11 tiered-menus which direct the user through the evaluation process. The main contribution of the PCMINSIM is the use of automated spreadsheet technology to illuminate the relationships inherent in a DCFROR evaluation, to expedite interactive sensitivity analysis, and to facilitate modifications to explore new applications of the property evaluation tool.