Real Options Spreadsheet in action: Foresight.co.uk "Exploiting the Electromagnetic Spectrum"

Foresight.co.uk is the British government's efforts at tracking, spotting and managing technological and scientific development. To value the cost and benefits of 'Exploiting the Electromagnetic Spectrum' they used Real Option Theory and tasked University of Manchester to develop a spreadsheet to calculate option prices of completing certain project milestones.

Link to the main page: "Foresight Real Options Model"

Link to the PDF Manual.

Link to the Option Calculator (Excel Spreadsheet).

Crack open the PDF manual and they'll explain clearly what all the cells do and how they relate to each other. Very insightful if you are thinking of developing a Real Option spreadsheet of your own.

Real Option Valuation Spreadsheet

URL: http://pages.stern.nyu.edu/~adamodar/

For all you MBAs, MScs, CFAs, finance undergrads/postgrads, whatever, I bring to you, the sourcebook, the panacea for all your valuation pains - Damodaran Online!

Checks its outs, yo, all your excel spreadsheets preconfigured with the formula so that all you've gotta do now is plug accounting numbers to relevant cells, do a bit of messing about with the numbers and voila! numbers for you to plug into that term report.

Damodaran is the man!

(Apologies for the slang; I don't quite know what came over me.)