02 - February 2019 Monthly Financial ReportVILLAGE
OAK BROOK
OF
MONTHLY FINANCIAL REPORTS
FEBRUARY 2019
ITEM 6.D
Total
Cash and Cash Pooled Cash and
Fund Equivalents Investments Investments % By Fund
General Corporate $4,356,491 $13,888,121 $18,244,612 42.4%
Hotel/Motel Tax 2,670,114 2,101,048 4,771,162 11.1%
Motor Fuel Tax 650,270 169,276 819,546 1.9%
Infrastructure 7,060,756 2,838,684 9,899,440 23.0%
Promenade TIF 26,694 - 26,694 0.1%
Water 4,594,444 2,553,726 7,148,170 16.6%
Sports Core - - - 0.0%
Golf Surcharge 338 383,613 383,951 0.9%
Self-Insurance 732,573 - 732,573 1.7%
Garage 382,404 - 382,404 0.9%
Equipment Replacement 156,086 507,937 664,023 1.5%
Total $20,630,170 $22,442,405 $43,072,575 100.0%
Change in Cash and Investments by Fund :
Balance at Balance at Year-to-Date Year-to-Date
Fund January 1, 2019 February 28, 2019 Change ($)Change (%)
General Corporate $18,092,186 $18,244,612 $152,426 0.8%
Hotel/Motel Tax 4,843,367 4,771,162 (72,205)-1.5%
Motor Fuel Tax 782,203 819,546 37,343 4.8%
Infrastructure 9,322,381 9,899,440 577,059 6.2%
Promenade TIF 257,485 26,694 (230,791)-89.6%
Water 6,449,315 7,148,170 698,855 10.8%
Sports Core 190,397 - (190,397)-100.0%
Golf Surcharge 442,152 383,951 (58,201)-13.2%
Self-Insurance 468,568 732,573 264,005 56.3%
Garage 331,134 382,404 51,270 15.5%
Equipment Replacement 1,636,238 664,023 (972,215)-59.4%
$42,815,426 $43,072,575 $257,149 0.6%
Book Market
Value Value
Pooled Checking $174,056 $174,056
Sports Core Checking 75,745 75,745
Pooled IPTIP 20,184,379 20,184,379
Water E-Pay IPTIP 195,990 195,990
$20,630,170 $20,630,170
Pooled Investments:
Investments-Municipal Bonds $7,015,957 $6,942,190
Investments-Corporate Bonds 7,881,614 7,885,961
Government & Agency Obligations 691,857 663,441
Certificates of Deposit 6,720,000 6,694,688
Accrued Interest 132,977 132,977
Total Pooled Investments $22,442,405 $22,319,257
Total Cash and Investments $43,072,575 $42,949,427
For February, total interest revenue is $82,399 and YTD revenue is $166,785.
Total investment yield for the portfolio is:
Pooled
Investments Illinois Funds Total
Monthly yield 0.20%0.20%0.20%
YTD yield 0.39%0.41%0.40%
Last 12 months yield 2.03%2.09%2.06%
The weighted average yield of the current pooled investment portfolio is 2.34%.
Monthly Treasurer's Report
February 28, 2019
Monthly Treasurer's Report
February 2019
The table below lists the detail investment holdings at J.P. Morgan Securities as of 2/28/19:
Month End VOB
Settlement Maturity Coupon Yield Book Market Accrued
Type Date Date Rate Rate Value Value Interest
Municipal Bonds:
Maryland St Econ Dev #57420PGK6 07/08/15 06/01/19 2.050%2.123%$99,981 $99,853 $511
Rosemont IL GO Corp #777543UT4 02/08/16 12/01/19 3.021%2.000%503,738 498,255 3,680
New York N Y City #64971QTX1 02/22/16 05/01/21 2.350%2.000%201,467 197,776 1,552
Florida Hurricane #34074GDH4 03/30/16 07/01/20 2.995%2.150%505,457 499,990 2,495
Bloomingdale Mich Pub Sch Dist #094383FS0 04/26/16 05/01/22 2.710%2.150%508,500 495,625 4,478
Milan Mich Area Achs #598801JD1 05/26/16 05/01/20 1.931%1.931%245,000 242,793 1,476
Indiana Bd Bk Rev Taxable #4546248F7 01/06/17 01/15/20 2.934%1.900%257,242 255,451 970
Garland Cnty Ark Sales & Use #36609PAN3 02/06/17 11/01/19 1.795%1.840%499,849 497,025 3,116
Anchor Bay Mich Sch Dist GO #032879TA6 02/13/17 05/01/19 1.810%1.420%365,240 364,507 2,125
Lanse Creuse Mich Pub Schs #516228RL9 05/02/17 05/01/20 2.159%2.159%100,000 99,334 717
California St GO Bonds #13063A7G3 05/08/17 10/01/19 6.200%1.600%513,360 510,220 12,635
*Genesee Cnty Mich #371608UV0 05/31/17 10/01/19 2.681%2.681%129,000 128,994 187
Connecticut St GO Bds 2016 #20772J3F7 06/15/17 08/15/21 1.750%2.300%493,468 481,205 336
North Carolina Eastn Mun Pwr #65819WAL7 10/02/17 07/01/19 2.578%1.700%501,468 499,615 2,005
Fowlerville Mich Comnty Schs #351280MS8 10/03/17 05/01/20 2.045%1.750%501,706 496,365 3,238
Racine Cnty WI #749845UK7 12/20/17 12/01/20 2.150%2.150%750,000 739,020 4,031
Wisconsin St Gen Fd Annual #977100CW4 01/05/18 05/01/20 1.446%2.100%595,470 591,162 2,796
Illinois St G/O #452152HU8 04/03/18 03/01/19 5.877%3.000%245,011 245,000 7,079
Total Municipal Bonds $7,015,957 $6,942,190 $53,427
Corporate Bonds:
Huntington National Bank #446438RG0 07/06/18 04/01/19 2.200%2.541%699,791 699,776 6,374
Bank of America #06051GFD6 07/06/18 04/01/19 2.650%2.509%750,091 749,970 7,840
KeyBank #49327M2N3 07/19/18 03/08/19 2.350%2.490%844,967 844,958 9,487
Bank of America #06051GFD6 07/30/18 04/01/19 2.650%2.420%245,040 244,990 2,705
Goldman Sachs #38141GVP9 09/26/18 09/15/20 2.750%3.180%496,794 497,750 6,302
Fifth Third #31677QBH1 10/11/18 09/27/19 1.625%2.750%993,680 993,290 6,951
JP Morgan #46640QUV1 11/01/18 07/29/19 0.000%3.017%1,481,496 1,483,132 0
Wells Fargo #94974BGR5 01/15/19 12/07/20 2.550%3.120%1,376,520 1,379,255 8,566
SunTrust #86787EAU1 01/28/19 01/29/21 2.590%3.050%497,984 498,075 1,079
PNC Bank #69353RFH6 01/30/19 01/22/21 2.500%3.020%495,251 494,765 1,354
Total Corporate Bonds $7,881,614 $7,885,961 $50,658
Government & Agency Obligations:
**Government National Mtg Assn #38379UEM4 02/29/16 02/16/51 2.300%2.245%$691,857 $663,441 $2,132
Total Government & Agency Obligations:$691,857 $663,441 $2,132
Certificates of Deposit:
State Bk India NY #8562846A7 01/26/17 01/26/22 2.250%2.250%$245,000 $241,009 $536
Marlin Bank #57116ANU8 05/10/17 11/12/19 1.610%1.610%245,000 243,645 205
American Express Fed Svgs #02587CER7 05/10/17 11/12/19 1.700%1.700%245,000 243,814 1,267
Synchrony Bank #87164WRA8 05/26/17 05/28/19 1.650%1.650%245,000 244,608 1,028
Umpqua Bank #90421MAG8 05/31/17 05/31/19 1.600%1.600%245,000 244,559 986
Stone Bk Mtn View Ark #86158RAJ8 06/28/17 06/28/19 1.600%1.600%245,000 244,427 4
TIAA FSB Jacksonville #87270LAA1 07/19/17 07/19/19 1.600%1.600%245,000 244,302 441
Peoples United Bank #71270QQZ2 07/19/17 07/19/19 1.650%1.650%245,000 244,348 455
Priority Bank Ozark Ark #74269KBR6 07/26/17 07/26/19 1.600%1.600%245,000 244,272 32
American Express Centurion #02587DV96 08/15/17 08/17/20 1.900%1.900%245,000 242,285 175
Sallie Mae #795450C86 08/16/17 08/17/20 1.900%1.900%245,000 242,530 175
Merrick Bank South Jordan #59013JZS1 08/21/17 08/21/20 1.800%1.800%245,000 242,153 104
Pinnacle Bank #72345SFS5 08/30/17 08/31/20 1.800%1.800%115,000 113,630 9
Jackson County Bank #466682AP6 08/31/17 03/01/21 1.850%1.850%245,000 240,943 19
Barclays Bank #06740KKX4 09/27/17 09/28/20 1.950%1.950%245,000 242,467 2,031
Capital One Bank #1404205E6 10/04/17 10/04/19 1.700%1.700%245,000 244,022 1,689
Transportation Alliance #89388CCB2 10/13/17 04/12/19 1.600%1.600%235,000 234,828 164
Goldman Sachs Bank #38148PRK5 10/18/17 10/19/20 1.950%1.950%245,000 242,327 1,752
FirstBank PR Santurce #33767A6M8 11/03/17 11/03/20 2.000%2.000%245,000 242,430 344
Morgan Stanley #61747MQ53 03/22/18 03/23/20 2.550%2.550%245,000 245,054 2,616
Investors Community Bank #46147UTT7 08/28/18 02/28/20 2.550%2.550%245,000 245,081 9
Lakeside Bank #51210SPS0 08/30/18 03/30/20 2.550%2.550%245,000 245,049 26
Bank United #066519GJ2 08/31/18 02/20/20 2.500%2.500%245,000 244,961 3,063
Compass Bank #20451PVW3 10/26/18 10/26/20 3.000%3.000%245,000 246,428 2,532
UBS Bank #90348JFH8 10/30/18 10/29/20 3.050%3.050%245,000 246,642 34
Citibank #17294XJP2 10/31/18 10/31/20 3.000%3.000%245,000 246,012 2,470
Discover Bank #254673WF9 11/07/18 11/09/20 3.000%3.000%245,000 246,431 2,307
Ally Bank #02007GFX6 11/08/18 11/09/20 3.000%3.000%245,000 246,431 2,287
Total Certificates of Deposits $6,720,000 $6,694,688 $26,760
Total J.P.Morgan Securities $22,309,428 $22,186,280 $132,977
*Interest rate is a floating rate that sets each month. Rate is determined at the one-month LIBOR rate plus 0.60%.
**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 2/16/2051 maturity date.
VILLAGE OF OAK BROOK
Monthly Treasurer's Report
February 28, 2019
Cash & Investments by Fund - Total $43.1 million
Cash & Investments by Type - Total $43.1 million
Checking
Illinois Funds
Certificates of Deposit
Municipal Bonds
Corporate Bonds
Government & Agency Obligations
Accrued Interest
General Corporate
42.36%
Hotel/Motel Tax
11.08%Motor Fuel Tax
1.90%
Infrastructure
22.98%
Promenade TIF
0.06%
Water
16.60%
Sports Core
0.00%
Golf Surcharge
0.89%
Self-Insurance
1.70%Garage
0.89%
Equipment
Replacement
1.54%
Checking, $0.3
Illinois Funds, $20.4
Certificates of Deposit,
$6.7
Municipal Bonds, $7.0
Corporate Bonds, $7.9
Government & Agency
Obligations, $0.7
Accrued Interest, $0.1
in millions
Village of Oak Brook
Monthly Financial Report – Fund Narrative
For the Period Ending February 28, 2019
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. 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 a cash basis.
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 February 2019 are $140,943 lower than last year, but $97,937 over
budget.
o Sales tax revenue, the General Fund’s largest revenue source, is up $223,321 from last
year and $228,203 over budget. This is due to general inflation and the reopening of
businesses in the mall.
o Licenses and permits revenue is down $422,625 from last year and $60,940 under
budget. The decrease is due to the receipt large building permit issued in January 2018
and the timing of permits to be issued in 2019.
Total expenditures through February 2019 are $906,244 higher than last year, but $411,955
under budget.
o Personnel expenditures are up $692,007 from last year, but $190,472 under budget.
The increase is due to January containing three payroll periods in 2019 vs. two periods
in 2018.
o Operation and contract expenditures are up $93,221 from last year, but $94,783 under
budget. This is due to the general timing of payments compared to when they were
projected to occur.
o Capital outlay expenditures are up $111,715 from last year, but $84,137 under budget.
The increase is due to the completion of the Fire Station 93 bunkroom and shower area
renovation work.
Hotel Tax Fund
Total revenues through February 2019 are $3,008 higher than last year and $20,407 over
budget.
o Hotel tax revenue is down $3,237 from last year, but $6,682 over budget. This is due to
the general timing of when receipts come in.
Total expenditures through February 2019 are $793 lower than last year and $408,812 under
budget.
o Operation and contract expenditures are up $30 from last year, but are $96,223 under
budget. Payments are still to come later in FY2019 as originally budgeted.
o Capital Outlay expenditures have not occurred to date, but are $312,595 under budget.
This is due to the timing of projects scheduled.
Motor Fuel Tax Fund
Total revenues through February 2019 are up $226 from last year and $3,384 over budget.
Motor Fuel Tax receipts are down slightly in 2019 compared to 2018, but increases in interest
income have offset the difference.
No Mother Fuel Tax transfers have been made in 2019 to date.
Infrastructure Fund
Total revenues through February 2019 are up $121,251 from last year and $129,155 over
budget.
o Non‐home rule sales tax revenue is up $105,339 from last year and $106,211 over
budget. This is primarily due to the reduction of the State’s administration fee from 2%
to 1.5% and the reopening of businesses in the mall.
o Interest income revenue is up $17,428 from last year and $23,774 over budget. This is
due to favorable market conditions and rising interest rates.
Total expenditures through February 2019 are up $141,605 from last year, but $1,054,116 under
budget.
o Personnel expenditures are up $57,209 from last year and $6,484 over budget. The
increase is due to January containing three payroll periods in 2019 vs. two periods in
2018.
o Operation and contract expenditures are up $26,878 from last year, but $106,957 under
budget. Expenditures are under budget due to the timing of engineering payments.
o Capital Outlay expenditures are up $44,108 from last year, but $966,673 under budget.
This is due to a delay in timing vs. when projects were originally expected to occur.
Promenade TIF Fund
Total revenues through February 2019 are up $140 from last year and $189 over budget. This is
due to an increase in interest revenue compared to last year.
Total expenditures through February 2019 are up $7,920 from last year and even with budget.
The increase relates to additional principal and interest paid towards the TIF note.
Water Fund
Total revenues through February 2019 are up $51,551 from last year, but $12,755 under budget.
o Water sales revenue is up $36,845 from last year, but $22,355 under budget. The
increase from last year is due to a 5% rate increase effective 1/1/19. Water gallons sold
has also been slightly less than projected so far this year.
Total expenditures through February 2019 are down $8,359 from last year and $778,241 under
budget.
o Operation and contract expenditures are down $68,424 from last year and $589,127
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 up $16,894 from last year, but $169,125 under budget.
This is due to a delay in timing vs. when projects were originally expected to occur.
Sports Core Fund
Total revenues through February 2019 are down $4,170 from last year and $6,484 under
budget. To date, only miscellaneous revenue sources have been received.
Total expenditures through February 2019 are up $75,409 from last year, but $39,876 under
budget.
o Personnel expenditures are up $40,155 from last year, but $12,439 under budget. The
increase is due to January containing three payroll periods in 2019 vs. two periods in
2018.
o Operation and Contractual expenditures are down $49,256 from last year and $54,633
under budget. This is due to the timing of pre‐season startup costs.
Golf Surcharge Fund
No Golf Surcharge money has been received or spent to date in 2019. A minimal amount of
interest has been received to date.
Self Insurance Fund
Total revenues through February 2019 are up $49,147 from last year and $3,274 over budget.
The increase is due to a rate increase effective 7/1/2018.
Total expenditures through February 2019 are down $266,409 from last year and $414,257
under budget. This is due to the timing of invoices paid and health claims coming in.
Garage Fund
Total revenues through February 2019 are up $54,153 from last year and $708 over budget.
This is due to a budgeted equipment replacement reserve balance transfer in 2019.
Total expenditures through February 2019 are up $36,948 from last year and $458 over budget.
This is due to an additional payroll date in 2019 vs. 2018 and the timing of vehicle maintenance
invoices being paid.
Equipment Replacement Fund
Total revenues through February 2019 are down $22,854 from last year, but $564 over budget.
This is due to a reduction in replacement contributions as a result of the switch to leasing
vehicles instead of purchasing.
Total expenditures through February 2019 are up $1,010,688 from last year, but $9,883 under
budget. This is due to a transfer of accumulated reserve funds to other funds.
YTD YTD
Net Fund Budgeted
YTD YTD Increase Increase
Governmental Funds Revenues Expenditures (Decrease)(Decrease)
General Fund (Major Fund)4,691,280 $4,489,448 $201,832 ($32,870)
Main operating fund of the Village.
Hotel Fund (Major Fund)$173,407 $17,263 $156,144 ($273,075)
Collects and spends resources from the
3% hotel/motel tax.
Motor Fuel Tax Fund $37,344 $0 $37,344 $33,960
Collects and spends resources from the
State motor fuel tax.
Infrastructure Fund (Major Fund)$1,307,434 $609,039 $698,395 ($484,870)
Accounts for construction and maintenance of
roadways, drainage, and safety path systems.
Promenade TIF Fund (Major Fund)$339 $231,130 ($230,791)($230,980)
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,491,435 $700,799 $790,636 $25,150
Collects user fees for the distribution of water
and maintenance of infrastructure.
Sports Core Fund (Major Fund)$369,550 $539,499 ($169,949)($488,420)
Accounts for revenues and expenses relating
to administration, programs, food and beverage
operations, and golf course.
Golf Surcharge Fund $1,686 $59,887 ($58,201)($49,170)
Accounts for the collection of the $3 per round
golf surcharge.
Internal Service Funds
Self Insurance Fund $561,434 $150,943 $410,491 ($7,040)
Accounts for the Village's health insurance costs
and the related contributions from the Village,
employees, retirees, and other agencies.
Garage Fund $156,943 $131,313 $25,630 $25,380
Accounts for the maintenance of the Village's vehicle
fleet and the related departmental reimbursements.
Equipment Replacement Fund $39,567 $1,010,947 ($971,380)($981,830)
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 February 28, 2019
2/28/19 2/28/19
2/28/18 2/28/19 YTD % of 2019 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 1,983,632$ 2,206,953$ 1,978,750$ 111.5%12,325,000$ 223,321$
Other Intergovernmental Tax 212,290 222,291 216,500 102.7%1,227,750 10,001
Telecommunications/Utility Tax 1,063,157 1,056,008 1,023,540 103.2%5,857,500 (7,149)
Licenses and Permits 719,530 296,905 357,845 83.0%2,335,050 (422,625)
Charges for Services 122,676 155,788 232,915 66.9%1,491,400 33,112
Fines and Penalties 27,280 42,022 26,340 159.5%158,000 14,742
Administrative Towing Fees 6,675 5,000 5,000 100.0%30,000 (1,675)
Interest on Investments 47,774 70,687 55,000 128.5%330,000 22,913
Franchise/IMF Maint. Fee - - 53,250 N/A 213,000 -
Miscellaneous Income 35,606 22,023 30,600 72.0%212,800 (13,583)
Total Operating Revenues 4,218,620$ 4,077,677$ 3,979,740$ 102.5%24,180,500$ (140,943)$
OPERATING EXPENDITURES
Personnel 2,551,161$ 3,243,168$ 3,433,640$ 94.5%18,183,745$ 692,007$
Materials and Supplies 65,420 72,557 114,820 63.2%559,780 7,137
Operation and Contract 660,286 753,507 848,290 88.8%4,224,475 93,221
Other Expenditures 21,886 24,050 24,350 98.8%141,100 2,164
Capital Outlay 9,263 120,978 205,115 59.0%862,475 111,715
Total Operating Expenditures 3,308,016$ 4,214,260$ 4,626,215$ 91.1%23,971,575$ 906,244$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 910,604$ (136,583)$ (646,475)$ 208,925$ (1,047,187)$
OTHER TRANSACTIONS
Transfers In -$ 508,235$ 508,235$ 100.0%508,235$ 508,235$
Transfers Out - - - N/A (1,216,725) -
Reimbursements From Other Funds 104,842 105,368 105,370 100.0%632,210 526
Sports Core Loan (100,000) (275,188) - N/A - (175,188)
Total Interfund Transactions 4,842$ 338,415$ 613,605$ 55.2%(76,280)$ 333,573$
NET FUND INCREASE (DECREASE)915,446$ 201,832$ (32,870)$ 132,645$ (713,614)$
Village of Oak Brook
General Fund Financial Update
For the Period Ending February 28, 2019
Total Total
Revenues Expenditures
2/28/19 Actual 4,077,677$ 4,214,260$
2/28/18 Actual 4,218,620$ 3,308,016$
% Change From Last Year -3.3%27.4%
Major Revenues Other
Intergov.Licenses &Charges for
Sales Tax Tax Telecom Tax Permits Services
2/28/19 Actual 2,206,953$ 222,291$ 1,056,008$ 296,905$ 155,788$
2/28/18 Actual $ 1,983,632 $ 212,290 $ 1,063,157 $ 719,530 $ 122,676
% Change From Last Year 11.3%4.7%-0.7%-58.7%27.0%
Five Year Trend
Major Expenditures Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
2/28/19 Actual 3,243,168$ 72,557$ 753,507$ 24,050$ 120,978$
2/28/18 Actual 2,551,161$ 65,420$ 660,286$ 21,886$ 9,263$
% Change From Last Year 27.1%10.9%14.1%9.9%1206.0%
Five Year Trend
Expenditures by Department
2/28/18 2/28/19 2/28/19 2/28/19 2019 Difference Five
YTD YTD YTD % of Annual Prior Year
Department Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 397,183$ 442,636$ 530,540$ 83.4%2,700,820$ 45,453$
Financial Services 134,416 155,681 167,360 93.0%913,960 21,265
Public Works 71,425 86,898 171,945 50.5%886,420 15,473
Engineering & Capital Projects 6,913 104,724 76,650 136.6%459,900 97,811
Library 129,782 170,892 187,230 91.3%928,675 41,110
Police 1,312,538 1,573,365 1,737,705 90.5%8,891,960 260,827
Fire 1,116,243 1,506,003 1,582,000 95.2%8,207,785 389,760
Development Services 139,516 174,061 172,785 100.7%982,055 34,545
Total Expenditures 3,308,016$ 4,214,260$ 4,626,215$ 91.1%23,971,575$ 906,244$
Five Year Trend
For the Period Ending February 28, 2019
General Fund - Five Year Trend
Village of Oak Brook
Revenues Expenditures
2/28/19 2/28/19
2/28/18 2/28/19 YTD % of 2019 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Hotel Tax 157,919$ 154,682$ 148,000$ 104.5%1,268,000$ (3,237)$
Interest 10,826 18,725 5,000 374.5%30,000 7,899
Miscellaneous 1,654 - - 0.0%- (1,654)
Total Operating Revenues 170,399$ 173,407$ 153,000$ 113.3%1,298,000$ 3,008$
EXPENDITURES
Operation and Contract 47$ 77$ 96,300$ 0.1%577,860$ 30$
Other Expenditures 16,590 17,186 17,180 100.0%103,115 596
Capital Outlay 1,419 - 312,595 0.0%4,180,545 (1,419)
Total Expenditures 18,056$ 17,263$ 426,075$ 4.1%4,861,520$ (793)$
NET FUND INCREASE (DECREASE)152,343$ 156,144$ (273,075)$ (3,563,520)$ 3,801$
Note - Expenditures are recorded in program 171.
Village of Oak Brook
Hotel Tax Fund Financial Update
For the Period Ending February 28, 2019
Total Total
Revenues Expenditures
2/28/19 Actual $ 173,407 17,263$
2/28/18 Actual $ 170,399 18,056$
% Change From Last Year 1.8%-4.4%
Major Revenues
Hotel Tax Interest Miscellaneous
2/28/19 Actual $ 154,682 $ 18,725 $ -
2/28/18 Actual $ 157,919 $ 10,826 $ 1,654
% Change From Last Year -2.0%73.0%-100.0%
Five Year Trend
Major Expenditures Operation &Other
Contractual Expenditures Capital Outlay
2/28/19 Actual 77$ 17,186$ -$
2/28/18 Actual 47$ 16,590$ 1,419$
% Change From Last Year 63.8%3.6%-100.0%
Five Year Trend
Village of Oak Brook
Hotel Tax Fund - Major Sources Five Year Trend
For the Period Ending February 28, 2019
Five Year Trend
Revenues Expenditures
2/28/19 2/28/19
2/28/18 2/28/19 YTD % of 2019 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 892,622$ 997,961$ 891,750$ 111.9%5,548,000$ 105,339$
Interest 20,346 37,774 14,000 269.8%80,000 17,428
Miscellaneous 1,516 - 830 0.0%5,000 (1,516)
Total Operating Revenues 914,484$ 1,035,735$ 906,580$ 114.2%5,633,000$ 121,251$
OPERATING EXPENDITURES
Personnel 228,705$ 285,914$ 279,430$ 102.3%1,322,375$ 57,209$
Materials and Supplies 49,582 63,548 50,505 125.8%246,845 13,966
Operation and Contract 159,200 186,078 293,035 63.5%1,663,435 26,878
Other Expenditures 27,478 26,922 26,935 100.0%161,535 (556)
Capital Outlay 2,469 46,577 1,013,250 4.6%10,008,575 44,108
Total Operating Expenditures 467,434$ 609,039$ 1,663,155$ 36.6%13,402,765$ 141,605$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 447,050$ 426,696$ (756,575)$ -56.4%(7,769,765)$ (20,354)$
INTERFUND TRANSACTIONS
Transfers In -$ 216,125$ 216,125$ 100.0%1,116,125$ 216,125$
Reimbursements From Other Funds 30,188 55,574 55,580 100.0%333,445 25,386
Total Interfund Transactions 30,188$ 271,699$ 271,705$ 100.0%1,449,570$ 241,511$
NET FUND INCREASE (DECREASE)477,238$ 698,395$ (484,870)$ (6,320,195)$ 221,157$
Village of Oak Brook
Infrastructure Fund Financial Update
For the Period Ending February 28, 2019
Total Total
Revenues Expenditures
2/28/19 Actual $ 1,035,735 609,039$
2/28/18 Actual $ 914,484 467,434$
% Change From Last Year 13.3%30.3%
Major Revenues
Sales Tax Grants Interest Miscellaneous Reimbursements
2/28/19 Actual $ 997,961 $ - $ 37,774 $ - $ 55,574
2/28/18 Actual $ 892,622 $ - $ 20,346 $ 1,516 $ 30,188
% Change From Last Year 11.8%0.0%85.7%-100.0%84.1%
Five Year Trend
Major Expenditures Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
2/28/19 Actual 285,914$ 63,548$ 186,078$ 26,922$ 46,577$
2/28/18 Actual 228,705$ 49,582$ 159,200$ 27,478$ 2,469$
% Change From Last Year 25.0%28.2%16.9%-2.0%1786.5%
Five Year Trend
Expenditures by Department
2/28/18 2/28/19 2/28/19 2/28/19 2019 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 16,567$ 18,497$ 28,380$ 65.2%179,485$ 1,930$
Public Works 423,571 508,210 1,508,700 33.7%6,462,865 84,639
Engineering & Capital Projects 27,296 82,332 126,075 65.3%6,760,415 55,036
Total Expenditures 467,434$ 609,039$ 1,663,155$ 36.6%13,402,765$ 141,605$
Five Year Trend
Village of Oak Brook
Infrastructure Fund - Major Sources Five Year Trend
For the Period Ending February 28, 2019
Revenues Expenditures
2/28/19 2/28/19
2/28/18 2/28/19 YTD % of 2019 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax -$ -$ -$ 0.0%100,000$ -$
Real Estate Tax - - - 0.0%360,000 -
Interest 199 339 150 226.0%900 140
Total Operating Revenues 199$ 339$ 150$ 226.0%460,900$ 140$
EXPENDITURES
Operation and Contract -$ -$ -$ 0.0%4,210$ -$
Other Expenditures 223,210 231,130 231,130 100.0%460,980 7,920
Total Expenditures 223,210$ 231,130$ 231,130$ 100.0%465,190$ 7,920$
NET FUND INCREASE (DECREASE)(223,011)$ (230,791)$ (230,980)$ (4,290)$ (7,780)$
Note - Expenditures are recorded in program 283.
Village of Oak Brook
Promenade TIF Fund Financial Update
For the Period Ending February 28, 2019
Total Total
Revenues Expenditures
2/28/19 Actual $ 339 231,130$
2/28/18 Actual $ 199 223,210$
% Change From Last Year 70.4%3.5%
Major Revenues Real Estate
Sales Tax Tax Interest
2/28/19 Actual $ - $ - $ 339
2/28/18 Actual $ - $ - $ 199
% Change From Last Year 0.0%0.0%70.4%
Five Year Trend
Major Expenditures Operation &Other
Contractual Expenditures
2/28/19 Actual -$ 231,130$
2/28/18 Actual -$ 223,210$
% Change From Last Year 0.0%3.5%
Five Year Trend
Village of Oak Brook
Promenade TIF Fund - Major Sources Five Year Trend
For the Period Ending February 28, 2019
Five Year Trend
Revenues Expenditures
2/28/19 2/28/19
2/28/18 2/28/19 YTD % of 2019 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Plan Review Fees 225$ 300$ 250$ 120.0%1,500$ 75$
Building/Inspection Fees 225 1,688 830 203.4%5,000 1,463
Water Sales 1,183,685 1,220,530 1,242,885 98.2%10,223,250 36,845
Unmetered Sales 418 4,635 5,000 92.7%30,000 4,217
Water Connection Fees 5,520 5,980 8,300 72.0%50,000 460
Fire Service Charge - - 830 0.0%5,000 -
Meter Charges 1,013 2,265 3,350 67.6%20,000 1,252
Special Services - - - 0.0%30,000 -
Interest on Investments 13,008 26,855 9,160 293.2%55,000 13,847
Miscellaneous 14,705 8,097 12,500 64.8%75,000 (6,608)
Total Operating Revenues 1,218,799$ 1,270,350$ 1,283,105$ 99.0%10,494,750$ 51,551$
EXPENDITURES
Personnel 123,581$ 141,422$ 156,500$ 90.4%828,710$ 17,841$
Materials and Supplies 6,511 7,397 12,300 60.1%76,210 886
Operation and Contract 467,272 398,848 987,975 40.4%5,822,285 (68,424)
Other Expenditures 67,528 91,972 91,980 100.0%551,830 24,444
Capital Outlay 44,266 61,160 230,285 26.6%6,244,075 16,894
Total Expenditures 709,158$ 700,799$ 1,479,040$ 47.4%13,523,110$ (8,359)$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 509,641$ 569,551$ (195,935)$ (3,028,360)$ 59,910$
INTERFUND TRANSACTIONS
Transfers In -$ 221,085$ 221,085$ 100.0%221,085$ 221,085
Total Interfund Transactions -$ 221,085$ 221,085$ 100.0%221,085$ 221,085$
NET FUND INCREASE (DECREASE)509,641$ 790,636$ 25,150$ (2,807,275)$ 280,995$
Village of Oak Brook
Water Fund Financial Update
For the Period Ending February 28, 2019
Total Total
Revenues Expenditures
2/28/19 Actual $ 1,270,350 700,799$
2/28/18 Actual $ 1,218,799 709,158$
% Change From Last Year 4.2%-1.2%
Unmetered Water
Water Sales Sales Connection Fees Meter Charges Miscellaneous
2/28/19 Actual $ 1,220,530 $ 4,635 $ 5,980 $ 2,265 $ 8,097
2/28/18 Actual $ 1,183,685 $ 418 $ 5,520 $ 1,013 $ 14,705
% Change From Last Year 3.1%1008.9%8.3%123.6%-44.9%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
2/28/19 Actual 141,422$ 7,397$ 398,848$ 91,972$ 61,160$
2/28/18 Actual 123,581$ 6,511$ 467,272$ 67,528$ 44,266$
% Change From Last Year 14.4%13.6%-14.6%36.2%38.2%
Five Year Trend
Expenditures by Department
2/28/18 2/28/19 2/28/19 2/28/19 2019 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Public Works 659,080$ 642,657$ 1,252,095$ 51.3%7,299,035$ (16,423)$
Engineering & Capital Projects 50,078 58,142 226,945 25.6%6,224,075 8,064
Total Expenditures 709,158$ 700,799$ 1,479,040$ 47.4%13,523,110$ (8,359)$
Five Year Trend
Village of Oak Brook
Water Fund - Major Sources Five Year Trend
For the Period Ending February 28, 2019
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Sports Core Fund Consolidated Presentation
For the Period Ending February 28, 2019
2/28/19 2/28/19
2/28/19 YTD % of 2019 2/28/18 Difference
B&T Recreation Food &Golf YTD Amended Amended Adopted YTD Prior
Programs Beverage Club Total Budget Budget Budget Total Year
DIRECT REVENUES
Memberships -$ -$ 5,000$ 5,000$ 14,325$ 34.9%453,815$ 14,750$ (9,750)$
Greens Fees - - - - - 0.0%930,000 (129) 129
Pro Shop Sales - - 10,363 10,363 1,735 597.3%200,000 2,862 7,501
Golf Lessons - - - - - 0.0%40,000 590 (590)
Driving Range Fees - - 1,200 1,200 4,300 27.9%226,000 3,980 (2,780)
Rentals - - - - 2,025 0.0%459,000 - -
Programs/User Fees 3,100 - - 3,100 3,100 100.0%253,450 3,400 (300)
Food Sales - - - - - 0.0%175,500 - -
Beverage Sales - - - - - 0.0%252,500 - -
Other Revenue 128 9,055 295 9,478 10,140 93.5%428,300 7,858 1,620
Total Direct Revenues 3,228$ 9,055$ 16,858$ 29,141$ 35,625$ 81.8%3,418,565$ 33,311$ (4,170)$
DIRECT EXPENDITURES
Personnel 4,799$ 28,606$ 121,311$ 154,716$ 167,155$ 92.6%1,572,920$ 114,561$ 40,155$
Materials & Supplies 31 1,120 25,716 26,867 10,050 267.3%580,645 (7,252) 34,119
Operational & Contractual 255,211 4,641 37,685 297,537 352,170 84.5%1,115,975 346,793 (49,256)
Other - - - - - 0.0%(83,150) - -
Capital - 7,782 52,597 60,379 50,000 120.8%1,655,900 9,988 50,391
Total Direct Expenditures 260,041$ 42,149$ 237,309$ 539,499$ 579,375$ 93.1%4,842,290$ 464,090$ 75,409$
Direct Revenues Over (Under) Expenditures (256,813)$ (33,094)$ (220,451)$ (510,358)$ (543,750)$ 93.9%(1,423,725)$ (430,779)$ (79,579)$
B&T Administration Overhead Allocation*13,135$ (13,135)$ -$ -$ -$ 0.0%-$ -$ -$
Operating Revenues Over (Under) Expenditures (243,678)$ (46,229)$ (220,451)$ (510,358)$ (543,750)$ 93.9%(1,423,725)$ (430,779)$ (79,579)$
Interfund Loan**275,188$ -$ -$ 275,188$ -$ 0.0%-$ 100,000$ 175,188$
Transfer From General Fund - - - - - 0.0%1,216,725 - -
Transfer From Golf Surcharge Fund - - 59,887 59,887 50,000 0.0%175,000 - 59,887
Reimbursement From Infrastructure Fund 4,000 - - 4,000 4,000 100.0%24,000 4,000 -
Reimbursement From Water Fund 1,334 - - 1,334 1,330 100.3%8,000 1,334 -
Adjusted Operating Revenues Over (Under) Expenditures 36,844$ (46,229)$ (160,564)$ (169,949)$ (488,420)$ -$ (325,445)$ 155,496$
*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.
**Interfund loan is from the General Fund. This will be repaid as the season begins.
Total Direct Total Direct
Revenues Expenditures
2/28/19 Actual $ 29,141 539,499$
2/28/18 Actual $ 33,311 464,090$
% Change From Last Year -12.5%16.2%
Driving Program/
Memberships Greens Fees Range Fees Rentals User Fees
2/28/19 Actual $ 5,000 $ - $ 1,200 $ - $ 3,100
2/28/18 Actual $ 14,750 $ (129) $ 3,980 $ - $ 3,400
% Change From Last Year -66.1%-100.0%-69.8%0.0%-8.8%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
2/28/19 Actual 154,716$ 26,867$ 297,537$ -$ 60,379$
2/28/18 Actual 114,561$ (7,252)$ 346,793$ -$ 9,988$
% Change From Last Year 35.1%-470.5%-14.2%0.0%504.5%
Five Year Trend
Revenues by Department 2/28/18 2/28/19 2/28/19 2/28/19 2019 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Programs 3,221$ 3,228$ 646,495$ 0.5%686,515$ 7$
Food & Beverage 7,515 9,055 127,800 7.1%663,000 1,540
Golf Club 22,575 16,858 567,997 3.0%2,069,050 (5,717)
Total Revenues 33,311$ 29,141$ 1,342,292$ 2.2%3,418,565$ (4,170)$
Expenditures by Department 2/28/18 2/28/19 2/28/19 % of 2019 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Programs 293,633$ 260,041$ 344,363$ 75.5%1,883,075$ (33,592)$
Food & Beverage 25,044 42,149 281,968 14.9%1,037,845 17,105
Golf Club 145,413 237,309 778,751 30.5%1,921,370 91,896
Total Expenditures 464,090$ 539,499$ 1,405,082$ 38.4%4,842,290$ 75,409$
Five Year Trend
Village of Oak Brook
Sports Core Fund - Major Sources Five Year Trend
For the Period Ending February 28, 2019
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Bath & Tennis Club Recreation Programs
For the Period Ending February 28, 2019 2/28/19 2/28/19
2/28/19 YTD % of 2019 2/28/18 Difference
811 812 813 815 816 YTD Amended Amended Adopted YTD Prior
B&T Admin Swimming Tennis Polo Open Fields Total Budget Budget Budget Total Year
Revenues:
Memberships -$ -$ -$ -$ -$ -$ -$ 0.0%244,815$ -$ -$
Programs/User Fees - - - - 3,100 3,100 3,100 100.0%253,450 3,400 (300)
Other Revenue (872) - - - 1,000 128 140 91.4%188,250 (179) 307
Total Revenue (872)$ -$ -$ -$ 4,100$ 3,228$ 3,240$ 99.6%686,515$ 3,221$ 7$
Expenditures:
Personnel 4,799$ -$ -$ -$ -$ 4,799$ 9,460$ 50.7%182,405$ 3,658$ 1,141$
Materials & Supplies 31 - - - - 31 1,430 2.2%26,350 186 (155)
Operational & Contractual 24,515 230,167 49 - 480 255,211 259,755 98.3%673,820 279,801 (24,590)
Other - - - - - - - 0.0%- - -
Capital - - - - - - - 0.0%1,000,500 9,988 (9,988)
Total Expenditures 29,345$ 230,167$ 49$ -$ 480$ 260,041$ 270,645$ 96.1%1,883,075$ 293,633$ (33,592)$
Direct Revenues Over (Under) Expenditures (30,217)$ (230,167)$ (49)$ -$ 3,620$ (256,813)$ (267,405)$ 96.0%(1,196,560)$ (290,412)$ 33,599$
B&T Administration Overhead Allocation*24,324$ (8,757)$ (2,432)$ -$ -$ 13,135$ 18,010$ 72.9%91,410$ 14,597$ (1,462)$
Revenues Over (Under) Expenditures (5,893)$ (238,924)$ (2,481)$ -$ 3,620$ (243,678)$ (249,395)$ 97.7%(1,105,150)$ (275,815)$ 32,137$
Interfund Loan**275,188$ -$ -$ -$ -$ 275,188$ -$ 0.0%-$ 100,000$ 175,188$
Transfer From General Fund - - - - - - - 0.0%965,500 - -
Reimbursement From Infrastructure Fund 4,000 - - - - 4,000 4,000 100.0%24,000 4,000 -$
Reimbursement From Water Fund 1,334 - - - - 1,334 1,330 100.3%8,000 1,334 -
Adjusted Revenues Over (Under) Expenditures 274,629$ (238,924)$ (2,481)$ -$ 3,620$ 36,844$ (244,065)$ (107,650)$ (170,481)$ 207,325$
*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.
**Interfund loan is from the General Fund.
Village of Oak Brook
Monthly Operating Statement
Sports Core Food & Beverage Programs
For the Period Ending February 28, 2019
2/28/19 2/28/19
821 822 823 2/28/19 YTD % of 2019 2/28/18 Difference
B&T Poolside Golf YTD Amended Amended Adopted YTD Prior
Clubhouse Café Clubhouse Total Budget Budget Budget Total Year
Revenues:
Memberships -$ -$ -$ -$ -$ 0.0%-$ -$ -$
Food Sales - - - - - 0.0%175,500 - -
Beverage Sales - - - - - 0.0%252,500 - -
Other Revenue 9,055 - - 9,055 10,000 90.6%235,000 7,515 1,540
Total Revenue 9,055$ -$ -$ 9,055$ 10,000$ 90.6%663,000$ 7,515$ 1,540$
Expenditures:
Personnel 21,631$ -$ 6,975$ 28,606$ 28,380$ 100.8%286,125$ 16,189$ 12,417$
Materials & Supplies 1,077 - 43 1,120 4,720 23.7%208,200 1,114 6
Operational & Contractual 3,822 - 819 4,641 31,400 14.8%153,120 7,741 (3,100)
Capital 7,782 - - 7,782 - 0.0%390,400 - 7,782
Total Expenditures 34,312$ -$ 7,837$ 42,149$ 64,500$ 65.3%1,037,845$ 25,044$ 17,105$
Direct Revenues Over (Under) Expenditures (25,257)$ -$ (7,837)$ (33,094)$ (54,500)$ 60.7%(374,845)$ (17,529)$ (15,565)$
B&T Administration Overhead Allocation*(12,162)$ (973)$ -$ (13,135)$ (18,010)$ 72.9%(91,410)$ (14,597)$ 1,462$
Revenues Over (Under) Expenditures (37,419)$ (973)$ (7,837)$ (46,229)$ (72,510)$ 63.8%(466,255)$ (32,126)$ (14,103)$
Transfer From General Fund -$ -$ -$ -$ -$ 0.0%251,225$ -$ -$
Adjusted Revenues Over (Under) Expenditures (37,419)$ (973)$ (7,837)$ (46,229)$ (72,510)$ (215,030)$ (32,126)$ (14,103)$
*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.
Village of Oak Brook
Monthly Operating Statement
Golf Club Programs
For the Period Ending February 28, 2019
2/28/19 2/28/19
831 832 833 834 2/28/19 YTD % of 2019 2/28/18 Difference
Golf General Golf Learning Golf Cart Golf Course YTD Amended Amended Adopted YTD Prior
Operation & Practice Operations Maintenance Total Budget Budget Budget Total Year
Revenues:
Memberships 5,000$ -$ -$ -$ 5,000$ 14,325$ 34.9%209,000$ 14,750$ (9,750)$
Greens Fees - - - - - - 0.0%930,000 (129) 129
Pro Shop Sales 10,363 - - - 10,363 1,735 597.3%200,000 2,862 7,501
Golf Lessons - - - - - - 0.0%40,000 590 (590)
Driving Range Fees - 1,200 - - 1,200 4,300 27.9%226,000 3,980 (2,780)
Rentals - - - - - 2,025 0.0%459,000 - -
Other Revenue 295 - - - 295 - N/A 5,050 522 (227)
Total Revenue 15,658$ 1,200$ -$ -$ 16,858$ 22,385$ 75.3%2,069,050$ 22,575$ (5,717)$
Expenditures:
Personnel 72,301$ -$ -$ 49,010$ 121,311$ 129,315$ 93.8%1,104,390$ 94,714$ 26,597$
Materials & Supplies 23,742 - - 1,974 25,716 3,900 659.4%346,095 (8,552) 34,268
Operational & Contractual 29,524 - - 8,161 37,685 61,015 61.8%289,035 59,251 (21,566)
Other - - - - - - 0.0%(83,150) - -
Capital 52,597 - - - 52,597 50,000 105.2%265,000 - 52,597
Total Expenditures 178,164$ -$ -$ 59,145$ 237,309$ 244,230$ 97.2%1,921,370$ 145,413$ 91,896$
Direct Revenues Over (Under) Expenditures (162,506)$ 1,200$ -$ (59,145)$ (220,451)$ (221,845)$ 99.4%147,680$ (122,838)$ (97,613)$
Transfer from Golf Surcharge 59,887$ -$ -$ -$ 59,887$ 50,000$ 119.8%175,000$ -$ 59,887$
Adjusted Revenues Over (Under) Expenditures (102,619)$ 1,200$ -$ (59,145)$ (160,564)$ (171,845)$ 322,680$ (122,838)$ (37,726)$