PDF Ebook Intermediate Structured Finance Modeling, with Website: Leveraging Excel, VBA, Access, and Powerpoint, by William Preinitz, Matthew Nieder
From the mix of knowledge as well as actions, somebody could boost their ability and ability. It will lead them to live as well as function far better. This is why, the pupils, workers, or even companies must have reading habit for publications. Any book Intermediate Structured Finance Modeling, With Website: Leveraging Excel, VBA, Access, And Powerpoint, By William Preinitz, Matthew Nieder will certainly offer specific knowledge to take all perks. This is just what this Intermediate Structured Finance Modeling, With Website: Leveraging Excel, VBA, Access, And Powerpoint, By William Preinitz, Matthew Nieder tells you. It will certainly add more understanding of you to life and also work better. Intermediate Structured Finance Modeling, With Website: Leveraging Excel, VBA, Access, And Powerpoint, By William Preinitz, Matthew Nieder, Try it and prove it.
Intermediate Structured Finance Modeling, with Website: Leveraging Excel, VBA, Access, and Powerpoint, by William Preinitz, Matthew Nieder
PDF Ebook Intermediate Structured Finance Modeling, with Website: Leveraging Excel, VBA, Access, and Powerpoint, by William Preinitz, Matthew Nieder
Intermediate Structured Finance Modeling, With Website: Leveraging Excel, VBA, Access, And Powerpoint, By William Preinitz, Matthew Nieder How a straightforward concept by reading can enhance you to be a successful individual? Reading Intermediate Structured Finance Modeling, With Website: Leveraging Excel, VBA, Access, And Powerpoint, By William Preinitz, Matthew Nieder is an extremely basic activity. But, exactly how can many people be so lazy to review? They will certainly like to spend their free time to chatting or hanging around. When actually, reading Intermediate Structured Finance Modeling, With Website: Leveraging Excel, VBA, Access, And Powerpoint, By William Preinitz, Matthew Nieder will give you much more possibilities to be successful finished with the efforts.
As recognized, experience as well as experience about session, enjoyment, and expertise can be acquired by just checking out a publication Intermediate Structured Finance Modeling, With Website: Leveraging Excel, VBA, Access, And Powerpoint, By William Preinitz, Matthew Nieder Even it is not directly done, you could understand more about this life, regarding the world. We offer you this correct and very easy method to acquire those all. We provide Intermediate Structured Finance Modeling, With Website: Leveraging Excel, VBA, Access, And Powerpoint, By William Preinitz, Matthew Nieder and numerous book collections from fictions to scientific research at all. Among them is this Intermediate Structured Finance Modeling, With Website: Leveraging Excel, VBA, Access, And Powerpoint, By William Preinitz, Matthew Nieder that can be your companion.
Exactly what should you assume more? Time to get this Intermediate Structured Finance Modeling, With Website: Leveraging Excel, VBA, Access, And Powerpoint, By William Preinitz, Matthew Nieder It is easy after that. You could just rest and stay in your location to obtain this book Intermediate Structured Finance Modeling, With Website: Leveraging Excel, VBA, Access, And Powerpoint, By William Preinitz, Matthew Nieder Why? It is on-line book shop that provide many compilations of the referred books. So, merely with net connection, you could take pleasure in downloading this book Intermediate Structured Finance Modeling, With Website: Leveraging Excel, VBA, Access, And Powerpoint, By William Preinitz, Matthew Nieder and varieties of books that are looked for currently. By going to the web link web page download that we have supplied, the book Intermediate Structured Finance Modeling, With Website: Leveraging Excel, VBA, Access, And Powerpoint, By William Preinitz, Matthew Nieder that you refer so much can be discovered. Just conserve the asked for book downloaded and install and then you could appreciate the book to check out each time as well as area you really want.
It is really simple to review guide Intermediate Structured Finance Modeling, With Website: Leveraging Excel, VBA, Access, And Powerpoint, By William Preinitz, Matthew Nieder in soft data in your device or computer system. Once more, why need to be so difficult to obtain the book Intermediate Structured Finance Modeling, With Website: Leveraging Excel, VBA, Access, And Powerpoint, By William Preinitz, Matthew Nieder if you can pick the easier one? This internet site will certainly reduce you to choose and decide on the best cumulative publications from the most needed seller to the released publication recently. It will always upgrade the compilations time to time. So, attach to internet and see this site constantly to obtain the new publication everyday. Currently, this Intermediate Structured Finance Modeling, With Website: Leveraging Excel, VBA, Access, And Powerpoint, By William Preinitz, Matthew Nieder is all yours.
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.
- Sales Rank: #1857435 in Books
- Published on: 2011-02-08
- Original language: English
- Number of items: 1
- Dimensions: 10.25" h x 2.18" w x 7.40" l, 4.27 pounds
- Binding: Hardcover
- 995 pages
From the Inside Flap
Regardless of your financial specialization, this book is an essential learning tool in leveraging Microsoft products in whatever modeling applications you choose to build. The principles outlined here can be readily employed across all fields of financial and non-financial modeling.
This book is written for financial analysts who have a working knowledge of Excel and VBA and who wish to enhance their productivity and marketability by improving their modeling expertise. The goal of the book is to broaden the reader's Excel/VBA skills and to demonstrate the progressive integration of Access, PowerPoint, and Outlook into a modeling environment. Significant attention is also directed to the design and execution of an Excel/VBA user interface employing complex UserForms.
The focus of the book is a case study containing a structured finance model. An exisiting Excel/VBA model is segregated into separate Asset and Liability Models. These two models are then extensively developed by creating sophisticated UserForm interfaces, expanding computational subroutines, and implementing more elaborate and detailed report packages. Access databases are then incorporated to manage sets of model inputs and results. The capability to automatically produce a ready-to-use PowerPoint presentation is also added. Finally, Outlook is integrated to automate status reporting and distribution of model report packages.
The book contains over 750 exhibits of VBA and Access code, Excel menus and UserForms, as well as financial calculation algorithms and reports. Complete working versions of all models, their input files, and report results are included on the Web site. Other web chapters contain detailed instructions on how to create a directory environment to download and run the models, supplemental bond and mortgage math primers, a discussion of representative line generator programs, and a tutorial on Excel UserForms.
This book is the intermediate-level companion volume to A Fast-Track to Structured Finance Modeling, Monitoring, and Valuation: Jump Start VBA, an introductory work on the subject.
From the Back Cover
A pragmatic, hands-on approach to reaching an intermediate level of sophistication as a financial modeler
Intermediate Structured Finance Modeling is packed with insight and tips to teach you step by step to expand your current level of organizational, coding, modeling, and financial skills to enhance and develop new and more powerful applications. It expertly employs a code-intensive approach to improve your VBA and Excel skills and demonstrates how to integrate them with a real-life application.
Providing you with a set of immediately applicable modeling approaches, techniques, skills, and examples with a focus on large model development, you will learn how to:
- Organize and build a set of directories to contain the model system you will develop
- Separate an existing basic structured finance model into two special-purpose models, an Asset (collateral) model and a Liabilities Structure (bonds) model
- Expand the computational, data management, and reporting capabilities of both new models
- Employ Excel UserForms to build a sophisticated model interfaces
- Introduce Access databases and code to manage model data requirements and outputs
- Dramatically expand existing reporting packages, producing more sophisticated analytical results
- Automate the production of ready-to-use PowerPoint presentations
- Improve your model's ability to distribute its results by integrating Outlook mailing lists
If you have some modeling experience and are confident in your mastery of the fundamental features of VBA and Excel, Intermediate Structured Finance Modeling is the book for you. With working solutions to the challenges of developing larger scale models, you will learn successful intermediate modeling techniques that can be applied to any real-world situation and activity.
This book is the intermediate-level companion volume to A Fast-Track to Structured Finance Modeling, Monitoring, and Valuation: Jump Start VBA, an introductory work on the subject.
About the Author
WILLIAM PREINITZ has thirty years' experience in investment banking and structured finance analytics. A former managing director at Citigroup, highlights of his career include the creation and marketing of securitizations backed by 12b-1 mutual fund fees. With a team of ten people over a fifteen-year period, his group concurrently provided analytical structuring support for the over 100 different asset classes contained in the ABCP program of the bank. These included such varied items as movie revenues, fast-food franchise financing, and communication satellite leasing. In conjunction with the bank's corporate training program, he taught Excel/VBA modeling classes to over 300 people ranging from associates to managing directors.
MATTHEW NIEDERMAIER is currently a vice president in the Structured Finance Group at Markit, where he is a member of a pricing and valuation group focused on agency mortgages and CMOs. Within Markit he has also taught courses in Excel/VBA globally. Prior to Markit he modeled U.S. and Latin American ABS deals at Citigroup, including auto loans, credit cards, and timeshares.
Most helpful customer reviews
4 of 5 people found the following review helpful.
Comprehensive guide for the strong willed
By DL692
Having read Preinitz's first book, A Fast Track To Structured Finance Modeling, Monitoring and Valuation: Jump Start VBA (Wiley Finance), I was already familiar with the existing model that is presented in Chapter 2. This book takes you step by step (literally) through the enhancement of the existing securitization model. Creating an enhanced model that utilizes tools like Access and Powerpoint is quite an involved process. It's not clear how straightforward it would be for someone to encounter this model and run with it without having gone through it in the first book. Preinitz, however, makes a solid effort to light your path by providing detailed explanations throughout the book and many chapters of supplemental material on the accompanying website.
I admit that I was mentally exhausted by the time I finished going through all of the materials. But the level of understanding I gained would have taken much more time (months, years?) to acquire were I to learn on-the-job.
Just reading this book may be informative, but one can only truly understand structured finance transactions by doing. The author has provided an enormous amount of resources and detailed instruction, giving you the responsibility of following through. If you are willing to put in the time, this book is thoroughly rewarding.
2 of 2 people found the following review helpful.
Wonderful book
By Ron
I learned a great deal from this book. It's helpful if you are blessed with a triple digit
IQ. It's important to have the mental wherewithal to understand finance and programming.
2 of 3 people found the following review helpful.
Sure does leverage
By AvidReader
I've read both of Preinitz's books. Each is highly organized and well thought out. This one continues where the contents of the first left off. The original SBA loan portfolio used as an example in the introductory level book is replaced by a larger and more complex asset-backed cash flow model that uses a residential mortgage portfolio. If the user wants to undertake an example of transforming an existing simple model into a more complex one, the first six chapters do just that. If, however, an advanced level reader prefers, one can start directly with Chapter 7.
Preinitz shows how to, by explicit but manageable segments of VBA code, incrementally build an asset and a liability model. As a modeler with a basic VBA background, I can easily interpret the code purely from its nomenclature and standardized approach. The most awesome part of the finished model (provided in the Web site) is the use of aesthetically pleasing UserForms (for input) and the speed and visual impact of automatically produced presentation format reports (for output) using PowerPoint. It's a plus that the instruction and code also uses Access (for database management) and Outlook (for messaging).
The only criticism I can offer is that the reader must be prepared for comprehensive study. There is no superficial quick approach to this author but I can see easily how the techniques, once mastered, can be time-saving after the initial effort is invested. I highly recommend this book. This appears to be a set of modeling techniques developed over a long career that are condensed into one VBA platform.
See all 5 customer reviews...
Intermediate Structured Finance Modeling, with Website: Leveraging Excel, VBA, Access, and Powerpoint, by William Preinitz, Matthew Nieder PDF
Intermediate Structured Finance Modeling, with Website: Leveraging Excel, VBA, Access, and Powerpoint, by William Preinitz, Matthew Nieder EPub
Intermediate Structured Finance Modeling, with Website: Leveraging Excel, VBA, Access, and Powerpoint, by William Preinitz, Matthew Nieder Doc
Intermediate Structured Finance Modeling, with Website: Leveraging Excel, VBA, Access, and Powerpoint, by William Preinitz, Matthew Nieder iBooks
Intermediate Structured Finance Modeling, with Website: Leveraging Excel, VBA, Access, and Powerpoint, by William Preinitz, Matthew Nieder rtf
Intermediate Structured Finance Modeling, with Website: Leveraging Excel, VBA, Access, and Powerpoint, by William Preinitz, Matthew Nieder Mobipocket
Intermediate Structured Finance Modeling, with Website: Leveraging Excel, VBA, Access, and Powerpoint, by William Preinitz, Matthew Nieder Kindle
Intermediate Structured Finance Modeling, with Website: Leveraging Excel, VBA, Access, and Powerpoint, by William Preinitz, Matthew Nieder PDF
Intermediate Structured Finance Modeling, with Website: Leveraging Excel, VBA, Access, and Powerpoint, by William Preinitz, Matthew Nieder PDF
Intermediate Structured Finance Modeling, with Website: Leveraging Excel, VBA, Access, and Powerpoint, by William Preinitz, Matthew Nieder PDF
Intermediate Structured Finance Modeling, with Website: Leveraging Excel, VBA, Access, and Powerpoint, by William Preinitz, Matthew Nieder PDF
![Her Master's Choice [Bound to Please 1] (Siren Publishing Everlasting Classic), by Karen Mercury](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_uUZJ-C69TuRp-VRi0MuJgsjJSCgX4_GgQcVR9yJxyRsTw0GuaOa3bwpRaKZEq2ORV72sGsKAeC2rFc0vH4EKX8bfkXCQP1t43Ifv4ObFUfL9Zbv97-S4KKfaU=s0-d "Her Master's Choice [Bound to Please 1] (Siren Publishing Everlasting Classic), by Karen Mercury")
![Her Master's Choice [Bound to Please 1] (Siren Publishing Everlasting Classic), by Karen Mercury](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_uH2NNtLh-ZyWnI3W916D7rH1dRmKJ8wPX75DQT1s2dkrfAOl_8S1L_ocIhNyHfLRsCOMMjbokUZKvxliTIxBRDED6s9w=s0-d "Her Master's Choice [Bound to Please 1] (Siren Publishing Everlasting Classic), by Karen Mercury")
