Cost-Benefit-Analysis-Tool

Document Sample
Cost-Benefit-Analysis-Tool Powered By Docstoc
					Economic Analysis                        <title of the investment proposal>
Summary Table
Saturday, September 01, 2012

                                                Option 1           Option 2         Option 3
                                             <description>      <description>     <description>
Appraisal period (years)                                   30                 30               30
Capital Costs                                              $0         $2,000,000    $30,000,000
Whole of Life Costs                             $15,000,000         $17,000,000     $45,000,000
Cost-benefit analysis of monetary costs and benefits at the Public Sector Discount Rate
Present Value of Benefits                        $5,849,716           $7,604,631    $39,841,423
Present Value of Costs                           $5,849,716           $7,849,716    $35,479,345
Benefit Cost Ratio                                       1.00               0.97             1.12
Net Present Value                                          $0          -$245,085      $4,362,077
Multi-Criteria Analysis ranking of intangible costs and benefits (if any)
Criteria 1                                               1.50               2.50             2.50
Criteria 2                                               1.25               2.25
Criteria 3                                               0.60               0.90             1.20
Criteria 4                                               0.40               0.30             0.50
Weighted Score                                            3.8                 6.0             4.2
  Option 4
<description>
             30
  $55,000,000
  $70,000,000

  $47,718,390
  $43,903,348
         1.09
   $3,815,042

          2.50
          1.50
          1.20
          0.80
           6.0
Cost Benefit Analysis                     <title of the investment proposal>
Option 1:                                 <description of the option>
Saturday, September 01, 2012

Key Assumptions:
Public Sector Discount Rate 2011                   8.00%
Appraisal period (years)                              30 years

Summary of the Results of the Analysis:
Capital Costs                                         $0
Whole of Life Costs                          $15,000,000
Present Value of Benefits                     $5,849,716
Present Value of Costs                        $5,849,716
Benefit Cost Ratio                                  1.00
Net Present Value                                     $0

                                                       0                1             2
Year                                                2012             2013          2014
Discount factor (mid-year)                       0.96225          0.89097       0.82497
Discount factor (start of year)                  1.00000          0.92593       0.85734

Benefit 1 <description>                         $100,000         $100,000      $100,000
Benefit 2 <description>                         $100,000         $100,000      $100,000
Benefit 3 <description>                         $100,000         $100,000      $100,000
Benefit 4 <description>                         $100,000         $100,000      $100,000
Benefit 5 <description>                         $100,000         $100,000      $100,000
Total Benefits (mid-year)                       $500,000         $500,000      $500,000

Present Value of Benefits (mid-yr)             $481,125          $445,486      $412,487
Present Value of Benefits                     $5,849,716

Cost 1 <description>                           -$100,000         -$100,000     -$100,000
Cost 2 <description>                           -$100,000         -$100,000     -$100,000
Cost 3 <description>                           -$100,000         -$100,000     -$100,000
Cost 4 <description>                           -$100,000         -$100,000     -$100,000
Cost 5 <description>                           -$100,000         -$100,000     -$100,000
Total Costs (mid-year)                         -$500,000         -$500,000     -$500,000

Capital Costs (at start of year)                       $0               $0            $0
Total Costs                                     -$500,000        -$500,000     -$500,000
Total Capital Costs                                    $0
Total Whole of Life Costs                    -$15,000,000

Present Value of Costs (mid-year)               -$481,125        -$445,486     -$412,487
Present Value of Costs (start year)                    $0               $0            $0
Present Value of Costs (by year)                -$481,125        -$445,486     -$412,487
Present Value of Costs                        -$5,849,716

Net Cash Flows                                        $0               $0            $0
Net Present Value (by year)                     $0         $0         $0
Cumulative NPV                                  $0         $0         $0


Chart data only:
Year                                              0          1          2
Present Value of Benefits ($million)     $   0.481 $    0.445 $    0.412
Present Value of Costs ($million)       -$   0.481 -$   0.445 -$   0.412
Cumulative Net Present Value ($million) $      -    $     -    $     -
       3           4           5           6           7
    2015        2016        2017        2018        2019
 0.76387     0.70728     0.65489     0.60638     0.56146
 0.79383     0.73503     0.68058     0.63017     0.58349

$100,000    $100,000    $100,000    $100,000    $100,000
$100,000    $100,000    $100,000    $100,000    $100,000
$100,000    $100,000    $100,000    $100,000    $100,000
$100,000    $100,000    $100,000    $100,000    $100,000
$100,000    $100,000    $100,000    $100,000    $100,000
$500,000    $500,000    $500,000    $500,000    $500,000

$381,933    $353,641    $327,446    $303,191    $280,732



-$100,000   -$100,000   -$100,000   -$100,000   -$100,000
-$100,000   -$100,000   -$100,000   -$100,000   -$100,000
-$100,000   -$100,000   -$100,000   -$100,000   -$100,000
-$100,000   -$100,000   -$100,000   -$100,000   -$100,000
-$100,000   -$100,000   -$100,000   -$100,000   -$100,000
-$500,000   -$500,000   -$500,000   -$500,000   -$500,000

       $0          $0          $0          $0          $0
-$500,000   -$500,000   -$500,000   -$500,000   -$500,000




-$381,933   -$353,641   -$327,446   -$303,191   -$280,732
       $0          $0          $0          $0          $0
-$381,933   -$353,641   -$327,446   -$303,191   -$280,732



      $0          $0          $0          $0          $0
        $0         $0         $0         $0         $0
        $0         $0         $0         $0         $0




          3          4          5          6          7
 $   0.382 $    0.354 $    0.327 $    0.303 $    0.281
-$   0.382 -$   0.354 -$   0.327 -$   0.303 -$   0.281
 $     -    $     -    $     -    $     -    $     -
       8           9          10          11          12
    2020        2021        2022        2023        2024
 0.51987     0.48136     0.44571     0.41269     0.38212
 0.54027     0.50025     0.46319     0.42888     0.39711

$100,000    $100,000    $100,000    $100,000    $100,000
$100,000    $100,000    $100,000    $100,000    $100,000
$100,000    $100,000    $100,000    $100,000    $100,000
$100,000    $100,000    $100,000    $100,000    $100,000
$100,000    $100,000    $100,000    $100,000    $100,000
$500,000    $500,000    $500,000    $500,000    $500,000

$259,937    $240,682    $222,854    $206,346    $191,061



-$100,000   -$100,000   -$100,000   -$100,000   -$100,000
-$100,000   -$100,000   -$100,000   -$100,000   -$100,000
-$100,000   -$100,000   -$100,000   -$100,000   -$100,000
-$100,000   -$100,000   -$100,000   -$100,000   -$100,000
-$100,000   -$100,000   -$100,000   -$100,000   -$100,000
-$500,000   -$500,000   -$500,000   -$500,000   -$500,000

       $0          $0          $0          $0          $0
-$500,000   -$500,000   -$500,000   -$500,000   -$500,000




-$259,937   -$240,682   -$222,854   -$206,346   -$191,061
       $0          $0          $0          $0          $0
-$259,937   -$240,682   -$222,854   -$206,346   -$191,061



      $0          $0          $0          $0          $0
        $0         $0         $0         $0         $0
        $0         $0         $0         $0         $0




          8          9         10         11         12
 $   0.260 $    0.241 $    0.223 $    0.206 $    0.191
-$   0.260 -$   0.241 -$   0.223 -$   0.206 -$   0.191
 $     -    $     -    $     -    $     -    $     -
      13          14          15          16          17
    2025        2026        2027        2028        2029
 0.35382     0.32761     0.30334     0.28087     0.26007
 0.36770     0.34046     0.31524     0.29189     0.27027

$100,000    $100,000    $100,000    $100,000    $100,000
$100,000    $100,000    $100,000    $100,000    $100,000
$100,000    $100,000    $100,000    $100,000    $100,000
$100,000    $100,000    $100,000    $100,000    $100,000
$100,000    $100,000    $100,000    $100,000    $100,000
$500,000    $500,000    $500,000    $500,000    $500,000

$176,909    $163,804    $151,671    $140,436    $130,033



-$100,000   -$100,000   -$100,000   -$100,000   -$100,000
-$100,000   -$100,000   -$100,000   -$100,000   -$100,000
-$100,000   -$100,000   -$100,000   -$100,000   -$100,000
-$100,000   -$100,000   -$100,000   -$100,000   -$100,000
-$100,000   -$100,000   -$100,000   -$100,000   -$100,000
-$500,000   -$500,000   -$500,000   -$500,000   -$500,000

       $0          $0          $0          $0          $0
-$500,000   -$500,000   -$500,000   -$500,000   -$500,000




