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 »
Posted in blog & books corrections
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.
.
Posted in blog & books corrections
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 info@enstructcorp.com.
Chapter 2
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 »
Posted in blog & books corrections