Pub. Date:
MIT Press
Financial Modeling (w/ disk)

Financial Modeling (w/ disk)

by Simon Benninga, Benjamin Czaczkes


Current price is , Original price is $57.95. You

Temporarily Out of Stock Online

Please check back later for updated availability.

This item is available online through Marketplace sellers.


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 the computation of corporate finance problems, standard portfolio problems, option pricing and applications, and duration and immunization. The author includes a set of chapters dealing with advanced techniqueS, including random number generation, matrix manipulation, and the Gauss-Seidel method.

Although the reader should know enough about Excel to set up a simple spreadsheet, the author explains advanced Excel techniques such as functions, macros, the use of data tables, and VBA programming. The book comes with a disk containing Excel worksheets and solutions to end-of-chapter exercises.

Product Details

ISBN-13: 9780262024372
Publisher: MIT Press
Publication date: 11/28/1997
Edition description: Older Edition
Pages: 397
Product dimensions: 7.19(w) x 9.27(h) x 1.28(d)

Table of Contents

Corporate Finance Models
Pro forma financial Statement Modeling
Using Financial Statement Models for Valuation
Analysis of Leasing
The Financial Analysis of Leveraged Leases
Portfolio Models
Portfolio Models Introduction
Calculating the VarianceCovariance MatriX
Calculating Efficient Portfolios
Betas and the Security Market Line
Efficient Portfolios with Short Sale Restrictions
Option Pricing Models
An Introduction to Options
Binomial Option Pricing Model
The Lognormal Distribution
The BlackScholes Model
Portfolio insurance
Bonds and Duration
Duration and immunization
Calculating defaultadjusted eXpected bond returns (a Markov model)
Duration and the cheapesttodeliver on Treasury bill futures (this
chapter written jointly with Zvi Wiener)
Technical chapters on various aspects of EXcel
Number Generation
Data Tables in EXcel
Matrices and Array Functions
The GaussSeidel Method
Some EXcel Functions (those used in this book)
Introduction to VBA Programming (two chapters written by Benjamin
Programming in Microsoft EXcel
Introduction to UserDefined Functions in VBA

Customer Reviews

Most Helpful Customer Reviews

See All Customer Reviews