Structured Finance Modeling with Object-Oriented VBA

Evan Tick

ISBN 10: 0470098597 / ISBN 13: 9780470098592

Published by Wiley Mai 2007, 2007

About this Item

Neuware - Praise for STRUCTURED FINANCE MODELING with Object-Oriented VBA'This book is an excellent and interesting integration of financial engineering, structured finance, and structured programming, and the book accomplishes this with easy-to-follow examples, using the most commonly available tools, MS VBA and spreadsheets. The author is clearly intimately familiar with structured products, the mechanics and challenges of securitization, and the financial and analytical modeling that is required to understand and manage these diverse financial products. The result is a book that demonstrates an easy-to-follow combination of finance and object-oriented programming. This is a 'must own book' for the active practitioner, the financial engineer on the front lines of the structuring battle.'-Cyrus Mohebbi, PhD, Head of MBS/ABS Structuring and Analytics, HSBC Securities Inc.'Tick has written a seminal structured finance book. He presents an approach to modeling that is both efficient and practical. His work will serve as a timeless template to simplify the complexity of structured finance.'-Janet Tavakoli, President, Tavakoli Structured Finance'Dr. Tick's experience in applying theoretical concepts to various markets is well encapsulated in this book. A must-read for technicians and market practitioners alike who would like insight into practical solutions to complex financial modeling problems.'-Adil Nathani, Old Lane Management'Reading Tick's book gives a real-world introduction to practical bond structuring, the activity that generates a significant part of Wall Street's profits. This book from a (financial) engineer who is intimately involved in this business, gives the details needed to generate accurate cash flows along with meticulously presented real-life examples. In addition to meat-and-potatoes asset and liability cash flows, he discusses optimization and stochastic modeling, a useful introduction to synthetic structures. This book also serves as an introduction to programming skills in VBA.'-Ramine Rouhani, Managing Director, Head of Capital Markets, IXIS Capital Markets North America.

Seller Inventory # 9780470098592

Bibliographic Details

• Title: Structured Finance Modeling with Object-Oriented VBA
• Publisher: Wiley Mai 2007
• Publication Date: 2007
• Language: English
• ISBN 10: 0470098597
• ISBN 13: 9780470098592
• Binding: Buch
• Condition: Neu
• Dimensions: 228W x 161H x 31D millimeters 228 millimeters width by 161 millimeters height by 31 millimeters depth
• Weight: 540 grams

About this title

Synopsis

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.

About the Author

Evan Tick is a director at IXIS Capital Markets, and has worked on Wall Street for ten years. His expertise is fixed income and structured finance modeling in the areas of risk management, asset-backed securities (ABS), residential mortgages, and credit derivatives.