Average Customer Review: ( 52 customer reviews )
Write an online review and share your thoughts with other customers.
Most Helpful Customer Reviews
249 of 250 found the following review helpful:
 The Best Choice for Fundamental Financial Modeling Apr 15, 2005
By Bachelier
""1004""
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.
100 of 111 found the following review helpful:
 Excellent book due to its simple practicality Jul 18, 2001
By Reader from New York
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 found the following review helpful:
Chicken Soup for the Financial Analyst's Soul Jul 20, 2003
By Dark Mechanicus JSG
"Black Ops Teep"
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.
27 of 28 found the following review helpful:
Real World Financial Modelling Apr 20, 2001
By Franco Arda
Finally a book for the Finance Specialist using Excel. Fantastic explanation of every step, starting at the very beginning of each topic. I Corporate Finance Models Basic Financial Calculations, Calculation of Cost of Capital, Financial Statement Modeling, Using Financial Statement Models for Valuation, The Financial Analysis of Leasing, The Financial Analysis of Leveraged Leases. Great basics from which you can build your own models, improvements etc. II Portfolio Models Calculating the Variance-Covariance Matrix, No Short Sale Restriction, Estimating Beta & SML, Short Sale Restriction, VAR. Basic topics in PM, and less used on Excel in the professional world. But, very exciting to gain thorough understanding by doing it on Excel. III Option Pricing Models My topic. Binomial Model, LogNorm Distribution, B&S Model, Portfolio Insurance, Real Options, Early Excercising. Again, great excerise to do it on Excel for learning purposes. Nice intro on Real Options using Binomial Model, but not my beloved B&S. IV Bonds and Duration Duration, Immunisation, Modelling the Term Structure, Calculating Default expec.adj. Bond Returns, Cheapest to Deliver. Cannot comment to this topic. V Technical Considerations Random Numbers, Data Tables, Matrices, The Gauss-Seidel Method, Excel Functions, Some Excel Hints. Matrices explained on Excel! Never seen that before. The rest almost replaces a single Excel Handbook. VI Introduction to Visual Basic for Applications User-defined Functions with VBA for Applications, Types and Loops, Macros and User Interaction, Arrays, Objects. The basics of VBA that help you to master many VBA problems. Fantastic work Simon Benninga! Check: http://finance.wharton.upenn.edu/~benninga/home.html
45 of 50 found the following review helpful:
 Too many errors and inadequacies Jan 13, 2003
By Gadgester
"No Time, No Money"
As a practioner of financial modeling, I was used to building financial models with SAS, Stata and Matlab, so when I was first asked by my new boss to start using Excel, I checked out this book. Unfortunately, it's grossly inadequate. The worst part is there are full of errors, encompassing typos in the Excel spreadsheets and technical inaccuracies. The coverage of a lot of topics is also quite superficial, for example, the chapters on calculating the efficient frontier ignore the important question of utility. (That is, the author maximizes wealth instead of utility.) In trying to cover a lot of ground in finance, from leasing to VaR to options, the book ends up doing nothing well, and the effort in presenting some theory before showing how it's implemented in Excel is laudable but ultimately laughable because much of the theory is presented quite poorly. In the end, you may find some value in understanding at a general level how to translate theory into Excel, esp. if you are new to the application.
See all 52 customer reviews on Amazon.com
|
![TurboTax Deluxe Federal + State 2007 [OLD VERSION]](http://ecx.images-amazon.com/images/I/41F-Spji2aL._SL75_.jpg "TurboTax Deluxe Federal + State 2007 [OLD VERSION]")
![Quicken 2008 Deluxe [OLD VERSION]](http://ecx.images-amazon.com/images/I/41rozdCQ-FL._SL75_.jpg "Quicken 2008 Deluxe [OLD VERSION]")
based on 52 reviews
