Energy Escalator 4%
<br />CPI 2%
<br />City of Roseville
<br />46,000 1 kWh/year
<br />11.50% ISystem Efficiency
<br />Attachment A
<br />City Hall Annual Usage
<br />800,000
<br />kWh
<br />Monthly Usage (avg)
<br />6,700
<br />kWh
<br />Years installed
<br />1
<br />2
<br />3 1
<br />4
<br />5
<br />6 1
<br />7
<br />8 1
<br />9
<br />10
<br />Year
<br />2014 1
<br />2015 1
<br />2016 1
<br />2017 1
<br />2018
<br />1 2019 1
<br />2020
<br />1 2021 1
<br />2022
<br />2023
<br />Existing Rate
<br />$0.1100 1
<br />$0.1144 1
<br />$0.1190
<br />$0.1237 1
<br />$0.1287
<br />1 $0.1338
<br />$0.1392
<br />1 $0.1448
<br />$0.1505 1
<br />$0.1566
<br />Payment
<br />$5,262.40
<br />$5,262.40
<br />$5,472.90
<br />$5,691.81
<br />$5,919.48
<br />$6,156.26
<br />$6,402.51
<br />$6,658.61
<br />$6,924.96
<br />$7,201.96
<br />PPA Rate
<br />85%
<br />$4,473.04
<br />$4,473.04
<br />$4,651.96
<br />$4,838.04
<br />$5,031.56
<br />$5,232.82
<br />$5,442.14
<br />$5,659.82
<br />$5,886.22
<br />$6,121.66
<br />Electrcity Savings
<br />15%
<br />$789.36
<br />$789.36
<br />$820.93
<br />$853.77
<br />$887.92
<br />$923.44
<br />$960.38
<br />$998.79
<br />$1,038.74
<br />$1,080.29
<br />Down Payment
<br />-$12,000.00
<br />Energy Savings
<br />$789.36
<br />$789.36
<br />$820.93
<br />$853.77
<br />$887.92
<br />$923.44
<br />$960.38
<br />$998.79
<br />$1,038.74
<br />$1,080.29
<br />Tax Credit
<br />Put Option
<br />Rooftop Lease Payment
<br />$300.00
<br />$306.00
<br />$312.12
<br />$318.36
<br />$324.73
<br />$331.22
<br />$337.85
<br />$344.61
<br />$351.50
<br />$358.53
<br />Benefit Stream
<br />-$10,910.64
<br />$1,095.36
<br />$1,133.05
<br />$1,172.13
<br />$1,212.65
<br />$1,254.66
<br />$1,298.23
<br />$1,343.40
<br />$1,390.24
<br />$1,438.82
<br />IRR
<br />21.87
<br />Payback
<br />Years installed
<br />-$10,910.64
<br />11
<br />-$9,815.28
<br />12
<br />-$8,682.23
<br />13
<br />-$7,510.09
<br />14
<br />-$6,297.44
<br />15
<br />-$5,042.78
<br />16
<br />-$3,744.55
<br />17
<br />-$2,401.15
<br />18
<br />-$1,010.91
<br />19
<br />$427.91
<br />20
<br />Year
<br />2024
<br />2025
<br />2026
<br />2027
<br />2028
<br />2029
<br />2030
<br />2031
<br />1
<br />2032
<br />2033
<br />Existing Rate
<br />$0.1628
<br />$0.1693
<br />$0.1761
<br />$0.1832
<br />$0.1905
<br />$0.1981
<br />$0.2060
<br />$0.2143
<br />$0.2228
<br />$0.2318
<br />Payment
<br />$7,490.04
<br />$7,789.64
<br />$8,101.22 1
<br />$8,425.27
<br />$8,762.28
<br />$9,112.77 1
<br />$9,477.29
<br />$9,856.38 1
<br />$10,250.63
<br />$10,660.66
<br />PPA Rate 185%1
<br />$0.00 1
<br />$0.00 1
<br />$0.00 1
<br />$0.00 1
<br />$0.00
<br />1 $0.00 1
<br />$0.00
<br />1 $0.00 1
<br />$0.00
<br />$0.00
<br />Electrcity Savings 115%1
<br />$7,490.04 1
<br />$7,789.64 1
<br />$8,101.22 1
<br />$8,425.27 1
<br />$8,762.28
<br />1 $9,112.77 1
<br />$9,477.29
<br />1 $9,856.38 1
<br />$10,250.631
<br />$10,660.66
<br />Down Payment
<br />Energy Savings
<br />$7,490.04
<br />$7,789.64
<br />$8,101.22
<br />$8,425.27
<br />$8,762.28
<br />$9,112.77
<br />$9,477.29
<br />$9,856.38
<br />$10,250.63
<br />$10,660.66
<br />Tax Credit
<br />Put Option
<br />-$5,932.00
<br />Rooftop Lease Payment
<br />$0.00
<br />$0.00
<br />$0.00
<br />$0.00
<br />$0.00
<br />$0.00
<br />$0.00
<br />$0.00
<br />$0.00
<br />$0.00
<br />Benefit Stream
<br />$7,490.04
<br />$7,789.64
<br />$8,101.22
<br />$8,425.27
<br />$8,762.28
<br />$9,112.77
<br />$9,477.29
<br />$9,856.38
<br />$10,250.63
<br />$10,660.66
<br />RR
<br />21.87
<br />Payback
<br />$1,558.04 1
<br />$9,347.67 1
<br />$17,448.901
<br />$25,874.171
<br />$34,636.451
<br />$43,749.231
<br />$53,226.511
<br />$63,082.891
<br />$73,333.521
<br />$83,994.18
<br />
|