Financial Modeling

Financial Modeling

Hardback

By (author) Simon Benninga

$87.80

Free delivery worldwide
Available
Dispatched in 3 business days
When will my order arrive?

  • Publisher: MIT Press
  • Format: Hardback | 1168 pages
  • Dimensions: 183mm x 236mm x 46mm | 1,724g
  • Publication date: 1 August 2008
  • Publication City/Country: Cambridge, Mass.
  • ISBN 10: 0262026287
  • ISBN 13: 9780262026284
  • Edition: 3, Revised
  • Edition statement: 3rd Revised edition
  • Sales rank: 37,054

Product description

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. The accompanying CD contains Excel worksheets and solutions to end-of-chapter exercises.

Other people who viewed this bought:

Showing items 1 to 10 of 10

Other books in this category

Showing items 1 to 10 of 10
Categories:

Author information

Simon Benninga is Professor of Finance and Director of the Sofaer International MBA program at the Faculty of Management at Tel-Aviv University. For many years he was a Visiting Professor at the Wharton School of the University of Pennsylvania.

Review quote

For the 2nd Edition: "Benninga has a clear writing style and uses numerous illustrations, which make this book one of the best texts on using Excel for finance that I've seen." Ed McCarthy Ticker Magazine For the 2nd Edition: "The author describes this as a 'cookbook' and that is a good analogy... Its breadth is extensive, covering simple present valuing and cost of capital... to the likes of real options and early exercise of American-style options... A worthwhile acquisition." Paul Dentskevitch Risk Magazine