09 - September 2020 Monthly Financial ReportVILLAGE
OAK BROOK
OF
MONTHLY FINANCIAL REPORTS
SEPTEMBER 2020
ITEM 6.E
Cash and Investments by Fund:Total
Cash and Cash Pooled Cash and
Fund Equivalents Investments Investments % By Fund
General Corporate $6,454,424 $14,932,650 $21,387,074 47.2%
Hotel/Motel Tax 2,088,397 2,589,660 4,678,057 10.3%
Motor Fuel Tax 777,313 36,712 814,025 1.8%
Infrastructure 5,898,574 1,961,877 7,860,451 17.4%
Promenade TIF 226,824 - 226,824 0.5%
Water 4,328,508 3,642,231 7,970,739 17.6%
Sports Core 465,415 - 465,415 1.0%
Golf Surcharge 124,661 - 124,661 0.3%
Self-Insurance 458,313 - 458,313 1.0%
Garage 349,661 - 349,661 0.8%
Equipment Replacement 606,947 339,922 946,869 2.1%
Total $21,779,037 $23,503,052 $45,282,089 100.0%
Change in Cash and Investments by Fund :
Balance at Balance at Year-to-Date Year-to-Date
Fund January 1, 2020 September 30, 2020 Change ($)Change (%)
General Corporate $21,270,239 $21,387,074 $116,835 0.5%
Hotel/Motel Tax 5,427,474 4,678,057 (749,417)-13.8%
Motor Fuel Tax 1,085,595 814,025 (271,570)-25.0%
Infrastructure 8,217,724 7,860,451 (357,273)-4.3%
Promenade TIF 304,194 226,824 (77,370)-25.4%
Water 6,947,239 7,970,739 1,023,500 14.7%
Sports Core 231,216 465,415 234,199 101.3%
Golf Surcharge 347,066 124,661 (222,405)-64.1%
Self-Insurance 308,820 458,313 149,493 48.4%
Garage 275,988 349,661 73,673 26.7%
Equipment Replacement 808,879 946,869 137,990 17.1%
$45,224,434 $45,282,089 $57,655 0.1%
Book Bank/Market
Value Value
Cash and Cash Equivalents:
Pooled Checking $1,597,010 $2,032,257
Sports Core Checking 590,075 565,588
Pooled IPTIP 19,373,974 19,373,974
Water E-Pay IPTIP 217,978 182,508
$21,779,037 $22,154,327
Pooled Investments:
Investments-Municipal Bonds $7,771,561 $7,844,069
Investments-Corporate Bonds 8,661,281 8,763,031
Government & Agency Obligations 1,769,867 1,806,845
Certificates of Deposit 5,145,000 5,206,330
Accrued Interest 155,342 155,342
Total Pooled Investments $23,503,052 $23,775,617
Total Cash and Investments $45,282,089 $45,929,944
For September, total interest revenue is $41,449 and YTD is $513,192. The total investment yield for the portfolio is:
Pooled
Investments Illinois Funds Total
Last 12 months yield 2.16%1.11%1.68%
The weighted average yield of the current pooled investment portfolio is 2.02%. The IL Funds August average daily rate was 0.127%.
Monthly Treasurer's Report
Septemer 30, 2020
Monthly Treasurer's Report
September 2020
The table below lists the detail investment holdings at J.P. Morgan Securities as of 9/30/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,389 $202,198 $1,944
Bloomingdale Mich Pub Sch Dist #094383FS0 04/26/16 05/01/22 2.710%2.150%504,289 517,645 5,607
Connecticut St GO Bds 2016 #20772J3F7 06/15/17 08/15/21 1.750%2.300%497,656 505,875 1,065
Wright County Min #982276BC0 07/18/19 12/01/20 2.000%2.000%545,000 546,232 4,148
State of IL #452152P54 10/09/19 11/01/21 5.000%1.870%516,793 513,450 10,166
Anchor Bay Mich Sch #032879TE8 11/01/19 05/01/21 2.320%1.750%717,373 723,616 6,773
Brownsville TX #16405ST9 12/19/19 02/15/22 2.050%2.000%555,366 565,306 1,296
Laredo TX Waterworks #517039VW0 12/19/19 03/01/24 2.230%2.230%455,000 474,269 789
Manchester NH #562333JE5 03/12/20 12/01/20 5.000%0.850%478,284 478,772 7,876
Oakland Univ Mich #673588HJ1 04/29/20 03/01/24 5.000%1.650%327,678 334,604 1,229
Philadelphia PA GO Ref #717813SW0 05/05/20 08/01/22 5.000%1.820%412,354 421,192 3,047
Maryland St DOT #574204WG4 05/06/20 06/15/22 4.350%1.200%273,856 276,962 3,214
University of CA #91412HFK4 07/16/20 05/15/23 0.628%0.628%25,000 25,106 32
Windsor NY Sch Dist #973675EW7 07/23/02 06/17/21 1.500%0.400%478,690 478,297 1,360
Waterford Mich Sch Dist #941468YZ7 08/20/20 08/24/21 4.000%0.301%516,563 515,690 2,258
Weedsport NY Cent Sch Dist #948543KA0 08/21/20 08/20/21 1.000%0.570%501,894 501,620 551
Universty of IL #914353YH4 08/31/20 10/01/21 3.000%0.701%255,717 255,493 3,750
New Jersey St #646039UD7 09/20/20 06/01/22 5.000%0.600%509,658 507,742 7,851
Total Municipal Bonds $7,771,561 $7,844,069 $62,957
Corporate Bonds:
Wells Fargo #94974BGR5 01/15/19 12/07/20 2.550%3.120%$1,388,681 $1,395,616 $11,520
PNC Bank #69353RFH6 01/30/19 01/22/21 2.500%3.020%499,230 502,490 2,396
Morgan Stanley #61747WAL3 03/08/19 07/28/21 5.500%3.034%1,070,714 1,093,943 9,946
Citigroup #172967LC3 04/01/19 12/08/21 2.900%2.754%1,001,681 1,027,250 8,539
Bank of America #06051GFT1 04/03/19 10/19/20 2.625%2.625%700,000 700,763 8,014
Goldman Sachs #38143U8F1 05/02/19 02/25/21 2.875%2.707%365,230 368,004 1,022
American Honda #02665WBG5 07/31/19 09/09/21 1.700%2.180%497,798 505,965 542
BB&T Corp #05531FAZ6 08/15/19 02/01/21 2.150%2.010%750,377 753,518 2,491
JP Morgan #48128BAB7 09/30/19 01/15/23 2.972%2.337%1,014,037 1,032,620 6,274
JP Morgan #46625HRT9 01/30/20 06/07/21 2.400%1.648%502,531 506,270 3,800
American Express #025816CD9 05/05/20 05/20/22 2.750%1.290%511,844 517,775 4,861
Goldman Sachs #38141GGQ1 08/31/20 07/27/21 5.250%0.251%359,157 358,817 3,220
Total Corporate Bonds $8,661,281 $8,763,031 $62,624
Government & Agency Obligations:
*Government National Mtg Assn #38379UEM4 02/29/16 02/16/51 2.300%2.245%$494,400 $488,671 $2,226
*Government National Mtg Assn #38381WV96 08/06/19 07/20/54 2.250%2.293%704,518 723,419 1,227
*Government National Mtg Assn #38380BNV3 12/05/19 06/20/46 2.000%2.112%570,949 594,755 883
Total Government & Agency Obligations:$1,769,867 $1,806,845 $4,336
Certificates of Deposit:
State Bk India NY #8562846A7 01/26/17 01/26/22 2.250%2.250%$245,000 $251,970 $1,004
Jackson Cnty Bk #466682AP6 08/31/17 03/01/21 1.850%1.850%245,000 246,864 378
Goldman Sachs Bank #38148PRK5 10/18/17 10/19/20 1.950%1.950%245,000 245,245 2,144
FirstBank PR Santurce #33767A6M8 11/03/17 11/03/20 2.000%2.000%245,000 245,436 343
Compass Bank #20451PVW3 10/26/18 10/26/20 3.000%3.000%245,000 245,522 3,134
UBS Bank #90348JFH8 10/30/18 10/29/20 3.050%3.050%245,000 245,590 5
Discover Bank #254673WF9 11/07/18 11/09/20 3.000%3.000%245,000 245,801 2,930
Ally Bank #02007GFX6 11/08/18 11/09/20 3.000%3.000%245,000 245,801 2,909
Comenity Cap Bank #20033AU46 04/15/19 04/15/21 2.500%2.500%245,000 248,222 223
Morgan Stanley #61760AE21 05/30/19 06/01/21 2.400%2.400%245,000 248,824 1,944
First St Bank DeQueen #336460CU2 07/18/19 07/19/21 2.000%2.000%245,000 248,773 175
Bank Hapoalim #06251AW89 07/19/19 07/19/21 2.000%2.000%245,000 248,996 1,086
Capital One Natl Assn #14042RMF5 07/24/19 07/26/19 2.050%2.050%245,000 248,991 1,033
TIAA FSB Jacksonville #87270LCN1 07/29/19 07/29/21 2.000%2.000%245,000 248,927 844
Wells Fargo #949763J31 09/18/19 09/20/21 1.850%1.850%245,000 249,202 176
BMW Bank #05580ASQ8 10/11/19 10/12/21 1.800%1.800%245,000 249,332 2,015
Wells Fargo #949495AN5 01/17/20 01/18/22 1.800%1.800%245,000 250,400 176
Bank Leumi #063248KQ0 03/31/20 03/31/22 1.250%1.250%245,000 249,180 1,531
Capital One Natl Assn #14042TCZ8 04/01/20 04/01/22 1.350%1.350%245,000 249,540 1,645
Synchrony Bank #87164WZN1 04/03/20 04/04/22 1.350%1.350%245,000 249,562 1,626
Wells Fargo #95001DAB6 06/17/20 06/17/23 1.200%1.200%245,000 244,152 106
Total Certificates of Deposits $5,145,000 $5,206,330 $25,426
Total J.P.Morgan Securities $23,347,709 $23,620,275 $155,342
*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
September 30, 2020
Cash & Investments by Fund - Total $45.3 million
Cash & Investments by Type - Total $45.3 million
Checking
Illinois Funds
Certificates of Deposit
Municipal Bonds
Corporate Bonds
Government & Agency Obligations
Accrued Interest
General Corporate
47.2%
Hotel/Motel Tax
10.3%Motor Fuel Tax
1.8%
Infrastructure
17.4%
Promenade TIF
0.5%
Water
17.6%
Sports Core
1.0%
Golf Surcharge
0.3%
Self-Insurance
1.0%Garage
0.8%
Equipment
Replacement
2.1%
Checking, $2.2
Illinois Funds, $19.6
Certificates of Deposit,
$5.1
Municipal Bonds, $7.8
Corporate Bonds, $8.7
Government & Agency
Obligations, $1.8
Accrued Interest, $0.1
in millions
YTD YTD
Net Fund Budgeted
YTD YTD Increase Increase
Governmental Funds Revenues Expenditures (Decrease)(Decrease)
General Fund (Major Fund)17,219,560$ 17,359,431$ (139,871)$ 550,745$
Main operating fund of the Village.
Hotel Fund (Major Fund)470,449$ 721,685$ (251,236)$ (148,665)$
Collects and spends resources from the
3% hotel/motel tax.
Motor Fuel Tax Fund 400,584$ 666,994$ (266,410)$ (611,015)$
Collects and spends resources from the
State motor fuel tax.
Infrastructure Fund (Major Fund)4,585,302$ 4,506,756$ 78,546$ (4,851,615)$
Accounts for construction and maintenance of
roadways, drainage, and safety path systems.
Promenade TIF Fund (Major Fund)456,658$ 534,028$ (77,370)$ (56,415)$
Accounts for the revenues and expenditures
restricted to the Tax Increment Financing (TIF)
district located at 22nd St. and Meyers Rd.
Enterprise Funds
Water Fund (Major Fund)7,902,112$ 5,818,383$ 2,083,729$ (1,426,825)$
Collects user fees for the distribution of water
and maintenance of infrastructure.
Sports Core Fund (Major Fund)3,109,091$ 2,819,391$ 289,700$ 211,735$
Accounts for revenues and expenses relating
to administration, programs, food and beverage
operations, and golf course.
Golf Surcharge Fund 100,968$ 323,373$ (222,405)$ (299,110)$
Accounts for the collection of the $3 per round
golf surcharge.
Internal Service Funds
Self Insurance Fund 2,640,053$ 2,314,814$ 325,239$ 3,375$
Accounts for the Village's health insurance costs
and the related contributions from the Village,
employees, retirees, and other agencies.
Garage Fund 539,050$ 500,206$ 38,844$ (38,205)$
Accounts for the maintenance of the Village's vehicle
fleet and the related departmental reimbursements.
Equipment Replacement Fund 248,062$ 110,072$ 137,990$ 31,065$
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 September 30, 2020
Village of Oak Brook
Monthly Financial Report – Fund Narrative
For the Period Ending September 30, 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 September 2020 are $3,407,697, or 16.9%, lower than last September
and $2,538,911, or 13.2%, under budget to date. The main drivers for this are:
o Sales tax revenue, the General
Fund’s largest revenue source, is
down $1,228,260 from last year
and $1,180,856 under budget.
September 2020 collections are
down compared to collections
the previous five years. The
decline is related to the COVID-
19 pandemic, which saw
numerous businesses close in
March through much of June.
o Telecommunications/Utility Tax is down $251,414 from last year and $207,151 under
budget. This is due to a decrease in usage from the closure of businesses during the
pandemic.
o Licenses and permits revenue is down $1,690,797 from last year and $882,533 under
budget. This is due to the timing of permits being issued vs. when originally planned.
Permit revenue is still expected to be strong in 2020 with the Hines Oak Brook
Commons kicking off shortly.
o Charges for Services revenue is down $314,327 from last year and $242,508 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 September 2020 are $690,467, or 3.9%, lower than last year and
$1,411,936, or 7.7%, under budget to date. The main drivers for this are:
o Personnel expenditures are up $396,004 from last year, but $396,004 under budget.
The increase is due to a combination of annual pay increases and final accrual payouts
from three retirements. Personnel is under budget due to the start of furlough days and
a reduction in overtime due to the COVID-19 pandemic.
o Operation and contract expenditures are down $452,983 from last year and $496,775
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 $628,115 from last year and $453,844 under
budget. Many capital items have been put on hold for 2020 due to the current
economic state.
Hotel Tax Fund
Total revenues through September 2020 are $577,936, or 55.1%, lower than last year and
$477,101, or 50.4%, under budget. The main drivers for this are:
o Hotel tax revenue is down $552,249 from last year and $480,898 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 September 2020 are $219,500, or 49.2%, higher than last year, but
$207,214, or 23.7%, under budget. The main drivers for this are:
o Operation and contract expenditures are down $70,157 from last year and $235,789
under budget. This is due to the timing of advertising payments and the cancelling of
some campaigns. In addition, the Village rebated $70,013 of hotel tax related to
January, February, and March stays back to the hotels.
o Capital Outlay expenditures are up $289,657 from last year and $28,575 over budget.
The street light replacements began earlier than originally projected.
Infrastructure Fund
Total revenues through September 2020 are down $800,555, or 18.0%, from last year and
$678,909, or 15.7%, under budget. The main drivers for this are:
o Non-home rule sales tax revenue
is down $697,771 from last year
and $654,465 under budget.
September 2020 collections are
down 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
$102,154 from last year and $22,124 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 September 2020 are down $474,253 or 9.8%, from last year and
$5,925,124, or 57.5%, under budget to date. The main drivers for this are:
o Operation and contract expenditures are down $129,736 from last year and $431,570
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 $360,933 from last year and $5,436,714 under
budget. The majority of budgeted projects have not occurred to date and may be
delayed until later in the year or 2021.
Promenade TIF Fund
Total revenues through September 2020 are up $3,991, or 0.9% from last year and $4,283, or
0.9%, over budget. The timing of sales tax transfers has changed in 2020 due to information
being more readily available from IDOR, resulting in an increase. Real estate tax revenue
increased slightly in 2020 compared to last year. Interest rates have dropped in recent months
compared to last year, resulting in a decrease in interest income.
Total expenditures through September 2020 are up $69,300, or 14.9%, from last year and
$25,238, or 5.0%, 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 September 2020 are down $71,133, or 0.9%, from last year and
$436,058, or 5.2%, under budget. The main drivers for this are:
o Water sales revenue is up $154,547 from last year, but $351,062 under budget. The
decrease in water sales relates to the business shut down from the COVID-19 pandemic.
o Water connection fees are down $148,990 from last year and $57,275 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 September 2020 are down $1,123,169, or 17.2%, from last year and
$3,946,621, or 42.1%, under budget. The main drivers for this are:
o Operation and contract expenditures are down $23,551 from last year and $897,902
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 $1,055,965 from last year and $2,946,919 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 September 2020 are down $667,796, or 21.5%, from last year and
$902,139, or 27.0%, under budget to date. Most revenue sources are under budget to date in
2020 due to the COVID-19 pandemic limiting activity. Starting in 2020, the Park District took
over all Bath and Tennis Club membership sales, however, this was not factored into the 2020
budget due to the timing of the agreement. Highlights of Sports core revenues are:
o Membership revenue is down $194,794 from last year and $234,248 under budget. This
is due to a change in swimming and tennis memberships being taken over by the Park
District rather than the Village. Golf memberships are up $27,013 from last year and
$7,188 over budget to date.
o Greens Fees are up $76,861 from last year and $59,396 over budget. The golf course
was open on a limited basis until June 1, but has made up nearly all the lost rounds
since.
o Rental income is down $341,577 from last year and $378,210 under budget. This is due
to many events being cancelled this year at the B&T Clubhouse. In addition, golf cart
rental fees are under budget due to the course being closed in the spring.
Total expenditures through September 2020 are down $768,265, or 21.7%, from last year and
$1,528,135, or 35.5%, under budget to date. The main drivers for this are:
o Personnel expenditures are down $165,418 from last year and $171,169 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 $43,128 from last year and $70,021 under
budget. Expenditures are down due to facilities being closed for much of the spring.
o Operation and Contractual expenditures are down $503,882 from last year and
$639,256 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 down $55,837 from last year and $730,839 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.
9/30/20 9/30/20
9/30/19 9/30/20 YTD % of YTD 2020 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 9,431,654$ 8,203,394$ 9,384,250$ 87.4%12,502,000$ (1,228,260)$
Other Intergovernmental Tax*1,122,891 1,180,383 1,070,850 110.2%1,352,000 57,492
Telecommunications/Utility Tax 4,730,763 4,479,349 4,686,500 95.6%6,125,000 (251,414)
Licenses and Permits 3,076,334 1,385,537 2,268,070 61.1%2,990,190 (1,690,797)
Charges for Services 987,379 673,052 915,560 73.5%1,253,100 (314,327)
Fines and Penalties 171,046 130,521 144,000 90.6%192,000 (40,525)
Administrative Towing Fees 16,042 13,743 14,985 91.7%20,000 (2,299)
Investment Interest 347,294 285,929 311,265 91.9%415,000 (61,365)
Franchise Fees 106,424 101,907 157,500 64.7%210,000 (4,517)
Miscellaneous Income 167,639 295,954 335,700 88.2%443,095 128,315
Total Operating Revenues 20,157,466$ 16,749,769$ 19,288,680$ 86.8%25,502,385$ (3,407,697)$
OPERATING EXPENDITURES
Personnel 13,459,378$ 13,855,382$ 14,224,125$ 97.4%19,160,220$ 396,004$
Materials and Supplies 332,173 329,762 419,400 78.6%539,170 (2,411)
Operation and Contract 3,047,953 2,594,970 3,091,745 83.9%4,071,660 (452,983)
Other Expenditures 7,336 4,374 7,310 59.8%10,000 (2,962)
Capital Outlay 771,866 143,751 597,595 24.1%688,030 (628,115)
Total Operating Expenditures 17,618,706$ 16,928,239$ 18,340,175$ 92.3%24,469,080$ (690,467)$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 2,538,760$ (178,470)$ 948,505$ 1,033,305$ (2,717,230)$
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 474,156 469,791 469,800 100.0%626,395 (4,365)
Reimbursements To Other Funds (98,325) (104,823) (104,805) 100.0%(139,770) (6,498)
Total Interfund Transactions 549,863$ 38,599$ (397,760)$ -9.7%(436,375)$ (511,264)$
NET FUND INCREASE (DECREASE)3,088,623$ (139,871)$ 550,745$ 596,930$ (3,228,494)$
*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 September 30, 2020
Total Total
Revenues Expenditures
9/30/20 Actual 16,749,769$ 16,928,239$
9/30/19 Actual 20,157,466$ 17,618,706$
% Change From Last Year -16.9%-3.9%
Major Revenues
Other Telecom/Utility Licenses &Charges for
Sales Tax Intergov. Tax Tax Permits Services
9/30/20 Actual 8,203,394$ 1,180,383$ 4,479,349$ 1,385,537$ 673,052$
9/30/19 Actual $ 9,431,654 $ 1,122,891 $ 4,730,763 $ 3,076,334 $ 987,379
% Change From Last Year -13.0%5.1%-5.3%-55.0%-31.8%
Five Year Trend
Major Expenditures Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
9/30/20 Actual 13,855,382$ 329,762$ 2,594,970$ 4,374$ 143,751$
9/30/19 Actual 13,459,378$ 332,173$ 3,047,953$ 7,336$ 771,866$
% Change From Last Year 2.9%-0.7%-14.9%-40.4%-81.4%
Five Year Trend
Expenditures by Department
9/30/19 9/30/20 9/30/20 9/30/20 2020 Difference Five
YTD YTD YTD % of Annual Prior Year
Department Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 1,762,145$ 1,560,892$ 1,951,730$ 80.0%2,556,835$ (201,253)$
Financial Services 563,549 568,830 589,570 96.5%781,455 5,281
Public Works 665,464 548,311 678,080 80.9%893,055 (117,153)
Engineering & Capital Projects 393,984 37,699 381,050 9.9%411,500 (356,285)
Library 691,918 608,154 743,535 81.8%994,410 (83,764)
Police 6,755,879 6,715,622 7,031,015 95.5%9,493,905 (40,257)
Fire 6,072,142 6,113,322 6,200,425 98.6%8,298,370 41,180
Development Services 713,625 775,409 764,770 101.4%1,039,550 61,784
Total Expenditures 17,618,706$ 16,928,239$ 18,340,175$ 92.3%24,469,080$ (690,467)$
Five Year Trend
For the Period Ending September 30, 2020
General Fund - Five Year Trend
Village of Oak Brook
Revenues Expenditures
9/30/20 9/30/20
9/30/19 9/30/20 YTD % of YTD 2020 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Hotel Tax 962,651$ 410,402$ 891,300$ 46.0%1,212,500$ (552,249)$
Investment Interest 85,734 55,880 56,250 99.3%75,000 (29,854)
Loan Interest - 4,167 - N/A - 4,167
Total Operating Revenues 1,048,385$ 470,449$ 947,550$ 49.6%1,287,500$ (577,936)$
EXPENDITURES
Operation and Contract 376,838$ 306,681$ 542,470$ 56.5%576,615$ (70,157)$
Capital Outlay 69,313 358,970 330,395 108.6%640,395 289,657
Total Expenditures 446,151$ 665,651$ 872,865$ 76.3%1,217,010$ 219,500$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 602,234$ (195,202)$ 74,685$ -261.4%70,490$ (797,436)$
INTERFUND TRANSACTIONS
Transfer Out -$ -$ (167,325)$ 0.0%(338,125)$ -$
Reimbursements to Other Funds (77,337) (56,034) (56,025) 100.0%(74,715) 21,303
Total Interfund Transactions (77,337)$ (56,034)$ (223,350)$ 25.1%(412,840)$ 21,303$
NET FUND INCREASE (DECREASE)524,897$ (251,236)$ (148,665)$ (342,350)$ (776,133)$
Note - Expenditures are recorded in program 171.
Village of Oak Brook
Hotel Tax Fund Financial Update
For the Period Ending September 30, 2020
Total Total
Revenues Expenditures
9/30/20 Actual $ 470,449 665,651$
9/30/19 Actual $ 1,048,385 446,151$
% Change From Last Year -55.1%49.2%
Major Revenues Investment
Hotel Tax Interest Loan Interest Miscellaneous
9/30/20 Actual $ 410,402 $ 55,880 4,167$ -$
9/30/19 Actual $ 962,651 $ 85,734 -$ -$
% Change From Last Year -57.4%-34.8%N/A 0.0%
Five Year Trend
Major Expenditures Operation &
Contractual Capital Outlay
9/30/20 Actual 306,681$ 358,970$
9/30/19 Actual 376,838$ 69,313$
% Change From Last Year -18.6%N/A
Five Year Trend
Village of Oak Brook
Hotel Tax Fund - Major Sources Five Year Trend
For the Period Ending September 30, 2020
Five Year Trend
Revenues Expenditures
9/30/20 9/30/20
9/30/19 9/30/20 YTD % of YTD 2020 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 4,275,306$ 3,577,535$ 4,232,000$ 84.5%5,615,000$ (697,771)$
Charges for Services 965 335 765 43.8%1,000 (630)
Investment Interest 173,765 71,611 93,735 76.4%125,000 (102,154)
Miscellaneous - - 1,890 0.0%2,500 -
Total Operating Revenues 4,450,036$ 3,649,481$ 4,328,390$ 84.3%5,743,500$ (800,555)$
OPERATING EXPENDITURES
Personnel 972,678$ 963,138$ 1,020,575$ 94.4%1,389,540$ (9,540)$
Materials and Supplies 104,891 130,847 130,250 100.5%253,295 25,956
Operation and Contract 1,111,876 982,140 1,413,710 69.5%1,856,790 (129,736)
Capital Outlay 2,669,839 2,308,906 7,745,620 29.8%10,220,090 (360,933)
Total Operating Expenditures 4,859,284$ 4,385,031$ 10,310,155$ 42.5%13,719,715$ (474,253)$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES (409,248)$ (735,550)$ (5,981,765)$ 12.3%(7,976,215)$ (326,302)$
INTERFUND TRANSACTIONS
Transfers In 216,125$ 666,289$ 982,325$ 67.8%1,653,125$ 450,164$
Reimbursements From Other Funds 250,083 269,532 269,550 100.0%359,380 19,449
Reimbursements To Other Funds (121,149) (121,725) (121,725) 100.0%(162,300) (576)
Total Interfund Transactions 345,059$ 814,096$ 1,130,150$ 72.0%1,850,205$ 469,037$
NET FUND INCREASE (DECREASE)(64,189)$ 78,546$ (4,851,615)$ (6,126,010)$ 142,735$
Village of Oak Brook
Infrastructure Fund Financial Update
For the Period Ending September 30, 2020
Total Total
Revenues Expenditures
9/30/20 Actual $ 3,649,481 4,385,031$
9/30/19 Actual $ 4,450,036 4,859,284$
% Change From Last Year -18.0%-9.8%
Major Revenues
Sales Tax
Charges for
Services
Investment
Interest Miscellaneous
9/30/20 Actual $ 3,577,535 $ 335 $ 71,611 $ -
9/30/19 Actual $ 4,275,306 $ 965 $ 173,765 $ -
% Change From Last Year -16.3%-65.3%-58.8%0.0%
Five Year Trend
Major Expenditures Materials &Operation &
Personnel Supplies Contractual Capital Outlay
9/30/20 Actual 963,138$ 130,847$ 982,140$ 2,308,906$
9/30/19 Actual 972,678$ 104,891$ 1,111,876$ 2,669,839$
% Change From Last Year -1.0%24.7%-11.7%-13.5%
Five Year Trend
Expenditures by Department
9/30/19 9/30/20 9/30/20 9/30/20 2020 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 120,137$ 106,334$ 130,355$ 81.6%176,490$ (13,803)$
Public Works 3,001,755 3,036,276 3,728,715 81.4%4,390,810 34,521
Engineering & Capital Projects 1,737,392 1,242,421 6,451,085 19.3%9,152,415 (494,971)
Total Expenditures 4,859,284$ 4,385,031$ 10,310,155$ 42.5%13,719,715$ (474,253)$
Five Year Trend
Village of Oak Brook
Infrastructure Fund - Major Sources Five Year Trend
For the Period Ending September 30, 2020
Revenues Expenditures
9/30/20 9/30/20
9/30/19 9/30/20 YTD % of YTD 2020 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 39,820$ 41,624$ 71,250$ 58.4%95,000$ 1,804$
Real Estate Tax 411,687 414,544 380,000 109.1%380,000 2,857
Investment Interest 1,160 490 1,125 43.6%1,500 (670)
Total Operating Revenues 452,667$ 456,658$ 452,375$ 100.9%476,500$ 3,991$
EXPENDITURES
Operation and Contract 3,748$ 4,128$ 3,890$ 106.1%3,890$ 380$
Other Expenditures 460,980 529,900 504,900 105.0%504,900 68,920
Total Expenditures 464,728$ 534,028$ 508,790$ 105.0%508,790$ 69,300$
NET FUND INCREASE (DECREASE)(12,061)$ (77,370)$ (56,415)$ (32,290)$ (65,309)$
Note - Expenditures are recorded in program 283.
Village of Oak Brook
Promenade TIF Fund Financial Update
For the Period Ending September 30, 2020
Total Total
Revenues Expenditures
9/30/20 Actual $ 456,658 534,028$
9/30/19 Actual $ 452,667 464,728$
% Change From Last Year 0.9%14.9%
Major Revenues Real Estate Investment
Sales Tax Tax Interest
9/30/20 Actual 41,624$ $ 414,544 $ 490
9/30/19 Actual 39,820$ $ 411,687 $ 1,160
% Change From Last Year 4.5%0.7%-57.8%
Five Year Trend
Major Expenditures Operation &Other
Contractual Expenditures
9/30/20 Actual 4,128$ 529,900$
9/30/19 Actual 3,748$ 460,980$
% Change From Last Year 10.1%15.0%
Five Year Trend
Village of Oak Brook
Promenade TIF Fund - Major Sources Five Year Trend
For the Period Ending September 30, 2020
Five Year Trend
Revenues Expenditures
9/30/20 9/30/20
9/30/19 9/30/20 YTD % of YTD 2020 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Plan Review Fees 1,125$ 675$ 900$ 75.0%1,200$ (450)$
Building/Inspection Fees 5,963 5,512 5,985 92.1%8,000 (451)
Water Sales 7,544,391 7,698,938 8,050,000 95.6%10,302,525 154,547
Unmetered Sales 32,297 60,901 22,500 270.7%30,000 28,604
Water Connection Fees 166,730 17,740 75,015 23.6%100,000 (148,990)
Meter Charges 24,017 7,737 15,005 51.6%20,000 (16,280)
Special Services 16,772 12,657 15,000 84.4%30,000 (4,115)
Investment Interest 134,870 77,999 97,515 80.0%130,000 (56,871)
Miscellaneous 47,080 19,953 56,250 35.5%75,000 (27,127)
Total Operating Revenues 7,973,245$ 7,902,112$ 8,338,170$ 94.8%10,696,725$ (71,133)$
OPERATING EXPENDITURES
Personnel 593,927$ 571,660$ 644,000$ 88.8%868,705$ (22,267)$
Materials and Supplies 47,671 26,285 55,745 47.2%74,260 (21,386)
Operation and Contract 3,500,804 3,477,253 4,375,155 79.5%5,833,755 (23,551)
Capital Outlay 2,404,041 1,348,076 4,294,995 31.4%6,293,225 (1,055,965)
Total Expenditures 6,546,443$ 5,423,274$ 9,369,895$ 57.9%13,069,945$ (1,123,169)$
Surplus (Deficit) of Revenues Over
Expenditures 1,426,802$ 2,478,838$ (1,031,725)$ -240.3%(2,373,220)$ 1,052,036$
INTERFUND TRANSACTIONS
Transfers In 221,085$ -$ -$ 0.0%-$ (221,085)
Reimbursements To Other Funds (413,874) (395,109) (395,100) 100.0%(526,815) 18,765
Total Interfund Transactions (192,789)$ (395,109)$ (395,100)$ 100.0%(526,815)$ (202,320)$
Fund Increase/(Decrease) - Budgetary Basis 1,234,013$ 2,083,729$ (1,426,825)$ -146.0%(2,900,035)$ 849,716$
ADUSTMENTS TO GAAP BASIS*
Remove Capital Outlay 2,404,041$ 1,348,076$
Depreciation Expense (341,403) (383,333)
IMRF Pension Expense 51,491 33,333
OPEB Expense (32,683) (30,000)
Total GAAP Adjustments 2,081,445$ 968,076$
Fund Increase/(Decrease) - GAAP Basis 3,315,458$ 3,051,805$
*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 September 30, 2020
Total Total
Revenues Expenditures
9/30/20 Actual $ 7,902,112 5,423,274$
9/30/19 Actual $ 7,973,245 6,546,443$
% Change From Last Year -0.9%-17.2%
Unmetered Water
Water Sales Sales Connection Fees Meter Charges Miscellaneous
9/30/20 Actual $ 7,698,938 $ 60,901 $ 17,740 $ 7,737 $ 19,953
9/30/19 Actual $ 7,544,391 $ 32,297 $ 166,730 $ 24,017 $ 47,080
% Change From Last Year 2.0%88.6%-89.4%-67.8%-57.6%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
9/30/20 Actual 571,660$ 26,285$ 3,477,253$ -$ 1,348,076$
9/30/19 Actual 593,927$ 47,671$ 3,500,804$ -$ 2,404,041$
% Change From Last Year -3.7%-44.9%-0.7%0.0%-43.9%
Five Year Trend
Expenditures by Department
9/30/19 9/30/20 9/30/20 9/30/20 2020 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Public Works 4,135,336$ 4,106,456$ 4,887,710$ 84.0%6,527,120$ (28,880)$
Engineering & Capital Projects 2,411,107 1,316,818 4,482,185 29.4%6,542,825 (1,094,289)
Total Expenditures 6,546,443$ 5,423,274$ 9,369,895$ 57.9%13,069,945$ (1,123,169)$
Five Year Trend
Village of Oak Brook
Water Fund - Major Sources Five Year Trend
For the Period Ending September 30, 2020
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Sports Core Fund Consolidated Presentation
For the Period Ending September 30, 2020
9/30/20 9/30/20
9/30/20 YTD % of YTD 2020 9/30/19 Difference
B&T Recreation Field Clubhouse Golf YTD Amended Amended Adopted YTD Prior
Operations Operations Operations Club Total Budget Budget Budget Total Year
OPERATING REVENUES
Memberships 199$ -$ -$ 224,688$ 224,887$ 459,135$ 49.0%459,135$ 419,681$ (194,794)$
Greens Fees - - - 924,396 924,396 865,000 106.9%930,000 847,535 76,861
Pro Shop Sales - - - 150,297 150,297 192,500 78.1%207,000 184,751 (34,454)
Golf Lessons - - - 45,245 45,245 40,000 113.1%40,000 33,606 11,639
Driving Range Fees - - - 236,386 236,386 241,000 98.1%244,000 235,664 722
Rentals - 97,540 19,989 300,591 418,120 796,330 52.5%962,000 759,697 (341,577)
Programs/User Fees - - - - - 61,000 0.0%66,300 66,318 (66,318)
Food Sales - - - 131,392 131,392 167,945 78.2%180,500 170,499 (39,107)
Beverage Sales - - - 298,247 298,247 244,015 122.2%265,000 250,685 47,562
Taste of Oak Brook - - - - - 120,000 0.0%120,000 - -
Grants - - - - - 139,800 0.0%139,800 - -
Other Revenue 1,139 - - 5,237 6,376 10,760 59.3%11,000 134,706 (128,330)
Total Operating Revenues 1,338$ 97,540$ 19,989$ 2,316,479$ 2,435,346$ 3,337,485$ 73.0%3,624,735$ 3,103,142$ (667,796)$
OPERATING EXPENDITURES
Personnel 40,255$ -$ 80,232$ 974,934$ 1,095,421$ 1,266,590$ 86.5%1,578,100$ 1,260,839$ (165,418)$
Materials & Supplies 3,545 119 1,540 472,420 477,624 547,645 87.2%618,025 520,752 (43,128)
Operational & Contractual 40,349 22,854 39,397 235,749 338,349 977,605 34.6%1,055,095 842,231 (503,882)
Other - - - - - (83,150) 0.0%(83,150) - -
Capital 362,998 9,421 36,215 457,027 865,661 1,596,500 54.2%1,921,545 921,498 (55,837)
Total Operating Expenditures 447,147$ 32,394$ 157,384$ 2,140,130$ 2,777,055$ 4,305,190$ 64.5%5,089,615$ 3,545,320$ (768,265)$
B&T Administration Overhead Allocation*63,054$ -$ (63,054)$ -$ -$ -$ 0.0%-$ -$ -$
Operating Revenues Over (Under) Expenditures (382,755)$ 65,146$ (200,449)$ 176,349$ (341,709)$ (967,705)$ 35.3%(1,464,880)$ (442,178)$ 100,469$
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 18,000 - - - 18,000 18,000 100.0%24,000 18,000 -
Reimbursement From Water Fund 6,003 - - - 6,003 5,985 100.3%8,000 6,003 -
Reimbursement To General Fund (21,168) - - (21,168) (42,336) (42,300) 100.1%(56,450) - (42,336)
Total Interfund Transactions 329,204$ -$ -$ 302,205$ 631,409$ 1,179,440$ 53.5%1,333,550$ 571,175$ 60,234$
Total Revenues Over (Under) Expenditures - Budgetary Basis (53,551)$ 65,146$ (200,449)$ 478,554$ 289,700$ 211,735$ (131,330)$ 128,997$ 160,703$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay 362,998$ 9,421$ 36,215$ 457,027$ 865,661$ 921,498$
Depreciation Expense (112,427) (1,264) (26,250) (159,000) (298,941) (246,292)
IMRF Pension Expense (3,938) (188) (1,500) (8,888) (14,513) 69,578
OPEB Expense - - (3,900) (30,000) (33,900) (15,026)
Total GAAP Adjustments 246,633$ 7,970$ 4,565$ 259,140$ 518,308$ 729,758$
Fund Increase/(Decrease) - GAAP Basis 193,082$ 73,116$ (195,884)$ 737,694$ 808,008$ 858,755$
*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
9/30/20 Actual $ 2,435,346 2,777,055$
9/30/19 Actual $ 3,103,142 3,545,320$
% Change From Last Year -21.5%-21.7%
Driving Program/
Memberships Greens Fees Range Fees Rentals User Fees
9/30/20 Actual $ 224,887 $ 924,396 $ 236,386 $ 418,120 -$
9/30/19 Actual $ 419,681 $ 847,535 $ 235,664 $ 759,697 66,318$
% Change From Last Year -46.4%9.1%0.3%-45.0%-100.0%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
9/30/20 Actual 1,095,421$ 477,624$ 338,349$ -$ 865,661$
9/30/19 Actual 1,260,839$ 520,752$ 842,231$ -$ 921,498$
% Change From Last Year -13.1%-8.3%-59.8%0.0%-6.1%
Five Year Trend
Revenues by Department 9/30/19 9/30/20 9/30/20 9/30/20 2020 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Operations 354,510$ 1,338$ 501,195$ 0.3%506,735$ (298,263)$
Open Field Operations 322,173 97,540 371,355 26.3%407,000 (224,633)
B&T Clubhouse Operations 250,316 19,989 205,000 9.8%300,000 (230,327)
Golf Club 2,176,143 2,316,479 2,259,935 102.5%2,411,000 140,336
Total Revenues 3,103,142$ 2,435,346$ 3,337,485$ 73.0%3,624,735$ (612,887)$
Expenditures by Department 9/30/19 9/30/20 9/30/20 % of YTD 2020 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Operations 848,693$ 447,147$ 1,427,465$ 31.3%1,752,045$ (401,546)$
Open Field Operations 139,076$ 32,394$ 258,980$ 12.5%267,110$ (106,682)$
B&T Clubhouse Operations 544,885 157,384 397,925 39.6%458,770 (387,501)
Golf Club 2,012,666 2,140,130 2,220,820 96.4%2,611,690 127,464
Total Expenditures 3,545,320$ 2,777,055$ 4,305,190$ 64.5%5,089,615$ (768,265)$
Five Year Trend
Village of Oak Brook
Sports Core Fund - Major Sources Five Year Trend
For the Period Ending September 30, 2020
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Bath & Tennis Club Recreation Operations
For the Period Ending September 30, 2020 9/30/20 9/30/20
822 9/30/20 YTD % of YTD 2020 9/30/19 Difference
811 812 813 Poolside YTD Amended Amended Adopted YTD Prior
B&T Admin Swimming Tennis Café Total Budget Budget Budget Total Year
OPERATING REVENUES
Memberships -$ 199$ -$ -$ 199$ 241,635$ 0.1%241,635$ 222,006$ (221,807)$
Programs/User Fees - - - - - 61,000 0.0%66,300 66,318 (66,318)
Food Sales - - - - - 36,000 0.0%36,000 35,375 -
Beverage Sales - - - - - 20,000 0.0%20,000 19,534 -
Grants - - - - - 139,800 0.0%139,800 - -
Other Revenue 1,139 - - - 1,139 2,760 41.3%3,000 11,277 (10,138)
Total Operating Revenues 1,139$ 199$ -$ -$ 1,338$ 501,195$ 0.3%506,735$ 354,510$ (298,263)$
OPERATING EXPENDITURES
Personnel 39,939$ -$ -$ 316$ 40,255$ 156,585$ 25.7%163,580$ 135,115$ (94,860)$
Materials & Supplies 345 2,165 1,035 - 3,545 56,950 6.2%57,650 70,005 (66,460)
Operational & Contractual 29,260 5,060 6,029 - 40,349 401,430 10.1%418,270 389,792 (349,443)
Capital 36,535 326,369 94 - 362,998 812,500 44.7%1,112,545 253,781 109,217
Total Operating Expenditures 106,079$ 333,594$ 7,158$ 316$ 447,147$ 1,427,465$ 31.3%1,752,045$ 848,693$ (401,546)$
B&T Administration Overhead Allocation*126,108$ (45,399)$ (12,611)$ (5,044)$ 63,054$ 87,370$ 72.2%93,235$ 98,139$ (35,085)$
Operating Revenues Over (Under) Expenditures 21,168$ (378,794)$ (19,769)$ (5,360)$ (382,755)$ (838,900)$ 45.6%(1,152,075)$ (396,044)$ 68,198$
INTERFUND TRANSACTIONS
Transfer From General Fund -$ 326,369$ -$ -$ 326,369$ 597,255$ 54.6%757,500$ 48,704$ 277,665$
Reimbursement From Infrastructure Fund 18,000 - - - 18,000 18,000 100.0%24,000 18,000 -
Reimbursement From Water Fund 6,003 - - - 6,003 5,985 100.3%8,000 6,003 -
Reimbursement To General Fund (21,168) - - - (21,168) (21,150) 100.1%(28,225) - (21,168)
Total Interfund Transactions 2,835$ 326,369$ -$ -$ 329,204$ 600,090$ 54.9%761,275$ 72,707$ 256,497$
Total Revenues Over (Under) Expenditures - Budgetary Basis 24,003$ (52,425)$ (19,769)$ (5,360)$ (53,551)$ (238,810)$ (390,800)$ (323,337)$ 324,695$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay 36,535$ 326,369$ 94$ -$ 362,998$ 253,781$
Depreciation Expense - (107,801) (3,750) (876) (112,427) (71,118)
IMRF Pension Expense (3,750) - - (188) (3,938) 4,574
Total GAAP Adjustments 32,785$ 218,568$ (3,656)$ (1,064)$ 246,633$ 187,237$
Fund Increase/(Decrease) - GAAP Basis 56,788$ 166,143$ (23,425)$ (6,424)$ 193,082$ (136,100)$
*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 September 30, 2020 9/30/20 9/30/20
9/30/20 YTD % of YTD 2020 9/30/19 Difference
815 816 YTD Amended Amended Adopted YTD Prior
Polo Open Fields Total Budget Budget Budget Total Year
OPERATING REVENUES
Field Rentals -$ 22,540$ 22,540$ 176,355$ 12.8%212,000$ 132,433$ (109,893)$
Range Rentals - 75,000 75,000 75,000 100.0%75,000 75,000 -
Taste of Oak Brook - - - 120,000 0.0%120,000 - -
Other Revenue - - - - 0.0%- 114,740 (114,740)
Total Operating Revenues -$ 97,540$ 97,540$ 371,355$ 26.3%407,000$ 322,173$ (224,633)$
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 - 22,854 22,854 236,975 9.6%239,600 123,431 (100,577)
Capital - 9,421 9,421 15,000 62.8%15,000 11,683 (2,262)
Total Operating Expenditures -$ 32,394$ 32,394$ 258,980$ 12.5%267,110$ 139,076$ (106,682)$
Operating Revenues Over (Under) Expenditures -$ 65,146$ 65,146$ 112,375$ 58.0%139,890$ 183,097$ (117,951)$
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 -$ 65,146$ 65,146$ 147,375$ 174,890$ 183,097$ (117,951)$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay -$ 9,421$ 9,421$ 11,683$
Depreciation Expense - (1,264) (1,264) (1,264)
IMRF Pension Expense - (188) (188) 551
Total GAAP Adjustments -$ 7,970$ 7,970$ 10,971$
Fund Increase/(Decrease) - GAAP Basis -$ 73,116$ 73,116$ 194,068$
*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 September 30, 2020
9/30/20 9/30/20
821 YTD % of YTD 2020 9/30/19 Difference
B&T Amended Amended Adopted YTD Prior
Clubhouse Budget Budget Budget Total Year
OPERATING REVENUES
Rentals 19,989$ 205,000$ 9.8%300,000$ 250,316$ (230,327)$
Total Operating Revenues 19,989$ 205,000$ 9.8%300,000$ 250,316$ (230,327)$
OPERATING EXPENDITURES
Personnel 80,232$ 104,715$ 76.6%140,045$ 99,571$ (19,339)$
Materials & Supplies 1,540 15,840 9.7%20,225 19,072 (17,532)
Operational & Contractual 39,397 88,370 44.6%109,500 72,115 (32,718)
Capital 36,215 189,000 19.2%189,000 354,127 (317,912)
Total Operating Expenditures 157,384$ 397,925$ 39.6%458,770$ 544,885$ (387,501)$
B&T Administration Overhead Allocation*(63,054)$ (87,370)$ 72.2%(93,235)$ (98,139)$ 35,085$
Operating Revenues Over (Under) Expenditures (200,449)$ (280,295)$ 71.5%(252,005)$ (392,708)$ 192,259$
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 (200,449)$ (114,795)$ (86,505)$ (107,209)$ (93,240)$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay 36,215$ 354,127$
Depreciation Expense (26,250) (24,113)
IMRF Pension Expense (1,500) 5,024
OPEB Expense (3,900) (1,575)
Total GAAP Adjustments 4,565$ 333,463$
Fund Increase/(Decrease) - GAAP Basis (195,884)$ 226,254$
*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 September 30, 2020
9/30/20 9/30/20
823 831 832 833 834 9/30/20 YTD % of YTD 2020 9/30/19 Difference
Golf Golf General Golf Learning Golf Cart Golf Course YTD Amended Amended Adopted YTD Prior
Café Operation & Practice Operations Maintenance Total Budget Budget Budget Total Year
OPERATING REVENUES
Memberships -$ 224,688$ -$ -$ -$ 224,688$ 217,500$ 103.3%217,500$ 197,675$ 27,013$
Greens Fees - 924,396 - - - 924,396 865,000 106.9%930,000 847,535 76,861
Pro Shop Sales - 150,297 - - - 150,297 192,500 78.1%207,000 184,751 (34,454)
Golf Lessons - - 45,245 - - 45,245 40,000 113.1%40,000 33,606 11,639
Driving Range Fees - - 236,386 - - 236,386 241,000 98.1%244,000 235,664 722
Rentals - 195 - 300,396 - 300,591 339,975 88.4%375,000 301,948 (1,357)
Food Sales 131,392 - - - - 131,392 131,945 99.6%144,500 135,124 (3,732)
Beverage Sales 298,247 - - - - 298,247 224,015 133.1%245,000 231,151 67,096
Other Revenue - 5,237 - - - 5,237 8,000 65.5%8,000 8,689 (3,452)
Total Operating Revenues 429,639$ 1,304,813$ 281,631$ 300,396$ -$ 2,316,479$ 2,259,935$ 102.5%2,411,000$ 2,176,143$ 140,336$
OPERATING EXPENDITURES
Personnel 137,669$ 380,583$ 28,868$ 36,866$ 390,948$ 974,934$ 999,285$ 97.6%1,263,665$ 1,022,191$ (47,257)$
Materials & Supplies 181,149 136,219 11,638 705 142,709 472,420 473,855 99.7%538,450 431,675 40,745
Operational & Contractual 5,081 139,855 121 52,856 37,836 235,749 250,830 94.0%287,725 256,893 (21,144)
Other - - - - - - (83,150) 0.0%(83,150) - -
Capital 12,059 357,261 - - 87,707 457,027 580,000 78.8%605,000 301,907 155,120
Total Operating Expenditures 335,958$ 1,013,918$ 40,627$ 90,427$ 659,200$ 2,140,130$ 2,220,820$ 96.4%2,611,690$ 2,012,666$ 127,464$
Operating Revenues Over (Under) Expenditures 93,681$ 290,895$ 241,004$ 209,969$ (659,200)$ 176,349$ 39,115$ 450.8%(200,690)$ 163,477$ 12,872$
INTERFUND TRANSACTIONS
Transfer from Golf Surcharge -$ 323,373$ -$ -$ -$ 323,373$ 400,000$ 80.8%400,000$ 212,969$ 110,404$
Reimbursement to General Fund - (21,168) - - - (21,168) (21,150) 100.1%(28,225) - (21,168)
Total Interfund Transactions -$ 302,205$ -$ -$ -$ 302,205$ 378,850$ 79.8%371,775$ 212,969$ 89,236$
Total Revenues Over (Under) Expenditures - Budgetary Basis 93,681$ 593,100$ 241,004$ 209,969$ (659,200)$ 478,554$ 417,965$ 171,085$ 376,446$ 102,108$
ADUSTMENTS TO GAAP BASIS*
Remove Capital Outlay 12,059$ 357,261$ -$ -$ 87,707$ 457,027$ 301,907$
Depreciation Expense - (101,250) (3,000) (17,250) (37,500) (159,000) (149,797)
IMRF Pension Expense (1,125) (3,750) (263) - (3,750) (8,888) 59,429
OPEB Expense (2,250) (17,250) - - (10,500) (30,000) (13,451)
Total GAAP Adjustments 8,684$ 235,011$ (3,263)$ (17,250)$ 35,957$ 259,140$ 198,088$
Fund Increase/(Decrease) - GAAP Basis 102,365$ 828,111$ 237,742$ 192,719$ (623,243)$ 737,694$ 574,534$
*Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.