View online at http://www.palisade.com/news/2008/PE/RISK5.asp




Palisade Corporation



@RISK 5.0 @RISK 5.0
Special Offers
Buy or Upgrade Now
» Get over 100 Free
   Financial Models

» Upgrade and Save £100
» Buy New from £795
» Free Upgrade for
   Maintenance Holders (web)


In This Issue
More About @RISK 5.0
» The @RISK Library
» The Compound Function
» @RISK for Six Sigma (web)
» RISKOptimizer 5.0

@RISK 5.0 Example Models
» Asset Price Random Walks
   and Option Values

» Discounted Cash Flow
» Insurance Claims with
   RiskCompound

» Product Mix with
   RISKOptimizer

» Six Sigma DOE
» Value at Risk (VAR)

@RISK 5.0 is intuitive, flexible and technically excellent. It is a quantum leap in all aspects of functionality and user experience.”
Raj Nataraja
Chase Cooper Ltd

“The user interface is significantly improved in @RISK 5.0 along with the output.”
Larry Hoberg
Raytheon

“The look and feel of @RISK 5.0 is a step up. Much more intuitive. This package seems really well put together.”
Albert Perrella
Institute for Defense Analyses


@Risk World Tour
You are invited to a special live demonstration of the all-new @RISK 5.0! Take this opportunity to network with peers, enjoy snacks and cocktails, and see an expert review of the new features of @RISK 5.0. Contact your sales rep to suggest tour dates and cities.

Madrid, 17 March
Warsaw, 24 April
Budapest, 25 April
Rome, 22 May

» Sign up for a Tour date


Free Webcasts
Robust Dynamic Pricing
of Perishable Products
Register Now!
» 27 Mar, 11am-12pmpm ET


Regional Seminars
» Europe & Africa
London: 12-13 Mar
Copenhagen: 26-27 Mar
London: 1-2 Apr
Paris: 7-8 Apr (in French)
Brussels: 8-9 May
London: 13-14 May
Prague: 9-10 June
London: 16-17 June
London: 14-15 July

» North America
Stamford, CT: 18-19 Mar
Washington, DC: 9-10 Apr
Vancouver: 22-23 Apr
Houston: 7-8 May
Ithaca, NY: 21-22 May
Denver: 29-30 May
Chicago: 3-4 June
Huntsville, AL: 17-18 June

» Latinoamérica
Buenos Aires
  (en español): 18-20 marzo
Bogota, Colombia
  (en español): 8-10 abril
São Paulo, Brasil
  (em português): 8-10 abril
Rio de Janeiro, Brasil
  (em português): 6-8 maio
São Paulo, Brasil
  (em português): 27-28 maiol

» Asia-Pacific
Auckland: 27-28 March
Perth: 10-11 April


Live Web Training
» What's New in @RISK 5.0
31 March, 2-4pm GMT

» Introduction to
@RISK for Project

3 April, 2-4pm GMT

» Risk and Decision Assessment Training using @RISK, Part I
24-25 March, 1-5pm ET
14-15 April, 1-5pm ET
12-13 May, 1-5pm ET
9-10 June, 1-5pm ET

» Risk and Decision Assessment Training using @RISK, Part II
27-28 March, 1-5pm ET
17-18 April, 1-5pm ET
15-16 May, 1-5pm ET
12-13 June, 1-5pm ET


Free Trial Versions
Palisade software is available in fully functional free trial versions. Try @RISK or any of our software today!

The DecisionTools Suite
The complete risk and decision analysis toolkit

@RISK
The world's most widely used risk analysis tool
@RISK
» @RISK for Excel
@RISK
» @RISK for Project

PrecisionTree
Visual decision analysis for spreadsheets

NeuralTools
Sophisticated neural networks for spreadsheets

StatTools
Advanced statistical analysis for spreadsheets

Evolver
The Innovative Optimiser
for Windows


The DecisionTools Suite





ALL NEW Announcing @RISK 5.0:
A new standard in risk analysis

