Loading...
01 - January 2018 Monthly Financial ReportVILLAGE OAK BROOK OF MONTHLY FINANCIAL REPORTS JANUARY 2018 ITEM 6.F Total Cash and Cash Pooled Cash and Fund Equivalents Investments Investments % By Fund General Corporate $6,071,711 $12,180,066 $18,251,777 45.0% Hotel/Motel Tax 1,689,914 2,497,548 4,187,462 10.3% Motor Fuel Tax 150,749 441,919 592,668 1.5% Infrastructure 4,908,100 3,519,420 8,427,520 20.8% Promenade TIF 19,758 ‐                                       19,758 0.0% Water 4,414,171 1,247,834 5,662,005 14.0% Sports Core 332,552 ‐                                       332,552 0.8% Golf Surcharge 19,087                            540,744                         559,831 1.4% Self‐Insurance 331,036 ‐                                       331,036 0.8% Garage 432,199 ‐                                       432,199 1.1% Equipment Replacement 724,343 1,054,209 1,778,552 4.4% Total $19,093,618 $21,481,741 $40,575,359 100.0% Change in Cash and Investments by Fund : Balance at Balance at Year‐to‐Date Year‐to‐Date Fund January 1, 2018 January 31, 2018 Change ($) Change (%) General Corporate $17,679,585 $18,251,777 $572,192 3.2% Hotel/Motel Tax 4,172,234 4,187,462 15,228 0.4% Motor Fuel Tax 574,460 592,668 18,208 3.2% Infrastructure 8,222,797 8,427,520 204,723 2.5% Promenade TIF 276,164 19,758 (256,406)‐92.8% Water 5,692,458 5,662,005 (30,452)‐0.5% Sports Core 472,473 332,552 (139,921)‐29.6% Golf Surcharge 559,073 559,831 758 0.1% Self‐Insurance 45,042 331,036 285,993 634.9% Garage 427,409 432,199 4,789 1.1% Equipment Replacement 1,805,663 1,778,552 (27,111)‐1.5% $39,927,358 $40,575,359 $648,001 1.6% Book Market   Value Value Pooled Checking $1,015,754 $1,015,754 Sports Core Checking 349,944 349,944 Pooled IPTIP 17,624,513 17,624,513 Water E‐Pay IPTIP 103,407 103,407 $19,093,618 $19,093,618 Pooled Investments: Investments‐Municipal $9,270,967 $9,172,358 Investments‐Corporate 4,276,973 4,272,523 Government & Agency Obligations 859,799 832,604 Certificates of Deposit 6,965,000 6,922,656 Accrued Interest 109,002 109,002 Total Pooled Investments $21,481,741 $21,309,143 Total Cash and Investments $40,575,359 $40,402,761 For January, total interest revenue is $49,846. Total investment yield for the portfolio is: Pooled Investments Illinois Funds Total Monthly yield 0.14% 0.13% 0.13% YTD yield 0.14% 0.13% 0.13% Last 12 months yield 1.50% 1.00% 1.29% The weighted average yield of the current pooled investment portfolio is 1.75%.   Monthly Treasurer's Report January 31, 2018 Monthly Treasurer's Report January 2018 The table below lists the detail investment holdings at J.P. Morgan Securities as of 1/31/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,949 $750,518 $1,303 Maryland St Econ Dev #57420PGK6 07/08/15 6/1/2019 2.050% 2.123% 99,903 99,760 340 Rosemont IL GO Corp #777543UT4 02/08/16 12/1/2019 3.021% 2.000% 509,124 501,540 2,422 New York St Urban Dev Corp #650035J58 02/22/16 3/15/2018 1.650% 1.150% 175,104 174,988 1,082 New York N Y City #64971QTX1 02/22/16 5/1/2021 2.350% 2.000% 202,185 197,904 1,161 Florida Hurricane #34074GDH4 03/30/16 7/1/2020 2.995% 2.150% 509,851 505,815 1,247 Bloomingdale Mich Pub Sch Dist #094383FS0 04/26/16 5/1/2022 2.710% 2.150% 511,300 494,260 3,349 Milan Mich Area Achs #598801JD1 05/26/16 5/1/2020 1.931% 1.931% 245,000 242,442 1,082 Indiana Bd Bk Rev Taxable #4546248F7 01/06/17 1/15/2020 2.934% 1.900% 260,021 256,966 346 North Carolina Eastn Mun PWR #65819WAC7 01/30/17 7/1/2018 2.003% 1.450% 701,583 700,042 1,168 Garland Cnty Ark Sales & Use #36609PAN3 02/06/17 11/1/2019 1.795% 1.840% 499,611 493,145 2,368 Anchor Bay Mich Sch Dist GO #032879TA6 02/13/17 5/1/2019 1.810% 1.420% 366,766 363,120 1,575 Macomb Cnty Mich Retirees #554885H63 04/11/17 11/1/2018 1.731% 1.300% 401,287 399,060 1,688 Lanse Creuse Mich Pub Schs #516228RL9 05/02/17 5/1/2020 2.159% 2.159% 100,000 99,408 537 California St GO Bonds #13063A7G3 05/08/17 10/1/2019 6.200% 1.600% 537,816 531,830 10,051 *Genesee Cnty Mich #371608UV0 05/31/17 10/1/2019 2.167% 2.167% 559,000 559,011 555 Connecticut St GO Bds 2016 #20772J3F7 06/15/17 8/15/2021 1.750% 2.300% 490,689 474,400 3,981 North Carolina Eastn Mun Pwr #65819WAL7 10/02/17 7/1/2019 2.578% 1.700% 506,151 502,030 931 Fowlerville Mich Comnty Schs #351280MS8 10/03/17 5/1/2020 2.045% 1.750% 503,255 496,780 2,386 Racine Cnty WI #38379UEM4 12/20/17 12/1/2020 2.150% 2.150% 750,000 742,185 1,836 Wisconsin St Gen Fd Annual #977100CW4 01/05/18 5/1/2020 1.446% 2.100% 591,372 587,154 2,073 Total Municipal Bonds $9,270,967 $9,172,358 $41,481 Corporate Bonds: Wachovia #92976WBH8 06/15/17 2/1/2018 5.750% 1.360% $1,033,175 $1,033,000 $29,337 Morgan Stanley #6174467U7 08/28/17 4/25/2018 2.125% 1.531% 1,392,128 1,390,681 7,140 Goldman Sachs #38147MAA3 01/25/18 7/19/2018 2.900% 1.752% 849,514 848,372 749 American Honda Finance Corp #02665WAC5 01/25/18 10/10/2018 2.125% 1.809% 1,002,157 1,000,470 6,493 Total Corporate Bonds $4,276,973 $4,272,523 $43,719 Government & Agency Obligations: **Government National Mtg Assn #38379UEM4 02/29/16 2/16/2051 2.300% 2.245% $859,799 $832,604 $2,131 Total Government & Agency Obligations: $859,799 $832,604 $2,131 Certificates of Deposit: Capital One Natl Assn VA #14042E5Z9 08/26/15 8/27/2018 1.75% 1.75% $245,000 $245,130 $2,278 Ally Bk Midvale Utah #02006LVC4 10/29/15 10/29/2018 1.60% 1.60% 245,000 245,061 980 Wex Bank Midvale Utah #92937CDY1 07/29/16 7/30/2018 1.00% 1.00% 245,000 244,363 4 Bank Hope Los Angeles #062683AB3 08/26/16 8/27/2018 1.00% 1.00% 245,000 244,052 21 Wells Fargo Bank Natl Assn #949763AL0 08/31/16 8/31/2018 1.10% 1.10% 245,000 244,049 1 BMW Bank #05580AFG4 09/23/16 9/24/2018 1.10% 1.10% 245,000 243,910 951 Comenity Cap Bank #20033ASB3 09/26/16 9/26/2018 1.10% 1.10% 245,000 243,885 27 Enerbank #29266N4E4 10/21/16 10/22/2018 1.10% 1.10% 245,000 244,035 749 Discover Bank #254672L71 10/26/16 10/26/2018 1.20% 1.20% 245,000 243,711 776 State Bk India NY #8562846A7 01/26/17 1/26/2022 2.25% 2.25% 245,000 243,371 77 Marlin Business Bk #57116ANU8 05/10/17 11/12/2019 1.60% 1.60% 245,000 242,837 211 American Express Fed Svgs #02587CER7 05/10/17 11/12/2019 1.70% 1.70% 245,000 242,775 920 Synchrony Bank #87164WRA8 05/26/17 5/28/2019 1.65% 1.65% 245,000 244,022 691 Umpqua Bank #90421MAG8 05/31/17 5/31/2019 1.60% 1.60% 245,000 243,849 659 Stone Bk Mtn View Ark #86158RAJ8 06/28/17 6/28/2019 1.60% 1.60% 245,000 243,689 10 Investors Savings Bk #46176PGU3 06/30/17 4/2/2018 1.35% 1.35% 245,000 244,978 1,929                   TIAA FSB Jacksonville #87270LAA1 07/19/17 7/19/2019 1.60% 1.60% 245,000 243,579 115                      Peoples United Bank #71270QQZ2 07/19/17 7/19/2019 1.65% 1.65% 245,000 243,758 118                      Priority Bank Ozark Ark #74269KBR6 07/26/17 7/26/2019 1.60% 1.60% 245,000 243,535 38                         American Express Centurion #02587DV96 08/15/17 8/17/2020 1.90% 1.90% 245,000 241,879 2,134                   Sallie Mae #795450C86 08/16/17 8/17/2020 1.90% 1.90% 245,000 242,778 2,134                   Merrick Bank South Jordan #59013JZS1 08/21/17 8/21/2020 1.80% 1.80% 245,000 242,138 111                      Pinnacle Bank #72345SFS5 08/30/17 8/31/2020 1.80% 1.80% 115,000 113,632 1                           Jackson County Bank #466682AP6 08/31/17 3/1/2021 1.85% 1.85% 245,000 241,359 1,889                   Barclays Bank #06740KKX4 09/27/17 9/28/2020 1.95% 1.95% 245,000 242,876 1,632                   Capital One Bank #1404205E6 10/04/17 10/4/2019 1.70% 1.70% 245,000 243,510 1,342                   Transportation Alliance #89388CCB2 10/13/17 4/12/2019 1.60% 1.60% 235,000 234,121 170                      Goldman Sachs Bank #38148PRK5 10/18/17 10/19/2020 1.95% 1.95% 245,000 242,766 1,354                   FirstBank PR Santurce #33767A6M8 11/03/17 11/3/2020 2.00% 2.00% 245,000 243,008 352                      Total Certificates of Deposits $6,965,000 $6,922,656 $21,671 Total J.P.Morgan Securities $21,372,739 $21,200,141 $109,002 *Interest rate is a floating rate that sets each month.  Rate is determined at the one‐month LIBOR rate plus 0.60% **This is a mortgage backed security that receives principal payments each month based on mortgage repayments.  Monthly  principal payments will vary and the investment balance may be repaid before the 2/16/2051 maturity date. VILLAGE OF OAK BROOK Monthly Treasurer's Report January 31, 2018 Cash & Investments by Fund ‐ Total $40.6 million Cash & Investments by Type ‐ Total $40.6 million General Corporate 44.98% Hotel/Motel Tax 10.32%Motor Fuel Tax 1.46% Infrastructure 20.77% Promenade TIF 0.05% Water 13.95% Sports Core 0.82% Golf Surcharge 1.38% Self‐Insurance 0.82%Garage 1.07% Equipment  Replacement 4.38% Checking, $1.4 Illinois Funds, $17.7 Certificates of Deposit,  $6.9 Municipal Bonds, $9.3 Corporate Bonds, $4.3 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)$2,379,631 $1,747,845 $631,786 ($46,815)   Main operating fund of the Village. Hotel Fund (Major Fund)$76,965 $8,295 $68,670 $24,560   Collects and spends resources from the   3% hotel/motel tax. Motor Fuel Tax Fund $18,208 $0 $18,208 $17,515   Collects and spends resources from the   State motor fuel tax. Infrastructure Fund (Major Fund)$445,682 $234,165 $211,517 $196,145   Accounts for construction and maintenance of   roadways, drainage, and safety path systems. Promenade TIF Fund (Major Fund)$144 $223,210 ($223,066) ($223,180)   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)$879,578 $201,037 $678,541 ($2,225)   Collects user fees for the distribution of water   and maintenance of infrastructure. Sports Core Fund (Major Fund)$10,787 $116,621 ($105,833) ($165,510)   Accounts for revenues and expenses relating   to administration, programs, food and beverage   operations, and golf course. Golf Surcharge Fund $758 $0 $758 $290   Accounts for the collection of the $3 per round   golf surcharge. Internal Service Funds Self Insurance Fund $315,903 $73,183 $242,720 ($15,400)   Accounts for the Village's health insurance costs   and the related contributions from the Village,   employees, retirees, and other agencies. Garage Fund $51,410 $47,639 $3,771 ($13,550)   Accounts for the maintenance of the Village's vehicle   fleet and the related departmental reimbursements. Equipment Replacement Fund $30,722 $0 $30,722 ($42,240)   Accounts for the replacement of the Village's vehicle   fleet and the related departmental contributions. Further information on the Village's major funds (as indicated above) can be found on the proceeding pages. Executive Summary on Village Funds Through January 31, 2018 1/31/18 1/31/18 1/31/17 1/31/18 YTD % of 2018 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Sales Tax 1,007,103$       941,951$           969,000$           97% 12,453,000$     (65,152)$            Other Intergovernmental Tax 147,824             105,635             108,200             98% 1,144,700          (42,189)              Telecommunications/Utility Tax 382,787             496,450             483,650             103% 5,792,250          113,663             Licenses and Permits 68,843               668,074             528,845             126% 1,784,070          599,231             Charges for Services 54,326               59,473               75,700               79% 1,017,100          5,147                 Fines and Penalties 10,081               17,734               12,535               141% 150,500             7,653                 Administrative Towing Fees 1,500                 2,000                 2,915                 69% 35,000               500                     Interest on Investments 15,011               23,284               16,250               143% 195,000             8,273                 Franchise/IMF Maint. Fee ‐                      ‐                      ‐                          0% 215,000             ‐                      Reimbursements From Other Funds 51,442               52,421               59,445               88% 713,360             979                     Installment Contract Proceeds ‐                          ‐                          ‐                          0% 2,475,165          ‐                      Miscellaneous Income 19,211               12,609               13,735               92% 180,750             (6,602)                Total Operating Revenues 1,758,128$       2,379,631$       2,270,275$       105% 26,155,895$     621,503$           OPERATING EXPENDITURES Personnel 1,304,757$       1,294,743$       1,410,570$       92% 17,953,350$     (10,014)$            Materials and Supplies 24,308               22,590               47,825               47% 532,820             (1,718)                Operation and Contract 709,784             419,569             585,865             72% 4,278,675          (290,215)            Other Expenditures 10,692               10,943               10,940               100% 388,815             251                     Capital Outlay ‐                      ‐                      261,890             0% 2,997,840          ‐                      Total Operating Expenditures 2,049,541$       1,747,845$       2,317,090$       75% 26,151,500$     (301,696)$         SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES (291,413)$         631,786$           (46,815)$            0% 4,395$               923,199$           INTERFUND TRANSACTIONS Transfers Out ‐$                   ‐$                   ‐$                   0% ‐$                   ‐$                   Total Interfund Transactions ‐$                   ‐$                   ‐$                   0% ‐$                   ‐$                   NET FUND INCREASE (DECREASE)(291,413)$         631,786$           (46,815)$            4,395$               923,199$           Village of Oak Brook General Fund Financial Update For the Period Ending January 31, 2018 Total Total Revenues Expenditures 1/31/18 Actual  $            2,379,631  1,747,845$             1/31/17 Actual  $            1,758,128  2,049,541$             % Change From Last Year 35.4% ‐14.7% Major Revenues Other Intergov. Licenses & Charges for Sales Tax Tax Telecom Tax Permits Services 1/31/18 Actual  $               941,951   $               105,635   $               496,450   $               668,074  59,473                     1/31/17 Actual  $            1,007,103   $               147,824  $               382,787   $                 68,843  54,326                     % Change From Last Year ‐6.5% ‐28.5% 29.7% 870.4% 9.5% Five Year Trend Major Expenditures Materials & Operation & Other Personnel Supplies Contractual Expenditures Capital Outlay 1/31/18 Actual 1,294,743$             22,590$                   419,569$                10,943                     ‐$                         1/31/17 Actual 1,304,757$             24,308$                   709,784$                10,692                     ‐$                         % Change From Last Year ‐0.8% ‐7.1% ‐40.9% 2.3% 0.0% Five Year Trend Expenditures by Department 1/31/17 1/31/18 1/31/18 1/31/18 2018 Difference Five YTD YTD YTD % of Annual Prior Year Department Actual Actual Budget Budget Budget Year Trend Legislative & General Management 461,579$                263,726$                347,905$                75.8% 2,673,305$             (197,853)$               Financial Services 62,559                     64,857                     67,675                     95.8% 1,117,875               2,298                       Public Works 29,472                     30,936                     68,555                     45.1% 993,820                   1,464                       Engineering & Capital Projects ‐                           ‐                           227,725                   0.0% 2,732,665               ‐                           Library 113,245                   61,214                     74,380                     82.3% 889,845                   (52,031)                   Police 733,461                   738,454                   777,925                   94.9% 8,705,350               4,993                       Fire 579,166                   523,277                   679,275                   77.0% 8,043,215               (55,889)                   Development Services 70,059                     65,381                     73,650                     88.8% 995,425                   (4,678)                      Total Expenditures 2,049,541$             1,747,845$             2,317,090$             75.4% 26,151,500$           (301,696)$               Explanation of Major Changes From Last Year: Sales Tax revenue is down $65,152 compared to revenue through January 2017.  This is due to the closure of two taxpayers and general timing of returns.  Total Sales Tax  revenue through January 2018 is $27,049 under budget due to the timing of tax returns. Other Intergovernmental Tax revenue is down $42,189 compared to revenue through January 2017.  This is due to the early receipt of February taxes in 2017. Total Intergovernmental Tax revenue through January 2018 is $2,565 under budget. Telecommunications Tax  revenue is up $113,663 compared to revenue through January 2017.  This is due to the January electricity tax being received during February  in 2017.  Total Telecommunications Tax revenue through January 2018 is $12,800 over budget. Licenses & Permits revenue is up $599,231 compared to collections through January 2017.  This is primarily due to a large construction permit being received in 2018. Total Licenses & Permits revenue through January 2018 is over budget by $139,229.   Personnel expenditures are down $10,014 comapred to payments through January 2017.  This is primarily due to various position eliminations and unsettled contract negotations.  Total Personnel expenditures through January 2018 are $115,827 under budget due to public safety pensions being funded lower than budgeted and  ongoing union negotations. Operation & Contractual expenditures are down $290,215 compared to payments through January 2017.  This is due to the general timing of payments and a decrease in  liability insurance premiums.  Total Operation & Contractual expenditures through January 2018 are $166,296 under budget due to general timing of payments. Five Year Trend For the Period Ending January 31, 2018 General Fund ‐ Five Year Trend Village of Oak Brook Revenues Expenditures 1/31/18 1/31/18 1/31/17 1/31/18 YTD % of 2018 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Hotel Tax 94,982$            71,711$            80,000$            90% 1,340,000$       (23,271)$           Interest 3,187                 5,254                 2,500                 210% 30,000               2,067                 Total Operating Revenues 98,169$            76,965$            82,500$            93.3% 1,370,000$       (21,204)$           EXPENDITURES Operation and Contract 3,210$               ‐$                   49,645$            0% 646,515$          (3,210)$             Other Expenditures 7,783                 8,295                 8,295                 100% 99,550               512                    Capital Outlay ‐                     ‐                     ‐                     0% 640,000            ‐                     Total Expenditures 10,993$            8,295$               57,940$            14.3% 1,386,065$       (2,698)$             NET FUND INCREASE (DECREASE)87,176$            68,670$            24,560$            (16,065)$           (18,506)$           Note ‐ Expenditures are recorded in program 171. Village of Oak Brook Hotel Tax Fund Financial Update For the Period Ending January 31, 2018 Total Total Revenues Expenditures 1/31/18 Actual  $                 76,965 8,295$                    1/31/17 Actual  $                 98,169 10,993$                  % Change From Last Year ‐21.6% ‐24.5% Major Revenues Grants Hotel Tax Interest Miscellaneous 1/31/18 Actual  $                          ‐    $                 71,711   $                   5,254   $                          ‐    1/31/17 Actual  $                          ‐    $                 94,982   $                   3,187   $                          ‐    % Change From Last Year N/A ‐24.5% 64.9% N/A Five Year Trend Major Expenditures Operation & Other Contractual Expenditures Capital Outlay 1/31/18 Actual ‐$                        8,295$                    ‐$                        1/31/17 Actual 3,210$                    7,783$                    ‐$                        % Change From Last Year ‐100.0% 6.6% N/A Five Year Trend Explanation of Major Changes From Last Year: Hotel Tax revenue is down $23,271 compared to collections through January 2017.  This is related to the timing of late receipts in 2017.  Total Hotel Tax revenue through January 2018 is under budget by $8,289 due to the general timing of when receipts have been received compared to expected. Village of Oak Brook Hotel Tax Fund ‐ Major Sources Five Year Trend For the Period Ending January 31, 2018 Five Year Trend Revenues Expenditures 1/31/18 1/31/18 1/31/17 1/31/18 YTD % of 2018 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Sales Tax 466,623$          420,506$          436,500$          96% 5,563,000$       (46,117)$           Grants ‐                     ‐                     ‐                     N/A ‐                     ‐                     Interest 4,087                 10,082               3,500                 288% 42,000               5,995                 Miscellaneous ‐                     ‐                     415                    0% 5,000                 ‐                     Reimbursements From Other Funds 14,720               15,094               15,095               100% 181,130            374                    Total Operating Revenues 485,430$          445,682$          455,510$          98% 5,791,130$       (39,748)$           OPERATING EXPENDITURES Personnel 100,768            113,122$          127,555$          89% 1,365,445$       12,354$            Materials and Supplies 14,452               13,622               21,125               64% 182,955            (830)                   Operation and Contract 191,259            93,682               96,945               97% 1,484,755         (97,577)             Other Expenditures 13,542               13,739               13,740               100% 164,865            197                    Capital Outlay ‐                     ‐                     ‐                     N/A 5,625,620         ‐                     ‐                     Total Operating Expenditures 320,021$          234,165$          259,365$          90% 8,823,640$       (85,856)$           SURPLUS (DEFICIT) OF REVENUES OVER EXPENDITURES 165,409$          211,517$          196,145$          108% (3,032,510)$     46,108$            INTERFUND TRANSACTIONS Transfers In ‐$                   ‐$                   ‐$                   N/A 500,000$          ‐$                   Total Interfund Transactions ‐$                   ‐$                   ‐$                   N/A 500,000$          ‐$                   NET FUND INCREASE (DECREASE)165,409$          211,517$          196,145$          (2,532,510)$     46,108$            Village of Oak Brook Infrastructure Fund Financial Update For the Period Ending January 31, 2018 Total Total Revenues Expenditures 1/31/18 Actual  $              445,682 234,165$               1/31/17 Actual  $              485,430 320,021$               % Change From Last Year ‐8.2% ‐26.8% Major Revenues Sales Tax Grants Interest Miscellaneous Reimbursements 1/31/18 Actual  $              420,506  $                         ‐     $                10,082  $                         ‐     $                15,094  1/31/17 Actual  $              466,623  $                         ‐     $                  4,087   $                         ‐     $                14,720  % Change From Last Year ‐9.9% N/A 146.7% N/A 2.5% Five Year Trend Major Expenditures Materials & Operation & Other Personnel Supplies Contractual Expenditures Capital Outlay 1/31/18 Actual 113,122$               13,622$                 93,682$                 13,739$                 ‐$                        1/31/17 Actual 100,768$               14,452$                 191,259$               13,542$                 ‐$                        % Change From Last Year 12.3% ‐5.7% ‐51.0% 1.5% N/A Five Year Trend Expenditures by Department 1/31/17 1/31/18 1/31/18 1/31/18 2018 Difference Five YTD YTD YTD % of Annual Prior Year Actual Actual Budget Budget Budget Year Trend Legislative & General Management 2,564$                    3,320$                    13,625$                 24.4% 178,530$               756$                       Public Works 310,290                 225,016                 204,460                 110.1% 2,592,335              (85,274)                  Engineering & Capital Projects 7,167                      5,829                      41,280                    14.1% 6,052,775              (1,338)                     Total Expenditures 320,021$               234,165$               259,365$               90.3% 8,823,640$            (85,856)$                Explanation of Major Changes From Last Year: Sales Tax revenue is down $46,117 compared to revenue through January 2017.  This is due to the State's 2% service fee reduction implemented in mid‐2017.  Total  Sales Tax revenue through January 2018 is $15,994 under budget due to the timing of returns filed. Personnel expenditures are up $12,354 compared to payments through January 2017.  This is primarily due to an increase in overtime hours worked compared to last January.  Total Personnel costs through January 2018 are $14,433 under budget due to unsettled contract negotiations. Operation & Contractual expenditures are down $97,577 compared to payments through January 2017.  This is due to a decrease in liability insurance premiums. Total Operation & Contractual expenditures through January 2018 are $3,263 under budget. Five Year Trend Village of Oak Brook Infrastructure Fund ‐ Major Sources Five Year Trend For the Period Ending January 31, 2018 Revenues Expenditures 1/31/18 1/31/18 1/31/17 1/31/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 50                       144                    30                       480% 250                    94                       Total Operating Revenues 50$                    144$                  30$                    480% 487,750$          94$                    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,245)$         (223,066)$         (223,180)$         23,840$            (2,821)$             Note ‐ Expenditures are recorded in program 283. Village of Oak Brook Promenade TIF Fund Financial Update For the Period Ending January 31, 2018 Total Total Revenues Expenditures 1/31/18 Actual  $                      144 223,210$                1/31/17 Actual  $                        50 220,295$                % Change From Last Year 188.0% 1.3% Major Revenues Real Estate Sales Tax Tax Interest 1/31/18 Actual  $                          ‐     $                          ‐     $                      144  1/31/17 Actual  $                          ‐     $                          ‐     $                        50  % Change From Last Year N/A N/A 188.0% Five Year Trend Major Expenditures Operation & Other Contractual Expenditures 1/31/18 Actual ‐$                         223,210$                1/31/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 January 31, 2018 Five Year Trend Revenues Expenditures 1/31/18 1/31/18 1/31/17 1/31/18 YTD % of 2018 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Plan Review Fees 75$                    75$                    165$                  45% 2,000$               ‐$                   Building/Inspection Fees 75                       75                       415                    18% 5,000                 ‐                     Water Sales 821,116            868,029            850,000            102% 9,730,425         46,913               Unmetered Sales ‐                     ‐                     2,500                 0% 30,000               ‐                     Water Connection Fees 2,760                 2,760                 4,150                 67% 50,000               ‐                     Fire Service Charge ‐                     ‐                     415                    0% 5,000                 ‐                     Meter Charges 301                    602                    2,085                 29% 25,000               301                    Special Services ‐                     ‐                     ‐                     0% 30,000               ‐                     Interest on Investments 2,138                 6,539                 835                    783% 10,000               4,401                 Miscellaneous (1,197)                1,498                 4,165                 36% 50,000               2,695                 Total Operating Revenues 825,268$          879,578$          864,730$          102% 9,937,425$       54,310$            EXPENDITURES Personnel 77,768$            69,221$            65,875$            105% 817,490$          (8,547)$             Materials and Supplies 1,202                 5,774                 7,840                 74% 76,860               4,572                 Operation and Contract 83,333               48,214               561,960            9% 6,780,015         (35,119)             Other Expenditures 33,467               33,764               33,765               100% 405,170            297                    Capital Outlay 6,327                 44,064               197,515            22% 2,710,220         37,737               Total Expenditures 202,097$          201,037$          866,955$          23% 10,789,755$    (1,060)$             NET FUND INCREASE (DECREASE)623,171$          678,541$          (2,225)$             (852,330)$         55,370$            Village of Oak Brook Water Fund Financial Update For the Period Ending January 31, 2018 Total Total Revenues Expenditures 1/31/18 Actual  $              879,578 201,037$               1/31/17 Actual  $              825,268 202,097$               % Change From Last Year 6.6% ‐0.5% Unmetered Water Water Sales Sales Connection Fees Meter Charges Miscellaneous 1/31/18 Actual  $              868,029   $                         ‐    $                  2,760   $                      602   $                  1,498  1/31/17 Actual  $              821,116   $                         ‐    $                  2,760   $                      301  $                 (1,197) % Change From Last Year 5.7% N/A 0.0% 100.0% ‐225.1% Five Year Trend Materials & Operation & Other Personnel Supplies Contractual Expenditures Capital Outlay 1/31/18 Actual 69,221$                 5,774$                    48,214$                 33,764$                 44,064$                 1/31/17 Actual 77,768$                 1,202$                    83,333$                 33,467$                 6,327$                    % Change From Last Year ‐11.0% 380.4% ‐42.1% 0.9% 596.4% Five Year Trend Expenditures by Department 1/31/17 1/31/18 1/31/18 1/31/18 2018 Difference Five YTD YTD YTD % of Annual Prior Year Actual Actual Budget Budget Budget Year Trend Public Works 202,097$               156,972$               664,855$               23.6% 8,124,535$            (45,125)$                Engineering & Capital Projects ‐                          44,065                    195,850                 0.0% 2,665,220              44,065                    Total Expenditures 202,097$               201,037$               860,705$               23.4% 10,789,755$         (1,060)$                  Explanation of Major Changes From Last Year: Water Sales revenue is up $46,913 compared to collections through January 2017.  This is due to a 7% rate increase adopted January 1, 2018.  Total Water Sales  revenue through January 2018 is over budget by $18,029 due to gallons billed being slightly higher than projected. Operation & Contractual expenditures are down $35,119 compared to payments through January 2017.  This is due to a reduction in liability insurance premiums. Operation & Contractual expenditures through January 2018 are under budget by $513,746 due to the timing of bills being paid to the timing of invoices being paid. Capital Outlay expenditures are up $37,737 compared to payments through January 2017.  This is due to the start of the water meter replacement project.  Capital  Outlay expenditures through January 2018 are under budget by $153,451 due to general timing of invoices. Five Year Trend Village of Oak Brook Water Fund ‐ Major Sources Five Year Trend For the Period Ending January 31, 2018 Revenues Expenditures Village of Oak BrookMonthly Operating StatementSports Core Fund Consolidated PresentationFor the Period Ending January 31, 20181/31/18 1/31/181/31/18 YTD % of 2018 1/31/17 DifferenceB&T Recreation Food & Golf YTD Amended Amended Adopted YTD PriorPrograms Beverage Club Total Budget Budget Budget Total YearDIRECT REVENUESMemberships ‐$                     ‐$                     ‐$                     ‐$                     100$                     0% 414,875$            ‐$                     ‐$                    Greens Fees ‐                       ‐                        (129)                     (129)                     ‐                        0% 975,000               ‐                        (129)                    Pro Shop Sales ‐                       ‐                        1,396                   1,396                   ‐                        0% 200,000               (81)                        1,477                  Golf Lessons ‐                       ‐                        ‐                        ‐                        ‐                        0% 40,000                 ‐                        ‐                       Driving Range Fees ‐                       ‐                        ‐                        ‐                        ‐                        0% 235,000               740                       (740)                    Rentals ‐                       ‐                        ‐                        ‐                        10,000                 0% 451,000               ‐                        ‐                       Programs/User Fees 1,550                   ‐                        ‐                        1,550                   ‐                        0% 300,700               1,625                   (75)                       Food Sales ‐                       ‐                        ‐                        ‐                        ‐                        0% 145,500               ‐                        ‐                       Beverage Sales ‐                       ‐                        ‐                        ‐                        ‐                        0% 236,000               ‐                        ‐                       Other Revenue (173)                     5,079                   397                       5,303                   7,320                   72% 380,650               251                       5,052                  Total Direct Revenues1,377$                 5,079$                 1,664$                 8,120$                 17,420$               47% 3,378,725$         2,535$                 5,585$                DIRECT EXPENDITURESPersonnel 2,262$                 7,944$                 43,803$               54,009$               70,960$               76% 1,497,200$         57,518$               (3,509)$               Materials & Supplies ‐                       143                       9,009                   9,152                   855                       1070% 615,885               161                       8,991                  Operational & Contractual 23,182                 901                       29,377                 53,460                 104,970               51% 961,510               111,510               (58,050)               Other ‐                       ‐                        ‐                        ‐                        8,810                   0% (44,275)                ‐                        ‐                       Capital ‐                       ‐                        ‐                        ‐                        ‐                        0% 365,660               ‐                        ‐                       Total Direct Expenditures25,444$              8,988$                 82,189$               116,621$            185,595$            63% 3,395,980$         169,189$            (52,568)$            Direct Revenues Over (Under) Expenditures(24,067)$             (3,909)$                (80,525)$             (108,501)$           (168,175)$           65% (17,255)$             (166,654)$           58,153$              B&T Administration Overhead Allocation* 13,335$              (13,334)$             ‐$                     1$                         ‐$                     0% ‐$                     ‐$                     1$                        Operating Revenues Over (Under) Expenditures(10,732)$             (17,243)$             (80,525)$             (108,500)$           (168,175)$           65% (17,255)$             (166,654)$           58,154$              Interfund Loan** ‐$                     ‐$                     ‐$                     ‐$                     ‐$                     0% ‐$                     ‐$                     ‐$                    Transfer From General Fund ‐                       ‐                        ‐                        ‐                        ‐                        0% ‐                        ‐                        ‐                       Transfer From Infrastructure Fund 2,000                   ‐                        ‐                        2,000                   2,000                   100% 24,000                 2,000                   ‐                       Transfer From Water Fund 667                      ‐                        ‐                        667                       665                       100% 8,000                   667                       ‐                       Transfer From Golf Surcharge Fund ‐                       ‐                        ‐                        ‐                        ‐                        0% ‐                        ‐                        ‐                       Adjusted Operating Revenues Over (Under) Expenditures(8,065)$               (17,243)$             (80,525)$             (105,833)$           (165,510)$           14,745$               (163,987)$           58,154$              *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 1/31/18 Actual  $                   8,120 116,621$                1/31/17 Actual  $                   2,535 169,189$                % Change From Last Year 220.3% ‐31.1% Driving Program/ Memberships Greens Fees Range Fees Rentals User Fees 1/31/18 Actual  $                         ‐     $                    (129)  $                         ‐     $                         ‐     $                   1,550  1/31/17 Actual  $                         ‐     $                         ‐     $                      740   $                         ‐     $                   1,625  % Change From Last Year N/A 0.0% ‐100.0% N/A ‐4.6% Five Year Trend Materials & Operation & Other Personnel Supplies Contractual Expenditures Capital Outlay 1/31/18 Actual 54,009$                  9,152$                    53,460$                  ‐$                        ‐$                        1/31/17 Actual 57,518$                  161$                       111,510$                ‐$                        ‐$                        % Change From Last Year ‐6.1% 5584.5% ‐52.1% N/A N/A Five Year Trend Revenues by Department 1/31/17 1/31/18 1/31/18 1/31/18 2018 Difference Five YTD YTD YTD % of Annual Prior Year Actual Actual Budget Budget Budget Year Trend B&T Recreation Programs 1,871$                    1,377$                    646,495$                0.2% 712,075$                (494)$                      Food & Beverage ‐                          5,079                      127,800                  4.0% 569,000                  5,079                      Golf Club 664                          1,664                      567,997                  0.3% 2,097,650               1,000                      Total Revenues 2,535$                    8,120$                    1,342,292$            0.6% 3,378,725$            5,585$                    Expenditures by Department 1/31/17 1/31/18 1/31/18 % of 2018 Difference Five YTD YTD YTD % of Annual Prior Year Actual Actual Budget Budget Budget Year Trend B&T Recreation Programs 59,969$                  25,444$                  344,363$                7.4% 1,058,430$            (34,525)$                Food & Beverage 7,672                      8,988                      281,968                  3.2% 514,980                  1,316                      Golf Club 101,548                  82,189                    778,751                  10.6% 1,822,570               (19,359)                   Total Expenditures 169,189$                116,621$                1,405,082$            8.3% 3,395,980$            (52,568)$                Explanation of Major Changes From Last Year: Operation & Contractual expenditures are down $58,050 compared to expenditures through January 2017.  This is due to a decrease in liability insurance premiums. Total Operation & Contractual expenditures through January 2018 is $51,510 under budget due to a general timing of payments. Five Year Trend Village of Oak Brook Sports Core Fund ‐ Major Sources Five Year Trend For the Period Ending January 31, 2018 Revenues Expenditures Village of Oak BrookMonthly Operating StatementBath & Tennis Club Recreation ProgramsFor the Period Ending January 31, 20181/31/18 1/31/181/31/18 YTD % of 2018 1/31/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 ‐$                    ‐$                    ‐$                    ‐$                    ‐$                    ‐$                    100$                   0% 223,375$           ‐$                    ‐$                   Programs/User Fees ‐                      ‐                      ‐                      ‐                      1,550                 1,550                 ‐                      N/A 300,700             1,625                 (75)                     Beverage Sales ‐                      ‐                      ‐                      ‐                      ‐                      ‐                      ‐                      N/A ‐                      ‐                      ‐                     Other Revenue (173)                    ‐                      ‐                      ‐                      ‐                      (173)                    1,320                 ‐13% 188,000             246                     (419)                   Total Revenue(173)$                 ‐$                    ‐$                    ‐$                    1,550$               1,377$               1,420$               97% 712,075$           1,871$               (494)$                Expenditures:Personnel 2,262$               ‐$                    ‐$                    ‐$                    ‐$                    2,262$               10,905$             21% 208,040$           10,210$             (7,948)$             Materials & Supplies ‐                      ‐                      ‐                      ‐                      ‐                      ‐                      250                     0% 28,280               ‐                      ‐                     Operational & Contractual 22,258               802                     ‐                      ‐                      122                     23,182               48,040               48% 586,160             49,759               (26,577)             Other ‐                      ‐                      ‐                      ‐                      ‐                      ‐                      4,680                 0% 56,200               ‐                      ‐                     Capital ‐                      ‐                      ‐                      ‐                      ‐                      ‐                      ‐                      N/A 179,750             ‐                      ‐                     Total Expenditures24,520$             802$                   ‐$                    ‐$                    122$                   25,444$             63,875$             40% 1,058,430$       59,969$             (34,525)$          Direct Revenues Over (Under) Expenditures(24,693)$           (802)$                 ‐$                    ‐$                    1,428$               (24,067)$           (62,455)$           39% (346,355)$         (58,098)$           34,031$            B&T Administration Overhead Allocation* 24,693$             (8,889)$              (2,469)$              ‐$                    ‐$                    13,335$             32,645$             41% 207,995$           32,200$             (18,865)$          Revenues Over (Under) Expenditures‐$                    (9,691)$              (2,469)$              ‐$                    1,428$               (10,732)$           (29,810)$           36% (138,360)$         (25,898)$           15,166$            Interfund Loan** ‐$                    ‐$                    ‐$                    ‐$                    ‐$                    ‐$                    ‐$                    0% ‐$                    ‐$                    ‐$                   Transfer From General Fund ‐                      ‐                      ‐                      ‐                      ‐                      ‐                      ‐                      N/A ‐                      ‐                      ‐                     Transfer From Infrastructure Fund 2,000                 ‐                      ‐                      ‐                      ‐                      2,000                 2,000                 100% 24,000               2,000                 ‐                     Transfer From Water Fund 667                     ‐                      ‐                      ‐                      ‐                      667                     665                     100% 8,000                 667                     ‐                     Adjusted Revenues Over (Under) Expenditures2,667$               (9,691)$              (2,469)$              ‐$                    1,428$               (8,065)$              (27,145)$           (106,360)$         (23,231)$           15,166$            *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 January 31, 20181/31/18 1/31/18821 822 823 1/31/18 YTD % of 2018 1/31/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              ‐                      ‐                     Beverage Sales ‐                      ‐                      ‐                      ‐                      ‐                      N/A 236,000              ‐                      ‐                     Other Revenue 5,079                  ‐                      ‐                      5,079                  6,000                  85% 187,500              ‐                      5,079                 Total Revenue5,079$                ‐$                    ‐$                    5,079$                6,000$                85% 569,000$           ‐$                    5,079$               Expenditures:Personnel 6,863$                ‐$                    1,081$                7,944$                11,190$              71% 199,505$           5,492$                2,452$               Materials & Supplies 294                     ‐                      (151)                    143                     505                     28% 182,150              ‐                      143                    Operational & Contractual 645                     ‐                      256                     901                     8,225                  11% 133,325              2,180                  (1,279)                Capital ‐                      ‐                      ‐                      ‐                      ‐                      N/A ‐                      ‐                      ‐                     Total Expenditures7,802$                ‐$                    1,186$                8,988$                19,920$              45% 514,980$           7,672$                1,316$               Direct Revenues Over (Under) Expenditures(2,723)$              ‐$                    (1,186)$              (3,909)$              (13,920)$            28% 54,020$              (7,672)$              3,763$               B&T Administration Overhead Allocation* (12,346)$            (988)$                  ‐$                    (13,334)$            (32,645)$            41% (175,995)$          (32,200)$            18,866$             Revenues Over (Under) Expenditures(15,069)$            (988)$                  (1,186)$              (17,243)$            (46,565)$            37% (121,975)$          (39,872)$            22,629$             Transfer From General Fund ‐$                    ‐$                    ‐$                    ‐$                    ‐$                    0% ‐$                    ‐$                    ‐$                   Adjusted Revenues Over (Under) Expenditures(15,069)$            (988)$                  (1,186)$              (17,243)$            (46,565)$            (121,975)$          (39,872)$            22,629$             *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 January 31, 20181/31/18 1/31/18831 832 833 834 1/31/18 YTD % of 2018 1/31/17 DifferenceGolf General Golf Learning Golf Cart Golf Course YTD Amended Amended Adopted YTD PriorOperation & Practice Operations Maintenance Total Budget Budget BudgetTotal YearRevenues:Memberships ‐$                    ‐$                    ‐$                    ‐$                    ‐$                    ‐$                    N/A 191,500$           ‐$                    ‐$                   Greens Fees (129)                    ‐                      ‐                      ‐                      (129)                    ‐                      N/A 975,000             ‐                      (129)                   Pro Shop Sales 1,396                  ‐                      ‐                      ‐                      1,396                  ‐                      N/A 200,000             (81)                      1,477                 Golf Lessons ‐                      ‐                      ‐                      ‐                      ‐                      ‐                      N/A 40,000                ‐                      ‐                     Driving Range Fees ‐                      ‐                      ‐                      ‐                      ‐                      ‐                      N/A 235,000             740                     (740)                   Rentals ‐                      ‐                      ‐                      ‐                      ‐                      10,000                0% 451,000             ‐                      ‐                     Other Revenue 397                     ‐                      ‐                      ‐                      397                     ‐                      N/A 5,150                  5                          392                    Total Revenue1,664$                ‐$                    ‐$                    ‐$                    1,664$                10,000$             17% 2,097,650$        664$                   1,000$               Expenditures:Personnel 28,616$             ‐$                    154$                   15,033$             43,803$             48,865$             90% 1,089,655$        41,816$             1,987$               Materials & Supplies 5,586                  ‐                      ‐                      3,423                  9,009                  100                     9009% 405,455             161                     8,848                 Operational & Contractual 23,908                ‐                      200                     5,269                  29,377                48,705                60% 242,025             59,571                (30,194)             Other ‐                      ‐                      ‐                      ‐                      ‐                      4,130                  0% (100,475)            ‐                      ‐                     Capital ‐                      ‐                      ‐                      ‐                      ‐                      ‐                      N/A 185,910             ‐                      ‐                     Total Expenditures58,110$             ‐$                    354$                   23,725$             82,189$             101,800$           81% 1,822,570$        101,548$           (19,359)$           Direct Revenues Over (Under) Expenditures(56,446)$            ‐$                    (354)$                  (23,725)$            (80,525)$            (91,800)$            88% 275,080$           (100,884)$          20,359$            Transfer from General Fund ‐$                    ‐$                    ‐$                    ‐$                    ‐$                    ‐$                    0% ‐$                    ‐$                    ‐$                   Adjusted Revenues Over (Under) Expenditures(56,446)$            ‐$                    (354)$                  (23,725)$            (80,525)$            (91,800)$            275,080$           (100,884)$          20,359$