Credit Risk Modeling using Excel and VBA

Comprehensive instruction on developing real-world financial models This book, designed for self-study, classroom use, and reference, presents a com-prehensive approach to developing simple to sophisticated financial models in all major areas of finance. The approach is based on the author's 20 years of experience of developing such models in the business world and teaching a popular MBA class in financial modeling. The book assumes only basic knowledge of Excel and teaches all advanced features of Excel and VBA from scratch using a unique simple method. A companion CD includes all working versions of all the models presented in the book and additional useful reference material. Chandan Sengupta (White Plains, NY) teaches finance in the MBA program at Fordham University's Graduate School of Business. Formerly, he was vice president of the Chase Manhattan Bank for eight years and senior financial advisor for Mobil Corporation for 10 years. He is also the author of The Only Proven Road to Investment Success (0-471-44307-7).

Co-authored by two respected authorities on hedge funds and asset management, this implementation-oriented guide shows you how to employ a range of the most commonly used analysis tools and techniques both in industry and academia, for understanding, identifying and managing risk as well as for quantifying return factors across several key investment strategies. The book is also suitable for use as a core textbook for specialised graduate level courses in hedge funds and alternative investments. The book provides hands-on coverage of the visual and theoretical methods for measuring and modelling hedge fund performance with an emphasis on risk-adjusted performance metrics and techniques. A range of sophisticated risk analysis models and risk management strategies are also described in detail. Throughout, coverage is supplemented with helpful skill building exercises and worked examples in Excel and VBA. The book's dedicated website, www.darbyshirehampton.com provides Excel spreadsheets and VBA source code which can be freely downloaded and also features links to other relevant and useful resources. A comprehensive course in hedge fund modelling and analysis, this book arms you with the knowledge and tools required to effectively manage your risks and to optimise the return profile of your investment style.

"Professional Financial Computing Using Excel and VBA is an admirable exposition that bridges the theoretical underpinnings of financial engineering and its application which usually appears as a «black-box» software application. The book opens the black-box and reveals the architecture of risk-modeling and financial engineering based on industry-standard stochastic models by utilizing Excel and VBA functionality to create a robust and practical modeling tool-kit. Financial engineering professionals who purchase this book will have a jumpstart advantage for their customized financial engineering and modeling needs." Dr. Cameron Wicentowich Vice President, Treasury Analytics Canadian Imperial Bank of Commerce (CIBC) «Spreadsheet modeling for finance has become a standard course in the curriculum of many Quantitative Finance programs since the Excel-based Visual Basic programming is now widely used in constructing optimal portfolios, pricing structured products and managing risks. Professional Financial Computing Using Excel and VBA is written by a unique team of finance, physics and computer academics and practitioners. It is a good reference for those who are studying for a Masters degree in Financial Engineering and Risk Management. It can also be useful for financial engineers to jump-start a project on designing structured products, modeling interest term structure or credit risks.» Dr. Jin Zhang Director of Master of Finance Program and Associate Professor The University of Hong Kong «Excel has been one of the most powerful tools for financial planning and computing over the last few years. Most users utilize a fraction of its capabilities. One of the reasons is the limited availability of books that cover the advanced features of Excel for Finance. Professional Financial Computing Using Excel and VBA goes the extra mile and deals with the Excel tools many professionals call for. This book is a must for professionals or students dealing with financial engineering, financial risk management, computational finance or mathematical finance. I loved the way the authors covered the material using real life, hands-on examples.» Dr. Isaac Gottlieb Temple University Author, Next Generation Excel: Modeling in Excel for Analysts and MBAs

This comprehensive guide offers traders, quants, and students the tools and techniques for using advanced models for pricing options. The accompanying website includes data files, such as options prices, stock prices, or index prices, as well as all of the codes needed to use the option and volatility models described in the book. Praise for Option Pricing Models & Volatility Using Excel-VBA «Excel is already a great pedagogical tool for teaching option valuation and risk management. But the VBA routines in this book elevate Excel to an industrial-strength financial engineering toolbox. I have no doubt that it will become hugely successful as a reference for option traders and risk managers.» —Peter Christoffersen, Associate Professor of Finance, Desautels Faculty of Management, McGill University «This book is filled with methodology and techniques on how to implement option pricing and volatility models in VBA. The book takes an in-depth look into how to implement the Heston and Heston and Nandi models and includes an entire chapter on parameter estimation, but this is just the tip of the iceberg. Everyone interested in derivatives should have this book in their personal library.» —Espen Gaarder Haug, option trader, philosopher, and author of Derivatives Models on Models «I am impressed. This is an important book because it is the first book to cover the modern generation of option models, including stochastic volatility and GARCH.» —Steven L. Heston, Assistant Professor of Finance, R.H. Smith School of Business, University of Maryland

