The URL can be used to link to this page

Home My WebLink AboutOrdinance 014-20RECORD OF ORDINANCES BARRETT BROTHERS - DAYTON, OHIO Ordinance No. 14-20 AN ORDINANCE ADOPTING THE PROPOSED TAX BUDGET FOR FISCAL YEAR 2021 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 WHERI=AS, 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 2021 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. Passed thisr— day of . tx , 20.2-o mayor - Nresiaing Utticer ATTEST: Cl Office of the City Manager ubn, OH 43017-1 Icityof Dublin Phone: 614.410---4r400. 5555 Perimter DiveDax:i614410-4490090 Memo To: Members of Dublin City Council From: Dana L. McDaniel, City Manager Date: May 19, 2020 Initiated By: Matthew L. Stiffler, Director of Finance Melody Kennedy, Budget Manager Re: Ordinance 14-20 —Adopting the Proposed Tax Budget for Fiscal Year 2021 Summary In compliance with the Ohio Revised Code (ORC) Section 5705.28, submitted for your approval is the proposed tax budget for the 2021 fiscal year (calendar basis). The Ohio Revised Code mandates adoption of the tax budget by a political subdivision (taxing authority) no later than July 15' 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. This submission covers the financial completion of calendar years 2018 and 2019, a budget forecast for calendar year 2020 and the projection for calendar year 2021. This 2021 projection is based on the estimated revenue and expenditure figures previously used to calculate the 2020 Operating Budget and 2020-2024 Capital Improvements Program. As you know, an updated revenue estimate for 2020 and projection for 2021 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 2021 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 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: Ord. 14-20 — Adopting the Proposed Tax Budget for Fiscal Year 2021 May 19, 2020 (1) Description of the revenue or expenditure type. (2) Actual revenue and expenditure figures for calendar year 2018. (3) Actual revenue and expenditure figures for calendar year 2019. (4) This column represents the current year's information. It includes 2020 budgeted revenue and expenditures which are based on appropriations approved by City Council (including carry-over 2019 encumbrances), plus supplemental appropriations and increases/decreases in estimated resources actually budgeted through April 2020 or information received from the Franklin County Auditor updating real estate tax collection estimates. (5) This column represents the upcoming year. It includes 2020 estimated revenue and expenditures which are based on previously projected budget figures for the 2021 calendar year. For the income tax projection, the amount remains consistent with the City's 2020 estimate. As Council is aware, a revised estimate for 2020 and future projection for 2021 will not be available until July/August. The revenue estimate previously used for the 2020 Operating Budget and the 2020-2024 Capital Improvements Program included a 1% increase in 2021 from the amount budgeted in 2020. To estimate expenditures an inflationary measure of 0 to 2% was applied across various spending categories. Projected personnel costs were estimated flat because of the 271 pay period in 2020 not recurring in 2021. 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 Capital Improvements Plan as well as the City's debt schedule. The Capital Improvements projection is reflected in the City's approved 2020-2024 Capital Improvements Program (excluding any expenses to be paid from bond issue), and the debt schedule is based on the projection for calendar year 2020. Property Tax Distribution The Police / Safety Operating 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 2020 — 2024 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 Parkland Service Fund 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-2020 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 Ord. 14-20 — Adopting the Proposed Tax Budget for Fiscal Year 2021 May 19, 2020 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. Currently, the only annual expenditure made from the Parkland Acquisition Fund is for payment of the debt service for the Coffman Park expansion. That debt is scheduled to retire in 2020. As of December 31, 2019, the fund balance in the Parkland Acquisition Fund was $1,755,754.78. Income Tax The City's largest revenue source for general operations is obtained through income taxes. In the 2020 Operating Budget, it was estimated that revenue from local income tax would be approximately $89,285,700. Per City Code, 75% or $66,964,275 is to be programmed in the General Fund, and 25% or $22,312,425 is to be programmed in the Capital Improvements Tax Fund. As Council is aware, the COVID19 emergency is having a significant impact on all City revenues sources, including income taxes. This tax budget uses the previously estimated 1% increase for 2021 income taxes from the 2020 estimate. This estimate along with the 2020 estimate will be updated in July/August. 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 2021 tax budget reflects an estimated 2020 year-end General Fund balance of $51,823,287 and $41,237,098 for 2021 which, as a percentage of General Fund expenditures and operating transfers (excluding advances), equals 58.1% and 50.0% respectively. When looking at the projected General Fund balance, it is important to remember that these figures assume that all funds appropriated in 2019 and 2020 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 passage of Ordinance 14-20 at the second reading/public hearing on June 8, 2020. Attachment: 2021 Tax Budget Fan all Akira: artlwnq all recent uu Ruagw must be aoi Per they legislative body cRrymmge Caunat Twmnl> Tullm, of other Beers) on ar More Juty 15th aW nes ogles all M oubnaryen A the Coal Al an or Mlm July Mr. FAILURE TO COMPLY WITH SECTION SM.R& ONO. 9WLLL RESULT IN GOES OF LOCAL CAVEBNMENT FUND SCHEDULE SUMMARY Of AMOUNTS REQUIRED FROM GENERAL PROPERTY TA%APPROVED BY BUDGET COMMISSION, AND COUNTY AUDITOR'S ESTIMATED RATES For Municipal Use For Budder Commission Use For County Auditor Use FUND (Include only Nose funds which are requesting general o eN tax revenue Budget Year Amount RequeNedof Budget Commission Inside Outside Budget Year Amount Appel by Budge Commisso Inside 10 MIII Limitation BudgetYear Amount for Denvetl Freer Levies Outside 10 MIII GmiNtion County Auditors estimate Tax Rate to be Levied Insitle10 Mill Outside 10 MIII LimBudget Limit Budget year Year Columnl Column 2 Column 3 Column 4 Column 5 OOVERNMENTFUNDS XXXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX GENERALFUND s s s PODCESAFETY OPERATING FUND 48$335 0 462,335 PARKLAND ACoulslnoN 700,000 ]00,000 s CAPITAL IMPROVEMENTS TAX FUND $309,315 2,309,315 0 PROPRIETARY FUNDS XXXXXXXX XXXXXXXX XXXXXXXXX XXXXXXXXX XXXXXXXX FIDUCIARYFUNDs xxxxxxxx xxxxxxxx XXXXXXXX XXXXXXXX XXXXXXXX TOTAL ALLFUNDs 3,x]2299 3509315 452335 SCHEDULE B LEVIES OUTSIDE 10 MILL LIMITATION, EXCLUSIVE FUND OF DEBT Maximum Rate Authorized to be Levied LEVIES Tax Year County Auditor's Estimate of Yield of Levy (Carry to Schedule A, Column 3) GENERALFUND: Current Expense Levy authorized by voters on not exceed years. Authorized under Sect. R.C. Current Expense Levy authorized by voters on / / not exceed years. Authorized under Section. R.C. Current Expense Levy authorized by voters on / / not exceed years. Authorized under Section. R.C. Current Expense Levy authorized by voters on / / not exceed years. Authorized under Section. R.C. Current Expense Levy authorized by voters on / / not exceed years. Authorized under Section. R.C. not exceed years. Authorized under Section. R.C. Current Expense Levy authorized by voters on / / not exceed years. Authorized under Section. R.C. TOTAL GENERAL FUND OUTSIDE 10 MILL LIMITATION SPECIAL LEVY FUNDS POLICE/SAFETY FUND, Levy authorized by voters on 11/1981 1.2 not to exceed ONGOING years. Authorized under Section R.C. FUND, Levy authorized by voters on / /11 not to exceed years. Authorized under Section R.C. FUND, Levy authorized by voters on / /11 not to exceed years. Authorized under Section R.C. FUND, Levy authorized by voters on / /11 not to exceed years. Authorized under Section R.C. FUND, Levy authorized by voters on / /11 not to exceed years. Authorized under Section R.C. FUND NAME: GENERAL FUND EXHIBIT I FUND TYPE/CLASSIFICATION: GOVERNMENTAL --GENERAL This Exhibit is to be used for the General Fund Only DESCRIPTION (1) For 2018 Actual (2) ❑❑ For 2019 Actual (3) Current Year Estimated for 2020 (4) Budget Year Estimated for 2021 (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 66,090,159 70,011,955 66,964,275 67,633,915 Other Local Taxes 0 0 0 0 Total Local Taxes 66,090,159 70,011,955 66,964,275 67,633,915 Intergovernmental Revenues State Shared Taxes and Permits Local Government 232,870 356,917 458,638 400,000 Estate Tax 0 0 0 0 Cigarette Tax 522 567 500 500 Liquor and Beer Permits 75,177 78,189 70,000 70,700 Gasoline Tax 0 0 0 0 Library and Local Government Sup port Fund 0 0 0 0 Property Tax Allocation 0 0 0 0 Other Permits 8,756 7,844 10,000 10,000 Total State Shared Taxes and Permits 317,326 443,516 539,138 481,200 Federal Grants or Aid 47,897 40,399 0 0 State Grants or Aid 0 0 0 0 Other Grants or Aid 0 870 0 0 Total Intergovernmental Revenues 365,223 484,785 539,138 481,200 Special Assessments 0 0 0 0 Charges for Services 1,187,527 1,034,375 1,082,500 1,093,325 Fines, Licenses, and Permits 4,283,694 4,128,457 3,324,400 3,357,645 Miscellaneous 1,547,783 1,747,726 1,503,000 1,518,030 Other Financing Sources: Proceeds from Sale of Debt 0 0 0 0 Transfers 0 0 500,000 0 Advances 21,023,902 1,385,000 15,700,000 440,000 Other Sources (Sale of Capital Assets) 0 0 3,200,000 0 TOTAL REVENUE 94,498,288 78,792,297 92,813,313 74,524,115 FUND NAME: GENERAL FUND FUND TYPE/CLASSIFICATION: GOVERNMENTAL --GENERAL This Exhibit is to be used for the General Fund Only EXHIBITI DESCRIPTION (1) For 2018 Actual i2) ❑❑ For 2019 Actual G Current Year Estimated for 2020 (4) Budget Year Estimated for 2021 (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 199,950 219,397 284,446 287,290 Supplies and Materials 39,621 84,712 162,274 163,895 Capital Outlay 0 0 0 0 Total Security of Persons and Property 239,571 304,109 446,720 451,185 Public Health Services Personal Services 0 0 0 0 Travel Transportation 0 0 0 0 Contractual Services 428,732 454,423 482,606 487,430 Capital Outlay 0 0 0 0 Total Public Health Services 428,732 454,423 482,606 487,430 Leisure Time Activities Personal Services 5,697,667 5,635,934 6,307,119 6,307,119 Travel Transportation 0 0 0 0 Contractual Services 1,425,909 1,776,663 2,796,087 2,852,010 Supplies and Materials 388,023 420,520 519,375 524,570 Capital Outlay 6,562 15,941 19,250 19,445 Total Leisure Time Activities 7,518,160 7,849,058 9,641,831 9,703,143 Community Environment Personal Services 6,265,650 6,275,802 7,213,583 7,213,583 Travel Transportation 0 0 0 0 Contractual Services 1,198,426 996,922 2,615,177 2,615,175 Supplies and Materials 39,278 26,372 44,475 44,920 Capital Outlay 1 0 0 0 0 Total Community Environment 7,503,354 7,299,096 9,873,236 9,873,679 Basic Utility Services Personal Services 680,832 704,588 783,380 783,380 Travel Transportation 0 0 0 0 Contractual Services 2,586,269 2,793,949 3,132,557 3,163,880 Supplies and Materials 424 2,250 2,412 2,435 Capital Outlay 0 0 0 0 Total Basic Utility Services 3,267,526 3,500,788 3,918,349 3,918,350 FUND NAME: GENERAL FUND FUND TYPE/CLASSIFICATION: GOVERNMENTAL --GENERAL This Exhibit is to be used for the General Fund Only EXHIBIT I DESCRIPTION (1) For 2018 Actual (2) �� For 2019 Actual (3) Current Year Estimated for 2020 (4) Budget Year Estimated for 2021 (5) Transportation Personal Services 0 0 0 0 Travel Transportation 0 0 0 0 Contractual Services 0 0 0 0 Supplies and Materials 0 0 0 0 Capital Outlay 0 0 0 0 Total Transportation 0 0 0 0 General Government Personal Services 12,150,158 12,325,839 14,537,220 14,537,220 Travel Transportation 0 0 0 0 Contractual Services 6,740,310 7,728,238 10,359,983 10,463,580 Supplies and Materials 3,842,678 3,215,501 4,444,585 4,489,030 Capital Outlay 6,489,713 1,528,100 1,612,217 593,000 Total General Government 29,222,859 24,797,677 30,954,005 30,082,831 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 23,193,050 18,715,000 26,885,250 20,850,000 Advances 20,605,000 17,300,000 1,400,000 2,710,000 Contingencies 51,298 75,112 148,960 148,960 Other Uses of Funds(Refunds/Incentives/Grants) 5,381,538 6,064,116 6,884,727 6,884,725 Total Other Uses of Funds 49,230,886 42,154,228 35,318,937 30,593,685 TOTAL EXPENDITURES 97,411,088 86,359,379 90,635,683 85,110,303 Revenues over/(under) Expenditures (2,912,800) (7,567,082) 2,177,630 (10,586,189) Beginning Cash Fund Balance 60,125,538 57,212,738 49,645,657 51,823,287 Ending Cash Fund Balance 57,212,738 49,645,657 51,823,287 41,237,098 Estimated Encumbrances (4,076,544) (3,961,918) 0 0 Estimated Ending Unencumbered Fund Balance 53,136,195 45,683,739 51,823,287 41,237,098 FUND NAME: SAFETY/POLICE OPERATING EXHIBITII FUND TYPE/CLASSIFICATION: SPECIAL REVENUE To be used for any fund receiving property tax revenue except the General Fund. DESCRIPTION (1) For 2018 Actual (2) �� For 2019 Actual (3) Current Year Estimated for 2020 (4) Budget Year Estimated for 2021 (5) REVENUE XXXXXXXX XXXXXXXX XXXXXXXXX XXXXXXXX Local Taxes- Real Estate 473,680 477,344 458,300 462,885 Intergovernmental Revenue 84,428 71,558 64,000 71,500 Charges for Services 2,822,108 2,678,738 3,768,912 3,844,290 Miscellaneous 57,976 42,737 5,000 25,000 Other Financing Sources: Transfers 11,830,000 12,180, 000 13,580, 000 14,000,000 Other Sources 0 0 0 0 s TOTAL REVENUE 15,268,193 15,450,378 17,876,212 18,403,675 EXPENDITURES (Identify each program and object code at the same level shown on (PROGRAM) (OBJECT) XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX Security of Persons and Property Personal Services 14,686,220 14,700,971 17,631,322 17,631,322 Travel/Transportation 0 0 0 0 Contractual Services 177,479 203,741 272,312 275,035 Supplies and Materials 245,261 285,750 329,030 353,500 Capital Outlay 47,940 33,683 34,300 34,645 Other Uses(Refunds and other misc) 5,382 3,381 24,500 24,500 TOTAL EXPENDITURES 15,162,282 15,227,526 18,291,464 18,319,002 Revenues Over (Under) Expenditures 105,910 222,852 (415,252) 84,673 Beginning Cash Fund Balance 565,588 671,498 894,350 479,098 Ending Cash Fund Balance 671,498 894,350 479,098 563,771 Estimated Encumbrances (outstanding at end of year) (220,247) (172,244) 0 0 Estimated Ending Unencumbered Fund Balance 451,252 722,106 479,098 563,771 EXHIBITII FUND TYPE/CLASSIFICATION: CAPITAL PROJECTS To be used for any fund receiving property tax revenue except the General Fund. DESCRIPTION (1) For 2018 Actual �Eal (2) FoEstimated A Current Year for 2020 (4) Budget Year Estimated for 2021 (5) REVENUE XXXXXXXX XXXXXXXX XXXXXXXXX XXXXXXXX Local Taxes* Property Tax -- Real Estate/Personal Property 2,833,250 2,825,040 2,781,500 2,809,315 Municipal Income Tax (Note 1) 22,030,056 23,337,321 22,321,425 22,544,640 Intergovernmental Revenue 311,097 571,796 299,000 301,990 Fines, Licenses, and Permits 0 0 0 0 Miscellaneous 719,288 769,613 2,925,000 769,615 Other Financing Sources: Transfers 5,938,050 1,657,000 7,600,250 0 Other Sources -Advances 2,653,500 1,722,000 2,294,937 1,830,000 Proceeds from Bonds 0 0 0 0 TOTAL REVENUE 34,485,240 30,882,771 38,222,112 28,255,561 EXPENDITURES (Identify each program and object code at the same level shown on (PROGRAM) (OBJECT) XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX Contractual Services 44,778 40,353 46,000 46,460 Capital Outlay 24,161,291 17,530,723 59,101,174 17,980,000 Transfers 5,443,454 6,175,039 7,507,635 9,468,860 Advances 2,055,200 400,000 350,000 0 TOTAL EXPENDITURES 31,704,723 24,146,114 67,004,809 27,495,320 Revenues Over (Under) Expenditures 2,780,517 6,736,657 (28,782,697) 760,241 Beginning Cash Fund Balance 21,529,371 24,309,889 31,046,547 2,263,850 Ending Cash Fund Balance 24,309,889 31,046,547 2,263,850 3,024,091 Estimated Encumbrances (outstanding at end ofyear) (9,550,291) (12,798,649) 0 0 Estimated Ending Unencumbered Fund Balance 14,759,598 18,247,898 2,263,850 3,024,091 FUND NAME: PARKLAND ACQUISITION EXHIBIT II FUND TYPE/CLASSIFICATION: CAPITAL PROJECT To be used for any fund receiving property tax revenue except the General Fund. DESCRIPTION (1) For 2018 Actual (2) �� For 2019 Actual (3) Current Year Estimated for 2020 (4) Budget Year Estimated for 2021 (5) REVENUE XXXXXXXX XXXXXXXX XXXXXXXXX XXXXXXXX Local Taxes- Real Estate 708,243 706,191 693,650 700,000 Intergovernmental Revenue 127,766 129,263 126,000 127,260 Fines, Licenses, and Permits 0 0 0 0 Miscellaneous 9,536 9,976 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 845,545 845,430 819,650 827,260 EXPENDITURES (Identify each program and object code at the same level shown on (PROGRAM) (OBJECT) XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX Contractual Services 11,197 9,874 11,150 11,262 Capital Outlay 0 85,141 750,000 750,000 Transfers 239,540 227,770 207,000 0 Advances 350,000 210,000 0 0 TOTAL EXPENDITURES 600,737 532,785 968,150 761,262 Revenues Over (Under) Expenditures 244,809 312,645 (148,500) 65,999 Beginning Cash Fund Balance 1,198,300 1,443,109 1,755,754 1,607,254 Ending Cash Fund Balance 1,443,109 1,755,754 1,607,254 1,673,253 Estimated Encumbrances (outstanding at end of year) (320,000) 0 0 0 Estimated Ending Unencumbered Fund Balance 1,123,109 1,755,754 1,607,254 1,673,253 List of All Funds Individually Unless Reported on Exhibits I and II EXHIBIT III (pg 1 of 2) p FUND List All Funds Individually Unless Reported on Exhibit I or II Estimated Unencumbered Fund Balance 01/01/21 Budget Ypear Estimated Receipt Total Availabl For Ex enditures Budget Year Expenditures and Encumbrances Personal Services Other Total Estimated Unencumbered Balance 12/31/21 GOVERNMENTAL: SPECIAL REVENUE: XXXXXXXX XXXXXXXX XXXXX M XXXXXXXX XXXXXXxx XXXXXXXX xxxxxxxx XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXX)OC XXXXXXXX XXXXXXXX Street Maintenance & Repair 106,110 4,790,000 4,896,110 2,619,790 1,504,945 4,124,735 771,375 State Highway Improvement 487,223 206,100 693,323 0 111,100 111,100 582,223 Cemetery 55,374 227,500 282,874 156,660 30,000 186,660 96,214 Recreation 719,009 7,900,400 8,619,409 5,159,240 2,809,110 7,968,350 651,059 Swimming Pool 240,587 973,295 1,213,882 597,260 365,360 962,620 251,262 Permissive Tax 202,144 121,200 323,344 0 100,000 100,000 223,344 Hotel/Motel Tax 3,505,969 4,511,530 8,017,499 883,395 3,951,035 4,834,430 3,183,069 Enforcement and Education 59,126 1,010 60,136 2,470 0 2,470 57,666 Law Enforcement Trust 89,269 705 89,974 0 7,000 7,000 82,974 Mandatory Drug Fine 2,758 40 2,798 0 0 0 2,798 Mayor's Court Computer 48,816 18,685 67,501 0 14,250 14,250 53,251 Accrued Leave Reserves 176,296 318,000 494,296 300,000 0 300,000 194,296 Wireless 9-1-1 System 527,677 141,400 669,077 0 126,820 126,820 542,257 Rings Unitrust 300,000 150,000 450,000 0 0 0 450,000 TOTAL SPECIAL REVENUE FUNDS 6,520,358 19,359,865 1 25,880,223 19,718,815 1 9,019,620 118,738,436 7,141,789 DEBT SERVICE FUNDS XXXXXXXX XXXXX M XXXXXXxx XXXXXXXY XXXXXXXX XXXXXX)OC XXXXXXXX General Debt Service 4,554,953 15,750,790 20,305,743 0 15,700,790 15,700,790 4,604,953 Economic Development Bond Retirement 3 2,069,655 2,069,658 0 2,069,655 2,069,655 3 Special Assessment Debt Service 5,019 0 5,019 0 0 0 5,019 2001 Special Assessment Debt Service 132,069 110,000 242,069 0 83,743 83,743 158,326 TOTAL DEBT SERVICE FUNDS 4,692,044 17,930,445 22,622,489 0 17,854,188 17,854,188 4,768,301 CAPITAL PROJECT FUNDS XXXXXXXX XXXXXX)OC XXXXXXJOC XXXXXX)CX XXXXXX)CX XXXXXX)CX Note: Various construction funds not mcluded. TOTAL CAPITAL PROJECTS 0 0 0 0 0 0 0 PERMANENT IMPROVEMENT FUNDS XXXXXXXX XXXXXX)OC XXXXXX)OC XXXXXXJOC XXXXXXJOC XXXXXXJOC Cemetery Perpetual Care 1,506,904 30,000 1,536,904 0 0 0 1,536,904 TOTAL PERMANENT IMPROVEMENTS FUNDS 1,506,904 3Q,000 1,536,904 0 0 0 1,536,904 List of All Funds Individually Unless Reported on Exhibits I and II EXHIBITIII (pg 2 of 2) p FUND List All Funds Individually Unless Reported on Exhibit I or II Estimated Unencumbere Fund Balance 01/01/21 Budget Year Estima ReceEx otapl Availabl For enditures Budget Year Expenditures and Encumbrances Personal Services Other Tota=Balance PROPRIETARY: ENTERPRISE FUNDS XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX Water 10,184,801 1,477,125 11,661,926 311,620 2,668,770 2,980,390 8,681,536 Sewer 3,900,506 2,535,100 6,435,606 956,180 2,860,635 3,816,815 2,618,791 Merchandising 0 0 0 0 0 0 0 TOTAL ENTERPRISE FUNDS 14,085,307 4,012,225 18,097,532 1,267,800 5,529,405 6,797,205 11,300,327 Note: Various construction funds not included.. INTERNAL SERVICE FUNDS XXXXXXXX XXXXXX)OC XXXXXX)OC XXXXXXJOC XXXXXX)OC XXXXXX)OC XXXXX)OC Employee Benefits Self -Insurance 2,988,929 8,860,020 11,848,949 99,715 8,568,225 8,667,941 3,181,008 Workers Compensation Self -Insurance 69,460 102,010 171,470 0 150,000 150,000 21,470 TOTAL INTERNAL SERVICE FUNDS 3,058,389 8,962,030 12,020,419 99,715 8,718,225 8,817,941 3,202,478 TRUST AND AGENCY FUNDS XXXXXXXX XXXXXXXX XXXXXXXX XXXXXM XXXXXXXX XXXXXXXX XXXXXXXX Dublin Convention & Visitors Bureau 225,017 1,307,950 1,532,967 0 1,300,000 1,300,000 232,967 Agency (Deposits) 509,851 1,319,200 1,829,051 0 1,317,350 1,317,350 511,701 COIRS 390,211 327,600 717,811 0 320,675 320,675 397,136 EconDev - PACE 0 254,745 254,745 0 254,745 254,745 0 TOTAL TRUST AND AGENCY FUNDS J, 1,125,079 3,209,495 4,334,574 0 3,192,770 3,192,770 1,141,804 000000 TOTAL FOR MEMORANDUM ONLY:]29,481,177 53,474,060 82,955,238 11,086,329 44,314,210 55,400,540 27,554,699 STATEMENT OF PERMANENT IMPROVEMENTS EXHIBIT IV (Do Not Include Expense to be Paid from Bond Issue) (pg 1 of 2) (Section 5705.29. Revised Code) DESCRIPTION Estimated Cost of Permanent Improvement Amount to be Budgeted During Current Year Name of Paying Fund Total Project Cost 2020-2024 CIP (May Include Other Funding Sources including Tips) 2021 Projects CIP -Administration Administration (land acquisition, 10,170,000 2,000,000 Capital Improvements Construction & Parkland Acquisition Fund contingencies, sewer ext.) Municipal Facilities 6,660,000 1,185,000 Capital Improvements Tax Fund Computer Hardware/Software 8,410,000 1,765,000 Capital Improvements Tax Fund Fleet Management 6,030,000 11185,000 Capital Improvements Tax Fund and Water & Sewer, Hotel/Motel CIP - Parks & Recreation Parks 20,735,000 1,290,000 Capital Improvements Tax Fund CIP - Safety Police 2,290,000 970,000 Capital Improvements Tax Fund CIP - Stormwater System Stormwater Improvements 5,565,000 925,000 Capital Improvements Tax Fund CIP - Transpiration Bicycles and Pedestrians 5,845,000 2,000,000 Capital Improvements Tax Fund Bridges and Culverts 6,890,000 1,770,000 Capital Improvements Tax Fund and Capital Construction Fund Streets and Parking 122,940,000 44,085,000 Capital Improvements Tax Fund and Capital Construction Fund SUB -TOTAL 195,535,000 57,175,000 CIP - Sanitary Sewer System Sewer Improvements 12,975,000 305,000 Sewer Fund CIP -Water Distribution System Water Improvements 2,910,000 745,000 Water Fund SUB -TOTAL 15,885,000 1,050,000 TOTAL 211,420,000 58,225,000 EXHIBIT IV (Pg 2 of 2) DEBT SERVICE SCREDOLE Reflects Debt as of 12/31/2021 Date 2021 Of original 0/5 Principal Interest 1®p Amount Principal Payment Payment Unvabed Bonds (G.O.) Sowce (1) Service Center Income Tax Revenue 12/1/01 3,675,000 173,991 173,991 5,872 (1) Mimicipal Pool South (OMB) Oonme Tax Revenue 4/14104 2,986,000 928,000 171,000 42,032 (1) LED Street Ughts Income Tax Revenue 1012112 2,185,000 510,000 250,000 13,775 (2) Dubin Road Water Tower Waw Fund 10/2112 2,360,000 1,575,000 110,000 48,563 (3) Sewer Lining & Repairs Sewer Fund 1012112 2,540,000 1,695,000 120,000 52,200 (4) Emerald Parkway Phase 8 Emerald 8 TIF 12/17/13 5,420,000 4,990,000 315,000 166,275 Bridge Street TIF/Riven' Ridge (4) Bridge Street- Land Acquisition TIF/Mcl(itrick 12/17/13 4,435,000 4,060,000 255,000 135,300 (4) Industrial Pkwy/SR 1610nprovements Perimeter WestTIF 117114 8,210,000 4,995,000 495,000 166,119 (2) Danee Fields Water Tower Water Fund 117/14 1,710,000 1,040,000 100,000 34,600 (3) Sanitary Sewer lining Sewer Fund 1/7/14 1,880,000 1,150,000 110,000 38,263 (4) Emerald Parkway Phase 8 Emerald 6 TIF 1/7114 1,580,000 - - - Bridge Sheet TIF/River Ridge (4) &idge Street- Land Acquisition TIF/McKitrick 1/7/14 1,265,000 - - - (4) 270/33 We change (Design, ROW) RuscjllyUppet Meh'o TIF 1/7114 9,000,000 2,905,000 945,000 92,375 (8) Dubin Road/Glick Road Improvements (OPWC) State Highway 7/1114 250,000 137,500 25,000 - (1) Justice Center Improvanents Income Tax Revenue 9130/15 10,60D,000 8,680,000 425,000 356,994 (3) Sewer Lining & Repairs Sewer Fund 9130115 2,500,000 2,045,000 100,000 84,169 (4) BSD Transportation (Riverside Dr/161/Park) Various 9130/15 25,000,000 20,475,000 1,000,000 842,125 (4) BSD Transportation (Bridge Park) Bridge Park TIF 9/30115 11,100,000 9,365,000 460,000 385,081 (1) BSD Parking Structures (Tax -Exempt) Bridge Park TIF 10/28/15 16,000,000 16,000,000 - 718,231 (1) BSD Parking Structw'es (Taxable) &'idge Pat'k TIF 10/28/15 16,000,000 14,275,000 765,000 586,425 Pimdb, Dublin Meth, Upper (4) 270/33 DO -change (Construction)(SIB) Me4'o 2110/15 10,010,000 6,579,247 368,268 651,089 (4) BSD Transportation (John Shiekls Parkway In Bridge Street TIFs 12/6116 9,325,000 7,890,000 385,000 245,300 (1) Service Center' Renovation/Expansion Income Tax Revenue 812117 3,300,000 2,940,000 130,000 115,300 (3) Sever Lining & Repairs/Extensions Sewer Fund 8/2117 1,380,000 1,230,000 55,000 48,300 (1) Pedestrian Bridge/N. High Sheet Income Tax Revenue 812/17 27,200,000 24,250,000 1,065,000 951,350 (1) CML/City Parking Garage Income Tax Revenue 12/18/18 15,60D,000 14,535,OOO 555,000 665,281 (1) CML/City Paking Garage Income Tax Revenue 12/18/18 4,000,000 3,730,000 140,000 158,988 (1) Riverside Crossing Park Income Tax Revenue 12/18/18 1,750,000 1,630,000 60,000 74,619 (3) Sewer Lining & Repaus/Extensions Sewer Fund 12/18/18 1,350,000 1,260,000 50,000 57,638 (3) Serer Lining & Repans/Ex Sever' Fund 412120 6,000,000 6,000,000 225,000 180,000 (1) Riverside Q ossng Park/North Swimming Pool Income Tax Revenue 412120 20,000,000 20,000,000 745,000 600,000 185,043,738 9,598,259 7,516,262 Unvoted Special Assessment Bonds (7) Ballanhae (2001) Special Assessment 12/1101 1,700,000 81,009 81,009 2,734 81,009 81,009 2,734 Voted Bonds (G.O.) (4) Woemar-Tempie Road Woemer Temple TIF 1211100 5,555,000 - - - (1) Emer'akl Parkway Overpass - Phase 7 Income Tax Revenue 12/1/00 6,565,000 - - - (5) Coffman Park Expansion Property Tax Revenue 12/1/00 3,135,000 Total Debt Payment;