12 - December 2017 Monthly Financial ReportVILLAGE
OAK BROOK
OF
MONTHLY FINANCIAL REPORTS
DECEMBER 2017
Total
Cash and Cash Pooled Cash and
Fund Equivalents Investments Investments % By Fund
General Corporate $4,568,437 $13,118,776 $17,687,213 44.3%
Hotel/Motel Tax 1,954,035 2,218,199 4,172,234 10.4%
Motor Fuel Tax 231,525 480,365 711,890 1.8%
Infrastructure 4,743,960 3,366,467 8,110,427 20.3%
Promenade TIF 242,824 - 242,824 0.6%
Water 4,834,129 858,980 5,693,109 14.3%
Sports Core 472,483 - 472,483 1.2%
Golf Surcharge 14,525 544,549 559,074 1.4%
Self-Insurance 45,042 - 45,042 0.1%
Garage 427,409 - 427,409 1.1%
Equipment Replacement 847,089 958,574 1,805,663 4.5%
Total $18,381,458 $21,545,910 $39,927,368 100.0%
Change in Cash and Investments by Fund :
Balance at Balance at Year-to-Date Year-to-Date
Fund January 1, 2017 December 31, 2017 Change ($)Change (%)
General Corporate $16,586,097 $17,687,213 $1,101,116 6.6%
Hotel/Motel Tax 4,415,721 4,172,234 (243,487)-5.5%
Motor Fuel Tax 909,926 711,890 (198,036)-21.8%
Infrastructure 5,436,080 8,110,427 2,674,347 49.2%
Promenade TIF 249,278 242,824 (6,454)-2.6%
Water 2,732,210 5,693,109 2,960,899 108.4%
Sports Core 701,448 472,483 (228,965)-32.6%
Golf Surcharge 0 559,074 559,074 N/A
Self-Insurance 589,849 45,042 (544,807)-92.4%
Garage 347,053 427,409 80,356 23.2%
Equipment Replacement 1,510,026 1,805,663 295,637 19.6%
$33,477,689 $39,927,368 $6,449,679 19.3%
Book Market
Value Value
Pooled Checking $666,296 $666,296
Sports Core Checking 487,224 487,224
Pooled IPTIP 17,218,045 17,218,045
Water E-Pay IPTIP 9,893 9,893
$18,381,458 $18,381,458
Pooled Investments:
Investments-Municipal $9,304,761 $9,236,009
Investments-Corporate 4,275,313 4,272,057
Government & Agency Obligations 867,456 844,315
Certificates of Deposit 6,965,000 6,933,416
Accrued Interest 133,380 133,380
Total Pooled Investments $21,545,910 $21,419,177
Total Cash and Investments $39,927,368 $39,800,635
For December, total interest revenue is $49,617 and year to date is $453,699.
Total investment yield for the portfolio is:
Pooled
Investments Illinois Funds Total
Monthly yield 0.14%0.13%0.14%
YTD yield 1.47%0.94%1.25%
Last 12 months yield 1.47%0.94%1.25%
The weighted average yield of the current pooled investment portfolio is 1.70%.
Monthly Treasurer's Report
December 31, 2017
Monthly Treasurer's Report
December 2017
The table below lists the detail investment holdings at J.P. Morgan Securities as of 12/31/17:
Month End VOB
Settlement Maturity Coupon Yield Book Market Accrued
Type Date Date Rate Rate Value Value Interest
Municipal Bonds:
Public Utility District #181117EP3 09/02/14 1/1/2018 1.667%1.650%$600,000 $600,000 $5,001
Florida Hurricane #34074GDG6 01/05/15 7/1/2018 2.107%2.090%751,139 750,263 7,888
Maryland St Econ Dev #57420PGK6 07/08/15 6/1/2019 2.050%2.123%99,897 99,997 169
Rosemont IL GO Corp #777543UT4 02/08/16 12/1/2019 3.021%2.000%509,534 503,115 1,163
New York St Urban Dev Corp #650035J58 02/22/16 3/15/2018 1.650%1.150%175,176 175,005 841
New York N Y City #64971QTX1 02/22/16 5/1/2021 2.350%2.000%202,240 199,820 769
Florida Hurricane #34074GDH4 03/30/16 7/1/2020 2.995%2.150%510,185 506,545 7,487
Bloomingdale Mich Pub Sch Dist #094383FS0 04/26/16 5/1/2022 2.710%2.150%511,513 500,500 2,219
Milan Mich Area Achs #598801JD1 05/26/16 5/1/2020 1.931%1.931%245,000 243,861 688
Indiana Bd Bk Rev Taxable #4546248F7 01/06/17 1/15/2020 2.934%1.900%260,232 258,330 3,463
North Carolina Eastn Mun PWR #65819WAC7 01/30/17 7/1/2018 2.003%1.450%701,903 700,238 7,010
Garland Cnty Ark Sales & Use #36609PAN3 02/06/17 11/1/2019 1.795%1.840%499,593 494,895 1,621
Anchor Bay Mich Sch Dist GO #032879TA6 02/13/17 5/1/2019 1.810%1.420%366,882 364,047 1,024
Macomb Cnty Mich Retirees #554885H63 04/11/17 11/1/2018 1.731%1.300%401,429 399,304 1,111
Lanse Creuse Mich Pub Schs #516228RL9 05/02/17 5/1/2020 2.159%2.159%100,000 100,005 357
California St GO Bonds #13063A7G3 05/08/17 10/1/2019 6.200%1.600%539,680 535,875 7,468
*Genesee Cnty Mich #371608UV0 05/31/17 10/1/2019 1.960%1.960%580,000 580,011 838
Connecticut St GO Bds 2016 #20772J3F7 06/15/17 8/15/2021 1.750%2.300%490,478 474,565 3,252
North Carolina Eastn Mun Pwr #65819WAL7 10/02/17 7/1/2019 2.578%1.700%506,507 503,565 6,302
Fowlerville Mich Comnty Schs #351280MS8 10/03/17 5/1/2020 2.045%1.750%503,373 498,850 1,534
Racine Cnty WI #38379UEM4 12/20/17 12/1/2020 2.150%2.150%750,000 747,218 493
Total Municipal Bonds $9,304,761 $9,236,009 $60,698
Corporate Bonds:
JP Morgan Chase #46625HJG6 06/08/17 1/25/2018 1.800%1.371%$845,244 $844,932 $6,536
Goldman Sachs Group #38141GRC0 06/08/17 1/22/2018 2.375%1.531%1,000,499 1,000,200 10,404
Wachovia #92976WBH8 06/15/17 2/1/2018 5.750%1.360%1,036,949 1,036,202 24,387
Morgan Stanley #6174467U7 08/28/17 4/25/2018 2.125%1.531%1,392,621 1,390,723 5,369
Total Corporate Bonds $4,275,313 $4,272,057 $46,696
Government & Agency Obligations:
**Government National Mtg Assn #38379UEM4 02/29/16 2/16/2051 2.300%2.245%$867,456 $844,315 $3,762
Total Government & Agency Obligations:$867,456 $844,315 $3,762
Certificates of Deposit:
Capital One Natl Assn VA #14042E5Z9 08/26/15 8/27/2018 1.75%1.75%$245,000 $245,211 $279
Ally Bk Midvale Utah #02006LVC4 10/29/15 10/29/2018 1.60%1.60%245,000 245,096 653
Wex Bank Midvale Utah #92937CDY1 07/29/16 7/30/2018 1.00%1.00%245,000 244,302 1,035
Bank Hope Los Angeles #062683AB3 08/26/16 8/27/2018 1.00%1.00%245,000 243,969 25
Wells Fargo Bank Natl Assn #949763AL0 08/31/16 8/31/2018 1.10%1.10%245,000 243,969 234
BMW Bank #05580AFG4 09/23/16 9/24/2018 1.10%1.10%245,000 243,822 726
Comenity Cap Bank #20033ASB3 09/26/16 9/26/2018 1.10%1.10%245,000 243,802 32
Enerbank #29266N4E4 10/21/16 10/22/2018 1.10%1.10%245,000 243,947 524
Discover Bank #254672L71 10/26/16 10/26/2018 1.20%1.20%245,000 243,581 531
State Bk India NY #8562846A7 01/26/17 1/26/2022 2.25%2.25%245,000 244,633 2,396
Marlin Business Bk #57116ANU8 05/10/17 11/12/2019 1.60%1.60%245,000 243,302 217
American Express Fed Svgs #02587CER7 05/10/17 11/12/2019 1.70%1.70%245,000 243,172 573
Synchrony Bank #87164WRA8 05/26/17 5/28/2019 1.65%1.65%245,000 244,316 354
Umpqua Bank #90421MAG8 05/31/17 5/31/2019 1.60%1.60%245,000 244,135 332
Stone Bk Mtn View Ark #86158RAJ8 06/28/17 6/28/2019 1.60%1.60%245,000 244,010 16
Investors Savings Bk #46176PGU3 06/30/17 4/2/2018 1.35%1.35%245,000 244,966 1,654
TIAA FSB Jacksonville #87270LAA1 07/19/17 7/19/2019 1.60%1.60%245,000 243,915 1,764
Peoples United Bank #71270QQZ2 07/19/17 7/19/2019 1.65%1.65%245,000 244,103 1,819
Priority Bank Ozark Ark #74269KBR6 07/26/17 7/26/2019 1.60%1.60%245,000 243,878 45
American Express Centurion #02587DV96 08/15/17 8/17/2020 1.90%1.90%245,000 242,675 1,746
Sallie Mae #795450C86 08/16/17 8/17/2020 1.90%1.90%245,000 243,608 1,746
Merrick Bank South Jordan #59013JZS1 08/21/17 8/21/2020 1.80%1.80%245,000 242,959 118
Pinnacle Bank #72345SFS5 08/30/17 8/31/2020 1.80%1.80%115,000 114,019 174
Jackson County Bank #466682AP6 08/31/17 3/1/2021 1.85%1.85%245,000 242,386 1,511
Barclays Bank #06740KKX4 09/27/17 9/28/2020 1.95%1.95%245,000 243,751 1,234
Capital One Bank #1404205E6 10/04/17 10/4/2019 1.70%1.70%245,000 243,949 995
Transportation Alliance #89388CCB2 10/13/17 4/12/2019 1.60%1.60%235,000 234,356 176
Goldman Sachs Bank #38148PRK5 10/18/17 10/19/2020 1.95%1.95%245,000 243,657 956
FirstBank PR Santurce #33767A6M8 11/03/17 11/3/2020 2.00%2.00%245,000 243,927 359
Total Certificates of Deposits $6,965,000 $6,933,416 $22,224
Total J.P.Morgan Securities $21,412,530 $21,285,797 $133,380
*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
December 31, 2017
Cash & Investments by Fund - Total $39.9 million
Cash & Investments by Type - Total $39.9 million
Checking
Illinois Funds
Certificates of Deposit
Municipal Bonds
Corporate Bonds
Government & Agency Obligations
Accrued Interest
General Corporate
44.30%
Hotel/Motel Tax
10.45%Motor Fuel Tax
1.78%
Infrastructure
20.31%
Promenade TIF
0.61%
Water
14.26%
Sports Core
1.18%
Golf Surcharge
1.40%
Self-Insurance
0.11%Garage
1.07%
Equipment
Replacement
4.52%
Checking, $1.2
Illinois Funds, $17.2
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 Budget
Increase Increase
Governmental Funds Revenues Expenditures (Decrease)(Decrease)
General Fund (Major Fund)$24,438,020 $23,315,712 $1,122,308 ($356,158)
Main operating fund of the Village.
Hotel Fund (Major Fund)$1,381,983 $1,459,023 ($77,040)($1,238,875)
Collects and spends resources from the
3% hotel/motel tax.
Motor Fuel Tax Fund $212,988 $411,024 ($198,036)($352,565)
Collects and spends resources from the
State motor fuel tax.
Infrastructure Fund (Major Fund)$6,345,828 $3,418,564 $2,927,264 $1,877,480
Accounts for construction and maintenance of
roadways, drainage, and safety path systems.
Promenade TIF Fund (Major Fund)$451,884 $458,338 ($6,454)($2,850)
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,872,565 $6,549,805 $3,322,760 ($1,744,615)
Collects user fees for the distribution of water
and maintenance of infrastructure.
Sports Core Fund (Major Fund)$3,445,101 $3,646,045 ($200,944)($356,475)
Accounts for revenues and expenses relating
to administration, programs, food and beverage
operations, and golf course.
Golf Surcharge Fund $557,911 $0 $557,911 $629,500
Accounts for the collection of the $3 per round
golf surcharge.
Internal Service Funds
Self Insurance Fund $3,086,921 $3,368,043 ($281,122)($35,150)
Accounts for the Village's health insurance costs
and the related contributions from the Village,
employees, retirees, and other agencies.
Garage Fund $748,260 $601,483 $146,777 ($74,200)
Accounts for the maintenance of the Village's vehicle
fleet and the related departmental reimbursements.
Equipment Replacement Fund $802,702 $1,251,644 ($448,942)$193,960
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 December, 2017
12/31/17 12/31/17
12/31/16 12/31/17 YTD % of 2017 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 12,975,476$ 12,497,499$ 13,048,000$ 96%13,048,000$ (477,977)$
Other Intergovernmental Tax 1,268,351 1,334,662 1,265,235 105%1,265,235 66,311
Telecommunications/Utility Tax 6,023,946 6,009,125 5,638,000 107%5,638,000 (14,821)
Licenses and Permits 1,881,997 2,196,112 1,711,750 128%1,711,750 314,115
Charges for Services 1,056,338 1,028,509 1,006,750 102%1,006,750 (27,829)
Fines and Penalties 158,961 142,394 153,590 93%153,590 (16,567)
Administrative Towing Fees 31,955 39,915 50,000 80%50,000 7,960
Interest on Investments 150,804 233,804 125,000 187%125,000 83,000
Franchise/IMF Maint. Fee 219,838 162,548 207,200 78%207,200 (57,290)
Reimbursements From Other Funds 628,025 617,300 617,300 100%617,300 (10,725)
Miscellaneous Income 232,161 176,152 231,675 76%231,675 (56,009)
Total Operating Revenues 24,627,852$ 24,438,020$ 24,054,500$ 102%24,054,500$ (189,832)$
OPERATING EXPENDITURES
Personnel 16,269,666$ 17,112,781$ 17,704,865$ 97%17,788,210$ 843,115$
Materials and Supplies 429,678 454,112 554,530 82%554,530 24,434
Operation and Contract 3,626,267 3,998,131 4,344,325 92%4,344,325 371,864
Other Expenditures 424,358 418,100 418,100 100%418,100 (6,258)
Capital Outlay 537,681 1,332,588 1,315,333 101%805,310 794,907
Total Operating Expenditures 21,287,650$ 23,315,712$ 24,337,153$ 96%23,910,475$ 2,028,062$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 3,340,202$ 1,122,308$ (282,653)$ 144,025$ (2,217,894)$
INTERFUND TRANSACTIONS
Transfers Out -$ -$ (73,505)$ 0%(73,505)$ -$
Total Interfund Transactions -$ -$ (73,505)$ 0%(73,505)$ -$
NET FUND INCREASE (DECREASE)3,340,202$ 1,122,308$ (356,158)$ 70,520$ (2,217,894)$
Village of Oak Brook
General Fund Financial Update
For the Period Ending December 31, 2017
Total Total
Revenues Expenditures
12/31/17 Actual $ 24,438,020 23,315,712$
12/31/16 Actual $ 24,627,852 21,287,650$
% Change From Last Year -0.8%9.5%
Major Revenues Other
Intergov.Licenses &Charges for
Sales Tax Tax Telecom Tax Permits Services
12/31/17 Actual $ 12,497,499 $ 1,334,662 $ 6,009,125 $ 2,196,112 1,028,509
12/31/16 Actual $ 12,975,476 $ 1,268,351 $ 6,023,946 $ 1,881,997 1,056,338
% Change From Last Year -3.7%5.2%-0.2%16.7%-2.6%
Five Year Trend
Major Expenditures Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
12/31/17 Actual 17,112,781$ 454,112$ 3,998,131$ 418,100 1,332,588$
12/31/16 Actual 16,269,666$ 429,678$ 3,626,267$ 424,358 537,681$
% Change From Last Year 5.2%5.7%10.3%-1.5%147.8%
Five Year Trend
Expenditures by Department
12/31/16 12/31/17 12/31/17 12/31/17 2017 Difference Five
YTD YTD YTD % of Annual Prior Year
Department Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 2,201,507$ 2,633,206$ 2,935,300$ 89.7%2,883,255$ 431,699$
Financial Services 1,167,780 1,094,738 1,189,950 92.0%1,116,445 (73,042)
Public Works 598,082 693,058 752,340 92.1%752,340 94,976
Engineering & Capital Projects 363,804 844,438 799,178 105.7%372,500 480,634
Library 953,572 878,459 989,470 88.8%989,470 (75,113)
Police 8,020,567 8,373,617 8,609,255 97.3%8,609,255 353,050
Fire 7,041,850 7,822,048 8,153,055 95.9%8,205,100 780,198
Development Services 940,488 976,148 982,110 99.4%982,110 35,660
Total Expenditures 21,287,650$ 23,315,712$ 24,410,658$ 95.5%23,910,475$ 2,028,062$
Explanation of Major Changes From Last Year:
Sales Tax revenue is down $477,977 compared to revenue through December 2016. This is due to non-routine receipts received from a top taxpayer in 2016. Total Sales Tax
revenue through December 2017 is $550,501 under budget due to the timing of receipts from new businesses and slowed retail growth.
Other Intergovernmental Tax revenue is up $66,311 compared to revenue through December 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 December 2017 is $69,427 over budget.
Telecommunications Tax revenue is down $14,821 compared to revenue through December 2016. Total Telecommunications Tax revenue through December 2017 is
$371,125 over budget.
Licenses & Permits revenue is up $314,115 compared to collections through December 2016. This is primarily due to increases in building permits and accessory structure
permits. Total Licenses & Permits revenue through December 2017 is over budget by $484,362.
Personnel expenditures are up $843,115 comapred to payments through December 2016. This is primarily due to general increases in wages, insurance, and pension
payments. Total Personnel expenditures through December 2017 are $592,084 under budget due to turnover and public safety pensions being funded lower than budgeted.
Operation & Contractual expenditures are up $371,864 compared to payments through December 2016. This is due to increased litigation services and increases in liability
insurance premiums and claims. Total Operation & Contractual expenditures through December 2017 are $346,194 under budget due to general timing of payments.
Capital Outlay expenditures are up $794,907 compared to payments through December 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 December 2017 are $17,255 over budget.
Five Year Trend
For the Period Ending December 31, 2017
General Fund - Five Year Trend
Village of Oak Brook
Revenues Expenditures
12/31/17 12/31/17
12/31/16 12/31/17 YTD % of 2017 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Hotel Tax 1,244,575$ 1,287,887$ 1,266,000$ 102%1,266,000$ 43,312$
Interest 33,416 50,001 22,000 227%22,000 16,585
Miscellaneous - 44,095 - N/A - 44,095
Total Operating Revenues 1,277,991$ 1,381,983$ 1,288,000$ 107.3%1,288,000$ 103,992$
EXPENDITURES
Operation and Contract 347,931$ 386,114$ 595,975$ 65%595,975$ 38,183$
Other Expenditures 90,305 93,400 93,400 100%93,400 3,095
Capital Outlay 213,576 979,509 1,837,500 53%1,837,500 765,933
Total Expenditures 651,812$ 1,459,023$ 2,526,875$ 57.7%2,526,875$ 807,211$
NET FUND INCREASE (DECREASE)626,179$ (77,040)$ (1,238,875)$ (1,238,875)$ (703,219)$
Note - Expenditures are recorded in program 171.
Village of Oak Brook
Hotel Tax Fund Financial Update
For the Period Ending December 31, 2017
Total Total
Revenues Expenditures
12/31/17 Actual $ 1,381,983 1,459,023$
12/31/16 Actual $ 1,277,991 651,812$
% Change From Last Year 8.1%123.8%
Major Revenues
Grants Hotel Tax Interest Miscellaneous
12/31/17 Actual $ - $ 1,287,887 $ 50,001 $ 44,095
12/31/16 Actual $ - $ 1,244,575 $ 33,416 $ -
% Change From Last Year 0.0%3.5%49.6%N/A
Five Year Trend
Major Expenditures Operation &Other
Contractual Expenditures Capital Outlay
12/31/17 Actual 386,114$ 93,400$ 979,509$
12/31/16 Actual 347,931$ 90,305$ 213,576$
% Change From Last Year 11.0%3.4%358.6%
Five Year Trend
Explanation of Major Changes From Last Year:
Hotel Tax revenue is up $43,312 compared to collections through December 2016. This is related to the timing of
receipts. Total Hotel Tax revenue through December 2017 is over budget by $21,887 because of general increases in
receipts and the timing of when receipts have been received.
Operation & Contractual expenditures are up $38,183 compared to payments through December 2016. This is related to
engineering costs for a 22nd Street beautification project. Total Operation & Contractual expenditures through
December 2017 are under budget by $209,861 due to the timing of DCVB quarterly dues and advertising payments.
Capital Outlay expenditures are up $765,933 compared to payments through December 2016. This is related to 22nd St.
construction costs that were delayed from 2016. Total Capital Outlay expenditures through December 2017 are
under budget by $857,991 due to the timing of payments.
Village of Oak Brook
Hotel Tax Fund - Major Sources Five Year Trend
For the Period Ending December 31, 2017
Five Year Trend
Revenues Expenditures
12/31/17 12/31/17
12/31/16 12/31/17 YTD % of 2017 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 5,975,037$ 5,690,315$ 5,982,000$ 95%5,982,000$ (284,722)$
Grants - 3,142 - N/A - 3,142
Interest 42,802 80,387 27,500 292%27,500 37,585
Miscellaneous 24,160 5,745 5,000 115%5,000 (18,415)
Reimbursements From Other Funds 180,035 176,635 176,635 100%176,635 (3,400)
Total Operating Revenues 6,222,034$ 5,956,224$ 6,191,135$ 96%6,191,135$ (265,810)$
OPERATING EXPENDITURES
Personnel 1,555,921 1,142,736$ 1,314,465$ 87%1,474,390$ (413,185)$
Materials and Supplies 103,910 90,757 351,095 26%351,095 (13,153)
Operation and Contract 1,406,576 1,488,688 1,292,360 115%1,132,435 82,112
Other Expenditures 155,000 162,500 162,500 100%162,500 7,500
Capital Outlay 2,363,966 533,883 1,755,000 30%1,755,000 (1,830,083)
-
Total Operating Expenditures 5,585,373$ 3,418,564$ 4,875,420$ 70%4,875,420$ (2,166,809)$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 636,661$ 2,537,660$ 1,315,715$ 193%1,315,715$ 1,900,999$
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,152,882$ 2,927,264$ 1,877,480$ 1,877,480$ 1,774,382$
Village of Oak Brook
Infrastructure Fund Financial Update
For the Period Ending December 31, 2017
Total Total
Revenues Expenditures
12/31/17 Actual $ 5,956,224 3,418,564$
12/31/16 Actual $ 6,222,034 5,585,373$
% Change From Last Year -4.3%-38.8%
Major Revenues
Sales Tax Grants Interest Miscellaneous Reimbursements
12/31/17 Actual $ 5,690,315 $ 3,142 $ 80,387 $ 5,745 $ 176,635
12/31/16 Actual $ 5,975,037 $ - $ 42,802 $ 24,160 $ 180,035
% Change From Last Year -4.8%N/A 87.8%-76.2%-1.9%
Five Year Trend
Major Expenditures Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
12/31/17 Actual 1,142,736$ 90,757$ 1,488,688$ 162,500$ 533,883$
12/31/16 Actual 1,555,921$ 103,910$ 1,406,576$ 155,000$ 2,363,966$
% Change From Last Year -26.6%-12.7%5.8%4.8%-77.4%
Five Year Trend
Expenditures by Department
12/31/16 12/31/17 12/31/17 12/31/17 2017 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 176,820$ 164,906$ 174,430$ 94.5%174,430$ (11,914)$
Public Works 2,061,790 2,254,560 2,697,845 83.6%2,697,845 192,770
Engineering & Capital Projects 3,346,763 999,098 2,003,145 49.9%2,003,145 (2,347,665)
Total Expenditures 5,585,373$ 3,418,564$ 4,875,420$ 70.1%4,875,420$ (2,166,809)$
Explanation of Major Changes From Last Year:
Sales Tax revenue is down $284,722 compared to revenue through December 2016. This is due to non-routine receipts received from a top taxpayer in 2016. Total
Sales Tax revenue through December 2017 is $291,685 under budget due to the timing of receipts from new businesses and slowed retail growth.
Personnel expenditures are down $413,185 compared to payments through December 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 December 2017 are $171,729
under budget due to less time spent on snow removal.
Operation & Contractual expenditures are up $82,112 compared to payments through December 2016. This is due to payments for outsourced engineering services
that started in 2017. Total Operation & Contractual expenditures through December 2017 are $196,328 over budget due to the timing of general maintenance
payments.
Capital Outlay expenditures are down $1,830,083 compared to payments through December 2016. This is due to the timing of payments. Total Capital Outlay
expenditures through December 2017 are $1,221,117 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 December 31, 2017
Revenues Expenditures
12/31/17 12/31/17
12/31/16 12/31/17 YTD % of 2017 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 69,262$ 65,941$ 100,500$ 66%100,500$ (3,321)$
Real Estate Tax 354,829 385,018 355,000 108%355,000 30,189
Interest 388 925 100 925%100 537
Total Operating Revenues 424,479$ 451,884$ 455,600$ 99%455,600$ 27,405$
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,679)$ (6,454)$ (2,850)$ (2,850)$ 8,225$
Note - Expenditures are recorded in program 283.
Village of Oak Brook
Promenade TIF Fund Financial Update
For the Period Ending December 31, 2017
Total Total
Revenues Expenditures
12/31/17 Actual $ 451,884 458,338$
12/31/16 Actual $ 424,479 439,158$
% Change From Last Year 6.5%4.4%
Major Revenues Real Estate
Sales Tax Tax Interest
12/31/17 Actual $ 65,941 $ 385,018 $ 925
12/31/16 Actual $ 69,262 $ 354,829 $ 388
% Change From Last Year -4.8%8.5%138.4%
Five Year Trend
Major Expenditures Operation &Other
Contractual Expenditures
12/31/17 Actual 3,958$ 454,380$
12/31/16 Actual 3,938$ 435,220$
% Change From Last Year 0.5%4.4%
Five Year Trend
Explanation of Major Changes From Last Year:
Real Estate Tax revenue is up $30,189 compared to revenue through December 2016. This is due to general property value
increases within the TIF. Total Real Estate Tax revenue through December 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 December 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 December.
Village of Oak Brook
Promenade TIF Fund - Major Sources Five Year Trend
For the Period Ending December 31, 2017
Five Year Trend
Revenues Expenditures
12/31/17 12/31/17
12/31/16 12/31/17 YTD % of 2017 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Grants -$ 3,386$ -$ N/A -$ 3,386$
Plan Review Fees 1,809 2,314 2,000 116%2,000 505
Building/Inspection Fees 5,988 11,839 4,500 263%4,500 5,851
Water Sales 8,448,806 9,446,192 9,143,000 103%9,143,000 997,386
Unmetered Sales 41,794 50,422 25,000 202%25,000 8,628
Water Connection Fees 69,573 187,680 30,000 626%30,000 118,107
Fire Service Charge 9,486 - 10,000 0%10,000 (9,486)
Meter Charges 22,907 22,979 25,000 92%25,000 72
Special Services 31,241 15,858 31,000 51%31,000 (15,383)
Interest on Investments 14,130 42,796 10,000 428%10,000 28,666
Miscellaneous 85,959 89,099 65,000 137%65,000 3,140
Total Operating Revenues 8,731,693$ 9,872,565$ 9,345,500$ 106%9,345,500$ 1,140,872$
EXPENDITURES
Personnel 821,447$ 777,335$ 835,110$ 93%835,110$ (44,112)$
Materials and Supplies 68,614 67,229 70,660 95%70,660 (1,385)
Operation and Contract 5,551,532 5,207,710 6,547,735 80%6,547,735 (343,822)
Other Expenditures 423,720 401,600 401,600 100%401,600 (22,120)
Capital Outlay 80,383 95,931 3,235,010 3%3,235,010 15,548
Total Expenditures 6,945,696$ 6,549,805$ 11,090,115$ 59%11,090,115$ (395,891)$
NET FUND INCREASE (DECREASE)1,785,997$ 3,322,760$ (1,744,615)$ (1,744,615)$ 1,536,763$
Village of Oak Brook
Water Fund Financial Update
For the Period Ending December 31, 2017
Total Total
Revenues Expenditures
12/31/17 Actual $ 9,872,565 6,549,805$
12/31/16 Actual $ 8,731,693 6,945,696$
% Change From Last Year 13.1%-5.7%
Unmetered Water
Water Sales Sales Connection Fees Meter Charges Miscellaneous
12/31/17 Actual $ 9,446,192 $ 50,422 $ 187,680 $ 22,979 $ 89,099
12/31/16 Actual $ 8,448,806 $ 41,794 $ 69,573 $ 22,907 $ 85,959
% Change From Last Year 11.8%20.6%169.8%0.3%3.7%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
12/31/17 Actual 777,335$ 67,229$ 5,207,710$ 401,600$ 95,931$
12/31/16 Actual 821,447$ 68,614$ 5,551,532$ 423,720$ 80,383$
% Change From Last Year -5.4%-2.0%-6.2%-5.2%19.3%
Five Year Trend
Expenditures by Department
12/31/16 12/31/17 12/31/17 12/31/17 2017 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Public Works 6,945,696$ 6,430,813$ 7,912,070$ 81.3%7,912,070$ (514,883)$
Engineering & Capital Projects - 118,992 3,178,045 0.0%3,178,045 118,992
Total Expenditures 6,945,696$ 6,549,805$ 11,090,115$ 59.1%11,090,115$ (395,891)$
Explanation of Major Changes From Last Year:
Water Sales revenue is up $997,386 compared to collections through December 2016. This is due to a 10% rate increase adopted January 1, 2017. Total Water Sales
revenue through December 2017 is over budget by $303,192 due to gallons billed being slightly higher than projected.
Water Connection Fees revenue is up $118,107 compared to collections through December 2016. This is due to construction of the Rush Midwest Orthopedics building.
Total Water Connection Fees revenue through December 2017 is over budget by $157,680 due to new development within the Village.
Operation & Contractual expenditures are down $343,822 compared to payments through December 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
December 2017 are under budget by $1,340,025 due to the timing of bills being paid to the timing of invoices being paid.
Capital Outlay expenditures are up $15,548 compared to payments through December 2016. This is due to general timing of payments. Capital Outlay expenditures
through December 2017 are under budget by $3,139,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 December 31, 2017
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Sports Core Fund Consolidated Presentation
For the Period Ending December 31, 2017
12/31/17 12/31/17
12/31/17 YTD % of 2017 12/31/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 - - 942,506 - 942,506 898,000 105%840,000 897,480 45,026
Pro Shop Sales - - 181,149 - 181,149 200,000 91%190,000 195,512 (14,363)
Golf Lessons - - 43,359 - 43,359 30,250 143%30,250 40,053 3,306
Driving Range Fees - - 236,520 - 236,520 225,000 105%225,000 224,558 11,962
Rentals - - 364,563 - 364,563 362,850 100%327,850 368,137 (3,574)
Programs/User Fees 370,173 - - - 370,173 387,750 95%387,750 343,394 26,779
Food Sales - 177,514 - - 177,514 175,375 101%163,850 174,964 2,550
Beverage Sales - 268,679 - - 268,679 246,300 109%199,300 243,785 24,894
Other Revenue 193,825 199,902 19,758 - 413,485 351,900 118%351,900 366,748 46,737
Total Direct Revenues 786,788$ 648,495$ 1,977,818$ -$ 3,413,101$ 3,335,005$ 102%3,159,480$ 3,259,149$ 153,952$
DIRECT EXPENDITURES
Personnel 240,554$ 223,276$ 1,061,933$ -$ 1,525,763$ 1,535,685$ 99%1,609,185$ 1,516,416$ 9,347$
Materials & Supplies 38,283 204,135 361,644 - 604,062 683,870 88%700,870 588,163 15,899
Operational & Contractual 633,430 139,686 276,201 - 1,049,317 1,012,130 104%1,047,630 1,027,627 21,690
Other - - (186,200) - (186,200) (206,200) 90%(206,200) (206,200) 20,000
Capital 51,521 94,925 75,200 - 221,646 261,500 85%226,000 127,155 94,491
Total Direct Expenditures 963,788$ 662,022$ 1,588,778$ -$ 3,214,588$ 3,286,985$ 98%3,377,485$ 3,053,161$ 161,427$
Direct Revenues Over (Under) Expenditures (177,000)$ (13,527)$ 389,040$ -$ 198,513$ 48,020$ 413%(218,005)$ 205,988$ (7,475)$
B&T Administration Overhead Allocation*178,250$ (178,250)$ -$ -$ -$ -$ 0%-$ -$ -$
Operating Revenues Over (Under) Expenditures 1,250$ (191,777)$ 389,040$ -$ 198,513$ 48,020$ 413%(218,005)$ 205,988$ (7,475)$
Interfund Loan**-$ -$ -$ -$ -$ -$ 0%-$ -$ -$
Transfer From General Fund - - - - - 73,505 0%73,505 - -
Transfer From Infrastructure Fund 24,000 - - - 24,000 24,000 100%24,000 24,000 -
Transfer From Water Fund 8,000 - - - 8,000 8,000 100%8,000 8,000 -
Transfer To Golf Surcharge Fund - - - (431,457) (431,457) (510,000) 85%- - (431,457)
Adjusted Operating Revenues Over (Under) Expenditures 33,250$ (191,777)$ 389,040$ (431,457)$ (200,944)$ (356,475)$ (112,500)$ 237,988$ (438,932)$
*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
12/31/17 Actual $ 3,413,101 3,214,588$
12/31/16 Actual $ 3,259,149 3,053,161$
% Change From Last Year 4.7%5.3%
Driving Program/
Memberships Greens Fees Range Fees Rentals User Fees
12/31/17 Actual $ 415,153 $ 942,506 $ 236,520 $ 364,563 $ 370,173
12/31/16 Actual $ 404,518 $ 897,480 $ 224,558 $ 368,137 $ 343,394
% Change From Last Year 2.6%5.0%5.3%-1.0%7.8%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
12/31/17 Actual 1,525,763$ 604,062$ 1,049,317$ (186,200)$ 221,646$
12/31/16 Actual 1,516,416$ 588,163$ 1,027,627$ (206,200)$ 127,155$
% Change From Last Year 0.6%2.7%2.1%0.0%74.3%
Five Year Trend
Revenues by Department 12/31/16 12/31/17 12/31/17 12/31/17 2017 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Programs 759,708$ 786,788$ 646,495$ 121.7%842,830$ 27,080$
Food & Beverage 587,420 648,495 127,800 507.4%532,350 58,675
Golf Club 1,912,021 1,977,818 567,997 348.2%1,784,300 65,797
Total Revenues 3,259,149$ 3,413,101$ 1,342,292$ 254.3%3,159,480$ 151,552$
Expenditures by Department 12/31/16 12/31/17 12/31/17 % of 2017 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Programs 938,596$ 963,788$ 344,363$ 279.9%992,140$ 25,192$
Food & Beverage 576,057 662,022 281,968 234.8%633,545 85,965
Golf Club 1,538,508 1,588,778 778,751 204.0%1,751,800 50,270
Total Expenditures 3,053,161$ 3,214,588$ 1,405,082$ 228.8%3,377,485$ 161,427$
Explanation of Major Changes From Last Year:
Memberships revenue is up $10,635 compared to collections through December 2016. This is due to an increase in Golf Club memberships compared to last
year. Total Memberships revenue through December 2017 is $42,427 under budget due to Bath & Tennis Club memberships being lower than projected.
Greens Fees revenue is up $45,026 compared to collections through December 2016. This is due to the weather allowing the golf course to open early in 2017.
Total Greens Fees revenue through December 2017 is $44,506 over budget due to the course opening early during the 2017 season.
Program/User Fees revenue is up $26,779 compared to collections through December 2016. This is due to the timing of field rental receipts being collected vs.
last year. Total Program/User Fees revenue through December 2017 is $217,577 under budget due to swimming and tennis user fees being less than expected.
Capital Outlay expenditures are up $94,491 compared to payments through December 2016. This is due to the renovation project at the B&T Clubhouse in 2017.
Total Capital Outlay expenditures through December 2017 are $39,854 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 December 31, 2017
Revenues Expenditures
Village of Oak Brook
Monthly Operating Statement
Bath & Tennis Club Recreation Programs
For the Period Ending December 31, 2017 12/31/17 12/31/17
12/31/17 YTD % of 2017 12/31/16 Difference
811 812 813 815 816 YTD Amended Amended Adopted YTD Prior
B&T Admin Swimming Tennis Polo Open Fields Total Budget Budget Budget Total Year
Revenues:
Memberships -$ 211,240$ 11,550$ -$ -$ 222,790$ 273,080$ 82%273,080$ 224,531$ (1,741)$
Programs/User Fees (3,607) 88,738 16,784 - 268,258 370,173 387,750 95%387,750 343,394 26,779
Beverage Sales - - - - - - 300 0%300 - -
Other Revenue 2,255 3,070 125 - 188,375 193,825 181,700 107%181,700 191,783 2,042
Total Revenue (1,352)$ 303,048$ 28,459$ -$ 456,633$ 786,788$ 842,830$ 93%842,830$ 759,708$ 27,080$
Expenditures:
Personnel 171,062$ 36,823$ 21,907$ -$ 10,762$ 240,554$ 226,335$ 106%226,335$ 215,708$ 24,846$
Materials & Supplies 20,491 11,960 4,042 - 1,790 38,283 66,700 57%66,700 31,146 7,137
Operational & Contractual 136,359 171,563 34,461 30,000 261,047 633,430 588,105 108%638,105 646,622 (13,192)
Capital 828 30,070 - - 20,623 51,521 111,000 46%61,000 45,120 6,401
Total Expenditures 328,740$ 250,416$ 60,410$ 30,000$ 294,222$ 963,788$ 992,140$ 97%992,140$ 938,596$ 25,192$
Direct Revenues Over (Under) Expenditures (330,092)$ 52,632$ (31,951)$ (30,000)$ 162,411$ (177,000)$ (149,310)$ 119%(149,310)$ (178,888)$ 1,888$
B&T Administration Overhead Allocation*330,092$ (118,833)$ (33,009)$ -$ -$ 178,250$ 176,890$ 101%176,890$ 70,964$ 107,286$
Revenues Over (Under) Expenditures -$ (66,201)$ (64,960)$ (30,000)$ 162,411$ 1,250$ 27,580$ 5%27,580$ (107,924)$ 109,174$
Interfund Loan**-$ -$ -$ -$ -$ -$ -$ 0%-$ -$ -$
Transfer From General Fund - - - - - - 73,505 0%73,505 - -
Transfer From Infrastructure Fund 24,000 - - - - 24,000 24,000 100%24,000 24,000 -
Transfer From Water Fund 8,000 - - - - 8,000 8,000 100%8,000 8,000 -
Adjusted Revenues Over (Under) Expenditures 32,000$ (66,201)$ (64,960)$ (30,000)$ 162,411$ 33,250$ 133,085$ 133,085$ (75,924)$ 109,174$
*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 December 31, 2017
12/31/17 12/31/17
821 822 823 12/31/17 YTD % of 2017 12/31/16 Difference
B&T Poolside Golf YTD Amended Amended Adopted YTD Prior
Clubhouse Café Clubhouse Total Budget Budget Budget Total Year
Revenues:
Memberships 2,400$ -$ -$ 2,400$ 4,500$ 53%4,500$ -$ -$
Food Sales - 40,263 137,251 177,514 175,375 101%163,850 174,964 2,550
Beverage Sales - 21,005 247,674 268,679 246,000 109%199,000 243,785 24,894
Other Revenue 199,902 - - 199,902 165,000 121%165,000 168,671 31,231
Total Revenue 202,302$ 61,268$ 384,925$ 648,495$ 590,875$ 110%532,350$ 587,420$ 58,675$
Expenditures:
Personnel 88,849$ 21,625$ 112,802$ 223,276$ 226,890$ 98%226,890$ 215,339$ 7,937$
Materials & Supplies 4,234 38,641 161,260 204,135 210,920 97%210,920 200,759 3,376
Operational & Contractual 130,126 2,122 7,438 139,686 160,735 87%160,735 159,959 (20,273)
Capital 78,552 16,373 - 94,925 35,000 271%35,000 - 94,925
Total Expenditures 301,761$ 78,761$ 281,500$ 662,022$ 633,545$ 104%633,545$ 576,057$ 85,965$
Direct Revenues Over (Under) Expenditures (99,459)$ (17,493)$ 103,425$ (13,527)$ (42,670)$ 32%(101,195)$ 11,363$ (24,890)$
B&T Administration Overhead Allocation*(165,046)$ (13,204)$ -$ (178,250)$ (176,890)$ 101%(176,890)$ (70,964)$ (107,286)$
Revenues Over (Under) Expenditures (264,505)$ (30,697)$ 103,425$ (191,777)$ (219,560)$ 87%(278,085)$ (59,601)$ (132,176)$
Transfer From General Fund -$ -$ -$ -$ -$ 0%-$ -$ -$
Adjusted Revenues Over (Under) Expenditures (264,505)$ (30,697)$ 103,425$ (191,777)$ (219,560)$ (278,085)$ (59,601)$ (132,176)$
*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 December 31, 2017
12/31/17 12/31/17
831 832 833 834 12/31/17 YTD % of 2017 12/31/16 Difference
Golf General Golf Learning Golf Cart Golf Course YTD Amended Amended Adopted YTD Prior
Operation & Practice Operations Maintenance Total Budget Budget Budget Total Year
Revenues:
Memberships 189,963$ -$ -$ -$ 189,963$ 180,000$ 106%166,000$ 179,987$ 9,976$
Greens Fees 942,506 - - - 942,506 898,000 105%840,000 897,480 45,026
Pro Shop Sales 181,149 - - - 181,149 200,000 91%190,000 195,512 (14,363)
Golf Lessons - 43,359 - - 43,359 30,250 143%30,250 40,053 3,306
Driving Range Fees - 236,520 - - 236,520 225,000 105%225,000 224,558 11,962
Rentals 4,348 - 360,215 - 364,563 362,850 100%327,850 368,137 (3,574)
Other Revenue 19,758 - - - 19,758 5,200 380%5,200 6,294 13,464
Total Revenue 1,337,724$ 279,879$ 360,215$ -$ 1,977,818$ 1,901,300$ 104%1,784,300$ 1,912,021$ 65,797$
Expenditures:
Personnel 470,091$ 77,721$ 51,562$ 462,559$ 1,061,933$ 1,082,460$ 98%1,155,960$ 1,085,369$ (23,436)$
Materials & Supplies 158,691 11,243 4,437 187,273 361,644 406,250 89%423,250 356,258 5,386
Operational & Contractual 209,869 14,077 6,054 46,201 276,201 263,290 105%248,790 221,046 55,155
Other - - - (186,200) (186,200) (206,200) 90%(206,200) (206,200) 20,000
Capital 38,800 8,526 - 27,874 75,200 115,500 65%130,000 82,035 (6,835)
Total Expenditures 877,451$ 111,567$ 62,053$ 537,707$ 1,588,778$ 1,661,300$ 96%1,751,800$ 1,538,508$ 50,270$
Direct Revenues Over (Under) Expenditures 460,273$ 168,312$ 298,162$ (537,707)$ 389,040$ 240,000$ 162%32,500$ 373,513$ 15,527$
Transfer from General Fund -$ -$ -$ -$ -$ -$ 0%-$ -$ -$
Adjusted Revenues Over (Under) Expenditures 460,273$ 168,312$ 298,162$ (537,707)$ 389,040$ 240,000$ 32,500$ 373,513$ 15,527$