All-new @RISK 5.0 from Palisade is here! @RISK 5.0 has been redesigned from the ground up with total Excel integration, stunning new graphics, unprecedented model sharing, and more robust analyses—including new Six Sigma and insurance functions. Plus, it works with previous versions and non-@RISK users. @RISK 5.0 Industrial adds new RISKOptimizer 5.0 which features a streamlined interface, improved entry of constraints, and much more.

» Download a trial version
» Read more and buy now

All New

The first thing you notice when you launch @RISK is the all-new interface with total Excel integration.

Browse, define, and analyse - while never leaving Excel. @RISK graphs pop-up as you browse through cells in your spreadsheet. Summary windows displaying thumbnail graphs and statistics of model components link directly to the cells they represent. Seamlessly switch between model definition and simulation results. Create and overlay graphs with drag-and-drop ease. Perform tasks with context-sensitive right-click menus.


MODEL …Your situation with new sharing capabilities, correlation improvements, and insurance features.

Set Up Your Model

Share model components with the @RISK Library.
The new @RISK Library is a SQL database that lets you share specific probability distributions, model components, and simulation results with other @RISK users. » MORE

Collaborate with non-@RISK users.
The @RISK Function Swap lets you “swap out” @RISK functions from your spreadsheet with a single click so that @RISK models may be shared with—and edited by—other users without @RISK installed.

Compound function for insurance and finance.
Reduce your model from thousands of distributions representing frequency and severity of events to just one new Compound function. » MORE

Correlate inputs for model accuracy.
@RISK 5.0 offers dynamically updating correlation Scatter Plots, and Scatter Plots of actual simulated correlations after a simulation. Plus, setup of a correlated time series is a snap.


SIMULATE …Scenarios with greater control, enhanced updating, and a faster calculation engine.

Run Simulation

Illustrate with live updating.
All graphs, summary windows, and displayed results can update live, in real-time during simulation, allowing you to explain the simulation mechanics to others. A new Demo Mode provides one-click demonstration set-up.

Accurate results when you need them.
Simulations are calculated 100% within Excel, supported by Palisade sampling and statistics proven in over twenty years of use. Plus, @RISK 5.0 fully utilises popular dual- and quad-core processors to speed up simulations.


UNDERSTAND …Risks you face better than ever with new graphs and reporting.

Understand Your Risks

See at-a-glance summaries with Summary Box Plots.
New Summary Box Plots quickly show the mean and percentile values of simulated outputs in a range.

Spot relationships with Scatter Plots.
For individual outputs, Scatter Plots and Scatter matrices visually depict the relationship between a simulated output and a given input distribution.

Understand critical values with
Tornado Graphs – Mapped Values.

Not only can you see which variables are most important, now you can read exactly how much a change in a given input affects your bottom line—no math required.

Customise any graph, any way.
@RISK 5.0 uses a new graphing engine designed specifically for processing simulation data. Graphs can be fully customised by simply clicking on the desired graph element. Plus, a set of summary statistics is included alongside each graph.

Six Sigma reporting.
New Six Sigma property functions define USL, LSL, and Target values for simulation outputs. After simulation, new Six Sigma statistics functions return desired capability metrics like Cp, Cpk, Cpm, DPM, PNC, and many more. Six Sigma graph markers customise charts for Six Sigma reports. » MORE


Buy or Upgrade Now and get 100 Free Models

Get Financial Models Book and over 100 Example Models FREE


»
UPGRADE from ANY PREVIOUS VERSION of @RISK at special prices for a limited time:

@RISK 5.0 Free Book       to @RISK 5.0 Industrial — SAVE £100
       to @RISK 5.0 Professional — SAVE £75
       to @RISK 5.0 Standard — SAVE £50

Call Palisade for this offer.

» BUY NEW for only:

       @RISK 5.0 Industrial — £1395
       @RISK 5.0 Professional — £995
       @RISK 5.0 Standard — £795

All prices include a full year of maintenance, up to £279 value.

