A Fast Track To Structured Finance Modeling, Monitoring and Valuation

Jump Start VBA
Author: William Preinitz
Publisher: John Wiley & Sons
ISBN: 9780470446065
Category: Business & Economics
Page: 560
View: 4436

Continue Reading →

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

e-Study Guide for A Fast-Track to Structured Finance: Modeling, Monitoring and Valuation - Jump Start VBA, textbook by William Preinitz


Author: Cram101 Textbook Reviews
Publisher: Cram101 Textbook Reviews
ISBN: 1467208639
Category: Education
Page: 3
View: 4244

Continue Reading →

Never Highlight a Book Again! Just the FACTS101 study guides give the student the textbook outlines, highlights, practice quizzes and optional access to the full practice tests for their textbook.

Intermediate Structured Finance Modeling

Leveraging Excel, VBA, Access, and PowerPoint
Author: William Preinitz,Matthew Niedermaier
Publisher: John Wiley & Sons Incorporated
ISBN: N.A
Category: Computers
Page: 995
View: 2936

Continue Reading →

This book is written for financial analysts who have a working knowledge of Excel and VBA and who wish to enhance their marketability by improving their modeling expertise. The goal of the book is to broaden the reader’s VBA skills and at the same time to progressively integrate Access, PowerPoint, and Outlook into an existing model. Significant attention is also directed to the design and execution of an Excel/VBA interface employing detailed UserForms. In addition, the construction of various reports, first in Excel, then Access, and finally PowerPoint is undertaken. Regardless of your area of financial expertise, this book serves as an essential guide to mastering leveraging the effects of Microsoft products in whatever applications you choose to build. The focus of the book is a case study containing a structured finance model. The case study model was originally designed for the securitization of a portfolio of commercial small business loans. This model now needs to be expanded to securitize a much larger portfolio of residential mortgages. The Original Structuring model will be bifurcated into a Sources of Funds model, the assets of the collateral pool, and a Uses of Funds model, the liabilities waterfall model. This will give the reader experience working with an existing model as a base departure point of development rather than the less common “start from scratch” approach. Once the Base Asset Model (BAM) and the Base Liabilities Models (BLM) are complete, each model will serve as the platform for future development. From the BAM and BLM a pair of much more robust models, the Collateral Cash Flow Generator (CCFG) and the Liabilities Waterfall Model (LWM), respectively, are created. The CCFG is designed to process a significantly greater quantity, variety, and complexity of collateral types. It also introduces the analyst to Geographic based prepayment methods as well as those using Financial/Demographic factor approaches. The LWM, operating independently of the CCFG, reads the collateral cash flow scenarios and applies them across a two tiered, six tranche bond structure. The liabilities waterfall contains provision for an interest rate swap, performance triggers and a variety of other credit enhancement features. With the CCFG and LWM now complete Access is introduced. Access will replace various Excel/VBA code modules in the CCFG such as the collateral data management, data scrubbing and reporting, data sufficiency testing, and eligibility screening. Access is also employed to export and the various collateral cash flows. In the LWM Access is used to import the cash flows, store the liability structure specifications, and export/save the resultant structure performance. PowerPoint is then introduced in the CCFG to allow for the fully automated production of presentation report packages. Last Outlook is added to the models to inform the analyst of model performance and to automatically distribute the various report packages to pre-designated mailing lists. The book contains over 750 exhibits of reports, menus, calculation, and algorithmic examples and most of all code. The complete Excel, VBA, Access, PowerPoint, and Outlook code for all of the models is included on the Web site. The Web site also includes Web chapters containing detailed instructions on how to create and populate a directory environment to store this code, run the models, and organize the results. Lastly there are other Web chapters containing supplemental information explaining the structure and function of the original model, bond and mortgage math (with calculation examples), representative line generator programs, and a tutorial on the construction and integration of UserForms. This book is the intermediate level companion volume to A Fast-Track to Structured Finance Modeling, Monitoring, and Valuation: Jump Start VBA; Preinitz; Wiley 2009, an introductory work on the subject.

