From Business Spreadsheets:
The Real Option Valuation template combines a set of option pricing tools to quantify the embedded strategic value for a range of financial analysis and investment scenarios. Traditional discounted cash flow investment analysis will only accept an investment if the returns on the project exceed the hurdle cost of capital rate. This is a worthwhile exercise as input for valuing real options; however it ignores any strategic options that are commonly associated with many investment decisions. Real option valuation provides the ability to identify what options might exist in a business proposal and the tools to estimate the quantification of them. The real option valuation template combines ease and flexibility of input with embedded help prompts to assist with selecting the correct option valuation model for the investment decision. Modified Black Scholes option pricing models are provide to value the options to delay, expand or abandon proposed of existing business streams or investments. An unlimited branch binomial tree builder model can be employed to evaluate complex strategic options with multiple stages. The Nash equilibrium Game Theory option model evaluates market entry strategies in a competitive environment with clear results on whether to lead, follow or enter the market simultaneously with competitors. Historical investment and/or industry risk profiles can be utilized across real option valuation models as a proxy of risk for the analyzed investment. The Real Option Valuation template is compatible with Excel 97-2016 for Windows and Excel 2016, 2011 or 2004 for Mac as a cross platform real options valuation solution.