Loading...
Utility CIAC Update December 2020 - 4.01.21 Isw City of Las Cruces' MOUNTAINS OF OPPORTUNITY Water and Wastewater D v lop t Fee C • 11 ctions CIAC Update 2nd Quarter FY21 April 1 ,2021 GRVj City of lag Cruces' FY 21 Water Development Fees $70,000 $60,000 $50,000 $40,000 $30,000 $20,000 $10,000 $- J u I Aug Sep Oct Nov Dec ■ Builder E Customer M Rates FY 21 Wastewater Development Fees $120,000 $100,000 $80,000 $60,000 $40,000 $20,000 Jul Aug Sep Oct Nov Dec ■ Builder ■ Customer ■ Rates FY 15-21 Water Development Fees $1,200,O00 $1,124,901 $1,000,000 ,201 919,805 $800,000 $ 9,015 768,332 $606,546 $600,000 $726,615 $400,000 - _ $200,000 Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun FY1S Total -FY16 Total -FY17 Total-FY18 Total FY19 Total FY20 Total FY21 Total FY 15-21 Wastewater Development Fees $1,800,000 $1,697,409 $1,600,000 3 $1,355,1 ' $1,400,000 $1,200,000 1 6 8: 1,061,601 $1,000,000 $857,599 8 $800,000 - ef:::�00- $600,000 $400,000 - -- $200,000 r $- Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun FY15 Total - FY16 Total - FY17 Total - FY18 Total FY19 Total FY20 Total FY21 Total Water & Wastewater Development Fees FY 21 Month Water Wastewater Builder Customer Rates FY21 Total Builder Customer Rates FY21 Total Jul $ 46,585 $ 26,100 $ 11,707 $ 84,392 $ 71,856 $ 30,144 $ 37,895 $ 139,895 Aug $ 26,620 $ 14,913 $ 23,143 $ 64,676 $ 59,231 $ 24,700 $ 58,008 $ 141,939 Se $ 51,425 $ 28,136 $ 28,204 $ 107,765 $ 96,616 $ 38,316 $ 45,182 $ 180,114 Oct $ 64,130 $ 35,926 $ 20,750 $ 120,806 $ 77,202 $ 30,141 $ 36,146 $ 143,489 Nov $ 45,980 $ 24,406 $ 25,874 $ 96,260 $ 57,289 $ 24,311 $ 39,048 $ 120,648 Dec $ 57,620 $ 33,634 $ 41,393 $ 132,647 $ 64,072 $ 26,049 $ 41,393 $ 131,514 Jan $ - $ - Feb $ - $ - Mar $ - $ - r $ - $May $ - $Jun $ - $ - Subtotal $ 292,360 $ 163,115 $ 151,071 $ 606,546 $ 426,266 $ 173,661 $ 257,672 $ 857,599 Average $ 48,727 $ 27,186 $ 25,179 $ 50,546 $ 71,044 $ 28,944 $ 42,945 $ 71,467 TARGET 50% 20 .: 2 2' 50% 20 ' �- n Water & Wastewater Development Fees FY 20 Month Water Wastewater Builder Customer Rates FY20 Total Builder Customer Rates FY20 Total Jul $ 58,685 $ 31,524 $ 26,337 $ 116,546 $ 59,859 $ 23,921 $ 37,020 $ 120,800 Aug $ 38,720 $ 23,046 $ 18,094 $ 79,860 $ 70,889 $ 28,391 $ 42,559 $ 141,839 Sep $ 24,200 $ 15,446 $ 11,174 $ 50,820 $ 50,494 $ 20,226 $ 30,899 $ 101,619 Oct $ 36,300 $ 20,340 $ 15,960 $ 72,600 $ 52,434 $ 23,726 $ 32,648 $ 108,808 Nov $ 9,075 $ 6,440 $ 4,523 $ 20,038 $ 21,849 $ 8,752 $ 13,700 $ 44,301 Dec $ 45,375 $ 115,779 $ 45,224 $ 206,378 $ 38,844 $ 81,905 $ 51,595 $ 172,344 Jan $ 38,115 $ 20,673 $ 16,764 $ 75,552 $ 89,339 $ 35,395 $ 53,634 $ 178,368 Feb $ 29,418 $ 16,950 $ 13,832 $ 60,200 $ 58,119 $ 23,281 $ 42,397 $ 123,797 Mar $ 36,754 $ 14,916 $ 11,172 $ 62,842 $ 61,312 $ 33,444 $ 37,895 $ 132,651 Apr $ 101,640 $ 58,810 $ 46,314 $ 206,764 $ 140,831 $ 55,986 $ 84,529 $ 281,346 May $ 42,955 $ 25,953 $ 19,422 $ 88,330 $ 60,206 $ 25,475 $ 36,728 $ 122,409 Jun $ 44,165 $ 25,615 $ 15,191 $ 84,971 $ 87,358 $ 34,423 $ 47,346 $ 169,127 Subtotal $ 505,402 $ 375,492 $ 244,007 $ 1,124,901 $ 791,534 $ 394,925 $ 510,950 $ 1,697,409 Average $ 42,117 $ 31,291 $ 20,334 $ 93,742 $ 65,961 $ 32,910 $ 42,579 $ 141,451 TARGET 50%, 28% 22'y 50% 20% 30% n FUND 5301 uWATER DEVELOPMENT Cash Accounts Only Fund Name (All) u Row Labels u Org name FY19 Actuals FY20 Revised FY20 YTD FY21 REVISED iF BEGINNING BALANCE ($217,416) ($1,419,841) ($1,419,841) ($1,447,598) O REVENUES -15301 uWATER DEVELOPMENT ($274,429) ($376,314) ($583,290) ($18,360) - 50334002 - WATER ADMI N ISTRATION =1507110 1JWATER DEV CHARGE- DEVELOPERS ($429,550) ($549,219) ($497,310) ($549,219) B507120 *,WATER DEV CHARGE RATES ($200,070) ($241,656) ($228,816) ($241,656) B 5071M t WATER DIF RATE RIDER $29,099 $0 $0 $0 O-SU7140 -:!JWATERIMPACTFEES- CUSTSURCH ($260,581) ($307,562) ($375,492) ($307,562) L=JS91190 iLBOTHERREVENUE $0 $0 $0 $0 51034022 - TECHNICAL SUPPORT =1591190 '*DOTHERREVENUE $0 $0 $0 $0 REVENUES Total ($1,135,531) ($1,474,751) ($1,684,908) ($1,116,797) '='EXPENDITURES - 5301 WATER DEVELOPMENT $55,050 $55,050 $55,050 $255,C50 50334002 WATER ADMINISTRATION 9820000 '`)BOND/NOTE PRINCIPAL $750,348 $756,911 $727,959 $774,544 B820000 J INTEREST EXPENSE $0 $0 $0 $0 1821000 !BOND/NOTE INTEREST $235,459 $224,968 $204,453 $213,598 =151034022 UTECHNICAL SUPPORT 0721070 'D PROFESSI ONAL/TECH N I CAL SERVICE $0 $29,000 $28,220 $2,000 FJ721080 J PURCHASED SERVICES GENERAL $0 $0 $0 $0 1804200 -BINFRASTRUCTURE-DEVELOPMENT $0 $800,000 $6,264 $742,240 EXPENDITURES Total $1,040,857 $1,865,929 $1,021,946 $1,997,432 ENDING BALANCE ($312,090) ($1,028,663) ($2,082,803) ($576,963) FUND 5401 !_-;WASTEWATER DEVELOPMENT Cash Accounts Only Fund Name (All) U Row Labels -r Org name FY19 Actual FY20 Revised FY20 YTD FY21 REVISED * BEGINNING BALANCE ($3,306,817) ($5,089,090) ($5,089,090) ($3,487,784) - REVENUES MW - 5401 WASTEWATER DEVELOPMENT ($176,453) ($39,443) ($140,970) ($239,442) - 50434002 JWASTEWATERADMINISTRATION U507080 - WASTEWATER DEV CHG- SURCHARGE ($278,660) ($297,382) ($385,210) ($275,367) U507090 - WASTEWATER DEVEL CHARGE RATES ($403,999) ($446,073) ($463,604) ($373,118) C-J 507220 - WW DI F RATE RI DER $0 $0 $0 $0 r1507230 - WW IMPACT FEES- DEVELOPERS ($664,634) ($743,454) ($791,534) ($633,705) - 565000 - PROVISION FOR UNCOLLIBLEACCTS $0 $0 $0 $0 REVENUES Total ($1,523,745) ($1,526,352) ($1,781,318) ($1,521,632) - EXPENDITURES (=-'5401 WASTEWATER DEVELOPMENT $44,700 $44,700 $44,700 $44,700 050434002 - WASTEWATE R A D M I N I STRATI 0 N - 721070 - PROFESSIONAL/TECHNICALSERVICE $24,720 $300,000 $3,500 $2,000 - 721080 - PURCHASED SERVICES GENERAL $0 $0 $0 $0 - 804000 - INFRASTRUCTURE - 11399 INFRASTRUCTURE $0 $0 $0 $0 - 810000 - BOND/NOTE PRINCIPAL $405,540 $413,225 $414,260 $425,640 - 821000 - BOND/NOTE INTEREST $145,778 $169,662 $168,629 $157,266 - 804200 jINFRASTRUCTURE-DEVELOPMENT C�11367 INFRASTRUCTURE-DEVELOPMENT $0 $0 $0 $0 CJ 11384 INFRASTRUCTURE-DEVELOPMENT $0 $0 $0 $0 Ci 11389 INFRASTRUCTURE-DEVELOPMENT $0 $0 $0 $0 Ej 11390 INFRASTRUCTURE-DEVELOPMENT $0 $0 $0 $0 - 51034016 -TECHNICAL SUPPORT - 804200 JINFRASTRUCTURE-DEVELOPMENT Ej11387 INFRASTRUCTURE-DEVELOPMENT $154,544 $2,472,130 $1,052,546 $1,610,430 0- 11389 INFRASTRUCTURE-DEVELOPMENT $0 O INFRASTRUCTURE-DEVELOPMENT $1,045,674 $400,000 $42,258 $100,000 EXPENDITURES Total _jW $1,820,956 $3,799,717 $1,725,893 $2,340,036 ENDING BALANCE ($3,009,606) ($2,815,725) ($5,144,515) ($2,669,380) End of presentation . . . 0 m