Commerce City Council
February 8, 2022

Cash Flow
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 Year 21 Year 22 Year 23 Year 24 Year 25 Year 26 Year 27 Year 28 Year 29 Year 30 Totals 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 2041 2042 2043 2044 2045 2046 2047 2048 2049 2050 2051 2052 2053 2054 Energy Efficiency Savings $8,640 $43,198 $45,790 $48,537 $51,450 $54,537 $57,809 $61,277 $64,954 $68,851 $72,982 $77,361 $82,003 $86,923 $92,139 $97,667 $2,952 $3,129 $3,316 $3,515 $3,726 $3,950 $4,187 $4,438 $4,705 $4,987 $5,286 $5,603 $5,939 $6,296 $6,673 $1,082,822 O&M Savings $24,535 $122,677 $126,357 $130,148 $134,052 $138,074 $142,216 $146,483 $150,877 $155,404 $160,066 $82,434 $84,907 $87,454 $90,078 $92,780 $95,563 $98,430 $101,383 $104,425 $107,557 $2,375,901 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 $814,515 $856,479 $900,605 $947,004 $995,794 $1,047,097 $1,101,043 $1,157,769 $1,217,417 $1,280,139 $20,398,608 Solar Direct Pay ITC $1,347,746 $1,347,746
Capital Cost Avoidance $0
Total Program Savings $92,821 $464,103 $1,833,486 $508,435 $532,240 $557,212 $583,411 $610,898 $639,739 $670,002 $701,760 $652,655 $685,162 $719,330 $755,245 $792,998 $732,110 $767,796 $805,262 $844,595 $885,891 $818,465 $860,666 $905,043 $951,708 $1,000,780 $1,052,383 $1,106,646 $1,163,708 $1,223,713 $1,286,812 $25,205,078 Total Project Amount - $9,059,952
Capital Contribution $0
Annual Lease Payment $ 713,313 $ 721,328 $ 721,327 $ 721,327 $ 721,327 $ 721,327 $ 721,327 $ 721,327 $ 721,328 $ 721,327 $ 721,327 $ 721,327 $ 721,328 $ 721,328 $ 721,327 $ 721,327 $ 721,327 $ 721,328 $ 721,327 $ 721,327 $14,418,530 Total Program Payments $0 $713,313 $721,328 $721,327 $721,327 $721,327 $721,327 $721,327 $721,327 $721,328 $721,327 $721,327 $721,327 $721,328 $721,328 $721,327 $721,327 $721,327 $721,328 $721,327 $721,327 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $14,418,530 Net Annual Cash Flow $92,821 ($249,210) $1,112,159 ($212,893) ($189,087) ($164,115) ($137,916) ($110,429) ($81,588) ($51,325) ($19,567) ($68,671) ($36,165) ($1,998) $33,917 $71,671 $10,783 $46,469 $83,934 $123,268 $164,564 $818,465 $860,666 $905,043 $951,708 $1,000,780 $1,052,383 $1,106,646 $1,163,708 $1,223,713 $1,286,812 $10,786,548 Net Cumulative Cash Flow $92,821 ($156,389) $955,770 $742,877 $553,790 $389,675 $251,759 $141,330 $59,742 $8,416 ($11,150) ($79,822) ($115,986) ($117,984) ($84,066) ($12,395) ($1,612) $44,858 $128,792 $252,059 $416,623 $1,235,088 $2,095,754 $3,000,797 $3,952,505 $4,953,286 $6,005,669 $7,112,315 $8,276,023 $9,499,736 $10,786,548