07 - July 2020 Monthly Financial ReportVILLAGE
OAK BROOK
OF
MONTHLY FINANCIAL REPORTS
JULY 2020
Cash and Investments by Fund:Total
Cash and Cash Pooled Cash and
Fund Equivalents Investments Investments % By Fund
General Corporate $6,355,124 $14,906,607 $21,261,731 47.4%
Hotel/Motel Tax 2,359,121 2,458,710 4,817,831 10.7%
Motor Fuel Tax 704,693 59,199 763,892 1.7%
Infrastructure 7,183,169 1,993,410 9,176,579 20.5%
Promenade TIF 12,202 - 12,202 0.0%
Water 3,356,726 3,476,987 6,833,713 15.2%
Sports Core 194,939 - 194,939 0.4%
Golf Surcharge 80,818 - 80,818 0.2%
Self-Insurance 455,304 - 455,304 1.0%
Garage 313,994 - 313,994 0.7%
Equipment Replacement 523,340 396,498 919,838 2.1%
Total $21,539,430 $23,291,411 $44,830,841 100.0%
Change in Cash and Investments by Fund :
Balance at Balance at Year-to-Date Year-to-Date
Fund January 1, 2020 July 31, 2020 Change ($)Change (%)
General Corporate $21,270,239 $21,261,731 ($8,508)0.0%
Hotel/Motel Tax 5,427,474 4,817,831 (609,643)-11.2%
Motor Fuel Tax 1,085,595 763,892 (321,703)-29.6%
Infrastructure 8,217,724 9,176,579 958,855 11.7%
Promenade TIF 304,194 12,202 (291,992)-96.0%
Water 6,947,239 6,833,713 (113,526)-1.6%
Sports Core 231,216 194,939 (36,277)-15.7%
Golf Surcharge 347,066 80,818 (266,248)-76.7%
Self-Insurance 308,820 455,304 146,484 47.4%
Garage 275,988 313,994 38,006 13.8%
Equipment Replacement 808,879 919,838 110,959 13.7%
$45,224,434 $44,830,841 ($393,593)-0.9%
Book Bank/Market
Value Value
Cash and Cash Equivalents:
Pooled Checking $773,611 $1,746,892
Sports Core Checking 278,974 222,166
Pooled IPTIP 20,041,090 20,041,090
Water E-Pay IPTIP 445,755 424,825
$21,539,430 $22,434,973
Pooled Investments:
Investments-Municipal Bonds $6,000,140 $6,077,386
Investments-Corporate Bonds 8,807,268 8,937,951
Government & Agency Obligations 1,879,963 1,917,052
Certificates of Deposit 6,485,000 6,563,421
Accrued Interest 119,040 119,040
Total Pooled Investments $23,291,411 $23,614,850
Total Cash and Investments $44,830,841 $46,049,823
For July, total interest revenue is $46,620 and YTD is $428,009. The total investment yield for the portfolio is:
Pooled
Investments Illinois Funds Total
Last 12 months yield 2.22%1.46%1.86%
The weighted average yield of the current pooled investment portfolio is 2.17%. The IL Funds June average daily rate was 0.248%.
Monthly Treasurer's Report
July 31, 2020
Monthly Treasurer's Report
July 2020
The table below lists the detail investment holdings at J.P. Morgan Securities as of 7/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,504 203,036 1,161
Bloomingdale Mich Pub Sch Dist #094383FS0 04/26/16 05/01/22 2.710%2.150%504,739 511,995 3,349
Connecticut St GO Bds 2016 #20772J3F7 06/15/17 08/15/21 1.750%2.300%497,208 505,705 3,982
Wright County Min #982276BC0 07/18/19 12/01/20 2.000%2.000%545,000 546,695 2,331
State of IL #452152P54 10/09/19 11/01/21 5.000%1.870%519,344 517,790 5,999
Anchor Bay Mich Sch #032879TE8 11/01/19 05/01/21 2.320%1.750%718,044 725,754 4,009
Brownsville TX #16405ST9 12/19/19 02/15/22 2.050%2.000%555,410 566,028 5,088
Laredo TX Waterworks #517039VW0 12/19/19 03/01/24 2.230%2.230%455,000 474,761 4,171
Manchester NH #562333JE5 03/12/20 12/01/20 5.000%0.850%481,561 482,467 3,918
Oakland Univ Mich #673588HJ1 04/29/20 03/01/24 5.000%1.650%329,232 336,669 6,146
Philadelphia PA GO Ref #717813SW0 05/05/20 08/01/22 5.000%1.820%414,349 424,004 9,547
Maryland St DOT #574204WG4 05/06/20 06/15/22 4.350%1.200%275,191 278,288 1,329
University of CA #91412HFK4 07/16/20 05/15/23 0.628%0.628%25,000 25,066 6
Windsor NY Sch Dist #973675EW7 07/23/02 06/17/21 1.500%0.400%479,558 479,128 172
Total Municipal Bonds $6,000,140 $6,077,386 $51,208
Corporate Bonds:
Goldman Sachs #38141GVP9 09/26/18 09/15/20 2.750%3.180%499,758 500,370 5,156
Wells Fargo #94974BGR5 01/15/19 12/07/20 2.550%3.120%1,387,372 1,400,661 5,612
PNC Bank #69353RFH6 01/30/19 01/22/21 2.500%3.020%498,802 504,235 313
Morgan Stanley #61747WAL3 03/08/19 07/28/21 5.500%3.034%1,074,909 1,102,258 321
Citigroup #172967LC3 04/01/19 12/08/21 2.900%2.754%1,001,916 1,031,140 3,705
Bank of America #06051GFT1 04/03/19 10/19/20 2.625%2.625%700,000 703,472 4,951
Goldman Sachs #38143U8F1 05/02/19 02/25/21 2.875%2.707%365,331 369,417 4,520
American Honda #02665WBG5 07/31/19 09/09/21 1.700%2.180%497,407 506,760 3,376
BB&T Corp #05531FAZ6 08/15/19 02/01/21 2.150%2.010%750,551 755,498 7,866
JP Morgan #48128BAB7 09/30/19 01/15/23 2.972%2.337%1,015,038 1,035,720 1,321
JP Morgan #46625HRT9 01/30/20 06/07/21 2.400%1.648%503,150 507,890 1,800
American Express #025816CD9 05/05/20 05/20/22 2.750%1.290%513,034 520,530 2,569
Total Corporate Bonds $8,807,268 $8,937,951 $41,510
Government & Agency Obligations:
*Government National Mtg Assn #38379UEM4 02/29/16 02/16/51 2.300%2.245%$520,155 $515,203 $2,226
*Government National Mtg Assn #38381WV96 08/06/19 07/20/54 2.250%2.293%771,393 791,099 1,359
*Government National Mtg Assn #38380BNV3 12/05/19 06/20/46 2.000%2.112%588,415 610,750 921
Total Government & Agency Obligations:$1,879,963 $1,917,052 $4,506
Certificates of Deposit:
State Bk India NY #8562846A7 01/26/17 01/26/22 2.250%2.250%$245,000 $252,688 $85
American Express Centurion #02587DV96 08/15/17 08/17/20 1.900%1.900%245,000 245,211 2,115
Sallie Mae #795450C86 08/16/17 08/17/20 1.900%1.900%245,000 245,211 2,115
Merrick Bank South Jordan #59013JZS1 08/21/17 08/21/20 1.800%1.800%245,000 245,245 117
Pinnacle Bank #72345SFS5 08/30/17 08/31/20 1.800%1.800%115,000 115,170 3
Jackson County Bank #466682AP6 08/31/17 03/01/21 1.850%1.850%245,000 247,514 1,895
Barclays Bank #06740KKX4 09/27/17 09/28/20 1.950%1.950%245,000 245,747 1,639
Goldman Sachs Bank #38148PRK5 10/18/17 10/19/20 1.950%1.950%245,000 246,014 1,347
FirstBank PR Santurce #33767A6M8 11/03/17 11/03/20 2.000%2.000%245,000 246,210 358
Compass Bank #20451PVW3 10/26/18 10/26/20 3.000%3.000%245,000 246,725 1,909
UBS Bank #90348JFH8 10/30/18 10/29/20 3.050%3.050%245,000 246,815 29
Discover Bank #254673WF9 11/07/18 11/09/20 3.000%3.000%245,000 247,002 1,705
Ally Bank #02007GFX6 11/08/18 11/09/20 3.000%3.000%245,000 247,002 1,684
Comenity Cap Bank #20033AU46 04/15/19 04/15/21 2.500%2.500%245,000 249,133 242
Morgan Stanley #61760AE21 05/30/19 06/01/21 2.400%2.400%245,000 249,692 964
First St Bank DeQueen #336460CU2 07/18/19 07/19/21 2.000%2.000%245,000 249,444 191
Bank Hapoalim #06251AW89 07/19/19 07/19/21 2.000%2.000%245,000 249,721 228
Capital One Natl Assn #14042RMF5 07/24/19 07/26/19 2.050%2.050%245,000 249,689 195
TIAA FSB Jacksonville #87270LCN1 07/29/19 07/29/21 2.000%2.000%245,000 249,606 27
Wells Fargo #949763J31 09/18/19 09/20/21 1.850%1.850%245,000 249,780 191
BMW Bank #05580ASQ8 10/11/19 10/12/21 1.800%1.800%245,000 249,893 1,280
Wells Fargo #949495AN5 01/17/20 01/18/22 1.800%1.800%245,000 250,921 190
Southpoint Bank #84464PBK2 02/28/20 02/28/22 1.600%1.600%245,000 245,289 12
Bank Leumi #063248KQ0 03/31/20 03/31/22 1.250%1.250%245,000 249,469 1,021
Capital One Natl Assn #14042TCZ8 04/01/20 04/01/22 1.350%1.350%245,000 249,871 1,093
Synchrony Bank #87164WZN1 04/03/20 04/04/22 1.350%1.350%245,000 249,893 1,075
Wells Fargo #95001DAB6 06/17/20 06/17/23 1.200%1.200%245,000 244,466 106
Total Certificates of Deposits $6,485,000 $6,563,421 $21,816
Total J.P.Morgan Securities $23,172,371 $23,495,810 $119,040
*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
July 31, 2020
Cash & Investments by Fund - Total $44.8 million
Cash & Investments by Type - Total $44.8 million
Checking
Illinois Funds
Certificates of Deposit
Municipal Bonds
Corporate Bonds
Government & Agency Obligations
Accrued Interest
General Corporate
47.4%
Hotel/Motel Tax
10.7%Motor Fuel Tax
1.7%
Infrastructure
20.5%
Promenade TIF
0.0%
Water
15.2%
Sports Core
0.4%
Golf Surcharge
0.2%
Self-Insurance
1.0%Garage
0.7%
Equipment
Replacement
2.1%
Checking, $1.0
Illinois Funds, $20.5
Certificates of Deposit,
$6.5
Municipal Bonds, $6.0
Corporate Bonds, $8.8
Government & Agency
Obligations, $1.9
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)13,666,143$ 13,838,593$ (172,450)$ (117,145)$
Main operating fund of the Village.
Hotel Fund (Major Fund)382,171$ 495,760$ (113,589)$ (56,105)$
Collects and spends resources from the
3% hotel/motel tax.
Motor Fuel Tax Fund 349,746$ 666,289$ (316,543)$ 184,155$
Collects and spends resources from the
State motor fuel tax.
Infrastructure Fund (Major Fund)3,956,892$ 2,543,757$ 1,413,135$ (4,493,610)$
Accounts for construction and maintenance of
roadways, drainage, and safety path systems.
Promenade TIF Fund (Major Fund)241,573$ 533,565$ (291,992)$ (270,115)$
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,192,267$ 4,223,850$ 968,417$ (1,541,400)$
Collects user fees for the distribution of water
and maintenance of infrastructure.
Sports Core Fund (Major Fund)2,168,132$ 2,076,939$ 91,193$ (83,045)$
Accounts for revenues and expenses relating
to administration, programs, food and beverage
operations, and golf course.
Golf Surcharge Fund 57,126$ 323,373$ (266,247)$ (336,530)$
Accounts for the collection of the $3 per round
golf surcharge.
Internal Service Funds
Self Insurance Fund 2,042,587$ 1,662,742$ 379,845$ (12,875)$
Accounts for the Village's health insurance costs
and the related contributions from the Village,
employees, retirees, and other agencies.
Garage Fund 428,874$ 394,610$ 34,264$ (17,920)$
Accounts for the maintenance of the Village's vehicle
fleet and the related departmental reimbursements.
Equipment Replacement Fund 193,505$ 82,545$ 110,960$ 66,680$
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 July 31, 2020
Village of Oak Brook
Monthly Financial Report – Fund Narrative
For the Period Ending July 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 July 2020 are $1,770,372, or 11.7%, lower than last July and $1,801,345,
or 11.9%, under budget to date. The main drivers for this are:
o Sales tax revenue, the General
Fund’s largest revenue source, is
down $447,476 from last year
and $402,938 under budget.
July 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 Other intergovernmental tax revenue is down $44,590 from last year and $9,028 under
budget. The Village has experienced a decrease in Income Tax and Replacement Tax
receipts to date due to the COVID-19 pandemic. The decrease is offset by increases in
Use Tax payments, which are up approximately 15.9% compared to last year.
o Licenses and permits revenue is down $678,271 from last year and $784,337 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 Restoration Hardware and the
Hines Oak Brook Commons kicking off shortly.
o Charges for Services revenue is down $402,217 from last year and $323,877 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 July 2020 are $176,780, or 1.3%, higher than last year, but
$1,309,675, or 8.9%, under budget to date. The main drivers for this are:
o Personnel expenditures are up $1,250,261 from last year, but $274,154 under budget.
The increase is due to a combination of annual pay increases, final accrual payouts from
three retirements, and one additional payroll compared to 2019. 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 $538,289 from last year and $495,750
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 $526,659 from last year and $450,673 under
budget. Many capital items have been put on hold for 2020 due to the current
economic state.
Hotel Tax Fund
Total revenues through July 2020 are $327,522, or 46.1%, lower than last year and $314,379, or
45.1%, under budget. The main drivers for this are:
o Hotel tax revenue is down $311,323 from last year and $321,623 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 July 2020 are $101,539, or 29.0%, higher than last year, but
$124,577, or 21.6%, under budget. The main drivers for this are:
o Operation and contract expenditures are down $115,427 from last year and $211,148
under budget. This is due to the timing of advertising payments and the cancelling of
some campaigns. In addition, the Village rebated $69,348 of hotel tax related to
January, February, and March stays back to the hotels.
o Capital Outlay expenditures are up $216,966 from last year and $86,571 over budget.
The street light replacements began earlier than originally projected.
Infrastructure Fund
Total revenues through July 2020 are down $374,784, or 10.8%, from last year and $273,503, or
8.2%, under budget. The main drivers for this are:
o Non-home rule sales tax revenue
is down $299,693 from last year
and $262,230 under budget.
July 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
$75,426 from last year and $9,543 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 July 2020 are down $491,961 or 16.7%, from last year and
$5,646,298, or 69.7%, under budget to date. The main drivers for this are:
o Operation and contract expenditures are down $113,949 from last year and $308,294
under budget. Expenditures are under budget due to the timing of engineering
payments. Some projects have been delayed due to the current pandemic.
o Capital Outlay expenditures are down $428,925 from last year and $5,322,795 under
budget. Payments for ongoing projects have not occurred to date and will be delayed
until later in the year or 2021.
Promenade TIF Fund
Total revenues through July 2020 are down $5,123, or 2.1% from last year, but $3,198, or 1.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 July 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 July 2020 are down $237,568, or 4.4%, from last year and $469,203, or
8.3%, under budget. The main drivers for this are:
o Water sales revenue is down $70,895 from last year and $414,172 under budget. The
decrease in water sales relates to the business shut down from the COVID-19 pandemic.
o Water connection fees are down $129,930 from last year and $50,505 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 July 2020 are down $175,014, or 4.3%, from last year and
$2,979,027, or 43.2%, under budget. The main drivers for this are:
o Operation and contract expenditures are down $157,471 from last year and $1,287,097
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 $24,001 from last year and $1,606,073 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 July 2020 are down $601,380, or 28.6%, from last year and $885,099, or
37.1%, 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 $191,527 from last year and $232,748 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 $30,713 from last year and
$9,288 over budget to date.
o Greens Fees are down $18,854 from last year and $40,851 under budget. This is due to
the golf course being closed and limited in the spring due to the COVID-19 pandemic.
o Rental income is down $232,605 from last year and $189,171 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 July 2020 are down $673,748, or 24.8%, from last year and
$1,607,364, or 44.0%, under budget to date. The main drivers for this are:
o Personnel expenditures are down $110,045 from last year and $182,135 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 $142,683 from last year and $184,398
under budget. Expenditures are down due to facilities being closed for much of the
spring.
o Operation and Contractual expenditures are down $473,937 from last year and
$437,159 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 $52,917 from last year, but $803,672 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.
7/31/20 7/31/20
7/31/19 7/31/20 YTD % of YTD 2020 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 7,306,038$ 6,858,562$ 7,261,500$ 94.5%12,502,000$ (447,476)$
Other Intergovernmental Tax*944,662 900,072 909,100 99.0%1,352,000 (44,590)
Telecommunications/Utility Tax 3,720,247 3,526,412 3,683,000 95.7%6,125,000 (193,835)
Licenses and Permits 1,687,864 1,009,593 1,793,930 56.3%2,990,190 (678,271)
Charges for Services 801,855 399,638 723,515 55.2%1,253,100 (402,217)
Fines and Penalties 140,353 93,855 112,000 83.8%192,000 (46,498)
Administrative Towing Fees 13,004 9,664 11,655 82.9%20,000 (3,340)
Investment Interest 267,359 233,000 242,095 96.2%415,000 (34,359)
Franchise Fees 58,453 55,794 105,000 53.1%210,000 (2,659)
Miscellaneous Income 131,287 214,160 260,300 82.3%443,095 82,873
Total Operating Revenues 15,071,122$ 13,300,750$ 15,102,095$ 88.1%25,502,385$ (1,770,372)$
OPERATING EXPENDITURES
Personnel 9,819,620$ 11,069,881$ 11,344,035$ 97.6%19,160,220$ 1,250,261$
Materials and Supplies 255,124 249,553 337,255 74.0%539,170 (5,571)
Operation and Contract 2,543,664 2,005,375 2,501,125 80.2%4,071,660 (538,289)
Other Expenditures 7,336 4,374 5,770 75.8%10,000 (2,962)
Capital Outlay 628,171 101,512 552,185 18.4%688,030 (526,659)
Total Operating Expenditures 13,253,915$ 13,430,695$ 14,740,370$ 91.1%24,469,080$ 176,780$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 1,817,207$ (129,945)$ 361,725$ 1,033,305$ (1,947,152)$
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 368,788 365,393 365,400 100.0%626,395 (3,395)
Reimbursements To Other Funds (76,475) (81,529) (81,515) 100.0%(139,770) (5,054)
Total Interfund Transactions 466,345$ (42,505)$ (478,870)$ 8.9%(436,375)$ (508,850)$
NET FUND INCREASE (DECREASE)2,283,552$ (172,450)$ (117,145)$ 596,930$ (2,456,002)$
*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 July 31, 2020
Total Total
Revenues Expenditures
7/31/20 Actual 13,300,750$ 13,430,695$
7/31/19 Actual 15,071,122$ 13,253,915$
% Change From Last Year -11.7%1.3%
Major Revenues
Other Telecom/Utility Licenses &Charges for
Sales Tax Intergov. Tax Tax Permits Services
7/31/20 Actual 6,858,562$ 900,072$ 3,526,412$ 1,009,593$ 399,638$
7/31/19 Actual $ 7,306,038 $ 944,662 $ 3,720,247 $ 1,687,864 $ 801,855
% Change From Last Year -6.1%-4.7%-5.2%-40.2%-50.2%
Five Year Trend
Major Expenditures Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
7/31/20 Actual 11,069,881$ 249,553$ 2,005,375$ 4,374$ 101,512$
7/31/19 Actual 9,819,620$ 255,124$ 2,543,664$ 7,336$ 628,171$
% Change From Last Year 12.7%-2.2%-21.2%-40.4%-83.8%
Five Year Trend
Expenditures by Department
7/31/19 7/31/20 7/31/20 7/31/20 2020 Difference Five
YTD YTD YTD % of Annual Prior Year
Department Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 1,326,906$ 1,159,693$ 1,527,115$ 75.9%2,556,835$ (167,213)$
Financial Services 432,941 456,454 475,750 95.9%781,455 23,513
Public Works 497,421 417,462 528,195 79.0%893,055 (79,959)
Engineering & Capital Projects 291,125 31,899 360,750 8.8%411,500 (259,226)
Library 531,403 480,746 600,475 80.1%994,410 (50,657)
Police 5,057,644 5,466,115 5,669,275 96.4%9,493,905 408,471
Fire 4,572,874 4,833,768 4,969,025 97.3%8,298,370 260,894
Development Services 543,601 584,558 609,785 95.9%1,039,550 40,957
Total Expenditures 13,253,915$ 13,430,695$ 14,740,370$ 91.1%24,469,080$ 176,780$
Five Year Trend
For the Period Ending July 31, 2020
General Fund - Five Year Trend
Village of Oak Brook
Revenues Expenditures
7/31/20 7/31/20
7/31/19 7/31/20 YTD % of YTD 2020 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Hotel Tax 642,500$ 331,177$ 652,800$ 50.7%1,212,500$ (311,323)$
Investment Interest 67,193 46,827 43,750 107.0%75,000 (20,366)
Loan Interest - 4,167 - N/A - 4,167
Total Operating Revenues 709,693$ 382,171$ 696,550$ 54.9%1,287,500$ (327,522)$
EXPENDITURES
Operation and Contract 350,639$ 235,212$ 446,360$ 52.7%576,615$ (115,427)$
Capital Outlay - 216,966 130,395 166.4%640,395 216,966
Total Expenditures 350,639$ 452,178$ 576,755$ 78.4%1,217,010$ 101,539$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 359,054$ (70,007)$ 119,795$ -58.4%70,490$ (429,061)$
INTERFUND TRANSACTIONS
Transfer Out -$ -$ (132,325)$ 0.0%(338,125)$ -$
Reimbursements to Other Funds (60,151) (43,582) (43,575) 100.0%(74,715) 16,569
Total Interfund Transactions (60,151)$ (43,582)$ (175,900)$ 24.8%(412,840)$ 16,569$
NET FUND INCREASE (DECREASE)298,903$ (113,589)$ (56,105)$ (342,350)$ (412,492)$
Note - Expenditures are recorded in program 171.
Village of Oak Brook
Hotel Tax Fund Financial Update
For the Period Ending July 31, 2020
Total Total
Revenues Expenditures
7/31/20 Actual $ 382,171 452,178$
7/31/19 Actual $ 709,693 350,639$
% Change From Last Year -46.1%29.0%
Major Revenues Investment
Hotel Tax Interest Loan Interest Miscellaneous
7/31/20 Actual $ 331,177 $ 46,827 4,167$ -$
7/31/19 Actual $ 642,500 $ 67,193 -$ -$
% Change From Last Year -48.5%-30.3%N/A 0.0%
Five Year Trend
Major Expenditures Operation &
Contractual Capital Outlay
7/31/20 Actual 235,212$ 216,966$
7/31/19 Actual 350,639$ -$
% Change From Last Year -32.9%N/A
Five Year Trend
Village of Oak Brook
Hotel Tax Fund - Major Sources Five Year Trend
For the Period Ending July 31, 2020
Five Year Trend
Revenues Expenditures
7/31/20 7/31/20
7/31/19 7/31/20 YTD % of YTD 2020 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 3,316,963$ 3,017,270$ 3,279,500$ 92.0%5,615,000$ (299,693)$
Charges for Services - 335 595 56.3%1,000 335
Investment Interest 138,788 63,362 72,905 86.9%125,000 (75,426)
Miscellaneous - - 1,470 0.0%2,500 -
Total Operating Revenues 3,455,751$ 3,080,967$ 3,354,470$ 91.8%5,743,500$ (374,784)$
OPERATING EXPENDITURES
Personnel 755,826$ 786,308$ 818,815$ 96.0%1,389,540$ 30,482$
Materials and Supplies 102,372 122,803 105,505 116.4%253,295 20,431
Operation and Contract 900,745 786,796 1,095,090 71.8%1,856,790 (113,949)
Capital Outlay 1,182,100 753,175 6,075,970 12.4%10,220,090 (428,925)
Total Operating Expenditures 2,941,043$ 2,449,082$ 8,095,380$ 30.3%13,719,715$ (491,961)$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 514,708$ 631,885$ (4,740,910)$ -13.3%(7,976,215)$ 117,177$
INTERFUND TRANSACTIONS
Transfers In 216,125$ 666,289$ 132,325$ 503.5%1,653,125$ 450,164$
Reimbursements From Other Funds 194,509 209,636 209,650 100.0%359,380 15,127
Reimbursements To Other Funds (94,227) (94,675) (94,675) 100.0%(162,300) (448)
Total Interfund Transactions 316,407$ 781,250$ 247,300$ 315.9%1,850,205$ 464,843$
NET FUND INCREASE (DECREASE)831,115$ 1,413,135$ (4,493,610)$ (6,126,010)$ 582,020$
Village of Oak Brook
Infrastructure Fund Financial Update
For the Period Ending July 31, 2020
Total Total
Revenues Expenditures
7/31/20 Actual $ 3,080,967 2,449,082$
7/31/19 Actual $ 3,455,751 2,941,043$
% Change From Last Year -10.8%-16.7%
Major Revenues
Sales Tax
Charges for
Services
Investment
Interest Miscellaneous
7/31/20 Actual $ 3,017,270 $ 335 $ 63,362 $ -
7/31/19 Actual $ 3,316,963 $ - $ 138,788 $ -
% Change From Last Year -9.0%N/A -54.3%0.0%
Five Year Trend
Major Expenditures Materials &Operation &
Personnel Supplies Contractual Capital Outlay
7/31/20 Actual 786,308$ 122,803$ 786,796$ 753,175$
7/31/19 Actual 755,826$ 102,372$ 900,745$ 1,182,100$
% Change From Last Year 4.0%20.0%-12.7%-36.3%
Five Year Trend
Expenditures by Department
7/31/19 7/31/20 7/31/20 7/31/20 2020 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 95,936$ 77,881$ 102,600$ 75.9%176,490$ (18,055)$
Public Works 1,231,680 1,280,944 3,340,520 38.3%4,390,810 49,264
Engineering & Capital Projects 1,613,427 1,090,257 4,652,260 23.4%9,152,415 (523,170)
Total Expenditures 2,941,043$ 2,449,082$ 8,095,380$ 30.3%13,719,715$ (491,961)$
Five Year Trend
Village of Oak Brook
Infrastructure Fund - Major Sources Five Year Trend
For the Period Ending July 31, 2020
Revenues Expenditures
7/31/20 7/31/20
7/31/19 7/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$ 33,825$ 47,500$ 71.2%95,000$ (5,995)$
Real Estate Tax 205,855 207,272 190,000 109.1%380,000 1,417
Investment Interest 1,021 476 875 54.4%1,500 (545)
Total Operating Revenues 246,696$ 241,573$ 238,375$ 101.3%476,500$ (5,123)$
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,757)$ (291,992)$ (270,115)$ (32,290)$ (74,235)$
Note - Expenditures are recorded in program 283.
Village of Oak Brook
Promenade TIF Fund Financial Update
For the Period Ending July 31, 2020
Total Total
Revenues Expenditures
7/31/20 Actual $ 241,573 533,565$
7/31/19 Actual $ 246,696 464,453$
% Change From Last Year -2.1%14.9%
Major Revenues Real Estate Investment
Sales Tax Tax Interest
7/31/20 Actual 33,825$ $ 207,272 $ 476
7/31/19 Actual 39,820$ $ 205,855 $ 1,021
% Change From Last Year -15.1%0.7%-53.4%
Five Year Trend
Major Expenditures Operation &Other
Contractual Expenditures
7/31/20 Actual 3,665$ 529,900$
7/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 July 31, 2020
Five Year Trend
Revenues Expenditures
7/31/20 7/31/20
7/31/19 7/31/20 YTD % of YTD 2020 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Plan Review Fees 825$ 300$ 700$ 42.9%1,200$ (525)$
Building/Inspection Fees 2,625 5,062 4,655 108.7%8,000 2,437
Water Sales 5,090,723 5,019,828 5,434,000 92.4%10,302,525 (70,895)
Unmetered Sales 28,554 55,744 17,500 318.5%30,000 27,190
Water Connection Fees 137,770 7,840 58,345 13.4%100,000 (129,930)
Meter Charges 10,767 5,152 11,675 44.1%20,000 (5,615)
Special Services 16,772 12,657 15,000 84.4%30,000 (4,115)
Investment Interest 105,493 65,000 75,845 85.7%130,000 (40,493)
Miscellaneous 36,306 20,684 43,750 47.3%75,000 (15,622)
Total Operating Revenues 5,429,835$ 5,192,267$ 5,661,470$ 91.7%10,696,725$ (237,568)$
OPERATING EXPENDITURES
Personnel 443,905$ 457,164$ 511,645$ 89.4%868,705$ 13,259$
Materials and Supplies 20,410 13,609 44,985 30.3%74,260 (6,801)
Operation and Contract 2,277,649 2,120,178 3,407,275 62.2%5,833,755 (157,471)
Capital Outlay 1,349,593 1,325,592 2,931,665 45.2%6,293,225 (24,001)
Total Expenditures 4,091,557$ 3,916,543$ 6,895,570$ 56.8%13,069,945$ (175,014)$
Surplus (Deficit) of Revenues Over
Expenditures 1,338,278$ 1,275,724$ (1,234,100)$ -103.4%(2,373,220)$ (62,554)$
INTERFUND TRANSACTIONS
Transfers In 221,085$ -$ -$ 0.0%-$ (221,085)
Reimbursements To Other Funds (321,902) (307,307) (307,300) 100.0%(526,815) 14,595
Total Interfund Transactions (100,817)$ (307,307)$ (307,300)$ 100.0%(526,815)$ (206,490)$
Fund Increase/(Decrease) - Budgetary Basis 1,237,461$ 968,417$ (1,541,400)$ -62.8%(2,900,035)$ (269,044)$
ADUSTMENTS TO GAAP BASIS*
Remove Capital Outlay 1,349,593$ 1,325,592$
Depreciation Expense (298,728) (335,417)
IMRF Pension Expense 45,054 29,167
OPEB Expense (28,598) (26,250)
Total GAAP Adjustments 1,067,322$ 993,092$
Fund Increase/(Decrease) - GAAP Basis 2,304,783$ 1,961,509$
*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 July 31, 2020
Total Total
Revenues Expenditures
7/31/20 Actual $ 5,192,267 3,916,543$
7/31/19 Actual $ 5,429,835 4,091,557$
% Change From Last Year -4.4%-4.3%
Unmetered Water
Water Sales Sales Connection Fees Meter Charges Miscellaneous
7/31/20 Actual $ 5,019,828 $ 55,744 $ 7,840 $ 5,152 $ 20,684
7/31/19 Actual $ 5,090,723 $ 28,554 $ 137,770 $ 10,767 $ 36,306
% Change From Last Year -1.4%95.2%-94.3%-52.2%-43.0%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
7/31/20 Actual 457,164$ 13,609$ 2,120,178$ -$ 1,325,592$
7/31/19 Actual 443,905$ 20,410$ 2,277,649$ -$ 1,349,593$
% Change From Last Year 3.0%-33.3%-6.9%0.0%-1.8%
Five Year Trend
Expenditures by Department
7/31/19 7/31/20 7/31/20 7/31/20 2020 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Public Works 2,736,131$ 2,599,725$ 3,818,315$ 68.1%6,527,120$ (136,406)$
Engineering & Capital Projects 1,355,426 1,316,818 3,077,255 42.8%6,542,825 (38,608)
Total Expenditures 4,091,557$ 3,916,543$ 6,895,570$ 56.8%13,069,945$ (175,014)$
Five Year Trend
Village of Oak Brook
Water Fund - Major Sources Five Year Trend
For the Period Ending July 31, 2020
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Sports Core Fund Consolidated Presentation
For the Period Ending July 31, 2020
7/31/20 7/31/20
7/31/20 YTD % of YTD 2020 7/31/19 Difference
B&T Recreation Field Clubhouse Golf YTD Amended Amended Adopted YTD Prior
Operations Operations Operations Club Total Budget Budget Budget Total Year
OPERATING REVENUES
Memberships 199$ -$ -$ 226,788$ 226,987$ 459,735$ 49.4%459,135$ 418,514$ (191,527)$
Greens Fees - - - 496,149 496,149 537,000 92.4%930,000 515,003 (18,854)
Pro Shop Sales - - - 91,431 91,431 131,500 69.5%207,000 122,534 (31,103)
Golf Lessons - - - 43,325 43,325 33,500 129.3%40,000 31,305 12,020
Driving Range Fees - - - 159,665 159,665 186,000 85.8%244,000 181,451 (21,786)
Rentals - 92,540 14,223 159,306 266,069 455,240 58.4%962,000 498,674 (232,605)
Programs/User Fees - - - - - 45,550 0.0%66,300 52,500 (52,500)
Food Sales - - - 65,595 65,595 110,185 59.5%180,500 108,467 (42,872)
Beverage Sales - - - 147,182 147,182 154,740 95.1%265,000 158,950 (11,768)
Taste of Oak Brook - - - - - 120,000 0.0%120,000 - -
Grants - - - - - 139,800 0.0%139,800 - -
Other Revenue 312 - - 3,006 3,318 11,570 28.7%11,000 13,703 (10,385)
Total Operating Revenues 511$ 92,540$ 14,223$ 1,392,447$ 1,499,721$ 2,384,820$ 62.9%3,624,735$ 2,101,101$ (601,380)$
OPERATING EXPENDITURES
Personnel 2,680$ -$ 63,814$ 681,631$ 748,125$ 930,260$ 80.4%1,578,100$ 858,170$ (110,045)$
Materials & Supplies 2,149 119 1,540 235,794 239,602 424,000 56.5%618,025 382,285 (142,683)
Operational & Contractual 34,612 27,829 36,152 164,863 263,456 700,615 37.6%1,055,095 737,393 (473,937)
Other - - - - - - 0.0%(83,150) - -
Capital 348,670 8,710 - 435,448 792,828 1,596,500 49.7%1,921,545 739,911 52,917
Total Operating Expenditures 388,111$ 36,658$ 101,506$ 1,517,736$ 2,044,011$ 3,651,375$ 56.0%5,089,615$ 2,717,759$ (673,748)$
B&T Administration Overhead Allocation*33,754$ -$ (33,754)$ -$ -$ -$ 0.0%-$ -$ -$
Operating Revenues Over (Under) Expenditures (353,846)$ 55,882$ (121,037)$ (125,289)$ (544,290)$ (1,266,555)$ 43.0%(1,464,880)$ (616,658)$ 72,368$
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 14,000 - - - 14,000 14,000 100.0%24,000 14,000 -
Reimbursement From Water Fund 4,669 - - - 4,669 4,655 100.3%8,000 4,669 -
Reimbursement To General Fund (16,464) - - (16,464) (32,928) (32,900) 100.1%(56,450) - (32,928)
Total Interfund Transactions 328,574$ -$ -$ 306,909$ 635,483$ 1,183,510$ 53.7%1,333,550$ 565,841$ 69,642$
Total Revenues Over (Under) Expenditures - Budgetary Basis (25,272)$ 55,882$ (121,037)$ 181,620$ 91,193$ (83,045)$ (131,330)$ (50,817)$ 142,010$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay 348,670$ 8,710$ -$ 435,448$ 792,828$ 739,911$
Depreciation Expense (87,443) (983) (20,417) (123,667) (232,510) (191,560)
IMRF Pension Expense (3,063) (146) (1,167) (6,913) (11,288) 54,116
OPEB Expense - - (3,033) (23,333) (26,367) (11,687)
Total GAAP Adjustments 258,164$ 7,581$ (24,617)$ 281,536$ 522,664$ 590,780$
Fund Increase/(Decrease) - GAAP Basis 232,892$ 63,463$ (145,654)$ 463,156$ 613,857$ 539,963$
*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
7/31/20 Actual $ 1,499,721 2,044,011$
7/31/19 Actual $ 2,101,101 2,717,759$
% Change From Last Year -28.6%-24.8%
Driving Program/
Memberships Greens Fees Range Fees Rentals User Fees
7/31/20 Actual $ 226,987 $ 496,149 $ 159,665 $ 266,069 -$
7/31/19 Actual $ 418,514 $ 515,003 $ 181,451 $ 498,674 52,500$
% Change From Last Year -45.8%-3.7%-12.0%-46.6%-100.0%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
7/31/20 Actual 748,125$ 239,602$ 263,456$ -$ 792,828$
7/31/19 Actual 858,170$ 382,285$ 737,393$ -$ 739,911$
% Change From Last Year -12.8%-37.3%-64.3%0.0%7.2%
Five Year Trend
Revenues by Department 7/31/19 7/31/20 7/31/20 7/31/20 2020 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Operations 324,640$ 511$ 474,155$ 0.1%506,735$ (281,491)$
Open Field Operations 83,070 92,540 240,065 38.5%407,000 9,470
B&T Clubhouse Operations 154,736 14,223 117,500 12.1%300,000 (140,513)
Golf Club 1,538,655 1,392,447 1,553,100 89.7%2,411,000 (146,208)
Total Revenues 2,101,101$ 1,499,721$ 2,384,820$ 62.9%3,624,735$ (558,742)$
Expenditures by Department 7/31/19 7/31/20 7/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 572,428$ 388,111$ 1,351,860$ 28.7%1,752,045$ (184,317)$
Open Field Operations 140,344$ 36,658$ 108,630$ 33.7%267,110$ (103,686)$
B&T Clubhouse Operations 495,173 101,506 355,930 28.5%458,770 (393,667)
Golf Club 1,509,814 1,517,736 1,834,955 82.7%2,611,690 7,922
Total Expenditures 2,717,759$ 2,044,011$ 3,651,375$ 56.0%5,089,615$ (673,748)$
Five Year Trend
Village of Oak Brook
Sports Core Fund - Major Sources Five Year Trend
For the Period Ending July 31, 2020
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Bath & Tennis Club Recreation Operations
For the Period Ending July 31, 2020 7/31/20 7/31/20
822 7/31/20 YTD % of YTD 2020 7/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$ 242,235$ 0.1%241,635$ 222,439$ (222,240)$
Programs/User Fees - - - - - 45,550 0.0%66,300 52,500 (52,500)
Food Sales - - - - - 28,000 0.0%36,000 27,327 -
Beverage Sales - - - - - 15,000 0.0%20,000 15,311 -
Grants - - - - - 139,800 0.0%139,800 - -
Other Revenue 312 - - - 312 3,570 8.7%3,000 7,063 (6,751)
Total Operating Revenues 312$ 199$ -$ -$ 511$ 474,155$ 0.1%506,735$ 324,640$ (281,491)$
OPERATING EXPENDITURES
Personnel 2,680$ -$ -$ -$ 2,680$ 121,000$ 2.2%163,580$ 102,279$ (99,599)$
Materials & Supplies 327 787 1,035 - 2,149 54,000 4.0%57,650 41,910 (39,761)
Operational & Contractual 26,141 3,760 4,711 - 34,612 364,360 9.5%418,270 356,620 (322,008)
Capital 22,207 326,369 94 - 348,670 812,500 42.9%1,112,545 71,619 277,051
Total Operating Expenditures 51,355$ 330,916$ 5,840$ -$ 388,111$ 1,351,860$ 28.7%1,752,045$ 572,428$ (184,317)$
B&T Administration Overhead Allocation*67,508$ (24,303)$ (6,751)$ (2,700)$ 33,754$ 74,370$ 45.4%93,235$ 68,770$ (35,016)$
Operating Revenues Over (Under) Expenditures 16,465$ (355,020)$ (12,591)$ (2,700)$ (353,846)$ (803,335)$ 44.0%(1,152,075)$ (179,018)$ (132,190)$
INTERFUND TRANSACTIONS
Transfer From General Fund -$ 326,369$ -$ -$ 326,369$ 597,255$ 54.6%757,500$ 48,704$ 277,665$
Reimbursement From Infrastructure Fund 14,000 - - - 14,000 14,000 100.0%24,000 14,000 -
Reimbursement From Water Fund 4,669 - - - 4,669 4,655 100.3%8,000 4,669 -
Reimbursement To General Fund (16,464) - - - (16,464) (16,450) 100.1%(28,225) - (16,464)
Total Interfund Transactions 2,205$ 326,369$ -$ -$ 328,574$ 599,460$ 54.8%761,275$ 67,373$ 261,201$
Total Revenues Over (Under) Expenditures - Budgetary Basis 18,670$ (28,651)$ (12,591)$ (2,700)$ (25,272)$ (203,875)$ (390,800)$ (111,645)$ 129,011$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay 22,207$ 326,369$ 94$ -$ 348,670$ 71,619$
Depreciation Expense - (83,845) (2,917) (681) (87,443) (55,314)
IMRF Pension Expense (2,917) - - (146) (3,063) 3,558
Total GAAP Adjustments 19,290$ 242,524$ (2,823)$ (827)$ 258,164$ 19,863$
Fund Increase/(Decrease) - GAAP Basis 37,960$ 213,873$ (15,414)$ (3,527)$ 232,892$ (91,782)$
*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 July 31, 2020 7/31/20 7/31/20
7/31/20 YTD % of YTD 2020 7/31/19 Difference
815 816 YTD Amended Amended Adopted YTD Prior
Polo Open Fields Total Budget Budget Budget Total Year
OPERATING REVENUES
Field Rentals -$ 17,540$ 17,540$ 120,065$ 14.6%212,000$ 83,070$ (65,530)$
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 -$ 92,540$ 92,540$ 240,065$ 38.5%407,000$ 83,070$ 9,470$
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 10,000 17,829 27,829 86,625 32.1%239,600 131,947 (104,118)
Capital - 8,710 8,710 15,000 58.1%15,000 4,435 4,275
Total Operating Expenditures 10,000$ 26,658$ 36,658$ 108,630$ 33.7%267,110$ 140,344$ (103,686)$
Operating Revenues Over (Under) Expenditures (10,000)$ 65,882$ 55,882$ 131,435$ 42.5%139,890$ (57,274)$ 113,156$
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 (10,000)$ 65,882$ 55,882$ 166,435$ 174,890$ (57,274)$ 113,156$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay -$ 8,710$ 8,710$ 4,435$
Depreciation Expense - (983) (983) (983)
IMRF Pension Expense - (146) (146) 429
Total GAAP Adjustments -$ 7,581$ 7,581$ 3,881$
Fund Increase/(Decrease) - GAAP Basis (10,000)$ 73,463$ 63,463$ (53,393)$
*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 July 31, 2020
7/31/20 7/31/20
821 YTD % of YTD 2020 7/31/19 Difference
B&T Amended Amended Adopted YTD Prior
Clubhouse Budget Budget Budget Total Year
OPERATING REVENUES
Rentals 14,223$ 117,500$ 12.1%300,000$ 154,736$ (140,513)$
Total Operating Revenues 14,223$ 117,500$ 12.1%300,000$ 154,736$ (140,513)$
OPERATING EXPENDITURES
Personnel 63,814$ 80,370$ 79.4%140,045$ 71,915$ (8,101)$
Materials & Supplies 1,540 11,770 13.1%20,225 8,160 (6,620)
Operational & Contractual 36,152 74,790 48.3%109,500 51,794 (15,642)
Capital - 189,000 0.0%189,000 363,304 (363,304)
Total Operating Expenditures 101,506$ 355,930$ 28.5%458,770$ 495,173$ (393,667)$
B&T Administration Overhead Allocation*(33,754)$ (74,370)$ 45.4%(93,235)$ (68,770)$ 35,016$
Operating Revenues Over (Under) Expenditures (121,037)$ (312,800)$ 38.7%(252,005)$ (409,207)$ 288,170$
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 (121,037)$ (147,300)$ (86,505)$ (123,708)$ 2,671$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay -$ 363,304$
Depreciation Expense (20,417) (18,755)
IMRF Pension Expense (1,167) 3,908
OPEB Expense (3,033) (1,225)
Total GAAP Adjustments (24,617)$ 347,232$
Fund Increase/(Decrease) - GAAP Basis (145,654)$ 223,524$
*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 July 31, 2020
7/31/20 7/31/20
823 831 832 833 834 7/31/20 YTD % of YTD 2020 7/31/19 Difference
Golf Golf General Golf Learning Golf Cart Golf Course YTD Amended Amended Adopted YTD Prior
Café Operation & Practice Operations Maintenance Total Budget Budget Budget Total Year
OPERATING REVENUES
Memberships -$ 226,788$ -$ -$ -$ 226,788$ 217,500$ 104.3%217,500$ 196,075$ 30,713$
Greens Fees - 496,149 - - - 496,149 537,000 92.4%930,000 515,003 (18,854)
Pro Shop Sales - 91,431 - - - 91,431 131,500 69.5%207,000 122,534 (31,103)
Golf Lessons - - 43,325 - - 43,325 33,500 129.3%40,000 31,305 12,020
Driving Range Fees - - 159,665 - - 159,665 186,000 85.8%244,000 181,451 (21,786)
Rentals - 55 - 159,251 - 159,306 217,675 73.2%375,000 260,868 (101,562)
Food Sales 65,595 - - - - 65,595 82,185 79.8%144,500 81,140 (15,545)
Beverage Sales 147,182 - - - - 147,182 139,740 105.3%245,000 143,639 3,543
Other Revenue - 3,006 - - - 3,006 8,000 37.6%8,000 6,640 (3,634)
Total Operating Revenues 212,777$ 817,429$ 202,990$ 159,251$ -$ 1,392,447$ 1,553,100$ 89.7%2,411,000$ 1,538,655$ (146,208)$
OPERATING EXPENDITURES
Personnel 83,457$ 283,673$ 17,108$ 22,988$ 274,405$ 681,631$ 722,885$ 94.3%1,263,665$ 680,014$ 1,617$
Materials & Supplies 101,272 51,305 5,049 478 77,690 235,794 357,230 66.0%538,450 332,215 (96,421)
Operational & Contractual 3,752 94,447 121 35,798 30,745 164,863 174,840 94.3%287,725 197,032 (32,169)
Other - - - - - - - 0.0%(83,150) - -
Capital - 352,741 - - 82,707 435,448 580,000 75.1%605,000 300,553 134,895
Total Operating Expenditures 188,481$ 782,166$ 22,278$ 59,264$ 465,547$ 1,517,736$ 1,834,955$ 82.7%2,611,690$ 1,509,814$ 7,922$
Operating Revenues Over (Under) Expenditures 24,296$ 35,263$ 180,712$ 99,987$ (465,547)$ (125,289)$ (281,855)$ 44.5%(200,690)$ 28,841$ (154,130)$
INTERFUND TRANSACTIONS
Transfer from Golf Surcharge -$ 323,373$ -$ -$ -$ 323,373$ 400,000$ 80.8%400,000$ 212,969$ 110,404$
Reimbursement to General Fund - (16,464) - - - (16,464) (16,450) 100.1%(28,225) - (16,464)
Total Interfund Transactions -$ 306,909$ -$ -$ -$ 306,909$ 383,550$ 80.0%371,775$ 212,969$ 93,940$
Total Revenues Over (Under) Expenditures - Budgetary Basis 24,296$ 342,172$ 180,712$ 99,987$ (465,547)$ 181,620$ 101,695$ 171,085$ 241,810$ (60,190)$
ADUSTMENTS TO GAAP BASIS*
Remove Capital Outlay -$ 352,741$ -$ -$ 82,707$ 435,448$ 300,553$
Depreciation Expense - (78,750) (2,333) (13,417) (29,167) (123,667) (116,509)
IMRF Pension Expense (875) (2,917) (204) - (2,917) (6,913) 46,222
OPEB Expense (1,750) (13,417) - - (8,167) (23,333) (10,462)
Total GAAP Adjustments (2,625)$ 257,658$ (2,538)$ (13,417)$ 42,457$ 281,536$ 219,805$
Fund Increase/(Decrease) - GAAP Basis 21,671$ 599,830$ 178,175$ 86,570$ (423,090)$ 463,156$ 461,615$
*Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.