The Monte Carlo Simulation in Banks: Simplified Example in MS Excel and Practical Approach in German Savings Banks

Scientific Essay from the year 2010 in the subject Business economics - Banking, Stock Exchanges, Insurance, Accounting, grade: keine, Masaryk University (Fakultät für Wirtschaft und Verwaltung), course: ---, language: English, abstract: This article deals with the actual status quo of measuring credit risk in the German banking sector. It defines the kinds of VaR approaches and discusses the basics and models for quantifying credit risk. The VaR tools used in the German banking sector to measure credit risk are analysed in a next step. Further, the complex character of the Monte Carlo approac h is explained at the example of an Excel tool. The outlook of this article consists of a critical analysis of the efficiency in the context of the actual financial crisis in Germany.The paper extends the basic aspects of three former publications of the author, published in the specialized banking magazine Bankpraktiker 07-08.2006, pp. 366 - 371, the Conference paper for the ESF Conference on 25.06. - 26.06.2008 in Brno, Czech Republic, pp. 325 - 333 and the ControllerMagazin 05.2009, pp. 84 - 92.