Financial Modeling, 3rd Edition
AbstractToo often, finance courses stop short of making a connection between textbook finance and the problems of real-world business. Financial Modeling bridges this gap between theory and practice by providing a nuts-and-bolts guide to solving common financial models with spreadsheets. Simon Benninga takes the reader step by step through each model, showing how it can be solved using Microsoft Excel. The long-awaited third edition of this standard text maintains the "cookbook" features and Excel dependence that have made the first and second editions so popular. It also offers significant new material, with new chapters covering such topics as bank valuation, the Black-Litterman approach to portfolio optimization, Monte Carlo methods and their applications to option pricing, and using array functions and formulas. Other chapters, including those on basic financial calculations, portfolio models, calculating the variance-covariance matrix, and generating random numbers, have been revised, with many offering substantially new and improved material. Other areas covered include financial statement modeling, leasing, standard portfolio problems, value at risk (VaR), real options, duration and immunization, and term structure modeling. Technical chapters treat such topics as data tables, matrices, the Gauss-Seidel method, and tips for using Excel. The last section of the text covers the Visual Basic for Applications (VBA) techniques needed for the book. The accompanying CD contains Excel worksheets and solutions to end-of-chapter exercises.
Download InfoTo our knowledge, this item is not available for download. To find whether it is available, there are three options:
1. Check below under "Related research" whether another version of this item is available online.
2. Check on the provider's web page whether it is in fact available.
3. Perform a search for a similarly titled item that would be available.
Bibliographic InfoThis book is provided by The MIT Press in its series MIT Press Books with number 0262026287 and published in 2008.
Contact details of provider:
Web page: http://mitpress.mit.edu
financial modeling; visual basic for applications; excel; term structure modeling;
Find related papers by JEL classification:
- C5 - Mathematical and Quantitative Methods - - Econometric Modeling
You can help add them by filling out this form.
CitEc Project, subscribe to its RSS feed for this item.
- Premachandra, I.M. & Zhu, Joe & Watson, John & Galagedera, Don U.A., 2012. "Best-performing US mutual fund families from 1993 to 2008: Evidence from a novel two-stage DEA model for efficiency decomposition," Journal of Banking & Finance, Elsevier, vol. 36(12), pages 3302-3317.
- Robert J. Balik, 2009. "Excel best practices," Managerial Finance, Emerald Group Publishing, vol. 35(5), pages 410-426, April.
- Raja, Ammar, 2009. "Future of option pricing: use of log logistic distribution instead of log normal distribution in Black Scholes model," MPRA Paper 40198, University Library of Munich, Germany.
For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: (Jake Furbush).
If references are entirely missing, you can add them using this form.