Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
06-17-21 Town Council Agenda Packet
TOWN OF WESTLAKE TOWN COUNCIL MEETING AGENDA 1500 SOLANA BLVD, BUILDING 1, SUITE 1100, ��Westlake Conference Room" WESTLAKE, TX 76262 r x E r o w N o F �une 17� 2021 8:30 A.M. MEETING WESTLAKE In accordance with Order of the Office of the Governor issued March 16, 2020 and March 19, 2020, the Town Council of the Town of Westlake conduct a meeting and planning work session at 8:30 a.m. on Thursday, June 17, 2021. In order to advance the public health goal of promoting "social distancing" to slow the spread of the Coronavirus (COVID-19), there will be limited public access to the physical location described above. Limited seating will be available to the public on a first- come, first-serve basis. A recording of this meeting will be made and will be available to the public in accordance with the Open Meetings Act. �ision Statement An oasis ofnatural beauty that maintains our open spaces in ba/ance with distinctive deve%pment, trai/s, and quality of life amenities amidst an e ver expanding urban landscape. Regular Session 1. CALL TO ORDER. 2. DISCUSSION REGARDING KEY STRATEGIC INIAIATIVES AND VISION GOVERNANCE FOR THE FUTURE. 3. PRESENTATION AND DISCUSSION REGARDING PROPOSED FY 21/22 MUNICIPAL AND ACADEMIC BUDGETS, THE FIVE-(5) YEAR CAPITAL IMPROVEMENT PLAN AND POSSIBLE DEBT ISSUANCE TO FUND PROJECTS WITHIN THE CIP. 4. COUNCIL RECAP / STAFF DIRECTION. 5. AD]OURNMENT. ANY ITEM ON THIS POSTED AGENDA COULD BE DISCUSSED IN EXECUTIVE SESSION AS LONG AS IT IS WITHIN ONE OF THE PERMITTED CATEGORIES UNDER SECTIONS 551.071 THROUGH 551.076 AND SECTION 551.087 OF THE TEXAS GOVERNMENT CODE. CERTIFICATION I certify that the above notice was posted at the Town Hall of the Town of Westlake, 1500 Solana Blvd., Building 7, Suite 7100, Westlake, TX 76262, June 14, 2021, by 7:00 a.m. under the Open Meetings Act, Chapter 551 of the Texas Government Code. Todd Wood, Town Secretary If you plan to attend this public meeting and have a disability that requires special needs, please advise the Town Secretary's Office 48 hours in advance at 817-490-5711 and reasonable accommodations will be made to assist you. TC Agenda-06/17/21 Page 1 of 1 FY 2021 - 2022 . , , . . ..., , . _ . . _ . _. �a ��� �. _ �;�� f I�� � .,, ..,.. -�ik�fL - ,� i�s', d'alp�=, l�'t, �i .,,,, y-. i. i5 +'.�. ���r�.. , F� �i� ��1'L �:+���� � ��:4,. - .r�.�r �� �� ����� , � ._,.. � .1 ��,� �'�� .' � -e'��r' � � �����I ,,d�1���,���,. �� �'�'3�F F������"�r.'� d T H E T � 1N N � F , :��.�.��� .:�; - � ���:r ,�� , . ., . � , _., , �.�. ,.. ....r,�, ; . . ,. . '"f 1�4 , . �i ,..' 1 ,: '�. '< , ,.,� ..� ..� ..,�. ...�. �. _.�... :',l l.,i,�..�. . . , ... 1.� .'i�.� ...I:"/i:� ��y�� `FI�'iTl },`I�rirdl� yei�`rV,.. , ' I �s.�L i � d�,� i�f i � DI � T � �V � TIIIE � � DE � IGN �� � � ,.�u,�,�:, _,,y�:� � ., : - - .. . . .����� .� .�_. Thursday, June 17 , 2021 The Town of Westlake * 1500 Solana Blvd, Suite 7200 Westlake, Texas 76262 * www.westlake-tx.org MUNICIPAL i MUNICIPAL BUDGET 4-30 Five-Year Forecast T H E T Q W N 0 F - - W E ST LA K E FISCAL & BUDGETARY POLICIES 31-45 DISTINCTIVE BY DESIGN - - - CAPITAL PROJECT FORECAST Formerly Adopted and New 46 Fi s c al Ye ar _ Pr°p°s�d Pr°;��ts _ CAPITAL PROJECT FORECAST 4� Z O� 1 -2 0 2 2 Unfunded/Under Discussion ACADEMI C Proposed ACADEMIC BUDGET ' Assumptions and Five-Year Forecast 49-50 Operating Budget SHARED SERVICE MODEL Municipal and Academic SeYvices 51 GENERAL FUND SUMMARY 52 Budget PERSONNEL 53 Retreat 06- 17-21 _ Ix e 'i �11 � � '��fi w�:�` � '`d,,w��,7 r`��'�r� ,�� �� q��� § 'd, `� N,� J� �' �.+�'T ' M ���. '� �� ������ �i����"d<� " �� ; � ��`. '�,:. � :�������.:� � T H E T � 1N N � F � . r-} , , � ;,ti _,..� , .„�,- � � � DI � T � �V � TIIIE � � DE � IGN , .,� �_„ FIVE YEAR FINANCIAL FORECAST SUMMARY ADOPTED REVISED � �� � � Projected Projected Projected Projected FUND FY 20/21 FY 20/21 FY 22/23 FY 23/24 FY 24/25 FY 25/26 ' � � Total Revenues and Other Sources $ 9,620,674 $ 10,179,751 $ 10,759,302 $ 12,750,668 $ 11,328,961 $ 13,504,832 $ 12,311,057 Total Expenditures and Other Uses (10,675,746) (9,913,481) (12,559,992) (11,956,719) (12,472,272) (13,243,164) (12,737,373) • � � i i :�� •� Beginning Fund Balance 14,498,447 14,498,447 14,764,717 12,964,028 13,757,976 12,614,665 12,876,333 Endin�Fund Balance 13,443,375 14,764,717 12,964,028 13,757,976 12,614,665 12,876,333 12,450,017 Restricted/Committed/Assigned 298,560 430,111 430,111 430,111 430,111 430,111 430,111 Unassigned Ending Balance $ 13,144,815 $ 14,334,606 $ 13,327,865 $ 12,184,554 $ 12,446,222 $ 12,019,906 Operating Expenditures $10,665,746 $9,828,481 $10,059,992 $10,256,719 $10,522,272 $10,793,164 $11,037,373 Operating Cost per Day $29,221 $26,927 $27,562 $28,101 $28,828 $29,570 $30,239 OPERATING DAYS 450 532 455 474 423 421 397 . . . � Total Revenues and Other Sources $ 5,819,803 $ 5,819,803 $ 5,779,603 $ 5,931,667 $ 6,045,606 $ 6,158,660 $ 6,249,176 Total Expenditures and Other Uses (5,641,207) (5,641,207) (6,074,051) (5,814,945) (5,951,982) (5,962,263) (6,037,113) • � �. Beginning Working Capital 5,738,480 5,738,480 5,917,075 5,622,627 5,739,349 5,832,973 6,029,371 Ending Working Capital 5,917,075 5,917,075 5.622,627 5,739,349 5,832,973 6,029,371 6,241,434 Restricted/Committed/Assigned 1,457,933 1,457,933 1,307,032 1,298,577 1,289,974 1,276,344 1,262,468 Unassigned Working Capital $ 4,459,143 $ 4,459,143 $ 4,440,772 $ 4,542,999 $ 4,753,026 $ 4,978,966 . � . Total Revenues and Other Sources $ 109,275 $ 184,275 $ 2,484,275 $ 1,665,050 $ 1,980,050 $ 2,415,050 $ 1,665,050 Total Expenditures and Other Uses (1,143,500) (1,058,500) (1,793,287) (972,000) (1,518,000) (3,785,000) (1,218,515) • � � •� � � i � � Beginning Fund Balance 1,980,839 1,980,839 1,106,614 1,797,602 2,490,652 2,952,702 1,582,752 Endins Fund Balance 946.614 1.106.614 1.797,602 2,490,652 2.952,702 1.582,752 2,029.287 Restricted/Committed/Assigned 946,614 1,106,614 1,797,602 2,490,652 2,952,702 1,582,752 2,029,287 Unassigned Ending Balance $ - $ - $ - $ - $ - $ - . � . � Total Revenues and Other Sources $ 1,470,625 $ 1,765,250 $ 2,072,486 $ 1,886,708 $ 1,928,159 $ 1,756,168 $ 1,789,661 Total Expenditures and Other Uses (1,612,716) (2,057,341) (1,809,837) (1,805,068) (1,787,308) (1,586,163) (1,600,365) • � i• �• �� �� � � �� Beginning Fund Balance 834,616 834,616 542,525 805,174 886,815 1,027,665 1,197,670 Endin�Fund Balance 692,525 542,525 805,174 886,815 1,027,665 1,197,670 1,386,966 Restricted/Committed/Assigned 692,525 542,525 805,174 886,815 1,027,665 1,197,670 1,386,966 Unassigned Ending Balance $ - $ - $ - $ - $ - $ - 4 FIVE YEAR FINANCIAL FORECAST SUMMARY ADOPTED REVISED � �� � � Projected Projected Projected Projected FUND FY 20/21 FY 20/21 FY 22/23 FY 23/24 FY 24/25 FY 25/26 � : ' � Total Revenues and Other Sources $ 2,654,572 $ 2,653,759 2,804,222 2,913,756 2,918,787 2,658,995 2,660,460 Total Expenditures and Other Uses (2,691,274) (2,691,274) (2,917,224) (2,913,756) (2,918,787) (2,658,995) (2,660,460) • � : � i� � � Beginning Fund Balance 150,518 150,518 113,003 (0) 0 0 0 Ending Fund Balance 113,816 113,003 (0) 0 0 0 0 Restricted/Committed/Assigned 113,816 113,003 0 0 0 0 0 Unassigned Ending Balance $ - $ - � $ 0 $ 0 $ - $ - � ' � " • � Total Revenues and Other Sources $ 280,000 $ 2,530,000 $ 3,613,602 $ 10,000 $ 10,000 $ 10,000 $ 10,000 Total Expenditures and Other Uses (1,613,830) (2,419,130) (2,991,720) (579,017) (682,865) 0 0 • � � � . � � ��i Beginning Fund Balance 4,502,451 4,502,451 4,613,321 5,235,203 4,666,186 3,993,321 4,003,321 Endin�Fund Balance 3,168,621 4,613,321 5,235,203 4,666,186 3,993,321 4,003,321 4,013,321 Restricted/Committed/Assigned 3,168,621 4,613,321 5,235,203 4,666,186 3,993,321 4,003,321 4,013,321 Unassigned Ending Balance $ - $ - $ - $ - $ - $ - ' � � • � � ' � � ' : Total Revenues and Other Sources $ 19,954,949 $ 23,132,838 $ 27,513,490 $ 25,157,849 $ 24,211,562 $ 26,503,706 $ 24,685,404 Total Expenditures and Other Uses (23,378,273) (23,780,933) (28,146,110) (24,041,504) (25,331,214) (27,235,585) (24,253,826) • � �• .�: Beginning Fund Balance 27,705,352 27,705,352 25,005,509 26,424,634 27,540,979 26,421,327 25,689,447 Ending Fund Balance 24,282,027 27,057,256 26,424,635 27,540,979 26,421,327 25,689,447 26,121,025 Restricted/Committed/Assigned 6,678,069 8,263,507 9,575,122 9,772,341 9,693,773 8,490,199 9,122,153 Unassigned Ending Balance $ 17,603,958 $ 18,793,749 $ 17,768,638 $ 16,727,554 $ 17,199,248 $ 16,998,872 5 FIVE YEAR FINANCIAL FORECAST ALL MUNICIPAL FUNDS AUDITED ADOPTED REVISED � Projected Projected Projected Projected FY 19-20 FY 20-21 FY 20-21 FY 22-23 FY 23-24 FY 24-25 FY 25-26 � � � � � � / � 11 ' � � 1 Sales&UseTaxRevenues 3% $ 7,378,900 $ 4,221,500 $ 6,000,000 5 5,607,236 5,775,453 5,945,717 6,127,178 6,310,994 2 Commerciall - - - - - 250,000 250,000 250,000 250,000 3 Commercial2 - 0 - - - 100,000 100,000 100,000 100,000 BASE SALES&USE TAX 7,378,900 4,221,500 6,000,000 5,607,236 6,125,453 6,298,717 6,477,178 6,660,994 4 Allocation to 4B 2% (1,844,R5) (1,055,375) (1,500,000) (1,107,236) (1,108,041) (1,101,553) (878,619� (885,961) 5 Allocation to ED (50) - - - - - - - ALLOCATIONSTOOTHERFUNDS (1,844,775) (1,055,375) (1,500,000) (1,107,236) (1,108,041) (1,101,553) (878,619) (885,961) 6 TotalGeneral5ales7ax 5,534,125 3,166,125 4,500,000 4,500,000 5,017,412 5,197,164 5,598,559 5,775,033 7 PropertyTax 2% 1,713,375 1,837,577 2,003,360 1,800,921 1,836,939 1,873,675 1,9ll,152 1,949,375 8 Addl Residential(cumulative) schedule - - - - 289,886 434,685 572,409 690,911 g CurrentYearPenalty/Interest 0% 4,091 - - - - - - - 10 PriorYear Penalty/Interest 0% 1,410 - - - - - - - 11 PriorYearDelinquent 0% 7,075 - - - - - - - BASEPROPERTYTAX 1,725,950 1,837,577 2,003,360 1,800,921 2,126,825 2,308,363 2,483,561 2,640,286 12 Additional Commercial(Schwab) schedule - - - - 316,469 316,469 316,469 316,469 13 SchwabAbatementStartedl6/ll schedule - - - - (253,175) (221,528) (189,881) (15$234) ADDITIONAL DEVELOPMENT - - - - 63,294 94,941 126,587 158,234 14 TotalPrapertyTax 1,725,950 1,837,577 2,003,360 1,800,921 2,190,119 2,403,304 2,630,148 2,798,520 15 Building-MEP-0rivewayPermits dept 12 739,585 895,253 895,253 1,416,352 2,223,761 1,050,261 2,075,261 998,461 16 Inspection/Plan Review Fees dept 12 551,581 1,392,408 537,152 790,425 1,266,959 678,560 1,118,560 697,524 17 Grading/Excavation Fees dept 12 9,783 29,6D 29,627 43,745 40,335 37,500 39,500 33,000 18 Erosion Control Fees dept 12 22,500 72,000 72,000 108,000 96,000 93,000 94,500 81,000 19 Fire Inspection Permits dept 14 46,682 55,866 55,866 55,866 116,159 35,900 101,800 42,600 20 Permits and Fees(Building Residential&Commercial) 1,370,131 2,445,154 1,589,898 2,414,388 3,743,214 1,895,521 3,429,921 1,852,885 21 Liquor Permit Fees dept 10 1% 1,020 3,080 3,080 3,080 3,111 3,142 3,173 3,205 22 OtherMiscPermits dept 10 1% 1,500 - - - - - - - 23 Administrative Fees dept 10 1% 7,426 3,615 3,615 3,615 3,651 3,688 3,725 3,762 24 Reforestation Tree Escrow dept 12 1% 45,805 32,450 32,450 - - - - - 25 Open Space Escrow dept 12 1% 100,000 - - - - - - - 26 Re-Inspection Fees dept 12 1% - 50 50 - - - - - 27 GasWell-SitePermits dept 12 1% - - - - - - - - 28 GasWell-DrillingPermits dept 12 1% - - - - - - - - 2g Gas Well Misc Fees dept 12 1% 2,500 - - - - - - - 30 Insurance&Surety Review Fees dept 12 1% - - - - - - - - 31 RenewalFees dept 12 1% - - - - - - - - 32 Engineer Review/Civil dept 12 1% 216,584 20,000 20,000 20,000 20,200 20,402 20,606 20,812 33 Pre-Submittal Reviews dept 12 1% - - - - - - - - 34 Development Fees dept 12 1% 112,667 61,868 61,868 61,868 62,487 63,112 63,743 64,380 35 DevelopmentFees-Entrada dept 12 1% - - - - - - - - 36 ContractorRegistrationFees dept 12 1% 30,518 15,000 15,000 15,000 15,150 15,302 15,455 15,609 37 EMS Revenues dept 14 1% 110,783 110,000 110,000 110,000 111,100 112,211 113,333 114,466 38 FirefighterEquipmentFees dept 14 1% - - - - - - - - 39 FireCodelnspections dept 14 1% - - - - - - - - 40 Administrative Fees dept 15 1% - - - - - - - - 41 Misc Permits and Fees(Other) 628,804 246,063 246,063 213,563 215,699 217,856 220,034 222,235 42 Flex Plan Gain dept 10 1% - - - - - - - - 43 Special Events dept 10 1% - - - - - - - - 44 Sales of Surplus/Scrap Items dept 10 1% 7,129 1,810 1,810 1,810 1,828 1,846 1,865 1,883 45 Tarrant Cnty CARES Distrib dept 10 1% 69,901 - - - - - - - 46 Insurance Refund/Equity Return dept 10 1% 15,987 3,345 3,345 3,345 3,378 3,412 3,446 3,481 47 Misc Revenue dept 10 1% 6,777 5,550 5,550 5,550 5,606 5,662 5,718 5,775 48 MiscRevenue dept 12 1% - 100 100 100 101 102 103 104 49 MiscRevenue dept 14 1% 100 100 100 100 101 102 103 104 50 MiscRevenue dept 15 1% - - - - - - - - 51 MiscRevenue dept 16 1% - - - - - - - - 52 MiscRevenue dept 17 1% - - - - - - - - 53 FacilityRental dept 17 1% 8,975 15,000 15,000 5,000 5,050 5,101 5,152 5,203 54 MiscRevenue dept 19 1% - - - - - - - - 55 FacilityRental dept 19 1% - - - - - - - - 56 ARPA-CV State&Local Fiscal Rec. dept 10 1% - - 200,000 200,000 - - - - 9 BBVA CC Cash Rewards dept 10 1% 1,324 - - - - - - - 58 MiscRevenue dept 11 1% - - - - - - - - 59 SAFERGrant dept 14 1% - 285,325 - - - - - - 60 Misc Income 130,192 311,230 225,905 215,905 16,064 16,225 16,387 16,551 61 AT&T/SBC dept 10 1% 430,565 420,000 420,000 420,000 424,200 425,442 432,726 437,054 62 Verizon dept 10 1% - - - - - - - - 63 TXU/AtmosGas dept 10 1% 50,063 50,100 50,100 50,100 50,601 51,107 51,615 52,134 6 3 FIVE YEAR FINANCIAL FORECAST ALL MUNICIPAL FUNDS AUDITED ADOPTED REVISED � Projected Projected Projected Projected FY 19-20 FY 20-21 FY 20-21 FY 22-23 FY 23-24 FY 24-25 FY 25-26 65 Charter dept 10 1% 19,821 - - - - - - - 66 OneSource dept 10 1% 3,643 1,575 1,575 1,575 1,591 1,607 1,623 1,639 67 Southwestern Bell dept 10 1% - - - - - - - - 68 Tri-CountyElectric dept 10 1% 347,735 338,550 338,550 338,550 341,936 345,355 34S,SOS 352,296 69 TrinityWaste/AWINMgmt dept 10 1% 56,995 76,000 76,000 76,000 76,760 77,528 75,303 79,OS6 70 H3Construction dept 10 1% 7,653 2,000 2,000 2,000 2,020 2,040 2,061 2,081 71 Misc.Franchire Fees dept 10 L°o 56,045 53,900 53,900 53,900 54,439 54,953 55,533 56,OS9 72 Franchise Fees 972,519 942,125 942,125 942,125 951,546 961,062 970,672 980,379 73 Citation Revenue dept 15 1% 430,674 405,000 405,000 405,000 409,050 413,141 417,272 421,445 74 Citation Revenue-JCM dept 15 1% 11,817 16,000 16,000 16,000 16,160 16,322 16,485 16,650 75 Citation Revenue dept 15 0% - - - - - - - - 76 CourtTechology dept 15 1% 15,656 12,800 12,800 12,800 12,928 13,057 13,188 13,320 77 CourtSecurity dept 15 1% 16,131 13,500 13,500 13,500 13,635 13,771 13,909 14,045 78 WarrantRevenue-5/O dept 15 0% 129 - - - - - - - 7g Warrant Fees dept 15 1% 20,372 26,000 26,000 26,000 26,260 26,523 26,788 D,056 80 NSFCheckFees dept 15 0% 403 - - - - - - - 81 Court Efficiency Fees dept 15 1% 317 1,100 1,100 1,100 1,111 1,122 1,133 1,145 82 Law Enforcement Stds/Edu dept 15 0% 629 - - - - - - - 83 Law Enforcement Stds/Edu(Marshal) dept 15 0% - 1,200 1,200 1,200 1,201 1,201 1,202 1,202 84 Collection Fees dept 15 0% (3,693) - - - - - - - 85 Court Fines and Forfeitures 492,434 475,600 475,600 475,600 480,345 485,137 489,977 494,865 86 BeverageTax dept 10 1% 41,949 40,000 40,000 40,000 40,400 40,804 41,212 41,624 87 Entrada Hotel dept 10 1% - - - - - 15,000 15,000 15,000 88 Front 44 dept 10 1% - - - - - - 15,000 15,000 8g Beverage Tax 41,949 40,000 40,000 40,000 40,400 55,804 71,212 71,624 90 Interest Income dept 10 1% 144,549 ss,000 ss,000 ss,000 85,850 86,709 87,576 88,451 91 Interestlncome dept 15 1% 1,592 3,800 3,800 3,800 3,838 3,876 3,915 3,954 92 Interest Income 146,141 88,800 88,800 88,800 89,688 90,585 91,491 92,406 93 ConVibutions dept 10 1% - - - - - - - - g4 ConVibutions dept 19 1% (2,100) - - - - - - - s5 contributions (z,loo) - - - - - - - 96 Transfer in-Fund 412 WA Expansion - - - - - - - - g7 Transfer In-UF 500 for Impact Fees 77,158 68,000 68,000 68,000 6,181 6,305 6,431 6,560 g8 Transfers In 77,158 68,000 68,000 68,000 6,181 6,305 6,431 6,560 99 TOTAL REVENUES 11,097,303 9,620,674 30,179,751 12,750,668 11,328,961 13,504,832 12,311,057 100 Wages-FuIlTimeSalaries acct 41110 3% (3,848,995) (4,225,391) (4,042,372) (4,215,400) (4,341,862) (4,472,118) (4,606,281) (4,744,470) 101 Wages-PartTimeSalaries acct 41210 3% (41,904) (115,320) (115,320) (211,433) (217,776) (224,309) (231,038) (237,969) 102 Wages-Overtime acct 41120 3% (225,736) (142,323) (129,155) (238,623) (245,782) (253,155) (260,750) (265,572) 103 Wages-PremiumPay acct 41510 3% (15,824) (31,463) (27,692) (28,992) (29,862) (30,758) (31,680) (32,631) 104 Wages-FireAdministrative acct 41620 0% - - - - - - - - 105 Wages-CarAllowance acct 41640 0% (29,223) (28,200) (28,200) (28,200) (28,200) (28,200) (28,200) (28,200) 106 Wages-MovingAllowance acct 41645 0% - - - - - - - - 107 Wages-PerformancePay acct 41647 0% - - - - - - - - 108 Wages-457TownContribution acct 41670 0% - - - (30,550) - - - - 109 Wages-Phone Allowance acct 41641 0% (16,470) (16,800) (17,215) (20,120) (20,120) (20,120) (20,120) (20,120) 110 Wages-MeritPayTSO acct 41660 0% (2,000) - - - - - - - 111 Other-TransferslnVA&UF acct 42698 1% 904,453 740,564 740,564 880,117 888,918 897,807 906,785 915,853 112 Payroll5alaries&Wages (3,275,700) (3,818,933) (3,619,390) (3,893,201) (3,994,683) (4,130,852) (4,271,284) (4,416,109) 113 Insurance-Medical acct 42110 8% (600,956) (676,248) (639,680) (651,729) (700,609) (753,154) (809,641) (870,364) 114 Insurance-Dental acct 42111 1% (31,583) (35,204) (33,527) (36,027) (36,387) (36,751) (37,119) (37,490) 115 Insurance-Vision acct 42112 1% - - - - - - - - 116 Insurance-Life acct 42130 1% (29,095) (33,137) (31,418) (32,918) (33,247) (33,580) (33,915) (34,255) 117 Taxes-Social5ecurity acct 42210 3% (243,594) (282,334) (269,937) (287,309) (295,928) (304,806) (313,950) (323,369) 118 Taxes-Medicare acct 42220 3% (58,132) (66,030) (63,131) (67,194) (69,210) (71,286) (73,425) (75,627) 119 Taxes-Unemployment acct 42510 1% (8,682) (7,776) (7,344) (7,389) (7,463) (7,535) (7,613) (7,659) 120 Taxes-Workers Comp acct 42610 1% (49,685) (57,123) (52,599) (52,974) (53,504) (54,039) (54,579) (55,125) 121 Retirement-TMRS acct 42310 3% (494,031) (516,289) (491,958) (525,244) (541,001) (557,231) (573,948) (591,167) 122 Retirement-ICMA acct 42311 0% - - - - - - - - 123 PayrollTaxes,lnsurence,Retirement (1,515,758) (1,674,141) (1,589,594) (1,660,784) (1,737,349) (1,818,385) (1,904,190) (1,995,085) 124 Total Payrolland Related (4,791,458) (5,493,074) (5,208,984) (5,553,985) (5,732,032) (5,949,237) (6,175,475) (6,411,194) 125 ComputerHardware/Software dept 18 0% (3,376) - - - - - - - 126 Computer Hardware/Software dept 11 0% (2,800) (1,000) (1,000) (1,000) (1,000) (1,000) (1,000) (1,000) 127 ComputerHardware/Software dept 12 0% - - - - - - - - 128 ComputerHardware/Software dept 15 0% - - - - - - - - 129 Fire Fighter Equipment dept 14 0% (69,417) (21,900) (21,900) (21,900) (21,900) (21,900) (21,900) (21,900) 130 Fire Fighter Equipment(COVID-19) dept 14 0% (2,990) - - - - - - - 131 Furniture&Fixtures dept 17 0% - (2,500) (2,500) (2,500) (2,500) (2,500) (2,500) (2,500) 132 Furniture&Fixtures dept 16 0% (794) (795) (795) (795) (795) (795) (795) (795) 133 Furniture&Fixtures dept 18 0% - - - - - - - - 134 Furniture&Fixtures dept 17 0% (1,042) (3,000) (3,000) (3,000) (3,000) (3,000) (3,000) (3,000) 135 MechanicalEquipment dept 17 0% - (1,000) (1,000) (1,000) (1,000) (1,000) (1,000) (1,000) 136 Mechanical Equipment dept 12 0% - - - - - - - - 7 FIVE YEAR FINANCIAL FORECAST ALL MUNICIPAL FUNDS AUDITED ADOPTED REVISED � Projected Projected Projected Projected FY 19-20 FY 20-21 FY 20-21 FY 22-23 FY 23-24 FY 24-25 FY 25-26 137 MechanicalEquipment dept 16 0% (5,359) (5,000) (5,000) (5,000) (5,000) (5,000) (5,000) (5,000) 138 Mechanical Equipment dept 19 0% (169) (2,020) (2,020) (2,020) (2p20) (2p20) (2p20) (2p20) 139 Motor Vehides dept 19 0% - - - (1,000) (1,000) (1,000) (1,000) (1,000) 140 Total Capital Outlay (85,947) (37,215) (37,215) (38,215) (38,215) (38,215) (38,215) (38,215) 141 General5ervice Debt�thru 24/25)(BBP) acct 47120 0% (36,677) (36,680) (36,680) (36,680) (36,650� (36,650� (36,680� - 142 Westlake Reserve acct 47900 0% (219,750) - - - - - - - 143 Total Debt Expenditures (256,427) (36,680) (36,680) (36,680) (36,680) (36,680) (36,680) - 144 CopierLease dept 10 1% (6,411) �ns,000) (45,000) (45,000) (45,450) (45,905) (46,364) (46,827) 145 CopierLease dept 11 1% (341) - - - - - - - 146 CopierLease dept 13 1% (2,466) - - - - - - - 147 CopierLease dept 14 1% (3,320) - - - - - - - 148 CopierLease dept 15 1% (12,594) - - - - - - - 149 CopierLease dept 17 1/ (2,125) - - - - - - - 150 CopierLease dept 18 1/ (2,800) - - - - - - - 151 CopierLease dept 21 1/ (2,125) - - - - - - - 152 CopierLease dept 22 1/ (2,125) - - - - - - - 153 Misc Rental/Lease dept 10 1% (2,597) (1,265) (1,265) (1,265) (1,275) (1,290) (1,303) (1,316) 154 Misc Rental/Lease dept 12 1% (3,179) (2,550) (2,550) (2,550) (2,576) (2,601) (2,627) (2,654) 155 Misc Rental/Lease dept 13 1% - (250) (250) (250) (253) (255) (255) (260) 156 Misc Rental/Lease dept 15 1% (690) (1,070) (1,070) (1,070) (1,OS1) (1,092) (1,102) (1,113) 157 Misc Rental/Lease dept 17 1% - - - - - - - - 158 Misc Rental/Lease dept 17 1% - - - - - - - - 159 Total Rental&Lease Expenditures (40,772) (50,135) (50,135) (50,135) (50,636) (51,143) (51,654) (52,171) 160 TownSecretary dept 13 1% (22,R0) (15,000) (15,000) (15,000) (15,150) (15,302) (15,455) (15,609) 161 Fire Department dept 14 1% - (140) (140) (140) (141) (143) (144) (146) 162 Facilities WA dept 17 1% - (2,380) (2,380) (1,500) (1,515) (1,530) (1,545) (1,561) 163 Finance dept 18 1% (150) - - - - - - - 164 Human Resources dept 21 1% (2,188) �z,soo) (2,500) (2,500) (2,525) (2,550) (2,576) (2,602) 165 FacilitiesTown dept 26 1% - - - - - - - - 166 Total Public Notice Expenditures (25,058) (20,020) (20,020) (19,140) (19,331) (19,525) (19,720) (19,917) 167 InsuranceAutomobile dept 16 1% - - - - - - - - 168 InsuranceR&PP/Auto dept 16 1% - - - - - - - - 169 Totallnsurence - - - - - - - - 170 Electric-Court dept 15 1% - - - - - - - - 171 Electric-Fire Station dept 14 1% (22,071) (10,000) (10,000) (10,000) (10,100) (1Q201) (10,303) (10,406) 172 Electric-Parchman dept 10 1% - - - - - - - - 173 Electric-Parchman dept 19 1% - - - - - - - - 174 Electric-Parks/Rec dept 19 1% (10,170) (7,950) (7,950) (7,950) (5,030) (5,110) (5,191) (8,273) 175 Electric-Public Works dept 16 1% (4,769) (2,864) (2,864) (10,000) (10,100) (10,201) (10,303) (10,406) 176 Electric-Town Hall dept 10 1% (37,052) (55,000) (55,000) (55,000) (55,550) (56,106) (56,667) (57,233) n� Electric-TownHall dePc v zi �i,ni) �soo) �soo) �soo) (sos� (sio� (sis� (szo� 178 Gas-Fire Station dept 14 1% (4,769) (7,500) (7,500) (7,500) (7,575) (7,651) (7,727) (7,805) 179 Internet-TownHall dept 26 1% - - - - - - - - 180 Intemet-WA dept 17 1% (451) (200) (200) (1,500) (1,515) (1,530) (1,545) (1,561) 181 Intemet-Fire Dept dept 14 1% (26,927) (16,000) (16,000) (16,000) (16,160) (16,322) (16,455) (16,650) 182 Intemet-TownHall dept 10 1% (15,644) (13,500) (13,500) (13,500) (13,635) (13,771) (13,909) (14,048) 183 Office Rent dept 10 (393,555) (370,370) (370,370) (370,370) (348,452) (355,796) (359,037) (362,378) 184 Telephone-Fire Dept dept 14 1% (7,042) (4,100) (6,840) (6,840) (6,908) (6,977) (7,047) (7,118) 185 Telephone-TownHall dept 10 1% (502) (3,100) (3,100) (3,100) (3,131) (3,162) (3,194) (3,226) 186 Telephone-Facilities dept 17 1% - - - - - - - - 187 Water-Fire Dept dept 14 1% (32,168) (15,750) (15,750) (15,750) (15,905) (16,067) (16,227) (16,390) 188 Water-Parks&Rec dept 19 1% (1,210) (1,015) (1,015) (1,015) (1,025) (1,035) (1,046) (1,056) 189 Water-ROWlrrigation dept 16 1% (236,902) (150,000) (150,000) (170,000) (171,700) (173,417) (175,151) (176,903) 190 Water-ROW Irrigation dept 19 1% (106,220) (100,000) (100,000) (100,000) (101,000) (102,010) (103,030) (104,060) 191 Total Rent&Utilities (900,722) (757,849) (760,589) (789,025) (771,294) (782,866) (790,378) (798,032) 192 Audio Visual R&M dept 14 1% (41) (2,500) (2,500) (2,500) (2,525) (2,550) (2,576) (2,602) 193 Audio Visual R&M dept 26 1% - - - - - - - - 194 Audio Visual R&M dept 17 1% (1,490) (525) (525) (525) (530) (536) (541) (546) 195 BuildingExteriorR&M dept 14 1% - - - - - - - - 196 BuildingExteriorR&M dept 26 1% - - - - - - - - 197 Building Exterior R&M dept 17 1% (809) (2,000) (2,000) (2,000) (2,020) (2,040) (2,061) (2,OS1) 198 Building Exterior R&M dept 17 1% (680) (2,250) (2,250) (2,250) (2,273) (2,295) (2,315) (2,341) 199 Building Exterior R&M dept 17 1% (1,400) (3,500) (3,500) (3,500) (3,535) (3,570) (3,606) (3,642) 200 Building R&M dept 14 1% (4,652) �n,eoo) (4,600) (4,600) (4,646) (4,692) (4,739) (4,787) 201 Building R&M Contract dept 26 1% - - - - - - - - 202 Building R&M Contract dept 17 1% (1,257) (5,000) (5,000) (5,000) (5,050) (5,101) (5,152) (5,203) 203 Building R&M Contract dept 17 1% (250) (2,750) (2,750) (2,750) (2,775) (2,505) (2,533) (2,562) 204 Town Contract Building R&M dept 17 1% (7,376) (5,000) (5,000) (5,000) (5,050) (5,101) (5,152) (5,203) 205 Contract Building Maintenance(COVID-19) dept 17 1% (1,193) - - - - - - - 206 Communication R&M dept 14 1% (2,440) (6,000) (6,000) (6,000) (6,060) (6,121) (6,152) (6,244) 207 Electrical R&M dept 26 1% - - - - - - - - 208 Electrical R&M dept 17 1% (837) (375) (375) (375) (379) (353) (356) (390) 209 Electrical R&M dept 17 1% - (1,000) (1,000) (1,000) (1,010) (1,020) (1,030) (1,041) $ FIVE YEAR FINANCIAL FORECAST ALL MUNICIPAL FUNDS AUDITED ADOPTED REVISED � Projected Projected Projected Projected FY 19-20 FY 20-21 FY 20-21 FY 22-23 FY 23-24 FY 24-25 FY 25-26 210 Electrical R&M dept 17 1% - (1,000) (1,000) (1,000) (1,010) (1p20) (1,030) (1,041) 211 Electrical R&M Contract dept 26 1% - - - - - - - - 212 Electrical R&M Contract dept 17 1% (RS) (1,000) (1,000) (1,000) (1,010) (1,020) (1,030) (1,041) 213 ElevatorR&M dept 17 1% - - - - - - - - 214 Equipment R&M dept 14 1% (19,184) (13,370) (13,370) (18,570) (15,756) (15,943) (19,133) (19,324) 215 FireSprinklerR&M dept 17 1% - - - - - - - - 216 FireSprinklerR&M dept 26 1% - - - - - - - - 217 Fire Sprinkler R&M dept 17 1% (1,640) (4,500) (4,500) (4,500) (4,545) (4,590) (4,636) (4,683) 218 Fire Sprinkler R&M dept 17 1% (1,606) (1,200) (1,200) (1,200) (1,212) (1,224) (1,236) (1,249) 219 FireStationR&M dept 17 1% (1,385) - - - - - - - 220 FireStationR&M dept 17 1% - - - - - - - - 221 FireStationR&M dept 26 1% - - - - - - - - 222 Fire/Life-AEDR&M dept 17 1% - - - - - - - - 223 Fire/Life-AEDR&M dept 17 1% - (1,500) (1,500) (1,500) (1,515) (1,530) (1,545) (1,561) 224 Grounds R&M dept 17 1% (696) (3,500) (3,500) (3,500) (3,535) (3,570) (3,606) (3,642) 225 GroundsR&M dept 14 1% - (275) (275) (275) (275) (251) (253) (286) 226 Grounds R&M dept 19 1% (5,314) (13,000) (13,000) (13,000) (13,130) (13,261) (13,394) (13,525) 227 GroundsR&M dept 26 1% - - - - - - - - 228 Grounds R&M dept 17 1% (1,542) (1,200) (1,200) (1,200) (1,212) (1,224) (1,236) (1,249) 229 Grounds R&M dept 17 1% (800) (2,000) (2,000) (1,000) (1,010) (1,020) (1,030) (1,041) 230 HOCProjects dept 17 1% - - - - - - - - 231 HOCProjects dept 19 1% - - - - - - - - 232 HVAC R&M dept 17 1% (3,935) (1,000) (1,000) (1,000) (1,010) (1,020) (1,030) (1,041) 233 HVAC R&M dept 14 1% - - - - - - - - 234 HVAC R&M dept 26 1% - - - - - - - - 235 HVAC R&M dept 17 1% - (2,000) (2,000) (2,000) (2,020) (2,040) (2,061) (2,081) 236 HVAC R&M Contract dept 26 1% - - - - - - - - 237 HVAC R&M Contract dept 14 1% - - - - - - - - 238 HVAC R&M Contract dept 17 1% (180) (1,825) (1,825) (1,825) (1,843) (1,562) (1,SS0) (1,599) 239 HVAC R&M Contract dept 17 1% (2,262) (1,000) (1,000) (3,000) (3,030) (3,060) (3,091) (3,122) 240 HVAC R&M Contract dept 17 1% (852) (2,500) (2,500) (2,500) (2,525) (2,550) (2,576) (2,602) 241 HVAC R&M Contract dept 17 1% - (1,000) (1,000) (1,000) (1,010) (1,020) (1,030) (1,041) 242 Interior Building R&M dept 17 1% (842) (2,000) (2,000) (2,000) (2,020) (2,040) (2,061) (2,OS1) 243 Interior Building R&M dept 26 1% - - - - - - - - 244 Interior Building R&M dept 17 1% (3,154) (2,000) (2,000) (1,000) (1,010) (1,020) (1,030) (1,041) 245 Interior Building R&M dept 17 1% - (1,000) (1,000) (1,000) (1,010) (1,020) (1,030) (1,041) 246 Irrigation R&M dept 17 1% - - - - - - - - 247 Irrigation R&M dept 19 1% - (4,500) (4,500) (4,500) (4,545) (4,590) (4,636) (4,683) 248 Irrigation R&M dept 17 1% - (1,500) (1,500) (1,500) (1,515) (1,530) (1,545) (1,561) 24g LandscapeTreeR&M dept 16 1% - - - - - - - - 2W Mechanical R&M dept 14 1% - - - - - - - - 251 Mechanical R&M dept 26 1% - - - - - - - - 252 Mechanical R&M dept 17 1% - (1,000) (1,000) (1,000) (1,010) (1,020) (1,030) (1,041) 253 Maint.Bldg.Contract Services dept 17 1% (750) - - - - - - - 254 Mechanical R&M Contract dept 26 1% - - - - - - - - 255 Mechanical R&M Contract dept 17 1% (1,000) (1,080) (1,080) (1,080) (1,091) (1,102) (1,113) (1,124) 256 Mechanical R&M Contract dept 17 1% (4,000) (4,000) (4,000) (4,000) (4,040) (4,080) (4,121) (4,162) 257 Mechanical R&M Contract dept 17 1% (1,000) (3,000) (3,000) (3,000) (3,030) (3,060) (3,091) (3,122) 258 Median R&M Contract dept 17 1% (1,235) - - - - - - - 259 Median R&M Contract dept 19 1% (58,627) (27,710) (27,710) (30,500) (30,805) (31,113) (31,424) (31,738) 260 Median R&M Contract dept 26 1% - - - - - - - - 261 Misc R&M dept 18 1% - - - - - - - - 262 Misc R&M dept 26 1% - - - - - - - - 263 Off Site Smrage R&M dept 17 1% - - - - - - - - 264 Park R&M dept 19 1% (9,018) (10,500) (10,500) (10,500) (10,605) (10,711) (10,818) (10,926) 265 Plumbing R&M dept 14 1% - - - - - - - - 266 Plumbing R&M dept 26 1% - - - - - - - - 267 Plumbing R&M dept 17 1% (201) (4,000) (4,000) (4,000) (4,040) (4,080) (4,121) (4,162) 268 Plumbing R&M dept 17 1% - (1,000) (1,000) (1,000) (1,010) (1,020) (1,030) (1,041) 269 Interior Building R&M dept 17 1% (19) - - - - - - - 270 Pothole R&M dept 16 1% - - - - - - - - 271 Road R&M dept 16 1% (37,995) (75,000) (75,000) (75,000) (75,750) (76,508) (77,273) (78,045) 272 Security R&M Contract dept 26 1% - - - - - - - - 273 Security R&M Contract dept 17 1% (370) (750) (750) (750) (758) (765) (773) (780) 274 Security R&M Contract dept 17 1% (680) - - - - - - - 275 Security R&M Contract dept 17 1% - (2,000) (2,000) (2,000) (2,020) (2,040) (2,061) (2,081) 276 Sign R&M dept 16 1% (586) (7,400) (7,400) (7,400) (7,474) (7,549) (7,624) (7,700) 277 Software R&M dept 12 1% - - - - - - - - 278 Software R&M dept 11 1% - - - - - - - - 279 Software R&M dept 17 1% - (100) (100) (100) (101) (102) (103) (104) 280 SW/HW Maintenance R&M dept 20 1% (86,752) (65,000) (65,000) (110,000) (111,100) (112,211) (113,333) (114,466) 281 SW/HW Maintenance R&M(COVID-19) dept 20 1% (895) - - - - - - - 282 Trail R&M Contract dept 17 1% - - - - - - - - 283 Trail R&M Contract dept 19 1% (4,733) (15,000) (15,000) (15,000) (15,150) (15,302) (15,455) (15,609) 284 Vehide R&M dept 10 1% - - - - - - - - 285 Vehide R&M dept 11 1% - - - - - - - - 286 Vehide R&M dept 12 1% - - - - - - - - 287 Vehide R&M dept 14 1% (59,692) (30,000) (30,000) (30,000) (30,300) (30,603) (30,909) (31,218) 288 Vehide R&M dept 15 1% (895) - - - - - - - 9 FIVE YEAR FINANCIAL FORECAST ALL MUNICIPAL FUNDS AUDITED ADOPTED REVISED � Projected Projected Projected Projected FY 19-20 FY 20-21 FY 20-21 FY 22-23 FY 23-24 FY 24-25 FY 25-26 289 Vehide R&M dept 15 1% (362) (600) (600) (600) (606) (612) (618) (624) 290 Vehicle R&M dept 16 1% (2,428) (1,775) (1,775) (2,100) (2,121) (2,142) (2,164) (2,185) 291 Vehicle R&M dept 17 1% (1,215) (2,000) (2,000) (2,000) (2,020) (2,040) (2,061) (2,081) 292 Vehicle R&M dept 19 1% (26) (1,500) (1,500) (1,000) (1,010) (1,020) (1,030) (1,041) 293 Vehide R&M dept 20 1% - - - - - - - - 294 Vehide R&M dept 21 1% - - - - - - - - 295 Vehide R&M dept 26 1% - - - - - - - - 296 Total Repair&Maintenance (339,021) (351,785) (351,785) (404,600) (408,646) (412,732) (416,860) (421,028) 297 AdministrativeExpense dept 11 1% - - - - - - - - 298 Application Software Maint. dept 16 1% - (1,128) (1,128) (1,128) (1,139) (1,151) (1,162) (1,174) 299 Appraisal Fees dept 11 1% - - - - - - - - 300 Attomey-Boyle&Lowry dept 10 1% (190,866) (115,000) (115,000) (115,000) (116,150) (117,312) (118,485) (119,669) 301 Attomey-Boyle&Lowry dept 11 1% - - - - - - - - 302 Attomey-Boyle&Lowry dept 12 1% (9,000) (20,000) (20,000) (20,000) (20,200) (20,402) (20,606) (20,812) 303 Attomey-Boyle&Lowry dept 14 1% (500) (1,115) (1,115) (1,115) (1,126) (1,137) (1,149) (1,160) 304 Attomey-Boyle&Lowry dept 15 1% (20,856) (25,000) (25,000) (25,000) (25,250) (25,503) (25,758) (26,015) 305 Attomey-Boyle&Lowry dept 17 1% (2,100) (100) (100) (4,500) (4,545) (4,590) (4,636) (4,683) 306 Attomey-Boyle&Lowry dept 18 1% (350) - - - - - - - 307 Attomey-Boyle&Lowry dept 19 1% - - - - - - - - 308 Attomey-Boyle&Lowry dept 20 1% (150) - - (1,000) (1,010) (1,020) (1,030) (1,041) 309 Attomey-Goins&Underkofler dept 10 1% - (1,045) (1,045) (1,045) (1,055) (1,066) (1,077) (1,087) 310 Attomey-Goins&Underkofler dept 11 1% - - - - - - - - 311 Auditor dept 18 1% (24,000) (24,600) (24,600) (27,000) (27,270) (27,543) (27,518) (28,096) 312 Bank Charges dept 10 1% (8,637) (3,150) (3,150) (3,150) (3,152) (3,213) (3,245) (3,278) 313 BankCharges dept 11 1% - - - - - - - - 314 BankCharges dept 15 1% - - - - - - - - 315 BankServiceCharges dept 22 1% - - - - - - - - 316 Buildinglnspection dept 12 1% (58,176) (75,000) (75,000) (75,000) (75,750) (76,SOS) (77,273) (78,045) 317 BuildingLease dept 13 1% - - - - - - - - 318 Capital Project Oper Impact dept 10 1% - - - - - - - - 319 Capital Project Oper Impact dept 16 1% - - - - - - - - 320 Capital Project Oper Impact dept 17 1% - - - - - - - - 321 Capital Project Oper Impact dept 19 1% - - - - - - - - 322 Capital Project Oper Impact dept 20 1% - - - - - - - - 323 Codification dept 13 1% (1,175) (5,000) �s,000) (5,000) (5,050) (5,101) (5,152) (5,203) 324 Communication Services dept 14 1% (16,200) (17,250) (17,250) (17,250) (17,423) (17,597) (17,773) (17,950) 325 CommunityServices dept 10 1% - - - - - - - - 326 CommunityServices dept 11 1% - - - - - - - - 327 CommunityServices dept 13 1% - - - - - - - - 328 Consultant dept 13 1% (374) - - - - - - - 329 Consultant dept 17 1% - - - - - - - - 330 Consultant Fees dept 10 1% (25,864) (31,500) (31,500) (31,500) (31,515) (32,133) (32,454) (32,779) 331 ConsultantFees dept 11 1% (1,940) - - - - - - - 332 Consultant Fees dept 12 1% (107,234) (115,000) (115,000) (115,000) (116,150) (117,312) (118,485) (119,669) 333 Consultant Fees dept 14 1% (3,000) - - - - - - - 334 Consultant Fees dept 18 1% (18,382) - - (57,500) (SS,075) (SS,656) (59,242) (59,835) 335 Consultant Fees dept 12 1% (20,371) (11,300) (11,300) (11,300) (11,413) (11,527) (11,642) (11,759) 336 Contingency dept 10 1% (9,250) - - - - - - - 337 Contingency dept 11 1% - - - - - - - - 338 Contingency dept 12 1% - - - - - - - - 339 ContractCarpetCleaning dept 26 1% - - - - - - - - 340 Contract Exterminator dept 17 1% (1,810) (1,500) (1,500) (1,500) (1,515) (1,530) (1,545) (1,561) 341 ContractJanitorial5ervice dept 26 1% - - - - - - - - 342 Contract Labor dept 11 1% - - - - - - - - 343 Contract Labor dept 12 1% - - - - - - - - 344 Contract Labor dept 14 1% - - - - - - - - 345 Contract Labor dept 15 1% - - - - - - - - 346 Contract Labor dept 18 1% - - - - - - - - 347 Contract Labor dept 21 1% (187) - - - - - - - 348 Contract Landscape dept 19 1% (14,549) (69,000) (69,000) (69,000) (69,690) (70,387) (71,091) (71,802) 349 Contract Landscape dept 26 1% - - - - - - - - 3W ContractLandscape-GWFarms dept 17 1% - - - - - - - - 351 ContractSanitatin/WasteRemov dept 26 1% - - - - - - - - 352 ContractSecurityMonitoring dept 26 1% - - - - - - - - 353 Contract Services dept 10 1% (17,195) (25,000) (25,000) (25,000) (25,250) (25,503) (25,758) (26,015) 354 Contract Services dept 12 1% (118,225) (100,000) (100,000) (100,000) (101,000) (102,010) (103,030) (104,060) 355 Contract Services dept 14 1% (44,208) (45,890) (9,890) - - - - - 356 Contract Services dept 15 1% (1,253) (1,200) (1,200) (1,200) (1,212) (1,224) (1,236) (1,249) 357 Contract Services dept 15 1% (4,124) (4,010) (4,010) (4,260) (4,303) (4,346) (4,359) (4,433) 358 Contract Services dept 18 1% - (20,000) (38,700) (35,000) (35,350) (35,704) (36,061) (36,421) 359 Contract Services dept 19 1% (12,982) (10,000) (10,000) (10,000) (10,100) (1Q201) (10,303) (10,406) 360 Contract Services dept 20 1% (6,631) (25,000) (25,000) (30,000) (30,300) (30,603) (30,909) (31,218) 361 Contract Services dept 21 1% (4,394) (10,000) (9,500) (10,000) (10,100) (1Q201) (10,303) (10,406) 362 ContractServices dept 26 1% - - - - - - - - 363 ContractSweeping/Washing dept 26 1% - - - - - - - - 364 ContractWastewaterTreatment dept 17 1% - - - - - - - - 365 Contract Window Cleaning dept 17 1% - (500) (500) (500) (505) (510) (515) (520) 366 Contract Window Cleaning dept 26 1% - - - - - - - - 10 FIVE YEAR FINANCIAL FORECAST ALL MUNICIPAL FUNDS AUDITED ADOPTED REVISED � Projected Projected Projected Projected FY 19-20 FY 20-21 FY 20-21 FY 22-23 FY 23-24 FY 24-25 FY 25-26 367 CopierR&M/Supplies/Copy/Tax dept 18 1/ - - - - - - - - 368 Courier5ervice dept 10 1% - - - - - - - - 369 Courier5ervice dept 11 1% - - - - - - - - 370 Courier5ervice dept 12 1% - (250) (250) - - - - - 371 Courier5ervice dept 13 1% (950) - - - - - - - 372 Courier5ervice dept 14 1% - - - - - - - - 373 Courier5ervice dept 16 1% - - - (1,000) (1,010) (1,020) (1,030) (1,041) 374 Courier5ervice dept 17 1% - (25) (25) (25) (25) (26) (26) (26) 375 Courier5ervice dept 18 1% - - - - - - - - a�s Courier5ervice dePe zi zi - �ioo) �ioo) �ioo) (ioi� (ioz� (ioa� (ioa� 377 Courier5ervice dept 26 1% - - - - - - - - 378 Court Efficiency dept 15 1% - (450) (450) (450) (455) (459) (464) (468) 379 CourtSecurity dept 26 1% - - - - - - - - 380 Court Technology dept 15 1% (16,341) (14,000) (14,000) (14,000) (14,140) (14,251) (14,424) (14,568) 381 CreditCardProcessing dept 10 1/ - - - - - - - - 382 CreditCardProcessing dept 11 1/ - - - - - - - - 383 CreditCardProcessing dept 15 1% (756) - - - - - - - 384 Debt Settlement Legal dept 11 1% - - - - - - - - 385 Duct Bank Engineering dept 11 1% - - - - - - - - 386 Election Expense dept 13 1% - (14,000) (7,000) (14,000) (14,140) (14,251) (14,424) (14,565) 387 Employee Physicals dept 11 1% - - - - - - - - 388 Employee Physicals dept 14 1% (15,963) (19,800) (19,800) (19,800) (19,995) (20,195) (20,400) (20,604) 389 EMS UserFee dept 14 1% (9,100) (12,000) (12,000) (12,000) (12,120) (12,241) (12,364) (12,457) 390 Engineering dept 00 1% - - - - - - - - 391 Engineering dept 10 1% - (150) (150) (150) (152) (153) (155) (156) 392 Engineering dept 11 1% - - - - - - - - 393 Engineering dept 12 1% (52,113) (50,000) (50,000) (50,000) (50,500) (51,005) (51,515) (52,030) 394 Engineering dept 16 1% (25,139) (61,461) (61,461) (61,461) (62,076) (62,696) (63,323) (63,957) 395 Engineering dept 17 1% - (5,000) (5,000) (5,000) (5,050) (5,101) (5,152) (5,203) 396 Engineering dept 21 1% - - - - - - - - 397 Entrada Design Services dept 10 1% - - - - - - - - 398 ExterminatorService dept 14 1% (1,348) (1,500) (1,500) (1,500) (1,515) (1,530) (1,545) (1,561) 399 Feasibility Studies dept 10 1% - (2,500) (2,500) (2,500) (2,525� (2,550) (2,576) (2,602) 400 FeasibilityStudies dept 11 1% - - - - - - - - 401 FeesTa«ant County dept 13 1% - (4,500) (4,500) (4,500) (4,545) (4,590) (4,636) (4,653) 402 FEMAGrantExp(Federa190%) dept 14 1% - - - - - - - - 403 FEMAGrantExp(WL10%) dept 14 1% - - - - - - - - 404 Filing Fees dept 18 1% (345) (750) (750) (750) (755) (765) (773) (750) 405 Fire/EMS Cont Carpet Clean dept 17 1% - (2,000) (2,000) (2,000) (2,020) (2,040) (2,061) (2,OS1) 406 Fire/EMSComplexContractSer dept 17 1% - (5,000) (5,000) (5,000) (5,050) (5,101) (5,152) (5,203) 407 Fire/EMS ConUanitorial Sery dept 17 1% (12,683) (12,500) (12,500) (15,000) (15,150) (15,302) (15,455) (15,609) 408 Fire/EMS Cont Landscape-Civic dept 17 1% (26,427) (22,000) (22,000) (22,000) (22,220) (22,442) (22,667) (22,593) 409 Fire/EMSContSecurityMonitor dept 17 1% (610) (1,000) (1,000) (2,000) (2,020) (2,040) (2,061) (2,OS1) 410 Fire/EMSContWindowClean dept 17 1% - (5,000) (5,000) (5,000) (5,050) (5,101) (5,152) (5,203) 411 Fire/EMSSecurity dept 17 1% - (2,500) (2,500) (2,500) (2,525) (2,550) (2,576) (2,602) 412 Flex Plan Loss dept 10 1% - - - - - - - - 413 FM1938 ROW Landscaping dept 16 1% (4,840) (3,928) (3,928) (6,428) (6,492) (6,557) (6,623) (6,689) 414 GIS Fees dept 12 1% (11,645) (11,250) (11,250) (11,250) (11,363) (11,476) (11,591) (11,707) 415 GroundsR&M dept 11 1% - - - - - - - - 416 HostedWebApplications dept 21 1% - (2,000) (1,500) (2,000) (2,020) (2,040) (2,061) (2,OS1) 417 InsuranceAutomobile dept 10 1% (54) (60) (60) (60) (61) (61) (62) (62) 418 InsuranceAutomobile dept 12 1% - - - - - - - - 419 Insurance Automobile dept 14 1% (10,220) (11,250) (11,250) (11,250) (11,363) (11,476) (11,591) (11,707) 420 InsuranceAutomobile dept 15 1% - - - - - - - - 421 Insurance Automobile dept 15 1% (594) (600) (600) (600) (606) (612) (615) (624) 422 Insurance Automobile dept 17 1% (618) (1,595) (1,595) (1,595) (1,611) (1,627) (1,643) (1,660) 423 Insurance Automobile dept 19 1% (618) (620) (620) (620) (626) (632) (639) (645) 424 InsuranceAutomobile dept 26 1% - - - - - - - - 425 Insurance Crime&Theft dept 10 1% (1,643) (2,000) (2,000) (2,000) (2,020) (2,040) (2,061) (2,081) 426 Insurance Deductible dept 14 1% - (1,000) (1,000) (1,000) (1,010) (1,020) (1,030) (1,041) 427 Insurance Errors&Omissions dept 10 1% (9,469) (10,500) (10,500) (10,500) (10,605) (10,711) (10,518) (10,926) 428 Insurance GeneralLiability dept 10 1% (5,384) (6,000) (6,000) (6,000) (6,060) (6,121) (6,152) (6,244) 429 Insurance General Liability dept 14 1% - (30) (30) (30) (30) (31) (31) (31) 430 Insurance Law Enforcement dept 10 1% (1,052) (1,160) (1,160) (1,160) (1,172) (1,183) (1,195) (1,207) 431 Insurance Property dept 10 1% (2,604) (2,875) (2,875) (2,875) (2,904) (2,933) (2,962) (2,992) 432 Insurance Property dept 14 1% (32,902) (36,200) (36,200) (36,200) (36,562) (36,925) (37,297) (37,670) 433 Intem Program dept 11 1% - - - - - - - - 434 ludge Services/Fees dept 15 1% (500) (500) (500) (500) (505) (510) (515) (520) 435 Keller Police Contract dept 14 1% - - - - - - - - 436 Keller Police Contract dept 23 1% (978,651) (987,694) (987,694) (987,694) (997,571) (1,007,547) (1,017,622) (1,027,795) 437 Landscape GW Farms dept 19 1% - - - - - - - - 438 LandscapePlanner dept 11 1% - - - - - - - - 439 Legislative dept 10 1% - (5,000) (5,000) (5,000) (5,050) (5,101) (5,152) (5,203) 440 Legislative dept 11 1/ - - - - - - - - 441 Main Bldg Cont Landscape-Civic dept 17 1% (4,086) (4,200) (4,200) (4,200) (4,242) (4,254) (4,327) (4,371) 442 MaintBldgConUanitorial dept 17 1% - (1,500) (1,500) (1,500) (1,515) (1,530) (1,545) (1,561) 443 MaintBldgSecurity dept 17 1% - (1,000) (1,000) - - - - - 444 Maint Bldg Security Monitor dept 17 1% - (1,000) (1,000) (1,000) (1,010) (1,020) (1,030) (1,041) 445 Maint.Bldg Cont Exterminator dept 17 1% (485) (1,500) (1,500) (1,500) (1,515) (1,530) (1,545) (1,561) 11 FIVE YEAR FINANCIAL FORECAST ALL MUNICIPAL FUNDS AUDITED ADOPTED REVISED � Projected Projected Projected Projected FY 19-20 FY 20-21 FY 20-21 FY 22-23 FY 23-24 FY 24-25 FY 25-26 446 Marketing&Promotions dept 17 1% - - - - - - - - 447 MiscLegal dept 10 1% - - - - - - - - 448 MiscLegal dept 11 1% - - - - - - - - 449 MiscLegal dept 13 1% (50) - - - - - - - 450 Misc.Engineering dept 11 1% - - - - - - - - 451 MobilePhone dept 11 1% (867) (660) (660) (660) (667) (673) (650) (657) 452 Mobile Phone dept 12 1% - - - - - - - - 453 Mobile Phone dept 14 1% (5,677) (6,280) (6,280) (6,280) (6,343) (6,406) (6,470) (6,535) 454 Mobile Phone dept 15 1% - - - - - - - - 455 Mobile Phone dept 17 1% (1,239) (1,085) (1,085) (1,285) (1,295) (1,311) (1,324) (1,337) 456 MobilePhone dept 20 1% (471) (585) (585) (585) (591� (597) (603) (609) 457 Mobile Phone dept 22 1% - - - - - - - - 458 MobilePhone dept 26 1% - - - - - - - - 459 Mobile Phone dept 10 1% (555) - - - - - - - 460 MovingExpense dept 11 1% (529) - - - - - - - 461 Moving Expense dept 15 1% - - - - - - - - 462 Payroll Expense dept 10 1% - - - - - - - - 463 Payroll Expense dept 11 1% - - - - - - - - 464 Payroll Expense dept 19 1% - - - - - - - - 465 Payroll Expense dept 20 1% - - - - - - - - 466 PayrollExpense dept 21 1% - (500) (500) (500) (505) (510) (515) (520) 467 PID Assessment dept 10 1% (46,759) (26,380) (26,380) (26,380) (26,644) (26,910) (27,179) (27,451) 468 PlannersFees dept 11 1% - - - - - - - - 469 Pre-EmploymentPhysicals dept 11 1% - - - - - - - - 470 Pre-Employment Physicals dept 14 1% (4,475) (3,500) (3,500) (3,500) (3,535) (3,570) (3,606) (3,642) 471 Pre-EmploymentPhysicals dept 15 1% - - - - - - - - 472 Pre-Employmenttesting dept 11 1% - - - - - - - - 473 Pre-Employmenttesting dept 14 1% (2,843) (3,000) (3,000) (3,000) (3,030) (3,060) (3,091) (3,122) 474 Pre-Employmenttesting dept 15 1% - - - - - - - - 475 Pre-Employmenttesting dept 18 1% - - - - - - - - 476 Pre-Employmenttesting dept 21 1% - (300) (300) (300) (303) (306) (309) (312) 477 Printing dept 10 1% - - - - - - - - 478 Printing dept 11 1% - - - - - - - - 479 Printing dept 12 1% - (3,750) (3,750) (3,750) (3,7SS) (3,525) (3,564) (3,902) 480 Printing dept 13 1% - - - - - - - - 481 Printing dept 14 1% (336) (610) (610) (610) (616) (622) (625) (635) 482 Printing dept 15 1% (819) (1,200) (1,200) (1,200) (1,212) (1,224) (1,236) (1,249) 483 Printing dept 15 1% - - - - - - - - 484 Printing dept 16 1% - - - - - - - - 485 Printing dept 17 1% (168) (25) (25) (25) (25) (26) (26) (26) 486 Printing dept 18 1% - (600) (600) (600) (606) (612) (618) (624) 487 Printing dept 19 1% - (1,500) (1,500) (1,500) (1,515) (1,530) (1,545) (1,561) asa Printing aePe u v - �soo) �soo) �soo) (sos� (sio� (sis� (szo� 489 Printing dept 22 1% (210) (225) (225) (225) (227) (230) (232) (234) 490 Printing dept 26 1% - - - - - - - - 491 PrintingCovid-19 dept 19 1% (685) - - - - - - - 492 PropertyTaxAppraisalFees dept 10 1% (12,289) (15,260) (15,260) (15,260) (15,413) (15,567) (15,722) (15,SS0) 493 Rewrds Management dept 10 1% (34,145) (44,825) (44,825) (75,325) (76,075) (76,539) (77,607) (78,383) 494 RewrdsManagement dept 11 1% - - - - - - - - 495 Rewrds Management dept 13 1% - (3,265) (3,265) (3,265) (3,295) (3,331) (3,364) (3,398) 496 ResidentAppreciation dept 10 1% (116) (10,000) (10,000) (10,000) (10,100) (10,201) (10,303) (10,406) 497 Resident Survey dept 10 1% - (10,000) (10,000) (10,000) (10,100) (10,201) (10,303) (10,406) 498 Resident5urvey dept 11 1/ - - - - - - - - 499 Row Tree Removal dept 16 1% (1,600) (1,875) (1,875) (1,875) (1,594) (1,913) (1,932) (1,951) 500 Sanitation/Waste Removal dept 17 1% (750) (1,075) (1,075) (1,075) (1,OS6) (1,097) (1,108) (1,119) soi se�u��cy dePe i4 v - �z,000) �z,000) �z,000) (z,ozo� (z,oao� (z,oei� (z,osi� soz se�u��cy dePe is v �zi4) �soo) �soo) �soo) (sos� (sio� (sis� (szo� 503 Security Expense dept 15 1% (5,896) (600) (600) (600) (606) (612) (615) (624) 504 Spec Event-Employee Retir dept 10 1% - (2,500) (2,500) (2,500) (2,525) (2,550) (2,576) (2,602) 505 Special Events dept 11 1% - - - - - - - - 506 Special Events dept 18 1% - - - - - - - - 507 SpecialEvents dept 19 1% (116) (3,000) (3,000) (3,000) (3,030) (3,060) (3,091) (3,122) 508 SpecialEvents-Employee Apprec dept 10 1% (23,457) (20,000) (20,000) (20,000) (20,200) (20,402) (20,606) (20,512) 509 Sponshorship Expense dept 10 1% - - - - - - - - 510 Street Drainage dept 16 1% (39,132) (45,000) (45,000) (45,000) (45,450) (45,905) (46,364) (46,827) 511 STW Software Maintenance dept 10 1% - (18,000) - (18,000) (iS,1S0) (15,362) (15,545) (18,731) 512 STW Software Maintenance dept 18 1% (7,168) (7,000) (7,000) (7,000) (7,070) (7,141) (7,212) (7,284) 513 STW Software Maintenance dept 20 1% (1,117) (4,015) (1,015) (4,015) (4,055) (4,096) (4,137) (4,178) 514 STW Software Maintenance dept 21 1% (2,050) (2,500) - (2,500) (2,525) (2,550) (2,576) (2,602) 515 System Admin&Support Service dept 20 1% - (32,615) (32,615) (57,615) (SS,191) (SS,773) (59,361) (59,954) 516 Technology Consultant-IT Fee dept 20 1% - - - - - - - - 517 Town-SecurityExpense dept 17 1% - (400) (400) - - - - - 518 Town Contract Carpet Cleaning dept 17 1% - (2,000) (2,000) (2,000) (2,020) (2,040) (2,061) (2,OS1) 519 Town ContracUanitorial5ery dept 17 1% (1,390) (15,000) (15,000) (6,000) (6,060) (6,121) (6,182) (6,244) 520 Town ContracUanitorial5ery(COVID-19) dept 17 1% (16,416) - - - - - - - 521 Town Contract Landscape-Civic dept 17 1% (3,111) (3,000) (3,000) (3,000) (3,030) (3,060) (3,091) (3,122) 522 Town Contract Security Monitor dept 17 1% - (1,000) (1,000) (1,000) (1,010) (1,020) (1,030) (1,041) 523 Town Contract Services dept 17 1% (1,120) (10,500) (10,500) (10,500) (10,605) (10,711) (10,S1S) (10,926) 524 TownContractSweeping/Washing dept 17 1% - - - - - - - - 12 FIVE YEAR FINANCIAL FORECAST ALL MUNICIPAL FUNDS AUDITED ADOPTED REVISED � Projected Projected Projected Projected FY 19-20 FY 20-21 FY 20-21 FY 22-23 FY 23-24 FY 24-25 FY 25-26 525 Town Contract Window Cleaning dept 17 1% - (300) (300) (300) (303) (306) (309) (312) 526 TownExterminatorService dept 17 1% (315) (300) (300) (300) (303) (306) (309) (312) 527 Town Security Expense dept 10 1% - - - - - - - - 528 Traffic5ervices dept 11 1% - - - - - - - - 529 Traffic5ervices dept 16 1% - - - (3,000) (3,030) (3,060) (3,091) (3,122) 530 Tree Farm Expense dept 19 1% - - - (50,000) (50,500) (51,005) (51,515) (52,030) 531 Tree Mitigation Expense dept 12 1% (5,540) - - - - - - - 532 WebsiteDevelopment/Maintenanc dept 20 1% (6,167) (6,000) (6,000) ��,000) (7,070) (7,141) (7,212) (7,284) 533 WestlakeAcademyFoundation dept 10 1% (66,601) (67,920) (67,920) (67,920) (68,599) (69,285) (69,978) (70,678) 534 Total Service Expenditures (2,265,509) (2,469,386) (2,420,586) (2,615,096) (2,641,247) (2,667,659) (2,694,336) (2,721,279) 535 Books&Printed Materials dept 15 1% - (300) (300) (300) (303) (306) (309) (312) 536 Market&Promotions dept 14 1% - - - - - - - - 537 BuildingSupplies dept 26 1% - - - - - - - - 538 Building Supplies dept 10 1% (5,321) (7,000) (7,000) (7,000) (7,070) (7,141) (7,212) (7,284) 539 Building Supplies dept 17 1% - (1,000) (1,000) (1,000) (1,010) (1,020) (1,030) (1,041) 540 Building Supplies dept 17 1% (15) (1,000) (1,000) (1,000) (1,010) (1,020) (1,030) (1,041) 541 Building Supplies dept 17 1% (281) (2,000) (2,000) (2,000) (2,020) (2,040) (2,061) (2,081) 542 Building Supplies dept 17 1% (147) (1,070) (1,070) (3,500) (3,535) (3,570) (3,606) (3,642) 543 ChemicalSupplies dept 26 1/ - - - - - - - - 544 ChemicalSupplies dept 17 1/ - (1,000) (1,000) (1,000) (1,010) (1,020) (1,030) (1,041) 545 Cleaning Supplies dept 14 1% (2,613) (5,000) (5,000) (5,000) (5,050) (5,101) (5,152) (5,203) 546 Cleaning Supplies dept 15 1% - (100) (100) (100) (101) (102) (103) (104) 547 Cleaning5upplies dept 26 1% - - - - - - - - 548 Cleaning Supplies dept 17 1% - (500) (500) (500) (505) (510) (515) (520) 549 Cleaning Supplies dept 17 1% - (325) (325) (325) (325) (332) (335) (338) 550 Communication Supplies dept 17 1% - - - - - - - - 551 ComputerEqpmt/Software dept 10 1% (19) - - - - - - - 552 ComputerEqpmt/Software dept 11 1% (2,043) (1,000) (1,000) (1,000) (1,010) (1,020) (1,030) (1,041) 553 ComputerEqpmt/Software dept 12 1% (12,240) (18,600) (18,600) (18,600) (1S,7S6) (15,974) (19,164) (19,355) 554 ComputerEqpmt/Software dept 13 1% (870) (870) (1,870) (870) (579) (SS7) (596) (905) 555 ComputerEqpmt/Software dept 14 1% (5,196) (11,325) (11,325) (17,335) (17,SOS) (17,653) (17,560) (18,039) 556 ComputerEqpmt/Software dept 15 1% - (1,000) (1,000) (1,000) (1,010) (1,020) (1,030) (1,041) 557 ComputerEqpmt/Software dept 15 1% (85) (540) (540) (540) (545) (551) (556) (562) 558 ComputerEqpmt/Software dept 16 1% (1,976) (1,980) (1,980) (30,000) (30,300) (30,603) (30,909) (31,218) 559 ComputerEqpmt/Software dept 18 1% (1,920) - - (4,000) (4,040) (4,OS0) (4,121) (4,162) 560 ComputerEqpmt/Software dept 19 1% - (2,500) (2,500) (2,500) (2,525) (2,550) (2,576) (2,602) 561 ComputerEqpmt/Software dept 20 1% (13,540) (5,110) (5,110) (7,500) (7,575) (7,651) (7,727) (7,805) 562 ComputerEqpmt/Software dept 21 1% (2,148) (2,000) (2,000) (5,500) (5,555) (5,611) (5,667) (5,723) 563 ComputerEqpmt/Software dept 22 1% (1,800) (2,500) (2,500) (6,000) (6,060) (6,121) (6,182) (6,244) 564 ComputerEqpmt/Software dept 17 1% (574) (1,875) (1,875) (1,875) (1,594) (1,913) (1,932) (1,951) 565 Copier R&M/Supplies/Copy/Tax dept 10 1% (1,978) (15,000) (15,000) (15,000) (15,150) (15,302) (15,455) (15,609) 566 CopierR&M/Supplies/Copy/Tax dept 11 1/ - - - - - - - - 567 CopierR&M/Supplies/Copy/Tax dept 13 1% - - - - - - - - 568 CopierR&M/Supplies/Copy/Tax dept 14 1/ (1,424) - - - - - - - 569 CopierR&M/Supplies/Copy/Tax dept 15 1/ - - - - - - - - 570 Council Meeting Expense dept 11 1% - - - - - - - - 571 Donations dept 11 1% - - - - - - - - 572 Electrical5upplies dept 26 1/ - - - - - - - - 573 ElectricalSupplies dept 17 1% (21) (1,000) (1,000) (1,000) (1,010) (1,020) (1,030) (1,041) 574 ElectricalSupplies dept 17 1% - (440) (440) (440) (444) (449) (453) (458) 575 Facility Supplies dept 14 1% (7,237) (10,000) (9,180) (10,000) (10,100) (10,201) (10,303) (10,406) 576 Facility5upplies dept 26 1% - - - - - - - - 577 Fencing Supplies dept 17 1% - (1,000) (1,000) (1,000) (1,010) (1,020) (1,030) (1,041) 578 Firefighter5upplies dept 14 1% (3,966) (4,600) (4,600) (4,600) (4,646) (4,692) (4,739) (4,787) 579 Ground Supplies dept 17 1% (3,630) (5,000) �s,000) (5,000) (5,050) (5,101) (5,152) (5,203) 580 GroundSupplies dept 26 1% - - - - - - - - 581 Ground Supplies dept 17 1% - (1,300) (1,300) (1,300) (1,313) (1,326) (1,339) (1,353) 582 GroundSupplies dept 17 1% (785) (628) (628) (628) (634) (641) (647) (653) 583 Hospitalityltems dept 11 1% (252) - - - - - - - 584 Hospitalityltems dept 14 1% (1,108) (1,000) (1,000) (1,000) (1,010) (1,020) (1,030) (1,041) 585 Hospitalityltems dept 15 1% (582) (500) (500) (500) (505) (510) (515) (520) 586 Hospitality Items dept 15 1% - - - - - - - - 587 Hospitalityltems dept 17 1% (75) (1,000) (1,000) (1,000) (1,010) (1,020) (1,030) (1,041) 588 Hospitalityltems dept 19 1% - - - (1,200) (1,212) (1,224) (1,236) (1,249) 589 Hospitalityltems dept 21 1% (1,359) (1,000) (1,000) (1,000) (1,010) (1,020) (1,030) (1,041) 590 Hospitalityltems dept 22 1% - - - - - - - - 591 HVACSupplies dept 17 1% (92) (1,000) (1,000) (1,000) (1,010) (1,020) (1,030) (1,041) 592 HVACSupplies dept 26 1% - - - - - - - - 593 HVACSupplies dept 17 1% - (750) (750) (750) (755) (765) (773) (780) 594 HVACSupplies dept 17 1% - (800) (800) (800) (SOS) (516) (824) (832) 595 Lamp/BulbSupplies dept 17 1% - (1,500) (1,500) (1,500) (1,515) (1,530) (1,545) (1,561) 596 Lamp/BulbSupplies dept 26 1% - - - - - - - - 597 Lamp/Bulb Supplies dept 17 1% - (1,000) (1,000) (1,000) (1,010) (1,020) (1,030) (1,041) 598 Lamp/Bulb Supplies dept 17 1% - (315) (315) (315) (315) (321) (325) (328) 599 Medical5upplies dept 14 1% (15,773) (14,615) (14,615) (14,615) (14,761) (14,909) (15,058) (15,208) 600 Meeting Expense dept 10 1% (3,677) (5,500) (5,500) (5,500) (5,555) (5,611) (5,667) (5,723) 601 Meeting Expense dept 12 1% - (125) (125) (125) (126) (128) (129) (130) 602 MeetingExpense dept 13 1% - - - - - - - - 13 FIVE YEAR FINANCIAL FORECAST ALL MUNICIPAL FUNDS AUDITED ADOPTED REVISED � Projected Projected Projected Projected FY 19-20 FY 20-21 FY 20-21 FY 22-23 FY 23-24 FY 24-25 FY 25-26 603 MiscHandTools dept 17 1% - (500) (500) (1,000) (1,010� (1,020) (1,030) (1,041) 604 MiscHandTools dept 12 1% - - - - - - - - 605 MiscHandTools dept 14 1% (36) (350) (350) (350) (354) (357) (361) (364) 606 MiscHandTools dept 16 1% (1,329) (750) (750) (750) (755) (765) (773) (750) 607 MiscHandTools dept 26 1% - - - - - - - - 608 Misc Hand Tools dept 17 1% (424) (600) (600) (600) (606) (612) (615) (624) 609 Misc.Expense dept 10 1% (8,548) (8,000) (8,000) (8,000) (S,OSO) (5,161) (5,242) (8,325) 610 Misc.Expense dept 11 1% - - - - - - - - 611 Misc.Expense dept 12 1% - - - - - - - - 612 Misc.Expense dept 13 1% - (100) (100) (100) (101) (102) (103) (104) 613 Misc.Expense dept 14 1% - (300) (300) (300) (303) (306) (309) (312) 614 Misc.Expense dept 15 1% - - - - - - - - 615 Misc.Expense dept 16 1% (164) (40) (40) (40) (40) (41) (41) (42) 616 Misc.Expense dept 17 1% (211) (435) (435) (435) (439) (444) (445) (453) 617 Misc.Expense dept 18 1% - - - - - - - - 618 Misc.Expense dept 19 1% - - - - - - - - 619 Misc.Expense dept 21 1% - (50) (50) (50) (51) (51) (52) (52) 620 Misc.Expense dept 26 1% - - - - - - - - 621 Misc.Supplies dept 14 1% - (50) (50) (50) (51) (51) (52) (52) 622 Misc.Supplies dept 15 1% - (500) (500) (500) (505) (510) (515) (520) 623 Office Equipment dept 12 1% - - - - - - - - 624 Office Equipment dept 18 1% - - - - - - - - 625 Office Fumiture dept 12 1% - - - - - - - - 626 Office Fumiture dept 21 1% - - - - - - - - 627 Office Supplies dept 10 1% (3,184) (6,500) (6,500) (6,500) (6,565) (6,631) (6,697) (6,764) 628 Office Supplies dept 11 1% (177) (750) (750) (750) (755) (765) (773) (780) 629 Office Supplies dept 12 1% (873) (1,800) (1,800) (1,800) (1,518) (1,836) (1,855) (1,873) 630 Office Supplies dept 13 1% (421) (1,000) (1,000) (1,000) (1,010) (1,020) (1,030) (1,041) 631 Office Supplies dept 14 1% (1,847) (2,500) (2,500) (2,500) (2,525) (2,550) (2,576) (2,602) 632 Office Supplies dept 15 1% (1,283) (3,000) (3,000) (2,000) (2,020) (2,040) (2,061) (2,081) 633 Office5upplies dept 15 1% (55) (1,370) (1,370) (200) (202) (204) (206) (208) 634 Office Supplies dept 15 1% - (200) (200) (200) (202) (204) (206) (208) 635 Office5upplies dept 16 1% (397) (585) (585) (585) (591) (597) (603) (609) 636 Office Supplies dept 18 1% (1,136) (2,750) (2,750) (2,750) (2,778) (2,805) (2,833) (2,862) 637 Office5upplies dept 19 1% - (45) (45) (45) (45) (46) (46) (47) 638 Office5upplies dept 20 1% (5,717) (2,020) (2,020) (3,520) (3,555) (3,591) (3,627) (3,663) 639 Office5upplies dept 21 1% - (1,000) (1,000) (1,000) (1,010) (1,020) (1,030) (1,041) 640 Office5upplies dept 22 1% (546) (400) (400) (400) (404) (405) (412) (416) 641 Office5upplies dept 26 1% - - - - - - - - 642 Office Supplies dept 17 1% (121) (410) (410) (410) (414) (415) (422) (427) 643 Painting Supplies dept 17 1% - (1,000) (1,000) (1,000) (1,010) (1,020) (1,030) (1,041) 644 Painting5upplies dept 18 1% - - - - - - - - 645 Painting Supplies dept 19 1% - (1,500) (1,500) (1,500) (1,515) (1,530) (1,545) (1,561) 646 Painting5upplies dept 26 1% - - - - - - - - 647 Painting Supplies dept 17 1% (183) (375) (375) (375) (379) (353) (356) (390) 648 Postage&Supplies dept 12 1% - - - - - - - - 649 Postage&Supplies dept 10 1% (1,073) (1,225) (1,225) (1,225) (1,237) (1,250) (1,262) (1,275) 650 Postage&Supplies dept 11 1% - - - - - - - - 651 Postage&Supplies dept 13 1% - - - - - - - - 652 Postage&Supplies dept 14 1% (130) (260) (260) (260) (263) (265) (265) (271) 653 Postage&Supplies dept 15 1% (2,180) (4,000) (4,000) (4,000) (4,040) (4,080) (4,121) (4,162) 654 Postage&Supplies dept 17 1% (33) (35) (35) (35) (35) (36) (36) (36) 655 Postage&Supplies dept 18 1% - - - - - - - - 656 Postage&Supplies dept 19 1% - - - - - - - - 657 RecreationSupplies dept 19 1% - (2,500) (2,500) (2,500) (2,525) (2,550) (2,576) (2,602) 658 Safety Supplies dept 14 1% (1,295) (2,175) (2,175) (2,175) (2,197) (2,219) (2,241) (2,263) 659 Safety5upplies dept 17 1% - (500) (500) (500) (505) (510) (515) (520) 660 Safety5upplies dept 26 1% - - - - - - - - 661 Safety5upplies dept 17 1% - (140) (140) (140) (141) (143) (144) (146) 662 Sanitation Supplies dept 17 1% (470) - - - - - - - 663 Security Supplies dept 17 1% - (2,500) (2,500) (2,500) (2,525) (2,550) (2,576) (2,602) 664 Security Supplies dept 17 1% - (1,800) (1,800) (800) (SOS) (516) (524) (532) 665 SecuritySupplies dept 26 1% - - - - - - - - 666 Security Supplies dept 17 1% (400) (500) (500) (500) (505) (510) (515) (520) 667 Special Events dept 22 1% - - - - - - - - 668 StreetSupplies dept 16 1% - - - - - - - - 669 Uniforms dept 10 1% - - - - - - - - 670 Uniforms dept 11 1% - - - - - - - - 671 Uniforms dept 12 1% (401) (500) (500) (500) (505) (510) (515) (520) 672 Uniforms dept 13 1% - (100) (100) (100) (101) (102) (103) (104) 673 Uniforms dept 14 1% (36,959) (35,000) (35,000) (35,000) (35,350) (35,704) (36,061) (36,421) 674 Uniforms dept 15 1% (253) (400) (400) (400) (404) (405) (412) (416) 675 Uniforms dept 15 1% (1,254) (1,500) (1,500) (1,500) (1,515) (1,530) (1,545) (1,561) 676 Uniforms dept 15 1% - (300) (300) (300) (303) (306) (309) (312) 677 Uniforms dept 16 1% (787) (600) (600) (850) (559) (567) (576) (SSS) 678 Uniforms dept 17 1% (306) (500) (500) (500) (505) (510) (515) (520) 679 Uniforms dept 18 1% - - - - - - - - 680 Uniforms dept 19 1% - (500) (500) (800) (SOS) (516) (824) (832) sai u��rorms dePe zo v - �soo) �soo) �soo) (sos� (sio� (sis� (szo� 14 FIVE YEAR FINANCIAL FORECAST ALL MUNICIPAL FUNDS AUDITED ADOPTED REVISED � Projected Projected Projected Projected FY 19-20 FY 20-21 FY 20-21 FY 22-23 FY 23-24 FY 24-25 FY 25-26 ssz u��rorms dePe zi ii - �ioo) �ioo) �ioo) (ioi� (ioz� (ios� (ioa� 683 Uniforms dept 22 1% - - - - - - - - 684 Uniforms dept 26 1% - - - - - - - - 685 Vehide Fuel dept 10 1% - - - - - - - - 686 VehideFuel dept 11 1% - - - - - - - - 687 Vehide Fuel dept 12 1% - - - - - - - - 688 Vehide Fuel dept 14 1% (13,034) (20,000) (17,260) (17,260) (17,433) (17,607) (17,753) (17,961) 689 VehideFuel dept 15 1% (686) - - - - - - - 690 Vehide Fuel dept 15 1% (584) (1,650) (1,650) (1,650) (1,667) (1,683) (1,700) (1,717) 691 Vehide Fuel dept 16 1% (3,497) (2,510) (2,510) (4,500) (4,545) (4,590) (4,636) (4,653) 692 Vehide Fuel dept 17 1% (403) (1,500) (1,500) (1,500) (1,515) (1,530) (1,545) (1,561) 693 Vehide Fuel dept 19 1% (697) (1,500) (1,500) (1,500) (1,515) (1,530) (1,545) (1,561) 694 Vehide Fuel dept 26 1% - - - - - - - - 695 Warning Devices dept 16 1% - - - - - - - - 696 WaterTreatmentSupplies dept 17 1% (1,059) (100) (100) (100) (101) (102) (103) (104) 697 Weapons/Accessories dept 14 1% - - - - - - - - 698 Westlake Academy Expense dept 22 1% - (9,600) (9,600) (9,600) (9,696) (9,793) (9,891) (9,990) 699 Marketing dept 15 0% - - - (550) (550) (550) (550) (550) 700 Weapons dept 15 0% - - - (400) (400) (400) (400) (400) 701 OfficeSupplies dept 18 0% (140) - - - - - - - 702 Postage&Supplies dept 11 0% (21) - - - - - - - 703 CleaningSupplies-COVID-19 dept 14 0% (1,111) - - - - - - - 7p4 MedicalSupplies-COVID-19 dept 14 0% (1,825) - - - - - - - 705 OfficeSupplies-COVID-19 dept 15 0% (105) - - - - - - - 706 Office5upplies-COVID-19 dept 22 0% (49) - - - - - - - 707 Town Cleaning Supplies(COVID-19) dept 17 0% (7) - - - - - - - 7p8 Town Safety5upplies(COVID-19) dept 17 0% (184) - - - - - - - 7pg Maint.Bldg Supplies(COVID-19) dept 17 0% (816) - - - - - - - 710 Town Office Supplies(COVID-19) dept 17 0% (37) - - - - - - - 711 Computer Equipment/Software(COVID-19) dept 20 0% (13,653) - - - - - - - 712 Total Supply Expenditures (202,844) (268,043) (265,483) (318,673) (321,850� (325,059) (328,300) (331,574) 713 Association Dues dept 11 1% - - - - - - - - 714 CVB Membership dept 11 1% - - - - - - - - 715 Spousal Travel Allowance dept 11 1% (421) (5,000) (5,000) (5,000) (5,050) (5,101) (5,152) (5,203) 716 Travel Airfare dept 10 1% - - - - - - - - 717 Travel Airfare dept 11 1% (901) (2,000) (2,000) (2,000) (2,020) (2,040) (2,061) (2,OS1) 718 Travel Airfare dept 12 1% - - - - - - - - 719 Travel Airfare dept 13 1% - (200) (200) (200) (202) (204) (206) (205) 720 Travel Airfare dept 14 1% (405) (2,050) (2,050) (2,050) (2,071) (2,091) (2,112) (2,133) 721 Travel Airfare dept 15 1% - (200) (200) (800) (808) (816) (824) (532) 722 Travel Airfare dept 15 1% - - - - - - - - 723 Travel Airfare dept 15 1% - - - - - - - - 724 Travel Airfare dept 16 1% - - - (2,000) (2,020) (2,040) (2,061) (2,OS1) 725 Travel Airfare dept 18 1% (1,419) (1,300) (1,300) (1,300) (1,313) (1,326) (1,339) (1,353) 726 Travel Airfare dept 21 1% - (600) (600) (600) (606) (612) (618) (624) 727 Travel Airfare dept 22 1% - (250) (250) (250) (253) (255) (258) (260) 728 Travel Car Rental/Parking dept 10 1% - - - - - - - - 729 Travel Car Rental/Parking dept 11 1% (554) (1,000) (1,000) (1,000) (1,010) (1,020) (1,030) (1,041) 730 Travel Car Rental/Parking dept 12 1% - (25) (25) (25) (25) (26) (26) (26) 731 Travel Car Rental/Parking dept 13 1% (61) (65) (65) (65) (66) (66) (67) (6S) 732 TravelCarRental/Parking dept 14 1% (16) (570) (570) (570) (576) (581) (587) (593) 733 TravelCarRental/Parking dept 15 1% (15) (200) (200) (200) (202) (204) (206) (205) 734 Travel Car Rental/Parking dept 15 1% - - - - - - - - 735 Travel Car Rental/Parking dept 15 1% - - - - - - - - 736 TravelCarRental/Parking dept 16 1% (101) (60) (60) (500) (505) (510) (515) (520) 737 Travel Car Rental/Parking dept 17 1% - (1,125) (1,125) (1,125) (1,136) (1,148) (1,159) (1,171) 738 TravelCarRental/Parking dept 18 1% (227) (100) (100) (300) (303) (306) (309) (312) 739 TravelCarRental/Parking dept 21 1% - (300) (300) (300) (303) (306) (309) (312) 740 Travel Car Rental/Parking dept 22 1% (70) (276) (276) (276) (D9) (282) (284) (257) 741 Travel Car Rental/Parking dept 26 1% - - - - - - - - 742 Travel Lodging dept 10 1% - - - - - - - - 743 Travel Lodging dept 11 1% (3,074) (5,000) (5,000) (5,000) (5,050) (5,101) (5,152) (5,203) 744 TravelLodging dept 12 1% - (100) (100) (100) (101) (102) (103) (104) 745 TravelLodging dept 13 1% (414) (540) (540) (540) (545) (551) (556) (562) 746 Travel Lodging dept 14 1% (1,599) (1,365) (1,865) (1,865) (1,884) (1,902) (1,922) (1,941) 747 Travel Lodging dept 15 1% (426) (1,500) (1,500) (1,500) (1,515) (1,530) (1,545) (1,561) 748 Travel Lodging dept 15 1% - - - - - - - - 749 TravelLodging dept 15 1% - (150) (150) (150) (152) (153) (155) (156) 750 Travel Lodging dept 16 1% (309) (450) (450) (2,000) (2,020) (2,040) (2,061) (2,081) 751 Travel Lodging dept 17 1% (78) (1,500) (1,500) (1,500) (1,515) (1,530) (1,545) (1,561) 752 Travel Lodging dept 18 1% (314) (1,720) (1,720) (1,720) (1,737) (1,755) (1,772) (1,790) 753 Travel Lodging dept 19 1% (381) (2,000) (2,000) (2,000) (2,020) (2,040) (2,061) (2,OS1) 754 Travel Lodging dept 20 1% - (1,350) (1,350) (1,350) (1,364) (1,377) (1,391) (1,405) 755 Travel Lodging dept 21 1% - (500) (500) (500) (505) (510) (515) (520) 756 TravelLodging dept 22 1% (499) (901) (901) (901) (910) (919) (928) (938) 757 Travel Meals dept 10 1% (594) - - - - - - - 758 Travel Meals dept 11 1% (1,115) (1,900) (1,900) (1,900) (1,919) (1,935) (1,955) (1,977) 759 Travel Meals dept 12 1% (78) (250) (250) (250) (253) (255) (258) (260) 15 FIVE YEAR FINANCIAL FORECAST ALL MUNICIPAL FUNDS AUDITED ADOPTED REVISED � Projected Projected Projected Projected FY 19-20 FY 20-21 FY 20-21 FY 22-23 FY 23-24 FY 24-25 FY 25-26 760 Travel Meals dept 13 1% (53) (100) (100) (100) (101) (102) (103) (104) 761 Travel Meals dept 14 1% (571) (600) (600) (600) (606) (612) (615) (624) 762 Travel Meals dept 15 1% (164) (850) (850) (1,550) (1,566) (1,SS1) (1,597) (1,613) 763 Travel Meals dept 15 1% (25) - - (200) (202) (204) (206) (208) 764 Travel Meals dept 15 1% - (200) (200) (200) (202) (204) (206) (208) 765 Travel Meals dept 17 1% (436) (1,830) (1,830) (1,830) (1,S4S) (1,567) (1,585) (1,904) 766 Travel Meals dept 18 1% (139) (345) (345) (345) (345) (352) (355) (359) 767 Travel Meals dept 20 1% (31) (115) (115) (115) (116) (117) (118) (120) 768 Travel Meals dept 21 1% - (300) (300) (300) (303) (306) (309) (312) 769 Travel Meals dept 22 1% (183) (300) (300) (300) (303) (306) (309) (312) 770 Travel Meals dept 26 1% - - - - - - - - 771 Travel Mileage dept 10 1% (142) (450) (450) (450) (455) (459) (464) (468) 772 Travel Mileage dept 11 1% 32 - - - - - - - 773 Travel Mileage dept 12 1% (201) (200) (200) (200) (202) (204) (206) (208) 774 Travel Mileage dept 13 1% - (200) (200) (200) (202) (204) (206) (208) 775 Travel Mileage dept 14 1% - (1,005) (505) (505) (510) (515) (520) (526) 776 Travel Mileage dept 15 1% (326) (950) (950) (1,940) (1,959) (1,979) (1,999) (2,019) 777 Travel Mileage dept 15 1% - - - - - - - - 778 Travel Mileage dept 15 1% - (460) (460) (460) (465) (469) (474) (479) 779 Travel Mileage dept 17 1% (495) (2,315) (2,315) (2,315) (2,335) (2,362) (2,385) (2,409) 780 Travel Mileage dept 18 1% - (375) (375) (600) (606) (612) (618) (624) 781 Travel Mileage dept 19 1% - - - - - - - - 782 Travel Mileage dept 20 1% (626) (1,000) (1,000) (1,000) (1,010) (1,020) (1,030) (1,041) 783 Travel Mileage dept 21 1% - (150) (150) (150) (152) (153) (155) (156) 784 Travel Mileage dept 22 1% (690) (700) (700) (700) (707) (714) (721) (728) 785 Travel Mileage dept 26 1% - - - - - - - - 786 LEAD HPO Training dept 10 1% (242) (25,000) (25,000) (25,000) (25,250) (25,503) (25,755) (26,015) 787 TraininglSeminars/Meetings dept 10 1% (8,211) (10,000) (10,000) (10,000) (10,100) (10,201) (10,303) (10,406) 788 TraininglSeminars/Meetings dept 11 1% (5,526) (10,000) (10,000) (10,000) (10,100) (10,201) (10,303) (10,406) 789 TraininglSeminars/Meetings dept 12 1% (1,095) (2,000) (2,000) (2,000) (2,020) (2,040) (2,061) (2,081) 790 TraininglSeminars/Meetings dept 13 1% (690) (1,450) (7,450) (1,450) (1,465) (1,479) (1,494) (1,509) 791 TraininglSeminars/Meetings dept 14 1% (11,450) (16,800) (16,800) (16,800) (16,965) (17,135) (17,309) (17,482) 792 TraininglSeminars/Meetings dept 15 1% (715) (500) (500) (1,600) (1,616) (1,632) (1,645) (1,665) 793 TraininglSeminars/Meetings dept 15 1% (245) (515) (515) (515) (520) (525) (531) (536) 794 TraininglSeminars/Meetings dept 15 1% (55) (375) (375) (375) (379) (353) (386) (390) 795 TraininglSeminars/Meetings dept 16 1% (1,045) (1,450) (1,450) (2,500) (2,525) (2,550) (2,576) (2,602) 796 TraininglSeminars/Meetings dept 17 1% (866) (2,000) (2,000) (2,000) (2,020) (2,040) (2,061) (2,081) 797 TraininglSeminars/Meetings dept 18 1% (2,824) (5,000) (5,000) (5,000) (5,050) (5,101) (5,152) (5,203) 798 TraininglSeminars/Meetings dept 19 1% (140) (2,000) (2,000) (2,000) (2,020) (2,040) (2,061) (2,081) 799 TraininglSeminars/Meetings dept 20 1% (1,810) (6,500) (6,500) (8,000) (S,OSO) (8,161) (8,242) (8,325) 800 TraininglSeminars/Meetings dept 21 1% (285) (6,000) (6,000) (6,800) (6,S6S) (6,937) (7,006) (7,076) 801 TraininglSeminars/Meetings dept 22 1% (1,265) (3,000) (3,000) (3,800) (3,538) (3,876) (3,915) (3,954) 802 TraininglSeminars/Meetings dept 26 1% - - - - - - - - 803 Prevention&Education dept 14 1% (1,349) (2,000) (2,000) (2,000) (2,020) (2,040) (2,061) (2,081) 804 Dues&Subscriptions dept 10 1% (1,354) (5,350) (5,350) (5,350) (5,404) (5,458) (5,512) (5,567) 805 Dues&Subscriptions dept 11 1% (8,095) (7,000) (7,000) (7,000) (7,070) (7,141) (7,212) (7,284) 806 Dues&Subscriptions dept 12 1% (1,738) (1,600) (1,600) (1,600) (1,616) (1,632) (1,648) (1,665) 807 Dues&Subscriptions dept 13 1% (200) (690) (690) (690) (697) (704) (711) (718) 808 Dues&Subscriptions dept 14 1% (28,177) (31,000) (31,000) (31,000) (31,310) (31,623) (31,939) (32,259) 809 Dues&Subscriptions dept 15 1% (235) (200) (312) (400) (404) (408) (412) (416) 810 Dues&Subscriptions dept 15 1% (38) (1,195) (1,083) (490) (495) (500) (505) (510) 811 Dues&Subscriptions dept 15 1% - (100) (100) (100) (101) (102) (103) (104) 812 Dues&Subscriptions dept 16 1% (635) (581) (581) (581) (SS7) (593) (599) (605) 813 Dues&Subscriptions dept 17 1% (285) (1,000) (1,000) (1,000) (1,010) (1,020) (1,030) (1,041) 814 Dues&Subscriptions dept 18 1% (6,324) (1,700) (6,500) (6,500) (6,565) (6,631) (6,697) (6,764) 815 Dues&Subscriptions dept 19 1% (555) (1,000) (1,000) (2,250) (2,273) (2,295) (2,318) (2,341) 816 Dues&Subscriptions dept 20 1% (739) (650) (650) (650) (657) (663) (670) (676) 817 Dues&Subscriptions dept 21 1% (4,310) (9,000) (10,000) (9,000) (9,090) (9,151) (9,273) (9,365) 818 Dues&Subscriptions dept 22 1% (946) (1,000) (1,000) (1,000) (1,010) (1,020) (1,030) (1,041) 819 Dues&Subscriptions dept 26 1% - - - - - - - - 820 Books&Printed Materials dept 10 1% (49) (2,055) (2,055) (2,055) (2,076) (2,096) (2,117) (2,138) 821 Books&Printed Materials dept 11 1% (800) (150) (150) (150) (152) (153) (155) (156) 822 Books&Printed Materials dept 12 1% - (350) (350) (350) (354) (357) (361) (364) 823 Books&Printed Materials dept 13 1% (59) (550) (550) (550) (556) (561) (567) (572) 824 Books&Printed Materials dept 14 1% (617) (875) (875) (875) (SS4) (593) (902) (911) 825 Books&Printed Materials dept 15 1% - - - - - - - - 826 Books&Printed Materials dept 15 1% - - - - - - - - 827 Books&Printed Materials dept 16 1% - - - - - - - - 828 Books&Printed Materials dept 17 1% - (500) (500) (500) (505) (510) (515) (520) 829 Books&Printed Materials dept 18 1% (1,543) (1,350) (935) (1,350) (1,364) (1,377) (1,391) (1,405) 830 Books&Printed Materials dept 21 1% (170) (350) (350) (350) (354) (357) (361) (364) 831 Books&Printed Materials dept 22 1% (180) (200) (200) (200) (202) (204) (206) (208) 832 Books&Printed Materials dept 26 1% - - - - - - - - 833 Licenses/RegisVations dept 10 1% - - - - - - - - 834 Licenses/RegisVations dept 11 1% (1) - - - - - - - 835 Licenses/RegisVations dept 12 1% - - - - - - - - 836 Licenses/RegisVations dept 13 1% (97) (150) (150) (150) (152) (153) (155) (156) 837 Licenses/RegisVations dept 14 1% (3,046) (2,570) (3,570) (4,570) (4,616) (4,662) (4,708) (4,756) 838 Licenses/RegisVations dept 15 1% - - - - - - - - 16 FIVE YEAR FINANCIAL FORECAST ALL MUNICIPAL FUNDS AUDITED ADOPTED REVISED � Projected Projected Projected Projected FY 19-20 FY 20-21 FY 20-21 FY 22-23 FY 23-24 FY 24-25 FY 25-26 839 Licenses/Registrations dept 17 1% - (50) (50) (50) (51) (51) (52) (52) 840 Licenses/RegisVations dept 21 1% - (1,000) (1,000) (1,000) (1,010) (1,020) (1,030) (1,041) 841 Licenses/RegisVations dept 26 1% - - - - - - - - 842 TCLEOSE Marshal Expense dept 15 1% - - - - - - - - 843 TCLEOSE dept 15 1% (249) (945) (945) (945) (954) (964) (974� (983) 844 Total Travel&Training (115,374) (214,743) (227,128) (234,443) (236,787) (239,155) (241,547) (243,962) 845 Transfer Out-DS 300 (D2,089) (966,816) (449,876) - - - - - 846 TotalOperating7ransfersOut (272,089) (966,816) (449,876) - - - - - 847 TOTALOPERATINGEXPENDITURES (payroll/operetions/maintenance) (9,295,221) (10,665,746) (9,828,481) (10,256,719) (10,522,272) (10,793,164) (11,037,373) 848 TransferOut-GMRFund600 - (10,000) (10,000) (1,500,000) (950,000) (950,000� (950,000� (950,000) 849 TransferOut-GFVMRFund605 - - (75,000) (500,000) (500,000) (750,000) (1,250,000) (500,000) 850 TransferOut-UFVMRFund505 - - - - - - - - 851 TransferOut-CPFund410 - - - - - - - - asz rra�sfer o�e-vn F��d zzo (soo,000) �zso,000� �zso,000� (zso,000� �zso,000� 853 Total Non-Operating Transfers Out - (30,000) (85,000) (2,500,000) (1,700,000) (1,950,000) (2,450,000) (1,700,000) 854 TOTAL NON-OPERATING EXPENDITURES - (10,000) (85,000) (1,700,000) (1,950,000) (2,450,000) (1,700,000) 855 GRANDTOTALALLEXPENDITURES (9,295,221) (30,675,746) (9,913,481) (11,956,719) (12,472,272) (13,243,164) (12,737,373) 856 857 Beginning Fund Balance 12,696,365 14,498,447 14,498,447 14,764,717 12,964,025 13,757,976 12,614,665 12,576,333 858 Endin¢Fund Balance 14.498.446 13.443.374 14.764.717 12.964.028 13,757,976 12,614,665 12,876,333 12,450,017 859 Restricted/Committed/Assigned 383,712 298,560 430,111 430,111 430,111 430,111 430,111 43Q111 860 Unassigned Ending Balance $ 14,114,735 $ 13,144,815 $ 14,334,606 $ 13,327,865 $ 12,184,554 $ 12,446,222 $ 12,019,906 861 Operating Expenditures 9,295,221 10,665,746 9,828,481 10,059,992 1Q256,719 10,522,272 10,793,164 11,037,373 862 Operatine Cost per Dav 25 466 29 221 26 927 27 562 25,101 2S,S28 29,570 30,239 863 OPERATING DAYS 554 450 532 455 474 423 421 397 17 FIVE YEAR FINANCIAL FORECAST ALL MUNICIPAL FUNDS AUDITED ADOPTED REVISED � Projected Projected Projected Projected FY 19-20 FY 20-21 FY 20-21 FY 22-23 FY 23-24 FY 24-25 FY 25-26 864 � . � , 865 , � , ass Section Sales oi S 66,578 S so,000 5 so,000 5 s,soo 5 s,soo 5 s,soo 5 s,soo 5 s,soo 867 PerpetualCare-Sectionl5% 0% - 150 150 1,500 1,500 1,500 1,500 1,500 868 Perpetual Care-interment 100% 0% 100 50 50 - - - - - 869 Marker5ales 0% - - - - - - - - 870 MarkerinitiativeFees 0% 900 100 100 100 100 100 100 100 871 PrivateContributions 0% - - - - - - - - 872 ContractorFee 0% - 250 250 250 250 250 250 250 873 MiscRevenue 0% - DS 275 275 275 275 275 275 874 Interest Income 0% 2,292 500 500 500 500 500 500 500 875 TOTAL REVENUES 69,869 51,325 51,325 11,125 11,125 11,125 11,125 876 Engineering 1% - (6,450) (6,450) (6,450) (6,514.50) (6,580) (6,645) (6,712) 877 Attorney-Boyle&Lowry 0% - - - - - - - - 878 ContractServices 1% (350) (370) (370) (370) (374) (377) (381) (385) 87g Irrigation R&M 1% (358) (2,500) (2,500) (2,500) (2,525) (2,550) (2,576) (2,602) 880 Contract Landscaping 1% (5,686) (6,375) (6,375) (6,375) (6,439) (6,503) (6,565) (6,634) 881 ComputerEqpmt/Software 0% (1,500) - - - - - - - 882 ROW Irrigation 1% (3,637) (1,625) (1,625) (1,625) (1,641) (1,655) (1,674) (1,691) 883 Grounds R&M 1% (6,328) (2,375) (2,375) (2,375) (2,399) (2,423) (2,447) (2,471) 884 Training/Meetings/Seminars 1% - (2,500) (2,500) (2,500) (2,525) (2,550) (2,576) (2,602) 885 Dues&Memberships 1% - (125) (125) (125) (126) (128) (129) (130) 886 Misc.Expense 1% (497) (215) (215) (215) (217) (219) (222) (224) 887 Land Improvements 0% - - - - - - - - 888 CostofSales-CemeteryLots 1% (3,379) (1,491) (1,491) (1,491) (1,506) (1,521) (1,536) (1,552) 88g TOTAL E7(PENDITURES (21,734� (24,026� (24,026) (24,266) (24,509) (24,754) (25,002) 890 891 Beginning Fund Balance 260,168 308,304 308,304 335,603 322,702 309,561 296,177 282,548 892 Endine Fund Balance 308,304 335,603 335,603 322.702 309 561 296.177 282 548 268.671 893 Restricted/Committed/Assigned 308,304 335,603 335,603 322,702 309,561 296,ll7 282,548 268,671 894 Unassigned Ending Balance $ - $ - $ - $ - $ - $ - $ - 895 Operating Expenses 21,734 24,026 24,026 24,026 24,266 24,509 24,754 25,002 896 Operating Cost Per Day 60 66 66 66 66 67 6S 6S 897 OPERATING DAYS 5,178 5,098 5,098 4,902 4,656 4,411 4,166 3,922 898 , 1 1 , 899 Water Revenue 2% $ 4,104,042 $ 3,794,581 $ 3,794,581 $ 3,794,581 $ 3,570,473 $ 3,947,SS2 $ 4,026,540 $ 4,107,377 900 DS-HillwoodServiceArea 2% 102,215 48,960 48,960 48,960 49,939 50,935 51,957 52,996 901 DS-TownServiceAreaAccts 2% 85,225 43,860 43,860 43,860 44,737 45,632 46,545 47,475 902 WasteManagement 2% 10,625 6,314 6,314 6,314 6,440 6,569 6,700 6,834 903 SewerRevenue-Westlake 2% 1,642,488 1,406,506 1,406,506 1,406,506 1,434,636 1,463,329 1,492,595 1,522,447 904 SewerRevenue-Keller 2% 1,203 1,293 1,293 1,293 1,319 1,345 1,372 1,400 905 WaterTapFees 2% 21,500 34,366 34,366 34,366 35,053 35,754 36,469 37,199 906 SewerTapFees 2% 6,750 17,424 17,424 17,424 17,772 1S,12S 15,490 18,860 907 Fort Worth Impact fees 0% 77,158 67,225 67,225 67,225 67,225 67,225 67,225 67,225 908 MeterRepair&Replacement 2% 902 6,060 6,060 6,060 6,181 6,305 6,431 6,560 909 Sub-Total Charge For Services 6,052,109 5,426,589 5,426,589 5,426,589 5,533,776 5,643,107 5,754,625 5,868,373 910 Duct Bank Leases 41,930 41,161 41,161 41,161 41,161 41,161 41,161 41,161 911 TRAWastewater5ettle-Up 246,603 69,750 69,750 69,750 69,750 69,750 69,750 69,750 912 WaterTowerLease 9,500 11,400 11,400 11,400 11,400 11,400 11,400 11,400 913 Duct Bank Permit Fees linked to PD schedule 46,500 145,700 145,700 145,700 159,100 192,200 192,200 167,400 914 Sub-Total Permits and Fees 344,533 268,011 268,011 268,011 311,411 314,511 314,511 289,711 915 Interest Income 2% 54,995 55,853 55,853 55,853 56,970 58,109 59,272 60,457 916 Totallnterest 54,995 55,853 55,853 55,853 56,970 58,109 59,272 60,457 917 Cross Connection Control Prog. 2% 5,414 4,000 4,000 4,000 4,OSO 4,162 4,245 4,330 918 InsuranceRefund/EquityRetum 2% - 500 500 500 510 520 531 541 919 MiscRevenue 2% (269) 6,050 6,050 6,050 6,171 6,294 6,420 6,549 920 Administrative Fee 2% 8,967 7,475 7,475 7,475 7,625 7,777 7,933 8,091 921 MiscReimbursements 2% - - - - - - - - 922 Total Misc Income 14,112 18,025 18,025 18,025 18,386 18,753 19,128 19,511 923 TOTALREVENUES 6,465,748 5,768,478 5,768,478 5,768,478 5,920,542 6,034,481 6,147,535 6,238,051 18 FIVE YEAR FINANCIAL FORECAST ALL MUNICIPAL FUNDS AUDITED ADOPTED REVISED � Projected Projected Projected Projected FY 19-20 FY 20-21 FY 20-21 FY 22-23 FY 23-24 FY 24-25 FY 25-26 924 Operating Xfr Out for PR Costs 1% (410,866) (543,088) (543,088) 5 (559,381) $ (564,974.81) $ (570,625) $ (576,331) $ (582,094) 925 Compensated Absences 1% 19,133 (2,785) (2,785) (2,785) (2,513) (2,541) (2,569) (2,598) 926 Compensated Absences 1% (264) (4,645) (4,645) (4,645) (4,691) (4,735) (4,786) (4,834) 927 Compensated Absences 1% 1,502 (1,640) (1,640) (1,640) (1,656) (1,673) (1,690) (1,707) 928 Compensated Absences 1% 2,656 (125) (125) (125) (126) (125) (129� (130) 929 Worker'sCompensation 1% - - - - - - - - 930 Total Payroll and Related (387,839) (552,283) (552,283) (568,576) (574,262) (580,004) (585,804) (591,662) 931 Mechanical Equipment 2% - (1,000) (1,000) (1,000) (1,015) (1,030) (1,046) (1,061) 932 ComputerHardware/Software 2% (1,392) �i,000) �i,000) �i,000) (1,015) (1,030) (1,046) (1,061) 933 Water Meters/Equipment 2% (43,389) (2QD5) (20,275) (2QD5) (20,579) (20,SSS) (21,201) (21,519) 934 WaterTaps 2% - (8,780) (8,780) (8,780) (5,912) (9,045) (9,181) (9,319) 935 Total Capital Outlay (44,781) (31,055) (31,055) (31,055) (31,521) (31,994) (32,474) (32,961) 936 Fort Worth Waterline Payment 0% (917,350) - - - 937 Keller OH Storage-Principal ends 2020 tied to schedule - - - - - - - - 938 Keller OH Storage-Interest ends 2020 tied to schedule (2,523) - - 939 Service Area-Hillwood tied m revenues (68,823) (48,240) (48,240) (48,240) (49,939) (50,938) (51,957) (52,996) 940 Service Area-Town tied to revenues (57,689) (43,215) (43,215) (43,215) (44,737� (45,632) (46,545) (47,475) 941 TXWDB 2018 CO-Principal tied to schedule - (23,650) (23,650) (23,650) (100,000) (100,000) (100,000) (100,000) 942 TXWDB 2015 CO-Interest tied to schedule (30,883) (31,582) (31,582) (31,582) (40,744) (39,404) (37,949) (36,394) 943 GSTank2013C0-Principal tiedtoschedule - (100,000) (100,000) (100,000) (24,750) (25,300) (26,400) (26,400) 944 GS Tank 2013 CO-Interest tied to schedule (57,066) (41,984) (41,984) (41,984) (30,977) (3Q288) (29,512) (28,720) 945 HillwoodDebtCO-Principal - (743,000) (743,000) (435,000) (410,000) (420,000) (435,000) (450,000) 946 Hillwood Debt CO-Interest (848,209) - - (387,551) (412,226) (400,581) (386,474) (371,871) 947 Total Debt (1,982,542) (1,031,671) (1,031,671) (1,111,222) (1,113,373� (1,112,143) (1,113,836) (1,113,856) 948 Misc Rental/Lease Dept.16 2% - (1,500) (1,500) (1,500) (1,523) (1,545) (1,569) (1,592) 949 Total Leases and Rentals - (1,500) (1,500) (1,500) (1,523) (1,545) (1,569) (1,592) 9W Public Notice Dept.ll 2% - - - - - - - - 951 Public Notice Dept.16 2% - - - - - - - - 952 Total Public Notices - - - - - - - - 953 Office Rent Dept.10 from schedule (83,919) (79,500) (79,500) (79,500) (74,665) (76,242) (76,936) (77,653) 954 Electric-Town Hall Dept.10 0% (7,940) (9,100) (9,100) (9,100) (9,100) (9,100) (9,100) (9,100) 955 Electric-Lift Station Dept.16 2% (1,400) (2,680) (2,680) (2,680) (2,720) (2,761) (2,802) (2,844) 956 Electric-PumpStation Dept.16 2% (1,862) (1,291) (1,291) (1,291) (1,310) (1,330) (1,350) (1,370) 957 Electric-PumpStation Dept.16 2% (53,361) (7qD7) (7qD7) (82,D7) (53,511) (54,764) (56,035) (87,326) 958 Internet Service Dept.10 2% (3,709) (2,330) (2,330) (2,330) (2,365) (2,400) (2,436) (2,473) 959 IntemetService Dept.16 2% - - - - - - - - 960 Telephone-TownHall Dept.10 2% (108) (700) (700) (700) (711) (721) (732) (743) 961 Telephone Dept.16 2% - (1,000) �i,000) (1,000) (1,015) (1,030) (1,046) (1,061) 962 Water-Other Dept.16 2% - (850) (850) (850) (863) (876) (889) (902) 963 Water-Pump Station Dept.16 2% (11,482) (20,600) (20,600) (20,600) (20,909) (21,223� (21,541) (21,864) 964 Total Rent&Utilities (163,781) (188,328) (188,328) (200,328) (197,172) (200,447) (202,868) (205,337� 965 WaterTowerLandscape R&M Dept.16 2% (134) (6,000) (6,000) (6,000) (6,090) (6,181) (6,D4) (6,368) 966 Water Main R&M Dept.16 2% (120,372) (35,045) (35,045) (35,045) (35,571) (36,104) (36,646) (37,195) 967 WaterTowerR&M Dept.16 2% (538) (1,000) (1,000) (1,000) (1,015) (1,030) (1,046) (1,061) 968 Sewer Main R&M Dept.16 2% (68,957) (24,973) (24,973) (24,973) (25,345) (25,725) (26,114) (26,505) 969 Pump Station Landscape R&M Dept.16 2% (14,180) (12,500) (12,500) (12,500) (12,688) (12,878) (13,071) (13,267) 970 Lift Station R&M Dept.16 2% (13,930) (6,000) (6,000) (6,000) (6,090) (6,151) (6,274) (6,368) 971 Instrument R&M Dept.16 2% (1,136) (9,473) (9,473) (9,473) (9,615) (9,759) (9,906) (10,054) 972 Ground Storage Tank R&M Dept.16 2% (7,115) (2,300) (2,300) (2,300) (2,335) (2,370) (2,405) (2,441) 973 GeneratorR&M Dept.16 2% (13,921) (6,815) (6,815) (6,815) (6,917) (7,021) (7,126) (7,233) 974 Pump Station R&M Dept.16 2% (40,687) (12,500) (12,500) (12,500) (12,6SS) (12,S7S) (13,071) (13,267) 975 Duct Bank R&M Dept.16 2% (11,800) (6,940) (6,940) (6,940) (7,044) (7,150) (7,257) (7,366) 976 FM1938 ROW Landscape Dept.16 2% - - - - - - - - 977 Meter Repair&Replacement Dept.16 2% (5,229) (35,793) (35,793) (35,793) (36,330) (36,875) (37,425) (37,989) 978 HVAC Maint. Dept.16 2% - - - - - - - - 979 Water/SeWer R&M Dept.16 2% (641) (726) (726) (726) (737) (748) (759) (771) 980 Vehide R&M Dept.16 2% (1,239) �i,000) (i,000) �i,000) (1,015) (1,030) (1,046) (1,061) 981 Total Repair and Maintenance (299,880) (161,065) (161,065) (161,065) (163,481) (165,933) (168,422) (170,949) 982 Engineering Dept.16 2% (2,813) (4,540) (4,540) (4,540) (4,608) (4,677) (4,747) (4,519) 983 Water Utility Engineering Dept.16 2% (11,692) (37,555) (37,555) (37,555) (3S,11S) (35,690) (39,270) (39,560) 984 Misc.Engineering Dept.16 2% (625) (4,126) (4,126) (4,126) (4,188) (4,251) (4,314) (4,379) 985 Consultant Fees Dept.16 2% (28,382) (5,138) (5,138) (5,138) (5,215) (5,293) (5,373) (5,453) 986 Auditor Dept.16 2% (8,000) (8,200) (8,200) (8,200) (8,323) (8,448) (5,575) (5,703) 987 Attomey-Boyle&Lowry Dept.16 2% (31,258) (9,421) (9,421) (9,421) (9,562) (9,706) (9,551) (9,999) 988 Attorney-LloydGosselink Dept.16 2% (2,498) (10,256) (10,256) (10,256) (10,410) (10,566) (10,724) (10,885) 989 ContractLabor Dept.16 2% - - - - - - - - 990 Contract Services Dept.16 2% (8,978) (7,860) (7,860) (7,860) (7,978) (8,095) (5,219) (5,342) 991 Water Purchases Dept.16 2% (989,807) (1,042,621) (1,042,621) (1,042,621) (1,063,473) (1,OS4,743) (1,106,435) (1,125,567) 992 WaterService Charge Dept.16 0% (600) (600) (600) (600) (600) (600) (600) (600) 993 PeakPayment Dept.16 2% (211,264) (456,879) (456,879) (456,879) (466,017) (475,337) (484,844) (494,541) 994 TRA-WastewaterTreatment Dept.16 2% (520,754) (479,303) (479,303) (479,303) (486,493) (493,790) (501,197) (508,715) 995 Southlake-WastewaterTreatment Dept.16 2% (1,007,949) (1,302,497) (1,302,497) (1,302,497) (1,322,034) (1,341,565) (1,361,993) (1,352,423) 996 Testing-Water/Bacteria/Rgltry Dept.16 2% (24,340) (30,000) (30,000) (30,000) (30,450) (30,907) (31,370) (31,841) 997 Utility Billing Dept.16 2% (5,451) (27,321) (27,321) (27,321) (27,731) (25,147) (25,569) (28,998) 998 Line Location Dept.16 2% (3,122) (5,660) (5,660) (5,660) (5,745) (5,831) (5,919) (6,007) 999 Application Software Maint. Dept.16 2% (7,851) (11,985) (11,985) (11,985) (12,165) (12,347) (12,532) (12,720) 1,000 Keller Waste Water Dept.16 2% (1,056) (1,300) (1,300) (1,300) (1,320) (1,339) (1,359) (1,350) 19 FIVE YEAR FINANCIAL FORECAST ALL MUNICIPAL FUNDS AUDITED ADOPTED REVISED � Projected Projected Projected Projected FY 19-20 FY 20-21 FY 20-21 FY 22-23 FY 23-24 FY 24-25 FY 25-26 1,001 Insurance GeneralLiability Dept.16 2% (853) (855) (855) (855) (S6S) (881) (894) (907) t.002 Insurance Automobile Dept.10 2% - (1,630) (1,630) (1,630) (1,654) (1,679) (1,704) (1,730) 1,003 Insurance Automobile Dept.16 2% (618) (619) (619) (619) (625) (635) (647) (657) 1,004 Insurance Property Dept.10 2% - (8,650) (8,650) (8,650) (8,780) (8,911) (9,045) (9,181) 1,W5 Insurance Property Dept.16 2% (11,548) (11,548) (11,548) (11,548) (11,721) (11,597) (12,075) (12,257) 1,006 Mobile Phone Dept.16 2% (2,268) (1,000) (1,000) (1,000) (1,015) (1,030) (1,046) (1,061) 1,007 Printing Dept.16 2% - (1,130) (1,130) (1,130) (1,147) (1,164) (1,182) (1,199) 1,008 Bank Service Charges Dept.10 2% (10,109) (7,550) (7,550) (7,550) (7,663) (7,778) (7,895) (8,013) 1,009 Courier5ervice Dept.16 2% - (200) (200) (200) (203) (206) (209) (212) 1,010 Bad Debt Expense Dept.16 2% - - - - - - - - 1,011 Total Services (2,891,836) (3,478,444) (3,478,444) (3,478,444) (3,538,109) (3,598,819) (3,660,593) (3,723,449) 1,012 ComputerEqpmt/Software Dept.16 2% - (210) (210) (210) (213) (216) (220) (223) 1,013 Safety5upplies Dept.16 2% (1,285) (100) (100) (100) (102) (103) (105) (106) 1,014 MiscHandTools Dept.16 2% (2,D2) (1,855) (1,855) (1,855) (1,SS3) (1,911) (1,940) (1,969) 1,015 Chemical Supplies Dept.16 2% - (350) (350) (350) (355) (361) (366) (371) 1,016 Office Supplies Dept.16 2% - (538) (538) (538) (546) (554) (563) (571) 1,017 Office Equipment Dept.16 2% - - - - - - - - 1,018 Postage&Shipping Dept.16 2% (55) (400) (400) (400) (406) (412) (418) (425) 1,019 Misc Supplies Dept.16 2% - - - - - - - - 1,020 Meeting Expense Dept.16 2% - - - - - - - - 1,021 Misc Supplies Dept.10 2% - - - - - - - - 1,022 Vehide Fuel Dept.16 2% (3,SR) (3,000) (3,000) (3,000) (3,045) (3,091) (3,137) (3,184) 1,023 Uniforms Dept.16 2% (707) (587) (587) (587) (596) (605) (614) (623) 1,024 Total Supplies (7,891) (7,040) (7,040) (7,040) (7,146) (7,253) (7,362) (7,472) 1,025 Travel Airfare Dept.16 2% - (800) �soo) (800) (512) (824) (837) (849) 1,026 TravelCar Rental/Parking Dept.16 2% (10) (100) (100) (100) (102) (103) (105) (106) 1,027 TravelLodging Dept.16 2% - (1,560) (1,560) (1,560) (1,SS3) (1,607) (1,631) (1,656) 1,028 Travel Meals Dept.16 2% - (77) (77) (77) (78) (79) (81) (S2) 1,029 Travel Mileage Dept.16 2% - (58) (58) (58) (59) (60) (61) (62) 1,030 Training/Seminars/Meetings Dept.16 2% (155) (3,000) (3,000) (3,000) (3,045) (3,091) (3,137) (3,154) 1,031 Dues&Subscriptions Dept.16 2% - (1,500) (1,500) (1,500) (1,523) (1,545) (1,569) (1,592) 1,032 Books&Printed Materials Dept.16 2% - - - - - - - - 1,033 Licenses/Registrations Dept.16 2% - (700) (700) (700) (711) (721) (732) (743) 1,034 Total Travel&Training (165) (7,795) (7,795) (7,795) (7,912) (8,031) (8,151) (8,273� 1,035 Transfer Out-UMR Fund 510 Dept.99 linked to UMR - (30,000) (30,000) (350,000) (150,000) (150,000) (150,000) (150,000) 1,036 Transfer Out-VMR Fund 505 Dept.99 linked to VMR (20,000) (60,000) (60,000) (65,000) - (65,000) - - 1,037 Transfer Out-GF 1001mpact Fees Dept.99 GF linked to this (77,158) (68,000) (68,000) (68,000) (6,181) (6,305) (6,431) (6,560) 1,038 Total Transfers Out (97,158) (158,000) (158,000) (483,000) (156,181� (221,305) (156,431� (156,560) 1,039 TOTALE7(PENSES (5,875,871) (5,617,181) $ (5,617,181) $ (5,790,679) 5 (5,927,473) 5 (5,937,509) 5 (6,012,111) 1,040 1,041 Beginning Fund Balance(Working Capital) 4,840,299 5,430,176 5,430,176 5,581,473 5,299,925 5,429,789 5,536,796 5,746,823 1,042 Endine Fund Balance 5.430.176 5.581.473 5.581.473 5,299,925 5.429.789 5.536.796 5.746.823 5.972.763 1,043 ResVicted/Committed/Assigned Hillwood 888,000 888,000 888,000 750,000 750,000 750,000 750,000 750,000 1,044 ResVicted/Committed/Assigned Deposiu 2% 239,750 234,330 234,330 234,330 239,011 243,797 243,797 243,797 1,045 ResVicted/Committed/Assigned Other - - - - - - - - 1,046 Unassigned Ending Balance 4,302,426 4,459,143 $ 4,459,143 $ 4,440,772 $ 4,542,999 $ 4,753,026 $ 4,978,966 1,047 Operating Expenses 5,875,871 5,617,181 5,617,181 6,050,025 5,790,679 5,9D,473 5,937,509 6,012,111 1,048 Operatin�Cost Per DaV 16,098 15,390 15,390 16,575 15,865 16,240 16,267 16,472 1,049 OPERATING DAYS 337 363 363 320 342 341 353 363 2� FIVE YEAR FINANCIAL FORECAST ALL MUNICIPAL FUNDS AUDITED ADOPTED REVISED � Projected Projected Projected Projected FY 19-20 FY 20-21 FY 20-21 FY 22-23 FY 23-24 FY 24-25 FY 25-26 t 050 � . � � � , � 1,051 � � � � ' ' � � 1,052 Salesof5urplus $ - $ - $ - 5 - S - $ - $ - $ - 1,053 Insurance Proceeds - - - - - - - - 1,054 Interest Eamed 357 25 25 25 50 50 50 50 1,055 Transfer in from GF - - - - - - - - 1,056 Transferinfrom UF 20,000 60,000 60,000 65,000 - 65,000 - - 1,057 TOTAL REVENUES 20,357 60,025 60,025 50 65,050 50 50 i,oss Public Works Vehide (so,oeo) (eo,000) (eo,000) �es,000) - 1,059 TOTALEXPENDITURES (50,060) (60,000) (60,000) - - - - 1,060 1,061 Beginning Fund Balance 34,387 4,685 4,685 4,710 4,735 4,785 69,835 69,885 1,p62 Endine Fund Balance 4.685 4.710 4.710 4.735 4.785 69.835 69.885 69.935 1,063 ResVicted/Committed/Assigned 4,685 4,710 4,710 4,735 4,785 69,835 69,885 69,935 1.064 Unassigned Ending Balance $ $ $ $ $ $ $ t 065 � 1 � � ' � � 1 1,066 Interestlncome $ 4,533 $ 1,750 $ 1,750 $ 1,750 $ 1,000 $ 1,000 $ 1,000 $ 1,000 1,p67 Transfers In from UF 500 - 30,000 30,000 350,000 150,000 150,000 150,000 150,000 1,068 TOTAL REVENUES 4,533 31,750 31,750 151,000 151,000 151,000 151,000 1,069 Pump Station Equipment (110,207) (10,000) (10,000) (190,000) (10,000) (10,000) (25,000) (50,000) 1,070 LiftStation Pump Repairs (17,982) (12,000) (12,000) (20,000) (10,000) (10,000) (10,000) (25,000) �,p7� Sewer Easement Cleaning Machine - (68,000) (68,000) (68,000) - - - - �,p7p Water Main Repairand Maintenance - (20,000) (20,000) (20,000) (20,000) (20,000) (20,000) (20,000) �,p73 LiftStation Repairand Maintenance - (21,500) (21,500) (15,000) (10,000) (35,000) (10,000) (10,000) �,p7q Pump Station R&M - - - - - - - - �,p75 Pump/Motor Repair/Replacement - (175,000) (30,000) (145,000) (5,000) (15,000) (5,000) (10,000) �,p76 Duct Bank Repairand Maintenance - (5,000) (5,000) (5,000) (5,000) (10,000) (5,000) (5,000) �,p77 Sewer Line Repairand Maintenance - (10,000) (10,000) (15,000) (10,000) (10,000) (15,000) (10,000) �,p7g Public Works Equipment (2,348) - - (6,000) (3,000) (3,000) (3,000) (3,000) �,p7g Street Drainage (47,690) - - - - - - - 1,080 TOTAL E7(PENDITURES (178,228) (321,500� (176,500) (73,000) (113,000) (93,000) (133,000) 1,081 1,082 beginning Fund Balance 454,352 280,657 280,657 135,907 3,657 81,657 119,657 177,657 1,083 Endine Fund Balance 280.657 (9,093) 135,907 3.657 81.657 119.657 177.657 195.657 1.084 ResVicted/Committed/Assigned 280,657 (9,093) 135,907 3,657 81,657 119,657 177,657 195,657 1.085 Unassigned Ending Balance $ $ $ $ $ $ $ t 086 � • 1 1 ' � � � ' � � � 1,087 Contributions Dept 14 Dept.14 - - - - - - - - �,pgg FirefighterEquipmentFees Dept.14 - - - - - - - - �,pgg Interestlnmme Dept.00 13,026 4,500 4,500 4,500 - - - - �,pgp Misc Revenue Dept.00 2,500 - - - - - - - �,pg� Saleof5urplus Dept.00 - - - - - - - - �,pgZ Transfer in from GF Dept.88 - 10,000 10,000 1,500,000 950,000 950,000 950,000 950,000 �,pg3 �NA Facilities Allotment 50% Dept.17 - - - 60,000 60,000 60,000 60,000 60,000 �,pgq Contribution Dept.00 12,860 - - - - - - - �,pg5 TEA-Safety&Security Grant Dept.17 - - - - - - - 1.096 6N FAI-Safety&Security 6rant Dept.17 24,750 - - - - - - 1.097 TOTAL REVENUES 53,136 14,500 14,500 1,010,000 1,010,000 1,010,000 1,010,000 21 FIVE YEAR FINANCIAL FORECAST ALL MUNICIPAL FUNDS AUDITED ADOPTED REVISED � Projected Projected Projected Projected FY 19-20 FY 20-21 FY 20-21 FY 22-23 FY 23-24 FY 24-25 FY 25-26 t.098 Fire Dept Equipment - - - (78,287) (8,000) (10,000� (20,000) (10,000) i,oss comm����ac�o�s - �eo,000) �so,000� (ioo,000� (so,000� (io,000� 1,100 Dept 14-Fire/EMS - - - (138,287) (58,000) (110,000) (70,000) (20,000) 1,101 SH 114 Repainting - (30,000) (30,000) (10,000) - (15,000) - (40,000) 1,102 SC Hills Pavement Repair - - - - - - - - 1,103 Dove/OttingerSurface Treatment (59,785) (150,000) (150,000) - - - - - 1,104 Solana Pavement Repair - - - (30,000) (25,000) - (50,000) - 1,105 FM 1935 Pavement Repairs - - - (90,000) (30,000) (50,000) (20,000) (20,000) 1,106 Illuminated Street Name Signs - - - (10,000) (10,000) (10,000) (10,000) (10,000) 1,107 Street Signs and SignalLights - (15,000) (15,000) (15,000) (8,000) (10,000) (20,000) (10,000) 1,108 Street Staining/Maintenance - (100,000) �ioo,000) �ioo,000) (50,000) (100,000) (50,000) (10,000) 1,109 Dept16-Road/Streetlmprovements (59,785) (295,000) (295,000) (255,000) (123,000) (215,000) (150,000) (90,000) �,��p WA-Irrigation System - (5,000) (5,000) (10,000) (5,000) (5,000) (10,000) (5,000) �,>>> WA-15Ton5plitHVACSystem - (15,000) �is,000) (io,000) (is,000� (s,000� (io,000� (io,000� �,>>Z WA4 Ton RoofTop Units - (10,000) �io,000) �is,000) (io,000� (is,000� (s,000� (s,000� �,��3 WA-AC ton/7.5 ton serverroom - (10,000) (10,000) (10,000) (5,000) (10,000) (5,000) (5,000) �,��q WA-HVAC System Replacement - (5,000) (5,000) (150,000) (5,000) (5,000) (5,000) (5,000) �,��5 WA-Update Security System (1,357) (5,000) (5,000) (5,000) (5,000) (5,000) (20,000) (5,000) �,��6 WA-Update Security Cameras - (5,000) (5,000) (5,000) (10,000) (15,000) (5,000) (5,000) �,��7 WA-Heater Boilers - (5,000) (5,000) (5,000) (5,000) (5,000) (5,000) (25,000) �,��g WA-Painting/Cloth Wall R&M - (8,000) (8,000) (5,000) (5,000) (5,000) (5,000) (10,000) �,��g WA-Ext Envrnmtlmprvmtslrrig - (12,000) (12,000) (10,000) (10,000) (10,000) (10,000) (10,000) �,�p0 �NA-Parking Lot (1,329) - - - (5,000) (5,000) (10,000) (5,000) �,�p� WA Playground Equipment - - - - (5,000) - (10,000) - �,�pp WA-Plumbing Repair/Replacement - (5,000) (5,000) (5,000) (5,000) (10,000) (5,000) (5,000) �,�p3 �NA-Carpet/VCT Flooring (8,251) (38,000) (38,000) (25,000) (10,000) (10,000) (10,000) (30,000) �,�pq WA-Envrnmt Bldg UG light/water - (5,000) (5,000) (5,000) (5,000) (5,000) (5,000) (50,000) �,�25 WA-Refurbish Classrooms - (20,000) (20,000) (20,000) (25,000) (25,000) (25,000) (25,000) �,�26 �NA-Interior Building R&M - (40,000) (40,000) (35,000) (30,000) (40,000) (35,000) (30,000) �,�27 WA-Exterior Paint&Wood R&M (2,000) (8,000) (8,000) (10,000) (10,000) (10,000) (10,000) (10,000) �,�Zg WA-Roof Repairs (61,013) (20,000) (20,000) (20,000) (10,000) (10,000) (10,000) (10,000) �,�Zg WA Facilities Allotment (52,825) - - (60,000) (60,000) (60,000) (60,000) (60,000) 1,130 �NA-Mechanical Equipment (37,706) - - - - - - - 1,131 �NAKeIIerPolice5ubstation (700) - - - - - - - 1,132 �NA-Furniture/Interior Bldg - (5,000) (5,000) (5,000) (5,000) (5,000) (5,000) (5,000) 1,133 �NA Security Fence/Cameras (60,281) - - - (3,000) (3,000) (15,000) (3,000) 1,134 �NA Fire Alarm System Allotment - - (60,000) - - - - - 1,135 WA-Grant 1,136 Dept 17-Westlake Academy Facilities (225,462) (221,000) (281,000) (430,000) (248,000) (263,000) (280,000) (318,000� 1,137 Trail Repairs and Maintenance (8,549) (10,000) (10,000) (20,000) (20,000) (20,000) (20,000) (25,000) 1,138 Park Repairs and Maintenance (8,689) (15,000) (15,000) (25,000) (25,000) (25,000) (25,000) (25,000) 1,139 Dept 19-Town Parks (17,237) (25,000) (25,000) (45,000) (45,000� (45,000) (45,000) (50,000� �,�q0 Servers&Network Smrage - (15,000) (15,000) (15,000) (30,000) (30,000) (30,000) - �,�q� Network Printers/Peripheal Dev (2,585) (5,000) (5,000) (5,000) (5,000) (5,000) (5,000) - �,�qZ Network Equipment (133,310) (15,000) (15,000) (15,000) (25,000) (15,000) (15,000) (15,000) �,�q3 Server Replacements (1,074) (60,000) (60,000) (60,000) (20,000) (20,000) (20,000) - �,�qq Phone System/Peripheal Devices (298) (15,000) (15,000) (15,000) (15,000) (65,000) (65,000) - 1,145 Dept20-TownlTDept (337,266) (110,000) (110,000) (110,000) (95,000) (135,000) (135,000) (15,000) i,ias Town-Irrigation R&M (5,000) �s,000) �s,000) (s,000� (s,000� (s,000� (s,000� 1,147 Town Open Spacelmprovements - (10,000) (10,000) (40,000) (40,000) (45,000) (45,000) (45,000) 1,148 Town-15 Ton Split HVAC System - - - - - - - - 1,149 Town-2TonRoofTopUnits - - - - - - - - 1,150 Town-AC ton/7.5 ton serverroo - (3,000) (3,000) (3,000) (2,000) (2,000) (2,000) (3,000) 1,151 Town-HVAC System Replacement - (5,000) (5,000) (5,000) (3,000) (3,000) (5,000) (3,000) 1,152 Town-Contract Landscaping - (5,000) (5,000) (5,000) (5,000) (5,000) (5,000) (5,000) i,iss Town-Security System (z,000) (s,000) �s,000) �io,000) (s,000� (s,000� (io,000� (s,000� 1,154 Town-Security Cameras - (5,000) (5,000) (5,000) (5,000) (10,000) (5,000) (5,000) 1,155 Town-Safety Doors - (8,000) (8,000) (5,000) (3,000) (3,000) (3,000) (3,000) 1,156 Town-Ground R&M - (4,000) (4,000) (3,000) (3,000) (3,000) (3,000) (3,000) 1,157 Town-HeaterBoiler - - - - - - - - 1,158 Town-Painting/Cloth Wall R&M - (4,000) (4,000) (4,000) (3,000) (3,000) (3,000) (10,000) 1,159 Town-Signs and Signals - - - - - - - - 1,160 Town-Environmentallmprovement - (4,000) (4,000) (5,000) (5,000) (5,000) (5,000) (5,000) 1,161 Town-Parking Lot - (4,000) (4,000) (3,000) (3,000) (3,000) (3,000) (15,000) 1,162 Town-Plumbing Repair/Replace - (2,000) (2,000) (4,000) (2,000) (2,000) (4,000) (2,000) 1,163 Town-Carpet/Flooring R&M - - - - - (20,000) (35,000) - 1,164 Town-Env Bldg UG light/water - (10,000) (10,000) (8,000) (5,000) (5,000) (5,000) (10,000) 1,165 Town-Interior Building R&M - (5,000) (5,000) (5,000) (5,000) (5,000) (5,000) (5,000) 1,166 Town-Bldg Exterior Paint/R&M - (5,000) (5,000) (5,000) (5,000) (5,000) (10,000) (5,000) 1,167 Town-Roof Repairs - (6,000) (6,000) (5,000) (5,000) (5,000) (5,000) (5,000) 22 FIVE YEAR FINANCIAL FORECAST ALL MUNICIPAL FUNDS AUDITED ADOPTED REVISED � Projected Projected Projected Projected FY 19-20 FY 20-21 FY 20-21 FY 22-23 FY 23-24 FY 24-25 FY 25-26 t.168 Town-Fumiture/Interior Bldg 507 (3,000) (3,000) (3,000) (3,000) (3,000) (3,000� (3,000) 1,169 TowmFumiture/InteriorBldg (507) - - - - - - - 1,170 Dept 26-Town Facilities (2,000) (93,000) (93,000) (123,000) (110,000) (137,000) (161,000) (137,000) 1,171 TOTALEXPENDITURES (441,751) (744,000) (804,000) (679,000) (905,000) (841,000) (630,000) 1,172 1,173 Beginning Fund Balance 1,228,140 839,526 839,526 50,026 533,239 864,239 969,239 1,138,239 1,174 Endinz Fund Balance 839.526 110.026 50.026 533139 864 239 969 239 1 138 239 1 518 239 1,175 Restricted/Committed/Assigned 839,526 110,026 50,026 533,239 864,239 969,239 1,135,239 1,518,239 1,176 Unassigned Ending Balance $ - $ - $ - $ - $ - $ - $ - 1.177 1 • � � � ' ' � � 1,178 Contribution for WA euses Dept.10 $ - $ - $ - $ - $ - $ - $ - $ - 1,179 Interest Eamed Dept.10 10,870 3,000 3,000 3,000 4,000 4,000 4,000 4,000 1,180 Transfer In from GF Dept.88 - - 75,000 500,000 500,000 750,000 1,250,000 500,000 1,181 TOTALREVENUES 10,870 3,000 78,000 504,000 754,000 1,254,000 504,000 1,182 AcademyBuses Dept.10 - - - - (95,000) (65,000) - - 1,183 Fire Dept Vehides Dept 14 (17,944) - - (145,000) (125,000) (415,000) (2,756,000) (455,515) 1,184 MarshalTruck Dept.15 (63,145) - - - - - - - 1,185 FacilitiesTruck Dept.11 - - - - - - (65,000� - 1,186 Parks&Rec Mule Dept.19 - (18,000) �is,000) (18,000) - (20,000) - - 1,187 TOTAL EXPENDITURES (81,090) (18,000) (18,000) (220,000) (500,000) (2,851,000) (455,515) 1.188 1,189 Beginning Fund Balance 926,191 855,9R 855,9R 915,972 1,255,972 1,539,972 1,793,972 196,972 1,190 Ending Fund Balance 855.972 840.972 915.972 1155.972 1 539 972 1 793 972 196 972 245 457 1,191 Restricted/Committed/Assigned 855,9R 840,9R 915,9R 1,255,972 1,539,972 1,793,972 196,9R 245,457 1,192 Unassigned Ending Balance $ - $ - $ - $ - $ - $ - $ - 23 FIVE YEAR FINANCIAL FORECAST ALL MUNICIPAL FUNDS AUDITED ADOPTED REVISED � Projected Projected Projected Projected FY 19-20 FY 20-21 FY 20-21 FY 22-23 FY 23-24 FY 24-25 FY 25-26 t 193 � � � , 1,194 � 1 � ' � � � � � 1,195 HotelTax�Ma«iott) 1% $ 330,475 $ 350,000 5 200,000 $ 400,000 5 450,000 5 525,000 5 575,000 5 600,000 1,196 HotelTax�Other) 1% - - - - (230) (230) (230) (230) 1,197 HotelTax(Deloitte) 1% 19,335 28,000 28,000 28,000 36,000 36,360 36,724 37,091 Base Hotel Tax 349,809 378,000 228,000 428,000 485,770 561,130 611,494 636,861 1,198 HotelTax-Entrada 0% - - - - - - - - 1,199 HotelTax-Front44 0% - - - - - - - - Additional Commercial Tax - - - - - - - - 1,200 TotalHatelOccupancyTax 349,809 378,000 228,000 428,000 485,770 561,130 611,494 636,861 1,201 CommunityTreeLighting 1% 4,650 - - - 2,216 2,238 2,261 2,487 1,202 Interestlnmme 1% 7,594 3,500 3,500 3,500 7,000 7,500 8,000 5,500 1,203 Insur Refund/Equiry Return 1% - - - - - - - - 1,204 Misc Inmme 1% - - - - - - - - 1,205 Dept10-General5erviceRevenues 12,244 3,500 3,500 3,500 9,216 9,738 30,261 30,987 1,206 Membership Fees 1% - - - - - - - - 1,207 Special Events Revenue 1% - - - - - - - - 1,208 Sales of Printed Material 1% 300 100 100 100 - - - - 1,209 Misc Revenue 1% - - - - - - - - 1,210 Donations 1% - - - - - - - - 1,211 Sponsors 1% - - - - - - - - 1,212 Dept 24-Historical Board Revenues Other 300 300 300 300 - - - - 1,213 CarShow-RegisVations 1% 1,075 1,000 1,000 1,000 1,010 1,020 1,030 1,041 1,214 Car Show-Merchandise Sales 1% 3,365 2,000 2,000 2,000 2,020 2,040 2,061 2,081 1,215 Car Show-Pine Car Derby 1% 74 100 100 100 101 102 103 104 1,216 CarShow-Sponsors 1% 2,015 2,500 2,500 2,500 2,525 2,550 2,576 2,602 1,217 Dept24-CarShowRevenues 6,529 5,600 5,600 5,600 5,656 5,713 5,770 5,827 1,218 Transfer in from 6F - - - 500,000 250,000 250,000 250,000 250,000 1,219 TOTALREVENUES 368,882 387,200 237,200 750,642 826,581 877,524 903,675 1,220 Office Rent 1% (83,919) (79,500) (79,500) (79,500) (81,714) (84,090) (86,485) (SS,910) 1,221 TelephoneService 1% (108) (600) (600) (600) (606) (612) (618) (624) 1,222 Internet Expense 1% (3,710) (2,200) (2,200) (2,200) (2,222) (2,244) (2,267) (2,259) 1,223 ElecVic Service 1% (7,940) (9,100) (9,100) (9,100) (9,191) (9,283) (9,376) (9,469) 1,224 Dept10-Rent&UtilitiesExpenditures (95,676) (91,400) (91,400) (91,400) (93,733) (96,229) (98,746) (101,293� 1,225 OperatingXfrOuttoGFforPayrollCosts 1% (493,588) (197,476) (197,476) (320,736) (323,943) (3D,183) (330,455) (333,759) 1,226 Auditor 1% (8,000) (8,200) (8,200) (8,200) ($282) (5,365) (S,44S) (5,533) 1,227 Resident5urvey 1% - - - - - - - - 1,228 CommunityServices 1% - - - - - - - - 1,229 Marriott Marketing (7,400) (25,000) (25,000) (25,000) (25,000) (35,000) (50,000) (50,000) 1,230 Marriott Transportation 1% (40,000) (80,000) (80,000) (80,000) (80,000) (80,000) (80,000) (80,000) 1,231 Special Events 1% (245) - - - - - - - 1,232 PublicArtExpense 1% - - - - - - - - 1,233 Marketing&Promotions 1% (7,500) (7,500) (7,500) (7,500) (7,575) (7,651) (7,7D) (7,505) 1,234 Application Software Maint. 1% (3,704) (4,000) (4,000) (4,000) (4,040) (4,080) (4,121) (4,162) 1,235 Advertising/Public Notices 1% - - - - - - - - 1,236 CommunityTreeLighting 1% (21,143) - - (22,000) (22,220) (22,442) (22,667) (22,893) 1,237 Audio/Visual 1% - - - - - - - - 1,238 Dues&Subscriptions 1% (749) - - - - - - - 1,239 Dept10-General5ervice Expenditures (582,329) (322,176) (322,176) (467,436) (471,060) (484,721) (503,418) (507,152) 1,240 ConVact Services 1% (10,645) (20,000) (20,000) (20,000) (20,100) (20,201) (20,302) (20,403) 1,241 Communiry Services 1% (13,103) (13,400) (13,400) (13,400) (13,467) (13,534) (13,602) (13,670) 1,242 Masterworks 1% - - - - - - - - 1,243 Marketing&Promotions 1% (25,323) (30,000) (30,000) (30,000) (30,150) (30,301) (30,452) (30,605) 1,244 Marketing&Promotions Covid-19 (5,905) - - - - - - - 1,245 Community Pirnic 1% - - - - - - - - 1,246 Advertising/Public Notices 1% (22,482) (20,000) (20,000) (20,000) (20,100) (20,201) (20,302) (20,403) 1,247 Special Community Events 1% (1,458) (2,000) (2,000) (2,000) (2,010) (2,020) (2,030) (2,040) 1,248 Special Events Covid-19 1% (208) - - - - - - - 1,249 Dues&Subscriptions 1% (6,224) (7,250) (7,250) (7,250) (7,286) (7,323) (7,359) (7,396) 1,250 Postage&Supplies 1% - - - - - - - - 1,251 Printing 1% - (1,000) (1,000) (1,000) (1,005) (1,010) (1,015) (1,020) 1,252 Dept22-CommunicationExpenditures (85,348) (93,650) (93,650) (93,650) (94,118) (94,589) (95,062) (95,537) 1,253 y�ebsite Development/Maint. 0% - - - - - - - - t.254 Decoration Day/Memorial Day 0% - - - - - - - - t.255 Misc.Expense 0% - - - - - - - - 24 FIVE YEAR FINANCIAL FORECAST ALL MUNICIPAL FUNDS AUDITED ADOPTED REVISED � Projected Projected Projected Projected FY 19-20 FY 20-21 FY 20-21 FY 22-23 FY 23-24 FY 24-25 FY 25-26 t.256 PoppySales/Miscellaneous 0% - - - - - - - - 1,257 Advertising/PublicNotices 1% - - - - - - - - 1,258 Misc.Expense 0% (404) - - - - - - - 1,259 Office5upplies 0% - - - - - - - - 1,260 Special Events 0% - - - - - - - - 1,261 Constitution Day Expense 0% - - - - - - - - 1,262 CarShow-Website 1% (193) (15) (15) (15) (15) (15) (15) (16) 1,263 Membership Drive 0% - - - - - - - - 1,264 CarShow-Expenses 1% (7,934) (10,000) (10,000) (10,000) (10,100) (10,201) (10,303) (10,406) 1,265 Town Historical Board Expense 0% - - - - - - - - 1,266 Dept 24-Historical Board Expenditures (8,530) (10,015) (10,015) (10,015) (10,115) (10,216) (10,318) (10,422) 1,267 Consultant Fees 0% - - - - - - - - 1,268 Sponsorship Expense 0% - - - - - - - - 1,269 ContractServices 0% - - - - - - - - 1,270 Advertising/Public Notices 1% - - - - - - - - 1,271 Special Events 0% - - - - - - - - 1,272 Printing 0% - - - - - - - - 1,273 Dept 25-Public Art Expenditures - - - - - - - - 1,274 Misc.Expense 0% - - - - - - - - 1,275 Contract5ervices 0% - - - - - - - - 1,276 Dept 26 Arbor Day Expenditures - - - - - - - - 1,277 TOTAL EXPENDITURES (771,883) (517,241) (517,241) (669,027) (685,755) (707,544) (714,404) 1.278 1,279 Beginning Fund Balance R6,333 323,332 323,332 43,291 317,990 399,605 540,431 710,410 1,280 Endinz Fund Balance 323.332 193.291 43.291 317.990 399 605 540 431 710 410 899 681 1,281 Restricted/Committed/Assigned 323,332 193,291 43,291 317,990 399,605 540,431 710,410 899,681 1,282 Unassigned Ending Balance $ - $ - $ - $ - $ - $ - $ - 1,283 Operating Expenditures 771,883 517,241 517,241 662,501 669,027 685,755 707,544 714,404 1,284 OperatingDailyCost 2,115 1,4ll 1,4ll 1,815 1,533 1,879 1,938 1,957 1.285 OPERATING DAYS 153 136 31 175 218 288 366 460 t286 � 11 � : � � � � ' � 1,287 Sales&UseTax Revenues $ 1,844,725 $ 1,055,375 $ 1,500,000 $ 1,107,236 $ 1,1OS,041 $ 1,101,553 $ 878,619 $ 885,961 1,288 TOTALREVENUES $ 1,844,725 $ 1,055,375 $ 1,500,000 $ 1,108,041 $ 1,101,553 $ 878,619 $ 885,961 1,289 Transfer Out-DS Fund 300 $ (1,844,R5) $ (1,055,375) $ (1,500,000) $ (1,107,236) $ (1,108,041) $ (1,101,553) $ (878,619) $ (885,961) 1,290 TOTAL EXPENDITURES $ (1,844,725) $ (1,055,375) $ (1,500,000) $ (1,108,041) $ (1,101,553) $ (878,619) $ (885,961) 1.291 1,292 Beginning Fund Balance $ - $ - $ - - - - - - 1,293 Endinz Fund Balance S S S t.294 Restricted/Committed/Assigned $ - $ - $ - - - - - - t.295 Unassigned Ending Balance $ - $ - $ - - - - - 1.296 , / / / , / � , 1,297 Sales&Use Tax Revenues $ 50 5 - $ - 5 - $ - $ - $ - $ - 1,298 Hotel OccupancyTax Revenues ends 22/23 19,335 28,000 28,000 28,000 25,000 - - - 1,299 WA$lOK Lot Payment Revenues 280,000 - - - - - - - 1,300 TOTAL REVENUES 299,384 28,000 28,000 28,000 - - - 1,301 ED-Deloitte HotelTax ends 22/23 (19,335) (28,000) (zs,000) (28,000) (25,000) - - - 1,302 ED-Schwab5alesTax (130,702) - - - 1,303 TransferOut-WAE412 (280,000) - - - - - - - 1,304 TOTALEXPENDITURES (430,037) (28,000) (28,000) (28,000) - - - 1,305 1,306 Beginning Fund Balance 130,652 0.26 0 0 0 0 0 0 1,307 Endin¢Fund Balance 0 0 0 0 0 0 0 0 t.308 Restricted/Committed/Assigned 0 0 0 0 0 0 0 0 t.309 Unassigned Ending Balance $ - $ - $ - $ - $ - $ - $ - 25 FIVE YEAR FINANCIAL FORECAST ALL MUNICIPAL FUNDS AUDITED ADOPTED REVISED � Projected Projected Projected Projected FY 19-20 FY 20-21 FY 20-21 FY 22-23 FY 23-24 FY 24-25 FY 25-26 1,310 , � • � � . , � / � � 1,311 Development Fees(Platting) 0% $ - - - - - - - - 1,312 Miscellaneous Reimbursements 0% 13,501 - - - $ - $ - $ - $ - 1,313 TOTALREVENUES 13,501 - - - - - - 1,314 Consultant Fees 0% (3,862) (10,000) (10,000) (10,000) - - - - i,sis Boyle&Lowry oi �sso) �z,000) �z,000) �z,000) o.00 o.00 o.00 o.00 1,316 Admin Fees 0% (29) (100) (100) (100) 0.00 0.00 0.00 0.00 1,317 Filing Fees 0% - - - - - - - - 1,318 Engineering 0% - - - - - - - - 1,319 Construction Inspection 0% - - - - - - - - 1,320 Advertising 0% - - - - - - - - 1,321 Consultant Fees 0% - - - - - - - - 1,322 TOTAL EXPENDITURES (4,441) (12,100) (12,300) - - - - 1,323 1,324 Beginning Fund Balance 387,505 396,565 396,565 384,465 372,365 372,365 372,365 372,365 1,325 Endin¢Fund Balance 396.565 384.465 384.465 372.365 372 365 372 365 372 365 372 365 1,326 Restricted/Committed/Assigned 396,565 384,465 384,465 3R,365 3R,365 372,365 372,365 372,365 1,327 Unassigned Ending Balance $ - $ - $ - $ - $ - $ - $ - 1,328 , � � � � � � • � � � 1,32s Honorarium Dontations $ - $ - 5 - 5 - 5 - $ - $ - $ - 1,330 Contributions-Deloitte/WAF Contribution - - - - - - - - 1,331 Donations-Art Pieces - - - - - - - - 1,332 Transfer in from Capital Project-Fire Station 1��,��� - - - 1,333 TOTAL REVENUES 100,000 - - - - - - 1,334 Honorarium Expense (10,000) - - - - - - - 1,335 Dues&Subscriptions - - - - - - - - 1,336 TOTAL EXPENDITURES (30,000) - - - - - - 1,337 1,338 Beginning Fund Balance 10,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 1,339 EndinzFundBalance 100.000 100.000 100.000 100.000 300000 100000 100000 100000 1,340 Restricted/Committed/Assigned ioo,000 ioo,000 ioo,000 100,000 100,000 100,000 100,000 100,000 1,341 Unassigned Ending Balance - -$ - $ - $ - $ - $ - 1.342 , � • / � � � • , • � 1,343 Interestlncome $ 176 $ 50 5 50 $ 50 5 25 5 ZS 5 ZS 5 z5 1,344 TOTAL REVENUES 176 50 50 25 25 25 25 1,345 Filing Fee Expense - - - - - - - - 1,346 TOTAL EXPENDITURES - - - - - - - 1.347 1,348 Beginning Fund Balance 14,543 14,719 14,719 14,769 14,519 14,544 14,869 14,894 1,349 Endin¢FundBalance 14,719 14,769 14,769 14.819 14844 14869 14894 14919 1,350 Restricted/Committed/Assigned 14,719 14,769 14,769 14,819 14,844 14,869 14,894 14,919 1,351 Unassigned Ending Balance $ - $ - $ - $ - $ - $ - $ - 26 FIVE YEAR FINANCIAL FORECAST ALL MUNICIPAL FUNDS AUDITED ADOPTED REVISED � Projected Projected Projected Projected FY 19-20 FY 20-21 FY 20-21 FY 22-23 FY 23-24 FY 24-25 FY 25-26 t 352 , � • , 1,353 , / 1 , � � � � � � � 1,354 Transfer in-GF 100 $ 2R,089 $ 966,816 $ 449,876 $ - $ - $ - $ - $ - 1,355 Transferin-48200 1,844,725 1,055,375 1,500,000 1,107,236 1,1OS,041 1,101,553 S7S,619 SS5,961 1,356 TOTALREVENUES 2,116,814 2,022,191 1,949,876 1,108,041 1,101,553 878,619 885,961 1,357 Bank Charge - - - - 1,358 BankCharge-2011GOR8 Refundingof2002/2003 (400) (400) (400) - 1,359 Principal-Issue 2011 GORB Issue-2011-GORB (730,000) ��so,000) ��so,000) - 1,360 Interest-Issue 2011 GORB Program 10 (149,750) (1D,550) (127,550) - 1,361 TOTAL 2011 GORB (880,150) (877,950) (877,950) - - - - - 1,362 gank Charge-2011 CO Issue 2011 CO - 1,363 Principal-2011C0 Roadlmprovementr (96,000) (101,000) (106,000) (111,000) (1ll,000) 1,364 Interest-2011C0 Program011 (D,936) (25,572) (23,088) (20,484) (ll,748) 1,365 TOTAL 2011 CO - - - (123,936) (126,572) (129,088) (131,484) (134,748) 1,366 Bank Charge-Issue 2013 CO Splibut3m qcademy Expansion (440) (440) - - 1,367 Principal-Issue2013C0 qMENDEDto Issue-2013-CO (33,200) (71,875) - - 1,368 Interest-Issue 2013 CO 3o1 in FYu Program 12 (128,958) - - - 1,369 TOTAL 2013 CO (162,598) (72,315) - - - - - - 1,370 Bank Charge-2013 GORB Issue 2013 GORB (44�) 1,371 Principal-2013GORB Refundingof2018�A&S) (145,000) (150,000) (145,000) (155,000) (165,000) 1,372 Interest-2013GORB Program013 (Z3,838) (20,375) (ll,130) (13,830) (10,063) 1,373 TOTAL 2013 GORB - - - (169,278) (170,375) (162,130) (168,830) (175,063) 1,374 Bank Charge-Issue 2014 60RB Refunding of 2003 (400) (400) (400) (400) - - - - 1,375 Principal-Issue 2014 GORB Issue-2014-GORB (5,000) �s,000) (s,000) �s,000) (5,000) (5,000) (5,000) (5,000) 1,376 Interest-Issue 2014 GORB Program 14 (64,680) (64,500) (64,500) (64,320) (64,140� (63,960) (63,780) (63,600) 1,377 TOTAL 2014 GORB (70,080) (69,900) (69,900) (69,720) (69,140) (68,960) (68,780) (68,600) 1,378 Bank Charge-2017 GORB Refunding of 2007 (450) (450) (450) - 1,379 Principal-Issue20llGOR6 Issue-2017-GORB (35,000) (35,000) (35,000) - 1,380 Interest-Issue 20ll GORB Program 15 (ZZ6,375) (225,675) (225,675) - 1,381 TOTAL 2017 GORB (261,825) (261,125) (261,125) - - - - - 1,382 Bank Charge-20ll Tax Note Fire Station Tax Note - - - - - (550� - - 1,383 Principal-20llTaxNote Issue-20ll-TTN (Z15,000) (219,000) (219,000) (223,000) (227,000) (232,000) - - 1,384 Interest-20ll Tax Note Program 16 (18,211) (14,326) (14,326) (10,326) (6,254) (2,100) - - 1,385 TO7AL 20177axNote (233,211) (233,326) (233,326) (233,326) (233,254) (234,650) - - 1,386 gank Charge-20ll CO Fire Station Bonds (450) (450) (450) (450) - - - (450) i,sa� Pr�oaPai-iss�ezovco iss�e-zov-co Izlo,000) �zis,000) �zis,000) �zzs,000) (zso,000� (zss,000� (zas,000� (zso,000� i,saa i�eerese-issue zov co Program 17 Iz9s,soo) �z9z,izs) �z9z,izs) �zss,szs) (z�s,�oo� (z�i,�zs� (zea,szs� (zs�,ioo� i,sas rorn� xovco (sos,eso) (so�,s�s) (so�,s�s) (sio,e�s) �sos,�oo� �soe,�xs� �so9,sxs� �sm,sso� 1,390 TOTAL EXPENDITURES (2,116,814) (2,022,191) (1,949,876) (1,108,041) (1,101,553) (878,619) (885,961) 1,391 1,392 Beginning Fund Balance - - - - 0 0 0 - 1,393 Endin¢Fund Balance - - 0 0 0 1,394 Restricted/Committed/Assigned - - - - - - - - 1,395 Unassigned Ending Balance $ - $ - $ - 0 0 - - 1,396 , 1 , � � � � � � � � � � � 1,397 PropertyTax $ 682,926 $ 632,381 $ 703,883 $ 1,696,986 $ 1,805,715 $ 1,817,234 5 1,780,376 5 1,774,499 1,398 Current Year Penalty/Interest 1,630 - - - - - - - 1,399 Prior Year Penalty/Interest 256 - - - - - - - 1,400 PriorYearDelinquent 1,101 - - - - - - - 1,401 TOTALREVENUES 685,914 632,381 703,883 1,805,715 1,817,234 1,780,376 1,774,499 1,402 Bank Charge-2011 CO Issue 2011 CO - - - - - - - 1,403 Principal-2011C0 Roadlmprovements (87,000) (91,000) (91,000) - - - - t.404 Interest-2011C0 Program011 (32,293) (30,180) (30,180) - - - - i,aos rorn� xoii co (iie,2es) (i2i,iso) (i2i,iso) - - - - - 27 FIVE YEAR FINANCIAL FORECAST ALL MUNICIPAL FUNDS AUDITED ADOPTED REVISED � Projected Projected Projected Projected FY 19-20 FY 20-21 FY 20-21 FY 22-23 FY 23-24 FY 24-25 FY 25-26 1,406 Bank Charge-Issue 2013 CO Academy Expansion - - (440) - - - - - Split with 1,407 Principal-Issue 2013 CO Fund 300 Issue-2013-CO (158,150) (119,475) (191,350) (200,250) (204,700) (213,600) (213,600) (226,950) 1,408 Interest-Issue 2013 CO Program 12 (130,SR) (255,525) (255,525) (250,630) (245,056) (238,781) (232,373) (225,765) 1,409 TOTAL 2013 CO (289,022) (375,000) (447,315) (450,880) (449,756) (452,381) (445,973) (452,715) 1,410 Bank Charge-2013 GORB Issue 2013 GORB (�40) (440) (440) - - - 1,411 Principal-2013 GORB Refunding of 2018(A&5) (140,000) (145,000) (145,000) - - - - 1,412 Interest-2013 GORB Program 013 (31,025) (D,463) (D,463) - - - - 1,413 TOTAL 2013 GORB (171,765) (172,903) (172,903) - - - - - 1,414 Bank Charge - 1,415 BankCharge-2011GOR8 Refundingof2002/2003 (400) (400) (400) (400) (400) 1,416 Principal-Issue 2011 GORB Issue-2011-60R8 (770,000) (790,000) (520,000) (260,000) (260,000) 1,417 Interest-Issue 2011 GORB Program 10 (104,750) (81,350) (55,150) (36,250) (27,150) 1,418 TOTAL 2011 GORB - - - (875,150) (871,750) (875,550) (296,650) (287,550) 1,419 Bank Charge-2017 GORB Refunding of 2007 (450) (400) (400) (400) (400) 1,420 Principal-Issue 20ll GORB Issue-2017-60R8 (35,000) (35,000) (40,000) (605,000) (625,000) 1,421 Interest-Issue 2017 GORB Program 15 (ZZ4,888) (223,925) (222,800) (210,100) (185,500) 1,422 TOTAL 2017 GORB - - - (260,338) (259,325) (263,200) (815,500) (830,900) 1,423 Bank Charge-2021 CO CIP Issue 2021 CO - - - (440) (440) (440� (440) (440) 1,424 Principal-2021 CO Assume issuance in Aug 2021 - - - (140,000) (135,000) (140,000) (140,000) (145,000) 1,425 Interest-2021C0 Program021 - - - (83,182) (59,444) (85,663� (81,813) (77,894) 1,426 TOTAL 2021 CO - - - (223,621) (224,884) (226,303) (222,253) (223,334) 1,427 TOTAL EXPENDITURES (580,080) (669,083) (741,398) (1,805,715) (1,817,234) (1,780,376) (1,774,499) 1,428 1,429 Beginning Fund Balance 44,683 15Q518 15Q518 113,003 0 0 0 0 1,430 Endin¢Fund Balance 150.518 113,816 113,003 0 0 0 0 0 1,431 Restricted/Committed/Assigned 15Q518 113,816 113,003 0 0 0 0 0 1,432 Unassigned Ending Balance $ - $ - $ - $ - $ - $ - $ - 2$ FIVE YEAR FINANCIAL FORECAST ALL MUNICIPAL FUNDS AUDITED ADOPTED REVISED � Projected Projected Projected Projected FY 19-20 FY 20-21 FY 20-21 FY 22-23 FY 23-24 FY 24-25 FY 25-26 t433 � � � � � � 1 ,.449 � � 1 � ' � ' ' � � �,aso rransfer in from�F $ - $ - S - S - $ - $ - $ - 1,451 Interestlncome 30,095 15,000 15,000 5,000 5,000 5,000 5,000 5,000 1,452 Cemetary Improvements (565) - - - - - 1,453 Trail-Dove/Pearson/Aspen (2,598) - - - - - 1,454 Maintenance&Storage Facility (RS) - - - - - 1,455 Bond Proceeds - - - 3,353,602 - - 1,456 TOTALREVENUES 26,207 15,000 15,000 5,000 5,000 5,000 5,000 1,457 FM 1935 Town Improvements (41,295) - - - - - - - 1,458 Roanoke Road Recon/Drain South (8,290) - - (700,955) - - - - 1,459 170Townlmprovements (234,800) - - - - - - - 1,460 Sam School Road Recon&Drainage - - - - - (72,160) - - 1,461 Ottinger Road Reconstruction&Drainage (15,450) (593,250) (593,250) - - - - - 1,462 Pearson Lane Recon&Drainage (20,R5) - (20,831) (475,565) - - - - 1,463 Dove Road/FM1938 Signalization (6,732) - - - - - - - 1,464 Solana/FM 1938 Signalization (62,499) - - - - - - - 1,465 Flashing Crosswalk Lights - (25,000) (26,302) - - - - - 1,466 Solana Pavement Repairs (376,196) - - - - - - - 1,467 Wyck Hill Pavement Resurface (76,689) - - - - - - - 1,468 FM1938 Pavement Repairs - (90,400) (34,222) - - - - - i,ass SH 1145ervice Rd Construction (iv,4so) �ios,4so) �ios,4so) �ioo,000) (ioo,000� (so,000� - - 1,470 GPS Opticom Traffic Control - - - (91,250) - - - - 1,471 170Townlmprovements (234,800) - - - - - - - 1,472 ROAD and STREET IMPROVEMENTS DEP (960,126) (817,130) (783,085) (100,000) (122,160) - - 1,473 WA-PondRepairs - (82,000) (17,395) - - - - - 1,474 WA West Parking Improvements - - - - - - - - 1,475 Maintenance and Storage Facility (81,143) - - - - - - - 1,476 WAParkinglmprovements (61,R2) - - - - - - 1,477 FACILITY and GROUND IMPROVEMENTS DEP (142,864) (82,000) (17,395) - - - - 1,478 Software Upgrades for WA - - - (200,000) - - - - 1,479 Software Upgradesfor Municipality - - - - (200,000� - - - 1,480 FINANCE DEP - - - (200,000) - - - 1,481 Trail Connection at 114&Solana - - - - - (560,705) - - 1,482 Trail-WestlakeAcademytoCemetery - - - - - - - - 1,483 Trail-Dove/Pearson/Aspen (4,220) - (74,867) (459,250) - - - - 1,484 Wayfinding Signage (3,965) (214,700) (20,000) (214,700) (214,700) - - - 1,485 Cemetary lmprovements - - - (250,000) (64,3ll) - - - 1,486 PARKS/TRAIL/CEMETERYIMPROVEMENTS DEP (8,185) (214,700) (94,867) (279,017) (560,705) - - 1,487 FiberConnectivitybetweenBuildings (182,324) - (23,783) - - - - - 1,488 INFORMATION TECHNOLOGY IMPROVEMENTS (182,324) - (23,783) - - - - 1,489 TOTAL REVENUES AND TRANSFERS IN 26,207 15,000 15,000 3,358,602 5,000 5,000 5,000 5,000 1,490 TOTALEXPENDITURESANDTRANSFERSOUT (1,293,500) (3,113,830) (919,130) (2,491,720) (579,017) (682,865) - - 1.491 1,492 Beginning Fund Balance 2,708,144 1,440,851 1,440,851 536,721 1,403,603 S29,SS6 151,721 156,721 1,493 Endin¢Fund Balance 1,440,851 342,021 536.721 1.403.603 829 586 151 721 156 721 161 721 1,494 Restricted/Committed/Assigned Contributions/6rants/Bonds 1,440,851 342,021 536,R1 1,403,603 829,586 151,721 156,721 161,721 1,495 Unassigned Ending Balance $ - $ - $ - $ - $ - $ - $ - 29 FIVE YEAR FINANCIAL FORECAST ALL MUNICIPAL FUNDS AUDITED ADOPTED REVISED � Projected Projected Projected Projected FY 19-20 FY 20-21 FY 20-21 FY 22-23 FY 23-24 FY 24-25 FY 25-26 1,496 , � � � , � � • � , ♦ � 1,497 Transfer in from WA Exp 100,000 250,000 1,250,000 250,000 - - - - 1,498 Interestlnwme 109 - - - - 1,499 Contributions - - 1,250,000 - - 1,500 Contributions�WAAffiliates) 1,501 TOTALREVENUES 100,109 250,000 2,SOO,000 - - - - i,soz Engineering �m,sna) �zso,000) �zso,000) - 1,503 Construction - - - - - - - - 1,504 Design (29,884) - - (250,000) 1,505 TOTAL EXPENDITURES (50,427) (250,000) (250,000) - - - - 1,506 1,507 Beginning Fund Balance - 49,682 49,682 2,299,682 2,299,682 2,299,682 2,299,682 2,299,682 1,508 Ending Fund Balance 49.682 49.682 2.299.682 2.299.682 2 299 682 2 299 682 2 299 682 2 299 682 t.509 Restricted Funds 49,682 49,682 2,299,682 2,299,682 2,299,682 2,299,682 2,299,682 2,299,682 t.510 Unassigned Ending Balance $ - $ - $ - $ - $ - $ - $ - 1,511 � I � � � ' � � � 1,512 Interest Earned $ 33,706 $ 15,000 $ 15,000 $ 5,000 $ 5,000 $ 5,000 $ 5,000 $ 5,000 1,513 Contributions - - - - - - - - 1,514 Transfer in from ED 200 tied to bldg permits 280,000 - - - - - - - 1,515 TOTAL REVENUES 313,706 15,000 15,000 5,000 5,000 5,000 5,000 i,sis rra�sfero�ccon&s (zso,000) (i,zso,000) �zso,000) - - - - 1,517 TOTALEXPENDITURES - (250,000) (1,250,000) - - - - 1.518 1,519 Beginning Fund Balance 2,798,212 3,011,918 3,011,918 1,776,918 1,531,918 1,536,918 1,541,918 1,546,918 1,520 Ending Fund Balance 3.111.918 2.776.918 1.776.918 1.531.918 1,536,918 1,541,918 1,546,918 1,551,918 1,521 Restricted Funds 3,111,918 2,776,918 1,776,918 1,531,918 1,536,918 1,541,918 1,546,918 1,551,918 1,522 Unassigned Ending Balance $ - $ - $ - $ - $ - $ - $ - 30 I. STATEMENT OF PURPOSE The overall intent of the following Fiscal and Budgetary Policy Statements is to enable the Town to achieve a long-term stable and positive financial condition. The watchwords of the Town's financial management include integrity, prudence, stewardship, planning, accountability, and full disclosure. The more specific purpose is to provide guidelines to the Town Manager and Finance Director in planning and directing the Town's day-to-day financial affairs and in developing recommendations to the Town Manger and Town Council. The scope of these policies generally span, among other issues, accounting, purchasing, auditing, financial reporting, internal controls, operating and capital budgeting, revenue management, cash and investment management, expenditure control, asset management, debt management, and planning concepts, in order to: A. Present fairly and with full disclosure the financial position and results of the financial operations of the Town in conformity with generally accepted accounting principles (GAAP), and B. Determine and demonstrate compliance with finance related legal and contractual issues in accordance with provisions of the Texas Local Government Code and other pertinent legal documents and mandates. The Town Council will annually review and approve the Fiscal and Budgetary Policy Statements as part of the budget process. II. SUMMARY OF POLICY INTENDED OUTCOMES This policy framework mandates pursuit of the following fiscal objectives: A. Operating Budget: Prepare, conservatively estimate revenues, present, and adopt the Town's annual operating plan. B. Revenues Management: Design, maintain, and administer a revenue system that will assure a reliable, equitable,diversified, and sufficient revenue stream to support desired Town services. C. Expenditure Control: Identify priority services,establish appropriate service levels, and administer the expenditure of available resources to assure fiscal stability and the effective and efficient delivery of services. D. Fund Balance/Retained Earnings: Maintain the fund balance and retained earnings of the various operating funds at levels sufficient to protect the Town's credit worthiness as well as its financial position from emergencies. 31 E. Debt Management: Establish guidelines for debt financing that will provide needed capital equipment and infrastructure improvements while minimizing the impact of debt payments on current revenues. F. Intergovernmental Relationships: Where feasible,coordinate efforts with other governmental agencies to achieve common policy objectives,share the cost of providing governmental services on an equitable basis and support favorable legislation at the State and Federal level. G. Grants: Seek, apply for and effectively administer within this policy's guidelines, Federal, State, and foundation grants-in-aid which address the Town's current priorities and policy objectives. H. Economic Development: Initiate where feasible, encourage, and participate in economic development efforfs to create job opporfunities and strengthen the local tax base and economy I. Fiscal Monitoring: Prepare and present regular reports that analyze, evaluate, and forecast the Town's financial performance and economic condition. J. Financial Consultants: With available resources, seek out and employ the assistance of qualified financial advisors and consultants in the management and administration of the Town's financial functions. K. Accounting,Auditing,and Financial Reporting: Comply with prevailing Federal,State and local statues and regulations. Conform to generally accepted accounting principles as promulgated by the Government Accounting Standards Board (GASB), the American Institute of Certified Public Accountants (AICPA), and the Government Finance Officers Association (GFOA). L. Capital Improvement Plan/Budget and Program: Multi-year planning,forecasting, preparation, and control of the Town's capital improvement plan/budget. M. Capital Maintenance and Replacement: Annually review and monitor the state of the Town's capital equipment and infrastructure,setting priorities for its replacement and renovation based on needs,finding alternatives, and availability of resources. N. Internal Controls:To establish and maintain an internal control structure designed to provide reasonable assurances that the Town's assets are safeguarded and that the possibilities for material errors in the Town's financial records are minimized. 32 III. OPERATING BUDGET A. Preparation: Budgeting is an essential element of the financial planning,control and evaluation process of municipal government. The "operating budget" is the Town's annual financial operating plan. The budget includes all of the operating departments of the Town,the debt service fund, all capital projects funds, and the internal service funds of the Town. The proposed budget will be prepared with the cooperation of all Town departments, and is submitted to the Town Manager who makes any necessary changes and transmits the document to the Town Council. A budget preparation calendar and timetable will be established and followed in accordance with State law. B. Revenue Estimates for Budgeting: In order to maintain a stable level of services,the Town shall use a conservative, objective, and analytical approach when preparing revenue estimates.The process shall include analysis of probable economic changes and their impacts on revenues, historical collection rates, and trends in revenues.This approach should reduce the likelihood of actual revenues falling shorf of budget estimates during the year and should avoid mid-year service reductions. C. Balanced Budget: As per State Law, current operating revenues,including Properfy Tax Reduction Sales Tax transfers (which can be used for operations),will be sufficient to support current operating expenditures. Annually recurring revenue will not be less than annually recurring operating budget expenditures (operating budget minus capital outlay). Debt or bond financing will not be used to finance current expenditures. D. Proposed Budget Process: a proposed budget shall be prepared by the Town Manager with the participation of all of the Town's department directors. The proposed budget shall include four basic segments for review and evaluation: (1) personnel costs, (2) base budget for operations and maintenance costs, (3) service level adjustments for increases of existing service levels or additional services,and (4) revenues. • The proposed budget review process shall include Council parficipation in the review of each of the four segments of the proposed budget and a public hearing to allow for citizen participation in the budget preparation. • The proposed budget process shall allow sufficient time to provide review,as well as N address policy and fiscal issues, by the Town Council. • A copy of the proposed budget shall be filed with the Town Secretary when it is submitted to the Town Council as well as placed on the Town's website. E. Budget Adoption: Upon the determination and presentation of the final iteration of the proposed budget as established by the Council, a public hearing date and time will be set and publicized. The Council will subsequently consider a resolution which,if adopted, such budget becomes the Town's Approved Annual Budget. The adopted budget will be effective for the fiscal year beginning October 1. The approved budget will be placed on the Town's web site. 33 F. Budget Award: Each year the Council approved operating budget will be submitted annually to the Government Finance Officers Association (GFOA) for evaluation and consideration for the Award for Distinguished Budget Presentation. � G. Budget Amendments: Department Directors are responsible for monitoring their respective department budgets. The Finance Department will monitor all financial operations. The budget team will decide whether to proceed with a budget amendment and, if so,will then present the request to the Town Council. If the Council decides a budget amendment is necessary,the amendment is adopted in resolution format and the necessary budgetary changes are then made. H. Central Control:Modifications within the operating categories (salaries,supplies, maintenance,services, capital, etc.) can be made with the approval of the Town Manager. Modifications to reserve categories and interdepartmental budget totals will be made only by Town Council consent with formal briefing and Council action. I. Planning:The budget process will be coordinated so as to identify major policy issues for Town Council by integrating it into the Council's overall strategic planning process for the Town. Each department shall have a multi-year business plan that integrates with the Town's overall strategic plan. J. Reporting: Monthly financial reports will be prepared by the Finance Deparfment and distributed to and reviewed by each Director. Information obtained from financial reports and other operating reports is to be used by Directors to monitor and control deparfmental budget. Summary financial reports will be presented to the Town Council quarterly. K. Performance Measures& Productivity Indicators: Where appropriate, performance measures and productivity indicators will be used as guidelines to measure efficiency, effectiveness, and outcomes of Town services. This information will be included in the annual budget process as needed. L. Contingent Appropriation: During the budget process,staff will attempt to establish an adequate contingent appropriation in each of the operating funds. The expenditure for this appropriation shall be made only in cases of emergency, and a detailed account shall be recorded and reported. The proceeds shall be disbursed only by transfer to departmental appropriation. All transfers from the contingent appropriation will be evaluated using the following criteria: • Is the request of such an emergency nature that it must be made immediately? • Why was the item not budgeted in the normal budget process? • Why can't the transfer be made within the department? 34 IV. REVENUES MANAGEMENT A. Revenue Design Parameter: The Town will pursue the following optimum characteristics in its revenue system: Simplicity-The Town,where possible and without sacrificing accuracy,will strive to keep the revenue system simple in order to reduce costs,achieve transparency,and increase citizen understanding of Town revenue sources. • Certainty-A knowledge and understanding of revenue sources reliability increases the viability of the revenue system. The Town will understand,to the best of its ability,all aspects of its revenue sources and their performance,as well as enact consistent collection policies to provide assurances that the revenue base will materialize according to budgets,forecasts,and plans. • Equity-The Town shall make every effort to maintain equity in its revenue system: i.e. the Town shall seek to minimize or eliminate all forms of subsidization between entities, funds,services utilities,and customer classes within a utility. • Administration-The benefits of a revenue source will not exceed the cost of collecting that revenue. Every effort will be made for the cost of collection to be reviewed annually for cost effectiveness as a part of the Town's indirect cost and cost of service analysis. • Adequacy,Diversification and Stability-The Town shall attempt,in as much as is practical,to achieve a balance in its revenue system. The Town shall also strive to maintain a balanced and diversified revenue system to protect the Town from fluctuations in any one source due to changes in local economic conditions which adversely impact that revenue source. B. Other Considerations. The following considerations and issues will guide the Town in its revenue policies concerning specific sources of funds: Cost/Benefit of Incentives for Economic Development-The Town will use due caution in the analysis of any tax or fee incentives that are being considered to encourage economic development. A cost/benefit (fiscal impact) analysis will be performed as a part of the evaluation for each proposed economic development project. • Non-Recurring Revenues-One-time or non-recurring revenues will not be used to finance on-going operational costs. Non-recurring revenues will be used only for one- time expenditures such as long-lived capital needs or one-time major maintenance projects that occur infrequently. Non-recurring revenues will not be used for budget balancing purposes except to cover the one-time expenditures described above. 35 • Investment Income-Earnings from investment of available monies,whether pooled or not,will be distributed to the funds in accordance with the equity balance of the fund from which monies were provided to be invested. • Property Tax Revenues-The Town shall endeavor to avoid a property tax by revenue diversification,implementation of user fees,and economic development. C. User-Based(Demand Driven) Fees and Service Charges. For services that are demand driven and can be associated with a user fee or charge,the direct and indirect costs of that service will be offset by a fee where possible. The Town staff will endeavor to prepare a review of all fees and charges annually, but not less than once every three years,in order to ensure that these fees provide for,at minimum,full cost recovery of service. D. Enterprise Fund Rates. Utility rates and rate structures for water and sewer services will be constructed to target full cost of service recovery. Annually the Town will review and adopt water and sewer utility rates and a rate structure that generates revenue sufficient to fully cover operating expenses, meet the legal restrictions of all applicable bond covenants, provide for an adequate level of working capital,and recover applicable general/administrative costs. The Solid Waste function will have rates that fully recover all costs and maintain an adequate balance. The Cemetery Fund will be structured to operate on lot sales and endowments. • General and Administrative(G&A)Charges-Where feasible,G8�A costs will be charged to all funds for services of indirect general overhead costs,which may include general administration,finance,customer billing,facility use, personnel,technology, engineering,legal counsel,and other costs as deemed appropriate. These charges will be determined through an indirect cost allocation study following accepted practices and procedures. E. Intergovernmental Revenues. As a general rule,intergovernmental revenues (grants) will not be utilized for on-going operating costs. Any potential grant opportunity will be examined to identify all costs related to matching and continuation of program requirements. Staff will focus on one-time grants to avoid long-term implications. If it is determined that accepting a grant with on-going cost conditions is in the interests of the Town,all the operating and maintenance costs must be included in the financial forecast and their ultimate effect on operations and revenue requirements be known. F. Revenue Monitoring. Revenues as they are received will be regularly compared to budgeted revenues and variances will be investigated. This process will be summarized in the appropriate budget report. G. Special Revenue/Educational Funds. Where feasible and practical, General and Administrative Charges (G&A) for special revenue and educational funds of the Town of Westlake will be determined on an annual basis and transfers will be made where sufficient revenue exists to cover the associated expenditures. 36 V. EXPENDITURE CONTROL A. Appropriations-The point of budgetary control is at the department level in the General Fund and at the fund level in all other funds. When budget adjustments among Departments and/or funds are necessary,they must be approved by the Town Council. B. Current Funding Basis-The Town shall operate on a current funding basis. Expenditures shall be budgeted and controlled so as not to exceed current revenues plus the planned use of fund balance accumulated through prior year savings. (The use of fund balance shall be guided by the Fund Balance/Retained Earnings Policy Statements.) C. Avoidance of Operating Deficits-The Town shall take immediate corrective actions if at any time during the fiscal year expenditure and revenue re-estimates are such that an operating deficit (i.e., projected expenditures in excess of projected revenues) is projected at year-end.Corrective actions can include a hiring freeze,expenditure reductions,fee increases,or use of fund balance within the Fund. D. Balance/Retained Earnings Policy-Expenditure deferrals into the following fiscal year, short-term loans,or use of one-time revenue sources shall be avoided to balance the budget. E. Maintenance of Capital Assets-Within the resources available each fiscal year,the Town shall maintain capital assets and infrastructure at a sufficient level to protect the Town's investment,to minimize future replacement and maintenance costs, and to continue service levels. F. Periodic Program Reviews-The Town Manager shall undertake periodic staff and third- party reviews of Town programs for both efficiency and effectiveness. Privatization and contracting with other governmental agencies will be evaluated as alternative approaches to service delivery. Programs which are determined to be inefficient and/or ineffective shall be reduced in scope or eliminated. G. Salary-The Town shall strive to maintain competitive salary levels for municipal employees. A salary survey will be conducted through a sampling of surrounding and comparable municipal organizations to create a comparison. The Town will strive to maintain salary levels within three percent (3�) of the median of surveyed benchmark municipalities. H. Purchasing-The Town shall make every effort to maximize any discounts offered by creditors/vendors.Staff shall also use competitive bidding in accordance to State law,as well as intergovernmental partnerships and purchasing cooperatives to attain the best possible price on goods and services. I. Prompt Payment-All invoices will be paid within 30 days of receipt in accordance with the prompt payment requirements of State law. 37 VI. FUND BALANCE/RETAINED EARNINGS A. General Fund Undesignated Fund Balance-The Town shall strive to maintain the General Fund undesignated minimum fund balance at,or in excess of, 180 days of operation. B. Retained Earnings of Other Operating Funds-In the Utility Fund,the Town shall strive to maintain positive retained earnings positions to provide sufficient reserves for emergencies and revenue shortfalls. C. Use of Fund Balance-The Council delegates the responsibility to assign funds to the Town Manager or his/her designee. The Council shall have the authority to assign any amount of funds. Assignments may occur subsequent to fiscal year-end. The Council will utilize funds in the following spending order: Restricted,Committed,Assigned, Unassigned Fund Balance will be targeted to only be used with Council approval and can be only be used for the following: • Emergencies, • non-recurring expenditures such as technology/FF8�E (furniture,fixtures and equipment),or major capital purchases that cannot be accommodated through current year savings. • Should such use reduce the balance below the appropriate level set as the objective N for that fund,recommendations will be made on how to restore it. • The Council shall approve all commitments by formal action. The action to commit funds must occur prior to fiscal year-end,to reporf such commitments in the balance sheet of the respective period, even though the amount may be determined subsequent to fiscal year-end. • A commitment can only be modified or removed by the same formal action. D. General Fund Balance Specifically- Amounts of the General Fund's Fund Balance above the 180 day minimum in the General Fund may,with Council approval, be used for the following in descending order of priority: • Emergencies such as natural disaster response or repairs to major equipment failure or damage. • Specific capital improvement projects or be transferred to the Capital Projects Fund. • Major maintenance projects not meeting Capital Project criteria as identified in the Adopted Budget's Capital Improvement Plan. • Acquisition of technology hardware and/or software such as Geographic Information Systems (GIS), public safety technology enhancements,and fiber optic technology. • Local matches on State or Federal grants. • One-time (i.e. non-reoccurring) employee performance pay 38 VII. DEBT MANAGEMENT A. Debt Issuance Analysis- All consideration of debt issuance for major capital assets will be prepared within the framework of a Council approved multi-year capital improvement plan and forecast for all Town facilities and infrastructure. B. Analysis of Debt Issuance and Debt Issuance Alternatives-Staff will explore alternatives to the issuance of debt for capital acquisitions and construction projects. These alternatives will include, but not be limited to, • grants-in-aid • use of reserves • use of either current on-going general revenues or one-time revenues • contributions from developers and others • leases • userfees • impact fees C. Use of Debt Financing-The useful life of the asset or project shall,at a minimum,exceed the payout schedule of any debt the Town assumes. Debt financing instruments to be considered by the Town may include: N • General obligation bonds-These must be authorized by a vote of the citizens of Westlake. • Revenue bonds-These bonds generate capital requirements necessary for continuation or expansion of a service which produces revenue and for which the asset may reasonable be expected to provide for a revenue stream to fund the debt service requirement. • Certificates of obligation-These can be authorized by Council approval with debt service by either general revenues or backed by a specific revenue stream or a combination of both. • Lease/purchase agreements-These shall only be used to purchase capital assets that cannot be financed from either current revenues or fund balance/retained earnings and to fund infrastructure improvements and additions. D. Assumption of Additional Debt-The Town shall not assume more tax-supported general purpose debt than it retires each yearwithout first conducting an objective analysis as to the community's ability to assume and support additional debt service payments. E. Affordability Targets-The Town shall use an objective multi-year analytical approach to determine whether it can afford to assume new general purpose debt beyond what it retires each year.This process shall compare generally accepted standards of affordability to the current values for the Town.The process shall also examine the direct costs and benefits of the proposed expenditures.The decision on whether or not to assume new debt shall be based on these costs and benefits and on the Town's ability to 39 "afford" new debt as determined by the aforementioned standards.The Town shall strive to achieve and/or maintain these standards at a low to moderate classification. F. Debt Structure-The Town shall structure its debt payment schedules for general purpose debt to ensure level principal repayment schedules.The Town shall not assume any debt with"balloon'repayment schedules which consist of low annual payments and one large payment of the balance due at the end of the term.While balloon payment structures minimize the size of debt payments during the period,they force a large funding requirement on the budget of the final year. Given the uncerfainties of the future,level payment schedules improve budget planning and financial management. G. Sale Process-The Town shall use a competitive bidding process in the sale of debt unless the nature of the issue warrants a negotiated bid.The Town shall award bonds based on a true interest cost (TIC) basis as long as the financial advisor agrees that the TIC basis can satisfactorily determine the lowest and best bid. H. Bond Rating Agencies Presentations-Full disclosure of operations and open lines of communication shall be made to the bond rating agencies.Town staff,with assistance of financial advisors,shall prepare the necessary materials and presentation to the bond rating agencies. I. Continuing Disclosure-The Town is committed to continuing disclosure of financial and pertinent credit information relevant to the Town's outstanding securities. J. Debt Refunding-Town staff and the financial advisor shall monitor the municipal bond market for opportunities to obtain interest savings by refunding outstanding debt.As a general rule,the present value savings of a particular refunding should exceed 3.5�of the refunded maturities. VIII. INTERGOVERNMENTAL RELATIONSHIPS The Town will pursue coordinated efforts with other governmental agencies to achieve common policy objectives,share the cost of providing government services on an equitable basis,and support favorable legislation at the State and Federal levels. A. Inter-local Cooperation in Delivering Services-In order to promote the effective and efficient delivery of services,the Town shall actively seek to work with other local jurisdictions in joint purchasing consortia,sharing facilities,sharing equitably the costs of service delivery,and developing joint programs to improve service to its citizens. 40 B. Legislative Program-The Town shall cooperate with other jurisdictions to actively oppose any State or Federal regulation or proposal that mandates additional Town programs or services and does not provide the funding to implement them.Conversely,as appropriate, the Town shall support legislative initiatives that provide more funds for priority local programs. IX. GRANTS A. Grant Guidelines-The Town shall apply,and facilitate the application by others,for only those grants that are consistent with the objectives and high priority needs previously identified above in these policies. The potential for incurring on-going costs,to include the assumption of support for grant funded positions from local revenues,will be considered prior to applying for a grant. B. Grant Review-All grant submittals shall be reviewed for their cash match requirements, their potential impact on the operating budget, and the extent to which they meet the Town's policy objectives.If there are cash match requirements,the source of funding shall be identified prior to application. Staff will focus on one-time grants to avoid long-term implications related to additional expenditures in future years. C. Grant Program Termination-The Town shall terminate grant funded programs and associated positions when grant funds are no longer available unless alternate funding is identified. X. ECONOMIC DEVELOPMENT A. Positive Business Environment-The Town shall endeavor,through its regulatory and administrative functions,to provide a positive business environment in which local businesses can grow,flourish and create jobs.The Town Council and Town staff will be sensitive to the needs,concerns and issues facing local businesses. B. Commitment to Business Expansion, Diversification,and Job Creation-The Town shall encourage and participate in economic development efforts to expand Westlake's economy to increase local employment.These efforts shall not only focus on newly developing areas but also on other established sections of Westlake where development can generate additional jobs and other economic benefits. C. Coordinate Efforts with Other Jurisdictions-The Town's economic development program shall encourage close cooperation with other local jurisdictions,chambers of commerce, and groups Interested in promoting the economic well-being of this area. D. Cost/Benefit of Incentives for Economic Development-The Town will use due caution in the analysis of any tax or fee incentives that are used to encourage economic development. 41 A cost/benefit (fiscal impact) analysis will be performed as part of such evaluation for each prospect. Economic development agreements will contain performance language as to the business's proposed economic impact to Westlake in exchange for Town incentives with adequate "claw-back" provisions for the Town. XI. FISCAL MONITORING A. Financial Status and Performance Reports-Quarterly reports comparing expenditures and revenues to current budget, projecting expenditures and revenues through the end of the year,noting the status of fund balances to include dollar amounts and percentages,and outlining any remedial actions necessary to maintain the Town's financial position shall be prepared for review by the Town Manager and the Council. B. Compliance with Council Policy Statements-The Fiscal and Budgetary Policies will be reviewed annually by the Council and updated,revised or refined as deemed necessary. Policy statements adopted by the Council are guidelines,and occasionally, exceptions may be appropriate and required. However,exceptions to stated policies will be specifically identified,and the need for the exception will be documented and fully explained. XII. FINANCIAL CONSULTANTS To employ the assistance of qualified financial advisors and consultants as needed in the management and administration of the Town's financial functions.These areas include but are not limited to investments,debt administration,financial accounting systems, program evaluation,and financial impact modeling.Advisors shall be selected on a competitive basis using objective questionnaires and requests for proposals based on the scope of the work to be performed. XIII. ACCOUNTING, AUDITING, AND FINANCIAL REPORTING To complywith prevailing local,state,and federal regulations relative to accounting,auditing, and financial reporting. Accounting practices and financial reporting shall conform to generally accepted accounting principles as promulgated by the Governmental Accounting Standards Board (GASB),the American Institute of Certified Public Accountants, (AICPA),and the Government Finance Officers Association (GFOA).The Board shall select an independent firm of certified public accountants to perform an annual audit of all operations A. Accounting-The Town is solely responsible for the recording and reporfing of its financial affairs,both internally and externally. The Town's Finance Director is responsible for establishing the structure for the Town's chart of accounts and for assuring that procedures are in place to properly record financial transactions and report the Town's financial position. 42 B. External Auditing-Town will be audited annually by outside independent accountants (auditors). The auditors must be a CPA firm and must demonstrate significant experience in the field of local government auditing. They must conduct the town's audit in accordance with generally accepted auditing standards and be knowledgeable in the Government Finance Officers Association Cerfificate of Achievement program. The auditors' report on Town's financial statements will be completed within a timely period of the Town's fiscal year-end. The auditor will jointly review the management letter with the Town Council,if necessary. In conjunction with this review,the Finance Director shall respond in writing to the Town Council regarding the auditor's Management Letter, addressing the issued contained therein. The Town will not require auditor rotation, but will circulate request for proposal for audit services on a periodic basis as deemed appropriate. C. External Financial Reporting-Town will prepare and publish a comprehensive annual financial report (CAFR). The CAFR will be prepared in accordance with generally accepted accounting principles and will be presented annually to the Government Finance Officers Association (GFOA) for evaluation and awarding of the Cerfificate of Achievement for Excellence in Financial Reporting. D. Responsibility of Auditor to Town Council-The auditor is retained by and it accountable directly to the Town Council and will have access to direct communication with the Town Council if the Town Staff is unresponsive to auditor recommendations or if the auditor considers such communication necessary to fulfill its legal and professional responsibilities. E. Internal Financial Reporting-The Finance Department will prepare internal financial reporfs sufficient for management to plan, monitor,and control Town's financial affairs. XIV. CAPITAL BUDGET AND PROGRAM A. Preparation-The Town's capital budget will include all capital projects funds and all capital resources. While the capital budget will be prepared annually on a project basis,it will be based on an on-going, multi-year capital improvement plan (CIP) that shows all funded and unfunded projects as identified by staff for all Town facilities and infrastructure. The multi-year CIP will be reviewed annually,updated by staff and presented to the Council for its review and approval. The annual capital budget will be prepared by the Finance Department with the involvement of responsible departments based on the multi- year CIP. B. Control-All capital project expenditures must be appropriated in the capital budget. The Finance Director must certify the availability of resources before any capital project contract is presented to the Town Council for approval. C. Program Planning-The capital budget will be taken from the capital improvements project plan for future years. The planning time frame for the capital improvements project plan should normally be five years,with a minimum of at least three years. The 43 replacement and maintenance for capital items should also be projected for the next five years. Future maintenance and operational costs will be considered so that these costs can be included as appropriate in the annual budget. D. Financing Programs-Where applicable and with Council approval,impact fees, pro-rata charges,assessments,or other fees should be used to fund capital projects which have a primary benefit to specific,identifiable property owners. Recognizing that long-term debt is usually a more expensive financing method,alternative financing sources will be explored before debt is issued. When debt is issued,it will be used to acquire major assets with expected lives which equal or exceed the average life of the debt issue. E. Reporting-Periodic financial reports will be prepared to enable the deparfment directors to manage their capital budgets. Summary capital project status reports will be presented to the Town Council quarterly. XV. CAPITAL MAINTENANCE AND REPLACEMENT The Town recognizes that deferred maintenance and not anticipating capital replacement needs increases future capital costs. Annually,available funds will be evaluated during the budget process and a percentage of each operating fund's budget will be recommended to the Council for transfer. Upon approval by the Council,the recommended amount will be transferred to the appropriate funds (General/Utility/Vehicle Maintenance Replacement Fund) for major maintenance and replacement of street,building roof,flooring,air conditioning,equipment, etc. XVI. INTERNAL CONTROLS A. Written Procedures-Whenever possible,written procedures will be established and maintained by the Finance Director for all functions involving purchasing,cash handling and/or accounting throughout the Town. These procedures will embrace the general concepts of fiscal responsibility set for in this policy statement. B. Department Directors' Responsibilities-Each department director is responsible for ensuring that good internal controls are followed throughout his/her department,that all directives or internal controls are implemented,and that all independent auditor internal control recommendations are addressed. Deparfments will develop and periodically update written internal control procedures. 44 XVII. ASSET MANAGEMENT A. Investments-The Finance Director shall promptly invest all Town funds with the depository bank in accordance with the provisions of the current Bank Depository Agreement or in any negotiable instrument authorized by the Town Council. Further,investments shall be made in accordance with the Investment Policy approved by the Town Council for the Town of Westlake that meets the requirements of the Public Funds Investment Act (PFIA), Section 2256 of the Texas Local Government Code. The Finance Director will issue quarferly reporfs on investment activity to the Town Council. B. Cash Management-Town's cash flow will be managed to maximize the cash available to invest. Such cash management will entail the centralization of cash collections,where feasibility,including utility bills, building and related permits and license,fines,fees,and other collection offices as appropriate. Periodic review of cash flow position will be performed to determine performance of cash management and conformance to investment policies. The underlying theme will be that idle cash will be invested with the intent to (1) safeguard assets, (2) maintain liquidity,and (3) maximize return. C. Fixed Assets and Inventory-Such assets will be reasonably safeguarded and properly accounted for and prudently insured. The fixed asset inventory will be updated regularly. D. Capitalization Criteria-For purposes of budgeting and accounting classification,the following criteria must be capitalized: • The asset is owned by the Town of Westlake • The expected useful life of the asset must be longer than one year, or extend the life on an identifiable existing asset by more than one year • The original cost of the asset must be at least$5,000 • The asset must be tangible • On-going repairs and general maintenance are not capitalized • New Purchases-All costs associated with bringing the asset into working order will be capitalized as part of the asset cost. This includes start-up costs,engineering or consultant type fees as part of the asset cost once the decision or commitment to purchase the asset is made. The cost of land acquired should include all related costs associated with its purchase • Improvements and Replacement-Improvement will be capitalized when they extend the original life of an asset or when they make the asset more valuable than it was originally. The replacement of assets components will normally be expenses unless they are a significant nature and meet all the capitalization criteria. E. Computer System/Data Security-The Town shall provide security of its computer/network system and data files through physical and logical security systems that will include, but are not limited to: network user authentications,firewalls,content filtering,spam/virus protection,and redundant data backup. N � 45 FUNDED CAPITAL IMPROVEMENT PROJECT FORECAST � Totals FY 2021 FY 2022 FY 2023 FY 2024 FY 2025 PROJECT � Project Description thru Adopted Revised Proposed Projected Projected Projected GRAND a FY 2020 Budget Budget Budget Budget Budget Budget TOTAL CP20 FM1938 Town Improvements 3,432,780 - - - - - - 3,432,780 CP34 Roanoke Road Reconstruction&Drainage South 72,118 - - 700,955 - - - 773,073 CP40 Sam School Road Reconstruction&Drainage 26,828 - - - - 72,160 - 98,988 CP75 Flashing Crosswalk-Dove @ Pearson/Ottinger 31,044 25,000 26,302 - - - - 57,346 CP78 Solana Pavement Repairs 376,196 - - - - - - 376,196 CP80 FM1938 Pavement Repairs - 90,400 34,222 - - - 34,222 CP82 SH114 Service Road Construction 157,450 108,480 108,480 100,000 100,000 50,000 - 515,930 CP83 GPS Opticom Traffic Control - - - 91,250 - - - 91,250 Total- Road Improvements- Dept 16 4,096,415 223,880 169,004 892,205 100,000 122,160 - 5,379,784 CP77 WA Pond Repairs - 82,000 17,395 - - - - 17,395 Total- Facility Improvements- Dept 17 - 82,000 17,395 - - - - 17,395 CP86 Software Upgrades for WA - - - 200,000 - - 200,000 CP87 Software Upgrades for Municipality - - - 200,000 - - 200,000 Total- Finance- Dept 18 - - - 200,000 200,000 - - 400,000 CP67 Wayfinding Signage 3,965 214,700 20,000 214,700 214,700 - - 453,365 CP76 Cemetery Improvements 113,752 - - 250,000 64,317 - - 428,069 Total-Trail/Park/Cemetery- Dept 19 117,717 214,700 20,000 464,700 279,017 - - 881,434 CP52 Trail-Academy to Cemetery - - - - - 560,705 - 560,705 CP58 Ottinger Road Recon/Drainage 44,770 593,250 593,250 - - - - 638,020 CP53 Trail-Dove/Pearson/Aspen 4,220 - 74,867 459,250 - - - 538,337 CP60 Pearson Lane Recon/Drainage 77,713 - 20,831 475,565 - - - 574,109 Total-Trail and Road Improvements- Dept 16-19 126,703 593,250 688,948 934,815 - 560,705 - 2,311,171 CP81 Fiber Connectivity Project 193,846 - 23,783 - - - - 217,629 Total - Information Technology- Dept 20 193,846 - 23,783 - - - - 217,629 TOTAL GOVERNMENTAL PROJECTS 4,534,680 1,113,830 919,130 2,491,720 579,017 682,865 - 9,207,412 Totals FY 2021 FY 2022 FY 2023 FY 2024 FY 2025 PROJECT Funding Summary thru Adopted Revised Adopted Projected Projected Projected GRAND FY 2020 Budget Budget Budget Budget Budget Budget TOTAL Cash/Fund Balance (Formerly adopted) 4,534,680 1,113,830 919,130 200,000 200,000 - - 5,853,810 FY21/22 Bonds 20 Year-Street/Trail - - - 2,291,720 379,017 682,865 - 3,353,602 GRAND TOTAL ALL PROJECTS 4,534,680 1,113,830 919,130 � ' � 579,017 682,865 - 9,207,412 46 UNFUNDED/UNDER DISCUSSION CAPITAL IMPROVEMENT PROJECT FORECAST Totals FY 2021 � FY 2023 FY 2024 FY 2025 FY 2026 PROJECT Dept Project Description Thru Revised Projected Projected Projected Projected GRAND No. FY 2020 Budget Budget Budget Budget Budget TOTAL 16 Hwy 170,377 and Schwab Way Traffic $ $ _ $ _ $ _ $ 495,000 $ - $ - $ 495,000 Signal Upgrade 16 Dove Road&Randol Mill Traffic Circle - - - - - 83,600 1,108,800 1,192,400 16 Glenwyck Farms Telecommunications _ _ - 1,003,200 - - 1,003,200 Ductbank 16 SH 114/170 Enhancements 239,433 - - - - 913,651 - 1,153,084 Sub-Total-Road/Street Improvements 239,433 - - - 1,498,200 997,251 1,108,800 3,843,684 17 Municipal Town Hall - - - - 10,000,000 - 10,000,000 17 WA Arts&Sciences Center Expansion - - - 9,500,000 - - - 9,500,000 Sub-Total-Facility Improvements - - - 9,500,000 10,000,000 - - 19,500,000 19 Hwy 377 Landscape Improvements(Phase _ _ _ - 577,500 110,000 687,500 I and II) 19 Trail-Fidelity Campus to WL Parkway at _ _ _ 412,500 - - 412,500 Hwy 114 19 Cemetery Improvements - - - 150,000 50,000 - - 200,000 19 15-30 Acre Community Park - - - - - 10,500 211,000 221,500 Sub-Total-Trail/Park/Cemetery Improvements - - - 150,000 462,500 588,000 321,000 1,521,500 TOTAL UNFUNDED(UNDER DISCUSSION) $ 239,433 $ - � $ 9,650,000 $ 11,960,700 $ 1,585,251 $ 1,429,800 $ 24,865,184 � 47 .: — - , e 'i �11 � � '��fi w�:�` � '`d,,w��,7 r`��'�r� ,�� �� q��� § 'd, `� N,� J� �' �.+�'T ' M ���. '� �� ������ �i����"d<� " �� ; � ��`. '�,:. � :�������.:� � T H E T � 1N N � F � . r-} , , � ;,ti _,..� , .„�,- � � � DI � T � �V � TIIIE � � DE � IGN , .,� �_„ Academic FY 2021/2022 Budget Revenue Assumptions State Revenue ■ Increase $104K in FY 22 due to increases in Available School and CTE funding ■ Enrollment FY 21/22: 875 students increasing to 885 FY 23/24 through FY 24/25, increasing revenue by $77K per year ■ Enrollment FY 25/26: 890 students, increasing revenue by $78K State Facilities Allotment ■ FY 22 Proposed Allotment: $143K, a decrease of 11% over FY 21, and a 21% decrease since the program's FY 19 inception ■ Assigned in Fund Balance: 50%, cumulative each year, estimated reserve in FY 22 is $173K Local Revenue ■ Bank Interest: Calculated at 0.25% rate ■ Westlake Academy Foundation: Remains steady at $1.03M ■ Misc Revenue: 9% increase over the FY 21 amended budget due to increased in-person attendance Academic Budget Expenditure Assumptions Payroll ■ Step increase plus 1% for Teachers, Librarians, Counselors, & Nurses and 1% for Administrative & Hourly staff; combined total less than $75K. ■ Total Full-Time Equivalent (FTE): 104.34 (2.50 increase over FY 21) ■ FTE change includes adding a Primary Special Education Teacher, increasing the Middle Years Programme Curriculum Coordinator to a full FTE, and reclassifying a vacant PE Teacher position to two Instructional Aides Technolo�y ■ iPad Initiative: 3rd year of lease, remains steady at $200K Other Expenditures ■ Guidance & Counseling: $5K increase for SPED contracted services and travel ■ Extra-/Co-Curricular Activities: $7K increase for field rentals (11-man football) and post- season tournaments ■ General Administration: $10K increase, which include adjustments in legal fees and technology, and contracted services for executive search consultants ■ Technology: $16K increase for contracted services, replacements, and repairs and additional staff training 49 Westlake Academy- General Fund - Five Year Financial Forecast Fiscal Years 2021/2022 through 2025/2026 Audited Adopted Amended Proposed amounc projected Projected Projected Projected FY 19/20 FY 20/21 FY 20/21 FY 21/22 Inc/(Dec) FY 22/23 FY 23/24 FY 24/25 FY 25/26 i REVENUE 2 Transportation $ 7,000 $ 10,500 $ 10,500 $ 10,500 S - $ 10,500 $ 10,500 $ 10,500 $ 10,500 3 Parking 1,820 15,000 15,000 15,000 - 15,000 15,000 15,000 15,000 a Athletic Activities 75,095 88,100 88,100 88,100 88,100 88,100 88,100 88,100 s Interest Earned 17,293 10,000 5,000 5,000 - 5,000 5,000 5,000 5,000 s WAF Blacksmith Donation 1,031,311 1,030,000 1,030,000 1,030,000 1,030,000 1,030,000 1,030,000 1,030,000 � Salary Reimbursement(liaison to WAF) 71,431 71,235 71,235 72,660 i,azs 73,387 74,121 74,862 75,611 8 Municipal Transfer 219,750 - - - - - - - - 9 Other Local Revenue(sub,tech,prnt,misc) 31,349 47,300 32,200 35,000 z,800 35,000 35,000 35,000 35,000 io Technology Equipment Sale Proceeds - - - - - - - - - 11 Food Services 7,000 7,000 4,000 7,000 3,000 7,000 7,000 7,000 7,000 iz Total Local Revenues 1,462,048 1,279,135 1,256,035 1,263,260 �,zzs 1,263,987 1,264,721 1,265,462 1,266,211 13 Percent of total revenues 16% 14% 13% 1396 13% 13% 13% 1396 ia TEA-AvailableSchool Funds 270,996 212,000 212,000 332,570 1zo,57o 335,896 339,255 342,647 346,074 is TEA-Foundation School Funds(incl accr) 6,613,138 7,024,142 7,024,142 6,770,269 (z53,s73) 6,837,972 6,906,351 6,975,415 7,045,169 16 CTE Funding(addt'I TEA-FSP Funds) 495,800 263,366 263,366 518,096 zsa,�3o 523,277 528,510 533,795 539,133 v Facilities Allotment(addt'I TEA-FSP Funds) 160,500 160,500 160,500 143,098 (v,aoz) 143,098 143,098 143,098 143,098 is TEA-Advanced PlacementTraining 6,750 6,750 6,750 6,750 6,750 6,750 6,750 6,750 is SB-500 SPED Services 5,172 - - - - - - - - zo TRS On-behalf/Medicare Part B 405,627 486,085 486,085 495,807 9,7zz 500,765 505,773 510,830 515,939 u Total State Revenues 7,957,983 8,152,843 8,152,843 8,266,590 iis,�a� 8,347,757 8,429,737 8,512,535 8,596,162 22 Percentoftotalrevenues 84% 86% 87% 87% 87% 87% 87% 87% z3 TOTAL REVENUES $9,420,030 $9,431,978 $9,408,878 $9,529,850 S 1zo,97z $9,611,744 $9,694,457 $ 9,777,997 $ 9,862,373 za EXPENDITURES by FUNCTION zs Function 11-Instructional $5,566,302 $5,141,964 $5,108,409 $5,131,786 S z3,3n ze Function 12-Resources&Media 88,513 95,802 95,802 98,983 3,1s1 z� Function 13-Curriculum&Staff Development 57,790 64,045 55,595 55,795 200 z8 Function 21-Instructional Leadership 154,252 191,240 191,240 193,053 i,ai3 29 Function 23-School Leadership 1,060,501 1,117,395 1,121,368 1,128,090 5,7zz 3o Function 31-Guidance&Counseling 569,417 604,282 613,976 623,119 9,143 31 Function 33-Health Services 77,264 82,673 84,867 83,457 (i,aio� 3z Function 36-Co/Extracurricular Activities 253,652 272,047 282,547 291,708 9,161 33 Function 41-Administrative 244,889 241,995 242,579 248,652 6,073 sa Function 51-Maintenance&Operations 976,930 983,676 1,043,676 987,229 (s6,aa�) 3s Function 52-Security&Monitoring 20,150 26,800 26,800 26,800 - 36 Function 53-Data Processing 213,941 221,565 236,625 290,534 53,909 3� Function 61-Community Services 136,790 142,471 142,471 143,896 i,azs 3s Function 71-Debt Service 207,922 207,922 207,922 207,922 - 39 TOTAL EXPENDITURES by FUNCTION $9,628,313 $9,393,877 $9,453,877 $9,511,024 5 5�,14� ao EXPENDITURES by OBIECT ai Object Code 61XX-Salaries $7,164,320 $7,425,791 $7,443,096 $7,500,222 S s�,iz6 $7,575,224 $7,650,976 $ 7,727,486 $ 7,804,761 az Object Code 62XX-Contracted Services 1,000,956 932,785 980,005 994,073 i4,o68 994,073 994,073 994,073 1,004,014 u3 Object Code 63XX-Supplies&Materials 836,953 362,074 352,019 373,920 zi,9oi 373,920 373,920 373,920 377,659 44 Object Code 64XX-Other Operating Costs 418,162 465,305 470,835 434,887 (35,9as) 455,887 473,887 473,887 478,626 as Object Code 65XX-Debt Service 207,922 207,922 207,922 207,922 - 207,922 226,002 226,002 226,002 u6 TOTAL EXPENDITURES by OBIECT $9,628,313 $9,393,877 $9,453,877 $9,511,024 $ 5�,14� $9,607,026 $9,718,859 $ 9,795,368 $ 9,891,062 u� Other Resources-Local $ 585,623 $ - $ - $ - 5 - $ - $ - $ - $ - as Transfer in-Athletics(198) 90,000 90,000 90,000 45,000 (as,000) 45,000 45,000 45,000 45,000 as Transfer out-General Fund(199) (90,000) (90,000) (90,000) (45,000) as,000 (45,000) (45,000) (45,000) (45,000) so Transfer out-SRF Covid-19(491) - - - - - - - - - si NET OTHER RESOURCES&USES SS5,623 - - - - - - - - sz EXCESS REVENUES OVER�UNDER)EXP $ 377,340 $ 38,101 $ (44,999) $ 18,826 5 63,az5 $ 4,718 $ (24,401) $ (17,371) $ (28,689) ss FUND BALANCE BEGINNING 1,373,837 1,751,177 1,751,177 1,706,178 (aa,999) 1,725,004 1,729,722 1,705,320 1,687,949 sa FUND BALANCE ENDING 1,751,177 1,789,278 1,706,178 1,725,004 i8,8z5 1,729,722 1,705,320 1,687,949 1,659,260 ss Less:Assigned for Bus Maintenance (24,090) (19,000) (19,000) (17,000) z,000 (16,150) (15,343) (14,575) (13,847) se Less:Assigned for Technology R&M (54,000) (54,000) (50,000) a,000 (47,500) (45,125) (42,869) (40,725) s� Less:Assigned for Ath Uniform/Equip Rplcmnt (15,000) (15,000) (15,000) (15,000) (15,000) (15,000) (15,000) (15,000) sa FUND BALANCE ENDING(Unassigned) $1,712,087 $1,701,278 $1,618,178 $1,643,004 5 Z4,8zs $1,651,072 $1,629,853 $ 1,615,505 $ 1,589,688 s9 Number of Operating Days(unassigned FA) 65 66 62 63 1 63 61 60 59 eo Facilities Allotment Reserve (85,563) (161,593) (101,593) (173,142) pi,sa9) (244,691) (316,240) (387,789) (459,338) 61 FUND BALANCE ENDING(Unassigned) $1,626,525 $1,539,686 $1,516,586 $1,469,862 5 ac,3�a $2,053,062 $2,097,027 $ 2,148,182 $ 2,188,170 6z Number of Operating Days(assigned 50%FA) 62 60 59 56 (z) 78 79 80 Sl ea Dollars per Operating Day $ 26,379 $ 25,737 $ 25,901 $ 26,058 is� $ 26,321 $ 26,627 $ 26,837 $ 27,099 sa Total Students Enrolled 869 885 856 875 19 885 885 885 890 ss TEA Funding per Student $ 8,492 $ 8,655 $ 8,949 $ 8,873 (75) $ 8,859 $ 8,946 $ 9,034 $ 9,071 66 Operating Cost per Student(Academic Only) $ 11,080 $ 10,615 $ 11,044 $ 10,870 (vs) $ 10,855 $ 10,982 $ 11,068 $ 11,114 6� Teachers 7030 7030 71.01 70.18 (o.s3) 70.18 70.18 70.18 70.18 6s Student/Teacher Ratio 12.36 12.59 12.05 12.47 O.ai 12.61 12.61 12.61 12.68 50 69 ALL Faculty&Staff 101.13 100.25 101.84 104.34 z.so 104.34 104.34 104.34 104.34 Five Year Forecast Summary ACADEMIC GENERAL FUND Proposed Projected Projected Projected Projected FIVE YEAR FORECAST fY 21/22 FY 22/23 FY 23/24 FY 24/25 FY 25/26 � Total Revenues $9,529,850 $9,611,744 $9,694,457 $9,777,997 $9,862,373 2 Total Expenditures 9,511,024 9,607,026 9,718,859 9,795,368 9,891,062 _ ,,,,,,,,,,,,,,,,,,,,,, ,,,,,,,,,,,,,,,,,,,,,,,,, ,,,,,,,,,,,,,,,,,, a NetOtherSources/Uses - - - - - 4 Excess Revenues Over(under)Expenditures 18,826 4,718 (24,401) (17,371) (28,689) 5 Fund Balance Beginning 1,706,178 1,725,004 1,729,722 1,705,320 1,687,949 s Fund Balance Ending 1,725,004 1,729,722 1,705,320 1,687,949 1,659,260 �,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, ,,,,,,,,,,,,,,,,,,,,, � ,,,,,,,,,,,,,,,,.. ..,,,,,,,,,,,,,,,,,,,,,,,,,,,,....,,,,,,,,,,,,,,,,,,,,,,,,,..,,,,,,,,,,,,,,,,,,,,,,,,,.... ..,,,,,,,,,,,,,,,,,,,,,,,,....,,,,,,,,,,,,,,,,,,,,,,,,,,,,,..,,,,,,,,,,,,,,,,,,,,,,,,,,,,,..,,,,,,,,,,,,,,,,,,,,,,,,,,..,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,....,,,,,,,,,,,,,,,,,, � Less:Assigned Fund Balance (82,000) (78,650) (75,468) (72,444) (69,572) $ Unassigned Fund Balance $1,643,004 $1,651,072 $1,629,853 $1,615,505 $1,589,688 9 OperatingDays 63 63 61 60 59 �o Dollars perOperatingDay $ 26,058 $ 26,321 $ 26,627 $ 26,837 $ 27,099 � 11 Total Students Enrolled 875 885 885 885 890 �,,,,,,,,,,,,,,,,,,,,,,,,,,,,,�,,,,,,,,,,,,,,,,,,,,,,,,,,,,,..�,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,...,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,.,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,....,,,,,,,,,,,,,,,,,,,,,,,,,...,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,...,,,,,,,,,,,,,,,,,,,,,,,,,,...�,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,_.,,,,,,,,,,,,,,,,,,,,,,,,,,..�,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,.,,,,,,,,,,,,,,,,,,,,,,,,,,,,...,,,,,,,,,,,,,,,,,,,,,,,,,,,....,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,...,,,,,,,,,,,,,,,,,,,, �2 TEAFundingperStudent(incICTE/SPED) 8,873 8,859 8,946 9,034 9,071 13 OperatingCostperStudent $ 10,870 $ 10,855 $ 10,982 $ 11,068 $ 11,114 � 15 Teachers 70.18 70.18 70.18 70.18 70.18 �s Student/Teacher Ratio 12.47 12.61 12.61 12.61 12.68. Change in Operating Days _, - � � � � � Actual Actual Actual Actual Actual Actual Amended Proposed Projected Projected Projected Projected FY 14/15 FY 15/16 FY16/17 FY17/18 FY18/19 FY19/20 FY20/21 FY21/22 FY22/23 FY23/24 FY24/25 FY25/26 Shared Service Model Combined: General Fund Academic& Municipal Services GENERAL FUND EXPENDITURES Amended Proposed $Increase %Increase Academic&Municipal Expenditure Costs FY 2020/21 FY 2021/22 (Decrease) (Decrease) � Operating Expenditures $ 9,453,877 $ 9,511,024 $ 57,147 0.60% 2 Municipal-TransfertoWAWAFStaff 71,235 72,660 1,425 2.00% 3 Total Academic Costs 9,525,112 9,583,684 58,572 0.61% _.......................... ............ 4 Annual DebtService(Municipal budget) 1,829,193 1,825,366 (3,827) -0.21% Major Maintenance and Replacement 5 (Fnd 600-Dept 17) 281,000 410,000 129,000 45.91% g In-direct OperatingCosts(Payroll&Related) 1,042,238 1,359,776 317,538 30.47% 7 Total Municipal Costs 3,152,431 3,595,142 442,711 14.04% $ Academic(General) &Municipal Expenditure Costs $12,677,543 $13,178,826 $ 501,283 3.95% 9 NumberofStudents 856 875 19 2.22% 10 Total Expenditure Cost perStudent $ 14,810 $ 15,062 $ 251 1.70% 51 General Fund Budget Summary GENERAL FUND Amended Proposed $ Increase %Increase Academic Only FY 2020/21 FY 2021/22 (Decrease) (Decrease) � Revenues $ 9,408,878 $ 9,529,850 $ 120,972 1.29% 2 Expenditures 9,453,877 9,511,024 57,147 0.60% �................................................................................................................................................................................................................................... ......................... .......................... ............................................................... �,,,,,,,,,,,,,,,,,,,,,,,,,,,,,.,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,. 3 Other Resources 90,000 45,000 (45,000) -50.00% a Other Uses (90,000) (45,000) 45,000 0.00% 5 Excess Revenues Over(Under)Expenditures (44,999) 18,826 63,825 -141.84% 6 FUND BALANCE BEGINNING 1,751,177 1,706,178 (44,999) -2.57% �............... — � FUND BALANCE ENDING 1,706,178 1,725,004 18,825 1.10% � ...,,,,,, �., ��,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, ,,,,,,,,,,,,,,,,,,,,,,,, � ..,,,,,,,,,,,,,, $ Assigned (88,000) (82,000) 6,000 -6.82% 9 FUND BALANCE ENDING(Unassigned) $ 1,618,178 $ 1,643,004 $ 24,825 1.53% �o #Days Operating(Based on 365) 62 63 1 0.92% 11 DailyOperatingExpenditure $ 25,901 $ 26,058 $ 157 0.60% 12 Students Enrolled 856 875 19 2.22% 13 TEA Funding per Student 8,949 8,873 $ (75) -0.84% '� OperatingCostperStudent $ 11,044 $ 10,870 (175) -1.58% 15 Teachers 71.01 70.18 (0.83) -1.17% 16 Student/Teacher Ratio 12.05 12.47 0.41 3.43% �� Total Faculty&Staff 101.84 104.34 2.50 2.45% Revenue & Expenditure Comparison Revenues Expenditures (in millions) FY 17/18 AUDITED FY 18/19 AUDITED FY 19/20 AUDITED FY 20/21 AMENDED FY 21/22 PROPOSED 52 Personnel Staffing Levels Employee FY 14/15 FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22 Change Type Amended Proposed Principals 4.50 4.50 4.50 4.50 4.75 4.75 5.50 5.50 - Coordinators 3.50 5.00 4.50 3.50 4.25 4.58 5.33 6.83 1.50 Primary 23.59 27.00 27.00 27.00 26.50 27.50 27.50 26.50 (1.00) _........... _........................................................................................................................................... Secondary 30.92 32.06 32.55 34.26 34.92 37.55 37.51 37.51 - S u p p o rt 17.10 15.50 15.00 14.00 14.00 14.00 13.50 15.3 3 1.83 Specialist 5.00 6.25 6.00 5.00 4.75 5.25 6.00 6.17 0.17 Foundation 1.50 1.50 1.50 1.50 1.50 1.50 1.50 1.50 - _............................................................................................................................................................................................................................................................................._.................................................................................................._............................ ... Facilities 2.00 2.00 2.00 2.00 2.00 4.00 3.00 3.00 - IT Dept 1.10 2.00 2.00 2.00 2.00 2.00 2.00 2.00 - TotalStaff 89.21 95.81 95.05 93.76 94.67 101.13 301.84 104.34 2.50 Total Teachers 59.51 65.31 65.55 66.26 66.17 70.30 71.01 70.18 (0.83) Defined Employee Groups by FTE Instructional Administration Support � • „ : �� : �� � � � � � � FY 14/15 FY 15/16 FY 16/17 FY 17/18 FY 18/19 FY 19/20 FY 20/21 FY 21/22 AMENDED PROPOSED 53