Ebook Free Financial Modeling, by Simon Benninga, Benjamin Czaczkes
You may not should be question regarding this Financial Modeling, By Simon Benninga, Benjamin Czaczkes It is easy way to get this publication Financial Modeling, By Simon Benninga, Benjamin Czaczkes You can just go to the established with the link that we give. Below, you can buy the book Financial Modeling, By Simon Benninga, Benjamin Czaczkes by on-line. By downloading Financial Modeling, By Simon Benninga, Benjamin Czaczkes, you can discover the soft data of this publication. This is the local time for you to begin reading. Also this is not printed publication Financial Modeling, By Simon Benninga, Benjamin Czaczkes; it will exactly offer even more benefits. Why? You might not bring the published publication Financial Modeling, By Simon Benninga, Benjamin Czaczkes or stack the book in your residence or the office.
Financial Modeling, by Simon Benninga, Benjamin Czaczkes
Ebook Free Financial Modeling, by Simon Benninga, Benjamin Czaczkes
Recommendation in choosing the best book Financial Modeling, By Simon Benninga, Benjamin Czaczkes to read this day can be gotten by reading this web page. You could discover the very best book Financial Modeling, By Simon Benninga, Benjamin Czaczkes that is offered in this globe. Not only had actually guides released from this nation, but additionally the other nations. And also currently, we suppose you to read Financial Modeling, By Simon Benninga, Benjamin Czaczkes as one of the reading products. This is just one of the very best publications to gather in this site. Consider the page and also look the books Financial Modeling, By Simon Benninga, Benjamin Czaczkes You could locate great deals of titles of guides supplied.
The perks to take for reading the books Financial Modeling, By Simon Benninga, Benjamin Czaczkes are pertaining to improve your life top quality. The life high quality will not just concerning the amount of knowledge you will obtain. Also you read the enjoyable or entertaining publications, it will aid you to have enhancing life high quality. Feeling fun will lead you to do something flawlessly. Furthermore, guide Financial Modeling, By Simon Benninga, Benjamin Czaczkes will certainly give you the session to take as a good need to do something. You may not be worthless when reviewing this publication Financial Modeling, By Simon Benninga, Benjamin Czaczkes
Never mind if you don't have enough time to go to the book store as well as search for the preferred publication to read. Nowadays, the on-line book Financial Modeling, By Simon Benninga, Benjamin Czaczkes is pertaining to provide ease of reading practice. You may not require to go outside to look the publication Financial Modeling, By Simon Benninga, Benjamin Czaczkes Searching and downloading and install the e-book entitle Financial Modeling, By Simon Benninga, Benjamin Czaczkes in this short article will certainly offer you much better option. Yeah, on-line publication Financial Modeling, By Simon Benninga, Benjamin Czaczkes is a kind of electronic book that you could obtain in the link download offered.
Why ought to be this online publication Financial Modeling, By Simon Benninga, Benjamin Czaczkes You could not should go somewhere to review the e-books. You can read this publication Financial Modeling, By Simon Benninga, Benjamin Czaczkes every time and also every where you desire. Also it is in our downtime or feeling bored of the works in the office, this corrects for you. Obtain this Financial Modeling, By Simon Benninga, Benjamin Czaczkes today as well as be the quickest person who completes reading this book Financial Modeling, By Simon Benninga, Benjamin Czaczkes
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.
- Sales Rank: #1785183 in Books
- Published on: 1997-10-03
- Original language: English
- Number of items: 1
- Dimensions: 9.50" h x 7.25" w x 1.50" l,
- Binding: Hardcover
- 415 pages
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.
Most helpful customer reviews
130 of 139 people found the following review helpful.
the single most useful book for finance students and professionals ever published
By Bachelier
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.
107 of 114 people found the following review helpful.
Quick Tip
By SelfTraining
Rather then comment extensively on the content of the book (as others have done rather well), I felt like I would pass this tip (which I wish I had known to prevent frustration). I feel that anyone without a working knowledge of Visual Basic, and manuevering around Excel should obtain the skill set with the well written technical sections. I would suggest starting with part VI introduction to Visual Basic (chapters 36-41) then moving on to Technical Consideration (chapters 29-35) and THEN moving onto the substantial matter of the first 4 parts. This will help keep you from getting frustrated while interacting with the software and allow you to focus on the concepts. Again this is only for individuals without a working knowledge of the platforms, if you do possess those skills then the above recommendation is a moot point.
256 of 258 people found the following review helpful.
The Best Choice for Fundamental Financial Modeling
By Bachelier
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.
Financial Modeling, by Simon Benninga, Benjamin Czaczkes PDF
Financial Modeling, by Simon Benninga, Benjamin Czaczkes EPub
Financial Modeling, by Simon Benninga, Benjamin Czaczkes Doc
Financial Modeling, by Simon Benninga, Benjamin Czaczkes iBooks
Financial Modeling, by Simon Benninga, Benjamin Czaczkes rtf
Financial Modeling, by Simon Benninga, Benjamin Czaczkes Mobipocket
Financial Modeling, by Simon Benninga, Benjamin Czaczkes Kindle
