000 02590nam a2200217Ia 4500
100 _aBenninga, Simon
_9154056
008 140323b2008 xxu||||| |||| 00| 0 eng d
020 _a9780262026284
082 _a332.015118
245 _aFinancial modeling
_cBenninga, Simon
_bwith a section on visual basic for applications by Benjamin Czaczkes
250 _a3rd ed.
260 _aCambridge, Massachusetts
_bMIT Press
_c2008
300 _axxviii, 1133p.
_eWith CD at Acc. No. CD1268 (164777)
300 _axxviii, 1133p.
_eWith CD at Acc. No. CD1438 (167248)
365 _bUSD 85.00(each)
520 _a The third edition of this standard text retains the popular “cookbook” features of earlier editions and includes expanded and new coverage of such topics as bank valuation, the Black-Litterman portfolio selection model, Monte Carlo pricing methods, array function, and getting information from the Internet with VBA. Too 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. https://mitpress.mit.edu/books/financial-modeling-third-edition
650 _aFinance - Mathematical models
650 _aMathematical models - Finance
852 _hB3F4
942 _cBK
_2ddc
999 _c13209
_d13209