Spreadsheet: 154975d1336639095-eric-chart-in-excel-829700b
Sheet: Multi-colour ERIC

Multi-colour MAC curve chart with labels and reduction target
generated using a multiple set XY scatter chart
Data
Reduction target | (thousand tonnes) |  | 1 | 1
 |  |  | 0 | 1790.865013774107
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 |  | 172000
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 |  | 12970.25888062164
Cumulative savings for all projects | (thousand tonnes/year) |  | 0.027 |  | 0.064 |  | 0.1873 |  | 0.2972238688 |  | 0.7180238688 |  | 0.7610238688000001 |  | 0.9830238688 |  | 1.0030238688 |  | 1.0720238688 |  | 1.0950238688
IRR | 0 |  | 1628.059103431006 |  | 1176 |  | 112.5 |  | 79.08 |  | 50 |  | 30.66666666666666 |  | 22.01726285264612 |  | 13.13039527487506 |  | 11.21875 |  | 10.18604651162791
Discounted life savings of carbon | (tonnes) |  | 67.14500375657406 |  | 92.01352366641632 |  | 757.6251241333877 |  | 997.7833560561934 |  | 1046.467317806162 |  | 264.2163855453014 |  | 1688.549650400457 |  | 152.1215901261673 |  | 587.4358966633409 |  | 208.7719204192752
MAC (carbon  discounted) | (£/tonne) |  | -178.1285666330984 |  | -176.5076753490651 |  | -156.083472038522 |  | -154.7962092401308 |  | -2.32616911536651 |  | -50.20509480842622 |  | -64.48126833098047 |  | 0.1868914645530732 |  | 24.45043372774846 |  | 62.12645289928624
XY data points |  | 0 | 1 | 0.027 | 1 | 0.064 | 1 | 0.1873 | 1 | 0.2972238688 | 1 | 0.7180238688 | 1 | 0.7610238688000001 | 1 | 0.9830238688 | 1 | 1.0030238688 | 1 | 1.0720238688 | 1
 |  | 0 | 1628.059103431006 | 0.027 | 1176 | 0.064 | 112.5 | 0.1873 | 79.08 | 0.2972238688 | 50 | 0.7180238688 | 30.66666666666666 | 0.7610238688000001 | 22.01726285264612 | 0.9830238688 | 13.13039527487506 | 1.0030238688 | 11.21875 | 1.0720238688 | 10.18604651162791
 |  | 0.027 | 1628.059103431006 | 0.064 | 1176 | 0.1873 | 112.5 | 0.2972238688 | 79.08 | 0.7180238688 | 50 | 0.7610238688000001 | 30.66666666666666 | 0.9830238688 | 22.01726285264612 | 1.0030238688 | 13.13039527487506 | 1.0720238688 | 11.21875 | 1.0950238688 | 10.18604651162791
 |  | 0.027 | 1 | 0.064 | 1 | 0.1873 | 1 | 0.2972238688 | 1 | 0.7180238688 | 1 | 0.7610238688000001 | 1 | 0.9830238688 | 1 | 1.0030238688 | 1 | 1.0720238688 | 1 | 1.0950238688 | 1
 |  | 1628.059103431006 | 1176 | 112.5 | 79.08 | 50 | 30.66666666666666 | 22.01726285264612 | 13.13039527487506 | 11.21875 | 10.18604651162791
Cumm IRR | Xpos | 0.027 | 0.064 | 0.1873 | 0.2972238688 | 0.7180238688 | 0.7610238688000001 | 0.9830238688 | 1.0030238688 | 1.0720238688 | 1.0950238688
 | Ypos | 1628.059103431006 | 2804.059103431005 | 2916.559103431005 | 2995.639103431005 | 3045.639103431005 | 3076.305770097672 | 3098.323032950318 | 3111.453428225193 | 3122.672178225193 | 3132.858224736821