Financial Modeling [Hardcover]

Simon Benninga (Author), Benjamin Czaczkes (Author)

Book Description

Publication Date: October 3, 1997

This textbook aims to bridge a gap between theory and practice in financial courses 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 the computation of corporate finance problems, standard portfolio problems, option pricing and applications, and duration and immunization. The author includes a set of chapters dealing with advanced techniques, including random number generation, matrix manipulation, and the Gauss-Seidel method. Although the reader should know enough about Excel to set up a simple spreadsheet, the author explains advanced Excel techniques such as functions, macros, the use of data tables, and VBA programming. The book comes with a disk containing Excel worksheets and solutions to end-of-chapter exercises.

Editorial Reviews

About the Author

Simon Benninga is Professor of Finance at Tel Aviv University and Visiting Professor of Finance at the Wharton School at the University of Pennsylvania. --This text refers to an out of print or unavailable edition of this title.

Product Details

• Hardcover: 415 pages
• Publisher: Mit Pr; Har/Dskt edition (October 3, 1997)
• Language: English
• ISBN-10: 0262024373
• ISBN-13: 978-0262024372
• Product Dimensions: 9.3 x 7.3 x 1.4 inches
• Shipping Weight: 2.1 pounds
• Average Customer Review: 4.5 out of 5 stars  See all reviews (52 customer reviews)
• Amazon Best Sellers Rank: #624,229 in Books (See Top 100 in Books)

Customer Reviews

Most Helpful Customer Reviews

248 of 249 people found the following review helpful:

4.0 out of 5 stars The Best Choice for Fundamental Financial Modeling, April 15, 2005

By 

Bachelier ""1004"" (Ile de France) - See all my reviews

Amazon Verified Purchase

This review is from: Financial Modeling - 2nd Edition: Includes CD (Hardcover)

I have used Simon Benninga's "Financial Modeling with Excel" for five years to teach undergraduate computational finance [...]. My thinking remains that my students have been well served by this textbook.

The inadequacies that limit my assessment to four stars and need to be addressed in the third edition are: 1) frustrating errors in the text and models, for which the errata sheet and corrected models (available at: [...] only improve, but do not heal. My students find new, undocumented, errors each semester. 2) the data sets and examples are getting, frankly, a little old. It is the year 2005 as I write this, but the data sets and examples end in 1999, a year in which my current students were in high school. 3) the models, while excellent as introductions to the field, are now at the point of being fundamental, rather than exemplary. This is not Prof. Benninga's fault, but as the other reviews from professionals here attest, Excel modeling has advanced in all fields (option pricing, financial statements, portfolio optimization, bond metrics, etc). When this volume was introduced, it was adequate for helping MBA and Master of Science in Finance students build essential modeling skills. Sadly, it now is only appropriate for raw beginners or undergraduates. A new text with a larger scope that addresses advances in the fields is called for. 4) While it is a subject in itself, the book is seriously hindered by not introducing basic Monte Carlo simulation in Excel. 5) No information on downloading data from BLOOMBERG, REUTERS, and other historical and market data providers. It would add to the scope of the text, but 6) fitting DCF models to yield curves also would be welcome.

Even with these criticisms, Benninga's Financial Modeling remains the best book in the field for what it seeks to accomplish. It covers the major topics of finance that are appropriately addressed with models: financial statement, firm valuation and credit metrics, portfolio construction, fixed income metrics, option pricing, etc. Benninga's FM also compares favorably with his two nearest competitors.

Powel and Baker's "The Art of Spreadsheet Modeling" is a two pronged monster: it seeks to be a meta-level theoretical work on spreadsheet modeling, and then introduces modeling Monte Carlo simulation as a fundamental component of Excel (a student edition of CrystalBall is included in the text, and is the only reason to buy this book). The gap between the two is a Grand Canyon's worth of knowledge space that this text does not fill in and nearly ignores. The student who uses only Powel and Baker is ill served; whereas if he uses Benninga, he knows how, why, when and what to model. Consider Powel & Baker as sketches of a concept car with simulated wind tunnel runs, whereas Benninga shows how to build your own kit car and drive it around. Powel and Baker's concept car is beautiful, advanced, gracious, but doesn't exist and doesn't run; Benninga's kit car is like a Lotus Super Seven: simple, runs, is a blast to drive, but is dangerous in heavy traffic and you would not want to go on a 1,000 mile journey with it (i.e. or build a DCF model for the Goldman Sachs LBO team with only Benninga).

Chandan Sengupta's "Financial Modeling Using Excel and VBA" is the only book that comes close to Benninga, and I recommend it as another perspective for my students who want to continue with financial modeling. However, Sengupta's work is flawed on two counts: 1) it is clear throughout that he had read Benninga, and 2) he dropped much of Benninga's content in favor of adding wordy explanatory paragraphs to soften the blow of the fact that modeling is mathematically and technically both boring and intense work. With those criticisms in mind, his work still has neater, leaner, more compressed models with updated contemporary detail.

There are three other books, Scott Proctor's "Building Financial Models with Microsoft Excel: A Guide for Business Professionals," which focuses on building vanilla financial statements, as does John Tjia "Building Financial Models." Mary Jackson & Mike Staunton's "Advanced Modeling in Finance using Excel and VBA" is also now dated and seriously flawed and limited in scope), however it is the next step following Benninga.

