Average Reviews:
(More customer reviews)Simon Benninga's 3rd Edition of Financial Modelling with Excel is the single most useful book for finance students and professionals ever published and continues to offer an outstanding reference and textbook for students and practitioners of applied finance.
For further information, please use the "Look Inside" feature and examine the Table of Contents carefully, because I will emphasize selected portions.
It is difficult to overstate how useful and practical and helpful this work is for a wide audience and Financial Modelling is the single finance book I recommend for everyone after they have taken (or read themselves) Introductory Finance.
For those looking for "one-stop-shopping" for models that resemble those of professional financial analysts then there is no better value than Benninga's FM3.
Benninga's FM3 is a coal-face work for those who must make financial decisions using models. There are further specialist texts in topics covered here (credit modelling, portfolio construction, option pricing), but the models in FM3 are the first advanced models applied to loans, bonds, options, and equity portfolios. Master these and then specialized texts are easier to digest.
"Cookbook" metaphors are too strong and do not do this work justice, for Financial Modelling 3rd (FM3) is not a mere collection of recipes but rather topical introduction, explanation, and then direct technique.
If we can make a comparison with a "cookbook" then FM3 falls somewhere between "The Joy of Cooking" and "Mastering the Art of French Cooking." "Joy" combines chapters on technique, ingredients, and tools with dense pages of endless recipes, whereas "Mastering" emphasises technique and a few well-selected recipes.
The welcome new chapters cover bank valuation, the Black-Litterman approach to portfolio optimization, and Monte Carlo methods and applications to option pricing, and the previous 2nd edition's small chapter on using array functions and formulas has been expanded. The chapter on data downloads from YAHOO is also welcome, especially for those on a budget.
There is a single significant flaw in the work, which is excusable and redeemable. Far too often the discounting in the chapters is done over a flat interest rate curve. While the term structure of interest rates is covered, and historical term structures and parallel shifts and steepening and flattening is covered in isolation in a thorough chapter and with wonderful data files, the necessity and explicit connection of discounting from an appropriate yield curve is left implied and only mentioned in a few exercises. I would have preferred a "round up" chapter where each of the subjects treated (bond discounting, portfolio expected returns, options, etc.) under a yield curve with advanced models. Sure BLOOMBERG and REUTERS have these sort of things (often incorrectly) programmed, but students need to learn explicitly about them and do the exercise themselves to comprehend the importance of curve discounting.
The CD attached in the back of the book is alone worth the price, with over two score of models that are practical and adaptable for students and professionals alike. The files are stored and separated according to chapters and subject matter. Each file has logical progression of the concepts advanced in the book, and each separate sheet either stands alone or appropriately links to data and models on other sheets, so editing for your own purposes is a breeze.
For those who want to train themselves in Finance (not "personal finance") then I suggest reading Copeland, Weston, & Shastri's Financial Theory and Corporate Policy (4th Edition) and Brealey, Myers, and Marcus's "Corporate Finance" and "Investments" followed by working through FM3. Such a course would give any self-disciplined person the equivalent of a Masters of Science in Finance.
Full disclosure: I am thanked in the "Acknowledgements" for providing a few helpful comments on the second edition.
Click Here to see more reviews about:
Financial ModelingToo 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
Get 30% OFF
Click here for more information about Financial Modeling