Modeling Structured Finance Cash Flows with Microsoft?Excel

A Step-by-Step Guide
Author: Keith A. Allman
Publisher: John Wiley & Sons
ISBN: 9781118044667
Category: Business & Economics
Page: 199
View: 9740

Continue Reading →

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.

A Fast-Track to Structured Finance, Modeling, Monitoring and Valuation - Jump Start VBA


Author: CTI Reviews
Publisher: Cram101 Textbook Reviews
ISBN: 1497008891
Category: Education
Page: 45
View: 2319

Continue Reading →

Facts101 is your complete guide to A Fast-Track to Structured Finance, Modeling, Monitoring and Valuation - Jump Start VBA. In this book, you will learn topics such as as those in your book plus much more. With key features such as key terms, people and places, Facts101 gives you all the information you need to prepare for your next exam. Our practice tests are specific to the textbook and we have designed tools to make the most of your limited study time.

Cash CDO Modelling in Excel

A Step by Step Approach
Author: Darren Smith,Pamela Winchie
Publisher: John Wiley & Sons
ISBN: 0470971673
Category: Business & Economics
Page: 354
View: 4802

Continue Reading →

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. A CD-ROM containing these Excel examples will accompany the book.

Elements of Structured Finance


Author: Ann Rutledge,Sylvain Raynes
Publisher: Oxford University Press
ISBN: 0195179986
Category: Biography & Autobiography
Page: 682
View: 5242

Continue Reading →

The discipline of securitization, almost twenty years old, has become a pervasive element of modern financial management. Yet, it has not been systematically covered in a textbook designed for both the school and workplace contexts. Elements of Structured Finance, the text version of a program of instruction in structured finance that the authors have offered at NYU and Hong Kong University, as well as in private training programs and consultancies, fills this void spectacularly.

Structured Products and Related Credit Derivatives

A Comprehensive Guide for Investors
Author: Brian P. Lancaster,Glenn M. Schultz,Frank J. Fabozzi
Publisher: John Wiley & Sons
ISBN: 9780470369234
Category: Business & Economics
Page: 528
View: 9582

Continue Reading →

Filled with the insights of numerous experienced contributors, Structured Products and Related Credit Derivatives takes a detailed look at the various aspects of structured assets and credit derivatives. Written over a period spanning the greatest bull market in structured products history to arguably its most challenging period, this reliable resource will help you identify the opportunities and mitigate the risks in this complex financial market.

Structured Finance and Insurance

The ART of Managing Capital and Risk
Author: Christopher L. Culp
Publisher: John Wiley & Sons
ISBN: 1118160991
Category: Business & Economics
Page: 892
View: 4291

Continue Reading →

Praise for Structured Finance & Insurance "More and more each year, the modern corporation must decide what risks to keep and what risks to shed to remain competitive and to maximize its value for the capital employed. Culp explains the theory and practice of risk transfer through either balance sheet mechanism such as structured finance, derivative transactions, or insurance. Equity is expensive and risk transfer is expensive. As understanding grows, and, as a result, costs continue to fall, ART will continue to replace equity as the means to cushion knowable risks. This book enhances our understanding of ART." --Myron S. Scholes, Frank E. Buck Professor of Finance, Emeritus, Graduate School of Business, Stanford University "A must-read for everyone offering structured finance as a business, and arguably even more valuable to any one expected to pay for such service." --Norbert Johanning, Managing Director, DaimlerChrysler Financial Services "Culp's latest book provides a comprehensive account of the most important financing and risk management innovations in both insurance and capital markets. And it does so by fitting these innovative solutions and products into a single, unified theory of financial markets that integrates the once largely separate disciplines of insurance and risk management with the current theory and practice of corporate finance." --Don Chew, Editor, Journal of Applied Corporate Finance (a Morgan Stanley publication) "This exciting book is a comprehensive read on alternative insurance solutions available to corporations. It focuses on the real benefits, economical and practical, of alternatives such as captives, rent-a-captive, and mutuals. An excellent introduction to the very complex field of alternative risk transfer (ART)." --Paul Wohrmann, PhD, Head of the Center of Excellence ART and member of theExecutive Management of Global Corporate in Europe, Zurich Financial Services "Structured Finance and Insurance transcends Silos to reach the Enterprise Mountaintop. Culp superbly details integrated, captive, multiple triggers and capital market products, and provides the architectural blueprints for enterprise risk innovation." --Paul Wagner, Director, Risk Management, AGL Resources Inc.