-$176,909   -$163,804   -$151,671   -$140,436   -$130,033
       $0          $0          $0          $0          $0
-$176,909   -$163,804   -$151,671   -$140,436   -$130,033



      $0          $0          $0          $0          $0
        $0         $0         $0         $0         $0
        $0         $0         $0         $0         $0




         13         14         15         16         17
 $   0.177 $    0.164 $    0.152 $    0.140 $    0.130
-$   0.177 -$   0.164 -$   0.152 -$   0.140 -$   0.130
 $     -    $     -    $     -    $     -    $     -
      18          19          20          21          22
    2030        2031        2032        2033        2034
 0.24080     0.22297     0.20645     0.19116     0.17700
 0.25025     0.23171     0.21455     0.19866     0.18394

$100,000    $100,000    $100,000    $100,000    $100,000
$100,000    $100,000    $100,000    $100,000    $100,000
$100,000    $100,000    $100,000    $100,000    $100,000
$100,000    $100,000    $100,000    $100,000    $100,000
$100,000    $100,000    $100,000    $100,000    $100,000
$500,000    $500,000    $500,000    $500,000    $500,000

$120,401    $111,483    $103,225     $95,578     $88,498



-$100,000   -$100,000   -$100,000   -$100,000   -$100,000
-$100,000   -$100,000   -$100,000   -$100,000   -$100,000
-$100,000   -$100,000   -$100,000   -$100,000   -$100,000
-$100,000   -$100,000   -$100,000   -$100,000   -$100,000
-$100,000   -$100,000   -$100,000   -$100,000   -$100,000
-$500,000   -$500,000   -$500,000   -$500,000   -$500,000

       $0          $0          $0          $0          $0
-$500,000   -$500,000   -$500,000   -$500,000   -$500,000




-$120,401   -$111,483   -$103,225    -$95,578    -$88,498
       $0          $0          $0          $0          $0
-$120,401   -$111,483   -$103,225    -$95,578    -$88,498



      $0          $0          $0          $0          $0
        $0         $0         $0         $0         $0
        $0         $0         $0         $0         $0




         18         19         20         21         22
 $   0.120 $    0.111 $    0.103 $    0.096 $    0.088
-$   0.120 -$   0.111 -$   0.103 -$   0.096 -$   0.088
 $     -    $     -    $     -    $     -    $     -
      23          24          25          26          27
    2035        2036        2037        2038        2039
 0.16389     0.15175     0.14051     0.13010     0.12046
 0.17032     0.15770     0.14602     0.13520     0.12519

$100,000    $100,000    $100,000    $100,000    $100,000
$100,000    $100,000    $100,000    $100,000    $100,000
$100,000    $100,000    $100,000    $100,000    $100,000
$100,000    $100,000    $100,000    $100,000    $100,000
$100,000    $100,000    $100,000    $100,000    $100,000
$500,000    $500,000    $500,000    $500,000    $500,000

 $81,943     $75,873     $70,253     $65,049     $60,231



-$100,000   -$100,000   -$100,000   -$100,000   -$100,000
-$100,000   -$100,000   -$100,000   -$100,000   -$100,000
-$100,000   -$100,000   -$100,000   -$100,000   -$100,000
-$100,000   -$100,000   -$100,000   -$100,000   -$100,000
-$100,000   -$100,000   -$100,000   -$100,000   -$100,000
-$500,000   -$500,000   -$500,000   -$500,000   -$500,000

       $0          $0          $0          $0          $0
-$500,000   -$500,000   -$500,000   -$500,000   -$500,000




 -$81,943    -$75,873    -$70,253    -$65,049    -$60,231
       $0          $0          $0          $0          $0
 -$81,943    -$75,873    -$70,253    -$65,049    -$60,231



      $0          $0          $0          $0          $0
        $0         $0         $0         $0         $0
        $0         $0         $0         $0         $0




         23         24         25         26         27
 $   0.082 $    0.076 $    0.070 $    0.065 $    0.060
-$   0.082 -$   0.076 -$   0.070 -$   0.065 -$   0.060
 $     -    $     -    $     -    $     -    $     -
      28          29       1000      1000      1000
    2040        2041       2042      2043      2044
 0.11154     0.10328    0.00000   0.00000   0.00000
 0.11591     0.10733    0.00000   0.00000   0.00000

$100,000    $100,000        $0        $0        $0
$100,000    $100,000        $0        $0        $0
$100,000    $100,000        $0        $0        $0
$100,000    $100,000        $0        $0        $0
$100,000    $100,000        $0        $0        $0
$500,000    $500,000        $0        $0        $0

 $55,769     $51,638        $0        $0        $0



-$100,000   -$100,000       $0        $0        $0
-$100,000   -$100,000       $0        $0        $0
-$100,000   -$100,000       $0        $0        $0
-$100,000   -$100,000       $0        $0        $0
-$100,000   -$100,000       $0        $0        $0
-$500,000   -$500,000       $0        $0        $0

       $0          $0       $0        $0        $0
-$500,000   -$500,000       $0        $0        $0




 -$55,769    -$51,638       $0        $0        $0
       $0          $0       $0        $0        $0
 -$55,769    -$51,638       $0        $0        $0



      $0          $0        $0        $0        $0
        $0         $0       $0       $0        $0
        $0         $0       $0       $0        $0




         28         29     1000     1000     1000
 $   0.056 $    0.052 $     -   $    -   $    -
-$   0.056 -$   0.052 $     -   $    -   $    -
 $     -    $     -    $    -   $    -   $    -
   1000      1000      1000      1000      1000
   2045      2046      2047      2048      2049
0.00000   0.00000   0.00000   0.00000   0.00000
0.00000   0.00000   0.00000   0.00000   0.00000

    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0

    $0        $0        $0        $0        $0



    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0

    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0




    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0



    $0        $0        $0        $0        $0
     $0       $0       $0       $0        $0
     $0       $0       $0       $0        $0




    1000     1000     1000     1000     1000
$    -   $    -   $    -   $    -   $    -
$    -   $    -   $    -   $    -   $    -
$    -   $    -   $    -   $    -   $    -
   1000      1000      1000      1000      1000
   2050      2051      2052      2053      2054
0.00000   0.00000   0.00000   0.00000   0.00000
0.00000   0.00000   0.00000   0.00000   0.00000

    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0

    $0        $0        $0        $0        $0



    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0

    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0




    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0



    $0        $0        $0        $0        $0
     $0       $0       $0       $0        $0
     $0       $0       $0       $0        $0




    1000     1000     1000     1000     1000
$    -   $    -   $    -   $    -   $    -
$    -   $    -   $    -   $    -   $    -
$    -   $    -   $    -   $    -   $    -
   1000      1000      1000      1000      1000
   2055      2056      2057      2058      2059
0.00000   0.00000   0.00000   0.00000   0.00000
0.00000   0.00000   0.00000   0.00000   0.00000

    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0

    $0        $0        $0        $0        $0



    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0

    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0




    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0



    $0        $0        $0        $0        $0
     $0       $0       $0       $0        $0
     $0       $0       $0       $0        $0




    1000     1000     1000     1000     1000
$    -   $    -   $    -   $    -   $    -
$    -   $    -   $    -   $    -   $    -
$    -   $    -   $    -   $    -   $    -
   1000      1000
   2060      2061
0.00000   0.00000
0.00000   0.00000

    $0        $0
    $0        $0
    $0        $0
    $0        $0
    $0        $0
    $0        $0

    $0        $0



    $0        $0
    $0        $0
    $0        $0
    $0        $0
    $0        $0
    $0        $0

    $0        $0
    $0        $0




    $0        $0
    $0        $0
    $0        $0



    $0        $0
     $0        $0
     $0        $0




    1000     1000
$    -   $    -
$    -   $    -
$    -   $    -
                                                                         Cost Benefit Analysis: Option 1
                              $1




                              $0




                              $0
Todays Dollars ($ millions)




                              $0




                              -$0




                              -$0
                                                                                                                         Present Value of Benefits ($million)

                                                                                                                         Present Value of Costs ($million)

                                                                                                                         Cumulative Net Present Value ($million)
                              -$1
                                    1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50
                                                                                                       Year
Cost Benefit Analysis                     <title of the investment proposal>
Option 2:                                 <description of the option>
Saturday, September 01, 2012

Key Assumptions:
Public Sector Discount Rate 2011                   8.00%
Appraisal period (years)                              30 years

Summary of the Results of the Analysis:
Capital Costs                                 $2,000,000
Whole of Life Costs                          $17,000,000
Present Value of Benefits                     $7,604,631
Present Value of Costs                        $7,849,716
Benefit Cost Ratio                                  0.97
Net Present Value                              -$245,085

                                                       0                1             2
