The URL can be used to link to this page

Quarterly Investment Report for 9 months ended 03-31-18CITY OF ENCINITAS INVESTMENT REPORT MEMORANDUM Nine Months ended March 31, 2018 TO: City Council � VIA: Karen P. Brust, City Manager FROM: Teresa S. McBroome, Director of Finance/City Treasurer lw4plll� DATE: June 6, 2018 SUBJECT: City of Encinitas Investment Report for the nine (9) months ended March 31, 2018 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 $112.7 million at March 31, 2018, compared to an average investable balance for the nine months ended March 31, 2018 of $105.1 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 monthly portfolio balance over the last five years. Monthly Portfolio Balance by Fiscal Year $125,000,000 $120,000,000 $115,000,000 $110,000,000 $105,000,000 -- _.....__._._ FY 17/18 $100,000,000 FY 16/17 $95,000,000 FY 15/16 $90,000,000 - — �- FY 14/15 $85,000,000 FY 13/14 I $ 80, 000,000 $ 75, 000,000 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 Local Agency Investment 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 $30.6 million at March 31, 2018. FY 2017-18 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Book Value $ 112,717,522 $ 108,724,220 $ 100,117,676 Market Value $ 111,688,801 $ 108,059,982 $ 99,859,075 Unrealized Gain/(Loss) $ (1,028,721) $ (664,238) $ (258,601) Unrealized Gain/Loss as % of Book Value -0.9127% -0.6109% -0.2583% Effective Rate of Return 1.37% 1.30% 1.28% Average Yield To Maturity 1.60% 1.36% 1.31% Average Maturity (Years) 1.58 1.40 1.67 Investment Earnings Yearto Date $ 1,079,219 $ 673,783 $ 337,542 The Pool earned $1,079,219 during the first nine months of FY 2017-18 for an annualized return of 1.37%. This compares to the City's adopted performance benchmark of the one (1) year constant maturity Treasury index which averaged a 1.56% yield over the nine months ended March 31, 2018. 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 578 days or 1.58 years.) The 2 yr. T-note averaged a 1.35% yield for the nine months ended March 31, 2018. City Portfolio Yield Compared to Treasury Indexes 2.50 % 2.00 % — X 1.50% .' '✓r 1.00% „ . 0.50% 0.00% ::ec .......r Rt � 0 M Ln Ln W W W W N N r1% N W C O. u z'- C C. u i t U. C 6. U 7 7 GJ Gl 7 W0 M y y to o g 4 (n o g in o g 0 o � City Portfolio 2 YrTreasury 1 Yr Treasury — — — 6 Mth Treasury The market value of the City's direct investments is less than their carrying value by $192,738 as of March 31, 2017 meaning that the portfolio has 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 Investments Local Agency Investment Funds Managed Pool Accounts Money Market Funds Certificates of Deposit - Bank Negotiable CDs U.S. Treasury Coupon Securities Federal Agency Coupon Securities Investments Cash Passbook/Checking (not included in yield calculations) Total Cash and Investments Par Value 28,320,780.24 1,020,207.10 24,490.21 6,153,000.00 245,000.00 32,000,000.00 44,000,000.00 111,763,477.55 1,293,954.03 113,057,431.58 City of Encinitas - Qtr Inv Report Portfolio Management Portfolio Summary March 31, 2018 Market Value Book % of Value Portfolio CITY OF ENCINITAS 505 S. VULCAN ENCINITAS, ENCINITAS, CA 9 (760)633-2641 YTM Term Days to Maturity 28,320,780.24 28,320,780.24 25.42 1.590 1 1 1,020,207.10 1,020,207.10 0.92 1.620 1 1 24,490.21 24,490.21 0.02 1.500 1 1 6,079,629.77 6,153,000.00 5.52 2.257 1,667 1,262 240,678.20 245,000.00 0.22 1.750 1,095 810 31,326,924.73 31,849,305.67 28.58 1.421 1,316 774 43,382,136.95 43,810,784.84 39.32 1.634 1,373 725 110,394,847.20 111,423,568.06 100.00% 1.596 1,011 578 1,293,954.03 111,688,801.23 1,293,954.03 112,717,522.09 0.000 1 1.596 1,011 Total Earnings March 31 Period Ending Current Year 1,079,219.48 Average Daily Balance 105,148,312.85 Effective Rate of Return 1.37% 1 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-03/31/2018 Data Updated: SET_QTR: 04/19/2018 18:00 Run Date: 04/19/2018 -18:00 No fiscal year history available 1 578 Portfolio ENCI AC PM (PRF_PM1) 7.3.0 Report Ver. 7.3.5 City of Encinitas - Qtr Inv Report Portfolio Management Portfolio Details - Investments March 31, 2018 Page 1 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 28,320,780.24 28,320,780.24 28,320,780.24 1.590 1.590 NR Subtotal and Average 26,160,141.13 28,320,780.24 28,320,780.24 28,320,780.24 1.590 Managed Pool Accounts SYS1003 1003 CA Asset Management Program Subtotal and Average 1,015,784.18 Money Market Funds SYS1004 1004 Union Bank Custody Acct. Subtotal and Average 738,836.45 Certificates of Deposit - Bank 254672CB2 1477 0606247A5 1454 8562843F9 1484 87164YEB6 1478 17284C5K6 1487 020061-3N1 1527 56585YA136 1532 169894AN2 1529 337630BDB 1531 975875AK1 1526 17670DAC8 1530 17801GSB7 1551 38148PKX4 1528 06653ABM5 1533 949763JG2 1535 14042RGN5 1552 1404203Q1 1553 87270LAD5 1554 58404DBL4 1561 05580AMB7 1562 17312QH69 1563 29278TAU4 1568 45581EASO 1564 501798LT7 1566 1,020,207.10 1,020,207.10 24,490.21 24,490.21 1,020,207.10 1,020,207.10 24,490.21 24,490.21 1,020,207.10 1.620 1.620 AAA 1,020,207.10 1.620 24,490.21 1.500 1.500 AAA 24,490.21 1.500 Discovery Bank 10/22/2014 248,000.00 247,972.72 248,000.00 1.800 1.800 NR NR 10/22/2018 Bank of Baroda 11/12/2013 248,000.00 248,148.80 248,000.00 2.050 2.050 NR NR 11/13/2018 State Bank of India 12/05/2014 248,000.00 248,019.84 248,000.00 2.000 2.000 NR NR 12/05/2018 Synchrony Bank 10/17/2014 248,000.00 247,089.84 248,000.00 2.000 2.000 NR NR 10/17/2019 CIT Bank 12/10/2014 248,000.00 247,169.20 248,000.00 2.200 2.200 NR NR 12/10/2019 Ally Bank 06/22/2017 245,000.00 241,464.65 245,000.00 1.900 1.900 06/22/2020 Marathon Savings Bank 06/28/2017 245,000.00 240,342.55 245,000.00 1.700 1.700 06/29/2020 Chippewa Valley Bank 06/30/2017 245,000.00 240,340.10 245,000.00 1.700 1.700 06/30/2020 Firstrust Savings Bank 06/23/2017 245,000.00 239,154.30 245,000.00 1.900 1.900 06/23/2021 Winter Hill Bank FSB 06/26/2017 245,000.00 238,360.50 245,000.00 1.800 1.800 06/28/2021 Citizens State Bankl 06/30/2017 245,000.00 237,919.50 245,000.00 1.900 1.900 12/30/2021 City National Bank Metropolis 07/03/2017 245,000.00 238,576.10 245,000.00 2.000 2.000 NR NR 02/03/2022 Goldman Sachs Bank USA 06/21/2017 245,000.00 241,006.50 245,000.00 2.350 2.350 P-1 06/21/2022 BankVista 06/30/2017 245,000.00 237,505.45 245,000.00 2.000 2.000 06/30/2022 Wells Fargo Bank 06/30/2017 245,000.00 238,157.15 245,000.00 2.250 2.250 06/30/2022 Capital One NA 07/19/2017 245,000.00 240,345.00 245,000.00 2.300 2.300 NR 07/19/2022 Capital One Bank USA, NA 07/19/2017 245,000.00 240,345.00 245,000.00 2.300 2.300 07/19/2022 TIAA FSB 07/19/2017 245,000.00 238,860.30 245,000.00 2.150 2.150 NR NR 07/19/2022 Medallion Bank UT 03/28/2018 249,000.00 249,455.67 249,000.00 2.900 2.900 03/28/2023 BMW Bank North America 03/29/2018 246,000.00 246,445.26 246,000.00 2.900 2.900 03/29/2023 Citi Bank NA 03/29/2018 246,000.00 245,874.54 246,000.00 2.850 2.850 03/29/2023 Enerbank USA 03/29/2018 246,000.00 245,874.54 246,000.00 2.850 2.850 03/29/2023 Industrial & Comm Bank China 03/29/2018 249,000.00 249,453.18 249,000.00 2.900 2.900 03/29/2023 LCA Bank Corp 03/29/2018 246,000.00 245,303.82 246,000.00 2.800 2.800 03/29/2023 Data Updated: SET _QTR: 04/19/2018 18:00 Run Date: 04/19/2018 - 18:00 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 March 31, 2018 Page 2 Average Purchase Stated YTM Maturity CUSIP Investment # Issuer Balance Date Par Value Market Value Book Value Rate S&P Moody's Date Certificates of Deposit - Bank 61747MR37 1565 Morgan Stanley Bank 03/29/2018 246,000.00 246,445.26 246,000.00 2.900 2.900 03/29/2023 Subtotal and Average 4,640,945.26 6,153,000.00 6,079,629.77 6,153,000.00 2.257 Negotiable CDs 20033AUE4 1525 Comenity Capital Bank 06/20/2017 245,000.00 240,678.20 245,000.00 1.750 1.750 06/19/2020 Subtotal and Average 245,000.78 245,000.00 240,678.20 245,000.00 1.750 U.S. Treasury Coupon Securities 912828VK3 1491 U.S. Treasury Notes 02/20/2015 2,000,000.00 1,997,840.00 2,001,083.94 1.375 1.150 AA+ Aaa 06/30/2018 912828XK1 1509 U.S. Treasury Notes 01/27/2016 2,000,000.00 1,994,580.00 1,999,453.17 0.875 0.971 Aaa 07/15/2018 912828TH3 1510 U.S. Treasury Notes 01/27/2016 2,000,000.00 1,965,620.00 1,991,671.18 0.875 1.195 Aaa 07/31/2019 912828TNO 1515 U.S. Treasury Notes 06/01/2016 2,000,000.00 1,966,180.00 1,998,842.09 1.000 1.042 Aaa 08/31/2019 912828TV2 1516 U.S. Treasury Notes 06/01/2016 2,000,000.00 1,969,300.00 2,005,540.42 1.250 1.071 Aaa 10/31/2019 912828,150 1517 U.S. Treasury Notes 06/01/2016 2,000,000.00 1,966,020.00 2,007,983.83 1.375 1.161 Aaa 02/29/2020 912828,184 1518 U.S. Treasury Notes 06/01/2016 2,000,000.00 1,963,900.00 2,007,908.55 1.375 1.172 Aaa 03/31/2020 912828XM7 1514 U.S. Treasury Notes 04/19/2016 2,000,000.00 1,967,900.00 2,021,620.04 1.625 1.149 NR Aaa 07/31/2020 9128281-32 1520 U.S. Treasury Notes 02/13/2017 2,000,000.00 1,954,220.00 1,990,426.78 1.375 1.580 Aaa 08/31/2020 91282BL65 1521 U.S. Treasury Notes 02/13/2017 2,000,000.00 1,952,260.00 1,989,448.82 1.375 1.593 Aaa 09/30/2020 9128281-99 1522 U.S. Treasury Notes 02/13/2017 2,000,000.00 1,950,460.00 1,987,872.80 1.375 1.618 Aaa 10/31/2020 912828A42 1538 U.S. Treasury Notes 06/28/2017 2,000,000.00 1,980,860.00 2,022,384.09 2.000 1.567 Aaa 11/30/2020 912828P87 1539 U.S. Treasury Notes 06/28/2017 2,000,000.00 1,928,760.00 1,972,725.58 1.125 1.609 Aaa 02/28/2021 912828Q37 1540 U.S. Treasury Notes 06/28/2017 2,000,000.00 1,933,760.00 1,978,800.34 1.250 1.616 Aaa 03/31/2021 912828S76 1523 U.S. Treasury Notes 02/13/2017 2,000,000.00 1,915,700.00 1,957,909.28 1.125 1.784 Aaa 07/31/2021 912828T34 1556 U.S. Treasury Notes 02/23/2018 2,000,000.00 1,919,564.73 1,915,634.76 1.125 2.530 Aaa 09/30/2021 Subtotal and Average 31,745,047.87 32,000,000.00 31,326,924.73 31,849,305.67 1.421 Federal Agency Coupon Securities 3133EEM98 1496 Federal Farm Credit 05/27/2015 2,000,000.00 1,997,940.00 1,999,918.06 1.000 1.030 AA- Aaa 05/21/2018 3135GOE33 1501 Federal Nat'l Mortgage Assoc. 06/24/2015 2,000,000.00 1,995,600.00 1,999,792.64 1.125 1.160 AAA Aaa 07/20/2018 313OA5E54 1497 Federal Home Loan Bank 05/27/2015 2,000,000.00 1,993,700.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 1,998,900.00 2,005,846.72 1.875 1.230 AAF Aaa 09/18/2018 313OA53ZO 1493 Federal Home Loan Bank 04/24/2015 2,000,000.00 1,989,300.00 1,999,780.19 1.050 1.070 AA+ Aaa 10/2312018 3135GOYT4 1505 Federal Nat'l Mortgage Assoc. 06/26/2015 2,000,000.00 1,994,820.00 2,004,539.41 1.625 1.270 AAF Aaa 11/27/2018 3135GOZA4 1500 Federal Nat'l Mortgage Assoc. 06/24/2015 2,000,000.00 1,995,540.00 2,008,551.42 1.875 1.377 AA+ Aaa 02/19/2019 3133782M2 1498 Federal Home Loan Bank 05/27/2015 2,000,000.00 1,988,080.00 2,003,273.43 1.500 1.320 AAF Aaa 03/08/2019 313379EE5 1499 Federal Home Loan Bank 05/27/2015 2,000,000.00 1,986,840.00 2,005,242.36 1.625 1.400 AA+ Aaa 06/14/2019 Data Updated: SET _QTR: 04/19/2018 18:00 Run Date: 04/19/2018 - 18:00 Portfolio ENCI AC PM (PRF_PM2) 7.3.0 City of Encinitas - Qtr Inv Report Portfolio Management Portfolio Details - Investments March 31, 2018 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 3137EAEB1 1559 Federal Home Loan Mortgage 02/23/2018 2,000,000.00 1,967,312.78 1,968,911.28 0.875 2.160 AA+ Aaa 07/19/2019 3135GOZG1 1506 Federal Nat'l Mortgage Assoc. 06/26/2015 2,000,000.00 1,985,760.00 2,004,316.46 1.750 1.595 AA+ Aaa 09/12/2019 3135GOZY2 1507 Federal Nat'l Mortgage Assoc. 06/26/2015 2,000,000.00 1,983,420.00 2,003,330.50 1.750 1.645 AA+ Aaa 11126/2019 3137EADR7 1512 Federal Home Loan Mortgage 04/19/2016 2,000,000.00 1,961,020.00 2,009,767.56 1.375 1.134 AA+ Aaa 05/01/2020 313383HU8 1513 Federal Home Loan Bank 04/19/2016 2,000,000.00 1,971,240.00 2,022,481.78 1.750 1.224 AA+ Aaa 06/12/2020 3133EHNX7 1534 Federal Farm Credit 06/21/2017 2,000,000.00 1,942,900.00 1,995,408.33 1.650 1.724 06/21/2021 313OA8QS5 1524 Federal Home Loan Bank 02/13/2017 2,000,000.00 1,916,160.00 1,958,152.58 1.125 1.790 AA+ Aaa 07/14/2021 3134G9N94 1537 Federal Home Loan Mortgage 06/23/2017 2,000,000.00 1,958,220.00 2,010,533.56 1.875 1.710 AA+ Aaa 07/27/2021 3137EAEC9 1557 Federal Home Loan Mortgage 02/23/2018 2,000,000.00 1,911,227.50 1,913,033.98 1.125 2.493 AA+ Aaa 08/12/2021 3130AABG2 1555 Federal Home Loan Bank 02/23/2018 2,000,000.00 1,964,250.00 1,963,932.17 1.875 2.520 AA+ Aaa 11/29/2021 3133EHCT8 1536 Federal Farm Credit 06/23/2017 2,000,000.00 1,962,260.00 2,024,497.49 2.150 1.825 AA+ Aaa 03/15/2022 3134GSAX3 1560 Federal Home Loan Mortgage 02/23/2018 2,000,000.00 1,981,926.67 1,976,641.59 2.220 2.580 AA+ Aaa 07/01/2022 3133EC4Q4 1558 Federal Farm Credit 02/23/2018 2,000,000.00 1,935,720.00 1,932,833.33 1.820 2.700 AA+ Aaa 11/23/2022 Subtotal and Average 40,471,248.01 44,000,000.00 43,382,136.95 43,810,784.84 1.634 Total and Average 105,148,312.85 111,763,477.55 110,394,847.20 111,423,568.06 1.596 Portfolio ENCI Data Updated: SET_QTR: 04/19/2018 18:00 AC Run Date: 04/19/2018 -18:00 PM (PRF_PM2) 7.3.0 City of Encinitas - Qtr Inv Report Portfolio Management Portfolio Details - Cash March 31, 2018 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. 1,293,954.03 1,293,954.03 1,293,954.03 0.000 Average Balance 0.00 Total Cash and Investments 105,148,312.85 113,057,431.58 111,688,801.23 112,717,522.09 1.596 Page 4 Data Updated: SET_QTR: 04/19/2018 18:00 Portfolio ENCIAC Run Date: 04/19/2018 - 18:00 PM (PRF_PM2) 7.3.0 City of Encinitas - Qtr Inv Report Portfolio Management Activity By Type July 1, 2017 through March 31, 2018 Page 1 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. 35,978,712.95 37,300,554.97 Subtotal 35,978,712.95 37,300,554.97 0.00 Local Agency Investment Funds (Monthly Summary) SYS1012 1012 CA LAIF 1.590 29,024,791.31 31,250,000.00 Subtotal 29,024,791.31 31,250,000.00 28,320,780.24 Managed Pool Accounts (Monthly Summary) SYS1003 1003 CA Asset Management Program Subtotal Money Market Funds (Monthly Summary) SYS1004 1004 Union Bank Custody Acct. Subtotal Certificates of Deposit - Bank 02587DLV8 1438 05580AMB7 1562 14042RGN5 1552 1404203Q1 1553 17312QH69 1563 17801 GSB7 1551 29278TAU4 1568 45083ADZ2 1482 45581EASO 1564 501798LT7 1566 58404DBL4 1561 61747MR37 1565 87270LAD5 1554 Negotiable CDs U.S. Treasury Coupon Securities American Express Centurion BMW Bank North America Capital One NA Capital One Bank USA, NA Citi Bank NA City National Bank Metropolis Enerbank USA Iberia Bank/LA Industrial & Comm Bank China LCA Bank Corp Medallion Bank UT Morgan Stanley Bank TIAA FSB Subtotal Subtotal 1.620 1.500 1.500 2.900 2.300 2.300 2.850 2.000 2.850 1.200 2.900 2.800 2.900 2.900 2.150 10/25/2017 03/29/2018 07/19/2017 07/19/2017 03/29/2018 07/03/2017 03/29/2018 12/04/2017 03/29/2018 03/29/2018 03/28/2018 03/29/2018 07/19/2017 9,297.10 9,297.10 26,982,165.08 26,982,165.08 0.00 246,000.00 245,000.00 245,000.00 246,000.00 245,000.00 246,000.00 0.00 249,000.00 246,000.00 249,000.00 246,000.00 245,000.00 2,708,000.00 0.00 0.00 27,020,148.25 27,020,148.25 248,000.00 0.00 0.00 0.00 0.00 0.00 0.00 248,000.00 0.00 0.00 0.00 0.00 0.00 496,000.00 1,020,207.10 24,490.21 6,153,000.00 245,000.00 Portfolio ENCI Data Updated: SET QTR: 04/19/2018 18:00 AC Run Date: 04/19/2018 - 18:00 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 March 31, 2018 Stated Transaction Purchases Redemptions CUSIP Investment # Issuer Rate Date or Deposits or Withdrawals Balance Page 2 U.S. Treasury Coupon Securities 912828UE8 1490 912828TG5 1511 912828T34 1556 U.S. Treasury Notes U.S. Treasury Notes U.S. Treasury Notes Subtotal 0.750 0.500 1.125 12/31/2017 07/31/2017 02/23/2018 0.00 0.00 1,903,906.25 1,903,906.25 2,000,000.00 2,000,000.00 0.00 4,000,000.00 31,849,305.67 Federal Agency Coupon Securities 3133EDSU7 1508 Federal Farm Credit 1.000 08/15/2017 0.00 1,000,000.00 3133EC4Q4 1558 Federal Farm Credit 1.820 02/23/2018 1,922,000.00 0.00 313OA4TR3 1495 Federal Home Loan Bank 0.875 10/16/2017 0.00 2,000,000.00 3130AABG2 1555 Federal Home Loan Bank 1.875 02/23/2018 1,953,890.00 0.00 3137EADP1 1492 Federal Home Loan Mortgage 0.875 03/07/2018 0.00 2,000,000.00 3137EAEC9 1557 Federal Home Loan Mortgage 1.125 02/23/2018 1,909,596.00 0.00 3137EAEB1 1559 Federal Home Loan Mortgage 0.875 02/23/2018 1,964,600.00 0.00 3134GSAX3 1560 Federal Home Loan Mortgage 2.220 02/23/2018 1,970,500.00 0.00 3136GOZH7 1480 Federal Nat'l Mortgage Assoc. 1.050 09/05/2017 0.00 2,000,000.00 3136GOYE5 1494 Federal Nat'l Mortgage Assoc. 1.000 08/28/2017 0.00 1,000,000.00 3135GOTG8 1504 Federal Nat'l Mortgage Assoc. 0.875 02/08/2018 0.00 2,000,000.00 Subtotal 9,720,586.00 10,000,000.00 43,810,784.84 Total 106,327,458.69 110,066,703.22 111,423,568.06 Portfolio ENCI Data Updated: SET_QTR: 04/19/2018 18:00 AC Run Date: 04/19/2018 - 18:00 PM (PRF_PM3) 7.3.0 City of Encinitas - Qtr Inv Report Portfolio Management Page 1 Interest Earnings Summary March 31, 2018 March 31 Month Ending Fiscal Year To Date CD/Coupon/Discount Investments: Interest Collected 830,178.56 830,178.56 Plus Accrued Interest at End of Period 288,354.78 288,354.78 Less Accrued Interest at Beginning of Period ( 266,111.32) ( 266,111.32) Less Accrued Interest at Purchase During Period ( 34,641.68) ( 34,641.68) Interest Earned during Period 817,780.34 817,780.34 Adjusted by Premiums and Discounts -7,556.95 -7,556.95 Adjusted by Capital Gains or Losses 0.00 0.00 Earnings during Periods 810,223.39 810,223.39 Pass Through Securities: Interest Collected 0.00 0.00 Plus Accrued Interest at End of Period 0.00 0.00 Less Accrued Interest at Beginning of Period ( 0.00) ( 0.00) Less Accrued Interest at Purchase During Period ( 0.00) ( 0.00) Interest Earned during Period 0.00 0.00 Adjusted by Premiums and Discounts 0.00 0.00 Adjusted by Capital Gains or Losses 0.00 0.00 Earnings during Periods 0.00 0.00 Cash/Checking Accounts: Interest Collected 239,690.48 239,690.48 Plus Accrued Interest at End of Period 121,037.41 121,037.41 Less Accrued Interest at Beginning of Period ( 91,731.80) ( 91,731.80) Interest Earned during Period 268,996.09 268,996.09 Total Interest Earned during Period 1,086,776.43 1,086,776.43 Total Adjustments from Premiums and Discounts -7,556.95 -7,556.95 Total Capital Gains or Losses 0.00 0.00 Total Earnings during Period 1,079,219.48 1,079,219.48 Portfolio ENCI Data Updated: SET_QTR: 04/19/2018 18:00 AC Run Date: 04/19/2018 - 18:00 No fiscal year history available PM (PRF_PM6) 7.3.0 Report Ver. 7.3.5 City of Encinitas - Qtr Inv Report CITY OF ENCINITAS 505 S. VULCAN Investments by Issuer ENCINITAS, ENCINITAS, CA 9 Active Investments (760)633-2641 Sorted by Fund March 31, 2018 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 020061-3N1 1527 Certificates of Deposit - Bank Amort 245,000.00 1.900 241,464.65 03/31/2018 1.900 06/22/2020 813 Subtotal and Average 245,000.00 241,464.65 1.900 813 Bank of Baroda 0606247A5 1454 Certificates of Deposit - Bank Amort 248,000.00 2.050 248,148.80 03/31/2018 2.050 11/13/2018 226 Subtotal and Average 248,000.00 248,148.80 2.050 226 BankVista 06653ABM5 1533 Certificates of Deposit - Bank Amort 245,000.00 2.000 237,505.45 03/31/2018 2.000 06/30/2022 1,551 Subtotal and Average 245,000.00 237,505.45 2.000 1,551 BMW Bank North America 05580AMB7 1562 Certificates of Deposit - Bank Amort 246,000.00 2.900 246,445.26 03/31/2018 2.900 03/29/2023 1,823 Subtotal and Average 246,000.00 246,445.26 2.900 1,823 CA Asset Management Program SYS1003 1003 Managed Pool Accounts Amort 1,020,207.10 1.620 1,020,207.10 03/31/2018 1.620 1 Subtotal and Average 1,020,207.10 1,020,207.10 1.620 1 Capital One NA 14042RGN5 1552 Certificates of Deposit - Bank Amort 245,000.00 2.300 240,345.00 03/31/2018 2.300 07/19/2022 1,570 Subtotal and Average 245,000.00 240,345.00 2.300 1,570 Capital One Bank USA, NA 1404203Q1 1553 Certificates of Deposit - Bank Amort 245,000.00 2.300 240,345.00 03/31/2018 2.300 07/19/2022 1,570 Subtotal and Average 245,000.00 240,345.00 2.300 1,570 Chippewa Valley Bank 169894AN2 1529 Certificates of Deposit - Bank Amort 245,000.00 1.700 240,340.10 03/31/2018 1.700 06/30/2020 821 Subtotal and Average 245,000.00 240,340.10 1.700 821 Portfolio ENCI Data Updated: SET _QTR: 04/19/2018 18:00 AC Run Date: 04/19/2018 - 18:00 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 2 Investment Current Market YTM Redemption Days To Call CUSIP Investment # Security Type Class Book Value Rate Market Value Date 365 Date Maturity Date Collateral CIT Bank 17284C5K6 1487 Certificates of Deposit - Bank Amort 248,000.00 2.200 247,169.20 03/31/2018 2.200 12/10/2019 618 Subtotal and Average 248,000.00 247,169.20 2.200 618 Citi Bank NA 17312QH69 1563 Certificates of Deposit - Bank Amort 246,000.00 2.850 245,874.54 03/31/2018 2.890 03/29/2023 1,823 Subtotal and Average 246.000.00 245.87a sa 2 aon C99 Citizens State Bankl 17670DAC8 1530 City National Bank Metropolis 17801GSB7 1551 Comenity Capital Bank 20033AUE4 1525 Discovery Bank 254672CB2 1477 Enerbank USA 29278TAU4 1568 Federal Farm Credit 3133EEM98 1496 3133EHNX7 1534 3133EHCT8 1536 3133EC404 1558 Federal Home Loan Bank Certificates of Deposit - Bank Amort 245,000.00 1.900 Subtotal and Average 245,000.00 Certificates of Deposit - Bank Amort 245,000.00 2.000 Subtotal and Average 245,000.00 Negotiable CDs Amort 245,000.00 1.750 Subtotal and Average 245,000.00 Certificates of Deposit - Bank Amort 248,000.00 1.800 Subtotal and Average 248,000.00 Certificates of Deposit - Bank Amort 246,000.00 2.850 Subtotal and Average 246,000.00 Federal Agency Coupon Securities Fair Federal Agency Coupon Securities Fair Federal Agency Coupon Securities Fair Federal Agency Coupon Securities Fair Subtotal and Average 1,999,918.06 1.000 1,995,408.33 1.650 2,024,497.49 2.150 1,932,833.33 1.820 7,952,657.21 237,919.50 03/31/2018 237,919.50 1.900 1.900 12/30/2021 1,369 1,369 238,576.10 03/31/2018 2.000 02/03/2022 1,404 238,576.10 2.000 1,404 240,678.20 03/31/2018 1.775 06/19/2020 810 240,678.20 1.775 810 247,972.72 03/31/2018 1.800 10/22/2018 204 247,972.72 1.800 204 245,874.54 03/31/2018 2.850 03/29/2023 1,823 245,874.54 2.850 1,823 1,997,940.00 03/31/2018 1.030 05/21/2018 50 1,942,900.00 03/31/2018 1.724 06/21/2021 1,177 1,962,260.00 03/31/2018 1.825 03/15/2022 1,444 1,935,720.00 03/31/2018 2.700 11/23/2022 1,697 7,838,820.00 1.812 1,087 Portfolio ENCI Data Updated: SET QTR: 04/19/2018 18:00 AC Run Date: 04/19/2018 - 18:00 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 313OA53ZO 1493 Federal Agency Coupon Securities Fair 1,999,780.19 1.050 1,989,300.00 03/31/2018 1.070 10/23/2018 205 313OA5E54 1497 Federal Agency Coupon Securities Fair 2,000,000.00 1.100 1,993,700.00 03/31/2018 1.100 08/13/2018 134 3133782M2 1498 Federal Agency Coupon Securities Fair 2,003,273.43 1.500 1,988,080.00 03/31/2018 1.320 03/08/2019 341 313379EE5 1499 Federal Agency Coupon Securities Fair 2,005,242.36 1.625 1,986,840.00 03/31/2018 1.400 06/14/2019 439 313383HU8 1513 Federal Agency Coupon Securities Fair 2,022,481.78 1.750 1,971,240.00 03/31/2018 1.224 06/12/2020 803 313OA8QS5 1524 Federal Agency Coupon Securities Fair 1,958,152.58 1.125 1,916,160.00 03/31/2018 1.790 07/14/2021 1,200 3130AABG2 1555 Federal Agency Coupon Securities Fair 1,963,932.17 1.875 1,964,250.00 03/31/2018 2.520 11/29/2021 1,338 Subtotal and Average 13,952,862.51 13,809,570.00 1.485 633 Federal Home Loan Mortgage 3137EADR7 1512 Federal Agency Coupon Securities Fair 2,009,767.56 1.375 1,961,020.00 03/31/2018 1.134 05/01/2020 761 3134G9N94 1537 Federal Agency Coupon Securities Fair 2,010,533.56 1.875 1,958,220.00 03/31/2018 1.710 07/27/2021 1,213 3137EAEC9 1557 Federal Agency Coupon Securities Fair 1,913,033.98 1.125 1,911,227.50 03/31/2018 2.493 08/12/2021 1,229 3137EAEB1 1559 Federal Agency Coupon Securities Fair 1,968,911.28 0.875 1,967,312.78 03/31/2018 2.160 07/19/2019 474 3134GSAX3 1560 Federal Agency Coupon Securities Fair 1,976,641.59 2.220 1,981,926.67 03/31/2018 2.580 07/01/2022 1,552 07/01/2020 Subtotal and Average 9,878,887.97 9,779,706.95 2.008 1,044 Firstrust Savings Bank 337630BD8 1531 Certificates of Deposit - Bank Amort Subtotal and Average 245,000.00 245,000.00 1.900 239,154.30 03/31/2018 239,154.30 1.900 1.900 06/23/2021 1,179 1,179 Federal Nat'l Mortgage Assoc. 3135GOZA4 1500 Federal Agency Coupon Securities Fair 2,008,551.42 1.875 1,995,540.00 03/31/2018 1.377 02/19/2019 324 3135GOE33 1501 Federal Agency Coupon Securities Fair 1,999,792.64 1.125 1,995,600.00 03/31/2018 1.160 07/20/2018 110 3135GOYM9 1503 Federal Agency Coupon Securities Fair 2,005,846.72 1.875 1,998,900.00 03/31/2018 1.230 09/18/2018 170 3135GOYT4 1505 Federal Agency Coupon Securities Fair 2,004,539.41 1.625 1,994,820.00 03/31/2018 1.270 11/27/2018 240 3135GOZG1 1506 Federal Agency Coupon Securities Fair 2,004,316A6 1.750 1,985,760.00 03/31/2018 1.595 09/12/2019 529 3135GOZY2 1507 Federal Agency Coupon Securities Fair 2.003,330.50 1.750 1,983,420.00 03/31/2018 1.645 11/26/2019 604 Subtotal and Average 12,026,377.15 11,954,040.00 1.380 329 Goldman Sachs Bank USA 38148PI0C4 1528 Certificates of Deposit - Bank Amort 245,000.00 2.350 241,006.50 03/31/2018 2.350 06/21/2022 1,542 Subtotal and Average 245,000.00 241,006.50 2.350 1,542 State Bank of India 8562843F9 1484 Certificates of Deposit - Bank Amort 248,000.00 2.000 248,019.84 03/31/2018 2.000 12/05/2018 248 Portfolio ENCI Data Updated: SET _QTR: 04/19/2018 18:00 AC Run Date: 04/19/2018 - 18:00 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 4 Investment Current Market YTM Redemption Days To Call CUSIP Investment # Security Type Class Book Value Rate Market Value Date 365 Date Maturity Date Collateral Subtotal and Average 248,000.00 248,019.84 2.000 248 Industrial & Comm Bank China 45581EAS0 1564 Certificates of Deposit - Bank Amort 249,000.00 2.900 249,453.18 03/31/2018 2.900 03/29/2023 1,823 Subtotal and Average 249,000.00 249,453.18 2.900 1,823 CA LAIF SYS1012 1012 Local Agency Investment Funds Amort 28,320,780.24 1.590 28,320,780.24 03/31/2018 1.590 1 Subtotal and Average 28,320,780.24 28,320,780.24 1.590 1 LCA Bank Corp 501798LT7 1566 Certificates of Deposit - Bank Amort 246,000.00 2.800 245,303.82 03/31/2018 2.800 03/29/2023 1,823 Subtotal and Average 246,000.00 245,303.82 2.800 1,823 Marathon Savings Bank 56585YAB6 1532 Certificates of Deposit - Bank Amort 245,000.00 1.700 240,342.55 03/31/2018 1.700 06/29/2020 820 Subtotal and Average 245,000.00 240,342.55 1.700 820 Medallion Bank UT 58404DBL4 1561 Morgan Stanley Bank 61747MR37 1565 Synchrony Bank 87164YEB6 1478 TIAA FSB Certificates of Deposit - Bank Amort Subtotal and Average Certificates of Deposit - Bank Amort Subtotal and Average Certificates of Deposit - Bank Amort Subtotal and Average 249,000.00 2.900 249,000.00 246,000.00 2.900 246,000.00 248,000.00 2.000 248,000.00 87270LAD5 1554 Certificates of Deposit - Bank Amort 245,000.00 2.150 Subtotal and Average 245,000.00 Union Bank Checking Acct. SYS1010 1010 Passbook/Checking Accounts Amort 1,293,954.03 249,455.67 03/31/2018 2.900 03/28/2023 1,822 249,455.67 2.900 1,822 246,445.26 03/31/2018 2.900 03/29/2023 1,823 246,445.26 2.900 1,823 247,089.84 03/31/2018 2.000 10/17/2019 564 247,089.84 2.000 564 238,860.30 03/31/2018 2.150 07/19/2022 1,570 238,860.30 2.150 1,570 1,293,954.03 03/31/2018 1 Portfolio ENCI Data Updated: SET QTR: 04/19/2018 18:00 AC Run Date: 04/19/2018 - 18:00 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 5 Investment Current Market YTM Redemption Days To Call CUSIP Investment # Security Type Class Book Value Rate Market Value Date 365 Date Maturitx Date Collateral Subtotal and Average 1,293,954.03 1,293,954.03 1 Union Bank Custody Acct. SYS1004 1004 Money Market Funds Amort 24,490.21 1.500 24,490.21 03/31/2018 1.500 1 Subtotal and Average 24,490.21 24,490.21 1.500 1 U.S. Treasury Notes 912828VK3 1491 U.S. Treasury Coupon Securities Fair 2,001,083.94 1.375 1,997,840.00 03/31/2018 1.150 06/30/2018 90 912828XK1 1509 U.S. Treasury Coupon Securities Fair 1,999,453.17 0.875 1,994,580.00 03/31/2018 0.971 07/15/2018 105 912828TH3 1510 U.S. Treasury Coupon Securities Fair 1,991,671.18 0.875 1,965,620.00 03/31/2018 1.195 07/31/2019 486 912828XM7 1514 U.S. Treasury Coupon Securities Fair 2,021,620.04 1.625 1,967,900.00 03/31/2018 1.149 07/31/2020 852 912828TNO 1515 U.S. Treasury Coupon Securities Fair 1,998,842.09 1.000 1,966,180.00 03/31/2018 1.042 08/31/2019 517 912828TV2 1516 U.S. Treasury Coupon Securities Fair 2,005,540.42 1.250 1,969,300.00 03/31/2018 1.071 10/31/2019 578 912828.150 1517 U.S. Treasury Coupon Securities Fair 2,007,983.83 1.375 1,966,020.00 03/31/2018 1.161 02/29/2020 699 912828J84 1518 U.S. Treasury Coupon Securities Fair 2,007,908.55 1.375 1,963,900.00 03/31/2018 1.172 03/31/2020 730 9128281-32 1520 U.S. Treasury Coupon Securities Fair 1,990,426.78 1.375 1,954,220.00 03/31/2018 1.580 08/31/2020 883 912828L65 1521 U.S. Treasury Coupon Securities Fair 1,989,448.82 1.375 1,952,260.00 03/31/2018 1.593 09/30/2020 913 9128281-99 1522 U.S. Treasury Coupon Securities Fair 1,987,872.80 1.375 1,950,460.00 03/31/2018 1.618 10/31/2020 944 912828S76 1523 U.S. Treasury Coupon Securities Fair 1,957,909.28 1.125 1,915,700.00 03/31/2018 1.784 07/31/2021 1,217 912828A42 1538 U.S. Treasury Coupon Securities Fair 2,022,384.09 2.000 1,980,860.00 03/31/2018 1.567 11/30/2020 974 912828P87 1539 U.S. Treasury Coupon Securities Fair 1,972,725.58 1.125 1,928,760.00 03/31/2018 1.609 02/28/2021 1,064 912828Q37 1540 U.S. Treasury Coupon Securities Fair 1,978,800.34 1.250 1,933,760.00 03/31/2018 1.616 03/31/2021 1,095 912828T34 1556 U.S. Treasury Coupon Securities Fair 1,915,634.76 1.125 1,919,564.73 03/31/2018 2.530 09/30/2021 1,278 Subtotal and Average 31,849,305.67 31,326,924.73 1.421 774 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 245,000.00 2.250 245,000.00 245,000.00 1.800 245,000.00 112,717,522.09 238,157.15 03/31/2018 2.250 06/30/2022 1,551 238,157.15 2.250 1,551 238,360.50 03/31/2018 1.800 06/28/2021 1,184 238,360.50 1.800 1,184 111,688,801.23 1.578 571 Portfolio ENCI Data Updated: SET _QTR: 04/19/2018 18:00 AC Run Date: 04/19/2018 -18:00 No fiscal year history available DI (PRF_DI) 7.1.1 Report Ver. 7.3.5 CITY OF ENCINITAS City of Encinitas - Qtr Inv Report 505 S. VULCAN Interest Earnings ENCINITAS, ENCINITAS, CA 9 Sorted by Fund - Fund (760)633-2641 July 1, 2017 - March 31, 2018 Yield on Beginning Book Value CUSIP Investment # Fund Security Type Ending Par Value Beginning Book Value Ending Maturity Book Value Date CurrentAnnualized Rate Yield Interest Earned Adjusted Interest Earnings Amortization/ Adjusted Interest Accretion Earnings Fund: General Investments SYS1012 1012 001 LA5 28,320,780.24 30,545,988.93 28,320,780.24 1.590 1.103 252,893.85 0.00 252,893.85 SYS1003 1003 001 LA1 1,020,207.10 1,010,910.00 1,020,207.10 1.620 1.295 9,830.74 0.00 9,830.74 SYS1004 1004 001 LA3 24,490.21 62,473.38 24,490.21 1.500 13.373 6,271.50 0.00 6,271.50 3130A4TR3 1495 001 FAG 0.00 2,000,316.59 0.0010/16/2017 0.875 0.816 5,104.17 -316.59 4,787.58 3133782M2 1498 001 FAC 2,000,000.00 2,005,896.06 2,003,273.43 03/08/2019 1.500 1.320 22,500.00 -2,622.63 19,877.37 3130A8QS5 1524 001 FAC 2,000,000.00 1,950,414.11 1,958,152.58 07/14/2021 1.125 1.805 16,875.00 9,550.97 26,425.97 313379EE5 1499 001 FAC 2,000,000.00 2,008,511.27 2,005,242.36 06/14/2019 1.625 1.400 24,375.00 -3,268.91 21,106.09 313383HU8 1513 001 FAC 2,000,000.00 2,030,155.71 2,022,481.78 06/12/2020 1.750 1.219 26,250.00 -7,673.93 18,576.07 313OA53Z0 1493 001 FAC 2,000,000.00 1,999,486.39 1,999,780.1910/23/2018 1.050 1.069 15,750.00 293.80 16,043.80 313OA5E54 1497 001 FAC 2,000,000.00 2,000,000.00 2,000,000.00 08/13/2018 1.100 1.099 16,500.00 0.00 16,500.00 3130AABG2 1555 001 FAC 2,000,000.00 0.00 1,963,932.1711/29/2021 1.875 2.651 3,958.33 1,292.17 5,250.50 3135GOTG8 1504 001 FAC 0.00 1,998,633.50 0.00 02/08/2018 0.875 0.980 10,548.61 1,366.50 11,915.11 3135GOZA4 1500 001 FAC 2,000,000.00 2,015,812.06 2,008,551.42 02/19/2019 1.875 1.379 28,125.00 -7,260.64 20,864.36 3135GOE33 1501 001 FAC 2,000,000.00 1,999,279.01 1,999,792.64 07/20/2018 1.125 1.159 16,875.00 513.63 17,388.63 3135GOYT4 1505 001 FAC 2,000,000.00 2,009,732.79 2,004,539.41 11/27/2018 1.625 1.271 24,375.00 -5,193.38 19,181.62 3135GOZY2 1507 001 FAC 2,000,000.00 2,004,841.82 2,003,330.5011/26/2019 1.750 1.644 26,250.00 -1,511.32 24,738.68 3135GOZG1 1506 001 FAC 2,000,000.00 2,006,553.40 2,004,316.46 09/12/2019 1.750 1.594 26,250.00 -2,236.94 24,013.06 3136GOZH7 1480 001 FAC 0.00 2,000,050.15 0.00 09/05/2017 1.050 1.018 3,733.33 -50.15 3,683.18 3135GOYM9 1503 001 FAC 2,000,000.00 2,015,299.51 2,005,846.72 09/18/2018 1.875 1.234 28,125.00 -9,452.79 18,672.21 3136130YE5 1494 001 FAC 0.00 1,000,344.39 0.00 08/28/2017 1.000 0.779 1,583.33 -344.39 1,238.94 3137EADR7 1512 001 FAC 2,000,000.00 2,013,283.88 2,009,767.56 05/01/2020 1.375 1.132 20,625.00 -3,516.32 17,108.68 3137EADP1 1492 001 FAC 0.00 1,998,049.52 0.00 03/07/2018 0.875 1.020 11,958.33 1,950.48 13,908.81 3137EAEB1 1559 001 FAC 2,000,000.00 0.00 1,968,911.28 07/19/2019 0.875 2.262 1,847.22 2,658.50 4,505.72 3134G9N94 1537 001 FAC 2,000,000.00 2,028,119.87 2,010,533.56 07/27/2021 1.875 1.691 28,125.00 -2,377.98 25,747.02 3137EAEC9 1557 001 FAG 2,000,000.00 0.00 1,913,033.98 08/12/2021 1.125 2.648 2,375.00 2,750.48 5,125.48 3134GSAX3 1560 001 FAC 2,000,000.00 0.00 1,976,641.59 07/01/2022 2.220 2.766 4,810.00 714.92 5,524.92 3133EHCT8 1536 001 FAC 2,000,000.00 2,040,847.93 2,024,497.49 03/15/2022 2.150 1.802 32,250.00 -4,644.88 27,605.12 3133EC4Q4 1558 001 FAC 2,000,000.00 0.00 1,932,833.3311/23/2022 1.820 2.862 3,842.22 1,733.33 5,575.55 3133EHNX7 1534 001 FAC 2,000,000.00 1,994,339.58 1,995,408.33 06/21/2021 1.650 1.725 24,750.00 1,068.75 25,818.75 3133EDSU7 1508 001 FAC 0.00 1,000,205.35 0.00 08/15/2017 1.000 0.825 1,222.22 -205.35 1,016.87 Portfolio ENCI Data Updated: SET_QTR: 04/19/2018 18:00 AC Run Date: 04/19/2018 - 18:00 No fiscal year history available IE (PRF_IE) 7.2.0 Report Ver. 7.3.5 City of Encinitas - Qtr Inv Report CUSIP Investment # Fund Security Type Ending Par Value Interest Earnings July 1, 2017 - March 31, 2018 Beginning Ending Maturity Book Value Book Value Date CurrentAnnualized Rate Yield Interest Earned Page 2 Adjusted Interest Earnings Amortization/ Adjusted Interest Accretion Earnings Fund: General Investments 3133EEM98 1496 001 FAC 2,000,000.00 1,999,475.61 1,999,918.06 05/21/2018 1.000 1.029 15,000.00 442.45 15,442.45 912828S76 1523 001 TRC 2,000,000.00 1,949,240.83 1,957,909.28 07/31/2021 1.125 1.799 16,843.92 9,476.46 26,320.38 9128281-99 1522 001 TRC 2,000,000.00 1,984,352.83 1,987,872.8010/31/2020 1.375 1.623 20,663.81 3,519.97 24,183.78 912828Q37 1540 001 TRC 2,000,000.00 1,979,574.81 1,978,800.34 03/31/2021 1.250 1.621 18,784.16 5,304.76 24,088.92 912828T34 1556 001 TRC 2,000,000.00 0.00 1,915,634.76 09/30/2021 1.125 2.586 2,286.75 2,703.78 4,990.53 912828P87 1539 001 TRC 2,000,000.00 1,973,038.86 1,972,725.58 02/28/2021 1.125 1.618 16,936.14 7,023.68 23,959.82 912828A42 1538 001 TRC 2,000,000.00 2,031,741.17 2,022,384.0911/30/2020 2.000 1.555 30,018.61 -6,296.97 23,721.64 9128281-65 1521 001 TRC 2,000,000.00 1,986,282.31 1,989,448.82 09/30/2020 1.375 1.598 20,662.57 3,166.51 23,829.08 912828,150 1517 001 TRC 2,000,000.00 2,011,113.40 2,007,983.83 02/29/2020 1.375 1.164 20,699.72 -3,129.57 17,570.15 9128281-32 1520 001 TRC 2,000,000.00 1,987,456.15 1,990,426.78 08/31/2020 1.375 1.587 20,699.72 2,970.63 23,670.35 912828VK3 1491 001 TRC 2,000,000.00 2,004,383.92 2,001,083.94 06/30/2018 1.375 1.149 20,588.25 -3,299.98 17,288.27 912828XK1 1509 001 TRC 2,000,000.00 1,998,026.19 1,999,453.17 07/15/2018 0.875 0.969 13,100.83 1,426.98 14,527.81 912828UE8 1490 001 TRC 0.00 1,997,320.95 0.00 12/31/2017 0.750 1.012 7,459.24 2,679.05 10,138.29 912828TG5 1511 001 TRC 0.00 1,999,523.59 0.00 07/31/2017 0.500 0.794 828.73 476.41 1,305.14 912828,184 1518 001 TRC 2,000,000.00 2,010,876.97 2,007,908.55 03/31/2020 1.375 1.172 20,662.57 -2,968.42 17,694.15 912828TH3 1510 001 TRC 2,000,000.00 1,986,975.51 1,991,671.18 07/31/2019 0.875 1.193 13,100.83 4,695.67 17,796.50 912828XM7 1514 001 TRC 2,000,000.00 2,028,572.97 2,021,620.04 07/31/2020 1.625 1.141 24,330.11 -6,952.93 17,377.18 912828TV2 1516 001 TRC 2,000,000.00 2,008,166.85 2,005,540.4210/31/2019 1.250 1.072 18,785.28 -2,626.43 16,158.85 912828TNO 1515 001 TRC 2,000,000.00 1,998,228.42 1,998,842.09 08/31/2019 1.000 1.045 15,054.35 613.67 15,668.02 02587DLVB 1438 001 BCD 0.00 248,000.00 0.0010/25/2017 1.500 1.500 1,182.24 0.00 1,182.24 02006L3N1 1527 001 BCD 245,000.00 245,000.00 245,000.00 06/22/2020 1.900 1.900 3,494.44 0.00 3,494.44 05580AMB7 1562 001 BCD 246,000.00 0.00 246,000.00 03/29/2023 2.900 2.900 58.64 0.00 58.64 0606247A5 1454 001 BCD 248,000.00 248,000.00 248,000.0011/13/2018 2.050 2.050 3,816.49 0.00 3,816.49 20033AUE4 1525 001 NCB 245,000.00 245,011.91 245,000.00 06/19/2020 1.750 1.774 3,263.26 0.00 3,263.26 254672CB2 1477 001 BCD 248,000.00 248,000.00 248,000.0010/22/2018 1.800 1.800 3,351.06 0.00 3,351.06 87164YEB6 1478 001 BCD 248,000.00 248,000.00 248,000.0010/17/2019 2.000 2.000 3,723.40 0.00 3,723.40 1404203Q1 1553 001 BCD 245,000.00 0.00 245,000.00 07/19/2022 2.300 2.300 3,952.22 0.00 3,952.22 45083ADZ2 1482 001 BCD 0.00 248,000.00 0.0012/04/2017 1.200 1.200 1,271.93 0.00 1,271.93 8562843F9 1484 001 BCD 248,000.00 248,000.00 248,000.0012/05/2018 2.000 2.000 3,723.40 0.00 3,723.40 17284C5K6 1487 001 BCD 248,000.00 248,000.00 248,000.0012/10/2019 2.200 2.200 4,095.74 0.00 4,095.74 975875AK1 1526 001 BCD 245,000.00 245,000.00 245,000.00 06/28/2021 1.800 1.800 3,310.52 0.00 3,310.52 38148PKX4 1528 001 BCD 245,000.00 245,000.00 245,000.00 06/21/2022 2.350 2.350 4,322.07 0.00 4,322.07 169894AN2 1529 001 BCD 245,000.00 245,000.00 245,000.00 06/30/2020 1.700 1.700 3,126.60 0.00 3,126.60 17670DAC8 1530 001 BCD 245,000.00 245,000.00 245,000.0012/30/2021 1.900 1.900 3,494.44 0.00 3,494.44 337630BD8 1531 001 BCD 245,000.00 245,000.00 245,000.00 06/23/2021 1.900 1.900 3,494.44 0.00 3,494.44 56585YAB6 1532 001 BCD 245,000.00 245,000.00 245,000.00 06/29/2020 1.700 1.700 3,126.61 0.00 3,126.61 06653ABM5 1533 001 BCD 245,000.00 245,000.00 245,000.00 06/30/2022 2.000 2.000 3,678.36 0.00 3,678.36 Portfolio ENCI Data Updated: SET _QTR: 04/19/2018 18:00 AC Run Date: 04/19/2018 -18:00 No fiscal year history available IE (PRF_IE) 7.2.0 Report Ver. 7.3.5 Security CUSIP Investment# Fund Type City of Encinitas - Qtr Inv Report Interest Earnings July 1, 2017 - March 31, 2018 Ending Beginning Ending Maturity CurrentAnnualized Par Value Book Value Book Value Date Rate Yield Page 3 Adjusted Interest Earnings Interest Amortization/ Adjusted Interest Earned Accretion Earnings Fund: General Investments 949763JG2 1535 001 BCD 245,000.00 245,000.00 245,000.00 06/30/2022 2.250 2.250 4,138.15 0.00 4,138.15 17801 GSB7 1551 001 BCD 245,000.00 0.00 245,000.00 02/03/2022 2.000 2.000 3,651.51 0.00 3,651.51 14042RGN5 1552 001 BCD 245,000.00 0.00 245,000.00 07/19/2022 2.300 2.300 3,952.22 0.00 3,952.22 87270LAD5 1554 001 BCD 245,000.00 0.00 245,000.00 07/19/2022 2.150 2.150 3,694.47 0.00 3,694.47 58404DBL4 1561 001 BCD 249,000.00 0.00 249,000.00 03/28/2023 2.900 2.900 79.13 0.00 79.13 17312QH69 1563 001 BCD 246,000.00 0.00 246,000.00 03/29/2023 2.850 2.890 58.43 0.00 58.43 45581EASO 1564 001 BCD 249,000.00 0.00 249,000.00 03/29/2023 2.900 2.900 59.35 0.00 59.35 61747MR37 1565 001 BCD 246,000.00 0.00 246,000.00 03/29/2023 2.900 2.900 58.64 0.00 58.64 501798LT7 1566 001 BCD 246,000.00 0.00 246,000.00 03/29/2023 2.800 2.800 56.61 0.00 56.61 29278TAU4 1568 001 BCD 246,000.00 0.00 246,000.00 03/29/2023 2.850 2.850 57.62 0.00 57.62 Subtotal 111,763,477.55 113,859,908.45 111,423,568.06 1.322 1,086,776.43 -7,556.95 1,079,219.48 Total 111,763,477.55 113,859,908.45 111,423,568.06 1.322 1,086,776.43-7,556.95 1,079,219.48 Portfolio ENCI Data Updated: SET QTR: 04/19/2018 18:00 AC Run Date: 04/19/2018 -18:00 No fiscal year history available IE (PRF_IE) 7.2.0 Report Ver. 7.3.5