Business Risk and Simulation Modelling in Practice: Using Excel, VBA and @RISK (The Wiley Finance Series) - Tapa dura

Reseña del editor

The complete guide to the principles and practice of risk quantification for business applications. The assessment and quantification of risk provide an indispensable part of robust decision-making; to be effective, many professionals need a firm grasp of both the fundamental concepts and of the tools of the trade. Business Risk and Simulation Modelling in Practice is a comprehensive, in depth, and practical guide that aims to help business risk managers, modelling analysts and general management to understand, conduct and use quantitative risk assessment and uncertainty modelling in their own situations. Key content areas include: * Detailed descriptions of risk assessment processes, their objectives and uses, possible approaches to risk quantification, and their associated decision-benefits and organisational challenges. * Principles and techniques in the design of risk models, including the similarities and differences with traditional financial models, and the enhancements that risk modelling can provide. * In depth coverage of the principles and concepts in simulation methods, the statistical measurement of risk, the use and selection of probability distributions, the creation of dependency relationships, the alignment of risk modelling activities with general risk assessment processes, and a range of Excel modelling techniques. * The implementation of simulation techniques using both Excel/VBA macros and the @RISK Excel add-in. Each platform may be appropriate depending on the context, whereas the core modelling concepts and risk assessment contexts are largely the same in each case. Some additional features and key benefits of using @RISK are also covered. Business Risk and Simulation Modelling in Practice reflects the author s many years in training and consultancy in these areas. It provides clear and complete guidance, enhanced with an expert perspective. It uses approximately one hundred practical and real-life models to demonstrate all key concepts and techniques; these are accessible on the companion website.

Contraportada

A Complete Package of Risk Quantification Principles and Best Practices

Business Risk and Simulation Modelling in Practice is the authoritative guide to building risk simulation models for the real-world. Using the techniques and examples contained in the book business risk managers, modelling analysts, and senior leadership can gain an in-depth understanding of risk and simulation modelling and effectively apply that knowledge to carry out essential and advanced quantitative risk assessment and uncertainty modelling in their own organisations.

Step-by-step guidance demonstrates how to build powerful models in Excel using VBA macros and then opens up a richer range of models built more quickly, flexibly, and transparently using Palisade's @RISK add-in. Written to jumpstart you from apprentice to expert practitioner, the results-based training program includes a companion website with convenient resources, including one hundred worked examples and coded Excel spreadsheets. When you're finished, you will:

• Understand the fundamental concepts and practices of risk analysis and modelling.
• Master Excel, VBA, and @RISK for dependency and correlation modelling.
• Know which distribution fits specific scenarios, and how to use it appropriately.
• Be experienced working with a variety of models employing complex concepts.

Ensure that you make the right decisions for your business unit and firm with Business Risk and Simulation Modelling in Practice.