Simon Benninga

The late Simon Benninga was 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.

  • Financial Modeling, Fourth Edition

    Financial Modeling, Fourth Edition

    Simon Benninga

    A substantially revised edition of a bestselling text combining explanation and implementation using Excel; for classroom use or as a reference for finance practitioners.

    Financial Modeling is now the standard text for explaining the implementation of financial models in Excel. This long-awaited fourth edition maintains the “cookbook” features and Excel dependence that have made the previous editions so popular. As in previous editions, basic and advanced models in the areas of corporate finance, portfolio management, options, and bonds are explained with detailed Excel spreadsheets. Sections on technical aspects of Excel and on the use of Visual Basic for Applications (VBA) round out the book to make Financial Modeling a complete guide for the financial modeler.

    The new edition of Financial Modeling includes a number of innovations. A new section explains the principles of Monte Carlo methods and their application to portfolio management and exotic option valuation. A new chapter discusses term structure modeling, with special emphasis on the Nelson-Siegel model. The discussion of corporate valuation using pro forma models has been rounded out with the introduction of a new, simple model for corporate valuation based on accounting data and a minimal number of valuation parameters.

    New print copies of this book include a card affixed to the inside back cover with a unique access code. Access codes are required to download Excel worksheets and solutions to end-of-chapter exercises. If you have a used copy of this book, you may purchase a digitally-delivered access code separately via the Supplemental Material link on this page. If you purchased an e-book, you may obtain a unique access code by emailing digitalproducts-cs@mit.edu or calling 617-253-2889 or 800-207-8354 (toll-free in the U.S. and Canada).

    Praise for earlier editions “Financial Modeling belongs on the desk of every finance professional. Its no-nonsense, hands-on approach makes it an indispensable tool.”—Hal R. Varian, Dean, School of Information Management and Systems, University of California, Berkeley

    Financial Modeling is highly recommended to readers who are interested in an introduction to basic, traditional approaches to financial modeling and analysis, as well as to those who want to learn more about applying spreadsheet software to financial analysis."—Edward Weiss, Journal of Computational Intelligence in Finance

    “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

    • Hardcover $125.00 £75.00
  • Financial Modeling, Third Edition

    Financial Modeling, Third Edition

    Simon Benninga

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

    Praise for the previous editions:

    "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

    "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

    "Financial Modeling is highly-recommended to readers who are interested in an introduction to basic, traditional approaches to financial modeling and analysis, as well as to those who want to learn more about applying spreadsheet software to financial analysis."—Edward Weiss, Journal of Computational Intelligence in Finance

    "Financial Modeling belongs on the desk of every finance professional. Its no-nonsense, hands-on approach makes it an indispensable tool."—Hal R. Varian, Dean, School of Information Management and Systems, University of California, Berkeley

    "This is applied finance theory for the professional at its best. As a student, I and countless others learnt the intricacies of Lotus and financial theory from Professor Benninga's first book—Numerical Techniques in Finance. Now, as a professional, I do not have to 're-invent the wheel' in Excel. An invaluable guide. A must for all financial analysts."—Vikas Nath, Global Strategist, Emerging Equity Markets, Union Bank of Switzerland, London

    • Hardcover $92.00
  • Financial Modeling, Second Edition

    Financial Modeling, Second Edition

    Simon Benninga

    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®. In this sense, this is a finance "cookbook," providing recipes with lists of ingredients and instructions. Areas covered include computation of corporate finance problems, standard portfolio problems, option pricing and applications, and duration and immunization. The second edition contains six new chapters covering financial calculations, cost of capital, value at risk (VaR), real options, early exercise boundaries, and term structure modeling. A new technical chapter contains a potpourri of tips for using Excel®. Although the reader should know enough about Excel™ to set up a simple spreadsheet, the author explains advanced Excel® techniques used in the book. The book includes chapters dealing with random number generation, data tables, matrix manipulation, and VBA programming. It also comes with a CD-ROM containing Excel® worksheets and solutions to end-of-chapter exercises.

    • Hardcover $80.00
  • Numerical Techniques in Finance

    Numerical Techniques in Finance

    Simon Benninga

    Numerical Techniques in Finance is an innovative book that shows how to create, and how to solve problems in a wide variety of complex financial models. All the models are set up using Lotus 1-2-3; some of the advanced models also make use of Lotus macros. Using the models set out in the book, students and practicing professionals will be able to enhance their evaluative and planning skills. Each of the models is preceded by an explanation of the underlying financial theory. Exercises are provided to help the reader utilize the models to create new individualized applications. Numerical Techniques in Finance covers standard financial models in the areas of corporate finance, financial statement simulation, portfolio problems, options, portfolio insurance, duration, and immunization. A separate section of the book reviews the relevant mathematical and Lotus 1-2-3 techniques. Each of the book's five parts begins with a succinct overview.

    • Hardcover $42.00
    • Paperback $9.75 £7.99