Ordinance 14-23RECORD OF ORDINANCES
Dayton Legal Blank, Inc. Form No. 30043
Ordinance No. 14-23 Passed _, 20
AN ORDINANCE ADOPTING THE PROPOSED TAX BUDGET FOR
FISCAL YEAR 2024
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 2024 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 this [L" day of « Nis _, 2023.
Yue Sil
Mayor — Présiding Officer
ATTEST: Crud My Clerk/pf Coufcil J
To: Members of Dublin City Council
From: Megan O’Callaghan, City Manager
Date: May 16, 2023
Initiated By: Matthew L. Stiffler, Chief Financial Officer/Director of Finance
Jaime Hoffman, Director of Financial Operations
Meghan Murray, Budget Manager
Re: Ordinance 14-23 – Adopting the Proposed Tax Budget for Fiscal
Year 2024
Summary
In compliance with the Ohio Revised Code (ORC) Section 5705.28, submitted for your approval is
the proposed tax budget for the 2024 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 2021 and 2022, a
budget forecast for calendar year 2023, and the projection for calendar year 2024. This 2024
projection is usually based on the estimated revenue and expenditure figures previously used to
calculate the 2023 Operating Budget and 2023-2027 Capital Improvements Program (CIP). As you
know, the City’s updated revenue estimate for 2023, and revenue projection for 2024 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 2024 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
Ord. 14-23 – Adopting the Proposed Tax Budget for Fiscal Year 2024
May 13, 2023
2
(1) Description of the revenue or expenditure type.
(2) Actual revenue and expenditure figures for calendar year 2021.
(3) Actual revenue and expenditure figures for calendar year 2022.
(4) This column represents the current year’s information. It includes 2023 revised budgeted
revenue and expenditures which are based on appropriations approved by City Council (including
carry-over 2022 encumbrances), plus Q1 supplemental appropriations and increases/decreases in
estimated resources actually budgeted through April 2023, and/or information received from the
Franklin County Auditor updating real estate tax collection estimates.
(5) This column represents the upcoming year 2024. 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 2024 are estimated at $100,000,000 consistent with prior year
actual receipts. More analysis of income tax trends will be done prior to preparation of the
2024 Annual Operating Budget in late summer/early fall. At that time, additional information
may be known regarding the income tax impacts of work-from-home.
• A triennial real estate tax update was completed in Franklin County in December 2020,
which increased the 2021 property tax collections. Actual 2021 property tax collections were
used as the basis for the 2024 revenue projection.
• Revenue (in most cases) was increased by 3% following inflationary rate estimates in the
City’s 2024 Tax Budget projection. 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 4% merit increase was projected on the 2023 budget, which is
consistent with prior years and union contracts.
• Each expenditure line item for 2024 was analyzed separately, and non-recurring
expenditures from 2022 actual data were not programmed into the 2024 projections.
• As of March 2023, the inflationary rate is 5.6%. However, for purposes of this Tax Budget, a
3% inflationary rate (in most cases) was applied across various spending categories based
on 2022 actual expenditures, or 2023 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
2024 at this time. More in-depth review and data analysis will be completed prior to the
preparation of the 2024-2028 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 2024.
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).
Ord. 14-23 – Adopting the Proposed Tax Budget for Fiscal Year 2024
May 13, 2023
3
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 2023-
2027 Capital Improvements Program (excluding any expenses to be paid from bond issue), and the
debt schedule is based on the projection for calendar year 2023.
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 2023 – 2027 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, 2022, the fund balance in the Parkland Acquisition
Fund was $3,845,081.68.
Income Tax
The City’s largest revenue source for general operations is obtained through income taxes. In the
2023 Operating Budget, it was estimated that revenue from local income tax would be
approximately $94,000,000. Per City Code, 75% or $70,500,000 is programmed in the General
Fund, and 25% or $23,500,000 is programmed in the Capital Improvements Tax Fund. As stated
previously in this memo, as of the current date, income taxes for 2024 are projected at
$100,000,000. This estimate, as well as the 2023 income tax estimate will be updated later this
year.
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
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-2023 0.35 1.40
Ord. 14-23 – Adopting the Proposed Tax Budget for Fiscal Year 2024
May 13, 2023
4
2024 tax budget reflects an estimated 2023 year-end General Fund balance of $57,485,990, and
$30,791,768 for 2024.
When looking at the projected General Fund balance, it is important to remember that these figures
assume that all funds appropriated in 2023 and 2024 will be spent, which is rarely 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-23 at the second reading/public hearing on June 12,
2023.
Attachment: 2024 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 525,300 0 525,300
PARKLAND ACQUISITION 817,460 817,460 0
CAPITAL IMPROVEMENTS TAX FUND 3,405,695 3,405,695 0
PROPRIETARY FUNDS XXXXXXXX XXXXXXXX XXXXXXXXX XXXXXXXXX XXXXXXXX
FIDUCIARY FUNDS XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX
TOTAL ALL FUNDS 4,748,455 4,223,155 525,300
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 525,300
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 2021 For 2022 Estimated for Estimated for
DESCRIPTION Actual Actual 2023 2024
(1) (2) (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 75,807,429 78,602,233 70,500,000 75,000,000
Other Local Taxes 0 0 0 0
Total Local Taxes 75,807,429 78,602,233 70,500,000 75,000,000
Intergovernmental Revenues
State Shared Taxes and Permits
Local Government 587,218 645,635 545,260 618,000
Estate Tax 0 0 0 0
Cigarette Tax 560 410 500 515
Liquor and Beer Permits 48,231 103,024 70,000 61,800
u0000
Library and Local Government Support Fund 00 0 0
Property Tax Allocation 0 0 0 0
Other Permits 8,863 0 10,000 10,300
Total State Shared Taxes and Permits 644,871 749,068 625,760 690,615
Federal Grants or Aid 0 0 0 0
State Grants or Aid 0 0 0 0
Other Grants or Aid 56,719 17,046 0 0
Total Intergovernmental Revenues 701,590 766,115 625,760 690,615
Special Assessments 0 0 0 0
Charges for Services 947,997 1,277,804 1,008,500 1,038,755
Fines, Licenses, and Permits 3,477,582 3,384,650 3,035,500 3,126,565
Miscellaneous 1,281,634 2,586,066 1,590,350 1,638,061
Other Financing Sources:
Proceeds from Sale of Debt 0 0 0 0
Transfers 34,038 0 0 0
Advances 20,000 6,068,800 1,448,800 1,650,000
Other Sources (Sale of Capital Assets) 0 0 0 0
TOTAL REVENUE 82,270,271 92,685,667 78,208,910 83,143,996
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 2021 For 2022 Estimated for Estimated for
(1) Actual Actual 2023 2024
(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 218,965 144,264 349,368 359,845
Supplies and Materials 47,144 126,396 188,107 193,750
Capital Outlay 0 0 0 0
Total Security of Persons and Property 266,109 270,660 537,475 553,595
Public Health Services
Personal Services 0 0 0 0
Travel Transportation 0 0 0 0
Contractual Services 500,420 508,835 565,734 594,025
Capital Outlay 0 0 0 0
Total Public Health Services 500,420 508,835 565,734 594,025
Leisure Time Activities
Personal Services 4,882,830 5,379,588 5,828,690 6,061,840
Travel Transportation 0 0 0 0
Contractual Services 2,084,517 2,477,272 3,330,875 340,800
Supplies and Materials 421,010 432,117 674,680 694,920
Capital Outlay 14,480 14,825 20,140 20,600
Total Leisure Time Activities 7,402,837 8,303,801 9,854,385 7,118,160
Community Environment
Personal Services 4,985,754 5,988,325 6,239,658 6,489,240
Travel Transportation 0 0 0 0
Contractual Services 1,168,400 1,087,549 3,245,141 3,090,000
Supplies and Materials 13,185 25,271 33,861 33,990
Capital Outlay 0 0 0 0
Total Community Environment 6,167,340 7,101,145 9,518,660 9,613,230
Basic Utility Services
Personal Services 849,009 819,414 820,888 853,725
Travel Transportation 0 0 0 0
Contractual Services 3,568,374 3,890,683 5,034,311 5,185,340
Supplies and Materials 1,930 21,662 39,948 41,145
Capital Outlay 0 438 0 0
Total Basic Utility Services 4,419,313 4,732,197 5,895,147 6,080,210
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 2021 For 2022 Estimated for Estimated for
(1) Actual Actual 2023 2024
(3) (3) (4) (5)
Transportation
Personal Services 1,161,541 1,364,901 1,525,898 1,586,935
Travel Transportation 0 0 0 0
Contractual Services 13,350 645,793 1,939,137 1,997,310
Supplies and Materials 71,692 115,662 246,064 253,445
Capital Outlay 0 0 0 0
Total Transportation 1,246,583 2,126,355 3,711,099 3,837,690
General Government
Personal Services 13,267,156 13,443,665 16,930,327 15,233,445
Travel Transportation 0 0 0 0
Contractual Services 8,121,964 9,550,988 12,802,886 8,446,000
Supplies and Materials 3,209,089 3,820,435 4,360,031 4,490,830
Capital Outlay 15,039,125 7,990,272 609,299 627,580
Total General Government 39,637,334 34,805,360 34,702,543 28,797,855
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 24,118,755 16,160,000 25,900,000 18,440,000
Advances 7,236,965 1,536,965 10,736,965 1,536,965
Contingencies 60,367 180,529 550,564 150,000
Other Uses of Funds(Refunds/Incentives/Grants)5,039,998 10,603,794 6,593,065 6,000,000
Total Other Uses of Funds 36,456,085 28,481,287 43,780,594 26,126,965
TOTAL EXPENDITURES 96,096,020 86,329,641 108,565,638 82,721,730
Revenues over/(under) Expenditures (13,825,749) 6,356,026 (30,356,728) 422,265
Beginning Cash Fund Balance 71,311,739 57,485,990 63,842,016 33,485,288
Ending Cash Fund Balance 57,485,990 63,842,016 33,485,288 33,907,553
Estimated Encumbrances (4,122,792) (4,122,792) 0 0
Estimated Ending Unencumbered Fund Balance 53,363,198 59,719,224 33,485,288 33,907,553
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 2021 For 2022 Estimated for Estimated for
(1) Actual Actual 2023 2024
(3) (3) (4) (5)
REVENUE XXXXXXXX XXXXXXXX XXXXXXXXX XXXXXXXX
Local Taxes - Real Estate 500,829 509,057 510,000 525,300
Intergovernmental Revenue 69,437 109,513 60,500 62,315
Charges for Services 3,784,060 3,998,328 4,017,500 4,138,025
Miscellaneous 46,798 37,428 17,500 18,025
Other Financing Sources:
Transfers 12,559,550 8,250,000 14,000,000 14,000,000
Other Sources 0 0 0 0
TOTAL REVENUE 16,960,674 12,904,325 18,605,500 18,743,665
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 16,731,503 12,438,468 17,382,814 19,578,370
Travel/Transportation 0 0 0 0
Contractual Services 222,260 243,043 421,246 433,885
Supplies and Materials 254,906 233,169 352,630 363,210
Capital Outlay 3,548 2,976 33,923 34,940
Other Uses(Refunds and other misc) 2,705 3,958 5,500 5,665
TOTAL EXPENDITURES 17,214,922 12,921,614 18,196,112 20,416,070
Revenues Over (Under) Expenditures (254,248) (17,289) 409,388 (1,672,405)
Beginning Cash Fund Balance 2,668,740 2,414,492 2,397,203 2,806,590
Ending Cash Fund Balance 2,414,492 2,397,203 2,806,590 1,134,185
Estimated Encumbrances (outstanding at end of year)(174,125) (174,125) 0 0
Estimated Ending Unencumbered Fund Balance 2,240,366 2,223,077 2,806,590 1,134,185
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 2021 For 2022 Estimated for Estimated for
(1) Actual Actual 2023 2024
(3) (3) (4) (5)
REVENUE XXXXXXXX XXXXXXXX XXXXXXXXX XXXXXXXX
Local Taxes*
Property Tax -- Real Estate/Personal Property 3,284,621 3,299,006 3,306,500 3,405,695
Municipal Income Tax (Note 1) 25,269,146 26,200,746 23,500,000 25,000,000
Intergovernmental Revenue 493,998 8,493,151 351,615 362,163
Fines, Licenses, and Permits 0 1,534,702 0 0
Miscellaneous 567,085 692,258 3,000,000 3,090,000
Other Financing Sources:
Transfers 7,550,000 3,980,000 7,865,000 8,100,950
Other Sources-Advances 1,932,000 1,658,000 1,698,000 1,863,000
Proceeds from Bonds 0 0 0 0
TOTAL REVENUE 39,096,850 45,857,863 39,721,115 41,821,808
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 43,583 61,703 65,000 66,950
Capital Outlay 33,002,810 28,559,033 62,179,512 29,349,850
Transfers 5,805,934 6,495,552 7,134,445 7,134,445
Advances 0 5,500,000 2,600,000 2,000,000
TOTAL EXPENDITURES 38,852,327 40,616,289 71,978,957 38,551,245
Revenues Over (Under) Expenditures 244,523 5,241,574 (32,257,842) 3,270,563
Beginning Cash Fund Balance 39,707,926 39,952,450 45,194,025 12,936,183
Ending Cash Fund Balance 39,952,450 45,194,025 12,936,183 16,206,746
Estimated Encumbrances (outstanding at end of year)(18,810,746) (18,810,746) 0 0
Estimated Ending Unencumbered Fund Balance 21,141,704 26,383,279 12,936,183 16,206,746
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 2021 For 2022 Estimated for Estimated for
(1) Actual Actual 2023 2024
(3) (3) (4) (5)
REVENUE XXXXXXXX XXXXXXXX XXXXXXXXX XXXXXXXX
Local Taxes - Real Estate 824,989 824,752 793,650 817,460
Intergovernmental Revenue 86,947 142,105 137,905 142,042
Fines, Licenses, and Permits 0000
Miscellaneous 0000
Other Financing Sources:
Transfers 0000
Other Sources-Advances 0000
Proceeds from Bonds 0000
TOTAL REVENUE 911,936 966,857 931,555 959,502
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 10,895 15,257 18,500 19,055
Capital Outlay 398,579 0 750,000 772,500
Transfers 0000
Advances 0000
TOTAL EXPENDITURES 409,474 15,257 768,500 791,555
Revenues Over (Under) Expenditures 502,462 951,600 163,055 167,947
Beginning Cash Fund Balance 2,391,019 2,893,481 3,845,081 4,008,136
Ending Cash Fund Balance 2,893,481 3,845,081 4,008,136 4,176,083
Estimated Encumbrances (outstanding at end of year)(6,523) (6,523) 0 0
Estimated Ending Unencumbered Fund Balance 2,886,958 3,838,558 4,008,136 4,176,083
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 1,367,060 2,610,000 3,977,060 2,134,510 985,610 3,120,120 856,940
State Highway Improvement 470,713 209,400 680,113 0 265,615 265,615 414,500
Cemetery 176,551 182,000 358,551 158,700 65,990 224,690 133,860
Recreation 1,953,250 7,193,875 9,147,125 5,478,405 2,071,775 7,550,180 1,596,945
Swimming Pool 289,620 1,120,000 1,409,620 676,415 511,180 1,187,595 222,025
Permissive Tax 81,369 108,000 189,369 0 103,000 103,000 86,370
Hotel/Motel Tax 3,008,711 5,618,250 8,626,961 989,210 4,977,460 5,966,669 2,660,290
Enforcement and Education 70,944 500 71,444 0 0 0 71,445
Law Enforcement Trust 137,721 700 138,421 0 4,040 4,040 134,380
Mandatory Drug Fine 2,873 20 2,893 0 0 0 2,895
Mayor's Court Computer 44,113 10,500 54,613 0 31,945 31,945 22,670
Accrued Leave Reserves 1,014,426 501,500 1,515,926 416,000 0 416,000 1,099,925
Wireless 9-1-1 System 461,972 125,000 586,972 0 437,750 437,750 149,220
Rings Unitrust 750,000 0 750,000 0 0 0 750,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 9,837,533 17,679,745 27,517,278 9,853,239 9,454,366 19,307,605 8,209,675
DEBT SERVICE FUNDS XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX
General Debt Service 2,490,400 13,422,000 15,912,400 0 13,654,190 13,654,190 2,258,210
Economic Development Bond Retirement 353,801 2,066,920 2,420,721 0 2,066,920 2,066,920 353,800
Special Assessment Debt Service 8,486 0 8,486 0 0 0 8,485
2001 Special Assessment Debt Service 132,727 0 132,727 0 500 500 132,225
TOTAL DEBT SERVICE FUNDS 2,985,414 15,488,920 18,474,334 0 15,721,610 15,721,610 2,752,720
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,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/23 Balance 12/31/24
PROPRIETARY: XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX
ENTERPRISE FUNDS XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX
Water 11,485,860 1,413,265 12,899,125 300,840 2,005,730 2,306,570 10,592,555
Sewer 4,514,950 3,835,445 8,350,395 1,024,175 4,420,865 5,445,040 2,905,355
Water Construction 0 3,203,910 3,203,910 0 3,203,910 3,203,910 0
Sewer Construction 74,664 7,334,660 7,409,324 0 7,334,660 7,334,660 74,665
TOTAL ENTERPRISE FUNDS 16,075,474 15,787,280 31,862,754 1,325,015 16,965,165 18,290,180 13,572,575
Note: Various construction funds not included.
INTERNAL SERVICE FUNDS XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXX
Employee Benefits Self-Insurance 3,844,849 9,663,768 13,508,617 108,120 11,654,745 11,762,865 1,745,750
Workers Compensation Self-Insurance 32,585 401,250 433,835 0 334,540 334,540 99,295
TOTAL INTERNAL SERVICE FUNDS 3,877,434 10,065,018 13,942,452 108,120 11,989,285 12,097,405 1,845,045
TRUST AND AGENCY FUNDS XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX XXXXXXXX
Visit Dublin Ohio (aka DCVB) 69,526 1,100,000 1,169,526 0 1,100,000 1,100,000 69,526
Agency (Deposits) 184,747 38,585 223,332 0 42,500 42,500 180,832
COIRS 192,325 332,620 524,945 0 332,620 332,620 192,325
Econ Dev - PACE 0 1,451,775 1,451,775 0 1,451,775 1,451,775 0
TOTAL TRUST AND AGENCY FUNDS 446,598 2,922,980 3,369,578 0 2,926,895 2,926,895 442,683
TOTAL FOR MEMORANDUM ONLY 33,222,453 61,943,943 95,166,399 11,286,375 57,057,319 68,343,698 26,822,698
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,480,000 1,015,000 Capital Improvements Tax Fund
Computer Hardware/Software/Fiber 10,030,000 2,060,000 Capital Improvements Tax Fund
CIP - Parks & Recreation
Parks 31,475,000 8,095,000 Capital Improvements Tax Fund
CIP - Safety
Police 4,335,000 735,000 Capital Improvements Tax Fund
CIP - Stormwater System
Stormwater Improvements 5,365,000 1,300,000 Capital Improvements Tax Fund
CIP - Transportation
Mobility, Bicycles and Pedestrians 16,195,000 5,210,000 Capital Improvements Tax Fund
Bridges and Culverts 35,155,000 1,410,000 Capital Improvements Tax Fund
Streets and Parking 72,995,000 11,340,000 Capital Improvements Tax Fund and
TIF Funds (as appropriate)
SUB-TOTAL 198,145,000 34,575,000
CIP - Sanitary Sewer System
Sewer Improvements 1,700,000 2,300,000 Sewer Fund
CIP - Water Distribution System
Water Improvements 80,000 0 Water Fund
SUB-TOTAL 1,780,000 2,300,000
TOTAL 199,925,000 36,875,000
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
Total Project Cost 2023-2027 CIP
(May Include Other Funding
Sources including TIFs)
2024 Projects
11,930,000 2,340,000
Capital Improvements Tax Fund &
Parkland Acquisition Fund
Capital Improvements Tax Fund and
Water & Sewer, Hotel/Motel1,070,0006,185,000 Fleet Management
CITY OF DUBLIN, OHProfile SummaryProfile as Of 12/31/2023Grouped by TypeSeries Dated Date Original Par AmountOutstanding Par AmountFinal MaturityCallable Call Date Type177,871.40 36,649.602020 05/15/2020 177,871.40 36,649.60 05/15/2024 Goverment Obligation Contract (Appropriation)175,344.00 149,042.4022 Woodhull Copiers Lo06/29/2022 175,344.00 149,042.40 03/01/2028 Government Obligation Contract (Appropriation)177,540,000.00 133,125,000.002012 10/02/2012 10,820,000.00 2,560,000.00 06/01/2032 Callable Currently Callable Limited Tax (General Obligation)2015 09/30/2015 49,200,000.00 34,405,000.00 12/01/2035 Callable 12/01/2025 @ 100.000 Limited Tax (General Obligation)2016 12/06/2016 9,325,000.00 6,700,000.00 12/01/2036 Callable 12/01/2025 @ 100.000 Limited Tax (General Obligation)2017 08/02/2017 31,880,000.00 24,560,000.00 12/01/2037 Callable 06/01/2027 @ 100.000 Limited Tax (General Obligation)2018 A 12/18/2018 18,700,000.00 15,345,000.00 12/01/2038 Callable 12/01/2028 @ 100.000 Limited Tax (General Obligation)2018 B 12/18/2018 4,000,000.00 3,295,000.00 12/01/2038 Callable 12/01/2023 @ 100.000 Limited Tax (General Obligation)2020 04/02/2020 26,000,000.00 23,010,000.00 12/01/2040 Callable 12/01/2029 @ 100.000 Limited Tax (General Obligation)2021 10/05/2021 15,730,000.00 11,740,000.00 12/01/2041 Callable 12/01/2031 @ 100.000 Limited Tax (General Obligation)2022 05/10/2022 11,885,000.00 11,510,000.00 12/01/2042 Callable 06/01/2031 @ 100.000 Limited Tax (General Obligation)250,000.00 62,500.002014 02/23/2015 250,000.00 62,500.00 01/01/2026 Ohio Public Works Commission Loan (Appropriation)32,000,000.00 27,910,000.002015 A 10/28/2015 16,000,000.00 16,000,000.00 12/01/2044 Callable 12/01/2025 @ 100.000 Special Obligation (Revenue)2015 B 10/28/2015 16,000,000.00 11,910,000.00 12/01/2035 Callable 12/01/2025 @ 100.000 Special Obligation (Revenue)28,529,329.91 18,419,578.592015 A 02/10/2015 7,873,802.09 5,695,539.92 02/01/2035 State Infrastructure Bank Loan (Appropriation)2015 B 02/10/2015 20,655,527.82 12,724,038.67 01/15/2035 State Infrastructure Bank Loan (Appropriation)2,986,000.00 394,000.002004 04/15/2004 2,986,000.00 394,000.00 01/01/2025 Swimming Pool Loan (Appropriation)241,658,545.31 180,096,770.59Audited Financial Statements: 12/31/2021OHIO PUBLIC WORKS COMMISSION LOAN (APPROPRIATION)SPECIAL OBLIGATION (REVENUE)STATE INFRASTRUCTURE BANK LOAN (APPROPRIATION)SWIMMING POOL LOAN (APPROPRIATION)Total Outstanding Par AmountGOVERMENT OBLIGATION CONTRACT (APPROPRIATION)GOVERNMENT OBLIGATION CONTRACT (APPROPRIATION)LIMITED TAX (GENERAL OBLIGATION)