Loading...
HomeMy WebLinkAboutOrdinance 12-24RECORD OF ORDINANCES Dayton Legal Blank, Inc. Form No. 30043 Ordinance No. 12-24 Passed __,20 ADOPTING THE PROPOSED TAX BUDGET FOR FISCAL YEAR 2025 WHEREAS, Section 5705.28 of the Ohio Revised Code requires that City Council adopt a tax budget for the following year on or before July 15; and WHEREAS, Section 5705.30 of the Ohio Revised Code requires the tax budget to be filed with the County Auditor(s), as secretary to the budget commission(s), on or before July 20; and WHEREAS, the filing of the tax budget with the County Auditor(s) entitles the City to participate in “Local Government Funds” which are monies collected by the State of Ohio and shared with its various political Subdivisions via the County(s). NOW, THEREFORE, BE IT ORDAINED by the Council of the City of Dublin, State of Ohio, _ | »_ of the elected members concurring that: Section 1. The proposed 2025 tax budget hereto attached as an Exhibit, be and hereby is approved. Section 2. This ordinance shall take effect on the earliest date permitted under applicable law. J Passed this 5 day of 2024 a a ae Mayor — Presiding Officer ATTEST: 7 Courfil ‘ /) To: Members of Dublin City Council From: Megan O’Callaghan, City Manager Date: May 14, 2024 Initiated By: Matthew L. Stiffler, Chief Financial Officer/Director of Finance Jaime Hoffman, Director of Financial Operations Meghan Murray, Budget Manager Re: Ordinance 12-24 – Adopting the Proposed Tax Budget for Fiscal Year 2025 Summary In compliance with the Ohio Revised Code (ORC) Section 5705.28, submitted for your approval is the proposed tax budget for the 2025 fiscal year (calendar basis). The Ohio Revised Code mandates adoption of the tax budget by a political subdivision (taxing authority) no later than July 15th of each year for the next succeeding calendar year. The approved tax budget must be effective prior to filing with the office of the County Auditor, and must be filed with the County Auditor (5705.30 ORC) no later than July 20th. The budgetary laws governing political subdivisions in the State of Ohio can be found in Section 5705 of the Ohio Revised Code. The tax budget has historically been part of the initial stages of the City’s annual budgeting process and has previously represented the City’s first estimate of its anticipated financial condition, resources and expenditure needs for the coming year. The primary purpose of the Tax Budget is to set property tax rates, and allocate local government fund dollars. The Tax Budget covers the financial completion (actuals) for calendar years 2022 and 2023, a budget forecast for calendar year 2024, and the projection for calendar year 2025. This 2025 projection is usually based on the estimated revenue and expenditure figures previously used to calculate the 2024 Operating Budget and 2024-2028 Capital Improvements Program (CIP). As you know, the City’s updated revenue estimate for 2024, and revenue projection for 2025 will not be available until July/August – after the mandated filing deadline for this document. In no way does adoption of the tax budget grant any legal spending authority of public funds, or commit to any capital improvement projects for the 2025 fiscal year. This is not an appropriation measure. Once the Tax Budget is adopted, it will be filed with the Delaware and Franklin County Auditors, as they are the secretaries for their respective Budget Commissions. Union County does not require the Tax Budget to be submitted to their County Budget Commission. The City’s eligibility to receive the State’s shared revenue, “local government funds” from Delaware and Franklin Counties is contingent upon the timely filing of a Tax Budget. The Franklin County Budget Commission also reviews any property tax levy assessments outside the ten-mill limitation to verify the appropriate millage for those obligations. The Tax Budget includes the following columns as marked in the document on Exhibits I through II: Office of the City Manager 5555 Perimeter Drive • Dublin, OH 43017-1090 Phone: 614-410-4400 • Fax: 614-410-4490 Memo Ordinance 12-24 – Adopting the Proposed Tax Budget for Fiscal Year 2025 May 14, 2024 2 (1) Description of the revenue or expenditure type. (2) Actual revenue and expenditure figures for calendar year 2022. (3) Actual revenue and expenditure figures for calendar year 2023. (4) This column represents the current year’s information. It includes 2024 revised budgeted revenue and expenditures which are based on appropriations approved by City Council (including carry-over 2023 encumbrances), plus Q1 supplemental appropriations and increases/decreases in estimated resources actually budgeted through April 2024, and/or information received from the Franklin County Auditor updating real estate tax collection estimates. (5) This column represents the upcoming year 2025. It includes projected budget figures for the 2023 calendar year based on the revenue and expenditure assumptions listed below. Revenue Assumptions: • Income tax projections for 2025 remained consistent with 2024. More analysis of income tax trends will be done prior to preparation of the 2025 Annual Operating Budget in late summer/early fall. At that time, more information may be known regarding the income tax impacts of work-from-home. • Revenue (in most cases) remained horizontal in the City’s 2025 Tax Budget projection, although we are seeing a gradual increase in revenues for 2024 in some Departments. Due to the continuing financial influence of the current economic climate, historical-based increases used to complete the next year projections were not necessarily reliable, and the Finance Team has erred on the side of caution. Expenditure Assumptions: • For personal services a 2% merit increase was projected on the 2024 budget, which is consistent with prior years and union contracts for 2025. • Each expenditure line item for 2025 was analyzed separately, and non-recurring expenditures from 2023 actual data were not programmed into the 2025 projections. • As of March 2024, the inflationary rate is 3.1%. However, for purposes of this Tax Budget, a 2.5% inflationary rate (in most cases) was applied across various spending categories based on 2023 actual expenditures, or 2024 budgeted expenditures as appropriate. This was done not only to provide fiscal prudence, but because the compliance requirements for filing the Tax Budget are so early in the year that it is difficult to determine the financial drivers for 2025 at this time. More in-depth review and data analysis will be completed prior to the preparation of the 2025-2029 CIP and the Annual Operating Budget to provide financial insights into economic conditions and risks projected for next year. Additionally, it will allow the City’s Administration and City Council to leverage the use of more timely figures in making data-driven financial decisions for 2025. Exhibit III is used for all funds that do not derive any revenue from the general property taxes (all funds not included on Exhibits I and II, construction funds and TIF Funds). Exhibit IV includes supplemental information for the Capital Improvements Program as well as the City’s debt schedule. The Capital Improvements projection is reflected in the City’s approved 2024- 2028 Capital Improvements Program (excluding any expenses to be paid from bond issue), and the debt schedule is based on the projection for calendar year 2024. Property Tax Distribution The Safety Fund, the Parkland Acquisition Fund, and the Capital Improvements Tax Fund receive property tax revenues. The allocation of the City’s inside millage (also known as “unvoted” millage), Ordinance 12-24 – Adopting the Proposed Tax Budget for Fiscal Year 2025 May 14, 2024 3 a total of 1.75 mills, can be adjusted on an annual basis. As part of the 2024 – 2028 CIP review, City Council approved the same allocation where 80% (1.4 mills) of the property tax revenue from the City’s “inside millage” is allocated to the Capital Improvements Tax Fund, with the remaining 20% (.35 mills) is allocated to the Parkland Acquisition Fund. Following is a history of approved allocations. The City has the option to reallocate the tax revenue from the inside millage each year as part of the tax budget process, and then again later in the year when the Resolution Accepting the Amounts and Rates is approved by City Council. It is important to note that despite the fact that 20% of the property tax revenue received from the inside millage is allocated to the Parkland Acquisition Fund, the amount allocated within the Capital Improvement Tax Fund may also be used for parkland acquisition and other park-related capital improvements, as well as to acquire rights-of- way for shared-use path projects. Another source of revenue for the Parkland Acquisition Fund includes a $50,000 contribution from Washington Township (annually from 2015 through 2024) in exchange for the City assuming ownership and maintenance for Kaltenbach Park. Expenditures in the Parkland Acquisition Fund consist of County Auditor’s deductions for real estate services, and the annual $750,000 allocation for capital expenditures. As of December 31, 2023, the fund balance in the Parkland Acquisition Fund was $4,860,754. Income Tax The City’s largest revenue source for general operations is obtained through income taxes. In the 2024 Operating Budget, it was estimated that revenue from local income tax would be approximately $106,000,000. Per City Code, 75% or $79,500,000 is programmed in the General Fund, and 25% or $26,500,000 is programmed in the Capital Improvements Tax Fund. As stated previously in this memo, as of the current date, income taxes for 2025 are being projected conservatively at a stable, flat rate. This estimate, as well as the 2024 income tax estimate will be updated in late summer of this year. General Fund Balance When looking at the projected General Fund balance, it is important to remember that these figures are based on estimates that spend all funds appropriated in 2024 and 2025. In recent years, at least 10% of appropriations across all the funds are unspent or encumbered. Recommendation Staff recommend passage of the ordinance at the second reading/public hearing on June 3, 2024. Attachment: 2025 Tax Budget Years General Fund Safety Fund GO Debt Service Fund Parkland Acquisition Fund Capital Improvements Fund Prior to 2000 1.17 0.50 0.08 2001-2006 1.75 2007-2009 0.95 0.80 2010-2024 0.35 1.40 SCHEDULE A SUMMARY OF AMOUNTS REQUIRED FROM GENERAL PROPERTY TAX APPROVED BY BUDGET COMMISSION, AND COUNTY AUDITOR'S ESTIMATED RATES For Municipal Use For Budget Commission Use For County Auditor Use Budget Year Budget Year County Auditor's estimate Amount Amount Approved Budget Year Tax Rate to be Levied FUND Requested of by Budget Amount to be (Include only those funds Budget Commission Derived From Inside 10 Mill Outside 10 Mill which are requesting Commission Inside/Inside 10 Mill Levies Outside Limited Budget Limit Budget general property tax revenue) Outside Limitation 10 Mill Limitation Year Year Column 1 Column 2 Column 3 Column 4 Column 5 GOVERNMENT FUNDS XXXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX GENERAL FUND 0 0 0 POLICE/SAFETY OPERATING FUND 535,000 0 535,000 PARKLAND ACQUISITION 843,650 843,650 0 CAPITAL IMPROVEMENTS TAX FUND 3,400,000 3,400,000 0 PROPRIETARY FUNDS XXXXXXXX XXXXXXXX XXXXXXXXX XXXXXXXXX XXXXXXXX FIDUCIARY FUNDS XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX TOTAL ALL FUNDS 4,778,650 4,243,650 535,000 SCHEDULE B LEVIES OUTSIDE 10 MILL LIMITATION, EXCLUSIVE OF DEBT LEVIES Tax Year County Auditor's FUND Maximum Rate Estimate of Authorized to be Yield of Levy Levied (Carry to Schedule A, Column 3) GENERAL FUND: Current Expense Levy authorized by voters on / / , not exceed years. Authorized under Sect. , R.C. TOTAL GENERAL FUND OUTSIDE 10 MILL LIMITATION SPECIAL LEVY FUNDS POLICE/SAFETY FUND, Levy authorized by voters on 11/1981 1.2 535,000 not to exceed ON-GOING years. Authorized under Section , R.C. FUND, Levy authorized by voters on / / FUND NAME: GENERAL FUND EXHIBIT I FUND TYPE/CLASSIFICATION: GOVERNMENTAL -- GENERAL This Exhibit is to be used for the General Fund Only Current Year Budget Year For 2022 For 2023 Estimated for Estimated for DESCRIPTION Actual Actual 2024 2025 (1) (3) (3) (4) (5) REVENUES XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX Local Taxes General Property Tax -- Real Estate 0 0 0 0 Tangible Personal Property Tax 0 0 0 0 Municipal Income Tax 78,602,233 80,718,323 79,500,000 79,500,000 Other Local Taxes 0 0 0 0 Total Local Taxes 78,602,233 80,718,323 79,500,000 79,500,000 Intergovernmental Revenues State Shared Taxes and Permits Local Government 645,635 674,239 620,325 645,000 Estate Tax 0 0 0 0 Cigarette Tax 410 613 700 700 Liquor and Beer Permits 103,024 94,728 50,000 60,000 Gasoline Tax 0 0 0 0 Library and Local Government Support Fund 0 0 0 0 Property Tax Allocation 0 0 0 0 Other Permits 0 0 5,000 5,000 Total State Shared Taxes and Permits 749,068 769,580 676,025 710,700 Federal Grants or Aid 0 0 0 0 State Grants or Aid 0 0 0 0 Other Grants or Aid 17,046 17,678 15,000 15,000 Total Intergovernmental Revenues 766,115 787,258 691,025 725,700 Special Assessments 0 0 0 0 Charges for Services 1,277,804 1,694,819 1,242,000 1,242,000 Fines, Licenses, and Permits 3,384,650 3,293,852 3,269,500 3,269,500 Miscellaneous 2,586,066 3,354,074 1,640,350 1,640,350 Other Financing Sources: Proceeds from Sale of Debt 0 0 0 0 Transfers 0 0 0 0 Advances 6,068,800 400,000 290,000 290,000 Other Sources (Sale of Capital Assets) 0 0 0 0 TOTAL REVENUE 92,685,667 90,248,326 86,632,875 86,667,550 FUND NAME: GENERAL FUND EXHIBIT I FUND TYPE/CLASSIFICATION: GOVERNMENTAL -- GENERAL This Exhibit is to be used for the General Fund Only Current Year Budget Year DESCRIPTION For 2022 For 2023 Estimated for Estimated for (1)Actual Actual 2024 2025 (3) (3) (4) (5) EXPENDITURES XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX Security of Persons and Property Personal Services 0 0 0 0 Travel Transportation 0 0 0 0 Contractual Services 144,264 212,230 269,945 269,950 Supplies and Materials 126,396 148,935 172,609 172,610 Capital Outlay 0 0 0 0 Total Security of Persons and Property 270,660 361,164 442,554 442,560 Public Health Services Personal Services 0 0 0 0 Travel Transportation 0 0 0 0 Contractual Services 508,835 510,074 657,485 690,360 Capital Outlay 0 0 0 0 Total Public Health Services 508,835 510,074 657,485 690,360 Leisure Time Activities Personal Services 5,379,588 5,945,350 5,974,778 6,094,280 Travel Transportation 0 0 0 0 Contractual Services 2,477,272 2,808,054 4,075,087 4,075,090 Supplies and Materials 432,117 507,302 630,880 630,880 Capital Outlay 14,825 19,674 20,500 20,500 Total Leisure Time Activities 8,303,801 9,280,379 10,701,246 10,820,750 Community Environment Personal Services 5,988,325 6,078,219 6,498,895 6,628,880 Travel Transportation 0 0 0 0 Contractual Services 1,087,549 1,609,592 4,408,503 4,408,500 Supplies and Materials 25,271 22,407 41,454 33,000 Capital Outlay 0 0 0 0 Total Community Environment 7,101,145 7,710,219 10,948,852 11,070,381 Basic Utility Services Personal Services 819,414 783,962 765,261 784,400 Travel Transportation 0 0 0 0 Contractual Services 3,890,683 4,341,769 5,083,649 5,083,650 Supplies and Materials 21,662 11,325 49,898 49,900 Capital Outlay 438 0 0 0 Total Basic Utility Services 4,732,197 5,137,055 5,898,808 5,917,949 FUND NAME: GENERAL FUND EXHIBIT I FUND TYPE/CLASSIFICATION: GOVERNMENTAL -- GENERAL This Exhibit is to be used for the General Fund Only Current Year Budget Year DESCRIPTION For 2022 For 2023 Estimated for Estimated for (1)Actual Actual 2024 2025 (3) (3) (4) (5) Transportation Personal Services 1,364,901 1,414,635 1,504,402 1,534,490 Travel Transportation 0 0 0 0 Contractual Services 645,793 1,088,076 2,363,613 2,363,620 Supplies and Materials 115,662 199,213 191,090 195,870 Capital Outlay 0 0 0 0 Total Transportation 2,126,355 2,701,925 4,059,105 4,093,979 General Government Personal Services 13,443,665 12,801,019 16,165,462 14,940,500 Travel Transportation 0 0 0 0 Contractual Services 8,737,081 9,007,642 10,968,399 8,200,000 Supplies and Materials 3,820,435 3,915,102 6,520,826 6,520,830 Capital Outlay 8,804,179 1,703,620 1,444,430 1,444,430 Total General Government 34,805,360 27,427,383 35,099,117 31,105,760 Debt Service Interest 0 0 0 0 Other Debt Service 0 0 0 0 Total Debt Service 0 0 0 0 Other Uses of Funds Transfers 16,160,000 25,750,000 23,370,000 23,370,000 Advances 1,536,965 2,406,665 9,136,965 9,136,970 Contingencies 180,529 352,805 334,636 150,000 Other Uses of Funds(Refunds/Incentives/Grants)10,603,794 5,512,152 5,558,750 6,000,000 Total Other Uses of Funds 28,481,287 34,021,621 38,400,351 38,656,970 TOTAL EXPENDITURES 86,329,641 87,149,821 106,207,516 102,798,709 Revenues over/(under) Expenditures 6,356,026 3,098,505 (19,574,641) (16,131,159) Beginning Cash Fund Balance 57,485,989 63,842,015 66,940,521 47,365,879 Ending Cash Fund Balance 63,842,015 66,940,521 47,365,879 31,234,720 Estimated Encumbrances (4,122,792) (7,187,197) 0 0 Estimated Ending Unencumbered Fund Balance 59,719,224 59,753,324 47,365,879 31,234,720 65,413,002 64,150,929 77,558,572 FUND NAME: SAFETY/POLICE OPERATING EXHIBIT II FUND TYPE/CLASSIFICATION: SPECIAL REVENUE To be used for any fund receiving property tax revenue except the General Fund. Current Year Budget Year DESCRIPTION For 2022 For 2023 Estimated for Estimated for (1)Actual Actual 2024 2025 (3) (3) (4) (5) REVENUE XXXXXXXX XXXXXXXX XXXXXXXXX XXXXXXXX Local Taxes - Real Estate 509,057 512,815 535,000 535,000 Intergovernmental Revenue 109,513 67,959 60,500 60,500 Charges for Services 3,998,328 4,287,850 4,590,876 4,590,876 Miscellaneous 37,428 33,388 24,500 24,500 Other Financing Sources: Transfers 8,250,000 14,000,000 16,500,000 14,000,000 Other Sources 0 0 0 0 TOTAL REVENUE 12,904,325 18,902,012 21,710,876 19,210,876 EXPENDITURES XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX (Identify each program and object XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX code at the same level shown on XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX (PROGRAM) (OBJECT) Security of Persons and Property Personal Services 12,438,468 18,292,270 17,892,715 18,250,570 Travel/Transportation 0 0 0 0 Contractual Services 243,043 291,617 652,259 668,570 Supplies and Materials 233,169 257,204 405,744 415,890 Capital Outlay 2,976 20,710 24,713 25,340 Other Uses(Refunds and other misc) 3,958 3,958 6,650 6,650 TOTAL EXPENDITURES 12,921,614 18,865,759 18,982,082 19,367,021 Revenues Over (Under) Expenditures (17,289)36,254 2,728,794 (156,145) Beginning Cash Fund Balance 2,414,491 2,397,202 2,433,456 5,162,250 Ending Cash Fund Balance 2,397,202 2,433,456 5,162,250 5,006,105 Estimated Encumbrances (outstanding at end of year)(174,125) (149,159) 0 0 Estimated Ending Unencumbered Fund Balance 2,223,077 2,284,297 5,162,250 5,006,105 FUND NAME: CAPITAL IMPROVEMENTS TAX FUND EXHIBIT II FUND TYPE/CLASSIFICATION: CAPITAL PROJECTS To be used for any fund receiving property tax revenue except the General Fund. Current Year Budget Year DESCRIPTION For 2022 For 2023 Estimated for Estimated for (1)Actual Actual 2024 2025 (3) (3) (4) (5) REVENUE XXXXXXXX XXXXXXXX XXXXXXXXX XXXXXXXX Local Taxes* Property Tax -- Real Estate/Personal Property 3,299,006 3,337,604 3,400,000 3,400,000 Municipal Income Tax (Note 1) 26,200,746 26,906,109 26,500,000 26,500,000 Intergovernmental Revenue 8,493,151 1,372,667 351,615 351,615 Fines, Licenses, and Permits 1,534,702 0 0 0 Miscellaneous 692,258 3,334,254 800,000 800,000 Other Financing Sources: Transfers 3,980,000 7,100,000 7,820,000 7,820,000 Other Sources-Advances 1,658,000 1,098,000 2,198,000 1,863,000 Proceeds from Bonds 0 0 0 0 TOTAL REVENUE 45,857,863 43,148,633 41,069,615 40,734,615 EXPENDITURES XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX (Identify each program and object XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX code at the same level shown on XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX (PROGRAM) (OBJECT) Contractual Services 61,703 44,894 65,000 66,630 Capital Outlay 28,559,033 33,216,263 63,337,641 29,207,380 Transfers 6,495,552 7,107,057 7,760,141 7,760,141 Advances 5,500,000 1,000,000 750,000 2,000,000 TOTAL EXPENDITURES 40,616,289 41,368,214 71,912,782 39,034,151 Revenues Over (Under) Expenditures 5,241,574 1,780,419 (30,843,167)1,700,464 Beginning Cash Fund Balance 39,952,450 45,194,024 46,974,444 16,131,277 Ending Cash Fund Balance 45,194,024 46,974,444 16,131,277 17,831,741 Estimated Encumbrances (outstanding at end of year)(18,810,746) (24,252,641) 0 0 Estimated Ending Unencumbered Fund Balance 26,383,278 22,721,803 16,131,277 17,831,741 Note 1: A portion of this revenue is designated to retire debt for capital improvements. FUND NAME: PARKLAND ACQUISITION EXHIBIT II FUND TYPE/CLASSIFICATION: CAPITAL PROJECTS To be used for any fund receiving property tax revenue except the General Fund. Current Year Budget Year DESCRIPTION For 2022 For 2023 Estimated for Estimated for (1)Actual Actual 2024 2025 (3) (3) (4) (5) REVENUE XXXXXXXX XXXXXXXX XXXXXXXXX XXXXXXXX Local Taxes - Real Estate 824,752 834,398 843,650 843,650 Intergovernmental Revenue 142,105 193,314 160,000 160,000 Fines, Licenses, and Permits 0 0 0 0 Miscellaneous 0 0 0 0 Other Financing Sources: Transfers 0 0 0 0 Other Sources-Advances 0 0 0 0 Proceeds from Bonds 0 0 0 0 TOTAL REVENUE 966,857 1,027,712 1,003,650 1,003,650 EXPENDITURES XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX (Identify each program and object XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX code at the same level shown on XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX (PROGRAM) (OBJECT) Contractual Services 15,257 12,040 18,500 18,970 Capital Outlay 0 0 800,000 820,000 Transfers 0 0 0 0 Advances 0 0 0 0 TOTAL EXPENDITURES 15,257 12,040 818,500 838,970 Revenues Over (Under) Expenditures 951,600 1,015,672 185,150 164,681 Beginning Cash Fund Balance 2,893,482 3,845,082 4,860,754 5,045,904 Ending Cash Fund Balance 3,845,082 4,860,754 5,045,904 5,210,584 Estimated Encumbrances (outstanding at end of year)(6,523) (6,523) 0 0 Estimated Ending Unencumbered Fund Balance 3,838,559 4,854,231 5,045,904 5,210,584 EXHIBIT III List of All Funds Individually Unless Reported on Exhibits l and II (pg 1 of 2) FUND Estimated Budget Year Total Available List All Funds Individually Unless Unencumbered Estimated For Personal Other Total Estimated Reported on Exhibit I or II Fund Balance Receipt Expenditures Services Unencumbered 01/01/24 Balance 12/31/24 GOVERNMENTAL: XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX SPECIAL REVENUE: XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX Street Maintenance & Repair 818,916 3,170,000 3,988,916 2,039,380 1,343,650 3,383,030 605,886 State Highway Improvement 440,349 214,600 654,949 0 261,420 261,420 393,529 Cemetery 122,663 240,000 362,663 158,940 62,720 221,660 141,003 Recreation 1,784,865 8,334,200 10,119,065 5,880,550 3,257,430 9,137,980 981,085 Swimming Pool 105,959 1,259,400 1,365,359 835,130 520,400 1,355,530 9,829 Permissive Tax 39,740 108,000 147,740 0 120,000 120,000 27,740 Hotel/Motel Tax 1,711,899 5,460,500 7,172,399 955,510 5,408,770 6,364,280 808,119 Enforcement and Education 72,737 1,700 74,437 0 0 0 74,437 Law Enforcement Trust 96,072 1,500 97,572 0 40,000 40,000 57,572 Mandatory Drug Fine 2,918 40 2,958 0 0 0 2,958 Mayor's Court Computer 33,767 15,750 49,517 0 33,400 33,400 16,117 Accrued Leave Reserves 726,619 537,000 1,263,619 499,800 0 499,800 763,819 Wireless 9-1-1 System 671,484 125,000 796,484 0 194,140 194,140 602,344 Rings Unitrust 1,000,000 0 1,000,000 0 0 0 1,000,000 Covid Relief Fund 8,210 0 8,210 0 0 0 8,210 Local Coronavirus Recovery Fund 0 0 0 0 0 0 0 Opiod Relief Fund 0 TOTAL SPECIAL REVENUE FUNDS 7,636,198 19,467,690 27,103,888 10,369,310 11,241,931 21,611,241 5,492,648 DEBT SERVICE FUNDS XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX General Debt Service 2,216,971 11,520,438 13,737,409 0 13,500,000 13,500,000 237,409 Economic Development Bond Retirement 703,873 4,131,830 4,835,703 0 2,065,920 2,065,920 2,769,783 Special Assessment Debt Service 14,619 0 14,619 0 0 0 14,619 2001 Special Assessment Debt Service 134,413 0 134,413 0 500 500 133,913 TOTAL DEBT SERVICE FUNDS 3,069,876 15,652,268 18,722,144 0 15,566,420 15,566,420 3,155,724 CAPITAL PROJECT FUNDS XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX Note: Various construction funds not included. TOTAL CAPITAL PROJECTS 0 0 0 0 0 0 0 PERMANENT IMPROVEMENT FUNDS XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX Cemetery Perpetual Care 1,683,474 25,000 1,708,474 0 0 0 1,708,474 TOTAL PERMANENT IMPROVEMENTS FUNDS 1,683,474 25,000 1,708,474 0 0 0 1,708,474 Budget Year Expenditures and Encumbrances EXHIBIT III List of All Funds Individually Unless Reported on Exhibits l and II (pg 2 of 2) FUND Estimated Budget Year Total Available Budget Year Expenditures and Encumbrances List All Funds Individually Unless Unencumbered Estimated For Personal Other Total Estimated Reported on Exhibit I or II Fund Balance Receipt Expenditures Services Unencumbered 01/01/24 Balance 12/31/24 PROPRIETARY: XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX ENTERPRISE FUNDS XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX Water 11,583,790 1,501,610 13,085,400 299,900 1,760,380 2,060,280 11,025,120 Sewer 4,529,974 3,313,692 7,843,666 811,450 3,734,600 4,546,050 3,297,616 Water Construction 6,470 935,000 941,470 0 860,000 860,000 81,470 Sewer Construction 346,830 2,775,000 3,121,830 0 2,675,000 2,675,000 446,830 TOTAL ENTERPRISE FUNDS 16,467,064 8,525,302 24,992,366 1,111,350 9,029,980 10,141,330 14,851,036 Note: Various construction funds not included. INTERNAL SERVICE FUNDS XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXX Employee Benefits Self-Insurance 3,829,736 10,910,000 14,739,736 107,680 11,383,220 11,490,900 3,248,836 Workers Compensation Self-Insurance 182,634 304,000 486,634 0 473,280 473,280 13,354 TOTAL INTERNAL SERVICE FUNDS 4,012,370 11,214,000 15,226,370 107,680 11,856,500 11,964,180 3,262,190 TRUST AND AGENCY FUNDS XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX Visit Dublin Ohio (aka DCVB) 82,304 900,000 982,304 0 900,000 900,000 82,304 Agency (Deposits) 3,715 71,500 75,215 0 30,000 30,000 45,215 COIRS 226,704 1,203,711 1,430,415 0 1,217,100 1,217,100 213,315 Econ Dev - PACE 626 743,980 744,606 0 743,980 743,980 626 TOTAL TRUST AND AGENCY FUNDS 313,349 2,919,191 3,232,540 0 2,891,080 2,891,080 341,460 TOTAL FOR MEMORANDUM ONLY 31,498,857 57,778,451 89,277,311 11,588,341 50,585,909 62,174,254 27,103,058 EXHIBIT IV (pg 1 of 1) Estimated Cost DESCRIPTION of Permanent Name of Paying Fund Improvement CIP - Administration Administration (land acquisition, contingencies, sewer ext.) Municipal Facilities 6,185,000 2,495,000 Capital Improvements Tax Fund Computer Hardware/Software/Fiber 11,348,140 2,261,000 Capital Improvements Tax Fund CIP - Parks & Recreation Parks 24,540,000 5,665,000 Capital Improvements Tax Fund, TIF Funds (as appropriate), Hotel/Motel CIP - Safety Police 4,390,000 1,595,000 Capital Improvements Tax Fund CIP - Stormwater System Stormwater Improvements 6,485,000 585,000 Capital Improvements Tax Fund CIP - Transportation Mobility, Bicycles and Pedestrians 35,174,000 2,359,000 Capital Improvements Tax Fund and TIF Funds (as appropriate) Bridges and Culverts 19,078,000 13,336,000 Capital Improvements Tax Fund and TIF Funds (as appropriate) Streets and Parking 82,716,000 17,674,000 Capital Improvements Tax Fund and TIF Funds (as appropriate) SUB-TOTAL 206,392,344 49,463,542 CIP - Sanitary Sewer System Sewer Improvements 0 0 Sewer Fund CIP - Water Distribution System Water Improvements 340,000 0 Water Fund SUB-TOTAL 340,000 0 TOTAL 206,732,344 49,463,542 Capital Improvements Tax Fund and Water & Sewer, Hotel/Motel1,849,0008,176,000 Fleet Management Total Project Cost 2024-2028 CIP (May Include Other Funding Sources including TIFs) 2025 Projects 8,300,204 1,644,542 Capital Improvements Tax Fund & Parkland Acquisition Fund STATEMENT OF PERMANENT IMPROVEMENTS (Do Not Include Expense to be Paid from Bond Issue) (Section 5705.29. Revised Code) Amount to be Budgeted During Current Year