Loading...
Ordinance 22-21 To: Members of Dublin City Council From: Dana L. McDaniel, City Manager Date: May 18, 2021 Initiated By: Matthew L. Stiffler, Director of Finance Rosa Ocheltree, Deputy Director of Finance Melody Kennedy, Budget Manager Re: Ordinance 22-21 – Adopting the Proposed Tax Budget for Fiscal Year 2022 Summary In compliance with the Ohio Revised Code (ORC) Section 5705.28, submitted for your approval is the proposed tax budget for the 2022 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 2019 and 2020, a budget forecast for calendar year 2021, and the projection for calendar year 2022. This 2022 projection is usually based on the estimated revenue and expenditure figures previously used to calculate the 2021 Operating Budget and 2021-2025 Capital Improvements Program (CIP). As you know, the City’s updated revenue estimate for 2021, and revenue projection for 2022 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 2022 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. Office of the City Manager 5555 Perimeter Drive • Dublin, OH 43017-1090 Phone: 614-410-4400 • Fax: 614-410-4490 Memo Ord. 22-21 – Adopting the Proposed Tax Budget for Fiscal Year 2022 May 18, 2021 2 The Tax Budget includes the following columns as marked in the document on Exhibits I through II: (1) Description of the revenue or expenditure type. (2) Actual revenue and expenditure figures for calendar year 2019. (3) Actual revenue and expenditure figures for calendar year 2020. (4) This column represents the current year’s information. It includes 2021 revised budgeted revenue and expenditures which are based on appropriations approved by City Council (including carry-over 2020 encumbrances), plus Q1 supplemental appropriations and increases/decreases in estimated resources actually budgeted through April 2021, and/or information received from the Franklin County Auditor updating real estate tax collection estimates. (5) This column represents the upcoming year 2022. It includes projected budget figures for the 2022 calendar year based on the revenue and expenditure assumptions listed below. Due to the financial influence of the COVID-19 pandemic, historical-based increases used to complete the next year projections were not necessarily reliable. Subsequently, each revenue and expenditure line item for the 2022 projection was analyzed separately. Revenue Assumptions: • 0-1% increase was used based on 2019 actual revenues (in most cases). • 1% increase in real estate tax over 2020 actual collection. A triennial update was completed in Franklin County in December 2020, which increased the 2021 real estate taxes but was initiated too late in the year to be captured in the City’s 2021 Operating Budget. • Flat projection for 2022 income tax as of the date of this memo. More analysis will be done prior to preparation of the 2022 Annual Operating Budget in late summer/early fall. At that time, more information may be known regarding the HB 157 (companion to SB 97), which would repeal Section 29 of HB 197 which allows municipalities to collect income tax from jurisdictions where the employer is located rather than an employee’s work-from-home location (20 days in a row). Expenditure Assumptions: • For personal services, a historical trend level increase was projected on the 2021 budget, which is consistent with prior years. • In most cases, personal services were not projected based on the 2020 calendar year. Although the budget projections for 2020 included a 27th pay, which was anticipated to increase expenditures for the year, the COVID-19 pandemic had a significant impact on the actual 2020 payroll expenditures as those expenditures were reduced by the allocation of more than $1.7 million. • For all other expenditures, a 0-1% inflationary rate was applied across various spending categories based on 2019 actual expenditures, or 2021 budgeted expenditures as appropriate. • Although the Tax Budget projection assumes a gradual increase in revenue in 2022 in the Recreation Fund and the Hotel/Motel Tax Fund, this projection also assumes additional transfers from the General Fund will be necessary. Exhibit III is used for all funds that do not derive any revenue from the general property taxes (all Ord. 22-21 – Adopting the Proposed Tax Budget for Fiscal Year 2022 May 18, 2021 3 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 2021- 2025 Capital Improvements Program (excluding any expenses to be paid from bond issue), and the debt schedule is based on the projection for calendar year 2022. 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), a total of 1.75 mills, can be adjusted on an annual basis. As part of the 2021 – 2025 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. 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-2021 0.35 1.40 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 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. Other sources of revenue for the Parkland Acquisition Fund include a contribution from Washington Township ($50,000 annually from 2015 through 2024 in exchange for the city assuming ownership and maintenance for Kaltenbach Park), and interest income. Expenditures in the Fund consist of County Auditor’s deductions for real estate services, and the annual $750,000 allocation for capital expenditures. As of December 31, 2020, the fund balance in the Parkland Acquisition Fund was $2,391,019. In 2021, $400,000 is designated towards the acquisition of the N. Riverview Street properties (Ordinance 54-20). Income Tax The City’s largest revenue source for general operations is obtained through income taxes. In the 2021 Operating Budget, it was estimated that revenue from local income tax would be approximately $90,178,557. Per City Code, 75% or $67,633,918 is to be programmed in the General Fund, and 25% or $22,544,639 is to be programmed in the Capital Improvements Tax Fund. As City Council is aware, the COVID-19 emergency impacted many of the City’s revenues sources, including income taxes in 2021. As stated previously in this memo, as of the current date, income taxes for 2022 are being projected conservatively at a stable, flat rate. This estimate for 2022, as well as the 2021 income tax estimate will be updated in July/August. Ord. 22-21 – Adopting the Proposed Tax Budget for Fiscal Year 2022 May 18, 2021 4 General Fund Balance The City’s policy is to maintain a year-end balance equal to or greater than 50% of the General Fund expenditures including operating transfers. Based on estimated revenue and expenditures, the 2022 tax budget reflects an estimated 2021 year-end General Fund balance of $50,525,344, and $42,520,349 for 2022. That represents a percentage of General Fund expenditures and operating transfers (excluding advances), equal to 54.4% and 52.2% respectively. When looking at the projected General Fund balance, it is important to remember that these figures assume that all funds appropriated in 2021 and 2022 will be spent, which is never the case. This budgeting method is consistent with the City’s past practice of conservatively estimating both revenues and expenditures. Recommendation Staff recommends adoption of Ordinance 22-21 at the second reading/public hearing on June 14, 2021. Attachment: 2022 Tax Budget 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 00 0 POLICE/SAFETY OPERATING FUND 493,990 0 493,990 PARKLAND ACQUISITION 729,940 729,940 0 CAPITAL IMPROVEMENTS TAX FUND 2,919,810 2,919,810 0 PROPRIETARY FUNDS XXXXXXXX XXXXXXXX XXXXXXXXX XXXXXXXXX XXXXXXXX FIDUCIARY FUNDS XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX TOTAL ALL FUNDS 4,143,740 3,649,750 493,990 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 493,990 not to exceed ONGOING 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 2019 For 2020 Estimated for Estimated for DESCRIPTION Actual Actual 2021 2022 (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 70,011,955 69,182,020 67,633,918 67,633,920 Other Local Taxes 0 0 0 0 Total Local Taxes 70,011,955 69,182,020 67,633,918 67,633,920 Intergovernmental Revenues State Shared Taxes and Permits Local Government 356,917 433,119 405,262 409,315 Estate Tax 0 0 0 0 Cigarette Tax 567 604 500 505 Liquor and Beer Permits 78,189 73,352 70,000 70,700 Gasoline Tax 0 0 0 0 Library and Local Government Support Fund 00 0 0 Property Tax Allocation 0 0 0 0 Other Permits 7,844 11,950 10,000 10,100 Total State Shared Taxes and Permits 443,516 519,026 485,762 490,620 Federal Grants or Aid 40,399 (8,903) 0 0 State Grants or Aid 0 0 0 0 Other Grants or Aid 870 20,000 0 0 Total Intergovernmental Revenues 484,785 530,123 485,762 490,620 Special Assessments 0 0 0 0 Charges for Services 1,034,375 748,454 907,500 916,575 Fines, Licenses, and Permits 4,128,457 3,399,580 3,172,400 3,331,020 Miscellaneous 1,747,726 5,360,300 1,288,000 1,300,880 Other Financing Sources: Proceeds from Sale of Debt 0 0 0 0 Transfers 0 0 0 0 Advances 1,385,000 15,700,000 190,000 1,270,000 Other Sources (Sale of Capital Assets) 0 0 0 0 TOTAL REVENUE 78,792,297 94,920,477 73,677,580 74,943,015 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 2019 For 2020 Estimated for Estimated for (1) Actual Actual 2021 2022 (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 219,397 225,243 293,655 248,500 Supplies and Materials 84,712 51,108 162,070 125,000 Capital Outlay 0 0 0 0 Total Security of Persons and Property 304,109 276,351 455,725 373,500 Public Health Services Personal Services 0 0 0 0 Travel Transportation 0 0 0 0 Contractual Services 454,423 478,512 525,035 522,880 Capital Outlay 0 0 0 0 Total Public Health Services 454,423 478,512 525,035 522,880 Leisure Time Activities Personal Services 5,635,934 5,567,623 5,394,110 5,501,990 Travel Transportation 0 0 0 0 Contractual Services 1,776,663 1,817,341 2,381,135 2,116,065 Supplies and Materials 420,520 401,323 486,490 486,490 Capital Outlay 15,941 12,188 19,250 19,445 Total Leisure Time Activities 7,849,058 7,798,476 8,280,986 8,123,990 Community Environment Personal Services 6,275,802 6,165,844 5,821,080 5,937,500 Travel Transportation 0 0 0 0 Contractual Services 996,922 1,162,068 2,184,565 1,573,390 Supplies and Materials 26,372 13,828 36,395 36,760 Capital Outlay 0 0 0 0 Total Community Environment 7,299,096 7,341,739 8,042,040 7,547,650 Basic Utility Services Personal Services 704,588 647,842 873,190 873,190 Travel Transportation 0 0 0 0 Contractual Services 2,793,949 2,931,310 3,978,480 3,500,500 Supplies and Materials 2,250 1,973 2,405 2,430 Capital Outlay 0 0 0 0 Total Basic Utility Services 3,500,788 3,581,125 4,854,075 4,376,120 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 2019 For 2020 Estimated for Estimated for (1) Actual Actual 2021 2022 (3) (3) (4) (5) Transportation Personal Services 0 0 1,386,380 1,414,110 Travel Transportation 0 0 0 0 Contractual Services 0 0 418,310 418,310 Supplies and Materials 0 0 160,350 160,350 Capital Outlay 0 0 0 0 Total Transportation 0 0 1,965,040 1,992,770 General Government Personal Services 12,325,839 12,422,936 14,652,450 14,940,495 Travel Transportation 0 0 0 0 Contractual Services 7,728,238 7,094,242 13,847,595 11,595,380 Supplies and Materials 3,215,501 2,562,697 4,611,260 2,588,325 Capital Outlay 1,528,100 1,496,534 1,909,960 329,060 Total General Government 24,797,677 23,576,408 35,021,265 29,453,260 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 18,715,000 23,380,000 29,825,000 25,025,000 Advances 17,300,000 1,400,000 1,536,965 1,536,965 Contingencies 75,112 30,253 155,000 155,000 Other Uses of Funds(Refunds/Incentives/Grants)6,064,116 5,391,530 3,802,845 3,840,875 Total Other Uses of Funds 42,154,228 30,201,783 35,319,810 30,557,840 TOTAL EXPENDITURES 86,359,379 73,254,395 94,463,975 82,948,010 Revenues over/(under) Expenditures (7,567,082) 21,666,083 (20,786,395) (8,004,995) Beginning Cash Fund Balance 57,212,738 49,645,656 71,311,739 50,525,344 Ending Cash Fund Balance 49,645,656 71,311,739 50,525,344 42,520,349 Estimated Encumbrances (3,961,918) (3,287,680) 0 0 Estimated Ending Unencumbered Fund Balance 45,683,738 68,024,059 50,525,344 42,520,349 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 2019 For 2020 Estimated for Estimated for (1) Actual Actual 2021 2022 (3) (3) (4) (5) REVENUE XXXXXXXX XXXXXXXX XXXXXXXXX XXXXXXXX Local Taxes - Real Estate 477,344 489,148 458,300 493,990 Intergovernmental Revenue 71,558 68,083 60,000 71,500 Charges for Services 2,678,738 4,041,641 3,797,000 4,082,055 Miscellaneous 42,737 53,909 5,000 25,000 Other Financing Sources: Transfers 12,180,000 13,380,000 13,580,000 14,000,000 Other Sources 0 0 0 0 TOTAL REVENUE 15,450,378 18,032,781 17,900,300 18,672,545 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 14,700,971 15,787,027 17,846,540 18,216,145 Travel/Transportation 0 0 0 0 Contractual Services 203,741 226,799 289,249 292,140 Supplies and Materials 285,750 229,248 327,765 290,550 Capital Outlay 33,683 14,258 24,125 24,365 Other Uses(Refunds and other misc) 3,381 1,059 6,430 6,430 TOTAL EXPENDITURES 15,227,526 16,258,392 18,494,109 18,829,630 Revenues Over (Under) Expenditures 222,852 1,774,390 (593,809) (157,085) Beginning Cash Fund Balance 671,498 894,350 2,668,739 2,074,930 Ending Cash Fund Balance 894,350 2,668,739 2,074,930 1,917,845 Estimated Encumbrances (outstanding at end of year)(172,244) (181,481) 0 0 Estimated Ending Unencumbered Fund Balance 722,106 2,487,258 2,074,930 1,917,845 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 2019 For 2020 Estimated for Estimated for (1) Actual Actual 2021 2022 (3) (3) (4) (5) REVENUE XXXXXXXX XXXXXXXX XXXXXXXXX XXXXXXXX Local Taxes* Property Tax -- Real Estate/Personal Property 2,825,040 2,890,908 2,781,500 2,919,810 Municipal Income Tax (Note 1) 23,337,321 23,060,676 22,544,639 22,544,640 Intergovernmental Revenue 571,796 403,461 3,449,000 3,483,490 Fines, Licenses, and Permits 0 0 0 0 Miscellaneous 769,613 1,073,123 5,600,000 1,073,125 Other Financing Sources: Transfers 1,657,000 5,549,495 6,750,000 750,000 Other Sources-Advances 1,722,000 2,274,937 2,732,000 2,605,000 Proceeds from Bonds 0 0 0 0 TOTAL REVENUE 30,882,771 35,252,599 43,857,139 33,376,065 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 40,353 48,094 46,500 46,965 Capital Outlay 17,530,723 21,125,972 60,785,265 24,475,000 Transfers 6,175,039 5,417,156 5,713,050 9,468,860 Advances 400,000 0 0 0 TOTAL EXPENDITURES 24,146,114 26,591,221 66,544,815 33,990,825 Revenues Over (Under) Expenditures 6,736,657 8,661,378 (22,687,676) (614,760) Beginning Cash Fund Balance 24,309,889 31,046,547 39,707,926 17,020,250 Ending Cash Fund Balance 31,046,547 39,707,926 17,020,250 16,405,490 Estimated Encumbrances (outstanding at end of year)(12,798,649) (16,610,265) 0 0 Estimated Ending Unencumbered Fund Balance 18,247,898 23,097,661 17,020,250 16,405,490 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 2019 For 2020 Estimated for Estimated for (1) Actual Actual 2021 2022 (3) (3) (4) (5) REVENUE XXXXXXXX XXXXXXXX XXXXXXXXX XXXXXXXX Local Taxes - Real Estate 706,191 722,714 693,650 729,940 Intergovernmental Revenue 129,263 130,741 126,000 127,260 Fines, Licenses, and Permits 0000 Miscellaneous 9,976 833 0 0 Other Financing Sources: Transfers 0000 Other Sources-Advances 0000 Proceeds from Bonds 0000 TOTAL REVENUE 845,430 854,288 819,650 857,200 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 9,874 12,023 11,650 11,770 Capital Outlay 85,141 0 750,000 750,000 Transfers 227,770 207,000 0 0 Advances 210,000000 TOTAL EXPENDITURES 532,785 219,023 761,650 761,770 Revenues Over (Under) Expenditures 312,645 635,265 58,000 95,431 Beginning Cash Fund Balance 1,443,109 1,755,754 2,391,019 2,449,019 Ending Cash Fund Balance 1,755,754 2,391,019 2,449,019 2,544,450 Estimated Encumbrances (outstanding at end of year)0000 Estimated Ending Unencumbered Fund Balance 1,755,754 2,391,019 2,449,019 2,544,450 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/22 Balance 12/31/22 GOVERNMENTAL: XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX SPECIAL REVENUE: XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX Street Maintenance & Repair 2,442,660 4,585,400 7,028,060 2,364,365 2,237,155 4,601,520 2,426,539 State Highway Improvement 521,390 206,100 727,490 0 214,375 214,375 513,116 Cemetery 91,825 227,500 319,325 151,550 60,195 211,745 107,580 Recreation 1,026,140 8,004,775 9,030,915 5,465,275 2,826,880 8,292,155 738,760 Swimming Pool 286,420 1,155,000 1,441,420 658,935 550,845 1,209,780 231,640 Permissive Tax 211,475 110,300 321,775 0 200,000 200,000 121,775 Hotel/Motel Tax 2,600,135 4,359,650 6,959,785 948,835 4,075,415 5,024,249 1,935,536 Enforcement and Education 65,380 2,100 67,480 2,500 0 2,500 64,980 Law Enforcement Trust 94,505 1,000 95,505 0 7,000 7,000 88,505 Mandatory Drug Fine 2,820 40 2,860 0 0 0 2,860 Mayor's Court Computer 63,710 18,500 82,210 875 18,900 19,775 62,435 Accrued Leave Reserves 91,610 501,480 593,090 474,250 0 474,250 118,840 Wireless 9-1-1 System 631,305 140,000 771,305 0 126,820 126,820 644,485 Rings Unitrust 450,000 0 450,000 0 0 0 450,000 Coronavirus Relief Fund 0 0 0 0 0 0 0 TOTAL SPECIAL REVENUE FUNDS 8,579,375 19,311,845 27,891,220 10,066,585 10,317,585 20,384,170 7,507,050 DEBT SERVICE FUNDS XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX General Debt Service 3,023,797 12,647,590 15,671,387 0 12,647,590 12,647,590 3,023,797 Economic Development Bond Retirement 3 2,340,702 2,340,705 0 2,340,705 2,340,705 0 Special Assessment Debt Service 5,020 0 5,020 0 0 0 5,020 2001 Special Assessment Debt Service 150,232 0 150,232 0 0 0 150,232 TOTAL DEBT SERVICE FUNDS 3,179,052 14,988,292 18,167,344 0 14,988,295 14,988,295 3,179,049 CAPITAL PROJECT FUNDS XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX Note: Various construction funds not included. TOTAL CAPITAL PROJECTS 00 0000 0 PERMANENT IMPROVEMENT FUNDS XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX Cemetery Perpetual Care 1,554,896 30,000 1,584,896 0 0 0 1,584,896 TOTAL PERMANENT IMPROVEMENTS FUNDS 1,554,896 30,000 1,584,896 0 0 0 1,584,896 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/22 Balance 12/31/22 PROPRIETARY: XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX ENTERPRISE FUNDS XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX Water 10,993,190 1,189,275 12,182,465 353,695 1,333,640 1,687,335 10,495,130 Sewer 4,159,380 2,888,600 7,047,980 988,555 2,897,365 3,885,921 3,162,059 TOTAL ENTERPRISE FUNDS 15,152,570 4,077,875 19,230,445 1,342,250 4,231,005 5,573,256 13,657,189 Note: Various construction funds not included. INTERNAL SERVICE FUNDS XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXX Employee Benefits Self-Insurance 2,957,860 9,520,900 12,478,760 108,945 9,412,960 9,521,905 2,956,855 Workers Compensation Self-Insurance 108,835 201,100 309,935 0 176,435 176,435 133,500 TOTAL INTERNAL SERVICE FUNDS 3,066,695 9,722,000 12,788,695 108,945 9,589,394 9,698,340 3,090,355 TRUST AND AGENCY FUNDS XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX Visit Dublin Ohio (aka DCVB) 186,510 886,300 1,072,810 0 866,300 866,300 206,510 Agency (Deposits) 509,850 2,537,400 3,047,250 0 2,897,100 2,897,100 150,150 COIRS 714,710 332,100 1,046,810 0 342,300 342,300 704,510 Econ Dev - PACE 0 1,470,955 1,470,955 0 1,470,955 1,470,955 0 TOTAL TRUST AND AGENCY FUNDS 1,411,070 5,226,755 6,637,825 0 5,576,655 5,576,655 1,061,170 TOTAL FOR MEMORANDUM ONLY 31,388,760 53,326,767 84,715,532 11,517,780 44,702,933 56,220,718 28,494,815 EXHIBIT IV (pg 1 of 2) Estimated Cost DESCRIPTION of Permanent Name of Paying Fund Improvement CIP - Administration Administration (land acquisition, contingencies, sewer ext.) Municipal Facilities 4,905,000 1,010,000 Capital Improvements Tax Fund Computer Hardware/Software 8,235,000 1,885,000 Capital Improvements Tax Fund CIP - Parks & Recreation Parks 14,950,000 2,775,000 Capital Improvements Tax Fund CIP - Safety Police 785,000 215,000 Capital Improvements Tax Fund CIP - Stormwater System Stormwater Improvements 4,675,000 975,000 Capital Improvements Tax Fund CIP - Transportation Bicycles and Pedestrians 8,145,000 2,115,000 Capital Improvements Tax Fund Bridges and Culverts 9,175,000 2,570,000 Capital Improvements Tax Fund and Capital Construction Fund Streets and Parking 99,770,000 27,627,500 Capital Improvements Tax Fund and Capital Construction Fund SUB-TOTAL 168,090,000 42,612,500 CIP - Sanitary Sewer System Sewer Improvements 14,055,000 550,000 Sewer Fund CIP - Water Distribution System Water Improvements 2,330,000 475,000 Water Fund SUB-TOTAL 16,385,000 1,025,000 TOTAL 184,475,000 43,637,500 Fleet Management 5,640,000 1,140,000 Capital Improvements Tax Fund and Water & Sewer, Hotel/Motel Total Project Cost 2021-2025 CIP (May Include Other Funding Sources including TIFs) 2021 Projects 11,810,000 2,300,000 Capital Improvements Construction & 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 EXHIBIT IV (pg 2 of 2)