Year                                                2012             2013          2014
Discount factor (mid-year)                       0.96225          0.89097       0.82497
Discount factor (start of year)                  1.00000          0.92593       0.85734

Benefit 1 <description>                         $250,000         $250,000      $250,000
Benefit 2 <description>                         $100,000         $100,000      $100,000
Benefit 3 <description>                         $100,000         $100,000      $100,000
Benefit 4 <description>                         $100,000         $100,000      $100,000
Benefit 5 <description>                         $100,000         $100,000      $100,000
Total Benefits (mid-year)                       $650,000         $650,000      $650,000

Present Value of Benefits (mid-yr)             $625,463          $579,132      $536,234
Present Value of Benefits                     $7,604,631

Cost 1 <description>                           -$100,000         -$100,000     -$100,000
Cost 2 <description>                           -$100,000         -$100,000     -$100,000
Cost 3 <description>                           -$100,000         -$100,000     -$100,000
Cost 4 <description>                           -$100,000         -$100,000     -$100,000
Cost 5 <description>                           -$100,000         -$100,000     -$100,000
Total Costs (mid-year)                         -$500,000         -$500,000     -$500,000

Capital Costs (at start of year)              -$2,000,000               $0            $0
Total Costs                                   -$2,500,000        -$500,000     -$500,000
Total Capital Costs                           -$2,000,000
Total Whole of Life Costs                    -$17,000,000

Present Value of Costs (mid-year)               -$481,125        -$445,486     -$412,487
Present Value of Costs (start year)           -$2,000,000               $0            $0
Present Value of Costs (by year)              -$2,481,125        -$445,486     -$412,487
Present Value of Costs                        -$7,849,716

Net Cash Flows                                -$1,850,000        $150,000      $150,000
Net Present Value (by year)                  -$1,855,662       $133,646        $123,746
Cumulative NPV                               -$1,855,662     -$1,722,017     -$1,598,270


Chart data only:
Year                                                   0               1               2
Present Value of Benefits ($million)     $        0.625 $         0.579 $         0.536
Present Value of Costs ($million)       -$        2.481 -$        0.445 -$        0.412
Cumulative Net Present Value ($million) -$        1.856 -$        1.722 -$        1.598
       3           4           5           6           7
    2015        2016        2017        2018        2019
 0.76387     0.70728     0.65489     0.60638     0.56146
 0.79383     0.73503     0.68058     0.63017     0.58349

$250,000    $250,000    $250,000    $250,000    $250,000
$100,000    $100,000    $100,000    $100,000    $100,000
$100,000    $100,000    $100,000    $100,000    $100,000
$100,000    $100,000    $100,000    $100,000    $100,000
$100,000    $100,000    $100,000    $100,000    $100,000
$650,000    $650,000    $650,000    $650,000    $650,000

$496,513    $459,734    $425,679    $394,148    $364,952



-$100,000   -$100,000   -$100,000   -$100,000   -$100,000
-$100,000   -$100,000   -$100,000   -$100,000   -$100,000
-$100,000   -$100,000   -$100,000   -$100,000   -$100,000
-$100,000   -$100,000   -$100,000   -$100,000   -$100,000
-$100,000   -$100,000   -$100,000   -$100,000   -$100,000
-$500,000   -$500,000   -$500,000   -$500,000   -$500,000

       $0          $0          $0          $0          $0
-$500,000   -$500,000   -$500,000   -$500,000   -$500,000




-$381,933   -$353,641   -$327,446   -$303,191   -$280,732
       $0          $0          $0          $0          $0
-$381,933   -$353,641   -$327,446   -$303,191   -$280,732



$150,000    $150,000    $150,000    $150,000    $150,000
       $114,580        $106,092          $98,234         $90,957         $84,220
     -$1,483,691     -$1,377,598     -$1,279,364     -$1,188,407     -$1,104,188




               3               4               5               6               7
 $        0.497 $         0.460 $         0.426 $         0.394 $         0.365
-$        0.382 -$        0.354 -$        0.327 -$        0.303 -$        0.281
-$        1.484 -$        1.378 -$        1.279 -$        1.188 -$        1.104
       8           9          10          11          12
    2020        2021        2022        2023        2024
 0.51987     0.48136     0.44571     0.41269     0.38212
 0.54027     0.50025     0.46319     0.42888     0.39711

$250,000    $250,000    $250,000    $250,000    $250,000
$100,000    $100,000    $100,000    $100,000    $100,000
$100,000    $100,000    $100,000    $100,000    $100,000
$100,000    $100,000    $100,000    $100,000    $100,000
$100,000    $100,000    $100,000    $100,000    $100,000
$650,000    $650,000    $650,000    $650,000    $650,000

$337,918    $312,887    $289,710    $268,250    $248,380



-$100,000   -$100,000   -$100,000   -$100,000   -$100,000
-$100,000   -$100,000   -$100,000   -$100,000   -$100,000
-$100,000   -$100,000   -$100,000   -$100,000   -$100,000
-$100,000   -$100,000   -$100,000   -$100,000   -$100,000
-$100,000   -$100,000   -$100,000   -$100,000   -$100,000
-$500,000   -$500,000   -$500,000   -$500,000   -$500,000

       $0          $0          $0          $0          $0
-$500,000   -$500,000   -$500,000   -$500,000   -$500,000




-$259,937   -$240,682   -$222,854   -$206,346   -$191,061
       $0          $0          $0          $0          $0
-$259,937   -$240,682   -$222,854   -$206,346   -$191,061



$150,000    $150,000    $150,000    $150,000    $150,000
         $77,981       $72,205       $66,856       $61,904       $57,318
     -$1,026,207     -$954,002     -$887,146     -$825,242     -$767,923




               8             9            10            11            12
 $        0.338 $       0.313 $       0.290 $       0.268 $       0.248
-$        0.260 -$      0.241 -$      0.223 -$      0.206 -$      0.191
-$        1.026 -$      0.954 -$      0.887 -$      0.825 -$      0.768
      13          14          15          16          17
    2025        2026        2027        2028        2029
 0.35382     0.32761     0.30334     0.28087     0.26007
 0.36770     0.34046     0.31524     0.29189     0.27027

$250,000    $250,000    $250,000    $250,000    $250,000
$100,000    $100,000    $100,000    $100,000    $100,000
$100,000    $100,000    $100,000    $100,000    $100,000
$100,000    $100,000    $100,000    $100,000    $100,000
$100,000    $100,000    $100,000    $100,000    $100,000
$650,000    $650,000    $650,000    $650,000    $650,000

$229,981    $212,946    $197,172    $182,567    $169,043



-$100,000   -$100,000   -$100,000   -$100,000   -$100,000
-$100,000   -$100,000   -$100,000   -$100,000   -$100,000
-$100,000   -$100,000   -$100,000   -$100,000   -$100,000
-$100,000   -$100,000   -$100,000   -$100,000   -$100,000
-$100,000   -$100,000   -$100,000   -$100,000   -$100,000
-$500,000   -$500,000   -$500,000   -$500,000   -$500,000

       $0          $0          $0          $0          $0
-$500,000   -$500,000   -$500,000   -$500,000   -$500,000




-$176,909   -$163,804   -$151,671   -$140,436   -$130,033
       $0          $0          $0          $0          $0
-$176,909   -$163,804   -$151,671   -$140,436   -$130,033



$150,000    $150,000    $150,000    $150,000    $150,000
       $53,073       $49,141       $45,501       $42,131       $39,010
     -$714,851     -$665,709     -$620,208     -$578,077     -$539,067




            13            14            15            16            17
 $      0.230 $       0.213 $       0.197 $       0.183 $       0.169
-$      0.177 -$      0.164 -$      0.152 -$      0.140 -$      0.130
-$      0.715 -$      0.666 -$      0.620 -$      0.578 -$      0.539
      18          19          20          21          22
    2030        2031        2032        2033        2034
 0.24080     0.22297     0.20645     0.19116     0.17700
 0.25025     0.23171     0.21455     0.19866     0.18394

$250,000    $250,000    $250,000    $250,000    $250,000
$100,000    $100,000    $100,000    $100,000    $100,000
$100,000    $100,000    $100,000    $100,000    $100,000
$100,000    $100,000    $100,000    $100,000    $100,000
$100,000    $100,000    $100,000    $100,000    $100,000
$650,000    $650,000    $650,000    $650,000    $650,000

$156,521    $144,927    $134,192    $124,252    $115,048



-$100,000   -$100,000   -$100,000   -$100,000   -$100,000
-$100,000   -$100,000   -$100,000   -$100,000   -$100,000
-$100,000   -$100,000   -$100,000   -$100,000   -$100,000
-$100,000   -$100,000   -$100,000   -$100,000   -$100,000
-$100,000   -$100,000   -$100,000   -$100,000   -$100,000
-$500,000   -$500,000   -$500,000   -$500,000   -$500,000

       $0          $0          $0          $0          $0
