Value Map (Excel)

< Back

This is an Excel spreadsheet of the value map with preset formulas to help you calculate your impact. The template also includes a page of guidance notes to assist you in using the value map.

This spreadsheet includes two versions of the value map;

– SROI Value Map
– Value Map (non-SROI)

The SROI Value Map sheet is to be used where the analysis uses monetary valuation of outcomes (i.e. a conventional SROI analysis). The SROI Value Map includes formulae to calculate Present Value, Net Present Value, the SROI ratio and the ability to apply a discount rate.

The Value Map (non-SROI) sheet is to be used where the analysis does not use monetary valuation of outcomes (e.g. relative importance of outcomes is expressed using a weighting). The Value Map (non-SROI) sheet does not include formulae to calculate Present Value, Net Present Value, the SROI ratio or the ability to apply a discount rate.

Download

Comments are closed.