Financial Simulation Modeling in Excel
April 8, 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.
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.
1. If you have the kindle version, and you copy paste over the COUNTIF formula…the quotes “” used need to be reentered…Kindle copies over a fancy kind of quote that Excel does not recognize.
2. Page 20, C4:AF207 should read C8:AF207…..C4 is already has another value used.
3. Page 20, the COUNTIF formula uses a semi colon as those sections were referenced from a European version of Excel..it should be using a comma if you are using a U.S./Other version.
4. Page 21, step 14. In the equation given, the last part “=” should have been “>=”. Thus, the whole equation should read: =COUNTIF($C$6:$AF$6,”>=”&AI28)-COUNTIF($C$6:$AF$6,”>=”&A