Financial Modeling, Fourth Edition
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 submitting a request here - https://mitpress.atlassian.net/servicedesk/.
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
Downloadable instructor resources available for this title: slides for all chapters except 18, syllabi and exams from author courses, Amtrak case questions and solutions, and an app for downloading stock data
Hardcover$125.00 X ISBN: 9780262027281 1144 pp. | 7 in x 9 in 95 figures, 31 tables
I've found earlier editions of Simon Benninga's Financial Modeling to be a great reference, and I've used them often. The fourth edition again offers helpful tips for using Excel in the most efficient and powerful manner to solve finance problems. These tips are illustrated in clear, step-by-step fashion so that the reader can start using them right away. The fourth edition also offers an improved flow of topics within the primary headings of Corporate Finance and Valuation, Portfolio Models, Valuation of Options, Valuing Bonds, and Monte Carlo Methods, along with updated examples and exercises. Financial Modeling continues to be a valuable resource for practicing finance professionals, students, and professors.
Robert A. Taggart
Professor of Finance, Carroll School of Management, Boston College