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.