-$500,000   -$500,000   -$500,000   -$500,000   -$500,000




-$120,401   -$111,483   -$103,225    -$95,578    -$88,498
       $0          $0          $0          $0          $0
-$120,401   -$111,483   -$103,225    -$95,578    -$88,498



$150,000    $150,000    $150,000    $150,000    $150,000
       $36,120       $33,445       $30,967       $28,673       $26,550
     -$502,947     -$469,502     -$438,535     -$409,861     -$383,312




            18            19            20            21            22
 $      0.157 $       0.145 $       0.134 $       0.124 $       0.115
-$      0.120 -$      0.111 -$      0.103 -$      0.096 -$      0.088
-$      0.503 -$      0.470 -$      0.439 -$      0.410 -$      0.383
      23          24          25          26          27
    2035        2036        2037        2038        2039
 0.16389     0.15175     0.14051     0.13010     0.12046
 0.17032     0.15770     0.14602     0.13520     0.12519

$250,000    $250,000    $250,000    $250,000    $250,000
$100,000    $100,000    $100,000    $100,000    $100,000
$100,000    $100,000    $100,000    $100,000    $100,000
$100,000    $100,000    $100,000    $100,000    $100,000
$100,000    $100,000    $100,000    $100,000    $100,000
$650,000    $650,000    $650,000    $650,000    $650,000

$106,526     $98,635     $91,329     $84,564     $78,300



-$100,000   -$100,000   -$100,000   -$100,000   -$100,000
-$100,000   -$100,000   -$100,000   -$100,000   -$100,000
-$100,000   -$100,000   -$100,000   -$100,000   -$100,000
-$100,000   -$100,000   -$100,000   -$100,000   -$100,000
-$100,000   -$100,000   -$100,000   -$100,000   -$100,000
-$500,000   -$500,000   -$500,000   -$500,000   -$500,000

       $0          $0          $0          $0          $0
-$500,000   -$500,000   -$500,000   -$500,000   -$500,000




 -$81,943    -$75,873    -$70,253    -$65,049    -$60,231
       $0          $0          $0          $0          $0
 -$81,943    -$75,873    -$70,253    -$65,049    -$60,231



$150,000    $150,000    $150,000    $150,000    $150,000
       $24,583       $22,762       $21,076       $19,515       $18,069
     -$358,729     -$335,967     -$314,891     -$295,377     -$277,307




            23            24            25            26            27
 $      0.107 $       0.099 $       0.091 $       0.085 $       0.078
-$      0.082 -$      0.076 -$      0.070 -$      0.065 -$      0.060
-$      0.359 -$      0.336 -$      0.315 -$      0.295 -$      0.277
      28          29       1000      1000      1000
    2040        2041       2042      2043      2044
 0.11154     0.10328    0.00000   0.00000   0.00000
 0.11591     0.10733    0.00000   0.00000   0.00000

$250,000    $250,000        $0        $0        $0
$100,000    $100,000        $0        $0        $0
$100,000    $100,000        $0        $0        $0
$100,000    $100,000        $0        $0        $0
$100,000    $100,000        $0        $0        $0
$650,000    $650,000        $0        $0        $0

 $72,500     $67,129        $0        $0        $0



-$100,000   -$100,000       $0        $0        $0
-$100,000   -$100,000       $0        $0        $0
-$100,000   -$100,000       $0        $0        $0
-$100,000   -$100,000       $0        $0        $0
-$100,000   -$100,000       $0        $0        $0
-$500,000   -$500,000       $0        $0        $0

       $0          $0       $0        $0        $0
-$500,000   -$500,000       $0        $0        $0




 -$55,769    -$51,638       $0        $0        $0
       $0          $0       $0        $0        $0
 -$55,769    -$51,638       $0        $0        $0



$150,000    $150,000        $0        $0        $0
       $16,731       $15,491            $0            $0            $0
     -$260,577     -$245,085     -$245,085     -$245,085     -$245,085




            28            29         1000          1000          1000
 $      0.072 $       0.067 $         -    $        -    $        -
-$      0.056 -$      0.052 $         -    $        -    $        -
-$      0.261 -$      0.245 -$      0.245 -$      0.245 -$      0.245
   1000      1000      1000      1000      1000
   2045      2046      2047      2048      2049
0.00000   0.00000   0.00000   0.00000   0.00000
0.00000   0.00000   0.00000   0.00000   0.00000

    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0

    $0        $0        $0        $0        $0



    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0

    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0




    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0



    $0        $0        $0        $0        $0
            $0            $0            $0            $0            $0
     -$245,085     -$245,085     -$245,085     -$245,085     -$245,085




         1000          1000          1000          1000          1000
 $        -    $        -    $        -    $        -    $        -
 $        -    $        -    $        -    $        -    $        -
-$      0.245 -$      0.245 -$      0.245 -$      0.245 -$      0.245
   1000      1000      1000      1000      1000
   2050      2051      2052      2053      2054
0.00000   0.00000   0.00000   0.00000   0.00000
0.00000   0.00000   0.00000   0.00000   0.00000

    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0

    $0        $0        $0        $0        $0



    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0

    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0




    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0



    $0        $0        $0        $0        $0
            $0            $0            $0            $0            $0
     -$245,085     -$245,085     -$245,085     -$245,085     -$245,085




         1000          1000          1000          1000          1000
 $        -    $        -    $        -    $        -    $        -
 $        -    $        -    $        -    $        -    $        -
-$      0.245 -$      0.245 -$      0.245 -$      0.245 -$      0.245
   1000      1000      1000      1000      1000
   2055      2056      2057      2058      2059
0.00000   0.00000   0.00000   0.00000   0.00000
0.00000   0.00000   0.00000   0.00000   0.00000

    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0

    $0        $0        $0        $0        $0



    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0

    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0




    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0



    $0        $0        $0        $0        $0
            $0            $0            $0            $0            $0
     -$245,085     -$245,085     -$245,085     -$245,085     -$245,085




         1000          1000          1000          1000          1000
 $        -    $        -    $        -    $        -    $        -
 $        -    $        -    $        -    $        -    $        -
-$      0.245 -$      0.245 -$      0.245 -$      0.245 -$      0.245
   1000      1000
   2060      2061
0.00000   0.00000
0.00000   0.00000

    $0        $0
    $0        $0
    $0        $0
    $0        $0
    $0        $0
    $0        $0

    $0        $0



    $0        $0
    $0        $0
    $0        $0
    $0        $0
    $0        $0
    $0        $0

    $0        $0
    $0        $0




    $0        $0
    $0        $0
    $0        $0



    $0        $0
            $0            $0
     -$245,085     -$245,085




         1000          1000
 $        -    $        -
 $        -    $        -
-$      0.245 -$      0.245
                                                                         Cost Benefit Analysis: Option 2
                              $1




                              $1




                              $0
Todays Dollars ($ millions)




                              -$1




                              -$1




                              -$2




                              -$2


                                                                                                                         Present Value of Benefits ($million)
                              -$3
                                                                                                                         Present Value of Costs ($million)

                                                                                                                         Cumulative Net Present Value ($million)
                              -$3
                                    1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50
                                                                                                       Year
Cost Benefit Analysis                     <title of the investment proposal>
Option 3:                                 <description of the option>
Saturday, September 01, 2012

Key Assumptions:
Public Sector Discount Rate 2011                   8.00%
Appraisal period (years)                              30 years

Summary of the Results of the Analysis:
Capital Costs                                $30,000,000
Whole of Life Costs                          $45,000,000
Present Value of Benefits                    $39,841,423
Present Value of Costs                       $35,479,345
Benefit Cost Ratio                                  1.12
Net Present Value                             $4,362,077

                                                       0                  1            2
Year                                                2012               2013         2014
Discount factor (mid-year)                       0.96225            0.89097      0.82497
Discount factor (start of year)                  1.00000            0.92593      0.85734

Benefit 1 <description>                        $400,000           $800,000      $800,000
Benefit 2 <description>                       $1,000,000         $1,000,000    $1,000,000
Benefit 3 <description>                        $100,000           $100,000      $100,000
Benefit 4 <description>                        $100,000           $100,000      $100,000
Benefit 5 <description>                        $750,000          $1,500,000    $1,500,000
Total Benefits (mid-year)                     $2,350,000         $3,500,000    $3,500,000

Present Value of Benefits (mid-yr)            $2,261,289         $3,118,404    $2,887,411
Present Value of Benefits                    $39,841,423

