Dietmar Ernst

This book shows how modern risk management in banks and insurance companies can be modeled in Excel and Matlab. Readers are provided with all the necessary knowledge and skills in a systematic and structured step-by-step manner. Apart from basic Excel knowledge, no previous knowledge is required. The textbook is divided into five parts. First, the reader learns the basics of analyzing and modeling market risks. Next, the authors introduce and explain the modeling of credit risks and operational risks are quantified by calibrating loss distributions based on expert estimates. Furthermore, individual risk measures are examined in more detail. In order to calculate a risk measure for an overall portfolio to determine the risk capital, the question of the aggregation method is discussed. There are various common concepts for this, which are examined in more detail in the last part of the book. The book is aimed at students of business administration with a focus on financial services. Accompanying the book, readers receive Excel spreadsheets as digital bonus material for practice and application.

This textbook rethinks derivatives in a structured manner. This is done from the perspective of financial modeling, whereby the central issues from the financial economy are holistically mapped and resolved with the help of Microsoft Excel. The guideline of the book is an integrated case study, which is divided into two parts. The first part deals with the basics and the valuation of options and futures. In the second part, the individual option strategies are examined step by step in separate course units. The analysis ends – figuratively speaking – in a cockpit of sorts, where the reader controls the possible strategies in Excel. The book is aimed at students of business administration with a focus on finance.

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

This book shows how modern risk management in banks and insurance companies can be modeled in Excel and Matlab. Readers are provided with all the necessary knowledge and skills in a systematic and structured step-by-step manner. Apart from basic Excel knowledge, no previous knowledge is required. The textbook is divided into five parts. First, the reader learns the basics of analyzing and modeling market risks. Next, the authors introduce and explain the modeling of credit risks and operational risks are quantified by calibrating loss distributions based on expert estimates. Furthermore, individual risk measures are examined in more detail. In order to calculate a risk measure for an overall portfolio to determine the risk capital, the question of the aggregation method is discussed. There are various common concepts for this, which are examined in more detail in the last part of the book. The book is aimed at students of business administration with a focus on financial services. Accompanying the book, readers receive Excel spreadsheets as digital bonus material for practice and application.

Usted conoce su negocio, su historia, c mo funciona, c mo se adapta a los cambios constantes del mercado y c mo ha logrado superar los obst culos encontrados a lo largo de los a os. Nuestra misi n es escuchar sus necesidades y conocer el ADN de su empresa, todo con el objetivo de aportarle una soluci n exitosa a su organizaci n. Un proceso de fusi n o la adquisici n total o parcial de un negocio es un asunto que no debe tomarse a la ligera. Lo recomendable es realizar siempre el proceso de debida diligencia para anticipar los riesgos y costos que suele conllevar. No importa si usted est del lado del vendedor o del comprador: hay que realizar las evaluaciones correspondientes que coadyuven a alcanzar los objetivos buscados. Esta es la primera edici n del libro Transacciones corporativas. Fusiones y adquisiciones, la cual dedicamos a los clientes y amigos de Grant Thornton quienes, a lo largo de los a os, han demostrado su lealtad y aprecio hacia la firma. Deseamos realizar un reconocimiento especial a esta oficina en Ciudad de Panam por su liderazgo y apoyo a iniciativa como estas, que buscan promover el conocimiento en una materia tan importante en los mercados internacionales como la de los procesos de fusiones y adquisiciones

Mergers & acquisitions are an essential instrument of strategic corporate management for companies of all sizes. The success of an M&A project highly depends on an optimal transaction preparation, fast execution and the experience of all parties involved. Due to numerous endogenous and exogenous influences, no two M&A transactions are alike at the detailed level. This book is designed as a practical M&A guide for students and professionals alike. In addition to dealing with important basics of mergers & acquisitions, the focus is on a structured and in-depth examination of the individual process steps of a typical company sale. At various points in this book, specific differences between a company sale of medium-sized companies (mid-caps) and large companies (large-caps) are discussed in detail.

Dieses Buch liefert die statistischen Grundlagen für das quantitative Risikomanagement, indem es die wichtigsten Verteilungen vorstellt und erläutert. Verteilungen beschreiben das Auftreten und die Auswirkungen eines Risikos. Sie sind Voraussetzung für die Risikoaggregation, die Risikoanalyse und die Risikobewertung, wie sie in den deutschen Revisionsstandards IDW PS 340, StaRUG und FISG gefordert werden. Das Buch stellt die für das Risikomanagement von Unternehmen grundlegenden Verteilungen dar und zeigt, wann und wie sie eingesetzt werden. Dazu gehören Verteilungen wie Bernoulli, Binomial, Poisson, Gleich, Dreieck, PERT, modifizierte PERT, Trapez, Expert, Poly, Custom, Normal, Lognormal, Weibull und die Compound-Verteilung. Außerdem wird erklärt, wie die Parametrisierung der Verteilungen durch Expertenschätzungen oder algorithmische Kalibrierung erfolgen kann.

This book provides the statistical basis for quantitative risk management by presenting and explaining the most important distributions. Distributions describe the occurrence and impact of a risk. They are a prerequisite for risk aggregation, risk analysis and risk assessment as required by the German revision standards IDW PS 340, StaRUG and FISG. This book portrays the distributions that are fundamental for enterprise risk management and shows when and how they are used. These include the Bernoulli distribution, the binomial distribution, the Poisson distribution, the uniform distribution, the triangular distribution, the PERT distribution, the modified PERT distribution, the trapezoidal distribution, the custom distribution, the normal distribution, the lognormal distribution, the Weibull distribution, the expert distribution, the poly distribution and the compound distribution. Furthermore, the book explains how the parameterisation of the distributions can be done via expert estimates or algorithmic calibration.

Mergers & acquisitions are an essential instrument of strategic corporate management for companies of all sizes. The success of an M&A project highly depends on an optimal transaction preparation, fast execution and the experience of all parties involved. Due to numerous endogenous and exogenous influences, no two M&A transactions are alike at the detailed level. This book is designed as a practical M&A guide for students and professionals alike. In addition to dealing with important basics of mergers & acquisitions, the focus is on a structured and in-depth examination of the individual process steps of a typical company sale. At various points in this book, specific differences between a company sale of medium-sized companies (mid-caps) and large companies (large-caps) are discussed in detail.

This book provides a comprehensive introduction to modern financial modeling using Excel, VBA, standards of financial modeling and model review. It offers guidance on essential modeling concepts around the four core financial activities in the modern financial industry today: financial management; corporate finance; portfolio management and financial derivatives. Written in a highly practical, market focused manner, it gives step-by-step guidance on modeling practical problems in a structured manner. Quick and interactive learning is assured due to the structure as a training course which includes applied examples that are easy to follow. All applied examples contained in the book can be reproduced step by step with the help of the Excel files. The content of this book serves as the foundation for the training course Certified Financial Modeler. In an industry that is becoming increasingly complex, financial modeling is a key skill for practitioners across all key sectors offinance and banking, where complicated problems often need to be solved quickly and clearly. This book will equip readers with the basic modeling skills required across the industry today.