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.
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.Read More
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.
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.Read More