2018-2022 Five Year PlanVILLAGE OF OAK BROOK
2018-2022
Five-Year Financial Plan
QG� p F UAk
` o
o y
CUUNTI
Village of Oak Brook, Illinois
1200 Oak Brook Road
Oak Brook, Illinois 60523
www.oak-brook.org
VILLAGE OF OAK BROOK
2018-2022
FIVE-YEAR FINANCIAL PLAN
TABLE OF CONTENTS
SECTION
PAGE
Introduction
3
General Assumptions
3
Relationship to the Annual Budget
4
General Corporate Fund
6
Hotel/Motel Tax Fund
20
Motor Fuel Tax Fund
26
Infrastructure Fund
30
Promenade Special Tax Allocation Fund
35
Water Fund
39
Sports Core Fund
44
Golf Surcharge Fund
61
Self -Insurance Fund
65
Garage Fund
69
Equipment Replacement Fund
74
VILLAGE OF OAK BROOK
2018-2022
FIVE-YEAR FINANCIAL PLAN
INTRODUCTION
The Village of Oak Brook Five -Year Financial Plan is intended to provide the community with a long-range projection of the financial
condition for each of the ten funds that comprise the financial structure of the Village of Oak Brook. The Five -Year Plan assumes the
continuation of current service levels and being able to maintain those levels in future years. The forecast provides a foundation for
discussion and policy decisions that will be made in the future to maintain the existing service levels and/or enhance service levels in specific
areas.
Each fund in the Village's financial structure is a separate financial entity. Although the Village's audited financial statements are prepared
on an accrual or modified accrual basis (as applicable and consistent with generally accepted accounting principles as promulgated by the
Governmental Accounting Standards Board), the Five -Year Financial Plan, like the annual Municipal Budget, is prepared and presented on a
cash basis. This results in a more easily understood and more useful document.
The presentation for each fund includes a summary, revenue projections, a general long-range operating budget and a capital improvement
program, if applicable. The Capital Improvements Program focuses on all vehicles and all capital items that are over $5,000. The summary
for each fund reflects the revenue and expenditure projections and presents a rolling five-year operating statement, beginning with cash
available as of January 1, 2017 as reported in the audited financial statements as of December 31, 2016.
GENERAL ASSUMPTIONS
The principal assumptions for the Five -Year Financial Plan involve the rates for general inflation, "personnel inflation" (direct personnel costs
as well as costs of fringe benefits and training), interest rates, and the rate of growth in sales tax, the principal revenue source of the Village.
The 2018-2022 Five -Year Financial Plan is based on the following general assumptions:
• Inflation is the measure of the increase in the cost of goods and services. Inflation is measured by the Consumer Price Index and
impacts most expenditure categories. For the purpose of this report, inflation for the purchase of goods and services and
operational and contractual services are forecasted at 2.5%.
• Personnel inflation, (including benefits, training and merit adjustments applicable to personnel not at top -of -grade) are factored
at 4.5% per year.
3
VILLAGE OF OAK BROOK
2018-2022
FIVE-YEAR FINANCIAL PLAN
• Interest earnings on invested funds at rates ranging from less than .2% to 2%, depending upon the fund, the type and length of
investment.
Sales tax receipts for 2018 are projected to increase 1.0% from the adjusted 2017 estimated cash collections. Adjustments to
future sales tax receipts include new businesses entering and leaving the Village known at the time of creating this document.
For each year thereafter the sales tax receipts are projected to increase 1.5%. Receipts from the non -home rule sales tax, are
projected using the same assumptions as the growth in general sales tax receipts. Additionally, non -home rule sales tax receipts
have been reduced by 2% in years 2018-2022 to account for the State of Illinois administrative collection fee.
• State income tax receipts have been reduced by 10% in years 2018-2022 to reflect recent changes in the State of Illinois budget.
hi years 2018-2022, the long-range operating budget projections are adjusted by an experience factor intended to take into account normal
positive variances in expenditures across the thousands of accounts that make up the Village's financial structure and to partially offset the
effects of compounding of the inflation assumptions in the later years. Other assumptions specific to particular funds are described in the
narrative preceding the presentation of each fund.
RELATIONSHIP TO THE ANNUAL BUDGET
For 2018, staff has prepared the 2018-2022 Five -Year Plan, 2018 Budget, and 2018 Program Objectives concurrently. This is done in order to
streamline the budget process by reducing the amount of time spent overall by staff and the Village Board on budget -related activities.
The 2018 Budget and 2018-2022 Five -Year Plan continues the Village Board directive that staff should prioritize items for inclusion in the
2018 Budget and Five -Year Financial Plan using the following hierarchy:
• Projects or expenditures necessary to maintain or replace critical equipment, projects already started yet not completed, projects that
are the recipient of grant funding, and items required to comply with Illinois and Federal law.
• Projects or expenditures that will directly contribute to increased revenues from sales tax, utility and telecommunications taxes, and
Hotel/Motel taxes.
• Projects or expenditures that will significantly increase the efficiency of Village operations.
4
VILLAGE OF OAK BROOK
2018-2022
FIVE-YEAR FINANCIAL PLAN
• Projects or expenditures that will significantly improve the safety, convenience, or quality of life for residents, non-residents, and
businesses.
• Projects or expenditures that will improve the aesthetics of the Village.
• Discretionary projects or expenditures that add new services or amenities.
The actual 2018 Municipal Budget is provided in a separate document; whereas, the Five -Year Financial Plan is structured by Fund, the
operating budget is structured according to cost centers (called "programs") and is presented at a level of detail far beyond that reflected in the
Five -Year Plan. The capital improvement budget is based on the capital improvement program for the first year of the Five -Year Plan.
At the fund level in the Budget document, revenue budgets are brought together with operating and capital improvement expenditure budgets
to present a cash -basis income statement for each fund (called a "Fund Summary"). The Fund Summary can be compared to the first year of
the relevant Five -Year Financial Plan Summary to ensure that the Budget matches the first year of the Five -Year Plan for that fund.
VILLAGE OF OAK BROOK
2018-2022
FIVE-YEAR FINANCIAL PLAN
GENERAL CORPORATE FUND
The General Corporate Fund is the main operating fund of the Village which provides core services for its operations of the major Village
departments such as Police, Fire, Library, and many other administrative departments. Capital improvements, contributions to pension funds
(in lieu of property tax levies), transfers to the Garage and Equipment Replacement Funds (through user charges), and loans to other funds as
appropriate are all included in the General Fund.
OVERVIEW:
The Village's budget methodology is to estimate revenues conservatively and to maintain a spending level less than or equal to current year
resources. The General Corporate Fund 2018 Budget is operating at a balanced budget where revenues are at or exceed expenditures without
using cash reserves. The proposed 2018 General Fund Revenues totals $26.2 million, an increase of $2.1 million over the 2017 budgeted
revenues, or 8.7%. The total General Fund spending in the proposed 2018 Budget is $26.2 million, an increase of $2.2 million, or 9.0%, from
the 2017 Budget. The following highlights some of the major budget issues facing the Village for 2018 and beyond:
• The pension issue needs to be addressed at the State level as the funding for these plans is becoming increasingly unsustainable for all
Illinois municipalities. The actuarial rate of 6.75%, 100% level of funding, and the RP2000 projected to 2017 mortality table was
budgeted in 2018 - 2022 for both the Police and Fire pension. Total contributions to the Police and Fire Pension Funds budgeted in
2018 are $4.0 million. In year 2022, total contributions to the Police and Fire Pension Funds are expected to reach $4.4 million.
• The impact of new healthcare reforms on employers is multi -faceted and complex. This will directly require employers to modify
their practices and policies. Health insurance related costs are budgeted to increase 5% on July 1, 2018.
• The sustainability of various revenue sources remains uncertain for future years. McDonald's will be departing its Oak Brook
headquarters in 2018, which could result in the loss of 3,000 employees and numerous business visitors coming into the Village on a
daily basis. Although the Village is losing McDonald's, it has gained Duchossois Group, Midwest Orthopedics, Hyatt House, and
other business in the future years.
VILLAGE OF OAK BROOK
2018-2022
FIVE-YEAR FINANCIAL PLAN
• Funding of Capital Improvements continues to be a challenge being able to prioritize and address all of the funding needs. The 2018
budget includes a $2.5 million debt issuance to fund the Police Department lockup renovation project. A study for Fire Station 93
will be conducted during 2018.
The Village's 2018 — 2022 Five -Year Financial Plan represents the current conditions and future viability of the Village's finances. The
overall objective of this plan is to provide analytical information for key budgetary decisions that will allow the Village to accomplish its
goals over the next five-year period and beyond.
Revenues:
The principal source of revenue to the General Corporate Fund, and to the Village, is the sales tax. As a result, the rate of growth in sales tax
receipts determines, to a significant extent, the Village's ability to meet the needs of the community and its overall financial condition. It has
been the practice of the Village to project growth in sales tax receipts conservatively, and that practice is continued in this edition of the Five -
Year Financial Plan (See GENERAL ASSUMPTIONS). For 2018, sales tax revenue is projected to be $12.5 million, which is down slightly
from the 2017 projected receipts. The estimate was based on various businesses entering and leaving the Village, as well as an overall softening of
brick and mortar sales.
Receipts from the utility tax on electric, natural gas, and telecommunications service are expected to end the year at $5.8 million, an increase
of $0.2 million, or 3.6% compared to the 2017 budget. Utility tax collections for 2018 are budgeted to be down $0.2 million from the 2017
estimated amount. Inflationary increases of 1.0% have been assumed in subsequent years 2019 - 2022.
State shared revenues in total are projected using information provided by the Illinois Municipal League for budget year 2018. The State
Income Tax is projected to decrease $130,215, or 16.2%, compared to the 2017 projected amount. This is due to a 10% reduction from the
State of Illinois and two accelerated payments received during 2017. Use tax is expected to increase by $1,640, or 0.8%, from the 2017
projected amount. Replacement Tax is expecting to decrease $46,350, or 15.6%, from 2017 projected amount. State shared revenues are
projected to increase by 2.0% in years 2019 — 2022. The rates imposed for a number of license and fee categories, such as building permits
are projected to increase and should positively impact revenues. Investment returns can significantly fluctuate depending on market
conditions; therefore, interest revenue is projected at $195,000 for 2018 due to the balance of cash on hand and current interest rates. Most
other revenue sources are projected to increase from 0% to 3% per year for the duration of the Five -Year Financial Plan.
7
VILLAGE OF OAK BROOK
2018-2022
FIVE-YEAR FINANCIAL PLAN
Expenditures:
Legislative and General Management: This department involves a wide variety of general -scope functions including the operations of the
Village Board and the offices of the Village Clerk, Village Manager, Village Attorney, and Human Resources. The Legal program includes
Labor Attorney fees of $60,000 budgeted for Police and Public Works union negotiations. The Human Resources budget includes $30,000 for
the implementation of a tuition reimbursement program for employees seeking an advanced degree. The Risk Management program reflects a
decrease in liability insurance premiums in 2018. The liability insurance budget has decreased from $470,000 in 2017 to $346,250 in 2018.
This is due to the use of an IRMA surplus balance in 2018 to offset annual premium costs. The Legislative and General Management
department underwent a reorganization that resulted in the reduction of a full time Human Resources position.
Information Technology budget includes the continuation of two full time contracted employees for a village -wide document imaging project
and miscellaneous IT assistance for $67,400. A part time IT position that was budgeted in 2017 was not filled and will be eliminated in the
2018 budget. The contracted employees will assist with these duties as necessary. A 10% portion of the IT Director's salary and benefits will
continue to be allocated to the Geographic Information System program in year 2018.
Financial Services: This department includes all functions related to the Village's financial management activities. Financial Management
reflects an increase in contractual services due to increases in the Village's audit and actuarial services agreements. The Interfund Transfers
program includes a cost reimbursement of $131,315 to Infrastructure for administrative costs. The Installment Contract Debt Service program
includes $262,500 for principal, interest, and issuance costs on the new Police Department remodel debt issuance.
Public Works: The Municipal Buildings Improvements budget includes $2.7 million in capital improvements, an increase of $2.4 million
from the 2017 budget. The increase in 2018 is due to the Police Department lockup renovation project. A debt certificate is assumed to fund
this project. The program budgets for the majority of the Village's capital improvement which can be found in this book.
Library: The Library General Operations budget includes the elimination of a vacant Circulation Supervisor position. This position was
budgeted in 2017, but not filled.
Police: The Police Field Services program includes $7,900 for a new speed enforcement trailer. Police Support Services includes DuComm
fees of $468,650, a 1.7% increase from 2017. Police pension contributions are budgeted at $1.8 million, an increase of $42,320 or 2.4%
compared to the 2017 budget. This amount reflects 100% of the actuarial determined contribution amount.
Fire: Fire, Rescue, and EMS Operations includes a decrease in overtime of from the 2017 budget to align the budget to historical spends.
Fire gear for $21,875, LDH fire hose for $10,000, and thermal imaging cameras for $7,500 are included in the 2017 capital request.
U
VILLAGE OF OAK BROOK
2018-2022
FIVE-YEAR FINANCIAL PLAN
Emergency Medical Services program includes capital expenses of Zoll Monitor/Defibrillator for $35,200, Zoll Auto Pulse CPR Units for
$18,000, and AED Units for $6,500. Fire pension contributions are budgeted at $2.1 million, an increase of $65,700 or 3.2% compared to the
2017 Budget. This amount reflects 100% of the actuarial determined contribution amount.
Development Services: Development Services Management director's salary and benefits continue to be split between the Engineering
program (40%) and the Development Services program (60%). The Village Planner position continues to be allocated to the Development
Services department at 60% and to the Hotel Fund for their time on streetscape and beautification efforts at 40%.
Exceptional Charges:
Exceptional Charges in the General Corporate Fund include:
• Contributions to the Police and Firefighters' Pension Funds (in lieu of property taxes). These contributions are expected to
increase for the duration of the Five -Year Financial Plan.
• Assumed debt service on installment contract certificates related to the Police Department lockup renovation project.
• Vehicle replacement charges are funded in the General Corporate Fund with 100% of funding contributions in years 2019 - 2022.
The Equipment Replacement fund projected cash balance (page 75) factors in General Fund contributions for years 2018-2022 and
will continue to be a healthy fund.
• An annual reimbursement to the Infrastructure Fund in order to offset costs (primarily administrative) funded by the Infrastructure
Fund that relate to General Corporate Fund activities.
Capital hnprovements:
Significant capital expenditures reflected in the Plan include continued outlays for maintaining our current technology systems, Heritage
Center improvements, renovations to the Police Department, improvements to Fire Stations 93 and 94, replacement of critical equipment in
the fire department, Butler Government Center improvements, and many more. The prioritization of specific projects are reviewed annually
during the budget process and included if the General Corporate Fund has sufficient funds, but projecting them this far in advance is very
difficult.
91
VILLAGE OF OAK BROOK
2018-2022
FIVE-YEAR FINANCIAL PLAN
OTHER CONSIDERATIONS:
It is the financial policy of the Village Board to make every effort to maintain a six month reserve fund for operating expenses. The six month
reserve fund is expected to end 2018 at 9.2 months once all of the budget changes noted here have been fully implemented. Oak Brook's
current philosophy is to always try to keep reserves at or above 6 months even in downtimes. During years when we are in unexpected
difficult economic times or having a significant unplanned expenditure, this excess fund balance could be used to keep the village at or above
the 6 month reserve funding without making drastic cuts in services or personnel to deal with one or two years of financial issues.
10
Village of Oak Brook
18,451,755
17,980,065
18,534,895
2018-2022 Five -Year Financial Plan
18,716,945
19,572,774
20,252,732
GENERAL. CORPORATE FUND
4,701,915
4,628,410
4,593,765
Summary
5,229,607
5,305,486
5,396,691
2017 2017 2018
2019
2020 2021
2022
Budget Estimate Budget
Projection
Projection Projection
Projection
Unrestricted Cash Available, January 1, 2017 $16,510,154
1,477
(450,309)
Add Beginning of Year Cash Balance
Estimated Income $24,054,500 $24,324,845 $26,155,895
$24,062,490
$24,551,018 $24,879,737
$25,199,114
Less Estimated Operating Expenses
Operating Budget
18,451,755
17,980,065
18,534,895
18,136,450
18,716,945
19,572,774
20,252,732
Exceptional Charges
4,701,915
4,628,410
4,593,765
5,056,949
5,229,607
5,305,486
5,396,691
Estimated Net Operating Income
900,830
1,716,370
3,027,235
869,091
604,466
1,477
(450,309)
Add Beginning of Year Cash Balance
16,510,154
16,510,154
16,905,374
16,909,769
16,588,390
16,453,596
15,568,113
Estimated Available Funds
17,410,984
18,226,524
19,932,609
17,778,860
17,192,856
16,455,073
15,117,804
Less Capital Improvement Program
830,310
1,321,150
3,022,840
1,190,470
739,260
886,960
274,760
Unrestricted Cash Available at Year -End
$16,580,674
$16,905,374
$16,909,769
$16,588,390
$16,453,596
$15,568,113
$14,843,044
6 Months Operating Expenditures
$11,003,878
$11,003,878
$11,049,958
$11,141,932
$11,481,240
$11,937,017
$12,314,158
# ojMonihs Reserve
9.0
9.2
9.2
8.9
8.6
7.8
7.2
11
Village of Oak Brook
2018-2022 Five -Year Financial Plan
GENERAL CORPORATE FUND
Revenue Projections
12
2017
2017
2018
2019
2020
2021
2022
Description
Budget
Estimate
Budget
Projection
Projection
Projection
Projection
General Sales Tax
13,048,000
12,496,875
12,453,000
12,639,795
12,829,392
13,021,833
13,217,160
State income Tax
808,500
804,415
674,200
687,684
701,438
715,466
729,776
Replacement Tax
252,735
297,350
251,000
256,020
261,140
266,363
271,690
York Township Road and Bridge Tax
15,000
24,000
24,000
24,000
24,000
24,000
24,000
State Use Tax
189,000
193,860
195,500
199,410
203,398
207,466
211,615
Charitable Games Tax
600
405
500
500
500
500
500
Grants
12,100
12,100
12,500
12,500
12,500
12,500
12,500
Telecommunications Tax/Utility
5,638,000
6,008,235
5,792,250
5,850,173
5,908,674
5,967,761
6,027,439
Total Intergovernmental
19,963,935
19,837,240
19,402,950
19,670,082
19,941,042
20,215,890
20,494,681
Liquor License
156,000
185,000
185,000
185,000
185,000
185,000
185,000
Scavenger Licenses
8,000
10,000
10,000
10,000
10,000
10,000
10,000
Taxi Licenses
30,000
20,000
20,000
20,000
20,000
20,000
20,000
Tobacco License
1,200
1,200
1,200
1,200
1,200
1,200
1,200
Rattle Licenses
600
500
500
500
500
500
500
Building Permits
1,250,000
1,450,000
1,250,000
1,250,000
1,250,000
1,250,000
1,250,000
Electrical Permits
60,000
105,000
70,000
70,000
70,000
70,000
70,000
Plumbing Permits
20,000
20,000
20,000
20,000
20,000
20,000
20,000
Alarm Application Fee
30,000
22,000
34,000
34,000
34,000
34,000
34,000
Annual Alarm Permit Fee
150
120
120
120
120
120
120
Accessory Structure Permits
40,000
90,000
75,000
75,000
75,000
75,000
75,000
HVAC Permits
25,000
37,500
25,000
25,000
25,000
25,000
25,000
Demolition Permits
15,000
10,000
7,500
7,500
7,500
7,500
7,500
Application/Occupancy Fees
35,000
40,000
40,000
40,000
40,000
40,000
40,000
Miscellaneous Licenses & Permits
40,000
49,000
45,000
45,000
45,000
45,000
45,000
Solicitation Permits
800
750
750
750
750
750
750
Total Licenses and Permits
1,711,750
2,041,070
1,784,070
1,784,070
1,784,070
1,784,070
1,784,070
12
Village of Oak Brook
2018-2022 Five -Year Financial Plan
GENERAL CORPORATE FUND
Revenue Projections
13
2017
2017
2018
2019
2020
2021
2022
Description
Budget
Estimate
Budget
Projection
Projection
Projection
Projection
Elevator Inspections
115,000
125,000
125,000
125,000
125,000
125,000
125,000
Zoning/Subdivision Appl. Fees
10,000
20,000
12,500
12,500
12,500
12,500
12,500
Plan Review Fees
20,000
28,000
25,000
25,000
25,000
25,000
25,000
Building/Inspection Fees
110,000
145,000
120,000
120,000
120,000
120,000
120,000
Ambulance Fees
714,500
725,000
725,500
732,755
740,083
747,483
754,958
Toll Road Fire Service
34,000
40,000
40,000
40,000
40,000
40,000
40,000
Special Services -EMS
5,000
5,000
5,000
5,250
5,513
5,788
6,078
Special Services -Fire
5,000
5,000
5,000
5,250
5,513
5,788
6,078
False Alann-Fire
3,000
5,000
4,000
4,000
4,000
4,000
4,000
Compliance
15,000
4,000
5,000
5,000
5,000
5,000
5,000
Fingerprinting
3,000
2,600
2,700
2,700
2,700
2,700
2,700
Special Services -Police
125,000
145,000
150,000
157,500
165,375
173,644
182,326
Field Services -Police
250
100
100
100
100
100
100
Misc. Support Services -Police
3,500
4,225
4,300
4,300
4,300
4,300
4,300
False Alarm -Police
22,500
24,000
24,000
24,000
24,000
24,000
24,000
Eng. Plan Review & Inspection
10,000
7,000
7,500
7,500
7,500
7,500
7,500
Subdivision Review & Inspection
1,000
2,500
2,500
2,500
2,500
2,500
2,500
Fire Plan Review Fees
15,000
19,350
20,000
20,000
20,000
20,000
20,000
Library Services
10,000
8,725
9,000
9,000
9,000
9,000
9,000
Bad Debt
(215,000)
(281,000)
(270,000)
(270,000)
(270,000)
(270,000)
(270,000)
Total Charges for Services
1,006,750
1,034,500
1,017,100
1,032,355
1,048,083
1,064,303
1,081,039
Court Fines
123,090
111,655
120,000
123,600
127,308
131,127
135,061
Village Fines
20,000
21,750
22,000
22,000
22,000
22,000
22,000
Training Reimbursement -Police
7,500
0
0
0
0
0
0
Administrative Towing Fees
50,000
35,000
35,000
35,000
35,000
35,000
35,000
Administrative Fines
2,500
2,000
2,500
2,625
2,756
2,894
3,039
Library Fines
8,000
5,700
6,000
6,000
6,000
6,000
6,000
Interest
125,000
211,000
195,000
169,098
331,768
329,072
311,362
IMF/Franchise Fees
207,200
216,160
215,000
221,450
228,094
234,936
241,984
Rental Income
166,475
151,470
112,750
206,000
212,180
218,545
225,102
Road Maintenance Reimbursement
15,000
15,000
15,000
15,450
15,914
16,391
16,883
Miscellaneous
30,000
25,000
40,000
40,000
40,000
40,000
40,000
13
Village of Oak Brook
2018-2022 Five -Year Financial Plan
GENERAL CORPORATE FUND
Revenue Projections
14
2017
2017
2018
2019
2020
2021
2022
Description
Budget
Estimate
Budget
Projection
Projection
Projection
Projection
Installment Contract Proceeds
0
0
2,475,165
0
0
0
0
Total Other Revenues
754,765
794,735
3,238,415
841,223
1,021,019
1,035,966
1,036,431
Reimbursements From Other Funds
617,300
617,300
713,360
734,761
756,804
779,508
802,893
Total Interfund Revenues
617,300
617,300
713,360
734,761
756,804
779,508
802,893
Total Revenue
24,054,500
24,324,845
26,155,895
24,062,490
24,551,018
24,879,737
25,199,114
14
Exceptional Charges
Police Pension Contribution
Village of Oak Brook
$1,766,300
$1,808,620
$1,882,520
$1,946,610
$1,973,360
2018-2022 Five -Year Financial Plan
Firefighters' Pension Contribution
2,083,600
2,083,600
2,149,300
2,266,895
GENERAL CORPORATE FUND
2,327,900
2,375,205
Vehicle Replacement Charges
360,410
360,410
Long -Range Operating Budget
504,405
559,885
568,360
571,810
Transfer to DuConun Building Reserve
2017 2017 2018
2019
2020
2021
2022
10,000
Budget Estimate Budget
Projection
Projection
Projection
Projection
135,254
139,312
Personnel
$13,938,310 $13,481,405 $13,995,430
$14,534,538
$15,289,876
$16,084,810
$16,921,430
Materials and Supplies
554,530 534,445 532,820
546,141
559,794
573,789
588,134
Operations and Contractual
3,958,915 3,964,215 4,006,645
4,010,321
4,061,973
4,163,501
4,267,567
Total Operating Budget
$18,451,755 $17,980,065 $18,534,895
$19,091,000
$19,911,643
$20,822,100
$21,777,131
$5,305,486
$5,396,691
Adjustment for Budget Goal Attainment
$18,534,895
$18,136,450
$18,716,945
$19,572,774
$20,252,732
Exceptional Charges
Police Pension Contribution
$1,766,300
$1,766,300
$1,808,620
$1,882,520
$1,946,610
$1,973,360
$2,000,380
Firefighters' Pension Contribution
2,083,600
2,083,600
2,149,300
2,266,895
2,300,925
2,327,900
2,375,205
Vehicle Replacement Charges
360,410
360,410
247,030
504,405
559,885
568,360
571,810
Transfer to DuConun Building Reserve
0
0
10,000
10,000
10,000
10,000
10,000
Reimbursement to Infrastructure Fund
128,300
128,300
131,315
135,254
139,312
143,491
147,796
Transfer to Sports Core Fund
73,505
0
0
0
0
0
0
Installment Contract Debt Service
289,800
289,800
247,500
257,875
272,875
282,375
291,500
Total Exceptional Charges
$4,701,915
$4,628,410
$4,593,765
$5,056,949
$5,229,607
$5,305,486
$5,396,691
Capital Improvement Program
(See Schedule)
$830,310
$1,321,150
$3,022,840
$1,190,470
$739,260
$886,960
$274,760
Total Budget
$23,983,980
$23,929,625
$26,151,500
$24,383,869
$24,685,812
$25,765,220
$25,924,183
15
CAPITAL REQUESTS
GENERAL CORPORATE FUND
Legislative and General Management:
Computer Hardware and Software
Total Program 151
Municipal Complex:
Undesignated Repairs/Safety Projects
Interior Painting
Police Dep. Remodel/Addition
Police Dep. Upstairs Carpet
Police Dep. Admin. Kitchen Remodel
Redesign East Entrance
Development Services Counter
BGC Roof
Server Room A/C Units
Electrical Project
Village Hall Carpet Replace West Wing
West Wing/Station 94 Painting
Galvanized Plumbing Replacement
Village Hall Exterior Beautification
Station 94 Apparatus Floor Patching
Station 94 Reseal Apparatus Floor
Station 94 Ceiling Fans
Ductwork Cleaning
Electric Door Strikes
201018 2019 2020 2021 2022 Tota
ojected Budget Projection Projection Projection Projection 2018-2
209,610 240,910 183,200 446,970 118,060 145,060 124,860 1,018,150
209,610 240,910 183,200 446,970 118,060 145,060 124,860 1,018,150
15,000
-
15,000
15,000
15,000
15,000
15,000
75,000
-
-
5,000
5,000
5,000
5,000
5,000
25,000
-
38,605
2,475,165
-
-
-
-
2,475,165
-
-
75,000
-
-
75,000
-
-
-
10,000
-
-
-
10,000
-
-
-
-
-
75,000
-
75,000
15,000
-
-
15,000
-
-
-
15,000
-
-
-
500,000
-
500,000
-
15,000
-
-
15,000
-
448,320
-
-
-
50,000
50,000
50,000
-
-
-
-
50,000
5,000
5,000
5,000
5,000
5,000
5,000
5,000
25,000
15,000
15,000
15,000
15,000
15,000
-
-
45,000
7,500
7,500
7,500
7,500
7,500
7,500
7,500
37,500
10,000
-
10,000
-
-
-
-
10,000
-
-
-
50,000
-
-
-
50,000
5,000
-
5,000
-
-
-
-
5,000
10,000
10,000
10,000
10,000
10,000
10,000
10,000
50,000
15,000
15,000
15,000
15,000
15,000
15,000
15,000
75,000
16
Village of Oak Brook
CAPITAL REQUESTS
GENERAL CORPORATE FUND
Upper Level Bathroom Remodel
Lower Level Bathroom Remodel
Irrigation System
Station 93
Station 93 Building Needs Study
Station 93 Painting Outside/Bird Proofing
Station 93 Door Close Safety System
Station 93 Bunk & Bathroom Remodel
Station 93 Interior Painting
Generator Replacement
Public Works Building:
Recondition/Reseal Garage Floor
Salt Dome Repairs
Ceiling & Lights
Pressure Washer Replacement
Pressure Washer Electric and Gas Replacement
Heritage Center
HVAC
Repoint Exterior
Library:
New Sign on 31st Street
Floor Retile
Lobby Electrical Improvements
Bathroom Remodel
2017
2017
2018
2019
2020
2021
2022Total
dget
Projection
Projection
Projection
Projection
-
107,285
-
50,000
-
15,000
15,000
-
15,000
- 15,000
25,000
-
25,000
-
-
-
- 25,000
-
-
10,000
-
-
- 10,000
-
-
40,000
-
-
- 40,000
-
-
150,000
-
-
- 150,000
-
-
7,500
-
-
- 7,500
-
-
-
75,000
-
-
75,000
25,000
18,800
25,000
25,000
25,000
25,000
25,000 125,000
30,000
30,000
-
-
-
-
- -
20,000
21,200
15,000
15,000
-
-
-
-
20,000
-
- 20,000
-
-
-
-
306,000
- 306,000
25,000
20,000
25,000
25,000
25,000
- 75,000
-
-
15,000
-
-
-
- 15,000
-
15,000
- 15,000
5,000
-
- 5,000
-
-
-
25,000
-
-
- 25,000
17
Mp of Oak Brook
CAPITAL REQUESTS
GENERAL CORPORATE FUND
Office Painting
Carpeting Replacement
Exterior Wood Siding Maintenance
Electrical Improvements
Interior Lighting Change Out
Total Program 421
Police:
Hand Gun Replacement
Speed Enforcement Trailer
Total Program 621
Fire:
Fire Utility Vehicle
Fire Gear Replacement
LDH Fire Hose
Emergency Vehicular Lighting
Starcom Portable Radios
Fire Gear Dryer
Gear Extractor
Thermal Imaging Camera
Total Program 700
2017 2017 2018 2019
-8.goZet Projected Budget Projection
5,000 5,000 5,000 5,000
- - 50,000
5,000 2,435 -
10,000 7,895 20,000
TO 'MI2022 To
Projection Projection Projection,_ .2 ,16,
- - 5,000 15,000
- - 50,000
20,000 20,000
20,000 40,000
372,500 832,040 2,732,665 655,000 498,500 672,500 87,500 4,646,165
- - - - 35,000 - - 35,000
- - 7,900 - - - - 7,900
7,900 35,000 42,900
160,000
160,000
-
-
- - -
-
19,000
19,000
21,875
19,600
20,100 19,600 20,100
101,275
9,000
9,000
10,000
9,000
9,000 - -
28,000
-
-
-
12,000
- - -
12,000
18,000
18,000
-
-
7,000
7,000
-
-
-
-
-
-
15,000 -
15,000
-
-
7,500
7,500
- 7,500 -
22,500
213,000
213,000
39,375
48,100
44,100 27,100 20,100
178,775
f[:
CAPITAL REQUESTS
GENERAL CORPORATE FUND
2017 2018 2019 2020 2021 2022 Total
ojected Budget Projection . Projection Projection Projection 2018-20
Zoll Monitor/Defibrillator
35,200 35,200 35,200
35,200 35,200
35,200
35,200
176,000
Zoll Auto Pulse CPR Units
- - 18,000
- -
-
-
18,000
EMS Body Armor
- -
- 3,200
3,200
3,200
9,600
AED Units
- 6,500
5,200 5,200
3,900
3,900
24,700
Total Program 731
35,200 35,200 59,700
40,400 43,600
42,300
42,300
228,300
Note - Totals above include engineering costs.
19
VILLAGE OF OAK BROOK
2018-2022
FIVE-YEAR FINANCIAL PLAN
HOTEL/MOTEL TAX FUND
This fund is used to account for funds collected from imposition of the Village's Hotel/Motel Tax. State law requires that for non -home rule
communities this revenue must be devoted to programs and activities designed to increase tourism and overnight stays in hotels located within
the Village. For 2006 and prior, most expenditures of funds from the tax were those recommended by the Hotel, Convention and Visitors
Committee and specifically approval of the Village Board. Beginning in 2007, the Village Board established a Hotel Beautification District
designed to improve and maintain the landscape and hardscape features in the areas served by the hotels also in order to increase overnight
stays in hotels located within the Village. Village code dedicates 1% of the 3% Hotel/Motel Tax rate to funding activities of the Hotel,
Convention and Visitors Committee; the remaining 2% of the 3% rate is dedicated to funding the Hotel District streetscape projects.
OVERVIEW:
Revenue:
For 2018, revenues from the 3% Hotel/Motel Tax are projected to be $1.3 million, which is an increase of $74,000, or 5.8% compared to the
2017 Budget and relatively flat to the 2017 projected amount. For 2019 and thereafter, revenue is projected to increase 1.0% per year.
Operations (1% Fund):
For 2018, the projections reflect expenditures for marketing efforts of the Hotel, Convention and Visitors Committee, as well as payments to
the DuPage Convention and Visitors Bureau equal to 25% of the first 1% of the Hotel Tax imposed. Thereafter, expenditures increase
approximately 3.0% per year.
Exceptional Charges:
The Plan reflects an annual transfer to the General Corporate Fund for administrative services from the Hotel, Convention and Visitors
Committee for a portion of the Village Planner.
20
VILLAGE OF OAK BROOK
2018-2022
FIVE-YEAR FINANCIAL PLAN
Capital Improvement Program (2% Fund):
The 2018 Budget includes pedestrian access improvements budgeted for $600,000, median and street lighting projects for $70,000, and
median plantings for $20,000. Thereafter, additional outlays of specific projects are budgeted for improvements and maintenance in the Hotel
Beautification District.
21
Village of Oak Brook
2018-2022 Five -Year Financial Plan
HOTEU/MOTEL TAX FUND
Summary
2017 2017 2018 2019 2020 2021 2022
Budget Estimate Budget Projection Projection Projection Projection
Unrestricted Cash Available, January I, 2017 $4,403,430
Estimated Income $1,288,000 $1,386,280 $1,370,000 $1,369,858 $1,382,364 $1,395,017 $1,407,817
Less Estimated Operating Expenses
Operating Budget
375,975
381,225
596,515
453,115
460,100
467,205
474,560
Exceptional Charges
93,400
93,400
99,550
102,537
105,613
108,781
112,044
Estimated Net Operating Income
818,625
911,655
673,935
814,206
816,651
819,031
821,213
Add Beginning of Year Cash Balance
4,403,430
4,403,430
3,307,585
3,291,520
3,085,726
2,882,377
2,681,408
Estimated Available Funds
5,222,055
5,315,085
3,981,520
4,105,726
3,902,377
3,701,408
3,502,621
Less Capital Improvement Program
2,057,500
2,007,500
690,000
1,020,000
1,020,000
1,020,000
520,000
Estimated Unrestricted Cash Balance at Year -End
$3,164,555
$3,307,585
$3,291,520
$3,085,726
$2,882,377
$2,681,408
$2,982,621
22
Village of Oak Brook
2018-2022 Five -Year Financial Plan
HOTEIJMOTEL TAX FUND
Revenue Projections
23
2017
2017
2018
2019
2020
2021
2022
Budget
Estimate
Budget
Projection
Projection
Projection
Projection
Hotel/MotelTm
$1,266,000
$1,331,050
$1,340,000
$1,353,400
$1,366,935
$1,380,605
$1,394,410
Grants
0
0
0
0
0
0
0
Interest
22,000
43,900
30,000
16,458
15,429
14,412
13,407
Miscellaneous
0
11,330
0
0
0
0
0
Total Revenue
$1,288,000
$1,386,280
$1,370,000
$1,369,858
$1,382,364
$1,395,017
$1,407,817
23
Village of Oak Brook
2018-2022 Five -Year Financial Plan
HOTELIMOTEL TAX FUND
Long -Range Operating Budget
2017
2017
2018
2019
2020
2021
2022
Budget
Estimate
Budget
Projection
Projection
Projection
Projection
Operations and Contractual $375,975
$381,225
$596,515
$453,115
$460,100
$467,205
$474,560
Total Operating Budget $375,975
$381,225
$596,515
$453,115
$460,100
$467,205
$474,560
Exceptional Charges
Reimbursement to General Fund $93,400 $93,400 $99,550 $102,537 $105,613 $108,781 $112,044
Total Exceptional Charges $93,400 $93,400 $99,550 $102,537 $105,613 $108,781 $112,044
Capital Improvement Program
Hotel Beautification and projects $2,057,500 $2,007,500 $690,000 $1,020,000 $1,020,000 $1,020,000 $520,000
Total Budget $2,526,875 $2,482,125 $1,386,065 $1,575,652 $1,585,713 $1,595,986 $1,106,604
24
CAPITAL REQUESTS
HOTEL AND MOTEL FUND
Streetscape Program (2% Portion)
Median/Streetlighting Projects
22nd St. (Salt Creek -1294)
Connect McDonalds Irrigation System (Jorie Blvd)
Design - Jorie, York, Perimeter of OB Center
Construction - Jorie, York, Perimeter of OB Center
Median Plantings
TBD Additional projects
Total Median/Streetlighting Projects
Pedestrian Access Projects:
Spring/Harger Connection Ph2 (Prof C) Design
Spring/Harger Connection Ph2 (Prof C) Const
16th Street Connection (Proj A) Design
16th Street Connection (Proj A) Const
Oak Brook Center to 16th St. Connection
Clearwater, York, and 22nd Street Connection
TBD Additional projects
Total Pedestrian Access Projects
1,837,500
1,837,500
-
- - - - -
-
-
40,000
- - - - 40,000
30,000
-
30,000
- - - - 30,000
-
-
-
1,000,000 1,000,000 - - 2,000,000
20,000
-
20,000
20,000 20,000 20,000 20,000 100,000
-
-
-
- - 1,000,000 500,000 1,500,000
1,887,500
1,837,500
90,000
1,020,000 1,020,000 1,020,000 520,000 3,670,000
10,000
10,000
-
- - - - -
-
-
100,000
- - - - 100,000
25,000
25,000
-
- - - - -
-
-
250,000
- - - - 250,000
125,000
125,000
-
- - - - -
30,000
10,000
-
- - - - -
-
-
250,000
- - - - 250,000
170,000
170,000
600,000
- - - 600,000
Total Program 171 2,057,500 2,007,500 690,000 1,020,000 1,020,000 1,020,000 520,000 4,270,000
Note - Totals above include engineering costs.
25
VILLAGE OF OAK BROOK
2018-2022
FIVE-YEAR FINANCIAL PLAN
MOTOR FUEL TAX FUND
DESCRIPTION:
The Motor Fuel Tax (MFT) Fund is used to account for funds distributed to the Village by the State of Illinois pursuant to the MFT
distribution formula. State law limits the use of these funds for specified purposes. This edition of the Five -Year Financial Plan continues the
practice of periodically allocating MFT funds to eligible street resurfacing and reconstruction projects.
OVERVIEW:
Revenue:
The Motor Fuel Tax is levied on a cents -per -gallon basis and is deposited into a segregated fund at the State level. From there, funds are
distributed to local governments on a per -capita basis, according to a formula and based on the last certified census. Actual collections in
2017 are projected to be $201,365. Revenues for 2018 are budgeted at $204,160, an increase of $2,795 over projected 2017 collections. For
years, 2019 — 2022 revenues are projected to increase 2.0% each year.
Exceptional Charges:
Funds are projected to be transferred to the Infrastructure Fund as needed for related Motor Fuel Tax projects.
26
Unrestricted Cash Available, January 1, 2017 $906,936
Estimated Income
Less Estimated Operating Expenses
Operating Budget
Exceptional Charges
Estimated Net Operating Income
Add Beginning of Year Cash Balance
Estimated Available Funds
Less Capital Improvement Program
Estimated Unrestricted Cash Balance at Year -End
Village of Oak Brook
2018-2022 Five -Year Financial Plan
MOTOR FUEL TAX FUND
Summary
2017
Budget
$209,200
2017 2018 2019 2020 2021 2022
Estimate Budget Pro,jectioo Projection Projection Projection
$210,365 $210,160 $210,381 $212,447 $216,658 $220,999
0
0
0
0
0
0
0
561,765
400,000
500,000
630,000
220,000
215,000
220,000
(352,565)
(189,635)
(289,840)
(419,619)
(7,553)
1,658
999
906,936
906,936
717,301
427,461
7,842
289
1,947
554,371
717,301
427,461
7,842
289
1,947
2,946
0
0
0
0
0
0
0
$554,371
$717,301
$427,461
$7,842
$289
$1,947
$2,946
27
Village of Oak Brook
2018-2022 Five -Year Financial Plan
MOTOR FUEL TAX FUND
Revenue Projections
2017
2017
2018
2019
2020
2021
2022
_ Budget
Estimate
Budget
Projection
Projection
Projection
Projection
Motor Fuel Tax Allotments $206,200
$201,365
$204,160
$208,243
$212,408
$216,656
$220,989
Interest 3,000
9,000
6,000
2,137
39
1
10
Total Revenue $209,200
$210,365
$210,160
$210,381
$212,447
$216,658
$220,999
M
Village of Oak Brook
2018-2022 Five -Year Financial Plan
MOTOR FUEL TAX FUND
Long -Range Operating Budget
2017 2017 2018 2019 2020 2021 2022
Budget Estimate Budget Projection Projection Projection Projection
Exceptional Charges
Transfer to Infrastructure Fund $561,765 $400,000 $500,000 $630,000 $220,000 $215,000 $220,000
Total Exceptional Charges $561,765 $400,000 $500,000 $630,000 $220,000 $215,000 $220,000
29
VILLAGE OF OAK BROOK
2018-2022
FIVE-YEAR FINANCIAL PLAN
II JI1XI.yIII1 9 1 Qat A 1,
DESCRIPTION:
The Infrastructure Fund was established to separately account for revenues and expenditures related to certain categories of capital projects
including street resurfacing/reconstruction, safety pathways and drainage projects. Due to statutory restrictions on use, beginning in 2005 the
Village's non -home rule sales tax of 0.25% (authorized by referendum in 2004) became the major source of funding for this Fund. In April,
2007 a second referendum was passed and the rate of tax increased to 0.50% effective January 1, 2008 (collections began in April, 2008).
Periodic transfers from the Motor Fuel Tax Fund have been made in order to supplement the roadway maintenance program. In 2005 and
after, most operating costs of the Public Works and Engineering Departments have been shifted to this fund.
OVERVIEW
Revenue from the Village's Non -Home Rule Sales Tax is projected at $5.6 million for 2018, which represents a $0.4 million decrease from
the 2017 budget and a $0.1 million decrease from the 2017 projected amount. As is the case with the General Sales Tax, 20% of the
incremental Non -Home Rule Sales Taxes generated by the Promenade Development are required to be deposited in the Promenade Special
Tax Allocation Fund. Thereafter, for 2019 — 2022, the revenues are estimated to grow approximately 1.5% per year (See GENERAL
ASSUMPTIONS). Transfers from the Motor Fuel Tax Fund are reflected as needed in order to supplement the roadway maintenance
program. Reimbursements from the General Corporate Fund are reflected in order to allocate costs (mostly administrative) that are funded by
the Infrastructure Fund that relate to activities in these funds.
Operations:
The 2018 Budget continues the outsourcing of the Village project engineering functions.
Capital Improvements:
The 2018 Street Improvement project will occur for approximately $2.8 million including engineering. Additional projects are scheduled to
begin in 2018, including: York Road/I-88 Bridge, York Road/Harger Road Intersection, York Road/Harger Road Bike Path, Windor
Bridge/Street Design.
30
Village of Oak Brook
2018-2022 Five -Year Financial Plan
INFRASTRUCTURE FUND
Summary
2017 2017 2018 2019 2020 2021 2022
Budget Estimate Budget Projection Projection Projection Projection
Unrestricted Cash Available, January 1, 2017 $5,149,586
Estimated Income $6,752,900 $6,347,925 $6,291,130 $7,476,695 $7,252,392 $7,335,171 $6,838,521
Less Estimated Operating Expenses
Operating Budget
2,802,295
2,548,940
2,642,625
2,620,784
2,674,239
2,728,721
2,784,243
Exceptional Charges
323,125
323,125
225,395
295,783
304,439
318,417
327,959
Estimated Net Operating Income
3,627,480
3,475,860
3,423,110
4,560,128
4,273,714
4,288,033
3,726,319
Add Beginning of Year Cash Balance
5,149,586
5,149,586
6,875,446
4,342,936
2,044,944
45,453
1,058,486
Estimated Available Funds
8,777,066
8,625,446
10,298,556
8,903,064
6,318,658
4,333,486
4,784,805
Less Capital Improvement Program
1,750,000
1,750,000
5,955,620
6,858,120
6,273,205
3,275,000
3,275,000
Estimated Unrestricted Cash Balance at Year -End
$7,027,066
$6,875,446
$4,342,936
$2,044,944
$45,453
$1,058,486
$1,509,805
31
Non -Home Rule Sales Tax
Grants
Interest
Transfer From Motor Fuel Tax Fund
Reimbursements From Other Funds
Miscellaneous
Total Revenue
Village of Oak Brook
2018-2022 Five -Year Financial Plan
INFRASTRUCTURE FUND
Revenue Projections
2017
2017
2018
2019
2020
2021
2022
Budget
Estimate
Budget
Projection
Projection
Projection
Projection
$5,982,000
$5,703,750
$5,563,000
$5,646,445
$5,731,142
$5,817,109
$5,904,365
0
3,145
0
1,000,000
1,100,000
1,100,000
500,000
27,500
58,650
42,000
8,686
4,090
136
5,292
561,765
400,000
500,000
630,000
220,000
215,000
220,000
176,635
176,635
181,130
186,564
192,161
197,926
203,863
5,000
5,745
5,000
5,000
5,000
5,000
5,000
$6,752,900
$6,347,925
$6,291,130
$7,476,695
$7,252,392
$7,335,171
$6,838,521
32
Exceptional Charges
Vehicle Replacement Charges
Village of Oak Brook
160,625
60,530
122,675
122,675
127,565
2018-2022 Five -Year Financial Plan
Transfer to Other Funds
162,500
162,500
164,865
173,108
INFRASTRUCTURE FUND
190,852
200,394
Total Exceptional Charges
323,125
323,125
Long -Range Operating Budget
295,783
304,438
318,417
327,959
2017 2017 2018
2019
2020
2021
2022
Budget Estimate Budget
Projection
Projection
Projection
Projection
Personnel
$1,474,390 $1,237,100 $1,365,445
$1,416,093
$1,468,750
$1,523,501
$1,580,431
Materials and Supplies
351,095 146,825 182,955
187,529
192,217
197,023
201,948
Operations and Contractual
946,810 1,110,335 1,024,225
1,106,362
1,134,021
1,162,371
1,191,430
Capital Outlay (not C.I.P.)
30,000 54,680 70,000
20,000
20,000
20,000
20,000
Total Operating Budget
2,802,295 2,548,940 2,642,625
2,729,984
2,814,988
2,902,895
2,993,810
Adjustment for Budget Goal Attainment
2,642,625
2,620,784
2,674,239
2,728,721
2,784,243
Exceptional Charges
Vehicle Replacement Charges
160,625
160,625
60,530
122,675
122,675
127,565
127,565
Transfer to Other Funds
162,500
162,500
164,865
173,108
181,763
190,852
200,394
Total Exceptional Charges
323,125
323,125
225,395
295,783
304,438
318,417
327,959
Capital Improvement Program
(See Schedule)
1,750,000
1,750,000
5,955,620
6.858,120
6,273,205
3,275,000
3,275,000
Total Budget
$4,875,420
$4,622,065
$8,823,640
$9,774,687
$9,251,882
$6,322,138
$6,387,202
33
Village of Oak Brook
CAPITAL REQUESTS
INFRASTRUCTURE FUND
Drainage Maintenance
Salt Dome/Storage Drainage Design
Salt Dome/Storage Drainage Construction
Total Program 364
Roadway Improvements
Street Resurfacing/Reconstruction
Street Cracksealing
York Road/1-88 Bridge
York Road/HargerRoad Intersection
York Road/Harger Road Bike Path
Harger Road Bike Path Design
Harger Road Bike Path Construction
Windsor Bridge/Street Design
Windsor Bridge/Street Construction
Total Program 461
2017 2017
Budget Projected
2018 2019
Budget Projection
168,500
Rion Projection Proje
168,500
- - - 1,000,000 1,000,000 - - 2,000,000
168,500 1,000,000 1,000,000 2,168,500
1,650,000 1,650,000 2,800,000
1,500,000
1,500,000
2,000,000
2,000,000
9,800,000
100,000 100,000 -
-
75,000
75,000
75,000
225,000
- - 762,420
762,420
653,505
-
-
2,178,345
- - 1,210,000
1,210,000
1,210,000
-
-
3,630,000
- - 634,700
634,700
634,700
-
1,904,100
- - 30,000
-
-
-
30,000
-
1,526,000
-
1,526,000
- 350,000
225,000
-
-
-
575,000
- -
-
1,200,000
1,200,000
1,200,000
3,600,000
1,750,000 1,750,000 5,787,120
5,858,120
5,273,205
3,275,000
3,275,000
23,468,445
Note - Totals above include engineering costs.
34
VILLAGE OF OAK BROOK
2018-2022
FIVE-YEAR FINANCIAL PLAN
PROMENDADE SPECIAL TAX ALLOCATION FUND
DESCRIPTION:
The Promenade Special Tax Allocation Fund was established in 2006 as a result of a redevelopment agreement approved by the Village Board
that provides for Tax Increment Financing (T.I.F.) for certain infrastructure improvements for the Promenade Development. As provided for
in the redevelopment agreement, the Village has issued a limited obligation note of $4.25 million bearing interest at 8%. The note is secured
by 100% of the incremental real estate taxes and 20% of the incremental sales taxes generated by the Promenade Development. The note is
not a general obligation of the Village and the Village's liability is limited to the pledge of incremental revenues previously noted for a period
not to exceed 15 years.
Revenue
Revenues from the incremental real estate tax revenue generated by the development are projected based on a 1.5% increase from the amount
received for 2018. For 2019 and thereafter, real estate tax revenues are projected based on increasing at 1.5%. Sales tax receipts from the
General Fund and Infrastructure Fund is included based on 20% of the expected General Sales Tax and Non -Home Rule Sales Tax expected
to be generated from the development.
Exceptional Charges
Exceptional charges consist of debt service on the $4.25 million limited obligation notes that were issued in early 2008. The notes provide in
November each year the Village is to notify the holders of the notes as to the amount funds expected to be on hand to fund debt service for the
subsequent year. Based on the amounts projected to be available for the succeed year debt service payments are to scheduled to be applied to
(1) interest on past due interest, (2) current interest, and (3) repayment of principal. For the 2018 Budget and years 2019-2022, principal and
interest payments are projected based on the original repayment schedule.
35
Unrestricted Cash Available, January 1, 2017 $249,278
Estimated Income
Less Estimated Operating Expenses
Operating Budget
Exceptional Charges
Estimated Net Operating Income
Add Beginning of Year Cash Balance
Estimated Available Funds
Less Capital Improvement Program
Estimated Unrestricted Cash Balance at Year -End
Village of Oak Brook
2017-2021 Five -Year Financial Plan
PROMENADE SPECIAL TAX ALLOCATION (T.I.F.) FUND
Summary
2017 2017 2018 2019 2020 2021 2022
Budget Estimate Budget Projection Projection Projection Projection
$455,600 $486,375 $487,750 $493,144 $498,599 $504,117 $509,698
4,070
3,960
4,090
4,192
4,297
4,404
4,515
454,380
454,380
459,820
463,660
479,280
486,170
493,115
(2,850)
28,035
23,840
25,292
15,022
13,543
12,068
249,278
249,278
277,313
301,153
326,445
341,467
355,010
246,428
277,313
301,153
326,445
341,467
355,010
367,078
0
0
0
0
0
0
0
$246,428
$277,313
$301,153
$326,445
$341,467
$355,010
$367,078
36
Village of Oak Brook
2017-2021 Five -Year Financial Plan
PROMENADE SPECIAL TAX ALLOCATION (T.I.F.) FUND
Revenue Projections
2017
2017
2018
2019
2020
2021
2022
Budget
Estimate
Budget
Projection
Projection
Projection
Projection
Real Estate Taxes $355,000
$385,020
$385,000
$388,850
$392,739
$396,666
$400,633
Sales Tax 100,500
101,075
102,500
104,038
105,598
107,182
108,790
Interest 100
280
250
256
263
269
276
Total Revenue $455,600 $486,375 $487,750 $493,144 $498,599 $504,117 $509,698
37
Village of Oak Brook
2017-2021 Five -Year Financial Plan
PROMENADE SPECIAL TAX ALLOCATION (T.I.F.) FUND
Long -Range Operating Budget
2017
2017
2018
2019
2020
2021
2022
Budget
Estimate
Budget
Projection
Projection
Projection
Projection
Operations and Contractual $4,070
$3,960
$4,090
$4,192
$4,297
$4,404
$4,515
Total Operating Budget 4,070
3,960
4,090
4,192
4,297
4,404
4,515
Exceptional Charges
Debt Service Interest
277,380
277,380
262,820
246,660
228,380
207,770
184,915
Debt Service Principal
177,000
177,000
197,000
217,000
250,900
278,400
308,200
Total Exceptional Charges
454,380
454,380
459,820
463,660
479,280
486,170
493,115
Total Budget
$ 458,450
$ 458,340
$ 463,910
$ 467,852
$ 483,577
$ 490,574
$ 497,630
38
VILLAGE OF OAK BROOK
2018-2022
FIVE-YEAR FINANCIAL PLAN
WATER FUND
The water utility is one of two large enterprises operated by the Village. It serves approximately 5,200 customers, nearly 2,000 of which are
located outside the corporate limits of Oak Brook. The Water Fund supports both operations and capital improvements to the water system.
The Water Fund is considered an enterprise fund and is operated on a self-supporting basis.
Revenue: Revenue from the sale of water is based on an average of 900 million gallons billed per year and usage is projected to remain flat in
order to mitigate fluctuations due to weather. In late 2015, the Village Board conducted a comprehensive water rate study, which resulted in
increasing the water rates by 10% and fixed charges by 36% for 2016 in order to support the operating and maintenance of the system as well
as capital improvements. Subsequent increases range from 7% to 10%, including a 7% increase in 2018 to the water rate. The 2018-2022
Five Year Plan reflects rate increases as proposed in the water rate study in order to fund expected long-term capital outlays due to the aging
of the system and an estimated 5% rate increase from the City of Chicago to the DuPage Water Commission.
Operations: The cost to DuPage Water Commission is reflective in the 2018 budget at $6.1 million and 5% increase in years 2019 — 2022.
Capital Improvements: The capital improvement program reflects a focus on water main replacement for the next twenty years.
M
Village of Oak Brook
2018-2022 Five -Year Financial Plan
WATER FUND
Summary
2017 2017 2018 2019 2020 2021 2022
Budget Estimate Budget Projection Projection Projection Projection
Unrestricted Cash Available, January 1, 201 $2,724,004
Estimated Income $9,345,500 $9,645,670 $9,937,425 $10,585,225 $11,372,875 $12,224,100 $12,915,500
Less Estimated Operating Expenses
Operating Budget
1,711,935
1,648,335
1,510,090
1,520,625
1,562,399
1,605,229
1,649,135
Exceptional Charges
6,143,170
5,426,160
6,494,445
6,840,946
7,174,168
7,521,133
7,885,189
Estimated Net Operating Income
1,490,395
2,571,175
1,932,890
2,223,654
2,636,308
3,097,738
3,381,176
Add Beginning of Year Cash Balance
2,724,004
2,724,004
4,224,979
3,372,649
3,511,523
3,595,316
3,750,534
Estimated Available Funds
4,214,399
5,295,179
6,157,869
5,596,303
6,147,831
6,693,054
7,131,710
Less Capital Improvement Program
3,235,010
1,070,200
2,785,220
2,084,780
2,552,515
2,942,520
1,870,425
Estimated Unrestricted Cash Balance at Year -End
$979,389
$4,224,979
$3,372,649
$3,511,523
$3,595,316
$3,750,534
$5,261,285
40
Village of Oak Brook
2018-2022 Five -Year Financial Plan
WATERFUND
Revenue Projections
41
2017
2017
2018
2019
2020
2021
2022
Budget
Estimate
Budget
Projection
Projection
Projection
Projection
Water Sales
$9,143,000
$9,284,135
$9,730,425
$10,380,725
$11,168,375
$12,019,600
$12,711,000
Unmetered Sales
25,000
30,000
30,000
30,000
30,000
30,000
30,000
Connection Fees
30,000
158,000
50,000
50,000
50,000
50,000
50,000
Meter Fees
25,000
23,000
25,000
25,000
25,000
25,000
25,000
Special Services
31,000
30,500
30,000
30,000
30,000
30,000
30,000
Fire Service Charge
10,000
5,000
5,000
5,000
5,000
5,000
5,000
Plan Review Fees
2,000
2,000
2,000
2,000
2,000
2,000
2,000
Inspection Fees
4,500
6,500
5,000
5,000
5,000
5,000
5,000
Interest
10,000
28,150
10,000
7,500
7,500
7,500
7,500
Grants
0
3,385
0
0
0
0
0
Miscellaneous
65,000
75,000
50,000
50,000
50,000
50,000
50,000
Total Revenue
$9,345,500
$9,645,670
$9,937,425
$10,585,225
$11,372,875
$12,224,100
$12,915,500
41
Village of Oak Brook
2018-2022 Five -Year Financial Plan
WATER FUND
Long -Range Operating Budget
-
2017
2017
2018
2019
2020
2021
2022
Budget
Estimate
Budget
Projection
Projection
Projection
Projection
Personnel
$835,110
$823,405
$817,490
$854,277
$892,720
$932,892
$974,872
Materials and Supplies
70,660
68,015
76,860
79,166
81,541
83,987
86,507
Operations and Contractual
806,165
756,915
615,740
634,212
653,239
672,836
693,021
Total Operating Budget
$1,711,935
$1,648,335
$1,510,090
$1,567,655
$1,627,499
$1,689,715
$1,754,399
Adjustment for Budget Goal Attainment
$1,510,090
$1,520,625
$1,562,399
$1,605,229
$1,649,135
Exceptional Charges
DWC Fixed and O & M Charges
$5,663,760
$4,946,750
$6,060,225
$6,363,236
$6,681,398
$7,015,468
$7,366,241
Reimbursement To General Corporate Fund
401,600
401,600
405,170
417,325
429,845
442,740
456,022
Vehicle Replacement Charges
77,810
77,810
29,050
60,385
62,925
62,925
62,925
Total Exceptional Charges
$6,143,170
$5,426,160
$6,494,445
$6,840,946
$7,174,168
$7,521,133
$7,885,189
Capital Improvement Program
(See Schedule)
$3,235,010
$1,070,200
$2,785,220
$2,084,780
$2,552,515
$2,942,520
$1,870,425
Total Budget
$11,090,115
$8,144,695
$10,789,755
$10,446,352
$11,289,082
$12,068,882
$11,404,749
N
CAPITAL REQUESTS
WATER FUND
Distribution Improvements:
Water System Controls Radio Upgrade
Replacement Water Meters
Total Program 351
New Water Meters and Radio Collectors
Master Meter Design
Install Master Meters
Water Tower Painting
Luthin Road Engineering and Construction
Control Valve Reservoir A
Generator Reservoir 8
Harger Road Bridge to Yorkshire Design
Harger Road Bridge to Yorkshire Construction
Harger Road Steeplechase to Yorkshire
Concord/Ivy/Devonshire Watermain
Charleton/Kimberly, Pembroke/Shelburne WM
Mockingbird, Lambeth, Heather, Cemelot WM
Total Program 451
115,000
20,200
100,000
- - - - 100,000
50,000
50,000
20,000
20,000 20,000 20,000 20,000 100,000
165,000
70,200
120,000
20,000 20,000 20,000 20,000 200,000
2,500,000
1,000,000 2,000,000
-
-
-
2,000,000
-
- 25,000
25,000
25,000
25,000
25,000
125,000
340,010
350,220
175,000
180,000
185,000
190,000
1,080,220
-
- -
650,000
-
700,000
-
1,350,000
20,000
- 25,000
499,960
-
-
524,960
150,000
- 155,000
-
-
-
-
155,000
80,000
- 85,000
-
-
-
-
85,000
-
- 25,000
-
-
-
-
25,000
-
- -
310,000
-
-
-
310,000
-
- -
404,820
-
-
-
404,820
-
- -
-
2,327,515
-
-
2,327,515
-
- -
-
-
2,012,520
-
2,012,520
-
- -
-
-
-
1,635,425
1,635,425
3,090,010
1,000,000 2,665,220
2,064,780
2,532,515
2,922,520
1,850,425
12,035,460
Note - Totals above include engineering costs.
43
Eff
2,552,515 2,942,SZ 1,870,425
VILLAGE OF OAK BROOK
2018-2022
FIVE-YEAR FINANCIAL PLAN
SPORTS CORE FUND
The Oak Brook Sports Core is the other large enterprise operated by the Village. The Sports Core Fund supports the entire operation
including uses of the Sports Core's fields and forest areas, the Oak Brook Golf Club, the Oak Brook Bath and Tennis Club (all available for
use by the general public) and food and beverage services at the various Sports Core venues. It is considered an enterprise fund since the
majority of its revenues are derived from user fees.
In order to make clear the specific designation of certain resources, the Sports Core Fund is broken down into three segments: Sports Core
Operations, the Golf Surcharge Account and the Capital Improvement Account. The Sports Core Fund - Consolidated presentation brings all
of the parts together.
OVERVIEW:
For many years it has been the goal of the Village to operate the Sports Core on a self-sufficient basis; that is, it should be 100% supported by
user fees. Based on projections contained in this document, revenues are expected to cover operating expenses. Scheduled capital
expenditures will vary depending on the amount of resources available each year. Delays in capital items are expected to occur in the future.
Although the future projections are encouraging, favorable operating results of the Sports Core Fund are largely dependent on favorable
weather, annual increases in user fee revenue, and improved financial results of the Food and Beverage operations. Capital improvements
completed over the past several years were planned with a view toward making more favorable operating results possible on an annual basis.
44
Cash Available, January 1, 2017
Estimated Income
Less Estimated Operating Expenses
Operating Budget
Exceptional Charges
Estimated Net Operating Income
Add Beginning of Year Cash Balance
Estimated Available Funds
Less Capital Improvement Program
Estimated Cash Balance at Year -End
$700,649
Village of Oak Brook
2017-2021 Five -Year Financial Plan
SPORTS CORE FUND -CONSOLIDATED
Summary
2017 2017 2018 2019 2020 2021 2022
Budget Estimate Budget Projection Projection Projection Projection
$3,377,485 $3,417,955 $3,410,725 $3,459,957 $3,510,082 $3,561,326 $3,613,717
3,151,485
3,052,385
2,896,445
3,002,754
3,113,068
3,227,548
3,346,362
0
429,820
133,875
136,404
139,009
141,692
144,455
226,000
(64,250)
380,405
320,799
258,005
192,086
122,900
700,649
700,649
360,864
375,609
366,408
380,413
357,499
926,649
636,399
741,269
696,408
624,413
572,499
480,399
226,000
275,535
365,660
330,000
244,000
215,000
238,000
$700,649
$360,864
$375,609
$366,408
$380,413
$357,499
$242,399
45
Sports Core Operations
Golf Surcharge
Total
Village of Oak Brook
2017-2021 Five -Year Financial Plan
SPORTS CORE FUND -CONSOLIDATED
Revenue Projections
2017
Budget
$3,264,985
112,500
2017 2018 2019 2020 2021 2022
Estimate Budget Projection Projection Projection Projection
$3,417,955 $3,410,725 $3,459,957 $3,510,082 $3,561,326 $3,613,717
0 0 0 0 0 0
$3,377,485 $3,417,955 $3,410,725 $3,459,957 $3,510,082 $3,561,326 $3,613,717
46
Personnel
Materials and Supplies
Operations and Contractual
Other
Total
Exceptional Charges
Golf Cart Lease
Reimbursement to General Fund
Transfer to Golf Surcharge Fund
Total
Capital Improvement Program
Sports Core Operations
Total
Total Budget
Village of Oak Brook
0
49,575
49,575
49,575
2017-2021 Five -Year Financial Plan
49,575
0
0
84,300
SPORTS CORE FUND -CONSOLIDATED
89,434
92,117
94,880
0
Long -Range Operating Budget
0
0
0
0
2017 2017 2018
2019
2020
2021
2022
Budget Estimate Budget
Projection
Projection
Projection
Projection
$1,609,185 $1,530,325 $1,497,200
$1,564,574
$1,634,980
$1,708,554
$1,785,439
700,870 709,990 615,885
631,282
647,064
663,241
679,822
1,047,630 1,018,270 961,510
985,048
1,009,174
1,033,903
1,059,251
(206,200) (206,200) (178,150)
(178,150)
(178,150)
(178,150)
(178,150)
$3,151,485 $3,052,385 $2,896,445
$3,002,754
$3,113,068
$3,227,548
$3,346,362
0
0
49,575
49,575
49,575
49,575
49,575
0
0
84,300
86,829
89,434
92,117
94,880
0
429,820
0
0
0
0
0
$0
$429,820
$133,875
$136,404
$139,009
$141,692
$144,455
226,000 275,535 365,660 330,000 244,000 215,000 238,000
$226,000 $275,535 $365,660 $330,000 $244,000 $215,000 $238,000
$3,377,485 $3,757,740 $3,395,980 $3,469,158 $3,496,077 $3,584,240 $3,728,817
47
VILLAGE OF OAK BROOK
2018-2022
FIVE-YEAR FINANCIAL PLAN
SPORTS CORE FUND
Operations
The Sports Core Fund Operations presentation combines the operating projections for the Golf Club, Bath and Tennis Club, Sports Core Food
and Beverage operations, and open fields operations. It also includes capital expenditures for equipment and similar purposes not assigned to
the Golf Surcharge Account.
OVERVIEW:
Revenue: The total number of Golf Club members is projected at 150 throughout the planning period. For years 2019 - 2022, memberships
are to remain flat and membership fees are increased 3% per year. Daily greens fees increase $.50 to $1.00 per round per year. Other revenues
are adjusted consistent with market factors.
Membership revenue for the Bath & Tennis Club is budgeted to decrease 18.2% over the 2017 budgeted amounts. In 2019 and thereafter,
3% increase in the number of members is included as well as a $25 annual increase in rates for all membership categories.
Food and Beverage revenue is budgeted to increase by $36,650, or 6.9%, in 2018 compared to the 2017 budget. In 2019 and thereafter, rental
income revenue is projected to increase 2.5%.
Operations: The Bath and Tennis Clubhouse will continue to market the preferred caterer (partner) concept to our wedding and special event
clients.
Capital Improvements: The capital improvement program in the Sports Core Fund Operations presentation reflects an ongoing program of
maintaining existing equipment and facilities. The 2018 budget includes $365,660 in capital improvements.
48
Cash Available, January 1, 2017
Estimated Income
Less Estimated Operating Expenses
Operating Budget
Exceptional Charges
Estimated Net Operating Income
Add Beginning of Year Cash Balance
Estimated Available Funds
Adjusted Cash Available
Less Capital Improvement Program
Estimated Cash Balance at Year -End
$270,829
Village of Oak Brook
2017-2021 Five -Year Financial Plan
SPORTS CORE FUND OPERATIONS
Summary
2017 2017 2018 2019 2020 2021 2022
Budget Estimate Budget Projection Projection Projection Projection
$3,264,985 $3,417,955 $3,410,725 $3,459,957 $3,510,082 $3,561,326 $3,613,717
3,151,485
3,052,385
2,896,445
3,002,754
3,113,068
3,227,548
3,346,362
0
0
133,875
136,404
139,009
141,692
144,455
113,500
365,570
380,405
320,799
258,005
192,086
122,900
270,829
270,829
360,864
375,609
366,408
380,413
357,499
384,329
636,399
741,269
696,408
624,413
572,499
480,399
384,329
636,399
741,269
696,408
624,413
572,499
480,399
226,000
275,535
365,660
330,000
244,000
215,000
238,000
158,329
360,864
375,609
366,408
380,413
357,499
242,399
49
Village of Oak Brook
2017-2021 Five -Year Financial Plan
SPORTS CORE FUND OPERATIONS
Revenue Projections
2017 2017 2018 2019 2020 2021 2022
Budget Estimate Budget Projection Projection Projection Projection
Bath & Tennis Club:
General Administration
Miscellaneous
$200
($3,065)
$0
$200
$200
$200
$200
Grants
$0
$0
$0
$0
$0
$0
$0
Transfer From General Fund
73,505
0
0
A
0
0
0
Transfer From Infrastructure Fund
24,000
24,000
24,000
24,000
24,000
24,000
24,000
Transfer From Water Fund
8,000
8,000
8,000
8,000
8,000
8,000
8,000
Swimming
Grants
0
0
0
0
0
0
0
Miscellaneous
0
3,370
3,000
3,000
3,000
3,000
3,000
Membership Allocation
246,830
215,750
207,175
213,390
219,792
226,386
233,177
Swim Fees
72,500
88,740
89,200
91,876
94,632
97,471
100,395
Tennis
Grants
0
0
0
0
0
0
0
Membership Allocation
26,250
7,385
16,200
16,686
17,187
17,702
18,233
Tennis Lessons and Programs
51,750
16,700
11,500
11,845
12,200
12,566
12,943
Beverage & Pro Shop Revenue
300
0
0
0
0
0
0
Miscellaneous
0
125
0
0
0
0
0
Polo
Food Sales
0
0
0
0
0
0
0
Sponsorships, Memberships, & Admissions
0
0
0
0
0
0
0
Transfer From General Fund
0
0
0
0
0
0
0
Open Fields
Grants
0
0
0
0
0
0
0
Field Rental
265,000
265,000
200,000
206,000
212,180
218,545
225,102
Sponsorships, Memberships, & Admissions
180,000
188,375
185,000
185,000
185,000
185,000
185,000
Total Bath & Tennis Club
$948,335
$814,380
$744,075
$759,997
$776,191
$792,871
$810,051
50
Village of Oak Brook
2017-2021 Five -Year Financial Plan
SPORTS CORE FUND OPERATIONS
Revenue Projections
2017 2017 2018 2019 2020 2021 2022
Budget Estimate Budget Projection Projection Projection Projection
Food & Beverage:
Clubhouse Food & Beverage
B&T Membership Allocation
4,500
2,400
0
0
0
0
0
Rental Income
165,000
180,000
187,500
192,188
196,992
201,917
206,965
Miscellaneous
0
2,200
0
0
0
0
0
Poolside Grill
255,250
272,500
350,000
350,000
350,000
350,000
350,000
Food Sales
42,000
40,275
6,000
6,150
6,304
6,461
6,623
Beverage/LiquorSales
19,000
20,780
3,000
3,075
3,152
3,231
3,311
Golf Club Lounge
$1,784,300
$1,988,920
$2,097,650
$2,116,735
$2,136,085
$2,155,704
$2,175,597
Food Sales
112,350
121,000
125,000
128,125
131,328
134,611
137,977
Beverage/Liquor Sales
180,000
233,000
233,000
238,825
244,796
250,916
257,188
Candy/Cigarette Sales
9,500
15,000
14,500
14,863
15,234
15,615
16,005
Total Food & Beverage
$532,350
$614,655
$569,000
$583,225
$597,806
$612,751
$628,070
Golf Club:
Memberships
$166,000
$189,965
$191,500
$193,415
$195,349
$197,303
$199,276
Golf Fees
840,000
929,000
975,000
984,750
994,598
1,004,543
1,014,589
Merchandise Sales
195,500
205,000
205,500
205,500
205,500
205,500
205,500
Driving Range Fees
255,250
272,500
350,000
350,000
350,000
350,000
350,000
Cart Rental Fees
325,500
370,500
371,000
378,420
385,988
393,708
401,582
Miscellaneous
2,050
21,955
4,650
4,650
4,650
4,650
4,650
Total Golf Club
$1,784,300
$1,988,920
$2,097,650
$2,116,735
$2,136,085
$2,155,704
$2,175,597
Total Sports Core Operations
$3,264,985
$3,417,955
$3,410,725
$3,459,957
$3,510,082
$3,561,326
$3,613,717
51
Exceptional Charges
Golf Cart Lease $0 $0 $49,575 $49,575 $49,575 $49,575 $49,575
Reimbursement to General Fund 0 0 84,300 86,829 89,434 92,117 94,880
Total $0 $0 $133,875 $136,404 $139,009 $141,692 $144,455
Capital Improvement Program
(See Schedule) $226,000 $275,535 $365,660 $330,000 $244,000 $215,000 $238,000
Total Budget $3,377,485 $3,327,920 $3,395,980 $3,469,158 $3,496,077 $3,584,240 $3,728,817
52
Village of Oak Brook
2017-2021 Five -Year Financial Plan
SPORTS CORE FUND OPERATIONS
Long -Range Operating Budget
2017 2017 2018
2019
2020
2021
2022
Budget Estimate Budget
Projection
Projection
Projection
Projection
Personnel
$1,609,185 $1,530,325 $1,497,200
$1,564,574
$1,634,980
$1,708,554
$1,785,439
Materials and Supplies
700,870 709,990 615,885
631,282
647,064
663,241
679,822
Operations and Contractual
1,047,630 1,018,270 961,510
985,048
1,009,174
1,033,903
1,059,251
Other
(206,200) (206,200) (178,150)
(178,150)
(178,150)
(178,150)
(178,150)
Total
$3,151,485 $3,052,385 $2,896,445
$3,002,754
$3,113,068
$3,227,548
$3,346,362
Exceptional Charges
Golf Cart Lease $0 $0 $49,575 $49,575 $49,575 $49,575 $49,575
Reimbursement to General Fund 0 0 84,300 86,829 89,434 92,117 94,880
Total $0 $0 $133,875 $136,404 $139,009 $141,692 $144,455
Capital Improvement Program
(See Schedule) $226,000 $275,535 $365,660 $330,000 $244,000 $215,000 $238,000
Total Budget $3,377,485 $3,327,920 $3,395,980 $3,469,158 $3,496,077 $3,584,240 $3,728,817
52
CAPITAL REQUESTS
SPORTS CORE FUND
Bath & Tennis General Operations:
New Sign on 31st Street
B&T Clubhouse Exterior Painting
B&T A/C Unit
B&T Hot Water Heater
B&T Clubhouse Roof Scuppers
Total Program 811
Bath & Tennis Club:
Wading Pool Improvements
Main Pool Improvements
Diving Well Improvements
Pool Lounge Chairs
Pool Umbrellas
1m Dive Stand and Fulcrum
3m Dive Stand and Fulcrum
Slide
Pool Backwash Discharge to Sanitary
Sanitary Sewer Repairs B&Tto Dover
Diving Well Padding
Pool Awning Replacement
Total Program 812
15,000 905 15,000
15,000
- - - 30,000 -
- 30,000
- 25,000
- 25,000
15,000 -
- 15,000
- - - 20,000 -
- 20,000
15,000 905 15,000 65,000 25,000
- 105,000
25,000 25,000 -
- 25,000
- - 25,000 -
- 25,000
- - - - 25,000
- 25,000
6,000 19,755 19,750 -
- 19,750
- 10,315 - - - -
- -
- 17,000 - - -
- 17,000
- - 6,000 - - -
- 6,000
- - 27,000 - - -
- 27,000
- - 30,000 - -
- 30,000
- - 20,000 - -
- 20,000
- - 5,000 - -
- 5,000
- - - 30,000 -
- 30,000
31,000 30,070 149,750 55,000 25,000
- 229,750
53
CAPITAL REQUESTS
SPORTS CORE FUND
Fencing for Courts
Total Program 813
Soccer Building Siding
Total Program 816
B&T Clubhouse:
New Carpeting and Dance Floor - Oak Brook
B&T Clubhouse Faux Stone/Brick
B&T Clubhouse Interior Painting
Light Fixtures - B&T Clubhouse
B&T Clubhouse Water Infiltration
B&T Clubhouse Design Services
B&T Clubhouse Office Furniture
Dishwasher Replacement
B&T Clubhouse Bar Update
Saddle Room Floor Replacement
B&T Clubhouse Front Entrace Bird Netting
Kitchen Equipment Replacement
Generator
Designer Fee
20,000 20,000 40,000
20,000 20,000 40,000
15,000 20,625 15,000 15,000 - - - 30,000
15,000 20,625 15,000 15,000 30,000
20,000 20,430
15,000 -
- 12,040
- 10,195
- 19,000
- 14,560
- 2,155
54
30,000 30,000
- 25,000 - 25,000
20,000 - - 20,000
35,000 - - 35,000
- - 15,000 - 15,000
20,000 - - 20,000
- 20,000 20,000
5,000 5,000
CAPITAL REQUESTS
SPORTS CORE FUND
B&T Clubhouse Bathrooms
Total Program 821
Poolside Grille:
New Furniture
Total Program 822
Golf Club:
New Sign on York Road
Exterior Staining
Outdoor Furniture
Indoor Furniture
Interior Flooring
Interior Design Improvements
Parking Lot Seal Coating/Striping
Parking Lot Drainage
Cart Path Replacement
Tee Signs
HVAC Improvements
Total Program 831
- 100,000 100,000
35,000 78,380 85,000 45,000 15,000 125,000 270,000
16,375
16,375
15,000 - 15,000
- - - 20,000 20,000
35,000 20,000 - -
25,000 25,000 - -
25,000 15,000 10,000 10,000
15,000 15,000 - -
- 10,000
10,000
20,000
15,000 -
- -
- 15,000
25,000 25,000
25,000 25,000
25,000 125,000
- 10,000
- -
- 10,000
- - - -
- 45,000
- 45,000
100,000 75,000 65,000 65,000
25,000 80,000
25,000 260,000
W,
CAPITAL REQUESTS
SPORTS CORE FUND
Ball Dispenser Replacement
Picker Cart Replacement
Total Program 832
Golf Carts
9,000
9,000
8,530 - 10,000 10,000
8,530 9,000 10,000 19,000
17,775
Utility Cart Fleet - 6 Carts Total
- 40,910
40,910
Total Program 833
- 17,775 40,910
-
- 40,910
Tractors/Mowers
30,000 27,875 35,000
45,000
50,000 50,000 53,000 233,000
Dump Truck
- - 45,000
-
- - - 45,000
Utility Vehicle
- - -
-
25,000 25,000 25,000 75,000
Rough Mower
- -
25,000
- - - 25,000
Golf Maintenance Parking Lot Replacement
- - -
20,000
- - - 20,000
Total Program 834
30,000 27,875 80,000
90,000
75,000 75,000 78,000 398,000
56
VILLAGE OF OAK BROOK
2018-2022
FIVE-YEAR FINANCIAL PLAN
SPORTS CORE FUND
Golf Surcharge Account
DESCRIPTION:
The Golf Surcharge Account is the repository for revenues received from the $3.00 per round surcharge levied on every round of golf played
at the Oak Brook Golf Club. Surcharge revenues are reserved for golf course improvements and for restoration of flood damage to the course,
should it be necessary in the future.
The Golf Surcharge Account has been transferred to a separate fund in 2017.
57
Restricted Cash Available, January 1, 2017 $429,820
Estimated Income
Less Estimated Operating Expenses
Operating Budget
Exceptional Charges
Estimated Net Operating Income
Add Beginning of Year Cash Balance
Estimated Available Funds
Less Capital Improvement Program
Estimated Restricted Cash Balance at Year -End
Village of Oak Brook
2017-2021 Five -Year Financial Plan
SPORTS CORE FUND -GOLF SURCHARGE ACCOUNT
Summary
2017 2017 2018 2019 2020 2021 2022
Budget Estimate Budget Projection Projection Projection Projection
$112,500 $0 $0 $0 $0 $0 $0
0
0
0
0
0
0
0
0
429,820
0
0
0
0
0
112,500
(429,820)
0
0
0
0
0
429,820
429,820
0
0
0
0
0
542,320
0
0
0
0
0
0
0
0
0
0
0
0
0
$542,320
$0
$0
$0
$0
$0
$0
90
Account
Golf Surcharge
Interest
Total Revenue
Village of Oak Brook
2017-2021 Five -Year Financial Plan
SPORTS CORE FUND -GOLF SURCHARGE ACCOUNT
Revenue Projections
2017 2017 2018 2019 2020 2021 2022
Budget Estimate Budget Projection Projection -Projection Projection
$110,000
$0
$0
$0
$0
$0
$0
2,500
0
0
0
0
0
0
$112,500
$0
$0
$0
$0
$0
$0
59
Exceptional Charges
Transfer Out
Total Exceptional Charges
Total Budget
Village of Oak Brook
2017-2021 Five -Year Financial Plan
SPORTS CORE FUND -GOLF SURCHARGE ACCOUNT
Long -Range Operating Budget
2017 2017 2018 2019 2020 2021 2022
Budget Estimate Budget Projection Projection Projection Projection
$0 $429,820 $0 $0 $0 $0 $0
$0 $429,820 $0 $0 $0 $0 $0
$0 $429,820 $0 $0
$0 $0 $0
VILLAGE OF OAK BROOK
2018-2022
FIVE-YEAR FINANCIAL PLAN
GOLF SURCHARGE FUND
The Golf Surcharge Fund is the repository for revenues received from the $3.00 per round surcharge levied on every round of golf played at
the Oak Brook Golf Club. Surcharge revenues are reserved for golf course improvements and for restoration of flood damage to the course,
should it be necessary in the future.
OVERVIEW
Revenue: Revenue is projected based on the $3.00 surcharge applied to 40,000 rounds played.
Capital 1mnrovements: No capital improvements are included in years 2018-2022.
61
Unrestricted Cash Available, January 1, 2017
Estimated Income
Less Estimated Operating Expenses
Operating Budget
Exceptional Charges
Estimated Net Operating Income
Add Beginning of Year Cash Balance
Estimated Available Funds
Less Capital Improvement Program
Estimated restricted Cash Balance at Year -End
$0
Village of Oak Brook
2018-2022 Five -Year Financial Plan
GOLF SURCHARGE FUND
Summary
2017
2017
2018
2019
2020
2021
2022
Budget
Estimate
Budget
Projection
Projection
Projection
Projection
$0
$552,820
$123,500
$125,782
$128,859
$132,000
$135,207
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
552,820
123,500
125,782
128,859
132,000
135,207
0
0
552,820
676,320
802,102
930,961
1,062,961
0
552,820
676,320
802,102
930,961
1,062,961
1,198,168
0
0
0
0
0
0
0
$0
$552,820
$676,320
$802,102
$930,961
$1,062,961
$1,198,168
62
Village of Oak Brook
2018-2022 Five -Year Financial Plan
GOLF SURCHARGE FUND
Revenue Projections
63
2017
2017
2018
2019
2020
2021
2022
Budget
Estimate
Budget
Projection
Projection
Projection
Projection
Golf Surcharge
$0
$118,500
$120,000
$122,400
$124,848
$127,345
$129,892
Interest
0
4,500
3,500
3,382
4,011
4,655
5,315
Transfer From Sports Core Fund
0
429,820
0
0
0
0
0
Total Revenue
$0
$552,820
$123,500
$125,782
$128,859
$132,000
$135,207
63
Village of Oak Brook
2018-2022 Five -Year Financial Plan
GOLFSURCHARGEFUND
Long -Range Operating Budget
2017 2017 2018 2019 2020 2021 2022
Budget Estimate Budget Projection Projection Projection Projection
Exceptional Charges
Transfer to Sports Core Fund $0 $0 $0 $0 $0 $0 $0
Total Exceptional Charges $0 $0 $0 $0 $0 $0 $0
64
VILLAGE OF OAK BROOK
2018-2022
FIVE-YEAR FINANCIAL PLAN
SELF-INSURANCE FUND
The Self -Insurance Fund is an internal service fund used for funding the Village's employee welfare benefit programs, including the self-
insured medical and dental plans and group life and accidental death insurance coverage. These programs also are made available to
employees of the Oak Brook Park District, retired Village employees and separated employees and their dependents pursuant to COBRA
regulations.
Revenue: Revenue comes principally from charges to other funds, through the budgets of departments where plan participants are employed,
charges to the Oak Brook Park District, charges to retirees, and charges to COBRA participants. The Plan also reflects increased participant
contribution to the cost of health and dental insurance for all covered Village employees. Revenue from equivalent premiums is projected to
increase at a rate sufficient to fund projected expenses.
Operations: Since 2012, the amount expended for health insurance claims has moderated due primarily to a change in the third party
administrator to Blue Cross/Blue Shield and alternative plan offerings. The Village offers a PPO, HMO alternative and High Deductible plans
to all employees. For 2018, claims are projected based on various rates used to set equivalent premiums. For 2019 and beyond, a claims
inflation factor of 5% per year has been used. Other expenses, including reinsurance costs, are also projected to increase 3% to 5% annually,
beginning in July 2018.
FUTURE CONSIDERATIONS: The future of health insurance is changing and the Affordable Care Act (ACA) presents the Village a
number of challenges in forecasting and budgeting for federally mandated increases in benefits and taxes. We will continue to conservatively
budget in order to prepare for unforeseen circumstances related to the on-going implementation of the ACA.
65
Unrestricted Cash Available, January 1, 2017
Estimated Income
Less Estimated Operating Expenses
Operating Budget
Exceptional Charges
Estimated Net Operating Income
Add Beginning of Year Cash Balance
Estimated Available Funds
Less Capital Improvement Program
Estimated Unrestricted Cash Balance at Year -End
$589,849
Village of Oak Brook
2018-2022 Five -Year Financial Plan
SELF-INSURANCE FUND
Summary
2017
2017
2018
2019
2020
2021
2022
Budget
Estimate
Budget
Projection
Projection
Projection
Projection
$3,203,000
$3,134,390
$3,259,330
$3,421,420
$3,592,135
$3,771,400
$3,959,620
0
0
0
0
0
0
0
3,238,150
3,355,305
3,317,920
3,442,445
3,599,060
3,763,100
3,934,920
(35,150)
(220,915)
(58,590)
(21,025)
(6,925)
8,300
24,700
589,849
589,849
368,934
310,344
289,319
282,394
290,694
554,699
368,934
310,344
289,319
282,394
290,694
315,394
0
0
0
0
0
0
0
$554,699
$368,934
$310,344
$289,319
$282,394
$290,694
$315,394
m
Village Contributions
Participant Contributions
Park District Contributions
Retiree Contributions
Cobra Contributions
Interest
Transfer from General Corporate Fund
Total Revenue
Village of Oak Brook
2018-2022 Five -Year Financial Plan
SELF-INSURANCE FUND
Revenue Projections
2017
2017
2018
2019
2020
2021
2022
Budget
Estimate
Budget
Projection
Projection
Projection
Projection
$1,701,500
$1,582,045
$1,692,705
$1,777,340
$1,866,205
$1,959,520
$2,057,495
434,000
419,750
427,000
448,350
470,765
494,305
519,020
563,000
614,935
635,000
666,750
700,085
735,090
771,845
503,500
484,945
497,125
521,980
548,080
575,485
604,260
0
28,000
5,000
5,000
5,000
5,000
5,000
1,000
4,715
2,500
2,000
2,000
2,000
2,000
0
0
0
0
0
0
0-
$3,203,000
$3,134,390
$3,259,330
$3,421,420
$3,592,135
$3,771,400
$3,959,620
67
Exceptional Charges
Stop -Loss Premiums
HMO Premiums
Vision Insurance Premiums
Life Insurance Premiums
Health Claims
Dental Claims
Plan Administration Expense
Total Exceptional Charges
K9
Village of Oak Brook
2018-2022 Five -Year Financial Plan
SELF-INSURANCE FOND
Long -Range Operating Budget
2017
2017 2018
2019
2020
2021
2022
Budget
Estimate Budget
Projection
Projection
Projection
Projection
$305,000
$212,895 $285,000
$290,950
$297,030
$303,235
$309,570
355,000
365,515 380,000
399,000
418,950
439,900
461,890
8,150
7,700 8,400
8,650
8,910
9,180
9,455
25,000
20,810 22,000
22,660
23,340
24,040
24,760
2,155,000
2,376,475 2,225,000
2,310,000
2,425,500
2,546,775
2,674,115
175,000
161,475 174,000
180,960
188,200
195,725
203,555
215,000
210,435 223,520
230,225
237,130
244,245
251,575
$3,238,150
$3,355,305 $3,317,920
$3,442,445
$3,599,060
$3,763,100
$3,934,920
K9
VILLAGE OF OAK BROOK
2018-2022
FIVE-YEAR FINANCIAL PLAN
GARAGE FUND
This fund is an internal service fund financed by charges to Village departments for maintenance of vehicle fleet equipment. Expenditures
support the operation and maintenance of cars, trucks, most fire equipment, public works construction equipment and related items.
Revenue: Revenues are calculated as charge -backs to various operating budget programs based on historical fuel and maintenance cost
information.
Operations: All costs associated with operation and maintenance of the Village's vehicle and equipment fleet are charged to this fund.
Annual transfers to the General Corporate Fund for administrative services are also included. The projections include increases in the cost of
fuel due to elevated oil prices as well as increases in the cost of repairs. A mechanic position has been eliminated and replaced with 50% of
the salary and benefits of a new Fleet/Facility Maintenance Supervisor position.
Capital Expenditures: No capital expenditures are planned for 2018. A floor lift for $20,000 is planned for 2020.
M
Village of Oak Brook
2018-2022 Five -Year Financial Plan
GAPAGEFUND
Summary
2017 2017 2018 2019 2020 2021 2022
Budget Estimate Budget Projection Projection Projection Projection
Unrestricted Cash Available, January 1, 2017 $347,053
Estimated Income $744,675 $747,625 $612,730 $800,390 $824,365 $848,995 $874,419
Less Estimated Operating Expenses
Operating Budget
763,755
648,430
751,560
749,304
772,823
797,145
822,301
Exceptional Charges
46,620
46,620
45,620
52,015
54,182
56,458
58,848
Estimated Net Operating Income
(65,700)
52,575
(184,450)
(929)
(2,640)
(4,608)
(6,730)
Add Beginning of Year Cash Balance
347,053
347,053
391,128
206,678
205,749
183,109
178,501
Estimated Available Funds
281,353
399,628
206,678
205,749
203,109
178,501
171,771
Less Capital Improvement Program
8,500
8,500
0
0
20,000
0
0
Estimated Unrestricted Cash Balance at Year -End
$272,853
$391,128
$206,678
$205,749
$183,109
$178,501
$171,771
70
71
Village of Oak Brook
2018-2022 Five -Year Financial Plan
GARAGEFUND
Revenue Projections
2017
2017 2018
2019
2020
2021
2022
Budget
Estimate Budget
Projection
Projection
Projection
Projection
Vehicle 0 & M Charges
$743,875
$743,875 $611,230
$799,270
$823,248
$847,946
$873,384
Interest
300
2,500 1,000
620
617
549
536
Miscellaneous
500
1,250 500
500
500
500
500
Total Revenue
$744,675
$747,625 $612,730
$800,390
$824,365
$848,995
$874,419
71
Personnel
Materials and Supplies
Operations and Contractual
Total Operating Budget
Exceptional Charges
Reimbursement to Infrastructure Fund
Vehicle Replacement Charge
Total Exceptional Charges
Capital Improvement Program
Floor Lift
Vehicle Exhaust, Lift Arms
Total Capital Improvement Program
Total Budget
Village of Oak Brook
2018-2022 Five -Year Financial Plan
GARAGEFUND
Long -Range Operating Budget
2017 2017 2018 2019 2020 2021 2022
Budget Estimate Budget Projection Projection Projection Projection
$253,495 $155,170 $229,010 $239,315 $250,085 $261,338 $273,099
230,390 213,740 224,040 229,641 235,382 241,267 247,298
279,870 279,520 298,510 280,348 287,356 294,540 301,904
$763,755 $648,430 $751,560 $749,304 $772,823 $797,145 $822,301
$40,135
$40,135
$41,290
$43,355
$45,522
$47,798
$50,188
6,485
6,485
4,330
8,660
8,660
8,660
8,660
$46,620
$46,620
$45,620
$52,015
$54,182
$56,458
$58,848
0
0
0
0
20,000
$0
$0
8,500
8,500
0
0
0
0
0
$8,500
$8,500
$0
$0
$20,000
$0
$0
$818,875
$703,550
$797,180
$801,319
$847,005
$853,604
$881,149
72
CAPITAL REQUESTS
GARAGEFUND
Floor Lift
Vehicle Exhaust, Lift Arms 8,500 8,500
Total Program 341
20,000
20,000
8,500 8,500 20,000 20,000
73
VILLAGE OF OAK BROOK
2018-2022
FIVE-YEAR FINANCIAL PLAN
EQUIPMENT REPLACEMENT FUND
This fund was created as a means of pre -funding replacement of major capital equipment, primarily vehicles. It has been supported by other
funds, principally the General Corporate, Infrastructure, and Water Funds, through vehicle user charges. This fund is utilized solely for
replacement of fleet equipment. Acquisition of new equipment (i.e., not as replacements) is reflected in the fund where the using department
or division resides.
Revenue: Prior to 2002, revenues were calculated as charge -backs to various operating budget programs based on future replacement cost and
funded over the remaining life of existing vehicles and equipment. In 2002, the charge -back attributable to the General Corporate Fund was
eliminated and replaced with 20% of utility tax collections (i.e. 1% of the total 5% rate). For 2003 and 2004, the Equipment Replacement
Fund's share of utility tax collections was redirected to the General Corporate Fund in order to fund operating needs (the General Corporate
Fund share was not funded). For 2005 and thereafter there is a return to the 2002 practice whereby operating budget programs are assessed a
charge -back based on future replacement cost.
Exceptional Charges: None in 2018.
Capital Expenditures: The capital program reflects normal scheduled replacements of existing fleet vehicles. The actual timing of the
replacement will be based on mileage, condition, and maintenance history of the vehicle at that time. The deferral of the replacement of some
vehicles from the schedule contained here is likely to occur.
74
Village of Oak Brook
2018-2022 Five -Year Financial Plan
EQUIPMENT REPLACEMENT FUND
Summary
75
2017
2017
2018
2019
2020
2021
2022
Budget
Estimate
Budget
Projection
Projection
Projection
Projection
Unrestricted Cash Available, January 1, 2017 $1,502,658
Estimated Income
$667,330
$821,760
$402,940
$759,920
$822,380
$835,740
$839,185
Less Estimated Operating Expenses
Operating Budget
0
0
0
0
0
0
0
Exceptional Charges
0
0
0
0
0
0
0
Estimated Net Operating Income
667,330
821,760
402,940
759,920
822,380
835,740
839,185
Add Beginning of Year Cash Balance
1,502,658
1,502,658
1,801,233
1,589,968
1,662,488
1,981,573
2,408,828
Estimated Available Funds
2,169,988
2,324,418
2,204,173
2,349,888
2,484,868
2,817,313
3,248,013
Less Capital Improvement Program
473,370
523,185
614,205
687,400
503,295
408,485
557,725
Estimated Unrestricted Cash Balance at Year -End
$1,696,618
$1,801,233
$1,589,968
$1,662,488
$1,981,573
$2,408,828
$2,690,288
75
Village of Oak Brook
2018-2022 Five -Year Financial Plan
EQUIPMENT REPLACEMENT FUND
Revenue Projections
76
2017
2017
2018
2019
2020
2021
2022
Budget
Estimate
Budget
Projection
Projection
Projection
Projection
Vehicle Replacement Charges
605,330
605,330
340,940
697,920
760,380
773,740
777,185
Grants
0
148,930
0
0
0
0
0
Interest
12,000
17,500
12,000
12,000
12,000
12,000
12,000
Sales/Insumnce Proceeds
50,000
50,000
50,000
50,000
50,000
50,000
50,000
Total Revenue
$667,330
$821,760
$402,940
$759,920
$822,380
$835,740
$839,185
76
Exceptional Charges
Transfer to General Fund
Total Exceptional Charges
Capital Improvement Program
(See Schedule)
Total Budget
Village of Oak Brook
2018-2022 Five -Year Financial Plan
EQUIPMENT REPLACEMENT FUND
Long -Range Operating Budget
2017 2017 2018
2019
2020
2021
2022
Budget Estimate Budget
Projection
Projection
Projection
Projection
$0 $0 $0
$0
$0
$0
$0-
$0 $0 $0
$0
$0
$0
$0-
$473,370 $523,185 $614,205
$687,400
$503,295
$408,485
$557,725
$1,140,700 $1,344,945 $1,017,145
$1,447,320
$1,325,675
$1,244,225
$1,396,910
MA
CAPITAL REQUESTS
EQUIPMENT REPLACEMENT FUND
General Management Vehicles
-
-
-
15,000
- -
-
15,000
Engineering Vehicles
-
-
27,000
15,000
- -
-
42,000
Police Vehicles
115,500
118,860
68,000
391,650
255,940 127,485
356,935
1,200,010
Fire and EMS Vehicles
182,500
228,955
317,000
75,000
43,325 281,000
-
716,325
Public Works Vehicles
107,000
107,000
122,415
125,750
204,030 -
169,105
621,300
Water Vehicles
68,370
68,370
79,790
65,000
- -
31,685
176,475
Total Program 342
473,370
523,185
614,205
687,400
503,295 408,485
557,725
2,771,110
78