Cost 1 <description>                           -$100,000          -$100,000    -$100,000
Cost 2 <description>                           -$100,000          -$100,000    -$100,000
Cost 3 <description>                           -$100,000          -$100,000    -$100,000
Cost 4 <description>                           -$100,000          -$100,000    -$100,000
Cost 5 <description>                           -$100,000          -$100,000    -$100,000
Total Costs (mid-year)                         -$500,000          -$500,000    -$500,000

Capital Costs (at start of year)             -$25,000,000        -$5,000,000          $0
Total Costs                                  -$25,500,000        -$5,500,000   -$500,000
Total Capital Costs                          -$30,000,000
Total Whole of Life Costs                    -$45,000,000

Present Value of Costs (mid-year)               -$481,125          -$445,486   -$412,487
Present Value of Costs (start year)          -$25,000,000        -$4,629,630          $0
Present Value of Costs (by year)             -$25,481,125        -$5,075,116   -$412,487
Present Value of Costs                       -$35,479,345

Net Cash Flows                               -$23,150,000        -$2,000,000   $3,000,000
Net Present Value (by year)                  -$23,219,837      -$1,956,712       $2,474,924
Cumulative NPV                               -$23,219,837     -$25,176,548     -$22,701,624


Chart data only:
Year                                                    0                1                2
Present Value of Benefits ($million)     $         2.261 $          3.118 $          2.887
Present Value of Costs ($million)       -$        25.481 -$         5.075 -$         0.412
Cumulative Net Present Value ($million) -$        23.220 -$        25.177 -$        22.702
        3            4            5            6            7
     2015         2016         2017         2018         2019
  0.76387      0.70728      0.65489      0.60638      0.56146
  0.79383      0.73503      0.68058      0.63017      0.58349

 $800,000     $800,000     $800,000     $800,000     $800,000
$1,000,000   $1,000,000   $1,000,000   $1,000,000   $1,000,000
 $100,000     $100,000     $100,000     $100,000     $100,000
 $100,000     $100,000     $100,000     $100,000     $100,000
$1,500,000   $1,500,000   $1,500,000   $1,500,000   $1,500,000
$3,500,000   $3,500,000   $3,500,000   $3,500,000   $3,500,000

$2,673,529   $2,475,490   $2,292,120   $2,122,334   $1,965,124



-$100,000    -$100,000    -$100,000    -$100,000    -$100,000
-$100,000    -$100,000    -$100,000    -$100,000    -$100,000
-$100,000    -$100,000    -$100,000    -$100,000    -$100,000
-$100,000    -$100,000    -$100,000    -$100,000    -$100,000
-$100,000    -$100,000    -$100,000    -$100,000    -$100,000
-$500,000    -$500,000    -$500,000    -$500,000    -$500,000

       $0           $0           $0           $0           $0
-$500,000    -$500,000    -$500,000    -$500,000    -$500,000




-$381,933    -$353,641    -$327,446    -$303,191    -$280,732
       $0           $0           $0           $0           $0
-$381,933    -$353,641    -$327,446    -$303,191    -$280,732



$3,000,000   $3,000,000   $3,000,000   $3,000,000   $3,000,000
       $2,291,596       $2,121,848       $1,964,674       $1,819,143       $1,684,392
     -$20,410,028     -$18,288,180     -$16,323,505     -$14,504,362     -$12,819,971




                3                4                5                6                7
 $         2.674 $          2.475 $          2.292 $          2.122 $          1.965
-$         0.382 -$         0.354 -$         0.327 -$         0.303 -$         0.281
-$        20.410 -$        18.288 -$        16.324 -$        14.504 -$        12.820
        8            9           10           11           12
     2020         2021         2022         2023         2024
  0.51987      0.48136      0.44571      0.41269      0.38212
  0.54027      0.50025      0.46319      0.42888      0.39711

 $800,000     $800,000     $800,000     $800,000     $800,000
$1,000,000   $1,000,000   $1,000,000   $1,000,000   $1,000,000
 $100,000     $100,000     $100,000     $100,000     $100,000
 $100,000     $100,000     $100,000     $100,000     $100,000
$1,500,000   $1,500,000   $1,500,000   $1,500,000   $1,500,000
$3,500,000   $3,500,000   $3,500,000   $3,500,000   $3,500,000

$1,819,559   $1,684,777   $1,559,978   $1,444,425   $1,337,430



-$100,000    -$100,000    -$100,000    -$100,000    -$100,000
-$100,000    -$100,000    -$100,000    -$100,000    -$100,000
-$100,000    -$100,000    -$100,000    -$100,000    -$100,000
-$100,000    -$100,000    -$100,000    -$100,000    -$100,000
-$100,000    -$100,000    -$100,000    -$100,000    -$100,000
-$500,000    -$500,000    -$500,000    -$500,000    -$500,000

       $0           $0           $0           $0           $0
-$500,000    -$500,000    -$500,000    -$500,000    -$500,000




-$259,937    -$240,682    -$222,854    -$206,346    -$191,061
       $0           $0           $0           $0           $0
-$259,937    -$240,682    -$222,854    -$206,346    -$191,061



$3,000,000   $3,000,000   $3,000,000   $3,000,000   $3,000,000
       $1,559,622      $1,444,094      $1,337,124      $1,238,078      $1,146,369
     -$11,260,349     -$9,816,254     -$8,479,130     -$7,241,052     -$6,094,683




                8               9              10              11              12
 $         1.820 $         1.685 $         1.560 $         1.444 $         1.337
-$         0.260 -$        0.241 -$        0.223 -$        0.206 -$        0.191
-$        11.260 -$        9.816 -$        8.479 -$        7.241 -$        6.095
       13           14           15           16           17
     2025         2026         2027         2028         2029
  0.35382      0.32761      0.30334      0.28087      0.26007
  0.36770      0.34046      0.31524      0.29189      0.27027

 $800,000     $800,000     $800,000     $800,000     $800,000
$1,000,000   $1,000,000   $1,000,000   $1,000,000   $1,000,000
 $100,000     $100,000     $100,000     $100,000     $100,000
 $100,000     $100,000     $100,000     $100,000     $100,000
$1,500,000   $1,500,000   $1,500,000   $1,500,000   $1,500,000
$3,500,000   $3,500,000   $3,500,000   $3,500,000   $3,500,000

$1,238,361   $1,146,631   $1,061,695    $983,051     $910,232



-$100,000    -$100,000    -$100,000    -$100,000    -$100,000
-$100,000    -$100,000    -$100,000    -$100,000    -$100,000
-$100,000    -$100,000    -$100,000    -$100,000    -$100,000
-$100,000    -$100,000    -$100,000    -$100,000    -$100,000
-$100,000    -$100,000    -$100,000    -$100,000    -$100,000
-$500,000    -$500,000    -$500,000    -$500,000    -$500,000

       $0           $0           $0           $0           $0
-$500,000    -$500,000    -$500,000    -$500,000    -$500,000




-$176,909    -$163,804    -$151,671    -$140,436    -$130,033
       $0           $0           $0           $0           $0
-$176,909    -$163,804    -$151,671    -$140,436    -$130,033



$3,000,000   $3,000,000   $3,000,000   $3,000,000   $3,000,000
      $1,061,452       $982,826        $910,024        $842,615        $780,199
     -$5,033,230     -$4,050,404     -$3,140,380     -$2,297,764     -$1,517,565




              13              14              15              16              17
 $        1.238 $         1.147 $         1.062 $         0.983 $         0.910
-$        0.177 -$        0.164 -$        0.152 -$        0.140 -$        0.130
-$        5.033 -$        4.050 -$        3.140 -$        2.298 -$        1.518
       18           19           20           21           22
     2030         2031         2032         2033         2034
  0.24080      0.22297      0.20645      0.19116      0.17700
  0.25025      0.23171      0.21455      0.19866      0.18394

 $800,000     $800,000     $800,000     $800,000     $800,000
$1,000,000   $1,000,000   $1,000,000   $1,000,000   $1,000,000
 $100,000     $100,000     $100,000     $100,000     $100,000
 $100,000     $100,000     $100,000     $100,000     $100,000
$1,500,000   $1,500,000   $1,500,000   $1,500,000   $1,500,000
$3,500,000   $3,500,000   $3,500,000   $3,500,000   $3,500,000

 $842,808     $780,378     $722,572     $669,048     $619,489



-$100,000    -$100,000    -$100,000    -$100,000    -$100,000
-$100,000    -$100,000    -$100,000    -$100,000    -$100,000
-$100,000    -$100,000    -$100,000    -$100,000    -$100,000
-$100,000    -$100,000    -$100,000    -$100,000    -$100,000
-$100,000    -$100,000    -$100,000    -$100,000    -$100,000
-$500,000    -$500,000    -$500,000    -$500,000    -$500,000

       $0           $0           $0           $0           $0
