Excel Spreadsheets

The following spreadsheets are distributed without warranty or technical support.

Real Options: Binomial Model

Aircraft Options

Real Option: Binomial vs. Black-Scholes-Merton Model

Growth Options

Cash Flow Analysis: Earnings to Cash Flows

Vitamin A to Vitamin C

Synergies Valuation

Synergy Analysis

Event Studies, Beta Estimation

Regression Analysis


Restructuring Valuation

Financial Distress and Default Probabilities

Financial Distress: Implied Asset Value, Asset Volatility, and Default Probabilities

Excel Solver: Minimization

Simulation Resources

If you are interested in Monte Carlo Simulations, you should go to the following websites for free Excel add-ins and a whole book on simulations in economics and finance.