Commerce City Council
December 12, 2023

Cash Flow - 20 Years (NEW - 5.15%) - With ITC
City of Commerce
Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 10 Year 11 Year 12 Year 13 Year 14 Year 15 Year 16 Year 17 Year 18 Year 19 Year 20 Years 21 to 25 Years 26 to 30 Totals 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 2041 2042 2043 2044 2045 to 2049 2050 to 2054 Energy Efficiency Savings $13,407 $67,033 $71,055 $75,318 $79,837 $84,627 $89,705 $95,087 $100,793 $106,840 $113,251 $120,046 $127,248 $134,883 $142,976 $151,555 $3,129 $3,316 $3,515 $3,726 $3,950 $23,602 $31,585 $1,646,487 O&M Savings $28,783 $143,913 $148,230 $152,677 $157,258 $161,975 $166,835 $171,840 $176,995 $182,305 $187,774 $99,520 $102,506 $105,581 $108,748 $112,011 $115,371 $118,832 $122,397 $126,069 $129,851 $0 $0 $2,819,471 New Renewable Savings $59,646 $298,228 $313,593 $329,749 $346,738 $364,602 $383,386 $403,138 $423,908 $445,747 $468,712 $492,860 $518,252 $544,953 $573,029 $602,551 $633,595 $666,237 $700,562 $736,655 $774,607 $4,514,396 $5,803,465 $20,398,608 Solar Direct Pay ITC $1,347,746 $0 $0 $1,347,746
Capital Cost Avoidance $0 $0 $0
Total Program Savings $101,835 $509,174 $1,880,624 $557,744 $583,833 $611,204 $639,926 $670,065 $701,695 $734,892 $769,737 $712,426 $748,007 $785,417 $824,753 $866,117 $752,094 $788,386 $826,475 $866,450 $908,409 $4,537,999 $5,835,050 $26,212,312 Total Project Amount - $9,713,379
Capital Contribution $0 $0 $0
Annual Lease Payment $508,174 $1,879,624 $556,744 $582,833 $610,204 $638,926 $669,065 $700,695 $733,892 $768,737 $711,426 $747,007 $784,417 $823,753 $865,117 $751,094 $787,386 $825,475 $865,450 $896,872 $0 $0 $15,706,891 Total Program Payments $0 $508,174 $1,879,624 $556,744 $582,833 $610,204 $638,926 $669,065 $700,695 $733,892 $768,737 $711,426 $747,007 $784,417 $823,753 $865,117 $751,094 $787,386 $825,475 $865,450 $896,872 $0 $0 $15,706,891 Net Annual Cash Flow $101,835 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $11,537 $4,537,999 $5,835,050 $10,505,421 Net Cumulative Cash Flow $101,835 $102,835 $103,835 $104,835 $105,835 $106,835 $107,835 $108,835 $109,835 $110,835 $111,835 $112,835 $113,835 $114,835 $115,835 $116,835 $117,835 $118,835 $119,835 $120,835 $132,371 $4,670,370 $10,505,421