» MAINTENANCE PLAN HOLDERS upgrade to @RISK 5.0 for FREE

» Download free trial
» Watch What’s New

All @RISK 5.0 purchases made by March 31, 2008 will be shipped with a FREE copy of Financial Models Using Simulation and Optimization by Wayne Winston and all accompanying example models. First published in 1998, this book has been updated for @RISK 5.0 in a new 3rd edition and has become the reference for business and financial modeling under uncertainty. Packed with over 100 real-life example spreadsheets, it comes with step-by-step instructions on a wide range of topics in finance and business. This offer ends March 31.

+44 1895 425050 | sales@palisade-europe.com



More About @RISK 5.0

The @RISK Library
@RISK 5.0 Professional and Industrial versions include the @RISK Library, a separate database application for sharing @RISK input probability distributions and comparing results from different simulations. The @RISK Library uses SQL Server to store @RISK data. Different users in an organisation can access a shared @RISK Library in order to access:

  • Common input probability distributions which have been pre-defined for use in an organisation’s risk models
  • Simulation results from different users in an organisation

Probability distribution functions in the @RISK Library may be accessed from the Define Distribution window like any other distribution.

The @RISK Library will make standardisation and consistency of analysis much easier than ever before. With the @RISK Library, workgroup efficiency will be greatly improved.

 

The Compound Function
The new RiskCompound function, especially applicable to the insurance industry, is used for “frequency – severity” modeling and takes two distributions to create a single new input distribution. This function takes two arguments. Each argument can be an @RISK function, or can be a cell reference to another formula. In a given iteration, the value of the first argument specifies the number of samples which will be drawn from the distribution entered in the second argument. Those samples from the second distribution are then summed to give the value returned by the RiskCompound function.

For example, the function:

RiskCompound(RiskPoisson(5),RiskLognorm(10000,10000))

would be used in the insurance industry where the frequency or number of claims is described by RiskPoisson(5) and the severity of each claim is given by RiskLognorm(10000,10000). Here the sample value returned by RiskCompound is the total claim amount for the iteration, as given by a number claims sampled from RiskPoisson(5), each with an amount sampled from RiskLognorm(10000,10000).

RiskCompound can eliminate hundreds or thousands of distribution functions from existing @RISK models by encapsulating them in a single function. The result is models that are much simpler to use, and run much faster.

RiskCompound supports cell references with formulas for more complex modeling, such as accounting for the timing of claims paid.



RISKOptimizer 5.0
Included with the Industrial version of @RISK 5.0 and the DecisionTools Suite, RISKOptimizer 5.0 has been re-engineered from the ground up in a stunning new version. A streamlined interface, full support for cell ranges, enhanced monitoring of optimisation progress, a faster engine and more make RISKOptimizer PC World’s “most practical power tool around.”

RISKOptimizer combines the Monte Carlo simulation technology of @RISK with genetic algorithm optimisation technology to allow the optimisation of Excel spreadsheet models that contain uncertain values. Take any optimisation problem and replace uncertain values with @RISK probability distribution functions that represent a range of possible values. For each trial solution RISKOptimizer tries during optimisation, it runs a Monte Carlo simulation, finding the combination of adjustable cells that provides the best simulation results.

» More on RISKOptimizer 5.0




@RISK 5.0 Example Models

Asset Price Random Walks and Options Valuation
Models of the prices of assets (stocks, property, commodities) very often assume a random walk over time, in which the periodic price changes are random, and in the simplest models are independent of each other. The future price level of the asset may result in some contract or payoff becoming valuable, such as in the case of financial market options. In these cases, the value of the contract (contingent payment or option) is calculated as the average discounted value of the future payoff. In the special case of European options on a traded underlying asset, the value calculated from the simulation may be compared with mathematical formulas that analytically provide the valuation, such as the Black-Scholes equation. This particular model compares the average simulated payoff for European Call and Put options with the Black-Scholes valuation.

For the case of the correlated random walks of multiple assets with a constant correlation coefficient, these can be set up using the Correlated Time Series feature of @RISK.

