Loading...
Quarterly Investment Report for 6 months ended 12-31-17CITY OF EN INITAS INVESTMENT REPORT MEMORANDUM Six Months ended December 31, 2017 TO: City council VIA: Karen P. Brust, iGrty Manager FROM: Teresa S. McBroome, Director of Finance/City Treasurer DATE: February 6, 2018 SUBJECT: City of Encinitas Investment Report for the six (6) months ended December 31, 2017 It is the practice of the Finance Department to report on the status of City investments to the City Council on a periodic basis. Currently, the process is to report investment positions and results quarterly via memorandum, with attachments showing positions and earnings by investment and in summary. This report covers only the City's Pooled Investment fund (the "Pool".) It does not cover monies invested by the City's bond trustee, which are reported on an annual basis. The Pool had an investable balance of $108.7 million at December 31, 2017, compared to an average investable balance for the period of $102.5 million. The size of the pool varies throughout the year depending upon cash flow. Several factors have a significant impact on cash flow. Property tax revenue is received primarily in December, January, April and May. While debt payments typically fall in February, April, August and October. In addition, large payments on capital projects can happen throughout the year. The chart below shows the portfolio balance over the last five years. Monthly Portfolio Balance by Fiscal Year $120,000,000 $115,000,000 $110,000,000 $105,000,000 $100,000,000 - FY 17/18 - FY 16/17 $95,000,000 ^---- FY 15/16 $90,000,000 FY 14/15 FY 13/14 $85,000,000 $80,000,000 -- $75,000,000 I ' Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun End of Month Balance The City utilizes a variety of investment vehicles, including direct investments and indirect investments. Direct investments are primarily fixed income securities issued by the US Treasury and several US Gov't Agencies, such as the Federal National Mortgage Association (FNMA) and the Federal Home Loan Mortgage Corporation (FHLMC). Indirect investments include money market funds and pooled investments funds managed by other agencies, such as the California LAIF fund. Indirect investment balances are generally available to the City on a next day basis, and are classified as "liquid" meaning available to pay current demands. Monies invested in direct securities can only be accessed via the maturity of a security, or selling the security prior to maturity. The final maturities on our direct securities vary from less than one month to four years. The City has total liquidity, including cash in the bank, of $34.0 million at December 31, 2017. FY 2017-18 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Book Value $ 108,724,220 $ 100,117,676 Market Value $ 108,059,982 $ 99,859,075 Unrealized Gain/(Loss) $ (664,238) $ (258,601) Unrealized Gain/Loss as % of Book Value -0.6109% -0.2583% Effective Rate of Return 1.30% 1.28% Average Yield To Maturity 1.36% 1.31% Average Maturity (Years) 1.401 1.67 Investment Earnings Year to Date $ 673,783 1 $ 337,542 The Pool earned $673,783 during the first six months of FY 2017-18 for an annualized return of 1.30%. This compares to the City's adopted performance benchmark of the one (1) year constant maturity Treasury index which averaged a 1.28% yield over the six months ended December 31, 2017. The City informally utilizes an alternative benchmark of the two (2) year constant maturity Treasury index yield for comparison. This is a more appropriate comparison when the weighted -average maturity (WAM) of the Pool is greater than one year (the current WAM is 512 days or 1.40 years.) The 2 yr. T-note averaged a 1.16% yield for the six months ended December 31, 2017. City Portfolio Yield Compared to Treasury Indexes 2.50% 2.00% 1.50% � = v 1.00 % 0.50 % .. tia 4% ,ya ,p tiO ti6 y1 y1 tit tit lJc 41 1 e lgt 1Jr SyQ� p�� �a� 1`�� fed peg 4a1 100 5e� peg City Portfolio - 2 Yr Treasury 1 Yr Treasury 6 Mth Treasury The market value of the City's direct investments is less than their carrying value by $664.238 as of December 31, 2017, meaning that there are unrealized losses on securities held. Since the City has never had to sell a security prior to maturity, any unrealized gains or losses would only constitute a timing difference. The public's monies are extremely safe and well -diversified, and are in line with the City's adopted investment policy and the overall direction of the City Council. ATTACHMENTS — Portfolio Management and Interest Earnings Reports City of Encinitas - Qtr Inv Report Portfolio Management Portfolio Summary December 31, 2017 CITY OF ENCINITAS 505 S. VULCAN ENCINITAS, ENCINITAS, CA 9 (760)633-2641 Investments Par Value Market Value Book Value % of Portfolio YTM Term Days to Maturity Local Agency Investment Funds 29,749,581.47 29,749,581.47 29,749,581.47 28.76 1.300 1 1 Managed Pool Accounts 1,016,685.49 1,016,685.49 1,016,685.49 0.98 1.290 1 1 Money Market Funds 12,052.56 12,052.56 12,052.56 0.01 0.940 1 1 Certificates of Deposit - Bank 4,425,000.00 4,397,406.81 4,425,000.00 4.28 2.017 1,605 1,132 Negotiable CDs 245,000.00 242,966.50 245,000.00 0.24 1.750 1,095 900 U.S. Treasury Coupon Securities 30,000,000.00 29,588,860.00 29,929,425.80 28.93 1.350 1,316 832 Federal Agency Coupon Securities 38,000,000.00 37,773,260.00 38,067,306.24 36.80 1.348 1,356 599 103,448,319.52 102,780,812.83 103,445,051.56 100.00% 1.364 951 512 Investments Cash, Pending Redemptions Passbook/Checking 3,279,168.67 (not included in yield calculations) 3,279,168.67 3,279,168.67 0.000 1 1 Pending Redemptions 2,000,000.00 2,000,000.00 2,000,000.00 Subtotal 5,279,168.67 5,279,168.67 Total Cash, Pending Redemptions 108,727,488.19 108,059,981.50 108,724,220.23 1.364 951 512 and Investments Total Earnings December 31 Period Ending Current Year 673,783.49 Average Daily Balance 102,510,212.45 Effective Rate of Return 1.30% I certify the accuracy of the attached report on the City of Encinitas' Pooled Investment Fund. All funds for which the City has oversight responsibility are reflected in this report. All investments are in compliance with the City's adopted Investment Policy., which is available through the City Clerk's office. The City's Investment Program provides sufficient liquidity to meet the next six (6) months expenditure requirements. The source of the market values of investments owned is Union Bank of California Custody Services. Teresa McBroome, Finance Director\Treasurer Reporting period 07/01/2017-12/31/2017 Data Updated: SET_QTR: 01/23/2018 19:29 Run Date: 01/23/2018 -19:29 No fiscal year history available Portfolio ENCI AC PM (PRF_PM1) 7.3.0 Report Ver. 7.3.5 City of Encinitas - Qtr Inv Report Portfolio Management Page 1 Portfolio Details - Investments December 31, 2017 Average Purchase Stated YTM Maturity CUSIP Investment # Issuer Balance Date Par Value Market Value Book Value Rate S&P Moody's Date Local Agency Investment Funds SYS1012 1012 CA LAIF 29,749,581.47 29,749,581.47 29,749,581.47 1.300 1.300 NR Subtotal and Average 23,359,737.14 29,749,581.47 29,749,581.47 29,749,581.47 1.300i Managed Pool Accounts SYS1003 1003 CA Asset Management Program Subtotal and Average 1,014,211.01 Money Market Funds SYS1004 1004 Union Bank Custody Acct. Subtotal and Average Certificates of Deposit - Bank 254672CB2 1477 Discovery Bank 0606247A5 1454 Bank of Baroda 8562843F9 1484 State Bank of India 87164YEB6 1478 Synchrony Bank 17284C5K6 1487 CIT Bank 020061_3N1 1527 Ally Bank 56585YAB6 1532 Marathon Savings Bank 169894AN2 1529 Chippewa Valley Bank 337630BD8 1531 Firstrust Savings Bank 975875AK1 1526 Winter Hill Bank FSB 17670DAC8 1530 Citizens State Bankl 17801 GSB7 1551 City National Bank Metropolis 38148PKX4 1528 Goldman Sachs Bank USA 06653ABM5 1533 BankVista 949763JG2 1535 Wells Fargo Bank 14042RGN5 1552 Capital One NA 1404203Q1 1553 Capital One Bank USA, NA 87270LAD5 1554 TIAA FSB Negotiable CDs 20033AUE4 325,928.78 Subtotal and Average 4,717,043.48 1525 Comenity Capital Bank Subtotal and Average Data Updated: SET _QTR: 01/23/2018 19:29 Run Date: 01/23/2018 -19:29 245,001.17 10/22/2014 11/12/2013 12/05/2014 10/17/2014 12/10/2014 06/22/2017 06/28/2017 06/30/2017 06/23/2017 06/26/2017 06/30/2017 07/03/2017 06/21/2017 06/30/2017 06/30/2017 07/1912017 07/19/2017 07/19/2017 1,016, 685.49 1,016,685.49 12,052.56 12,052.56 248,000.00 248,000.00 248,000.00 248,000.00 248,000.00 245,000.00 245,000.00 245,000.00 245,000.00 245,000.00 245,000.00 245,000.00 245,000.00 245,000.00 245,000.00 245,000.00 245,000.00 245,000.00 4,425,000.00 06/20/2017 245,000.00 245,000.00 1,016,685.49 1,016,685.49 1,016,685.49 1.290 1.290 AAA 1,016,685.49 1.290 12,052.56 12,052.56 0.940 0.940 AAA 12,052.56 12,052.56 0.940 248,334.80 248,607.60 248,461.28 248,577.84 248,949.84 243,843.60 242,618.60 242,616.15 242,324.60 241,479.35 241,528.35 242,184.95 244,627.60 240,906.05 242,224.15 243,899.95 243,899.95 242,322.15 4,397,406.81 242,966.50 242,966.50 248, 000.00 1.800 1.800 248,000.00 2.050 2.050 248,000.00 2.000 2.000 248,000.00 2.000 2.000 248,000.00 2.200 2.200 245, 000.00 1.900 1.900 245, 000.00 1.700 1.700 245, 000.00 1.700 1.700 245, 000.00 1.900 1.900 245, 000.00 1.800 1.800 245,000.00 1.900 1.900 245,000.00 2.000 2.000 245,000.00 2.350 2.350 245,000.00 2.000 2.000 245,000.00 2.250 2.250 245,000.00 2.300 2.300 245,000.00 2.300 2.300 245,000.00 2.150 2.150 4,425,000.00 2.017 245, 000.00 1.750 1.750 245,000.00 1.750 NR NR 10/22/2018 NR NR 11/13/2018 NR NR 12/05/2018 NR NR 10/17/2019 NR NR 12/10/2019 06/22/2020 06/29/2020 06/30/2020 06/23/2021 06/28/2021 12/30/2021 NR NR 02/03/2022 P-1 06/21/2022 06/30/2022 06/30/2022 NR 07/19/2022 07/19/2022 NR NR 07/19/2022 06/19/2020 Portfolio ENCI AC PM (PRF_PM2) 7.3.0 Report Ver. 7.3.5 City of Encinitas - Qtr Inv Report Portfolio Management Portfolio Details - Investments December 31, 2017 Page 2 CUSIP Investment # Average Issuer Balance Purchase Date Par Value Market Value Book Value Stated Rate YTM Maturity S&P Moody's Date U.S. Treasury Coupon Securities 912828VK3 1491 U.S. Treasury Notes 02/20/2015 2,000,000.00 1,998,760.00 2,002,167.87 1.375 1.150 AA+ Aaa 06/30/2018 912828XK1 1509 U.S. Treasury Notes 01/27/2016 2,000,000.00 1,992,820.00 1,998,984.45 0.875 0.971 Aaa 07/15/2018 912828TH3 1510 U.S. Treasury Notes 01/27/2016 2,000,000.00 1,969,840.00 1,990,128.81 0.875 1.195 Aaa 07/31/2019 912828TNO 1515 U.S. Treasury Notes 06/01/2016 2,000,000.00 1,971,720.00 1,998,640.52 1.000 1.042 Aaa 08/31/2019 912828TV2 1516 U.S. Treasury Notes 06/01/2016 2,000,000.00 1,977,580.00 2,006,403.12 1.250 1.071 Aaa 10/31/2019 912828,150 1517 U.S. Treasury Notes 06/01/2016 2,000,000.00 1,977,420.00 2,009,011.79 1.375 1.161 Aaa 02/29/2020 912828,184 1518 U.S. Treasury Notes 06/01/2016 2,000,000.00 1,976,560.00 2,008,883.58 1.375 1.172 Aaa 03/31/2020 912828XM7 1514 U.S. Treasury Notes 04/19/2016 2,000,000.00 1,984,620.00 2,023,903.85 1.625 1.149 NR Aaa 07/31/2020 91282BL32 1520 U.S. Treasury Notes 02/13/2017 2,000,000.00 1,970,780.00 1,989,451.03 1.375 1.580 Aaa 08/31/2020 9128281-65 1521 U.S. Treasury Notes 02/13/2017 2,000,000.00 1,969,540.00 1,988,408.73 1.375 1.593 Aaa 09/30/2020 9128281-99 1522 U.S. Treasury Notes 02/13/2017 2,000,000.00 1,967,740.00 1,986,716.61 1.375 1.618 Aaa 10/31/2020 912828A42 1538 U.S. Treasury Notes 06/28/2017 2,000,000.00 2,001,880.00 2,024,452.44 2.000 1.567 Aaa 11/30/2020 912828P87 1539 U.S. Treasury Notes 06/28/2017 2,000,000.00 1,944,920.00 1,970,418.53 1.125 1.609 Aaa 02/28/2021 9128280137 1540 U.S. Treasury Notes 06/28/2017 2,000,000.00 1,950,620.00 1,977,057.90 1.250 1.616 Aaa 03/31/2021 912828S76 1523 U.S. Treasury Notes 02/13/2017 2,000,000.00 1,934,060.00 1,954,796.57 1.125 1.784 Aaa 07/31/2021 Subtotal and Average 32,247,129.48 30,000,000.00 29,588,860.00 29,929,425.80 1.350 Federal Agency Coupon Securities 3135GOTG8 1504 Federal Nat'l Mortgage Assoc. 06/26/2015 2,000,000.00 1,999,040.00 1,999,767.00 0.875 0.990 AA+ Aaa 02/08/2018 3137EADP1 1492 Federal Home Loan Mortgage 03/20/2015 2,000,000.00 1,998,280.00 1,999,476.70 0.875 1.020 AA+ Aaa 03/07/2018 3133EEM98 1496 Federal Farm Credit 05/27/2015 2,000,000.00 1,996,360.00 1,999,770.58 1.000 1.030 AA+ Aaa 05/21/2018 3135GOE33 1501 Federal Nat'l Mortgage Assoc. 06/24/2015 2,000,000.00 1,994,280.00 1,999,621.43 1.125 1.160 AA+ Aaa 07/20/2018 313OA5E54 1497 Federal Home Loan Bank 05/27/2015 2,000,000.00 1,991,780.00 2,000,000.00 1.100 1.100 AA+ Aaa 08/13/2018 3135GOYM9 1503 Federal Nat'l Mortgage Assoc. 06/26/2015 2,000,000.00 2,001,740.00 2,008,997.65 1.875 1.230 AA+ Aaa 09/18/2018 313OA53ZO 1493 Federal Home Loan Bank 04/24/2015 2,000,000.00 1,987,400.00 1,999,682.26 1.050 1.070 AA+ Aaa 10/23/2018 3135GOYT4 1505 Federal Nat'l Mortgage Assoc. 06/26/2015 2,000,000.00 1,996,840.00 2,006,270.53 1.625 1.270 AA+ Aaa 11/27/2018 3135GOZA4 1500 Federal Nat'l Mortgage Assoc. 06/24/2015 2,000,000.00 2,000,520.00 2,010,971.63 1.875 1.377 AA+ Aaa 02/19/2019 3133782M2 1498 Federal Home Loan Bank 05/27/2015 2,000,000.00 1,991,780.00 2,004,147.64 1.500 1.320 AA+ Aaa 03/08/2019 313379EE5 1499 Federal Home Loan Bank 05/27/2015 2,000,000.00 1,992,040.00 2,006,332.00 1.625 1.400 AA+ Aaa 06/14/2019 3135GOZG1 1506 Federal Nat'l Mortgage Assoc. 06/26/2015 2,000,000.00 1,994,340.00 2,005,062.11 1.750 1.595 AA+ Aaa 09/12/2019 3135GOZY2 1507 Federal Nat'l Mortgage Assoc 06/26/2015 2,000,000.00 1,993,240.00 2,003,834.28 1.750 1.645 AA+ Aaa 11/2612019 3137EADR7 1512 Federal Home Loan Mortgage 04/19/2016 2,000,000.00 1,970,100.00 2,010,939.67 1.375 1.134 AA+ Aaa 05/01/2020 313383HU8 1513 Federal Home Loan Bank 04/19/2016 2,000,000.00 1,986,460.00 2,025,039.75 1.750 1.224 AA+ Aaa 06/12/2020 3133EHNX7 1534 Federal Farm Credit 06/21/2017 2,000,000.00 1,967,520.00 1,995,052.08 1.650 1.724 06/21/2021 313OA8QS5 1524 Federal Home Loan Bank 02/13/2017 2,000,000.00 1,933,560.00 1,954,968.93 1.125 1.790 AA+ Aaa 07/14/2021 3134G9N94 1537 Federal Home Loan Mortgage 06/23/2017 2,000,000.00 1,982,820.00 2,011,326.22 1.875 1.710 AA+ Aaa 07/27/2021 Data Updated: SET _QTR: 01/23/2018 19:29 Portfolio ENCI AC Run Date: 01/23/2018 -19:29 PM (PRF_PM2) 7.3.0 City of Encinitas - Qtr Inv Report Portfolio Management Portfolio Details - Investments December 31, 2017 Page 3 Average Purchase Stated YTM Maturity CUSIP Investment # Issuer Balance Date Par Value Market Value Book Value Rate S&P Moody's Date Federal Agency Coupon Securities 3133EHCT8 1536 Federal Farm Credit 06/23/2017 2,000,000.00 1,995,160.00 2,026,045.78 2.150 1.825 AA+ Aaa 03/15/2022 Subtotal and Average 40,526,080.89 38,000,000.00 37,773,260.00 38,067,306.24 1.348 Total and Average 102,510,212.45 103,448,319.52 102,780,812.83 103,445,051.56 1.364 Data Updated: SET QTR: 01/23/2018 19:29 Portfolio ENCIAC Run Date: 01/23/2018 - 19:29 PM (PRF_PM2) 7.3.0 City of Encinitas - Qtr Inv Report Portfolio Management Page 4 Portfolio Details - Cash December 31, 2017 Average Purchase Stated YTM CUSIP Investment # Issuer Balance Date Par Value Market Value Book Value Rate S&P Moody's Passbook/Checking Accounts SYS1010 1010 Union Bank Checking Acct. 3,279,168.67 3,279,168.67 3,279,168.67 0.000 Average Balance 0.00 Total Cash and Investments Data Updated: SET_QTR: 01/23/2018 19:29 Run Date: 01/23/2018 - 19:29 102,510,212.45 106,727,488.19 106,059,981.50 106,724,220.23 1.364 Portfolio ENCI AC PM (PRF_PM2) 7.3.0 City of Encinitas - Qtr Inv Report Portfolio Management Portfolio Details - Pending Redemptions December 31, 2017 Page 1 Purchase Mat/Sale Security # Investment # Issuer Settlement Date Settlement Date Par Value U.S. Treasury Coupon Securities 91282BUEB 1490 U.S. Treasury Notes 12/17/2014 / I 0.00 912828UE8 1490 U.S. Treasury Notes 12/17/2014 / / 0.00 912828UE8 1490 U.S. Treasury Notes 12/17/2014 / ' 0.00 912828UEB 1490 U.S. Treasury Notes 12/17/2014 / ; 0.00 912828UE8 1490 U.S. Treasury Notes 12/17/2014 / 0.00 912828UEB 1490 U.S. Treasury Notes 12/17/2014 / / 0.00 912828UE8 1490 U.S. Treasury Notes 12/17/2014 12/31/2017 2,000,000.00 Subtotal 2,000,000.00 Total Pending Redemptions 2,000,000.00 Data Updated: SET QTR: 01/23/2018 19:29 Portfolio ENCI AC Run Date: 01/23/2018 -19:29 PM (PRF_PM7) 7.3.0 Report Ver. 7.3.5 City of Encinitas - Qtr Inv Report Portfolio Management Activity By Type July 1, 2017 through December 31, 2017 Stated Transaction Purchases Redemptions CUSIP Investment # Issuer Rate Date or Deposits or Withdrawals Balance Passbook/Checking Accounts (Monthly Summary) SYS1010 1010 Union Bank Checking Acct. Subtotal Local Agency Investment Funds (Monthly Summary) SYS1012 1012 CA LAIF 1.300 Subtotal Managed Pool Accounts (Monthly Summary) SYS1003 1003 CA Asset Management Program 1.290 Subtotal Money Market Funds (Monthly Summary) SYS1004 1004 Union Bank Custody Acct. Subtotal Certificates of Deposit - Bank 02587DLV8 1438 American Express Centurion 14042RGN5 1552 Capital One NA 1404203Q1 1553 Capital One Bank USA, NA 17801 GSB7 1551 City National Bank Metropolis 45083ADZ2 1482 Iberia Bank/LA 87270LAD5 1554 TIAA FSB Subtotal Negotiable CDs Subtotal U.S. Treasury Coupon Securities 912828UE8 1490 U.S. Treasury Notes 912828TG5 1511 U.S. Treasury Notes Subtotal Federal Agency Coupon Securities 3133EDSU7 1508 Federal Farm Credit 3130A4TR3 1495 Federal Home Loan Bank •* - Indicates incomplete recording of maturity redemption. Data Updated: SET QTR: 01/23/2018 19:29 Run Date: 01/23/2018 - 19:29 0.940 1.500 10/25/2017 2.300 07/19/2017 2.300 07/19/2017 2.000 07/03/2017 1.200 12/04/2017 2.150 07/19/2017 0.750 12/31/2017 0.500 07/31/2017 1.000 08/15/2017 0.875 10/16/2017 13, 814, 815.83 13,151, 443.21 13, 814, 815.8 3 13,151, 443.21 15,953,592.54 16,750,000.00 15,953,592.54 16, 750, 000.00 0.00 29,749,581.47 5,775.49 0.00 5,775.49 0.00 1,016,685.49 9,981,329.18 10,031,750.00 9,981,329.18 10,031,750.00 12,052.56 0.00 248,000.00 245,000.00 0.00 245,000.00 0.00 245,000.00 0.00 0.00 248,000.00 245,000.00 0.00 980,000.00 496,000.00 4,425,000.00 0.00 2,000,000.00 ** 0.00 2,000,000.00 0.00 4,000,000.00 0.00 1,000,000.00 0.00 2,000,000.00 245,000.00 29,929,425.80 Page 1 Portfolio ENCI AC PM (PRF_PM3) 7.3.0 Report Ver. 7.3.5 City of Encinitas - Qtr Inv Report Portfolio Management Activity By Type July 1, 2017 through December 31, 2017 Page 2 Stated Transaction Purchases Redemptions CUSIP Investment # Issuer Rate Date or Deposits or Withdrawals Balance Federal Agency Coupon Securities 3136GOZH7 1480 Federal NaVl Mortgage Assoc. 1.050 09/05/2017 0.00 2,000,000.00 3136GOYE5 1494 Federal NaVI Mortgage Assoc. 1.000 08/28/2017 0.00 1,000,000.00 Subtotal 0.00 6,000,000.00 38,067,306.24 Total 40,735,513.04 50,429,193.21 103,445,051.56 Portfolio ENCI Data Updated: SET_QTR: 01/23/2018 19:29 AC Run Date: 01/23/2018 -19:29 PM (PRF_PM3) 7.3.0 City of Encinitas - Qtr Inv Report Portfolio Management Interest Earnings Summary December 31, 2017 December 31 Month Ending CD/Coupon/Discount Investments: Interest Collected Plus Accrued Interest at End of Period Less Accrued Interest at Beginning of Period Less Accrued Interest at Purchase During Period Interest Earned during Period Adjusted by Premiums and Discounts Adjusted by Capital Gains or Losses Earnings during Periods Pass Through Securities: Interest Collected Plus Accrued Interest at End of Period Less Accrued Interest at Beginning of Period Less Accrued Interest at Purchase During Period Interest Earned during Period Adjusted by Premiums and Discounts Adjusted by Capital Gains or Losses Earnings during Periods Cash/Checking Accounts: Interest Collected Plus Accrued Interest at End of Period Less Accrued Interest at Beginning of Period Interest Earned during Period Total Interest Earned during Period Total Adjustments from Premiums and Discounts Total Capital Gains or Losses Total Earnings during Period 533,741.22 275,595.03 ( 266,111.32) { 0.00) 543,224.93 -14,460.54 0.00 528,764.39 0.00 0.00 0.00) { 0.00) 0.00 0.00 0.00 0.00 162,076.02 72,435.02 ( 91,731.80) 142,779.24 686,004.17 -14,460.54 0.00 671,543.63 Fiscal Year To Date 533,741.22 275,595.03 266,111.32) 0.00) 543,224.93 -14,460.54 0.00 528,764.39 0.00 0.00 ( 0.00) ( 0.00) 0.00 0.00 0.00 0.00 162,076.02 72,435.02 ( 91,731.80) 142,779.24 686,004.17 -14,460.54 0.00 671,543.63 Page 1 Portfolio ENCI Data Updated: SET QTR: 01/23/2018 19:29 AC Run Date: 01/23/2018 - 19:29 No fiscal year history available PM (PRF_PM6) 7.3.0 Report Ver. 7.3.5 Cityof Encinitas - Qtr Inv Report p CITY OF ENCINITAS _ 505 S. VULCAN Investments by Issuer ENCINITAS, ENCINITAS, CA 9 (760)633-2641 Active Investments Sorted by Fund December 31, 2017 Investment Current Market YTM Redemption Days To Call CUSIP Investment # Security Type Class Book Value Rate Market Value Date 365 Date Maturity Date Collateral Ally Bank 02006L3N1 1527 Certificates of Deposit - Bank Amort 245,000.00 1.900 243,843.60 12/31/2017 1.900 06/22/2020 903 Subtotal and Average 245,000.00 243,843.60 1.900 903 Bank of Baroda 0606247A5 1454 BankVista 06653ABM5 1533 CA Asset Management Program SYS1003 1003 Capital One NA 14042RGN5 1552 Capital One Bank USA, NA 1404203Q1 1553 Chippewa Valley Bank 169894AN2 1529 CIT Bank 17284C5K6 1487 Certificates of Deposit - Bank Amort 248,000.00 2.050 248,607.60 12/31/2017 2.050 11/13/2018 316 Subtotal and Average 248,000.00 248,607.60 2.050 316 Certificates of Deposit - Bank Amort 245,000.00 2.000 240,906.05 12/31/2017 2.000 06/30/2022 1,641 Subtotal and Average 245,000.00 240,906.05 2.000 1,641 Managed Pool Accounts Amort 1,016,685.49 1.290 1,016,685.49 12/31/2017 1.290 1 Subtotal and Average 1,016,685.49 1,016,685.49 1.290 1 Certificates of Deposit - Bank Amort 245,000.00 2.300 243,899.95 12/31/2017 2.300 07/19/2022 1,660 Subtotal and Average 245,000.00 243,899.95 2.300 1,660 Certificates of Deposit - Bank Amort 245,000.00 2.300 243,899.95 12/31/2017 2.300 07/19/2022 1,660 Subtotal and Average 245,000.00 243,899.95 2.300 1,660 Certificates of Deposit - Bank Amort Subtotal and Average Certificates of Deposit - Bank Amort Subtotal and Average Data Updated: SET QTR: 01/23/2018 19:29 Run Date: 01/23/2018 - 19:29 245,000.00 1.700 245,000.00 248,000.00 2.200 248,000.00 No fiscal year history available 242,616.15 12/31/2017 1.700 06/30/2020 911 242,616.15 1.700 911 248,949.84 12/31/2017 2.200 12/10/2019 708 248,949.84 2.200 708 Portfolio ENCI AC DI (PRF_DI) 7.1.1 Report Ver. 7.3.5 City of Encinitas - Qtr Inv Report Investments by Issuer Page 2 Sorted by Fund Investment Current Market YTM Redemption Days To Call CUSIP Investment # Security Type Class Book Value Rate Market Value Date 365 Date Maturity Date Collateral Citizens State Bankl 17670DAC8 1530 Certificates of Deposit - Bank Amort 245,000.00 1.900 241 528.35 12/31/2017 1.900 12/30/2021 1 459 City National Bank Metropolis 17801 GSB7 1551 Comenity Capital Bank 20033AUE4 1525 Discovery Bank 254672CB2 1477 Federal Farm Credit 3133EEM98 1496 3133EHNX7 1534 3133EHCT8 1536 Federal Home Loan Bank 313OA53ZO 1493 3130A5E54 1497 3133782M2 1498 313379EE5 1499 313383HU8 1513 3130A8QS5 1524 Federal Home Loan Mortgage 3137EADP1 1492 3137EADR7 1512 3134G9N94 1537 Subtotal and Average Certificates of Deposit - Bank Amort Subtotal and Average Negotiable CDs Amort Subtotal and Average Certificates of Deposit - Bank Amort Subtotal and Average Federal Agency Coupon Securities Fair Federal Agency Coupon Securities Fair Federal Agency Coupon Securities Fair Subtotal and Average Federal Agency Coupon Securities Fair Federal Agency Coupon Securities Fair Federal Agency Coupon Securities Fair Federal Agency Coupon Securities Fair Federal Agency Coupon Securities Fair Federal Agency Coupon Securities Fair Federal Agency Coupon Securities Fair Federal Agency Coupon Securities Fair Federal Agency Coupon Securities Fair Subtotal and Average 245,000.00 245,000.00 2.000 245,000.00 245,000.00 1.750 245,000.00 248,000.00 1.800 248,000.00 1,999,770.58 1.000 1,995,052.08 1.650 2,026,045.78 2.150 6,020,868.44 1,999,682.26 1.050 2,000,000.00 1.100 2,004,147.64 1.500 2,006,332.00 1.625 2,025,039.75 1.750 1,954.968.93 1.125 11,990,170.58 1,999,476.70 0.875 2,010,939.67 1.375 2,011,326.22 1.875 6,021,742.59 241,528.35 1.900 1,459 242,184.95 242,184.95 12/31/2017 2.000 2.000 02/03/2022 1,494 1,494 242,966.50 12/31/2017 1.775 06/19/2020 900 242,966.50 1.775 900 248,334.80 12/31/2017 1.800 10/22/2018 294 248,334.80 1.800 294 1,996,360.00 12/31/2017 1.030 05/21/2018 140 1,967,520.00 12/31/2017 1.724 06/21/2021 1,267 1,995,160.00 12/31/2017 1.825 03/15/2022 1,534 5,959,040.00 1.528 982 1,987,400.00 12/31/2017 1.070 10/23/2018 295 1,991,780.00 12/31/2017 1.100 08/13/2018 224 1,991,780.00 12/31/2017 1.320 03/08/2019 431 1,992,040.00 12/31/2017 1.400 06/14/2019 529 1,986,460.00 12/31/2017 1.224 06/12/2020 893 1,933,560.00 12/31/2017 1.790 07/14/2021 1,290 11,883,020.00 1.315 608 1,998,280.00 12/31/2017 1.020 03/07/2018 65 1,970,100.00 12/31/2017 1.134 05/01/2020 851 1,982,820.00 12/31/2017 1.710 07/27/2021 1,303 5,951,200.00 1.289 740 Portfolio ENCI Data Updated: SET _QTR: 01/23/2018 19:29 AC Run Date: 01/23/2018 - 19:29 No fiscal year history available DI (PRF_DI) 7.1.1 Report Ver. 7.3.5 City of Encinitas - Qtr Inv Report Investments by Issuer Sorted by Fund Page 3 Investment Current Market YTM Redemption Days To Call CUSIP Investment # Security Type Class Book Value Rate Market Value Date 365 Date Maturity Date Collateral Firstrust Savings Bank 337630BDB 1531 Certificates of Deposit - Bank Amort 245,000.00 1.900 242,324.60 12/31/2017 1.900 06/23/2021 1,269 Subtotal and Average 245,000.00 242,324.60 1.900 1,269 Federal NaVI Mortgage Assoc. 3135GOZA4 1500 Federal Agency Coupon Securities Fair 2,010,971.63 1.875 2,000,520.00 12/31/2017 1.377 02/19/2019 414 3135GOE33 1501 Federal Agency Coupon Securities Fair 1,999,621.43 1.125 1,994,280.00 12/31/2017 1.160 07/20/2018 200 3135GOYM9 1503 Federal Agency Coupon Securities Fair 2,008,997.65 1.875 2,001,740.00 12/31/2017 1.230 09/18/2018 260 3135GOTG8 1504 Federal Agency Coupon Securities Fair 1,999,767.00 0.875 1,999,040.00 12/31/2017 0.990 02/08/2018 38 3135GOYT4 1505 Federal Agency Coupon Securities Fair 2,006,270.53 1.625 1,996,840.00 12/31/2017 1.270 11/27/2018 330 3135GOZG1 1506 Federal Agency Coupon Securities Fair 2,005,062.11 1.750 1,994,340.00 12/31/2017 1.595 09/12/2019 619 3135GOZY2 1507 Federal Agency Coupon Securities Fair 2,003,834.28 1.750 1,993,240.00 12/31/2017 1.645 11/26/2019 694 Subtotal and Average 14,034,524.63 13,980,000.00 1.324 365 Goldman Sachs Bank USA 38148PKK4 1528 Certificates of Deposit - Bank Amort 245,000.00 2.350 244,627.60 12/31/2017 2.350 06/21/2022 1,632 Subtotal and Average 245,000.00 244,627.60 2.350 1,632 State Bank of India 8562843F9 1484 Certificates of Deposit - Bank Amort 248,000.00 2.000 248,461.28 12/31/2017 2.000 12/05/2018 338 Subtotal and Average 248,000.00 248,461.28 2.000 338 CA LAIF SYS1012 1012 Local Agency Investment Funds Amort 29,749,581.47 1.300 29,749,581.47 12/31/2017 1.300 1 Subtotal and Average 29,749,581.47 29,749,581.47 1.300 1 Marathon Savings Bank 56585YA136 1532 Certificates of Deposit - Bank Amort 245,000.00 1.700 242,618.60 12/31/2017 1.700 06/29/2020 910 Subtotal and Average 245,000.00 242,618.60 1.700 910 Synchrony Bank 87164YEB6 1478 Certificates of Deposit - Bank Amort 248,000.00 2.000 248,577.84 12/31/2017 2.000 10/17/2019 654 Subtotal and Average 248,000.00 248,577.84 2.000 654 TIAA FSB 87270LAD5 1554 Certificates of Deposit - Bank Amort 245,000.00 2.150 242,322.15 12/31/2017 2.150 07/19/2022 1,660 Portfolio ENCI Data Updated: SET _QTR: 01/23/2018 19:29 AC Run Date: 01/23/2018 -19:29 No fiscal year history available DI (PRF_DI) 7.1.1 Report Ver. 7.3.5 City of Encinitas - Qtr Inv Report Investments by Issuer Page 4 Sorted by Fund Investment Current Market YTM Redemption Call CUSIP Investment # Security Type Class Book Value Rate Market Value Date 365 Date Date Collateral Subtotal and Average 245,000.00 242,322.15 2.150 1,660 Union Bank Checking Acct. SYS1010 1010 Passbook/Checking Accounts Amort 3,279,168.67 3,279,168.67 12/31/2017 1 Subtotal and Average 3,279,168.67 3,279,168.67 1 Union Bank Custody Acct. SYS1004 1004 Money Market Funds Amort 12,052.56 0.940 12,052.56 12/31/2017 0.940 1 Subtotal and Average 12,052.56 12,052.56 0.940 1 U.S. Treasury Notes 912828VK3 1491 U.S. Treasury Coupon Securities Fair 2,002,167.87 1.375 1,998,760.00 12/31/2017 1.150 06/30/2018 180 912828XK1 1509 U.S. Treasury Coupon Securities Fair 1,998,984.45 0.875 1,992,820.00 12/31/2017 0.971 07/15/2018 195 912828TH3 1510 U.S. Treasury Coupon Securities Fair 1,990,128.81 0.875 1,969,840.00 12/31/2017 1.195 07/31/2019 576 912828XM7 1514 U.S. Treasury Coupon Securities Fair 2,023,903.85 1.625 1,984,620.00 12/31/2017 1.149 07/31/2020 942 912828TNO 1515 U.S. Treasury Coupon Securities Fair 1,998,640.52 1.000 1,971,720.00 12/31/2017 1.042 08/31/2019 607 912828TV2 1516 U.S. Treasury Coupon Securities Fair 2,006,403.12 1.250 1,977,580.00 12/31/2017 1.071 10/31/2019 668 912828.150 1517 U.S. Treasury Coupon Securities Fair 2,009,011.79 1.375 1,977,420.00 12/31/2017 1.161 02/29/2020 789 912828J84 1518 U.S. Treasury Coupon Securities Fair 2,008,883.58 1.375 1,976,560.00 12/31/2017 1.172 03/31/2020 820 9128281-32 1520 U.S. Treasury Coupon Securities Fair 1,989,451.03 1.375 1,970,780.00 12/31/2017 1.580 08/31/2020 973 9128281-65 1521 U.S. Treasury Coupon Securities Fair 1,988,408.73 1.375 1,969,540.00 12/31/2017 1.593 09/30/2020 1,003 9128281-99 1522 U.S. Treasury Coupon Securities Fair 1,986,716.61 1.375 1,967,740.00 12/31/2017 1.618 10/31/2020 1,034 91282BS76 1523 U.S. Treasury Coupon Securities Fair 1,954,796.57 1.125 1,934,060.00 12/31/2017 1.784 07/31/2021 1,307 912828A42 1538 U.S. Treasury Coupon Securities Fair 2,024,452.44 2.000 2,001,880.00 12/31/2017 1.567 11/30/2020 1,064 91282BP87 1539 U.S. Treasury Coupon Securities Fair 1,970,418.53 1.125 1,944,920.00 12/31/2017 1.609 02/28/2021 1,154 912828Q37 1540 U.S. Treasury Coupon Securities Fair 1,977,057.90 1.250 1,950,620.00 12/31/2017 1.616 03/31/2021 1,185 Subtotal and Average 29,929,425.80 29,588,860.00 1.350 831 Wells Fargo Bank 949763JG2 1535 Winter Hill Bank FSB 975875AK1 1526 Certificates of Deposit - Bank Amort Subtotal and Average Certificates of Deposit - Bank Amort Subtotal and Average Total and Average Data Updated: SET _QTR: 01/23/2018 19:29 Run Date: 01/23/2018 -19:29 245,000.00 2.250 245,000.00 245,000.00 1.800 245,000.00 106,724,220.23 No fiscal year history available 242,224.15 12/31/2017 2.250 06/30/2022 1,641 242,224.15 2.250 1,641 241,479.35 12/31/2017 1.800 06/28/2021 241,479.35 1.800 106,059,981.50 1.322 1,274 1,274 496 Portfolio ENCI AC DI (PRF_DI) 7.1.1 Report Ver. 7.3.5 CUSIP Investment # Fund Issuer Passbook/Checking Accounts SYS1010 1010 001 Local Agency Investment Funds SYS1012 1012 001 Managed Pool Accounts SYS1003 1003 001 Money Market Funds SYS1004 1004 001 Certificates of Deposit - Bank CITY OF ENCINITAS City of Encinitas - Qtr Inv Report 505 S. VULCAN Investments by Type ENCINITAS, ENCINITAS, CA 9 Active Investments (760)633-2641 December 31, 2017 Purchase Current Maturity Call Call Par Value Price Remaining Cost Rate Date Date Price Union Bank Checking Acct. 3,279,168.67 100.0000000 Subtotal 3,279,168.67 CA LAIF 29,749,581.47 100.0000000 Subtotal 29,749, 581.47 CA Asset Management Program Subtotal Union Bank Custody Acct. Subtotal 1, 016, 685.49 100.0000000 1,016,685.49 12, 052.56 100.0000000 020061-3N1 1527 001 Ally Bank 245,000.00 100.0000000 0606247A5 1454 001 Bank of Baroda 248,000.00 100.0000000 06653ABM5 1533 001 BankVista 245,000.00 100.0000000 14042RGN5 1552 001 Capital One NA 245,000.00 100.0000000 1404203Q1 1553 001 Capital One Bank USA, NA 245,000.00 100.0000000 169894AN2 1529 001 Chippewa Valley Bank 245,000.00 100.0000000 17284C5K6 1487 001 CIT Bank 248,000.00 100.0000000 17670DAC8 1530 001 Citizens State Bankl 245,000.00 100.0000000 17801 GSB7 1551 001 City National Bank Metropolis 245,000.00 100.0000000 254672CB2 1477 001 Discovery Bank 248,000.00 100.0000000 337630BD8 1531 001 Firstrust Savings Bank 245,000.00 100.0000000 38148PKX4 1528 001 Goldman Sachs Bank USA 245,000.00 100.0000000 8562843F9 1484 001 State Bank of India 248,000.00 100.0000000 56585YAB6 1532 001 Marathon Savings Bank 245,000.00 100.0000000 87164YEB6 1478 001 Synchrony Bank 248,000.00 100.0000000 Data Updated: SET QTR: 01/23/2018 19:29 Run Date: 01/23/2018 - 19:29 No fiscal year history available 3,279,168.67 3,279,168.67 29,749,581.47 1.300 29,749,581.47 1,016,685.49 1.290 1,016,685.49 12,052.56 0.940 12,052.56 245,000.00 1.900 06/22/2020 248,000.00 2.050 11/13/2018 245,000.00 2.000 06/30/2022 245,000.00 2.300 07/19/2022 245,000.00 2.300 07/19/2022 245,000.00 1.700 06/30/2020 248,000.00 2.200 12/10/2019 245, 000.00 1.900 12/30/2021 245,000.00 2.000 02/03/2022 248,000.00 1.800 10/22/2018 245,000.00 1.900 06/23/2021 245,000.00 2.350 06/21/2022 248,000.00 2.000 12/05/2018 245,000.00 1.700 06/29/2020 248,000.00 2.000 10/17/2019 Portfolio ENCI AC DT (PRF_DT) 7.1.1 Report Ver. 7.3.5 City of Encinitas - Qtr Inv Report CUSIP Investment # Fund Issuer Investments by Type December 31, 2017 Par Value Purchase Price Remaining Cost Current Rate Page 2 Maturity Call Call Date Date Price Certificates of Deposit - Bank 87270LAD5 1554 001 TIAA FSB 245,000.00 100.0000000 245,000.00 2.150 07/19/2022 949763JG2 1535 001 Wells Fargo Bank 245,000.00 100.0000000 245,000.00 2.250 06/30/2022 975875AK1 1526 001 Winter Hill Bank FSB 245,000.00 100.0000000 245,000.00 1.800 06/28/2021 Subtotal 4,425,000.00 4,425,000.00 Negotiable CDs 20033AUE4 1525 001 Comenity Capital Bank 245,000.00 100.0000000 245,000.00 1.750 06/19/2020 Subtotal 245,000.00 245,000.00 U.S. Treasury Coupon Securities 912828VK3 1491 001 U.S. Treasury Notes 2,000,000.00 100.7382815 2,014,765.63 1.375 06/30/2018 912828XK1 1509 001 U.S. Treasury Notes 2,000,000.00 99.7656425 1,995,312.85 0.875 07/15/2018 912828TH3 1510 001 U.S. Treasury Notes 2,000,000.00 98.9023440 1,978,046.88 0.875 07/31/2019 912828XM7 1514 001 U.S. Treasury Notes 2,000,000.00 101.9843750 2,039,687.50 1.625 07/31/2020 912828TNO 1515 001 U.S. Treasury Notes 2,000,000.00 99.8671875 1,997,343.75 1.000 08/31/2019 912828TV2 1516 001 U.S. Treasury Notes 2,000,000.00 100.5976565 2,011,953.13 1.250 10/31/2019 912828,150 1517 001 U.S. Treasury Notes 2,000,000.00 100.7812500 2,015,625.00 1.375 02/29/2020 912828,184 1518 001 U.S. Treasury Notes 2,000,000.00 100.7578125 2,015,156.25 1.375 03/31/2020 9128281-32 1520 001 U.S. Treasury Notes 2,000,000.00 99.2980000 1,985,960.00 1.375 08/31/2020 91282BL65 1521 001 U.S. Treasury Notes 2,000,000.00 99.2343750 1,984,687.50 1.375 09/30/2020 9128281-99 1522 001 U.S. Treasury Notes 2,000,000.00 99.1290000 1,982,580.00 1.375 10/31/2020 912828S76 1523 001 U.S. Treasury Notes 2,000,000.00 97.1830000 1,943,660.00 1.125 07/31/2021 912828A42 1538 001 U.S. Treasury Notes 2,000,000.00 101.4375000 2,028,750.00 2.000 11/30/2020 912828P87 1539 001 U.S. Treasury Notes 2,000,000.00 98.2812500 1,965,625.00 1.125 02/28/2021 912828Q37 1540 001 U.S. Treasury Notes 2,000,000.00 98.6718750 1,973,437.50 1.250 03/31/2021 Subtotal 30,000,000.00 29,932,590.99 Federal Agency Coupon Securities 3133EEM98 1496 001 Federal Farm Credit 2,000,000.00 99.9120000 1,998,240.00 1.000 05/21/2018 3133EHNX7 1534 001 Federal Farm Credit 2,000,000.00 99.7150000 1,994,300.00 1.650 06/21/2021 3133EHCT8 1536 001 Federal Farm Credit 2,000,000.00 101.4640000 2,029,280.00 2.150 03/15/2022 313OA53ZO 1493 001 Federal Home Loan Bank 2,000,000.00 99.9315000 1,998,630.00 1.050 10/23/2018 3130A5E54 1497 001 Federal Home Loan Bank 2,000,000.00 100.0000000 2,000,000.00 1.100 08/13/2018 3133782M2 1498 001 Federal Home Loan Bank 2,000,000.00 100.6610000 2,013,220.00 1.500 03/08/2019 313379EE5 1499 001 Federal Home Loan Bank 2,000,000.00 100.8820000 2,017,640.00 1.625 06/14/2019 313383HU8 1513 001 Federal Home Loan Bank 2,000,000.00 102.1217000 2,042,434.00 1.750 06/12/2020 Portfolio ENCI Data Updated: SET QTR: 01/23/2018 19:29 AC Run Date: 01/23/2018 -19:29 No fiscal year history available DT (PRF_DT) 7.1.1 Report Ver. 7.3.5 CUSIP Investment # Fund Issuer Federal Agency Coupon Securities 3130ABQS5 1524 001 3137EADP1 1492 001 3137EADR7 1512 001 3134G9N94 1537 001 3135GOZA4 1500 001 3135GOE33 1501 001 3135GOYM9 1503 001 3135GOTG8 1504 001 3135GOYT4 1505 001 3135GOZG1 1506 001 3135GOZY2 1507 001 City of Encinitas - Qtr Inv Report Investments by Type December 31, 2017 Purchase Par Value Price Federal Home Loan Bank Federal Home Loan Mortgage Federal Home Loan Mortgage Federal Home Loan Mortgage Federal Nat'l Mortgage Assoc. Federal Nat'I Mortgage Assoc. Federal Nat'l Mortgage Assoc. Federal Nat'l Mortgage Assoc. Federal Nat'l Mortgage Assoc. Federal Nat'l Mortgage Assoc. Federal NaCl Mortgage Assoc. Subtotal Total 2,000,000.00 97.1860000 2,000,000.00 99.5770000 2,000,000.00 100.9455000 2, 000, 000.00 100.6491000 2,000,000.00 101.7681000 2,000,000.00 99.8948000 2, 000, 000.00 102.0341000 2,000,000.00 99.7034000 2,000,000.00 101.1839000 2, 000, 000.00 100.6280000 2,000,000.00 100.4450000 38,000,000.00 106,727,488.19 Page 3 Current Maturity Call Call Remaining Cost Rate Date Date Price 1,943,720.00 1.125 07/14/2021 1,991,540.00 0.875 03/07/2018 2,018,910.00 1.375 05/01/2020 2,012,982.00 1.875 07/27/2021 2,035,362.00 1.875 02/19/2019 1,997,896.00 1.125 07/20/2018 2,040,682.00 1.875 09/18/2018 1,994,068.00 0.875 02/08/2018 2,023,678.00 1.625 11 /27/2018 2,012,560.00 1.750 09/12/2019 2, 008, 900.00 1.750 11 /26/2019 38,174,042.00 106,834,121.18 Portfolio ENCI Data Updated: SET _QTR: 01/23/2018 19:29 AC Run Date: 01/23/2018 -19:29 No fiscal year history available DT (PRF_DT) 7.1.1 Report Ver. 7.3.5