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

Acerca del autor

MICHAEL REES is an independent consultant and trainer for financial modelling. He works for a wide range of clients, including major corporations, private equity firms, fund managers, strategy consultants and risk management consultants.

De la 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.

De la solapa interior

Thousands of professionals have already gained a mastery of the fundamental concepts and latest tools of the trade from the training methods in Business Risk and Simulation Modelling in Practice—now it's your turn to bring game-changing insight to your organisation's boardroom.

Whether you're looking at budgeting, forecasting, corporate finance valuation, portfolio composition and optimisation, or cash flow analysis, this practical guide shows you the best ways to approach risk assessment and the most efficient techniques to analyse and present the hard data that business leaders need to make profitable decisions. Business planners and financial analysts receive guidance to risk modelling that is grounded in real-life solutions and that includes advice on how to overcome the challenges of instilling a more risk-aware culture in organisations with established processes and incentives. Rigorous, yet highly accessible coverage uses non-mathematical material to provide you with:

• The key principles of simulation methods and the relationships between simulation and other modelling techniques such as sensitivity, scenario, and optimisation analysis.
• The core aspects of risk-model design, including important similarities and differences to traditional static modelling, alignment with general risk assessment process, and integration into existing models.
• A discussion of more than 20 distributions, along with their uses and processes, as well as frameworks for selecting the proper ones, and methods to create random samples using Excel macros created with Visual Basic Applications (VBA).
• Excel template models for running simulations, creating versatile ways to store and analyseresults, generating correlated random numbers and increasing simulation speed.
• A discussion of the benefits of Palisade's @RISK Excel add-in, including its sophisticated and flexible graphics capabilities; tools for rapidly building, testing, and modifying models; a larger set of available distributions and parameters; and greater capability to control simulation and random number selection.

While Palisade's @RISK add-in is used to demonstrate some key techniques, most coverage is software independent. This versatile book provides the tools to build a vast number of simulations in Excel, with VBA or @RISK.

Be prepared for every possible outcome with Business Risk and Simulation Modelling in Practice.