09 - September 2021 Monthly Financial ReportVILLAGE
OAK BROOK
OF
MONTHLY FINANCIAL REPORTS
SEPTEMBER 2021
ITEM 6.E
Cash and Investments by Fund:Total
Cash and Cash Pooled Cash and
Fund Equivalents Investments Investments % By Fund
General Corporate $14,908,374 $13,033,312 $27,941,686 58.8%
Hotel/Motel Tax 442,471 2,125,290 2,567,761 5.4%
Motor Fuel Tax 1,055,232 18,151 1,073,383 2.3%
Infrastructure 3,985,001 2,992,806 6,977,807 14.7%
Promenade TIF 254,806 - 254,806 0.5%
Water 2,679,953 3,364,053 6,044,006 12.7%
Sports Core 678,251 - 678,251 1.4%
Golf Surcharge 259,043 - 259,043 0.5%
Self-Insurance 580,879 - 580,879 1.2%
Garage 344,191 - 344,191 0.7%
Equipment Replacement 379,388 398,960 778,348 1.6%
Total $25,567,589 $21,932,572 $47,500,161 100.0%
Change in Cash and Investments by Fund :
Balance at Balance at Year-to-Date Year-to-Date
Fund January 1, 2021 September 30, 2021 Change ($)Change (%)
General Corporate $23,894,312 $27,941,686 $4,047,374 16.9%
Hotel/Motel Tax 4,567,176 2,567,761 (1,999,415)-43.8%
Motor Fuel Tax 673,455 1,073,383 399,928 59.4%
Infrastructure 7,480,975 6,977,807 (503,168)-6.7%
Promenade TIF 267,300 254,806 (12,494)-4.7%
Water 6,900,169 6,044,006 (856,163)-12.4%
Sports Core 114,133 678,251 564,118 494.3%
Golf Surcharge 132,593 259,043 126,450 95.4%
Self-Insurance - 580,879 580,879 N/A
Garage 298,348 344,191 45,843 15.4%
Equipment Replacement 696,392 778,348 81,956 11.8%
$45,024,853 $47,500,161 $2,475,308 5.5%
Book Bank/Market
Value Value
Cash and Cash Equivalents:
Pooled Checking $1,257,843 $3,555,460
Sports Core Checking 944,715 877,266
Pooled IPTIP 22,855,392 22,855,392
Water E-Pay IPTIP 509,639 458,293
$25,567,589 $27,746,411
Pooled Investments:
Investments-Municipal Bonds $8,895,492 $8,926,185
Investments-Corporate Bonds 8,838,470 8,827,023
Government & Agency Obligations 1,337,617 1,343,019
Certificates of Deposit 2,695,000 2,701,240
Accrued Interest 165,993 165,993
Total Pooled Investments $21,932,572 $21,963,460
Total Cash and Investments $47,500,161 $49,709,871
For September, total interest revenue is $19,937 and YTD is $231,366. The total investment yield for the portfolio is:
Pooled
Investments Illinois Funds Total
Last 12 months yield 1.37%0.60%0.75%
The weighted average yield of the current investment portfolio is 1.06%. The IL Funds September average daily rate was 0.02%.
Monthly Treasurer's Report
September 30, 2021
Monthly Treasurer's Report
September 2021
The table below lists the detail investment holdings at J.P. Morgan Securities as of 9/30/21:
Month End VOB
Settlement Maturity Coupon Yield Book Market Accrued
Type Date Date Rate Rate Value Value Interest
Municipal Bonds:
Bloomingdale Mich Pub Sch Dist #094383FS0 04/26/16 05/01/22 2.710%2.150%$501,555 $506,595 $5,607
State of IL #452152P54 10/09/19 11/01/21 5.000%1.870%501,325 501,785 10,166
Brownsville TX #16405ST9 12/19/19 02/15/22 2.050%2.000%555,094 558,513 1,296
Laredo TX Waterworks #517039VW0 12/19/19 03/01/24 2.230%2.230%455,000 472,627 789
Oakland Univ Mich #673588HJ1 04/29/20 03/01/24 5.000%1.650%318,264 327,193 1,229
Philadelphia PA GO Ref #717813SW0 05/05/20 08/01/22 5.000%1.820%400,258 405,557 3,047
Maryland St DOT #574204WG4 05/06/20 06/15/22 4.350%1.200%265,788 267,540 3,214
University of CA #91412HFK4 07/16/20 05/15/23 0.628%0.628%25,000 25,130 59
Universty of IL #914353YH4 08/31/20 10/01/21 3.000%0.701%250,000 250,000 3,750
New Jersey St #646039UD7 09/20/20 06/01/22 5.000%0.600%488,909 489,887 7,851
Rio Rancho NM #767175HM7 10/14/2020 5/15/2022 5.000%0.350%190,359 190,467 3,469
Cook, Kane, Lake, & McHenry #216181GL5 10/29/2020 12/15/2022 4.000%0.300%1,070,580 1,072,222 37,804
Miami-Dade Cnty #59333NN90 11/16/2020 12/15/2022 0.375%0.430%734,393 735,000 1,363
Hamilton NY #407741MC8 1/21/2021 5/1/2023 1.000%0.550%206,456 206,101 843
Southern Cal Pub Pwr #84247PHZ7 1/25/2021 4/1/2024 3.608%0.500%1,084,922 1,077,690 8,820
Hillsborough Cnty FL #43232VV3 3/11/2021 7/1/2024 1.815%0.770%514,222 511,400 2,193
Port Auth of NY and NJ #73358WAH7 4/15/2021 12/1/2024 5.859%0.600%582,480 580,370 9,602
City of Atlanta GA Water #047870SG6 4/19/2021 11/1/2024 0.616%0.500%250,887 249,033 625
West Contra Costa Cal Uni #9523474U3 6/17/2021 8/1/2024 0.575%0.575%500,000 499,075 823
Total Municipal Bonds $8,895,492 $8,926,185 $102,550
Corporate Bonds:
Citigroup #172967LC3 04/01/19 12/08/21 2.900%2.754%$1,000,357 $1,002,550 $8,539
JP Morgan #48128BAB7 09/30/19 01/15/23 2.972%2.337%1,007,950 1,007,292 6,274
American Express #025816CD9 05/05/20 05/20/22 2.750%1.290%504,655 506,946 4,860
PNC Bank #69349LAK4 12/7/2020 1/30/2023 2.950%0.457%1,053,666 1,052,516 5,015
Wells Fargo #94974BFJ4 12/7/2020 2/13/2023 3.450%0.480%1,446,037 1,446,633 6,261
Comerica Bank #200340AS6 12/23/2020 7/31/2023 3.700%0.500%529,147 528,070 3,083
Bank of America #06048WM23 5/14/2021 5/14/2024 0.650%0.650%915,000 910,752 743
Goldman Sachs #38141GXE9 7/27/2021 2/20/2024 3.625%0.693%641,597 639,381 2,417
Goldman Sachs #38150AGU3 7/28/2021 7/28/2023 0.550%0.550%655,000 653,923 630
Morgan Stanley #61746BDQ6 7/28/2021 4/29/2024 3.875%0.547%1,085,061 1,078,960 16,361
Total Corporate Bonds $8,838,470 $8,827,023 $54,183
Government & Agency Obligations:
*Government National Mtg Assn #38379UEM4 02/29/16 02/16/51 2.300%2.245%$189,815 $178,340 $563
*Government National Mtg Assn #38381WV96 08/06/19 07/20/54 2.250%2.293%257,440 264,812 347
*Government National Mtg Assn #38380BNV3 12/05/19 06/20/46 2.000%2.112%390,362 401,863 529
Federal Home Loan Bank #3130AMVU3 06/29/21 06/29/26 0.500%0.500%500,000 498,004 625
Total Government & Agency Obligations:$1,337,617 $1,343,019 $2,064
Certificates of Deposit:
State Bk India NY #8562846A7 01/26/17 01/26/22 2.250%2.250%$245,000 $246,726 $1,004
BMW Bank #05580ASQ8 10/11/19 10/12/21 1.800%1.800%245,000 245,139 2,015
Wells Fargo #949495AN5 01/17/20 01/18/22 1.800%1.800%245,000 246,249 176
Bank Leumi #063248KQ0 03/31/20 03/31/22 1.250%1.250%245,000 246,424 -
Capital One Natl Assn #14042TCZ8 04/01/20 04/01/22 1.350%1.350%245,000 246,540 1,645
Synchrony Bank #87164WZN1 04/03/20 04/04/22 1.350%1.350%245,000 246,567 1,626
Goldman Sachs 38149MXG3 07/28/21 07/29/24 0.550%0.550%245,000 244,650 236
Sallie Mae #795451AD5 07/28/21 07/29/24 0.600%0.600%245,000 244,994 257
Texas Exchange Bk #88241TLS7 07/30/21 07/30/24 0.500%0.500%245,000 244,302 -
Toyota Financial #89235MLF6 08/05/21 8/5/2024 0.550%0.550%245,000 244,610 206
UBS Bank #90348JT42 09/22/21 9/23/2024 0.650%0.650%245,000 245,039 31
Total Certificates of Deposits $2,695,000 $2,701,240 $7,196
Total J.P.Morgan Securities $21,766,579 $21,797,467 $165,993
*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
September 30, 2021
Cash & Investments by Fund - Total $47.5 million
Cash & Investments by Type - Total $47.5 million
Checking
Illinois Funds
Certificates of Deposit
Municipal Bonds
Corporate Bonds
Government & Agency Obligations
Accrued Interest
General Corporate
58.8%
Hotel/Motel Tax
5.4%Motor Fuel Tax
2.3%
Infrastructure
14.7%
Promenade TIF
0.5%
Water
12.7%
Sports Core
1.4%
Golf Surcharge
0.5%
Self-Insurance
1.2%
Garage
0.7%
Equipment
Replacement
1.6%
Checking, $2.2
Illinois Funds, $23.4
Certificates of Deposit,
$2.7
Municipal Bonds, $8.9
Corporate Bonds, $8.8
Government & Agency
Obligations, $1.3
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)19,721,874$ 15,877,059$ 3,844,815$ 1,016,800$
Main operating fund of the Village.
Hotel Fund (Major Fund)506,459$ 2,527,288$ (2,020,829)$ (2,014,335)$
Collects and spends resources from the
3% hotel/motel tax.
Motor Fuel Tax Fund 399,623$ -$ 399,623$ (405,575)$
Collects and spends resources from the
State motor fuel tax.
Infrastructure Fund (Major Fund)7,032,691$ 7,399,354$ (366,663)$ (1,866,325)$
Accounts for construction and maintenance of
roadways, drainage, and safety path systems.
Promenade TIF Fund (Major Fund)472,644$ 485,138$ (12,494)$ (12,735)$
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)9,045,369$ 9,087,579$ (42,210)$ (3,820,075)$
Collects user fees for the distribution of water
and maintenance of infrastructure.
Sports Core Fund (Major Fund)3,487,513$ 2,840,493$ 647,020$ (78,860)$
Accounts for revenues and expenses relating
to administration, programs, food and beverage
operations, and golf course.
Golf Surcharge Fund 126,450$ -$ 126,450$ (100,255)$
Accounts for the collection of the $3 per round
golf surcharge.
Internal Service Funds
Self Insurance Fund 2,970,971$ 2,321,880$ 649,091$ 1,470$
Accounts for the Village's health insurance costs
and the related contributions from the Village,
employees, retirees, and other agencies.
Garage Fund 458,061$ 427,552$ 30,509$ (113,200)$
Accounts for the maintenance of the Village's vehicle
fleet and the related departmental reimbursements.
Equipment Replacement Fund 298,849$ 213,409$ 85,440$ (369,700)$
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 September 30, 2021
Village of Oak Brook
Monthly Financial Report – Fund Narrative
For the Period Ending September 30, 2021
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
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 (annual audit).
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 September 2021 are $2,526,848, or 15.1%, higher than last September
and $1,319,642, or 7.3%, over budget to date. The main drivers for this are:
o Sales Tax revenue, the General
Fund’s largest revenue source, is
up $1,913,086 from last year
and $1,239,240 over budget.
September 2021 collections
were the highest September in
the past five years, as the Village
has seen encouraging economic
trends after the COVID-19
restrictions of 2020.
o Other Intergovernmental Tax
revenue is up $278,093 from last year and $420,176 over budget. Receipts from Income
Tax, Replacement Tax, and Use Tax have been stronger than projected to date.
o Telecommunications/Utility Tax revenue is down $160,731 from last year and $247,382
under budget. We have seen a decrease in tax revenue as a result of remote working
over the last year. In addition, telecommunications tax revenue has been trending
downwards statewide as more people are switching to data only cellular plans.
o Licenses and Permits revenue is up $231,588 from last year, but $41,995 under budget.
The increase relates to a combination of the timing of receipt collections and a
reduction of certain liquor licenses in 2020 related to COVID-19 business closures.
Revenue is under budget due to the timing of building permits issued.
o Charges for Services revenue is up $378,646 from last year and $106,028 over budget.
Revenue is up due to certain revenue sources being negatively affected by COVID-19 in
2020, such as elevator inspections and ambulance fees. Amounts can vary from year to
year due to the timing of billing requests.
o Investment Interest revenue is down $147,819 from last year and $86,890 under
budget. Investment return rates have dropped significantly since the beginning of the
COVID-19 pandemic.
Total expenditures through September 2021 are $1,130,596, or 6.7%, lower than last year and
$1,408,382, or 8.2%, under budget to date. The main drivers for this are:
o Personnel expenditures are down $952,575 from last year and $950,468 under budget.
The decrease is due to two payroll cycles in January 2021 vs. three payroll cycles in
January 2020. In addition, personnel expenditures are under budget due to delays in
full public safety pension funding.
Hotel Tax Fund
Total revenues through September 2021 are $36,010, or 7.7%, higher than last year and
$157,294, or 45.0%, over budget to date. The main drivers for this are:
o Hotel tax revenue is up $64,907 from last year and $160,159 over budget. Revenue has
come in higher than projections in 2021, but has yet to reach pre-pandemic levels. This
is projected to occur in late 2022 as the business travel industry recovers.
Total expenditures through September 2021 are $585,038, or 87.9%, lower than last year and
$219,832, or 73.2%, under budget. Major expenditures from the Hotel Tax Fund have not
occurred yet in 2021 as many initiatives have been put on hold due to the lack of revenue.
Expenditures have primarily been limited to minimal advertising efforts and DCVB dues.
Through September 2021, the Hotel Tax Fund has transferred $2,383,612 to the Infrastructure
Fund related to the Windsor Drive widening project. A total of $3,806,250 was approved to be
transferred in 2021 as construction invoices are paid.
Infrastructure Fund
Total revenues through September 2021 are up $750,712, or 20.6%, from last year and
$350,863, or 8.7%, over budget. The main drivers for this are:
o Non-home rule sales tax revenue
is up $792,958 from last year
and $351,943 over budget.
September 2021 collections
were the highest September in
the past five years, as the Village
has seen encouraging economic
trends after the COVID-19
restrictions of 2020.
o Investment Interest revenue is
down $46,190 from last year and
$4,594 under budget. Investment return rates have dropped significantly since the
beginning of the COVID-19 pandemic.
Total expenditures through September 2021 are up $2,882,095, or 65.7%, from last year, but
$1,665,134, or 18.6%, under budget to date. The main drivers for this are:
o Personnel expenditures are up $42,097 from last year, but $8,990 under budget.
Personnel is up due to multiple retirements and the related unused accrual time
payouts.
o Operation and contract expenditures are up $197,533 from last year, but $265,487
under budget. Expenditures are under budget due to the timing of engineering and
other miscellaneous payments.
o Capital Outlay expenditures are up $2,628,073 from last year, but $1,381,471 under
budget. Expenditures are up due to project delays last year and general timing of work
performed.
Through September 2021, the Infrastructure Fund has received $2,383,612 from the Hotel Tax
Fund related to the Windsor Drive widening project. A total of $3,806,250 was approved to be
transferred in 2021 as construction invoices are paid.
Promenade TIF Fund
Total revenues through September 2021 are up $15,986, or 3.5%, from last year and $15,029, or
3.3%, over budget. Sales tax receipts have come in higher than anticipated so far in 2021.
Total expenditures through September 2021 are down $48,890, or 9.2%, from last year, but
$14,788, or 3.1%, over budget to date. Expenditures are over budget due to more principal
being paid on the note than originally projected.
Water Fund
Total revenues through September 2021 are up $1,143,257, or 14.5%, from last year and
$530,604, or 6.2%, over budget. The main drivers for this are:
o Water sales revenue is up $401,940 from last year, but $189,122 under budget. Water
gallons sold has been less than projected so far this year. Revenue is up in 2021 due to
the business shutdowns in 2020.
o Water connection fees revenue is up $167,870 from last year and $110,595 over
budget. This is due to construction on the Hines property and Restoration Hardware.
o Miscellaneous revenue is up $644,937 from last year and $616,155 over budget. This is
due to a payment related to the sale of non-corporate water lines.
Total expenditures through September 2021 are up $3,326,427, or 61.3%, from last year, but
$3,247,279, or 27.1%, under budget. The main drivers for this are:
o Operation and contract expenditures are down $8,606 from last year and $579,303
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 up $3,241,787 from last year, but $2,682,632 under
budget. Many capital projects were delayed in 2020 due to the COVID-19 pandemic.
Capital projects have begun in 2021 as planned.
Sports Core Fund
Total revenues through September 2021 are up $1,022,161, or 42.0%, from last year and
$327,137, or 10.5%, over budget to date. The main drivers for this are:
o Memberships revenue is up $130,913 from last year and $117,300 over budget. Golf
memberships have seen a significant increase in 2021 to some of the highest levels.
o Greens Fees revenue is up $222,083 from last year and $221,479 over budget. The
course did not see much activity in early 2020 due to COVID-19 restrictions.
o Driving Range Fees revenue is up $90,687 from last year and $92,073 over budget. This
is due to the golf course being able to open early and stay open this season.
o Rentals revenue is up $250,360 from last year and $59,005 over budget. This is due to
events at the Bath & Tennis Clubhouse starting to return to normal in 2021 and an
increase in golf cart rentals from more rounds played in 2021.
o Food sales are up $118,763 from last year and $75,655 over budget. This is due to
recent renovations to the Golf patio and clubhouse and due to minimal activity last
spring due to COVID-19 restrictions.
o Beverage sales are up $142,317 from last year and $122,564 over budget. This is due to
recent renovations to the Golf patio and clubhouse and due to minimal activity last
spring due to COVID-19 restrictions.
Total expenditures through September 2021 are up $16,269, or 0.6%, from last year, but
$698,746, or 20.0%, under budget to date. The main drivers for this are:
o Personnel expenditures are up $41,254 from last year, but $85,235 under budget.
Expenditures are up from last year due to the golf course being closed in spring 2020 for
COVID-19 restrictions. Personnel is under budget due to the poolside grille operations
and swim team not occurring in 2021. In addition, the Sports Core has had difficultly
filling open seasonal positions this season.
o Operation and contractual expenditures are up $97,642 from last year, but $152,914
under budget. Expenditures are up due to a full golf season in 2021 compared to last
year. Expenditures are under budget due to the cancellation of the Taste of Oak Brook
event.
o Capital outlay expenditures are down $230,993 from last year and $480,712 under
budget. Expenditures are down because of the golf lounge project that occurred in
spring 2020. Expenditures are under budget due to the timing of projects.
9/30/21 9/30/21
9/30/20 9/30/21 YTD % of YTD 2021 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 8,203,394$ 10,116,480$ 8,877,240$ 114.0%11,860,995$ 1,913,086$
Other Intergovernmental Tax*1,180,383 1,458,476 1,038,300 140.5%1,320,600 278,093
Telecommunications/Utility Tax 4,479,349 4,318,618 4,566,000 94.6%5,995,000 (160,731)
Grants 11,895 39,301 10,000 393.0%15,100 27,406
Licenses and Permits 1,385,537 1,617,125 1,659,120 97.5%2,180,360 231,588
Charges for Services 673,052 1,051,698 945,670 111.2%1,293,540 378,646
Fines and Penalties 130,521 113,267 135,405 83.7%180,500 (17,254)
Administrative Towing Fees 13,743 22,550 16,515 136.5%22,000 8,807
Investment Interest 285,929 138,110 225,000 61.4%300,000 (147,819)
Franchise Fees 101,907 106,146 151,500 70.1%202,000 4,239
Miscellaneous Income 284,059 294,846 332,225 88.7%448,280 10,787
Total Operating Revenues 16,749,769$ 19,276,617$ 17,956,975$ 107.3%23,818,375$ 2,526,848$
OPERATING EXPENDITURES
Personnel 13,855,382$ 12,902,807$ 13,853,275$ 93.1%18,842,080$ (952,575)$
Materials and Supplies 329,762 293,048 428,010 68.5%551,030 (36,714)
Operation and Contract 2,594,970 2,394,868 2,580,510 92.8%3,397,210 (200,102)
Other Expenditures 4,374 6,457 7,500 86.1%10,000 2,083
Capital Outlay 143,751 200,463 336,730 59.5%452,300 56,712
Total Operating Expenditures 16,928,239$ 15,797,643$ 17,206,025$ 91.8%23,252,620$ (1,130,596)$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES (178,470)$ 3,478,974$ 750,950$ 565,755$ 3,657,444$
INTERFUND TRANSACTIONS
Transfers Out (326,369)$ -$ (100,000)$ 0.0%(100,000)$ 326,369$
Reimbursements From Other Funds 469,791 445,257 445,275 100.0%593,685 (24,534)
Reimbursements To Other Funds (104,823) (79,416) (79,425) 100.0%(105,885) 25,407
Total Interfund Transactions 38,599$ 365,841$ 265,850$ 137.6%387,800$ 327,242$
NET FUND INCREASE (DECREASE)(139,871)$ 3,844,815$ 1,016,800$ 953,555$ 3,984,686$
*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 September 30, 2021
Total Total
Revenues Expenditures
9/30/21 Actual 19,276,617$ 15,797,643$
9/30/20 Actual 16,749,769$ 16,928,239$
% Change From Last Year 15.1%-6.7%
Major Revenues
Other Telecom/Utility Licenses &Charges for
Sales Tax Intergov. Tax Tax Permits Services
9/30/21 Actual 10,116,480$ 1,458,476$ 4,318,618$ 1,617,125$ 1,051,698$
9/30/20 Actual $ 8,203,394 $ 1,180,383 $ 4,479,349 $ 1,385,537 $ 673,052
% Change From Last Year 23.3%23.6%-3.6%16.7%56.3%
Five Year Trend
Major Expenditures Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
9/30/21 Actual 12,902,807$ 293,048$ 2,394,868$ 6,457$ 200,463$
9/30/20 Actual 13,855,382$ 329,762$ 2,594,970$ 4,374$ 143,751$
% Change From Last Year -6.9%-11.1%-7.7%47.6%39.5%
Five Year Trend
Expenditures by Department
9/30/20 9/30/21 9/30/21 9/30/21 2021 Difference Five
YTD YTD YTD % of Annual Prior Year
Department Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 1,560,892$ 1,806,636$ 1,807,785$ 99.9%2,498,625$ 245,744$
Financial Services 568,830 557,828 580,330 96.1%770,360 (11,002)
Public Works 548,311 655,875 706,590 92.8%948,860 107,564
Engineering & Capital Projects 37,699 22,418 179,000 12.5%209,000 (15,281)
Library 608,154 637,585 711,695 89.6%943,405 29,431
Police 6,715,622 6,213,517 6,794,790 91.4%9,213,585 (502,105)
Fire 6,113,322 5,191,220 5,609,805 92.5%7,576,045 (922,102)
Development Services 775,409 712,564 816,030 87.3%1,092,740 (62,845)
Total Expenditures 16,928,239$ 15,797,643$ 17,206,025$ 91.8%23,252,620$ (1,130,596)$
Five Year Trend
For the Period Ending September 30, 2021
General Fund - Five Year Trend
Village of Oak Brook
Revenues Expenditures
9/30/21 9/30/21
9/30/20 9/30/21 YTD % of YTD 2021 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Hotel Tax 410,402$ 475,309$ 315,150$ 150.8%414,000$ 64,907$
Investment Interest 55,880 25,878 30,015 86.2%40,000 (30,002)
Loan Interest 4,167 4,000 4,000 100.0%8,000 (167)
Miscellaneous - 1,272 - 0.0%- 1,272
Total Operating Revenues 470,449$ 506,459$ 349,165$ 145.0%462,000$ 36,010$
EXPENDITURES
Operation and Contract 306,681$ 77,963$ 150,445$ 51.8%193,945$ (228,718)$
Capital Outlay 358,970 2,650 150,000 1.8%250,000 (356,320)
Total Expenditures 665,651$ 80,613$ 300,445$ 26.8%443,945$ (585,038)$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES (195,202)$ 425,846$ 48,720$ 874.1%18,055$ 621,048$
INTERFUND TRANSACTIONS
Transfer Out -$ (2,383,612)$ (2,000,000)$ 119.2%(100,000)$ (2,383,612)$
Reimbursements to Other Funds (56,034) (63,063) (63,055) 100.0%(84,085) (7,029)
Total Interfund Transactions (56,034)$ (2,446,675)$ (2,063,055)$ 118.6%(184,085)$ (2,390,641)$
NET FUND INCREASE (DECREASE)(251,236)$ (2,020,829)$ (2,014,335)$ (166,030)$ (1,769,593)$
Note - Expenditures are recorded in program 171.
Village of Oak Brook
Hotel Tax Fund Financial Update
For the Period Ending September 30, 2021
Total Total
Revenues Expenditures
9/30/21 Actual $ 506,459 80,613$
9/30/20 Actual $ 470,449 665,651$
% Change From Last Year 7.7%-87.9%
Major Revenues Investment
Hotel Tax Interest Loan Interest Miscellaneous
9/30/21 Actual $ 475,309 $ 25,878 4,000$ 1,272$
9/30/20 Actual $ 410,402 $ 55,880 4,167$ -$
% Change From Last Year 15.8%-53.7%-4.0%N/A
Five Year Trend
Major Expenditures Operation &
Contractual Capital Outlay
9/30/21 Actual 77,963$ 2,650$
9/30/20 Actual 306,681$ 358,970$
% Change From Last Year -74.6%-99.3%
Five Year Trend
Village of Oak Brook
Hotel Tax Fund - Major Sources Five Year Trend
For the Period Ending September 30, 2021
Five Year Trend
Revenues Expenditures
9/30/21 9/30/21
9/30/20 9/30/21 YTD % of YTD 2021 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Non-Home Rule Sales Tax 3,577,535$ 4,370,493$ 4,018,550$ 108.8%5,333,500$ 792,958$
Charges for Services 335 - 765 0.0%1,000 (335)
Investment Interest 71,611 25,421 30,015 84.7%40,000 (46,190)
Miscellaneous - 4,279 - N/A - 4,279
Total Operating Revenues 3,649,481$ 4,400,193$ 4,049,330$ 108.7%5,374,500$ 750,712$
OPERATING EXPENDITURES
Personnel 963,138$ 1,005,235$ 1,014,225$ 99.1%1,386,115$ 42,097$
Materials and Supplies 130,847 145,239 154,425 94.1%245,660 14,392
Operation and Contract 982,140 1,179,673 1,445,160 81.6%1,892,905 197,533
Capital Outlay 2,308,906 4,936,979 6,318,450 78.1%8,956,170 2,628,073
Total Operating Expenditures 4,385,031$ 7,267,126$ 8,932,260$ 81.4%12,480,850$ 2,882,095$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES (735,550)$ (2,866,933)$ (4,882,930)$ 58.7%(7,106,350)$ (2,131,383)$
INTERFUND TRANSACTIONS
Transfers In 666,289$ 2,383,612$ 2,900,000$ 82.2%1,400,000$ 1,717,323$
Reimbursements From Other Funds 269,532 248,886 248,895 100.0%331,840 (20,646)
Reimbursements To Other Funds (121,725) (132,228) (132,290) 100.0%(176,300) (10,503)
Total Interfund Transactions 814,096$ 2,500,270$ 3,016,605$ 82.9%1,555,540$ 1,686,174$
NET FUND INCREASE (DECREASE)78,546$ (366,663)$ (1,866,325)$ (5,550,810)$ (445,209)$
Village of Oak Brook
Infrastructure Fund Financial Update
For the Period Ending September 30, 2021
Total Total
Revenues Expenditures
9/30/21 Actual $ 4,400,193 7,267,126$
9/30/20 Actual $ 3,649,481 4,385,031$
% Change From Last Year 20.6%65.7%
Major Revenues
Sales Tax
Charges for
Services
Investment
Interest Miscellaneous
9/30/21 Actual $ 4,370,493 $ - $ 25,421 $ 4,279
9/30/20 Actual $ 3,577,535 $ 335 $ 71,611 $ -
% Change From Last Year 22.2%-100.0%-64.5%N/A
Five Year Trend
Major Expenditures Materials &Operation &
Personnel Supplies Contractual Capital Outlay
9/30/21 Actual 1,005,235$ 145,239$ 1,179,673$ 4,936,979$
9/30/20 Actual 963,138$ 130,847$ 982,140$ 2,308,906$
% Change From Last Year 4.4%11.0%20.1%113.8%
Five Year Trend
Expenditures by Department
9/30/20 9/30/21 9/30/21 9/30/21 2021 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 106,334$ 109,252$ 116,645$ 93.7%157,640$ 2,918$
Public Works 3,036,276 1,777,795 1,972,670 90.1%2,789,580 (1,258,481)
Engineering & Capital Projects 1,242,421 5,380,079 6,842,945 78.6%9,709,930 4,137,658
Total Expenditures 4,385,031$ 7,267,126$ 8,932,260$ 81.4%12,657,150$ 2,882,095$
Five Year Trend
Village of Oak Brook
Infrastructure Fund - Major Sources Five Year Trend
For the Period Ending September 30, 2021
Revenues Expenditures
9/30/21 9/30/21
9/30/20 9/30/21 YTD % of YTD 2021 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 41,624$ 64,153$ 56,850$ 112.8%75,000$ 22,529$
Real Estate Tax 414,544 408,456 400,000 102.1%400,000 (6,088)
Investment Interest 490 35 765 4.6%1,000 (455)
Total Operating Revenues 456,658$ 472,644$ 457,615$ 103.3%476,000$ 15,986$
EXPENDITURES
Operation and Contract 4,128$ 3,638$ 3,850$ 94.5%3,850$ (490)$
Other Expenditures 529,900 481,500 466,500 103.2%466,500 (48,400)
Total Expenditures 534,028$ 485,138$ 470,350$ 103.1%470,350$ (48,890)$
NET FUND INCREASE (DECREASE)(77,370)$ (12,494)$ (12,735)$ 5,650$ 64,876$
Note - Expenditures are recorded in program 283.
Village of Oak Brook
Promenade TIF Fund Financial Update
For the Period Ending September 30, 2021
Total Total
Revenues Expenditures
9/30/21 Actual $ 472,644 485,138$
9/30/20 Actual $ 456,658 534,028$
% Change From Last Year 3.5%-9.2%
Major Revenues Real Estate Investment
Sales Tax Tax Interest
9/30/21 Actual 64,153$ $ 408,456 $ 35
9/30/20 Actual 41,624$ $ 414,544 $ 490
% Change From Last Year 54.1%-1.5%-92.9%
Five Year Trend
Major Expenditures Operation &Other
Contractual Expenditures
9/30/21 Actual 3,638$ 481,500$
9/30/20 Actual 4,128$ 529,900$
% Change From Last Year -11.9%-9.1%
Five Year Trend
Village of Oak Brook
Promenade TIF Fund - Major Sources Five Year Trend
For the Period Ending September 30, 2021
Five Year Trend
Revenues Expenditures
9/30/21 9/30/21
9/30/20 9/30/21 YTD % of YTD 2021 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Plan Review Fees 675$ 525$ 765$ 68.6%1,000$ (150)$
Building/Inspection Fees 5,512 2,850 5,265 54.1%7,000 (2,662)
Water Sales 7,698,938 8,100,878 8,290,000 97.7%10,597,000 401,940
Unmetered Sales 60,901 33,453 26,235 127.5%35,000 (27,448)
Water Connection Fees 17,740 185,610 75,015 247.4%100,000 167,870
Meter Charges 7,737 6,786 11,250 60.3%15,000 (951)
Special Services 12,657 13,333 12,500 106.7%25,000 676
Investment Interest 77,999 37,044 45,000 82.3%60,000 (40,955)
Miscellaneous 19,953 664,890 48,735 1364.3%65,000 644,937
Total Operating Revenues 7,902,112$ 9,045,369$ 8,514,765$ 106.2%10,905,000$ 1,143,257$
OPERATING EXPENDITURES
Personnel 571,660$ 582,962$ 619,670$ 94.1%842,235$ 11,302$
Materials and Supplies 26,285 108,229 56,865 190.3%75,780 81,944
Operation and Contract 3,477,253 3,468,647 4,047,950 85.7%5,379,925 (8,606)
Capital Outlay 1,348,076 4,589,863 7,272,495 63.1%8,103,750 3,241,787
Total Expenditures 5,423,274$ 8,749,701$ 11,996,980$ 72.9%14,401,690$ 3,326,427$
Surplus (Deficit) of Revenues Over
Expenditures 2,478,838$ 295,668$ (3,482,215)$ -8.5%(3,496,690)$ (2,183,170)$
INTERFUND TRANSACTIONS
Reimbursements To Other Funds (395,109)$ (337,878)$ (337,860)$ 100.0%(450,500)$ 57,231$
Total Interfund Transactions (395,109)$ (337,878)$ (337,860)$ 100.0%(450,500)$ 57,231$
Fund Increase/(Decrease) - Budgetary Basis 2,083,729$ (42,210)$ (3,820,075)$ 1.1%(3,947,190)$ (2,125,939)$
ADUSTMENTS TO GAAP BASIS*
Remove Capital Outlay 1,348,076$ 4,589,863$
Depreciation Expense (411,527) (431,250)
IMRF Pension Expense (31,120) (33,750)
OPEB Expense 20,732 (22,500)
Total GAAP Adjustments 926,161$ 4,102,363$
Fund Increase/(Decrease) - GAAP Basis 3,009,890$ 4,060,153$
*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 September 30, 2021
Total Total
Revenues Expenditures
9/30/21 Actual $ 9,045,369 8,749,701$
9/30/20 Actual $ 7,902,112 5,423,274$
% Change From Last Year 14.5%61.3%
Unmetered Water
Water Sales Sales Connection Fees Meter Charges Miscellaneous
9/30/21 Actual $ 8,100,878 $ 33,453 $ 185,610 $ 6,786 $ 664,890
9/30/20 Actual $ 7,698,938 $ 60,901 $ 17,740 $ 7,737 $ 19,953
% Change From Last Year 5.2%-45.1%946.3%-12.3%3232.3%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
9/30/21 Actual 582,962$ 108,229$ 3,468,647$ -$ 4,589,863$
9/30/20 Actual 571,660$ 26,285$ 3,477,253$ -$ 1,348,076$
% Change From Last Year 2.0%311.8%-0.2%0.0%240.5%
Five Year Trend
Expenditures by Department
9/30/20 9/30/21 9/30/21 9/30/21 2021 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Public Works 4,106,456$ 4,094,744$ 4,739,480$ 86.4%6,317,940$ (11,712)$
Engineering & Capital Projects 1,316,818 4,654,957 7,257,500 64.1%8,083,750 3,338,139
Total Expenditures 5,423,274$ 8,749,701$ 11,996,980$ 72.9%14,401,690$ 3,326,427$
Five Year Trend
Village of Oak Brook
Water Fund - Major Sources Five Year Trend
For the Period Ending September 30, 2021
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Sports Core Fund Consolidated Presentation
For the Period Ending September 30, 2021
9/30/21 9/30/21
9/30/21 YTD % of YTD 2021 9/30/20 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 -$ -$ -$ 355,800$ 355,800$ 238,500$ 149.2%238,500$ 224,887$ 130,913$
Greens Fees - - - 1,146,479 1,146,479 925,000 123.9%985,000 924,396 222,083
Pro Shop Sales - - - 202,254 202,254 192,500 105.1%207,000 150,297 51,957
Golf Lessons - - - 46,755 46,755 45,000 103.9%45,000 45,245 1,510
Driving Range Fees - - - 327,073 327,073 235,000 139.2%250,000 236,386 90,687
Rentals - 102,500 124,417 441,563 668,480 609,475 109.7%761,000 418,120 250,360
Programs/User Fees - - - - - 31,500 0.0%31,500 - -
Food Sales - - - 250,155 250,155 174,500 143.4%207,500 131,392 118,763
Beverage Sales - - - 440,564 440,564 318,000 138.5%382,000 298,247 142,317
Taste of Oak Brook - - - - - 120,000 0.0%120,000 - -
Grants - - - - - 233,600 0.0%233,600 - -
Other Revenue 8,518 - - 11,429 19,947 7,295 273.4%7,700 6,376 13,571
Total Operating Revenues 8,518$ 102,500$ 124,417$ 3,222,072$ 3,457,507$ 3,130,370$ 110.5%3,468,800$ 2,435,346$ 1,022,161$
OPERATING EXPENDITURES
Personnel 16,251$ -$ 89,286$ 1,031,138$ 1,136,675$ 1,221,910$ 93.0%1,597,610$ 1,095,421$ 41,254$
Materials & Supplies 27,425 - 5,636 542,929 575,990 594,875 96.8%628,450 477,624 98,366
Operational & Contractual 88,195 8,053 44,497 295,246 435,991 588,905 74.0%663,035 338,349 97,642
Other - - - - - (39,000) 0.0%(39,000) - -
Capital 269,301 232,675 4,382 138,310 644,668 1,125,380 57.3%1,125,380 865,661 (220,993)
Total Operating Expenditures 401,172$ 240,728$ 143,801$ 2,007,623$ 2,793,324$ 3,492,070$ 80.0%3,975,475$ 2,777,055$ 16,269$
B&T Administration Overhead Allocation*20,315$ -$ (20,315)$ -$ -$ -$ 0.0%-$ -$ -$
Operating Revenues Over (Under) Expenditures (372,339)$ (138,228)$ (39,699)$ 1,214,449$ 664,183$ (361,700)$ -183.6%(506,675)$ (341,709)$ 1,005,892$
INTERFUND TRANSACTIONS
Transfer From General Fund -$ -$ -$ -$ -$ 100,000$ 0.0%100,000$ 326,369$ (326,369)$
Transfer From Golf Surcharge Fund - - - - - 200,000 0.0%200,000 323,373 (323,373)
Reimbursement From Infrastructure Fund 24,003 - - - 24,003 24,010 100.0%32,000 18,000 6,003
Reimbursement From Water Fund 6,003 - - - 6,003 6,005 100.0%8,000 6,003 -
Reimbursement To General Fund (11,790) - - (35,379) (47,169) (47,175) 100.0%(62,900) (42,336) (4,833)
Total Interfund Transactions 18,216$ -$ -$ (35,379)$ (17,163)$ 282,840$ -6.1%277,100$ 631,409$ (648,572)$
Total Revenues Over (Under) Expenditures - Budgetary Basis (354,123)$ (138,228)$ (39,699)$ 1,179,070$ 647,020$ (78,860)$ (229,575)$ 289,700$ 357,320$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay 269,301$ 232,675$ 4,382$ 138,310$ 644,668$ 865,661$
Depreciation Expense (126,170) (1,264) (45,000) (184,725) (357,159) (291,812)
IMRF Pension Expense (1,538) - (2,250) (18,375) (22,163) (19,616)
OPEB Expense - - (2,250) (21,000) (23,250) (18,935)
Total GAAP Adjustments 141,593$ 231,411$ (45,118)$ (85,790)$ 242,097$ 535,300$
Fund Increase/(Decrease) - GAAP Basis (212,530)$ 93,183$ (84,817)$ 1,093,280$ 889,117$ 825,000$
*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.
Total Direct Total Direct
Revenues Expenditures
9/30/21 Actual $ 3,457,507 2,793,324$
9/30/20 Actual $ 2,435,346 2,777,055$
% Change From Last Year 42.0%0.6%
Driving Program/
Memberships Greens Fees Range Fees Rentals User Fees
9/30/21 Actual $ 355,800 $ 1,146,479 $ 327,073 $ 668,480 -$
9/30/20 Actual $ 224,887 $ 924,396 $ 236,386 $ 418,120 -$
% Change From Last Year 58.2%24.0%38.4%59.9%0.0%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
9/30/21 Actual 1,136,675$ 575,990$ 435,991$ -$ 644,668$
9/30/20 Actual 1,095,421$ 477,624$ 338,349$ -$ 865,661$
% Change From Last Year 3.8%20.6%28.9%0.0%-25.5%
Five Year Trend
Revenues by Department 9/30/20 9/30/21 9/30/21 9/30/21 2021 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Operations 1,338$ 8,518$ 325,595$ 2.6%325,800$ 7,180$
Open Field Operations 97,540 102,500 222,500 46.1%230,000 4,960
B&T Clubhouse Operations 19,989 124,417 167,000 74.5%267,000 104,428
Golf Club 2,316,479 3,222,072 2,415,275 133.4%2,646,000 905,593
Total Revenues 2,435,346$ 3,457,507$ 3,130,370$ 110.5%3,468,800$ 1,022,161$
Expenditures by Department 9/30/20 9/30/21 9/30/21 % of YTD 2021 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Operations 447,147$ 401,172$ 761,460$ 52.7%780,740$ (45,975)$
Open Field Operations 32,394$ 240,728$ 357,105$ 67.4%358,910$ 208,334$
B&T Clubhouse Operations 157,384 143,801 193,390 74.4%262,635 (13,583)
Golf Club 2,140,130 2,007,623 2,180,115 92.1%2,573,190 (132,507)
Total Expenditures 2,777,055$ 2,793,324$ 3,492,070$ 80.0%3,975,475$ 16,269$
Five Year Trend
Village of Oak Brook
Sports Core Fund - Major Sources Five Year Trend
For the Period Ending September 30, 2021
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Bath & Tennis Club Recreation Operations
For the Period Ending September 30, 2021 9/30/21 9/30/21
822 9/30/21 YTD % of YTD 2021 9/30/20 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 -$ -$ -$ -$ -$ -$ 0.0%-$ 199$ (199)$
Programs/User Fees - - - - - 31,500 0.0%31,500 - -
Food Sales - - - - - 38,000 0.0%38,000 - -
Beverage Sales - - - - - 22,000 0.0%22,000 - -
Grants - - - - - 233,600 0.0%233,600 - -
Other Revenue 8,518 - - - 8,518 495 1720.8%700 1,139 7,379
Total Operating Revenues 8,518$ -$ -$ -$ 8,518$ 325,595$ 2.6%325,800$ 1,338$ 7,180$
OPERATING EXPENDITURES
Personnel 16,251$ -$ -$ -$ 16,251$ 105,890$ 15.3%119,110$ 40,255$ (24,004)$
Materials & Supplies 457 22,799 2,460 1,709 27,425 37,010 74.1%37,250 3,545 23,880
Operational & Contractual 50,655 31,432 5,885 223 88,195 83,730 105.3%89,550 40,349 47,846
Capital 158,926 110,375 - - 269,301 534,830 50.4%534,830 362,998 (93,697)
Total Operating Expenditures 226,289$ 164,606$ 8,345$ 1,932$ 401,172$ 761,460$ 52.7%780,740$ 447,147$ (45,975)$
B&T Administration Overhead Allocation*40,629$ (14,626)$ (4,063)$ (1,625)$ 20,315$ 39,055$ 52.0%44,755$ 63,054$ (42,739)$
Operating Revenues Over (Under) Expenditures (177,142)$ (179,232)$ (12,408)$ (3,557)$ (372,339)$ (396,810)$ 93.8%(410,185)$ (382,755)$ 10,416$
INTERFUND TRANSACTIONS
Transfer From General Fund -$ -$ -$ -$ -$ 100,000$ 0.0%100,000$ 326,369$ (326,369)$
Reimbursement From Infrastructure Fund 24,003 - - - 24,003 24,010 100.0%32,000 18,000 6,003
Reimbursement From Water Fund 6,003 - - - 6,003 6,005 100.0%8,000 6,003 -
Reimbursement To General Fund (11,790) - - - (11,790) (11,790) 100.0%(15,725) (21,168) 9,378
Total Interfund Transactions 18,216$ -$ -$ -$ 18,216$ 118,225$ 15.4%124,275$ 329,204$ (310,988)$
Total Revenues Over (Under) Expenditures - Budgetary Basis (158,926)$ (179,232)$ (12,408)$ (3,557)$ (354,123)$ (278,585)$ (285,910)$ (53,551)$ (300,572)$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay 158,926$ 110,375$ -$ -$ 269,301$ 362,998$
Depreciation Expense (48,269) (75,000) (2,025) (876) (126,170) (69,080)
IMRF Pension Expense (1,500) - - (38) (1,538) (839)
Total GAAP Adjustments 109,157$ 35,375$ (2,025)$ (914)$ 141,593$ 293,079$
Fund Increase/(Decrease) - GAAP Basis (49,769)$ (143,857)$ (14,433)$ (4,471)$ (212,530)$ 239,528$
*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 September 30, 2021 9/30/21 9/30/21
9/30/21 YTD % of YTD 2021 9/30/20 Difference
815 816 YTD Amended Amended Adopted YTD Prior
Polo Open Fields Total Budget Budget Budget Total Year
OPERATING REVENUES
Field Rentals -$ 22,500$ 22,500$ 22,500$ 100.0%30,000$ 22,540$ (40)$
Range Rentals - 80,000 80,000 80,000 100.0%80,000 75,000 5,000
Taste of Oak Brook - - - 120,000 0.0%120,000 - -
Other Revenue - - - - 0.0%- - -
Total Operating Revenues -$ 102,500$ 102,500$ 222,500$ 46.1%230,000$ 97,540$ 4,960$
OPERATING EXPENDITURES
Personnel -$ -$ -$ -$ 0.0%-$ -$ -$
Materials & Supplies - - - 400 0.0%500 119 (119)
Operational & Contractual - 8,053 8,053 188,655 4.3%190,360 22,854 (14,801)
Capital - 232,675 232,675 168,050 0.0%168,050 9,421 223,254
Total Operating Expenditures -$ 240,728$ 240,728$ 357,105$ 67.4%358,910$ 32,394$ 208,334$
Operating Revenues Over (Under) Expenditures -$ (138,228)$ (138,228)$ (134,605)$ 102.7%(128,910)$ 65,146$ (203,374)$
INTERFUND TRANSACTIONS
Transfer From Hotel Tax Fund -$ -$ -$ -$ 0.0%-$ -$ -$
Total Interfund Transactions -$ -$ -$ -$ 0.0%-$ -$ -$
Total Revenues Over (Under) Expenditures - Budgetary Basis -$ (138,228)$ (138,228)$ (134,605)$ (128,910)$ 65,146$ (203,374)$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay -$ 232,675$ 232,675$ 9,421$
Depreciation Expense - (1,264) (1,264) (1,264)
Total GAAP Adjustments -$ 231,411$ 231,411$ 8,157$
Fund Increase/(Decrease) - GAAP Basis -$ 93,183$ 93,183$ 73,303$
*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 September 30, 2021
9/30/21 9/30/21
821 YTD % of YTD 2021 9/30/20 Difference
B&T Amended Amended Adopted YTD Prior
Clubhouse Budget Budget Budget Total Year
OPERATING REVENUES
Rentals 124,417$ 167,000$ 74.5%267,000$ 19,989$ 104,428$
Total Operating Revenues 124,417$ 167,000$ 74.5%267,000$ 19,989$ 104,428$
OPERATING EXPENDITURES
Personnel 89,286$ 99,365$ 89.9%133,585$ 80,232$ 9,054$
Materials & Supplies 5,636 8,185 68.9%12,000 1,540 4,096
Operational & Contractual 44,497 76,340 58.3%107,550 39,397 5,100
Capital 4,382 9,500 46.1%9,500 36,215 (31,833)
Total Operating Expenditures 143,801$ 193,390$ 74.4%262,635$ 157,384$ (13,583)$
B&T Administration Overhead Allocation*(20,315)$ (39,055)$ 52.0%(44,755)$ (63,054)$ 42,739$
Operating Revenues Over (Under) Expenditures (39,699)$ (65,445)$ 60.7%(40,390)$ (200,449)$ 160,750$
INTERFUND TRANSACTIONS
Transfer From General Fund -$ -$ 0.0%-$ -$ -$
Total Interfund Transactions -$ -$ 0.0%-$ -$ -$
Total Revenues Over (Under) Expenditures - Budgetary Basis (39,699)$ (65,445)$ (40,390)$ (200,449)$ 160,750$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay 4,382$ 36,215$
Depreciation Expense (45,000) (45,416)
IMRF Pension Expense (2,250) (1,555)
OPEB Expense (2,250) (1,983)
Total GAAP Adjustments (45,118)$ (12,739)$
Fund Increase/(Decrease) - GAAP Basis (84,817)$ (213,188)$
*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 September 30, 2021
9/30/21 9/30/21
823 831 832 833 834 9/30/21 YTD % of YTD 2021 9/30/20 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 -$ 355,800$ -$ -$ -$ 355,800$ 238,500$ 149.2%238,500$ 224,688$ 131,112$
Greens Fees - 1,146,479 - - - 1,146,479 925,000 123.9%985,000 924,396 222,083
Pro Shop Sales - 202,254 - - - 202,254 192,500 105.1%207,000 150,297 51,957
Golf Lessons - - 46,755 - - 46,755 45,000 103.9%45,000 45,245 1,510
Driving Range Fees - - 327,073 - - 327,073 235,000 139.2%250,000 236,386 90,687
Rentals - 2,430 9,000 430,133 - 441,563 339,975 129.9%384,000 300,591 140,972
Food Sales 250,155 - - - - 250,155 136,500 183.3%169,500 131,392 118,763
Beverage Sales 440,564 - - - - 440,564 296,000 148.8%360,000 298,247 142,317
Other Revenue - 11,429 - - - 11,429 6,800 168.1%7,000 5,237 6,192
Total Operating Revenues 690,719$ 1,718,392$ 382,828$ 430,133$ -$ 3,222,072$ 2,415,275$ 133.4%2,646,000$ 2,316,479$ 905,593$
OPERATING EXPENDITURES
Personnel 195,088$ 413,365$ 74,947$ 38,639$ 309,099$ 1,031,138$ 1,016,655$ 101.4%1,344,915$ 974,934$ 56,204$
Materials & Supplies 249,760 149,328 16,171 1,057 126,613 542,929 549,280 98.8%578,700 472,420 70,509
Operational & Contractual 4,416 210,093 799 55,667 24,271 295,246 240,180 122.9%275,575 235,749 59,497
Other - - - - - - (39,000) 0.0%(39,000) - -
Capital - 17,772 - - 120,538 138,310 413,000 33.5%413,000 457,027 (318,717)
Total Operating Expenditures 449,264$ 790,558$ 91,917$ 95,363$ 580,521$ 2,007,623$ 2,180,115$ 92.1%2,573,190$ 2,140,130$ (132,507)$
Operating Revenues Over (Under) Expenditures 241,455$ 927,834$ 290,911$ 334,770$ (580,521)$ 1,214,449$ 235,160$ 516.4%72,810$ 176,349$ 1,038,100$
INTERFUND TRANSACTIONS
Transfer from Golf Surcharge -$ -$ -$ -$ -$ -$ 200,000$ 0.0%200,000$ 323,373$ (323,373)$
Reimbursement to General Fund - (35,379) - - - (35,379) (35,385) 100.0%(47,175) (21,168) (14,211)
Total Interfund Transactions -$ (35,379)$ -$ -$ -$ (35,379)$ 164,615$ -21.5%152,825$ 302,205$ (337,584)$
Total Revenues Over (Under) Expenditures - Budgetary Basis 241,455$ 892,455$ 290,911$ 334,770$ (580,521)$ 1,179,070$ 399,775$ 225,635$ 478,554$ 700,516$
ADUSTMENTS TO GAAP BASIS*
Remove Capital Outlay -$ 17,772$ -$ -$ 120,538$ 138,310$ 457,027$
Depreciation Expense (750) (78,750) (1,725) (9,750) (93,750) (184,725) (176,051)
IMRF Pension Expense (1,875) (7,500) (750) - (8,250) (18,375) (17,222)
OPEB Expense (2,250) (11,250) - - (7,500) (21,000) (16,952)
Total GAAP Adjustments (4,875)$ (79,728)$ (2,475)$ (9,750)$ 11,038$ (85,790)$ 246,803$
Fund Increase/(Decrease) - GAAP Basis 236,580$ 812,727$ 288,436$ 325,020$ (569,483)$ 1,093,280$ 725,357$
*Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.