Loading...
04 - April 2022 Monthly Financial ReportVILLAGE OAK BROOKOF MONTHLY FINANCIAL REPORTS APRIL 2022 Cash and Investments by Fund:Total Cash and Cash Pooled Cash and Fund Equivalents Investments Investments % By Fund General Corporate $17,222,541 $13,358,721 $30,581,262 56.7% Hotel/Motel Tax 1,477,522 417,023 $1,894,545 3.5% Motor Fuel Tax 1,326,973 14,692 $1,341,666 2.5% Infrastructure 7,957,272 4,361,344 $12,318,615 22.8% Promenade TIF 55,287 $55,287 0.1% Water 1,563,000 3,351,579 $4,914,579 9.1% Sports Core 1,274,680 $1,274,680 2.4% Golf Surcharge 285,016 $285,016 0.5% Self-Insurance 260,390 $260,390 0.5% Garage 342,626 $342,626 0.6% Equipment Replacement 420,025 238,092 $658,116 1.2% Total $32,185,332 $21,741,451 $53,926,783 100.0% Change in Cash and Investments by Fund : Balance at Balance at Year-to-Date Year-to-Date Fund January 1, 2022 April 30, 2022 Change ($)Change (%) General Corporate $25,941,144 $30,581,262 $4,640,118 17.9% Hotel/Motel Tax 1,754,745 1,894,545 139,800 8.0% Motor Fuel Tax 1,153,550 1,341,666 188,116 16.3% Infrastructure 10,880,028 12,318,615 1,438,587 13.2% Promenade TIF 298,387 55,287 (243,100)-81.5% Water 3,614,863 4,914,579 1,299,716 36.0% Sports Core 576,566 1,274,680 698,114 121.1% Golf Surcharge 278,773 285,016 6,243 2.2% Self-Insurance 87,655 260,390 172,735 197.1% Garage 325,902 342,626 16,724 5.1% Equipment Replacement 759,255 658,116 (101,139)-13.3% 45,670,868 $53,926,783 $8,255,915 18.1% Book Bank/Market Value Value Cash and Cash Equivalents: Pooled Checking $2,239,161 $2,239,161 Sports Core Checking 1,274,680 1,274,680 Pooled IPTIP 28,194,635 28,194,635 Water E-Pay IPTIP 476,856 476,856 32,185,332 $32,185,332 Pooled Investments: Investments-Municipal Bonds $9,208,187 $8,943,614 Investments-Corporate Bonds 8,482,304 8,161,623 Government & Agency Obligations 2,695,247 2,519,725 Certificates of Deposit 1,225,000 1,165,293 Accrued Interest 132,153 132,153 Total Pooled Investments $21,742,892 $20,922,408 Total Cash and Investments $53,928,224 $53,107,740 Monthly Treasurer's Report April 30, 2022 Monthly Treasurer's Report April 2022 The table below lists the detail investment holdings at J.P. Morgan Securities as of 04/30/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,000 500,000 $6,923 Laredo TX Waterworks #517039VW0 12/19/19 03/01/24 2.230%2.230%455,000 449,731 1,127 Oakland Univ Mich #673588HJ1 04/29/20 03/01/24 5.000%1.650%312,700 307,732 2,458 Philadelphia PA GO Ref #717813SW0 05/05/20 08/01/22 5.000%1.820%393,100 393,452 4,672 Maryland St DOT #574204WG4 05/06/20 06/15/22 4.350%1.200%261,037 260,941 4,156 University of CA #91412HFK4 07/16/20 05/15/23 0.628%0.628%25,000 24,536 65 New Jersey St #646039UD7 09/20/20 06/01/22 5.000%0.600%476,748 476,316 9,830 Rio Rancho NM #767175HM7 10/14/2020 5/15/2022 5.000%0.350%185,347 185,237 4,240 Cook, Kane, Lake, & McHenry #216181GL5 10/29/2020 12/15/2022 4.000%0.300%1,048,521 1,040,006 17,138 Miami-Dade Cnty #59333NN90 11/16/2020 12/15/2022 0.375%0.430%734,628 722,035 222 Hamilton NY #407741MC8 1/21/2021 5/1/2023 1.000%0.550%205,922 201,708 1,093 Southern Cal Pub Pwr #84247PHZ7 1/25/2021 4/1/2024 3.608%0.500%1,067,017 1,013,860 11,826 Hillsborough Cnty FL #43232VV3 3/11/2021 7/1/2024 1.815%0.770%511,233 485,540 2,949 Port Auth of NY and NJ #73358WAH7 4/15/2021 12/1/2024 5.859%0.600%567,408 529,820 12,044 City of Atlanta GA Water #047870SG6 4/19/2021 11/1/2024 0.616%0.500%250,721 235,658 761 West Contra Costa Cal Uni #9523474U3 6/17/2021 8/1/2024 0.575%0.575%500,000 473,150 711 New York NY City #64971XA40 10/7/2021 11/1/2024 0.450%0.620%711,981 668,203 1,600 NY Urban Dev Corp #650036AR7 11/5/2021 3/15/2023 0.720%0.451%501,175 492,865 450 Colorado Brdg Enterprise #19633SAZ6 11/24/2021 12/31/2023 0.923%0.844%500,651 482,825 1,756 Total Municipal Bonds $9,208,187 $8,943,614 $84,023 Corporate Bonds: PNC Bank #69349LAK4 12/7/2020 1/30/2023 2.950%0.457%1,038,905 1,023,800 7,522 Wells Fargo #94974BFJ4 12/7/2020 2/13/2023 3.450%0.480%1,422,084 1,397,426 10,257 Comerica Bank #200340AS6 12/23/2020 7/31/2023 3.700%0.500%519,887 503,311 4,625 Bank of America #06048WM23 5/14/2021 5/14/2024 0.650%0.650%915,000 858,489 1,239 Goldman Sachs #38141GXE9 7/27/2021 2/20/2024 3.625%0.693%631,485 601,116 4,229 Goldman Sachs #38150AGU3 7/28/2021 7/28/2023 0.550%0.550%655,000 629,273 931 Morgan Stanley #61746BDQ6 7/28/2021 4/29/2024 3.875%0.547%1,065,893 1,006,732 215 Citigroup #17329UEH0 11/18/2021 11/18/2024 1.000%1.149%1,000,000 930,983 4,500 Bank New York Mellon #06406RAG2 1/25/2022 4/28/2023 3.500%0.810%718,598 707,182 136 Comerica Bank #200340AS6 1/25/2022 7/31/2023 3.700%1.200%515,452 503,311 4,625 Total Corporate Bonds $8,482,304 $8,161,623 $38,280 Government & Agency Obligations: Government National Mtg Assn #38381WV96 08/06/19 07/20/54 2.250%2.293%99,081 95,568 26 Government National Mtg Assn #38380BNV3 12/05/19 06/20/46 2.000%2.112%318,648 303,952 379 Federal Home Loan Bank #3130AMVU3 06/29/21 06/29/26 0.500%0.500%500,000 466,872 833 Government National Mtg Assn #38383DWC8 12/14/2021 11/20/2056 1.250%1.379%917,458 797,057 993 Federal Home Loan Bank #313381BR5 2/25/2022 12/9/2022 1.875%0.900%860,060 856,274 6,234 Total Government & Agency Obligations:$2,695,247 $2,519,725 $8,466 Certificates of Deposit: Goldman Sachs 38149MXG3 07/28/21 07/29/24 0.550%0.550%245,000 233,198 348 Sallie Mae #795451AD5 07/28/21 07/29/24 0.600%0.600%245,000 233,463 380 Texas Exchange Bk #88241TLS7 07/30/21 07/30/24 0.500%0.500%245,000 232,850 310 Toyota Financial #89235MLF6 08/05/21 8/5/2024 0.550%0.550%245,000 233,071 318 UBS Bank #90348JT42 09/22/21 9/23/2024 0.650%0.650%245,000 232,712 28 Total Certificates of Deposits $1,225,000 $1,165,293 $1,384 Total J.P.Morgan Securities $21,610,739 $20,790,254 $132,153 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 April 30, 2022 Cash & Investments by Fund - Total $53.9 million Cash & Investments by Type - Total $53.9 million General Corporate 56.7% Hotel/Motel Tax 3.5%Motor Fuel Tax 2.5% Infrastructure 22.8% Promenade TIF 0.1% Water 9.1% Sports Core 2.4% Golf Surcharge 0.5% Self-Insurance 0.5% Garage 0.6%Equipment Replacement 1.2% Checking, $3.2 Illinois Funds, $28.7 Certificates of Deposit, 1.2 Municipal Bonds, $9.2 Corporate Bonds, $8.5 Government & Agency Obligations, $2.7 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)11,417,647$ 6,867,936$ 4,549,711$ 846,401$ Main operating fund of the Village. Hotel Fund (Major Fund)293,356$ 107,911$ 185,445$ 101,620$ Collects and spends resources from the 3% hotel/motel tax. Motor Fuel Tax Fund 188,455$ -$ 188,455$ 157,960$ Collects and spends resources from the State motor fuel tax. Infrastructure Fund (Major Fund)2,799,197$ 989,964$ 1,809,233$ (60,175)$ Accounts for construction and maintenance of roadways, drainage, and safety path systems. Promenade TIF Fund (Major Fund)49$ 243,150$ (243,101)$ (213,135)$ 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)2,959,963$ 1,341,455$ 1,618,508$ 788,180$ Collects user fees for the distribution of water and maintenance of infrastructure. Sports Core Fund (Major Fund)1,189,511$ 628,545$ 560,966$ 22,520$ Accounts for revenues and expenses relating to administration, programs, food and beverage operations, and golf course. Golf Surcharge Fund 6,244$ -$ 6,244$ (46,500)$ Accounts for the collection of the $3 per round golf surcharge. Internal Service Funds Self Insurance Fund 1,271,831$ 905,853$ 365,978$ 66,675$ Accounts for the Village's health insurance costs and the related contributions from the Village, employees, retirees, and other agencies. Garage Fund 207,346$ 188,698$ 18,648$ (17,760)$ Accounts for the maintenance of the Village's vehicle fleet and the related departmental reimbursements. Equipment Replacement Fund 289,460$ 391,913$ (102,453)$ (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 April 31, 2022 Village of Oak Brook Monthly Financial Report – Fund Narrative For the Period Ending April 30, 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 Annual Financial Report (CAFR). 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 April 2022 are $2,981,255, or 36.1%, higher than last April, and 2,799,309, or 33.2%, over budget to date. The main drivers for this are: o Sales tax revenue, the General Fund’s largest revenue source, is up 1,971,173 from last year and 1,851,475 over budget. April 2022 collections came in at the highest level in the past five years. o Other Intergovernmental Tax is up 327,645 from last year and $362,180 over budget. Receipts from Income Tax and Replacement Tax came in higher than anticipated in April. o The Telecommunication/Utility Tax is up $234,289 from last year and $175,088 over budget. Total expenditures through April 2022 are $59,781, or 1%, higher than last year and 904,101, or 11.69%, under budget to date. Hotel Tax Fund Total revenues through April 2022 are $152,202, or 107.8%, higher than last year and 97,856, or 50.05%, over budget to date. The main drivers for this are: o Hotel tax revenue is up $163,582 from last year and $02,970 over budget. Hotel stay continues to recover from the effects of COVID-19 on the travel industry. Total expenditures through April 2022 are $63,683 higher than last year and $14,031 over budget. Infrastructure Fund Total revenues through April 2022 are up $ $728,458, or 37.1%, from last year and $ 691,995 or 15.7%, over budget. The main drivers for this are: o Non-home rule sales tax revenue is up 732,415 from last year, and $690,680 over budget. April 2022 collections came in at the highest level in the past five years. Total expenditures through April 2022 are down $2,053,274, or 68.4%, from last year and $1,177,407 or 55.3%, under budget to date. The main drivers for this are: o Operation and contract expenditures are down $62,327 from last year and 278,170 under budget. o Capital Outlay is down $2,045,489 from last year and $970,052 under budget. Promenade TIF Fund Total revenues through April 2022 are lower than last year and $17,579 or 99.7%, under budget. Revenues are under budget due to the timing of information to record the TIF sale tax transfer. Total expenditures through April 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 April 2022 are up $385,732, or 15.0% higher than last year and 488,303, or 19.76%, over budget. The main drivers for this are: o Water sales revenue is up $ 335,911 from last year and $276,266 over budget. Water gallons sold has also been slightly more than projected so far this year. Total expenditures through April 2022 are down $1,904,084, or 61.3%, from last year and 342,019 or 22.16%, under budget. The main drivers for this are: o Personnel expenditures are down $105,798 from last year and $69,343 under budget. o Capital outlay expenditures are down $1,885,966 from last year. Sports Core Fund Total revenues through April 2022 are up $259,066 or 27.80% higher than last year and 682,746, or 174.2% over budget to date. The main drivers for this are: o Membership revenue is up $335,550 from last year and $369,625 over budget. o Rentals are up by $41,665 from last year and $136,911 over budget. Total expenditures through April 2022 are down $55,839, or 8.5%, from last year, and 88,013, or 2.32% under budget to date. The main drivers for this are: o Personnel expenditure are down $31,073 from last year and $24,562 under budget. o Operation and contract expenditures are higher $37,554 from last year and 92,847 under budget. o Capital outlay expenditures are down $55,883 from last year, and $54,054 under budget. Activity in the Sports Core Fund are expected to increase in the coming month as preparation for the season begins. 4/30/22 4/30/22 4/30/21 4/30/22 YTD % of YTD 2022 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Sales Tax 4,520,302$ 6,491,475 4,640,000$ 139.9%13,200,000$ 1,971,173$ Other Intergovernmental Tax*616,835 944,480 582,300 162.2%1,618,400 327,645$ Telecommunications/Utility Tax 1,864,799 2,099,088 1,924,000 109.1%5,595,000 234,289$ Grants - 973 2,500 100.0%15,000 973$ Licenses and Permits 692,255 692,795 607,300 114.1%2,007,510 540$ Charges for Services 267,355 760,583 351,320 216.5%1,154,900 493,228$ Fines and Penalties 55,805 28,865 47,340 61.0%142,000 (26,940)$ Administrative Towing Fees 10,079 12,000 8,340 143.9%25,000 1,921$ Investment Interest 68,527 28,883 48,000 60.2%144,000 (39,644)$ Franchise Fees 3,674 57,129 49,500 115.4%198,000 53,455$ Installment Contract Proceeds - N/A -$ Miscellaneous Income 148,353 112,967 169,330 66.7%478,270 (35,386)$ Total Operating Revenues 8,247,984$ 11,229,239$ 8,429,930$ 133.2%24,578,080$ 2,981,255$ OPERATING EXPENDITURES Personnel 5,452,544$ 5,511,354 5,869,254$ 93.9%19,596,700$ 58,810$ Materials and Supplies 124,299 133,043 212,210 62.7%541,780 8,744$ Operation and Contract 1,111,228 1,150,810 1,193,700 96.4%3,584,020 39,582$ Other Expenditures 2,173 4,290 4,500 95.3%9,000 2,117$ Capital Outlay 81,283 31,812 455,745 7.0%1,292,350 (49,471)$ Total Operating Expenditures 6,771,527$ 6,831,308$ 7,735,409$ 88.3%25,023,850$ 59,781$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 1,476,457$ 4,397,931$ 694,521$ 633.2%(445,770)$ 2,921,474$ INTERFUND TRANSACTIONS Transfers In -$ -$ -$ N/A -$ -$ Transfers Out -$ N/A -$ Reimbursements From Other Funds 197,892 188,408 188,400 100.0%565,220 (9,484)$ Reimbursements To Other Funds (35,296) (36,628) (36,520) 100.3%(109,880) (1,332)$ Sports Core Loan - N/A - -$ Total Interfund Transactions 162,596$ 151,780$ 151,880$ 99.9%455,340$ (10,816)$ NET FUND INCREASE (DECREASE)1,639,053$ 4,549,711$ 846,401$ 9,570$ 2,910,658$ 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 April 30, 2022 Total Total Revenues Expenditures 4/30/22 Actual 11,229,239$ 6,831,308$ 4/30/21 Actual 8,247,984$ 6,771,527$ Change From Last Year 36.1%0.9% Major Revenues Other Telecom/Utility Licenses &Charges for Sales Tax Intergov. Tax Tax Permits Services 4/30/22 Actual 6,491,475$ 944,480$ 2,099,088$ 692,795$ 760,583$ 4/30/21 Actual $ 4,520,302 $ 616,835 $ 1,864,799 $ 692,255 $ 267,355 Change From Last Year 43.6%53.1%12.6%0.1%184.5% Five Year Trend Major Expenditures Materials &Operation &Other Personnel Supplies Contractual Expenditures Capital Outlay 4/30/22 Actual 5,511,354$ 133,043$ 1,150,810$ 4,290$ 31,812$ 4/30/21 Actual 5,452,544$ 124,299$ 1,111,228$ 2,173$ 81,283$ Change From Last Year 1.1%7.0%3.6%97.4%-60.9% Five Year Trend Expenditures by Department 4/30/21 4/30/22 4/30/22 4/30/22 2022 Difference Five YTD YTD YTD % of Annual Prior Year Department Actual Actual Budget Budget Budget Year Trend Legislative & General Management 555,439$ 555,048$ 784,905$ 70.7%3,002,480$ (391)$ Financial Services 178,532 207,071 194,640 106.4%827,030 28,539 Public Works 223,019 157,826 183,560 86.0%928,765 (65,193) Engineering & Capital Projects 4,547 11,172 139,000 8.0%384,000 6,625 Library 206,516 233,222 239,800 97.3%996,145 26,706 Police 2,034,356 2,185,963 2,336,800 93.5%9,869,105 151,607 Fire 1,767,963 1,611,145 1,872,020 86.1%7,922,040 (156,818) Development Services 257,484 222,207 250,015 88.9%1,094,285 (35,277) Total Expenditures 5,227,856$ 5,183,655$ 6,000,740$ 86.4%25,023,850$ (44,201)$ Five Year Trend For the Period Ending April 30, 2022 General Fund - Five Year Trend Village of Oak Brook Revenues Expenditures 4/30/22 4/30/22 4/30/21 4/30/22 YTD % of YTD 2022 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Hotel Tax 127,888$ 291,470 188,500$ 154.6%773,500$ 163,582$ Investment Interest 13,266 1,887 7,000 27.0%21,000 (11,379) Loan Interest - - - N/A 6,000 - Total Operating Revenues 141,154$ 293,356$ 195,500$ 150.1%800,500$ 152,202$ EXPENDITURES Operation and Contract 16,628$ 27,615 66,280$ 41.7%289,985$ 10,987$ Capital Outlay - 52,696 - N/A - 52,696 Total Expenditures 16,628$ 80,311$ 66,280$ 121.2%289,985$ 63,683$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 124,526$ 213,045$ 129,220$ 164.9%510,515$ 88,519$ INTERFUND TRANSACTIONS Transfer Out -$ -$ -$ N/A (193,375)$ -$ Reimbursements to Other Funds (28,028) (27,600) (27,600) 100.0%(82,800) 428 Total Interfund Transactions (28,028)$ (27,600)$ (27,600)$ 100.0%(276,175)$ 428$ NET FUND INCREASE (DECREASE)96,498$ 185,445$ 101,620$ 234,340$ 88,947$ Note - Expenditures are recorded in program 171. Village of Oak Brook Hotel Tax Fund Financial Update For the Period Ending April 30, 2022 Total Total Revenues Expenditures 4/30/22 Actual $ 293,356 80,311$ 4/30/21 Actual $ 141,154 16,628$ Change From Last Year 107.8%383.0% Major Revenues Investment Hotel Tax Interest Loan Interest Miscellaneous 4/30/22 Actual $ 291,470 $ 1,887 -$ -$ 4/30/21 Actual $ 127,888 $ 13,266 -$ -$ Change From Last Year 127.9%-85.8%0.0%0.0% Five Year Trend Major Expenditures Operation & Contractual Capital Outlay 4/30/22 Actual 27,615$ 52,696$ 4/30/21 Actual 16,628$ -$ Change From Last Year 66.1%N/A Five Year Trend Village of Oak Brook Hotel Tax Fund - Major Sources Five Year Trend For the Period Ending April 30, 2022 Five Year Trend Revenues Expenditures 4/30/22 4/30/22 4/30/21 4/30/22 YTD % of YTD 2022 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Non-Home Rule Sales Tax 1,948,264$ 2,680,680 1,990,000$ 97.9%5,815,000$ 732,415$ Investment Interest 11,603 10,726 9,160 126.7%27,500 (878) Grants - - - N/A 1,089,730 - Miscellaneous 3,080 - 250 0.0%1,000 (3,080) Total Operating Revenues 1,962,948$ 2,691,405$ 1,999,410$ 134.6%6,933,230$ 728,458$ OPERATING EXPENDITURES Personnel 450,278$ 472,005$ 410,975$ 114.9%1,292,835$ 21,727$ Materials and Supplies 124,125 117,565 107,785 109.1%226,600 (6,561) Operation and Contract 354,022 291,695 569,865 51.2%1,730,180 (62,327) Other Expenditures 39,376 39,370 100.0%39,376 Capital Outlay 2,075,437 29,948 1,000,000 3.0%9,226,320 (2,045,489) Total Operating Expenditures 3,003,863$ 950,588$ 2,127,995$ 44.7%12,475,935$ (2,053,274)$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES (1,040,915)$ 1,740,817$ (128,585)$ -1353.8%(5,542,705)$ 2,781,732$ INTERFUND TRANSACTIONS Transfers In -$ -$ -$ N/A 423,375$ -$ Reimbursements From Other Funds 110,616 107,792 107,780 100.0%323,365 (2,824) Reimbursements To Other Funds (58,768) (39,376) (39,370) 100.0%(118,130) 19,392 Total Interfund Transactions 51,848$ 68,416$ 68,410$ 100.0%628,610$ 16,568$ NET FUND INCREASE (DECREASE)(989,067)$ 1,809,233$ (60,175)$ (4,914,095)$ 2,798,300$ Village of Oak Brook Infrastructure Fund Financial Update For the Period Ending April 30, 2022 Total Total Revenues Expenditures 4/30/22 Actual $ 2,691,405 950,588$ 4/30/21 Actual $ 1,962,948 3,003,863$ Change From Last Year 37.1%-68.4% Major Revenues Sales Tax Charges for Services Investment Interest Miscellaneous 4/30/22 Actual $ 2,680,680 $ - $ 10,726 $ 3,080 4/30/21 Actual $ 1,948,264 $ - $ 11,603 $ 3,080 Change From Last Year 37.6%0.0%-7.6%0.0% Five Year Trend Major Expenditures Materials &Operation & Personnel Supplies Contractual Capital Outlay 4/30/22 Actual 472,005$ 117,565$ 291,695$ 29,948$ 4/30/21 Actual 450,278$ 124,125$ 354,022$ 2,075,437$ Change From Last Year 4.8%-5.3%-17.6%-98.6% Five Year Trend Expenditures by Department 4/30/21 4/30/22 4/30/22 4/30/22 2022 Difference Five YTD YTD YTD % of Annual Prior Year Actual Actual Budget Budget Budget Year Trend Legislative & General Management 36,285$ 28,892$ 52,010$ 55.5%209,510$ (7,394)$ Public Works 651,848 589,033 584,365 100.8%2,380,195 (62,815) Engineering & Capital Projects 768,463 98,940 706,825 14.0%9,886,230 (669,523) Total Expenditures 1,456,596$ 716,864$ 1,343,200$ 53.4%12,475,935$ (739,732)$ Five Year Trend Village of Oak Brook Infrastructure Fund - Major Sources Five Year Trend For the Period Ending April 30, 2022 Revenues Expenditures 4/30/22 4/30/22 4/30/21 4/30/22 YTD % of YTD 2022 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Sales Tax 17,605$ -$ 30,000$ 0.0%90,000$ (17,605)$ Real Estate Tax - N/A 405,000 - Investment Interest 23 49 15 328.7%50 26 Total Operating Revenues 17,628$ 49$ 30,015$ 0.164%495,050$ (17,579)$ EXPENDITURES Operation and Contract -$ N/A 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)(210,622)$ (243,101)$ (213,135)$ 4,895$ (32,479)$ Note - Expenditures are recorded in program 283. Village of Oak Brook Promenade TIF Fund Financial Update For the Period Ending April 30, 2022 Total Total Revenues Expenditures 4/30/22 Actual $ 49 243,150$ 4/30/21 Actual $ 17,628 228,250$ Change From Last Year -99.7%6.5% Major Revenues Real Estate Investment Sales Tax Tax Interest 4/30/22 Actual -$ $ - $ 49 4/30/21 Actual 17,605$ $ - $ 23 Change From Last Year -100.0%0.0%111.5% Five Year Trend Major Expenditures Operation &Other Contractual Expenditures 4/30/22 Actual -$ 243,150$ 4/30/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 April 30, 2022 Five Year Trend Revenues Expenditures 4/30/22 4/30/22 4/30/21 4/30/22 YTD % of YTD 2022 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Plan Review Fees 75$ 375$ 340$ 110.3%1,000$ 300$ Building/Inspection Fees 2,025 825 1,660 49.7%5,000 (1,200) Water Sales 2,342,855 2,678,766 2,402,500 111.5%10,484,500 335,911 Unmetered Sales 5,126 45,547 16,660 273.4%50,000 40,421 Water Connection Fees 77,510 183,310 25,000 733.2%75,000 105,800 Fire Service Charge N/A - Meter Charges 2,228 9,926 5,000 198.5%15,000 7,698 Special Services 765 - 500 0.0%25,000 (765) Investment Interest 18,286 5,466 10,000 54.7%30,000 (12,820) Miscellaneous 125,363 35,748 10,000 357.5%30,000 (89,615) Total Operating Revenues 2,574,232$ 2,959,963$ 2,471,660$ 119.8%10,715,500$ 385,732$ OPERATING EXPENDITURES Personnel 238,714$ 132,917$ 202,260$ 65.7%647,620$ (105,798)$ Materials and Supplies 37,204 39,430 25,455 154.9%69,650 2,226 Operation and Contract 939,597 1,025,051 1,315,595 77.9%5,400,625 85,454 Capital Outlay 1,889,860 3,894 - N/A 3,925,000 (1,885,966) Total Expenditures 3,105,375$ 1,201,291$ 1,543,310$ 77.8%10,042,895$ (1,904,084)$ Surplus (Deficit) of Revenues Over Expenditures (531,144)$ 1,758,672$ 928,350$ 189.4%672,605$ 2,289,816$ INTERFUND TRANSACTIONS Reimbursements To Other Funds (150,168)$ (140,164)$ (140,170)$ 100.0%(420,490)$ 10,004$ Total Interfund Transactions (150,168)$ (140,164)$ (140,170)$ 100.0%(420,490)$ 10,004$ Fund Increase/(Decrease) - Budgetary Basis (681,312)$ 1,618,508$ 788,180$ 205.3%252,115$ 2,299,820$ ADUSTMENTS TO GAAP BASIS* Remove Capital Outlay 508,161$ 3,894$ Depreciation Expense (143,750) (143,750) IMRF Pension Expense (11,250) (11,250) OPEB Expense (7,500) (7,500) Total GAAP Adjustments 345,661$ (158,606)$ Fund Increase/(Decrease) - GAAP Basis (335,651)$ 1,459,902$ 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 April 30, 2022 Total Total Revenues Expenditures 4/30/22 Actual $ 2,959,963 1,201,291$ 4/30/21 Actual $ 2,574,232 3,105,375$ Change From Last Year 15.0%-61.3% Unmetered Water Water Sales Sales Connection Fees Meter Charges Miscellaneous 4/30/22 Actual $ 2,678,766 $ 45,547 $ 183,310 $ 9,926 $ 35,748 4/30/21 Actual $ 2,342,855 $ 5,126 $ 77,510 $ 2,228 $ 125,363 Change From Last Year 14.3%788.6%136.5%345.5%-71.5% Five Year Trend Materials &Operation &Other Personnel Supplies Contractual Expenditures Capital Outlay 4/30/22 Actual 132,917$ 39,430$ 1,025,051$ -$ 3,894$ 4/30/21 Actual 238,714$ 37,204$ 939,597$ -$ 1,889,860$ Change From Last Year -44.3%6.0%9.1%0.0%-99.8% Five Year Trend Expenditures by Department 4/30/21 4/30/22 4/30/22 4/30/22 2022 Difference Five YTD YTD YTD % of Annual Prior Year Actual Actual Budget Budget Budget Year Trend Public Works 838,833$ 813,074$ 1,140,710$ 73.5%6,067,895$ 25,759$ Engineering & Capital Projects 527,386 23,265 - 0.0%3,975,000 504,122 Total Expenditures 1,366,219$ 836,338$ 1,140,710$ 73.3%10,042,895$ 529,881$ Five Year Trend Village of Oak Brook Water Fund - Major Sources Five Year Trend For the Period Ending April 30, 2022 Revenues Expenditures Village of Oak Brook Monthly Operating Statement Sports Core Fund Consolidated Presentation For the Period Ending April 30, 2022 4/30/22 4/30/22 4/30/22 YTD % of YTD 2022 4/30/21 Difference B&T Recreation Field Clubhouse Golf YTD Amended Amended Adopted YTD Prior Operations Operations Operations Club Total Budget Budget Budget Total Year OPERATING REVENUES Memberships 304,025$ -$ -$ 370,300$ 674,325$ 304,700$ 221.3%801,750$ 338,775$ 335,550$ Greens Fees - - - 89,686 89,686 36,000 249.1%1,145,000 148,823 (59,137) Pro Shop Sales - - - 46,129 46,129 21,910 210.5%210,000 52,654 (6,525) Golf Lessons - - - 21,603 21,603 7,000 308.6%50,000 22,950 (1,347) Driving Range Fees - - - 109,237 109,237 63,000 173.4%300,000 117,636 (8,399) Rentals - 147,643 13,888 29,655 191,186 54,275 352.3%993,775 149,521 41,665 Programs/User Fees 750 - - - 750 1,500 0.0%15,500 - 750 Food Sales - - - 19,465 19,465 6,440 302.3%286,000 32,012 (12,547) Beverage Sales - - - 36,980 36,980 11,500 321.6%490,000 56,272 (19,292) Taste of Oak Brook - - - - - - 0.0%120,000 - - Grants - - - - - - 0.0%- - - Other Revenue 150 - - - 150 440 34.1%8,000 11,802 (11,652) Total Operating Revenues 304,925$ 147,643$ 13,888$ 723,055$ 1,189,511$ 506,765$ 234.7%4,420,025$ 930,445$ 259,066$ OPERATING EXPENDITURES Personnel 3,617$ -$ 37,548$ 231,452$ 272,617$ 248,055$ 109.9%1,671,380$ 303,690$ (31,073)$ Materials & Supplies 4,488 - 414 81,916 86,818 62,160 139.7%718,900 93,255 (6,437) Operational & Contractual 59,443 14,007 21,311 96,216 190,977 98,130 194.6%942,765 153,423 37,554 Other - - - - - - N/A - - - Capital 14,708 - 5,792 32,481 52,981 107,035 49.5%466,750 108,864 (55,883) Total Operating Expenditures 82,256$ 14,007$ 65,065$ 442,066$ 603,393$ 515,380$ 117.1%3,799,795$ 659,232$ (55,839)$ B&T Administration Overhead Allocation*-$ -$ -$ -$ -$ -$ N/A -$ -$ -$ Operating Revenues Over (Under) Expenditures 222,669$ 133,636$ (51,176)$ 280,990$ 586,118$ (8,615)$ -6803.5%620,230$ 271,213$ 314,905$ INTERFUND TRANSACTIONS Interfund Loan**-$ -$ -$ -$ -$ -$ 0.0%-$ -$ -$ Transfer From General Fund - - - - - - 0.0%- - - Transfer From Golf Surcharge Fund - - - - - 50,000 0.0%150,000 - - Reimbursement From Infrastructure Fund - - - - - - 0.0%- 10,667 (10,667) Reimbursement From Water Fund - - - - - - 0.0%- 2,669 (2,669) Reimbursement To General Fund (6,288) - - (18,864) (25,152) (18,865) 133.3%(75,455) (20,964) (4,188) Total Interfund Transactions (6,288)$ -$ -$ (18,864)$ (25,152)$ 31,135$ -80.8%74,545$ (7,628)$ (17,524)$ Total Revenues Over (Under) Expenditures - Budgetary Basis 216,381$ 133,636$ (51,176)$ 262,126$ 560,966$ 22,520$ 694,775$ 263,585$ 297,381$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay 14,708$ -$ 5,792$ 32,481$ 52,981$ 108,864$ Depreciation Expense (42,057) (421) - (61,575) (104,053) (158,737) IMRF Pension Expense (513) - - (6,125) (6,638) (9,850) OPEB Expense - - - (7,000) (7,000) (10,333) Total GAAP Adjustments (27,861)$ (421)$ 5,792$ (42,219)$ (64,710)$ (70,057)$ Fund Increase/(Decrease) - GAAP Basis 188,520$ 133,215$ (45,384)$ 219,907$ 496,257$ 193,528$ 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 4/30/22 Actual $ 1,189,511 603,393$ 4/30/21 Actual $ 930,445 659,232$ Change From Last Year 27.8%-8.5% Driving Program/ Memberships Greens Fees Range Fees Rentals User Fees 4/30/22 Actual $ 674,325 $ 89,686 $ 109,237 $ 191,186 750$ 4/30/21 Actual $ 338,775 $ 148,823 $ 117,636 $ 149,521 -$ Change From Last Year 99.0%-39.7%N/A 27.9%0.0% Five Year Trend Materials &Operation &Other Personnel Supplies Contractual Expenditures Capital Outlay 4/30/22 Actual 272,617$ 86,818$ 190,977$ -$ 52,981$ 4/30/21 Actual 303,690$ 93,255$ 153,423$ -$ 108,864$ Change From Last Year -10.2%-6.9%24.5%0.0%-51.3% Five Year Trend Revenues by Department 4/30/21 4/30/22 4/30/22 4/30/22 2022 Difference Five YTD YTD YTD % of Annual Prior Year Actual Actual Budget Budget Budget Year Trend B&T Recreation Operations 7,103$ 304,925$ 64,640$ 471.7%521,450$ 297,822$ Open Field Operations 90,000 147,643 3,000 4921.4%375,000 57,643 B&T Clubhouse Operations 2,950 13,888 41,275 33.6%351,275 10,938 Golf Club 830,392 723,055 397,850 181.7%3,172,300 (107,337) Total Revenues 930,445$ 1,189,511$ 506,765$ 234.7%4,420,025$ 259,066$ Expenditures by Department 4/30/21 4/30/22 4/30/22 % of YTD 2022 Difference Five YTD YTD YTD % of Annual Prior Year Actual Actual Budget Budget Budget Year Trend B&T Recreation Operations 154,043$ 82,256$ 40,240$ 204.4%567,180$ (71,787)$ Open Field Operations 1,082$ 14,007$ 11,255$ 124.5%250,660$ 12,925$ B&T Clubhouse Operations 42,844 65,065 110,565 58.8%298,200 22,221 Golf Club 461,263 442,066 353,320 125.1%2,683,755 (19,197) Total Expenditures 659,232$ 603,393$ 515,380$ 117.1%3,799,795$ (55,839)$ Five Year Trend Village of Oak Brook Sports Core Fund - Major Sources Five Year Trend For the Period Ending April 30, 2022 Revenues Expenditures Village of Oak Brook Monthly Operating Statement Bath & Tennis Club Recreation Operations For the Period Ending April 30, 2022 4/30/22 4/30/22 822 4/30/22 YTD % of YTD 2022 4/30/21 Difference 811 812 813 Poolside YTD Amended Amended Adopted YTD Prior B&T Admin Swimming Tennis Café Total Budget Budget Budget Total Year OPERATING REVENUES Memberships -$ 287,200$ 16,825 - 304,025$ 62,900$ 483.3%448,950$ -$ 304,025$ Programs/User Fees - 120 630 - 750$ 1,500.00 50.0%15,500 - 750 Food Sales - - - - -$ - N/A 36,000 - - Beverage Sales - - - - -$ - N/A 20,000 - - Grants - - - - -$ - N/A - - - Other Revenue 150 - - - 150$ 240 62.6%1,000 7,103 (6,953) Total Operating Revenues 150$ 287,320$ 17,455$ -$ 304,925$ 64,640$ 471.7%521,450$ 7,103$ 297,822$ OPERATING EXPENDITURES Personnel 3,617$ - - - 3,617$ 9,340$ 38.7%127,350$ -$ 3,617$ Materials & Supplies 232 3,066 1,191 - 4,488$ 8,620 52.1%74,550 22,778 (18,290) Operational & Contractual 10,310 47,722 1,153 258 59,443$ 18,215 326.3%307,530 25,483 33,960 Other - -$ N/A - - Capital (11,584) 24,670 1,158 463 14,708$ 4,065 361.8%57,750 105,782 (91,074) Total Operating Expenditures 2,575$ 75,458$ 3,502$ 721$ 82,256$ 40,240$ 204.4%567,180$ 154,043$ (71,787)$ B&T Administration Overhead Allocation*-$ -$ -$ -$ -$ -$ N/A 68,810$ 11,017$ (11,017)$ Operating Revenues Over (Under) Expenditures (2,425)$ 211,862$ 13,953$ (721)$ 222,669$ 24,400$ 912.6%23,080$ (135,923)$ 358,592$ Reimbursement From Infrastructure Fund - - - - - - 0.0%- 10,667 (10,667) Reimbursement From Water Fund - - - - - - 0.0%- 2,669 (2,669) Reimbursement To General Fund (6,288) - - - (6,288) (4,710) 133.5%(18,865) (5,240) (1,048) Total Interfund Transactions (6,288)$ -$ -$ -$ (6,288)$ (4,710)$ 133.5%(18,865)$ 8,096$ (14,384)$ Total Revenues Over (Under) Expenditures - Budgetary Basis (8,713)$ 211,862$ 13,953$ (721)$ 216,381$ 19,690$ 4,215$ (127,827)$ 344,208$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay (11,584)$ 24,670$ 1,158$ 463$ 14,708$ 105,782$ Depreciation Expense (16,090) (25,000) (675) (292) (42,057) (56,076) IMRF Pension Expense (500) - - (13) (513) (683) Total GAAP Adjustments (28,173)$ (330)$ 483$ 159$ (27,861)$ 49,023$ Fund Increase/(Decrease) - GAAP Basis (36,886)$ 211,532$ 14,436$ (563)$ 188,520$ (78,804)$ 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 April 30, 2022 4/30/22 4/30/22 4/30/22 YTD % of YTD 2022 4/30/21 Difference 815 816 YTD Amended Amended Adopted YTD Prior Polo Open Fields Total Budget Budget Budget Total Year OPERATING REVENUES Field Rentals -$ 67,643$ 67,643$ 3,000$ 2254.8%170,000$ 10,000$ 57,643$ Range Rentals - 80,000 80,000 - N/A 85,000 80,000 - Taste of Oak Brook - - - N/A 120,000 - - Other Revenue - - N/A - - - Total Operating Revenues -$ 147,643$ 147,643$ 3,000$ 4921.4%375,000$ 90,000$ 57,643$ OPERATING EXPENDITURES Personnel -$ -$ -$ N/A -$ -$ Materials & Supplies - - - 100 0.0%1,500$ - - Operational & Contractual - 14,007 14,007 11,155 125.6%249,160 1,082 12,925 Capital - - N/A - - Total Operating Expenditures -$ 14,007$ 14,007$ 11,255$ 124.5%250,660$ 1,082$ 12,925$ Operating Revenues Over (Under) Expenditures -$ 133,636$ 133,636$ (8,255)$ -1618.8%124,340$ 88,918$ 44,718$ INTERFUND TRANSACTIONS Transfer From Hotel Tax Fund -$ -$ -$ -$ 0.0%-$ -$ -$ Total Interfund Transactions -$ -$ -$ -$ 0.0%-$ -$ -$ Total Revenues Over (Under) Expenditures - Budgetary Basis -$ 133,636$ 133,636$ (8,255)$ 124,340$ 88,918$ 44,718$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay -$ -$ -$ -$ Depreciation Expense - (421) (421) (562) Total GAAP Adjustments -$ (421)$ (421)$ (562)$ Fund Increase/(Decrease) - GAAP Basis -$ 133,215$ 133,215$ 88,356$ 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 April 30, 2022 4/30/22 4/30/22 821 YTD % of YTD 2022 4/30/21 Difference B&T Amended Amended Adopted YTD Prior Clubhouse Budget Budget Budget Total Year OPERATING REVENUES Rentals 13,888$ 41,275$ 33.6%351,275$ 2,950$ 10,938$ Total Operating Revenues 13,888$ 41,275$ 33.6%351,275$ 2,950$ 10,938$ OPERATING EXPENDITURES Personnel 37,548$ 38,550$ 97.4%140,250$ 33,648$ 3,900$ Materials & Supplies 414 5,630 7.3%15,350 1,466 (1,052) Operational & Contractual 21,311 23,415 91.0%92,600 7,730 13,581 Capital 5,792 42,970 13.5%50,000 - 5,792 Total Operating Expenditures 65,065$ 110,565$ 58.8%298,200$ 42,844$ 22,221$ B&T Administration Overhead Allocation*-$ -$ N/A (68,810)$ (11,017)$ 11,017$ Operating Revenues Over (Under) Expenditures (51,176)$ (69,290)$ 73.9%(15,735)$ (50,911)$ (265)$ INTERFUND TRANSACTIONS Transfer From General Fund -$ -$ 0.0%-$ -$ -$ Total Interfund Transactions -$ -$ 0.0%-$ -$ -$ Total Revenues Over (Under) Expenditures - Budgetary Basis (51,176)$ (69,290)$ (15,735)$ (50,911)$ (265)$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay 5,792$ -$ Depreciation Expense (20,000) IMRF Pension Expense (1,000) OPEB Expense (1,000) Total GAAP Adjustments 5,792$ (22,000)$ Fund Increase/(Decrease) - GAAP Basis (45,384)$ (72,911)$ 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 April 30, 2022 4/30/22 4/30/22 823 831 832 833 834 4/30/22 YTD % of YTD 2022 4/30/21 Difference Golf Golf General Golf Learning Golf Cart Golf Course YTD Amended Amended Adopted YTD Prior Café Operation & Practice Operations Maintenance Total Budget Budget Budget Total Year OPERATING REVENUES Memberships -$ 370,300$ -$ -$ -$ 370,300$ 241,800$ 153.1%352,800$ 338,775$ 31,525$ Greens Fees - 89,686 - - - 89,686 36,000 249.1%1,145,000 148,823 (59,137) Pro Shop Sales - 46,129 - - - 46,129 21,910 210.5%210,000 52,654 (6,525) Golf Lessons - - 21,603 - - 21,603 7,000 308.6%50,000 22,950 (1,347) Driving Range Fees - - 109,237 - - 109,237 63,000 173.4%300,000 117,636 (8,399) Rentals - 115 - 29,540 - 29,655 10,000 296.5%387,500 56,571 (26,916) Food Sales 19,465 - - - - 19,465 6,440 302.3%250,000 32,012 (12,547) Beverage Sales 36,980 - - - - 36,980 11,500 321.6%470,000 56,272 (19,292) Other Revenue - - - - - - 200 0.0%7,000 4,699 (4,699) Total Operating Revenues 56,445$ 506,230$ 130,840$ 29,540$ -$ 723,055$ 397,850$ 181.7%3,172,300$ 830,392$ (107,337)$ OPERATING EXPENDITURES Personnel 26,086$ 131,371$ 2,342$ 1,539$ 70,114$ 231,452$ 200,165$ 115.6%1,403,780$ 270,042$ (38,590)$ Materials & Supplies 45,508 (2,388) 8,786 1,368 28,642 81,916 47,810 171.3%627,500 69,011 12,905 Operational & Contractual 1,561 55,959 606 17,877 20,213 96,216 45,345 212.2%293,475 119,128 (22,912) Other - - - - - - - 0.0%- - - Capital - 32,481 - - - 32,481 60,000 0.0%359,000 3,082 29,399 Total Operating Expenditures 73,155$ 217,422$ 11,735$ 20,784$ 118,969$ 442,066$ 353,320$ 125.1%2,683,755$ 461,263$ (19,197)$ Operating Revenues Over (Under) Expenditures (16,709)$ 288,808$ 119,105$ 8,756$ (118,969)$ 280,990$ 44,530$ 631.0%488,545$ 369,129$ (88,139)$ INTERFUND TRANSACTIONS Transfer from Golf Surcharge -$ -$ -$ -$ -$ -$ 50,000$ 0.0%150,000$ -$ -$ Reimbursement to General Fund - (18,864) - - - (18,864) (14,155) 133.3%(56,590) (15,724) (3,140) Total Interfund Transactions -$ (18,864)$ -$ -$ -$ (18,864)$ 35,845$ -52.6%93,410$ (15,724)$ (3,140)$ Total Revenues Over (Under) Expenditures - Budgetary Basis (16,709)$ 269,944$ 119,105$ 8,756$ (118,969)$ 262,126$ 80,375$ 581,955$ 353,405$ (91,279)$ ADUSTMENTS TO GAAP BASIS* Remove Capital Outlay -$ 32,481$ -$ -$ -$ 32,481$ 3,082$ Depreciation Expense (250) (26,250) (575) (3,250) (31,250) (61,575) (82,100) IMRF Pension Expense (625) (2,500) (250) - (2,750) (6,125) (8,167) OPEB Expense (750) (3,750) - - (2,500) (7,000) (9,333) Total GAAP Adjustments (1,625)$ (19)$ (825)$ (3,250)$ (36,500)$ (42,219)$ (96,518)$ Fund Increase/(Decrease) - GAAP Basis (18,334)$ 269,925$ 118,280$ 5,506$ (155,469)$ 219,907$ 256,887$ Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.