Financial Modeling by Simon Benninga

Description

This book by Simon Benninga is an excellent book for any applicant wanting to apply finance in practice. The spreadsheet examples are state-of-the-art, practical and unique, easy to implement, and the integration of VBA is particularly helpful since VBA has become the programming language in finance. I would recommend this book to both academics and professionals interested in building up financial models. However, it should be easier to understand if supportive cases are included.” — Tim Opler, Director, Liability Management, Deutsche Morgan Grenfell and Department of Finance, Ohio State University.

Finance courses often fail to connect textbooks to real world business issues. Financial Modeling connects that gap – here is the first serious attempt at an integrated and applied guide for solving financial models using spreadsheets. Simon Benninga leads readers through each model step-by-step, and shows how to implement them using Microsoft Excel. This is a finance “cookbook,” with clear instructions accompanied by a list of “ingredients” for solving every type of corporate finance problem, standard portfolio issues, option pricing, and techniques of duration and immunisation.

The book also offers other advanced methods like random number generation, matrix manipulation, and the Gauss-Seidel method. The author further arms the reader with advanced techniques including functions, macros, data tables, and VBA programming in the event the reader may have had some prior information on the use of Excel. The book is packaged with a disk containing worksheets and solutions to the chapter-end exercises in the use of Excel.