Home | Posts RSS | Comments RSS | Login

FINANCIAL MODELING Uses EXCEL, 3e

2009/2/12

ISBN13:9780262026284|Binding: Hardcover|Pages:1168|Copyright: ©2008|Price:NT$1680

Author
Simon Benninga, Tel Aviv University

Description
It offers significant new material, with new chapters covering such topics as bank valuation, the Black-Litterman approach to portfolio optimization, Monte Carlo methods and their applications to option pricing, and using array functions and formulas. Other chapters, including those on basic financial calculations, portfolio models, calculating the variance-covariance matrix, and generating random numbers, have been revised, with many offering substantially new and improved material. Other areas covered include financial statement modeling, leasing, standard portfolio problems, value at risk (VaR), real options, duration and immunization, and term structure modeling. Technical chapters treat such topics as data tables, matrices, the Gauss-Seidel method, and tips for using Excel. The last section of the text covers the Visual Basic for Applications (VBA) techniques needed for the book. The accompanying CD contains Excel worksheets and solutions to end-of-chapter exercises.

Table of Contents (Detail)
I Corporate Finance Models
II Portfolio Models
III Option-Pricing Models
IV Bonds
V Technical Considerations
VI Introduction to Visual Basic for Applications