01 - January 2019 Monthly Financial ReportVILLAGE
OAK BROOK
OF
MONTHLY FINANCIAL REPORTS
JANUARY 2019
ITEM 6.F
Total
Cash and Cash Pooled Cash and
Fund Equivalents Investments Investments % By Fund
General Corporate $4,503,337 $13,833,887 $18,337,224 42.6%
Hotel/Motel Tax 2,707,526 2,101,719 4,809,245 11.2%
Motor Fuel Tax 631,372 169,540 800,912 1.9%
Infrastructure 6,938,303 2,840,567 9,778,870 22.7%
Promenade TIF 26,909 - 26,909 0.1%
Water 4,480,982 2,550,236 7,031,218 16.3%
Sports Core 3,981 - 3,981 0.0%
Golf Surcharge 8,136 434,860 442,996 1.0%
Self-Insurance 756,279 - 756,279 1.8%
Garage 391,336 - 391,336 0.9%
Equipment Replacement 146,183 507,858 654,041 1.5%
Total $20,594,344 $22,438,667 $43,033,011 100.0%
Change in Cash and Investments by Fund :
Balance at Balance at Year-to-Date Year-to-Date
Fund January 1, 2019 January 31, 2019 Change ($)Change (%)
General Corporate $18,063,445 $18,337,224 $273,779 1.5%
Hotel/Motel Tax 4,820,599 4,809,245 (11,354)-0.2%
Motor Fuel Tax 782,203 800,912 18,709 2.4%
Infrastructure 9,345,196 9,778,870 433,674 4.6%
Promenade TIF 257,750 26,909 (230,841)-89.6%
Water 6,449,315 7,031,218 581,903 9.0%
Sports Core 220,480 3,981 (216,499)-98.2%
Golf Surcharge 442,152 442,996 844 0.2%
Self-Insurance 468,568 756,279 287,711 61.4%
Garage 331,134 391,336 60,202 18.2%
Equipment Replacement 1,634,585 654,041 (980,544)-60.0%
$42,815,427 $43,033,011 $217,584 0.5%
Book Market
Value Value
Pooled Checking $565,848 $565,848
Sports Core Checking 42,403 42,403
Pooled IPTIP 19,870,121 19,870,121
Water E-Pay IPTIP 115,972 115,972
$20,594,344 $20,594,344
Pooled Investments:
Investments-Municipal Bonds $7,040,729 $6,964,082
Investments-Corporate Bonds 7,875,632 7,880,078
Government & Agency Obligations 693,675 665,481
Certificates of Deposit 6,720,000 6,687,221
Accrued Interest 108,631 108,631
Total Pooled Investments $22,438,667 $22,305,493
Total Cash and Investments $43,033,011 $42,899,837
For January, total interest revenue is $84,386.
Total investment yield for the portfolio is:
Pooled
Investments Illinois Funds Total
Monthly yield 0.19%0.21%0.20%
YTD yield 0.19%0.21%0.20%
Last 12 months yield 1.99%1.99%1.99%
The weighted average yield of the current pooled investment portfolio is 2.34%.
Monthly Treasurer's Report
January 31, 2019
Monthly Treasurer's Report
January 2019
The table below lists the detail investment holdings at J.P. Morgan Securities as of 1/31/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,975 $99,811 $340
Rosemont IL GO Corp #777543UT4 02/08/16 12/01/19 3.021%2.000%504,156 498,095 2,422
New York N Y City #64971QTX1 02/22/16 05/01/21 2.350%2.000%201,523 196,752 1,161
Florida Hurricane #34074GDH4 03/30/16 07/01/20 2.995%2.150%505,798 501,135 1,247
Bloomingdale Mich Pub Sch Dist #094383FS0 04/26/16 05/01/22 2.710%2.150%508,718 496,305 3,349
Milan Mich Area Achs #598801JD1 05/26/16 05/01/20 1.931%1.931%245,000 242,614 1,082
Indiana Bd Bk Rev Taxable #4546248F7 01/06/17 01/15/20 2.934%1.900%257,458 255,487 346
Garland Cnty Ark Sales & Use #36609PAN3 02/06/17 11/01/19 1.795%1.840%499,830 496,715 2,368
Anchor Bay Mich Sch Dist GO #032879TA6 02/13/17 05/01/19 1.810%1.420%365,358 364,292 1,575
Lanse Creuse Mich Pub Schs #516228RL9 05/02/17 05/01/20 2.159%2.159%100,000 99,278 537
California St GO Bonds #13063A7G3 05/08/17 10/01/19 6.200%1.600%515,256 511,535 10,050
*Genesee Cnty Mich #371608UV0 05/31/17 10/01/19 2.681%2.681%150,000 150,014 280
Connecticut St GO Bds 2016 #20772J3F7 06/15/17 08/15/21 1.750%2.300%493,252 481,475 3,982
North Carolina Eastn Mun Pwr #65819WAL7 10/02/17 07/01/19 2.578%1.700%501,832 499,245 931
Fowlerville Mich Comnty Schs #351280MS8 10/03/17 05/01/20 2.045%1.750%501,826 496,060 2,386
Racine Cnty WI #749845UK7 12/20/17 12/01/20 2.150%2.150%750,000 739,268 2,688
Wisconsin St Gen Fd Annual #977100CW4 01/05/18 05/01/20 1.446%2.100%595,151 590,484 2,073
Illinois St G/O #452152HU8 04/03/18 03/01/19 5.877%3.000%245,596 245,517 5,879
Total Municipal Bonds $7,040,729 $6,964,082 $42,696
Corporate Bonds:
Huntington National Bank #446438RG0 07/06/18 04/01/19 2.200%2.541%699,593 699,349 5,091
Bank of America #06051GFD6 07/06/18 04/01/19 2.650%2.509%750,178 750,000 6,183
KeyBank #49327M2N3 07/19/18 03/08/19 2.350%2.490%844,869 844,890 7,833
Bank of America #06051GFD6 07/30/18 04/01/19 2.650%2.420%245,087 245,000 2,164
Goldman Sachs #38141GVP9 09/26/18 09/15/20 2.750%3.180%496,624 497,245 5,156
Fifth Third #31677QBH1 10/11/18 09/27/19 1.625%2.750%992,759 992,260 5,597
JP Morgan #46640QUV1 11/01/18 07/29/19 0.000%3.017%1,477,780 1,478,826 0
Wells Fargo #94974BGR5 01/15/19 12/07/20 2.550%3.120%1,375,897 1,379,658 5,612
SunTrust #86787EAU1 01/28/19 01/29/21 2.590%3.050%497,798 497,775 0
PNC Bank #69353RFH6 01/30/19 01/22/21 2.500%3.020%495,047 495,075 313
Total Corporate Bonds $7,875,632 $7,880,078 $37,949
Government & Agency Obligations:
**Government National Mtg Assn #38379UEM4 02/29/16 02/16/51 2.300%2.245%$693,675 $665,481 $2,111
Total Government & Agency Obligations:$693,675 $665,481 $2,111
Certificates of Deposit:
State Bk India NY #8562846A7 01/26/17 01/26/22 2.250%2.250%$245,000 $240,147 $77
Marlin Bank #57116ANU8 05/10/17 11/12/19 1.610%1.610%245,000 243,314 211
American Express Fed Svgs #02587CER7 05/10/17 11/12/19 1.700%1.700%245,000 243,515 920
Synchrony Bank #87164WRA8 05/26/17 05/28/19 1.650%1.650%245,000 244,456 691
Umpqua Bank #90421MAG8 05/31/17 05/31/19 1.600%1.600%245,000 244,397 659
Stone Bk Mtn View Ark #86158RAJ8 06/28/17 06/28/19 1.600%1.600%245,000 244,221 10
TIAA FSB Jacksonville #87270LAA1 07/19/17 07/19/19 1.600%1.600%245,000 244,101 115
Peoples United Bank #71270QQZ2 07/19/17 07/19/19 1.650%1.650%245,000 244,160 118
Priority Bank Ozark Ark #74269KBR6 07/26/17 07/26/19 1.600%1.600%245,000 244,054 38
American Express Centurion #02587DV96 08/15/17 08/17/20 1.900%1.900%245,000 241,881 2,134
Sallie Mae #795450C86 08/16/17 08/17/20 1.900%1.900%245,000 242,180 2,134
Merrick Bank South Jordan #59013JZS1 08/21/17 08/21/20 1.800%1.800%245,000 241,764 111
Pinnacle Bank #72345SFS5 08/30/17 08/31/20 1.800%1.800%115,000 113,448 1
Jackson County Bank #466682AP6 08/31/17 03/01/21 1.850%1.850%245,000 240,458 1,888
Barclays Bank #06740KKX4 09/27/17 09/28/20 1.950%1.950%245,000 242,092 1,632
Capital One Bank #1404205E6 10/04/17 10/04/19 1.700%1.700%245,000 243,765 1,342
Transportation Alliance #89388CCB2 10/13/17 04/12/19 1.600%1.600%235,000 234,695 170
Goldman Sachs Bank #38148PRK5 10/18/17 10/19/20 1.950%1.950%245,000 241,938 1,354
FirstBank PR Santurce #33767A6M8 11/03/17 11/03/20 2.000%2.000%245,000 242,028 352
Morgan Stanley #61747MQ53 03/22/18 03/23/20 2.550%2.550%245,000 244,909 2,195
Investors Community Bank #46147UTT7 08/28/18 02/28/20 2.550%2.550%245,000 244,951 19
Lakeside Bank #51210SPS0 08/30/18 03/30/20 2.550%2.550%245,000 244,900 2
Bank United #066519GJ2 08/31/18 02/20/20 2.500%2.500%245,000 244,819 2,552
Compass Bank #20451PVW3 10/26/18 10/26/20 3.000%3.000%245,000 246,220 1,918
UBS Bank #90348JFH8 10/30/18 10/29/20 3.050%3.050%245,000 246,446 5
Citibank #17294XJP2 10/31/18 10/31/20 3.000%3.000%245,000 245,936 1,858
Discover Bank #254673WF9 11/07/18 11/09/20 3.000%3.000%245,000 246,213 1,695
Ally Bank #02007GFX6 11/08/18 11/09/20 3.000%3.000%245,000 246,213 1,674
Total Certificates of Deposits $6,720,000 $6,687,221 $25,875
Total J.P.Morgan Securities $22,330,036 $22,196,862 $108,631
*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
January 31, 2018
Cash & Investments by Fund - Total $43.0 million
Cash & Investments by Type - Total $43.08 million
Checking
Illinois Funds
Certificates of Deposit
Municipal Bonds
Corporate Bonds
Government & Agency Obligations
Accrued Interest
General Corporate
42.61%
Hotel/Motel Tax
11.18%Motor Fuel Tax
1.86%
Infrastructure
22.72%
Promenade TIF
0.06%
Water
16.34%
Sports Core
0.01%
Golf Surcharge
1.03%
Self-Insurance
1.76%Garage
0.91%
Equipment
Replacement
1.52%
Checking, $0.6
Illinois Funds, $20.0
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 January 31, 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 January 2019 are $215,378 lower than last year, but $236,862 over
budget.
o Sales tax revenue, the General Fund’s largest revenue source, is up $112,293 from last
year and $115,744 over budget.
o Licenses and permits revenue is down $442,311 from last year, but $48,903 over
budget. The decrease is due to the receipt large building permit issued in January 2018.
Total expenditures through January 2019 are $839,480 higher than last year, but $101,695
under budget.
o Personnel expenditures are up $660,731 from last year, but $64,061 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 $137,486 from last year, but $15,535 under
budget. This is due to the general timing of payments compared to when they were
projected to occur.
Hotel Tax Fund
Total revenues through January 2019 are $20,351 higher than last year and $20,816 over
budget.
o Hotel tax revenue is up $16,022 from last year and $13,733 over budget. The increase is
due to the timing of receipts being received.
Total expenditures through January 2019 are $298 higher than last year, but $210,742 under
budget.
o Operation and contract expenditures have not occurred to date, but are $48,150 under
budget. Payments are still to come later in FY2019 as originally budgeted.
o Capital Outlay expenditures have not occurred to date, but are $162,595 under budget.
This is due to the timing of projects scheduled.
Motor Fuel Tax Fund
Total revenues through January 2019 are up $501 from last year and $1,729 over budget.
Motor Fuel Tax receipts are up slightly in 2019 compared to 2018.
No Mother Fuel Tax transfers have been made in 2019 to date.
Infrastructure Fund
Total revenues through January 2019 are up $58,918 from last year and $62,841 over budget.
o Non-home rule sales tax revenue is up $49,858 from last year and $51,114 over budget.
This is primarily due to the reduction of the State’s administration fee from 2% to 1.5%.
o Interest income revenue is up $9,060 from last year and $12,142 over budget. This is
due to favorable market conditions and rising interest rates.
Total expenditures through January 2019 are up $30,046 from last year, but $114,399 under
budget.
o Personnel expenditures are up $46,746 from last year, but $5,067 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 down $4,565 from last year and $84,993 under
budget. Expenditures are under budget due to the timing of engineering payments.
Promenade TIF Fund
Total revenues through January 2019 are up $145 from last year and $214 over budget. This is
due to an increase in interest revenue compared to last year.
Total expenditures through January 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 January 2019 are up $48,134 from last year, but $1,283 under budget.
o Water sales revenue is up $35,011 from last year, but $5,835 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 January 2019 are down $27,871 from last year and $583,729 under
budget.
o Operation and contract expenditures are down $7,869 from last year and $464,965
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 $40,872 from last year and $104,458 under
budget. The decrease relates to the start of the Village-wide water meter replacement
project in January 2018.
Sports Core Fund
Total revenues through January 2019 are up $322 from last year and $1,772 over budget. To
date, only miscellaneous revenue sources have been received.
Total expenditures through January 2019 are up $254,630 from last year, but $54,249 under
budget.
o Personnel expenditures are up $37,075 from last year, but $4,181 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 up $227,474 from last year, but $45,316
under budget. This is due to the Park District swim management payment being paid in
January in 2019 and in February in 2018.
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 January 2019 are down $36,455 from last year and $257 under budget.
The decrease is due to the timing of Park District contributions being received.
Total expenditures through January 2019 are up $29,010 from last year, but $177,977 under
budget. This is due to the timing of invoices paid and health claims coming in.
Garage Fund
Total revenues through January 2019 are up $54,342 from last year and $357 over budget. This
is due to a budgeted equipment replacement reserve balance transfer in 2019.
Total expenditures through January 2019 are up $8,787 from last year, but $12,854 under
budget. This is due to the delay in vehicle maintenance invoices paid.
Equipment Replacement Fund
Total revenues through January 2019 are down $10,467 from last year, but $755 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 January 2019 are up $1,002,750 from last year, but $7,660 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)2,672,751 $2,767,325 ($94,574)($253,130)
Main operating fund of the Village.
Hotel Fund (Major Fund)$97,316 $8,593 $88,723 ($142,835)
Collects and spends resources from the
3% hotel/motel tax.
Motor Fuel Tax Fund $18,709 $0 $18,709 $16,980
Collects and spends resources from the
State motor fuel tax.
Infrastructure Fund (Major Fund)$733,418 $264,211 $469,207 $291,970
Accounts for construction and maintenance of
roadways, drainage, and safety path systems.
Promenade TIF Fund (Major Fund)$289 $231,130 ($230,841)($231,055)
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,148,797 $173,166 $975,631 $393,185
Collects user fees for the distribution of water
and maintenance of infrastructure.
Sports Core Fund (Major Fund)$191,109 $371,251 ($180,142)($416,165)
Accounts for revenues and expenses relating
to administration, programs, food and beverage
operations, and golf course.
Golf Surcharge Fund $844 $0 $844 $415
Accounts for the collection of the $3 per round
golf surcharge.
Internal Service Funds
Self Insurance Fund $279,448 $102,193 $177,255 ($465)
Accounts for the Village's health insurance costs
and the related contributions from the Village,
employees, retirees, and other agencies.
Garage Fund $105,752 $56,426 $49,326 $36,115
Accounts for the maintenance of the Village's vehicle
fleet and the related departmental reimbursements.
Equipment Replacement Fund $20,255 $1,002,750 ($982,495)($990,910)
Accounts for the replacement of the Village's vehicle
fleet and the related departmental contributions.
Further information on the Village's major funds (as indicated above) can be found on the proceeding pages.
Executive Summary on Village Funds
Through January 31, 2019
1/31/19 1/31/19
1/31/18 1/31/19 YTD % of 2019 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 941,951$ 1,054,244$ 938,500$ 112.3%12,325,000$ 112,293$
Other Intergovernmental Tax 105,635 116,478 106,000 109.9%1,227,750 10,843
Telecommunications/Utility Tax 496,450 526,992 478,870 110.0%5,857,500 30,542
Licenses and Permits 668,074 225,763 176,860 127.7%2,335,050 (442,311)
Charges for Services 59,473 98,229 116,270 84.5%1,491,400 38,756
Fines and Penalties 17,734 24,273 13,170 184.3%158,000 6,539
Administrative Towing Fees 2,000 4,500 2,500 180.0%30,000 2,500
Interest on Investments 23,284 35,615 27,500 129.5%330,000 12,331
Franchise/IMF Maint. Fee - 5,462 - N/A 213,000 5,462
Miscellaneous Income 12,609 20,276 15,300 132.5%212,800 7,667
Total Operating Revenues 2,327,210$ 2,111,832$ 1,874,970$ 112.6%24,180,500$ (215,378)$
OPERATING EXPENDITURES
Personnel 1,294,743$ 1,955,474$ 2,019,535$ 96.8%18,183,745$ 660,731$
Materials and Supplies 22,590 33,617 43,745 76.8%559,780 11,027
Operation and Contract 419,569 557,055 572,590 97.3%4,224,475 137,486
Other Expenditures 10,943 13,125 13,425 97.8%141,100 2,182
Capital Outlay - 28,054 39,725 70.6%862,475 28,054
Total Operating Expenditures 1,747,845$ 2,587,325$ 2,689,020$ 96.2%23,971,575$ 839,480$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 579,365$ (475,493)$ (814,050)$ 208,925$ (1,054,858)$
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 52,421 52,684 52,685 100.0%632,210 263
Sports Core Loan - (180,000) - N/A - (180,000)
Total Interfund Transactions 52,421$ 380,919$ 560,920$ 67.9%(76,280)$ 328,498$
NET FUND INCREASE (DECREASE)631,786$ (94,574)$ (253,130)$ 132,645$ (726,360)$
Village of Oak Brook
General Fund Financial Update
For the Period Ending January 31, 2019
Total Total
Revenues Expenditures
1/31/19 Actual 2,111,832$ 2,587,325$
1/31/18 Actual 2,327,210$ 1,747,845$
% Change From Last Year -9.3%48.0%
Major Revenues Other
Intergov.Licenses &Charges for
Sales Tax Tax Telecom Tax Permits Services
1/31/19 Actual 1,054,244$ 116,478$ 526,992$ 225,763$ 98,229$
1/31/18 Actual $ 941,951 $ 105,635 $ 496,450 $ 668,074 $ 59,473
% Change From Last Year 11.9%10.3%6.2%-66.2%65.2%
Five Year Trend
Major Expenditures Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
1/31/19 Actual 1,955,474$ 33,617$ 557,055$ 13,125$ 28,054$
1/31/18 Actual 1,294,743$ 22,590$ 419,569$ 10,943$ -$
% Change From Last Year 51.0%48.8%32.8%19.9%N/A
Five Year Trend
Expenditures by Department
1/31/18 1/31/19 1/31/19 1/31/19 2019 Difference Five
YTD YTD YTD % of Annual Prior Year
Department Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 263,726$ 288,447$ 363,150$ 79.4%2,700,820$ 24,721$
Financial Services 64,857 87,748 93,445 93.9%913,960 22,891
Public Works 30,936 40,820 76,775 53.2%886,420 9,884
Engineering & Capital Projects - 26,704 38,325 69.7%459,900 26,704
Library 61,214 104,530 104,680 99.9%928,675 43,316
Police 738,454 1,001,038 1,024,730 97.7%8,891,960 262,584
Fire 523,277 935,492 887,240 105.4%8,207,785 412,215
Development Services 65,381 102,546 100,675 101.9%982,055 37,165
Total Expenditures 1,747,845$ 2,587,325$ 2,689,020$ 96.2%23,971,575$ 839,480$
Five Year Trend
For the Period Ending January 31, 2019
General Fund - Five Year Trend
Village of Oak Brook
Revenues Expenditures
1/31/19 1/31/19
1/31/18 1/31/19 YTD % of 2019 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Hotel Tax 71,711$ 87,733$ 74,000$ 118.6%1,268,000$ 16,022$
Interest 5,254 9,583 2,500 383.3%30,000 4,329
Total Operating Revenues 76,965$ 97,316$ 76,500$ 127.2%1,298,000$ 20,351$
EXPENDITURES
Operation and Contract -$ -$ 48,150$ 0.0%577,860$ -$
Other Expenditures 8,295 8,593 8,590 100.0%103,115 298
Capital Outlay - - 162,595 0.0%4,180,545 -
Total Expenditures 8,295$ 8,593$ 219,335$ 3.9%4,861,520$ 298$
NET FUND INCREASE (DECREASE)68,670$ 88,723$ (142,835)$ (3,563,520)$ 20,053$
Note - Expenditures are recorded in program 171.
Village of Oak Brook
Hotel Tax Fund Financial Update
For the Period Ending January 31, 2019
Total Total
Revenues Expenditures
1/31/19 Actual $ 97,316 8,593$
1/31/18 Actual $ 76,965 8,295$
% Change From Last Year 26.4%3.6%
Major Revenues
Hotel Tax Interest Miscellaneous
1/31/19 Actual $ 87,733 $ 9,583 $ -
1/31/18 Actual $ 71,711 $ 5,254 $ -
% Change From Last Year 22.3%82.4%0.0%
Five Year Trend
Major Expenditures Operation &Other
Contractual Expenditures Capital Outlay
1/31/19 Actual -$ 8,593$ -$
1/31/18 Actual -$ 8,295$ -$
% Change From Last Year 0.0%3.6%0.0%
Five Year Trend
Village of Oak Brook
Hotel Tax Fund - Major Sources Five Year Trend
For the Period Ending January 31, 2019
Five Year Trend
Revenues Expenditures
1/31/19 1/31/19
1/31/18 1/31/19 YTD % of 2019 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 420,506$ 470,364$ 419,250$ 112.2%5,548,000$ 49,858$
Interest 10,082 19,142 7,000 273.5%80,000 9,060
Miscellaneous - - 415 0.0%5,000 -
Total Operating Revenues 430,588$ 489,506$ 426,665$ 114.7%5,633,000$ 58,918$
OPERATING EXPENDITURES
Personnel 113,122$ 159,868$ 164,935$ 96.9%1,322,375$ 46,746$
Materials and Supplies 13,622 1,765 26,090 6.8%246,845 (11,857)
Operation and Contract 93,682 89,117 174,110 51.2%1,663,435 (4,565)
Other Expenditures 13,739 13,461 13,475 99.9%161,535 (278)
Capital Outlay - - - 0.0%10,008,575 -
Total Operating Expenditures 234,165$ 264,211$ 378,610$ 69.8%13,402,765$ 30,046$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 196,423$ 225,295$ 48,055$ 468.8%(7,769,765)$ 28,872$
INTERFUND TRANSACTIONS
Transfers In -$ 216,125$ 216,125$ 100.0%1,116,125$ 216,125$
Reimbursements From Other Funds 15,094 27,787 27,790 100.0%333,445 12,693
Total Interfund Transactions 15,094$ 243,912$ 243,915$ 100.0%1,449,570$ 228,818$
NET FUND INCREASE (DECREASE)211,517$ 469,207$ 291,970$ (6,320,195)$ 257,690$
Village of Oak Brook
Infrastructure Fund Financial Update
For the Period Ending January 31, 2019
Total Total
Revenues Expenditures
1/31/19 Actual $ 489,506 264,211$
1/31/18 Actual $ 430,588 234,165$
% Change From Last Year 13.7%12.8%
Major Revenues
Sales Tax Grants Interest Miscellaneous Reimbursements
1/31/19 Actual $ 470,364 $ - $ 19,142 $ - $ 27,787
1/31/18 Actual $ 420,506 $ - $ 10,082 $ - $ 15,094
% Change From Last Year 11.9%0.0%89.9%0.0%84.1%
Five Year Trend
Major Expenditures Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
1/31/19 Actual 159,868$ 1,765$ 89,117$ 13,461$ -$
1/31/18 Actual 113,122$ 13,622$ 93,682$ 13,739$ -$
% Change From Last Year 41.3%-87.0%-4.9%-2.0%0.0%
Five Year Trend
Expenditures by Department
1/31/18 1/31/19 1/31/19 1/31/19 2019 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 3,320$ 2,080$ 14,715$ 14.1%179,485$ (1,240)$
Public Works 225,016 250,811 304,190 82.5%6,462,865 25,795
Engineering & Capital Projects 5,829 11,320 59,705 19.0%6,760,415 5,491
Total Expenditures 234,165$ 264,211$ 378,610$ 69.8%13,402,765$ 30,046$
Five Year Trend
Village of Oak Brook
Infrastructure Fund - Major Sources Five Year Trend
For the Period Ending January 31, 2019
Revenues Expenditures
1/31/19 1/31/19
1/31/18 1/31/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 144 289 75 385.3%900 145
Total Operating Revenues 144$ 289$ 75$ 385.3%460,900$ 145$
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,066)$ (230,841)$ (231,055)$ (4,290)$ (7,775)$
Note - Expenditures are recorded in program 283.
Village of Oak Brook
Promenade TIF Fund Financial Update
For the Period Ending January 31, 2019
Total Total
Revenues Expenditures
1/31/19 Actual $ 289 231,130$
1/31/18 Actual $ 144 223,210$
% Change From Last Year 100.7%3.5%
Major Revenues Real Estate
Sales Tax Tax Interest
1/31/19 Actual $ - $ - $ 289
1/31/18 Actual $ - $ - $ 144
% Change From Last Year 0.0%0.0%100.7%
Five Year Trend
Major Expenditures Operation &Other
Contractual Expenditures
1/31/19 Actual -$ 231,130$
1/31/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 January 31, 2019
Five Year Trend
Revenues Expenditures
1/31/19 1/31/19
1/31/18 1/31/19 YTD % of 2019 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Plan Review Fees 75$ 225$ 125$ 180.0%1,500$ 150$
Building/Inspection Fees 75 1,613 415 388.7%5,000 1,538
Water Sales 868,029 903,040 908,875 99.4%10,223,250 35,011
Unmetered Sales - 4,335 2,500 173.4%30,000 4,335
Water Connection Fees 2,760 3,220 4,150 77.6%50,000 460
Fire Service Charge - - 415 0.0%5,000 -
Meter Charges 602 1,935 1,685 114.8%20,000 1,333
Special Services - - - 0.0%30,000 -
Interest on Investments 6,539 13,124 4,580 286.6%55,000 6,585
Miscellaneous 1,498 220 6,250 3.5%75,000 (1,278)
Total Operating Revenues 879,578$ 927,712$ 928,995$ 99.9%10,494,750$ 48,134$
EXPENDITURES
Personnel 69,221$ 81,784$ 92,500$ 88.4%828,710$ 12,563$
Materials and Supplies 5,774 1,859 5,440 34.2%76,210 (3,915)
Operation and Contract 48,214 40,345 505,310 8.0%5,822,285 (7,869)
Other Expenditures 33,764 45,986 45,995 100.0%551,830 12,222
Capital Outlay 44,064 3,192 107,650 3.0%6,244,075 (40,872)
Total Expenditures 201,037$ 173,166$ 756,895$ 22.9%13,523,110$ (27,871)$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 678,541$ 754,546$ 172,100$ (3,028,360)$ 76,005$
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)678,541$ 975,631$ 393,185$ (2,807,275)$ 297,090$
Village of Oak Brook
Water Fund Financial Update
For the Period Ending January 31, 2019
Total Total
Revenues Expenditures
1/31/19 Actual $ 927,712 173,166$
1/31/18 Actual $ 879,578 201,037$
% Change From Last Year 5.5%-13.9%
Unmetered Water
Water Sales Sales Connection Fees Meter Charges Miscellaneous
1/31/19 Actual $ 903,040 $ 4,335 $ 3,220 $ 1,935 $ 220
1/31/18 Actual $ 868,029 $ - $ 2,760 $ 602 $ 1,498
% Change From Last Year 4.0%N/A 16.7%221.4%-85.3%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
1/31/19 Actual 81,784$ 1,859$ 40,345$ 45,986$ 3,192$
1/31/18 Actual 69,221$ 5,774$ 48,214$ 33,764$ 44,064$
% Change From Last Year 18.1%-67.8%-16.3%36.2%-92.8%
Five Year Trend
Expenditures by Department
1/31/18 1/31/19 1/31/19 1/31/19 2019 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Public Works 156,972$ 173,166$ 650,920$ 26.6%7,299,035$ 16,194$
Engineering & Capital Projects 44,065 - 105,975 0.0%6,224,075 (44,065)
Total Expenditures 201,037$ 173,166$ 756,895$ 22.9%13,523,110$ (27,871)$
Five Year Trend
Village of Oak Brook
Water Fund - Major Sources Five Year Trend
For the Period Ending January 31, 2019
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Sports Core Fund Consolidated Presentation
For the Period Ending January 31, 2019
1/31/19 1/31/19
1/31/19 YTD % of 2019 1/31/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 -$ -$ -$ -$ -$ 0.0%453,815$ -$ -$
Greens Fees - - - - - 0.0%930,000 (129) 129
Pro Shop Sales - - 2,459 2,459 - N/A 200,000 1,396 1,063
Golf Lessons - - - - - 0.0%40,000 - -
Driving Range Fees - - - - - 0.0%226,000 - -
Rentals - - - - - 0.0%459,000 - -
Programs/User Fees 1,550 - - 1,550 1,550 100.0%253,450 1,550 -
Food Sales - - - - - 0.0%175,500 - -
Beverage Sales - - - - - 0.0%252,500 - -
Other Revenue (5) 4,298 140 4,433 5,120 86.6%428,300 5,303 (870)
Total Direct Revenues 1,545$ 4,298$ 2,599$ 8,442$ 6,670$ 126.6%3,418,565$ 8,120$ 322$
DIRECT EXPENDITURES
Personnel 2,999$ 15,707$ 72,378$ 91,084$ 95,265$ 95.6%1,572,920$ 54,009$ 37,075$
Materials & Supplies - (112) 3,996 3,884 3,985 97.5%580,645 9,152 (5,268)
Operational & Contractual 251,437 340 29,157 280,934 326,250 86.1%1,115,975 53,460 227,474
Other - - - - - 0.0%(83,150) - -
Capital - - (4,651) (4,651) - N/A 1,655,900 - (4,651)
Total Direct Expenditures 254,436$ 15,935$ 100,880$ 371,251$ 425,500$ 87.3%4,842,290$ 116,621$ 254,630$
Direct Revenues Over (Under) Expenditures (252,891)$ (11,637)$ (98,281)$ (362,809)$ (418,830)$ 86.6%(1,423,725)$ (108,501)$ (254,308)$
B&T Administration Overhead Allocation*13,135$ (13,135)$ -$ -$ -$ 0.0%-$ -$ -$
Operating Revenues Over (Under) Expenditures (239,756)$ (24,772)$ (98,281)$ (362,809)$ (418,830)$ 86.6%(1,423,725)$ (108,501)$ (254,308)$
Interfund Loan**180,000$ -$ -$ 180,000$ -$ 0.0%-$ -$ 180,000$
Transfer From General Fund - - - - - 0.0%1,216,725 - -
Transfer From Golf Surcharge Fund - - - - - 0.0%175,000 - -
Reimbursement From Infrastructure Fund 2,000 - - 2,000 2,000 100.0%24,000 2,000 -
Reimbursement From Water Fund 667 - - 667 665 100.3%8,000 667 -
Adjusted Operating Revenues Over (Under) Expenditures (57,089)$ (24,772)$ (98,281)$ (180,142)$ (416,165)$ -$ (105,834)$ (74,308)$
*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
1/31/19 Actual $ 8,442 371,251$
1/31/18 Actual $ 8,120 116,621$
% Change From Last Year 4.0%218.3%
Driving Program/
Memberships Greens Fees Range Fees Rentals User Fees
1/31/19 Actual $ - $ - $ - $ - $ 1,550
1/31/18 Actual $ - $ (129) $ - $ - $ 1,550
% Change From Last Year 0.0%-100.0%0.0%0.0%0.0%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
1/31/19 Actual 91,084$ 3,884$ 280,934$ -$ (4,651)$
1/31/18 Actual 54,009$ 9,152$ 53,460$ -$ -$
% Change From Last Year 68.6%-57.6%425.5%0.0%N/A
Five Year Trend
Revenues by Department 1/31/18 1/31/19 1/31/19 1/31/19 2019 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Programs 1,377$ 1,545$ 646,495$ 0.2%686,515$ 168$
Food & Beverage 5,079 4,298 127,800 3.4%663,000 (781)
Golf Club 1,664 2,599 567,997 0.5%2,069,050 935
Total Revenues 8,120$ 8,442$ 1,342,292$ 0.6%3,418,565$ 322$
Expenditures by Department 1/31/18 1/31/19 1/31/19 % of 2019 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Programs 25,444$ 254,436$ 344,363$ 73.9%1,883,075$ 228,992$
Food & Beverage 8,988 15,935 281,968 5.7%1,037,845 6,947
Golf Club 82,189 100,880 778,751 13.0%1,921,370 18,691
Total Expenditures 116,621$ 371,251$ 1,405,082$ 26.4%4,842,290$ 254,630$
Five Year Trend
Village of Oak Brook
Sports Core Fund - Major Sources Five Year Trend
For the Period Ending January 31, 2019
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Bath & Tennis Club Recreation Programs
For the Period Ending January 31, 2019 1/31/19 1/31/19
1/31/19 YTD % of 2019 1/31/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 - - - - 1,550 1,550 1,550 100.0%253,450 1,550 -
Other Revenue (5) - - - - (5) 120 -4.2%188,250 (173) 168
Total Revenue (5)$ -$ -$ -$ 1,550$ 1,545$ 1,670$ 92.5%686,515$ 1,377$ 168$
Expenditures:
Personnel 2,999$ -$ -$ -$ -$ 2,999$ 5,025$ 59.7%182,405$ 2,262$ 737$
Materials & Supplies - - - - - - 100 0.0%26,350 - -
Operational & Contractual 21,321 230,022 - - 94 251,437 256,605 98.0%673,820 23,182 228,255
Other - - - - - - - 0.0%- - -
Capital - - - - - - - 0.0%1,000,500 - -
Total Expenditures 24,320$ 230,022$ -$ -$ 94$ 254,436$ 261,730$ 97.2%1,883,075$ 25,444$ 228,992$
Direct Revenues Over (Under) Expenditures (24,325)$ (230,022)$ -$ -$ 1,456$ (252,891)$ (260,060)$ 97.2%(1,196,560)$ (24,067)$ (228,824)$
B&T Administration Overhead Allocation*24,325$ (8,758)$ (2,432)$ -$ -$ 13,135$ 15,285$ 85.9%91,410$ 13,335$ (200)$
Revenues Over (Under) Expenditures -$ (238,780)$ (2,432)$ -$ 1,456$ (239,756)$ (244,775)$ 97.9%(1,105,150)$ (10,732)$ (229,024)$
Interfund Loan**180,000$ -$ -$ -$ -$ 180,000$ 0.0%-$ -$ 180,000$
Transfer From General Fund - - - - - - 0.0%965,500 - -
Reimbursement From Infrastructure Fund 2,000 - - - - 2,000 2,000 100.0%24,000 2,000$ -$
Reimbursement From Water Fund 667 - - - - 667 665 100.3%8,000 667 -
Adjusted Revenues Over (Under) Expenditures 182,667$ (238,780)$ (2,432)$ -$ 1,456$ (57,089)$ (242,110)$ (107,650)$ (8,065)$ (49,024)$
*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 January 31, 2019
1/31/19 1/31/19
821 822 823 1/31/19 YTD % of 2019 1/31/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 4,298 - - 4,298 5,000 86.0%235,000 5,079 (781)
Total Revenue 4,298$ -$ -$ 4,298$ 5,000$ 86.0%663,000$ 5,079$ (781)$
Expenditures:
Personnel 11,863$ -$ 3,844$ 15,707$ 16,200$ 97.0%286,125$ 7,944$ 7,763$
Materials & Supplies - - (112) (112) 3,585 -3.1%208,200 143 (255)
Operational & Contractual 245 - 95 340 21,655 1.6%153,120 901 (561)
Capital - - - - - 0.0%390,400 - -
Total Expenditures 12,108$ -$ 3,827$ 15,935$ 41,440$ 38.5%1,037,845$ 8,988$ 6,947$
Direct Revenues Over (Under) Expenditures (7,810)$ -$ (3,827)$ (11,637)$ (36,440)$ 31.9%(374,845)$ (3,909)$ (7,728)$
B&T Administration Overhead Allocation*(12,162)$ (973)$ -$ (13,135)$ (15,285)$ 85.9%(91,410)$ (13,335)$ 200$
Revenues Over (Under) Expenditures (19,972)$ (973)$ (3,827)$ (24,772)$ (51,725)$ 47.9%(466,255)$ (17,244)$ (7,528)$
Transfer From General Fund -$ -$ -$ -$ -$ 0.0%251,225$ -$ -$
Adjusted Revenues Over (Under) Expenditures (19,972)$ (973)$ (3,827)$ (24,772)$ (51,725)$ (215,030)$ (17,244)$ (7,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 percentage basis.
Village of Oak Brook
Monthly Operating Statement
Golf Club Programs
For the Period Ending January 31, 2019
1/31/19 1/31/19
831 832 833 834 1/31/19 YTD % of 2019 1/31/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 -$ -$ -$ -$ -$ -$ 0.0%209,000$ -$ -$
Greens Fees - - - - - - 0.0%930,000 (129) 129
Pro Shop Sales 2,459 - - - 2,459 - N/A 200,000 1,396 1,063
Golf Lessons - - - - - - 0.0%40,000 - -
Driving Range Fees - - - - - - 0.0%226,000 - -
Rentals - - - - - - 0.0%459,000 - -
Other Revenue 140 - - - 140 - N/A 5,050 397 (257)
Total Revenue 2,599$ -$ -$ -$ 2,599$ -$ #DIV/0!2,069,050$ 1,664$ 935$
Expenditures:
Personnel 43,105$ -$ -$ 29,273$ 72,378$ 74,040$ 97.8%1,104,390$ 43,803$ 28,575$
Materials & Supplies 3,043 - - 953 3,996 300 1332.0%346,095 9,009 (5,013)
Operational & Contractual 25,544 - - 3,613 29,157 47,990 60.8%289,035 29,377 (220)
Other - - - - - - 0.0%(83,150) - -
Capital (4,651) - - - (4,651) - N/A 265,000 - (4,651)
Total Expenditures 67,041$ -$ -$ 33,839$ 100,880$ 122,330$ 82.5%1,921,370$ 82,189$ 18,691$
Direct Revenues Over (Under) Expenditures (64,442)$ -$ -$ (33,839)$ (98,281)$ (122,330)$ 80.3%147,680$ (80,525)$ (17,756)$
Transfer from Golf Surcharge -$ -$ -$ -$ -$ -$ 0.0%175,000$ -$ -$
Adjusted Revenues Over (Under) Expenditures (64,442)$ -$ -$ (33,839)$ (98,281)$ (122,330)$ 322,680$ (80,525)$ (17,756)$