04 - April 2019 Monthly Financial ReportVILLAGE
OAK BROOK
OF
MONTHLY FINANCIAL REPORTS
APRIL 2019
ITEM 8.D
Total
Cash and Cash Pooled Cash and
Fund Equivalents Investments Investments % By Fund
General Corporate $5,156,491 $14,145,709 $19,302,200 43.2%
Hotel/Motel Tax 2,874,154 1,907,521 4,781,675 10.7%
Motor Fuel Tax 705,253 148,124 853,377 1.9%
Infrastructure 7,451,665 2,507,708 9,959,373 22.3%
Promenade TIF 26,805 - 26,805 0.1%
Water 4,578,055 2,969,260 7,547,315 16.9%
Sports Core 3,669 - 3,669 0.0%
Golf Surcharge 61,704 306,904 368,608 0.8%
Self-Insurance 764,514 - 764,514 1.7%
Garage 367,994 - 367,994 0.8%
Equipment Replacement 236,747 454,803 691,550 1.5%
Total $22,227,051 $22,440,029 $44,667,080 100.0%
Change in Cash and Investments by Fund :
Balance at Balance at Year-to-Date Year-to-Date
Fund January 1, 2019 April 30, 2019 Change ($)Change (%)
General Corporate $18,092,186 $19,302,200 $1,210,014 6.7%
Hotel/Motel Tax 4,843,367 4,781,675 (61,692)-1.3%
Motor Fuel Tax 782,203 853,377 71,174 9.1%
Infrastructure 9,322,381 9,959,373 636,992 6.8%
Promenade TIF 257,485 26,805 (230,680)-89.6%
Water 6,449,315 7,547,315 1,098,000 17.0%
Sports Core 190,397 3,669 (186,728)-98.1%
Golf Surcharge 442,152 368,608 (73,544)-16.6%
Self-Insurance 468,568 764,514 295,946 63.2%
Garage 331,134 367,994 36,860 11.1%
Equipment Replacement 1,636,238 691,550 (944,688)-57.7%
$42,815,426 $44,667,080 $1,851,654 4.3%
Book Bank/Market
Value Value
Pooled Checking ($8,962)$721,365
Sports Core Checking 636,213 607,978
Pooled IPTIP 21,453,173 21,453,173
Water E-Pay IPTIP 146,627 146,627
$22,227,051 $22,929,143
Pooled Investments:
Investments-Municipal Bonds $6,721,555 $6,680,052
Investments-Corporate Bonds 8,162,756 8,179,297
Government & Agency Obligations 688,206 664,926
Certificates of Deposit 6,730,000 6,718,611
Accrued Interest 137,512 137,512
Total Pooled Investments $22,440,029 $22,380,398
Total Cash and Investments $44,667,080 $45,309,541
For April, total interest revenue is $88,804 and YTD revenue is $345,407.
Total investment yield for the portfolio is:
Pooled
Investments Illinois Funds Total
Monthly yield 0.20%0.22%0.21%
YTD yield 0.78%0.85%0.81%
Last 12 months yield 2.12%2.22%2.17%
The weighted average yield of the current pooled investment portfolio is 2.39%.
Monthly Treasurer's Report
April 30, 2019
Monthly Treasurer's Report
April 2019
The table below lists the detail investment holdings at J.P. Morgan Securities as of 4/30/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,993 $99,972 $852
Rosemont IL GO Corp #777543UT4 02/08/16 12/01/19 3.021%2.000%502,899 498,935 6,198
New York N Y City #64971QTX1 02/22/16 05/01/21 2.350%2.000%201,355 199,342 2,336
Florida Hurricane #34074GDH4 03/30/16 07/01/20 2.995%2.150%504,771 502,220 4,991
Bloomingdale Mich Pub Sch Dist #094383FS0 04/26/16 05/01/22 2.710%2.150%508,063 499,575 6,736
Milan Mich Area Achs #598801JD1 05/26/16 05/01/20 1.931%1.931%245,000 243,537 2,265
Indiana Bd Bk Rev Taxable #4546248F7 01/06/17 01/15/20 2.934%1.900%256,809 255,589 2,216
Garland Cnty Ark Sales & Use #36609PAN3 02/06/17 11/01/19 1.795%1.840%499,886 497,790 4,612
Anchor Bay Mich Sch Dist GO #032879TA6 02/13/17 05/01/19 1.810%1.420%365,003 365,000 3,226
Lanse Creuse Mich Pub Schs #516228RL9 05/02/17 05/01/20 2.159%2.159%100,000 99,606 1,077
California St GO Bonds #13063A7G3 05/08/17 10/01/19 6.200%1.600%509,560 507,675 2,301
*Genesee Cnty Mich #371608UV0 05/31/17 10/01/19 2.681%2.681%86,000 86,000 29
Connecticut St GO Bds 2016 #20772J3F7 06/15/17 08/15/21 1.750%2.300%493,902 489,345 1,794
North Carolina Eastn Mun Pwr #65819WAL7 10/02/17 07/01/19 2.578%1.700%500,740 499,855 4,154
Fowlerville Mich Comnty Schs #351280MS8 10/03/17 05/01/20 2.045%1.750%501,465 497,765 4,942
Racine Cnty WI #749845UK7 12/20/17 12/01/20 2.150%2.150%750,000 744,278 6,718
Wisconsin St Gen Fd Annual #977100CW4 01/05/18 05/01/20 1.446%2.100%596,109 593,568 4,242
Total Municipal Bonds $6,721,555 $6,680,052 $58,689
Corporate Bonds:
Goldman Sachs #38141GVP9 09/26/18 09/15/20 2.750%3.180%497,136 500,070 1,719
Fifth Third #31677QBH1 10/11/18 09/27/19 1.625%2.750%995,528 995,700 1,535
JP Morgan #46640QUV1 11/01/18 07/29/19 0.000%3.017%1,488,954 1,490,213 0
Wells Fargo #94974BGR5 01/15/19 12/07/20 2.550%3.120%1,377,772 1,385,969 14,473
SunTrust #86787EAU1 01/28/19 01/29/21 2.590%3.050%498,358 499,200 3,238
PNC Bank #69353RFH6 01/30/19 01/22/21 2.500%3.020%495,661 498,690 3,438
Morgan Stanley #61747WAL3 03/08/19 07/28/21 5.500%3.034%1,105,704 1,108,370 14,758
Citigroup #172967LC3 04/01/19 12/08/21 2.900%2.754%1,003,643 1,000,630 10,956
Bank of America #06051GFT1 04/03/19 10/19/20 2.625%2.625%700,000 700,455 357
Total Corporate Bonds $8,162,756 $8,179,297 $50,474
Government & Agency Obligations:
**Government National Mtg Assn #38379UEM4 02/29/16 02/16/51 2.300%2.245%$688,206 $664,926 $2,175
Total Government & Agency Obligations:$688,206 $664,926 $2,175
Certificates of Deposit:
State Bk India NY #8562846A7 01/26/17 01/26/22 2.250%2.250%$245,000 $242,883 $1,455
Marlin Bank #57116ANU8 05/10/17 11/12/19 1.610%1.610%245,000 243,976 224
American Express Fed Svgs #02587CER7 05/10/17 11/12/19 1.700%1.700%245,000 244,108 1,961
Synchrony Bank #87164WRA8 05/26/17 05/28/19 1.650%1.650%245,000 244,882 1,702
Umpqua Bank #90421MAG8 05/31/17 05/31/19 1.600%1.600%245,000 244,858 1,638
Stone Bk Mtn View Ark #86158RAJ8 06/28/17 06/28/19 1.600%1.600%245,000 244,726 24
TIAA FSB Jacksonville #87270LAA1 07/19/17 07/19/19 1.600%1.600%245,000 244,596 1,095
Peoples United Bank #71270QQZ2 07/19/17 07/19/19 1.650%1.650%245,000 244,623 1,129
Priority Bank Ozark Ark #74269KBR6 07/26/17 07/26/19 1.600%1.600%245,000 244,561 52
American Express Centurion #02587DV96 08/15/17 08/17/20 1.900%1.900%245,000 243,121 951
Sallie Mae #795450C86 08/16/17 08/17/20 1.900%1.900%245,000 243,261 951
Merrick Bank South Jordan #59013JZS1 08/21/17 08/21/20 1.800%1.800%245,000 242,932 126
Pinnacle Bank #72345SFS5 08/30/17 08/31/20 1.800%1.800%115,000 114,009 8
Jackson County Bank #466682AP6 08/31/17 03/01/21 1.850%1.850%245,000 242,288 774
Barclays Bank #06740KKX4 09/27/17 09/28/20 1.950%1.950%245,000 243,270 458
Capital One Bank #1404205E6 10/04/17 10/04/19 1.700%1.700%245,000 244,282 306
Goldman Sachs Bank #38148PRK5 10/18/17 10/19/20 1.950%1.950%245,000 243,199 166
FirstBank PR Santurce #33767A6M8 11/03/17 11/03/20 2.000%2.000%245,000 243,332 368
Morgan Stanley #61747MQ53 03/22/18 03/23/20 2.550%2.550%245,000 245,238 560
Investors Community Bank #46147UTT7 08/28/18 02/28/20 2.550%2.550%245,000 245,233 40
Lakeside Bank #51210SPS0 08/30/18 03/30/20 2.550%2.550%245,000 245,240 23
Bank United #066519GJ2 08/31/18 02/20/20 2.500%2.500%245,000 245,130 1,046
Compass Bank #20451PVW3 10/26/18 10/26/20 3.000%3.000%245,000 246,933 92
UBS Bank #90348JFH8 10/30/18 10/29/20 3.050%3.050%245,000 247,127 31
Citibank #17294XJP2 10/31/18 10/31/20 3.000%3.000%245,000 245,728 3,695
Discover Bank #254673WF9 11/07/18 11/09/20 3.000%3.000%245,000 246,965 3,532
Ally Bank #02007GFX6 11/08/18 11/09/20 3.000%3.000%245,000 246,965 3,512
Comenity Cap Bank #20033AU46 04/15/19 04/15/21 2.500%2.500%245,000 245,145 255
Total Certificates of Deposits $6,730,000 $6,718,611 $26,174
Total J.P.Morgan Securities $22,302,517 $22,242,886 $137,512
*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
April 30, 2019
Cash & Investments by Fund - Total $44.7 million
Cash & Investments by Type - Total $44.7 million
Checking
Illinois Funds
Certificates of Deposit
Municipal Bonds
Corporate Bonds
Government & Agency Obligations
Accrued Interest
General Corporate
43.21%
Hotel/Motel Tax
10.71%Motor Fuel Tax
1.91%
Infrastructure
22.30%
Promenade TIF
0.06%
Water
16.90%
Sports Core
0.01%
Golf Surcharge
0.83%
Self-Insurance
1.71%Garage
0.82%
Equipment
Replacement
1.55%
Checking, $0.7
Illinois Funds, $21.6
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)9,299,553 $8,286,464 $1,013,089 $263,985
Main operating fund of the Village.
Hotel Fund (Major Fund)$338,008 $211,665 $126,343 ($500,565)
Collects and spends resources from the
3% hotel/motel tax.
Motor Fuel Tax Fund $71,175 $0 $71,175 $67,920
Collects and spends resources from the
State motor fuel tax.
Infrastructure Fund (Major Fund)$2,520,307 $1,853,483 $666,824 ($3,015,085)
Accounts for construction and maintenance of
roadways, drainage, and safety path systems.
Promenade TIF Fund (Major Fund)$450 $231,130 ($230,680)($230,830)
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,815,034 $1,655,468 $1,159,566 ($879,985)
Collects user fees for the distribution of water
and maintenance of infrastructure.
Sports Core Fund (Major Fund)$949,171 $1,120,722 ($171,551)($336,540)
Accounts for revenues and expenses relating
to administration, programs, food and beverage
operations, and golf course.
Golf Surcharge Fund $11,713 $85,258 ($73,545)($90,340)
Accounts for the collection of the $3 per round
golf surcharge.
Internal Service Funds
Self Insurance Fund $1,116,757 $675,011 $441,746 ($7,690)
Accounts for the Village's health insurance costs
and the related contributions from the Village,
employees, retirees, and other agencies.
Garage Fund $259,388 $243,541 $15,847 $2,480
Accounts for the maintenance of the Village's vehicle
fleet and the related departmental reimbursements.
Equipment Replacement Fund $78,282 $1,022,138 ($943,856)($1,092,980)
Accounts for the replacement of the Village's vehicle
fleet and the related departmental contributions.
Further information on the Village's major funds (as indicated above) can be found on the proceeding pages.
Executive Summary on Village Funds
Through April 30, 2019
Village of Oak Brook
Monthly Financial Report – Fund Narrative
For the Period Ending April 30, 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
x Sales Tax collections through April
2019 are $4,634,499, which is
$173,962 higher than through April
2018 and $181,249 over FY19 budget
to date. The increase is primarily due
to the opening of newer businesses
in town and general inflationary
growth. April 2019 collections came
in at its lowest amount in the past
five years, however, the 2019 trend
has been positive.
x Licenses and Permits revenue through April 2019 is $578,682, which is $425,834 lower than
through April 2018 and $149,508 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, therefore, the decrease is due to the timing of permits issued.
x Personnel expenditures through April 2019 are $5,869,734, which is $278,559 more than
through April 2018, but $389,126 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.
x Operation and Contract expenditures through April 2019 are $1,521,033, which is $239,761
more than through April 2018, but $80,097 under FY19 budget to date. The increase is primarily
due to the addition of five contracted paramedics to increase ambulance services.
x Capital Outlay expenditures through April 2019 are $485,158, which is $332,728 more than
through April 2018, but $92,687 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
x Hotel Tax collections through April 2019 are $300,158, which is $37,523 lower than through
April 2018 and $28,842 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.
x Capital Outlay expenditures have not occurred through April 2019. Expenditures are $612,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.
Motor Fuel Tax Fund
x Motor Fuel Tax collections through April 2019 are $64,655, which is $1,363 lower than through
April 2018 and $1,265 under FY19 budget to date. Motor Fuel Tax revenue was anticipated to
be down slightly in 2019, but has been coming in slightly lower than projected.
Infrastructure Fund
x Non-Home Rule Sales Tax collections
through April 2019 are $2,113,914,
which is $89,122 higher than through
April 2018 and $90,164 over FY19
budget to date. The increase is
primarily due to the opening of
newer businesses in town and
general inflationary growth. April
2019 collections came in at its lowest
amount in the past five years,
however, the 2019 trend has been
positive.
x Capital Outlay expenditures through April 2019 are $780,752, which is $769,256 higher than
through April 2018, but $3,446,733 under FY19 budget to date. This is due to the timing of FY19
projects being started. Projects are expected to occur later in FY19 or early FY20 as planned.
Water Fund
x Water Sales revenue through April 2019 is $2,491,089, which is $131,618 higher than through
April 2018 and $21,234 over FY19 budget to date. The increase is due to a 5% rate increase
effective January 1, 2019.
x Operation and Contractual expenditures through April 2019 are $1,089,930, which is $148,107
lower than through April 2018 and $869,265 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.
x Capital Outlay expenditures through April 2019 are $107,441, which is $777,661 lower than
through April 2018 and $1,084,879 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
x Other Revenue collections through April 2019 are $28,924, which is $100,301 lower than
through April 2018 and $94,566 under FY19 budget to date. This is due to the $100,000
McDonald’s Taste of Oak Brook sponsorship not coming in for FY19. This sponsorship will be
made up from other sources in FY19.
x Capital Outlay expenditures through April 2019 are $306,494, which is $229,142 higher than
through April 2018, but $78,506 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. Major capital projects to the Sports Core are still planned for
later in FY19.
Equipment Replacement Fund
x Other Expenditures through April 2019 are $1,003,196, 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.
4/30/19 4/30/19
4/30/18 4/30/19 YTD % of 2019 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 4,460,537$ 4,634,499$ 4,453,250$ 104.1%12,325,000$ 173,962$
Other Intergovernmental Tax*438,169 468,813 443,500 105.7%1,227,750 30,644
Telecommunications/Utility Tax 2,123,326 2,171,848 2,047,365 106.1%5,857,500 48,522
Licenses and Permits 1,004,516 578,682 728,190 79.5%2,335,050 (425,834)
Charges for Services 270,442 390,265 465,330 83.9%1,491,400 119,823
Fines and Penalties 62,546 86,964 52,680 165.1%158,000 24,418
Administrative Towing Fees 11,775 7,800 10,000 78.0%30,000 (3,975)
Interest on Investments 102,283 146,137 110,000 132.9%330,000 43,854
Franchise/IMF Maint. Fee 5,912 5,493 53,250 10.3%213,000 (419)
Miscellaneous Income 157,027 90,081 66,200 136.1%212,800 (66,946)
Total Operating Revenues 8,636,533$ 8,580,582$ 8,429,765$ 101.8%24,180,500$ (55,951)$
OPERATING EXPENDITURES
Personnel 5,591,175$ 5,869,734$ 6,258,860$ 93.8%18,183,745$ 278,559$
Materials and Supplies 152,704 144,514 233,220 62.0%559,780 (8,190)
Operation and Contract 1,281,272 1,521,033 1,601,130 95.0%4,224,475 239,761
Other Expenditures 43,772 48,834 48,700 100.3%141,100 5,062
Capital Outlay 152,430 485,158 577,845 84.0%862,475 332,728
Total Operating Expenditures 7,221,353$ 8,069,273$ 8,719,755$ 92.5%23,971,575$ 847,920$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 1,415,180$ 511,309$ (289,990)$ 208,925$ (903,871)$
OTHER TRANSACTIONS
Transfers In -$ 508,235$ 508,235$ 100.0%508,235$ 508,235$
Transfers Out - (42,169) (165,000) 25.6%(1,216,725) (42,169)
Reimbursements From Other Funds 209,684 210,736 210,740 100.0%632,210 1,052
Sports Core Loan - (175,022) - N/A - (175,022)
Total Interfund Transactions 209,684$ 501,780$ 553,975$ 90.6%(76,280)$ 292,096$
NET FUND INCREASE (DECREASE)1,624,864$ 1,013,089$ 263,985$ 132,645$ (611,775)$
*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 April 30, 2019
Total Total
Revenues Expenditures
4/30/19 Actual 8,580,582$ 8,069,273$
4/30/18 Actual 8,636,533$ 7,221,353$
% Change From Last Year -0.6%11.7%
Major Revenues Other
Intergov.Licenses &Charges for
Sales Tax Tax Telecom Tax Permits Services
4/30/19 Actual 4,634,499$ 468,813$ 2,171,848$ 578,682$ 390,265$
4/30/18 Actual $ 4,460,537 $ 438,169 $ 2,123,326 $ 1,004,516 $ 270,442
% Change From Last Year 3.9%7.0%2.3%-42.4%44.3%
Five Year Trend
Major Expenditures Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
4/30/19 Actual 5,869,734$ 144,514$ 1,521,033$ 48,834$ 485,158$
4/30/18 Actual 5,591,175$ 152,704$ 1,281,272$ 43,772$ 152,430$
% Change From Last Year 5.0%-5.4%18.7%11.6%218.3%
Five Year Trend
Expenditures by Department
4/30/18 4/30/19 4/30/19 4/30/19 2019 Difference Five
YTD YTD YTD % of Annual Prior Year
Department Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 789,739$ 773,773$ 948,160$ 81.6%2,700,820$ (15,966)$
Financial Services 308,048 311,869 332,655 93.8%913,960 3,821
Public Works 216,626 259,285 317,195 81.7%886,420 42,659
Engineering & Capital Projects 114,539 264,680 153,300 172.7%459,900 150,141
Library 293,744 315,665 333,285 94.7%928,675 21,921
Police 2,709,405 3,066,456 3,369,335 91.0%8,891,960 357,051
Fire 2,474,888 2,763,742 2,944,595 93.9%8,207,785 288,854
Development Services 314,364 313,803 321,230 97.7%982,055 (561)
Total Expenditures 7,221,353$ 8,069,273$ 8,719,755$ 92.5%23,971,575$ 847,920$
Five Year Trend
For the Period Ending April 30, 2019
General Fund - Five Year Trend
Village of Oak Brook
Revenues Expenditures
4/30/19 4/30/19
4/30/18 4/30/19 YTD % of 2019 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Hotel Tax 337,681$ 300,158$ 329,000$ 91.2%1,268,000$ (37,523)$
Interest 22,754 37,850 10,000 378.5%30,000 15,096
Miscellaneous 2,977 - - 0.0%- (2,977)
Total Operating Revenues 363,412$ 338,008$ 339,000$ 99.7%1,298,000$ (25,404)$
EXPENDITURES
Operation and Contract 100,451$ 177,293$ 192,610$ 92.0%577,860$ 76,842$
Other Expenditures 33,180 34,372 34,360 100.0%103,115 1,192
Capital Outlay 11,483 - 612,595 0.0%4,180,545 (11,483)
Total Expenditures 145,114$ 211,665$ 839,565$ 25.2%4,861,520$ 66,551$
NET FUND INCREASE (DECREASE)218,298$ 126,343$ (500,565)$ (3,563,520)$ (91,955)$
Note - Expenditures are recorded in program 171.
Village of Oak Brook
Hotel Tax Fund Financial Update
For the Period Ending April 30, 2019
Total Total
Revenues Expenditures
4/30/19 Actual $ 338,008 211,665$
4/30/18 Actual $ 363,412 145,114$
% Change From Last Year -7.0%45.9%
Major Revenues
Hotel Tax Interest Miscellaneous
4/30/19 Actual $ 300,158 $ 37,850 $ -
4/30/18 Actual $ 337,681 $ 22,754 $ 2,977
% Change From Last Year -11.1%66.3%-100.0%
Five Year Trend
Major Expenditures Operation &Other
Contractual Expenditures Capital Outlay
4/30/19 Actual 177,293$ 34,372$ -$
4/30/18 Actual 100,451$ 33,180$ 11,483$
% Change From Last Year 76.5%3.6%-100.0%
Five Year Trend
Village of Oak Brook
Hotel Tax Fund - Major Sources Five Year Trend
For the Period Ending April 30, 2019
Five Year Trend
Revenues Expenditures
4/30/19 4/30/19
4/30/18 4/30/19 YTD % of 2019 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 2,024,792$ 2,113,914$ 2,023,750$ 104.5%5,548,000$ 89,122$
Interest 45,652 79,120 28,000 282.6%80,000 33,468
Miscellaneous 2,729 - 1,660 0.0%5,000 (2,729)
Total Operating Revenues 2,073,173$ 2,193,034$ 2,053,410$ 106.8%5,633,000$ 119,861$
OPERATING EXPENDITURES
Personnel 440,984$ 474,710$ 474,910$ 100.0%1,322,375$ 33,726$
Materials and Supplies 75,032 96,896 87,805 110.4%246,845 21,864
Operation and Contract 291,659 447,281 551,725 81.1%1,663,435 155,622
Other Expenditures 54,956 53,844 53,855 100.0%161,535 (1,112)
Capital Outlay 11,496 780,752 4,227,485 18.5%10,008,575 769,256
Total Operating Expenditures 874,127$ 1,853,483$ 5,395,780$ 34.4%13,402,765$ 979,356$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 1,199,046$ 339,551$ (3,342,370)$ -10.2%(7,769,765)$ (859,495)$
INTERFUND TRANSACTIONS
Transfers In 7,790$ 216,125$ 216,125$ 100.0%1,116,125$ 208,335$
Reimbursements From Other Funds 60,376 111,148 111,160 100.0%333,445 50,772
Total Interfund Transactions 68,166$ 327,273$ 327,285$ 100.0%1,449,570$ 259,107$
NET FUND INCREASE (DECREASE)1,267,212$ 666,824$ (3,015,085)$ (6,320,195)$ (600,388)$
Village of Oak Brook
Infrastructure Fund Financial Update
For the Period Ending April 30, 2019
Total Total
Revenues Expenditures
4/30/19 Actual $ 2,193,034 1,853,483$
4/30/18 Actual $ 2,073,173 874,127$
% Change From Last Year 5.8%112.0%
Major Revenues
Sales Tax Grants Interest Miscellaneous Reimbursements
4/30/19 Actual $ 2,113,914 $ - $ 79,120 $ - $ 111,148
4/30/18 Actual $ 2,024,792 $ - $ 45,652 $ 2,729 $ 60,376
% Change From Last Year 4.4%0.0%73.3%-100.0%84.1%
Five Year Trend
Major Expenditures Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
4/30/19 Actual 474,710$ 96,896$ 447,281$ 53,844$ 780,752$
4/30/18 Actual 440,984$ 75,032$ 291,659$ 54,956$ 11,496$
% Change From Last Year 7.6%29.1%53.4%-2.0%6691.5%
Five Year Trend
Expenditures by Department
4/30/18 4/30/19 4/30/19 4/30/19 2019 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 45,399$ 41,697$ 57,240$ 72.8%179,485$ (3,702)$
Public Works 741,422 852,378 3,886,875 21.9%6,462,865 110,956
Engineering & Capital Projects 87,306 959,408 1,451,665 66.1%6,760,415 872,102
Total Expenditures 874,127$ 1,853,483$ 5,395,780$ 34.4%13,402,765$ 979,356$
Five Year Trend
Village of Oak Brook
Infrastructure Fund - Major Sources Five Year Trend
For the Period Ending April 30, 2019
Revenues Expenditures
4/30/19 4/30/19
4/30/18 4/30/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 338 450 300 150.0%900 112
Total Operating Revenues 338$ 450$ 300$ 150.0%460,900$ 112$
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,872)$ (230,680)$ (230,830)$ (4,290)$ (7,808)$
Note - Expenditures are recorded in program 283.
Village of Oak Brook
Promenade TIF Fund Financial Update
For the Period Ending April 30, 2019
Total Total
Revenues Expenditures
4/30/19 Actual $ 450 231,130$
4/30/18 Actual $ 338 223,210$
% Change From Last Year 33.1%3.5%
Major Revenues Real Estate
Sales Tax Tax Interest
4/30/19 Actual $ - $ - $ 450
4/30/18 Actual $ - $ - $ 338
% Change From Last Year 0.0%0.0%33.1%
Five Year Trend
Major Expenditures Operation &Other
Contractual Expenditures
4/30/19 Actual -$ 231,130$
4/30/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 April 30, 2019
Five Year Trend
Revenues Expenditures
4/30/19 4/30/19
4/30/18 4/30/19 YTD % of 2019 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Plan Review Fees 300$ 525$ 500$ 105.0%1,500$ 225$
Building/Inspection Fees 300 1,838 1,660 110.7%5,000 1,538
Water Sales 2,359,471 2,491,089 2,469,855 100.9%10,223,250 131,618
Unmetered Sales 6,120 6,497 10,000 65.0%30,000 377
Water Connection Fees 7,130 11,500 16,600 69.3%50,000 4,370
Fire Service Charge - - 1,660 0.0%5,000 -
Meter Charges 3,713 3,740 6,680 56.0%20,000 27
Special Services - - - 0.0%30,000 -
Interest on Investments 28,058 57,800 18,320 315.5%55,000 29,742
Miscellaneous 30,607 20,960 25,000 83.8%75,000 (9,647)
Total Operating Revenues 2,435,699$ 2,593,949$ 2,550,275$ 101.7%10,494,750$ 158,250$
EXPENDITURES
Personnel 256,490$ 263,683$ 285,930$ 92.2%828,710$ 7,193$
Materials and Supplies 15,047 10,470 29,950 35.0%76,210 (4,577)
Operation and Contract 1,238,037 1,089,930 1,959,195 55.6%5,822,285 (148,107)
Other Expenditures 135,056 183,944 183,950 100.0%551,830 48,888
Capital Outlay 885,102 107,441 1,192,320 9.0%6,244,075 (777,661)
Total Expenditures 2,529,732$ 1,655,468$ 3,651,345$ 45.3%13,523,110$ (874,264)$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES (94,033)$ 938,481$ (1,101,070)$ (3,028,360)$ 1,032,514$
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)(94,033)$ 1,159,566$ (879,985)$ (2,807,275)$ 1,253,599$
Village of Oak Brook
Water Fund Financial Update
For the Period Ending April 30, 2019
Total Total
Revenues Expenditures
4/30/19 Actual $ 2,593,949 1,655,468$
4/30/18 Actual $ 2,435,699 2,529,732$
% Change From Last Year 6.5%-34.6%
Unmetered Water
Water Sales Sales Connection Fees Meter Charges Miscellaneous
4/30/19 Actual $ 2,491,089 $ 6,497 $ 11,500 $ 3,740 $ 20,960
4/30/18 Actual $ 2,359,471 $ 6,120 $ 7,130 $ 3,713 $ 30,607
% Change From Last Year 5.6%6.2%61.3%0.7%-31.5%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
4/30/19 Actual 263,683$ 10,470$ 1,089,930$ 183,944$ 107,441$
4/30/18 Actual 256,490$ 15,047$ 1,238,037$ 135,056$ 885,102$
% Change From Last Year 2.8%-30.4%-12.0%36.2%-87.9%
Five Year Trend
Expenditures by Department
4/30/18 4/30/19 4/30/19 4/30/19 2019 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Public Works 1,628,612$ 1,535,075$ 2,465,695$ 62.3%7,299,035$ (93,537)$
Engineering & Capital Projects 901,120 120,393 1,185,650 10.2%6,224,075 (780,727)
Total Expenditures 2,529,732$ 1,655,468$ 3,651,345$ 45.3%13,523,110$ (874,264)$
Five Year Trend
Village of Oak Brook
Water Fund - Major Sources Five Year Trend
For the Period Ending April 30, 2019
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Sports Core Fund Consolidated Presentation
For the Period Ending April 30, 2019
4/30/19 4/30/19
4/30/19 YTD % of 2019 4/30/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 70,415$ -$ 170,425$ 240,840$ 251,470$ 95.8%453,815$ 232,400$ 8,440$
Greens Fees - - 61,841 61,841 79,010 78.3%930,000 72,968 (11,127)
Pro Shop Sales - - 44,314 44,314 44,890 98.7%200,000 40,180 4,134
Golf Lessons - - 14,035 14,035 13,500 104.0%40,000 14,430 (395)
Driving Range Fees - - 90,203 90,203 75,700 119.2%226,000 69,552 20,651
Rentals - - 98,982 98,982 35,325 280.2%459,000 88,730 10,252
Programs/User Fees 28,798 - - 28,798 31,120 92.5%253,450 31,746 (2,948)
Food Sales - 10,753 - 10,753 12,465 86.3%175,500 9,193 1,560
Beverage Sales - 17,364 - 17,364 19,090 91.0%252,500 15,542 1,822
Other Revenue 5,740 19,482 3,702 28,924 123,490 23.4%428,300 129,225 (100,301)
Total Direct Revenues 104,953$ 47,599$ 483,502$ 636,054$ 686,060$ 92.7%3,418,565$ 703,966$ (67,912)$
DIRECT EXPENDITURES
Personnel 26,408$ 60,129$ 255,604$ 342,141$ 361,395$ 94.7%1,572,920$ 311,473$ 30,668$
Materials & Supplies 781 18,905 28,961 48,647 119,970 40.5%580,645 22,896 25,751
Operational & Contractual 309,897 24,763 88,780 423,440 436,895 96.9%1,115,975 418,155 5,285
Other - - - - - N/A (83,150) 8,262 (8,262)
Capital 6,064 92,879 207,551 306,494 385,000 79.6%1,655,900 77,352 229,142
Total Direct Expenditures 343,150$ 196,676$ 580,896$ 1,120,722$ 1,303,260$ 86.0%4,842,290$ 838,138$ 282,584$
Direct Revenues Over (Under) Expenditures (238,197)$ (149,077)$ (97,394)$ (484,668)$ (617,200)$ 78.5%(1,423,725)$ (134,172)$ (350,496)$
B&T Administration Overhead Allocation*33,750$ (33,750)$ -$ -$ -$ 0.0%-$ -$ -$
Operating Revenues Over (Under) Expenditures (204,447)$ (182,827)$ (97,394)$ (484,668)$ (617,200)$ 78.5%(1,423,725)$ (134,172)$ (350,496)$
Interfund Loan**175,022$ -$ -$ 175,022$ -$ N/A -$ -$ 175,022$
Transfer From General Fund 4,385 37,784 - 42,169 165,000 25.6%1,216,725 - 42,169
Transfer From Golf Surcharge Fund - - 85,258 85,258 105,000 81.2%175,000 - 85,258
Reimbursement From Infrastructure Fund 8,000 - - 8,000 8,000 100.0%24,000 8,000 -
Reimbursement From Water Fund 2,668 - - 2,668 2,660 100.3%8,000 2,668 -
Adjusted Operating Revenues Over (Under) Expenditures (14,372)$ (145,043)$ (12,136)$ (171,551)$ (336,540)$ -$ (123,504)$ (48,047)$
*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
4/30/19 Actual $ 636,054 1,120,722$
4/30/18 Actual $ 703,966 838,138$
% Change From Last Year -9.6%33.7%
Driving Program/
Memberships Greens Fees Range Fees Rentals User Fees
4/30/19 Actual $ 240,840 $ 61,841 $ 90,203 $ 98,982 $ 28,798
4/30/18 Actual $ 232,400 $ 72,968 $ 69,552 $ 88,730 $ 31,746
% Change From Last Year 3.6%-15.2%29.7%11.6%-9.3%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
4/30/19 Actual 342,141$ 48,647$ 423,440$ -$ 306,494$
4/30/18 Actual 311,473$ 22,896$ 418,155$ 8,262$ 77,352$
% Change From Last Year 9.8%112.5%1.3%0.0%296.2%
Five Year Trend
Revenues by Department 4/30/18 4/30/19 4/30/19 4/30/19 2019 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Programs 195,608$ 104,953$ 646,495$ 16.2%686,515$ (90,655)$
Food & Beverage 48,321 47,599 127,800 37.2%663,000 (722)
Golf Club 460,037 483,502 567,997 85.1%2,069,050 23,465
Total Revenues 703,966$ 636,054$ 1,342,292$ 47.4%3,418,565$ (67,912)$
Expenditures by Department 4/30/18 4/30/19 4/30/19 % of 2019 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Programs 359,481$ 343,150$ 344,363$ 99.6%1,883,075$ (16,331)$
Food & Beverage 107,623 196,676 281,968 69.8%1,037,845 89,053
Golf Club 371,034 580,896 778,751 74.6%1,921,370 209,862
Total Expenditures 838,138$ 1,120,722$ 1,405,082$ 79.8%4,842,290$ 282,584$
Five Year Trend
Village of Oak Brook
Sports Core Fund - Major Sources Five Year Trend
For the Period Ending April 30, 2019
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Bath & Tennis Club Recreation Programs
For the Period Ending April 30, 2019 4/30/19 4/30/19
4/30/19 YTD % of 2019 4/30/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 -$ 70,015$ 400$ -$ -$ 70,415$ 88,020$ 80.0%244,815$ 61,625$ 8,790$
Programs/User Fees - - 7,035 - 21,763 28,798 31,120 92.5%253,450 31,746 (2,948)
Other Revenue (760) - - - 6,500 5,740 103,290 5.6%188,250 102,237 (96,497)
Total Revenue (760)$ 70,015$ 7,435$ -$ 28,263$ 104,953$ 222,430$ 47.2%686,515$ 195,608$ (90,655)$
Expenditures:
Personnel 26,408$ -$ -$ -$ -$ 26,408$ 35,980$ 73.4%182,405$ 24,815$ 1,593$
Materials & Supplies 54 727 - - - 781 11,530 6.8%26,350 3,245 (2,464)
Operational & Contractual 35,278 234,349 2,534 20,000 17,736 309,897 281,725 110.0%673,820 295,679 14,218
Capital - 6,064 - - - 6,064 40,000 15.2%1,000,500 35,742 (29,678)
Total Expenditures 61,740$ 241,140$ 2,534$ 20,000$ 17,736$ 343,150$ 369,235$ 92.9%1,883,075$ 359,481$ (16,331)$
Direct Revenues Over (Under) Expenditures (62,500)$ (171,125)$ 4,901$ (20,000)$ 10,527$ (238,197)$ (146,805)$ 162.3%(1,196,560)$ (163,873)$ (74,324)$
B&T Administration Overhead Allocation*62,500$ (22,500)$ (6,250)$ -$ -$ 33,750$ 39,535$ 85.4%91,410$ 29,589$ 4,161$
Revenues Over (Under) Expenditures -$ (193,625)$ (1,349)$ (20,000)$ 10,527$ (204,447)$ (107,270)$ 190.6%(1,105,150)$ (134,284)$ (70,163)$
Interfund Loan**175,022$ -$ -$ -$ -$ 175,022$ -$ N/A -$ -$ 175,022$
Transfer From General Fund - 4,385 - - - 4,385 40,000 11.0%965,500 - 4,385
Reimbursement From Infrastructure Fund 8,000 - - - - 8,000 8,000 100.0%24,000 8,000 -$
Reimbursement From Water Fund 2,668 - - - - 2,668 2,660 100.3%8,000 2,668 -
Adjusted Revenues Over (Under) Expenditures 185,690$ (189,240)$ (1,349)$ (20,000)$ 10,527$ (14,372)$ (56,610)$ (107,650)$ (123,616)$ 109,244$
*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 April 30, 2019
4/30/19 4/30/19
821 822 823 4/30/19 YTD % of 2019 4/30/18 Difference
B&T Poolside Golf YTD Amended Amended Adopted YTD Prior
Clubhouse Café Clubhouse Total Budget Budget Budget Total Year
Revenues:
Food Sales -$ -$ 10,753$ 10,753$ 12,465$ 86.3%175,500$ 9,193$ 1,560$
Beverage Sales - - 17,364 17,364 19,090 91.0%252,500 15,542 1,822
Other Revenue 19,482 - - 19,482 20,000 97.4%235,000 23,586 (4,104)
Total Revenue 19,482$ -$ 28,117$ 47,599$ 51,555$ 92.3%663,000$ 48,321$ (722)$
Expenditures:
Personnel 38,802$ -$ 21,327$ 60,129$ 61,450$ 97.9%286,125$ 46,879$ 13,250$
Materials & Supplies 2,149 317 16,439 18,905 30,340 62.3%208,200 25,216 (6,311)
Operational & Contractual 21,676 - 3,087 24,763 54,120 45.8%153,120 35,528 (10,765)
Capital 92,879 - - 92,879 200,000 46.4%390,400 - 92,879
Total Expenditures 155,506$ 317$ 40,853$ 196,676$ 345,910$ 56.9%1,037,845$ 107,623$ 89,053$
Direct Revenues Over (Under) Expenditures (136,024)$ (317)$ (12,736)$ (149,077)$ (294,355)$ 50.6%(374,845)$ (59,302)$ (89,775)$
B&T Administration Overhead Allocation*(31,250)$ (2,500)$ -$ (33,750)$ (39,535)$ 85.4%(91,410)$ (29,589)$ (4,161)$
Revenues Over (Under) Expenditures (167,274)$ (2,817)$ (12,736)$ (182,827)$ (333,890)$ 54.8%(466,255)$ (88,891)$ (93,936)$
Transfer From General Fund 37,784$ -$ -$ 37,784$ 125,000$ 30.2%251,225$ -$ 37,784$
Adjusted Revenues Over (Under) Expenditures (129,490)$ (2,817)$ (12,736)$ (145,043)$ (208,890)$ (215,030)$ (88,891)$ (56,152)$
*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 April 30, 2019
4/30/19 4/30/19
831 832 833 834 4/30/19 YTD % of 2019 4/30/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 170,425$ -$ -$ -$ 170,425$ 163,450$ 104.3%209,000$ 170,775$ (350)$
Greens Fees 61,841 - - - 61,841 79,010 78.3%930,000 72,968 (11,127)
Pro Shop Sales 44,314 - - - 44,314 44,890 98.7%200,000 40,180 4,134
Golf Lessons - 14,035 - - 14,035 13,500 104.0%40,000 14,430 (395)
Driving Range Fees - 90,203 - - 90,203 75,700 119.2%226,000 69,552 20,651
Rentals 200 75,000 23,782 - 98,982 35,325 280.2%459,000 88,730 10,252
Other Revenue 3,702 - - - 3,702 200 1851.0%5,050 3,402 300
Total Revenue 280,482$ 179,238$ 23,782$ -$ 483,502$ 412,075$ 117.3%2,069,050$ 460,037$ 23,465$
Expenditures:
Personnel 138,264$ 3,027$ 4,421$ 109,892$ 255,604$ 263,965$ 96.8%1,104,390$ 239,779$ 15,825$
Materials & Supplies 10,422 2,067 96 16,376 28,961 78,100 37.1%346,095 (5,565) 34,526
Operational & Contractual 64,194 - 8,262 16,324 88,780 101,050 87.9%289,035 86,948 1,832
Other - - - - - - N/A (83,150) 8,262 (8,262)
Capital 194,016 - - 13,535 207,551 145,000 143.1%265,000 41,610 165,941
Total Expenditures 406,896$ 5,094$ 12,779$ 156,127$ 580,896$ 588,115$ 98.8%1,921,370$ 371,034$ 209,862$
Direct Revenues Over (Under) Expenditures (126,414)$ 174,144$ 11,003$ (156,127)$ (97,394)$ (176,040)$ 55.3%147,680$ 89,003$ (186,397)$
Transfer from Golf Surcharge 85,258$ -$ -$ -$ 85,258$ 105,000$ 81.2%175,000$ -$ 85,258$
Adjusted Revenues Over (Under) Expenditures (41,156)$ 174,144$ 11,003$ (156,127)$ (12,136)$ (71,040)$ 322,680$ 89,003$ (101,139)$