Structured Finance Modeling with Object-Oriented VBA


Author: Evan Tick
Publisher: John Wiley & Sons
ISBN: 1118160665
Category: Business & Economics
Page: 352
View: 4075

Continue Reading →

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.

Collateralized Debt Obligations and Structured Finance

New Developments in Cash and Synthetic Securitization
Author: Janet M. Tavakoli
Publisher: John Wiley & Sons
ISBN: 9780471481362
Category: Business & Economics
Page: 352
View: 9560

Continue Reading →

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

Reverse Engineering Deals on Wall Street with Microsoft Excel + Website

A Step-by-Step Guide
Author: Keith A. Allman
Publisher: John Wiley & Sons
ISBN: 0470472154
Category: Business & Economics
Page: 224
View: 5450

Continue Reading →

A serious source of information for those looking to reverse engineer business deals It’s clear from the current turbulence on Wall Street that the inner workings of its most complex transactions are poorly understood. Wall Street deals parse risk using intricate legal terminology that is difficult to translate into an analytical model. Reverse Engineering Deals on Wall Street: A Step-By-Step Guide takes readers through a detailed methodology of deconstructing the public deal documentation of a modern Wall Street transaction and applying the deconstructed elements to create a fully dynamic model that can be used for risk and investment analysis. Appropriate for the current market climate, an actual residential mortgage backed security (RMBS) transaction is taken from prospectus to model by the end of the book. Step by step, Allman walks the reader through the reversing process with textual excerpts from the prospectus and discussions on how it directly transfers to a model. Each chapter begins with a discussion of concepts with exact references to an example prospectus, followed by a section called "Model Builder," in which Allman translates the theory into a fully functioning model for the example deal. Also included is valuable VBA code and detailed explanation that shows proper valuation methods including loan level amortization and full trigger modeling. Aside from investment analysis this text can help anyone who wants to keep track of the competition, learn from others public transactions, or set up a system to audit one’s own models. Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

The Handbook of Structured Finance


Author: Arnaud de Servigny,Norbert Jobst
Publisher: McGraw Hill Professional
ISBN: 0071508848
Category: Business & Economics
Page: 500
View: 7995

Continue Reading →

Structured finance is a $2 trillion market used by all major institutional investors Both authors are highly regarded structured finance experts from Standard & Poor’s Features Standard & Poor’s exclusive techniques in default risk models and cash-flow models

Introduction to Structured Finance


Author: Frank J. Fabozzi,Henry A. Davis,Moorad Choudhry
Publisher: John Wiley & Sons
ISBN: 0470107804
Category: Business & Economics
Page: 400
View: 6960

Continue Reading →

Created by the experienced author team of Frank Fabozzi, Henry Davis, and Moorad Choudhry, Introduction to Structured Finance examines the essential elements of this discipline. It is a convenient reference guide—which covers all the important transaction types in one place—and an excellent opportunity to enhance your understanding of finance.

Implementing Models of Financial Derivatives

Object Oriented Applications with VBA
Author: Nick Webber
Publisher: John Wiley & Sons
ISBN: 0470661844
Category: Business & Economics
Page: 692
View: 7040

