
Now for something surprising. This can all be replaced by a single excel sheet, with a single excel tab. This is because the theory behind the option pricing model defines an option's value in terms of a couple of parameters of the underlying share - namely its price, expected volatility and dividend payout structure over the life of the option. Stripped down like this, all shares look identical to the option pricing model. It doesn't care which particular share it is a derivative on. Only that there's always a price, expected volatility and dividend payment structure available to it for any moment it is asked for a valuation. The option also needs to know the current values of a couple of low risk interest rates, and finally it needs to know four definitional constants - start up parameters, if you like - Is it a call or a put? Can the current holder get out of the deal during the life of the option, or only on the final day? Just when is that final day? And what's the line-in-the-sand strike price of the option, the price point around which it operates?
This single model can actually be implemented in a couple of ways, but they'll essentially give the same result. And I'm deliberately ignoring the existence of so-called exotic options for now.
What about history? Microsoft is now trading at 30.24. Way back in 2005, Apple was also trading at 30.24. If they had the same dividend payment structure and expected volatility, and if interest rates were the same at those points in time too, then all the calls and puts you could imagine on these two names ought to be valued at the same levels. It doesn't matter one bit to this insight that in reality interest rates are never exactly the same, or that volatility expectations are never exactly the same. The insight still holds - there is only one option.


The option car doesn't need a corporate valuation model - which in this case would be a guess as to which person the driver cares to listen to at any moment, or a prediction of what his right foot will do next - the option car simply tracks the car as best it can. The car contents can be a black box to the option car. Once the option car learns this trick, it can track any driver on any road anywhere, for any time.
Even more dramatically, you could pre-calculate all these numbers in an excel sheet and store them down. From that point on, the valuation of any stock's option would be a straight table lookup in excel. People would never do this because the lookup table would be too large; running the recipe is a better time-space trade-off proposition.