10 - October 2017 Monthly Financial ReportVILLAGE
OAK BROOK
OF
MONTHLY FINANCIAL REPORTS
OCTOBER 2017
RG
Total
Cash and Cash Pooled Cash and
Fund Equivalents Investments Investments % By Fund
General Corporate $5,785,084 $13,050,922 $18,836,006 46.8%
Hotel/Motel Tax 1,816,365 2,203,534 4,019,899 10.0%
Motor Fuel Tax 218,454 477,935 696,389 1.7%
Promenade TIF 242,366 - 242,366 0.6%
Water 4,165,642 860,975 5,026,617 12.5%
Self-Insurance 275,259 - 275,259 0.7%
Sports Core 680,829 541,298 1,222,127 3.0%
Golf Surcharge 8,360 - 8,360 0.0%
Equipment Replacement 837,993 944,704 1,782,697 4.4%
Infrastructure 4,414,342 3,341,723 7,756,065 19.3%
Garage 401,380 - 401,380 1.0%
Total $18,846,074 $21,421,092 $40,267,166 100.0%
Change in Cash and Investments by Fund :
Balance at Balance at Year-to-Date Year-to-Date
Fund January 1, 2017 October 31, 2017 Change ($)Change (%)
General Corporate $16,586,097 $18,836,006 $2,249,909 13.6%
Hotel/Motel Tax 4,415,721 4,019,899 (395,823)-9.0%
Motor Fuel Tax 909,926 696,389 (213,536)-23.5%
Promenade TIF 249,278 242,366 (6,912)-2.8%
Water 2,732,210 5,026,617 2,294,408 84.0%
Self-Insurance 589,849 275,259 (314,590)-53.3%
Sports Core 701,448 1,222,127 520,679 74.2%
Golf Surcharge 0 8,360 8,360 N/A
Equipment Replacement 1,510,026 1,782,697 272,671 18.1%
Infrastructure 5,436,080 7,756,065 2,319,985 42.7%
Garage 347,053 401,380 54,327 15.7%
$33,477,689 $40,267,166 $6,789,477 20.3%
Book Market
Value Value
Pooled Checking $615,578 $615,578
Sports Core Checking 688,895 688,895
Pooled IPTIP 17,531,741 17,531,741
Water E-Pay IPTIP 9,860 9,860
$18,846,074 $18,846,074
Pooled Investments:
Certificates of Deposit $6,965,000 $6,954,592
Investments-Municipal 8,648,391 8,616,023
Investments-Corporate 4,788,914 4,785,559
Government & Agency Obligations 895,960 876,621
Accrued Interest 122,827 122,827
Total Pooled Investments $21,421,092 $21,355,622
Total Cash and Investments $40,267,166 $40,201,696
For October, total interest revenue is $45,372 and year to date is $359,251.
Total investment yield for the portfolio is:
Pooled
Investments Illinois Funds Total
Monthly yield 0.14%0.11%0.12%
YTD yield 1.20%0.75%0.90%
Last 12 months yield 1.40%0.82%1.13%
The weighted average yield of the current pooled investment portfolio is 1.66%.
Monthly Treasurer's Report
October 31, 2017
Monthly Treasurer's Report
October 2017
The table below lists the detail investment holdings at J.P. Morgan Securities as of 10/31/17:
Month End VOB
Settlement Maturity Coupon Yield Book Market Accrued
Type Date Date Rate Rate Value Value Interest
Municipal Bonds:
Public Utility District #181117EP3 09/02/14 1/1/2018 1.667%1.650%$600,314 $600,108 $3,379
Florida Hurricane #34074GDG6 01/05/15 7/1/2018 2.107%2.090%751,517 751,275 5,254
Maryland St Econ Dev #57420PGK6 07/08/15 6/1/2019 2.050%2.123%99,885 100,459 852
Rosemont IL GO Corp #777543UT4 02/08/16 12/1/2019 3.021%2.000%510,351 506,715 6,198
New York St Urban Dev Corp #650035J58 02/22/16 3/15/2018 1.650%1.150%175,322 175,147 360
New York N Y City #64971QTX1 02/22/16 5/1/2021 2.350%2.000%202,349 201,654 2,336
Florida Hurricane #34074GDH4 03/30/16 7/1/2020 2.995%2.150%510,851 508,655 4,991
Bloomingdale Mich Pub Sch Dist #094383FS0 04/26/16 5/1/2022 2.710%2.150%511,937 504,495 6,736
Milan Mich Area Achs #598801JD1 05/26/16 5/1/2020 1.931%1.931%245,000 245,250 2,265
Indiana Bd Bk Rev Taxable #4546248F7 01/06/17 1/15/2020 2.934%1.900%260,654 260,039 2,216
North Carolina Eastn Mun PWR #65819WAC7 01/30/17 7/1/2018 2.003%1.450%702,542 701,498 4,673
Garland Cnty Ark Sales & Use #36609PAN3 02/06/17 11/1/2019 1.795%1.840%499,556 497,090 4,612
Anchor Bay Mich Sch Dist GO #032879TA6 02/13/17 5/1/2019 1.810%1.420%367,115 365,533 3,226
Macomb Cnty Mich Retirees #554885H63 04/11/17 11/1/2018 1.731%1.300%401,713 400,196 3,419
Lanse Creuse Mich Pub Schs #516228RL9 05/02/17 5/1/2020 2.159%2.159%100,000 100,606 1,071
California St GO Bonds #13063A7G3 05/08/17 10/1/2019 6.200%1.600%543,400 541,270 2,301
*Genesee Cnty Mich #371608UV0 05/31/17 10/1/2019 1.835%1.835%665,000 665,013 1,008
Connecticut St GO Bds 2016 #20772J3F7 06/15/17 8/15/2021 1.750%2.300%490,057 483,785 1,794
North Carolina Eastn Mun Pwr #65819WAL7 10/02/17 7/1/2019 2.578%1.700%507,219 505,465 4,153
Fowlerville Mich Comnty Schs #351280MS8 10/03/17 5/1/2020 2.045%1.750%503,609 501,770 4,942
Total Municipal Bonds $8,648,391 $8,616,023 $65,787
Corporate Bonds:
MacCormick & Co #579780AF4 04/06/17 12/15/2017 5.750%1.401%$502,679 $502,280 $10,755
JP Morgan Chase #46625HJG6 06/08/17 1/25/2018 1.800%1.371%845,847 845,448 4,001
Goldman Sachs Group #38141GRC0 06/08/17 1/22/2018 2.375%1.531%1,001,901 1,001,750 6,445
Wachovia #92976WBH8 06/15/17 2/1/2018 5.750%1.360%1,044,486 1,043,537 14,488
Morgan Stanley #6174467U7 08/28/17 4/25/2018 2.125%1.531%1,394,001 1,392,544 446
Total Corporate Bonds $4,788,914 $4,785,559 $36,135
Government & Agency Obligations:
**Government National Mtg Assn #38379UEM4 02/29/16 2/16/2051 2.300%2.245%$895,960 $876,621 $2,126
Total Government & Agency Obligations:$895,960 $876,621 $2,126
Certificates of Deposit:
Capital One Natl Assn VA #14042E5Z9 08/26/15 8/27/2018 1.75%1.75%$245,000 $245,598 $1,206
Ally Bk Midvale Utah #02006LVC4 10/29/15 10/29/2018 1.60%1.60%245,000 245,439 0
Wex Bank Midvale Utah #92937CDY1 07/29/16 7/30/2018 1.00%1.00%245,000 244,459 626
Bank Hope Los Angeles #062683AB3 08/26/16 8/27/2018 1.00%1.00%245,000 244,052 26
Wells Fargo Bank Natl Assn #949763AL0 08/31/16 8/31/2018 1.10%1.10%245,000 244,049 6
BMW Bank #05580AFG4 09/23/16 9/24/2018 1.10%1.10%245,000 243,866 277
Comenity Cap Bank #20033ASB3 09/26/16 9/26/2018 1.10%1.10%245,000 243,849 33
Enerbank #29266N4E4 10/21/16 10/22/2018 1.10%1.10%245,000 244,057 75
Discover Bank #254672L71 10/26/16 10/26/2018 1.20%1.20%245,000 243,626 41
Bank of Baroda #06062QXT6 11/30/16 11/30/2017 0.95%0.95%245,000 244,983 2,134
State Bk India NY #8562846A7 01/26/17 1/26/2022 2.25%2.25%245,000 246,112 1,477
Marlin Business Bk #57116ANU8 05/10/17 11/12/2019 1.60%1.60%245,000 244,402 219
American Express Fed Svgs #02587CER7 05/10/17 11/12/2019 1.70%1.70%245,000 244,162 1,978
Synchrony Bank #87164WRA8 05/26/17 5/28/2019 1.65%1.65%245,000 245,083 1,718
Umpqua Bank #90421MAG8 05/31/17 5/31/2019 1.60%1.60%245,000 244,887 1,644
Stone Bk Mtn View Ark #86158RAJ8 06/28/17 6/28/2019 1.60%1.60%245,000 244,821 18
Investors Savings Bk #46176PGU3 06/30/17 4/2/2018 1.35%1.35%245,000 245,105 1,103
TIAA FSB Jacksonville #87270LAA1 07/19/17 7/19/2019 1.60%1.60%245,000 244,765 1,111
Peoples United Bank #71270QQZ2 07/19/17 7/19/2019 1.65%1.65%245,000 244,971 1,145
Priority Bank Ozark Ark #74269KBR6 07/26/17 7/26/2019 1.60%1.60%245,000 244,748 46
American Express Centurion #02587DV96 08/15/17 8/17/2020 1.90%1.90%245,000 243,927 970
Sallie Mae #795450C86 08/16/17 8/17/2020 1.90%1.90%245,000 244,922 970
Merrick Bank South Jordan #59013JZS1 08/21/17 8/21/2020 1.80%1.80%245,000 244,238 120
Pinnacle Bank #72345SFS5 08/30/17 8/31/2020 1.80%1.80%115,000 114,618 5
Jackson County Bank #466682AP6 08/31/17 3/1/2021 1.85%1.85%245,000 243,814 755
Barclays Bank #06740KKX4 09/27/17 9/28/2020 1.95%1.95%245,000 245,071 438
Capital One Bank #1404205E6 10/04/17 10/4/2019 1.70%1.70%245,000 245,002 301
Transportation Alliance #89388CCB2 10/13/17 4/12/2019 1.60%1.60%235,000 234,993 178
Goldman Sachs Bank #38148PRK5 10/18/17 10/19/2020 1.95%1.95%245,000 244,973 159
Total Certificates of Deposits $6,965,000 $6,954,592 $18,780
Total J.P.Morgan Securities $21,298,265 $21,232,795 $122,827
*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
October 31, 2017
Cash & Investments by Fund - Total $40.3 million
Cash & Investments by Type - Total $40.3 million
Checking
Illinois Funds
Certificates of Deposit
Municipal Bonds
Corporate Bonds
Government & Agency Obligations
Accrued Interest
General Corporate
46.78%
Hotel/Motel Tax
9.98%Motor Fuel Tax
1.72%
TIF #1
Butterfield/Meyers
0.60%
Water
12.48%
Self-Insurance
0.68%
Sports Core
3.04%
Golf Surcharge
0.02%
Equipment
Replacement
4.43%Infrastructure
19.26%
Garage
1.00%
Checking, $1.3
Illinois Funds, $17.5
Certificates of Deposit,
$7.0
Municipal Bonds, $8.7
Corporate Bonds, $4.8
Government & Agency
Obligations, $0.9
Accrued Interest, $0.1
in millions
YTD YTD
Net Fund Budget
Increase Increase
Governmental Funds Revenues Expenditures (Decrease)(Decrease)
General Fund (Major Fund)$20,484,879 $18,781,314 $1,703,565 ($371,755)
Main operating fund of the Village.
Hotel Fund (Major Fund)$1,117,179 $1,328,660 ($211,481)($1,486,555)
Collects and spends resources from the
3% hotel/motel tax.
Motor Fuel Tax Fund $176,068 $389,604 ($213,536)($387,465)
Collects and spends resources from the
State motor fuel tax.
Infrastructure Fund (Major Fund)$5,360,390 $2,785,676 $2,574,714 $1,802,635
Accounts for construction and maintenance of
roadways, drainage, and safety path systems.
Promenade TIF Fund (Major Fund)$451,426 $458,338 ($6,912)($36,380)
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)$8,123,032 $5,476,580 $2,646,452 ($1,372,155)
Collects user fees for the distribution of water
and maintenance of infrastructure.
Sports Core Fund (Major Fund)$3,366,743 $2,869,148 $497,595 $264,725
Accounts for revenues and expenses relating
to administration, programs, food and beverage
operations, and golf course.
Golf Surcharge Fund $112,767 $0 $112,767 $117,910
Accounts for the collection of the $3 per round
golf surcharge.
Internal Service Funds
Self Insurance Fund $2,610,822 $2,703,484 ($92,662)($29,360)
Accounts for the Village's health insurance costs
and the related contributions from the Village,
employees, retirees, and other agencies.
Garage Fund $623,489 $538,501 $84,988 ($67,160)
Accounts for the maintenance of the Village's vehicle
fleet and the related departmental reimbursements.
Equipment Replacement Fund $671,188 $398,517 $272,671 $161,610
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 October 31, 2017
10/31/17 10/31/17
10/31/16 10/31/17 YTD % of 2017 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 10,854,412$ 10,342,460$ 10,922,715$ 95%13,048,000$ (511,952)$
Other Intergovernmental Tax 1,110,625 1,201,140 1,142,140 105%1,265,235 90,515
Telecommunications/Utility Tax 5,003,772 5,004,413 4,787,390 105%5,638,000 641
Licenses and Permits 1,639,733 2,010,691 1,585,475 127%1,711,750 370,958
Charges for Services 836,115 797,538 807,250 99%1,006,750 (38,577)
Fines and Penalties 133,677 117,909 127,900 92%153,590 (15,768)
Administrative Towing Fees 26,940 34,875 41,650 84%50,000 7,935
Interest on Investments 121,734 187,223 104,150 180%125,000 65,489
Franchise/IMF Maint. Fee 173,509 113,712 155,400 73%207,200 (59,797)
Reimbursements From Other Funds 523,350 514,420 514,400 100%617,300 (8,930)
Miscellaneous Income 168,122 160,498 190,250 84%231,675 (7,624)
Total Operating Revenues 20,591,989$ 20,484,879$ 20,378,720$ 101%24,054,500$ (107,110)$
OPERATING EXPENDITURES
Personnel 13,427,927$ 13,497,508$ 15,009,060$ 90%17,788,210$ 69,581$
Materials and Supplies 329,220 346,488 476,305 73%554,530 17,268
Operation and Contract 3,112,020 3,439,564 3,770,150 91%4,344,325 327,544
Other Expenditures 402,588 396,720 396,700 100%418,100 (5,868)
Capital Outlay 354,184 1,101,034 1,098,260 100%805,310 746,850
Total Operating Expenditures 17,625,939$ 18,781,314$ 20,750,475$ 91%23,910,475$ 1,155,375$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 2,966,050$ 1,703,565$ (371,755)$ 144,025$ (1,262,485)$
INTERFUND TRANSACTIONS
Transfers Out -$ -$ -$ 0%(73,505)$ -$
Interfund Loan - - - 0%- -
Total Interfund Transactions -$ -$ -$ 0%(73,505)$ -$
NET FUND INCREASE (DECREASE)2,966,050$ 1,703,565$ (371,755)$ 70,520$ (1,262,485)$
Village of Oak Brook
General Fund Financial Update
For the Period Ending October 31, 2017
Total Total
Revenues Expenditures
10/31/17 Actual $ 20,484,879 18,781,314$
10/31/16 Actual $ 20,591,989 17,625,939$
% Change From Last Year -0.5%6.6%
Major Revenues Other
Intergov.Licenses &Charges for
Sales Tax Tax Telecom Tax Permits Services
10/31/17 Actual $ 10,342,460 $ 1,201,140 $ 5,004,413 $ 2,010,691 797,538
10/31/16 Actual $ 10,854,412 $ 1,110,625 $ 5,003,772 $ 1,639,733 836,115
% Change From Last Year -4.7%8.1%0.0%22.6%-4.6%
Five Year Trend
Major Expenditures Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
10/31/17 Actual 13,497,508$ 346,488$ 3,439,564$ 396,720 1,101,034$
10/31/16 Actual 13,427,927$ 329,220$ 3,112,020$ 402,588 354,184$
% Change From Last Year 0.5%5.2%10.5%-1.5%210.9%
Five Year Trend
Expenditures by Department
10/31/16 10/31/17 10/31/17 10/31/17 2017 Difference Five
YTD YTD YTD % of Annual Prior Year
Department Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 1,893,329$ 2,188,655$ 2,482,205$ 88.2%2,883,255$ 295,326$
Financial Services 1,050,468 967,028 991,405 97.5%1,116,445 (83,440)
Public Works 486,462 560,706 610,095 91.9%752,340 74,244
Engineering & Capital Projects 227,816 776,915 665,980 116.7%372,500 549,099
Library 807,022 750,321 848,825 88.4%989,470 (56,701)
Police 6,752,963 6,847,761 7,347,635 93.2%8,609,255 94,798
Fire 5,624,643 5,886,433 6,982,595 84.3%8,205,100 261,790
Development Services 783,236 803,495 821,735 97.8%982,110 20,259
Total Expenditures 17,625,939$ 18,781,314$ 20,750,475$ 90.5%23,910,475$ 1,155,375$
Explanation of Major Changes From Last Year:
Sales Tax revenue is down $511,952 compared to revenue through October 2016. This is due to non-routine receipts received from a top taxpayer in 2016. Total Sales Tax
revenue through October 2017 is $580,255 under budget due to the timing of receipts from new businesses and slowed retail growth.
Other Intergovernmental Tax revenue is up $90,515 compared to revenue through October 2016. This is due to increases in State Income Tax due to an acceleration in
payments from the State and general increases in Replacement Tax revenue. Total Intergovernmental Tax revenue through October 2017 is $59,000 over budget.
Licenses & Permits revenue is up $370,958 compared to collections through October 2016. This is primarily due to increases in building permits and accessory structure
permits. Total Licenses & Permits revenue through October 2017 is over budget by $425,216.
Personnel expenditures are up $69,581 comapred to payments through October 2016. This is primarily due to general increases in wages, insurance, and pension
payments. Total Personnel expenditures through October 2017 are $1,511,552 under budget due to public safety pensions being funded lower than budgeted.
Operation & Contractual expenditures are up $327,544 compared to payments through October 2016. This is due to increased litigation services and increases in liability
insurance premiums and claims. Total Operation & Contractual expenditures through October 2017 are $330,586 under budget due to general timing of payments.
Capital Outlay expenditures are up $746,850 compared to payments through October 2016. This is due to major projects performed early in 2017 such as the BGC restroom
renovation project, fire department humidifier installation, and BGC electrical upgrade. Total Capital Outlay expenditures through October 2017 are $2,774 over budget.
Five Year Trend
For the Period Ending October 31, 2017
General Fund - Five Year Trend
Village of Oak Brook
Revenues Expenditures
10/31/17 10/31/17
10/31/16 10/31/17 YTD % of 2017 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Hotel Tax 1,043,967$ 1,032,697$ 907,045$ 114%1,266,000$ (11,270)$
Interest 27,483 40,387 18,300 221%22,000 12,904
Miscellaneous - 44,095 - N/A - 44,095
Total Operating Revenues 1,071,450$ 1,117,179$ 925,345$ 120.7%1,288,000$ 45,729$
EXPENDITURES
Operation and Contract 293,686$ 372,913$ 496,600$ 75%595,975$ 79,227$
Other Expenditures 75,250 77,830 77,800 100%93,400 2,580
Capital Outlay 64,526 877,917 1,837,500 48%1,837,500 813,391
Total Expenditures 433,462$ 1,328,660$ 2,411,900$ 55.1%2,526,875$ 895,198$
NET FUND INCREASE (DECREASE)637,988$ (211,481)$ (1,486,555)$ (1,238,875)$ (849,469)$
Note - Expenditures are recorded in program 171.
Village of Oak Brook
Hotel Tax Fund Financial Update
For the Period Ending October 31, 2017
Total Total
Revenues Expenditures
10/31/17 Actual $ 1,117,179 1,328,660$
10/31/16 Actual $ 1,071,450 433,462$
% Change From Last Year 4.3%206.5%
Major Revenues
Grants Hotel Tax Interest Miscellaneous
10/31/17 Actual $ - $ 1,032,697 $ 40,387 $ 44,095
10/31/16 Actual $ - $ 1,043,967 $ 27,483 $ -
% Change From Last Year 0.0%-1.1%47.0%N/A
Five Year Trend
Major Expenditures Operation &Other
Contractual Expenditures Capital Outlay
10/31/17 Actual 372,913$ 77,830$ 877,917$
10/31/16 Actual 293,686$ 75,250$ 64,526$
% Change From Last Year 27.0%3.4%1260.6%
Five Year Trend
Explanation of Major Changes From Last Year:
Hotel Tax revenue is down $11,270 compared to collections through October 2016. This is related to the timing of
receipts. Total Hotel Tax revenue through October 2017 is over budget by $125,652 because of general increases in
receipts and the timing of when receipts have been received.
Operation & Contractual expenditures are up $79,227 compared to payments through October 2016. This is related to
engineering costs for a 22nd Street beautification project. Total Operation & Contractual expenditures through
October 2017 are under budget by $123,687 due to the timing of DCVB quarterly dues and advertising payments.
Capital Outlay expenditures are up $813,391 compared to payments through October 2016. This is related to 22nd St.
construction costs that were delayed from 2016. Total Capital Outlay expenditures through October 2017 are
under budget by $959,583 due to the timing of payments.
Village of Oak Brook
Hotel Tax Fund - Major Sources Five Year Trend
For the Period Ending October 31, 2017
Five Year Trend
Revenues Expenditures
10/31/17 10/31/17
10/31/16 10/31/17 YTD % of 2017 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 5,016,705$ 4,752,219$ 5,026,170$ 95%5,982,000$ (264,486)$
Grants - 3,142 - N/A - 3,142
Interest 34,693 62,480 22,900 273%27,500 27,787
Miscellaneous (1,645) 5,745 4,150 138%5,000 7,390
Reimbursements From Other Funds 150,030 147,200 147,200 100%176,635 (2,830)
Total Operating Revenues 5,199,783$ 4,970,786$ 5,200,420$ 96%6,191,135$ (228,997)$
OPERATING EXPENDITURES
Personnel 1,254,026$ 968,626$ 1,075,345$ 90%1,474,390$ (285,400)$
Materials and Supplies 89,560 80,702 290,200 28%351,095 (8,858)
Operation and Contract 1,136,152 1,204,635 1,134,855 106%1,132,435 68,483
Other Expenditures 129,170 135,420 135,400 100%162,500 6,250
Capital Outlay 1,463,290 396,293 1,323,750 30%1,755,000 (1,066,997)
-
Total Operating Expenditures 4,072,198$ 2,785,676$ 3,959,550$ 70%4,875,420$ (1,286,522)$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 1,127,585$ 2,185,110$ 1,240,870$ 176%1,315,715$ 1,057,525$
INTERFUND TRANSACTIONS
Transfers In -$ 389,604$ 561,765$ 69%561,765$ 389,604$
Total Interfund Transactions -$ 389,604$ 561,765$ 69%561,765$ 389,604$
NET FUND INCREASE (DECREASE)1,127,585$ 2,574,714$ 1,802,635$ 1,877,480$ 1,447,129$
Village of Oak Brook
Infrastructure Fund Financial Update
For the Period Ending October 31, 2017
Total Total
Revenues Expenditures
10/31/17 Actual $ 4,970,786 2,785,676$
10/31/16 Actual $ 5,199,783 4,072,198$
% Change From Last Year -4.4%-31.6%
Major Revenues
Sales Tax Grants Interest Miscellaneous Reimbursements
10/31/17 Actual $ 4,752,219 $ 3,142 $ 62,480 $ 5,745 $ 147,200
10/31/16 Actual $ 5,016,705 $ - $ 34,693 $ (1,645) $ 150,030
% Change From Last Year -5.3%N/A 80.1%-449.2%-1.9%
Five Year Trend
Major Expenditures Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
10/31/17 Actual 968,626$ 80,702$ 1,204,635$ 135,420$ 396,293$
10/31/16 Actual 1,254,026$ 89,560$ 1,136,152$ 129,170$ 1,463,290$
% Change From Last Year -22.8%-9.9%6.0%4.8%-72.9%
Five Year Trend
Expenditures by Department
10/31/16 10/31/17 10/31/17 10/31/17 2017 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 115,970$ 141,895$ 147,655$ 96.1%174,430$ 25,925$
Public Works 1,735,860 1,918,930 2,270,765 84.5%2,697,845 183,070
Engineering & Capital Projects 2,220,368 724,851 1,541,130 47.0%2,003,145 (1,495,517)
Total Expenditures 4,072,198$ 2,785,676$ 3,959,550$ 70.4%4,875,420$ (1,286,522)$
Explanation of Major Changes From Last Year:
Sales Tax revenue is down $264,486 compared to revenue through October 2016. This is due to non-routine receipts received from a top taxpayer in 2016. Total
Sales Tax revenue through October 2017 is $273,951 under budget due to the timing of receipts from new businesses and slowed retail growth.
Personnel expenditures are down $285,400 compared to payments through October 2016. This is primarily due to a decrease in hours needed for snow removal
overtime and a reduction in headcount related to the outsourcing of the Village engineering function. Total Personnel costs through October 2017 are $106,719
under budget due to less time spent on snow removal.
Operation & Contractual expenditures are up $68,483 compared to payments through October 2016. This is due to payments for outsourced engineering services
that started in 2017. Total Operation & Contractual expenditures through October 2017 are $69,780 over budget due to the timing of general maintenance
payments.
Capital Outlay expenditures are down $1,066,997 compared to payments through October 2016. This is due to the timing of payments. Total Capital Outlay
expenditures through October 2017 are $927,457 under budget due to the timing of capital projects.
Five Year Trend
Village of Oak Brook
Infrastructure Fund - Major Sources Five Year Trend
For the Period Ending October 31, 2017
Revenues Expenditures
10/31/17 10/31/17
10/31/16 10/31/17 YTD % of 2017 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 69,262$ 65,941$ 67,000$ 98%100,500$ (3,321)$
Real Estate Tax 354,829 385,018 355,000 108%355,000 30,189
Interest 220 467 70 667%100 247
Total Operating Revenues 424,311$ 451,426$ 422,070$ 107%455,600$ 27,115$
EXPENDITURES
Operation and Contract 3,938$ 3,958$ 4,070$ 97%4,070$ 20$
Other Expenditures 435,220 454,380 454,380 100%454,380 19,160
Total Expenditures 439,158$ 458,338$ 458,450$ 100%458,450$ 19,180$
NET FUND INCREASE (DECREASE)(14,847)$ (6,912)$ (36,380)$ (2,850)$ 7,935$
Note - Expenditures are recorded in program 283.
Village of Oak Brook
Promenade TIF Fund Financial Update
For the Period Ending October 31, 2017
Total Total
Revenues Expenditures
10/31/17 Actual $ 451,426 458,338$
10/31/16 Actual $ 424,311 439,158$
% Change From Last Year 6.4%4.4%
Major Revenues Real Estate
Sales Tax Tax Interest
10/31/17 Actual $ 65,941 $ 385,018 $ 467
10/31/16 Actual $ 69,262 $ 354,829 $ 220
% Change From Last Year -4.8%8.5%112.3%
Five Year Trend
Major Expenditures Operation &Other
Contractual Expenditures
10/31/17 Actual 3,958$ 454,380$
10/31/16 Actual 3,938$ 435,220$
% Change From Last Year 0.5%4.4%
Five Year Trend
Explanation of Major Changes From Last Year:
Real Estate Tax revenue is up $30,189 compared to revenue through October 2016. This is due to general property value
increases within the TIF. Total Real Estate Tax revenue through October 2017 is $30,018 over budget due to the property
valuation being higher than anticipated.
Other Expenditures are up $19,160 compared to payments through October 2016. This is due to an increase in TIF note
payable principal payments to the bondholders. This is in line with the 2017 budget projection through October.
Village of Oak Brook
Promenade TIF Fund - Major Sources Five Year Trend
For the Period Ending October 31, 2017
Five Year Trend
Revenues Expenditures
10/31/17 10/31/17
10/31/16 10/31/17 YTD % of 2017 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Grants -$ 3,386$ -$ N/A -$ 3,386$
Plan Review Fees 1,359 1,714 1,650 104%2,000 355
Building/Inspection Fees 5,538 11,389 3,750 304%4,500 5,851
Water Sales 7,110,339 7,769,274 7,684,145 101%9,143,000 658,935
Unmetered Sales 26,154 37,498 20,800 180%25,000 11,344
Water Connection Fees 61,323 163,070 25,000 652%30,000 101,747
Fire Service Charge 9,486 - 8,350 0%10,000 (9,486)
Meter Charges 20,321 19,908 20,850 95%25,000 (413)
Special Services 15,620 15,286 15,500 99%31,000 (334)
Interest on Investments 10,338 31,409 8,350 376%10,000 21,071
Miscellaneous 67,232 70,098 54,150 129%65,000 2,866
Total Operating Revenues 7,327,710$ 8,123,032$ 7,842,545$ 104%9,345,500$ 795,322$
EXPENDITURES
Personnel 699,942$ 658,520$ 705,420$ 93%835,110$ (41,422)$
Materials and Supplies 54,146 51,231 59,850 86%70,660 (2,915)
Operation and Contract 5,077,688 4,373,538 5,456,130 80%6,547,735 (704,150)
Other Expenditures 353,100 334,670 334,650 100%401,600 (18,430)
Capital Outlay 63,422 58,621 2,658,650 2%3,235,010 (4,801)
Total Expenditures 6,248,298$ 5,476,580$ 9,214,700$ 59%11,090,115$ (771,718)$
NET FUND INCREASE (DECREASE)1,079,412$ 2,646,452$ (1,372,155)$ (1,744,615)$ 1,567,040$
Village of Oak Brook
Water Fund Financial Update
For the Period Ending October 31, 2017
Total Total
Revenues Expenditures
10/31/17 Actual $ 8,123,032 5,476,580$
10/31/16 Actual $ 7,327,710 6,248,298$
% Change From Last Year 10.9%-12.4%
Unmetered Water
Water Sales Sales Connection Fees Meter Charges Miscellaneous
10/31/17 Actual $ 7,769,274 $ 37,498 $ 163,070 $ 19,908 $ 70,098
10/31/16 Actual $ 7,110,339 $ 26,154 $ 61,323 $ 20,321 $ 67,232
% Change From Last Year 9.3%43.4%165.9%-2.0%4.3%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
10/31/17 Actual 658,520$ 51,231$ 4,373,538$ 334,670$ 58,621$
10/31/16 Actual 699,942$ 54,146$ 5,077,688$ 353,100$ 63,422$
% Change From Last Year -5.9%-5.4%-13.9%-5.2%-7.6%
Five Year Trend
Expenditures by Department
10/31/16 10/31/17 10/31/17 10/31/17 2017 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Public Works 6,248,298$ 5,404,891$ 6,631,670$ 81.5%7,912,070$ (843,407)$
Engineering & Capital Projects - 71,688 2,583,030 0.0%3,178,045 71,688
Total Expenditures 6,248,298$ 5,476,579$ 9,214,700$ 59.4%11,090,115$ (771,719)$
Explanation of Major Changes From Last Year:
Water Sales revenue is up $658,935 compared to collections through October 2016. This is due to a 10% rate increase adopted January 1, 2017. Total Water Sales
revenue through October 2017 is over budget by $85,129 due to gallons billed being slightly higher than projected.
Water Connection Fees revenue is up $101,747 compared to collections through October 2016. This is due to construction of the Rush Midwest Orthopedics building.
Total Water Connection Fees revenue through October 2017 is over budget by $138,070 due to new development within the Village.
Operation & Contractual expenditures are down $704,150 compared to payments through October 2016. This is due to the timing of DuPage Water
Commission invoices being paid and the DuPage Water Commission rate increase being less than anticipated. Operation & Contractual expenditures through
October 2017 are under budget by $1,082,592 due to the timing of bills being paid to the timing of invoices being paid.
Capital Outlay expenditures are down $4,801 compared to payments through October 2016. This is due to general timing of payments. Capital Outlay expenditures
through October 2017 are under budget by $2,600,029 due to the meter replacement project happening later than originally planned.
Five Year Trend
Village of Oak Brook
Water Fund - Major Sources Five Year Trend
For the Period Ending October 31, 2017
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Sports Core Fund Consolidated Presentation
For the Period Ending October 31, 2017
10/31/17 10/31/17
10/31/17 YTD % of 2017 10/31/16 Difference
B&T Recreation Food &Golf YTD Amended Amended Adopted YTD Prior
Programs Beverage Club Total Budget Budget Budget Total Year
DIRECT REVENUES
Memberships 222,790$ 2,400$ 189,963$ 415,153$ 456,080$ 91%443,580$ 404,518$ 10,635$
Greens Fees - - 925,411 925,411 867,320 107%840,000 867,664 57,747
Pro Shop Sales - - 171,540 171,540 193,000 89%190,000 178,305 (6,765)
Golf Lessons - - 43,359 43,359 30,250 143%30,250 40,053 3,306
Driving Range Fees - - 235,274 235,274 225,000 105%225,000 223,403 11,871
Rentals - - 356,005 356,005 360,095 99%327,850 349,595 6,410
Programs/User Fees 361,330 - - 361,330 325,180 111%387,750 274,981 86,349
Food Sales - 175,726 - 175,726 171,755 102%163,850 170,393 5,333
Beverage Sales - 263,947 - 263,947 238,520 111%199,300 235,610 28,337
Other Revenue 193,403 179,157 19,768 392,328 342,800 114%351,900 347,928 44,400
Total Direct Revenues 777,523$ 621,230$ 1,941,320$ 3,340,073$ 3,210,000$ 104%3,159,480$ 3,092,450$ 247,623$
DIRECT EXPENDITURES
Personnel 192,158$ 200,851$ 938,032$ 1,331,041$ 1,354,245$ 98%1,609,185$ 1,326,370$ 4,671$
Materials & Supplies 35,562 199,448 306,465 541,475 652,140 83%700,870 523,179 18,296
Operational & Contractual 611,260 99,312 255,972 966,544 971,490 99%1,047,630 973,585 (7,041)
Other - - (186,200) (186,200) (206,200) 90%(206,200) (200,035) 13,835
Capital 51,521 94,750 70,017 216,288 261,500 83%226,000 120,990 95,298
Total Direct Expenditures 890,501$ 594,361$ 1,384,286$ 2,869,148$ 3,033,175$ 95%3,377,485$ 2,744,089$ 125,059$
Direct Revenues Over (Under) Expenditures (112,978)$ 26,869$ 557,034$ 470,925$ 176,825$ 266%(218,005)$ 348,361$ 122,564$
B&T Administration Overhead Allocation*153,922$ (153,922)$ -$ -$ -$ 0%-$ -$ -$
Operating Revenues Over (Under) Expenditures 40,944$ (127,053)$ 557,034$ 470,925$ 176,825$ 266%(218,005)$ 348,361$ 122,564$
Interfund Loan**-$ -$ -$ -$ -$ 0%-$ -$ -$
Transfer From General Fund - - - - 61,250 0%73,505 - -
Transfer From Infrastructure Fund 20,000 - - 20,000 20,000 100%24,000 20,000 -
Transfer From Water Fund 6,670 - - 6,670 6,650 100%8,000 6,670 -
Adjusted Operating Revenues Over (Under) Expenditures 67,614$ (127,053)$ 557,034$ 497,595$ 264,725$ (112,500)$ 375,031$ 122,564$
*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.
Total Direct Total Direct
Revenues Expenditures
10/31/17 Actual $ 3,340,073 2,869,148$
10/31/16 Actual $ 3,092,450 2,744,089$
% Change From Last Year 8.0%4.6%
Driving Program/
Memberships Greens Fees Range Fees Rentals User Fees
10/31/17 Actual $ 415,153 $ 925,411 $ 235,274 $ 356,005 $ 361,330
10/31/16 Actual $ 404,518 $ 867,664 $ 223,403 $ 349,595 $ 274,981
% Change From Last Year 2.6%6.7%5.3%1.8%31.4%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
10/31/17 Actual 1,331,041$ 541,475$ 966,544$ (186,200)$ 216,288$
10/31/16 Actual 1,326,370$ 523,179$ 973,585$ (200,035)$ 120,990$
% Change From Last Year 0.4%3.5%-0.7%0.0%78.8%
Five Year Trend
Revenues by Department 10/31/16 10/31/17 10/31/17 10/31/17 2017 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Programs 690,875$ 777,523$ 646,495$ 120.3%842,830$ 86,648$
Food & Beverage 556,277 621,230 127,800 486.1%532,350 62,553
Golf Club 1,845,298 1,941,320 567,997 341.8%1,784,300 96,022
Total Revenues 3,092,450$ 3,340,073$ 1,342,292$ 248.8%3,159,480$ 245,223$
Expenditures by Department 10/31/16 10/31/17 10/31/17 % of 2017 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Programs 900,175$ 890,501$ 344,363$ 258.6%992,140$ (9,674)$
Food & Beverage 525,387 594,361 281,968 210.8%633,545 68,974
Golf Club 1,318,527 1,384,286 778,751 177.8%1,751,800 65,759
Total Expenditures 2,744,089$ 2,869,148$ 1,405,082$ 204.2%3,377,485$ 125,059$
Explanation of Major Changes From Last Year:
Memberships revenue is up $10,635 compared to collections through October 2016. This is due to an increase in Golf Club memberships compared to last
year. Total Memberships revenue through October 2017 is $40,927 under budget due to Bath & Tennis Club memberships being lower than projected.
Greens Fees revenue is up $57,747 compared to collections through October 2016. This is due to the weather allowing the golf course to open early in 2017.
Total Greens Fees revenue through October 2017 is $58,091 over budget due to the course opening early during the 2017 season.
Program/User Fees revenue is up $86,349 compared to collections through October 2016. This is due to the timing of field rental receipts being collected vs.
last year. Total Program/User Fees revenue through October 2017 is $36,150 over budget due to field rental receipts being received earlier than anticipated.
Capital Outlay expenditures are up $95,298 compared to payments through October 2016. This is due to the renovation project at the B&T Clubhouse in 2017.
Total Capital Outlay expenditures through October 2017 are $45,212 over budget due to the timing of the B&T renovation project.
Five Year Trend
Village of Oak Brook
Sports Core Fund - Major Sources Five Year Trend
For the Period Ending October 31, 2017
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Bath & Tennis Club Recreation Programs
For the Period Ending October 31, 2017 10/31/17 10/31/17
10/31/17 YTD % of 2017 10/31/16 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 -$ 211,240$ 11,550$ -$ -$ 222,790$ 273,080$ 82%273,080$ 224,531$ (1,741)$
Programs/User Fees (4,207) 88,738 16,784 - 260,015 361,330 325,180 111%387,750 274,981 86,349
Beverage Sales - - - - - - 300 0%300 - -
Other Revenue 1,833 3,070 125 - 188,375 193,403 181,600 106%181,700 191,363 2,040
Total Revenue (2,374)$ 303,048$ 28,459$ -$ 448,390$ 777,523$ 780,160$ 100%842,830$ 690,875$ 86,648$
Expenditures:
Personnel 128,495$ 36,823$ 21,799$ -$ 5,041$ 192,158$ 202,005$ 95%226,335$ 186,812$ 5,346$
Materials & Supplies 20,167 9,563 4,042 - 1,790 35,562 65,080 55%66,700 30,777 4,785
Operational & Contractual 133,176 153,991 34,321 30,000 259,772 611,260 583,155 105%638,105 637,466 (26,206)
Capital 828 30,070 - - 20,623 51,521 111,000 46%61,000 45,120 6,401
Total Expenditures 282,666$ 230,447$ 60,162$ 30,000$ 287,226$ 890,501$ 961,240$ 93%992,140$ 900,175$ (9,674)$
Direct Revenues Over (Under) Expenditures (285,040)$ 72,601$ (31,703)$ (30,000)$ 161,164$ (112,978)$ (181,080)$ 62%(149,310)$ (209,300)$ 96,322$
B&T Administration Overhead Allocation*285,040$ (102,614)$ (28,504)$ -$ -$ 153,922$ 147,425$ 104%176,890$ 64,197$ 89,725$
Revenues Over (Under) Expenditures -$ (30,013)$ (60,207)$ (30,000)$ 161,164$ 40,944$ (33,655)$ -122%27,580$ (145,103)$ 186,047$
Interfund Loan**-$ -$ -$ -$ -$ -$ -$ 0%-$ -$ -$
Transfer From General Fund - - - - - - 61,250 0%73,505 - -
Transfer From Infrastructure Fund 20,000 - - - - 20,000 20,000 100%24,000 20,000 -
Transfer From Water Fund 6,670 - - - - 6,670 6,650 100%8,000 6,670 -
Adjusted Revenues Over (Under) Expenditures 26,670$ (30,013)$ (60,207)$ (30,000)$ 161,164$ 67,614$ 54,245$ 133,085$ (118,433)$ 186,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 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 October 31, 2017
10/31/17 10/31/17
821 822 823 10/31/17 YTD % of 2017 10/31/16 Difference
B&T Poolside Golf YTD Amended Amended Adopted YTD Prior
Clubhouse Café Clubhouse Total Budget Budget Budget Total Year
Revenues:
Memberships 2,400$ -$ -$ 2,400$ 3,000$ 80%4,500$ -$ -$
Food Sales - 40,263 135,463 175,726 171,755 102%163,850 170,393 5,333
Beverage Sales - 21,005 242,942 263,947 238,220 111%199,000 235,610 28,337
Other Revenue 179,157 - - 179,157 156,000 115%165,000 150,274 28,883
Total Revenue 181,557$ 61,268$ 378,405$ 621,230$ 568,975$ 109%532,350$ 556,277$ 62,553$
Expenditures:
Personnel 76,766$ 21,554$ 102,531$ 200,851$ 203,870$ 99%226,890$ 191,772$ 9,079$
Materials & Supplies 4,167 38,641 156,640 199,448 202,060 99%210,920 190,636 8,812
Operational & Contractual 91,048 2,122 6,142 99,312 141,550 70%160,735 142,979 (43,667)
Capital 78,377 16,373 - 94,750 35,000 271%35,000 - 94,750
Total Expenditures 250,358$ 78,690$ 265,313$ 594,361$ 582,480$ 102%633,545$ 525,387$ 68,974$
Direct Revenues Over (Under) Expenditures (68,801)$ (17,422)$ 113,092$ 26,869$ (13,505)$ -199%(101,195)$ 30,890$ (4,021)$
B&T Administration Overhead Allocation*(142,520)$ (11,402)$ -$ (153,922)$ (147,425)$ 104%(176,890)$ (64,197)$ (89,725)$
Revenues Over (Under) Expenditures (211,321)$ (28,824)$ 113,092$ (127,053)$ (160,930)$ 79%(278,085)$ (33,307)$ (93,746)$
Transfer From General Fund -$ -$ -$ -$ -$ 0%-$ -$ -$
Adjusted Revenues Over (Under) Expenditures (211,321)$ (28,824)$ 113,092$ (127,053)$ (160,930)$ (278,085)$ (33,307)$ (93,746)$
*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 October 31, 2017
10/31/17 10/31/17
831 832 833 834 10/31/17 YTD % of 2017 10/31/16 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 189,963$ -$ -$ -$ 189,963$ 180,000$ 106%166,000$ 179,987$ 9,976$
Greens Fees 925,411 - - - 925,411 867,320 107%840,000 867,664 57,747
Pro Shop Sales 171,540 - - - 171,540 193,000 89%190,000 178,305 (6,765)
Golf Lessons - 43,359 - - 43,359 30,250 143%30,250 40,053 3,306
Driving Range Fees - 235,274 - - 235,274 225,000 105%225,000 223,403 11,871
Rentals 4,348 - 351,657 - 356,005 360,095 99%327,850 349,595 6,410
Other Revenue 19,768 - - - 19,768 5,200 380%5,200 6,291 13,477
Total Revenue 1,311,030$ 278,633$ 351,657$ -$ 1,941,320$ 1,860,865$ 104%1,784,300$ 1,845,298$ 96,022$
Expenditures:
Personnel 409,058$ 76,430$ 49,453$ 403,091$ 938,032$ 948,370$ 99%1,155,960$ 947,786$ (9,754)$
Materials & Supplies 122,181 11,243 4,437 168,604 306,465 385,000 80%423,250 301,766 4,699
Operational & Contractual 192,346 14,077 6,054 43,495 255,972 246,785 104%248,790 193,140 62,832
Other - - - (186,200) (186,200) (206,200) 90%(206,200) (200,035) 13,835
Capital 33,617 8,526 - 27,874 70,017 115,500 61%130,000 75,870 (5,853)
Total Expenditures 757,202$ 110,276$ 59,944$ 456,864$ 1,384,286$ 1,489,455$ 93%1,751,800$ 1,318,527$ 65,759$
Direct Revenues Over (Under) Expenditures 553,828$ 168,357$ 291,713$ (456,864)$ 557,034$ 371,410$ 150%32,500$ 526,771$ 30,263$
Transfer from General Fund -$ -$ -$ -$ -$ -$ 0%-$ -$ -$
Adjusted Revenues Over (Under) Expenditures 553,828$ 168,357$ 291,713$ (456,864)$ 557,034$ 371,410$ 32,500$ 526,771$ 30,263$