-$500,000    -$500,000    -$500,000    -$500,000    -$500,000




-$120,401    -$111,483    -$103,225      -$95,578     -$88,498
       $0           $0           $0            $0           $0
-$120,401    -$111,483    -$103,225      -$95,578     -$88,498



$3,000,000   $3,000,000   $3,000,000   $3,000,000   $3,000,000
      $722,407      $668,895     $619,347      $573,470       $530,991
     -$795,158     -$126,263     $493,084     $1,066,554     $1,597,544




            18            19           20             21             22
 $      0.843 $       0.780 $      0.723 $        0.669 $        0.619
-$      0.120 -$      0.111 -$     0.103 -$       0.096 -$       0.088
-$      0.795 -$      0.126 $      0.493 $        1.067 $        1.598
       23           24           25           26           27
     2035         2036         2037         2038         2039
  0.16389      0.15175      0.14051      0.13010      0.12046
  0.17032      0.15770      0.14602      0.13520      0.12519

 $800,000     $800,000     $800,000     $800,000     $800,000
$1,000,000   $1,000,000   $1,000,000   $1,000,000   $1,000,000
 $100,000     $100,000     $100,000     $100,000     $100,000
 $100,000     $100,000     $100,000     $100,000     $100,000
$1,500,000   $1,500,000   $1,500,000   $1,500,000   $1,500,000
$3,500,000   $3,500,000   $3,500,000   $3,500,000   $3,500,000

 $573,601     $531,112     $491,770     $455,343     $421,614



-$100,000    -$100,000    -$100,000    -$100,000    -$100,000
-$100,000    -$100,000    -$100,000    -$100,000    -$100,000
-$100,000    -$100,000    -$100,000    -$100,000    -$100,000
-$100,000    -$100,000    -$100,000    -$100,000    -$100,000
-$100,000    -$100,000    -$100,000    -$100,000    -$100,000
-$500,000    -$500,000    -$500,000    -$500,000    -$500,000

       $0           $0           $0           $0           $0
-$500,000    -$500,000    -$500,000    -$500,000    -$500,000




  -$81,943     -$75,873     -$70,253     -$65,049     -$60,231
        $0           $0           $0           $0           $0
  -$81,943     -$75,873     -$70,253     -$65,049     -$60,231



$3,000,000   $3,000,000   $3,000,000   $3,000,000   $3,000,000
      $491,658       $455,239       $421,517       $390,294       $361,383
     $2,089,202     $2,544,441     $2,965,958     $3,356,252     $3,717,635




             23             24             25             26             27
 $       0.574 $        0.531 $        0.492 $        0.455 $        0.422
-$       0.082 -$       0.076 -$       0.070 -$       0.065 -$       0.060
 $       2.089 $        2.544 $        2.966 $        3.356 $        3.718
       28           29       1000      1000      1000
     2040         2041       2042      2043      2044
  0.11154      0.10328    0.00000   0.00000   0.00000
  0.11591      0.10733    0.00000   0.00000   0.00000

 $800,000     $800,000        $0        $0        $0
$1,000,000   $1,000,000       $0        $0        $0
 $100,000     $100,000        $0        $0        $0
 $100,000     $100,000        $0        $0        $0
$1,500,000   $1,500,000       $0        $0        $0
$3,500,000   $3,500,000       $0        $0        $0

 $390,383     $361,466        $0        $0        $0



-$100,000    -$100,000        $0        $0        $0
-$100,000    -$100,000        $0        $0        $0
-$100,000    -$100,000        $0        $0        $0
-$100,000    -$100,000        $0        $0        $0
-$100,000    -$100,000        $0        $0        $0
-$500,000    -$500,000        $0        $0        $0

       $0           $0        $0        $0        $0
-$500,000    -$500,000        $0        $0        $0




  -$55,769     -$51,638       $0        $0        $0
        $0           $0       $0        $0        $0
  -$55,769     -$51,638       $0        $0        $0



$3,000,000   $3,000,000       $0        $0        $0
      $334,614       $309,828             $0            $0            $0
     $4,052,249     $4,362,077    $4,362,077    $4,362,077    $4,362,077




             28             29         1000          1000          1000
 $       0.390 $        0.361 $         -   $         -   $         -
-$       0.056 -$       0.052 $         -   $         -   $         -
 $       4.052 $        4.362 $       4.362 $       4.362 $       4.362
   1000      1000      1000      1000      1000
   2045      2046      2047      2048      2049
0.00000   0.00000   0.00000   0.00000   0.00000
0.00000   0.00000   0.00000   0.00000   0.00000

    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0

    $0        $0        $0        $0        $0



    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0

    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0




    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0



    $0        $0        $0        $0        $0
            $0            $0            $0            $0            $0
    $4,362,077    $4,362,077    $4,362,077    $4,362,077    $4,362,077




         1000          1000          1000          1000          1000
$         -   $         -   $         -   $         -   $         -
$         -   $         -   $         -   $         -   $         -
$       4.362 $       4.362 $       4.362 $       4.362 $       4.362
   1000      1000      1000      1000      1000
   2050      2051      2052      2053      2054
0.00000   0.00000   0.00000   0.00000   0.00000
0.00000   0.00000   0.00000   0.00000   0.00000

    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0

    $0        $0        $0        $0        $0



    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0

    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0




    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0



    $0        $0        $0        $0        $0
            $0            $0            $0            $0            $0
    $4,362,077    $4,362,077    $4,362,077    $4,362,077    $4,362,077




         1000          1000          1000          1000          1000
$         -   $         -   $         -   $         -   $         -
$         -   $         -   $         -   $         -   $         -
$       4.362 $       4.362 $       4.362 $       4.362 $       4.362
   1000      1000      1000      1000      1000
   2055      2056      2057      2058      2059
0.00000   0.00000   0.00000   0.00000   0.00000
0.00000   0.00000   0.00000   0.00000   0.00000

    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0

    $0        $0        $0        $0        $0



    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0

    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0




    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0



    $0        $0        $0        $0        $0
            $0            $0            $0            $0            $0
    $4,362,077    $4,362,077    $4,362,077    $4,362,077    $4,362,077




         1000          1000          1000          1000          1000
$         -   $         -   $         -   $         -   $         -
$         -   $         -   $         -   $         -   $         -
$       4.362 $       4.362 $       4.362 $       4.362 $       4.362
   1000      1000
   2060      2061
0.00000   0.00000
0.00000   0.00000

    $0        $0
    $0        $0
    $0        $0
    $0        $0
    $0        $0
    $0        $0

    $0        $0



    $0        $0
    $0        $0
    $0        $0
    $0        $0
    $0        $0
    $0        $0

    $0        $0
    $0        $0




    $0        $0
    $0        $0
    $0        $0



    $0        $0
            $0            $0
    $4,362,077    $4,362,077




         1000          1000
$         -   $         -
$         -   $         -
$       4.362 $       4.362
                                                                          Cost Benefit Analysis: Option 3
                              $10




                               $5




                               $0
Todays Dollars ($ millions)




                               -$5




                              -$10




                              -$15




                              -$20


                                                                                                                          Present Value of Benefits ($million)
                              -$25
                                                                                                                          Present Value of Costs ($million)

                                                                                                                          Cumulative Net Present Value ($million)
                              -$30
                                     1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50
                                                                                                        Year
Cost Benefit Analysis                     <title of the investment proposal>
Option 4:                                 <description of the option>
Saturday, September 01, 2012

Key Assumptions:
Public Sector Discount Rate 2011                   8.00%
Appraisal period (years)                              30 years

Summary of the Results of the Analysis:
Capital Costs                                $55,000,000
Whole of Life Costs                          $70,000,000
Present Value of Benefits                    $47,718,390
Present Value of Costs                       $43,903,348
Benefit Cost Ratio                                  1.09
Net Present Value                             $3,815,042

                                                       0                  1            2
Year                                                2012               2013         2014
Discount factor (mid-year)                       0.96225            0.89097      0.82497
Discount factor (start of year)                  1.00000            0.92593      0.85734

Benefit 1 <description>                        $400,000           $800,000     $1,200,000
Benefit 2 <description>                       $1,000,000         $1,000,000    $1,000,000
Benefit 3 <description>                        $100,000           $100,000      $500,000
Benefit 4 <description>                        $100,000           $100,000      $100,000
Benefit 5 <description>                        $750,000          $1,500,000    $1,500,000
Total Benefits (mid-year)                     $2,350,000         $3,500,000    $4,300,000

Present Value of Benefits (mid-yr)            $2,261,289         $3,118,404    $3,547,391
Present Value of Benefits                    $47,718,390

