02 - February 2022 Monthly Financial ReportVILLAGE
OAK BROOK
OF
MONTHLY FINANCIAL REPORTS
FEBRUARY 2022
ITEM 6.E
Cash and Investments by Fund:Total
Cash and Cash Pooled Cash and
Fund Equivalents Investments Investments % By Fund
General Corporate $13,515,416 $14,104,353 $27,619,769 57.3%
Hotel/Motel Tax 1,042,379 718,714 1,761,093 3.7%
Motor Fuel Tax 1,194,937 14,777 1,209,715 2.5%
Infrastructure 6,764,983 4,515,690 11,280,673 23.4%
Promenade TIF 55,248 - 55,248 0.1%
Water 714,260 3,380,666 4,094,926 8.5%
Sports Core 367,723 - 367,723 0.8%
Golf Surcharge 278,770 - 278,770 0.6%
Self-Insurance 299,583 - 299,583 0.6%
Garage 340,454 340,454 0.7%
Equipment Replacement 527,094 378,244 905,338 1.9%
Total $25,100,845 $23,112,445 $48,213,291 100.0%
Change in Cash and Investments by Fund :
Balance at Balance at Year-to-Date Year-to-Date
Fund January 1, 2022 February 28, 2022 Change ($)Change (%)
General Corporate $25,941,144 $27,619,769 $1,678,625 6.5%
Hotel/Motel Tax 1,754,745 1,761,093 6,348 0.4%
Motor Fuel Tax 1,153,550 1,209,715 56,165 4.9%
Infrastructure 10,880,028 11,280,673 400,645 3.7%
Promenade TIF 298,387 55,248 (243,139)-81.5%
Water 3,614,863 4,094,926 480,063 13.3%
Sports Core 576,566 367,723 (208,843)-36.2%
Golf Surcharge 278,773 278,770 (3)0.0%
Self-Insurance 87,655 299,583 211,928 N/A
Garage 325,902 340,454 14,552 4.5%
Equipment Replacement 759,255 905,338 146,083 19.2%
45,670,868 $48,213,291 $2,542,423 5.6%
Book Bank/Market
Value Value
Cash and Cash Equivalents:
Pooled Checking $453,708 $1,212,109
Sports Core Checking 654,191 648,997
Pooled IPTIP 23,705,920 23,708,063
Water E-Pay IPTIP 287,027 279,691
25,100,845 $25,848,859
Pooled Investments:
Investments-Municipal Bonds $9,235,321 $9,111,761
Investments-Corporate Bonds 9,011,192 8,846,002
Government & Agency Obligations $2,800,105 2,727,232
Certificates of Deposit 1,960,000 1,928,703
Accrued Interest 105,828 105,828
Total Pooled Investments $23,112,445 $22,719,527
Total Cash and Investments $48,213,290 $48,568,386
Monthly Treasurer's Report
February 28, 2022
Monthly Treasurer's Report
February 2022
The table below lists the detail investment holdings at J.P. Morgan Securities as of 2/28/22:
Month End VOB
Settlement Maturity Coupon Yield Book Market Accrued
Type Date Date Rate Rate Value Value Interest
Municipal Bonds:
Bloomingdale Mich Pub Sch Dist #094383FS0 04/26/16 05/01/22 2.710%2.150%$500,397 $501,665 $4,478
Laredo TX Waterworks #517039VW0 12/19/19 03/01/24 2.230%2.230%455,000 459,991 5,017
Oakland Univ Mich #673588HJ1 04/29/20 03/01/24 5.000%1.650%314,295 316,258 7,375
Philadelphia PA GO Ref #717813SW0 05/05/20 08/01/22 5.000%1.820%395,153 397,043 1,422
Maryland St DOT #574204WG4 05/06/20 06/15/22 4.350%1.200%262,398 262,779 2,271
University of CA #91412HFK4 07/16/20 05/15/23 0.628%0.628%25,000 24,793 46
New Jersey St #646039UD7 09/20/20 06/01/22 5.000%0.600%480,227 479,926 5,872
Rio Rancho NM #767175HM7 10/14/2020 5/15/2022 5.000%0.350%186,780 186,672 2,698
Cook, Kane, Lake, & McHenry #216181GL5 10/29/2020 12/15/2022 4.000%0.300%1,054,827 1,051,127 8,648
Miami-Dade Cnty #59333NN90 11/16/2020 12/15/2022 0.375%0.430%734,560 728,863 1,133
Hamilton NY #407741MC8 1/21/2021 5/1/2023 1.000%0.550%206,075 203,506 672
Southern Cal Pub Pwr #84247PHZ7 1/25/2021 4/1/2024 3.608%0.500%1,072,138 1,043,210 5,813
Hillsborough Cnty FL #43232VVG3 3/11/2021 7/1/2024 1.815%0.770%512,088 498,145 1,437
Port Auth of NY and NJ #73358WAH7 4/15/2021 12/1/2024 5.859%0.600%571,720 554,060 7,161
City of Atlanta GA Water #047870SG6 4/19/2021 11/1/2024 0.616%0.500%250,768 241,793 496
West Contra Costa Cal Uni #9523474U3 6/17/2021 8/1/2024 0.575%0.575%500,000 485,190 583
New York NY City #64971XA40 10/7/2021 11/1/2024 0.450%0.620%711,781 688,995 1,055
NY Urban Dev Corp #650036AR7 11/5/2021 3/15/2023 0.720%0.451%501,398 496,855 1,650
Colorado Brdg Enterprise #19633SAZ6 11/24/2021 12/31/2023 0.923%0.844%500,714 490,890 782
Total Municipal Bonds $9,235,321 $9,111,761 $58,608
Corporate Bonds:
American Express #025816CD9 05/05/20 05/20/22 2.750%1.290%$501,632 $501,220 $3,715
PNC Bank #69349LAK4 12/7/2020 1/30/2023 2.950%0.457%1,043,127 1,033,953 2,508
Wells Fargo #94974BFJ4 12/7/2020 2/13/2023 3.450%0.480%1,428,935 1,412,880 2,265
Comerica Bank #200340AS6 12/23/2020 7/31/2023 3.700%0.500%522,536 512,745 10,792
Bank of America #06048WM23 5/14/2021 5/14/2024 0.650%0.650%915,000 888,262 248
Goldman Sachs #38141GXE9 7/27/2021 2/20/2024 3.625%0.693%634,378 615,736 604
Goldman Sachs #38150AGU3 7/28/2021 7/28/2023 0.550%0.550%655,000 636,703 330
Morgan Stanley #61746BDQ6 7/28/2021 4/29/2024 3.875%0.547%1,071,376 1,033,937 13,132
Citigroup #17329UEH0 11/18/2021 11/18/2024 1.000%1.149%1,000,000 982,177 2,833
Bank New York Mellon #06406RAG2 1/25/2022 4/28/2023 3.500%0.810%721,708 715,644 8,303
Comerica Bank #200340AS6 1/25/2022 7/31/2023 3.700%1.200%517,501 512,745 (7,708)
Total Corporate Bonds $9,011,192 $8,846,002 $37,021
Government & Agency Obligations:
Government National Mtg Assn #38379UEM4 02/29/16 02/16/51 2.300%2.245%$14,631 $1,663 $351
Government National Mtg Assn #38381WV96 08/06/19 07/20/54 2.250%2.293%131,194 133,022 93
Government National Mtg Assn #38380BNV3 12/05/19 06/20/46 2.000%2.112%333,512 332,292 413
Federal Home Loan Bank #3130AMVU3 06/29/21 06/29/26 0.500%0.500%500,000 486,244 417
Government National Mtg Assn #38383DWC8 12/14/2021 11/20/2056 1.250%1.379%959,327 912,486 1,010
Federal Home Loan Bank #313381BR5 2/25/2022 12/9/2022 1.875%0.900%861,440 861,525 3,563
Total Government & Agency Obligations:$2,800,105 $2,727,232 $5,846
Certificates of Deposit:
Bank Leumi #063248KQ0 03/31/20 03/31/22 1.250%1.250%$245,000 $245,221 $1,276
Capital One Natl Assn #14042TCZ8 04/01/20 04/01/22 1.350%1.350%245,000 245,250 1,365
Synchrony Bank #87164WZN1 04/03/20 04/04/22 1.350%1.350%245,000 245,274 1,346
Goldman Sachs 38149MXG3 07/28/21 07/29/24 0.550%0.550%245,000 238,612 118
Sallie Mae #795451AD5 07/28/21 07/29/24 0.600%0.600%245,000 238,901 129
Texas Exchange Bk #88241TLS7 07/30/21 07/30/24 0.500%0.500%245,000 238,313 5
Toyota Financial #89235MLF6 08/05/21 8/5/2024 0.550%0.550%245,000 238,534 88
UBS Bank #90348JT42 09/22/21 9/23/2024 0.650%0.650%245,000 238,599 27
Total Certificates of Deposits $1,960,000 $1,928,703 $4,353
Total J.P.Morgan Securities $23,006,617 $22,613,699 $105,828
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, 2022
Cash & Investments by Fund - Total $48.2 million
Cash & Investments by Type - Total $48.2 million
General Corporate
57.3%
Hotel/Motel Tax
3.7%Motor Fuel Tax
2.5%
Infrastructure
23.4%
Promenade TIF
0.1%
Water
8.5%
Sports Core
0.8%
Golf Surcharge
0.6%
Self-Insurance
0.6%
Garage
0.7%
Equipment
Replacement
1.9%
Checking, $1,107,898.6
Illinois Funds,
23,992,946.7
Certificates of Deposit,
1,960,000.0
Municipal Bonds,
9,235,320.7
Corporate Bonds,
9,011,191.6
Government & Agency
Obligations,
2,800,104.6
Accrued Interest,
105,828.2
in millions
YTD YTD
Net Fund Budgeted
YTD YTD Increase Increase
Governmental Funds Revenues Expenditures (Decrease)(Decrease)
General Fund (Major Fund)5,210,682$ 3,539,510$ 1,671,171$ 223,265$
Main operating fund of the Village.
Hotel Fund (Major Fund)129,472$ 76,536$ 52,936$ 31,125$
Collects and spends resources from the
3% hotel/motel tax.
Motor Fuel Tax Fund 56,220$ -$ 56,220$ 47,250$
Collects and spends resources from the
State motor fuel tax.
Infrastructure Fund (Major Fund)1,263,546$ 488,926$ 774,620$ 425,390$
Accounts for construction and maintenance of
roadways, drainage, and safety path systems.
Promenade TIF Fund (Major Fund)11$ 243,150$ (243,139)$ (228,145)$
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,401,157$ 577,533$ 823,624$ 371,445$
Collects user fees for the distribution of water
and maintenance of infrastructure.
Sports Core Fund (Major Fund)21,967$ 222,312$ (200,345)$ (232,925)$
Accounts for revenues and expenses relating
to administration, programs, food and beverage
operations, and golf course.
Golf Surcharge Fund (3)$ -$ (3)$ -$
Accounts for the collection of the $3 per round
golf surcharge.
Internal Service Funds
Self Insurance Fund 682,770$ 622,155$ 60,615$ 663,290$
Accounts for the Village's health insurance costs
and the related contributions from the Village,
employees, retirees, and other agencies.
Garage Fund 103,563$ 76,038$ 27,525$ 103,660$
Accounts for the maintenance of the Village's vehicle
fleet and the related departmental reimbursements.
Equipment Replacement Fund 172,702$ 44,674$ 128,028$ 216,820$
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, 2022
2/28/22 2/28/22
2/28/21 2/28/22 YTD % of YTD 2022 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 2,245,253$ 2,972,631$ 2,170,000$ 137.0%13,200,000$ 727,378$
Other Intergovernmental Tax*290,219 402,665 276,900 145.4%1,618,400 112,446
Telecommunications/Utility Tax 973,575 1,076,619 955,000 112.7%5,595,000 103,044
Grants - - - N/A 15,000 -
Licenses and Permits 130,659 275,739 298,625 92.3%2,007,510 145,080
Charges for Services 159,963 245,620 174,645 140.6%1,154,900 85,657
Fines and Penalties 22,321 12,599 23,670 53.2%142,000 (9,722)
Administrative Towing Fees 11,260 6,000 4,170 143.9%25,000 (5,260)
Investment Interest 35,585 16,774 24,000 69.9%144,000 (18,811)
Franchise Fees 50,783 53,735 49,500 0.0%198,000 2,952
Miscellaneous Income 120,700 54,096 72,980 74.1%478,270 (66,604)
Total Operating Revenues 4,040,318$ 5,116,478$ 4,049,490$ 126.3%24,578,080$ 1,076,160$
OPERATING EXPENDITURES
Personnel 2,844,546$ 2,774,509$ 3,022,285$ 91.8%19,596,700$ (70,037)$
Materials and Supplies 64,535 77,041 102,290 75.3%541,780 12,506
Operation and Contract 627,559 657,791 651,065 101.0%3,584,020 30,232
Other Expenditures 2,173 2,142 2,250 95.2%9,000 (31)
Capital Outlay 35,854 9,713 124,375 7.8%1,292,350 (26,141)
Total Operating Expenditures 3,574,667$ 3,521,196$ 3,902,265$ 90.2%25,023,850$ (53,471)$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 465,651$ 1,595,281$ 147,225$ (445,770)$ 1,129,630$
INTERFUND TRANSACTIONS
Reimbursements From Other Funds 98,946$ 94,204$ 94,200$ 100.0%565,220$ (4,742)$
Reimbursements To Other Funds (17,648) (18,314) (18,160) 100.8%(109,880) (666)
Total Interfund Transactions 81,298$ 75,890$ 76,040$ 99.8%455,340$ (5,408)$
NET FUND INCREASE (DECREASE)546,949$ 1,671,171$ 223,265$ 9,570$ 1,124,222$
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, 2022
Total Total
Revenues Expenditures
02/28/22 Actual 5,116,478$ 3,521,196$
02/28/21 Actual 4,040,318$ 3,574,667$
Change From Last Year 26.6%-1.5%
Major Revenues
Other Telecom/Utility Licenses &Charges for
Sales Tax Intergov. Tax Tax Permits Services
02/28/22 Actual 2,972,631$ 402,665$ 1,076,619$ 275,739$ 245,620$
02/28/21 Actual $ 2,245,253 $ 290,219 $ 973,575 $ 130,659 $ 159,963
Change From Last Year 32.4%38.7%10.6%111.0%53.5%
Five Year Trend
Major Expenditures Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
02/28/22 Actual 2,774,509$ 77,041$ 657,791$ 2,142$ 9,713$
02/28/21 Actual 2,844,546$ 64,535$ 627,559$ 2,173$ 35,854$
Change From Last Year -2.5%19.4%4.8%-1.4%-72.9%
Five Year Trend
Expenditures by Department
2/28/21 2/28/22 2/28/22 2/28/22 2022 Difference Five
YTD YTD YTD % of Annual Prior Year
Department Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 244,706$ 393,007$ 541,560$ 72.6%3,002,480$ 148,301$
Financial Services 56,793 120,537 133,395 90.4%827,030 63,744
Public Works 45,374 103,890 112,545 92.3%928,765 58,516
Engineering & Capital Projects - (803) 9,000 -8.9%384,000 (803)
Library 73,072 168,339 167,040 100.8%996,145 95,267
Police 873,286 1,487,509 1,538,940 96.7%9,869,105 614,223
Fire 633,402 1,109,009 1,234,615 89.8%7,922,040 475,607
Development Services 96,969 139,708 165,170 84.6%1,094,285 42,739
Total Expenditures 2,023,602$ 3,521,196$ 3,902,265$ 90.2%25,023,850$ 1,497,594$
Five Year Trend
For the Period Ending February 28, 2022
General Fund - Five Year Trend
Village of Oak Brook
Revenues Expenditures
2/28/22 2/28/22
2/28/21 2/28/22 YTD % of YTD 2022 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Hotel Tax 43,122$ 128,427$ 91,500$ 140.4%773,500$ 85,305$
Investment Interest 7,024 1,045 3,500 29.8%21,000 (5,979)
Loan Interest - 0.0%6,000 -
Total Operating Revenues 50,146$ 129,472$ 95,000$ 136.3%800,500$ 79,326$
EXPENDITURES
Operation and Contract 39$ 10,040$ 50,075$ 20.0%289,985$ 10,001$
Capital Outlay - 52,696 - 0.0%- 52,696
Total Expenditures 39$ 62,736$ 50,075$ 125.3%289,985$ 62,697$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 50,107$ 66,736$ 44,925$ 148.5%510,515$ 16,629$
INTERFUND TRANSACTIONS
Transfer Out -$ -$ -$ 0.0%(193,375)$ -$
Reimbursements to Other Funds (14,014) (13,800) (13,800) 100.0%(82,800) 214
Total Interfund Transactions (14,014)$ (13,800)$ (13,800)$ 100.0%(276,175)$ 214$
NET FUND INCREASE (DECREASE)36,093$ 52,936$ 31,125$ 234,340$ 16,843$
Note - Expenditures are recorded in program 171.
Village of Oak Brook
Hotel Tax Fund Financial Update
For the Period Ending February 28, 2022
Total Total
Revenues Expenditures
02/28/22 Actual $ 129,472 62,736$
02/28/21 Actual $ 50,146 39$
Change From Last Year 158.2%N/A
Major Revenues Investment
Hotel Tax Interest Loan Interest Miscellaneous
02/28/22 Actual $ 128,427 $ 1,045 -$ -$
02/28/21 Actual $ 43,122 $ 7,024 -$ -$
Change From Last Year 197.8%-85.1%0.0%0.0%
Five Year Trend
Major Expenditures Operation &
Contractual Capital Outlay
02/28/22 Actual 10,040$ 52,696$
02/28/21 Actual 39$ -$
Change From Last Year N/A 0.0%
Five Year Trend
Village of Oak Brook
Hotel Tax Fund - Major Sources Five Year Trend
For the Period Ending February 28, 2022
Five Year Trend
Revenues Expenditures
2/28/22 2/28/22
2/28/21 2/28/22 YTD % of YTD 2022 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Non-Home Rule Sales Tax 972,039$ 1,204,555$ 970,000$ 124.2%5,815,000$ 232,516$
Investment Interest 6,099 5,095 4,830 105.5%27,500 (1,004)
Grants - - - 0.0%1,089,730 -
Miscellaneous - - - 0.0%1,000 -
Total Operating Revenues 978,138$ 1,209,650$ 974,830$ 124.1%6,933,230$ 231,512$
OPERATING EXPENDITURES
Personnel 250,968$ 255,201$ 220,695$ 115.6%1,292,835$ 4,233$
Materials and Supplies 70,114 62,240 68,605 90.7%226,600 (7,874)
Operation and Contract 173,037 141,471 294,350 48.1%1,730,180 (31,566)
Capital Outlay 14,098 10,326 - 0.0%9,226,320 (3,772)
Total Operating Expenditures 508,217$ 469,238$ 583,650$ 80.4%12,475,935$ (38,979)$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 469,921$ 740,412$ 391,180$ 189.3%(5,542,705)$ 270,491$
INTERFUND TRANSACTIONS
Transfers In -$ -$ -$ 0.0%423,375$ -$
Reimbursements From Other Funds 55,308 53,896 53,890 100.0%323,365 (1,412)
Reimbursements To Other Funds (29,384) (19,688) (19,680) 100.0%(118,130) 9,696
Total Interfund Transactions 25,924$ 34,208$ 34,210$ 100.0%628,610$ 8,284$
NET FUND INCREASE (DECREASE)495,845$ 774,620$ 425,390$ (4,914,095)$ 278,775$
Village of Oak Brook
Infrastructure Fund Financial Update
For the Period Ending February 28, 2022
Total Total
Revenues Expenditures
02/28/22 Actual $ 1,209,650 469,238$
02/28/21 Actual $ 978,138 508,217$
Change From Last Year 23.7%-7.7%
Major Revenues
Sales Tax
Charges for
Services
Investment
Interest Miscellaneous
02/28/22 Actual $ 1,204,555 $ - $ 5,095 $ -
02/28/21 Actual $ 972,039 $ - $ 6,099 $ -
Change From Last Year 23.9%0.0%-16.5%0.0%
Five Year Trend
Major Expenditures Materials &Operation &
Personnel Supplies Contractual Capital Outlay
02/28/22 Actual 255,201$ 62,240$ 141,471$ 10,326$
02/28/21 Actual 250,968$ 70,114$ 173,037$ 14,098$
Change From Last Year 1.7%-11.2%-18.2%-26.8%
Five Year Trend
Expenditures by Department
2/28/21 2/28/22 2/28/22 2/28/22 2022 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 15,982$ 16,229$ 35,185$ 46.1%209,510$ 247$
Public Works 451,796 401,520 410,550 97.8%2,380,195 (50,276)
Engineering & Capital Projects 40,439 51,488 137,915 37.3%9,886,230 11,049
Total Expenditures 508,217$ 469,238$ 583,650$ 80.4%12,475,935$ (38,979)$
Five Year Trend
Village of Oak Brook
Infrastructure Fund - Major Sources Five Year Trend
For the Period Ending February 28, 2022
Revenues Expenditures
2/28/22 2/28/22
2/28/21 2/28/22 YTD % of YTD 2022 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax -$ -$ 15,000$ 0.0%90,000$ -$
Real Estate Tax - - - 0.0%405,000 -
Investment Interest 19 11 5 N/A 50 (8)
Total Operating Revenues 19$ 11$ 15,005$ 0.1%495,050$ (8)$
EXPENDITURES
Operation and Contract -$ -$ -$ 0.0%3,900$ -$
Other Expenditures 228,250 243,150 243,150 100.0%486,255 14,900
Total Expenditures 228,250$ 243,150$ 243,150$ 100.0%490,155$ 14,900$
NET FUND INCREASE (DECREASE)(228,231)$ (243,139)$ (228,145)$ 4,895$ (14,908)$
Note - Expenditures are recorded in program 283.
Village of Oak Brook
Promenade TIF Fund Financial Update
For the Period Ending February 28, 2022
Total Total
Revenues Expenditures
02/28/22 Actual $ 11 243,150$
02/28/21 Actual $ 19 228,250$
Change From Last Year -44.3%6.5%
Major Revenues Real Estate Investment
Sales Tax Tax Interest
02/28/22 Actual -$ $ - $ 11
02/28/21 Actual -$ $ - $ 19
Change From Last Year 0.0%0.0%-44.3%
Five Year Trend
Major Expenditures Operation &Other
Contractual Expenditures
02/28/22 Actual -$ 243,150$
02/28/21 Actual -$ 228,250$
Change From Last Year 0.0%6.5%
Five Year Trend
Village of Oak Brook
Promenade TIF Fund - Major Sources Five Year Trend
For the Period Ending February 28, 2022
Five Year Trend
Revenues Expenditures
2/28/22 2/28/22
2/28/21 2/28/22 YTD % of YTD 2022 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Plan Review Fees -$ -$ -$ #DIV/0!1,000$ -$
Building/Inspection Fees - - - #DIV/0!5,000 -
Water Sales 1,135,767 1,332,559 1,162,500 114.6%10,484,500 196,792
Unmetered Sales 6,238 39,279 8,330 471.5%50,000 33,041
Water Connection Fees - 5,980 12,500 47.8%75,000 5,980
Meter Charges - 1,750 2,500 70.0%15,000 1,750
Special Services 765 - 500 0.0%25,000 (765)
Investment Interest 9,593 4,015 5,000 80.3%30,000 (5,578)
Miscellaneous 14,987 17,573 5,000 351.5%30,000 2,586
Total Operating Revenues 1,167,350$ 1,401,157$ 1,196,330$ 117.1%10,715,500$ 233,807$
OPERATING EXPENDITURES
Personnel 122,371$ 76,986$ 101,380$ 75.9%647,620$ (45,385)$
Materials and Supplies 30,714 29,986 11,495 260.9%69,650 (728)
Operation and Contract 353,145 396,585 641,920 61.8%5,400,625 43,440
Capital Outlay 238,549 3,894 - N/A 3,925,000 (234,655)
Total Expenditures 744,779$ 507,451$ 754,795$ 67.2%10,042,895$ (237,328)$
Surplus (Deficit) of Revenues Over
Expenditures 422,571$ 893,706$ 441,535$ 202.4%672,605$ 471,135$
INTERFUND TRANSACTIONS
Reimbursements To Other Funds (75,084) (70,082)$ (70,090)$ 100.0%(420,490)$ 5,002$
Total Interfund Transactions (75,084)$ (70,082)$ (70,090)$ 100.0%(420,490)$ 5,002$
Fund Increase/(Decrease) - Budgetary Basis 347,487$ 823,624$ 371,445$ 221.7%252,115$ 476,137$
ADUSTMENTS TO GAAP BASIS*
Remove Capital Outlay 238,549$ 3,894$
Depreciation Expense (45,725) (47,917)
IMRF Pension Expense 2,472 (3,750)
OPEB Expense 2,304 (2,500)
Total GAAP Adjustments 197,599$ (50,273)$
Fund Increase/(Decrease) - GAAP Basis 545,086$ 773,351$
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, 2022
Total Total
Revenues Expenditures
02/28/22 Actual $ 1,401,157 507,451$
02/28/21 Actual $ 1,167,350 744,779$
Change From Last Year 20.0%-31.9%
Unmetered Water
Water Sales Sales Connection Fees Meter Charges Miscellaneous
02/28/22 Actual $ 1,332,559 $ 39,279 $ 5,980 $ 1,750 $ 17,573
02/28/21 Actual $ 1,135,767 $ 6,238 $ - $ - $ 14,987
Change From Last Year 17.3%N/A N/A N/A 17.3%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
02/28/22 Actual 76,986$ 29,986$ 396,585$ -$ 3,894$
02/28/21 Actual 122,371$ 30,714$ 353,145$ -$ 238,549$
Change From Last Year -37.1%-2.4%12.3%0.0%N/A
Five Year Trend
Expenditures by Department
2/28/21 2/28/22 2/28/22 2/28/22 2022 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Public Works 486,415$ 484,187$ 754,795$ 64.1%6,067,895$ (2,228)$
Engineering & Capital Projects 258,364 23,265 - #DIV/0!3,975,000 (235,100)
Total Expenditures 744,779$ 507,451$ 754,795$ 67.2%10,042,895$ (237,328)$
Five Year Trend
Village of Oak Brook
Water Fund - Major Sources Five Year Trend
For the Period Ending February 28, 2022
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Sports Core Fund Consolidated Presentation
For the Period Ending February 28, 2022
2/28/22 2/28/22
2/28/22 YTD % of YTD 2022 2/28/21 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 450$ -$ -$ -$ 450$ 3,600$ 0.0%801,750$ 7,500$ (7,050)$
Greens Fees - - - - - - 0.0%1,145,000 - -
Pro Shop Sales - - - 6,112 6,112 3,270 186.9%210,000 3,789 2,323
Golf Lessons - - - - - - 0.0%50,000 - -
Driving Range Fees - - - (17) (17) - 0.0%300,000 550 (567)
Rentals - 1,393 7,344 - 8,737 12,000 72.8%993,775 4,966 3,771
Programs/User Fees - - - - - - 0.0%15,500 - -
Food Sales - - - 2,576 2,576 - N/A 286,000 - 2,576
Beverage Sales - - - 4,053 4,053 - N/A 490,000 - 4,053
Taste of Oak Brook - - - - - - 0.0%120,000 - -
Grants - - - - - - 0.0%- - -
Other Revenue 57 - - - 57 260 21.9%8,000 7,145 (7,088)
Total Operating Revenues 507$ 1,393$ 7,344$ 12,723$ 21,967$ 19,130$ 114.8%4,420,025$ 23,950$ (1,983)$
OPERATING EXPENDITURES
Personnel 249$ -$ 18,612$ 103,855$ 122,717$ 160,075$ 76.7%1,671,380$ 128,371$ (5,654)$
Materials & Supplies 24 - 7 30,817 30,849 16,090 191.7%718,900 415 30,434
Operational & Contractual 7,164 1,736 4,592 42,678 56,171 63,310 88.7%942,765 95,796 (39,625)
Other - - - - - 9,440 0.0%- - -
Capital (874) - 874 - 0 (11,745) 0.0%466,750 65,782 (65,782)
Total Operating Expenditures 6,564$ 1,736$ 24,086$ 177,351$ 209,736$ 237,170$ 88.4%3,799,795$ 290,364$ (80,628)$
B&T Administration Overhead Allocation*-$ -$ -$ -$ -$ (11,745)$ 0.0%-$ -$ -$
Operating Revenues Over (Under) Expenditures (6,057)$ (343)$ (16,741)$ (164,627)$ (187,769)$ (229,785)$ 81.7%620,230$ (266,414)$ 78,645$
INTERFUND TRANSACTIONS
Transfer From Golf Surcharge Fund -$ -$ -$ -$ -$ -$ 0.0%150,000$ -$ -$
Reimbursement From Infrastructure Fund - - - - - - 0.0%- 5,334 (5,334)
Reimbursement From Water Fund - - - - - - 0.0%- 1,334 (1,334)
Reimbursement To General Fund (3,144) - - (9,432) (12,576) (3,140) 400.5%(75,455) (10,482) (2,094)
Total Interfund Transactions (3,144)$ -$ -$ (9,432)$ (12,576)$ (3,140)$ 400.5%74,545$ (3,814)$ (8,762)$
Total Revenues Over (Under) Expenditures - Budgetary Basis (9,201)$ (343)$ (16,741)$ (174,059)$ (200,345)$ (232,925)$ 694,775$ (270,228)$ 69,883$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay (874)$ -$ 874$ -$ 0$ 65,782$
Depreciation Expense (10,622) (1,152) (5,217) (19,661) (36,651) (35,475)
IMRF Pension Expense (83) - (167) (1,917) (2,167) 5,458
OPEB Expense - - (250) (1,925) (2,175) (2,134)
Total GAAP Adjustments (11,579)$ (1,152)$ (4,759)$ (23,503)$ (40,993)$ 33,631$
Fund Increase/(Decrease) - GAAP Basis (20,780)$ (1,495)$ (21,501)$ (197,562)$ (241,337)$ (236,597)$
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.
Total Direct Total Direct
Revenues Expenditures
02/28/22 Actual $ 21,967 209,736$
02/28/21 Actual $ 23,950 290,364$
Change From Last Year -8.3%-27.8%
Driving Program/
Memberships Greens Fees Range Fees Rentals User Fees
02/28/22 Actual $ 450 $ - $ (17) $ 8,737 -$
02/28/21 Actual $ 7,500 $ - $ 550 $ 4,966 -$
Change From Last Year -94.0%0.0%-103.1%75.9%0.0%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
02/28/22 Actual 122,717$ 30,849$ 56,171$ -$ 0$
02/28/21 Actual 128,371$ 415$ 95,796$ -$ 65,782$
Change From Last Year -4.4%7333.4%-41.4%0.0%0.0%
Five Year Trend
Revenues by Department 2/28/21 2/28/22 2/28/22 2/28/22 2022 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Operations 6,885$ 507$ 160$ 316.9%521,450$ (6,378)$
Open Field Operations 5,000 1,393 2,000 69.6%375,000 (3,607)
B&T Clubhouse Operations - 7,344 10,000 73.4%351,275 7,344
Golf Club 12,065 12,723 6,970 182.5%3,172,300 658
Total Revenues 23,950$ 21,967$ 19,130$ 114.8%4,420,025$ (1,983)$
Expenditures by Department 2/28/21 2/28/22 2/28/22 % of YTD 2022 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Operations 82,318$ 6,564$ 9,365$ 70.1%567,180$ (75,754)$
Open Field Operations 25,998$ 1,736$ 4,240$ 40.9%250,660$ (24,262)$
B&T Clubhouse Operations 21,207 24,086 32,530 74.0%298,200 2,879
Golf Club 160,841 177,351 191,035 92.8%2,683,755 16,510
Total Expenditures 290,364$ 209,736$ 237,170$ 88.4%3,799,795$ (80,628)$
Five Year Trend
Village of Oak Brook
Sports Core Fund - Major Sources Five Year Trend
For the Period Ending February 28, 2022
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Bath & Tennis Club Recreation Operations
For the Period Ending February 28, 2022 2/28/22 2/28/22
822 2/28/22 YTD % of YTD 2022 2/28/21 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 -$ 450$ -$ -$ 450$ -$ 0.0%448,950$ -$ 450$
Programs/User Fees - - - - - - 0.0%15,500 - -
Food Sales - - - - - - 0.0%36,000 - -
Beverage Sales - - - - - - 0.0%20,000 - -
Grants - - - - - - 0.0%- - -
Other Revenue 57 - - - 57 160 35.6%1,000 6,885 (6,828)
Total Operating Revenues 57$ 450$ -$ -$ 507$ 160$ 316.9%521,450$ 6,885$ (6,378)$
OPERATING EXPENDITURES
Personnel 249$ -$ -$ -$ 249$ 4,670$ 5.3%127,350$ -$ 249$
Materials & Supplies - - 24 - 24 80 30.5%74,550 2,483 (2,459)
Operational & Contractual 7,125 - 40 - 7,164 16,360 43.8%307,530 14,053 (6,889)
Capital (1,747) 629 175 70 (874) (11,745) 0.0%57,750 65,782 (66,656)
Total Operating Expenditures 5,626$ 629$ 239$ 70$ 6,564$ 9,365$ 70.1%567,180$ 82,318$ (75,754)$
B&T Administration Overhead Allocation*-$ -$ -$ -$ -$ -$ #DIV/0!68,810$ 8,820$ (8,820)$
Operating Revenues Over (Under) Expenditures (5,569)$ (179)$ (239)$ (70)$ (6,057)$ (9,205)$ 65.8%23,080$ (66,613)$ 60,556$
INTERFUND TRANSACTIONS
Reimbursement From Infrastructure Fund -$ -$ -$ -$ -$ -$ 0.0%-$ 5,334 (5,334)$
Reimbursement From Water Fund - - - - - - 0.0%- 1,334 (1,334)
Reimbursement To General Fund (3,144) - - - (3,144) (3,140) 100.1%(18,865) (2,620) (524)
Total Interfund Transactions (3,144)$ -$ -$ -$ (3,144)$ (3,140)$ 100.1%(18,865)$ 4,048$ (7,192)$
Total Revenues Over (Under) Expenditures - Budgetary Basis (8,713)$ (179)$ (239)$ (70)$ (9,201)$ (12,345)$ 4,215$ (62,565)$ 53,364$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay (1,747)$ 629$ 175$ 70$ (874)$ 65,782$
Depreciation Expense (1,133) (9,167) (224) (98) (10,622) (10,417)
IMRF Pension Expense (83) - - - (83) 97
Total GAAP Adjustments (2,964)$ (8,538)$ (49)$ (28)$ (11,579)$ 55,463$
Fund Increase/(Decrease) - GAAP Basis (11,677)$ (8,717)$ (288)$ (98)$ (20,780)$ (7,103)$
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, 2022 2/28/22 2/28/22
2/28/22 YTD % of YTD 2022 2/28/21 Difference
815 816 YTD Amended Amended Adopted YTD Prior
Polo Open Fields Total Budget Budget Budget Total Year
OPERATING REVENUES
Field Rentals -$ 1,393$ 1,393$ 2,000$ 69.6%170,000$ 5,000$ (3,607)$
Range Rentals - - - - 0.0%85,000 - -
Taste of Oak Brook - - - - 0.0%120,000 - -
Grants - - - - 0.0%- - -
Total Operating Revenues -$ 1,393$ 1,393$ 2,000$ 69.6%375,000$ 5,000$ (3,607)$
OPERATING EXPENDITURES
Materials & Supplies -$ -$ -$ 100$ 0.0%1,500$ -$ -$
Operational & Contractual - 1,736 1,736 4,140 41.9%249,160 25,998 (24,262)
Capital - - - - 0.0%- - -
Total Operating Expenditures -$ 1,736$ 1,736$ 4,240$ 40.9%250,660$ 25,998$ (24,262)$
Total Revenues Over (Under) Expenditures - Budgetary Basis -$ (343)$ (343)$ (2,240)$ 124,340$ (20,998)$ 20,655$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay -$ -$ -$ -$
Depreciation Expense - (1,152) (1,152) (281)
Total GAAP Adjustments -$ (1,152)$ (1,152)$ (323)$
Fund Increase/(Decrease) - GAAP Basis -$ (1,495)$ (1,495)$ (21,321)$
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, 2022
2/28/22 2/28/22
821 YTD % of YTD 2022 2/28/21 Difference
B&T Amended Amended Adopted YTD Prior
Clubhouse Budget Budget Budget Total Year
OPERATING REVENUES
Rentals 7,344$ 10,000$ 73.4%351,275$ -$ 7,344$
Total Operating Revenues 7,344$ 10,000$ 73.4%351,275$ -$ 7,344$
OPERATING EXPENDITURES
Personnel 18,612$ 18,700$ 99.5%140,250$ 16,548$ 2,064$
Materials & Supplies 7 2,810 0.2%15,350 1,009 (1,002)
Operational & Contractual 4,592 11,020 41.7%92,600 3,650 942
Capital 874 - 0.0%50,000 - 874
Total Operating Expenditures 24,086$ 32,530$ 74.0%298,200$ 21,207$ 2,879$
B&T Administration Overhead Allocation*-$ (11,745)$ 0.0%(68,810)$ (8,820)$ 8,820$
Total Revenues Over (Under) Expenditures - Budgetary Basis (16,741)$ (34,275)$ (15,735)$ (30,027)$ 13,286$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay 874$ -$
Depreciation Expense (5,217) (5,217)
IMRF Pension Expense (167) 517
OPEB Expense (250) (250)
Total GAAP Adjustments (4,759)$ (4,950)$
Fund Increase/(Decrease) - GAAP Basis (21,501)$ (34,977)$
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, 2022
2/28/22 2/28/22
823 831 832 833 834 2/28/22 YTD % of YTD 2022 2/28/21 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 -$ -$ -$ - - -$ 3,600$ 0.0%352,800$ 7,500$ (7,500)$
Greens Fees - - - - - - - 0.0%1,145,000 - -
Pro Shop Sales - 6,112 - - - 6,112 3,270 186.9%210,000 3,789 2,323
Golf Lessons - - - - - - - 0.0%50,000 - -
Driving Range Fees - - - (17) - (17) - 0.0%300,000 550 (567)
Rentals - - - - - - - N/A 387,500 (34) 34
Food Sales 2,576 - - - - 2,576 - N/A 250,000 - 2,576
Beverage Sales 4,053 - - - - 4,053 - N/A 470,000 - 4,053
Other Revenue - - - - - - 100 N/A 7,000 260 (260)
Total Operating Revenues 6,628$ 6,112$ -$ (17)$ -$ 12,723$ 6,970$ 182.5%3,172,300$ 12,065$ 658$
OPERATING EXPENDITURES
Personnel 9,260$ 60,846$ -$ -$ 33,749$ 103,855$ 136,705$ 76.0%1,403,780$ 111,823$ (7,968)$
Materials & Supplies 7,886 15,430 4,320 109 3,073 30,817 13,100 235.2%627,500 (3,077) 33,894
Operational & Contractual 763 27,765 606 - 13,545 42,678 31,790 134.3%293,475 52,095 (9,417)
Other - - - - - - 9,440 0.0%- - -
Capital - - - - - - - 0.0%359,000 - -
Total Operating Expenditures 17,908$ 104,040$ 4,926$ 109$ 50,367$ 177,351$ 191,035$ 92.8%2,683,755$ 160,841$ 16,510$
Operating Revenues Over (Under) Expenditures (11,280)$ (97,928)$ (4,926)$ (126)$ (50,367)$ (164,627)$ (184,065)$ 89.4%488,545$ (148,776)$ (15,851)$
INTERFUND TRANSACTIONS
Transfer from Golf Surcharge -$ -$ -$ -$ -$ -$ -$ 0.0%150,000$ -$ -$
Reimbursement to General Fund - (9,432) - - - (9,432) - #DIV/0!(56,590) (7,862) (1,570)
Total Interfund Transactions -$ (9,432)$ -$ -$ -$ (9,432)$ -$ #DIV/0!93,410$ (7,862)$ (1,570)$
Total Revenues Over (Under) Expenditures - Budgetary Basis (11,280)$ (107,360)$ (4,926)$ (126)$ (50,367)$ (174,059)$ (184,065)$ 581,955$ (156,638)$ (17,421)$
ADUSTMENTS TO GAAP BASIS*
Remove Capital Outlay -$ -$ -$ -$ -$ -$ -$
Depreciation Expense (252) (7,985) (192) (1,021) (10,213) (19,661) (19,561)
IMRF Pension Expense (208) (792) (83) - (833) (1,917) 4,886
OPEB Expense (217) (1,083) - - (625) (1,925) (1,884)
Total GAAP Adjustments (677)$ (9,860)$ (275)$ (1,021)$ (11,671)$ (23,503)$ (16,559)$
Fund Increase/(Decrease) - GAAP Basis (11,957)$ (117,220)$ (5,201)$ (1,147)$ (62,037)$ (197,562)$ (173,197)$
Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.