HomeMy WebLinkAboutWK - May 22, 2018ANLb
Y O F6
1685 CROSSTOWN BOULEVARD N.W. • ANDOVER, MINNESOTA 55304 • (763) 755-5100
FAX (763) 755-8923 • WWW.ANDOVERMN.GOV
City Council Workshop
Tuesday, May 22, 2018
Conference Rooms A & B
1. Call to Order— 6:00 p.m.
2. Joint Meeting with Open Space Advisory Commission
3. Update on City Campus Master Plan -Administration
4. 2018 CIP Progress Update & 2019-2023 CIP Development Discussions- Administration
5. April 2018 Budget Progress Reports -Administration
6. April 2018 City Investments Review—Administration
7. Other Business
8. Adjournment
1685 CROSSTOWN BOULEVARD N.W. • ANDOVER, MINNESOTA 55304 . (763) 755-5100
FAX (763) 755-8923 • WWW.ANDOVERMN.GOV
TO:
CC:
From:
Subject:
Date:
Mayor and Council Members
Jim Dickinson, City Administrator
David D. Berkowitz, Director of Pu is orks/City Engineer��
Kameron Kytonen, Natural Resources
Joint Meeting with Open Space Advisory Commission
May 22, 2018
0
INTRODUCTION
The Open Space Advisory Commission has met on several occasions and continues to plan for ongoing
management and development of the properties. The Commission would like to get feedback from the
City Council on various items related to these properties, discuss potential funding options for future
properties of interest and the future of the Open Space Advisory Commission and its role.
DISCUSSION
The following items will be discussed during the meeting. Chairperson Sabel has prepared a slide show
which will include most of these talking points:
• "State of the Nature Preserves"
• Funding for land; setting money aside;
• Future?
ACTION REQUESTED
The City Council is requested to meet with the Open Space Advisory Commission and provide feedback
on the above talking points.
Respectfully submitted,
J '/
Kameron Kytonen
Natural Resources Technician
• F
19.1
NDOVEA
1685 CROSSTOWN BOULEVARD N.W. • ANDOVER, MINNESOTA 55304 • (763) 755-5100
FAX (763) 755-8923 • WWW.ANDOVERMN.GOV
TO:
FROM:
SUBJECT:
DATE:
Mayor and Council Members
Jim Dickinson, City Administrator
Update on City Campus Master Plan
May 22, 2018
ACTION REOUESTED
The City Council is requested to receive an update from 292 Design Group relative to exploring
the expansion of the Andover YMCA Community Center. Focus of the presentation/discussion
will be responding to the stakeholder input received via a schematic design presentation. Also,
Construction Manager, RJM Construction will be available to provide their expertise and high-
level budgeting for the schematic design.
DISCUSSION
On December 5, 2017, the City Council approved the 292 Design Group (292) as the architectural
firm to provide architectural services to explore expansion of the Andover YMCA Community
Center. The programming, schematic design and project development phase is working toward a
decision point date in June 2018 as to what components of an expansion may progress to
construction documents.
On February 1St, City Staff and 292 held a stakeholder meeting with many of the local sports
associations, school officials, Fun Fest representatives and Andover YMCA. On February 12th the
City Council and Community Center Advisory Commission was updated on the stakeholder input
and the Council & Commission provided their goals for the project.
Since February, City Staff has worked with 292 & RJM to assemble designs that will address the
requests of the stakeholder groups and engage the YMCA on their potential participation in an
expansion. The results of the past few months discussions will be presented at the meeting.
od,
rim, wr
i ilt,
1685 CROSSTOWN BOULEVARD N.W. • ANDOVER, MINNESOTA 55304 • (763) 755-5100
FAX (763) 755-8923 • WWW.ANDOVERMN.GOV
TO:
FROM:
SUBJECT:
DATE:
Mayor and Councilmembers
Jim Dickinson, City Administrator
2018 CIP Progress Update & 2019-2023 CIP Development Discussions
May 22, 2018
0
INTRODUCTION
Late March, Administration/Finance distributed baseline worksheets to Department Heads for the
2019-2023 CIP kick-off. Subsequent discussion centered on the 2019-2023 CIP development, the
need of other committees (Vehicle/Equipment Purchasing & Facility Management Committees)
and commissions (Parks and Recreation & Community Center Advisory) to start their work and
to work toward a "draft" proposed 2019-2023 CIP to present to the City Council.
DISCUSSION
Throughout the summer a significant amount of time will be spent on evaluating utility
infrastructure, transportation improvements, building maintenance, equipment and park and
recreation needs. Each of these items will be supported by a detailed fund balance analysis of
funding sources (based on various assumptions and estimates) that will be presented to the Council
for review at future workshops.
At this time, the Staff would like to have a brief discussion with the Council to determine
Council's priorities for a 2019-2023 CIP are being met. It is anticipated that interactive
reviews will be done at future workshop meetings, but the focus during those reviews will be
on new projects and outstanding questions on previously proposed proiects where staff needs
ongoing Council direction (such as State Aid Routes Reconstruction, Trial improvements &
maior building/expansion proiects).
Attached is a spreadsheet identifying the current 2018 Capital Improvement Plan Projects
by Department and the progress on each project, also attached for reference is the
introduction section of the 2018-2022 CIP adopted by the Council last October.
ACTION REQUESTED
The Council is requested to review the attachments, receive a brief presentation, and provide
direction to staff on Council priorities for the 2019-2023 CIP.
fitted,
CITY OF ANDOVER
2018 Capital Improvement Plan
Projects By Department - Use of Funds
Community Center
I@
ACC/YMCA Expansion
$ 200,000
Exploration In Process
Replacement - Carpeting
12,000
Summer
New - Inflatables
5,000
Reviewing options
Replacement - Pickleball Inserts/Net System
5,000
Core drilling end of month
Replacement - Track Skid Steer
222,000
Purchased
Emergency Management
55,000
Reviewing options
Emergency Operations Center Improvement
18,000
Under construction
Replacement - Emergency Sirens
45,000
In process
63,000
Engineering
New Development Projects
160,000
Ongoing
Pedestrian Trail Maintenance
55,000
Under contract
New Pedestrian Trail and Sidewalk Segments
587,000
Design; will bid trail / boardwalk separate
Pedestrian Trail Reconstruction
80,000
Pedestrian Curb Ramp Replacements
16,000
Under contract
Replacement - Data Collector/Total Station
33,500
Purchased
931,500
Facility Management
Annual Parking Lot Maintenance
130,000
FS #1 design
Public Works Relocation / Expansion
450,000
Open house scheduled 05/23/18
Replacement - Carpet/Tile
10,000
Completed
590,000
Fire
Replacement - Turnout Gear
20,000
Replacement - Grass #31
85,000
Under construction
105,000
Information Technology
Smartboard Addition
12,000
Summer
Shortel Switch Replacement
10,000
Review options
22,000
Park & Recreation - Operations
Replace/Repair Play Structures - Various Parks
50,000
On going
Replace/Repair Major Park Projects - Various Parks
35,000
On going
Replacement - One Ton Crew Cab Truck
80,000
Reviewing options
New - Brush Cutter
15,000
Purchased
Replacement - Track Skid Steer
60,000
Purchased
Replacement - Small Extended Cab Truck #76
55,000
Reviewing options
295,000
Park & Recreation - Projects
Annual Miscellaneous Projects 15,000 Ongoing
Irrigation Projects - Small Parks 25,000 Quotes received, Wild Iris this year
40,000
Sanitary Sewer
Lift Station Improvements 230,000 Ongoing
Replacement - One Ton Utility Truck #69 150,000 Reviewing options
380,000
CITY OF ANDOVER
2018 Capital Improvement Plan
Projects By Department - Use of Funds
Storm Sewer
Storm Sewer Improvements 60,000 Ongoing
Replacement - Tymco Street Sweeper #172 235,000 Purchased
295,000
Streets / Highways
Annual Street Seal Coat Project
700,000
Under contract
Annual Street Crack Seal Project
150,000
Under contract
Annual Pavement Markings
40,000
Under contract
Annual Curb Replacement
52,000
Under contract
Municipal State Aid Routes / New & Reconstruct
900,000
Construction has begun
Annual Street Reconstruction
667,000
Construction has begun
Gravel Road Improvement
20,000
Completed
Replacement - Lazer Line Painter
8,500
Purchased
Replacement - Hot Fetcher Box #08-180
75,000
Purchased
2,612,500
Water
Rehabilitation of Wells
50,000
Summer/ Fall
Replacement - 3/4 Ton Utility Truck #66
60,000
Reviewing options
Replacement - Side by Side UTV #70
48,000
Ordered
Water Main Improvements
664,000
Construct 143rd Ave
822,000
Grand Total
$ 6,378,000
0
9
C I T Y O F,
NDOVE.
1685 CROSSTOWN BOULEVARD N.W.. ANDOVER, MINNESOTA 55304 . (763) 755-5100
FAX (763) 755-8923 • WWW.CLAN DOVER. MN. US
TO: Mayor and Council Members FROM: Jim Dickinson, City Administrator / Finance Director copy
SUBJECT: 2018 — 2022 Capital Improvement Plan
DATE: October 17, 2017
INTRODUCTION
On behalf of the City's Management Team, I am pleased to present the City of Andover's Capital
Improvement Plan for years 2018 through 2022. The City's management team and their respective staff
worked diligently to produce a document that was both practical, substantive in addressing needed capital
improvements and insightful regarding the underlying factors associated with the City's rapidly changing
suburban landscape.
CAPITAL IMPROVEMENT PLAN GOALS
ACKNOWLEDGE AND COMMUNICATE
PUBLIC INFRASTRUCTURE PRIORITIES AND DYNAMICS
ENSURE APPROPRIATE RESPONSES
TO CHANGING INFRASTRUCTURE NEEDS AND DEMANDS
DEVELOP A FINANCIAL ASSESSMENT OF CAPITAL RESOURCES
AVAILABLE TO MEET FUTURE CAPITAL PROJECT PLANNING NEEDS
INSTITUTE A STRATEGIC VISION
PREDICATED ON MAINTAINING A HIGH QUALITY SERVICE INFRASTRUCTURE CAPABLE OF
MEETING THE NEEDS OF OUR CITIZENS FOR TODAY AND TOMORROW
The purpose of the City's Capital Improvement Plan (CIP) is to identify, prioritize and address
community needs through careful long-term capital planning and balanced public investment in
supporting physical infrastructure. To ensure that this commitment is both meaningful and achievable,
appropriate capital improvement factors were given significant consideration in developing a CIP that
addresses community priorities over the next five (5) years. The CIP will also provide a planning
foundation for future needs assessments to ensure the City is appropriately responding to the critical
infrastructure needs necessary for sustainable future growth. The CIP represents a beginning in terms of
producing a comprehensive planning response to address changing capital needs by developing a project
schedule that will lead to timely and cost-effective project completions.
The 2018 - 2022 CIP has been prepared as a strategic planning tool to assist the City Council in
identifying proposed capital improvement projects over the next five years. With the inclusion of
preliminary financing sources, appropriate background information citing needs and projected cost
estimates, this document will provide Council with the needed information to begin the process for
planning improvements that meet the City's physical infrastructure needs. Consequently, the CIP serves
as a flexible guide plan to properly identify the critical components of the City's infrastructure, yet
maintain flexibility in determining project timeframes, project scope and possible funding sources. The
2018 - 2022 CIP continues the emphasis of judiciously managing the City's limited resources by
prudently planning for known and/or anticipated future capital expenditures.
A critical step in the plan adoption process is the collaborative nature of plan review that involves the
leadership of the City Council, the input of appointed Commissions and staff, and most importantly,
affected residents of the community. Consequently, the strategic value of this plan lies in the
acknowledgement of future needs by the governing body and the effective communication of those needs
to the general public during project development stages. Likewise, the availability and preliminary
designation of fiscal resources to serve both current and future needs is critical to the achievement of plan
outcomes that meet with Council approval. Following the approval of the plan, feasibility studies are
performed, affected constituencies are notified to formally disseminate and receive public feedback on
proposed project plans. This process culminates with the City Council considering all relevant
information and making a final decision on whether to proceed with the proposed capital improvement.
The public process that supports the advancement of these projects from inception to completion is
engendered in the CIP project development and authorization schedule. Formalizing the steps in the CIP
project advancement process serves a number of purposes and ensures that the Council and public are
kept well informed regarding project purposes and desired outcomes, estimated project costs, funding
sources, progress and final status. It should be emphasized that projects will require approval in various
stages of project development by the City Council in accordance with approved policies.
The objectives of the 2018 - 2022 Capital Improvement Plan are to present a comprehensive capital
improvement program that communicates efforts:
➢ to ensure that community priorities are reflected in the capital investment plans
of each City department;
➢ to provide a consolidated financial picture of anticipated expenditures and
outline recommended funding strategies to underwrite anticipated capital
improvements;
➢ to document and communicate capital improvement processes for City projects
that will ensure consistency, a full appreciation of both the costs and benefits of
proposed capital investments, and raises the level of public understanding
regarding the City's public improvement processes;
➢ to provide information on the fiscal impacts of capital investment plans on total
City finances; and
➢ to effectively plan for public improvements that support community needs in the
areas of private development infrastructure, transportation, public safety, parks
and recreation, utilities, and commercial/industrial growth through fiscally
responsible economic development initiatives.
Accordingly, this document attempts to recognize known or perceived capital improvement needs, but as
with any plan recognizes that social, economic and political considerations will by necessity determine
final project outcomes. The major categories of expenditures that are identified within the CIP include,
but are not limited to:
1. New Public Facilities Planning
2. Street Construction, Maintenance and Reconstruction
3. Utility Construction, Maintenance and Reconstruction
4. Construction, Maintenance and Upgrade of Parks, Playgrounds and Trails
5. Capital Improvements to Existing Facilities
6. Private development infrastructure
7. Capital equipment and vehicle planning needs (Equipment purchases to be determined through
normal budgetary process)
The City Council, consequently, accepts this document with the provision that capital improvement
planning is subject to the dynamics of community growth, political leadership and acknowledges that
other unanticipated needs may take precedence over planned projects.
The 2018 - 2022 Capital Improvement Plan is the product of collaborative planning efforts by City staff,
Park and Recreation Commission, Community Center Advisory Commission and the City Council.
Projects have been introduced based on 1) anticipated future growth trends articulated in the City's
current Comprehensive Plan, 2) the natural cycle of deterioration and decay evident in all physically
constructed and engineered improvements in the more established areas of the community and 3) capital
deficiencies or infrastructure issues brought to the City's attention through a variety of sources.
Capital expenditures identified within the CIP are the best estimates available, and once the CIP is
adopted, will be reviewed and confirmed through individual feasibility reports where appropriate. I am
appreciative of the commitment, good judgment and expertise that each department has contributed to the
capital improvement planning process.
Respectfully submitted,
Jim Dickinson
City Administrator
CIP PROJECT DEVELOPMENT AND 10
PROCESS AUTHORIZATION SCHEDULE
The following process is a Council/staff guideline for authorizing public improvement projects. As this process
is controlled by State Statute and other influencing environmental factors, it is subject to change and should be
viewed as a guide to assist the Council and public in understanding the public improvement process used by
City staff. A separate Council meeting would facilitate each step in the process, and accomplishment of
respective activities. As a result, the process time frame is a significant factor affecting City staffs ability to
properly manage and complete approved Council ordered projects within budget and on time.
1. Council Approval of Annual CIP Projects by City Resolution will authorize the following outcomes:
a) Staff and/or Consultant preparation of project feasibility studies
b) Staff preparation of detailed financial review of project funding sources
c) Neighborhood Meeting may be held prior to Feasibility Study subject to need and Type of project.
TIME FRAME: October -November of each preceding year.
2. Presentation of Feasibility Study
a) Feasibility Study Components:
I ) Review of Project Engineering and Construction Estimates
2) Total Project Costs (All related project costs, i.e. land, soft costs)
3) Project Financial Plan/Fiscal Implications (Engineering/Finance)
4) Authorization to develop a Preliminary Assessment Roll, if any, for the Public Hearing.
(Engineering)
• If Council accepts Feasibility Study, A Resolution "Accepting Feasibility Study and Setting Date for
Public Hearing on the Project" when appropriate (Engineering Department) would initiate the
following:
1) Notices mailed to affected Residents per statute requirements no less than 10 days before Public
Hearing. (Engineering)
2) Public Hearing Notice is published. Two publications one week apart, with the second publication
no less than three days before the hearing. (Engineering/City Clerk)
TIME FRAME: February -March -April -May of current year.
3. Neighborhood Meeting — City staff will hold neighborhood project meetings, when appropriate, to review
and present Project Feasibility Studies, answer questions and meet with affected property owners. These
meetings will include a question and answer component designed specifically to bring awareness to the
property owner, obtain citizen input and produce an understanding of the purposes behind the City's
attempts to construct public improvements in the affected area.
TIME FRAME: Following the presentation of the Feasibility Study to Council, but prior to the holding of a
Public Hearing by Council.
4. Council holds a Public Hearing when appropriate for following purposes:
a) Presentation of Project (Engineering Department)
b) Presentation of Preliminary Special Assessment Rolls and Financing Implications (Engineering/Finance
Department)
c) Council to hear Affected Resident Input
d) Council determines whether to "order" the public improvement
• A Council Resolution is drafted "Ordering the Project and Authorizing Preparation of Plans and
Specifications" (Engineering Department). Council may ORDER THE IMPROVEMENT after the public
hearing is closed or at a subsequent Council Meeting within 6 months of the public hearing date.
(Statutory Requirement - Council Resolution ordering project must be approved on 4/5 Council vote if it
is Council initiated project with assessments).
If Council decides to reject the project as presented, a Council vote should be taken to officially
determine the final status of the project.
TIME FRAME: April -May -June of current year
5. Plans and Specifications are presented to Council for approval. (Engineering Department)
a) A Council Resolution is drafted authorizing the following:
1) Accepting and Approving Project Plans and Specifications
2) Authorizing the Advertisement for Project Bids. Bids are developed and invitation to Bid is
processed. Bid opening date is no less than 3 weeks after publication. (Engineering)
3) Authorize staff to pursue an appropriate funding mechanism to underwrite project costs
TIME FRAME: May -June of each year
6. Council Acceptance of Project Bids and Awarding of Contracts would authorize the following outcomes:
a) A Council Resolution is drafted "Accepting Project Bids and Awarding Contracts" (Engineering)
b) Initiation of Project Construction and work (Engineering)
TIME FRAME: April -May -June -July of current year.
7. Project Completion
a) Council Acceptance of Project
b) Final Presentation and Review of Project Costs versus Project Budget by Finance Department.
c) If Special Assessments are financing a portion of the Project, A Council Resolution "Setting the Special
Assessment Hearing for Project #" is adopted at this same meeting. (Engineering/Finance)
TIME FRAME: Upon completion of project.
8. If Special Assessments would finance a portion of the projects costs, Council Holds a Special Assessment
Hearing to review the following:
a) Affected Property owners would be officially notified per statute no less than two weeks prior to Special
Assessment Hearing. (Clerk/Engineering)
b) Public Notice is published no less than two weeks prior to Special Hearing per statute
(Clerk/Engineering)
c) Staff prepares a proposed roll and Council Approves Final Assessment Roll (Engineering/Finance)
d) Council consideration of Assessment Appeals and Requested Deferrals filed prior to hearing or during
the hearing.
e) Meets M.S. Chapter 429 statutory requirements
• A Council Resolution is drafted "Adopting Final Special Assessment Roll"(Engineering), and is
adopted at this meeting.
TIME FRAME: October/November of current year depending on finalization of project and status of
completion.
CITY OF ANDOVER
2018 CIP Expenditures By Year
2022 $5,091,000
2021 $6,864,00
2020 9,135,000
2019 $23,712,500
2018 $6,378,000
2017 Adopted $6,794,800
$- $5,000,000 $10,000,000 $15,000,000 $20,000,000 $25,000,000
b
City of Andover, MN
Capital Plan
2018 thru 2022
DEPARTMENT SUMMARY
Department 2018 2019 2020 2021 2022 Total
Building
35,000
35,000
Central Equipment
45,000
45,000
Community Center
222,000
7,923,000
589,000
258,000
158,000
9,150,000
Emergency Management
63,000
52,500
55,000
10,000
180,500
Engineering
931,500
342,000
1,353,000
781,000
490,000
3,897,500
Facility Management
590,000
8,615,000
132,000
39,000
50,000
9,426,000
Finance
200,000
200,000
Fire
105,000
428,000
306,000
595,000
505,000
1,939,000
Information Technology
22,000
22,000
Park&Rec- Operations
295,000
85,000
415,000
85,000
85,000
965,000
Park&Rec- Projects
40,000
35,000
415,000
15,000
15,000
520,000
Sanitary Sewer
380,000
650,000
1,030,000
Stone Sewer
295,000
60,000
312,000
65,000
68,000
800,000
Streets/Highways
2,612,500
5,029,000
2,658,000
4,966,000
3,670,000
18,935,500
Water
822,000
863,000
2,250,000
50,000
50,000
4,035,000
TOTAL 6,378,000
23,712,500
9,135,000
6,864,000
5,091,000
51,180,500
City of Andover, MN
Capital Plan
2018 thru 2022
FUNDING SOURCE SUMMARY
Source 2018 2019 2020 2021 2022 Total
Assessments
932,500
1,282,000
318,500
467,000
523,000
3,523,000
Capital Equipment Reserve
828,500
367,500
465,000
84,000
85,000
1,830,000
Comm CIr Operations
22,000
198,000
86,000
258,000
158,000
722,000
Construction Seal Coat Fund
10,000
12,000
14,000
16,000
18,000
70,000
Equipment Bond
488,000
1,376,000
760,000
930,000
3,554,000
G.O. Bond
650,000
16,875,000
500,000
18,025,000
General Fund
115,000
105,000
105,000
105,000
105,000
535,000
Grant
254,000
1,600,000
1,854,000
Municipal State Aid Funds
824,500
2,174,500
392,500
750,000
947,000
5,088,500
Park Dedication Funds
40,000
35,000
135,000
15,000
15,000
240,000
Road & Bridge Funds
1,636,500
1,830,500
1,646,000
2,142,000
2,007,000
9,262,000
Sanitary Sewer Fund
166,000
166,000
Sewer Trunk Fund
177,000
120,000
775,000
125,000
125,000
1,322,000
Ston Sewer Fund
76,000
60,000
62,000
65,000
68,000
331,000
Trail Funds
587,000
681,000
372,000
1,640,000
Water Fund
126,000
120,000
1,275,000
50,000
50,000
1,621,000
Water Trunk Fund
187,000
45,000
1,050,000
55,000
60,000
1,397,000
GRAND TOTAL
6,378,000
23,712,500
9,135,000
6,864,000
5,091,000
51,180,500
City of Andover, MN CD
Capital Plan
2018 thru 2022
PROJECTS & FUNDING SOURCES BY DEPARTMENT
Department Project# Priority 2018 2019 2020 2021 2022 Total
Building
Replacement- Small Extended Cab Pick Up #8 19-02300-01 1 35,000 35,000
Equipment Bond 35,000 35.000
Building Total
Central Equipment
Replacement - Service Truck #371 19-48800-01
Equipment Bond
Central Equipment Total
Communitv Center
ACCNMCA Expansion
18-44000.01
G.O. Bond
35,000
Replacement - Carpeting
18-44000-02
Comm Ctr Operations
45,000
New -Inflatables
18-44400-01
Comm Ctr Operations
45,000
Replacement- Pickleball lnserslNet System
1844400-02
Comm Ctr Operations
45,000
Replacement - All Community Center Doors
19-44000-01
Comm Ctr Operations
6,925,000
Replacement - Skate Sharpener
19-44200-01
Comm Ctr Operations
6,925,000
Refacing Rink Boards
19-44300-01
Comm Ctr Operations
24,000
Repaint Ice Arena ceiling
19-44300-02
Comm Cir Operations
24000
Replacement- Ice Arena Refrigeration Replacement
1944300-03
G.O. Bond
5,000
Replacement - Heat Exchangers-Munters Unit
19-44300-04
Comm Ctr Operations
5,000
Replacement- Zemboni Battery Pack
19-44300-05
Comm Ctr Operations
5,000
Replacement- Munters Desiccant Wheel
1944300-06
Comm Ctr Operations
5,000
Replacement - Scissor Lift
20-44000-01
Equipment Bond
75,000
Replacement - Lobby Furniture
2044000-02
Comm Ctr Operations
75,000
Replacement - Roof
20-44000-03
G.O. Bond
8,000
Replacement- Kaivac Cleaning System
20-44000-04
35,000
35,000
2
45,000
45,000
45,000
45,000
45,000
45,000
2 200,000
6,725,000
6,925,000
200,000
6,725,000
6,925,000
1 12,000
12,000
24,000
12,000
1$000
24000
1 5,000
5,000
5,000
5,000
1 5,000
5,000
5,000
5,000
1
75,000
75,000
75,000
75,000
1
8,000
8,000
8,000
8,000
1
25,000
25,000
25,000
25,000
1
25,000
25,000
25,000
25,000
1
1,000,000
1,000,000
1,000,000
1,000,000
1
15,000
15,000
15,000
15,000
1
14,000
14,000
14,000
14,000
1
36,000
36,000
36,000
36,000
1
15,000
15,000
15,000
15,000
1
15,000
15,000
15,000
15,000
1
500,000
500,000
500,000
500,000
1
10,000
10,000
Department
Project#
Priority
2018
2019
2020
2021
a
2022 Total
Comm Ctr Operations
10,000
10,000
Replacement - Camera/Security System
20-04000-05
1
12,000
12,000
Comm Ctr Operations
12,000
11,000
Replacement- Zamboni Room Water Heater
20-44300-01
1
25,000
25,000
Comm Ctr Operations
25,000
25,000
Replacement - Floor Scrubber
21-44000-01
1
15,000
15,000
Comm Ctr Operations
15,000
15,000
Repaint Field House Ceiling
21-44200-01
1
25,000
25,000
Comm Ctr Operations
25,000
25,000
Replacement -Electric Edger
2144300-02
1
8,000
8,000
Comm Ctr Operations
8,000
8,000
Replacement- Evaporative Condenser
21-44300-03
1
60,000
60,000
Comm Ctr Operations
60,000
60,000
Replacement- Field House Floor
2144400-01
1
150,000
150,000
Comm Ctr Operations
150,000
150,000
Replacement-Zamboni
22-44300-01
1
150,000
150,000
Comm Ctr Operations
150,000
150,000
Replacement- Ice Rink Hard Dividers
22-44300-02
1
8,000
8,000
Comm Ctr Operations
8,000
8,000
Community Center Total
222,000
7,923,000
589,000
258,000
158,000
9,150,000
LEmergency Management
Emergency Operations Center Improvement
18-42400-01
1
18,000
7,500
10,000
10,000
45,500
Capital Equipment Reserve
18,000
7,500
10,000
10,000
45,500
Replacement- Emergency Sirens
18-02400-02
1
45,000
45,000
45,000
135,000
Capital Equipment Reserve
45,000
45,000
44000
135,000
Emergency Management Total
63,000
52,500
55,000
10,000
180,500
Engineering
New Development Projects
18-41600-01
1
160,000
165,000
175,000
180,000
185,000
865,000
Sewer Trunk Fund
117,000
120,000
125,000
125,000
125,000
612,000
Water Trunk Fund
43,000
45,000
50,000
55,000
60,000
253,000
Pedestrian Trail Maintenance
18-01600-02
1
55,000
60,000
65,000
70,000
75,000
325,000
Read 8 Bridge Funds
55,000
60,000
65,000
70,000
75,000
325,000
New Pedestrian Trail and Sidewalk Segments
18-41600-03
1
587,000
935,000
372,000
1,894,000
Grant
254,000
254,000
Trail Funds
587,000
681,000
372,000
1,640,000
Pedestrian Trail Reconstruction
1841600-04
1
80,000
100,000
120,000
140,000
160,000
600,000
Road B Bridge Funds
80,000
100,000
120,000
140,000
160,000
600,000
Pedestrian Curb Ramp Replacements
18-41600-05
1
16,000
17,000
18,000
19,000
20,000
90,000
Road& Bridge Funds
16,000
17,000
18,000
19,000
20,000
90,000
Replacement- Data Collectorrlotal Station
18-41600-06
1
33,500
33,500
Road 8 Bridge Funds
33,500
33,500
Replacement - Pick Up Truck #6
2041600-01
2
40,000
40,000
Equipment Bond
40,000
40,000
Replacement -3/4 Ton Truck #12
22-41600-01
2
50,000
50,000
Equipment Bond
50,000
50,000
Engineering Total
931,500
342,000
1,353,000
781,000
490,000
3,897,500
Facility Management
Annual Parking Lot Maintenance
18-41900-01
1
130,000
35,000
37,000
39,000
40,000
281,000
Capita/ Equipment Reserve
130,000
35,000
37,000
39,000
40,000
281,000
Public Works Relocation / Expansion
18-41900-02
1 450,000
8,500,000
Department
Project#
Priority 2018
2019 2020 2021 2022 Total
Public Works Relocation / Expansion
18-41900-02
1 450,000
8,500,000
8,615,000
8,950,000
G.O. Bond
50,000
450,000
8,500,000
8,950,000
Replacement - Carpet/Tile
1841900-03
1 10,000
10,000
10,000 30,000
Capital Equipment Reserve
1941400-01
10,000
10,000
10,000 30,000
Building A - Seal Floor
19-41900-01
1
25,000
25,000
Capital Equipment Reserve
200,000
25,000
25,000
Memorial - Veterans Memorial
19-41900-03
1
10,000
200,000
10,000
Capital Equipment Reserve
200,000
10,000
10,000
New- Diesel Exhaust Capturing System
1941900-04
1
45,000
45,000
Capita/ Equipment Reserve
18-42200-01
1
45,000
20,000
45,000
Surface Seal all Brick Structures
20-41900-01
1
Genera/Fund
85,000
85,000
Capital Equipment Reserve
20,000
20,000
20,000
48,000
48,000
Comm Ctr Operations
18-42200-02
1
85,000
12,000
11,000
Water Fund
85,000
Capital Equipment Reserve
25.000
25.000
Facility Management Total
590,000
8,615,000
132,000
39,000
50,000
9,426,000
Finance
Financial/ Payroll System Upgrade Replacement
1941400-01
1
200,000
200,000
Capital Equipment Reserve
200,000
200,000
Finance Total
200,000
200,000
Fire
Replacement -Turnout Gear
18-42200-01
1
20,000
20,000
20,000
20,000
20,000
100,000
Genera/Fund
20,000
20,000
20,000
20,000
20,000
100,000
Replacement - Grass #31
18-42200-02
1
85,000
85,000
Capital Equipment Reserve
85,000
85,000
Replacement - Tanker #11
19-42200-01
1
400,000
400,000
Equipment Bond
400,000
400,000
New- Bullex Fire Extinguisher Prop
1942200-02
2
8,000
8,000
Equipment Bond
8,000
8,000
Replacement- SCBA Compressors
20-42200-01
1
130,000
130,000
Equipment Bond
130,000
130,000
Replacement -800 MHz radios
20-42200-02
1
35,000
35,000
35,000
105,000
Capital Equipment Reserve
35,000
35,000
35,000
105,000
Replacement- Grass #21
20-42200-03
1
85,000
85,000
Equipment Bond
85,000
85,000
Replacement- Thermal Imaging Cameras
20-42200-04
1
36,000
36,000
Equipment Bond
36,000
36,000
Replacement- Grass Utility Vehicle (UTV) 94813
21-42200-01
1
45,000
45,000
Equipment Bond
45,000
45,000
Replacement- 1999 GMC Sonoma Truck (U-1 0) #4810
21-42200-02
2
45,000
45,000
Equipment Bond
45,000
45,000
Replacement -Engine 21#4884
2142200-03
1
450,000
450,000
Equipment Bond
450,000
450,000
Replacement -Engine 31#4800
22-42200-01
1
450,000
450,000
Equipment Bond
450,000
450,000
Fire Total
105,000
428,000
306,000
595,000
505,000
1,939,000
Information Technology
Smadboard Addition
1841420-01
1
12,000
12,000
Capital Equipment Reserve
11,000
12,000
(Sanitary Sewer
Lift Station Improvements
18-48200-02
1 230,000
650,000
Department
Project#
Priority
2018
2019
2020
2021
2022
Total
Shoretel Switch Replacement
18-01420-02
1
10,000
1 150,000
150,000
Sanitary Sewer Fund
10,000
General Fund
150,000
10,000
380,000
650,000
-
10,000
Information Technology Total
22,000
Storm Sewer Improvements
18-48300-01
1 60,000
60,000 62,000 65,000 68,000
22,000
Stone Sewer Fund
60,000
60,000 62,000 65,000 68,000
315,000
Replacement-Tymco Street Sweeper#172
18-08300-02
1 235,000
Park &Rec -Operations
Replace/Repair Play SWctures- Various Parks
18-05000-01
1
50,000
50,000
50,000
50,000
50,000
250,000
General Fund
50,000
50,000
50,000
50,000
50,000
250,000
Replace/Repair Major Park Projects - Various Parks
18-45000-02
1
35,000
35,000
35,000
35,000
35,000
175,000
General Fund
35,000
35,000
35,000
35,000
35,000
175,000
Replacement- One Ton Truck w/ Plow #599
18-05000-03
1
80,000
80,000
Capita/ Equipment Reserve
80,000
80,000
New - Brush cutter
18-45000.04
1
15,000
15,000
Capital Equipment Reserve
15,000
15,000
Replacement - Bobcat Track Loader 4610
18-45000-05
1
60,000
60,000
CapkalEquipmentReserve
60,000
60,000
Replacement -Small Extended Cab Truck#76
18-05000-06
1
55,000
55,000
Capital Equipment Reserve
55,000
55,000
Replacement - Water Tanker #161
20-45000-01
1
175,000
175,000
Equipment Bond
175,000
175,000
Replacement -Trailer #T-555
20-05000-02
1
18,000
18,000
Equipment Bond
18,000
18,000
Replacement- Cushman Field Dresser#547
20-45000-03
1
27,000
27,000
Equipment Bond
27,000
27,000
Replacement- Large Capacity Mower #11-582
20-45000-04
1
110,000
110,000
Equipment Bond
110,000
110,000
Park & Ree - Operations Total
295,000
85,000
415,000
85,000
85,000
965,000
Park & Ree - Projects
Annual Miscellaneous Park Projects
18-45001-01
1
15,000
15,000
15,000
15,000
15,000
75,000
Park Dedication Funds
15,000
15,000
15,000
15,000
15,000
75,000
Irrigation Projects - Small Parks
18-45001-02
1
25,000
20,000
45,000
Park Dedication Funds
25,000
20,000
45,000
Pine Hills North - Phase II
2045001-02
1
400,000
400,000
Capital Equipment Reserve
280,000
280,000
Park Dedication Funds
120,000
120,000
Park & Ree - Projects Total
40,000
35,000
415,000
15,000
15,000
520,000
(Sanitary Sewer
Lift Station Improvements
18-48200-02
1 230,000
650,000
880,000
Assessments
170,000
170,000
Sewer Trunk Fund
60,000
650,000
710,000
Replacement - One Ton Utility Truck #69
18-08200-03
1 150,000
150,000
Sanitary Sewer Fund
150,000
150,000
Sanitary Sewer Total
380,000
650,000
1,030,000
Storm Sewer
Storm Sewer Improvements
18-48300-01
1 60,000
60,000 62,000 65,000 68,000
315,000
Stone Sewer Fund
60,000
60,000 62,000 65,000 68,000
315,000
Replacement-Tymco Street Sweeper#172
18-08300-02
1 235,000
235,000
CapitalliqulpmentReserve
235,000
235,000
Department
Project # Priority 2018
2019 2020 2021 2022
Total
Replacement- Elgin Street Sweeper 4169
2048300-01 1
250,000
250,000
Equipment Bond
285,000
250.000
250.000
Storm Sewer Total 295,000 60,000 312,000 65,000 68,000 800,000
Streets / Highways
260,000
Annual Street Seal Coat Project
18-43100-01
Road 8 Bridge Funds
1,820,000
Annual Street Crack Seal Project
1843100-02
Construction Seal Coat Fund
285,000
Road & Bridge Funds
1,820,000
Annual Pavement Markings
1843100-03
Road & Bridge Funds
165,000
Annual Curb Replacement
18-43100-04
Road & Bridge Funds
12,000
Municipal State Aid Routes/ New & Reconstruct
1843100-05
Assessments
70,000
Municipal State Aid Funds
143,000
Annual Street Reconstruction
18-43100-06
Assessments
730,000
Road & Bridge Funds
42,000
Street Overlays
18-43100-07
Assessments
220,000
Road & Bridge Funds
42,000
Intersection Upgrades
1843100-08
Grant
220,000
Municipal State Aid Funds
54,000
Gravel Road Improvements
1843100-09
Road & Bridge Funds
280,000
Replacement- Lazar Line Painter
18-43100-10
Capital Equipment Reserve
58,000
Replacement - Hot Patch box #08-180
18-43100-11
Capital Equipment Reserve
2,050,000
Pedestrian Tunnel Under Crosstown Blvd,
1943100-01
G.O. Bond
4,730,000
Replacement -Bobcat S185#120
20-43100-01
Equipment Bond
15,000
Replacement - One Ton Track w/Plow #133
2043100-02
Equipment Bond
1,889,500
Replacement- Backhoe Loader #80
20-43100-03
Equipment Bond
4,328,500
Replacement - Front End Loader#124
20-43100-04
Equipment Bond
1,306,000
New - Dump Truck w/ snow removal
2143100-01
Equipment Bond
291,000
Replacement - Dump Truck w/Snow removal#198
22-43100-01
Equipment Bond
1,476,000
Replacement- Aerial bucket truck #00-139
2243100-02
Equipment Bond
- 979,000
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
Streets / Highways Total
Water
Rehabilitation of Wells 18-08100-01 1
Water Fund
700,000
260,000
275,000
285,000
300,000
1,820,000
700,000
260,000
275,000
285,000
300,000
1,820,000
150,000
155,000
160,000
165,000
170,000
800,000
10,000
12,000
14,000
14000
18,000
70,000
140,000
143,000
144000
149,000
152,000
730,000
40,000
42,000
44,000
46,000
48,000
220,000
40,000
42,000
44000
46,000
48,000
220,000
52,000
54,000
56,000
58,000
60,000
280,000
52,000
54,000
54000
58,000
60,000
280,000
900,000
2,050,000
410,000
290,000
1,080,000
4,730,000
75,500
160,500
17,500
15,000
133,000
401,500
824,500
1,889,500
392,500
275,000
947,000
4,328,500
667,000
1,163,000
1,202,000
1,306,000
1,560,000
5,898,000
167,000
291,000
301,000
327,000
390,000
1,476,000
500,000
872,000
901,000
- 979,000
1,170,000
4,422,000
350,000
500,000
850,000
87,500
125,000
212,500
262,500
375,000
637,500
285,000
2,075,000
2,360,000
1,600,000
1,600,000
285,000
475,000
760,000
20,000
20,000
21,000
21,000
22,000
104,000
20,000
20,000
21,000
21,000
22,000
104,000
8,500
8,500
8,500
8,500
75,000
75,000
75,000
75,000
650,000
650,000
650,000
650,000
60,000
60,000
60,000
60,000
80,000
80,000
80,000
80,000
100,000
100,000
100,000
100,000
250,000
250,000
250,000
250,000
220,000
220,000
220,000
220,000
230,000
230,000
230,000
230,000
200,000
200,000
200,000
200,000
2,612,500
5,029,000
2,658,000
4,966,000
3,670,000
18,935,500
50,000
50,000
50,000
50,000
50,000
250,000
50,000
50,000
50,000
50,000
50,000
250,000
Department Project Priority 2018 2019 2020 2021 2022 Total
Replacement - 3/4 Ton Utility Truck #66
1848100-02
1
60,000
60,000
Water Fund
60,000
60,000
Replacement - Side by Side UTV #70
18-48100-03
1
48,000
48,000
San Nary Sewer Fund
16,000
16,000
Storm Sewer Fund
16,000
1x;000
Water Fund
16,000
16,000
Water Main Improvements
1848100-04
1
664,000
743,000
1,407,000
Assessments
520,000
743,000
1,263,000
Water Trunk Fund
144,000
144,000
New- Valve Maintenance Trailer
19-48100-01
1
70,000
70,000
Water Fund
70,000
70,000
Water Meter Reading System AMI/AMR
2048100-01
2
1,200,000
1,200,000
Water Fund
1,200,000
1,200,000
Recondition& Paint Water Tower #2
20-48100-02
1
1,000,000
1,000,000
Water Trunk Fund
1,000,000
11000,000
Water Total 822,000 863,000 2,250,000 50,000 50,000 4,035,000
GRAND TOTAL 6,378,000 23,712,500 9,135,000 6,864,000 5,091,000 51,160,500
1685 CROSSTOWN BOULEVARD N.W.. ANDOVER, MINNESOTA 55304 . (763) 755-5100
FAX (763) 755-8923 . WWW.ANDOVERMN.GOV
TO: Mayor and Councilmembers
FROM: Jim Dickinson, City Administrator
SUBJECT: April 2018 General Fund Budget Progress Report
DATE: May 22, 2018
INTRODUCTION
The City of Andover 2018 General Fund Budget contains total revenues of $11,085,238 and total
expenditures of $11,319,815; a decrease in fund balance is planned.
Monthly reporting of the City Budget progress to the Governing body is a recommended financial
practice and often viewed positively by rating agencies.
DISCUSSION
Attached is the General Fund Revenue & Expenditure Budget Summary - Budget Year 2018
reflecting year to date actual through April 2018. The attachment provided is to assist
discussion in reviewing 2018 progress: other documents may be distributed at the meeting
The following represents Administration's directives and departmental expectations in place for
2018:
1. Expenditure budgets while approved, expenses are to meet with the spirit that needs are
fulfilled first, expansions of service and special requests are to be reviewed with City
Administration before proceeding.
2. Departments are to be committed to search for the best possible prices when purchasing goods
and services.
3. Departments are to be committed to continually searching out new efficiencies and to
challenge the status quo of how the City provides services.
4. Departments are to be committed to searching out collaborative opportunities to facilitate
efficient and cost-effective utilization of governmental assets and personnel.
5. Departments are to be committed to developing effective, consistent and ongoing
communications with City residents, businesses and other stakeholders.
6. Departments are to be cognizant that services provided are subiect to available revenues and
should not commit to services that are not sustainable.
ACTION REQUESTED
The Council is requested to receive a presentation from staff.
tted,
CITY OF ANDOVER
General Fund Budget Summary Totals
Budget Year 2018
2017 2018
REVENUES Budget Apr YTD %Bud Final Budget Apr YTD %Bud
General Property Tax
$ 8,420,354
$ 52
0%
$ 8,332,634
$ 8,721,256
$ 7,707
0%
Licenses and Permits
367,705
182,157
50%
544,568
377,900
111,736
30%
Intergovernmental
766,150
190,093
25%
793,931
766,274
204,013
27%
Charges for Services
773,950
224,366
29%
787,042
746,700
170,072
23%
Fines
100,750
19,998
20%
75,287
90,250
19,282
21%
Investment Income
75,000
(4,811)
-6%
64,751
75,000
(6,871)
-9%
Miscellaneous
124,300
89,524
72%
179,789
129,300
66,086
51%
Transfers In
196,930
196,930
100%
196,930
178,558
178,558
100%
Total Revenues
$ 10,825,139
$ 898,309
8%
$ 10,974,932
$ 11,085,238
$ 750,583
7%
2017 1 2018
EXPENDTTURES Budget Apr YTD %Bud Final Budget Apr YTD %Bud
GENERAL GOVERNMENT
Mayor and Council
$ 89,991
$ 46,304
51% $
84,136
$ 91,298
$ 46,030
50%
Administration
199,541
62,376
31%
187,514
203,833
64,437
32%
Newsletter
26,000
8,827
34%
25,287
26,000
5,406
21%
Human Resources
27,913
9,327
33%
15,520
28,431
9,042
32%
Attorney
191,360
46,979
25%
188,644
191,360
47,084
25%
City Clerk
148,599
51,321
35%
147,450
155,608
51,742
33%
Elections
63,881
3,430
5%
17,852
59,781
10,956
18%
Finance
268,129
95,760
36%
258,883
278,660
95,795
34%
Assessing
150,000
145,367
97%
147,914
154,000
-
0%
Information Services
180,722
54,587
30%
149,513
180,597
52,271
29%
Planning & Zoning
462,212
122,816
27%
398,780
438,827
131,624
30%
Engineering
535,715
167,022
31%
511,183
553,765
171,179
31%
Facility Management
681,733
150,044
22%
509,547
678,519
141,389
21%
Total General Gov
3,025,796
964,160
32%
2,642,223
3,040,679
826,955
27%
PUBLIC SAFETY
Police Protection
2,962,551
740,638
25%
2,962,551
3,053,526
763,382
25%
Fire Protection
1,422,522
426,678
30%
1,353,209
1,423,914
382,558
27%
Protective Inspection
446,688
139,574
31%
443,712
462,164
135,949
29%
Civil Defense
24,847
5,786
23%
16,320
32,502
6,657
20%
Animal Control
5,950
542
9%
2,544
5,950
150
3%
Total Public Safety
4,862,558
1,313,218
27%
4,778,336
4,978,056
1,288,696
26%
PUBLIC WORKS
Streets and Highways
614,668
188,356
31%
597,964
659,943
185,378
28%
Snow and Ice Removal
547,777
229,585
42%
449,881
562,706
366,507
65%
Street Signs
215,244
62,842
29%
214,540
219,418
60,196
27%
Traffic Signals
37,000
7,031
19%
36,152
37,000
5,444
15%
Street Lighting
38,400
6,813
18%
27,735
40,400
8,213
20%
Street Lights - Billed
217,500
35,486
16%
144,451
220,500
35,516
16%
Park & Recreation
1,275,530
324,576
25%
1,207,359
1,318,395
304,550
23%
Natural Resource Preservation
12,697
485
0%
6,503
15,074
503
3%
Recycling
122,221
44,326
29%
169,956
157,216
43,484
28%
Total Public Works
3,081,037
899,500
29%
2,854,541
3,230,652
1,009,791
31%
OTHER
Miscellaneous
31,728
4,500
14%
764,875
31,828
1,615
5%
Youth Services
38,600
0%
-
38,600
8,500
22%
Total Other
70,328
4,500
6%
764,875
70,428
10,115
14%
Total Expenditures
S 11,039,719
$ 3,1819378
29%
$ 11,039,975
$ 11,319,815
$ 3,135,557
28%
NET INCREASE (DECREASE) S (214,580) S (2,283,069) $ (65,043) S (234,577) S (2,384,974)
1685 CROSSTOWN BOULEVARD N.W. • ANDOVER, MINNESOTA 55304 • (763) 755-5100
FAX (763) 755-8923 • WWW.ANDOVERMN.GOV
TO: Mayor and Councilmembers
FROM: Jim Dickinson, City Administrator
SUBJECT: April 2018 City Investment Reports
DATE: May 22, 2018
INTRODUCTION
Summary reporting of the City Investment portfolio to the Governing body is a recommended
financial practice and often viewed positively by rating agencies.
Furthermore, the City of Andover Investment Policy recommends the Finance Director presents
to the City Council at least quarterly the type of investments held by the City.
DISCUSSION
Attached is the Investment Maturities Summary for April 2018, the April 2018 Investment
Detail Report, and the April 2018 Money Market Funds Report. These attachments are
intended to provide a status report on the April 2018 investments.
ACTION REQUESTED
Informational, for Council review. Staff will provide a brief presentation and answer questions.
Imitted,
Investment Maturities - April 2018
Investment Maturities (in Years)
Credit
Fair
Less Than
More Than
Investment Type
Rating
Value
1
1- 5
6-10
10
Money market funds
N/A
$ 1,923,656
$ 1,923,656
$
$
$
MN Municipal Money
Market Fund (4M)
N/A
1,015,512
1,015,512
-
-
-
Premier Banks Money
Market Fund
N/A
275,816
275,816
-
-
-
Certificates of deposit
FDIC
12,127,420
6,852,486
5,274,934
-
-
Local governments
A/Al/A2
445,198
121,800
1 222,223
101,175
-
AA1/AA2/AA3
5,785,980
1,267,491
3,226,807
1 1,187,969
1 103,714
AAA
3,549,627
485,263
2,485,464
578,900,
-
-
-
-
State governments A/A1/A2 201,480 - 201,480
AAI/AA2/AA3 1,163,878 305,851 858,026
AAA
586,568
125,460
461,107
-
U.S. agencies
AAA
8,752,729
4,127,534
4,471,335
153,860
-
FNMA REMIC
N/A
333
333
-
-
-
U. S. agencies
N/A
746,525
746,525
-
-
-
Total investments
$ 36,574,721
$ 17,247;728
$ 17,201,376
$ 2,021,903
$ 103,714
Deposits
524,005
Total cash and investments
$ 37,098,726
April 2018 Investment Detail
Description
bCUSo
Number
Credit
Rating/F
DIC #
Type
Purchase Price
Carrying Cost
Maturity
Amount
Interest
Rate
Current Market
Value
Interest Paid
Date
Acquired
Coupon
Date
Maturity/
Due Date
Community Bk Chesapeake MD
20350ACU3
30903
CD
245,000.00
245,000.00
245,000.00
1.350%
244,982.85
maturity
08/18/17
none
05/11/18
Compass Bk Birmingham AL
20451PSG2
19048
CD
245,000.00
245,000.00
245,000.00
1.400%
244,987.75
maturity
08/11/17
none
05/11/18
PlainsCapital Bank
72663OC98
17491
CD
245,000.00
245,000.00
245,000.00
1.350%
244,904.45
maturity
06/21/17
none
06/21/18
Capital One Bank (USA)
140420ZQ6
33954
CD
245,000.00
245,000.00
245,000.00
0.900%
244,652.10
semi-annual
07/13/16
01/13/17
07/13/18
Key Bank National Association
49306SWQ5
17534
CD
245,000.00
245,000.00
245,000.00
0.850%
244,676.60
semi-annual
07/13/16
01113/17
1 07/13/18
Bank of China NY
06426WNJ7
33653
CD
245,000.00
245,000.00
245,000.00
1.500%
244,882.40
maturity
07/20/17
none
07/20/18
First National Bank of Omaha
332135HA3
5452
CD
245,000.00
245,000.00
245,000.00
1.450%
244,630.95
maturity
07/26/17
none
07/27/18
Israel Discount Bank of NY
465076J1.12
19977
CD
245,000.00
245,000.60
245,000.00
1.450%
244,784.40
maturity
08/09/17
none
08/09/18
Pacific Western Bank
69506YFT1
24045
CD
245,000.00
245,000.00
245,000.00
1.450%
244,784.40
maturity
08/09/17
none
08/09/18
BMO Harris Bk
05581 WST3
16571
CD
245,000.00
245,000.00
245,000.00
1.400%
244,710.90
maturity
10/20/17
none
08/20/18
Cathay Bank
149159LR4
18503
CD
245,000.00
245,000.00
245,000.00
1.500%
244,723.15
maturity
12/07/17
none
09/07/18
ZB NA
98878BLC0
2270
CD
245,000.00
245,000.00
245,000.00
1.500%
244,468.35
maturity
12/07/17
none
09/07/18
Beal Bk
07370W5B8
57833
CD
245,000.00
245,000.00
245,000.00
1.500%
244,703.55
maturity
12/13/17
none
09/12/18
BNY Mellon
05584CBA3
7946
CD
245,000.00
245,000.00
245,000.00
1.550%
244,747.65
maturity
12/12/17
none
09/12/18
Bank India New York _
06279H4M2
33648
CD
245,000.00
245,000.00
245,000.00
1.450%
244,483.05
maturity
10/19/17
none
10/17/18
CD F & M Bank
30246AFM5
9963
CD
245,000.00
245,000.00
245,000.00
1.350%
244,358.10
maturity
10/20/17
none
10/19/18
New York Community Bank
649447RD3
16022
CD
245,000.00
245,000.00
245,000.00
1.600%
244,637.40
maturity
12/22/17
none
10/22/18
Amex Centurion Bk
02587DU63
27471
CD
245,000.00
245,000.00
245.000.00
1.550%
244,519.80
maturity
maturity
maturity
08/03/17
12/16/17
12/16/17
02/08/18
none
none
11/08/18
12116/18
12/16/18
1 Year CD - Premier Bank
1091003210
21714
CD
245,000.00
245,000.00
245,000.00
1.500%
245,000.00
1 Year CD- Premier Bank Rochester
2055214401
33202
CD
245,000.00
245,000.00
245,000.00
1.500%
245,000.00
1 Year CD - Premier Bank MN _
BMW Bank of North America _
Safra National Bk
TCF National Bank
Beak Bank SSB
3041574901
05580ADR2
33204
CD
245,000.00
245,000.00
245,000.00
1.500%
245,000.00
maturity
12/16/17
none
12/16/18
01/22/19
02/27/19
02/28/19
04/10/19
35141
CD
245,000.00
245,000.00
245,000.00
1.600%
244,284.60
semi-annual
01/22/16
07/22/16
78658Q2Q5
26876
CD
245,000.00
245,000.00
245,000.00
1.950%
244,767.25
maturity
02/28118
none
872278X76
28330
CD
245,000.00
245,000.00
245,000.00
245,000.00
1.900%
244,661.90
maturity
02/28/18
none
07370XDZ4
32574
CD
245,000.00
245,000.00
2.00091.
244,710.90
maturity
04/11/18
none
Bank Hapoallm, BM of NY
06251AT42
33686
CD
245,000.00
245,000.00
245,000.00
2.100%
244,914.25
maturity
04/20/18
none
04/18/19
Bank Baroda New York
06062RC42
33681
CD
245,000.00
245,000.00
245,000.00
2.050%
244,777.05
maturity
04/23118
none
04/23/19
Berkshire Bk Pittsfield MA
084601NP4
23621
CD
245,000.00
245,000.00
245,000.00
1.950%
244,532.05
maturity
04/24/18
none
04/24/19
Oneida County NY
6824543R2
Al
local
22,877.60
22,877.60
20,000.00
6.250%
20,703.00
semi-annual
08/16/10
none
04/15/19
Junction City Kansas
481502F72
A2
local
101,558.00
101,558.00
100,000.00
5.500%
101,097.00
semi-annual
05/28/08
03101109
09/01/18
Farmington MN
311297W84
AA
local
102,787.00
102,787.00
100,000.00
2.000%
100,199.00
semi-annual
07/06/16
none
02/01/19
Rice Cnty MN
762698GK8
AA
local
45,466.80
45,466.80
40,000.00
4.400%
40,489.20
semi-annual
03/07/12
none
02/01/19
Racine Wl
7500216D4
AA-
local
101,792.00
101,792.00
100,000.00
2.100%
100,004.00
semi-annual
01/24/12
06101/12
06/01/18
Indiana St Bond Bank
454624540
AA+
local
146,123.60
146,123.60
140,000.00
4.302%
140,779.80
semi-annual
12/30/16
none
08/01/18
Ramsey MN
751813PB6
AA+
local
158,677.85
158,677.85
145,000.00
4.500%
145,234.90
semi-annual
02/16/12
04/01/16
04/01/19
New York City NY Transitional
64971 QTU7
AA1
local
100,440.00
100,440.00
100,000.00
1.600%
100,000.00
semi-annual
01/27/17
none
05/01/18
Scott County IA
809486FJ2
AAl
local
112,617.00
112,617.00
100,000.00
4.400%
100,141.00
semi-annual
10/31/12
12/01/12
06/01/18
Minneapolis MN
60374YS73
AA1
local
111,898.00
111,898.00
100,000.00
3.250%
100,580.00
semi-annual
06/05/12
12/01/11
12/01/18
Orange Beach ALA
68406PHF1
AA1
local
241,689.60
241,689.60
240,000.00
4.400%
243,115.20
semi-annual
08/05/10
02/01/11
02/01/19
Kane McHenry Cook & De Kalb Zero Cpn
484080MB9
AA3
local
157,328.00
157,328.00
200,000.00
196,948.00
maturity
07/16/12
none
12/01118
Brownsville TX ISD Zero Coupon
116421E46
AAA
local
229,640.00
229,640.00
250,000.00
248,155.00
maturity
06/26/13
none
08/15/18
King Cnty WA
49474E31.5
AAA
local
224,634.00
224,634.00
200,000.00
3.980%1
202,032.00
semi-annual
03/27/12
none
12/01/18
Description
Cusip
Number
Credit
Rating/F
DIC #
Type
Purchase Price
Carrying Cost
Maturity
Amount
Interest
Rate
Current Market
Value
Interest Paid
Date
Acquired
Coupon
Date
Maturity)
Due Date
Minnetonka MN ISD #276
604195RA7
AAA
local
37,433.20
37,433.20
35,000.00
3.100%
35,075.95
semi-annual
semi-annual
12/22/11
none
02/01/19
Washington State
939758DL9
AA
state
205,804.00
205,804.00
200,000.00
4.500%
200,990.00
01124/12
04/01/12
10/01/18
New Hampshire St Hsg
64469DWV9
AA2
state
105,625.80
105,625.80
105,000.00
1.939%
104,861.40
semi-annual
12/09/15
07/01/16
07/01/18
Georgia State
373384RQ1
AAA
state
26,742.50
26,742.50
25,000.00
2.970%
25,089.25
semi-annual
02/08/12
none
10/01/18
Texas State
882722J51
AAA
slate
103,089.00
103,089.00
100,000.00
2.894%
100,371.00
semi-annual
08/10/11
04/01/12
10/01/18
Fed Home Ln Bank
313379DT3
AAA
US
250,010.74
250,010.74
250,000.00
1.250%
249,872.50
semi-annual
07/07/17
12/08/12
06/08/18
Fed Farm Credit Bank
3133EHDQ3
AAA
US
200,042.00
200,042.00
200,000.00
1.180%
199,808.00
semi-annual
03/30/17
06/27/17
06/27/18
Fed Nag Mtg Assn
3135GOE33
AAA
US
249,677.50
249,677.50
250,000.00
1.125%
249,572.50
semi-annual
07/07/17
07/20/15
07/20/18
Fed Home Ln Mtg Corp Med Term Note
3134G3ZK9
AAA
US
200,000.00
200,000.00
200,000.00
1.200%
199,696.00
semi-annual
07/30/12
01/30/13
07/30/16
Fed Farm Credit Bank
31331Y4S6
AAA
US
114,000.00
114,000.00
100,000.00
5.050%
100,806.00
semi-annual
09/11/13
none
08/01/18
Fed Farm Credit Bank
3133EGK87
AAA
US
199,462.00
199,462.00
200,000.00
1.020%
199,246.00
semi-annual
03/30/17
none
09/24/18
Fed Home Ln Bank
3130ACR89
AAA
US
249,862.50
249,862.50
250,000.00
1.375%
249,140.00
semi-annual
11/03/17
05/02/18
11/02/18
Govt Nall Mtg Assn
3136GILUI
AAA
US
448,245.00
448,245.00
450,000.00
1.060%
447,606.00
semi-annual
08/21/17
none
11114/18
Fed Farm Credit Bank
3133EHQF3
AAA
US
249,870.00
249,870.00
250,000.00
1.350%
248,382.50
semi-annual
07/07/17
01/07/18
01/07/19
Fed Farm Credit Bank
3133EG3X1
AAA
US
199,711.60
199,711.60
200,000.00
1.250%
198,492.00
semi-annual
06/16/17
07/17/17
01/17/19
Fed Nat[Mtg Assn
3136GOY70
AAA
US
199,300.00
199,300.00
200,000.00
1.080%
197,942.00
semi-annual
10/30/12
01/30/13
01/30/19
Fed Farm Credit Bank
3133EC5NO
AAA
US
99,587.00
99,587.00
100.000.00
1.250%
99,114.00
semi-annual
01/07/13
03/04/13
03/04/19
Fed Farm Credit Bank
3133EDTU6
AAA
US
251,285.00
251,285.00
250,000.00
1.700%
248,950.00
semi-annual
07/07/17
03/04/15_
Fed Farm Credit Bank
3133EHLZ4
AAA
US
199,654.80
199,654.80
200,000.00
1.270%
198,418.00
semi-annual
semi-annual
semi-annual
semi-annual
semi-annual
06/16/17
07/07/17
06/22/17
12/14/17
09/06/17
09/08/12
none
10/15/16
_03/04/19
03/06/19
03/08/1 fl
03113/19
04/15/19
04/26/19
08/25/18
05/11/18
06/15/18
Fed Home Ln Bank
3133782M2
AAA
US
250,470.00
250,470.00
250,000.00
1.500%
248,392.50
Fed Nail Mtg Assn _
3136G1 FYO
AAA
US
200,000.00
200,000.00
200,000.00
1.375%
198,420.00
_ _
Fed Home Ln Mtg Corp _ _
Fed Nat Mtg Assn
Fed Nat] Mill Assn Remic
FICO Strip Cpn Zero Coupon
Fed Home Ln Mig Corp
3137EADZ9
AAA
US
297,417.00
297,417.00
300,000.00
1.125%
296,691.00
3135GOK28
AAA
US
299,700.00
299,700.00
340.20
300,000.00
333.23
1.250%
296,985.00
07/19/17
10/26/16
31393EAL3
US
us
204,187.50
529,947.00
4.500%
333.34
monthly
07/30/03
none
31771EAA9
529,947.00
550,000.00
549,670.00
maturity
06/09/14
none
31393VMQ1
US
153,656.25
66.83
65.24
4.500%
65.19
monthly
06/30/03
FICO Strip Cpnl3 Zero Coupon
31771 C2G9
US
93,140.00
93,140.00
100,000.00
98,442.00
maturity
12/29/14
none
12/27/18
FICO Strip Cpn Zero Coupon
31358BAA6
US
94,480.00
94,480.00
100,000.00
98,348.00
maturity
04/17/15
none
02/01/19
14,032,744.08
Customers Bank
23204HFAI
34444
CD
245,000.00
245,000.00
245,000.00
2.000%
244,541.85
semi-annual
02/21/18
08/21118
05121119
Banner Bank
06652XFP5
28489
CO
245,000.00
245,000.00
245,000.00
1.850%
244,274.80
semi-annual
02/23/18
08/23/18
05/23/19
First Foundation Bk
32026UFSO
58647
CD
245,000.00
245,000.00
245,000.00
2.000%
244,512.45
semi-annual
02/28/18
08/28/18
05/28/19
Ally Bank Midvale Utah
02006LF32
57803
CD
245,000.00
245,000.00
245,000.00
1.200%
242,040.40
semi-annual
06/30/16
12/30/16
07/01/19
Barclays Bank
067401KHB6
57203
CD
247,000.00
247,000.00
247,000.00
2.050%
246,338.04
semi-annual
07/03/14
01/02/15
07/02/19
Synchrony Bank
87164WBT4
27314
CD
247,000.00
247,000.00
247,000.00
2.050%
246,263.94
semi-annual
07/11/14
01/11115
07/11/19
JP Morgan Chase Bank NA
48125Y51_4
628
CD
245,000.00
245,000.00
245,000.00
1.100%
241,768.45
quarterly
07/15/16
10115/16
07/15/19
PrivateBank B Trust Co
74267GUQB
33306
CD
247,000.00
247,000.00
247,000.00
2.000%
246,204.66
semi-annual
07/21/14
01/21/15
07/22/19
Goldman Sachs Bank USA
38147JU59
795450895
33124
56177
CD
247,000.00
247,000.00
247,000.00
2.050%
246,081.16
semi-annual
07/23/14
01/23/15
07/23/19
Sallie Mae Bank
CD
245,000.00
245,000.00
245,000.00
1.700%
243,221.30
semi-annual
08/09/17
02/09/18
08/09/19
First Feder at Svgs Bk
32021YCH4
29690
CD
249,000.00
249,000.00
249,000.00
1.500%
248,093.64
monthly
01/21/16
02/21116
08/21/19
Victory Bank
92644LA88
58615
CD
247,000.00
247,000.00
247,000.00
2.000%
245,829.22
semi-annual
09/24/14
03/24115
09/24/19
CommerceWest Bank NIA
20084TKXO
57176
CD
245,000.00
245,000.00
245,000.00
2.300%
244,742.75
semi-annual
04/25/18
10/25/18
10125/19
1,874,554.05 local
431,311.65 state
4,874,392.53 US
Less Than 1 Year
Description
umbCuso
Number
Credit
RatinglF
DIC#
Type
Purchase Price
Carrying Cost
Maturity
Amount
Interest
Rate
Current Market
Value
Interest Paid
Date
Acquired
Coupon
Date
Maturity /
Due Date
Umpqua Bk Roseburg Ore
90421MBZ5
17266
CD
245,000.00
245,000.00
245,000.00
2.350%
244,909.35
semi-annual
semi-annual
04/27/18
10/27/18
10/28/19
Third Federal Sav & Loan
88413QAW8
30012
CD
128,000.00
128,000.00
128,000.00
2.000%
127,372.80
11/24/14
05/24/15
11125119
Celtic Bank
15118RJMO
57056
CD
247,000.00
247,000.00
247,000.00
2,050%
246,204.66
semi-annual
12/20/13
06/20/14
12/20119
Steams Bank NA
857894PB9
10988
CD
247,000.00
247,000.00
247,000.00
1.000%
245,609.39
semi-annual
12/26114
06/26/15
12/26/19
Jefferson Bk&Tr Co
472376AD4
1071
CD
245,000.00
245,000.00
245,000.00
1 2.450%
244,412.00
semi-annual
04/11/18
10111/18
04/10/20
CitiBankNA
17312QJ34
7213
CD
245,000.00
245,000.00
245,000.00
2.550%
244,862.80
semi-annual
04/11118
10/11/18
04/13/20
Discover Bk Greenwood Del
254673NR3
5649
CD
245,000.00
245,000.00
245,000.00
2.500%
244,630.05
semi-annual
04/11118
10/11/18
04/13/20
Citizens Alliance Bank
17318LAP9
1402
CD
249,000.00
249,000.00
249,000.00
2.000%
246,980.61
monthly
06/27114
07/27/14
06/26/20
Enerbank USA
29266NA31
57293
CD
249,000.00
249,000.00
249,000.00
2.100%
246,039.39
monthly
07/18/14
08/18/14
07/20/20
Elbow Lake MN
284281 KC5
A
local
170,045.70
170,045.70
165,000.00
2.750%
163,696.50
semi-annual
12/08/14
none
12/01/19
Kaufman TX
486206KR5
A3
local
61,821.00
61,821.00
60,000.00
3.000%
58,526.40
semi-annual
06/28/16
02/15/17
02/15/23
Rothsay MN ISD #850
778731AZ2
AA+
local
208,640.25
208,640.25
195,000.00
3.000%
198,632.85
semi-annual
07/06/16
none
02/01/20
Saint Paul MN Port Auth
793067CC1
AA+
local
79,756.80
79,756.80
80,000.00
2.000%
78,471.20
semi-annual
01110/17
09/01/17
03/01/20
Steams Cc MN
857896MH4
AA+
local
276,875.00
276,875.00
250,000.00
4.500%
250,387.50
semi-annual
04117/13
none
06/01/20
Greenway MN ISD #31
39678LDF6
AA+
local
27,593.50
27,593.50
25,000.00
5.000%
25,368.25
semi-annual
07109/13
none
03/15/21
Cedar Rapids IA
150528RM1
AA1
local
217,672.00
217,672.00
200,000.00
3.000%
201,202.00
semi-annual
06/11/13
12/01/13
06/01/19
Multnomah Cnty OR Sch Dist 1J
625517JMO
AA1
local
250,000.00
250,000.00
250,000.00
1.450%
247,515.00
semi-annual
08/10/17
12/15/17
06/15/19
Minneapolis MN
60374YS81
AA1
local
278,632.50
278,632.50
250,000.00
3.500%
253,357.50
semi-annual
02/26/13
none
12/01/19
Hampton VA
4095582,11
AA1
local
100,836.00
100,836.00
100,000.00
2.209%
99,094.00
semi-annual
semi-annual
semi-annual
semi-annual
semi-annual
01/20/16
02124/15
11/10114
10/31/11
12/22/16
none
none
12/01/14
none
none
04/01/20
09/01/20
06/01/21
03/01/23
06/01/19
Middleton WI
596782RX2
AA1
local
106,979.00
106,979.00
100,000.00
3.750%
100,416.00
Des Moines IA Area Cmnty Col
2500971-121
AA1
local
50,606.00
50,606.00
50,000.00
2.450%
49,202.50
Minneapolis MN _
Sioux City IA
Waterloo IA
Western Lake Superior MN
Portsmouth VA
60374YG68
AA1
AA2
AA2 _
local
110,419.00
110,419.00
100,000.00
4.700%
101,575.00
829458FC7
941647PAl
local
local
156,100.50
50,559.50
156,100.50
155,000.00
50,000.00
2.000%
2.000%
154,256.00
50,559.50
49,728.50
semi-annual
06127/13
12/01/13
06/01/19
958522WU4
73723RSL8
AA2
AA2
local
100,000.00
100,000.00
100,000.00
3.150%
100,819.00
semi-annual
08/16/11
04/01/12
10/01/19
local
286,268.00
286,268.00
295,000.00
2.400%
294,471.95
semi-annual
07/17/13
02/01/14
02/01/20
Brunswick Cnty
117061VH1
AA2
local
108,967.10
108,967.10
110,000.00
1.740%
106,973.90
semi-annual
08/21/15
none
05/01/20
Fon Du Lac Cnty WI
344442KK3
AA2
local
259,715.00
259,715.00
250,000.00
3.250%
251,282.50
semi-annual
03/10117
none
03/01/21
Alexandria MN ISD#206
015131LQ6
AA2
local
279,760.50
279,760.50
270,000.00
3.000%
267,291.90
semi-annual
01/21/15
none
02/01/23
Moorhead MN
6161412R7
AA3
local
108,820.00
108,820.00
100,000.00
3.800%
101,752.00
semi-annual
11/14/11
none
02/01/20
Whitewater Wis
966204KA6
AA3
local
109,541.00
109,541.00
100,000.00
4.850%
105,016.00
semi-annual
06/09/11
none
12/01/20
West Bend WI
9514288NO
AA3
local
97,805.00
97,805.00
100,000.00
1.900%
95,846.00
semi-annual
01/11118
none
04/01/22
W Palm Beach FL
955116BE7
AA3
local
101,245.00
101,245.00
100,000.00
2.264%
94,147.00
semi-annual
07/05/16
10/01/16
10/01/22
Palm Beach Cnty FLA
696497TR7
AAA
local
174,889.50
174,889.50
150,000.00
5.898%
151,833.00
semi-annual
07/06/11
none
06/01/19
Tenn Val Auth Cpn Strip Zero Cpn
88059EWZ3
AAA
local
262,890.00
262,890.00
300,000.00
291,051.00
maturity
12/27/13
none
06/15/19
Norwalk Conn
668844DS9
AAA
local
122,464.80
122,464.80
120,000.00
4.050%
120,454.80
semi-annual
08/04/10
08101/11
08/01/19
Greensboro NC
39546OV21
AAA
local
366,832.80
366,832.80
360,000.00
3.263%
363,960.00
semi-annual
07/15/11
none
10/01/19
Saint Paul MN Port Auth
793028WS6
AAA
local
201,806.00
201,806.00
200,000.00
2.000%
197,440.00
semi-annual
12/22/16
08/01/17
02/01/20
Woodbury MN
97913PCQ7
AAA
local
123,037.35
123,037.35
115,000.00
3.250%
115,552.00
semi-annual
12/22/11
none
02101/20
Dallas TX Indpt Sch Dist
235308QK2
AAA
local
116,900.00
116,900.00
100,000.00
4.450%
103,307.00
semi-annual
04/16/12
08/15/11
02/15120
Tenn Valley Auth Zero Cpn
88059EHD9
AAA
local
263,970.00
263,970.00
300,000.00
283,695.00
maturity
03/11/13
none
05/01/20
Tenn Val Auth Cpn Ship Zero Cpn
88059EMX9
AAA
local
88,133.00
88,133.00
100,000.00
93,682.00
maturity
03/18/13
none
07/15/20
McAllen TX Dev Corp
579086AW9
AAA
local
175,000.00
175,000.00
175,000.00
1.400%
169,118.25
semi-annual
07/26/16
02/15/17
08/15/20
5,274,933.71 CD
Description
Cusip
Number
Credit
Rating/F
DIC #
Type
Purchase Price
Carrying Cost
Maturity
Amount
Interest
Rate
Current Market
Value
Interest Paid
Date
Acquired
Coupon
Date
Maturity)
Due Date
Indianapolis Ind
Baltimore Cnty MD
45528UGF2
AAA
AAA
local
251,507.50
251,507.50
250,000.00
2.219%
245,185.00
48,457.50
semi-annual
semi-annual
07/11/17
08/31/16
07/15113
01/15/21
08/01/21
05914FME7
local
51,290.00
51,290.00
50,000.00
2.097°k
none
_
New York St Mtge A_gy
64988RHGO
AAA
local
100,000.00
100,000.00
100,000.00
2.375%
97,054.00
semi-annual
10/27/15
04/01116
10101/21
Columbus OH
199492CS6
AAA
local
39,956.40
39,956.40
40,000.00
2.133%
38,984.40
semi-annual
02/20/15
none
12/01121
Outagamie Cnty WI _
Connecticut State
Massachusetts Stale
689900898
AAA
local
170,000.00
170,000.00
214,954.00
170,000.00
2.350%
165,489.90
semi-annual
11/07/17
05/01/18
11/01122
20772JON5
Al
state
214,954.00
200,000.00
3.517%
201,480.00
semi-annual
semi-annual
05/27/16
12/17/14
02/15/14
08/15121
57582P2T6
AA1
AA2
state
199.744.00
199,744.00
200,000.00
2.090%
197,328.00
11/01/14
05/01/20
Colorado St Hsg & Fin Auth
196479A82
state
84,864.00
84,864.00
85,000.00
1.875%
84,182.30
semi-annual
01126118
none
05/01/19
Florida St Hurricane
34074GDH4
AA3
state
279,439.80
279,439.80
270,000.00
2.995%
270,918.00
semi-annual
11110115
07/01/13
07/01/20
Minnesota St Colleges & Univ
60414FPJ3
AA3
state
100,000.00
100,000.00
100,000.00
2.000%
98,080.00
semi-annual
02126/15
10101115
10/01/20
Florida St Dept Environmental
34160WUAO
AA3
state
217,800.00
217,800.00
200,000.00
6.206%
207,518.00
semi-annual
08/30/10
07/01/10
07/01/22
Tennessee State
880541003
AAA
slate
48,218.85
48,218.85
45,000.00
3.178%
45,529.65
semi-annual
08/30/16
02/01/12
08/01/20
Virginia State
928101
AAA
state
22,126.00
22,126.00
20,000.00
4.100%
20,341.80
semi-annual
02/07/12
none
06/01/21
Kentucky St Hsg Corp
49130TSHO
AAA
state
203,458.00
203,458.00
200,000.00
2.780%
197,428.00
semi-annual
03/29/17
none
07101121
Georgia State
373384208
_ _
AAA
state
204,444.00
204,444.00
200,000.00
2.780%
197,808.00
semi-annual
12/13/16
none
02/01123
Fed Home Ln Mtg Corp
Fed Home Ln Mig Corp Mad Term Note
3137FADK2
_
AAA
US
249,035.00
249.035.00
200,000.00
250,000.00
1.250%
246,507.50
semi-annual_
07/07/17
02/01/13
08101119
08/23119
3134G96U6
_
AAA
US
200,000.00
200,000.00
1.050%
196,510.00
quarterly
08/23/16
11/23/16
Fed Home Ln Bank
313383VN8
3133EGVJ1
AAA
US
301,065.00
301,065.00
300,000.00
2.000%
298,302.00
semi-annual
semi-annual
semi-annual
semi-annual
maturity
semi-annual
12107/17
12/08/17
01104118
04/10/18
07/22/15
02/09/18
none
none
04/11118
10111/16
none
09113119
09/26/19
10111/19
10111119
10/15/19
10128/19
11125/19
11129/19
12/16/19
01109/20
_
Fed Farm Credit Bank
Fed Farm Credit Bank_
US
297,300.00
297,300.00
248,227.50
294,603.00
300,000.00
1.160%
1.550%
1.125%
1.350%
1.300%
1.330%
294,432.00
246,867.50
294,294.00
192,434.00
98,381.00
196,292.00
960,050.00
220,896.00
3130ACLS1
_AAA
AAA
US
248,227.50
294,603.00
250,000.00
Fed Home Ln Bank
RFCSP Strip Principal Zero Coupon
Fed Nag Mtg Assn
Fed Farm Credit Bank
Fed Home Ln Mtg Corp Zero Cpn _
Fed Farm Credit Bank
Fed Home Ln Bank
313OA8NRO
_
AAA_
AAA
AAA
AAA
AAA _
AAA
AAA
US
300,000.00
76116FAA5
3135GOJ95
3133EGBKO
31340OBV4
3133EGFR1
US
185,568.00
185,568.00
98,570.00
199,600.00
950,527.00
223,031.25
200,000.00
_
US
98,570.00
199,600.00
100,000.00
200,000.00
1,000,000.00
225,000.00
10128/16
_
US
semi-annual
05/25/16
11125/16
US
950,527.00
223,031.25
maturity
semiannual
11/02/15
none
US
11/03/17
none
313381ND3
US
147,300.00
147,300.00
150,000.00
1.450%
147,324.00
semi-annual
03123/18
none
Fed Home Ln Mtg Corp
3137EAEE5
AAA
US
297,912.00
297,912.00
300,000.00
1.500%
295,077.00
semi-annual
12107117
07/17/17
01/17/26
Fed Home Ln Bank
3130A3XL3
AAA
US
99,500.00
99,500.00
100,000.00
1.500%
98,241.00
semi-annual
semi-annual
07/22/15
08/10115
02110/20
10127/20
Fed Home Ln Mtg Corp Med Term Note
3134GBS78
AAA
US
200,000.00
200,000.00
200,000.00
1.500%
197,172.00
10/27/17
04/27118
Fed Home Ln Mtg Corp
3137EAEK1
AAA
US
299,193.00
299,193.00
300,000.00
1.875%
294,207.00
semi-annual
12/07/17
05/17/18
11/17/20
Fed Nag Mtg Assn
3136G4JM6
AAA
US
200,000.00
200,000.00
200,000.00
1.850%
194,348.00
semi-annual
12/28/16
06/28/17
12128/20
17,201,375.76
Itasca County Minn_
Chaska MN
5.550%
101,175.00
02/01/28
02101/24
465452GP9
1616636S3
A
AA
local
105,024.00
105,024.00
100,000.00
semi-annual
07112111
none
local
94,191.30
94,191.30
90,000.00
4.000%
91,428.30
semi-annual
09108114
none
Mitchell SD Sch Dist #17-2
606687EHO_
AA
local
116,702.00
116,702.00
100,000.00
6.000%
103,731.00
semi-annual
12120111
06/15/19
06/15/24
_
Lake City Minn ISD #813
508084DW7
_ _
local
103,933.00
103,933.00
100,000.00
5.000%
102,357.00
semi-annual
05/11111
none
02101/25
_
Milaca Minn ISD #912
598699NT9
_AA+
AA+
local
106,941.00
106,941.00
100,000.00
5.650%
101,792.00
semi-annual
07/22/11
none
02/01/27
03/01/24
_ _ _ _
Minneapolis MN
60374YG76
_
AAi
local
72,201.35
72,201.35
65,000.00
4.800%
66,055.60
semi-annual
12/09/14
none
Ann Arbor Ml
035438CF5
AAi
local
262,025.00
262,025.00
250,000.00
5.750%
256,932.50
semi-annual
12/27117
05/01/19
05/01/27
Duluth MN
264438ZL9
AA2
local
29,767.20
29,767.20
30,000.00
2.625%1
28,585.20
semi-annual
12/05/12
08/01/13
02101/25
Will County IL Call Zero Coupon
969078OM9
AA2
local
159,000.00
159,000.00
500,000.00
335,690.00
maturity
08/25/09
none
11101/27
5,934,493.30 local
1,520,613.75 state
',.171,335.00 US
5 Years
Description
Cusip
Number
Credit
RatinglF
DIC #
Type
Purchase Price
Carrying Cost
Maturity
Amount
Interest
Rate
Current Market
Value
Interestuired
ate
Coupon
Date
Maturity)
Due Date
Hawkins Cnty TN
420218PL7
AA3
local
111,480.00
111,480.00
198,018.00
100,000.00
4.800%
101,397.00
semi-an13/12
semi-an17/10
none
05101/24
Savage Minn
80465PAN4
AAA
local
198,018.00
200,000.00
4.800%
204,502.00
02/01111
02101/24
Tennessee Valley Auth Ser E
880591CJ9
_ AAA
local
121,500.00
121,500.00
100,000.00
8.750%
124,398.00
semi-an19/09
none
11/01/25
Ice Deposit- National Spods Center
Fad Home Ln Bank
none
local
250,000.00
250,000.00
250,000.00
250,000.00
matu/06/08
In
none
01/01/26
3130A8W33
AAA
US
39,000.00
39,000.00
40,000.00
2.100%
36,940.80
semi-an/27/17
08/22/17
08/22/25
Fed Farts Credit Bank
31331VLC8
AAA
US
106,030.45
106,030.45
100,000.00
5.250%
116,919.00
2,021,903.40Van
semi-an26/10
none
04121/28
Buren Mich Public Schools
920729HD5
AA1
local
102,750.00
102,750.00
100,000.00
6.430%
103,714.00
semi-a/17/09
11/01/09
05/01/29
103,714.00
33,359,737.24
1,868,043.60 local
153,859.80 US
6 -10 Years
103,714.00 local
10+ Years
INVESTMENT SCHEDULE - Money Market Funds
April 30, 2018
Description
Current Market
Value
YTD Interest
Wells Fargo
z Wells Fargo Government Money Market Fund
1 1,923,656.42
9,871.89
4M
z 14M 1
1,008,547.751
3,949.92
4M PLUS
z 4M Plus
6,964.001
29.96
Premier Bank
1 I Premier Bank Money Market 1
-275,816.051
226.58
Grand Total Money Market Funds 1 $3,214,984.22 1 $14,078.35
Updated: 51912018