08 - August 2020 Monthly Financial ReportVILLAGE
OAK BROOK
OF
MONTHLY FINANCIAL REPORTS
AUGUST 2020
ITEM 6.D
Cash and Investments by Fund:Total
Cash and Cash Pooled Cash and
Fund Equivalents Investments Investments % By Fund
General Corporate $6,323,916 $14,840,513 $21,164,429 48.7%
Hotel/Motel Tax 2,321,754 2,478,276 4,800,030 11.0%
Motor Fuel Tax 744,896 41,785 786,681 1.8%
Infrastructure 5,699,585 1,996,837 7,696,422 17.7%
Promenade TIF 14,689 - 14,689 0.0%
Water 3,247,327 3,545,549 6,792,876 15.6%
Sports Core 434,175 - 434,175 1.0%
Golf Surcharge 105,564 - 105,564 0.2%
Self-Insurance 397,135 - 397,135 0.9%
Garage 316,988 - 316,988 0.7%
Equipment Replacement 566,658 367,787 934,445 2.2%
Total $20,172,687 $23,270,747 $43,443,434 100.0%
Change in Cash and Investments by Fund :
Balance at Balance at Year-to-Date Year-to-Date
Fund January 1, 2020 August 31, 2020 Change ($)Change (%)
General Corporate $21,270,239 $21,164,429 ($105,810)-0.5%
Hotel/Motel Tax 5,427,474 4,800,030 (627,444)-11.6%
Motor Fuel Tax 1,085,595 786,681 (298,914)-27.5%
Infrastructure 8,217,724 7,696,422 (521,302)-6.3%
Promenade TIF 304,194 14,689 (289,505)-95.2%
Water 6,947,239 6,792,876 (154,363)-2.2%
Sports Core 231,216 434,175 202,959 87.8%
Golf Surcharge 347,066 105,564 (241,502)-69.6%
Self-Insurance 308,820 397,135 88,315 28.6%
Garage 275,988 316,988 41,000 14.9%
Equipment Replacement 808,879 934,445 125,566 15.5%
$45,224,434 $43,443,434 ($1,781,000)-3.9%
Book Bank/Market
Value Value
Cash and Cash Equivalents:
Pooled Checking $269,864 $867,204
Sports Core Checking 539,739 471,499
Pooled IPTIP 19,276,982 19,276,982
Water E-Pay IPTIP 86,102 64,819
$20,172,687 $20,680,504
Pooled Investments:
Investments-Municipal Bonds $7,270,302 $7,352,723
Investments-Corporate Bonds 8,665,410 8,783,097
Government & Agency Obligations 1,823,989 1,861,051
Certificates of Deposit 5,390,000 5,459,439
Accrued Interest 121,046 121,046
Total Pooled Investments $23,270,747 $23,577,356
Total Cash and Investments $43,443,434 $44,257,860
For August, total interest revenue is $43,734 and YTD is $471,743. The total investment yield for the portfolio is:
Pooled
Investments Illinois Funds Total
Last 12 months yield 2.20%1.28%1.77%
The weighted average yield of the current pooled investment portfolio is 2.05%. The IL Funds August average daily rate was 0.161%.
Monthly Treasurer's Report
August 31, 2020
Monthly Treasurer's Report
August 2020
The table below lists the detail investment holdings at J.P. Morgan Securities as of 8/31/20:
Month End VOB
Settlement Maturity Coupon Yield Book Market Accrued
Type Date Date Rate Rate Value Value Interest
Municipal Bonds:
New York N Y City #64971QTX1 02/22/16 05/01/21 2.350%2.000%200,446 202,770 1,552
Bloomingdale Mich Pub Sch Dist #094383FS0 04/26/16 05/01/22 2.710%2.150%504,514 518,375 4,478
Connecticut St GO Bds 2016 #20772J3F7 06/15/17 08/15/21 1.750%2.300%497,432 505,875 336
Wright County Min #982276BC0 07/18/19 12/01/20 2.000%2.000%545,000 546,346 3,240
State of IL #452152P54 10/09/19 11/01/21 5.000%1.870%518,068 518,510 8,082
Anchor Bay Mich Sch #032879TE8 11/01/19 05/01/21 2.320%1.750%717,709 724,767 5,391
Brownsville TX #16405ST9 12/19/19 02/15/22 2.050%2.000%555,388 565,700 348
Laredo TX Waterworks #517039VW0 12/19/19 03/01/24 2.230%2.230%455,000 474,633 5,017
Manchester NH #562333JE5 03/12/20 12/01/20 5.000%0.850%479,923 480,667 5,897
Oakland Univ Mich #673588HJ1 04/29/20 03/01/24 5.000%1.650%328,456 335,247 7,375
Philadelphia PA GO Ref #717813SW0 05/05/20 08/01/22 5.000%1.820%413,352 422,448 1,422
Maryland St DOT #574204WG4 05/06/20 06/15/22 4.350%1.200%274,524 277,690 2,271
University of CA #91412HFK4 07/16/20 05/15/23 0.628%0.628%25,000 25,171 19
Windsor NY Sch Dist #973675EW7 07/23/02 06/17/21 1.500%0.400%479,124 478,686 766
Waterford Mich Sch Dist #941468YZ7 08/20/20 08/24/21 4.000%0.301%518,100 518,100 591
Weedsport NY Cent Sch Dist #948543KA0 08/21/20 08/20/21 1.000%0.570%502,073 501,890 134
Universty of IL #914353YH4 08/31/20 10/01/21 3.000%0.701%256,193 255,848 3,125
Total Municipal Bonds $7,270,302 $7,352,723 $50,044
Corporate Bonds:
Wells Fargo #94974BGR5 01/15/19 12/07/20 2.550%3.120%$1,388,026 $1,398,479 $8,565
PNC Bank #69353RFH6 01/30/19 01/22/21 2.500%3.020%499,016 503,438 1,354
Morgan Stanley #61747WAL3 03/08/19 07/28/21 5.500%3.034%1,072,814 1,098,153 5,133
Citigroup #172967LC3 04/01/19 12/08/21 2.900%2.754%1,001,799 1,029,910 6,122
Bank of America #06051GFT1 04/03/19 10/19/20 2.625%2.625%700,000 702,184 6,482
Goldman Sachs #38143U8F1 05/02/19 02/25/21 2.875%2.707%365,280 368,760 148
American Honda #02665WBG5 07/31/19 09/09/21 1.700%2.180%497,602 506,720 4,084
BB&T Corp #05531FAZ6 08/15/19 02/01/21 2.150%2.010%750,464 754,635 1,147
JP Morgan #48128BAB7 09/30/19 01/15/23 2.972%2.337%1,014,538 1,034,350 3,798
JP Morgan #46625HRT9 01/30/20 06/07/21 2.400%1.648%502,841 507,400 2,800
American Express #025816CD9 05/05/20 05/20/22 2.750%1.290%512,439 518,850 3,715
Goldman Sachs #38141GGQ1 08/31/20 07/27/21 5.250%0.251%360,591 360,218 1,711
Total Corporate Bonds $8,665,410 $8,783,097 $45,059
Government & Agency Obligations:
*Government National Mtg Assn #38379UEM4 02/29/16 02/16/51 2.300%2.245%$502,727 $497,147 $2,217
*Government National Mtg Assn #38381WV96 08/06/19 07/20/54 2.250%2.293%741,652 761,062 1,300
*Government National Mtg Assn #38380BNV3 12/05/19 06/20/46 2.000%2.112%579,610 602,842 902
Total Government & Agency Obligations:$1,823,989 $1,861,051 $4,419
Certificates of Deposit:
State Bk India NY #8562846A7 01/26/17 01/26/22 2.250%2.250%$245,000 $252,333 $544
Jackson Cnty Bk #466682AP6 08/31/17 03/01/21 1.850%1.850%245,000 247,225 0
Barclays Bank #06740KKX4 09/27/17 09/28/20 1.950%1.950%245,000 245,363 2,037
Goldman Sachs Bank #38148PRK5 10/18/17 10/19/20 1.950%1.950%245,000 245,632 1,745
FirstBank PR Santurce #33767A6M8 11/03/17 11/03/20 2.000%2.000%245,000 245,833 351
Compass Bank #20451PVW3 10/26/18 10/26/20 3.000%3.000%245,000 246,122 2,522
UBS Bank #90348JFH8 10/30/18 10/29/20 3.050%3.050%245,000 246,203 17
Discover Bank #254673WF9 11/07/18 11/09/20 3.000%3.000%245,000 246,401 2,317
Ally Bank #02007GFX6 11/08/18 11/09/20 3.000%3.000%245,000 246,401 2,297
Comenity Cap Bank #20033AU46 04/15/19 04/15/21 2.500%2.500%245,000 248,714 233
Morgan Stanley #61760AE21 05/30/19 06/01/21 2.400%2.400%245,000 249,300 1,454
First St Bank DeQueen #336460CU2 07/18/19 07/19/21 2.000%2.000%245,000 249,138 183
Bank Hapoalim #06251AW89 07/19/19 07/19/21 2.000%2.000%245,000 249,381 657
Capital One Natl Assn #14042RMF5 07/24/19 07/26/19 2.050%2.050%245,000 249,361 614
TIAA FSB Jacksonville #87270LCN1 07/29/19 07/29/21 2.000%2.000%245,000 249,285 436
Wells Fargo #949763J31 09/18/19 09/20/21 1.850%1.850%245,000 249,496 184
BMW Bank #05580ASQ8 10/11/19 10/12/21 1.800%1.800%245,000 249,611 1,648
Wells Fargo #949495AN5 01/17/20 01/18/22 1.800%1.800%245,000 250,672 183
Bank Leumi #063248KQ0 03/31/20 03/31/22 1.250%1.250%245,000 249,339 1,276
Capital One Natl Assn #14042TCZ8 04/01/20 04/01/22 1.350%1.350%245,000 249,719 1,369
Synchrony Bank #87164WZN1 04/03/20 04/04/22 1.350%1.350%245,000 249,741 1,351
Wells Fargo #95001DAB6 06/17/20 06/17/23 1.200%1.200%245,000 244,169 106
Total Certificates of Deposits $5,390,000 $5,459,439 $21,524
Total J.P.Morgan Securities $23,149,701 $23,456,310 $121,046
*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, 2020
Cash & Investments by Fund - Total $43.4 million
Cash & Investments by Type - Total $43.4 million
Checking
Illinois Funds
Certificates of Deposit
Municipal Bonds
Corporate Bonds
Government & Agency Obligations
Accrued Interest
General Corporate
48.7%
Hotel/Motel Tax
11.0%Motor Fuel Tax
1.8%
Infrastructure
17.7%
Promenade TIF
0.0%
Water
15.6%
Sports Core
1.0%
Golf Surcharge
0.2%
Self-Insurance
0.9%Garage
0.7%
Equipment
Replacement
2.2%
Checking, $0.8
Illinois Funds, $19.3
Certificates of Deposit,
$5.4
Municipal Bonds, $7.3
Corporate Bonds, $8.7
Government & Agency
Obligations, $1.8
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)15,392,448$ 15,545,706$ (153,258)$ 216,125$
Main operating fund of the Village.
Hotel Fund (Major Fund)424,207$ 613,852$ (189,645)$ (16,635)$
Collects and spends resources from the
3% hotel/motel tax.
Motor Fuel Tax Fund 373,241$ 666,994$ (293,753)$ (137,930)$
Collects and spends resources from the
State motor fuel tax.
Infrastructure Fund (Major Fund)4,167,085$ 4,237,391$ (70,306)$ (4,752,465)$
Accounts for construction and maintenance of
roadways, drainage, and safety path systems.
Promenade TIF Fund (Major Fund)244,061$ 533,565$ (289,504)$ (269,990)$
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)5,764,339$ 4,949,148$ 815,191$ (1,683,470)$
Collects user fees for the distribution of water
and maintenance of infrastructure.
Sports Core Fund (Major Fund)2,710,187$ 2,483,430$ 226,757$ (13,610)$
Accounts for revenues and expenses relating
to administration, programs, food and beverage
operations, and golf course.
Golf Surcharge Fund 81,872$ 323,373$ (241,501)$ (316,320)$
Accounts for the collection of the $3 per round
golf surcharge.
Internal Service Funds
Self Insurance Fund 2,340,969$ 2,017,373$ 323,596$ (4,750)$
Accounts for the Village's health insurance costs
and the related contributions from the Village,
employees, retirees, and other agencies.
Garage Fund 483,933$ 447,995$ 35,938$ (17,745)$
Accounts for the maintenance of the Village's vehicle
fleet and the related departmental reimbursements.
Equipment Replacement Fund 220,832$ 95,265$ 125,567$ 76,210$
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, 2020
Village of Oak Brook
Monthly Financial Report – Fund Narrative
For the Period Ending August 31, 2020
The monthly financial report serves as a document to inform and update readers of the Village’s
financial current position, including historical and trend information. A detailed financial statement and
trend information is displayed for all Village major funds. A fund is considered major if it is the primary
operating of the Village (General Fund) or meets the following criteria:
Total assets/deferred outflows of resources, liabilities/deferred inflows of resources, revenues,
or expenditures/expenses of that individual governmental or enterprise fund are at least 10% of
the total for all funds of the same category or type, and
The same element of the individual fun that met the 10% test is at least 5% of the
corresponding total for all funds combined.
This report is prepared on a cash basis of accounting, meaning transactions are recognized only when
cash is increased or decreased. Transactions for each month are compared to amounts from the
Village’s annual budget, which was also prepared using the cash basis of accounting. For the Village’s
major enterprise funds (Water and Sports Core), a reconciliation is included to display results on a full
accrual basis, which is how information is presented in the Village’s annual Comprehensive Annual
Financial Report (CAFR).
The proceeding pages contain detailed information on the Village’s major funds. Highlights for each of
the Village’s funds are:
General Fund
Total revenues through August 2020 are $3,156,871, or 17.4%, lower than last August and
$2,249,879, or 13.1%, under budget to date. The main drivers for this are:
o Sales tax revenue, the General
Fund’s largest revenue source, is
down $1,061,006 from last year
and $1,025,757 under budget.
August 2020 collections dropped
significantly compared to
collections the previous five
years. The decline is related to
the COVID-19 pandemic, which
saw numerous businesses close
in March through much of June.
o Telecommunications/Utility Tax
is down $212,358 from last year and $173,971 under budget. This is due to a decrease
in usage from the closure of businesses during the pandemic.
o Licenses and permits revenue is down $1,667,405 from last year and $763,251 under
budget. This is due to the timing of permits being issued vs. when originally planned.
Permit revenue is still expected to be strong in 2020 with the Hines Oak Brook
Commons kicking off shortly.
o Charges for Services revenue is down $237,744 from last year and $228,824 under
budget. This is primarily due to a decrease in ambulance fees from fewer calls for
service due to the ongoing pandemic.
Total expenditures through August 2020 are $708,950, or 4.5%, lower than last year and
$1,444,134, or 8.7%, under budget to date. The main drivers for this are:
o Personnel expenditures are up $369,919 from last year, but $321,412 under budget.
The increase is due to a combination of annual pay increases and final accrual payouts
from three retirements. Personnel is under budget due to the start of furlough days and
a reduction in overtime due to the COVID-19 pandemic.
o Operation and contract expenditures are down $554,043 from last year and $574,967
under budget. This is due to the general timing of payments compared to when they
were projected to occur. The Village has also put various projects on hold until after the
pandemic is over.
o Capital outlay expenditures are down $547,396 from last year and $462,299 under
budget. Many capital items have been put on hold for 2020 due to the current
economic state.
Hotel Tax Fund
Total revenues through August 2020 are $482,051, or 53.2%, lower than last year and $401,093,
or 48.6%, under budget. The main drivers for this are:
o Hotel tax revenue is down $460,939 from last year and $406,701 under budget. The
decrease is due to the timing of receipts being received and a reduction in room rentals
from the COVID-19 pandemic.
Total expenditures through August 2020 are $195,968, or 53.2%, higher than last year, but
$60,766, or 9.7%, under budget. The main drivers for this are:
o Operation and contract expenditures are down $72,448 from last year and $198,787
under budget. This is due to the timing of advertising payments and the cancelling of
some campaigns. In addition, the Village rebated $70,013 of hotel tax related to
January, February, and March stays back to the hotels.
o Capital Outlay expenditures are up $268,416 from last year and $138,021 over budget.
The street light replacements began earlier than originally projected.
Infrastructure Fund
Total revenues through August 2020 are down $695,285, or 17.6%, from last year and $588,968,
or 15.3%, under budget. The main
drivers for this are:
o Non-home rule sales tax revenue
is down $606,360 from last year
and $571,287 under budget.
August 2020 collections dropped
significantly compared to
collections the previous five
years. The decline is related to
the COVID-19 pandemic, which
saw numerous businesses close
in March through much of June.
o Interest revenue is down $89,260 from last year and $15,656 under budget. Interest
rates have dropped in recent months compared to last year. In addition, the
Infrastructure Fund’s reserve balance has shifted to cash and other short-term
investments in order to have money available for upcoming projects.
Total expenditures through August 2020 are up $188,310 or 4.8%, from last year, but
$5,087,179, or 55.2%, under budget to date. The main drivers for this are:
o Operation and contract expenditures are down $128,426 from last year and $357,539
under budget. Expenditures are under budget due to the timing of engineering
payments. Some projects have been delayed due to the current pandemic.
o Capital Outlay expenditures are up $317,967 from last year, but $4,684,647 under
budget. The majority of budgeted projects have not occurred to date and may be
delayed until later in the year or 2021.
Promenade TIF Fund
Total revenues through August 2020 are down $2,706, or 1.1% from last year, but $5,561, or
2.3%, over budget. The timing of sales tax transfers has changed in 2020 due to information
being more readily available from IDOR. Interest rates have dropped in recent months
compared to last year, resulting in a decrease in interest income.
Total expenditures through August 2020 are up $69,112, or 14.9%, from last year and $25,075,
or 4.9%, over budget. The increase relates to additional principal and interest paid towards the
TIF note. Expenditures are over budget due to the timing of audit and TIF report fees, as well as
more principal paid on the note due to an increase in real estate taxes.
Water Fund
Total revenues through August 2020 are down $376,844, or 6.1%, from last year and $606,481,
or 9.5%, under budget. The main drivers for this are:
o Water sales revenue is down $155,117 from last year and $538,090 under budget. The
decrease in water sales relates to the business shut down from the COVID-19 pandemic.
o Water connection fees are down $151,320 from last year and $54,470 under budget.
Revenue is down from last year due to the opening of a large office building in 2019.
Revenue is under budget due to the delay in construction of planned development in
2020.
Total expenditures through August 2020 are down $203,088, or 4.2%, from last year and
$3,105,150, or 40.3%, under budget. The main drivers for this are:
o Operation and contract expenditures are down $140,569 from last year and $1,159,094
under budget. Expenditures are under budget due to the timing of invoices paid and
DuPage Water Commission water purchased being less than expected.
o Capital outlay expenditures are down $8,821 from last year and $1,835,589 under
budget. A number of budgeted projects for 2020 are on hold due to the current
pandemic. Activity so far in 2020 primarily relates to finishing 2019 projects.
Sports Core Fund
•Total revenues through August 2020 are down $537,849, or 20.9%, from last year and $813,831,
or 28.5%, under budget to date. Most revenue sources are under budget to date in 2020 due to
the COVID-19 pandemic limiting activity. Starting in 2020, the Park District took over all Bath
and Tennis Club membership sales, however, this was not factored into the 2020 budget due to
the timing of the agreement. Highlights of Sports core revenues are:
o Membership revenue is down $194,794 from last year and $234,248 under budget. This
is due to a change in swimming and tennis memberships being taken over by the Park
District rather than the Village. Golf memberships are up $27,013 from last year and
$7,188 over budget to date.
o Greens Fees are up $50,964 from last year and $29,317 over budget. The golf course
was open on a limited basis until June 1, but has made up nearly all the lost rounds
since.
o Rental income is down $284,569 from last year and $245,178 under budget. This is due
to many events being cancelled this year at the B&T Clubhouse. In addition, golf cart
rental fees are down due to the course being closed in the spring.
Total expenditures through August 2020 are down $684,853, or 21.9%, from last year and
$1,602,227, or 39.6%, under budget to date. The main drivers for this are:
o Personnel expenditures are down $168,630 from last year and $180,817 under budget.
Personnel is down due to the COVID-19 pandemic closing Sports Core facilities for much
of spring.
o Materials & Supplies expenditures are down $125,515 from last year and $135,714
under budget. Expenditures are down due to facilities being closed for much of the
spring.
o Operation and Contractual expenditures are down $508,576 from last year and
$547,749 under budget. This is due to the outsourcing of swimming, tennis, and soccer
fields to the Park District. Previously, the Village paid the Park District $230,000 to
operate the swimming pool.
o Capital expenditures are up $117,868 from last year, but $737,947 under budget. This is
due to the golf lounge renovation project and a delay in the pool renovation project due
to the COVID-19 pandemic.
8/31/20 8/31/20
8/31/19 8/31/20 YTD % of YTD 2020 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 8,377,249$ 7,316,243$ 8,342,000$ 87.7%12,502,000$ (1,061,006)$
Other Intergovernmental Tax*1,044,345 1,069,495 989,350 108.1%1,352,000 25,150
Telecommunications/Utility Tax 4,207,387 3,995,029 4,169,000 95.8%6,125,000 (212,358)
Licenses and Permits 2,939,279 1,271,874 2,035,125 62.5%2,990,190 (1,667,405)
Charges for Services 828,430 590,686 819,510 72.1%1,253,100 (237,744)
Fines and Penalties 156,786 112,048 128,000 87.5%192,000 (44,738)
Administrative Towing Fees 15,004 12,664 13,320 95.1%20,000 (2,340)
Investment Interest 307,507 260,181 276,680 94.0%415,000 (47,326)
Franchise Fees 106,424 101,907 157,500 64.7%210,000 (4,517)
Miscellaneous Income 149,316 244,729 294,250 83.2%443,095 95,413
Total Operating Revenues 18,131,727$ 14,974,856$ 17,224,735$ 86.9%25,502,385$ (3,156,871)$
OPERATING EXPENDITURES
Personnel 12,070,539$ 12,467,458$ 12,788,870$ 97.5%19,160,220$ 396,919$
Materials and Supplies 291,273 289,805 373,095 77.7%539,170 (1,468)
Operation and Contract 2,801,756 2,247,713 2,822,680 79.6%4,071,660 (554,043)
Other Expenditures 7,336 4,374 6,540 66.9%10,000 (2,962)
Capital Outlay 664,207 116,811 579,110 20.2%688,030 (547,396)
Total Operating Expenditures 15,835,111$ 15,126,161$ 16,570,295$ 91.3%24,469,080$ (708,950)$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 2,296,616$ (151,305)$ 654,440$ 1,033,305$ (2,447,921)$
INTERFUND TRANSACTIONS
Transfers In 508,235$ -$ -$ 0.0%-$ (508,235)$
Transfers Out (334,203) (326,369) (762,755) 42.8%(923,000) 7,834
Reimbursements From Other Funds 421,472 417,592 417,600 100.0%626,395 (3,880)
Reimbursements To Other Funds (87,400) (93,176) (93,160) 100.0%(139,770) (5,776)
Total Interfund Transactions 508,104$ (1,953)$ (438,315)$ 0.4%(436,375)$ (510,057)$
NET FUND INCREASE (DECREASE)2,804,720$ (153,258)$ 216,125$ 596,930$ (2,957,978)$
*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, 2020
Total Total
Revenues Expenditures
8/31/20 Actual 14,974,856$ 15,126,161$
8/31/19 Actual 18,131,727$ 15,835,111$
% Change From Last Year -17.4%-4.5%
Major Revenues
Other Telecom/Utility Licenses &Charges for
Sales Tax Intergov. Tax Tax Permits Services
8/31/20 Actual 7,316,243$ 1,069,495$ 3,995,029$ 1,271,874$ 590,686$
8/31/19 Actual $ 8,377,249 $ 1,044,345 $ 4,207,387 $ 2,939,279 $ 828,430
% Change From Last Year -12.7%2.4%-5.0%-56.7%-28.7%
Five Year Trend
Major Expenditures Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
8/31/20 Actual 12,467,458$ 289,805$ 2,247,713$ 4,374$ 116,811$
8/31/19 Actual 12,070,539$ 291,273$ 2,801,756$ 7,336$ 664,207$
% Change From Last Year 3.3%-0.5%-19.8%-40.4%-82.4%
Five Year Trend
Expenditures by Department
8/31/19 8/31/20 8/31/20 8/31/20 2020 Difference Five
YTD YTD YTD % of Annual Prior Year
Department Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 1,562,795$ 1,371,353$ 1,765,735$ 77.7%2,556,835$ (191,442)$
Financial Services 508,750 514,010 533,105 96.4%781,455 5,260
Public Works 619,492 480,305 601,700 79.8%893,055 (139,187)
Engineering & Capital Projects 317,120 31,899 370,900 8.6%411,500 (285,221)
Library 623,763 546,620 669,800 81.6%994,410 (77,143)
Police 6,098,968 6,099,940 6,351,790 96.0%9,493,905 972
Fire 5,460,263 5,413,242 5,590,840 96.8%8,298,370 (47,021)
Development Services 643,960 668,792 686,425 97.4%1,039,550 24,832
Total Expenditures 15,835,111$ 15,126,161$ 16,570,295$ 91.3%24,469,080$ (708,950)$
Five Year Trend
For the Period Ending August 31, 2020
General Fund - Five Year Trend
Village of Oak Brook
Revenues Expenditures
8/31/20 8/31/20
8/31/19 8/31/20 YTD % of YTD 2020 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Hotel Tax 829,538$ 368,599$ 775,300$ 47.5%1,212,500$ (460,939)$
Investment Interest 76,720 51,441 50,000 102.9%75,000 (25,279)
Loan Interest - 4,167 - N/A - 4,167
Total Operating Revenues 906,258$ 424,207$ 825,300$ 51.4%1,287,500$ (482,051)$
EXPENDITURES
Operation and Contract 368,076$ 295,628$ 494,415$ 59.8%576,615$ (72,448)$
Capital Outlay - 268,416 130,395 205.8%640,395 268,416
Total Expenditures 368,076$ 564,044$ 624,810$ 90.3%1,217,010$ 195,968$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 538,182$ (139,837)$ 200,490$ -69.7%70,490$ (678,019)$
INTERFUND TRANSACTIONS
Transfer Out -$ -$ (167,325)$ 0.0%(338,125)$ -$
Reimbursements to Other Funds (68,744) (49,808) (49,800) 100.0%(74,715) 18,936
Total Interfund Transactions (68,744)$ (49,808)$ (217,125)$ 22.9%(412,840)$ 18,936$
NET FUND INCREASE (DECREASE)469,438$ (189,645)$ (16,635)$ (342,350)$ (659,083)$
Note - Expenditures are recorded in program 171.
Village of Oak Brook
Hotel Tax Fund Financial Update
For the Period Ending August 31, 2020
Total Total
Revenues Expenditures
8/31/20 Actual $ 424,207 564,044$
8/31/19 Actual $ 906,258 368,076$
% Change From Last Year -53.2%53.2%
Major Revenues Investment
Hotel Tax Interest Loan Interest Miscellaneous
8/31/20 Actual $ 368,599 $ 51,441 4,167$ -$
8/31/19 Actual $ 829,538 $ 76,720 -$ -$
% Change From Last Year -55.6%-32.9%N/A 0.0%
Five Year Trend
Major Expenditures Operation &
Contractual Capital Outlay
8/31/20 Actual 295,628$ 268,416$
8/31/19 Actual 368,076$ -$
% Change From Last Year -19.7%N/A
Five Year Trend
Village of Oak Brook
Hotel Tax Fund - Major Sources Five Year Trend
For the Period Ending August 31, 2020
Five Year Trend
Revenues Expenditures
8/31/20 8/31/20
8/31/19 8/31/20 YTD % of YTD 2020 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 3,799,573$ 3,193,213$ 3,764,500$ 84.8%5,615,000$ (606,360)$
Charges for Services - 335 680 49.3%1,000 335
Investment Interest 156,924 67,664 83,320 81.2%125,000 (89,260)
Miscellaneous - - 1,680 0.0%2,500 -
Total Operating Revenues 3,956,497$ 3,261,212$ 3,850,180$ 84.7%5,743,500$ (695,285)$
OPERATING EXPENDITURES
Personnel 894,524$ 870,649$ 920,400$ 94.6%1,389,540$ (23,875)$
Materials and Supplies 104,189 126,833 122,075 103.9%253,295 22,644
Operation and Contract 1,023,987 895,561 1,253,100 71.5%1,856,790 (128,426)
Capital Outlay 1,918,181 2,236,148 6,920,795 32.3%10,220,090 317,967
Total Operating Expenditures 3,940,881$ 4,129,191$ 9,216,370$ 44.8%13,719,715$ 188,310$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 15,616$ (867,979)$ (5,366,190)$ 16.2%(7,976,215)$ (883,595)$
INTERFUND TRANSACTIONS
Transfers In 216,125$ 666,289$ 482,325$ 138.1%1,653,125$ 450,164$
Reimbursements From Other Funds 222,296 239,584 239,600 100.0%359,380 17,288
Reimbursements To Other Funds (107,688) (108,200) (108,200) 100.0%(162,300) (512)
Total Interfund Transactions 330,733$ 797,673$ 613,725$ 130.0%1,850,205$ 466,940$
NET FUND INCREASE (DECREASE)346,349$ (70,306)$ (4,752,465)$ (6,126,010)$ (416,655)$
Village of Oak Brook
Infrastructure Fund Financial Update
For the Period Ending August 31, 2020
Total Total
Revenues Expenditures
8/31/20 Actual $ 3,261,212 4,129,191$
8/31/19 Actual $ 3,956,497 3,940,881$
% Change From Last Year -17.6%4.8%
Major Revenues
Sales Tax
Charges for
Services
Investment
Interest Miscellaneous
8/31/20 Actual $ 3,193,213 $ 335 $ 67,664 $ -
8/31/19 Actual $ 3,799,573 $ - $ 156,924 $ -
% Change From Last Year -16.0%N/A -56.9%0.0%
Five Year Trend
Major Expenditures Materials &Operation &
Personnel Supplies Contractual Capital Outlay
8/31/20 Actual 870,649$ 126,833$ 895,561$ 2,236,148$
8/31/19 Actual 894,524$ 104,189$ 1,023,987$ 1,918,181$
% Change From Last Year -2.7%21.7%-12.5%16.6%
Five Year Trend
Expenditures by Department
8/31/19 8/31/20 8/31/20 8/31/20 2020 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 108,509$ 79,402$ 116,350$ 68.2%176,490$ (29,107)$
Public Works 2,140,022 2,910,235 3,548,335 82.0%4,390,810 770,213
Engineering & Capital Projects 1,692,350 1,139,554 5,551,685 20.5%9,152,415 (552,796)
Total Expenditures 3,940,881$ 4,129,191$ 9,216,370$ 44.8%13,719,715$ 188,310$
Five Year Trend
Village of Oak Brook
Infrastructure Fund - Major Sources Five Year Trend
For the Period Ending August 31, 2020
Revenues Expenditures
8/31/20 8/31/20
8/31/19 8/31/20 YTD % of YTD 2020 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 39,820$ 36,311$ 47,500$ 76.4%95,000$ (3,509)$
Real Estate Tax 205,855 207,272 190,000 109.1%380,000 1,417
Investment Interest 1,092 478 1,000 47.8%1,500 (614)
Total Operating Revenues 246,767$ 244,061$ 238,500$ 102.3%476,500$ (2,706)$
EXPENDITURES
Operation and Contract 3,473$ 3,665$ 3,590$ 102.1%3,890$ 192$
Other Expenditures 460,980 529,900 504,900 105.0%504,900 68,920
Total Expenditures 464,453$ 533,565$ 508,490$ 104.9%508,790$ 69,112$
NET FUND INCREASE (DECREASE)(217,686)$ (289,504)$ (269,990)$ (32,290)$ (71,818)$
Note - Expenditures are recorded in program 283.
Village of Oak Brook
Promenade TIF Fund Financial Update
For the Period Ending August 31, 2020
Total Total
Revenues Expenditures
8/31/20 Actual $ 244,061 533,565$
8/31/19 Actual $ 246,767 464,453$
% Change From Last Year -1.1%14.9%
Major Revenues Real Estate Investment
Sales Tax Tax Interest
8/31/20 Actual 36,311$ $ 207,272 $ 478
8/31/19 Actual 39,820$ $ 205,855 $ 1,092
% Change From Last Year -8.8%0.7%-56.2%
Five Year Trend
Major Expenditures Operation &Other
Contractual Expenditures
8/31/20 Actual 3,665$ 529,900$
8/31/19 Actual 3,473$ 460,980$
% Change From Last Year 5.5%15.0%
Five Year Trend
Village of Oak Brook
Promenade TIF Fund - Major Sources Five Year Trend
For the Period Ending August 31, 2020
Five Year Trend
Revenues Expenditures
8/31/20 8/31/20
8/31/19 8/31/20 YTD % of YTD 2020 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Plan Review Fees 1,050$ 525$ 800$ 65.6%1,200$ (525)$
Building/Inspection Fees 5,813 5,287 5,320 99.4%8,000 (526)
Water Sales 5,730,027 5,574,910 6,113,000 91.2%10,302,525 (155,117)
Unmetered Sales 31,997 60,301 20,000 301.5%30,000 28,304
Water Connection Fees 163,530 12,210 66,680 18.3%100,000 (151,320)
Meter Charges 23,307 6,902 13,340 51.7%20,000 (16,405)
Special Services 16,772 12,657 15,000 84.4%30,000 (4,115)
Investment Interest 120,272 71,594 86,680 82.6%130,000 (48,678)
Miscellaneous 48,415 19,953 50,000 39.9%75,000 (28,462)
Total Operating Revenues 6,141,183$ 5,764,339$ 6,370,820$ 90.5%10,696,725$ (376,844)$
OPERATING EXPENDITURES
Personnel 540,678$ 498,815$ 578,180$ 86.3%868,705$ (41,863)$
Materials and Supplies 31,098 19,263 50,365 38.2%74,260 (11,835)
Operation and Contract 2,872,690 2,732,121 3,891,215 70.2%5,833,755 (140,569)
Capital Outlay 1,356,562 1,347,741 3,183,330 42.3%6,293,225 (8,821)
Total Expenditures 4,801,028$ 4,597,940$ 7,703,090$ 59.7%13,069,945$ (203,088)$
Surplus (Deficit) of Revenues Over
Expenditures 1,340,155$ 1,166,399$ (1,332,270)$ -87.5%(2,373,220)$ (173,756)$
INTERFUND TRANSACTIONS
Transfers In 221,085$ -$ -$ 0.0%-$ (221,085)
Reimbursements To Other Funds (367,888) (351,208) (351,200) 100.0%(526,815) 16,680
Total Interfund Transactions (146,803)$ (351,208)$ (351,200)$ 100.0%(526,815)$ (204,405)$
Fund Increase/(Decrease) - Budgetary Basis 1,193,352$ 815,191$ (1,683,470)$ -48.4%(2,900,035)$ (378,161)$
ADUSTMENTS TO GAAP BASIS*
Remove Capital Outlay 1,356,562$ 1,347,741$
Depreciation Expense (341,403) (383,333)
IMRF Pension Expense 51,491 33,333
OPEB Expense (32,683) (30,000)
Total GAAP Adjustments 1,033,966$ 967,741$
Fund Increase/(Decrease) - GAAP Basis 2,227,318$ 1,782,932$
*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, 2020
Total Total
Revenues Expenditures
8/31/20 Actual $ 5,764,339 4,597,940$
8/31/19 Actual $ 6,141,183 4,801,028$
% Change From Last Year -6.1%-4.2%
Unmetered Water
Water Sales Sales Connection Fees Meter Charges Miscellaneous
8/31/20 Actual $ 5,574,910 $ 60,301 $ 12,210 $ 6,902 $ 19,953
8/31/19 Actual $ 5,730,027 $ 31,997 $ 163,530 $ 23,307 $ 48,415
% Change From Last Year -2.7%88.5%-92.5%-70.4%-58.8%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
8/31/20 Actual 498,815$ 19,263$ 2,732,121$ -$ 1,347,741$
8/31/19 Actual 540,678$ 31,098$ 2,872,690$ -$ 1,356,562$
% Change From Last Year -7.7%-38.1%-4.9%0.0%-0.7%
Five Year Trend
Expenditures by Department
8/31/19 8/31/20 8/31/20 8/31/20 2020 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Public Works 3,435,643$ 3,281,122$ 4,353,370$ 75.4%6,527,120$ (154,521)$
Engineering & Capital Projects 1,365,385 1,316,818 3,349,720 39.3%6,542,825 (48,567)
Total Expenditures 4,801,028$ 4,597,940$ 7,703,090$ 59.7%13,069,945$ (203,088)$
Five Year Trend
Village of Oak Brook
Water Fund - Major Sources Five Year Trend
For the Period Ending August 31, 2020
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Sports Core Fund Consolidated Presentation
For the Period Ending August 31, 2020
8/31/20 8/31/20
8/31/20 YTD % of YTD 2020 8/31/19 Difference
B&T Recreation Field Clubhouse Golf YTD Amended Amended Adopted YTD Prior
Operations Operations Operations Club Total Budget Budget Budget Total Year
OPERATING REVENUES
Memberships 199$ -$ -$ 224,688$ 224,887$ 459,135$ 49.0%459,135$ 419,681$ (194,794)$
Greens Fees - - - 743,317 743,317 714,000 104.1%930,000 692,353 50,964
Pro Shop Sales - - - 126,700 126,700 164,500 77.0%207,000 155,876 (29,176)
Golf Lessons - - - 44,405 44,405 39,000 113.9%40,000 33,575 10,830
Driving Range Fees - - - 204,971 204,971 214,000 95.8%244,000 209,177 (4,206)
Rentals - 95,040 14,741 240,926 350,707 595,885 58.9%962,000 635,276 (284,569)
Programs/User Fees - - - - - 54,700 0.0%66,300 62,172 (62,172)
Food Sales - - - 103,524 103,524 138,745 74.6%180,500 143,071 (39,547)
Beverage Sales - - - 236,375 236,375 202,615 116.7%265,000 211,448 24,927
Taste of Oak Brook - - - - - 120,000 0.0%120,000 - -
Grants - - - - - 139,800 0.0%139,800 - -
Other Revenue 719 - - 3,504 4,223 10,560 40.0%11,000 14,329 (10,106)
Total Operating Revenues 918$ 95,040$ 14,741$ 1,928,410$ 2,039,109$ 2,852,940$ 71.5%3,624,735$ 2,576,958$ (537,849)$
OPERATING EXPENDITURES
Personnel 24,076$ -$ 71,999$ 822,023$ 918,098$ 1,098,915$ 83.5%1,578,100$ 1,086,728$ (168,630)$
Materials & Supplies 3,545 119 1,540 367,442 372,646 508,360 73.3%618,025 498,161 (125,515)
Operational & Contractual 39,651 23,796 37,934 195,120 296,501 844,250 35.1%1,055,095 805,077 (508,576)
Other - - - - - - 0.0%(83,150) - -
Capital 356,601 8,710 36,215 457,027 858,553 1,596,500 53.8%1,921,545 740,685 117,868
Total Operating Expenditures 423,873$ 32,625$ 147,688$ 1,841,612$ 2,445,798$ 4,048,025$ 60.4%5,089,615$ 3,130,651$ (684,853)$
B&T Administration Overhead Allocation*50,647$ -$ (50,647)$ -$ -$ -$ 0.0%-$ -$ -$
Operating Revenues Over (Under) Expenditures (372,308)$ 62,415$ (183,594)$ 86,798$ (406,689)$ (1,195,085)$ 34.0%(1,464,880)$ (553,693)$ 147,004$
INTERFUND TRANSACTIONS
Transfer From General Fund 326,369$ -$ -$ -$ 326,369$ 762,755$ 42.8%923,000$ 334,203$ (7,834)$
Transfer From Hotel Tax Fund - - - - - 35,000 0.0%35,000 - -
Transfer From Golf Surcharge Fund - - - 323,373 323,373 400,000 80.8%400,000 212,969 110,404
Reimbursement From Infrastructure Fund 16,000 - - - 16,000 16,000 100.0%24,000 16,000 -
Reimbursement From Water Fund 5,336 - - - 5,336 5,320 100.3%8,000 5,336 -
Reimbursement To General Fund (18,816) - - (18,816) (37,632) (37,600) 100.1%(56,450) - (37,632)
Total Interfund Transactions 328,889$ -$ -$ 304,557$ 633,446$ 1,181,475$ 53.6%1,333,550$ 568,508$ 64,938$
Total Revenues Over (Under) Expenditures - Budgetary Basis (43,419)$ 62,415$ (183,594)$ 391,355$ 226,757$ (13,610)$ (131,330)$ 14,815$ 211,942$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay 356,601$ 8,710$ 36,215$ 457,027$ 858,553$ 740,685$
Depreciation Expense (99,935) (1,123) (23,333) (141,333) (265,725) (218,926)
IMRF Pension Expense (3,500) (167) (1,333) (7,900) (12,900) 61,847
OPEB Expense - - (3,467) (26,667) (30,133) (13,357)
Total GAAP Adjustments 253,166$ 7,420$ 8,082$ 281,127$ 549,794$ 570,250$
Fund Increase/(Decrease) - GAAP Basis 209,747$ 69,835$ (175,512)$ 672,482$ 776,551$ 585,065$
*Overhead allocation is comprised of salaries, business forms, liability insurance, building & grounds maintenance and bank service fees in Program 811 - Sports Core General Operations distributed to various Sports Core
Programs on a % basis.
**Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.
Total Direct Total Direct
Revenues Expenditures
8/31/20 Actual $ 2,039,109 2,445,798$
8/31/19 Actual $ 2,576,958 3,130,651$
% Change From Last Year -20.9%-21.9%
Driving Program/
Memberships Greens Fees Range Fees Rentals User Fees
8/31/20 Actual $ 224,887 $ 743,317 $ 204,971 $ 350,707 -$
8/31/19 Actual $ 419,681 $ 692,353 $ 209,177 $ 635,276 62,172$
% Change From Last Year -46.4%7.4%-2.0%-44.8%-100.0%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
8/31/20 Actual 918,098$ 372,646$ 296,501$ -$ 858,553$
8/31/19 Actual 1,086,728$ 498,161$ 805,077$ -$ 740,685$
% Change From Last Year -15.5%-25.2%-63.2%0.0%15.9%
Five Year Trend
Revenues by Department 8/31/19 8/31/20 8/31/20 8/31/20 2020 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Operations 344,842$ 918$ 493,195$ 0.2%506,735$ (289,015)$
Open Field Operations 98,693 95,040 268,210 35.4%407,000 (3,653)
B&T Clubhouse Operations 209,837 14,741 162,500 9.1%300,000 (195,096)
Golf Club 1,923,586 1,928,410 1,929,035 100.0%2,411,000 4,824
Total Revenues 2,576,958$ 2,039,109$ 2,852,940$ 71.5%3,624,735$ (482,940)$
Expenditures by Department 8/31/19 8/31/20 8/31/20 % of YTD 2020 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Operations 653,871$ 423,873$ 1,401,875$ 30.2%1,752,045$ (229,998)$
Open Field Operations 145,556$ 32,625$ 193,155$ 16.9%267,110$ (112,931)$
B&T Clubhouse Operations 525,634 147,688 378,215 39.0%458,770 (377,946)
Golf Club 1,805,590 1,841,612 2,074,780 88.8%2,611,690 36,022
Total Expenditures 3,130,651$ 2,445,798$ 4,048,025$ 60.4%5,089,615$ (684,853)$
Five Year Trend
Village of Oak Brook
Sports Core Fund - Major Sources Five Year Trend
For the Period Ending August 31, 2020
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Bath & Tennis Club Recreation Operations
For the Period Ending August 31, 2020 8/31/20 8/31/20
822 8/31/20 YTD % of YTD 2020 8/31/19 Difference
811 812 813 Poolside YTD Amended Amended Adopted YTD Prior
B&T Admin Swimming Tennis Café Total Budget Budget Budget Total Year
OPERATING REVENUES
Memberships -$ 199$ -$ -$ 199$ 241,635$ 0.1%241,635$ 222,006$ (221,807)$
Programs/User Fees - - - - - 54,700 0.0%66,300 62,172 (62,172)
Food Sales - - - - - 35,000 0.0%36,000 35,375 -
Beverage Sales - - - - - 19,500 0.0%20,000 19,534 -
Grants - - - - - 139,800 0.0%139,800 - -
Other Revenue 719 - - - 719 2,560 28.1%3,000 5,755 (5,036)
Total Operating Revenues 719$ 199$ -$ -$ 918$ 493,195$ 0.2%506,735$ 344,842$ (289,015)$
OPERATING EXPENDITURES
Personnel 24,076$ -$ -$ -$ 24,076$ 146,630$ 16.4%163,580$ 126,217$ (102,141)$
Materials & Supplies 345 2,165 1,035 - 3,545 55,850 6.3%57,650 69,932 (66,387)
Operational & Contractual 28,640 5,000 6,011 - 39,651 386,895 10.2%418,270 378,080 (338,429)
Capital 30,138 326,369 94 - 356,601 812,500 43.9%1,112,545 79,642 276,959
Total Operating Expenditures 83,199$ 333,534$ 7,140$ -$ 423,873$ 1,401,875$ 30.2%1,752,045$ 653,871$ (229,998)$
B&T Administration Overhead Allocation*101,295$ (36,466)$ (10,130)$ (4,052)$ 50,647$ 81,495$ 62.1%93,235$ 94,875$ (44,228)$
Operating Revenues Over (Under) Expenditures 18,815$ (369,801)$ (17,270)$ (4,052)$ (372,308)$ (827,185)$ 45.0%(1,152,075)$ (214,154)$ (103,245)$
INTERFUND TRANSACTIONS
Transfer From General Fund -$ 326,369$ -$ -$ 326,369$ 597,255$ 54.6%757,500$ 48,704$ 277,665$
Reimbursement From Infrastructure Fund 16,000 - - - 16,000 16,000 100.0%24,000 16,000 -
Reimbursement From Water Fund 5,336 - - - 5,336 5,320 100.3%8,000 5,336 -
Reimbursement To General Fund (18,816) - - - (18,816) (18,800) 100.1%(28,225) - (18,816)
Total Interfund Transactions 2,520$ 326,369$ -$ -$ 328,889$ 599,775$ 54.8%761,275$ 70,040$ 258,849$
Total Revenues Over (Under) Expenditures - Budgetary Basis 21,335$ (43,432)$ (17,270)$ (4,052)$ (43,419)$ (227,410)$ (390,800)$ (144,114)$ 155,604$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay 30,138$ 326,369$ 94$ -$ 356,601$ 79,642$
Depreciation Expense - (95,823) (3,333) (779) (99,935) (63,216)
IMRF Pension Expense (3,333) - - (167) (3,500) 4,066
Total GAAP Adjustments 26,805$ 230,546$ (3,239)$ (945)$ 253,166$ 20,492$
Fund Increase/(Decrease) - GAAP Basis 48,140$ 187,114$ (20,509)$ (4,997)$ 209,747$ (123,622)$
*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, 2020 8/31/20 8/31/20
8/31/20 YTD % of YTD 2020 8/31/19 Difference
815 816 YTD Amended Amended Adopted YTD Prior
Polo Open Fields Total Budget Budget Budget Total Year
OPERATING REVENUES
Field Rentals -$ 20,040$ 20,040$ 148,210$ 13.5%212,000$ 98,693$ (78,653)$
Range Rentals - 75,000 75,000 - N/A 75,000 - 75,000
Taste of Oak Brook - - - 120,000 0.0%120,000 - -
Total Operating Revenues -$ 95,040$ 95,040$ 268,210$ 35.4%407,000$ 98,693$ (3,653)$
OPERATING EXPENDITURES
Personnel -$ -$ -$ 6,005$ 0.0%10,810$ 3,962$ (3,962)$
Materials & Supplies - 119 119 1,000 11.9%1,700 - 119
Operational & Contractual 5,000 18,796 23,796 171,150 13.9%239,600 130,630 (106,834)
Capital - 8,710 8,710 15,000 58.1%15,000 10,964 (2,254)
Total Operating Expenditures 5,000$ 27,625$ 32,625$ 193,155$ 16.9%267,110$ 145,556$ (112,931)$
Operating Revenues Over (Under) Expenditures (5,000)$ 67,415$ 62,415$ 75,055$ 83.2%139,890$ (46,863)$ 109,278$
INTERFUND TRANSACTIONS
Transfer From Hotel Tax Fund -$ -$ -$ 35,000$ 0.0%35,000$ -$ -$
Total Interfund Transactions -$ -$ -$ 35,000$ 0.0%35,000$ -$ -$
Total Revenues Over (Under) Expenditures - Budgetary Basis (5,000)$ 67,415$ 62,415$ 110,055$ 174,890$ (46,863)$ 109,278$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay -$ 8,710$ 8,710$ 10,964$
Depreciation Expense - (1,123) (1,123) (1,123)
IMRF Pension Expense - (167) (167) 490
Total GAAP Adjustments -$ 7,420$ 7,420$ 10,331$
Fund Increase/(Decrease) - GAAP Basis (5,000)$ 74,835$ 69,835$ (36,532)$
*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, 2020
8/31/20 8/31/20
821 YTD % of YTD 2020 8/31/19 Difference
B&T Amended Amended Adopted YTD Prior
Clubhouse Budget Budget Budget Total Year
OPERATING REVENUES
Rentals 14,741$ 162,500$ 9.1%300,000$ 209,837$ (195,096)$
Total Operating Revenues 14,741$ 162,500$ 9.1%300,000$ 209,837$ (195,096)$
OPERATING EXPENDITURES
Personnel 71,999$ 92,830$ 77.6%140,045$ 88,642$ (16,643)$
Materials & Supplies 1,540 14,805 10.4%20,225 18,971 (17,431)
Operational & Contractual 37,934 81,580 46.5%109,500 69,327 (31,393)
Capital 36,215 189,000 19.2%189,000 348,694 (312,479)
Total Operating Expenditures 147,688$ 378,215$ 39.0%458,770$ 525,634$ (377,946)$
B&T Administration Overhead Allocation*(50,647)$ (81,495)$ 62.1%(93,235)$ (94,875)$ 44,228$
Operating Revenues Over (Under) Expenditures (183,594)$ (297,210)$ 61.8%(252,005)$ (410,672)$ 227,078$
INTERFUND TRANSACTIONS
Transfer From General Fund -$ 165,500$ 0.0%165,500$ 285,499$ (285,499)$
Total Interfund Transactions -$ 165,500$ 0.0%165,500$ 285,499$ (285,499)$
Total Revenues Over (Under) Expenditures - Budgetary Basis (183,594)$ (131,710)$ (86,505)$ (125,173)$ (58,421)$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay 36,215$ 348,694$
Depreciation Expense (23,333) (21,434)
IMRF Pension Expense (1,333) 4,466
OPEB Expense (3,467) (1,400)
Total GAAP Adjustments 8,082$ 330,326$
Fund Increase/(Decrease) - GAAP Basis (175,512)$ 205,153$
*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, 2020
8/31/20 8/31/20
823 831 832 833 834 8/31/20 YTD % of YTD 2020 8/31/19 Difference
Golf Golf General Golf Learning Golf Cart Golf Course YTD Amended Amended Adopted YTD Prior
Café Operation & Practice Operations Maintenance Total Budget Budget Budget Total Year
OPERATING REVENUES
Memberships -$ 224,688$ -$ -$ -$ 224,688$ 217,500$ 103.3%217,500$ 197,675$ 27,013$
Greens Fees - 743,317 - - - 743,317 714,000 104.1%930,000 692,353 50,964
Pro Shop Sales - 126,700 - - - 126,700 164,500 77.0%207,000 155,876 (29,176)
Golf Lessons - - 44,405 - - 44,405 39,000 113.9%40,000 33,575 10,830
Driving Range Fees - - 204,971 - - 204,971 214,000 95.8%244,000 209,177 (4,206)
Rentals - 120 - 240,806 - 240,926 285,175 84.5%375,000 326,746 (85,820)
Food Sales 103,524 - - - - 103,524 103,745 99.8%144,500 107,696 (4,172)
Beverage Sales 236,375 - - - - 236,375 183,115 129.1%245,000 191,914 44,461
Other Revenue - 3,504 - - - 3,504 8,000 43.8%8,000 8,574 (5,070)
Total Operating Revenues 339,899$ 1,098,329$ 249,376$ 240,806$ -$ 1,928,410$ 1,929,035$ 100.0%2,411,000$ 1,923,586$ 4,824$
OPERATING EXPENDITURES
Personnel 111,982$ 331,285$ 22,967$ 30,316$ 325,473$ 822,023$ 853,450$ 96.3%1,263,665$ 867,907$ (45,884)$
Materials & Supplies 142,462 104,812 5,571 518 114,079 367,442 436,705 84.1%538,450 409,258 (41,816)
Operational & Contractual 4,737 112,508 121 44,003 33,751 195,120 204,625 95.4%287,725 227,040 (31,920)
Other - - - - - - - 0.0%(83,150) - -
Capital - 357,261 12,059 - 87,707 457,027 580,000 78.8%605,000 301,385 155,642
Total Operating Expenditures 259,181$ 905,866$ 40,718$ 74,837$ 561,010$ 1,841,612$ 2,074,780$ 88.8%2,611,690$ 1,805,590$ 36,022$
Operating Revenues Over (Under) Expenditures 80,718$ 192,463$ 208,658$ 165,969$ (561,010)$ 86,798$ (145,745)$ -59.6%(200,690)$ 117,996$ (31,198)$
INTERFUND TRANSACTIONS
Transfer from Golf Surcharge -$ 323,373$ -$ -$ 323,373$ 400,000$ 80.8%400,000$ 212,969$ 110,404$
Reimbursement to General Fund - (18,816) - - (18,816) (18,800) 100.1%(28,225) - (18,816)
Total Interfund Transactions -$ 304,557$ -$ -$ -$ 304,557$ 381,200$ 79.9%371,775$ 212,969$ 91,588$
Total Revenues Over (Under) Expenditures - Budgetary Basis 80,718$ 497,020$ 208,658$ 165,969$ (561,010)$ 391,355$ 235,455$ 171,085$ 330,965$ 60,390$
ADUSTMENTS TO GAAP BASIS*
Remove Capital Outlay -$ 357,261$ 12,059$ -$ 87,707$ 457,027$ 301,385$
Depreciation Expense - (90,000) (2,667) (15,333) (33,333) (141,333) (133,153)
IMRF Pension Expense (1,000) (3,333) (233) - (3,333) (7,900) 52,825
OPEB Expense (2,000) (15,333) - - (9,333) (26,667) (11,957)
Total GAAP Adjustments (3,000)$ 248,594$ 9,159$ (15,333)$ 41,707$ 281,127$ 209,101$
Fund Increase/(Decrease) - GAAP Basis 77,718$ 745,614$ 217,817$ 150,636$ (519,303)$ 672,482$ 540,066$
*Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.