Continue Reading →

Implementing Models of Financial Derivatives is a comprehensive treatment of advanced implementation techniques in VBA for models of financial derivatives. Aimed at readers who are already familiar with the basics of VBA it emphasizes a fully object oriented approach to valuation applications, chiefly in the context of Monte Carlo simulation but also more broadly for lattice and PDE methods. Its unique approach to valuation, emphasizing effective implementation from both the numerical and the computational perspectives makes it an invaluable resource. The book comes with a library of almost a hundred Excel spreadsheets containing implementations of all the methods and models it investigates, including a large number of useful utility procedures. Exercises structured around four application streams supplement the exposition in each chapter, taking the reader from basic procedural level programming up to high level object oriented implementations. Written in eight parts, parts 1-4 emphasize application design in VBA, focused around the development of a plain Monte Carlo application. Part 5 assesses the performance of VBA for this application, and the final 3 emphasize the implementation of a fast and accurate Monte Carlo method for option valuation. Key topics include: ?Fully polymorphic factories in VBA; ?Polymorphic input and output using the TextStream and FileSystemObject objects; ?Valuing a book of options; ?Detailed assessment of the performance of VBA data structures; ?Theory, implementation, and comparison of the main Monte Carlo variance reduction methods; ?Assessment of discretization methods and their application to option valuation in models like CIR and Heston; ?Fast valuation of Bermudan options by Monte Carlo. Fundamental theory and implementations of lattice and PDE methods are presented in appendices and developed through the book in the exercise streams. Spanning the two worlds of academic theory and industrial practice, this book is not only suitable as a classroom text in VBA, in simulation methods, and as an introduction to object oriented design, it is also a reference for model implementers and quants working alongside derivatives groups. Its implementations are a valuable resource for students, teachers and developers alike. Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

The Mechanics of Securitization

A Practical Guide to Structuring and Closing Asset-Backed Security Transactions
Author: Moorad Choudhry
Publisher: John Wiley & Sons
ISBN: 1118234545
Category: Business & Economics
Page: 208
View: 8628

Continue Reading →

A step-by-step guide to implementing and closing securitization transactions Securitization is still in wide use despite the reduction in transactions. The reality is that investors and institutions continue to use this vehicle for raising funds and the demand for their use will continue to rise as the world's capital needs increase. The Mechanics of Securitization specifically analyzes and describes the process by which a bank successfully implements and closes a securitization transaction in the post subprime era. This book begins with an introduction to asset-backed securities and takes you through the historical impact of these transactions including the implications of the recent credit crisis and how the market has changed. Discusses, in great detail, rating agency reviews, liaising with third parties, marketing the deals, and securing investors Reviews due diligence and cash flow analysis techniques Examines credit and cash considerations as well as how to list and close deals Describes the process by which a bank will structure and implement the deal, and how the process is project managed and tested across internal bank departments While securitization transactions have been taking place for over twenty-five years, there is still a lack of information on exactly how they are processed successfully. This book will put you in a better position to understand how it all happens, and show you how to effectively implement an ABS transaction yourself.

Using Excel for Business Analysis

A Guide to Financial Modelling Fundamentals
Author: Danielle Stein Fairhurst
Publisher: John Wiley & Sons
ISBN: 1119062454
Category: Business & Economics
Page: 464
View: 5813

Continue Reading →

