Numerical Techniques in Finance
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.
About the Author
Simon Benninga is Professor of Finance and Director of the Sofaer International MBA program at the Faculty of Management at Tel-Aviv University. For many years he was a Visiting Professor at the Wharton School of the University of Pennsylvania.
"This excellent book shows how to incorporate into a spreadsheetprogram, like Lotus, the sometimes theoretical constructs of modernfinance. In the process of working through this book, the reader willgain an intuitive understanding of modern finance and, as a bonus, athorough knowledge of Lotus."
- Marshall E. Blume, Howard Butcher III Professor of FinancialManagement, Wharton School, University of Pennsylvania