Financial modeling
Simon Benninga ; with a section on Visual Basic for Applications by Benjamin Czaczkes
- 4th ed.
- Cambridge, Mass. : The MIT Press, c2014.
- xxiv, 1111 p. : ill. ; 23 cm.
with a section on Visual Basic for Applications by Benjamin Czaczkes
This book is the standard text for explaining the implementation of financial models in Excel. As in previous editions, this fourth edition maintains the "cookbook" features and Excel dependence; it explains basic and advanced models in the areas of corporate finance, portfolio management, options, and bonds with detailed Excel spreadsheets. It also includes: a new section explaining the principles of Monte Carlo methods and their application to portfolio management and exotic option valuation; a new chapter discussing term structure modeling, with special emphasis on the Nelson-Siegel model; and a discussion of corporate valuation using pro forma models with the introduction of a new, simple model for corporate valuation based on accounting data and a minimal number of valuation parameters.