11 - November 2017 Monthly Financial ReportVILLAGE
OAK BROOK
OF
MONTHLY FINANCIAL REPORTS
NOVEMBER 2017
ITEM #6.G.
Total
Cash and Cash Pooled Cash and
Fund Equivalents Investments Investments % By Fund
General Corporate $5,727,780 $13,000,889 $18,728,669 46.5%
Hotel/Motel Tax 1,888,911 2,193,724 4,082,635 10.1%
Motor Fuel Tax 238,364 476,272 714,636 1.8%
Promenade TIF 242,576 - 242,576 0.6%
Water 4,893,206 859,631 5,752,837 14.3%
Self-Insurance 225,449 - 225,449 0.6%
Sports Core 551,295 - 551,295 1.4%
Golf Surcharge 16,919 540,316 557,234 1.4%
Equipment Replacement 855,495 941,561 1,797,055 4.5%
Infrastructure 4,651,342 3,328,158 7,979,500 19.8%
Garage 403,326 - 403,326 1.0%
Total $19,694,661 $21,340,550 $41,035,211 101.9%
Change in Cash and Investments by Fund :
Balance at Balance at Year-to-Date Year-to-Date
Fund January 1, 2017 November 30, 2017 Change ($)Change (%)
General Corporate $16,586,097 $18,728,669 $2,142,572 12.9%
Hotel/Motel Tax 4,415,721 4,082,635 (333,086)-7.5%
Motor Fuel Tax 909,926 714,636 (195,290)-21.5%
Promenade TIF 249,278 242,576 (6,702)-2.7%
Water 2,732,210 5,752,837 3,020,627 110.6%
Self-Insurance 589,849 225,449 (364,401)-61.8%
Sports Core 701,448 551,295 (150,153)-21.4%
Golf Surcharge 0 557,234 557,234 N/A
Equipment Replacement 1,510,026 1,797,055 287,029 19.0%
Infrastructure 5,436,080 7,979,500 2,543,420 46.8%
Garage 347,053 403,326 56,273 16.2%
$33,477,689 $41,035,211 $7,557,522 22.6%
Book Market
Value Value
Pooled Checking $1,045,703 $1,045,703
Sports Core Checking 567,314 567,314
Pooled IPTIP 17,992,221 17,992,221
Water E-Pay IPTIP 89,423 89,423
$19,694,661 $19,694,661
Pooled Investments:
Certificates of Deposit $6,965,000 $6,947,031
Investments-Municipal 8,602,079 8,548,633
Investments-Corporate 4,781,647 4,777,511
Government & Agency Obligations 869,137 847,671
Accrued Interest 122,687 122,687
Total Pooled Investments $21,340,550 $21,243,533
Total Cash and Investments $41,035,211 $40,938,193
For November, total interest revenue is $44,831 and year to date is $404,083.
Total investment yield for the portfolio is:
Pooled
Investments Illinois Funds Total
Monthly yield 0.14%0.11%0.13%
YTD yield 1.33%0.84%1.13%
Last 12 months yield 1.43%0.88%1.20%
The weighted average yield of the current pooled investment portfolio is 1.68%.
Monthly Treasurer's Report
November 30, 2017
Monthly Treasurer's Report
November 2017
The table below lists the detail investment holdings at J.P. Morgan Securities as of 11/30/17:
Month End VOB
Settlement Maturity Coupon Yield Book Market Accrued
Type Date Date Rate Rate Value Value Interest
Municipal Bonds:
Public Utility District #181117EP3 09/02/14 1/1/2018 1.667%1.650%$600,157 $599,994 $4,212
Florida Hurricane #34074GDG6 01/05/15 7/1/2018 2.107%2.090%751,328 750,548 6,571
Maryland St Econ Dev #57420PGK6 07/08/15 6/1/2019 2.050%2.123%99,891 100,156 1,023
Rosemont IL GO Corp #777543UT4 02/08/16 12/1/2019 3.021%2.000%509,942 504,020 7,457
New York St Urban Dev Corp #650035J58 02/22/16 3/15/2018 1.650%1.150%175,249 175,056 601
New York N Y City #64971QTX1 02/22/16 5/1/2021 2.350%2.000%202,294 200,242 377
Florida Hurricane #34074GDH4 03/30/16 7/1/2020 2.995%2.150%510,518 506,575 6,239
Bloomingdale Mich Pub Sch Dist #094383FS0 04/26/16 5/1/2022 2.710%2.150%511,725 501,705 1,090
Milan Mich Area Achs #598801JD1 05/26/16 5/1/2020 1.931%1.931%245,000 244,214 293
Indiana Bd Bk Rev Taxable #4546248F7 01/06/17 1/15/2020 2.934%1.900%260,444 258,851 2,840
North Carolina Eastn Mun PWR #65819WAC7 01/30/17 7/1/2018 2.003%1.450%702,223 700,497 5,842
Garland Cnty Ark Sales & Use #36609PAN3 02/06/17 11/1/2019 1.795%1.840%499,574 495,455 873
Anchor Bay Mich Sch Dist GO #032879TA6 02/13/17 5/1/2019 1.810%1.420%366,998 364,547 474
Macomb Cnty Mich Retirees #554885H63 04/11/17 11/1/2018 1.731%1.300%401,571 399,576 534
Lanse Creuse Mich Pub Schs #516228RL9 05/02/17 5/1/2020 2.159%2.159%100,000 100,165 178
California St GO Bonds #13063A7G3 05/08/17 10/1/2019 6.200%1.600%541,541 538,150 4,885
*Genesee Cnty Mich #371608UV0 05/31/17 10/1/2019 1.835%1.835%623,000 623,012 6
Connecticut St GO Bds 2016 #20772J3F7 06/15/17 8/15/2021 1.750%2.300%490,267 481,705 2,523
North Carolina Eastn Mun Pwr #65819WAL7 10/02/17 7/1/2019 2.578%1.700%506,863 504,555 5,228
Fowlerville Mich Comnty Schs #351280MS8 10/03/17 5/1/2020 2.045%1.750%503,491 499,610 682
Total Municipal Bonds $8,602,079 $8,548,633 $51,926
Corporate Bonds:
MacCormick & Co #579780AF4 04/06/17 12/15/2017 5.750%1.401%$500,870 $500,585 $13,151
JP Morgan Chase #46625HJG6 06/08/17 1/25/2018 1.800%1.371%845,546 845,118 5,269
Goldman Sachs Group #38141GRC0 06/08/17 1/22/2018 2.375%1.531%1,001,200 1,000,790 8,425
Wachovia #92976WBH8 06/15/17 2/1/2018 5.750%1.360%1,040,720 1,039,725 19,438
Morgan Stanley #6174467U7 08/28/17 4/25/2018 2.125%1.531%1,393,311 1,391,293 2,908
Total Corporate Bonds $4,781,647 $4,777,511 $49,189
Government & Agency Obligations:
**Government National Mtg Assn #38379UEM4 02/29/16 2/16/2051 2.300%2.245%$869,137 $847,671 $2,099
Total Government & Agency Obligations:$869,137 $847,671 $2,099
Certificates of Deposit:
Capital One Natl Assn VA #14042E5Z9 08/26/15 8/27/2018 1.75%1.75%$245,000 $245,436 $1,563
Ally Bk Midvale Utah #02006LVC4 10/29/15 10/29/2018 1.60%1.60%245,000 245,326 327
Wex Bank Midvale Utah #92937CDY1 07/29/16 7/30/2018 1.00%1.00%245,000 244,395 830
Bank Hope Los Angeles #062683AB3 08/26/16 8/27/2018 1.00%1.00%245,000 244,045 22
Wells Fargo Bank Natl Assn #949763AL0 08/31/16 8/31/2018 1.10%1.10%245,000 244,040 9
BMW Bank #05580AFG4 09/23/16 9/24/2018 1.10%1.10%245,000 243,878 502
Comenity Cap Bank #20033ASB3 09/26/16 9/26/2018 1.10%1.10%245,000 243,863 29
Enerbank #29266N4E4 10/21/16 10/22/2018 1.10%1.10%245,000 244,057 299
Discover Bank #254672L71 10/26/16 10/26/2018 1.20%1.20%245,000 243,662 286
Bank of Baroda #06062QXT6 11/30/16 11/30/2017 0.95%0.95%0 0 2,328
State Bk India NY #8562846A7 01/26/17 1/26/2022 2.25%2.25%245,000 245,742 1,937
Marlin Business Bk #57116ANU8 05/10/17 11/12/2019 1.60%1.60%245,000 244,022 213
American Express Fed Svgs #02587CER7 05/10/17 11/12/2019 1.70%1.70%245,000 243,826 226
Synchrony Bank #87164WRA8 05/26/17 5/28/2019 1.65%1.65%245,000 244,819 17
Umpqua Bank #90421MAG8 05/31/17 5/31/2019 1.60%1.60%245,000 244,630 6
Stone Bk Mtn View Ark #86158RAJ8 06/28/17 6/28/2019 1.60%1.60%245,000 244,542 12
Investors Savings Bk #46176PGU3 06/30/17 4/2/2018 1.35%1.35%245,000 245,049 1,378
TIAA FSB Jacksonville #87270LAA1 07/19/17 7/19/2019 1.60%1.60%245,000 244,471 1,437
Peoples United Bank #71270QQZ2 07/19/17 7/19/2019 1.65%1.65%245,000 244,669 1,482
Priority Bank Ozark Ark #74269KBR6 07/26/17 7/26/2019 1.60%1.60%245,000 244,449 40
American Express Centurion #02587DV96 08/15/17 8/17/2020 1.90%1.90%245,000 243,422 1,358
Sallie Mae #795450C86 08/16/17 8/17/2020 1.90%1.90%245,000 244,385 1,358
Merrick Bank South Jordan #59013JZS1 08/21/17 8/21/2020 1.80%1.80%245,000 243,719 113
Pinnacle Bank #72345SFS5 08/30/17 8/31/2020 1.80%1.80%115,000 114,372 1
Jackson County Bank #466682AP6 08/31/17 3/1/2021 1.85%1.85%245,000 243,221 1,133
Barclays Bank #06740KKX4 09/27/17 9/28/2020 1.95%1.95%245,000 244,510 836
Capital One Bank #1404205E6 10/04/17 10/4/2019 1.70%1.70%245,000 244,628 648
Transportation Alliance #89388CCB2 10/13/17 4/12/2019 1.60%1.60%235,000 234,774 172
Goldman Sachs Bank #38148PRK5 10/18/17 10/19/2020 1.95%1.95%245,000 244,405 557
FirstBank PR Santurce #33767A6M8 11/03/17 11/3/2020 2.00%2.00%245,000 244,674 354
Total Certificates of Deposits $6,965,000 $6,947,031 $19,473
Total J.P.Morgan Securities $21,217,863 $21,120,846 $122,687
*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
November 30, 2017
Cash & Investments by Fund - Total $41.0 million
Cash & Investments by Type - Total $41.0 million
General Corporate
45.64%
Hotel/Motel Tax
9.95%Motor Fuel Tax
1.74%
TIF #1
Butterfield/Meyers
0.59%
Water
14.02%
Self-Insurance
0.55%
Sports Core
1.34%
Golf Surcharge
1.36%
Equipment
Replacement
4.38%Infrastructure
19.45%
Garage
0.98%
Checking, $1.6
Illinois Funds, $18.1
Certificates of Deposit,
$6.9
Municipal Bonds, $8.6
Corporate Bonds, $4.8
Government & Agency
Obligations, $0.9
Accrued Interest, $0.1
in millions
YTD YTD
Net Fund Budget
Increase Increase
Governmental Funds Revenues Expenditures (Decrease)(Decrease)
General Fund (Major Fund)$22,484,033 $20,371,798 $2,112,235 ($374,955)
Main operating fund of the Village.
Hotel Fund (Major Fund)$1,257,268 $1,423,907 ($166,639)($1,420,870)
Collects and spends resources from the
3% hotel/motel tax.
Motor Fuel Tax Fund $194,314 $389,604 ($195,290)($370,015)
Collects and spends resources from the
State motor fuel tax.
Infrastructure Fund (Major Fund)$5,854,697 $3,079,279 $2,775,418 $1,817,160
Accounts for construction and maintenance of
roadways, drainage, and safety path systems.
Promenade TIF Fund (Major Fund)$451,636 $458,338 ($6,702)($36,365)
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)$9,525,698 $6,026,967 $3,498,731 ($1,093,075)
Collects user fees for the distribution of water
and maintenance of infrastructure.
Sports Core Fund (Major Fund)$3,411,459 $3,473,855 ($62,396)($281,220)
Accounts for revenues and expenses relating
to administration, programs, food and beverage
operations, and golf course.
Golf Surcharge Fund $556,072 $0 $556,072 $629,500
Accounts for the collection of the $3 per round
golf surcharge.
Internal Service Funds
Self Insurance Fund $2,881,635 $3,046,620 ($164,985)($32,255)
Accounts for the Village's health insurance costs
and the related contributions from the Village,
employees, retirees, and other agencies.
Garage Fund $685,827 $584,989 $100,838 ($70,660)
Accounts for the maintenance of the Village's vehicle
fleet and the related departmental reimbursements.
Equipment Replacement Fund $750,664 $1,208,214 ($457,550)$177,785
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 November 30, 2017
11/30/17 11/30/17
11/30/16 11/30/17 YTD % of 2017 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 11,939,193$ 11,460,477$ 12,009,655$ 95%13,048,000$ (478,716)$
Other Intergovernmental Tax 1,172,799 1,267,802 1,201,790 105%1,265,235 95,003
Telecommunications/Utility Tax 5,508,751 5,505,114 5,169,085 107%5,638,000 (3,637)
Licenses and Permits 1,805,439 2,110,500 1,663,795 127%1,711,750 305,061
Charges for Services 908,172 861,109 882,750 98%1,006,750 (47,063)
Fines and Penalties 148,096 130,277 140,745 93%153,590 (17,819)
Administrative Towing Fees 29,955 38,415 45,825 84%50,000 8,460
Interest on Investments 136,036 209,901 114,575 183%125,000 73,865
Franchise/IMF Maint. Fee 219,838 162,548 207,200 78%207,200 (57,290)
Reimbursements From Other Funds 575,685 565,862 565,850 100%617,300 (9,823)
Miscellaneous Income 181,067 172,028 208,260 83%231,675 (9,039)
Total Operating Revenues 22,625,031$ 22,484,033$ 22,209,530$ 101%24,054,500$ (140,998)$
OPERATING EXPENDITURES
Personnel 14,611,444$ 14,745,078$ 16,388,050$ 90%17,788,210$ 133,634$
Materials and Supplies 370,230 402,166 519,345 77%554,530 31,936
Operation and Contract 3,340,652 3,682,463 4,097,915 90%4,344,325 341,811
Other Expenditures 413,473 407,412 407,400 100%418,100 (6,061)
Capital Outlay 442,133 1,134,679 1,171,775 97%805,310 692,546
Total Operating Expenditures 19,177,932$ 20,371,798$ 22,584,485$ 90%23,910,475$ 1,193,866$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 3,447,099$ 2,112,235$ (374,955)$ 144,025$ (1,334,864)$
INTERFUND TRANSACTIONS
Transfers Out -$ -$ -$ 0%(73,505)$ -$
Total Interfund Transactions -$ -$ -$ 0%(73,505)$ -$
NET FUND INCREASE (DECREASE)3,447,099$ 2,112,235$ (374,955)$ 70,520$ (1,334,864)$
Village of Oak Brook
General Fund Financial Update
For the Period Ending November 30, 2017
Total Total
Revenues Expenditures
11/30/17 Actual $ 22,484,033 20,371,798$
11/30/16 Actual $ 22,625,031 19,177,932$
% Change From Last Year -0.6%6.2%
Major Revenues Other
Intergov.Licenses &Charges for
Sales Tax Tax Telecom Tax Permits Services
11/30/17 Actual $ 11,460,477 $ 1,267,802 $ 5,505,114 $ 2,110,500 861,109
11/30/16 Actual $ 11,939,193 $ 1,172,799 $ 5,508,751 $ 1,805,439 908,172
% Change From Last Year -4.0%8.1%-0.1%16.9%-5.2%
Five Year Trend
Major Expenditures Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
11/30/17 Actual 14,745,078$ 402,166$ 3,682,463$ 407,412 1,134,679$
11/30/16 Actual 14,611,444$ 370,230$ 3,340,652$ 413,473 442,133$
% Change From Last Year 0.9%8.6%10.2%-1.5%156.6%
Five Year Trend
Expenditures by Department
11/30/16 11/30/17 11/30/17 11/30/17 2017 Difference Five
YTD YTD YTD % of Annual Prior Year
Department Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 2,022,122$ 2,356,639$ 2,676,105$ 88.1%2,883,255$ 334,517$
Financial Services 1,104,439 1,029,734 1,053,915 97.7%1,116,445 (74,705)
Public Works 530,790 589,225 710,670 82.9%752,340 58,435
Engineering & Capital Projects 315,765 804,566 732,580 109.8%372,500 488,801
Library 879,625 819,747 921,120 89.0%989,470 (59,878)
Police 7,318,062 7,441,091 7,982,450 93.2%8,609,255 123,029
Fire 6,157,428 6,435,345 7,595,290 84.7%8,205,100 277,917
Development Services 849,701 895,451 912,355 98.1%982,110 45,750
Total Expenditures 19,177,932$ 20,371,798$ 22,584,485$ 90.2%23,910,475$ 1,193,866$
Explanation of Major Changes From Last Year:
Sales Tax revenue is down $478,716 compared to revenue through November 2016. This is due to non-routine receipts received from a top taxpayer in 2016. Total Sales Tax
revenue through November 2017 is $549,178 under budget due to the timing of receipts from new businesses and slowed retail growth.
Other Intergovernmental Tax revenue is up $95,003 compared to revenue through November 2016. This is due to increases in State Income Tax due to an acceleration in
payments from the State and general increases in Replacement Tax revenue. Total Intergovernmental Tax revenue through November 2017 is $66,012 over budget.
Telecommunications Tax revenue is down $3,637 compared to revenue through November 2016. Total Telecommunications Tax revenue through November 2017 is
$336,029 over budget.
Licenses & Permits revenue is up $305,061 compared to collections through November 2016. This is primarily due to increases in building permits and accessory structure
permits. Total Licenses & Permits revenue through November 2017 is over budget by $446,705.
Personnel expenditures are up $133,634 comapred to payments through November 2016. This is primarily due to general increases in wages, insurance, and pension
payments. Total Personnel expenditures through November 2017 are $1,642,972 under budget due to turnover and public safety pensions being funded lower than budgeted.
Operation & Contractual expenditures are up $341,811 compared to payments through November 2016. This is due to increased litigation services and increases in liability
insurance premiums and claims. Total Operation & Contractual expenditures through November 2017 are 415,452 under budget due to general timing of payments.
Capital Outlay expenditures are up $692,546 compared to payments through November 2016. This is due to major projects performed early in 2017 such as the BGC restroom
renovation project, fire department humidifier installation, and BGC electrical upgrade. Total Capital Outlay expenditures through November 2017 are $37,096 under budget.
Five Year Trend
For the Period Ending November 30, 2017
General Fund - Five Year Trend
Village of Oak Brook
Revenues Expenditures
11/30/17 11/30/17
11/30/16 11/30/17 YTD % of 2017 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Hotel Tax 1,136,140$ 1,168,277$ 1,028,365$ 114%1,266,000$ 32,137$
Interest 30,334 44,896 20,150 223%22,000 14,562
Miscellaneous - 44,095 - N/A - 44,095
Total Operating Revenues 1,166,474$ 1,257,268$ 1,048,515$ 119.9%1,288,000$ 90,794$
EXPENDITURES
Operation and Contract 344,971$ 386,068$ 546,285$ 71%595,975$ 41,097$
Other Expenditures 82,775 85,613 85,600 100%93,400 2,838
Capital Outlay 68,169 952,226 1,837,500 52%1,837,500 884,057
Total Expenditures 495,915$ 1,423,907$ 2,469,385$ 57.7%2,526,875$ 927,992$
NET FUND INCREASE (DECREASE)670,559$ (166,639)$ (1,420,870)$ (1,238,875)$ (837,198)$
Note - Expenditures are recorded in program 171.
Village of Oak Brook
Hotel Tax Fund Financial Update
For the Period Ending November 30, 2017
Total Total
Revenues Expenditures
11/30/17 Actual $ 1,257,268 1,423,907$
11/30/16 Actual $ 1,166,474 495,915$
% Change From Last Year 7.8%187.1%
Major Revenues
Grants Hotel Tax Interest Miscellaneous
11/30/17 Actual $ - $ 1,168,277 $ 44,896 $ 44,095
11/30/16 Actual $ - $ 1,136,140 $ 30,334 $ -
% Change From Last Year 0.0%2.8%48.0%N/A
Five Year Trend
Major Expenditures Operation &Other
Contractual Expenditures Capital Outlay
11/30/17 Actual 386,068$ 85,613$ 952,226$
11/30/16 Actual 344,971$ 82,775$ 68,169$
% Change From Last Year 11.9%3.4%1296.9%
Five Year Trend
Explanation of Major Changes From Last Year:
Hotel Tax revenue is up $32,137 compared to collections through November 2016. This is related to the timing of
receipts. Total Hotel Tax revenue through November 2017 is over budget by $139,912 because of general increases in
receipts and the timing of when receipts have been received.
Operation & Contractual expenditures are up $41,097 compared to payments through November 2016. This is related to
engineering costs for a 22nd Street beautification project. Total Operation & Contractual expenditures through
November 2017 are under budget by $160,217 due to the timing of DCVB quarterly dues and advertising payments.
Capital Outlay expenditures are up $884,057 compared to payments through November 2016. This is related to 22nd St.
construction costs that were delayed from 2016. Total Capital Outlay expenditures through November 2017 are
under budget by $885,274 due to the timing of payments.
Village of Oak Brook
Hotel Tax Fund - Major Sources Five Year Trend
For the Period Ending November 30, 2017
Five Year Trend
Revenues Expenditures
11/30/17 11/30/17
11/30/16 11/30/17 YTD % of 2017 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 5,492,871$ 5,223,472$ 5,501,095$ 95%5,982,000$ (269,399)$
Grants - 3,142 - N/A - 3,142
Interest 38,596 70,814 25,200 281%27,500 32,218
Miscellaneous 24,160 5,745 4,575 126%5,000 (18,415)
Reimbursements From Other Funds 165,033 161,920 161,920 100%176,635 (3,113)
Total Operating Revenues 5,720,660$ 5,465,093$ 5,692,790$ 96%6,191,135$ (255,567)$
OPERATING EXPENDITURES
Personnel 1,443,960$ 1,049,797$ 1,194,805$ 88%1,474,390$ (394,163)$
Materials and Supplies 90,409 87,050 331,480 26%351,095 (3,359)
Operation and Contract 1,279,583 1,397,177 1,222,795 114%1,132,435 117,594
Other Expenditures 142,087 148,962 148,940 100%162,500 6,875
Capital Outlay 1,577,216 396,293 1,539,375 26%1,755,000 (1,180,923)
-
Total Operating Expenditures 4,533,255$ 3,079,279$ 4,437,395$ 69%4,875,420$ (1,453,976)$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 1,187,405$ 2,385,814$ 1,255,395$ 190%1,315,715$ 1,198,409$
INTERFUND TRANSACTIONS
Transfers In 516,221$ 389,604$ 561,765$ 69%561,765$ (126,617)$
Total Interfund Transactions 516,221$ 389,604$ 561,765$ 69%561,765$ (126,617)$
NET FUND INCREASE (DECREASE)1,703,626$ 2,775,418$ 1,817,160$ 1,877,480$ 1,071,792$
Village of Oak Brook
Infrastructure Fund Financial Update
For the Period Ending November 30, 2017
Total Total
Revenues Expenditures
11/30/17 Actual $ 5,465,093 3,079,279$
11/30/16 Actual $ 5,720,660 4,533,255$
% Change From Last Year -4.5%-32.1%
Major Revenues
Sales Tax Grants Interest Miscellaneous Reimbursements
11/30/17 Actual $ 5,223,472 $ 3,142 $ 70,814 $ 5,745 $ 161,920
11/30/16 Actual $ 5,492,871 $ - $ 38,596 $ 24,160 $ 165,033
% Change From Last Year -4.9%N/A 83.5%-76.2%-1.9%
Five Year Trend
Major Expenditures Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
11/30/17 Actual 1,049,797$ 87,050$ 1,397,177$ 148,962$ 396,293$
11/30/16 Actual 1,443,960$ 90,409$ 1,279,583$ 142,087$ 1,577,216$
% Change From Last Year -27.3%-3.7%9.2%4.8%-74.9%
Five Year Trend
Expenditures by Department
11/30/16 11/30/17 11/30/17 11/30/17 2017 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 127,287$ 153,311$ 161,185$ 95.1%174,430$ 26,024$
Public Works 1,875,025 2,102,070 2,504,030 83.9%2,697,845 227,045
Engineering & Capital Projects 2,530,943 823,898 1,772,180 46.5%2,003,145 (1,707,045)
Total Expenditures 4,533,255$ 3,079,279$ 4,437,395$ 69.4%4,875,420$ (1,453,976)$
Explanation of Major Changes From Last Year:
Sales Tax revenue is down $269,399 compared to revenue through November 2016. This is due to non-routine receipts received from a top taxpayer in 2016. Total
Sales Tax revenue through November 2017 is $277,623 under budget due to the timing of receipts from new businesses and slowed retail growth.
Personnel expenditures are down $394,163 compared to payments through November 2016. This is primarily due to a decrease in hours needed for snow removal
overtime and a reduction in headcount related to the outsourcing of the Village engineering function. Total Personnel costs through November 2017 are $145,008
under budget due to less time spent on snow removal.
Operation & Contractual expenditures are up $117,594 compared to payments through November 2016. This is due to payments for outsourced engineering services
that started in 2017. Total Operation & Contractual expenditures through November 2017 are $174,382 over budget due to the timing of general maintenance
payments.
Capital Outlay expenditures are down $1,180,923 compared to payments through November 2016. This is due to the timing of payments. Total Capital Outlay
expenditures through November 2017 are $1,143,082 under budget due to the timing of capital projects.
Five Year Trend
Village of Oak Brook
Infrastructure Fund - Major Sources Five Year Trend
For the Period Ending November 30, 2017
Revenues Expenditures
11/30/17 11/30/17
11/30/16 11/30/17 YTD % of 2017 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 69,262$ 65,941$ 67,000$ 98%100,500$ (3,321)$
Real Estate Tax 354,829 385,018 355,000 108%355,000 30,189
Interest 294 677 85 796%100 383
Total Operating Revenues 424,385$ 451,636$ 422,085$ 107%455,600$ 27,251$
EXPENDITURES
Operation and Contract 3,938$ 3,958$ 4,070$ 97%4,070$ 20$
Other Expenditures 435,220 454,380 454,380 100%454,380 19,160
Total Expenditures 439,158$ 458,338$ 458,450$ 100%458,450$ 19,180$
NET FUND INCREASE (DECREASE)(14,773)$ (6,702)$ (36,365)$ (2,850)$ 8,071$
Note - Expenditures are recorded in program 283.
Village of Oak Brook
Promenade TIF Fund Financial Update
For the Period Ending November 30, 2017
Total Total
Revenues Expenditures
11/30/17 Actual $ 451,636 458,338$
11/30/16 Actual $ 424,385 439,158$
% Change From Last Year 6.4%4.4%
Major Revenues Real Estate
Sales Tax Tax Interest
11/30/17 Actual $ 65,941 $ 385,018 $ 677
11/30/16 Actual $ 69,262 $ 354,829 $ 294
% Change From Last Year -4.8%8.5%130.3%
Five Year Trend
Major Expenditures Operation &Other
Contractual Expenditures
11/30/17 Actual 3,958$ 454,380$
11/30/16 Actual 3,938$ 435,220$
% Change From Last Year 0.5%4.4%
Five Year Trend
Explanation of Major Changes From Last Year:
Real Estate Tax revenue is up $30,189 compared to revenue through November 2016. This is due to general property value
increases within the TIF. Total Real Estate Tax revenue through November 2017 is $30,018 over budget due to the property
valuation being higher than anticipated.
Other Expenditures are up $19,160 compared to payments through November 2016. This is due to an increase in TIF note
payable principal payments to the bondholders. This is in line with the 2017 budget projection through November.
Village of Oak Brook
Promenade TIF Fund - Major Sources Five Year Trend
For the Period Ending November 30, 2017
Five Year Trend
Revenues Expenditures
11/30/17 11/30/17
11/30/16 11/30/17 YTD % of 2017 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Grants -$ 3,386$ -$ N/A -$ 3,386$
Plan Review Fees 1,509 2,089 1,825 114%2,000 580
Building/Inspection Fees 5,688 11,614 4,125 282%4,500 5,926
Water Sales 8,192,139 9,132,372 8,860,665 103%9,143,000 940,233
Unmetered Sales 39,992 47,413 22,900 207%25,000 7,421
Water Connection Fees 66,813 182,850 27,500 665%30,000 116,037
Fire Service Charge 9,486 - 9,175 0%10,000 (9,486)
Meter Charges 21,224 21,112 22,925 92%25,000 (112)
Special Services 31,241 15,286 31,000 49%31,000 (15,955)
Interest on Investments 12,132 36,493 9,175 398%10,000 24,361
Miscellaneous 71,741 73,083 59,575 123%65,000 1,342
Total Operating Revenues 8,451,965$ 9,525,698$ 9,048,865$ 105%9,345,500$ 1,073,733$
EXPENDITURES
Personnel 753,525$ 714,804$ 770,265$ 93%835,110$ (38,721)$
Materials and Supplies 61,343 55,904 65,405 85%70,660 (5,439)
Operation and Contract 5,105,977 4,820,381 5,991,335 80%6,547,735 (285,596)
Other Expenditures 388,410 368,137 368,115 100%401,600 (20,273)
Capital Outlay 76,302 67,741 2,946,820 2%3,235,010 (8,561)
Total Expenditures 6,385,557$ 6,026,967$ 10,141,940$ 59%11,090,115$ (358,590)$
NET FUND INCREASE (DECREASE)2,066,408$ 3,498,731$ (1,093,075)$ (1,744,615)$ 1,432,323$
Village of Oak Brook
Water Fund Financial Update
For the Period Ending November 30, 2017
Total Total
Revenues Expenditures
11/30/17 Actual $ 9,525,698 6,026,967$
11/30/16 Actual $ 8,451,965 6,385,557$
% Change From Last Year 12.7%-5.6%
Unmetered Water
Water Sales Sales Connection Fees Meter Charges Miscellaneous
11/30/17 Actual $ 9,132,372 $ 47,413 $ 182,850 $ 21,112 $ 73,083
11/30/16 Actual $ 8,192,139 $ 39,992 $ 66,813 $ 21,224 $ 71,741
% Change From Last Year 11.5%18.6%173.7%-0.5%1.9%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
11/30/17 Actual 714,804$ 55,904$ 4,820,381$ 368,137$ 67,741$
11/30/16 Actual 753,525$ 61,343$ 5,105,977$ 388,410$ 76,302$
% Change From Last Year -5.1%-8.9%-5.6%-5.2%-11.2%
Five Year Trend
Expenditures by Department
11/30/16 11/30/17 11/30/17 11/30/17 2017 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Public Works 6,385,557$ 5,948,572$ 7,274,905$ 81.8%7,912,070$ (436,985)$
Engineering & Capital Projects - 78,395 2,867,035 0.0%3,178,045 78,395
Total Expenditures 6,385,557$ 6,026,967$ 10,141,940$ 59.4%11,090,115$ (358,590)$
Explanation of Major Changes From Last Year:
Water Sales revenue is up $940,233 compared to collections through November 2016. This is due to a 10% rate increase adopted January 1, 2017. Total Water Sales
revenue through November 2017 is over budget by $271,707 due to gallons billed being slightly higher than projected.
Water Connection Fees revenue is up $116,037 compared to collections through November 2016. This is due to construction of the Rush Midwest Orthopedics building.
Total Water Connection Fees revenue through November 2017 is over budget by $155,350 due to new development within the Village.
Operation & Contractual expenditures are down $285,596 compared to payments through November 2016. This is due to the timing of DuPage Water
Commission invoices being paid and the DuPage Water Commission rate increase being less than anticipated. Operation & Contractual expenditures through
November 2017 are under budget by $1,170,954 due to the timing of bills being paid to the timing of invoices being paid.
Capital Outlay expenditures are down $8,561 compared to payments through November 2016. This is due to general timing of payments. Capital Outlay expenditures
through November 2017 are under budget by $2,879,079 due to the meter replacement project happening later than originally planned.
Five Year Trend
Village of Oak Brook
Water Fund - Major Sources Five Year Trend
For the Period Ending November 30, 2017
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Sports Core Fund Consolidated Presentation
For the Period Ending November 30, 2017
11/30/17 11/30/17
11/30/17 YTD % of 2017 11/30/16 Difference
B&T Recreation Food &Golf Golf YTD Amended Amended Adopted YTD Prior
Programs Beverage Club Surcharge Total Budget Budget Budget Total Year
DIRECT REVENUES
Memberships 222,790$ 2,400$ 189,963$ -$ 415,153$ 457,580$ 91%443,580$ 404,518$ 10,635$
Greens Fees - - 937,814 - 937,814 898,000 104%840,000 896,914 40,900
Pro Shop Sales - - 175,595 - 175,595 199,315 88%190,000 188,178 (12,583)
Golf Lessons - - 43,359 - 43,359 30,250 143%30,250 40,053 3,306
Driving Range Fees - - 236,240 - 236,240 225,000 105%225,000 224,535 11,705
Rentals - - 362,364 - 362,364 362,850 100%327,850 368,008 (5,644)
Programs/User Fees 368,173 - - - 368,173 388,250 95%387,750 341,844 26,329
Food Sales - 176,908 - - 176,908 175,375 101%163,850 174,932 1,976
Beverage Sales - 267,271 - - 267,271 246,300 109%199,300 243,750 23,521
Other Revenue 193,625 185,863 19,757 - 399,245 350,850 114%351,900 356,019 43,226
Total Direct Revenues 784,588$ 632,442$ 1,965,092$ -$ 3,382,122$ 3,333,770$ 101%3,159,480$ 3,238,751$ 143,371$
DIRECT EXPENDITURES
Personnel 207,808$ 213,802$ 1,010,156$ -$ 1,431,766$ 1,467,160$ 98%1,609,185$ 1,437,237$ (5,471)$
Materials & Supplies 37,914 203,351 330,839 - 572,104 681,155 84%700,870 578,415 (6,311)
Operational & Contractual 629,595 107,818 271,027 - 1,008,440 1,048,065 96%1,047,630 997,684 10,756
Other - - (186,200) - (186,200) (206,200) 90%(206,200) (206,200) 20,000
Capital 51,521 94,750 70,017 - 216,288 211,500 102%226,000 127,155 89,133
Total Direct Expenditures 926,838$ 619,721$ 1,495,839$ -$ 3,042,398$ 3,201,680$ 95%3,377,485$ 2,934,291$ 108,107$
Direct Revenues Over (Under) Expenditures (142,250)$ 12,721$ 469,253$ -$ 339,724$ 132,090$ 257%(218,005)$ 304,460$ 35,264$
B&T Administration Overhead Allocation*159,840$ (159,840)$ -$ -$ -$ -$ 0%-$ -$ -$
Operating Revenues Over (Under) Expenditures 17,590$ (147,119)$ 469,253$ -$ 339,724$ 132,090$ 257%(218,005)$ 304,460$ 35,264$
Interfund Loan**-$ -$ -$ -$ -$ -$ 0%-$ -$ -$
Transfer From General Fund - - - - - 67,375 0%73,505 - -
Transfer From Infrastructure Fund 22,000 - - - 22,000 22,000 100%24,000 22,000 -
Transfer From Water Fund 7,337 - - - 7,337 7,315 100%8,000 7,337 -
Transfer To Golf Surcharge Fund - - - (431,457) (431,457) (510,000) 85%- - (431,457)
Adjusted Operating Revenues Over (Under) Expenditures 46,927$ (147,119)$ 469,253$ (431,457)$ (62,396)$ (281,220)$ (112,500)$ 333,797$ (396,193)$
*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
11/30/17 Actual $ 3,382,122 3,042,398$
11/30/16 Actual $ 3,238,751 2,934,291$
% Change From Last Year 4.4%3.7%
Driving Program/
Memberships Greens Fees Range Fees Rentals User Fees
11/30/17 Actual $ 415,153 $ 937,814 $ 236,240 $ 362,364 $ 368,173
11/30/16 Actual $ 404,518 $ 896,914 $ 224,535 $ 368,008 $ 341,844
% Change From Last Year 2.6%4.6%5.2%-1.5%7.7%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
11/30/17 Actual 1,431,766$ 572,104$ 1,008,440$ (186,200)$ 216,288$
11/30/16 Actual 1,437,237$ 578,415$ 997,684$ (206,200)$ 127,155$
% Change From Last Year -0.4%-1.1%1.1%0.0%70.1%
Five Year Trend
Revenues by Department 11/30/16 11/30/17 11/30/17 11/30/17 2017 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Programs 757,938$ 784,588$ 646,495$ 121.4%842,830$ 26,650$
Food & Beverage 576,894 632,442 127,800 494.9%532,350 53,148
Golf Club 1,903,919 1,965,092 567,997 346.0%1,784,300 61,173
Total Revenues 3,238,751$ 3,382,122$ 1,342,292$ 252.0%3,159,480$ 140,971$
Expenditures by Department 11/30/16 11/30/17 11/30/17 % of 2017 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Programs 918,641$ 926,838$ 344,363$ 269.1%992,140$ 8,197$
Food & Beverage 554,658 619,721 281,968 219.8%633,545 65,063
Golf Club 1,460,992 1,495,839 778,751 192.1%1,751,800 34,847
Total Expenditures 2,934,291$ 3,042,398$ 1,405,082$ 216.5%3,377,485$ 108,107$
Explanation of Major Changes From Last Year:
Memberships revenue is up $10,635 compared to collections through November 2016. This is due to an increase in Golf Club memberships compared to last
year. Total Memberships revenue through November 2017 is $42,427 under budget due to Bath & Tennis Club memberships being lower than projected.
Greens Fees revenue is up $40,900 compared to collections through November 2016. This is due to the weather allowing the golf course to open early in 2017.
Total Greens Fees revenue through November 2017 is $39,814 over budget due to the course opening early during the 2017 season.
Program/User Fees revenue is up $26,329 compared to collections through November 2016. This is due to the timing of field rental receipts being collected vs.
last year. Total Program/User Fees revenue through November 2017 is $20,077 over budget due to field rental receipts being received earlier than anticipated.
Capital Outlay expenditures are up $89,133 compared to payments through November 2016. This is due to the renovation project at the B&T Clubhouse in 2017.
Total Capital Outlay expenditures through November 2017 are $4,788 over budget due to the timing of the B&T renovation project.
Five Year Trend
Village of Oak Brook
Sports Core Fund - Major Sources Five Year Trend
For the Period Ending November 30, 2017
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Bath & Tennis Club Recreation Programs
For the Period Ending November 30, 2017 11/30/17 11/30/17
11/30/17 YTD % of 2017 11/30/16 Difference
811 812 813 815 816 YTD Amended Amended Adopted YTD Prior
B&T Admin Swimming Tennis Polo Open Fields Total Budget Budget Budget Total Year
Revenues:
Memberships -$ 211,240$ 11,550$ -$ -$ 222,790$ 273,080$ 82%273,080$ 224,531$ (1,741)$
Programs/User Fees (3,907) 88,738 16,784 - 266,558 368,173 388,250 95%387,750 341,844 26,329
Beverage Sales - - - - - - 300 0%300 - -
Other Revenue 2,055 3,070 125 - 188,375 193,625 181,650 107%181,700 191,563 2,062
Total Revenue (1,852)$ 303,048$ 28,459$ -$ 454,933$ 784,588$ 843,280$ 93%842,830$ 757,938$ 26,650$
Expenditures:
Personnel 138,316$ 36,823$ 21,907$ -$ 10,762$ 207,808$ 217,175$ 96%226,335$ 202,504$ 5,304$
Materials & Supplies 20,236 11,846 4,042 - 1,790 37,914 66,040 57%66,700 31,017 6,897
Operational & Contractual 134,767 169,490 34,376 30,000 260,962 629,595 635,475 99%638,105 640,000 (10,405)
Capital 828 30,070 - - 20,623 51,521 61,000 84%61,000 45,120 6,401
Total Expenditures 294,147$ 248,229$ 60,325$ 30,000$ 294,137$ 926,838$ 979,690$ 95%992,140$ 918,641$ 8,197$
Direct Revenues Over (Under) Expenditures (295,999)$ 54,819$ (31,866)$ (30,000)$ 160,796$ (142,250)$ (136,410)$ 104%(149,310)$ (160,703)$ 18,453$
B&T Administration Overhead Allocation*295,999$ (106,559)$ (29,600)$ -$ -$ 159,840$ 162,165$ 99%176,890$ 67,302$ 92,538$
Revenues Over (Under) Expenditures -$ (51,740)$ (61,466)$ (30,000)$ 160,796$ 17,590$ 25,755$ 68%27,580$ (93,401)$ 110,991$
Interfund Loan**-$ -$ -$ -$ -$ -$ -$ 0%-$ -$ -$
Transfer From General Fund - - - - - - 67,375 0%73,505 - -
Transfer From Infrastructure Fund 22,000 - - - - 22,000 22,000 100%24,000 22,000 -
Transfer From Water Fund 7,337 - - - - 7,337 7,315 100%8,000 7,337 -
Adjusted Revenues Over (Under) Expenditures 29,337$ (51,740)$ (61,466)$ (30,000)$ 160,796$ 46,927$ 122,445$ 133,085$ (64,064)$ 110,991$
*Overhead allocation is comprised of salaries, business forms, liability insurance, building & grounds maintenance and bank service fees in Program 811 - Sports Core
General Operations distributed to various Sports Core Programs on a percentage basis.
**Interfund loan is from the General Fund.
Village of Oak Brook
Monthly Operating Statement
Sports Core Food & Beverage Programs
For the Period Ending November 30, 2017
11/30/17 11/30/17
821 822 823 11/30/17 YTD % of 2017 11/30/16 Difference
B&T Poolside Golf YTD Amended Amended Adopted YTD Prior
Clubhouse Café Clubhouse Total Budget Budget Budget Total Year
Revenues:
Memberships 2,400$ -$ -$ 2,400$ 4,500$ 53%4,500$ -$ -$
Food Sales - 40,263 136,645 176,908 175,375 101%163,850 174,932 1,976
Beverage Sales - 21,005 246,266 267,271 246,000 109%199,000 243,750 23,521
Other Revenue 185,863 - - 185,863 164,000 113%165,000 158,212 27,651
Total Revenue 188,263$ 61,268$ 382,911$ 632,442$ 589,875$ 107%532,350$ 576,894$ 53,148$
Expenditures:
Personnel 82,859$ 21,625$ 109,318$ 213,802$ 218,580$ 98%226,890$ 205,679$ 8,123$
Materials & Supplies 4,167 38,641 160,543 203,351 210,465 97%210,920 200,550 2,801
Operational & Contractual 98,718 2,122 6,978 107,818 152,275 71%160,735 148,429 (40,611)
Capital 78,377 16,373 - 94,750 35,000 271%35,000 - 94,750
Total Expenditures 264,121$ 78,761$ 276,839$ 619,721$ 616,320$ 101%633,545$ 554,658$ 65,063$
Direct Revenues Over (Under) Expenditures (75,858)$ (17,493)$ 106,072$ 12,721$ (26,445)$ -48%(101,195)$ 22,236$ (9,515)$
B&T Administration Overhead Allocation*(148,000)$ (11,840)$ -$ (159,840)$ (162,165)$ 99%(176,890)$ (67,302)$ (92,538)$
Revenues Over (Under) Expenditures (223,858)$ (29,333)$ 106,072$ (147,119)$ (188,610)$ 78%(278,085)$ (45,066)$ (102,053)$
Transfer From General Fund -$ -$ -$ -$ -$ 0%-$ -$ -$
Adjusted Revenues Over (Under) Expenditures (223,858)$ (29,333)$ 106,072$ (147,119)$ (188,610)$ (278,085)$ (45,066)$ (102,053)$
*Overhead allocation is comprised of salaries, business forms, liability insurance, building & grounds maintenance and bank service fees in Program 811 -
Sports Core General Operations distributed to various Sports Core Programs on a percentage basis.
Village of Oak Brook
Monthly Operating Statement
Golf Club Programs
For the Period Ending November 30, 2017
11/30/17 11/30/17
831 832 833 834 11/30/17 YTD % of 2017 11/30/16 Difference
Golf General Golf Learning Golf Cart Golf Course YTD Amended Amended Adopted YTD Prior
Operation & Practice Operations Maintenance Total Budget Budget Budget Total Year
Revenues:
Memberships 189,963$ -$ -$ -$ 189,963$ 180,000$ 106%166,000$ 179,987$ 9,976$
Greens Fees 937,814 - - - 937,814 898,000 104%840,000 896,914 40,900
Pro Shop Sales 175,595 - - - 175,595 199,315 88%190,000 188,178 (12,583)
Golf Lessons - 43,359 - - 43,359 30,250 143%30,250 40,053 3,306
Driving Range Fees - 236,240 - - 236,240 225,000 105%225,000 224,535 11,705
Rentals 4,348 - 358,016 - 362,364 362,850 100%327,850 368,008 (5,644)
Other Revenue 19,757 - - - 19,757 5,200 380%5,200 6,244 13,513
Total Revenue 1,327,477$ 279,599$ 358,016$ -$ 1,965,092$ 1,900,615$ 103%1,784,300$ 1,903,919$ 61,173$
Expenditures:
Personnel 439,934$ 77,320$ 51,092$ 441,810$ 1,010,156$ 1,031,405$ 98%1,155,960$ 1,029,054$ (18,898)$
Materials & Supplies 129,052 11,243 4,437 186,107 330,839 404,650 82%423,250 346,848 (16,009)
Operational & Contractual 206,184 14,077 6,054 44,712 271,027 260,315 104%248,790 209,255 61,772
Other - - - (186,200) (186,200) (206,200) 90%(206,200) (206,200) 20,000
Capital 33,617 8,526 - 27,874 70,017 115,500 61%130,000 82,035 (12,018)
Total Expenditures 808,787$ 111,166$ 61,583$ 514,303$ 1,495,839$ 1,605,670$ 93%1,751,800$ 1,460,992$ 34,847$
Direct Revenues Over (Under) Expenditures 518,690$ 168,433$ 296,433$ (514,303)$ 469,253$ 294,945$ 159%32,500$ 442,927$ 26,326$
Transfer from General Fund -$ -$ -$ -$ -$ -$ 0%-$ -$ -$
Adjusted Revenues Over (Under) Expenditures 518,690$ 168,433$ 296,433$ (514,303)$ 469,253$ 294,945$ 32,500$ 442,927$ 26,326$