12 - December 2020 Monthly Financial ReportVILLAGE
OAK BROOK
OF
MONTHLY FINANCIAL REPORTS
DECEMBER 2020
Cash and Investments by Fund:Total
Cash and Cash Pooled Cash and
Fund Equivalents Investments Investments % By Fund
General Corporate $9,868,007 $14,155,372 $24,023,379 53.5%
Hotel/Motel Tax 1,713,259 2,763,451 4,476,710 10.0%
Motor Fuel Tax 673,017 35,493 708,510 1.6%
Infrastructure 5,521,032 2,046,737 7,567,769 16.8%
Promenade TIF 259,885 - 259,885 0.6%
Water 3,303,804 3,596,329 6,900,133 15.4%
Sports Core 122,234 - 122,234 0.3%
Golf Surcharge 132,593 - 132,593 0.3%
Self-Insurance (272,398)- (272,398) -0.6%
Garage 298,348 - 298,348 0.7%
Equipment Replacement 283,035 413,357 696,392 1.6%
Total $21,902,816 $23,010,739 $44,913,555 100.0%
Change in Cash and Investments by Fund :
Balance at Balance at Year-to-Date Year-to-Date
Fund January 1, 2020 December 31, 2020 Change ($)Change (%)
General Corporate $21,270,239 $24,023,379 $2,753,140 12.9%
Hotel/Motel Tax 5,427,474 4,476,710 (950,764)-17.5%
Motor Fuel Tax 1,085,595 708,510 (377,085)-34.7%
Infrastructure 8,217,724 7,567,769 (649,955)-7.9%
Promenade TIF 304,194 259,885 (44,309)-14.6%
Water 6,947,239 6,900,133 (47,106)-0.7%
Sports Core 231,216 122,234 (108,982)-47.1%
Golf Surcharge 347,066 132,593 (214,473)-61.8%
Self-Insurance 308,820 (272,398)(581,218)-188.2%
Garage 275,988 298,348 22,360 8.1%
Equipment Replacement 808,879 696,392 (112,487)-13.9%
$45,224,434 $44,913,555 ($310,879)-0.7%
Book Bank/Market
Value Value
Cash and Cash Equivalents:
Pooled Checking $560,002 $1,400,585
Sports Core Checking 194,685 188,527
Pooled IPTIP 21,068,469 21,068,469
Water E-Pay IPTIP 79,660 60,582
$21,902,816 $22,718,163
Pooled Investments:
Investments-Municipal Bonds $8,932,407 $9,002,245
Investments-Corporate Bonds 8,647,170 8,705,727
Government & Agency Obligations 1,577,812 1,609,760
Certificates of Deposit 3,675,000 3,718,417
Accrued Interest 178,350 178,350
Total Pooled Investments $23,010,739 $23,214,499
Total Cash and Investments $44,913,555 $45,932,662
For December, total interest revenue is $32,477 and YTD is $621,717. The total investment yield for the portfolio is:
Pooled
Investments Illinois Funds Total
Last 12 months yield 2.03%0.65%1.40%
The weighted average yield of the current investment portfolio is 1.53%. The IL Funds December average daily rate was 0.093%.
Monthly Treasurer's Report
December 31, 2020
Monthly Treasurer's Report
December 31 2020
The table below lists the detail investment holdings at J.P. Morgan Securities as of 12/31/20:
Month End VOB
Settlement Maturity Coupon Yield Book Market Accrued
Type Date Date Rate Rate Value Value Interest
Municipal Bonds:
New York N Y City #64971QTX1 02/22/16 05/01/21 2.350%2.000%$200,217 $201,286 $769
Bloomingdale Mich Pub Sch Dist #094383FS0 04/26/16 05/01/22 2.710%2.150%503,610 514,745 2,219
Connecticut St GO Bds 2016 #20772J3F7 06/15/17 08/15/21 1.750%2.300%498,331 503,855 3,252
State of IL #452152P54 10/09/19 11/01/21 5.000%1.870%512,953 514,155 3,916
Anchor Bay Mich Sch #032879TE8 11/01/19 05/01/21 2.320%1.750%716,363 719,712 2,626
Brownsville TX #16405ST9 12/19/19 02/15/22 2.050%2.000%555,299 564,796 4,140
Laredo TX Waterworks #517039VW0 12/19/19 03/01/24 2.230%2.230%455,000 475,703 3,326
Oakland Univ Mich #673588HJ1 04/29/20 03/01/24 5.000%1.650%325,339 332,329 4,917
Philadelphia PA GO Ref #717813SW0 05/05/20 08/01/22 5.000%1.820%409,351 417,386 7,922
Maryland St DOT #574204WG4 05/06/20 06/15/22 4.350%1.200%271,848 274,732 386
University of CA #91412HFK4 07/16/20 05/15/23 0.628%0.628%25,000 25,158 20
Windsor NY Sch Dist #973675EW7 07/23/02 06/17/21 1.500%0.400%477,387 477,275 3,141
Waterford Mich Sch Dist #941468YZ7 08/20/20 08/24/21 4.000%0.301%511,951 511,405 7,259
Weedsport NY Cent Sch Dist #948543KA0 08/21/20 08/20/21 1.000%0.570%501,359 500,870 1,801
Universty of IL #914353YH4 08/31/20 10/01/21 3.000%0.701%254,289 254,073 1,875
New Jersey St #646039UD7 09/20/20 06/01/22 5.000%0.600%504,483 505,661 1,913
Alaska St GO #011770Z72 10/14/2020 8/1/2021 5.000%0.252%179,862 179,811 3,622
Rio Rancho NM #767175HM7 10/14/2020 5/15/2022 5.000%0.350%196,787 197,064 1,156
Cook, Kane, Lake, & McHenry #216181GL5 10/29/2020 12/15/2022 4.000%0.300%1,098,886 1,099,507 7,054
Miami-Dade Cnty #59333NN90 10/29/2020 12/15/2022 0.375%0.430%734,092 732,722 681
Total Municipal Bonds $8,932,407 $9,002,245 $61,995
Corporate Bonds:
Morgan Stanley #61747WAL3 03/08/19 07/28/21 5.500%3.034%1,064,382 1,080,870 24,384
Citigroup #172967LC3 04/01/19 12/08/21 2.900%2.754%1,001,434 1,021,610 1,289
Goldman Sachs #38143U8F1 05/02/19 02/25/21 2.875%2.707%365,078 365,679 3,646
American Honda #02665WBG5 07/31/19 09/09/21 1.700%2.180%498,387 504,705 2,667
BB&T Corp #05531FAZ6 08/15/19 02/01/21 2.150%2.010%750,116 750,000 6,522
JP Morgan #48128BAB7 09/30/19 01/15/23 2.972%2.337%1,012,529 1,027,240 10,894
American Express #025816CD9 05/05/20 05/20/22 2.750%1.290%510,056 515,825 1,423
Goldman Sachs #38141GGQ1 08/31/20 07/27/21 5.250%0.251%354,853 354,688 7,748
PNC Bank #69349LAK4 12/7/2020 1/30/2023 2.950%0.457%1,072,586 1,072,632 12,538
Wells Fargo #94974BFJ4 12/7/2020 2/13/2023 3.450%0.480%1,476,736 1,473,053 18,250
Comerica Bank #200340AS6 12/23/2020 7/31/2023 3.700%0.500%541,013 539,425 7,708
Total Corporate Bonds $8,647,170 $8,705,727 $97,069
Government & Agency Obligations:
*Government National Mtg Assn #38379UEM4 02/29/16 02/16/51 2.300%2.245%$451,489 $445,753 $2,218
*Government National Mtg Assn #38381WV96 08/06/19 07/20/54 2.250%2.293%611,410 627,732 1,042
*Government National Mtg Assn #38380BNV3 12/05/19 06/20/46 2.000%2.112%514,913 536,275 776
Total Government & Agency Obligations:$1,577,812 $1,609,760 $4,036
Certificates of Deposit:
State Bk India NY #8562846A7 01/26/17 01/26/22 2.250%2.250%$245,000 $250,750 $2,382
Jackson Cnty Bk #466682AP6 08/31/17 03/01/21 1.850%1.850%245,000 245,742 1,511
Comenity Cap Bank #20033AU46 04/15/19 04/15/21 2.500%2.500%245,000 246,754 227
Morgan Stanley #61760AE21 05/30/19 06/01/21 2.400%2.400%245,000 247,440 490
First St Bank DeQueen #336460CU2 07/18/19 07/19/21 2.000%2.000%245,000 247,656 178
Bank Hapoalim #06251AW89 07/19/19 07/19/21 2.000%2.000%245,000 247,791 2,372
Capital One Natl Assn #14042RMF5 07/24/19 07/26/19 2.050%2.050%245,000 247,818 2,288
TIAA FSB Jacksonville #87270LCN1 07/29/19 07/29/21 2.000%2.000%245,000 247,788 2,069
Wells Fargo #949763J31 09/18/19 09/20/21 1.850%1.850%245,000 248,200 180
BMW Bank #05580ASQ8 10/11/19 10/12/21 1.800%1.800%245,000 248,369 907
Wells Fargo #949495AN5 01/17/20 01/18/22 1.800%1.800%245,000 249,476 179
Bank Leumi #063248KQ0 03/31/20 03/31/22 1.250%1.250%245,000 248,633 753
Capital One Natl Assn #14042TCZ8 04/01/20 04/01/22 1.350%1.350%245,000 248,932 813
Synchrony Bank #87164WZN1 04/03/20 04/04/22 1.350%1.350%245,000 248,957 795
Wells Fargo #95001DAB6 06/17/20 06/17/23 1.200%1.200%245,000 244,111 106
Total Certificates of Deposits $3,675,000 $3,718,417 $15,250
Total J.P.Morgan Securities $22,832,389 $23,036,149 $178,350
*This is a mortgage backed security that receives principal payments each month based on mortgage repayments. Monthly principal payments will vary and the
investment balance may be repaid before the maturity date.
VILLAGE OF OAK BROOK
Monthly Treasurer's Report
December 31, 2020
Cash & Investments by Fund - Total $44.9 million
Cash & Investments by Type - Total $44.9 million
Checking
Illinois Funds
Certificates of Deposit
Municipal Bonds
Corporate Bonds
Government & Agency Obligations
Accrued Interest
General Corporate
52.8%
Hotel/Motel Tax
9.8%
Motor Fuel Tax
1.6%
Infrastructure
16.6%
Promenade TIF
0.6%
Water
15.2%
Sports Core
0.3%
Golf Surcharge
0.3%
Self-Insurance
-0.6%Garage
0.7%
Equipment
Replacement
1.5%
Checking, $0.8
Illinois Funds, $21.1
Certificates of Deposit,
$3.7
Municipal Bonds, $8.9
Corporate Bonds, $8.6
Government & Agency
Obligations, $1.6
Accrued Interest, $0.2
in millions
YTD YTD
Net Fund Budgeted
YTD YTD Increase Increase
Governmental Funds Revenues Expenditures (Decrease)(Decrease)
General Fund (Major Fund)25,641,874$ 22,936,813$ 2,705,061$ 596,930$
Main operating fund of the Village.
Hotel Fund (Major Fund)585,990$ 1,033,574$ (447,584)$ (342,350)$
Collects and spends resources from the
3% hotel/motel tax.
Motor Fuel Tax Fund 476,307$ 848,233$ (371,926)$ (1,030,750)$
Collects and spends resources from the
State motor fuel tax.
Infrastructure Fund (Major Fund)6,485,890$ 6,871,322$ (385,432)$ (6,126,010)$
Accounts for construction and maintenance of
roadways, drainage, and safety path systems.
Promenade TIF Fund (Major Fund)489,893$ 534,203$ (44,310)$ (32,290)$
Accounts for the revenues and expenditures
restricted to the Tax Increment Financing (TIF)
district located at 22nd St. and Meyers Rd.
Enterprise Funds
Water Fund (Major Fund)10,030,273$ 9,370,365$ 659,908$ (2,900,035)$
Collects user fees for the distribution of water
and maintenance of infrastructure.
Sports Core Fund (Major Fund)3,649,830$ 3,681,081$ (31,251)$ (131,330)$
Accounts for revenues and expenses relating
to administration, programs, food and beverage
operations, and golf course.
Golf Surcharge Fund 125,592$ 340,065$ (214,473)$ (282,500)$
Accounts for the collection of the $3 per round
golf surcharge.
Internal Service Funds
Self Insurance Fund 3,520,523$ 3,864,068$ (343,545)$ 27,565$
Accounts for the Village's health insurance costs
and the related contributions from the Village,
employees, retirees, and other agencies.
Garage Fund 704,182$ 684,142$ 20,040$ (49,775)$
Accounts for the maintenance of the Village's vehicle
fleet and the related departmental reimbursements.
Equipment Replacement Fund 334,592$ 447,079$ (112,487)$ 59,675$
Accounts for the replacement of the Village's vehicle
fleet and the related departmental contributions.
Further information on the Village's major funds (as indicated above) can be found on the proceeding pages.
Executive Summary on Village Funds
Through December 31, 2020
Village of Oak Brook
Monthly Financial Report – Fund Narrative
For the Period Ending December 31, 2020
The monthly financial report serves as a document to inform and update readers of the Village’s
financial current position, including historical and trend information. A detailed financial statement and
trend information is displayed for all Village major funds. A fund is considered major if it is the primary
operating of the Village (General Fund) or meets the following criteria:
Total assets/deferred outflows of resources, liabilities/deferred inflows of resources, revenues,
or expenditures/expenses of that individual governmental or enterprise fund are at least 10% of
the total for all funds of the same category or type, and
The same element of the individual fun that met the 10% test is at least 5% of the
corresponding total for all funds combined.
This report is prepared on a cash basis of accounting, meaning transactions are recognized only when
cash is increased or decreased. Transactions for each month are compared to amounts from the
Village’s annual budget, which was also prepared using the cash basis of accounting. For the Village’s
major enterprise funds (Water and Sports Core), a reconciliation is included to display results on a full
accrual basis, which is how information is presented in the Village’s annual Comprehensive Annual
Financial Report (CAFR).
The proceeding pages contain detailed information on the Village’s major funds. Highlights for each of
the Village’s funds are:
General Fund
Total revenues through December 2020 are $1,368,145, or 5.2%, lower than last December and
$486,906, or 1.9%, under budget to date. The main drivers for this are:
o Sales tax revenue, the General
Fund’s largest revenue source, is
down $838,171 from last year
and $809,203 under budget.
December 2020 collections are
the highest collections in the
previous five years as revenues
rebounded from the COVID-19
related business closures that
occurred earlier this year.
o Telecommunications/Utility Tax
is down $351,643 from last year and $207,524 under budget. This is due to a decrease
in usage from the closure of businesses during the pandemic.
o Licenses and permits revenue is down $106,286 from last year, but $534,406 over
budget. Building permit revenue was strong in 2020 with the issuance of numerous
large projects, including Hines Oak Brook Commons and Restoration Hardware.
o Charges for Services revenue is down $505,214 from last year and $411,997 under
budget. This is primarily due to a decrease in ambulance fees from fewer calls for
service due to the ongoing pandemic.
Total expenditures through December 2020 are $1,229,737, or 5.2%, lower than last year and
$2,055,598, or 8.4%, under budget to date. The main drivers for this are:
o Personnel expenditures are down $52,382 from last year, but $1,113,290 under budget.
Personnel is down and under budget due to the start of furlough days and a reduction in
overtime due to the COVID-19 pandemic.
o Operation and contract expenditures are down $354,887 from last year and $470,880
under budget. This is due to the general timing of payments compared to when they
were projected to occur. The Village has also put various projects on hold until after the
pandemic is over.
o Capital outlay expenditures are down $813,072 from last year and $389,977 under
budget. Many capital items have been put on hold for 2020 due to the current
economic state.
Hotel Tax Fund
Total revenues through December 2020 are $852,063, or 59.3%, lower than last year and
$701,510, or 54.5%, under budget. The main drivers for this are:
o Hotel tax revenue is down $819,791 from last year and $720,587 under budget. The
decrease is due to the timing of receipts being received and a reduction in room rentals
from the COVID-19 pandemic.
Total expenditures through December 2020 are $313,295, or 60.0%, higher than last year, but
$381,129, or 31.3%, under budget. The main drivers for this are:
o Operation and contract expenditures are down $159,948 from last year and $323,977
under budget. This is due to the timing of advertising payments and the cancelling of
certain campaigns. In addition, the Village rebated $70,013 of hotel tax related to
January, February, and March stays back to the hotels.
o Capital Outlay expenditures are up $473,243 from last year, but $57,152 under budget.
There was no capital activity in 2019 and certain projects were cancelled or delayed
during 2020.
Infrastructure Fund
Total revenues through December 2020 are down $731,986, or 12.4%, from last year and
$588,202, or 10.2%, under budget. The main drivers for this are:
o Non-home rule sales tax
revenue is down $582,590 from
last year and $542,129 under
budget. December 2020
collections are the highest
collections in the previous five
years as revenues rebounded
from the COVID-19 related
business closures that occurred
earlier this year.
o Interest revenue is down
$134,297 from last year and $43,052 under budget. Interest rates have dropped in
recent months compared to last year. In addition, the Infrastructure Fund’s reserve
balance has shifted to cash and other short-term investments in order to have money
available for upcoming projects.
Total expenditures through December 2020 are down $593,841, or 8.1%, from last year and
$7,010,693, or 51.1%, under budget to date. The main drivers for this are:
o Operation and contract expenditures are down $287,405 from last year and $571,338
under budget. Expenditures are under budget due to the timing of engineering
payments. Some projects have been delayed due to the current pandemic.
o Capital Outlay expenditures are down $355,033 from last year and $6,236,473 under
budget. The majority of budgeted projects have not occurred to date and may be
cancelled or delayed until 2021 or later.
Promenade TIF Fund
Total revenues through December 2020 are down $6,214, or 1.3% from last year, but $13,393,
or 2.8%, over budget. Real estate tax revenue increased slightly in 2020 compared to last year.
Interest rates have dropped in recent months compared to last year, resulting in a decrease in
interest income. Sales tax revenue has been negatively affected by the COVID-19 pandemic.
Total expenditures through December 2020 are up $69,475, or 14.9%, from last year and
$25,413, or 5.0%, over budget. The increase relates to additional principal and interest paid
towards the TIF note. Expenditures are over budget due to the timing of audit and TIF report
fees, as well as more principal paid on the note due to an increase in real estate taxes.
Water Fund
Total revenues through December 2020 are down $149,149, or 1.5%, from last year and
$666,452, or 6.2%, under budget. The main drivers for this are:
o Water sales revenue is up $197,455 from last year, but $539,361 under budget. Sales
are under budget due to the business shut downs from the COVID-19 pandemic.
o Water connection fees are down $226,040 from last year and $77,880 under budget.
Revenue is down from last year due to the opening of a large office building in 2019.
Revenue is under budget due to the delay in construction of planned development in
2020.
Total expenditures through December 2020 are down $1,253,000, or 12.4%, from last year and
$4,226,395, or 32.3%, under budget. The main drivers for this are:
o Operation and contract expenditures are down $103,618 from last year and $940,560
under budget. Expenditures are under budget due to the timing of invoices paid and
DuPage Water Commission water purchased being less than expected.
o Capital outlay expenditures are down $1,096,620 from last year and $3,138,219 under
budget. A number of budgeted projects for 2020 are on hold due to the current
pandemic.
Sports Core Fund
Total revenues through December 2020 are down $537,470, or 15.7%, from last year and
$730,531, or 20.2%, under budget to date. Most revenue sources are under budget to date in
2020 due to the COVID-19 pandemic limiting activity. Starting in 2020, the Park District took
over all Bath and Tennis Club membership sales, however, this was not factored into the 2020
budget due to the timing of the agreement. Highlights of Sports core revenues are:
o Membership revenue is down $192,994 from last year and $232,448 under budget. This
is due to a change in swimming and tennis memberships being taken over by the Park
District rather than the Village. Golf memberships are up $28,813 from last year and
$8,988 over budget to date.
o Greens Fees are up $202,476 from last year and $208,323 over budget. The golf course
was open on a limited basis until June 1, but has made up all the lost rounds since.
o Rental income is down $440,809 from last year and $472,614 under budget. This is due
to many events being cancelled this year at the B&T Clubhouse. In addition, golf cart
rental fees are under budget due to the course being closed in the spring.
Total expenditures through December 2020 are down $687,488, or 15.9%, from last year and
$1,464,984, or 28.8%, under budget to date. The main drivers for this are:
o Personnel expenditures are down $39,303 from last year and $78,141 under budget.
Personnel is down due to the COVID-19 pandemic closing Sports Core facilities for much
of spring.
o Materials & Supplies expenditures are down $68,396 from last year and $30,364 under
budget. Expenditures are down due to facilities being closed for much of the spring.
o Operation and Contractual expenditures are down $546,666 from last year and
$575,349 under budget. This is due to the outsourcing of swimming, tennis, and soccer
fields to the Park District. Previously, the Village paid the Park District $230,000 to
operate the swimming pool.
o Capital expenditures are down $83,073 from last year and $831,080 under budget. This
is due to the golf lounge renovation project and a delay in the pool renovation project
due to the COVID-19 pandemic.
12/31/20 12/31/20
12/31/19 12/31/20 YTD % of YTD 2020 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 12,530,968$ 11,692,797$ 12,502,000$ 93.5%12,502,000$ (838,171)$
Other Intergovernmental Tax*1,465,157 1,525,466 1,352,000 112.8%1,352,000 60,309
Telecommunications/Utility Tax 6,269,119 5,917,476 6,125,000 96.6%6,125,000 (351,643)
Licenses and Permits 3,630,882 3,524,596 2,990,190 117.9%2,990,190 (106,286)
Charges for Services 1,346,317 841,103 1,253,100 67.1%1,253,100 (505,214)
Fines and Penalties 203,353 193,147 227,000 85.1%227,000 (10,206)
Administrative Towing Fees 22,030 23,828 20,000 119.1%20,000 1,798
Investment Interest 463,459 352,323 415,000 84.9%415,000 (111,136)
Franchise Fees 159,169 151,877 210,000 72.3%210,000 (7,292)
Miscellaneous Income 293,170 792,866 408,095 194.3%408,095 499,696
Total Operating Revenues 26,383,624$ 25,015,479$ 25,502,385$ 98.1%25,502,385$ (1,368,145)$
OPERATING EXPENDITURES
Personnel 18,099,312$ 18,046,930$ 19,160,220$ 94.2%19,160,220$ (52,382)$
Materials and Supplies 467,578 461,172 539,170 85.5%539,170 (6,406)
Operation and Contract 3,955,667 3,600,780 4,071,660 88.4%4,071,660 (354,887)
Other Expenditures 9,537 6,547 10,000 65.5%10,000 (2,990)
Capital Outlay 1,111,125 298,053 688,030 43.3%688,030 (813,072)
Total Operating Expenditures 23,643,219$ 22,413,482$ 24,469,080$ 91.6%24,469,080$ (1,229,737)$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 2,740,405$ 2,601,997$ 1,033,305$ 1,033,305$ (138,408)$
INTERFUND TRANSACTIONS
Transfers In 508,235$ -$ -$ 0.0%-$ (508,235)$
Transfers Out (704,518) (383,561) (923,000) 41.6%(923,000) 320,957
Reimbursements From Other Funds 632,210 626,395 626,395 100.0%626,395 (5,815)
Reimbursements To Other Funds (131,100) (139,770) (139,770) 100.0%(139,770) (8,670)
Total Interfund Transactions 304,827$ 103,064$ (436,375)$ -23.6%(436,375)$ (201,763)$
NET FUND INCREASE (DECREASE)3,045,232$ 2,705,061$ 596,930$ 596,930$ (340,171)$
*Includes the collection of Income Tax, Use Tax, Road & Bridge Tax, Personal Property Replacement Tax, and Cannabis Use Tax.
Village of Oak Brook
General Fund Financial Update
For the Period Ending December 31, 2020
Total Total
Revenues Expenditures
12/31/20 Actual 25,015,479$ 22,413,482$
12/31/19 Actual 26,383,624$ 23,643,219$
% Change From Last Year -5.2%-5.2%
Major Revenues
Other Telecom/Utility Licenses &Charges for
Sales Tax Intergov. Tax Tax Permits Services
12/31/20 Actual 11,692,797$ 1,525,466$ 5,917,476$ 3,524,596$ 841,103$
12/31/19 Actual $ 12,530,968 $ 1,465,157 $ 6,269,119 $ 3,630,882 $ 1,346,317
% Change From Last Year -6.7%4.1%-5.6%-2.9%-37.5%
Five Year Trend
Major Expenditures Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
12/31/20 Actual 18,046,930$ 461,172$ 3,600,780$ 6,547$ 298,053$
12/31/19 Actual 18,099,312$ 467,578$ 3,955,667$ 9,537$ 1,111,125$
% Change From Last Year -0.3%-1.4%-9.0%-31.4%-73.2%
Five Year Trend
Expenditures by Department
12/31/19 12/31/20 12/31/20 12/31/20 2020 Difference Five
YTD YTD YTD % of Annual Prior Year
Department Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 2,383,054$ 2,192,928$ 2,556,835$ 85.8%2,556,835$ (190,126)$
Financial Services 729,357 760,422 781,455 97.3%781,455 31,065
Public Works 890,072 832,836 893,055 93.3%893,055 (57,236)
Engineering & Capital Projects 522,158 70,167 411,500 17.1%411,500 (451,991)
Library 900,987 847,066 994,410 85.2%994,410 (53,921)
Police 9,003,939 8,816,334 9,493,905 92.9%9,493,905 (187,605)
Fire 8,217,461 7,831,669 8,298,370 94.4%8,298,370 (385,792)
Development Services 996,191 1,062,060 1,039,550 102.2%1,039,550 65,869
Total Expenditures 23,643,219$ 22,413,482$ 24,469,080$ 91.6%24,469,080$ (1,229,737)$
Five Year Trend
For the Period Ending December 31, 2020
General Fund - Five Year Trend
Village of Oak Brook
Revenues Expenditures
12/31/20 12/31/20
12/31/19 12/31/20 YTD % of YTD 2020 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Hotel Tax 1,311,704$ 491,913$ 1,212,500$ 40.6%1,212,500$ (819,791)$
Investment Interest 112,418 68,551 75,000 91.4%75,000 (43,867)
Loan Interest - 9,167 - N/A - 9,167
Miscellaneous 13,931 16,359 - N/A - 2,428
Total Operating Revenues 1,438,053$ 585,990$ 1,287,500$ 45.5%1,287,500$ (852,063)$
EXPENDITURES
Operation and Contract 522,586$ 362,638$ 686,615$ 52.8%576,615$ (159,948)$
Capital Outlay - 473,243 530,395 89.2%640,395 473,243
Total Expenditures 522,586$ 835,881$ 1,217,010$ 68.7%1,217,010$ 313,295$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 915,467$ (249,891)$ 70,490$ -354.5%70,490$ (1,165,358)$
INTERFUND TRANSACTIONS
Transfer Out -$ (122,978)$ (338,125)$ 36.4%(338,125)$ (122,978)$
Reimbursements to Other Funds (103,115) (74,715) (74,715) 100.0%(74,715) 28,400
Total Interfund Transactions (103,115)$ (197,693)$ (412,840)$ 47.9%(412,840)$ (94,578)$
NET FUND INCREASE (DECREASE)812,352$ (447,584)$ (342,350)$ (342,350)$ (1,259,936)$
Note - Expenditures are recorded in program 171.
Village of Oak Brook
Hotel Tax Fund Financial Update
For the Period Ending December 31, 2020
Total Total
Revenues Expenditures
12/31/20 Actual $ 585,990 835,881$
12/31/19 Actual $ 1,438,053 522,586$
% Change From Last Year -59.3%60.0%
Major Revenues Investment
Hotel Tax Interest Loan Interest Miscellaneous
12/31/20 Actual $ 491,913 $ 68,551 9,167$ 16,359$
12/31/19 Actual $ 1,311,704 $ 112,418 -$ 13,931$
% Change From Last Year -62.5%-39.0%N/A 17.4%
Five Year Trend
Major Expenditures Operation &
Contractual Capital Outlay
12/31/20 Actual 362,638$ 473,243$
12/31/19 Actual 522,586$ -$
% Change From Last Year -30.6%N/A
Five Year Trend
Village of Oak Brook
Hotel Tax Fund - Major Sources Five Year Trend
For the Period Ending December 31, 2020
Five Year Trend
Revenues Expenditures
12/31/20 12/31/20
12/31/19 12/31/20 YTD % of YTD 2020 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Non-Home Rule Sales Tax 5,655,461$ 5,072,871$ 5,615,000$ 90.3%5,615,000$ (582,590)$
Charges for Services 1,556 335 1,000 33.5%1,000 (1,221)
Investment Interest 216,245 81,948 125,000 65.6%125,000 (134,297)
Miscellaneous 14,022 144 2,500 5.8%2,500 (13,878)
Total Operating Revenues 5,887,284$ 5,155,298$ 5,743,500$ 89.8%5,743,500$ (731,986)$
OPERATING EXPENDITURES
Personnel 1,254,044$ 1,301,098$ 1,389,540$ 93.6%1,389,540$ 47,054$
Materials and Supplies 137,312 138,855 253,295 54.8%253,295 1,543
Operation and Contract 1,572,857 1,285,452 1,856,790 69.2%1,856,790 (287,405)
Capital Outlay 4,338,650 3,983,617 10,220,090 39.0%10,220,090 (355,033)
Total Operating Expenditures 7,302,863$ 6,709,022$ 13,719,715$ 48.9%13,719,715$ (593,841)$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES (1,415,579)$ (1,553,724)$ (7,976,215)$ 19.5%(7,976,215)$ (138,145)$
INTERFUND TRANSACTIONS
Transfers In 216,125$ 971,212$ 1,653,125$ 58.8%1,653,125$ 755,087$
Reimbursements From Other Funds 333,445 359,380 359,380 100.0%359,380 25,935
Reimbursements To Other Funds (161,535) (162,300) (162,300) 100.0%(162,300) (765)
Total Interfund Transactions 388,035$ 1,168,292$ 1,850,205$ 63.1%1,850,205$ 780,257$
NET FUND INCREASE (DECREASE)(1,027,544)$ (385,432)$ (6,126,010)$ (6,126,010)$ 642,112$
Village of Oak Brook
Infrastructure Fund Financial Update
For the Period Ending December 31, 2020
Total Total
Revenues Expenditures
12/31/20 Actual $ 5,155,298 6,709,022$
12/31/19 Actual $ 5,887,284 7,302,863$
% Change From Last Year -12.4%-8.1%
Major Revenues
Sales Tax
Charges for
Services
Investment
Interest Miscellaneous
12/31/20 Actual $ 5,072,871 $ 335 $ 81,948 $ 144
12/31/19 Actual $ 5,655,461 $ 1,556 $ 216,245 $ 14,022
% Change From Last Year -10.3%-78.5%-62.1%-99.0%
Five Year Trend
Major Expenditures Materials &Operation &
Personnel Supplies Contractual Capital Outlay
12/31/20 Actual 1,301,098$ 138,855$ 1,285,452$ 3,983,617$
12/31/19 Actual 1,254,044$ 137,312$ 1,572,857$ 4,338,650$
% Change From Last Year 3.8%1.1%-18.3%-8.2%
Five Year Trend
Expenditures by Department
12/31/19 12/31/20 12/31/20 12/31/20 2020 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 167,865$ 142,587$ 176,490$ 80.8%176,490$ (25,278)$
Public Works 3,913,664 3,835,050 4,390,810 87.3%4,390,810 (78,614)
Engineering & Capital Projects 3,221,334 2,731,385 9,152,415 29.8%9,152,415 (489,949)
Total Expenditures 7,302,863$ 6,709,022$ 13,719,715$ 48.9%13,719,715$ (593,841)$
Five Year Trend
Village of Oak Brook
Infrastructure Fund - Major Sources Five Year Trend
For the Period Ending December 31, 2020
Revenues Expenditures
12/31/20 12/31/20
12/31/19 12/31/20 YTD % of YTD 2020 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 81,663$ 74,805$ 95,000$ 78.7%95,000$ (6,858)$
Real Estate Tax 412,066 414,544 380,000 109.1%380,000 2,478
Investment Interest 2,378 544 1,500 36.3%1,500 (1,834)
Total Operating Revenues 496,107$ 489,893$ 476,500$ 102.8%476,500$ (6,214)$
EXPENDITURES
Operation and Contract 3,748$ 4,303$ 3,890$ 110.6%3,890$ 555$
Other Expenditures 460,980 529,900 504,900 105.0%504,900 68,920
Total Expenditures 464,728$ 534,203$ 508,790$ 105.0%508,790$ 69,475$
NET FUND INCREASE (DECREASE)31,379$ (44,310)$ (32,290)$ (32,290)$ (75,689)$
Note - Expenditures are recorded in program 283.
Village of Oak Brook
Promenade TIF Fund Financial Update
For the Period Ending December 31, 2020
Total Total
Revenues Expenditures
12/31/20 Actual $ 489,893 534,203$
12/31/19 Actual $ 496,107 464,728$
% Change From Last Year -1.3%14.9%
Major Revenues Real Estate Investment
Sales Tax Tax Interest
12/31/20 Actual 74,805$ $ 414,544 $ 544
12/31/19 Actual 81,663$ $ 412,066 $ 2,378
% Change From Last Year -8.4%0.6%-77.1%
Five Year Trend
Major Expenditures Operation &Other
Contractual Expenditures
12/31/20 Actual 4,303$ 529,900$
12/31/19 Actual 3,748$ 460,980$
% Change From Last Year 14.8%15.0%
Five Year Trend
Village of Oak Brook
Promenade TIF Fund - Major Sources Five Year Trend
For the Period Ending December 31, 2020
Five Year Trend
Revenues Expenditures
12/31/20 12/31/20
12/31/19 12/31/20 YTD % of YTD 2020 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Plan Review Fees 1,350$ 1,050$ 1,200$ 87.5%1,200$ (300)$
Building/Inspection Fees 7,838 5,887 8,000 73.6%8,000 (1,951)
Water Sales 9,565,709 9,763,164 10,302,525 94.8%10,302,525 197,455
Unmetered Sales 43,704 82,626 30,000 275.4%30,000 38,922
Water Connection Fees 248,160 22,120 100,000 22.1%100,000 (226,040)
Meter Charges 27,787 15,082 20,000 75.4%20,000 (12,705)
Special Services 32,975 24,169 30,000 80.6%30,000 (8,806)
Investment Interest 172,835 94,778 130,000 72.9%130,000 (78,057)
Miscellaneous 79,064 21,397 75,000 28.5%75,000 (57,667)
Total Operating Revenues 10,179,422$ 10,030,273$ 10,696,725$ 93.8%10,696,725$ (149,149)$
OPERATING EXPENDITURES
Personnel 787,912$ 754,709$ 868,705$ 86.9%868,705$ (33,203)$
Materials and Supplies 60,199 40,640 74,260 54.7%74,260 (19,559)
Operation and Contract 4,996,813 4,893,195 5,833,755 83.9%5,833,755 (103,618)
Capital Outlay 4,251,626 3,155,006 6,293,225 50.1%6,293,225 (1,096,620)
Total Expenditures 10,096,550$ 8,843,550$ 13,069,945$ 67.7%13,069,945$ (1,253,000)$
Surplus (Deficit) of Revenues Over
Expenditures 82,872$ 1,186,723$ (2,373,220)$ -50.0%(2,373,220)$ 1,103,851$
INTERFUND TRANSACTIONS
Transfers In 221,085$ -$ -$ 0.0%-$ (221,085)
Reimbursements To Other Funds (551,830) (526,815) (526,815) 100.0%(526,815) 25,015
Total Interfund Transactions (330,745)$ (526,815)$ (526,815)$ 100.0%(526,815)$ (196,070)$
Fund Increase/(Decrease) - Budgetary Basis (247,873)$ 659,908$ (2,900,035)$ -22.8%(2,900,035)$ 907,781$
ADUSTMENTS TO GAAP BASIS*
Remove Capital Outlay 4,251,626$ 3,155,006$
Depreciation Expense (512,105) (575,000)
IMRF Pension Expense 77,236 50,000
OPEB Expense (49,025) (45,000)
Total GAAP Adjustments 3,767,732$ 2,585,006$
Fund Increase/(Decrease) - GAAP Basis 3,519,859$ 3,244,914$
*Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.
Village of Oak Brook
Water Fund Financial Update
For the Period Ending December 31, 2020
Total Total
Revenues Expenditures
12/31/20 Actual $ 10,030,273 8,843,550$
12/31/19 Actual $ 10,179,422 10,096,550$
% Change From Last Year -1.5%-12.4%
Unmetered Water
Water Sales Sales Connection Fees Meter Charges Miscellaneous
12/31/20 Actual $ 9,763,164 $ 82,626 $ 22,120 $ 15,082 $ 21,397
12/31/19 Actual $ 9,565,709 $ 43,704 $ 248,160 $ 27,787 $ 79,064
% Change From Last Year 2.1%89.1%-91.1%-45.7%-72.9%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
12/31/20 Actual 754,709$ 40,640$ 4,893,195$ -$ 3,155,006$
12/31/19 Actual 787,912$ 60,199$ 4,996,813$ -$ 4,251,626$
% Change From Last Year -4.2%-32.5%-2.1%0.0%-25.8%
Five Year Trend
Expenditures by Department
12/31/19 12/31/20 12/31/20 12/31/20 2020 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Public Works 5,836,550$ 5,713,002$ 6,527,120$ 87.5%6,527,120$ (123,548)$
Engineering & Capital Projects 4,260,000 3,130,548 6,542,825 47.8%6,542,825 (1,129,452)
Total Expenditures 10,096,550$ 8,843,550$ 13,069,945$ 67.7%13,069,945$ (1,253,000)$
Five Year Trend
Village of Oak Brook
Water Fund - Major Sources Five Year Trend
For the Period Ending December 31, 2020
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Sports Core Fund Consolidated Presentation
For the Period Ending December 31, 2020
12/31/20 12/31/20
12/31/20 YTD % of YTD 2020 12/31/19 Difference
B&T Recreation Field Clubhouse Golf YTD Amended Amended Adopted YTD Prior
Operations Operations Operations Club Total Budget Budget Budget Total Year
OPERATING REVENUES
Memberships 199$ -$ -$ 226,488$ 226,687$ 459,135$ 49.4%459,135$ 419,681$ (192,994)$
Greens Fees - - - 1,138,323 1,138,323 930,000 122.4%930,000 935,847 202,476
Pro Shop Sales - - - 194,464 194,464 207,000 93.9%207,000 206,449 (11,985)
Golf Lessons - - - 41,580 41,580 40,000 104.0%40,000 33,726 7,854
Driving Range Fees - - - 270,065 270,065 244,000 110.7%244,000 244,998 25,067
Rentals - 102,540 20,402 366,444 489,386 962,000 50.9%962,000 930,195 (440,809)
Programs/User Fees - - - - - 66,300 0.0%66,300 68,815 (68,815)
Food Sales - - - 164,494 164,494 180,500 91.1%180,500 183,550 (19,056)
Beverage Sales - - - 362,129 362,129 265,000 136.7%265,000 272,035 90,094
Taste of Oak Brook - - - - - 120,000 0.0%120,000 - -
Grants - - - - - 139,800 0.0%139,800 - -
Other Revenue 1,902 - - 5,174 7,076 11,000 64.3%11,000 136,378 (129,302)
Total Operating Revenues 2,101$ 102,540$ 20,402$ 2,769,161$ 2,894,204$ 3,624,735$ 79.8%3,624,735$ 3,431,674$ (537,470)$
OPERATING EXPENDITURES
Personnel 56,776$ -$ 108,825$ 1,334,358$ 1,499,959$ 1,578,100$ 95.0%1,578,100$ 1,539,262$ (39,303)$
Materials & Supplies 3,761 119 1,765 582,016 587,661 618,025 95.1%618,025 656,057 (68,396)
Operational & Contractual 76,003 44,510 55,669 303,564 479,746 1,055,095 45.5%1,055,095 1,026,412 (546,666)
Other - - - (33,200) (33,200) (83,150) 39.9%(83,150) (83,150) 49,950
Capital 452,366 9,421 145,072 483,606 1,090,465 1,921,545 56.7%1,921,545 1,173,538 (83,073)
Total Operating Expenditures 588,906$ 54,050$ 311,331$ 2,670,344$ 3,624,631$ 5,089,615$ 71.2%5,089,615$ 4,312,119$ (687,488)$
B&T Administration Overhead Allocation*100,814$ -$ (100,814)$ -$ -$ -$ 0.0%-$ -$ -$
Operating Revenues Over (Under) Expenditures (485,991)$ 48,490$ (391,743)$ 98,817$ (730,427)$ (1,464,880)$ 49.9%(1,464,880)$ (880,445)$ 150,018$
INTERFUND TRANSACTIONS
Transfer From General Fund 383,561$ -$ -$ -$ 383,561$ 923,000$ 41.6%923,000$ 704,518$ (320,957)$
Transfer From Hotel Tax Fund - - - - - 35,000 0.0%35,000 - -
Transfer From Golf Surcharge Fund - - - 340,065 340,065 400,000 85.0%400,000 212,969 127,096
Reimbursement From Infrastructure Fund 24,000 - - - 24,000 24,000 100.0%24,000 24,000 -
Reimbursement From Water Fund 8,000 - - - 8,000 8,000 100.0%8,000 8,000 -
Reimbursement To General Fund (28,225) - - (28,225) (56,450) (56,450) 100.0%(56,450) - (56,450)
Total Interfund Transactions 387,336$ -$ -$ 311,840$ 699,176$ 1,333,550$ 52.4%1,333,550$ 949,487$ (250,311)$
Total Revenues Over (Under) Expenditures - Budgetary Basis (98,655)$ 48,490$ (391,743)$ 410,657$ (31,251)$ (131,330)$ (131,330)$ 69,042$ (100,293)$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay 452,366$ 9,421$ 145,072$ 483,606$ 1,090,465$ 1,173,538$
Depreciation Expense (149,903) (1,685) (35,000) (212,000) (398,588) (328,389)
IMRF Pension Expense (5,250) (250) (2,000) (11,850) (19,350) 92,771
OPEB Expense - - (5,200) (40,000) (45,200) (20,035)
Total GAAP Adjustments 297,213$ 7,486$ 102,872$ 219,756$ 627,327$ 917,885$
Fund Increase/(Decrease) - GAAP Basis 198,558$ 55,976$ (288,871)$ 630,413$ 596,076$ 986,927$
*Overhead allocation is comprised of salaries, business forms, liability insurance, building & grounds maintenance and bank service fees in Program 811 - Sports Core General Operations distributed to various Sports Core
Programs on a % basis.
**Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.
Total Direct Total Direct
Revenues Expenditures
12/31/20 Actual $ 2,894,204 3,624,631$
12/31/19 Actual $ 3,431,674 4,312,119$
% Change From Last Year -15.7%-15.9%
Driving Program/
Memberships Greens Fees Range Fees Rentals User Fees
12/31/20 Actual $ 226,687 $ 1,138,323 $ 270,065 $ 489,386 -$
12/31/19 Actual $ 419,681 $ 935,847 $ 244,998 $ 930,195 68,815$
% Change From Last Year -46.0%21.6%10.2%-47.4%-100.0%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
12/31/20 Actual 1,499,959$ 587,661$ 479,746$ (33,200)$ 1,090,465$
12/31/19 Actual 1,539,262$ 656,057$ 1,026,412$ (83,150)$ 1,173,538$
% Change From Last Year -2.6%-10.4%-53.3%-60.1%-7.1%
Five Year Trend
Revenues by Department 12/31/19 12/31/20 12/31/20 12/31/20 2020 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Operations 357,114$ 2,101$ 506,735$ 0.4%506,735$ (300,104)$
Open Field Operations 359,448 102,540 407,000 25.2%407,000 (256,908)
B&T Clubhouse Operations 348,444 20,402 300,000 6.8%300,000 (328,042)
Golf Club 2,366,668 2,769,161 2,411,000 114.9%2,411,000 402,493
Total Revenues 3,431,674$ 2,894,204$ 3,624,735$ 79.8%3,624,735$ (482,561)$
Expenditures by Department 12/31/19 12/31/20 12/31/20 % of YTD 2020 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Operations 1,075,760$ 588,906$ 1,752,045$ 33.6%1,752,045$ (486,854)$
Open Field Operations 224,098$ 54,050$ 267,110$ 20.2%267,110$ (170,048)$
B&T Clubhouse Operations 605,290 311,331 458,770 67.9%458,770 (293,959)
Golf Club 2,406,971 2,670,344 2,611,690 102.2%2,611,690 263,373
Total Expenditures 4,312,119$ 3,624,631$ 5,089,615$ 71.2%5,089,615$ (687,488)$
Five Year Trend
Village of Oak Brook
Sports Core Fund - Major Sources Five Year Trend
For the Period Ending December 31, 2020
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Bath & Tennis Club Recreation Operations
For the Period Ending December 31, 2020 12/31/20 12/31/20
822 12/31/20 YTD % of YTD 2020 12/31/19 Difference
811 812 813 Poolside YTD Amended Amended Adopted YTD Prior
B&T Admin Swimming Tennis Café Total Budget Budget Budget Total Year
OPERATING REVENUES
Memberships -$ 199$ -$ -$ 199$ 241,635$ 0.1%241,635$ 222,006$ (221,807)$
Programs/User Fees - - - - - 66,300 0.0%66,300 68,815 (68,815)
Food Sales - - - - - 36,000 0.0%36,000 35,375 -
Beverage Sales - - - - - 20,000 0.0%20,000 19,534 -
Grants - - - - - 139,800 0.0%139,800 - -
Other Revenue 1,902 - - - 1,902 3,000 63.4%3,000 11,384 (9,482)
Total Operating Revenues 1,902$ 199$ -$ -$ 2,101$ 506,735$ 0.4%506,735$ 357,114$ (300,104)$
OPERATING EXPENDITURES
Personnel 56,460$ -$ -$ 316$ 56,776$ 163,580$ 34.7%163,580$ 140,424$ (83,648)$
Materials & Supplies 561 2,165 1,035 - 3,761 57,650 6.5%57,650 70,175 (66,414)
Operational & Contractual 61,700 6,914 7,389 - 76,003 418,270 18.2%418,270 414,584 (338,581)
Capital 56,584 395,688 94 - 452,366 1,112,545 40.7%1,112,545 450,577 1,789
Total Operating Expenditures 175,305$ 404,767$ 8,518$ 316$ 588,906$ 1,752,045$ 33.6%1,752,045$ 1,075,760$ (486,854)$
B&T Administration Overhead Allocation*201,628$ (72,586)$ (20,163)$ (8,065)$ 100,814$ 93,235$ 108.1%93,235$ 103,602$ (2,788)$
Operating Revenues Over (Under) Expenditures 28,225$ (477,154)$ (28,681)$ (8,381)$ (485,991)$ (1,152,075)$ 42.2%(1,152,075)$ (615,044)$ 183,962$
INTERFUND TRANSACTIONS
Transfer From General Fund -$ 383,561$ -$ -$ 383,561$ 757,500$ 50.6%757,500$ 419,019$ (35,458)$
Reimbursement From Infrastructure Fund 24,000 - - - 24,000 24,000 100.0%24,000 24,000 -
Reimbursement From Water Fund 8,000 - - - 8,000 8,000 100.0%8,000 8,000 -
Reimbursement To General Fund (28,225) - - - (28,225) (28,225) 100.0%(28,225) - (28,225)
Total Interfund Transactions 3,775$ 383,561$ -$ -$ 387,336$ 761,275$ 50.9%761,275$ 451,019$ (63,683)$
Total Revenues Over (Under) Expenditures - Budgetary Basis 32,000$ (93,593)$ (28,681)$ (8,381)$ (98,655)$ (390,800)$ (390,800)$ (164,025)$ 120,279$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay 56,584$ 395,688$ 94$ -$ 452,366$ 450,577$
Depreciation Expense - (143,735) (5,000) (1,168) (149,903) (94,824)
IMRF Pension Expense (5,000) - - (250) (5,250) 6,099
Total GAAP Adjustments 51,584$ 251,953$ (4,906)$ (1,418)$ 297,213$ 361,852$
Fund Increase/(Decrease) - GAAP Basis 83,584$ 158,360$ (33,587)$ (9,799)$ 198,558$ 197,827$
*Overhead allocation is comprised of salaries, business forms, liability insurance, building & grounds maintenance and bank service fees in Program 811 - Sports Core General Operations distributed to various Sports Core Programs on
a percentage basis.
**Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.
Village of Oak Brook
Monthly Operating Statement
Open Fields Operations
For the Period Ending December 31, 2020 12/31/20 12/31/20
12/31/20 YTD % of YTD 2020 12/31/19 Difference
815 816 YTD Amended Amended Adopted YTD Prior
Polo Open Fields Total Budget Budget Budget Total Year
OPERATING REVENUES
Field Rentals -$ 27,540$ 27,540$ 212,000$ 13.0%212,000$ 169,708$ (142,168)$
Range Rentals - 75,000 75,000 75,000 100.0%75,000 75,000 -
Taste of Oak Brook - - - 120,000 0.0%120,000 - -
Other Revenue - - - - 0.0%- 114,740 (114,740)
Total Operating Revenues -$ 102,540$ 102,540$ 407,000$ 25.2%407,000$ 359,448$ (256,908)$
OPERATING EXPENDITURES
Personnel -$ -$ -$ 10,810$ 0.0%10,810$ 8,890$ (8,890)$
Materials & Supplies - 119 119 1,700 7.0%1,700 1,375 (1,256)
Operational & Contractual 20,000 24,510 44,510 239,600 18.6%239,600 199,213 (154,703)
Capital - 9,421 9,421 15,000 62.8%15,000 14,620 (5,199)
Total Operating Expenditures 20,000$ 34,050$ 54,050$ 267,110$ 20.2%267,110$ 224,098$ (170,048)$
Operating Revenues Over (Under) Expenditures (20,000)$ 68,490$ 48,490$ 139,890$ 34.7%139,890$ 135,350$ (86,860)$
INTERFUND TRANSACTIONS
Transfer From Hotel Tax Fund -$ -$ -$ 35,000$ 0.0%35,000$ -$ -$
Total Interfund Transactions -$ -$ -$ 35,000$ 0.0%35,000$ -$ -$
Total Revenues Over (Under) Expenditures - Budgetary Basis (20,000)$ 68,490$ 48,490$ 174,890$ 174,890$ 135,350$ (86,860)$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay -$ 9,421$ 9,421$ 14,620$
Depreciation Expense - (1,685) (1,685) (1,685)
IMRF Pension Expense - (250) (250) 735
Total GAAP Adjustments -$ 7,486$ 7,486$ 13,670$
Fund Increase/(Decrease) - GAAP Basis (20,000)$ 75,976$ 55,976$ 149,020$
*Overhead allocation is comprised of salaries, business forms, liability insurance, building & grounds maintenance and bank service fees in Program 811 - Sports Core General Operations distributed to
various Sports Core Programs on a percentage basis.
**Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.
Village of Oak Brook
Monthly Operating Statement
Bath & Tennis Clubhouse Operations
For the Period Ending December 31, 2020
12/31/20 12/31/20
821 YTD % of YTD 2020 12/31/19 Difference
B&T Amended Amended Adopted YTD Prior
Clubhouse Budget Budget Budget Total Year
OPERATING REVENUES
Rentals 20,402$ 300,000$ 6.8%300,000$ 348,444$ (328,042)$
Total Operating Revenues 20,402$ 300,000$ 6.8%300,000$ 348,444$ (328,042)$
OPERATING EXPENDITURES
Personnel 108,825$ 140,045$ 77.7%140,045$ 130,195$ (21,370)$
Materials & Supplies 1,765 20,225 8.7%20,225 19,892 (18,127)
Operational & Contractual 55,669 109,500 50.8%109,500 97,832 (42,163)
Capital 145,072 189,000 76.8%189,000 357,371 (212,299)
Total Operating Expenditures 311,331$ 458,770$ 67.9%458,770$ 605,290$ (293,959)$
B&T Administration Overhead Allocation*(100,814)$ (93,235)$ 108.1%(93,235)$ (103,602)$ 2,788$
Operating Revenues Over (Under) Expenditures (391,743)$ (252,005)$ 155.5%(252,005)$ (360,448)$ (31,295)$
INTERFUND TRANSACTIONS
Transfer From General Fund -$ 165,500$ 0.0%165,500$ 285,499$ (285,499)$
Total Interfund Transactions -$ 165,500$ 0.0%165,500$ 285,499$ (285,499)$
Total Revenues Over (Under) Expenditures - Budgetary Basis (391,743)$ (86,505)$ (86,505)$ (74,949)$ (316,794)$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay 145,072$ 357,371$
Depreciation Expense (35,000) (32,151)
IMRF Pension Expense (2,000) 6,699
OPEB Expense (5,200) (2,100)
Total GAAP Adjustments 102,872$ 329,819$
Fund Increase/(Decrease) - GAAP Basis (288,871)$ 254,870$
*Overhead allocation is comprised of salaries, business forms, liability insurance, building & grounds maintenance and bank service fees in Program 811 -
Sports Core General Operations distributed to various Sports Core Programs on a percentage basis.
**Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.
Village of Oak Brook
Monthly Operating Statement
Golf Club Programs
For the Period Ending December 31, 2020
12/31/20 12/31/20
823 831 832 833 834 12/31/20 YTD % of YTD 2020 12/31/19 Difference
Golf Golf General Golf Learning Golf Cart Golf Course YTD Amended Amended Adopted YTD Prior
Café Operation & Practice Operations Maintenance Total Budget Budget Budget Total Year
OPERATING REVENUES
Memberships -$ 226,488$ -$ -$ -$ 226,488$ 217,500$ 104.1%217,500$ 197,675$ 28,813$
Greens Fees - 1,138,323 - - - 1,138,323 930,000 122.4%930,000 935,847 202,476
Pro Shop Sales - 194,464 - - - 194,464 207,000 93.9%207,000 206,449 (11,985)
Golf Lessons - - 41,580 - - 41,580 40,000 104.0%40,000 33,726 7,854
Driving Range Fees - - 270,065 - - 270,065 244,000 110.7%244,000 244,998 25,067
Rentals - 350 - 366,094 - 366,444 375,000 97.7%375,000 337,043 29,401
Food Sales 164,494 - - - - 164,494 144,500 113.8%144,500 148,175 16,319
Beverage Sales 362,129 - - - - 362,129 245,000 147.8%245,000 252,501 109,628
Other Revenue - 5,174 - - - 5,174 8,000 64.7%8,000 10,254 (5,080)
Total Operating Revenues 526,623$ 1,564,799$ 311,645$ 366,094$ -$ 2,769,161$ 2,411,000$ 114.9%2,411,000$ 2,366,668$ 402,493$
OPERATING EXPENDITURES
Personnel 182,829$ 511,607$ 79,398$ 47,427$ 513,097$ 1,334,358$ 1,263,665$ 105.6%1,263,665$ 1,259,753$ 74,605$
Materials & Supplies 216,281 162,972 11,638 1,351 189,774 582,016 538,450 108.1%538,450 564,615 17,401
Operational & Contractual 5,878 184,396 13,321 54,599 45,370 303,564 287,725 105.5%287,725 314,783 (11,219)
Other - - - - (33,200) (33,200) (83,150) 39.9%(83,150) (83,150) 49,950
Capital 12,059 382,693 1,147 - 87,707 483,606 605,000 79.9%605,000 350,970 132,636
Total Operating Expenditures 417,047$ 1,241,668$ 105,504$ 103,377$ 802,748$ 2,670,344$ 2,611,690$ 102.2%2,611,690$ 2,406,971$ 263,373$
Operating Revenues Over (Under) Expenditures 109,576$ 323,131$ 206,141$ 262,717$ (802,748)$ 98,817$ (200,690)$ -49.2%(200,690)$ (40,303)$ 139,120$
INTERFUND TRANSACTIONS
Transfer from Golf Surcharge -$ 340,065$ -$ -$ 340,065$ 400,000$ 85.0%400,000$ 212,969$ 127,096$
Reimbursement to General Fund - (28,225) - - (28,225) (28,225) 100.0%(28,225) - (28,225)
Total Interfund Transactions -$ 311,840$ -$ -$ -$ 311,840$ 371,775$ 83.9%371,775$ 212,969$ 98,871$
Total Revenues Over (Under) Expenditures - Budgetary Basis 109,576$ 634,971$ 206,141$ 262,717$ (802,748)$ 410,657$ 171,085$ 171,085$ 172,666$ 237,991$
ADUSTMENTS TO GAAP BASIS*
Remove Capital Outlay 12,059$ 382,693$ 1,147$ -$ 87,707$ 483,606$ 350,970$
Depreciation Expense - (135,000) (4,000) (23,000) (50,000) (212,000) (199,729)
IMRF Pension Expense (1,500) (5,000) (350) - (5,000) (11,850) 79,238
OPEB Expense (3,000) (23,000) - - (14,000) (40,000) (17,935)
Total GAAP Adjustments 7,559$ 219,693$ (3,203)$ (23,000)$ 18,707$ 219,756$ 212,544$
Fund Increase/(Decrease) - GAAP Basis 117,135$ 854,664$ 202,938$ 239,717$ (784,041)$ 630,413$ 385,210$
*Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.