"I've worked with simulation in business for over 20 years, andAllman really nails it with this book. I admit that I own hisprevious book on structured finance cash flows, but I was surprisedby what I found in here. He addresses the fundamental questions ofhow decision makers react to simulations and his read was very muchin accordance with what I've experienced myself. When it came tothe nuts and bolts of describing the different types of simulationanalysis the book becomes incredibly detailed. There is workingcode and models for a fantastic array of the most common simulationproblems. If you're so inclined, the book very carefully stepsthrough the tricky math needed to really understand the theorybehind stochastic modeling in finance. If you're preparing modelsthat include any kind of randomization or stochastic modelingcomponent, this book is a must-read, a tremendous value andtime-saver." -- David Brode of The Brode Group
A practical guide to understanding and implementing financialsimulation modeling
As simulation techniques become more popular among the financialcommunity and a variety of sub-industries, a thorough understandingof theory and implementation is critical for practitioners involvedin portfolio management, risk management, pricing, and capitalbudgeting. Financial Simulation Modeling in Excel containsthe information you need to make the most informed decisionspossible in your professional endeavors.
Financial Simulation Modeling in Excel contains apractical, hands-on approach to learning complex financialsimulation methodologies using Excel and VBA as a medium. Craftedin an easy to understand format, this book is suitable for anyonewith a basic understanding of finance and Excel. Filled within-depth insights and expert advice, each chapter takes you throughthe theory behind a simulation topic and the implementation of thatsame topic in Excel/VBA in a step-by-step manner.
* Organized in an easy-to-follow fashion, this guide effectivelywalks you through the process of creating and implementing riskmodels in Excel
* A companion website contains all the Excel models risk expertsand quantitative analysts need to practice and confirm theirresults as they progress
* Keith Allman is the author of other successful modeling books,including Corporate Valuation Modeling and ModelingStructured Finance Cash Flows with Microsoft Excel
Created for those with some background in finance and experiencein Excel, this reliable resource shows you how to effectivelyperform sound financial simulation modeling, even if you've yet todo extensive modeling up to this point in your professional oracademic career.