06 - June 2022 Monthly Financial ReportVILLAGE
OAK BROOKOF
MONTHLY FINANCIAL REPORTS
JUNE 2022
ITEM 6.E
YTD YTD
Net Fund Budgeted
YTD YTD Increase Increase
Governmental Funds Revenues Expenditures (Decrease)(Decrease)
General Fund (Major Fund)16,789,424$ 10,977,190$ 5,812,235$ 4,785$
Main operating fund of the Village.
Hotel Fund (Major Fund)517,996$ 137,898$ 380,097$ 117,170$
Collects and spends resources from the
3% hotel/motel tax.
Motor Fuel Tax Fund 243,378$ -$ 243,378$ 157,960$
Collects and spends resources from the
State motor fuel tax.
Infrastructure Fund (Major Fund)3,902,080$ 2,705,452$ 1,196,627$ (2,457,048)$
Accounts for construction and maintenance of
roadways, drainage, and safety path systems.
Promenade TIF Fund (Major Fund)207,903$ 243,150$ (35,247)$ 2,448$
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)4,863,574$ 1,851,819$ 3,011,755$ 126,058$
Collects user fees for the distribution of water
and maintenance of infrastructure.
Sports Core Fund (Major Fund)2,420,298$ 1,341,517$ 1,078,781$ 347,388$
Accounts for revenues and expenses relating
to administration, programs, food and beverage
operations, and golf course.
Golf Surcharge Fund 59,883$ -$ 59,883$ (46,500)$
Accounts for the collection of the $3 per round
golf surcharge.
Internal Service Funds
Self Insurance Fund 1,582,081$ 1,296,878$ 285,203$ 66,675$
Accounts for the Village's health insurance costs
and the related contributions from the Village,
employees, retirees, and other agencies.
Garage Fund 311,368$ 309,631$ 1,737$ (17,760)$
Accounts for the maintenance of the Village's vehicle
fleet and the related departmental reimbursements.
Equipment Replacement Fund 466,535$ 434,137$ 32,398$ (133,965)$
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 June 30, 2022
6/30/22 6/30/22
6/30/21 6/30/22 YTD % of YTD 2022 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 6,498,311$ 9,139,691 6,600,000$ 138.5%13,200,000$ 2,641,380$
Other Intergovernmental Tax*1,041,206 1,570,965 809,200 194.1%1,618,400 529,759
Telecommunications/Utility Tax 2,798,505 2,957,981 2,797,500 105.7%5,595,000 159,476
Grants 10,466 7,500 100.0%15,000 10,466
Licenses and Permits 1,166,063 1,203,577 1,003,755 119.9%2,007,510 37,514
Charges for Services 543,139 1,160,543 577,450 201.0%1,154,900 617,404
Fines and Penalties 83,488 52,547 71,000 74.0%142,000 (30,941)
Administrative Towing Fees 13,724 25,500 12,500 204.0%25,000 11,776
Investment Interest 98,725 79,205 72,000 110.0%144,000 (19,520)
Franchise Fees 52,636 109,116 99,000 110.2%198,000 56,480
Installment Contract Proceeds - 0.0%-
Miscellaneous Income 229,450 197,220 239,135 82.5%478,270 (32,230)
Total Operating Revenues 12,525,247$ 16,506,812$ 12,289,040$ 134.3%24,578,080$ 3,981,565$
OPERATING EXPENDITURES
Personnel 8,168,894$ 8,905,879$ 9,798,350$ 90.9%19,596,700$ 736,985$
Materials and Supplies 199,477 187,786 270,890 69.3%541,780 (11,691)$
Operation and Contract 1,631,552 1,758,441 1,792,010 98.1%3,584,020 126,889$
Other Expenditures 4,315 4,290 4,500 95.3%9,000 (26)$
Capital Outlay 120,742 65,851 646,175 10.2%1,292,350 (54,891)$
Total Operating Expenditures 10,124,980$ 10,922,248$ 12,511,925$ 87.3%25,023,850$ 797,268$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 2,400,267$ 5,584,565$ (222,885)$ -2505.6%(445,770)$ 3,184,298$
INTERFUND TRANSACTIONS
Transfers In -$ -$ -$ N/A -$ -$
Transfers Out - N/A -
Reimbursements From Other Funds 296,838 282,612 282,610 100.0%565,220 (14,226)
Reimbursements To Other Funds (52,944) (54,942) (54,940) 100.0%(109,880) (1,998)
Sports Core Loan - N/A - -
Total Interfund Transactions 243,894$ 227,670$ 227,670$ 100.0%455,340$ (16,224)$
NET FUND INCREASE (DECREASE)2,644,161$ 5,812,235$ 4,785$ 9,570$ 3,168,074$
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 June 30, 2022
Total Total
Revenues Expenditures
6/30/22 Actual 16,506,812$ 10,922,248$
6/30/21 Actual 12,525,247$ 10,124,980$
Change From Last Year 31.8%7.9%
Major Revenues
Other Telecom/Utility Licenses &Charges for
Sales Tax Intergov. Tax Tax Permits Services
6/30/22 Actual 9,139,691$ 1,570,965$ 2,957,981$ 1,203,577$ 1,160,543$
6/30/21 Actual $ 6,498,311 $ 1,041,206 $ 2,798,505 $ 83,488 $ 13,724
Change From Last Year 40.6%50.9%5.7%1341.6%8356.3%
Five Year Trend
Major Expenditures Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
6/30/22 Actual 8,905,879$ 187,786$ 1,758,441$ 4,290$ 65,851$
6/30/21 Actual 8,168,894$ 199,477$ 1,631,552$ 4,315$ 120,742$
Change From Last Year 9.0%-5.9%7.8%-0.6%-45.5%
Five Year Trend
Expenditures by Department
6/30/21 6/30/22 6/30/22 6/30/22 2022 Difference Five
YTD YTD YTD % of Annual Prior Year
Department Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 555,439$ 555,048$ 784,905$ 70.7%3,002,480$ (391)$
Financial Services 178,532 207,071 194,640 106.4%827,030 28,539
Public Works 223,019 157,826 183,560 86.0%928,765 (65,193)
Engineering & Capital Projects 4,547 11,172 139,000 8.0%384,000 6,625
Library 206,516 233,222 239,800 97.3%996,145 26,706
Police 2,034,356 2,185,963 2,336,800 93.5%9,869,105 151,607
Fire 1,767,963 1,611,145 1,872,020 86.1%7,922,040 (156,818)
Development Services 257,484 222,207 250,015 88.9%1,094,285 (35,277)
Total Expenditures 5,227,856$ 5,183,655$ 6,000,740$ 86.4%25,023,850$ (44,201)$
Five Year Trend
For the Period Ending June 30, 2022
General Fund - Five Year Trend
Village of Oak Brook
Revenues Expenditures
6/30/22 6/30/22
6/30/21 6/30/22 YTD % of YTD 2022 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Hotel Tax 240,607$ 512,885$ 386,750$ 132.6%773,500$ 272,278$
Investment Interest 19,187 5,110 10,500 48.7%21,000 (14,077)
Loan Interest 4,000 - 3,000 N/A 6,000 (4,000)
Total Operating Revenues 263,794$ 517,996$ 400,250$ 129.4%800,500$ 254,202$
EXPENDITURES
Operation and Contract 55,124$ 43,803$ 144,993$ 30.2%289,985$ (11,321)$
Capital Outlay 2,650 52,696 - N/A - 50,046
Total Expenditures 57,774$ 96,498$ 144,993$ 66.6%289,985$ 38,724$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 206,020$ 421,497$ 255,258$ 165.1%510,515$ 215,477$
INTERFUND TRANSACTIONS
Transfer Out (1,462,918)$ -$ (96,688)$ N/A (193,375)$ 1,462,918$
Reimbursements to Other Funds (42,042) (41,400) (41,400) 100.0%(82,800) 642
Total Interfund Transactions (1,504,960)$ (41,400)$ (138,088)$ 30.0%(276,175)$ 1,463,560$
NET FUND INCREASE (DECREASE)(1,298,940)$ 380,097$ 117,170$ 234,340$ 1,679,037$
Note - Expenditures are recorded in program 171.
Village of Oak Brook
Hotel Tax Fund Financial Update
For the Period Ending June 30, 2022
Total Total
Revenues Expenditures
6/30/22 Actual $ 517,996 96,498$
6/30/21 Actual $ 263,794 57,774$
Change From Last Year 96.4%67.0%
Major Revenues Investment
Hotel Tax Interest Loan Interest Miscellaneous
6/30/22 Actual $ 512,885 $ 5,110 4,000$ -$
6/30/21 Actual $ 240,607 $ 19,187 -$ -$
Change From Last Year 113.2%-73.4%0.0%0.0%
Five Year Trend
Major Expenditures Operation &
Contractual Capital Outlay
6/30/22 Actual 43,803$ 52,696$
6/30/21 Actual 55,124$ 2,650$
Change From Last Year -20.5%N/A
Five Year Trend
Village of Oak Brook
Hotel Tax Fund - Major Sources Five Year Trend
For the Period Ending June 30, 2022
Five Year Trend
Revenues Expenditures
6/30/22 6/30/22
6/30/21 6/30/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 2,798,331$ 3,710,894$ 2,907,500$ 1$ 5,815,000$ 912,563$
Investment Interest 16,837 29,498 13,750 122.5%27,500 12,661
Grants - 544,865 N/A 1,089,730 -
Miscellaneous 3,080 - 500 0.0%1,000 (3,080)
Total Operating Revenues 2,818,248$ 3,740,392$ 3,466,615$ 107.9%6,933,230$ 922,144$
OPERATING EXPENDITURES
Personnel 761,459$ 694,117$ 646,418$ 107.4%1,292,835$ (67,342)$
Materials and Supplies 136,212 123,372 113,300 108.9%226,600 (12,840)
Operation and Contract 553,296 480,053 865,090 55.5%1,730,180 (73,243)
Other Expenditures - #DIV/0!-
Capital Outlay 2,797,028 1,348,846 4,613,160 29.2%9,226,320 (1,448,182)
Total Operating Expenditures 4,247,995$ 2,646,388$ 6,237,968$ 42.4%12,475,935$ (1,601,607)$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES (1,429,747)$ 1,094,003$ (2,771,353)$ -39.5%(5,542,705)$ 2,523,750$
INTERFUND TRANSACTIONS
Transfers In 1,462,918$ -$ 211,688$ N/A 423,375$ (1,462,918)$
Reimbursements From Other Funds 165,924 161,688 161,683 100.0%323,365 (4,236)
Reimbursements To Other Funds (88,152) (59,064) (59,065) 100.0%(118,130) 29,088
Total Interfund Transactions 1,540,690$ 102,624$ 314,305$ 32.7%628,610$ (1,438,066)$
NET FUND INCREASE (DECREASE)110,943$ 1,196,627$ (2,457,048)$ (4,914,095)$ 1,085,684$
Village of Oak Brook
Infrastructure Fund Financial Update
For the Period Ending June 30, 2022
Total Total
Revenues Expenditures
6/30/22 Actual $ 3,740,392 2,646,388$
6/30/21 Actual $ 2,818,248 4,247,995$
Change From Last Year 32.7%-37.7%
Major Revenues
Sales Tax
Charges for
Services
Investment
Interest Miscellaneous
6/30/22 Actual $ 3,710,894 $ - $ 29,498 $ -
6/30/21 Actual $ 2,798,331 $ - $ 16,837 #REF!
Change From Last Year 32.6%0.0%75.2%0.0%
Five Year Trend
Major Expenditures Materials &Operation &
Personnel Supplies Contractual Capital Outlay
6/30/22 Actual 694,117$ 123,372$ 480,053$ 1,348,846$
6/30/21 Actual 761,459$ 136,212$ 553,296$ 2,797,028$
Change From Last Year -8.8%-9.4%-13.2%-51.8%
Five Year Trend
Expenditures by Department
6/30/21 6/30/22 6/30/22 6/30/22 2022 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 36,285$ 28,892$ 52,010$ 55.5%209,510$ (7,394)$
Public Works 651,848 589,033 584,365 100.8%2,380,195 (62,815)
Engineering & Capital Projects 768,463 98,940 706,825 14.0%9,886,230 (669,523)
Total Expenditures 1,456,596$ 716,864$ 1,343,200$ 53.4%12,475,935$ (739,732)$
Five Year Trend
Village of Oak Brook
Infrastructure Fund - Major Sources Five Year Trend
For the Period Ending June 30, 2022
Revenues Expenditures
6/30/22 6/30/22
6/30/21 6/30/22 YTD % of YTD 2022 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 35,586$ -$ 45,000$ 0.0%90,000$ (35,586)$
Real Estate Tax 204,228 207,773 202,500 N/A 405,000 3,545
Investment Interest 28 130 25 520.3%50 102
Total Operating Revenues 239,842$ 207,903$ 247,525$ 83.993%495,050$ (31,939)$
EXPENDITURES
Operation and Contract 2,763$ -$ 1,950$ N/A 3,900$ (2,763)$
Other Expenditures 481,500 243,150 243,128 100.0%486,255 (238,350)
Total Expenditures 484,263$ 243,150$ 245,078$ 99.2%490,155$ (241,113)$
NET FUND INCREASE (DECREASE)(244,421)$ (35,247)$ 2,448$ 4,895$ 209,174$
Note - Expenditures are recorded in program 283.
Village of Oak Brook
Promenade TIF Fund Financial Update
For the Period Ending June 30, 2022
Total Total
Revenues Expenditures
6/30/22 Actual $ 207,903 243,150$
6/30/21 Actual $ 239,842 484,263$
Change From Last Year -13.3%-49.8%
Major Revenues Real Estate Investment
Sales Tax Tax Interest
6/30/22 Actual -$ $ 207,773 $ 130
6/30/21 Actual 35,586$ $ 204,228 $ 28
Change From Last Year -100.0%0.0%364.6%
Five Year Trend
Major Expenditures Operation &Other
Contractual Expenditures
6/30/22 Actual -$ 243,150$
6/30/21 Actual 2,763$ 481,500$
Change From Last Year 0.0%-49.5%
Five Year Trend
Village of Oak Brook
Promenade TIF Fund - Major Sources Five Year Trend
For the Period Ending June 30, 2022
Five Year Trend
Revenues Expenditures
6/30/22 6/30/22
6/30/21 6/30/22 YTD % of YTD 2022 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Plan Review Fees 375$ 375$ 500$ 75.0%1,000$ -$
Building/Inspection Fees 2,700 1,200 2,500 48.0%5,000 (1,500)
Water Sales 3,754,330 4,247,022 5,242,250 81.0%10,484,500 492,692
Unmetered Sales 9,690 50,247 25,000 201.0%50,000 40,557
Water Connection Fees 181,240 483,920 37,500 1290.5%75,000 302,680
Fire Service Charge - N/A -
Meter Charges 6,126 16,174 7,500 215.7%15,000 10,048
Special Services 12,757 - 12,500 0.0%25,000 (12,757)
Investment Interest 26,596 15,519 15,000 103.5%30,000 (11,077)
Miscellaneous 638,399 49,117 15,000 327.4%30,000 (589,282)
Total Operating Revenues 4,632,213$ 4,863,574$ 5,357,750$ 90.8%10,715,500$ 231,361$
OPERATING EXPENDITURES
Personnel 374,196$ 205,960$ 323,810$ 63.6%647,620$ (168,236)$
Materials and Supplies 46,538 41,854 34,825 120.2%69,650 (4,684)
Operation and Contract 1,702,329 1,387,365 2,700,313 51.4%5,400,625 (314,964)
Capital Outlay 2,503,635 6,394 1,962,500 N/A 3,925,000 (2,497,241)
Total Expenditures 4,626,698$ 1,641,573$ 5,021,448$ 32.7%10,042,895$ (2,985,125)$
Surplus (Deficit) of Revenues Over
Expenditures 5,515$ 3,222,001$ 336,303$ 958.1%672,605$ 3,216,486$
INTERFUND TRANSACTIONS
Reimbursements To Other Funds (225,252)$ (210,246)$ (210,245)$ 100.0%(420,490)$ 15,006$
Total Interfund Transactions (225,252)$ (210,246)$ (210,245)$ 100.0%(420,490)$ 15,006$
Fund Increase/(Decrease) - Budgetary Basis (219,737)$ 3,011,755$ 126,058$ 2389.2%252,115$ 3,231,492$
ADUSTMENTS TO GAAP BASIS*
Remove Capital Outlay 2,503,635$ 6,394$
Depreciation Expense (287,500) (287,500)
IMRF Pension Expense (22,500) (22,500)
OPEB Expense (15,000) (15,000)
Total GAAP Adjustments 2,178,635$ (318,606)$
Fund Increase/(Decrease) - GAAP Basis 1,958,898$ 2,693,149$
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 June 30, 2022
Total Total
Revenues Expenditures
6/30/22 Actual $ 4,863,574 1,641,573$
6/30/21 Actual $ 4,632,213 4,626,698$
Change From Last Year 5.0%-64.5%
Unmetered Water
Water Sales Sales Connection Fees Meter Charges Miscellaneous
6/30/22 Actual $ 4,247,022 $ 50,247 $ 483,920 $ 16,174 $ 49,117
6/30/21 Actual $ 3,754,330 $ 9,690 $ 181,240 $ 6,126 $ 638,399
Change From Last Year 13.1%418.5%167.0%164.0%-92.3%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
6/30/22 Actual 205,960$ 41,854$ 1,387,365$ -$ 6,394$
6/30/21 Actual 374,196$ 46,538$ 1,702,329$ -$ 2,503,635$
Change From Last Year -45.0%-10.1%-18.5%0.0%-99.7%
Five Year Trend
Expenditures by Department
6/30/21 6/30/22 6/30/22 6/30/22 2022 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Public Works 838,833$ 813,074$ 1,140,710$ 73.5%6,067,895$ 25,759$
Engineering & Capital Projects 527,386 23,265 - 0.0%3,975,000 504,122
Total Expenditures 1,366,219$ 836,338$ 1,140,710$ 73.3%10,042,895$ 529,881$
Five Year Trend
Village of Oak Brook
Water Fund - Major Sources Five Year Trend
For the Period Ending June 30, 2022
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Sports Core Fund Consolidated Presentation
For the Period Ending June 30, 2022
6/30/22 6/30/22
6/30/22 YTD % of YTD 2022 6/30/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 400,955$ -$ -$ 404,425$ 805,380$ 400,875$ 200.9%801,750$ 356,915$ 448,465$
Greens Fees - - - 457,154 457,154 572,500 79.9%1,145,000 527,141 (69,987)
Pro Shop Sales - - - 94,548 94,548 105,000 90.0%210,000 125,997 (31,449)
Golf Lessons - - - 33,158 33,158 25,000 132.6%50,000 46,525 (13,367)
Driving Range Fees - - - 210,597 210,597 150,000 140.4%300,000 215,198 (4,602)
Rentals - 178,143 99,546 159,771 437,460 496,888 88.0%993,775 325,538 111,922
Programs/User Fees 50,302 - - - 50,302 7,750 0.0%15,500 - 50,302
Food Sales 22,149 - - 101,790 123,938 143,000 86.7%286,000 109,460 14,478
Beverage Sales 8,763 - - 182,604 191,367 245,000 78.1%490,000 197,121 (5,754)
Taste of Oak Brook - 15,500 - - 15,500 60,000 0.0%120,000 - 15,500
Grants - - - - - - 0.0%- - -
Other Revenue 684 - - - 684 4,000 17.1%8,000 12,380 (11,696)
Total Operating Revenues 482,853$ 193,643$ 99,546$ 1,644,046$ 2,420,088$ 2,210,013$ 109.5%4,420,025$ 1,916,275$ 503,813$
OPERATING EXPENDITURES
Personnel 34,563$ -$ 63,263$ 524,302$ 622,128$ 835,690$ 74.4%1,671,380$ 573,794$ 48,334$
Materials & Supplies 21,338 - 427 134,289 156,055 359,450 43.4%718,900 281,245 (125,190)
Operational & Contractual 130,392 14,638 33,840 142,456 321,326 471,383 68.2%942,765 253,039 68,287
Other - - - - - - N/A - - -
Capital 171,798 - - 32,481 204,279 233,375 87.5%466,750 149,752 54,527
Total Operating Expenditures 358,091$ 14,638$ 97,531$ 833,528$ 1,303,789$ 1,899,898$ 68.6%3,799,795$ 1,257,830$ 45,959$
B&T Administration Overhead Allocation*12,352$ -$ (12,352)$ -$ (0)$ -$ N/A -$ -$ (0)$
Operating Revenues Over (Under) Expenditures 137,113$ 179,005$ (10,337)$ 810,518$ 1,116,299$ 310,115$ 360.0%620,230$ 658,445$ 457,854$
INTERFUND TRANSACTIONS
Interfund Loan**-$ -$ -$ -$ -$ -$ 0.0%-$ -$ -$
Transfer From General Fund 210 - - - 210 - 0.0%- - 210
Transfer From Golf Surcharge Fund - - - - - 75,000 0.0%150,000 - -
Reimbursement From Infrastructure Fund - - - - - - 0.0%- 16,002 (16,002)
Reimbursement From Water Fund - - - - - - 0.0%- 4,002 (4,002)
Reimbursement To General Fund (9,432) - - (28,296) (37,728) (37,728) 100.0%(75,455) (31,446) (6,282)
Total Interfund Transactions (9,222)$ -$ -$ (28,296)$ (37,518)$ 37,273$ -100.7%74,545$ (11,442)$ (26,076)$
Total Revenues Over (Under) Expenditures - Budgetary Basis 127,891$ 179,005$ (10,337)$ 782,222$ 1,078,781$ 347,388$ 694,775$ 647,003$ 431,778$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay 171,798$ -$ -$ 32,481$ 204,279$ 149,752$
Depreciation Expense (84,114) (843) (25,000) (123,150) (233,106) (238,106)
IMRF Pension Expense (1,025) - (1,250) (12,250) (14,525) (14,775)
OPEB Expense - - (1,250) (14,000) (15,250) (15,500)
Total GAAP Adjustments 86,660$ (843)$ (27,500)$ (116,919)$ (58,602)$ (118,629)$
Fund Increase/(Decrease) - GAAP Basis 214,551$ 178,162$ (37,837)$ 665,303$ 1,020,179$ 528,374$
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
6/30/22 Actual $ 2,420,088 1,303,789$
6/30/21 Actual $ 1,916,275 1,257,830$
Change From Last Year 26.3%3.7%
Driving Program/
Memberships Greens Fees Range Fees Rentals User Fees
6/30/22 Actual $ 805,380 $ 457,154 $ 210,597 $ 437,460 50,302$
6/30/21 Actual $ 356,915 $ 527,141 $ 215,198 $ 325,538 -$
Change From Last Year 125.7%-13.3%N/A 34.4%0.0%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
6/30/22 Actual 622,128$ 156,055$ 321,326$ -$ 204,279$
6/30/21 Actual 573,794$ 281,245$ 253,039$ -$ 149,752$
Change From Last Year 8.4%-44.5%27.0%0.0%36.4%
Five Year Trend
Revenues by Department 6/30/21 6/30/22 6/30/22 6/30/22 2022 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Operations 7,442$ 482,853$ 260,725$ 185.2%521,450$ 444,499$
Open Field Operations 95,000 193,643 187,500 103.3%375,000 83,143
B&T Clubhouse Operations 33,658 99,546 175,638 56.7%351,275 65,888
Golf Club 1,780,175 1,644,046 1,586,150 103.7%3,172,300 (136,129)
Total Revenues 1,916,275$ 2,420,088$ 2,210,013$ 109.5%4,420,025$ 457,401$
Expenditures by Department 6/30/21 6/30/22 6/30/22 % of YTD 2022 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Operations 208,612$ 358,091$ 283,590$ 126.3%567,180$ 149,479$
Open Field Operations 5,161$ 14,638$ 125,330$ 11.7%250,660$ 9,477$
B&T Clubhouse Operations 85,415 97,531 149,100 65.4%298,200 12,116
Golf Club 958,642 833,528 1,341,878 62.1%2,683,755 (125,114)
Total Expenditures 1,257,830$ 1,303,789$ 1,899,898$ 68.6%3,799,795$ 45,959$
Five Year Trend
Village of Oak Brook
Sports Core Fund - Major Sources Five Year Trend
For the Period Ending June 30, 2022
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Bath & Tennis Club Recreation Operations
For the Period Ending June 30, 2022 6/30/22 6/30/22
822 6/30/22 YTD % of YTD 2022 6/30/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 -$ 375,380$ 25,575 - 400,955$ 224,475$ 178.6%448,950$ -$ 400,955$
Programs/User Fees - 33,476 16,826 - 50,302 7,750.00 649.1%15,500 - 50,302
Food Sales - - - 22,149 22,149 18,000.00 N/A 36,000 - -
Beverage Sales - - - 8,763 8,763 10,000.00 N/A 20,000 - -
Grants - - - - - - N/A - - -
Other Revenue 684 - - - 684 500 136.8%1,000 7,442 (6,758)
Total Operating Revenues 684$ 408,856$ 42,401$ 30,912$ 482,853$ 260,725$ 185.2%521,450$ 7,442$ 444,499$
OPERATING EXPENDITURES
Personnel 13,943$ 6,668$ -$ 13,953$ 34,563$ 63,675$ 54.3%127,350$ 6,867$ 27,696$
Materials & Supplies 325 3,890 1,656 15,466 21,338 37,275 57.2%74,550 28,301 (6,963)
Operational & Contractual 13,926 89,437 26,734 295 130,392 153,765 84.8%307,530 40,024 90,368
Other - - - N/A - -
Capital - 171,048 750 - 171,798 28,875 595.0%57,750 133,420 38,378
Total Operating Expenditures 28,194$ 271,043$ 29,140$ 29,714$ 358,091$ 283,590$ 126.3%567,180$ 208,612$ 149,479$
B&T Administration Overhead Allocation*24,703$ (8,893)$ (2,470)$ (988)$ 12,352$ -$ N/A 68,810$ 24,342$ (11,990)$
Operating Revenues Over (Under) Expenditures (2,807)$ 128,920$ 10,791$ 210$ 137,113$ (22,865)$ -599.7%23,080$ (176,828)$ 283,029$
Transfer From General Fund - - 210 - 210 - 0.0%- 210
Reimbursement From Infrastructure Fund - - - - - -$ 0.0%- 16,002 (16,002)
Reimbursement From Water Fund - - - - - - 0.0%- 4,002 (4,002)
Reimbursement To General Fund (9,432) - - - (9,432) (9,433) 100.0%(18,865) (7,860) (1,572)
Total Interfund Transactions (9,432)$ -$ 210$ -$ (9,222)$ (9,433)$ 97.8%(18,865)$ 12,144$ (21,366)$
Total Revenues Over (Under) Expenditures - Budgetary Basis (12,239)$ 128,920$ 11,001$ 210$ 127,891$ (32,298)$ 4,215$ (164,684)$ 261,663$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay -$ 171,048$ 750$ -$ 171,798$ 133,420$
Depreciation Expense (32,180) (50,000) (1,350) (584) (84,114) (84,114)
IMRF Pension Expense (1,000) - - (25) (1,025) (1,025)
Total GAAP Adjustments (33,180)$ 121,048$ (600)$ (609)$ 86,660$ 48,282$
Fund Increase/(Decrease) - GAAP Basis (45,419)$ 249,968$ 10,401$ (399)$ 214,551$ (116,403)$
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 June 30, 2022 6/30/22 6/30/22
6/30/22 YTD % of YTD 2022 6/30/21 Difference
815 816 YTD Amended Amended Adopted YTD Prior
Polo Open Fields Total Budget Budget Budget Total Year
OPERATING REVENUES
Field Rentals -$ 98,143$ 98,143$ 85,000$ 115.5%170,000$ 15,000$ 83,143$
Range Rentals - 80,000 80,000 42,500 N/A 85,000 80,000 -
Taste of Oak Brook - 15,500 15,500 60,000 N/A 120,000 - -
Other Revenue - - - N/A - - -
Total Operating Revenues -$ 193,643$ 193,643$ 187,500$ 103.3%375,000$ 95,000$ 83,143$
OPERATING EXPENDITURES
Personnel -$ -$ -$ -$ N/A -$ -$
Materials & Supplies - - - 750 0.0%1,500$ - -
Operational & Contractual 199 14,439 14,638 124,580 11.8%249,160 5,161 9,477
Capital - - - N/A - -
Total Operating Expenditures 199$ 14,439$ 14,638$ 125,330$ 11.7%250,660$ 5,161$ 9,477$
Operating Revenues Over (Under) Expenditures (199)$ 179,204$ 179,005$ 62,170$ 287.9%124,340$ 89,839$ 73,666$
INTERFUND TRANSACTIONS
Transfer From Hotel Tax Fund -$ -$ -$ -$ 0.0%-$ -$ -$
Total Interfund Transactions -$ -$ -$ -$ 0.0%-$ -$ -$
Total Revenues Over (Under) Expenditures - Budgetary Basis (199)$ 179,204$ 179,005$ 62,170$ 124,340$ 89,839$ 73,666$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay -$ -$ -$ -$
Depreciation Expense - (843) (843) (843)
Total GAAP Adjustments -$ (843)$ (843)$ (843)$
Fund Increase/(Decrease) - GAAP Basis (199)$ 178,361$ 178,162$ 88,997$
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 June 30, 2022
6/30/22 6/30/22
821 YTD % of YTD 2022 6/30/21 Difference
B&T Amended Amended Adopted YTD Prior
Clubhouse Budget Budget Budget Total Year
OPERATING REVENUES
Rentals 99,546$ 175,638$ 56.7%351,275$ 33,658$ 65,888$
Total Operating Revenues 99,546$ 175,638$ 56.7%351,275$ 33,658$ 65,888$
OPERATING EXPENDITURES
Personnel 63,263$ 70,125$ 90.2%140,250$ 52,515$ 10,748$
Materials & Supplies 427 7,675 5.6%15,350 2,890 (2,463)
Operational & Contractual 33,840 46,300 73.1%92,600 25,628 8,212
Capital - 25,000 0.0%50,000 4,382 (4,382)
Total Operating Expenditures 97,531$ 149,100$ 65.4%298,200$ 85,415$ 12,116$
B&T Administration Overhead Allocation*(12,352)$ -$ N/A (68,810)$ (24,342)$ 11,990$
Operating Revenues Over (Under) Expenditures (10,337)$ 26,538$ -39.0%(15,735)$ (76,099)$ 65,762$
INTERFUND TRANSACTIONS
Transfer From General Fund -$ -$ 0.0%-$ -$ -$
Total Interfund Transactions -$ -$ 0.0%-$ -$ -$
Total Revenues Over (Under) Expenditures - Budgetary Basis (10,337)$ 26,538$ (15,735)$ (76,099)$ 65,762$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay -$ 4,382$
Depreciation Expense (25,000) (30,000)
IMRF Pension Expense (1,250) (1,500)
OPEB Expense (1,250) (1,500)
Total GAAP Adjustments (27,500)$ (28,618)$
Fund Increase/(Decrease) - GAAP Basis (37,837)$ (104,717)$
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 June 30, 2022
6/30/22 6/30/22
823 831 832 833 834 6/30/22 YTD % of YTD 2022 6/30/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 -$ 404,425$ -$ -$ -$ 404,425$ 176,400$ 229.3%352,800$ 356,915$ 47,510$
Greens Fees - 457,154 - - - 457,154 572,500 79.9%1,145,000 527,141 (69,987)
Pro Shop Sales - 94,548 - - - 94,548 105,000 90.0%210,000 125,997 (31,449)
Golf Lessons - - 33,158 - - 33,158 25,000 132.6%50,000 46,525 (13,367)
Driving Range Fees - - 210,597 - - 210,597 150,000 140.4%300,000 215,198 (4,602)
Rentals - - - 159,771 - 159,771 193,750 82.5%387,500 196,880 (37,109)
Food Sales 101,790 - - - - 101,790 125,000 81.4%250,000 109,460 (7,670)
Beverage Sales 182,604 - - - - 182,604 235,000 77.7%470,000 197,121 (14,517)
Other Revenue - - - - - - 3,500 0.0%7,000 4,938 (4,938)
Total Operating Revenues 284,394$ 956,127$ 243,755$ 159,771$ -$ 1,644,046$ 1,586,150$ 103.7%3,172,300$ 1,780,175$ (136,129)$
OPERATING EXPENDITURES
Personnel 91,574$ 247,457$ 22,196$ 14,018$ 149,057$ 524,302$ 701,890$ 74.7%1,403,780$ 514,412$ 9,890$
Materials & Supplies 81,092 (12,794) 9,552 1,432 55,007 134,289 313,750 42.8%627,500 250,054 (115,765)
Operational & Contractual 2,008 94,437 606 19,115 26,289 142,456 146,738 97.1%293,475 182,226 (39,770)
Other - - - - - - 0.0%- - -
Capital - 32,481 - - - 32,481 179,500 0.0%359,000 11,950 20,531
Total Operating Expenditures 174,674$ 361,582$ 32,354$ 34,565$ 230,353$ 833,528$ 1,341,878$ 62.1%2,683,755$ 958,642$ (125,114)$
Operating Revenues Over (Under) Expenditures 109,720$ 594,545$ 211,400$ 125,206$ (230,353)$ 810,518$ 244,273$ 331.8%488,545$ 821,533$ (11,015)$
INTERFUND TRANSACTIONS
Transfer from Golf Surcharge -$ -$ -$ -$ -$ -$ 75,000$ 0.0%150,000$ -$ -$
Reimbursement to General Fund - (28,296) - - - (28,296) (28,295) 100.0%(56,590) (23,586) (4,710)
Total Interfund Transactions -$ (28,296)$ -$ -$ -$ (28,296)$ 46,705$ -60.6%93,410$ (23,586)$ (4,710)$
Total Revenues Over (Under) Expenditures - Budgetary Basis 109,720$ 566,249$ 211,400$ 125,206$ (230,353)$ 782,222$ 290,978$ 581,955$ 797,947$ (15,725)$
ADUSTMENTS TO GAAP BASIS*
Remove Capital Outlay -$ 32,481$ -$ -$ -$ 32,481$ 11,950$
Depreciation Expense (500) (52,500) (1,150) (6,500) (62,500) (123,150) (123,150)
IMRF Pension Expense (1,250) (5,000) (500) - (5,500) (12,250) (12,250)
OPEB Expense (1,500) (7,500) - - (5,000) (14,000) (14,000)
Total GAAP Adjustments (3,250)$ (32,519)$ (1,650)$ (6,500)$ (73,000)$ (116,919)$ (137,450)$
Fund Increase/(Decrease) - GAAP Basis 106,470$ 533,730$ 209,750$ 118,706$ (303,353)$ 665,303$ 660,497$
Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.
Cash and Investments by Fund:Total
Cash and Cash Pooled Cash and
Fund Equivalents Investments Investments % By Fund
General Corporate $18,483,833 $13,669,780 $32,153,613 56.2%
Hotel/Motel Tax 1,428,785 638,311 $2,067,096 3.6%
Motor Fuel Tax 1,381,960 14,586 $1,396,546 2.4%
Infrastructure 7,209,283 4,451,815 $11,661,098 20.4%
Promenade TIF 263,141 $263,141 0.5%
Water 2,959,522 3,353,663 $6,313,185 11.0%
Sports Core 1,546,336 $1,546,336 2.7%
Golf Surcharge 338,656 40,736 $379,392 0.7%
Self-Insurance 201,218 $201,218 0.4%
Garage 352,686 $352,686 0.6%
Equipment Replacement 515,837 312,290 $828,126 1.4%
Total $34,681,255 $22,481,182 $57,162,436 100.0%
Change in Cash and Investments by Fund :
Balance at Balance at Year-to-Date Year-to-Date
Fund January 1, 2022 June 30, 2022 Change ($)Change (%)
General Corporate $25,941,144 $32,153,613 $6,212,469 23.9%
Hotel/Motel Tax 1,754,745 2,067,096 312,351 17.8%
Motor Fuel Tax 1,153,550 1,396,546 242,996 21.1%
Infrastructure 10,880,028 11,661,098 781,070 7.2%
Promenade TIF 298,387 263,141 (35,246)-11.8%
Water 3,614,863 6,313,185 2,698,322 74.6%
Sports Core 576,566 1,546,336 969,770 168.2%
Golf Surcharge 278,773 379,392 100,619 36.1%
Self-Insurance 87,655 201,218 113,563 129.6%
Garage 325,902 352,686 26,784 8.2%
Equipment Replacement 759,255 828,126 68,871 9.1%
45,670,868 $57,162,436 $11,491,568 25.2%
Book Bank/Market
Value Value
Cash and Cash Equivalents:
Pooled Checking $3,577,772 $4,021,567
Sports Core Checking 3,069,489 2,969,843
Pooled IPTIP 27,305,653 27,305,653
Water E-Pay IPTIP 768,112 753,784
34,721,026 $35,050,848
Pooled Investments:
Investments-Municipal Bonds $7,763,182 $7,018,573
Investments-Corporate Bonds 8,455,113 8,132,023
Government & Agency Obligations 4,900,287 4,725,888
Certificates of Deposit 1,225,000 1,156,753
Accrued Interest 119,403 119,405
Total Pooled Investments $22,462,985 $21,152,641
Total Cash and Investments $57,184,011 $56,203,489
Monthly Treasurer's Report
June 30, 2022
Monthly Treasurer's Report
June 30, 2022
The table below lists the detail investment holdings at J.P. Morgan Securities as of 06/30/22:
Month End VOB
Settlement Maturity Coupon Yield Book Market Accrued
Type Date Date Rate Rate Value Value Interest
Municipal Bonds:
Laredo TX Waterworks #517039VW0 12/19/19 03/01/24 2.230%2.230%455,000 447,306 2,818
Oakland Univ Mich #673588HJ1 04/29/20 03/01/24 5.000%1.650%311,196 308,446 2,458
Philadelphia PA GO Ref #717813SW0 05/05/20 08/01/22 5.000%1.820%391,069 391,053 4,672
University of CA #91412HFK4 07/16/20 05/15/23 0.628%0.628%25,000 24,479
Cook, Kane, Lake, & McHenry #216181GL5 10/29/2020 12/15/2022 4.000%0.300%1,042,455 1,036,952 3,472
Miami-Dade Cnty #59333NN90 11/16/2020 12/15/2022 0.375%0.430%734,044 719,881 681
Hamilton NY #407741MC8 1/21/2021 5/1/2023 1.000%0.550%205,770 201,150 342
Southern Cal Pub Pwr #84247PHZ7 1/25/2021 4/1/2024 3.608%0.500%1,061,743 1,004,070 17,840
Hillsborough Cnty FL #43232VV3 3/11/2021 7/1/2024 1.815%0.770%510,356 484,465 4,462
Port Auth of NY and NJ #73358WAH7 4/15/2021 12/1/2024 5.859%0.600%563,032 52,700 2,279
City of Atlanta GA Water #047870SG6 4/19/2021 11/1/2024 0.616%0.500%250,670 234,548 248
West Contra Costa Cal Uni #9523474U3 6/17/2021 8/1/2024 0.575%0.575%500,000 471,610 1,190
New York NY City #64971XA40 10/7/2021 11/1/2024 0.450%0.620%711,311 667,424 527
NY Urban Dev Corp #650036AR7 11/5/2021 3/15/2023 0.720%0.451%500,950 491,875 1,050
Colorado Brdg Enterprise #19633SAZ6 11/24/2021 12/31/2023 0.923%0.844%500,585 482,615 218
Total Municipal Bonds $7,763,182 $7,018,573 $42,257
Corporate Bonds:
PNC Bank #69349LAK4 12/7/2020 1/30/2023 2.950%0.457%1,034,782 1,018,159 12,537
Wells Fargo #94974BFJ4 12/7/2020 2/13/2023 3.450%0.480%1,415,473 1,391,300 18,250
Comerica Bank #200340AS6 12/23/2020 7/31/2023 3.700%0.500%517,263 499,669 7,708
Bank of America #06048WM23 5/14/2021 5/14/2024 0.650%0.650%915,000 853,518 743
Goldman Sachs #38141GXE9 7/27/2021 2/20/2024 3.625%0.693%628,536 598,059 7,854
Goldman Sachs #38150AGU3 7/28/2021 7/28/2023 0.550%0.550%655,000 636,475 1,531
Morgan Stanley #61746BDQ6 7/28/2021 4/29/2024 3.875%0.547%1,060,313 1,001,274 6,674
Citigroup #17329UEH0 11/18/2021 11/18/2024 1.000%1.149%1,000,000 930,948 1,167
Bank New York Mellon #06406RAG2 1/25/2022 4/28/2023 3.500%0.810%715,405 702,952 4,219
Comerica Bank #200340AS6 1/25/2022 7/31/2023 3.700%1.200%513,341 499,669 7,708
Total Corporate Bonds $8,455,113 $8,132,023 $68,392
Government & Agency Obligations:
Government National Mtg Assn #38381WV96 08/06/19 07/20/54 2.250%2.293%100,911 89,685 10
Government National Mtg Assn #38380BNV3 12/05/19 06/20/46 2.000%2.112%285,956 289,922 351
Federal Home Loan Bank #3130AMVU3 06/29/21 06/29/26 0.500%0.500%500,000 466,188 747
Government National Mtg Assn #38383DWC8 12/14/2021 11/20/2056 1.250%1.379%874,230 749,755 977
Federal Home Loan Bank #313381BR5 2/25/2022 12/9/2022 1.875%0.900%858,668 853,416 891
Unites States Treasury #912796X61 6/8/2022 12/8/2022 2,280,523 2,276,921 3,603
Total Government & Agency Obligations:$4,900,287 $4,725,888 $6,578
Certificates of Deposit:
Goldman Sachs 38149MXG3 07/28/21 07/29/24 0.550%0.550%245,000 231,521 573
Sallie Mae #795451AD5 07/28/21 07/29/24 0.600%0.600%245,000 231,765 625
Texas Exchange Bk #88241TLS7 07/30/21 07/30/24 0.500%0.500%245,000 231,137 410
Toyota Financial #89235MLF6 08/05/21 8/5/2024 0.550%0.550%245,000 231,391 543
UBS Bank #90348JT42 09/22/21 9/23/2024 0.650%0.650%245,000 230,938 26
Total Certificates of Deposits $1,225,000 $1,156,753 $2,176
Total J.P.Morgan Securities $22,343,582 $21,033,236 $119,403
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
June 30, 2022
Cash & Investments by Fund - Total $57 million
Cash & Investments by Type - Total $57 million
General Corporate
56.2%
Hotel/Motel Tax
3.6%Motor Fuel Tax
2.4%
Infrastructure
20.4%
Promenade TIF
0.5%
Water
11.0%
Sports Core
2.7%
Golf Surcharge
0.7%
Self-Insurance
0.4%
Garage
0.6%Equipment Replacement
1.4%
Checking, $6.6
Illinois Funds, $28.0
Certificates of Deposit,
1.2
Municipal Bonds, $7.7
Corporate Bonds, $8.5
Government & Agency
Obligations, $4.9
Accrued Interest, $0.1
in millions