03 - March 2019 Monthly Financial ReportVILLAGE
OAK BROOK
OF
MONTHLY FINANCIAL REPORTS
MARCH 2019
ITEM 6.E
Total
Cash and Cash Pooled Cash and
Fund Equivalents Investments Investments % By Fund
General Corporate $5,358,207 $13,989,250 $19,347,457 42.9%
Hotel/Motel Tax 2,656,976 2,163,217 4,820,193 10.7%
Motor Fuel Tax 668,044 168,793 836,837 1.9%
Infrastructure 7,821,539 2,632,733 10,454,272 23.2%
Promenade TIF 26,751 - 26,751 0.1%
Water 4,967,940 2,620,601 7,588,541 16.8%
Sports Core - - - 0.0%
Golf Surcharge 1,117 362,985 364,102 0.8%
Self-Insurance 575,765 - 575,765 1.3%
Garage 358,066 - 358,066 0.8%
Equipment Replacement 169,467 506,776 676,243 1.5%
Total $22,603,872 $22,444,355 $45,048,227 100.0%
Change in Cash and Investments by Fund :
Balance at Balance at Year-to-Date Year-to-Date
Fund January 1, 2019 March 31, 2019 Change ($)Change (%)
General Corporate $18,092,186 $19,347,457 $1,255,271 6.9%
Hotel/Motel Tax 4,843,367 4,820,193 (23,174)-0.5%
Motor Fuel Tax 782,203 836,837 54,634 7.0%
Infrastructure 9,322,381 10,454,272 1,131,891 12.1%
Promenade TIF 257,485 26,751 (230,734)-89.6%
Water 6,449,315 7,588,541 1,139,226 17.7%
Sports Core 190,397 - (190,397)-100.0%
Golf Surcharge 442,152 364,102 (78,050)-17.7%
Self-Insurance 468,568 575,765 107,197 22.9%
Garage 331,134 358,066 26,932 8.1%
Equipment Replacement 1,636,238 676,243 (959,995)-58.7%
$42,815,426 $45,048,227 $2,232,801 5.2%
Book Market
Value Value
Pooled Checking $408,691 $408,691
Sports Core Checking 275,969 275,969
Pooled IPTIP 21,836,223 21,836,223
Water E-Pay IPTIP 82,989 82,989
$22,603,872 $22,603,872
Pooled Investments:
Investments-Municipal Bonds $6,746,757 $6,703,646
Investments-Corporate Bonds 8,150,268 8,170,360
Government & Agency Obligations 690,034 665,136
Certificates of Deposit 6,720,000 6,705,099
Accrued Interest 137,296 137,296
Total Pooled Investments $22,444,355 $22,381,537
Total Cash and Investments $45,048,227 $44,985,409
For March, total interest revenue is $37,355 and YTD revenue is $108,042.
Total investment yield for the portfolio is:
Pooled
Investments Illinois Funds Total
Monthly yield 0.20%0.23%0.21%
YTD yield 0.59%0.63%0.61%
Last 12 months yield 2.08%2.16%2.12%
The weighted average yield of the current pooled investment portfolio is 2.36%.
Monthly Treasurer's Report
March 31, 2019
Monthly Treasurer's Report
March 2019
The table below lists the detail investment holdings at J.P. Morgan Securities as of 3/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,987 $99,947 $681
Rosemont IL GO Corp #777543UT4 02/08/16 12/01/19 3.021%2.000%503,324 498,830 4,939
New York N Y City #64971QTX1 02/22/16 05/01/21 2.350%2.000%201,411 199,486 1,944
Florida Hurricane #34074GDH4 03/30/16 07/01/20 2.995%2.150%505,114 502,640 3,743
Bloomingdale Mich Pub Sch Dist #094383FS0 04/26/16 05/01/22 2.710%2.150%508,282 500,060 5,607
Milan Mich Area Achs #598801JD1 05/26/16 05/01/20 1.931%1.931%245,000 243,388 1,870
Indiana Bd Bk Rev Taxable #4546248F7 01/06/17 01/15/20 2.934%1.900%257,025 255,681 1,593
Garland Cnty Ark Sales & Use #36609PAN3 02/06/17 11/01/19 1.795%1.840%499,867 497,070 3,864
Anchor Bay Mich Sch Dist GO #032879TA6 02/13/17 05/01/19 1.810%1.420%365,122 364,763 2,676
Lanse Creuse Mich Pub Schs #516228RL9 05/02/17 05/01/20 2.159%2.159%100,000 99,562 897
California St GO Bonds #13063A7G3 05/08/17 10/01/19 6.200%1.600%511,461 509,215 15,218
*Genesee Cnty Mich #371608UV0 05/31/17 10/01/19 2.681%2.681%108,000 108,001 121
Connecticut St GO Bds 2016 #20772J3F7 06/15/17 08/15/21 1.750%2.300%493,685 489,130 1,065
North Carolina Eastn Mun Pwr #65819WAL7 10/02/17 07/01/19 2.578%1.700%501,105 499,820 3,079
Fowlerville Mich Comnty Schs #351280MS8 10/03/17 05/01/20 2.045%1.750%501,585 497,525 4,090
Racine Cnty WI #749845UK7 12/20/17 12/01/20 2.150%2.150%750,000 745,620 5,375
Wisconsin St Gen Fd Annual #977100CW4 01/05/18 05/01/20 1.446%2.100%595,789 592,908 3,519
Total Municipal Bonds $6,746,757 $6,703,646 $60,281
Corporate Bonds:
Huntington National Bank #446438RG0 07/06/18 04/01/19 2.200%2.541%699,989 700,000 7,657
Bank of America #06051GFD6 07/06/18 04/01/19 2.650%2.509%750,003 750,000 9,496
Bank of America #06051GFD6 07/30/18 04/01/19 2.650%2.420%245,000 245,000 3,246
Goldman Sachs #38141GVP9 09/26/18 09/15/20 2.750%3.180%496,965 499,410 573
Fifth Third #31677QBH1 10/11/18 09/27/19 1.625%2.750%994,603 994,650 181
JP Morgan #46640QUV1 11/01/18 07/29/19 0.000%3.017%1,485,220 1,486,428 0
Wells Fargo #94974BGR5 01/15/19 12/07/20 2.550%3.120%1,377,145 1,385,496 11,520
SunTrust #86787EAU1 01/28/19 01/29/21 2.590%3.050%498,171 498,840 2,158
PNC Bank #69353RFH6 01/30/19 01/22/21 2.500%3.020%495,456 499,510 2,396
Morgan Stanley #61747WAL3 03/08/19 07/28/21 5.500%3.034%1,107,716 1,111,026 9,946
Total Corporate Bonds $8,150,268 $8,170,360 $47,173
Government & Agency Obligations:
**Government National Mtg Assn #38379UEM4 02/29/16 02/16/51 2.300%2.245%$690,034 $665,136 $2,154
Total Government & Agency Obligations:$690,034 $665,136 $2,154
Certificates of Deposit:
State Bk India NY #8562846A7 01/26/17 01/26/22 2.250%2.250%$245,000 $242,016 $995
Marlin Bank #57116ANU8 05/10/17 11/12/19 1.610%1.610%245,000 243,755 231
American Express Fed Svgs #02587CER7 05/10/17 11/12/19 1.700%1.700%245,000 243,910 1,614
Synchrony Bank #87164WRA8 05/26/17 05/28/19 1.650%1.650%245,000 244,733 1,365
Umpqua Bank #90421MAG8 05/31/17 05/31/19 1.600%1.600%245,000 244,691 1,312
Stone Bk Mtn View Ark #86158RAJ8 06/28/17 06/28/19 1.600%1.600%245,000 244,542 30
TIAA FSB Jacksonville #87270LAA1 07/19/17 07/19/19 1.600%1.600%245,000 244,417 768
Peoples United Bank #71270QQZ2 07/19/17 07/19/19 1.650%1.650%245,000 244,456 792
Priority Bank Ozark Ark #74269KBR6 07/26/17 07/26/19 1.600%1.600%245,000 244,388 58
American Express Centurion #02587DV96 08/15/17 08/17/20 1.900%1.900%245,000 242,905 563
Sallie Mae #795450C86 08/16/17 08/17/20 1.900%1.900%245,000 243,099 563
Merrick Bank South Jordan #59013JZS1 08/21/17 08/21/20 1.800%1.800%245,000 242,748 134
Pinnacle Bank #72345SFS5 08/30/17 08/31/20 1.800%1.800%115,000 113,926 181
Jackson County Bank #466682AP6 08/31/17 03/01/21 1.850%1.850%245,000 242,227 396
Barclays Bank #06740KKX4 09/27/17 09/28/20 1.950%1.950%245,000 243,138 60
Capital One Bank #1404205E6 10/04/17 10/04/19 1.700%1.700%245,000 244,118 2,036
Transportation Alliance #89388CCB2 10/13/17 04/12/19 1.600%1.600%235,000 234,941 189
Goldman Sachs Bank #38148PRK5 10/18/17 10/19/20 1.950%1.950%245,000 243,082 2,150
FirstBank PR Santurce #33767A6M8 11/03/17 11/03/20 2.000%2.000%245,000 243,224 376
Morgan Stanley #61747MQ53 03/22/18 03/23/20 2.550%2.550%245,000 245,164 39
Investors Community Bank #46147UTT7 08/28/18 02/28/20 2.550%2.550%245,000 245,174 50
Lakeside Bank #51210SPS0 08/30/18 03/30/20 2.550%2.550%245,000 245,162 547
Bank United #066519GJ2 08/31/18 02/20/20 2.500%2.500%245,000 245,061 536
Compass Bank #20451PVW3 10/26/18 10/26/20 3.000%3.000%245,000 247,016 3,144
UBS Bank #90348JFH8 10/30/18 10/29/20 3.050%3.050%245,000 247,232 657
Citibank #17294XJP2 10/31/18 10/31/20 3.000%3.000%245,000 245,838 3,083
Discover Bank #254673WF9 11/07/18 11/09/20 3.000%3.000%245,000 247,068 2,920
Ally Bank #02007GFX6 11/08/18 11/09/20 3.000%3.000%245,000 247,068 2,899
Total Certificates of Deposits $6,720,000 $6,705,099 $27,688
Total J.P.Morgan Securities $22,307,059 $22,244,241 $137,296
*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
March 31, 2019
Cash & Investments by Fund - Total $45.0 million
Cash & Investments by Type - Total $45.0 million
Checking
Illinois Funds
Certificates of Deposit
Municipal Bonds
Corporate Bonds
Government & Agency Obligations
Accrued Interest
General Corporate
42.95%
Hotel/Motel Tax
10.70%Motor Fuel Tax
1.86%
Infrastructure
23.21%
Promenade TIF
0.06%
Water
16.85%
Sports Core
0.00%
Golf Surcharge
0.81%
Self-Insurance
1.28%Garage
0.79%
Equipment
Replacement
1.50%
Checking, $0.7
Illinois Funds, $21.9
Certificates of Deposit,
$6.7
Municipal Bonds, $6.7
Corporate Bonds, $8.2
Government & Agency
Obligations, $0.7
Accrued Interest, $0.1
in millions
YTD YTD
Net Fund Budgeted
YTD YTD Increase Increase
Governmental Funds Revenues Expenditures (Decrease)(Decrease)
General Fund (Major Fund)7,453,618 $6,147,787 $1,305,831 $436,160
Main operating fund of the Village.
Hotel Fund (Major Fund)$243,034 $37,884 $205,150 ($388,320)
Collects and spends resources from the
3% hotel/motel tax.
Motor Fuel Tax Fund $54,634 $0 $54,634 $50,940
Collects and spends resources from the
State motor fuel tax.
Infrastructure Fund (Major Fund)$2,151,187 $877,928 $1,273,259 ($1,533,565)
Accounts for construction and maintenance of
roadways, drainage, and safety path systems.
Promenade TIF Fund (Major Fund)$396 $231,130 ($230,734)($230,905)
Accounts for the revenues and expenditures
restricted to the Tax Increment Financing (TIF)
district located at 22nd St. and Meyers Rd.
Enterprise Funds
Water Fund (Major Fund)$2,426,362 $1,152,359 $1,274,003 ($102,345)
Collects user fees for the distribution of water
and maintenance of infrastructure.
Sports Core Fund (Major Fund)$575,097 $699,936 ($124,839)($496,495)
Accounts for revenues and expenses relating
to administration, programs, food and beverage
operations, and golf course.
Golf Surcharge Fund $3,997 $82,047 ($78,050)($101,755)
Accounts for the collection of the $3 per round
golf surcharge.
Internal Service Funds
Self Insurance Fund $839,893 $586,882 $253,011 ($8,615)
Accounts for the Village's health insurance costs
and the related contributions from the Village,
employees, retirees, and other agencies.
Garage Fund $208,196 $182,506 $25,690 $12,255
Accounts for the maintenance of the Village's vehicle
fleet and the related departmental reimbursements.
Equipment Replacement Fund $58,942 $1,018,104 ($959,162)($972,750)
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 March 31, 2019
Village of Oak Brook
Monthly Financial Report – Fund Narrative
For the Period Ending March 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 significant items by individual fund:
General Fund
Sales Tax collections through March
2019 are $3,911,481, which is
$288,711 higher than through March
2018 and $288,231 over FY19 budget
to date. The increase is primarily due
to the opening of newer businesses
in town and general inflationary
growth.
Licenses and Permits revenue
through March 2019 is $415,476,
which is $462,327 lower than through March 2018 and $122,354 under FY19 budget to date.
The decrease is due to the Kidzania permit being issued in first quarter 2018. The Village
expects two large construction permits to be issued later in 2019.
Personnel expenditures through March 2019 are $4,570,333, which is $220,703 more than
through March 2018, but $280,827 under FY19 budget to date. The increase is due to normal
salary and benefit increases. Personnel is under budget in FY19 due to a delay in full pension
funding until later in the year.
Capital Outlay expenditures through March 2019 are $138,160, which is $60,269 more than
through March 2018, but $343,495 under FY19 budget to date. This is due to the general timing
of projects being started. Capital projects are expected to occur later in FY19 as budgeted.
Hotel Tax Fund
Hotel Tax collections through March 2019 are $214,433, which is $24,710 lower than through
March 2018 and $22,567 under FY19 budget to date. This is primarily due to the timing of
receipts coming in. FY19 tax receipts have been consistent with the FY18 comparable month to
date.
Capital Outlay expenditures have not occurred through March 2019. Expenditures are
$462,595 under FY19 budget to date due to the delay in the Jorie, Kensington, and Forest Gate
streetscape beautification project. This project may occur later in 2019 or 2020.
$3.5
$3.6
$3.7
$3.8
$3.9
$4.0
2015 2016 2017 2018 2019MillionsSales Tax -1st Quarter
Motor Fuel Tax Fund
Motor Fuel Tax collections through March 2019 are $49,779, which is $923 lower than through
March 2018, but $339 over FY19 budget to date. Motor Fuel Tax revenue was anticipated to be
down slightly in 2019.
Infrastructure Fund
Non-Home Rule Sales Tax collections
through March 2019 are $1,792,810,
which is $142,008 higher than through
March 2018 and $139,060 over FY19
budget to date. The increase is
primarily due to the opening of newer
businesses in town and general
inflationary growth.
Capital Outlay expenditures through
March 2019 are $105,690, which is
$98,634 higher than first quarter 2018,
but $2,514,690 under FY19 budget to date. This is due to the timing of FY19 projects being
started. Projects are expected to occur later in FY19 as planned.
Water Fund
Water Sales revenue through March 2019 is $2,137,068, which is $112,917 higher than through
March 2018 and $17,088 over FY19 budget to date. The increase is due to a 5% rate increase
effective January 1, 2019.
Operation and Contractual expenditures through March 2019 are $721,453, which is $108,274
lower than through March 2018 and $751,002 under FY19 budget to date. The decrease is due
to less total gallons purchased from DuPage Water Commission compared to FY18. Payments
are under budget due to the general timing of when invoices have been paid compared to when
budgeted.
Capital Outlay expenditures through March 2019 are $83,521, which is $648,553 lower than
through March 2018 and $564,274 under FY19 budget to date. The decrease is due to the FY18
meter replacement project kicking off in early 2018. The 2019 budgeted capital projects have
not been started to date, but are expected to occur as planned later in 2019.
Sports Core Fund
Other Revenue collections through March 2019 are $18,310, which is $106,182 lower than
through March 2018 and $5,989 under FY19 budget to date. The decrease is due to the
$100,000 McDonald’s Taste of Oak Brook sponsorship being received in March 2018.
Capital Outlay expenditures through March 2019 are $160,385, which is $130,654 higher than
through March 2018, but $144,615 under FY19 budget to date. The FY19 increase is due to the
Golf Club pro shop renovation. Capital expenditures are under budget so far in FY19 due to the
timing of projects and payments.
$1.5
$1.6
$1.7
$1.8
$1.9
$2.0
2015 2016 2017 2018 2019MillionsNon-Home Rule Sales Tax -1st Quarter
Equipment Replacement Fund
Other Expenditures through March 2019 are $1,002,397, which is even with FY19 budget to
date. This includes a $1,000,000 equity transfer to the General Fund, Infrastructure Fund, Water
Fund, and Garage Fund as a result of switching to a leasing program.
3/31/19 3/31/19
3/31/18 3/31/19 YTD % of 2019 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 3,622,770$ 3,911,481$ 3,623,250$ 108.0%12,325,000$ 288,711$
Other Intergovernmental Tax*305,700 317,801 310,000 102.5%1,227,750 12,101
Telecommunications/Utility Tax 1,597,532 1,625,232 1,539,535 105.6%5,857,500 27,700
Licenses and Permits 877,803 415,476 537,830 77.3%2,335,050 (462,327)
Charges for Services 179,814 278,619 348,685 79.9%1,491,400 98,805
Fines and Penalties 41,170 65,728 39,510 166.4%158,000 24,558
Administrative Towing Fees 10,125 6,100 7,500 81.3%30,000 (4,025)
Interest on Investments 74,147 108,042 82,500 131.0%330,000 33,895
Franchise/IMF Maint. Fee - - 53,250 N/A 213,000 -
Miscellaneous Income 60,906 58,852 45,900 128.2%212,800 (2,054)
Total Operating Revenues 6,769,967$ 6,787,331$ 6,587,960$ 103.0%24,180,500$ 17,364$
OPERATING EXPENDITURES
Personnel 4,349,630$ 4,570,333$ 4,851,160$ 94.2%18,183,745$ 220,703$
Materials and Supplies 112,473 109,620 174,665 62.8%559,780 (2,853)
Operation and Contract 969,849 1,026,505 1,150,335 89.2%4,224,475 56,656
Other Expenditures 32,829 35,708 35,275 101.2%141,100 2,879
Capital Outlay 77,891 138,160 481,655 28.7%862,475 60,269
Total Operating Expenditures 5,542,672$ 5,880,326$ 6,693,090$ 87.9%23,971,575$ 337,654$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 1,227,295$ 907,005$ (105,130)$ 208,925$ (320,290)$
OTHER TRANSACTIONS
Transfers In -$ 508,235$ 508,235$ 100.0%508,235$ 508,235$
Transfers Out - (37,439) (125,000) 30.0%(1,216,725) (37,439)
Reimbursements From Other Funds 157,263 158,052 158,055 100.0%632,210 789
Sports Core Loan (100,000) (230,022) - N/A - (130,022)
Total Interfund Transactions 57,263$ 398,826$ 541,290$ 73.7%(76,280)$ 341,563$
NET FUND INCREASE (DECREASE)1,284,558$ 1,305,831$ 436,160$ 132,645$ 21,273$
*Includes the collection of Income Tax, Use Tax, Road & Bridge Tax, and Personal Property Replacement Tax.
Village of Oak Brook
General Fund Financial Update
For the Period Ending March 31, 2019
Total Total
Revenues Expenditures
3/31/19 Actual 6,787,331$ 5,880,326$
3/31/18 Actual 6,769,967$ 5,542,672$
% Change From Last Year 0.3%6.1%
Major Revenues Other
Intergov.Licenses &Charges for
Sales Tax Tax Telecom Tax Permits Services
3/31/19 Actual 3,911,481$ 317,801$ 1,625,232$ 415,476$ 278,619$
3/31/18 Actual $ 3,622,770 $ 305,700 $ 1,597,532 $ 877,803 $ 179,814
% Change From Last Year 8.0%4.0%1.7%-52.7%54.9%
Five Year Trend
Major Expenditures Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
3/31/19 Actual 4,570,333$ 109,620$ 1,026,505$ 35,708$ 138,160$
3/31/18 Actual 4,349,630$ 112,473$ 969,849$ 32,829$ 77,891$
% Change From Last Year 5.1%-2.5%5.8%8.8%77.4%
Five Year Trend
Expenditures by Department
3/31/18 3/31/19 3/31/19 3/31/19 2019 Difference Five
YTD YTD YTD % of Annual Prior Year
Department Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 613,277$ 609,613$ 744,875$ 81.8%2,700,820$ (3,664)$
Financial Services 218,286 218,536 239,240 91.3%913,960 250
Public Works 111,494 188,633 250,365 75.3%886,420 77,139
Engineering & Capital Projects 60,184 108,489 114,975 94.4%459,900 48,305
Library 220,674 250,926 255,025 98.4%928,675 30,252
Police 2,135,690 2,207,701 2,606,575 84.7%8,891,960 72,011
Fire 1,940,989 2,052,800 2,233,790 91.9%8,207,785 111,811
Development Services 242,078 243,628 248,245 98.1%982,055 1,550
Total Expenditures 5,542,672$ 5,880,326$ 6,693,090$ 87.9%23,971,575$ 337,654$
Five Year Trend
For the Period Ending March 31, 2019
General Fund - Five Year Trend
Village of Oak Brook
Revenues Expenditures
3/31/19 3/31/19
3/31/18 3/31/19 YTD % of 2019 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Hotel Tax 239,143$ 214,433$ 237,000$ 90.5%1,268,000$ (24,710)$
Interest 16,627 28,601 7,500 381.3%30,000 11,974
Miscellaneous 2,977 - - 0.0%- (2,977)
Total Operating Revenues 258,747$ 243,034$ 244,500$ 99.4%1,298,000$ (15,713)$
EXPENDITURES
Operation and Contract 69,880$ 12,105$ 144,455$ 8.4%577,860$ (57,775)$
Other Expenditures 24,885 25,779 25,770 100.0%103,115 894
Capital Outlay 3,476 - 462,595 0.0%4,180,545 (3,476)
Total Expenditures 98,241$ 37,884$ 632,820$ 6.0%4,861,520$ (60,357)$
NET FUND INCREASE (DECREASE)160,506$ 205,150$ (388,320)$ (3,563,520)$ 44,644$
Note - Expenditures are recorded in program 171.
Village of Oak Brook
Hotel Tax Fund Financial Update
For the Period Ending March 31, 2019
Total Total
Revenues Expenditures
3/31/19 Actual $ 243,034 37,884$
3/31/18 Actual $ 258,747 98,241$
% Change From Last Year -6.1%-61.4%
Major Revenues
Hotel Tax Interest Miscellaneous
3/31/19 Actual $ 214,433 $ 28,601 $ -
3/31/18 Actual $ 239,143 $ 16,627 $ 2,977
% Change From Last Year -10.3%72.0%-100.0%
Five Year Trend
Major Expenditures Operation &Other
Contractual Expenditures Capital Outlay
3/31/19 Actual 12,105$ 25,779$ -$
3/31/18 Actual 69,880$ 24,885$ 3,476$
% Change From Last Year -82.7%3.6%-100.0%
Five Year Trend
Village of Oak Brook
Hotel Tax Fund - Major Sources Five Year Trend
For the Period Ending March 31, 2019
Five Year Trend
Revenues Expenditures
3/31/19 3/31/19
3/31/18 3/31/19 YTD % of 2019 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 1,650,802$ 1,792,810$ 1,653,750$ 108.4%5,548,000$ 142,008$
Interest 32,373 58,891 21,000 280.4%80,000 26,518
Miscellaneous 2,729 - 1,245 0.0%5,000 (2,729)
Total Operating Revenues 1,685,904$ 1,851,701$ 1,675,995$ 110.5%5,633,000$ 165,797$
OPERATING EXPENDITURES
Personnel 363,003$ 378,561$ 377,305$ 100.3%1,322,375$ 15,558$
Materials and Supplies 51,446 81,104 58,480 138.7%246,845 29,658
Operation and Contract 213,551 272,190 412,495 66.0%1,663,435 58,639
Other Expenditures 41,217 40,383 40,395 100.0%161,535 (834)
Capital Outlay 7,056 105,690 2,620,380 4.0%10,008,575 98,634
Total Operating Expenditures 676,273$ 877,928$ 3,509,055$ 25.0%13,402,765$ 201,655$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 1,009,631$ 973,773$ (1,833,060)$ -53.1%(7,769,765)$ (35,858)$
INTERFUND TRANSACTIONS
Transfers In 7,790$ 216,125$ 216,125$ 100.0%1,116,125$ 208,335$
Reimbursements From Other Funds 45,282 83,361 83,370 100.0%333,445 38,079
Total Interfund Transactions 53,072$ 299,486$ 299,495$ 100.0%1,449,570$ 246,414$
NET FUND INCREASE (DECREASE)1,062,703$ 1,273,259$ (1,533,565)$ (6,320,195)$ 210,556$
Village of Oak Brook
Infrastructure Fund Financial Update
For the Period Ending March 31, 2019
Total Total
Revenues Expenditures
3/31/19 Actual $ 1,851,701 877,928$
3/31/18 Actual $ 1,685,904 676,273$
% Change From Last Year 9.8%29.8%
Major Revenues
Sales Tax Grants Interest Miscellaneous Reimbursements
3/31/19 Actual $ 1,792,810 $ - $ 58,891 $ - $ 83,361
3/31/18 Actual $ 1,650,802 $ - $ 32,373 $ 2,729 $ 45,282
% Change From Last Year 8.6%0.0%81.9%-100.0%84.1%
Five Year Trend
Major Expenditures Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
3/31/19 Actual 378,561$ 81,104$ 272,190$ 40,383$ 105,690$
3/31/18 Actual 363,003$ 51,446$ 213,551$ 41,217$ 7,056$
% Change From Last Year 4.3%57.6%27.5%-2.0%1397.9%
Five Year Trend
Expenditures by Department
3/31/18 3/31/19 3/31/19 3/31/19 2019 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 18,646$ 30,120$ 40,045$ 75.2%179,485$ 11,474$
Public Works 593,808 669,669 2,682,685 25.0%6,462,865 75,861
Engineering & Capital Projects 63,819 178,139 786,325 22.7%6,760,415 114,320
Total Expenditures 676,273$ 877,928$ 3,509,055$ 25.0%13,402,765$ 201,655$
Five Year Trend
Village of Oak Brook
Infrastructure Fund - Major Sources Five Year Trend
For the Period Ending March 31, 2019
Revenues Expenditures
3/31/19 3/31/19
3/31/18 3/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 266 396 225 176.0%900 130
Total Operating Revenues 266$ 396$ 225$ 176.0%460,900$ 130$
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)(222,944)$ (230,734)$ (230,905)$ (4,290)$ (7,790)$
Note - Expenditures are recorded in program 283.
Village of Oak Brook
Promenade TIF Fund Financial Update
For the Period Ending March 31, 2019
Total Total
Revenues Expenditures
3/31/19 Actual $ 396 231,130$
3/31/18 Actual $ 266 223,210$
% Change From Last Year 48.9%3.5%
Major Revenues Real Estate
Sales Tax Tax Interest
3/31/19 Actual $ - $ - $ 396
3/31/18 Actual $ - $ - $ 266
% Change From Last Year 0.0%0.0%48.9%
Five Year Trend
Major Expenditures Operation &Other
Contractual Expenditures
3/31/19 Actual -$ 231,130$
3/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 March 31, 2019
Five Year Trend
Revenues Expenditures
3/31/19 3/31/19
3/31/18 3/31/19 YTD % of 2019 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Plan Review Fees 225$ 300$ 375$ 80.0%1,500$ 75$
Building/Inspection Fees 225 1,688 1,245 135.6%5,000 1,463
Water Sales 2,024,151 2,137,068 2,119,980 100.8%10,223,250 112,917
Unmetered Sales 3,418 4,635 7,500 61.8%30,000 1,217
Water Connection Fees 5,520 5,980 12,450 48.0%50,000 460
Fire Service Charge - - 1,245 0.0%5,000 -
Meter Charges 2,448 2,265 5,015 45.2%20,000 (183)
Special Services - - - 0.0%30,000 -
Interest on Investments 20,496 42,274 13,740 307.7%55,000 21,778
Miscellaneous 22,053 11,067 18,750 59.0%75,000 (10,986)
Total Operating Revenues 2,078,536$ 2,205,277$ 2,180,300$ 101.1%10,494,750$ 126,741$
EXPENDITURES
Personnel 199,877$ 199,975$ 221,965$ 90.1%828,710$ 98$
Materials and Supplies 10,200 9,452 23,550 40.1%76,210 (748)
Operation and Contract 829,727 721,453 1,472,455 49.0%5,822,285 (108,274)
Other Expenditures 101,292 137,958 137,965 100.0%551,830 36,666
Capital Outlay 732,074 83,521 647,795 12.9%6,244,075 (648,553)
Total Expenditures 1,873,170$ 1,152,359$ 2,503,730$ 46.0%13,523,110$ (720,811)$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 205,366$ 1,052,918$ (323,430)$ (3,028,360)$ 847,552$
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)205,366$ 1,274,003$ (102,345)$ (2,807,275)$ 1,068,637$
Village of Oak Brook
Water Fund Financial Update
For the Period Ending March 31, 2019
Total Total
Revenues Expenditures
3/31/19 Actual $ 2,205,277 1,152,359$
3/31/18 Actual $ 2,078,536 1,873,170$
% Change From Last Year 6.1%-38.5%
Unmetered Water
Water Sales Sales Connection Fees Meter Charges Miscellaneous
3/31/19 Actual $ 2,137,068 $ 4,635 $ 5,980 $ 2,265 $ 11,067
3/31/18 Actual $ 2,024,151 $ 3,418 $ 5,520 $ 2,448 $ 22,053
% Change From Last Year 5.6%35.6%8.3%-7.5%-49.8%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
3/31/19 Actual 199,975$ 9,452$ 721,453$ 137,958$ 83,521$
3/31/18 Actual 199,877$ 10,200$ 829,727$ 101,292$ 732,074$
% Change From Last Year 0.0%-7.3%-13.0%36.2%-88.6%
Five Year Trend
Expenditures by Department
3/31/18 3/31/19 3/31/19 3/31/19 2019 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Public Works 1,132,723$ 1,071,531$ 1,860,940$ 57.6%7,299,035$ (61,192)$
Engineering & Capital Projects 740,447 80,828 642,790 12.6%6,224,075 (659,619)
Total Expenditures 1,873,170$ 1,152,359$ 2,503,730$ 46.0%13,523,110$ (720,811)$
Five Year Trend
Village of Oak Brook
Water Fund - Major Sources Five Year Trend
For the Period Ending March 31, 2019
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Sports Core Fund Consolidated Presentation
For the Period Ending March 31, 2019
3/31/19 3/31/19
3/31/19 YTD % of 2019 3/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 3,935$ -$ 107,825$ 111,760$ 126,100$ 88.6%453,815$ 126,815$ (15,055)$
Greens Fees - - 10,340 10,340 26,760 38.6%930,000 25,177 (14,837)
Pro Shop Sales - - 19,261 19,261 18,575 103.7%200,000 17,994 1,267
Golf Lessons - - 5,695 5,695 5,000 113.9%40,000 7,065 (1,370)
Driving Range Fees - - 45,429 45,429 37,000 122.8%226,000 34,166 11,263
Rentals - - 4,243 4,243 6,225 68.2%459,000 2,112 2,131
Programs/User Fees 4,790 - - 4,790 4,650 103.0%253,450 4,650 140
Food Sales - 1,344 - 1,344 1,915 70.2%175,500 2,582 (1,238)
Beverage Sales - 2,405 - 2,405 3,000 80.2%252,500 3,721 (1,316)
Other Revenue 139 11,027 1,155 12,321 18,310 67.3%428,300 118,503 (106,182)
Total Direct Revenues 8,864$ 14,776$ 193,948$ 217,588$ 247,535$ 87.9%3,418,565$ 342,785$ (125,197)$
DIRECT EXPENDITURES
Personnel 14,266$ 40,857$ 173,742$ 228,865$ 253,960$ 90.1%1,572,920$ 209,508$ 19,357$
Materials & Supplies 31 2,621 (32,110) (29,458) 38,585 -76.3%580,645 (4,555) (24,903)
Operational & Contractual 274,927 6,809 58,408 340,144 384,480 88.5%1,115,975 372,154 (32,010)
Other - - - - - 0.0%(83,150) - -
Capital 4,519 64,301 91,565 160,385 305,000 52.6%1,655,900 29,731 130,654
Total Direct Expenditures 293,743$ 114,588$ 291,605$ 699,936$ 982,025$ 71.3%4,842,290$ 606,838$ 93,098$
Direct Revenues Over (Under) Expenditures (284,879)$ (99,812)$ (97,657)$ (482,348)$ (734,490)$ 65.7%(1,423,725)$ (264,053)$ (218,295)$
B&T Administration Overhead Allocation*24,741$ (24,741)$ -$ -$ -$ 0.0%-$ -$ -$
Operating Revenues Over (Under) Expenditures (260,138)$ (124,553)$ (97,657)$ (482,348)$ (734,490)$ 65.7%(1,423,725)$ (264,053)$ (218,295)$
Interfund Loan**230,022$ -$ -$ 230,022$ -$ N/A -$ 100,000$ 130,022$
Transfer From General Fund 4,385 33,054 - 37,439 125,000 30.0%1,216,725 - 37,439
Transfer From Golf Surcharge Fund - - 82,047 82,047 105,000 78.1%175,000 - 82,047
Reimbursement From Infrastructure Fund 6,000 - - 6,000 6,000 100.0%24,000 6,000 -
Reimbursement From Water Fund 2,001 - - 2,001 1,995 100.3%8,000 2,001 -
Adjusted Operating Revenues Over (Under) Expenditures (17,730)$ (91,499)$ (15,610)$ (124,839)$ (496,495)$ -$ (156,052)$ 31,213$
*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 and cash becomes available.
Total Direct Total Direct
Revenues Expenditures
3/31/19 Actual $ 217,588 699,936$
3/31/18 Actual $ 342,785 606,838$
% Change From Last Year -36.5%15.3%
Driving Program/
Memberships Greens Fees Range Fees Rentals User Fees
3/31/19 Actual $ 111,760 $ 10,340 $ 45,429 $ 4,243 $ 4,790
3/31/18 Actual $ 126,815 $ 25,177 $ 34,166 $ 2,112 $ 4,650
% Change From Last Year -11.9%-58.9%33.0%100.9%3.0%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
3/31/19 Actual 228,865$ (29,458)$ 340,144$ -$ 160,385$
3/31/18 Actual 209,508$ (4,555)$ 372,154$ -$ 29,731$
% Change From Last Year 9.2%546.7%-8.6%0.0%439.5%
Five Year Trend
Revenues by Department 3/31/18 3/31/19 3/31/19 3/31/19 2019 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Programs 116,547$ 8,864$ 646,495$ 1.4%686,515$ (107,683)$
Food & Beverage 22,227 14,776 127,800 11.6%663,000 (7,451)
Golf Club 204,011 193,948 567,997 34.1%2,069,050 (10,063)
Total Revenues 342,785$ 217,588$ 1,342,292$ 16.2%3,418,565$ (125,197)$
Expenditures by Department 3/31/18 3/31/19 3/31/19 % of 2019 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Programs 307,851$ 293,743$ 344,363$ 85.3%1,883,075$ (14,108)$
Food & Beverage 55,324 114,588 281,968 40.6%1,037,845 59,264
Golf Club 243,663 291,605 778,751 37.4%1,921,370 47,942
Total Expenditures 606,838$ 699,936$ 1,405,082$ 49.8%4,842,290$ 93,098$
Five Year Trend
Village of Oak Brook
Sports Core Fund - Major Sources Five Year Trend
For the Period Ending March 31, 2019
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Bath & Tennis Club Recreation Programs
For the Period Ending March 31, 2019 3/31/19 3/31/19
3/31/19 YTD % of 2019 3/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 -$ 3,535$ 400$ -$ -$ 3,935$ 18,400$ 21.4%244,815$ 11,015$ (7,080)$
Programs/User Fees - - - - 4,790 4,790 4,650 103.0%253,450 4,650 140
Other Revenue (861) - - - 1,000 139 3,260 4.3%188,250 100,882 (100,743)
Total Revenue (861)$ 3,535$ 400$ -$ 5,790$ 8,864$ 26,310$ 33.7%686,515$ 116,547$ (107,683)$
Expenditures:
Personnel 14,266$ -$ -$ -$ -$ 14,266$ 19,040$ 74.9%182,405$ 7,456$ 6,810$
Materials & Supplies 31 - - - - 31 5,230 0.6%26,350 1,766 (1,735)
Operational & Contractual 30,657 230,189 98 - 13,983 274,927 266,005 103.4%673,820 283,687 (8,760)
Other - - - - - - - 0.0%- - -
Capital - 4,519 - - - 4,519 - N/A 1,000,500 14,942 (10,423)
Total Expenditures 44,954$ 234,708$ 98$ -$ 13,983$ 293,743$ 290,275$ 101.2%1,883,075$ 307,851$ (14,108)$
Direct Revenues Over (Under) Expenditures (45,815)$ (231,173)$ 302$ -$ (8,193)$ (284,879)$ (263,965)$ 107.9%(1,196,560)$ (191,304)$ (93,575)$
B&T Administration Overhead Allocation*45,815$ (16,492)$ (4,582)$ -$ -$ 24,741$ 26,315$ 94.0%91,410$ 16,707$ 8,034$
Revenues Over (Under) Expenditures -$ (247,665)$ (4,280)$ -$ (8,193)$ (260,138)$ (237,650)$ 109.5%(1,105,150)$ (174,597)$ (85,541)$
Interfund Loan**230,022$ -$ -$ -$ -$ 230,022$ -$ N/A -$ 100,000$ 130,022$
Transfer From General Fund - 4,385 - - - 4,385 - N/A 965,500 - 4,385
Reimbursement From Infrastructure Fund 6,000 - - - - 6,000 6,000 100.0%24,000 6,000 -$
Reimbursement From Water Fund 2,001 - - - - 2,001 1,995 100.3%8,000 2,001 -
Adjusted Revenues Over (Under) Expenditures 238,023$ (243,280)$ (4,280)$ -$ (8,193)$ (17,730)$ (229,655)$ (107,650)$ (66,596)$ 48,866$
*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. This will be repaid as the season begins and cash becomes available.
Village of Oak Brook
Monthly Operating Statement
Sports Core Food & Beverage Programs
For the Period Ending March 31, 2019
3/31/19 3/31/19
821 822 823 3/31/19 YTD % of 2019 3/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 - - 1,344 1,344 1,915 70.2%175,500 2,582 (1,238)
Beverage Sales - - 2,405 2,405 3,000 80.2%252,500 3,721 (1,316)
Other Revenue 11,027 - - 11,027 15,000 73.5%235,000 15,924 (4,897)
Total Revenue 11,027$ -$ 3,749$ 14,776$ 19,915$ 74.2%663,000$ 22,227$ (7,451)$
Expenditures:
Personnel 29,597$ -$ 11,260$ 40,857$ 43,730$ 93.4%286,125$ 32,654$ 8,203$
Materials & Supplies 2,114 - 507 2,621 11,405 23.0%208,200 5,322 (2,701)
Operational & Contractual 5,854 - 955 6,809 43,735 15.6%153,120 17,348 (10,539)
Capital 64,301 - - 64,301 200,000 32.2%390,400 - 64,301
Total Expenditures 101,866$ -$ 12,722$ 114,588$ 298,870$ 38.3%1,037,845$ 55,324$ 59,264$
Direct Revenues Over (Under) Expenditures (90,839)$ -$ (8,973)$ (99,812)$ (278,955)$ 35.8%(374,845)$ (33,097)$ (66,715)$
B&T Administration Overhead Allocation*(22,908)$ (1,833)$ -$ (24,741)$ (26,315)$ 94.0%(91,410)$ (16,707)$ (8,034)$
Revenues Over (Under) Expenditures (113,747)$ (1,833)$ (8,973)$ (124,553)$ (305,270)$ 40.8%(466,255)$ (49,804)$ (74,749)$
Transfer From General Fund 33,054$ -$ -$ 33,054$ 125,000$ 26.4%251,225$ -$ 33,054$
Adjusted Revenues Over (Under) Expenditures (80,693)$ (1,833)$ (8,973)$ (91,499)$ (180,270)$ (215,030)$ (49,804)$ (41,695)$
*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 March 31, 2019
3/31/19 3/31/19
831 832 833 834 3/31/19 YTD % of 2019 3/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 107,825$ -$ -$ -$ 107,825$ 107,700$ 100.1%209,000$ 115,800$ (7,975)$
Greens Fees 10,340 - - - 10,340 26,760 38.6%930,000 25,177 (14,837)
Pro Shop Sales 19,261 - - - 19,261 18,575 103.7%200,000 17,994 1,267
Golf Lessons - 5,695 - - 5,695 5,000 113.9%40,000 7,065 (1,370)
Driving Range Fees - 45,429 - - 45,429 37,000 122.8%226,000 34,166 11,263
Rentals - - 4,243 - 4,243 6,225 68.2%459,000 2,112 2,131
Other Revenue 1,155 - - - 1,155 50 2310.0%5,050 1,697 (542)
Total Revenue 138,581$ 51,124$ 4,243$ -$ 193,948$ 201,310$ 96.3%2,069,050$ 204,011$ (10,063)$
Expenditures:
Personnel 102,331$ 356$ 529$ 70,526$ 173,742$ 191,190$ 90.9%1,104,390$ 169,398$ 4,344$
Materials & Supplies (34,479) 360 - 2,009 (32,110) 21,950 -146.3%346,095 (11,643) (20,467)
Operational & Contractual 44,843 - - 13,565 58,408 74,740 78.1%289,035 71,119 (12,711)
Other - - - - - - 0.0%(83,150) - -
Capital 91,565 - - - 91,565 105,000 87.2%265,000 14,789 76,776
Total Expenditures 204,260$ 716$ 529$ 86,100$ 291,605$ 392,880$ 74.2%1,921,370$ 243,663$ 47,942$
Direct Revenues Over (Under) Expenditures (65,679)$ 50,408$ 3,714$ (86,100)$ (97,657)$ (191,570)$ 51.0%147,680$ (39,652)$ (58,005)$
Transfer from Golf Surcharge 82,047$ -$ -$ -$ 82,047$ 105,000$ 78.1%175,000$ -$ 82,047$
Adjusted Revenues Over (Under) Expenditures 16,368$ 50,408$ 3,714$ (86,100)$ (15,610)$ (86,570)$ 322,680$ (39,652)$ 24,042$