Option pricing spreadsheet that calculates the theoretical price and all of the Option Greeks for European Call and Put options. The spreadsheet also allows the user to enter up to 10 option legs for option strategy combination pricing. The calculations are made in Visual Basic and all of the code used is fully disclosed in the Visual Basic editor for user intervention.
The Real Option Valuation model encompasses a suite 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 rate. While this is a worthwhile exercise, it fails to consider the myriad of strategic options that are associated with many investments.
