Financial Modeling

This document was uploaded by one of our users. The uploader already confirmed that they had the permission to publish it. If you are author/publisher or own the copyright of this documents, please report to us by using this DMCA report form.

Simply click on the Download Book button.

Yes, Book downloads on Ebookily are 100% Free.

Sometimes the book is free on Amazon As well, so go ahead and hit "Search on Amazon"

A substantially revised edition of a bestselling text combining explanation and implementation using Excel; for classroom use or as a reference for finance practitioners. Financial Modeling is now the standard text for explaining the implementation of financial models in Excel. This long-awaited fourth edition maintains the “cookbook” features and Excel dependence that have made the previous editions so popular. As in previous editions, basic and advanced models in the areas of corporate finance, portfolio management, options, and bonds are explained with detailed Excel spreadsheets. Sections on technical aspects of Excel and on the use of Visual Basic for Applications (VBA) round out the book to make Financial Modeling a complete guide for the financial modeler. The new edition of Financial Modeling includes a number of innovations. A new section explains the principles of Monte Carlo methods and their application to portfolio management and exotic option valuation. A new chapter discusses term structure modeling, with special emphasis on the Nelson-Siegel model. The discussion of corporate valuation using pro forma models has been rounded out with the introduction of a new, simple model for corporate valuation based on accounting data and a minimal number of valuation parameters. New print copies of this book include a card affixed to the inside back cover with a unique access code. Access codes are required to download Excel worksheets and solutions to end-of-chapter exercises. If you have a used copy of this book, you may purchase a digitally-delivered access code separately via the Supplemental Material link on this page. If you purchased an e-book, you may obtain a unique access code by emailing [email protected] or calling 617-253-2889 or 800-207-8354 (toll-free in the U.S. and Canada). Praise for earlier editions “Financial Modeling belongs on the desk of every finance professional. Its no-nonsense, hands-on approach makes it an indispensable tool.” ―Hal R. Varian, Dean, School of Information Management and Systems, University of California, Berkeley “Financial Modeling is highly recommended to readers who are interested in an introduction to basic, traditional approaches to financial modeling and analysis, as well as to those who want to learn more about applying spreadsheet software to financial analysis." ―Edward Weiss, Journal of Computational Intelligence in Finance “Benninga has a clear writing style and uses numerous illustrations, which make this book one of the best texts on using Excel for finance that I've seen.” ―Ed McCarthy, Ticker Magazine

Author(s): Simon Benninga
Edition: 4
Publisher: The MIT Press
Year: 2014

Language: English
Commentary: Vector PDF
Pages: 1144
City: Cambridge, MA
Tags: Finance; Option Models; Portfolio Valuation; Net Present Value; Capital Asset Pricing Model; Futures; Value at Risk; Asset Valuation; Market-Based Valuation; Cash Flow; Model Analysis; Internal Rate of Return

Contents
Preface
From the Preface to the Third Edition
From the Preface to the Second Edition
From the Preface to the First Edition
0 Before All Else
Part I: Corporate Finance and Valuation
1 Basic Financial Calculations
2 Corporate Valuation Overview
3 Calculating the Weighted Average Cost of Capital (WACC)
4 Valuation Based on the Consolidated Statement of Cash Flows
5 Pro Forma Financial Statement Modeling
6 Building a Pro Forma Model: The Case of Caterpillar
7 Financial Analysis of Leasing
Part II: Portfolio Models
8 Portfolio Models—Introduction
9 Calculating Efficient Portfolios
10 Calculating the Variance-Covariance Matrix
11 Estimating Betas and the Security Market Line
12 Efficient Portfolios Without Short Sales
13 The Black-Litterman Approach to Portfolio Optimization
14 Event Studies
Part III: Valuation of Options
15 Introduction to Options
16 The Binomial Option Pricing Model
17 The Black-Scholes Model
18 Option Greeks
19 Real Options
Part IV: Valuing Bonds
20 Duration
21 Immunization Strategies
22 Modeling the Term Structure
23 Calculating Default-Adjusted Expected Bond Returns
Part V: Monte Carlo Methods
24 Generating and Using Random Numbers
25 An Introduction to Monte Carlo Methods
26 Simulating Stock Prices
27 Monte Carlo Simulations for Investments
28 Value at Risk (VaR)
29 Simulating Options and Option Strategies
30 Using Monte Carlo Methods for Option Pricing
Part VI: Excel Techniques
31 Data Tables
32 Matrices
33 Excel Functions
34 Array Functions
35 Some Excel Hints
Part VII: Visual Basic for Applications (VBA)
36 User-Defined Functions with VBA
37 Variables and Arrays
38 Subroutines and User Interaction
39 Objects and Add-Ins
Selected References
Index