Cost 1 <description>                           -$100,000          -$100,000    -$100,000
Cost 2 <description>                           -$100,000          -$100,000    -$100,000
Cost 3 <description>                           -$100,000          -$100,000    -$100,000
Cost 4 <description>                           -$100,000          -$100,000    -$100,000
Cost 5 <description>                           -$100,000          -$100,000    -$100,000
Total Costs (mid-year)                         -$500,000          -$500,000    -$500,000

Capital Costs (at start of year)             -$25,000,000        -$5,000,000          $0
Total Costs                                  -$25,500,000        -$5,500,000   -$500,000
Total Capital Costs                          -$55,000,000
Total Whole of Life Costs                    -$70,000,000

Present Value of Costs (mid-year)               -$481,125          -$445,486   -$412,487
Present Value of Costs (start year)          -$25,000,000        -$4,629,630          $0
Present Value of Costs (by year)             -$25,481,125        -$5,075,116   -$412,487
Present Value of Costs                       -$43,903,348

Net Cash Flows                               -$23,150,000        -$2,000,000   $3,800,000
Net Present Value (by year)                  -$23,219,837      -$1,956,712       $3,134,904
Cumulative NPV                               -$23,219,837     -$25,176,548     -$22,041,645


Chart data only:
Year                                                    0                1                2
Present Value of Benefits ($million)     $         2.261 $          3.118 $          3.547
Present Value of Costs ($million)       -$        25.481 -$         5.075 -$         0.412
Cumulative Net Present Value ($million) -$        23.220 -$        25.177 -$        22.042
        3            4            5             6            7
     2015         2016         2017          2018         2019
  0.76387      0.70728      0.65489       0.60638      0.56146
  0.79383      0.73503      0.68058       0.63017      0.58349

$1,200,000   $1,200,000   $1,200,000   $1,200,000    $1,200,000
$1,000,000   $1,000,000   $1,000,000   $1,000,000    $1,000,000
 $500,000     $500,000     $500,000     $500,000      $500,000
 $100,000     $100,000     $100,000     $100,000      $100,000
$1,500,000   $1,500,000   $1,500,000   $1,500,000    $1,500,000
$4,300,000   $4,300,000   $4,300,000   $4,300,000    $4,300,000

$3,284,621   $3,041,316   $2,816,033   $2,607,438    $2,414,295



-$100,000    -$100,000    -$100,000     -$100,000    -$100,000
-$100,000    -$100,000    -$100,000     -$100,000    -$100,000
-$100,000    -$100,000    -$100,000     -$100,000    -$100,000
-$100,000    -$100,000    -$100,000     -$100,000    -$100,000
-$100,000    -$100,000    -$100,000     -$100,000    -$100,000
-$500,000    -$500,000    -$500,000     -$500,000    -$500,000

       $0           $0           $0    -$5,000,000          $0
-$500,000    -$500,000    -$500,000    -$5,500,000   -$500,000




-$381,933    -$353,641    -$327,446      -$303,191   -$280,732
       $0           $0           $0    -$3,150,848          $0
-$381,933    -$353,641    -$327,446    -$3,454,039   -$280,732



$3,800,000   $3,800,000   $3,800,000   -$1,200,000   $3,800,000
       $2,902,689       $2,687,675       $2,488,588        -$846,600       $2,133,563
     -$19,138,956     -$16,451,281     -$13,962,694     -$14,809,294     -$12,675,731




                3                4                5                6                7
 $         3.285 $          3.041 $          2.816 $          2.607 $          2.414
-$         0.382 -$         0.354 -$         0.327 -$         3.454 -$         0.281
-$        19.139 -$        16.451 -$        13.963 -$        14.809 -$        12.676
        8            9           10            11           12
     2020         2021         2022          2023         2024
  0.51987      0.48136      0.44571       0.41269      0.38212
  0.54027      0.50025      0.46319       0.42888      0.39711

$1,200,000   $1,200,000   $1,200,000   $1,200,000    $1,200,000
$1,000,000   $1,000,000   $1,000,000   $1,000,000    $1,000,000
 $500,000     $500,000     $500,000     $500,000      $500,000
 $100,000     $100,000     $100,000     $100,000      $100,000
$1,500,000   $1,500,000   $1,500,000   $1,500,000    $1,500,000
$4,300,000   $4,300,000   $4,300,000   $4,300,000    $4,300,000

$2,235,458   $2,069,869   $1,916,545   $1,774,579    $1,643,128



-$100,000    -$100,000    -$100,000     -$100,000    -$100,000
-$100,000    -$100,000    -$100,000     -$100,000    -$100,000
-$100,000    -$100,000    -$100,000     -$100,000    -$100,000
-$100,000    -$100,000    -$100,000     -$100,000    -$100,000
-$100,000    -$100,000    -$100,000     -$100,000    -$100,000
-$500,000    -$500,000    -$500,000     -$500,000    -$500,000

       $0           $0           $0    -$5,000,000          $0
-$500,000    -$500,000    -$500,000    -$5,500,000   -$500,000




-$259,937    -$240,682    -$222,854      -$206,346   -$191,061
       $0           $0           $0    -$2,144,414          $0
-$259,937    -$240,682    -$222,854    -$2,350,761   -$191,061



$3,800,000   $3,800,000   $3,800,000   -$1,200,000   $3,800,000
       $1,975,521      $1,829,186      $1,693,691       -$576,182      $1,452,067
     -$10,700,210     -$8,871,024     -$7,177,333     -$7,753,515     -$6,301,448




                8               9              10              11              12
 $         2.235 $         2.070 $         1.917 $         1.775 $         1.643
-$         0.260 -$        0.241 -$        0.223 -$        2.351 -$        0.191
-$        10.700 -$        8.871 -$        7.177 -$        7.754 -$        6.301
       13           14           15            16           17
     2025         2026         2027          2028         2029
  0.35382      0.32761      0.30334       0.28087      0.26007
  0.36770      0.34046      0.31524       0.29189      0.27027

$1,200,000   $1,200,000   $1,200,000   $1,200,000    $1,200,000
$1,000,000   $1,000,000   $1,000,000   $1,000,000    $1,000,000
 $500,000     $500,000     $500,000     $500,000      $500,000
 $100,000     $100,000     $100,000     $100,000      $100,000
$1,500,000   $1,500,000   $1,500,000   $1,500,000    $1,500,000
$4,300,000   $4,300,000   $4,300,000   $4,300,000    $4,300,000

$1,521,415   $1,408,718   $1,304,368   $1,207,748    $1,118,286



-$100,000    -$100,000    -$100,000     -$100,000    -$100,000
-$100,000    -$100,000    -$100,000     -$100,000    -$100,000
-$100,000    -$100,000    -$100,000     -$100,000    -$100,000
-$100,000    -$100,000    -$100,000     -$100,000    -$100,000
-$100,000    -$100,000    -$100,000     -$100,000    -$100,000
-$500,000    -$500,000    -$500,000     -$500,000    -$500,000

       $0           $0           $0    -$5,000,000          $0
-$500,000    -$500,000    -$500,000    -$5,500,000   -$500,000




-$176,909    -$163,804    -$151,671      -$140,436   -$130,033
       $0           $0           $0    -$1,459,452          $0
-$176,909    -$163,804    -$151,671    -$1,599,888   -$130,033



$3,800,000   $3,800,000   $3,800,000   -$1,200,000   $3,800,000
      $1,344,506      $1,244,913      $1,152,698       -$392,140       $988,252
     -$4,956,941     -$3,712,028     -$2,559,330     -$2,951,470     -$1,963,218




              13              14              15              16              17
 $        1.521 $         1.409 $         1.304 $         1.208 $         1.118
-$        0.177 -$        0.164 -$        0.152 -$        1.600 -$        0.130
-$        4.957 -$        3.712 -$        2.559 -$        2.951 -$        1.963
       18           19           20            21           22
     2030         2031         2032          2033         2034
  0.24080      0.22297      0.20645       0.19116      0.17700
  0.25025      0.23171      0.21455       0.19866      0.18394

$1,200,000   $1,200,000   $1,200,000   $1,200,000    $1,200,000
$1,000,000   $1,000,000   $1,000,000   $1,000,000    $1,000,000
 $500,000     $500,000     $500,000     $500,000      $500,000
 $100,000     $100,000     $100,000     $100,000      $100,000
$1,500,000   $1,500,000   $1,500,000   $1,500,000    $1,500,000
$4,300,000   $4,300,000   $4,300,000   $4,300,000    $4,300,000

$1,035,450    $958,750     $887,731      $821,973     $761,086



