Cash CDO Modelling in Excel

Cash CDO Modelling in Excel
Author: Darren Smith
Publisher: John Wiley & Sons
Total Pages: 357
Release: 2011-12-07
Genre: Business & Economics
ISBN: 0470971673

This book is an introduction to the modelling of cash collateralised debt obligations (“CDOs”). It is intended that the reader have a basic understanding of CDOs and a basic working knowledge of Microsoft Office Excel. There will be written explanations of concepts along with understandable mathematical explanations and examples provided in Excel.

Financial Simulation Modeling in Excel

Financial Simulation Modeling in Excel
Author: Keith A. Allman
Publisher: John Wiley & Sons
Total Pages: 220
Release: 2011-09-02
Genre: Business & Economics
ISBN: 1118137221

"I've worked with simulation in business for over 20 years, and Allman really nails it with this book. I admit that I own his previous book on structured finance cash flows, but I was surprised by what I found in here. He addresses the fundamental questions of how decision makers react to simulations and his read was very much in accordance with what I've experienced myself. When it came to the nuts and bolts of describing the different types of simulation analysis the book becomes incredibly detailed. There is working code and models for a fantastic array of the most common simulation problems. If you're so inclined, the book very carefully steps through the tricky math needed to really understand the theory behind stochastic modeling in finance. If you're preparing models that include any kind of randomization or stochastic modeling component, this book is a must-read, a tremendous value and time-saver." — David Brode of The Brode Group A practical guide to understanding and implementing financial simulation modeling As simulation techniques become more popular among the financial community and a variety of sub-industries, a thorough understanding of theory and implementation is critical for practitioners involved in portfolio management, risk management, pricing, and capital budgeting. Financial Simulation Modeling in Excel contains the information you need to make the most informed decisions possible in your professional endeavors. Financial Simulation Modeling in Excel contains a practical, hands-on approach to learning complex financial simulation methodologies using Excel and VBA as a medium. Crafted in an easy to understand format, this book is suitable for anyone with a basic understanding of finance and Excel. Filled with in-depth insights and expert advice, each chapter takes you through the theory behind a simulation topic and the implementation of that same topic in Excel/VBA in a step-by-step manner. Organized in an easy-to-follow fashion, this guide effectively walks you through the process of creating and implementing risk models in Excel A companion website contains all the Excel models risk experts and quantitative analysts need to practice and confirm their results as they progress Keith Allman is the author of other successful modeling books, including Corporate Valuation Modeling and Modeling Structured Finance Cash Flows with Microsoft Excel Created for those with some background in finance and experience in Excel, this reliable resource shows you how to effectively perform sound financial simulation modeling, even if you've yet to do extensive modeling up to this point in your professional or academic career.

Correlation Risk Modeling and Management

Correlation Risk Modeling and Management
Author: Gunter Meissner
Publisher: John Wiley & Sons
Total Pages: 268
Release: 2013-12-19
Genre: Business & Economics
ISBN: 1118796896

A thorough guide to correlation risk and its growing importance in global financial markets Ideal for anyone studying for CFA, PRMIA, CAIA, or other certifications, Correlation Risk Modeling and Management is the first rigorous guide to the topic of correlation risk. A relatively overlooked type of risk until it caused major unexpected losses during the financial crisis of 2007 through 2009, correlation risk has become a major focus of the risk management departments in major financial institutions, particularly since Basel III specifically addressed correlation risk with new regulations. This offers a rigorous explanation of the topic, revealing new and updated approaches to modelling and risk managing correlation risk. Offers comprehensive coverage of a topic of increasing importance in the financial world Includes the Basel III correlation framework Features interactive models in Excel/VBA, an accompanying website with further materials, and problems and questions at the end of each chapter

Wall Street and the Financial Crisis

Wall Street and the Financial Crisis
Author: United States. Congress. Senate. Committee on Homeland Security and Governmental Affairs. Permanent Subcommittee on Investigations
Publisher:
Total Pages: 1852
Release: 2011
Genre: Financial crises
ISBN:

Structured Finance Modeling with Object-Oriented VBA

Structured Finance Modeling with Object-Oriented VBA
Author: Evan Tick
Publisher: John Wiley & Sons
Total Pages: 278
Release: 2011-07-28
Genre: Business & Economics
ISBN: 1118160665

