Loading...
01 - January 2022 Monthly Financial ReportVILLAGE OAK BROOK OF MONTHLY FINANCIAL REPORTS JANUARY 2022 Cash and Investments by Fund:Total Cash and Cash Pooled Cash and Fund Equivalents Investments Investments % By Fund General Corporate $13,096,771 $13,977,303 $27,074,074 57.0% Hotel/Motel Tax 973,615 822,393 1,796,008 3.8% Motor Fuel Tax 1,168,634 14,311 1,182,945 2.5% Infrastructure 6,731,909 4,195,246 10,927,155 23.0% Promenade TIF 55,248 - 55,248 0.1% Water 641,830 3,497,448 4,139,278 8.7% Sports Core 496,115 - 496,115 1.0% Golf Surcharge 278,770 - 278,770 0.6% Self-Insurance 383,769 - 383,769 0.8% Garage 336,834 - 336,834 0.7% Equipment Replacement 445,865 379,378 825,243 1.7% Total $24,609,360 $22,886,079 $47,495,439 100.0% Change in Cash and Investments by Fund : Balance at Balance at Year-to-Date Year-to-Date Fund January 1, 2022 January 31, 2022 Change ($)Change (%) General Corporate $25,941,144 $27,074,074 $1,132,930 4.4% Hotel/Motel Tax 1,754,745 1,796,008 41,263 2.4% Motor Fuel Tax 1,153,550 1,182,945 29,395 2.5% Infrastructure 10,880,028 10,927,155 47,127 0.4% Promenade TIF 298,387 55,248 (243,139)-81.5% Water 3,614,863 4,139,278 524,415 14.5% Sports Core 576,566 496,115 (80,451)-14.0% Golf Surcharge 278,773 278,770 (3)0.0% Self-Insurance 87,655 383,769 296,114 N/A Garage 325,902 336,834 10,932 3.4% Equipment Replacement 759,255 825,243 65,988 8.7% $45,670,868 $47,495,439 $1,824,571 4.0% Book Bank/Market Value Value Cash and Cash Equivalents: Pooled Checking $1,584,080 $2,245,142 Sports Core Checking 782,202 780,528 Pooled IPTIP 22,036,411 22,036,411 Water E-Pay IPTIP 206,667 186,160 $24,609,360 $25,248,241 Pooled Investments: Investments-Municipal Bonds $9,803,911 $9,712,697 Investments-Corporate Bonds 9,025,415 8,900,431 Government & Agency Obligations 1,981,845 1,925,688 Certificates of Deposit 1,960,000 1,944,786 Accrued Interest 114,908 114,908 Total Pooled Investments $22,886,079 $22,598,510 Total Cash and Investments $47,495,439 $47,846,751 For January, total interest revenue is $11,900. The total investment yield for the portfolio is: Pooled Investments Illinois Funds Total Last 12 months yield 1.08%0.04%0.58% The weighted average yield of the current investment portfolio is 0.85%. The IL Funds January average daily rate was 0.076%. Monthly Treasurer's Report January 31, 2022 Monthly Treasurer's Report January 2022 The table below lists the detail investment holdings at J.P. Morgan Securities as of 1/31/22: Month End VOB Settlement Maturity Coupon Yield Book Market Accrued Type Date Date Rate Rate Value Value Interest Municipal Bonds: Bloomingdale Mich Pub Sch Dist #094383FS0 04/26/16 05/01/22 2.710%2.150%$500,629 $502,660 $3,349 Brownsville TX #16405ST9 12/19/19 02/15/22 2.050%2.000%555,001 555,322 5,088 Laredo TX Waterworks #517039VW0 12/19/19 03/01/24 2.230%2.230%455,000 462,562 4,171 Oakland Univ Mich #673588HJ1 04/29/20 03/01/24 5.000%1.650%315,091 318,231 6,146 Philadelphia PA GO Ref #717813SW0 05/05/20 08/01/22 5.000%1.820%396,177 398,806 9,547 Maryland St DOT #574204WG4 05/06/20 06/15/22 4.350%1.200%263,077 263,783 1,329 University of CA #91412HFK4 07/16/20 05/15/23 0.628%0.628%25,000 24,864 33 New Jersey St #646039UD7 09/20/20 06/01/22 5.000%0.600%481,965 481,835 3,892 Rio Rancho NM #767175HM7 10/14/2020 5/15/2022 5.000%0.350%187,496 187,442 1,927 Cook, Kane, Lake, & McHenry #216181GL5 10/29/2020 12/15/2022 4.000%0.300%1,057,980 1,055,689 5,232 Miami-Dade Cnty #59333NN90 11/16/2020 12/15/2022 0.375%0.430%734,527 728,944 903 Hamilton NY #407741MC8 1/21/2021 5/1/2023 1.000%0.550%206,151 203,745 501 Southern Cal Pub Pwr #84247PHZ7 1/25/2021 4/1/2024 3.608%0.500%1,074,697 1,051,090 2,806 Hillsborough Cnty FL #43232VV3 3/11/2021 7/1/2024 1.815%0.770%512,516 501,160 681 Port Auth of NY and NJ #73358WAH7 4/15/2021 12/1/2024 5.859%0.600%573,874 557,350 4,720 City of Atlanta GA Water #047870SG6 4/19/2021 11/1/2024 0.616%0.500%250,792 243,230 368 West Contra Costa Cal Uni #9523474U3 6/17/2021 8/1/2024 0.575%0.575%500,000 487,825 1,781 New York NY City #64971XA40 10/7/2021 11/1/2024 0.450%0.620%711,682 692,649 787 NY Urban Dev Corp #650036AR7 11/5/2021 3/15/2023 0.720%0.451%501,509 498,005 1,350 Colorado Brdg Enterprise #19633SAZ6 11/24/2021 12/31/2023 0.923%0.844%500,747 497,505 397 Total Municipal Bonds $9,803,911 $9,712,697 $55,008 Corporate Bonds: American Express #025816CD9 05/05/20 05/20/22 2.750%1.290%$502,238 $502,225 $2,569 PNC Bank #69349LAK4 12/7/2020 1/30/2023 2.950%0.457%1,045,235 1,038,013 - Wells Fargo #94974BFJ4 12/7/2020 2/13/2023 3.450%0.480%1,432,358 1,424,381 22,246 Comerica Bank #200340AS6 12/23/2020 7/31/2023 3.700%0.500%523,858 515,783 9,250 Bank of America #06048WM23 5/14/2021 5/14/2024 0.650%0.650%915,000 892,809 1,238 Goldman Sachs #38141GXE9 7/27/2021 2/20/2024 3.625%0.693%635,824 620,502 9,667 Goldman Sachs #38150AGU3 7/28/2021 7/28/2023 0.550%0.550%655,000 638,215 30 Morgan Stanley #61746BDQ6 7/28/2021 4/29/2024 3.875%0.547%1,074,116 1,044,164 9,903 Citigroup #17329UEH0 11/18/2021 11/18/2024 1.000%1.149%1,000,000 988,936 2,000 Bank New York Mellon #06406RAG2 1/25/2022 4/28/2023 3.500%0.810%723,261 719,620 6,261 Comerica Bank #200340AS6 1/25/2022 7/31/2023 3.700%1.200%518,525 515,783 (9,250) Total Corporate Bonds $9,025,415 $8,900,431 $53,914 Government & Agency Obligations: *Government National Mtg Assn #38379UEM4 02/29/16 02/16/51 2.300%2.245%$15,681 $2,712 $328 *Government National Mtg Assn #38381WV96 08/06/19 07/20/54 2.250%2.293%147,769 150,875 128 *Government National Mtg Assn #38380BNV3 12/05/19 06/20/46 2.000%2.112%340,706 339,649 429 Federal Home Loan Bank #3130AMVU3 06/29/21 06/29/26 0.500%0.500%500,000 489,819 208 *Government National Mtg Assn #38383DWC8 12/14/2021 11/20/2056 1.250%1.379%977,689 942,633 1,015 Total Government & Agency Obligations:$1,981,845 $1,925,688 $2,108 Certificates of Deposit: Bank Leumi #063248KQ0 03/31/20 03/31/22 1.250%1.250%$245,000 $245,462 $1,021 Capital One Natl Assn #14042TCZ8 04/01/20 04/01/22 1.350%1.350%245,000 245,510 1,089 Synchrony Bank #87164WZN1 04/03/20 04/04/22 1.350%1.350%245,000 245,535 1,071 Goldman Sachs 38149MXG3 07/28/21 07/29/24 0.550%0.550%245,000 241,626 6 Sallie Mae #795451AD5 07/28/21 07/29/24 0.600%0.600%245,000 241,927 6 Texas Exchange Bk #88241TLS7 07/30/21 07/30/24 0.500%0.500%245,000 241,309 - Toyota Financial #89235MLF6 08/05/21 8/5/2024 0.550%0.550%245,000 241,578 655 UBS Bank #90348JT42 09/22/21 9/23/2024 0.650%0.650%245,000 241,839 30 Total Certificates of Deposits $1,960,000 $1,944,786 $3,878 Total J.P.Morgan Securities $22,771,171 $22,483,602 $114,908 *This is a mortgage backed security that receives principal payments each month based on mortgage repayments. Monthly principal payments will vary and the investment balance may be repaid before the maturity date. VILLAGE OF OAK BROOK Monthly Treasurer's Report January 31, 2022 Cash & Investments by Fund - Total $47.5 million Cash & Investments by Type - Total $47.5 million Checking Illinois Funds Certificates of Deposit Municipal Bonds Corporate Bonds Government & Agency Obligations Accrued Interest General Corporate 57.0% Hotel/Motel Tax 3.8%Motor Fuel Tax 2.5% Infrastructure 23.0% Promenade TIF 0.1% Water 8.7% Sports Core 1.0% Golf Surcharge 0.6% Self-Insurance 0.8% Garage 0.7% Equipment Replacement 1.7% Checking, $2.4 Illinois Funds, $22.2 Certificates of Deposit, $2.0 Municipal Bonds, $9.8 Corporate Bonds, $9.0 Government & Agency Obligations, $2.0 Accrued Interest, $0.1 in millions YTD YTD Net Fund Budgeted YTD YTD Increase Increase Governmental Funds Revenues Expenditures (Decrease)(Decrease) General Fund (Major Fund)2,574,675$ 1,743,624$ 831,051$ (54,905)$ Main operating fund of the Village. Hotel Fund (Major Fund)92,288$ 16,900$ 75,388$ 39,320$ Collects and spends resources from the 3% hotel/motel tax. Motor Fuel Tax Fund 29,395$ -$ 29,395$ 23,125$ Collects and spends resources from the State motor fuel tax. Infrastructure Fund (Major Fund)613,064$ 175,427$ 437,637$ 190,465$ Accounts for construction and maintenance of roadways, drainage, and safety path systems. Promenade TIF Fund (Major Fund)11$ 243,150$ (243,139)$ (235,650)$ Accounts for the revenues and expenditures restricted to the Tax Increment Financing (TIF) district located at 22nd St. and Meyers Rd. Enterprise Funds Water Fund (Major Fund)1,045,222$ 97,255$ 947,967$ 485,540$ Collects user fees for the distribution of water and maintenance of infrastructure. Sports Core Fund (Major Fund)7,829$ 82,832$ (75,003)$ (109,750)$ Accounts for revenues and expenses relating to administration, programs, food and beverage operations, and golf course. Golf Surcharge Fund (3)$ -$ (3)$ -$ Accounts for the collection of the $3 per round golf surcharge. Internal Service Funds Self Insurance Fund 307,568$ 27,019$ 280,549$ 21,350$ Accounts for the Village's health insurance costs and the related contributions from the Village, employees, retirees, and other agencies. Garage Fund 51,792$ 54,852$ (3,060)$ (7,135)$ Accounts for the maintenance of the Village's vehicle fleet and the related departmental reimbursements. Equipment Replacement Fund 69,946$ 3,957$ 65,989$ 22,710$ 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 January 31, 2022 Village of Oak Brook Monthly Financial Report – Fund Narrative For the Period Ending January 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 fun that met the 10% test is at least 5% of the corresponding total for all funds combined. This report is prepared on a cash basis of accounting, meaning transactions are recognized only when cash is increased or decreased. Transactions for each month are compared to amounts from the Village’s annual budget, which was also prepared using the cash basis of accounting. For the Village’s enterprise funds (Water and Sports Core), a reconciliation is included to display results on a full accrual basis, which is how information is presented in the Village’s annual Comprehensive Annual Financial Report. 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 January 2022 are $498,232, or 24.6%, higher than last January and $554,103, or 28.1%, over budget to date. The main drivers for this are: o Sales tax revenue, the General Fund’s largest revenue source, is up $287,652 from last year and $394,904 over budget. January 2022 collections came in at the highest level in the past five years. o Other Intergovernmental Tax revenue is up $67,680 from last year and $72,071 over budget. Receipts from Income Tax and Replacement Tax came in higher than anticipated in January. o Telecommunications/Utility Tax revenue is up $92,086 from last year and $98,784 over budget. This is due to receiving the December 2021 electricity tax return in early January 2022; therefore, an extra payment is recorded in January.  Total expenditures through January 2022 are $289,135, or 14.3%, lower than last year and $332,028, or 16.1%, under budget to date. The main drivers for this are: o Personnel expenditures are down $115,462 from last year and $77,403 under budget. The decrease is due to vacant positions and a delay in full public safety pension funding. o Operation and Contract expenditures are down $183,877 from last year and $176,271 under budget. This relates to the timing of invoices received and paid. Expenditures are expected to occur as planned later in 2022. Hotel Tax Fund  Total revenues through January 2022 are $57,750, or 167.2%, higher than last year and $46,038, or 99.5%, over budget to date. The main drivers for this are: o Hotel tax revenue is up $60,963 from last year and $47,277 over budget. Hotel stays continue to recover from the effects of COVID-19 on the travel industry.  Total expenditures through January 2022 are $10,000 higher than last year and $9,970 over budget. The only expenditures to date relate to sponsorships for the Oak Brook Magazine. Infrastructure Fund  Total revenues through January 2022 are up $79,467, or 15.7%, from last year and $111,326, or 23.4%, over budget. The main drivers for this are: o Non-home rule sales tax revenue is up $80,376 from last year and $111,406 over budget. January 2022 collections came in at the highest level in the past five years.  Total expenditures through January 2022 are down $66,297, or 28.6%, from last year and $135,852, or 45.1%, under budget to date. The main drivers for this are: o Personnel expenditures are up $12,068 from last year and $13,625 over budget. The increase relates to additional snow overtime this year compared to last. o Operation and contract expenditures are down $53,239 from last year and $120,933 under budget. Expenditures are under budget due to the timing of engineering and other miscellaneous payments. Promenade TIF Fund  Total revenues through January 2022 are even with last year and $7,489, or 99.9%, under budget. Revenues are under budget due to the timing of information to record the TIF sale tax transfer.  Total expenditures through January 2022 are up $14,900 from last year and even with budget. The increase relates to more principal paid towards the TIF note compared to last year. Water Fund  Total revenues through January 2022 are up $152,658, or 17.1%, from last year and $125,557, or 13.7%, over budget. The main drivers for this are: o Water sales revenue is up $110,939 from last year and $96,293 over budget. Water gallons sold has been slightly more than projected so far this year.  Total expenditures through January 2022 are down $60,966, or 49.5%, from last year and $336,861, or 84.4%, under budget. The main drivers for this are: o Operation and contract expenditures are down $39,535 from last year and $323,306 under budget. Expenditures are under budget due to the timing of invoices paid and DuPage Water Commission water purchased being less than expected. Sports Core Fund  Total revenues through January 2022 are down $10,461, or 57.2%, from last year and $471, or 5.7%, under budget to date. In January, only miscellaneous revenue sources have been collected and recorded. Memberships and user fees are expected to begin in February or March.  Total expenditures through January 2022 are down $43,391, or 36.2%, from last year and $35,211, or 31.5%, under budget to date. Activity in the Sports Core Fund has been minimal in January. Expenditures are expected to increase in the coming month as preparation for the season begins. 1/31/22 1/31/22 1/31/21 1/31/22 YTD % of YTD 2022 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Sales Tax 1,152,252$ 1,439,904$ 1,045,000$ 137.8%13,200,000$ 287,652$ Other Intergovernmental Tax*163,341 231,021 158,950 145.3%1,618,400 67,680 Telecommunications/Utility Tax 481,698 573,784 475,000 120.8%5,595,000 92,086 Grants 10,000 264 - N/A 15,000 (9,736) Licenses and Permits 55,500 47,123 149,300 31.6%2,007,510 (8,377) Charges for Services 62,782 212,553 82,810 256.7%1,154,900 149,771 Fines and Penalties 14,909 6,062 11,835 51.2%142,000 (8,847) Administrative Towing Fees 8,014 4,000 2,085 191.8%25,000 (4,014) Investment Interest 18,384 7,214 12,000 60.1%144,000 (11,170) Franchise Fees - - - 0.0%198,000 - Miscellaneous Income 62,461 5,648 36,490 15.5%478,270 (56,813) Total Operating Revenues 2,029,341$ 2,527,573$ 1,973,470$ 128.1%24,578,080$ 498,232$ OPERATING EXPENDITURES Personnel 1,547,014$ 1,431,552$ 1,508,955$ 94.9%19,596,700$ (115,462)$ Materials and Supplies 22,769 33,004 49,060 67.3%541,780 10,235 Operation and Contract 451,646 267,769 444,040 60.3%3,584,020 (183,877) Other Expenditures 2,173 2,142 2,250 95.2%9,000 (31) Capital Outlay - - 62,190 0.0%1,292,350 - Total Operating Expenditures 2,023,602$ 1,734,467$ 2,066,495$ 83.9%25,023,850$ (289,135)$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 5,739$ 793,106$ (93,025)$ (445,770)$ 787,367$ INTERFUND TRANSACTIONS Reimbursements From Other Funds 49,473$ 47,102$ 47,100$ 100.0%565,220$ (2,371)$ Reimbursements To Other Funds (8,824) (9,157) (8,980) 102.0%(109,880) (333) Total Interfund Transactions 40,649$ 37,945$ 38,120$ 99.5%455,340$ (2,704)$ NET FUND INCREASE (DECREASE)46,388$ 831,051$ (54,905)$ 9,570$ 784,663$ *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 January 31, 2022 Total Total Revenues Expenditures 1/31/22 Actual 2,527,573$ 1,734,467$ 1/31/21 Actual 2,029,341$ 2,023,602$ % Change From Last Year 24.6%-14.3% Major Revenues Other Telecom/Utility Licenses &Charges for Sales Tax Intergov. Tax Tax Permits Services 1/31/22 Actual 1,439,904$ 231,021$ 573,784$ 47,123$ 212,553$ 1/31/21 Actual $ 1,152,252 $ 163,341 $ 481,698 $ 62,782 $ 14,909 % Change From Last Year 25.0%41.4%19.1%-24.9%1325.7% Five Year Trend Major Expenditures Materials &Operation &Other Personnel Supplies Contractual Expenditures Capital Outlay 1/31/22 Actual 1,431,552$ 33,004$ 267,769$ 2,142$ -$ 1/31/21 Actual 1,547,014$ 22,769$ 451,646$ 2,173$ -$ % Change From Last Year -7.5%45.0%-40.7%-1.4%0.0% Five Year Trend Expenditures by Department 1/31/21 1/31/22 1/31/22 1/31/22 2022 Difference Five YTD YTD YTD % of Annual Prior Year Department Actual Actual Budget Budget Budget Year Trend Legislative & General Management 244,706$ 86,832$ 306,185$ 28.4%3,002,480$ (157,874)$ Financial Services 56,793 60,460 63,580 95.1%827,030 3,667 Public Works 45,374 32,357 56,420 57.4%928,765 (13,017) Engineering & Capital Projects - - 4,000 0.0%384,000 - Library 73,072 82,152 84,325 97.4%996,145 9,080 Police 873,286 809,410 834,175 97.0%9,869,105 (63,876) Fire 633,402 596,358 635,710 93.8%7,922,040 (37,044) Development Services 96,969 66,898 82,100 81.5%1,094,285 (30,071) Total Expenditures 2,023,602$ 1,734,467$ 2,066,495$ 83.9%25,023,850$ (289,135)$ Five Year Trend For the Period Ending January 31, 2022 General Fund - Five Year Trend Village of Oak Brook Revenues Expenditures 1/31/22 1/31/22 1/31/21 1/31/22 YTD % of YTD 2022 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Hotel Tax 30,814$ 91,777$ 44,500$ 206.2%773,500$ 60,963$ Investment Interest 3,724 511 1,750 29.2%21,000 (3,213) Loan Interest - - - 0.0%6,000 - Total Operating Revenues 34,538$ 92,288$ 46,250$ 199.5%800,500$ 57,750$ EXPENDITURES Operation and Contract -$ 10,000$ 30$ 33333.3%289,985$ 10,000$ Capital Outlay - - - 0.0%- - Total Expenditures -$ 10,000$ 30$ 33333.3%289,985$ 10,000$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 34,538$ 82,288$ 46,220$ 178.0%510,515$ 47,750$ INTERFUND TRANSACTIONS Transfer Out -$ -$ -$ 0.0%(193,375)$ -$ Reimbursements to Other Funds (7,007) (6,900) (6,900) 100.0%(82,800) 107 Total Interfund Transactions (7,007)$ (6,900)$ (6,900)$ 100.0%(276,175)$ 107$ NET FUND INCREASE (DECREASE)27,531$ 75,388$ 39,320$ 234,340$ 47,857$ Note - Expenditures are recorded in program 171. Village of Oak Brook Hotel Tax Fund Financial Update For the Period Ending January 31, 2022 Total Total Revenues Expenditures 1/31/22 Actual $ 92,288 10,000$ 1/31/21 Actual $ 34,538 -$ % Change From Last Year 167.2%N/A Major Revenues Investment Hotel Tax Interest Loan Interest Miscellaneous 1/31/22 Actual $ 91,777 $ 511 -$ -$ 1/31/21 Actual $ 30,814 $ 3,724 -$ -$ % Change From Last Year 197.8%-86.3%0.0%0.0% Five Year Trend Major Expenditures Operation & Contractual Capital Outlay 1/31/22 Actual 10,000$ -$ 1/31/21 Actual -$ -$ % Change From Last Year N/A 0.0% Five Year Trend Village of Oak Brook Hotel Tax Fund - Major Sources Five Year Trend For the Period Ending January 31, 2022 Five Year Trend Revenues Expenditures 1/31/22 1/31/22 1/31/21 1/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 503,530$ 583,906$ 472,500$ 123.6%5,815,000$ 80,376$ Investment Interest 3,119 2,210 2,290 96.5%27,500 (909) Grants - - 0.0%1,089,730 - Miscellaneous - - - 0.0%1,000 - Total Operating Revenues 506,649$ 586,116$ 474,790$ 123.4%6,933,230$ 79,467$ OPERATING EXPENDITURES Personnel 110,997$ 123,065$ 109,440$ 112.4%1,292,835$ 12,068$ Materials and Supplies 22,260 2,321 30,865 7.5%226,600 (19,939) Operation and Contract 93,436 40,197 161,130 24.9%1,730,180 (53,239) Capital Outlay 5,187 - - 0.0%9,226,320 (5,187) Total Operating Expenditures 231,880$ 165,583$ 301,435$ 54.9%12,475,935$ (66,297)$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 274,769$ 420,533$ 173,355$ 242.6%(5,542,705)$ 145,764$ INTERFUND TRANSACTIONS Transfers In -$ -$ -$ 0.0%423,375$ -$ Reimbursements From Other Funds 27,654 26,948 26,945 100.0%323,365 (706) Reimbursements To Other Funds (14,692) (9,844) (9,835) 100.1%(118,130) 4,848 Total Interfund Transactions 12,962$ 17,104$ 17,110$ 100.0%628,610$ 4,142$ NET FUND INCREASE (DECREASE)287,731$ 437,637$ 190,465$ (4,914,095)$ 149,906$ Village of Oak Brook Infrastructure Fund Financial Update For the Period Ending January 31, 2022 Total Total Revenues Expenditures 1/31/22 Actual $ 586,116 165,583$ 1/31/21 Actual $ 506,649 231,880$ % Change From Last Year 15.7%-28.6% Major Revenues Sales Tax Charges for Services Investment Interest Miscellaneous 1/31/22 Actual $ 583,906 $ - $ 2,210 $ - 1/31/21 Actual $ 503,530 $ - $ 3,119 $ - % Change From Last Year 16.0%0.0%-29.1%0.0% Five Year Trend Major Expenditures Materials &Operation & Personnel Supplies Contractual Capital Outlay 1/31/22 Actual 123,065$ 2,321$ 40,197$ -$ 1/31/21 Actual 110,997$ 22,260$ 93,436$ 5,187$ % Change From Last Year 10.9%-89.6%-57.0%-100.0% Five Year Trend Expenditures by Department 1/31/21 1/31/22 1/31/22 1/31/22 2022 Difference Five YTD YTD YTD % of Annual Prior Year Actual Actual Budget Budget Budget Year Trend Legislative & General Management 3,965$ 3,962$ 18,860$ 21.0%209,510$ (3)$ Public Works 213,786 141,932 213,570 66.5%2,380,195 (71,854) Engineering & Capital Projects 14,129 19,689 69,005 28.5%9,886,230 5,560 Total Expenditures 231,880$ 165,583$ 301,435$ 54.9%12,475,935$ (66,297)$ Five Year Trend Village of Oak Brook Infrastructure Fund - Major Sources Five Year Trend For the Period Ending January 31, 2022 Revenues Expenditures 1/31/22 1/31/22 1/31/21 1/31/22 YTD % of YTD 2022 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Sales Tax -$ -$ 7,500$ 0.0%90,000$ -$ Real Estate Tax - - - 0.0%405,000 - Investment Interest 11 11 - N/A 50 - Total Operating Revenues 11$ 11$ 7,500$ 0.1%495,050$ -$ EXPENDITURES Operation and Contract -$ -$ -$ 0.0%3,900$ -$ Other Expenditures 228,250 243,150 243,150 100.0%486,255 14,900 Total Expenditures 228,250$ 243,150$ 243,150$ 100.0%490,155$ 14,900$ NET FUND INCREASE (DECREASE)(228,239)$ (243,139)$ (235,650)$ 4,895$ (14,900)$ Note - Expenditures are recorded in program 283. Village of Oak Brook Promenade TIF Fund Financial Update For the Period Ending January 31, 2022 Total Total Revenues Expenditures 1/31/22 Actual $ 11 243,150$ 1/31/21 Actual $ 11 228,250$ % Change From Last Year 0.0%6.5% Major Revenues Real Estate Investment Sales Tax Tax Interest 1/31/22 Actual -$ $ - $ 11 1/31/21 Actual -$ $ - $ 11 % Change From Last Year 0.0%0.0%0.0% Five Year Trend Major Expenditures Operation &Other Contractual Expenditures 1/31/22 Actual -$ 243,150$ 1/31/21 Actual -$ 228,250$ % Change From Last Year 0.0%6.5% Five Year Trend Village of Oak Brook Promenade TIF Fund - Major Sources Five Year Trend For the Period Ending January 31, 2022 Five Year Trend Revenues Expenditures 1/31/22 1/31/22 1/31/21 1/31/22 YTD % of YTD 2022 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Plan Review Fees -$ 150$ 85$ 176.5%1,000$ 150$ Building/Inspection Fees - 150 415 36.1%5,000 150 Water Sales 887,854 998,793 902,500 110.7%10,484,500 110,939 Unmetered Sales - 38,979 4,165 935.9%50,000 38,979 Water Connection Fees - 4,370 6,250 69.9%75,000 4,370 Meter Charges - 1,040 1,250 83.2%15,000 1,040 Special Services - - - 0.0%25,000 - Investment Interest 4,974 1,643 2,500 65.7%30,000 (3,331) Miscellaneous (264) 97 2,500 3.9%30,000 361 Total Operating Revenues 892,564$ 1,045,222$ 919,665$ 113.7%10,715,500$ 152,658$ OPERATING EXPENDITURES Personnel 59,194$ 36,523$ 51,065$ 71.5%647,620$ (22,671)$ Materials and Supplies 6,067 3,413 6,320 54.0%69,650 (2,654) Operation and Contract 57,919 18,384 341,690 5.4%5,400,625 (39,535) Capital Outlay - 3,894 - N/A 3,925,000 3,894 Total Expenditures 123,180$ 62,214$ 399,075$ 15.6%10,042,895$ (60,966)$ Surplus (Deficit) of Revenues Over Expenditures 769,384$ 983,008$ 520,590$ 188.8%672,605$ 213,624$ INTERFUND TRANSACTIONS Reimbursements To Other Funds (37,542) (35,041)$ (35,050)$ 100.0%(420,490)$ 2,501$ Total Interfund Transactions (37,542)$ (35,041)$ (35,050)$ 100.0%(420,490)$ 2,501$ Fund Increase/(Decrease) - Budgetary Basis 731,842$ 947,967$ 485,540$ 195.2%252,115$ 216,125$ ADUSTMENTS TO GAAP BASIS* Remove Capital Outlay -$ 3,894$ Depreciation Expense (45,725) (47,917) IMRF Pension Expense 2,472 (3,750) OPEB Expense 2,304 (2,500) Total GAAP Adjustments (40,950)$ (50,273)$ Fund Increase/(Decrease) - GAAP Basis 690,892$ 897,694$ *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 January 31, 2022 Total Total Revenues Expenditures 1/31/22 Actual $ 1,045,222 62,214$ 1/31/21 Actual $ 892,564 123,180$ % Change From Last Year 17.1%-49.5% Unmetered Water Water Sales Sales Connection Fees Meter Charges Miscellaneous 1/31/22 Actual $ 998,793 $ 38,979 $ 4,370 $ 1,040 $ 97 1/31/21 Actual $ 887,854 $ - $ - $ - $ (264) % Change From Last Year 12.5%N/A N/A N/A -136.7% Five Year Trend Materials &Operation &Other Personnel Supplies Contractual Expenditures Capital Outlay 1/31/22 Actual 36,523$ 3,413$ 18,384$ -$ 3,894$ 1/31/21 Actual 59,194$ 6,067$ 57,919$ -$ -$ % Change From Last Year -38.3%-43.7%-68.3%0.0%N/A Five Year Trend Expenditures by Department 1/31/21 1/31/22 1/31/22 1/31/22 2022 Difference Five YTD YTD YTD % of Annual Prior Year Actual Actual Budget Budget Budget Year Trend Public Works 123,180$ 62,214$ 399,075$ 15.6%6,067,895$ (60,966)$ Engineering & Capital Projects - - - #DIV/0!3,975,000 - Total Expenditures 123,180$ 62,214$ 399,075$ 15.6%10,042,895$ (60,966)$ Five Year Trend Village of Oak Brook Water Fund - Major Sources Five Year Trend For the Period Ending January 31, 2022 Revenues Expenditures Village of Oak Brook Monthly Operating Statement Sports Core Fund Consolidated Presentation For the Period Ending January 31, 2022 1/31/22 1/31/22 1/31/22 YTD % of YTD 2022 1/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 -$ -$ -$ -$ -$ -$ 0.0%801,750$ 5,700$ (5,700)$ Greens Fees - - - - - - 0.0%1,145,000 - - Pro Shop Sales - - - 4,496 4,496 2,220 202.5%210,000 2,570 1,926 Golf Lessons - - - - - - 0.0%50,000 - - Driving Range Fees - - - - - - 0.0%300,000 550 (550) Rentals - - 728 (17) 711 6,000 11.9%993,775 2,466 (1,755) Programs/User Fees - - - - - - 0.0%15,500 - - Food Sales - - - 497 497 - N/A 286,000 - 497 Beverage Sales - - - 2,070 2,070 - N/A 490,000 - 2,070 Taste of Oak Brook - - - - - - 0.0%120,000 - - Grants - - - - - - 0.0%- - - Other Revenue 50 - - 5 55 80 68.8%8,000 7,004 (6,949) Total Operating Revenues 50$ -$ 728$ 7,051$ 7,829$ 8,300$ 94.3%4,420,025$ 18,290$ (10,461)$ OPERATING EXPENDITURES Personnel 68$ -$ 9,769$ 52,991$ 62,828$ 71,245$ 88.2%1,671,380$ 65,174$ (2,346)$ Materials & Supplies - - - 4,870 4,870 6,815 71.5%718,900 10,345 (5,475) Operational & Contractual 157 15 433 8,241 8,846 33,695 26.3%942,765 44,416 (35,570) Other - - - - - - 0.0%- - - Capital - - - - - - 0.0%466,750 - - Total Operating Expenditures 225$ 15$ 10,202$ 66,102$ 76,544$ 111,755$ 68.5%3,799,795$ 119,935$ (43,391)$ B&T Administration Overhead Allocation*873$ -$ (873)$ -$ -$ -$ 0.0%-$ -$ -$ Operating Revenues Over (Under) Expenditures 698$ (15)$ (10,347)$ (59,051)$ (68,715)$ (103,455)$ 66.4%620,230$ (101,645)$ 32,930$ INTERFUND TRANSACTIONS Transfer From Golf Surcharge Fund -$ -$ -$ -$ -$ -$ 0.0%150,000$ -$ -$ Reimbursement From Infrastructure Fund - - - - - - 0.0%- 2,667 (2,667) Reimbursement From Water Fund - - - - - - 0.0%- 667 (667) Reimbursement To General Fund (1,572) - - (4,716) (6,288) (6,295) 99.9%(75,455) (5,241) (1,047) Total Interfund Transactions (1,572)$ -$ -$ (4,716)$ (6,288)$ (6,295)$ 99.9%74,545$ (1,907)$ (4,381)$ Total Revenues Over (Under) Expenditures - Budgetary Basis (874)$ (15)$ (10,347)$ (63,767)$ (75,003)$ (109,750)$ 694,775$ (103,552)$ 28,549$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay -$ -$ -$ -$ -$ -$ Depreciation Expense (10,622) (1,152) (5,217) (19,661) (36,651) (36,346) IMRF Pension Expense (83) - (167) (1,917) (2,167) 5,500 OPEB Expense - - (250) (1,925) (2,175) (2,134) Total GAAP Adjustments (10,705)$ (1,152)$ (5,633)$ (23,503)$ (40,993)$ (32,980)$ Fund Increase/(Decrease) - GAAP Basis (11,579)$ (1,167)$ (15,980)$ (87,270)$ (115,996)$ (136,532)$ *Overhead allocation is comprised of salaries, business forms, liability insurance, building & grounds maintenance and bank service fees in Program 811 - Sports Core General Operations distributed to various Sports Core Programs on a % basis. Total Direct Total Direct Revenues Expenditures 1/31/22 Actual $ 7,829 76,544$ 1/31/21 Actual $ 18,290 119,935$ % Change From Last Year -57.2%-36.2% Driving Program/ Memberships Greens Fees Range Fees Rentals User Fees 1/31/22 Actual $ - $ - $ - $ 711 -$ 1/31/21 Actual $ 5,700 $ - $ 550 $ 2,466 -$ % Change From Last Year -100.0%0.0%-100.0%-71.2%0.0% Five Year Trend Materials &Operation &Other Personnel Supplies Contractual Expenditures Capital Outlay 1/31/22 Actual 62,828$ 4,870$ 8,846$ -$ -$ 1/31/21 Actual 65,174$ 10,345$ 44,416$ -$ -$ % Change From Last Year -3.6%-52.9%-80.1%0.0%0.0% Five Year Trend Revenues by Department 1/31/21 1/31/22 1/31/22 1/31/22 2022 Difference Five YTD YTD YTD % of Annual Prior Year Actual Actual Budget Budget Budget Year Trend B&T Recreation Operations 6,903$ 50$ 80$ 62.5%521,450$ (6,853)$ Open Field Operations 2,500 - 1,000 0.0%375,000 (2,500) B&T Clubhouse Operations - 728 5,000 14.6%351,275 728 Golf Club 8,887 7,051 2,220 317.6%3,172,300 (1,836) Total Revenues 18,290$ 7,829$ 8,300$ 94.3%4,420,025$ (10,461)$ Expenditures by Department 1/31/21 1/31/22 1/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 13,093$ 225$ 15,190$ 1.5%567,180$ (12,868)$ Open Field Operations 525$ 15$ 2,085$ 0.7%250,660$ (510)$ B&T Clubhouse Operations 9,884 10,202 16,530 61.7%298,200 318 Golf Club 96,433 66,102 77,950 84.8%2,683,755 (30,331) Total Expenditures 119,935$ 76,544$ 111,755$ 68.5%3,799,795$ (43,391)$ Five Year Trend Village of Oak Brook Sports Core Fund - Major Sources Five Year Trend For the Period Ending January 31, 2022 Revenues Expenditures Village of Oak Brook Monthly Operating Statement Bath & Tennis Club Recreation Operations For the Period Ending January 31, 2022 1/31/22 1/31/22 822 1/31/22 YTD % of YTD 2022 1/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 -$ -$ -$ -$ -$ -$ 0.0%448,950$ -$ -$ Programs/User Fees - - - - - - 0.0%15,500 - - Food Sales - - - - - - 0.0%36,000 - - Beverage Sales - - - - - - 0.0%20,000 - - Grants - - - - - - 0.0%- - - Other Revenue 50 - - - 50 80 62.5%1,000 6,903 (6,853) Total Operating Revenues 50$ -$ -$ -$ 50$ 80$ 62.5%521,450$ 6,903$ (6,853)$ OPERATING EXPENDITURES Personnel 68$ -$ -$ -$ 68$ 2,335$ 2.9%127,350$ -$ 68$ Materials & Supplies - - - - - 40 0.0%74,550 63 (63) Operational & Contractual 157 - - - 157 12,815 1.2%307,530 13,030 (12,873) Capital - - - - - - 0.0%57,750 - - Total Operating Expenditures 225$ -$ -$ -$ 225$ 15,190$ 1.5%567,180$ 13,093$ (12,868)$ B&T Administration Overhead Allocation*1,747$ (629)$ (175)$ (70)$ 873$ 8,315$ 10.5%68,810$ 3,565$ (2,692)$ Operating Revenues Over (Under) Expenditures 1,572$ (629)$ (175)$ (70)$ 698$ (6,795)$ -10.3%23,080$ (2,625)$ 3,323$ INTERFUND TRANSACTIONS Reimbursement From Infrastructure Fund -$ -$ -$ -$ -$ -$ #DIV/0!-$ 2,667$ (2,667)$ Reimbursement From Water Fund - - - - - - #DIV/0!- 667 (667) Reimbursement To General Fund (1,572) - - - (1,572) (1,570) 100.1%(18,865) (1,310) (262) Total Interfund Transactions (1,572)$ -$ -$ -$ (1,572)$ (1,570)$ 100.1%(18,865)$ 2,024$ (3,596)$ Total Revenues Over (Under) Expenditures - Budgetary Basis -$ (629)$ (175)$ (70)$ (874)$ (8,365)$ 4,215$ (601)$ (273)$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay -$ -$ -$ -$ -$ -$ Depreciation Expense (1,133) (9,167) (224) (98) (10,622) (10,417) IMRF Pension Expense (83) - - - (83) 97 Total GAAP Adjustments (1,217)$ (9,167)$ (224)$ (98)$ (10,705)$ (10,320)$ Fund Increase/(Decrease) - GAAP Basis (1,217)$ (9,796)$ (399)$ (168)$ (11,579)$ (10,921)$ *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 January 31, 2022 1/31/22 1/31/22 1/31/22 YTD % of YTD 2022 1/31/21 Difference 815 816 YTD Amended Amended Adopted YTD Prior Polo Open Fields Total Budget Budget Budget Total Year OPERATING REVENUES Field Rentals -$ -$ -$ 1,000$ 0.0%170,000$ 2,500$ (2,500)$ Range Rentals - - - - 0.0%85,000 - - Taste of Oak Brook - - - - 0.0%120,000 - - Grants - - - - 0.0%- - - Total Operating Revenues -$ -$ -$ 1,000$ 0.0%375,000$ 2,500$ (2,500)$ OPERATING EXPENDITURES Materials & Supplies -$ -$ -$ -$ 0.0%1,500$ -$ -$ Operational & Contractual - 15 15 2,085 0.7%249,160 525 (510) Capital - - - - 0.0%- - - Total Operating Expenditures -$ 15$ 15$ 2,085$ 0.7%250,660$ 525$ (510)$ Total Revenues Over (Under) Expenditures - Budgetary Basis -$ (15)$ (15)$ (1,085)$ 124,340$ 1,975$ (1,990)$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay -$ -$ -$ -$ Depreciation Expense - (1,152) (1,152) (1,152) Total GAAP Adjustments -$ (1,152)$ (1,152)$ (1,152)$ Fund Increase/(Decrease) - GAAP Basis -$ (1,167)$ (1,167)$ 823$ *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 January 31, 2022 1/31/22 1/31/22 821 YTD % of YTD 2022 1/31/21 Difference B&T Amended Amended Adopted YTD Prior Clubhouse Budget Budget Budget Total Year OPERATING REVENUES Rentals 728$ 5,000$ 14.6%351,275$ -$ 728$ Total Operating Revenues 728$ 5,000$ 14.6%351,275$ -$ 728$ OPERATING EXPENDITURES Personnel 9,769$ 9,345$ 104.5%140,250$ 8,428$ 1,341$ Materials & Supplies - 1,675 0.0%15,350 606 (606) Operational & Contractual 433 5,510 7.9%92,600 850 (417) Capital - - 0.0%50,000 - - Total Operating Expenditures 10,202$ 16,530$ 61.7%298,200$ 9,884$ 318$ B&T Administration Overhead Allocation*(873)$ (8,315)$ 10.5%(68,810)$ (3,565)$ 2,692$ Total Revenues Over (Under) Expenditures - Budgetary Basis (10,347)$ (19,845)$ (15,735)$ (13,449)$ 3,102$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay -$ -$ Depreciation Expense (5,217) (5,217) IMRF Pension Expense (167) 517 OPEB Expense (250) (250) Total GAAP Adjustments (5,633)$ (4,950)$ Fund Increase/(Decrease) - GAAP Basis (15,980)$ (18,399)$ *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 January 31, 2022 1/31/22 1/31/22 823 831 832 833 834 1/31/22 YTD % of YTD 2022 1/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 -$ -$ -$ -$ -$ -$ -$ 0.0%352,800$ 5,700$ (5,700)$ Greens Fees - - - - - - - 0.0%1,145,000 - - Pro Shop Sales - 4,496 - - - 4,496 2,220 202.5%210,000 2,570 1,926 Golf Lessons - - - - - - 0.0%50,000 - - Driving Range Fees - - - - - - - 0.0%300,000 550 (550) Rentals - - - (17) - (17) - N/A 387,500 (34) 17 Food Sales 497 - - - - 497 - N/A 250,000 - 497 Beverage Sales 2,070 - - - - 2,070 - N/A 470,000 - 2,070 Other Revenue - 5 - - - 5 - N/A 7,000 101 (96) Total Operating Revenues 2,567$ 4,501$ -$ (17)$ -$ 7,051$ 2,220$ 317.6%3,172,300$ 8,887$ (1,836)$ OPERATING EXPENDITURES Personnel 4,434$ 31,202$ -$ -$ 17,355$ 52,991$ 59,565$ 89.0%1,403,780$ 56,746$ (3,755)$ Materials & Supplies 1,838 2,923 - 109 - 4,870 5,100 95.5%627,500 9,676 (4,806) Operational & Contractual 337 4,166 - - 3,738 8,241 13,285 62.0%293,475 30,011 (21,770) Other - - - - - - - 0.0%- - - Capital - - - - - - - 0.0%359,000 - - Total Operating Expenditures 6,609$ 38,291$ -$ 109$ 21,093$ 66,102$ 77,950$ 84.8%2,683,755$ 96,433$ (30,331)$ Operating Revenues Over (Under) Expenditures (4,042)$ (33,790)$ -$ (126)$ (21,093)$ (59,051)$ (75,730)$ 78.0%488,545$ (87,546)$ 28,495$ INTERFUND TRANSACTIONS Transfer from Golf Surcharge -$ -$ -$ -$ -$ -$ 0.0%150,000$ -$ -$ Reimbursement to General Fund - (4,716) - - - (4,716) (4,725) 99.8%(56,590) (3,931) (785) Total Interfund Transactions -$ (4,716)$ -$ -$ -$ (4,716)$ (4,725)$ 99.8%93,410$ (3,931)$ (785)$ Total Revenues Over (Under) Expenditures - Budgetary Basis (4,042)$ (38,506)$ -$ (126)$ (21,093)$ (63,767)$ (80,455)$ 581,955$ (91,477)$ 27,710$ ADUSTMENTS TO GAAP BASIS* Remove Capital Outlay -$ -$ -$ -$ -$ -$ -$ Depreciation Expense (252) (7,985) (192) (1,021) (10,213) (19,661) (19,561) IMRF Pension Expense (208) (792) (83) - (833) (1,917) 4,886 OPEB Expense (217) (1,083) - - (625) (1,925) (1,884) Total GAAP Adjustments (677)$ (9,860)$ (275)$ (1,021)$ (11,671)$ (23,503)$ (16,559)$ Fund Increase/(Decrease) - GAAP Basis (4,719)$ (48,366)$ (275)$ (1,147)$ (32,764)$ (87,270)$ (108,036)$ *Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.