Description
Simon Benninga’s “Financial Modeling” is a great one-stop reference and guide that offers great technical advice on how to use the Excel software appropriately. Beyond just as a step-by-step tutorial book, this fourth edition of “Financial Modeling” also comes with updated examples and exercises relevant to modern times.
About the Author
The late Simon Benninga was Professor of Finance and Director of the Sofaer International MBA program at the Faculty of Management at Tel-Aviv University. For many years he was a Visiting Professor at the Wharton School of the University of Pennsylvania.
Table of Contents
- Preface
- Before All Else
- CORPORATE FINANCE AND VALUATION
- Basic Financial Calculations
- Corporate Valuation Overview
- Calculating the Weighted Average Cost of Capital (WACC)
- Valuation Based on the Consolidated Statement of Cash Flows
- Pro Forma Financial Modeling
- Building a Pro Forma Model: The Case of a Caterpillar
- Financial Analysis of Leasing
- PORTFOLIO MODELS
- Portfolio Models – Introduction
- Calculating Efficient Portfolios
- Calculating the Variance-Covariance Matrix
- Estimating Betas and the Security Marked Line
- Efficient Portfolios Without Short Sales
- The Black-Litterman Approach to Portfolios Optimization
- Event Studies
- VALUATION OF OPTIONS
- Introduction to Options
- The Binomial Option Pricing Model
- The Black-Scholes Model
- Option Greeks
- VALUING BONDS
- Duration
- Immunization Strategies
- Modeling the Term Structure
- Calculating Default-Adjusted Expected Bond Returns
- MONTE CARLO METHODS
- Generating and Using Random Numbers
- An Introduction to Monte Carlo Methods
- Simulating Stock Prices
- Monte Carlo Simulations for Investments
- Value at Risk (VaR)
- Simulating Options and Options Strategies
- Using Monte Carlo Methods for Option Pricing
- EXCEL TECHNIQUES
- Data Tables
- Matrices
- Excel Functions
- Array Functions
- Some Excel Hints
- VISUAL BASIC FOR APPLICATIONS (VBA)
- User-Defined Functions with VBA
- Variables and Arrays
- Subroutine and User Interaction
- Objects and Add-In
- Selected References
- Index