Item 4 p.2 - Investment Porfolio Details Investment Portfolio Details
As of 4-29-20
1 Year or Less 1 - 365 days See Note (1)54.70% 77,636,541$
1 to 2 Years 366 - 730 days No More than 50% 1.41% 2,000,000
2 to 3 Years 731 - 1095 days No More than 35%10.57% 15,002,006
3 to 4 Years 1096 -1460 days No More than 30%7.75% 10,997,758
4 to 5 Years 1461 - 1825 days No more than 30%25.57% 36,298,742
100.00% 141,935,047$
PURCHASE MATURITY DAYS TO PAR BOOK MARKET
Line # Type Invest. # BROKER DATE DESCRIPTION DATE MATURITY RATE YIELD VALUE VALUE VALUE
10 Pool 18691 LAIF City 4/29/2020 1 1.540 1.540 37,500,000.00 37,500,000.00 37,500,000.00
11 Pool 20115 LAIF Successor Agency 4/29/2020 1 1.540 1.540 24,300,000.00 24,300,000.00 24,300,000.00
12 Money Market Mutual Fund 21250 Wells Fargo Bank - Treasury Sweep Money Market Mutual Fund 4/29/2020 1 0.209 0.209 1,836,836.06 1,836,836.06 1,836,836.06
13 Agency 21283 Stifel 6/29/2017 Toyota MTN 6/29/2020 61 2.000 2.000 10,000,000.00 10,000,000.00 9,949,211.10
14 Agency 21268 Stifel 5/27/2016 FNMA 11/30/2020 215 1.500 1.511 4,000,000.00 3,999,705.00 4,022,391.00
15 Medium Term Note 21276 UBS Financial Services 10/5/2016 Apple MTN 8/4/2021 462 1.550 1.550 2,000,000.00 2,000,000.00 2,012,340.00
16 Agency 21295 Stifel 2/25/2020 FHLMC 5/18/2022 749 1.600 1.477 7,000,000.00 7,002,006.00 7,005,785.00
17 Agency 21291 UBS Financial Services 1/22/2020 FHLB 7/22/2022 814 1.750 1.750 8,000,000.00 8,000,000.00 8,027,846.00
18 Agency 21289 UBS Financial Services 12/16/2019 FHLB 6/16/2023 1143 1.875 1.875 8,000,000.00 8,000,000.00 8,022,636.00
19 Agency 21296 Stifel 3/26/2020 FFCB 3/12/2024 1413 1.210 1.229 3,000,000.00 2,997,757.89 2,994,164.00
20 Agency 21293 UBS Financial Services 2/20/2020 FFCB 5/20/2024 1482 1.800 1.800 7,000,000.00 7,000,000.00 7,006,733.00
21 Medium Term Note 21290 UBS Financial Services 12/10/2019 HSBC MTN 6/23/2024 1516 3.500 2.145 6,000,000.00 6,326,023.00 6,033,375.18
22 Agency 21286 UBS Financial Services 9/3/2019 FFCB 9/3/2024 1588 2.000 2.000 13,000,000.00 13,000,000.00 13,068,274.00
23 Medium Term Note 21288 UBS Financial Services 9/20/2019 Coca Cola MTN 9/6/2024 1591 1.750 2.000 3,000,000.00 2,967,928.00 3,135,074.73
24 Agency 21294 Stifel 2/20/2020 FHLB 2/21/2025 1759 1.950 1.809 7,000,000.00 7,004,791.00 7,017,801.00
Total Portfolio Balance 141,636,836.06 141,935,046.95 141,932,467.07
LAIF Balance See Note (2) 43.54% LAIF 61,800,000.00 61,800,000.00 61,800,000.00
Agency Balance Maximum 75% of portfolio at time of purchase. 40.17% Agency 57,000,000.00 57,004,259.89 57,165,630.00
Money Market Mutual Fund Balance Maximum $15 million, or 20% of portfolio, whichever is less.1.29%1,836,836.06 1,836,836.06 1,836,836.06
Commercial Paper Balance Maximum 20% of portfolio and no more than 5% in a single issuer at time of purchase.0.00%0.00 0.00 0.00
Medium Term Note Balance Maximum 20% of portfolio and no more than 5% in a single issuer at time of purchase.15.00% Medium Term Note 21,000,000.00 21,293,951.00 21,130,001.01
100.00%141,636,836.06 141,935,046.95 141,932,467.07
Federal Home Loan Mortgage Corporation Maximum 35% of portfolio. 4.94%7,000,000.00 7,002,006.00 7,005,785.00
Federal Home Loan Bank Maximum 35% of portfolio. 16.21%23,000,000.00 23,004,791.00 23,068,283.00
Federal Farm Credit Bank Maximum 35% of portfolio..16.20%23,000,000.00 22,997,757.89 23,069,171.00
Federal National Mortgage Association Maximum 35% of portfolio. 2.82%4,000,000.00 3,999,705.00 4,022,391.00
40.17%57,000,000.00 57,004,259.89 57,165,630.00
ck 0.00 0.00 0.00
Note:
(1) Easing of the less than 15% and no more than 50% requirement approved by the City Manager as Emergency Services Manager during the pandemic. Allow flexibility to invest the maturing and called bond proceeds in the short run for liquidity as the impact of the coronavirus on cash needs
is currently uncertain. More bonds are expected to be called due to low interest rates.
(2) Easing of the 35% limit and an increase to 40% of the portfolio with influx of large deposits from called bonds. In the current market, LAIF performs better than other types of investment allowed in the Investment Policy.
Money Market Mutual Fund
Commercial Paper
Investments by Type by Maturity as of 4-29-20.xls
4/29/2020
10:58 AM
2