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.
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