April 8th, 2012
As simulation techniques become more popular among the financial community and a variety of sub-industries, a thorough understanding of theory and implementation is critical for practitioners involved in portfolio management, risk management, pricing, and capital budgeting. Financial Simulation Modeling in Excel contains the information you need to make the most informed decisions possible in your professional endeavors.
Financial Simulation Modeling in Excel contains a practical, hands-on approach to learning complex financial simulation methodologies using Excel and VBA as a medium. Crafted in an easy to understand format, this book is suitable for anyone with a basic understanding of finance and Excel. Filled with in-depth insights and expert advice, each chapter takes you through the theory behind a simulation topic and the implementation of that same topic in Excel/VBA in a step-by-step manner.
- Organized in an easy-to-follow fashion, this guide effectively walks you through the process of creating and implementing risk models in Excel. A companion website contains all the Excel models risk experts and quantitative analysts need to practice and confirm their results as they progress
Created for those with some background in finance and experience in Excel, this reliable resource shows you how to effectively perform sound financial simulation modeling, even if you’ve yet to do extensive modeling up to this point in your professional or academic career.
Read the rest of this entry »
September 23rd, 2009
A critical guide to corporate valuation modeling. Valuation is at the heart of everything that Wall Street does. Every day, millions of transactions to purchase or sell companies take place based on prices created by the activities of all market participants. Corporate Valuation Modeling takes you step-by-step through the process of creating a powerful corporate valuation model. Each chapter discusses the theory of the concept, followed by Model Builder instructions that inform you of every step necessary to create the template model. Many chapters also include a validation section that shows techniques and implementations that you can employ to make sure the model is working properly.
- Walks you through the full process of constructing a fully dynamic corporate valuation model
- A Tool Box section at the end of each chapter assists readers who may be less skilled in Excel techniques and functions
Complete with a companion CD-ROM that contains constructed models, this book is an essential guide to understanding the intricacies of corporate valuation modeling.
Read the rest of this entry »
June 30th, 2008
Given the lack of transparency in the market and the difficult time investors have in understanding complex Wall Street transaction, Keith Allman’s second book takes readers through the detailed process of reverse engineering a deal by decomposing legal documentation and rebuilding it in an computer model.
Using a sophisticated mortgage-backed transaction as an example, the book jumps between excerpts from the legal documentation and the corresponding Excel formulas and code.
This book is particularly valuable for those who want to expand their knowledge of Visual Basic Applications (VBA) as there is extensive coding to create the loan-level amortization engine.
The included CD-ROM includes all code and the final model.
June 24th, 2008
Enstruct’s principal’s debut book on modeling structured finance securities. It is an easily accessible text that takes a reader through every component of the analytical process for structured finance assets. Readers build their modeling experience in each chapter through Model Builder exercises, which culminate into a final, consolidated model. Included with this text is a CD-ROM with the Excel versions of the Model Builder exercises and the complete model.
The following discrepancies and errata have been reported in earlier versions of the text. Later versions may have these issues edited out. If you discover any yourself please forward them to firstname.lastname@example.org.
p. 31 Step 14 instructs the reader to enter 1.50% for the margin, however the CD-ROM models leave this field blank. The corrected model files should have 1.50% entered for the margin to begin with. Read the rest of this entry »