» Download example model: AssetPrices.Options.BS.Multi.xls

 

Discounted Cash Flow (DCF)
Discounted cash flow (DCF) calculations are a frequent example of the use of @RISK. In the example model, the sources of risk are the revenue growth rate and the variable costs as a percentage of sales. After taking into account the assumed investment, and applying a discount factor, the DCF is derived. Following the simulation, the average (mean) of the DCF is known as the net present value (NPV). The decision as to whether to proceed or not with this project will depend on the risk perspective or tolerance of the decision-maker. This example has also been extended to calculate the distribution of bonus payments on the assumption that a bonus is paid whenever the net DCF is larger than a fixed amount. It also uses the @RISK Statistics functions RiskMean, RiskTarget, and RiskTargetD to work out the average net DCF, the probability that the net DCF is negative and the probability that a bonus is paid.

» Download example model: CashFlow.xls

 

Insurance Claims with RiskCompound
@RISK’s RiskCompound function uses two distributions to create a single new input distribution, streamlining insurance models that must account for frequency and severity of claims. This model illustrates how the RiskCompound function is created, and shows properties such as mean, standard deviation, and a target value of the resulting RiskCompound function.

» Download example model: RiskCompound.xls

 

Product Mix with RISKOptimizer
A manufacturing plant is trying to find the optimal quantities of each of four products to manufacture to maximise the mean of total revenues. The demand for each product is uncertain, and represented with probability distribution functions. The quantity of each product produced must meet constraints related to the resources available for manufacturing each product. Here, all constraints are specified in one step, using RISKOptimizer's ability to define constraint limits as ranges. RISKOptimizer will vary the amount of each product produced, subject to the constraints of resources, to maximise revenues.

» Download example model: ProductMix.xls

 

Six Sigma DOE
Suppose you are analysing a metallic burst cup manufactured by welding a disk onto a ring. The product functions as a seal and a safety device, so it must hold pressure in normal use, and it must separate if the internal pressure exceeds the safety limit. The output is the weld strength, which is affected by process and design factors such as disk thickness, weld time, and more. The model accounts for the variation for each factor, and forecasts the product performance in relation to the engineering specifications.

Modeling a response based on multiple factors can often be accomplished by generating a statistically significant function through experimental design or multiple regression analysis. In this example, @RISK simulates the variation using Normal distributions for each factor.

The output is Weld Strength (N) and contains a RiskSixSigma property function that includes the Lower Specification Limit (LSL), Upper Specification Limit (USL), and Target value specified. After you run the simulation, Six Sigma statistics are generated using @RISK Six Sigma functions for Cpk-Upper, Cpk-Lower, Cpk, and PPM Defects (or DPM). Standard @RISK statistics functions (like RiskMean) were also used.

» Download example model: SixSigmaDOE.xls

 

Value at Risk (VAR)
The concept of value at risk (VAR) has been used to help describe a portfolio's uncertainty. Simply stated, the value at risk of a portfolio at a future point in time is usually considered to be the fifth percentile of the loss in the portfolio's value at that point in time. In other words, there is considered to be only one chance in 20 that the portfolio's loss will exceed the VAR. This model shows how @RISK can be used to measure VAR. The example also demonstrates how buying puts can greatly reduce the risk in a stock. The two outputs represent the range of the percentage gain if we do not buy a put vs. the percentage gain if we do buy a put. The results illustrate there is a greater chance of a big loss if we do not buy the put, although the average return is slightly higher if we do not buy the put.

» Download example model: VAR.xls

More Example Models online:

» Finance
» Insurance
» Six Sigma


Visit http://www.palisade.com
E-mail comments or suggestions to:sales@palisade-europe.com
©2008 Palisade Europe UK Ltd, 31 The Green, West Drayton, Middlesex, UB7 7PN, UK
+44 1895 425050, UK 0800 783 5398, FR 0800 90 80 32, GER 0800 181 7449, SP 900 93 89 16
$unsub