Business risk and simulation modelling in practice : using Excel, VBA and RISK

Author

• Rees, Michael

Additional Author(s)

-

Publisher

Chichester, West Sussex, United Kingdom: John Wiley and Sons, Inc., 2015

Language

English

ISBN

9781118904022

Series

Wiley finance series

Subject(s)

• BUSINESS & ECONOMICS / INDUSTRIAL MANAGEMENT
• BUSINESS & ECONOMICS / MANAGEMENT
• BUSINESS & ECONOMICS / MANAGEMENT SCIENCE
• RISK MANAGEMENT-DATA PROCESSING
• RISK MANAGEMENT-COMPUTER SIMULATION
• BUSINESS & ECONOMICS / ORGANIZATIONAL BEHAVIOR

Notes

• Includes index

. .

Abstract

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.

Physical Dimension

Number of Page(s)

1 online resource (xxv, 438 p.)

Dimension

-

Other Desc.

-

Summary / Review / Table of Content

Front Matter (Pages: i-xxv)
Part I : An Introduction to Risk Assessment – Its Uses, Processes, Approaches, Benefits and Challenges
CHAPTER 1 The Context and Uses of Risk Assessment (Pages: 1-27)
CHAPTER 2 Key Stages of the General Risk Assessment Process (Pages: 29-44)
CHAPTER 3 Approaches to Risk Assessment and Quantification (Pages: 45-57)
CHAPTER 4 Full Integrated Risk Modelling: Decision‐Support Benefits (Pages: 59-86)
CHAPTER 5 Organisational Challenges Relating to Risk Modelling (Pages: 87-103)
Part II : The Design of Risk Models – Principles, Processes and Methodology
CHAPTER 6 Principles of Simulation Methods (Pages: 105-135)
CHAPTER 7 Core Principles of Risk Model Design (Pages: 137-179)
CHAPTER 8 Measuring Risk using Statistics of Distributions (Pages: 181-213)
CHAPTER 9 The Selection of Distributions for Use in Risk Models (Pages: 215-272)
CHAPTER 10 Creating Samples from Distributions (Pages: 273-289)
CHAPTER 11 Modelling Dependencies between Sources of Risk (Pages: 291-323)
Part III : Getting Started with Simulation in Practice
CHAPTER 12 Using Excel/VBA for Simulation Modelling (Pages: 325-364)
CHAPTER 13 Using @RISK for Simulation Modelling (Pages: 365-423)
Index (Pages: 425-438)

Exemplar(s)

#	Accession No.	Call Number	Location	Status
1.	01697/19	658.1550285554 Ree B	Online !	Available