04 - April 2021 Monthly Financial ReportVILLAGE
OAK BROOK
OF
MONTHLY FINANCIAL REPORTS
APRIL 2021
ITEM 6.E
Cash and Investments by Fund:Total
Cash and Cash Pooled Cash and
Fund Equivalents Investments Investments % By Fund
General Corporate $11,519,640 $14,116,717 $25,636,357 57.5%
Hotel/Motel Tax 2,015,301 2,671,603 4,686,904 10.5%
Motor Fuel Tax 820,401 33,102 853,503 1.9%
Infrastructure 3,533,025 2,257,719 5,790,744 13.0%
Promenade TIF 56,678 - 56,678 0.1%
Water 1,821,426 3,679,994 5,501,420 12.3%
Sports Core 212,500 - 212,500 0.5%
Golf Surcharge 150,987 - 150,987 0.3%
Self-Insurance 632,809 - 632,809 1.4%
Garage 303,065 - 303,065 0.7%
Equipment Replacement 330,476 403,501 733,977 1.6%
Total $21,396,308 $23,162,636 $44,558,944 100.0%
Change in Cash and Investments by Fund :
Balance at Balance at Year-to-Date Year-to-Date
Fund January 1, 2021 April 30, 2021 Change ($)Change (%)
General Corporate $23,894,312 $25,636,357 $1,742,045 7.3%
Hotel/Motel Tax 4,567,176 4,686,904 119,728 2.6%
Motor Fuel Tax 673,455 853,503 180,048 26.7%
Infrastructure 7,480,975 5,790,744 (1,690,231)-22.6%
Promenade TIF 267,300 56,678 (210,622)-78.8%
Water 6,900,169 5,501,420 (1,398,749)-20.3%
Sports Core 114,133 212,500 98,367 86.2%
Golf Surcharge 132,593 150,987 18,394 13.9%
Self-Insurance 0 632,809 632,809 N/A
Garage 298,348 303,065 4,717 1.6%
Equipment Replacement 696,392 733,977 37,585 5.4%
$45,024,853 $44,558,944 ($465,909)-1.0%
Book Bank/Market
Value Value
Cash and Cash Equivalents:
Pooled Checking $565,052 $3,678,331
Sports Core Checking 379,716 350,137
Pooled IPTIP 20,024,908 20,024,908
Water E-Pay IPTIP 426,632 418,625
$21,396,308 $24,472,001
Pooled Investments:
Investments-Municipal Bonds $11,044,700 $11,106,411
Investments-Corporate Bonds 7,486,313 7,522,442
Government & Agency Obligations 1,234,121 1,257,774
Certificates of Deposit 3,185,000 3,208,593
Accrued Interest 212,502 212,502
Total Pooled Investments $23,162,636 $23,307,722
Total Cash and Investments $44,558,944 $47,779,723
For April, total interest revenue is $26,555 and YTD is $114,126. The total investment yield for the portfolio is:
Pooled
Investments Illinois Funds Total
Last 12 months yield 1.74%0.20%1.03%
The weighted average yield of the current investment portfolio is 1.38%. The IL Funds April average daily rate was 0.041%.
Monthly Treasurer's Report
April 30, 2021
Monthly Treasurer's Report
April 2021
The table below lists the detail investment holdings at J.P. Morgan Securities as of 4/30/21:
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,000 $200,000 $2,350
Bloomingdale Mich Pub Sch Dist #094383FS0 04/26/16 05/01/22 2.710%2.150%502,701 511,405 6,736
Connecticut St GO Bds 2016 #20772J3F7 06/15/17 08/15/21 1.750%2.300%499,238 502,330 1,794
State of IL #452152P54 10/09/19 11/01/21 5.000%1.870%507,805 511,185 12,249
Anchor Bay Mich Sch #032879TE8 11/01/19 05/01/21 2.320%1.750%715,010 715,000 8,156
Brownsville TX #16405ST9 12/19/19 02/15/22 2.050%2.000%555,207 562,204 2,244
Laredo TX Waterworks #517039VW0 12/19/19 03/01/24 2.230%2.230%455,000 475,516 1,635
Oakland Univ Mich #673588HJ1 04/29/20 03/01/24 5.000%1.650%322,205 333,129 2,458
Philadelphia PA GO Ref #717813SW0 05/05/20 08/01/22 5.000%1.820%405,325 413,201 4,672
Maryland St DOT #574204WG4 05/06/20 06/15/22 4.350%1.200%269,161 271,786 4,156
University of CA #91412HFK4 07/16/20 05/15/23 0.628%0.628%25,000 25,180 72
Windsor NY Sch Dist #973675EW7 07/23/02 06/17/21 1.500%0.400%475,647 475,627 5,516
Waterford Mich Sch Dist #941468YZ7 08/20/20 08/24/21 4.000%0.301%505,795 505,525 13,925
Universty of IL #914353YH4 08/31/20 10/01/21 3.000%0.701%252,382 252,733 625
New Jersey St #646039UD7 09/20/20 06/01/22 5.000%0.600%497,570 499,577 9,830
Alaska St GO #011770Z72 10/14/2020 8/1/2021 5.000%0.252%177,096 177,067 2,163
Rio Rancho NM #767175HM7 10/14/2020 5/15/2022 5.000%0.350%193,932 194,256 4,240
Cook, Kane, Lake, & McHenry #216181GL5 10/29/2020 12/15/2022 4.000%0.300%1,086,314 1,089,965 20,720
Miami-Dade Cnty #59333NN90 11/16/2020 12/15/2022 0.375%0.430%734,226 735,301 214
Hamilton NY #407741MC8 1/21/2021 5/1/2023 1.000%0.550%206,837 206,474 558
Southern Cal Pub Pwr #84247PHZ7 1/25/2021 4/1/2024 3.608%0.500%1,097,679 1,092,390 11,826
Hillsborough Cnty FL #43232VV3 3/11/2021 7/1/2024 1.815%0.770%516,350 514,565 2,949
Port Auth of NY and NJ #73358WAH7 4/15/2021 12/1/2024 5.859%0.600%593,214 591,745 12,044
City of Atlanta GA Water #047870SG6 4/19/2021 11/1/2024 0.616%0.500%251,006 250,250 761
Total Municipal Bonds $11,044,700 $11,106,411 $131,893
Corporate Bonds:
Morgan Stanley #61747WAL3 03/08/19 07/28/21 5.500%3.034%1,055,864 1,062,842 14,758
Citigroup #172967LC3 04/01/19 12/08/21 2.900%2.754%1,000,958 1,013,670 10,956
American Honda #02665WBG5 07/31/19 09/09/21 1.700%2.180%499,178 502,540 1,251
JP Morgan #48128BAB7 09/30/19 01/15/23 2.972%2.337%1,010,504 1,018,530 8,751
American Express #025816CD9 05/05/20 05/20/22 2.750%1.290%507,662 512,065 6,006
Goldman Sachs #38141GGQ1 08/31/20 07/27/21 5.250%0.251%349,111 348,978 4,729
PNC Bank #69349LAK4 12/7/2020 1/30/2023 2.950%0.457%1,064,185 1,063,401 7,523
Wells Fargo #94974BFJ4 12/7/2020 2/13/2023 3.450%0.480%1,463,106 1,465,866 10,257
Comerica Bank #200340AS6 12/23/2020 7/31/2023 3.700%0.500%535,745 534,550 4,625
Total Corporate Bonds $7,486,313 $7,522,442 $68,856
Government & Agency Obligations:
*Government National Mtg Assn #38379UEM4 02/29/16 02/16/51 2.300%2.245%$343,741 $335,186 $733
*Government National Mtg Assn #38381WV96 08/06/19 07/20/54 2.250%2.293%438,589 450,811 704
*Government National Mtg Assn #38380BNV3 12/05/19 06/20/46 2.000%2.112%451,791 471,777 654
Total Government & Agency Obligations:$1,234,121 $1,257,774 $2,091
Certificates of Deposit:
State Bk India NY #8562846A7 01/26/17 01/26/22 2.250%2.250%$245,000 $249,043 $1,440
Morgan Stanley #61760AE21 05/30/19 06/01/21 2.400%2.400%245,000 245,517 2,450
First St Bank DeQueen #336460CU2 07/18/19 07/19/21 2.000%2.000%245,000 246,063 187
Bank Hapoalim #06251AW89 07/19/19 07/19/21 2.000%2.000%245,000 246,132 1,494
Capital One Natl Assn #14042RMF5 07/24/19 07/26/19 2.050%2.050%245,000 246,201 1,430
TIAA FSB Jacksonville #87270LCN1 07/29/19 07/29/21 2.000%2.000%245,000 246,210 1,232
Wells Fargo #949763J31 09/18/19 09/20/21 1.850%1.850%245,000 246,725 188
BMW Bank #05580ASQ8 10/11/19 10/12/21 1.800%1.800%245,000 246,970 178
Wells Fargo #949495AN5 01/17/20 01/18/22 1.800%1.800%245,000 248,114 187
Bank Leumi #063248KQ0 03/31/20 03/31/22 1.250%1.250%245,000 247,700 255
Capital One Natl Assn #14042TCZ8 04/01/20 04/01/22 1.350%1.350%245,000 247,918 267
Synchrony Bank #87164WZN1 04/03/20 04/04/22 1.350%1.350%245,000 247,938 248
Wells Fargo #95001DAB6 06/17/20 06/17/23 1.200%1.200%245,000 244,062 106
Total Certificates of Deposits $3,185,000 $3,208,593 $9,662
Total J.P.Morgan Securities $22,950,134 $23,095,220 $212,502
*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
April 30, 2021
Cash & Investments by Fund - Total $44.6 million
Cash & Investments by Type - Total $44.6 million
Checking
Illinois Funds
Certificates of Deposit
Municipal Bonds
Corporate Bonds
Government & Agency Obligations
Accrued Interest
General Corporate
57.5%
Hotel/Motel Tax
10.5%
Motor Fuel Tax
1.9%
Infrastructure
13.0%
Promenade TIF
0.1%
Water
12.3%
Sports Core
0.5%
Golf Surcharge
0.3%
Self-Insurance
1.4%
Garage
0.7%
Equipment
Replacement
1.6%
Checking, $0.9
Illinois Funds, $20.5
Certificates of Deposit,
$3.2
Municipal Bonds,
$11.1
Corporate Bonds, $7.5
Government & Agency
Obligations, $1.2
Accrued Interest, $0.2
in millions
YTD YTD
Net Fund Budgeted
YTD YTD Increase Increase
Governmental Funds Revenues Expenditures (Decrease)(Decrease)
General Fund (Major Fund)8,445,876$ 6,806,823$ 1,639,053$ 862,535$
Main operating fund of the Village.
Hotel Fund (Major Fund)141,154$ 44,656$ 96,498$ (7,500)$
Collects and spends resources from the
3% hotel/motel tax.
Motor Fuel Tax Fund 179,743$ -$ 179,743$ 96,000$
Collects and spends resources from the
State motor fuel tax.
Infrastructure Fund (Major Fund)2,073,563$ 3,062,630$ (989,067)$ (953,410)$
Accounts for construction and maintenance of
roadways, drainage, and safety path systems.
Promenade TIF Fund (Major Fund)17,628$ 228,250$ (210,622)$ (201,285)$
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)2,573,663$ 3,255,543$ (681,880)$ (3,439,925)$
Collects user fees for the distribution of water
and maintenance of infrastructure.
Sports Core Fund (Major Fund)943,781$ 680,196$ 263,585$ (185,785)$
Accounts for revenues and expenses relating
to administration, programs, food and beverage
operations, and golf course.
Golf Surcharge Fund 18,394$ -$ 18,394$ (186,680)$
Accounts for the collection of the $3 per round
golf surcharge.
Internal Service Funds
Self Insurance Fund 1,336,687$ 639,908$ 696,779$ 8,635$
Accounts for the Village's health insurance costs
and the related contributions from the Village,
employees, retirees, and other agencies.
Garage Fund 203,840$ 213,476$ (9,636)$ (38,615)$
Accounts for the maintenance of the Village's vehicle
fleet and the related departmental reimbursements.
Equipment Replacement Fund 111,883$ 87,017$ 24,866$ (35,850)$
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 April 30, 2021
Village of Oak Brook
Monthly Financial Report – Fund Narrative
For the Period Ending April 30, 2021
The monthly financial report serves as a document to inform and update readers of the Village’s
financial current position, including historical and trend information. A detailed financial statement and
trend information is displayed for all Village major funds. A fund is considered major if it is the primary
operating of the Village (General Fund) or meets the following criteria:
Total assets/deferred outflows of resources, liabilities/deferred inflows of resources, revenues,
or expenditures/expenses of that individual governmental or enterprise fund are at least 10% of
the total for all funds of the same category or type, and
The same element of the individual fun that met the 10% test is at least 5% of the
corresponding total for all funds combined.
This report is prepared on a cash basis of accounting, meaning transactions are recognized only when
cash is increased or decreased. Transactions for each month are compared to amounts from the
Village’s annual budget, which was also prepared using the cash basis of accounting. For the Village’s
enterprise funds (Water and Sports Core), a reconciliation is included to display results on a full accrual
basis, which is how information is presented in the Village’s annual Comprehensive Annual Financial
Report (annual audit).
The proceeding pages contain detailed information on the Village’s major funds. Highlights for each of
the Village’s funds are:
General Fund
Total revenues through April 2021 are $416,962, or 4.8%, lower than last April, but $874 over
budget to date. The main drivers for this are:
o Sales Tax revenue, the General
Fund’s largest revenue source, is
down $283,377 from last year,
but $238,052 over budget. April
2021 collections were consistent
with the past five years despite
COVID-19 restrictions.
o Other Intergovernmental Tax
revenue is up $100,430 from last
year and $156,635 over budget.
Receipts from Income Tax,
Replacement Tax, and Use Tax have been stronger than projected to date.
o Telecommunications/Utility Tax revenue is down $236,537 from last year and $209,201
under budget. The decrease relates to amended telecommunications tax returns.
o Charges for Services revenue is down $67,749 from last year and $131,815 under
budget. This is due to a decrease in billable auxiliary police services and a decrease in
billable ambulance revenue to date.
o Investment Interest revenue is down $74,320 from last year and $31,473 under budget.
Investment return rates have dropped significantly since the beginning of the COVID-19
pandemic.
Total expenditures through April 2021 are $831,742, or 10.9%, lower than last year and
$675,648, or 9.1%, under budget to date. The main drivers for this are:
o Personnel expenditures are down $844,447 from last year and $416,466 under budget.
The decrease is due to two payroll cycles in January 2021 vs. three payroll cycles in
January 2020. In addition, personnel expenditures are under budget due to delays in
full public safety pension funding.
Hotel Tax Fund
Total revenues through April 2021 are $152,777, or 52.0%, lower than last year, but $10,164, or
7.8%, over budget to date. The main drivers for this are:
o Hotel tax revenue is down $135,413 from last year, but $10,238 over budget. The
decrease in revenue is due to the effects of COVID-19 on the travel industry.
Total expenditures through April 2021 are $402,679, or 96.0%, lower than last year and $93,842,
or 84.9%, under budget. Major expenditures from the Hotel Tax Fund have not occurred yet in
2021 as many initiatives have been put on hold due to the lack of revenue.
Infrastructure Fund
Total revenues through April 2021 are down $251,058, or 11.3%, from last year and $358 under
budget. The main drivers for this are:
o Non-home rule sales tax
revenue is down $221,591 from
last year and $1,361 under
budget. April 2021 collections
were consistent with the past
five years despite COVID-19
restrictions.
o Investment Interest revenue is
down $32,547 from last year
and $1,737 under budget.
Investment return rates have
dropped significantly since the beginning of the COVID-19 pandemic.
Total expenditures through April 2021 are up $1,915,015, or 175.9%, from last year and
$35,467, or 1.2%, over budget to date. The main drivers for this are:
o Personnel expenditures are down $29,474 from last year and $3,932 under budget. The
decrease is due to two payroll cycles in January 2021 vs. three payroll cycles in January
2020.
o Operation and contract expenditures are down $108,416 from last year and $295,918
under budget. Expenditures are under budget due to the timing of engineering and
other miscellaneous payments.
o Capital Outlay expenditures are up $2,012,021 from last year and $316,937 over budget.
Expenditures are up due to delays last year and general timing of work performed.
Promenade TIF Fund
Total revenues through April 2021 are down $1,979, or 10.1%, from last year and $9,337, or
34.6%, under budget. Revenues are under budget due to the timing of Department of Revenue
information to record the TIF sale tax transfer.
Total expenditures through April 2021 are down $37,205, or 14.0%, from last year and even with
budget. The decrease relates to less principal and interest paid towards the TIF note.
Water Fund
Total revenues through April 2021 are down $54,449, or 2.1%, from last year and $285,677, or
10.0%, under budget. The main drivers for this are:
o Water sales revenue is down $180,960 from last year and $422,564 under budget.
Water gallons sold has also been slightly less than projected so far this year.
Total expenditures through April 2021 are up $1,244,550, or 66.9%, from last year, but
$3,043,730, or 49.5%, under budget. The main drivers for this are:
o Operation and contract expenditures are down $18,445 from last year and $857,453
under budget. Expenditures are under budget due to the timing of invoices paid and
DuPage Water Commission water purchased being less than expected.
o Capital outlay expenditures are up $1,260,787 from last year, but $2,170,510 under
budget. Capital projects will occur later in 2021 as planned.
Sports Core Fund
Total revenues through April 2021 are up $623,955, or 203.6%, from last year and $410,420, or
78.9%, over budget to date. The main drivers for this are:
o Memberships revenue is up $205,376 from last year and $175,275 over budget. Golf
memberships have doubled the total 2021 budget already through April.
o Greens Fees revenue is up $127,516 from last year and $69,823 over budget. The
course did not see much activity last spring due to COVID-19 restrictions.
o Driving Range Fees revenue is up $84,949 from last year and $47,636 over budget. This
is due to the golf course being able to open early and stay open this season.
Total expenditures through April 2021 are down $542,841, or 45.2%, from last year and
$238,943, or 26.6%, under budget to date. The main drivers for this are:
o Capital outlay expenditures are down $643,916 from last year and $178,636 under
budget. Expenditures are down because of the golf lounge project that occurred in
spring 2020. Expenditures are under budget due to the timing of projects.
4/30/21 4/30/21
4/30/20 4/30/21 YTD % of YTD 2021 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 4,803,679$ 4,520,302$ 4,282,250$ 105.6%11,860,995$ (283,377)$
Other Intergovernmental Tax*516,405 616,835 460,200 134.0%1,320,600 100,430
Telecommunications/Utility Tax 2,101,336 1,864,799 2,074,000 89.9%5,995,000 (236,537)
Licenses and Permits 580,639 692,255 666,870 103.8%2,180,360 111,616
Charges for Services 335,104 267,355 399,170 67.0%1,293,540 (67,749)
Fines and Penalties 60,751 55,805 60,180 92.7%180,500 (4,946)
Administrative Towing Fees 7,637 10,079 7,340 137.3%22,000 2,442
Investment Interest 142,847 68,527 100,000 68.5%300,000 (74,320)
Franchise Fees 4,483 3,674 50,500 7.3%202,000 (809)
Miscellaneous Income 112,065 148,353 146,600 101.2%463,380 36,288
Total Operating Revenues 8,664,946$ 8,247,984$ 8,247,110$ 100.0%23,818,375$ (416,962)$
OPERATING EXPENDITURES
Personnel 6,296,991$ 5,452,544$ 5,869,010$ 92.9%18,842,080$ (844,447)$
Materials and Supplies 134,110 124,299 198,650 62.6%551,030 (9,811)
Operation and Contract 1,117,932 1,111,228 1,277,685 87.0%3,397,210 (6,704)
Other Expenditures 2,201 2,173 5,000 43.5%10,000 (28)
Capital Outlay 52,035 81,283 96,830 83.9%452,300 29,248
Total Operating Expenditures 7,603,269$ 6,771,527$ 7,447,175$ 90.9%23,252,620$ (831,742)$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 1,061,677$ 1,476,457$ 799,935$ 565,755$ 414,780$
INTERFUND TRANSACTIONS
Transfers Out (326,369)$ -$ (100,000)$ 0.0%(100,000)$ 326,369$
Reimbursements From Other Funds 208,796 197,892 197,900 100.0%593,685 (10,904)
Reimbursements To Other Funds (46,588) (35,296) (35,300) 100.0%(105,885) 11,292
Sports Core Loan (113,481) - - 0.0%- 113,481
Total Interfund Transactions (277,642)$ 162,596$ 62,600$ 259.7%387,800$ 440,238$
NET FUND INCREASE (DECREASE)784,035$ 1,639,053$ 862,535$ 953,555$ 855,018$
*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 April 30, 2021
Total Total
Revenues Expenditures
4/30/21 Actual 8,247,984$ 6,771,527$
4/30/20 Actual 8,664,946$ 7,603,269$
% Change From Last Year -4.8%-10.9%
Major Revenues
Other Telecom/Utility Licenses &Charges for
Sales Tax Intergov. Tax Tax Permits Services
4/30/21 Actual 4,520,302$ 616,835$ 1,864,799$ 692,255$ 267,355$
4/30/20 Actual $ 4,803,679 $ 516,405 $ 2,101,336 $ 580,639 $ 335,104
% Change From Last Year -5.9%19.4%-11.3%19.2%-20.2%
Five Year Trend
Major Expenditures Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
4/30/21 Actual 5,452,544$ 124,299$ 1,111,228$ 2,173$ 81,283$
4/30/20 Actual 6,296,991$ 134,110$ 1,117,932$ 2,201$ 52,035$
% Change From Last Year -13.4%-7.3%-0.6%-1.3%56.2%
Five Year Trend
Expenditures by Department
4/30/20 4/30/21 4/30/21 4/30/21 2021 Difference Five
YTD YTD YTD % of Annual Prior Year
Department Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 712,699$ 745,851$ 880,705$ 84.7%2,498,625$ 33,152$
Financial Services 273,735 250,110 259,985 96.2%770,360 (23,625)
Public Works 205,152 286,433 301,900 94.9%948,860 81,281
Engineering & Capital Projects 18,020 5,493 24,000 22.9%209,000 (12,527)
Library 282,574 273,659 299,735 91.3%943,405 (8,915)
Police 3,093,523 2,618,179 2,825,415 92.7%9,213,585 (475,344)
Fire 2,656,166 2,266,879 2,503,895 90.5%7,576,045 (389,287)
Development Services 361,400 324,923 351,540 92.4%1,092,740 (36,477)
Total Expenditures 7,603,269$ 6,771,527$ 7,447,175$ 90.9%23,252,620$ (831,742)$
Five Year Trend
For the Period Ending April 30, 2021
General Fund - Five Year Trend
Village of Oak Brook
Revenues Expenditures
4/30/21 4/30/21
4/30/20 4/30/21 YTD % of YTD 2021 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Hotel Tax 263,301$ 127,888$ 117,650$ 108.7%414,000$ (135,413)$
Investment Interest 30,630 13,266 13,340 99.4%40,000 (17,364)
Loan Interest - - - 0.0%8,000 -
Total Operating Revenues 293,931$ 141,154$ 130,990$ 107.8%462,000$ (152,777)$
EXPENDITURES
Operation and Contract 202,341$ 16,628$ 60,470$ 27.5%193,945$ (185,713)$
Capital Outlay 216,966 - 50,000 0.0%250,000 (216,966)
Total Expenditures 419,307$ 16,628$ 110,470$ 15.1%443,945$ (402,679)$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES (125,376)$ 124,526$ 20,520$ 606.9%18,055$ 249,902$
INTERFUND TRANSACTIONS
Transfer Out -$ -$ -$ 0.0%(100,000)$ -$
Reimbursements to Other Funds (24,904) (28,028) (28,020) 100.0%(84,085) (3,124)
Total Interfund Transactions (24,904)$ (28,028)$ (28,020)$ 100.0%(184,085)$ (3,124)$
NET FUND INCREASE (DECREASE)(150,280)$ 96,498$ (7,500)$ (166,030)$ 246,778$
Note - Expenditures are recorded in program 171.
Village of Oak Brook
Hotel Tax Fund Financial Update
For the Period Ending April 30, 2021
Total Total
Revenues Expenditures
4/30/21 Actual $ 141,154 16,628$
4/30/20 Actual $ 293,931 419,307$
% Change From Last Year -52.0%-96.0%
Major Revenues Investment
Hotel Tax Interest Loan Interest Miscellaneous
4/30/21 Actual $ 127,888 $ 13,266 -$ -$
4/30/20 Actual $ 263,301 $ 30,630 -$ -$
% Change From Last Year -51.4%-56.7%0.0%0.0%
Five Year Trend
Major Expenditures Operation &
Contractual Capital Outlay
4/30/21 Actual 16,628$ -$
4/30/20 Actual 202,341$ 216,966$
% Change From Last Year -91.8%-100.0%
Five Year Trend
Village of Oak Brook
Hotel Tax Fund - Major Sources Five Year Trend
For the Period Ending April 30, 2021
Five Year Trend
Revenues Expenditures
4/30/21 4/30/21
4/30/20 4/30/21 YTD % of YTD 2021 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Non-Home Rule Sales Tax 2,169,855$ 1,948,264$ 1,949,625$ 99.9%5,333,500$ (221,591)$
Charges for Services - - 340 0.0%1,000 -
Investment Interest 44,150 11,603 13,340 87.0%40,000 (32,547)
Miscellaneous - 3,080 - N/A - 3,080
Total Operating Revenues 2,214,005$ 1,962,947$ 1,963,305$ 100.0%5,374,500$ (251,058)$
OPERATING EXPENDITURES
Personnel 479,752$ 450,278$ 454,210$ 99.1%1,386,115$ (29,474)$
Materials and Supplies 83,241 124,125 105,745 117.4%245,660 40,884
Operation and Contract 462,438 354,022 649,940 54.5%1,892,905 (108,416)
Capital Outlay 63,416 2,075,437 1,758,500 118.0%8,956,170 2,012,021
Total Operating Expenditures 1,088,847$ 3,003,862$ 2,968,395$ 101.2%12,480,850$ 1,915,015$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 1,125,158$ (1,040,915)$ (1,005,090)$ 103.6%(7,106,350)$ (2,166,073)$
INTERFUND TRANSACTIONS
Transfers In -$ -$ -$ 0.0%1,400,000$ -$
Reimbursements From Other Funds 119,792 110,616 110,620 100.0%331,840 (9,176)
Reimbursements To Other Funds (54,100) (58,768) (58,940) 99.7%(176,300) (4,668)
Total Interfund Transactions 65,692$ 51,848$ 51,680$ 100.3%1,555,540$ (13,844)$
NET FUND INCREASE (DECREASE)1,190,850$ (989,067)$ (953,410)$ (5,550,810)$ (2,179,917)$
Village of Oak Brook
Infrastructure Fund Financial Update
For the Period Ending April 30, 2021
Total Total
Revenues Expenditures
4/30/21 Actual $ 1,962,947 3,003,862$
4/30/20 Actual $ 2,214,005 1,088,847$
% Change From Last Year -11.3%175.9%
Major Revenues
Sales Tax
Charges for
Services
Investment
Interest Miscellaneous
4/30/21 Actual $ 1,948,264 $ - $ 11,603 $ 3,080
4/30/20 Actual $ 2,169,855 $ - $ 44,150 $ -
% Change From Last Year -10.2%0.0%-73.7%N/A
Five Year Trend
Major Expenditures Materials &Operation &
Personnel Supplies Contractual Capital Outlay
4/30/21 Actual 450,278$ 124,125$ 354,022$ 2,075,437$
4/30/20 Actual 479,752$ 83,241$ 462,438$ 63,416$
% Change From Last Year -6.1%49.1%-23.4%3172.7%
Five Year Trend
Expenditures by Department
4/30/20 4/30/21 4/30/21 4/30/21 2021 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 48,260$ 48,219$ 51,250$ 94.1%157,640$ (41)$
Public Works 750,829 780,773 853,570 91.5%2,789,580 29,944
Engineering & Capital Projects 289,758 2,174,870 2,063,575 105.4%9,709,930 1,885,112
Total Expenditures 1,088,847$ 3,003,862$ 2,968,395$ 101.2%12,657,150$ 1,915,015$
Five Year Trend
Village of Oak Brook
Infrastructure Fund - Major Sources Five Year Trend
For the Period Ending April 30, 2021
Revenues Expenditures
4/30/21 4/30/21
4/30/20 4/30/21 YTD % of YTD 2021 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 19,258$ 17,605$ 26,625$ 66.1%75,000$ (1,653)$
Real Estate Tax - - - 0.0%400,000 -
Investment Interest 349 23 340 6.8%1,000 (326)
Total Operating Revenues 19,607$ 17,628$ 26,965$ 65.4%476,000$ (1,979)$
EXPENDITURES
Operation and Contract -$ -$ -$ 0.0%3,850$ -$
Other Expenditures 265,455 228,250 228,250 100.0%466,500 (37,205)
Total Expenditures 265,455$ 228,250$ 228,250$ 100.0%470,350$ (37,205)$
NET FUND INCREASE (DECREASE)(245,848)$ (210,622)$ (201,285)$ 5,650$ 35,226$
Note - Expenditures are recorded in program 283.
Village of Oak Brook
Promenade TIF Fund Financial Update
For the Period Ending April 30, 2021
Total Total
Revenues Expenditures
4/30/21 Actual $ 17,628 228,250$
4/30/20 Actual $ 19,607 265,455$
% Change From Last Year -10.1%-14.0%
Major Revenues Real Estate Investment
Sales Tax Tax Interest
4/30/21 Actual 17,605$ $ - $ 23
4/30/20 Actual 19,258$ $ - $ 349
% Change From Last Year -8.6%0.0%-93.4%
Five Year Trend
Major Expenditures Operation &Other
Contractual Expenditures
4/30/21 Actual -$ 228,250$
4/30/20 Actual -$ 265,455$
% Change From Last Year 0.0%-14.0%
Five Year Trend
Village of Oak Brook
Promenade TIF Fund - Major Sources Five Year Trend
For the Period Ending April 30, 2021
Five Year Trend
Revenues Expenditures
4/30/21 4/30/21
4/30/20 4/30/21 YTD % of YTD 2021 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Plan Review Fees 150$ 75$ 340$ 22.1%1,000$ (75)$
Building/Inspection Fees 4,912 2,025 2,340 86.5%7,000 (2,887)
Water Sales 2,523,396 2,342,436 2,765,000 84.7%10,597,000 (180,960)
Unmetered Sales 27,114 5,126 11,660 44.0%35,000 (21,988)
Water Connection Fees 5,080 77,510 33,340 232.5%100,000 72,430
Meter Charges 4,377 2,228 5,000 44.6%15,000 (2,149)
Special Services 763 765 - N/A 25,000 2
Investment Interest 41,706 18,286 20,000 91.4%60,000 (23,420)
Miscellaneous 20,614 125,212 21,660 578.1%65,000 104,598
Total Operating Revenues 2,628,112$ 2,573,663$ 2,859,340$ 90.0%10,905,000$ (54,449)$
OPERATING EXPENDITURES
Personnel 270,054$ 238,714$ 266,125$ 89.7%842,235$ (31,340)$
Materials and Supplies 3,656 37,204 25,560 145.6%75,780 33,548
Operation and Contract 958,042 939,597 1,797,050 52.3%5,379,925 (18,445)
Capital Outlay 629,073 1,889,860 4,060,370 46.5%8,103,750 1,260,787
Total Expenditures 1,860,825$ 3,105,375$ 6,149,105$ 50.5%14,401,690$ 1,244,550$
Surplus (Deficit) of Revenues Over
Expenditures 767,287$ (531,712)$ (3,289,765)$ 16.2%(3,496,690)$ (1,298,999)$
INTERFUND TRANSACTIONS
Reimbursements To Other Funds (175,604)$ (150,168)$ (150,160)$ 100.0%(450,500)$ 25,436$
Total Interfund Transactions (175,604)$ (150,168)$ (150,160)$ 100.0%(450,500)$ 25,436$
Fund Increase/(Decrease) - Budgetary Basis 591,683$ (681,880)$ (3,439,925)$ 19.8%(3,947,190)$ (1,273,563)$
ADUSTMENTS TO GAAP BASIS*
Remove Capital Outlay 629,073$ 1,889,860$
Depreciation Expense (182,901) (191,667)
IMRF Pension Expense (13,831) (15,000)
OPEB Expense 9,214 (10,000)
Total GAAP Adjustments 441,555$ 1,673,193$
Fund Increase/(Decrease) - GAAP Basis 1,033,238$ 991,313$
*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 April 30, 2021
Total Total
Revenues Expenditures
4/30/21 Actual $ 2,573,663 3,105,375$
4/30/20 Actual $ 2,628,112 1,860,825$
% Change From Last Year -2.1%66.9%
Unmetered Water
Water Sales Sales Connection Fees Meter Charges Miscellaneous
4/30/21 Actual $ 2,342,436 $ 5,126 $ 77,510 $ 2,228 $ 125,212
4/30/20 Actual $ 2,523,396 $ 27,114 $ 5,080 $ 4,377 $ 20,614
% Change From Last Year -7.2%-81.1%1425.8%-49.1%507.4%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
4/30/21 Actual 238,714$ 37,204$ 939,597$ -$ 1,889,860$
4/30/20 Actual 270,054$ 3,656$ 958,042$ -$ 629,073$
% Change From Last Year -11.6%917.6%-1.9%0.0%200.4%
Five Year Trend
Expenditures by Department
4/30/20 4/30/21 4/30/21 4/30/21 2021 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Public Works 1,231,762$ 1,202,266$ 2,095,405$ 57.4%6,317,940$ (29,496)$
Engineering & Capital Projects 629,063 1,903,109 4,053,700 46.9%8,083,750 1,274,046
Total Expenditures 1,860,825$ 3,105,375$ 6,149,105$ 50.5%14,401,690$ 1,244,550$
Five Year Trend
Village of Oak Brook
Water Fund - Major Sources Five Year Trend
For the Period Ending April 30, 2021
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Sports Core Fund Consolidated Presentation
For the Period Ending April 30, 2021
4/30/21 4/30/21
4/30/21 YTD % of YTD 2021 4/30/20 Difference
B&T Recreation Field Clubhouse Golf YTD Amended Amended Adopted YTD Prior
Operations Operations Operations Club Total Budget Budget Budget Total Year
OPERATING REVENUES
Memberships -$ -$ -$ 338,775$ 338,775$ 163,500$ 207.2%238,500$ 133,399$ 205,376$
Greens Fees - - - 148,823 148,823 79,000 188.4%985,000 21,307 127,516
Pro Shop Sales - - - 52,654 52,654 44,500 118.3%207,000 16,289 36,365
Golf Lessons - - - 22,950 22,950 15,000 153.0%45,000 120 22,830
Driving Range Fees - - - 117,636 117,636 70,000 168.1%250,000 32,687 84,949
Rentals - 90,000 2,950 56,571 149,521 137,325 108.9%761,000 98,340 51,181
Programs/User Fees - - - - - - 0.0%31,500 - -
Food Sales - - - 32,012 32,012 3,000 1067.1%207,500 926 31,086
Beverage Sales - - - 56,272 56,272 6,000 937.9%382,000 2,827 53,445
Taste of Oak Brook - - - - - - 0.0%120,000 - -
Grants - - - - - - 0.0%233,600 - -
Other Revenue 7,103 - - 4,699 11,802 1,700 694.2%7,700 595 11,207
Total Operating Revenues 7,103$ 90,000$ 2,950$ 830,392$ 930,445$ 520,025$ 178.9%3,468,800$ 306,490$ 623,955$
OPERATING EXPENDITURES
Personnel -$ -$ 33,648$ 270,042$ 303,690$ 326,490$ 93.0%1,597,610$ 285,723$ 17,967$
Materials & Supplies 22,778 - 1,466 69,011 93,255 117,190 79.6%628,450 30,959 62,296
Operational & Contractual 25,483 1,082 7,730 119,128 153,423 166,995 91.9%663,035 132,611 20,812
Other - - - - - - 0.0%(39,000) - -
Capital 105,782 - - 3,082 108,864 287,500 37.9%1,125,380 752,780 (643,916)
Total Operating Expenditures 154,043$ 1,082$ 42,844$ 461,263$ 659,232$ 898,175$ 73.4%3,975,475$ 1,202,073$ (542,841)$
B&T Administration Overhead Allocation*11,017$ -$ (11,017)$ -$ -$ -$ 0.0%-$ -$ -$
Operating Revenues Over (Under) Expenditures (135,923)$ 88,918$ (50,911)$ 369,129$ 271,213$ (378,150)$ -71.7%(506,675)$ (895,583)$ 1,166,796$
INTERFUND TRANSACTIONS
Interfund Loan**-$ -$ -$ -$ -$ -$ 0.0%-$ 113,481$ (113,481)$
Transfer From General Fund - - - - - - 0.0%100,000 326,369 (326,369)
Transfer From Golf Surcharge Fund - - - - - 200,000 0.0%200,000 320,732 (320,732)
Reimbursement From Infrastructure Fund 10,667 - - - 10,667 10,670 100.0%32,000 8,000 2,667
Reimbursement From Water Fund 2,669 - - - 2,669 2,670 100.0%8,000 2,668 1
Reimbursement To General Fund (5,240) - - (15,724) (20,964) (20,975) 99.9%(62,900) (18,816) (2,148)
Total Interfund Transactions 8,096$ -$ -$ (15,724)$ (7,628)$ 192,365$ -4.0%277,100$ 752,434$ (760,062)$
Total Revenues Over (Under) Expenditures - Budgetary Basis (127,827)$ 88,918$ (50,911)$ 353,405$ 263,585$ (185,785)$ (229,575)$ (143,149)$ 406,734$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay 105,782$ -$ -$ 3,082$ 108,864$ 752,780$
Depreciation Expense (56,076) (562) (20,000) (82,100) (158,737) (129,694)
IMRF Pension Expense (683) - (1,000) (8,167) (9,850) (8,718)
OPEB Expense - - (1,000) (9,333) (10,333) (8,415)
Total GAAP Adjustments 49,023$ (562)$ (22,000)$ (96,518)$ (70,057)$ 605,953$
Fund Increase/(Decrease) - GAAP Basis (78,804)$ 88,356$ (72,911)$ 256,887$ 193,528$ 462,804$
*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
4/30/21 Actual $ 930,445 659,232$
4/30/20 Actual $ 306,490 1,202,073$
% Change From Last Year 203.6%-45.2%
Driving Program/
Memberships Greens Fees Range Fees Rentals User Fees
4/30/21 Actual $ 338,775 $ 148,823 $ 117,636 $ 149,521 -$
4/30/20 Actual $ 133,399 $ 21,307 $ 32,687 $ 98,340 -$
% Change From Last Year 154.0%598.5%259.9%52.0%0.0%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
4/30/21 Actual 303,690$ 93,255$ 153,423$ -$ 108,864$
4/30/20 Actual 285,723$ 30,959$ 132,611$ -$ 752,780$
% Change From Last Year 6.3%201.2%15.7%0.0%-85.5%
Five Year Trend
Revenues by Department 4/30/20 4/30/21 4/30/21 4/30/21 2021 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Operations (36)$ 7,103$ (100)$ -7103.0%325,800$ 7,139$
Open Field Operations 82,670 90,000 90,000 100.0%230,000 7,330
B&T Clubhouse Operations 10,480 2,950 12,000 24.6%267,000 (7,530)
Golf Club 213,376 830,392 418,125 198.6%2,646,000 617,016
Total Revenues 306,490$ 930,445$ 520,025$ 178.9%3,468,800$ 623,955$
Expenditures by Department 4/30/20 4/30/21 4/30/21 % of YTD 2021 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Operations 364,091$ 154,043$ 107,940$ 142.7%780,740$ (210,048)$
Open Field Operations 30,956$ 1,082$ 22,400$ 4.8%358,910$ (29,874)$
B&T Clubhouse Operations 48,192 42,844 72,785 58.9%262,635 (5,348)
Golf Club 758,834 461,263 695,050 66.4%2,573,190 (297,571)
Total Expenditures 1,202,073$ 659,232$ 898,175$ 73.4%3,975,475$ (542,841)$
Five Year Trend
Village of Oak Brook
Sports Core Fund - Major Sources Five Year Trend
For the Period Ending April 30, 2021
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Bath & Tennis Club Recreation Operations
For the Period Ending April 30, 2021 4/30/21 4/30/21
822 4/30/21 YTD % of YTD 2021 4/30/20 Difference
811 812 813 Poolside YTD Amended Amended Adopted YTD Prior
B&T Admin Swimming Tennis Café Total Budget Budget Budget Total Year
OPERATING REVENUES
Memberships -$ -$ -$ -$ -$ 0.0%-$ 199$ (199)$
Programs/User Fees - - - - - 0.0%31,500 - -
Food Sales - - - - - 0.0%38,000 - -
Beverage Sales - - - - - 0.0%22,000 - -
Grants - - - - - 0.0%233,600 - -
Other Revenue 7,103 - - - 7,103 (100) -7103.0%700 (235) 7,338
Total Operating Revenues 7,103$ -$ -$ -$ 7,103$ (100)$ -7103.0%325,800$ (36)$ 7,139$
OPERATING EXPENDITURES
Personnel -$ -$ -$ -$ -$ 17,035$ 0.0%119,110$ 2,316$ (2,316)$
Materials & Supplies - 18,112 2,342 2,324 22,778 11,860 192.1%37,250 705 22,073
Operational & Contractual 15,306 9,012 1,042 123 25,483 34,045 74.9%89,550 27,004 (1,521)
Capital 8,591 97,191 - - 105,782 45,000 235.1%534,830 334,066 (228,284)
Total Operating Expenditures 23,897$ 124,315$ 3,384$ 2,447$ 154,043$ 107,940$ 142.7%780,740$ 364,091$ (210,048)$
B&T Administration Overhead Allocation*22,034$ (7,933)$ (2,203)$ (881)$ 11,017$ 18,280$ 60.3%44,755$ 21,180$ (10,163)$
Operating Revenues Over (Under) Expenditures 5,240$ (132,248)$ (5,587)$ (3,328)$ (135,923)$ (89,760)$ 151.4%(410,185)$ (342,947)$ 207,024$
INTERFUND TRANSACTIONS
Interfund Loan**-$ -$ -$ -$ 0.0%-$ 113,481$ (113,481)$
Transfer From General Fund - - - - 0.0%100,000 326,369 (326,369)
Reimbursement From Infrastructure Fund 10,667 - - 10,667 10,670 100.0%32,000 8,000 2,667
Reimbursement From Water Fund 2,669 - - 2,669 2,670 100.0%8,000 2,668 1
Reimbursement To General Fund (5,240) - - (5,240) (5,240) 100.0%(15,725) (9,408) 4,168
Total Interfund Transactions 8,096$ -$ -$ -$ 8,096$ 8,100$ 100.0%124,275$ 441,110$ (433,014)$
Total Revenues Over (Under) Expenditures - Budgetary Basis 13,336$ (132,248)$ (5,587)$ (3,328)$ (127,827)$ (81,660)$ (285,910)$ 98,163$ (225,990)$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay 8,591$ 97,191$ -$ -$ 105,782$ 334,066$
Depreciation Expense (21,453) (33,333) (900) (389) (56,076) (30,702)
IMRF Pension Expense (667) - - (17) (683) (373)
Total GAAP Adjustments (13,529)$ 63,858$ (900)$ (406)$ 49,023$ 302,991$
Fund Increase/(Decrease) - GAAP Basis (193)$ (68,390)$ (6,487)$ (3,734)$ (78,804)$ 401,154$
*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 April 30, 2021 4/30/21 4/30/21
4/30/21 YTD % of YTD 2021 4/30/20 Difference
815 816 YTD Amended Amended Adopted YTD Prior
Polo Open Fields Total Budget Budget Budget Total Year
OPERATING REVENUES
Field Rentals -$ 10,000$ 10,000$ 10,000$ 100.0%30,000$ 7,670$ 2,330$
Range Rentals - 80,000 80,000 80,000 100.0%80,000 75,000 5,000
Taste of Oak Brook - - - - 0.0%120,000 - -
Other Revenue - - - - 0.0%- - -
Total Operating Revenues -$ 90,000$ 90,000$ 90,000$ 100.0%230,000$ 82,670$ 7,330$
OPERATING EXPENDITURES
Personnel -$ -$ -$ -$ 0.0%-$ -$ -$
Materials & Supplies - - - 200 0.0%500 119 (119)
Operational & Contractual - 1,082 1,082 22,200 4.9%190,360 22,127 (21,045)
Capital - - - - 0.0%168,050 8,710 (8,710)
Total Operating Expenditures -$ 1,082$ 1,082$ 22,400$ 4.8%358,910$ 30,956$ (29,874)$
Operating Revenues Over (Under) Expenditures -$ 88,918$ 88,918$ 67,600$ 131.5%(128,910)$ 51,714$ 37,204$
INTERFUND TRANSACTIONS
Transfer From Hotel Tax Fund -$ -$ -$ -$ 0.0%-$ -$ -$
Total Interfund Transactions -$ -$ -$ -$ 0.0%-$ -$ -$
Total Revenues Over (Under) Expenditures - Budgetary Basis -$ 88,918$ 88,918$ 67,600$ (128,910)$ 51,714$ 37,204$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay -$ -$ -$ 8,710$
Depreciation Expense - (562) (562) (562)
Total GAAP Adjustments -$ (562)$ (562)$ 8,148$
Fund Increase/(Decrease) - GAAP Basis -$ 88,356$ 88,356$ 59,862$
*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 April 30, 2021
4/30/21 4/30/21
821 YTD % of YTD 2021 4/30/20 Difference
B&T Amended Amended Adopted YTD Prior
Clubhouse Budget Budget Budget Total Year
OPERATING REVENUES
Rentals 2,950$ 12,000$ 24.6%267,000$ 10,480$ (7,530)$
Total Operating Revenues 2,950$ 12,000$ 24.6%267,000$ 10,480$ (7,530)$
OPERATING EXPENDITURES
Personnel 33,648$ 35,620$ 94.5%133,585$ 37,949$ (4,301)$
Materials & Supplies 1,466 4,510 32.5%12,000 1,436 30
Operational & Contractual 7,730 28,155 27.5%107,550 8,807 (1,077)
Capital - 4,500 0.0%9,500 - -
Total Operating Expenditures 42,844$ 72,785$ 58.9%262,635$ 48,192$ (5,348)$
B&T Administration Overhead Allocation*(11,017)$ (18,280)$ 60.3%(44,755)$ (21,180)$ 10,163$
Operating Revenues Over (Under) Expenditures (50,911)$ (79,065)$ 64.4%(40,390)$ (58,892)$ 7,981$
INTERFUND TRANSACTIONS
Transfer From General Fund -$ -$ 0.0%-$ -$ -$
Total Interfund Transactions -$ -$ 0.0%-$ -$ -$
Total Revenues Over (Under) Expenditures - Budgetary Basis (50,911)$ (79,065)$ (40,390)$ (58,892)$ 7,981$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay -$ -$
Depreciation Expense (20,000) (20,185)
IMRF Pension Expense (1,000) (691)
OPEB Expense (1,000) (881)
Total GAAP Adjustments (22,000)$ (21,757)$
Fund Increase/(Decrease) - GAAP Basis (72,911)$ (80,649)$
*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 April 30, 2021
4/30/21 4/30/21
823 831 832 833 834 4/30/21 YTD % of YTD 2021 4/30/20 Difference
Golf Golf General Golf Learning Golf Cart Golf Course YTD Amended Amended Adopted YTD Prior
Café Operation & Practice Operations Maintenance Total Budget Budget Budget Total Year
OPERATING REVENUES
Memberships -$ 338,775$ -$ -$ -$ 338,775$ 163,500$ 207.2%238,500$ 133,200$ 205,575$
Greens Fees - 148,823 - - - 148,823 79,000 188.4%985,000 21,307 127,516
Pro Shop Sales - 52,654 - - - 52,654 44,500 118.3%207,000 16,289 36,365
Golf Lessons - - 22,950 - - 22,950 15,000 153.0%45,000 120 22,830
Driving Range Fees - - 117,636 - - 117,636 70,000 168.1%250,000 32,687 84,949
Rentals - 130 - 56,441 - 56,571 35,325 160.1%384,000 5,190 51,381
Food Sales 32,012 - - - - 32,012 3,000 1067.1%169,500 926 31,086
Beverage Sales 56,272 - - - - 56,272 6,000 937.9%360,000 2,827 53,445
Other Revenue - 4,699 - - - 4,699 1,800 261.1%7,000 830 3,869
Total Operating Revenues 88,284$ 545,081$ 140,586$ 56,441$ -$ 830,392$ 418,125$ 198.6%2,646,000$ 213,376$ 617,016$
OPERATING EXPENDITURES
Personnel 34,939$ 132,840$ 4,106$ 4,477$ 93,680$ 270,042$ 273,835$ 98.6%1,344,915$ 245,458$ 24,584$
Materials & Supplies 38,782 (4,557) 4,967 735 29,084 69,011 100,620 68.6%578,700 28,699 40,312
Operational & Contractual 1,283 94,812 249 8,262 14,522 119,128 82,595 144.2%275,575 74,673 44,455
Other - - - - - - - 0.0%(39,000) - -
Capital - 2,684 - - 398 3,082 238,000 1.3%413,000 410,004 (406,922)
Total Operating Expenditures 75,004$ 225,779$ 9,322$ 13,474$ 137,684$ 461,263$ 695,050$ 66.4%2,573,190$ 758,834$ (297,571)$
Operating Revenues Over (Under) Expenditures 13,280$ 319,302$ 131,264$ 42,967$ (137,684)$ 369,129$ (276,925)$ -133.3%72,810$ (545,458)$ 914,587$
INTERFUND TRANSACTIONS
Transfer from Golf Surcharge -$ -$ -$ -$ -$ 200,000$ 0.0%200,000$ 320,732$ (320,732)$
Reimbursement to General Fund - (15,724) - - (15,724) (15,735) 99.9%(47,175) (9,408) (6,316)
Total Interfund Transactions -$ (15,724)$ -$ -$ -$ (15,724)$ 184,265$ -8.5%152,825$ 311,324$ (327,048)$
Total Revenues Over (Under) Expenditures - Budgetary Basis 13,280$ 303,578$ 131,264$ 42,967$ (137,684)$ 353,405$ (92,660)$ 225,635$ (234,134)$ 587,539$
ADUSTMENTS TO GAAP BASIS*
Remove Capital Outlay -$ 2,684$ -$ -$ 398$ 3,082$ 410,004$
Depreciation Expense (333) (35,000) (767) (4,333) (41,667) (82,100) (78,245)
IMRF Pension Expense (833) (3,333) (333) - (3,667) (8,167) (7,654)
OPEB Expense (1,000) (5,000) - - (3,333) (9,333) (7,534)
Total GAAP Adjustments (2,167)$ (40,649)$ (1,100)$ (4,333)$ (48,269)$ (96,518)$ 316,571$
Fund Increase/(Decrease) - GAAP Basis 11,113$ 262,929$ 130,164$ 38,634$ (185,953)$ 256,887$ 82,437$
*Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.