Loading...
HomeMy WebLinkAbout2019-0916B Resolution Adopting FY2020 BudgetResolution No. 2019-0916B CERTIFICATE OF RESOLUTION 2019-0916B THE STATE OF TEXAS COUNTIES OF DENTON AND TARRANT I, the undersigned member of the Board of Directors of Trophy Club Municipal Utility District No. 1 of Denton and Tarrant Counties, Texas (the "District"), hereby certify as follows: 1. That I am the duly qualified Secretary of the Board of Directors of the District, and that, as such, I have custody of the minutes and records of the District. 2. That the Board of Directors of the District convened in Open Session at a Regular Meeting on September 16, 2019, at the regular meeting place thereof, and the roll was called of the duly constituted officers and members of the Board of Directors, to wit: Gregory Wilson President William C. Rose Vice President Steve Flynn Secretary/Treasurer Kelly Castonguay Director Mark Chapman Director All members of the Board were present except ,_al-pvt , thus constituting a quorum. Whereupon, among other business, the following Oas transacted at such meeting: A RESOLUTION APPROVING THE 2020 FISCAL YEAR BUDGET OF TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 and duly introduced for the consideration of the Board of Directors of the District. It was then duly moved and seconded that such Resolution be adopted and, after due discussion, such motion, carrying with it the adoption of such Resolution, prevailed and carried by the following vote: AYES: NAYS: lZ ABSTENSIONS: 3. That a true, full and correct copy of such Resolution adopted at such meeting is attached to and follows this certificate; that such resolution has been duly recorded in the minutes of the Board of Directors for such meeting; that the persons named in the above and foregoing Paragraph 2 were the duly chosen, qualified and acting officers and members of the Board of Directors as indicated therein, that each was duly and sufficiently notified officially and personally, in advance, of the time, place and purpose of such meeting, and 1 of 5 Resolution No. 2019-0916B that such Resolution would be introduced and considered for adoption at such meeting, and that each consented, in advance, to the holding of such meeting for such purpose; that the canvassing of the officers and members of the Board of Directors present at and absent from such meeting and of the votes of each on such motion, as set forth in the above and foregoing Paragraph 2, is true and correct; and that sufficient and timely notice of the hour, date, place and subject of such meeting was given and posted as required by Chapter 551, Texas Government Code, as amended. SIGNED AND SEALED the 16th day of September 2019. Steve ynn, Secretary °1`re urer Board of Directors Laurie S al ght, District Secre 2 of 5 Resolution No. 2019-0916B RESOLUTION NO. 2019-0916B A RESOLUTION APPROVING THE 2020 FISCAL YEAR BUDGET OF TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1 WHEREAS, Trophy Club Municipal Utility District No. 1 (the "District") is a conservation and reclamation district of the State of Texas created under Article XVI, Sec. 59 of the Texas Constitution, and the District operates under Chapters 49 and 54 of the Texas Water Code, as amended; WHEREAS, Section 49.057(b) of the Texas Water Code requires the board of directors of a water district to adopt an annual budget; WHEREAS, Title 30, Section 293.97(b), Texas Administrative Code, provides that an operating budget shall be passed and approved by a resolution of the governing board of a water district and shall be made a part of the governing board minutes; and WHEREAS, the Board of Directors of the District desires to adopt a budget for the 2020 fiscal year in an open, public meeting, proper notice of which has been given as required by law. NOW THEREFORE BE IT RESOLVED BY THE BOARD OF DIRECTORS OF TROPHY CLUB MUNICIPAL UTILITY DISTRICT NO. 1: Section 1. That the facts and recitations found in the preamble of this Resolution are hereby found and declared to be true and correct and are incorporated by reference herein and expressly made a part hereof, as if copied verbatim. Section 2. That the annual budget of revenues and expenditures necessary for conducting the operations and affairs of the District for Fiscal Year 2020, attached hereto and incorporated herein as Exhibit A, is hereby approved and adopted. Said budget document shall be on file for public inspection in the office of the District. Section 3. That the District's expenditures during the fiscal year shall be made in accordance with the approved budget and any amendments thereto approved by the Board of Directors. Section 4. A copy of this Resolution and the budget approved hereby shall be attached to the minutes of the Board's September 16, 2019 meeting. 3 of 5 Resolution No. 2019-0916B EXHIBIT "A" (Approved FY 2020 Budget) 4 TROPHY CLUB FY 2020 Adopted Annual Budget .....] 1 General Fund Revenue FY 2020 Tax Collections FY 2020 PID Surcharges Reserve Funds Total Revenue Water Expense Wastewater Expense Board of Directors Expense Administration Expense Non -Departmental Expense Total Expense Net Budget Surplus/Deficit Tax Debt Service Fund Revenue FY 2020 Tax Collections PID Surcharge Total Revenue Debt Service Expense Total Expense Budget Summary TAX RATE SUMMARY M&O (General Fund) Tax M&O Fire Tax 1 & S (Debt Service) Tax 2019 0.00765 0.06719 0.04134 Total Tax Rate: 2020 0.00748 0.06738 0.03787 0.11618 0.11273 Increase/Decrease: PID Fire Assessment Rate Increase/Decrease: -0.00403 0.06719 -0.00151 -0.00345 0.06737 0.00018 1 2019 PROPERTY VALUE SUMMARY MUD Tarrant Co. MUD Denton Co. PID Out of District & PID Total Value: 10,345,953 134,871 164,253 0 10,645,077 5,506,929 3,157,421 13,230 1,776,712 184,561 10,638,853 6,224 223,004 685,441 114,563 1,023,008 1,015,008 521,630,735 1,280,500,446 751,813,073 351,306 2,554,295,560 Fire Fund Revenue FY 2020 Tax Collections FY 2020 PID Assessment Reserve Funds Total Revenue 111,000 1,214,230 506,789 0 1,832,019 Fire Expense Total Expense Net Budget Surplus/Deficit Revenue Debt Service Fund 1,832,019 1,832,019 0 Revenue Total Revenue 1,205,749 1,205,749 Debt Service Expense 1,201,249 1,015,008 Total Expense 1,201,249 Net Budget Surplus/Deficit 8,000 Net Budget Surplus/Deficit 4,500 FY 2020 Tax/Assess Rate = 0.067381 IFY 2020 PID Surcharge Rate = 0.015241 TAX RATE ASSESSMENT PID ASSESSMENT & SURCHARGE CALCULATIONS FIRE TAX/ASSESSMENT RATE NET TAX VALUE: TARRANT COUNTY: 5521,630,735 DENTON COUNTY: $1,280,500,446 DENTON CO. PID: $751,813,073 OUT OF DISTRICT & PID REQUIRED REVENUE FIRE 51,721,019 O&M TAX/SURCHARGE RATE $351,306 TAX/ASSESS RATE = REQUIRED REVENUE/TOTAL VALS/100 Vals/100 = 25,542,956 Revenue from MUD Tax = Revenue from PID Assess = NET TAX VALUE: TARRANT COUNTY: DENTON COUNTY: $ 1,214,230 $ 506,789 Total: $ 1,721,019 521,630,735 1,280,500,446 DENTON CO. PID: 751,813,073 REQUIRED REVENUE M&O 184,561 168,800 *MUD (All of Dept. 39 Budget) **P1D (Legal and Auditor only Dept 39 Budget) I&S TAX/SURCHARGE RATE NEW DEBT: CALCULATE AMOUNT DUE FROM PID Certified 7/22/2019 7/16/2019 7/16/2019 7/16/2019 Certified 7/22/2019 7/16/2019 7/16/2019 TAX/SURCHARGE RATE = REQUIRED REVENUE/TOTAL VALS/100 Vals/100 = 25,539,443 FY 2020 MUD M&0 Tax Rate = 0.00748 FY 2020 PID Tax/Surcharge Rate = 0.00661 Revenue from MUD Tax = Revenue from PID Surcharge = NET TAX VALUE: $ 134,871 $ 49,690 Total: $ 184,561 TARRANT COUNTY: $521,630,735 DENTON COUNTY: $1,280,500,446 DENTON CO. PID: $751,813,073 REQUIRED REVENUE TAX DEBT 2014 AND AFTER (I&S) $389,175 MUD DEBT: CALCULATE MUD TAX Certified 7/22/2019 7/16/2019 7/16/2019 TAX/SURCHARGE RATE = REQUIRED REVENUE/TOTAL VALS/100 Vals/100 = 25,539,443 ***NOT FINAL TAX RATE: ONLY USED TO CALCULATE PID SHARE Revenue from MUD Tax = $ 274,612 Revenue from PID Surcharge = $ 114,563 Total: $ 389,175 NET TAX VALUE: TARRANT COUNTY: DENTON COUNTY: $521,630,735 $1,280,500,446 REQUIRED REVENUE I&S MUD DEBT $682,441 Certified 7/22/2019 7/16/2019 TAX/SURCHARGE RATE = REQUIRED REVENUE/TOTAL VALS/100 Vals/100 = 18,021,312 FY 2020 Tax Rate = 0.03787 Revenue from MUD Tax = Revenue from PID = N/A 682,441 Total: $ 682,441 OVERALL TAX RATE FY 2020: $0.11273 MAX ROLLBACK RATE $0.11440 TAX COMPARISON FY 2019 TO FY 2020 M&O (General Fund) Tax M&O Fire Tax I & S (Debt Service) Tax Total Tax Rate: Increase/Decrease: PID Fire Assessment Rate 2019 2020 0.00765 0.00748 0.06719 0.06738 0.04134 0.03787 0.11618 0.11273 -0.00403 -0.00345 0.06719 0.06738 FIRE DEPARTMENT Account Description FY 2016 FY 2017 FY 2018 FY 2019 FY 2019 FY 2020 Budget Actual Actual Actual Proposed Adopted Proposed Change % Revenues -Town L 122-44004-000-000 Assessment - Emerg Svcs 403,838 477,776 490,697 538,869 500,839 506,789 1.19% 122-40003-000-000 122-40015-000-000 122-41320-000-000 122-43400-000-000 122-44004-000-000 122-42500-000-000 Revenues -MUD 122-40001-000-000 122-40010-000-000 122-40011-000-000 122-40020-000-000 122-49000-000-000 122-49026-000-000 122-49035-000-000 122-49036-000-000 122-49900-000-000 Emer Svcs Assessmen/Delinquent Property Taxes/Assessments P&I Fire Permits/Sprinkler & Plan Review Fire Inspections Denton/Tarrant Cty Pledge -Fire Grant Revenue 346 5,200 2,100 83,704 65,000 90,000 46,000 1,075 10,000 10,000 10,000 10,000 10,000 10,000 55,000 -48.89% Assessment-Emerg Svcs Reimb from Town Property Taxes/MUD Fire Property Taxes/Fire-Delinquent Property Taxes/Fire P&I Capital Leases -Other Financial Sources Proceeds from Sale of Assets Prior Year Reserves GASB Reserves Miscellaneous Income Total Revenue 112 - - - 875,978 1,036,680 1,066,061 1,201,853 1,117,000 1,214,230 18,076 3,196 3,945 7,621 4,184 4,787 60,000 60,000 8.70% 75,000 - -100.00% 36,182 23,164 11,100 149 1,429,416 1,617,362 1,659,193 1,815,722 1,792,839 1,832,019 2.19% Expenses -Town 122-50100-045-000 Salaries & Wages 511,904 537,947 582,657 638,481 642,064 685,229 6.72% 122-50130-045-000 Overtime 58,952 68,555 71,354 73,688 73,688 72,896 -1.07% 122-50011-045-000 Holiday Pay 14,718 122-50140-045-000 Longevity 5,730 5,599 5,856 6,566 6,566 6,890 4.93% 122-50145-045-000 Stipend - 6,313 - - - 122-50160-045-000 Certification 4,740 4,988 4,950 4,950 4,950 9,750 96.97% 122-51200-045-000 Retirement 71,888 79,312 83,513 90,511 90,511 99,005 9.38% 122-51210-045-000 Medical Insurance 56,876 61,919 59,991 85,791 75,498 79,220 4.93% 122-51215-045-000 Dental lnsurance 5,016 4,373 5,388 4,998 5,985 6,670 11.45% 122-51216-045-000 Vision Insurance 968 429 569 536 536 612 14.18% 122-51218-045-000 Life lnsurance & Other 4,016 2,853 3,316 4,068 4,068 4,982 22.47% 122-52220-045-000 Social Security Taxes 32,993 34,596 37,002 43,901 44,123 46,795 6.06% 122-52225-045-000 Medicare Taxes 7,714 8,084 8,651 10,267 10,319 10,944 6.06% 122-52250-045-000 Unemployment Taxes 2,125 158 1,620 1,628 1,628 1,625 -0.18% 122-52260-045-000 Workman's Compensation 9,379 7,885 8,639 11,203 11,269 16,762 48.74% 122-52290-045-000 Physicals/Testing 54 2,917 7,417 7,794 7,794 6,675 -14.36% 122-53240-045-000 Tuition Reimbursement 2,184 3,488 9,600 9,600 8,290 -13.65% 122-55045-045-000 Legal 6,560 - - - 122-55085-045-000 Generator Maintenance & Repairs - 122-60026-045-000 Cable 1,920 - - - 122-60100-045-000 Professional Outside Services 2,744 2,327 125 3,000 3,000 5,500 83.33% 122-60180-045-000 Fire lnspection/Enforcement 359 - - 122-60243-045-000 Prior Year Expense - 122-60280-045-000 Property Maintenance - - 122-60800-045-000 Software & Support 5,561 608 2,784 12,813 12,813 16,749 30.72% 122-61150-045-000 Tax Adminstration - - - - 1,605 122-63200-045-000 Advertising 4,200 398 750 750 1,500 100.00% 122-63250-045-000 Printing - 265 155 250 250 300 20.00% 122-63450-045-000 Radios 7,934 167 - 122-63551-045-000 Schools & Training 3,743 3,825 15,392 24,090 24,090 24,505 1.72% 122-64000-045-000 Electricity 5,686 6,446 4,895 8,000 8,000 8,400 5.00% 122-64100-045-000 Water 2,027 2,758 3,203 3,800 3,800 4,000 5.26% 122-64300-045-000 Telephone 59 - - 122-64400-045-000 Communications/Mobiles 6,835 11,235 15,884 8,925 8,925 16,691 87.01% 122-65030-045-000 Chemicals 1,191 - - - FIRE DEPARTMENT Account Description FY 2016 FY 2017 FY 2018 FY 2019 FY 2019 FY 2020 Budget Actual Actual Actual Proposed Adopted Proposed Change 122-65200-045-000 Building Maintenance - 13,758 14,335 93,000 18,000 22,200 23.33% 122-65300-045-000 Vehicle Maintenance 14,808 23,053 49,770 48,500 48,500 41,800 -13.81% 122-65350-045-000 Equipment Maintenance 54,653 5,214 12,394 21,900 21,900 18,000 -17.81% 122-66250-045-000 Emergency Management 1,000 1,919 158 1,000 1,000 1,000 0.00% 122-66500-045-000 Dispatch- Denton County - 2,376 3,045 3,481 3,481 3,986 14.51% 122-68100-045-000 Dues & Memberships 15,457 15,404 19,601 20,417 20,417 20,337 -0.39% 122-68190-045-000 Flags & Repair 2,355 3,311 1,000 9,419 9,419 - -100.00% 122-68200-045-000 Travel & per diem 1,147 1,979 7,280 13,507 13,507 14,510 7.43% 122-68600-045-000 Meetings - 71 - - - - 122-68700-045-000 Safety Programs - 3,375 - - - - 122-69255-045-000 Airpacks - - - - - - 122-70100-045-000 Office Supplies 328 815 289 250 250 300 20.00% 122-00000-045-000 Printer Supplies - - 1,041 1,400 1,400 1,400 0.00% 122-70300-045-000 Postage 46 57 53 100 100 100 0.00% 122-70400-045-000 Publications/Books/Subscrips 172 350 267 350 350 350 0.00% 122-71000-045-000 Fuel 4,729 15,614 9,082 13,933 13,933 12,215 -12.33% 122-72100-045-000 Uniforms 9,516 9,266 6,338 5,907 5,907 7,145 20.96% 122-72220-045-000 Pharmacy - 158 - - - - 122-72300-045-000 Safety Equipment/Protective Clothing 47,907 27,815 25,217 31,600 31,600 27,700 -12.34% 122-78400-045-000 Small Equipment 1,868 17,681 5,499 25,800 8,300 4,950 -40.36% 122-78600-045-000 Hardware 394 - 914 4,200 4,200 4,458 6.14% 122-79100-045-000 Maintenance & Supplies - 410 386 1,500 1,500 1,500 0.00% 122-79999-045-000 Miscellaneous Expense 1,119 767 3,246 6,000 6,000 4,000 -33.33% 122-83700-045-000 Capital Expenses - 28,962 - - - - 122-83701-045-000 Capital Replacement - - - - - - 122-83702-045-000 IT Equipment - - - - - - 122-87100-045-000 Programs & Special Projects 3,671 3,206 10,745 15,300 15,300 14,900 -2.61% Expenses -MUD 122-55080-045-000 Maintenance & Repairs (GASB34) - - 1,490 - - - 122-60030-045-000 Rent And/Or Usage 214,379 214,379 218,954 215,979 215,979 218,004 0.94% 122-60055-045-000 Insurance 9,072 9,072 15,238 18,000 18,000 21,000 16.67% 122-60337-045-000 Transfer to Town/Fire Budget - - - - - 122-69005-045-000 Capital Outlays 7,918 7,918 - - 75,000 48,000 -36.00% 122-69008-045-000 Short Term Debt -Principal - - - - - - 122-69009-045-000 Short Term Debt -Interest - - 14,768 - - - 122-69195-045-000 GASB34/Reserve for Replacement 81,420 81,420 81,420 81,420 81,420 81,420 0.00% 122-69305-045-000 Capital Leases 127,149 127,149 112,381 127,149 127,149 127,149 0.00% Total 1,435,000 1,471,640 1,541,761 1,815,722 1,792,839 1,832,019 2.19% Total Fire Revenues 1,429,416 1,617,362 1,659,193 1,815,722 1,792,839 1,832,019 2.19% Total Fire Expenses 1,435,000 1,471,640 1,541,761 1,815,722 1,792,839 1,832,019 2.19% Net Budget Surplus (Deficit) (5,584) 145,721 117,432 - - - Town/MUD Fire Contract Calculation FY 2020 FY 19 FY 20 Fire Budget 1,792,839 1,832,019 Less: Rent/Debt Service 215,979 218,004 Less: Capital Leases 127,149 127,149 Less: ESD Assessment 500,839 506,789 Less: TML Fire Insurance 18,000 21,000 Less: Capital Outlays 75,000 48,000 Less: GASB34/Reserve for Replacement 81,420 81,420 Less: Denton County Fire Pledge 10,000 10,000 Less: Fire Permits/Sprinkler 90,000 46,000 Less: Grant Proceeds - 55,000 Less: Fire Inspections - - 122-60337-045-000 Transfer to Town from MUD/Fire Budget 674,452 718,657 Monthly payment to Town Oct 18 -Sept 19 56,204 59,888 General Fund Account Description FY 2015 Actual FY 2016 FY 2017 FY 2018 Actual Actual Actuals FY 2019 Adopted FY 2019 Amended 91 FY 2020 Proposed General Fund Revenues 135-40000-000-000 Property Taxes 167,935 57,250 61,008 122,279 132,384 132,384 134,871 135-40002-000-000 Property Taxes/Delinquent 464 2,192 290 347 300 300 300 135-40015-000-000 Property Taxes/P & I 727 746 350 530 300 300 300 135-40025-000-000 PID Surcharges 30,645 146,125 103,619 195,528 171,983 171,983 164,253 135-47000-000-000 Water 3,781,229 4,210,866 5,822,785 6,035,804 6,599,484 6,599,484 6,486,623 135-47005-000-000 Sewer 2,179,235 2,359,115 2,587,176 3,035,824 3,412,665 3,412,665 3,503,885 135-47025-000-000 Penalties 100,639 101,584 121,528 119,594 136,418 136,418 112,608 135-47030-000-000 Service Charges (Disconnect Fees) 10,599 12,850 14,100 13,881 17,000 17,000 15,150 135-47035-000-000 Plumbing Inspections 2,450 2,600 2,400 2,200 1,500 1,500 750 135-47045-000-000 Sewer Inspections 7,350 7,650 4,800 5,800 4,500 4,500 2,500 135-47070-000-000 TCCC Effluent Charges 67,064 45,511 87,159 81,611 60,000 60,000 50,000 135-48010-000-000 Utility Fees 239,200 55,200 - - - - 135-49011-000-000 Interest Income 6,117 12,652 18,940 61,282 20,000 80,000 120,000 135-49016-000-000 Cell Tower Revenue 10,926 10,926 10,926 12,077 14,146 14,146 14,146 135-49018-000-000 Building Rent Income 7,000 7,000 7,000 7,000 7,000 7,000 7,000 135-49026-000-000 Proceeds from Sale of Assets 46,750 30,935 39,899 15,400 10,000 55,000 13,000 135-49035-000-000 Prior Year Reserves - - - 358,600 135-49036-000-000 GASB Reserves 74,706 13,088 - - 266,613 135-49005-000-000 Loan Proceeds - - 360,100 - 135-49075-000-000 Oversize Meter Reimbursement 58,023 51,654 20,864 14,237 18,522 18,522 12,691 135-49141-000-000 Interfund Transfer In - 8,034 797,834 135-49145-000-000 Intergov Transfer In 1,074,337 - - - - - - 135-49900-000-000 Miscellaneous Income 98,675 28,818 (27,448) 16,547 7,000 7,000 7,000 135-49901-000-000 Records Management Revenue 18 44 32 2 135-49903-000-000 Recovery of Prior Year Expense 81,791 - - - 135-00000-000-000 Reimbursement (Total 1 7,964,090 1 7,164,841 1 8,957,220 1 10,897,878 1 10,613,204 1 11,343,417 1 10,645,077 1 Increase % FY19 From FY19 Projections 1.88% 125,564 0.00% (329) 0.00% 553 -4.49% - -1.71% 5,070,552 2.67% 3,112,665 -17.45% 106,418 -10.88% 15,655 -50.00% 1,909 -44.44% 3,927 -16.67% 60,000 0.00% - 500.00% 130,000 0.00% 14,472 0.00% 7,000 30.00% 52,600 0.00% 617,929 0.00% 150,000 0.00% -31.48% 12,620 0.00% 25,000 0.00% 0.00% 20,500 0.00% 4 0.00% 0.00% 0.30%1 9,527,038 Water (General Fund Expenses 135-50005-010-000 Salaries & Wages 135-50010-010-000 Overtime 135-50016-010-000 Longevity 135-50017-010-000 Certification 135-50020-010-000 Retirement 135-50026-010-000 Medical Insurance 135-50027-010-000 Dental Insurance 135-50028-010-000 Vision Insurance 135-50029-010-000 Life Insurance & Other 135-50030-010-000 Social Security Taxes 135-50035-010-000 Medicare Taxes 135-50040-010-000 Unemployment Taxes 135-50045-010-000 Workman's Compensation 135-50060-010-000 Pre-emp Physicals/Testing 135-50070-010-000 Employee Relations 135-55005-010-000 Engineering 135-55080-010-000 Maintenance & Repairs 135-55085-010-000 Generator Maintenance & Repairs 135-55090-010-000 Vehicle Maintenance 135-55105-010-000 Maintenance -Heavy Equipment 135-55120-010-000 Cleaning Services 135-55135-010-000 Lab Analysis - MUD 135-60010-010-000 Communications/Mobiles 135-60020-010-000 Electricity 135-60066-010-000 Publications/Books/Subscripts 135-60070-010-000 Dues & Memberships 135-60080-010-000 Schools & Training 135-60090-010-000 Safety Program 135-60100-010-000 Travel & per diem 135-60105-010-000 Rent/Lease Equipment 135-60135-010-000 TCEQ Fees & Permits - MUD 135-60150-010-000 Wholesale Water 135-60245-010-000 Miscellaneous Expenses 135-60280-010-000 Property Maintenance 135-60285-010-000 Lawn Equipment & Maintenance 135-60332-010-000 Interfund Transfer Out- Revenue I&S 135-60333-010-000 Interfund Transfer Out- Bond Reserve 135-60334-010-000 Interfund Transfer Out -Bank Reserve Account 135-60360-010-000 Furniture/Equipment < $5000 135-65005-010-000 Fuel & Lube 135-65010-010-000 Uniforms 135-65030-010-000 Chemicals 135-65035-010-000 Small Tools 135-65040-010-000 Safety Equipment 135-65050-010-000 Meter Expense 135-65053-010-000 Meter Change Out Program 135-69005-010-000 Capital Outlays 135-69008-010-000 Short Term Debt -Principal 135-69009-010-000 Short Term Debt -Interest 135-69195-010-000 Gasb34/Reserve for Replacement 135-69281-010-000 Water Tank Inspection Contract 135-55135-010-001 Lab Analysis - PID 135-60135-010-001 TCEQ Fees & Permits - PID 1 1 1 221,838 219,077 232,082 245,349 326,755 326,755 350,267 7.20% 306,653 16,318 13,385 13,069 14,433 20,000 20,000 17,000 -15.00% 17,000 2,705 2,945 3,270 3,310 3,620 3,620 3,920 8.29% 3,620 2,725 2,400 2,600 2,425 4,800 4,800 5,400 12.50% 2,200 21,735 20,866 21,489 24,919 33,304 33,304 34,863 4.68% 30,046 36,698 38,990 30,038 32,816 74,818 74,818 84,326 12.71% 49,818 2,927 2,944 2,942 2,589 4,317 4,317 4,725 9.45% 2,982 677 662 578 460 701 701 767 9.52% 488 2,975 2,361 2,576 2,573 3,131 3,131 3,132 0.03% 2,557 14,868 14,627 15,286 16,345 22,021 22,021 23,348 6.03% 18,830 3,477 3,421 3,575 3,823 5,150 5,150 5,461 6.03% 4,404 24 859 51 819 1,080 1,080 1,080 0.00% 51 8,975 12,438 11,864 10,799 12,895 12,895 11,850 -8.10% 10,876 1,037 236 347 285 200 200 400 100.00% 202 192 112 187 178 300 300 300 0.00% 300 1,710 109,670 25,390 - 20,000 20,000 20,000 0.00% - 62,171 84,225 87,258 100,901 100,000 153,000 100,000 0.00% 153,000 - - 2,459 770 3,000 3,000 3,000 0.00% 3,000 7,466 6,229 2,253 5,216 5,000 5,000 5,000 0.00% 5,000 4,417 2,893 35 3,500 3,500 3,500 0.00% 3,500 - 5,214 5,214 1,000 -80.82% 500 4,961 6,389 3,948 7,413 6,500 6,500 7,500 15.38% 8,178 3,997 4,717 4,589 3,973 5,000 5,000 5,000 0.00% 4,000 147,907 150,535 156,752 140,190 154,204 154,204 125,677 -18.50% 114,204 739 716 767 767 1,000 1,000 1,000 0.00% 1,000 - 11 - 500 500 500 0.00% 500 1,353 1,545 936 2,889 4,651 4,651 7,426 59.66% 3,556 - 249 8 400 400 400 0.00% - 240 87 124 87 2,345 2,345 2,845 21.32% 679 379 - - 1,500 1,500 1,500 0.00% 1,500 30,058 17,788 31,064 24,220 58,000 58,000 63,000 8.62% 25,000 2,266,895 2,030,607 2,068,311 2,257,593 3,013,494 3,013,494 2,714,710 -9.91% 1,876,437 - - 103 - 200 200 200 0.00% - 1,583 2,643 775 975 3,000 3,000 3,000 0.00% 1,000 8,250 11,250 14,750 14,750 14,750 0.00% 8,500 - - 240,822 278,084 585,209 585,209 527,381 -9.88% 276,901 - - 48,047 48,996 55,193 55,193 55,193 0.00% 55,193 - - - 200,000 200,000 180,000 -10.00% 200,000 1,823 - 5,020 2,500 2,500 2,500 0.00% 12,517 12,647 8,733 11,489 15,000 15,000 15,000 0.00% 1,100 3,185 2,170 3,064 2,632 5,190 5,190 5,190 0.00% 2,219 10,195 13,070 24,217 18,687 20,000 20,000 20,000 0.00% 22,000 995 868 868 - 1,200 1,200 1,200 0.00% 1,200 457 719 507 1,081 1,000 1,000 1,000 0.00% 1,000 119,269 88,942 24,000 24,976 70,000 70,000 70,000 0.00% 60,000 - 77,325 71,160 82,313 87,000 87,000 87,000 0.00% 86,949 439,705 1,492,504 323,263 488,427 453,000 719,613 684,875 51.19% 1,108,783 129,000 130,700 - 30,068 30,068 30,512 1.48% 30,068 3,632 1,178 - 2,271 4,124 4,124 3,231 -21.67% 4,124 75,000 75,000 75,000 75,000 75,000 75,000 75,000 0.00% 75,000 126,958 126,958 126,958 107,864 120,000 120,000 120,000 0.00% 99,877 3,046 1,725 2,183 1,753 2,000 2,000 2,000 0.00% 2,000 0.00% - 1 Subtotal Water 3,796,451 1 4,777,813 1 3,681,756 1 4,066,003 1 5,641,836 1 5,961,449 1 5,506,929 1 -2.39%1 4,685,996 General Fund Account Description FY 2015 Actual FY 2016 Actual FY 2017 Actual FY 2018 Actuals FY 2019 Adopted FY 2019 Amended 81 FY 2020 Proposed Increase % From FY19 FY19 Projections Wastewater 135-50005-020-000 135-50010-020-000 135-50016-020-000 135-50017-020-000 135-50020-020-000 135-50026-020-000 135-50027-020-000 135-50028-020-000 135-50029-020-000 135-50030-020-000 135-50035-020-000 135-50040-020-000 135-50045-020-000 135-50060-020-000 135-50070-020-000 135-55005-020-000 135-55070-020-000 135-55080-020-000 135-55081-020-000 135-55085-020-000 135-55090-020-000 135-55091-020-000 135-55105-020-000 135-55120-020-000 135-55125-020-000 135-55135-020-000 135-60010-020-000 135-60020-020-000 135-60066-020-000 135-60070-020-000 135-60080-020-000 135-60090-020-000 135-60100-020-000 135-60105-020-000 135-60125-020-000 135-60135-020-000 135-60245-020-000 135-60280-020-000 135-60285-020-000 135-60331-020-000 135-60332-020-000 135-60333-020-000 135-60334-020-000 135-60360-020-000 135-65005-020-000 135-65010-020-000 135-65030-020-000 135-65031-020-000 135-65035-020-000 135-65040-020-000 135-65045-020-000 135-69005-020-000 135-69008-020-000 135-69009-020-000 135-69195-020-000 135-70020-020 Salaries & Wages Overtime Longevity Certification Retirement Medical Insurance Dental Insurance Vision Insurance Life Insurance & Other Social Security Taxes Medicare Taxes Unemployment Taxes Workman's Compensation Pre-emp Physicals/Testing Employee Relations Engineering Independent Labor Maintenance & Repairs Maintenance & Repairs- Collections Generator Maintenance & Repairs Vehicle Maintenance Vehicle Maintenance- Collections Maintenance -Heavy Equipment Cleaning Services Dumpster Services Lab Analysis Communications/Pagers/Mobiles Electricity Publications/Books/Subscripts Dues & Memberships Schools & Training Safety Program Travel & per diem Rent/Lease Equipment Advertising TCEQ Fees & Permits Miscellaneous Expenses Property Maintenance Lawn Equipment & Maintenance Interfund Transfer Out -Tax I&S Interfund Transfer Out- Revenue I&S Interfund Transfer Out -Bond Reserve Interfund Transfer Out -Bank Reserve Account Furniture/Equipment < $5000 Fuel & Lube Uniforms Chemicals Chemicals- Collections Small Tools Safety Equipment Lab Supplies Capital Outlays Short Term Debt -Principal Short Term Debt -Interest Gasb34/Reserve for Replacement Capital Lease Issuance Cost 'Subtotal Wastewater 305,552 369,462 387,947 362,490 421,699 421,699 441,799 4.77% 348,267 27,622 35,175 31,979 37,047 30,000 30,000 33,000 10.00% 33,000 5,615 6,125 6,635 7,415 7,445 7,445 8,035 7.92% 7,445 6,600 7,611 8,275 8,436 8,700 8,700 9,000 3.45% 8,564 30,826 36,694 38,208 38,361 43,276 43,276 45,531 5.21% 37,255 57,602 66,679 55,136 65,584 91,627 91,627 104,858 14.44% 67,627 3,682 4,119 4,464 4,692 5,104 5,104 5,817 13.99% 4,189 853 930 954 803 826 826 948 14.78% 678 4,399 4,116 4,552 4,205 4,495 4,495 4,500 0.11% 4,011 19,403 23,597 25,343 23,764 29,006 29,006 30,494 5.13% 22,519 4,523 5,519 5,927 5,558 6,784 6,784 7,132 5.13% 5,267 14 1,204 63 1,134 1,260 1,260 1,260 0.00% 59 8,975 7,003 14,903 16,176 16,941 16,941 15,373 -9.25% 14,087 189 238 80 273 400 400 400 0.00% 114 523 722 461 300 300 300 0.00% 76 - - 852 - 30,000 30,000 30,000 0.00% - - 27,109 19,449 2,145 15,000 15,000 15,000 0.00% 5,000 96,664 173,132 97,990 74,141 88,000 133,000 88,000 0.00% 133,000 - - - - - - 10,000 0.00% - - - 6,076 1,595 10,000 10,000 10,000 0.00% 7,500 3,540 7,165 9,836 9,572 8,000 8,000 4,000 -50.00% 3,500 - - - - - - 8,000 0.00% - 803 742 24 395 1,500 7,000 3,000 100.00% 7,925 - 5,214 5,214 1,500 -71.23% 88 48,977 41,801 56,329 68,016 75,000 75,000 100,000 33.33% 75,000 26,355 37,393 32,416 31,558 35,000 35,000 40,000 14.29% 32,820 5,274 5,888 5,460 4,844 5,000 5,000 5,000 0.00% 4,969 136,622 131,275 145,449 161,571 174,165 174,165 160,067 -8.09% 154,165 135 - 150 - 200 200 200 0.00% 200 307 300 267 60 300 300 300 0.00% 300 1,526 3,361 2,959 658 7,155 7,155 4,991 -30.24% 7,155 - 341 291 352 1,000 1,000 1,000 0.00% 1,000 2,257 977 2,625 90 1,895 1,895 1,545 -18.47% 1,895 1 8,639 - - 5,000 5,000 5,000 0.00% 5,000 - - 4,086 - 2,500 2,500 2,500 0.00% 2,500 9,019 18,527 32,564 30,273 30,000 30,000 15,000 -50.00% 30,000 19 423 113 0 450 450 450 0.00% 450 - - - 274 5,000 5,000 5,000 0.00% 5,000 785 - 6,490 8,730 11,600 11,600 14,000 20.69% 11,600 30,645 119,706 120,492 122,043 120,053 120,053 114,563 -4.57% 120,053 136,989 444,838 595,638 598,738 688,330 688,330 673,867 -2.10% 596,330 71,946 123,336 - 123,336 125,187 125,187 125,187 0.00% 125,187 - - 180,417 - 200,000 200,000 180,000 -10.00% 200,000 - - - 1,762 3,500 3,500 2,000 -42.86% 3,500 17,164 10,253 8,722 9,009 12,500 12,500 12,500 0.00% 12,500 2,598 4,142 3,754 2,930 5,495 5,495 5,495 0.00% 2,713 21,409 28,882 25,101 19,716 30,000 30,000 20,000 -33.33% 33,000 - - - - - - 17,500 0.00% - 1,504 1,787 2,191 1,436 1,200 1,200 1,200 0.00% 1,200 626 577 517 1,158 1,200 1,200 1,200 0.00% 1,750 12,341 17,349 13,258 20,748 20,000 20,000 20,000 0.00% 20,000 196,760 188,556 276,328 128,991 330,000 688,600 530,500 60.76% 735,822 56,991 21,277 - - 109,858 109,858 79,133 -27.97% 58,934 1,952 197 - 3,011 14,917 14,917 11,277 -24.40% 9,233 - - - 30,000 30,000 30,000 130,000 333.33% 30,000 - - - 1,500 - 0.00% 1,500 1,359,587 1 1,957,167 1 2,234,770 I 2,034,586 1 2,872,082 1 3,281,182 1 3,157,421 1 9.93%1 2,993,946 Board of Directors 135-50005-026-000 Salaries & Wages 14,900 9,100 - - - - - 0.00% - 135-50030-026-000 Social Security Taxes 924 564 - - - - - 0.00% - 135-50035-026-000 Medicare Taxes 216 132 - - - - - 0.00% - 135-55040-026-000 Unemployment Taxes 67 2 - - - - - 0.00% - 135-50045-026-000 Workman's Compensation 35 50 30 29 30 30 30 0.00% 30 135-60066-026-000 Publications/Books/Subscripts - - - - 150 150 150 0.00% - 135-60070-026-000 Dues & Memberships 35 11 - 650 750 750 750 0.00% 650 135-60075-026-000 Meetings 276 474 145 135 1,300 1,300 1,300 0.00% 200 135-60080-026-000 Schools & Training 2,950 1,875 3,557 2,755 4,000 4,000 4,000 0.00% 920 135-60100-026-000 Travel & per diem 3,479 3,314 2,690 4,768 5,000 5,000 5,000 0.00% 800 135-60245-026-000 Miscellaneous Expenses 1,659 260 75 1,474 2,000 2,000 2,000 0.00% - 'Subtotal Board of Directors 1 24,541 1 15,782 1 6,498 1 9,811 1 13,230 1 13,230 1 13,230 1 0.00%I 2,600 General Fund Account Description FY 2015 Actual FY 2016 Actual FY 2017 Actual FY 2018 Actuals FY 2019 Adopted FY 2019 Amended 81 FY 2020 Proposed Increase % From FY19 FY19 Projections Administration 1 135-50005-030-000 Salaries & Wages 135-50010-030-000 Overtime 135-50016-030-000 Longevity 135-50020-030-000 Retirement 135-50026-030-000 Medical Insurance 135-50027-030-000 Dental Insurance 135-50028-030-000 Vision Insurance 135-50029-030-000 Life Insurance & Other 135-50030-030-000 Social Security Taxes 135-50035-030-000 Medicare Taxes 135-50040-030-000 Unemployment Taxes 135-50045-030-000 Workman's Compensation 135-50060-030-000 Pre-emp Physicals/Testing 135-50070-030-000 Employee Relations 135-55005-030-000 Engineering 135-55030-030-000 Software & Support 135-55045-030-000 Legal 135-55070-030-000 Independent Labor 135-55080-030-000 Maintenance & Repairs 135-55085-030-000 Generator Maintenance & Repairs 135-55100-030-000 Building Maint & Supplies 135-55120-030-000 Cleaning Services 135-55160-030-000 Professional Outside Services 135-55165-030-000 Collection Fees 135-55205-030-000 Utility Billing Contract 135-60005-030-000 Telephone 135-60010-030-000 Communications/Mobiles 135-60020-030-000 Electricity 135-60025-030-000 Water 135-60035-030-000 Postage 135-60040-030-000 Bank Service Charges & Fees 135-60050-030-000 Bad Debt Expense 135-60055-030-000 Insurance 135-60066-030-000 Publications/Books/Subscripts 135-60070-030-000 Dues & Memberships 135-60075-030-000 Meetings 135-60079-030-000 Public Education 135-60080-030-000 Schools & Training 135-60100-030-000 Travel & per diem 135-60110-030-000 Physicals/Testing 135-60115-030-000 Elections 135-60125-030-000 Advertising 135-60235-030-000 Security 135-60245-030-000 Miscellaneous Expenses 135-60246-030-000 General Manager Contingency 135-60270-030-000 4th of July Celebration 135-60285-030-000 Lawn Equipment & Maintenance 135-60336-030-000 Interfund Trans Out (MUD1 I&5) 135-60360-030-000 Furniture/Equipment < $5000 135-65010-030-000 Uniforms 135-65055-030-000 Hardware IT 135-65085-030-000 Office Supplies 135-65090-030-000 Printer Supplies & Maintenance 135-65095-030-000 Maintenance Supplies 135-65105-030-000 Printing 135-69005-030-000 Capital Outlays 135-69170-030-000 Copier Lease Installments 11 ll 464,345 484,728 432,978 383,692 441,006 441,006 628,298 42.47% 374,007 608 901 3,498 566 2,000 2,000 2,000 0.00% 63 3,283 3,823 3,418 3,548 1,833 1,833 2,208 20.46% 1,833 41,787 42,642 37,687 36,819 41,148 41,148 58,554 42.30% 34,886 61,099 61,243 44,204 49,850 81,895 81,895 124,394 51.90% 61,895 3,754 4,207 3,938 3,277 4,291 4,291 6,464 50.64% 3,331 1,012 975 842 590 701 701 1,035 47.58% 533 5,203 4,678 4,426 3,735 4,495 4,495 4,500 0.11% 3,643 27,363 28,227 25,994 23,075 27,580 27,580 39,215 42.19% 21,309 6,399 6,601 6,079 5,397 6,450 6,450 9,171 42.19% 4,984 144 1,349 294 1,146 1,260 1,260 1,440 14.29% 65 1,048 2,067 1,796 1,482 1,295 1,295 1,775 37.06% 1,295 38 147 701 212 500 500 500 0.00% 180 2,796 3,421 2,692 4,351 5,000 5,000 8,000 60.00% 5,000 - 4,365 - - - - - 0.00% - 112,750 47,907 88,943 68,007 77,849 77,849 134,681 73.00% 65,000 0.00% - 57,935 1,806 30,925 153,669 175,000 175,000 135,000 -22.86% 155,000 535 6,284 826 10,584 20,000 20,000 15,000 -25.00% 20,000 6,368 - 485 5,205 10,000 10,000 10,000 0.00% 5,000 7,530 6,890 7,705 - - - - 0.00% - 22,602 7,017 6,705 10,046 10,000 10,000 10,000 0.00% 9,481 26,170 69,683 63,965 62,300 66,055 66,055 65,600 -0.69% 68,964 0.00% - 7,872 8,516 7,514 7,063 9,000 9,000 9,000 0.00% 6,329 11,851 13,723 14,081 18,246 23,500 23,500 23,680 0.77% 23,500 4,053 4,041 3,621 2,986 4,000 4,000 4,000 0.00% 2,851 11,326 7,245 11,002 6,591 8,690 8,690 6,879 -20.84% 6,728 922 934 1,041 719 2,000 2,000 1,500 -25.00% 1,000 31,693 27,203 27,334 21,120 30,000 30,000 30,000 0.00% 24,000 45,820 51,500 52,782 62,356 55,560 55,560 67,000 20.59% 67,560 1,712 3,459 1,674 - 1,500 1,500 1,500 0.00% - 49,110 33,573 59,614 76,999 65,000 65,000 84,000 29.23% 75,633 1,225 260 770 360 1,000 1,000 1,000 0.00% - 4,558 5,656 4,851 3,988 6,000 6,000 6,000 0.00% 4,269 60 163 122 134 400 400 400 0.00% 400 3,385 4,230 4,972 - 6,000 6,000 6,000 0.00% 1,500 2,938 3,382 2,255 3,238 8,950 8,950 6,850 -23.46% 1,172 2,018 3,562 7,112 1,677 4,345 4,345 3,545 -18.41% 149 - - - - 200 200 200 0.00% 1,289 3,610 2,961 220 - - - 0.00% 6,983 1,549 2,323 925 25,000 25,000 2,500 -90.00% 60 - - 442 1,288 1,288 1,288 0.00% 1,288 10,801 5,448 503 169 500 500 500 0.00% 500 - 17,000 17,000 17,000 17,000 0.00% 10,000 - - - - - - 0.00% - - - - - - - 0.00% 14,000 - - - - - - 0.00% 6,339 656 1,056 212 2,500 2,500 2,500 0.00% 240 1,043 23 475 747 2,050 2,050 2,050 0.00% - 35,172 7,238 2,300 6,802 7,064 7,064 26,485 274.93% 6,000 8,145 5,632 5,353 5,331 6,000 6,000 6,000 0.00% 6,994 2,870 1,302 754 2,365 3,500 3,500 3,500 0.00% 4,461 3,632 3,985 4,199 4,000 4,000 4,000 0.00% 4,888 1,333 3,232 2,593 144 2,500 2,500 2,500 0.00% 61,822 24,907 129,301 48,355 280,000 280,000 195,000 -30.36% 204,887 3,485 3,888 3,929 3,231 4,000 4,000 4,000 0.00% 4,000 1Subtotal Administration 1,199,115 1,017,525 1,122,380 1,123,167 1,559,904 1,559,905 1,776,712 13.90% 1,280,356 Non Departmental 135-55045-039-000 Legal 495,151 338,721 118,762 151,171 137,000 137,000 135,000 -1.46% 135,000 1135-55055-039-000 Auditing 16,836 29,039 18,809 25,659 30,800 30,800 33,800 9.74% 26,4601 1135-55060-039-000 Appraisal 9,846 10,088 10,713 10,696 11,714 11,714 11,761 0.40% 11,3001 135-55065-039-000 Tax Admin Fees 2,456 2,469 2,562 2,968 4,800 4,800 4,000 -16.67% 3,653 Subtotal Non Departmental 524,289 380,317 150,846 190 184,314 184,314 184,561 0.13% 176,413 Total General Fund Revenues 7,964,090 7,164,841 8,957,220 10,897,878 _ 10,613,204 11,343,417 10,645,077 0.30% 9,527,038 1 Total General Fund Expenses 6,903,983 8,178,604 7,196,250 7,424,061 10,271,366 11,000,080 10,638,854 3.58% 9,139,311 1 Net Budget Surplus (Deficit) 1,060,107 (1,013,763) 1,760,970 3,473,817 341,837 343,337 6,223 387,727 1 MUD/PID Paid 1 Par Principal FY20 Interest 3/01 Interest 9/01 1 Subtotal Interest Paying Agent Fee 1 Total 1 Maturity Date 1 First Callable Date Project/Reason TAX DEBT PAYMENTS LONG TERM TAX DEBT LONG TERM REVENUE DEBT MUD/PID Paid Par REVENUE DEBT PAYMENTS Principal FY 20 1 Interest 3/01 1 Interest 9/01 Subtotal Interest 1 Paying Agent Fee 1 Total 1 Maturity Date 1 First Callable Date Project/Reason Series 2015 (Revenue) WWTP $9,230,000 $390,000 $104,119 $104,119 $208,238 $400 $598,638 9/1/2035 9/1/2025 Trophy Club Fire Station and costs related to Series 2010 (Tax) MUD $2,000,000 $90,000 $29,954 $29,954 $59,908 $750 $150,658 9/1/2031 9/1/2020 the issuance of the Bonds. Camera Van $205,504 $38,687 $3,686 $3,308 56,995 $45,681 2/1/2024 Replacement Refund MUD #2 Unlimited Tax Bonds, 2002 and costs related to the issuance of the Series 2012 (Tax) MUD $2,355,000 $225,000 $14,175 $14,175 $28,350 $500 $253,850 9/1/2023 9/1/2020 Bonds. TOTAL ALL REVENUE BONDS: $20,945,000 $605,000 $349,074 $245,975 $595,049 $1,200 51,201,249 Refund MUD #2 Unlimited Tax Bonds Series 2003 and MUD #2 Unlimited Tax Refunding Bonds Series 2005 and costs related to the Series 2013 (Tax) MUD $1,905,000 $195,000 $12,913 $12,913 $25,825 $500 $221,325 9/1/2023 9/1/2023 issuance of the Bonds. SUBTOTAL MUD -ONLY TAX BONDS: $6,260,000 $510,000 $57,041 $57,041 $114,083 $1,750 $625,833 Tax Bonds for Wastewater Plant Expansion Series 2014 (Tax) MUD/PID $5,765,000 $255,000 $66,888 $66,888 $133,775 $400 $389,175 9/1/2034 9/1/2024 Issued 10/1/2014 SUBTOTAL ALL MUD/PID TAX BONDS: $5,765,000 $255,000 $66,888 $66,888 $133,775 $400 $389,175 TOTAL ALL TAX BONDS: $12,025,000 $765,000 $123,929 $123,929 $247,858 $2,150 $1,015,008 TAX DEBT PAYMENTS LONG TERM TAX DEBT LONG TERM REVENUE DEBT MUD/PID Paid Par REVENUE DEBT PAYMENTS Principal FY 20 1 Interest 3/01 1 Interest 9/01 Subtotal Interest 1 Paying Agent Fee 1 Total 1 Maturity Date 1 First Callable Date Project/Reason Series 2015 (Revenue) WWTP $9,230,000 $390,000 $104,119 $104,119 $208,238 $400 $598,638 9/1/2035 9/1/2025 Revenue Bonds for WWTP Expansion Series 2016 (Revenue) SWIFT $4,635,000 $215,000 $30,063 $30,063 $60,125 $400 $275,525 9/1/2036 9/1/2027 Revenue Bonds for Fort Worth Line NSII Camera Van $205,504 $38,687 $3,686 $3,308 56,995 $45,681 2/1/2024 Replacement Revenue Bonds for 16in Water Line (77%) and Series 2019 (Revenue) Water & Waste Water Systems $565,604 $7,080,000 $0 $214,892 $111,794 $326,686 $400 $327,086 9/1/2049 9/1/2028 Overrun for WWTP Expansion (23%) TOTAL ALL REVENUE BONDS: $20,945,000 $605,000 $349,074 $245,975 $595,049 $1,200 51,201,249 SHORT TERM REVENUE DEBT CAPITAL LEASE PAYMENTS MUD/PID Paid Original PAR Principal FY 20 Interest 2/01 Interest 8/01 Subtotal Interest Total Payoff Date Project/Reason Department Vaccon Truck (Water usage 43%) $154,843 530,512 $1,840 51,390 $3,231 $33,743 2/1/2023 Replacement Water Vaccon Truck (WW usage 57%) $205,257 $40,446 $2,440 $1,843 $4,283 $44,729 2/1/2023 Replacement Wastewater Camera Van $205,504 $38,687 $3,686 $3,308 56,995 $45,681 2/1/2024 Replacement Wastewater Total: $565,604 5109,641 $7,966 56,542 $14,508 $124,153 .57,5(10,000.00 S7,I1SMl,f H10.IX7 51,500,000.00 $1,0 00,01)0.00 ,000.00 S:, W.000.0 U 5 Annual Long -Term Debt Payments M1 W&S Rev SCR CS 2011 {$7,080,000} M1 VMS Rry SFR FS 2016 {5.1,615,0()0) ■ M1 W&SS Rev SERIES 2015 (59,230,000) • M1 UT SCRICS 2011 ($5,765,000) M1 UTR SERIES 2013 ($1,910,000) • MI. GO SERIES 2012 (52,355,000) • M1 GO StRItS 2010 (S2.WU,WU) I .^.0 ^�yY 4:1 '14 .14 ^Oca 1Oto 44\ 4 61 % 4:9" $' •43; ,14 y'O53 4, ^4> 43/P 4, X054 ^O9 4) 4'1 - 4' 4. 4' 424910'4 ^9p"o 4' $300,000.00 $250,000.00 $200,000.00 $150,000.00 $100,000.00 $50,000.00 $- Annual Capital Lease Payments 2020 2021 2022 2023 2024 • LADDER TRUCK LEASE 2015 ($1,057,316) ■ VAC TRUCK LEASE 2018 ($360,100.40) CAMERA VAN LEASE 2019 ($210,000) CAPITAL OUTLAYS Category FY 19-20 I FY 20-21 I FY 21-22 I FY 22-23 I FY 23-24 Notes Water Water System Improvements Wastewater System Improvements Quick Connects Fire Hydrants $ 5,000 $ 5,250 $ 5,513 $ 5,788 $ 6,078 Work with FD- $200 Each Beacon Meter Software $ 9,000 $ 10,000 Yearly Upgrades/Improvements Lift Station Pumps $ 20,000 Additional Funding Needed Valve Replacement/Addition $ 50,000 $ 52,500 $ 55,125 $ 57,881 $ 60,775 Yearly Change Out Engineer Master Plan of Improvements $ - $ 50,000 $ - $ - $ - Engineer Master Plan of Improvements Water Line Replacement $ 500,000 $ 525,000 $ 551,250 $ 578,813 $ 607,753 Water Line Replacement 20' Line Stops and Gate Valves $ 69,875 $ - $ - $ - $ - Replace existing Totals $ 633,875 $ 632,750 $ 611,888 $ 642,482 $ 674,606 $ - Town/MUD Joint $ - $ - Belt Press Belt Telemetry Upgrades $ 30,000 $ - $ - $ - $ - $ - $ 30,000 Totals $ - $ - $ - $ - $ - $ 50,000 Building Maintenance $ - $ - Engineer Master Plan of Improvements WWTP Legal $ 150,000 $ - Fencing $ 10,000 $ 10,000 $ 10,000 $ 10,000 $ 10,000 Yearly Upgrades/Improvements Totals $ 10,000 $ 10,000 $ 10,000 $ 10,000 $ 10,000 $ 110,000 Fleet $ 30,000 $ 30,000 Building Maintenance $ - $ - Fleet Replacement $ 41,000 $ - $ 41,000 $ - $ - Bert's Truck Replacement Totals $ 41,000 $ - $ 41,000 $ - $ 41,000 $ - Contingency For Carryover $ - $ - Replace WWTP Fence Manhole Rehab and Replacement $ 22,500 $ 7,500 Totals $ - $ - $ - $ - $ - $ - Water Grand Totals $ 684,875 $ 642,750 $ 662,888 $ 652,482 $ 725,606 $ 12,500 WASTEWATER Wastewater System Improvements LS Upgrades (Lights, Control Panels, Quick Connects) $ 50,000 $ 10,000 $ 10,000 $ 10,000 $ 10,000 Yearly Upgrades/Improvements Lift Station Pumps $ 20,000 $ 20,000 $ 20,000 $ 20,000 $ 20,000 Yearly Upgrades/Improvements Lift Station #1 Upgrade $ 30,000 $ - $ - $ - $ - Upgrade and Easements Spare Part Inventory $ 25,000 $ - $ - $ - $ - Return Meter, Eff Meter Blower Curtains $ 13,000 $ - $ - $ - $ - Blower Curtains Hose Upgrades MBR $ 5,000 $ - $ - $ - $ - Hose Upgrades MBR Belt Press Belt $ 5,000 $ - $ - $ - $ - Belt Press Belt Telemetry Upgrades $ 30,000 UV, Digester, Belt Press Smart Cover Manhole $ - $ 30,000 $ - $ - $ - Study and Install Engineer Master Plan of Improvements $ - $ 50,000 $ - $ - $ - Engineer Master Plan of Improvements WWTP Legal $ 150,000 $ - $ - $ - $ - WWTP Legal- Litigation Totals $ 70,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 Totals $ 328,000 $ 110,000 $ 30,000 $ 30,000 $ 30,000 Building Maintenance $ - $ - $ - $ - $ - Lift Station Fencing $ 5,000 $ 5,000 $ 5,000 $ 5,000 $ - LS Fence Yearly Change Out WWTP Fencing Replacement $ 50,000 $ - $ - $ - $ - Replace WWTP Fence Manhole Rehab and Replacement $ 22,500 $ 7,500 $ 7,500 $ 7,500 $ 7,500 Emergency Replacement Paving Road and Driveway WWTP $ 125,000 $ - $ - $ - $ - Depends on Town Ownership of Road Totals $ 202,500 $ 12,500 $ 12,500 $ 12,500 $ 7,500 Fleet $ - $ - $ - $ 35,000 $ 35,000 Future Fleet Truck Replacement Totals $ - $ - $ - $ 35,000 $ 35,000 Contingency For Carryover Totals $ - $ - $ - $ - $ - Wastewater Grand Totals $ 530,500 $ 122,500 $ 42,500 $ 77,500 $ 72,500 ADMIN Information Technology Improvements Board Room Upgrade $ 100,000 $ - $ - $ - $ - Audio and Video Equipment Security Phase III $ 25,000 $ - $ - $ - $ - Water, WWTP, and Admin Phase III $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - Totals $ 125,000 $ - $ - $ - $ - Building & Property Maintenance Building Maintenance $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 Additional Building Needs Pavement and Driveway Repair $ 20,000 $ - $ - $ - $ - Parking and Driveway Repair $ - $ - $ - $ - $ - Totals $ 70,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 Contingency For Carryover Totals $ - $ - $ - $ - $ - Admin Grand Totals $ 195,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 AVG METERS AS OF COMPLETED LAST THREE FISCAL YEARS AVG WATER USE OF COMPLETED LAST THREE FISCAL YEARS PROJECTED FORT WORTH WATER COST ANNUALIZE GROWTH IN WATER METERS = 0.00% PROJECTED NO. OF ACTIVE METERS ON OCT. 1, 2020 = ITEM NO. MONTH PROJECTED EOM AND AVERAGE ANNUAL NO. OF WATER METERS 4643 97,481,333 1 OCT 4,768 4645 63,329,667 2 NOV 4,768 4659 45,259,667 3 DEC 4,768 4658 39,394,667 4 JAN 4,768 4666 44,327,333 5 FEB 4,768 4681 57,950,000 6 MAR 4,768 4683 61,957,000 7 APR 4,768 4704 79,736,667 8 MAY 4,768 4730 105,852,000 9 JUN 4,768 4717 128, 605,333 10 J U L 4,768 4722 132,781,333 11 AUG 4,768 4715 102,654,000 12 SEP 4,768 AVERAGE TOTAL CALCULATED AVERAGE WATER USE PER METER PER MONTH = PROJECTED TOTAL NO. OF NEW RETAIL METERS IN FY20 = PROJECTED TOTAL OF ADDITIONAL GALLONS IN FY20 = 4,768 AVERAGE WATER USE PER METER FOR THE LAST 3 COMPLETE FISCAL YEARS (GALLONS) 20,994 13,634 9,714 8,457 9,499 12,381 13,229 16,951 22,377 27,264 28,120 21,770 PROJECTED MONTHY WATER USE (GALLONS) 100,098,564 65,006,642 46,315,229 40,324,983 45,293,105 59,031,249 63,077,077 80,821,519 106,694,878 129,995,809 134,074,841 103,800,567 4,768 17,033 974,534,461 (GALS/METER/MN) (METERS) (GALLONS) 17,033 0 0 Growth is significantly flat as build out approaches 0% recommended Purchased Water Expense (Projected Fort Worth Costs) Out of District Volumetric Charge Per 1000 Gallons Rate of Use Charge Monthly Increase Monthly Rate of Use Charge- Projected True Up Service Charge Monthly Purchased Water (gallons): 974,534,461 $2.23 $2,177,890 $34,710.00 $416,520 $10,000.00 $120,000 $25 $300 Total: 1 $2,714,710 Water Use History and Projections Gallons in Thousands 1,000,000 .\/) 900,000 —. 800,000 700,000 600,000 500,000 400,000 300,000 200,000 100,000 0 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 Consumption in gallons Years Number of Connections per Year 60000 55000 50000 45000 40000 35000 30000 25000 20000 15000 10000 5000 0 Total Connections by Year 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 Years Revenue in Thousands $7,000.00 $6,000.00 $5,000.00 $4,000.00 $3,000.00 $2,000.00 $1,000.00 $- Revenue by Year 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 Years Consumtipon per Connection 21000 19500 18000 16500 15000 13500 12000 10500 9000 7500 6000 4500 3000 1500 0 Consumption per Connection by Year 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 Years Rates PROJECTED WASTEWATER REVENUE Minimum Charge All Meter Sizes Residential (Winter Average) Commercial Total $20.60 $20.60 Volumetric Charge (000's) 0-4,000 $3.80 4,001-8,000 $5.40 8,001-12,000 $7.65 12,000+ $10.90 Commercial $6.37 Billing Determinants Annual # of Meters 53,262 1,428 54,690 Volumes (000's) 0 -4,000 gallons 188,646 188,646 4,001 - 8,000 gallons 89,454 89,454 8,001- 12,000 gallons 30,534 30,534 > 12,001 gallons 29,250 29,250 337,884 337,884 Commercial (000's) 98,109 98,109 Projected Revenue Meter Charge Revenue $1,097,197 $29,417 $1,126,614 Residential 0 -4,000 gallons $716,855 $716,855 4,001 - 8,000 gallons $483,052 $483,052 8,001 - 12,000 gallons $233,585 $233,585 > 12,001 gallons $318,825 $318,825 Subtotal $1,752,317 $0 $1,752,317 Commercial $624,954 $624,954 Total Revenue $2,849,514 $654,371 $3,503,885 Account 135-55160-030 Professional Outside Services 135-55030-030 Software & Support INFORMATION TECHNOLOGY Description Description M3- It & Cell Phone Support, includes Mobile Client Totals: Amount I $ 58,750 58,750 Description Used R For Recurring, NR For Non -Recurring. R -Internet Connectivity- Charter Spectrum $ 12,000 R -Internet Connectivity -ATT (Backup & WWTP) $ 2,000 R -Internet Connectivity -Pump Room at Water Plant/SCADA $ 1,000 R- M3- Microft Office 365 Licenses $ 6,200 R-STW-Annual Support, Annual Lease, & Report Coding $ 29,000 R -Clear Rec Annual Maintenance $ 600 R- Peak Agenda Management $ 3,465 R -Web Hosting $ 500 R -Web Maintenance (Domains, SSL Cert, etc) $ 116 R -Mail Chimp $ 240 R -Photoshop $ 120 R- Adobe Licenses/Support $ 600 R- Timeclock Plus License and Support $ 1,500 R- MCCI Annual Support Online Records $ 5,200 R -Annual Support for Website -Four Man Furnace $ 2,000 R -Automatic Meter Reading -Badger $ 2,500 R-Pipelogix Maintenance $ 1,980 R-AudioTel Remit Plus Annual Support $ 1,975 R-AudioTel Annual Scanner Support $ 585 R-SCADA Support (Includes Win -911) $ 1,000 R- Onsolve Intermediate Holding (Code Red) $ 4,000 R- Budget Software $ 30,100 R- Hippo CMMS System $ 3,000 R- GIS Year Subscription and Annual Software Support $ 25,000 NR- VMWare Software & Support (3 yrs support) $ - Totals: $ 134,681 135-60005-030 Description Telephone R- Main Phone Numbers & Long Distance $ 10,500 R- Afterhours answering service $ 2,500 R- WWTP Phone Service (LS + 4 temp ofc phones) $ 8,000 R -E -Fax $ 180 Phone System Maintenance/Replacement $ 1,500 Repairs (Non -Maintenance) $ 1,000 Totals: $ 23,680 135-60235-030 Security Description R- Monitoring Service R -Access Control System (Cards, Fobs, Print Supplies) Totals: 288 1,000 $ 1,288 135-65055-030 Description Qty Per Item Amount Hardware R-A/V Miscellaneous Equipment 0 $ - $ - WIFI(MUD &Public) 0 $ - $ - Replacement Hardware: Dell Laptop 2 $ 1,869 $ 3,738 Dell Docking Station 1 $ 179 $ 179 Dell 22" Monitor 4 $ 200 $ 800 Dell Monitor Stand 1 $ 189 $ 189 Dell Desktop 2 $ 1,000 $ 2,000 Keyboard/Mouse combo 1 $ 79 $ 79 Network SAN ( Warranty Renewal) 1 $ 6,500 $ 6,500 Server Rotation 1 $ 13,000 $ 13,000 Printers 0 $ 300 $ - Totals: $ 26,485 135-65105030 Description Printing Events or Special Mailers $ 2,500 Totals: $ 2,500 135-65090-030 Printer Supplies Description Toner and Cartridges $ 3,500 Totals: $ 3,500 135-69170-030 Copier Rental/Lease Description Copier Lease $ 4,000 Totals: $ 4,000 Grand Total: $ 254,884