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.
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.
No comments:
Post a Comment