08 - August 2021 Monthly Financial ReportVILLAGE
OAK BROOK
OF
MONTHLY FINANCIAL REPORTS
AUGUST 2021
Cash and Investments by Fund:Total
Cash and Cash Pooled Cash and
Fund Equivalents Investments Investments % By Fund
General Corporate $13,954,667 $13,330,103 $27,284,770 58.6%
Hotel/Motel Tax 399,632 2,132,014 2,531,646 5.4%
Motor Fuel Tax 1,025,896 18,799 1,044,695 2.2%
Infrastructure 4,938,876 3,122,128 8,061,004 17.3%
Promenade TIF 243,789 - 243,789 0.5%
Water 1,586,625 3,498,521 5,085,146 10.9%
Sports Core 599,477 - 599,477 1.3%
Golf Surcharge 222,251 - 222,251 0.5%
Self-Insurance 362,744 - 362,744 0.8%
Garage 348,413 - 348,413 0.7%
Equipment Replacement 354,135 402,139 756,274 1.6%
Total $24,036,505 $22,503,704 $46,540,209 100.0%
Change in Cash and Investments by Fund :
Balance at Balance at Year-to-Date Year-to-Date
Fund January 1, 2021 August 31, 2021 Change ($)Change (%)
General Corporate $23,894,312 $27,284,770 $3,390,458 14.2%
Hotel/Motel Tax 4,567,176 2,531,646 (2,035,530)-44.6%
Motor Fuel Tax 673,455 1,044,695 371,240 55.1%
Infrastructure 7,480,975 8,061,004 580,029 7.8%
Promenade TIF 267,300 243,789 (23,511)-8.8%
Water 6,900,169 5,085,146 (1,815,023)-26.3%
Sports Core 114,133 599,477 485,344 425.2%
Golf Surcharge 132,593 222,251 89,658 67.6%
Self-Insurance - 362,744 362,744 N/A
Garage 298,348 348,413 50,065 16.8%
Equipment Replacement 696,392 756,274 59,882 8.6%
$45,024,853 $46,540,209 $1,515,356 3.4%
Book Bank/Market
Value Value
Cash and Cash Equivalents:
Pooled Checking $1,964,557 $2,217,034
Sports Core Checking 834,157 815,797
Pooled IPTIP 20,917,957 20,917,957
Water E-Pay IPTIP 319,834 284,241
$24,036,505 $24,235,029
Pooled Investments:
Investments-Municipal Bonds $8,910,790 $8,955,158
Investments-Corporate Bonds 9,350,697 9,352,570
Government & Agency Obligations 1,407,579 1,416,819
Certificates of Deposit 2,695,000 2,702,921
Accrued Interest 139,638 139,638
Total Pooled Investments $22,503,704 $22,567,106
Total Cash and Investments $46,540,209 $46,802,135
For August, total interest revenue is $21,473 and YTD is $211,429. The total investment yield for the portfolio is:
Pooled
Investments Illinois Funds Total
Last 12 months yield 1.44%0.07%0.81%
The weighted average yield of the current investment portfolio is 1.10%. The IL Funds August average daily rate was 0.02%.
Monthly Treasurer's Report
August 31, 2021
Monthly Treasurer's Report
August 2021
The table below lists the detail investment holdings at J.P. Morgan Securities as of 8/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%$501,785 $507,605 $4,478
State of IL #452152P54 10/09/19 11/01/21 5.000%1.870%502,625 503,945 8,081
Brownsville TX #16405ST9 12/19/19 02/15/22 2.050%2.000%555,116 559,351 348
Laredo TX Waterworks #517039VW0 12/19/19 03/01/24 2.230%2.230%455,000 473,155 5,017
Oakland Univ Mich #673588HJ1 04/29/20 03/01/24 5.000%1.650%319,054 329,055 7,375
Philadelphia PA GO Ref #717813SW0 05/05/20 08/01/22 5.000%1.820%401,275 407,460 1,422
Maryland St DOT #574204WG4 05/06/20 06/15/22 4.350%1.200%266,464 268,499 2,271
University of CA #91412HFK4 07/16/20 05/15/23 0.628%0.628%25,000 25,155 46
Universty of IL #914353YH4 08/31/20 10/01/21 3.000%0.701%250,470 250,570 3,125
New Jersey St #646039UD7 09/20/20 06/01/22 5.000%0.600%490,643 492,100 5,872
Rio Rancho NM #767175HM7 10/14/2020 5/15/2022 5.000%0.350%191,074 191,333 2,698
Cook, Kane, Lake, & McHenry #216181GL5 10/29/2020 12/15/2022 4.000%0.300%1,073,729 1,076,660 34,386
Miami-Dade Cnty #59333NN90 11/16/2020 12/15/2022 0.375%0.430%734,360 732,927 1,133
Hamilton NY #407741MC8 1/21/2021 5/1/2023 1.000%0.550%206,532 206,298 672
Southern Cal Pub Pwr #84247PHZ7 1/25/2021 4/1/2024 3.608%0.500%1,087,475 1,082,870 5,813
Hillsborough Cnty FL #43232VV3 3/11/2021 7/1/2024 1.815%0.770%514,648 513,060 1,437
Port Auth of NY and NJ #73358WAH7 4/15/2021 12/1/2024 5.859%0.600%584,629 584,535 7,161
City of Atlanta GA Water #047870SG6 4/19/2021 11/1/2024 0.616%0.500%250,911 250,455 496
West Contra Costa Cal Uni #9523474U3 6/17/2021 8/1/2024 0.575%0.575%500,000 500,125 583
Total Municipal Bonds $8,910,790 $8,955,158 $92,414
Corporate Bonds:
Citigroup #172967LC3 04/01/19 12/08/21 2.900%2.754%$1,000,477 $1,004,995 $6,122
American Honda #02665WBG5 07/31/19 09/09/21 1.700%2.180%499,974 500,147 4,084
JP Morgan #48128BAB7 09/30/19 01/15/23 2.972%2.337%1,008,463 1,010,261 3,798
American Express #025816CD9 05/05/20 05/20/22 2.750%1.290%505,257 507,961 3,715
PNC Bank #69349LAK4 12/7/2020 1/30/2023 2.950%0.457%1,055,771 1,055,430 2,508
Wells Fargo #94974BFJ4 12/7/2020 2/13/2023 3.450%0.480%1,449,454 1,450,226 2,265
Comerica Bank #200340AS6 12/23/2020 7/31/2023 3.700%0.500%530,468 529,964 1,542
Bank of America #06048WM23 5/14/2021 5/14/2024 0.650%0.650%915,000 913,536 248
Goldman Sachs #38141GXE9 7/27/2021 2/20/2024 3.625%0.693%643,038 642,288 604
Goldman Sachs #38150AGU3 7/28/2021 7/28/2023 0.550%0.550%655,000 654,599 330
Morgan Stanley #61746BDQ6 7/28/2021 4/29/2024 3.875%0.547%1,087,795 1,083,163 13,132
Total Corporate Bonds $9,350,697 $9,352,570 $38,348
Government & Agency Obligations:
*Government National Mtg Assn #38379UEM4 02/29/16 02/16/51 2.300%2.245%$220,964 $210,016 $598
*Government National Mtg Assn #38381WV96 08/06/19 07/20/54 2.250%2.293%282,868 290,930 398
*Government National Mtg Assn #38380BNV3 12/05/19 06/20/46 2.000%2.112%403,747 416,857 555
Federal Home Loan Bank #3130AMVU3 06/29/21 06/29/26 0.500%0.500%500,000 499,016 417
Total Government & Agency Obligations:$1,407,579 $1,416,819 $1,968
Certificates of Deposit:
State Bk India NY #8562846A7 01/26/17 01/26/22 2.250%2.250%$245,000 $247,204 $544
Wells Fargo #949763J31 09/18/19 09/20/21 1.850%1.850%245,000 245,244 184
BMW Bank #05580ASQ8 10/11/19 10/12/21 1.800%1.800%245,000 245,497 1,647
Wells Fargo #949495AN5 01/17/20 01/18/22 1.800%1.800%245,000 246,631 183
Bank Leumi #063248KQ0 03/31/20 03/31/22 1.250%1.250%245,000 246,721 1,276
Capital One Natl Assn #14042TCZ8 04/01/20 04/01/22 1.350%1.350%245,000 246,857 1,369
Synchrony Bank #87164WZN1 04/03/20 04/04/22 1.350%1.350%245,000 246,883 1,351
Goldman Sachs 38149MXG3 07/28/21 07/29/24 0.550%0.550%245,000 244,484 124
Sallie Mae #795451AD5 07/28/21 07/29/24 0.600%0.600%245,000 244,837 135
Texas Exchange Bk #88241TLS7 07/30/21 07/30/24 0.500%0.500%245,000 244,124 1
Toyota Financial #89235MLF6 08/05/21 8/5/2024 0.550%0.550%245,000 244,439 94
Total Certificates of Deposits $2,695,000 $2,702,921 $6,908
Total J.P.Morgan Securities $22,364,066 $22,427,468 $139,638
*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
August 31, 2021
Cash & Investments by Fund - Total $46.5 million
Cash & Investments by Type - Total $46.5 million
Checking
Illinois Funds
Certificates of Deposit
Municipal Bonds
Corporate Bonds
Government & Agency Obligations
Accrued Interest
General Corporate
58.6%
Hotel/Motel Tax
5.4%Motor Fuel Tax
2.2%
Infrastructure
17.3%
Promenade TIF
0.5%
Water
10.9%
Sports Core
1.3%
Golf Surcharge
0.5%
Self-Insurance
0.8%
Garage
0.7%
Equipment
Replacement
1.6%
Checking, $2.8
Illinois Funds, $21.2
Certificates of Deposit,
$2.7
Municipal Bonds, $8.9
Corporate Bonds, $9.4
Government & Agency
Obligations, $1.4
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)17,260,239$ 14,152,491$ 3,107,748$ 844,785$
Main operating fund of the Village.
Hotel Fund (Major Fund)443,250$ 2,520,245$ (2,076,995)$ (2,032,415)$
Collects and spends resources from the
3% hotel/motel tax.
Motor Fuel Tax Fund 370,935$ -$ 370,935$ 69,175$
Collects and spends resources from the
State motor fuel tax.
Infrastructure Fund (Major Fund)6,982,892$ 7,157,503$ (174,611)$ (1,669,540)$
Accounts for construction and maintenance of
roadways, drainage, and safety path systems.
Promenade TIF Fund (Major Fund)461,627$ 485,138$ (23,511)$ (218,470)$
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)7,077,862$ 8,187,589$ (1,109,727)$ (5,163,755)$
Collects user fees for the distribution of water
and maintenance of infrastructure.
Sports Core Fund (Major Fund)3,021,399$ 2,544,961$ 476,438$ (486,285)$
Accounts for revenues and expenses relating
to administration, programs, food and beverage
operations, and golf course.
Golf Surcharge Fund 89,658$ -$ 89,658$ (117,340)$
Accounts for the collection of the $3 per round
golf surcharge.
Internal Service Funds
Self Insurance Fund 2,669,463$ 2,166,494$ 502,969$ 70$
Accounts for the Village's health insurance costs
and the related contributions from the Village,
employees, retirees, and other agencies.
Garage Fund 407,217$ 374,200$ 33,017$ (84,080)$
Accounts for the maintenance of the Village's vehicle
fleet and the related departmental reimbursements.
Equipment Replacement Fund 257,776$ 194,410$ 63,366$ (71,730)$
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 August 31, 2021
Village of Oak Brook
Monthly Financial Report – Fund Narrative
For the Period Ending August 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 August 2021 are
$1,889,599, or 12.6%, higher than last
August and $857,760, or 5.4%, over
budget to date. The main drivers for this
are:
o Sales Tax revenue, the General
Fund’s largest revenue source, is
up $1,497,535 from last year
and $947,538 over budget.
August 2021 collections were
the highest August in the past
five years, with 2020 being affected by COVID-19 related business restrictions.
o Other Intergovernmental Tax revenue is up $288,299 from last year and $408,544 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 $258,174 from last year and $332,145
under budget. The decrease primarily relates to amended telecommunications tax
returns that were processed in 2021. We have also seen a decrease in tax revenue as a
result of remote working over the last year.
o Licenses and Permits revenue is up $93,320 from last year, but $128,401 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 $343,134 from last year and $87,450 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 $133,905 from last year and $73,724 under
budget. Investment return rates have dropped significantly since the beginning of the
COVID-19 pandemic.
Total expenditures through August 2021 are $1,044,262, or 6.9%, lower than last year and
$1,305,211, or 8.5%, under budget to date. The main drivers for this are:
o Personnel expenditures are down $931,288 from last year and $868,600 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 August 2021 are $19,043, or 4.5%, higher than last year and $136,170,
or 44.3%, over budget to date. The main drivers for this are:
o Hotel tax revenue is up $46,663 from last year and $138,862 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 August 2021 are $483,467, or 85.7%, lower than last year and
$202,873, or 71.6%, 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 August 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 August 2021 are up $1,116,836, or 34.2%, from last year and $790,138,
or 22.0%, over budget. The main drivers for this are:
o Non-home rule sales tax revenue
is up $614,222 from last year
and $246,885 over budget.
August 2021 collections were
the highest August in the past
five years, with 2020 being
affected by COVID-19 related
business restrictions.
o Investment Interest revenue is
down $44,995 from last year and
$4,011 under budget.
Investment return rates have dropped significantly since the beginning of the COVID-19
pandemic.
Total expenditures through August 2021 are up $2,910,776, or 70.5%, from last year, but
$721,103, or 9.3%, under budget to date. The main drivers for this are:
o Personnel expenditures are up $62,629 from last year and $22,193 over budget. This is
due to multiple retirements and the related unused accrual time payouts.
o Operation and contract expenditures are up $184,487 from last year, but $208,137
under budget. Expenditures are under budget due to the timing of engineering and
other miscellaneous payments.
o Capital Outlay expenditures are up $2,650,338 from last year, but $527,724 under
budget. Expenditures are up due to project delays last year and general timing of work
performed.
Through August 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 August 2021 are up $217,566, or 89.1%, from last year and $210,097, or
83.5%, over budget. This is due to the second real estate tax allotment being received earlier
than anticipated.
Total expenditures through August 2021 are down $48,427, or 9.1%, from last year, but
$15,138, or 3.2%, 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 August 2021 are up $1,313,523, or 22.8%, from last year and $556,682,
or 8.5%, over budget. The main drivers for this are:
o Water sales revenue is up $570,065 from last year, but $175,025 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 $173,400 from last year and $118,930 over
budget. This is due to construction on the Hines property and Restoration Hardware.
o Miscellaneous revenue is up $636,387 from last year and $613,020 over budget. This is
due to a payment related to the sale of non-corporate water lines.
Total expenditures through August 2021 are up $3,289,313, or 71.5%, from last year, but
$3,497,362, or 30.7%, under budget. The main drivers for this are:
o Operation and contract expenditures are up $134,078 from last year, but $736,676
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,030,279 from last year, but $2,797,810 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 August 2021 are up $955,618, or 46.9%, from last year and $515,772, or
20.8%, 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 $230,532 from last year and $239,839 over budget. The
course did not see much activity in early 2020 due to COVID-19 restrictions.
o Driving Range Fees revenue is up $91,148 from last year and $76,119 over budget. This
is due to the golf course being able to open early and stay open this season.
o Food sales are up $99,494 from last year and $55,818 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 $136,416 from last year and $116,791 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 August 2021 are up $57,235, or 2.3%, from last year, but $746,952,
or 23.0%, under budget to date. The main drivers for this are:
o Personnel expenditures are up $76,538 from last year, but $76,484 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 Capital outlay expenditures are down $217,642 from last year and $484,469 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.
8/31/21 8/31/21
8/31/20 8/31/21 YTD % of YTD 2021 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 7,316,243$ 8,813,778$ 7,866,240$ 112.0%11,860,995$ 1,497,535$
Other Intergovernmental Tax*1,069,495 1,357,794 949,250 143.0%1,320,600 288,299
Telecommunications/Utility Tax 3,995,029 3,736,855 4,069,000 91.8%5,995,000 (258,174)
Licenses and Permits 1,271,874 1,365,194 1,493,595 91.4%2,180,360 93,320
Charges for Services 590,686 933,820 846,370 110.3%1,293,540 343,134
Fines and Penalties 112,048 103,257 120,360 85.8%180,500 (8,791)
Administrative Towing Fees 12,664 20,018 14,680 136.4%22,000 7,354
Investment Interest 260,181 126,276 200,000 63.1%300,000 (133,905)
Franchise Fees 101,907 106,146 151,500 70.1%202,000 4,239
Grants 11,690 39,301 7,500 0.0%15,100 27,611
Miscellaneous Income 233,039 262,016 288,200 90.9%448,280 28,977
Total Operating Revenues 14,974,856$ 16,864,455$ 16,006,695$ 105.4%23,818,375$ 1,889,599$
OPERATING EXPENDITURES
Personnel 12,467,458$ 11,536,170$ 12,404,770$ 93.0%18,842,080$ (931,288)$
Materials and Supplies 289,805 259,608 385,130 67.4%551,030 (30,197)
Operation and Contract 2,247,713 2,137,128 2,338,180 91.4%3,397,210 (110,585)
Other Expenditures 4,374 4,315 7,500 57.5%10,000 (59)
Capital Outlay 116,811 144,678 251,530 57.5%452,300 27,867
Total Operating Expenditures 15,126,161$ 14,081,899$ 15,387,110$ 91.5%23,252,620$ (1,044,262)$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES (151,305)$ 2,782,556$ 619,585$ 565,755$ 2,933,861$
INTERFUND TRANSACTIONS
Transfers Out (326,369)$ -$ (100,000)$ 0.0%(100,000)$ 326,369$
Reimbursements From Other Funds 417,592 395,784 395,800 100.0%593,685 (21,808)
Reimbursements To Other Funds (93,176) (70,592) (70,600) 100.0%(105,885) 22,584
Total Interfund Transactions (1,953)$ 325,192$ 225,200$ 144.4%387,800$ 327,145$
NET FUND INCREASE (DECREASE)(153,258)$ 3,107,748$ 844,785$ 953,555$ 3,261,006$
*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 August 31, 2021
Total Total
Revenues Expenditures
8/31/21 Actual 16,864,455$ 14,081,899$
8/31/20 Actual 14,974,856$ 15,126,161$
% Change From Last Year 12.6%-6.9%
Major Revenues
Other Telecom/Utility Licenses &Charges for
Sales Tax Intergov. Tax Tax Permits Services
8/31/21 Actual 8,813,778$ 1,357,794$ 3,736,855$ 1,365,194$ 933,820$
8/31/20 Actual $ 7,316,243 $ 1,069,495 $ 3,995,029 $ 1,271,874 $ 590,686
% Change From Last Year 20.5%27.0%-6.5%7.3%58.1%
Five Year Trend
Major Expenditures Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
8/31/21 Actual 11,536,170$ 259,608$ 2,137,128$ 4,315$ 144,678$
8/31/20 Actual 12,467,458$ 289,805$ 2,247,713$ 4,374$ 116,811$
% Change From Last Year -7.5%-10.4%-4.9%-1.3%23.9%
Five Year Trend
Expenditures by Department
8/31/20 8/31/21 8/31/21 8/31/21 2021 Difference Five
YTD YTD YTD % of Annual Prior Year
Department Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 1,371,353$ 1,544,462$ 1,587,435$ 97.3%2,498,625$ 173,109$
Financial Services 514,010 500,978 522,530 95.9%770,360 (13,032)
Public Works 480,305 594,349 628,740 94.5%948,860 114,044
Engineering & Capital Projects 31,899 21,542 94,000 22.9%209,000 (10,357)
Library 546,620 571,142 637,520 89.6%943,405 24,522
Police 6,099,940 5,599,916 6,118,575 91.5%9,213,585 (500,024)
Fire 5,413,242 4,616,914 5,063,575 91.2%7,576,045 (796,328)
Development Services 668,792 632,596 734,735 86.1%1,092,740 (36,196)
Total Expenditures 15,126,161$ 14,081,899$ 15,387,110$ 91.5%23,252,620$ (1,044,262)$
Five Year Trend
For the Period Ending August 31, 2021
General Fund - Five Year Trend
Village of Oak Brook
Revenues Expenditures
8/31/21 8/31/21
8/31/20 8/31/21 YTD % of YTD 2021 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Hotel Tax 368,599$ 415,262$ 276,400$ 150.2%414,000$ 46,663$
Investment Interest 51,441 23,988 26,680 89.9%40,000 (27,453)
Loan Interest 4,167 4,000 4,000 100.0%8,000 (167)
Total Operating Revenues 424,207$ 443,250$ 307,080$ 144.3%462,000$ 19,043$
EXPENDITURES
Operation and Contract 295,628$ 77,927$ 133,450$ 58.4%193,945$ (217,701)$
Capital Outlay 268,416 2,650 150,000 1.8%250,000 (265,766)
Total Expenditures 564,044$ 80,577$ 283,450$ 28.4%443,945$ (483,467)$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES (139,837)$ 362,673$ 23,630$ 1534.8%18,055$ 502,510$
INTERFUND TRANSACTIONS
Transfer Out -$ (2,383,612)$ (2,000,000)$ 119.2%(100,000)$ (2,383,612)$
Reimbursements to Other Funds (49,808) (56,056) (56,045) 100.0%(84,085) (6,248)
Total Interfund Transactions (49,808)$ (2,439,668)$ (2,056,045)$ 118.7%(184,085)$ (2,389,860)$
NET FUND INCREASE (DECREASE)(189,645)$ (2,076,995)$ (2,032,415)$ (166,030)$ (1,887,350)$
Note - Expenditures are recorded in program 171.
Village of Oak Brook
Hotel Tax Fund Financial Update
For the Period Ending August 31, 2021
Total Total
Revenues Expenditures
8/31/21 Actual $ 443,250 80,577$
8/31/20 Actual $ 424,207 564,044$
% Change From Last Year 4.5%-85.7%
Major Revenues Investment
Hotel Tax Interest Loan Interest Miscellaneous
8/31/21 Actual $ 415,262 $ 23,988 4,000$ -$
8/31/20 Actual $ 368,599 $ 51,441 4,167$ -$
% Change From Last Year 12.7%-53.4%-4.0%0.0%
Five Year Trend
Major Expenditures Operation &
Contractual Capital Outlay
8/31/21 Actual 77,927$ 2,650$
8/31/20 Actual 295,628$ 268,416$
% Change From Last Year -73.6%-99.0%
Five Year Trend
Village of Oak Brook
Hotel Tax Fund - Major Sources Five Year Trend
For the Period Ending August 31, 2021
Five Year Trend
Revenues Expenditures
8/31/21 8/31/21
8/31/20 8/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 3,193,213$ 3,807,435$ 3,560,550$ 106.9%5,333,500$ 614,222$
Charges for Services 335 - 680 0.0%1,000 (335)
Investment Interest 67,664 22,669 26,680 85.0%40,000 (44,995)
Grants - 544,864 - N/A - 544,864
Miscellaneous - 3,080 - N/A - 3,080
Total Operating Revenues 3,261,212$ 4,378,048$ 3,587,910$ 122.0%5,374,500$ 1,116,836$
OPERATING EXPENDITURES
Personnel 870,649$ 933,278$ 911,085$ 102.4%1,386,115$ 62,629$
Materials and Supplies 126,833 140,155 147,590 95.0%245,660 13,322
Operation and Contract 895,561 1,080,048 1,288,185 83.8%1,892,905 184,487
Capital Outlay 2,236,148 4,886,486 5,414,210 90.3%8,956,170 2,650,338
Total Operating Expenditures 4,129,191$ 7,039,967$ 7,761,070$ 90.7%12,480,850$ 2,910,776$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES (867,979)$ (2,661,919)$ (4,173,160)$ 63.8%(7,106,350)$ (1,793,940)$
INTERFUND TRANSACTIONS
Transfers In 666,289$ 2,383,612$ 2,400,000$ 99.3%1,400,000$ 1,717,323$
Reimbursements From Other Funds 239,584 221,232 221,240 100.0%331,840 (18,352)
Reimbursements To Other Funds (108,200) (117,536) (117,620) 99.9%(176,300) (9,336)
Total Interfund Transactions 797,673$ 2,487,308$ 2,503,620$ 99.3%1,555,540$ 1,689,635$
NET FUND INCREASE (DECREASE)(70,306)$ (174,611)$ (1,669,540)$ (5,550,810)$ (104,305)$
Village of Oak Brook
Infrastructure Fund Financial Update
For the Period Ending August 31, 2021
Total Total
Revenues Expenditures
8/31/21 Actual $ 4,378,048 7,039,967$
8/31/20 Actual $ 3,261,212 4,129,191$
% Change From Last Year 34.2%70.5%
Major Revenues
Sales Tax
Charges for
Services
Investment
Interest Miscellaneous
8/31/21 Actual $ 3,807,435 $ - $ 22,669 $ 3,080
8/31/20 Actual $ 3,193,213 $ 335 $ 67,664 $ -
% Change From Last Year 19.2%-100.0%-66.5%N/A
Five Year Trend
Major Expenditures Materials &Operation &
Personnel Supplies Contractual Capital Outlay
8/31/21 Actual 933,278$ 140,155$ 1,080,048$ 4,886,486$
8/31/20 Actual 870,649$ 126,833$ 895,561$ 2,236,148$
% Change From Last Year 7.2%10.5%20.6%118.5%
Five Year Trend
Expenditures by Department
8/31/20 8/31/21 8/31/21 8/31/21 2021 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 79,402$ 107,667$ 104,190$ 103.3%157,640$ 28,265$
Public Works 2,910,235 1,633,609 1,768,935 92.3%2,789,580 (1,276,626)
Engineering & Capital Projects 1,139,554 5,298,691 5,887,945 90.0%9,709,930 4,159,137
Total Expenditures 4,129,191$ 7,039,967$ 7,761,070$ 90.7%12,657,150$ 2,910,776$
Five Year Trend
Village of Oak Brook
Infrastructure Fund - Major Sources Five Year Trend
For the Period Ending August 31, 2021
Revenues Expenditures
8/31/21 8/31/21
8/31/20 8/31/21 YTD % of YTD 2021 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 36,311$ 53,139$ 50,850$ 104.5%75,000$ 16,828$
Real Estate Tax 207,272 408,456 200,000 204.2%400,000 201,184
Investment Interest 478 32 680 4.7%1,000 (446)
Total Operating Revenues 244,061$ 461,627$ 251,530$ 183.5%476,000$ 217,566$
EXPENDITURES
Operation and Contract 3,665$ 3,638$ 3,500$ 103.9%3,850$ (27)$
Other Expenditures 529,900 481,500 466,500 103.2%466,500 (48,400)
Total Expenditures 533,565$ 485,138$ 470,000$ 103.2%470,350$ (48,427)$
NET FUND INCREASE (DECREASE)(289,504)$ (23,511)$ (218,470)$ 5,650$ 265,993$
Note - Expenditures are recorded in program 283.
Village of Oak Brook
Promenade TIF Fund Financial Update
For the Period Ending August 31, 2021
Total Total
Revenues Expenditures
8/31/21 Actual $ 461,627 485,138$
8/31/20 Actual $ 244,061 533,565$
% Change From Last Year 89.1%-9.1%
Major Revenues Real Estate Investment
Sales Tax Tax Interest
8/31/21 Actual 53,139$ $ 408,456 $ 32
8/31/20 Actual 36,311$ $ 207,272 $ 478
% Change From Last Year 46.3%97.1%-93.3%
Five Year Trend
Major Expenditures Operation &Other
Contractual Expenditures
8/31/21 Actual 3,638$ 481,500$
8/31/20 Actual 3,665$ 529,900$
% Change From Last Year -0.7%-9.1%
Five Year Trend
Village of Oak Brook
Promenade TIF Fund - Major Sources Five Year Trend
For the Period Ending August 31, 2021
Five Year Trend
Revenues Expenditures
8/31/21 8/31/21
8/31/20 8/31/21 YTD % of YTD 2021 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Plan Review Fees 525$ 525$ 680$ 77.2%1,000$ -$
Building/Inspection Fees 5,287 2,850 4,680 60.9%7,000 (2,437)
Water Sales 5,574,910 6,144,975 6,320,000 97.2%10,597,000 570,065
Unmetered Sales 60,301 33,453 23,320 143.5%35,000 (26,848)
Water Connection Fees 12,210 185,610 66,680 278.4%100,000 173,400
Meter Charges 6,902 6,786 10,000 67.9%15,000 (116)
Special Services 12,657 13,333 12,500 106.7%25,000 676
Investment Interest 71,594 33,990 40,000 85.0%60,000 (37,604)
Miscellaneous 19,953 656,340 43,320 1515.1%65,000 636,387
Total Operating Revenues 5,764,339$ 7,077,862$ 6,521,180$ 108.5%10,905,000$ 1,313,523$
OPERATING EXPENDITURES
Personnel 498,815$ 538,807$ 554,555$ 97.2%842,235$ 39,992$
Materials and Supplies 19,263 104,227 51,355 203.0%75,780 84,964
Operation and Contract 2,732,121 2,866,199 3,602,875 79.6%5,379,925 134,078
Capital Outlay 1,347,741 4,378,020 7,175,830 61.0%8,103,750 3,030,279
Total Expenditures 4,597,940$ 7,887,253$ 11,384,615$ 69.3%14,401,690$ 3,289,313$
Surplus (Deficit) of Revenues Over
Expenditures 1,166,399$ (809,391)$ (4,863,435)$ 16.6%(3,496,690)$ (1,975,790)$
INTERFUND TRANSACTIONS
Reimbursements To Other Funds (351,208)$ (300,336)$ (300,320)$ 100.0%(450,500)$ 50,872$
Total Interfund Transactions (351,208)$ (300,336)$ (300,320)$ 100.0%(450,500)$ 50,872$
Fund Increase/(Decrease) - Budgetary Basis 815,191$ (1,109,727)$ (5,163,755)$ 21.5%(3,947,190)$ (1,924,918)$
ADUSTMENTS TO GAAP BASIS*
Remove Capital Outlay 1,347,741$ 4,378,020$
Depreciation Expense (365,802) (383,333)
IMRF Pension Expense (27,662) (30,000)
OPEB Expense 18,429 (20,000)
Total GAAP Adjustments 972,706$ 3,944,687$
Fund Increase/(Decrease) - GAAP Basis 1,787,897$ 2,834,960$
*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 August 31, 2021
Total Total
Revenues Expenditures
8/31/21 Actual $ 7,077,862 7,887,253$
8/31/20 Actual $ 5,764,339 4,597,940$
% Change From Last Year 22.8%71.5%
Unmetered Water
Water Sales Sales Connection Fees Meter Charges Miscellaneous
8/31/21 Actual $ 6,144,975 $ 33,453 $ 185,610 $ 6,786 $ 656,340
8/31/20 Actual $ 5,574,910 $ 60,301 $ 12,210 $ 6,902 $ 19,953
% Change From Last Year 10.2%-44.5%1420.1%-1.7%3189.4%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
8/31/21 Actual 538,807$ 104,227$ 2,866,199$ -$ 4,378,020$
8/31/20 Actual 498,815$ 19,263$ 2,732,121$ -$ 1,347,741$
% Change From Last Year 8.0%441.1%4.9%0.0%224.8%
Five Year Trend
Expenditures by Department
8/31/20 8/31/21 8/31/21 8/31/21 2021 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Public Works 3,281,122$ 3,444,139$ 4,222,115$ 81.6%6,317,940$ 163,017$
Engineering & Capital Projects 1,316,818 4,443,114 7,162,500 62.0%8,083,750 3,126,296
Total Expenditures 4,597,940$ 7,887,253$ 11,384,615$ 69.3%14,401,690$ 3,289,313$
Five Year Trend
Village of Oak Brook
Water Fund - Major Sources Five Year Trend
For the Period Ending August 31, 2021
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Sports Core Fund Consolidated Presentation
For the Period Ending August 31, 2021
8/31/21 8/31/21
8/31/21 YTD % of YTD 2021 8/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,800$ 355,800$ 238,500$ 149.2%238,500$ 224,887$ 130,913$
Greens Fees - - - 973,849 973,849 734,000 132.7%985,000 743,317 230,532
Pro Shop Sales - - - 181,752 181,752 164,500 110.5%207,000 126,700 55,052
Golf Lessons - - - 45,105 45,105 43,000 104.9%45,000 44,405 700
Driving Range Fees - - - 296,119 296,119 220,000 134.6%250,000 204,971 91,148
Rentals - 100,000 81,543 369,323 550,866 517,175 106.5%761,000 350,707 200,159
Programs/User Fees - - - - - 31,500 0.0%31,500 - -
Food Sales - - - 203,018 203,018 147,200 137.9%207,500 103,524 99,494
Beverage Sales - - - 372,791 372,791 256,000 145.6%382,000 236,375 136,416
Taste of Oak Brook - - - - - 120,000 0.0%120,000 - -
Grants - - - - - - 0.0%233,600 - -
Other Revenue 8,188 - - 7,239 15,427 7,080 217.9%7,700 4,223 11,204
Total Operating Revenues 8,188$ 100,000$ 81,543$ 2,804,996$ 2,994,727$ 2,478,955$ 120.8%3,468,800$ 2,039,109$ 955,618$
OPERATING EXPENDITURES
Personnel 15,929$ -$ 77,872$ 900,835$ 994,636$ 1,071,120$ 92.9%1,597,610$ 918,098$ 76,538$
Materials & Supplies 27,425 - 4,224 457,882 489,531 544,620 89.9%628,450 372,646 116,885
Operational & Contractual 84,245 7,271 33,552 252,887 377,955 508,865 74.3%663,035 296,501 81,454
Other - - - - - - 0.0%(39,000) - -
Capital 269,066 232,675 4,382 134,788 640,911 1,125,380 57.0%1,125,380 858,553 (217,642)
Total Operating Expenditures 396,665$ 239,946$ 120,030$ 1,746,392$ 2,503,033$ 3,249,985$ 77.0%3,975,475$ 2,445,798$ 57,235$
B&T Administration Overhead Allocation*30,312$ -$ (30,312)$ -$ -$ -$ 0.0%-$ -$ -$
Operating Revenues Over (Under) Expenditures (358,165)$ (139,946)$ (68,799)$ 1,058,604$ 491,694$ (771,030)$ -63.8%(506,675)$ (406,689)$ 898,383$
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 21,336 - - - 21,336 21,340 100.0%32,000 16,000 5,336
Reimbursement From Water Fund 5,336 - - - 5,336 5,340 99.9%8,000 5,336 -
Reimbursement To General Fund (10,480) - - (31,448) (41,928) (41,935) 100.0%(62,900) (37,632) (4,296)
Total Interfund Transactions 16,192$ -$ -$ (31,448)$ (15,256)$ 284,745$ -5.4%277,100$ 633,446$ (648,702)$
Total Revenues Over (Under) Expenditures - Budgetary Basis (341,973)$ (139,946)$ (68,799)$ 1,027,156$ 476,438$ (486,285)$ (229,575)$ 226,757$ 249,681$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay 269,066$ 232,675$ 4,382$ 134,788$ 640,911$ 858,553$
Depreciation Expense (112,151) (1,123) (40,000) (164,200) (317,475) (259,388)
IMRF Pension Expense (1,367) - (2,000) (16,333) (19,700) (17,436)
OPEB Expense - - (2,000) (18,667) (20,667) (16,831)
Total GAAP Adjustments 155,548$ 231,552$ (39,618)$ (64,412)$ 283,070$ 564,898$
Fund Increase/(Decrease) - GAAP Basis (186,425)$ 91,606$ (108,417)$ 962,744$ 759,508$ 791,655$
*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
8/31/21 Actual $ 2,994,727 2,503,033$
8/31/20 Actual $ 2,039,109 2,445,798$
% Change From Last Year 46.9%2.3%
Driving Program/
Memberships Greens Fees Range Fees Rentals User Fees
8/31/21 Actual $ 355,800 $ 973,849 $ 296,119 $ 550,866 -$
8/31/20 Actual $ 224,887 $ 743,317 $ 204,971 $ 350,707 -$
% Change From Last Year 58.2%31.0%44.5%57.1%0.0%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
8/31/21 Actual 994,636$ 489,531$ 377,955$ -$ 640,911$
8/31/20 Actual 918,098$ 372,646$ 296,501$ -$ 858,553$
% Change From Last Year 8.3%31.4%27.5%0.0%-25.3%
Five Year Trend
Revenues by Department 8/31/20 8/31/21 8/31/21 8/31/21 2021 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Operations 918$ 8,188$ 91,880$ 8.9%325,800$ 7,270$
Open Field Operations 95,040 100,000 220,000 45.5%230,000 4,960
B&T Clubhouse Operations 14,741 81,543 132,000 61.8%267,000 66,802
Golf Club 1,928,410 2,804,996 2,035,075 137.8%2,646,000 876,586
Total Revenues 2,039,109$ 2,994,727$ 2,478,955$ 120.8%3,468,800$ 955,618$
Expenditures by Department 8/31/20 8/31/21 8/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 423,873$ 396,665$ 744,515$ 53.3%780,740$ (27,208)$
Open Field Operations 32,625$ 239,946$ 337,810$ 71.0%358,910$ 207,321$
B&T Clubhouse Operations 147,688 120,030 174,695 68.7%262,635 (27,658)
Golf Club 1,841,612 1,746,392 1,992,965 87.6%2,573,190 (95,220)
Total Expenditures 2,445,798$ 2,503,033$ 3,249,985$ 77.0%3,975,475$ 57,235$
Five Year Trend
Village of Oak Brook
Sports Core Fund - Major Sources Five Year Trend
For the Period Ending August 31, 2021
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Bath & Tennis Club Recreation Operations
For the Period Ending August 31, 2021 8/31/21 8/31/21
822 8/31/21 YTD % of YTD 2021 8/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 - - - - - - 0.0%233,600 - -
Other Revenue 8,188 - - - 8,188 380 2154.7%700 719 7,469
Total Operating Revenues 8,188$ -$ -$ -$ 8,188$ 91,880$ 8.9%325,800$ 918$ 7,270$
OPERATING EXPENDITURES
Personnel 15,929$ -$ -$ -$ 15,929$ 98,670$ 16.1%119,110$ 24,076$ (8,147)$
Materials & Supplies 457 22,799 2,460 1,709 27,425 35,970 76.2%37,250 3,545 23,880
Operational & Contractual 49,283 29,729 5,010 223 84,245 75,045 112.3%89,550 39,651 44,594
Capital 158,691 110,375 - - 269,066 534,830 50.3%534,830 356,601 (87,535)
Total Operating Expenditures 224,360$ 162,903$ 7,470$ 1,932$ 396,665$ 744,515$ 53.3%780,740$ 423,873$ (27,208)$
B&T Administration Overhead Allocation*60,623$ (21,824)$ (6,062)$ (2,425)$ 30,312$ 35,835$ 84.6%44,755$ 50,647$ (20,335)$
Operating Revenues Over (Under) Expenditures (155,549)$ (184,727)$ (13,532)$ (4,357)$ (358,165)$ (616,800)$ 58.1%(410,185)$ (372,308)$ 14,143$
INTERFUND TRANSACTIONS
Transfer From General Fund -$ -$ -$ -$ -$ 100,000$ 0.0%100,000$ 326,369$ (326,369)$
Reimbursement From Infrastructure Fund 21,336 - - - 21,336 21,340 100.0%32,000 16,000 5,336
Reimbursement From Water Fund 5,336 - - - 5,336 5,340 99.9%8,000 5,336 -
Reimbursement To General Fund (10,480) - - - (10,480) (10,480) 100.0%(15,725) (18,816) 8,336
Total Interfund Transactions 16,192$ -$ -$ -$ 16,192$ 116,200$ 13.9%124,275$ 328,889$ (312,697)$
Total Revenues Over (Under) Expenditures - Budgetary Basis (139,357)$ (184,727)$ (13,532)$ (4,357)$ (341,973)$ (500,600)$ (285,910)$ (43,419)$ (298,554)$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay 158,691$ 110,375$ -$ -$ 269,066$ 356,601$
Depreciation Expense (42,906) (66,667) (1,800) (779) (112,151) (61,405)
IMRF Pension Expense (1,333) - - (33) (1,367) (746)
Total GAAP Adjustments 114,452$ 43,708$ (1,800)$ (812)$ 155,548$ 294,450$
Fund Increase/(Decrease) - GAAP Basis (24,905)$ (141,019)$ (15,332)$ (5,169)$ (186,425)$ 251,031$
*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 August 31, 2021 8/31/21 8/31/21
8/31/21 YTD % of YTD 2021 8/31/20 Difference
815 816 YTD Amended Amended Adopted YTD Prior
Polo Open Fields Total Budget Budget Budget Total Year
OPERATING REVENUES
Field Rentals -$ 20,000$ 20,000$ 20,000$ 100.0%30,000$ 20,040$ (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 -$ 100,000$ 100,000$ 220,000$ 45.5%230,000$ 95,040$ 4,960$
OPERATING EXPENDITURES
Personnel -$ -$ -$ -$ 0.0%-$ -$ -$
Materials & Supplies - - - 300 0.0%500 119 (119)
Operational & Contractual - 7,271 7,271 169,460 4.3%190,360 23,796 (16,525)
Capital - 232,675 232,675 168,050 0.0%168,050 8,710 223,965
Total Operating Expenditures -$ 239,946$ 239,946$ 337,810$ 71.0%358,910$ 32,625$ 207,321$
Operating Revenues Over (Under) Expenditures -$ (139,946)$ (139,946)$ (117,810)$ 118.8%(128,910)$ 62,415$ (202,361)$
INTERFUND TRANSACTIONS
Transfer From Hotel Tax Fund -$ -$ -$ -$ 0.0%-$ -$ -$
Total Interfund Transactions -$ -$ -$ -$ 0.0%-$ -$ -$
Total Revenues Over (Under) Expenditures - Budgetary Basis -$ (139,946)$ (139,946)$ (117,810)$ (128,910)$ 62,415$ (202,361)$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay -$ 232,675$ 232,675$ 8,710$
Depreciation Expense - (1,123) (1,123) (1,123)
Total GAAP Adjustments -$ 231,552$ 231,552$ 7,587$
Fund Increase/(Decrease) - GAAP Basis -$ 91,606$ 91,606$ 70,002$
*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 August 31, 2021
8/31/21 8/31/21
821 YTD % of YTD 2021 8/31/20 Difference
B&T Amended Amended Adopted YTD Prior
Clubhouse Budget Budget Budget Total Year
OPERATING REVENUES
Rentals 81,543$ 132,000$ 61.8%267,000$ 14,741$ 66,802$
Total Operating Revenues 81,543$ 132,000$ 61.8%267,000$ 14,741$ 66,802$
OPERATING EXPENDITURES
Personnel 77,872$ 87,840$ 88.7%133,585$ 71,999$ 5,873$
Materials & Supplies 4,224 7,770 54.4%12,000 1,540 2,684
Operational & Contractual 33,552 69,585 48.2%107,550 37,934 (4,382)
Capital 4,382 9,500 46.1%9,500 36,215 (31,833)
Total Operating Expenditures 120,030$ 174,695$ 68.7%262,635$ 147,688$ (27,658)$
B&T Administration Overhead Allocation*(30,312)$ (35,835)$ 84.6%(44,755)$ (50,647)$ 20,335$
Operating Revenues Over (Under) Expenditures (68,799)$ (78,530)$ 87.6%(40,390)$ (183,594)$ 114,795$
INTERFUND TRANSACTIONS
Transfer From General Fund -$ -$ 0.0%-$ -$ -$
Total Interfund Transactions -$ -$ 0.0%-$ -$ -$
Total Revenues Over (Under) Expenditures - Budgetary Basis (68,799)$ (78,530)$ (40,390)$ (183,594)$ 114,795$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay 4,382$ 36,215$
Depreciation Expense (40,000) (40,370)
IMRF Pension Expense (2,000) (1,382)
OPEB Expense (2,000) (1,763)
Total GAAP Adjustments (39,618)$ (7,300)$
Fund Increase/(Decrease) - GAAP Basis (108,417)$ (190,894)$
*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 August 31, 2021
8/31/21 8/31/21
823 831 832 833 834 8/31/21 YTD % of YTD 2021 8/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,800$ -$ -$ -$ 355,800$ 238,500$ 149.2%238,500$ 224,688$ 131,112$
Greens Fees - 973,849 - - - 973,849 734,000 132.7%985,000 743,317 230,532
Pro Shop Sales - 181,752 - - - 181,752 164,500 110.5%207,000 126,700 55,052
Golf Lessons - - 45,105 - - 45,105 43,000 104.9%45,000 44,405 700
Driving Range Fees - - 296,119 - - 296,119 220,000 134.6%250,000 204,971 91,148
Rentals - 1,825 9,000 358,498 - 369,323 285,175 129.5%384,000 240,926 128,397
Food Sales 203,018 - - - - 203,018 109,200 185.9%169,500 103,524 99,494
Beverage Sales 372,791 - - - - 372,791 234,000 159.3%360,000 236,375 136,416
Other Revenue - 7,239 - - - 7,239 6,700 108.0%7,000 3,504 3,735
Total Operating Revenues 575,809$ 1,520,465$ 350,224$ 358,498$ -$ 2,804,996$ 2,035,075$ 137.8%2,646,000$ 1,928,410$ 876,586$
OPERATING EXPENDITURES
Personnel 166,564$ 360,824$ 65,347$ 34,228$ 273,872$ 900,835$ 884,610$ 101.8%1,344,915$ 822,023$ 78,812$
Materials & Supplies 209,873 114,034 16,126 757 117,092 457,882 500,580 91.5%578,700 367,442 90,440
Operational & Contractual 3,919 188,829 799 37,609 21,731 252,887 194,775 129.8%275,575 195,120 57,767
Other - - - - - - - 0.0%(39,000) - -
Capital - 14,250 - - 120,538 134,788 413,000 32.6%413,000 457,027 (322,239)
Total Operating Expenditures 380,356$ 677,937$ 82,272$ 72,594$ 533,233$ 1,746,392$ 1,992,965$ 87.6%2,573,190$ 1,841,612$ (95,220)$
Operating Revenues Over (Under) Expenditures 195,453$ 842,528$ 267,952$ 285,904$ (533,233)$ 1,058,604$ 42,110$ 2513.9%72,810$ 86,798$ 971,806$
INTERFUND TRANSACTIONS
Transfer from Golf Surcharge -$ -$ -$ -$ -$ -$ 200,000$ 0.0%200,000$ 323,373$ (323,373)$
Reimbursement to General Fund - (31,448) - - - (31,448) (31,455) 100.0%(47,175) (18,816) (12,632)
Total Interfund Transactions -$ (31,448)$ -$ -$ -$ (31,448)$ 168,545$ -18.7%152,825$ 304,557$ (336,005)$
Total Revenues Over (Under) Expenditures - Budgetary Basis 195,453$ 811,080$ 267,952$ 285,904$ (533,233)$ 1,027,156$ 210,655$ 225,635$ 391,355$ 635,801$
ADUSTMENTS TO GAAP BASIS*
Remove Capital Outlay -$ 14,250$ -$ -$ 120,538$ 134,788$ 457,027$
Depreciation Expense (667) (70,000) (1,533) (8,667) (83,333) (164,200) (156,490)
IMRF Pension Expense (1,667) (6,667) (667) - (7,333) (16,333) (15,308)
OPEB Expense (2,000) (10,000) - - (6,667) (18,667) (15,068)
Total GAAP Adjustments (4,333)$ (72,417)$ (2,200)$ (8,667)$ 23,205$ (64,412)$ 270,161$
Fund Increase/(Decrease) - GAAP Basis 191,120$ 738,663$ 265,752$ 277,237$ (510,028)$ 962,744$ 661,516$
*Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.