Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
01 - January 2017 Monthly Financial Report
VILLAGE 1019 OAK BROOK MONTHLY FINANCIAL REPORTS JANUARY 2017 y Monthly Treasurer's Report January 31, 2017 Total Cash and Cash Pooled Cash and Fund Equivalents Investments Investments General Corporate $3,665,168.62 $12,463,658.80 $16,128,827.42 Hotel/Motel Tax 2,489,375.68 1,878,521.36 4,367,897.04 Motor Fuel Tax 448,489.51 480,836.33 929,325.84 TIF#1 Butterfield/Meyers 29,033.10 0.00 29,033.10 Water 1,879,764.55 1,062,031.12 2,941,795.67 Self -Insurance 800,050.24 0.00 800,050.24 Sports Core 83,727.40 0.00 83,727.40 Golf Surcharge 0.00 436,561.78 436,561.78 Equipment Replacement 329,016.28 1,030,475.46 1,359,491.74 Infrastructure 3,001,638.69 2,551,327.79 5,552,966.48 Garage 351,679.57 0.00 351,679.57 Total $13,077,943.64 $19,903,412.64 $32,981,356.28 Change in Cash and Investments by Fund : Batance at Balance at Year -to -Date Year -to -Date Fund January 1, 2017 January 31, 2017 Change ($) Change (%) General Corporate Hotel/Motel Tax Motor Fuel Tax TIF #1 Butterfield/Meyers Water Self -Insurance Sports Core Golf Surcharge Equipment Replacement Infrastructure Garage Pooled Checking Sports Core Checking Pooled IPTIP Water E -Pay IPTIP Pooled Investments: $16,538,208.01 $16,128,827.42 ($409,380.59) -2.5% 4,408,534.69 4,367,897.04 (40,637.65) -0.9% 908,177.41 929,325.84 21,148.43 2.3% 249,277.74 29,033.10 (220,244.64) -88.4% 2,727,962.05 2,941,795.67 213,833.62 7.8% 589,849.32 800,050.24 210,200.92 35.6% 268,828.44 83,727.40 (185,101.04) -68.9% 430,983.30 436,561.78 5,578.48 1.3% 1,505,717.99 1,359,491.74 (146.22625) -9.7% 5,426,436.04 5,552,966.48 126,530.44 2.3% 347,053.40 351,679.57 4,626.17 1.3% $33,401,028.39 $32,981,356.28 ($41961211) -1.3% Certificates of Deposit Investments -Municipal Investments -Corporate Government & Agency Obligations Accrued Interest Total Pooled Investments Total Cash and Investments For January, total interest revenue is $27,490. Total investment yield for the portfolio is: Book Market Value Value $1,545,669.53 $1,545,669.53 87,209.19 87,209.19 11,407,138.00 11,407,138.00 37,926.92 37,926.92 $13,077,943.64 $13,077,943.64 $4,900,000.00 $4,903,936.00 8,446,603.50 8,424,733.00 3,662,351.23 3,659,314.00 2,817,013.62 2,792,898.00 77,444.29 77,444.29 $19,903,412.64 $19,858,325.29 $32,981,356.28 $32,936,268.93 Pooled Investments Illinois Funds Total Monthly yield 0.10% 0.06% 0.09% Last 12 months yield 1.19% 0.40% 0.92% The weighted average yield of the pooled investment portfolio is 1.45%. Monthly Treasurer's Report January 2017 The table below lists the detail investment holdings at J.P. Morgan Securities as of 1/31/17 '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. Month End VOB Settlement Maturity Coupon Yield Book Market Accrued Type Date Date Rate Rate Value Value Interest Municipal Bonds: Illinois St. Sales #452227JF9 03/13/14 6/15/2017 1.170% 1.170% $500,213 $500,010 $746 Public Utility District #181117EP3 09102/14 1/1/2018 1.667% 1.650% 601,722 601,890 878 Florida Hurricane#34074GDG6 01/05/15 7/1/2018 2.107% 2.090% 753,205 755,828 1,303 Grundy Kendall & Will Co. #400424KG1 02/12/15 5/1/2017 1.422% 1.410% 1,000,806 999,870 3,431 Cmniy Cons Sch Dist No 47 #581000PG5 02/25/15 2/1/2017 3.890% 3.710% 495,000 495,000 9,607 Sturgeon Bay Wisc. #864048JZ7 06/11/15 4/1/2017 1.250% 1.048% 500,166 500,035 2,061 Maryland St Econ Dev #57420PGK6 07/08/15 6/1/2019 2.050% 2.123% 99,833 101,018 340 Du Page County IL #263493TN8 07/20/15 10/1/2017 4.850% 1.200% 512,155 511,260 7,874 Hidalgo County Tex Ltd Tax #429326W W7 10/14/15 8/15/2017 1.291% 1.263% 850,121 849,779 5,053 Rosemont IL GO Corp #777543UT4 02/08/16 12/1/2019 3.021% 2.000% 513,994 510,190 2,422 New York St Urban Dev Corp #650035,158 02/22/16 3/15/2018 1.650% 1.150% 175,972 175,523 1,082 New York N Y City #6497107X1 02/22116 5/1/2021 2.350% 2.000% 202,834 198,800 1,161 Florida Hurricane #34074GDH4 03/30/16 7/1/2020 2.995% 2.150% 513,818 513,845 1,247 Bloomingdale Mich Pub Sch Dist #094383FS0 04/26/16 5/1/2022 2.710% 2.150% 513,828 502,435 3,348 Milan Mich Area Achs#598801JD1 05/26/16 5/1/2020 1.931% 1.931% 245,000 242,462 1,182 Indiana Ed Bk Rev Taxable #4546248F7 01/06/17 1/15/2020 2.934% 1.900% 262,536 262,364 346 North Carolina Eastn Mun PWR #6581 9WAC7 01/30/17 7/1/2018 2.003% 1.450% 705,401 704,424 1,168 Total Municipal Bonds $8,446,604 $8,424,733 $43,249 Corporate Bonds: Wachovia#929903DT6 09/22/16 6/15/2017 5.750% 1.183% $1,050,549 $1,049,848 $7,407 American Express#0258MODM8 10/13/16 6/5/2017 1.125% 1.001% 1,595,671 1,595,016 2,779 National City Bank #63534PAG2 10/20/16 6/7/2017 5.800% 1.160% 1,016,131 1,014,450 8,676 Total Corporate Bonds $3,662,351 $3,659,314 $18,861 Government & Agency Obligations: 'Government National Mtg Assn #38379UEM4 02/29/16 2/16/2051 2.300% 2.245% $967,014 $948,825 $2,202 Fed Home Loan Mtg Corp #3134G9HS9 05/27/16 5/25/2018 0.750% 0.750% 500,000 499,185 688 Fed Home Loan Mtg Corp #3134G9UV7 06/28/16 6/28/2019 0.750% 0.750% 500,000 498,460 333 Fed Home Loan Bank #3130A9HF1 09/30/16 9/30/2019 0.750% 1.280% 600,000 597,618 375 Fed Home Loan Mtg Corp #3314GALU6 09/30/16 9/30/2019 0.800% 1.852% 250,000 248,810 667 Total Government & Agency Obligations: $2,817,014 $2,792,898 $4,264 Certificates of Deposit: First Kentucky Bank #32065TAH4 07/10/14 5/25/2017 1.00% 1.01% $245,000 $245,265 $30 Capital One Bank #140420PP9 09/23/14 10/2/2017 1.35% 1.36% 245,000 245,537 1,103 Goldman Sachs Bank #38148JNW7 03/17/15 9/25/2017 1.15% 1.15% 245,000 245,632 974 Compass Bank #20451 PMB9 06/30/15 6/30/2017 1.05% 1.05% 245,000 245,380 214 American Express #02587DZK7 07/01/15 7/3/2017 1.15% 1.15% 245,000 245,323 215 Capital One Nat Assn VA #14042E5Z9 08/26/15 8/27/2018 1.75% 1.75% 245,000 246,847 2,278 FirstBank PR Santurce #33767ANR8 08/31/15 8/31/2017 1.30% 1.30% 245,000 245,811 (14) Needham Co -Operative Bk #63983RAS8 10/07/15 10/10/2017 1.05% 1.05% 245,000 245,688 808 BMO Harris #05573J5A8 10/07/15 10/10/2017 1.10% 1.10% 245,000 245,671 846 Ally Bk Midvale Utah #02006LVC4 10/29/15 10/29/2018 1.60% 1.60% 245,000 246,757 980 Everbank Jacksonville 929976DD23 10/30/15 10/30/2017 1.05% 1.05% 245,000 245,412 643 Wax Bank Midvale Utah #92937CDY1 07/29/16 7/30/2018 1.00% 1.00% 245,000 244,537 4 Bank Hope Los Angeles #062683AB3 08/26/16 8/27/2018 1.00% 1.00% 245,000 243,920 21 Wells Fargo Bank Nail Assn #949763AL0 08/31/16 8/31/2018 1.10% 1.10% 245,000 243,939 1 BMW Bank#05580AFG4 09/23/16 9/24/2016 1.10% 1.10% 245,000 243,773 951 Comenity Cap Bank #20033ASB3 09/26/16 9/26/2018 1.10% 1.10% 245,000 243,753 27 Enerbank #29266N4E4 10/21/16 10/22/2018 1.10% 1.10% 245,000 244,309 749 Discover Bank #2546721-71 10/26/16 10/26/2018 1.20% 1.20% 245,000 243,581 776 Bank of Baroda #060620X76 11/30/16 11/30/2017 0.95% 0.95% 245,000 245,123 388 State Bk India NY #8562846A7 01/26/17 1/26/2022 2.25% 2.25% 245,000 247,678 77 Total Certificates of Deposits $4,900,000 $4,903,936 $11,070 Total J.P.Morgan Securities $19,82_5,968 $19,780,881 $77,444 '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, 2017 Cash & Investments by Fund - Total $33.0 million Equipment Replacement Garage 4.12% Infrastructure 1.07% 16.84% Golf Surcharge 1.32% Sports Core _ 0.25% Self -Insurance 2.43% Water 8.92% TIF #1 �,,— Hotel/Motel Tax Field/Meyers Motor Fuel Tax 13.24% 0.09% 2.82% Cash & Investments by Type - Total $33.0 million Corporate Bonc Municipal Bonds, Accrued Interest, $0.1 General Corporate 48.90% $4.9 Illinois Funds, $11.5 in millions Executive Summary on Major Funds Through January 31, 2017 Infrastructure Corporate Fund Hotel Fund Fund Water Fund Sports Core Fund •Actual a Budget aARual • Budge[ aAc[ual •Budget •Actual •Budget •Actual a 9udget I" k,...R I" --N- Revenues Expenses Revenues Expenses Revenues Expenses Revenues Expenses Revenues Expenses Net Fund Increase YTD Revenues Expenditures Decrease Budaet General Fund 1,758,128 $2,049,541 ($291,413) ($198,060) Main operating fund of the Village. Hotel Fund $98,169 $10,993 $87,176 $2,170 Collects and spends resources from the 3% hotebmotel tax. Infrastructure Fund $485,430 $320,021 $165,409 $209,600 Accounts tar construction and maintenance of roadways, drainage, and safety path systems. YTD Revenues Expenses Profiti(Lossl Budget Water Fund $825,268 $202,097 $623,171 $136,205 Co//acts user fees for the dishibution of water and maintenance ofinfrastructure. Sports Core Fund $5,656 $193,094 ($187,438) ($154,915) Accounts for revenues and expenses relating to administration, programs, food and beverage operations, and got/course. Sports Core Fund by Division: Sports Core General Operation' $2,873 $5,281 ($2,408) ($11,525) Golf $664 $112,308 ($111,644) ($101,225) Golf Improv. -Surcharge $454 $5,230 ($4,776) $210 Tennis $0 $6,160 ($6,160) ($2,795) Swimming $0 $23,729 ($23,729) ($9,920) Open Space $1,665 $59 $1,606 $1,005 Food 8 Beverage $0 $40,327 ($40,327) ($30,665) Polo $0 $0 $0 $0 Total Sports Core $5,656 $193,094 ($187,438) ($154,915) Overall, the Village has experienced a net fund increase and profit in all major funds except the General Fund and Sports Core Fund through January 2017. Village of Oak Brook Corporate Fund Financial Update For the Period Ending January 31, 2017 SURPLUS <DEFICIT> AFTER DEDUCTING OPERATING EXPENSES 151,723 (332,163) (238,810) (344975) (483886) Reimbursements From Other Funds 52,335 51,442 51,440 100% 617,300 (893) Reimbursements To Other Funds (10,885) (10,892) (10,690) 100% (128,300) 193 Transfers Out - - - 0% (73,505) - Interfund Loan (100.000) - - 0% - 100.000 Total lnterfund Transactions (58,550) 46750 0.750 100% 415,495 99,300 NET FUND INCREASE (DECREASE) 93,173 (291,413) (198,060) 70.520 1384,585) 1131117 1131117 1131116 1131117 YTD %of 2017 Difference YTD YTD Amended Amended Adapted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES General Sales Tax 994,739 1,007,103 99(1,715 101% 13,048,000 12,364 Other Intergovernmental Tax 167,441 147,824 149,340 99% 1,265,235 (19,617) Telecommunirations/Utilily Tax 462,890 382,787 463,445 83% 5,638,000 (80,103) Licenses and Permits 191,318 68,843 297,195 23% 1,711,750 (122,475) Charges for Services 78,913 54,326 75,475 72% 1,006750 (24,587) Fines and Penalties 8,741 10,081 12,790 79% 153,590 1,340 Administrative Towing Fees 2.000 1.500 4,165 36% 50,000 (500) Intereston Investments 9,326 15,011 10,415 144% 125,000 5,665 FranchisellMF - - - 0% 207,200 - Miscellaneous Income 12,140 19,211 17,995 107% 231,675 7,071 Total Operating Revenues 1,927,508 1,706,888 2,027,535 84% 23,437,200 (220,822) OPERATING EXPENDITURES Personnel 1.230,496 1,304,757 1.418,405 92% 17,788,210 74,261 Materials and Supplies 5,933 24,308 41,445 59% 554,530 18,375 Operation and Contract 539,356 709,784 736.980 96% 4,344,325 170,428 011ier Expenditures - - - 0% 289,800 Capital Outlay 69,515 0% 805,310 Total Operating Expenditures 1,775,785 2,038.849 2,266345 90% 23,782,175 263,064 SURPLUS <DEFICIT> AFTER DEDUCTING OPERATING EXPENSES 151,723 (332,163) (238,810) (344975) (483886) Reimbursements From Other Funds 52,335 51,442 51,440 100% 617,300 (893) Reimbursements To Other Funds (10,885) (10,892) (10,690) 100% (128,300) 193 Transfers Out - - - 0% (73,505) - Interfund Loan (100.000) - - 0% - 100.000 Total lnterfund Transactions (58,550) 46750 0.750 100% 415,495 99,300 NET FUND INCREASE (DECREASE) 93,173 (291,413) (198,060) 70.520 1384,585) ExpeMNurn ev DepannaN VIIia,vad aMBraN CorygrMa Fund -Fhe Your Tmtl For Ma Pedal Fueling January 31, 2011 1131111 Tand Tonal 2W7 DMemnw Revenues Ex,enNrums Five Year Trend 1/3111n 8 1,]-8,688 $ $09&689 191116Mual $ 1,927,6OB $ 1. 5,785 Acted %Cem9e Frwn In your -11.5% 18.8% Year Lgislalive& GeneRl Ndn3gemenl �Mwnua �FxpMnures Malor Mevmrma 538..111 qMr 203255 $ 99.868 —Trend I — Mlergwemmmw uomee.a cnarr« 51,687 aware ra ra.wmlm wmdm 6ervdiw 1131117Mual S 1.0117.103 $ 147.826 $ %2,761 $ W.583 54,926 1r31118MUN f 998.139 $ 167,441 3 8821893 $ 191,318 10,913 % Claude F. 1,51 Year 1.2% dt]% d73% 89.0% 512% F Year Tmntl 66.fA0 8-de—e-'e"IF ✓� ♦ 1 MI Emanmmm \� LISmry 52,955 113.2Q5 11980.5 Mabrlal Og IDNer Wad) PBFeatured!8umlle d ., centracNEapmElmma CmI1L Outlry ]33A81 $ 1,m4,r57 $ NXII $ '09 16$ - $ - r1/11Pclual Wit'Aival 8 1.230A98 $ .W3 $ 539.356 $ % Change From bat Year fi3Oe1 309.�iv 316% 00% .. Year Tmnd / / 1 / t ---l/\ V ExpeMNurn ev DepannaN 1131116 1131111 1131117 S.a 2W7 DMemnw Five Y)8 Z. ol Inner Y. Acted Z. %.Mnu& Year Lgislalive& GeneRl Ndn3gemenl $ 361.]35 $ 861.6n $ 538..111 66.8%$ 203255 $ 99.868 —Trend I — Flnanmal8—as 80.781 51,687 58.500 8&5% 988.185 (8,674) Pude Wale 18,8W 29072 32,9)0 66.8% ...D 10.623 ,e ✓`J _A Enyneeing& Cautal PmjeGs - 66.fA0 0656 372,W0 \� LISmry 52,955 113.2Q5 11980.5 95.]% 989.0]0 Wad) /�--F J Pullin, W2]91 ]33A81 288220 fee," 0509255 649'82 a✓` Five 588,606 5]9.lae 818,985 939% 'um".100 3215% CanmuMry eMopment 82,tfl 20.059 22,815 96.2% ada.110 ],988 ✓ Y 1II� Total EapenJlmm $ 1.]1$,]85 3 2,...449 $ 2266,385 90.0%$ 23,252.175 $ ... — , Trialmmnues W$V04686amtt5%b rthan Lastymx TTa overall decrease In mvenuas k pnnvedy due to 0%re9aee in gMrIMergommmeMal Tm(A1]%) Telencm Tax OT3%). Llaensaz & PormN (E8.0%), and Charges 1a 8enlws 01.2%) sa npareed m lan yser. Th'c in aXset M, increase¢ in mapr soumm awn ry Sales Tex(1.2%) aompem0 m bat }ear. 1Tmuyi January, total rerenua are $3211.&9 un0erbuyel. Total ementlimrea W$ 2.03&880 ave 18.8% never Nan We year. Eavear lturas expminwE an incrmw In le.anel(8.0%). Maeneb&3u0Wba(309.?%). and Cwml n & C -..-ll (318%) somwmE blurt year. TTmu9n January, total ananEiWms em=7r4 6 under MOW Village of Oak Brook Hotel Fund Financial Update For the Period Ending January 31, 2017 EXPENDITURES Operation and Contract - 3,210 49,660 6% 595,975 3,210 Other Expenditures 7,525 7,783 7,780 100% 93,400 258 Capital Outlay - - 0% 1,837,500 - Total Expenditures 7,525 10,993 1/31/17 1/31/17 3,468 1131116 1131117 YTD % of 2017 Difference 2,170 YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year OPERATING REVENUES Hotel/Motel Tax 49,457 94,982 57,780 164% 1,266,000 45,525 Interest 2,601 3,187 1,830 174% 22,000 586 Total Operating Revenues 52,058 98,169 59,610 165% 1,268,000 46,111 EXPENDITURES Operation and Contract - 3,210 49,660 6% 595,975 3,210 Other Expenditures 7,525 7,783 7,780 100% 93,400 258 Capital Outlay - - 0% 1,837,500 - Total Expenditures 7,525 10,993 57,440 19% 2,526,875 3,468 NET FUND INCREASE (DECREASE) 44,533 87,176 2,170 (1,238,875) 42,643 Note - Expenditures are recorded in program 171. Village of Oak Brook Hotel Fund - Major Sources Five Year Trend Forth. Period Ending January 31, 2017 Total Total Revenues Expenditures Five Year Trend 1/31/17Actual $ 98,169 $ 10,993 1/31/16Actual $ 52,058 $ 7,525 %Change From Last Year 88.6% 46.1% �Revenues —FExpenERures Major Revenues Grants Hotel/Motel To. Interest Miscellaneous 1/31117 Actual $ - $ 94,982 $ 3,187 $ 1131116 Actual $ - $ 49,457 $ 2,601 $ - %ChangeFromLastYear 0.0% 92.0% 22.5% 0.0% Five Year Trend W �• Major Expenditures Operation& Other Contractual Expenditures Capital Outlay 1/31/17 Actual $ 3,210 $ 7,783 $ - 1/31/16 Actual $ - $ 7,525 $ - % Change From Last Year 100.00% 3.4% 0.0% Five Year Trend / Total revenues of $98,169 are 88.6% higher than last year. The increase in total revenues is due to an increase in Hotel/Motel Tax (92.0%) and Interest (22.5%) compared to last year. Through January, total revenues are $38,559 over budget. Total expenditures of $10,993 are 46.1% higher than last year. The increase in expenditures is due to an increase in Operation & Contractual (100.0%) and Other Expenditures (3.49/6) compared to last year. Through January, total expenditures are $46,447 under budget. Village of Oak Brook Infrastructure Fund Financial Update For the Period Ending January 31, 2017 Sales Tax 457,292 1131117 1131117 102% 5,982,000 1131116 1131117 YTD %of 2017 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budget Year Sales Tax 457,292 466,623 456,100 102% 5,982,000 9,331 Interest 2,970 4,087 2,290 178% 27,500 1,117 Miscellaneous - - 415 0% 5,000 - Reimbursements From Other Funds 15,003 14,720 14,720 100% 176,635 (283) Transfers In - - 150,000 0% 561,765 - Total Operating Revenues 475,265 485,430 623,525 78% 6,752900 10,165 EXPENDITURES Personnel 118,022 100,768 135,255 75% 1,474,390 (17,254) Materials and Supplies 10,748 14,452 39,975 36% 351,095 3,704 Operation and Contract 137,948 191,259 225,155 85% 1,132,435 53,311 Other Expenditures 12,917 13,542 13,540 100% 162,500 625 Capital Ou0ay - - - 0% 1,755,000 - Total Expenditures 279,635 320,021 413,925 77% 4,875.420 40386 NET FUND INCREASE (DECREASE) 195,630 165,409 209,600 1,877A80(30,221 Flra YwrTmd /' "tea EximndlNro by BapWnaOr YIIIaOe of Oak Brook MhaahuMre Fond - MW Soured Five Your TWO 1131116 Valli Far Me Fail Ending January 31, W7 %oi 201] TWaI TWI Yt[I YTO Z. Mavanuea EamnOiluro Five Year Trend Frlw YearFOWL 1131/1]Aqual $ 485.x30 $ 320,021—u BudZ Year 1131/18 ACWel $ 4]5.265 $ 2]B.CK 2564 S 13.295 %Change Frani St Year 2A% 144% J--t 0.•m--* PUOIk Weeks 243.149 3102 93 93 3]8.0 619% Mager Rwmuw 07.141 f �-*�/ IV FaceneeWg BC lRoute 389!1 7,,167 Bale�Tex CuaMa Mlerea+ M6CMMnacue RamouRpeane tlJtm Atlwl 5 466.823 8 - $ 4,08] $ - E t4)2p tl3tn8pclual $ 45].292 $ Miles E 2,9. $ E 15,003 % Craigs From}eel Year 20% 0.0% 37.6% 0.0% -19% Fam YaaT nd MafOr EapMialureB PereOnnel suppled G Meclual Encendluem Candeal Way t/3tH]Acasl 8 100.]88 S 14,452 $ 191259 E- 19t/t6ACWal $ 118.022 E t0, ]46 $ t3],. E 12,917 $ % Grange Fixer lmi Year -146% 30.5% b8% 4B% 0.0% Flra YwrTmd /' "tea EximndlNro by BapWnaOr 1131116 Valli 1131117 %oi 201] OlRweou Fled Yt[I YTO Z. TTB %Of AMUN Frlw YearFOWL Zoe Budp01 BudZ Year Trend La,alal'rva B General byn,O.anl 8 2,50.5 $ 2564 S 13.295 193% $ 1]4,430 E 19 J--t 0.•m--* PUOIk Weeks 243.149 3102 93 93 3]8.0 619% 269],445 07.141 f �-*�/ IV FaceneeWg BC lRoute 389!1 7,,167 21,]00 330% 2.003,145 (26,}]0.) V Total EepenMWm 6 2791 6 mi $ 411M ,.M $ 4/76,420 5 Miles �y immrgedWea arna ae onvi n4 arMam Net)ear. lramcrema Frevanuaskmamlr Ma reau9 WAnmamm58a+raxeated, and IMemi(un8%1 mmparedWNai>ear. Tns wm nifan dyadameae.In aanneursamanN(-1.9x) wmparedmleattwr. rrmu9n.wnnary, mel reennu na 6t3aoes under eue9n. Toner to eadkum W$320.021 am 14,4% hi Man let tear. TM IMreMWcture Fund eigiienced increases in MatertaN B Suppt (30.5%(, CperalionI Cmlracival (386%(, and girer Egend6urae (48%) uanWrai W and year. That; in oflaet by dacreasa In Ferri (-14.6%)mrimre] M lag year TWough Jan., ..I expandllurm are ilgi Underbudget. Village of Oak Brook Water Fund Financial Update For the Period Ending January 31, 2017 Plan Review Fees 64 1/31117 1/31/17 46% 2,000 1/31116 1/31117 YTD %of 2017 Difference YTD YTD Amended Amended Adopted Prior Actual Actual Budget Budget Budoet Year Plan Review Fees 64 75 165 46% 2,000 11 Building/Inspection Fees 64 75 375 20% 4,500 11 Water Sales 730,017 821,116 820,300 100% 9,143,000 91,099 Unmetered Sales - - 2,080 0% 25,000 - WalerConnectionFees 2,760 2,760 2,500 110% 30,000 - Fire Service Charge - - 835 0% 10,000 - Meter Charges 301 301 2,085 14% 25,000 - Special Services - - - 0% 31,000 - Interestonlnvestments 940 2,138 835 256% 10,000 1,198 Miscellaneous 820 (1,197) 5,415 -22% 65,000 (2017) Total Operating Revenues 734,966 825,268 834,590 99% 9,345,500 90,302 EXPENDITURES Personnel 71,421 77,768 67,655 115% 835,110 6,347 Materials and Supplies 36 1,202 5,250 23% 70,660 1,166 Operation and Contract 55,040 83,333 $87,850 14% 6,547,735 28,293 Other Expenditures 35,310 33,467 33,465 100% 401,600 (1,843) Capital Outlay 6,327 4,165 152% 3,235,010 6,327 Total Expenditures 161,807 202,097 698,385 29% 11,090,115 40,290 NET FUND INCREASE (DECREASE) 573,159 623,171 136,205 (1,744,615) 50,012 FIK Year Trent /^ e- i e---1 "^ _ e-111 EapmdNm by Department Ill 113111) w1ha9edoaMerOW %d 2012 OMereace leWrFuotl Ma)w SomttaFNe YearTmen Ylo Ylo For Ne Pena6 EnEln9 January 31, W17 Annud Tdel Total ACNy Z. Revmuo EMardluma Five Year Trentl Year Trend Pudq WOM $ 161,807 $ 1/31/1]MWM $ 923208 $ 202.09] 7,91 $ 40,290 1I31I16... S YJ4966 $ 101.007 - %Coal From Last Year 12.3% 24.9% Total Expenditures 6 161 $ 202,097 $ 689,385 enUss�rnpenaiwa 11,000113 $ 40863 waw Waterealp Unmetered 3alp Connection Foss Meter Gagp Mtcelanewa 1131/i>Adual S 821,110 $ - E 2. E 901 E (119]) 191/tfi Mual $]30.01] S 8 2,980 E 301 $ 320 % Clual From Last Year 125% 11.0% 00% 00% 246.0% F Year Trend e /a� r \ • . F ,i ^.i /�p-6-a/11W /� - -ai 4Ae sampan 98 oO 5 Centel PpeOnned SuppiNe Cenra l EawlMlUrea Cydal0., 1131/1]Aduel $ ]'. $ 1'sps $ 83,333 $ 33,411] $ 8,3T 1ry'lii aI S 71,4211 38 S SLOW S 35.310 I$ % Cheaper From last Year 09% 32389% 510% d2% 1W,O% FIK Year Trent /^ e- i e---1 "^ _ e-111 EapmdNm by Department TOW ma Wp aftPiZ268 am 123% higher Nan lad year. 16e ircma9e In RyrNp ie prmenlymBOB up M11WRppin Weler561p (125%1 C011lp&Bp to lael year. TA'6 or oflael by dettepp In Mgpdma0ue 1-248.0%) c8mpare t lo Wt yw'. Tllwgh January. Land reveal are 89322 under Mail ToNIe nWureed$202A97are24,MhM1rler NanIWyur. T1e HoeneIn eagndlMmNma]e updnveazxn Porscnnal189%1. bkNriab88up01ip 13,339.8%) oper811mplit Comperea1131A%), and Capital Cubay(100.0%) compared to andsear. T1161acRp1 minoM ,n MerEyK dI om(d,2%)comp dWWst wr. ,Mdoilit Jnuary, tons pgndWma am be9fi.203 uncap Wd9N. Ill 113111) 113111117 %d 2012 OMereace Free Ylo Ylo Y10 Annud Prl11 Year ACNy Z. Budod Z.O.ee Badpe1 Year Trend Pudq WOM $ 161,807 $ =09] $ anal5 20.9% $ 7,91 $ 40,290 } Fngineging b Capital Pmler. - - 00% 3,178.015 Total Expenditures 6 161 $ 202,097 $ 689,385 tdi $ 11,000113 $ 40863 TOW ma Wp aftPiZ268 am 123% higher Nan lad year. 16e ircma9e In RyrNp ie prmenlymBOB up M11WRppin Weler561p (125%1 C011lp&Bp to lael year. TA'6 or oflael by dettepp In Mgpdma0ue 1-248.0%) c8mpare t lo Wt yw'. Tllwgh January. Land reveal are 89322 under Mail ToNIe nWureed$202A97are24,MhM1rler NanIWyur. T1e HoeneIn eagndlMmNma]e updnveazxn Porscnnal189%1. bkNriab88up01ip 13,339.8%) oper811mplit Comperea1131A%), and Capital Cubay(100.0%) compared to andsear. T1161acRp1 minoM ,n MerEyK dI om(d,2%)comp dWWst wr. ,Mdoilit Jnuary, tons pgndWma am be9fi.203 uncap Wd9N. Village of Oak grook Mgmmy Operating Statement Sports Core Fund Consolidated Presentation For the Period Ending January 31, 2017 DIRECTREVENUES Memberships Greens Fees Pro Shop Sales Golf Lessons Driving Range Fees Rentals Golf Suml Programs/User Fees Food Sales Beverage Sales Other Revenue Total Direct Revenues DIRECT EXPENDITURE Personnel Materials & Supplies Operational& Contractual Other Capital Total Direct Expenditures Direct Revenues Over (Under) Expenditures BST Admimstrstion Overhead Allocation' Dem Ser ce Operating Revenues Over (Under) Expenditures - 113111] 1131117 - 0% 443.580 1*1117 YID %of 2017 VNI16 Difference B&T Recreation Food & Gulf Golf YTD Amended Amended Adopted M Prior Programs Beverage Club Surcharge Total Budget Budget Budget Tafel Year - - - - - - 0% 443.580 - - Transfer From General Fund - - - - - 0% B44000 304 (304) - - (81) - (81) - 0% 194000 1,472 (1,553) - - - - - - 0% 30.250 150 (150) - - 740 - 740 - 0% 225.000 8 732 - - - - - - 0% 327,850 - - - - - - - - 0% 110,000 30 (30) 1,625 - - - 1,625 1,485 111% 38],]50 two 75 - - - - - - 0% 183,850 - - - - - 0% 199.300 - - 246 5 454 705 2,760 26% 354,400 2,484 (1.779) 1871 684 454 2.989 4225 71% 3.271.980 5,998 (3,009) 10,210 5.92 41,816 - 57.518 68.020 85% 1,609,185 59,753 (2,235) 161 - 161 1.230 13% 700.870 2119 (1,958) 49,759 2,180 59,571 - 111,510 98,685 113% 1,047,630 ]],415 34095 - - - - - 0% (206800) - - 59889 7,672 101.548 1691189 167,935 101% 3.3]].485 139.287 29,902 (58096) (7672) (100884) 454 (168200) (163710) 102% (105.505) (133.289) (32.911) 32,200 (32.200) - - - - 0% (258981 (39872) (100884) 454 (166200) (163710) 102% (105.505) (133,289) (32.911) Ime fund Loan" - - - - - - 0% - 100.000 (104000) Transfer From General Fund - - - - - 6,125 0% 73.505 - Transfer From Infrastructure Fund 2,000 - - - 2,000 2,000 100% 24,000 2.000 - TransferFromWaterFund 667 - - - 661 635 1W% &000 667 - Remove Capial Outlay - - - - - 0% - - - DepreGationExWnsa" (7460) (455) (10760) (5230) (2390.5) 0% (23,904) (1) Adjusted Operating Revenues Over (Under) Expenditures (30691) (40327) (111,644) (4,776) (187,438) 1154,9201 121% (54,528) (132912) 'Overhead allocation is comprised of salaries, business fomes, liability Insuralwe, building & grounds maintenance and bank service fees in Program 811 - Spuds Core General Ope2bons distributed to various $pods Care Progrems as a %basis. '9ntedund loan is from the General Fund. "'EsfimatedamouM. VI14go1Oakeroak Sam. Card Fund-qI Someee FNe Yxc Tn. For Ne a gr ori Ending January 31, 2017 FMYaeIiRM / \ a--a-� a� .1Direl TdalDWn ..I.0 Openuon3 dM1x XeWnue¢ EaPouaftres anal YBelTrynO CanOacWy Emendl0lres C.Mus., Vatln MuN E SZS1B E t8t 3 S 2868 S 108.169 _ aqua l $ i131/1)pauN 1 . 5 5.8 D 1. 28) 39 Asand 5 % Chane From Lam Year Fro %OlChm Last Yeal Change From fi.2%2% 2L5% 400% 0.0% Od% -FOermues - Eumm, B3T meuames. Presmrra Is 1.21) $ 1,8)1 3 orhard 03%$ 0a2. $ MentersM1ip Greens'.. Ilea.Fees stands Under Fees Igtlnub& D 710 E - D LB25 W1/16 Adui S $ YJa 5 6 S - E I,Y6 % Change Frohn Lal Yen 00% -ifA.O% 01 5% 00% d8% FMYaeIiRM / \ a--a-� a� Flue Year Trend Ail \/ l , ra1 / Raver., a, DeOaNnenl ..I.0 Openuon3 dM1x anal $umm er CanOacWy Emendl0lres C.Mus., Vatln MuN E SZS1B E t8t 3 111,510 $ - S - =16., $ 50)53 E 2,118 $ 17p15 $ Asand 5 % Chane From Lam Year .",% .,a% 400% 0.0% Od% Flue Year Trend Ail \/ l , ra1 / Raver., a, DeOaNnenl 11]1110 11]11', hums, %d A17 OMerence FIW Y)D TID YSD %d Asnual Prior Mlual Asand BudON Bw on Year Trend B3T meuames. Presmrra Is 1.21) $ 1,8)1 3 0i8.e95 03%$ 0a2. $ 851 Food O.."a 2.B. - 121. 00% ae? 5. 12.PoB1 Gdl Club 1.9% BBs 58).93) 0.1% 1.184.301) (1.2)0) Iia GWBucllame 207 050 32355 1<% 1125W 20) To1eI B0uenuae f 5.W8 f 2.809 $ 1.))45W 0.2% f ]3)t,. f Mang EeCen .-4 Coaxia l 11]1118 11]111) 11311', %d 2017 Difference Firy YtD Yi0 YT %d Mnual Prbr Year I mel Actual BWON BuMel Budoel Year Trand BBT Fresheners "rams $ 03005 3 59589 E b430 17.I%S .",a f 17,OBi ^ a^ 1...—mg. d. ),BR 2BI.r. 2.7hu 633.645 (1820) .club 0).)88 101.508 7)&)51 13.0% 1,151,800 'V. . 4suNwe 50001 0.0% A /I TOLLI Fipmdl.— f 'I'll S 164,199 f 1FSS00) 11.8% f 3.3)),405 f 29.902 � TOW revenues d$2.. ere 503% bwnlM1an and year. Beunues In January has ..m irng1.1 in Ne 11.due . M. 1.1 dxONly Imonal January, bbl d. mumu¢, ne 11,238 me. arms 1. iota essandMrea 0$1 W.189 are 21.5% b¢11v Nan lest year, The lncreaw In npendlbres is due b an lncmx in Oooc¢tion B ConhMu91(010% I wmpeaed b lead year Tns is offset M, dismissed In Personnel(3)%)and MN0 edNe 6uMtYes(I compare b list year. Tnmu,s Januay. bW rimed egen,K am$L250 avn budge. Village of Oak Brook Monthly Operating Statement Baur 8 Tennis Club Recreation Programs Far the Period Ending January 31, 2017 Revenues: Memberships ProgramslUser Fees Beverage Sales Other Revenue Total Revenue Expenditures: Personnel Materials 8 Supplies Operational 8 Contractual Capital - - - 0% 273,080 - - (40) - - - 1,665 1,625 1,465 111% 38],]50 1,550 75 - - - - - - 0% 300 - - 2W 1,665 1,871 1,515 123% 842,830 1,217 654 10,210 - - - - 10.210 10,150 101% 226,335 3,830 6,380 - - - - - - 670 0% 66,700 1,452 (1,452) 49,625 33 42 - 59 49,759 37,465 133% 63$105 36,723 13,036 Total Expenditures 59.835 33 42 59 59,969 48,285 124% 992,140 42,005 17,964 Direct Revenues Over (Under) Expenditures 1131117 1131117 (42) - 1,606 158,0981 1131117 YTD %of 2017 1131116 Difference 811 812 813 815 816 YTD Amended Amended Adopted YTD Prior BBTAdmin Swimming Tende Pdo Open Fields Total Budget Budget Budget Total Year - - - 0% 273,080 - - (40) - - - 1,665 1,625 1,465 111% 38],]50 1,550 75 - - - - - - 0% 300 - - 2W 1,665 1,871 1,515 123% 842,830 1,217 654 10,210 - - - - 10.210 10,150 101% 226,335 3,830 6,380 - - - - - - 670 0% 66,700 1,452 (1,452) 49,625 33 42 - 59 49,759 37,465 133% 63$105 36,723 13,036 Total Expenditures 59.835 33 42 59 59,969 48,285 124% 992,140 42,005 17,964 Direct Revenues Over (Under) Expenditures (59629) (33) (42) - 1,606 158,0981 (46P0) 124% (149,310) (40788) (17,310 6,125 0% 73,505 - - TransferFrominfrastructureFund 2,00 - - - - 2,000 2,W0 100% BST Administration Overhead Allocation" 59,629 (21466) (5963) 667 - - - 32200 14.745 218% 176,890 13,108 19,092 Remove Capital Outlay - - - - - - - 0% - - - DepreciationExpensi (5075) (22301 (155) - Revenues Over (Under) Expenditures (21499) (8005) 1,6W (25,898) (32.025) 81% 27,580 (27,680) 1,782 mterfund Loan" - - - - - 0% - 100,00 (1W,00) Transfer From General Fund - - - - - - 6,125 0% 73,505 - - TransferFrominfrastructureFund 2,00 - - - - 2,000 2,W0 100% 24,000 2,OW - Transfer From Water Fund 667 - - - - 667 965 100% 8,000 667 - Remove Capital Outlay - - - - - - - 0% - - - DepreciationExpensi (5075) (22301 (155) - (]460) 0% - (7,458) (2) Adjusted Revenues Over (Under) Expenditures (2,408) (23729) (Q160) - 1,60 (30,691) (23,235) 132% 133,085 67,529 (98,220) '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. '9ntertund loan is from the General Fund, "-Estimated amount. Village of Oak Brook Monthly Operating Statement Sports Core Food & Beverage Programs For the Period Ending January 31, 2017 Revenues: Memberships Food Sales Beverage Sales Other Revenue Total Revenue Expenditures: Personnel Materials & Supplies Operational & Contractual Capital Total Expenditures Direct Revenues Over (Under) Expenditures - - - - 0% 4,500 - - 0% 163,850 - - - 0% 199,000 - - 2,500 0% 165,000 2,600 (2,600) 5,492 - - 5,492 9,610 57% 226,890 5,911 (419) - - 460 0% 210,920 - - 1,855 - 325 2,180 8,355 26% 160,736 3,585 (1,405) 7,347 325 7,672 18,425 42% 633,545 9,496 (1,824) (7347) (325) (7672) (15,925) 48% (101,195) (6,896) (776) B&T Administration Overhead Allocation' (29815) (2385) (32200) (14740) 218% (176,890) (13,108) (19,092) Revenues Over (Under) Expenditures (37162) (2385) (325) (39872) (30665) 130% (278, 86) (20,004) (19,868) Transfer From General Fund - - - - - 0% - - - Remove Capital Outlay - - - - - 0% - - - Depreciation Expense" (355) (100) - (455) - 0% (456) 1 Adjusted Revenues Oxer (Under) Expenditures (37,517) (2,485) (325) (40,327) (30,665) 132% (278,085) (20,460) (19,867) '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. Estimated Amount 1131117 1131117 821 822 823 1131117 YTD %of 2017 1/31116 Difference B&T Poolside Golf YTD Amended Amended Adopted YTD Prior Clubhouse Calls, Clubhouse Total Budget Budget Budget Total Year - - - - 0% 4,500 - - 0% 163,850 - - - 0% 199,000 - - 2,500 0% 165,000 2,600 (2,600) 5,492 - - 5,492 9,610 57% 226,890 5,911 (419) - - 460 0% 210,920 - - 1,855 - 325 2,180 8,355 26% 160,736 3,585 (1,405) 7,347 325 7,672 18,425 42% 633,545 9,496 (1,824) (7347) (325) (7672) (15,925) 48% (101,195) (6,896) (776) B&T Administration Overhead Allocation' (29815) (2385) (32200) (14740) 218% (176,890) (13,108) (19,092) Revenues Over (Under) Expenditures (37162) (2385) (325) (39872) (30665) 130% (278, 86) (20,004) (19,868) Transfer From General Fund - - - - - 0% - - - Remove Capital Outlay - - - - - 0% - - - Depreciation Expense" (355) (100) - (455) - 0% (456) 1 Adjusted Revenues Oxer (Under) Expenditures (37,517) (2,485) (325) (40,327) (30,665) 132% (278,085) (20,460) (19,867) '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. Estimated Amount Village of Oak Brook Monthly Operating Statement Golf Club Programs For the Period Ending January 31, 2017 Excenditures, Personnel Materials 8 Supplies Operational 8 Contractual Other Capital Total Expenditures Direct Revenues Over (Under) Expenditures B&T Administration Overhead Allocation' 27,340 - - 14,476 41,816 48,260 87% 1,155,960 50,012 1131117 1131117 - 2,507 161 100 161% 423,250 831 832 833 834 1131117 YTD %of 2017 1131118 Difference - - Golf General Golf Learning Golf Cart Golf Counm YTD Amended Amended Adopted YTD Prior - Operation It Practice Operations Maintenance Total Budget Budget Budget Total Year Revenues: Memberships - - - - - - 0% 166,000 - - Greens Fees - - - - - - 0% 640.000 304 (304) Pro Shop Sales (81) - - - (81) - 0% 190,000 1,472 (1,553) Golf Lessons - - - - - - 0% 30,250 150 (150) Driving Range Fees - 740 - - 740 - 0% 225,000 8 732 Rentals - - - - - - 0% 327,860 - - Other Revenue 5 5 0% 5,200 5 Total Revenue (76) 740 664 0% 1,784,300 1,934 (1,270) Excenditures, Personnel Materials 8 Supplies Operational 8 Contractual Other Capital Total Expenditures Direct Revenues Over (Under) Expenditures B&T Administration Overhead Allocation' 27,340 - - 14,476 41,816 48,260 87% 1,155,960 50,012 (8,1%) (2,346) - - 2,507 161 100 161% 423,250 667 (606) 54.712 - - 4,859 59,571 52,865 113% 248,790 37,107 22,464 - - - - - - 0% (206,200) - - - - - - - - 0% 130.000 - - 79,706 21,842 101,548 101,225 100% 1,751,800 87,786 13,762 (79782) 740 (21842) (100884) (101225) 100% 32500 (85,852) (15,032) Revenues Over (Under) Expenditures (79782) 740 (21842) (100884) (101225) 100% 32,500 (85,852) (15,032 Transfer from General Fund - - - - - - 0% - - - Remove Capital Outlay- - - - - - 0% - - - DepredaticnExpease" (3845) (30) (3210) (3675) (10760) 0% - (10,760) - Adjusted Revenues Over (Under) Expenditures (83627) 710 (3210) (25517) (111,844) (101,225) 110% 32,500 (96,612) (15,032) 'Overhead allocation Is comprised of salaries, business fortes, liability insurance, building 8 grounds maintenance and bank service fees in Program 811 - Spods Core General Operations distributed to various Sports Core Programs on a percentage basis. "Estimated Amount Village of Oak Brook Monthly Operating Statement Golf Improvement - Surcharge For the period Ending January 31, 2017 The Golf Surcharge Account is the repository, for revenues receivetl from the $3.W per round surcharge levied on every round of golf played at the Oak Brook Golf Club. Surcharge revenues are reserved for golf course improvements and for restoration of flood damage to the course, should it be necessary in Ne future. 'Estimated Amount 1131117 1131117 1131117 YTD %of 2017 1131116 Difference YTD Amended Amended Adopted YTO poor Actual Budget Budget Budget Total Year Revenues: Golf Surcharge - - 0% 110,000 30 (30) Other Revenue 454 210 216% 2,500 217 237 Total Revenue 454 210 216% 112,500 247 207 Expenditures, Operation& Contractual - - 0% - - - Capital 0% Total Expenditures 0% Revenues Over (Under) Expenditures 454 210 216% 112,500 247 297 Transfer from General Fund - - 0% - - - RemoveCapitalOullay - - 0% - - - Depreciation' (5,230) 0% (5,230) Adjusted Revenues Over (Under) Expenditures (4,778) 210 -2274% 112,500 (4,983) 207 The Golf Surcharge Account is the repository, for revenues receivetl from the $3.W per round surcharge levied on every round of golf played at the Oak Brook Golf Club. Surcharge revenues are reserved for golf course improvements and for restoration of flood damage to the course, should it be necessary in Ne future. 'Estimated Amount