Loading...
11 - November 2020 Monthly Financial ReportVILLAGE OAK BROOK OF MONTHLY FINANCIAL REPORTS NOVEMBER 2020 ITEM 6.E Cash and Investments by Fund:Total Cash and Cash Pooled Cash and Fund Equivalents Investments Investments % By Fund General Corporate $10,093,723 $14,082,848 $24,176,571 52.4% Hotel/Motel Tax 1,820,182 2,764,719 4,584,901 9.9% Motor Fuel Tax 829,420 35,737 865,157 1.9% Infrastructure 5,923,814 2,039,325 7,963,139 17.2% Promenade TIF 240,554 - 240,554 0.5% Water 3,931,816 3,545,649 7,477,465 16.2% Sports Core 210,415 - 210,415 0.5% Golf Surcharge 129,101 - 129,101 0.3% Self-Insurance (489,935)- (489,935) -1.1% Garage 337,440 - 337,440 0.7% Equipment Replacement 269,838 414,916 684,754 1.5% Total $23,296,368 $22,883,194 $46,179,562 100.0% Change in Cash and Investments by Fund : Balance at Balance at Year-to-Date Year-to-Date Fund January 1, 2020 November 30, 2020 Change ($)Change (%) General Corporate $21,270,239 $24,176,571 $2,906,332 13.7% Hotel/Motel Tax 5,427,474 4,584,901 (842,573)-15.5% Motor Fuel Tax 1,085,595 865,157 (220,438)-20.3% Infrastructure 8,217,724 7,963,139 (254,585)-3.1% Promenade TIF 304,194 240,554 (63,640)-20.9% Water 6,947,239 7,477,465 530,226 7.6% Sports Core 231,216 210,415 (20,801)-9.0% Golf Surcharge 347,066 129,101 (217,965)-62.8% Self-Insurance 308,820 (489,935)(798,755)-258.6% Garage 275,988 337,440 61,452 22.3% Equipment Replacement 808,879 684,754 (124,125)-15.3% $45,224,434 $46,179,562 $955,128 2.1% Book Bank/Market Value Value Cash and Cash Equivalents: Pooled Checking $2,196,999 $2,660,494 Sports Core Checking 549,252 530,660 Pooled IPTIP 20,132,745 20,132,745 Water E-Pay IPTIP 417,372 392,373 $23,296,368 $23,716,272 Pooled Investments: Investments-Municipal Bonds $9,965,428 $10,028,665 Investments-Corporate Bonds 7,451,202 7,524,308 Government & Agency Obligations 1,622,147 1,654,224 Certificates of Deposit 3,675,000 3,722,998 Accrued Interest 169,417 169,417 Total Pooled Investments $22,883,194 $23,099,612 Total Cash and Investments $46,179,562 $46,815,884 For November, total interest revenue is $36,035 and YTD is $589,240. The total investment yield for the portfolio is: Pooled Investments Illinois Funds Total Last 12 months yield 2.08%0.80%1.50% The weighted average yield of the current pooled investment portfolio is 1.80%. The IL Funds November average daily rate was 0.093%. Monthly Treasurer's Report November 30, 2020 Monthly Treasurer's Report November 2020 The table below lists the detail investment holdings at J.P. Morgan Securities as of 11/30/20: Month End VOB Settlement Maturity Coupon Yield Book Market Accrued Type Date Date Rate Rate Value Value Interest Municipal Bonds: New York N Y City #64971QTX1 02/22/16 05/01/21 2.350%2.000%$200,273 $201,478 $377 Bloomingdale Mich Pub Sch Dist #094383FS0 04/26/16 05/01/22 2.710%2.150%503,837 516,005 1,090 Connecticut St GO Bds 2016 #20772J3F7 06/15/17 08/15/21 1.750%2.300%498,106 504,400 2,523 Wright County Min #982276BC0 07/18/19 12/01/20 2.000%2.000%545,000 545,000 5,965 State of IL #452152P54 10/09/19 11/01/21 5.000%1.870%514,235 510,025 1,832 Anchor Bay Mich Sch #032879TE8 11/01/19 05/01/21 2.320%1.750%716,701 719,626 1,244 Brownsville TX #16405ST9 12/19/19 02/15/22 2.050%2.000%555,320 565,229 3,192 Laredo TX Waterworks #517039VW0 12/19/19 03/01/24 2.230%2.230%455,000 475,111 2,480 Manchester NH #562333JE5 03/12/20 12/01/20 5.000%0.850%475,002 475,000 11,835 Oakland Univ Mich #673588HJ1 04/29/20 03/01/24 5.000%1.650%326,120 333,149 3,688 Philadelphia PA GO Ref #717813SW0 05/05/20 08/01/22 5.000%1.820%410,354 418,837 6,297 Maryland St DOT #574204WG4 05/06/20 06/15/22 4.350%1.200%272,518 275,421 5,099 University of CA #91412HFK4 07/16/20 05/15/23 0.628%0.628%25,000 25,094 7 Windsor NY Sch Dist #973675EW7 07/23/02 06/17/21 1.500%0.400%477,821 477,603 2,547 Waterford Mich Sch Dist #941468YZ7 08/20/20 08/24/21 4.000%0.301%513,488 512,855 5,591 Weedsport NY Cent Sch Dist #948543KA0 08/21/20 08/20/21 1.000%0.570%501,538 501,115 1,384 Universty of IL #914353YH4 08/31/20 10/01/21 3.000%0.701%254,766 254,525 1,250 New Jersey St #646039UD7 09/20/20 06/01/22 5.000%0.600%506,209 506,920 11,809 Alaska St GO #011770Z72 10/14/2020 8/1/2021 5.000%0.252%180,554 180,546 2,892 Rio Rancho NM #767175HM7 10/14/2020 5/15/2022 5.000%0.350%197,501 197,819 385 Cook, Kane, Lake, & McHenry #216181GL5 10/29/2020 12/15/2022 4.000%0.300%1,102,027 1,100,840 3,637 Miami-Dade Cnty #59333NN90 10/29/2020 12/15/2022 0.375%0.430%734,059 732,067 452 Total Municipal Bonds $9,965,428 $10,028,665 $75,578 Corporate Bonds: Wells Fargo #94974BGR5 01/15/19 12/07/20 2.550%3.120%$1,389,996 $1,390,445 $17,427 PNC Bank #69353RFH6 01/30/19 01/22/21 2.500%3.020%499,660 500,860 4,479 Morgan Stanley #61747WAL3 03/08/19 07/28/21 5.500%3.034%1,066,498 1,084,997 19,571 Citigroup #172967LC3 04/01/19 12/08/21 2.900%2.754%1,001,552 1,023,630 13,372 Goldman Sachs #38143U8F1 05/02/19 02/25/21 2.875%2.707%365,129 366,365 2,771 American Honda #02665WBG5 07/31/19 09/09/21 1.700%2.180%498,190 505,340 1,959 BB&T Corp #05531FAZ6 08/15/19 02/01/21 2.150%2.010%750,203 751,163 5,178 JP Morgan #48128BAB7 09/30/19 01/15/23 2.972%2.337%1,013,033 1,029,120 6,994 American Express #025816CD9 05/05/20 05/20/22 2.750%1.290%510,653 516,310 277 Goldman Sachs #38141GGQ1 08/31/20 07/27/21 5.250%0.251%356,288 356,078 6,239 Total Corporate Bonds $7,451,202 $7,524,308 $78,268 Government & Agency Obligations: *Government National Mtg Assn #38379UEM4 02/29/16 02/16/51 2.300%2.245%$454,562 $447,845 $2,199 *Government National Mtg Assn #38381WV96 08/06/19 07/20/54 2.250%2.293%641,403 658,346 1,102 *Government National Mtg Assn #38380BNV3 12/05/19 06/20/46 2.000%2.112%526,181 548,033 799 Total Government & Agency Obligations:$1,622,147 $1,654,224 $4,101 Certificates of Deposit: State Bk India NY #8562846A7 01/26/17 01/26/22 2.250%2.250%$245,000 $251,152 $1,922 Jackson Cnty Bk #466682AP6 08/31/17 03/01/21 1.850%1.850%245,000 246,125 1,133 Comenity Cap Bank #20033AU46 04/15/19 04/15/21 2.500%2.500%245,000 247,249 220 Morgan Stanley #61760AE21 05/30/19 06/01/21 2.400%2.400%245,000 247,923 - First St Bank DeQueen #336460CU2 07/18/19 07/19/21 2.000%2.000%245,000 248,026 173 Bank Hapoalim #06251AW89 07/19/19 07/19/21 2.000%2.000%245,000 248,195 1,943 Capital One Natl Assn #14042RMF5 07/24/19 07/26/19 2.050%2.050%245,000 248,210 1,870 TIAA FSB Jacksonville #87270LCN1 07/29/19 07/29/21 2.000%2.000%245,000 248,170 1,661 Wells Fargo #949763J31 09/18/19 09/20/21 1.850%1.850%245,000 248,526 174 BMW Bank #05580ASQ8 10/11/19 10/12/21 1.800%1.800%245,000 248,697 539 Wells Fargo #949495AN5 01/17/20 01/18/22 1.800%1.800%245,000 249,778 174 Bank Leumi #063248KQ0 03/31/20 03/31/22 1.250%1.250%245,000 248,783 498 Capital One Natl Assn #14042TCZ8 04/01/20 04/01/22 1.350%1.350%245,000 249,101 538 Synchrony Bank #87164WZN1 04/03/20 04/04/22 1.350%1.350%245,000 249,126 519 Wells Fargo #95001DAB6 06/17/20 06/17/23 1.200%1.200%245,000 243,937 106 Total Certificates of Deposits $3,675,000 $3,722,998 $11,470 Total J.P.Morgan Securities $22,713,777 $22,930,195 $169,417 *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 November 30, 2020 Cash & Investments by Fund - Total $46.2 million Cash & Investments by Type - Total $46.2 million Checking Illinois Funds Certificates of Deposit Municipal Bonds Corporate Bonds Government & Agency Obligations Accrued Interest General Corporate 51.3% Hotel/Motel Tax 9.7% Motor Fuel Tax 1.8% Infrastructure 16.9% Promenade TIF 0.5% Water 15.9% Sports Core 0.4% Golf Surcharge 0.3% Self-Insurance -1.0%Garage 0.7% Equipment Replacement 1.5% Checking, $2.7 Illinois Funds, $20.6 Certificates of Deposit, $3.7 Municipal Bonds, $9.9 Corporate Bonds, $7.5 Government & Agency Obligations, $1.6 Accrued Interest, $0.2 in millions YTD YTD Net Fund Budgeted YTD YTD Increase Increase Governmental Funds Revenues Expenditures (Decrease)(Decrease) General Fund (Major Fund)23,538,644$ 20,935,159$ 2,603,485$ 900,770$ Main operating fund of the Village. Hotel Fund (Major Fund)557,571$ 901,964$ (344,393)$ (313,225)$ Collects and spends resources from the 3% hotel/motel tax. Motor Fuel Tax Fund 451,011$ 666,289$ (215,278)$ (1,058,185)$ Collects and spends resources from the State motor fuel tax. Infrastructure Fund (Major Fund)5,546,531$ 6,263,685$ (717,154)$ (5,503,350)$ Accounts for construction and maintenance of roadways, drainage, and safety path systems. Promenade TIF Fund (Major Fund)470,562$ 534,203$ (63,641)$ (56,165)$ 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)9,793,765$ 8,738,482$ 1,055,283$ (1,909,710)$ Collects user fees for the distribution of water and maintenance of infrastructure. Sports Core Fund (Major Fund)3,529,615$ 3,486,724$ 42,891$ 56,520$ Accounts for revenues and expenses relating to administration, programs, food and beverage operations, and golf course. Golf Surcharge Fund 122,100$ 340,065$ (217,965)$ (282,690)$ Accounts for the collection of the $3 per round golf surcharge. Internal Service Funds Self Insurance Fund 3,231,813$ 3,789,460$ (557,647)$ 19,530$ Accounts for the Village's health insurance costs and the related contributions from the Village, employees, retirees, and other agencies. Garage Fund 649,139$ 618,107$ 31,032$ (41,805)$ Accounts for the maintenance of the Village's vehicle fleet and the related departmental reimbursements. Equipment Replacement Fund 302,455$ 426,579$ (124,124)$ 50,125$ 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 November 30, 2020 Village of Oak Brook Monthly Financial Report – Fund Narrative For the Period Ending November 30, 2020 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: x 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 x 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 major 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 x Total revenues through November 2020 are $1,456,715, or 6.0%, lower than last November and $506,555, or 2.2%, under budget to date. The main drivers for this are: o Sales tax revenue, the General Fund’s largest revenue source, is down $1,185,071 from last year and $1,163,893 under budget. November 2020 collections are relatively consistent with collections the previous five years as revenues rebounded from the COVID-19 related business closures earlier this year. o Telecommunications/Utility Tax is down $320,807 from last year and $191,260 under budget. This is due to a decrease in usage from the closure of businesses during the pandemic. o Licenses and permits revenue is down $71,000 from last year, but $718,254 over budget. The building permit related to the first phase of the Hines development was issued in November. Additional phases of this project are expected to come over the next year. o Charges for Services revenue is down $381,959 from last year and $299,500 under budget. This is primarily due to a decrease in ambulance fees from fewer calls for service due to the ongoing pandemic. x Total expenditures through November 2020 are $846,178, or 4.0%, lower than last year and $1,612,672, or 7.3%, under budget to date. The main drivers for this are: o Personnel expenditures are up $271,713 from last year, but $501,870 under budget. The increase is due to a combination of annual pay increases and final accrual payouts from three retirements. Personnel is under budget due to the start of furlough days and a reduction in overtime due to the COVID-19 pandemic. o Operation and contract expenditures are down $364,219 from last year and $555,492 under budget. This is due to the general timing of payments compared to when they were projected to occur. The Village has also put various projects on hold until after the pandemic is over. o Capital outlay expenditures are down $746,337 from last year and $463,604 under budget. Many capital items have been put on hold for 2020 due to the current economic state. Hotel Tax Fund x Total revenues through November 2020 are $752,439, or 57.4%, lower than last year and $624,479, or 52.8%, under budget. The main drivers for this are: o Hotel tax revenue is down $734,198 from last year and $640,945 under budget. The decrease is due to the timing of receipts being received and a reduction in room rentals from the COVID-19 pandemic. x Total expenditures through November 2020 are $317,504, or 61.5%, higher than last year, but $335,497, or 28.7%, under budget. The main drivers for this are: o Operation and contract expenditures are down $155,739 from last year and $278,345 under budget. This is due to the timing of advertising payments and the cancelling of certain campaigns. In addition, the Village rebated $70,013 of hotel tax related to January, February, and March stays back to the hotels. o Capital Outlay expenditures are up $473,243 from last year, but $57,152 under budget. There was no capital activity in 2019 and certain projects were cancelled or delayed during 2020. Infrastructure Fund x Total revenues through November 2020 are down $861,249, or 15.9%, from last year and $739,996, or 14.0%, under budget. The main drivers for this are: o Non-home rule sales tax revenue is down $736,165 from last year and $701,477 under budget. November 2020 collections are relatively consistent with collections the previous five years as revenues rebounded from the COVID-19 related business closures earlier this year. o Interest revenue is down $124,198 from last year and $35,753 under budget. Interest rates have dropped in recent months compared to last year. In addition, the Infrastructure Fund’s reserve balance has shifted to cash and other short-term investments in order to have money available for upcoming projects. x Total expenditures through November 2020 are down $360,501, or 5.6%, from last year and $6,432,750, or 51.3%, under budget to date. The main drivers for this are: o Operation and contract expenditures are down $216,624 from last year and $518,572 under budget. Expenditures are under budget due to the timing of engineering payments. Some projects have been delayed due to the current pandemic. o Capital Outlay expenditures are down $145,083 from last year and $5,778,967 under budget. The majority of budgeted projects have not occurred to date and may be cancelled or delayed until 2021 or later. Promenade TIF Fund x Total revenues through November 2020 are down $8,648, or 1.8% from last year, but $17,937, or 4.0%, over budget. Real estate tax revenue increased slightly in 2020 compared to last year. Interest rates have dropped in recent months compared to last year, resulting in a decrease in interest income. Sales tax revenue has been negatively affected by the COVID-19 pandemic. x Total expenditures through November 2020 are up $69,475, or 14.9%, from last year and $25,413, or 5.0%, over budget. The increase relates to additional principal and interest paid towards the TIF note. Expenditures are over budget due to the timing of audit and TIF report fees, as well as more principal paid on the note due to an increase in real estate taxes. Water Fund x Total revenues through November 2020 are up $60,913, or 0.6%, from last year, but $509,105, or 4.9%, under budget. The main drivers for this are: o Water sales revenue is up $301,766 from last year, but $407,427 under budget. Sales are under budget due to the business shut downs from the COVID-19 pandemic. o Water connection fees are down $151,290 from last year and $69,565 under budget. Revenue is down from last year due to the opening of a large office building in 2019. Revenue is under budget due to the delay in construction of planned development in 2020. x Total expenditures through November 2020 are down $95,711, or 1.1%, from last year and $3,474,109, or 29.6%, under budget. The main drivers for this are: o Operation and contract expenditures are up $30,704 from last year, but $979,349 under budget. Expenditures are under budget due to the timing of invoices paid and DuPage Water Commission water purchased being less than expected. o Capital outlay expenditures are down $74,594 from last year and $2,369,799 under budget. A number of budgeted projects for 2020 are on hold due to the current pandemic. Sports Core Fund x Total revenues through November 2020 are down $542,682, or 16.1%, from last year and $754,661, or 21.0%, under budget to date. Most revenue sources are under budget to date in 2020 due to the COVID-19 pandemic limiting activity. Starting in 2020, the Park District took over all Bath and Tennis Club membership sales, however, this was not factored into the 2020 budget due to the timing of the agreement. Highlights of Sports core revenues are: o Membership revenue is down $192,994 from last year and $232,448 under budget. This is due to a change in swimming and tennis memberships being taken over by the Park District rather than the Village. Golf memberships are up $28,813 from last year and $8,988 over budget to date. o Greens Fees are up $199,628 from last year and $181,776 over budget. The golf course was open on a limited basis until June 1, but has made up all the lost rounds since. o Rental income is down $430,872 from last year and $446,584 under budget. This is due to many events being cancelled this year at the B&T Clubhouse. In addition, golf cart rental fees are under budget due to the course being closed in the spring. x Total expenditures through November 2020 are down $754,567, or 18.0%, from last year and $1,432,620, or 29.4%, under budget to date. The main drivers for this are: o Personnel expenditures are down $75,616 from last year and $83,077 under budget. Personnel is down due to the COVID-19 pandemic closing Sports Core facilities for much of spring. o Materials & Supplies expenditures are down $84,210 from last year and $52,518 under budget. Expenditures are down due to facilities being closed for much of the spring. o Operation and Contractual expenditures are down $495,045 from last year and $610,408 under budget. This is due to the outsourcing of swimming, tennis, and soccer fields to the Park District. Previously, the Village paid the Park District $230,000 to operate the swimming pool. o Capital expenditures are down $99,696 from last year and $769,767 under budget. This is due to the golf lounge renovation project and a delay in the pool renovation project due to the COVID-19 pandemic. 11/30/20 11/30/20 11/30/19 11/30/20 YTD % of YTD 2020 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Sales Tax 11,537,428$ 10,352,357$ 11,516,250$ 89.9%12,502,000$ (1,185,071)$ Other Intergovernmental Tax*1,378,072 1,426,192 1,272,000 112.1%1,352,000 48,120 Telecommunications/Utility Tax 5,770,547 5,449,740 5,641,000 96.6%6,125,000 (320,807) Licenses and Permits 3,533,554 3,462,554 2,744,300 126.2%2,990,190 (71,000) Charges for Services 1,191,019 809,060 1,108,560 73.0%1,253,100 (381,959) Fines and Penalties 195,101 183,346 211,000 86.9%227,000 (11,755) Administrative Towing Fees 20,530 23,828 18,315 130.1%20,000 3,298 Investment Interest 425,616 332,549 380,435 87.4%415,000 (93,067) Franchise Fees 159,169 151,877 210,000 72.3%210,000 (7,292) Miscellaneous Income 210,134 772,952 369,150 209.4%408,095 562,818 Total Operating Revenues 24,421,170$ 22,964,455$ 23,471,010$ 97.8%25,502,385$ (1,456,715)$ OPERATING EXPENDITURES Personnel 16,324,622$ 16,596,335$ 17,098,205$ 97.1%19,160,220$ 271,713$ Materials and Supplies 416,672 412,327 501,350 82.2%539,170 (4,345) Operation and Contract 3,623,722 3,259,503 3,814,995 85.4%4,071,660 (364,219) Other Expenditures 9,537 6,547 9,230 70.9%10,000 (2,990) Capital Outlay 952,298 205,961 669,565 30.8%688,030 (746,337) Total Operating Expenditures 21,326,851$ 20,480,673$ 22,093,345$ 92.7%24,469,080$ (846,178)$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 3,094,319$ 2,483,782$ 1,377,665$ 1,033,305$ (610,537)$ INTERFUND TRANSACTIONS Transfers In 508,235$ -$ -$ 0.0%-$ (508,235)$ Transfers Out (704,518) (326,369) (923,000) 35.4%(923,000) 378,149 Reimbursements From Other Funds 579,524 574,189 574,200 100.0%626,395 (5,335) Reimbursements To Other Funds (120,175) (128,117) (128,095) 100.0%(139,770) (7,942) Total Interfund Transactions 263,066$ 119,703$ (476,895)$ -25.1%(436,375)$ (143,363)$ NET FUND INCREASE (DECREASE)3,357,385$ 2,603,485$ 900,770$ 596,930$ (753,900)$ *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 November 30, 2020 Total Total Revenues Expenditures 11/30/20 Actual 22,964,455$ 20,480,673$ 11/30/19 Actual 24,421,170$ 21,326,851$ % Change From Last Year -6.0%-4.0% Major Revenues Other Telecom/Utility Licenses &Charges for Sales Tax Intergov. Tax Tax Permits Services 11/30/20 Actual 10,352,357$ 1,426,192$ 5,449,740$ 3,462,554$ 809,060$ 11/30/19 Actual $ 11,537,428 $ 1,378,072 $ 5,770,547 $ 3,533,554 $ 1,191,019 % Change From Last Year -10.3%3.5%-5.6%-2.0%-32.1% Five Year Trend Major Expenditures Materials &Operation &Other Personnel Supplies Contractual Expenditures Capital Outlay 11/30/20 Actual 16,596,335$ 412,327$ 3,259,503$ 6,547$ 205,961$ 11/30/19 Actual 16,324,622$ 416,672$ 3,623,722$ 9,537$ 952,298$ % Change From Last Year 1.7%-1.0%-10.1%-31.4%-78.4% Five Year Trend Expenditures by Department 11/30/19 11/30/20 11/30/20 11/30/20 2020 Difference Five YTD YTD YTD % of Annual Prior Year Department Actual Actual Budget Budget Budget Year Trend Legislative & General Management 2,095,097$ 1,884,863$ 2,325,785$ 81.0%2,556,835$ (210,234)$ Financial Services 671,497 680,718 703,730 96.7%781,455 9,221 Public Works 783,297 735,240 816,395 90.1%893,055 (48,057) Engineering & Capital Projects 501,989 53,528 401,350 13.3%411,500 (448,461) Library 837,200 765,180 898,635 85.1%994,410 (72,020) Police 8,193,532 8,162,887 8,545,230 95.5%9,493,905 (30,645) Fire 7,346,535 7,250,168 7,468,765 97.1%8,298,370 (96,367) Development Services 897,704 948,089 933,455 101.6%1,039,550 50,385 Total Expenditures 21,326,851$ 20,480,673$ 22,093,345$ 92.7%24,469,080$ (846,178)$ Five Year Trend For the Period Ending November 30, 2020 General Fund - Five Year Trend Village of Oak Brook Revenues Expenditures 11/30/20 11/30/20 11/30/19 11/30/20 YTD % of YTD 2020 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Hotel Tax 1,206,553$ 472,355$ 1,113,300$ 42.4%1,212,500$ (734,198)$ Investment Interest 103,457 64,690 68,750 94.1%75,000 (38,767) Loan Interest - 4,167 - N/A - 4,167 Miscellaneous - 16,359 - N/A - 16,359 Total Operating Revenues 1,310,010$ 557,571$ 1,182,050$ 47.2%1,287,500$ (752,439)$ EXPENDITURES Operation and Contract 515,974$ 360,235$ 638,580$ 56.4%576,615$ (155,739)$ Capital Outlay - 473,243 530,395 89.2%640,395 473,243 Total Expenditures 515,974$ 833,478$ 1,168,975$ 71.3%1,217,010$ 317,504$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 794,036$ (275,907)$ 13,075$ -2110.2%70,490$ (1,069,943)$ INTERFUND TRANSACTIONS Transfer Out -$ -$ (257,825)$ 0.0%(338,125)$ -$ Reimbursements to Other Funds (94,523) (68,486) (68,475) 100.0%(74,715) 26,037 Total Interfund Transactions (94,523)$ (68,486)$ (326,300)$ 21.0%(412,840)$ 26,037$ NET FUND INCREASE (DECREASE)699,513$ (344,393)$ (313,225)$ (342,350)$ (1,043,906)$ Note - Expenditures are recorded in program 171. Village of Oak Brook Hotel Tax Fund Financial Update For the Period Ending November 30, 2020 Total Total Revenues Expenditures 11/30/20 Actual $ 557,571 833,478$ 11/30/19 Actual $ 1,310,010 515,974$ % Change From Last Year -57.4%61.5% Major Revenues Investment Hotel Tax Interest Loan Interest Miscellaneous 11/30/20 Actual $ 472,355 $ 64,690 4,167$ 16,359$ 11/30/19 Actual $ 1,206,553 $ 103,457 -$ -$ % Change From Last Year -60.9%-37.5%N/A N/A Five Year Trend Major Expenditures Operation & Contractual Capital Outlay 11/30/20 Actual 360,235$ 473,243$ 11/30/19 Actual 515,974$ -$ % Change From Last Year -30.2%N/A Five Year Trend Village of Oak Brook Hotel Tax Fund - Major Sources Five Year Trend For the Period Ending November 30, 2020 Five Year Trend Revenues Expenditures 11/30/20 11/30/20 11/30/19 11/30/20 YTD % of YTD 2020 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Sales Tax 5,207,688$ 4,471,523$ 5,173,000$ 86.4%5,615,000$ (736,165)$ Charges for Services 1,365 335 935 35.8%1,000 (1,030) Investment Interest 203,010 78,812 114,565 68.8%125,000 (124,198) Miscellaneous - 144 2,310 6.2%2,500 144 Total Operating Revenues 5,412,063$ 4,550,814$ 5,290,810$ 86.0%5,743,500$ (861,249)$ OPERATING EXPENDITURES Personnel 1,161,232$ 1,157,621$ 1,230,235$ 94.1%1,389,540$ (3,611)$ Materials and Supplies 132,061 136,878 199,475 68.6%253,295 4,817 Operation and Contract 1,420,732 1,204,108 1,722,680 69.9%1,856,790 (216,624) Capital Outlay 3,761,386 3,616,303 9,395,270 38.5%10,220,090 (145,083) Total Operating Expenditures 6,475,411$ 6,114,910$ 12,547,660$ 48.7%13,719,715$ (360,501)$ SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES (1,063,348)$ (1,564,096)$ (7,256,850)$ 21.6%(7,976,215)$ (500,748)$ INTERFUND TRANSACTIONS Transfers In 216,125$ 666,289$ 1,572,825$ 42.4%1,653,125$ 450,164$ Reimbursements From Other Funds 305,657 329,428 329,450 100.0%359,380 23,771 Reimbursements To Other Funds (148,071) (148,775) (148,775) 100.0%(162,300) (704) Total Interfund Transactions 373,711$ 846,942$ 1,753,500$ 48.3%1,850,205$ 473,231$ NET FUND INCREASE (DECREASE)(689,637)$ (717,154)$ (5,503,350)$ (6,126,010)$ (27,517)$ Village of Oak Brook Infrastructure Fund Financial Update For the Period Ending November 30, 2020 Total Total Revenues Expenditures 11/30/20 Actual $ 4,550,814 6,114,910$ 11/30/19 Actual $ 5,412,063 6,475,411$ % Change From Last Year -15.9%-5.6% Major Revenues Sales Tax Charges for Services Investment Interest Miscellaneous 11/30/20 Actual $ 4,471,523 $ 335 $ 78,812 $ 144 11/30/19 Actual $ 5,207,688 $ 1,365 $ 203,010 $ - % Change From Last Year -14.1%-75.5%-61.2%N/A Five Year Trend Major Expenditures Materials &Operation & Personnel Supplies Contractual Capital Outlay 11/30/20 Actual 1,157,621$ 136,878$ 1,204,108$ 3,616,303$ 11/30/19 Actual 1,161,232$ 132,061$ 1,420,732$ 3,761,386$ % Change From Last Year -0.3%3.6%-15.2%-3.9% Five Year Trend Expenditures by Department 11/30/19 11/30/20 11/30/20 11/30/20 2020 Difference Five YTD YTD YTD % of Annual Prior Year Actual Actual Budget Budget Budget Year Trend Legislative & General Management 146,091$ 128,250$ 162,040$ 79.1%176,490$ (17,841)$ Public Works 3,338,099 3,650,787 4,135,935 88.3%4,390,810 312,688 Engineering & Capital Projects 2,991,221 2,335,873 8,249,685 28.3%9,152,415 (655,348) Total Expenditures 6,475,411$ 6,114,910$ 12,547,660$ 48.7%13,719,715$ (360,501)$ Five Year Trend Village of Oak Brook Infrastructure Fund - Major Sources Five Year Trend For the Period Ending November 30, 2020 Revenues Expenditures 11/30/20 11/30/20 11/30/19 11/30/20 YTD % of YTD 2020 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Sales Tax 65,184$ 55,493$ 71,250$ 77.9%95,000$ (9,691)$ Real Estate Tax 412,066 414,544 380,000 109.1%380,000 2,478 Investment Interest 1,960 525 1,375 38.2%1,500 (1,435) Total Operating Revenues 479,210$ 470,562$ 452,625$ 104.0%476,500$ (8,648)$ EXPENDITURES Operation and Contract 3,748$ 4,303$ 3,890$ 110.6%3,890$ 555$ Other Expenditures 460,980 529,900 504,900 105.0%504,900 68,920 Total Expenditures 464,728$ 534,203$ 508,790$ 105.0%508,790$ 69,475$ NET FUND INCREASE (DECREASE)14,482$ (63,641)$ (56,165)$ (32,290)$ (78,123)$ Note - Expenditures are recorded in program 283. Village of Oak Brook Promenade TIF Fund Financial Update For the Period Ending November 30, 2020 Total Total Revenues Expenditures 11/30/20 Actual $ 470,562 534,203$ 11/30/19 Actual $ 479,210 464,728$ % Change From Last Year -1.8%14.9% Major Revenues Real Estate Investment Sales Tax Tax Interest 11/30/20 Actual 55,493$ $ 414,544 $ 525 11/30/19 Actual 65,184$ $ 412,066 $ 1,960 % Change From Last Year -14.9%0.6%-73.2% Five Year Trend Major Expenditures Operation &Other Contractual Expenditures 11/30/20 Actual 4,303$ 529,900$ 11/30/19 Actual 3,748$ 460,980$ % Change From Last Year 14.8%15.0% Five Year Trend Village of Oak Brook Promenade TIF Fund - Major Sources Five Year Trend For the Period Ending November 30, 2020 Five Year Trend Revenues Expenditures 11/30/20 11/30/20 11/30/19 11/30/20 YTD % of YTD 2020 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Plan Review Fees 1,350$ 1,050$ 1,100$ 95.5%1,200$ (300)$ Building/Inspection Fees 6,488 5,887 7,315 80.5%8,000 (601) Water Sales 9,229,807 9,531,573 9,939,000 95.9%10,302,525 301,766 Unmetered Sales 42,792 82,626 27,500 300.5%30,000 39,834 Water Connection Fees 173,410 22,120 91,685 24.1%100,000 (151,290) Meter Charges 25,767 15,082 18,335 82.3%20,000 (10,685) Special Services 32,975 24,169 30,000 80.6%30,000 (8,806) Investment Interest 160,776 89,809 119,185 75.4%130,000 (70,967) Miscellaneous 59,487 21,449 68,750 31.2%75,000 (38,038) Total Operating Revenues 9,732,852$ 9,793,765$ 10,302,870$ 95.1%10,696,725$ 60,913$ OPERATING EXPENDITURES Personnel 717,032$ 685,423$ 776,170$ 88.3%868,705$ (31,609)$ Materials and Supplies 54,908 34,696 68,910 50.3%74,260 (20,212) Operation and Contract 4,342,992 4,373,696 5,353,045 81.7%5,833,755 30,704 Capital Outlay 3,236,350 3,161,756 5,531,555 57.2%6,293,225 (74,594) Total Expenditures 8,351,282$ 8,255,571$ 11,729,680$ 70.4%13,069,945$ (95,711)$ Surplus (Deficit) of Revenues Over Expenditures 1,381,570$ 1,538,194$ (1,426,810)$ -107.8%(2,373,220)$ 156,624$ INTERFUND TRANSACTIONS Transfers In 221,085$ -$ -$ 0.0%-$ (221,085) Reimbursements To Other Funds (505,846) (482,911) (482,900) 100.0%(526,815) 22,935 Total Interfund Transactions (284,761)$ (482,911)$ (482,900)$ 100.0%(526,815)$ (198,150)$ Fund Increase/(Decrease) - Budgetary Basis 1,096,809$ 1,055,283$ (1,909,710)$ -55.3%(2,900,035)$ (41,526)$ ADUSTMENTS TO GAAP BASIS* Remove Capital Outlay 3,236,350$ 3,161,756$ Depreciation Expense (469,430) (527,083) IMRF Pension Expense 70,800 45,833 OPEB Expense (44,940) (41,250) Total GAAP Adjustments 2,792,781$ 2,639,256$ Fund Increase/(Decrease) - GAAP Basis 3,889,590$ 3,694,539$ *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 November 30, 2020 Total Total Revenues Expenditures 11/30/20 Actual $ 9,793,765 8,255,571$ 11/30/19 Actual $ 9,732,852 8,351,282$ % Change From Last Year 0.6%-1.1% Unmetered Water Water Sales Sales Connection Fees Meter Charges Miscellaneous 11/30/20 Actual $ 9,531,573 $ 82,626 $ 22,120 $ 15,082 $ 21,449 11/30/19 Actual $ 9,229,807 $ 42,792 $ 173,410 $ 25,767 $ 59,487 % Change From Last Year 3.3%93.1%-87.2%-41.5%-63.9% Five Year Trend Materials &Operation &Other Personnel Supplies Contractual Expenditures Capital Outlay 11/30/20 Actual 685,423$ 34,696$ 4,373,696$ -$ 3,161,756$ 11/30/19 Actual 717,032$ 54,908$ 4,342,992$ -$ 3,236,350$ % Change From Last Year -4.4%-36.8%0.7%0.0%-2.3% Five Year Trend Expenditures by Department 11/30/19 11/30/20 11/30/20 11/30/20 2020 Difference Five YTD YTD YTD % of Annual Prior Year Actual Actual Budget Budget Budget Year Trend Public Works 5,107,250$ 5,125,023$ 5,969,340$ 85.9%6,527,120$ 17,773$ Engineering & Capital Projects 3,244,032 3,130,548 5,760,340 54.3%6,542,825 (113,484) Total Expenditures 8,351,282$ 8,255,571$ 11,729,680$ 70.4%13,069,945$ (95,711)$ Five Year Trend Village of Oak Brook Water Fund - Major Sources Five Year Trend For the Period Ending November 30, 2020 Revenues Expenditures Village of Oak Brook Monthly Operating Statement Sports Core Fund Consolidated Presentation For the Period Ending November 30, 2020 11/30/20 11/30/20 11/30/20 YTD % of YTD 2020 11/30/19 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 199$ -$ -$ 226,488$ 226,687$ 459,135$ 49.4%459,135$ 419,681$ (192,994)$ Greens Fees - - - 1,111,776 1,111,776 930,000 119.5%930,000 912,148 199,628 Pro Shop Sales - - - 178,102 178,102 206,500 86.2%207,000 199,410 (21,308) Golf Lessons - - - 41,580 41,580 40,000 104.0%40,000 33,726 7,854 Driving Range Fees - - - 259,116 259,116 235,000 110.3%244,000 235,405 23,711 Rentals - 100,040 20,402 369,449 489,891 936,475 52.3%962,000 920,763 (430,872) Programs/User Fees - - - - - 66,300 0.0%66,300 68,815 (68,815) Food Sales - - - 162,974 162,974 180,500 90.3%180,500 182,186 (19,212) Beverage Sales - - - 356,936 356,936 263,815 135.3%265,000 268,107 88,829 Taste of Oak Brook - - - - - 120,000 0.0%120,000 - - Grants - - - - - 139,800 0.0%139,800 - - Other Revenue 1,588 - - 5,194 6,782 10,980 61.8%11,000 136,285 (129,503) Total Operating Revenues 1,787$ 100,040$ 20,402$ 2,711,615$ 2,833,844$ 3,588,505$ 79.0%3,624,735$ 3,376,526$ (542,682)$ OPERATING EXPENDITURES Personnel 56,776$ -$ 97,283$ 1,244,979$ 1,399,038$ 1,482,115$ 94.4%1,578,100$ 1,474,654$ (75,616)$ Materials & Supplies 3,762 119 1,758 550,008 555,647 608,165 91.4%618,025 639,857 (84,210) Operational & Contractual 75,681 24,264 51,702 276,915 428,562 1,038,970 41.2%1,055,095 923,607 (495,045) Other - - - - - (83,150) 0.0%(83,150) - - Capital 437,577 9,421 145,072 459,663 1,051,733 1,821,500 57.7%1,921,545 1,151,429 (99,696) Total Operating Expenditures 573,796$ 33,804$ 295,815$ 2,531,565$ 3,434,980$ 4,867,600$ 70.6%5,089,615$ 4,189,547$ (754,567)$ B&T Administration Overhead Allocation*96,807$ -$ (96,807)$ -$ -$ -$ 0.0%-$ -$ -$ Operating Revenues Over (Under) Expenditures (475,202)$ 66,236$ (372,220)$ 180,050$ (601,136)$ (1,279,095)$ 47.0%(1,464,880)$ (813,021)$ 211,885$ INTERFUND TRANSACTIONS Transfer From General Fund 326,369$ -$ -$ -$ 326,369$ 923,000$ 35.4%923,000$ 704,518$ (378,149)$ Transfer From Hotel Tax Fund - - - - - 35,000 0.0%35,000 - - Transfer From Golf Surcharge Fund - - - 340,065 340,065 400,000 85.0%400,000 212,969 127,096 Reimbursement From Infrastructure Fund 22,000 - - - 22,000 22,000 100.0%24,000 22,000 - Reimbursement From Water Fund 7,337 - - - 7,337 7,315 100.3%8,000 7,337 - Reimbursement To General Fund (25,872) - - (25,872) (51,744) (51,700) 100.1%(56,450) - (51,744) Total Interfund Transactions 329,834$ -$ -$ 314,193$ 644,027$ 1,335,615$ 48.2%1,333,550$ 946,824$ (302,797)$ Total Revenues Over (Under) Expenditures - Budgetary Basis (145,368)$ 66,236$ (372,220)$ 494,243$ 42,891$ 56,520$ (131,330)$ 133,803$ (90,912)$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay 437,577$ 9,421$ 145,072$ 459,663$ 1,051,733$ 1,151,429$ Depreciation Expense (137,411) (1,545) (32,083) (194,333) (365,372) (301,023) IMRF Pension Expense (4,813) (229) (1,833) (10,863) (17,738) 85,040 OPEB Expense - - (4,767) (36,667) (41,433) (18,365) Total GAAP Adjustments 295,353$ 7,647$ 106,389$ 217,801$ 627,190$ 917,080$ Fund Increase/(Decrease) - GAAP Basis 149,985$ 73,883$ (265,831)$ 712,044$ 670,081$ 1,050,883$ *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 11/30/20 Actual $ 2,833,844 3,434,980$ 11/30/19 Actual $ 3,376,526 4,189,547$ % Change From Last Year -16.1%-18.0% Driving Program/ Memberships Greens Fees Range Fees Rentals User Fees 11/30/20 Actual $ 226,687 $ 1,111,776 $ 259,116 $ 489,891 -$ 11/30/19 Actual $ 419,681 $ 912,148 $ 235,405 $ 920,763 68,815$ % Change From Last Year -46.0%21.9%10.1%-46.8%-100.0% Five Year Trend Materials &Operation &Other Personnel Supplies Contractual Expenditures Capital Outlay 11/30/20 Actual 1,399,038$ 555,647$ 428,562$ -$ 1,051,733$ 11/30/19 Actual 1,474,654$ 639,857$ 923,607$ -$ 1,151,429$ % Change From Last Year -5.1%-13.2%-53.6%0.0%-8.7% Five Year Trend Revenues by Department 11/30/19 11/30/20 11/30/20 11/30/20 2020 Difference Five YTD YTD YTD % of Annual Prior Year Actual Actual Budget Budget Budget Year Trend B&T Recreation Operations 357,084$ 1,787$ 506,715$ 0.4%506,735$ (300,388)$ Open Field Operations 357,688 100,040 404,500 24.7%407,000 (257,648) B&T Clubhouse Operations 338,264 20,402 270,000 7.6%300,000 (317,862) Golf Club 2,323,490 2,711,615 2,407,290 112.6%2,411,000 388,125 Total Revenues 3,376,526$ 2,833,844$ 3,588,505$ 79.0%3,624,735$ (487,773)$ Expenditures by Department 11/30/19 11/30/20 11/30/20 % of YTD 2020 Difference Five YTD YTD YTD % of Annual Prior Year Actual Actual Budget Budget Budget Year Trend B&T Recreation Operations 1,073,035$ 573,796$ 1,648,370$ 34.8%1,752,045$ (499,239)$ Open Field Operations 153,853$ 33,804$ 266,235$ 12.7%267,110$ (120,049)$ B&T Clubhouse Operations 587,132 295,815 437,765 67.6%458,770 (291,317) Golf Club 2,375,527 2,531,565 2,515,230 100.6%2,611,690 156,038 Total Expenditures 4,189,547$ 3,434,980$ 4,867,600$ 70.6%5,089,615$ (754,567)$ Five Year Trend Village of Oak Brook Sports Core Fund - Major Sources Five Year Trend For the Period Ending November 30, 2020 Revenues Expenditures Village of Oak Brook Monthly Operating Statement Bath & Tennis Club Recreation Operations For the Period Ending November 30, 2020 11/30/20 11/30/20 822 11/30/20 YTD % of YTD 2020 11/30/19 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 -$ 199$ -$ -$ 199$ 241,635$ 0.1%241,635$ 222,006$ (221,807)$ Programs/User Fees - - - - - 66,300 0.0%66,300 68,815 (68,815) Food Sales - - - - - 36,000 0.0%36,000 35,375 - Beverage Sales - - - - - 20,000 0.0%20,000 19,534 - Grants - - - - - 139,800 0.0%139,800 - - Other Revenue 1,588 - - - 1,588 2,980 53.3%3,000 11,354 (9,766) Total Operating Revenues 1,588$ 199$ -$ -$ 1,787$ 506,715$ 0.4%506,735$ 357,084$ (300,388)$ OPERATING EXPENDITURES Personnel 56,460$ -$ -$ 316$ 56,776$ 161,655$ 35.1%163,580$ 139,942$ (83,166)$ Materials & Supplies 562 2,165 1,035 - 3,762 57,550 6.5%57,650 70,175 (66,413) Operational & Contractual 61,498 6,914 7,269 - 75,681 416,665 18.2%418,270 412,961 (337,280) Capital 50,814 386,669 94 - 437,577 1,012,500 43.2%1,112,545 449,957 (12,380) Total Operating Expenditures 169,334$ 395,748$ 8,398$ 316$ 573,796$ 1,648,370$ 34.8%1,752,045$ 1,073,035$ (499,239)$ B&T Administration Overhead Allocation*193,616$ (69,702)$ (19,362)$ (7,745)$ 96,807$ 91,645$ 105.6%93,235$ 102,927$ (6,120)$ Operating Revenues Over (Under) Expenditures 25,870$ (465,251)$ (27,760)$ (8,061)$ (475,202)$ (1,050,010)$ 45.3%(1,152,075)$ (613,024)$ 192,731$ INTERFUND TRANSACTIONS Transfer From General Fund -$ 326,369$ -$ -$ 326,369$ 757,500$ 43.1%757,500$ 419,019$ (92,650)$ Reimbursement From Infrastructure Fund 22,000 - - - 22,000 22,000 100.0%24,000 22,000 - Reimbursement From Water Fund 7,337 - - - 7,337 7,315 100.3%8,000 7,337 - Reimbursement To General Fund (25,872) - - - (25,872) (25,850) 100.1%(28,225) - (25,872) Total Interfund Transactions 3,465$ 326,369$ -$ -$ 329,834$ 760,965$ 43.3%761,275$ 448,356$ (118,522)$ Total Revenues Over (Under) Expenditures - Budgetary Basis 29,335$ (138,882)$ (27,760)$ (8,061)$ (145,368)$ (289,045)$ (390,800)$ (164,668)$ 74,209$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay 50,814$ 386,669$ 94$ -$ 437,577$ 449,957$ Depreciation Expense - (131,757) (4,583) (1,071) (137,411) (86,922) IMRF Pension Expense (4,583) - - (229) (4,813) 5,591 Total GAAP Adjustments 46,231$ 254,912$ (4,489)$ (1,300)$ 295,353$ 368,626$ Fund Increase/(Decrease) - GAAP Basis 75,566$ 116,030$ (32,249)$ (9,361)$ 149,985$ 203,958$ *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 November 30, 2020 11/30/20 11/30/20 11/30/20 YTD % of YTD 2020 11/30/19 Difference 815 816 YTD Amended Amended Adopted YTD Prior Polo Open Fields Total Budget Budget Budget Total Year OPERATING REVENUES Field Rentals -$ 25,040$ 25,040$ 209,500$ 12.0%212,000$ 167,948$ (142,908)$ Range Rentals - 75,000 75,000 75,000 100.0%75,000 75,000 - Taste of Oak Brook - - - 120,000 0.0%120,000 - - Other Revenue - - - - 0.0%- 114,740 (114,740) Total Operating Revenues -$ 100,040$ 100,040$ 404,500$ 24.7%407,000$ 357,688$ (257,648)$ OPERATING EXPENDITURES Personnel -$ -$ -$ 10,810$ 0.0%10,810$ 8,890$ (8,890)$ Materials & Supplies - 119 119 1,700 7.0%1,700 1,375 (1,256) Operational & Contractual - 24,264 24,264 238,725 10.2%239,600 128,968 (104,704) Capital - 9,421 9,421 15,000 62.8%15,000 14,620 (5,199) Total Operating Expenditures -$ 33,804$ 33,804$ 266,235$ 12.7%267,110$ 153,853$ (120,049)$ Operating Revenues Over (Under) Expenditures -$ 66,236$ 66,236$ 138,265$ 47.9%139,890$ 203,835$ (137,599)$ INTERFUND TRANSACTIONS Transfer From Hotel Tax Fund -$ -$ -$ 35,000$ 0.0%35,000$ -$ -$ Total Interfund Transactions -$ -$ -$ 35,000$ 0.0%35,000$ -$ -$ Total Revenues Over (Under) Expenditures - Budgetary Basis -$ 66,236$ 66,236$ 173,265$ 174,890$ 203,835$ (137,599)$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay -$ 9,421$ 9,421$ 14,620$ Depreciation Expense - (1,545) (1,545) (1,545) IMRF Pension Expense - (229) (229) 674 Total GAAP Adjustments -$ 7,647$ 7,647$ 13,749$ Fund Increase/(Decrease) - GAAP Basis -$ 73,883$ 73,883$ 217,584$ *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 November 30, 2020 11/30/20 11/30/20 821 YTD % of YTD 2020 11/30/19 Difference B&T Amended Amended Adopted YTD Prior Clubhouse Budget Budget Budget Total Year OPERATING REVENUES Rentals 20,402$ 270,000$ 7.6%300,000$ 338,264$ (317,862)$ Total Operating Revenues 20,402$ 270,000$ 7.6%300,000$ 338,264$ (317,862)$ OPERATING EXPENDITURES Personnel 97,283$ 126,605$ 76.8%140,045$ 120,822$ (23,539)$ Materials & Supplies 1,758 18,210 9.7%20,225 19,892 (18,134) Operational & Contractual 51,702 103,950 49.7%109,500 88,866 (37,164) Capital 145,072 189,000 76.8%189,000 357,552 (212,480) Total Operating Expenditures 295,815$ 437,765$ 67.6%458,770$ 587,132$ (291,317)$ B&T Administration Overhead Allocation*(96,807)$ (91,645)$ 105.6%(93,235)$ (102,927)$ 6,120$ Operating Revenues Over (Under) Expenditures (372,220)$ (259,410)$ 143.5%(252,005)$ (351,795)$ (20,425)$ INTERFUND TRANSACTIONS Transfer From General Fund -$ 165,500$ 0.0%165,500$ 285,499$ (285,499)$ Total Interfund Transactions -$ 165,500$ 0.0%165,500$ 285,499$ (285,499)$ Total Revenues Over (Under) Expenditures - Budgetary Basis (372,220)$ (93,910)$ (86,505)$ (66,296)$ (305,924)$ ADUSTMENTS TO GAAP BASIS** Remove Capital Outlay 145,072$ 357,552$ Depreciation Expense (32,083) (29,472) IMRF Pension Expense (1,833) 6,141 OPEB Expense (4,767) (1,925) Total GAAP Adjustments 106,389$ 332,296$ Fund Increase/(Decrease) - GAAP Basis (265,831)$ 266,000$ *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 November 30, 2020 11/30/20 11/30/20 823 831 832 833 834 11/30/20 YTD % of YTD 2020 11/30/19 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 -$ 226,488$ -$ -$ -$ 226,488$ 217,500$ 104.1%217,500$ 197,675$ 28,813$ Greens Fees - 1,111,776 - - - 1,111,776 930,000 119.5%930,000 912,148 199,628 Pro Shop Sales - 178,102 - - - 178,102 206,500 86.2%207,000 199,410 (21,308) Golf Lessons - 41,580 - - 41,580 40,000 104.0%40,000 33,726 7,854 Driving Range Fees - 259,116 - - 259,116 235,000 110.3%244,000 235,405 23,711 Rentals - 350 9,000 360,099 - 369,449 381,975 96.7%375,000 339,551 29,898 Food Sales 162,974 - - - 162,974 144,500 112.8%144,500 146,811 16,163 Beverage Sales 356,936 - - - 356,936 243,815 146.4%245,000 248,573 108,363 Other Revenue - 5,194 - - - 5,194 8,000 64.9%8,000 10,191 (4,997) Total Operating Revenues 519,910$ 1,521,910$ 309,696$ 360,099$ -$ 2,711,615$ 2,407,290$ 112.6%2,411,000$ 2,323,490$ 388,125$ OPERATING EXPENDITURES Personnel 173,773$ 463,192$ 79,096$ 47,071$ 481,847$ 1,244,979$ 1,183,045$ 105.2%1,263,665$ 1,205,000$ 39,979$ Materials & Supplies 211,788 146,470 11,638 1,351 178,761 550,008 530,705 103.6%538,450 548,415 1,593 Operational & Contractual 5,680 175,044 121 54,599 41,471 276,915 279,630 99.0%287,725 292,812 (15,897) Other - - - - - - (83,150) 0.0%(83,150) - - Capital 12,059 359,897 - - 87,707 459,663 605,000 76.0%605,000 329,300 130,363 Total Operating Expenditures 403,300$ 1,144,603$ 90,855$ 103,021$ 789,786$ 2,531,565$ 2,515,230$ 100.6%2,611,690$ 2,375,527$ 156,038$ Operating Revenues Over (Under) Expenditures 116,610$ 377,307$ 218,841$ 257,078$ (789,786)$ 180,050$ (107,940)$ -166.8%(200,690)$ (52,037)$ 232,087$ INTERFUND TRANSACTIONS Transfer from Golf Surcharge -$ 340,065$ -$ -$ -$ 340,065$ 400,000$ 85.0%400,000$ 212,969$ 127,096$ Reimbursement to General Fund - (25,872) - - - (25,872) (25,850) 100.1%(28,225) - (25,872) Total Interfund Transactions -$ 314,193$ -$ -$ -$ 314,193$ 374,150$ 84.0%371,775$ 212,969$ 101,224$ Total Revenues Over (Under) Expenditures - Budgetary Basis 116,610$ 691,500$ 218,841$ 257,078$ (789,786)$ 494,243$ 266,210$ 171,085$ 160,932$ 333,311$ ADUSTMENTS TO GAAP BASIS* Remove Capital Outlay 12,059$ 359,897$ -$ -$ 87,707$ 459,663$ 329,300$ Depreciation Expense - (123,750) (3,667) (21,083) (45,833) (194,333) (183,085) IMRF Pension Expense (1,375) (4,583) (321) - (4,583) (10,863) 72,635 OPEB Expense (2,750) (21,083) - - (12,833) (36,667) (16,440) Total GAAP Adjustments 7,934$ 210,480$ (3,988)$ (21,083)$ 24,457$ 217,801$ 202,410$ Fund Increase/(Decrease) - GAAP Basis 124,544$ 901,980$ 214,854$ 235,995$ (765,329)$ 712,044$ 363,342$ *Estimates based on historical year-end audit adjustments. Actual amounts are not measured and recorded until the end of the year.