-$100,000    -$100,000    -$100,000     -$100,000    -$100,000
-$100,000    -$100,000    -$100,000     -$100,000    -$100,000
-$100,000    -$100,000    -$100,000     -$100,000    -$100,000
-$100,000    -$100,000    -$100,000     -$100,000    -$100,000
-$100,000    -$100,000    -$100,000     -$100,000    -$100,000
-$500,000    -$500,000    -$500,000     -$500,000    -$500,000

       $0           $0           $0    -$5,000,000          $0
-$500,000    -$500,000    -$500,000    -$5,500,000   -$500,000




-$120,401    -$111,483    -$103,225       -$95,578     -$88,498
       $0           $0           $0      -$993,279           $0
-$120,401    -$111,483    -$103,225    -$1,088,857     -$88,498



$3,800,000   $3,800,000   $3,800,000   -$1,200,000   $3,800,000
       $915,049       $847,267     $784,507     -$266,884     $672,588
     -$1,048,169     -$200,902     $583,604      $316,721     $989,309




              18            19           20            21           22
 $        1.035 $       0.959 $      0.888 $       0.822 $      0.761
-$        0.120 -$      0.111 -$     0.103 -$      1.089 -$     0.088
-$        1.048 -$      0.201 $      0.584 $       0.317 $      0.989
       23           24           25            26           27
     2035         2036         2037          2038         2039
  0.16389      0.15175      0.14051       0.13010      0.12046
  0.17032      0.15770      0.14602       0.13520      0.12519

$1,200,000   $1,200,000   $1,200,000   $1,200,000    $1,200,000
$1,000,000   $1,000,000   $1,000,000   $1,000,000    $1,000,000
 $500,000     $500,000     $500,000     $500,000      $500,000
 $100,000     $100,000     $100,000     $100,000      $100,000
$1,500,000   $1,500,000   $1,500,000   $1,500,000    $1,500,000
$4,300,000   $4,300,000   $4,300,000   $4,300,000    $4,300,000

 $704,710     $652,509     $604,175      $559,421     $517,983



-$100,000    -$100,000    -$100,000     -$100,000    -$100,000
-$100,000    -$100,000    -$100,000     -$100,000    -$100,000
-$100,000    -$100,000    -$100,000     -$100,000    -$100,000
-$100,000    -$100,000    -$100,000     -$100,000    -$100,000
-$100,000    -$100,000    -$100,000     -$100,000    -$100,000
-$500,000    -$500,000    -$500,000     -$500,000    -$500,000

       $0           $0           $0    -$5,000,000          $0
-$500,000    -$500,000    -$500,000    -$5,500,000   -$500,000




  -$81,943     -$75,873     -$70,253     -$65,049      -$60,231
        $0           $0           $0    -$676,009            $0
  -$81,943     -$75,873     -$70,253    -$741,058      -$60,231



$3,800,000   $3,800,000   $3,800,000   -$1,200,000   $3,800,000
      $622,767       $576,636       $533,922       -$181,637      $457,752
     $1,612,075     $2,188,711     $2,722,633     $2,540,997     $2,998,749




             23             24             25             26             27
 $       0.705 $        0.653 $        0.604 $        0.559 $        0.518
-$       0.082 -$       0.076 -$       0.070 -$       0.741 -$       0.060
 $       1.612 $        2.189 $        2.723 $        2.541 $        2.999
       28           29       1000      1000      1000
     2040         2041       2042      2043      2044
  0.11154      0.10328    0.00000   0.00000   0.00000
  0.11591      0.10733    0.00000   0.00000   0.00000

$1,200,000   $1,200,000       $0        $0        $0
$1,000,000   $1,000,000       $0        $0        $0
 $500,000     $500,000        $0        $0        $0
 $100,000     $100,000        $0        $0        $0
$1,500,000   $1,500,000       $0        $0        $0
$4,300,000   $4,300,000       $0        $0        $0

 $479,614     $444,087        $0        $0        $0



-$100,000    -$100,000        $0        $0        $0
-$100,000    -$100,000        $0        $0        $0
-$100,000    -$100,000        $0        $0        $0
-$100,000    -$100,000        $0        $0        $0
-$100,000    -$100,000        $0        $0        $0
-$500,000    -$500,000        $0        $0        $0

       $0           $0        $0        $0        $0
-$500,000    -$500,000        $0        $0        $0




  -$55,769     -$51,638       $0        $0        $0
        $0           $0       $0        $0        $0
  -$55,769     -$51,638       $0        $0        $0



$3,800,000   $3,800,000       $0        $0        $0
      $423,845       $392,449             $0            $0            $0
     $3,422,593     $3,815,042    $3,815,042    $3,815,042    $3,815,042




             28             29         1000          1000          1000
 $       0.480 $        0.444 $         -   $         -   $         -
-$       0.056 -$       0.052 $         -   $         -   $         -
 $       3.423 $        3.815 $       3.815 $       3.815 $       3.815
   1000      1000      1000      1000      1000
   2045      2046      2047      2048      2049
0.00000   0.00000   0.00000   0.00000   0.00000
0.00000   0.00000   0.00000   0.00000   0.00000

    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0

    $0        $0        $0        $0        $0



    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0

    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0




    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0



    $0        $0        $0        $0        $0
            $0            $0            $0            $0            $0
    $3,815,042    $3,815,042    $3,815,042    $3,815,042    $3,815,042




         1000          1000          1000          1000          1000
$         -   $         -   $         -   $         -   $         -
$         -   $         -   $         -   $         -   $         -
$       3.815 $       3.815 $       3.815 $       3.815 $       3.815
   1000      1000      1000      1000      1000
   2050      2051      2052      2053      2054
0.00000   0.00000   0.00000   0.00000   0.00000
0.00000   0.00000   0.00000   0.00000   0.00000

    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0

    $0        $0        $0        $0        $0



    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0

    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0




    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0



    $0        $0        $0        $0        $0
            $0            $0            $0            $0            $0
    $3,815,042    $3,815,042    $3,815,042    $3,815,042    $3,815,042




         1000          1000          1000          1000          1000
$         -   $         -   $         -   $         -   $         -
$         -   $         -   $         -   $         -   $         -
$       3.815 $       3.815 $       3.815 $       3.815 $       3.815
   1000      1000      1000      1000      1000
   2055      2056      2057      2058      2059
0.00000   0.00000   0.00000   0.00000   0.00000
0.00000   0.00000   0.00000   0.00000   0.00000

    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0

    $0        $0        $0        $0        $0



    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0

    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0




    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0
    $0        $0        $0        $0        $0



    $0        $0        $0        $0        $0
            $0            $0            $0            $0            $0
    $3,815,042    $3,815,042    $3,815,042    $3,815,042    $3,815,042




         1000          1000          1000          1000          1000
$         -   $         -   $         -   $         -   $         -
$         -   $         -   $         -   $         -   $         -
$       3.815 $       3.815 $       3.815 $       3.815 $       3.815
   1000      1000
   2060      2061
0.00000   0.00000
0.00000   0.00000

    $0        $0
    $0        $0
    $0        $0
    $0        $0
    $0        $0
    $0        $0

    $0        $0



    $0        $0
    $0        $0
    $0        $0
    $0        $0
    $0        $0
    $0        $0

    $0        $0
    $0        $0




    $0        $0
    $0        $0
    $0        $0



    $0        $0
            $0            $0
    $3,815,042    $3,815,042




         1000          1000
$         -   $         -
$         -   $         -
$       3.815 $       3.815
                                                                          Cost Benefit Analysis: Option 4
                              $10




                               $5




                               $0
Todays Dollars ($ millions)




                               -$5




                              -$10




                              -$15




                              -$20


                                                                                                                          Present Value of Benefits ($million)
                              -$25
                                                                                                                          Present Value of Costs ($million)

                                                                                                                          Cumulative Net Present Value ($million)
                              -$30
                                     1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50
                                                                                                        Year
Multi-Criteria Analysis                    <title of the investment proposal>



                                                                    Option 1                  Option 2
                                                                  <description>             <description>
                                                    Criteria         Score      Weighted       Score
Criteria                                            Weight         (out of 10)   Score       (out of 10)
<description>                                            50.0%               3       1.50              5
<description>                                            25.0%               5       1.25              9
<description>                                            15.0%               4       0.60              6
<description>                                            10.0%               4       0.40              3

Overall                                                  100.0%           16          3.8            23

refer to the comments on the marked cells for guidance
                              Option 3                  Option 4
<description>               <description>             <description>
                Weighted       Score      Weighted       Score      Weighted
                 Score       (out of 10)   Score       (out of 10)   Score
                     2.50              5       2.50              5       2.50
                     2.25              0                         6       1.50
                     0.90              8       1.20              8       1.20
                     0.30              5       0.50              8       0.80

                      6.0           18          4.2           27          6.0

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:8
posted:9/1/2012
language:Unknown
pages:96