C153701 Consents and certificates

• Contract/PO #: C153701
• Contractor Name: Fort Morgan, City of & Fort Morgan Water Works and Distribution Enterprise
• Contract Type: Loan
• Water District: 1
• County: Weld
• Bill Number: SB94-029
• Loan Projects - Doc Type: Contract Documents

, -

- ,,(~t/HJ ~ I
__~==l~L!~d'" "__L_.,:J

City of Fort Morgan
Projected Operating Expenses at Completion of C-BT Project
Draft: 12/11/97
Total Residential Average Total Total Transfer Tap Total Annual Depreciation Small Payments on Payments on Payments Payments on Payments on Payments on
Revenue Water Monthly Residential Commercial From Fee Revenue Operating and Capital $2,500,000 $5,500,000 for Interim $4,800,000 $15,000,000 $8,000,000
Vear Required Taps Bill Revenue Revenue C.I.F. Revenue Generated Expenses Reserves CWRPDA Loan CWCB Loan Financing RD Loan CWRPDA Loan CWCB Loan
1998 $2,186,881 2,960 $28.25 $1,003,440 $972,003 $197,544 $25,125 $2,212,006 $749,000 $185,000 $365,000 $210,002 $277,879 $170,000 $230,000
1999 $3,173,417 2,975 $41.39 $1,477,632 $1,394,961 $287,019 $25,753 $3,201,572 $850,000 $185,000 $200,000 $211,074 $277,879 $135,000 $130,560 $675,000 $462,640
2000 $3,890,334 2,990 $54.94 $1,928,026 $1,776,511 $351,983 $26,397 $4,101,437 $1 227000 $170000 $8Q.QQD 5711 ZR1 5777 R7~ $261 120 $1.153650 $462640
2001 $3,927,586 3,005 $55.16 $1,988,892 $1,794,276 $355,159 $27,057 $4,186,218 $1,257,675 $174,250 $82,000 $212,108 $277,879 $261,120 $1,153,650 $462,640
2002 $3,965,375 3,020 $55.39 $2,006,953 $1,812,219 $358,384 $27,733 $4,228,436 $1,289,117 $178,606 $84,050 $212,049 $277,879 $261,120 $1,153,650 $462,640
2003 $4,003,753 3,035 $46.68 $1,699,816 $1,916,814 $361,663 $28,427 $4,032,180 $1,321,345 $183,071 $86,151 $211,633 $277,879 $261,120 $1,153,650 $462,640
2004 $4,042,707 3,050 $46.87 $1,715,472 $1,934,468 $364,994 $29,137 $4,071,844 $1,354,378 $187,648 $88,305 $210,822 $277,879 $261,120 $1,153,650 $462,640
2005 $4,082,152 3,065 $47.07 $1,731,337 $1,952,359 $368,370 $29,866 $4,112,018 $1,388,238 $192,339 $90,513 $209,509 $277,879 $261,120 $1,153,650 $462,640
2006 $4,123,177 3,080 $47.28 $1,747,878 $1,971,011 $371,889 $30,612 $4,153,790 $1,422,944 $197,148 $92,775 $208,757 $277,879 $261,120 $1,153,650 $462,640
2007 $4,168,262 3,096 $47.54 $1,766,153 $1,991,619 $375,777 $31,378 $4,199,840 $1,458,517 $202,077 $95,095 $211,020 $277,879 $261,120 $1,153,650 $462,640
2008 $4,210,515 3,111 $47.76 $1,783,218 $2,010,863 $379,408 $32,162 $4,242,677 $1,494,980 $207,128 $97,472 $209,381 $277,879 $261,120 $1,153,650 $462,640
2009 $4,211,095 3,127 $47.53 $1,783,466 $2,011,142 $379,461 $32,966 $4,244,061 $1,532,355 $212,307 $99,909 $211,235 $277,879 $261,120 $1,153,650 $462,640
2010 $4,258,488 3,143 $47.83 $1,803,716 $2,033,977 $383,769 $33,790 $4,292,278 $1,570,664 $217,614 $102,407 $212,514 $277,879 $261,120 $1,153,650 $462,640
2011 $4,305,591 3,158 $48.12 $1,823,841 $2,056,672 $388,051 $34,635 $4,340,226 $1,609,930 $223,055 $104,967 $212,350 $277,879 $261,120 $1,153,650 $462,640
2012 $4,350,670 3,174 $48.39 $1,843,102 $2,078,392 $392,149 $35,501 $4,386,171 $1,650,179 $228,631 $107,591 $208,980 $277,879 $261,120 $1,153,650 $462,640
2013 $4,404,068 3,190 $48.74 $1,865,918 $2,104,120 $397,004 $36,388 $4,440,456 $1,691,433 $234,347 $110,281 $212,718 $277,879 $261,120 $1,153,650 $462,640
2014 $4,418,709 3,206 $48.66 $1,872,174 $2,111,175 $398,335 $37,298 $4,456,008 $1,733,719 $240,206 $113,038 $176,458 $277,879 $261,120 $1,153,650 $462,640
2015 $4,294,425 3,222 $47.05 $1.819,071 $2,051,292 $387,036 $38,231 $4,332,656 $1,777,062 $246,211 $115,864 $277,879 $261,120 $1,153,650 $462,640
2016 $4,347,904 3,238 $47.40 $1,841,921 $2,077,059 $391,898 $39,186 $4,387,090 $1,821,488 $252,366 $118,760 $277,879 $261,120 $1,153,650 $462,640
2017 $4,402,719 3,254 $47.77 $1,865,342 $2,103,470 $396,881 $40,166 $4,442,885 $1,867,026 $258,675 $121,729 $277,879 $261,120 $1,153,650 $462,640
2018 $4,458,905 3,270 $48.14 $1,889,348 $2,130,542 $401,989 $41,170 $4,500,075 $1,913,701 $265,142 $124,773 $277,879 $261,120 $1,153,650 $462,640
2019 $4,516,495 3,287 $48.53 $1,913,955 $2,158,290 $407,224 $42,199 $4,558,695 $1,961.544 $271,771 $127,892 $277,879 $261,120 $1,153,650 $462,640
2020 $3,421,875 3,303 $36.49 $1,446,254 $1,630,882 $307,714 $43,254 $3,465,130 $2,010,582 $278,565 $131,089 $277,879 $261,120 $462,640
2021 $3,482,381 3,320 $36.95 $1,472,106 $1,660,035 $313.214 $44,336 $3,526,717 $2,060,847 $285,529 $134,367 $277,879 $261,120 $462,640
2022 $3,544,400 3,336 $37.43 $1,498,605 $1,689,917 $318,852 $45,444 $3,589,844 $2,112,368 $292.667 $137,726 $277,879 $261,120 $462,640
2023 $3,607,969 3,353 $37.92 $1.525,767 $1,720,545 $324,631 $46.580 $3,654,549 $2,165,177 $299,984 $141,169 $277,879 $261,120 $462,640
2024 $3,673,127 3,370 $38.42 $1,553,607 $1,751,940 $330,555 $47,745 $3,720,872 $2,219,307 $307,483 $144,698 $277, 879 $261,120 $462,640
2025 $3,739,914 3,387 $38.93 $1,582,143 $1,784,119 $336,626 $48,938 $3,788,853 $2,274,789 $315,170 $148,316 $277,879 $261,120 $462,640
2026 $3,808,371 3,404 $39.45 $1,611,393 $1,817,103 $342,850 $50,162 $3,858,533 $2,331,659 $323,050 $152,023 $277,879 $261,120 $462,640
2027 $3,878,540 3,421 $39.99 $1,641,374 $1,850,911 $349,229 $51,416 $3,929,956 $2,389,951 $331,126 $155,824 $277,879 $261,120 $462,640
2028 $3,487,822 3,438 $35.98 $1,484,315 $1,673,802 $315,812 $52,701 $3,540,524 $2,449,699 $339,404 $159,720 $277,879 $261,120 $462,640
2029 $3,561,543 3,455 $36.56 $1,515,814 $1,709,322 $322,514 $54,019 $3,615,562 $2,510,942 $347,889 $163,713 $277,879 $261,120
2030 $3,637,106 3,472 $37.15 $1,548,100 $1,745,730 $329,383 $55,369 $3,692,476 $2,573,715 $356,586 $167,805 $277,879 $261,120
2031 $3,714,559 3,490 $37.76 $1,581,193 $1,783,048 $336,424 $56,754 $3,771,313 $2,638,058 $365,501 $172,001 $277,879 $261,120
2032 $3,793,948 3,507 $38.38 $1,615,114 $1,821,299 $343,641 $58,172 $3,852,120 $2,704,010 $374,639 $176,301 $277,879 $261,120
2033 $3,875,322 3,525 $39.01 $1,649,883 $1,860,506 $351,039 $59,627 $3,934,949 $2,771,610 $384,005 $180,708 $277,879 $261,120
2034 $3,680,851 3,542 $37.00 $1,572,727 $1,773,501 $334,623 $61,117 $3,741,968 $2,840,900 $393,605 $185,226 $277,879 $261,120
2035 $3,766,344 3,560 $37.67 $1,609,256 $1,814,693 $342,395 $62,645 $3,828,989 $2,911,923 $403,445 $189,856 $261,120
2036 $3,853,975 3.578 $38.36 $1,646,698 $1,856,915 $350,361 $64,212 $3,918,186 $2,984,721 $413,531 $194,603 $261,120
2037 $3,943,796 3,596 $39.05 $1,685,076 $1,900,193 $358,527 $65,817 $4,009,613 $3,059,339 $423,869 $199,468 $261,120
2038 $4,035,863 3,614 $39.77 $1,724,414 $1,944,552 $366,897 $67,462 $4,103,325 $3,135,822 $434,466 $204,455 $261,120
Assumptions:
C-BT Project is Fully Operational in the Year 2000
Number of Residential Water Taps Increases by 0.5% per year
Operating and Maintenance Costs Increase by 2.5% per year
Interest Paid on Reserve Accounts is 5%
Excel Corp. (Beel Plant) is supplied groundwater at the current rate except for demands currently being supplied by Morgan County Quality Waler Dislrict
Leprino Foods is not a City customer until 2003 due 10 contractual agreements with the Morgan County Quality Water District
Residential Revenues Generate 47% of Revenues Irom Customers lor Years 2003 + (City begins serving Leprino Foods)
Total Revenue Required = O&M + Debt Service + Depreciation and Small Capital RECEIVED
C.IF Transfer is Cash Transferred from the City General Fund to the Water Enterprise Fund.
Debt Coverage Ratio = (Tolal Revenue - O&M - Smali Capital)/(AII Debt Service)
DEe 1 2 1997
~atet
. Board