12 - December 2021 Monthly Financial ReportVILLAGE
OAK BROOK
OF
MONTHLY FINANCIAL REPORTS
DECEMBER 2021
ITEM 6.D
Cash and Investments by Fund:Total
Cash and Cash Pooled Cash and
Fund Equivalents Investments Investments % By Fund
General Corporate $11,653,013 $14,302,377 $25,955,390 56.8%
Hotel/Motel Tax 551,647 1,203,098 1,754,745 3.8%
Motor Fuel Tax 1,137,964 15,586 1,153,550 2.5%
Infrastructure 7,058,346 3,825,279 10,883,625 23.8%
Promenade TIF 287,509 - 287,509 0.6%
Water 42,840 3,572,023 3,614,863 7.9%
Sports Core 576,566 - 576,566 1.3%
Golf Surcharge 278,773 - 278,773 0.6%
Self-Insurance 80,857 - 80,857 0.2%
Garage 325,902 - 325,902 0.7%
Equipment Replacement 373,298 385,957 759,255 1.7%
Total $22,366,715 $23,304,320 $45,671,035 100.0%
Change in Cash and Investments by Fund :
Balance at Balance at Year-to-Date Year-to-Date
Fund January 1, 2021 December 31, 2021 Change ($)Change (%)
General Corporate $23,894,312 $25,955,390 $2,061,078 8.6%
Hotel/Motel Tax 4,567,176 1,754,745 (2,812,431)-61.6%
Motor Fuel Tax 673,455 1,153,550 480,095 71.3%
Infrastructure 7,480,975 10,883,625 3,402,650 45.5%
Promenade TIF 267,300 287,509 20,209 7.6%
Water 6,900,169 3,614,863 (3,285,306)-47.6%
Sports Core 114,133 576,566 462,433 405.2%
Golf Surcharge 132,593 278,773 146,180 110.2%
Self-Insurance - 80,857 80,857 N/A
Garage 298,348 325,902 27,554 9.2%
Equipment Replacement 696,392 759,255 62,863 9.0%
$45,024,853 $45,671,035 $646,182 1.4%
Book Bank/Market
Value Value
Cash and Cash Equivalents:
Pooled Checking $501,799 $1,847,445
Sports Core Checking 862,756 852,404
Pooled IPTIP 20,958,869 20,958,869
Water E-Pay IPTIP 43,291 41,366
$22,366,715 $23,700,084
Pooled Investments:
Investments-Municipal Bonds $9,817,516 $9,781,183
Investments-Corporate Bonds 8,801,677 8,725,863
Government & Agency Obligations 2,097,982 2,067,497
Certificates of Deposit 2,450,000 2,445,182
Accrued Interest 137,145 137,145
Total Pooled Investments $23,304,320 $23,156,870
Total Cash and Investments $45,671,035 $46,856,954
For December, total interest revenue is $18,616 and YTD is $287,705. The total investment yield for the portfolio is:
Pooled
Investments Illinois Funds Total
Last 12 months yield 1.16%0.04%0.63%
The weighted average yield of the current investment portfolio is 0.94%. The IL Funds December average daily rate was 0.056%.
Monthly Treasurer's Report
December 31, 2021
Monthly Treasurer's Report
December 2021
The table below lists the detail investment holdings at J.P. Morgan Securities as of 12/31/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%$500,861 $503,665 $2,220
Brownsville TX #16405ST9 12/19/19 02/15/22 2.050%2.000%555,024 556,099 4,140
Laredo TX Waterworks #517039VW0 12/19/19 03/01/24 2.230%2.230%455,000 467,039 3,325
Oakland Univ Mich #673588HJ1 04/29/20 03/01/24 5.000%1.650%315,886 323,406 4,916
Philadelphia PA GO Ref #717813SW0 05/05/20 08/01/22 5.000%1.820%397,200 400,819 7,922
Maryland St DOT #574204WG4 05/06/20 06/15/22 4.350%1.200%263,756 264,787 386
University of CA #91412HFK4 07/16/20 05/15/23 0.628%0.628%25,000 25,006 20
New Jersey St #646039UD7 09/20/20 06/01/22 5.000%0.600%483,703 484,039 1,913
Rio Rancho NM #767175HM7 10/14/2020 5/15/2022 5.000%0.350%188,212 188,250 1,156
Cook, Kane, Lake, & McHenry #216181GL5 10/29/2020 12/15/2022 4.000%0.300%1,061,131 1,062,361 1,815
Miami-Dade Cnty #59333NN90 11/16/2020 12/15/2022 0.375%0.430%734,493 731,082 674
Hamilton NY #407741MC8 1/21/2021 5/1/2023 1.000%0.550%206,227 205,062 330
Southern Cal Pub Pwr #84247PHZ7 1/25/2021 4/1/2024 3.608%0.500%1,077,255 1,060,890 17,840
Hillsborough Cnty FL #43232VV3 3/11/2021 7/1/2024 1.815%0.770%512,943 506,380 4,462
Port Auth of NY and NJ #73358WAH7 4/15/2021 12/1/2024 5.859%0.600%576,027 565,540 2,279
City of Atlanta GA Water #047870SG6 4/19/2021 11/1/2024 0.616%0.500%250,816 245,835 240
West Contra Costa Cal Uni #9523474U3 6/17/2021 8/1/2024 0.575%0.575%500,000 492,690 1,541
New York NY City #64971XA40 10/7/2021 11/1/2024 0.450%0.620%711,582 699,413 518
NY Urban Dev Corp #650036AR7 11/5/2021 3/15/2023 0.720%0.451%501,621 500,465 1,050
Colorado Brdg Enterprise #19633SAZ6 11/24/2021 12/31/2023 0.923%0.844%500,779 498,355 26
Total Municipal Bonds $9,817,516 $9,781,183 $56,773
Corporate Bonds:
JP Morgan #48128BAB7 09/30/19 01/15/23 2.972%2.337%$1,006,405 $1,000,689 $13,704
American Express #025816CD9 05/05/20 05/20/22 2.750%1.290%502,843 503,491 1,423
PNC Bank #69349LAK4 12/7/2020 1/30/2023 2.950%0.457%1,047,345 1,042,554 12,537
Wells Fargo #94974BFJ4 12/7/2020 2/13/2023 3.450%0.480%1,435,780 1,430,120 18,250
Comerica Bank #200340AS6 12/23/2020 7/31/2023 3.700%0.500%525,182 520,317 7,708
Bank of America #06048WM23 5/14/2021 5/14/2024 0.650%0.650%915,000 901,814 743
Goldman Sachs #38141GXE9 7/27/2021 2/20/2024 3.625%0.693%637,268 629,434 7,854
Goldman Sachs #38150AGU3 7/28/2021 7/28/2023 0.550%0.550%655,000 638,229 1,531
Morgan Stanley #61746BDQ6 7/28/2021 4/29/2024 3.875%0.547%1,076,854 1,060,091 6,674
Citigroup #17329UEH0 11/18/2021 11/18/2024 1.000%1.149%1,000,000 999,124 1,167
Total Corporate Bonds $8,801,677 $8,725,863 $71,591
Government & Agency Obligations:
*Government National Mtg Assn #38379UEM4 02/29/16 02/16/51 2.300%2.245%$75,797 $63,010 $419
*Government National Mtg Assn #38381WV96 08/06/19 07/20/54 2.250%2.293%174,069 178,652 181
*Government National Mtg Assn #38380BNV3 12/05/19 06/20/46 2.000%2.112%352,491 357,890 453
Federal Home Loan Bank #3130AMVU3 06/29/21 06/29/26 0.500%0.500%500,000 494,547 0
*Government National Mtg Assn #38383DWC8 12/14/2021 11/20/2056 1.250%1.379%995,625 973,398 1,020
Total Government & Agency Obligations:$2,097,982 $2,067,497 $2,073
Certificates of Deposit:
State Bk India NY #8562846A7 01/26/17 01/26/22 2.250%2.250%$245,000 $245,353 $2,381
Wells Fargo #949495AN5 01/17/20 01/18/22 1.800%1.800%245,000 245,190 179
Bank Leumi #063248KQ0 03/31/20 03/31/22 1.250%1.250%245,000 245,612 766
Capital One Natl Assn #14042TCZ8 04/01/20 04/01/22 1.350%1.350%245,000 245,680 813
Synchrony Bank #87164WZN1 04/03/20 04/04/22 1.350%1.350%245,000 245,703 795
Goldman Sachs 38149MXG3 07/28/21 07/29/24 0.550%0.550%245,000 243,475 573
Sallie Mae #795451AD5 07/28/21 07/29/24 0.600%0.600%245,000 243,787 625
Texas Exchange Bk #88241TLS7 07/30/21 07/30/24 0.500%0.500%245,000 243,154 1
Toyota Financial #89235MLF6 08/05/21 8/5/2024 0.550%0.550%245,000 243,434 543
UBS Bank #90348JT42 09/22/21 9/23/2024 0.650%0.650%245,000 243,794 32
Total Certificates of Deposits $2,450,000 $2,445,182 $6,708
Total J.P.Morgan Securities $23,167,175 $23,019,725 $137,145
*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, 2021
Cash & Investments by Fund - Total $45.7 million
Cash & Investments by Type - Total $45.7 million
Checking
Illinois Funds
Certificates of Deposit
Municipal Bonds
Corporate Bonds
Government & Agency Obligations
Accrued Interest
General Corporate
56.8%
Hotel/Motel Tax
3.8%Motor Fuel Tax
2.5%
Infrastructure
23.8%
Promenade TIF
0.6%
Water
7.9%
Sports Core
1.3%
Golf Surcharge
0.6%
Self-Insurance
0.2%
Garage
0.7%
Equipment
Replacement
1.7%
Checking, $1.4
Illinois Funds, $21.0
Certificates of Deposit,
$2.5
Municipal Bonds, $9.8
Corporate Bonds, $8.8
Government & Agency
Obligations, $2.1
Accrued Interest, $0.1
in millions
YTD YTD
Net Fund Budgeted
YTD YTD Increase Increase
Governmental Funds Revenues Expenditures (Decrease)(Decrease)
General Fund (Major Fund)27,393,002$ 25,460,813$ 1,932,189$ (2,220,345)$
Main operating fund of the Village.
Hotel Fund (Major Fund)794,067$ 3,727,914$ (2,933,847)$ (3,972,280)$
Collects and spends resources from the
3% hotel/motel tax.
Motor Fuel Tax Fund 479,790$ -$ 479,790$ (832,825)$
Collects and spends resources from the
State motor fuel tax.
Infrastructure Fund (Major Fund)12,865,244$ 9,317,976$ 3,547,268$ 1,237,585$
Accounts for construction and maintenance of
roadways, drainage, and safety path systems.
Promenade TIF Fund (Major Fund)505,784$ 485,575$ 20,209$ 5,650$
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)11,684,329$ 14,333,409$ (2,649,080)$ (3,959,805)$
Collects user fees for the distribution of water
and maintenance of infrastructure.
Sports Core Fund (Major Fund)4,139,114$ 3,460,564$ 678,550$ (249,430)$
Accounts for revenues and expenses relating
to administration, programs, food and beverage
operations, and golf course.
Golf Surcharge Fund 146,180$ -$ 146,180$ (84,000)$
Accounts for the collection of the $3 per round
golf surcharge.
Internal Service Funds
Self Insurance Fund 3,905,799$ 3,614,580$ 291,219$ 19,400$
Accounts for the Village's health insurance costs
and the related contributions from the Village,
employees, retirees, and other agencies.
Garage Fund 610,604$ 518,036$ 92,568$ (152,610)$
Accounts for the maintenance of the Village's vehicle
fleet and the related departmental reimbursements.
Equipment Replacement Fund 382,252$ 315,905$ 66,347$ (451,270)$
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, 2021
Village of Oak Brook
Monthly Financial Report – Fund Narrative
For the Period Ending December 31, 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 December 2021 are $1,783,838, or 7.1%, higher than last December and
$2,980,942, or 12.5%, over budget to date. The main drivers for this are:
o Sales Tax revenue, the General
Fund’s largest revenue source, is
up $2,594,069 from last year
and $2,425,871 over budget.
December 2021 collections were
the highest December 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 $412,056 from last year and $616,922 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 $231,583 from last year and $309,107
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 down $1,096,780 from last year, but $247,456 over
budget. The decrease relates to a large building permit received in November 2020 that
resulted in revenue being near its highest levels seen.
o Charges for Services revenue is up $698,516 from last year and $246,079 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. Fiscal year 2021 has seen less ambulance bad
debts and insurance unallowables compared to prior years.
o Investment Interest revenue is down $181,091 from last year and $128,768 under
budget. Investment return rates have dropped significantly since the beginning of the
COVID-19 pandemic.
Total expenditures through December 2021 are $58,554, or 0.3%, lower than last year and
$1,071,592, or 4.6%, under budget to date. The main drivers for this are:
o Personnel expenditures are up $482,967 from last year, but $486,083 under budget.
The increase relates to normal salary increases and 100% pension funding compared to
2020. Personnel is under budget due to staff turnover and vacant positions.
o Operation and Contract expenditures are down $488,461 from last year and $284,891
under budget. The decrease relates to discontinuing contracted paramedic services in
2021.
In December 2021, the General Fund transferred $3,000,000 to the Infrastructure Fund to assist
with future capital improvements.
Hotel Tax Fund
Total revenues through December 2021 are $208,077, or 35.5%, higher than last year and
$332,067, or 71.9%, over budget to date. The main drivers for this are:
o Hotel tax revenue is up $262,101 from last year and $340,014 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 December 2021 are $642,514, or 76.9%, lower than last year and
$250,578, or 56.4%, 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 December 2021, the Hotel Tax Fund has transferred $3,450,462 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 December 2021 are up $927,644, or 18.0%, from last year and $708,442,
or 13.2%, over budget. The main drivers for this are:
o Non-home rule sales tax revenue is
up $971,728 from last year and
$711,099 over budget. December
2021 collections were the highest
December 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
$47,884 from last year and $5,936
under budget. Investment return
rates have dropped significantly since the beginning of the COVID-19 pandemic.
Total expenditures through December 2021 are up $2,432,654, or 36.3%, from last year, but
$3,357,029, or 26.9%, under budget to date. The main drivers for this are:
o Personnel expenditures are up $26,989 from last year, but $75,883 under budget.
Personnel is up due to multiple retirements and the related unused accrual time
payouts. Personnel is under budget due to a Public Works staffing reorganization.
o Operation and contract expenditures are up $302,220 from last year, but $305,233
under budget. Expenditures are up due to the timing of engineering and other
miscellaneous payments as many projects were delayed in 2020 to 2021.
o Capital Outlay expenditures are up $2,080,732 from last year, but $2,891,821 under
budget. Expenditures are up due to project delays from 2020 to 2021.
Through December 2021, the Infrastructure Fund has received $3,450,462 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. In addition, the Infrastructure Fund
received $3,000,000 from the General Fund to assist with future capital improvements.
Promenade TIF Fund
Total revenues through December 2021 are up $15,891, or 3.2%, from last year and $29,784, or
6.3%, over budget. Sales tax receipts have come in higher than anticipated in 2021 as economic
conditions have improved since the 2020 business closures.
Total expenditures through December 2021 are down $48,628, or 9.1%, from last year, but
$15,225, or 3.2%, over budget to date. Expenditures are over budget due to more principal
being paid on the note than originally projected. This is a result of more tax revenue being
collected than originally projected.
Water Fund
Total revenues through December 2021 are up $1,654,056, or 16.5%, from last year and
$779,329, or 7.1%, over budget. The main drivers for this are:
o Water sales revenue is up $891,503 from last year and $57,667 over budget. Revenue is
up in 2021 due to the business shutdowns in 2020 and a rate increase.
o Water connection fees revenue is up $166,710 from last year and $88,830 over budget.
This is due to construction on the Hines property and Restoration Hardware.
o Miscellaneous revenue is up $690,554 from last year and $646,951 over budget. This is
due to a payment related to the sale of non-corporate water lines.
Total expenditures through December 2021 are up $5,039,359, or 57.0%, from last year, but
$531,396, or 3.7%, under budget. The main drivers for this are:
o Operation and contract expenditures are down $66,558 from last year and $553,288
under budget. Expenditures are down and under budget due to DuPage Water
Commission water purchases being less than expected.
o Capital outlay expenditures are up $5,032,690 from last year and $83,946 over budget.
Many capital projects were delayed in 2020 due to the COVID-19 pandemic and pushed
into 2021, including multiple phases of the Brook Forest water main replacement
project.
Sports Core Fund
Total revenues through December 2021 are up $1,204,910, or 41.6%, from last year and
$630,314, or 18.2%, over budget to date. The main drivers for this are:
o Memberships revenue is up $129,178 from last year and $117,365 over budget. Golf
memberships have seen a significant increase in 2021 to some of the highest levels.
o Greens Fees revenue is up $165,753 from last year and $319,076 over budget. Rounds
played in 2021 were some of the highest levels seen.
o Driving Range Fees revenue is up $71,375 from last year and $91,440 over budget. This
is due to the golf course being able to open early and stay open this season.
o Rentals revenue is up $336,319 from last year and $64,705 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 $115,888 from last year and $72,882 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 $134,115 from last year and $114,244 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 December 2021 are down $226,967, or 6.3%, from last year, but
$597,666, or 15.0%, under budget to date. The main drivers for this are:
o Personnel expenditures are down $36,976 from last year and $154,482 under budget.
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 Materials and Supplies expenditures are up $128,518 from last year and $87,729 over
budget. This relates to an increase in food and beverage cost of sales from increased
activity at the golf café.
o Operation and contractual expenditures are up $119,659 from last year, but $63,630
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 $432,368 from last year and $467,283 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.
12/31/21 12/31/21
12/31/20 12/31/21 YTD % of YTD 2021 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 11,692,797$ 14,286,866$ 11,860,995$ 120.5%11,860,995$ 2,594,069$
Other Intergovernmental Tax*1,525,466 1,937,522 1,320,600 146.7%1,320,600 412,056
Telecommunications/Utility Tax 5,917,476 5,685,893 5,995,000 94.8%5,995,000 (231,583)
Grants 438,243 42,987 15,100 284.7%15,100 (395,256)
Licenses and Permits 3,524,596 2,427,816 2,180,360 111.3%2,180,360 (1,096,780)
Charges for Services 841,103 1,539,619 1,293,540 119.0%1,293,540 698,516
Fines and Penalties 193,147 139,421 180,500 77.2%180,500 (53,726)
Administrative Towing Fees 23,828 26,891 22,000 122.2%22,000 3,063
Investment Interest 352,323 171,232 300,000 57.1%300,000 (181,091)
Franchise Fees 151,877 159,960 202,000 79.2%202,000 8,083
Miscellaneous Income 354,623 381,110 448,280 85.0%448,280 26,487
Total Operating Revenues 25,015,479$ 26,799,317$ 23,818,375$ 112.5%23,818,375$ 1,783,838$
OPERATING EXPENDITURES
Personnel 18,046,930$ 18,529,897$ 19,015,980$ 97.4%18,842,080$ 482,967$
Materials and Supplies 461,172 436,833 551,030 79.3%551,030 (24,339)
Operation and Contract 3,600,780 3,112,319 3,397,210 91.6%3,397,210 (488,461)
Other Expenditures 6,547 8,599 10,000 86.0%10,000 2,052
Capital Outlay 298,053 267,280 452,300 59.1%452,300 (30,773)
Total Operating Expenditures 22,413,482$ 22,354,928$ 23,426,520$ 95.4%23,252,620$ (58,554)$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 2,601,997$ 4,444,389$ 391,855$ 565,755$ 1,842,392$
INTERFUND TRANSACTIONS
Transfers Out (383,561) (3,000,000)$ (3,100,000)$ 96.8%(100,000)$ (2,616,439)$
Reimbursements From Other Funds 626,395 593,685 593,685 100.0%593,685 (32,710)
Reimbursements To Other Funds (139,770) (105,885) (105,885) 100.0%(105,885) 33,885
Total Interfund Transactions 103,064$ (2,512,200)$ (2,612,200)$ 96.2%387,800$ (2,615,264)$
NET FUND INCREASE (DECREASE)2,705,061$ 1,932,189$ (2,220,345)$ 953,555$ (772,872)$
*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, 2021
Total Total
Revenues Expenditures
12/31/21 Actual 26,799,317$ 22,354,928$
12/31/20 Actual 25,015,479$ 22,413,482$
% Change From Last Year 7.1%-0.3%
Major Revenues
Other Telecom/Utility Licenses &Charges for
Sales Tax Intergov. Tax Tax Permits Services
12/31/21 Actual 14,286,866$ 1,937,522$ 5,685,893$ 2,427,816$ 1,539,619$
12/31/20 Actual $ 11,692,797 $ 1,525,466 $ 5,917,476 $ 841,103 $ 193,147
% Change From Last Year 22.2%27.0%-3.9%188.6%697.1%
Five Year Trend
Major Expenditures Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
12/31/21 Actual 18,529,897$ 436,833$ 3,112,319$ 8,599$ 267,280$
12/31/20 Actual 18,046,930$ 461,172$ 3,600,780$ 6,547$ 298,053$
% Change From Last Year 2.7%-5.3%-13.6%31.3%-10.3%
Five Year Trend
Expenditures by Department
12/31/20 12/31/21 12/31/21 12/31/21 2021 Difference Five
YTD YTD YTD % of Annual Prior Year
Department Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 2,192,928$ 2,359,152$ 2,536,170$ 93.0%2,498,625$ 166,224$
Financial Services 760,422 782,270 790,715 98.9%770,360 21,848
Public Works 832,836 818,356 950,045 86.1%948,860 (14,480)
Engineering & Capital Projects 70,167 42,025 209,000 20.1%209,000 (28,142)
Library 847,066 922,347 975,970 94.5%943,405 75,281
Police 8,816,334 9,026,150 9,337,225 96.7%9,213,585 209,816
Fire 7,831,669 7,451,482 7,518,205 99.1%7,576,045 (380,187)
Development Services 1,062,060 953,146 1,109,190 85.9%1,092,740 (108,914)
Total Expenditures 22,413,482$ 22,354,928$ 23,426,520$ 95.4%23,252,620$ (58,554)$
Five Year Trend
For the Period Ending December 31, 2021
General Fund - Five Year Trend
Village of Oak Brook
Revenues Expenditures
12/31/21 12/31/21
12/31/20 12/31/21 YTD % of YTD 2021 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Hotel Tax 491,913$ 754,014$ 414,000$ 182.1%414,000$ 262,101$
Investment Interest 68,551 30,781 40,000 77.0%40,000 (37,770)
Loan Interest 9,167 8,000 8,000 100.0%8,000 (1,167)
Miscellaneous 16,359 1,272 - N/A - (15,087)
Total Operating Revenues 585,990$ 794,067$ 462,000$ 171.9%462,000$ 208,077$
EXPENDITURES
Operation and Contract 362,638$ 188,152$ 193,945$ 97.0%193,945$ (174,486)$
Capital Outlay 473,243 5,215 250,000 2.1%250,000 (468,028)
Total Expenditures 835,881$ 193,367$ 443,945$ 43.6%443,945$ (642,514)$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES (249,891)$ 600,700$ 18,055$ 3327.1%18,055$ 850,591$
INTERFUND TRANSACTIONS
Transfer Out (122,978)$ (3,450,462)$ (3,906,250)$ 88.3%(100,000)$ (3,327,484)$
Reimbursements to Other Funds (74,715) (84,085) (84,085) 100.0%(84,085) (9,370)
Total Interfund Transactions (197,693)$ (3,534,547)$ (3,990,335)$ 88.6%(184,085)$ (3,336,854)$
NET FUND INCREASE (DECREASE)(447,584)$ (2,933,847)$ (3,972,280)$ (166,030)$ (2,486,263)$
Note - Expenditures are recorded in program 171.
Village of Oak Brook
Hotel Tax Fund Financial Update
For the Period Ending December 31, 2021
Total Total
Revenues Expenditures
12/31/21 Actual $ 794,067 193,367$
12/31/20 Actual $ 585,990 835,881$
% Change From Last Year 35.5%-76.9%
Major Revenues Investment
Hotel Tax Interest Loan Interest Miscellaneous
12/31/21 Actual $ 754,014 $ 30,781 8,000$ 1,272$
12/31/20 Actual $ 491,913 $ 68,551 9,167$ 16,359$
% Change From Last Year 53.3%-55.1%-12.7%-92.2%
Five Year Trend
Major Expenditures Operation &
Contractual Capital Outlay
12/31/21 Actual 188,152$ 5,215$
12/31/20 Actual 362,638$ 473,243$
% Change From Last Year -48.1%-98.9%
Five Year Trend
Village of Oak Brook
Hotel Tax Fund - Major Sources Five Year Trend
For the Period Ending December 31, 2021
Five Year Trend
Revenues Expenditures
12/31/21 12/31/21
12/31/20 12/31/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 5,072,871$ 6,044,599$ 5,333,500$ 113.3%5,333,500$ 971,728$
Charges for Services 335 - 1,000 0.0%1,000 (335)
Investment Interest 81,948 34,064 40,000 85.2%40,000 (47,884)
Miscellaneous 144 4,279 - N/A - 4,135
Total Operating Revenues 5,155,298$ 6,082,942$ 5,374,500$ 113.2%5,374,500$ 927,644$
OPERATING EXPENDITURES
Personnel 1,301,098$ 1,328,087$ 1,403,970$ 94.6%1,386,115$ 26,989$
Materials and Supplies 138,855 161,568 245,660 65.8%245,660 22,713
Operation and Contract 1,285,452 1,587,672 1,892,905 83.9%1,892,905 302,220
Capital Outlay 3,983,617 6,064,349 8,956,170 67.7%8,956,170 2,080,732
Total Operating Expenditures 6,709,022$ 9,141,676$ 12,498,705$ 73.1%12,480,850$ 2,432,654$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES (1,553,724)$ (3,058,734)$ (7,124,205)$ 42.9%(7,106,350)$ (1,505,010)$
INTERFUND TRANSACTIONS
Transfers In 971,212$ 6,450,462$ 8,206,250$ 78.6%1,400,000$ 5,479,250$
Reimbursements From Other Funds 359,380 331,840 331,840 100.0%331,840 (27,540)
Reimbursements To Other Funds (162,300) (176,300) (176,300) 100.0%(176,300) (14,000)
Total Interfund Transactions 1,168,292$ 6,606,002$ 8,361,790$ 79.0%1,555,540$ 5,437,710$
NET FUND INCREASE (DECREASE)(385,432)$ 3,547,268$ 1,237,585$ (5,550,810)$ 3,932,700$
Village of Oak Brook
Infrastructure Fund Financial Update
For the Period Ending December 31, 2021
Total Total
Revenues Expenditures
12/31/21 Actual $ 6,082,942 9,141,676$
12/31/20 Actual $ 5,155,298 6,709,022$
% Change From Last Year 18.0%36.3%
Major Revenues
Sales Tax
Charges for
Services
Investment
Interest Miscellaneous
12/31/21 Actual $ 6,044,599 $ - $ 34,064 $ 4,279
12/31/20 Actual $ 5,072,871 $ 335 $ 81,948 $ 144
% Change From Last Year 19.2%-100.0%-58.4%2871.5%
Five Year Trend
Major Expenditures Materials &Operation &
Personnel Supplies Contractual Capital Outlay
12/31/21 Actual 1,328,087$ 161,568$ 1,587,672$ 6,064,349$
12/31/20 Actual 1,301,098$ 138,855$ 1,285,452$ 3,983,617$
% Change From Last Year 2.1%16.4%23.5%52.2%
Five Year Trend
Expenditures by Department
12/31/20 12/31/21 12/31/21 12/31/21 2021 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 142,587$ 160,404$ 158,155$ 101.4%157,640$ 17,817$
Public Works 3,835,050 2,392,370 2,628,940 91.0%2,789,580 (1,442,680)
Engineering & Capital Projects 2,731,385 6,588,902 9,711,610 67.8%9,709,930 3,857,517
Total Expenditures 6,709,022$ 9,141,676$ 12,498,705$ 73.1%12,657,150$ 2,432,654$
Five Year Trend
Village of Oak Brook
Infrastructure Fund - Major Sources Five Year Trend
For the Period Ending December 31, 2021
Revenues Expenditures
12/31/21 12/31/21
12/31/20 12/31/21 YTD % of YTD 2021 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 74,805$ 97,268$ 75,000$ 129.7%75,000$ 22,463$
Real Estate Tax 414,544 408,456 400,000 102.1%400,000 (6,088)
Investment Interest 544 60 1,000 6.0%1,000 (484)
Total Operating Revenues 489,893$ 505,784$ 476,000$ 106.3%476,000$ 15,891$
EXPENDITURES
Operation and Contract 4,303$ 4,075$ 3,850$ 105.8%3,850$ (228)$
Other Expenditures 529,900 481,500 466,500 103.2%466,500 (48,400)
Total Expenditures 534,203$ 485,575$ 470,350$ 103.2%470,350$ (48,628)$
NET FUND INCREASE (DECREASE)(44,310)$ 20,209$ 5,650$ 5,650$ 64,519$
Note - Expenditures are recorded in program 283.
Village of Oak Brook
Promenade TIF Fund Financial Update
For the Period Ending December 31, 2021
Total Total
Revenues Expenditures
12/31/21 Actual $ 505,784 485,575$
12/31/20 Actual $ 489,893 534,203$
% Change From Last Year 3.2%-9.1%
Major Revenues Real Estate Investment
Sales Tax Tax Interest
12/31/21 Actual 97,268$ $ 408,456 $ 60
12/31/20 Actual 74,805$ $ 414,544 $ 544
% Change From Last Year 30.0%-1.5%-89.0%
Five Year Trend
Major Expenditures Operation &Other
Contractual Expenditures
12/31/21 Actual 4,075$ 481,500$
12/31/20 Actual 4,303$ 529,900$
% Change From Last Year -5.3%-9.1%
Five Year Trend
Village of Oak Brook
Promenade TIF Fund - Major Sources Five Year Trend
For the Period Ending December 31, 2021
Five Year Trend
Revenues Expenditures
12/31/21 12/31/21
12/31/20 12/31/21 YTD % of YTD 2021 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Plan Review Fees 1,050$ 525$ 1,000$ 52.5%1,000$ (525)$
Building/Inspection Fees 5,887 3,000 7,000 42.9%7,000 (2,887)
Water Sales 9,763,164 10,654,667 10,597,000 100.5%10,597,000 891,503
Unmetered Sales 82,626 46,702 35,000 133.4%35,000 (35,924)
Water Connection Fees 22,120 188,830 100,000 188.8%100,000 166,710
Meter Charges 15,082 7,826 15,000 52.2%15,000 (7,256)
Special Services 24,169 25,326 25,000 101.3%25,000 1,157
Investment Interest 94,778 45,502 60,000 75.8%60,000 (49,276)
Miscellaneous 21,397 711,951 65,000 1095.3%65,000 690,554
Total Operating Revenues 10,030,273$ 11,684,329$ 10,905,000$ 107.1%10,905,000$ 1,654,056$
OPERATING EXPENDITURES
Personnel 754,709$ 737,710$ 854,850$ 86.3%842,235$ (16,999)$
Materials and Supplies 40,640 130,866 75,780 172.7%75,780 90,226
Operation and Contract 4,893,195 4,826,637 5,379,925 89.7%5,379,925 (66,558)
Capital Outlay 3,155,006 8,187,696 8,103,750 101.0%8,103,750 5,032,690
Total Expenditures 8,843,550$ 13,882,909$ 14,414,305$ 96.3%14,401,690$ 5,039,359$
Surplus (Deficit) of Revenues Over
Expenditures 1,186,723$ (2,198,580)$ (3,509,305)$ 62.7%(3,496,690)$ (3,385,303)$
INTERFUND TRANSACTIONS
Reimbursements To Other Funds (526,815)$ (450,500)$ (450,500)$ 100.0%(450,500)$ 76,315$
Total Interfund Transactions (526,815)$ (450,500)$ (450,500)$ 100.0%(450,500)$ 76,315$
Fund Increase/(Decrease) - Budgetary Basis 659,908$ (2,649,080)$ (3,959,805)$ 66.9%(3,947,190)$ (3,308,988)$
ADUSTMENTS TO GAAP BASIS*
Remove Capital Outlay 3,155,006$ 8,187,696$
Depreciation Expense (548,703) (575,000)
IMRF Pension Expense (41,493) (45,000)
OPEB Expense 27,643 (30,000)
Total GAAP Adjustments 2,592,453$ 7,537,696$
Fund Increase/(Decrease) - GAAP Basis 3,252,361$ 4,888,616$
*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, 2021
Total Total
Revenues Expenditures
12/31/21 Actual $ 11,684,329 13,882,909$
12/31/20 Actual $ 10,030,273 8,843,550$
% Change From Last Year 16.5%57.0%
Unmetered Water
Water Sales Sales Connection Fees Meter Charges Miscellaneous
12/31/21 Actual $ 10,654,667 $ 46,702 $ 188,830 $ 7,826 $ 711,951
12/31/20 Actual $ 9,763,164 $ 82,626 $ 22,120 $ 15,082 $ 21,397
% Change From Last Year 9.1%-43.5%753.7%-48.1%3227.3%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
12/31/21 Actual 737,710$ 130,866$ 4,826,637$ -$ 8,187,696$
12/31/20 Actual 754,709$ 40,640$ 4,893,195$ -$ 3,155,006$
% Change From Last Year -2.3%222.0%-1.4%0.0%159.5%
Five Year Trend
Expenditures by Department
12/31/20 12/31/21 12/31/21 12/31/21 2021 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Public Works 5,713,002$ 5,631,604$ 6,330,555$ 89.0%6,317,940$ (81,398)$
Engineering & Capital Projects 3,130,548 8,251,305 8,083,750 102.1%8,083,750 5,120,757
Total Expenditures 8,843,550$ 13,882,909$ 14,414,305$ 96.3%14,401,690$ 5,039,359$
Five Year Trend
Village of Oak Brook
Water Fund - Major Sources Five Year Trend
For the Period Ending December 31, 2021
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Sports Core Fund Consolidated Presentation
For the Period Ending December 31, 2021
12/31/21 12/31/21
12/31/21 YTD % of YTD 2021 12/31/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,865$ 355,865$ 238,500$ 149.2%238,500$ 226,687$ 129,178$
Greens Fees - - - 1,304,076 1,304,076 985,000 132.4%985,000 1,138,323 165,753
Pro Shop Sales - - - 244,194 244,194 207,000 118.0%207,000 194,464 49,730
Golf Lessons - - - 50,140 50,140 45,000 111.4%45,000 41,580 8,560
Driving Range Fees - - - 341,440 341,440 250,000 136.6%250,000 270,065 71,375
Rentals - 110,500 216,189 499,016 825,705 761,000 108.5%761,000 489,386 336,319
Programs/User Fees - - - - - 31,500 0.0%31,500 - -
Food Sales - - - 280,382 280,382 207,500 135.1%207,500 164,494 115,888
Beverage Sales - - - 496,244 496,244 382,000 129.9%382,000 362,129 134,115
Taste of Oak Brook - - - - - 120,000 0.0%120,000 - -
Grants 138,217 59,994 - - 198,211 233,600 84.9%233,600 - 198,211
Other Revenue 8,761 - (19,805) 13,901 2,857 7,700 37.1%7,700 7,076 (4,219)
Total Operating Revenues 146,978$ 170,494$ 196,384$ 3,585,258$ 4,099,114$ 3,468,800$ 118.2%3,468,800$ 2,894,204$ 1,204,910$
OPERATING EXPENDITURES
Personnel 16,251$ -$ 126,165$ 1,320,567$ 1,462,983$ 1,617,465$ 90.4%1,597,610$ 1,499,959$ (36,976)$
Materials & Supplies 32,675 - 6,867 676,637 716,179 628,450 114.0%628,450 587,661 128,518
Operational & Contractual 112,296 34,714 72,936 379,459 599,405 663,035 90.4%663,035 479,746 119,659
Other - - - (39,000) (39,000) (39,000) 100.0%(39,000) (33,200) (5,800)
Capital 386,809 119,988 4,382 146,918 658,097 1,125,380 58.5%1,125,380 1,090,465 (432,368)
Total Operating Expenditures 548,031$ 154,702$ 210,350$ 2,484,581$ 3,397,664$ 3,995,330$ 85.0%3,975,475$ 3,624,631$ (226,967)$
B&T Administration Overhead Allocation*24,921$ -$ (24,921)$ -$ -$ -$ 0.0%-$ -$ -$
Operating Revenues Over (Under) Expenditures (376,132)$ 15,792$ (38,887)$ 1,100,677$ 701,450$ (526,530)$ -133.2%(506,675)$ (730,427)$ 1,431,877$
INTERFUND TRANSACTIONS
Transfer From General Fund -$ -$ -$ -$ -$ 100,000$ 0.0%100,000$ 383,561$ (383,561)$
Transfer From Golf Surcharge Fund - - - - - 200,000 0.0%200,000 340,065 (340,065)
Reimbursement From Infrastructure Fund 32,000 - - - 32,000 32,000 100.0%32,000 24,000 8,000
Reimbursement From Water Fund 8,000 - - - 8,000 8,000 100.0%8,000 8,000 -
Reimbursement To General Fund (15,725) - - (47,175) (62,900) (62,900) 100.0%(62,900) (56,450) (6,450)
Total Interfund Transactions 24,275$ -$ -$ (47,175)$ (22,900)$ 277,100$ -8.3%277,100$ 699,176$ (722,076)$
Total Revenues Over (Under) Expenditures - Budgetary Basis (351,857)$ 15,792$ (38,887)$ 1,053,502$ 678,550$ (249,430)$ (229,575)$ (31,251)$ 709,801$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay 386,809$ 119,988$ 4,382$ 146,918$ 658,097$ 1,090,465$
Depreciation Expense (127,460) (13,820) (62,600) (235,935) (439,815) (389,082)
IMRF Pension Expense (1,000) - (2,000) (23,000) (26,000) (26,154)
OPEB Expense - - (2,750) (23,100) (25,850) (25,246)
Total GAAP Adjustments 258,349$ 106,168$ (62,968)$ (135,117)$ 166,432$ 649,983$
Fund Increase/(Decrease) - GAAP Basis (93,508)$ 121,960$ (101,855)$ 918,385$ 844,982$ 618,732$
*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
12/31/21 Actual $ 4,099,114 3,397,664$
12/31/20 Actual $ 2,894,204 3,624,631$
% Change From Last Year 41.6%-6.3%
Driving Program/
Memberships Greens Fees Range Fees Rentals User Fees
12/31/21 Actual $ 355,865 $ 1,304,076 $ 341,440 $ 825,705 -$
12/31/20 Actual $ 226,687 $ 1,138,323 $ 270,065 $ 489,386 -$
% Change From Last Year 57.0%14.6%26.4%68.7%0.0%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
12/31/21 Actual 1,462,983$ 716,179$ 599,405$ (39,000)$ 658,097$
12/31/20 Actual 1,499,959$ 587,661$ 479,746$ (33,200)$ 1,090,465$
% Change From Last Year -2.5%21.9%24.9%0.0%-39.6%
Five Year Trend
Revenues by Department 12/31/20 12/31/21 12/31/21 12/31/21 2021 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Operations 2,101$ 146,978$ 325,800$ 45.1%325,800$ 6,660$
Open Field Operations 102,540 170,494 230,000 74.1%230,000 7,960
B&T Clubhouse Operations 20,402 196,384 267,000 73.6%267,000 175,982
Golf Club 2,769,161 3,585,258 2,646,000 135.5%2,646,000 816,097
Total Revenues 2,894,204$ 4,099,114$ 3,468,800$ 118.2%3,468,800$ 1,006,699$
Expenditures by Department 12/31/20 12/31/21 12/31/21 % of YTD 2021 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Operations 588,906$ 548,031$ 780,740$ 70.2%780,740$ (40,875)$
Open Field Operations 54,050$ 154,702$ 358,910$ 43.1%358,910$ 100,652$
B&T Clubhouse Operations 311,331 210,350 265,260 79.3%262,635 (100,981)
Golf Club 2,670,344 2,484,581 2,590,420 95.9%2,573,190 (185,763)
Total Expenditures 3,624,631$ 3,397,664$ 3,995,330$ 85.0%3,975,475$ (226,967)$
Five Year Trend
Village of Oak Brook
Sports Core Fund - Major Sources Five Year Trend
For the Period Ending December 31, 2021
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Bath & Tennis Club Recreation Operations
For the Period Ending December 31, 2021 12/31/21 12/31/21
822 12/31/21 YTD % of YTD 2021 12/31/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 138,217 - - - 138,217 233,600 59.2%233,600 - -
Other Revenue 8,761 - - - 8,761 700 1251.6%700 1,902 6,859
Total Operating Revenues 146,978$ -$ -$ -$ 146,978$ 325,800$ 45.1%325,800$ 2,101$ 6,660$
OPERATING EXPENDITURES
Personnel 16,251$ -$ -$ -$ 16,251$ 119,110$ 13.6%119,110$ 56,776$ (40,525)$
Materials & Supplies 593 27,913 2,460 1,709 32,675 37,250 87.7%37,250 3,761 28,914
Operational & Contractual 66,841 38,075 7,157 223 112,296 89,550 125.4%89,550 76,003 36,293
Capital 276,434 110,375 - - 386,809 534,830 72.3%534,830 452,366 (65,557)
Total Operating Expenditures 360,119$ 176,363$ 9,617$ 1,932$ 548,031$ 780,740$ 70.2%780,740$ 588,906$ (40,875)$
B&T Administration Overhead Allocation*50,650$ (18,525)$ (5,146)$ (2,058)$ 24,921$ 44,755$ 55.7%44,755$ 100,814$ (75,893)$
Operating Revenues Over (Under) Expenditures (162,491)$ (194,888)$ (14,763)$ (3,990)$ (376,132)$ (410,185)$ 91.7%(410,185)$ (485,991)$ (28,358)$
INTERFUND TRANSACTIONS
Transfer From General Fund -$ -$ -$ -$ -$ 100,000$ 0.0%100,000$ 383,561$ (383,561)$
Reimbursement From Infrastructure Fund 32,000 - - - 32,000 32,000 100.0%32,000 24,000 8,000
Reimbursement From Water Fund 8,000 - - - 8,000 8,000 100.0%8,000 8,000 -
Reimbursement To General Fund (15,725) - - - (15,725) (15,725) 100.0%(15,725) (28,225) 12,500
Total Interfund Transactions 24,275$ -$ -$ -$ 24,275$ 124,275$ 19.5%124,275$ 387,336$ (363,061)$
Total Revenues Over (Under) Expenditures - Budgetary Basis (138,216)$ (194,888)$ (14,763)$ (3,990)$ (351,857)$ (285,910)$ (285,910)$ (98,655)$ (391,419)$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay 276,434$ 110,375$ -$ -$ 386,809$ 452,366$
Depreciation Expense (13,600) (110,000) (2,690) (1,170) (127,460) (92,107)
IMRF Pension Expense (1,000) - - - (1,000) (1,119)
Total GAAP Adjustments 261,834$ 375$ (2,690)$ (1,170)$ 258,349$ 359,140$
Fund Increase/(Decrease) - GAAP Basis 123,618$ (194,513)$ (17,453)$ (5,160)$ (93,508)$ 260,485$
*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, 2021 12/31/21 12/31/21
12/31/21 YTD % of YTD 2021 12/31/20 Difference
815 816 YTD Amended Amended Adopted YTD Prior
Polo Open Fields Total Budget Budget Budget Total Year
OPERATING REVENUES
Field Rentals -$ 30,500$ 30,500$ 30,000$ 101.7%30,000$ 27,540$ 2,960$
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 - -
Grants - 59,994 59,994 - N/A - - -
Total Operating Revenues -$ 170,494$ 170,494$ 230,000$ 74.1%230,000$ 102,540$ 7,960$
OPERATING EXPENDITURES
Materials & Supplies -$ -$ -$ 500$ 0.0%500$ 119$ (119)$
Operational & Contractual 25,000 9,714 34,714 190,360 18.2%190,360 44,510 (9,796)
Capital - 119,988 119,988 168,050 71.4%168,050 9,421 110,567
Total Operating Expenditures 25,000$ 129,702$ 154,702$ 358,910$ 43.1%358,910$ 54,050$ 100,652$
Total Revenues Over (Under) Expenditures - Budgetary Basis (25,000)$ 40,792$ 15,792$ (128,910)$ (128,910)$ 48,490$ (92,692)$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay -$ 119,988$ 119,988$ 9,421$
Depreciation Expense - (13,820) (13,820) (1,685)
Total GAAP Adjustments -$ 106,168$ 106,168$ 7,736$
Fund Increase/(Decrease) - GAAP Basis (25,000)$ 146,960$ 121,960$ 56,226$
*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, 2021
12/31/21 12/31/21
821 YTD % of YTD 2021 12/31/20 Difference
B&T Amended Amended Adopted YTD Prior
Clubhouse Budget Budget Budget Total Year
OPERATING REVENUES
Rentals 216,189$ 267,000$ 81.0%267,000$ 20,402$ 195,787$
Other Revenue (19,805) - N/A - - (19,805)
Total Operating Revenues 196,384$ 267,000$ 73.6%267,000$ 20,402$ 175,982$
OPERATING EXPENDITURES
Personnel 126,165$ 136,210$ 92.6%133,585$ 108,825$ 17,340$
Materials & Supplies 6,867 12,000 57.2%12,000 1,765 5,102
Operational & Contractual 72,936 107,550 67.8%107,550 55,669 17,267
Capital 4,382 9,500 46.1%9,500 145,072 (140,690)
Total Operating Expenditures 210,350$ 265,260$ 79.3%262,635$ 311,331$ (100,981)$
B&T Administration Overhead Allocation*(24,921)$ (44,755)$ 55.7%(44,755)$ (100,814)$ 75,893$
Total Revenues Over (Under) Expenditures - Budgetary Basis (38,887)$ (43,015)$ (40,390)$ (391,743)$ 352,856$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay 4,382$ 145,072$
Depreciation Expense (62,600) (60,555)
IMRF Pension Expense (2,000) (2,073)
OPEB Expense (2,750) (2,644)
Total GAAP Adjustments (62,968)$ 79,800$
Fund Increase/(Decrease) - GAAP Basis (101,855)$ (311,943)$
*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, 2021
12/31/21 12/31/21
823 831 832 833 834 12/31/21 YTD % of YTD 2021 12/31/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,865$ -$ -$ -$ 355,865$ 238,500$ 149.2%238,500$ 226,488$ 129,377$
Greens Fees - 1,304,076 - - - 1,304,076 985,000 132.4%985,000 1,138,323 165,753
Pro Shop Sales - 244,194 - - - 244,194 207,000 118.0%207,000 194,464 49,730
Golf Lessons - - 50,140 - - 50,140 45,000 111.4%45,000 41,580 8,560
Driving Range Fees - - 341,440 - - 341,440 250,000 136.6%250,000 270,065 71,375
Rentals - 2,715 9,000 487,301 - 499,016 384,000 130.0%384,000 366,444 132,572
Food Sales 280,382 - - - - 280,382 169,500 165.4%169,500 164,494 115,888
Beverage Sales 496,244 - - - - 496,244 360,000 137.8%360,000 362,129 134,115
Other Revenue - 13,901 - - - 13,901 7,000 198.6%7,000 5,174 8,727
Total Operating Revenues 776,626$ 1,920,751$ 400,580$ 487,301$ -$ 3,585,258$ 2,646,000$ 135.5%2,646,000$ 2,769,161$ 816,097$
OPERATING EXPENDITURES
Personnel 238,105$ 560,413$ 84,888$ 42,404$ 394,757$ 1,320,567$ 1,362,145$ 96.9%1,344,915$ 1,334,358$ (13,791)$
Materials & Supplies 281,070 198,846 16,171 2,469 178,081 676,637 578,700 116.9%578,700 582,016 94,621
Operational & Contractual 5,937 266,290 14,799 56,910 35,523 379,459 275,575 137.7%275,575 303,564 75,895
Other - - - - (39,000) (39,000) (39,000) 0.0%(39,000) (33,200) (5,800)
Capital 6,678 19,702 - - 120,538 146,918 413,000 35.6%413,000 483,606 (336,688)
Total Operating Expenditures 531,790$ 1,045,251$ 115,858$ 101,783$ 689,899$ 2,484,581$ 2,590,420$ 95.9%2,573,190$ 2,670,344$ (185,763)$
Operating Revenues Over (Under) Expenditures 244,836$ 875,500$ 284,722$ 385,518$ (689,899)$ 1,100,677$ 55,580$ 1980.3%72,810$ 98,817$ 1,001,860$
INTERFUND TRANSACTIONS
Transfer from Golf Surcharge -$ -$ -$ -$ -$ -$ 200,000$ 0.0%200,000$ 340,065$ (340,065)$
Reimbursement to General Fund - (47,175) - - - (47,175) (47,175) 100.0%(47,175) (28,225) (18,950)
Total Interfund Transactions -$ (47,175)$ -$ -$ -$ (47,175)$ 152,825$ -30.9%152,825$ 311,840$ (359,015)$
Total Revenues Over (Under) Expenditures - Budgetary Basis 244,836$ 828,325$ 284,722$ 385,518$ (689,899)$ 1,053,502$ 208,405$ 225,635$ 410,657$ 642,845$
ADUSTMENTS TO GAAP BASIS*
Remove Capital Outlay 6,678$ 19,702$ -$ -$ 120,538$ 146,918$ 483,606$
Depreciation Expense (3,020) (95,815) (2,300) (12,250) (122,550) (235,935) (234,735)
IMRF Pension Expense (2,500) (9,500) (1,000) - (10,000) (23,000) (22,962)
OPEB Expense (2,600) (13,000) - - (7,500) (23,100) (22,602)
Total GAAP Adjustments (1,442)$ (98,613)$ (3,300)$ (12,250)$ (19,512)$ (135,117)$ 203,307$
Fund Increase/(Decrease) - GAAP Basis 243,394$ 729,712$ 281,422$ 373,268$ (709,411)$ 918,385$ 613,964$
*Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.