Administration & Finance Committee
Regular MeetingNorthbrook, IL · March 11, 2014
Minutes
APPROVED
MINUTES OF A MEETING OF THE
ADMINISTRATION AND FINANCE COMMITTEE
VILLAGE OF NORTHBROOK
MARCH 11, 2014
CALL TO ORDER
Trustee Scolaro called the meeting to order at 6:20 p.m. On roll call, attending were Trustees
Scolaro, Ciesla, and Karagianis. A quorum was present. Also attending were: President Frum,
Trustee Buehler, Trustee Heller, and Trustee Israel. Staff present included Village Manager
Richard Nahrstadt, Chief Financial Officer and Deputy Village Manager Jeff Rowitz,, Director
of Public Works Kelly Hamill, Village Engineer Paul Kendzior, Assistant Public Works Director
Matt Morrison, Accounting Manager Iwona Petryszak Public; Works Project Manager Rich
Daubert, Public Works Analyst Andrew Letson, Fire Chief Mark Nolan, Fire Department
Analyst Emma Trausch, Deputy Fire Chief Tim Smeltzer, Police Chief Charles Wernick, Deputy
Police Chief Scott Dunham, Deputy Police Chief Louis Caruso, Police Department Services
Administrator Jason Batalden, Assistant Director of Development and Planning Services David
Schoon, Assistant Finance Director Betsy Garibaldi , Development and Planning Services
Analyst Mike Strong, Assistant Director of Building and Development Nick Desario,
Communications Manager Cheryl Fayne-Depersio, Human Resource Manager Greg Van Dahm
and Village Clerk Debra Ford.
HEAR FROM THE AUDIENCE
None.
DISCUSSION – FY 13/14 THIRD QUARTER FINANCIAL REPORTS
Village Manager Richard Nahrstadt said that the Village expected revenues for Fiscal Year
2013-2014 to be $850,000 over budget. Much of this is due to one-time revenues, such as
annexation fees. A $1.4 million surplus is expected for the General Fund. In FY2013-2014, the
resignation of the assistant village manager and the IT manager provided the opportunity to
reorganize certain functions. The position of deputy village manager/chief financial officer was
created. Also, a new Information Services Department has been created to provide a greater
emphasis on technology. The department will be led by a Chief Information Officer, who will
report directly to the Village Manager. Also, a half-time position in the General Government
Department became full-time, and a personal computer (PC) technician position is being filled in
the Information Services Department.
PRESENTATION & DISCUSSION OF FY 14/15 DRAFT BUDGET
Deputy Village Manager and Chief Financial Officer Jeff Rowitz said that the Village
projects a $282,930 General Fund surplus for Fiscal Year 2014-2015. It expects to end Fiscal
Year 2014-2015 with an estimated General Fund balance that is $1.2 million over the 40 percent
set by Village policy as a reserve fund. In December, the Village levied a property tax increase
of $260,000 for its General Fund in order to provide the Board with flexibility heading into the
budget. At that time, the Board stated the goal of abating this increase during the budget process.
The draft budget meets that goal and allows the Village Board to fully abate the increase.
Village Manager Nahrstadt said that the Village’s operating expenditures projected for
FY2014-2015 are within 0.5 percent of those projected one year ago. The Village expects to run
a General Fund surplus of approximately $40,000 in FY 2015-2016.
The proposed FY2014-2015 budget includes funding to fill one of the two police officer
positions which had been held vacant, and projects filling the other vacant position in FY 2015-
16. The FY 2014-15 draft budget also includes adding a structural building inspector in
Development & Planning Services, a project manager in Public Works, and an engineering
technician assigned to the Storm Water Fund.
Trustee Scolaro said that the salary and benefit estimates normally come in under budget
because the Village does not fill positions immediately when a person resigns. He said that in
general, the Village budgets for full employment for every position for the entire year. It also
budgets its revenues slightly conservatively, so it is not harmed if revenues fall short of
projection
CFO Jeff Rowitz said that the proposed budget for FY2014-2015 includes $18.5 million in
capital projects. He explained that $12.9 million will be funded with bond proceeds with,$4.3
million being repaid from water usage charges, $2.3 million will be paid from sanitary sewer
usage charges, $3.2 million will be paid from stormwater usage charges, and $3.1 million will be
backed by property tax revenues.
The proposed capital projects include eleven stormwater management projects.
Public Works Director Kelly Hamill briefly reviewed the street maintenance projects
included in the 2014-2015 capital budget. Village Manager Richard Nahrstadt said that the
proposed 2014-2015 budget does not include funds for the second phase of work at the
intersection of Dundee Road and Skokie Boulevard.
Village Manager Nahrstadt said that the budget includes funds that could be spent on a study
regarding the provision of parking downtown. He said that merchants complain that on-street
parking is insufficient. President Frum said that putting the money in the budget to pay for a
parking study does not mean that the Village will necessarily spend the money. Village Manager
Nahrstadt said that a discussion of downtown parking would be scheduled for an upcoming
Committee of the Whole meeting where the Board can determine whether further study is
necessary
Public Works Director Kelly Hamill then reviewed the traffic signal improvements for the
intersection of Sanders Road and Lindenwood Lane that are included in the proposed 2014-2015
budget. The Village is responsible for 50 percent of the construction cost of this project.
Director Hamill then reviewed the capital projects funded by the Water Fund. A 20 percent
rate hike is planned for FY2014-2015. The vast majority of this increase is to fund debt service
for capital improvements. Director Hamill said that the Village’s water plant is aging. Water
main replacement is now on a 140-year replacement cycle. Village Manager Nahrstadt said that
in the past the Village has tried to accelerate the pace of replacement. He said that a 20 percent
rate hike is proposed every two years for the next ten years. President Frum said that the Village
may wish to pursue new customers, in part because the biggest users of water in Northbrook are
now using ponds and other sources to irrigate. This is in keeping with the recent emphasis on
water conservation. Village Manager Nahrstadt said that the Village of Northbrook currently
sells water to the Village of Riverwoods. The Village of Wauconda and others have inquired
about becoming customers. If the Village wants to sell water to other towns, it must make some
decisions regarding capacity. Trustee Buehler said that the Village could consider subsidizing
water service with proceeds from the General Fund or other funds. Trustee Ciesla asked if the
Village should instead consider simply buying water from other towns. Trustee Israel said that
the Village has access to Lake Michigan water. Could it privatize this? President Frum said that
the Village should discuss its water issues over the long term. Nothing has to be decided tonight.
Chief Financial Officer Jeff Rowitz said that the proposed water rate increase would raise the
price of 1,000 gallons of water from $4.08 to $4.90. Of the 82-cent increase, 66 cents will go to
pay for debt service and capital expenditures. Public Works Director Kelly Hamill said that the
minimum water bill (based on 7,000 gallons of water used per quarter) will go up $5.74 per
quarter as a result of the water rate increase. He said that the sanitary sewer rate, which is slated
to rise by 25 cents per 1,000 gallons in FY2014-2015, has not been raised since 2004. Trustee
Ciesla asked if the Village could consider a separate water rate for business customers. Public
Works Director said it may be possible, but that water rates traditionally have been based on
usage, i.e., a charge per 1,000 gallons used. Trustee Ciesla said that homeowners will eventually
pay more because businesses are using less water. Public Works Director Hamill said that usage
is also falling among residential properties. President Frum said that she does not want to drive
businesses out of Northbrook. Village Manager Nahrstadt suggested that the Village Board meet
in May to discuss the water issue. The Committee then discussed the need to plan now for what
may be a policy shift in Fiscal Year 2015-2016. As Northbrook’s population ages, the planned
20 percent increases may become more burdensome. It was recommended that different
methods of securing and pricing water be investigated.
Trustee Ciesla moved, seconded by Trustee Karagianis, to direct staff to prepare the budget
as discussed by the Committee for Village Board approval at the April 8, 2014 regular meeting.
The motion passed by a voice vote.
ADJOURN
At 7:25 p.m., Trustee Ciesla, seconded by Trustee Karagianis, moved to adjourn the meeting.
The motion passed by a voice vote.
Respectfully submitted,
Christine Martin
Recording Secretary
Agenda
ADMINISTRATION & FINANCE COMMITTEE
NORTHBROOK VILLAGE HALL, 1225 CEDAR LANE
MARCH 11, 2014, 6:15 P.M., TERRACE ROOM
The Administration & Finance Committee of the Village of Northbrook Board of Trustees will hold a
meeting on Tuesday, March 11, 2014 at 6:15 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. DISCUSSION – FY 13/14 THIRD QUARTER FINANCIAL REPORTS
4. PRESENTATION & DISCUSSION OF FY 14/15 DRAFT BUDGET
5. ADJOURN
Michael Scolaro, Chair
Administration/Finance Committee
Members: Trustee Karagianis
Trustee Ciesla
Village of Northbrook
Cook County, Illinois
February 21, 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 (847-
664-4014 and 847-664-4013, respectively) 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.
MEMORANDUM
TO: Richard A. Nahrstadt, Village Manager
FROM: Jeffrey L. Rowitz, Deputy Village Manager/Chief Financial Officer
DATE: February 28, 2014
RE: FY 2013/14 Third Quarter Financial Reports
Attached please find the General Fund revenue and expense reports for the third quarter budget
review. These reports show budgeted and actual results for the third quarter as well as staff’s current
projections for the remainder of the fiscal year.
The FY 2013/14 budget projected a General Fund surplus for the year of $444,200. As shown in the
attached schedules, we are currently projecting the General Fund surplus to be $1.45 million. The
material differences are described below.
Revenues
We currently estimate that revenues will be $850,000 higher than budget. Sales taxes are projected to
be 4% under budget, due primarily to summer road construction on Lake Cook and Willow Roads and
the closing of the Dominick’s store at the end of December. Higher than expected revenues from
building permits, utility taxes, hotel taxes, telecom taxes, and annexation fees received from the Village
of Glenview for development on the Culligan property, more than offset the sales tax variance.
Expenses
Expenditures are anticipated to be $195,000 less than planned. Most of this savings is attributed to
salaries and benefits due to staff turnover.
Village of Northbrook
General Fund Revenue Projections
Fiscal Year 2014 - Third Quarter
January 31, 2014
Projected
Third Quarter Third Quarter Over (Under)
Account FY 2012/13 YTD YTD FY13/14 FY13/14 Budget
Number Actual Budget Actual Budget Estimate $ %
Property Taxes 401-00/11 7,685,720 3,441,130 3,893,479 7,820,750 7,820,750 0 0.00%
Township Road and Bridge Tax 401-06/16 456,927 167,200 213,992 380,000 420,000 40,000 10.53%
Replacement Taxes
Corporate 405-01 364,466 223,300 305,877 385,000 385,000 0 0.00%
Township Road and Bridge 405-03 11,143 0 0 12,500 12,500 0
Total Replacement Taxes 375,609 223,300 305,877 397,500 397,500 0 0.00%
Sales Tax
Retail Sales Tax 421-00/04 12,344,249 9,109,760 8,886,707 12,652,445 12,105,000 (547,445) -4.33%
Auto Rental Tax 421-01 11,946 8,995 8,352 12,000 12,000 0 0.00%
Use Tax 421-03 525,915 402,855 404,449 537,355 553,940 16,585 3.09%
Total Sales Tax 12,882,110 9,521,610 9,299,508 13,201,800 12,670,940 (530,860) -4.02%
Income Tax
State Income Tax 422-00 3,111,609 2,372,360 2,579,189 3,164,415 3,207,500 43,085 1.36%
Total Income Taxes 3,111,609 2,372,360 2,579,189 3,164,415 3,207,500 43,085 1.36%
Projected
Third Quarter Third Quarter Over (Under)
Account FY 2012/13 YTD YTD FY13/14 FY13/14 Budget
Number Actual Budget Actual Budget Estimate $ %
Other Taxes
Hotel/Motel Occupancy Tax 407-01 785,140 562,500 589,269 750,000 800,000 50,000 6.67%
Utility Tax 407-03/04 1,124,312 787,185 772,315 1,050,000 1,100,000 50,000 4.76%
Telecommunications Tax 478-06 1,041,003 1,874,250 2,858,452 2,500,000 3,600,000 1,100,000 44.00%
Admissions/Entertainment Tax 407-02 114,267 82,465 81,711 110,000 110,000 0 0.00%
Total Other Taxes 3,064,722 3,306,400 4,301,747 4,410,000 5,610,000 1,200,000 27.21%
Permits
Building 452-00 1,550,035 824,670 1,350,979 1,100,000 1,500,000 400,000 36.36%
Alarm 454-03 4,050 5,175 3,695 7,500 4,500 (3,000) -40.00%
Total Permits 1,554,085 829,845 1,354,674 1,107,500 1,504,500 397,000 35.85%
Licenses
Animal 435-01 21,522 21,500 22,137 21,500 22,500 1,000 4.65%
Business/Liquor 435-02/04 313,236 222,450 271,735 335,000 335,000 0 0.00%
Vehicle 435-05 583,659 585,000 568,625 585,000 575,000 (10,000) -1.71%
Total Licenses 918,417 828,950 862,497 941,500 932,500 (9,000) -0.96%
Interest Income
General Fund 426-01/02/04 41,769 74,970 19,911 100,000 50,000 (50,000) -50.00%
Property Tax 426-09/19 110 1,125 89 1,500 1,500 0 0.00%
Total Interest Income 41,879 76,095 20,000 101,500 51,500 (50,000) -49.26%
Fees:
RFPD Fees 451-00 2,420,839 1,245,500 1,210,420 2,491,000 2,491,000 0 0.00%
RED Center Administration Fees 451-01 18,500 0 0 20,000 20,000 0 0.00%
Elevator Inspections 452-01 50,610 28,875 16,965 52,200 52,500 300 0.57%
Franchise Fees:
Cable Television 478-01 635,585 479,810 510,717 640,000 650,000 10,000 1.56%
Total Franchise Fees 635,585 479,810 510,717 640,000 650,000 10,000 1.56%
Alarm Services Fees:
Police Alarms 454-00/01/02 115,907 85,170 97,955 135,000 135,000 0 0.00%
Fire Alarms 459-00/01 73,346 50,230 50,894 67,000 73,500 6,500 9.70%
Total Alarm Services Fees 189,253 135,400 148,849 202,000 208,500 6,500 3.22%
Projected
Third Quarter Third Quarter Over (Under)
Account FY 2012/13 YTD YTD FY13/14 FY13/14 Budget
Number Actual Budget Actual Budget Estimate $ %
Petitioner Fees:
Plan Commission 457-00 17,957 14,995 9,286 20,000 20,000 0 0.00%
Zoning Board of Appeals 479-00 0 3,750 0 5,000 0 (5,000) -100.00%
Total Petitioner Fees 17,957 18,745 9,286 25,000 20,000 (5,000) -20.00%
Total Fees 3,332,744 1,908,330 1,896,237 3,430,200 3,442,000 11,800 0.34%
Rental Income:
Commuter Station:
The Grind 461-05 6,981 5,250 5,651 7,000 7,000 0 0.00%
Total Rental Income 6,981 5,250 5,651 7,000 7,000 0 0.00%
Fines:
Ordinance Violations 458-01/04 52,270 37,485 59,837 50,000 85,000 35,000 70.00%
Traffic Court Fines 458-02 156,036 119,950 111,338 160,000 160,000 0 0.00%
Total Fines 208,306 157,435 171,174 210,000 245,000 35,000 16.67%
Projected
Third Quarter Third Quarter Over (Under)
Account FY 2012/13 YTD YTD FY13/14 FY13/14 Budget
Number Actual Budget Actual Budget Estimate $ %
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
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:17 54,323 29,990 57,616 40,000 60,000 20,000 50.00%
GIS Service Fees 473-21 0 750 0 1,000 0 (1,000) -100.00%
Antenna Lease Fees 476-01 224,473 159,360 216,292 218,300 218,300 0 0.00%
Weed Cutting/Tree Removal Fees 477-02/05 216 750 0 1,000 200 (800) -80.00%
Sign Material Sales 477-06 0 750 665 1,000 665 (335) -33.50%
Reforestation Fees 477-07 15,350 7,500 9,875 10,000 20,000 10,000 100.00%
IDOT Signal Maintenance Fees 477-10 0 1,875 0 2,500 0 (2,500) -100.00%
Toll Road Responses-Fire/EMS 477-31/32 3,150 15,000 700 20,000 3,500 (16,500) -82.50%
Ambulance Transportation Fee 480-02 1,000,163 674,730 693,602 900,000 900,000 0 0.00%
Glenbrook North Police Service 480-03 102,787 105,000 104,601 105,000 115,690 10,690 10.18%
Summer School Crossing Guards 480-04 5,864 3,750 6,313 5,000 6,310 1,310 26.20%
Training Fees (Police/Fire) 480-21/31 0 3,750 0 5,000 0 (5,000) -100.00%
Total Charges for Services 1,406,326 1,003,205 1,089,664 1,308,800 1,324,665 15,865 1.21%
Projected
Third Quarter Third Quarter Over (Under)
Account FY 2012/13 YTD YTD FY13/14 FY13/14 Budget
Number Actual Budget Actual Budget Estimate $ %
Miscellaneous:
Surplus Equipment Sales 473-03 35,882 44,980 26,059 60,000 40,000 (20,000) -33.33%
Retail Sale Permits 473-06 7,295 7,495 5,550 10,000 10,000 0 0.00%
Miscellaneous Income
473-07/09/18/20/22/25/29/35, 480-06, 482-16/18, 455-01,477-01/04/33322,415
52,307 694,045 430,050 725,000 294,950 68.59%
Grants 481-15/17/18/26/31 21,689 0 82,924 0 22,860 22,860
Court-Ordered DUI Reimbursements 473-08 - 750 0 1,000 0 (1,000) -100.00%
Raffle/Facility Use Fees 473-10 360 110 450 150 500 350 233.33%
Frontage Deposit Fees 473-11 1,185 1,125 200 1,500 500 (1,000) -66.67%
State Route Maintenance 475-04 17,524 14,995 11,949 20,000 20,000 0 0.00%
Traffic Signal/Street Light Damage 477-03/04 8,187 3,750 10 5,000 5,000 0 0.00%
Impound Fees 477-08 480 750 310 1,000 1,000 0 0.00%
Miscellaneous Reimbursements 477-09 27,805 3,750 0 5,000 5,000 0 0.00%
Annexation Fees 480-19 59,618 118,080 33,508 157,500 102,500 (55,000) -34.92%
Bond Proceeds 406-02 275,000 1,456,100 1,225,627 1,456,100 1,225,626 (230,474) -15.83%
Total Miscellaneous 507,332 1,974,300 2,080,632 2,147,300 2,157,986 10,686 0.50%
TOTAL GENERAL CORPORATE FUND 38,046,517 28,252,895 30,511,805 41,065,750 42,229,326 1,163,576 2.83%
Village of Northbrook
General Corporate Fund
Expenditure Summary By Department (Without Special Revenue Funds)
FY 2013/14 - Third Quarter
January 31, 2014
Projected
Third Quarter Third Quarter FY13/14 Over (Under)
YTD YTD Amended FY13/14 Budget
Budget Actual Budget Estimate $ % Reason
LEGISLATIVE
Personal Services 31,040 30,900 41,400 41,400 - 0.00%
Fringe Benefits 2,325 2,363 3,100 3,150 50 1.61%
Contractual Services 220,185 228,861 266,130 253,780 (12,350) -4.64%
Total 253,550 262,124 310,630 298,330 (12,300) -3.96%
ADMINISTRATIVE
Personal Services 1,033,760 981,674 1,397,070 1,227,220 (169,850) -12.16% Full time GIS position eliminated
through attrition and increased use
of contractual services.
Fringe Benefits 378,125 354,369 449,880 406,500 (43,380) -9.64% Full time GIS position eliminated
through attrition.
Contractual Services 600,160 504,569 780,100 800,400 20,300 2.60% Increased contractual services for
GIS.
Commodities 3,560 6,845 4,750 7,500 2,750 57.89%
Capital Outlay 636,495 15,744 849,000 849,000 - 0.00% Timing of ERP
Total 2,652,100 1,863,201 3,480,800 3,290,620 (190,180) -5.46%
Total w/o Capital 2,015,605 1,847,457 2,631,800 2,441,620 (190,180) -7.23%
LEGAL
Contractual Services 438,875 411,903 585,400 635,400 50,000 8.54%
Total 438,875 411,903 585,400 635,400 50,000 8.54%
FINANCE
Restructuring of finance and general
Personal Services 566,170 580,640 756,950 742,165 (14,785) -1.95% government departments
Fringe Benefits 240,940 233,346 280,910 275,585 (5,325) -1.90%
Projected
Third Quarter Third Quarter FY13/14 Over (Under)
YTD YTD Amended FY13/14 Budget
Budget Actual Budget Estimate $ % Reason
Contractual Services 169,100 181,950 206,790 211,890 5,100 2.47%
Commodities 19,940 19,364 26,600 21,600 (5,000) -18.80%
Capital Outlay 1,500 6,204 2,000 8,000 6,000 300.00%
Total 997,650 1,021,504 1,273,250 1,259,240 (14,010) -1.10%
Total w/o Capital 996,150 1,015,300 1,271,250 1,251,240 (20,010) -1.57%
POLICE
Personal Services 7,141,330 7,147,035 9,610,650 9,760,740 150,090 1.56% OT pay, including reclaim time bank
payouts, is greater than expected
due to turnover.
Fringe Benefits 1,737,540 1,748,868 1,902,995 1,895,495 (7,500) -0.39%
Contractual Services 1,208,240 1,114,985 1,418,655 1,422,425 3,770 0.27%
Commodities 414,830 296,211 553,325 498,715 (54,610) -9.87%
Capital Outlay 601,177 182,526 704,100 618,400 (85,700) -12.17% E-ticketing project delayed due to
implementation decisions made by
the County. E-crash software project
delayed due to a vendor decision to
wait to roll out software for Illinois.
Firehouse Cloud (E911) project was
deferred.
Total 11,103,117 10,489,625 14,189,725 14,195,775 6,050 0.04%
Total w/o Capital 10,501,940 10,307,099 13,485,625 13,577,375 91,750 0.68%
FIRE
Personal Services 5,683,470 5,600,565 7,877,555 7,822,765 (54,790) -0.70% Temporary vacancies due to
turnover.
Fringe Benefits 1,413,090 1,399,592 1,467,685 1,460,005 (7,680) -0.52%
Contractual Services 1,154,905 1,071,936 1,326,715 1,328,325 1,610 0.12%
Commodities 374,020 310,291 452,890 453,410 520 0.11%
Capital Outlay 52,480 15,809 10,000 10,000 - 0.00%
Total 8,677,965 8,398,192 11,134,845 11,074,505 (60,340) -0.54%
Total w/o Capital 8,625,485 8,382,383 11,124,845 11,064,505 (60,340) -0.54%
Projected
Third Quarter Third Quarter FY13/14 Over (Under)
YTD YTD Amended FY13/14 Budget
Budget Actual Budget Estimate $ % Reason
PUBLIC WORKS
Personal Services 2,431,150 2,409,579 3,320,570 3,333,625 13,055 0.39% Above average number of snow ice
control events during the 2013/14
season resulting in more overtime
being incurred. Most operations
occurred at night, on weekends, or
on holidays. YTD actual is not as
high as expected as about $178,000
worth of overtime hours were
accumulated as PTO and not paid
out.
Fringe Benefits 1,041,610 1,005,053 1,248,870 1,225,480 (23,390) -1.87% Retirement of Administrative
Assistant, position vacant for
roughly three months. Position
reclassified to Administrative Clerk
at a lower pay rate.
Contractual Services 1,512,270 1,218,208 1,857,550 1,745,740 (111,810) -6.02% Savings on HVAC maintenance
contract and anticipated savings on
downtown streetscape/landscape
improvements.
Commodities 530,980 450,959 711,250 838,300 127,050 17.86% Increase in parts and materials
purchases attributable to repairs at
Fire Station 11 and Police Station,
materials for street and pothole
repairs, sand to be mixed with salt,
and parts for Village snow plow
fleet.
Projected
Third Quarter Third Quarter FY13/14 Over (Under)
YTD YTD Amended FY13/14 Budget
Budget Actual Budget Estimate $ % Reason
Capital Outlay 535,636 192,794 852,120 845,975 (6,145) -0.72% An assessment of Public Works
Roof showed that replacement at
this time was not needed. Budgeted
funds were used to complete two
smaller projects (PW Mechanicals
Screening and hatch installation,
HVAC replacement at FS 10 and
12) at a lower cost. Some minor
savings on two vehicles purchased
before September.
Total 6,051,646 5,276,594 7,990,360 7,989,120 (1,240) -0.02%
Total w/o Capital 5,516,010 5,083,799 7,138,240 7,143,145 4,905 0.07%
DEVELOPMENT & PLANNING
Personal Services 732,990 748,514 1,000,265 1,008,455 8,190 0.82% Increased hours for part-time
employee to cover extended medical
absence of full-time employee.
Fringe Benefits 432,085 414,755 489,695 487,160 (2,535) -0.52%
Contractual Services 405,775 455,977 504,960 530,953 25,993 5.15% Increased contractual services for
building inspections. -
Commodities 2,585 4,470 3,450 4,550 1,100 31.88%
Capital Outlay 1,425 - 1,900 1,400 (500) -26.32%
Total 1,574,860 1,623,716 2,000,270 2,032,518 32,248 1.61%
Total w/o Capital 1,573,435 1,623,716 1,998,370 2,031,118 32,748 1.64%
Projected
Third Quarter Third Quarter FY13/14 Over (Under)
YTD YTD Amended FY13/14 Budget
Budget Actual Budget Estimate $ % Reason
ALL DEPARTMENTS
Total 31,749,763 29,346,858 40,965,280 40,775,508 (189,772) -0.46%
Total w/o Capital 29,228,625 28,259,755 38,546,160 38,442,733 (141,127) -0.37%
TOTAL BY CLASS
Personal Services 17,619,910 17,498,908 24,004,460 23,936,370 (68,090) -0.28%
Fringe Benefits 5,245,715 5,158,345 5,843,135 5,753,375 (89,760) -1.54%
Contractual Services 5,709,510 5,188,388 6,946,300 6,928,913 (17,387) -0.25%
Commodities 1,345,915 1,088,141 1,752,265 1,824,075 71,810 4.10%
Capital Outlay 1,828,713 413,077 2,419,120 2,332,775 (86,345) -3.57%
31,749,763 29,346,858 40,965,280 40,775,508 (189,772) -0.46%
PROJECTED REVENUES 41,246,550 42,229,326 982,776 2.38%
SURPLUS / (DEFICIT) BEFORE EQUITY TRANSFERS 281,270 1,453,818
EQUITY TRANSFERS OUT 1,200,000 1,200,000
SURPLUS / (DEFICIT) INCLUDING EQUITY TRANSFERS (918,730) 253,818
PROJECTED FUND BALANCE 17,138,882 18,311,430
Fund Balance as a % of Revenue 41.6% 43.4%
Fund Balance as a % of Expense 41.8% 44.9%
Fund Balance above 40% policy 640,262 1,419,700
Village of Northbrook
Comparative Sales Tax Collections
Fiscal Year 2013/14
GAAP Basis
Liability Collection Disbursement Budgeted
Month Month Month 2009-10 2010-11 2011-12 2012-13 2013-14 Amount
Feb Mar May 865,582 885,373 993,014 1,012,201 1,034,800
Mar Apr Jun 1,085,532 1,142,555 1,179,767 1,179,072 1,205,400
Apr May July 967,598 1,013,811 1,082,343 1,122,109 1,097,293 1,147,150
May Jun Aug 988,707 1,078,377 1,193,929 1,204,629 1,266,803 1,231,300
Jun Jul Sep 1,135,466 1,153,113 1,258,768 1,333,790 1,251,288 1,363,560
Jul Aug Oct 969,579 1,038,674 1,022,824 1,059,683 1,120,681 1,063,525
Aug Sep Nov 1,039,981 1,040,610 1,147,063 1,189,263 1,193,600 1,220,800
Sep Oct Dec 1,123,137 1,118,357 1,183,982 1,304,942 1,203,212 1,334,100
Oct Nov Jan 1,026,086 1,055,850 1,081,807 1,178,118 1,159,309 1,204,400
Nov Dec Feb 1,024,897 1,145,298 1,183,531 1,307,382 1,203,020 1,341,560
Dec Jan Mar 1,469,248 1,545,773 1,702,654 1,707,000 1,745,100
Jan Feb Apr 870,366 942,125 975,448 1,019,737 1,052,500
$ 12,566,178 $ 13,159,916 $ 14,005,130 $ 14,617,926 9,495,205 14,944,195
2013/14 Budgeted Sales Tax Revenue $ 14,944,195
Percent Collected 63.54%
Current Year Projection Based Upon Recent Trends $ 14,360,050
Over (Under) Budget $ (584,145)
Percentage Over (Under) Budget (3.91)%
Fiscal Year Sales Tax Receipts by Month
GAAP Basis
$1,400,000
$1,300,000
$1,200,000
$1,100,000
$1,000,000
$900,000 FY 09/10
$800,000 FY 10/11
$700,000 FY 11/12
$600,000 FY 12/13
$500,000 FY 13/14
$400,000
$300,000
$200,000
$100,000
$0
July Aug Sep Oct Nov Dec Jan Feb
Budget to Actual Sales Tax Collections
FY 2013/14 - GAAP Basis
$1,500,000
$1,400,000
$1,300,000
$1,200,000
$1,100,000
$1,000,000
$900,000
$800,000
$700,000 Budget
$600,000 Actual
$500,000
$400,000
$300,000
$200,000
$100,000
$0
July Aug Sep Oct Nov Dec Jan Feb
February sales tax receipts were $138,540 below budget. The February
receipts reflect sales made in November.
Sales Tax by Standard Industrial Code
1st Three Calendar Quarters
$2,000,000
$1,800,000
$1,600,000
$1,400,000
$1,200,000 2007
$1,000,000
$800,000 2008
$600,000
$400,000 2009
$200,000
$0 2010
2011
2012
2013
Sales Tax Receipts
Last 18 Months
$1,800,000
September 2012 - February 2014
$1,600,000
$1,400,000
$1,200,000
$1,000,000
$800,000 Budget
Actual
$600,000
$400,000
$200,000
$0
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 2,599.87 3,002.62
Total General Government 95.43 67.50 - 50.61 2,504.44 2,884.51 - - 2,599.87 3,002.62
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 4,292.56 9,269.15
- -
Total Finance Department 2,747.50 3,881.62 617.27 4,352.60 2,838.98 2,452.11 - - 6,203.75 10,686.33
Police Department
Roll call 31,179.72 32,612.58 31,382.23 32,077.65 31,386.63 32,109.22 93,948.58 96,799.45 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 69,595.46 70,647.52 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 69,349.26 42,380.35 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 93,434.97 105,921.45 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 94,084.30 101,124.73 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 60,562.64 53,758.49
Private details (reimbursable) 3,755.03 7,239.88 15,807.67 16,714.66 6,393.36 3,933.22 25,956.06 27,887.76
Court time 23,631.37 22,943.28 26,537.54 25,817.09 25,639.08 26,683.68 75,807.99 75,444.05
Minimum manning 44,909.08 75,117.18 37,716.34 37,895.70 57,593.13 53,463.03 140,218.55 166,475.91 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.
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 6,679.14 4,306.57 Includes National Night Out and
other community events.
4th of July 12,038.72 13,103.44 247.10 - - - 12,285.82 13,103.44
NIPAS/NORTAF 4,303.67 16,144.66 9,749.22 15,544.92 15,725.03 7,321.87 29,777.92 39,011.45
Total Overtime Worked 239,949.17 306,867.84 245,198.96 272,724.65 309,695.31 242,835.33 - 794,843.44 822,427.82
LESS: Hours accumulated as PTO (70,494.02) (90,923.51) (63,683.22) (82,178.00) (93,911.55) (85,978.92) (228,088.79) (259,080.43)
Overtime Paid Out 169,455.15 215,944.33 181,515.74 190,546.65 215,783.76 156,856.41 - - 566,754.65 563,347.39
Fire Department
FLSA 6,867.00 8,905.00 7,682.00 6,887.00 7,946.00 9,269.00 22,495.00 25,061.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.
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
Shift holdover 5,718.00 5,267.00 4,579.00 4,626.00 7,100.00 4,718.00 17,397.00 14,611.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 27,787.00 12,884.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,735.00 2,573.00 3,191.00 6,884.00 6,679.00 22,486.00 12,605.00 31,943.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 33,974.00 37,602.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 225,709.00 233,151.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 4,496.00 1,450.00
Open house - 1,587.00 735.00 0 1,587.00 735.00
Northbrook Days 816.00 5,759.00 466.00 0 5,759.00 1,282.00
4th of July 1,267.00 784.00 - 0 1,267.00 784.00
Total Overtime Worked 133,831.00 118,070.00 140,224.00 69,896.00 79,021.00 171,537.00 - - 353,076.00 359,503.00
LESS: Hours accumulated as PTO (14,795.00) (14,847.00) (22,048.00) (20,833.00) (16,541.00) (16,398.00) (53,384.00) (52,078.00)
Overtime Paid Out 119,036.00 103,223.00 118,176.00 49,063.00 62,480.00 155,139.00 - - 299,692.00 307,425.00
Public Works
Streets & sidewalks 505.75 4,660.04 39.81 1,369.83 2,039.78 1,269.92 2,585.34 7,299.79
The Village had 22 snow and ice
control events in the 3rd Quarter.
The average for a season is 19-20.
Additionally, the majority of the
operations have occurred at night,
Snow & Ice control 26.39 - 4,200.60 - 26,512.29 222,121.98 30,739.28 222,121.98 on weekends, or on holidays.
Parkway & street lights 1,258.61 410.02 176.15 410.01 600.16 540.70 2,034.92 1,360.73
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
Storm sewer 1,594.52 5,471.41 1,182.06 1,018.33 1,666.51 3,712.94 4,443.09 10,202.68
Sanitary sewer 3,599.35 4,246.41 3,314.85 2,834.08 3,037.07 1,973.13 9,951.27 9,053.62
Village building 336.87 1,069.41 1,744.23 959.91 410.63 2,679.49 2,491.73 4,708.81
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 4,259.66 3,329.20 in service.
Water Production & Dist. 27,922.17 13,729.74 16,145.31 15,919.21 17,985.45 18,801.73 62,052.93 48,450.68
Water main breaks 56,042.46 2,392.94 19,879.65 9,434.62 42,274.02 22,620.21 118,196.13 34,447.77 With the repeated cycles of
extreme cold followed by heavy
snows, we saw an increase in the
number of main breaks in the 3rd
Quarter of FY 12/13.
JULIE Locates 2,393.07 3,281.19 2,112.24 2,115.54 1,954.57 1,788.47 6,459.88 7,185.20
Engineering plan review & insp. 2,038.24 2,429.57 4,920.89 1,893.48 365.97 1,276.82 7,325.10 5,599.87
Northbrook Days 0.00 - - - - -
Family Dinner - 1,183.23 - 1,802.46 1,183.23 1,802.46
Earth Day 4,763.93 - - - 4,763.93 -
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 15,451.81 15,924.29
Trees & storm damage 1,457.91 2,899.72 580.74 2,659.99 1,637.87 1,516.11 3,676.52 7,075.82
Total Overtime Worked 111,452.24 53,885.90 62,737.25 44,638.83 103,664.54 288,081.57 - - 277,854.03 386,606.30
LESS: Hours accumulated as PTO (33,950.24) (18,718.11) (19,861.56) (17,797.83) (50,730.35) (141,439.57) (104,542.15) (177,955.51)
Overtime Paid Out 77,502.00 35,167.79 42,875.69 26,841.00 52,934.19 146,642.00 - - 173,311.88 208,650.79
General Fund 18,790.47 16,661.72 18,391.24 9,037.00 25,386.57 89,021.00 62,568.28 114,719.72
Water Fund 50,313.53 14,012.75 19,920.50 14,327.00 24,082.90 45,211.00 94,316.93 73,550.75
Sewer Fund 6,219.00 4,196.05 1,472.54 3,329.00 3,226.03 6,525.00 10,917.57 14,050.05
Storm Water Fund 2,179.00 297.27 1,908.18 148.00 1,421.92 5,885.00 5,509.10 6,330.27
77,502.00 35,167.79 41,692.46 26,841.00 54,117.42 146,642.00 - - 173,311.88 208,650.79
Development & Planning Services
Regular overtime 452.11 2,363.43 476.66 1,683.92 1,594.80 463.55 2,523.57 4,510.90
Total Dev. & Planning Services 452.11 2,363.43 476.66 1,683.92 1,594.80 463.55 - - 2,523.57 4,510.90
GRAND TOTAL 369,288.19 360,647.67 343,661.36 272,537.78 338,136.17 464,437.58 - - 1,051,085.72 1,097,623.03
VILLAGE OF NORTHBROOK
Effective Interest - Actual Life
Receipts in Period
1/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 9,980,290.00 9,980,290.00 0.00 9,980,290 9,980,290
CASH - E-PAY 0.0150 1,533,395.00 1,533,395.00 1,533,395 1,533,395
CASH - DISBURSEMENT 0.0150 2,466,371.00 2,466,371.00 2,466,371 2,466,371
CASH - SENIOR HOUSING 0.0150 64,515.00 64,515.00 0.00 0.00 64,515 64,515
CASH - SENIOR HOUSING SECURITY DEPOSITIS 0.0150 96,847.00 96,847.00 96,847 96,847
CASH - MFT 0.0150 772,320.00 772,320.00 772,320 772,320
CASH - E-911 0.0150 124,705.00 124,705.00 124,705 124,705
CASH - DRUG FORFEITURE 0.0150 10,130.00 10,130.00 10,130 10,130
1300 - THE ILLINOIS FUNDS Total 15,048,573.00 15,048,573.00 0.00 0.00 15,048,573 15,048,573
1300 - THE ILLINOIS FUNDS Total 15,048,573.00 15,048,573.00 0.00 0.00 15,048,573 15,048,573
2100 - IMET (IL Metropolitan Inv Fun 366006017 AR-0009 IMET 10/06/97 Open 0.2900 7,495,875.00 7,495,875.00 0.00 0.00 7,495,875 7,495,875
366006017 AR-0011 IMET 09/30/98 Open 0.2900 1,507,387.00 1,507,387.00 0.00 0.00 1,507,387 1,507,387
366006017 AR-0012 IMET 09/30/98 Open 0.2900 1,507,387.00 1,507,387.00 0.00 0.00 1,507,387 1,507,387
2100 - IMET (IL Metropolitan Inv Fun Total 10,510,649.00 10,510,649.00 0.00 0.00 10,510,649 10,510,649
2100 - IMET (IL Metropolitan Inv Fun Total 10,510,649.00 10,510,649.00 0.00 0.00 10,510,649 10,510,649
4600 - NORTHBROOK BANK & TRUST 8100009643 MAXSAFE TM PUBLIC 10/20/11 OPEN 0.2000 3,520,231.00 3,520,231.00 0.00 0.00 3,520,231 3,520,231
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,538,444.00 4,538,444.00 0.00 0.00 4,538,444 4,538,444
7500014368 AR-0029 MONEY MARKET 07/08/08 OPEN 0.0800 2,646,418.00 2,646,418.00 0.00 0.00 2,646,418 2,646,418
CASH - PAYROLL 0.0000 0.00 0.00 0.00 0.00 - -
CASH - SENIOR HOUSING 0.0300 1,589,604.00 1,589,604.00 0.00 0.00 1,589,604 1,589,604
CASH - ANGEL 0.0300 21,540.00 21,540.00 0.00 0.00 21,540 21,540
CASH - DISBURSEMENT 0.0000 82.00 82.00 0.00 0.00 82 82
4600 - NORTHBROOK BANK & TRUST Total 16,816,319.00 16,816,319.00 0.00 0.00 16,816,319.00 16,816,319.00
4600 - NORTHBROOK BANK & TRUST Total 16,816,319.00 16,816,319.00 0.00 0.00 16,816,319.00 16,816,319.00
5000 - FIRST BANK OF HIGHLAND PARK 53000916 AR-0028 MONEY MARKET 02/08/07 Open 0.4000 2,244,417.00 2,244,417.00 0.00 0.00 2,244,417 2,244,417
5000 -FIRST BANK OF HIGHLAND PARK Total 2,244,417.00 2,244,417.00 0.00 0.00 2,244,417.00 2,244,417.00
5000 - FIRST BANK OF HIGHLAND PARK Total 2,244,417.00 2,244,417.00 0.00 0.00 2,244,417.00 2,244,417.00
Investment Total
44,619,958 44,619,958 - - 44,619,958 44,619,958
Page 1 of 1
VILLAGE OF NORTHBROOK POLICE AND FIREFIGHTER'S PENSION FUNDS
Effective Interest - Actual Life
Receipts in Period
1/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 2,467,530.00 2,467,530.00 0.00 0.00 2,467,530 2,467,530
139124585 AR-0002 Treasurs Pool 04/30/95 Open 0.0150 0.0000 1.000000 1,549,649.00 1,549,648.00 0.00 0.00 1,549,649 1,549,649
1300 - THE ILLINOIS FUNDS Total 0.0150 0.0000 1.000000 4,017,179.00 4,017,178.00 0.00 0.00 4,017,179 4,017,179
1300 - THE ILLINOIS FUNDS Total 0.0150 0.0000 1.000000 4,017,179.00 4,017,178.00 0.00 0.00 4,017,179 4,017,179
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,446,936.00 6,446,936.00 0.00 0.00 6,446,936 6,446,936
2400 - VANGUARD GROUP Total 0.0000 0.0000 1.000000 6,446,936.00 6,446,936.00 0.00 0.00 6,446,936.00 6,446,936.00
2400 - VANGUARD GROUP Total 0.0000 0.0000 1.000000 6,446,936.00 6,446,936.00 0.00 0.00 6,446,936.00 6,446,936.00
2800 - FIRST TENNESSEE
452152HP9 12-0222 ILLINOIS ST 4.026 3/1/14 03/30/12 Open 1.8405 1.8405 1.041020 500,000.00 520,510.00 -20,510.00 0.00 520,510 501,470
2800 - FIRST TENNESSEE Total 2.1124 1.8071 1.047525 500,000.00 520,510.00 -20,510.00 0.00 520,510.00 501,470.00
2800 - FIRST TENNESSEE Total 2.1124 1.8071 1.047525 500,000.00 520,510.00 -20,510.00 0.00 520,510.00 501,470.00
3000 - CHARLES SCHWAB 66976M409 09-0225 BROWN CAP MGMT SM COMPANY CL I 02/12/09 Open 0.0000 0.0000 23.649900 3,805.50 90,000.00 0.00 0.00 90,000 280,846
66976M409 09-0239 BROWN CAP MGMT SM COMPANY CL I 03/06/09 Open 0.0000 0.0000 20.149900 7,444.17 150,000.00 0.00 0.00 150,000 549,380
66976M409 11-0145 BROWN CAP MGMT SM COMPANY CL I 12/21/10 Open 0.0000 0.0000 43.500000 17.00 739.59 0.00 0.00 740 1,255
66976M409 11-0168 BROWN CAP MGMT SM COMPANY CL I 12/21/10 Open 0.0000 0.0000 43.500000 33.26 1,446.77 0.00 0.00 1,447 2,455
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 197,509
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 303,475
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,002
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 16,735
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 28,929
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 6,959
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 48,400
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 4,808
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 28,515
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 8,959
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,307
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 960
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 564
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 218
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 13,053
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,028
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,075
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 69,892
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,474
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 813
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 106,091
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,365
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 37
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 261,857
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 7,829
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 5,738
38259P508 08-0088 GOOGLE, INC CL A 12/03/07 Open 0.0000 0.0000 677.014900 150.00 101,552.00 0.00 0.00 101,552 177,000
38259P508 09-0023 GOOGLE, INC CL A 05/27/08 Open 0.0000 0.0000 566.250000 50.00 28,312.50 0.00 0.00 28,312 59,000
471023549 11-0116 JANUS INVT FD 10/19/10 Open 0.0000 0.0000 14.970000 10,354.04 155,000.00 155,000 236,590
471023549 11-0118 JANUS INVT FD 10/18/10 Open 0.0000 0.0000 14.899990 6,711.41 100,000.00 100,000 153,356
471023549 11-0177 JANUS INVT FD 12/24/10 Open 0.0000 0.0000 16.429691 193.80 3,184.18 3,184 4,428
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 26,762
543069405 03-0085 LONGLEAF PARTNERS INTL FUND Page 1 of 7
11/13/02 Open 0.0000 0.0000 9.469882 392.46 3,716.55 -3,324.09 0.00 3,717 6,896
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,587
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 07-0087 LONGLEAF PARTNERS INTL FUND 12/27/06 Open 0.0000 0.0000 18.944100 1.65 31.22 31 29
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,330
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,844
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 59,593
543069405 09-0147 LONGLEAF PARTNERS INTL FUND 11/07/08 Open 0.0000 0.0000 10.349700 168.67 1,745.69 1,746 2,963
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,261
543069405 09-0167 LONGLEAF PARTNERS INTL FUND 12/31/08 Open 0.0000 0.0000 10.942200 13.86 151.66 152 244
543069405 09-0197 LONGLEAF PARTNERS INTL FUND 01/02/09 Open 0.0000 0.0000 10.941200 19.93 218.06 218 350
543069405 10-0052 LONGLEAF PARTNERS INTL FUND 08/05/09 Open 0.0000 0.0000 12.860000 3,888.03 50,000.00 50,000 68,313
543069405 11-0153 LONGLEAF PARTNERS INTL FUND 12/31/10 Open 0.0000 0.0000 15.378981 31.40 482.90 483 552
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,637
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 121,628
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,440
863137105 07-0019 STRATTON SMALL CAP VALUE FUND 06/27/06 Open 0.0000 0.0000 45.319900 21.55 976.60 977 1,550
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,859
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 135,910
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 217,456
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,101
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,866
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,450
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 74,982
931422109 04-0028 WALGREEN CO 06/24/03 Open 0.0000 0.0000 32.800000 700.00 22,960.00 -22,260.00 21.00 22,960 40,145
931422109 04-0041 WALGREEN CO 08/29/03 Open 0.0000 0.0000 31.619750 200.00 6,323.95 -6,123.95 29.95 6,324 11,470
931422109 09-0027 WALGREEN CO 05/27/08 Open 0.0000 0.0000 35.437500 1,200.00 42,525.00 42,525 68,820
3000 - CHARLES SCHWAB Total 0.0000 0.0000 14.768316 79,829 1,876,822 (293,335) 51 1,876,824 3,476,938
3000 - CHARLES SCHWAB Total 0.0000 0.0000 14.768316 79,829 1,876,822 (293,335) 51 1,876,824 3,476,938
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 162,282
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 405,705
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 149,730
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 499,102
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 149,730
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 499,102
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 188,438
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 282,657
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 364,308
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 520,440
14040HAS4 14-0211 CAPITAL ONE FINANCING CO 7.375 5/23/14 01/31/14 Open 0.4204 0.4204 1.021590 400,000.00 408,636.00 -8,636.00 5,572.22 414,208 408,344
3600 - MISCHLER FINANCIAL GROUP, INC. Total 2.0903 2.0903 1.048388 3,749,310.00 3,921,054.79 -171,744.79 0.00 3,926,626.00 3,629,838.00
3600 - MISCHLER FINANCIAL GROUP, INC. Total 2.0903 2.0903 1.048388 3,749,310.00 3,921,054.79 -171,744.79 0.00 3,926,626.00 3,629,838.00
4200 - ARBOR RESEARCH & TRADING 3133X7FK5 09-0059 FHLB 5.250 06/18/14 06/06/08 Open 4.0800 4.0800 1.062000 1,400,000.00 1,486,800.00 -86,800.40 0.00 1,486,800 1,427,132
36212UVW8 08-0004 GNMA #544329 5.00 1/15/22 12/23/04 Open 5.1363 5.1363 0.991250 282,740.00 280,266.00 2,473.00 0.00 280,266 277,974
4200 - ARBOR RESEARCH & TRADING, INC. Total 4.6473 4.6473 1.011363 1,682,740.00 1,767,066.00 -84,327.40 0.00 1,767,066.00 1,705,106.00
4200 - ARBOR RESEARCH & TRADING, INC. Total 4.6473 4.6473 1.011363 1,682,740.00 1,767,066.00 -84,327.40 0.00 1,767,066.00 1,705,106.00
4600 - NORTHBROOK BANK & TRUST 7500014724 AR-0023 Cash 05/01/99 Open 0.0500 0.0000 1.000000 15,345.00 15,345.00 0.00 0.00 15,345 15,345
7500014732 AR-0024 Cash 05/01/99 Open 0.0500 0.0000 1.000000 23,782.00 23,782.00 0.00 0.00 23,782 23,782
4600 - NORTHBROOK BANK & TRUST Total 0.0500 0.9098 1.000000 39,127.00 39,127.00 0.00 0.00 39,127.00 39,127
4600 - NORTHBROOK BANK & TRUST Total 0.0500 0.9098 1.000000 39,127.00 39,127.00 0.00 0.00 39,127.00 39,127
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 540,085
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 470,133
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 54,395
452152HP9 12-0025 ILLINOIS ST 4.026 3/1/14 06/03/11 Open 2.5902 2.5902 1.037770 200,000.00 207,554.00 -7,554.00 0.00 207,554 200,588
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 108,790
452152HP9 12-0032 ILLINOIS ST 4.026 3/1/14 06/03/11 Open 2.5902 2.5902 1.037770 500,000.00 518,885.00 -18,885.00 0.00 518,885 501,470
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 633,153
716495AH9 12-0088 PETROHAWK ENERGY CORP NT 10.50 8/1/14 09/09/11
Page 2 of 7 02/01/12 5.3292 -21.0870 1.136900 100,000.00 113,690.00 -13,690.00 0.00 113,690 100,000
716495AH9 12-0090 PETROHAWK ENERGY CORP NT 10.50 8/1/14 09/09/11 02/01/12 5.3292 -21.0870 1.136900 200,000.00 227,380.00 -27,380.00 0.00 227,380 200,000
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 265,533
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
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 531,065
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 462,960
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 160,859
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 428,956
59018YSU6 13-0089 MERRILL LYNCH & CO 5.00 2/3/14 08/07/12 Open 2.0859 2.0859 1.042500 255,000.00 265,837.00 -10,837.00 0.00 265,837 255,000
61747YCF0 13.0098 MORGAN STANLEY 6.00 5/13/14 09/24/12 Open 2.0743 2.0743 1.062800 300,000.00 318,840.00 -18,824.00 0.00 318,840 304,554
61747YCF0 13-0100 MORGAN STANLEY 6.00 5/13/14 09/24/12 Open 2.0743 2.0743 1.062800 400,000.00 425,120.00 -25,120.00 0.00 425,120 406,072
35671DAU9 13-0143 FREEPORT-MCMORAN COPPER & GOLD 3/1/22 12/26/12 Open 3.6269 3.6269 0.994000 100,000.00 99,400.00 600.00 0.00 99,400 95,681
35671DAU9 13-0169 FREEPORT-MCMORAN COPPER & GOLD 3/1/22 12/26/12 Open 3.6269 3.6269 0.994000 100,000.00 99,400.00 600.00 0.00 99,400 95,681
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 198,502
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 297,753
451102AH0 13-0258 ICAHN ENTERPRISES 8.00 1/15/18 04/24/13 01/15/14 6.0668 -2.6118 1.078250 275,000.00 296,518.00 -21,519.00 0.00 296,519 286,000
451102AH0 13-0259 ICAHN ENTERPRISES 8.00 1/15/18 04/24/13 01/15/14 6.0668 -2.6118 1.078550 375,000.00 404,343.00 -29,344.00 0.00 404,344 390,000
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 210,574
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 315,861
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 188,348
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 282,522
577778BS1 14-0051 MAY DEPT STORES CO 5.75 7/15/14 06/28/13 Open 1.0515 1.0515 1.048800 400,000.00 419,520.00 -19,520.00 0.00 419,520 409,000
577778BS1 14-0065 MAY DEPT STORES CO 5.75 7/15/14 06/28/13 Open 1.0515 1.0515 1.048800 500,000.00 524,400.00 -24,400.00 0.00 524,400 511,250
87972VAL2 14-0113 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 510,625
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 510,625
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 517,765
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 621,318
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 330,750
77531QAD0 14-0151 ROGERS WIRELESS INC 6.375 3/1/14 11/29/13 Open 0.4524 0.4524 1.015100 500,000.00 507,550.00 -7,550.00 0.00 507,550 502,180
428236AT0 14-0152 HEWLETT PACKARD CO 6.125 3/1/14 11/29/13 Open 0.4572 0.4572 1.014450 500,000.00 507,225.00 -7,225.00 0.00 507,225 501,995
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 330,750
77531QAD0 14-0158 ROGERS WIRELESS INC 6.375 3/1/14 11/29/13 Open 0.4524 0.4524 1.015000 650,000.00 659,815.00 -9,815.00 0.00 659,815 652,834
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,657
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 259,963
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 344,390
65504LAA5 14-0210 NOBLE CORP 7.375 3/15/14 01/31/14 Open 0.3978 0.3978 1.008510 400,000.00 403,404.00 -3,404.00 11,144.00 414,548 503,785
055299AJ0 14-0212 BBVA US SENIOR SA UNIPER 3.25 5/16/14 01/31/14 Open 0.7400 0.7400 1.007290 500,000.00 503,645.00 -3,465.00 3,385.00 507,030 503,490
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 753,285
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 259,963
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 442,787
65504LAA5 14-0235 NOBLE CORP 7.375 3/15/14 01/30/14 Open 0.5472 0.5472 1.008510 500,000.00 504,255.00 -4,255.00 0.00 504,255 501,995
055299AJ0 14-0237 BBVA US SENIOR SA UNIPER 3.25 5/16/14 01/31/14 Open 0.7400 0.7400 1.007290 750,000.00 755,467.00 -5,468.00 5,078.00 7,605,645 755,235
4900 -PERSHING Total 2.9027 2.3387 1.036888 17,413,506.00 18,078,321.00 -647,093.00 0.00 24,675,499.00 17,859,177.00
4900 - PERSHING Total 2.9027 2.3387 1.036888 17,413,506.00 18,078,321.00 -647,093.00 0.00 24,675,499.00 17,859,177.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 510,246
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 321,266
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 188,430
00507V109 14-0082 ACTIVISION BLIZZARD INC 07/08/13 OPEN 0.0000 0.0000 14.414800 18,200.00 262,349.00 0.00 0.00 262,349.00 311,766
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 286,522
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 207,634
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 335,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 189,890
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 195,131
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 97,620
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 58,572
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 151,459
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 80,434
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,396
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 73,610
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,125
029683109 07-0107 AMERICAN SOFTWARE INC CL A 02/23/07
Page 3 of 7 OPEN 0.0000 0.0000 7.180600 1,200.00 8,816.76 0.00 0.00 8,817.00 12,096
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 2,016
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 10,080
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-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 19,081
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 4,032
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 5,040
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 6,048
029683109 07-0174 AMERICAN SOFTWARE INC CL A 02/23/07 OPEN 0.0000 0.0000 7.554000 100.00 755.40 0.00 0.00 755.00 1,008
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 5,040
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 1,008
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 5,040
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 58,766
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 22,176
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 90,880
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 36,920
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 37,695
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,616
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,079
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,539
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 83,556
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 60,768
037833100 08-0165 APPLE, INC 02/19/08 OPEN 0.0000 0.0000 127.209000 400.00 31,802.00 0.00 0.00 31,802.00 200,240
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 47,817
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 92,092
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 12,397
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 102,718
05508R106 13-0045 B & G FOODS INC 07/06/12 OPEN 0.0000 0.0000 26.649800 3,000.00 79,949.00 0.00 0.00 79,949.00 98,310
05508R106 13-0066 B & G FOODS INC 08/02/12 OPEN 0.0000 0.0000 28.356100 1,800.00 51,041.00 0.00 0.00 51,041.00 58,986
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 293,928
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 250,112
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,775
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,850
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 19,988
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 14,991
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 19,988
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 19,988
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 44,973
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 24,985
119530301 14-0154 BUFFALO EMERGING OPPORTUNITIES 11/05/13 OPEN 0.0000 0.0000 18.519900 10,799.14 200,000.00 0.00 0.00 200,000.00 212,095
119530301 14-0227 BUFFALO EMERGING OPPORTUNITIES 01/28/14 OPEN 0.0000 0.0000 19.510000 10,251.15 200,000.00 0.00 0.00 200,000.00 201,333
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 102,688
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 73,807
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 72,261
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 105,524
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 140,865
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 339,185
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 564,517
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 234,168
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 1,928
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 230,037
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 5,887
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 5,736
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,320
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,286
19765P596 08-0158 COLUMBIA SMALL CAP GROWTH FUND 02/14/08 OPEN 0.0000 0.0000 27.610000 4,527.35 125,000.00 0.00 0.00 125,000.00 147,139
19765P596 11-0088 COLUMBIA SMALL CAP GROWTH FUND 10/18/10 OPEN 0.0000 0.0000 27.639962 3,617.95 100,000.00 0.00 0.00 100,000.00 117,583
19765P596 12-0140 COLUMBIA SMALL CAP GROWTH FUND 12/09/11 OPEN 0.0000 0.0000 27.660029 802.51 22,197.00 0.00 0.00 22,197.00 26,082
19765P596 14-0162 COLUMBIA SMALL CAP GROWTH FUND 12/09/13 OPEN 0.0000 0.0000 31.809965 1,702.69 54,163.00 0.00 0.00 54,163.00 55,337
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 44,506
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 57,222
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,716
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 284,424
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 196,388
237194105 14-0005 DARDEN RESTAURANTS INC 05/22/13
Page 4 of 7 OPEN 0.0000 0.0000 53.180000 1,200.00 63,816.00 0.00 0.00 63,816.00 59,328
237194105 14-0026 DARDEN RESTAURANTS INC 05/07/13 OPEN 0.0000 0.0000 52.200000 1,600.00 83,520.00 0.00 0.00 83,520.00 79,104
23918K108 14-0119 DAVITA HEALTHCARE PARTNERS INC 10/10/13 OPEN 0.0000 0.0000 58.040000 5,100.00 296,008.00 0.00 0.00 296,008.00 331,143
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
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 154,728
245906201 12-0053 DELAWARE SMID CAP GROWTH FUND 07/29/11 OPEN 0.0000 0.0000 27.849930 7,719.93 215,000.00 0.00 0.00 215,000.00 263,790
245906201 12-0126 DELAWARE SMID CAP GROWTH FUND 12/06/11 OPEN 0.0000 0.0000 27.349984 3,546.62 97,000.00 0.00 0.00 97,000.00 121,188
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 410,174
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 187,461
264411505 14-0043 DUKE REALTY CORP 05/07/13 OPEN 0.0000 0.0000 17.803900 4,800.00 85,459.00 0.00 0.00 85,459.00 75,408
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 53,414
277432100 14-0123 EASTMAN CHEM CO 10/10/13 OPEN 0.0000 0.0000 78.021100 3,700.00 288,678.00 0.00 0.00 288,678.00 288,452
277432100 14-0132 EASTMAN CHEM CO 11/14/13 OPEN 0.0000 0.0000 79.079400 2,400.00 189,790.00 0.00 0.00 189,790.00 187,104
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 226,665
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 135,999
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 303,996
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 188,188
30219G108 14-0216 EXPRESS SCRIPTS HOLDING CO 01/07/14 OPEN 0.0000 0.0000 70.280000 4,600.00 323,288.00 0.00 0.00 323,288.00 343,574
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 23,237
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 221,737
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 216,158
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,329
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,492
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 76,585
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 54,060
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 65,800
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 90,475
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 322,175
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,145
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 21,939
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 319,410
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 315,900
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 251,100
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 64,800
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 334,623
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 222,409
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 85,939
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 1,958
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 7,830
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 7,830
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 7,830
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 25,800
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 36,840
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 23,490
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 203,044
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 284,345
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 169,070
459200101 09-0075 IBM 08/27/08 OPEN 0.0000 0.0000 124.130900 700.00 86,892.00 0.00 0.00 86,892.00 123,676
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 54,340
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 70,642
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 208,790
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 310,310
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 387,795
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 4,886
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 15,474
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 87,496
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 185,929
494550106 13-0215 KINDER MORGAN ENERGY LP 02/01/13 OPEN 0.0000 0.0000 88.467300 1,800.00 159,241.00 0.00 0.00 159,541.00 143,064
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 54,416
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 78,223
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 162,450
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 297,786
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 197,733
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 186,670
561709734 14-0234 MANAGERS AMG SKYLINE SPECIAL 01/30/14
Page 5 of 7 OPEN 0.0000 0.0000 37.739900 5,829.36 220,000.00 0.00 0.00 220,000.00 220,350
57636Q104 11-0034 MASTERCARD INC 07/12/10 OPEN 0.0000 0.0000 204.754500 3,000.00 61,427.00 0.00 0.00 61,427.00 227,040
57636Q104 11-0186 MASTERCARD INC 07/12/10 OPEN 0.0000 0.0000 204.755000 1,000.00 23,027.00 0.00 0.00 23,027.00 75,680
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
57636Q104 12-0016 MASTERCARD INC 06/03/11 OPEN 0.0000 0.0000 286.600000 3,000.00 85,980.00 0.00 0.00 85,980.00 227,040
577081102 13-0217 MATTEL INC 02/01/13 OPEN 0.0000 0.0000 37.150000 1,600.00 59,440.00 0.00 0.00 59,440.00 60,544
577081102 13-0238 MATTEL INC 04/04/13 OPEN 0.0000 0.0000 43.628700 1,500.00 65,443.00 0.00 0.00 65,443.00 56,760
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 100,643
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 63,564
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 34,170
589584101 07-0164 MERIDIAN BIOSCIENCE INC 02/23/07 OPEN 0.0000 0.0000 18.677000 2,200.00 41,089.00 0.00 0.00 41,089.00 50,116
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 6,834
589584101 10-0183 MERIDIAN BIOSCIENCE INC 04/26/10 OPEN 0.0000 0.0000 19.640950 1,000.00 19,641.00 0.00 0.00 19,641.00 22,780
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 9,112
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 11,390
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 8,748
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 9,477
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 12,393
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,103
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 48,843
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 17,496
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 18,954
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 239,596
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 374,651
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 137,818
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 296,311
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 53,832
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 89,720
55261F104 14-0036 M T BANK CORP 05/24/13 OPEN 0.0000 0.0000 106.086300 1,600.00 169,738.00 0.00 0.00 169,738.00 178,416
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 94,050
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 69,825
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 286,083
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 240,673
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 45,410
62886E108 14-0098 NCR CORPORATION 07/08/13 OPEN 0.0000 0.0000 33.552800 7,800.00 261,712.00 0.00 0.00 261,712.00 274,482
G65431101 14-0218 NOBLE CORP PLC 01/07/14 OPEN 0.0000 0.0000 37.269400 8,600.00 320,517.00 0.00 0.00 320,517.00 266,858
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 92,440
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 127,105
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 323,980
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 41,094
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 41,094
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 285,600
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 41,532
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 30,529
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 547
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,169
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 82,284
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 103,617
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 106,378
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 267,798
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 198,897
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 207,982
68389X105 09-0218 ORACLE CORP 02/13/09 OPEN 0.0000 0.0000 17.408800 4,200.00 73,117.00 0.00 0.00 73,117.00 154,980
68389X105 12-0223 ORACLE CORP 04/30/12 OPEN 0.0000 0.0000 28.689900 700.00 20,083.00 0.00 0.00 20,083.00 25,830
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 104,550
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 66,912
713291102 13-0056 PEPCO HOLDINGS INC 07/09/12 OPEN 0.0000 0.0000 19.549500 4,400.00 86,018.00 0.00 0.00 86,018.00 85,492
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 50,518
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 106,400
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 66,880
731068102 13-0264 POLARIS INDS INC 02/01/13 OPEN 0.0000 0.0000 85.900000 1,700.00 146,030.00 0.00 0.00 146,030.00 212,840
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 244,423
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 296,276
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 271,739
744320102 14-0217 PRUDENTIAL FINANCIAL INC 01/07/14
Page 6 of 7 OPEN 0.0000 0.0000 90.330000 3,500.00 316,155.00 0.00 0.00 316,155.00 295,365
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 319,146
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 57,092
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
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 69,326
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 33,950
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 67,900
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 11,901
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 51,571
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 75,373
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 15,868
786514208 14-0096 SAFEWAY INC 07/08/13 OPEN 0.0000 0.0000 23.700000 11,200.00 265,440.00 0.00 0.00 265,440.00 349,888
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 214,658
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 151,741
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 158,366
835699307 14-0221 SONY CORP A D R 01/07/14 OPEN 0.0000 0.0000 17.261900 18,600.00 321,071.00 0.00 0.00 321,071.00 292,950
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 53,612
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 86,604
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 75,495
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 93,470
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 60,936
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 106,638
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 303,564
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 196,206
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 341,140
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 134,256
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 326,600
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 191,700
883556102 14-0016 THERMO FISHER SCIENTIFIC INC 05/24/13 OPEN 0.0000 0.0000 87.579100 2,000.00 175,158.00 0.00 0.00 175,158.00 230,280
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 199,905
892331307 14-0095 TOYOTA MTR CORP 07/08/13 OPEN 0.0000 0.0000 125.009000 2,100.00 262,519.00 0.00 0.00 262,519.00 240,996
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 198,632
H89128104 13-0205 TYCO INTERNATIONAL 01/11/13 OPEN 0.0000 0.0000 29.640800 7,900.00 234,162.00 0.00 0.00 234,162.00 319,871
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 191,664
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 89,040
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,920
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,200
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 250,390
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 209,510
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 333,518
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 207,322
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 53,172
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 88,620
931422109 11-0092 WALGREEN COMPANY 10/22/10 OPEN 0.0000 0.0000 33.755000 400.00 13,502.00 0.00 0.00 13,502.00 22,940
931422109 12-0129 WALGREEN COMPANY 12/07/11 OPEN 0.0000 0.0000 33.239500 400.00 13,296.00 0.00 0.00 13,296.00 22,940
931422109 13-0111 WALGREEN COMPANY 11/20/12 OPEN 0.0000 0.0000 32.180000 500.00 16,090.00 0.00 0.00 16,090.00 28,675
94973V107 14-0080 WELLPOINT INC 07/08/13 OPEN 0.0000 0.0000 81.888100 3,200.00 262,042.00 0.00 0.00 262,042.00 275,200
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 93,127
969457100 14-0087 WILLIAMS COS INC 05/22/13 OPEN 0.0000 0.0000 37.030000 1,700.00 62,951.00 0.00 0.00 62,951.00 68,833
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 298,375
5100 -FSC SECURITIES CORPORATION Total 0.0000 0.0000 0.000000 927,861.44 27,168,109.65 0.00 0.00 27,168,851.72 32,941,695.13
5100 - FSC SECURITIES CORPORATION Total 0.0000 0.0000 0.000000 927,861.44 27,168,109.65 0.00 0.00 27,168,851.72 32,941,695.13
Investment Total
50,176,976 79,155,612 (1,217,011) 51 85,759,106 85,937,954
Page 7 of 7
FINANCE DEPARTMENT
COLLECTION AGENCIES STATUS REPORT
QUARTER ENDING JANUARY, 2014
The following represents a summation of the collection status reports as of January 31, 2014 from Armor
Systems Corporation (Armor) and A/R Concepts, Inc.
Armor Systems Corporation
Amount Placed Collected During Collected to Date
(Since 5/98) 11/13 -- 1/14 (Since 5/98) Liquidation Ratio
Ambulance Transport $381,820.00 $2,300.00 $51,650.00 13.5%
Police False Alarms 18,670.00 0.00 11,960.00 64.1%
Final Water Bills 10,179.00 0.00 2,033.00 20.0%
NSF Checks 65.00 0.00 0.00 0.0%
Parking Tickets 66,615.00 80.00 11,570.00 17.4%
TOTAL $477,349.00 $2,380.00 $77,213.00 16.2%
A/R Concepts, Inc.
Amount Placed Collected During Collected to Date
(Since 5/98) 11/13 -- 1/14 (Since 5/98) Liquidation Ratio
Ambulance Transport $383,242.00 $1,440.00 $55,799.00 14.6%
Police False Alarms 20,360.00 0.00 15,320.00 75.2%
Final Water Bills 17,579.00 0.00 1,133.29 6.4%
NSF Checks 0.00 0.00 0.00 N/A
Parking Tickets 57,775.00 0.00 4,815.00 8.3%
TOTAL $478,956.00 $1,440.00 $77,067.29 16.1%
Northbrook Economic Data
•Office, Industrial & Retail Vacancies
•Unemployment Rates
•Local Sales Tax Collections
•Hotel Market
•Housing Market
•Equalized Assessed Values
•Building Permits
March 2014
Northbrook Economic Data
March 2014
• Office, Industrial, & Retail Vacancy Rates
Central North &
Near North
Office Submarkets
Source: CoStar
Source: CoStar
South Lake County &
North Cook County
Industrial Submarkets
Source: CoStar
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.9%
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
Source: Village of Northbrook Survey
Northbrook Economic Data
March 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.2%
6.0%
5.4%
4.4%
4.2%
4.0% 4.0% 4.0%
3.2%
2.9%
2.0%
0.0%
2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 Dec-13
Northbrook Unemployment Rate Cook County Unemployment Rate
Source: IDES - LMI
Chicago Metro Area Unemployment Rate State of Illinois Unemployment Rate
Unemployment Rate by Area Municipalities
Not Seasonally Adjusted
Change Change
Over the Over the
CITIES Dec-13 Nov-13 Dec-12 Month Year
GLENVIEW VILLAGE 5.1 5.2 5.5 -0.1 -0.4
NORTHBROOK VILLAGE 5.4 5.5 6.1 -0.1 -0.7
WILMETTE VILLAGE 5.5 5.7 5.2 -0.2 0.3
ARLINGTON HEIGHTS VILLAGE 5.6 5.7 6.3 -0.1 -0.7
ELMHURST CITY 5.7 5.8 6.0 -0.1 -0.3
MOUNT PROSPECT VILLAGE 5.8 5.7 6.5 0.1 -0.7
SCHAUMBURG VILLAGE 6.0 6.1 6.2 -0.1 -0.2
HOFFMAN ESTATES VILLAGE 6.1 5.9 6.6 0.2 -0.5
MORTON GROVE VILLAGE 6.1 6.4 6.2 -0.3 -0.1
HIGHLAND PARK CITY 6.2 6.3 5.7 -0.1 0.5
EVANSTON CITY 6.3 6.6 6.5 -0.3 -0.2
PALATINE VILLAGE 6.4 6.1 7.0 0.3 -0.6
SKOKIE VILLAGE 6.5 6.7 6.9 -0.2 -0.4
BUFFALO GROVE VILLAGE 6.6 6.8 6.3 -0.2 0.3
NILES VILLAGE 6.8 7.0 6.6 -0.2 0.2
WHEELING VILLAGE 7.1 6.3 7.7 0.8 -0.6
DES PLAINES CITY 8.0 7.4 8.3 0.6 -0.3
CHICAGO CITY 9.5 9.6 9.7 -0.1 -0.2
Source: IDES - LMI
Northbrook Economic Data
March 2014
• Local Sales Tax Collections
Village of Northbrook
Sales Tax by Calendar Month of Actual Retail Sale
Through November 2013
$1,800,000
$1,600,000
$1,400,000
$1,200,000
$1,000,000 2010
2011
$800,000 2012
2013
$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 2012 & 2013
$80,000
$62,174 $60,998
$60,000
$44,289
$40,000
$19,187
$20,000
$4,337
$-
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov
$(20,000)
$(18,809)
$(24,816)
$(40,000)
$(60,000)
$(57,658)
$(80,000)
Total Difference Through November $(82,502)
$(100,000)
-$198,863 $(101,730) $(104,332)
$(120,000)
Difference Between '12 & '13
Source: Village of Northbrook
Village of Northbrook
% Sales Tax Change by Calendar Month of Actual Retail Sales
Difference Between 2012 & 2013
8.0%
5.8%
6.0%
5.2%
4.5%
4.0%
1.9%
2.0%
0.4%
0.0%
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov
-2.0% -1.6%
-2.2%
-4.0%
-4.9%
-6.0%
-6.2%
-8.0%
% Change Through November
-7.8% -8.0%
Decrease of 1.5%
-10.0%
% Difference '12 & '13
Source: Village of Northbrook
Northbrook Economic Data
March 2014
• Hotel Market
Hotel Revenue Per Available Room (RevPAR)
$100.00
94.29
$90.00
$88.09
$80.00
78.60
$70.00 $70.39
$60.00
$50.00
42.99
$39.52 40.42
$40.00
$30.00
$20.00
$10.00
$-
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
2012 2013
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
$60.00
2010
Axis Title
$50.00 2011
2012
2013
$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
$900,000
$810,315
$800,000
Annual Difference Sheraton Opened
Between 2012 & 2013 Fall 2008
$700,000
+ $43,167
$600,000
An 6% Increase $578,924
2008
$500,000 2009
2010
2011
$400,000
2012
2013
$300,000
$236,672 $230,080
$200,000 $188,660
$171,414
$154,902 $154,449
$126,560 $126,501
$100,000
$-
Jan-Mar Apr-Jun Jul-Sep Oct-Dec Year Total
Note: # of rooms – Sheraton -161; Renaissance - 385 Source: Village of Northbrook
Northbrook Economic Data
March 2014
• Housing Market
Single Family Detached Residences - Average Sales Price
$1,400,000
$1,200,000
$1,000,000
$800,000
Jan-11
Jan-12
Jan-13
$600,000 $558,782
Jan-14
$400,000
$200,000
$-
Deerfield Glencoe Glenview Highland Park Northbrook Northfield Prospect Wheeling
Heights
Source: Robert E. Headrick Assoc., Inc.
Single Family Detached Residences - Average Sales Price
Difference from Previous Year
20.0%
15.0%
10.0% 9.4%
5.9%
5.0%
0.0%
Jan-12
Jan-13
-5.0% Jan-14
-5.9%
-10.0%
-15.0%
-20.0%
-25.0%
Deerfield Glencoe Glenview Highhland Park Northbrook Northfield Prospect Heights Wheeling
Source: Robert E. Headrick Assoc., Inc.
Northbrook Economic Data
March 2014
• Equalized Assessed Values
Village of Northbrook
Equalized Assessed Valuations (EAV) in Dollars
$3,500,000,000
$3,000,000,000
$2,500,000,000
$2,407,850,884 $2,410,896,301
EAV
$2,000,000,000
(less exemptions)
$1,592,730,144
$1,500,000,000 $1,530,248,322
Residential
Commercial
$1,000,000,000 Industrial
Total
$500,000,000 $541,731,517 $526,759,510
$335,716,243
$291,406,647
$-
2006 2007 2008 2009 2010 2011 2012
Source: Cook County Clerk
Village of Northbrook
Equalized Assessed Valuation (EAV) by Percentage
100%
14% 12% 12%
90%
80%
20%
22%
22%
70%
60%
Industrial
50%
Commercial
Residential
40%
68% 66%
64%
30%
20%
10%
0%
2006 2007 2008 2009 2010 2011 2012
Source: Cook County Clerk
Percentage Change in EAV from Previous Year
25%
21%
20% 20%
20%
15%
15%
10% 2006
2007
2008
5% 2009
2010
2011
0% 2012
Residential Commercial Industrial Total
-5%
-7% -6%
-7% -7%
-10%
-15%
Source: Cook County Clerk
Northbrook Economic Data
March 2014
• Building Permits
Source: Village of Northbrook
Source: Village of Northbrook
Source: Village of Northbrook
Source: Village of Northbrook
Source: Village of Northbrook
Northbrook Economic Data
Prepared by the Village of Northbrook
Department of Development & Planning Services
March 2014