In this book, Professor Roy Nersesian examines a wide range of common business problems that require an optimal solution, yet where no linearity exists. That is, he tackles problems that cannot accurately be solved using Excel’s Solver or other traditional linear optimization tools. Instead, Prof. Nersesian leverages the power of Evolver’s unique genetic algorithms to address issues ranging from managing a stock portfolio to the timing of new plants. The book also comes with detailed example spreadsheets you can use and modify to meet your company’s particular needs.

In this book, Professor Roy Nersesian examines a wide range of business problems in marketing, finance, and operations that require an optimal solution, yet where no linearity exists. That is, he tackles problems that cannot accurately be solved using Excel’s Solver or other traditional linear optimization tools.

In addition, he considers the element of uncertainty inherent in these problems that other optimizers ignore. That is, he looks at ways to find not only the optimal solution to a given problem in a static state, but the best solution that simultaneously considers what may happen to the factors outside of your control.

To do this, Prof. Nersesian leverages the power of RISKOptimizer’s unique genetic algorithms and its Monte Carlo simulation engine (from the world-leading @RISK software) to solve problems ranging from yield management to capital planning. The book also comes with detailed example spreadsheets you can use and modify to meet your company’s particular needs.

In this book, Professor Roy Nersesian examines a wide range of credit and other issues faced by banks and investors. Using @RISK, RISKOptimizer, and PrecisionTree, Prof. Nersesian provides step-by-step examples on how to tackle everything from cash flow analysis to insurance, and everything in between. The book also comes with detailed example spreadsheets you can use and modify to meet your company’s particular needs.

JAMES MURTHA
A great extension of Murtha's highly successful seminars on the use of @RISK in the petroleum industry. You start here with 2 chapters to get up to speed on the philosophy of risk analysis and the requisite principles in probability, statistics, and Monte Carlo simulation. Following are the basic steps you'd take to actually build, run, and interpret results for a real risk analysis model in @RISK. To make it as hands-on as possible, Murtha includes lots of petroleum examples — an accompanying disk includes all these examples pre-built in Excel worksheets. Volumetric reserves, exponential decline, porosity and water saturation, waterflood prospect, and competitive bidding are some of the examples. This is a rare offering in that you'll learn about the concepts of risk analysis while also getting some very solid hands-on experience with risk analysis modeling in @RISK. SC, 150 pp

WAYNE L. WINSTON
In Decision Making Under Uncertainty with RISKOptimizer, Wayne Winston, author of Palisade's best-selling Financial Models Using Simulation and Optimization, once again offers models and techniques to find the best answers to business problems affected by uncertainty. Winston harnesses the power of Microsoft Excel along with Palisade's RISKOptimizer to solve business problems in areas such as inventory management, product mix decisions, capital budgeting, scheduling and more! Using Genetic Optimization and Monte Carlo simulation, optimal answers to previously unsolvable problems are now found! Managers from any industry will reap the benefits from this book. More than 30 example models ranging from job shop & production scheduling to retirement planning and options pricing are provided on the included CD-ROM as well. A trial version of RISKOptimizer, described by PC World as "a uniquely versatile business problem-solver" and "for many business problems, the most practical power tool around", is also included with the book.

WAYNE L. WINSTON
Financial Models is the most in-depth book written about using @RISK, Evolver and other DecisionTools software products to solve today's complex financial problems. The applications of simulation and optimization in the book are new, novel approaches to options pricing, portfolio optimization, acquisitions modeling, VAR (value-at-risk) and more!

Financial Models features years' worth of experience in setting up and solving complicated financial problems using Microsoft® Excel® and DecisionTools software. Learn valuable analytical techniques that help you get the most out of @RISK, Evolver, PrecisionTree® and TopRank®. Over 60 example problems show step-by-step how to set up and analyze each model. This is a practical, step-by-step guide that you can use immediately to build the models that you need!

The models in the book have been used at executive training classes at major corporations, including GM, NCR, PriceWaterhouseCoopers, and Bristol-Myers Squibb. All the models are included on CD-ROM along with trial versions of DecisionTools software.

WAYNE L. WINSTON
First published in 1998, Financial Models Using Simulation and Optimization quickly became one of the most widely used references for the application of simulation and optimization techniques to financial problems. Now, author Wayne Winston has done it again with a totally new volume! Financial Models II is packed with real-life examples that demonstrate how @RISK, Evolver and Excel can be used to make better financial decisions. Winston's straightforward, step-by-step approach makes his innovative techniques accessible to anyone who uses Microsoft Excel.

Like its predecessor, Financial Models II features years' worth of experience in setting up and solving complicated financial problems using Microsoft Excel and DecisionTools software. You will learn valuable analytical techniques that will help you get the most out of @RISK, Evolver, and Excel. A wide variety of financial examples are presented and solved step-by-step in over 65 chapters. This isn't a book of long-winded theoretical discussions. It's a practical, step-by-step guide that you can use immediately to build the models that you need!

Save money when you buy these two popular titles together.

Save money when you buy these three popular titles together!
Financial Models Using Simulation and Optimization I, Financial Models Using Simulation and Optimization II, and Decision Making Under Uncertainty with RISKOptimizer.

DR. CHRIS ALBRIGHT
Palisade's StatTools software brings unprecedented statistical power to Microsoft Excel. By combining robust statistical procedures, Excel's ease-of-use, and customization capabilities, StatTools sets a new standard in statistical analysis. Learning Statistics with StatTools is written to help you get the most out of StatTools in a practical, straightforward manner.

Much more than a software reference manual, this book shows you how to apply statistics to problems you face. Each chapter discusses a logically grouped set of statistical procedures, grouped as they are in the StatTools menu structure. The author illustrates each procedure with a representative data set, explaining how StatTools can be used to analyze the data in an appropriate way. He even discusses the meaning of the StatTools output, just for those of you who need a refresher in basic statistics. After many of the sections, additional notes are provided about alternative StatTools possibilities or statistical details.

MANUEL CABEZA Y SALVADOR TORRA
El Riesgo trata principalmente del riesgo empresarial, cómo conocerlo, medirlo y controlarlo mediante el diseño de modelos realizados en Hojas de Cálculo enriquecidos a través de la utilización de @RISK.

El “riesgo de los negocios” y de la “Empresa” no son nuevos. Han existido siempre que el hombre ha iniciado o continuado una actividad de fabricación, comercial o de empresa. No obstante, el grado de incertidumbre actual, fomenta la necesidad de aumentar el conocimiento de los mismos, de una mayor profundización en cómo y dónde se originan, de un análisis de los efectos que puede acontecer, de la gravedad o severidad de sus consecuencias, de la influencia mayor o menor de cada uno de los componentes del riesgo y del control que puede efectuarse sobre los mismos. Mas sobre El Riesgo en la Empresa.

WAYNE WINSTON
Modelos Financieros es el libro más profundo sobre el uso del @RISK, Evolver y otros productos de software del Decision Tools Suite para resolver problemas financieros complejos del mundo de negocios contemporáneo. Su autor, el Dr. Wayne Winston, es profesor de Ciencias de la Información y Decisiones de Indiana University y un líder en el campo de la investigación de operaciones. Las aplicaciones de simulación y optimizacion en este libro (muchas de las cuales nunca han sido publicadas antes), representan novedosos acercamientos a problemas de valuación de opciones, optimización de portafolios, modelamiento de adquisiciones, Valor en Riesgo (VaR) y mucho más! Mas sobre Modelos Financieros.