Structured Finance Modeling with Object-Oriented VBA PDF Download

Author: Evan Tick
Publisher: John Wiley & Sons
ISBN: 1118160665
Category : Business & Economics
Languages : en
Pages : 278

View

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

Author: Keith A. Allman
Publisher: John Wiley & Sons
ISBN: 1118044665
Category : Business & Economics
Languages : en
Pages : 230

View

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

Author: William Preinitz
Publisher: Wiley
ISBN: 9780470398128
Category : Business & Economics
Languages : en
Pages : 744

View

Book Description
This book is designed to start with simple examples that progressively develop the reader's confidence to take on more complex tasks. There is very little theoretical discussion about computer science, operations research algorithms, mathematics, or finance. The thrust of the book is to teach the reader to break complex tasks down into simple tasks. It then looks to implement those simple tasks into VBA code using a critical subset of the features of the language. The tentative contents is: (1) Why? What? Who? Where? and How? (2) Common Sense (3) Securitizing A Loan Portfolio (4) Understanding the Excel Waterfall (5) Designing the VBA Model (6) Laying the Model Groundwork (7) Recorded Macros: A First Look at the VBA Language (8) Writing Menus: An Introduction to Data, Ranges, Arrays, and Objects (9) Controlling the Flow of the Model (10) Building Messaging Capabilities (11) Designing the Model’s Reports (12) Main Program and Menus (13) Writing the Collateral Selection Code (14) Calculating the Cash Flows (15) Running the Waterfall: Producing Initial Results (16) Debugging the Model (17) Validating the Model (18) Running the Model (19) Building Additional Capabilities (20) Documentation of the Model (21) Managing the Growth of the Model (22) Building Portfolio Monitoring Model (23) Valuation Techniques: How do we Determine Price? (24) Challenging Times For the Deal (25) Parting Admonitions

Author: Paul Darbyshire
Publisher: John Wiley & Sons
ISBN: 111994564X
Category : Business & Economics
Languages : en
Pages : 294

View

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

Author: Daniel J. Duffy
Publisher: John Wiley & Sons
ISBN: 0470030089
Category : Business & Economics
Languages : en
Pages : 866

View

Book Description
A practice-oriented guide to using C# to design and program pricing and trading models In this step-by-step guide to software development for financial analysts, traders, developers and quants, the authors show both novice and experienced practitioners how to develop robust and accurate pricing models and employ them in real environments. Traders will learn how to design and implement applications for curve and surface modeling, fixed income products, hedging strategies, plain and exotic option modeling, interest rate options, structured bonds, unfunded structured products, and more. A unique mix of modern software technology and quantitative finance, this book is both timely and practical. The approach is thorough and comprehensive and the authors use a combination of C# language features, design patterns, mathematics and finance to produce efficient and maintainable software. Designed for quant developers, traders and MSc/MFE students, each chapter has numerous exercises and the book is accompanied by a dedicated companion website, www.datasimfinancial.com/forum/viewforum.php?f=196&sid=f30022095850dee48c7db5ff62192b34, providing all source code, alongside audio, support and discussion forums for readers to comment on the code and obtain new versions of the software.

Author: Mary Jackson
Publisher: John Wiley & Sons
ISBN: 0470061669
Category : Business & Economics
Languages : en
Pages : 278

View

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

Author: Markus Krebsz
Publisher: John Wiley & Sons
ISBN: 0470662123
Category : Business & Economics
Languages : en
Pages : 594

View

Book Description
In this book, you will be introduced to generic best practice principles for a post credit crunch market. First, the book takes a closer look at the reasons why the market froze during the 2007 to 2009 credit crisis. Then you will learn how to use the principles explained here in your generic deal's typical life cycle stages. Throughout, each stage is discussed in detail, from strategy and feasibility, pre-close, at close, and post close. The final section of the book contains a toolbox of references, tables, dictionaries, and resources.

Author: Chandan Sengupta
Publisher: John Wiley & Sons
ISBN: 9780471267683
Category : Business & Economics
Languages : en
Pages : 680

View

Book Description
"Reviews all the necessary financial theory and concepts, and walks you through a wide range of real-world financial models" - cover.

Author: Fabrice D. Rouah
Publisher: John Wiley & Sons
ISBN: 1118429206
Category : Business & Economics
Languages : en
Pages : 456

View

Book Description
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

Author: Janet M. Tavakoli
Publisher: John Wiley & Sons
ISBN: 047148136X
Category : Business & Economics
Languages : en
Pages : 354

View

Book Description
The most cutting-edge read on CDO and credit market structures Collateralized Debt Obligations and Structured Finance provides a state-of-the-art look at the exploding CDO and structured credit products market. Financial expert Janet Tavakoli examines securitization topics never before seen in print, including the huge increase in the CDO arbitrage created by synthetics; the tranches most at risk from this new technology; dumping securitizations on bank balance sheets; the abuse of offshore vehicles by companies such as Enron; and securitizations made possible by new securitization techniques and the introduction of the Euro. This valuable guide comprehensively covers one of the fastest growing markets on Wall Street, predicting where new bank regulations and other developments may lead to product growth or product extinction. While providing an overview of the market and its dynamic growth, Collateralized Debt Obligations and Structured Finance explores the types of products offered, hedging techniques, and valuation and risk/return issues associated with investment in CDOs and synthetic CDOs. Janet M. Tavakoli, MBA (Chicago, IL), has over eighteen years of experience trading, structuring, and marketing derivatives and structured products with major financial institutions in New York and London. She is also the author of Credit Derivatives and Synthetic Structures, now in its Second Edition (0-471-41266-X).