This new and unique book demonstrates that Excel and VBA can play an important role in the explanation and implementation of numerical methods across finance. Advanced Modelling in Finance provides a comprehensive look at equities, options on equities and options on bonds from the early 1950s to the late 1990s. The book adopts a step-by-step approach to understanding the more sophisticated aspects of Excel macros and VBA programming, showing how these programming techniques can be used to model and manipulate financial data, as applied to equities, bonds and options. The book is essential for financial practitioners who need to develop their financial modelling skill sets as there is an increase in the need to analyse and develop ever more complex 'what if' scenarios. Specifically applies Excel and VBA to the financial markets Packaged with a CD containing the software from the examples throughout the book Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

This book provides a pragmatic, hands-on approach to reaching an intermediate level of sophistication as a financial modeler. Expanding on the first book, A Fast Tract to Structured Finance Modeling, Monitoring, and Valuation, the book will guide you step-by-step through using learned principals in new and more powerful applications. These applications will build on the knowledge of Excel and VBA gained, expand the use of Access for data management tasks, as well as PowerPoint and Outlook for reporting and presentation tasks.

A valuable reference for understanding operational risk Operational Risk with Excel and VBA is a practical guide that only discusses statistical methods that have been shown to work in an operational risk management context. It brings together a wide variety of statistical methods and models that have proven their worth, and contains a concise treatment of the topic. This book provides readers with clear explanations, relevant information, and comprehensive examples of statistical methods for operational risk management in the real world. Nigel Da Costa Lewis (Stamford, CT) is president and CEO of StatMetrics, a quantitative research boutique. He received his PhD from Cambridge University.

The book’s content is focused on rigorous and advanced quantitative methods for the pricing and hedging of counterparty credit and funding risk. The new general theory that is required for this methodology is developed from scratch, leading to a consistent and comprehensive framework for counterparty credit and funding risk, inclusive of collateral, netting rules, possible debit valuation adjustments, re-hypothecation and closeout rules. The book however also looks at quite practical problems, linking particular models to particular ‘concrete’ financial situations across asset classes, including interest rates, FX, commodities, equity, credit itself, and the emerging asset class of longevity. The authors also aim to help quantitative analysts, traders, and anyone else needing to frame and price counterparty credit and funding risk, to develop a ‘feel’ for applying sophisticated mathematics and stochastic calculus to solve practical problems. The main models are illustrated from theoretical formulation to final implementation with calibration to market data, always keeping in mind the concrete questions being dealt with. The authors stress that each model is suited to different situations and products, pointing out that there does not exist a single model which is uniformly better than all the others, although the problems originated by counterparty credit and funding risk point in the direction of global valuation. Finally, proposals for restructuring counterparty credit risk, ranging from contingent credit default swaps to margin lending, are considered.

A step-by-step, real world guide to the use of Value at Risk (VaR) models, this text applies the VaR approach to the measurement of market risk, credit risk and operational risk. The book describes and critiques proprietary models, illustrating them with practical examples drawn from actual case studies. Explaining the logic behind the economics and statistics, this technically sophisticated yet intuitive text should be an essential resource for all readers operating in a world of risk. Applies the Value at Risk approach to market, credit, and operational risk measurement. Illustrates models with real-world case studies. Features coverage of BIS bank capital requirements.

Presents systems-based theory, methodology, and applications in risk modeling, assessment, and management This book examines risk analysis, focusing on quantifying risk and constructing probabilities for real-world decision-making, including engineering, design, technology, institutions, organizations, and policy. The author presents fundamental concepts (hierarchical holographic modeling; state space; decision analysis; multi-objective trade-off analysis) as well as advanced material (extreme events and the partitioned multi-objective risk method; multi-objective decision trees; multi-objective risk impact analysis method; guiding principles in risk analysis); avoids higher mathematics whenever possible; and reinforces the material with examples and case studies. The book will be used in systems engineering, enterprise risk management, engineering management, industrial engineering, civil engineering, and operations research. The fourth edition of Risk Modeling, Assessment, and Management features: Expanded chapters on systems-based guiding principles for risk modeling, planning, assessment, management, and communication; modeling interdependent and interconnected complex systems of systems with phantom system models; and hierarchical holographic modeling An expanded appendix including a Bayesian analysis for the prediction of chemical carcinogenicity, and the Farmer’s Dilemma formulated and solved using a deterministic linear model Updated case studies including a new case study on sequential Pareto-optimal decisions for emergent complex systems of systems A new companion website with over 200 solved exercises that feature risk analysis theories, methodologies, and application Risk Modeling, Assessment, and Management, Fourth Edition, is written for both undergraduate and graduate students in systems engineering and systems management courses. The text also serves as a resource for academic, industry, and government professionals in the fields of homeland and cyber security, healthcare, physical infrastructure systems, engineering, business, and more.