Spreadsheet: 154570d1336487498-eric-chart-in-excel-temp_forum
Sheet: Project Data

Emissions Reduction Investment (ERI) Curve Calculator
Discount rate | 0.1
Reduction target (thousand tonnes) | 1
Project name |  |  | Project 1 | Project 2 | Project 3 | Project 4 | Project 5 | Project 6 | Project 7 | Project 8 | Project 9 | Project 10
Capital cost | (£) |  | 250 | 575 | 20000 | 25000 | 10000 | 15000 | 161387 | 22010 | 320000 | 135000
Annual benefit/cost | (£) |  | 4910 | 6762 | 22500 | 19770 | 5000 | 4600 | 35533 | 2890 | 35900 | 17520
Annual average CO2 savings for project | (tonnes/year) |  | 27 | 37 | 123.3 | 109.9238688 | 420.8 | 43 | 222 | 20 | 69 | 23
Project life | (years) |  | 3 | 3 | 10 | 25 | 3 | 10 | 15 | 15 | 20 | 25
NPV | (£) |  | -11960.44327573254 | -16241.09316303533 | -118252.7598783554 | -154453.0811603944 | -2434.259954921125 | -13265.00868624155 | -108879.8230976551 | 28.43022676882174 | 14363.06246066751 | -24029.74111937836
IRR |  | 0 | 1628.059103431006 | 1176 | 112.5 | 79.08 | 50 | 30.66666666666666 | 22.01726285264612 | 13.13039527487506 | 11.21875 | 12.97777777777778
Discounted life savings of carbon | (tonnes) | 0 | 67.14500375657406 | 92.01352366641632 | 757.6251241333877 | 997.7833560561934 | 1046.467317806162 | 264.2163855453014 | 1688.549650400457 | 152.1215901261673 | 587.4358966633409 | 208.7719204192752
MAC (carbon  discounted) | (£/tonne) | 0 | -178.1285666330984 | -176.5076753490651 | -156.083472038522 | -154.7962092401308 | -2.32616911536651 | -50.20509480842622 | -64.48126833098047 | 0.1868914645530732 | 24.45043372774846 | -115.1004458411821
Cumulative savings for all projects | (thousand tonnes/year) | 0 | 0.027 | 0.064 | 0.1873 | 0.2972238688 | 0.7180238688 | 0.7610238688000001 | 0.9830238688 | 1.0030238688 | 1.0720238688 | 1.0950238688
IRR |  |  | 16.28059103431006 | 11.76 | 1.125 | 0.7908 | 0.5 | 0.3066666666666666 | 0.2201726285264612 | 0.1313039527487506 | 0.1121875 | 0.1297777777777778
MAC (carbon not discounted) |  |  | -147.6597935275622 | -146.3161546219399 | -95.90653680320796 | -56.20365543771489 | -1.92827943197174 | -30.84885740986407 | -32.69664357286941 | 0.09476742256273912 | 10.40801627584602 | -41.79085412065803
IRR |  |  | 16.28059103431006 | 11.76 | 1.125 | 0.7908 | 0.5 | 0.3066666666666666 | 0.2201726285264612 | 0.1313039527487506 | 0.1121875 | 0.1297777777777778
Cumulative Capital | (£) |  | 250 | 825 | 20825 | 45825 | 55825 | 70825 | 232212 | 254222 | 574222 | 709222
Minimum project life | (years) |  | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
Cumulative benefit/cost | (£) |  | 4910 | 11672 | 34172 | 53942 | 58942 | 63542 | 99075 | 101965 | 137865 | 155385
Cumulative CO2 red, | (tonnes) |  | 27 | 64 | 187.3 | 297.2238688 | 718.0238688 | 761.0238688 | 983.0238688 | 1003.0238688 | 1072.0238688 | 1095.0238688
IRR | (%) |  | 16.28059103431006 | 11.76 | 1.125 | 0.7908 | 0.5 | 0.3066666666666666 | 0.2201726285264612 | 0.1313039527487506 | 0.1121875 | 0.1297777777777778
Cumulative IRR | (%) |  | 16.28059103431006 | 14.14787878787879 | 1.640912364945978 | 1.177130387343153 | 1.055835199283475 | 0.897169078715143 | 0.4266575370781872 | 0.4010864519986468 | 0.2400900696942994 | 0.2190921883415912
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 34.5 | 39.4 | 41.8 | 43.3 | 50.8
 |  |  | 0.027 | 0.037 | 0.1233 | 0.1099238688 | 0.4208 | 0.043 | 0.222 | 0.02 | 0.069 | 0.023 |  | 0.2 | 0.125 | 0.1 | 0.06666666666666667 | 0.06666666666666667
 |  |  | A | B | C | D | E | F | G | H | I | J