Financial Modeling

Financial Modeling

Review Financial Modeling

by SIMON BENNINGA

Description

Financial Modeling is a guidebook that utilizes the power of Excel to arrive at higher financial resolve. These guide practitioners on how to integrate financial frameworks in excel ideal for academic purposes or just templates for finance professionals. With a clear, systematized presentation, readers may pick up how-to knowledge about Excel and its function to multiple financial structures and models.

Latest updates and revision guarantee that readers are provided with a comprehensive topic discussion, which encompasses the fundamentals of financial Modeling with a focus on the Monte Carlo model, Nelson-Siegel model, and various valuation principles.

In the fourth edition of Financial Modeling, a unique function leaves readers hassle-free learning through access codes attached at the back cover. Through this kind of setup, excel sheets and solutions are ready for download for practice and exercises.

About the Author

Simon Benninga wrote Financial Modeling intending to provide an Excel guide to resolve financial issues and concerns. For 20 years, he endeavored to write a series of books about financial Modeling with his recent titles, Financial Modeling, and Principles of Finance with Excel.

Table of Contents

Preface

Before All Else 

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 the Caterpillar
  7. Financial Analysis of Leasing

PORTFOLIO MODELS

  1. Portfolio Models- Introduction
  2. Calculating Efficient Portfolios
  3. Calculating the Variance-Covariance Matrix
  4. Estimating Betas and the Security Market Line
  5. Efficient Portfolios Without Short Sales
  6. The Black-Litterman Approach to Portfolio Optimization
  7. Event Studies

VALUATION OF OPTIONS

  1. Introduction to Options
  2. The Binomial Option Pricing Model
  3. The Black Scholes Model
  4. Option Greeks
  5. Real Options

VALUING BONDS 

  1. Duration
  2. Immunization Strategies
  3. Modeling the Term Structure
  4. Calculating Default-Adjusted Expected Bond Returns

MONTE CARLO METHODS

  1. Generating and Using Random Numbers
  2. An introduction to Monte Carlo Methods
  3. Simulating Stock Prices
  4. Monte Carlo Simulations for Investments
  5. 28- Value at Risk (VaR)
  6. Simulating Options and Option Strategies
  7.  Using Monte Carlo Methods for Option Pricing

EXCEL TECHNIQUES

  1. Data Tables
  2. Matrices
  3. Excel Functions
  4. Array Functions
  5. Some Excel Hints

VISUAL BASIC FOR APPLICATIONS (VBA) 

  1. User-Defined Functions with VBA
  2. Variables and Arrays
  3.  Subroutines and user Interaction
  4. Objects and Add-Ins

Selected References

Index