DECISION TOOLS SUITE
This is a suite of five products designed to work together to provide
complete risk and decision analysis. The programs run together in an integrated
environment running from a common toolbar in Microsoft Excel.
With the suite, you can perform advanced analyses you could not perform with
a single produce. The Suite includes the following products:
- @RISK is the risk analysis and simulation add-in for Excel .
Replace uncertain values in your spreadsheet with @RISK functions which
represent a range of possible values. Select one or more bottom-line cells as
outputs, and start a simulation. The program recalculates the spreadsheet
multiple times, selecting random values from the functions entered. The result
is a distribution of possible outcomes and the probability of getting those
results. Results can be displayed as graphs and in a full statistical report.
Advanced features include sensitivity and scenario analysis, overlay graphs,
and multiple summary graphs.
- PrecisionTree (Standard or Professional) is the decision analysis
add-in for Excel for creating influence diagrams and decision trees. Influence
diagrams illustrate the relationships between components of a problem, then
decision trees model the sequence of events. Resutls include a full
statistical report and risk profile graphs. Sensitivity analysis identifies
which factors are most important. Advanced features include linked trees,
logic nodes, and reference nodes. The professional version adds policy
suggestion graphs and strategy region graphs.
- TopRank (Standard or Professional) is the what-if analysis add-in
for Excel. The program automatically determines which cells in a spreadsheet
affect results the most and ranks them in order of importance. Results can be
displayed as Tornado graphs and in a full statistical report. Advanced
features include a What-if Wizard, Multi-Way What-If Analysis, and support for
data tables.
- BestFit is the distribution fitting solution that takes data and
finds the distribution function that best fits the data. Three types of data
are accepted: sample, density, and cumulative. Advanced optimization
algorithms test up to 26 distribution types. Results are displayed graphically
and through a statistical report that includes goodness-of-fit statistics.
BestFit distributions can be used directly in @RISK.
- RISKview (Standard or Professional) is the distribution viewing
companion program. It is a tool for viewing, assessing, and creating
probability distributions. Draw distribution functions with the Distribution
Artist and place them in @RISK models as general distributions. The Pro
version calculates the distribution that best fits a hand-drawn curve from 37
distribution types.
The programs in the suite are also available separately.
HARDWARE: PC. Windows 3.x/95/NT
PRICE: $995 Standard. $1295 Professional Free demo CD.
SOFTWARE BISQUE
912 12th Street, Suite A
Golden, CO 80401
303-278-4478. FAX: 303-279-1180
Daniel R. Bisque
SEE 4.2- SOFTWARE FOR ECONOMIC EVALUATION
This is an economic analysis program designed to provide before or after tax
discounted cash flow analysis for mineral/mining investment opportunities. SEE
is menu-driven with pop up windows; context sensitive help screens bring the
manual to the screen with one keystroke. Values such as grade, production, or
recovery rates may be input as "series" amounts that may change at any
frequency (monthly, annually, etc.). Equation classes are provided for: General,
Revenues, Processing, Cost, Special Taxes and Royalties. Simple or complex cash
flow models can be built based on complicated interdependencies of the equation
classes.
Four different tax scenarios are provided. State and federal tax rates may be
varied yearly. Tax and depreciation calculations are based on 1989 tax laws and
are updated as the U.S. tax laws change.
SEE can handle economic evaluations of both mutually exclusive (choose only
one alternative) and non-mutually exclusive (rank alternatives for a given
budget) alternatives. The program contains routines for Monte Carlo analysis,
expected value analysis, sensitivity analysis and break-even revenue analysis. A
consolidation routine is also provided to determine the overall project
economics of combining several project's cash flows.
Capital Cost information consists of the purchase date, cost, type of cost,
depreciation method, life, lag and salvage value. Up to 50 different loans may
be entered for a leveraged analysis. Other input data includes cost depletion,
percentage depletion and extraordinary cash flow components.
The Report section provides ten different reports including:
- - Cash Flow report. Customize and save report formats, amount of detail
can be selected.
- - Decision Criteria report - displays net present value, discounted cash
flow rate of return, growth rate of return, modified rate of return ,
present rate of value, benefit cost ratio and payback.
- - Capital Cost reports - display capital costs by depreciation type and
amount, or report the yearly depreciation amounts of each capital cost
type.
- - Depreciation amortization schedules, loan amortization schedules and
production schedules.
All reports may be sent to the console, printer or to an ASCII text file
which can be imported into other software packages. A built-in graphing section
allows you to display cumulative cash position diagrams, cash flow diagrams,
Monte Carlo histograms, or line graphs of any cash flow component desired.
HARDWARE: PC running DOS with a hard disk drive. Graphics devices supported
include dot matrix printers, laser printers and HPGL or DM/PL plotter languages.
PRICE: $1495. If you enroll in the workshop offered by the Colorado School of
Mines, you can purchase the program for $795. Multiple copy discounts or site
licenses are available.