Business Spreadsheets

Excel Real Options Valuation Template


by Business Spreadsheets

Application Description

The Excel Real Options Valuation template provides quantification of embedded value in potential business and investment strategies. Uncertainty surrounding potential cash flows from real options that exist from alternative strategic outcomes can be assessed for the valuation of those options. Real options can include multiple branch outcome possibilities competitive environment scenarios or options to abandon, expand or delay proposed projects.

Real Options Valuation provides a set and analytical tools for valuing strategic business management decisions that have a range of possible outcomes. Potential volatility of project or business cash flows can be utilized as a proxy for underlying risk for which a valuation can be derived based on the probability of each outcome eventuating. The Real Options Valuation model provides a simple guide in order to select and employ the most relevant valuation solution to the proposed strategy being considered. A modified Black Scholes option pricing model is provided to quantify the value in abandoning, delaying or expanding business projects. The Nash equilibrium game theory model is provided to evaluate the benefit of being a leader or follower when entering a competitive market. The binomial option valuation model allows the creation of multiple binary branches with corresponding outcome probabilities to flow back to the valuation at the origin node. The Real Options Valuation runs on both Windows and Macintosh operating systems.

Excel Real Options Valuation Template has not been reviewed by any customers.

Submit A Review

The views and opinions submitted and expressed here are not those of Microsoft.

App Details

  • Version:

    2.2
  • Release Date:

    2012/12/02
Screenshot 1 out of 3 Screenshot 2 out of 3 Screenshot 3 out of 3
> <
Screenshot 1 out of 3 Screenshot 2 out of 3 Screenshot 3 out of 3