|
|
|
|
|
A Fast Track To Structured Finance Modeling, Monitoring and Valuation: Jump Start VBA (Wiley Finance)
| Our Price |
$ 78.85
|
|
| Retail Value |
$ 95.00 |
|
| You Save |
$ 16.15 (17%) |
|
| Item Number |
2414689 |
|
|
|
|
|
|
Item 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 |
Item Specifications...
Pages 744
Dimensions: Length: 2.25" Width: 7.25" Height: 10"
Weight: 3.25 lbs.
Binding Hardcover
Release Date Feb 9, 2009
ISBN 0470398124
EAN 9780470398128
|
Availability 3 units.
Availability accurate as of May 30, 2012 06:38.
Usually ships within one to two business days from Momence, IL.
Orders shipping to an address other than a confirmed Credit Card / Paypal Billing address may incur and additional processing delay.
|
Product Categories
Similar Products
Reviews - What do our customers think?
 | Good knowledge, though a bit misleading Oct 10, 2009 |
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. | | |  | Practical and Informative VBA Analytics Apr 13, 2009 |
This book is a must-read for structured products markets professionals and regulators -- it could not be more timely. An entertaining and informative introduction to VBA modeling, the book shows how to use VBA techniques for structured finance applications. In the process, it also demonstrates some of the challenges and pitfalls that underlie structured products cash flow modeling. The supplementary website and illustrative graphs and charts used throughout the book are highly useful, making the analysis very easy to follow.
| | | | Dynamic Problem Solving Apr 11, 2009 |
| The best part about learning VBA, as Preinitz points out at the beginning of Jump Start VBA, is not about learning the commands and applying them routinely. The best part is to challenge your mental acumen and to start thinking about dynamic problem solving. And you are learning a new language at the same time. He shares his great adventure and challenges you to keep up. Jump right in! | | | | Structured Finance For The Rest Of Us Mar 18, 2009 |
Whether you're a seasoned veteran of the financial markets or a curious student looking to find out what all the fuss is down on Wall Street, "A Fast Track to Structured Finance" has something for you.
This book offers a very detailed approach to managing and analyzing the securitization process utilizing Excel and Visual Basic. What makes this book brilliant is its careful balance of the author's industry knowledge, well designed Excel templates and concise Visual Basic coding.
Bill opens up the book with a discussion of the securitization process. Here we get our first glimpse at his expertise is this subject. During this discussion he details how the integration of VBA and Excel will help streamline the analyst and management of the deal. Interspersed throughout the book are tidbits of history, personal experiences and humor that add to a very entertaining read.
Don't let the size of the book scare you. It's filled with numerous screen shots and code samples that add clarity. And as a bonus, the spreadsheet and code examples can be found on the Wiley website. The Visual Basic coding is incredibly well documented and is portable. You'll find yourself looking for opportunities to apply his unique strategies to your own projects. There are many tips he offers the novice programmer to help ensure that their code is easy to read and understand in the future. This is especially important when you come back to your code months later and wonder why you wrote that "if" statement.
(For those advanced Excel VBA users, check out the code in chapter 13 where Bill discusses the "Ineligible Collateral Report". Very cool.)
Bill also deserves credit for his integration of Excel spreadsheets with Visual Basic.
No longer will you have the fear of, "there's too much data, I need a database".
Bill proves it can all be done in Excel.
Well written, detailed, filled with examples and fun to read. "Where can I find a book on Structured Finance like that?" Look no further...
This is that book. | | | | A Comprehensive Guide Mar 13, 2009 |
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.
| | | Write your own review about A Fast Track To Structured Finance Modeling, Monitoring and Valuation: Jump Start VBA (Wiley Finance)
|
Shopping Cart (0 Items)
