The Future in Your Spreadsheet
Wouldn’t you like to know the chances of making money – or taking a loss — on
your next venture? Or the likelihood that your project will finish on time and
within budget? How about the probabilities of finding oil or gas, and in what
amounts?
Everyone would like answers to these types of questions. Armed with that kind of
information, you could take a lot of guesswork out of big decisions and plan
strategies with confidence. With @RISK, you can answer these questions and more
– right in your Excel spreadsheet.
@RISK (pronounced “at risk”) performs risk analysis using Monte Carlo simulation
to show you many possible outcomes in your spreadsheet model—and tells you how
likely they are to occur. It mathematically and objectively computes and tracks
many different possible future scenarios, then tells you the probabilities and
risks associated with each different one. This means you can judge which risks
to take and which ones to avoid, allowing for the best decision making under
uncertainty.
@RISK also helps you plan the best risk management strategies through the
integration of RISKOptimizer, which combines Monte Carlo simulation with the
latest solving technology to optimize any spreadsheet with uncertain values.
Using genetic algorithms or OptQuest, along with @RISK functions, RISKOptimizer
can determine the best allocation of resources, the optimal asset allocation,
the most efficient schedule, and much more.
Excel Ease of Use
@RISK is a true add-in to Microsoft Excel, integrating completely with your
spreadsheet. Browse, define, analyze—while never leaving Excel. All @RISK
functions are true Excel functions, and behave exactly as native Excel functions
do. @RISK windows are all linked directly to cells in your spreadsheet, so
changes in one place are carried out in the other. @RISK graphs point to their
cells via callout windows. Drag-and-drop ease, context-sensitive right-click
menus, and the @RISK toolbar make learning and navigating @RISK a snap.
@RISK Professional
Designed for professional-grade problems in any industry, @RISK Professional is
perfect for most commercial uses. It provides a balance of advanced analysis and
point-and-click ease of use, and includes:
Integrated distribution fitting with BestFit® : Defines distribution functions
for you based on historical or industry data.
@RISK Library: A SQL database for storing and sharing with others @RISK
distribution functions, model components, and simulation results.
Excel Developer Kit (XDK): Automate and customize @RISK for Excel through a
complete library of commands and functions that let you control every aspect of
@RISK in your spreadsheet. Add @RISK for Excel to any custom application.
Stress Analysis: Lets you control the range that is sampled from a distribution
function, enabling you to see how different scenarios affect your bottom line
without changing your model.
Advanced Sensitivity Analysis: Lets you see how changes in any
input—distributions or regular values—affect simulation results.
@RISK Goal Seek: Uses multiple simulations to find an input value that achieves
a target simulation result you specify.
@RISK Industrial
Designed for your largest, most complex models, @RISK Industrial includes
everything in @RISK Professional, plus the following:
RISKOptimizer: Combines Monte Carlo simulation with sophisticated optimization
techniques to find the best combination of factors that lead to a desired result
under uncertain conditions. Use RISKOptimizer for resource allocation,
scheduling, investment, route planning, and other types of tricky problems where
you need to determine the best combination of inputs to maximize a return,
minimize a cost, or achieve a specific target. RISKOptimizer uses genetic
algorithms and Optquest solving methods so you’ll be sure to have the right
engine for any type of problem.
» More about RISKOptimizer
Simulation of Time-series Forecasts: @RISK offers a set of functions for
simulating time series processes, or values that change over time. Any future
projection of time series values has inherent uncertainty, and @RISK lets you
account for that uncertainty by looking at the whole range of possible time
series projections in your model. This is particularly useful in financial
modeling and portfolio simulation. There are functions available for 17
different statistical time series models, including ARMA, GBM, GARCH, and
others. These functions are entered as array functions in Excel. @RISK also
provides new windows for fitting historical time series data to these new
functions. The results can be animated to show the behavior of your time series
during simulation. All this is integrated into the existing @RISK interface.
Full Multi-CPU support: Speed up simulations with parallel processing by using
all multi-core processors and available CPUs within a single machine.