HomeMy WebLinkAbout5F 2nd Quarter 2015 Investment Report i PR-10%
u 4646 Dakota Street SE
Prior Lake,MN 55372
40MvEso'sP
CITY COUNCIL AGENDA REPORT
MEETING DATE: AUGUST 10, 2015
AGENDA#: 5F
PREPARED BY: CATHERINE ASMUS, ACCOUNTANT
PRESENTED BY: CATHY ERICKSON, ACCOUNTING MANAGER
AGENDA ITEM: CONSIDER APPROVAL OF 2nd QUARTER 2015 INVESTMENT REPORT
DISCUSSION: Introduction
The purpose of this agenda item is for the Council to consider approval of the in-
vestment report for the second quarter of 2015.
Current Circumstances
Staff has prepared a list of investments as of June 30, 2015. The Investment Re-
port Summary Narrative provides some supplementary information with respect to
the investments currently held and the allowable forms of investments permitted
by Minnesota Statute.
The investment software provides the ability to generate reports and charts by bro-
ker, security type, maturities, etc. The software also enables staff to track interest
earned on an accrual basis versus a cash basis as well as changes in market
value.
If Council members have questions please feel free to contact me at 952-447-
9842 for more information.
Conclusion
The City Council should approve the quarterly investment report.
ALTERNATIVES: 1. A motion as part of the consent agenda to approve the 2015 2nd Quarter In-
vestment Report as submitted.
2. Take no action and provide the staff with specific direction.
RECOMMENDED Alternative 1.
MOTION:
INVESTMENT REPORT SUMMARY NARRATIVE
The attached "Investment Portfolio - Detail, by Broker" identifies the various types of investments and
the brokers/banks the City of Prior Lake uses for investment purposes.
As of June 30, 2015, the balance of the investment portfolio is $33,768,314. This is an increase of
$9.9M from March 31, 2015, primarily due to the receipt of$5.79M for the first half tax settlement and
the 2015A and 2015B bond funds. Included in the tax settlement is current and delinquent property
taxes, special assessments, and tax increment revenue.
The 'weighted average yield to maturity at cost' of the investment portfolio is currently 1.43% which is
a decrease from 2.09% as of March 31. The yield will fluctuate due in part to the balances that are in
the short term money market accounts and the very low rate that is paid on money market funds. At
the end of June the balance in the 4M money market was $13.37M. This includes the first half tax
settlement and the 2015A and 2015B bond funds which will be reinvested.
It continues to be challenging to find competitive rates for short-term investments---30 to 120-day ma-
turities. These short-term securities are necessary to meet cash flow needs for payments to vendors
(including construction contracts) and payroll. Current short-term rates being offered by financial insti-
tutions continue to be very low. The following table shows the current money market rate for the 4M
Fund and treasury rates:
4M
Fund
(4MP) 1 mo 3 mo 6 mo 1 yr 2 yr 3 yr 5 yr 7 yr 10 yr
Current Rates
(7/7/15) 0.05 0.02 0.02 0.08 0.25 0.58 0.96 1.55 1.98 2.27
During the second quarter of 2015, the short-term rates have decreased slightly up to 3 basis points.
Mid-term rates (one- to three-year maturities) have increased up to 12 basis points. Longer term rates
(five- to ten-year maturities) have increased from 26 to 41 basis points. The following table illustrates
the changes that have occurred in the treasury rates and the 4M Fund account during the past twenty-
four months:
4M
Fund
(4MP) 1 mo 3 mo 6 mo 1 yr 2 yr 3 yr 5 yr 7 yr 10 yr
Change from
3 mos ago - (0.03) (0.02) (0.03) 0.02 0.08 0.12 0.26 0.36 0.41
Change from
6 mos ago - (0.01) (0.03) (0.01) 0.03 (0.03) (0.09) (0.02) 0.10 0.18
Change from
1 yr ago - - (0.03) 0.01 0.17 0.17 0.13 0.01 (0.06) (0.18)
Change from
2 yrs ago - - (0.03) 0.01 0.13 0.28 0.35 0.22 0.11 (0.17)
As rates decrease, the market value of the existing securities will increase. As of December 31, 2014,
the market exceeded the cost value of the investments by$22k. As of June 30, 2015, the market value
of the portfolio has increased and is greater than the cost of the investments by $122k. The increase
in the fair value of the securities is adjusted against interest earnings in each of the funds. This is a
paper gain for 2nd quarter 2015; no actual gain is realized because the City holds the securities until
maturity.
Investments for local governments are restricted to only those permitted by Minnesota Statutes. They
are identified as follows:
1. U.S. Treasury Bills and Notes which are direct obligations of the federal gov-
ernment.
2. U.S. Government Securities which are guaranteed or insured by the federal
government i.e., FHLB, FNMA, FHLMC agencies.
3. State and Local Government bonds that are rated "A" or better.
4. Bankers' Acceptances of a United States Bank.
5. Commercial Paper that is rated "Al+P1" and matures in 270 days or less.
6. Repurchase Agreements with banks having capitalization exceeding
$10,000,000.
7. Time deposits that are fully insured by the Federal Deposit Insurance Corpora-
tion or bankers acceptances of United States banks.
Also allowable, but of higher risk, are guaranteed investment contracts (GIC's) and mortgage-backed
securities (CMO's) which because of their sophisticated nature and inherent risk, Prior Lake does not
participate in.
In addition to the "Investment Portfolio— Detail, by Broker" report, charts and tables showing the diver-
sification by Broker and Security Type have been included for your reference.
The City's investment portfolio amount is a pool of funds identified on the monthly Treasurer's Report.
Because City funds are pooled for investment purposes, interest is allocated to each fund on a monthly
basis, and is based upon each individual fund's proportionate share of the total amount. Overall, the
total investment pool does not represent excess reserves but rather available financial resources. In
most instances these funds were established and restricted for specific and designated purposes by
either Minnesota Statutes or City Code to accomplish the goals and objectives of the City of Prior Lake.
The constraints for each of the funds are noted on the Treasurer's Report.
CITY OF PRIOR LAKE, MINNESOTA of gR'a,N
Investment Portfolio - Diversification, by Broker (Portfolio)
June 30, 2015 `n�
Portfolio Holdings Distribution by Portfolio Name
Northland Securities
_-- '_ _ 19.17%
Morgan Stanley-Smith Barney____.-----__ _ _Wells Fargo Advisors
30.95% 13.16%
2015A Bond Fund
11.60%
League of Minnesota Cities 20156 Bond Fund
19.78% _ —1___— 5.35%
YTM @ " Days to %of
Description Cost . Cost Value Maturity Portfolio
League of Minnesota Cities 0.050 6,677,967 1 19.78%
2015A Bond Fund 0.063 3,917,314 20 11.60%
20158 Bond Fund 0.091 1,808,006 63 5.35%
Morgan Stanley-Smith Barney 2.085 10,450,004 1,883 30.95%
Northland Securities 3.136 6,472,523 1,729 19.17%
Wells Fargo Advisors 1.246 4,442,500 1,302 13.16%
Total/Average 1.432 33,768,314 1,091 100.00%
City of Prior Lake-Quarterly Investment Report
CITY OF PRIOR LAKE, MINNESOTA04 p�8,p
Investment Portfolio - Diversification, by Security Type
June 30, 2015
Portfolio Holdings Distribution by Security Type
Local Government Investment Pool
33.18%
tc ..-----------
FNMA Bond FHLMC Bond -- Municipal Bond
10.22% _-------- -L13%
FHLB Bond Cash
17.28% _ ._..6.41%
Corporate Bond _ _ Certificate Of Deposit
3.55% _ _.___.-- _19.75%
YTM @- Days to %of
Description Cost Cost Value Maturity Portfolio
Cash - 2,165,527 1 6.41%
Certificate of Deposit 1.970 6,668,000 1,372 19.75%
Term Series 0.154 1,200,000 158 3.55%
FHLB Bond 2.357 5,834,375 2,782 17.28%
FHLMC Bond 2.011 3,452,125 1,989 10.22%
FNMA Bond 2.500 500,000 2,827 1.48%
LGIP 0.050 11,203,286 1 33.18%
Municipal Bond 4.569 2,745,000 1,092 8.13%
Total/Average 1.432 33,768,314 1,091 100.00%
City of Prior Lake-Quarterly Investment Report
CITY OF PRIOR LAKE, MINNESOTA itrr
f a,oInvestment Portfolio-Detail,by Brokera,S,
June 30,2015 U
Avg.YTM Purchase Maturity
Broker/Institution Investment/Description Cost Rate Date Date
League of Minnesota Cities
Liquid Asset Fund 6,677,967 0.05%
2015A Bond Fund 3,917,314 0.06% 11/30/2015
2015B Bond Fund 1,808,006 0.09% 11/30/2015
Morgan Stanley-Smith Barney
1st Federal Bank-Harrison AR 1.05 8/20/2018 245,000.00 1.05% 2/19/2013 8/20/2018
1st Natl Bk Sioux Falls SD Step 10/30/2020-15 245,000.00 2.33% 10/30/2014 10/30/2020
Ally Bank-UT 1.75 8/24/2016 96,000.00 1.75% 8/24/2011 8/24/2016
ALLY BK,UT 1.15 9/19/2016 150,000.00 1.15% 9/18/2013 9/19/2016
American Exp BK FSB,UT 1.95 7/17/2019 245,000.00 1.95% 7/17/2014 7/17/2019
Amex Centurion,Salt Lake City UT 2.2 12/11/2019 245,000.00 2.20% 12/11/2014 12/11/2019
Bank Baroda NY,NY 112/13/2016 245,000.00 1.00% 12/13/2013 12/13/2016
Barclays Bank-DE 1.9 1/19/2017 245,000.00 1.90% 1/19/2012 1/19/2017
BMW Bank NA,Utah 2.112/11/2018 245,000.00 2.10% 12/11/2013 12/11/2018
CIT Bank-UT 1.45 8/24/2015 150,000.00 1.45% 8/24/2011 8/24/2015
CIT Bank SLC 1.8 3/13/2020-13 96,000.00 1.80% 3/13/2013 3/13/2020
COMENITY BK SALT LAKE CITY UT 2.6 11/24/2021 245,000.00 2.60% 11/26/2014 11/24/2021
Compass Bank,AL 2 8/28/2018-14 245,000.00 2.00% 8/28/2013 8/28/2018
Discover Bank Greenwood DE 212/11/2018 245,000.00 2.00% 12/11/2013 12/11/2018
Enerbank USA,UT 2.25 8/28/2020 245,000.00 2.25% 8/28/2014 8/28/2020
FHLB 1.5 12/19/2022-13 1,000,000.00 1.50% 12/19/2012 12/19/2022
FHLB Step 11/9/2022-13 300,000.00 2.20% 11/9/2012 11/9/2022
FHLB Step 2/27/2023-13 450,000.00 2.54% 2/27/2013 2/27/2023
FHLB Step 3/27/2023-13 1,420,000.00 2.57% 3/27/2013 3/27/2023
FHLB Step 6/26/2024-15 525,000.00 3.25% 6/26/2014 6/26/2024
FIRSTBANK CD SANTURCE PR 1.15 10/26/2016 245,000.00 1.15% 10/26/2012 10/26/2016
GE CAP BK INC RETAIL 1.8 7/13/2017 96,000.00 1.80% 7/13/2012 7/13/2017
GE Cap Bk Inc Retail 2.55 7/19/2021 150,000.00 2.55% 7/18/2014 7/19/2021
GE Cap Ret BK,Draper UT 2.653/29/2021 96,000.00 2.65% 3/28/2014 3/29/2021
GE CAPITAL,UT 2.69/21/2020 150,000.00 2.60% 9/20/2013 9/21/2020
Goldman Sachs Bank USA-NY 1.65 2/28/2017 96,000.00 1.65% 2/29/2012 2/28/2017
Goldman Sachs Bank USA-NY 1.85 8/24/2016 150,000.00 1.85% 8/24/2011 8/24/2016
HSBC Bank USA NA Step 12/18/2019-17 245,000.00 2.02% 6/19/2014 12/18/2019
JPMorgan Chase Bk Step 2/19/2021-15 245,000.00 2.45% 2/19/2015 2/19/2021
Medallion Bk Utah 1.45 6/29/2018 248,000.00 1.45% 6/30/2014 6/29/2018
Mercantil Commerce Bank,FL 1.9 8/29/2018 245,000.00 1.90% 8/29/2013 8/29/2018
Morgan Stanley Cash 87,003.71 0.00% 12/31/2010 N/A
NBT Bank,NY 2.18/27/2019 245,000.00 2.10% 8/27/2014 8/27/2019
SALLIE MAE BK CD Murray UT 1.5 10/24/2017 245,000.00 1.50% 10/24/2012 10/24/2017
STATE BK INDIA NEW YORK NY 2.6 12/6/2021 245,000.00 2.60% 12/5/2014 12/6/2021
Toyota Finl Svgs Henderson,NV 2 2/20/2020-15 110,000.00 2.00% 2/20/2015 2/20/2020
Webster 5 Cnts CD,Webster,MA 2.25 2/28/2022-16 245,000.00 2.25% 2/27/2015 2/28/2022
Wells Fargo Bank,SD Step 3/29/2021-17 225,000.00 3.02% 3/28/2014 3/29/2021
World Financial Jumbo 1.85/31/2017 200,000.00 1.80% 5/31/2012 5/31/2017
Subtotal 10,450,004
Northland Securities
Aurora ISD-MN 4.65 2/1/2018-17 500,000.00 4.65% 2/12/2009 2/1/2018
Cash-Northland Securities Cash 32,523.20 0.00% 6/30/2012 N/A
FHLB 2.09 11/9/2021-12 545,000.00 2.09% 8/9/2012 11/9/2021
FHLB 2.19 12/19/2022-13 345,000.00 2.19% 12/20/2012 12/19/2022
FHLMC 211/30/2020-14 1,790,000.00 2.00% 5/30/2012 11/30/2020
FHLMC 212/18/2020-13 515,000.00 2.00% 6/18/2012 12/18/2020
FNMA 2.5 3/27/2023-13 500,000.00 2.50% 3/27/2013 3/27/2023
Robbinsdale ISD-MN 4.62/1/2019 1,000,000.00 4.60% 5/14/2009 2/1/2019
Saint Francis!SD-MN 4.44/1/2017 500,000.00 4.40% 4/16/2009 4/1/2017
Stillwater ISD-MN 4.753/1/2018-16 500,000.00 4.75% 2/17/2009 3/1/2018
Washington County Housing 4.25 1/1/2020-10 245,000.00 4.25% 7/1/2010 1/1/2020
Subtotal 6,472,523
Wells Fargo Advisors
FHLB Step 2/22/2023-13 1,249,375.00 2.57% 2/22/2013 2/22/2023
FHLMC 212/18/2020-13 1,147,125.00 2.03% 6/18/2012 12/18/2020
Wells Fargo Advisors Cash 2,046,000.17 0.00% 12/27/2011 N/A
Subtotal 4,442,500
Investment Portfolio Total 33,768,314 1.43%Weighted Average YTM
City of Prior Lake-Quarterly Investment Report