Open Access

Dietmar Ernst, Joachim Häcker

• In times of crisis, risk management is more important than ever. In addition, companies are obliged to identify, quantify and aggregate risks as part of a risk management system. Legal and auditingIn times of crisis, risk management is more important than ever. In addition, companies are obliged to identify, quantify and aggregate risks as part of a risk management system. Legal and auditing standards have set the framework for doing so. This book uses a case study to show ‘step by step’ how risks can be analyzed and quantified with the help of Microsoft Excel. The book begins with the graphical representation of risks and the calculation of risk parameters such as the value at risk. It subsequently aggregates different risks into an overall risk using Monte Carlo simulation. Hedging risks is also explained, and how non-hedgeable risks can be integrated into a business plan. The assessment of extreme risks is also addressed, as is the modeling of volatilities. The book is aimed at students of business administration with a focus on finance.…