Spreadsheet: 017d1649-f3b2-4c3c-a348-1619af3b7306
Sheet: Sheet1

Table 1:  Net Present Value and Internal Rate of Return Analysis using 8% 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 | 39289.1202 | 136189.0547 | -889810.9453
2 | 2012 | 0 | 87886.58700900001 | 11154.83604345 | 40157.40975642001 | 139198.83280887 | -750612.11249113
3 | 2013 | 0 | 89828.8805818989 | 11401.35792001025 | 41044.88851203689 | 142275.127013946 | -608336.985477184
4 | 2014 | 0 | 91814.09884275887 | 11653.32793004247 | 41951.9805481529 | 145419.4073209543 | -462917.5781562297
5 | 2015 | 0 | 93843.19042718384 | 11910.86647729641 | 42879.11931826708 | 148633.1762227473 | -314284.4019334824
6 | 2016 | 0 | 0 | 12174.09662644466 | 43826.74785520079 | 56000.84448164545 | -258283.5574518369
7 | 2017 | 0 | 0 | 12443.14416188909 | 44795.31898280072 | 57238.46314468981 | -201045.0943071471
8 | 2018 | 0 | 0 | 12718.13764786684 | 45785.29553232062 | 58503.43318018746 | -142541.6611269597
9 | 2019 | 0 | 0 | 12999.2084898847 | 46797.1505635849 | 59796.3590534696 | -82745.3020734901
10 | 2020 | 0 | 0 | 13286.49099751115 | 47831.36759104013 | 61117.85858855128 | -21627.44348493881
11 | 2021 | 0 | 0 | 13580.12244855615 | 48888.44081480212 | 62468.56326335826 | 40841.11977841945
12 | 2022 | 0 | 0 | 13880.24315466924 | 49968.87535680924 | 63849.11851147848 | 104690.2382898979
13 | 2023 | 0 | 0 | 14186.99652838743 | 51073.18750219473 | 65260.18403058215 | 169950.4223204801
14 | 2024 | 0 | 0 | 14500.52915166479 | 52201.90494599323 | 66702.43409765801 | 236652.8564181381
15 | 2025 | 0 | 0 | 14820.99084591658 | 53355.56704529968 | 68176.55789121626 | 304829.4143093544
16 | 2026 | 0 | 0 | 15148.53474361134 | 54534.7250770008 | 69683.25982061215 | 374512.6741299665
17 | 2027 | 0 | 0 | 15483.31736144515 | 55739.94250120252 | 71223.25986264767 | 445735.9339926142
18 | 2028 | 0 | 0 | 15825.49867513309 | 56971.7952304791 | 72797.2939056122 | 518533.2278982264
19 | 2029 | 0 | 0 | 16175.24219585353 | 58230.87190507269 | 74406.11410092622 | 592939.3419991527
20 | 2030 | 0 | 0 | 16532.71504838189 | 59517.7741741748 | 76050.4892225567 | 668989.8312217094
21 | 2031 | 0 | 0 | 16898.08805095113 | 60833.11698342406 | 77731.20503437519 | 746721.0362560846
22 | 2032 | 0 | 0 | 17271.53579687715 | 62177.52886875773 | 79449.06466563488 | 826170.1009217195
23 | 2033 | 0 | 0 | 17653.23673798814 | 63551.65225675728 | 81204.88899474542 | 907374.9899164649
24 | 2034 | 0 | 0 | 18043.37326989767 | 64956.14377163162 | 82999.5170415293 | 990374.5069579942
25 | 2035 | 0 | 0 | 18442.13181916241 | 66391.67454898468 | 84833.8063681471 | 1075208.313326141
26 | 2036 | 0 | 0 | 18849.7029323659 | 67858.93055651724 | 86708.63348888315 | 1161916.946815025
27 | 2037 | 0 | 0 | 19266.28136717119 | 69358.61292181627 | 88624.89428898746 | 1250541.841104012
28 | 2038 | 0 | 0 | 19692.06618538567 | 70891.43826738841 | 90583.50445277408 | 1341125.345556786
29 | 2039 | 0 | 0 | 20127.2608480827 | 72458.1390530977 | 92585.39990118038 | 1433710.745457966
30 | 2040 | 0 | 0 | 20572.07331282532 | 74059.46392617116 | 94631.53723899648 | 1528342.282696963
Totals |  | -1026000 | 449359.0468608416 | 457605.0512687221 | 1647378.184567399 | 1528342.282696963 | 9960956.087564718
Table Assumptions
Annual Inflation |  |  | 0.0221 |  |  | NPV= | -1457390.493826431
Performance Based Initiative per kWh |  |  | 0.26 |  |  | IRR= | 0.05553673111933358
Renewable Energy Credits per kWh |  |  | 0.033
Average annual kWh used |  |  | 330716.5
Price paid per kWh |  |  | 0.11
Discount Rate |  |  | 0.08