Numerical techniques in finance
Simon Benninga
The MIT Press
This excellent book shows how to incorporate into a spreadsheet  program, like Lotus, the sometimes theoretical constructs of modern  finance. In the process of working through this book, the reader will  gain an intuitive understanding of modern finance and, as a bonus, a  thorough knowledge of Lotus. -- Marshall E. Blume, Howard Butcher III  Professor of Financial Management, Wharton School, University of  Pennsylvania    <P> 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.    <P>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.    <P> Numerical Techniques in Finance  covers standard financial models  in the areas of corporate finance, financial-statement simulation,  portfolio problems, otions, 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.