Numerical techniques in finance

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

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, 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.