Utilise Excel 2013 capabilities to build effective financial models Using Excel for Business Analysis, Revised Edition provides practical guidance for anyone looking to build financial models. Whether for business proposals, opportunity evaluation, financial reports, or any other business finance application, this book shows you how to design, create, and test your model, then present your results effectively using Excel 2013. The book opens with a general guide to financial modelling, with each subsequent chapter building skill upon skill until you have a real, working model of your own. Financial tools, features, and functions are covered in detail from a practical perspective, and put in context with application to real-world examples. Each chapter focuses on a different aspect of Excel modelling, including step-by-step instructions that walk you through each feature, and the companion website provides live model worksheets that give you the real hands-on practice you need to start doing your job faster, more efficiently, and with fewer errors. Financial modelling is an invaluable business tool, and Excel 2013 is capable of supporting the most common and useful models most businesses need. This book shows you how to dig deeper into Excel's functionality to craft effective financial models and provide important information that informs good decision-making. Learn financial modelling techniques and best practice Master the formulas and functions that bring your model to life Apply stress testing and sensitivity analysis with advanced conditionals Present your results effectively, whether graphically, orally, or written A deceptively powerful application, Excel supports many hundreds of tools, features, and functions; Using Excel for Business Analysis eliminates the irrelevant to focus on those that are most useful to business finance users, with detailed guidance toward utilisation and best practice.

The Handbook of Financial Modeling

A Practical Approach to Creating and Implementing Valuation Projection Models
Author: Jack Avon
Publisher: Apress
ISBN: 1430262052
Category: Business & Economics
Page: 504
View: 2959

Continue Reading →

The ability to create and understand financial models that assess the valuation of a company, the projects it undertakes, and its future earnings/profit projections is one of the most valued skills in corporate finance. However, while many business professionals are familiar with financial statements and accounting reports, few are truly proficient at building an accurate and effective financial model from the ground up. That's why, in The Financial Modeling Handbook, Jack Avon equips financial professionals with all the tools they need to precisely and effectively monitor a company's assets and project its future performance. Based on the author's extensive experience building models in business and finance—and teaching others to do the same—The Handbook of Financial Modeling takes readers step by step through the financial modeling process, starting with a general overview of the history and evolution of financial modeling. It then moves on to more technical topics, such as the principles of financial modeling and the proper way to approach a financial modeling assignment, before covering key application areas for modeling in Microsoft Excel. Designed for intermediate and advanced modelers who wish to expand and enhance their knowledge, The Handbook of Financial Modeling also covers: The accounting and finance concepts that underpin working financial models; How to approach financial issues and solutions from a modeler's perspective; The importance of thinking about end users when developing a financial model; How to plan, design, and build a fully functional financial model; And more. A nuts-to-bolts guide to solving common financial problems with spreadsheets, The Handbook of Financial Modeling is a one-stop resource for anyone who needs to build or analyze financial models. What you’ll learn Key financial modeling principles, including best practices, principles around calculations, and the importance of producing clean, clear financial models How to design and implement a projection model that allows the user to change inputs quickly for sensitivity testing The proper way to approach a financial modeling assignment, from project planning all the way through to the documentation of the model's findings and effectiveness How to model in Microsoft Excel, including how to set up an Excel environment, how to format worksheets, and the correct application of various modeling formulae The skills and knowledge they need to become more proficient financial modelers and differentiate themselves from their professional competitors. Who this book is for Written in a clear, concise manner and filled with screen grabs that will facilitate readers' comprehension of the financial modeling process, The Handbook of Financial Modeling is appropriate for intermediate to advanced financial modelers who are looking to learn how to enhance their modeling proficiency. Table of Contents Financial Modeling: An Overview Financial Modeling Best Practices Modeling Functions and Tools Planning Your Model Testing and Documenting Your Model Designing and Building Your Model The Model User: Inputs An Introduction to Finance and Accounting for Modelers Managing and Evaluating a Business for Modelers The Implications and Rules of Accounting for Modelers Financial Based Calculations Logical and Structural Based Calculations How to Capture Document and Track Assumptions in Your Model Modeling to Give the User Transparency Model Testing and Auditing Modeling Handover Dos and Don'ts. Case Study: Building a Full Life Cycle Model Additional Tools and VBA for Financial Models What is the Future of Financial Modeling? Keyboard Shortcuts Finance and Accounting Glossary Readymade Functions Sample Outputs Housekeeping References