2021-10-12 P&E Agenda - Item 10 - Attachment 1 - Social Return on Investment Evaluation

A                      B                          C                D                              E               F                G              H            I                J
Focus area             Output / benefit           No. of units 1   Value or                       Interim Value   Deadweight   2   Attribution    Drop off 3   Displacement 4   Value /
                                                                   Financial proxy                                Would have       Allowing for   Extent of    Benefit taken    impact
                                                                                                                  happened         external       estimate     from
                                                                                                                  anyway           assistance/    decline at   somewhere else
                                                                                                                                   factors        12-month
                                                                                                                                                  mark
Students


Value of focused       Enhanced knowledge         50 x students    Assume equivalent value of     $7,500          -                -              10%          -                $6,750
talent                 and skill, greater                          5h (only) of private tuition
development            engagement with                             @ $30/h.
through tech. clubs    education
for students
Value of focused       Enhanced knowledge         150 x students   Assume equivalent value of     $4,500          -                -              -                             $4,500
digital tuition        and skill, greater                          1h (only) of private tuition
through holiday        engagement with                             @ $30/h.
programs               education
Talent migration       Productive economic        5 x students     Assume 20h/ week               $100,000        5%               5%             10%          -                $80,000
into digital work      activity & jobs, able to   (notional        @$25/h x 40w/p.a.
                       live locally – strong      number only)     (Figures are intentionally
                       social and family bonds                     conservative)
                       etc
Greater personal       Enhanced personal,         30 x students    Assume equivalent value of     $1,800          -                               10%          -                $1,620
confidence and         career and life            (notional        2h (only) of private tuition
enhanced focus on      outcomes                   number)          @ $60/h. ($30 x 2)
education
Council, as investor


Council OPEX           Wages, services,           1 x P&L loss     NA – direct value              (80,000)        -                               -            -                ($80,000) 7
                       materials                                   20/21 loss, $80,000
Turnover – café        Wages, supplies            1x               $50,000 (estimate)             $50,000         -                               -            10%              $45,000
Government             Construction jobs,         1x               $2,500,000 grants              $2.5m           -                               -            -                $2,500,000
Grants (2020/21        supplies
only)                                                                                                                                                          8
                       Construction jobs,         1x               Multiplier (0.54) - $2.5m      $1.25m          -                               -                             $1,350,000
                       supplies


39