For those working in top-tier banks, the internal training and modeling documents, and examples built by colleagues, will likely surpass by light years what is offered in these books. And so for beginners, Benninga remains the the best choice and first step, until something better comes along, or Benninga himself produces a new edition.

99 of 110 people found the following review helpful:

5.0 out of 5 stars Excellent book due to its simple practicality, July 18, 2001

By 

Reader from New York (New York City, NY) - See all my reviews

This review is from: Financial Modeling - 2nd Edition: Includes CD (Hardcover)

I highly recommend this book to any aspiring financial analyst. It is definitely worth it, even at the list price.

Want to master the fundamentals of basic finance using Excel? then this is one of the few books on the market that really meet this need. Want to set up more advanced mathmatics modeling? well as the introduction of this explains, this book is more like a cookbook: it lists the required basic ingredients and the culinary process but if you want to spice the dish (financial model) up, it is up to the individuals to dig out those advanced formulas from the financial trade journals and apply them to the models.

I first saw the first edition of this book in my college library. took it home and was EXCITED. I was looking for a practical book that would show me the intricacies of Excel for setting up financial models and this was like a god-sent. Like one of the other reviewers said, this book combined basic finance, Excel functions, and VBA programming. To add practicality to this book, Professor Benninga even showed how to download financial data from the internet. Granted it is rather basic, but it adds to the usability of his book, making it a well-round book.

The best parts are end-of-the chapter exercises. Solutions are provided in the accompanying CD-ROM. See how many ways can you solve the same problem.

Professor Benninga always outlines the assumptions and explains the parameters of each model. We should remember that in many instances, unrealistic assumptions lead to way-of-the mark numbers, rendering the whole modeling process and its calculations useless.

Want to become a advanced-level financial modeler? then master the fundamentals first! this book gets you started.

P.S. I also highly recommend to anyone just starting with Excel modeling to read William J. Orvis's Excel for Scientists and Engineers. It is a bit outdated but still highly useful for its chapters on curve fitting, VBA programming and raw data manipulation.

38 of 40 people found the following review helpful:

5.0 out of 5 stars Chicken Soup for the Financial Analyst's Soul, July 20, 2003

By 

Dark Mechanicus JSG "Black Ops Teep" (Fortified Bunker, USSA) - See all my reviews
(VINE VOICE)   

This review is from: Financial Modeling - 2nd Edition: Includes CD (Hardcover)

If you need to build a working valuation model, calculate the risk of a portfolio with 100+ securities, or figure out what return you might expect to get from a portfolio of high-yield bonds, then you'll find Simon Beninga's "Financial Modeling" merits far more than five stars: this is one book that is indispensable.

One of the biggest problems I ran into during my MBA program was the way my professors taught Corporate Finance. I had great profs, true, but they were teaching theoretical concepts from theoretical textbooks. Sure, you learned the basics: CAPM, net present value, basic options and futures, Arbitrage Pricing Theory, VAR and TEV, but I have always maintained that the best way of learning a subject---particularly corporate finance---is by getting your hands dirty and digging into the guts of the material.

Since Corporate Finance, off-balance sheet instruments aside, isn't very dirty, the best way to get a hands-on practical approach in terms of Capital Structure, the appropriate discount rate to use in pricing an asset, risk, and optimal debt and dividends is to program in Excel and Visual Basic. The problem is that many top finance texts don't offer supplemental material to translate the theoretical concepts into actual valuation and spreadsheet models, which any financial analyst will contend is the life-blood of the industry.

With that in mind, Simon Beninga's "Financial Modelling" is a kind of "Joy of Cooking" for initiate investment bankers, corporate financiers, controllers, analysts, and anyone who wants to use core Corporate Finance concepts in the real world. Beninga goes through the standard laundry list of Corporate Finance text topics---from the optimal risky portfolio to the term structure of interest rates---and shows you how to translate these concepts into workable spreadsheet models that can illustrate, illuminate, and get to the heart of a problem.

If you're a new MBA or financial analyst, you'll find much to love in Beninga's approach, and by pairing the newly expanded 2nd edition up with a top theoretical finance textbook (Ross, Westerfield et al.'s "Corporate Finance" is a fine example) you'll get the most out of your MBA program and have a solid foundation for building Excel and Visual Basic financial models that work.

I liken "Financial Modeling" to a cookbook, in that Beninga provides all the ingredients necessary to the model at hand: he begins with a sprinkling of theory, whether it's modeling a bond portfolio's immunization, calculating the cost of capital, estimating a portfolio's Beta with no short-selling, or pricing put and call options using both the binomial theorem and Black-Scholes. His writing is spare, terse, and to the point, but I have learned more about advanced corporate finance theory through Beninga's marvellously pithy writing and copious Excel examples than I have in reading ten 'top of the list' finance books.

In addition to nicely expanded sections on options (including portfolio insurance) and leasing (including the technically sophisticated subject of leveraged leasing, which requires Excel to comprehend), Beninga concludes his sprightly little tome with a section on getting the most out of Excel (useful little shortcuts that a financial analyst will need but may not have heard of) and a nice little introductory primer on programming in Visual Basic.

"Financial Modeling" is an absolute essential if you're going to make Corporate Finance your profession. For an equally elegant and practical treatment of building discounted cash flow models for businesses, the reader would be advised to pick up Beninga's "Corporate Finance", which, while not equally oriented in spreadsheet modeling, is one of the most terse, accessible, and reasonably technically sophisticated Corp-Fin books on the market today.