02 - February 2018 Monthly Financial ReportVILLAGE
OAK BROOK
OF
MONTHLY FINANCIAL REPORTS
FEBRUARY 2018
Agenda Item 6.F
Total
Cash and Cash Pooled Cash and
Fund Equivalents Investments Investments % By Fund
General Corporate $6,250,810 $12,289,655 $18,540,465 45.8%
Hotel/Motel Tax 1,428,408 2,704,600 4,133,008 10.2%
Motor Fuel Tax 191,506 420,386 611,892 1.5%
Infrastructure 5,278,164 3,379,327 8,657,491 21.4%
Promenade TIF 53,153 ‐ 53,153 0.1%
Water 3,933,819 1,488,482 5,422,301 13.4%
Sports Core 106,192 ‐ 106,192 0.3%
Golf Surcharge 6,993 553,933 560,927 1.4%
Self‐Insurance 190,598 ‐ 190,598 0.5%
Garage 432,388 ‐ 432,388 1.1%
Equipment Replacement 750,314 1,053,073 1,803,387 4.5%
Total $18,622,346 $21,889,457 $40,511,803 100.0%
Change in Cash and Investments by Fund :
Balance at Balance at Year‐to‐Date Year‐to‐Date
Fund January 1, 2018 February 28, 2018 Change ($) Change (%)
General Corporate $17,679,496 $18,540,465 $860,969 4.9%
Hotel/Motel Tax 4,172,234 4,133,008 (39,225)‐0.9%
Motor Fuel Tax 574,460 611,892 37,432 6.5%
Infrastructure 8,222,145 8,657,491 435,346 5.3%
Promenade TIF 276,164 53,153 (223,011)‐80.8%
Water 5,693,109 5,422,301 (270,809)‐4.8%
Sports Core 472,473 106,192 (366,281)‐77.5%
Golf Surcharge 559,073 560,927 1,853 0.3%
Self‐Insurance 45,042 190,598 145,556 323.2%
Garage 427,409 432,388 4,979 1.2%
Equipment Replacement 1,805,752 1,803,387 (2,364)‐0.1%
$39,927,358 $40,511,803 $584,445 1.5%
Book Market
Value Value
Pooled Checking $1,145,126 $1,145,126
Sports Core Checking 112,025 112,025
Pooled IPTIP 17,291,598 17,291,598
Water E‐Pay IPTIP 73,598 73,598
$18,622,346 $18,622,346
Pooled Investments:
Investments‐Municipal $9,246,106 $9,140,720
Investments‐Corporate 4,721,459 4,711,755
Government & Agency Obligations 858,097 827,909
Certificates of Deposit 6,965,000 6,912,091
Accrued Interest 98,795 98,795
Total Pooled Investments $21,889,457 $21,691,270
Total Cash and Investments $40,511,803 $40,313,616
For February, total interest revenue is $51,507 and YTD interest revenue is $101,352.
Total investment yield for the portfolio is:
Pooled
Investments Illinois Funds Total
Monthly yield 0.15% 0.12% 0.14%
YTD yield 0.29% 0.25% 0.27%
Last 12 months yield 1.54% 1.06% 1.33%
The weighted average yield of the current pooled investment portfolio is 1.79%.
Monthly Treasurer's Report
February 28, 2018
Monthly Treasurer's Report
February 2018
The table below lists the detail investment holdings at J.P. Morgan Securities as of 2/28/18:
Month End VOB
Settlement Maturity Coupon Yield Book Market Accrued
Type Date Date Rate Rate Value Value Interest
Municipal Bonds:
Florida Hurricane #34074GDG6 01/05/15 7/1/2018 2.107% 2.090% $750,759 $750,023 $2,620
Maryland St Econ Dev #57420PGK6 07/08/15 6/1/2019 2.050% 2.123% 99,909 99,649 511
Rosemont IL GO Corp #777543UT4 02/08/16 12/1/2019 3.021% 2.000% 508,714 500,675 3,680
New York St Urban Dev Corp #650035J58 02/22/16 3/15/2018 1.650% 1.150% 175,031 174,986 1,323
New York N Y City #64971QTX1 02/22/16 5/1/2021 2.350% 2.000% 202,130 198,290 1,552
Florida Hurricane #34074GDH4 03/30/16 7/1/2020 2.995% 2.150% 509,517 504,595 2,495
Bloomingdale Mich Pub Sch Dist #094383FS0 04/26/16 5/1/2022 2.710% 2.150% 511,087 492,130 4,478
Milan Mich Area Achs #598801JD1 05/26/16 5/1/2020 1.931% 1.931% 245,000 242,038 1,476
Indiana Bd Bk Rev Taxable #4546248F7 01/06/17 1/15/2020 2.934% 1.900% 259,809 256,446 969
North Carolina Eastn Mun PWR #65819WAC7 01/30/17 7/1/2018 2.003% 1.450% 701,262 700,084 2,336
Garland Cnty Ark Sales & Use #36609PAN3 02/06/17 11/1/2019 1.795% 1.840% 499,629 492,715 3,116
Anchor Bay Mich Sch Dist GO #032879TA6 02/13/17 5/1/2019 1.810% 1.420% 366,649 362,795 2,125
Macomb Cnty Mich Retirees #554885H63 04/11/17 11/1/2018 1.731% 1.300% 401,145 398,772 2,265
Lanse Creuse Mich Pub Schs #516228RL9 05/02/17 5/1/2020 2.159% 2.159% 100,000 99,247 717
California St GO Bonds #13063A7G3 05/08/17 10/1/2019 6.200% 1.600% 535,950 528,875 12,635
*Genesee Cnty Mich #371608UV0 05/31/17 10/1/2019 2.174% 2.174% 538,000 538,010 1,050
Connecticut St GO Bds 2016 #20772J3F7 06/15/17 8/15/2021 1.750% 2.300% 490,900 479,135 336
North Carolina Eastn Mun Pwr #65819WAL7 10/02/17 7/1/2019 2.578% 1.700% 505,794 501,260 2,005
Fowlerville Mich Comnty Schs #351280MS8 10/03/17 5/1/2020 2.045% 1.750% 503,137 495,880 3,238
Racine Cnty WI #38379UEM4 12/20/17 12/1/2020 2.150% 2.150% 750,000 738,705 3,180
Wisconsin St Gen Fd Annual #977100CW4 01/05/18 5/1/2020 1.446% 2.100% 591,684 586,410 2,796
Total Municipal Bonds $9,246,106 $9,140,720 $54,904
Corporate Bonds:
Morgan Stanley #6174467U7 08/28/17 4/25/2018 2.125% 1.531% 1,391,435 1,389,931 9,601
Goldman Sachs #38147MAA3 01/25/18 7/19/2018 2.900% 1.752% 848,712 846,597 2,791
American Honda Finance Corp #02665WAC5 01/25/18 10/10/2018 2.125% 1.809% 1,001,897 998,140 8,264
JP Morgan Securities #44640QKV2 02/01/18 10/29/2018 2.082% 2.082% 1,479,415 1,477,087 0
Total Corporate Bonds $4,721,459 $4,711,755 $20,656
Government & Agency Obligations:
**Government National Mtg Assn #38379UEM4 02/29/16 2/16/2051 2.300% 2.245% $858,097 $827,909 $2,152
Total Government & Agency Obligations: $858,097 $827,909 $2,152
Certificates of Deposit:
Capital One Natl Assn VA #14042E5Z9 08/26/15 8/27/2018 1.75% 1.75% $245,000 $245,066 $474
Ally Bk Midvale Utah #02006LVC4 10/29/15 10/29/2018 1.60% 1.60% 245,000 244,951 1,307
Wex Bank Midvale Utah #92937CDY1 07/29/16 7/30/2018 1.00% 1.00% 245,000 244,437 208
Bank Hope Los Angeles #062683AB3 08/26/16 8/27/2018 1.00% 1.00% 245,000 244,143 17
Wells Fargo Bank Natl Assn #949763AL0 08/31/16 8/31/2018 1.10% 1.10% 245,000 244,130 18
BMW Bank #05580AFG4 09/23/16 9/24/2018 1.10% 1.10% 245,000 243,971 1,175
Comenity Cap Bank #20033ASB3 09/26/16 9/26/2018 1.10% 1.10% 245,000 243,954 23
Enerbank #29266N4E4 10/21/16 10/22/2018 1.10% 1.10% 245,000 244,040 973
Discover Bank #254672L71 10/26/16 10/26/2018 1.20% 1.20% 245,000 243,746 1,021
State Bk India NY #8562846A7 01/26/17 1/26/2022 2.25% 2.25% 245,000 241,925 536
Marlin Business Bk #57116ANU8 05/10/17 11/12/2019 1.60% 1.60% 245,000 242,337 205
American Express Fed Svgs #02587CER7 05/10/17 11/12/2019 1.70% 1.70% 245,000 242,322 1,267
Synchrony Bank #87164WRA8 05/26/17 5/28/2019 1.65% 1.65% 245,000 243,809 1,028
Umpqua Bank #90421MAG8 05/31/17 5/31/2019 1.60% 1.60% 245,000 243,638 986
Stone Bk Mtn View Ark #86158RAJ8 06/28/17 6/28/2019 1.60% 1.60% 245,000 243,447 4
Investors Savings Bk #46176PGU3 06/30/17 4/2/2018 1.35% 1.35% 245,000 245,007 2,205
TIAA FSB Jacksonville #87270LAA1 07/19/17 7/19/2019 1.60% 1.60% 245,000 243,292 441
Peoples United Bank #71270QQZ2 07/19/17 7/19/2019 1.65% 1.65% 245,000 243,461 455
Priority Bank Ozark Ark #74269KBR6 07/26/17 7/26/2019 1.60% 1.60% 245,000 243,241 32
American Express Centurion #02587DV96 08/15/17 8/17/2020 1.90% 1.90% 245,000 241,041 175
Sallie Mae #795450C86 08/16/17 8/17/2020 1.90% 1.90% 245,000 241,908 175
Merrick Bank South Jordan #59013JZS1 08/21/17 8/21/2020 1.80% 1.80% 245,000 241,296 104
Pinnacle Bank #72345SFS5 08/30/17 8/31/2020 1.80% 1.80% 115,000 113,236 9
Jackson County Bank #466682AP6 08/31/17 3/1/2021 1.85% 1.85% 245,000 240,548 2,266
Barclays Bank #06740KKX4 09/27/17 9/28/2020 1.95% 1.95% 245,000 242,018 2,030
Capital One Bank #1404205E6 10/04/17 10/4/2019 1.70% 1.70% 245,000 243,069 1,689
Transportation Alliance #89388CCB2 10/13/17 4/12/2019 1.60% 1.60% 235,000 233,987 164
Goldman Sachs Bank #38148PRK5 10/18/17 10/19/2020 1.95% 1.95% 245,000 241,915 1,752
FirstBank PR Santurce #33767A6M8 11/03/17 11/3/2020 2.00% 2.00% 245,000 242,156 344
Total Certificates of Deposits $6,965,000 $6,912,091 $21,082
Total J.P.Morgan Securities $21,790,662 $21,592,475 $98,795
*Interest rate is a floating rate that sets each month. Rate is determined at the one‐month LIBOR rate plus 0.60%
**This is a mortgage backed security that receives principal payments each month based on mortgage repayments. Monthly
principal payments will vary and the investment balance may be repaid before the 2/16/2051 maturity date.
VILLAGE OF OAK BROOK
Monthly Treasurer's Report
February 28, 2018
Cash & Investments by Fund ‐ Total $40.5 million
Cash & Investments by Type ‐ Total $40.5 million
General Corporate
45.77%
Hotel/Motel Tax
10.20%Motor Fuel Tax
1.51%
Infrastructure
21.37%
Promenade TIF
0.13%
Water
13.38%
Sports Core
0.26%
Golf Surcharge
1.38%
Self‐Insurance
0.47%Garage
1.07%
Equipment
Replacement
4.45%
Checking, $1.2
Illinois Funds, $17.4
Certificates of Deposit,
$6.9
Municipal Bonds, $9.3
Corporate Bonds, $4.7
Government & Agency
Obligations, $0.9
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)$4,323,462 $3,408,016 $915,446 ($12,065)
Main operating fund of the Village.
Hotel Fund (Major Fund)$170,399 $18,056 $152,343 $49,120
Collects and spends resources from the
3% hotel/motel tax.
Motor Fuel Tax Fund $37,118 $0 $37,118 $35,030
Collects and spends resources from the
State motor fuel tax.
Infrastructure Fund (Major Fund)$944,672 $467,434 $477,238 $399,525
Accounts for construction and maintenance of
roadways, drainage, and safety path systems.
Promenade TIF Fund (Major Fund)$199 $223,210 ($223,011) ($223,160)
Accounts for the revenues and expenditures
restricted to the Tax Increment Financing (TIF)
district located at 22nd St. and Meyers Rd.
Enterprise Funds
Water Fund (Major Fund)$1,218,799 $709,158 $509,641 ($647,400)
Collects user fees for the distribution of water
and maintenance of infrastructure.
Sports Core Fund (Major Fund)$38,645 $464,090 ($325,445) ($217,545)
Accounts for revenues and expenses relating
to administration, programs, food and beverage
operations, and golf course.
Golf Surcharge Fund $1,853 $0 $1,853 $580
Accounts for the collection of the $3 per round
golf surcharge.
Internal Service Funds
Self Insurance Fund $512,287 $417,352 $94,935 ($21,650)
Accounts for the Village's health insurance costs
and the related contributions from the Village,
employees, retirees, and other agencies.
Garage Fund $102,790 $94,365 $8,425 ($27,195)
Accounts for the maintenance of the Village's vehicle
fleet and the related departmental reimbursements.
Equipment Replacement Fund $62,418 $259 $62,159 ($59,850)
Accounts for the replacement of the Village's vehicle
fleet and the related departmental contributions.
Further information on the Village's major funds (as indicated above) can be found on the proceeding pages.
Executive Summary on Village Funds
Through February 28, 2018
2/28/18 2/28/18
2/28/17 2/28/18 YTD % of 2018 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 2,121,157$ 1,983,632$ 2,062,000$ 96% 12,453,000$ (137,525)$
Other Intergovernmental Tax 163,896 212,290 198,350 107% 1,144,700 48,394
Telecommunications/Utility Tax 1,046,257 1,063,157 1,010,400 105% 5,792,250 16,900
Licenses and Permits 205,937 719,530 615,915 117% 1,784,070 513,593
Charges for Services 119,678 122,676 151,900 81% 1,017,100 2,998
Fines and Penalties 21,596 27,280 25,070 109% 150,500 5,684
Administrative Towing Fees 3,575 6,675 5,830 114% 35,000 3,100
Interest on Investments 30,726 47,774 32,500 147% 195,000 17,048
Franchise/IMF Maint. Fee ‐ ‐ 53,750 0% 215,000 ‐
Reimbursements From Other Funds 102,884 104,842 118,890 88% 713,360 1,958
Installment Contract Proceeds ‐ ‐ ‐ 0% 2,475,165 ‐
Miscellaneous Income 26,942 35,606 27,470 130% 180,750 8,664
Total Operating Revenues 3,842,648$ 4,323,462$ 4,302,075$ 100% 26,155,895$ 480,814$
OPERATING EXPENDITURES
Personnel 2,505,568$ 2,551,161$ 2,807,580$ 91% 17,953,350$ 45,593$
Materials and Supplies 57,265 65,420 109,725 60% 532,820 8,155
Operation and Contract 955,535 660,286 817,380 81% 4,278,675 (295,249)
Other Expenditures 21,384 21,886 21,880 100% 388,815 502
Capital Outlay 76,074 9,263 557,575 2% 2,997,840 (66,811)
Total Operating Expenditures 3,615,826$ 3,308,016$ 4,314,140$ 77% 26,151,500$ (307,810)$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 226,822$ 1,015,446$ (12,065)$ 0% 4,395$ 788,624$
INTERFUND TRANSACTIONS
Transfers Out ‐$ ‐$ ‐$ 0% ‐$ ‐$
Interfund Loan ‐ (100,000) ‐ 0% ‐ (100,000)
Total Interfund Transactions ‐$ (100,000)$ ‐$ 0% ‐$ (100,000)$
NET FUND INCREASE (DECREASE)226,822$ 915,446$ (12,065)$ 4,395$ 688,624$
Village of Oak Brook
General Fund Financial Update
For the Period Ending February 28, 2018
Total Total
Revenues Expenditures
2/28/18 Actual $ 4,323,462 3,308,016$
2/28/17 Actual $ 3,842,648 3,615,826$
% Change From Last Year 12.5% ‐8.5%
Major Revenues Other
Intergov. Licenses & Charges for
Sales Tax Tax Telecom Tax Permits Services
2/28/18 Actual $ 1,983,632 $ 212,290 $ 1,063,157 $ 719,530 122,676
2/28/17 Actual $ 2,121,157 $ 163,896 $ 1,046,257 $ 205,937 119,678
% Change From Last Year ‐6.5% 29.5% 1.6% 249.4% 2.5%
Five Year Trend
Major Expenditures Materials & Operation & Other
Personnel Supplies Contractual Expenditures Capital Outlay
2/28/18 Actual 2,551,161$ 65,420$ 660,286$ 21,886 9,263$
2/28/17 Actual 2,505,568$ 57,265$ 955,535$ 21,384 76,074$
% Change From Last Year 1.8% 14.2% ‐30.9% 2.3% 0.0%
Five Year Trend
Expenditures by Department
2/28/17 2/28/18 2/28/18 2/28/18 2018 Difference Five
YTD YTD YTD % of Annual Prior Year
Department Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 653,583$ 397,183$ 532,235$ 74.6% 2,673,305$ (256,400)$
Financial Services 130,218 134,416 137,445 97.8% 1,117,875 4,198
Public Works 70,856 71,425 115,765 61.7% 993,820 569
Engineering & Capital Projects 67,336 6,913 455,450 1.5% 2,732,665 (60,423)
Library 179,408 129,782 154,410 84.1% 889,845 (49,626)
Police 1,287,856 1,312,538 1,416,820 92.6% 8,705,350 24,682
Fire 1,084,738 1,116,243 1,349,615 82.7% 8,043,215 31,505
Development Services 141,831 139,516 152,400 91.5% 995,425 (2,315)
Total Expenditures 3,615,826$ 3,308,016$ 4,314,140$ 76.7% 26,151,500$ (307,810)$
Explanation of Major Changes From Last Year:
Sales Tax revenue is down $137,525 compared to revenue through February 2017. This is due to the closure of two taxpayers and general timing of returns. Total Sales Tax
revenue through February 2018 is $78,368 under budget due to the timing of tax returns.
Other Intergovernmental Tax revenue is up $48,394 compared to revenue through February 2017. This is due to Income Tax collections being higher than last year.
Total Intergovernmental Tax revenue through February 2018 is $13,940 over budget.
Licenses & Permits revenue is up $513,593 compared to collections through February 2017. This is primarily due to a large construction permit being received in 2018.
Total Licenses & Permits revenue through February 2018 is over budget by $103,615.
Personnel expenditures are up $45,593 compared to payments through February 2017. This is primarily due to normal annual wage increases. Total Personnel expenditures
through February 2018 are $256,419 under budget due to public safety pensions being funded lower than budgeted and open budgeted positions.
Operation & Contractual expenditures are down $295,249 compared to payments through February 2017. This is due to the general timing of payments and a decrease in
liability insurance premiums. Total Operation & Contractual expenditures through February 2018 are $157,094 under budget due to general timing of payments.
Capital Outlay expenditures are down $66,811 compared to payments through February 2017. This is due to the general timing of projects. Total Capital Outlay expenditures
through February 2018 are $548,312 under budget due to the timing of projects.
Five Year Trend
For the Period Ending February 28, 2018
General Fund ‐ Five Year Trend
Village of Oak Brook
Revenues Expenditures
2/28/18 2/28/18
2/28/17 2/28/18 YTD % of 2018 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Hotel Tax 149,602$ 157,919$ 160,000$ 99% 1,340,000$ 8,317$
Interest 6,447 10,826 5,000 217% 30,000 4,379
Miscellaneous ‐ 1,654 ‐ N/A ‐ 1,654
Total Operating Revenues 156,049$ 170,399$ 165,000$ 103.3% 1,370,000$ 14,350$
EXPENDITURES
Operation and Contract 20,938$ 47$ 99,290$ 0% 646,515$ (20,891)$
Other Expenditures 15,566 16,590 16,590 100% 99,550 1,024
Capital Outlay ‐ 1,419 ‐ 0% 640,000 1,419
Total Expenditures 36,504$ 18,056$ 115,880$ 15.6% 1,386,065$ (18,448)$
NET FUND INCREASE (DECREASE)119,545$ 152,343$ 49,120$ (16,065)$ 32,798$
Note ‐ Expenditures are recorded in program 171.
Village of Oak Brook
Hotel Tax Fund Financial Update
For the Period Ending February 28, 2018
Total Total
Revenues Expenditures
2/28/18 Actual $ 170,399 18,056$
2/28/17 Actual $ 156,049 36,504$
% Change From Last Year 9.2% ‐50.5%
Major Revenues
Grants Hotel Tax Interest Miscellaneous
2/28/18 Actual $ ‐ $ 157,919 $ 10,826 $ 1,654
2/28/17 Actual $ ‐ $ 149,602 $ 6,447 $ ‐
% Change From Last Year N/A 5.6% 67.9% N/A
Five Year Trend
Major Expenditures Operation & Other
Contractual Expenditures Capital Outlay
2/28/18 Actual 47$ 16,590$ 1,419$
2/28/17 Actual 20,938$ 15,566$ ‐$
% Change From Last Year ‐99.8% 6.6% N/A
Five Year Trend
Explanation of Major Changes From Last Year:
Hotel Tax revenue is up $8,317 compared to collections through February 2017. This is related to the opening of a new
hotel late in 2017. Total Hotel Tax revenue through February 2018 is under budget by $2,081.
Village of Oak Brook
Hotel Tax Fund ‐ Major Sources Five Year Trend
For the Period Ending February 28, 2018
Five Year Trend
Revenues Expenditures
2/28/18 2/28/18
2/28/17 2/28/18 YTD % of 2018 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 991,452$ 892,622$ 936,250$ 95% 5,563,000$ (98,830)$
Grants ‐ ‐ ‐ N/A ‐ ‐
Interest 8,416 20,346 7,000 291% 42,000 11,930
Miscellaneous ‐ 1,516 830 183% 5,000 1,516
Reimbursements From Other Funds 29,440 30,188 30,190 100% 181,130 748
Total Operating Revenues 1,029,308$ 944,672$ 974,270$ 97% 5,791,130$ (84,636)$
OPERATING EXPENDITURES
Personnel 196,846 228,705$ 250,105$ 91% 1,365,445$ 31,859$
Materials and Supplies 16,040 49,582 45,450 109% 182,955 33,542
Operation and Contract 243,507 159,200 201,710 79% 1,484,755 (84,307)
Other Expenditures 27,084 27,478 27,480 100% 164,865 394
Capital Outlay ‐ 2,469 50,000 5% 5,625,620 2,469
‐
Total Operating Expenditures 483,477$ 467,434$ 574,745$ 81% 8,823,640$ (16,043)$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 545,831$ 477,238$ 399,525$ 119% (3,032,510)$ (68,593)$
INTERFUND TRANSACTIONS
Transfers In ‐$ ‐$ ‐$ N/A 500,000$ ‐$
Total Interfund Transactions ‐$ ‐$ ‐$ N/A 500,000$ ‐$
NET FUND INCREASE (DECREASE)545,831$ 477,238$ 399,525$ (2,532,510)$ (68,593)$
Village of Oak Brook
Infrastructure Fund Financial Update
For the Period Ending February 28, 2018
Total Total
Revenues Expenditures
2/28/18 Actual $ 944,672 467,434$
2/28/17 Actual $ 1,029,308 483,477$
% Change From Last Year ‐8.2% ‐3.3%
Major Revenues
Sales Tax Grants Interest Miscellaneous Reimbursements
2/28/18 Actual $ 892,622 $ ‐ $ 20,346 $ 1,516 $ 30,188
2/28/17 Actual $ 991,452 $ ‐ $ 8,416 $ ‐ $ 29,440
% Change From Last Year ‐10.0% N/A 141.8% N/A 2.5%
Five Year Trend
Major Expenditures Materials & Operation & Other
Personnel Supplies Contractual Expenditures Capital Outlay
2/28/18 Actual 228,705$ 49,582$ 159,200$ 27,478$ 2,469$
2/28/17 Actual 196,846$ 16,040$ 243,507$ 27,084$ ‐$
% Change From Last Year 16.2% 209.1% ‐34.6% 1.5% N/A
Five Year Trend
Expenditures by Department
2/28/17 2/28/18 2/28/18 2/28/18 2018 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 13,976$ 16,567$ 27,245$ 60.8% 178,530$ 2,591$
Public Works 455,050 423,571 459,690 92.1% 2,592,335 (31,479)
Engineering & Capital Projects 14,451 27,296 87,810 31.1% 6,052,775 12,845
Total Expenditures 483,477$ 467,434$ 574,745$ 81.3% 8,823,640$ (16,043)$
Explanation of Major Changes From Last Year:
Sales Tax revenue is down $98,830 compared to revenue through February 2017. This is due to the State's 2% service fee reduction implemented in mid‐2017 and
the closure of two businesses. Total Sales Tax revenue through February 2018 is $43,628 under budget due to the timing of returns filed.
Personnel expenditures are up $31,859 compared to payments through February 2017. This is primarily due to an increase in snow overtime hours worked compared
to last year. Total Personnel costs through February 2018 are $21,000 under budget due to unsettled contract negotiations.
Operation & Contractual expenditures are down $84,307 compared to payments through February 2017. This is due to a decrease in liability insurance premiums.
Total Operation & Contractual expenditures through February 2018 are $42,510 under budget due to the timing of payments.
Five Year Trend
Village of Oak Brook
Infrastructure Fund ‐ Major Sources Five Year Trend
For the Period Ending February 28, 2018
Revenues Expenditures
2/28/18 2/28/18
2/28/17 2/28/18 YTD % of 2018 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax ‐$ ‐$ ‐$ N/A 102,500$ ‐$
Real Estate Tax ‐ ‐ ‐ N/A 385,000 ‐
Interest 64 199 50 398% 250 135
Total Operating Revenues 64$ 199$ 50$ 398% 487,750$ 135$
EXPENDITURES
Operation and Contract ‐$ ‐$ ‐$ N/A 4,090$ ‐$
Other Expenditures 220,295 223,210 223,210 100% 459,820 2,915
Total Expenditures 220,295$ 223,210$ 223,210$ 100% 463,910$ 2,915$
NET FUND INCREASE (DECREASE)(220,231)$ (223,011)$ (223,160)$ 23,840$ (2,780)$
Note ‐ Expenditures are recorded in program 283.
Village of Oak Brook
Promenade TIF Fund Financial Update
For the Period Ending February 28, 2018
Total Total
Revenues Expenditures
2/28/18 Actual $ 199 223,210$
2/28/17 Actual $ 64 220,295$
% Change From Last Year 210.9% 1.3%
Major Revenues Real Estate
Sales Tax Tax Interest
2/28/18 Actual $ ‐ $ ‐ $ 199
2/28/17 Actual $ ‐ $ ‐ $ 64
% Change From Last Year N/A N/A 210.9%
Five Year Trend
Major Expenditures Operation & Other
Contractual Expenditures
2/28/18 Actual ‐$ 223,210$
2/28/17 Actual ‐$ 220,295$
% Change From Last Year N/A 1.3%
Five Year Trend
Village of Oak Brook
Promenade TIF Fund ‐ Major Sources Five Year Trend
For the Period Ending February 28, 2018
Five Year Trend
Revenues Expenditures
2/28/18 2/28/18
2/28/17 2/28/18 YTD % of 2018 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Plan Review Fees 225$ 225$ 330$ 68% 2,000$ ‐$
Building/Inspection Fees 225 225 830 27% 5,000 ‐
Water Sales 1,108,956 1,183,685 1,155,000 102% 9,730,425 74,729
Unmetered Sales 2,894 418 5,000 8% 30,000 (2,476)
Water Connection Fees 8,280 5,520 8,300 67% 50,000 (2,760)
Fire Service Charge ‐ ‐ 830 0% 5,000 ‐
Meter Charges 1,726 1,013 4,170 24% 25,000 (713)
Special Services ‐ ‐ ‐ 0% 30,000 ‐
Interest on Investments 4,240 13,008 1,670 779% 10,000 8,768
Miscellaneous 7,697 14,705 8,330 177% 50,000 7,008
Total Operating Revenues 1,134,243$ 1,218,799$ 1,184,460$ 103% 9,937,425$ 84,556$
EXPENDITURES
Personnel 140,909$ 123,581$ 129,425$ 95% 817,490$ (17,328)$
Materials and Supplies 2,456 6,511 13,180 49% 76,860 4,055
Operation and Contract 439,281 467,272 1,126,695 41% 6,780,015 27,991
Other Expenditures 66,934 67,528 67,530 100% 405,170 594
Capital Outlay 6,327 44,266 495,030 9% 2,710,220 37,939
Total Expenditures 655,907$ 709,158$ 1,831,860$ 39% 10,789,755$ 53,251$
NET FUND INCREASE (DECREASE)478,336$ 509,641$ (647,400)$ (852,330)$ 31,305$
Village of Oak Brook
Water Fund Financial Update
For the Period Ending February 28, 2018
Total Total
Revenues Expenditures
2/28/18 Actual $ 1,218,799 709,158$
2/28/17 Actual $ 1,134,243 655,907$
% Change From Last Year 7.5% 8.1%
Unmetered Water
Water Sales Sales Connection Fees Meter Charges Miscellaneous
2/28/18 Actual $ 1,183,685 $ 418 $ 5,520 $ 1,013 $ 14,705
2/28/17 Actual $ 1,108,956 $ 2,894 $ 8,280 $ 1,726 $ 7,697
% Change From Last Year 6.7% ‐85.6% ‐33.3% ‐41.3% 91.0%
Five Year Trend
Materials & Operation & Other
Personnel Supplies Contractual Expenditures Capital Outlay
2/28/18 Actual 123,581$ 6,511$ 467,272$ 67,528$ 44,266$
2/28/17 Actual 140,909$ 2,456$ 439,281$ 66,934$ 6,327$
% Change From Last Year ‐12.3% 165.1% 6.4% 0.9% 599.6%
Five Year Trend
Expenditures by Department
2/28/17 2/28/18 2/28/18 2/28/18 2018 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Public Works 641,202$ 659,080$ 1,327,660$ 49.6% 8,124,535$ 17,878$
Engineering & Capital Projects 14,705 50,078 504,200 0.0% 2,665,220 35,373
Total Expenditures 655,907$ 709,158$ 1,831,860$ 38.7% 10,789,755$ 53,251$
Explanation of Major Changes From Last Year:
Water Sales revenue is up $74,729 compared to collections through February 2017. This is due to a 7% rate increase adopted January 1, 2018. Total Water Sales
revenue through February 2018 is over budget by $28,685 due to gallons billed being slightly higher than projected.
Operation & Contractual expenditures are up $27,991 compared to payments through February 2017. This is due to an increase in DWC water purchased and rate.
Operation & Contractual expenditures through February 2018 are under budget by $659,423 due to the timing of bills being paid.
Capital Outlay expenditures are up $37,939 compared to payments through February 2017. This is due to the start of the water meter replacement project. Capital
Outlay expenditures through February 2018 are under budget by $450,764 due to general timing of invoices.
Five Year Trend
Village of Oak Brook
Water Fund ‐ Major Sources Five Year Trend
For the Period Ending February 28, 2018
Revenues Expenditures
Village of Oak BrookMonthly Operating StatementSports Core Fund Consolidated PresentationFor the Period Ending February 28, 20182/28/18 2/28/182/28/18 YTD % of 2018 2/28/17 DifferenceB&T Recreation Food & Golf YTD Amended Amended Adopted YTD PriorPrograms Beverage Club Total Budget Budget Budget Total YearDIRECT REVENUESMemberships ‐$ ‐$ 14,750$ 14,750$ 44,275$ 33% 414,875$ 67,950$ (53,200)$ Greens Fees ‐ ‐ (129) (129) ‐ 0% 975,000 20,563 (20,692) Pro Shop Sales ‐ ‐ 2,862 2,862 1,735 165% 200,000 4,913 (2,051) Golf Lessons ‐ ‐ 590 590 ‐ 0% 40,000 ‐ 590 Driving Range Fees ‐ ‐ 3,980 3,980 9,000 44% 235,000 13,020 (9,040) Rentals ‐ ‐ ‐ ‐ 12,025 0% 451,000 5,423 (5,423) Programs/User Fees 3,400 ‐ ‐ 3,400 2,500 136% 300,700 3,175 225 Food Sales ‐ ‐ ‐ ‐ ‐ 0% 145,500 1,260 (1,260) Beverage Sales ‐ ‐ ‐ ‐ ‐ 0% 236,000 3,361 (3,361) Other Revenue (179) 7,515 522 7,858 10,240 77% 380,650 3,220 4,638 Total Direct Revenues3,221$ 7,515$ 22,575$ 33,311$ 79,775$ 42% 3,378,725$ 122,885$ (89,574)$ DIRECT EXPENDITURESPersonnel 3,658$ 16,189$ 94,714$ 114,561$ 144,660$ 79% 1,497,200$ 122,492$ (7,931)$ Materials & Supplies 186 1,114 (8,552) (7,252) 8,350 ‐87% 615,885 22,814 (30,066) Operational & Contractual 279,801 7,741 59,251 346,793 124,520 279% 961,510 138,833 207,960 Other ‐ ‐ ‐ ‐ 17,620 0% (44,275) ‐ ‐ Capital 9,988 ‐ ‐ 9,988 7,500 133% 365,660 58,054 (48,066) Total Direct Expenditures293,633$ 25,044$ 145,413$ 464,090$ 302,650$ 153% 3,395,980$ 342,193$ 121,897$ Direct Revenues Over (Under) Expenditures(290,412)$ (17,529)$ (122,838)$ (430,779)$ (222,875)$ 193% (17,255)$ (219,308)$ (211,471)$ B&T Administration Overhead Allocation* 14,597$ (14,597)$ ‐$ ‐$ ‐$ 0% ‐$ ‐$ ‐$ Operating Revenues Over (Under) Expenditures(275,815)$ (32,126)$ (122,838)$ (430,779)$ (222,875)$ 193% (17,255)$ (219,308)$ (211,471)$ Interfund Loan** 100,000$ ‐$ ‐$ 100,000$ ‐$ 0% ‐$ ‐$ 100,000$ Transfer From General Fund ‐ ‐ ‐ ‐ ‐ 0% ‐ ‐ ‐ Transfer From Infrastructure Fund 4,000 ‐ ‐ 4,000 4,000 100% 24,000 4,000 ‐ Transfer From Water Fund 1,334 ‐ ‐ 1,334 1,330 100% 8,000 1,334 ‐ Transfer From Golf Surcharge Fund ‐ ‐ ‐ ‐ ‐ 0% ‐ ‐ ‐ Adjusted Operating Revenues Over (Under) Expenditures(170,481)$ (32,126)$ (122,838)$ (325,445)$ (217,545)$ 14,745$ (213,974)$ (111,471)$ *Overhead allocation is comprised of salaries, business forms, liability insurance, building & grounds maintenance and bank service fees in Program 811 ‐ Sports Core General Operations distributed to various Sports Core Programs on a % basis.**Interfund loan is from the General Fund. This will be repaid as the season begins.
Total Direct Total Direct
Revenues Expenditures
2/28/18 Actual $ 33,311 464,090$
2/28/17 Actual $ 122,885 342,193$
% Change From Last Year ‐72.9% 35.6%
Driving Program/
Memberships Greens Fees Range Fees Rentals User Fees
2/28/18 Actual $ 14,750 $ (129) $ 3,980 $ ‐ $ 3,400
2/28/17 Actual $ 67,950 $ 20,563 $ 13,020 $ 5,423 $ 3,175
% Change From Last Year ‐78.3% ‐100.6% ‐69.4% ‐100.0% 7.1%
Five Year Trend
Materials & Operation & Other
Personnel Supplies Contractual Expenditures Capital Outlay
2/28/18 Actual 114,561$ (7,252)$ 346,793$ ‐$ 9,988$
2/28/17 Actual 122,492$ 22,814$ 138,833$ ‐$ 58,054$
% Change From Last Year ‐6.5% ‐131.8% 149.8% 0.0% ‐82.8%
Five Year Trend
Revenues by Department 2/28/17 2/28/18 2/28/18 2/28/18 2018 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Programs 3,389$ 3,221$ 646,495$ 0.5% 712,075$ (168)$
Food & Beverage 7,077 7,515 127,800 5.9% 569,000 438
Golf Club 112,419 22,575 567,997 4.0% 2,097,650 (89,844)
Total Revenues 122,885$ 33,311$ 1,342,292$ 2.5% 3,378,725$ (89,574)$
Expenditures by Department 2/28/17 2/28/18 2/28/18 % of 2018 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Programs 95,869$ 293,633$ 344,363$ 85.3% 1,058,430$ 197,764$
Food & Beverage 73,669 25,044 281,968 8.9% 514,980 (48,625)
Golf Club 172,655 145,413 778,751 18.7% 1,822,570 (27,242)
Total Expenditures 342,193$ 464,090$ 1,405,082$ 33.0% 3,395,980$ 121,897$
Explanation of Major Changes From Last Year:
Membership revenues are down $53,200 compared to revenue through February 2017. This is due to the pool operation transition to the Park District.
Total Membership revenue through February 2018 is $29,525 under budget due to the timing of renewals being sent.
Greens Fees revenues are down $20,692 compared to revenue through February 2017. This is due to the golf course opening early in 2017.
Operation & Contractual expenditures are up $207,960 compared to expenditures through February 2017. This is due to the Park District management fee.
Total Operation & Contractual expenditures through February 2018 are $222,273 over budget due to the timing of management fees.
Five Year Trend
Village of Oak Brook
Sports Core Fund ‐ Major Sources Five Year Trend
For the Period Ending February 28, 2018
Revenues Expenditures
Village of Oak BrookMonthly Operating StatementBath & Tennis Club Recreation ProgramsFor the Period Ending February 28, 20182/28/18 2/28/182/28/18 YTD % of 2018 2/28/17 Difference811 812 813 815 816 YTD Amended Amended Adopted YTD PriorB&T Admin Swimming Tennis Polo Open Fields Total Budget Budget Budget Total YearRevenues:Memberships ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ 200$ 0% 223,375$ ‐$ ‐$ Programs/User Fees 300 ‐ ‐ ‐ 3,100 3,400 2,500 136% 300,700 3,175 225 Beverage Sales ‐ ‐ ‐ ‐ ‐ ‐ ‐ 0% ‐ ‐ ‐ Other Revenue (179) ‐ ‐ ‐ ‐ (179) 140 ‐128% 188,000 214 (393) Total Revenue121$ ‐$ ‐$ ‐$ 3,100$ 3,221$ 2,840$ 113% 712,075$ 3,389$ (168)$ Expenditures:Personnel 3,658$ ‐$ ‐$ ‐$ ‐$ 3,658$ 21,760$ 17% 208,040$ 20,140$ (16,482)$ Materials & Supplies 186 ‐ ‐ ‐ ‐ 186 3,890 5% 28,280 7,234 (7,048) Operational & Contractual 23,310 255,978 44 ‐ 469 279,801 52,925 529% 586,160 59,571 220,230 Other ‐ ‐ ‐ ‐ ‐ ‐ 9,360 0% 56,200 ‐ ‐ Capital ‐ 9,988 ‐ ‐ ‐ 9,988 7,500 133% 179,750 8,924 1,064 Total Expenditures27,154$ 265,966$ 44$ ‐$ 469$ 293,633$ 95,435$ 308% 1,058,430$ 95,869$ 197,764$ Direct Revenues Over (Under) Expenditures(27,033)$ (265,966)$ (44)$ ‐$ 2,631$ (290,412)$ (92,595)$ 314% (346,355)$ (92,480)$ (197,932)$ B&T Administration Overhead Allocation* 27,033$ (9,733)$ (2,703)$ ‐$ ‐$ 14,597$ 47,560$ 31% 207,995$ 50,850$ (36,253)$ Revenues Over (Under) Expenditures‐$ (275,699)$ (2,747)$ ‐$ 2,631$ (275,815)$ (45,035)$ 612% (138,360)$ (41,630)$ (234,185)$ Interfund Loan** 100,000$ ‐$ ‐$ ‐$ ‐$ 100,000$ ‐$ 0% ‐$ ‐$ 100,000$ Transfer From General Fund ‐ ‐ ‐ ‐ ‐ ‐ ‐ 0% ‐ 4,000 (4,000) Transfer From Infrastructure Fund 4,000 ‐ ‐ ‐ ‐ 4,000 4,000 100% 24,000 1,334 2,666 Transfer From Water Fund 1,334 ‐ ‐ ‐ ‐ 1,334 1,330 100% 8,000 ‐ 1,334 Adjusted Revenues Over (Under) Expenditures105,334$ (275,699)$ (2,747)$ ‐$ 2,631$ (170,481)$ (39,705)$ (106,360)$ (36,296)$ (134,185)$ *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 BrookMonthly Operating StatementSports Core Food & Beverage ProgramsFor the Period Ending February 28, 20182/28/18 2/28/18821 822 823 2/28/18 YTD % of 2018 2/28/17 DifferenceB&T Poolside Golf YTD Amended Amended Adopted YTD Prior Clubhouse Café Clubhouse Total Budget Budget Budget Total YearRevenues:Memberships ‐$ ‐$ ‐$ ‐$ ‐$ N/A ‐$ ‐$ ‐$ Food Sales ‐ ‐ ‐ ‐ ‐ N/A 145,500 1,260 (1,260) Beverage Sales ‐ ‐ ‐ ‐ ‐ N/A 236,000 3,361 (3,361) Other Revenue 7,515 ‐ ‐ 7,515 10,000 75% 187,500 2,456 5,059 Total Revenue7,515$ ‐$ ‐$ 7,515$ 10,000$ 75% 569,000$ 7,077$ 438$ Expenditures:Personnel 15,108$ ‐$ 1,081$ 16,189$ 21,830$ 74% 199,505$ 12,183$ 4,006$ Materials & Supplies 825 ‐ 289 1,114 760 147% 182,150 6,613 (5,499) Operational & Contractual 7,390 ‐ 351 7,741 14,650 53% 133,325 5,743 1,998 Capital ‐ ‐ ‐ ‐ ‐ N/A ‐ 49,130 (49,130) Total Expenditures23,323$ ‐$ 1,721$ 25,044$ 37,240$ 67% 514,980$ 73,669$ (48,625)$ Direct Revenues Over (Under) Expenditures(15,808)$ ‐$ (1,721)$ (17,529)$ (27,240)$ 64% 54,020$ (66,592)$ 49,063$ B&T Administration Overhead Allocation* (13,516)$ (1,081)$ ‐$ (14,597)$ (47,560)$ 31% (175,995)$ (50,850)$ 36,253$ Revenues Over (Under) Expenditures(29,324)$ (1,081)$ (1,721)$ (32,126)$ (74,800)$ 43% (121,975)$ (117,442)$ 85,316$ Transfer From General Fund ‐$ ‐$ ‐$ ‐$ ‐$ 0% ‐$ ‐$ ‐$ Adjusted Revenues Over (Under) Expenditures(29,324)$ (1,081)$ (1,721)$ (32,126)$ (74,800)$ (121,975)$ (117,442)$ 85,316$ *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 BrookMonthly Operating StatementGolf Club ProgramsFor the Period Ending February 28, 20182/28/18 2/28/18831 832 833 834 2/28/18 YTD % of 2018 2/28/17 DifferenceGolf General Golf Learning Golf Cart Golf Course YTD Amended Amended Adopted YTD PriorOperation & Practice Operations Maintenance Total Budget Budget BudgetTotal YearRevenues:Memberships 14,750$ ‐$ ‐$ ‐$ 14,750$ 44,075$ 33% 191,500$ 67,950$ (53,200)$ Greens Fees (129) ‐ ‐ ‐ (129) ‐ 0% 975,000 20,563 (20,692) Pro Shop Sales 2,862 ‐ ‐ ‐ 2,862 1,735 165% 200,000 4,913 (2,051) Golf Lessons ‐ 590 ‐ ‐ 590 ‐ 0% 40,000 ‐ 590 Driving Range Fees ‐ 3,980 ‐ ‐ 3,980 9,000 44% 235,000 13,020 (9,040) Rentals ‐ ‐ ‐ ‐ ‐ 12,025 0% 451,000 5,423 (5,423) Other Revenue 522 ‐ ‐ ‐ 522 100 522% 5,150 550 (28) Total Revenue18,005$ 4,570$ ‐$ ‐$ 22,575$ 66,935$ 34% 2,097,650$ 112,419$ (89,844)$ Expenditures:Personnel 59,237$ ‐$ 154$ 35,323$ 94,714$ 101,070$ 94% 1,089,655$ 90,169$ 4,545$ Materials & Supplies (14,450) ‐ ‐ 5,898 (8,552) 3,700 ‐231% 405,455 8,967 (17,519) Operational & Contractual 49,436 ‐ 200 9,615 59,251 56,945 104% 242,025 73,519 (14,268) Other ‐ ‐ ‐ ‐ ‐ 8,260 0% (100,475) ‐ ‐ Capital ‐ ‐ ‐ ‐ ‐ ‐ N/A 185,910 ‐ ‐ Total Expenditures94,223$ ‐$ 354$ 50,836$ 145,413$ 169,975$ 86% 1,822,570$ 172,655$ (27,242)$ Direct Revenues Over (Under) Expenditures(76,218)$ 4,570$ (354)$ (50,836)$ (122,838)$ (103,040)$ 119% 275,080$ (60,236)$ (62,602)$ Transfer from General Fund ‐$ ‐$ ‐$ ‐$ ‐$ ‐$ 0% ‐$ ‐$ ‐$ Adjusted Revenues Over (Under) Expenditures(76,218)$ 4,570$ (354)$ (50,836)$ (122,838)$ (103,040)$ 275,080$ (60,236)$ (62,602)$