Financial Modeling

by Simon Z. Benninga, Benjamin Czaczkes

Too often, finance courses stop short of making a connection between textbook finance and the problems of real-world business. Financial Modeling bridges this gap between theory and practice by providing a nuts-and-bolts guide to solving common financial models with spreadsheets. Simon Benninga takes the reader step by step through each model, showing how it can be solved using Microsoft Excel®. In this sense, this is a finance "cookbook," providing recipes with lists of ingredients and instructions.

Areas covered include computation of corporate finance problems, standard portfolio problems, option pricing and applications, and duration and immunization. The second edition contains six new chapters covering financial calculations, cost of capital, value at risk (VaR), real options, early exercise boundaries, and term structure modeling. A new technical chapter contains a potpourri of tips for using Excel®.

Although the reader should know enough about Excel™ to set up a simple spreadsheet, the author explains advanced Excel® techniques used in the book. The book includes chapters dealing with random number generation, data tables, matrix manipulation, and VBA programming. It also comes with a CD-ROM containing Excel® worksheets and solutions to end-of-chapter exercises.

Genres: Finance, Business, Textbooks, Nonfiction, Reference, Economics

622 pages, Hardcover

First published September 18, 2000

Reviews

[Waleed · Rating 5 out of 5]

Amazing resource that walks you through finance principles and bridges it with examples using Excel. Great reference to have on your bookshelf for when you need a refresher!

[Rommel Harlequin Monet · Rating 5 out of 5]

The 1st 5 chapters on modeling inter-connected financial statements using Excel is worth 10 times the price of the book. The rest of the book is for finance geeks. Only a dimwit would give this anything less than 4 stars.


https://mzfsir.weebly.com/uploads/6/3...