Administration & Finance Committee
Regular MeetingNorthbrook, IL · November 15, 2016
Minutes
APPROVED
Minutes of a Meeting of the Administration and Finance Committee
Village of Northbrook
Cook County, Illinois
November 15, 2016
CALL TO ORDER
Trustee Scolaro called the meeting to order in the Terrace Room at 6:20 p.m. On roll call,
present were Trustees Karagianis and Scolaro. A quorum was present. Also present were Village
President Frum; Trustees Buehler and Heller; Village Manager Richard Nahrstadt; Deputy Village
Manager and Chief Financial Officer Jeff Rowitz; Assistant to the Village Manager, Erik Jensen; Fire Chief
Jose Torres; Deputy Fire Chief Dan Quinn; Police Chief Charles Wernick; Deputy Police Chief Lou Caruso,
Deputy Police Chief Scott Dunham; Jason Batalden, Internal Services Administrator, Police Department;
Emma Perley, Management Analyst, Fire Department; Lori Baker, Chief Information Officer; Kelly Hamill,
Public Works Director; Village Engineer, Matt Farmer; Matt Morrison, Assistant Public Works Director;
Betsy Garibaldi, Assistant Finance Director; Iwona Petryszak, Accounting Manager, Finance Department;
Tom Poupard, Director, Development and Planning Services; David Schoon Assistant Director,
Development and Planning Services and Debbie Ford, Village Clerk.
HEAR FROM THE AUDIENCE
None
PRESENTATION & DISCUSSION OF QUARTERLY FINANCIAL REPORTS
Deputy Village Manager and Chief Financial Officer Jeff Rowitz reviewed the Fiscal Year 2015/16
year-end financial statements. He stated that the General Fund ended the fiscal year with reserves that
were $2.8 million above the 40% reserve policy. Mr. Rowitz noted that during the budget process, the
Board of Trustees transferred $2.4M of excess reserves to the Water Fund and $600,000 to the Sanitary
Sewer Fund.
Mr. Rowitz then presented a summary of revenues and expenditures for the year, highlighting that
expenditures were $2.9 million under budget, primarily due to timing of capital projects and temporary
staffing vacancies due to turnover. He then presented a summary for the last six fiscal years and stated
that expenditures in FY 15/16 were $185,000 more than the previous fiscal year. He also reviewed the
overtime reports and noted that overtime for FY 15/16 was approximately $45,000 less than the
previous year.
Mr. Rowitz then presented a summary of the first quarter estimates for FY 16/17.
He stated expenditures are projected to be $200,000 under budget, and revenues are expected to be
approximately $100,000 less than anticipated. General Fund reserves are projected to be $3.1 million
above the 40% reserve policy at April 30, 2017. He then summarized the overtime reports for the first
quarter and stated that first quarter overtime was $15,000 less than the same period in FY 15/16. Mr.
Rowitz then reviewed the budget to actual sales tax reports. He stated that over the past 18 months, the
cumulative sales tax was $368,000 under budget, which equates to a variance of 1.6%. Trustee Heller
asked if we knew why sales tax was down. President Frum stated it is primarily due to internet sales.
Economic Development Director David Schoon then reviewed the following Northbrook’s economic
data that was provided in the written materials to the Committee.
Northbrook office, industrial, and shopping center vacancy rates;
Unemployment rates;
Hotel tax revenue and average revenue per available hotel room.
Equalized assessed values by classification and the tax year;
Average sales prices for single detached homes; and
Building permits issued.
PRESENTATION AND DISCUSSION OF CAPITAL IMPROVEMENT PLAN
Iwona Petryszak, Accounting Manager, reviewed the Capital Improvement Plan and the role it plays
in the Village’s financial reporting cycle. She also discussed the Water Fund study completed in 2015,
which formed the basis for scheduled capital improvements in the Water Fund. Ms. Petryszak then
discussed the planned facilities study to be prepared and reviewed with the Ad Hoc Facilities Committee
in 2017.
President Frum noted she and Trustee Israel toured most of the Village buildings yesterday. She
stated everyone else should take a tour prior to the first Ad Hoc Committee meeting.
Erik Jensen, Assistant to the Village Manager, reviewed Fiscal Year 2016/2017. He discussed the
various projects that were scheduled or completed during the fiscal year such as the Starcom21
radio upgrades at the Police 911 Center, Fire Station 11’s windows replacement, various
improvements to the Fleet Garage, and the replacement of the Police Department’s Roof/HVAC
and Village Hall emergency generators as well as Fire Engine Unit 57, Ambulance Unit 65 and
various other vehicles and IT infrastructure components. Moving through the other funds, Mr.
Jensen discussed the status of the following projects: Asphalt Street Rehabilitation projects:
Central Business District, Concrete Street Rehabilitation and Arrowhead and White Road.
Stormwater projects: Northbrook East; Shermer Road Overflow, Westcott Park and
Keystone/Chartres.
Water/Sewer projects: Water Main Replacement, Two zone Water Pressure Implementation,
Critical Valve Installation
Scheduled Vehicle Replacements
Sanitary Sewer Fund: Sanitary sewer lining(in the area bounded by Dundee, Waukegan, Grant
and Voltz)
Ms. Petryszak reviewed a summary of the planned capital projects for FY 17/18 broken down by
fund. She also reviewed the current debt schedule and planned debt service for all outstanding debt
issues.
Trustee Scolaro questioned why the debt payments are going up $600,000 a year. Mr. Rowitz stated
it is due to previously issued bonds for infrastructure improvements.
Ms. Petryszak then reviewed the significant General Fund projects for FY 17/18:
Village Hall generator replacement
Security camera replacements/installations
Public Works Facility trench drain replacement
IT Improvements throughout the Village:
o Wired/wireless network replacement
o Telephone and voicemail system
Other projects:
o Master Bike Plan Update
o Vehicle replacements:
Unit 55
Units 226 and 227
Other scheduled major vehicle replacements
Director of Public Works Kelly Hamill reviewed the 17/18 infrastructure projects.
Infrastructure Capital Projects Fund:
Asphalt Streets
o Illinois/Maple Oak
o Lee Road
o Central Business District and streetscape expansion
Concrete Streets (Lone Tree)
Other projects
o Skokie Valley Trail
Stormwater Fund:
Dundee Road and Skokie Blvd.
Keystone Road/Chartres Drive
Northbrook Manor (construction)
Sunset Lane
Woodlawn Road
Dehne Road and Glendale Avenue
Water Fund projects:
Water main replacement
Dundee and Lee Critical main replacement
Two Zone Construction
President Frum asked if the Dundee project is dependent on the Illinois Department of
Transportation (IDOT) doing the culvert. Do we know for certain if they will be replacing the culvert?
Director Hamill replied, that has not been determined. President Frum questioned if the permits would
have to be resubmitted if they don’t. Director Hamill stated it would depend on the timing, noting that
one of the sanitary sewer lines has to be relocated.
Sanitary Sewer projects:
Dundee and Lee: Main replacement related to IDOT project on Dundee Road at intersection
with Lee Road.
Ms. Petryszak then summarized the Fiscal 18/19 projects. She stated that 60-70 percent are
infrastructure projects. She explained that the Western Ave road reconstruction and water main
replacement were scheduled for FY 17/18 but have been rescheduled for FY 18/19. Director Hamill
stated the project will include complete reconstruction of Western Avenue between Oak and Techny
including conversion to an asphalt surface. He explained there will be a simultaneous replacement of
2,800 feet of original water main and extension of the main to Maple in order to loop the mains in the
area. Trustee Buehler questioned how old the main was and Assistant Director of Public Works Matt
Morrison stated from 1960s.
Village Manager Nahrstadt stated the Village is looking for federal grants for the Skokie Valley
Trail project. Director Hamill stated we are applying for a grant for construction of the bridge and the
trail. He then reviewed Woodlawn Road, water main replacements and planned storm water projects.
Accounting Manager Petryszak summarized the significant projects for fiscal year 19/20.
Willow Creek subdivision
Dundee at railroad tracks critical main replacement
Water plant roof replacement
Brittany and Blackthorn stormwater project
Wendy Road stormwater project (acquisition and design/final engineering)
Fire engine replacement
Ms. Petryszak reviewed the significant projects for fiscal year 20/21.
Asphalt and concrete street reconstruction – Sky Harbor
Water main replacement
Wendy Drive storm water project
First Street/Center Avenue storm water project (design and engineering)
Water plant roof replacement (phase II)
Ambulance replacement
Ms. Petryszak reviewed the significant projects for fiscal year 21/22 .
Water main replacement project on Russett Lane
First Street/Center Avenue stormwater project (construction)
Willow Creek Subdivision stormwater
Self-contained breathing apparatus replacement
DISCUSSION – 2016 PROPERTY TAX LEVY
Mr. Rowitz explained that the property tax levy has to be approved in December. The Illinois Truth
in Taxation law requires that we calculate our estimated levy increase at least 20 days prior to adoption.
If the calculated increase is expected to exceed 105% of the previous year’s levy, we are required to
publish specific notices and conduct a public hearing prior to adoption of the levy Ordinance. The
proposed levy exceeds 105% of last year’s levy.
Mr. Rowitz gave a status on the Fire and Police Pension funds, explaining that last year the funds lost
money. Since 2005, we have assumed an 8% rate of return on investments. This was in line with other
public sector pension plans and historical averages. Eight percent made sense for a number of years;
however the last few years have not met the benchmark. Mr. Rowitz stated staff is recommending to
bring the assumed rate of return down to 7 ½% in 2016 and then 7% in 2017. Rowitz stated he, Village
Manager Nahrstadt and Accounting Manager Petryszak met with President Frum and Trustee Scolaro
and they concur with this recommendation and also recommend using $1 million from the General Fund
surplus reserves to moderate the required property tax increase. He stated that staff is looking for
direction on how to draft the levy ordinance for the December meeting.
Trustee Heller questioned if there were other options. In response, Trustees Karagianis and Israel
stated we could take more out of reserves.
Trustee Israel questioned if there has ever been an excess in the Fire and Police Pension Funds. Mr.
Rowitz stated that in the late 1990’s both plans were overfunded, and in 2005 both plans were 100%
funded.
Trustee Karagianis suggested taking more out of reserves to reduce the property tax increase.
The Trustees discussed. Trustee Scolaro stated we don’t know what is happening with Springfield
and recommended not taking additional reserves beyond the proposed $1 million in order to maintain
financial flexibility. Trustee Heller commented he is not happy with the 14% increase to property taxes.
Mr. Rowitz stated that the levy approved in December will establish an amount that we cannot
exceed. We have until the end of March to do abatements. This has been done in the past, through the
budget process.
President Frum discussed taking funds out of General Fund reserves. She recommended we wait
until we see the budget in the spring. This will provide the most flexibility. After discussing, the
Committee determined to move forward with staff’s recommendation and determine if more monies
should be moved to moderate the property tax levy once staff is completed with and presents the
budget.
Respectfully submitted,
Debra J. Ford
Village Clerk
Agenda
ADMINISTRATION & FINANCE COMMITTEE
NORTHBROOK VILLAGE HALL, 1225 CEDAR LANE
NOVEMBER 15, 2016, 6:00 P.M., TERRACE ROOM
The Administration & Finance Committee of the Village of Northbrook Board of Trustees will hold a
meeting on Tuesday, November 15, 2016 at 6:00 p.m. in the Terrace Room of the Village Hall, 1225
Cedar Lane, Northbrook, Illinois. The following will be discussed.
MEETING AGENDA
Please note: a light dinner will be provided for Board Members and Staff
1. Call To Order
2. Hear From The Audience
3. DISCUSSION: FY 15/16 Year End Review
4. DISCUSSION: First Quarter (FY 16/17) Budget Review
5. DISCUSSION: Capital Improvement Plan
6. DISCUSSION: 2016 Property Tax Levy
7. Adjourn
Michael Scolaro, Chair
Administration/Finance Committee
Members: Trustee Karagianis
Trustee Ciesla
Village of Northbrook
Cook County, Illinois
November 15, 2016
The Village of Northbrook is subject to the requirements of the Americans with Disabilities Act of 1990.
Individuals with disabilities who plan to attend this meeting and who require certain accommodations in
order to allow them to observe and/or participate in this meeting, or who have questions regarding the
accessibility of this meeting or the facilities, are requested to contact Greg Van Dahm or Debbie Ford (664-
4014 or 4013respectively) promptly to allow the Village of Northbrook to make reasonable accommodations
for those persons. Hearing impaired individuals may call the TDD number, 564-8645, for more information.
Administration and Finance Committee
November 15, 2016
Meeting Attachments
1. FY 15/16 General Fund Revenue and Expenditure Summary
2. FY 15/16 General Fund Revenue
3. FY 15/16 General Fund Expenditures and Fund Balance
4. FY 15/16 Overtime Reports
5. FY 15/16 Investment Report
6. FY 16/17 General Fund Revenue and Expenditure Summary
7. FY 16/17 General Fund Revenue
8. FY 16/17 General Fund Expenditures and Fund Balance
9. Sales Tax Collection
10. FY 16/17 Overtime Reports
11. FY 16/17 Quarterly Investment Report
12. Northbrook Economic Data Report – November 2016
13. FYs 2018-2022 Capital Improvement Plan Presentation
14. 2016 Property Tax Levy Memorandum
Revenue and Expense Projections
General Fund (without special revenue funds) *
Fiscal Year 2015/16
Variance from Original Budget
Original Amended Oct. 2015 March 2016 Audited Oct. 2015 March 2016 Audited
Budget Budget Estimate Estimate Actual Estimate Estimate Actual
Revenue $ 43,790,530 $ 43,790,530 $ 43,743,649 $ 44,120,550 $ 46,139,651 -0.11% 0.75% 5.36%
Expense $ 44,412,625 $ 44,419,125 $ 43,839,282 $ 42,376,180 $ 41,491,853 -1.29% -4.59% -6.58%
Surplus (Deficit) $ (622,095) $ (628,595) $ (95,633) $ 1,744,370 $ 4,647,798
Equity Transfer $ (300,000) $ (300,000) $ (300,000) $ (300,000) $ (3,300,007)
Assigned bond proceeds $ 3,304,763
Prior year bonds $ 1,150,000 $ 1,150,000 $ 1,145,963 $ 1,150,000 $ 1,145,963
Adjusted Surplus 227,905 221,405 750,330 2,594,370 (811,009)
Fund Balance $ 22,288,425 $ 22,281,925 $ 22,810,850 $ 23,504,890 $ 21,249,511 2.34% 5.46% -4.66%
as a % of revenue 50.9% 50.9% 52.1% 53.3% 46.1%
as a % of expense 50.2% 50.2% 51.7% 55.1% 47.4%
Fund Balance above 40%
target $ 4,772,213 $ 4,765,713 $ 5,313,390 $ 5,856,670 $ 2,793,651
* Restricted revenues for drug forfeiture and foreign fire taxes and the associated expenses have been deducted.
Village of Northbrook
General Fund Revenue Projections
Fiscal Year 2016 - Final
November 15, 2016
Over (Under)
Account FY 2014/15 FY16 October 2015 March 2016 Budget
Number Actual Budget Estimate Estimate Final $ %
Property Taxes 401-00/11 7,714,519 7,820,750 7,820,750 7,820,750 7,622,045 (198,705) -2.54%
Township Road and Bridge Tax 401-06/16 457,360 460,000 460,000 460,000 460,210 210 0.05%
Replacement Taxes
Corporate 405-01 406,834 360,000 380,000 430,000 346,816 (13,184) -3.66%
Township Road and Bridge 405-03 12,384 12,000 12,000 12,000 14,227 2,227 18.56%
Total Replacement Taxes 419,218 372,000 392,000 442,000 361,043 (10,957) -2.95%
Sales Tax
Retail Sales Tax 421-00/04 12,330,590 12,775,000 12,775,000 12,450,000 12,472,371 (302,629) -2.37%
Auto Rental Tax 421-01 13,620 12,000 12,000 12,000 6,605 (5,395) -44.96%
Use Tax 421-03 670,183 643,500 643,500 736,375 765,696 122,196 18.99%
Total Sales Tax 13,014,393 13,430,500 13,430,500 13,198,375 13,244,672 (185,828) -1.38%
Income Tax
State Income Tax 422-00 3,401,924 3,283,830 3,283,830 3,482,850 3,362,196 78,366 2.39%
Total Income Taxes 3,401,924 3,283,830 3,283,830 3,482,850 3,362,196 78,366 2.39%
Other Taxes
Hotel/Motel Occupancy Tax 407-01 942,388 865,000 950,000 1,025,000 985,943 120,943 13.98%
Utility Tax 407-03/04 1,144,255 1,200,000 1,000,000 1,000,000 995,457 (204,543) -17.05%
Telecommunications Tax 478-06 3,217,022 3,100,000 3,100,000 3,200,000 3,210,141 110,141 3.55%
Admissions/Entertainment Tax 407-02 100,549 110,000 110,000 110,000 103,441 (6,559) -5.96%
Total Other Taxes 5,404,214 5,275,000 5,160,000 5,335,000 5,294,982 19,982 0.38%
Over (Under)
Account FY 2014/15 FY16 October 2015 March 2016 Budget
Number Actual Budget Estimate Estimate Final $ %
Permits
Building 452-00/06/05 2,618,710 2,200,000 2,300,000 2,341,000 2,539,782 339,782 15.44%
Alarm 454-03 4,865 5,000 5,000 5,000 9,110 4,110 82.20%
Total Permits 2,623,575 2,205,000 2,305,000 2,346,000 2,548,892 343,892 15.60%
Licenses
Animal 435-01 24,227 24,000 24,000 24,000 23,528 (472) -1.97%
Business/Liquor 435-02/04 314,739 335,000 335,000 350,000 330,065 (4,935) -1.47%
Vehicle 435-05, 473-35 561,340 575,000 565,000 582,045 574,211 (789) -0.14%
Total Licenses 900,306 934,000 924,000 956,045 927,804 (6,196) -0.66%
Interest Income
General Fund 426-01/02/04 49,630 50,000 50,000 50,000 102,543 52,543 105.09%
Property Tax 426-09/19 0 1,500 1,500 0 0 (1,500) -100.00%
Total Interest Income 49,630 51,500 51,500 50,000 102,543 51,043 99.11%
Fees:
RFPD Fees 451-00 2,378,697 2,665,000 2,665,000 2,665,000 2,262,060 (402,940) -15.12%
RED Center Administration Fees 451-01 20,000 20,000 20,000 20,000 20,000 0.00%
Elevator Inspections 452-01 30,685 45,000 45,000 35,500 32,265 (12,735) -28.30%
Franchise Fees:
Cable Television 478-01 716,851 700,000 700,000 750,000 755,732 55,732 7.96%
PEG Activities 478-04 - 0 0 -
Total Franchise Fees 716,851 700,000 700,000 750,000 755,732 55,732 7.96%
Alarm Services Fees:
Police Alarms 454-00/01/02 135,632 135,000 135,000 129,000 124,536 (10,464) -7.75%
Fire Alarms 459-00/01 69,003 73,500 73,500 85,000 73,293 (207) -0.28%
Total Alarm Services Fees 204,635 208,500 208,500 214,000 197,829 (10,671) -5.12%
Petitioner Fees:
Plan Commission 457-00 36,426 20,000 20,000 20,000 20,373 373 1.87%
Total Petitioner Fees 36,426 20,000 20,000 20,000 20,373 373 1.87%
Total Fees 3,387,294 3,658,500 3,658,500 3,704,500 3,288,259 (370,241) -10.12%
Over (Under)
Account FY 2014/15 FY16 October 2015 March 2016 Budget
Number Actual Budget Estimate Estimate Final $ %
Rental Income:
Commuter Station:
The Grind 461-05 7,641 7,000 7,000 7,640 7,643 643 9.19%
Total Rental Income 7,641 7,000 7,000 7,640 7,643 643 9.19%
Fines:
Ordinance Violations 458-01 45,098 60,000 50,000 40,000 25,526 (34,474) -57.46%
Traffic Court Fines 458-02 119,088 160,000 130,000 120,000 131,348 (28,652) -17.91%
Total Fines 164,186 220,000 180,000 160,000 156,874 (63,126) -28.69%
Interfund Transfers:
Sanitary Sewer Fund 475-14 489,850 509,455 509,455 509,455 509,455 0 0.00%
Senior Housing Fund 475-15 80,000 83,205 83,205 83,205 83,205 0 0.00%
Stormwater Fund 475-16 75,715 78,750 78,750 78,750 78,750 0 0.00%
Water Production Fund 475-21 658,050 684,380 684,380 684,380 684,380 0 0.00%
Water Distribution Fund 475-21 1,124,045 1,169,015 1,169,015 1,169,015 1,169,015 0 0.00%
Parking Fund 475-22 105,835 110,075 110,075 110,075 110,075 0 0.00%
Cemetary Fund 475-20/23 1,510 1,570 1,570 1,570 1,570 0 0.00%
Total Interfund Transfers 2,535,005 2,636,450 2,636,450 2,636,450 2,636,450 0 0.00%
Charges for Services:
Overtime Reimb. - Police/Fire/Dev/PW 473-13:17 82,663 60,000 60,000 63,000 58,534 (1,466) -2.44%
Antenna Lease Fees 476-01 214,808 216,710 216,710 230,638 237,200 20,490 9.46%
Sign Material Sales 477-06 0 1,000 1,000 1,000 0 (1,000) -100.00%
Reforestation Fees 477-07 13,300 15,000 15,000 15,000 7,855 (7,145) -47.63%
Toll Road Responses-Fire/EMS 477-31/32 850 3,500 3,500 1,750 1,600 (1,900) -54.29%
Ambulance Transportation Fee 480-02 1,030,957 1,000,000 1,000,000 1,050,000 1,127,507 127,507 12.75%
Glenbrook North Police Service 480-03 117,718 110,000 110,000 117,718 114,898 4,898 4.45%
Summer School Crossing Guards 480-04 6,934 7,000 6,619 6,619 6,619 (381) -5.44%
Total Charges for Services 1,467,230 1,413,210 1,412,829 1,485,725 1,554,213 141,003 9.98%
Over (Under)
Account FY 2014/15 FY16 October 2015 March 2016 Budget
Number Actual Budget Estimate Estimate Final $ %
Miscellaneous:
Surplus Equipment Sales 473-03 25,063 50,000 50,000 62,000 64,061 14,061 28.12%
Retail Sale Permits 473-06 740 6,500 5,000 2,000 950 (5,550) -85.38%
Miscellaneous Income 473-07/09/20 526,967 350,000 350,000 275,000 103,145 (246,855) -70.53%
Grants 481-15/17/18 0 57,750 57,750 800 800 (56,950)
Raffle/Facility Use Fees 473-10/18 270 500 500 375 330 (170) -34.00%
Frontage Deposit Fees 473-11 0 500 500 0 0 (500) -100.00%
State Route Maintenance 475-04 24,502 20,000 20,000 20,000 0 (20,000) -100.00%
Traffic Signal/Street Light Damage 477-03/04 0 5,000 5,000 8,000 2,969 (2,031) -40.62%
Impound Fees 477-08 195 1,000 1,000 500 80 (920) -92.00%
Miscellaneous Reimbursements 477-09/10 1,651 5,000 5,000 5,000 1,087 (3,913) -78.26%
Annexation Fees 480-19 35,601 25,000 25,000 160,000 90,949 65,949 263.80%
Bond Proceeds 406-02 1,984,476 1,501,540 1,501,540 1,501,540 4,307,454 2,805,914 186.87%
Total Miscellaneous 2,599,465 2,022,790 2,021,290 2,035,215 4,571,825 2,549,035 126.02%
TOTAL GENERAL CORPORATE FUND 44,145,960 43,790,530 43,743,649 44,120,550 46,139,651 2,349,121 5.36%
Village of Northbrook
General Corporate Fund
Expenditure Summary By Department (Without Special Revenue Funds)
FY 2015/16
November 15, 2016
FY16 FY16 Over (Under)
Original Amended FY16 Budget
Budget Budget Final $ % Reason
LEGISLATIVE
Personal Services 41,200 41,200 41,200 - 0.00%
Fringe Benefits 3,150 3,150 3,150 - 0.00%
Contractual Services 301,325 307,825 301,641 (6,184) -2.01%
Total 345,675 352,175 345,991 (6,184) -1.76%
ADMINISTRATIVE
Personal Services 1,080,620 1,080,620 1,064,143 (16,477) -1.52% Temporary part-time vacancy
Fringe Benefits 324,750 324,750 309,300 (15,450) -4.76% Temporary part-time vacancy
Contractual Services 219,545 219,545 199,533 (20,012) -9.12%
Commodities 3,500 3,500 1,051 (2,449) -69.97%
Total 1,628,415 1,628,415 1,574,027 (54,388) -3.34%
Total w/o Capital 1,628,415 1,628,415 1,574,027 (54,388) -3.34%
LEGAL
Contractual Services 640,000 640,000 595,957 (44,043) -6.88%
Total 640,000 640,000 595,957 (44,043) -6.88%
FINANCE
Personal Services 712,035 712,035 695,131 (16,904) -2.37% Temporary part-time vacancy
Fringe Benefits 251,645 251,645 246,789 (4,856) -1.93% Temporary part-time vacancy
Contractual Services 220,640 220,640 234,736 14,096 6.39%
Commodities 18,000 18,000 15,532 (2,468) -13.71%
Capital Outlay 2,500 2,500 4,250 1,750 70.00%
Total 1,204,820 1,204,820 1,196,438 (8,382) -0.70%
Total w/o Capital 1,202,320 1,202,320 1,192,188 (10,132) -0.84%
FY16 FY16 Over (Under)
Original Amended FY16 Budget
Budget Budget Final $ % Reason
INFORMATION SERVICES
Personal Services 359,940 359,940 362,555 2,615 0.73%
Fringe Benefits 133,475 133,475 125,996 (7,479) -5.60%
Deferred fly over photography for GIS
layer development. Less than
anticipated contractual assistance.
Contractual Services 975,960 975,960 724,005 (251,955) -25.82% Secondary internet provider deferred.
Commodities 1,000 1,000 311 (689) -68.90%
Capital Outlay 859,135 859,135 838,647 (20,488) -2.38%
Total 2,329,510 2,329,510 2,051,514 (277,996) -11.93%
Total w/o Capital 1,470,375 1,470,375 1,212,867 (257,508) -17.51%
POLICE
Personal Services 10,050,290 10,050,290 10,101,291 51,001 0.51%
Fringe Benefits 1,967,750 1,967,750 1,978,290 10,540 0.54%
Contractual Services 1,437,375 1,437,375 1,424,913 (12,462) -0.87%
E-Crash and E-Ticket deferred. Auto
Commodities 479,215 479,215 434,867 (44,348) -9.25% parts lower than anticipated.
Satellite receiver replacement deferred
Capital Outlay 278,400 278,400 136,395 (142,005) -51.01% pending migration to Starcomm.
Total 14,213,030 14,213,030 14,075,756 (137,274) -0.97%
Total w/o Capital 13,934,630 13,934,630 13,939,361 4,731 0.03%
FIRE
Savings due to attrition and timing of
Personal Services 8,286,745 8,286,745 8,167,240 (119,505) -1.44% replacements.
Fringe Benefits 1,510,905 1,510,905 1,525,065 14,160 0.94%
Contractual Services 1,334,595 1,334,595 1,327,246 (7,349) -0.55%
Commodities 438,790 438,790 415,829 (22,961) -5.23%
Capital Outlay 100,000 100,000 99,473 (527) -0.53%
Total 11,671,035 11,671,035 11,534,853 (136,182) -1.17%
Total w/o Capital 11,571,035 11,571,035 11,435,380 (135,655) -1.17%
FY16 FY16 Over (Under)
Original Amended FY16 Budget
Budget Budget Final $ % Reason
PUBLIC WORKS
Temporary vacancies and lower than
Personal Services 3,603,875 3,603,875 3,133,081 (470,794) -13.06% expected overtime.
Fringe Benefits 1,260,675 1,260,675 1,147,815 (112,860) -8.95% Temporary vacancies and lower than
expected overtime.
Contractual Services 2,093,795 2,093,795 1,742,351 (351,444) -16.79% Shermer Road bike path, downtown
landscape, bike Chevrons deferred to
FY 16/17.
Mild winter resulted in lower than
expected salt purchases. Fuel costs less
Commodities 1,011,495 1,011,495 716,661 (294,834) -29.15% than projected.
Public Works and Village Hall
Capital Outlay 2,163,170 2,163,170 1,150,067 (1,013,103) -46.83% improvements deferred.
Total 10,133,010 10,133,010 7,889,975 (2,243,035) -22.14%
Total w/o Capital 7,969,840 7,969,840 6,739,908 (1,229,932) -15.43%
DEVELOPMENT & PLANNING
Personal Services 1,137,770 1,137,770 1,119,971 (17,799) -1.56%
Fringe Benefits 507,660 507,660 492,560 (15,100) -2.97%
Contractual Services 595,950 595,950 609,689 13,739 2.31%
Commodities 3,750 3,750 3,241 (509) -13.57%
Capital Outlay 2,000 2,000 1,881 (119) -5.95%
Total 2,247,130 2,247,130 2,227,342 (19,788) -0.88%
Total w/o Capital 2,245,130 2,245,130 2,225,461 (19,669) -0.88%
ALL DEPARTMENTS
Total 44,412,625 44,419,125 41,491,853 (2,927,272) -6.59%
Total w/o Capital 41,007,420 41,013,920 39,261,140 (1,445,045) -3.52%
FY16 FY16 Over (Under)
Original Amended FY16 Budget
Budget Budget Final $ % Reason
TOTAL BY CLASS
Personal Services 25,272,475 25,272,475 24,684,612 (587,863) -2.33%
Fringe Benefits 5,960,010 5,960,010 5,828,965 (131,045) -2.20%
Contractual Services 7,819,185 7,825,685 7,160,071 (665,614) -8.51%
Commodities 1,955,750 1,955,750 1,587,492 (368,258) -18.83%
Capital Outlay 3,405,205 3,405,205 2,230,713 (1,174,492) -34.49%
Total 44,412,625 44,419,125 41,491,853 (2,927,272) -6.59%
PROJECTED REVENUES 43,790,530 43,790,530 46,139,651 2,349,121 5.36%
SURPLUS / (DEFICIT) (622,095) (628,595) 4,647,798
ASSIGNED BOND PROCEEDS 1,150,000 1,150,000 3,304,763
Transfer $2.4 million to Water Fund
EQUITY TRANSFER 300,000 300,000 3,300,007 and $600,000 to Sanitary Sewer Fund.
ADJUSTED SURPLUS 227,905 221,405 7,952,561
ASSIGNED BOND PROCEEDS FROM PREV. YR 1,145,963
PROJECTED FUND BALANCE 22,288,425 22,281,925 21,249,511
Fund Balance as a % of Revenue 50.9% 50.9% 46.1%
Fund Balance as a % of Expense 50.2% 50.2% 51.2%
Fund Balance above 40% policy 4,772,213 4,765,713 2,793,651
Quarterly Overtime Report
Fiscal Year 2015/16
First Second Third Fourth
Budget Qtr. Qtr. Qtr. Qtr. Total
General Government
Regular overtime 2,202.08 1,247.93 4,060.22 3,916.47 11,426.70
Family dinner
Total General Government 5,000 2,202.08 1,247.93 4,060.22 3,916.47 11,426.70
Finance Department
Vehicle licenses 1,388.80 1,388.80
Regular overtime 1,106.71 4,834.51 4,965.62 7,202.46 18,109.30
-
Total Finance Department 9,000 2,495.51 4,834.51 4,965.62 7,202.46 19,498.10
Police Department
Roll call 33,654.28 33,216.26 33,603.90 33,702.90 134,177.34
FLSA 26,983.64 25,152.22 25,510.88 18,142.56 95,789.30
Shift holdover 10,535.17 8,506.15 7,476.22 15,282.97 41,800.51
Regular/Speciality recall 22,998.27 23,363.43 21,745.68 26,148.92 94,256.30
Meetings/Training 59,886.41 59,662.92 72,896.72 10,850.24 203,296.29
Special Assignments 12,934.00 5,888.64 7,426.06 3,230.67 29,479.37
Private details (reimbursable) 7,859.95 11,910.62 7,080.79 6,153.41 33,004.77
Court time 23,842.36 18,076.12 19,444.48 18,804.00 80,166.96
Minimum manning 70,148.94 59,214.88 64,399.12 35,485.45 229,248.39
Northbrook Days (partial reimb.) - 28,753.55 - 28,753.55
Community relations 3,992.47 1,925.63 325.35 2,296.39 8,539.84
Quarterly Overtime Report
Fiscal Year 2015/16
First Second Third Fourth
Budget Qtr. Qtr. Qtr. Qtr. Total
Police Department (cont.)
4th of July 15,811.15 1,351.05 686.93 - 17,849.13
NIPAS/NORTAF 9,112.06 18,641.12 1,953.40 12,947.27 42,653.85
-
Total Overtime Worked 297,758.70 295,662.59 262,549.53 183,044.78 1,039,015.60
LESS: Hours accumulated as PTO (121,326.97) (124,783.02) (135,292.31) $ 287,837.49 (93,564.81)
Overtime Paid Out 697,975 176,431.73 170,879.57 127,257.22 470,882.27 945,450.79
Fire Department
FLSA 13,484.54 12,668.35 14,474.52 $ 11,322.73 51,950.14
Shift holdover 4,453.46 4,892.49 5,505.06 $ 3,843.59 18,694.60
Regular/recall 5,259.01 13,392.80 12,220.64 $ 1,297.50 32,169.95
Meetings/Training 12,374.07 18,428.28 16,605.73 $ 12,111.61 59,519.69
Special teams training 28,775.00 9,707.46 9,700.72 $ 13,408.20 61,591.38
Minimum manning 83,702.11 57,497.97 52,982.04 $ 93,852.11 288,034.23
CERT Training (REIMBURS) 681.00 1,076.39 680.97 $ 1,247.03 3,685.39
FLS Inspections $ 4,069.58 4,069.58
Administrative Work $ 6,747.47 6,747.47
Open House
Northbrook Days 5,518.00 5,518.00
4th of July 948.00 948.00
Total Overtime Worked 149,677.19 123,181.74 112,169.68 147,899.82 532,928.43
LESS: Hours accumulated as PTO (19,777.01) (18,991.09) (26,766.66) (2,326.02) (67,860.78)
Overtime Paid Out 450,220 129,900.18 104,190.65 85,403.02 145,573.80 465,067.65
Quarterly Overtime Report
Fiscal Year 2015/16
First Second Third Fourth
Budget Qtr. Qtr. Qtr. Qtr. Total
Public Works
Streets & sidewalks 1,814.52 2,884.80 568.79 5,268.11
Snow & Ice control 58,446.50 28,132.78 86,579.28
Parkway & street lights 524.90 295.28 203.00 164.45 1,187.63
Storm sewer 852.82 183.48 1,681.78 1,198.50 3,916.58
Sanitary sewer 2,290.99 2,207.71 5,072.18 3,412.44 12,983.32
Village building 847.85 134.12 1,385.97 1,184.38 3,552.32
Fleet 1,400.36 401.67 1,319.72 1,319.02 4,440.77
Water Production & Dist. 16,405.79 13,459.66 12,853.27 13,316.36 56,035.08
Water main breaks 1,840.05 11,117.38 4,745.40 8,934.79 26,637.62
JULIE Locates 3,298.23 4,286.13 1,694.49 1,015.04 10,293.89
Engineering plan review & insp. 7,803.23 4,069.86 2,394.07 4,060.82 18,327.98
Northbrook Days
Family Dinner 1,956.83 1,956.83
Earth Day 5,771.46 5,771.46
Misc. Special Events 1,107.30 341.42 1,448.72
4th of July 4,409.16 4,409.16
Roll call 5,264.50 4,978.26 4,391.34 5,318.54 19,952.64
Trees & storm damage 3,360.52 1,801.82 2,230.04 2,200.85 9,593.23
Quarterly Overtime Report
Fiscal Year 2015/16
First Second Third Fourth
Budget Qtr. Qtr. Qtr. Qtr. Total
Public Works (cont.)
Total Overtime Worked 51,220.22 46,161.59 98,374.59 76,598.22 272,354.62
LESS: Hours accumulated as PTO (19,081.38) (21,210.38) (48,641.95) (41,744.19) (130,677.90)
Overtime Paid Out 358,620 32,138.84 24,951.21 49,732.64 34,854.03 141,676.72
General Fund 217,810 13,501.90 10,108.90 26,281.43 15,524.32 65,416.55
Water Fund 98,420 13,735.12 12,355.46 16,537.81 13,070.08 55,698.47
Sewer Fund 21,195 4,500.65 2,459.17 6,452.03 6,259.63 19,671.48
Storm Water Fund 21,195 401.17 27.68 461.37 - 890.22
358,620 32,138.84 24,951.21 49,732.64 34,854.03 141,676.72
Development & Planning Services
Regular overtime 2,992.38 5,128.83 3,439.69 4,441.60 16,002.50
Total Dev. & Planning Services 8,160 2,992.38 5,128.83 3,439.69 4,441.60 16,002.50
Total Overtime paid Out 1,528,975 346,160.72 311,232.70 274,858.41 666,870.63 1,599,122.46
Hours accumulated as PTO 160,185.36 164,984.49 210,700.92 (243,767.28) 535,870.77
GRAND TOTAL 1,528,975 506,346.08 476,217.19 485,559.33 423,103.35 1,891,225.95
Comparative Overtime Report
First Quarter Second Quarter Third Quarter Fourth Quarter Total
FY 14/15 FY 15/16 FY 14/15 FY 15/16 FY 14/15 FY 15/16 FY 14/15 FY 15/16 FY 14/15 FY 15/16
General Government
Regular overtime 1,366.20 2,202.08 907.74 1,247.93 2,969.59 4,060.22 1,809.39 3,916.47 7,052.92 11,426.70
General Government 1,366.20 2,202.08 907.74 1,247.93 2,969.59 4,060.22 1,809.39 3,916.47 7,052.92 11,426.70
Finance Department
Vehicle licenses 927.07 1,106.21 927.07 1,106.21
Regular overtime 1,254.28 1,389.30 1,759.59 4,834.51 1,265.17 4965.62 3,226.99 7,202.46 7,506.03 18,391.89 ERP Implementation
Finance Department 2,181.35 2,495.51 1,759.59 4,834.51 1,265.17 4,965.62 3,226.99 7,202.46 8,433.10 19,498.10
Comparative Overtime Report
First Quarter Second Quarter Third Quarter Fourth Quarter Total
FY 14/15 FY 15/16 FY 14/15 FY 15/16 FY 14/15 FY 15/16 FY 14/15 FY 15/16 FY 14/15 FY 15/16
Police Department
Roll call 32,708.06 33,654.28 32,975.91 33,216.26 32,975.91 33,603.90 32,975.91 33,702.90 131,635.79 134,177.34 Preparation and participation
in daily roll call, checking
equipment, and providing
assignments at the beginning
of each shift.
FLSA 23,942.32 26,983.64 24,123.88 25,152.22 24,977.62 25,510.88 23,586.56 18,142.56 96,630.38 95,789.30 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 12,332.47 10,535.17 12,138.77 8,506.15 14,571.79 7,476.22 10,587.94 15,282.97 49,630.97 41,800.51 Completion of arrest or
assignment which occurs
near end of a shift.
Regular/Speciality 27,360.08 22,998.27 15,569.97 23,363.43 32,465.17 21,745.68 18,808.05 26,148.92 94,203.27 94,256.30 Need based recall of officers
recall 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 14/15 FY 15/16 FY 14/15 FY 15/16 FY 14/15 FY 15/16 FY 14/15 FY 15/16 FY 14/15 FY 15/16
Meetings/Training 30,701.32 59,886.41 13,656.25 59,662.92 57,760.06 72,896.72 10,834.86 10,850.24 112,952.49 203,296.29 Primarily comprised of
required training which
cannot be completed while
on duty. Also includes
special team meetings as
needed. Costs for the
Emergency Readiness Drill
are included in FY 15/16.
Other increases are due to
the timing of trainings.
Special Assignments 8,547.84 12,934.00 2,492.42 5,888.64 2,293.50 7,426.06 3,850.30 3,230.67 17,184.06 29,479.37
Private details 7,113.35 7,859.95 12,881.70 11,910.62 13,445.76 7,080.79 5,622.08 6,153.41 39,062.89 33,004.77
(reimbursable)
Court time 19,997.89 23,842.36 22,439.40 18,076.12 20,127.56 19,444.48 23,138.40 18,804.00 85,703.25 80,166.96
Minimum manning 44,045.44 70,148.94 80,032.52 59,214.88 58,840.42 64,399.12 50,072.75 35,485.45 232,991.13 229,248.39 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. Q4 reductions
are due to the Department
being fully staffed.
Northbrook Days 317.46 23,759.32 28,753.55 24,076.78 28,753.55
(partial reimb.)
Community relations 4,643.97 3,992.47 3,226.50 1,925.63 131.85 325.35 2,090.24 2,296.39 10,092.56 8,539.84 Includes National Night Out
and other community events.
4th of July 15,152.22 15,811.15 838.71 1,351.05 984.45 686.93 16,975.38 17,849.13
NIPAS/NORTAF 11,823.07 9,112.06 18,915.41 18,641.12 5,699.35 1,953.40 4,416.30 12,947.27 40,854.13 42,653.85
Police Department 238,685.49 297,758.70 263,050.76 295,662.59 264,273.44 262,549.53 185,983.39 183,044.78 951,993.08 1,039,015.60
Comparative Overtime Report
First Quarter Second Quarter Third Quarter Fourth Quarter Total
FY 14/15 FY 15/16 FY 14/15 FY 15/16 FY 14/15 FY 15/16 FY 14/15 FY 15/16 FY 14/15 FY 15/16
Fire Department
FLSA 9,176.00 13,484.54 9,721.00 12,668.35 16,006.26 14,474.52 12,705.69 $ 11,322.73 47,608.95 51,950.14 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 6,264.00 4,453.46 4,630.87 4,892.49 5,117.82 5,505.06 4,188.10 $ 3,843.59 20,200.79 18,694.60 Completion of an emergency
call which occurs near the
end of a shift.
Regular/recall 3,611.00 5,259.01 7,616.39 13,392.80 3,662.26 12,220.64 7,091.31 $ 1,297.50 21,980.96 32,169.95 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. The
increases in the second and
third quarter are due to
increased call volume.
Comparative Overtime Report
First Quarter Second Quarter Third Quarter Fourth Quarter Total
FY 14/15 FY 15/16 FY 14/15 FY 15/16 FY 14/15 FY 15/16 FY 14/15 FY 15/16 FY 14/15 FY 15/16
Meetings/Training 14,827.00 12,374.07 23,276.23 18,428.28 14,901.30 16,605.73 31,739.90 $ 12,111.61 84,744.43 59,519.69 Required training which
cannot be completed while
on duty. Also includes
special team meetings as
needed. The high total in the
fourth quarter of FY 14/15 is
due to a higher training
volume in that quarter,
including a night drill.
Special teams training 32,640.00 28,775.00 17,934.00 9,707.46 15,164.54 9,700.72 9,836.87 $ 13,408.20 75,575.41 61,591.38 Specialized training for Dive,
Technical Rescue, and
Hazmat teams which cannot
be completed while on duty.
The decrease in FY 15/16 is
due to decreased enrollment
in special teams.
Minimum manning 85,950.00 83,702.11 55,484.00 57,497.97 82,737.22 52,982.04 38,667.71 $ 93,852.11 262,838.93 288,034.23 Hireback of
firefighters/paramedics to
maintain minimum required
staffing of shift. Mainly
occurs when a firefighter is
ill or injured.
CERT Training 1,693.00 681.00 1,115.00 1,076.39 1,454.77 680.97 2,273.47 $ 1,247.03 6,536.24 3,685.39
(REIMBURS)
FLS Inspections $ 4,069.58 4,069.58 7 G positions which
supplement FPB staff
Administrative Work $ 6,747.47 6,747.47 7 G positions which focus on
training and community
engagement
Open house 844.00 844.00
Northbrook Days 5,315.00 4,822.00 5,518.00 10,137.00 5,518.00
4th of July 2,045.00 948.00 2,045.00 948.00
Fire Department 161,521.00 149,677.19 125,443.49 123,181.74 139,044.17 112,169.68 106,503.05 147,899.82 532,511.71 532,928.43
Comparative Overtime Report
First Quarter Second Quarter Third Quarter Fourth Quarter Total
FY 14/15 FY 15/16 FY 14/15 FY 15/16 FY 14/15 FY 15/16 FY 14/15 FY 15/16 FY 14/15 FY 15/16
Public Works
Streets & sidewalks 3,012.22 1,814.52 2,135.25 2,884.80 154.18 619.21 568.79 5,920.86 5,268.11
Snow & Ice control 75,865.75 58,446.50 85,997.08 28,132.78 161,862.83 86,579.28 A mild winter led to fewer
snow and ice control call
outs.
Parkway & street lights 442.93 524.90 442.92 295.28 955.88 203.00 275.58 164.45 2,117.31 1,187.63
Storm sewer 5,493.68 852.82 4,172.15 183.48 257.94 1,681.78 1,528.82 1,198.50 11,452.59 3,916.58
Sanitary sewer 3,457.72 2,290.99 1,217.21 2,207.71 2,696.50 5,072.18 3,360.05 3,412.44 10,731.48 12,983.32
Village building 2,447.97 847.85 5,144.88 134.12 2,708.50 1,385.97 3,160.44 1,184.38 13,461.79 3,552.32
Fleet 1,056.53 1,400.36 348.38 401.67 1,928.47 1,319.72 1,844.35 1,319.02 5,177.73 4,440.77
Water Production & 23,282.60 16,405.79 21,838.14 13,459.66 22,087.89 12,853.27 11,392.63 13,316.36 78,601.26 56,035.08
Dist.
Water main breaks 9,617.21 1,840.05 10,337.32 11,117.38 19,108.47 4,745.40 7,303.75 8,934.79 46,366.75 26,637.62 There have been fewer water
main break repairs on
overtime.
JULIE Locates 2,950.83 3,298.23 1,956.15 4,286.13 1,610.80 1,694.49 2,529.66 1,015.04 9,047.44 10,293.89
Engineering plan 1,292.58 7,803.23 8,342.09 4,069.86 3,156.67 2,394.07 3,022.71 4,060.82 15,814.05 18,327.98
review & insp.
Northbrook Days -
Family Dinner 2,229.45 1,956.83 2,229.45 1,956.83
Earth Day 4,568.52 5,771.46 4,568.52 5,771.46
Misc. Special Events 1,036.00 1,107.30 192.51 341.42 1,228.51 1,448.72
4th of July 5,882.87 4,409.16 5,882.87 4,409.16
Roll call 5,432.75 5,264.50 5,442.52 4,978.26 5,442.52 4,391.34 5,442.52 5,318.54 21,760.31 19,952.64
Trees & storm damage 2,492.95 3,360.52 27,775.50 1,801.82 916.62 2,230.04 930.19 2,200.85 32,115.26 9,593.23
Public Works 67,898.84 51,220.22 89,345.02 46,161.59 139,119.64 98,374.59 131,975.51 76,598.22 428,339.01 272,354.62
Department
Comparative Overtime Report
First Quarter Second Quarter Third Quarter Fourth Quarter Total
FY 14/15 FY 15/16 FY 14/15 FY 15/16 FY 14/15 FY 15/16 FY 14/15 FY 15/16 FY 14/15 FY 15/16
Development &
Planning Services
Regular overtime 739.21 2,992.38 2,929.47 5,128.83 2,967.87 3,439.69 1,641.65 4441.60 8,278.20 16,002.50 770 Skokie Inspections.
Dev. & Planning 739.21 2,992.38 2,929.47 5,128.83 2,967.87 3,439.69 1,641.65 4,441.60 8,278.20 16,002.50
Services
GRAND TOTAL 472,392.09 506,346.08 483,436.07 476,217.19 549,639.88 485,559.33 431,139.98 423,103.35 1,936,608.02 1,891,225.95
-
VILLAGE OF NORTHBROOK
Effective Interest - Actual Life
Receipts in Period
4/30/2016
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 19,749,174.00 19,749,174.00 0.00 19,749,174 19,749,174
CASH - E-PAY 0.0150 5,214,668.00 5,214,668.00 5,214,668 5,214,668
CASH - DISBURSEMENT 0.0150 7,606.00 7,606.00 7,606 7,606
CASH - SENIOR HOUSING (Closed 4/15) 0.0150 0.00 0.00 0.00 0.00 - -
CASH - SENIOR HOUSING SECURITY DEPOSITIS 0.0150 96,976.00 96,976.00 96,976 96,976
CASH - COMMUTER PARKING 0.0150 178,724.00 178,724.00 178,724 178,724
CASH - MFT 0.0150 871,118.00 871,118.00 871,118 871,118
CASH - E-911 0.0150 124,872.00 124,872.00 124,872 124,872
CASH - DRUG FORFEITURE 0.0150 10,143.00 10,143.00 10,143 10,143
1300 - THE ILLINOIS FUNDS Total 26,253,281.00 26,253,281.00 0.00 0.00 26,253,281 26,253,281
1300 - THE ILLINOIS FUNDS Total 26,253,281.00 26,253,281.00 0.00 0.00 26,253,281 26,253,281
4600 - NORTHBROOK BANK & TRUST 8100009643 MAXSAFE TM PUBLIC 10/20/11 OPEN 0.2000 1,353,711.00 1,353,711.00 0.00 0.00 1,353,711 1,353,711
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,551,150.00 4,551,150.00 0.00 0.00 4,551,150 4,551,150
7500014368 AR-0029 MONEY MARKET 07/08/08 OPEN 0.0800 3,794,852.00 3,794,852.00 0.00 0.00 3,794,852 3,794,852
CASH - PAYROLL 0.0000 0.00 0.00 0.00 0.00 - -
CASH - SENIOR HOUSING 0.0300 1,050,066.00 1,050,066.00 0.00 0.00 1,050,066 1,050,066
CASH - ANGEL 0.0300 23,161.00 23,161.00 0.00 0.00 23,161 23,161
CASH - DISBURSEMENT 0.0000 9.00 9.00 0.00 0.00 9 9
4600 - NORTHBROOK BANK & TRUST Total 15,272,949.00 15,272,949.00 0.00 0.00 15,272,949.00 15,272,949.00
4600 - NORTHBROOK BANK & TRUST Total 15,272,949.00 15,272,949.00 0.00 0.00 15,272,949.00 15,272,949.00
5000 - FIRST BANK OF HIGHLAND PARK 52006511 AR-0028 MONEY MARKET 02/08/07 Open 0.4500 30,955,650.00 30,955,650.00 0.00 0.00 30,955,650 30,955,650
52005698 CASH-DISBURSEMENT 09/21/15 0.00 0.00 0.00 0.00 - -
XXXX0101 CERTIFICATE OF DEPOSIT 08/20/15 0.8500 10,056,963.00 10,056,963.00 0.00 0.00 10,056,963 10,056,963
5000 -FIRST BANK OF HIGHLAND PARK Total 41,012,613.00 41,012,613.00 0.00 0.00 41,012,613.00 41,012,613.00
5000 - FIRST BANK OF HIGHLAND PARK Total 41,012,613.00 41,012,613.00 0.00 0.00 41,012,613.00 41,012,613.00
Investment Total
82,538,843 82,538,843 - - 82,538,843 82,538,843
Page 1 of 1
VILLAGE OF NORTHBROOK POLICE AND FIREFIGHTER'S PENSION FUNDS
Effective Interest - Actual Life
Receipts in Period
4/30/2016
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 1,549,928.00 1,549,928.00 0.00 0.00 1,549,928 1,549,928
139124585 AR-0002 Treasurs Pool 04/30/95 Open 0.0150 0.0000 1.000000 1,607,692.00 1,607,692.00 0.00 0.00 1,607,692 1,607,692
1300 - THE ILLINOIS FUNDS Total 0.0150 0.0000 1.000000 3,157,620.00 3,157,620.00 0.00 0.00 3,157,620 3,157,620
1300 - THE ILLINOIS FUNDS Total 0.0150 0.0000 1.000000 3,157,620.00 3,157,620.00 0.00 0.00 3,157,620 3,157,620
2400 - VANGUARD GROUP 919946557 AR-0010 VANGUARD 06/22/98 Open 0.0000 0.0000 1.000000 7,400,917.00 7,400,917.00 0.00 0.00 7,400,917 7,400,917
2400 - VANGUARD GROUP Total 0.0000 0.0000 1.000000 7,400,917.00 7,400,917.00 0.00 0.00 7,400,917.00 7,400,917.00
2400 - VANGUARD GROUP Total 0.0000 0.0000 1.000000 7,400,917.00 7,400,917.00 0.00 0.00 7,400,917.00 7,400,917.00
2500- FIRST BANK OF HIGHLAND PARK 52006244 HIGH YIELD 02/01/16 Open 0.0000 0.0000 1.000000 715,102.00 715,102.00 0.00 0.00 715,102 715,102
52006252 HIGH YIELD 02/01/16 Open 0.0000 0.0000 1.000000 746,144.00 746,144.00 0.00 0.00 746,144 746,144
2500 - FIRST BANK OF HIGHLAND PARK Total 0.0000 0.0000 1.000000 1,461,246.00 1,461,246.00 0.00 0.00 1,461,246.00 1,461,246.00
2500 - FIRST BANK OF HIGHLAND PARK Total 0.0000 0.0000 1.000000 1,461,246.00 1,461,246.00 0.00 0.00 1,461,246.00 1,461,246.00
2800 - FIRST TENNESSEE
452152QJ3 15-0096 ILLINOIS ST 2.42 04/01/17 08/08/14 OPEN 1.8103 1.8103 1.015680 600,000.00 607,806.00 -7,806.00 0.00 607,806.00 602,670.00
452152QJ3 15-0101 ILLINOIS ST 2.42 04/01/17 08/08/14 OPEN 1.8103 1.8103 1.015680 600,000.00 607,806.00 -7,806.00 0.00 607,806.00 602,670.00
167505JY3 15-0275 CHICAGO BRD ED BUILD AMER 4.682 12/01/17 03/26/15 OPEN 2.7500 2.7500 1.049560 450,000.00 472,302.00 -22,302.00 0.00 472,302.00 368,000.00
167505JY3 15-0296 CHICAGO BRD ED BUILD AMER 4.682 12/01/17 03/26/15 OPEN 2.7500 2.7500 1.049560 400,000.00 419,824.00 -19,824.00 0.00 419,824.00 368,000.00
777543UL1 15-0300 ROSEMONT IL 4.72 12/01/18 04/20/15 OPEN 1.8501 1.8501 1.099860 200,000.00 219,972.00 -19,972.00 0.00 219,972.00 215,450.00
777543UL1 15-0312 ROSEMONT IL 4.72 12/01/18 04/20/15 OPEN 1.8501 1.8501 1.099860 200,000.00 219,972.00 -19,972.00 0.00 219,972.00 215,450.00
452152HS3 ILLINOIS ST 5.365 3/1/17 12/18/15 Open 500,000.00 518,665.00 -18,665.00 0.00 518,665.00 514,249.81
452152HS3 ILLINOIS ST 5.365 3/1/17 12/18/15 Open 500,000.00 518,665.00 -18,665.00 0.00 518,665.00 514,249.81
06051GEK1 BANK OF AMERICA CORP 3.75 7/12/16 11/25/15 OPEN 450,000.00 458,154.00 -8,154.00 0.00 458,154.00 452,452.00
06051GEK1 BANK OF AMERICA CORP 3.75 7/12/16 11/25/15 Open 450,000.00 458,154.00 -8,154.00 0.00 458,154.00 452,452.00
94974BFW5 WELLS FARGO COM MTN 1.150% 6/2/17 02/29/16 OPEN 250,000.00 250,000.00 0.00 0.00 250,000.00 250,180.00
94974BFW5 WELLS FARGO COM MTN 1.150% 6/2/17 02/29/16 OPEN 250,000.00 250,000.00 0.00 0.00 250,000.00 250,180.00
2800 - FIRST TENNESSEE Total 3.1529 3.0091 1.026634 4,850,000.00 5,001,320.00 -151,320.00 0.00 5,001,320.00 4,806,003.61
2800 - FIRST TENNESSEE Total 3.1529 3.0091 1.026634 4,850,000.00 5,001,320.00 -151,320.00 0.00 5,001,320.00 4,806,003.61
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 70,196
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,481
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 817
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,551
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,375
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 237,690
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,106
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,208
315805655 FIDELITY ADVISORS SMALL CAP CL I Open 0.0000 0.0000 4,891.72 130,394.64 0.00 0.00 130,395 125,570
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 19,847
543069405 03-0085 LONGLEAF PARTNERS INTL FUND 11/13/02 Open 0.0000 0.0000 9.469882 392.46 3,716.55 -3,324.09 0.00 3,717 5,114
471023648 07-0051 LONGLEAF PARTNERS INTL FUND 11/08/06 Open 0.0000 0.0000 18.240000 147.26 2,685.94 2,686 1,919
543069405 07-0087 LONGLEAF PARTNERS INTL FUND 12/27/06 Open 0.0000 0.0000 18.944100 1.65 31.22 31 21
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 987
543069405 08-0078 LONGLEAF PARTNERS INTL FUND 11/09/07 Open 0.0000 0.0000 20.259900 218.78 4,432.47 4,432 2,851
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 44,194
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,198
543069405 09-0148 LONGLEAF PARTNERS INTL FUND 11/07/08 Open 0.0000 0.0000 10.350000 242.50 2,509.89 2,510 3,160
543069405 09-0167 LONGLEAF PARTNERS INTL FUND 12/31/08 Open 0.0000 0.0000 10.942200 13.86 151.66 152 181
543069405 09-0197 LONGLEAF PARTNERS INTL FUND 01/02/09 Open 0.0000 0.0000 10.941200 19.93 218.06 218 260
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 50,661
543069405 11-0153 LONGLEAF PARTNERS INTL FUND 12/31/10 Open 0.0000 0.0000 15.378981 31.40 482.90 483 409
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,214
3000 - CHARLES SCHWAB Total 0.0000 0.0000 14.768316 33,555 640,168 (4,521) - 640,170 690,046
3000 - CHARLES SCHWAB Total 0.0000 0.0000 14.768316 33,555 640,168 (4,521) - 640,170 690,046
3100 - WILLIAM BLAIR
Page 1 of 7
912810RJ9 US TREASURY BOND 3.00% 11/15/44 01/27/16 Open 0.0000 0.0000 300,000.00 311,273.70 -11,273.70 0.00 311,274 321,081
912810RJ9 US TREASURY BOND 3.00% 11/15/44 01/27/16 Open 0.0000 0.0000 300,000.00 311,273.70 -11,273.70 0.00 311,274 321,081
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
17252MAJ9 CINTAS CORP NO 2 2.85 6/1/16 11/30/15 Open 265,000.00 267,438.00 -2,438.00 0.00 267,438 265,416
17252MAJ9 CINTAS CORP NO 2 2.85 6/1/16 11/30/15 OPEN 265,000.00 267,438.00 -2,438.00 0.00 267,438 265,416
912810RJ9 US TREASURY BOND 3.00% 11/15/44 04/15/16 Open 0.0000 0.0000 350,000.00 379,367.00 -29,367.00 0.00 379,367 374,595
912810RJ9 US TREASURY BOND 3.00% 11/15/44 04/15/16 OPEN 0.0000 0.0000 350,000.00 379,367.00 -29,367.00 0.00 379,367 374,595
970648AD3 WILLIS NORTH AMERICA 6.200% 3/28/17 04/20/16 Open 0.0000 0.0000 300,000.00 312,516.00 -12,516.00 0.00 312,516 312,009
970648AD3 WILLIS NORTH AMERICA 6.200% 3/28/17 04/20/16 OPEN 0.0000 0.0000 300,000.00 312,516.00 -12,516.00 0.00 312,516 312,009
743410AW2 PROLOGIS 6.875% 3/15/20 04/21/16 Open 0.0000 0.0000 135,000.00 148,070.00 -13,070.00 0.00 148,070 148,297
743410AW2 PROLOGIS 6.875% 3/15/20 04/24/16 OPEN 0.0000 0.0000 135,000.00 148,070.00 -13,070.00 0.00 148,070 148,297
361448AK9 GATX CORP 3.500% 7/15/16 04/21/16 Open 0.0000 0.0000 600,000.00 603,438.00 -3,438.00 0.00 603,438 602,730
361448AK9 GATX CORP 3.500% 7/15/16 04/21/16 OPEN 0.0000 0.0000 400,000.00 402,292.00 -2,292.00 0.00 402,292 401,820
345397VX8 FORD MOTOR CREDIT 4.250% 2/3/17 03/07/16 Open 0.0000 0.0000 500,000.00 510,570.00 -10,570.00 0.00 510,570 510,635
3100 - WILLIAM BLAIR Total 0.580600 0.5806 1.014884 4,200,000 4,353,629 (153,629) - 4,353,629 4,357,980
3100 - WILLIAM BLAIR Total 0.900200 0.9002 1.036760 4,200,000 4,353,629 (153,629) - 4,353,629 4,357,980
3200-HILLTOP SECURITIES, INC 127055AG6 CABOT CORP 5.00% 10/1/16 03/09/16 OPEN 0.0000 0.0000 245,000.00 249,451.00 -4,951.00 0.00 249,451 248,234
127055AG6 CABOT CORP 5.00% 10/1/16 03/09/16 OPEN 0.0000 0.0000 245,000.00 249,451.00 -4,951.00 0.00 249,451 248,234
3200 - HILLTOP SECURITIES INC Total 0.580600 0.5806 1.014884 490,000 498,902 (9,902) - 498,902 496,468
3200 - HILLTOP SECURITIES INC Total 0.900200 0.9002 1.036760 490,000 498,902 (9,902) - 498,902 496,468
3600 - MISCHLER FINANCIAL GROUP INC 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 157,603
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 525,346
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 157,603
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 525,346
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 177,800
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 266,700
925524BB5 VIACOM INC 6.250% 4/30/16 01/04/16 250,000.00 256,817.78 -6,817.78 0.00 256,818 250,000
345397VX8 FORD MOTOR CREDIT 4.25% 2/3/17 01/13/16 500,000.00 520,999.00 -20,999.00 0.00 520,999 510,635
140420ND8 CAPITAL ONE BANK MTN 1.15% 11/21/16 01/29/16 250,000.00 250,383.06 -383.06 0.00 250,383 250,180
959802AB5 WESTERN UNION CO 5.930% 10/1/16 01/29/16 200,000.00 210,017.44 -10,017.44 0.00 210,017 203,970
240019BS7 DAYTON POWER LIGHT 1.875% 9/15/16 01/29/16 400,000.00 403,911.67 -3,911.67 0.00 413,912 400,992
925524BB5 VIACOM INC 6.250% 4/30/16 01/04/16 250,000.00 256,817.78 -6,817.78 0.00 256,818 250,000
345397VX8 FORD MOTOR CREDIT 4.25% 2/3/17 01/13/16 500,000.00 520,999.00 -20,999.00 0.00 520,999 510,635
140420ND8 CAPITAL ONE BANK MTN 1.15% 11/21/16 01/29/16 250,000.00 250,383.06 -383.06 0.00 250,383 250,180
959802AB5 WESTERN UNION CO 5.930% 10/1/16 01/29/16 200,000.00 210,017.44 -10,017.44 0.00 210,017 203,970
240019BS7 DAYTON POWER LIGHT 1.875% 9/15/16 01/29/16 400,000.00 403,911.67 -3,911.67 0.00 413,912 400,992
345397WA7 FORD MOTOR CREDIT CO 3.984 6/15/16 12/09/15 600,000.00 608,106.00 -8,106.00 0.00 608,106 602,058
172967GW5 CITIGROUP INC 1.70 7/25/16 12/14/15 500,000.00 501,465.00 -1,465.00 0.00 501,465 500,665
345397WA7 FORD MOTOR CREDIT CO 3.984 6/15/16 12/09/15 600,000.00 608,106.00 -8,106.00 0.00 608,106 602,058
172967gw5 CITIGROUP INC 1.70 7/25/16 12/14/15 500,000.00 501,465.00 -1,465.00 0.00 501,465 500,665
345397WJ8 FORD MOTOR CREDIT CO 1.70 5/9/16 09/03/15 400,000.00 401,316.00 -1,316.00 0.00 401,316 400,044
345397WJ8 FORD MOTOR CREDIT CO 1.70 5/9/16 09/03/15 400,000.00 401,316.00 -1,316.00 0.00 401,316 400,044
216871AC7 COOPER US INC 6.10% 7/1/17 02/29/16 200,000.00 212,450.00 -12,450.00 0.00 212,450 210,342
216871AC7 COOPER US INC 6.10% 7/1/17 02/29/16 200,000.00 212,450.00 -12,450.00 0.00 212,450 210,342
031162AV2 AMGEN INC 5.80% 6/1/17 03/09/16 290,000.00 305,645.00 -15,645.00 0.00 305,645 304,410
031162AV2 AMGEN INC 5.80% 6/1/17 03/09/16 290,000.00 305,645.00 -15,645.00 0.00 305,645 304,410
55616XAA5 MACYS RETAIL HLDGS 7.450% 7/15/17 03/11/16 275,000.00 295,537.00 -20,537.00 0.00 295,537 293,573
55616XAA5 MACYS RETAIL HLDGS 7.450% 7/15/17 03/11/16 275,000.00 295,537.00 -20,537.00 0.00 295,537 293,573
025816AX7 AMERICAN EXPRESS 6.150% 8/28/17 03/31/16 500,000.00 532,705.00 -32,705.00 0.00 532,705 530,685
025816AX7 AMERICAN EXPRESS 6.150% 8/28/17 03/31/16 500,000.00 532,705.00 -32,705.00 532,705 530,685
3600 - MISCHLER FINANCIAL GROUP, INC. Total 2.0903 2.0903 1.048388 10,530,721.00 10,896,894.69 -366,172.69 0.00 10,916,893.78 10,725,506.00
3600 - MISCHLER FINANCIAL GROUP, INC. Total 2.0903 2.0903 1.048388 10,530,721.00 10,896,894.69 -366,172.69 0.00 10,916,893.78 10,725,506.00
4600 - BMO HARRIS 3175346 Cash Open 0.0500 0.0000 1.000000 9,878.00 9,878.00 0.00 0.00 9,878 9,878
3175221 Cash Open 0.0500 0.0000 1.000000 10,178.00 10,178.00 0.00 0.00 10,178 10,178
4600 - BMO HARRIS Total 0.0500 0.9098 1.000000 20,056.00 20,056.00 0.00 0.00 20,056.00 20,056
4600 - BMO HARRIS Total 0.0500 0.9098 1.000000 20,056.00 20,056.00 0.00 0.00 20,056.00 20,056
4900 - PERSHING 36212UVW8 08-0004 GNMA #544329 5.00 1/15/22 12/23/04 Open 5.1363 5.1363 0.991250 174,097.79 172,574.43 1,523.36 0.00 172,574 152,290
36202FVF0 12-0081 GNMA #005114 4.00 7/20/41 08/18/11 Open 3.4812 3.4812 1.065517 424,094.22 452,699.00 -38,000.00 0.00 452,699 377,434
61746BDB9 14-0268 MORGAN STANLEY MTN 5.75 10/18/16 03/21/14 Open 1.2637 1.2637 1.113300 400,000.00 445,320.00 -45,320.00 0.00 445,320 408,532
61746BDB9 14-0269 MORGAN STANLEY MTN 5.75 10/18/16 03/21/14 Open
Page 2 of 7 1.2637 1.2637 1.113300 300,000.00 333,950.00 -33,990.00 0.00 333,950 306,399
451102BB2 15-0020 ICAHN ENTERPRISES 4.875 3/15/19 05/23/14 Open 4.2016 4.2016 1.029000 200,000.00 205,800.00 -5,800.00 0.00 205,800 198,500
451102BB2 15-0021 ICAHN ENTERPRISES 4.875 3/15/19 05/23/14 Open 4.2016 4.2016 1.029000 300,000.00 308,700.00 -8,700.00 0.00 308,700 297,750
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
452152FV8 15-0109 ILLINOIS ST 4.875 7/1/16 09/05/14 Open 1.2949 1.2949 1.064250 350,000.00 372,487.50 -22,487.50 0.00 372,487 351,981
452152FV8 15-0111 ILLINOIS ST 4.875 7/1/16 09/05/14 Open 1.2949 1.2949 1.064250 350,000.00 372,487.50 -22,487.50 0.00 372,487 351,981
25271CAL6 15-0208 DIAMOND OFFSHORE DRILL 5.70 10/15/39 12/29/14 Open 5.9600 5.9600 0.966440 250,000.00 241,610.00 8,390.00 0.00 241,610 193,522
25271CAL6 15-0210 DIAMOND OFFSHORE DRILL 5.70 10/15/39 12/29/14 Open 5.9600 5.9600 0.966440 300,000.00 289,932.00 10,068.00 0.00 289,932 232,227
912810RJ9 15-0212 US TREASURY BOND 3.00 11/15/44 01/21/15 Open 2.3898 2.3898 1.129560 500,000.00 564,780.00 -64,780.00 0.00 564,780 535,135
912810RJ9 15-0221 US TREASURY BOND 3.00 11/15/44 01/21/15 Open 2.3898 2.3898 1.129560 500,000.00 564,780.00 -64,780.00 0.00 564,780 535,135
452152HS3 15-0265 ILLINOIS ST 5.365 03/01/17 03/19/15 Open 1.4205 1.4205 1.075590 525,000.00 564,684.75 -39,684.75 0.00 564,685 539,962
37045XAG1 15-0268 GENERAL MOTORS FINL CO 2.75 05/15/16 03/05/15 Open 1.4020 1.4020 1.015900 600,000.00 609,540.00 -9,540.00 0.00 609,540 600,342
222372AJ3 15-0272 COUNTRYWIDE FINL CORP 6.25 5/15/16 03/25/15 Open 1.4500 1.4500 1.054001 600,000.00 632,400.57 -32,400.57 0.00 632,401 600,978
37045XAG1 15-0278 GENERAL MOTORS FINL CO 2.75 05/15/16 03/05/15 Open 1.4020 1.4020 1.015900 400,000.00 406,360.00 -6,360.00 0.00 406,360 400,228
452152HS3 15-0291 ILLINOIS ST 5.365 03/01/17 03/19/15 Open 1.4205 1.4205 1.075590 385,000.00 414,102.15 -29,102.15 80.00 414,102 395,972
222372AJ3 15-0293 COUNTRYWIDE FINL CORP 6.25 05/15/16 03/25/15 Open 1.4500 1.4500 1.054001 400,000.00 421,600.45 -21,600.45 0.00 421,600 400,652
452152FW6 15-0301 ILLINOIS ST 5.125 07/01/17 04/24/15 Open 1.6602 1.6602 1.074060 750,000.00 805,545.00 -55,545.00 0.00 805,545 775,140
452152FW6 15-0313 ILLINOIS ST 5.125 7/1/17 04/24/15 Open 1.6602 1.6602 1.074060 750,000.00 805,545.00 -55,545.00 0.00 805,545 775,140
565849AK2 16-22 MARATHON OIL CORP 2.800 11/1/22 07/01/15 Open 0.0000 0.0000 0.000000 200,000.00 189,833.33 11,166.00 0.00 189,833 177,800
565849AK2 16-23 MARATHON OIL CORP 2.800 11/1/22 07/01/15 Open 0.0000 0.0000 0.000000 300,000.00 284,750.00 15,250.00 0.00 284,750 266,700
4900 -PERSHING Total 1.6476 1.4757 1.044748 8,958,192.01 9,459,481.68 -509,725.56 0.00 9,286,906.00 8,873,800.34
4900 - PERSHING Total 1.6476 1.4757 1.044748 8,958,192.01 9,459,481.68 -509,725.56 0.00 9,286,906.00 8,873,800.34
5000 - BROWNSTONE INVESTMENT GROUP
29081YAB2 EMBRAER OVERSEAS LTD 6.375 1/24/17 12/22/15 Open 0.0000 0.0000 0.000000 300,000.00 307,431.00 -7,431.00 0.00 307,431 308,625
29081YAB2 EMBRAER OVERSEAS LTD 6.375 1/24/17 12/22/15 Open 0.0000 0.0000 0.000000 300,000.00 307,431.00 -7,431.00 0.00 307,431 308,625
845437BH4 SOUTHWESTERN ELEC PWR 5.550% 1/15/17 02/29/16 Open 0.0000 0.0000 0.000000 250,000.00 259,182.00 -9,182.00 0.00 259,182 257,397
845437BH4 SOUTHWESTERN ELEC PWR 5.550% 1/15/17 02/29/16 Open 0.0000 0.0000 0.000000 250,000.00 259,182.00 -9,182.00 0.00 259,182 257,397
240019BS7 DAYTON POWER LIGHT 1.875% 9/15/16 03/07/16 Open 0.0000 0.0000 0.000000 500,000.00 501,820.00 -1,820.00 0.00 501,820 501,330
240019BS7 DAYTON POWER LIGHT 1.875% 9/15/16 03/07/16 Open 0.0000 0.0000 0.000000 500,000.00 501,820.00 -1,820.00 0.00 501,820 501,330
200339CG2 COMERICA BANK 5.75% 11/21/16 03/10/16 Open 0.0000 0.0000 0.000000 300,000.00 308,916.00 -8,916.00 0.00 308,916 307,050
200339CG2 COMERICA BANK 5.75% 11/21/16 03/10/16 Open 0.0000 0.0000 0.000000 300,000.00 308,916.00 -8,916.00 0.00 308,916 307,050
5000 -BROWNSTONE INVESTMENT GROUP Total 0.0000 0.0000 0.000000 2,700,000.00 2,754,698.00 -54,698.00 0.00 2,754,698.00 2,748,804.00
5000 - BROWNSTONE INVESTMENT GROUPTotal 0.0000 0.0000 0.000000 2,700,000.00 2,754,698.00 -54,698.00 0.00 2,754,698.00 2,748,804.00
5050 - SOUTHWEST SECURITIES, INC
452152HS3 ILLINOIS ST 5.365 3/1/17 12/04/15 Open 0.0000 0.0000 0.000000 400,000.00 415,408.00 -15,408.00 0.00 415,408 411,400
452152HT1 ILLINOIS ST 5.665 3/1/18 12/07/15 Open 0.0000 0.0000 0.000000 150,000.00 158,932.00 -8,932.00 0.00 158,932 158,836
37045XAG1 GENERAL MOTORS FINL 2.75 5/15/16 12/11/15 Open 0.0000 0.0000 0.000000 250,000.00 251,647.00 -1,647.00 0.00 251,647 250,142
452152HS3 ILLINOIS ST 5.365 3/1/17 12/04/15 Open 0.0000 0.0000 0.000000 400,000.00 415,408.00 -15,408.00 0.00 415,408 411,400
452152HT1 ILLINOIS ST 5.665 3/1/18 12/07/15 Open 0.0000 0.0000 0.000000 150,000.00 158,932.00 -8,932.00 0.00 158,932 158,836
5050 -SOUTHWEST SECURITIES INC Total 0.0000 0.0000 0.000000 1,350,000.00 1,400,327.00 -50,327.00 0.00 1,400,327.00 1,390,614.21
5050 - SOUTHWEST SECURITIES INCTotal 0.0000 0.0000 0.000000 1,350,000.00 1,400,327.00 -50,327.00 0.00 1,400,327.00 1,390,614.21
5051 - GOLDMAN SACHS
577778BD4 MACYS RETAIL HLD 7.875 8/15/36 09/10/15 Open 0.0000 0.0000 0.000000 395,000.00 417,712.00 -22,712.00 0.00 417,712 400,269
5051 -GOLDMAN SACHS Total 0.0000 0.0000 0.000000 395,000.00 417,712.00 -22,712.00 0.00 417,712.00 400,269.00
5051 - GOLDMAN SACHS Total 0.0000 0.0000 0.000000 395,000.00 417,712.00 -22,712.00 0.00 417,712.00 400,269.00
COMMON STOCKS - ADJ TO ACTUAL Open 0.0000 0.0000 772,605.00 0.00 0.00 772,605.00 772,605
00508Y102 ACUITY BRANDS INC Open 0.0000 0.0000 900.00 233,860.00 0.00 0.00 233,860.00 219,501
00508Y102 ACUITY BRANDS INC Open 0.0000 0.0000 1,400.00 354,371.00 0.00 0.00 354,371.00 341,446
00817Y108 15-0123 AETNA INC 10/10/14 Open 0.0000 0.0000 79.253600 3,500.00 288,921.00 0.00 0.00 288,921.00 392,945
G0177J108 ALLERGAN PLC Open 0.0000 0.0000 1,000.00 152,054.00 0.00 0.00 152,054.00 216,560
G0177J108 ALLERGAN PLC Open 0.0000 0.0000 1,500.00 240,332.00 0.00 0.00 240,332.00 324,840
018581108 ALLIANCE DATA SYSTEMS CORP Open 0.0000 0.0000 1,500.00 399,945.00 0.00 0.00 378,846.00 304,965
018581108 ALLIANCE DATA SYSTEMS CORP Open 0.0000 0.0000 800.00 219,447.00 0.00 0.00 219,447.00 162,648
02079K305 ALPHABET INC CL A Open 0.0000 0.0000 300.00 228,802.00 0.00 0.00 228,802.00 212,364
023135106 AMAZON COM INC 400.00 250,618.00 0.00 0.00 250,618.00 263,836
023135106 AMAZON COM INC 600.00 359,455.00 0.00 0.00 359,455.00 395,754
025537101 13-0043 AMERICAN ELECTRIC POWER CO INC 07/06/12 OPEN 0.0000 0.0000 40.229500 1,000.00 40,229.00 0.00 0.00 80,459.00 63,500
025537101 13-0078 AMERICAN ELECTRIC POWER CO INC 08/02/12 OPEN 0.0000 0.0000 42.629200 1,400.00 56,321.00 0.00 0.00 51,155.00 88,900
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 144,305
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 76,634
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,189
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 70,133
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 4,883
29875E100 15-0177 AMERICAN EUROPACIFIC GROWTH F2 12/30/14 OPEN 0.0000 0.0000 47.489162 117.18 5,564.78 0.00 0.00 5,565.00 5,247
649280823 AMERICAN FUNDS NEW WORLD FUND Page 3 of 7 Open 0.0000 0.0000 5,328.00 275,000.00 0.00 0.00 275,000.00 270,076
026874784 15-0121 AMERICAN INTERNATIONAL GROUP 10/10/14 OPEN 0.0000 0.0000 51.935900 6,000.00 313,105.00 0.00 0.00 313,105.00 334,920
026874784 15-0287 AMERICAN INTERNATIONAL GROUP 03/06/15 OPEN 0.0000 0.0000 55.660000 4,000.00 242,964.00 0.00 0.00 242,964.00 223,280
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-0109 AMERICAN SOFTWARE INC CL A 02/23/07 OPEN 0.0000 0.0000 7.387300 1,000.00 7,387.30 0.00 0.00 7,387.00 9,140
029683109 07-0110 AMERICAN SOFTWARE INC CL A 02/23/07 OPEN 0.0000 0.0000 7.397200 1,893.00 14,002.91 0.00 0.00 14,003.00 17,302
029683109 07-0171 AMERICAN SOFTWARE INC CL A 02/23/07 OPEN 0.0000 0.0000 7.484000 400.00 2,993.61 0.00 0.00 2,994.00 3,656
029683109 07-0172 AMERICAN SOFTWARE INC CL A 02/23/07 OPEN 0.0000 0.0000 7.514000 500.00 3,757.00 0.00 0.00 3,757.00 4,570
029683109 07-0173 AMERICAN SOFTWARE INC CL A 02/23/07 OPEN 0.0000 0.0000 7.524000 600.00 4,514.41 0.00 0.00 4,514.00 5,484
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 914
029683109 07-0175 AMERICAN SOFTWARE INC CL A 02/23/07 OPEN 0.0000 0.0000 7.574000 500.00 3,787.00 0.00 0.00 3,787.00 4,570
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 914
029683109 07-0178 AMERICAN SOFTWARE INC CL A 02/23/07 OPEN 0.0000 0.0000 7.494000 500.00 3,747.01 0.00 0.00 3,747.00 4,570
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 53,286
029683109 09-0020 AMERICAN SOFTWARE INC CL A 05/27/08 OPEN 0.0000 0.0000 6.198400 2,200.00 13,636.60 0.00 0.00 13,637.00 20,108
029899101 13-0044 AMERICAN STATES WATER CO 07/06/12 OPEN 0.0000 0.0000 39.663000 1,900.00 37,680.00 0.00 0.00 37,680.00 79,211
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 54,197
03027X100 AMERICAN TOWER CORP OPEN 0.0000 0.0000 3,400.00 360,400.00 0.00 0.00 360,400.00 356,592
03073E105 15-0231 AMERISOURCEBERGEN CORP 02/02/15 OPEN 0.0000 0.0000 96.635200 2,600.00 252,477.00 0.00 0.00 252,477.00 221,260
00170K208 AMG MANAGERS SKYLINE SPECIAL Open 0.0000 0.0000 6,343.00 239,371.00 0.00 0.00 239,371.00 232,217
037833100 08-0165 APPLE, INC 02/19/08 OPEN 0.0000 0.0000 127.209000 2,100.00 86,842.00 0.00 0.00 86,842.00 196,854
037833100 14-0273 APPLE, INC 04/21/14 OPEN 0.0000 0.0000 516.525800 3,600.00 280,701.00 0.00 0.00 280,701.00 337,464
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 78,988
042068106 ARM HLDGS PLC ADR OPEN 0.0000 0.0000 5,200.00 225,983.00 0.00 0.00 225,983.00 214,188
042068106 ARM HLDGS PLC ADR Open 0.0000 0.0000 8,300.00 367,029.00 0.00 0.00 367,029.00 341,877
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 167,384
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 38,416
09253U108 BLACKSTONE GROUP LP OPEN 0.0000 0.0000 700.00 36,468.00 0.00 0.00 36,468.00 19,208
09253U4108 15-0307 BLACKSTONE GROUP LP 04/13/15 Open 0.0000 0.0000 39.227000 10,200.00 400,115.00 0.00 0.00 400,115.00 279,888
09253U4108 BLACKSTONE GROUP LP OPEN 0.0000 0.0000 2,600.00 70,515.00 0.00 0.00 70,515.00 71,344
Y09827109 BROADCOM LTD OPEN 0.0000 0.0000 1,500.00 188,995.00 0.00 0.00 188,995.00 218,625
Y09827109 BROADCOM LTD Open 0.0000 0.0000 2,300.00 233,807.00 0.00 0.00 233,807.00 335,225
118230101 BUCKEYE PARTNERS LP OPEN 0.0000 0.0000 5,400.00 362,406.00 0.00 0.00 362,406.00 388,800
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 94,912
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 68,218
128030202 CAL MAINE FOODS INC OPEN 0.0000 0.0000 1,100.00 51,673.00 0.00 0.00 51,673.00 55,836
128030202 CAL MAINE FOODS INC OPEN 0.0000 0.0000 1,600.00 77,756.00 0.00 0.00 77,756.00 81,216
151020104 CELGENE CORP OPEN 0.0000 0.0000 3,200.00 358,656.00 0.00 0.00 358,656.00 330,912
151020104 CELGENE CORP Open 0.0000 0.0000 2,200.00 57,887.00 0.00 0.00 57,887.00 227,502
192446102 16- COGNIZANT TECH SOLUTIONS CL A 06/11/15 OPEN 0.0000 0.0000 64.045800 4,000.00 256,303.20 0.00 0.00 256,303.00 233,480
192446102 COGNIZANT TECH SOLUTIONS CL A Open 0.0000 0.0000 5,700.00 369,481.00 0.00 0.00 369,481.00 332,709
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 201,698
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,029
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,157
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,127
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 62,384
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 80,208
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 17,824
22822V101 CROWN CASTLE INTL CORP OPEN 0.0000 0.0000 600.00 52,038.00 0.00 0.00 52,038.00 52,128
22822V101 CROWN CASTLE INTL CORP OPEN 0.0000 0.0000 900.00 73,233.00 0.00 0.00 73,233.00 78,192
126650100 13-0240 CVS/CAREMARK CORP 04/18/13 OPEN 0.0000 0.0000 56.986600 2,500.00 148,153.00 0.00 0.00 148,153.00 251,250
126650100 14-0012 CVS/CAREMARK CORP 05/24/13 OPEN 0.0000 0.0000 59.261200 3,500.00 199,322.00 0.00 0.00 199,322.00 351,750
233331107 DTE ENERGY CO OPEN 0.0000 0.0000 600.00 50,801.00 0.00 0.00 50,801.00 53,496
233331107 DTE ENERGY CO OPEN 0.0000 0.0000 900.00 78,158.00 0.00 0.00 78,158.00 80,244
237194105 DARDEN RESTAURANTS INC OPEN 0.0000 0.0000 900.00 51,492.00 0.00 0.00 51,492.00 56,025
237194105 DARDEN RESTAURANTS INC OPEN 0.0000 0.0000 1,300.00 76,323.00 0.00 0.00 76,323.00 80,925
247361702 14-0097 DELTA AIR LINES INC 07/08/13 OPEN 0.0000 0.0000 18.784400 4,800.00 232,546.00 0.00 0.00 232,546.00 200,016
247361702 15-0281 DELTA AIR LINES INC 03/06/15 OPEN 0.0000 0.0000 44.856500 7,900.00 193,634.00 0.00 0.00 193,634.00 329,193
256206103 15-0046 DODGE & COX INTERNATIONAL STOCK 07/17/14 OPEN 0.0000 0.0000 46.779978 10,478.00 458,313.00 0.00 0.00 300,000.00 380,980
26613Q106 15-0218 DUPONT FABROS TECHNOLOGY 01/08/15 OPEN 0.0000 0.0000 33.529400 2,400.00 80,470.00 0.00 0.00 93,882.00 95,568
26613Q106 15-0232 DUPONT FABROS TECHNOLOGY 02/02/15 OPEN 0.0000 0.0000 37.930000 1,600.00 60,688.00 0.00 0.00 60,688.00 63,712
G3223R108 EVEREST RE GROUP LTD OPEN 0.0000 0.0000 1,200.00 130,307.00 0.00 0.00 130,307.00 221,880
G3223R108 EVEREST RE GROUP LTD OPEN 0.0000 0.0000 1,900.00 213,810.00 0.00 0.00 213,810.00 351,310
316128834 15-0048 FIDELITY ADVISOR MID CAP VALUE 07/17/14 OPEN 0.0000 0.0000 23.990000 12,505.21 300,000.00 0.00 0.00 300,000.00 283,868
316389717 FIDELITY ADVISOR SMALL CAP GRW FD 1 OPEN 0.0000 0.0000 21.940000 20,366.93 394,377.00 0.00 0.00 394,377.00 368,641
31428X106 FED EX CORP OPEN 0.0000 0.0000 1,400.00 234,740.00 0.00 0.00 234,740.00 231,154
31428X106 FED EX CORP Page 4 of 7 OPEN 0.0000 0.0000 2,200.00 363,129.00 0.00 0.00 363,129.00 363,242
344849104 15-0098 FOOT LOCKER INC 08/11/14 OPEN 0.0000 0.0000 48.861600 3,600.00 175,902.00 0.00 0.00 224,763.36 221,184
344849104 FOOT LOCKER INC OPEN 0.0000 0.0000 6,100.00 366,366.00 0.00 0.00 366,366.00 374,784
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
H2906T109 GARMIN LTD OPEN 0.0000 0.0000 1,200.00 38,582.00 0.00 0.00 38,582.00 51,156
H2906T109 GARMIN LTD OPEN 0.0000 0.0000 2,000.00 63,061.00 0.00 0.00 63,061.00 85,260
372460105 14-0002 GENUINE PARTS CO 05/22/13 OPEN 0.0000 0.0000 80.709900 700.00 56,497.00 0.00 0.00 64,568.00 67,179
372460105 14-0030 GENUINE PARTS CO 05/07/13 OPEN 0.0000 0.0000 75.710200 900.00 68,139.00 0.00 0.00 83,281.00 86,373
375558103 15-0122 GILEAD SCIENCES INC 10/10/14 OPEN 0.0000 0.0000 105.104700 3,400.00 357,355.98 0.00 0.00 357,356.00 299,914
375558103 15-0230 GILEAD SCIENCES INC 02/02/15 OPEN 0.0000 0.0000 104.163900 2,200.00 229,160.58 0.00 0.00 229,161.00 194,062
37558103 15-0282 GILEAD SCIENCES INC 03/06/15 OPEN 0.0000 0.0000 102.269900 500.00 51,134.95 0.00 0.00 51,135.00 44,105
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 240,121
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 2,344
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 16,351
38142Y500 15-0178 GOLDMAN SACHS GRWTH OPP FUND 12/05/14 OPEN 0.0000 0.0000 24.010000 3,892.01 93,447.18 0.00 0.00 93,447.00 77,334
38142Y500 GOLDMAN SACHS GRWTH OPP FUND OPEN 0.0000 0.0000 4,826.36 105,772.82 0.00 0.00 105,773.00 95,900
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 332,030
413875105 HARRIS CORP DEL OPEN 0.0000 0.000000 3,000.00 235,430.00 0.00 0.00 235,430 240,030
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 191,350
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 73,938
41664L294 HARTFORD INTL OPPORTUNITY I OPEN 0.0000 0.0000 4,608.00 69,193.00 0.00 0.00 69,193 65,295
437076102 15-0085 HOME DEPOT 08/11/14 OPEN 0.0000 0.0000 80.769900 1,900.00 150,408.00 0.00 0.00 150,408.00 254,391
437076102 14-0010 HOME DEPOT 05/24/13 OPEN 0.0000 0.0000 78.420000 2,700.00 320,228.00 0.00 0.00 367,670.00 361,503
44106M102 15-0248 HOSPITALITY PPTYS TR 02/24/15 OPEN 0.0000 0.0000 31.773800 1,800.00 57,192.84 0.00 0.00 57,193.00 46,062
44106M102 16- HOSPITALITY PPTYS TR 06/11/15 OPEN 0.0000 0.0000 29.725800 3,100.00 92,242.98 0.00 0.00 92,242.98 79,329
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 240,030
45865V100 INTERCONTINENTAL EXCHANGE INC OPEN 0.0000 0.0000 1,300.00 305,607.00 0.00 0.00 376,132.00 312,039
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 348,994
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,397
465899706 12-0168 IVY INTERNATIONAL CORE EQUITY 12/12/11 OPEN 0.0000 0.0000 13.819995 850.70 11,757.00 0.00 0.00 11,757.00 13,926
465899706 IVY INTERNATIONAL CORE EQUITY OPEN 0.0000 0.0000 4,078.94 69,719.59 0.00 0.00 69,720.00 66,772
471023549 15-0160 JANUS INVT FD 12/12/14 OPEN 0.0000 0.0000 25.189962 3,374.36 85,000.00 0.00 0.00 85,000.00 74,809
471023549 15-0234 JANUS INVT FD 02/20/15 OPEN 0.0000 0.0000 24.479993 7,761.44 190,000.00 0.00 0.00 190,000.00 172,071
471023549 JANUS INVT FD OPEN 0.0000 0.0000 7,393.99 158,883.00 0.00 0.00 158,883.00 163,925
471023549 JANUS INVT FD OPEN 0.0000 0.0000 10,808.00 212,563.00 0.00 0.00 212,563.00 239,613
471023549 JANUS INVT FD OPEN 0.0000 0.0000 6,452.00 45,621.00 0.00 0.00 45,621.00 143,041
501044101 14-0146 KROGER CO 11/14/13 OPEN 0.0000 0.0000 41.462100 6,000.00 118,457.00 0.00 0.00 118,457.00 212,340
501044101 15-0310 KROGER CO 04/13/15 OPEN 0.0000 0.0000 76.067400 8,400.00 318,877.00 0.00 0.00 372,124.00 297,276
521865204 15-0120 LEAR CORP 10/10/14 OPEN 0.0000 0.0000 88.253400 2,300.00 239,265.00 0.00 0.00 239,265.00 264,799
521865204 LEAR CORP OPEN 0.0000 0.0000 3,000.00 264,760.00 0.00 0.00 264,760.00 345,390
525327102 LEIDOS HOLDINGS INC OPEN 0.0000 0.0000 1,000.00 41,946.00 0.00 0.00 41,946.00 49,610
525327102 LEIDOS HOLDINGS INC OPEN 0.0000 0.0000 1,700.00 69,445.00 0.00 0.00 56,893.00 84,337
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 146,640
58933Y105 13-0047 MERCK AND CO INC 07/06/12 OPEN 0.0000 0.0000 41.779500 1,100.00 48,994.00 0.00 0.00 79,381.00 60,324
58933Y105 13-0070 MERCK AND CO INC 08/02/12 OPEN 0.0000 0.0000 44.540000 1,600.00 66,847.00 0.00 0.00 53,448.00 87,744
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,292
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 46,297
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 260,829
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 407,852
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 150,032
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 322,570
55273E822 15-0047 MFS INTERNATIONAL VALUE FUND I 07/17/14 OPEN 0.0000 0.0000 37.090016 8,088.43 300,000.00 0.00 0.00 300,000.00 297,088
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 58,308
595017104 13-0012 MICROCHIP TECHNOLOGY INC 05/04/12 OPEN 0.0000 0.0000 35.470000 1,600.00 56,752.00 0.00 0.00 70,940.00 77,744
61174X109 MONSTER BREVERAGE CORP OPEN 0.0000 0.0000 1,700.00 240,505.00 0.00 0.00 240,505.00 245,174
628530107 15-0314 MYLAN INC 04/09/15 OPEN 0.0000 0.0000 57.702400 4,500.00 259,660.80 0.00 0.00 259,661.00 187,695
628530107 15-0315 MYLAN INC 04/09/15 OPEN 0.0000 0.0000 57.702400 7,400.00 399,537.00 0.00 0.00 375,066.00 308,654
670725712 NUVEEN INTERNATIONAL GROWTH 1 Open 0.0000 0.0000 5,648.20 210,000.00 0.00 0.00 210,000.00 213,050
67064Y727 15-0050 NUVEEN NWQ SMALL CAP VALUE INDEX 07/17/14 OPEN 0.0000 0.0000 41.970017 10,721.94 450,000.00 0.00 0.00 450,000.00 460,400
67064Y727 15-0083 NUVEEN NWQ SMALL CAP VALUE INDEX 08/08/14 OPEN 0.0000 0.0000 40.090000 7,233.72 290,000.00 0.00 0.00 290,000.00 310,616
67064Y727 15-0151 NUVEEN NWQ SMALL CAP VALUE INDEX 11/07/14 OPEN 0.0000 0.0000 42.429944 2,710.35 115,000.00 0.00 0.00 115,000.00 116,382
670678200 NUVEEN SMALL CAP VALUE FUND CL 1 OPEN 0.0000 0.0000 21,971.00 448,000.00 0.00 0.00 448,000.00 443,375
670678200 NUVEEN SMALL CAP VALUE FUND CL 1 OPEN 0.0000 0.0000 18,445.00 375,000.00 0.00 0.00 375,000.00 372,220
62944T105 NVR INC OPEN 0.0000 0.0000 200.00 320,396.00 0.00 0.00 320,396.00 332,258
62944T105 NVR INC OPEN 0.0000 0.0000 125.00 219,512.00 0.00 0.00 219,512.00 207,661
413838202 12-0055 OAKMARK INTERNATIONAL FUND 07/28/11 OPEN 0.0000 0.0000 19.600000 15,144.30 303,649.00 0.00 0.00 303,649.00 320,605
674375506 OBERWEIS INTER OPPORTUNITIES Page 5 of 7 OPEN 0.0000 0.0000 13,020.00 275,000.00 0.00 0.00 275,000.00 269,905
680223104 16- OLD REP INTL CORP 06/11/15 OPEN 0.0000 0.0000 15.072200 4,000.00 60,408.80 0.00 0.00 60,409.00 73,960
680223104 16- OLD REP INTL CORP 06/11/15 OPEN 0.0000 0.0000 15.090700 2,700.00 40,776.00 0.00 0.00 40,776.00 49,923
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
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 107,528
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 270,694
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 201,048
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 210,231
695263103 PACWEST BANCORP OPEN 0.0000 0.0000 1,200.00 51,072.00 0.00 0.00 51,072.00 47,976
695263103 PACWEST BANCORP OPEN 0.0000 0.0000 2,000.00 81,800.00 0.00 0.00 81,800.00 79,960
704326107 13-0049 PAYCHEX 07/06/12 OPEN 0.0000 0.0000 31.450000 1,300.00 42,757.00 0.00 0.00 42,757.00 67,756
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 83,392
717081103 13-0051 PFIZER INC 07/06/12 OPEN 0.0000 0.0000 22.930000 1,600.00 42,119.00 0.00 0.00 42,119.00 52,336
717081103 13-0069 PFIZER INC 08/02/12 OPEN 0.0000 0.0000 23.710000 2,700.00 65,816.00 0.00 0.00 65,816.00 88,317
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 266,232
74160Q103 15-0162 PRIMECAP ODYSSEY GROWTH FUND 12/15/14 OPEN 0.0000 0.0000 26.549900 2,259.89 60,000.00 0.00 0.00 60,000.00 58,486
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 291,414
74255L795 14-0245 PRINCIPAL MIDCAP 02/05/14 OPEN 0.0000 0.0000 19.450000 13,778.92 268,000.00 0.00 0.00 268,000.00 291,838
74255L795 15-0002 PRINCIPAL MIDCAP 05/19/14 OPEN 0.0000 0.0000 20.740003 7,232.40 150,000.00 0.00 0.00 150,000.00 153,182
74255L795 PRINCIPAL MIDCAP OPEN 0.0000 0.0000 4,558.48 95,303.00 0.00 0.00 95,303.00 96,549
742537863 PRINCIPAL SMALLCAP P OPEN 0.0000 0.0000 11,873.23 258,430.00 0.00 0.00 258,430.00 236,752
718546104 PHILLIPS 66 OPEN 0.0000 0.0000 2,700.00 232,247.00 0.00 0.00 232,247.00 221,697
718546104 PHILLIPS 66 OPEN 0.0000 0.0000 4,200.00 360,173.00 0.00 0.00 360,173.00 344,862
756109104 11-0124 REALTY INCOME CORP 10/06/10 OPEN 0.0000 0.0000 33.646428 1,100.00 37,011.00 0.00 0.00 47,105.00 65,120
756109104 13-0011 REALTY INCOME CORP 05/04/12 OPEN 0.0000 0.0000 39.744100 1,300.00 51,639.00 0.00 0.00 67,565.00 76,960
761713106 11-0009 REYNOLDS AMERICAN INC 06/08/10 OPEN 0.0000 0.0000 53.039300 1,200.00 15,912.00 0.00 0.00 15,912.00 59,520
761713106 11-0018 REYNOLDS AMERICAN INC 06/08/10 OPEN 0.0000 0.0000 52.979742 1,800.00 23,841.00 0.00 0.00 23,841.00 89,280
V7780T103 ROYAL CARIBBEAN CRUISES LTD OPEN 0.0000 0.0000 2,600.00 247,530.00 0.00 0.00 223,652.00 201,240
V7780T103 ROYAL CARIBBEAN CRUISES LTD OPEN 0.0000 0.0000 4,000.00 370,929.00 0.00 0.00 370,929.00 309,600
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 65,689
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 96,007
79466L302 SALESFORCE COM INC OPEN 0.0000 0.0000 2,900.00 223,287.00 0.00 0.00 223,287.00 219,820
79466L302 SALESFORCE COM INC OPEN 0.0000 0.0000 4,800.00 366,904.00 0.00 0.00 366,904.00 363,840
808513105 SCHWAB CHARLES CORP OPEN 0.0000 0.0000 8,000.00 230,787.00 0.00 0.00 230,787.00 227,280
808513105 SCHWAB CHARLES CORP OPEN 0.0000 0.0000 13,200.00 361,260.00 0.00 0.00 361,260.00 375,012
G7945M107 15-0132 SEAGATE TECHNOLOGY 10/10/14 Open 0.0000 0.0000 55.271500 1,200.00 46,810.00 0.00 0.00 46,810.00 26,124
81721M109 SENIOR HOUSING PROP TRUST OPEN 0.0000 0.0000 3,700.00 50,908.00 0.00 0.00 50,908.00 65,046
824348106 SHERWIN WILLIAMS CO OPEN 0.0000 0.0000 900.00 230,963.00 0.00 0.00 230,963.00 258,579
824348106 SHERWIN WILLIAMS CO OPEN 0.0000 0.0000 1,300.00 311,363.00 0.00 0.00 359,265.00 373,503
83088M102 SKYWORKS SOLUTIONS INC OPEN 0.0000 0.0000 4,500.00 348,349.00 0.00 0.00 348,349.00 300,690
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 65,130
842587107 09-0093 SOUTHERN CO 08/29/08 OPEN 0.0000 0.0000 37.515200 1,800.00 67,527.00 0.00 0.00 67,527.00 90,180
844741108 15-0206 SOUTHWEST AIRLINES CO 12/16/14 OPEN 0.0000 0.0000 41.961100 4,900.00 200,262.00 0.00 0.00 267,399.00 218,589
844741108 SOUTHWEST AIRLINES CO OPEN 0.0000 0.0000 8,000.00 336,145.00 0.00 0.00 365,558.00 356,880
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 81,302
85917K546 STERLING CAPITAL STRATTON SM CAP VAL OPEN 0.0000 0.0000 5,652.58 288,729.00 0.00 0.00 288,729.00 405,177
779552207 14-0160 T ROWE PRICE EXT EQ MKT IDX 11/04/13 OPEN 0.0000 0.0000 23.860000 16,200.44 385,778.00 0.00 0.00 385,778.00 375,526
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 120,211
779562107 15-0013 T ROWE PRICE NEW HORIZONS FUND 05/23/14 OPEN 0.0000 0.0000 44.149988 3,601.36 159,000.00 0.00 0.00 159,000.00 148,268
779562107 15-0233 T ROWE PRICE NEW HORIZONS FUND 02/02/15 OPEN 0.0000 0.0000 43.370000 3,919.76 170,000.00 0.00 0.00 170,000.00 161,377
779562107 T ROWE PRICE NEW HORIZONS FUND OPEN 0.0000 0.0000 1,904.16 80,801.00 0.00 0.00 80,801.00 78,394
883556102 15-0039 THERMO FISHER SCIENTIFIC INC 07/11/14 OPEN 0.0000 0.0000 118.689700 2,600.00 308,593.00 0.00 0.00 356,069.00 375,050
887389104 TIMKEN CO OPEN 0.0000 0.0000 1,800.00 50,445.00 0.00 0.00 50,445.00 64,134
887389104 TIMKEN CO OPEN 0.0000 0.0000 2,600.00 76,711.00 0.00 0.00 76,711.00 92,638
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 188,148
893509224 TRANSAMERICA FDS OPEN 0.0000 0.0000 10,802.98 171,885.00 0.00 0.00 171,885.00 178,357
89417E109 TRAVELERS COS INC OPEN 0.0000 0.0000 2,100.00 232,071.00 0.00 0.00 232,071.00 230,790
901165100 15-0257 TWEEDY BROWNE GLOBAL VALUE FUND 02/23/15 OPEN 0.0000 0.0000 26.660000 7,476.00 198,609.00 0.00 0.00 190,000.00 182,639
91913Y100 14-0014 VALERO ENERGY CORP 05/24/13 OPEN 0.0000 0.0000 41.827700 3,600.00 147,986.00 0.00 0.00 147,986.00 211,932
921937686 15-0051 VANGUARD SMALL CAP VALUE INDEX 07/17/14 OPEN 0.0000 0.0000 44.589986 9,469.00 425,000.00 0.00 0.00 500,000.00 423,170
921937686 VANGUARD SMALL CAP VALUE INDEX OPEN 0.0000 0.0000 15,469.00 690,387.00 0.00 0.00 690,387.00 691,310
92828N593 VIRTUS SMALL CAP SUSTAINABLE GROWTH OPEN 0.0000 0.0000 20,469.00 375,000.00 0.00 0.00 375,000.00 372,536
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 54,981
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 91,635
931427108 WALGREENS BOOTS ALLIANCE INC OPEN 0.0000 0.0000 4,200.00 361,797.00 0.00 0.00 361,797.00 332,976
958102105 WESTERN DIGITAL CORP OPEN 0.0000 0.0000 1,300.00 51,375.00 0.00 0.00 51,375.00 53,125
958102105 WESTERN DIGITAL CORP Page 6 of 7 OPEN 0.0000 0.0000 1,800.00 72,173.00 0.00 0.00 72,173.00 73,557
959319104 WESTERN REFINING INC OPEN 0.0000 0.0000 1,700.00 66,831.00 0.00 0.00 58,972.00 45,492
959319104 WESTERN REFINING INC OPEN 0.0000 0.0000 2,400.00 93,520.00 0.00 0.00 82,192.00 64,224
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
5100 -FSC SECURITIES CORPORATION Total 0.0000 0.0000 0.000000 891,543.90 36,350,197.48 0.00 0.00 36,697,977.33 38,877,822.20
5100 - FSC SECURITIES CORPORATION Total 0.0000 0.0000 0.000000 891,543.90 36,350,197.48 0.00 0.00 36,697,977.33 38,877,822.20
Investment Total
46,438,851 83,813,169 (1,323,008) - 84,008,375 85,407,153
Page 7 of 7
Revenue and Expense Projections
General Fund (without special revenue funds) *
Fiscal Year 2016/17
Variance from Original Budget
Original Amended Oct. 2016 Dec. 2016 March 2017 Audited Oct. 2016 Dec. 2016 March 2017 Audited
Budget Budget Estimate Estimate Estimate Actual Estimate Estimate Estimate Actual
Revenue $ 44,599,230 $ 44,599,230 $ 41,899,480 -6.05%
Expense $ 44,474,205 $ 45,088,780 $ 44,887,976 0.93%
Surplus (Deficit) $ 125,025 $ (489,550) $ (2,988,496)
Prior year bonds $ 2,796,000
Adjusted Surplus 125,025 (489,550) (192,496)
Fund Balance $ 20,629,915 $ 20,015,340 $ 21,057,015 2.07%
as a % of revenue 46.3% 44.9% 50.3%
as a % of expense 46.4% 44.4% 46.9%
Fund Balance above 40%
target $ 2,790,223 $ 2,175,648 $ 3,178,823
* Restricted revenues for drug forfeiture and foreign fire taxes and the associated expenses have been deducted.
Village of Northbrook
General Fund Revenue Projections
Fiscal Year 2017 - First Quarter
November 15, 2016
Projected
Over (Under)
Account FY 2015/16 First Quarter First Quarter FY17 FY17 Budget
Number Actual Budget Actual Budget Estimate $ %
Property Taxes 401-00/11 7,622,045 1,180,000 1,188,819 7,820,750 7,820,750 0 0.00%
Township Road and Bridge Tax 401-06/16 460,210 109,000 108,898 460,000 460,000 0 0.00%
Replacement Taxes
Corporate 405-01 346,816 131,208 135,426 337,500 337,500 0 0.00%
Township Road and Bridge 405-03 14,227 0 0 12,000 12,000 0
Total Replacement Taxes 361,043 131,208 135,426 349,500 349,500 0 0.00%
Sales Tax
Retail Sales Tax 421-00/04 12,472,371 2,867,932 2,761,109 12,450,000 12,450,000 0 0.00%
Auto Rental Tax 421-01 6,605 2,988 594 12,000 12,000 0 0.00%
Use Tax 421-03 765,696 175,036 189,251 779,500 779,500 0 0.00%
Total Sales Tax 13,244,672 3,045,956 2,950,954 13,241,500 13,241,500 0 0.00%
Income Tax
State Income Tax 422-00 3,362,196 1,108,853 1,197,149 3,383,340 3,383,340 0 0.00%
Total Income Taxes 3,362,196 1,108,853 1,197,149 3,383,340 3,383,340 0 0.00%
Other Taxes
Hotel/Motel Occupancy Tax 407-01 985,943 298,887 281,295 1,050,000 1,000,000 (50,000) -4.76%
Utility Tax 407-03/04 995,457 273,618 211,474 1,100,000 1,050,000 (50,000) -4.55%
Telecommunications Tax 478-06 3,210,141 843,915 756,108 3,200,000 3,100,000 (100,000) -3.13%
Admissions/Entertainment Tax 407-02 103,441 25,486 20,045 110,000 110,000 0 0.00%
Total Other Taxes 5,294,982 1,441,906 1,268,922 5,460,000 5,260,000 (200,000) -3.66%
Permits
Building 452-00/06/05 2,539,782 466,861 520,141 1,600,000 2,000,000 400,000 25.00%
Alarm 454-03 9,110 1,134 1,050 5,000 5,000 0 0.00%
Total Permits 2,548,892 467,995 521,191 1,605,000 2,005,000 400,000 24.92%
Account FY 2015/16 First Quarter First Quarter FY17 FY17 Budget
Number Actual Budget Actual Budget Estimate $ %
Licenses
Animal 435-01 23,528 20,614 19,985 24,000 24,000 0 0.00%
Business/Liquor 435-02/04 330,065 49,596 12,827 350,000 350,000 0 0.00%
Vehicle 435-05, 473-35 574,211 554,289 530,507 580,000 580,000 0 0.00%
Total Licenses 927,804 624,499 563,319 954,000 954,000 0 0.00%
Interest Income
General Fund 426-01/02/04 102,543 25,000 33,047 60,000 100,000 40,000 66.67%
Total Interest Income 102,543 25,000 33,047 60,000 100,000 40,000 66.67%
Fees:
RFPD Fees 451-00 2,262,060 0 0 2,700,000 2,400,000 (300,000) -11.11%
RED Center Administration Fees 451-01 20,000 0 0 20,000 20,000 0 0.00%
Elevator Inspections 452-01 32,265 3,660 14,160 36,000 36,000 0 0.00%
Franchise Fees:
Cable Television 478-01 755,732 193,513 229,239 775,000 775,000 0 0.00%
Total Franchise Fees 755,732 193,513 229,239 775,000 775,000 0 0.00%
Alarm Services Fees:
Police Alarms 454-00/01/02 124,536 15,183 8,145 134,000 134,000 0 0.00%
Fire Alarms 459-00/01 73,293 24,328 19,602 80,000 80,000 0 0.00%
Total Alarm Services Fees 197,829 39,511 27,747 214,000 214,000 0 0.00%
Petitioner Fees:
Plan Commission 457-00 20,373 4,551 7,835 20,000 20,000 0 0.00%
Total Petitioner Fees 20,373 4,551 7,835 20,000 20,000 0 0.00%
Total Fees 3,288,259 241,235 278,981 3,765,000 3,465,000 (300,000) -7.97%
Rental Income:
Commuter Station:
The Grind 461-05 7,643 0 0 0 0 0 #DIV/0!
Total Rental Income 7,643 0 0 0 0 0 #DIV/0!
Fines:
Ordinance Violations 458-01 25,526 11,243 5,790 45,000 40,000 (5,000) -11.11%
Traffic Court Fines 458-02 131,348 29,040 52,126 120,000 150,000 30,000 25.00%
Total Fines 156,874 40,283 57,916 165,000 190,000 25,000 15.15%
Account FY 2015/16 First Quarter First Quarter FY17 FY17 Budget
Number Actual Budget Actual Budget Estimate $ %
Interfund Transfers:
Sanitary Sewer Fund 475-14 509,455 262,370 262,370 524,740 524,740 0 0.00%
Senior Housing Fund 475-15 83,205 42,850 42,850 85,700 85,700 0 0.00%
Stormwater Fund 475-16 78,750 40,555 40,555 81,110 81,110 0 0.00%
Water Production Fund 475-21 684,380 328,690 328,690 657,380 657,380 0 0.00%
Water Distribution Fund 475-21 1,169,015 575,545 575,545 1,151,090 1,151,090 0
Parking Fund 475-22 110,075 52,500 52,500 105,000 105,000 0 0.00%
Cemetary Fund 475-20/23 1,570 810 810 1,620 1,620 0 0.00%
Total Interfund Transfers 2,636,450 1,303,320 1,303,320 2,606,640 2,606,640 0 0.00%
Charges for Services:
Overtime Reimb. - Police/Fire/Dev/PW 473-13:17 58,534 7,658 9,961 63,000 63,000 0 0.00%
Antenna Lease Fees 476-01 237,200 5,000 4,921 206,875 206,875 0 0.00%
Sign Material Sales 477-06 0 0 0 1,000 1,000 0 0.00%
Reforestation Fees 477-07 7,855 3,141 815 15,000 10,000 (5,000) -33.33%
Toll Road Responses-Fire/EMS 477-31/32 1,600 642 1,650 1,750 3,000 1,250 71.43%
Ambulance Transportation Fee 480-02 1,127,507 213,960 240,929 1,050,000 1,050,000 0 0.00%
Glenbrook North Police Service 480-03 114,898 0 0 120,000 120,000 0 0.00%
Summer School Crossing Guards 480-04 6,619 0 0 7,000 7,000 0 0.00%
Total Charges for Services 1,554,213 230,401 258,276 1,464,625 1,460,875 (3,750) -0.26%
Miscellaneous:
Surplus Equipment Sales 473-03 64,061 8,000 44,782 60,000 70,000 10,000 16.67%
Retail Sale Permits 473-06 950 873 330 2,000 2,000 0 0.00%
Miscellaneous Income 473-07/09/20 103,145 35,665 53,507 350,000 350,000 0 0.00%
Grants 481-18/32 800 0 0 0 0 0
Raffle/Facility Use Fees 473-10/18 330 175 180 375 375 0 0.00%
State Route Maintenance 475-04 0 0 0 20,000 20,000 0 0.00%
Traffic Signal/Street Light Damage 477-03/04 2,969 0 0 5,000 5,000 0 0.00%
Impound Fees 477-08 80 187 50 500 500 0 0.00%
Miscellaneous Reimbursements 477-09/10 1,087 1,300 337 5,000 5,000 0 0.00%
Annexation Fees 480-19 90,949 7,319 64,720 25,000 150,000 125,000 500.00%
Bond Proceeds 406-02 4,307,454 2,796,000 0 2,796,000 0 (2,796,000) -100.00%
Total Miscellaneous 4,571,825 2,849,519 163,906 3,263,875 602,875 (2,661,000) -81.53%
TOTAL GENERAL CORPORATE FUND 46,139,651 12,799,175 10,030,124 44,599,230 41,899,480 (2,699,750) -6.05%
Village of Northbrook
General Corporate Fund
Expenditure Summary by Department (Without Special Revenue Funds)
FY 2016/17 - First Quarter
November 15, 2016
QUARTER
BUDGET YTD BALANCE 2016-17 PROJECTED OVER
ACCOUNT DESCRIPTION 07/31/2016 07/31/2016 AMENDED BUDGET FY 17 ESTIMATE (UNDER) BUDGET $ % REASON
1110-LEGISLATIVE DIVISION
PERSONAL SERVICES 10,612 10,300 41,200 41,200 -
FRINGE BENEFITS 808 860 3,150 3,150 -
CONTRACTUAL SERVICES 228,317 206,183 334,675 334,675 -
1110-LEGISLATIVE DIVISION 239,737 217,343 379,025 379,025 -
1120-ADMINISTRATIVE DIVISION
PERSONAL SERVICES 292,195 272,166 1,099,720 1,099,720 -
FRINGE BENEFITS 114,555 106,210 326,445 326,445 -
CONTRACTUAL SERVICES 50,268 41,140 210,820 210,820 -
COMMODITIES 177 - 3,500 3,500 -
1120-ADMINISTRATIVE DIVISION 457,195 419,515 1,640,485 1,640,485 -
1200-LEGAL DIVISION
CONTRACTUAL SERVICES 107,345 64,278 589,000 589,000 -
1200-LEGAL DIVISION 107,345 64,278 589,000 589,000 -
1300-FINANCE DEPARTMENT
PERSONAL SERVICES 182,788 179,605 699,650 699,650 -
FRINGE BENEFITS 93,893 90,589 252,355 252,355 -
CONTRACTUAL SERVICES 84,613 77,018 219,664 219,664 -
COMMODITIES 3,608 2,192 18,000 18,000 -
CAPITAL OUTLAY 266 - 2,500 2,500 -
1300-FINANCE DEPARTMENT 365,168 349,404 1,192,169 1,192,169 -
1400-INFORMATION SERVICES
PERSONAL SERVICES 103,625 97,461 414,500 400,202 (14,298) -3.4%
FRINGE BENEFITS 49,107 47,320 136,260 135,110 (1,150) -0.8%
New web hosting provider not included.
System maintenance over budget due to
CONTRACTUAL SERVICES 213,611 108,483 912,945 922,945 10,000 1.1% delayed retirement of Oracle.
COMMODITIES 250 105 1,000 1,000 -
Unplanned purchases of scanner and tablets
CAPITAL OUTLAY 40,000 21,806 322,500 344,500 22,000 6.8% for DPS.
1400-INFORMATION SERVICES 406,593 275,176 1,787,205 1,803,757 16,552 0.9%
General Corporate Fund
Expenditure Summary by Department (Without Special Revenue Funds)
FY 2016/17 - First Quarter
November 15, 2016
QUARTER
BUDGET YTD BALANCE 2016-17 PROJECTED OVER
ACCOUNT DESCRIPTION 07/31/2016 07/31/2016 AMENDED BUDGET FY 17 ESTIMATE (UNDER) BUDGET $ % REASON
2100-POLICE DEPARTMENT
PERSONAL SERVICES 2,492,958 2,323,867 10,216,375 10,175,900 (40,475) -0.4% Temporary vacancies due to attrition.
FRINGE BENEFITS 820,099 808,524 1,933,210 1,926,010 (7,200) -0.4% Temporary vacancies due to attrition.
CONTRACTUAL SERVICES 396,038 385,149 972,440 1,021,135 48,695 5.0% Equipment for new vehicles.
COMMODITIES 123,679 78,877 636,605 591,555 (45,050) -7.1% Taser project under budget.
Anticipated vehicle purchase moved from FY
CAPITAL OUTLAY 2,004 5,966 273,500 402,500 129,000 47.2% 18 to FY 17.
2100-POLICE DEPARTMENT 3,834,778 3,602,383 14,032,130 14,117,100 84,970 0.6%
2300-E911
Maintaining legacy 911 network longer than
CONTRACTUAL SERVICES 410,780 401,157 416,811 493,191 76,380 18.3% expected during transition to StarComm.
CAPITAL OUTLAY 2,500 13,295 24,000 27,570 3,570 14.9%
2300-E911 413,280 414,452 440,811 520,761 79,950 18.1%
3100-FIRE DEPARTMENT
POC salaries to be under budget due to low
enrollment. Overtime projected to be over
PERSONAL SERVICES 2,154,949 2,247,233 8,362,510 8,347,510 (15,000) -0.2% budget due to injuries.
FRINGE BENEFITS 689,539 691,417 1,488,055 1,488,055 -
CONTRACTUAL SERVICES 394,824 340,083 1,285,185 1,294,385 9,200 0.7%
Diesel is projected to be under budget.
COMMODITIES 98,289 73,571 456,990 441,390 (15,600) -3.4% Currently 10% behind.
Quarterly variance due to timing of purchase
CAPITAL OUTLAY - 727,556 1,160,000 1,160,000 - of replacement engine.
3100-FIRE DEPARTMENT 3,337,600 4,079,861 12,752,740 12,731,340 (21,400) -0.2%
General Corporate Fund
Expenditure Summary by Department (Without Special Revenue Funds)
FY 2016/17 - First Quarter
November 15, 2016
QUARTER
BUDGET YTD BALANCE 2016-17 PROJECTED OVER
ACCOUNT DESCRIPTION 07/31/2016 07/31/2016 AMENDED BUDGET FY 17 ESTIMATE (UNDER) BUDGET $ % REASON
4100-PUBLIC WORKS DEPARTMENT
PERSONAL SERVICES 869,110 810,357 3,596,615 3,410,953 (185,662) -5.2% Temporary vacancies due to attrition.
FRINGE BENEFITS 431,254 417,297 1,243,505 1,215,505 (28,000) -2.3% Temporary vacancies due to attrition.
First quarter expenditures were high due to
CONTRACTUAL SERVICES 536,137 601,640 2,039,790 1,983,597 (56,193) -2.8% increased tree activity and street patching.
Limited street repairs anticipated to be
COMMODITIES 113,079 99,551 725,375 678,283 (47,092) -6.5% performed in-house.
Budgeted replacement of dump truck and
CAPITAL OUTLAY 65,700 3,964 2,470,265 2,426,336 (43,929) -1.8% pickup truck lower than expected.
4100-PUBLIC WORKS DEPARTMENT 2,015,280 1,932,808 10,075,550 9,714,674 (360,876) -3.6%
6300-DEVELOPMENT/PLANNING SERVICES DEPARTMENT
PERSONAL SERVICES 285,677 278,780 1,163,210 1,163,210 -
FRINGE BENEFITS 192,909 188,842 504,805 504,805 -
CONTRACTUAL SERVICES 144,219 131,901 527,050 527,050 -
COMMODITIES 900 - 3,600 3,600 -
CAPITAL OUTLAY 250 - 1,000 1,000 -
6300-DEVELOPMENT/PLANNING SERVICES DEPT 623,955 599,523 2,199,665 2,199,665 -
TOTAL Expenditures 11,800,930 11,954,743 45,088,780 44,887,976 (200,804) -0.4%
TOTAL BY CLASS
Personal Services 6,391,914 6,219,768 25,593,780 25,338,345 (255,435) -1.0%
Fringe Benefits 2,392,164 2,351,059 5,887,785 5,851,435 (36,350) -0.6%
Contractual Services 2,566,151 2,357,033 7,508,380 7,596,462 88,082 1.2%
Commodities 339,981 254,297 1,845,070 1,737,328 (107,742) -5.8%
Capital Outlay 110,720 772,587 4,253,765 4,364,406 110,641 2.6%
Total 11,800,930 11,954,743 45,088,780 44,887,976 (200,804) -0.4%
Village of Northbrook
Comparative Sales Tax Collections
Fiscal Year 2016/17
GAAP Basis
Liability Collection Disbursement Budgeted
Month Month Month 2012-13 2013-14 2014-15 2015-16 2016-17 Amount
Feb Mar May 1,012,201 928,186 994,219 977,047 1,006,867
Mar Apr Jun 1,179,072 1,129,720 1,167,090 1,178,323 1,181,937
Apr May July 1,122,109 1,097,293 1,113,585 1,102,803 1,112,953 1,127,752
May Jun Aug 1,204,629 1,266,803 1,232,939 1,253,620 1,225,303 1,248,625
Jun Jul Sep 1,333,790 1,251,288 1,294,922 1,329,821 1,343,112 1,311,396
Jul Aug Oct 1,059,683 1,120,681 1,133,312 1,179,012 1,118,367 1,147,729
Aug Sep Nov 1,189,263 1,193,600 1,227,244 1,205,154 1,311,912 1,242,857
Sep Oct Dec 1,304,942 1,203,212 1,267,160 1,282,950 1,283,280
Oct Nov Jan 1,178,118 1,159,309 1,203,408 1,214,271 1,218,718
Nov Dec Feb 1,307,382 1,203,020 1,258,529 1,249,067 1,274,540
Dec Jan Mar 1,707,000 1,655,408 1,604,207 1,675,358 1,624,615
Jan Feb Apr 1,019,737 976,328 1,033,535 1,018,147 1,046,684
$ 14,617,926 $ 14,184,847 $ 14,530,151 $ 14,665,573 6,111,646 14,715,000
2016/17 Budgeted Sales Tax Revenue $ 14,715,000
Percent Collected 41.53%
Current Year Projection Based Upon Recent Trends $ 14,822,535
Over (Under) Budget $ 107,535
Percentage Over (Under) Budget 0.73%
Fiscal Year Sales Tax Receipts by Month
GAAP Basis
$1,800,000
$1,700,000
$1,600,000
$1,500,000
$1,400,000
$1,300,000
$1,200,000
FY 12/13
$1,100,000
$1,000,000 FY 13/14
$900,000
$800,000 FY 14/15
$700,000
FY 15/16
$600,000
$500,000 FY 16/17
$400,000
$300,000
$200,000
$100,000
$0
July Aug Sep Oct Nov
Budget to Actual Sales Tax Collections
FY 2016/17 - 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
November sales tax receipts were $69,055 above budget. The November
receipts reflect sales made in August.
Quarterly Overtime Report
Fiscal Year 2016/17
First Second Third Fourth
Budget Qtr. Qtr. Qtr. Qtr. Total
General Government
Regular overtime 3,755.49 3,755.49
Family dinner
Total General Government 7,500 3,755.49 3,755.49
Finance Department
Vehicle licenses 3,173.28 3,173.28
Regular overtime 3,767.17 3,767.17
Total Finance Department 10,000 6,940.45 6,940.45
Police Department
Roll call 33,929.50 33,929.50
FLSA 18,348.90 18,348.90
Shift holdover 7,850.98 7,850.98
Regular/Speciality recall 24,736.92 24,736.92
Meetings/Training 35,331.89 35,331.89
Special Assignments 9,581.01 9,581.01
Private details (reimbursable) 8,717.28 8,717.28
Court time 17,206.73 17,206.73
Minimum manning 28,896.10 28,896.10
Quarterly Overtime Report
Fiscal Year 2016/17
First Second Third Fourth
Budget Qtr. Qtr. Qtr. Qtr. Total
Police Department (cont.)
Northbrook Days (partial reimb.)
Community relations 2,466.89 2,466.89
4th of July 19,479.69 19,479.69
NIPAS/NORTAF 7,634.71 7,634.71
Total Overtime Worked 214,180.60 214,180.60
LESS: Hours accumulated as PTO (104,119.24) (104,119.24)
Overtime Paid Out 720,840 110,061.36 110,061.36
Fire Department
FLSA 10,720.28 10,720.28
Shift holdover 4,509.59 4,509.59
Regular/recall 8,219.43 8,219.43
Meetings/Training 10,938.18 10,938.18
Special teams training 18,962.92 18,962.92
Minimum manning 134,912.51 134,912.51
CERT Training (REIMBURS)
FLS Inspections 2,552.45 2,552.45
Administrative Work 6,805.41 6,805.41
Open House
Northbrook Days
4th of July 1,828.17 1,828.17
-
Quarterly Overtime Report
Fiscal Year 2016/17
First Second Third Fourth
Budget Qtr. Qtr. Qtr. Qtr. Total
Fire Department (cont.)
Total Overtime Worked 199,448.94 199,448.94
LESS: Hours accumulated as PTO (19,891.45) (19,891.45)
Overtime Paid Out 349,000 179,557.49 179,557.49
Public Works
Streets & sidewalks 223.66 223.66
Snow & Ice control
Parkway & street lights 442.92 442.92
Storm sewer 1,961.44 1,961.44
Sanitary sewer 4,284.07 4,284.07
Village building 1,007.05 1,007.05
Fleet 1,686.84 1,686.84
Water Production & Dist. 18,344.46 18,344.46
Water main breaks 9,197.03 9,197.03
JULIE Locates 3,107.71 3,107.71
Engineering plan review & insp. 5,040.21 5,040.21
Northbrook Days
Family Dinner
Earth Day
Misc. Special Events 959.66 959.66
4th of July 5,664.99 5,664.99
Roll call 5,626.37 5,626.37
Trees & storm damage 4,733.48 4,733.48
Quarterly Overtime Report
Fiscal Year 2016/17
First Second Third Fourth
Budget Qtr. Qtr. Qtr. Qtr. Total
Public Works (cont.)
Total Overtime Worked 62,279.89 62,279.89
LESS: Hours accumulated as PTO (26,589.97) (26,589.97)
Overtime Paid Out 315,810 35,689.92 35,689.92
General Fund 175,000 18,332.64 18,332.64
Water Fund 98,420 11,654.94 11,654.94
Sewer Fund 21,195 5,591.61 5,591.61
Storm Water Fund 21,195 110.73 110.73
315,810 35,689.92 35,689.92
Development & Planning Services
Regular overtime 4,876.96 4,876.96
Total Dev. & Planning Services 8,200 4,876.96 4,876.96
Total Overtime paid Out 1,411,350 340,881.67 340,881.67
Hours accumulated as PTO 150,600.66 150,600.66
GRAND TOTAL 1,411,350 491,482.33 491,482.33
Comparative Overtime Report
First Quarter Second Quarter Third Quarter Fourth Quarter Total
FY 15/16 FY 16/17 FY 15/16 FY 16/17 FY 15/16 FY 16/17 FY 15/16 FY 16/17 FY 15/16 FY 16/17
General Government
Regular overtime 2,202.08 3,755.49
General Government 2,202.08 3,755.49
Finance Department
Vehicle licenses 1,388.80 3,173.28
Regular overtime 1,106.71 3,767.17 ERP Implementation
Finance Department 2,495.51 6,940.45
Police Department
Roll call 33,654.28 33,929.50 Preparation and
participation in daily roll
call, checking equipment,
and providing
assignments at the
beginning of each shift.
Comparative Overtime Report
First Quarter Second Quarter Third Quarter Fourth Quarter Total
FY 15/16 FY 16/17 FY 15/16 FY 16/17 FY 15/16 FY 16/17 FY 15/16 FY 16/17 FY 15/16 FY 16/17
Police Dept. (cont.)
FLSA 26,983.64 18,348.90 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 10,535.17 7,850.98 Completion of arrest or
assignment which occurs
near end of a shift.
Regular/Speciality 22,998.27 24,736.92 Need based recall of
recall 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 15/16 FY 16/17 FY 15/16 FY 16/17 FY 15/16 FY 16/17 FY 15/16 FY 16/17 FY 15/16 FY 16/17
Police Dept. (cont.)
Meetings/Training 59,886.41 35,331.89 Primarily comprised of
required training which
cannot be completed
while on duty. Also
includes special team
meetings as needed. Cost
reductions in Q1 are due
to the timing of quarterly
training.
Special Assignments 12,934.00 9,581.01
Private details 7,859.95 8,717.28
(reimbursable)
Court time 23,842.36 17,206.73
Minimum manning 70,148.94 28,896.10 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.
Cost reductions due to
the Department being
fully staffed beginning in
Q4 of FY 15/16.
Northbrook Days -
(partial reimb.)
Community relations 3,992.47 2,466.89 Includes National Night
Out and other community
events.
Comparative Overtime Report
First Quarter Second Quarter Third Quarter Fourth Quarter Total
FY 15/16 FY 16/17 FY 15/16 FY 16/17 FY 15/16 FY 16/17 FY 15/16 FY 16/17 FY 15/16 FY 16/17
Police Dept. (cont.)
4th of July 15,811.15 19,479.69
NIPAS/NORTAF 9,112.06 7,634.71
Police Department 297,758.70 214,180.60
Fire Department
FLSA 13,484.54 10,720.28 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 4,453.46 4,509.59 Completion of an
emergency call which
occurs near the end of a
shift.
Comparative Overtime Report
First Quarter Second Quarter Third Quarter Fourth Quarter Total
FY 15/16 FY 16/17 FY 15/16 FY 16/17 FY 15/16 FY 16/17 FY 15/16 FY 16/17 FY 15/16 FY 16/17
Fire Dept. (cont.)
Regular/recall 5,259.01 8,219.43 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 12,374.07 10,938.18 Required training which
cannot be completed
while on duty. Also
includes special team
meetings as needed.
Special teams training 28,775.00 18,962.92 Specialized training for
Dive, Technical Rescue,
and Hazmat teams which
cannot be completed
while on duty. The
decrease in FY 16/17 is
due to an altered
schedule for special
teams this year.
Comparative Overtime Report
First Quarter Second Quarter Third Quarter Fourth Quarter Total
FY 15/16 FY 16/17 FY 15/16 FY 16/17 FY 15/16 FY 16/17 FY 15/16 FY 16/17 FY 15/16 FY 16/17
Fire Dept. (cont.)
Minimum manning 83,702.11 134,912.51 Hireback of
firefighters/paramedics to
maintain minimum
required staffing of shift.
Mainly occurs when a
firefighter is ill or
injured. This cost
increased due to
firefighters being out due
to injuries.
CERT Training 681.00
(REIMBURS)
FLS Inspections 2,552.45
Administrative Work 6,805.41
Open house -
Northbrook Days -
4th of July 948.00 1,828.17
Fire Department 149,677.19 199,448.94
Comparative Overtime Report
First Quarter Second Quarter Third Quarter Fourth Quarter Total
FY 15/16 FY 16/17 FY 15/16 FY 16/17 FY 15/16 FY 16/17 FY 15/16 FY 16/17 FY 15/16 FY 16/17
Public Works
Streets & sidewalks 1,814.52 223.66
Snow & Ice control -
524.90 442.92
Parkway & street lights
Storm sewer 852.82 1,961.44
Sanitary sewer 2,290.99 4,284.07
Village building 847.85 1,007.05
Fleet 1,400.36 1,686.84
Water Production & 16,405.79 18,344.46 Increase overtime due to
Dist. pump failure
Water main breaks 1,840.05 9,197.03 Had several significant
water main breaks in the
600 block of Skokie as
well as on Walters
Avenue.
JULIE Locates 3,298.23 3,107.71
Engineering plan 7,803.23 5,040.21
review & insp.
Northbrook Days
Family Dinner
Earth Day
Misc. Special Events 1,107.30 959.66
4th of July 4,409.16 5,664.99
Roll call 5,264.50 5,626.37
Trees & storm damage 3,360.52 4,733.48
Public Works 51,220.22 62,279.89
Department
Comparative Overtime Report
First Quarter Second Quarter Third Quarter Fourth Quarter Total
FY 15/16 FY 16/17 FY 15/16 FY 16/17 FY 15/16 FY 16/17 FY 15/16 FY 16/17 FY 15/16 FY 16/17
Development &
Planning Services
Regular overtime 2,992.38 4,876.96 Inspections.
Dev. & Planning 2,992.38 4,876.96
Services
GRAND TOTAL 506,346.08 491,482.33
VILLAGE OF NORTHBROOK
Effective Interest - Actual Life
Receipts in Period
7/31/2016
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 25,955,038.00 25,955,038.00 0.00 25,955,038 25,955,038
CASH - E-PAY 0.0150 5,766,338.00 5,766,338.00 5,766,338 5,766,338
CASH - DISBURSEMENT 0.0150 7,613.00 7,613.00 7,613 7,613
CASH - SENIOR HOUSING (Closed 4/15) 0.0150 0.00 0.00 0.00 0.00 - -
CASH - SENIOR HOUSING SECURITY DEPOSITIS 0.0150 97,058.00 97,058.00 97,058 97,058
CASH - COMMUTER PARKING 0.0150 196,760.00 196,760.00 196,760 196,760
CASH - MFT 0.0150 1,069,696.00 1,069,696.00 1,069,696 1,069,696
CASH - E-911 0.0150 124,976.00 124,976.00 124,976 124,976
CASH - DRUG FORFEITURE 0.0150 10,152.00 10,152.00 10,152 10,152
1300 - THE ILLINOIS FUNDS Total 33,227,631.00 33,227,631.00 0.00 0.00 33,227,631 33,227,631
1300 - THE ILLINOIS FUNDS Total 33,227,631.00 33,227,631.00 0.00 0.00 33,227,631 33,227,631
4600 - NORTHBROOK BANK & TRUST 8100009643 MAXSAFE TM PUBLIC 10/20/11 OPEN 0.2000 1,354,394.00 1,354,394.00 0.00 0.00 1,354,394 1,354,394
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,555,845.00 4,555,845.00 0.00 0.00 4,555,845 4,555,845
7500014368 AR-0029 MONEY MARKET 07/08/08 OPEN 0.0800 3,455,588.00 3,455,588.00 0.00 0.00 3,455,588 3,455,588
CASH - PAYROLL 0.0000 0.00 0.00 0.00 0.00 - -
CASH - SENIOR HOUSING 0.0300 1,264,632.00 1,264,632.00 0.00 0.00 1,264,632 1,264,632
CASH - ANGEL 0.0300 23,163.00 23,163.00 0.00 0.00 23,163 23,163
CASH - DISBURSEMENT 0.0000 94.00 94.00 0.00 0.00 94 94
4600 - NORTHBROOK BANK & TRUST Total 15,153,716.00 15,153,716.00 0.00 0.00 15,153,716.00 15,153,716.00
4600 - NORTHBROOK BANK & TRUST Total 15,153,716.00 15,153,716.00 0.00 0.00 15,153,716.00 15,153,716.00
5000 - FIRST BANK OF HIGHLAND PARK 52006511 AR-0028 MONEY MARKET 02/08/07 Open 0.4500 18,118,620.00 18,118,620.00 0.00 0.00 18,118,620 18,118,620
52005698 CASH-DISBURSEMENT 09/21/15 0.00 0.00 0.00 0.00 - -
XXXX0101 CERTIFICATE OF DEPOSIT 08/20/15 0.8500 10,078,291.00 10,078,291.00 0.00 0.00 10,078,291 10,078,291
5000 -FIRST BANK OF HIGHLAND PARK Total 28,196,911.00 28,196,911.00 0.00 0.00 28,196,911.00 28,196,911.00
5000 - FIRST BANK OF HIGHLAND PARK Total 28,196,911.00 28,196,911.00 0.00 0.00 28,196,911.00 28,196,911.00
Investment Total
76,578,258 76,578,258 - - 76,578,258 76,578,258
Page 1 of 1
VILLAGE OF NORTHBROOK POLICE AND FIREFIGHTER'S PENSION FUNDS
Effective Interest - Actual Life
Receipts in Period
7/31/2016
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 1,788,807.00 1,788,807.00 0.00 0.00 1,788,807 1,788,807
139124585 AR-0002 Treasurs Pool 04/30/95 Open 0.0150 0.0000 1.000000 2,163,446.00 2,163,446.00 0.00 0.00 2,163,446 2,163,446
1300 - THE ILLINOIS FUNDS Total 0.0150 0.0000 1.000000 3,952,253.00 3,952,253.00 0.00 0.00 3,952,253 3,952,253
1300 - THE ILLINOIS FUNDS Total 0.0150 0.0000 1.000000 3,952,253.00 3,952,253.00 0.00 0.00 3,952,253 3,952,253
2400 - VANGUARD GROUP 919946557 AR-0010 VANGUARD 06/22/98 Open 0.0000 0.0000 1.000000 7,550,810.00 7,550,810.00 0.00 0.00 7,550,810 7,550,810
2400 - VANGUARD GROUP Total 0.0000 0.0000 1.000000 7,550,810.00 7,550,810.00 0.00 0.00 7,550,810.00 7,550,810.00
2400 - VANGUARD GROUP Total 0.0000 0.0000 1.000000 7,550,810.00 7,550,810.00 0.00 0.00 7,550,810.00 7,550,810.00
2500- FIRST BANK OF HIGHLAND PARK 52006244 HIGH YIELD 02/01/16 Open 0.0000 0.0000 1.000000 1,146,910.00 1,146,910.00 0.00 0.00 1,146,910 1,146,910
52006252 HIGH YIELD 02/01/16 Open 0.0000 0.0000 1.000000 1,210,679.00 1,210,679.00 0.00 0.00 1,210,679 1,210,679
2500 - FIRST BANK OF HIGHLAND PARK Total 0.0000 0.0000 1.000000 2,357,589.00 2,357,589.00 0.00 0.00 2,357,589.00 2,357,589.00
2500 - FIRST BANK OF HIGHLAND PARK Total 0.0000 0.0000 1.000000 2,357,589.00 2,357,589.00 0.00 0.00 2,357,589.00 2,357,589.00
2800 - FIRST TENNESSEE
452152QJ3 15-0096 ILLINOIS ST 2.42 04/01/17 08/08/14 OPEN 1.8103 1.8103 1.015680 400,000.00 406,272.00 -6,272.00 0.00 406,272.00 401,552.00
452152QJ3 15-0101 ILLINOIS ST 2.42 04/01/17 08/08/14 OPEN 1.8103 1.8103 1.015680 600,000.00 607,806.00 -7,806.00 0.00 607,806.00 602,328.00
167505JY3 15-0275 CHICAGO BRD ED BUILD AMER 4.682 12/01/17 03/26/15 OPEN 2.7500 2.7500 1.049560 450,000.00 472,302.00 -22,302.00 0.00 472,302.00 421,848.00
167505JY3 15-0296 CHICAGO BRD ED BUILD AMER 4.682 12/01/17 03/26/15 OPEN 2.7500 2.7500 1.049560 400,000.00 419,824.00 -19,824.00 0.00 419,824.00 374,976.00
777543UL1 15-0300 ROSEMONT IL 4.72 12/01/18 04/20/15 OPEN 1.8501 1.8501 1.099860 200,000.00 219,972.00 -19,972.00 0.00 219,972.00 213,874.00
777543UL1 15-0312 ROSEMONT IL 4.72 12/01/18 04/20/15 OPEN 1.8501 1.8501 1.099860 200,000.00 219,972.00 -19,972.00 0.00 219,972.00 213,874.00
452152HS3 ILLINOIS ST 5.365 3/1/17 12/18/15 Open 500,000.00 518,665.00 -18,665.00 0.00 518,665.00 510,804.91
452152HS3 ILLINOIS ST 5.365 3/1/17 12/18/15 Open 500,000.00 518,665.00 -18,665.00 0.00 518,665.00 510,805.06
94974BFW5 WELLS FARGO COM MTN 1.150% 6/2/17 02/29/16 OPEN 250,000.00 250,000.00 0.00 0.00 250,000.00 250,217.00
94974BFW5 WELLS FARGO COM MTN 1.150% 6/2/17 02/29/16 OPEN 250,000.00 250,000.00 0.00 0.00 250,000.00 250,217.00
949746NX5 WELLS FARGO COM MTN 5.6250% 12/11/17 06/07/16 OPEN 250,000.00 266,320.00 -16,320.00 0.00 266,320.00 264,777.00
949746NX5 WELLS FARGO CON MTN 5.625% 12/11/17 06/07/16 OPEN 250,000.00 266,320.00 -16,320.00 0.00 266,320.00 264,777.00
452152HT1 ILLINOIS ST 5.665% 3/1/18 07/26/16 OPEN 400,000.00 422,436.00 -22,436.00 0.00 422,436.00 422,288.00
452152HT1 ILLINOIS ST 5.665% 3/1/18 07/26/16 OPEN 400,000.00 422,436.00 -22,436.00 0.00 422,436.00 422,288.00
2800 - FIRST TENNESSEE Total 3.1529 3.0091 1.026634 5,050,000.00 5,260,990.00 -210,990.00 0.00 5,260,990.00 5,124,625.97
2800 - FIRST TENNESSEE Total 3.1529 3.0091 1.026634 5,050,000.00 5,260,990.00 -210,990.00 0.00 5,260,990.00 5,124,625.97
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 74,781
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,577
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 870
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 113,511
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,531
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 40
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 247,135
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,388
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,415
315805655 FIDELITY ADVISORS SMALL CAP CL I Open 0.0000 0.0000 4,891.72 130,394.64 0.00 0.00 130,395 130,560
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 20,091
543069405 03-0085 LONGLEAF PARTNERS INTL FUND 11/13/02 Open 0.0000 0.0000 9.469882 392.46 3,716.55 -3,324.09 0.00 3,717 5,177
471023648 07-0051 LONGLEAF PARTNERS INTL FUND 11/08/06 Open 0.0000 0.0000 18.240000 147.26 2,685.94 2,686 1,942
543069405 07-0087 LONGLEAF PARTNERS INTL FUND 12/27/06 Open 0.0000 0.0000 18.944100 1.65 31.22 31 22
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 999
543069405 08-0078 LONGLEAF PARTNERS INTL FUND 11/09/07 Open 0.0000 0.0000 20.259900 218.78 4,432.47 4,432 2,886
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 44,737
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,225
543069405 09-0148 LONGLEAF PARTNERS INTL FUND 11/07/08 Open 0.0000 0.0000 10.350000 242.50 2,509.89 2,510 3,199
543069405 09-0167 LONGLEAF PARTNERS INTL FUND 12/31/08 Open 0.0000 0.0000 10.942200 13.86 151.66 152 183
543069405 09-0197 LONGLEAF PARTNERS INTL FUND 01/02/09 Open 0.0000 0.0000 10.941200 19.93 218.06 218 263
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 51,283
543069405 11-0153 LONGLEAF PARTNERS INTL FUND 12/31/10 Open 0.0000 0.0000 15.378981 31.40 482.90 483 414
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,229
3000 - CHARLES SCHWAB Total 0.0000 0.0000 14.768316 33,555 640,168 (4,521) - 640,170 718,456
Page 1 of 7
3000 - CHARLES SCHWAB Total 0.0000 0.0000 14.768316 33,555 640,168 (4,521) - 640,170 718,456
3100 - WILLIAM BLAIR
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
912810RJ9 US TREASURY BOND 3.00% 11/15/44 01/27/16 Open 0.0000 0.0000 250,000.00 267,422.00 -17,422.00 0.00 267,422 293,730
912810RJ9 US TREASURY BOND 3.00% 11/15/44 01/27/16 Open 0.0000 0.0000 250,000.00 267,422.00 -17,422.00 0.00 267,422 293,730
912810RJ9 US TREASURY BOND 3.00% 11/15/44 04/15/16 Open 0.0000 0.0000 350,000.00 379,367.00 -29,367.00 0.00 379,367 180,918
912810RJ9 US TREASURY BOND 3.00% 11/15/44 04/15/16 OPEN 0.0000 0.0000 350,000.00 379,367.00 -29,367.00 0.00 379,367 180,918
970648AD3 WILLIS NORTH AMERICA 6.200% 3/28/17 04/20/16 Open 0.0000 0.0000 300,000.00 312,516.00 -12,516.00 0.00 312,516 309,852
970648AD3 WILLIS NORTH AMERICA 6.200% 3/28/17 04/20/16 OPEN 0.0000 0.0000 300,000.00 312,516.00 -12,516.00 0.00 312,516 309,852
743410AW2 PROLOGIS 6.875% 3/15/20 04/21/16 Open 0.0000 0.0000 135,000.00 148,070.00 -13,070.00 0.00 148,070 152,570
743410AW2 PROLOGIS 6.875% 3/15/20 04/24/16 OPEN 0.0000 0.0000 135,000.00 148,070.00 -13,070.00 0.00 148,070 152,570
345397VX8 FORD MOTOR CREDIT 4.250% 2/3/17 03/07/16 Open 0.0000 0.0000 500,000.00 510,570.00 -10,570.00 0.00 510,570 507,335
345397VX8 FORD MOTOR CREDIT 4.250% 2/3/17 03/07/16 Open 0.0000 0.0000 500,000.00 510,570.00 -10,570.00 0.00 510,570 507,335
912834KP2 US TREASURY BOND 8/15/41 06/15/16 Open 0.0000 0.0000 250,000.00 133,445.00 116,555.00 0.00 133,445 142,082
9128334S6 US TREASURY BOND 8/15/31 06/17/16 Open 0.0000 0.0000 275,000.00 203,065.00 71,935.00 0.00 203,065 207,729
912834KP2 US TREASURY BOND 8/15/41 06/15/16 Open 0.0000 0.0000 250,000.00 133,445.00 116,555.00 0.00 133,445 142,082
9128334S6 US TREASURY BOND 8/15/31 06/17/16 Open 0.0000 0.0000 275,000.00 203,065.00 71,935.00 0.00 203,065 207,729
9128335A4 US TREASURY BOND 8/15/35 07/06/16 Open 0.0000 0.0000 400,000.00 272,944.00 127,056.00 0.00 272,944 270,656
912833LX6 US TREASURY BOND 11/15/25 07/06/16 Open 0.0000 0.0000 350,000.00 304,038.00 45,962.00 0.00 304,038 302,396
9128335A4 US TREASURY BOND 8/15/35 07/06/16 Open 0.0000 0.0000 400,000.00 272,944.00 127,056.00 0.00 272,944 270,656
912833LX6 US TREASURY BOND 11/15/25 07/06/16 Open 0.0000 0.0000 350,000.00 304,038.00 45,962.00 0.00 304,038 302,396
3100 - WILLIAM BLAIR Total 0.580600 0.5806 1.014884 5,620,000 5,062,874 557,126 - 5,062,874 4,734,536
3100 - WILLIAM BLAIR Total 0.900200 0.9002 1.036760 5,620,000 5,062,874 557,126 - 5,062,874 4,734,536
3200-HILLTOP SECURITIES, INC 127055AG6 CABOT CORP 5.00% 10/1/16 03/09/16 OPEN 0.0000 0.0000 245,000.00 249,451.00 -4,951.00 0.00 249,451 246,414
127055AG6 CABOT CORP 5.00% 10/1/16 03/09/16 OPEN 0.0000 0.0000 245,000.00 249,451.00 -4,951.00 0.00 249,451 246,414
3200 - HILLTOP SECURITIES INC Total 0.580600 0.5806 1.014884 490,000 498,902 (9,902) - 498,902 492,828
3200 - HILLTOP SECURITIES INC Total 0.900200 0.9002 1.036760 490,000 498,902 (9,902) - 498,902 492,828
3600 - MISCHLER FINANCIAL GROUP INC 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 159,888
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 532,961
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 159,888
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 532,961
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 178,670
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 268,005
345397VX8 FORD MOTOR CREDIT 4.25% 2/3/17 01/13/16 500,000.00 520,999.00 -20,999.00 0.00 520,999 507,335
140420ND8 CAPITAL ONE BANK MTN 1.15% 11/21/16 01/29/16 250,000.00 250,383.06 -383.06 0.00 250,383 250,167
959802AB5 WESTERN UNION CO 5.930% 10/1/16 01/29/16 200,000.00 210,017.44 -10,017.44 0.00 210,017 201,540
240019BS7 DAYTON POWER LIGHT 1.875% 9/15/16 01/29/16 400,000.00 403,911.67 -3,911.67 0.00 413,912 400,280
345397VX8 FORD MOTOR CREDIT 4.25% 2/3/17 01/13/16 500,000.00 520,999.00 -20,999.00 0.00 520,999 507,335
140420ND8 CAPITAL ONE BANK MTN 1.15% 11/21/16 01/29/16 250,000.00 250,383.06 -383.06 0.00 250,383 250,167
959802AB5 WESTERN UNION CO 5.930% 10/1/16 01/29/16 200,000.00 210,017.44 -10,017.44 0.00 210,017 201,540
240019BS7 DAYTON POWER LIGHT 1.875% 9/15/16 01/29/16 400,000.00 403,911.67 -3,911.67 0.00 413,912 400,280
216871AC7 COOPER US INC 6.10% 7/1/17 02/29/16 200,000.00 212,450.00 -12,450.00 0.00 212,450 208,912
216871AC7 COOPER US INC 6.10% 7/1/17 02/29/16 200,000.00 212,450.00 -12,450.00 0.00 212,450 208,912
031162AV2 AMGEN INC 5.80% 6/1/17 03/09/16 290,000.00 305,645.00 -15,645.00 0.00 305,645 301,127
031162AV2 AMGEN INC 5.80% 6/1/17 03/09/16 290,000.00 305,645.00 -15,645.00 0.00 305,645 301,127
55616XAA5 MACYS RETAIL HLDGS 7.450% 7/15/17 03/11/16 275,000.00 295,537.00 -20,537.00 0.00 295,537 290,854
55616XAA5 MACYS RETAIL HLDGS 7.450% 7/15/17 03/11/16 275,000.00 295,537.00 -20,537.00 0.00 295,537 290,854
025816AX7 AMERICAN EXPRESS 6.150% 8/28/17 03/31/16 500,000.00 532,705.00 -32,705.00 0.00 532,705 526,385
025816AX7 AMERICAN EXPRESS 6.150% 8/28/17 03/31/16 500,000.00 532,705.00 -32,705.00 532,705 526,385
313384B57 FHLB 8/10/16 05/31/16 700,000.00 699,420.00 580.00 0.00 699,420 699,965
313384D48 FHLB 8/25/16 05/31/16 700,000.00 699,281.00 720.00 0.00 699,281 699,888
313384B57 FHLB 8/10/16 05/31/16 500,000.00 499,586.00 414.00 0.00 499,586 499,975
313384D48 FHLB 8/25/16 05/31/16 500,000.00 499,486.00 514.00 0.00 499,486 499,920
89233P5E2 TOYOTA MOTOR CREDIT CORP 2.00% 9/15/16 06/01/16 225,000.00 225,938.00 -938.00 0.00 225,938 225,337
89233P5E2 TOYOTA MOTOR CREDIT CORP 2.00% 9/15/16 06/01/16 225,000.00 225,938.00 -938.00 0.00 225,938 225,337
0258M0DC0 AMERICAN EXPRESS CREDIT 2.80% 9/19/16 07/19/16 350,000.00 351,312.00 -1,312.00 0.00 351,312 350,952
0258M0DC0 AMERICAN EXPRESS CREDIT 2.80% 9/19/16 07/19/16 350,000.00 351,312.00 -1,312.00 0.00 351,312 350,952
628530BE6 MYLAN INC 1.35% 11/29/16 07/26/16 200,000.00 200,250.00 -250.00 0.00 200,250 200,110
628530BE6 MYLAN INC 1.35% 11/29/16 07/26/16 200,000.00 200,250.00 -250.00 0.00 200,250 200,110
075887BB4 BECTON DICKINSON 1.75% 11/8/16 07/29/16 425,000.00 426,135.00 -1,135.00 0.00 426,135 425,965
075887BB4 BECTON DICKINSON 1.75% 11/8/16 07/29/16 425,000.00 426,135.00 -1,135.00 0.00 426,135 425,965
3600 - MISCHLER FINANCIAL GROUP, INC. Total 2.0903 2.0903 1.048388 11,830,721.00 12,166,528.13 -335,805.13 0.00 12,186,527.00 12,010,049.00
3600 - MISCHLER FINANCIAL GROUP, INC. Total Page 2 of 7 2.0903 2.0903 1.048388 11,830,721.00 12,166,528.13 -335,805.13 0.00 12,186,527.00 12,010,049.00
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
4600 - BMO HARRIS 3175346 Cash Open 0.0500 0.0000 1.000000 10,000.00 10,000.00 0.00 0.00 10,000 10,000
3175221 Cash Open 0.0500 0.0000 1.000000 10,000.00 10,000.00 0.00 0.00 10,000 10,000
4600 - BMO HARRIS Total 0.0500 0.9098 1.000000 20,000.00 20,000.00 0.00 0.00 20,000.00 20,000
4600 - BMO HARRIS Total 0.0500 0.9098 1.000000 20,000.00 20,000.00 0.00 0.00 20,000.00 20,000
4900 - PERSHING 36212UVW8 08-0004 GNMA #544329 5.00 1/15/22 12/23/04 Open 5.1363 5.1363 0.991250 108,044.00 107,090.00 1,523.36 0.00 107,090 112,624
36202FVF0 12-0081 GNMA #005114 4.00 7/20/41 08/18/11 Open 3.4812 3.4812 1.065517 326,654.00 348,687.00 -22,033.00 0.00 348,687 350,719
61746BDB9 14-0268 MORGAN STANLEY MTN 5.75 10/18/16 03/21/14 Open 1.2637 1.2637 1.113300 400,000.00 445,320.00 -45,320.00 0.00 445,320 404,076
61746BDB9 14-0269 MORGAN STANLEY MTN 5.75 10/18/16 03/21/14 Open 1.2637 1.2637 1.113300 300,000.00 333,950.00 -33,990.00 0.00 333,950 303,057
451102BB2 15-0020 ICAHN ENTERPRISES 4.875 3/15/19 05/23/14 Open 4.2016 4.2016 1.029000 200,000.00 205,800.00 -5,800.00 0.00 205,800 198,500
451102BB2 15-0021 ICAHN ENTERPRISES 4.875 3/15/19 05/23/14 Open 4.2016 4.2016 1.029000 300,000.00 308,700.00 -8,700.00 0.00 308,700 297,750
25271CAL6 15-0208 DIAMOND OFFSHORE DRILL 5.70 10/15/39 12/29/14 Open 5.9600 5.9600 0.966440 250,000.00 241,610.00 8,390.00 0.00 241,610 203,400
25271CAL6 15-0210 DIAMOND OFFSHORE DRILL 5.70 10/15/39 12/29/14 Open 5.9600 5.9600 0.966440 300,000.00 289,932.00 10,068.00 0.00 289,932 244,080
452152HS3 15-0265 ILLINOIS ST 5.365 03/01/17 03/19/15 Open 1.4205 1.4205 1.075590 525,000.00 564,684.75 -39,684.75 0.00 564,685 536,345
452152HS3 15-0291 ILLINOIS ST 5.365 03/01/17 03/19/15 Open 1.4205 1.4205 1.075590 385,000.00 414,102.15 -29,102.15 80.00 414,102 393,320
452152FW6 15-0301 ILLINOIS ST 5.125 07/01/17 04/24/15 Open 1.6602 1.6602 1.074060 750,000.00 805,545.00 -55,545.00 0.00 805,545 770,542
452152FW6 15-0313 ILLINOIS ST 5.125 7/1/17 04/24/15 Open 1.6602 1.6602 1.074060 750,000.00 805,545.00 -55,545.00 0.00 805,545 770,542
565849AK2 16-22 MARATHON OIL CORP 2.800 11/1/22 07/01/15 Open 0.0000 0.0000 0.000000 200,000.00 189,833.33 11,166.00 0.00 189,833 178,670
565849AK2 16-23 MARATHON OIL CORP 2.800 11/1/22 07/01/15 Open 0.0000 0.0000 0.000000 300,000.00 284,750.00 15,250.00 0.00 284,750 268,005
4900 -PERSHING Total 1.6476 1.4757 1.044748 5,094,698.00 5,345,549.23 -249,322.54 0.00 5,238,459.00 5,031,630.05
4900 - PERSHING Total 1.6476 1.4757 1.044748 5,094,698.00 5,345,549.23 -249,322.54 0.00 5,238,459.00 5,031,630.05
5000 - BROWNSTONE INVESTMENT GROUP
29081YAB2 EMBRAER OVERSEAS LTD 6.375 1/24/17 12/22/15 Open 0.0000 0.0000 0.000000 300,000.00 307,431.00 -7,431.00 0.00 307,431 304,875
29081YAB2 EMBRAER OVERSEAS LTD 6.375 1/24/17 12/22/15 Open 0.0000 0.0000 0.000000 300,000.00 307,431.00 -7,431.00 0.00 307,431 304,875
845437BH4 SOUTHWESTERN ELEC PWR 5.550% 1/15/17 02/29/16 Open 0.0000 0.0000 0.000000 250,000.00 259,182.00 -9,182.00 0.00 259,182 254,942
845437BH4 SOUTHWESTERN ELEC PWR 5.550% 1/15/17 02/29/16 Open 0.0000 0.0000 0.000000 250,000.00 259,182.00 -9,182.00 0.00 259,182 254,942
240019BS7 DAYTON POWER LIGHT 1.875% 9/15/16 03/07/16 Open 0.0000 0.0000 0.000000 500,000.00 501,820.00 -1,820.00 0.00 501,820 500,350
240019BS7 DAYTON POWER LIGHT 1.875% 9/15/16 03/07/16 Open 0.0000 0.0000 0.000000 500,000.00 501,820.00 -1,820.00 0.00 501,820 500,350
200339CG2 COMERICA BANK 5.75% 11/21/16 03/10/16 Open 0.0000 0.0000 0.000000 300,000.00 308,916.00 -8,916.00 0.00 308,916 304,038
200339CG2 COMERICA BANK 5.75% 11/21/16 03/10/16 Open 0.0000 0.0000 0.000000 300,000.00 308,916.00 -8,916.00 0.00 308,916 304,038
55279HAD2 MANUF TRADERS TRUST CO 1.25% 1/30/17 06/17/16 Open 0.0000 0.0000 0.000000 324,000.00 324,431.00 -431.00 0.00 324,431 324,172
55279HAD2 MANUF TRADERS TRUST CO 1.25% 1/30/17 06/17/16 Open 0.0000 0.0000 0.000000 324,000.00 324,431.00 -431.00 0.00 324,431 324,172
5000 -BROWNSTONE INVESTMENT GROUP Total 0.0000 0.0000 0.000000 3,348,000.00 3,403,560.00 -55,560.00 0.00 3,403,560.00 3,376,754.00
5000 - BROWNSTONE INVESTMENT GROUPTotal 0.0000 0.0000 0.000000 3,348,000.00 3,403,560.00 -55,560.00 0.00 3,403,560.00 3,376,754.00
5050 - SOUTHWEST SECURITIES, INC
452152HS3 ILLINOIS ST 5.365 3/1/17 12/04/15 Open 0.0000 0.0000 0.000000 400,000.00 415,408.00 -15,408.00 0.00 415,408 408,644
452152HT1 ILLINOIS ST 5.665 3/1/18 12/07/15 Open 0.0000 0.0000 0.000000 150,000.00 158,932.00 -8,932.00 0.00 158,932 158,358
452152HS3 ILLINOIS ST 5.365 3/1/17 12/04/15 Open 0.0000 0.0000 0.000000 400,000.00 415,408.00 -15,408.00 0.00 415,408 408,644
452152HT1 ILLINOIS ST 5.665 3/1/18 12/07/15 Open 0.0000 0.0000 0.000000 150,000.00 158,932.00 -8,932.00 0.00 158,932 158,358
5050 -SOUTHWEST SECURITIES INC Total 0.0000 0.0000 0.000000 1,100,000.00 1,148,680.00 -48,680.00 0.00 1,148,680.00 1,134,003.98
5050 - SOUTHWEST SECURITIES INCTotal 0.0000 0.0000 0.000000 1,100,000.00 1,148,680.00 -48,680.00 0.00 1,148,680.00 1,134,003.98
5051 - GOLDMAN SACHS
577778BD4 MACYS RETAIL HLD 7.875 8/15/36 09/10/15 Open 0.0000 0.0000 0.000000 395,000.00 417,712.00 -22,712.00 0.00 417,712 395,715
5051 -GOLDMAN SACHS Total 0.0000 0.0000 0.000000 395,000.00 417,712.00 -22,712.00 0.00 417,712.00 395,715.00
5051 - GOLDMAN SACHS Total 0.0000 0.0000 0.000000 395,000.00 417,712.00 -22,712.00 0.00 417,712.00 395,715.00
00287Y109 ABBVIE INC 07/12/16 Open 0.0000 0.0000 5,900.00 374,196.00 0.00 0.00 374,196.00 390,757
00508Y102 ACUITY BRANDS INC Open 0.0000 0.0000 900.00 233,860.00 0.00 0.00 233,860.00 236,187
00508Y102 ACUITY BRANDS INC Open 0.0000 0.0000 1,400.00 354,371.00 0.00 0.00 354,371.00 367,402
02079K305 ALPHABET INC CL A Open 0.0000 0.0000 300.00 228,802.00 0.00 0.00 228,802.00 237,402
023135106 AMAZON COM INC 400.00 250,618.00 0.00 0.00 250,618.00 303,524
023135106 AMAZON COM INC 500.00 359,455.00 0.00 0.00 359,455.00 379,405
025537101 13-0043 AMERICAN ELECTRIC POWER CO INC 07/06/12 OPEN 0.0000 0.0000 40.229500 1,000.00 40,229.00 0.00 0.00 80,459.00 69,300
025537101 13-0078 AMERICAN ELECTRIC POWER CO INC 08/02/12 OPEN 0.0000 0.0000 42.629200 1,400.00 56,321.00 0.00 0.00 51,155.00 97,020
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 149,783
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 79,544
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,348
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 72,796
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,068
29875E100 15-0177 AMERICAN EUROPACIFIC GROWTH F2 12/30/14 OPEN 0.0000 0.0000 47.489162 117.18 5,564.78 0.00 0.00 5,565.00 5,446
649280823 AMERICAN FUNDS NEW WORLD FUND Page 3 of 7 Open 0.0000 0.0000 5,328.00 275,000.00 0.00 0.00 275,000.00 284,515
649280823 AMERICAN FUNDS NEW WORLD FUND Open 0.0000 0.0000 3,945.00 200,000.00 0.00 0.00 200,000.00 210,663
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 11,030
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 20,880
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,412
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,515
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,618
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,103
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,515
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,103
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,515
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 64,305
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 24,266
029683109 AMERICAN SOFTWARE INC CL A Open 0.0000 0.0000 1,470.00 20,245.00 0.00 0.00 20,245.00 16,214
029899101 13-0044 AMERICAN STATES WATER CO 07/06/12 OPEN 0.0000 0.0000 39.663000 1,900.00 37,680.00 0.00 0.00 37,680.00 82,080
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 56,160
029899101 AMERICAN STATES WATER CO 07/21/16 OPEN 0.0000 0.0000 300.00 17,321.00 0.00 0.00 17,321.00 12,960
029899101 AMERICAN STATES WATER CO 07/21/16 Open 0.0000 0.0000 400.00 17,148.00 0.00 0.00 17,148.00 17,280
03027X100 AMERICAN TOWER CORP OPEN 0.0000 0.0000 3,400.00 360,400.00 0.00 0.00 360,400.00 393,618
03027X100 AMERICAN TOWER CORP Open 0.0000 0.0000 2,100.00 244,398.00 0.00 0.00 244,398.00 243,117
03073E105 15-0231 AMERISOURCEBERGEN CORP 02/02/15 OPEN 0.0000 0.0000 96.635200 2,600.00 252,477.00 0.00 0.00 252,477.00 221,494
00170K208 AMG MANAGERS SKYLINE SPECIAL Open 0.0000 0.0000 6,343.00 239,371.00 0.00 0.00 239,371.00 238,180
037833100 08-0165 APPLE, INC 02/19/08 OPEN 0.0000 0.0000 127.209000 2,100.00 86,842.00 0.00 0.00 86,842.00 218,841
037833100 APPLE, INC Open 0.0000 0.0000 300.00 29,973.00 0.00 0.00 29,973.00 31,263
037833100 14-0273 APPLE, INC 04/21/14 OPEN 0.0000 0.0000 516.525800 3,600.00 280,701.00 0.00 0.00 280,701.00 375,156
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 78,728
04010L103 ARES CAP CORP Open 0.0000 0.0000 1,900.00 26,692.00 0.00 0.00 26,692.00 28,766
042068106 ARM HLDGS PLC ADR Open 0.0000 0.0000 8,300.00 367,029.00 0.00 0.00 367,029.00 550,788
00206R102 AT&T INC OPEN 0.0000 0.0000 5,800.00 247,995.00 0.00 0.00 247,995.00 251,082
00206R102 AT&T INC Open 0.0000 0.0000 8,800.00 373,723.00 0.00 0.00 373,723.00 380,952
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 163,724
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 37,576
09253U108 BLACKSTONE GROUP LP OPEN 0.0000 0.0000 700.00 36,468.00 0.00 0.00 36,468.00 18,788
09253U108 15-0307 BLACKSTONE GROUP LP 04/13/15 Open 0.0000 0.0000 39.227000 10,200.00 400,115.00 0.00 0.00 400,115.00 273,768
09253U108 BLACKSTONE GROUP LP OPEN 0.0000 0.0000 2,600.00 70,515.00 0.00 0.00 70,515.00 69,784
09253U108 BLACKSTONE GROUP LP 07/21/16 OPEN 0.0000 0.0000 1,100.00 27,654.00 0.00 0.00 27,654.00 29,524
09253U108 BLACKSTONE GROUP LP 07/21/16 Open 0.0000 0.0000 2,500.00 60,857.00 0.00 0.00 60,857.00 67,100
Y09827109 BROADCOM LTD OPEN 0.0000 0.0000 1,500.00 188,995.00 0.00 0.00 188,995.00 242,970
Y09827109 BROADCOM LTD Open 0.0000 0.0000 2,300.00 233,807.00 0.00 0.00 233,807.00 372,554
118230101 BUCKEYE PARTNERS LP OPEN 0.0000 0.0000 5,300.00 362,406.00 0.00 0.00 362,406.00 381,918
12673P105 14-0031 CA INC 05/07/13 OPEN 0.0000 0.0000 27.100800 2,900.00 86,723.00 0.00 0.00 86,723.00 100,485
12673P105 14-0092 CA INC 05/22/13 OPEN 0.0000 0.0000 27.530000 2,000.00 63,319.00 0.00 0.00 63,319.00 69,300
128030202 CAL MAINE FOODS INC OPEN 0.0000 0.0000 1,100.00 51,673.00 0.00 0.00 51,673.00 46,090
128030202 CAL MAINE FOODS INC OPEN 0.0000 0.0000 1,600.00 77,756.00 0.00 0.00 77,756.00 67,040
128030202 CAL MAINE FOODS INC 07/21/16 Open 0.0000 0.0000 500.00 22,394.14 0.00 0.00 22,394.14 20,950
128030202 CAL MAINE FOODS INC 07/12/16 OPEN 0.0000 0.0000 600.00 27,107.00 0.00 0.00 27,107.00 25,140
151020104 CELGENE CORP OPEN 0.0000 0.0000 3,200.00 358,656.00 0.00 0.00 358,656.00 359,008
151020104 CELGENE CORP OPEN 0.0000 0.0000 300.00 31,197.00 0.00 0.00 31,197.00 33,657
151020104 CELGENE CORP Open 0.0000 0.0000 2,200.00 57,887.00 0.00 0.00 57,887.00 246,818
17800P407 CNI CHARTER EMERGING MARKETS 07/19/16 OPEN 0.0000 0.0000 7,414.73 300,000.00 0.00 0.00 300,000.00 304,004
192446102 16- COGNIZANT TECH SOLUTIONS CL A 06/11/15 OPEN 0.0000 0.0000 64.045800 4,000.00 256,303.20 0.00 0.00 256,303.00 229,960
192446102 COGNIZANT TECH SOLUTIONS CL A Open 0.0000 0.0000 5,700.00 369,481.00 0.00 0.00 369,481.00 327,693
192446102 COGNIZANT TECH SOLUTIONS CL A OPEN 0.0000 0.0000 900.00 51,191.00 0.00 0.00 51,191.00 51,741
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 206,105
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,139
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,182
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,152
197199813 COLUMBIA ACORN INTL FUND CL Z OPEN 0.0000 0.0000 1,205.00 51,183.00 0.00 0.00 51,183.00 48,465
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 65,464
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 84,168
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 18,704
21036P108 CONSTELLATION BRANDS INC A 07/12/16 OPEN 0.0000 0.0000 2,300.00 381,379.00 0.00 0.00 381,379.00 378,649
22822V101 CROWN CASTLE INTL CORP OPEN 0.0000 0.0000 600.00 52,038.00 0.00 0.00 52,038.00 58,218
22822V101 CROWN CASTLE INTL CORP OPEN 0.0000 0.0000 900.00 73,233.00 0.00 0.00 73,233.00 87,327
126650100 13-0240 CVS/CAREMARK CORP 04/18/13 OPEN 0.0000 0.0000 56.986600 2,500.00 148,153.00 0.00 0.00 148,153.00 231,800
126650100 14-0012 CVS/CAREMARK CORP 05/24/13 OPEN
Page 4 of 7 0.0000 0.0000 59.261200 3,600.00 199,322.00 0.00 0.00 199,322.00 333,792
233331107 DTE ENERGY CO OPEN 0.0000 0.0000 600.00 50,801.00 0.00 0.00 50,801.00 58,512
233331107 DTE ENERGY CO OPEN 0.0000 0.0000 1,000.00 78,158.00 0.00 0.00 78,158.00 97,520
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
237194105 DARDEN RESTAURANTS INC OPEN 0.0000 0.0000 1,600.00 94,943.00 0.00 0.00 94,943.00 98,496
237194105 DARDEN RESTAURANTS INC OPEN 0.0000 0.0000 1,300.00 76,323.00 0.00 0.00 76,323.00 80,028
247361702 14-0097 DELTA AIR LINES INC 07/08/13 OPEN 0.0000 0.0000 18.784400 4,800.00 232,546.00 0.00 0.00 232,546.00 186,000
247361702 DELTA AIR LINES INC OPEN 0.0000 0.0000 1,500.00 60,479.00 0.00 0.00 60,479.00 58,125
247361702 15-0281 DELTA AIR LINES INC 03/06/15 OPEN 0.0000 0.0000 44.856500 7,900.00 193,634.00 0.00 0.00 193,634.00 306,125
247361702 DELTA AIR LINES INC OPEN 0.0000 0.0000 2,400.00 87,024.00 0.00 0.00 87,024.00 93,000
26613Q106 15-0218 DUPONT FABROS TECHNOLOGY 01/08/15 OPEN 0.0000 0.0000 33.529400 2,400.00 80,470.00 0.00 0.00 93,882.00 114,792
26613Q106 15-0232 DUPONT FABROS TECHNOLOGY 02/02/15 OPEN 0.0000 0.0000 37.930000 1,600.00 60,688.00 0.00 0.00 60,688.00 76,528
316128834 15-0048 FIDELITY ADVISOR MID CAP VALUE 07/17/14 OPEN 0.0000 0.0000 23.990000 13,805.00 329,675.00 0.00 0.00 329,675.00 323,175
316389717 FIDELITY ADVISOR SMALL CAP GRW FD 1 OPEN 0.0000 0.0000 21.940000 20,366.93 394,377.00 0.00 0.00 394,377.00 404,487
31428X106 FED EX CORP OPEN 0.0000 0.0000 1,400.00 234,740.00 0.00 0.00 234,740.00 226,660
31428X106 FED EX CORP OPEN 0.0000 0.0000 2,500.00 408,921.00 0.00 0.00 408,921.00 404,750
H2906T109 GARMIN LTD OPEN 0.0000 0.0000 1,600.00 56,765.00 0.00 0.00 56,765.00 86,928
H2906T109 GARMIN LTD OPEN 0.0000 0.0000 2,400.00 80,035.00 0.00 0.00 80,035.00 130,392
372460105 14-0002 GENUINE PARTS CO 05/22/13 OPEN 0.0000 0.0000 80.709900 700.00 56,497.00 0.00 0.00 64,568.00 71,568
372460105 14-0030 GENUINE PARTS CO 05/07/13 OPEN 0.0000 0.0000 75.710200 900.00 68,139.00 0.00 0.00 83,281.00 92,016
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 254,864
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 2,488
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 17,355
38142Y500 15-0178 GOLDMAN SACHS GRWTH OPP FUND 12/05/14 OPEN 0.0000 0.0000 24.010000 3,892.01 93,447.18 0.00 0.00 93,447.00 82,083
38142Y500 GOLDMAN SACHS GRWTH OPP FUND OPEN 0.0000 0.0000 4,826.36 105,772.82 0.00 0.00 105,773.00 101,788
41012R811 14-0055 HANCOCK HORIZON BURKENROAD SMALL 06/04/13 OPEN 0.0000 0.0000 48.609997 6,382.00 311,424.00 0.00 0.00 311,424 367,220
413875105 HARRIS CORP DEL OPEN 0.0000 0.000000 3,000.00 235,430.00 0.00 0.00 235,430 259,860
413875105 HARRIS CORP DEL OPEN 0.0000 0.0000 4,500.00 370,989.00 0.00 0.00 370,989 389,790
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 194,186
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 75,034
41664L294 HARTFORD INTL OPPORTUNITY I OPEN 0.0000 0.0000 4,608.00 69,193.00 0.00 0.00 69,193 66,263
437076102 15-0085 HOME DEPOT 08/11/14 OPEN 0.0000 0.0000 80.769900 1,900.00 150,408.00 0.00 0.00 150,408.00 262,656
437076102 14-0010 HOME DEPOT 05/24/13 OPEN 0.0000 0.0000 78.420000 2,700.00 320,228.00 0.00 0.00 367,670.00 373,248
44106M102 15-0248 HOSPITALITY PPTYS TR 02/24/15 OPEN 0.0000 0.0000 31.773800 1,800.00 57,192.84 0.00 0.00 57,193.00 57,438
44106M102 HOSPITALITY PPTYS TR O 0.0000 0.0000 500.00 15,679.00 0.00 0.00 15,679.00 15,955
44106M102 16- HOSPITALITY PPTYS TR 06/11/15 OPEN 0.0000 0.0000 29.725800 3,100.00 92,242.98 0.00 0.00 92,242.98 98,921
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 264,200
45865V100 INTERCONTINENTAL EXCHANGE INC OPEN 0.0000 0.0000 1,500.00 355,971.00 0.00 0.00 355,971.00 396,300
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 353,258
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,451
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 14,096
465899706 IVY INTERNATIONAL CORE EQUITY OPEN 0.0000 0.0000 4,078.94 69,719.59 0.00 0.00 69,720.00 67,588
471023549 15-0160 JANUS INVT FD 12/12/14 OPEN 0.0000 0.0000 25.189962 3,374.36 85,000.00 0.00 0.00 85,000.00 80,377
471023549 15-0234 JANUS INVT FD 02/20/15 OPEN 0.0000 0.0000 24.479993 7,761.44 190,000.00 0.00 0.00 190,000.00 184,877
471023549 JANUS INVT FD OPEN 0.0000 0.0000 7,393.99 158,883.00 0.00 0.00 158,883.00 176,125
471023549 JANUS INVT FD OPEN 0.0000 0.0000 10,808.00 212,563.00 0.00 0.00 212,563.00 257,447
471023549 JANUS INVT FD OPEN 0.0000 0.0000 6,452.00 45,621.00 0.00 0.00 45,621.00 153,687
501044101 14-0146 KROGER CO 11/14/13 OPEN 0.0000 0.0000 41.462100 6,000.00 118,457.00 0.00 0.00 118,457.00 205,140
521865204 15-0120 LEAR CORP 10/10/14 OPEN 0.0000 0.0000 88.253400 2,300.00 239,265.00 0.00 0.00 239,265.00 260,935
521865204 LEAR CORP OPEN 0.0000 0.0000 3,000.00 264,760.00 0.00 0.00 264,760.00 340,350
525327102 LEIDOS HOLDINGS INC OPEN 0.0000 0.0000 1,400.00 61,879.00 0.00 0.00 61,879.00 70,014
525327102 LEIDOS HOLDINGS INC OPEN 0.0000 0.0000 2,000.00 84,078.00 0.00 0.00 84,078.00 100,020
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 148,441
543069405 LONGLEAF PARTNERS INTL FUND OPEN 0.0000 0.0000 3,736.81 66,000.00 0.00 0.00 66,000.00 49,289
58933Y105 13-0047 MERCK AND CO INC 07/06/12 OPEN 0.0000 0.0000 41.779500 1,100.00 48,994.00 0.00 0.00 79,381.00 64,526
58933Y105 13-0070 MERCK AND CO INC 08/02/12 OPEN 0.0000 0.0000 44.540000 1,600.00 66,847.00 0.00 0.00 53,448.00 93,856
55272X102 07-0251 MFA MORTGAGE INVESTMENTS INC 03/01/07 OPEN 0.0000 0.0000 7.347000 1,200.00 8,816.44 0.00 0.00 8,816.00 9,024
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 50,384
55272X102 MFA MORTGAGE INVESTMENTS INC OPEN 0.0000 0.0000 1,700.00 11,425.00 0.00 0.00 11,425.00 12,784
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 275,599
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 430,949
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 158,528
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 340,837
55273E822 15-0047 MFS INTERNATIONAL VALUE FUND I 07/17/14 OPEN 0.0000 0.0000 37.090016 8,088.43 300,000.00 0.00 0.00 300,000.00 313,912
55273E822 MFS INTERNATIONAL VALUE FUND I OPEN 0.0000 0.0000 8,584.00 313,885.00 0.00 0.00 313,885.00 333,145
595017104 10-0147 MICROCHIP TECHNOLOGY INC 01/14/10 OPEN 0.0000 0.0000 28.557280 1,300.00 37,464.00 0.00 0.00 37,464.00 72,332
595017104 13-0012 MICROCHIP TECHNOLOGY INC 05/04/12 OPEN
Page 5 of 7 0.0000 0.0000 35.470000 2,000.00 76,915.00 0.00 0.00 76,915.00 111,280
61174X109 MONSTER BREVERAGE CORP OPEN 0.0000 0.0000 1,700.00 240,505.00 0.00 0.00 240,505.00 273,071
628530107 15-0314 MYLAN INC 04/09/15 OPEN 0.0000 0.0000 57.702400 5,500.00 300,979.00 0.00 0.00 300,979.00 257,345
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
628530107 15-0315 MYLAN INC 04/09/15 OPEN 0.0000 0.0000 57.702400 8,400.00 441,942.00 0.00 0.00 441,942.00 393,036
670725712 NUVEEN INTERNATIONAL GROWTH 1 Open 0.0000 0.0000 5,648.20 210,000.00 0.00 0.00 210,000.00 213,841
67064Y727 15-0050 NUVEEN NWQ SMALL CAP VALUE INDEX 07/17/14 OPEN 0.0000 0.0000 41.970017 10,721.94 450,000.00 0.00 0.00 450,000.00 491,601
67064Y727 15-0083 NUVEEN NWQ SMALL CAP VALUE INDEX 08/08/14 OPEN 0.0000 0.0000 40.090000 7,233.72 290,000.00 0.00 0.00 290,000.00 331,666
67064Y727 15-0151 NUVEEN NWQ SMALL CAP VALUE INDEX 11/07/14 OPEN 0.0000 0.0000 42.429944 2,710.35 115,000.00 0.00 0.00 115,000.00 124,269
670678200 NUVEEN SMALL CAP VALUE FUND CL 1 OPEN 0.0000 0.0000 21,971.00 448,000.00 0.00 0.00 448,000.00 484,461
670678200 NUVEEN SMALL CAP VALUE FUND CL 1 OPEN 0.0000 0.0000 18,445.00 375,000.00 0.00 0.00 375,000.00 406,712
62944T105 NVR INC OPEN 0.0000 0.0000 200.00 320,396.00 0.00 0.00 320,396.00 341,000
62944T105 NVR INC OPEN 0.0000 0.0000 125.00 219,512.00 0.00 0.00 219,512.00 213,125
413838202 12-0055 OAKMARK INTERNATIONAL FUND 07/28/11 OPEN 0.0000 0.0000 19.600000 15,144.30 303,649.00 0.00 0.00 303,649.00 313,033
674375506 OBERWEIS INTER OPPORTUNITIES OPEN 0.0000 0.0000 13,020.00 275,000.00 0.00 0.00 275,000.00 286,310
680223104 16- OLD REP INTL CORP 06/11/15 OPEN 0.0000 0.0000 15.072200 3,600.00 58,370.00 0.00 0.00 58,370.00 69,768
680223104 16- OLD REP INTL CORP 06/11/15 OPEN 0.0000 0.0000 15.090700 2,700.00 40,776.00 0.00 0.00 40,776.00 52,326
680223104 OLD REP INTL CORP OPEN 0.0000 0.0000 2,500.00 42,672.00 0.00 0.00 42,672.00 48,450
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 108,885
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 274,109
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 203,584
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 212,883
695263103 PACWEST BANCORP OPEN 0.0000 0.0000 1,700.00 71,367.00 0.00 0.00 71,367.00 70,295
695263103 PACWEST BANCORP OPEN 0.0000 0.0000 2,500.00 101,140.00 0.00 0.00 101,140.00 103,375
704326107 13-0049 PAYCHEX 07/06/12 OPEN 0.0000 0.0000 31.450000 1,300.00 42,757.00 0.00 0.00 42,757.00 77,064
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 94,848
704326107 PAYCHEX OPEN 0.0000 0.0000 100.00 5,148.00 0.00 0.00 5,148.00 5,928
717081103 13-0051 PFIZER INC 07/06/12 OPEN 0.0000 0.0000 22.930000 1,600.00 42,119.00 0.00 0.00 42,119.00 59,024
717081103 13-0069 PFIZER INC 08/02/12 OPEN 0.0000 0.0000 23.710000 2,700.00 65,816.00 0.00 0.00 65,816.00 99,603
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 288,350
74160Q103 15-0162 PRIMECAP ODYSSEY GROWTH FUND 12/15/14 OPEN 0.0000 0.0000 26.549900 2,259.89 60,000.00 0.00 0.00 60,000.00 63,345
74160Q103 PRIMECAP ODYSSEY GROWTH FUND OPEN 0.0000 0.0000 817.00 20,467.00 0.00 0.00 20,467.00 22,901
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 313,291
74255L795 14-0245 PRINCIPAL MIDCAP 02/05/14 OPEN 0.0000 0.0000 19.450000 13,778.92 268,000.00 0.00 0.00 268,000.00 313,746
74255L795 15-0002 PRINCIPAL MIDCAP 05/19/14 OPEN 0.0000 0.0000 20.740003 7,232.40 150,000.00 0.00 0.00 150,000.00 164,682
74255L795 PRINCIPAL MIDCAP OPEN 0.0000 0.0000 4,558.48 95,303.00 0.00 0.00 95,303.00 103,797
742537863 PRINCIPAL SMALLCAP P OPEN 0.0000 0.0000 11,873.23 258,430.00 0.00 0.00 258,430.00 257,649
718546104 PHILLIPS 66 OPEN 0.0000 0.0000 3,100.00 262,612.00 0.00 0.00 262,612.00 235,786
756109104 11-0124 REALTY INCOME CORP 10/06/10 OPEN 0.0000 0.0000 33.646428 1,100.00 37,011.00 0.00 0.00 47,105.00 78,617
756109104 13-0011 REALTY INCOME CORP 05/04/12 OPEN 0.0000 0.0000 39.744100 1,300.00 51,639.00 0.00 0.00 67,565.00 92,911
761713106 11-0009 REYNOLDS AMERICAN INC 06/08/10 OPEN 0.0000 0.0000 53.039300 1,200.00 15,912.00 0.00 0.00 15,912.00 60,072
761713106 11-0018 REYNOLDS AMERICAN INC 06/08/10 OPEN 0.0000 0.0000 52.979742 1,800.00 23,841.00 0.00 0.00 23,841.00 90,108
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 70,538
780905741 RPM INTERNATIONAL INC OPEN 0.0000 0.0000 100.00 1,464.00 0.00 0.00 1,464.00 5,426
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 103,094
79466L302 SALESFORCE COM INC OPEN 0.0000 0.0000 2,900.00 223,287.00 0.00 0.00 223,287.00 237,220
79466L302 SALESFORCE COM INC OPEN 0.0000 0.0000 4,700.00 360,399.00 0.00 0.00 360,399.00 384,460
808513105 SCHWAB CHARLES CORP OPEN 0.0000 0.0000 8,000.00 230,787.00 0.00 0.00 230,787.00 227,360
808513105 SCHWAB CHARLES CORP OPEN 0.0000 0.0000 13,200.00 361,260.00 0.00 0.00 361,260.00 375,144
808513105 SCHWAB CHARLES CORP OPEN 0.0000 0.0000 1,600.00 36,167.00 0.00 0.00 36,167.00 45,472
81721M109 SENIOR HOUSING PROP TRUST OPEN 0.0000 0.0000 3,700.00 50,908.00 0.00 0.00 50,908.00 82,177
824348106 SHERWIN WILLIAMS CO OPEN 0.0000 0.0000 900.00 230,963.00 0.00 0.00 230,963.00 269,757
824348106 SHERWIN WILLIAMS CO OPEN 0.0000 0.0000 1,200.00 287,412.00 0.00 0.00 287,412.00 359,676
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 69,550
842587107 09-0093 SOUTHERN CO 08/29/08 OPEN 0.0000 0.0000 37.515200 1,800.00 67,527.00 0.00 0.00 67,527.00 96,300
844741108 15-0206 SOUTHWEST AIRLINES CO 12/16/14 OPEN 0.0000 0.0000 41.961100 4,900.00 200,262.00 0.00 0.00 200,262.00 181,349
844741108 SOUTHWEST AIRLINES CO OPEN 0.0000 0.0000 8,000.00 336,145.00 0.00 0.00 365,558.00 296,080
844741108 SOUTHWEST AIRLINES CO OPEN 0.0000 0.0000 1,600.00 63,599.00 0.00 0.00 63,599.00 59,216
78409V104 SP GLOBAL INC 07/21/16 OPEN 0.0000 0.0000 2,200.00 255,860.00 0.00 0.00 255,860.00 268,840
78409V104 SP GLOBAL INC 07/21/16 OPEN 0.0000 0.0000 3,500.00 374,290.00 0.00 0.00 374,290.00 427,700
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,522
85917K546 STERLING CAPITAL STRATTON SM CAP VAL OPEN 0.0000 0.0000 5,652.58 288,729.00 0.00 0.00 288,729.00 436,266
779552207 14-0160 T ROWE PRICE EXT EQ MKT IDX 11/04/13 OPEN 0.0000 0.0000 23.860000 16,200.44 385,778.00 0.00 0.00 385,778.00 402,419
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 131,803
779562107 15-0013 T ROWE PRICE NEW HORIZONS FUND 05/23/14 OPEN 0.0000 0.0000 44.149988 3,601.36 159,000.00 0.00 0.00 159,000.00 162,565
779562107 15-0233 T ROWE PRICE NEW HORIZONS FUND 02/02/15 OPEN 0.0000 0.0000 43.370000 3,919.76 170,000.00 0.00 0.00 170,000.00 176,938
779562107 T ROWE PRICE NEW HORIZONS FUND Page 6 of 7 OPEN 0.0000 0.0000 1,904.16 80,801.00 0.00 0.00 80,801.00 85,954
883556102 15-0039 THERMO FISHER SCIENTIFIC INC 07/11/14 OPEN 0.0000 0.0000 118.689700 2,400.00 284,855.00 0.00 0.00 284,855.00 381,216
887389104 TIMKEN CO OPEN 0.0000 0.0000 2,200.00 63,145.00 0.00 0.00 63,145.00 73,590
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
887389104 TIMKEN CO OPEN 0.0000 0.0000 3,200.00 94,716.00 0.00 0.00 94,716.00 107,040
892356106 TRACTOR SUPPLY CO 07/21/16 OPEN 0.0000 0.0000 2,700.00 251,048.00 0.00 0.00 251,048.00 247,455
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 189,060
893509224 TRANSAMERICA FDS OPEN 0.0000 0.0000 10,802.98 171,885.00 0.00 0.00 171,885.00 179,221
901165100 15-0257 TWEEDY BROWNE GLOBAL VALUE FUND 02/23/15 OPEN 0.0000 0.0000 26.660000 7,476.00 198,609.00 0.00 0.00 190,000.00 186,227
921937694 VANGUARD MIDCAP VALUE INDEX ADMIRAL 07/19/16 OPEN 0.0000 0.0000 6,294.59 300,000.00 0.00 0.00 300,000.00 302,644
921937694 VANGUARD MIDCAP VALUE INDEX ADMIRAL 07/19/16 OPEN 0.0000 0.0000 10,002.14 467,000.00 0.00 0.00 467,000.00 480,903
921937686 15-0051 VANGUARD SMALL CAP VALUE INDEX 07/17/14 OPEN 0.0000 0.0000 44.589986 9,469.00 425,000.00 0.00 0.00 500,000.00 448,452
921937686 VANGUARD SMALL CAP VALUE INDEX OPEN 0.0000 0.0000 15,469.00 690,387.00 0.00 0.00 690,387.00 732,612
92828N593 VIRTUS SMALL CAP SUSTAINABLE GROWTH OPEN 0.0000 0.0000 21,071.00 385,603.00 0.00 0.00 385,603.00 390,235
92828N593 VIRTUS SMALL CAP SUSTAINABLE GROWTH OPEN 0.0000 0.0000 10,887.32 200,000.00 0.00 0.00 200,000.00 201,633
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 65,385
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 108,975
931427108 WALGREENS BOOTS ALLIANCE INC OPEN 0.0000 0.0000 4,600.00 392,924.00 0.00 0.00 392,924.00 364,550
958102105 WESTERN DIGITAL CORP OPEN 0.0000 0.0000 1,300.00 51,375.00 0.00 0.00 51,375.00 61,763
958102105 WESTERN DIGITAL CORP OPEN 0.0000 0.0000 2,200.00 91,107.00 0.00 0.00 91,107.00 104,522
959319104 WESTERN REFINING INC OPEN 0.0000 0.0000 3,600.00 105,607.00 0.00 0.00 105,607.00 75,060
959319104 WESTERN REFINING INC OPEN 0.0000 0.0000 4,700.00 139,562.00 0.00 0.00 139,562.00 97,995
963320106 WHIRLPOOL CORP 07/12/16 OPEN 0.0000 0.0000 2,200.00 365,624.00 0.00 0.00 365,624.00 423,192
98956P102 ZIMMER BIOMET HOLDINGS INC 07/21/16 OPEN 0.0000 0.0000 2,000.00 249,705.00 0.00 0.00 249,705.00 262,280
5100 -FSC SECURITIES CORPORATION Total 0.0000 0.0000 0.000000 936,634.71 35,435,080.51 0.00 0.00 35,693,023.11 40,449,560.83
5100 - FSC SECURITIES CORPORATION Total 0.0000 0.0000 0.000000 936,634.71 35,435,080.51 0.00 0.00 35,693,023.11 40,449,560.83
Investment Total
47,779,260 83,260,695 (380,367) - 83,431,549 87,348,811
Page 7 of 7
Northbrook Economic Data
•Office, Industrial & Retail Vacancies
•Unemployment Rates
•Local Sales Tax Collections
•Hotel Market
•Equalized Assessed Valuations
•Housing Market
•Building Permits
November 2016
Northbrook Economic Data
November 2016
• Office, Industrial, & Retail Vacancy Rates
Central North &
Near North
Office Submarkets
Source: CoStar
Northbrook Office Vacancy Rate
Northbrook
Source: CoStar
South Lake County &
North Cook County
Industrial Submarkets
Source: CoStar
Northbrook Industrial/Flex Space Vacancy Rate
Northbrook
Source: CoStar
Overall Vacancy Rate for Northbrook Shopping Centers
16.0%
14.9%
14.0%
11.7%
11.5%
12.0%
10.0%
8.3% 8.7%
8.2%
7.9%
8.0%
6.7% 6.6% 6.6%
5.9%
6.0% 5.3%
4.8%
4.5%
4.3%
4.0%
2.0%
0.0%
2009-4Q 2010-2Q 2010-4Q 2011-2Q 2011-4Q 2012-2Q 2012-4Q 2013-2Q 2013-4Q 2014-2Q 2014-4Q 2015-2Q 2015-4Q 2016-2Q 2016-4Q
Source: Village of Northbrook Survey
Northbrook Economic Data
November 2016
• 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.0% 6.5% 6.5%
6.2%
5.1%
4.0% 4.3% 4.4%
4.0%
3.2%
2.9%
2.0%
0.0%
2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 Sep-16
Northbrook Unemployment Rate Cook County Unemployment Rate
Chicago Metro Area Unemployment Rate State of Illinois Unemployment Rate Source: IDES - LMI
Unemployment Rate by Area Municipalities
Not Seasonally Adjusted
Change Over Change Over
CITIES Sep-16 Aug-16 Sep-15 the Month the Year
WHEELING VILLAGE 3.8 3.8 3.5 0.0 0.3
WILMETTE VILLAGE 4.1 4.1 3.6 0.0 0.5
ARLINGTON HEIGHTS VILLAGE 4.2 4.2 3.8 0.0 0.4
GLENVIEW VILLAGE 4.2 4.1 3.8 0.1 0.4
MOUNT PROSPECT VILLAGE 4.2 4.2 3.8 0.0 0.4
DES PLAINES CITY 4.3 4.6 4.3 -0.3 0.0
ELMHURST CITY 4.3 4.3 4.1 0.0 0.2
HOFFMAN ESTATES VILLAGE 4.3 4.3 3.7 0.0 0.6
NAPERVILLE CITY 4.3 4.5 4.0 -0.2 0.3
BUFFALO GROVE VILLAGE 4.4 4.2 4.4 0.2 0.0
EVANSTON CITY 4.4 4.6 4.3 -0.2 0.1
NORTHBROOK VILLAGE 4.4 4.2 3.8 0.2 0.6
SCHAUMBURG VILLAGE 4.4 4.5 4.1 -0.1 0.3
HIGHLAND PARK CITY 4.5 4.1 4.2 0.4 0.3
MORTON GROVE VILLAGE 4.5 4.5 4.3 0.0 0.2
SKOKIE VILLAGE 4.5 4.5 4.2 0.0 0.3
NILES VILLAGE 4.8 4.9 4.6 -0.1 0.2
AURORA CITY 5.1 5.3 5.1 -0.2 0.0
CHICAGO CITY 5.9 6.1 5.8 -0.2 0.1
Source: IDES - LMI
Northbrook Economic Data
November 2016
• Local Sales Tax Collections
Village of Northbrook
Sales Tax by Calendar Month of Actual Retail Sale Through August
$1,800,000
$1,600,000
$1,400,000 $1,343,112
$1,311,912
$1,225,303
$1,178,323
$1,200,000
$1,112,953 $1,118,367
$1,018,147 $997,047
$1,000,000 2013
2014
2015
$800,000
2016
$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 2015 & 2016
$120,000
$106,758
$100,000
$80,000
$60,000
$40,000
$20,000 $13,291
$11,233 $10,150
$2,828
$-
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
$(20,000) $(15,388)
$(28,317)
$(40,000) Total Difference Between 2015 & 2016
Through August
$(60,000)
$(60,645) Increase of $39,910
$(80,000)
Difference Between '15 & '16
Source: Village of Northbrook
Village of Northbrook
% Sales Tax Change by Calendar Month of Actual Retail Sales
Difference Between 2015 & 2016
10.0%
8.9%
8.0%
6.0%
4.0%
2.0%
1.0% 0.9% 1.0%
0.3%
0.0%
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
-2.0% -1.5%
Total % Change Between 2015 & 2016
-2.3%
Through August
-4.0%
Increase of 0.4%
-5.1%
-6.0%
% Difference '15 & '16
Source: Village of Northbrook
Northbrook Economic Data
November 2016
• Hotel Market
Revenue Per Available Room (RevPar) Chicago's North Shore CVB
$120.00
$105.41
$100.00 $95.11
$94.58
$89.74
$83.78 $83.12
$80.00
Revenue Per Available Room
$63.90
2013
$60.18
$60.00 2014
2015
$49.07
2016
$40.00
$20.00
$-
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Source: STR
Hotel Revenue Per Available Room (RevPAR)
$120.00
$105.41
$103.34
$100.00 $95.48 $94.73 $94.58 $95.11
$91.65 $90.80 $89.74
$84.27 $83.78 $83.12
$80.57
$80.00
$71.81
$63.67 $63.90
$60.18
$57.40
$60.00
$47.96 $48.25 $49.07
$40.00
$20.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
2015 2016
Chicago North Shore CVB ChicagoNorth/Lake County(1) Metro Area, Excluding Chicago
Source: STR
Village of Northbrook
Hotel Tax Revenue by Calendar Quarter
$350,000
Difference Between 2015 & 2016
Through September
$300,000 Decrease of $31,137
$281,295 $281,347
A 4% Decrease
$250,000
$222,878
$214,784
$200,000 $192,757 2012
2013
$169,718
2014
$150,000 2015
$136,729
2016
$100,000
$50,000
$-
Jan-Mar Apr-Jun Jul-Sep Oct-Dec
Note: # of rooms – Sheraton -161; Renaissance – 385; Sheraton opened Fall 2008 Source: Village of Northbrook
Northbrook Economic Data
November 2016
• Equalized Assessed Values
Village of Northbrook
Equalized Assessed Valuations (EAV) in Dollars by Tax Year
$3,500,000,000
$3,131,130,125
$3,000,000,000
$2,500,000,000
$2,139,565,115 $2,183,436,228
$2,075,277,265
$2,000,000,000
$1,426,205,616 $1,389,618,945
$1,500,000,000
$1,000,000,000
$628,565,693
$578,433,197
$492,412,415
$500,000,000 $362,682,781
$178,797,415 $193,245,905
$-
2009 2010 2011 2012 2013 2014 2015
Residential Commercial Industrial Total
Source: Cook County Clerk
Percentage Change in EAV from Previous Tax Year
30%
20%
10% 8%
2009
0% 2010
Residential Commercial Industrial Total 2011
-3% 2012
-5%
2013
-10% 2014
2015
-15%
-20%
-30%
-40%
Source: Cook County Clerk
Village of Northbrook
Equalized Assessed Valuation (EAV) Percentage by Tax Year
100%
12% 9%
90%
80%
20% 24%
70%
60%
Industrial
50%
Commercial
Residential
40%
68% 67%
30%
20%
10%
0%
2009 2010 2011 2012 2013 2014 2015
Source: Cook County Clerk
Northbrook Economic Data
November 2016
• Housing Market
Single Family Detached Homes - Average Sales Price First 6 Months
$1,400,000
$1,267,074
$1,200,000
$1,000,000
$800,000 $778,633
2012
2013
2014
$589,512 $623,161 $621,000
$600,000 $538,008 2015
2016
$387,956
$400,000
$228,930
$200,000
$-
Deerfield Glencoe Glenview Highhland Park Northbrook Northfield Prospect Heights Wheeling
Source: North Shore - Barrington Association of REALTORS
Single Family Detached Homes - Average Sales Price First 6 Months
Percentage Change From Previous Year
35%
30%
25%
20%
15%
13%
12% 2013
10%
10% 2014
7% 2015
5% 2016
5%
3%
1% 1%
0%
-1%
-5%
-10% -9%
-12%
-15%
Deerfield Glencoe Glenview Highhland Park Northbrook Northfield Prospect Heights Wheeling
Source: North Shore - Barrington Association of REALTORS
Northbrook Economic Data
November 2016
• Building Permits
Northbrook Economic Data
Prepared by the Village of Northbrook
Department of Development & Planning Services
November 2016
DRAFT CAPITAL
IMPROVEMENT PLAN
FISCAL YEARS
2 017 / 2 01 8 – 2 0 21 / 2 0 2 2
WHAT IS THE CIP?
• A long-range planning document designed to anticipate and plan for the
Village’s capital needs
• Helps ensure that the Village’s infrastructure can meet the service
demands of the public and operational needs of the Village
• Updated every year to allow the Village to balance a long-term
perspective with the flexibility to change plans as new needs and
technologies arise.
THE VILLAGE’S FINANCIAL CYCLE
Financial Planning
Capital Improvement Plan (CIP) Annual Budget
This five-year plan overviews the The annual budget is the key financial
Village’s upcoming capital needs and policy document of the Village. It
their anticipated costs so that the combines information from the CIP,
Village may make strategic decisions. operating Departments and other
This plan is used during the annual sources and plans for the revenues the
budget process but does not approve Village anticipates bringing in as well as
expenditures. its actual expenditures.
Comprehensive Annual Monthly & Quarterly Reporting
Financial Report
These documents summarize the
Village’s financial performance and
This document (often called the CAFR)
allow for comparisons between budget
reviews the fiscal activities and
estimates and past financial periods.
performance of an entire year &
These help the Village make “course
summarizes the Village’s standing.
corrections” if necessary.
Financial Reporting
NOTEWORTHY POINTS
• Water Plan: The previously completed Water Plan forms the basis
for the scheduling of projects in the Water Fund.
• Facility Study: With the Ad Hoc Facilities Committee beginning
work on the facility study, most projects were removed from the
CIP and will be incorporated into future CIPs based on the
Committee’s work.
FISCAL YEAR 2016-2017
RECAP
FISCAL YEAR 2016/2017 RECAP: GENERAL FUND
• Starcom21 Radio Upgrades
• Fire Station 11 Windows
• Fleet Garage
• Police Department Roof/HVAC
• Village Hall Emergency Generators
• Unit 57 (Fire Engine) and 65 (Ambulance) Replacement
• Vehicle Replacements
• IT Equipment Replacement
FISCAL YEAR 2016/2017 RECAP: INFRASTRUCTURE
• Asphalt Street Rehabilitation (area bounded by
Sanders, Walters and Terri-Lyn)
• Central Business District (Engineering)
• Concrete Street Rehabilitation (Heather Crest West,
Arrowhead and White Plains Subdivisions)
• Skokie Valley Trail (Phase I Engineering)
FISCAL YEAR 2016/2017 RECAP: STORMWATER
Northbrook East (Construction)
Shermer Road Overflow (Construction)
Wescott Park (Construction)
Keystone/Chartres (Engineering)
FISCAL YEAR 2016/2017 RECAP: WATER/SEWER
Water Fund:
Water Main Replacement (Harris and Banyan)
Two Zone Water Pressure Implementation (Engineering)
Critical Valve Installation (Skokie Boulevard)
Scheduled Vehicle Replacements
Sanitary Sewer Fund:
Sanitary Sewer Lining (area bounded by Dundee, Waukegan, Grant and
Voltz)
FISCAL YEARS
2017 – 2022
DRAFT CAPITAL
IMPROVEMENT PLAN
CIP SUMMARY: ALL FUNDS
General Fund
13%
3% 19%
Infrastructure
Capital Improvement
Fund
Water Fund
36% 29%
Sanitary Sewer Fund
Stormwater Fund
CIP Summary, All Funds, Fiscal Years 2018 – 2022
Total Capital Expenses: $59,571,877
FY16/17 FY17/18 FY18/19 FY19/20 FY20/21 FY21/22 FY22/23 FY23/24 FY24/25 FY25/26 FY26/27 FY27/28 FY34/35 FY35/36 FY36/37
DEBT SERVICE FUND Total (Note 1)
2007 Corporate Purpose Bonds
Principal 334,800 334,800
Interest 14,229 14,229
Subtotal 349,029 - - - - - - - - - - - 349,029
2008 Corporate Purpose Bonds
Principal 705,000 705,000
Interest 29,962 29,962
Subtotal 734,962 - - - - - - - - - - - 734,962
2010 Corporate Purpose Bonds
Principal 516,590 53,020 54,455 57,320 58,755 60,185 61,620 64,485 65,920 67,350 70,215 73,085 1,357,765
Interest 43,409 27,914 26,324 24,689 22,969 21,494 19,399 17,554 15,537 13,393 11,205 8,750 261,982
Subtotal 559,999 80,934 80,779 82,009 81,724 81,679 81,019 82,039 81,457 80,743 81,420 81,835 1,619,747
2011 Corporate Purpose Bonds
Principal 125,000 125,000 130,000 130,000 135,000 140,000 140,000 145,000 150,000 155,000 160,000 170,000 2,645,000
Interest 86,960 83,210 79,460 75,560 71,660 67,610 63,410 59,210 54,860 50,285 45,325 40,045 884,347
Subtotal 211,960 208,210 209,460 205,560 206,660 207,610 203,410 204,210 204,860 205,285 205,325 210,045 3,529,347
2012 Corporate Purpose Bonds
Principal 796,821 1,277,174 1,962,582 1,990,397 2,528,954 2,577,182 66,720 69,500 69,500 72,280 72,280 75,060 11,558,450
Interest 130,456 140,668 139,972 113,359 104,679 59,606 8,505 7,175 5,785 4,395 2,945 1,500 719,045
Subtotal 927,277 1,417,842 2,102,554 2,103,756 2,633,633 2,636,788 75,225 76,675 75,285 76,675 75,225 76,560 12,277,495
2013 Corporate Purpose Bonds
Principal 39,454 40,748 42,042 43,335 44,629 45,922 47,216 48,509 49,803 51,743 53,037 54,977 73,088 76,322 80,202 1,171,988
Interest 44,241 43,058 41,835 40,574 39,274 37,935 36,558 35,141 33,686 32,129 30,383 28,527 10,333 7,044 3,609 585,207
Subtotal 83,695 83,806 83,877 83,909 83,903 83,857 83,774 83,650 83,489 83,872 83,420 83,504 83,421 83,366 83,811 1,757,195
2014 Corporate Purpose Bonds
Principal 248,500 1,144,500 1,197,000 1,242,500 1,309,000 1,375,500 1,435,000 1,508,500 1,585,500 1,673,000 1,739,500 1,816,500 17,493,000
Interest 749,140 741,685 684,460 636,580 574,455 509,005 453,985 382,235 306,810 227,535 160,615 91,035 5,554,080
Subtotal 997,640 1,886,185 1,881,460 1,879,080 1,883,455 1,884,505 1,888,985 1,890,735 1,892,310 1,900,535 1,900,115 1,907,535 23,047,080
2015A Corporate Purpose Bonds
Principal 350,000 355,000 360,000 365,000 1,035,000 1,070,000 1,105,000 1,145,000 1,405,000 14,955,000
Interest 491,120 488,320 484,060 484,060 484,060 484,060 484,060 475,420 466,113 438,168 407,673 374,523 54,795 6,990,392
Subtotal 841,120 843,320 484,060 484,060 484,060 484,060 844,060 840,420 1,501,113 1,508,168 1,512,673 1,519,523 1,459,795 21,945,392
2015B Corporate Purpose Bonds
Principal 185,225 191,200 197,175 204,345 210,320 217,490 272,460 280,825 3,219,330
Interest 109,576 109,576 109,576 109,576 109,576 109,576 109,576 104,019 96,371 88,484 80,310 71,897 19,024 9,829 1,520,921
Subtotal 109,576 109,576 109,576 109,576 109,576 109,576 294,801 295,219 293,546 292,829 290,630 289,387 291,484 290,654 4,740,251
2016A Corporate Purpose Bonds
Principal 227,200 232,000 236,800 302,400 308,800 454,400 467,200 246,400 251,200 264,000 272,000 384,000 395,200 419,200 6,520,000
Interest 111,882 188,212 183,668 179,028 174,292 168,244 162,068 148,436 134,420 127,028 119,492 111,572 40,704 28,224 14,392 2,364,486
Subtotal 111,882 415,412 415,668 415,828 476,692 477,044 616,468 615,636 380,820 378,228 383,492 383,572 424,704 423,424 433,592 8,884,486
Total - CURRENT
Principal 3,116,165 3,222,642 3,618,079 3,700,352 4,378,738 4,507,589 2,750,181 2,859,394 3,399,298 3,544,918 3,674,352 3,824,112 2,134,548 752,347 499,402 59,960,333
Interest 1,810,974 1,822,643 1,749,355 1,663,426 1,580,965 1,457,530 1,337,561 1,229,190 1,113,582 981,417 857,948 727,849 124,856 45,097 18,001 18,924,651
Total Debt Service Fund 4,927,139 5,045,285 5,367,434 5,363,778 5,959,703 5,965,119 4,087,742 4,088,584 4,512,880 4,526,335 4,532,300 4,551,961 2,259,404 797,444 517,403 78,884,984
Paid From 1/4% HR Sales Tax 2,153,921 1,830,329 1,827,516 1,821,569 1,826,431 1,828,284 1,827,937 1,830,242 1,832,247 1,839,745 1,839,424 1,850,525 - - - 24,433,826
Total Net Debt Service 2,773,218 3,214,956 3,539,918 3,542,209 4,133,272 4,136,835 2,259,805 2,258,342 2,680,633 2,686,590 2,692,876 2,701,436 2,259,404 797,444 517,403 54,451,158
FY 2017-2022 Corporate
Purposes Bonds 193,396 589,580 728,598 831,153 954,890
Projected Net Annual Debt
Service 2017 - 2022 3,408,352 4,129,498 4,270,807 4,964,425 5,091,725
WATER FUND FY16/17 FY17/18 FY18/19 FY19/20 FY20/21 FY21/22 FY22/23 FY23/24 FY24/25 FY25/26 FY26/27 FY27/28 FY34/35 FY35/36 FY36/37
2007 Corporate Purpose Bonds
Principal 285,200 285,200
Interest 12,121 12,121
Subtotal 297,321 - - - - - - - - - - - 297,321
2010 Corporate Purpose Bonds
Principal 128,410 131,980 135,545 142,680 146,245 149,815 153,380 160,515 164,080 167,650 174,785 181,915 2,222,235
Interest 73,335 69,480 65,520 61,455 57,175 53,500 48,295 43,690 38,675 33,345 27,895 21,775 617,395
Subtotal 201,745 201,460 201,065 204,135 203,420 203,315 201,675 204,205 202,755 200,995 202,680 203,690 2,839,630
2012 Corporate Purpose Bonds
Principal 532,749 562,917 574,282 584,573 80,040 78,460 2,413,021
Interest 90,295 64,768 43,034 35,295 3,523 2,012 238,927
Subtotal 623,044 627,685 617,316 619,868 83,563 80,472 2,651,948
2013 Corporate Purpose Bonds
Principal 41,180 42,530 43,880 45,230 46,580 47,931 49,281 50,631 51,981 54,007 55,357 57,382 76,284 79,660 83,710 1,223,248
Interest 46,176 44,941 43,665 42,349 40,992 39,594 38,156 36,678 35,159 33,535 31,712 29,774 10,784 7,352 3,767 610,802
Subtotal 87,356 87,471 87,545 87,579 87,572 87,525 87,437 87,309 87,140 87,542 87,069 87,156 87,068 87,012 87,477 1,834,050
2014 Corporate Purpose Bonds
Principal 63,900 294,300 307,800 319,500 336,600 353,700 369,000 387,900 407,700 430,200 447,300 467,100 4,498,200
Interest 192,636 190,719 176,004 163,692 147,717 130,887 116,739 98,289 78,894 58,509 41,301 23,409 1,428,192
Subtotal 256,536 485,019 483,804 483,192 484,317 484,587 485,739 486,189 486,594 488,709 488,601 490,509 5,926,392
2015B Corporate Purpose Bonds
Principal 363,475 375,200 386,925 400,995 412,720 426,790 534,660 551,075 6,317,430
Interest 215,025 215,025 215,025 215,025 215,025 215,025 215,025 204,121 189,113 173,636 157,596 141,087 37,332 19,288 2,984,569
Subtotal 215,025 215,025 215,025 215,025 215,025 215,025 578,500 579,321 576,038 574,631 570,316 567,877 571,992 570,363 9,301,999
2016A Corporate Purpose Bonds
Principal 43,807 44,733 45,658 58,307 59,541 87,614 90,082 47,509 48,435 50,903 52,445 74,040 76,200 78,690 1,255,000
Interest 21,572 36,290 35,413 34,519 33,606 32,440 31,249 28,620 25,918 24,493 23,040 21,512 7,848 5,442 2,775 455,902
Subtotal 21,572 80,097 80,146 80,177 91,912 91,980 118,863 118,702 73,427 72,927 73,942 73,957 81,888 81,641 81,464 1,710,902
Total
Principal 1,051,439 1,075,534 1,106,240 1,137,641 667,772 689,447 1,022,750 1,064,328 1,058,195 1,101,287 1,141,065 1,185,632 684,984 706,935 162,400 18,214,334
Interest 651,160 621,222 578,661 552,335 498,037 473,457 449,464 411,398 367,758 323,517 281,543 237,557 55,965 32,082 6,542 6,347,909
Total Water Fund 1,702,599 1,696,756 1,684,901 1,689,976 1,165,809 1,162,904 1,472,214 1,475,726 1,425,953 1,424,804 1,422,608 1,423,189 740,949 739,016 168,941 24,562,243
FY 2017-2022 Corporate
Purposes Bonds 245,059 562,080 823,731 1,031,952 1,211,806
Projected Net Annual Debt
Service 2017 - 2022 1,941,815 2,246,981 2,513,707 2,197,761 2,374,710
FY16/17 FY17/18 FY18/19 FY19/20 FY20/21 FY21/22 FY22/23 FY23/24 FY24/25 FY25/26 FY26/27 FY27/28 FY34/35 FY35/36 FY36/37
SANITARY SEWER FUND
2013 Corporate Purpose Bonds
Principal 19,610 20,252 20,895 21,538 22,181 22,824 23,467 24,110 24,753 25,717 26,360 27,325 36,326 37,933 39,862 582,498
Interest 21,989 21,400 20,793 20,166 19,520 18,854 18,170 17,466 16,742 15,969 15,101 14,178 5,135 3,501 1,795 290,857
Subtotal 41,599 41,652 41,688 41,704 41,701 41,678 41,637 41,576 41,495 41,686 41,461 41,503 41,461 41,434 41,657 873,355
2014 Corporate Purpose Bonds
Principal 28,400 130,800 136,800 142,000 149,600 157,200 164,000 172,400 181,200 191,200 198,800 207,600 1,999,200
Interest 85,616 84,764 78,224 72,752 65,652 58,172 51,884 43,684 35,064 26,004 18,356 10,404 634,752
Subtotal 114,016 215,564 215,024 214,752 215,252 215,372 215,884 216,084 216,264 217,204 217,156 218,004 2,633,952
2015B Corporate Purpose Bonds
Principal 51,925 53,600 55,275 57,285 58,960 60,970 76,380 78,725 902,490
Interest 30,718 30,718 30,718 30,718 30,718 30,718 30,718 29,160 27,016 24,805 22,514 20,155 5,333 2,755 426,367
Subtotal 30,718 30,718 30,718 30,718 30,718 30,718 82,643 82,760 82,291 82,090 81,474 81,125 81,713 81,480 1,328,857
2016A Corporate Purpose Bonds
Principal 6,816 6,960 7,104 9,072 9,264 13,632 14,016 7,392 7,536 7,920 8,160 11,520 11,856 11,976 195,000
Interest 3,356 5,646 5,510 5,371 5,229 5,047 4,862 4,453 4,033 3,811 3,585 3,347 1,221 847 432 70,935
Subtotal 3,356 12,462 12,470 12,475 14,301 14,311 18,494 18,469 11,425 11,347 11,505 11,507 12,741 12,703 12,408 265,935
Total
Principal 48,010 157,868 164,655 170,642 180,853 189,288 253,024 264,126 268,620 281,738 292,040 304,055 124,226 128,514 51,838 3,679,188
Interest 141,679 142,528 135,245 129,007 121,119 112,791 105,634 94,763 82,855 70,589 59,555 48,084 11,689 7,103 2,227 1,422,911
Total Sanitary Sewer Fund 189,689 300,396 299,900 299,649 301,972 302,079 358,658 358,889 351,475 352,327 351,595 352,139 135,915 135,617 54,065 5,102,099
FY 2017-2022 Corporate
Purposes Bonds 53,265 66,539 80,130 94,442 109,079
Projected Net Annual Debt
Service 2017 - 2022 353,661 366,439 379,779 396,414 411,158
STORM WATER FUND
2012 Corporate Purpose Bonds
Principal 48,840 48,840 51,060 51,060 51,060 53,280 53,280 55,500 55,500 57,720 57,720 59,940 643,800
Interest 12,875 11,900 10,920 9,900 8,880 7,860 6,795 5,725 4,615 3,505 2,355 1,200 86,530
Subtotal 61,715 60,740 61,980 60,960 59,940 61,140 60,075 61,225 60,115 61,225 60,075 61,140 730,330
2013 Corporate Purpose Bonds
Principal 31,539 32,573 33,607 34,641 35,675 36,709 37,743 38,777 39,811 41,362 42,396 43,947 58,424 61,009 64,111 936,853
Interest 35,365 34,419 33,442 32,434 31,395 30,324 29,225 28,091 26,927 25,683 24,287 22,803 8,260 5,630 2,885 467,797
Subtotal 66,904 66,992 67,049 67,075 67,070 67,033 66,968 66,868 66,738 67,045 66,683 66,750 66,684 66,639 66,996 1,404,650
2014 Corporate Purpose Bonds
Principal 14,200 65,400 68,400 71,000 74,800 78,600 82,000 86,200 90,600 95,600 99,400 103,800 999,600
Interest 42,808 42,382 39,112 36,376 32,826 29,086 25,942 21,842 17,532 13,002 9,178 5,202 317,376
Subtotal 57,008 107,782 107,512 107,376 107,626 107,686 107,942 108,042 108,132 108,602 108,578 109,002 1,316,976
2015B Corporate Purpose Bonds
Principal 174,375 180,000 185,625 192,375 198,000 204,750 256,500 264,375 3,030,750
Interest 103,157 103,157 103,157 103,157 103,157 103,157 103,157 97,926 90,726 83,301 75,606 67,686 17,910 9,253 1,431,830
Subtotal 103,157 103,157 103,157 103,157 103,157 103,157 277,532 277,926 276,351 275,676 273,606 272,436 274,410 273,628 4,462,580
2016A Corporate Purpose Bonds
Principal 432,177 441,308 450,438 575,222 587,396 864,354 888,702 468,699 477,830 502,178 517,395 730,440 751,745 775,135 12,380,000
Interest 212,820 358,015 349,371 340,545 331,536 320,032 308,284 282,353 255,692 241,631 227,296 212,231 77,427 53,687 27,376 4,497,695
Subtotal 212,820 790,192 790,678 790,983 906,758 907,427 1,172,638 1,171,055 724,391 719,461 729,474 729,626 807,867 805,432 802,511 16,877,695
Total
Principal 94,579 578,990 594,375 607,139 736,757 755,985 1,211,752 1,249,179 840,235 864,887 899,694 929,832 1,045,364 1,077,129 839,246 17,991,003
Interest 407,025 549,872 536,002 522,412 507,794 490,459 473,403 435,937 395,492 367,122 338,722 309,121 103,597 68,570 30,261 6,801,228
Total Storm Wate r Fund 501,604 1,128,862 1,130,376 1,129,551 1,244,550 1,246,443 1,685,155 1,685,116 1,235,727 1,232,008 1,238,415 1,238,953 1,148,961 1,145,699 869,507 24,792,231
FY 2017-2022 Corporate
Purposes Bonds 189,337 247,559 359,395 384,012 468,587
Projected Net Annual Debt
Service 2017 - 2022 1,318,199 1,377,935 1,488,946 1,628,562 1,715,030
FY16/17 FY17/18 FY18/19 FY19/20 FY20/21 FY21/22 FY22/23 FY23/24 FY24/25 FY25/26 FY26/27 FY27/28 FY34/35 FY35/36 FY36/37
MOTOR FUEL TAX
2013 Corporate Purpose Bonds 173,217 178,897 184,576 190,255 195,935 201,614 207,293 212,972 218,652 227,170 232,850 241,369 320,878 335,076 352,114 5,145,411
Principal 194,234 189,038 183,671 178,134 172,426 166,548 160,499 154,281 147,892 141,059 133,392 125,242 45,363 30,924 15,845 2,569,246
Interest 367,451 367,935 368,247 368,389 368,361 368,162 367,792 367,253 366,544 368,229 366,242 366,611 366,241 366,000 367,959 7,714,657
Sub-total 367,451 367,935 368,247 368,389 368,361 368,162 367,792 367,253 366,544 368,229 366,242 366,611 366,241 366,000 367,959 7,714,657
TOTAL ALL FUNDS
TOTAL PRINCIPAL 4,483,410 5,213,931 5,667,924 5,806,029 6,160,054 6,343,922 5,445,000 5,649,999 5,785,000 6,019,999 6,240,000 6,485,000 4,310,000 3,000,000 1,904,999 104,990,269
TOTAL INTEREST 3,205,072 3,325,304 3,182,934 3,045,313 2,880,341 2,700,785 2,526,560 2,325,569 2,107,579 1,883,704 1,671,161 1,447,855 341,470 183,776 72,876 36,065,944
TOTAL PRINCIPAL AND
INTEREST 7,688,482 8,539,235 8,850,858 8,851,342 9,040,395 9,044,707 7,971,560 7,975,568 7,892,579 7,903,703 7,911,161 7,932,855 4,651,470 3,183,776 1,977,875 141,056,213
SUMMARY FOR FISCAL YEAR 2017/2018
Infrastructure Capital Sanitary Sewer
General Fund Improvement Fund Water Fund Fund Stormwater Fund Total
Capital Expense $2,371,990 $8,001,494 $5,529,723 $740,000 $3,084,050 $19,727,257
Planned Financing
Bond Proceeds $870,140 $2,209,500 $3,991,723 $740,000 $3,084,050 $10,895,413
Designated
Revenue $ - $5,173,000 $1,538,000 $ - $ - $6,711,000
Undesignated
Revenue $1,501,850 $618,994 $ - $ - $ - $2,120,844
Total $2,371,990 $8,001,494 $5,529,723 $740,000 $3,084,050 $19,727,257
Fund Total as a
Percentage of the
FY Total 12% 40% 28% 4% 16% 100%
FY 17/18 GENERAL FUND: $2,371,990
HIGHLIGHTED PROJECTS
Facility Improvements:
• Village Hall Generator Improvements: $250,000
• Security Camera Replacements/Installations: $81,000
• Public Works Trench Drain Replacement: $115,000
IT Improvements:
• Wired/Wireless Network Replacement: $150,000
• Telephone and Voicemail System: $72,500
FY 17/18 GENERAL FUND (CONT.)
Other Projects:
• Master Bike Plan: $150,000
Vehicle Replacements:
• Unit 55 (1996 Fire Squad): $328,000
• Units 226 & 227 (2003 International Dump Trucks): $292,140
• Scheduled Vehicle Replacements: $377,100
FY17/18 INFRASTRUCTURE FUND: $8,001,494
• Asphalt Streets:
• Illinois Road/Maple Avenue/Oak Avenue: $897,884
• Lee Road Asphalt Conversion: $1,100,000
• Central Business District Improvements and Streetscape Expansion:
$4,660,000
• Concrete Streets (Lone Tree Subdivision): $971,000
• Other Projects:
• Skokie Valley Trail (Phase II Engineering): $178,500
• Sidewalk Improvements: $119,110
• Traffic Signal Improvements: $75,000
FY 17/18 INFRASTRUCTURE: ASPHALT STREETS
FY 2017/2018 Asphalt Street Reconstruction & Rehabilitation
Last Square Yards of
Resurfaced Pavement
Street Section Rating Cost
Greenacre Drive Oak
Entire Avenue2 – Many Failures
Segment N/A Illinois Road
5,112 $151,853
Noble Court Entire Segment 2 – Many Failures N/A 950 $18,810
Kingsport Court Entire Segment 2 - Many Failures N/A 1,760 $43,433
Maple Avenue Oak Avenue - 3 – Limited N/A 3,634 $101,720
Eastern Failures
Terminus
Oak Avenue Royal Drive – 2 – Many Failures 1999 9,962 $262,760
Penfold Alley
Royal Drive Oak Avenue - 2 – Many Failures 1999 1,338 $38,218
Illinois Road Maple Avenue
Illinois Road Royal Drive – 2 – Many Failures 1999 9,992 $281,090
Penfold Place
Totals 32,748 $897,884
CENTRAL BUSINESS DISTRICT: $4,660,000
This project includes the following
elements:
• Road rehabilitation (both asphalt
and concrete)
• Sidewalk and streetscape
rehabilitation
• Streetscape improvements
• Traffic Signal Replacement
(Church and Shermer)
• Reconfiguration of Shermer
between Church and Waukegan
• The Shermer Bridge replacement
C0NCRETE STREETS (LONE TREE SUBDIVISION):
$971,000
This project includes complete street
reconstruction on the following
roads:
• Banyan
• Bayberry
• Sorrel
• Tamarind
• Laburnum (patching only)
All work shall be done concurrently
with water main replacements on
these streets.
FY 17/18 STORMWATER FUND: $3,084,050
• Dundee Road and Skokie (Construction): $269,650
• Keystone Road/Chartres Drive (Construction):
$603,250
• Northbrook Manor (Construction): $732,150
• Sunset Lane (Construction): $1,412,000
• Woodlawn Road (Property/Easement Acquisition and
Design/Final Engineering): $45,000
• Dehne Road and Glendale Avenue (Design/Final
Engineering): $22,000
DUNDEE AND SKOKIE: $269,650
This project includes installing new or replacing current inlets to help drain water at
the intersection of Dundee and Skokie. Additional work will be done to improve
conveyance and outlet conditions.
KEYSTONE/CHARTRES: $603,250
This project includes constructing a 24-inch storm relief sewer from Keystone Road
and Chartres Drive to West Park. A 6-acre foot expansion of the existing detention
basis will also be added at the Park.
FY17/18 WATER FUND: $5,529,732
• Water Main Replacement: $2,456,473
• Dundee and Lee Critical Main Replacement: $1,416,250
• Two Zone Construction: $1,427,000
• Other Projects: $230,000
FY17/18 SANITARY SEWER FUND: $740,000
• Dundee and Lee Critical Main Replacement: $275,000
• Sanitary Sewer Lining: $205,000
• Unit 305 Replacement (Sewer Flusher): $260,000
WATER MAIN REPLACEMENT: $2,456,473
This project includes replacing the
mains located along Illinois and Oak
in conjunction with the asphalt
resurfacing occurring on these
streets.
DUNDEE AND LEE CRITICAL MAIN REPLACEMENT
This project includes the
replacement of critical water and
sanitary sewer mains at the
intersection of Dundee and Lee as
part of an IDOT project to replace the
existing box culvert at this location.
IDOT will oversee this project.
Water Main Cost: $1,416,250
Sanitary Sewer Main Cost: $275,000
TWO ZONE CONSTRUCTION: $1,427,000
Engineering began in FY 2016/2017 for construction in FY 2017/2018.
SUMMARY FOR FISCAL YEAR 2018/2019
Infrastructure Capital Sanitary Sewer Stormwater
General Fund Improvement Fund Water Fund Fund Fund Total
Capital Expense $3,134,945 $4,573,575 $5,771,757 $265,000 $1,121,000 $14,866,277
Planned Financing
Bond Proceeds $1,900,000 $3,730,550 $4,626,977 $210,000 $921,000 $11,388,527
Designated Revenue $ - $481,400 $1,144,780 $55,000 $200,000 $1,881,180
Undesignated Revenue $1,234,945 $361,625 $ - $ - $ - $1,596,570
Total $3,134,945 $4,573,575 $5,771,757 $265,000 $1,121,000 $14,866,277
Fund Total As a
Percentage of the
FY Total 21% 31% 39% 2% 7% 100%
FY 18/19 – SIGNIFICANT PROJECTS
• Infrastructure Projects:
• Western Avenue – Road Reconstruction and Water Main
Replacement: $3,805,167
• Skokie Valley Trail Construction: $2,000,000
• Stormwater Projects:
• Woodlawn Road (Construction): $244,000
• Water Projects:
• Water Main Replacement: $2,530,167
• Water Plant Hypochlorite Conversion: $780,000
• General Fund:
• Unit 62 (Fire Ladder Truck): $1,350,000
WESTERN AVENUE (RECONSTRUCTION AND WATER
MAIN REPLACEMENT): $3,805,167 (TOTAL COST)
• Project Highlights:
• Complete reconstruction
of Western Avenue
between Oak and Techny,
including conversion to
asphalt surface.
• Simultaneous
replacement of 2,800
feet of original water
main and extension of the
main to Maple to loop the
mains in the area.
SKOKIE VALLEY TRAIL (CONSTRUCTION):
$2,000,000
This project includes a trail
extension between Lake-Cook
and Dundee Roads and review
of the section between Dundee
and Voltz as well as a future
section of trail south of Voltz.
The Village will submit a joint
grant application with the Lake
and Cook County Departments
of Transportation for
construction.
WOODLAWN ROAD (CONSTRUCTION): $244,000
This project involves adding new inlet structures and replacement of
existing culverts. 15 properties will experience a reduction in flooding.
WATER MAIN REPLACEMENTS: $2,530,167
This project includes replacement of the water main in the White Plains
South Subdivision as well as Dauphine, Normandy and Bordeaux.
SUMMARY FOR FISCAL YEAR 2019/2020
Infrastructure Capital Sanitary Sewer Stormwater
General Fund Improvement Fund Water Fund Fund Fund Total
Capital Expense $2,168,794 $1,549,889 $4,143,217 $309,780 $1,658,690 $9,830,370
Planned Financing
Bond Proceeds $1,268,820 $541,500 $4,068,217 $215,000 $1,658,690 $7,752,227
Designated
Revenue $ - $489,884 $75,000 $94,780 $ - $659,664
Undesignated
Revenue $899,974 $518,505 $ - $ - $ - $1,418,479
Total $2,168,794 $1,549,889 $4,143,217 $309,780 $1,658,690 $9,830,370
Fund Total As a
Percentage of the
FY Total 22% 16% 42% 3% 17% 100%
FY 19/20 – SIGNIFICANT PROJECTS
• Combined Asphalt Rehabilitation/Water Main Replacement
in Willow Creek Subdivision: $3,409,446 (Total Cost)
• Dundee at Railroad Tracks Critical Main Replacement:
$956,685
• Water Plant Roof Replacement (Phase 1): $355,000
• Brittany and Blackthorn Stormwater Projects (Construction):
$444,000 (Total Cost)
• Wendy Road Stormwater Project (Property/Easement
Acquisition and Design/Final Engineering): $544,000
• Unit 59 (Fire Engine) Replacement: $829,00
LONGMEADOW/KINGSTON STREET/WATER MAIN
PROJECT: $3,409,446
Project Highlights:
• Includes complete
resurfacing of the area
bounded by Pfingsten,
Longmeadow, Kingston
and Elm Ridge. Total Cost:
$803,374
• Includes replacement of
original water main in
same area. Total Cost:
$2,606,072
• Prolongs street life by
minimizing need for
puncturing street surface
CRITICAL WATER MAIN REPLACEMENT DUNDEE AT
RAILROAD: $956,685
This critical main is located under the railroad and West Fork of the North Branch of
the Chicago River and could impair the Village’s ability to supply water to the western
portion of the Village and pose a traffic problem if it failed. This project includes the
installation of a new, larger main.
SUMMARY FOR FISCAL YEAR 2020/2021
Infrastructure Capital Sanitary Sewer Stormwater
General Fund Improvement Fund Water Fund Fund Fund Total
Capital Expense $1,323,824 $1,745,179 $3,211,144 $335,810 $387,000 $7,002,957
Planned Financing
Bond Proceeds $514,010 $723,335 $3,136,144 $220,000 $387,000 $4,980,489
Designated Revenue $ - $498,453 $75,000 $115,810 $ - $689,263
Undesignated
Revenue $809,814 $523,391 $ - $ - $ - $1,333,205
Total $1,323,824 $1,745,179 $3,211,144 $335,810 $387,000 $7,002,957
Fund Total As a
Percentage of the
FY Total 19% 25% 46% 5% 5% 100%
FY 20/21 – SIGNIFICANT PROJECTS
• Asphalt and Concrete Street Reconstruction and
Rehabilitation (Sky Harbor): $1,534,464 (Total Cost)
• Water Main Replacement: $2,684,254
• Wendy Drive Stormwater Project (Construction): $221,000
• First Street/Center Avenue Stormwater Project
(Property/Easement Acquisition and Design/Final
Engineering): $83,000
• Water Plant Roof Replacement (Phase 2): $310,000
• Unit 66 (Ambulance) Replacement: $350,000
SKY HARBOR ASPHALT/CONCRETE RECONSTRUCTIONS:
$1,534,464
WATER MAIN REPLACEMENTS: $2,684,254
Project Highlights:
• Includes replacing original,
1950’s cast iron main with
larger diameter ductile iron
main.
WENDY DRIVE STORMWATER PROJECT: $221,000
This project involves installing new inlets along Wendy Drive as well as an overflow
flood route or detention facility.
SUMMARY FOR FISCAL YEAR 2021/2022
Infrastructure Capital Sanitary Sewer Stormwater
General Fund Improvement Fund Water Fund Fund Fund Total
Capital Expense $2,018,420 $1,593,814 $2,839,782 $355,000 $1,338,000 $8,145,016
Planned Financing
Bond Proceeds $1,075,550 $336,020 $2,764,782 $225,000 $1,338,000 $5,739,352
Designated Revenue $ - $507,107 $75,000 $130,000 $ - $712,107
Undesignated
Revenue $942,870 $750,687 $ - $ - $ - $1,693,557
Total $2,018,420 $1,593,814 $2,839,782 $355,000 $1,338,000 $8,145,016
Fund Total As a
Percentage of the
FY Total 25% 21% 34% 4% 16% 100%
FY 21/22 – SIGNIFICANT PROJECTS
• Asphalt Rehabilitation/Water Main Replacement Overlapping
Projects on and around Russett Lane: $3,805,076 (Total
Cost)
• First Street/Center Avenue Stormwater Project (Construction):
$484,000
• Willow Creek Subdivision Stormwater Project
(Property/Easement Acquisition and Design/Final
Engineering): $854,000
• Self-Contained Breathing Apparatus Replacement: $915,550
RUSSETT LANE OVERLAPPING ASPHALT/WATER
MAIN PROJECTS: $3,805,076 (TOTAL COST)
These overlapping projects will impact the area around Russett Lane with
additional work in other areas of the Village.
FIRST STREET/CENTER AVENUE STORMWATER
PROJECT: $484,000
This project includes construction of a relief sewer from the First and Center area to
the Village Hall detention pond.
WILLOW CREEK SUBDIVISION STORMWATER
PROJECT: $854,000
This project involves installing a new 36-inch storm sewer in the Willow Creek
subdivision to the South Fork Techny Drain.
QUESTIONS?
MEMORANDUM
TO: Village President and Board of Trustees
FROM: Richard A. Nahrstadt, Village Manager
Jeffrey L. Rowitz, Deputy Village Manager/Chief Financial Officer
DATE: November 11, 2016
RE: 2016 Property Tax Levy
At the December 13, 2016 meeting, the Village Board will review an ordinance to establish the 2016
property tax levy. At the November 15, 2016 meeting of the Administration & Finance Committee, staff
will be seeking direction for preparation of this ordinance.
The Illinois Truth in Taxation law requires that we calculate our estimated levy increase at least 20 days
prior to adoption (35 ILCS 200/18-60). If the calculated increase is expected to exceed 105% of the
previous year’s levy, we are required to publish specific notices and conduct a public hearing prior to
adoption of the levy Ordinance (35 ILCS 200/18-70). The proposed levy exceeds 105% of last year’s
levy.
The timing differences between the tax levy cycle and the Village’s budget cycle cause the Village Board
to make decisions on the property tax levy before our budget cycle even begins. While the tax levy
ordinance must be approved and filed in December, abatements can be filed through March. This gives
the Village Board the ability to reduce the levy during the budget process, but not the ability to increase it.
In consideration of these circumstances, we recommend that the Village Board adopt a tax levy that will
provide you the most flexibility in making these decisions.
As you know, the Village is required by statute to annually conduct an actuarial evaluation of our police
and fire pension funds and to fund the required contributions. State law dictates the benefits and the
required funding method. The only variables within Village control are the assumed rate of investment
return and the assumed rate for salary increases.
Since 2005, we have assumed an 8% rate of return. This was in line with other public sector pension plans
and historical averages. However, in examining our actual investment returns below, we recommend
phasing in a reduction to 7% over the next two years.
Rate of Return
Police Fire
2004/05 6.95% 7.46%
2005/06 7.28% 10.47%
2006/07 8.33% 9.09%
2007/08 1.96% 3.04%
2008/09 -8.58% -10.58%
2009/10 13.32% 14.70%
2010/11 9.23% 8.83%
2011/12 4.33% 2.38%
2012/13 7.93% 7.73%
2013/14 10.98% 10.41%
2014/15 6.86% 6.84%
2015/16 -3.76% -5.63%
Avg - Last 7 years 6.98% 6.47%
Assuming a 7.5% rate of return and applying the actuarial method and amortization period required by
state law, our actuary has calculated that the Village’s required contributions to our police and fire
pension funds will increase by a total of $2,212,661.
As we do every year, we met with President Frum and Trustee Scolaro to discuss options and receive
direction on the proposed levy. President Frum and Trustee Scolaro recommend using $1 million of the
$2.8 million General Fund surplus reserves (reserves above our 40% fund balance policy) to offset a
portion of this increase. The attached schedules reflect the proposed levy with and without using $1
million from the General Fund surplus reserves.
VILLAGE OF NORTHBROOK
TRUTH IN TAXATION ANALYSIS
Proposed 2016 Tax Levy - With using $1 million from GF surplus
2015 2016
EXTENSION EXTENSION DOLLAR PERCENT
FUND (FY 16/17) (FY 17/18) CHANGE CHANGE
GENERAL CORPORATE 7,820,749 8,055,370 $ 234,621 3.00%
POLICE PENSION 1,803,482 2,449,665 646,183 35.83%
FIRE PENSION 1,748,485 2,314,963 566,478 32.40%
TOTAL VILLAGE (EX. DEBT SERVICE) 11,372,716 12,819,998 1,447,282 12.73%
LIBRARY GENERAL 6,235,000 6,437,000 202,000 3.24%
LIBRARY IMRF 470,000 475,000 5,000 1.06%
LIBRARY SOCIAL SECURITY 265,000 270,000 5,000 1.89%
TOTAL LIBRARY 6,970,000 7,182,000 212,000 3.04%
TOTAL FOR TRUTH IN
TAXATION CALCULATION 18,342,716 20,001,998 1,659,282 9.05%
DEBT SERVICE (AFTER ABATEMENTS)
VILLAGE 2,661,337 3,214,956 553,619 20.80%
LIBRARY 1,010,891 1,016,420 5,529 0.55%
3,672,228 4,231,376 559,148 15.23%
GRAND TOTAL 22,014,944 24,233,374 2,218,430 10.08%
TOTAL VILLAGE ONLY
(INCLUDING DEBT SERVICE) 14,034,053 16,034,954 2,000,901 14.26%
VILLAGE OF NORTHBROOK
TRUTH IN TAXATION ANALYSIS
Proposed 2016 Tax Levy - Without $1 million from GF surplus
2015 2016
EXTENSION EXTENSION DOLLAR PERCENT
FUND (FY 16/17) (FY 17/18) CHANGE CHANGE
GENERAL CORPORATE 7,820,749 8,055,370 $ 234,621 3.00%
POLICE PENSION 1,803,482 2,949,665 1,146,183 63.55%
FIRE PENSION 1,748,485 2,814,963 1,066,478 60.99%
TOTAL VILLAGE (EX. DEBT SERVICE) 11,372,716 13,819,998 2,447,282 21.52%
LIBRARY GENERAL 6,235,000 6,437,000 202,000 3.24%
LIBRARY IMRF 470,000 475,000 5,000 1.06%
LIBRARY SOCIAL SECURITY 265,000 270,000 5,000 1.89%
TOTAL LIBRARY 6,970,000 7,182,000 212,000 3.04%
TOTAL FOR TRUTH IN
TAXATION CALCULATION 18,342,716 21,001,998 2,659,282 14.50%
DEBT SERVICE (AFTER ABATEMENTS)
VILLAGE 2,661,337 3,214,956 553,619 20.80%
LIBRARY 1,010,891 1,016,420 5,529 0.55%
3,672,228 4,231,376 559,148 15.23%
GRAND TOTAL 22,014,944 25,233,374 3,218,430 14.62%
TOTAL VILLAGE ONLY
(INCLUDING DEBT SERVICE) 14,034,053 17,034,954 3,000,901 21.38%