Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Quarterly Investment Report for the 9 months ended 03-31-23
CITY OF ENCINITAS INVESTMENT REPORT MEMORANDUM Nine Months ended March 31, 2023 TO: City Council VIA: Pamela Antil, City Manager FROM: Teresa S. McBroome, Director of Finance/City Treasurer DATE: May 24, 2023 SUBJECT: City of Encinitas Investment Report for the nine (9) months ended March 31, 2023 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 $132.2 million at March 31, 2023, compared to an average investable balance of $116.2 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 $s55,000,o00 $1.45,000,000 $185,000,00D $125,000,000 FY22-23 FY 21-22 $115,000,000 - FY 20.21 $105,000,000 - FY 19-20 FY 18-19 $9 5,000,000 $85,000,o00 Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun The City utilizes a variety of investment vehicles, including direct investments and indirect investments. Direct investments are primarily fixed income securities issued by the U.S. Treasury, several U.S. Government Agencies, such as the Federal National Mortgage Association (FNMA) and the Federal Home Loan Mortgage Corporation (FHLMC), and Certificates of Deposit with U.S Bank as Trustee. Indirect investments include money market funds and pooled investments funds managed by other agencies, including the California Local Agency Investment Fund (LAIF), California Asset Management Program (CAMP) and the San Diego County Investment Pool. 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 the City's direct securities can vary from less than one month to under five years. The City has overnight liquidity, including cash in the bank, of $37.9 million at March 31, 2023. FY 2022-23 June 30, 2023 March 31, 2023 Dec. 31, 2022 Sep. 3Q 2022 Book Value $ 132,180,626 $ 129,743,266 $ 116,194,740 Market Value $ 128,516,434 $ 125,375,418 $ 111,473,499 Unrealized Gain/(Loss) $ (3,664,192) $ (4,367,948) $ (4,721,241) Unrealized Gain/Loss as %of Book Value -2.77% -3,37% -4.06% Effective Rate of Return 1.81% 1.57% 1.42% Average Yield To Maturity 2.39% 2.09% 1.53% Average Maturity (Years) 1.66 1.21 1.44 Investment Earnings Yearto Date $ 1,581,898 $ 882,449 $ 412,347 The Pool earned $1,581,898 the first nine months of FY 2022-23 for an annualized return of 1.81 percent. The average yield for the City over the twelve months ended March 31, 2023, is 1.54 percent. This compares to the City's adopted performance benchmark of the one (1) year constant maturity Treasury Index which averaged a 3.98 percent yield over the twelve months ended March 31, 2023. The one (1) year Treasury Index rose quickly in a short period of time. The City maintains its investment policy objectives in priority order of safety of principal, liquidity of funds and return on investments and as such the City's yield will begin reflecting the rise of interest rates over time. 5.00% 4.00% 3.00% 2.00% 1.00% 0.00% City Portfolio Yield Compared to Treasury Indexes r--- — — — 1� 1a 1$ 14i 1� 1� 1� 1cl ;O ;L ;p 10 ti, ti1 tit tit ti~ titi titi tit ti� l;c -P IZF5 Oat 1�p le oe 4-1. vac 49 Qec, e 1o° SeQ oec era, I°c -P 1 ec 4 1 City Portfolio-YTD Rate 2 Yr Treasury 1 Yr Treasury — — — 6 With Treasury The market value of the City's direct investments is less than their carrying value by $3,664,192 as of March 31, 2023, 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 follow 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 Par Value 9,451, 001.45 2, 341, 274.59 20,473,846.74 13,640,000.00 498,000.00 64,000,000.00 17,000,000.00 127,404,122.78 City of Encinitas - Qtr Inv Report Portfolio Management Portfolio Summary March 31, 2023 Market Value 9,451, 001 45 2, 341, 274.59 20,473, 846.74 13, 011, 212.34 481,155.15 60,712,476.38 16,427,386.94 122,898,353.59 Book % of Value Portfolio 9,451,001.45 7.47 2, 341, 274.59 1.85 20,473,846.74 16.18 13,640,000.00 10.78 498,000.00 039 63,370,621.80 5007 16,787, 800.93 13.26 126, 662,545.51 100.00% CITY OF ENCINITAS 505 S. VULCAN Encinitas, CA 92024 (760)633-2641 YTM Days to Term Maturity 2.870 3.871 4.650 2.364 1.727 1,567 2.280 2.386 1 1 1 1.663 1,643 1,387 1,493 1,078 Cash Passbook/Checking 5,618,079.99 5,618,079.99 5,618,079.99 0.000 1 (not included in yield calculations) Total Cash and Investments 133,022,202.77 128,516,433.58 132,180,625.50 2.386 1,078 Total Earnings March 31 Period Ending Current Year 1,581,898.11 Average Daily Balance 116,209,661.96 Effective Rate of Return 1.81% 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 expend'tt e equiremeY ourc f e market values of invest ent ' wqe is Bank Custody Services. cl� 2 Teres4McBroome, Finance Director\Treasurer �^ Reporting period 07/01/2022-03/31/2023 Data Updated: SET _QTR: 04/27/2023 10:29 Run Date: 04/27/2023 - 10:29 No fiscal year history available 1 1 1 811 393 866 607 1 607 Portfolio ENCI AC PM (PRF_PM1) 7.3.0 Report Ver. 7.3.6.1 City of Encinitas - Qtr Inv Report Portfolio Management Portfolio Details - Investments March 31, 2023 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 9,451,001.45 9,451.001.45 9,451.001.45 2.870 2.870 NR Subtotal and Average 14,110,351.20 9,451,001.45 9,451,001.45 9,451,001.45 2.870 Managed Pool Accounts SYS1003 1003 CA Asset Management Program 1,097,956.72 1,097,956.72 SYS1584 1584 SD County Investment Pool 1,243,317.87 1,243,317.87 Subtotal and Average 2,317,916.94 2,341,274.59 2,341,274.69 Money Market Funds SYS1004 1004 US BANK Subtotal and Average Certificates of Deposit - Bank 33646CJPO 1569 249398BT4 1596 02589AAM4 1580 79545OS89 1570 20033AZK5 1571 020080BUO 1619 33640VDE5 1609 59013KAR7 1597 06251AW48 1585 34969RCS5 1616 654062JRO 1625 219255AK2 1623 397129AJ6 1663 61760AG52 1593 27002YEQ5 1594 200056QRZ8 1595 336460CQ 1 1598 761400BY1 1599 33847E4E4 1626 52465JHT7 1618 710673AC8 1624 73319FAD1 1611 203522AT4 1610 15,786,921.42 20,473,846.74 20,473,846.74 1,097,956.72 4.800 4.800 AAA 1.243.317.87 3.050 3.050 AAA 2,341,274.59 3.871 20,473,846.74 20,473.846.74 4.650 4.650 AAA 20,473,846.74 20,473,846.74 4.650 First Source Bank 04/11/2018 246,000.00 245,840.10 246,000.00 2.850 2.850 04/11/2023 Denver Savings Bank 06/21/2019 249.000.00 247,466.16 249,000.00 2.250 2.250 06/21/2023 American Express National Bank 06/26/2018 245,000.00 243,966.10 245,000.00 3.300 3.300 NR NR 06/26/2023 Sallie Mae Bank/Murray 06/27/2018 245,000.00 243,953.85 245,000.00 3.300 3.300 NR NR 06/27/2023 Comenity Capital Bank 06/29/2018 245,000.00 243.961.20 245.000.00 3.300 3.300 NR NR 06/29/2023 ALMA BANK 03/30/2020 249,000.00 243,960.24 249,000.00 0.900 0.900 09/29/2023 FIRST SERVICE BANK 11/15/2019 249.000.00 243,810.84 249,000.00 1.700 1.700 11/15/2023 Merrick Bank 06/28/2019 249,000.00 244,010.04 249,000.00 2.400 2.400 12/28/2023 BANK HAPOALIM BM NY 03/25/2019 246,000.00 240,787.26 246,000.00 2.900 2.900 03/25/2024 FORTUNE BANK ARNOLD 03/27/2020 249,000.00 239,122.17 249,000.00 1.000 1000 03/27/2024 NICOLET NATIONAL BANK 03/31/2020 249,000.00 239,483.22 249,000.00 1.150 1.150 03/28/2024 CORNHUSKER BANK 03/30/2020 249,000.00 239,336.31 249.000.00 1.100 1 100 03/29/2024 GREENWOOD CREDIT UNION 11/28/2022 248,000.00 247,628.00 248,000.00 4.950 4.950 05/28/2024 MORGAN STANLEY PRIVATE BANK 06/13/2019 246,000.00 238,952.10 246,000.00 2.600 2.600 06/13/2024 EAGLEBANK 06/20/2019 249,000.00 240,830.31 249.000.00 2.300 2.300 06/20/2024 COMMERCE BANK GENEVA MN 06/26/2019 249,000.00 240,730.71 249.000.00 2.300 2.300 06/26/2024 First State Bank Dequeen 06/28/2019 249,000.00 240,698.34 249,000.00 2.300 2.300 06/28/2024 REVERE BANK 06/28/2019 247,000.00 238,821.83 247,000.00 2.300 2.300 06/28/2024 FLAGSTAR BANK FSB 09/30/2020 249,000.00 232,456.44 249,000.00 0.400 0.400 09/30/2024 LEGENDS BANK 03/30/2020 249,000.00 234,533.10 249,000.00 1.000 1.000 09/30/2024 PEOPLES BANK/SARDIS TN 03/31/2020 249,000.00 234,533.10 249,000.00 1.000 1.000 09/30/2024 POPPY BANK 11/04/2019 249,000.00 236,188.95 249,000.00 1.650 1.650 11/04/2024 COMMUNITY BANK 11/08/2019 249,000.00 236,109.27 249,000.00 1.650 1.650 11/08/2024 Data Updated: SET_QTR: 04/27/2023 10:29 Run Dale: 04/27/2023 - 10:29 Portfolio ENCI AC PM (PRF_PM2) 7.3.0 Report Ver. 7.3.6 1 City of Encinitas - Qtr Inv Report Portfolio Management Portfolio Details - Investments March 31, 2023 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 29367SJQ8 1607 ENTERPRISE BANK AND TRUST 11/08/2019 249,000.00 236,684.46 249,000.00 1.800 1.800 11/08/2024 695292FP2 1613 PADUCAH BANK AND TRUST 11/08/2019 249,000.00 236,109.27 249,000.00 1.650 1.650 11/08/2024 89579NCB7 1612 TRIAD BANK FRONTENAC MO 11/08/2019 249,000.00 236,684.46 249,000.00 1.800 1.800 11/08/2024 01025RAD1 1661 ALABAMA CREDIT UNION 11/22/2022 248,000.00 247,583.36 248.000.00 4.900 4.900 11/22/2024 300185JF3 1615 EVERGREEN BANK GROUP 03/26/2020 249,000.00 230,39721 249,000.00 1.000 1.000 03/26/2025 59565QCS2 1617 MIDCOUNTRY BANK 03/27/2020 249,000.00 230.374.80 249,000.00 1.000 1.000 03/27/2025 152010CJ4 1620 CENTERSTATE BANK NA 03/30/2020 248,000.00 229,489.28 248,000.00 1.000 1.000 03/31/2025 538036KU7 1622 LIVE OAK BANKING COMPANY 03/31/2020 249,000.00 230,758.26 249,000.00 1.100 1.100 03/31/2025 694231AD3 1621 PACIFIC ENTERPRISE BANK 03/30/2020 249,000.00 231,017.22 249,000.00 1.150 1.150 03/31/2025 549104SS7 1627 LUANA SAVINGS BANK 10/02/2020 249,000.00 222,745.44 249.000.00 0.400 0.400 10/02/2025 33625CDVB 1629 1ST SECURITY BK OF WASH 11113/2020 249,000.00 222,145.35 249,000.00 0.400 0.400 10/15/2025 51507LBZ6 1628 LANDMARK COMMUNITY BANK 10/29/2020 249,000.00 221.771.85 249,000.00 0.400 0.400 10/29/2025 02007GD26 1662 Ally Bank 11/17/2022 244,000.00 243,282.64 244,000.00 4.800 4.800 11/17/2025 33744AAW9 1630 FIRST US BANK 11/18/2020 249,000.00 221,266.38 249,000.00 0.400 0.400 11/18/2025 50116CCP2 1631 KS STATEBANK 11/30/2020 249,000.00 221,308.71 249,000.00 0.450 0.450 11/28/2025 89789AAJ6 1681 Truliant Federal Credit 0312B/2023 248.000.00 248,682.00 248,000.00 5.000 5.000 03/27/2026 90348JN48 1632 UBS BANK USA 06/23/2021 249,000.00 218,156.37 249,000.00 0.750 0.750 06/23/2026 649447UZO 1633 NEW YORK COMMUNITY BANK 06/3012021 249,000 00 217,847.61 249,000.00 0.700 0.700 07/01/2026 07181JAU8 1660 BAXTER CREDIT UNION 11/22/2022 248,000.00 248,734.08 248,000 00 5.000 5.000 11/23/2026 052392CC9 1665 AUSTIN TELCO FCU 11/28/2022 248,000.00 249,150.72 248.000.00 5.050 5.050 11/27/2026 856285C41 1650 STATE BANK OF INDIA 01/13/2022 248,000.00 218,202.80 248,000.00 1.400 1.400 NR NR 01/13/2027 89235MMP3 1649 TOYOTA FINANCIAL SVGS BK 01/13/2022 248,000.00 217,778.72 248,000 00 1.350 1.350 01/13/2027 39573LCE6 1648 GREENSTATE CREDIT UNION 01/14/2022 248,000.00 217,505.92 248,000.00 1.350 1.350 01/14/2027 64034KAJO 1651 NELNET BANK INC 02/02/2022 248,000.00 218,230.08 248,000.00 1.450 1.450 02/02/2027 02616ABVO 1678 American Frst CU 03/30/2023 248,000.00 248,297.60 248,000.00 4 950 4,950 03/30/2027 910286GA5 1677 United Fidelity Bank FSB 03/30/2023 248,000.00 247,848.72 248,000.00 4.900 4.900 03/30/2027 710275ADO 1679 People Bank/Coldwater OH 03/30/2023 249,000.00 247,944.24 249,000.00 4.800 4.800 03/30/2027 87165FT53 1664 Synchrony Bank 11/18/2022 244,000 00 237,760.92 244,000.00 4250 4.250 11/18/2027 45157PBA7 1666 IDEAL CREDIT UNION 01/20/2023 249,000.00 245,170.38 249,000.00 4.500 4.500 01/20/2028 2546733G9 1676 Discover Bank 03/29/2023 244,000.00 242,960.56 244.000.00 4.750 4.750 03/27/2028 06211913M3 1674 Bank Five Nine 03/28/2023 249,000.00 245,177.85 249,000.00 4.500 4.500 03/28/2028 61690U3R9 1680 Morgan Stanley Bank NA 03/30/2023 244,000.00 242,965.44 244,000.00 4.750 4.750 03/30/2028 Subtotal and Average 12,709,405.11 13,640,000.00 13,011,212.34 13,640,000.00 2.364 Portfolio ENCI Data Updated: SET_QTR: 04/27/2023 10:29 AC Run Dale: 0427/2023 - 10,29 PM (PRF_PM2) 7 3.0 City of Encinitas - Qtr Inv Report Portfolio Management Portfolio Details - Investments March 31, 2023 Page 3 Average Purchase Stated YTM Maturity CUSIP Investment # Issuer Balance Date Par Value Market Value Book Value Rate SAP Moodv's Date Negotiable CDs 15118RSN8 1614 CELTIC BANK 10/30/2019 249.000.00 244,039.92 249,000.00 1.600 1.601 10/30/2023 33767GAMO 1608 First Bank Puerto Rico 10/28/2019 249.000.00 237.115.23 249,000.00 1.850 1.852 NR NR 10/25/2024 Subtotal and Average 498,000.00 498,000.00 481,155.15 498,000.00 1.727 U.S. Treasury Coupon Securities 912828S92 1592 U.S. Treasury Notes 03/27/2019 3,000,000.00 2,965,320.00 2,991,208.06 1.250 2.181 07/31/2023 9128282D1 1604 U.S. Treasury Notes 06/26/2019 2,000,000.00 1,972,580.00 1,997,169.29 1.375 1.729 08/3112023 91282CAP6 1636 U.S. Treasury Notes 07/08/2021 2,000,000.00 1,951,320.00 1,998,663.30 0.125 0.249 AAA Aaa 10/1512023 91282CBM2 1638 U.S. Treasury Notes 07/08/2021 2,000,000.00 1,922,040.00 1,996,927.52 0.125 0.301 02/15/2024 91282CBR1 1655 U.S. Treasury Notes 03/09/2022 1,000.000.00 959,410.00 987,569.54 0.250 1.578 03/15/2024 91282CCG4 1656 U.S. Treasury Notes 03/09/2022 2,000,000.00 1,901,880.00 1,967,500.19 0.250 1.627 06/15/2024 912828Y87 1634 U.S. Treasury Notes 07/08/2021 6,000,000.00 5,794,680.00 6,107,714.48 1.750 0.394 07/31/2024 912828YE4 1646 U.S. Treasury Notes 07/08/2021 2,000,000.00 1,915,080.00 2,023.366.30 1.250 0.419 08/31/2024 912828YH7 1642 U.S. Treasury Notes 07/08/2021 2,000,000.00 1,918,980.00 2,031,782.84 1.500 0.432 09/30/2024 912828YM6 1647 U.S. Treasury Notes 07/08/2021 1,000,000.00 957.970.00 1,016,435.28 1.500 0.453 10/31/2024 91282CDH1 1653 U.S. Treasury Notes 03/09/2022 1,000,000.00 945,350.00 985,161.34 0.750 1.688 11/15/2024 912828ZC7 1641 U.S. Treasury Notes 07/08/2021 2,000,000.00 1,891,100.00 2,022,483.80 1.125 0.531 02/28/2025 912828ZFO 1652 U.S. Treasury Notes 03/09/2022 1,000,000.00 932,700.00 976,636.57 0.500 1.705 03/3112025 912828ZW3 1645 U.S. Treasury Notes 07/0812021 2,000,000.00 1,843,360.00 1,984,461.46 0.250 0.600 06/30/2025 91282CAB7 1640 U.S. Treasury Notes 07/08/2021 6,000,000.00 5,509,920.00 5,948,328.84 0250 0.624 07/31/2025 91282CAJO 1643 U.S. Treasury Notes 07/08/2021 2,000,000.00 1,832,120.00 1,981,604.17 0.250 0.636 08/31/2025 91282CAM3 1644 U.S. Treasury Notes 07/08/2021 2,000,000.00 1,830,240.00 1,980,425.16 0.250 0.648 09/30/2025 91282CAT8 1657 U.S. Treasury Notes 03/09/2022 1,000,000.00 911,760.00 962,405.22 0.250 1.759 10/31/2025 91282CBQ3 1639 U.S. Treasury Notes 07/08/2021 2,000,000.00 1,817,740.00 1,987,403.82 0.500 0.720 02/28/2026 91282CBT7 1635 U.S. Treasury Notes 07/08/2021 2,000,000.00 1,829,760.00 2,000,792.56 0.750 0.736 AAA Aaa 03/31/2026 91282CCJ8 1654 U.S. Treasury Notes 03/09/2022 1,000,000.00 911,840.00 972,332.63 0.875 1.763 06/30/2026 91282CCP4 1659 U.S. Treasury Notes 03/10/2022 4,000,000.00 3,608,120.00 3,851,573.80 0.625 1.787 07/31/2026 912828Y95 1670 U.S. Treasury Notes 02/01/2023 1,000,000.00 940,831.80 941,224.07 1.875 3.774 07/31/2026 9128282A7 1671 U.S. Treasury Notes 02/01/2023 2,000,000.00 1,856,320.00 1,857,153.37 1.500 3.780 08/15/2026 91282CEW7 1669 U.S. Treasury Notes 02/01/2023 3,000,000.00 2.956,808.78 2,958,945.84 3.250 3.675 06/30/2027 91282CFB2 1668 U.S. Treasury Notes 02/01/2023 6,000,000.00 5,778,755.80 5,783,545.38 2.750 3.662 07/31/2027 91282CFM8 1673 U.S. Treasury Notes 02/01/2023 3,000,000.00 3.056,490.00 3,057,806.97 4.125 3.654 09/30/2027 Subtotal and Average 53,441,640.04 64,000,000.00 60,712,476.38 63,370,621.80 1.567 Portfolio ENCI Data Updated: SET _QTR: 04/27/2023 10:29 AC Run Date: 04/27/2023 - 10,29 PM (PRF_PM2) 7 3.0 City of Encinitas - Qtr Inv Report Portfolio Management Portfolio Details - Investments March 31, 2023 Page 4 Average Purchase Stated YTM Maturity CUSIP Investment# Issuer Balance_ Date Par Value Market Value Book Value Rate 58P Moodrs Date Federal Agency Coupon Securities 3133EKSN7 1605 Federal Farm Credit 06/26/2019 4,000,000.00 3,969,880.00 3,999,727.76 1.770 1.800 AAA Aaa 06/26/2023 3133EHST1 1591 FEDERAL FARM CREDIT BANK 03/27/2019 1,000,000.00 991,160.00 999,320.62 2.010 2234 07/26/2023 3135GOU43 1602 Federal Nat'l Mortgage Assoc 06/26/2019 2,000,000.00 1,981,940.00 2,009,207.59 2.875 1.801 09/12/2023 3133EHN25 1606 FEDERAL FARM CREDIT BANK 06/26/2019 2,000,000.00 1,964,400.00 2,004,406.65 2.200 1.805 11/01/2023 3135GO6G3 1658 Federal Nat'l Mortgage Assoc. 03/09/2022 1,000,000.00 914,910.00 967.119.27 0.500 1.813 11/07/2025 3130AN4T4 1637 Federal Home Loan Bank 07/08/2021 2,000,000.00 1,815,520 00 2,006,553.04 0.875 0.770 06/12/2026 3135GOQ22 1672 Federal Nat'l Mortgage Assoc. 02/01/2023 3,000,000.00 2,807,070.00 2,813,853.63 1.875 3,800 09/24/2026 3133EN7A2 1667 FEDERAL FARM CREDIT BANK 02/01/2023 2,000,000.00 1,982,506.94 1,987,612.37 3 625 3.829 10/26/2026 Subtotal and Average 17,068,305.45 17,000,000.00 16,427,386.94 16,787,800.93 2.280 Total and Average 116,209,661.96 127,404,122.78 122,898,353.59 126,562,545.51 2.386 Data Updated: SET _QTR: 04/27/2023 10:29 Run Date: 04/27/2023 - 10:29 Portfolio ENCI AC PM (PRF_PM2) 7.3.0 City of Encinitas - Qtr Inv Report Portfolio Management Portfolio Details - Cash March 31, 2023 Average Purchase Stated YTM CUSIP Investment # Issuer Balance Date Par Value Market Value Book Value Rate S&P Mood 's Passbook/Checking Accounts SYS1010 1010 Union Bank Checking Acct. 5,618,079.99 5,618,079.99 5,618,079.99 0.000 Average Balance 0.00 Total Cash and Investments 116,209,661.96 133,022,202.77 128,516,433.58 132,180,625.50 2.386 Page 5 Portfolio ENCI Data Updated: SET_QTR: 04/27/2023 10:29 AC Run Date. 04/27/2023 - 1029 PM (PRF_PM2) Tao City of Encinitas - Qtr Inv Report Portfolio Management Activity By Type July 1, 2022 through March 31, 2023 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 0.990 Subtotal Managed Pool Accounts (Monthly Summary) SYS1003 1003 CA Asset Management Program 1.140 SYS1584 1584 SD County Investment Pool 1.130 Subtotal Money Market Funds (Monthly Summary) SYS1004 1004 US BANK 1.370 Subtotal Certificates of Deposit - Bank 01025RAD1 1661 ALABAMA CREDIT UNION 4.900 11/22/2022 02007GD26 1662 Ally Bank 4.800 11/17/2022 02616ABVO 1678 American Frst CU 4.950 03/30/2023 052392CC9 1665 AUSTIN TELCO FCU 5.050 11/28/2022 07181JAUB 1660 BAXTER CREDIT UNION 5.000 11/22/2022 05580AMB7 1562 BMW Bank North America 2.900 03/29/2023 14042RGN5 1552 Capital One NA 2.300 07/19/2022 1404203Q1 1553 Capital One Bank USA, NA 2200 07/19/2022 17312OH69 1563 Citi Bank NA 2.850 03/29/2023 2546733G9 1676 Discover Bank 4.750 03129/2023 29278TAU4 1568 Enerbank USA 2.850 03/29/2023 062119BM3 1674 Bank Five Nine 4.500 03/28/2023 910286GA5 1677 United Fidelity Bank FSB 4.900 03/30/2023 397129AJ6 1663 GREENWOOD CREDIT UNION 4.950 11/28/2022 45157PBA7 1666 IDEAL CREDIT UNION 4.500 01/20/2023 45581EASO 1564 Industrial & Comm Bank China 2.900 03/29/2023 501798LT7 1566 LCA Bank Corp 2.800 03/29/2023 58404DBL4 1561 Medallion Bank UT 2.900 03/28/2023 61747MR37 1565 Morgan Stanley Bank 2.900 03/29/2023 75,931,375.68 75,890,454.53 75,931,375.68 75,890,454.53 184,544.24 25,000,000.00 184,544.24 25,395.01 14,690 56 40,085.57 44, 303,628.97 25,000,000.00 0.00 0.00 0.00 27,911,686.48 44,303,628.97 27,911,686.48 248,000.00 0.00 244,000.00 0.00 248,000 00 0.00 248,000.00 0.00 248,000.00 0.00 0.00 246,000.00 0.00 245,000.00 0.00 245,000.00 0.00 246,000.00 244,000.00 0.00 0.00 246,000.00 249,000.00 0.00 248,000 00 0.00 248,000.00 0.00 249,000.00 0.00 0.00 249,000.00 0.00 246,000.00 0.00 249,000.00 0.00 246,000.00 0.00 9,451,001.45 2,341,274.59 20,473,846.74 Page 1 Portfolio ENCI Data Updated: SET_QTR: 04/27/2023 10:29 AC Run Date: 04/27/2023 - 10:29 PM (PRF_PM3) 7 3.0 Report Ver. 7.3.6 1 City of Encinitas - Qtr Inv Report Portfolio Management Page 2 Activity By Type July 1, 2022 through March 31, 2023 Stated Transaction Purchases Redemptions CUSIP Investment# Issuer Rate Date or Deposits or Withdrawals Balance Certificates of Deposit - Bank 6169OU3R9 1680 Morgan Stanley Bank NA 4.750 03/30/2023 244,000.00 0.00 710275ADO 1679 People Bank/Coldwater OH 4.800 03/30/2023 249,000.00 0.00 87165FT53 1664 Synchrony Bank 4.250 11/18/2022 244,000.00 0.00 87270LAD5 1554 TIAA FSB 2.150 07/19/2022 0.00 245,000.00 89789AAJ6 1681 Truliant Federal Credit 5.000 03/28/2023 248,000.00 0.00 Subtotal 3,459,000.00 2,463,000.00 13,640,000.00 Negotiable CDs Subtotal U.S. Treasury Coupon Securities 9128281-24 1572 U.S. Treasury Notes 912828XQ8 1578 U.S. Treasury Notes 9128282W9 1579 U.S. Treasury Notes 91282CFB2 1668 U.S. Treasury Notes 91282CEW7 1669 U.S. Treasury Notes 912828Y95 1670 U.S. Treasury Notes 9128282A7 1671 U.S. Treasury Notes 91282CFM8 1673 U.S. Treasury Notes Subtotal Federal Agency Coupon Securities 1.875 08/31/2022 0.00 2,000,000.00 2.000 07/31/2022 0.00 4,000,000.00 1.875 09/30/2022 0.00 2,000,000.00 2.750 02/01/2023 5,775,000.00 0.00 3.250 02/01/2023 2,948,437.50 0.00 1.875 02/01/2023 938,320.31 0.00 1.500 02/01/2023 1,850,312.50 0.00 4.125 02/01/2023 3,059,882.81 0.00 14,571,953.12 8,000,000.00 3133EN7A2 1667 FEDERAL FARM CREDIT BANK 3.625 02/01/2023 1,985.980 00 0.00 3133EC4Q4 1558 Federal Farm Credit 1.820 11/23/2022 0.00 2,000,000.00 3133EJBP3 1590 Federal Farm Credit 2.500 02/02/2023 0.00 2.000.000.00 3133EDWWB 1600 Federal Farm Credit 2.600 10/06/2022 0.00 1,000,000.00 3135GOT78 1589 Federal Nat'l Mortgage Assoc. 2.000 10/05/2022 0.00 2,000,000.00 3135GOT78 1603 Federal Nat'l Mortgage Assoc. 2.000 10/05/2022 0.00 1,000,000.00 3135GOQ22 1672 Federal Nat'l Mortgage Assoc. 1.875 02/01/2023 2,804,940.00 0.00 Subtotal 4,790,920.00 8,000,000.00 Total 498,000.00 63,370,621.80 16,787,800.93 143,281,507.58 147,265,141.01 126,562,545.61 Portfolio ENCI Data Updated: SET _QTR: 04/27/2023 10:29 AC Run Dale: 04/27/2023 - 10,29 PM (PRF_PM3) 7 3.0 City of Encinitas - Qtr Inv Report Portfolio Management Page 1 Interest Earnings Summary March 31, 2023 March 31Month Ending Fiscal Year To Date CD/Coupon/Discount Investments: Interest Collected 984,885.19 984,885.19 Plus Accrued Interest at End of Period 208,277.01 208,277.01 Less Accrued Interest at Beginning of Period ( 291,834.97) ( 291,834.97) Less Accrued Interest at Purchase During Period ( 85,992.36) ( 85,992.36) Interest Earned during Period 815,334.87 815,334.87 Adjusted by Premiums and Discounts 83,373.37 83,373.37 Adjusted by Capital Gains or Losses 0.00 0.00 Earnings during Periods 898,708.24 898,708.24 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 0.00 0.00 0.00 000 ( 0.00) ( 0.00) ( 0.00) ( 0.00) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 579,177.59 167,954.26 ( 63,941.98) 683,189.87 1,498,524.74 83, 373.37 0.00 1,581,898.11 0.00 579,177.59 167,954.26 ( 63,941.98) 683,189.87 1,498,524.74 83,373.37 0.00 1,581,898.11 Portfolio ENCI Data Updated: SET _QTR: 04/27/2023 10:29 AC Run Date, 04/27/2023 10:29 No fiscal year history available PM (PRF_PM6) 7.3.0 Report Ver. 7.3.6.1 CITY OF ENCINITAS City of Encinitas - Qtr Inv Report 505 S. VULCAN Investments by Type Encinitas, 92024 (760)633-2641 Active Investments 01 March 31, 2023 Purchase Current Maturity Call Call CUSIP Investment # Fund Issuer Par Value Price Remaining Cost Rate Date Date Price Passbook/Checking Accounts SYS1010 1010 001 Union Bank Checking Acct. Local Agency Investment Funds SYS1012 1012 001 CA LAIF Managed Pool Accounts SYS1003 1003 001 SYS1584 1584 001 Money Market Funds SYS1004 1004 001 Certificates of Deposit - Bank 01025RAD1 1661 02007GD26 1662 020080BUO 1619 02616ABVO 1678 02589AAM4 1580 052392CC9 1665 07181JAU8 1660 06251 AW48 1585 200056QRZ8 1595 203522AT4 1610 20033AZK5 1571 219255AK2 1623 152010CJ4 1620 249398BT4 1596 Subtotal Suhtntal 5,618,079.99 100.0000000 5,618,079.99 9,451,001.45 100.0000000 9,451,001.45 CA Asset Management Program 1,097,956.72 100.0000000 SD County Investment Pool 1,243,317.87 100.0000000 Subtotal 2,341,274.59 US BANK 20,473,846.74 100.0000000 Subtotal 20,473,846.74 5,618,079.99 5,618,079.99 9,451,001.45 0.990 9,451,001.45 1, 097, 956.72 1.140 1,243,317.87 1.130 2,341,274.59 20.473.846.74 1.370 20,473,846.74 001 ALABAMA CREDIT UNION 248,000.00 100.0000000 248,000.00 4.900 11/22/2024 001 Ally Bank 244,000.00 100.0000000 244,000.00 4.800 11/17/2025 001 ALMA BANK 249,000.00 100.0000000 249,000.00 0.900 09/29/2023 001 American Frst CU 248,000.00 100.0000000 248,000.00 4.950 03/30/2027 001 American Express National Bank 245,000.00 100.0000000 245,000.00 3.300 06/26/2023 001 AUSTIN TELCO FCU 248,000.00 100.0000000 248,000.00 5.050 11/27/2026 001 BAXTER CREDIT UNION 248,000.00 100.0000000 248,000.00 5.000 11/23/2026 001 BANK HAPOALIM BM NY 246,000.00 100.0000000 246,000.00 2.900 03/25/2024 001 COMMERCE BANK GENEVA MN 249,000.00 100.0000000 249,000.00 2.300 06/26/2024 001 COMMUNITY BANK 249,000.00 100.0000000 249,000.00 1.650 11/08/2024 001 Comenity Capital Bank 245,000.00 100.0000000 245,000.00 3.300 06/29/2023 001 CORNHUSKER BANK 249,000.00 100.0000000 249,000.00 1.100 03/29/2024 001 CENTERSTATE BANK NA 248,000.00 100.0000000 248,000.00 1.000 03/31/2025 001 Denver Savings Bank 249,000.00 100.0000000 249,000.00 2.250 06/21/2023 Portfolio ENCI Data Updated: SET _QTR: 04/27/2023 10:29 AC Run Date: 04/27/2023 - 10:29 No fiscal year history available DT (PRF_DT) 7.1.1 Report Ver, 7 3.6.1 City of Encinitas - Qtr Inv Report Investments by Type March 31, 2023 Page 2 CUSIP Investment # Fund Issuer Par Value Purchase Price Remaining Cost Current Rate Maturity Call Call Date Date Price Certificates of Deposit - Bank 2546733G9 1676 001 Discover Bank 244,000.00 100.0000000 244.000.00 4.750 03/27/2028 27002YEQ5 1594 001 EAGLEBANK 249,000.00 100.0000000 249,000.00 2.300 06/20/2024 29367SJQ8 1607 001 ENTERPRISE BANK AND TRUST 249,000.00 100.0000000 249,000.00 1.800 11/08/2024 300185J173 1615 001 EVERGREEN BANK GROUP 249,000.00 100.0000000 249,000.00 1.000 03/26/2025 062119BM3 1674 001 Bank Five Nine 249,000.00 100.0000000 249,000.00 4.500 03/28/2028 910286GA5 1677 001 United Fidelity Bank FSB 248,000.00 100.0000000 248,000.00 4.900 03/30/2027 33640VDE5 1609 001 FIRST SERVICE BANK 249,000.00 100.0000000 249.000.00 1.700 11/15/2023 33847E4E4 1626 001 FLAGSTAR BANK FSB 249,000.00 100 0000000 249.000.00 0.400 09/30/2024 34969RCS5 1616 001 FORTUNE BANK ARNOLD 249,000.00 100.0000000 249,000.00 1 000 03/27/2024 336460CQ1 1598 001 First State Bank Dequeen 249,000.00 100.0000000 249,000.00 2.300 06/28/2024 33625CDV8 1629 001 1ST SECURITY BK OF WASH 249,000.00 100.0000000 249,000.00 0.400 10/15/2025 33646CJP0 1569 001 First Source Bank 246,000.00 100.0000000 246,000.00 2.850 04/11/2023 397129AJ6 1663 001 GREENWOOD CREDIT UNION 248,000.00 100.0000000 248,000.00 4.950 05/28/2024 45157PBA7 1666 001 IDEAL CREDIT UNION 249,000.00 100.0000000 249,000 00 4.500 01/20/2028 50116CCP2 1631 001 KS STATEBANK 249,000.00 100.0000000 249,000.00 0.450 11/28/2025 51507LBZ6 1628 001 LANDMARK COMMUNITY BANK 249,000.00 100.0000000 249,000.00 0.400 10/29/2025 52465JHT7 1618 001 LEGENDS BANK 249,000.00 100.0000000 249,000.00 1.000 09/30/2024 538036KU7 1622 001 LIVE OAK BANKING COMPANY 249,000.00 100.0000000 249,000.00 1.100 03/31/2025 549104SS7 1627 001 LUANA SAVINGS BANK 249,000.00 100.0000000 249,000.00 0.400 10/02/2025 59013KAR7 1597 001 Merrick Bank 249,000.00 100.0000000 249,000.00 2.400 12/28/2023 61760AG52 1593 001 MORGAN STANLEY PRIVATE BANK 246,000.00 100.0000000 246.000.00 2.600 06/13/2024 59565QCS2 1617 001 MIDCOUNTRY BANK 249,000.00 100.0000000 249,000.00 1.000 03/27/2025 61690U3R9 1680 001 Morgan Stanley Bank NA 244,000.00 100.0000000 244,000.00 4.750 03/30/2028 654062JR0 1625 001 NICOLET NATIONAL BANK 249,000.00 100.0000000 249,000.00 1.150 03/28/2024 64034KAJ0 1651 001 NELNET BANK INC 248,000.00 100.0000000 248,000.00 1.450 02/02/2027 649447UZ0 1633 001 NEW YORK COMMUNITY BANK 249,000.00 100.0000000 249,000.00 0.700 07/01/2026 694231AD3 1621 001 PACIFIC ENTERPRISE BANK 249,000.00 100.0000000 249,000.00 1.150 03/31/2025 695292FP2 1613 001 PADUCAH BANK AND TRUST 249,000.00 100.0000000 249,000.00 1.650 11/08/2024 710673AC8 1624 001 PEOPLES BANK/SARDIS TN 249,000.00 100.0000000 249,000.00 1.000 09/30/2024 710275AD0 1679 001 People Bank/Coldwater OH 249,000.00 100.0000000 249,000.00 4.800 03/30/2027 73319FAD1 1611 001 POPPY BANK 249,000.00 100.0000000 249,000.00 1.650 11/04/2024 761400BY1 1599 001 REVERE BANK 247,000.00 100.0000000 247,000.00 2.300 06/28/2024 856285C41 1650 001 STATE BANK OF INDIA 248,000.00 100.0000000 248,000.00 1.400 01/13/2027 795450S89 1570 001 Sallie Mae Bank/Murray 245,000.00 100.0000000 245,000.00 3.300 06/27/2023 87165FT53 1664 001 Synchrony Bank 244,000.00 100.0000000 244,000 00 4.250 11/18/2027 89235MMP3 1649 001 TOYOTA FINANCIAL SVGS BK 248,000.00 100.0000000 248,000.00 1.350 01/13/2027 89579NCB7 1612 001 TRIAD BANK FRONTENAC MO 249,000.00 100.0000000 249,000 00 1.800 11/08/2024 89789AAJ6 1681 001 Truliant Federal Credit 248,000.00 100.0000000 248,000.00 5.000 03/27/2026 Data Updated: SET _QTR: 04/27/2023 10:29 Run Date: 04/27/2023 - 10,29 No fiscal year history available Portfolio ENCI AC DT (PRF_DT) 7.1.1 Report Ver. 7.3.6.1 CUSIP Investment# Fund Issuer Certificates of Deposit - Bank 90348JN48 1632 001 39573LCE6 1648 001 33744AAW9 1630 001 Negotiable CDs 15118RSN8 1614 001 33767GAMO 1608 001 U.S. Treasury Coupon Securities 912828592 1592 001 9128282D1 1604 001 912828Y87 1634 001 91282CBT7 1635 001 91282CAP6 1636 001 91282CBM2 1638 001 91282CBQ3 1639 001 91282CAB7 1640 001 912828ZC7 1641 001 912828YH7 1642 001 91282CAJ0 1643 001 91282CAM3 1644 001 912828ZW3 1645 001 912828YE4 1646 001 912828YM6 1647 001 912828ZF0 1652 001 91282CDH1 1653 001 91282CCJB 1654 001 91282CBR1 1655 001 91282CCG4 1656 001 91282CAT8 1657 001 91282CCP4 1659 001 91282CFB2 1668 001 91282CEW7 1669 001 912828Y95 1670 001 UBS BANK USA GREENSTATE CREDIT UNION FIRST US BANK City of Encinitas - Qtr Inv Report Investments by Type March 31, 2023 Par Value Page 3 Purchase Current Maturity Call Call Price Remaining Cost Rate Date Date Price 249,000.00 100.0000000 249,000.00 0.750 06/23/2026 248,000.00 100.0000000 248,000.00 1.350 01/14/2027 249,000.00 100.0000000 249,000.00 0.400 11/18/2025 Subtotal 13,640,000.00 CELTIC BANK 249,000.00 100.0000000 First Bank Puerto Rico 249,000.00 100.0000000 Subtotal 498,000.00 U.S. Treasury Notes 3.000.000.00 96.1562500 U.S. Treasury Notes 2,000,000.00 98.5781250 U.S. Treasury Notes 6.000.000.00 104.1250000 U.S. Treasury Notes 2,000,000.00 100.0625000 U.S. Treasury Notes 2,000,000.00 99.7187600 U.S. Treasury Notes 2,000,000.00 99.5429690 U.S. Treasury Notes 2,000,000.00 98.9960940 U.S. Treasury Notes 6,000,000.00 98.5000000 U.S. Treasury Notes 2,000,000.00 102.1406250 U.S. Treasury Notes 2,000,000.00 103.4218750 U.S. Treasury Notes 2,000,000.00 98.4218750 U.S. Treasury Notes 2,000,000.00 98.3437500 U.S. Treasury Notes 2,000,000.00 98.6250000 U.S. Treasury Notes 2,000,000.00 102.5937500 U.S. Treasury Notes 1,000,000.00 103.4375000 U.S. Treasury Notes 1,000,000.00 96.4218750 U.S. Treasury Notes 1,000,000.00 97.5468750 U.S. Treasury Notes 1,000,000.00 96.3281250 U.S. Treasury Notes 1,000,000.00 97.3750000 U.S. Treasury Notes 2,000.000.00 96.9453125 U.S. Treasury Notes 1,000,000.00 94.6953130 U.S. Treasury Notes 4,000,000.00 95.1093750 U.S. Treasury Notes 6.000,000.00 96.2500000 U.S. Treasury Notes 3.000,000.00 98.2812500 U.S. Treasury Notes 1,000,000.00 93.8320310 13,640,000.00 249, 000.00 1.600 10/30/2023 249, 000.00 1.850 10/25/2024 498,000.00 2,884,687.50 1.250 07/31/2023 1,971,562.50 1.375 08/31/2023 6,247,500.00 1.750 07/31/2024 2,001.250.00 0.750 03/31/2026 1,994,375.00 0.125 10/15/2023 1.990.859.38 0.125 02/15/2024 1,979,921.88 0.500 02/28/2026 5,910.000.00 0.250 07/31/2025 2,042,812.50 1.125 02/28/2025 2,068,437.50 1.500 09/30/2024 1,968,437.50 0.250 08/31/2025 1.966,875.00 0.250 09/30/2025 1,972,500.00 0.250 06/30/2025 2,051,875.00 1.250 08/31/2024 1, 034, 375.00 1,500 10/31 /2024 964,218,75 0.500 03/31/2025 975,468.75 0.750 11/15/2024 963,28125 0.875 06/30/2026 973,750.00 0.250 03/15/2024 1.938,906.25 0250 06/15/2024 946,953.13 0.250 10/31/2025 3,804,375.00 0.625 07/31/2026 5,775,000.00 2.750 07/31/2027 2,948,437,50 3.250 06/30/2027 938,320.31 1.875 07/31/2026 Portfolio ENCI Data Updated: SET _QTR: 04/27/2023 10:29 AC Run Date: 04/27/2023 - 10:29 No fiscal year history available DT (PRF_DT) 7.1.1 Report Ver. 7.3.6.1 City of Encinitas - Qtr Inv Report Investments by Type Page 4 March 31, 2023 Purchase Current Maturity Call Call CUSIP Investment # Fund Issuer Par Value price Remaining Cost Rate Date Date Price U.S. Treasury Coupon Securities 9128282A7 1671 001 91282CFM8 1673 001 Federal Agency Coupon Securities 3133EHST1 1591 001 3133EHN25 1606 001 3133EN7A2 1667 001 3133EKSN7 1605 001 3130AN4T4 1637 001 3135GOU43 1602 001 3135GO6G3 1658 001 3135GOQ22 1672 001 U.S. Treasury Notes U.S. Treasury Notes Subtotal FEDERAL FARM CREDIT BANK FEDERAL FARM CREDIT BANK FEDERAL FARM CREDIT BANK Federal Farm Credit Federal Home Loan Bank Federal Nat'l Mortgage Assoc. Federal Nat'l Mortgage Assoc Federal Nat'l Mortgage Assoc. Subtotal Total 2,000,000.00 92.5156250 1,850,312.50 1.500 08/15/2026 3,000,000.00 101.9960937 3,059,882.81 4.125 09/30/2027 64,000,000.00 63,224,375.01 1,000,000.00 99.0790000 990,790.00 2.010 07/26/2023 2,000,000.00 101.6420000 2,032,840.00 2.200 11/01/2023 2,000,000.00 99.2990000 1,985,980.00 3.625 10/26/2026 4,000,000.00 99.8847000 3,995,388 00 1.770 06/26/2023 2,000,000.00 100.5050000 2,010,100.00 0.875 06/12/2026 2,000,000.00 104.3350000 2,086,700 00 2.875 09/12/2023 1,000,000.00 95.3700000 953,700.00 0.500 11/07/2025 3,000,000.00 93.4980000 2,804,940.00 1.875 09/24/2026 17,000,000.00 16,860,438.00 133,022,202.77 132,107,015.78 Portfolio ENCI Data Updated: SET _QTR: 04/27/2023 10:29 AC Run Date: 04/27/2023 - 10:29 No fiscal year history available DT (PRF_DT) 7.1.1 Report Ver. 7.3.6.1 CITY OF ENCINITAS City of Encinitas - Qtr Inv Report 505 S. VULCAN IEncinitas, )6 s2024 Interest Earnings (76033-2641 Sorted by Fund - Fund July 1, 2022 - March 31, 2023 Yield on Beginning Book Value Adjusted Interest Earnings Ending Beginning Ending Maturity Current Annualized Interest Amortization) Adjusted Interest CUSIP Investment # Fund Issuer Par Value Book Value Book Value Date Rate Yield Earned Accretion Earnings Fund: General Investments SYS1012 1012 001 LAIF 9,451,001.45 34,266,457.21 9,451,001.45 2.870 0.793 203,886.82 0.00 203,886.82 SYS1584 1584 001 COUNTY 1,243,317.87 1,228,627.31 1,243,317.87 3.050 2.281 21,038.32 0.00 21,038.32 SYS1003 1003 001 CAMP 1,097,95672 1,072,561.71 1,097,956.72 4.800 3.585 28,864.48 0.00 28,864.48 SYS1004 1004 001 UBCUST 20,473,846.74 4,081,904.25 20,473,846.74 4.650 14.013 429,400.25 0.00 429,400.25 SYS1010 1010 001 UBCKG 5,618,07999 5,577,158.84 5,618,079.99 0.00 0.00 0.00 3130AN4T4 1637 001 FHLB 2,000,000 00 2,008,090.25 2,006,553.04 06/12/2026 0.875 0.769 13,125.00 -1,537-21 11,587.79 3135GOT78 1589 001 FNMA 0.00 1,999,049.62 0.00 10/05/2022 2.000 2.167 10,444.44 950.38 11,394.82 3135GOT78 1603 001 FNMA 0.00 1,000,656.25 0.00 10/05/2022 2.000 1.735 5,222.22 -656.25 4,565.97 3135GOU43 1602 001 FNMA 2,000,000.00 2,024,648.88 2,009,207.59 09/12/2023 2.875 1.821 43,125.00 -15,441.29 27,683.71 3135G06G3 1658 001 FNMA 1.000,000.00 957,634.45 967,119.27 11/07/2025 0.500 1.841 3,750.00 9,484.82 13,234.82 3135GOQ22 1672 001 FNMA 3,000,000.00 0.00 2,813,853.63 09/24/2026 1.875 4.034 9,375.00 8,913.63 18,288.63 3133EKSN7 1605 001 FFCRED 4,000,000.00 3,998.863.01 3,999,727.76 06/26/2023 1.770 1.798 53,100.00 864.75 53,964.75 3133EC4Q4 1558 001 FFCRED 0.00 1,993,522.81 0.00 11/23/2022 1.820 2.631 14,357.78 6,477.19 20,834.97 3133EDWW8 1600 001 FFCRED 0.00 1,002,081.95 0.00 10/06/2022 2.600 1.795 6,861.11 -2,081.95 4,779.16 3133EJBP3 1590 001 FFCRED 0.00 2,003,237.36 0.00 02/02/2023 2.500 2.199 29,305.56 -3,237.36 26,068.20 912828YE4 1646 001 UST 2,000,000.00 2,035,726.09 2,023,366.30 08/31/2024 1.250 0.423 18,817.93 -12,359.79 6,458.14 91282CCG4 1656 001 UST 2,000,000.00 1,947,307.56 1,967,500.19 06/15/2024 0.250 1.638 3,751.20 20,192.63 23,943.83 912828YM6 1647 001 UST 1,000,000.00 1,024,212.94 1,016,435.28 10/31/2024 1.500 0.454 11.271.17 -7,777.66 3,493.51 91282CBR1 1655 001 UST 1,000,000.00 977,810.38 987,569.54 03/15/2024 0.250 1.586 1,881.79 9,759.16 11,640.95 91282CAT8 1657 001 UST 1,000,000-00 951,493.18 962,405.22 10/31/2025 0.250 1.791 1,878.52 10,912.04 12,790.56 91282CDH1 1653 001 UST 1,000,000.00 978,316.57 985,161.34 11/15/2024 0.750 1.699 5,630.52 6,844.77 12,475.29 91282CCJ8 1654 001 UST 1,000,000.00 965,940.68 972,332.63 06/30/2026 0.875 1.785 6,550.81 6,391.95 12,942.76 912828ZFO 1652 001 UST 1,000,000.00 967,867.29 976,636.57 03/31/2025 0.500 1.724 3,756.83 8,769.28 12,526.11 91282CCP4 1659 001 UST 4,000.000.00 3.820,780.87 3,851,573.80 07/31/2026 0.625 1.818 18,715.47 33,417.24 52,132.71 91282CFM8 1673 001 UST 3,000,000.00 0.00 3,057,806.97 09/30/2027 4.125 3.635 20,056.52 -2,075.84 17.980.68 91282CBQ3 1639 001 UST 2,000,000.00 1,984,160.07 1,987,403.82 02/28/2026 0.500 0.723 7,527.18 3,243-75 10,770.93 91282CBM2 1638 001 UST 2,000.000.00 1,994,296.71 1,996,927.52 02/15/2024 0.125 0.301 1,871.54 2,630.81 4,502.35 912828ZC7 1641 001 UST 2,000.000.00 2,031,297.19 2.022,483.80 02/28/2025 1.125 0.533 16.936.14 -8,813.39 8,122.75 91282CAB7 1640 001 UST 6,000.000.00 5,931,711.59 5,948,328.84 07/31/2025 0.250 0.625 11,229.28 16,617-25 27.846.53 91282CAP6 1636 001 UST 2,000,000.00 1,996.804.13 1,998,663.30 10/15/2023 0.125 0.249 1,877.89 1,859.17 3,737.06 Portfolio ENCI Data Updated: SET _QTR: 04/27/2023 10:29 AC Run Date: 04/27/2023 - 10:29 No fiscal year history available IE (PRF_IE) 7.2.0 Report Ver. 7.3.6.1 City of Encinitas - Qtr Inv Report Interest Earnings July 1, 2022 - March 31, 2023 Ending Beginning Ending Maturity Current Annualized CUSIP Investment# Fund Issuer Par Value Book Value Book Value Date Rate Yield Fund: General Investments 912828YH7 1642 912828Y87 1634 91282CBT7 1635 9128282A7 1671 91282CAM3 1644 91282C E W7 1669 912828Y95 1670 912828ZW3 1645 91282CFB2 1668 9128282D1 1604 9128282W9 1579 912828XQ8 1578 9128281-24 1572 91282CAJ0 1643 912828592 1592 795450589 1570 02007GD26 1662 05580AMB7 1562 20033AZK5 1571 87165FT53 1664 1404203Q1 1553 33767GAMO 1608 14042RGN5 1552 87270LAD5 1554 58404DBL4 1561 17312OH69 1563 45581EAS0 1564 61747MR37 1565 501798LT7 1566 29278TAU4 1568 33646CJP0 1569 02589AAM4 1580 06251 AW48 1585 3133EN7A2 1667 3133EHST1 1591 3133EHN25 1606 27002YEQ5 1594 Page 2 Adjusted Interest Earnings Interest Amortization/ Adjusted Interest Earned Accretion Earnings 001 UST 2.000,000.00 2,047,674.26 2,031,782.84 09/30/2024 1.500 ,0A33 22,540.99 -15,891.42 6,649.57 001 UST 6,000,000.00 6,168,317.69 6,107,714.48 07131/2024 1.750 0.389 78,604.97 -60,603.21 18,001.76 001 UST 2,000,000.00 2,000,990.88 2,000,792.56 03/31/2026 0.750 0.737 11,270.49 -198.32 11,072.17 001 UST 2,000,000.00 0.00 1,857,153.37 08/15/2026 1.500 3.916 4,870.58 6,840.87 11.711.45 001 UST 2,000,000.00 1,974,550.57 1,980,425.16 09/3012025 0.250 0.650 3,756.83 5,874.59 9.631.42 001 UST 3,000,000.00 0.00 2,958,945.84 06/30/2027 3.250 3.731 15.890.89 1,889.56 17,780A5 001 UST 1,000,000.00 0.00 941,224.07 07/31/2026 1.875 3.895 3,055.93 2,851.96 5,907.89 001 UST 2,000,000.00 1.979,275.64 1,984,461.46 06/30/2025 0.250 0.601 3,743.32 5,185.82 8,929.14 001 UST 6,000,000.00 0.00 5,783,545.38 07/31/2027 2.750 3.747 26.892.27 8,089.58 34,981.85 001 UST 2,000,000.00 1,992,066.55 1,997,169.29 08/31/2023 1.375 1.725 20,699.72 5,102.74 25,802.46 001 UST 0.00 1,996,091,44 0.00 09/30/2022 1.875 2.659 9,323.77 3,908.56 13,232.33 001 UST 0.00 3,997,819.18 0.00 07/31/2022 2.000 2.681 6,629.83 2,180.82 8,810.65 001 UST 0.00 1,997,378.44 0.00 08/31/2022 1.875 2.648 6,216.03 2,621.56 8,837.59 001 UST 2,000,000.00 1,975,895.83 1,981,604.17 08/31/2025 0.250 0.639 3,763.58 5,708.34 9,471.92 001 UST 3.000,000.00 2,971,299.03 2,991,208.06 07/31/2023 1.250 2.151 28.073.20 19,909.03 47,982.23 001 SMAEBN 245,000.00 245,000.00 245,000.00 06/27/2023 3.300 3.300 6,069.29 0.00 6,06929 001 ALLYBK 244,000.00 0.00 244,000.00 11/17/2025 4.800 4.800 4,331.84 0.00 4,331.84 001 BMWBNK 0.00 246,000.00 0.00 03/29/2023 2.900 2.900 5,296.75 0.00 5,296.75 001 COMNTY 245,000.00 245,000.00 245,000.00 06/29/2023 3.300 3.300 6,069.28 0.00 6,069,28 001 SYNCHR 244,000.00 0.00 244,000.00 11/18/2027 4.250 4.250 3,807.07 0.00 3,807.07 001 CAPONE 0.00 245,000.00 0.00 07/19/2022 2.300 2.300 277.89 0.00 277.89 001 FBPR 249,000.00 249,000.00 249,000.00 10/25/2024 1.850 1.850 3,458.06 0.00 3,458.06 001 CAP1NA 0.00 245,000.00 0.00 07/19/2022 2.300 2.300 277.89 0.00 277.89 001 TIAAFS 0.00 245,000.00 0.00 07/19/2022 2.150 2.150 259.77 0.00 259.77 001 MEDALL 0.00 249,000.00 0.00 03/28/2023 2.900 2.900 5,341.57 0.00 5,341.57 001 CITIBK 0.00 246,000.00 0.00 03/29/2023 2.850 2.850 5,205.43 0.00 5,205.43 001 INDUST 0.00 249,000.00 0,00 03/29/2023 2.900 2.900 5,361.36 0.00 5,361.36 001 MORSTN 0.00 246,000.00 0.00 03/29/2023 2.900 2.900 5,296.75 000 5,296.75 001 LCABNK 0.00 246,000.00 0.00 03129/2023 2.800 2.800 5,114.10 0.00 5.114.10 001 ENERBK 0.00 246,000,00 0.00 03/29/2023 2.850 2.850 5,205.43 0.00 5,205.43 001 FSRCBK 246,000.00 246,000.00 246,000.00 04/11/2023 2.850 2.850 5,263.06 0.00 5.263.06 001 AMEXNL 245,000.00 245,000.00 245,000.00 06/26/2023 3.300 3.300 6,069.29 0.00 6,069.29 001 BKHAPO 246,000 00 246,000.00 246,000.00 03/25/2024 2.900 2.900 5,355.39 000 5.355.39 001 FFCB 2,000,000.00 0.00 1.987,612.37 10126/2026 3.625 3.959 12,083.34 625.43 12,708.77 001 FFCB 1,000,000.00 997,725.56 999,320.62 07/26/2023 2.010 2.226 15,075.00 1,595.06 16.670.06 001 FFCB 2,000,000.00 2,010,072.33 2,004,406.65 11/01/2023 2.200 1.812 33,000.00 -5,665.68 27,334.32 001 EGLEBK 249,000.00 249,000.00 249,000.00 06/20/2024 2.300 2.300 4,299.15 0.00 4,299.15 Portfolio ENCI Data Updated: SET _QTR: 04/27/2023 10:29 AC Run Date: 04/27/2023 - 10:29 No fiscal year history available IE (PRF_IE) 7.2.0 Report Ver. 7.3.6.1 City of Encinitas - Qtr Inv Report Interest Earnings Page 3 July 1, 2022 - March 31, 2023 Adjusted Interest Earnings Ending Beginning Ending Maturity Current Annualized Interest Amortization/ Adjusted Interest CUSIP Investment# Fund Issuer Par Value Book Value Book Value Date Rate Yield Earned Accretion Earnings Fund: General Investments 200056QRZ8 1595 001 CMBKGN 249,000.00 249,000.00 249,000.00 06/26/2024 2.300 2.300 4,299.15 000 4,299.15 61760AG52 1593 001 MGSTPB 246,000.00 246,000.00 246,000.00 06/13/2024 2.600 2.600 4,801.38 0.00 4,801.38 249398BT4 1596 001 DENSVB 249,000.00 249,000.00 249,000.00 06/21/2023 2.250 2.250 4,205.72 0.00 4,205.72 59013KAR7 1597 001 MERRBK 249,000.00 249.000.00 249,000.00 12/28/2023 2.400 2.400 4,486.09 0.00 4,486.09 336460CQ1 1598 001 FSBDQ 249,000.00 249.000.00 249,000.00 06/28/2024 2.300 2.300 4,299.15 0.00 4,299.15 761400BY1 1599 001 RVBANK 247,000.00 247,000.00 247,000.00 06/28/2024 2.300 2.300 4,264.64 0.00 4,264.64 15118RSN8 1614 001 CELTIC 249,000.00 249,000.00 249,000.00 10/30/2023 1.600 1.600 2,990.73 0.00 2,990.73 29367SJQB 1607 001 ENTERB 249,000.00 249,000.00 249.000.00 11/08/2024 1.800 1.800 3.364.54 0.00 3,364.54 33640VDE5 1609 001 FIRSTS 249,000.00 249,000.00 249.000.00 11/15/2023 1.700 1.700 3,177.68 0.00 3,177.68 203522AT4 1610 001 COMMBK 249,000.00 249,000.00 249,000.00 11/08/2024 1.650 1.650 3,084.17 0.00 3,084.17 73319FAD1 1611 001 POPBK 249,000.00 249.000.00 249,000.00 11/04/2024 1.650 1.650 3,084.17 0.00 3,084.17 89579NCB7 1612 001 TRIADB 249,000.00 249,000.00 249.000.00 11/08/2024 1.800 1.800 3,364.54 0.00 3,364.54 695292FP2 1613 001 PADUCA 249,000.00 249,000.00 249,000.00 11/08/2024 1.650 1.650 3,084.17 0.00 3,084.17 300185JF3 1615 001 EVRGRN 249,000.00 249,000.00 249.000.00 03/26/2025 1.000 1.000 1,869.21 0.00 1,869.21 34969RCS5 1616 001 FORTUB 249,000.00 249,000.00 249,000.00 03/27/2024 1.000 1.000 1,869.21 0.00 1,869.21 59565QCS2 1617 001 MIDCBK 249,000.00 249,000.00 249,000.00 03/27/2025 1.000 1.000 1.869.21 000 1,869.21 52465JHT7 1618 001 LEGEND 249,000.00 249,000.00 249,000.00 09/30/2024 1.000 1.000 1,869.22 0.00 1,869.22 020080BU0 1619 001 ALMABK 249,000.00 249,000.00 249,000.00 09/29/2023 0.900 0.900 1,682.27 0.00 1,682.27 15201QCJ4 1620 001 CTRSTE 248,000.00 248,000.00 248,000.00 03/31/2025 1.000 1.000 1.861.70 0.00 1,861.70 694231AD3 1621 001 PACENT 249,000.00 249,000.00 249,000.00 03/31/2025 1.150 1.150 2,149.60 0.00 2,149.60 538036KU7 1622 001 LIVOAK 249,000.00 249,000.00 249,000.00 03/31/2025 1.100 1.100 2,056.14 0.00 2,056.14 219255AK2 1623 001 CRNHSK 249.000.00 249,000.00 249,000.00 03/29/2024 1.100 1.100 2,056.12 0.00 2,056.12 710673AC8 1624 001 PEBATN 249,000.00 249,000.00 249,000.00 09/30/2024 1.000 1.000 1,869.22 0.00 1,869.22 654062JR0 1625 001 NCBS 249,000.00 249.000.00 249,000.00 03/28/2024 1.150 1.150 2,149.60 0.00 2,149.60 549104SS7 1627 001 LUANSB 249,000.00 249,000.00 249,000.00 10/02/2025 0.400 0.400 747.68 0.00 747.68 33847E4E4 1626 001 FLGSB 249,000.00 249,000.00 249,000.00 09/30/2024 0.400 0,400 747.69 0.00 747.69 51507LBZ6 1628 001 LDMCB 249,000.00 249,000.00 249,000.00 10/29/2025 0.400 0.400 747.66 000 747.66 33625CDV8 1629 001 FSECWA 249,000.00 249,000.00 249,000.00 10/15/2025 0.400 0.400 747.67 0.00 747.67 33744AAW9 1630 001 USBI 249,000.00 249,000.00 249,000.00 11/1E/2025 0.400 0.400 747.67 0.00 747.67 50116CCP2 1631 001 KANBNK 249,000.00 249,000.00 249,000.00 11/28/2025 0.450 0.450 841.18 0.00 841.18 90348JN48 1632 001 UBS 249,000.00 249,000.00 249,000.00 06/23/2026 0.750 0.750 1,401.90 0.00 1,401.90 649447UZ0 1633 001 NYCB 249,000.00 249,000.00 249,000.00 07/01/2026 0.700 0.700 1,308.44 0.00 1.308.44 39573LCE6 1648 001 UNIICC 248,000.00 248.000.00 248,000.00 01/14/2027 1.350 1.350 2,513.29 0.00 2,513.29 89235MMP3 1649 001 TOYFBN 248,000.00 248.000.00 248,000.00 01/13/2027 1.350 1.350 2,513.29 0.00 2,513.29 856285C41 1650 001 SBIIN 248,000.00 248,000.00 248,000.00 01/13/2027 1.400 1.400 2,606.38 0.00 2.606.38 64034KAJ0 1651 001 NELNTB 248,000.00 248.000.00 248,000.00 02/02/2027 1.450 1.450 2,699.47 0.00 2,699,47 052392CC9 1665 001 AUSFCU 248,000.00 0.00 248,000.00 11/27/2026 5.050 5.050 4,220.42 0.00 4,220.42 Portfolio ENCI Data Updated: SET _QTR: 04/27/2023 10:29 AC Run Date: 04/27/2023 - 10:29 No fiscal year history available IE (PRF_IE) 7.2.0 Report Ver. 7.3.6.1 City of Encinitas - Qtr Inv Report Interest Earnings July 1, 2022 - March 31, 2023 Adjusted Interest Earnings Page 4 Ending Beginning Ending Maturity Current Annualized Interest Amortization/ Adjusted Interest CUSIP Investment# Fund Issuer Par Value Book Value Book Value Date Rate Yield Earned Accretion Earnings Fund: General Investments 07181JAU8 1660 001 BAXTCU 248,000.00 0.00 248,000.00 11/23/2026 5.000 5.000 4,382.46 0.00 4,382.46 01025RAD1 1661 001 ALABAM 248,000.00 0.00 248,000.00 11/22/2024 4.900 4 900 4,294.82 0.00 4,294.82 397129AJ6 1663 001 GRNWCU 248,000.00 0.00 248,000.00 05/28/2024 4.950 4 950 4,136.85 0.00 4,136.85 45157PBA7 1666 001 IDLCRU 249,000.00 0.00 249,000.00 01/20/2028 4.500 4.500 2J48.90 0.00 2,148.90 062119BM3 1674 001 FBFCEN 249.000.00 0.00 249,000.00 03/28/2028 4.500 4.500 92.10 0.00 92.10 2546733G9 1676 001 DFS 244,000.00 0.00 244,000.00 03/27/2028 4 750 4.750 95.26 000 95.26 910286GA5 1677 001 FFED 248,000.00 0.00 248,000.00 03/30/2027 4.900 4.900 33.29 0.00 33.29 02616ABV0 1678 001 AMEFIR 248,000.00 0.00 248.000.00 03/30/2027 4.950 4.950 33.63 0.00 33.63 710275AD0 1679 001 POCW 249,000.00 0.00 249,000.00 03/30/2027 4.800 4.801 32.75 0.00 32.75 616901-13R9 1680 001 MS 244,000.00 0.00 244,000.00 03/30/2028 4.750 4,750 63.51 0.00 63.51 89789AAJ6 1681 001 TRUFCU 248,000.00 0.00 248,000.00 03/27/2026 5.000 5.000 101.92 0.00 101.92 Subtotal 133,022,202.77 136,073,376.55 132,180,625.50 1.622 1,498,524.74 83,373.37 1,581,898.11 Total 133,022,202.77 136,073,376.55 132,180,625.50 1.622 1,498,524.74 83,373.37 1,581,898.11 Portfolio ENCI Data Updated: SET _QTR: 04/27/2023 10:29 AC Run Dale: 04/27/2023 - 10:29 No fiscal year history available IE (PRF_IE) 7.2.0 Report Ver. 7.3.6.1 f "r City of Encinitas - Qtr Inv Report CITY OF ENCINITAS i t Investments by Issuer 505 S. VULCAN Encinitas, CA 92024 Active Investments (760)633-2641 Sorted by Fund March 31, 2023 Investment Current Market YTM Redemption Days To Call CUSIP Investment# Security Type Class Remaining CostRal� Market Value 365 Collateral ALABAMA CREDIT UNION 01025RAD1 1661 Certificates of Deposit - Bank Amort 248,000.00 4.900 247,583.36 03/31/2023 4.900 11/22/2024 601 Subtotal and Average 248,000.00 247,583.36 4.900 601 Ally Bank 02007GD26 1662 Certificates of Deposit - Bank Amort 244,000.00 4.800 243,282.64 03/31/2023 4.800 11/17/2025 961 Subtotal and Average 244,000.00 243,282.64 4.800 961 ALMA BANK 020080BUO 1619 Certificates of Deposit - Bank Amort 249.000.00 0.900 243,960.24 03/31/2023 0.900 09/29/2023 181 Subtotal and Average 249,000.00 243,960.24 0.900 181 American Frst CU 02616ABVO 1678 Certificates of Deposit - Bank Amort 248,000.00 4.950 248.297.60 03/31/2023 4.950 03/30/2027 1,459 Subtotal and Average 248,000.00 248,297.60 4.950 1,459 American Express National Bank 02589AAM4 1580 Certificates of Deposit - Bank Amort 245,000.00 3.300 243,966.10 03/31/2023 3.300 06/26/2023 86 Subtotal and Average 245,000.00 243,966.10 3.300 86 AUSTIN TELCO FCU 052392CC9 1665 Certificates of Deposit - Bank Amort 248,000.00 5.050 249,150.72 03/31/2023 5.050 11/27/2026 1,336 Subtotal and Average 248,000.00 249,150.72 5.050 1,336 BAXTER CREDIT UNION 07181JAU8 1660 Certificates of Deposit- Bank Amort 248,000.00 5.000 248,734.08 03/31/2023 5.000 11/23/2026 1.332 Subtotal and Average 248,000.00 248,734.08 5.000 1,332 BANK HAPOALIM BM NY 06251AW48 1585 Certificates of Deposit - Bank Amort Subtotal and Average 246,000.00 2.900 240,787.26 03/31/2023 2.900 03/25/2024 359 246,000.00 240,787.26 2.900 359 Portfolio ENCI Data Updated: SET _QTR: 04/27/2023 10:29 AC Run Date: 04/27/2023 - 10:29 No fiscal year history available DI (PRF_DI) 7.1.1 Report Ver. 7.3.6.1 City of Encinitas - Qtr Inv Report Investments by Issuer Page 2 Sorted by Fund Investment Current Market YTM Redemption Days To Call CUSIP Investment # Sec urityType _ Class Remaining Cost Rate Market Value Data 365 Data Maturity [late Collateral CA Asset Management Program SYS1003 1003 Managed Pool Accounts Amort 1,097,956.72 1.140 1,097,956.72 03/31/2023 1.140 1 Subtotal and Average 1,097,956.72 1,097,956.72 1.140 1 CELTIC BANK 15118RSN8 1614 Negotiable CDs Amort 249,000.00 1.600 244,039.92 03/31/2023 1.601 10/30/2023 212 Subtotal and Average 249,000.00 244,039.92 1.601 212 COMMERCE BANK GENEVA MN 200056QRZB 1595 Certificates of Deposit - Bank Amort 249,000.00 2.300 240,730.71 03/31/2023 2.300 06/26/2024 452 Subtotal and Average 249,000.00 240,730.71 2.300 452 COMMUNITY BANK 203522AT4 1610 Certificates of Deposit- Bank Amort 249.000.00 1.650 236,109.27 03/31/2023 1.650 11/08/2024 587 Subtotal and Average 249,000.00 236,109.27 1.650 587 Comenity Capital Bank 20033AZK5 1571 SD County Investment Pool SYS1584 1584 CORNHUSKER BANK 219255AK2 1623 CENTERSTATE BANK NA 15201QCJ4 1620 Denver Savings Bank 249398BT4 1596 Certificates of Deposit - Bank Amort Subtotal and Average Managed Pool Accounts Amort Subtotal and Average Certificates of Deposit - Bank Amort Subtotal and Average Certificates of Deposit - Bank Amort Subtotal and Average Certificates of Deposit - Bank Amort Subtotal and Average Data Updated: SET _QTR: 04/27/2023 10:29 Run Date: 04/27/2023 - 10:29 245,000.00 3.300 243,961.20 03/31/2023 3.300 06/29/2023 89 245,000.00 243,961.20 3.300 89 1,243,317.87 1.130 1,243,317.87 03/31/2023 1.130 1 1,243,317.87 1,243,317.87 1.130 1 249,000.00 1.100 249,000.00 248,000.00 1.000 248,000.00 249,000.00 2.250 249,000.00 No fiscal year history available 239,336.31 03/31/2023 1.100 03/29/2024 363 239,336.31 1.100 363 229,489.28 03/31/2023 1.000 03/31/2025 730 229,489.28 1.000 730 247,466.16 03/31/2023 2.250 06/21/2023 81 247,466.16 2.250 81 Portfolio ENCI AC DI (PRF_DI) 7.1.1 Report Ver. 7.3.6.1 City of Encinitas - Qtr Inv Report Investments by Issuer Page 3 Sorted by Fund Investment Current Market YTM Redemption Days To Call CUSIP Investment# Security Type Class Remaining Cost Rd{e Market Value Date 365 ❑at atur":�iJ71a Collateral it Discover Bank 2546733G9 1676 Certificates of Deposit - Bank Amort 244,000.00 4.750 242,960.56 03/31/2023 4.750 03/27/2028 1,822 Subtotal and Average 244,000.00 242,960.56 4.750 1,822 EAGLEBANK 27002YE05 1594 Certificates of Deposit - Bank Amort 249,000.00 2.300 240,830.31 03/31/2023 2.300 06/20/2024 446 Subtotal and Average 249,000.00 240,830.31 2.300 446 ENTERPRISE BANK AND TRUST 29367SJQ8 1607 Certificates of Deposit - Bank Amort 249,000.00 1.800 236,684.46 03/31/2023 1.800 11/08/2024 587 Subtotal and Average 249,000.00 236,684.46 1.800 587 EVERGREEN BANK GROUP 300185JF3 1615 Certificates of Deposit - Bank Amort 249.000.00 1.000 Subtotal and Average Bank Five Nine 062119BM3 1674 First Bank Puerto Rico 33767GAMO 1608 FEDERAL FARM CREDIT BANK 3133EHST1 1591 3133EHN25 1606 3133EN7A2 1667 Federal Farm Credit 3133EKSN7 1605 Certificates of Deposit - Bank Amort Subtotal and Average Negotiable CDs Amort Subtotal and Average Federal Agency Coupon Securities Amort Federal Agency Coupon Securities Amort Federal Agency Coupon Securities Amort Subtotal and Average Federal Agency Coupon Securities Amort Subtotal and Average United Fidelity Bank FSB 910286GA5 1677 Certificates of Deposit - Bank 249,000.00 249,000.00 4.500 249,000.00 249,000.00 1.850 249,000.00 990,790.00 2.010 2,032,840.00 2.200 1,985,980.00 3.625 5,009,610.00 3, 995, 388.00 1.770 3,995,388.00 230,397.21 03/31/2023 1.000 03/26/2025 725 230,397.21 1.000 725 245,177.85 03/31/2023 4.500 03/28/2028 1,823 245,177.85 4.500 1,823 237,116.23 03/31/2023 1.852 10/25/2024 573 237,115.23 1.852 573 991,160.00 03/31/2023 2.234 07/26/2023 116 1,964,400.00 03/31/2023 1.805 11/01/2023 214 1,982,506.94 03/31/2023 3.829 10/26/2026 1,304 4,938,066.94 2.687 626 3,969,880.00 03/31/2023 1.800 06/26/2023 3,969,880.00 1.802 86 86 Amort 248,000.00 4.900 247,848.72 03/31/2023 4.900 03/30/2027 1,459 Portfolio ENCI Data Updated: SET _QTR: 04/27/2023 10:29 AC Run Dale: 04/27/2023 - 10:29 No fiscal year history available DI (PRF_DI) 7.1.1 Report Ver. 7.3.6 1 CUSIP Investment# City of Encinitas - Qtr Inv Report Investments by Issuer Sorted by Fund Investment Current Security Type Class Remaining Cost „ Market Market Value Datu YTM 365 Page 4 Redemption Days To Call Date Maturity pate Collateral Subtotal and Average 248,000.00 247,848.72 4.900 1,459 Federal Home Loan Bank 3130AN4T4 1637 Federal Agency Coupon Securities Amort 2,010,100.00 0.875 1,815,520.00 03/31/2023 0.770 06/12/2026 1,168 Subtotal and Average 2,010,100.00 1,815,520.00 0.769 1,165 FIRST SERVICE BANK 33640VDE5 1609 Certificates of Deposit- Bank Amort 249,000.00 1.700 243,810.84 03/31/2023 1.700 11/15/2023 228 Subtotal and Average 249,000.00 243,810.84 1.700 228 FLAGSTAR BANK FSB 33847E4E4 1626 Certificates of Deposit - Bank Amort 249,000.00 0.400 232,456.44 03/31/2023 0.400 09/30/2024 548 Subtotal and Average 249,000.00 232,456.44 0.400 548 Federal Nat'l Mortgage Assoc. 3135GOU43 1602 Federal Agency Coupon Securities Amort 2,086,700.00 2.875 1,981,940.00 03/31/2023 1.801 09/12/2023 164 3135G06G3 1658 Federal Agency Coupon Securities Amort 953,700.00 0.500 914,910.00 03/31/2023 1.813 11/07/2025 951 3135GOQ22 1672 Federal Agency Coupon Securities Amort 2,804,940.00 1.875 2,807,070.00 03/31/2023 3.800 0912412026 1,272 Subtotal and Average 5,845,340.00 5,703,920.00 2.748 826 FORTUNE BANK ARNOLD 34969RCS5 1616 Certificates of Deposit - Bank Amort 249,000.00 1.000 239,122.17 03/31/2023 1 000 03/27/2024 361 Subtotal and Average 249,000.00 239,122.17 1.000 361 First State Bank Dequeen 336460CQ1 1598 Certificates of Deposit- Bank Amort 249,000.00 2.300 240,698.34 03/31/2023 2.300 06/28/2024 454 Subtotal and Average 249,000.00 240,698.34 2.300 454 1ST SECURITY BK OF WASH 33625CDV8 1629 Certificates of Deposit - Bank Amort 249,000.00 0 400 222,145.35 03/31/2023 0.400 10/15/2025 928 Subtotal and Average 249,000.00 222,145.35 0.400 928 First Source Bank 33646CJP0 1569 Certificates of Deposit - Bank Amort 246,000.00 2.850 245,840.10 03/31/2023 2.850 04/11/2023 10 Subtotal and Average 246,000.00 245,840.10 2.850 10 Portfolio ENCI Data Updated: SET_QTR: 04/27/2023 10:29 AC Run Date: 04/27/2023 - 10:29 No fiscal year history available DI (PRF_DI) 7.1.1 Report Ver. 7.3.6.1 City of Encinitas - Qtr Inv Report Investments by Issuer Page 5 Sorted by Fund Investment Current Market YTM Redemption Days To Call CUSIP Investment # Security Type Class Remaining CostRa:g Market Value 365 Collateral GREENWOOD CREDIT UNION 397129AJ6 1663 Certificates of Deposit - Bank Amort 248,000.00 4.950 247,628.00 03/31/2023 4.950 05/28/2024 423 Subtotal and Average 248,000.00 247,628.00 4.950 423 IDEAL CREDIT UNION 45157PBA7 1666 Certificates of Deposit - Bank Amort 249,000.00 4.500 245,170.38 03/31/2023 4.500 01/20/2028 1,755 Subtotal and Average 249,000.00 245,170.38 4.500 1,755 KS STATEBANK 50116CCP2 1631 CA LAIF SYS1012 1012 LANDMARK COMMUNITY BANK 51507LBZ6 1628 LEGENDS BANK 52465JHT7 1618 LIVE OAK BANKING COMPANY 538036KU7 1622 LUANA SAVINGS BANK 549104SS7 1627 Merrick Bank 59013KAR7 1597 Certificates of Deposit - Bank Amort 249,000.00 0.450 Subtotal and Average 249,000.00 Local Agency Investment Funds Amort Subtotal and Average 9,451,001.45 0 990 9,451,001.46 Certificates of Deposit - Bank Amort 249,000.00 0.400 Subtotal and Average 249,000.00 Certificates of Deposit - Bank Amort 249,000.00 1.000 Subtotal and Average 249,000.00 Certificates of Deposit - Bank Amort 249,000.00 1.100 Subtotal and Average 249,000.00 Certificates of Deposit - Bank Amort 249,000.00 0.400 Subtotal and Average 249,000.00 Certificates of Deposit - Bank Amort 249.000.00 2.400 Subtotal and Average 249,000.00 221,308.71 03/31/2023 0.450 11/28/2025 972 221,308.71 0.450 972 9,451,001.45 03131/2023 0.990 1 9,451,001.45 0.990 1 221,771.85 03/31/2023 0.400 10/29/2025 942 221,771.85 0.400 942 234,533.10 03/31/2023 1.000 09/30/2024 548 234,533.10 1.000 548 230,758.26 03/31/2023 1.100 03/31/2025 730 230,758.26 1.100 730 222,745.44 03/31/2023 0,400 10/02/2025 915 222,745.44 0.400 915 244,010.04 03/31/2023 2.400 12/28/2023 271 244,010.04 2.400 271 Portfolio ENCI Data Updated: SET _QTR: 04/27/2023 10:29 AC Run Date: 04/27/2023 - 10:29 No fiscal year history available DI (PRF_DI) 7.1.1 Report Ver. 7.3.6.1 City of Encinitas - Qtr Inv Report Investments by Issuer Page 6 Sorted by Fund Investment Current Market YTM Redemption Days To Call CUSIP Investment # Securit, Class Remaining Cost Rate Market Value pate 365 Date Maturity Date Collateral MORGAN STANLEY PRIVATE BANK 61760AG52 1593 Certificates of Deposit - Bank Amort 246,000.00 2.600 238,952.10 03/31/2023 2.600 06/13/2024 439 Subtotal and Average 246,000.00 238,952.10 2.600 439 MIDCOUNTRY BANK 59565QCS2 1617 Certificates of Deposit - Bank Amort 249,000.00 1.000 230,374.80 03/31/2023 1.000 03/27/2025 726 Morgan Stanley Bank NA 616901-13R9 1680 NICOLET NATIONAL BANK 654062JRO 1625 NELNET BANK INC 64034KAJO 1651 NEW YORK COMMUNITY BANK 649447UZO 1633 PACIFIC ENTERPRISE BANK 694231AD3 1621 PADUCAH BANK AND TRUST 695292FP2 1613 Subtotal and Average Certificates of Deposit - Bank Amort Subtotal and Average Certificates of Deposit - Bank Amort Subtotal and Average Certificates of Deposit - Bank Amort Subtotal and Average Certificates of Deposit - Bank Amort Subtotal and Average Certificates of Deposit - Bank Amort Subtotal and Average Certificates of Deposit - Bank Amort Subtotal and Average PEOPLES BANK/SARDIS TN 710673AC8 1624 Certificates of Deposit - Bank Amort Subtotal and Average 249,000.00 244,000.00 4.750 244,000.00 249.000.00 1.150 249,000.00 230,374.80 1.000 726 242,965.44 03/31/2023 4.750 03/30/2028 1,825 242,965.44 4.750 1,825 239,483.22 03/31/2023 1.150 03/28/2024 362 239,483.22 1.150 362 248,000.00 1.450 218,230.08 03/31/2023 1.450 02/02/2027 1,403 248,000.00 218,230.08 1.450 1,403 249,000.00 0.700 217,847.61 03/31/2023 0.700 07/01/2026 1,187 249,000.00 217,847.61 0.700 1,187 249,000 00 1.150 231,017.22 03/31/2023 1.150 03/31/2025 730 249,000.00 231,017.22 1.150 730 249,000.00 1.650 249,000.00 249,000.00 1.000 249,000.00 236,109.27 03/31/2023 1.650 11/08/2024 587 236,109.27 1.650 587 234,533.10 03/31/2023 1.000 09/30/2024 548 234,533.10 1.000 548 Portfolio ENCI Data Updated. SET _QTR: 04/27/2023 10:29 AC Run Dale, 04/27/2023 - 10:29 No fiscal year history available DI (PRF_DI) 7.1.1 Report Ver. 7.3.6.1 City of Encinitas - Qtr Inv Report Investments by Issuer Page 7 Sorted by Fund Investment Current Market YTM Redemption Days To Call CUSIP Investment# Security Type Class Remaining Cost Rat- Market Value natc 365 Date Maturity Date Collateral People Bank/Coldwater OH 710275ADO 1679 Certificates of Deposit - Bank Amort 249,000.00 4.800 247,944.24 03/31/2023 4.800 03/30/2027 1,459 Subtotal and Average 249,000.00 247,944.24 4.800 1,459 POPPY BANK 73319FAD1 1611 Certificates of Deposit- Bank Amort 249,000.00 1.650 236,188.95 03/31/2023 1.650 11/04/2024 583 Subtotal and Average 249,000.00 236,188.95 1.650 583 REVERE BANK 761400BY1 1599 Certificates of Deposit - Bank Amort Subtotal and Average STATE BANK OF INDIA 856285C41 1650 Certificates of Deposit - Bank Amort Subtotal and Average Sallie Mae Bank/Murray 79545OS89 1570 Certificates of Deposit - Bank Amort Subtotal and Average Synchrony Bank 87165FT53 1664 TOYOTA FINANCIAL SVGS BK 89235M M P 3 1649 89579NCB7 1612 Truliant Federal Credit 89789AAJ6 1681 Certificates of Deposit - Bank Amort Subtotal and Average Certificates of Deposit - Bank Amort Subtotal and Average Certificates of Deposit - Bank Amort Subtotal and Average Certificates of Deposit - Bank Amort Subtotal and Average 247,000.00 2.300 238,821.83 03/31/2023 2.300 06/28/2024 454 247,000.00 238,821.83 2.300 454 248,000.00 1A00 218,202.80 03/31/2023 1.400 01/13/2027 1,383 248,000.00 218,202.80 1.400 1,383 245,000.00 3.300 243,953.85 03/31/2023 3.300 06/27/2023 87 245,000.00 243,953.85 3.300 87 244,000.00 4.250 237,760.92 03/31/2023 4.250 11/18/2027 1,692 244,000.00 248,000.00 1.350 248,000.00 249,000.00 1.800 249,000.00 248,000 00 5.000 248,000.00 237,760.92 4.250 1,692 217,778.72 03/31/2023 1.350 01/13/2027 1,383 217,778.72 1.350 1,383 236,684.46 03/31/2023 1.800 11/08/2024 587 236,684.46 1.800 587 248,682.00 03/31/2023 5.000 03/27/2026 1,091 248,682.00 5.000 1,091 Portfolio ENCI Data Updated: SET _QTR: 04/27/2023 10:29 AC Run Date: 04/27/2023 - 10,29 No fiscal year history available DI (PRF_DI) 7.1.1 Report Ver. 7 3-6 1 City of Encinitas - Qtr Inv Report Investments by Issuer Sorted by Fund Page 8 Investment Current Market YTM Redemption Call CUSIP Investment # Security Type Class Remaining Cost Market Value Collateral _ Y Y Rata• Da � .,365 Date Dale Union Bank Checking Acct. SYS1010 1010 Passbook/Checking Accounts Amort 5,618,079.99 5,618,079.99 03/31/2023 1 Subtotal and Average 5,618,079.99 5,618,079.99 1 US BANK SYS1004 1004 Money Market Funds Amort Subtotal and Average UBS BANK USA 90348JN48 1632 Certificates of Deposit - Bank Amort Subtotal and Average GREENSTATE CREDIT UNION 39573LCE6 1648 Certificates of Deposit - Bank Amort Subtotal and Average FIRST US BANK 33744AAW9 1630 Certificates of Deposit - Bank Amort Subtotal and Average U.S. Treasury Notes 912828592 1592 9128282D1 1604 912828Y87 1634 91282CBT7 1635 91282CAP6 1636 91282CBM2 1638 91282CBQ3 1639 91282CAB7 1640 912828ZC7 1641 912828YH7 1642 91282CAJ0 1643 91282CAM3 1644 912828ZW3 1645 912828YE4 1646 912828YM6 1647 U.S Treasury Coupon Securities U.S. Treasury Coupon Securities U.S Treasury Coupon Securities U.S. Treasury Coupon Securities U.S. Treasury Coupon Securities U.S. Treasury Coupon Securities U.S. Treasury Coupon Securities U.S. Treasury Coupon Securities U.S Treasury Coupon Securities U.S. Treasury Coupon Securities U.S. Treasury Coupon Securities U.S. Treasury Coupon Securities U.S. Treasury Coupon Securities U.S. Treasury Coupon Securities U.S. Treasury Coupon Securities 20,473,846.74 1.370 20,473,846.74 249,000.00 0.750 249,000.00 248,000.00 1.350 248,000.00 249,000.00 0.400 249,000.00 Fair 2,884,687.50 1.250 Amort 1,971,562.50 1.375 Amort 6,247.500.00 1.750 Amort 2,001,250.00 0.750 Amort 1,994,375.00 0.125 Amort 1,990,859.38 0.125 Amort 1,979,921.88 0.500 Amort 5,910,000.00 0.250 Amort 2,042,812.50 1.125 Amort 2,068,437.50 1.500 Amort 1,968,437.50 0.250 Amort 1,966,875.00 0.250 Amort 1,972,500.00 0.250 Amort 2,051,875.00 1.250 Amort 1,034,375.00 1.500 20,473,846.74 03/31/2023 1.370 1 20,473,846.74 1.370 1 218,156.37 03/31/2023 0.750 06/23/2026 1,179 218,156.37 0.750 1,179 217,505.92 03/31/2023 1.350 01/14/2027 1,384 217,505.92 1.350 1,384 221,266.38 03/31/2023 0400 11/18/2025 221,266.38 0.400 962 962 2,965,320 00 03/31/2023 2.181 07/31/2023 121 1,972,580.00 03/31/2023 1.729 08/31/2023 152 5,794,680.00 03/31/2023 0.394 07/31/2024 487 1,829,760.00 03/31/2023 0.736 03/31/2026 1,095 1,951.320.00 03/31/2023 0.249 10/15/2023 197 1,922,040.00 03/31/2023 0 301 02/15/2024 320 1,817,740.00 03/31/2023 0.720 02/28/2026 1,064 5,509,920.00 03/31/2023 0.624 07/31/2025 852 1891,100.00 03/31/2023 0.531 02/28/2025 699 1,918,980.00 03/31/2023 0.432 09/30/2024 548 1,832,120.00 03/31/2023 0.636 08/31/2025 883 1,830,240.00 03/31/2023 0.648 09/30/2025 913 1,843,360.00 03/31/2023 0.600 06/30/2025 821 1,915,080.00 03/31/2023 0.419 08/31/2024 518 957,970.00 03/31/2023 0.453 10/31/2024 579 Portfolio ENCI Data Updated: SET _QTR: 04/27/2023 10:29 AC Run Date: 04/27/2023 - 10:29 No fiscal year history available DI (PRF_DI) 7.1.1 Report Ver. 7.3,6.1 City of Encinitas - Qtr Inv Report Investments by Issuer Sorted by Fund Page 9 Investment Current Market 1'TM Redemption Days To Call CUSIP Investment# Security Type Class Remaining Cost Rat, Market Value Data 365 Collateral 912828ZFO 1652 U.S. Treasury Coupon Securities Amort 964.218.75 0.500 932,700.00 03/31/2023 1.705 03/31/2025 730 91282CDH1 1653 U.S. Treasury Coupon Securities Amort 975,468.75 0.750 945.350.00 03/31/2023 1.688 11/15/2024 594 91282CCJ8 1654 U.S. Treasury Coupon Securities Amort 963,281.25 0.875 911,840.00 03/31/2023 1.763 06/30/2026 1,186 91282CBR1 1655 U.S. Treasury Coupon Securities Amort 973.750.00 0.250 959,410.00 03/31/2023 1.578 03/15/2024 349 91282CCG4 1656 U.S. Treasury Coupon Securities Amort 1,938,906,25 0.250 1,901,880.00 03/31/2023 1.627 06/15/2024 441 91282CAT8 1657 U.S. Treasury Coupon Securities Amort 946,953.13 0.250 911.760.00 03/31/2023 1.759 10/31/2025 944 91282CCP4 1659 U.S. Treasury Coupon Securities Amort 3,804,375.00 0.625 3,608,120.00 03/31/2023 1.787 07/31/2026 1,217 91282CFB2 1668 U.S. Treasury Coupon Securities Amort 5,775,000.00 2.750 5,778,755.80 03/31/2023 3.662 07/31/2027 1,582 91282CEVV7 1669 U.S. Treasury Coupon Securities Amort 2,948,437.50 3.250 2,956,808.78 03/31/2023 3.675 06/30/2027 1,551 912828Y95 1670 U.S. Treasury Coupon Securities Amort 938,320.31 1.875 940,831.80 03/31/2023 3.774 07/31/2026 1,217 9128282A7 1671 U.S. Treasury Coupon Securities Amort 1,850,312.50 1.500 1,856,320.00 03/31/2023 3.780 08/15/2026 1,232 91282CFM8 1673 U.S. Treasury Coupon Securities Amort 3,059,882.81 4.125 3,056,490.00 03/31/2023 3.654 09/30/2027 1,643 Subtotal and Average 63,224,375.01 60,712,476.38 1.570 867 Total and Average 132,107,015.78 128,516,433.58 1.595 681 Portfolio ENCI Data Updated: SET _QTR: 04/27/2023 10:29 AC Run Dale: 04/27/2023 - 10:29 No fiscal year history available DI (PRF_DI) 7.1.1 Report Ver. 7.3.6.1