The purpose of this book is to provide a guide to solving common financial models with spreadsheets. The author takes the reader step by step through each model, showing how it can be solved by using Microsoft Excel. With a section on Visual Basic for Applications by Benjamin Czaczkes. reats of implementing common financial models in Excel. Areas covered include computation of corporate finance problems ; standard portfolio problems ; option pricing and applications ; duration and immunization. Six new chapters covering financial calculations ; cost of capital ; value of risk (VaR) ; real options ; early exercice boundaries ; term structure modeling ; a potpourri of Excel hints.
