Administration & Finance Committee
Regular MeetingNorthbrook, IL · October 7, 2014
Minutes
APPROVED
MINUTES OF A MEETING OF THE
ADMINISTRATION AND FINANCE COMMITTEE
VILLAGE OF NORTHBROOK
COOK COUNTY, ILLINOIS
OCTOBER 7, 2014
CALL TO ORDER
Trustee Scolaro called the meeting to order at 6:35 p.m. On roll call, attending were Trustees
Karagianis, Buehler, Scolaro, Heller, Ciesla, Israel and President Frum (arrived at 7:45). A quorum was
present. Also attending were Village Manager Richard Nahrstadt; Deputy Village Manager and Chief
Financial Officer Jeff Rowitz; Village Clerk Debbie Ford; Rob Sabo, Assistant to the Village Manager; Director
of Development and Planning Services Tom Poupard; Kelly Hamill, Director of Public Works; Lori Baker,
Chief Information Officer; Emma Perley, Management Analyst, Fire Department; Fire Chief, Mark Nolan,
Deputy Fire Chief Tim Smeltzer; Tim Cassidy, Division Chief of Training and Safety, Fire Department; Jason
Batalden, Internal Services Administrator, Police Department, Chief of Police Charles Wernick; Deputy
Police Chief Lou Caruso; Deputy Police Chief Scott Dunham; Mike Strong, Management Analyst,
Development and Planning Services Department; Betsy Garibaldi, Assistant Finance Director; Iwona
Petryszak, Accounting Manager.
HEAR FROM THE AUDIENCE
None.
FY 13/14 YEAR END REVIEW
Trustee Scolaro said that the Village soon will accept bids on approximately $26 million in bonds.
Of this total, $7.3 million will be used to fund budgeted capital improvements to the Village’s water,
sanitary sewer, and stormwater sewer systems, and to purchase a replacement fire engine and ambulance.
The remaining proceeds will be used to refund existing bonds issued in 2007 & 2008 for infrastructure
improvements, which will provide the Village an estimated savings of $750,000. Trustee Scolaro stated that
Moody’s and Standard & Poor’s have both confirmed their highest ratings for the Village (Aaa/AAA).
Trustee Scolaro also noted comments from the rating agency reports which highlighted the Village’s strong
financial operations, strong budgetary performance, very strong management conditions, strong financial
policies and practices, and modest debt level. Trustee Scolaro commended Village Manager Nahrstadt and
Deputy Village Manager /Chief Financial Officer Rowitz on their work.
Trustee Karagianis said that the rating agencies had said that the Village’s debt is modest. He asked
how this compares to other municipalities and whether it can be tracked routinely. He said that the
comparison does not have to be limited to municipalities in Illinois. He said that the Village should identify
what level of debt (or what other measure) might be used as a warning of future financial problems.
Trustee Scolaro said that the Village could ask the ratings agencies what criteria they use to measure
likelihood of default or other aspects of municipal financial condition.
Deputy Village Manager and Chief Financial Officer Rowitz said that the FY13/14 audit is complete.
The Village ended the fiscal year in better condition than expected. Revenues exceeded budgeted
amounts, and expenses were less than budgeted levels. At the end of FY13/14, the Village had $2.7 million
in its General Fund over and above the 40 percent of budgeted revenues that are to be kept in reserve as
per Village policy. He noted that last year (after the close of FY12-13), the Village transferred an excess of
$1.2 million from its General Fund to the Infrastructure Capital Projects Fund to be used for street
improvements. The Committee then discussed whether the 40 percent reserve goal is a Village policy or
rather a long-standing practice. President Frum said that she believed it was a policy adopted many years
ago via resolution. She said that if the Village contemplates changing this policy, it would be wise to first
determine how any change might affect the Village’s bond rating. The Committee also generally discussed
how much a triple-A bond rating saves in interest costs. For example, how much would the Village’s cost of
capital increase if its bond rating dropped to AA? Would it benefit Village residents to abandon the 40
percent reserve policy? Is the reserve (or the reserve policy) needed to maintain a superior bond rating?
The general consensus was to discuss this at the next quarterly meeting of the Administration and Finance
Committee.
Deputy Village Manager and Chief Financial Officer Rowitz said that FY13-14 expenses were
approximately $2 million under budget in part because certain major capital expenses were deferred until
key staff positions were filled. For example, the Village deferred its purchase of an ERP (enterprise resource
planning) system and other technology updates until the position of Chief Information Officer was filled.
This money (approximately $1.35 million) will be spent in FY14-15 now that the position has been filled.
The Committee then discussed specific revenues and expenses for FY13-14. Actual revenues did
not vary significantly from projections. Overtime expenses varied by only $6,000 between FY12-13 and
FY13-14. Deputy Village Manager and Chief Financial Officer Rowitz said that overtime expenses in future
years will be higher because the Village will begin to report not only dollars paid, but also compensatory
time carried on its books. This change is not required by Generally Accepted Accounting Principles (GAAP),
but will be adopted nonetheless in order to provide a more conservative representation of the Village’s
liabilities.
The Committee briefly discussed whether the Village should hire more police officers and fire
fighters to reduce the amount of overtime paid. Village Manager Nahrstadt said that one new police officer
is currently in the police academy. A second will be hired in FY15-16. He said that the Fire Department has
indicated that it is best to continue to operate by filling two line vacancies with overtime.
FIRST QUARTER (FY 14/15) BUDGET REVIEW
Deputy Village Manager and Chief Financial Officer Rowitz reviewed the Village’s budget and actual
results for the first quarter of FY14-15. Expenses for the first quarter are $300,000 under budget in part
because of temporary staff vacancies. The Committee then discussed whether the Village should budget
for some type of hiring lag to account for turnover which occurs during the fiscal year. Village Manager
Nahrstadt said that the Village budgets for 100 percent of salaries in order to be conservative. President
Frum said that it may be hard to predict in what department the vacancies will occur. Mr. Rowitz said that
payments in the “Personal Services” line item of the budget include not just base salaries, but also
overtime. He said that in FY13-14, the Village exceeded its budget for Personal Services by $13,000
because of overtime. A brief straw poll showed that a majority of elected officials attending the meeting
wished to continue to budget staff salaries at 100 percent, i.e., without a factor to account for hiring and
turnover lags.
Deputy Village Manager and Chief Financial Officer Rowitz said that sales tax revenue was slightly
under budget in the first quarter, but new stores opening in the Village Square shopping center are
expected to more than compensate for this variance.
Director of Development and Planning Services Tom Poupard gave an overview on the Economic
Data for Northbrook as follows:
Office, Industrial & Retail Vacancies.
He explained the office market is weak; there is more permit activity in the industrial areas.
Retail vacancies are going down from the landlord’s perspective. This does not include banks or
empty spaces, e.g. Walgreens.
Unemployment Rates.
Unemployment rates are going down in Northbrook; jobs are increasing
Local Sales’ Tax Collections.
Sales tax is down. One reason is due to the closing of Dominick’s
Hotel Revenue
No big changes, following normal trend.
Housing Market
Single Family Homes are steadily climbing up
The average sale price is meaningless because it depends on the number of homes on the market.
Building Permits
Cumulative construction value in 2013 was up from 2012, but in 2014 was down from 2013.
Major permits are climbing
New single family homes are up (most dramatic)
Additions have dropped off
Commercial permits are going up
Office permits are going down, industrial is going up – but both are realistically erratic..
Trustee Ciesla moved, seconded by Trustee Karagianis to adjourn the meeting at 7:30pm. On voice
vote, all were in favor.
Agenda
ADMINISTRATION & FINANCE COMMITTEE
NORTHBROOK VILLAGE HALL, 1225 CEDAR LANE
October 7, 2014, 6:30 P.M., TERRACE ROOM
The Administration & Finance Committee of the Village of Northbrook Board of Trustees will hold a
meeting on Tuesday, October 7, 2014 at 6:30 p.m. in the Terrace Room of the Village Hall, 1225
Cedar Lane, Northbrook, Illinois. The following will be discussed.
MEETING AGENDA
1. CALL TO ORDER
2. HEAR FROM THE AUDIENCE
3. FY 13/14 YEAR END REVIEW
4. FIRST QUARTER (FY 14/15) BUDGET REVIEW
5. ADJOURN
Michael Scolaro, Chair
Administration/Finance Committee
Members: Trustee Karagianis
Trustee Ciesla
Village of Northbrook
Cook County, Illinois
October 7, 2014
The Village of Northbrook is subject to the requirements of the Americans with Disabilities Act of 1990.
Individuals with disabilities who plan to attend this meeting and who require certain accommodations in
order to allow them to observe and/or participate in this meeting, or who have questions regarding the
accessibility of this meeting or the facilities, are requested to contact Greg Van Dahm or Debbie Ford (664-
4014 or 4013respectively) promptly to allow the Village of Northbrook to make reasonable accommodations
for those persons. Hearing impaired individuals may call the TDD number, 564-8645, for more information.
ADMINISTRATION & FINANCE COMMITTEE
OCTOBER 7, 2014 ADMINISTRATION & FINANCE
COMMITTEE MEETING ATTACHMENTS
1. FY 13-14 General Fund Revenue and Expenditures Summary
2. FY 13-14 General Fund Revenue
3. FY13-14 General Fund Expenditures and Fund Balance
4. FY13-14 Quarterly Overtime Report
5. Memorandum Regarding FY 14-15 First Quarter Financial Reports
6. FY 14-15 General Fund Revenue and Expenditure Summary
7. FY 14-15 General Fund Revenue
8. FY 14-15 General Fund Expenditures and Fund Balance
9. Sales Tax Collections
10. FY 14-15 Quarterly Overtime Report
11. Debt Service Schedule
12. Investment Report
13. Northbrook Economic Data Quarterly Report – October, 2014
Revenue and Expense Projections
General Fund (without special revenue funds) *
Fiscal Year 2013/14
Variance from Original Budget
Original Amended Sept. 2013 January 2014 Audited Original Sept. 2013 January 2014 Audited
Budget Budget Estimate Estimate Actual Budget Estimate Estimate Actual
Revenue $ 41,365,700 $ 41,365,700 $ 41,667,385 $42,229,326 $ 42,490,745 0.73% 2.09% 2.72%
Expense $ 40,921,500 $ 40,938,780 $ 40,735,385 $40,775,508 $ 39,003,970 -0.45% -0.36% -4.69%
Surplus (Deficit) $ 444,200 $ 426,920 $ 932,000 $ 1,453,818 $ 3,486,775
Equity Transfer $ (1,200,000) $ (1,200,000)
Assigned Bond Proceeds $ (650,000)
Fund Balance $ 18,205,608 $ 18,188,328 $ 18,963,517 $18,311,430 $ 19,694,387 4.16% 0.58% 8.18%
as a % of revenue 44.0% 44.0% 45.5% 43.4% 46.3%
as a % of expense 44.5% 44.4% 46.6% 44.9% 50.5%
Fund Balance above 40%
target $ 1,659,328 $ 1,642,048 $ 2,296,563 $ 1,419,700 $ 2,698,089
* Restricted revenues drug forfeiture and foreign fire taxes and the associated expenses have been deducted.
Village of Northbrook
General Fund Revenue Projections
Fiscal Year 2014 - Final
October 7, 2014
Over (Under)
Account FY 2012/13 FY 2013/14 September 2013 January 2014 Budget
Number Actual Budget Estimate Estimate Final $ %
Property Taxes 401-00/11 7,685,720 7,820,750 7,820,750 7,820,750 7,595,621 (225,129) -2.88%
Township Road and Bridge Tax 401-06/16 456,927 380,000 400,000 420,000 442,032 62,032 14.77%
Replacement Taxes
Corporate 405-01 364,466 385,000 385,000 385,000 417,089 32,089 8.33%
Township Road and Bridge 405-03 11,143 12,500 12,500 12,500 12,749 249 1.99%
Total Replacement Taxes 375,609 397,500 397,500 397,500 429,838 32,338 8.14%
Sales Tax
Retail Sales Tax 421-00 12,344,249 12,652,445 12,275,000 12,105,000 12,018,089 (634,356) -5.24%
Auto Rental Tax 421-01 11,946 12,000 11,000 12,000 11,007 (993) -8.28%
Use Tax 421-03 525,915 537,355 553,940 553,940 580,828 43,473 7.85%
Total Sales Tax 12,882,110 13,201,800 12,839,940 12,670,940 12,609,924 (591,876) -4.67%
Income Tax
State Income Tax 422-00 3,111,609 3,164,415 3,098,100 3,207,500 3,162,141 (2,274) -0.07%
Total Income Taxes 3,111,609 3,164,415 3,098,100 3,207,500 3,162,141 (2,274) -0.07%
Over (Under)
Account FY 2012/13 FY 2013/14 September 2013 January 2014 Budget
Number Actual Budget Estimate Estimate Final $ %
Other Taxes
Hotel/Motel Occupancy Tax 407-01 785,140 750,000 800,000 800,000 821,687 71,687 8.96%
Utility Tax 407-03,04 1,124,312 1,050,000 1,100,000 1,100,000 1,182,658 132,658 12.06%
Telecommunications Tax 478-06 1,041,003 2,500,000 2,750,000 3,600,000 3,688,219 1,188,219 33.01%
Admissions/Entertainment Tax 407-02 114,267 110,000 110,000 110,000 110,382 382 0.35%
Total Other Taxes 3,064,722 4,410,000 4,760,000 5,610,000 5,802,946 1,392,946 24.83%
Permits
Building 452-00/02 1,550,035 1,100,000 1,500,000 1,500,000 1,671,654 571,654 38.11%
Alarm 454-03 4,050 7,500 7,000 4,500 4,820 (2,680) -59.56%
Total Permits 1,554,085 1,107,500 1,507,000 1,504,500 1,676,474 568,974 37.82%
Licenses
Animal 435-01 21,522 21,500 21,500 22,500 24,304 2,804 12.46%
Business/Liquor 435-02/04 313,236 335,000 335,000 335,000 306,690 (28,310) -8.45%
Vehicle 435-05 583,659 585,000 585,000 575,000 599,936 14,936 2.60%
Total Licenses 918,417 941,500 941,500 932,500 930,930 (10,570) -1.13%
Interest Income
General Fund 426-01 41,769 100,000 75,000 50,000 50,138 (49,862) -99.72%
Property Tax 426-09/19 110 1,500 100 1,500 131 (1,369) -91.27%
Total Interest Income 41,879 101,500 75,100 51,500 50,269 (51,231) -99.48%
Fees:
RFPD Fees 451-00 2,420,839 2,491,000 2,491,000 2,491,000 2,498,853 7,853 0.32%
RED Center Administration Fees 451-01 18,500 20,000 20,000 20,000 20,000 0 0.00%
Elevator Inspections 452-01 50,610 52,500 52,200 52,500 36,650 (15,850) -30.19%
Franchise Fees:
Cable Television 478-01/02 635,585 640,000 650,000 650,000 685,533 45,533 7.01%
PEG Activities 478-04 - 0 0 0 1,736 1,736
Total Franchise Fees 635,585 640,000 650,000 650,000 687,269 47,269 7.27%
Over (Under)
Account FY 2012/13 FY 2013/14 September 2013 January 2014 Budget
Number Actual Budget Estimate Estimate Final $ %
Alarm Services Fees:
Police Alarms 454-00 115,907 135,000 135,000 135,000 141,127 6,127 4.54%
Fire Alarms 454-01/02/05 73,346 67,000 67,000 73,500 65,153 (1,847) -2.51%
Total Alarm Services Fees 189,253 202,000 202,000 208,500 206,280 4,280 2.05%
Petitioner Fees:
Plan Commission 457-00 17,957 20,000 20,000 20,000 34,991 14,991 74.96%
Zoning Board of Appeals 479-00 0 5,000 5,000 0 0 (5,000)
Total Petitioner Fees 17,957 25,000 25,000 20,000 34,991 9,991 49.96%
Total Fees 3,332,744 3,430,500 3,440,200 3,442,000 3,484,043 53,543 1.56%
Rental Income:
Meadow Road (Lorenz) 461-03 - 0 - 0
Commuter Station:
The Grind 461-05 6,981 7,000 7,000 7,000 7,561 561 8.01%
Total Rental Income 6,981 7,000 7,000 7,000 7,561 561 8.01%
Fines:
Ordinance Violations 458-01 52,270 50,000 50,000 85,000 73,953 23,953 28.18%
Traffic Court Fines 458-02 156,036 160,000 150,000 160,000 160,557 557 0.35%
Total Fines 208,306 210,000 200,000 245,000 234,510 24,510 10.00%
Over (Under)
Account FY 2012/13 FY 2013/14 September 2013 January 2014 Budget
Number Actual Budget Estimate Estimate Final $ %
Interfund Transfers:
Sanitary Sewer Fund 475-14 452,880 471,005 471,005 471,005 471,005 0 0.00%
Senior Housing Fund 475-15 73,960 76,920 76,920 76,920 76,920 0 0.00%
Stormwater Fund 475-16 70,000 72,800 72,800 72,800 72,800 0 0.00%
Infrastructure CPF Fund 475-40 150,000 0 0 0 0 0
CBD Capital Projects Fund 475-39 0 0 0 0 0 0
Water Production Fund 475-21 608,445 632,735 632,735 632,735 632,735 0 0.00%
Water Distribution Fund 475-21 1,039,230 1,080,810 1,080,810 1,080,810 1,080,810 0 0.00%
Parking Fund 475-22 97,850 101,765 101,765 101,765 101,765 0 0.00%
Cemetary Fund 475-20 1,385 1,450 1,450 1,450 1,450 0 0.00%
Total Interfund Transfers 2,493,750 2,437,485 2,437,485 2,437,485 2,437,485 0 0.00%
Charges for Services:
Overtime Reimb. - Police/Fire/Dev/PW 473-13/15/17 54,323 40,000 40,000 60,000 50,499 10,499 17.50%
GIS Service Fees 473-21 0 1,000 1,000 0 0 (1,000)
Antenna Lease Fees 476-01 224,473 218,300 218,300 218,300 222,305 4,005 1.83%
Weed Cutting/Tree Removal Fees 477-02/05 216 1,000 500 200 0 (1,000) -500.00%
Sign Material Sales 477-06 0 1,000 500 665 665 (335) -50.38%
Reforestation Fees 477-07 15,350 10,000 15,000 20,000 20,325 10,325 51.63%
IDOT Signal Maintenance Fees 477-10 0 2,500 2,500 0 0 (2,500)
Toll Road Responses-Fire/EMS 477-31/32 3,150 20,000 16,000 3,500 1,000 (19,000) -542.86%
Ambulance Transportation Fee 480-02 1,000,163 900,000 900,000 900,000 942,539 42,539 4.73%
Glenbrook North Police Service 480-03 102,787 105,000 105,000 115,690 104,601 (399) -0.34%
Summer School Crossing Guards 480-04 5,864 5,000 10,000 6,310 6,313 1,313 20.81%
Training Fees (Police/Fire) 480-21/31 0 5,000 5,000 0 0 (5,000)
Total Charges for Services 1,406,326 1,308,800 1,313,800 1,324,665 1,348,247 39,447 2.98%
Over (Under)
Account FY 2012/13 FY 2013/14 September 2013 January 2014 Budget
Number Actual Budget Estimate Estimate Final $ %
Miscellaneous:
Surplus Equipment Sales 473-03 35,882 60,000 50,000 40,000 28,359 (31,641) -79.10%
Retail Sale Permits 473-06 7,295 10,000 10,000 10,000 6,335 (3,665) -36.65%
Miscellaneous Income 473-07/09/20 52,307 430,050 430,000 725,000 871,518 441,468 60.89%
Grants 481-15/17/18/30 21,689 0 22,860 22,860 97,924 97,924 428.36%
Court-Ordered DUI Reimbursements 473-08 - 1,000 750 0 - (1,000)
Raffle/Facility Use Fees 473-10/18 360 150 300 500 1,405 1,255 251.00%
Frontage Deposit Fees 473-11 1,185 1,500 1,000 500 1,100 (400) -80.00%
State Route Maintenance 475-04 17,524 20,000 15,000 20,000 17,999 (2,001) -10.01%
Traffic Signal/Street Light Damage 477-03/04 8,187 5,000 5,000 5,000 2,426 (2,574) -51.48%
Impound Fees 477-08 480 1,000 500 1,000 340 (660) -66.00%
Miscellaneous Reimbursements 477-09 27,805 5,000 30,000 5,000 7,709 2,709 54.18%
Annexation Fees 480-19 59,618 157,500 157,500 102,500 33,460 (124,040) -121.01%
Bond Proceeds 406-02 275,000 1,456,100 1,456,100 1,225,626 1,210,149 (245,951) -20.07%
Total Miscellaneous 507,332 2,147,300 2,179,010 2,157,986 2,278,724 131,424 6.09%
TOTAL GENERAL CORP FUND 38,046,517 41,066,050 41,417,385 42,229,326 42,490,745 1,424,695 3.37%
Village of Northbrook
General Corporate Fund
Expenditure Summary By Department (Without Special Revenue Funds)
FY 2013/14
October 7, 2014
FY14 FY14 Over (Under)
Original Amended January 2014 FY14 Budget
Budget Budget Estimate Final $ %
LEGISLATIVE
Personal Services 41,400 41,400 41,400 41,200 (200) -0.48%
Fringe Benefits 3,100 3,100 3,150 3,151 51 1.65%
Contractual Services 248,350 266,130 253,780 253,393 (12,737) -4.79%
Capital Outlay - - - - -
Other - - - - -
Total 292,850 310,630 298,330 297,744 (12,886) -4.15%
ADMINISTRATIVE
Personal Services 1,397,070 1,345,908 1,227,220 1,229,582 (116,326) -8.64%
Fringe Benefits 449,880 449,880 406,500 404,447 (45,433) -10.10%
Contractual Services 780,100 831,262 800,400 753,086 (78,176) -9.40%
Commodities 4,750 4,750 7,500 8,480 3,730 78.53%
Capital Outlay 849,000 849,000 849,000 56,545 (792,455) -93.34%
Total 3,480,800 3,480,800 3,290,620 2,452,140 (1,028,660) -29.55%
Total w/o Capital 2,631,800 2,631,800 2,441,620 2,395,595 (236,205) -8.98%
LEGAL
Contractual Services 585,400 585,400 635,400 549,394 (36,006) -6.15%
Total 585,400 585,400 635,400 549,394 (36,006) -6.15%
FINANCE
Personal Services 756,950 756,950 742,165 767,792 10,842 1.43%
Fringe Benefits 280,910 280,910 275,585 270,740 (10,170) -3.62%
Contractual Services 206,790 206,790 211,890 203,101 (3,689) -1.78%
Commodities 26,600 26,600 21,600 21,439 (5,161) -19.40%
Capital Outlay 2,000 2,000 8,000 6,204 4,204 210.20%
Total 1,273,250 1,273,250 1,259,240 1,269,276 (3,974) -0.31%
Total w/o Capital 1,271,250 1,271,250 1,251,240 1,263,072 (8,178) -0.64%
FY14 FY14 Over (Under)
Original Amended January 2014 FY14 Budget
Budget Budget Estimate Final $ %
POLICE
Personal Services 9,610,650 9,610,650 9,760,740 9,782,473 171,823 1.79%
Fringe Benefits 1,902,995 1,902,995 1,895,495 1,903,582 587 0.03%
Contractual Services 1,418,655 1,418,655 1,422,425 1,258,034 (160,621) -11.32%
Commodities 553,325 553,325 498,715 470,170 (83,155) -15.03%
Capital Outlay 704,100 704,100 618,400 169,164 (534,936) -75.97%
Total 14,189,725 14,189,725 14,195,775 13,583,423 (606,302) -4.27%
Total w/o Capital 13,485,625 13,485,625 13,577,375 13,414,259 (71,366) -0.53%
FIRE
Personal Services 7,877,555 7,877,555 7,822,765 7,748,579 (128,976) -1.64%
Fringe Benefits 1,467,685 1,467,685 1,460,005 1,456,936 (10,749) -0.73%
Contractual Services 1,332,715 1,342,076 1,328,325 1,312,218 (29,858) -2.22%
Commodities 452,890 452,890 453,410 462,761 9,871 2.18%
Capital Outlay 10,000 10,000 10,000 10,112 112 1.12%
Total 11,140,845 11,150,206 11,074,505 10,990,606 (159,600) -1.43%
Total w/o Capital 11,130,845 11,140,206 11,064,505 10,980,494 (159,712) -1.43%
PUBLIC WORKS
Personal Services 3,320,570 3,320,570 3,333,625 3,380,228 59,658 1.80%
Fringe Benefits 1,248,870 1,248,870 1,225,480 1,203,713 (45,157) -3.62%
Contractual Services 1,851,550 1,851,550 1,745,740 1,570,547 (281,003) -15.18%
Commodities 711,250 711,250 838,300 823,282 112,032 15.75%
Capital Outlay 852,120 852,120 845,975 817,374 (34,746) -4.08%
Total 7,984,360 7,984,360 7,989,120 7,795,144 (189,216) -2.37%
Total w/o Capital 7,132,240 7,132,240 7,143,145 6,977,770 (154,470) -2.17%
DEVELOPMENT & PLANNING
Personal Services 1,000,265 1,000,265 1,008,455 1,016,613 16,348 1.63%
Fringe Benefits 489,695 489,695 487,160 469,348 (20,347) -4.16%
Contractual Services 478,960 504,960 530,953 573,107 68,147 13.50%
Commodities 3,450 3,450 4,550 5,138 1,688 48.93%
Capital Outlay 1,900 1,900 1,400 2,037 137 7.21%
Total 1,974,270 2,000,270 2,032,518 2,066,243 65,973 3.30%
Total w/o Capital 1,972,370 1,998,370 2,031,118 2,064,206 65,836 3.29%
FY14 FY14 Over (Under)
Original Amended January 2014 FY14 Budget
Budget Budget Estimate Final $ %
ALL DEPARTMENTS
Total 40,921,500 40,974,641 40,775,508 39,003,970 (1,970,671) -4.81%
Total w/o Capital 37,624,130 38,555,521 38,442,733 37,095,396 (564,095) -1.46%
TOTAL BY CLASS
Personal Services 24,004,460 23,953,298 23,936,370 23,966,467 13,169 0.05%
Fringe Benefits 5,843,135 5,843,135 5,753,375 5,711,917 (131,218) -2.25%
Contractual Services 6,902,520 7,006,823 6,928,913 6,472,880 (533,943) -7.62%
Commodities 1,752,265 1,752,265 1,824,075 1,791,270 39,005 2.23%
Capital Outlay 2,419,120 2,419,120 2,332,775 1,061,436 (1,357,684) -56.12%
Total 40,921,500 40,974,641 40,775,508 39,003,970 (1,970,671) -4.81%
PROJECTED REVENUES 41,366,050 41,366,050 42,229,326 42,490,745 1,124,695 2.72%
SURPLUS / (DEFICIT) 444,550 391,409 1,453,818 3,486,775
EQUITY TRANSFER OUT (1,200,000) (1,200,000)
ADJUSTED SURPLUS 253,818 2,286,775
ASSIGNED BOND PROCEEDS (650,000)
PROJECTED FUND BALANCE 18,502,162 18,449,021 18,311,430 19,694,387
Fund Balance as a % of Revenue 44.7% 44.6% 43.4% 46.3%
Fund Balance as a % of Expense 45.2% 45.0% 44.9% 50.5%
Fund Balance above 40% policy 1,955,742 1,902,601 1,419,700 2,698,089
Comparative Overtime Report
First Quarter Second Quarter Third Quarter Fourth Quarter Total
FY 12/13 FY 13/14 FY 12/13 FY 13/14 FY 12/13 FY 13/14 FY 12/13 FY 13/14 FY 12/13 FY 13/14
General Government
Regular overtime 95.43 67.50 - 50.61 2,504.44 2884.51 842.33 1,495.39 3,442.20 4,498.01
Total General Government 95.43 67.50 - 50.61 2,504.44 2,884.51 842.33 1,495.39 3,442.20 4,498.01
Finance Department
Vehicle licenses 1,911.19 1,417.18 - - - - - - 1,911.19 1,417.18
Regular overtime 836.31 2,464.44 617.27 4,352.60 2,838.98 2,452.11 2,793.13 1,998.82 7,085.69 11,267.97
- -
Total Finance Department 2,747.50 3,881.62 617.27 4,352.60 2,838.98 2,452.11 2,793.13 1,998.82 8,996.88 12,685.15
Police Department
Roll call 31,179.72 32,612.58 31,382.23 32,077.65 31,386.63 32,109.22 31,386.63 32,172.36 125,335.21 128,971.81 Preparation and participation in
daily roll call, checking
equipment, and providing
assignments at the beginning of
each shift.
FLSA 22,825.84 23,694.04 23,511.62 23,591.74 23,258.00 23,361.74 23,091.48 23,918.04 92,686.94 94,565.56 The Fair Labor Standards Act
provides exceptions to the seven
day work period for police and fire
employees due to the nature of 24
hour shifts in fire and 12 hour
shifts for police. While this
exception allows more hours
worked than 40 per week before
overtime is required, these shifts
slightly exceed the limit so
compensation must be adjusted
accordingly.
Shift holdover 18,424.90 17,157.44 29,841.37 13,368.52 21,082.99 11,854.39 18,565.51 11,796.47 87,914.77 54,176.82 Completion of arrest or assignment
which occurs near end of a shift.
Regular/Speciality recall 22,244.50 42,465.30 21,133.06 31,918.48 50,057.41 31,537.67 30,152.95 21,409.88 123,587.92 127,331.33 Need based recall of officers with
specific certifications or training.
Includes Evidence Technicians,
Accident Investigators and Canine
Officer.
Comparative Overtime Report
First Quarter Second Quarter Third Quarter Fourth Quarter Total
FY 12/13 FY 13/14 FY 12/13 FY 13/14 FY 12/13 FY 13/14 FY 12/13 FY 13/14 FY 12/13 FY 13/14
Meetings/Training 24,562.53 33,691.41 9,894.12 31,592.21 59,627.65 35,841.11 33,720.11 36,984.50 127,804.41 138,109.23 Primarily comprised of required
training which cannot be
completed while on duty. Also
includes special team meetings as
needed.
Special Assignments 28,100.09 17,319.74 14,382.11 20,604.53 18,080.44 15,834.22 14,512.00 1,525.60 75,074.64 55,284.09 Significant decrease is mainly due
to NATO Summit in 2013.
Private details (reimbursable) 3,755.03 7,239.88 15,807.67 16,714.66 6,393.36 3,933.22 5,968.21 4,459.22 31,924.27 32,346.98
Court time 23,631.37 22,943.28 26,537.54 25,817.09 25,639.08 26,683.68 26,140.30 20,906.69 101,948.29 96,350.74
Minimum manning 44,909.08 75,117.18 37,716.34 37,895.70 57,593.13 53,463.03 61,570.55 52,543.66 201,789.10 219,019.57 Hireback of officers to maintain
minimum required staffing of
shift. This occurs when an officer
is ill or injured, or called to
participate in a regional
investigation. First quarter of FY
13/14 shows significant increase
due to staffing shortage related to
terminations and retirements.
Northbrook Days (partial reimb.) 302.16 3,724.06 22,840.59 21,842.59 - - - - 23,142.75 25,566.65
Community relations 3,671.56 1,654.83 2,155.99 1,756.56 851.59 895.18 945.76 1,353.19 7,624.90 5,659.76 Includes National Night Out and
other community events.
4th of July 12,038.72 13,103.44 247.10 - - - 494.19 - 12,780.01 13,103.44
NIPAS/NORTAF 4,303.67 16,144.66 9,749.22 15,544.92 15,725.03 7,321.87 4,228.00 7,285.97 34,005.92 46,297.42
Total Overtime Worked 239,949.17 306,867.84 245,198.96 272,724.65 309,695.31 242,835.33 250,775.69 214,355.58 1,045,619.13 1,036,783.40
LESS: Hours accumulated as PTO (70,494.02) (90,923.51) (63,683.22) (82,178.00) (93,911.55) (85,978.92) (72,699.67) (105,455.54) (300,788.46) (364,535.97)
Overtime Paid Out 169,455.15 215,944.33 181,515.74 190,546.65 215,783.76 156,856.41 178,076.02 108,900.04 744,830.67 672,247.43
Comparative Overtime Report
First Quarter Second Quarter Third Quarter Fourth Quarter Total
FY 12/13 FY 13/14 FY 12/13 FY 13/14 FY 12/13 FY 13/14 FY 12/13 FY 13/14 FY 12/13 FY 13/14
Fire Department
FLSA 6,867.00 8,905.00 7,682.00 6,887.00 7,946.00 9,269.00 7,908.00 6,804.00 30,403.00 31,865.00 The Fair Labor Standards Act
provides exceptions to the seven
day work period for police and fire
employees due to the nature of 24
hour shifts in fire and 12 hour
shifts for police. While this
exception allows more hours
worked than 40 per week before
overtime is required, these shifts
slightly exceed the limit so
compensation must be adjusted
accordingly.
Shift holdover 5,718.00 5,267.00 4,579.00 4,626.00 7,100.00 4,718.00 3,922.00 3,511.00 21,319.00 18,122.00 Completion of an emergency call
which occurs near the end of a
shift.
Regular/recall 15,743.00 4,575.00 5,360.00 4,466.00 6,684.00 3,843.00 2,810.00 1,804.00 30,597.00 14,688.00 Emergency call-back to staff
reserve apparatus and/or a station
due to an extended large scale
incident, or multiple alarms.
Significant decrease is mainly due
to NATO Summit in 2013.
Meetings/Training 2,735.00 2,573.00 3,191.00 6,884.00 6,679.00 22,486.00 20,572.00 14,730.00 33,177.00 46,673.00 Meetings (includes special team
meetings as needed) and Required
training which cannot be
completed while on duty (i.e. live
fire, CPR).
Special teams training 14,339.00 10,623.00 11,120.00 15,242.00 8,515.00 11,737.00 18,537.00 13,878.00 52,511.00 51,480.00 Specialized training for Dive,
Technical Rescue, and Hazmat
teams which cannot be completed
while on duty.
Minimum manning 87,162.00 84,527.00 99,323.00 29,684.00 39,224.00 118,940.00 75,346.00 70,612.00 301,055.00 303,763.00 Hireback of
firefighters/paramedics to maintain
minimum required staffing of
shift. Mainly occurs when a
firefighter is ill or injured.
CERT Training (REIMBURS) - 1,623.00 906.00 2,873.00 544.00 - 1,886.00 4,496.00 3,336.00
Open house - 1,587.00 735.00 - - - - 1,587.00 735.00
Northbrook Days 816.00 5,759.00 466.00 - - - - 5,759.00 1,282.00
4th of July 1,267.00 784.00 - - - - - - 1,267.00 784.00
Comparative Overtime Report
First Quarter Second Quarter Third Quarter Fourth Quarter Total
FY 12/13 FY 13/14 FY 12/13 FY 13/14 FY 12/13 FY 13/14 FY 12/13 FY 13/14 FY 12/13 FY 13/14
Total Overtime Worked 133,831.00 118,070.00 140,224.00 69,896.00 79,021.00 171,537.00 129,095.00 113,225.00 482,171.00 472,728.00
LESS: Hours accumulated as PTO (14,795.00) (14,847.00) (22,048.00) (20,833.00) (16,541.00) (16,398.00) (18,041.00) (18,193.00) (71,425.00) (70,271.00)
Overtime Paid Out 119,036.00 103,223.00 118,176.00 49,063.00 62,480.00 155,139.00 111,054.00 95,032.00 410,746.00 402,457.00
Public Works
Streets & sidewalks 505.75 4,660.04 39.81 1,369.83 2,039.78 1,269.92 1,506.17 5,556.20 4,091.51 12,855.99
The Village had 22 snow and ice
control events in the 3rd Quarter
of FY 13/14. The average for a
season is 19-20. The majority of
these events occurred in the
evening, or on weekends or
holidays. During the 4th Quarter,
there were additional 8 snow and
ice events, most of which occurred
Snow & Ice control 26.39 - 4,200.60 - 26,512.29 222,121.98 83,321.87 100,342.01 114,061.15 322,463.99 in the evening or on weekends.
Parkway & street lights 1,258.61 410.02 176.15 410.01 600.16 540.70 141.56 81.07 2,176.48 1,441.80
Storm sewer 1,594.52 5,471.41 1,182.06 1,018.33 1,666.51 3,712.94 10,482.84 5,738.98 14,925.93 15,941.66
Sanitary sewer 3,599.35 4,246.41 3,314.85 2,834.08 3,037.07 1,973.13 3,791.07 6,865.65 13,742.34 15,919.27
Village building 336.87 1,069.41 1,744.23 959.91 410.63 2,679.49 1,261.85 1,505.16 3,753.58 6,213.97
During the 3rd Quarter the Village
had 2 ambulances down for repairs
at the same time. Mechanics
worked overtime to get them back
Fleet 2,447.81 190.68 1,811.85 470.53 - 2,667.99 2,387.77 246.91 6,647.43 3,576.11 in service.
Water Production & Dist. 27,922.17 13,729.74 16,145.31 15,919.21 17,985.45 18,801.73 15,836.39 14,661.55 77,889.32 63,112.23
Water main breaks 56,042.46 2,392.94 19,879.65 9,434.62 42,274.02 22,620.21 12,713.46 22,200.85 130,909.59 56,648.62 Decreased water main breaks. FY
12/13 - 163 compared to 87 in
FY13/14.
JULIE Locates 2,393.07 3,281.19 2,112.24 2,115.54 1,954.57 1,788.47 2,037.48 598.69 8,497.36 7,783.89
Engineering plan review & insp. 2,038.24 2,429.57 4,920.89 1,893.48 365.97 1,276.82 1,064.64 272.82 8,389.74 5,872.69
Northbrook Days - - - - - - - - - -
Family Dinner - - 1,183.23 - - 1,802.46 - - 1,183.23 1,802.46
Earth Day 4,763.93 - - - - - 4,588.04 4,504.07 9,351.97 4,504.07
Misc. Special Events - 5,537.90 - 243.68 - - - - 5,781.58
4th of July 1,973.79 2,261.82 265.42 - - - - - 2,239.21 2,261.82
Roll call 5,091.37 5,305.05 5,180.22 5,309.62 5,180.22 5,309.62 5,180.22 5,309.62 20,632.03 21,233.91
Trees & storm damage 1,457.91 2,899.72 580.74 2,659.99 1,637.87 1,516.11 763.69 566.76 4,440.21 7,642.58
Total Overtime Worked 111,452.24 53,885.90 62,737.25 44,638.83 103,664.54 288,081.57 145,077.05 168,450.34 422,931.08 555,056.64
Comparative Overtime Report
First Quarter Second Quarter Third Quarter Fourth Quarter Total
FY 12/13 FY 13/14 FY 12/13 FY 13/14 FY 12/13 FY 13/14 FY 12/13 FY 13/14 FY 12/13 FY 13/14
LESS: Hours accumulated as PTO (33,950.24) (18,718.11) (19,861.56) (17,797.83) (50,730.35) (141,439.57) (37,279.59) (13,344.86) (141,821.74) (191,300.37)
Overtime Paid Out 77,502.00 35,167.79 42,875.69 26,841.00 52,934.19 146,642.00 107,797.46 155,105.48 281,109.34 363,756.27
General Fund 18,790.47 16,661.72 18,391.24 9,037.00 25,386.57 89,021.00 53,032.04 88,928.20 115,600.32 203,647.92
Water Fund 50,313.53 14,012.75 19,920.50 14,327.00 24,082.90 45,211.00 43,989.18 48,608.14 138,306.11 122,158.89
Sewer Fund 6,219.00 4,196.05 1,472.54 3,329.00 3,226.03 6,525.00 9,901.50 10,769.90 20,819.07 24,819.95
Storm Water Fund 2,179.00 297.27 1,908.18 148.00 1,421.92 5,885.00 874.74 6,799.24 6,383.84 13,129.51
77,502.00 35,167.79 41,692.46 26,841.00 54,117.42 146,642.00 107,797.46 155,105.48 281,109.34 363,756.27
Development & Planning Services
Regular overtime 452.11 2,363.43 476.66 1,683.92 1,594.80 463.55 2,936.24 (135.54) 5,459.81 4,375.36
Total Dev. & Planning Services 452.11 2,363.43 476.66 1,683.92 1,594.80 463.55 2,936.24 (135.54) 5,459.81 4,375.36
GRAND TOTAL 369,288.19 360,647.67 343,661.36 272,537.78 338,136.17 464,437.58 403,499.18 362,396.19 1,454,584.90 1,460,019.22
MEMORANDUM
TO: Richard A. Nahrstadt, Village Manager
FROM: Jeffrey L. Rowitz, Deputy Village Manager/CFO
DATE: October 3, 2014
RE: FY 2014/15 First Quarter Financial Reports
Attached please find the General Fund revenue and expense reports for the first quarter budget review.
These reports show budgeted and actual results for the first quarter as well as staff’s current projections
for the remainder of the fiscal year.
The FY 2014/15 budget projected a General Fund surplus for the year of $259,960. As shown in the
attached schedules, we are currently projecting the General Fund surplus to be $577,715. The material
differences are described below.
Revenues
We currently estimate that revenues will be under budget by $20,865. Though total General Fund
revenues for the first quarter were $1.5 million over budget, most of the variation is attributed to
timing. The main variance is the telecommunication tax, which we are now projecting to be $100,000
(2.86%) under budget for the fiscal year.
When we prepared the budget, we estimated that sales taxes would provide a 1.6% increase from last
year. Through the first three months, receipts are tracking within ½% of expectations.
Expenses
We are currently projecting expenses to be $338,620 under budget. The savings is mainly attributed to
personnel costs associated with temporary vacancies and deferral of planned radio replacements.
Revenue and Expense Projections
General Fund (without special revenue funds) *
Fiscal Year 2014/15
Variance from Original Budget
Original Amended Oct. 2014 Dec. 2014 March 2015 Audited Oct. 2014 Dec. 2014 Mar-15 Audited
Budget Budget Estimate Estimate Estimate Actual Estimate Estimate Estimate Actual
Revenue $ 43,389,560 $ 43,389,560 $ 43,368,695 -0.05%
Expense $ 43,129,600 $ 43,152,570 $ 42,790,980 -0.79%
Surplus (Deficit) $ 259,960 $ 236,990 $ 577,715 $ - $ - $ -
Equity Transfer
Assigned Bond Proceeds
Fund Balance $ 19,954,347 $ 19,931,377 $ 20,272,102 1.59%
as a % of revenue 46.0% 45.9% 46.7%
as a % of expense 46.3% 46.2% 47.4%
Fund Balance above 40%
target $ 2,598,523 $ 2,575,553 $ 2,924,624 $ - $ - $ -
* Restricted revenues drug forfeiture and foreign fire taxes and the associated expenses have been deducted.
Village of Northbrook
General Fund Revenue Projections
Fiscal Year 2015 - First Quarter
October 7, 2014
Projected
Over (Under)
Account FY 2013/14 First Quarter First Quarter FY15 FY15 Budget
Number Actual Budget Actual Budget Estimate $ %
Property Taxes 401-00/11 7,595,621 0 1,299,125 7,820,750 7,820,750 0 0.00%
Township Road and Bridge Tax 401-06/16 442,032 0 82,866 425,000 440,000 15,000 3.53%
Replacement Taxes
Corporate 405-01 417,089 83,160 134,648 346,500 346,500 0 0.00%
Township Road and Bridge 405-03 12,749 0 0 12,000 12,000 0
Total Replacement Taxes 429,838 83,160 134,648 358,500 358,500 0 0.00%
Sales Tax
Retail Sales Tax 421-00/04 12,018,089 2,770,000 2,678,504 12,300,000 12,300,000 0 0.00%
Auto Rental Tax 421-01 11,007 3,000 2,731 12,000 12,000 0 0.00%
Use Tax 421-03 580,828 145,475 137,560 582,135 582,135 0 0.00%
Total Sales Tax 12,609,924 2,918,475 2,818,795 12,894,135 12,894,135 0 0.00%
Income Tax
State Income Tax 422-00 3,162,141 1,047,100 1,009,110 3,141,200 3,141,200 0 0.00%
Total Income Taxes 3,162,141 1,047,100 1,009,110 3,141,200 3,141,200 0 0.00%
Projected
Over (Under)
Account FY 2013/14 First Quarter First Quarter FY15 FY15 Budget
Number Actual Budget Actual Budget Estimate $ %
Other Taxes
Hotel/Motel Occupancy Tax 407-01 821,687 200,000 259,015 800,000 850,000 50,000 6.25%
Utility Tax 407-03/04 1,182,658 274,890 300,846 1,100,000 1,150,000 50,000 4.55%
Telecommunications Tax 478-06 3,688,219 874,650 794,617 3,500,000 3,400,000 (100,000) -2.86%
Admissions/Entertainment Tax 407-02 110,382 27,490 22,686 110,000 110,000 0 0.00%
Total Other Taxes 5,802,946 1,377,030 1,377,164 5,510,000 5,510,000 0 0.00%
Permits
Building 452-00/06/05 1,671,654 449,820 759,010 1,800,000 1,800,000 0 0.00%
Alarm 454-03 4,820 1,250 1,210 5,000 5,000 0 0.00%
Total Permits 1,676,474 451,070 760,220 1,805,000 1,805,000 0 0.00%
Licenses
Animal 435-01 24,304 20,925 21,565 22,500 22,500 0 0.00%
Business/Liquor 435-02/04 306,690 7,500 26,364 335,000 335,000 0 0.00%
Vehicle 435-05, 473-35 599,936 546,250 557,275 575,000 565,000 (10,000) -1.74%
Total Licenses 930,930 574,675 605,204 932,500 922,500 (10,000) -1.07%
Interest Income
General Fund 426-01/02/04 50,138 12,495 3,586 50,000 50,000 0 0.00%
Property Tax 426-09/19 131 375 8 1,500 200 (1,300) -86.67%
Total Interest Income 50,269 12,870 3,594 51,500 50,200 (1,300) -2.52%
Fees:
RFPD Fees 451-00 2,498,853 0 0 2,590,640 2,590,640 0 0.00%
RED Center Administration Fees 451-01 20,000 0 0 20,000 20,000 0 0.00%
Elevator Inspections 452-01 36,650 0 2,210 52,500 52,500 0 0.00%
Franchise Fees:
Cable Television 478-01 685,533 162,435 173,724 650,000 650,000 0 0.00%
PEG Activities 478-04 1,736 0 0 0 0 0
Total Franchise Fees 687,269 162,435 173,724 650,000 650,000 0 0.00%
Projected
Over (Under)
Account FY 2013/14 First Quarter First Quarter FY15 FY15 Budget
Number Actual Budget Actual Budget Estimate $ %
Alarm Services Fees:
Police Alarms 454-00/01/02 141,127 15,495 11,350 135,000 135,000 0 0.00%
Fire Alarms 459-00/01 65,153 18,370 22,046 73,500 73,500 0 0.00%
Total Alarm Services Fees 206,280 33,865 33,396 208,500 208,500 0 0.00%
Petitioner Fees:
Plan Commission 457-00 34,991 5,000 9,013 20,000 25,000 5,000 25.00%
Total Petitioner Fees 34,991 5,000 9,013 20,000 25,000 5,000 25.00%
Total Fees 3,484,043 201,300 218,343 3,541,640 3,546,640 5,000 0.14%
Rental Income:
Commuter Station:
The Grind 461-05 7,561 1,750 2,546 7,000 7,000 0 0.00%
Total Rental Income 7,561 1,750 2,546 7,000 7,000 0 0.00%
Fines:
Ordinance Violations 458-01 73,953 14,995 13,135 60,000 60,000 0 0.00%
Traffic Court Fines 458-02 160,557 39,985 32,816 160,000 160,000 0 0.00%
Total Fines 234,510 54,980 45,951 220,000 220,000 0 0.00%
Projected
Over (Under)
Account FY 2013/14 First Quarter First Quarter FY15 FY15 Budget
Number Actual Budget Actual Budget Estimate $ %
Interfund Transfers:
Sanitary Sewer Fund 475-14 471,005 244,925 244,925 489,850 489,850 0 0.00%
Senior Housing Fund 475-15 76,920 40,000 40,000 80,000 80,000 0 0.00%
Stormwater Fund 475-16 72,800 37,860 37,858 75,715 75,715 0 0.00%
Water Production Fund 475-21 632,735 329,025 329,025 658,050 658,050 0 0.00%
Water Distribution Fund 475-21 1,080,810 562,025 562,023 1,124,045 1,124,045 0 0.00%
Parking Fund 475-22 101,765 52,920 52,918 105,835 105,835 0 0.00%
Cemetary Fund 475-20/23 1,450 755 755 1,510 1,510 0 0.00%
Total Interfund Transfers 2,437,485 1,267,510 1,267,504 2,535,005 2,535,005 0 0.00%
Charges for Services:
Overtime Reimb. - Police/Fire/Dev/PW 473-13:17 50,499 14,995 15,638 60,000 60,000 0 0.00%
Antenna Lease Fees 476-01 222,305 40,905 41,024 240,630 240,630 0 0.00%
Weed Cutting/Tree Removal Fees 477-02/05 0 50 0 200 200 0 0.00%
Sign Material Sales 477-06 665 250 0 1,000 1,000 0 0.00%
Reforestation Fees 477-07 20,325 3,750 525 15,000 15,000 0 0.00%
Toll Road Responses-Fire/EMS 477-31/32 1,000 875 450 3,500 3,500 0 0.00%
Ambulance Transportation Fee 480-02 942,539 224,910 164,699 900,000 900,000 0 0.00%
Glenbrook North Police Service 480-03 104,601 0 0 110,000 110,000 0 0.00%
Summer School Crossing Guards 480-04 6,313 1,500 6,934 6,000 6,935 935 15.58%
Total Charges for Services 1,348,247 287,235 229,270 1,336,330 1,337,265 935 0.07%
Projected
Over (Under)
Account FY 2013/14 First Quarter First Quarter FY15 FY15 Budget
Number Actual Budget Actual Budget Estimate $ %
Miscellaneous:
Surplus Equipment Sales 473-03 28,359 12,495 4,813 50,000 30,000 (20,000) -40.00%
Retail Sale Permits 473-06 6,335 2,500 520 10,000 6,500 (3,500) -35.00%
Miscellaneous Income 473-07/09/20 871,518 87,465 41,555 350,000 350,000 0 0.00%
Grants 481-15/17/18 97,924 0 0 0 0 0
Court-Ordered DUI Reimbursements 473-08 0 0 0 0 0 0
Raffle/Facility Use Fees 473-10/18 1,405 125 180 500 500 0 0.00%
Frontage Deposit Fees 473-11 1,100 125 0 500 500 0 0.00%
Vending Machine Sales 473-19 0 0 0 0 0 0
State Route Maintenance 475-04 17,999 5,000 0 20,000 15,000 (5,000) -25.00%
Traffic Signal/Street Light Damage 477-03/04 2,426 1,250 0 5,000 3,000 (2,000) -40.00%
Impound Fees 477-08 340 250 150 1,000 1,000 0 0.00%
Miscellaneous Reimbursements 477-09/10 7,709 1,250 563 5,000 5,000 0 0.00%
Annexation Fees 480-19 33,460 24,240 18,858 97,000 97,000 0 0.00%
E-911 Surcharge Fees 482-05/07 0 0
E-911 Interest Income 482-04 0 0 0 0
Bond Proceeds 406-02 1,210,149 0 0 2,272,000 2,272,000 0 0.00%
Total Miscellaneous 2,278,724 134,700 66,639 2,811,000 2,780,500 (30,500) -1.09%
TOTAL GENERAL CORPORATE FUND 42,490,745 8,411,855 9,920,979 43,389,560 43,368,695 (20,865) -0.05%
Village of Northbrook
General Corporate Fund
Expenditure Summary By Department (Without Special Revenue Funds)
FY 2014/15 - First Quarter
October 7, 2014
Projected
First Quarter First Quarter Over (Under)
YTD YTD FY 15 FY 15 Budget
Budget Actual Budget Estimate $ % Reason
LEGISLATIVE
Personal Services 10,345 10,300 41,400 41,400 - 0.00%
Fringe Benefits 775 788 3,100 3,100 - 0.00%
Contractual Services 228,850 163,183 282,600 282,600 - 0.00%
Total 239,970 174,271 327,100 327,100 - 0.00%
ADMINISTRATIVE
Personal Services 264,250 253,112 1,082,340 1,082,340 - 0.00%
Fringe Benefits 114,925 112,370 341,195 341,195 - 0.00%
Contractual Services 69,515 82,774 237,320 237,320 - 0.00%
Commodities 875 113 3,500 3,500 - 0.00%
Capital Outlay - - - - -
Total 449,565 448,369 1,664,355 1,664,355 - 0.00%
Total w/o Capital 449,565 448,369 1,664,355 1,664,355 - 0.00%
LEGAL
Contractual Services 166,285 93,609 665,400 665,400 - 0.00%
Total 166,285 93,609 665,400 665,400 - 0.00%
FINANCE
Personal Services 182,600 172,193 699,470 677,570 (21,900) -3.13% Temporary vacancies.
Fringe Benefits 95,240 92,370 262,340 260,665 (1,675) -0.64% See comment above
Contractual Services 79,500 83,387 214,840 214,840 - 0.00%
Commodities 5,525 3,573 22,100 22,100 - 0.00%
Capital Outlay 625 - 2,500 2,500 - 0.00%
Total 363,490 351,523 1,201,250 1,177,675 (23,575) -1.96%
Total w/o Capital 362,865 351,523 1,198,750 1,175,175 (23,575) -1.97%
Projected
First Quarter First Quarter Over (Under)
YTD YTD FY 15 FY 15 Budget
Budget Actual Budget Estimate $ % Reason
INFORMATION SERVICES
Personal Services 87,330 71,740 349,460 330,560 (18,900) -5.41% New position budgeted for full year but not
filled in first qtr.
Fringe Benefits 48,385 44,628 134,270 129,270 (5,000) -3.72%
Contractual Services 133,100 38,747 697,205 697,205 - 0.00%
Commodities 125 382 500 800 300 60.00%
Capital Outlay - 2,020 592,000 592,000 - 0.00%
Total 268,940 157,517 1,773,435 1,749,835 (23,600) -1.33%
Total w/o Capital 268,940 155,497 1,181,435 1,157,835 (23,600) -2.00%
POLICE
Personal Services 2,358,015 2,327,874 9,854,570 9,807,500 (47,070) -0.48% Savings due to attrition and timing of
replacements.
Fringe Benefits 841,670 829,693 1,982,240 1,980,415 (1,825) -0.09%
Contractual Services 543,470 496,574 1,493,235 1,485,565 (7,670) -0.51%
Commodities 129,635 129,870 518,750 512,350 (6,400) -1.23%
Capital Outlay 142,605 43,488 506,765 341,880 (164,885) -32.54% Deferred replacement of portable radios.
Total 4,015,395 3,827,499 14,355,560 14,127,710 (227,850) -1.59%
Total w/o Capital 3,872,790 3,784,011 13,848,795 13,785,830 (62,965) -0.45%
FIRE
Personal Services 1,948,815 1,984,916 8,102,455 8,028,755 (73,700) -0.91% Savings due to attrition and timing of
replacements.
Fringe Benefits 705,580 701,411 1,519,155 1,502,430 (16,725) -1.10%
Contractual Services 455,000 409,310 1,317,525 1,327,205 9,680 0.73% Unexpected engine repairs
Commodities 116,685 92,457 441,800 429,620 (12,180) -2.76%
Capital Outlay - - 985,000 985,000 - 0.00%
Total 3,226,080 3,188,094 12,365,935 12,273,009 (92,925) -0.75%
Total w/o Capital 3,226,080 3,188,094 11,380,935 11,288,009 (92,925) -0.82%
Projected
First Quarter First Quarter Over (Under)
YTD YTD FY 15 FY 15 Budget
Budget Actual Budget Estimate $ % Reason
PUBLIC WORKS
Budgeted Project Manager position for full
Personal Services 845,925 811,835 3,468,740 3,440,240 (28,500) -0.82% year, currently performing recruitment.
Fringe Benefits 437,460 432,056 1,278,215 1,271,665 (6,550) -0.51%
Contractual Services 590,980 313,662 1,938,555 1,928,555 (10,000) -0.52% Savings from Landscape Maintenance
contract.
Commodities 137,335 106,679 849,560 964,560 115,000 13.54% Higher than anticipated salt prices.
Capital Outlay 288,005 14,701 1,053,910 1,048,290 (5,620) -0.53% Public Works and Village Hall improvements
are scheduled to be completed in Q3/4, Police
Department improvements in Q2/3. Fire
Station improvements are complete, but were
not paid until Q2. Three of the five
vehicles/equipment have been ordered, with
the remaining expected to occur in Q2/3.
Total 2,299,705 1,678,933 8,588,980 8,653,310 64,330 0.75%
Total w/o Capital 2,011,700 1,664,232 7,535,070 7,605,020 69,950 0.93%
DEVELOPMENT & PLANNING
Personal Services 273,635 272,809 1,100,355 1,100,355 - 0.00%
Fringe Benefits 196,650 192,009 512,060 512,060 - 0.00%
Contractual Services 193,720 137,244 570,320 535,320 (35,000) -6.14% Decision not to pursue downtown marketing
& parking study will be partially offset by the
need for additional contractual assistance on
inspections and property maintenance.
Commodities 900 8 3,600 3,600 - 0.00%
Capital Outlay 310 - 1,250 1,250 - 0.00%
Total 665,215 602,070 2,187,585 2,152,585 (35,000) -1.60%
Total w/o Capital 664,905 602,070 2,186,335 2,151,335 (35,000) -1.60%
Projected
First Quarter First Quarter Over (Under)
YTD YTD FY 15 FY 15 Budget
Budget Actual Budget Estimate $ % Reason
ALL DEPARTMENTS
Total 11,694,645 10,521,885 43,129,600 41,041,144 (315,020) -0.73%
Total w/o Capital 11,263,100 10,461,676 39,988,175 37,669,724 (144,515) -0.36%
TOTAL BY CLASS
Personal Services 5,970,915 5,904,779 24,698,790 24,508,720 (190,070) -0.77%
Fringe Benefits 2,440,685 2,405,325 6,032,575 6,000,800 (31,775) -0.53%
Contractual Services 2,460,420 1,818,490 7,417,000 7,374,010 (42,990) -0.58%
Commodities 391,080 333,082 1,839,810 1,936,530 96,720 5.26%
Capital Outlay 431,545 60,209 3,141,425 2,970,920 (170,505) -5.43%
11,694,645 10,521,885 43,129,600 42,790,980 (338,620) -0.79%
PROJECTED REVENUES 43,389,560 43,368,695 (20,865) -0.05%
SURPLUS / (DEFICIT) 259,960 577,715
EQUITY TRANSFER OUT
PROJECTED FUND BALANCE 19,954,347 20,272,102
Fund Balance as a % of Revenue 46.0% 46.7%
Fund Balance as a % of Expense 46.3% 47.4%
Fund Balance above 40% policy 2,598,523 2,924,624
Village of Northbrook
Comparative Sales Tax Collections
Fiscal Year 2014/15
GAAP Basis
Liability Collection Disbursement Budgeted
Month Month Month 2010-11 2011-12 2012-13 2013-14 2014-15 Amount
Feb Mar May 885,373 993,014 1,012,201 928,185.56 953,050
Mar Apr Jun 1,142,555 1,179,767 1,179,072 1,129,720 1,160,000
Apr May July 1,013,811 1,082,343 1,122,109 1,097,293 1,113,585 1,126,700
May Jun Aug 1,078,377 1,193,929 1,204,629 1,266,803 1,232,939 1,300,750
Jun Jul Sep 1,153,113 1,258,768 1,333,790 1,251,288 1,294,922 1,284,825
Jul Aug Oct 1,038,674 1,022,824 1,059,683 1,120,681 1,150,700
Aug Sep Nov 1,040,610 1,147,063 1,189,263 1,193,600 1,225,600
Sep Oct Dec 1,118,357 1,183,982 1,304,942 1,203,212 1,235,450
Oct Nov Jan 1,055,850 1,081,807 1,178,118 1,159,309 1,190,375
Nov Dec Feb 1,145,298 1,183,531 1,307,382 1,203,020 1,235,250
Dec Jan Mar 1,545,773 1,702,654 1,707,000 1,655,408 1,699,800
Jan Feb Apr 942,125 975,448 1,019,737 976,328 1,002,500
$ 13,159,916 $ 14,005,130 $ 14,617,926 $ 14,184,847 3,641,447 14,565,000
2014/15 Budgeted Sales Tax Revenue $ 14,565,000
Percent Collected 25.00%
Current Year Projection Based Upon Recent Trends $ 14,503,343
Over (Under) Budget $ (61,657)
Percentage Over (Under) Budget (0.42)%
Comparative Overtime Report
First Quarter Second Quarter Third Quarter Fourth Quarter Total
FY 13/14 FY 14/15 FY 13/14 FY 14/15 FY 13/14 FY 14/15 FY 13/14 FY 14/15 FY 12/13 FY 14/15
General Government
Regular overtime 67.50 1,366.20 67.50 1,366.20
Total General Government 67.50 1,366.20 - - - 67.50 1,366.20
Finance Department
Vehicle licenses 1,417.18 927.07 1,417.18 927.07
Regular overtime 2,464.44 1,254.28 2,464.44 1,254.28
- -
Total Finance Department 3,881.62 2,181.35 - - - 3,881.62 2,181.35
Police Department
Roll call 32,612.58 32,708.06 32,612.58 32,708.06 Preparation and participation in
daily roll call, checking
equipment, and providing
assignments at the beginning of
each shift.
FLSA 23,694.04 23,942.32 23,694.04 23,942.32 The Fair Labor Standards Act
provides exceptions to the seven
day work period for police and fire
employees due to the nature of 24
hour shifts in fire and 12 hour
shifts for police. While this
exception allows more hours
worked than 40 per week before
overtime is required, these shifts
slightly exceed the limit so
compensation must be adjusted
accordingly.
Shift holdover 17,157.44 12,332.47 17,157.44 12,332.47 Completion of arrest or assignment
which occurs near end of a shift.
Regular/Speciality recall 42,465.30 27,360.08 42,465.30 27,360.08 Need based recall of officers with
specific certifications or training.
Includes Evidence Technicians,
Accident Investigators and Canine
Officer.
Comparative Overtime Report
First Quarter Second Quarter Third Quarter Fourth Quarter Total
FY 13/14 FY 14/15 FY 13/14 FY 14/15 FY 13/14 FY 14/15 FY 13/14 FY 14/15 FY 12/13 FY 14/15
Meetings/Training 33,691.41 30,701.32 33,691.41 30,701.32 Primarily comprised of required
training which cannot be
completed while on duty. Also
includes special team meetings as
needed.
Special Assignments 17,319.74 8,547.84 17,319.74 8,547.84
Private details (reimbursable) 7,239.88 7,113.35 7,239.88 7,113.35
Court time 22,943.28 19,997.89 22,943.28 19,997.89
Minimum manning 75,117.18 44,045.44 75,117.18 44,045.44 Hireback of officers to maintain
minimum required staffing of
shift. This occurs when an officer
is ill or injured, or called to
participate in a regional
investigation. During first quarter
of FY 12/13, the department had
two vacant positions due to
Northbrook Days (partial reimb.) 3,724.06 317.46 3,724.06 317.46 attrition.
Community relations 1,654.83 4,643.97 1,654.83 4,643.97 Includes National Night Out and
other community events.
4th of July 13,103.44 15,152.22 13,103.44 15,152.22
NIPAS/NORTAF 16,144.66 11,823.07 16,144.66 11,823.07
Total Overtime Worked 306,867.84 238,685.49 - - - 306,867.84 238,685.49
Fire Department
FLSA 8,905.00 9,176.00 8,905.00 9,176.00 The Fair Labor Standards Act
provides exceptions to the seven
day work period for police and fire
employees due to the nature of 24
hour shifts in fire and 12 hour
shifts for police. While this
exception allows more hours
worked than 40 per week before
overtime is required, these shifts
slightly exceed the limit so
compensation must be adjusted
accordingly.
Shift holdover 5,267.00 6,264.00 5,267.00 6,264.00 Completion of an emergency call
which occurs near the end of a
shift.
Comparative Overtime Report
First Quarter Second Quarter Third Quarter Fourth Quarter Total
FY 13/14 FY 14/15 FY 13/14 FY 14/15 FY 13/14 FY 14/15 FY 13/14 FY 14/15 FY 12/13 FY 14/15
Regular/recall 4,575.00 3,611.00 4,575.00 3,611.00 Emergency call-back of a Full-
time firefighter to staff reserve
apparatus and/or a station due to
an extended large scale incident,
or multiple alarms.
Meetings/Training 2,573.00 14,827.00 2,573.00 14,827.00 Meetings (includes special team
meetings as needed) and required
training which cannot be
completed while on duty (i.e. live
fire, CPR). Increase is mainly
related to timing of cyclical
training.
Special teams training 10,623.00 32,640.00 10,623.00 32,640.00 Specialized training for Dive,
Technical Rescue, and Hazmat
teams which cannot be completed
while on duty. Increase is related
to timing of MABAS drills. Most
of this overtime expense was
reimbursed.
Minimum manning 84,527.00 85,950.00 84,527.00 85,950.00 Hireback of
firefighters/paramedics to maintain
minimum required staffing of
shift. Mainly occurs when a
firefighter is ill or injured.
CERT Training (REIMBURS) - 1,693.00 - 1,693.00
Open house - - - -
Northbrook Days 816.00 5,315.00 816.00 5,315.00
4th of July 784.00 2,045.00 784.00 2,045.00
Total Overtime Worked 118,070.00 161,521.00 - - - 118,070.00 161,521.00
Public Works
Streets & sidewalks 4,660.04 3,012.22 4,660.04 3,012.22
Snow & Ice control 0.00 - - -
Parkway & street lights 410.02 442.93 410.02 442.93
Storm sewer 5,471.41 5,493.68 5,471.41 5,493.68
Sanitary sewer 4,246.41 3,457.72 4,246.41 3,457.72
Village building 1,069.41 2,447.97 1,069.41 2,447.97
Fleet 190.68 1,056.53 190.68 1,056.53
Water Production & Dist. 13,729.74 23,282.60 13,729.74 23,282.60 Increase water main replacement
projects.
Comparative Overtime Report
First Quarter Second Quarter Third Quarter Fourth Quarter Total
FY 13/14 FY 14/15 FY 13/14 FY 14/15 FY 13/14 FY 14/15 FY 13/14 FY 14/15 FY 12/13 FY 14/15
Water main breaks 2,392.94 9,617.21 2,392.94 9,617.21 The Village experienced 18 water
main breaks during the first
quarter of FY 14-15 compared to 5
breaks in FY 13/14.
JULIE Locates 3,281.19 2,950.83 3,281.19 2,950.83
Engineering plan review & insp. 2,429.57 1,292.58 2,429.57 1,292.58
Northbrook Days - - - -
Family Dinner 0.00 - - -
Earth Day - - - -
Misc. Special Events 5,537.90 1,036.00 1,036.00
4th of July 2,261.82 5,882.87 2,261.82 5,882.87
Roll call 5,305.05 5,432.75 5,305.05 5,432.75
Trees & storm damage 2,899.72 2,492.95 2,899.72 2,492.95
Total Overtime Worked 53,885.90 67,898.84 - - - 53,885.90 67,898.84
Development & Planning Services
Regular overtime 2,363.43 739.21 2,363.43 739.21
Total Dev. & Planning Services 2,363.43 739.21 - - - 2,363.43 739.21
GRAND TOTAL 485,136.29 472,392.09 - - - - - - 485,136.29 472,392.09
Village of Northbrook
Schedule of General Obligation Debt
FY14/15 FY15/16 FY16/17 FY17/18 FY18/19 FY19/20 FY20/21 FY21/22 FY22/23 FY23/24 FY35/36 FY36/37
DEBT SERVICE FUND Total
2004 Pension Obligation Bonds
Principal 195,000 205,000 220,000 230,000 240,000 250,000 265,000 275,000 290,000 300,000 15,195,000
Interest 729,360 720,000 710,160 699,600 688,560 677,040 665,040 652,320 639,120 625,200 12,559,920
Subtotal 924,360 925,000 930,160 929,600 928,560 927,040 930,040 927,320 929,120 925,200 27,754,920
2006 Corporate Purpose Bonds
Principal 432,800 432,800
Interest 17,312 17,312
Subtotal 450,112 - - - - - - - 450,112
2007 Corporate Purpose Bonds
Principal 370,000 321,300 334,800 345,600 361,800 372,600 388,800 405,000 423,900 440,100 5,729,500
Interest 242,697 230,385 217,131 202,902 188,214 172,837 157,002 140,478 123,265 105,249 1,999,989
Subtotal 612,697 551,685 551,931 548,502 550,014 545,437 545,802 545,478 547,165 545,349 7,729,489
2008 Corporate Purpose Bonds
Principal 650,000 675,000 705,000 740,000 770,000 805,000 845,000 880,000 925,000 965,000 13,525,000
Interest 577,556 551,556 522,869 492,906 461,456 428,731 394,519 358,606 321,206 281,894 5,140,761
Subtotal 1,227,556 1,226,556 1,227,869 1,232,906 1,231,456 1,233,731 1,239,519 1,238,606 1,246,206 1,246,894 18,665,761
2010 Corporate Purpose Bonds
Principal 483,720 500,155 516,590 53,020 54,455 57,320 58,755 60,185 61,620 64,485 2,341,640
Interest 76,564 62,159 47,264 31,874 30,389 28,969 26,644 26,699 24,004 22,569 474,040
Subtotal 560,284 562,314 563,854 84,894 84,844 86,289 85,399 86,884 85,624 87,054 2,815,680
2011 Corporate Purpose Bonds
Principal 120,000 120,000 125,000 125,000 130,000 130,000 135,000 140,000 140,000 145,000 2,885,000
Interest 91,760 89,360 86,960 83,210 79,460 75,560 71,660 67,610 63,410 59,210 1,065,467
Subtotal 211,760 209,360 211,960 208,210 209,460 205,560 206,660 207,610 203,410 204,210 3,950,467
2012 Corporate Purpose Bonds
Principal 296,054 797,223 796,821 1,277,174 1,962,582 1,990,397 2,528,954 2,577,182 66,720 69,500 12,651,727
Interest 143,775 138,802 130,456 140,668 139,972 113,359 104,679 59,606 8,505 7,175 1,001,622
Subtotal 439,829 936,025 927,277 1,417,842 2,102,554 2,103,756 2,633,633 2,636,788 75,225 76,675 13,653,349
2013 Corporate Purpose Bonds
Principal 38,161 39,454 40,748 42,042 43,335 44,629 45,922 47,216 48,509 76,322 80,202 1,210,149
Interest 45,386 45,386 44,241 43,058 41,835 40,574 39,274 37,935 36,558 35,141 7,044 3,609 675,979
Subtotal 45,386 83,547 83,695 83,806 83,877 83,909 83,903 83,857 83,774 83,650 83,366 83,811 1,886,128
Village of Northbrook
Schedule of General Obligation Debt
Total - CURRENT
Principal 2,547,574 2,656,839 2,737,665 2,811,542 3,560,879 3,648,652 4,266,138 4,383,289 1,954,456 2,032,594 76,322 80,202 53,970,816
Interest 1,924,410 1,837,648 1,759,081 1,694,218 1,629,886 1,537,070 1,458,818 1,343,254 1,216,068 1,136,438 7,044 3,609 22,935,090
Total Debt Service Fund 4,471,984 4,494,487 4,496,746 4,505,760 5,190,765 5,185,722 5,724,956 5,726,543 3,170,524 3,169,032 83,366 83,811 76,905,906
Paid From 1/4% HR Sales Tax 2,052,013 1,987,601 1,991,760 1,989,618 1,990,930 1,984,728 1,991,981 1,991,694 1,996,781 1,996,453 - - 30,345,717
Total Net Debt Service 2,419,971 2,506,886 2,504,986 2,516,142 3,199,835 3,200,994 3,732,975 3,734,849 1,173,743 1,172,579 83,366 83,811 46,560,189
WATER FUND
2006 Corporate Purpose Bonds
Principal 325,035 - - 325,035
Interest 13,000 - - - - - - - 13,000
Subtotal 338,035 - - - - - - - 338,035
2007 Corporate Purpose Bonds
Principal 200,000 273,700 285,200 294,400 308,200 317,400 331,200 345,000 361,100 374,900 4,765,500
Interest 206,741 196,253 184,963 172,842 160,330 147,231 133,742 119,666 136,879 154,895 2,434,289
Subtotal 406,741 469,953 470,163 467,242 468,530 464,631 464,942 464,666 497,979 529,795 7,199,789
2010 Corporate Purpose Bonds
Principal 121,280 124,845 128,410 131,980 135,545 142,680 146,245 149,815 153,380 160,515 2,468,360
Interest 80,715 77,080 73,335 69,480 65,520 61,455 57,175 53,500 48,295 43,690 775,190
Subtotal 201,995 201,925 201,745 201,460 201,065 204,135 203,420 203,315 201,675 204,205 3,243,550
2012 Corporate Purpose Bonds
Principal 211,877 525,909 532,749 562,917 574,282 584,573 80,040 78,460 3,150,807
Interest 98,010 95,112 90,295 64,768 43,034 35,295 3,523 2,012 432,049
Subtotal 309,887 621,021 623,044 627,685 617,316 619,868 83,563 80,472 3,582,856
2013 Corporate Purpose Bonds
Principal 39,830 41,180 42,530 43,880 45,230 46,580 47,931 49,281 50,631 79,660 83,710 1,263,078
Interest 47,371 47,371 46,176 44,941 43,665 42,349 40,992 39,594 38,156 36,678 7,352 3,767 705,544
Subtotal 47,371 87,201 87,356 87,471 87,545 87,579 87,572 87,525 87,437 87,309 87,012 87,477 1,968,622
Total
Principal 858,192 964,284 987,539 1,031,827 1,061,907 1,089,883 604,065 621,206 563,761 586,046 79,660 83,710 11,972,780
Interest 445,837 415,816 394,769 352,031 312,549 286,330 235,432 214,772 223,330 235,263 7,352 3,767 4,360,072
Total Water Fund 1,304,029 1,380,100 1,382,308 1,383,858 1,374,456 1,376,213 839,497 835,978 787,091 821,309 87,012 87,477 16,332,852
Village of Northbrook
Schedule of General Obligation Debt
SANITARY SEWER FUND
2013 Corporate Purpose Bonds
Principal 18,967 19,610 20,252 20,895 21,538 22,181 22,824 23,467 24,110 37,933 39,862 601,465
Interest 22,558 22,558 21,989 21,400 20,793 20,166 19,520 18,854 18,170 17,466 3,501 1,795 335,973
Subtotal 22,558 41,525 41,599 41,652 41,688 41,704 41,701 41,678 41,637 41,576 41,434 41,657 937,438
Total
Principal - 18,967 19,610 20,252 20,895 21,538 22,181 22,824 23,467 24,110 37,933 39,862 601,465
Interest 22,558 22,558 21,989 21,400 20,793 20,166 19,520 18,854 18,170 17,466 3,501 1,795 335,973
Total Sanitary Sewer Fund 22,558 41,525 41,599 41,652 41,688 41,704 41,701 41,678 41,637 41,576 41,434 41,657 937,438
STORM WATER FUND
2012 Corporate Purpose Bonds
Principal 46,620 46,620 48,840 48,840 51,060 51,060 51,060 53,280 53,280 55,500 737,040
Interest 14,740 13,810 12,875 11,900 10,920 9,900 8,880 7,860 6,795 5,725 115,080
Subtotal 61,360 60,430 61,715 60,740 61,980 60,960 59,940 61,140 60,075 61,225 852,120
2013 Corporate Purpose Bonds
Principal 30,505 31,539 32,573 33,607 34,641 35,675 36,709 37,743 38,777 61,009 64,111 967,358
Interest 36,280 36,280 35,365 34,419 33,442 32,434 31,395 30,324 29,225 28,091 5,630 2,885 540,357
Subtotal 36,280 66,785 66,904 66,992 67,049 67,075 67,070 67,033 66,968 66,868 66,639 66,996 1,507,715
Total
Principal 46,620 77,125 80,379 81,413 84,667 85,701 86,735 89,989 91,023 94,277 61,009 64,111 1,704,398
Interest 51,020 50,090 48,240 46,319 44,362 42,334 40,275 38,184 36,020 33,816 5,630 2,885 655,437
Total Storm Water Fund 97,640 127,215 128,619 127,732 129,029 128,035 127,010 128,173 127,043 128,093 66,639 66,996 2,359,835
MOTOR FUEL TAX
2013 Corporate Purpose Bonds
Principal 167,538 173,217 178,897 184,576 190,255 195,935 201,614 207,293 212,972 335,076 352,114 5,312,949
Interest 199,260 199,260 194,234 189,038 183,671 178,134 172,426 166,548 160,499 154,281 30,924 15,845 2,967,766
Sub-total 199,260 366,798 367,451 367,935 368,247 368,389 368,361 368,162 367,792 367,253 366,000 367,959 8,280,715
Total Motor Fuel Tax 199,260 366,798 367,451 367,935 368,247 368,389 368,361 368,162 367,792 367,253 366,000 367,959 8,280,715
TOTAL PRINCIPAL 3,452,386 3,884,753 3,998,410 4,123,931 4,912,924 5,036,029 5,175,054 5,318,922 2,840,000 2,949,999 590,000 619,999 73,562,408
TOTAL INTEREST 2,643,085 2,525,372 2,418,313 2,303,006 2,191,261 2,064,034 1,926,471 1,781,612 1,654,087 1,577,264 54,451 27,901 31,254,338
TOTAL PRINCIPAL
AND INTEREST 6,095,471 6,410,125 6,416,723 6,426,937 7,104,185 7,100,063 7,101,525 7,100,534 4,494,087 4,527,263 644,451 647,900 104,816,746
VILLAGE OF NORTHBROOK
Effective Interest - Actual Life
Receipts in Period
7/31/2014
Beginning Commissi
CUSIP Invest Security Purchase Call Yield Yield Beginning Beginning Unamor Premium on Total
Number Description Date Date Matur Call Unit Cost Par Val/Shares Val/Cost Discount Fees Cost Market Value
1300 - THE ILLINOIS FUNDS CASH - COMMINGLED 0.0150 10,982,601.00 10,982,601.00 0.00 10,982,601 10,982,601
CASH - E-PAY 0.0150 2,248,145.00 2,248,145.00 2,248,145 2,248,145
CASH - DISBURSEMENT 0.0150 762,743.00 762,743.00 762,743 762,743
CASH - SENIOR HOUSING 0.0150 64,519.00 64,519.00 0.00 0.00 64,519 64,519
CASH - SENIOR HOUSING SECURITY DEPOSITIS 0.0150 96,854.00 96,854.00 96,854 96,854
CASH - COMMUTER PARKING 0.0150 64,801.68 64,801.68 64,802 64,802
CASH - MFT 0.0150 1,421,186.00 1,421,186.00 1,421,186 1,421,186
CASH - E-911 0.0150 124,714.00 124,714.00 124,714 124,714
CASH - DRUG FORFEITURE 0.0150 10,130.00 10,130.00 10,130 10,130
1300 - THE ILLINOIS FUNDS Total 15,775,693.68 15,775,693.68 0.00 0.00 15,775,694 15,775,694
1300 - THE ILLINOIS FUNDS Total 15,775,693.68 15,775,693.68 0.00 0.00 15,775,694 15,775,694
2100 - IMET (IL Metropolitan Inv Fun 366006017 AR-0009 IMET 10/06/97 Open 0.5600 7,505,702.00 7,505,702.00 0.00 0.00 7,505,702 7,505,702
366006017 AR-0011 IMET 09/30/98 Open 0.5600 1,509,364.00 1,509,364.00 0.00 0.00 1,509,364 1,509,364
366006017 AR-0012 IMET 09/30/98 Open 0.5600 1,509,364.00 1,509,364.00 0.00 0.00 1,509,364 1,509,364
2100 - IMET (IL Metropolitan Inv Fun Total 10,524,430.00 10,524,430.00 0.00 0.00 10,524,430 10,524,430
2100 - IMET (IL Metropolitan Inv Fun Total 10,524,430.00 10,524,430.00 0.00 0.00 10,524,430 10,524,430
4600 - NORTHBROOK BANK & TRUST 8100009643 MAXSAFE TM PUBLIC 10/20/11 OPEN 0.2000 3,523,724.00 3,523,724.00 0.00 0.00 3,523,724 3,523,724
7500019386 PUBLIC FUNDS CHECKING 10/20/11 Open 0.0000 4,500,000.00 4,500,000.00 0.00 0.00 4,500,000 4,500,000
7500019394 SUPER PUBFUND MMDA 10/20/11 Open 0.1400 4,541,596.00 4,541,596.00 0.00 0.00 4,541,596 4,541,596
7500014368 AR-0029 MONEY MARKET 07/08/08 OPEN 0.0800 3,950,288.00 3,950,288.00 0.00 0.00 3,950,288 3,950,288
CASH - PAYROLL 0.0000 0.00 0.00 0.00 0.00 - -
CASH - SENIOR HOUSING 0.0300 1,211,893.00 1,211,893.00 0.00 0.00 1,211,893 1,211,893
CASH - ANGEL 0.0300 17,162.00 17,162.00 0.00 0.00 17,162 17,162
CASH - DISBURSEMENT 0.0000 87.00 87.00 0.00 0.00 87 87
4600 - NORTHBROOK BANK & TRUST Total 17,744,750.00 17,744,750.00 0.00 0.00 17,744,750.00 17,744,750.00
4600 - NORTHBROOK BANK & TRUST Total 17,744,750.00 17,744,750.00 0.00 0.00 17,744,750.00 17,744,750.00
5000 - FIRST BANK OF HIGHLAND PARK 53000916 AR-0028 MONEY MARKET 02/08/07 Open 0.4500 2,249,078.00 2,249,078.00 0.00 0.00 2,249,078 2,249,078
5000 -FIRST BANK OF HIGHLAND PARK Total 2,249,078.00 2,249,078.00 0.00 0.00 2,249,078.00 2,249,078.00
5000 - FIRST BANK OF HIGHLAND PARK Total 2,249,078.00 2,249,078.00 0.00 0.00 2,249,078.00 2,249,078.00
Investment Total
46,293,952 46,293,952 - - 46,293,952 46,293,952
Page 1 of 1
VILLAGE OF NORTHBROOK POLICE AND FIREFIGHTER'S PENSION FUNDS
Effective Interest - Actual Life
Receipts in Period
7/31/2014
Beginning Commissi
CUSIP Invest Security Purchase Call Yield Yield Beginning Beginning Unamor Premium on Total Market
Number Description Date Date Matur Call Unit Cost Par Val/Shares Val/Cost Discount Fees Cost Value
1300 - THE ILLINOIS FUNDS 139125103 AR-0001 Treasurs Pool 04/30/95 Open 0.0150 0.0000 1.000000 538,179.00 538,179.00 0.00 0.00 538,179 538,179
139124585 AR-0002 Treasurs Pool 04/30/95 Open 0.0150 0.0000 1.000000 1,972,080.00 1,972,080.00 0.00 0.00 1,972,080 1,972,080
1300 - THE ILLINOIS FUNDS Total 0.0150 0.0000 1.000000 2,510,259.00 2,510,259.00 0.00 0.00 2,510,259 2,510,259
1300 - THE ILLINOIS FUNDS Total 0.0150 0.0000 1.000000 2,510,259.00 2,510,259.00 0.00 0.00 2,510,259 2,510,259
City of Highland Park Municipal Bonds 04/29/05 Open 4.8000 1.000000 8,656,076.00 8,656,076.00 8,656,076.00 8,656,076.00
04/30/05 Open 4.8000 1.000000 5,437,242.00 5,437,242.00 5,437,242.00 5,437,242.00
05/01/05 Open 4.8000 1.000000 1,227,170.00 1,227,170.00 1,227,170.00 1,227,170.00
4.8000 15,320,488 15,320,488 15,320,488 15,320,488
4.8000 15,320,488 15,320,488 15,320,488 15,320,488
2400 - VANGUARD GROUP 919946557 AR-0010 VANGUARD 06/22/98 Open 0.0000 0.0000 1.000000 6,897,441.00 6,897,441.00 0.00 0.00 6,897,441 6,897,441
2400 - VANGUARD GROUP Total 0.0000 0.0000 1.000000 6,897,441.00 6,897,441.00 0.00 0.00 6,897,441.00 6,897,441.00
2400 - VANGUARD GROUP Total 0.0000 0.0000 1.000000 6,897,441.00 6,897,441.00 0.00 0.00 6,897,441.00 6,897,441.00
151020104 06-0199 CELGENE CORP 01/26/06 Open 0.0000 0.0000 33.857000 1,300.00 44,014.00 0.00 0.00 44,014 113,295
197199409 04-0073 COLUMBIA ACORN FUND CLASS Z 10/16/03 Open 0.0000 0.0000 17.868240 6,890.90 123,128.00 -225,888.50 0.00 123,128 329,592
197199409 06-0032 COLUMBIA ACORN FUND CLASS Z 06/10/05 Open 0.0000 0.0000 26.260323 204.40 5,367.61 -5,163.21 0.00 5,368 9,776
197199409 05-0111 COLUMBIA ACORN FUND CLASS Z 12/15/04 Open 0.0000 0.0000 25.560211 380.00 9,713.00 -11,360.08 0.00 9,713 18,175
197199409 06-0177 COLUMBIA ACORN FUND CLASS Z 12/14/05 Open 0.0000 0.0000 28.430087 656.89 18,675.44 -18,018.55 0.00 18,675 31,419
197199409 07-0021 COLUMBIA ACORN FUND CLASS Z 06/09/06 Open 0.0000 0.0000 23.729900 158.02 4,620.52 0.00 0.00 4,621 7,558
197199409 07-0069 COLUMBIA ACORN FUND CLASS Z 12/12/06 Open 0.0000 0.0000 29.819900 1,099.00 32,772.11 0.00 0.00 32,772 52,565
197199409 08-0007 COLUMBIA ACORN FUND CLASS Z 06/07/07 Open 0.0000 0.0000 33.250000 109.17 3,629.87 0.00 0.00 3,630 5,222
197199409 08-0133 COLUMBIA ACORN FUND CLASS Z 12/17/07 Open 0.0000 0.0000 29.780000 647.47 19,281.72 0.00 0.00 19,282 30,969
197199409 09-0066 COLUMBIA ACORN FUND CLASS Z 06/16/08 Open 0.0000 0.0000 27.599900 203.43 5,614.72 0.00 0.00 5,615 9,730
197199409 09-0170 COLUMBIA ACORN FUND CLASS Z 12/11/08 Open 0.0000 0.0000 16.720000 75.08 1,255.37 0.00 0.00 1,255 3,591
197199409 10-0108 COLUMBIA ACORN FUND CLASS Z 12/11/09 Open 0.0000 0.0000 23.580179 21.80 513.93 0.00 0.00 514 1,042
197199409 11-0028 COLUMBIA ACORN FUND CLASS Z 06/14/10 Open 0.0000 0.0000 24.209900 12.82 310.25 0.00 0.00 310 613
197199409 11-0166 COLUMBIA ACORN FUND CLASS Z 12/17/10 Open 0.0000 0.0000 29.549940 4.96 146.42 0.00 0.00 146 237
197199409 11-0167 COLUMBIA ACORN FUND CLASS Z 12/17/10 Open 0.0000 0.0000 29.549940 296.39 8,758.35 0.00 0.00 8,758 14,176
197199409 12-0022 COLUMBIA ACORN FUND CLASS Z 06/10/11 Open 0.0000 0.0000 30.399109 136.88 4,161.00 0.00 0.00 4,161 6,547
197199409 13-0038 COLUMBIA ACORN FUND CLASS Z 06/06/12 Open 0.0000 0.0000 29.089822 137.94 4,013.00 0.00 0.00 4,013 6,598
315920249 09-0014 FIDELITY ADVEMERG MARKET CL I 05/21/08 Open 0.0000 0.0000 29.660000 3,371.54 100,000.00 0.00 0.00 100,000 80,243
315920249 09-0157 FIDELITY ADVEMERG MARKET CL I 12/08/08 Open 0.0000 0.0000 10.810100 71.11 768.71 0.00 0.00 769 1,692
197199409 10-0096 FIDELITY ADVEMERG MARKET CL I 12/07/09 Open 0.0000 0.0000 20.979907 39.22 822.79 0.00 0.00 823 933
315920249 11-0005 FIDELITY ADVEMERG MARKET CL I 05/11/10 Open 0.0000 0.0000 20.809990 5,117.73 106,500.00 0.00 0.00 106,500 121,802
315920249 11-0140 FIDELITY ADVEMERG MARKET CL I 12/06/10 Open 0.0000 0.0000 24.120168 114.09 2,751.87 0.00 0.00 2,752 2,715
315920249 11-0152 FIDELITY ADVEMERG MARKET CL I 12/31/10 Open 0.0000 0.0000 24.346368 1.79 43.58 0.00 0.00 44 43
315805655 09-0241 FIDELITY ADVISORS SMALL CAP CL I 03/09/09 Open 0.0000 0.0000 14.939900 9,259.46 138,336.00 0.00 0.00 138,336 275,932
315805655 11-0163 FIDELITY ADVISORS SMALL CAP CL I 12/13/10 Open 0.0000 0.0000 26.089692 276.83 7,222.39 0.00 0.00 7,222 8,249
315805655 11-0184 FIDELITY ADVISORS SMALL CAP CL I 01/10/11 Open 0.0000 0.0000 25.850024 202.90 5,244.97 0.00 0.00 5,245 6,046
471023549 11-0116 JANUS INVT FD 10/19/10 Open 0.0000 0.0000 14.970000 10,354.04 155,000.00 155,000 240,939
471023549 11-0118 JANUS INVT FD 10/18/10 Open 0.0000 0.0000 14.899990 6,711.41 100,000.00 100,000 156,174
471023549 11-0177 JANUS INVT FD 12/24/10 Open 0.0000 0.0000 16.429691 193.80 3,184.18 3,184 4,510
543069405 02-0203 LONGLEAF PARTNERS INTL FUND 03/07/02 Open 0.0000 0.0000 12.738091 1,523.19 19,402.52 0.00 19,403 27,463
543069405 03-0085 LONGLEAF PARTNERS INTL FUND 11/13/02 Open 0.0000 0.0000 9.469882 392.46 3,716.55 -3,324.09 0.00 3,717 7,076
471023648 07-0051 LONGLEAF PARTNERS INTL FUND 11/08/06 Open 0.0000 0.0000 18.240000 147.26 2,685.94 2,686 2,655
543069405 07-0087 LONGLEAF PARTNERS INTL FUND 12/27/06 Open 0.0000 0.0000 18.944100 1.65 31.22 31 30
543069405 06-0143 LONGLEAF PARTNERS INTL FUND 11/09/05 Open 0.0000 0.0000 16.809668 75.71 1,272.66 -1,196.95 0.00 1,273 1,365
543069405 08-0078 LONGLEAF PARTNERS INTL FUND 11/09/07 Open 0.0000 0.0000 20.259900 218.78 4,432.47 4,432 3,945
543069405 08-0153 LONGLEAF PARTNERS INTL FUND 02/14/08 Open 0.0000 0.0000 17.689900 3,391.75 60,000.00 60,000 61,153
543069405 09-0147 LONGLEAF PARTNERS INTL FUND 11/07/08 Open 0.0000 0.0000 10.349700 168.67 1,745.69 1,746 3,041
543069405 09-0148 LONGLEAF PARTNERS INTL FUND 11/07/08 Open 0.0000 0.0000 10.350000 242.50 2,509.89 2,510 4,372
543069405 09-0167 LONGLEAF PARTNERS INTL FUND 12/31/08 Open 0.0000 0.0000 10.942200 13.86 151.66 152 250
543069405 09-0197 LONGLEAF PARTNERS INTL FUND 01/02/09 Open 0.0000 0.0000 10.941200 19.93 218.06 218 359
543069405 10-0052 LONGLEAF PARTNERS INTL FUND Page 1 of 7
08/05/09 Open 0.0000 0.0000 12.860000 3,888.03 50,000.00 50,000 70,101
543069405 11-0153 LONGLEAF PARTNERS INTL FUND 12/31/10 Open 0.0000 0.0000 15.378981 31.40 482.90 483 566
Beginning Commissi
CUSIP Invest Security Purchase Call Yield Yield Beginning Beginning Unamor Premium on Total Market
Number Description Date Date Matur Call Unit Cost Par Val/Shares Val/Cost Discount Fees Cost Value
543069405 11-0174 LONGLEAF PARTNERS INTL FUND 12/30/10 Open 0.0000 0.0000 15.378981 93.17 1,433.02 1,433 1,680
863137105 06-0048 STRATTON SMALL CAP VALUE FUND 08/18/05 Open 0.0000 0.0000 42.989900 1,691.39 72,713.00 72,713 125,400
863137105 06-0175 STRATTON SMALL CAP VALUE FUND 12/14/05 Open 0.0000 0.0000 43.999900 89.55 3,940.37 3,940 6,640
863137105 07-0019 STRATTON SMALL CAP VALUE FUND 06/27/06 Open 0.0000 0.0000 45.319900 21.55 976.60 977 1,598
863137105 08-0009 STRATTON SMALL CAP VALUE FUND 06/29/07 Open 0.0000 0.0000 51.929900 39.76 2,064.84 2,065 2,948
863137105 08-0015 STRATTON SMALL CAP VALUE FUND 07/09/07 Open 0.0000 0.0000 52.909900 1,890.00 100,000.00 100,000 140,125
863137105 08-0045 STRATTON SMALL CAP VALUE FUND 07/09/07 Open 0.0000 0.0000 52.910000 3,024.00 160,000.00 160,000 224,200
863137105 08-0201 STRATTON SMALL CAP VALUE FUND 03/17/08 Open 0.0000 0.0000 48.060300 29.21 1,403.89 1,404 2,166
863137105 08-0127 STRATTON SMALL CAP VALUE FUND 12/10/07 Open 0.0000 0.0000 48.970500 39.86 1,951.72 1,952 2,955
863137105 08-0129 STRATTON SMALL CAP VALUE FUND 12/11/07 Open 0.0000 0.0000 48.059900 103.60 4,979.06 4,979 7,681
863137105 09-0221 STRATTON SMALL CAP VALUE FUND 02/18/09 Open 0.0000 0.0000 29.729900 1,042.72 31,000.00 31,000 77,307
3000 - CHARLES SCHWAB Total 0.0000 0.0000 14.768316 66,229 1,432,962 (264,951) - 1,432,964 2,315,459
3000 - CHARLES SCHWAB Total 0.0000 0.0000 14.768316 66,229 1,432,962 (264,951) - 1,432,964 2,315,459
3100 - WILLIAM BLAIR
219023AE8 14-0266 CORN PRODUCTS 3.20 11/1/15 03/20/14 Open 0.9002 0.9002 1.036760 200,000.00 207,352.00 -7,352.00 0.00 207,352 205,758
219023AE8 14-0267 CORN PRODUCTS 3.20 11/1/15 03/20/14 Open 0.9002 0.9002 1.036760 385,000.00 399,153.00 -14,153.00 0.00 399,153 396,084
35671DAV7 15-0024 FREEPORT MCMORAN C G 1.40 2/13/15 06/27/14 Open 0.6005 0.6005 1.005000 500,000.00 502,500.00 -2,500.00 502,500 501,880
278865AJ9 15-0034 ECOLAB INC 2.375 12/8/14 07/31/14 Open 0.3787 0.3787 1.007028 1,000,000.00 1,007,028.00 -7,028.00 3,496.00 1,010,524 1,006,740
3100 - WILLIAM BLAIR Total 0.580600 0.5806 1.014884 2,085,000 2,116,033 (31,033) 3,496 2,119,529 2,110,462
3100 - WILLIAM BLAIR Total 0.900200 0.9002 1.036760 2,085,000 2,116,033 (31,033) 3,496 2,119,529 2,110,462
3600 - MISCHLER FINANCIAL GROUP INC 3138LTJQ2 13-0031 FNMA POOL 3.00 5/1/42 06/13/12 Open 2.8886 2.8886 1.022187 199,597.00 204,025.00 -4,429.00 0.00 204,025 159,036
3138LTJQ2 13-0040 FNMA POOL 3.00 5/1/42 06/13/12 Open 2.8860 2.8860 1.022187 498,992.00 510,064.00 -11,072.00 0.00 510,064 397,590
912828TE0 13.0099 U.S. TIPS 0.125 07/15/22 09/24/12 Open -0.7053 -0.7053 1.084469 150,000.00 162,670.34 -12,670.34 0.00 162,670 155,462
912828TE0 13.0101 U.S. TIPS 0.125 07/15/22 09/24/12 Open -0.7053 -0.7053 1.084469 500,000.00 542,234.45 -42,234.45 0.00 542,234 518,208
912828TE0 13-0194 U.S. TIPS 0.125 07/15/22 01/08/13 Open -0.6929 -0.6929 1.080625 150,721.00 162,873.00 -12,151.00 0.00 162,873 155,462
912828TE0 13.0198 U.S. TIPS 0.125 07/15/22 01/08/13 Open -0.7434 -0.7434 1.085823 500,000.00 542,911.00 -42,911.00 0.00 542,911 518,208
565849AK2 13-0230 MARATHON OIL CORP 2.80 11/1/22 02/13/13 08/01/22 3.0996 3.1068 0.975000 200,000.00 195,000.00 5,000.00 0.00 195,000 193,238
565849AK2 13-0232 MARATHON OIL CORP 2.80 11/1/22 02/13/13 08/01/22 3.0990 3.1068 0.975000 300,000.00 292,500.00 7,500.00 0.00 292,500 289,857
452152HQ7 13-0260 MUNICIPAL BOND 4.511 3/1/15 04/30/13 Open 1.2503 1.2503 1.058990 350,000.00 370,646.00 -20,646.00 0.00 370,646 357,819
452152HQ7 13-0261 MUNICIPAL BOND 4.511 3/1/15 04/30/13 Open 1.2503 1.2503 1.058990 500,000.00 529,495.00 -29,495.00 0.00 529,495 511,211
3600 - MISCHLER FINANCIAL GROUP, INC. Total 2.0903 2.0903 1.048388 3,349,310.00 3,512,418.79 -163,108.79 0.00 3,512,418.00 3,256,091.00
3600 - MISCHLER FINANCIAL GROUP, INC. Total 2.0903 2.0903 1.048388 3,349,310.00 3,512,418.79 -163,108.79 0.00 3,512,418.00 3,256,091.00
4200 - ARBOR RESEARCH & TRADING
36212UVW8 08-0004 GNMA #544329 5.00 1/15/22 12/23/04 Open 5.1363 5.1363 0.991250 251,850.00 249,647.00 2,203.00 0.00 249,647 250,425
4200 - ARBOR RESEARCH & TRADING, INC. Total 4.6473 4.6473 1.011363 251,850.00 249,647.00 2,203.00 0.00 249,647.00 250,425.00
4200 - ARBOR RESEARCH & TRADING, INC. Total 4.6473 4.6473 1.011363 251,850.00 249,647.00 2,203.00 0.00 249,647.00 250,425.00
4600 - NORTHBROOK BANK & TRUST 7500014724 AR-0023 Cash 05/01/99 Open 0.0500 0.0000 1.000000 15,347.00 15,347.00 0.00 0.00 15,347 15,347
7500014732 AR-0024 Cash 05/01/99 Open 0.0500 0.0000 1.000000 23,785.00 23,785.00 0.00 0.00 23,785 23,785
4600 - NORTHBROOK BANK & TRUST Total 0.0500 0.9098 1.000000 39,132.00 39,132.00 0.00 0.00 39,132.00 39,132
4600 - NORTHBROOK BANK & TRUST Total 0.0500 0.9098 1.000000 39,132.00 39,132.00 0.00 0.00 39,132.00 39,132
4900 - PERSHING
452152HR5 11-0218 ILLINOIS ST 4.961 3/1/16 04/19/11 Open 4.5983 4.5983 1.015600 500,000.00 507,800.00 -7,800.00 0.00 507,800 530,055
452151LC5 12-0001 IL ST PENSION 4.05 6/1/15 05/06/11 Open 3.5503 3.5503 1.018760 450,000.00 458,442.00 -8,442.00 0.00 458,442 461,952
577778BC6 12-0023 MACYS RETAIL HLD 8.125 8/15/35 06/03/11 08/15/15 7.1603 5.1741 1.110000 50,000.00 55,500.00 -5,500.00 0.00 55,500 53,810
577778BC6 12-0030 MACYS RETAIL HLD 8.125 8/15/35 06/03/11 08/15/15 7.1630 5.1741 1.110000 100,000.00 111,000.00 -11,000.00 0.00 111,000 107,620
36202FVF0 12-0081 GNMA #005114 4.00 7/20/41 08/18/11 Open 3.4812 3.4812 1.065517 658,506.00 701,649.00 -43,143.00 0.00 701,649 579,275
61747YCE3 12-0205 MORGAN STANLEY 6.00 4/28/15 02/28/12 Open 4.0121 4.0121 1.058500 250,000.00 264,625.00 -14,625.00 0.00 264,625 259,430
61747YCE3 12-0208 MORGAN STANLEY 6.00 4/28/15 02/28/12 Open 4.0121 4.0121 1.058500 500,000.00 529,250.00 -29,250.00 0.00 529,250 518,907
61747YCK9 12-0238 MORGAN STANLEY 4.20 11/20/14 04/03/12 Open 3.6098 3.6098 1.014650 450,000.00 456,592.00 -6,592.00 0.00 456,592 454,914
345397VQ3 13-0042 FORD MOTOR CREDIT CO 5.625 9/15/15 07/17/12 Open 2.6060 2.6060 1.091000 150,000.00 163,650.00 -13,650.00 0.00 163,650 157,854
345397VQ3 13-0064 FORD MOTOR CREDIT CO 5.625 9/15/15 07/17/12 Open 2.6060 2.6060 1.091000 400,000.00 436,400.00 -36,400.00 0.00 436,400 420,944
237194AJ4 13-0256 DARDEN RESTAURANTS INC 4.50 10/15/21 04/19/13 Open 3.6509 3.6509 1.061500 200,000.00 212,300.00 -12,300.00 0.00 212,300 211,232
237194AJ4 13-0257 DARDEN RESTAURANTS INC 4.50 10/15/21 04/19/13 Open 3.6509 3.6509 1.061500 300,000.00 318,450.00 -18,450.00 0.00 318,450 316,848
345397VL4 13-0262 FORD MOTOR CREDIT CO 8.70 10/1/14 04/30/13 Open 1.1002 1.1002 1.106730 200,000.00 221,346.00 -21,346.00 0.00 221,346 202,582
345397VL4 13-0263 FORD MOTOR CREDIT CO 8.70 10/1/14 04/30/13 Open 1.1002 1.1002 1.106730 300,000.00 332,019.00 -32,019.00 0.00 332,019 303,873
260543CH4 14-0037 DOW CHEMICAL CORP 3.00 11/15/22 05/30/13 08/15/22 3.1043 3.1065 0.991500 200,000.00 198,300.00 1,700.00 0.00 198,300 195,452
260543CH4 14-0046 DOW CHEMICAL CORP 3.00 11/15/22 05/30/13 08/15/22 3.1043 3.1065 0.991500 300,000.00 297,450.00 2,550.00 0.00 297,450 293,178
87972VAL2 14-0113 TELECOM ITALIA CAP 4.95 9/30/14 10/01/13
Page 2 of 7 Open 1.6654 1.6654 1.032350 500,000.00 516,175.00 -16,175.00 0.00 516,175 502,000
87972VAL2 14-0114 TELECOM ITALIA CAP 4.95 9/30/14 10/01/13 Open 1.6654 1.6654 1.032350 500,000.00 516,175.00 -16,175.00 0.00 516,175 502,000
4521518V8 14-0115 IL STATE TAXABLE GO BOND 4.421 1/1/15 10/09/13 Open 1.5501 1.5501 1.034800 500,000.00 517,380.00 150.00 0.00 249,850 507,935
Beginning Commissi
CUSIP Invest Security Purchase Call Yield Yield Beginning Beginning Unamor Premium on Total Market
Number Description Date Date Matur Call Unit Cost Par Val/Shares Val/Cost Discount Fees Cost Value
4521518V8 14-0116 IL STATE TAXABLE GO BOND 4.421 1/1/15 10/09/13 Open 1.5501 1.5501 1.034800 600,000.00 620,856.00 -20,856.00 0.00 620,856 609,735
527288BD5 14-0150 LEUCADIA NATIONAL CORP 8.125 9/15/15 11/25/13 Open 1.5020 1.5020 1.117500 300,000.00 335,250.00 -35,250.00 0.00 335,250 321,750
527288BD5 14-0157 LEUCADIA NATIONAL CORP 8.125 9/15/15 11/25/13 Open 1.5022 1.5022 1.117500 300,000.00 335,250.00 -35,250.00 0.00 335,250 321,750
380956AB8 14-0206 GOLDCORP INC NEW CV 2.00 8/1/14 01/10/14 Open 1.0988 1.0988 1.005000 150,000.00 150,750.00 -750.00 0.00 150,750 150,000
59018YUW9 14-0207 MERRILL LYNCH & CO 5.00 1/15/15 01/10/14 Open 0.8092 0.8092 1.042230 250,000.00 260,558.00 -10,557.00 0.00 260,557 254,933
073730AF0 14-0208 BEAM INC 1.70 6/15/18 01/22/14 Open 2.1611 2.1611 0.980750 350,000.00 343,262.00 6,737.00 0.00 343,262 343,413
380956AB8 14-0222 GOLDCORP INC NEW CV 2.00 8/1/14 01/10/14 Open 1.0988 1.0988 1.005000 750,000.00 753,750.00 -3,750.00 0.00 753,750 750,000
59018YUW9 14-0223 MERRILL LYNCH CO INC 5.00 1/15/15 01/10/14 Open 0.8092 0.8092 1.042230 250,000.00 260,557.00 -10,557.00 0.00 260,557 254,933
073730AF0 14-0225 BEAM INC 1.70 6/15/18 01/22/14 Open 2.1611 2.1611 0.980750 450,000.00 441,337.00 8,662.00 0.00 441,337 441,531
4521518V8 14-0252 IL STATE TAXABLE GO BOND 4.421 1/1/15 02/11/14 Open 0.5503 0.5503 1.034270 500,000.00 517,135.00 -17,135.00 0.00 517,135 507,935
4521518V8 14-0253 IL STATE TAXABLE GO BOND 4.421 1/1/15 02/11/14 Open 0.5503 0.5503 1.034270 850,000.00 879,130.00 -29,130.00 0.00 879,130 863,297
452152DH1 14-0254 ILLINOIS ST BUILD 4.70 3/1/16 02/11/14 Open 1.1800 1.1800 1.071270 305,000.00 326,737.00 -21,737.00 0.00 326,737 321,101
91911TAF0 14-0255 VALE OVERSEAS LTD 6.25 1/11/16 02/25/14 Open 1.3200 1.3200 1.091120 250,000.00 272,780.00 -22,780.00 0.00 272,780 267,930
345397VH3 14-0263 FORD MOTOR CREDIT 12.00 5/15/15 03/18/14 Open 0.8097 0.8097 1.128730 550,000.00 620,801.00 -70,801.00 0.00 620,801 598,962
345397VH3 14-0264 FORD MOTOR CREDIT 12.00 5/15/15 03/18/14 Open 0.8097 0.8097 1.128730 850,000.00 959,420.00 -109,420.00 0.00 959,420 925,710
887389AG9 14-0265 TIMKIN CO 6.00 9/15/14 03/19/14 Open 0.5243 0.5243 1.026700 500,000.00 513,350.00 -13,350.00 0.00 513,350 502,815
61746BDB9 14-0268 MORGAN STANLEY MTN 5.75 10/18/16 03/21/14 Open 1.2637 1.2637 1.113300 400,000.00 445,320.00 -45,320.00 0.00 445,320 438,904
61746BDB9 14-0269 MORGAN STANLEY MTN 5.75 10/18/16 03/21/14 Open 1.2637 1.2637 1.113300 300,000.00 333,950.00 -33,990.00 0.00 333,950 329,178
46625HAX8 14-0270 JP MORGAN CHASE 5.25 5/1/15 03/21/14 Open 0.7597 0.7597 1.049580 300,000.00 314,874.00 -14,874.00 0.00 314,874 309,948
46625HAX8 14-0271 JP MORGAN CHASE 5.25 5/1/15 03/21/14 Open 0.7597 0.7597 1.049580 900,000.00 944,622.00 -44,622.00 0.00 944,622 929,844
02364WAH8 14-0278 AMERICA MOVIL SAB 5.75 1/15/15 04/02/14 Open 0.6011 0.6011 1.040310 300,000.00 312,093.00 -12,093.00 0.00 312,093 306,447
527288BD5 15-0014 LEUCADIA NATIONAL CORP 8.125 9/15/15 05/19/14 Open 1.3103 1.3103 1.089010 100,000.00 108,901.00 -8,901.00 0.00 108,901 107,250
345397VL4 15-0016 FORD MOTOR CREDIT CO 8.70 10/1/14 05/19/14 Open 0.6788 0.6788 1.029309 100,000.00 102,931.00 -2,931.00 0.00 102,931 101,291
452152HQ7 15-0017 ILLINOIS ST 4.511 3/1/15 05/20/14 Open 0.7997 0.7997 1.028810 400,000.00 411,524.00 -11,524.00 0.00 411,524 408,895
61747YCE3 15-0018 MORGAN STANLEY 6.00 4/28/15 05/20/14 Open 0.6903 0.6903 1.049600 150,000.00 157,440.00 -7,440.00 0.00 157,440 155,611
451102BB2 15-0020 ICAHN ENTERPRISES 4.875 3/15/19 05/23/14 Open 4.2016 4.2016 1.029000 200,000.00 205,800.00 -5,800.00 0.00 205,800 201,000
451102BB2 15-0021 ICAHN ENTERPRISES 4.875 3/15/19 05/23/14 Open 4.2016 4.2016 1.029000 300,000.00 308,700.00 -8,700.00 0.00 308,700 301,500
4521518V8 15-0023 IL STATE TAXABLE GO BOND 4.421 1/1/15 06/23/14 Open 0.4573 0.4573 1.020650 500,000.00 510,325.00 -10,325.00 0.00 510,325 507,935
4521518V8 15-0031 IL STATE TAXABLE GO BOND 4.421 1/1/15 06/23/14 Open 0.4573 0.4573 1.020650 500,000.00 510,325.00 -10,325.00 0.00 510,325 507,915
452152CM1 15-0033 ILLINOIS ST REF 5.00 1/1/15 07/31/14 Open 0.4018 0.4018 1.019120 500,000.00 509,560.00 -9,560.00 2,083.00 511,643 509,520
278865AJ9 15-0082 ECOLAB INC 2.375 12/8/14 07/31/14 Open 0.3787 0.3787 1.007028 350,000.00 352,460.00 -2,460.00 1,224.00 353,684 352,359
4900 -PERSHING Total 2.9027 2.3387 1.036888 19,013,506.00 19,934,251.00 -903,256.00 0.00 19,670,027.00 19,483,253.00
4900 - PERSHING Total 2.9027 2.3387 1.036888 19,013,506.00 19,934,251.00 -903,256.00 0.00 19,670,027.00 19,483,253.00
00507K103 13-0180 ACTAVIS INC 10/11/12 OPEN 0.0000 0.0000 87.430600 2,700.00 236,063.00 0.00 0.00 236,063.00 578,502
00507K103 13-0186 ACTAVIS INC 11/20/12 OPEN 0.0000 0.0000 82.591800 1,700.00 140,406.00 0.00 0.00 140,406.00 364,242
00507V109 14-0077 ACTIVISION BLIZZARD INC 07/25/13 OPEN 0.0000 0.0000 15.067000 11,000.00 165,737.00 0.00 0.00 165,737.00 246,180
013817101 14-0284 ALCOA INC 04/21/14 OPEN 0.0000 0.0000 13.018900 25,300.00 329,378.00 0.00 0.00 329,378.00 414,667
01877E503 12-0245 ALLIANCEBERNSTEIN SC GR ADV 04/30/12 OPEN 0.0000 0.0000 41.769984 5,266.94 220,000.00 0.00 0.00 220,000.00 270,247
01877E503 13-0065 ALLIANCEBERNSTEIN SC GR ADV 08/01/12 OPEN 0.0000 0.0000 39.300004 3,816.79 150,000.00 0.00 0.00 150,000.00 195,840
01881G103 14-0122 ALLIANCEBERNSTEIN HLDG LP 10/10/13 OPEN 0.0000 0.0000 19.899300 15,000.00 298,489.00 0.00 0.00 298,489.00 392,100
01881G103 14-0130 ALLIANCEBERNSTEIN HLDG LP 11/14/13 OPEN 0.0000 0.0000 21.763000 8,500.00 184,988.00 0.00 0.00 184,988.00 222,190
025083338 08-0157 AMERICAN CENTURY SMALL CAP GROWTH 02/14/08 OPEN 0.0000 0.0000 7.950000 15,723.70 125,000.00 0.00 0.00 125,000.00 188,999
025537101 13-0043 AMERICAN ELECTRIC POWER CO INC 07/06/12 OPEN 0.0000 0.0000 40.229500 2,000.00 80,459.00 0.00 0.00 80,459.00 103,980
025537101 13-0078 AMERICAN ELECTRIC POWER CO INC 08/02/12 OPEN 0.0000 0.0000 42.629200 1,200.00 51,155.00 0.00 0.00 51,155.00 62,388
29875E100 10-0018 AMERICAN EUROPACIFIC GROWTH F2 05/14/09 OPEN 0.0000 0.0000 29.479900 3,222.52 95,000.00 0.00 0.00 95,000.00 160,224
29875E100 10-0050 AMERICAN EUROPACIFIC GROWTH F2 08/10/09 OPEN 0.0000 0.0000 35.060000 1,711.35 60,000.00 0.00 0.00 60,000.00 85,088
29875E100 10-0101 AMERICAN EUROPACIFIC GROWTH F2 12/28/09 OPEN 0.0000 0.0000 38.390040 93.54 3,590.89 0.00 0.00 3,591.00 4,651
29875E100 10-0177 AMERICAN EUROPACIFIC GROWTH F2 04/30/10 OPEN 0.0000 0.0000 38.309900 1,566.17 60,000.00 0.00 0.00 60,000.00 77,870
29875E100 11-0149 AMERICAN EUROPACIFIC GROWTH F2 12/29/10 OPEN 0.0000 0.0000 40.928106 109.05 4,463.21 0.00 0.00 4,463.00 5,422
029683109 07-0107 AMERICAN SOFTWARE INC CL A 02/23/07 OPEN 0.0000 0.0000 7.180600 1,200.00 8,816.76 0.00 0.00 8,817.00 11,172
029683109 07-0108 AMERICAN SOFTWARE INC CL A 02/23/07 OPEN 0.0000 0.0000 7.377300 200.00 1,475.46 0.00 0.00 1,475.00 1,862
029683109 07-0109 AMERICAN SOFTWARE INC CL A 02/23/07 OPEN 0.0000 0.0000 7.387300 1,000.00 7,387.30 0.00 0.00 7,387.00 9,310
029683109 07-0110 AMERICAN SOFTWARE INC CL A 02/23/07 OPEN 0.0000 0.0000 7.397200 1,893.00 14,002.91 0.00 0.00 14,003.00 17,624
029683109 07-0171 AMERICAN SOFTWARE INC CL A 02/23/07 OPEN 0.0000 0.0000 7.484000 400.00 2,993.61 0.00 0.00 2,994.00 3,724
029683109 07-0172 AMERICAN SOFTWARE INC CL A 02/23/07 OPEN 0.0000 0.0000 7.514000 500.00 3,757.00 0.00 0.00 3,757.00 4,655
029683109 07-0173 AMERICAN SOFTWARE INC CL A 02/23/07 OPEN 0.0000 0.0000 7.524000 600.00 4,514.41 0.00 0.00 4,514.00 5,586
029683109 07-0174 AMERICAN SOFTWARE INC CL A 02/23/07
Page 3 of 7 OPEN 0.0000 0.0000 7.554000 100.00 755.40 0.00 0.00 755.00 931
029683109 07-0175 AMERICAN SOFTWARE INC CL A 02/23/07 OPEN 0.0000 0.0000 7.574000 500.00 3,787.00 0.00 0.00 3,787.00 4,655
029683109 07-0176 AMERICAN SOFTWARE INC CL A 02/23/07 OPEN 0.0000 0.0000 7.564000 100.00 756.40 0.00 0.00 756.00 931
Beginning Commissi
CUSIP Invest Security Purchase Call Yield Yield Beginning Beginning Unamor Premium on Total Market
Number Description Date Date Matur Call Unit Cost Par Val/Shares Val/Cost Discount Fees Cost Value
029683109 07-0178 AMERICAN SOFTWARE INC CL A 02/23/07 OPEN 0.0000 0.0000 7.494000 500.00 3,747.01 0.00 0.00 3,747.00 4,655
029683109 07-0180 AMERICAN SOFTWARE INC CL A 02/23/07 OPEN 0.0000 0.0000 7.584000 5,830.00 44,214.85 0.00 0.00 44,215.00 54,277
029683109 09-0020 AMERICAN SOFTWARE INC CL A 05/27/08 OPEN 0.0000 0.0000 6.198400 2,200.00 13,636.60 0.00 0.00 13,637.00 20,482
029899101 13-0044 AMERICAN STATES WATER CO 07/06/12 OPEN 0.0000 0.0000 39.663000 3,200.00 63,461.00 0.00 0.00 63,461.00 97,760
029899101 13-0079 AMERICAN STATES WATER CO 08/02/12 OPEN 0.0000 0.0000 41.441900 1,300.00 33,154.00 0.00 0.00 33,154.00 39,715
03073E105 15-0042 AMERISOURCEBERGEN CORP 07/11/14 OPEN 0.0000 0.0000 73.037100 4,900.00 357,882.00 0.00 0.00 357,882.00 376,859
035710409 09-0181 ANNALY CAP MANAGEMENT INC 11/04/05 OPEN 0.0000 0.0000 13.712800 3,500.00 47,995.00 0.00 0.00 47,995.00 38,850
035710409 10-0134 ANNALY CAP MANAGEMENT INC 01/11/10 OPEN 0.0000 0.0000 17.535775 800.00 14,028.62 0.00 0.00 14,029.00 8,880
035710409 11-0077 ANNALY CAP MANAGEMENT INC 10/06/10 OPEN 0.0000 0.0000 17.720000 2,700.00 47,844.00 0.00 0.00 47,844.00 29,970
035710409 13-0002 ANNALY CAP MANAGEMENT INC 05/04/12 OPEN 0.0000 0.0000 16.409900 700.00 11,487.00 0.00 0.00 11,487.00 7,770
037610106 14-0041 APOLLO INVT CORP 05/07/13 OPEN 0.0000 0.0000 8.776100 9,900.00 86,883.00 0.00 0.00 86,883.00 84,051
037610106 14-0088 APOLLO INVT CORP 05/22/13 OPEN 0.0000 0.0000 8.689000 7,200.00 62,567.00 0.00 0.00 62,567.00 61,128
037833100 08-0165 APPLE, INC 02/19/08 OPEN 0.0000 0.0000 127.209000 1,750.00 31,802.00 0.00 0.00 31,802.00 167,300
037833100 14-0273 APPLE, INC 04/21/14 OPEN 0.0000 0.0000 516.525800 4,000.00 295,158.00 0.00 0.00 295,158.00 382,400
04010L103 11-0010 ARES CAP CORP 06/08/10 OPEN 0.0000 0.0000 13.873956 2,700.00 37,459.68 0.00 0.00 37,460.00 45,117
04010L103 11-0023 ARES CAP CORP 06/08/10 OPEN 0.0000 0.0000 13.825400 5,200.00 71,892.08 0.00 0.00 71,892.00 86,892
04010L103 12-0058 ARES CAP CORP 08/01/11 OPEN 0.0000 0.0000 16.330000 700.00 11,431.00 0.00 0.00 11,431.00 11,697
042735100 14-0285 ARROW ELECTRS INC 04/21/14 OPEN 0.0000 0.0000 58.183000 5,600.00 325,825.00 0.00 0.00 325,825.00 324,520
042735100 15-0007 ARROW ELECTRS INC 05/21/14 OPEN 0.0000 0.0000 56.430000 3,900.00 220,077.00 0.00 0.00 220,077.00 226,005
05329W102 13-0245 AUTONATION INC 04/18/13 OPEN 0.0000 0.0000 43.473900 5,800.00 252,149.00 0.00 0.00 252,149.00 96,918
073302101 13-0249 B/E AEROSPACE INC 04/18/13 OPEN 0.0000 0.0000 58.975600 3,700.00 218,210.00 0.00 0.00 218,210.00 315,018
09062X103 12-0069 BIOGEN IDEC INC 08/02/11 OPEN 0.0000 0.0000 103.680000 800.00 82,944.00 0.00 0.00 82,944.00 267,512
09253U108 11-0191 BLACKSTONE GROUP LP 01/28/11 OPEN 0.0000 0.0000 15.680000 6,100.00 95,699.00 0.00 0.00 95,699.00 199,348
09253U108 12-0228 BLACKSTONE GROUP LP 04/30/12 OPEN 0.0000 0.0000 13.460000 1,400.00 18,844.00 0.00 0.00 18,844.00 45,752
110122108 07-0129 BRISTOL-MYERS SQUIBB CO 02/28/07 OPEN 0.0000 0.0000 27.110000 400.00 10,899.00 0.00 0.00 10,899.00 20,248
110122108 07-0193 BRISTOL-MYERS SQUIBB CO 02/26/07 OPEN 0.0000 0.0000 27.110000 300.00 8,135.00 0.00 0.00 8,135.00 15,186
110122108 09-0004 BRISTOL-MYERS SQUIBB CO 05/05/08 OPEN 0.0000 0.0000 22.042400 400.00 8,816.96 0.00 0.00 8,817.00 20,248
110122108 09-0029 BRISTOL-MYERS SQUIBB CO 05/28/08 OPEN 0.0000 0.0000 21.812500 400.00 8,725.00 0.00 0.00 8,725.00 20,248
110122108 09-0048 BRISTOL-MYERS SQUIBB CO 05/30/08 OPEN 0.0000 0.0000 21.899900 900.00 19,709.91 0.00 0.00 19,710.00 45,558
110122108 12-0050 BRISTOL-MYERS SQUIBB CO 07/20/11 OPEN 0.0000 0.0000 28.810000 500.00 14,405.00 0.00 0.00 14,405.00 25,310
12673P105 14-0031 CA INC 05/07/13 OPEN 0.0000 0.0000 27.100800 3,200.00 86,723.00 0.00 0.00 86,723.00 92,416
12673P105 14-0092 CA INC 05/22/13 OPEN 0.0000 0.0000 27.530000 2,300.00 63,319.00 0.00 0.00 63,319.00 66,424
12811R104 14-0147 CALAMOS ASSET MGMT INC CL A 11/14/13 OPEN 0.0000 0.0000 9.897300 6,300.00 62,353.00 0.00 0.00 62,353.00 74,718
12811R104 14-0156 CALAMOS ASSET MGMT INC CL A 11/06/13 OPEN 0.0000 0.0000 9.732500 9,200.00 89,539.00 0.00 0.00 89,539.00 109,112
149123101 11-0046 CATERPILLAR 08/10/10 OPEN 0.0000 0.0000 72.029000 1,500.00 108,044.00 0.00 0.00 108,044.00 151,125
192446102 14-0117 COGNIZANT TECH SOLUTIONS CL A 10/10/01 OPEN 0.0000 0.0000 84.448600 3,500.00 295,570.00 0.00 0.00 295,570.00 171,675
192446102 15-0077 COGNIZANT TECH SOLUTIONS CL A 07/21/14 OPEN 0.0000 0.0000 49.410000 7,000.00 345,870.00 0.00 0.00 345,870.00 343,350
197199409 14-0228 COLUMBIA ACORN FUND CLASS Z 01/28/14 OPEN 0.0000 0.0000 35.930000 12,818.29 460,561.00 0.00 0.00 460,561.00 613,099
197199813 11-0123 COLUMBIA ACORN INTL FUND CL Z 10/04/10 OPEN 0.0000 0.0000 38.340030 5,216.48 200,000.00 0.00 0.00 200,000.00 249,504
197199813 11-0144 COLUMBIA ACORN INTL FUND CL Z 12/17/10 OPEN 0.0000 0.0000 39.788125 42.95 1,708.90 0.00 0.00 1,709.00 2,054
197199813 11-0188 COLUMBIA ACORN INTL FUND CL Z 01/28/11 OPEN 0.0000 0.0000 40.980000 5,124.45 210,000.00 0.00 0.00 210,000.00 245,102
197199813 12-0017 COLUMBIA ACORN INTL FUND CL Z 06/10/11 OPEN 0.0000 0.0000 41.099969 131.14 5,390.00 0.00 0.00 5,391.00 6,272
197199813 12-0021 COLUMBIA ACORN INTL FUND CL Z 06/10/11 OPEN 0.0000 0.0000 41.098372 127.78 5,252.00 0.00 0.00 5,252.00 6,112
197199813 13-0030 COLUMBIA ACORN INTL FUND CL Z 06/07/12 OPEN 0.0000 0.0000 35.878912 29.40 1,055.00 0.00 0.00 1,055.00 1,406
197199813 13-0039 COLUMBIA ACORN INTL FUND CL Z 06/06/12 OPEN 0.0000 0.0000 35.885126 28.64 1,027.00 0.00 0.00 1,027.00 1,370
205363104 14-0283 COMPUTER SCIENCES CORP 04/21/14 OPEN 0.0000 0.0000 60.030000 5,500.00 330,016.00 0.00 0.00 330,016.00 343,145
205363104 15-0008 COMPUTER SCIENCES CORP 05/21/14 OPEN 0.0000 0.0000 61.040700 3,600.00 219,747.00 0.00 0.00 219,747.00 224,604
205887102 07-0130 CONAGRA FOODS INC 02/28/07 OPEN 0.0000 0.0000 25.760000 1,400.00 36,601.00 0.00 0.00 36,601.00 42,182
205887102 07-0223 CONAGRA FOODS INC 02/28/07 OPEN 0.0000 0.0000 26.140000 1,800.00 47,058.00 0.00 0.00 47,058.00 54,234
205887102 09-0034 CONAGRA FOODS INC 05/29/08 OPEN 0.0000 0.0000 23.732400 400.00 9,492.96 0.00 0.00 9,493.00 12,052
126650100 13-0240 CVS/CAREMARK CORP 04/18/13 OPEN 0.0000 0.0000 56.986600 4,200.00 239,341.00 0.00 0.00 239,341.00 320,712
126650100 14-0012 CVS/CAREMARK CORP 05/24/13 OPEN 0.0000 0.0000 59.261200 2,900.00 171,857.00 0.00 0.00 171,857.00 221,444
244199105 12-0066 DEERE & CO 08/02/11 OPEN 0.0000 0.0000 79.597800 1,800.00 143,276.00 0.00 0.00 143,276.00 153,198
247361702 14-0097 DELTA AIR LINES INC 07/08/13 OPEN 0.0000 0.0000 18.784400 13,400.00 251,711.00 0.00 0.00 251,711.00 501,964
25179M103 14-0281 DEVON ENERGY CORP 04/21/14 OPEN 0.0000 0.0000 68.655400 4,700.00 322,680.00 0.00 0.00 322,680.00 354,850
25179M103 15-0011 DEVON ENERGY CORP 05/21/14 OPEN 0.0000 0.0000 70.397200 3,100.00 218,231.00 0.00 0.00 218,231.00 234,050
253651109 14-0280 DIEBOLD INC 04/21/14 OPEN 0.0000 0.0000 39.500000 2,200.00 86,900.00 0.00 0.00 86,900.00 82,896
253651109 15-0005 DIEBOLD INC 05/21/14 OPEN 0.0000 0.0000 37.288500 1,500.00 55,933.00 0.00 0.00 55,933.00 56,520
25490A101 10-0086 DIRECTV CLASS-A 11/20/09 OPEN 0.0000 0.0000 21.910975 2,700.00 59,160.00 0.00 0.00 59,160.00 232,335
256206103 15-0046 DODGE & COX INTERNATIONAL STOCK 07/17/14 OPEN 0.0000 0.0000 46.779978 6,413.00 300,000.00 0.00 0.00 300,000.00 294,998
264411505 14-0043 DUKE REALTY CORP 05/07/13
Page 4 of 7 OPEN 0.0000 0.0000 17.803900 4,800.00 85,459.00 0.00 0.00 85,459.00 86,352
264411505 14-0091 DUKE REALTY CORP 05/22/13 OPEN 0.0000 0.0000 18.670000 3,400.00 63,478.00 0.00 0.00 63,478.00 61,166
277432100 14-0132 EASTMAN CHEM CO 11/13/13 OPEN 0.0000 0.0000 79.079500 2,400.00 189,791.00 0.00 0.00 189,791.00 189,072
Beginning Commissi
CUSIP Invest Security Purchase Call Yield Yield Beginning Beginning Unamor Premium on Total Market
Number Description Date Date Matur Call Unit Cost Par Val/Shares Val/Cost Discount Fees Cost Value
26875P101 14-0256 E O G RES INC 02/04/14 OPEN 0.0000 0.0000 164.886700 1,200.00 197,864.00 0.00 0.00 197,864.00 131,328
G3157S106 13-0254 ENSCO PLC CL A 04/18/13 OPEN 0.0000 0.0000 54.709700 4,500.00 246,194.00 0.00 0.00 246,194.00 227,925
G3157S106 14-0013 ENSCO PLC CL A 05/24/13 OPEN 0.0000 0.0000 63.185800 2,700.00 170,602.00 0.00 0.00 170,602.00 136,755
G3157S106 14-0238 ENSCO PLC CL A 02/04/14 OPEN 0.0000 0.0000 50.329900 1,000.00 50,330.00 0.00 0.00 50,330.00 50,650
G3223R108 13-0182 EVEREST RE GROUP LTD 10/11/12 OPEN 0.0000 0.0000 109.698100 2,100.00 230,366.00 0.00 0.00 230,366.00 327,411
G3223R108 13-0184 EVEREST RE GROUP LTD 11/20/12 OPEN 0.0000 0.0000 102.143100 1,300.00 132,786.00 0.00 0.00 132,786.00 202,683
316128834 15-0048 FIDELITY ADVISOR MID CAP VALUE 07/17/14 OPEN 0.0000 0.0000 23.990000 12,505.21 300,000.00 0.00 0.00 300,000.00 293,497
315805655 12-0173 FIDELITY ADVISORS SM CAP CL I 12/19/11 OPEN 0.0000 0.0000 21.940000 821.66 18,027.00 0.00 0.00 18,027.00 24,485
354713653 15-0019 FRANKLIN SMALL CAP GROWTH ADV 05/20/14 OPEN 0.0000 0.0000 18.949930 15,831.14 300,000.00 0.00 0.00 300,000.00 302,850
354713653 15-0049 FRANKLIN SMALL CAP GROWTH ADV 07/17/14 OPEN 0.0000 0.0000 19.770000 22,761.76 450,000.00 0.00 0.00 450,000.00 435,432
361439888 11-0117 GAMCO WESTWD MIGHTY M FD AAA 10/19/10 OPEN 0.0000 0.0000 16.490000 9,399.64 155,000.00 0.00 0.00 155,000.00 220,797
361439888 11-0119 GAMCO WESTWD MIGHTY M FD AAA 10/18/10 OPEN 0.0000 0.0000 16.370001 9,163.10 150,000.00 0.00 0.00 150,000.00 215,241
361439888 11-0128 GAMCO WESTWD MIGHTY M FD AAA 11/24/10 OPEN 0.0000 0.0000 16.209930 268.28 4,348.80 0.00 0.00 4,849.00 6,302
361439888 11-0135 GAMCO WESTWD MIGHTY M FD AAA 11/24/10 OPEN 0.0000 0.0000 16.209694 275.21 4,461.07 0.00 0.00 4,461.00 6,465
H2906T109 11-0111 GARMIN LTD 10/21/10 OPEN 0.0000 0.0000 31.036400 1,700.00 52,762.00 0.00 0.00 52,762.00 93,534
H2906T109 11-0120 GARMIN LTD 10/06/10 OPEN 0.0000 0.0000 30.575625 1,200.00 36,691.00 0.00 0.00 36,691.00 66,024
372460105 14-0002 GENUINE PARTS CO 05/22/13 OPEN 0.0000 0.0000 80.709900 800.00 64,568.00 0.00 0.00 64,568.00 66,256
372460105 14-0030 GENUINE PARTS CO 05/07/13 OPEN 0.0000 0.0000 75.710200 1,100.00 83,281.00 0.00 0.00 83,281.00 91,102
38142Y500 10-0064 GOLDMAN SACHS GRWTH OPP FUND 08/05/09 OPEN 0.0000 0.0000 16.550000 12,084.59 200,000.00 0.00 0.00 200,000.00 336,556
38142Y500 11-0160 GOLDMAN SACHS GRWTH OPP FUND 12/10/10 OPEN 0.0000 0.0000 22.290000 117.97 2,630.00 0.00 0.00 2,630.00 3,286
38142Y500 12-0166 GOLDMAN SACHS GRWTH OPP FUND 12/09/11 OPEN 0.0000 0.0000 20.639876 822.91 16,985.00 0.00 0.00 16,985.00 22,918
382550101 14-0219 GOODYEAR TIRE & RUBBER CO 01/07/14 OPEN 0.0000 0.0000 23.643500 13,500.00 319,187.00 0.00 0.00 319,187.00 339,930
38259P508 15-0003 GOOGLE INC 05/21/14 OPEN 0.0000 0.0000 528.319900 200.00 105,664.00 0.00 0.00 105,664.00 115,910
393122106 14-0120 GREEN MOUNTAIN COFFEE ROASTERS 10/10/13 OPEN 0.0000 0.0000 76.629900 3,900.00 298,857.00 0.00 0.00 298,857.00 465,192
393122106 14-0129 GREEN MOUNTAIN COFFEE ROASTERS 11/14/13 OPEN 0.0000 0.0000 60.223900 3,100.00 186,694.00 0.00 0.00 186,694.00 369,768
393122106 14-0135 GREEN MOUNTAIN COFFEE ROASTERS 11/06/13 OPEN 0.0000 0.0000 62.366000 800.00 49,893.00 0.00 0.00 49,863.00 95,424
41012R811 14-0055 HANCOCK HORIZON BURKENROAD SMALL 06/04/13 OPEN 0.0000 0.0000 48.609997 6,171.57 300,000.00 0.00 0.00 300,000 348,632
41664L294 13-0183 HARTFORD INTL OPPORTUNITY I 11/16/12 OPEN 0.0000 0.0000 14.069990 13,503.91 190,000.00 0.00 0.00 190,000 231,997
41664L294 14-0070 HARTFORD INTL OPPORTUNITY I 07/24/13 OPEN 0.0000 0.0000 16.289985 5,217.93 85,000.00 0.00 0.00 85,000 89,644
421915109 07-0141 HCP, INC 07/19/11 OPEN 0.0000 0.0000 532.020000 50.00 26,601.00 0.00 0.00 26,601.00 2,077
421915109 07-0143 HCP, INC 02/27/07 OPEN 0.0000 0.0000 39.547500 200.00 7,909.50 0.00 0.00 7,909.50 8,306
421915109 07-0144 HCP, INC 02/27/07 OPEN 0.0000 0.0000 39.587500 200.00 7,917.50 0.00 0.00 7,917.50 8,306
421915109 07-0145 HCP, INC 02/27/07 OPEN 0.0000 0.0000 39.597500 200.00 7,919.50 0.00 0.00 7,919.50 8,306
421915109 07-0220 HCP, INC 02/27/07 OPEN 0.0000 0.0000 38.721400 659.00 25,517.00 0.00 0.00 25,517.00 27,368
421915109 08-0117 HCP, INC 02/27/07 OPEN 0.0000 0.0000 38.681400 941.00 36,399.23 0.00 0.00 36,399.23 39,080
421915109 09-0024 HCP, INC 12/03/07 OPEN 0.0000 0.0000 33.125000 600.00 19,875.00 0.00 0.00 19,875.00 24,918
742935299 14-0229 HODGES SMALL CAP 01/28/14 OPEN 0.0000 0.0000 17.739900 11,273.96 200,000.00 0.00 0.00 200,000.00 219,053
742935299 15-0001 HODGES SMALL CAP 05/19/14 Open 0.0000 0.0000 18.769995 13,319.13 250,000.00 0.00 0.00 250,000 258,791
742935299 15-0081 HODGES SMALL CAP 07/21/14 Open 0.0000 0.0000 19.920000 12,550.20 250,000.00 0.00 0.00 250,000 243,850
437076102 13-0204 HOME DEPOT 01/11/13 OPEN 0.0000 0.0000 63.207200 3,700.00 233,867.00 0.00 0.00 233,867.00 299,145
437076102 14-0010 HOME DEPOT 05/24/13 OPEN 0.0000 0.0000 78.420000 2,200.00 172,524.00 0.00 0.00 172,524.00 177,870
45822P105 13-0009 INTEGRYS ENERGY GROUP INC 05/04/12 OPEN 0.0000 0.0000 55.135100 1,000.00 55,135.00 0.00 0.00 55,135.00 65,560
45822P105 13-0010 INTEGRYS ENERGY GROUP INC 05/04/12 OPEN 0.0000 0.0000 55.135100 1,300.00 71,676.00 0.00 0.00 71,676.00 85,228
45865V100 12-0068 INTERCONTINENTAL EXCHANGE INC 08/02/11 OPEN 0.0000 0.0000 125.506700 1,000.00 125,507.00 0.00 0.00 125,507.00 192,220
460146103 14-0215 INTERNATIONAL PAPER CO 01/07/14 OPEN 0.0000 0.0000 48.984000 6,500.00 318,398.00 0.00 0.00 318,398.00 308,750
460146103 14-0242 INTERNATIONAL PAPER CO 02/04/14 OPEN 0.0000 0.0000 46.969900 4,300.00 201,970.00 0.00 0.00 201,970.00 204,250
465899706 10-0182 IVY INTERNATIONAL CORE EQUITY 04/23/10 OPEN 0.0000 0.0000 15.009900 21,319.12 320,000.00 0.00 0.00 320,000.00 428,301
465899706 11-0162 IVY INTERNATIONAL CORE EQUITY 12/13/10 OPEN 0.0000 0.0000 16.269860 268.62 4,370.41 0.00 0.00 4,370.00 5,397
465899706 12-0168 IVY INTERNATIONAL CORE EQUITY 12/12/11 OPEN 0.0000 0.0000 13.819995 850.70 11,757.00 0.00 0.00 11,757.00 17,091
494368103 13-0239 KIMBERLY CLARK CORP 04/18/13 OPEN 0.0000 0.0000 100.520000 800.00 80,416.00 0.00 0.00 80,416.00 83,096
494368103 14-0011 KIMBERLY CLARK CORP 05/24/13 OPEN 0.0000 0.0000 102.305300 1,700.00 173,919.00 0.00 0.00 173,919.00 176,579
49456B101 14-0034 KINDER MORGAN INC 05/22/13 OPEN 0.0000 0.0000 40.060000 1,600.00 64,096.00 0.00 0.00 64,096.00 57,568
49456B101 14-0040 KINDER MORGAN INC 05/07/13 OPEN 0.0000 0.0000 38.784300 2,300.00 89,203.00 0.00 0.00 89,203.00 82,754
501044101 14-0146 KROGER CO 11/14/13 OPEN 0.0000 0.0000 41.462100 4,500.00 186,579.00 0.00 0.00 186,579.00 220,410
534187109 13-0252 LINCOLN NATIONAL CORP IND 04/18/13 OPEN 0.0000 0.0000 32.296500 6,200.00 200,238.00 0.00 0.00 200,238.00 324,818
543069405 14-0053 LONGLEAF PARTNERS INTL FUND 06/04/13 OPEN 0.0000 0.0000 15.549990 11,254.02 175,000.00 0.00 0.00 175,000.00 202,910
559222401 14-0145 MAGNA INTL INC CL A 11/14/13 OPEN 0.0000 0.0000 84.327800 2,200.00 185,521.00 0.00 0.00 185,521.00 236,280
559222401 15-0040 MAGNA INTL INC CL A 07/11/14 OPEN 0.0000 0.0000 108.337000 3,300.00 357,512.00 0.00 0.00 357,512.00 354,420
561709734 14-0234 MANAGERS AMG SKYLINE SPECIAL 01/30/14 OPEN 0.0000 0.0000 37.739900 5,829.36 220,000.00 0.00 0.00 220,000.00 220,991
574599106 14-0282 MASCO CORP 04/21/14 OPEN 0.0000 0.0000 21.516900 15,300.00 329,209.00 0.00 0.00 329,209.00 318,240
577081102 13-0217 MATTEL INC 02/01/13
Page 5 of 7 OPEN 0.0000 0.0000 37.150000 1,600.00 59,440.00 0.00 0.00 59,440.00 56,672
58933Y105 13-0047 MERCK AND CO INC 07/06/12 OPEN 0.0000 0.0000 41.779500 1,900.00 79,381.00 0.00 0.00 79,381.00 107,806
58933Y105 13-0070 MERCK AND CO INC 08/02/12 OPEN 0.0000 0.0000 44.540000 1,200.00 53,448.00 0.00 0.00 53,448.00 68,088
Beginning Commissi
CUSIP Invest Security Purchase Call Yield Yield Beginning Beginning Unamor Premium on Total Market
Number Description Date Date Matur Call Unit Cost Par Val/Shares Val/Cost Discount Fees Cost Value
589584101 07-0116 MERIDIAN BIOSCIENCE INC 02/23/07 OPEN 0.0000 0.0000 18.685400 1,500.00 28,028.00 0.00 0.00 28,028.00 29,565
589584101 09-0015 MERIDIAN BIOSCIENCE INC 05/22/08 OPEN 0.0000 0.0000 28.650000 300.00 8,595.00 0.00 0.00 8,595.00 5,913
589584101 11-0080 MERIDIAN BIOSCIENCE INC 10/06/10 OPEN 0.0000 0.0000 21.710000 400.00 8,684.00 0.00 0.00 8,684.00 7,884
589584101 13-0005 MERIDIAN BIOSCIENCE INC 05/04/12 OPEN 0.0000 0.0000 20.739900 500.00 10,370.00 0.00 0.00 10,370.00 9,855
55272X102 07-0251 MFA MORTGAGE INVESTMENTS INC 03/01/07 OPEN 0.0000 0.0000 7.347000 1,200.00 8,816.44 0.00 0.00 8,816.00 9,768
55272X102 07-0252 MFA MORTGAGE INVESTMENTS INC 03/01/07 OPEN 0.0000 0.0000 7.397000 1,300.00 9,616.14 0.00 0.00 9,616.00 10,582
55272X102 07-0254 MFA MORTGAGE INVESTMENTS INC 03/01/07 OPEN 0.0000 0.0000 7.357000 1,700.00 12,506.95 0.00 0.00 12,507.00 13,838
55272X102 07-0295 MFA MORTGAGE INVESTMENTS INC 03/01/07 OPEN 0.0000 0.0000 7.423800 700.00 5,197.00 0.00 0.00 5,197.00 5,698
55272X102 07-0299 MFA MORTGAGE INVESTMENTS INC 03/01/07 OPEN 0.0000 0.0000 7.393800 6,700.00 49,538.99 0.00 0.00 49,538.99 54,538
55272X102 09-0010 MFA MORTGAGE INVESTMENTS INC 05/08/08 OPEN 0.0000 0.0000 7.028700 2,400.00 16,869.00 0.00 0.00 16,869.00 19,536
55272X102 09-0044 MFA MORTGAGE INVESTMENTS INC 05/08/08 OPEN 0.0000 0.0000 7.047300 2,600.00 18,323.00 0.00 0.00 18,323.00 21,164
55273E822 13-0189 MFS INTERNATIONAL VALUE FUND I 11/21/12 OPEN 0.0000 0.0000 27.459990 7,101.24 195,000.00 0.00 0.00 195,000.00 257,207
55273B822 14-0054 MFS INTERNATIONAL VALUE FUND I 06/04/13 OPEN 0.0000 0.0000 31.520003 11,104.06 350,000.00 0.00 0.00 350,000.00 402,189
55273B822 14-0069 MFS INTERNATIONAL VALUE FUND I 07/23/13 OPEN 0.0000 0.0000 33.050001 4,084.72 135,000.00 0.00 0.00 135,000.00 147,949
55273E822 14-0226 MFS INTERNATIONAL VALUE FUND I 01/28/14 OPEN 0.0000 0.0000 34.160000 8,782.20 300,000.00 0.00 0.00 300,000.00 318,091
55273E822 15-0047 MFS INTERNATIONAL VALUE FUND I 07/17/14 OPEN 0.0000 0.0000 37.090016 8,088.43 300,000.00 0.00 0.00 300,000.00 292,963
595017104 10-0147 MICROCHIP TECHNOLOGY INC 01/14/10 OPEN 0.0000 0.0000 28.557280 1,200.00 34,269.00 0.00 0.00 34,269.00 54,024
595017104 13-0012 MICROCHIP TECHNOLOGY INC 05/04/12 OPEN 0.0000 0.0000 35.470000 2,000.00 70,940.00 0.00 0.00 70,940.00 90,040
595112103 15-0043 MICRON TECHNOLOGY INC 07/11/14 OPEN 0.0000 0.0000 32.370800 11,000.00 356,079.00 0.00 0.00 356,079.00 336,050
553829102 14-0028 MVC CAPITAL INC 05/07/13 OPEN 0.0000 0.0000 12.996500 6,600.00 85,777.00 0.00 0.00 85,777.00 81,774
553829102 14-0089 MVC CAPITAL INC 05/22/13 OPEN 0.0000 0.0000 13.045000 4,900.00 63,920.00 0.00 0.00 63,920.00 60,711
628530107 12-0199 MYLAN INC 01/11/12 OPEN 0.0000 0.0000 21.560100 6,300.00 135,829.00 0.00 0.00 135,829.00 311,031
628530107 12-0226 MYLAN INC 04/30/12 OPEN 0.0000 0.0000 22.345800 5,300.00 118,435.00 0.00 0.00 118,435.00 261,661
628530107 13-0018 MYLAN INC 05/07/12 OPEN 0.0000 0.0000 21.499900 1,000.00 21,500.00 0.00 0.00 21,500.00 49,370
628530107 14-0276 MYLAN INC 04/21/14 OPEN 0.0000 0.0000 46.089300 1,100.00 50,698.00 0.00 0.00 50,698.00 54,307
666807102 14-0033 NORTHROP GRUMMAN CORP 05/22/13 OPEN 0.0000 0.0000 81.849900 800.00 65,480.00 0.00 0.00 65,480.00 98,616
666807102 14-0042 NORTHROP GRUMMAN CORP 05/07/13 OPEN 0.0000 0.0000 76.480000 1,100.00 84,128.00 0.00 0.00 84,128.00 135,597
67020Q305 15-0045 NTELOS HOLDINGS CORP 07/11/14 OPEN 0.0000 0.0000 12.869100 7,000.00 90,084.00 0.00 0.00 90,084.00 84,280
67064Y727 15-0050 NUVEEN NWQ SMALL CAP VALUE INDEX 07/17/14 OPEN 0.0000 0.0000 41.970017 10,721.94 450,000.00 0.00 0.00 450,000.00 431,236
413838202 12-0055 OAKMARK INTERNATIONAL FUND 07/28/11 OPEN 0.0000 0.0000 19.600000 12,755.10 250,000.00 0.00 0.00 250,000.00 332,653
68235P108 14-0275 ONE GAS INC W I 04/21/14 OPEN 0.0000 0.0000 35.909100 2,000.00 71,818.00 0.00 0.00 71,818.00 52,160
68235P108 15-0012 ONE GAS INC W I 05/21/14 OPEN 0.0000 0.0000 36.245702 1,375.00 49,838.00 0.00 0.00 49,838.00 35,860
682680103 08-0171 ONEOK INC 02/25/08 OPEN 0.0000 0.0000 47.490000 600.00 28,494.00 0.00 0.00 28,494.00 38,658
682680103 08-0190 ONEOK INC 02/19/08 OPEN 0.0000 0.0000 47.386500 600.00 28,431.90 0.00 0.00 28,432.00 38,658
683974505 11-0060 OPPENHEIMER DEVELOPING MKTS FDS 08/25/10 OPEN 0.0000 0.0000 29.689988 8,251.94 245,000.00 0.00 0.00 245,000.00 327,519
683974505 11-0073 OPPENHEIMER DEVELOPING MKTS FDS 10/04/10 OPEN 0.0000 0.0000 33.589960 1,200.00 40,281.00 0.00 0.00 40,281.00 47,628
683974505 11-0089 OPPENHEIMER DEVELOPING MKTS FDS 10/21/10 OPEN 0.0000 0.0000 34.010135 882.09 30,000.00 0.00 0.00 30,000.00 35,010
683974505 11-0148 OPPENHEIMER DEVELOPING MKTS FDS 12/24/10 OPEN 0.0000 0.0000 35.008860 15.80 553.14 0.00 0.00 553.00 627
683974505 11-0172 OPPENHEIMER DEVELOPING MKTS FDS 12/24/10 OPEN 0.0000 0.0000 35.008860 33.77 1,182.77 0.00 0.00 1,183.00 1,340
683974505 11-0181 OPPENHEIMER DEVELOPING MKTS FDS 01/31/11 OPEN 0.0000 0.0000 34.069970 2,377.46 81,000.00 0.00 0.00 81,000.00 94,361
683974505 11-0189 OPPENHEIMER DEVELOPING MKTS FDS 01/31/11 OPEN 0.0000 0.0000 34.069970 2,993.84 102,000.00 0.00 0.00 102,000.00 118,825
68380L407 14-0149 OPPENHEIMER INTL GROWTH FD CL Y 11/14/13 OPEN 0.0000 0.0000 36.619976 2,949.21 108,000.00 0.00 0.00 108,000.00 110,595
68380L407 14-0153 OPPENHEIMER INTL GROWTH FD CL Y 11/05/13 OPEN 0.0000 0.0000 37.039980 7,424.41 275,000.00 0.00 0.00 275,000.00 278,415
68380L407 14-0205 OPPENHEIMER INTL GROWTH FD CL Y 01/31/14 OPEN 0.0000 0.0000 36.269990 5,514.20 200,000.00 0.00 0.00 200,000.00 206,783
68380L407 14-0233 OPPENHEIMER INTL GROWTH FD CL Y 01/30/14 OPEN 0.0000 0.0000 36.420000 5,766.06 210,000.00 0.00 0.00 210,000.00 216,227
704326107 13-0049 PAYCHEX 07/06/12 OPEN 0.0000 0.0000 31.450000 2,500.00 78,625.00 0.00 0.00 78,625.00 102,525
704326107 13-0077 PAYCHEX 08/02/12 OPEN 0.0000 0.0000 32.890000 1,600.00 52,624.00 0.00 0.00 52,624.00 65,616
69329Y104 15-0037 PDL BIOPHARMA INC 07/11/14 OPEN 0.0000 0.0000 9.443200 9,500.00 89,710.00 0.00 0.00 89,710.00 89,110
70706P104 15-0041 PENGROWTH ENERGY INC 07/11/14 OPEN 0.0000 0.0000 6.880000 13,000.00 89,440.00 0.00 0.00 89,440.00 83,200
713291102 13-0080 PEPCO HOLDINGS INC 08/02/12 OPEN 0.0000 0.0000 20.130000 2,600.00 52,338.00 0.00 0.00 52,338.00 69,810
717081103 13-0051 PFIZER INC 07/06/12 OPEN 0.0000 0.0000 22.930000 3,500.00 80,255.00 0.00 0.00 80,225.00 100,450
717081103 13-0069 PFIZER INC 08/02/12 OPEN 0.0000 0.0000 23.710000 2,200.00 52,162.00 0.00 0.00 52,162.00 63,140
74160Q103 14-0143 PRIMECAP ODYSSEY GROWTH FUND 11/12/13 OPEN 0.0000 0.0000 23.330000 10,287.18 240,000.00 0.00 0.00 240,000.00 253,270
74251V102 14-0121 PRINCIPAL FINANCIAL GROUP INC 10/10/13 OPEN 0.0000 0.0000 42.887700 6,800.00 291,636.00 0.00 0.00 291,636.00 337,824
74251V102 15-0010 PRINCIPAL FINANCIAL GROUP INC 05/21/14 OPEN 0.0000 0.0000 45.555800 4,800.00 218,668.00 0.00 0.00 218,668.00 238,464
74255L795 14-0056 PRINCIPAL MIDCAP 06/04/13 OPEN 0.0000 0.0000 18.170004 13,758.94 250,000.00 0.00 0.00 250,000.00 292,653
74255L795 14-0245 PRINCIPAL MIDCAP 02/05/14 OPEN 0.0000 0.0000 19.450000 13,778.92 268,000.00 0.00 0.00 268,000.00 293,078
74255L795 15-0002 PRINCIPAL MIDCAP 05/19/14 OPEN 0.0000 0.0000 20.740003 7,232.40 150,000.00 0.00 0.00 150,000.00 153,833
744320102 14-0217 PRUDENTIAL FINANCIAL INC 01/07/14 OPEN 0.0000 0.0000 90.330000 3,500.00 316,155.00 0.00 0.00 316,155.00 304,395
747525103 14-0081 QUALCOMM INC 07/08/13 OPEN 0.0000 0.0000 61.170400 4,300.00 263,033.00 0.00 0.00 263,033.00 316,996
747525103 15-0006 QUALCOMM INC 05/21/14
Page 6 of 7 OPEN 0.0000 0.0000 79.490000 2,800.00 222,572.00 0.00 0.00 222,572.00 206,416
756109104 11-0124 REALTY INCOME CORP 10/06/10 OPEN 0.0000 0.0000 33.646428 1,400.00 47,105.00 0.00 0.00 47,105.00 60,270
756109104 13-0011 REALTY INCOME CORP 05/04/12 OPEN 0.0000 0.0000 39.744100 1,700.00 67,565.00 0.00 0.00 67,565.00 73,185
Beginning Commissi
CUSIP Invest Security Purchase Call Yield Yield Beginning Beginning Unamor Premium on Total Market
Number Description Date Date Matur Call Unit Cost Par Val/Shares Val/Cost Discount Fees Cost Value
761713106 11-0009 REYNOLDS AMERICAN INC 06/08/10 OPEN 0.0000 0.0000 53.039300 700.00 37,127.51 0.00 0.00 37,128.00 39,095
761713106 11-0018 REYNOLDS AMERICAN INC 06/08/10 OPEN 0.0000 0.0000 52.979742 1,400.00 74,171.64 0.00 0.00 74,172.00 78,190
749685103 08-0178 RPM INTERNATIONAL INC 02/27/08 OPEN 0.0000 0.0000 21.832500 300.00 6,549.75 0.00 0.00 6,550.00 13,254
780905741 08-0179 RPM INTERNATIONAL INC 02/27/08 OPEN 0.0000 0.0000 21.856500 1,300.00 28,413.51 0.00 0.00 28,414.00 57,434
749685103 08-0197 RPM INTERNATIONAL INC 02/21/08 OPEN 0.0000 0.0000 21.612500 1,900.00 41,064.00 0.00 0.00 41,064.00 83,942
749685103 11-0081 RPM INTERNATIONAL INC 10/06/10 OPEN 0.0000 0.0000 20.050000 400.00 8,020.00 0.00 0.00 8,020.00 17,672
78390X101 14-0044 SAIC INC 05/07/13 OPEN 0.0000 0.0000 14.761300 5,800.00 85,616.00 0.00 0.00 85,616.00 242,266
78390X101 14-0093 SAIC INC 05/22/13 OPEN 0.0000 0.0000 15.410000 4,100.00 63,181.00 0.00 0.00 63,181.00 171,257
808625107 14-0279 SCIENCE APPLICATIONS INTE 04/21/14 OPEN 0.0000 0.0000 38.918899 1,372.00 53,397.00 0.00 0.00 53,397.00 57,308
808625107 15-0004 SCIENCE APPLICATIONS INTE 05/21/14 OPEN 0.0000 0.0000 37.097202 915.00 33,943.00 0.00 0.00 33,943.00 38,220
810634206 13-0176 SCOUT MID CAP FUND 08/03/12 OPEN 0.0000 0.0000 12.910002 9,101.47 117,500.00 0.00 0.00 117,500.00 165,647
842587107 09-0091 SOUTHERN CO 08/28/08 OPEN 0.0000 0.0000 37.624600 1,300.00 48,912.00 0.00 0.00 48,912.00 56,277
842587107 09-0093 SOUTHERN CO 08/29/08 OPEN 0.0000 0.0000 37.515200 2,100.00 78,781.98 0.00 0.00 78,782.00 90,909
845467109 15-0038 SOUTHWESTERN ENERGY CO 07/11/14 OPEN 0.0000 0.0000 44.096300 8,200.00 361,590.00 0.00 0.00 361,590.00 354,978
847560109 11-0103 SPECTRA ENERGY CORP 10/22/10 OPEN 0.0000 0.0000 23.517843 2,100.00 49,388.00 0.00 0.00 49,388.00 85,932
847560109 11-0113 SPECTRA ENERGY CORP 10/21/10 OPEN 0.0000 0.0000 24.983951 2,600.00 61,901.00 0.00 0.00 61,901.00 106,392
864159108 14-0144 STURM RUGER & CO INC 11/14/13 OPEN 0.0000 0.0000 73.779900 800.00 59,024.00 0.00 0.00 59,024.00 39,968
864159108 14-0155 STURM RUGER & CO INC 11/06/13 OPEN 0.0000 0.0000 68.253600 1,400.00 95,555.00 0.00 0.00 95,555.00 69,944
867914103 13-0201 SUNTRUST BKS INC 01/11/13 OPEN 0.0000 0.0000 28.740000 8,200.00 235,668.00 0.00 0.00 235,668.00 312,010
867914103 13-0216 SUNTRUST BKS INC 02/01/13 OPEN 0.0000 0.0000 29.097200 5,300.00 154,215.00 0.00 0.00 154,215.00 201,665
779552207 14-0160 T ROWE PRICE EXT EQ MKT IDX 11/04/13 OPEN 0.0000 0.0000 23.860000 14,249.79 340,000.00 0.00 0.00 340,000.00 352,255
779562107 14-0068 T ROWE PRICE NEW HORIZONS FUND 07/23/13 OPEN 0.0000 0.0000 42.809978 2,919.88 125,000.00 0.00 0.00 125,000.00 133,001
779562107 15-0013 T ROWE PRICE NEW HORIZONS FUND 05/23/14 OPEN 0.0000 0.0000 44.149988 3,601.36 159,000.00 0.00 0.00 159,000.00 164,042
883203101 13-0207 TEXTRON INC 01/11/13 OPEN 0.0000 0.0000 26.290000 9,200.00 241,868.00 0.00 0.00 241,868.00 334,604
883203101 13-0219 TEXTRON INC 02/01/13 OPEN 0.0000 0.0000 28.854400 5,400.00 155,814.00 0.00 0.00 155,814.00 196,398
883556102 15-0039 THERMO FISHER SCIENTIFIC INC 07/11/14 OPEN 0.0000 0.0000 118.689700 3,000.00 356,069.00 0.00 0.00 356,069.00 364,500
88732J207 12-0230 TIME WARNER CABLE INC 04/30/12 OPEN 0.0000 0.0000 81.496300 1,500.00 122,244.00 0.00 0.00 122,244.00 217,650
893509224 14-0209 TRANSAMERICA FDS 01/31/14 OPEN 0.0000 0.0000 17.550000 11,396.01 200,000.00 0.00 0.00 200,000.00 213,675
9024944103 15-0044 TYSON FOODS INC 07/11/14 OPEN 0.0000 0.0000 39.248400 9,200.00 361,085.00 0.00 0.00 361,085.00 342,332
907818108 13-0082 UNION PACIFIC CORP 08/02/12 OPEN 0.0000 0.0000 123.183600 1,100.00 135,502.00 0.00 0.00 135,502.00 108,141
91359E105 07-0239 UNIVERSAL HLTH RLTY INCOME TR SBI 02/28/07 OPEN 0.0000 0.0000 39.320000 2,100.00 82,575.00 0.00 0.00 82,575.00 88,326
91359E105 07-0249 UNIVERSAL HLTH RLTY INCOME TR SBI 03/01/07 OPEN 0.0000 0.0000 39.340900 800.00 31,473.00 0.00 0.00 31,473.00 33,648
91359E105 09-0026 UNIVERSAL HLTH RLTY INCOME TR SBI 05/27/08 OPEN 0.0000 0.0000 32.890000 500.00 16,445.00 0.00 0.00 16,445.00 21,030
91913Y100 12-0192 VALERO ENERGY CORP 01/11/12 OPEN 0.0000 0.0000 20.150800 4,900.00 98,739.00 0.00 0.00 98,739.00 248,920
91913Y100 14-0014 VALERO ENERGY CORP 05/24/13 OPEN 0.0000 0.0000 41.827700 4,100.00 171,494.00 0.00 0.00 171,494.00 208,280
91913Y100 15-0054 VALERO ENERGY CORP 07/21/14 OPEN 0.0000 0.0000 49.749900 1,000.00 49,750.00 0.00 0.00 49,750.00 50,800
921937686 15-0051 VANGUARD SMALL CAP VALUE INDEX 07/17/14 OPEN 0.0000 0.0000 44.589986 11,213.28 500,000.00 0.00 0.00 500,000.00 484,189
928563402 14-0118 VMWARE INC CLASS A 10/10/13 OPEN 0.0000 0.0000 81.163700 3,700.00 300,306.00 0.00 0.00 300,306.00 367,632
928563402 14-0131 VMWARE INC CLASS A 11/14/13 OPEN 0.0000 0.0000 80.263900 2,300.00 184,607.00 0.00 0.00 184,607.00 228,528
92930Y107 11-0126 W P CAREY & CO LLC 10/06/10 OPEN 0.0000 0.0000 29.105000 900.00 26,195.00 0.00 0.00 26,195.00 59,157
92930Y107 13-0017 W P CAREY & CO LLC 05/04/12 OPEN 0.0000 0.0000 47.125200 1,500.00 70,688.00 0.00 0.00 70,688.00 98,595
969457100 14-0027 WILLIAMS COS INC 05/07/13 OPEN 0.0000 0.0000 37.490000 2,300.00 86,227.00 0.00 0.00 86,227.00 130,249
969457100 14-0244 WILLIAMS COS INC 02/05/14 OPEN 0.0000 0.0000 40.090500 1,400.00 56,126.00 0.00 0.00 56,126.00 79,282
984121103 14-0100 XEROX CORP 07/08/13 OPEN 0.0000 0.0000 9.270400 27,500.00 254,936.00 0.00 0.00 254,936.00 364,650
984121103 15-0009 XEROX CORP 05/21/14 OPEN 0.0000 0.0000 11.998700 18,500.00 221,976.00 0.00 0.00 221,976.00 245,310
5100 -FSC SECURITIES CORPORATION Total 0.0000 0.0000 0.000000 1,086,622.88 32,220,004.65 0.00 0.00 32,220,446.72 38,491,956.76
5100 - FSC SECURITIES CORPORATION Total 0.0000 0.0000 0.000000 1,086,622.88 32,220,004.65 0.00 0.00 32,220,446.72 38,491,956.76
Investment Total
50,619,838 84,232,636 (1,360,146) - 83,972,351 90,674,967
Page 7 of 7
Northbrook Economic Data
•Office, Industrial & Retail Vacancies
•Unemployment Rates
•Local Sales Tax Collections
•Hotel Market
•Housing Market
•Building Permits
October 2014
Northbrook Economic Data
October 2014
• Office, Industrial, & Retail Vacancy Rates
Central North &
Near North
Office Submarkets
Source: CoStar
Northbrook
Source: CoStar
South Lake County &
North Cook County
Industrial Submarkets
Source: CoStar
Northbrook
Source: CoStar
Overall Vacancy Rate for Northbrook Shopping Centers
16.0%
14.9%
14.0%
12.0%
10.0%
8.0%
7.0%
6.0%
5.3%
4.0%
2.0%
0.0%
2008-2Q 2008-4Q 2009-2Q 2009-4Q 2010-2Q 2010-4Q 2011-2Q 2011-4Q 2012-2Q 2012-4Q 2013-2Q 2013-4Q 2014-2Q
Source: Village of Northbrook Survey
Northbrook Economic Data
October 2014
• Unemployment Rates
Northbrook Unemployment Rate Compared to Cook County, Chicago Metro
Area and State of Illinois
12.0%
10.0%
8.0%
6.9%
6.7%
6.5% 6.5%
6.2%
6.0%
4.5%
4.2%
4.0% 4.0% 4.0%
3.2%
2.9%
2.0%
0.0%
2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 Aug-14
Northbrook Unemployment Rate Cook County Unemployment Rate
Source: IDES - LMI
Chicago Metro Area Unemployment Rate State of Illinois Unemployment Rate
Northbrook Labor Force & Employment
18,000
17,567
17,500
17,098
17,003 17,073
17,000
16,500 16,388
16,000
15,960
15,500
15,000
14,500
2004 2005 2006 2007 2008 2009 2010 2011 2012 2013
Northbrook Labor Force Northbrook Residents Employed
Source: IDES - LMI
Unemployment Rate by Area Municipalities
Not Seasonally Adjusted
Change Over Change Over
CITIES Aug-14 Jul-14 Aug-13 the Month the Year
GLENVIEW VILLAGE 4.4 4.7 6.6 -0.3 -2.2
PALATINE VILLAGE 4.4 4.9 6.7 -0.5 -2.3
WHEELING VILLAGE 4.4 5.1 6.9 -0.7 -2.5
ARLINGTON HEIGHTS VILLAGE 4.5 5.2 6.6 -0.7 -2.1
ELMHURST CITY 4.5 5.1 7.2 -0.6 -2.7
NORTHBROOK VILLAGE 4.5 5.0 6.6 -0.5 -2.1
WILMETTE VILLAGE 4.5 5.0 6.1 -0.5 -1.6
MOUNT PROSPECT VILLAGE 4.7 5.0 6.7 -0.3 -2.0
HOFFMAN ESTATES VILLAGE 4.8 5.2 7.4 -0.4 -2.6
SCHAUMBURG VILLAGE 4.8 5.3 7.4 -0.5 -2.6
NILES VILLAGE 5.0 5.8 7.8 -0.8 -2.8
MORTON GROVE VILLAGE 5.1 5.7 7.2 -0.6 -2.1
SKOKIE VILLAGE 5.2 5.6 7.8 -0.4 -2.6
EVANSTON CITY 5.3 5.7 7.6 -0.4 -2.3
DES PLAINES CITY 5.4 5.9 8.2 -0.5 -2.8
HIGHLAND PARK CITY 5.6 5.2 6.0 0.4 -0.4
BUFFALO GROVE VILLAGE 5.8 5.9 7.5 -0.1 -1.7
CHICAGO CITY 7.4 8.0 10.7 -0.6 -3.3
Source: IDES - LMI
Northbrook Economic Data
October 2014
• Local Sales Tax Collections
Village of Northbrook
Sales Tax by Calendar Month of Actual Retail Sale
Through June 2014
$1,800,000
$1,600,000
$1,400,000
$1,294,922
$1,232,939
$1,200,000 $1,129,720 $1,113,585
$976,328
$1,000,000 2011
$928,185
2012
2013
$800,000
2014
$600,000
$400,000
$200,000
$-
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Source: Village of Northbrook
Village of Northbrook
Sales Tax Change by Calendar Month of Actual Retail Sales
Difference Between 2013 & 2014
$60,000
$43,634
$40,000
$20,000 $16,292
$7,611
$-
Jan Feb Mar Apr May Jun
$(20,000)
$(40,000) $(33,864)
$(43,409)
$(60,000) Total Difference Through June
-$93,752
$(80,000)
$(84,016)
$(100,000)
Difference Between '13 & '14
Source: Village of Northbrook
Village of Northbrook
% Sales Tax Change by Calendar Month of Actual Retail Sales
Difference Between 2013 & 2014
6.0%
4.0% 3.5%
2.0% 1.5%
0.7%
0.0%
Jan Feb Mar Apr May Jun
-2.0%
-2.7%
-4.0%
-4.3%
-6.0%
% Change Through June
-8.0%
Decrease of 1.4%
-8.3%
-10.0%
% Difference '13 & '14
Source: Village of Northbrook
Northbrook Economic Data
October 2014
• Hotel Market
Hotel Revenue Per Available Room (RevPAR)
$100.00
$90.00
81.96
$80.00
$74.14
$70.00
$60.00
$50.00
$40.00
$30.00
$20.00
$10.00
$-
Jan Feb Mar Apr May Jun Jul Aug Jan Feb Mar Apr May Jun Jul Aug
2013 2014
Chicago North Shore CVB ChicagoNorth/Lake County(1) Metro Area, Excluding Chicago
Source: STR
Revenue Per Available Room (RevPar) Chicago's North Shore CVB
$100.00
$90.00
$80.00
$70.00
Revenue Per Available Room
$60.00
2011
$50.00 2012
2013
2014
$40.00
$30.00
$20.00
$10.00
$-
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Source: STR
Village of Northbrook
Hotel Tax Revenue by Calendar Quarter
$300,000
Difference Between First 6 Months
$259,015
Of 2013 & 2014
$250,000
+ $33,715
An 8.6% Increase
$200,000
$174,238 $173,475
$166,274 $164,049 2010
2011
$150,000
2012
2013
$116,970
2014
$100,000
$50,000
$-
Jan-Mar Apr-Jun Jul-Sep Oct-Dec
Note: # of rooms – Sheraton -161; Renaissance – 385; Sheraton opened Fall 2008 Source: Village of Northbrook
Northbrook Economic Data
October 2014
• Housing Market
Single Family Detached Homes - Average Sales Price First 6 Months
$1,400,000
$1,200,000 $1,174,514
$1,040,778
$1,000,000
$800,000 2010
$709,482 2011
$664,909
$628,073 2012
$601,639 $613,455 $616,072
2013
$600,000
$544,659
$520,470 $516,296 2014
$494,999
$400,000
$338,120 $341,618
$197,656 $208,256
$200,000
$-
Deerfield Glencoe Glenview Highhland Park Northbrook Northfield Prospect Heights Wheeling
Source: North Shore - Barrington Association of REALTORS
Single Family Detached Homes - Average Sales Price First 6 Months
Percentage Change From Previous Year
60.0%
50.0%
40.0%
30.0%
20.0% Deerfield
12.7% Glencoe
10.0% Glenview
Highhland Park
1%
0.0% Northbrook
-0.7% Northfield
-2.8%
-10.0% Prospect Heights
Wheeling
-20.0%
-30.0%
-40.0%
-50.0%
2011 2012 2013 2014
Source: North Shore - Barrington Association of REALTORS
Northbrook Economic Data
October 2014
• Building Permits
Northbrook Economic Data
Prepared by the Village of Northbrook
Department of Development & Planning Services
October 2014