08 - August 2022 Monthly Financial ReportVILLAGE
OAK BROOKOF
MONTHLY FINANCIAL REPORTS
AUGUST 2022
Village of Oak Brook
Monthly Financial Report – Fund Narrative
For the Period Ending August 31, 2022
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 fund 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 Financial Report (annual audit).
The proceeding pages contain detailed information on the Village’s major funds. Highlights for
each of the Village’s funds are:
General Fund
Total revenues through August 2022 are $4,697,262, or 27.9%, higher than last August,
and $5,176,330, or 31.59%, over budget to date. The main drivers for this are:
o Sales tax revenue, the General Fund’s
largest revenue source, is up
$3,230,395 from last year and
$3,244,173 over budget. August 2022
collections came in at the highest
level in the past five years.
o Other Intergovernmental Tax is up
$629,435 from last year and $908,296
over budget. Receipts from Income
Tax and Replacement Tax came in higher than anticipated in August.
o The Telecommunication/Utility Tax is up $ 64,364 from last year and $71,219 over
budget.
Total expenditures through August 2022 are $692,871, or 4.9%, higher than last year and
$1,916,393 or 11.48%, under budget to date.
Hotel Tax Fund
Total revenues through August 2022 are $324,894, or 73.3%, higher than last year and
$234,477, or 43.94%, over budget to date. The main drivers for this are:
o Hotel tax revenue is up $340,628 from last year and $240,224 over budget.
Hotel stay continues to recover from the effects of COVID‐19 on the travel
industry.
Total expenditures through August 2022 are $306,364 higher than last year and
$193,618 over budget.
o Operation and Contract expenditures are up $256,319, or 328.3%, from last year
and $140,922 over budget.
Infrastructure Fund
Total revenues through August 2022 are up $576,117, or 13.2%, from last year and
$332,012 or 15.7%, over budget. The main drivers for this are:
o Non‐home rule sales tax revenue is up $1,100,903 from last year, and $1,031,672
over budget. August 2022 collections came in at the highest level in the past five
years.
Total expenditures through August 2022 are
down $501,324 or 7.1%, from last year and
$1,778,647 or 21.4%, under budget to date.
The main drivers for this are:
o Operation and contract expenditures
are down $328,721 from last year
and $402,127 under budget.
o Capital Outlay is down $109,402 from last year and $1,373,796 under budget.
Promenade TIF Fund
Total revenues through August 2022 are down $253,167 or 54.8%, from last year and
$121,573 under budget. Revenues are under budget due to the timing of information to
record the TIF sale tax transfer.
Total expenditures through August 2022 are up $1,122 from last year and $159,490 over
budget. The increase relates to timing in payment of notes payable compared to last year.
Water Fund
Total revenues through August 2022 are up $500,080, or 7.10% higher than last year and
$434,275, or 6.08%, over budget.
Total expenditures through August 2022 are down $5,016,029, or 63.6%, from last year
and $3,824,039 or 57.12%, under budget. The main drivers for this are:
o Personnel expenditures are down $253,335 from last year and $146,275 under
budget.
o Capital outlay expenditures are down $4,346,626 from last year.
Sports Core Fund
Total revenues through August 2022 are up $695,182 or 23.2% higher than last year and
$743,226, over budget to date. The main drivers for this are:
o Membership revenue is up $453,263 from last year and $274,563 over budget.
o Rentals are up by $164,831 from last year and $53,180 under budget.
Total expenditures through August 2022 are up $2,287, or 0.1%, from last year, and
$27,876, or 0.73% under budget to date. The main drivers for this are:
o Personnel expenditure are down $44,200 from last year and $163,817 under
budget.
o Operation and contract expenditures are higher $279,779 from last year and
$29,224 over budget.
o Capital outlay expenditures are down $300,681 from last year, and $29,064 over
budget.
YTD YTD
Net Fund Budgeted
YTD YTD Increase Increase
Governmental Funds Revenues Expenditures (Decrease)(Decrease)
General Fund (Major Fund)21,938,533$ 14,848,026$ 7,090,507$ (2,216)$
Main operating fund of the Village.
Hotel Fund (Major Fund)768,144$ 442,141$ 326,003$ 156,227$
Collects and spends resources from the
3% hotel/motel tax.
Motor Fuel Tax Fund 301,758$ -$ 301,758$ 157,960$
Collects and spends resources from the
State motor fuel tax.
Infrastructure Fund (Major Fund)5,169,749$ 6,617,395$ (1,447,646)$ (3,276,063)$
Accounts for construction and maintenance of
roadways, drainage, and safety path systems.
Promenade TIF Fund (Major Fund)208,460$ 486,260$ (277,800)$ 3,263$
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)#REF!3,151,552$ #REF!168,077$
Collects user fees for the distribution of water
and maintenance of infrastructure.
Sports Core Fund (Major Fund)3,689,909$ 2,555,624$ 1,134,285$ 463,183$
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 2,071,310$ 2,006,881$ 64,429$ 66,675$
Accounts for the Village's health insurance costs
and the related contributions from the Village,
employees, retirees, and other agencies.
Garage Fund 415,833$ 423,740$ (7,906)$ (17,760)$
Accounts for the maintenance of the Village's vehicle
fleet and the related departmental reimbursements.
Equipment Replacement Fund 584,501$ 532,618$ 51,883$ (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 August 31, 2022
8/31/22 8/31/22
8/31/21 8/31/22 YTD % of YTD 2022 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 8,813,778$ 12,044,173 8,800,000$ 136.9%13,200,000$ 3,230,395$
Other Intergovernmental Tax*1,357,794 1,987,229 1,078,933 184.2%1,618,400 629,435
Telecommunications/Utility Tax 3,736,855 3,801,219 3,730,000 101.9%5,595,000 64,364
Grants 39,301 10,466 10,000 104.7%15,000 (28,835)
Licenses and Permits 1,365,194 1,555,582 1,338,340 116.2%2,007,510 190,388
Charges for Services 933,820 1,534,056 769,933 199.2%1,154,900 600,236
Fines and Penalties 103,257 64,204 94,667 67.8%142,000 (39,053)
Administrative Towing Fees 20,018 33,850 16,667 203.1%25,000 13,832
Investment Interest 126,276 134,347 96,000 139.9%144,000 8,071
Franchise Fees 106,146 166,134 132,000 125.9%198,000 59,988
Installment Contract Proceeds - N/A -
Miscellaneous Income 262,016 230,457 318,847 72.3%478,270 (31,559)
Total Operating Revenues 16,864,455$ 21,561,717$ 16,385,387$ 131.6%24,578,080$ 4,697,262$
OPERATING EXPENDITURES
Personnel 11,536,170$ 11,648,738$ 12,978,832$ 89.8%19,468,249$ 112,568$
Materials and Supplies 259,608 294,913 381,697 77.3%572,545 35,305$
Operation and Contract 2,137,128 2,660,736 2,389,813 111.3%3,584,720 523,608$
Other Expenditures 4,315 77,546 79,253 97.8%118,880 73,231$
Capital Outlay 144,678 92,837 861,567 10.8%1,292,350 (51,841)$
Total Operating Expenditures 14,081,899$ 14,774,770$ 16,691,162$ 88.5%25,036,744$ 692,871$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 2,782,556$ 6,786,947$ (305,776)$ -2219.6%(458,664)$ 4,004,391$
INTERFUND TRANSACTIONS
Transfers In -$ -$ -$ N/A -$ -$
Transfers Out - N/A -
Reimbursements From Other Funds 395,784 376,816 376,813 100.0%565,220 (18,968)
Reimbursements To Other Funds (70,592) (73,256) (73,253) 100.0%(109,880) (2,664)
Sports Core Loan - N/A - -
Total Interfund Transactions 325,192$ 303,560$ 303,560$ 100.0%455,340$ (21,632)$
NET FUND INCREASE (DECREASE)3,107,748$ 7,090,507$ (2,216)$ (3,324)$ 3,982,759$
*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 August 31, 2022
Total Total
Revenues Expenditures
8/31/22 Actual 21,561,717$ 14,774,770$
8/31/21 Actual 16,864,455$ 14,081,899$
% Change From Last Year 27.9%4.9%
Major Revenues
Other Telecom/Utility Licenses &Charges for
Sales Tax Intergov. Tax Tax Permits Services
8/31/22 Actual 12,044,173$ 1,987,229$ 3,801,219$ 1,555,582$ 1,534,056$
8/31/21 Actual $ 8,813,778 $ 1,357,794 $ 3,736,855 $ 1,365,194 $ 933,820
% Change From Last Year 36.7%46.4%1.7%13.9%64.3%
Five Year Trend
Major Expenditures Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
8/31/22 Actual 11,648,738$ 294,913$ 2,660,736$ 77,546$ 92,837$
8/31/21 Actual 11,536,170$ 259,608$ 2,137,128$ 4,315$ 144,678$
% Change From Last Year 1.0%13.6%24.5%1697.1%-35.8%
Five Year Trend
Expenditures by Department
8/31/21 8/31/22 8/31/22 8/31/22 2022 Difference Five
YTD YTD YTD % of Annual Prior Year
Department Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 1,292,891$ 555,048$ 784,905$ 70.7%3,002,480$ (737,843)$
Financial Services 443,636 207,071 194,640 106.4%827,030 (236,565)
Public Works 575,281 157,826 183,560 86.0%928,765 (417,455)
Engineering & Capital Projects 24,639 11,172 139,000 8.0%384,000 (13,467)
Library 506,436 233,222 239,800 97.3%996,145 (273,214)
Police 4,964,687 2,185,963 2,336,800 93.5%9,869,105 (2,778,724)
Fire 4,061,441 1,611,145 1,872,020 86.1%7,922,040 (2,450,296)
Development Services 561,678 222,207 250,015 88.9%1,094,285 (339,471)
Total Expenditures 12,430,689$ 5,183,655$ 6,000,740$ 86.4%25,023,850$ (7,247,034)$
Five Year Trend
For the Period Ending August 31, 2022
General Fund - Five Year Trend
Village of Oak Brook
Revenues Expenditures
8/31/22 8/31/22
8/31/21 8/31/22 YTD % of YTD 2022 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Hotel Tax 415,262$ 755,890$ 515,667$ 146.6%773,500$ 340,628$
Investment Interest 23,988 12,253 14,000 87.5%21,000 (11,735)
Loan Interest 4,000 - 4,000 0.0%6,000 (4,000)
Total Operating Revenues 443,250$ 768,144$ 533,667$ 143.9%800,500$ 324,894$
EXPENDITURES
Operation and Contract 77,927$ 334,246$ 193,323$ 172.9%289,985$ 256,319$
Capital Outlay 2,650 52,695 - N/A - 50,045
Total Expenditures 80,577$ 386,941$ 193,323$ 200.2%289,985$ 306,364$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 362,673$ 381,203$ 340,343$ 112.0%510,515$ 18,530$
INTERFUND TRANSACTIONS
Transfer Out (2,383,612)$ -$ (128,917)$ 0.0%(193,375)$ 2,383,612$
Reimbursements to Other Funds (56,056) (55,200) (55,200) 100.0%(82,800) 856
Total Interfund Transactions (2,439,668)$ (55,200)$ (184,117)$ 30.0%(276,175)$ 2,384,468$
NET FUND INCREASE (DECREASE)(2,076,995)$ 326,003$ 156,227$ 234,340$ 2,402,998$
Note - Expenditures are recorded in program 171.
Village of Oak Brook
Hotel Tax Fund Financial Update
For the Period Ending August 31, 2022
Total Total
Revenues Expenditures
8/31/22 Actual $ 768,144 386,941$
8/31/21 Actual $ 443,250 80,577$
% Change From Last Year 73.3%380.2%
Major Revenues Investment
Hotel Tax Interest Loan Interest Miscellaneous
8/31/22 Actual $ 755,890 $ 12,253 4,000$ -$
8/31/21 Actual $ 415,262 $ 23,988 -$ -$
% Change From Last Year 82.0%-48.9%0.0%0.0%
Five Year Trend
Major Expenditures Operation &
Contractual Capital Outlay
8/31/22 Actual 334,246$ 52,695$
8/31/21 Actual 77,927$ 2,650$
% Change From Last Year 328.9%N/A
Five Year Trend
Village of Oak Brook
Hotel Tax Fund - Major Sources Five Year Trend
For the Period Ending August 31, 2022
Five Year Trend
Revenues Expenditures
8/31/22 8/31/22
8/31/21 8/31/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 3,807,435$ 4,908,338$ 3,876,667$ 126.6%5,815,000$ 1,100,903$
Charges for Services - - N/A -$
Investment Interest 22,669 45,827 18,333 250.0%27,500 23,158
Grants 544,864 - 726,487 0.0%1,089,730 (544,864)
Miscellaneous 3,080 - 667 0.0%1,000 (3,080)
Total Operating Revenues 4,378,048$ 4,954,165$ 4,622,153$ 107.2%6,933,230$ 576,117$
OPERATING EXPENDITURES
Personnel 933,278$ 876,813$ 861,890$ 101.7%1,292,835$ (56,465)$
Materials and Supplies 140,155 133,419 151,067 88.3%226,600 (6,736)
Operation and Contract 1,080,048 751,327 1,153,453 65.1%1,730,180 (328,721)
Other Expenditures - N/A -
Capital Outlay 4,886,486 4,777,084 6,150,880 77.7%9,226,320 (109,402)
Total Operating Expenditures 7,039,967$ 6,538,643$ 8,317,290$ 78.6%12,475,935$ (501,324)$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES (2,661,919)$ (1,584,478)$ (3,695,137)$ 42.9%(5,542,705)$ 1,077,441$
INTERFUND TRANSACTIONS
Transfers In 2,383,612$ -$ 282,250$ 0.0%423,375$ (2,383,612)$
Reimbursements From Other Funds 221,232 215,584 215,577 100.0%323,365 (5,648)
Reimbursements To Other Funds (117,536) (78,752) (78,753) 100.0%(118,130) 38,784
Total Interfund Transactions 2,487,308$ 136,832$ 419,073$ 32.7%628,610$ (2,350,476)$
NET FUND INCREASE (DECREASE)(174,611)$ (1,447,646)$ (3,276,063)$ (4,914,095)$ (1,273,035)$
Village of Oak Brook
Infrastructure Fund Financial Update
For the Period Ending August 31, 2022
Total Total
Revenues Expenditures
8/31/22 Actual $ 4,954,165 6,538,643$
8/31/21 Actual $ 4,378,048 7,039,967$
% Change From Last Year 13.2%-7.1%
Major Revenues
Sales Tax
Charges for
Services
Investment
Interest Miscellaneous
8/31/22 Actual $ 4,908,338 $ - $ 45,827 $ -
8/31/21 Actual $ 3,807,435 $ - $ 22,669 $ -
% Change From Last Year 28.9%0.0%102.2%0.0%
Five Year Trend
Major Expenditures Materials &Operation &
Personnel Supplies Contractual Capital Outlay
8/31/22 Actual 876,813$ 133,419$ 751,327$ 4,777,084$
8/31/21 Actual 933,278$ 140,155$ 1,080,048$ 4,886,486$
% Change From Last Year -6.1%-4.8%-30.4%-2.2%
Five Year Trend
Expenditures by Department
8/31/21 8/31/22 8/31/22 8/31/22 2022 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 85,246$ 28,892$ 52,010$ 55.5%209,510$ (56,355)$
Public Works 651,848 589,033 584,365 100.8%2,380,195 (926,197)
Engineering & Capital Projects 768,463 98,940 706,825 14.0%9,886,230 (3,396,070)
Total Expenditures 1,505,557$ 716,864$ 1,343,200$ 53.4%12,475,935$ (4,378,622)$
Five Year Trend
Village of Oak Brook
Infrastructure Fund - Major Sources Five Year Trend
For the Period Ending August 31, 2022
Revenues Expenditures
8/31/22 8/31/22
8/31/21 8/31/22 YTD % of YTD 2022 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 53,139$ -$ 60,000$ 0.0%90,000$ (53,139)$
Real Estate Tax 408,456 207,787 270,000 77.0%405,000 (200,669)
Investment Interest 32 674 33 2021.2%50 642
Total Operating Revenues 461,627$ 208,460$ 330,033$ 63.2%495,050$ (253,167)$
EXPENDITURES
Operation and Contract 3,638$ -$ 2,600$ 0.0%3,900$ (3,638)$
Other Expenditures 481,500 486,260 324,170 150.0%486,255 4,760
Total Expenditures 485,138$ 486,260$ 326,770$ 148.8%490,155$ 1,122$
NET FUND INCREASE (DECREASE)(23,511)$ (277,800)$ 3,263$ 4,895$ (254,289)$
Note - Expenditures are recorded in program 283.
Village of Oak Brook
Promenade TIF Fund Financial Update
For the Period Ending August 31, 2022
Total Total
Revenues Expenditures
8/31/22 Actual $ 208,460 486,260$
8/31/21 Actual $ 461,627 485,138$
% Change From Last Year -54.8%0.2%
Major Revenues Real Estate Investment
Sales Tax Tax Interest
8/31/22 Actual -$ $ 207,787 $ 674
8/31/21 Actual 53,139$ $ 408,456 $ 32
% Change From Last Year -100.0%0.0%2005.4%
Five Year Trend
Major Expenditures Operation &Other
Contractual Expenditures
8/31/22 Actual -$ 486,260$
8/31/21 Actual 3,638$ 481,500$
% Change From Last Year 0.0%1.0%
Five Year Trend
Village of Oak Brook
Promenade TIF Fund - Major Sources Five Year Trend
For the Period Ending August 31, 2022
Five Year Trend
Revenues Expenditures
8/31/22 8/31/22
8/31/21 8/31/22 YTD % of YTD 2022 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Plan Review Fees 525$ 450$ 667$ 67.5%1,000$ (75)$
Building/Inspection Fees 2,850 1,500 3,333 45.0%5,000 (1,350)
Water Sales 6,144,975 6,793,467 6,989,667 97.2%10,484,500 648,492
Unmetered Sales 33,453 70,480 33,333 211.4%50,000 37,027
Water Connection Fees 185,610 568,330 50,000 1136.7%75,000 382,720
Fire Service Charge - N/A -
Meter Charges 6,786 19,149 10,000 191.5%15,000 12,363
Special Services 13,333 13,389 16,667 80.3%25,000 56
Investment Interest 33,990 29,538 20,000 147.7%30,000 (4,452)
Miscellaneous 656,340 81,639 20,000 408.2%30,000 (574,701)
Total Operating Revenues 7,077,862$ 7,577,942$ 7,143,667$ 106.1%10,715,500$ 500,080$
OPERATING EXPENDITURES
Personnel 538,807$ 285,472$ 431,747$ 66.1%647,620$ (253,335)$
Materials and Supplies 104,227 49,338 46,433 106.3%69,650 (54,889)
Operation and Contract 2,866,199 2,505,021 3,600,417 69.6%5,400,625 (361,178)
Capital Outlay 4,378,020 31,394 2,616,667 1.2%3,925,000 (4,346,626)
Total Expenditures 7,887,253$ 2,871,224$ 6,695,263$ 42.9%10,042,895$ (5,016,029)$
Surplus (Deficit) of Revenues Over
Expenditures 5,515$ 4,706,718$ 448,403$ 1049.7%672,605$ 5,516,109$
INTERFUND TRANSACTIONS
Reimbursements To Other Funds (262,794)$ (280,328)$ (280,327)$ 100.0%(420,490)$ (17,534)$
Total Interfund Transactions (262,794)$ (280,328)$ (280,327)$ 100.0%(420,490)$ (17,534)$
Fund Increase/(Decrease) - Budgetary Basis (257,279)$ 4,426,390$ 168,077$ 252,115$ 5,498,575$
ADUSTMENTS TO GAAP BASIS*
Remove Capital Outlay 4,378,020$ 31,394$
Depreciation Expense (383,333) (383,333)
IMRF Pension Expense (30,000) (30,000)
OPEB Expense (20,000) (20,000)
Total GAAP Adjustments 3,944,687$ (401,939)$
Fund Increase/(Decrease) - GAAP Basis 3,687,408$ 4,024,451$
*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 August 31, 2022
Total Total
Revenues Expenditures
8/31/22 Actual $ 7,577,942 2,871,224$
8/31/21 Actual $ 7,077,862 7,887,253$
% Change From Last Year 7.1%-63.6%
Unmetered Water
Water Sales Sales Connection Fees Meter Charges Miscellaneous
8/31/22 Actual $ 6,793,467 $ 70,480 $ 568,330 $ 19,149 $ 81,639
8/31/21 Actual $ 6,144,975 $ 33,453 $ 185,610 $ 6,786 $ 656,340
% Change From Last Year 10.6%110.7%206.2%182.2%-87.6%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
8/31/22 Actual 285,472$ 49,338$ 2,505,021$ -$ 31,394$
8/31/21 Actual 538,807$ 104,227$ 2,866,199$ -$ 4,378,020$
% Change From Last Year -47.0%-52.7%-12.6%0.0%-99.3%
Five Year Trend
Expenditures by Department
8/31/21 8/31/22 8/31/22 8/31/22 2022 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Public Works 3,699,505$ 813,074$ 1,140,710$ 324.3%6,067,895$ 2,886,431$
Engineering & Capital Projects 5,662,500 23,265 - 0.0%3,975,000 5,639,236
Total Expenditures 9,362,005$ 836,338$ 1,140,710$ 73.3%10,042,895$ 8,525,667$
Five Year Trend
Village of Oak Brook
Water Fund - Major Sources Five Year Trend
For the Period Ending August 31, 2022
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Sports Core Fund Consolidated Presentation
For the Period Ending August 31, 2022
8/31/22 8/31/22
8/31/22 YTD % of YTD 2022 8/31/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 402,838$ -$ -$ 406,225$ 809,063$ 534,500$ 151.4%801,750$ 355,800$ 453,263$
Greens Fees - - - 898,170 898,170 763,333 117.7%1,145,000 973,849 (75,679)
Pro Shop Sales - - - 160,474 160,474 140,000 114.6%210,000 181,752 (21,278)
Golf Lessons - - - 39,448 39,448 33,333 118.3%50,000 45,105 (5,657)
Driving Range Fees - - - 303,523 303,523 200,000 151.8%300,000 296,119 7,404
Rentals - 193,393 202,286 320,019 715,697 662,517 108.0%993,775 550,866 164,831
Programs/User Fees 74,031 - - - 74,031 10,333 716.4%15,500 - 74,031
Food Sales 43,314 - - 201,510 244,824 190,667 128.4%286,000 203,018 41,806
Beverage Sales 17,140 - - 358,944 376,084 326,667 115.1%490,000 372,791 3,293
Taste of Oak Brook - 66,812 - - 66,812 80,000 83.5%120,000 - 66,812
Grants - - - - - - N/A - - -
Other Revenue 1,784 - - - 1,784 5,333 33.4%8,000 15,427 (13,643)
Total Operating Revenues 539,107$ 260,205$ 202,286$ 2,688,312$ 3,689,909$ 2,946,683$ 125.2%4,420,025$ 2,994,727$ 695,182$
OPERATING EXPENDITURES
Personnel 60,948$ -$ 84,793$ 804,696$ 950,436$ 1,114,253$ 85.3%1,671,380$ 994,636$ (44,200)$
Materials & Supplies 58,139 - 5,454 493,326 556,919 479,267 116.2%718,900 489,531 67,388
Operational & Contractual 273,678 67,946 57,924 258,187 657,734 628,510 104.6%942,765 377,955 279,779
Other - - - - - - N/A - - -
Capital 232,016 - - 108,214 340,230 311,167 109.3%466,750 640,911 (300,681)
Total Operating Expenditures 624,781$ 67,946$ 148,171$ 1,664,423$ 2,505,320$ 2,533,197$ 98.9%3,799,795$ 2,503,033$ 2,287$
B&T Administration Overhead Allocation*12,352$ -$ (12,352)$ -$ (0)$ -$ N/A -$ -$ (0)$
Operating Revenues Over (Under) Expenditures (73,322)$ 192,259$ 41,763$ 1,023,889$ 1,184,589$ 413,487$ 286.5%620,230$ 491,694$ 692,895$
INTERFUND TRANSACTIONS
Interfund Loan**-$ -$ -$ -$ -$ -$ N/A -$ -$ -$
Transfer From General Fund - - - - - - N/A - - -
Transfer From Golf Surcharge Fund - - - - - 100,000 0.0%150,000 - -
Reimbursement From Infrastructure Fund - - - - - - N/A - 21,336 (21,336)
Reimbursement From Water Fund - - - - - - N/A - 5,336 (5,336)
Reimbursement To General Fund (12,576) - - (37,728) (50,304) (50,303) 100.0%(75,455) (41,928) (8,376)
Total Interfund Transactions (12,576)$ -$ -$ (37,728)$ (50,304)$ 49,697$ -101.2%74,545$ (15,256)$ (35,048)$
Total Revenues Over (Under) Expenditures - Budgetary Basis (85,898)$ 192,259$ 41,763$ 986,161$ 1,134,285$ 463,183$ 694,775$ 476,438$ 657,847$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay 232,016$ -$ -$ 108,214$ 340,230$ 640,911$
Depreciation Expense (112,151) (1,123) (25,000) (164,200) (302,475) (317,475)
IMRF Pension Expense (1,367) - (1,250) (16,333) (18,950) (19,700)
OPEB Expense - - (1,250) (18,667) (19,917) (20,667)
Total GAAP Adjustments 118,498$ (1,123)$ (27,500)$ (90,986)$ (1,111)$ 283,070$
Fund Increase/(Decrease) - GAAP Basis 32,600$ 191,136$ 14,263$ 895,175$ 1,133,174$ 759,508$
*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
8/31/22 Actual $ 3,689,909 2,505,320$
8/31/21 Actual $ 2,994,727 2,503,033$
% Change From Last Year 23.2%0.1%
Driving Program/
Memberships Greens Fees Range Fees Rentals User Fees
8/31/22 Actual $ 809,063 $ 898,170 $ 303,523 $ 715,697 74,031$
8/31/21 Actual $ 355,800 $ 973,849 $ 296,119 $ 550,866 -$
% Change From Last Year 127.4%-7.8%N/A 29.9%0.0%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
8/31/22 Actual 950,436$ 556,919$ 657,734$ -$ 340,230$
8/31/21 Actual 994,636$ 489,531$ 377,955$ -$ 640,911$
% Change From Last Year -4.4%13.8%74.0%0.0%-46.9%
Five Year Trend
Revenues by Department 8/31/21 8/31/22 8/31/22 8/31/22 2022 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Operations 8,188$ 539,107$ 347,633$ 155.1%521,450$ 470,465$
Open Field Operations 100,000 260,205 250,000 104.1%375,000 93,393
B&T Clubhouse Operations 81,543 202,286 234,183 86.4%351,275 120,743
Golf Club 2,804,996 2,688,312 2,114,867 127.1%3,172,300 (116,684)
Total Revenues 2,994,727$ 3,689,909$ 2,946,683$ 125.2%4,420,025$ 567,916$
Expenditures by Department 8/31/21 8/31/22 8/31/22 % of YTD 2022 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Operations 396,665$ 624,781$ 378,120$ 165.2%567,180$ 228,116$
Open Field Operations 239,946$ 67,946$ 167,107$ 40.7%250,660$ (172,000)$
B&T Clubhouse Operations 120,030 148,171 198,800 74.5%298,200 28,141
Golf Club 1,746,392 1,664,423 1,789,170 93.0%2,683,755 (81,969)
Total Expenditures 2,503,033$ 2,505,320$ 2,533,197$ 98.9%3,799,795$ 2,287$
Five Year Trend
Village of Oak Brook
Sports Core Fund - Major Sources Five Year Trend
For the Period Ending August 31, 2022
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Bath & Tennis Club Recreation Operations
For the Period Ending August 31, 2022 8/31/22 8/31/22
822 8/31/22 YTD % of YTD 2022 8/31/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 -$ 377,263$ 25,575 - 402,838$ 299,300$ 134.6%448,950$ -$ 402,838$
Programs/User Fees - 39,908 34,123 - 74,031 10,333.33 716.4%15,500 - 74,031
Food Sales - - - 43,314 43,314 24,000.00 180.5%36,000 - -
Beverage Sales - - - 17,140 17,140 13,333.33 128.6%20,000 - -
Grants - - - - - - N/A - - -
Other Revenue 1,784 - - - 1,784 667 267.5%1,000 8,188 (6,404)
Total Operating Revenues 1,784$ 417,171$ 59,698$ 60,454$ 539,107$ 347,633$ 155.1%521,450$ 8,188$ 470,465$
OPERATING EXPENDITURES
Personnel 15,805$ 12,211$ -$ 32,932$ 60,948$ 84,900$ 71.8%127,350$ 15,929$ 45,019$
Materials & Supplies 432 19,757 6,574 31,375 58,139 49,700 117.0%74,550 27,425 30,714
Operational & Contractual 20,025 199,265 48,352 6,036 273,678 205,020 133.5%307,530 84,245 189,433
Other - - - - N/A - -
Capital - 231,266 750 - 232,016 38,500 602.6%57,750 269,066 (37,050)
Total Operating Expenditures 36,263$ 462,499$ 55,676$ 70,343$ 624,781$ 378,120$ 165.2%567,180$ 396,665$ 228,116$
B&T Administration Overhead Allocation*24,703$ (8,893)$ (2,470)$ (988)$ 12,352$ -$ N/A 68,810$ 30,312$ (17,960)$
Operating Revenues Over (Under) Expenditures (9,776)$ (54,221)$ 1,552$ (10,877)$ (73,322)$ (30,487)$ 240.5%23,080$ (358,165)$ 224,388$
Transfer From General Fund - - - - - - N/A - -
Reimbursement From Infrastructure Fund - - - - - -$ N/A - 21,336 (21,336)
Reimbursement From Water Fund - - - - - - N/A - 5,336 (5,336)
Reimbursement To General Fund (12,576) - - - (12,576) (12,577) 100.0%(18,865) (10,480) (2,096)
Total Interfund Transactions (12,576)$ -$ -$ -$ (12,576)$ (12,577)$ 100.0%(18,865)$ 16,192$ (28,768)$
Total Revenues Over (Under) Expenditures - Budgetary Basis (22,352)$ (54,221)$ 1,552$ (10,877)$ (85,898)$ (43,063)$ 4,215$ (341,973)$ 195,620$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay -$ 231,266$ 750$ -$ 232,016$ 269,066$
Depreciation Expense (42,906) (66,667) (1,800) (779) (112,151) (112,151)
IMRF Pension Expense (1,333) - - (33) (1,367) (1,367)
Total GAAP Adjustments (44,239)$ 164,600$ (1,050)$ (812)$ 118,498$ 155,548$
Fund Increase/(Decrease) - GAAP Basis (66,591)$ 110,379$ 502$ (11,689)$ 32,600$ (186,425)$
*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 August 31, 2022 8/31/22 8/31/22
8/31/22 YTD % of YTD 2022 8/31/21 Difference
815 816 YTD Amended Amended Adopted YTD Prior
Polo Open Fields Total Budget Budget Budget Total Year
OPERATING REVENUES
Field Rentals -$ 113,393$ 113,393$ 113,333$ 100.1%170,000$ 20,000$ 93,393$
Range Rentals - 80,000 80,000 56,667 141.2%85,000 80,000 -
Taste of Oak Brook - 66,812 66,812 80,000 83.5%120,000 - -
Other Revenue - - - N/A - - -
Total Operating Revenues -$ 260,205$ 260,205$ 250,000$ 104.1%375,000$ 100,000$ 93,393$
OPERATING EXPENDITURES
Personnel -$ -$ -$ -$ N/A -$ -$
Materials & Supplies - - - 1,000 0.0%1,500$ - -
Operational & Contractual 199 67,747 67,946 166,107 40.9%249,160 7,271 60,675
Capital - - - N/A 232,675 (232,675)
Total Operating Expenditures 199$ 67,747$ 67,946$ 167,107$ 40.7%250,660$ 239,946$ (172,000)$
Operating Revenues Over (Under) Expenditures (199)$ 192,458$ 192,259$ 82,893$ 231.9%124,340$ (139,946)$ 265,393$
INTERFUND TRANSACTIONS
Transfer From Hotel Tax Fund -$ -$ -$ -$ N/A -$ -$ -$
Total Interfund Transactions -$ -$ -$ -$ N/A -$ -$ -$
Total Revenues Over (Under) Expenditures - Budgetary Basis (199)$ 192,458$ 192,259$ 82,893$ 124,340$ (139,946)$ 265,393$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay -$ -$ -$ 232,675$
Depreciation Expense - (1,123) (1,123) (1,123)
Total GAAP Adjustments -$ (1,123)$ (1,123)$ 231,552$
Fund Increase/(Decrease) - GAAP Basis (199)$ 191,335$ 191,136$ 91,606$
*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 August 31, 2022
8/31/22 8/31/22
821 YTD % of YTD 2022 8/31/21 Difference
B&T Amended Amended Adopted YTD Prior
Clubhouse Budget Budget Budget Total Year
OPERATING REVENUES
Rentals 202,286$ 234,183$ 86.4%351,275$ 81,543$ 120,743$
Total Operating Revenues 202,286$ 234,183$ 86.4%351,275$ 81,543$ 120,743$
OPERATING EXPENDITURES
Personnel 84,793$ 93,500$ 90.7%140,250$ 77,872$ 6,921$
Materials & Supplies 5,454 10,233 53.3%15,350 4,224 1,230
Operational & Contractual 57,924 61,733 93.8%92,600 33,552 24,372
Capital - 33,333 0.0%50,000 4,382 (4,382)
Total Operating Expenditures 148,171$ 198,800$ 74.5%298,200$ 120,030$ 28,141$
B&T Administration Overhead Allocation*(12,352)$ -$ N/A (68,810)$ (30,312)$ 17,960$
Operating Revenues Over (Under) Expenditures 41,763$ 35,383$ 118.0%(15,735)$ (68,799)$ 110,562$
INTERFUND TRANSACTIONS
Transfer From General Fund -$ -$ 0.0%-$ -$ -$
Total Interfund Transactions -$ -$ 0.0%-$ -$ -$
Total Revenues Over (Under) Expenditures - Budgetary Basis 41,763$ 35,383$ (15,735)$ (68,799)$ 110,562$
ADUSTMENTS TO GAAP BASIS**
Remove Capital Outlay -$ 4,382$
Depreciation Expense (25,000) (40,000)
IMRF Pension Expense (1,250) (2,000)
OPEB Expense (1,250) (2,000)
Total GAAP Adjustments (27,500)$ (39,618)$
Fund Increase/(Decrease) - GAAP Basis 14,263$ (108,417)$
*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 August 31, 2022
8/31/22 8/31/22
823 831 832 833 834 8/31/22 YTD % of YTD 2022 8/31/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 -$ 406,225$ -$ -$ -$ 406,225$ 235,200$ 172.7%352,800$ 355,800$ 50,425$
Greens Fees - 898,170 - - - 898,170 763,333 117.7%1,145,000 973,849 (75,679)
Pro Shop Sales - 160,474 - - - 160,474 140,000 114.6%210,000 181,752 (21,278)
Golf Lessons - - 39,448 - - 39,448 33,333 118.3%50,000 45,105 (5,657)
Driving Range Fees - - 303,523 - - 303,523 200,000 151.8%300,000 296,119 7,404
Rentals - - - 320,019 - 320,019 258,333 123.9%387,500 369,323 (49,304)
Food Sales 201,510 - - - - 201,510 166,667 120.9%250,000 203,018 (1,508)
Beverage Sales 358,944 - - - - 358,944 313,333 114.6%470,000 372,791 (13,847)
Other Revenue - - - - - - 4,667 0.0%7,000 7,239 (7,239)
Total Operating Revenues 560,454$ 1,464,869$ 342,971$ 320,019$ -$ 2,688,312$ 2,114,867$ 127.1%3,172,300$ 2,804,996$ (116,684)$
OPERATING EXPENDITURES
Personnel 158,339$ 352,412$ 40,670$ 30,429$ 222,845$ 804,696$ 935,853$ 86.0%1,403,780$ 900,835$ (96,139)$
Materials & Supplies 233,183 101,932 15,447 1,449 141,315 493,326 418,333 117.9%627,500 457,882 35,444
Operational & Contractual 3,990 159,210 656 54,380 39,952 258,187 195,650 132.0%293,475 252,887 5,300
Other - - - - - - N/A - - -
Capital - 108,214 - - - 108,214 239,333 45.2%359,000 134,788 (26,574)
Total Operating Expenditures 395,512$ 721,768$ 56,773$ 86,258$ 404,112$ 1,664,423$ 1,789,170$ 93.0%2,683,755$ 1,746,392$ (81,969)$
Operating Revenues Over (Under) Expenditures 164,942$ 743,101$ 286,197$ 233,761$ (404,112)$ 1,023,889$ 325,697$ 314.4%488,545$ 1,058,604$ (34,715)$
INTERFUND TRANSACTIONS
Transfer from Golf Surcharge -$ -$ -$ -$ -$ -$ 100,000$ 0.0%150,000$ -$ -$
Reimbursement to General Fund - (37,728) - - - (37,728) (37,727) 100.0%(56,590) (31,448) (6,280)
Total Interfund Transactions -$ (37,728)$ -$ -$ -$ (37,728)$ 62,273$ -60.6%93,410$ (31,448)$ (6,280)$
Total Revenues Over (Under) Expenditures - Budgetary Basis 164,942$ 705,373$ 286,197$ 233,761$ (404,112)$ 986,161$ 387,970$ 581,955$ 1,027,156$ (40,995)$
ADUSTMENTS TO GAAP BASIS*
Remove Capital Outlay -$ 108,214$ -$ -$ -$ 108,214$ 134,788$
Depreciation Expense (667) (70,000) (1,533) (8,667) (83,333) (164,200) (164,200)
IMRF Pension Expense (1,667) (6,667) (667) - (7,333) (16,333) (16,333)
OPEB Expense (2,000) (10,000) - - (6,667) (18,667) (18,667)
Total GAAP Adjustments (4,333)$ 21,548$ (2,200)$ (8,667)$ (97,333)$ (90,986)$ (64,412)$
Fund Increase/(Decrease) - GAAP Basis 160,609$ 726,920$ 283,997$ 225,094$ (501,445)$ 895,175$ 962,744$
*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 $20,304,523 $13,432,253 $33,736,776 59.5%
Hotel/Motel Tax 1,384,616 618,937 $2,003,552 3.5%
Motor Fuel Tax 1,440,755 14,258 $1,455,014 2.6%
Infrastructure 4,605,526 4,350,495 $8,956,020 15.8%
Promenade TIF 20,588 $20,588 0.0%
Water 4,161,871 3,255,795 $7,417,665 13.1%
Sports Core 1,735,083 $1,735,083 3.1%
Golf Surcharge 386,169 ‐ $386,169 0.7%
Self‐Insurance (165,253) ($165,253)‐0.3%
Garage 329,564 $329,564 0.6%
Equipment Replacement 535,382 269,565 $804,947 1.4%
Total $34,738,823 $21,941,302 $56,680,125 100.0%
Change in Cash and Investments by Fund :
Balance at Balance at Year‐to‐Date Year‐to‐Date
Fund January 1, 2022 August 31, 2022 Change ($) Change (%)
General Corporate $25,941,144 $33,736,776 $7,795,632 30.1%
Hotel/Motel Tax 1,754,745 2,003,552 248,807 14.2%
Motor Fuel Tax 1,153,550 1,455,014 301,464 26.1%
Infrastructure 10,880,028 8,956,020 (1,924,008)‐17.7%
Promenade TIF 298,387 20,588 (277,799)‐93.1%
Water 3,614,863 7,417,665 3,802,802 105.2%
Sports Core 576,566 1,735,083 1,158,517 200.9%
Golf Surcharge 278,773 386,169 107,396 38.5%
Self‐Insurance 87,655 (165,253) (252,908)‐288.5%
Garage 325,902 329,564 3,662 1.1%
Equipment Replacement 759,255 804,947 45,692 6.0%
$45,670,868 $56,680,125 $11,009,257 24.1%
Book Bank/Market
Value Value
Cash and Cash Equivalents:
Pooled Checking $1,245,946 $2,212,045
Sports Core Checking 4,386,026 4,345,224
Pooled IPTIP 28,035,547 28,035,547
Water E‐Pay IPTIP 1,114,076 1,099,467
$34,781,595 $35,692,283
Pooled Investments:
Investments‐Municipal Bonds $7,353,134 $7,070,537
Investments‐Corporate Bonds 8,427,531 8,119,226
Government & Agency Obligations 4,852,687 4,658,702
Certificates of Deposit 1,225,000 1,160,474
Accrued Interest 82,950 82,950
Total Pooled Investments $21,941,302 $21,091,889
Total Cash and Investments $56,722,897 $56,784,172
Monthly Treasurer's Report
August 31, 2022
Monthly Treasurer's Report
August 31, 2022
The table below lists the detail investment holdings at J.P. Morgan Securities as of 08/31/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 445,086 4,510
Oakland Univ Mich #673588HJ1 04/29/20 03/01/24 5.000% 1.650% 309,578 305,095 4,917
University of CA #91412HFK4 07/16/20 05/15/23 0.628% 0.628% 25,000 24,485 (0)
Cook, Kane, Lake, & McHenry #216181GL5 10/29/2020 12/15/2022 4.000% 0.300% 1,036,038 1,030,207 10,305
Miami‐Dade Cnty #59333NN90 11/16/2020 12/15/2022 0.375% 0.430% 734,045 720,050 1,141
Hamilton NY #407741MC8 1/21/2021 5/1/2023 1.000% 0.550% 205,615 201,353 683
Southern Cal Pub Pwr #84247PHZ7 1/25/2021 4/1/2024 3.608% 0.500% 1,056,547 998,350 5,813
Hillsborough Cnty FL #43232VV3 3/11/2021 7/1/2024 1.815% 0.770% 509,486 481,570 1,437
Port Auth of NY and NJ #73358WAH7 4/15/2021 12/1/2024 5.859% 0.600%558,650 521,015 7,161
City of Atlanta GA Water #047870SG6 4/19/2021 11/1/2024 0.616% 0.500% 250,622 233,793 505
West Contra Costa Cal Uni #9523474U3 6/17/2021 8/1/2024 0.575% 0.575% 500,000 469,215 232
New York NY City #64971XA40 10/7/2021 11/1/2024 0.450% 0.620% 711,311 667,474 1,064
NY Urban Dev Corp #650036AR7 11/5/2021 3/15/2023 0.720% 0.451% 500,724 492,475 1,650
Colorado Brdg Enterprise #19633SAZ6 11/24/2021 12/31/2023 0.923% 0.844% 500,519 480,370 987
Total Municipal Bonds $7,353,134 $7,070,537 $40,403
Corporate Bonds:
PNC Bank #69349LAK4 12/7/2020 1/30/2023 2.950% 0.457% 1,030,510 1,018,403 2,507
Wells Fargo #94974BFJ4 12/7/2020 2/13/2023 3.450% 0.480% 1,408,541 1,386,018 2,265
Comerica Bank #200340AS6 12/23/2020 7/31/2023 3.700% 0.500% 514,574 499,293 1,542
Bank of America #06048WM23 5/14/2021 5/14/2024 0.650% 0.650% 915,000 855,048 248
Goldman Sachs #38141GXE9 7/27/2021 2/20/2024 3.625% 0.693% 625,607 595,628 604
Goldman Sachs #38150AGU3 7/28/2021 7/28/2023 0.550% 0.550% 655,000 635,519 330
Morgan Stanley #61746BDQ6 7/28/2021 4/29/2024 3.875% 0.547% 1,054,763 997,450 13,132
Citigroup #17329UEH0 11/18/2021 11/18/2024 1.000% 1.149% 1,000,000 932,227 2,833
Bank New York Mellon #06406RAG2 1/25/2022 4/28/2023 3.500% 0.810% 712,268 700,349 8,303
Comerica Bank #200340AS6 1/25/2022 7/31/2023 3.700% 1.200% 511,268 499,293 1,542
Total Corporate Bonds $8,427,531 $8,119,226 $33,306
Government & Agency Obligations:
*Government National Mtg Assn #38381WV96 08/06/19 07/20/54 2.250% 2.293% 96,853 86,176 6
*Government National Mtg Assn #38380BNV3 12/05/19 06/20/46 2.000% 2.112% 277,391 279,323 352
Federal Home Loan Bank #3130AMVU3 06/29/21 06/29/26 0.500% 0.500% 500,000 454,148 417
*Government National Mtg Assn #38383DWC8 12/14/2021 11/20/2056 1.250% 1.379% 840,652 704,172 1,025
Federal Home Loan Bank #313381BR5 2/25/2022 12/9/2022 1.875% 0.900%857,267 852,405 3,563
US Treasury #912796X61 6/8/2022 12/8/2022 1.670% 1.670% 2,280,523 2,282,478 3,082
Total Government & Agency Obligations: $4,852,687 $4,658,702 $8,444
Certificates of Deposit:
Goldman Sachs 38149MXG3 07/28/21 07/29/24 0.550% 0.550% 245,000 232,267 129
Sallie Mae #795451AD5 07/28/21 07/29/24 0.600% 0.600% 245,000 232,493 135
Texas Exchange Bk #88241TLS7 07/30/21 07/30/24 0.500% 0.500% 245,000 231,971 409
Toyota Financial #89235MLF6 08/05/21 8/5/2024 0.550% 0.550% 245,000 232,123 99
UBS Bank #90348JT42 09/22/21 9/23/2024 0.650% 0.650% 245,000 231,620 25
Total Certificates of Deposits $1,225,000 $1,160,474 $797
Total J.P.Morgan Securities $21,858,352 $21,008,939 $82,950
*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
August 31, 2022
Cash & Investments by Fund ‐ Total $56.68 million
Cash & Investments by Type ‐ Total $56.68 million
General Corporate
59.2%
Hotel/Motel Tax
3.5%Motor Fuel Tax
2.6%
Infrastructure
15.7%
Promenade TIF
0.0%
Water
13.0%
Sports Core
3.0%
Golf Surcharge
0.7%
Self‐Insurance
‐0.3%
Garage
0.6%Equipment Replacement
1.4%
Checking, $5.6
Illinois Funds, $29.1
Certificates of Deposit,
$1.2
Municipal Bonds, $7.4
Corporate Bonds, $8.4
Government & Agency
Obligations, $4.9
Accrued Interest, $0.1
in millions