Real Options Valuation

User Guide for the Real Options Valuation Excel template by Business Spreadsheets

Find Excel Solutions


Search User Guides:


Need a Customized Excel Solution?
Post your project to the community of experienced Excel professionals to ensure that your development requirements are most efficiently met and complete. Post a Project


Follow Business Spreadsheets On:
 
User Guide Navigation:
Business Spreadsheets User Guides: Project Planning and Management | Multiple Regression Analysis and Forecasting | Investment and Business Valuation | Real Options Valuation | Portfolio Optimization | Portfolio Performance Tracking | Customer Invoicing
Real Options Valuation Help Topics: Option Pricing Fundamentals | The Option to Delay a Project | The Option to Expand a Project | The Option to Abandon a Project | Binomial Option Pricing | Game Theory Analysis

While the traditional discounted cash flow analysis produced by the Investment and Business Valuation model is a worthwhile exercise, it fails to consider any potential strategic options that may be associated with the proposal. The Real Options Valuation model provides the means to extend the traditional analysis by quantifying any such options that may be apparent. The model encompasses a suite of option pricing tools to quantify the embedded strategic value for a range of investment and decision making scenarios. Such tools include modified versions of the Black-Scholes Option pricing model to value:

  • 1. The option to Delay a project.
  • 2. The option to Expand a project.
  • 3. The option to Abandon a project.
  • Binomial Option pricing model to value options on options and compare scenarios.
  • Game Theory model competitive dynamics for entering a market.

 

The Menu sheet of the Real Options Valuation model provides a short description of each of these tools so that the most appropriate model can be quickly chosen for valuation.

 

Additional support resources: Download | Video | Forum | FAQ


  
 




Find Excel templates
and add-ins in the
Excel Business Solutions Directory

       
  © 2013 Business Spreadsheets. All Rights Reserved. Legal |