Spreadsheet: 12eb2e84-d284-40b9-ba0b-8f4944eb91cc
Sheet: Sheet1

Table 3:  Net Present Value and Internal Rate of Return Analysis using 3% Discount Rate | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Year | Year | System Costs | Performance Based Initiative | Renewable Energy Credits | Avoided Electricity Cost | Annual Cash Flow | Cumulative Cash Flow
0 | 2010 | -1026000 | 0 | 0 | 0 | -1026000 | -1026000
1 | 2011 | 0 | 85986.29000000001 | 10913.6445 | 37470.17945 | 134370.11395 | -891629.88605
2 | 2012 | 0 | 87886.58700900001 | 11154.83604345 | 38298.27041584501 | 137339.693468295 | -754290.1925817049
3 | 2013 | 0 | 89828.8805818989 | 11401.35792001025 | 39144.66219203518 | 140374.9006939443 | -613915.2918877606
4 | 2014 | 0 | 91814.09884275887 | 11653.32793004247 | 40009.75922647916 | 143477.1859992805 | -470438.1058884801
5 | 2015 | 0 | 93843.19042718384 | 11910.86647729641 | 40893.97490538435 | 146648.0318098646 | -323790.0740786155
6 | 2016 | 0 | 0 | 12174.09662644466 | 41797.73175079334 | 53971.828377238 | -269818.2457013775
7 | 2017 | 0 | 0 | 12443.14416188909 | 42721.46162248588 | 55164.60578437497 | -214653.6399170026
8 | 2018 | 0 | 0 | 12718.13764786684 | 43665.60592434282 | 56383.74357220966 | -158269.8963447929
9 | 2019 | 0 | 0 | 12999.2084898847 | 44630.61581527079 | 57629.82430515549 | -100640.0720396374
10 | 2020 | 0 | 0 | 13286.49099751115 | 45616.95242478828 | 58903.44342229943 | -41736.62861733799
11 | 2021 | 0 | 0 | 13580.12244855615 | 46625.0870733761 | 60205.20952193225 | 18468.58090459426
12 | 2022 | 0 | 0 | 13880.24315466924 | 47655.50149769772 | 61535.74465236696 | 80004.32555696121
13 | 2023 | 0 | 0 | 14186.99652838743 | 48708.68808079684 | 62895.68460918427 | 142900.0101661455
14 | 2024 | 0 | 0 | 14500.52915166479 | 49785.15008738245 | 64285.67923904724 | 207185.6894051927
15 | 2025 | 0 | 0 | 14820.99084591658 | 50885.4019043136 | 65706.39275023018 | 272892.0821554229
16 | 2026 | 0 | 0 | 15148.53474361134 | 52009.96928639893 | 67158.50403001027 | 340050.5861854331
17 | 2027 | 0 | 0 | 15483.31736144515 | 53159.38960762835 | 68642.7069690735 | 408693.2931545067
18 | 2028 | 0 | 0 | 15825.49867513309 | 54334.21211795694 | 70159.71079309002 | 478853.0039475966
19 | 2029 | 0 | 0 | 16175.24219585353 | 55534.99820576378 | 71710.24040161731 | 550563.244349214
20 | 2030 | 0 | 0 | 16532.71504838189 | 56762.32166611117 | 73295.03671449306 | 623858.2810637071
21 | 2031 | 0 | 0 | 16898.08805095113 | 58016.76897493222 | 74914.85702588335 | 698773.1380895905
22 | 2032 | 0 | 0 | 17271.53579687715 | 59298.93956927823 | 76570.47536615538 | 775343.6134557459
23 | 2033 | 0 | 0 | 17653.23673798814 | 60609.44613375928 | 78262.68287174741 | 853606.2963274933
24 | 2034 | 0 | 0 | 18043.37326989767 | 61948.91489331536 | 79992.28816321303 | 933598.5844907063
25 | 2035 | 0 | 0 | 18442.13181916241 | 63317.98591245763 | 81760.11773162005 | 1015358.702222326
26 | 2036 | 0 | 0 | 18849.7029323659 | 64717.31340112295 | 83567.01633348885 | 1098925.718555815
27 | 2037 | 0 | 0 | 19266.28136717119 | 66147.56602728777 | 85413.84739445896 | 1184339.565950274
28 | 2038 | 0 | 0 | 19692.06618538567 | 67609.42723649084 | 87301.49342187651 | 1271641.059372151
29 | 2039 | 0 | 0 | 20127.2608480827 | 69103.59557841728 | 89230.85642649999 | 1360871.915798651
30 | 2040 | 0 | 0 | 20572.07331282532 | 70630.78504070031 | 91202.85835352563 | 1452074.774152176
Totals |  | -1026000 | 449359.0468608416 | 457605.0512687221 | 1571110.676022613 | 1452074.774152176 | 8902820.432196993
Table Assumptions
Annual Inflation |  |  | 0.0221 |  |  | NPV= | 2314618.320651059
Performance Based Initiative per kWh |  |  | 0.26 |  |  | IRR= | 0.05084705755822132
Renewable Energy Credits per kWh |  |  | 0.033
Average annual kWh used |  |  | 330716.5
Price paid per kWh |  |  | 0.11
Discount Rate |  |  | 0.03