Spreadsheet: 0300931d-d2c7-49a4-ba5a-7c6e1681f36c
Sheet: Sheet1

Table 2:  Net Present Value and Internal Rate of Return Analysis using 6% 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 | 38561.5439 | 135461.4784 | -890538.5216
2 | 2012 | 0 | 87886.58700900001 | 11154.83604345 | 39413.75402019 | 138455.17707264 | -752083.3445273599
3 | 2013 | 0 | 89828.8805818989 | 11401.35792001025 | 40284.7979840362 | 141515.0364859454 | -610568.3080414146
4 | 2014 | 0 | 91814.09884275887 | 11653.32793004247 | 41175.0920194834 | 144642.5187922848 | -465925.7892491298
5 | 2015 | 0 | 93843.19042718384 | 11910.86647729641 | 42085.06155311398 | 147839.1184575942 | -318086.6707915356
6 | 2016 | 0 | 0 | 12174.09662644466 | 43015.14141343781 | 55189.23803988247 | -262897.4327516531
7 | 2017 | 0 | 0 | 12443.14416188909 | 43965.77603867478 | 56408.92020056387 | -206488.5125510893
8 | 2018 | 0 | 0 | 12718.13764786684 | 44937.4196891295 | 57655.55733699634 | -148832.9552140929
9 | 2019 | 0 | 0 | 12999.2084898847 | 45930.53666425926 | 58929.74515414396 | -89903.21005994896
10 | 2020 | 0 | 0 | 13286.49099751115 | 46945.60152453939 | 60232.09252205055 | -29671.11753789842
11 | 2021 | 0 | 0 | 13580.12244855615 | 47983.09931823172 | 61563.22176678786 | 31892.10422888945
12 | 2022 | 0 | 0 | 13880.24315466924 | 49043.52581316464 | 62923.76896783388 | 94815.87319672332
13 | 2023 | 0 | 0 | 14186.99652838743 | 50127.38773363558 | 64314.38426202301 | 159130.2574587463
14 | 2024 | 0 | 0 | 14500.52915166479 | 51235.20300254893 | 65735.73215421372 | 224865.98961296
15 | 2025 | 0 | 0 | 14820.99084591658 | 52367.50098890526 | 67188.49183482185 | 292054.4814477819
16 | 2026 | 0 | 0 | 15148.53474361134 | 53524.82276076006 | 68673.35750437141 | 360727.8389521533
17 | 2027 | 0 | 0 | 15483.31736144515 | 54707.72134377286 | 70191.03870521802 | 430918.8776573713
18 | 2028 | 0 | 0 | 15825.49867513309 | 55916.76198547024 | 71742.26066060332 | 502661.1383179746
19 | 2029 | 0 | 0 | 16175.24219585353 | 57152.52242534913 | 73327.76462120266 | 575988.9029391774
20 | 2030 | 0 | 0 | 16532.71504838189 | 58415.59317094935 | 74948.30821933123 | 650937.2111585086
21 | 2031 | 0 | 0 | 16898.08805095113 | 59706.57778002733 | 76604.66583097845 | 727541.876989487
22 | 2032 | 0 | 0 | 17271.53579687715 | 61026.09314896593 | 78297.62894584308 | 805839.5059353301
23 | 2033 | 0 | 0 | 17653.23673798814 | 62374.76980755808 | 80028.00654554622 | 885867.5124808763
24 | 2034 | 0 | 0 | 18043.37326989767 | 63753.25222030512 | 81796.6254902028 | 967664.1379710791
25 | 2035 | 0 | 0 | 18442.13181916241 | 65162.19909437386 | 83604.33091353628 | 1051268.468884615
26 | 2036 | 0 | 0 | 18849.7029323659 | 66602.28369435953 | 85451.98662672544 | 1136720.455511341
27 | 2037 | 0 | 0 | 19266.28136717119 | 68074.19416400488 | 87340.47553117607 | 1224060.931042517
28 | 2038 | 0 | 0 | 19692.06618538567 | 69578.63385502939 | 89270.70004041506 | 1313331.631082932
29 | 2039 | 0 | 0 | 20127.2608480827 | 71116.32166322554 | 91243.58251130822 | 1404575.21359424
30 | 2040 | 0 | 0 | 20572.07331282532 | 72687.99237198282 | 93260.06568480814 | 1497835.279279048
Totals |  | -1026000 | 449359.0468608416 | 457605.0512687221 | 1616871.181149485 | 1497835.279279048 | 9537701.825417632
Table Assumptions
Annual Inflation |  |  | 0.0221 |  |  | NPV= | -475256.8025494161
Performance Based Initiative per kWh |  |  | 0.26 |  |  | IRR= | 0.05368330957650261
Renewable Energy Credits per kWh |  |  | 0.033
Average annual kWh used |  |  | 330716.5
Price paid per kWh |  |  | 0.11
Discount Rate |  |  | 0.06