09 - September 2017 Monthly Financial ReportVILLAGE
OAK BROOK
OF
MONTHLY FINANCIAL REPORTS
SEPTEMBER 2017
RG
Total
Cash and Cash Pooled Cash and
Fund Equivalents Investments Investments % By Fund
General Corporate $5,112,093 $13,331,690 $18,443,783 47.7%
Hotel/Motel Tax 2,108,596 2,203,830 4,312,426 11.1%
Motor Fuel Tax 370,717 478,282 848,999 2.2%
TIF #1 Butterfield/Meyers 211,301 - 211,301 0.5%
Water 4,148,351 861,528 5,009,879 12.9%
Self-Insurance 301,061 - 301,061 0.8%
Sports Core 756,881 - 756,881 2.0%
Golf Surcharge - 523,944 523,944 1.4%
Equipment Replacement 860,938 946,929 1,807,867 4.7%
Infrastructure 4,249,675 3,342,150 7,591,825 19.6%
Garage 385,089 - 385,089 1.0%
Total $18,504,702 $21,688,353 $40,193,055 103.9%
Change in Cash and Investments by Fund :
Balance at Balance at Year-to-Date Year-to-Date
Fund January 1, 2017 September 30, 2017 Change ($) Change (%)
General Corporate $16,586,097 $18,443,783 $1,857,686 11.2%
Hotel/Motel Tax 4,415,721 4,312,426 (103,295)-2.3%
Motor Fuel Tax 909,926 848,999 (60,927)-6.7%
TIF #1 Butterfield/Meyers 249,278 211,301 (37,977)-15.2%
Water 2,732,210 5,009,879 2,277,669 83.4%
Self-Insurance 589,849 301,061 (288,788)-49.0%
Sports Core 268,828 756,881 488,053 181.5%
Golf Surcharge 432,619 523,944 91,325 21.1%
Equipment Replacement 1,510,026 1,807,867 297,841 19.7%
Infrastructure 5,436,080 7,591,825 2,155,745 39.7%
Garage 347,053 385,089 38,036 11.0%
$33,477,688 $40,193,055 $6,715,367 20.1%
Monthly Treasurer's Report
September 30, 2017
Book Market
Value Value
Pooled Checking $1,228,604 $1,228,604
Sports Core Checking 756,687 756,687
Pooled IPTIP 16,385,468 16,385,468
Water E-Pay IPTIP 133,943 133,943
$18,504,702 $18,504,702
Pooled Investments:
Certificates of Deposit $7,220,000 $7,209,883
Investments-Municipal 8,184,441 8,147,003
Investments-Corporate 4,404,813 4,402,017
Government & Agency Obligations 1,747,674 1,729,817
Accrued Interest 131,425 131,425
Total Pooled Investments $21,688,353 $21,620,145
Total Cash and Investments $40,193,055 $40,124,847
For September, total interest revenue is $42,529 and year to date is $313,879.
Total investment yield for the portfolio is:
Pooled
Investments Illinois Funds Total
Monthly yield 0.13% 0.10% 0.12%
YTD yield 1.07% 0.65% 0.90%
Last 12 months yield 1.37% 0.76% 1.13%
The weighted average yield of the current pooled investment portfolio is 1.62%.
Monthly Treasurer's Report
September 2017
The table below lists the detail investment holdings at J.P. Morgan Securities as of 9/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,471 $600,174 $2,545
Florida Hurricane #34074GDG6 01/05/15 7/1/2018 2.107%2.090%751,706 751,320 3,937
Maryland St Econ Dev #57420PGK6 07/08/15 6/1/2019 2.050%2.123%99,879 100,617 682
Du Page County IL #263493TN8 07/20/15 10/1/2017 4.850%1.200%500,044 500,105 11,915
Rosemont IL GO Corp #777543UT4 02/08/16 12/1/2019 3.021%2.000%510,758 504,985 4,939
New York St Urban Dev Corp #650035J58 02/22/16 3/15/2018 1.650%1.150%175,394 175,096 120
New York N Y City #64971QTX1 02/22/16 5/1/2021 2.350%2.000%202,403 201,054 1,944
Florida Hurricane #34074GDH4 03/30/16 7/1/2020 2.995%2.150%511,183 509,620 3,743
Bloomingdale Mich Pub Sch Dist #094383FS0 04/26/16 5/1/2022 2.710%2.150%512,149 503,660 5,607
Milan Mich Area Achs #598801JD1 05/26/16 5/1/2020 1.931%1.931%245,000 242,393 1,870
Indiana Bd Bk Rev Taxable #4546248F7 01/06/17 1/15/2020 2.934%1.900%260,865 260,760 1,593
North Carolina Eastn Mun PWR #65819WAC7 01/30/17 7/1/2018 2.003%1.450%702,861 701,106 3,505
Garland Cnty Ark Sales & Use #36609PAN3 02/06/17 11/1/2019 1.795%1.840%499,538 495,910 3,864
Anchor Bay Mich Sch Dist GO #032879TA6 02/13/17 5/1/2019 1.810%1.420%367,231 365,704 2,676
Macomb Cnty Mich Retirees #554885H63 04/11/17 11/1/2018 1.731%1.300%401,855 400,096 2,842
Lanse Creuse Mich Pub Schs #516228RL9 05/02/17 5/1/2020 2.159%2.159%100,000 100,710 891
California St GO Bonds #13063A7G3 05/08/17 10/1/2019 6.200%1.600%545,256 543,090 15,218
*Genesee Cnty Mich #371608UV0 05/31/17 10/1/2019 1.837%1.837%708,000 708,023 1,092
Connecticut St GO Bds 2016 #20772J3F7 06/15/17 8/15/2021 1.750%2.300%489,848 482,580 1,065
Total Municipal Bonds $8,184,441 $8,147,003 $70,048
Corporate Bonds:
MacCormick & Co #579780AF4 04/06/17 12/15/2017 5.750%1.401%$504,486 $503,910 $8,359
JP Morgan Chase #46625HJG6 06/08/17 1/25/2018 1.800%1.371%846,148 845,651 2,734
Goldman Sachs Group #38141GRC0 06/08/17 1/22/2018 2.375%1.531%1,002,601 1,002,350 4,466
Wachovia #92976WBH8 06/15/17 2/1/2018 5.750%1.360%1,048,247 1,047,266 9,538
Morgan Stanley #6174467U7 08/28/17 4/25/2018 2.125%1.531%1,003,331 1,002,840 9,208
Total Corporate Bonds $4,404,813 $4,402,017 $34,305
Government & Agency Obligations:
**Government National Mtg Assn #38379UEM4 02/29/16 2/16/2051 2.300%2.245%$897,674 $879,817 $2,104
Fed Home Loan Bank #3130A9HF1 09/30/16 9/30/2019 0.750%1.280%600,000 600,000 1,125
Fed Home Loan Mtg Corp #3314GALU6 09/30/16 9/30/2019 0.800%1.852%250,000 250,000 1,000
Total Government & Agency Obligations:$1,747,674 $1,729,817 $4,229
Certificates of Deposit:
Capital One Bank #140420PP9 09/23/14 10/2/2017 1.35%1.36%$245,000 $245,002 $1,658Capital One Bank #140420PP9 09/23/14 10/2/2017 1.35%1.36%$245,000 $245,002 $1,658
Capital One Natl Assn VA #14042E5Z9 08/26/15 8/27/2018 1.75%1.75%245,000 245,541 849
Needham Co-Operative Bk #63983RAS8 10/07/15 10/10/2017 1.05%1.05%245,000 245,015 1,240
BMO Harris #05573J5A8 10/07/15 10/10/2017 1.10%1.10%245,000 245,012 1,299
Ally Bk Midvale Utah #02006LVC4 10/29/15 10/29/2018 1.60%1.60%245,000 245,434 1,639
Everbank Jacksonville #29976DD23 10/30/15 10/30/2017 1.05%1.05%245,000 245,007 1,075
Wex Bank Midvale Utah #92937CDY1 07/29/16 7/30/2018 1.00%1.00%245,000 244,282 422
Bank Hope Los Angeles #062683AB3 08/26/16 8/27/2018 1.00%1.00%245,000 243,834 23
Wells Fargo Bank Natl Assn #949763AL0 08/31/16 8/31/2018 1.10%1.10%245,000 243,831 232
BMW Bank #05580AFG4 09/23/16 9/24/2018 1.10%1.10%245,000 243,633 52
Comenity Cap Bank #20033ASB3 09/26/16 9/26/2018 1.10%1.10%245,000 243,618 30
Enerbank #29266N4E4 10/21/16 10/22/2018 1.10%1.10%245,000 243,915 1,201
Discover Bank #254672L71 10/26/16 10/26/2018 1.20%1.20%245,000 243,459 1,270
Bank of Baroda #06062QXT6 11/30/16 11/30/2017 0.95%0.95%245,000 244,963 1,940
State Bk India NY #8562846A7 01/26/17 1/26/2022 2.25%2.25%245,000 246,735 1,018
Marlin Business Bk #57116ANU8 05/10/17 11/12/2019 1.60%1.60%245,000 244,363 214
American Express Fed Svgs #02587CER7 05/10/17 11/12/2019 1.70%1.70%245,000 244,111 1,631
Synchrony Bank #87164WRA8 05/26/17 5/28/2019 1.65%1.65%245,000 245,059 1,381
Umpqua Bank #90421MAG8 05/31/17 5/31/2019 1.60%1.60%245,000 244,851 1,318
Stone Bk Mtn View Ark #86158RAJ8 06/28/17 6/28/2019 1.60%1.60%245,000 244,784 14
Investors Savings Bk #46176PGU3 06/30/17 4/2/2018 1.35%1.35%245,000 245,120 827
TIAA FSB Jacksonville #87270LAA1 07/19/17 7/19/2019 1.60%1.60%245,000 244,726 784
Peoples United Bank #71270QQZ2 07/19/17 7/19/2019 1.65%1.65%245,000 244,944 809
Priority Bank Ozark Ark #74269KBR6 07/26/17 7/26/2019 1.60%1.60%245,000 244,711 42
American Express Centurion #02587DV96 08/15/17 8/17/2020 1.90%1.90%245,000 244,089 582
Sallie Mae #795450C86 08/16/17 8/17/2020 1.90%1.90%245,000 245,118 582
Merrick Bank South Jordan #59013JZS1 08/21/17 8/21/2020 1.80%1.80%245,000 244,414 115
Pinnacle Bank #72345SFS5 08/30/17 8/31/2020 1.80%1.80%115,000 114,704 178
Jackson County Bank #466682AP6 08/31/17 3/1/2021 1.85%1.85%245,000 244,299 378
Barclays Bank #06740KKX4 09/27/17 9/28/2020 1.95%1.95%245,000 245,309 40
Total Certificates of Deposits $7,220,000 $7,209,883 $22,843
Total J.P.Morgan Securities $21,556,928 $21,488,720 $131,425
*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
September 30, 2017
Cash & Investments by Fund - Total $40.2 million
General Corporate
45.89%
Hotel/Motel Tax
10.73%Motor Fuel Tax
2.11%
TIF #1
Butterfield/Meyers
0.53%
Water
12.46%
Self-Insurance
0.75%
Sports Core
1.88%
Golf Surcharge
1.30%
Equipment
Replacement
4.50%Infrastructure
18.89%
Garage
0.96%
Cash & Investments by Type - Total $40.2 million
Checking, $2.0
Illinois Funds, $16.6
Certificates of Deposit,
$7.2
Municipal Bonds, $8.2
Corporate Bonds, $4.4
Government & Agency
Obligations, $1.7
Accrued Interest, $0.1
in millions
YTD YTD
Net Fund Budget
Increase Increase
Governmental Funds Revenues Expenditures (Decrease)(Decrease)
General Fund (Major Fund)$18,345,811 $16,745,428 $1,600,383 ($78,900)
Main operating fund of the Village.
Hotel Fund (Major Fund)$926,847 $854,394 $72,453 ($1,246,015)
Collects and spends resources from the
3% hotel/motel tax.
Motor Fuel Tax Fund $159,863 $220,789 ($60,926) ($404,895)
Collects and spends resources from the
State motor fuel tax.
Infrastructure Fund (Major Fund)$4,720,073 $2,297,914 $2,422,159 $1,744,060
Accounts for construction and maintenance of
roadways, drainage, and safety path systems.
Promenade TIF Fund (Major Fund)$420,360 $458,338 ($37,978) ($69,890)
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)$7,521,823 $4,739,684 $2,782,139 ($894,055)
Collects user fees for the distribution of water
and maintenance of infrastructure.
Sports Core Fund (Major Fund)$3,174,285 $2,574,535 $599,750 $249,600
Accounts for revenues and expenses relating
to administration, programs, food and beverage
operations, and golf course.
Golf Surcharge Fund $112,043 $0 $112,043 $105,955
Accounts for the collection of the $3 per round
golf surcharge.
Internal Service Funds
Self Insurance Fund $2,346,280 $2,416,017 ($69,737) ($26,450)
Accounts for the Village's health insurance costs
and the related contributions from the Village,
employees, retirees, and other agencies.
Garage Fund $561,151 $496,346 $64,805 ($62,150)
Accounts for the maintenance of the Village's vehicle
fleet and the related departmental reimbursements.
Equipment Replacement Fund $618,588 $320,746 $297,842 $145,440
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 September 30, 2017
9/30/17 9/30/17
9/30/16 9/30/17 YTD % of 2017 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 9,832,081$ 9,342,539$ 9,875,145$ 95% 13,048,000$ (489,542)$
Other Intergovernmental Tax 1,054,310 1,092,255 998,710 109% 1,265,235 37,945
Telecommunications/Utility Tax 4,484,244 4,513,733 4,329,360 104% 5,638,000 29,489
Licenses and Permits 1,496,633 1,692,450 1,488,555 114% 1,711,750 195,817
Charges for Services 719,484 698,024 731,025 95% 1,006,750 (21,460)
Fines and Penalties 121,839 105,867 115,110 92% 153,590 (15,972)
Administrative Towing Fees 25,850 31,375 37,485 84% 50,000 5,525
Interest on Investments 107,928 164,515 93,735 176% 125,000 56,587
Franchise/IMF Maint. Fee 167,541 107,597 155,400 69% 207,200 (59,944)
Reimbursements From Other Funds 471,015 462,978 462,960 100% 617,300 (8,037)
Miscellaneous Income 145,333 134,478 172,255 78% 231,675 (10,855)
Total Operating Revenues 18,626,258$ 18,345,811$ 18,459,740$ 99% 24,054,500$ (280,447)$
OPERATING EXPENDITURES
Personnel 12,211,892$ 12,264,968$ 13,631,085$ 90% 17,788,210$ 53,076$
Materials and Supplies 291,002 312,412 423,250 74% 554,530 21,410
Operation and Contract 2,794,945 3,030,887 3,356,160 90% 4,344,325 235,942
Other Expenditures 107,334 101,128 101,110 100% 418,100 (6,206)
Capital Outlay 318,092 1,036,033 1,027,035 101% 805,310 717,941
Total Operating Expenditures 15,723,265$ 16,745,428$ 18,538,640$ 90% 23,910,475$ 1,022,163$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 2,902,993$ 1,600,383$ (78,900)$ 144,025$ (1,302,610)$
INTERFUND TRANSACTIONS
Transfers Out -$ -$ -$ 0% (73,505)$ -$
Interfund Loan - - - 0% - -
Total Interfund Transactions -$ -$ -$ 0% (73,505)$ -$
NET FUND INCREASE (DECREASE)2,902,993$ 1,600,383$ (78,900)$ 70,520$ (1,302,610)$
Village of Oak Brook
General Fund Financial Update
For the Period Ending September 30, 2017
Total Total
Revenues Expenditures
9/30/17 Actual $ 18,345,811 16,745,428$
9/30/16 Actual $ 18,626,258 15,723,265$
% Change From Last Year -1.5%6.5%
Major Revenues Other
Intergov.Licenses & Charges for
Sales Tax Tax Telecom Tax Permits Services
9/30/17 Actual $ 9,342,539 $ 1,092,255 $ 4,513,733 $ 1,692,450 698,024
9/30/16 Actual $ 9,832,081 $ 1,054,310 $ 4,484,244 $ 1,496,633 719,484
% Change From Last Year -5.0%3.6%0.7%13.1%-3.0%
Five Year Trend
Major Expenditures Materials & Operation & Other
Personnel Supplies Contractual Expenditures Capital Outlay
9/30/17 Actual 12,264,968$ 312,412$ 3,030,887$ 101,128 1,036,033$
9/30/16 Actual 12,211,892$ 291,002$ 2,794,945$ 107,334 318,092$
% Change From Last Year 0.4%7.4%8.4%-5.8% 225.7%
Five Year Trend
Expenditures by Department
9/30/16 9/30/17 9/30/17 9/30/17 2017 Difference Five
YTD YTD YTD % of Annual Prior Year
Department Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 1,744,314$ 1,981,575$ 2,275,030$ 87.1% 2,883,255$ 237,261$
Five Year Trend
For the Period Ending September 30, 2017
General Fund - Five Year Trend
Village of Oak Brook
Revenues Expenditures
Financial Services 704,660 621,091 643,065 96.6% 1,116,445 (83,569)
Public Works 415,495 504,370 551,755 91.4% 752,340 88,875
Engineering & Capital Projects 191,822 759,061 599,380 126.6% 372,500 567,239
Library 729,683 684,074 769,895 88.9% 989,470 (45,609)
Police 6,103,553 6,144,828 6,591,675 93.2% 8,609,255 41,275
Fire 5,124,483 5,320,016 6,359,145 83.7% 8,205,100 195,533
Development Services 709,255 730,413 748,695 97.6% 982,110 21,158
Total Expenditures 15,723,265$ 16,745,428$ 18,538,640$ 90.3% 23,910,475$ 1,022,163$
Explanation of Major Changes From Last Year:
Sales Tax revenue is down $489,542 compared to revenue through September 2016. This is due to non-routine receipts received from a top taxpayer in 2016. Total Sales Tax
revenue through September 2017 is $532,606 under budget due to the timing of receipts from new businesses and slowed retail growth.
Other Intergovernmental Tax revenue is up $37,945 compared to revenue through September 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 September 2017 is $93,545 over budget.
Licenses & Permits revenue is up $195,817 compared to collections through September 2016. This is primarily due to increases in building permits and accessory structure
permits. Total Licenses & Permits revenue through September 2017 is over budget by $203,895.
Personnel expenditures are up $53,076 comapred to payments through September 2016. This is primarily due to general increases in wages, insurance, and pension
payments. Total Personnel expenditures through September 2017 are $1,366,117 under budget due to public safety pensions being funded lower than budgeted.
Operation & Contractual expenditures are up $235,942 compared to payments through September 2016. This is due to increased litigation services and increases in liability
insurance premiums and claims. Total Operation & Contractual expenditures through September 2017 are $325,273 under budget due to general timing of payments.
Capital Outlay expenditures are up $717,941 compared to payments through September 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 September 2017 are $8,998 over budget.
9/30/17 9/30/17
9/30/16 9/30/17 YTD % of 2017 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Hotel Tax 915,845$ 879,887$ 785,725$ 112% 1,266,000$ (35,958)$
Interest 24,713 35,629 16,470 216% 22,000 10,916
Miscellaneous - 11,331 - N/A - 11,331
Total Operating Revenues 940,558$ 926,847$ 802,195$ 115.5% 1,288,000$ (13,711)$
EXPENDITURES
Operation and Contract 263,009$ 329,664$ 446,940$ 74% 595,975$ 66,655$
Other Expenditures 67,725 70,047 70,020 100% 93,400 2,322
Capital Outlay 23,485 454,683 1,531,250 30% 1,837,500 431,198
Total Expenditures 354,219$ 854,394$ 2,048,210$ 41.7% 2,526,875$ 500,175$
NET FUND INCREASE (DECREASE)586,339$ 72,453$ (1,246,015)$ (1,238,875)$ (513,886)$
Note - Expenditures are recorded in program 171.
Village of Oak Brook
Hotel Tax Fund Financial Update
For the Period Ending September 30, 2017
Total Total
Revenues Expenditures
9/30/17 Actual $ 926,847 854,394$
9/30/16 Actual $ 940,558 354,219$
% Change From Last Year -1.5%141.2%
Major Revenues
Grants Hotel Tax Interest Miscellaneous
9/30/17 Actual $ - $ 879,887 $ 35,629 $ 11,331
9/30/16 Actual $ - $ 915,845 $ 24,713 $ -
% Change From Last Year 0.0%-3.9%44.2%N/A
Five Year Trend
Major Expenditures Operation &Other
Contractual Expenditures Capital Outlay
Village of Oak Brook
Hotel Tax Fund - Major Sources Five Year Trend
For the Period Ending September 30, 2017
Five Year Trend
Revenues Expenditures
9/30/17 Actual 329,664$ 70,047$ 454,683$
9/30/16 Actual 263,009$ 67,725$ 23,485$
% Change From Last Year 25.3%3.4%1836.1%
Five Year Trend
Explanation of Major Changes From Last Year:
Hotel Tax revenue is down $35,958 compared to collections through September 2016. This is related to the timing of
receipts. Total Hotel Tax revenue through September 2017 is over budget by $94,162 because of general increases in
receipts and the timing of when receipts have been received.
Operation & Contractual expenditures are up $66,655 compared to payments through September 2016. This is related to
engineering costs for a 22nd Street beautification project. Total Operation & Contractual expenditures through
September 2017 are under budget by $117,276 due to the timing of DCVB quarterly dues and advertising payments.
Capital Outlay expenditures are up $431,198 compared to payments through September 2016. This is related to 22nd St.
construction costs that were delayed from 2016. Total Capital Outlay expenditures through September 2017 are
under budget by $1,076,567 due to the timing of payments.
9/30/17 9/30/17
9/30/16 9/30/17 YTD % of 2017 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 4,546,464$ 4,303,788$ 4,545,930$ 95% 5,982,000$ (242,676)$
Grants - 3,142 - N/A - 3,142
Interest 30,810 54,129 20,610 263% 27,500 23,319
Miscellaneous (1,645) 5,745 3,735 154% 5,000 7,390
Reimbursements From Other Funds 135,027 132,480 132,480 100% 176,635 (2,547)
Total Operating Revenues 4,710,656$ 4,499,284$ 4,702,755$ 96% 6,191,135$ (211,372)$
OPERATING EXPENDITURES
Personnel 1,139,875$ 886,575$ 980,515$ 90% 1,474,390$ (253,300)$
Materials and Supplies 83,008 74,354 271,025 27% 351,095 (8,654)
Operation and Contract 876,818 920,975 1,038,935 89% 1,132,435 44,157
Other Expenditures 116,253 121,878 121,860 100% 162,500 5,625
Capital Outlay 1,170,372 294,132 1,108,125 27% 1,755,000 (876,240)
-
Total Operating Expenditures 3,386,326$ 2,297,914$ 3,520,460$ 65% 4,875,420$ (1,088,412)$
SURPLUS (DEFICIT) OF REVENUES OVER
EXPENDITURES 1,324,330$ 2,201,370$ 1,182,295$ 186% 1,315,715$ 877,040$
INTERFUND TRANSACTIONS
Transfers In -$ 220,789$ 561,765$ 39% 561,765$ 220,789$
Total Interfund Transactions -$ 220,789$ 561,765$ 39% 561,765$ 220,789$
NET FUND INCREASE (DECREASE)1,324,330$ 2,422,159$ 1,744,060$ 1,877,480$ 1,097,829$
Village of Oak Brook
Infrastructure Fund Financial Update
For the Period Ending September 30, 2017
Total Total
Revenues Expenditures
9/30/17 Actual $ 4,499,284 2,297,914$
9/30/16 Actual $ 4,710,656 3,386,326$
% Change From Last Year -4.5%-32.1%
Major Revenues
Sales Tax Grants Interest Miscellaneous Reimbursements
9/30/17 Actual $ 4,303,788 $ 3,142 $ 54,129 $ 5,745 $ 132,480
9/30/16 Actual $ 4,546,464 $ - $ 30,810 $ (1,645) $ 135,027
% Change From Last Year -5.3%N/A 75.7%-449.2%-1.9%
Five Year Trend
Major Expenditures Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
9/30/17 Actual 886,575$ 74,354$ 920,975$ 121,878$ 294,132$
9/30/16 Actual 1,139,875$ 83,008$ 876,818$ 116,253$ 1,170,372$
% Change From Last Year -22.2%-10.4%5.0%4.8%-74.9%
Five Year Trend
Five Year Trend
Village of Oak Brook
Infrastructure Fund - Major Sources Five Year Trend
For the Period Ending September 30, 2017
Revenues Expenditures
Expenditures by Department
9/30/16 9/30/17 9/30/17 9/30/17 2017 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Legislative & General Management 93,595$ 117,068$ 129,280$ 90.6% 174,430$ 23,473$
Public Works 1,546,660 1,727,537 2,081,125 83.0% 2,697,845 180,877
Engineering & Capital Projects 1,746,071 453,309 1,310,055 34.6% 2,003,145 (1,292,762)
Total Expenditures 3,386,326$ 2,297,914$ 3,520,460$ 65.3% 4,875,420$ (1,088,412)$
Explanation of Major Changes From Last Year:
Sales Tax revenue is down $242,676 compared to revenue through September 2016. This is due to non-routine receipts received from a top taxpayer in 2016. Total
Sales Tax revenue through September 2017 is $242,142 under budget due to the timing of receipts from new businesses and slowed retail growth.
Personnel expenditures are down $253,300 compared to payments through September 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 September 2017 are $93,940
under budget due to less time spent on snow removal.
Operation & Contractual expenditures are up $44,157 compared to payments through September 2016. This is due to payments for outsourced engineering services
that started in 2017. Total Operation & Contractual expenditures through September 2017 are $117,960 under budget due to the timing of general maintenance
payments.
Capital Outlay expenditures are down $876,240 compared to payments through September 2016. This is due to the timing of payments. Total Capital Outlay
expenditures through September 2017 are $813,993 under budget due to the timing of capital projects.
9/30/17 9/30/17
9/30/16 9/30/17 YTD % of 2017 Difference
YTD YTD Amended Amended Adopted Prior
Actual Actual Budget Budget Budget Year
OPERATING REVENUES
Sales Tax 34,842$ 35,077$ 33,500$ 105% 100,500$ 235$
Real Estate Tax 354,829 385,018 355,000 108% 355,000 30,189
Interest 155 265 60 442% 100 110
Total Operating Revenues 389,826$ 420,360$ 388,560$ 108% 455,600$ 30,534$
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)(49,332)$ (37,978)$ (69,890)$ (2,850)$ 11,354$
Note - Expenditures are recorded in program 283.
Village of Oak Brook
Promenade TIF Fund Financial Update
For the Period Ending September 30, 2017
Total Total
Revenues Expenditures
9/30/17 Actual $ 420,360 458,338$
9/30/16 Actual $ 389,826 439,158$
% Change From Last Year 7.8%4.4%
Major Revenues Real Estate
Sales Tax Tax Interest
9/30/17 Actual $ 35,077 $ 385,018 $ 265
9/30/16 Actual $ 34,842 $ 354,829 $ 155
% Change From Last Year 0.7%8.5%71.0%
Five Year Trend
Major Expenditures Operation & Other
Contractual Expenditures
9/30/17 Actual 3,958$ 454,380$
9/30/16 Actual 3,938$ 435,220$
Village of Oak Brook
Promenade TIF Fund - Major Sources Five Year Trend
For the Period Ending September 30, 2017
Five Year Trend
Revenues Expenditures
9/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 September 2016. This is due to general property value
increases within the TIF. Total Real Estate Tax revenue through September 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 September 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 September.
9/30/17 9/30/17
9/30/16 9/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,359 1,489 1,485 100% 2,000 130
Building/Inspection Fees 4,188 9,589 3,375 284% 4,500 5,401
Water Sales 6,641,390 7,231,161 7,226,995 100% 9,143,000 589,771
Unmetered Sales 15,764 26,803 18,720 143% 25,000 11,039
Water Connection Fees 61,323 135,700 22,500 603% 30,000 74,377
Fire Service Charge 9,486 - 7,515 0% 10,000 (9,486)
Meter Charges 20,321 17,077 18,765 91% 25,000 (3,244)
Special Services 15,620 15,286 15,500 99% 31,000 (334)
Interest on Investments 8,675 26,432 7,515 352% 10,000 17,757
Miscellaneous 48,035 54,900 48,735 113% 65,000 6,865
Total Operating Revenues 6,826,161$ 7,521,823$ 7,371,105$ 102% 9,345,500$ 695,662$
EXPENDITURES
Personnel 634,221$ 602,777$ 640,575$ 94% 835,110$ (31,444)$
Materials and Supplies 44,704 40,556 54,495 74% 70,660 (4,148)
Operation and Contract 4,107,983 3,745,909 4,898,420 76% 6,547,735 (362,074)
Other Expenditures 317,790 301,203 301,185 100% 401,600 (16,587)
Capital Outlay 63,422 49,239 2,370,485 2% 3,235,010 (14,183)
Total Expenditures 5,168,120$ 4,739,684$ 8,265,160$ 57% 11,090,115$ (428,436)$
NET FUND INCREASE (DECREASE)1,658,041$ 2,782,139$ (894,055)$ (1,744,615)$ 1,124,098$
Village of Oak Brook
Water Fund Financial Update
For the Period Ending September 30, 2017
Total Total
Revenues Expenditures
9/30/17 Actual $ 7,521,823 4,739,684$
9/30/16 Actual $ 6,826,161 5,168,120$
% Change From Last Year 10.2%-8.3%
Unmetered Water
Water Sales Sales Connection Fees Meter Charges Miscellaneous
9/30/17 Actual $ 7,231,161 $ 26,803 $ 135,700 $ 17,077 $ 54,900
9/30/16 Actual $ 6,641,390 $ 15,764 $ 61,323 $ 20,321 $ 48,035
% Change From Last Year 8.9%70.0%121.3%-16.0%14.3%
Five Year Trend
Materials &Operation &Other
Personnel Supplies Contractual Expenditures Capital Outlay
9/30/17 Actual 602,777$ 40,556$ 3,745,909$ 301,203$ 49,239$
9/30/16 Actual 634,221$ 44,704$ 4,107,983$ 317,790$ 63,422$
% Change From Last Year -5.0%-9.3%-8.8%-5.2%-22.4%
Five Year Trend
Expenditures by Department
Five Year Trend
Village of Oak Brook
Water Fund - Major Sources Five Year Trend
For the Period Ending September 30, 2017
Revenues Expenditures
Expenditures by Department
9/30/16 9/30/17 9/30/17 9/30/17 2017 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
Public Works 5,168,120$ 4,692,609$ 5,993,135$ 78.3% 7,912,070$ (475,511)$
Engineering & Capital Projects - 47,075 2,272,025 0.0% 3,178,045 47,075
Total Expenditures 5,168,120$ 4,739,684$ 8,265,160$ 57.3% 11,090,115$ (428,436)$
Explanation of Major Changes From Last Year:
Water Sales revenue is up $589,771 compared to collections through September 2016. This is due to a 10% rate increase adopted January 1, 2017. Total Water Sales
revenue through August 2017 is over budget by $4,166 due to gallons billed being slightly higher than projected.
Water Connection Fees revenue is up $74,377 compared to collections through September 2016. This is due to construction of the Rush Midwest Orthopedics building.
Total Water Connection Fees revenue through September 2017 is over budget by $113,200 due to new development within the Village.
Operation & Contractual expenditures are down $362,074 compared to payments through September 2016. This is due to total gallons pumped from DuPage Water
Commission being less than projected and the DuPage Water Commission rate increase being less than anticipated. Operation & Contractual expenditures through
September 2017 are under budget by $1,152,511 due to the timing of bills being paid to the timing of invoices being paid.
Capital Outlay expenditures are down $14,183 compared to payments through September 2016. This is due to general timing of payments. Capital Outlay expenditures
through September 2017 are under budget by $2,321,246 due to the meter replacement project happening later than originally planned.
Village of Oak BrookMonthly Operating StatementSports Core Fund Consolidated PresentationFor the Period Ending September 30, 20179/30/17 9/30/179/30/17 YTD % of 2017 9/30/16 DifferenceB&T Recreation Food & Golf YTD Amended Amended Adopted YTD PriorPrograms Beverage Club Total Budget Budget Budget Total YearDIRECT REVENUESMemberships222,790$ 2,400$ 189,963$ 415,153$ 454,580$ 91% 443,580$ 404,793$ 10,360$ Greens Fees- - 866,389 866,389 787,960 110% 840,000 789,500 76,889 Pro Shop Sales- - 163,230 163,230 173,000 94% 190,000 159,067 4,163 Golf Lessons- - 43,119 43,119 30,250 143% 30,250 40,053 3,066 Driving Range Fees- - 227,788 227,788 215,500 106% 225,000 214,026 13,762 Rentals- - 331,115 331,115 322,965 103% 327,850 316,363 14,752 Programs/User Fees327,201 - - 327,201 293,520 111% 387,750 241,074 86,127 Food Sales- 166,414 - 166,414 158,205 105% 163,850 156,503 9,911 Beverage Sales- 248,984 - 248,984 220,865 113% 199,300 218,027 30,957 Other Revenue193,132 149,562 18,195 360,889 317,640 114% 351,900 323,066 37,823 Total Direct Revenues743,123$ 567,360$ 1,839,799$ 3,150,282$ 2,974,485$ 106% 3,159,480$ 2,862,472$ 287,810$ DIRECT EXPENDITURESPersonnel181,888$ 184,106$ 821,124$ 1,187,118$ 1,219,615$ 97% 1,609,185$ 1,221,128$ (34,010)$ Materials & Supplies34,491 186,728 272,398 493,617 614,010 80% 700,870 467,940 25,677 Operational & Contractual568,108 89,040 225,759 882,907 990,070 89% 1,047,630 942,886 (59,979) Other- - (186,200) (186,200) (206,200) 90% (206,200) (206,200) 20,000 Capital51,521 94,750 50,822 197,093 186,500 106% 226,000 124,262 72,831 Total Direct Expenditures836,008$ 554,624$ 1,183,903$ 2,574,535$ 2,803,995$ 92% 3,377,485$ 2,550,016$ 24,519$ Direct Revenues Over (Under) Expenditures(92,885)$ 12,736$ 655,896$ 575,747$ 170,490$ 338% (218,005)$ 312,456$ 263,291$ B&T Administration Overhead Allocation* 133,500$ (133,500)$ -$ -$ -$ 0% -$ -$ -$ Operating Revenues Over (Under) Expenditures40,615$ (120,764)$ 655,896$ 575,747$ 170,490$ 338% (218,005)$ 312,456$ 263,291$ Interfund Loan**-$ -$ -$ -$ -$ 0% -$ -$ -$ Transfer From General Fund- - - - 55,125 0% 73,505 - - Transfer From Infrastructure Fund 18,000 - - 18,000 18,000 100% 24,000 18,000 - Transfer From Water Fund6,003 - - 6,003 5,985 100% 8,000 6,003 - Adjusted Operating Revenues Over (Under) Expenditures64,618$ (120,764)$ 655,896$ 599,750$ 249,600$ (112,500)$ 336,459$ 263,291$ *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
9/30/17 Actual $ 3,150,282 2,574,535$
9/30/16 Actual $ 2,862,472 2,550,016$
% Change From Last Year 10.1% 1.0%
Driving Program/
Memberships Greens Fees Range Fees Rentals User Fees
9/30/17 Actual $ 415,153 $ 866,389 $ 227,788 $ 331,115 $ 327,201
9/30/16 Actual $ 404,793 $ 789,500 $ 214,026 $ 316,363 $ 241,074
% Change From Last Year 2.6% 9.7% 6.4% 4.7%35.7%
Five Year Trend
Materials & Operation & Other
Personnel Supplies Contractual Expenditures Capital Outlay
9/30/17 Actual 1,187,118$ 493,617$ 882,907$ (186,200)$ 197,093$
9/30/16 Actual 1,221,128$ 467,940$ 942,886$ (206,200)$ 124,262$
% Change From Last Year -2.8%5.5%-6.4%0.0%58.6%
Five Year Trend
Revenues by Department 9/30/16 9/30/17 9/30/17 9/30/17 2017 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Programs 656,866$ 743,123$ 646,495$ 114.9% 842,830$ 86,257$
Five Year Trend
Village of Oak Brook
Sports Core Fund - Major Sources Five Year Trend
For the Period Ending September 30, 2017
Revenues Expenditures
Food & Beverage 500,099 567,360 127,800 443.9% 532,350 64,861
Golf Club 1,705,507 1,839,799 567,997 323.9% 1,784,300 134,292
Total Revenues 2,862,472$ 3,150,282$ 1,342,292$ 234.7% 3,159,480$ 285,410$
Expenditures by Department 9/30/16 9/30/17 9/30/17 % of 2017 Difference Five
YTD YTD YTD % of Annual Prior Year
Actual Actual Budget Budget Budget Year Trend
B&T Recreation Programs 880,719$ 836,008$ 344,363$ 242.8% 992,140$ (44,711)$
Food & Beverage 488,580 554,624 281,968 196.7% 633,545 66,044
Golf Club 1,180,717 1,183,903 778,751 152.0% 1,751,800 3,186
Total Expenditures 2,550,016$ 2,574,535$ 1,405,082$ 183.2% 3,377,485$ 24,519$
Explanation of Major Changes From Last Year:
Memberships revenue is up $10,360 compared to collections through September 2016. This is due to an increase in Golf Club memberships compared to last
year. Total Memberships revenue through September 2017 is $39,427 under budget due to Bath & Tennis Club memberships being lower than projected.
Greens Fees revenue is up $76,889 compared to collections through September 2016. This is due to the weather allowing the golf course to open early in 2017.
Total Greens Fees revenue through September 2017 is $78,429 over budget due to the course opening early during the 2017 season.
Program/User Fees revenue is up $86,127 compared to collections through September 2016. This is due to the timing of field rental receipts being collected vs.
last year. Total Program/User Fees revenue through September 2017 is $33,681 over budget due to field rental receipts being received earlier than anticipated.
Capital Outlay expenditures are up $72,831 compared to payments through September 2016. This is due to the renovation project at the B&T Clubhouse in 2017.
Total Capital Outlay expenditures through September 2017 are $10,593 over budget due to the timing of the B&T renovation project.
Village of Oak BrookMonthly Operating StatementBath & Tennis Club Recreation ProgramsFor the Period Ending September 30, 20179/30/17 9/30/179/30/17 YTD % of 2017 9/30/16 Difference811 812 813 815 816 YTD Amended Amended Adopted YTD PriorB&T Admin Swimming Tennis Polo Open Fields Total Budget Budget Budget Total YearRevenues:Memberships-$ 215,752$ 7,038$ -$ -$ 222,790$ 273,080$ 82% 273,080$ 224,531$ (1,741)$ Programs/User Fees(4,507) 88,738 16,700 - 226,270 327,201 293,520 111% 387,750 241,074 86,127 Beverage Sales- - - - - - 300 0% 300 - - Other Revenue1,562 3,070 125 - 188,375 193,132 181,440 106% 181,700 191,261 1,871 Total Revenue(2,945)$ 307,560$ 23,863$ -$ 414,645$ 743,123$ 748,340$ 99% 842,830$ 656,866$ 86,257$ Expenditures:Personnel118,526$ 36,823$ 21,498$ -$ 5,041$ 181,888$ 192,850$ 94% 226,335$ 175,646$ 6,242$ Materials & Supplies 19,768 8,891 4,042 - 1,790 34,491 57,120 60% 66,700 29,295 5,196 Operational & Contractual 105,155 144,052 34,266 30,000 254,635 568,108 629,395 90% 638,105 633,551 (65,443) Capital828 30,070 - - 20,623 51,521 61,000 84% 61,000 42,227 9,294 Total Expenditures244,277$ 219,836$ 59,806$ 30,000$ 282,089$ 836,008$ 940,365$ 89% 992,140$ 880,719$ (44,711)$ Direct Revenues Over (Under) Expenditures(247,222)$ 87,724$ (35,943)$ (30,000)$ 132,556$ (92,885)$ (192,025)$ 48% (149,310)$ (223,853)$ 130,968$ B&T Administration Overhead Allocation* 247,222$ (89,000)$ (24,722)$ -$ -$ 133,500$ 132,685$ 101% 176,890$ 60,748$ 72,752$ Revenues Over (Under) Expenditures-$ (1,276)$ (60,665)$ (30,000)$ 132,556$ 40,615$ (59,340)$ -68% 27,580$ (163,105)$ 203,720$ Interfund Loan**-$ -$ -$ -$ -$ -$ -$ 0% -$ -$ -$ Transfer From General Fund - - - - - - 55,125 0% 73,505 - - Transfer From Infrastructure Fund 18,000 - - - - 18,000 18,000 100% 24,000 18,000 - Transfer From Water Fund 6,003 - - - - 6,003 5,985 100% 8,000 6,003 - Adjusted Revenues Over (Under) Expenditures24,003$ (1,276)$ (60,665)$ (30,000)$ 132,556$ 64,618$ 19,770$ 133,085$ (139,102)$ 203,720$ *Overhead allocation is comprised of salaries, business forms, liability insurance, building & grounds maintenance and bank service fees in Program 811 - Sports Core General Operations distributed to various Sports Core Programs on a percentage basis.**Interfund loan is from the General Fund.
Village of Oak BrookMonthly Operating StatementSports Core Food & Beverage ProgramsFor the Period Ending September 30, 20179/30/17 9/30/17821 822 823 9/30/17 YTD % of 2017 9/30/16 DifferenceB&T Poolside Golf YTD Amended Amended Adopted YTD Prior Clubhouse Café Clubhouse Total Budget Budget Budget Total YearRevenues:Memberships2,400$ -$ -$ 2,400$ 1,500$ 0% 4,500$ -$ -$ Food Sales- 40,272 126,142 166,414 158,205 105% 163,850 156,503 9,911 Beverage Sales- 21,011 227,973 248,984 220,565 113% 199,000 218,027 30,957 Other Revenue149,562 - - 149,562 131,000 114% 165,000 125,569 23,993 Total Revenue151,962$ 61,283$ 354,115$ 567,360$ 511,270$ 111% 532,350$ 500,099$ 64,861$ Expenditures:Personnel69,324$ 21,554$ 93,228$ 184,106$ 185,365$ 99% 226,890$ 181,397$ 2,709$ Materials & Supplies3,621 38,641 144,466 186,728 189,180 99% 210,920 178,426 8,302 Operational & Contractual 81,737 2,037 5,266 89,040 131,495 68% 160,735 128,757 (39,717) Capital78,377 16,373 - 94,750 35,000 271% 35,000 - 94,750 Total Expenditures233,059$ 78,605$ 242,960$ 554,624$ 541,040$ 103% 633,545$ 488,580$ 66,044$ Direct Revenues Over (Under) Expenditures(81,097)$ (17,322)$ 111,155$ 12,736$ (29,770)$ -43% (101,195)$ 11,519$ 1,217$ B&T Administration Overhead Allocation* (123,611)$ (9,889)$ -$ (133,500)$ (132,685)$ 101% (176,890)$ (60,748)$ (72,752)$ Revenues Over (Under) Expenditures(204,708)$ (27,211)$ 111,155$ (120,764)$ (162,455)$ 74% (278,085)$ (49,229)$ (71,535)$ Transfer From General Fund -$ -$ -$ -$ -$ 0% -$ -$ -$ Adjusted Revenues Over (Under) Expenditures(204,708)$ (27,211)$ 111,155$ (120,764)$ (162,455)$ (278,085)$ (49,229)$ (71,535)$ *Overhead allocation is comprised of salaries, business forms, liability insurance, building & grounds maintenance and bank service fees in Program 811 - Sports Core General Operations distributed to various Sports Core Programs on a percentage basis.
Village of Oak BrookMonthly Operating StatementGolf Club ProgramsFor the Period Ending September 30, 20179/30/17 9/30/17831 832 833 834 9/30/17 YTD % of 2017 9/30/16 DifferenceGolf General Golf Learning Golf Cart Golf Course YTD Amended Amended Adopted YTD PriorOperation & Practice Operations Maintenance Total Budget Budget Budget Total YearRevenues:Memberships189,963$ -$ -$ -$ 189,963$ 180,000$ 106% 166,000$ 180,262$ 9,701$ Greens Fees866,389 - - - 866,389 787,960 110% 840,000 789,500 76,889 Pro Shop Sales163,230 - - - 163,230 173,000 94% 190,000 159,067 4,163 Golf Lessons- 43,119 - - 43,119 30,250 143% 30,250 40,053 3,066 Driving Range Fees- 227,788 - - 227,788 215,500 106% 225,000 214,026 13,762 Rentals4,218 - 326,897 - 331,115 322,965 103% 327,850 316,363 14,752 Other Revenue18,195 - - - 18,195 5,200 350% 5,200 6,236 11,959 Total Revenue1,241,995$ 270,907$ 326,897$ -$ 1,839,799$ 1,714,875$ 107% 1,784,300$ 1,705,507$ 134,292$ Expenditures:Personnel371,103$ 44,828$ 45,007$ 360,186$ 821,124$ 841,400$ 98% 1,155,960$ 864,085$ (42,961)$ Materials & Supplies106,167 11,243 4,437 150,551 272,398 367,710 74% 423,250 260,219 12,179 Operational & Contractual 167,593 13,412 6,054 38,700 225,759 229,180 99% 248,790 180,578 45,181 Other- - - (186,200) (186,200) (206,200) 90% (206,200) (206,200) 20,000 Capital33,617 - - 17,205 50,822 90,500 56% 130,000 82,035 (31,213) Total Expenditures678,480$ 69,483$ 55,498$ 380,442$ 1,183,903$ 1,322,590$ 90% 1,751,800$ 1,180,717$ 3,186$ Direct Revenues Over (Under) Expenditures563,515$ 201,424$ 271,399$ (380,442)$ 655,896$ 392,285$ 167% 32,500$ 524,790$ 131,106$ Transfer from General Fund -$ -$ -$ -$ -$ -$ 0% -$ -$ -$ Adjusted Revenues Over (Under) Expenditures563,515$ 201,424$ 271,399$ (380,442)$ 655,896$ 392,285$ 32,500$ 524,790$ 131,106$