Financial Simulation Modeling in Excel, + Website: A Step-by-Step Guide

✍ Scribed by Keith Allman, Josh Laurito, Michael Loh

• Publisher: Wiley
• Year: 2011
• Tongue: English
• Leaves: 211
• Series: Wiley Finance 18
• Edition: 1
• Category: Library

✦ Synopsis

I've worked with simulation in business for over 20 years, and Allman really nails it with this book. I admit that I own his previous book on structured finance cash flows, but I was surprised by what I found in here. He addresses the fundamental questions of how decision makers react to simulations and his read was very much in accordance with what I've experienced myself. When it came to the nuts and bolts of describing the different types of simulation analysis the book becomes incredibly detailed. There is working code and models for a fantastic array of the most common simulation problems. If you're so inclined, the book very carefully steps through the tricky math needed to really understand the theory behind stochastic modeling in finance. If you're preparing models that include any kind of randomization or stochastic modeling component, this book is a must-read, a tremendous value and time-saver. — David Brode of The Brode GroupA practical guide to understanding and implementing financial simulation modelingAs 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 ExcelA companion website contains all the Excel models risk experts and quantitative analysts need to practice and confirm their results as they progressKeith Allman is the author of other successful modeling books, including Corporate Valuation Modeling and Modeling Structured Finance Cash Flows with Microsoft ExcelCreated 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.

✦ Table of Contents

Financial Simulation
Modeling in
Excel......Page 3
Contents......Page 7
Preface......Page 9
Acknowledgments......Page 13
About the Authors......Page 15
CHAPTER 1 Introduction......Page 19
CHAPTER 2 Random Numbers, Distributions, and Basic Simulation Setup......Page 31
CHAPTER 3 Correlation......Page 65
CHAPTER 4 Option Pricing......Page 83
CHAPTER 5 Corporate Default Simulation......Page 113
CHAPTER 6 Simulating Pools of Assets......Page 145
CHAPTER 7 Dealing with Data Deficiencies and Other Issues......Page 171
CHAPTER 8 Advanced Topics and Further Reading......Page 187
APPENDIX A Partial Differential Equations......Page 193
APPENDIX B Newton-Raphson Method......Page 201
References......Page 205
Index......Page 207

✦ Subjects

Общеобразовательные дисциплины;Моделирование;Имитационное моделирование, СМО;