Purpose: This tool helps convert both objective data (e.g., revenue changes) and subjective valuation (e.g., value weights) into monetary equivalents. The final figures provide guidelines for decision-making, especially for calculating ROI.
Used in: Tool 7a
Helpful hint
To establish the cost of investment, refer back to Tool 2b where all the costs associated with your CBWM program for evaluation period. You can also play around with the ROI by inputting different funding request amounts as the Cost of Investment to see how the ROI responds to the costs outlined.
How to use
This worksheet can be used manually, with a calculator, or in spreadsheet programs (e.g., Excel or Google Sheets) for automated calculations.