02 - February 2021 Monthly Financial ReportVILLAGE
OAK BROOK
OF
MONTHLY FINANCIAL REPORTS
FEBRUARY 2021
Cash and Investments by Fund:Total
Cash and Cash Pooled Cash and
Fund Equivalents Investments Investments % By Fund
General Corporate $10,300,221 $13,896,146 $24,196,367 53.9%
Hotel/Motel Tax 1,957,683 2,667,000 4,624,683 10.3%
Motor Fuel Tax 680,013 34,308 714,321 1.6%
Infrastructure 5,054,600 2,250,261 7,304,861 16.3%
Promenade TIF 39,069 - 39,069 0.1%
Water 2,918,088 3,702,183 6,620,271 14.8%
Sports Core - - - 0.0%
Golf Surcharge 132,587 - 132,587 0.3%
Self-Insurance 197,661 - 197,661 0.4%
Garage 325,830 - 325,830 0.7%
Equipment Replacement 309,193 406,143 715,336 1.6%
Total $21,914,945 $22,956,041 $44,870,986 100.0%
Change in Cash and Investments by Fund :
Balance at Balance at Year-to-Date Year-to-Date
Fund January 1, 2021 January 31, 2021 Change ($)Change (%)
General Corporate $23,783,014 $24,196,367 $413,353 1.7%
Hotel/Motel Tax 4,476,710 4,624,683 147,973 3.3%
Motor Fuel Tax 628,079 714,321 86,242 13.7%
Infrastructure 7,616,817 7,304,861 (311,956)-4.1%
Promenade TIF 267,300 39,069 (228,231)-85.4%
Water 6,900,169 6,620,271 (279,898)-4.1%
Sports Core 114,133 0 (114,133)-100.0%
Golf Surcharge 132,593 132,587 (6)0.0%
Self-Insurance 0 197,661 197,661 N/A
Garage 298,348 325,830 27,482 9.2%
Equipment Replacement 696,392 715,336 18,944 2.7%
$44,913,555 $44,870,986 ($42,569)-0.1%
Book Bank/Market
Value Value
Cash and Cash Equivalents:
Pooled Checking $150,711 $946,420
Sports Core Checking 65,983 67,657
Pooled IPTIP 21,450,943 21,450,943
Water E-Pay IPTIP 247,308 240,294
$21,914,945 $22,705,314
Pooled Investments:
Investments-Municipal Bonds $10,216,105 $10,275,559
Investments-Corporate Bonds 7,509,164 7,560,249
Government & Agency Obligations 1,422,835 1,451,441
Certificates of Deposit 3,675,000 3,708,337
Accrued Interest 132,937 132,937
Total Pooled Investments $22,956,041 $23,128,523
Total Cash and Investments $44,870,986 $45,833,837
For February, total interest revenue is $28,708 and YTD is $59,599. The total investment yield for the portfolio is:
Pooled
Investments Illinois Funds Total
Last 12 months yield 1.89%0.38%1.20%
The weighted average yield of the current investment portfolio is 1.43%. The IL Funds February average daily rate was 0.077%.
Monthly Treasurer's Report
February 28, 2021
Monthly Treasurer's Report
February 2021
The table below lists the detail investment holdings at J.P. Morgan Securities as of 2/28/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,100 $200,730 $1,552
Bloomingdale Mich Pub Sch Dist #094383FS0 04/26/16 05/01/22 2.710%2.150%503,157 513,150 4,477
Connecticut St GO Bds 2016 #20772J3F7 06/15/17 08/15/21 1.750%2.300%498,784 503,685 336
State of IL #452152P54 10/09/19 11/01/21 5.000%1.870%510,383 513,365 8,082
Anchor Bay Mich Sch #032879TE8 11/01/19 05/01/21 2.320%1.750%715,688 717,445 5,391
Brownsville TX #16405ST9 12/19/19 02/15/22 2.050%2.000%555,253 563,586 348
Laredo TX Waterworks #517039VW0 12/19/19 03/01/24 2.230%2.230%455,000 473,664 5,017
Oakland Univ Mich #673588HJ1 04/29/20 03/01/24 5.000%1.650%323,774 329,152 7,375
Philadelphia PA GO Ref #717813SW0 05/05/20 08/01/22 5.000%1.820%407,341 414,578 1,422
Maryland St DOT #574204WG4 05/06/20 06/15/22 4.350%1.200%270,506 273,481 2,271
University of CA #91412HFK4 07/16/20 05/15/23 0.628%0.628%25,000 25,136 46
Windsor NY Sch Dist #973675EW7 07/23/02 06/17/21 1.500%0.400%476,517 476,463 4,329
Waterford Mich Sch Dist #941468YZ7 08/20/20 08/24/21 4.000%0.301%508,874 508,535 10,591
Weedsport NY Cent Sch Dist #948543KA0 08/21/20 08/20/21 1.000%0.570%501,002 500,290 2,634
Universty of IL #914353YH4 08/31/20 10/01/21 3.000%0.701%253,336 253,750 3,125
New Jersey St #646039UD7 09/20/20 06/01/22 5.000%0.600%501,028 502,336 5,872
Alaska St GO #011770Z72 10/14/2020 8/1/2021 5.000%0.252%178,479 178,504 705
Rio Rancho NM #767175HM7 10/14/2020 5/15/2022 5.000%0.350%195,360 195,639 2,698
Cook, Kane, Lake, & McHenry #216181GL5 10/29/2020 12/15/2022 4.000%0.300%1,092,601 1,093,460 13,886
Miami-Dade Cnty #59333NN90 11/16/2020 12/15/2022 0.375%0.430%734,159 735,250 1,141
Hamilton NY #407741MC8 1/21/2021 5/1/2023 1.000%0.550%206,989 206,650 216
Southern Cal Pub Pwr #84247PHZ7 1/25/2021 4/1/2024 3.608%0.500%1,102,774 1,096,710 5,813
Total Municipal Bonds $10,216,105 $10,275,559 $87,327
Corporate Bonds:
Morgan Stanley #61747WAL3 03/08/19 07/28/21 5.500%3.034%1,060,134 1,072,082 5,133
Citigroup #172967LC3 04/01/19 12/08/21 2.900%2.754%1,001,197 1,018,260 6,122
American Honda #02665WBG5 07/31/19 09/09/21 1.700%2.180%498,782 503,810 4,084
JP Morgan #48128BAB7 09/30/19 01/15/23 2.972%2.337%1,011,518 1,023,680 3,798
American Express #025816CD9 05/05/20 05/20/22 2.750%1.290%508,860 513,855 3,715
Goldman Sachs #38141GGQ1 08/31/20 07/27/21 5.250%0.251%351,982 351,959 1,711
PNC Bank #69349LAK4 12/7/2020 1/30/2023 2.950%0.457%1,068,387 1,067,073 2,508
Wells Fargo #94974BFJ4 12/7/2020 2/13/2023 3.450%0.480%1,469,924 1,472,080 2,265
Comerica Bank #200340AS6 12/23/2020 7/31/2023 3.700%0.500%538,380 537,450 1,542
Total Corporate Bonds $7,509,164 $7,560,249 $30,878
Government & Agency Obligations:
*Government National Mtg Assn #38379UEM4 02/29/16 02/16/51 2.300%2.245%$403,550 $396,585 $798
*Government National Mtg Assn #38381WV96 08/06/19 07/20/54 2.250%2.293%536,032 551,318 894
*Government National Mtg Assn #38380BNV3 12/05/19 06/20/46 2.000%2.112%483,253 503,538 715
Total Government & Agency Obligations:$1,422,835 $1,451,441 $2,407
Certificates of Deposit:
State Bk India NY #8562846A7 01/26/17 01/26/22 2.250%2.250%$245,000 $249,939 $522
Jackson Cnty Bk #466682AP6 08/31/17 03/01/21 1.850%1.850%245,000 245,037 2,266
Comenity Cap Bank #20033AU46 04/15/19 04/15/21 2.500%2.500%245,000 245,786 208
Morgan Stanley #61760AE21 05/30/19 06/01/21 2.400%2.400%245,000 246,524 1,470
First St Bank DeQueen #336460CU2 07/18/19 07/19/21 2.000%2.000%245,000 246,874 163
Bank Hapoalim #06251AW89 07/19/19 07/19/21 2.000%2.000%245,000 246,997 636
Capital One Natl Assn #14042RMF5 07/24/19 07/26/19 2.050%2.050%245,000 247,043 593
TIAA FSB Jacksonville #87270LCN1 07/29/19 07/29/21 2.000%2.000%245,000 247,031 416
Wells Fargo #949763J31 09/18/19 09/20/21 1.850%1.850%245,000 247,475 165
BMW Bank #05580ASQ8 10/11/19 10/12/21 1.800%1.800%245,000 247,678 1,642
Wells Fargo #949495AN5 01/17/20 01/18/22 1.800%1.800%245,000 248,810 165
Bank Leumi #063248KQ0 03/31/20 03/31/22 1.250%1.250%245,000 248,200 1,263
Capital One Natl Assn #14042TCZ8 04/01/20 04/01/22 1.350%1.350%245,000 248,459 1,364
Synchrony Bank #87164WZN1 04/03/20 04/04/22 1.350%1.350%245,000 248,484 1,346
Wells Fargo #95001DAB6 06/17/20 06/17/23 1.200%1.200%245,000 244,000 106
Total Certificates of Deposits $3,675,000 $3,708,337 $12,325
Total J.P.Morgan Securities $22,823,104 $22,995,586 $132,937
*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
February 28, 2021
Cash & Investments by Fund - Total $44.9 million
Cash & Investments by Type - Total $44.9 million
Checking
Illinois Funds
Certificates of Deposit
Municipal Bonds
Corporate Bonds
Government & Agency Obligations
Accrued Interest
General Corporate
53.9%
Hotel/Motel Tax
10.3%
Motor Fuel Tax
1.6%
Infrastructure
16.3%
Promenade TIF
0.1%
Water
14.8%
Sports Core
0.0%
Golf Surcharge
0.3%
Self-Insurance
0.4%Garage
0.7%
Equipment
Replacement
1.6%
Checking, $0.2
Illinois Funds, $21.7
Certificates of Deposit,
$3.7
Municipal Bonds,
$10.2
Corporate Bonds, $7.5
Government & Agency
Obligations, $1.4
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)4,139,264$ 3,810,536$ 328,728$ 130,985$
Main operating fund of the Village.
Hotel Fund (Major Fund)50,146$ 14,053$ 36,093$ 15,330$
Collects and spends resources from the
3% hotel/motel tax.
Motor Fuel Tax Fund 49,156$ 8,290$ 40,866$ 47,500$
Collects and spends resources from the
State motor fuel tax.
Infrastructure Fund (Major Fund)1,033,446$ 537,601$ 495,845$ 229,955$
Accounts for construction and maintenance of
roadways, drainage, and safety path systems.
Promenade TIF Fund (Major Fund)19$ 228,250$ (228,231)$ (215,030)$
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)1,167,350$ 819,863$ 347,487$ (1,915,475)$
Collects user fees for the distribution of water
and maintenance of infrastructure.
Sports Core Fund (Major Fund)248,839$ 300,846$ (52,007)$ (212,875)$
Accounts for revenues and expenses relating
to administration, programs, food and beverage
operations, and golf course.
Golf Surcharge Fund (6)$ -$ (6)$ 150$
Accounts for the collection of the $3 per round
golf surcharge.
Internal Service Funds
Self Insurance Fund 588,818$ 324,184$ 264,634$ 7,740$
Accounts for the Village's health insurance costs
and the related contributions from the Village,
employees, retirees, and other agencies.
Garage Fund 102,138$ 118,105$ (15,967)$ (20,400)$
Accounts for the maintenance of the Village's vehicle
fleet and the related departmental reimbursements.
Equipment Replacement Fund 56,001$ 35,403$ 20,598$ (17,910)$
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 February 28, 2021
Village of Oak Brook
Monthly Financial Report – Fund Narrative
For the Period Ending February 28, 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 (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 February 2021 are $117,302, or 2.8%, lower than last February, but
$114,833, or 2.9%, over budget to date. The main drivers for this are:
o Sales tax revenue, the General
Fund’s largest revenue source, is
up $90,863 from last year and
$298,953 over budget. February
2021 collections were consistent
with the past five years.
o Licenses and permits revenue is
down $284,705 from last year
and $198,536 under budget.
This is due to the timing of
receipts as the Village issues
permits throughout the year. Permit revenue is still expected to be strong in 2021 with
the continuation of the Hines Oak Brook Commons project.
Total expenditures through February 2021 are $709,232, or 16.6%, lower than last year and
$301,133, or 7.8%, under budget to date. The main drivers for this are:
o Personnel expenditures are down $724,047 from last year and $107,959 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 February 2021 are $108,029, or 68.3%, lower than last year and
$10,674, or 17.6%, under budget to date. The main drivers for this are:
o Hotel tax revenue is down $98,206 from last year and $11,028 under budget. The
decrease in revenue is due to the effects of COVID-19 on the travel industry.
Total expenditures through February 2021 are $24,378, or 99.8%, lower than last year and
$31,441, or 99.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 February 2021 are down $24,947, or 2.5%, from last year, but $89,648,
or 10.1%, over budget. The main drivers for this are:
o Non-home rule sales tax
revenue is down $6,604 from
last year, but $90,389 over
budget. February 2021
collections were consistent with
the past five years.
Total expenditures through February
2021 are down $48,321, or 8.7%, from
last year and $176,028, or 25.7%, under
budget to date. The main drivers for
this are:
o Personnel expenditures are down $33,390 from last year, but $1,458 over budget. The
decrease is due to two payroll cycles in January 2021 vs. three payroll cycles in January
2020. Personnel is over budget due to snow removal overtime.
o Operation and contract expenditures are down $32,995 from last year and $177,528
under budget. Expenditures are under budget due to the timing of engineering and
other miscellaneous payments.
Promenade TIF Fund
Total revenues through February 2021 are down $251, or 93.0%, from last year and $13,201, or
99.9%, under budget. The decrease is due to the decline in interest rates on available cash and
investments. Revenues are under budget due to the timing of information to record the TIF sale
tax transfer.
Total expenditures through February 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 February 2021 are down $183,703, or 13.6%, from last year and
$234,820, or 16.7%, under budget. The main drivers for this are:
o Water sales revenue is down $173,305 from last year and $219,233 under budget.
Water gallons sold has also been slightly less than projected so far this year.
Total expenditures through February 2021 are down $233,195, or 23.8%, from last year and
$2,497,786, or 77.0%, under budget. The main drivers for this are:
o Operation and contract expenditures are down $7,932 from last year and $532,500
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 $222,081 from last year and $1,968,541 under
budget. Capital projects will occur later in 2021 as planned.
Sports Core Fund
Total revenues through February 2021 are up $3,422, or 16.7%, from last year and $2,255, or
10.4%, over budget to date. In February, only a few miscellaneous revenue sources have been
collected and recorded. Memberships and user fees are expected to begin in March.
Total expenditures through February 2021 are down $55,562, or 16.1%, from last year, but
$59,619, or 25.8%, over budget to date. The main drivers for this are:
o Personnel expenditures are down $14,281 from last year and $18,629 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 up $32,758 from last year and $27,421 over
budget. This is due to the general timing of payments.
o Capital outlay expenditures are down $62,562 from last year, but $57,782 over budget.
Expenditures are down because of the golf lounge project that occurred in spring 2020.
Expenditures are over budget due to the timing of the pool renovation payments.
2/28/21 2/28/21
2/29/20 2/28/21 YTD % of YTD 2021 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 2,154,390$ 2,245,253$ 1,946,300$ 115.4%11,860,995$ 90,863$
Other Intergovernmental Tax*253,060 290,219 224,100 129.5%1,320,600 37,159
Telecommunications/Utility Tax 1,043,773 973,575 1,020,000 95.4%5,995,000 (70,198)
Licenses and Permits 415,364 130,659 329,195 39.7%2,180,360 (284,705)
Charges for Services 150,190 159,963 199,580 80.1%1,293,540 9,773
Fines and Penalties 31,097 22,321 30,090 74.2%180,500 (8,776)
Administrative Towing Fees 4,637 11,260 3,670 306.8%22,000 6,623
Investment Interest 74,262 35,585 50,000 71.2%300,000 (38,677)
Franchise Fees - 50,783 50,500 100.6%202,000 50,783
Miscellaneous Income 30,847 120,700 72,050 167.5%463,380 89,853
Total Operating Revenues 4,157,620$ 4,040,318$ 3,925,485$ 102.9%23,818,375$ (117,302)$
OPERATING EXPENDITURES
Personnel 3,568,593$ 2,844,546$ 2,952,505$ 96.3%18,842,080$ (724,047)$
Materials and Supplies 71,413 64,535 91,290 70.7%551,030 (6,878)
Operation and Contract 632,116 627,559 770,075 81.5%3,397,210 (4,557)
Other Expenditures 2,201 2,173 2,500 86.9%10,000 (28)
Capital Outlay 9,576 35,854 59,430 60.3%452,300 26,278
Total Operating Expenditures 4,283,899$ 3,574,667$ 3,875,800$ 92.2%23,252,620$ (709,232)$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES (126,279)$ 465,651$ 49,685$ 565,755$ 591,930$
INTERFUND TRANSACTIONS
Transfers Out -$ -$ -$ 0.0%(100,000)$ -$
Reimbursements From Other Funds 104,398 98,946 98,950 100.0%593,685 (5,452)
Reimbursements To Other Funds (23,294) (17,648) (17,650) 100.0%(105,885) 5,646
Sports Core Loan (105,000) (218,221) - 0.0%- (113,221)
Total Interfund Transactions (23,896)$ (136,923)$ 81,300$ -168.4%387,800$ (113,027)$
NET FUND INCREASE (DECREASE)(150,175)$ 328,728$ 130,985$ 953,555$ 478,903$
*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 February 28, 2021
Total Total
Revenues Expenditures
2/28/21 Actual 4,040,318$ 3,574,667$
2/28/20 Actual 4,157,620$ 4,283,899$
% Change From Last Year -2.8%-16.6%
Major Revenues
Other Telecom/Utility Licenses &Charges for
Sales Tax Intergov. Tax Tax Permits Services
2/28/21 Actual 2,245,253$ 290,219$ 973,575$ 130,659$ 159,963$
2/28/20 Actual $ 2,154,390 $ 253,060 $ 1,043,773 $ 415,364 $ 150,190
% Change From Last Year 4.2%14.7%-6.7%-68.5%6.5%
Five Year Trend
Major Expenditures Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
2/28/21 Actual 2,844,546$ 64,535$ 627,559$ 2,173$ 35,854$
2/28/20 Actual 3,568,593$ 71,413$ 632,116$ 2,201$ 9,576$
% Change From Last Year -20.3%-9.6%-0.7%-1.3%274.4%
Five Year Trend
Expenditures by Department
2/29/20 2/28/21 2/28/21 2/28/21 2021 Difference Five
YTD YTD YTD % of Annual Prior Year
Department Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 410,656$ 372,144$ 537,640$ 69.2%2,498,625$ (38,512)$
Financial Services 139,166 121,417 123,730 98.1%770,360 (17,749)
Public Works 88,235 97,688 130,680 74.8%948,860 9,453
Engineering & Capital Projects 3,010 4,547 9,000 50.5%209,000 1,537
Library 183,661 146,991 149,790 98.1%943,405 (36,670)
Police 1,804,602 1,438,633 1,468,615 98.0%9,213,585 (365,969)
Fire 1,485,273 1,210,628 1,266,420 95.6%7,576,045 (274,645)
Development Services 169,296 182,619 189,925 96.2%1,092,740 13,323
Total Expenditures 4,283,899$ 3,574,667$ 3,875,800$ 92.2%23,252,620$ (709,232)$
Five Year Trend
For the Period Ending February 28, 2021
General Fund - Five Year Trend
Village of Oak Brook
Revenues Expenditures
2/28/21 2/28/21
2/29/20 2/28/21 YTD % of YTD 2021 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Hotel Tax 141,328$ 43,122$ 54,150$ 79.6%414,000$ (98,206)$
Investment Interest 16,847 7,024 6,670 105.3%40,000 (9,823)
Loan Interest - - - 0.0%8,000 -
Total Operating Revenues 158,175$ 50,146$ 60,820$ 82.4%462,000$ (108,029)$
EXPENDITURES
Operation and Contract 4,838$ 39$ 31,480$ 0.1%193,945$ (4,799)$
Capital Outlay 19,579 - - 0.0%250,000 (19,579)
Total Expenditures 24,417$ 39$ 31,480$ 0.1%443,945$ (24,378)$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 133,758$ 50,107$ 29,340$ 170.8%18,055$ (83,651)$
INTERFUND TRANSACTIONS
Transfer Out -$ -$ -$ 0.0%(100,000)$ -$
Reimbursements to Other Funds (12,452) (14,014) (14,010) 100.0%(84,085) (1,562)
Total Interfund Transactions (12,452)$ (14,014)$ (14,010)$ 100.0%(184,085)$ (1,562)$
NET FUND INCREASE (DECREASE)121,306$ 36,093$ 15,330$ (166,030)$ (85,213)$
Note - Expenditures are recorded in program 171.
Village of Oak Brook
Hotel Tax Fund Financial Update
For the Period Ending February 28, 2021
Total Total
Revenues Expenditures
2/28/21 Actual $ 50,146 39$
2/28/20 Actual $ 158,175 24,417$
% Change From Last Year -68.3%-99.8%
Major Revenues Investment
Hotel Tax Interest Loan Interest Miscellaneous
2/28/21 Actual $ 43,122 $ 7,024 -$ -$
2/28/20 Actual $ 141,328 $ 16,847 -$ -$
% Change From Last Year -69.5%-58.3%0.0%0.0%
Five Year Trend
Major Expenditures Operation &
Contractual Capital Outlay
2/28/21 Actual 39$ -$
2/28/20 Actual 4,838$ 19,579$
% Change From Last Year -99.2%-100.0%
Five Year Trend
Village of Oak Brook
Hotel Tax Fund - Major Sources Five Year Trend
For the Period Ending February 28, 2021
Five Year Trend
Revenues Expenditures
2/28/21 2/28/21
2/29/20 2/28/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 978,643$ 972,039$ 881,650$ 110.3%5,333,500$ (6,604)$
Charges for Services - - 170 0.0%1,000 -
Investment Interest 24,442 6,099 6,670 91.4%40,000 (18,343)
Miscellaneous - - - 0.0%- -
Total Operating Revenues 1,003,085$ 978,138$ 888,490$ 110.1%5,374,500$ (24,947)$
OPERATING EXPENDITURES
Personnel 284,358$ 250,968$ 249,510$ 100.6%1,386,115$ (33,390)$
Materials and Supplies 63,669 70,114 84,170 83.3%245,660 6,445
Operation and Contract 206,032 173,037 350,565 49.4%1,892,905 (32,995)
Capital Outlay 2,479 14,098 - N/A 8,956,170 11,619
Total Operating Expenditures 556,538$ 508,217$ 684,245$ 74.3%12,480,850$ (48,321)$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 446,547$ 469,921$ 204,245$ 230.1%(7,106,350)$ 23,374$
INTERFUND TRANSACTIONS
Transfers In -$ -$ -$ 0.0%1,400,000$ -$
Reimbursements From Other Funds 59,896 55,308 55,310 100.0%331,840 (4,588)
Reimbursements To Other Funds (27,050) (29,384) (29,600) 99.3%(176,300) (2,334)
Total Interfund Transactions 32,846$ 25,924$ 25,710$ 100.8%1,555,540$ (6,922)$
NET FUND INCREASE (DECREASE)479,393$ 495,845$ 229,955$ (5,550,810)$ 16,452$
Village of Oak Brook
Infrastructure Fund Financial Update
For the Period Ending February 28, 2021
Total Total
Revenues Expenditures
2/28/21 Actual $ 978,138 508,217$
2/28/20 Actual $ 1,003,085 556,538$
% Change From Last Year -2.5%-8.7%
Major Revenues
Sales Tax
Charges for
Services
Investment
Interest Miscellaneous
2/28/21 Actual $ 972,039 $ - $ 6,099 $ -
2/28/20 Actual $ 978,643 $ - $ 24,442 $ -
% Change From Last Year -0.7%0.0%-75.0%0.0%
Five Year Trend
Major Expenditures Materials &Operation &
Personnel Supplies Contractual Capital Outlay
2/28/21 Actual 250,968$ 70,114$ 173,037$ 14,098$
2/28/20 Actual 284,358$ 63,669$ 206,032$ 2,479$
% Change From Last Year -11.7%10.1%-16.0%468.7%
Five Year Trend
Expenditures by Department
2/29/20 2/28/21 2/28/21 2/28/21 2021 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 16,465$ 15,982$ 26,840$ 59.5%157,640$ (483)$
Public Works 468,582 451,796 503,665 89.7%2,789,580 (16,786)
Engineering & Capital Projects 71,491 40,439 153,740 26.3%9,709,930 (31,052)
Total Expenditures 556,538$ 508,217$ 684,245$ 74.3%12,657,150$ (48,321)$
Five Year Trend
Village of Oak Brook
Infrastructure Fund - Major Sources Five Year Trend
For the Period Ending February 28, 2021
Revenues Expenditures
2/28/21 2/28/21
2/29/20 2/28/21 YTD % of YTD 2021 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax -$ -$ 13,050$ 0.0%75,000$ -$
Real Estate Tax - - - 0.0%400,000 -
Investment Interest 270 19 170 11.2%1,000 (251)
Total Operating Revenues 270$ 19$ 13,220$ 0.1%476,000$ (251)$
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)(265,185)$ (228,231)$ (215,030)$ 5,650$ 36,954$
Note - Expenditures are recorded in program 283.
Village of Oak Brook
Promenade TIF Fund Financial Update
For the Period Ending February 28, 2021
Total Total
Revenues Expenditures
2/28/21 Actual $ 19 228,250$
2/28/20 Actual $ 270 265,455$
% Change From Last Year -93.0%-14.0%
Major Revenues Real Estate Investment
Sales Tax Tax Interest
2/28/21 Actual -$ $ - $ 19
2/28/20 Actual -$ $ - $ 270
% Change From Last Year 0.0%0.0%-93.0%
Five Year Trend
Major Expenditures Operation &Other
Contractual Expenditures
2/28/21 Actual -$ 228,250$
2/28/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 February 28, 2021
Five Year Trend
Revenues Expenditures
2/28/21 2/28/21
2/29/20 2/28/21 YTD % of YTD 2021 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Plan Review Fees -$ -$ 170$ 0.0%1,000$ -$
Building/Inspection Fees 4,762 - 1,170 0.0%7,000 (4,762)
Water Sales 1,309,072 1,135,767 1,355,000 83.8%10,597,000 (173,305)
Unmetered Sales 2,400 6,238 5,830 107.0%35,000 3,838
Water Connection Fees 1,160 - 16,670 0.0%100,000 (1,160)
Meter Charges 330 - 2,500 0.0%15,000 (330)
Special Services 763 765 - N/A 25,000 2
Investment Interest 22,731 9,593 10,000 95.9%60,000 (13,138)
Miscellaneous 9,835 14,987 10,830 138.4%65,000 5,152
Total Operating Revenues 1,351,053$ 1,167,350$ 1,402,170$ 83.3%10,905,000$ (183,703)$
OPERATING EXPENDITURES
Personnel 155,871$ 122,371$ 135,890$ 90.1%842,235$ (33,500)$
Materials and Supplies 396 30,714 13,940 220.3%75,780 30,318
Operation and Contract 361,077 353,145 885,645 39.9%5,379,925 (7,932)
Capital Outlay 460,630 238,549 2,207,090 10.8%8,103,750 (222,081)
Total Expenditures 977,974$ 744,779$ 3,242,565$ 23.0%14,401,690$ (233,195)$
Surplus (Deficit) of Revenues Over
Expenditures 373,079$ 422,571$ (1,840,395)$ -23.0%(3,496,690)$ 49,492$
INTERFUND TRANSACTIONS
Reimbursements To Other Funds (87,802)$ (75,084)$ (75,080)$ 100.0%(450,500)$ 12,718$
Total Interfund Transactions (87,802)$ (75,084)$ (75,080)$ 100.0%(450,500)$ 12,718$
Fund Increase/(Decrease) - Budgetary Basis 285,277$ 347,487$ (1,915,475)$ -18.1%(3,947,190)$ 62,210$
ADUSTMENTS TO GAAP BASIS*
Remove Capital Outlay 460,630$ 238,549$
Depreciation Expense (95,833) (97,500)
IMRF Pension Expense 8,333 8,333
OPEB Expense (7,500) (7,500)
Total GAAP Adjustments 365,630$ 141,882$
Fund Increase/(Decrease) - GAAP Basis 650,907$ 489,369$
*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 February 28, 2021
Total Total
Revenues Expenditures
2/28/21 Actual $ 1,167,350 744,779$
2/28/20 Actual $ 1,351,053 977,974$
% Change From Last Year -13.6%-23.8%
Unmetered Water
Water Sales Sales Connection Fees Meter Charges Miscellaneous
2/28/21 Actual $ 1,135,767 $ 6,238 $ - $ - $ 14,987
2/28/20 Actual $ 1,309,072 $ 2,400 $ 1,160 $ 330 $ 9,835
% Change From Last Year -13.2%159.9%-100.0%-100.0%52.4%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
2/28/21 Actual 122,371$ 30,714$ 353,145$ -$ 238,549$
2/28/20 Actual 155,871$ 396$ 361,077$ -$ 460,630$
% Change From Last Year -21.5%7656.1%-2.2%0.0%-48.2%
Five Year Trend
Expenditures by Department
2/29/20 2/28/21 2/28/21 2/28/21 2021 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Public Works 517,441$ 486,415$ 1,038,815$ 46.8%6,317,940$ (31,026)$
Engineering & Capital Projects 460,533 258,364 2,203,750 11.7%8,083,750 (202,169)
Total Expenditures 977,974$ 744,779$ 3,242,565$ 23.0%14,401,690$ (233,195)$
Five Year Trend
Village of Oak Brook
Water Fund - Major Sources Five Year Trend
For the Period Ending February 28, 2021
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Sports Core Fund Consolidated Presentation
For the Period Ending February 28, 2021
2/28/21 2/28/21
2/28/21 YTD % of YTD 2021 2/29/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 -$ -$ -$ 7,500$ 7,500$ -$ N/A 238,500$ 199$ 7,301$
Greens Fees - - - - - - 0.0%985,000 807 (807)
Pro Shop Sales - - - 3,789 3,789 10,500 36.1%207,000 8,326 (4,537)
Golf Lessons - - - - - - 0.0%45,000 - -
Driving Range Fees - - - 550 550 - N/A 250,000 - 550
Rentals - 5,000 - (34) 4,966 11,025 45.0%761,000 11,395 (6,429)
Programs/User Fees - - - - - - 0.0%31,500 - -
Food Sales - - - - - - 0.0%207,500 - -
Beverage Sales - - - - - - 0.0%382,000 33 (33)
Taste of Oak Brook - - - - - - 0.0%120,000 - -
Grants - - - - - - 0.0%233,600 - -
Other Revenue 6,885 - - 260 7,145 170 4202.9%7,700 (232) 7,377
Total Operating Revenues 6,885$ 5,000$ -$ 12,065$ 23,950$ 21,695$ 110.4%3,468,800$ 20,528$ 3,422$
OPERATING EXPENDITURES
Personnel -$ -$ 16,548$ 111,823$ 128,371$ 147,000$ 87.3%1,597,610$ 142,652$ (14,281)$
Materials & Supplies 2,483 - 1,009 (3,077) 415 7,370 5.6%628,450 11,892 (11,477)
Operational & Contractual 14,053 25,998 3,650 52,095 95,796 68,375 140.1%663,035 63,038 32,758
Other - - - - - - 0.0%(39,000) - -
Capital 65,782 - - - 65,782 8,000 822.3%1,125,380 128,344 (62,562)
Total Operating Expenditures 82,318$ 25,998$ 21,207$ 160,841$ 290,364$ 230,745$ 125.8%3,975,475$ 345,926$ (55,562)$
B&T Administration Overhead Allocation*8,820$ -$ (8,820)$ -$ -$ -$ 0.0%-$ -$ -$
Operating Revenues Over (Under) Expenditures (66,613)$ (20,998)$ (30,027)$ (148,776)$ (266,414)$ (209,050)$ 127.4%(506,675)$ (325,398)$ 58,984$
INTERFUND TRANSACTIONS
Interfund Loan**218,221$ -$ -$ -$ 218,221$ -$ N/A -$ 105,000$ 113,221$
Transfer From General Fund - - - - - - 0.0%100,000 - -
Transfer From Hotel Tax Fund - - - - - - 0.0%- - -
Transfer From Golf Surcharge Fund - - - - - - 0.0%200,000 119,719 (119,719)
Reimbursement From Infrastructure Fund 5,334 - - - 5,334 5,335 100.0%32,000 4,000 1,334
Reimbursement From Water Fund 1,334 - - - 1,334 1,335 99.9%8,000 1,334 -
Reimbursement To General Fund (2,620) - - (7,862) (10,482) (10,495) 99.9%(62,900) (9,408) (1,074)
Total Interfund Transactions 222,269$ -$ -$ (7,862)$ 214,407$ (3,825)$ -5605.4%277,100$ 220,645$ (6,238)$
Total Revenues Over (Under) Expenditures - Budgetary Basis 155,656$ (20,998)$ (30,027)$ (156,638)$ (52,007)$ (212,875)$ (229,575)$ (104,753)$ 52,746$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay 65,782$ -$ -$ -$ 65,782$ 128,344$
Depreciation Expense (24,984) (281) (5,833) (35,333) (66,431) (54,732)
IMRF Pension Expense (875) (42) (333) (1,975) (3,225) 15,462
OPEB Expense - - (867) (6,667) (7,533) (3,339)
Total GAAP Adjustments 39,923$ (323)$ (7,033)$ (43,975)$ (11,408)$ 85,735$
Fund Increase/(Decrease) - GAAP Basis 195,579$ (21,321)$ (37,060)$ (200,613)$ (63,415)$ (19,018)$
*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
2/28/21 Actual $ 23,950 290,364$
2/28/20 Actual $ 20,528 345,926$
% Change From Last Year 16.7%-16.1%
Driving Program/
Memberships Greens Fees Range Fees Rentals User Fees
2/28/21 Actual $ 7,500 $ - $ 550 $ 4,966 -$
2/28/20 Actual $ 199 $ 807 $ - $ 11,395 -$
% Change From Last Year 3668.8%-100.0%N/A -56.4%0.0%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
2/28/21 Actual 128,371$ 415$ 95,796$ -$ 65,782$
2/28/20 Actual 142,652$ 11,892$ 63,038$ -$ 128,344$
% Change From Last Year -10.0%-96.5%52.0%0.0%-48.7%
Five Year Trend
Revenues by Department 2/29/20 2/28/21 2/28/21 2/28/21 2021 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Operations (173)$ 6,885$ 70$ 9835.7%325,800$ 7,058$
Open Field Operations 2,670 5,000 5,000 100.0%230,000 2,330
B&T Clubhouse Operations 8,742 - 4,000 0.0%267,000 (8,742)
Golf Club 9,289 12,065 12,625 95.6%2,646,000 2,776
Total Revenues 20,528$ 23,950$ 21,695$ 110.4%3,468,800$ 3,422$
Expenditures by Department 2/29/20 2/28/21 2/28/21 % of YTD 2021 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Operations 19,715$ 82,318$ 27,525$ 299.1%780,740$ 62,603$
Open Field Operations 7,687$ 25,998$ 1,210$ 2148.6%358,910$ 18,311$
B&T Clubhouse Operations 24,311 21,207 34,035 62.3%262,635 (3,104)
Golf Club 294,213 160,841 167,975 95.8%2,573,190 (133,372)
Total Expenditures 345,926$ 290,364$ 230,745$ 125.8%3,975,475$ (55,562)$
Five Year Trend
Village of Oak Brook
Sports Core Fund - Major Sources Five Year Trend
For the Period Ending February 28, 2021
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Bath & Tennis Club Recreation Operations
For the Period Ending February 28, 2021 2/28/21 2/28/21
822 2/28/21 YTD % of YTD 2021 2/29/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 6,885 - - - 6,885 70 9835.7%700 (372) 7,257
Total Operating Revenues 6,885$ -$ -$ -$ 6,885$ 70$ 9835.7%325,800$ (173)$ 7,058$
OPERATING EXPENDITURES
Personnel -$ -$ -$ -$ -$ 4,750$ 0.0%119,110$ 800$ (800)$
Materials & Supplies - 2,483 - - 2,483 630 394.1%37,250 249 2,234
Operational & Contractual 13,314 678 61 - 14,053 22,145 63.5%89,550 18,666 (4,613)
Capital 8,591 57,191 - - 65,782 - N/A 534,830 - 65,782
Total Operating Expenditures 21,905$ 60,352$ 61$ -$ 82,318$ 27,525$ 299.1%780,740$ 19,715$ 62,603$
B&T Administration Overhead Allocation*17,640$ (6,351)$ (1,764)$ (705)$ 8,820$ 11,200$ 78.8%44,755$ 11,953$ (3,133)$
Operating Revenues Over (Under) Expenditures 2,620$ (66,703)$ (1,825)$ (705)$ (66,613)$ (16,255)$ 409.8%(410,185)$ (7,935)$ (58,678)$
INTERFUND TRANSACTIONS
Interfund Loan**218,221$ -$ -$ -$ 218,221$ -$ N/A -$ 105,000$ 113,221$
Transfer From General Fund - - - - - - 0.0%100,000$ -$ -$
Reimbursement From Infrastructure Fund 5,334 - - - 5,334 5,335 100.0%32,000 4,000 1,334
Reimbursement From Water Fund 1,334 - - - 1,334 1,335 99.9%8,000 1,334 -
Reimbursement To General Fund (2,620) - - - (2,620) (2,620) 100.0%(15,725) (4,704) 2,084
Total Interfund Transactions 222,269$ -$ -$ -$ 222,269$ 4,050$ 5488.1%124,275$ 105,630$ 116,639$
Total Revenues Over (Under) Expenditures - Budgetary Basis 224,889$ (66,703)$ (1,825)$ (705)$ 155,656$ (12,205)$ (285,910)$ 97,695$ 57,961$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay 8,591$ 57,191$ -$ -$ 65,782$ -$
Depreciation Expense - (23,956) (833) (195) (24,984) (15,804)
IMRF Pension Expense (833) - - (42) (875) 1,017
Total GAAP Adjustments 7,758$ 33,235$ (833)$ (236)$ 39,923$ (14,788)$
Fund Increase/(Decrease) - GAAP Basis 232,647$ (33,468)$ (2,658)$ (941)$ 195,579$ 82,908$
*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 February 28, 2021 2/28/21 2/28/21
2/28/21 YTD % of YTD 2021 2/29/20 Difference
815 816 YTD Amended Amended Adopted YTD Prior
Polo Open Fields Total Budget Budget Budget Total Year
OPERATING REVENUES
Field Rentals -$ 5,000$ 5,000$ 5,000$ 100.0%30,000$ 2,670$ 2,330$
Range Rentals - - - - 0.0%80,000 - -
Taste of Oak Brook - - - - 0.0%120,000 - -
Other Revenue - - - - 0.0%- - -
Total Operating Revenues -$ 5,000$ 5,000$ 5,000$ 100.0%230,000$ 2,670$ 2,330$
OPERATING EXPENDITURES
Personnel -$ -$ -$ -$ 0.0%-$ -$ -$
Materials & Supplies - - - 100 0.0%500 - -
Operational & Contractual 25,000 998 25,998 1,110 2342.2%190,360 711 25,287
Capital - - - - 0.0%168,050 6,976 (6,976)
Total Operating Expenditures 25,000$ 998$ 25,998$ 1,210$ 2148.6%358,910$ 7,687$ 18,311$
Operating Revenues Over (Under) Expenditures (25,000)$ 4,002$ (20,998)$ 3,790$ -554.0%(128,910)$ (5,017)$ (15,981)$
INTERFUND TRANSACTIONS
Transfer From Hotel Tax Fund -$ -$ -$ -$ 0.0%-$ -$ -$
Total Interfund Transactions -$ -$ -$ -$ 0.0%-$ -$ -$
Total Revenues Over (Under) Expenditures - Budgetary Basis (25,000)$ 4,002$ (20,998)$ 3,790$ (128,910)$ (5,017)$ (15,981)$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay -$ -$ -$ 6,976$
Depreciation Expense - (281) (281) (281)
IMRF Pension Expense - (42) (42) 123
Total GAAP Adjustments -$ (323)$ (323)$ 6,818$
Fund Increase/(Decrease) - GAAP Basis (25,000)$ 3,680$ (21,321)$ 1,801$
*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 February 28, 2021
2/28/21 2/28/21
821 YTD % of YTD 2021 2/29/20 Difference
B&T Amended Amended Adopted YTD Prior
Clubhouse Budget Budget Budget Total Year
OPERATING REVENUES
Rentals -$ 4,000$ 0.0%267,000$ 8,742$ (8,742)$
Total Operating Revenues -$ 4,000$ 0.0%267,000$ 8,742$ (8,742)$
OPERATING EXPENDITURES
Personnel 16,548$ 18,140$ 91.2%133,585$ 21,556$ (5,008)$
Materials & Supplies 1,009 2,630 38.4%12,000 305 704
Operational & Contractual 3,650 13,265 27.5%107,550 2,450 1,200
Capital - - 0.0%9,500 - -
Total Operating Expenditures 21,207$ 34,035$ 62.3%262,635$ 24,311$ (3,104)$
B&T Administration Overhead Allocation*(8,820)$ (11,200)$ 78.8%(44,755)$ (11,953)$ 3,133$
Operating Revenues Over (Under) Expenditures (30,027)$ (41,235)$ 72.8%(40,390)$ (27,522)$ (2,505)$
INTERFUND TRANSACTIONS
Transfer From General Fund -$ -$ 0.0%-$ -$ -$
Total Interfund Transactions -$ -$ 0.0%-$ -$ -$
Total Revenues Over (Under) Expenditures - Budgetary Basis (30,027)$ (41,235)$ (40,390)$ (27,522)$ (2,505)$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay -$ -$
Depreciation Expense (5,833) (5,359)
IMRF Pension Expense (333) 1,117
OPEB Expense (867) (350)
Total GAAP Adjustments (7,033)$ (4,592)$
Fund Increase/(Decrease) - GAAP Basis (37,060)$ (32,114)$
*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 February 28, 2021
2/28/21 2/28/21
823 831 832 833 834 2/28/21 YTD % of YTD 2021 2/29/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 -$ 7,500$ -$ -$ -$ 7,500$ -$ N/A 238,500$ -$ 7,500$
Greens Fees - - - - - - - 0.0%985,000 807 (807)
Pro Shop Sales - 3,789 - - - 3,789 10,500 36.1%207,000 8,326 (4,537)
Golf Lessons - - - - - - - 0.0%45,000 - -
Driving Range Fees - - 550 - - 550 - N/A 250,000 - 550
Rentals - - - (34) - (34) 2,025 -1.7%384,000 (17) (17)
Food Sales - - - - - - - 0.0%169,500 - -
Beverage Sales - - - - - - - 0.0%360,000 33 (33)
Other Revenue - 260 - - - 260 100 260.0%7,000 140 120
Total Operating Revenues -$ 11,549$ 550$ (34)$ -$ 12,065$ 12,625$ 95.6%2,646,000$ 9,289$ 2,776$
OPERATING EXPENDITURES
Personnel 6,986$ 61,321$ -$ -$ 43,516$ 111,823$ 124,110$ 90.1%1,344,915$ 120,296$ (8,473)$
Materials & Supplies (2,118) (1,993) - 296 738 (3,077) 4,010 -76.7%578,700 11,338 (14,415)
Operational & Contractual 276 40,406 - - 11,413 52,095 31,855 163.5%275,575 41,211 10,884
Other - - - - - - - 0.0%(39,000) - -
Capital - - - - - - 8,000 0.0%413,000 121,368 (121,368)
Total Operating Expenditures 5,144$ 99,734$ -$ 296$ 55,667$ 160,841$ 167,975$ 95.8%2,573,190$ 294,213$ (133,372)$
Operating Revenues Over (Under) Expenditures (5,144)$ (88,185)$ 550$ (330)$ (55,667)$ (148,776)$ (155,350)$ 95.8%72,810$ (284,924)$ 136,148$
INTERFUND TRANSACTIONS
Transfer from Golf Surcharge -$ -$ -$ -$ -$ -$ -$ 0.0%200,000$ 119,719$ (119,719)$
Reimbursement to General Fund - (7,862) - - - (7,862) (7,875) 99.8%(47,175) (4,704) (3,158)
Total Interfund Transactions -$ (7,862)$ -$ -$ -$ (7,862)$ (7,875)$ 99.8%152,825$ 115,015$ (122,877)$
Total Revenues Over (Under) Expenditures - Budgetary Basis (5,144)$ (96,047)$ 550$ (330)$ (55,667)$ (156,638)$ (163,225)$ 225,635$ (169,909)$ 13,271$
ADUSTMENTS TO GAAP BASIS*
Remove Capital Outlay -$ -$ -$ -$ -$ -$ 121,368$
Depreciation Expense - (22,500) (667) (3,833) (8,333) (35,333) (33,288)
IMRF Pension Expense (250) (833) (58) - (833) (1,975) 13,206
OPEB Expense (500) (3,833) - - (2,333) (6,667) (2,989)
Total GAAP Adjustments (750)$ (27,167)$ (725)$ (3,833)$ (11,500)$ (43,975)$ 98,297$
Fund Increase/(Decrease) - GAAP Basis (5,894)$ (123,214)$ (175)$ (4,163)$ (67,167)$ (200,613)$ (71,612)$
*Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.