Loading...
HomeMy WebLinkAboutR-17-29 Proposed Budget FY 17/18RESOLUTION NO. R-17-29 A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF SEBASTIAN, INDIAN RIVER COUNTY, FLORIDA ADOPTING THE TENTATIVE BUDGET FOR THE FISCAL YEAR BEGINNING 01 OCTOBER 2017 AND ENDING 30 SEPTEMBER 2018; MAKING APPROPRIATIONS FOR THE PAYMENT OF OPERATING EXPENSES, CAPITAL EXPENSES, AND FOR THE PRINCIPAL AND INTEREST PAYMENTS ON INDEBTEDNESS OF THE CITY IN THE CITY'S GENERAL FUND, SPECIAL REVENUE FUNDS, DEBT SERVICE FUND, CAPITAL IMPROVEMENT FUNDS, GOLF COURSE FUND, AIRPORT FUND, AND BUILDING DEPARTMENT FUND AS PROVIDED FOR IN SCHEDULE "A", ATTACHED HERETO, ESTABLISHING AUTHORITY OF THE CITY MANAGER TO IMPLEMENT THE BUDGET; PROVIDING FOR SEVERABILITY; PROVIDING FOR CONFLICTS; AND PROVIDING FOR AN EFFECTIVE DATE. WHEREAS, the City Manager has submitted a Proposed Budget for the City of Sebastian for the fiscal year beginning 01 October 2017, and ending 30 September 2018; and WHEREAS, on 18 September 2017, the City Council has conducted a Public Hearing on the Tentative Budget. NOW, THEREFORE, BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF SEBASTIAN, INDIAN RIVER COUNTY, FLORIDA, that: Section 1. The Tentative Budget is hereby adopted for the Fiscal Year beginning 01 October 2017 and ending 30 September 2018, subject to final hearing on 27 September 2017. Section 2. The amounts shown on the attached Schedule "A" is appropriated out of the Treasury of the City, including any revenues accruing to the City available for purposes of the City's budgetary accounts. Section 3. The City Manager shall be authorized and directed to proceed with the implementation of the service programs and projects provided for in the budget. Such implementation is to be consistent with the provisions of the City Code of Ordinances and policies established by the City Council. Section 4. The City Manager shall be authorized to make budget adjustments within budgetary accounts, as he deems appropriate. He shall be further authorized to make budget adjustments between budgetary accounts when necessary to implement programs, projects, and expenditures authorized by the City Council. All other budgetary adjustments will require prior approval by the City Council. Section 5. If any clause, section, or other parts of this Resolution shall be held by any Court of competent jurisdiction to be unconstitutional or invalid, such unconstitutional or invalid part shall be considered as eliminated and shall in no way affect the validity of the other provisions of this Resolution. Section 6. All Resolutions or parts of Resolutions in conflict herewith are hereby repealed to the extent of such conflict. Section 7. This Resolution shall become effective upon passage. The foregoing Resolution was moved for adoption by Councilmember p; 11 The motion was seconded by Councilmember McPartlan _and, upon being put into a vote, the vote was as follows: Mayor Bob McPartlan ave Vice -Mayor Andrea B. Coy ave Councilmember Jim Hill aye Councilmember Linda Kinchen aye Councilmember Ed Dodd aye The Mayor thereupon declared this Resolution duly passed and adopted this 18th day of September, 2017. CITi��BA," ' /G,fiLOR�PA Bob McPartlan, Mayor ATTEST: ��GcJ��a.ma #ap6tte.Wiir ani, City Clerk Approved as to form and legality for the reliance by the City of Sebastian only: - 4 — Cynthia V. Hall, Interim CityAttomey ATTACHMENT TO RESOLUTION R-17-29 SCHEDULE"A" BUDGET SUMMARY FISCAL YEAR 2017/2018 1 GENERALFUND REVENUES: 001501 Taxes and franchise fees $ 7,884,576 001501 Licenses and permits 138,500 001501 Intergovernmental 2,608,036 001501 Charges for services 404,140 001501 Fines and forfeits 55,000 001501 Miscellaneous 233,269 001501 Transfers in 725,000 Total Revenues $ 12,048,521 EXPENDITURES: 010001 City Council $ 54,893 010005 City Manager 276,569 010009 City Clerk 225,160 010022 Audio Visual 134,138 010010 City Attorney 101,554 010020 Administrative Services 652,296 010021 Management Information System 220,197 010041 Police Administration 893,551 010043 Police Operations 2,778,265 010047 Police Detective Division 803,619 010049 Police Dispatch Unit 597,355 010045 Code Enforcement Division 173,549 010051 Engineering 418,276 010052 Roads and Maintenance 615,953 010053 Stormwater Utility 926,206 010054 Fleet Management 228,632 010056 Facilities Maintenance 314,412 010057 Parks and Recreation 926,176 010059 Cemetery 178,423 010080 Community Development 421,109 010099 Non -departmental 1,016,936 Unappropriated 91,252 Total Expenditures $ 12,048,521 1 ATTACHMENT TO RESOLUTION R-17-29 SCHEDULE"A" BUDGET SUMMARY FISCAL YEAR 2017/2018 SPECIAL REVENUE FUNDS 4 LOCAL OPTION GAS TAX FUND 120010 REVENUES Taxes $ 683,001 Miscellaneous 14,090 Appropriation from prior year 96,457 Total Revenues $ 793,548 120051 EXPENDITURES Operating $ 100,103 Debt service 242,445 Transfers out 451,000 Total Expenditures $ 793,548 DISCRETIONARY SALES TAX FUND 130010 REVENUES Taxes $ 3,187,750 Miscellaneous 27,708 Total Revenues $ 3,215,458 130051 EXPENDITURES Transfers out $ 2,478,137 Unappropriated 737,321 Total Expenditures $ 3,215,458 RECREATION IMPACT FEE FUND 160010 REVENUES Impact fee $ 163,800 Miscellaneous 4,880 Restricted cash balance carryforward 286,320 Total Revenues $ 455,000 160051 EXPENDITURES Transfers out $ 455,000 Total Expenditures $ 455,000 STORMWATER UTILITY FUND 163010 REVENUES Stormwater utility fee $ 998,000 Miscellaneous 3,535 Restricted cash balance carryforward 116,453 Total Revenues $ 1,117,988 163051 EXPENDITURES Operating $ 417,988 Transfers out 700,000 Total Expenditures $ 1,117,988 4 ATTACHMENT TO RESOLUTION R-17-29 SCHEDULE"A" BUDGET SUMMARY FISCAL YEAR 2017/2018 SPECIAL REVENUE FUNDS - CONTINUED M PARKING IN -LIEU -OF FEE FUND 190010 REVENUES Miscellaneous $ 14,204 Total Revenues $ 14,204 190051 EXPENDITURES Unappropriated 14,204 Total Expenditures $ 14,204 LAW ENFORCEMENT FORFEITURE FUND 190010 REVENUES Fines and forfeits $ 1,000 Miscellaneous 145 Total Revenues $ 1,145 190051 EXPENDITURES Unappropriated $ 1,145 Total Expenditures $ 1,145 COMMUNITY REDEVELOPMENT AGENCY FUND 163010 REVENUES Tax Increment - Sebastian $ 178,556 Tax Increment - Indian River County 171,433 Miscellaneous 37,878 Total Revenues $ 387,867 163051 EXPENDITURES Operating $ 217,192 Grants and Aids 40,000 Capital Outlay 60,000 Unappropriated 70,675 Total Expenditures $ 387,867 DEBT SERVICE FUNDS DISCRETIONARY SALES SURTAX REVENUE BONDS 230010 REVENUES Miscellaneous $ Transfers in Restricted cash balance carryforward Total Revenues $ 230051 EXPENDITURES Debt service $ Total Expenditures $ STORMWATER UTILITY REVENUE BONDS 263010 REVENUES Miscellaneous $ 900 Transfers in 403,792 Total Revenues $ 404,692 263051 EXPENDITURES Debt service $ 404,078 Unappropriated 614 Total Expenditures $ 404,692 M ATTACHMENT TO RESOLUTION R-17-29 SCHEDULE"A" BUDGET SUMMARY FISCAL YEAR 2017/2018 CAPITAL PROJECTS FUNDS REVENUES $ 3,689,658 Transfer from Discretionary Sales Tax fund 2,074,345 Transfer from Local Option Gas Tax fund 451,000 Transfer from Recreation Impact Fee Fund 455,000 Grants 2,951,963 Total Revenues $ 5,932,308 EXPENDITURES Transportation $ 3,689,658 Recreation facilities projects 668,000 Stormwater Improvements/Physical Environment 750,000 Public Safety 444,000 General Government 380,650 Total Expenditures $ 5,932,308 ENTERPRISE FUNDS GOLF COURSE FUND 410010 REVENUES: Charges for services $ 1,294,434 Miscellaneous revenues 53,464 Total Revenues $ 1,347,898 EXPENSES: GOLF COURSE ADMINISTRATION 410110 Personal services $ 283,542 Operating expenses 289,386 Repayment of Building Fund Loan 31,744 Total Administration $ 604,672 GOLF COURSE GREEN DIVISION 410120 Operating expenses $ 585,129 Total Golf Course Green Division $ 585,129 GOLF COURSE CARTS DIVISION 410130 Personal services $ 92,291 Operating expenses 8,400 Debt Service on Cart Lease/Purcbase 57,406 Total Golf Course Carts Division $ 158,097 Total Golf Course Expenses $ 1,347,898 4 ATTACHMENT TO RESOLUTION R-17-29 SCHEDULE"A" BUDGET SUMMARY FISCAL YEAR 2017/2018 TOTAL BUDGET SUMMARY GENERAL FUND AIRPORT FUND SPECIAL REVENUE FUNDS 5,985,210 450010 REVENUES CAPITAL PROJECT FUNDS 5,932,308 ENTERPRISE FUNDS Charges for services $ 483,156 Miscellaneous revenues 14,300 Total Revenues $ 497,456 450110 EXPENSES: Personal services $ 228,229 Operating expenses 209,727 Debt service 24,500 Capital Outlay 10,000 Transfer out 25,000 Total Expenses $ 497,456 BUILDING DEPARTMENT 480010 REVENUES Charges for services $ 652,400 Miscellaneous revenues 38,444 Total Revenues $ 690,844 480110 EXPENSES: Personal services $ 503,260 Operating expenses 104,463 Unappropriated 83,121 Total Expenses $ 690,844 TOTAL BUDGET SUMMARY GENERAL FUND S 12,048,521 SPECIAL REVENUE FUNDS 5,985,210 DEBT SERVICE FUNDS 404,692 CAPITAL PROJECT FUNDS 5,932,308 ENTERPRISE FUNDS 2,536,198 TOTAL BUDGET FOR ALL FUNDS S 26,906,929 5 Property Taxes(No Growth) Franchise Fees (2% Gmwlh) Utility Service Tax (2% Growth) lrtargovemmental(4.5% Groa,h) Investment Income ONer Revenue Transfers In (Slonnwaler, Cemetary,CRA) Ireuranca from Hurricane Matthew FEMA and Slate Reimbursements GENERAL FUND REVENUE Personnel Cost (iM Insurance @ 10%, Other LR 3%) Operating Expenditures (No Growth) Total Operation and Maintenance Transfers to Other Funds Capital Replacements or Additions Police Personnel Equipment Engineering Equipment Public Works Roads Vehicles Public Wahl Slormxater Equipment Public Works Parks Mowers Public Works Parks Pickup Trucks Public Works Parks Replace Playground Components Public Works Cemetery Commercial Mower Public Works Fleet Equipment Hurricane Matthew E tpendaures TOTAL FY 16 TOTAL FY 17 TOTAL FY 18 TOTAL FY 19 TOTAL FY 20 TOTAL FY 21 TOTAL FY 22 TOTAL FY 23 BEGINNING FUND BALANCE TOTAL REVENUES TOTAL EXPENDITURES UNRESTRICTED RESERVE BALANCE GENERALFUND PROJECTED BALANCES FISCAL YEARS 2018-2023 FY 16-16 FY 16-17 FY 17.18 FY 18.19 FY 19-20 FY 20-21 FY 21.22 FY 22.23 $ 3,603,024 $ 3,795,525 $ 3,799,624 $ 3,799,624 $ 3,799,624 3 3,799,624 $ 3,799,624 $ 3,799,624 1,257,430 1,293,398 1,333,454 1,360,123 1,387,326 1,415,072 1,443,373 1,472,241 2,686,322 2,711,900 2,751,498 2,806,528 2,862,659 2,919,912 2,978,310 3,037,676 2,654,806 2,632,215 2,608,036 2,725,398 2,848,041 2,976,202 3,110,131 3,250,087 28,859 38,600 34,431 36,526 39,174 38,684 38,010 37,238 834.660 718,083 791,MD 791,840 791,840 791,840 791,840 791,840 675,753 663.569 729,638 779,638 829,638 679,638 929,638 979,638 - 29,069 - - - - - - - - 1,443,750 - - - - - $ 11,740,854 5 11,782,379 $13,492,271 $12,299,677 $12,558,300 $ 12,820,972 513,090,927 $ 13,368,544 $ 8,527,708 $ 7,732,922 S 8,711,830 $ 9,043,185 $ 9,364,480 S 9,736,015 S 1D,098,095 S 10,471,038 2,518,709 3,113,368 3,200,439 3,200,439 3,200,439 3,200.439 3,200.439 3,200,439 $ 11,046,417 $ 10,646,290 S 11,912,269 $ 12,243,624 $ 12,584,919 $ 12,936,454 $ 13,298,534 $ 13,671,477 343,700 503,812 - - - - - - 191,903 20,652 20,000 6,000 6,000 6,000 6,000 6,000 14,500 10,000 28,000 - 26,000 38,000 - 30,000 30,000 25,000 25,000 25,000 25,DDD 25,000 25,000 - 13,000 - 20,000 40,000 7,000 7,000 1,750,000 $ 11,582,020 $ 13,304,754 $ 11,957,269 $ 12,378,124 $ 12,761,919 $ 12,974,454 $ 13,336,534 $ 13,702.477 S 5,652,594 $ 5,811,428 S 4,289,053 $ 5,824,055 S 5,745,608 $ 5,641,989 $ 5,388,508 S 5,142,901 11,740,854 11,782,379 13,492,271 12,299,677 12,558,300 12,820,972 13,090,927 13,358,544 11,582,020 13,304,754 11,957,269 12,378,124 12,761,919 12,974,454 13,336,534 13,702,477 $ 5,811.428 $ 4,289.053 S 5,824,055 3 5.745.608 $ 5.541.989 $ 5.M.WB S 5.142.901 S 4.608.967 Local Option Gas Tates FOOT Lighting Agreement Transfer from General Fund (AAF+Streets) Investment Income Total Revenues Street Lights RIR Crossing Maintenance All Aboard Florida Road Striping Indian River Drive Light Poles Road Signs and Markings Sidewalk Construction and Repair Total Operational and Maintenance Debt Payment- Final FY22-23 School Crossing Beacons Street Repaving for FY15 + Main Street Repaving TOTAL Catch-up Street Repaving TOTAL Repaving (Indian River Drive) TOTAL Repaving (Pleasant View/Rollinghills/Schumann) TOTAL Repaving, as needed TOTAL Repaving, as needed TOTAL Repaving, as needed TOTAL Repaving, as needed TOTAL BEGINNING FUND BALANCE BUDGET RESERVE -15% OF EXPENSES UNRESTRICTED RESERVE BALANCE TOTALREVENUES TOTAL EXPENDITURES+TRANSFERS ENDING FUND BALANCE LOCAL OPTION GAS TAX FUND PROJECTED BALANCES FISCAL YEARS 2018-2023 FY 15.16 FY 16-17 FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21-22 FY 22-23 $ 646,132 3 656,732 $ 683,001 $ 710,321 It 738,734 $ 768,283 $ 799,015 S 830,975 10,352 12,532 12,908 12,908 12,908 12,908 12,908 12,908 200,000 200,000 - - - - - - 1,780 1,700 1,182 1,000 1,173 1,568 2,034 2,572 $ 858,264 $ 870,964 $ 697,091 $ 724,229 $ 752,815 $ 782,760 $ 813,956 $ 846,455 $ 183,067 $ - $ - $ - $ - $ - $ - $ - 5,103 5,103 5,103 5,103 5,103 5,103 5,103 5,103 106,000 20,000 20,000 20,000 20,000 20,000 20,000 20,000 2,846 23,553 20,512 35,000 35,000 35,000 35,000 35,000 35,000 44,077 40,000 40,000 40,000 40,000 40,000 40,000 40,000 $ 258,646 $ 191,615 $ 100,103 $ 100,103 $ 100,103 $ 100,103 $ 100,103 $ 100,103 242,748 242,635 242,445 243,177 243,802 243,340 242,801 122,174 9,488 246,678 153,500 $ 901,572 663,423 S 1,107,161 451,000 $ 793,548 320,000 $ 663,280 250,000 $ 593,905 250,000 $ 593,443 250,000 $ 592,904 250,000 $ 472,277 $ 418,661 It 375,353 $ 139,156 $ 42,699 103,648 262,559 451,875 672,928 98,824 129,679 82,665 63,015 52,515 52,515 52,515 52,515 $ 319,838 $ 245,674 3 56,491 $ (20,316) $ 51,133 $ 210,043 $ 399,360 $ 620,412 858,264 870,964 697,091 724,229 752,815 782,760 813,956 846,455 901,572 1,107,161 793,548 663,280 593,905 593,443 592,904 472,277 $ 276,530 $ 9,477 $ (39,966) $ 40,633 $ 210,043 $ 399,360 $ 620,412 $ 994,590 DISCRETIONARY SALES TAX FUND (DST) PROJECTED BALANCES FISCAL YEARS 2018-2023 FY 15.16 FY 16-17 FY 17-18 FY 18.19 FY 19-20 FY 20.21 FY 21-22 FY 22-23 DST Revenue $ 3,052,152 S 3,110,000 $ 3,187,750 $ 3,267,444 $ 3,349,130 $ 3,432,858 $ 3,518,680 $ 3,606,647 Principal from $285,000 Airport Advance 09/29/08 649 675 702 6,730 6,999 7,279 7,570 7,873 Interest from $285,000 Airport Advance 11,351 11,325 11,298 11,270 11,001 10,721 10,430 10,127 Principal lrom$267.511 Airport Advance 01/05/11 0 1,800 1,872 1,946 2,024 2,105 8,189 8,517 Interest from $267,511 Airport Advance 8,025 10,700 10,628 10,554 10,476 10,395 10,311 9,983 Inveslmenllncome 8,424 2,965 3,208 2,597 3,182 1,874 2,408 4,175 DST PROJECT REVENUE $ 3,080,601 $ 3,137,465 $ 3,215,458 $ 3,300,640 $ 3,382,811 $ 3,465,232 $ 3,557,588 $ 3,647,321 City Hall Debt (Retires 2018) 868,342 354,253 Stormweter Debt (Retires 5101/22) 401,143 402,176 403,792 402,914 401,355 400,961 234,292 - Computer Replacement and Annual Upgrades 27,541 112,440 30,000 210,000 30,000 30,000 30,000 30,000 MIS Servers 40,000 Firewall Software 75,650 UPS Bypass Switches 12,000 Audio Visual Equipment 50,000 30,000 Laserfiche Software Upgrade 50.000 Wireless Capability at City Halt and Police Station 5,000 Police Vehicles and Equipment 249,341 388,250 350,000 350,000 300,000 300,000 300,000 300,000 City Hall/Pciice Air Conditioners 40,000 40,000 40,000 40,000 40,000 Diesel Fuel Tank and Software - 25,000 Presidential Streets 28,656 Fish House Improvements 107,372 Construct Hangar"C" 24,143 283,151 Airport Drive East 109,062 101,396 Tulip Drive - 177,124 CavCor Boat Parking Paving Completion 41,915 65,000 Roof Repairs (City Hall and PD) 40,640 32,517 Painting City Hell - 36,600 Police -Public Parking 62 29,335 City Hell Parking Lot - - - 50,000 Patch Truck - 156,252 Diesel Trader 49,224 Gob Course Improvements 599,858 Police Evidence Garage/Fodures 22.915 345,281 20,000 50,000 Dispatch Consoles Upgrade - 63,390 Working Waterfront Phase 2A Enhancements 15,791 202,193 Working Waterfront Drainage Phase 3 Shoreline - - 206,006 Excavator (Grant matching) 25,280 Replace Schumann Sidewalk 23,828 Street Reconstruction 136,121 479,045 Runway Markings 7,307 Automated Weather Observation System - 21,200 Electrical Boring for Swoop Pond 4,000 Service Pathway 12,104 Chipper 60,999 TOTALFY16 $ 2,785,073 Street Reconstruction (Vocelle and Damask) 130,545 50,000 Backhoe 84,169 Purchase 190 Sebastian Brad. 71,162 Stonecrop Drainage 22,000 187,500 - Airport Master Plan DesignuEnvironmental Study 25,800 Taxhvay"C',"D'and 'E' Design 13,110 Dump Truck ( Split with Stormwaler/General Fund) 60,000 Goff Clubhouse Reconstruction 175,000 Cemetery Columbadums (Excess of Trust Fund Budget) 40,093 TOTAL FY 17 3,992,053 Dispatch Console and Radio System Replacement 57,000 50,000 100,000 50,000 Dispatch Power Source/Generator 17,000 200,000 Public Works Garage Compound 400,000 3,000,000 1,000,000 Pickle Ball Courts 213,000 172,000 Stormwater Heavy Equipment 145,000 290,000 70,000 145,000 Airport Shade Hangars 125,000 40,000 Taxiway "D" and "E" Construction 1D9,195 Airport Security Cameras 100,000 Construct Access Road West - - - - 100,000 Cemetery Irrigation System 150,000 TOTALFYI6 $ 2,478,137 Cat Loader 200,000 8 yd. Brush Track - 125,000 Skid Steer Track Mower 75,000 - - Taxlway'C' Construction (West and East) 128,819 Engineering and Construction of Hangar "D" 225,000 225,000 TOTAL FY 1a 5,085,733 TOTAL FY 2d 2,711,355 TOTAL FY 21 1,155,961 TOTAL FY 22 849,292 Cemetery South Paved Roadway 100,000 TOTAL FY 23 430,000 BEGINNING FUND BALANCE $ 2,413,577 S 2,709,105 $ 1,854,518 $ 2,591,840 $ 806,647 $ 1,478,103 $ 3,787,374 S 6,495,670 BUDGET RESERVE -10%OF EXPENSES 278,507 399,205 247,814 508,573 271,136 115,596 84,929 43,000 RESERVE FOR ADVANCES 528,149 525,674 523,100 514,424 505.401 496,017 480,258 463,868 UNRESTRICTED RESERVE BALANCE $ 1.606,921 $ 1,784,226 $ 1,083,604 $ 1,568,842 $ 30,111 $ 886,490 $ 3,222,187 $ 5,988,002 TOTALREVENUES 3,080,601 3,137,465 3,215,458 3,300,540 3,382,811 3,465,232 3,557,588 3,647,321 TOTAL EXPENDITURES -DEBT -TRANSFERS 2,785,073 3,992.053 2,478,137 5,085,733 2,711,355 1,155,961 849,292 430.000 ENDING FUND BALANCE $ 1,902,449 $ 929,639 $ 1,820,926 $ (216,350) $ 701,567 $ 3,175,761 $ 5,930,483 $ 9,206,123 Cash on Hand S 2,180,956 $ 1,328,844 $ 2,068,740 $ 292,223 $ 972,702 111 3,291,357 $ 6,015,412 $ 9,249,123 RECREATION IMPACT FEE FUNDS PROJECTED BALANCES FISCAL YEARS 2018-2023 FY 15.16 FY 16-17 FY 17-18 FY 18.19 FY 19-20 FY 20-21 FY 21.22 FY 22-23 Recreation Impact Fees $ 163,800 $ 163,800 $ 163,800 $ 163,800 $ 163,800 $ 163,800 $ 163,800 $ 163,800 Investment Income 4,353 5,181 4,880 3,377 4,255 5,137 6,024 6,915 PROJECTED REVENUE $ 168,153 $ 168,981 $ 168,680 $ 167,177 $ 168,055 $ 168,937 $ 169,824 $ 170,715 Equipment Building 16,584 Community Center (Paving/Drainage/Lighting) 940 50,220 Barber Street Netting 14,875 TOTAL FY 15 TOTAL FY 16 $ 32,399 Pickle Ball (See DST) Parks & Recreation Comprehensive Plan Parks Inspection Football Field Restrooms CavCorp, Boat Parking Landscaping Barber Street Ballfield Lighting TOTAL FY 17 ADA Playground TOTAL FY 18 TOTAL FY 19 TOTAL FY 20 TOTAL FY 21 BEGINNING FUND BALANCE TOTAL REVENUES TOTAL EXPENDITURES ENDING FUND BALANCE BEGINNING FUND BALANCE: Zone A Zone B Zone C Zone D All Zones Recreation Impact Fees Zone A Zone B Zone C Zone D All Zones Investment Income Zone A Zone B Zone C Zone D All Zones Transfers: Zone A Zone B Zone C Zone D All Zones Ending Balances: Zone A Zone B Zone C Zone D All Zones 19,600 12,800 128,100 15,491 375,000 $ 226,211 80,000 $ 455,000 $ 769,138 $ 904,892 $ 847,662 $ 561,342 $ 168,153 168,981 168,680 167,177 32,399 226,211 455,000 0 $ 904,892 $ 847,662 $ 561,342 $ 728,519 $ 728,519 $ 896,574 $ 1,065,511 $ 1,235,334 168,055 168,937 169,824 170,715 0 0 0 0 896,574 $ 1,065,511 $ 1,235,334 $ 1,406,050 FY 16-16 FY 16-17 FY 17-18 FY 18-19 FY 19-20 FY 20-21 FY 21.22 FY 22-23 $ 305,003 $ 375,034 $ 374,205 $ 281,310 $ 117,095 135,946 108,947 24,600 38,818 47,733 48,100 61,025 308,223 346,180 316,410 194,407 $ 769,138 $ 904,892 $ 847,652 $ 561,342 $ 358,578 $ 436,248 $ 514,323 $ 592,807 53,524 82,612 111,861 141,269 74,041 87,122 100,270 113,485 242,376 290,592 339,057 387,773 728,519 $ 896,574 $ 1,065,511 $ 1,235,334 $ 75,576 $ 75,576 $ 75,576 $ 75,576 $ 75,576 $ 75,576 $ 75,576 $ 75,576 28,776 26,776 28,776 28,776 28,776 28,776 28,776 28,776 12,649 12,649 12,649 12,649 12,649 12,649 12,649 12,649 46,800 46,800 46,800 46,800 46,800 46,800 46,800 46,800 $ 163,800 $ 163,800 $ 163,800 $ 163,800 $ 163,800 $ 163,800 $ 163,800 $ 163,800 $ 1,726 $ 2,147 $ 2,154 $ 1,692 $ 2,094 $ 2,500 $ 2,908 $ 3,319 663 778 627 148 313 473 632 791 220 273 277 367 432 499 567 635 1,744 1,982 1,822 1,170 1,416 1,665 1,917 2,171 $ 4,353 $ 5,181 $ 4,880 $ 3,377 $ 4,255 $ 5,137 $ 6,024 $ 6,915 $ 7,271 $ 78,552 $ 170,625 $ - $ - $ - $ - $ - 10,587 56,553 113,750 - - - - - 3,964 12,555 - - - - - - 10,587 78,552 170,625 - - - - $ 32,399 $ 226,211 $ 455,000 $ - $ - $ - $ - $ $ 375,034 $ 374,205 $ 281,310 $ 358,578 $ 135,946 108,947 24,600 53,524 47,733 48,100 61,025 74,041 346,180 316,410 194,407 242,376 $ 904,892 $ 847,662 $ 561,342 $ 728,519 $ 436,248 $ 514,323 $ 592,807 $ 671,701 82,612 111,861 141,269 170,836 87,122 100,270 113,485 126,769 290,592 339,057 387,773 436,744 896,574 $ 1,065,511 $ 1,235,334 $ 1,406,050 STORMWATER UTILITY FUND PROJECTED BALANCES FISCAL YEARS 2018-2023 FY 15-16 FY 16-17 FY 17.18 FY 18-19 FY 19-20 FY 20.21 FY 21-22 FY 22.23 Stonnwater Fees $ 991,055 $ 998,000 $ 998,000 $ 998,000 $ 998,000 $ 998,000 $ 998,000 $ 998,000 Transfer from General Fund 100,000 100,000 - - - - - - Investment Income 3,400 4,109 3,535 2,702 3,644 4,215 5,077 5,645 SW PROJECTED REVENUE $ 1,094,455 $ 1,102,109 $ 1,001,535 $ 1,000,702 $ 1,001,644 $ 1,002,215 It 1,003.077 S 1,003,645 Professional Services $ 148 $ 150 It - $ - $ - $ - $ - It - Permit ISM Stomawater Park Maintenance 8,682 10,000 10,000 10,000 10,000 10,000 10,000 10,000 Ditch Maintenance 37,100 Road Crossings/Sideyard Pipes 50,827 100,000 90,000 90,000 90,000 90,000 90,000 90,000 Pipe Sliplining - 110.000 50,000 Pumps/Baffle Box Maintenance or Replacement 4,770 10,000 10,000 10,000 10.000 10.000 10,000 10,000 Total Operational and Maintenance $ 101,527 $ 230,650 $ 160,000 $ 110,000 $ 110,000 $ 110,000 $ 110,000 $ 110,000 Lagoon Improvements (25K Oyster Mals, 1/3rd Interlocal) 100,000 100,000 SW618 and SW -619 Pickups 47,851 SW -616 4X4 Pickup 30,349 4X4 Herb/UBliry, Vehicle and Equipment 17,612 Armadillo 72,860 90,027 SW -628 Tandum Dump Truck - 150,000 Swale Improvement Grants 250,000 Transfer to General Fund for Swale Maintenance 550,000 TOTAL STORMWATER FY16 $ 920,199 SW -606 1 Ton Crew Cab Pickup - - - 48,000 SW -614 4X4 2006 Pickup - - - 30,000 Transfer to General Fund for Swale Maintenance 650,000 TOTAL STORMWATER FY17 $ 1,220 677 NPDES 5 Year Permit 7,988 Transfer to General Fund for Swale Maintenance 700,000 TOTAL STORMWATER FY18 $ 1,117,988 Pumps 1,800 Transfer to General Fund for Swale Maintenance 700,000 Excavator Buckets/Mowmg Heads - - - 45,000 TOTAL STORMWATER FY19 S 811,800 Water Tank and Trailer - 20,000 Transfer to General Fund for Swale Maintenance 700,000 TOTAL STORMWATER FY20 $ 888,000 Transfer to General Fund for Swale Maintenance 700,000 TOTAL STORMWATER FY21 $ 830,000 Pickup Truck Replacement 35,000 Transfer to General Fund for Swale Maintenance 700,000 TOTAL STORMWATER FY22 $ 890,000 Pickup Truck Replacement 35,000 Transfer to General Fund for Swale Maintenance 700,000 TOTAL STORMWATER FY23 S 845,000 BEGINNING FUND BALANCE $ 100,300 It 274,556 $ 155,988 $ 39,535 $ 228,437 $ 342,081 $ 514,295 $ 627,372 BUDGET RESERVE -15%OF EXPENSES 138,030 183,102 167,698 121,770 133,200 124.500 133,500 126,750 UNRESTRICTED RESERVE BALANCE $ (37,730) $ 91,455 $ (11,710) $ (82,235) $ 95,237 $ 217,581 S 380,795 $ 500,622 ANNUAL REVENUES 1,094 455 1,102,109 1,001,535 1,000,702 1,001,644 1,002,215 1,003,077 1,003,645 ANNUAL EXPENDITURES 920,199 1,220,677 1,117,988 811,800 888,000 830,000 890,000 845,000 ENDING FUND BALANCE $ 136,526 $ (27,113) $ (128,163) $ 106,667 $ 208,881 $ 389,795 $ 493,872 $ 659,267 Payments in Lieu of Parking Investment Income PROJECTED REVENUE Expenditures: Parking on Indian River Drive CavCor Boat Parking Lot PROJECTED DISBURSEMENTS NONEXPENDABLE TRUST FUND: BEGINNING FUND BALANCE REVENUES EXPENDITURES ENDING FUND BALANCE PARKING IN LIEU OF FUND PROJECTED BALANCES FISCAL YEARS 2018-2023 FY 15-16 FY 16-17 FY 17-18 FY 18.19 FY 19.20 FY 20-21 FY 21-22 FY 22-23 $ 26,130 $ 28,418 $ 13,775 $ - $ - $ - $ - $ 358 547 429 432 436 439 442 53: 26,488 28,965 14,204 432 436 439 442 531, 62 44,703 13,792 62 58,495 $ 46,549 $ 72,975 $ 43,445 $ 57,649 $ 58,082 $ 58,517 $ 58,956 $ 59,398 26,488 28,965 14,204 432 436 439 442 535 62 58,495 - - - - - - $ 72,975 $ 43,445 $ 57,649 $ 58,082 $ 58,517 $ 58,956 $ 59,398 $ 59,933 RIVERFRONT CRA FUND PROJECTED BALANCES FISCAL YEARS 2018-2023 FY 15-16 FY 16-17 FY 17.18 FY 18-19 FY 19-20 FY 20.21 FY 21.22 FY 22-23 Tax Increment fmm City $ 181,150 $ 161,631 $ 178,556 $ 183,913 $ 189,430 S 195,113 $ 200,966 $ 206,995 Tax Increment from County 157,874 160,610 171,433 176,576 181,873 187,329 192,949 198,738 Rents 36,000 36,000 38,000 38,000 38,000 36,000 36,000 36,000 Investment Income 3,019 3,227 1,876 2,433 3,037 3,324 4,064 4,873 PROJECTED REVENUE S 378,043 $ 381,468 $ 387,867 $ 398,921 $ 410,341 $ 421,766 S 433,980 $ 446,606 Waterfront RenovationslExpenses (Crabby Bills) 23,572 24,000 24,000 24,000 24,000 24,000 24,000 24,000 Fagade/Sign Improvement Program 10,196 30,000 40,000 40,000 40,000 40,000 40,000 40,000 Sewer Connection Program 69,500 230,000 - 100,000 100,000 100,000 100,000 100,000 Special Events 37,120 42,000 42,000 42,000 42,000 42,000 42,000 42,000 Operating Expenditures 63,014 26,654 101,192 103,824 106,535 109,328 112,204 115,167 Update CRA Master Plan - 50.000 Signage for Chamber of Commerce 15,000 Veteran's Memorial 11,209 Speed Cushions an Indian River Drive 3,875 CavCorp Enhancements 8,195 108,730 Transfer to General Fund for Quality Maintenance 21,667 Landscaping Maintenance Contract 118,370 TOTAL RIVERFRONT CRA FY16 $ 366,718 TOTAL RIVERFRONT CRA FY17 $ 556,384 Riverview Park Tree Canopy 10,000 10,000 10,000 10,000 10,000 10,000 Wayfinding Signage 50,000 TOTAL RIVERFRONT CRA FY18 $ 317,192 Street Signage 50,000 50,000 TOTAL RIVERFRONT CRA FY19 $ 31$824 TOTAL RIVERFRONT CRA FY20 $ 372,535 TOTAL RIVERFRONT CRA FY21 S 325,328 TOTAL RIVERFRONT CRA FY22 $ 328,204 TOTAL RIVERFRONT CRA FY23 S 331,167 BEGINNING FUND BALANCE S 446,728 $ 458,053 $ 283,137 $ 353,812 $ 432,909 S 470,714 $ 587,153 S 672,929 ANNUAL REVENUES 378,043 381,468 387,867 398,921 410,341 421,766 433,980 446,606 ANNUAL EXPENDITURES 366,718 556,384 317,192 319,824 372,535 325,328 328,204 331,167 ENDING FUND BALANCE $ 458.053 $ 283,137 $ 353,812 $ 432,909 $ 470,714 $ 567,153 $ 672,929 $ 788,368 ' Note: $270,000 is also currently available from the $100,000 per year allocation from ad Valorem taxes for Indian River Lagoon cleanup. Detail on Ooeratina Expenditures: Indian River County Tax Assessor $ 5,000 $ 5,000 $ 51000 $ 51000 $ 5,000 $ 5,000 $ 5,000 $ 5,000 City of Sebastian Administration 13,202 13,202 87,740 90,372 93,083 95,876 98,752 101,715 Street Lighting 15,579 - - - - - - Water/Sewer 946 - - - - - - - Janitorial Services 20,398 Submerged Land Lease 3,968 4,710 4,710 4,710 4,710 4,710 4,710 4,710 Legal Advertisements 1,463 1,500 1,500 1,500 1,500 1,500 1,500 1,500 CRA Association 175 175 175 175 175 175 175 175 Ad Valorem Taxes 2,033 2,067 2,067 2,067 2,067 2,067 2,067 2,067 Tree Inventory 250 - - - - - - - Total Operating Expenditures $ 63,014 $ 26,654 $ 101,192 $ 103,824 $ 106,535 S 109,328 $ 112,204 $ 115,167 GOLF COURSE FUND PROJECTED BALANCES FISCAL YEARS 2018-2023 FY 15.16 IY 16.17 FY 17-18 FY 18.19 FY 19-20 FY 20-21 FY 21-22 FY 22.23 Charges for Services (5% Rale Increase) $ 1,030,793 Proshop Sales 58,461 Rents 28,473 Other Revenue 4,587 Contributions 9,143 Sale of Carts or Equipment 3,900 Temporary Loan from General Fund 402,000 Transfer from General Fund R&R 42,000 Advance from Building Fund (Greens) 4,460 Investment Income 4,460 PROJECTED REVENUE $ 1,537,357 Operating Costs Proshop Cost of Sales Transfer to Capital Fund Bank Note/Capital Lease - Golf Carts Rebuild Greens Other CapitallPicker, Washer, Dispenser Fuel Tank TOTAL FY 16 Close out Capital Fund Repayment of Temporary Loans Interest Payment to Building Fund Principal Payment to Building Fund TOTAL FY 17 TOTAL FY 18 TOTAL FY 19 TOTAL FY 20 TOTAL FY 21 TOTAL FY 22 TOTAL FY 23 BEGINNING FUND BALANCE TOTALREVENUES EXPENDITURES OPERATING FUND BALANCE BEGINNING FUND BALANCE Transfer from DST Fund Transfer from Operating Fund Advance from Building Fund Transfer from General Fund R&R Investment Income Course Bathrooms Irrigation System - DST & Building Loan Cart Path Repairs Trash ReceptiGes Golf Bag Rest Golf Bag Stands Pump #1 Motor Replacement Ice Machine Ice Machine for Eagles Nest Pressure Wash/Paint Clubhouse Pump Replacement Electrical Work Starter Shack Repairs Cart Barn Repairs Parking Lot Lights - Building Loan RoofinglShutters - Building Loan Painting and Carpet CAPITAL FUND BALANCE Total Fund 410 and 415 Balances Due to Other Funds Balances Building Fund Advance Balance CAFR Unrestricted Balance $ 1,295,329 44,954 51,664 57,278 2,000 6,568 $ 1,457,793 $ 911,464 $ 1,274,434 $ 1,338,156 $ 1,338,156 $ 1,338,156 $ 1,338,156 $ 1,338,156 37,750 55,000 55,000 55,000 55,000 55,000 55,000 26,119 42,000 42,000 42,000 42,000 42,000 42,000 4,460 4,460 4,460 4,460 4,460 4,460 4,460 9,133 7,004 7,004 7,004 7,004 7,004 7,004 88,313 $ 1,446,838 9,650 88,313 23,886 1,907 $ 1,446,850 20,916 61,940 175,174 $ 1,535,087 $ 1,254,320 $ 1,382,898 $ 1,446,620 $ 1,446,620 $ 1,446,620 $ 1,534,933 $ 1,446,620 $ 1,268,056 $ 1,258,748 $ 1,268,189 $ 1,277,700 $ 1,287,283 $ 1,296,937 $ 1,306,664 29,000 35,000 35,000 35,000 35,000 35,000 35,000 167,534 57,406 57,406 57,406 57,406 57,406 57,406 175,174 1,907 2,500 34,818 34,818 356,700 26,913 24,600 52,000 45,000 35,000 114,000 15,621 4,544 7,118 6,796 6,470 6,139 5,804 5,465 24,626 24,948 25,274 25,605 25,940 26,279 $ 1,681,033 5,161 2,391 $ 1,382,898 3,300 3,185 $ 1,446,838 9,650 23,886 $ 1,446,850 20,916 61,940 $ 1,446,432 $ 1,535,087 $ 1,446,435 $ (248,172) $ (168,608) $ (595,321) $ (595,321) $ (595,539) $ (595,769) $ (595,582) $ (595,737) 1,537,357 1,254,320 1,382,898 1,446,620 1,446,620 1,446,620 1,534,933 1,446,620 1,457,793 1,681,033 1,382,898 1,446,838 1,446,850 1,446,432 1,535,087 1,446,435 $ (168,608) $ (595,321) $ (595,321) $ (595,539) $ (595,769) $ (595,582) $ (595,737) $ (595,552) $ 140,923 $ (34,818) $ 599,858 51,664 34,818 356,700 26,913 24,600 616 103,396 884,376 5,997 59,055 2,384 4,627 2,685 7,890 5,161 2,391 3,300 3,185 25,011 9,650 23,886 10,242 20,916 61,940 $ (34,818) $ - $ - $ - $ - $ - $ - $ $ (203,426) $ (595,321) $ (595,321) $ (595,539) $ (595,769) $ (595,582) $ (595,737) $ (595,552) (535,800) (535,800) (535,800) (483,800) (438,800) (403,800) (289,800) (274,179) 1356,700) /356.700) /332,074) 1307,126) /281,852) 1256247) 1230.308) /204,029) $((,095,926) $(1,487,82'() $(1,463,195) $(1,386,466) $(1,316,421) $(1,255,629) $(1,115,844) $(1,073,760) OPERATING FUND: Fuel Sales Revenue (2.5% Increase) Non-taxable Rents Golf Course Rents Taxable Rents Other Revenue Transfer from General Fund Investment Income PROJECTED REVENUE Operating Costs Fuel Purchases for Resale Mower Fencing Repairs Air Conditioners Gate Installation Vehicle Purchase Swoop Pond Wind Sock and Pole Repayment of General Fund Advance Repayment of DST Fund Advance TOTAL FY 16 TOTAL FY 17 Entrance Signage TOTAL FY 18 TOTAL FY 19 TOTAL FY 20 TOTAL FY 21 TOTAL FY 22 TOTAL FY 22 BEGINNING FUND BALANCE TOTAL REVENUES TOTAL EXPENDITURES+DEBT+TRANSFERS ENDING FUND BALANCE CAPITAL FUND: BEGINNING FUND BALANCE Grants Transfers from General Fund Transfers from DST Total Expended ENDING FUND BALANCE TOTAL OPERATING AND CAPITAL General Fund Advance Balance DST Fund Advance Balance CAFR Unrestricted Balance AIRPORT FUND PROJECTED BALANCES FISCAL YEARS 2018-2023 FY 15.16 FY 16.17 FY 17-18 FY 18.19 FY 19.20 FY 20-21 FY 21-22 FY 22-23 $ 78,095 $ 74,000 $ 74,000 $ 75,850 $ 77,746 $ 79,690 $ 81,682 $ 83,724 391 391 391 391 391 391 391 391 100,000 100,000 106,000 106,000 106,000 106,000 106,000 106,000 231,847 238,375 298,625 298,625 298,625 298,625 298,625 298,625 106,070 80,793 73,840 73,840 73,840 73,840 73,840 73,840 4,826 5,526 892 567 600 784 1,031 956 874 791 $ 522,121 $ 499,652 $ 553,456 $ 555,490 $ 557,634 $ 559,502 $ 561,412 $ 563,371 379,515 381,946 437,956 443,211 448,530 453,912 459,359 464,872 57,919 55,000 56,000 57,400 58,835 60,306 61,814 63,359 2,524 27,416 14,061 12,000 29,331 6,020 4,826 50,000 10,000 25,000 10,000 10,000 10,000 10,000 10,000 19,376 24,500 24,500 30,500 30,500 30,500 30,500 30,500 $ 598,162 $ 476,272 10,000 $ 553,456 $ 541,111 $ 547,865 $ 554,718 $ 561,673 $ 568,730 $ 17,944 $ (58,097) $ (34,717) $ (34,717) $ (20,339) $ (10,570) $ (5,786) $ (6,047) 522,121 499,652 553,456 555,490 557,634 559,502 561,412 563,371 598,162 476,272 553,456 541,111 547,865 554,718 561,673 568,730 $ (58,097) $ (34,717) $ (34,717) $ (20,339) $ (10,570) $ (5,786) $ (6,047) $ (11,407) 532,818 1,179,906 2,389,463 2,262,317 900,000 900,000 1,900,000 - 2,800 181,895 297,267 334,195 128,819 225,000 225,000 100,000 - 717,513 1,477,173 2,723,658 2,391,136 1,125,000 1,125,000 2,000,000 - $ (58,097) $ (34,717) $ (34,717) $ (20,339) $ (10,570) $ (5,786) $ (6,047) $ (11,407) ((100,000) 50,638) ( (90,000j) ( (65,000)) (( (55,000) (45,000) (618.506) (35,000) J502.747) (25,000) ( (15,0000 $ (708,735) $ (672,880) $ 1645,306) $ i612,252j $ 583,460) $ (559 292) $ 533,794) $ (512,764) BUILDING FUND PROJECTED BALANCES FISCAL YEARS 2015-2023 FY 15.16 FY 16.17 FY 17-18 FY 18-19 FY 19.20 FY 20-21 FY 21-22 FY 22.23 Operating Revenue $ 801,641 $ 645,400 $ 652,400 $ 671,972 $ 692,131 $ 712,895 $ 734,282 $ 756,310 Other Revenue 8,428 2,000 2,500 2,500 2,500 2,500 2,500 2,500 Transfer from General Fund - 25,000 - - - - - - Pdncipal on Golf Course Loan - - 24,626 24,948 25,274 25,605 25,940 26,279 Interest on Golf Course Loan - 4,544 7,118 6,796 6,470 6,139 5,804 5,465 Investment Income 5,323 5,700 4,200 4,172 4,550 4,948 5,011 5,432 PROJECTED REVENUE $ 815,392 $ 682,644 $ 690,844 $ 710,388 $ 730,925 $ 752,087 $ 773,536 $ 795,986 Operating Costs Compact Pickup Clear Village Software - 14,383 Operating Costs 532,915 Compact Pickup 20,183 Utility Vehicle 28,100 Surface Tablets 2,814 Large Plan Scanner 14,639 Transfer to General Fund 104,086 Loan to Golf Course 356,700 202,087 TOTAL FY 16 $ 1,059,437 Operating Costs 535,772 TOTAL FY 17 $ 752,242 Operating Costs 607.723 TOTAL FY 18 $ 607,723 Operating Costs 622,673 TOTAL FY 19 $ 622,673 Operating Costs 637,991 TOTAL FY 20 $ 637,991 Operating Costs 653,685 TOTAL FY 21 $ 653,685 Operating Costs 669,766 TOTAL FY 22 $ 669,766 Operating Costs 686,242 TOTAL FY 23 $ 686,242 BEGINNING FUND BALANCE $ 975,044 $ 730,999 $ 661,401 $ 744,522 $ 832,237 $ 832,237 $ 925,171 $ 930,639 TOTAL REVENUES 815,392 682,644 690,844 710,388 730,925 752,087 773,536 795,986 EXPENDITURES+DEBT+TRANSFERS 1,059,437 752,242 607,723 622,673 637,991 653,685 669,766 686,242 ENDING FUND BALANCE $ 730,999 $ 661,401 $ 744,522 $ 832,237 $ 925,171 $ 930,639 $ 1,028,941 $ 1,040,383 Golf Course Fund Advance Balance 356,700 558,787 534,161 509,213 483,939 458,334 432,395 406,116 CAM Unrestricted Balance $ 1,087,699 $1,220,188 $ 1,278,683 $ 1,341,450 $ 1,409,110 $ 1,388,973 $ 1,461,336 $ 1,446,499