Social Return on Investment – The Impact Map for the worked example (continued from previous page)
Organisation Wheels-to-Meals Name
Objectives
Provide luncheon club for 30 elderly local residents with additional health and social benefits
by bringing residents to meals
Date
Activity
30 places for eligible elderly and/or disabled local
Scope
residents 5 days a week, 50 weeks of the year
Objective of Activity Time Period 1 year (2010)
Contract/Funding/Part of organisation Local Authority Grant Purpose of Analysis Forecast or Evaluation
Forecast
Stage 5
Calculating Social Return
Discount rate (%) 3.5%
Year 1 Year 2 Year 3 Year 4 Year 5
(after activity)
£625.10 £0.00 £0.00 £0.00 £0.00
£33,010.60 £0.00 £0.00 £0.00 £0.00
£48,013.00 £0.00 £0.00 £0.00 £0.00
£1,539.00 £1,385.10 £1,246.59 £1,121.93 £1,009.74
£451.62 £0.00 £0.00 £0.00 £0.00
£0.00 £0.00 £0.00 £0.00 £0.00
£0.00 £0.00 £0.00 £0.00 £0.00
£175.50 £0.00 £0.00 £0.00 £0.00
-£1,306.25 -£1,240.94 -£1,178.89 £0.00 £0.00
£82,508.57 £144.16 £67.70 £1,121.93 £1,009.74
Present Value* £79,718.43 £134.58 £61.06 £977.70 £850.17
Total Present Value (PV) £81,741.93
Net Present Value £39,366.93
Social Return £ per £ £1.93: £1
* See page 68 for an explanation of these calculations 10
Page 1  |  Page 2  |  Page 3  |  Page 4  |  Page 5  |  Page 6  |  Page 7  |  Page 8  |  Page 9  |  Page 10  |  Page 11  |  Page 12  |  Page 13  |  Page 14  |  Page 15  |  Page 16  |  Page 17  |  Page 18  |  Page 19  |  Page 20  |  Page 21  |  Page 22  |  Page 23  |  Page 24  |  Page 25  |  Page 26  |  Page 27  |  Page 28  |  Page 29  |  Page 30  |  Page 31  |  Page 32  |  Page 33  |  Page 34  |  Page 35  |  Page 36  |  Page 37  |  Page 38  |  Page 39  |  Page 40  |  Page 41  |  Page 42  |  Page 43  |  Page 44  |  Page 45  |  Page 46  |  Page 47  |  Page 48  |  Page 49  |  Page 50  |  Page 51  |  Page 52  |  Page 53  |  Page 54  |  Page 55  |  Page 56  |  Page 57  |  Page 58  |  Page 59  |  Page 60  |  Page 61  |  Page 62  |  Page 63  |  Page 64  |  Page 65  |  Page 66  |  Page 67  |  Page 68  |  Page 69  |  Page 70  |  Page 71  |  Page 72  |  Page 73  |  Page 74  |  Page 75  |  Page 76  |  Page 77  |  Page 78  |  Page 79  |  Page 80  |  Page 81  |  Page 82  |  Page 83  |  Page 84  |  Page 85  |  Page 86  |  Page 87  |  Page 88  |  Page 89  |  Page 90  |  Page 91  |  Page 92  |  Page 93  |  Page 94  |  Page 95  |  Page 96  |  Page 97  |  Page 98  |  Page 99  |  Page 100  |  Page 101  |  Page 102  |  Page 103  |  Page 104  |  Page 105  |  Page 106  |  Page 107  |  Page 108