Download PDF A Fast Track to Structured Finance Modeling, Monitoring, and Valuation: Jump Start VBA
Well, in connection with this trouble, what kind of book do you require now? This A Fast Track To Structured Finance Modeling, Monitoring, And Valuation: Jump Start VBA It's actually wow! We are likewise having the collection of this publication soft documents right here. It is not example by chance. This is the outcome of your effort to constantly follow what we provide. By finding guide in this site it proves that we constantly give guides that you really need so much.
A Fast Track to Structured Finance Modeling, Monitoring, and Valuation: Jump Start VBA
Download PDF A Fast Track to Structured Finance Modeling, Monitoring, and Valuation: Jump Start VBA
New updated! The A Fast Track To Structured Finance Modeling, Monitoring, And Valuation: Jump Start VBA from the most effective writer and author is now readily available here. This is the book A Fast Track To Structured Finance Modeling, Monitoring, And Valuation: Jump Start VBA that will make your day checking out comes to be finished. When you are seeking the published book A Fast Track To Structured Finance Modeling, Monitoring, And Valuation: Jump Start VBA of this title in guide store, you might not discover it. The troubles can be the minimal editions A Fast Track To Structured Finance Modeling, Monitoring, And Valuation: Jump Start VBA that are given up the book shop.
This is not kind of normal book. It gives you incredible web content to obtain the ideas. Beside, the existence of this publication will certainly lead you to always feel far better. You may not have to create or spend more time to go; the A Fast Track To Structured Finance Modeling, Monitoring, And Valuation: Jump Start VBA can be acquired from the soft file. Yeah, as this is an on-line collection, you could locate lots of types and styles of guides based upon the motifs that you truly need.
The reason of many individuals picks this A Fast Track To Structured Finance Modeling, Monitoring, And Valuation: Jump Start VBA as the reference exposes due to the demands in this day. We have some specific means just how guides are presented. Beginning with words options, attached subject, and also easy-carried language design, how the writer makes this A Fast Track To Structured Finance Modeling, Monitoring, And Valuation: Jump Start VBA is extremely simple. However, it includes the professional that can influence you easier.
You could conserve the soft file of this e-book A Fast Track To Structured Finance Modeling, Monitoring, And Valuation: Jump Start VBA It will depend upon your spare time and activities to open up as well as read this publication A Fast Track To Structured Finance Modeling, Monitoring, And Valuation: Jump Start VBA soft file. So, you may not hesitate to bring this publication A Fast Track To Structured Finance Modeling, Monitoring, And Valuation: Jump Start VBA almost everywhere you go. Simply include this sot documents to your device or computer disk to permit you read whenever as well as everywhere you have time.
From the Inside Flap
An introductory work to structured modeling in Visual Basic Application (VBA), A Fast-Track to Structured Finance Modeling, Monitoring, and Valuation: Jump Start VBA provides you with a concise, immediate, and practical guide to developing a meaningful level of modeling expertise on problems in structured finance. Designed to allow you to cross from the pure Excel world to the much more powerful and flexible world of VBA/Excel, this straightforward book is built around a structured finance case study in asset-based securitization. Starting with basic examples that progressively develop your confidence to take on more complicated tasks, this book teaches you how to break complex tasks down into simple tasks and then implement them into VBA code using a critical subset of the features of the language. This hands-on, step-by-step guide features coverage of: General modeling concepts The Cash Flow Waterfall in Excel code Organizing and creating VBA modules to hold your model code Generating VBA code from recorded macros, and how to simplify and extract it for use in your model Efficiently using VBA statements to control the flow of the model How to use template files for efficient and flexible report writing Writing a collateral selection and reporting capability into your model How to generate collateral cash flows on a loan-by-loan, period-by-period basis Calculation optimization applied to collateral cash flow amortization How to use the VBA debugger to detect and correct different types of errors How to use the completed model to structure and size a finance deal Modifying the model to allow multiple scenario runs Protecting and evolving the model so it continues to create value for the business unit How to add additional reporting and analytical features to the existing model How to convert the structuring model into a monitoring and valuation model Allowing for the use of monthly empirical performance information Use of the monitoring and valuation model to track the performance of the deal Valuing the deal based on its performance, market conditions, and rating criteria Accompanied by an online resource containing a complete working model and all the data and files professionals need to run it, A Fast-Track to Structured Finance Modeling, Monitoring, and Valuation: Jump Start VBA is the only book written for the complete novice, enhancing your ability to break complex, seemingly insoluble problems down into a set of manageable tasks, through the use of VBA.
Read more
From the Back Cover
A straightforward, how-to guide to the fundamentals of finance modeling "This book is a complete, all-in-one toolkit for structured finance modeling with Excel VBA, written by a veteran of a leading Wall Street investment bank who is also a VBA instructor. Whether you are new to structured finance or a seasoned professional, you will find here all you need to model even the most complex structured finance transactions. The book and accompanying web site provide the theory, the organization, and the code itself that take you step-by-step through the entire process, right up to the tasks market participants are most focused on today: valuation and monitoring. In addition to the nuts and bolts, you will find explanations and insights that only an experienced structured finance banker can provide. This book is the definitive resource that will raise you above the competition in modeling structured finance transactions." —Carol Childers, Director, Global Markets, Citigroup "Learning VBA is a daunting undertaking, add to that the challenge and complexity of structured cash flows, and the task can become overwhelming. This book provides a great step-by-step approach to overcoming this hurdle. It is extremely easy to read and offers a deliverables checklist for each chapter to ensure all concepts have been understood before moving on. The reader comes away with not only a sense of the utility and flexibility of VBA but also a sense of the factors that play into structuring cash flows. Concepts that are extremely pertinent in today's market environment include the performance of collateral, pricing of securities, and impact of the economic environment on the cash flows available to investors and all interested parties." —Kimberly Brown, Analyst, Commercial Real Estate, Citigroup "Bill is extraordinarily methodical in real life, with a very wide view of life. This shows in his book. Rather than rush through the ins and outs of code, he emphasizes what is needed, why it is needed, and how it is used. This makes the book much more than just a book on financial models, and closer to a book on how to be a financial professional." —Omar Haneff, Vice President, Proteus Technologies LLC
Read more
See all Editorial Reviews
Product details
Hardcover: 744 pages
Publisher: Wiley; 1 edition (February 9, 2009)
Language: English
ISBN-10: 9780470398128
ISBN-13: 978-0470398128
ASIN: 0470398124
Product Dimensions:
7.4 x 2.3 x 10.1 inches
Shipping Weight: 3.3 pounds (View shipping rates and policies)
Average Customer Review:
4.5 out of 5 stars
14 customer reviews
Amazon Best Sellers Rank:
#1,235,970 in Books (See Top 100 in Books)
My desk needed me to create a model to value/monitor our retained MSR portfolio. After quickly reading through 3 books(this one, the excel one, and the OOP one) I decided this book best suited our needs. Hands down this book delivered the best model by the end. But as the other reviewer said, this does take some time, even when using the example model he provided on the webpage.Needless to say, my boss seemed very impressed by the model I was able to produce with this book. Would recommend to anyone at any capacity.This was my first CF model. I have little prior knowledge of finance, and strong knowledge of VBA & Math. Took me roughly 8 weekends or so.
I purchased this book a few years ago, so I am a little late to the review process. I did have a fair Excel/VBA knowledge base and an above average Structured Finance background, so this book provided good information for someone looking to upgrade their VBA skills. One word of warning though, make sure you read and execute all of the chapters and associated models and not just use the final model at the end as your own...there is an error in the code described in the book when calculating the floating rate bond principal and will give you an incorrect collateral amortization schedule. If used as a pure VBA learning tool this book is well above average.
Very, very good.
I purchased this book having already a working knowledge of Visual Basic. I wanted basically what the title suggested, a fast track into the interconnected world of VBA and Finance. First, a note to those who are thinking about buying this: You will have to put time into this book. You cannot just sit on your bed and casually read it from cover to cover. The web site and this book go hand-in-hand together, and even if you ignore that portion (not recommended), you will need to have Excel open through some of the chapters or you will not get much out of it. Therefore, this book is for those who are dedicated to really learning how financial modeling works, and not just for people who want to read up on VBA code.Pros: What everyone is saying: This guy knows what he's doing and what he's talking about. He provides great background information in the first three chapters. As a person with programming background, the pace felt really slow in the first couple of chapters as he walks you through the concepts. He also provides information about the nature of the project you will be working on. Overall, the pacing feels off, but if you're patient you won't find this a problem.Cons: Those who fancy ourselves programmers remember our first lesson: the "Hello World" example. It was basically to introduce us to very elementary code. This is exactly what he does starting around chapter 7. He tells you to do something small and insignificant so you get a feel for how macros work and a glimpse at the resulting code. However, he then ramps up the difficulty by "cleaning" up the code. Here he starts slapping on and stripping syntax in such a way that someone who has little background in programming would get lost. This is by no means game-breaking but even I sometimes found myself staring at the "revised" code for a good 10-15 minutes trying to figure out what exactly he did. The statement he makes that this book was intended for those who know nothing of VBA is therefore misleading; he introduces a lot of syntax and code without truly explaining their nature. Again, to someone with some background in programming this is just a small nuisance you can work around. To someone that knows nothing, this is a serious hurdle. Another minor issue is that the book contains several typos. Not huge, but a lot of these typos are ridiculous mistakes that should easily have been caught by any editor.In conclusion, this is a great book if you have a working knowledge of programming. Otherwise, you may get lost in the moments where he just spits language at you without explaining them. Beginners can probably turn to Power Programming to start off.
I cannot emphasize enough the thoroughness of this book. The process involved in building and maintaining a model can be quite intensive. The author walks you through every detail while keeping the core objective ever in focus.While the author explicitly states that this book is primarily a text in modeling and not in financial structuring methodology, I found the chapter on securitization (Chapter 3) to be exceptionally...thorough. The chapter contains a broad, detailed overview of all the elements involved in a securitization. This is important because the reader needs an understanding of the overall process in order to continue with model building in the following chapters.This book contains a lot of useful information; it is a comprehensive step-by-step guide to modeling.
A Fast Track to Structured Finance Modeling, Monitoring, and Valuation: Jump Start VBA PDF
A Fast Track to Structured Finance Modeling, Monitoring, and Valuation: Jump Start VBA EPub
A Fast Track to Structured Finance Modeling, Monitoring, and Valuation: Jump Start VBA Doc
A Fast Track to Structured Finance Modeling, Monitoring, and Valuation: Jump Start VBA iBooks
A Fast Track to Structured Finance Modeling, Monitoring, and Valuation: Jump Start VBA rtf
A Fast Track to Structured Finance Modeling, Monitoring, and Valuation: Jump Start VBA Mobipocket
A Fast Track to Structured Finance Modeling, Monitoring, and Valuation: Jump Start VBA Kindle
A Fast Track to Structured Finance Modeling, Monitoring, and Valuation: Jump Start VBA PDF
A Fast Track to Structured Finance Modeling, Monitoring, and Valuation: Jump Start VBA PDF
A Fast Track to Structured Finance Modeling, Monitoring, and Valuation: Jump Start VBA PDF
A Fast Track to Structured Finance Modeling, Monitoring, and Valuation: Jump Start VBA PDF
