Spreadsheet skills competitionTry our live spreadsheet skills quiz



On this page a valuation model is available that combines a simple framework with advanced analytics. The model's main purpose is to give "big picture" insights into valuation principles, dynamics and sensitivities.

The model's design goals are to:

  • Implement and reconcile discounted cash flow, ratio and economic profit approaches
  • Provide transparency of calculation and methodology
  • Incorporate sophisticated analytics
  • Perform comprehensive term structure modelling of capital costs and value evolution
  • Allow user-defined additions and calculations
  • Give feedback about error conditions / invalid / inconsistent assumptions
  • Do the preceding whilst avoiding having to use macros or iteration

Download the modelOption Analyser
See a user guide to the modelOption Analyser