A detailed look at how object-oriented VBA should be used to model complex financial structures This guide helps readers overcome the difficult task of modeling complex financial structures and bridges the gap between professional C++/Java programmers writing production models and front-office analysts building Excel spreadsheet models. It reveals how to model financial structures using object-oriented VBA in an Excel environment, allowing desk-based analysts to quickly produce flexible and robust models. Filled with in-depth insight and expert advice, it skillfully illustrates the art of object-oriented programming for the explicit purpose of modeling structured products. Residential mortgage securitization is used as a unifying example throughout the text.

Modeling Structured Finance Cash Flows with Microsoft Excel

Modeling Structured Finance Cash Flows with Microsoft Excel
Author: Keith A. Allman
Publisher: John Wiley & Sons
Total Pages: 230
Release: 2010-12-28
Genre: Business & Economics
ISBN: 1118044665

A practical guide to building fully operational financial cash flow models for structured finance transactions Structured finance and securitization deals are becoming more commonplace on Wall Street. Up until now, however, market participants have had to create their own models to analyze these deals, and new entrants have had to learn as they go. Modeling Structured Finance Cash Flows with Microsoft Excel provides readers with the information they need to build a cash flow model for structured finance and securitization deals. Financial professional Keith Allman explains individual functions and formulas, while also explaining the theory behind the spreadsheets. Each chapter begins with a discussion of theory, followed by a section called "Model Builder," in which Allman translates the theory into functions and formulas. In addition, the companion website features all of the modeling exercises, as well as a final version of the model that is created in the text. Note: Companion website and other supplementary materials are not included as part of eBook file.

Modeling Derivatives Applications in Matlab, C++, and Excel

Modeling Derivatives Applications in Matlab, C++, and Excel
Author: Justin London
Publisher: Financial Times/Prentice Hall
Total Pages: 608
Release: 2007
Genre: Business & Economics
ISBN:

Hundreds of financial institutions now market complex derivatives; thousands of financial and technical professionals need to model them accurately and effectively. This volume brings together proven, tested real-time models for each of todays leading modeling platforms to help professionals save months of development time, while improving the accuracy and reliability of the models they create.

Collateralized Debt Obligations

Collateralized Debt Obligations
Author: Douglas J. Lucas
Publisher: John Wiley & Sons
Total Pages: 533
Release: 2006-05-05
Genre: Business & Economics
ISBN: 0471718874

Since first edition's publication, the CDO market has seen tremendous growth. As of 2005, $1.1 trillion of CDOs were outstanding -- making them the fastest-growing investment vehicle of the last decade. To help you keep up with this expanding market and its various instruments, Douglas Lucas, Laurie Goodman, and Frank Fabozzi have collaborated to bring you this fully revised and up-to-date new edition of Collateralized Debt Obligations. Written in a clear and accessible style, this valuable resource provides critical information regarding the evolving nature of the CDO market. You'll find in-depth insights gleaned from years of investment and credit experience as well as the examination of a wide range of issues, including cash CDOs, loans and CLOs, structured finance CDOs and collateral review, emerging market and market value CDOs, and synthetic CDOs. Use this book as your guide and take advantage of this dynamic market and its products.

Bank Asset and Liability Management

Bank Asset and Liability Management
Author: Moorad Choudhry
Publisher: John Wiley & Sons
Total Pages: 1444
Release: 2011-12-27
Genre: Business & Economics
ISBN: 1118177215

Banks are a vital part of the global economy, and the essence of banking is asset-liability management (ALM). This book is a comprehensive treatment of an important financial market discipline. A reference text for all those involved in banking and the debt capital markets, it describes the techniques, products and art of ALM. Subjects covered include bank capital, money market trading, risk management, regulatory capital and yield curve analysis. Highlights of the book include detailed coverage of: Liquidity, gap and funding risk management Hedging using interest-rate derivatives and credit derivatives Impact of Basel II Securitisation and balance sheet management Structured finance products including asset-backed commercial paper, mortgage-backed securities, collateralised debt obligations and structured investment vehicles, and their role in ALM Treasury operations and group transfer pricing. Concepts and techniques are illustrated with case studies and worked examples. Written in accessible style, this book is essential reading for market practitioners, bank regulators, and graduate students in banking and finance. Companion website features online access to software on applications described in the book, including a yield curve model, cubic spline spreadsheet calculator and CDO waterfall model.