Numerical Techniques in Finance is an innovative book that shows how to create, and how to solve problems in a wide variety of complex financial models. All the models are set up using Lotus 1-2-3; some of the advanced models also make use of Lotus macros.Using the models set out in the book, students and practicing professionals will be able to enhance their evaluative and planning skills. Each of the models is preceded by an explanation of the underlying financial theory. Exercises are provided to help the reader utilize the models to create new individualized applications.Numerical Techniques in Finance covers standard financial models in the areas of corporate finance, financial statement simulation, portfolio problems, options, portfolio insurance, duration, and immunization. A separate section of the book reviews the relevant mathematical and Lotus 1-2-3 techniques. Each of the book's five parts begins with a succinct overview.Simon Benninga is on the faculty of the School of Business Administration of the Hebrew University. He has been Visiting Professor of Finance at the University of Pennsylvania's Wharton School and at the Graduate School of Management at UCLA.
I am a professor of finance at Tel Aviv University and visiting professor of finance at the Wharton School of the University of Pennsylvania. In the last 20 years I have written a series of books on financial modeling.
My current books are Financial Modeling (3rd edition, MIT Press, 2008) and Principles of Finance with Excel (2nd edition, Oxford University Press, 2010). Both books integrate Excel with financial problems. It is difficult to exaggerate the importance of Excel for anyone doing finance, whether student or practitioner, but for some reason most finance books either ignore Excel completely or do not instruct the reader in the nuts-and-bolts of Excel implementation of finance problems. Hence my books.
Of the two currently in-print books, Financial Modeling is a more advanced modeling/finance book that includes VBA and some more advanced mathematics (all explained within the confines of the text). FM has become perhaps the standard financial modeling book at universities and among practitioners. It has been translated into Japanese, Chinese, Italian, and Russian.
Principles of Finance with Excel is an introductory text that covers the standard concepts of a "Principles" or "Introductory" finance book while maintaining the integration with Excel. PFE is gaining increasing adoption at universities in introductory finance courses.
I maintain a full website at http://simonbenninga.com that includes materials for instructors using my books in courses.
