Loading...
07 - July 2022 Monthly Financial ReportVILLAGE OAK BROOK OF MONTHLY FINANCIAL REPORTS JULY 2022 Village of Oak Brook Monthly Financial Report – Fund Narrative For the Period Ending July 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 July 2022 are $4,531,888, or 31.2%, higher than last July, and $4,741,119, or 33.07%, over budget to date. The main drivers for this are: o Sales tax revenue, the General Fund’s largest revenue source, is up $2,988,052 from last year and $2,860,614 over budget. July 2022 collections came in at the highest level in the past five years. o Other Intergovernmental Tax is up $616,637 from last year and $918,717 over budget. Receipts from Income Tax and Replacement Tax came in higher than anticipated in July. o The Telecommunication/Utility Tax is up $ 121,654 from last year and $112,242 over budget. • Total expenditures through July 2022 are $533,281, or 4.3%, higher than last year and $452,045, or 3.61%, over budget to date. Hotel Tax Fund • Total revenues through July 2022 are $313,434, or 90.3%, higher than last year and $193,406, or 41.42%, over budget to date. The main drivers for this are: o Hotel tax revenue is up $329,588 from last year and $199,332 over budget. Hotel stay continues to recover from the effects of COVID-19 on the travel industry. • Total expenditures through July 2022 are $58,731 higher than last year and $29,885 under budget. Infrastructure Fund • Total revenues through July 2022 are up $1,023,403, or 31.1%, from last year and $264,470 or 15.7%, over budget. The main drivers for this are: o Non-home rule sales tax revenue is up $1,009,127 from last year, and $879,687 over budget. July 2022 collections came in at the highest level in the past five years. • Total expenditures through July 2022 are down $488,914, or 9.6%, from last year and $2,671,057 or 36.7%, under budget to date. The main drivers for this are: o Operation and contract expenditures are down $61,473 from last year and $406,205 under budget. o Capital Outlay is down $341,909 from last year and $2,671,057 under budget. Promenade TIF Fund • Total revenues through July 2022 are down $41,138 or 16.5%, from last year and $80,570 under budget. Revenues are under budget due to the timing of information to record the TIF sale tax transfer. • Total expenditures through July 2022 are down $241,988 from last year and $42,774 under budget. The decrease relates to timing in payment of notes payable compared to last year. Water Fund • Total revenues through July 2022 are up $348,302, or 5.4% higher than last year and $525,203, or 8.40%, over budget. • Total expenditures through July 2022 are down $4,170,300, or 59.9%, from last year and $3,072,230 or 52.44%, under budget. The main drivers for this are: o Personnel expenditures are down $247,620 from last year and $130,181 under budget. o Capital outlay expenditures are down $4,123,345 from last year. Sports Core Fund • Total revenues through July 2022 are up $624,446 or 25.3% higher than last year and $513,028, over budget to date. The main drivers for this are: o Membership revenue is up $450,898 from last year and $341,376 over budget. o Rentals are up by $130,121 from last year and $20,203 under budget. • Total expenditures through July 2022 are up $359,570, or 21.10%, from last year, and $156,629, or 4.12% under budget to date. The main drivers for this are: o Personnel expenditure are down $7,254 from last year and $182,060 under budget. o Operation and contract expenditures are higher $260,652 from last year and $14,398 over budget. o Capital outlay expenditures are up $131,196 from last year, and $63,445 over budget. YTD YTD Net Fund Budgeted YTD YTD Increase Increase Governmental Funds Revenues Expenditures (Decrease)(Decrease) General Fund (Major Fund)19,408,046$               13,028,069$               6,379,977$                 2,090,903$                   Main operating fund of the Village. Hotel Fund (Major Fund)660,364$                     187,573$                     472,791$                     136,698$                       Collects and spends resources from the   3% hotel/motel tax. Motor Fuel Tax Fund 272,471$                     ‐$                             272,471$                     157,960$                       Collects and spends resources from the   State motor fuel tax. Infrastructure Fund (Major Fund)4,497,490$                 4,675,480$                 (177,990)$                   (2,866,555)$                  Accounts for construction and maintenance of   roadways, drainage, and safety path systems. Promenade TIF Fund (Major Fund)208,209$                     243,150$                     (34,941)$                      2,855$                           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)6,775,911$                 3,031,412$                 3,744,498$                 147,067$                       Collects user fees for the distribution of water   and maintenance of infrastructure. Sports Core Fund (Major Fund)3,091,376$                 2,103,934$                 987,442$                     405,285$                       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,690,747$                 1,751,463$                 (60,716)$                      66,675$                         Accounts for the Village's health insurance costs   and the related contributions from the Village,   employees, retirees, and other agencies. Garage Fund 363,525$                     367,227$                     (3,701)$                        (17,760)$                        Accounts for the maintenance of the Village's vehicle   fleet and the related departmental reimbursements. Equipment Replacement Fund 525,377$                     492,592$                     32,785$                       (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 July 31, 2022 7/31/22 7/31/22 7/31/21 7/31/22 YTD % of YTD 2022 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Sales Tax 7,572,562$       10,560,614     7,700,000$       137.2% 13,200,000$     2,988,052$       Other Intergovernmental Tax* 1,246,146         1,862,783       944,067             197.3% 1,618,400         616,637             Telecommunications/Utility Tax 3,254,338         3,375,992       3,263,750         103.4% 5,595,000         121,654             Grants 10,466             8,750                 119.6% 15,000               10,466               Licenses and Permits 1,237,412         1,385,732       1,171,048         118.3% 2,007,510         148,320             Charges for Services 716,934             1,377,260       673,692             204.4% 1,154,900         660,326             Fines and Penalties 96,696               56,790             82,833               68.6% 142,000             (39,906)             Administrative Towing Fees 16,252               26,500             14,583               181.7% 25,000               10,248               Investment Interest 113,481             101,249           84,000               120.5% 144,000             (12,232)             Franchise Fees 56,400               109,116           115,500             94.5% 198,000             52,716               Installment Contract Proceeds ‐                         N/A ‐                         Miscellaneous Income 236,223             211,830           278,991             75.9% 478,270             (24,393)             Total Operating Revenues 14,546,444$     19,078,332$   14,337,213$     133.1% 24,578,080$     4,531,888$       OPERATING EXPENDITURES Personnel 10,141,246$     10,273,733$   9,798,350$       104.9% 19,596,700$     132,487$          Materials and Supplies 232,070             247,458           270,890             91.4% 541,780             15,388$             Operation and Contract 1,926,835         2,346,939       1,792,010         131.0% 3,584,020         420,104$          Other Expenditures 4,315                 4,290               4,500                 95.3% 9,000                 (26)$                   Capital Outlay 126,223             91,550             646,175             14.2% 1,292,350         (34,673)$           Total Operating Expenditures 12,430,689$     12,963,970$   12,511,925$     103.6% 25,023,850$     533,281$          SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 2,115,755$       6,114,362$     1,825,288$       335.0% (445,770)$         3,998,607$       INTERFUND TRANSACTIONS Transfers In ‐$                   ‐$                 ‐$                   N/A ‐$                   ‐$                   Transfers Out ‐                     N/A ‐                     Reimbursements From Other Funds 346,311             329,714           329,712             100.0% 565,220             (16,597)             Reimbursements To Other Funds (61,768)             (64,099)            (64,097)             100.0% (109,880)           (2,331)                Sports Core Loan ‐                     N/A ‐                     ‐                     Total Interfund Transactions 284,543$          265,615$        265,615$          100.0% 455,340$          (18,928)$           NET FUND INCREASE (DECREASE) 2,400,298$       6,379,977$    2,090,903$      9,570$               3,979,679$      *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 July 31, 2022 Total Total Revenues Expenditures 7/31/22 Actual 19,078,332$ 12,963,970$ 7/31/21 Actual 14,546,444$ 12,430,689$ % Change From Last Year 31.2%4.3% Major Revenues Other Telecom/Utility Licenses &Charges for Sales Tax Intergov. Tax Tax Permits Services 7/31/22 Actual 10,560,614$ 1,862,783$ 3,375,992$ 1,385,732$ 1,377,260$ 7/31/21 Actual $ 7,572,562 $ 1,246,146 $ 3,254,338 $ 1,237,412 $ 716,934 % Change From Last Year 39.5%49.5%3.7%12.0%92.1% Five Year Trend Major Expenditures Materials &Operation &Other Personnel Supplies Contractual Expenditures Capital Outlay 7/31/22 Actual 10,273,733$ 247,458$ 2,346,939$ 4,290$ 91,550$ 7/31/21 Actual 10,141,246$ 232,070$ 1,926,835$ 4,315$ 126,223$ % Change From Last Year 1.3%6.6%21.8%-0.6%-27.5% Five Year Trend Expenditures by Department 7/31/21 7/31/22 7/31/22 7/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 July 31, 2022 General Fund - Five Year Trend Village of Oak Brook Revenues Expenditures 7/31/22 7/31/22 7/31/21 7/31/22 YTD % of YTD 2022 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Hotel Tax 320,952$           650,540$         451,208$           144.2% 773,500$           329,588$           Investment Interest 21,978               9,824               12,250               80.2% 21,000               (12,154)              Loan Interest 4,000                 ‐                   3,500                 0.0% 6,000                 (4,000)                Total Operating Revenues 346,930$           660,364$        466,958$           141.4% 800,500$           313,434$           EXPENDITURES Operation and Contract 77,892$             86,578$           169,158$           51.2% 289,985$           8,686$               Capital Outlay 2,650                 52,695             ‐                      N/A ‐                      50,045               Total Expenditures 80,542$             139,273$        169,158$           82.3% 289,985$           58,731$             SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 266,388$           521,091$        297,800$           175.0% 510,515$           254,703$           INTERFUND TRANSACTIONS Transfer Out (2,080,078)$      ‐$                 (112,802)$         0.0% (193,375)$         2,080,078$       Reimbursements to Other Funds (49,049)              (48,300)            (48,300)              100.0% (82,800)              749                     Total Interfund Transactions (2,129,127)$      (48,300)$         (161,102)$         30.0% (276,175)$         2,080,827$       NET FUND INCREASE (DECREASE) (1,862,739)$      472,791$        136,698$           234,340$           2,335,530$       Note ‐ Expenditures are recorded in program 171. Village of Oak Brook Hotel Tax Fund Financial Update For the Period Ending July 31, 2022 Total Total Revenues Expenditures 7/31/22 Actual  $              660,364 139,273$                7/31/21 Actual  $              346,930 80,542$                  % Change From Last Year 90.3% 72.9% Major Revenues Investment Hotel Tax Interest Loan Interest Miscellaneous 7/31/22 Actual  $              650,540  $                   9,824 4,000$                    ‐$                        7/31/21 Actual  $              320,952  $                 21,978 ‐$                        ‐$                        % Change From Last Year 102.7% ‐55.3% 0.0% 0.0% Five Year Trend Major Expenditures Operation & Contractual Capital Outlay 7/31/22 Actual 86,578$                  52,695$                  7/31/21 Actual 77,892$                  2,650$                    % Change From Last Year 11.2% N/A Five Year Trend Village of Oak Brook Hotel Tax Fund ‐ Major Sources Five Year Trend For the Period Ending July 31, 2022 Five Year Trend Revenues Expenditures 7/31/22 7/31/22 7/31/21 7/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,262,643$   4,271,770$    3,392,083$       125.9% 5,815,000$       1,009,127$       Charges for Services ‐                 ‐                    ‐                     N/A ‐                       ‐$                   Investment Interest 19,728            37,084            16,042               231.2% 27,500               17,356               Grants ‐                   ‐                       635,676            0.0% 1,089,730         ‐                          Miscellaneous 3,080               ‐                       583                    0.0% 1,000                 (3,080)                Total Operating Revenues 3,285,451$   4,308,854$    4,044,384$       106.5% 6,933,230$       1,023,403$       OPERATING EXPENDITURES Personnel 863,994$       788,872$        754,154$          104.6% 1,292,835$       (75,122)$           Materials and Supplies 137,601         127,190          132,183            96.2% 226,600            (10,411)             Operation and Contract 664,539         603,066          1,009,272         59.8% 1,730,180         (61,473)             Other Expenditures ‐                  ‐                   ‐                     N/A ‐                       ‐                     Capital Outlay 3,429,352      3,087,443      5,382,020         57.4% 9,226,320         (341,909)           Total Operating Expenditures 5,095,486$   4,606,572$    7,277,629$       63.3% 12,475,935$    (488,914)$         SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES (1,810,035)$  (297,718)$      (3,233,245)$     9.2% (5,542,705)$     1,512,317$       INTERFUND TRANSACTIONS Transfers In 2,080,078$   ‐$                 246,969$          0.0% 423,375$          (2,080,078)$     Reimbursements From Other Funds 193,578         188,636          188,630            100.0% 323,365            (4,942)                Reimbursements To Other Funds (102,844)        (68,908)           (68,909)             100.0% (118,130)           33,936               Total Interfund Transactions 2,170,812$   119,728$       366,689$          32.7% 628,610$          (2,051,084)$     NET FUND INCREASE (DECREASE) 360,777$       (177,990)$     (2,866,555)$    (4,914,095)$     (538,767)$        Village of Oak Brook Infrastructure Fund Financial Update For the Period Ending July 31, 2022 Total Total Revenues Expenditures 7/31/22 Actual  $          4,308,854 4,606,572$           7/31/21 Actual  $          3,285,451 5,095,486$           % Change From Last Year 31.1% ‐9.6% Major Revenues Sales Tax Charges for  Services Investment  Interest Miscellaneous 7/31/22 Actual  $          4,271,770   $                         ‐    $                37,084  $                         ‐    7/31/21 Actual  $          3,262,643   $                         ‐    $                19,728  $                         ‐    % Change From Last Year 30.9% 0.0% 88.0% 0.0% Five Year Trend Major Expenditures Materials & Operation & Personnel Supplies Contractual Capital Outlay 7/31/22 Actual 788,872$               127,190$               603,066$               3,087,443$           7/31/21 Actual 863,994$               137,601$               664,539$               3,429,352$           % Change From Last Year ‐8.7% ‐7.6% ‐9.3% ‐10.0% Five Year Trend Expenditures by Department 7/31/21 7/31/22 7/31/22 7/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 July 31, 2022 Revenues Expenditures 7/31/22 7/31/22 7/31/21 7/31/22 YTD % of YTD 2022 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Sales Tax 45,088$            ‐$                   52,500$            0.0% 90,000$            (45,088)$           Real Estate Tax 204,228            207,773            236,250            87.9% 405,000            3,545                 Investment Interest 31                       436                    29                       1494.9% 50                       405                    Total Operating Revenues 249,347$          208,209$          288,779$          72.1% 495,050$          (41,138)$           EXPENDITURES Operation and Contract 3,638$               ‐$                   2,275$               0.0% 3,900$               (3,638)$             Other Expenditures 481,500            243,150            283,649            85.7% 486,255            (238,350)           Total Expenditures 485,138$          243,150$          285,924$          85.0% 490,155$          (241,988)$         NET FUND INCREASE (DECREASE) (235,791)$         (34,941)$           2,855$               4,895$               200,850$          Note ‐ Expenditures are recorded in program 283. Village of Oak Brook Promenade TIF Fund Financial Update For the Period Ending July 31, 2022 Total Total Revenues Expenditures 7/31/22 Actual  $              208,209 243,150$                7/31/21 Actual  $              249,347 485,138$                % Change From Last Year ‐16.5% ‐49.9% Major Revenues Real Estate Investment Sales Tax Tax Interest 7/31/22 Actual ‐$                        $              207,773   $                      436  7/31/21 Actual 45,088$                  $              204,228   $                        31  % Change From Last Year ‐100.0% 0.0% 1306.5% Five Year Trend Major Expenditures Operation & Other Contractual Expenditures 7/31/22 Actual ‐$                        243,150$                7/31/21 Actual 3,638$                    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 July 31, 2022 Five Year Trend Revenues Expenditures 7/31/22 7/31/22 7/31/21 7/31/22 YTD % of YTD 2022 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Plan Review Fees 450$                   450$                   583$                   77.1% 1,000$               ‐$                   Building/Inspection Fees 2,775                 1,350                 2,917                 46.3% 5,000                 (1,425)                Water Sales 5,516,815          6,055,296          6,115,958          99.0% 10,484,500       538,481             Unmetered Sales 33,440               52,019               29,167               178.4% 50,000               18,579               Water Connection Fees 182,850             563,960           43,750             1289.1% 75,000               381,110           Fire Service Charge ‐                      N/A ‐                      Meter Charges 6,456                 17,729               8,750                 202.6% 15,000               11,273               Special Services 13,333               1,154                 14,583               7.9% 25,000               (12,179)              Investment Interest 30,706               19,963               17,500               114.1% 30,000               (10,743)              Miscellaneous 640,784             63,990               17,500               365.7% 30,000               (576,794)            Total Operating Revenues 6,427,609$       6,775,911$       6,250,708$       108.4% 10,715,500$     348,302$           OPERATING EXPENDITURES Personnel 495,581$           247,597$           377,778$           65.5% 647,620$           (247,984)$         Materials and Supplies 47,841               44,023               40,629               108.4% 69,650               (3,818)                Operation and Contract 2,258,264          2,463,111          3,150,365          78.2% 5,400,625          204,847             Capital Outlay 4,154,739          31,394               2,289,583          1.4% 3,925,000          (4,123,345)        Total Expenditures 6,956,425$       2,786,125$       5,858,355$       47.6% 10,042,895$     (4,170,300)$      Surplus (Deficit) of Revenues Over   Expenditures 5,515$               3,989,785$       392,353$           1016.9% 672,605$           4,518,601$       INTERFUND TRANSACTIONS Reimbursements To Other Funds (262,794)$         (245,287)$         (245,286)$         100.0% (420,490)$         17,507$             Total Interfund Transactions (262,794)$         (245,287)$         (245,286)$         100.0% (420,490)$         17,507$             Fund Increase/(Decrease) ‐ Budgetary Basis (257,279)$         3,744,498$      147,067$          252,115$           4,536,108$      ADUSTMENTS TO GAAP BASIS* Remove Capital Outlay 4,154,739$       31,394$             Depreciation Expense (335,417)            (335,417)            IMRF Pension Expense (26,250)              (26,250)              OPEB Expense (17,500)              (17,500)              Total GAAP Adjustments 3,775,572$       (347,773)$         Fund Increase/(Decrease) ‐ GAAP Basis 3,518,293$       3,396,726$      *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 July 31, 2022 Total Total Revenues Expenditures 7/31/22 Actual  $          6,775,911 2,786,125$           7/31/21 Actual  $          6,427,609 6,956,425$           % Change From Last Year 5.4% ‐59.9% Unmetered Water Water Sales Sales Connection Fees Meter Charges Miscellaneous 7/31/22 Actual  $          6,055,296   $                52,019  $             563,960  $                17,729  $                63,990  7/31/21 Actual  $          5,516,815   $                33,440  $             182,850  $                  6,456  $             640,784  % Change From Last Year 9.8% 55.6% 208.4% 174.6% ‐90.0% Five Year Trend Materials & Operation & Other Personnel Supplies Contractual Expenditures Capital Outlay 7/31/22 Actual 247,597$               44,023$                 2,463,111$           ‐$                        31,394$                 7/31/21 Actual 495,581$               47,841$                 2,258,264$           ‐$                        4,154,739$           % Change From Last Year ‐50.0% ‐8.0% 9.1% 0.0% ‐99.2% Five Year Trend Expenditures by Department 7/31/21 7/31/22 7/31/22 7/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 July 31, 2022 Revenues Expenditures Village of Oak BrookMonthly Operating StatementSports Core Fund Consolidated PresentationFor the Period Ending July 31, 20227/31/22 7/31/227/31/22 YTD % of YTD 2022 7/31/21 DifferenceB&T Recreation Field Clubhouse Golf YTD Amended Amended Adopted YTD PriorOperations Operations Operations Club Total Budget Budget Budget Total YearOPERATING REVENUESMemberships 402,838$             ‐$                      ‐$                      406,225$             809,063$             467,688$             173.0% 801,750$             358,165$             450,898$            Greens Fees ‐                        ‐                        ‐                        682,569                682,569                667,917                102.2% 1,145,000            755,130                (72,561)               Pro Shop Sales ‐                        ‐                        ‐                        131,244                131,244                122,500                107.1% 210,000                159,089                (27,845)               Golf Lessons ‐                        ‐                        ‐                        36,958                  36,958                  29,167                  126.7% 50,000                  47,595                  (10,637)               Driving Range Fees ‐                        ‐                        ‐                        262,033                262,033                175,000                149.7% 300,000                258,383                3,650                   Rentals ‐                        178,143               141,147                240,209                559,499                579,702                96.5% 993,775                429,378                130,121               Programs/User Fees 67,318                  ‐                        ‐                        ‐                        67,318                  9,042                    744.5% 15,500                  ‐                        67,318                 Food Sales 36,543                  ‐                        ‐                        150,702                187,245                166,833                112.2% 286,000                158,831                28,414                 Beverage Sales 14,575                  ‐                        ‐                        273,384                287,959                285,833                100.7% 490,000                286,768                1,191                   Taste of Oak Brook ‐                        66,312                  ‐                        ‐                        66,312                  70,000                  94.7% 120,000                ‐                        66,312                 Grants ‐                        ‐                        ‐                        ‐                        ‐                        ‐                        N/A ‐                        ‐                        ‐                       Other Revenue 1,176                    ‐                        ‐                        ‐                        1,176                    4,667                    25.2% 8,000                    13,591                  (12,415)               Total Operating Revenues 522,450$             244,455$             141,147$             2,183,323$          3,091,376$          2,578,348$          119.9% 4,420,025$          2,466,930$          624,446$            OPERATING EXPENDITURESPersonnel 51,817$               ‐$                      73,719$                667,376$             792,912$             974,972$             81.3% 1,671,380$          800,166$             (7,254)$               Materials & Supplies 45,959                  ‐                        2,016                    318,972                366,946                419,358                87.5% 718,900                391,970                (25,024)               Operational & Contractual 247,889               58,738                  46,201                  211,517                564,344                549,946                102.6% 942,765                303,692                260,652               Other ‐                        ‐                        ‐                        ‐                        ‐                        ‐                        N/A ‐                        ‐                        ‐                       Capital 227,501               ‐                        ‐                        108,214                335,716                272,271                123.3% 466,750                204,520                131,196               Total Operating Expenditures 573,166$             58,738$               121,935$             1,306,079$          2,059,918$          2,216,547$          92.9% 3,799,795$          1,700,348$          359,570$            B&T Administration Overhead Allocation* 12,352$               ‐$                      (12,352)$              ‐$                      (0)$                        ‐$                      N/A ‐$                      ‐$                      (0)$                       Operating Revenues Over (Under) Expenditures (38,364)$              185,717$             6,860$                  877,244$             1,031,458$          361,801$             285.1% 620,230$             766,582$             264,876$            INTERFUND TRANSACTIONSInterfund Loan** ‐$                      ‐$                      ‐$                      ‐$                      ‐$                      ‐$                      N/A ‐$                      ‐$                      ‐$                     Transfer From General Fund ‐                        ‐                        ‐                        ‐                        ‐                        ‐                        N/A ‐                        ‐                        ‐                       Transfer From Golf Surcharge Fund ‐                        ‐                        ‐                        ‐                        ‐                        87,500                  0.0% 150,000                ‐                        ‐                       Reimbursement From Infrastructure Fund ‐                        ‐                        ‐                        ‐                        ‐                        ‐                        N/A ‐                        18,669                  (18,669)               Reimbursement From Water Fund ‐                        ‐                        ‐                        ‐                        ‐                        ‐                        N/A ‐                        4,669                    (4,669)                  Reimbursement To General Fund (11,004)                ‐                        ‐                        (33,012)                (44,016)                (44,015)                100.0% (75,455)                (36,687)                (7,329)                  Total Interfund Transactions (11,004)$              ‐$                      ‐$                      (33,012)$              (44,016)$              43,485$               ‐101.2% 74,545$               (13,349)$              (30,667)$             Total Revenues Over (Under) Expenditures ‐ Budgetary Basis(49,368)$              185,717$             6,860$                  844,232$             987,442$             405,285$             694,775$             753,233$             234,209$            ADUSTMENTS TO GAAP BASIS**Remove Capital Outlay 227,501$             ‐$                      ‐$                      108,214$             335,716$             204,520$            Depreciation Expense (98,132)                (983)                      (25,000)                (143,675)              (267,790)              (277,790)             IMRF Pension Expense (1,196)                  ‐                        (1,250)                   (14,292)                (16,738)                (17,238)               OPEB Expense ‐                        ‐                        (1,250)                   (16,333)                (17,583)                (18,083)               Total GAAP Adjustments 128,173$             (983)$                   (27,500)$              (66,086)$              33,604$               (108,591)$           Fund Increase/(Decrease) ‐ GAAP Basis 78,805$               184,734$             (20,640)$              778,146$             1,021,046$          644,642$            *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 7/31/22 Actual  $          3,091,376 2,059,918$            7/31/21 Actual  $          2,466,930 1,700,348$            % Change From Last Year 25.3% 21.1% Driving Program/ Memberships Greens Fees Range Fees Rentals User Fees 7/31/22 Actual  $             809,063   $             682,569   $             262,033   $             559,499 67,318$                 7/31/21 Actual  $             358,165   $             755,130   $             258,383   $             429,378 ‐$                       % Change From Last Year 125.9% ‐9.6% N/A 30.3% 0.0% Five Year Trend Materials & Operation & Other Personnel Supplies Contractual Expenditures Capital Outlay 7/31/22 Actual 792,912$               366,946$               564,344$               ‐$                       335,716$               7/31/21 Actual 800,166$               391,970$               303,692$               ‐$                       204,520$               % Change From Last Year ‐0.9% ‐6.4% 85.8% 0.0% 64.1% Five Year Trend Revenues by Department 7/31/21 7/31/22 7/31/22 7/31/22 2022 Difference Five YTD YTD YTD % of Annual Prior Year Actual Actual Budget Budget Budget Year Trend B&T Recreation Operations 7,442$                   522,450$               304,179$               171.8% 521,450$               463,890$               Open Field Operations 95,000                   244,455                 218,750                 111.8% 375,000                 83,143                   B&T Clubhouse Operations 33,658                   141,147                 204,910                 68.9% 351,275                 107,489                 Golf Club 1,780,175              2,183,323              1,850,508              118.0% 3,172,300              403,148                 Total Revenues 1,916,275$           3,091,376$           2,578,348$           119.9% 4,420,025$           1,057,670$           Expenditures by Department 7/31/21 7/31/22 7/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 208,612$               573,166$               330,855$               173.2% 567,180$               364,554$               Open Field Operations 5,161$                   58,738$                 146,218$               40.2% 250,660$               53,577$                 B&T Clubhouse Operations 85,415                   121,935                 173,950                 70.1% 298,200                 36,520                   Golf Club 958,642                 1,306,079              1,565,524              83.4% 2,683,755              347,437                 Total Expenditures 1,257,830$           2,059,918$           2,216,547$           92.9% 3,799,795$           802,088$               Five Year Trend Village of Oak Brook Sports Core Fund ‐ Major Sources Five Year Trend For the Period Ending July 31, 2022 Revenues Expenditures Village of Oak BrookMonthly Operating StatementBath & Tennis Club Recreation OperationsFor the Period Ending July 31, 20227/31/22 7/31/22822 7/31/22 YTD % of YTD 2022 7/31/21 Difference811 812 813 Poolside YTD Amended Amended Adopted YTD PriorB&T Admin Swimming Tennis Café Total Budget Budget Budget Total YearOPERATING REVENUESMemberships ‐$                   377,263$           25,575               ‐                     402,838$           261,888$           153.8% 448,950$           ‐$                   402,838$          Programs/User Fees ‐                     38,813               28,505               ‐                     67,318               9,041.67            744.5% 15,500               ‐                     67,318              Food Sales ‐                     ‐                     ‐                     36,543               36,543               21,000.00          174.0% 36,000               ‐                     ‐                    Beverage Sales ‐                     ‐                     ‐                     14,575               14,575               11,666.67          124.9% 20,000               ‐                     ‐                    Grants ‐                     ‐                     ‐                     ‐                     ‐                          ‐                     N/A ‐                     ‐                     ‐                    Other Revenue 1,176                 ‐                     ‐                     ‐                     1,176                 583                    201.6% 1,000                 7,442                 (6,266)               Total Operating Revenues 1,176$               416,076$           54,080$             51,118$             522,450$           304,179$           171.8% 521,450$           7,442$               463,890$          OPERATING EXPENDITURESPersonnel 14,900$             11,952$             ‐$                       24,966$             51,817$             74,288$             69.8% 127,350$           6,867$               44,950$            Materials & Supplies 325                    11,568               2,695                 31,371               45,959               43,488               105.7% 74,550               28,301               17,658              Operational & Contractual 16,457               185,948             39,522               5,962                 247,889             179,393             138.2% 307,530             40,024               207,865            Other ‐                     ‐                     ‐                          ‐                     N/A ‐                     ‐                    Capital ‐                     226,751             750                    ‐                     227,501             33,688               675.3% 57,750               133,420             94,081              Total Operating Expenditures 31,682$             436,219$           42,967$             62,298$             573,166$           330,855$           173.2% 567,180$           208,612$           364,554$          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 (5,803)$              (29,037)$           8,643$               (12,167)$           (38,364)$           (26,676)$           143.8% 23,080$             (176,828)$         87,346$            Transfer From General Fund ‐                     ‐                     ‐                     ‐                     ‐                     ‐                     N/A ‐                     ‐                    Reimbursement From Infrastructure Fund ‐                     ‐                     ‐                     ‐                     ‐                     ‐$                   N/A ‐                     16,002               (16,002)             Reimbursement From Water Fund ‐                     ‐                     ‐                     ‐                     ‐                     ‐                     N/A ‐                     4,002                 (4,002)               Reimbursement To General Fund (11,004)              ‐                     ‐                     ‐                     (11,004)              (11,005)              100.0% (18,865)              (7,860)                (3,144)               Total Interfund Transactions (11,004)$           ‐$                   ‐$                   ‐$                   (11,004)$           (11,005)$           100.0% (18,865)$           12,144$             (23,148)$          Total Revenues Over (Under) Expenditures ‐ Budgetary Basis (16,807)$           (29,037)$           8,643$               (12,167)$           (49,368)$           (37,680)$           4,215$               (164,684)$         64,198$            ADUSTMENTS TO GAAP BASIS**Remove Capital Outlay ‐$                   226,751$           750$                  ‐$                   227,501$           133,420$          Depreciation Expense (37,543)              (58,333)              (1,575)                (681)                   (98,132)              (84,114)             IMRF Pension Expense (1,167)                ‐                     ‐                     (29)                     (1,196)                (1,025)               Total GAAP Adjustments (38,709)$           168,418$           (825)$                 (711)$                 128,173$           48,282$            Fund Increase/(Decrease) ‐ GAAP Basis (55,516)$           139,381$           7,818$               (12,878)$           78,805$             (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 ona 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 BrookMonthly Operating StatementOpen Fields OperationsFor the Period Ending July 31, 20227/31/22 7/31/227/31/22 YTD % of YTD 2022 7/31/21 Difference815 816 YTD Amended Amended Adopted YTD PriorPolo Open Fields Total Budget Budget Budget Total YearOPERATING REVENUESField Rentals ‐$                    98,143$             98,143$             99,167$             99.0% 170,000$           15,000$             83,143$            Range Rentals ‐                      80,000               80,000               49,583               161.3% 85,000               80,000               ‐                     Taste of Oak Brook ‐                      66,312               66,312               70,000               94.7% 120,000             ‐                      ‐                     Other Revenue ‐                      ‐                      ‐                      N/A ‐                      ‐                      ‐                     Total Operating Revenues ‐$                   244,455$           244,455$           218,750$           111.8% 375,000$           95,000$             83,143$            OPERATING EXPENDITURESPersonnel ‐$                    ‐$                    ‐$                    ‐$                    N/A ‐$                    ‐$                   Materials & Supplies ‐                      ‐                      ‐                      875                     0.0% 1,500$               ‐                      ‐                     Operational & Contractual 199                     58,538               58,738               145,343             40.4% 249,160             5,161                  53,577              Capital ‐                      ‐                      ‐                      N/A ‐                      ‐                     Total Operating Expenditures 199$                   58,538$             58,738$             146,218$           40.2% 250,660$           5,161$               53,577$            Operating Revenues Over (Under) Expenditures (199)$                 185,916$           185,717$           72,532$             256.0% 124,340$           89,839$             29,566$            INTERFUND TRANSACTIONSTransfer From Hotel Tax Fund ‐$                    ‐$                    ‐$                    ‐$                    N/A ‐$                    ‐$                    ‐$                   Total Interfund Transactions ‐$                   ‐$                   ‐$                   ‐$                   N/A ‐$                   ‐$                   ‐$                  Total Revenues Over (Under) Expenditures ‐ Budgetary Basis (199)$                185,916$          185,717$          72,532$             124,340$          89,839$            29,566$           ADUSTMENTS TO GAAP BASIS**Remove Capital Outlay ‐$                    ‐$                    ‐$                    ‐$                   Depreciation Expense ‐                      (983)                    (983)                    (843)                   Total GAAP Adjustments ‐$                   (983)$                 (983)$                 (843)$                Fund Increase/(Decrease) ‐ GAAP Basis (199)$                184,934$          184,734$          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 tovarious 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 BrookMonthly Operating StatementBath & Tennis Clubhouse OperationsFor the Period Ending July 31, 20227/31/22 7/31/22821 YTD % of YTD 2022 7/31/21 DifferenceB&T  Amended Amended Adopted YTD Prior Clubhouse Budget Budget Budget Total YearOPERATING REVENUESRentals 141,147$           204,910$           68.9% 351,275$           33,658$              107,489$          Total Operating Revenues 141,147$           204,910$           68.9% 351,275$           33,658$              107,489$          OPERATING EXPENDITURESPersonnel 73,719$              81,813$              90.1% 140,250$           52,515$              21,204$             Materials & Supplies 2,016                  8,954                  22.5% 15,350                2,890                  (874)                   Operational & Contractual 46,201                54,017                85.5% 92,600                25,628                20,573               Capital ‐                      29,167                0.0% 50,000                4,382                  (4,382)                Total Operating Expenditures 121,935$           173,950$           70.1% 298,200$           85,415$              36,520$             B&T Administration Overhead Allocation* (12,352)$            ‐$                    N/A (68,810)$            (24,342)$            11,990$             Operating Revenues Over (Under) Expenditures 6,860$                30,960$              22.2% (15,735)$            (76,099)$            82,959$             INTERFUND TRANSACTIONSTransfer From General Fund ‐$                    ‐$                    0.0% ‐$                    ‐$                    ‐$                   Total Interfund Transactions ‐$                    ‐$                   0.0%‐$                    ‐$                    ‐$                   Total Revenues Over (Under) Expenditures ‐ Budgetary Basis 6,860$               30,960$             (15,735)$           (76,099)$           82,959$            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 (20,640)$           (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 BrookMonthly Operating StatementGolf Club ProgramsFor the Period Ending July 31, 20227/31/22 7/31/22823 831 832 833 834 7/31/22 YTD % of YTD 2022 7/31/21 DifferenceGolf Golf General Golf Learning Golf Cart Golf Course YTD Amended Amended Adopted YTD PriorCafé Operation & Practice Operations Maintenance Total Budget Budget Budget Total YearOPERATING REVENUESMemberships ‐$                   406,225$           ‐$                   ‐$                   ‐$                   406,225$           205,800$           197.4% 352,800$           356,915$           49,310$            Greens Fees ‐                     682,569             ‐                     ‐                     ‐                     682,569             667,917             102.2% 1,145,000          527,141             155,428            Pro Shop Sales ‐                     131,244             ‐                     ‐                     ‐                     131,244             122,500             107.1% 210,000             125,997             5,247                Golf Lessons ‐                     ‐                     36,958               ‐                     ‐                     36,958               29,167               126.7% 50,000               46,525               (9,567)               Driving Range Fees ‐                     ‐                     262,033             ‐                     ‐                     262,033             175,000             149.7% 300,000             215,198             46,835              Rentals ‐                     ‐                     ‐                     240,209             ‐                     240,209             226,042             106.3% 387,500             196,880             43,329              Food Sales 150,702             ‐                     ‐                     ‐                     ‐                     150,702             145,833             103.3% 250,000             109,460             41,242              Beverage Sales 273,384             ‐                     ‐                     ‐                     ‐                     273,384             274,167             99.7% 470,000             197,121             76,263              Other Revenue ‐                     ‐                     ‐                     ‐                     ‐                     ‐                     4,083                 0.0% 7,000                 4,938                 (4,938)               Total Operating Revenues 424,085$           1,220,038$        298,991$           240,209$           ‐$                   2,183,323$        1,850,508$        118.0% 3,172,300$        1,780,175$        403,148$          OPERATING EXPENDITURESPersonnel 124,499$           301,835$           32,010$             22,182$             186,850$           667,376$           818,872$           81.5% 1,403,780$        514,412$           152,964$          Materials & Supplies 179,514             53,029               9,552                 1,432                 75,445               318,972             366,042             87.1% 627,500             250,054             68,918              Operational & Contractual 3,537                 127,408             656                     45,138               34,777               211,517             171,194             123.6% 293,475             182,226             29,291              Other ‐                     ‐                     ‐                     ‐                     ‐                     ‐                     N/A ‐                     ‐                     ‐                    Capital ‐                     108,214             ‐                     ‐                     ‐                     108,214             209,417             51.7% 359,000             11,950               96,264              Total Operating Expenditures 307,550$           590,486$           42,219$             68,752$             297,073$           1,306,079$        1,565,524$        83.4% 2,683,755$        958,642$           347,437$          Operating Revenues Over (Under) Expenditures 116,535$           629,552$           256,772$           171,457$           (297,073)$          877,244$           284,985$           307.8% 488,545$           821,533$           55,711$            INTERFUND TRANSACTIONSTransfer from Golf Surcharge ‐$                   ‐$                   ‐$                   ‐$                   ‐$                   ‐$                   87,500$             0.0% 150,000$           ‐$                   ‐$                  Reimbursement to General Fund ‐                     (33,012)              ‐                     ‐                     ‐                     (33,012)              (33,011)              100.0% (56,590)              (23,586)              (9,426)               Total Interfund Transactions ‐$                   (33,012)$            ‐$                   ‐$                   ‐$                   (33,012)$            54,489$             ‐60.6% 93,410$             (23,586)$            (9,426)$             Total Revenues Over (Under) Expenditures ‐ Budgetary Basis 116,535$           596,540$           256,772$           171,457$           (297,073)$          844,232$           339,474$           581,955$           797,947$           46,285$            ADUSTMENTS TO GAAP BASIS*Remove Capital Outlay ‐$                   108,214$           ‐$                   ‐$                   ‐$                   108,214$           11,950$            Depreciation Expense (583)                   (61,250)              (1,342)                (7,583)                (72,917)              (143,675)            (123,150)           IMRF Pension Expense (1,458)                (5,833)                (583)                   ‐                     (6,417)                (14,292)              (12,250)             OPEB Expense (1,750)                (8,750)                ‐                     ‐                     (5,833)                (16,333)              (14,000)             Total GAAP Adjustments (3,792)$              32,381$             (1,925)$              (7,583)$              (85,167)$            (66,086)$            (137,450)$         Fund Increase/(Decrease) ‐ GAAP Basis 112,744$           628,921$           254,847$           163,874$           (382,239)$          778,146$           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 $19,436,283 $13,661,225 $33,097,508 58.8% Hotel/Motel Tax 1,521,688                     629,487                       $2,151,176 3.8% Motor Fuel Tax 1,411,080                     14,501                         $1,425,581 2.5% Infrastructure 5,842,330                     4,424,655                    $10,266,985 18.3% Promenade TIF 263,447                        $263,447 0.5% Water 2,832,622                     3,311,294                    $6,143,917 10.9% Sports Core 1,527,616                     $1,527,616 2.7% Golf Surcharge 363,050                        40,736                         $403,786 0.7% Self‐Insurance (137,744)                      ($137,744)‐0.2% Garage 309,714                        $309,714 0.6% Equipment Replacement 516,692                        274,161                       $790,852 1.4% Total $33,886,778 $22,356,060 $56,242,838 100.0% Change in Cash and Investments by Fund : Balance at Balance at Year‐to‐Date Year‐to‐Date Fund January 1, 2022 July 31, 2022 Change ($) Change (%) General Corporate $25,941,144 $33,097,508 $7,156,364 27.6% Hotel/Motel Tax 1,754,745                     2,151,176                    396,431 22.6% Motor Fuel Tax 1,153,550                     1,425,581                    272,031 23.6% Infrastructure 10,880,028                  10,266,985                (613,043)‐5.6% Promenade TIF 298,387                        263,447                      (34,941)‐11.7% Water 3,614,863                     6,143,917                    2,529,054 70.0% Sports Core 576,566                        1,527,616                    951,050 165.0% Golf Surcharge 278,773                        403,786                       125,013 44.8% Self‐Insurance 87,655                          (137,744)                     (225,399)‐257.1% Garage 325,902                        309,714                      (16,188)‐5.0% Equipment Replacement 759,255                        790,852                       31,597 4.2% $45,670,868 $56,242,838 $10,571,970 23.1% 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,753,174 $7,503,224 Investments‐Corporate Bonds 8,442,010 8,149,724 Government & Agency Obligations 4,872,997 4,711,953 Certificates of Deposit 1,225,000 1,158,183 Accrued Interest 119,403 119,403 Total Pooled Investments $22,412,584 $21,642,488 Total Cash and Investments $57,133,610 $56,693,335 Monthly Treasurer's Report July 31, 2022 Monthly Treasurer's Report July 31, 2022 The table below lists the detail investment holdings at J.P. Morgan Securities as of 07/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 447,665 3,664 Oakland Univ Mich #673588HJ1 04/29/20 03/01/24 5.000% 1.650% 310,426 309,181 3,688 Philadelphia PA GO Ref #717813SW0 05/05/20 08/01/22 5.000% 1.820% 390,083 390,000 6,297 University of CA #91412HFK4 07/16/20 05/15/23 0.628% 0.628% 25,000 24,512 (0) Cook, Kane, Lake, & McHenry #216181GL5 10/29/2020 12/15/2022 4.000% 0.300% 1,039,404 1,034,953 6,888 Miami‐Dade Cnty #59333NN90 11/16/2020 12/15/2022 0.375% 0.430% 734,045 722,035 911 Hamilton NY #407741MC8 1/21/2021 5/1/2023 1.000% 0.550% 205,696 201,501 512 Southern Cal Pub Pwr #84247PHZ7 1/25/2021 4/1/2024 3.608% 0.500% 1,059,273 1,005,810 2,806 Hillsborough Cnty FL #43232VV3 3/11/2021 7/1/2024 1.815% 0.770% 509,942 485,780 681 Port Auth of NY and NJ #73358WAH7 4/15/2021 12/1/2024 5.859% 0.600%560,949 529,190 4,720 City of Atlanta GA Water #047870SG6 4/19/2021 11/1/2024 0.616% 0.500% 250,647 236,340 376 West Contra Costa Cal Uni #9523474U3 6/17/2021 8/1/2024 0.575% 0.575% 500,000 473,050 1,430 New York NY City #64971XA40 10/7/2021 11/1/2024 0.450% 0.620% 711,311 668,504 795 NY Urban Dev Corp #650036AR7 11/5/2021 3/15/2023 0.720% 0.451% 500,843 491,555 1,350 Colorado Brdg Enterprise #19633SAZ6 11/24/2021 12/31/2023 0.923% 0.844% 500,554 483,150 603 Total Municipal Bonds $7,753,174 $7,503,224 $34,721 Corporate Bonds: PNC Bank #69349LAK4 12/7/2020 1/30/2023 2.950% 0.457% 1,032,753 1,018,507 15,045                 Wells Fargo #94974BFJ4 12/7/2020 2/13/2023 3.450% 0.480% 1,412,180 1,391,297 22,246 Comerica Bank #200340AS6 12/23/2020 7/31/2023 3.700% 0.500% 515,986 500,052 9,250 Bank of America #06048WM23 5/14/2021 5/14/2024 0.650% 0.650% 915,000 859,304 1,239 Goldman Sachs #38141GXE9 7/27/2021 2/20/2024 3.625% 0.693% 627,144 600,930 9,667 Goldman Sachs #38150AGU3 7/28/2021 7/28/2023 0.550% 0.550% 655,000 637,070 30 Morgan Stanley #61746BDQ6 7/28/2021 4/29/2024 3.875% 0.547% 1,057,675 1,008,214 9,903 Citigroup #17329UEH0 11/18/2021 11/18/2024 1.000% 1.149% 1,000,000 932,326 2,000 Bank New York Mellon #06406RAG2 1/25/2022 4/28/2023 3.500% 0.810% 713,914 701,972 6,261 Comerica Bank #200340AS6 1/25/2022 7/31/2023 3.700% 1.200% 512,358 500,052 9,250 Total Corporate Bonds $8,442,010 $8,149,724 $84,890 Government & Agency Obligations: *Government National Mtg Assn #38381WV96 08/06/19 07/20/54 2.250% 2.293% 99,294 89,999 6 *Government National Mtg Assn #38380BNV3 12/05/19 06/20/46 2.000% 2.112% 280,414 288,364 347 Federal Home Loan Bank #3130AMVU3 06/29/21 06/29/26 0.500% 0.500% 500,000 471,921 208 *Government National Mtg Assn #38383DWC8 12/14/2021 11/20/2056 1.250% 1.379% 854,763 730,991 991 Federal Home Loan Bank #313381BR5 2/25/2022 12/9/2022 1.875% 0.900%858,002 852,005 2,227 US Treasury #912796X61 6/8/2022 12/8/2022 1.670% 1.670% 2,280,523 2,278,673 3,082 Total Government & Agency Obligations: $4,872,997 $4,711,953 $6,861 Certificates of Deposit: Goldman Sachs 38149MXG3 07/28/21 07/29/24 0.550% 0.550% 245,000 231,765 17                        Sallie Mae #795451AD5 07/28/21 07/29/24 0.600% 0.600% 245,000 232,001 18                        Texas Exchange Bk #88241TLS7 07/30/21 07/30/24 0.500% 0.500% 245,000 231,510 512                      Toyota Financial #89235MLF6 08/05/21 8/5/2024 0.550% 0.550% 245,000 231,703 655 UBS Bank #90348JT42 09/22/21 9/23/2024 0.650% 0.650% 245,000 231,204 28 Total Certificates of Deposits $1,225,000 $1,158,183 $1,230 Total J.P.Morgan Securities $22,293,181 $21,523,085 $127,702 *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 July 31, 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