The URL can be used to link to this page

Quarterly Investment Report for the 3 months ended 09-30-2022CITY OF ENCINITAS INVESTMENT REPORT MEMORANDUM Three Months ended September 30, 2022 TO: City Council VIA: Pamela Antil, City Manager FROM: Teresa S. McBroome, Director of Finance/City Treasurer DATE: January 26, 2023 SUBJECT: City of Encinitas Investment Report for the three (3) months ended September 30, 2022 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 $116.2 million at September 30, 2022, compared to an average investable balance of $115.5 million. The size of the pool varies throughout the year depending upon cash flow. Several factors have a significant impact on cash flow. Property tax revenue is received primarily in December, January, April, and May, while debt payments typically fall in February, April, August, and October. In addition, large payments on capital projects can happen throughout the year. The chart below shows the monthly portfolio balance over the last five years. Monthly Portfolio Balance by Fiscal Year $15510001000 P - --17 T $145,OOQ000 $135,000,000 I -- $125,000,000 FY 22-23 FY 21-22 115,00o 000 FY 20.21 FY 19-20 $105,000,000 FY 1&19 $45,000,000 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 vary from less than one month to under five years. The City has overnight liquidity, including cash in the bank, of $35.1 million at September 30, 2022. FY 2022-23 June 30, 2023 March 31, 2023 Dec. 31, 2022 Sep. 30, 2022 Book Value $ 116,194,740 Market Value $ 111,473,499 Unrealized Gain/(Loss) $ (4,721,241) Unrealized Gain/Loss as % of Book Value -4.06% Effective Rate of Return 1.42% Average Yield To Maturity 1.53% Average maturity (Years) 1.44 Investment Earnings Year to Date $ 412,347 The Pool earned $412,347 the first three months of FY 2022-23 for an annualized return of 1.42 percent. The average yield for the City over the twelve months ended September 30, 2022, is 1.59 percent. This compares to the City's adopted performance benchmark of the one (1) year constant maturity Treasury index which averaged a 2.05 percent yield over the twelve months ended September 30, 2022. The City follows its investment policy objectives in priority order of safety of principal, liquidity of funds and return on investments. City Portfolio Yield Compared to Treasury Indexes 5.00% 4.00% 3.00% Y — 4.e.. 1.00% �- 0.00% � V r .. — City Portfolio — — — 2 Yr Treasury 1 Yr Treasury 6 Mth Treasury The market value of the City's direct investments is less than their carrying value by $4,721,241 as of September 30, 2022, 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 City of Encinitas - Qtr Inv Report Portfolio Management Portfolio Summary September 30, 2022 CITY OF ENCINITAS 505 S. VULCAN Encinitas, CA 92024 (760)633-2641 Par Market Book % of YTM Days to Investments Value Value Value Portfolio Term Maturity Local Agency Investment Funds 12,824,102.31 12,824,102.31 12,824,102.31 11.71 1.630 1 1 Managed Pool Accounts 2,308,558.67 2,308,558.67 2,308,558.67 2.11 2.114 1 1 Money Market Funds 13,214,285.39 13,214,285.39 13,214,285.39 12.07 2.810 1 1 Certificates of Deposit - Bank 11,909,000.00 11,265,269.27 11,909,000.00 10.88 1.732 1,757 715 Negotiable CDs 498,000.00 479,163.15 498,000.00 0.45 1.727 1,643 575 U.S. Treasury Coupon Securities 49,000,000.00 45,183,170.00 48,734,234.48 44.51 0.930 1,329 851 Federal Agency Coupon Securities 20,000,000.00 19,485,440.00 19,993,049.60 18.26 1.886 1,494 352 Investments Cash Passbook/Checking (not included in yield calculations) Total Cash and Investments Total Earnings Current Year Average Daily Balance Effective Rate of Return 109,753,946.37 104,759,988.79 109,481,230.45 100.00% 6, 713, 510.03 116,467,456.40 ber 30 Period Ending 412,347.21 115,462,316.60 1.42% 6,713,510.03 111,473,498.82 6,713, 510.03 116,194,740.48 1.529 1,063 524 0.000 1 1 1.529 1,063 524 I certify the accuracy of the attached report on the City of Encinitas' Pooled Investment Fund All funds for which the City has oversight responsibility are reflected in this report. All investments are in compliance with the City's adopted Investment Policy., which is available through the City Clerk's office. The City's Investment Program provides sufficient liquidity to meet the next six (6) months ep it ere eme,The,sourcejpf the market values of investments owneq is US Bank Custody Services. Tere4 McBroome, Financ irector\Treasurer Reporting period 07/01/2022-09/30/2022 Data Updated: SET_QTR: 10/31/2022 15:24 Run Date: 10/31/2022 - 15:24 No fiscal year history available 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 September 30, 2022 Page 1 CUSIP Average Investment# Issuer Balance Purchase Date Par Value Market Value Book Value Stated Rate YTM Maturity S&P Moody's Date Local Agency Investment Funds SYS1012 1012 CA LAIF 12,824,102.31 12,824,102.31 12,824,102.31 1.630 1.630 NR Subtotal and Average 18,858,808.49 12,824,102.31 12,824,102.31 12,824,102.31 1.630 Managed Pool Accounts SYS1003 1003 CA Asset Management Program 1,077.158.84 1,077,158.84 1,077,158.84 2.610 2.610 AAA SYS1584 1584 SD County Investment Pool 1,231,399.83 1.231,399.83 1,231.399.83 1 680 1.680 AAA Subtotal and Average 2,305,757.20 2,308,558.67 2,308,558.67 2,308,558.67 2.114 Money Market Funds SYS1004 1004 US BANK 13.214.285.39 13,214,285.39 13,214.285.39 2.810 2.810 AAA Subtotal and Average 8,196,169.91 13,214,285.39 13,214,285.39 13,214,285.39 2.810 Certificates of Deposit - Bank 58404DBL4 1561 Medallion Bank UT 03/28/2018 249,000.00 247,789.86 249.000.00 2.900 2.900 03/28/2023 05580AMB7 1562 BMW Bank North America 03/29/2018 246.000.00 244,792.14 246.000.00 2.900 2.900 03/29/2023 17312QH69 1563 Citi Bank NA 03/29/2018 246,000.00 244.733.10 246.000.00 2.850 2.850 03/29/2023 29278TAU4 1568 Enerbank USA 03/29/2018 246.000.00 244.733.10 246.000.00 2.850 2.850 03/29/2023 45581 EASO 1564 Industrial & Comm Bank China 03/29/2018 249.000.00 247,774.92 249,000.00 2.900 2.900 03/29/2023 501798LT7 1566 LCA Bank Corp 03/29/2018 246,000,00 244,671.60 246,000.00 2.800 2.800 03/29/2023 61747MR37 1565 Morgan Stanley Bank 03/29/2018 246,000.00 244.792.14 246,000.00 2,900 2.900 03/29/2023 33646CJPO 1569 First Source Bank 04/11/2018 246,000 00 244,649.46 246,000.00 2.850 2.850 04/11/2023 249398BT4 1596 Denver Savings Bank 06/21/2019 249,000.00 246,016.98 249,000.00 2.250 2.250 06/21/2023 02589AAM4 1580 American Express National Bank 06/26/2018 245,000.00 243,870.55 245,000.00 3.300 3.300 NR NR 06/26/2023 79545OS89 1570 Sallie Mae Bank/Murray 06/27/2018 245.000.00 243,865.65 245,000.00 3.300 3.300 NR NR 06/27/2023 20033AZK5 1571 Comenity Capital Bank 06/29/2018 245,000;00 243,855.85 245,000.00 3.300 3.300 NR NR 06/29/2023 020080BUO 1619 ALMA BANK 03/30/2020 249,000.06 241,091.76 249,000.00 0.900 0.900 09/29/2023 33640VDE5 1609 FIRST SERVICE BANK 11/15/2019 249,000.00 242,254.59 249.000.00 1.700 1.700 11/15/2023 59013KAR7 1597 Merrick Bank 06/28/2019 249,000,00 243,614.13 249.000,00 2.400 2.400 12/28/2023 06251AW48 1585 BANK HAPOALIM BM NY 03/25/2019 246.000.00 241.350.60 246,000.00 2.900 2.900 03/25/2024 34969RCS5 1616 FORTUNE BANK ARNOLD. 03/27/2020 249,000.00 237,416.52 249,000.00 1.000 1.000 03/27/2024 654062JRO 1625 NICOLET NATIONAL BANK 03/31/2020 249,000.00 237.931.95 249,000.00 1.150 1.150 03/28/2024 219255AK2 1623 CORNHUSKER BANK 03/30/2020 249,000.00 237,730,26 249,000.00 1.100 1.100 03/29/2024 61760AG52 1593 MORGAN STANLEY PRIVATE BANK 06/13/2019 246,000.00 239,360.46 246,000.00 2.600 2.600 06/13/2024 27002YEQ5 1594 EAGLEBANK 06/20/2019 249,000.00 240,917.46 249.000.00 2,300 2.300 06/20/2024 200056QRZ8 1595 COMMERCE BANK GENEVA MN 06/26/2019 249,000.00 240,830.31 249,000,00 2.300 2.300 06/26/2024 336460CQ1 1598 First State Bank Dequeen 06/28/2019 249.000.00 240,802.92 249.000.00 2.300 2.300 06/28/2024 Portfolio ENCI Data Updated: SET _QTR: 10/31/2022 15:24 AC Run Date. 10/31/2022 - 15:24 PM (PRF_PM2) 7.3.0 Report Ver. 7.3,6.1 City of Encinitas - Qtr Inv Report Portfolio Management Portfolio Details - Investments September 30, 2022 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 761400BY1 1599 REVERE BANK 06/28/2019 247,000.00 238,918.16 247,000.00 2.300 2.300 06/28/2024 33847E4E4 1626 FLAGSTAR BANK FSB 09/30/2020 249,000.00 230,554.08 249,000.00 0.400 0 400 09/30/2024 52465JHT7 1618 LEGENDS BANK 03/30/2020 249,000.00 233,258.22 249,000.00 1.000 1.000 09/30/2024 710673ACB 1624 PEOPLES BANK/SARDIS TN 03/31/2020 249,000.00 233,258.22 249,000,00 1,000 1.000 09/30/2024 73319FAD1 1611 POPPY BANK 11/04/2019 249,000.00 235,783.08 249,000.00 1.650 1.650 11/04/2024 203522AT4 1610 COMMUNITY BANK 11/08/2019 249,000.00 235,713.36 249,000.00 1.650 1.650 11/08/2024 29367SJQ8 1607 ENTERPRISE BANK AND TRUST 11/08/2019 249,000.00 236,465.34 249,000.00 1.800 1.800 11/08/2024 695292FP2 1613 PADUCAH BANK AND TRUST 11/08/2019 249,000.00 235,713.36 249,000.00 1.650 1.650 11/08/2024 89579NCB7 1612 TRIAD BANK FRONTENAC MO 11/08/2019 249,000.00 236,465.34 249,000.00 1.800 1.800 11/08/2024 300185JF3 1615 EVERGREEN BANK GROUP 03/26/2020 249,000.00 229,500.81 249,000.00 1.000 1.000 03/26/2025 59565QCS2 1617 MIDCOUNTRY BANK 03/27/2020 249,000.00 229,480.89 249,000.00 1.000 1.000 03/27/2025 152010CJ4 1620 CENTERSTATE BANK NA 03/30/2020 248,000.00 228,616.32 248,000.00 1.000 1.000 03/31/2025 538036KU7 1622 LIVE OAK BANKING COMPANY 03/31/2020 249,000.00 229,983.87 249,000.00 1.100 1.100 03/31/2025 694231AD3 1621 PACIFIC ENTERPRISE BANK 03/30/2020 249,000.00 230,280.18 249,000.00 1.150 1.150 03/31/2025 549104SS7 1627 LUANA SAVINGS BANK 10/02/2020 249,000.00 221,567.67 249,000.00 0.400 0.400 10/02/2025 33625CDV8 1629 1ST SECURITY BK OF WASH 11/13/2020 249,000 00 221,024.85 249,000.00 0.400 0.400 10/15/2025 51507LBZ6 1628 LANDMARK COMMUNITY BANK 10/29/2020 249,000.00 220,691.19 249,000.00 0.400 0.400 10/29/2025 33744AAW9 1630 FIRST US BANK 11/18/2020 249,000.00 220,238.01 249,000.00 0.400 0.400 11/18/2025 50116CCP2 1631 KS STATEBANK 11/30/2020 249,000.00 220,345.08 249,000.00 0.450 0.450 11/28/2025 90348JN48 1632 UBS BANK USA 06/23/2021 249,000.00 218,183.76 249,000.00 0.750 0.750 06/23/2026 649447UZO 1633 NEW YORK COMMUNITY BANK 06/30/2021 249,000.00 217,817.73 249,000.00 0.700 0.700 07/01/2026 856285C41 1650 STATE BANK OF INDIA 01/13/2022 248,000.00 219,408.08 248,000.00 1.400 1.400 NR NR 0111312027 89235MMP3 1649 TOYOTA FINANCIAL SVGS BK 01/13/2022 248,000.00 218.929.44 248,000.00 1.350 1.350 01/13/2027 39573LCE6 1648 GREENSTATE CREDIT UNION 01/14/2022 248,000.00 218,708.72 248,000.00 1.350 1.350 01/14/2027 64034KAJO 1651 NELNET BANK INC 02/02/2022 248,000.00 219,517.20 248,000.00 1.450 1.450 02/02/2027 Subtotal and Average 12,052,804.35 11,909,000.00 11,265,269.27 11,909,000.00 1.732 Negotiable CDs 15118RSN8 1614 CELTIC BANK 10/30/2019 249,000.00 242,237 16 249,000.00 1.600 1.601 10/30/2023 33767GAMO 1608 First Bank Puerto Rico 10/28/2019 249,000.00 236,925.99 249,000.00 1.850 1.852 NR NR 10/25/2024 Subtotal and Average 498,000.00 498,000.00 479,163.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,927,100.00 2,977,983.81 1.250 2.181 07/31/2023 9128282D1 1604 U.S. Treasury Notes 06/26/2019 2,000.000.00 1,947,820.00 1,993,779.88 1.375 1.729 08/31/2023 91282CAP6 1636 U.S. Treasury Notes 07/08/2021 2,000,000.00 1,915,780 00 1,997,428.38 0,125 0.249 AAA Aaa 10/15/2023 Data Updated: SET _QTR: 10/31/2022 15:24 Run Date: 10/31/2022 - 15:24 Portfolio ENCI AC PM (PRF_PM2) 7.3.0 City of Encinitas - Qtr Inv Report Portfolio Management Portfolio Details - Investments September 30, 2022 Page 3 Average Purchase Stated YTM Maturity CUSIP Investment # Issuer Balance Date Par Value Market Value Book Value . Rate S&P Moody's Date U.S. Treasury Coupon Securities 91282CBM2 1638 U.S. Treasury Notes 07/08/2021 2,000,000.00 1.889,140.00 1,995,180.05 0.125 0.301 02/15/2024 91282CBR1 1655 U.S. Treasury Notes 03/09/2022 1.000.000.00 943,010.00 981,087.18 0.250 1.578 03/15/2024 91282CCG4 1656 U.S. Treasury Notes 03/09/2022 2,000.000.00 1,868.040.00 1,954,087.57 0.250 1.627 06/1512024 91282BY87 1634 U.S. Treasury Notes 07/08/2021 6,000.000.00 5,734,440.00 6.147,969.17 1.750 0.394 07/31/2024 912828YE4 1646 U.S. Treasury Notes 07/08/2021 2,000.000.00 1,890,320.00 2.031,576.09 1.250 0.419 08/31/2024 912828YH7 1642 U.S. Treasury Notes 07/08/2021 2,000,000.00 1,896,020.00 2.042,338.45 1.500 0.432 09/30/2024 912828YM6 1647 U.S. Treasury Notes 07/08/2021 1,000,000.00 945.630.00 1,021.601.47 1.500 0.453 10/31/2024 91282CDH1 1653 U.S. Treasury Notes 03/09/2022 1,000,000.00 929,220.00 980,614.82 0.750 1.688 11/15/2024 912828ZC7 1641 U S. Treasury Notes 07/08/2021 2,000,000.00 1,857,340.00 2.028.337.95 1.125 0.531 02/28/2025 912828ZFO 1652 U.S. Treasury Notes 03/09/2022 1.000,000.00 912,310.00 970.811.72 0.500 1.705 03/31/2025 912828ZW3 1645 U.S. Treasury Notes 07/08/2021 2,000,000.00 1,795.080.00 1,981,016.86 0.250 0.600 06/30/2025 91282CAB7 1640 U.S. Treasury Notes 07/08/2021 6,000,000.00 5.362,980.00 5,937,291.11 0.250 0.624 07131/2025 91282CAJO 1643 U.S. Treasury Notes 07/08/2021 2.000,000.00 1,781.640.00 1,977,812.50 0.250 0.636 08/31/2025 91282CAM3 1644 U.S. Treasury Notes 07/08/2021 2,000.000.00 1,777,500.00 1,976,523.06 0.250 0.648 09/30/2025 91282CAT8 1657 U.S. Treasury Notes 03/09/2022 1,000,000.00 885,590.00 955.157.08 0.250 1.759 10/31/2025 91282CBQ3 1639 U.S. Treasury Notes 07/08/2021 2,000.000.00 1,764.760.00 1,985,249.21 0.500 0.720 02/28/2026 91282CBT7 1635 U.S. Treasury Notes 07/08/2021 2,000.000.00 1,775.860.00 2,000,924.29 0.750 0.736 AAA Aaa 03/31/2026 91282CCJ8 1654 U.S. Treasury Notes 03/09/2022 1,000,000.00 885.310.00 968,086.88 0.875 1.763 06/30/2026 91282CCP4 1659 U.S. Treasury Notes 03/10/2022 4,000,000.00 3,498.280.00 3,829,376.95 0.625 1.787 07/31/2026 Subtotal and Average 53,331,276.09 49,000,000.00 45,183,170.00 48,734,234.48 0.930 Federal Agency Coupon Securities 3135GOT78 1589 Federal Nat'l Mortgage Assoc. 03/27/2019 2.000.000.00 1,999,840.00 1.999,959.56 2.000 2.190 10/05/2022 3135GOT78 1603 Federal Nat'l Mortgage Assoc. 06/26/2019 1,000,000.00 999,920.00 1.000,027,93 2.000 1.740 10/05/2022 3133EDWW8 1600 Federal Farm Credit 06/26/2019 1,000,000.00 999.950.00 1,000.109.58 2.600 1.784 10/06/2022 3133EC404 1558 Federal Farm Credit 02/23/2018 2,000,000.00 1,995,560.00 1,997,628.07 1.820 2.700 AA+ Aaa 11/23/2022 3133EJBP3 1590 Federal Farm Credit 03/27/2019 2.000,000.00 1.990,840.00 2,001,856.50 2.500 2.210 AAA Aaa 02/02/2023 3133EKSN7 1605 Federal Farm Credit 06/26/2019 4,000,000.00 3.926,080.00 3,999,151.26 1.770 1.800 AAA Aaa 06/26/2023 3133EHST1 1591 FEDERAL FARM CREDIT BANK 03/27/2019 1,000.000.00 981,770.00 998,257.25 2.010 2.234 07/26/2023 3135GOU43 1602 Federal Nat'l Mortgage Assoc. 06/26/2019 2.000,000.00 1,971,340.00 2.019.501.78 2.875 1.801 09/12/2023 3133EHN25 1606 FEDERAL FARM CREDIT BANK 06/26/2019 2.000.000.00 1,956,720.00 2,008,183.77 2.200 1.805 11/01/2023 3135GO6G3 1658 Federal Nat'l Mortgage Assoc. 03/09/2022 1.000,000.00 890,540.00 960.796.05 0,500 1.813 11/07/2025 3130AN4T4 1637 Federal Home Loan Bank 07/08/2021 2,000,000.00 1,772.880.00 2,007.577.85 0.875 0.770 06/12/2026 Subtotal and Average 19,994,302.27 20,000,000.00 19,485,440.00 19,993,049.60 1.886 Portfolio ENCI Data Updated: SET _QTR: 10/31/2022 15:24 AC Run Date: 10/31/2022 -15:24 PM (PRF_PM2) 7.3.0 City of Encinitas - Qtr Inv Report Portfolio Management Portfolio Details - Investments September 30, 2022 Average Purchase Stated YTM CUSIP Investment # Issuer Balance Date Par Value Market Value Book Value Rate S&P Mood 's Total and Average 115,462,316.60 109,753,946.37 104,759,988.79 109,481,230.45 1.529 Page 4 Portfolio ENCI Data Updated: SET _QTR: 10/31/2022 15:24 AC Run Date: 10/31/2022 - 15:24 PM (PRF_PM2) 7.3.0 City of Encinitas - Qtr Inv Report Portfolio Management Portfolio Details - Cash September 30, 2022 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. 6,713,510.03 6,713,510.03 6,713,510.03 0.000 Average Balance 0.00 Total Cash and Investments 115,462,316.60 116,467, 456.40 111,473,498.82 116,194,740.48 1.529 Page 5 Portfolio ENCI Data Updated: SET_QTR: 10/31/2022 15:24 AC Run Date: 10/31/2022 - 15:24 PM (PRF_PM2) 7.3.0 City of Encinitas - Qtr Inv Report Portfolio Management Activity By Type Page 1 July 1, 2022 through September 30, 2022 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. 20,718,243.47 19,581,892.28 Subtotal 20,718,243.47 19, 581,892.28 0.00 Local Agency Investment Funds (Monthly Summary) SYS1012 1012 CA LAIF 0.990 57,645 10 21,500,000.00 Subtotal 57,645.10 21,500,000.00 12,824,102.31 Managed Pool Accounts (Monthly Summary) SYS1003 1003 CA Asset Management Program 1.140 4,597.13 0.00 SYS1584 1584 SD County Investment Pool 1.130 2,772.52 0.00 Subtotal 7,369.65 0.00 Money Market Funds (Monthly Summary) SYS1004 1004 US BANK Subtotal Certificates of Deposit - Bank 14042RGN5 1552 Capital One NA 1404203Q1 1553 Capital One Bank USA, NA 87270LAD5 1554 TIAA FSB Subtotal 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 Subtotal Federal Agency Coupon Securities Subtotal Total 1.370 2.300 07/19/2022 2.300 07/19/2022 2.150 07/19/2022 1.875 08/31/2022 2.000 07/31/2022 1.875 09/30/2022 9,133, 577.14 9,133,577.14 0.00 0.00 0.00 0.00 1,196.00 2,308,558.67 1,196.00 13,214,285.39 245,000.00 245,000.00 245.000.00 735,000.00 11,909,000.00 498,000.00 2,000,000.00 4,000,000.00 2,000,000.00 8,000,000.00 48,734,234.48 19,993,049.60 29,916,835.36 49,818,088.28 109,481,230.45 Portfolio ENCI Data Updated: SET _QTR: 10/31/2022 15:24 AC Run Date: 10/31/2022 - 15:24 PM (PRF_PM3) 7.3.0 Report Ver. 7.3.6.1 City of Encinitas - Qtr Inv Report Portfolio Management Page 1 Interest Earnings Summary September 30, 2022 September 301VIonth Ending Fiscal Year To Date CD/Coupon/Discount Investments: Interest Collected 374,400.84 374,400.84 Plus Accrued Interest at End of Period 186,543.66 186,543.66 Less Accrued Interest at Beginning of Period ( 291,834.97) ( 291,834.97) Less Accrued Interest at Purchase During Period ( 0.00) ( 0.00) Interest Earned during Period 269,109.53 269,109.53 Adjusted by Premiums and Discounts 25,241.16 25,241.16 Adjusted by Capital Gains or Losses 0.00 0.00 Earnings during Periods Pass Through Securities: Interest Collected Plus Accrued Interest at End of Period Less Accrued Interest at Beginning of Period Less Accrued Interest at Purchase During Period Interest Earned during Period Adjusted by Premiums and Discounts Adjusted by Capital Gains or Losses 294, 350.69 294,350.69 0.00 0.00 0.00 0.00 ( 0.00) ( 0.00) ( 0.00) ( 0.00) 000 0.00 0.00 0.00 0.00 0.00 Earnings during Periods 0.00 0.00 Cash/Checking Accounts: Interest Collected 89,191.05 89,191.05 Plus Accrued Interest at End of Period 92,747.45 92,747.45 Less Accrued Interest at Beginning of Period ( 63,941.98) ( 63,941.98) Interest Earned during Period 117,996.52 117,996.52 Total Interest Earned during Period 387,106.05 387,106.05 Total Adjustments from Premiums and Discounts 25,241.16 25,241.16 Total Capital Gains or Losses 0.00 0.00 Total Earnings during Period 412,347.21 412,347.21 Portfolio ENCI Data Updated: SET_QTR: 10/31/2022 15:24 AC Run Date: 10/31/2022 - 15:24 No fiscal year history available PM (PRF_PM6) 7.3.0 Report Ver. 7.3.6.1 City of Encinitas - Qtr Inv Report Investments by Type Active Investments September 30, 2022 CITY OF ENCINITAS 505 S. VULCAN Encinitas, CA 92024 (760)633-2641 CUSIP Investment # Fund Issuer Par Value Purchase Price Remaining Cost Current Maturity Call Call Rate Date Date Price Passbook/Checking Accounts SYS1010 1010 001 Union Bank Checking Acct. 6,713,510.03 100.0000000 6,713,510.03 Subtotal 6,713,510.03 6,713,510.03 Local Agency Investment Funds SYS1012 1012 001 CA LAIF 12,824,102.31 100.0000000 12,824,102.31 0.990 Subtotal 12,824,102.31 12,824,102.31 Managed Pool Accounts SYS1003 1003 001 CA Asset Management Program 1,077,158.84 100.0000000 1,077,158.84 1.140 SYS1584 1584 001 SD County Investment Pool 1,231,399.83 100.0000000 1,231,399.83 1.130 Subtotal 2,308,558.67 2,308,558.67 Money Market Funds SYS1004 1004 001 US BANK 13,214,285.39 100.0000000 13,214,285.39 1.370 Certificates of Deposit - Bank 020080BUO 1619 02589AAM4 1580 06251AW48 1585 05580AM B7 1562 17312OH69 1563 200056QRZ8 1595 203522AT4 1610 20033AZK5 1571 219255AK2 1623 15201QCJ4 1620 249398BT4 1596 27002YEQ5 1594 29278TAU4 1568 29367SJOB 1607 Subtotal 13,214,285.39 13,214,285.39 001 ALMA BANK 249,000.00 100.0000000 249.000.00 0.900 09/29/2023 001 American Express National Bank 245,000.00 100.0000000 245,000.00 3.300 06/26/2023 001 BANK HAPOALIM BM NY 246.000.00 100.0000000 246,000.00 2.900 03/25/2024 001 BMW Bank North America 246,000.00 100.0000000 246,000.00 2.900 03/29/2023 001 Citi Bank NA 246.000.00 100.0000000 246,000.00 2.850 03/29/2023 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 Comen(ty 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 001 EAGLEBANK 249,000.00 100.0000000 249.000.00 2.300 06/20/2024 001 Enerbank USA 246,000.00 100,0000000 246,000.00 2.850 03/29/2023 001 ENTERPRISE BANK AND TRUST 249,000.00 100.0000000 249.000.00 1.800 11/08/2024 Portfolio ENCI Data Updated: SET_QTR: 10/31/2022 15:24 AC Run Date: 10/31/2022 - 15:24 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 September 30, 2022 Page 2 Purchase Current Maturity Call Call CUSIP Investment# Fund Issuer Par Value Price Remaining Cost Rate Date Date Price Certificates of Deposit - Bank 300185JF3 1615 001 EVERGREEN BANK GROUP 249,000.00 100.0000000 249,000.00 1.000 03/26/2025 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 33646CJPO 1569 001 First Source Bank 246,000.00 100.0000000 246,000.00 2.850 04/11/2023 45581 EASO 1564 001 Industrial & Comm Bank China 249,000.00 100.0000000 249,000.00 2.900 03/29/2023 50116CCP2 1631 001 KS STATEBANK 249,000.00 100.0000000 249,000.00 0.450 11/28/2025 501798LT7 1566 001 LCA Bank Corp 246,000.00 100,0000000 246.000.00 2.800 03/29/2023 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 58404DBL4 1561 001 Medallion Bank UT 249,000.00 100.0000000 249,000.00 2.900 03/28/2023 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 61747MR37 1565 001 Morgan Stanley Bank 246.000.00 100.0000000 246,000.00 2.900 03/29/2023 654062JRO 1625 001 NICOLET NATIONAL BANK 249,000.00 100.0000000 249,000.00 1.150 03/28/2024 64034KAJO 1651 001 NELNET BANK INC 248,000.00 100.0000000 248,000.00 1.450 02/02/2027 649447UZO 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 BANKISARDIS TN 249,000.00 100.0000000 249,000.00 1.000 09/30/2024 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 79545OS89 1570 001 Sallie Mae Bank/Murray 245.000.00 100.0000000 245,000.00 3.300 06/27/2023 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 90348JN48 1632 001 UBS BANK USA 249.000.00 100.0000000 249,000.00 0.750 06/23/2026 39573LCE6 1648 001 GREENSTATE CREDIT UNION 248,000.00 100 0000000 248,000.00 1.350 01/14/2027 33744AAW9 1630 001 FIRST US BANK 249.000.00 100.0000000 249.000.00 0.400 11/18/2025 Subtotal 11,909,000.00 11,909,000.00 Negotiable CDs Portfolio ENCI Data Updated: SET _QTR: 10/31/2022 15:24 AC Run Date: 10/31/2022 - 15:24 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 September 30, 2022 Page 3 Purchase Current Maturity Call Call CUSIP Investment# Fund Issuer Par Value Price Remaining Cost Rate Date Date Price Negotiable CDs 1511BRSN8 1614 001 CELTIC BANK 249,000.00 100.0000000 249.000.00 1 600 10/30/2023 33767GAMO 1608 001 First Bank Puerto Rico 249,000.00 100.0000000 249,000.00 1.850 10/25/2024 Subtotal 498,000.00 498,000.00 U.S. Treasury Coupon Securities 912828S92 1592 001 U.S. Treasury Notes 3,000,000.00 96.1562500 2,884,687.50 1.250 07/31/2023 9128282D1 1604 001 U.S. Treasury Notes 2,000,000.00 98.5781250 1,971,562 50 1.375 08/31/2023 912828Y87 1634 001 U.S. Treasury Notes 6,000,000.00 104.1250000 6,247,500.00 1 750 07/31/2024 91282CBT7 1635 001 U.S. Treasury Notes 2,000,000.00 100.0625000 2,001,250.00 0.750 03/31/2026 91282CAP6 1636 001 U.S. Treasury Notes 2,000,000.00 99.7187500 1,994,375.00 0.125 10/15/2023 91282CBM2 1638 001 U.S. Treasury Notes 2,000,000.00 99.5429690 1,990,859.38 0.125 02/15/2024 91282CBQ3 1639 001 U.S. Treasury Notes 2,000,000.00 98.9960940 1,979,921.88 0.500 02/28/2026 91282CAB7 1640 001 U.S. Treasury Notes 6,000,000.00 98.5000000 5,910,000.00 0.250 07/31/2025 912828ZC7 1641 001 U.S. Treasury Notes 2,000,000.00 102.1406250 2,042,812.50 1.125 02/28/2025 912828YH7 1642 001 U.S. Treasury Notes 2,000,000.00 103.4218750 2,068,437.50 1.500 09/30/2024 91282CAJO 1643 001 U.S. Treasury Notes 2,000,000.00 98.4218750 1,968,437.50 0.250 08/31/2025 91282CAM3 1644 001 U.S. Treasury Notes 2,000,000.00 98.3437500 1,966,875.00 0.250 09/30/2025 912828ZW3 1645 001 U.S. Treasury Notes 2.000.000.00 98.6250000 1,972,500.00 0.250 06/30/2025 912828YE4 1646 001 U.S. Treasury Notes 2,000,000.00 102.5937500 2,051,875.00 1,250 08/31/2024 912828YM6 1647 001 U.S. Treasury Notes 1,000,000.00 103.4375000 1,034,375,00 1,500 10/31/2024 912828ZFO 1652 001 U.S. Treasury Notes 1,000,000.00 96.4218750 964,218.75 0.500 03/31/2025 91282CDH1 1653 001 U.S. Treasury Notes 1,000,000.00 97.5463750 975,468.75 0.750 11/15/2024 91282CCJ8 1654 001 U.S. Treasury Notes 1,000,000.00 96.3281250 963,28125 0.875 06/30/2026 91282CBR1 1655 001 U.S. Treasury Notes 1,000,000.00 97.3750000 973,750.00 0.250 03/15/2024 91282CCG4 1656 001 U.S. Treasury Notes 2,000,000.00 96 9453125 1,938,906.25 0.250 06/15/2024 91282CATB 1657 001 U.S. Treasury Notes 1,000,000.00 94.6953130 946,953A3 0.250 10/31/2025 91282CCP4 1659 001 U.S. Treasury Notes 4,000,000.00 95.1093750 3,804,375.00 0,625 07/31/2026 Subtotal 49,000,000.00 48,652,421.89 Federal Agency Coupon Securities 3133EHST1 1591 001 FEDERAL FARM CREDIT BANK 1,000,000.00 99.0790000 990,790.00 2.010 07/26/2023 3133EHN25 1606 001 FEDERAL FARM CREDIT BANK 2,000,000 00 101.6420000 2,032,840.00 2.200 11/01/2023 3133EC4Q4 1558 001 Federal Farm Credit 2,000,000.00 96.1000000 1,922,000.00 1.820 11/23/2022 3133EJBP3 1590 001 Federal Farm Credit 2,000,000.00 101,0625000 2,021,250.00 2.500 02/02/2023 3133EDWW8 1600 001 Federal Farm Credit 1,000,000.00 102.5860000 1,025,860.00 2.600 10/06/2022 3133EKSN7 1605 001 Federal Farm Credit 4,000,000.00 99.8847000 3,995,388.00 1.770 06/26/2023 Portfolio ENCI Data Updated: SET _QTR: 10/31/2022 15:24 AC Run Date 10/31/2022 - 15:24 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 September 30, 2022 Page 4 Purchase Current Maturity Call Call CUSIP Investment # Fund Issuer Par Value Price Remaining Cost Rate Date Date Price Federal Agency Coupon Securities 3130AN4T4 1637 001 Federal Home Loan Bank 2,000,000.00 100.5050000 2,010,100.00 0.875 06/12/2026 3135GOT78 1589 001 Federal Nat'l Mortgage Assoc. 2,000,000.00 99.3590000 1,987,180.00 2.000 10/05/2022 3135GOU43 1602 001 Federal Nat'l Mortgage Assoc. 2,000,000.00 104.3350000 2,086,700.00 2.875 09/12/2023 3135GOT78 1603 001 Federal Nat'l Mortgage Assoc. 1,000,000.00 100.8231000 1,008,231.00 2.000 10/05/2022 3135GOGG3 1658 001 Federal Nat'l Mortgage Assoc. 1,000,000.00 95.3700000 953,700.00 0.500 11/07/2025 Subtotal 20,000,000.00 20,034,039.00 Total 116,467,456.40 116,153,917.29 Portfolio ENCI Data Updated: SET _QTR: 10/31/2022 15:24 AC Run Date: 10/31/2022 - 15:24 No fiscal year history available DT (PRF_DT) 7.1.1 Report Ver. 7.3.6.1 OF ENCINITAS City of Encinitas - Qtr Inv Report CITY 05 S. VULCAN Interest Earnings Encinitas, CA 92024 (760)633-2641 Sorted by Fund - Fund July 1, 2022 - September 30, 2022 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 12,824,102.31 34,266,457.21 12,824,102.31 1.630 0.743 64,187.84 0.00 64,187.84 SYS1584 1584 001 COUNTY 1,231,399,83 1,228,627.31 1.231,399.83 1.680 1.526 4,724.88 0.00 4,724.88 SYS1003 1003 001 CAMP 1,077,158.84 1,072,561.71 1,077,158.84 2.610 2.185 5,906.74 0.00 5,906.74 SYS1004 1004 001 UBCUST 13,214,285.39 4,081,904.25 13,214,285.39 2.810 4.197 43.177.06 0.00 43,177.06 SYS1010 1010 001 UBCKG 6,713,510.03 5,577,158.84 6,713,510.03 0.00 0.00 0.00 3130AN4T4 1637 001 FHLB 2,000,000.00 2,008.090.25 2,007,577.85 06/12/2026 0.875 0.763 4,375.00 -512.40 3.862.60 3135GOU43 1602 001 FNMA 2,000,000.00 2,024,648.88 2,019,501.78 09/12/2023 2.875 1.808 14,375.00 -5,147.10 9,227.90 3135G06G3 1658 001 FNMA 1,000,000.00 957,634.45 960,796.05 11/07/2025 0.500 1.828 1,250.00 3,161.60 4,411.60 3135GOT78 1603 001 FNMA 1,000,000,00 1,000,656.25 1,000,027.93 10/05/2022 2.000 1.733 5,000.00 -628.32 4,371.68 3135GOT78 1589 001 FNMA 2,000,000.00 1,999,049.62 1,999,959.56 10/05/2022 2.000 2.165 10,000.00 909.94 10,909.94 3133EKSN7 1605 001 FFCRED 4,000,000.00 3,998,863.01 3,999,151.26 06/26/2023 1.770 1.785 17,700.00 288.25 17,988.25 3133EJBP3 1590 001 FFCRED 2,000,000.00 2,003,237 36 2,001,856.50 02/02/2023 2.500 2.202 12,500.00 -1,380.86 11,119.14 3133EC404 1558 001 FFCRED 2,000,000.00 1,993,522.81 1,997,628.07 11/23/2022 1.820 2.628 9,100.00 4,105.26 13,205.26 3133EDWW8 1600 001 FFCRED 1,000,000.00 1,002,081.95 1,000,109.58 10/06/2022 2.600 1.793 6,500.00 -1,972.37 4,527.63 912828Y87 1634 001 UST 6,000,000.00 6,168,317.69 6,147,969.17 07/31/2024 1.750 0.389 26,391.88 -20,348.52 6,043.36 9128282131 1604 001 UST 2,000,000.00 1,992,066.55 1,993,779.88 08/31/2023 1.375 1.718 6,913.39 1,713.33 8,626.72 91282CBT7 1635 001 UST 2,000,000.,00 2,000,990.88 2,000,92429 03/31/2026 0.750 0.734 3,770.72 -66.59 3,704.13 91282CAP6 1636 001 UST 2,000,000.00 1,996,804.13 1,997,428.38 10/15/2023 0.125 0.249 628.41 624.25 1,252.66 91282CAB7 1640 001 UST 6,000,000.00 5,931,711.59 5,937,291.11 07/31/2025 0.250 0.625 3,770.26 5,579.52 9,349.78 91282CDH1 1653 O01 UST 1,000,000.00 978,316.57 980,614.82 11/15/2024 0.750 1.692 1,875.00 2,298.25 4,17325 91282CCJ8 1654 001 UST 1,000,000.00 965,940.68 968,086.88 06/30/2026 0.875 1.780 2,187.50 2,14620 4,333.70 91282BYM6 1647 001 UST 1,000,000.00 1,024,212.94 1,021,601.47 10/31/2024 1.500 0.441 3,750.00 -2,611.47 1,138.53 91282CBR1 1655 001 UST 1,000.000.00 977.810.38 981,087.18 03/15/2024 0.250 1.584 626.80 3,276.80 3,903.60 912828YE4 1646 001 UST 2,000,000.00 2,035,726.09 2.031,576.09 08/31/2024 1.250 0.416 6,284.90 -4,150.00 2,134.90 91282CAT8 1657 001 UST 1,000.000,00 951,493.18 955,157.08 10/31/2025 0.250 1.788 625.00 3,663.90 4,288.90 91282CCG4 1656 001 UST 2,000,000.00 1,947,307.56 1,954,087.57 06/15/2024 0250 1,637 1,256.83 6.780.01 8.036.84 912828YH7 1642 001 UST 2,000,000.00 2,047,674.26 2,042,338.45 09/30/2024 1.500 0.427 7,541.44 -5,335.81 2,205.63 91282CBQ3 1639 001 UST 2,000,000.00 1,984.160.07 1,985,249.21 02/28/2026 0.500 0.720 2,513.96 1,089.14 3,603.10 912828ZF0 1652 001 UST 1.000,000.00 967,867.29 970,811.72 03/31/2025 0.500 1.722 1,256.91 2,944.43 4.201.34 91282CBM2 1638 001 UST 2,000,000.00 1,994,296.71 1,995,180.05 02/15/2024 0,125 0.301 630.06 883.34 1.513.40 Portfolio ENCI Data Updated: SET _QTR: 10/31/2022 15:24 AC Run Date: 10/31/2022 - 15:24 No fiscal year history available - IE (PRF_IE) 7.2.0 Report Ver. 7.3.6.1 City of Encinitas - Qtr Inv Report CUSIP Investment # Fund Issuer Ending par Value Interest Earnings July 1, 2022 - September 30, 2022 Beginning Ending Book Value Book Value Maturity Date Current Rate Annualized Yield Interest Earned Page 2 Adjusted Interest Earnings Amortization/ Adjusted Interest Accretion Earnings Fund: General Investments 91282CCP4 1659 001 UST 4,000,000.00 3.820,780.87 3,829.376.95 07/31/2026 0.625 1.818 6.283.78 11.220,39 17.504.17 91282CAM3 1644 001 UST 2,000,000.00 1.974,550.57 1,976,523.06 09/30/2025 0.250 0.649 1.256.91 1,972.49 3.229.40 912828ZC7 1641 001 UST 2,000.000.00 2.031,297.19 2,028,337.95 02/28/2025 1.125 0.527 5.656.42 -2,959.24 2,697.18 9128282W9 1579 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 912828XQ8 1578 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 91282BS92 1592 001 UST 3,000.000.00 2,971.299.03 2,977.983.81 07/31/2023 1.250 2.151 9,425.66 6,684.78 16.110.44 912828ZW3 1645 001 UST 2,000.000.00 1,979,275.64 1,981.016.86 06/30/2025 0.250 0.600 1,250.00 1,741.22 2,991.22 9128281-24 1572 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 91282CAJO 1643 001 UST 2,000.000.00 1,975,895.83 1,977.812.50 08/31/2025 0.250 0.637 1,256.98 1,916.67 3,173.65 79545OS89 1570 001 SMAEBN 245,000 00 245,000.00 245.000.00 06/27/2023 3.300 3.300 2,037.87 0.00 2,037.87 05580AMB7 1562 001 BMWBNK 246,000.00 246,000.00 246.000.00 03/29/2023 2.900 2.900 1,798.16 0.00 1,798.16 20033AZK5 1571 001 COMNTY 245.000.00 245,000.00 245.000.00 06/29/2023 3.300 3.300 2.037.86 0.00 2,037.86 1404203Q1 1553 001 CAPONE 0.00 245.000.00 0.00 07/19/2022 2.300 2.300 277.89 0.00 277.89 33767GAMO 1608 001 FBPR 249,000.00 249,000,00 249,000.00 10/25/2024 1.850 1,850 1,161.10 0.00 1,161.10 14042RGN5 1552 001 CAPINA 0.00 245,000.00 0.00 07/19/2022 2.300 2.300 277.89 0.00 277.89 87270LAD5 1554 001 TIAAFS 0.00 245,000.00 0.00 07/19/2022 2.150 2.150 259.77 0.00 259.77 58404DBL4 1561 001 MEDALL 249,000.00 249,000.00 249,000.00 03/28/2023 2.900 2.900 1.820.09 0.00 1,820.09 17312QH69 1563 001 CITIBK 246,000.00 246.000.00 246.000.00 03/29/2023 2.850 2.850 1.767.16 0.00 1.767.16 45581EASO 1564 001 INDUST 249.000.00 249,000.00 249,000.00 03/29/2023 2.900 2.900 1.820.09 0.00 1,820.09 61747MR37 1565 001 MORSTN 246.000.00 246.000.00 246,000.00 03/29/2023 2.900 2.900 1.798.16 0.00 1,798.16 501798LT7 1566 001 LCABNK 246,000.00 246,000.00 246.000.00 03/29/2023 2.800 2.800 1,736.15 0.00 1,736.15 29278TAU4 1568 001 ENERBK 246,000.00 246,000.00 246,000.00 03/29/2023 2.850 2.850 1,767.16 0.00 1,767.16 33646CJPO 1569 001 FSRCBK 246,000.00 246,000.00 246,000.00 04/11/2023 2.850 2.850 1,767.16 0.00 1,767.16 02589AAM4 1580 001 AMEXNL 245,000.00 245,000.00 245,000.00 06/26/2023 3,300 3.300 2.037.87 0.00 2,037.87 06251AW48 1585 001 BKHAPO 246,000.00 246,000.00 246,000.00 03/25/2024 2.900 2.900 1,798.16 0.00 1,798.16 3133EHST1 1591 001 FFCB 1,000,000.00 997,725.56 998,257.25 07/26/2023 2.010 2.210 5.025.00 531.69 5.556.69 3133EHN25 1606 001 FFCB 2,000,000.00 2,010,072.33 2.008,183.77 11/01/2023 2.200 1.798 11.000.00 -1,888.56 9.111.44 27002YEQ5 1594 001 EGLEBK 249,000.00 249,000.00 249,000.00 06/20/2024 2.300 2.300 1.443.51 0.00 1.443.51 200056ORZ8 1595 001 CMBKGN 249.000.00 249.000.00 249.000.00 06/26/2024 2.300 2,300 1,443,51 0,00 1,443.51 61760AG52 1593 001 MGSTPB 246.000.00 246.000.00 246.000.00 06/13/2024 2.600 2.600 1,612.14 0.00 1,612.14 249398BT4 1596 001 DENSVB 249,000.00 249.000.00 249,000.00 06/21/2023 2.250 2.250 1.412.14 0.00 1.412.14 59013KAR7 1597 001 MERRBK 249,000.00 249,000.00 249.000.00 12/28/2023 2.400 2.400 1,506.28 0.00 1,506.28 336460CQ1 1598 001 FSBDQ 249,000.00 249.000.00 249,000.00 06/28/2024 2.300 2.300 1,443.51 0.00 1,443.51 761400BY1 1599 001 RVBANK 247,000.00 247,000.00 247,000.00 06/28/2024 2.300 2.300 1,431.93 0.00 1,431.93 15118RSN8 1614 001 CELTIC 249,000.00 249,000.00 249.000.00 10/30/2023 1.600 1.600 1.004.19 0.00 1.004.19 29367SJQB 1607 001 ENTERB 249,000.00 249,000.00 249,000.00 11/08/2024 1.800 1.800 1.129.70 0.00 1.129.70 33640VDE5 1609 001 FIRSTS 249,000.00 249.000.00 249,000.00 11/15/2023 1.700 1.700 1,066.96 0.00 1,066.96 Portfolio ENCI Data Updated: SET _QTR: 10/31/2022 15:24 AC Run Date, 10/31/2022 - 15:24 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 -September 30, 2022 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 203522AT4 1610 001 COMMBK 249,000.00 249.000.00 249,000.00 11/08/2024 1.650 1.650 1.035.56 0.00 1,035.56 73319FAD1 1611 001 POPBK 249,000.00 249,000.00 249,000.00 11/04/2024 1.650 1.650 1,035.56 0.00 1,035.56 89579NCB7 1612 001 TRIADB 249,000.00 249,000.00 249.000.00 11/08/2024 1.800 1.800 1,129.70 0.00 1,129.70 695292FP2 1613 001 PADUCA 249,000.00 249,000.00 249,000.00 11/08/2024 1.650 1.650 1,035.56 0.00 1,035.56 300185JF3 1615 001 EVRGRN 249,000.00 249,000.00 249,000.00 03/26/2025 1.000 1.000 627.62 0.00 627.62 34969RCS5 1616 001 FORTUB 249,000.00 249,000.00 249,000.00 03/27/2024 1.000 1.000 627,62 0.00 62762 59565QCS2 1617 001 MIDCBK 249,000.00 249,000.00 249.000.00 03/27/2025 1.000 1.000 627.62 0.00 627.62 52465JHT7 1618 001 LEGEND 249,000.00 249,000.00 249,000.00 09/30/2024 1.000 1,000 627.62 000 627.62 020080BUO 1619 001 ALMABK 249,000,00 249.000.00 249,000.00 09/29/2023 0.900 0.900 564.85 0.00 564.85 15201QCJ4 1620 001 CTRSTE 248,000.00 248,000.00 248,000.00 03/31/2025 1.000 1.000 625.09 0.00 625.09 694231AD3 1621 001 PACENT 249,000.00 249,000.00 249,000.00 03/31/2025 1.150 1.150 721.76 0.00 721.76 538036KU7 1622 001 LIVOAK 249,000.00 249,000.00 249.000.00 03/31/2025 1.100 1.100 69068 0.00 690.38 219255AK2 1623 001 CRNHSK 249,000.00 249,000.00 249,000.00 03/29/2024 1.100 1.100 690.38 0.00 690.38 710673AC8 1624 001 PEBATN 249,000.00 249.000.00 249.000.00 09/30/2024 1.000 1.000 627.62 0.00 627.62 654062JRO 1625 001 NCBS 249,000.00 249,000.00 249,000.00 03/28/2024 1.150 1.150 721.76 0.00 721.76 549104SS7 1627 001 LUANSB 249,000,00 249,000.00 249,000.00 10/02/2025 0.400 0.400 251.04 0.00 251.04 33847E4E4 1626 001 FLGSB 249,000.00 249,000.00 249,000.00 09/30/2024 0.400 0.400 251.05 0.00 251.05 51507LBZ6 1628 001 LDMCB 249.000,00 249,000.00 249,000.00 10/29/2025 0.400 0.400 251.04 0.00 251.04 33625CDVB 1629 001 FSECWA 249,000,00 249,000.00 249,000.00 10/15/2025 0.400 0.400 251.04 0.00 251.04 33744AAW9 1630 001 USBI 249,000 00 249,000.00 249,000.00 11/18/2025 0.400 0.400 251.04 0.00 251.04 50116CCP2 1631 001 KANBNK 249,000.00 249,000.00 249,000.00 11/28/2025 0.450 0.450 28244 0.00 282.44 90348JN48 1632 001 UBS 249,000.00 249,000.00 249,000.00 06/23/2026 0.750 0.750 470.71 0.00 470.71 649447UZO 1633 001 NYCB 249.000.00 249,000.00 249,000.00 07/01/2026 0.700 0.700 439.33 0.00 439.33 39573LCE6 1648 001 UNIICC 248,000.00 248,000.00 248,000.00 01/14/2027 1.350 1.350 843.88 0.00 843.88 89235MMP3 1649 001 TOYFBN 248,000.00 248,000.00 248,000.00 01/13/2027 1.350 1.350 843.88 0.00 843.88 856285C41 1650 001 SBIIN 248,000.00 248,000,00 248,000.00 01/13/2027 1.400 1.400 875.14 0.00 875.14 64034KAJO 1651 001 NELNTB 248,000.00 248,000,00 248,000.00 02/02/2027 1.450 1.450 906.39 0.00 906.39 Subtotal 116,467,456.40 136,073,376.65 116,194,740.48 1.238 387,106.05 25,241.16 412,347.21 Total 116,467,456.40 136,073,376.55 116,194,740.48 1.238 387,106.05 25,241.16 412,347.21 Portfolio ENCI Data Updated: SET _QTR: 10/31/2022 15:24 AC Run Date: 10/31/2022 - 15:24 No fiscal year history available IE (PRF_IE) 72.0 Report Ver. 7.3.6.1 City of Encinitas - Qtr Inv Report CITY OF ITAS - 05 S. VULCAN Investments by Issuer Encinitas, CA 92024 Active Investments (760)633-2641 Sorted by Fund September 30, 2022 Investment Current Market YTM Redemption Days To Call CUSIP Investment# Security Type Class Remaining Cost Ratc _ Market Value bate 365 ❑,ice hlatiirit •o Collateral _.p r7.ti ALMA BANK 020080BU0 1619 Certificates of Deposit - Bank Amort 249.000.00 0 900 241.091.76 09/30/2022 0.900 09/29/2023 363 Subtotal and Average 249,000.00 241,091.76 0.900 363 American Express National Bank 02589AAM4 1580 Certificates of Deposit - Bank Amort 245,000.00 3.300 243,870.55 09/30/2022 3.300 06/26/2023 268 Subtotal and Average 245,000.00 243,870.55 3.300 268 BANK HAPOALIM BM NY 06251AW48 1585 Certificates of Deposit - Bank Amort 246,000.00 2.900 241,350.60 09/30/2022 2.900 03/25/2024 541 Subtotal and Average 246,000.00 241,350.60 2.900 541 BMW Bank North America 05580AMB7 1562 Certificates of Deposit - Bank Amort 246,000.00 2.900 244.792.14 09/30/2022 2.900 03/29/2023 179 Subtotal and Average 246,000.00 244,792.14 2.900 179 CA Asset Management Program SYS1003 1003 Managed Pool Accounts Amort 1,077,158.84 1.140 1,077,158.84 09/30/2022 1.140 1 Subtotal and Average 1,077,158.84 1,077,158.84 1.140 1 CELTIC BANK 15118RSN8 1614 Negotiable CDs Amort 249,000.00 1.600 242.237.16 09/30/2022 1.601 10/30/2023 394 Subtotal and Average 249,000.00 242,237.16 1.601 394 Citi Bank NA 17312QH69 1563 Certificates of Deposit - Bank Amort 246,000.00 2.850 244,733.10 09/30/2022 2.850 03/29/2023 179 Subtotal and Average 246,000.00 244,733.10 2.850 179 COMMERCE BANK GENEVA MN 200056QRZ8 1595 Certificates of Deposit - Bank Amort 249,000.00 2.300 240.830.31 09/30/2022 2.300 06/26/2024 634 Subtotal and Average 249,000.00 240,830.31 2.300 634 Portfolio ENCI Data Updated: SET_QTR: 10/31/2022 15:24 AC Run Date: 10/31/2022 - 15:24 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# Security Type Class Remaining Cost Pat. Market Value Data' 365 Date Maturir4 p,,t+ Collateral COMMUNITY BANK 203522AT4 1610 Certificates of Deposit - Bank Amort 249,000.00 1.650 235,713.36 09/30/2022 1.650 11/08/2024 769 Subtotal and Average 249,000.00 235,713.36 1.650 769 Comenity Capital Bank 20033AZK5 1571 Certificates of Deposit - Bank Amort 245,000.00 3.300 243,855.85 09/30/2022 3 300 06/29/2023 271 Subtotal and Average 245,000.00 243,855.85 3.300 271 SD County Investment Pool SYS1584 1584 Managed Pool Accounts Amort 1,231,399.83 1.130 1,231,399.83 09/30/2022 1.130 1 Subtotal and Average 1,231,399.83 1,231,399.83 1.130 1 CORNHUSKER BANK 219255AK2 1623 CENTERSTATE BANK NA 15201 QCJ4 1620 Denver Savings Bank 249398BT4 1596 EAGLEBANK 27002YE05 1594 Enerbank USA 29278TAU4 1568 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 1.100 249,000.00 248,000.00 1.000 248,000.00 249,000.00 2.250 249,000.00 Certificates of Deposit - Bank Amort 249,000.00 2 300 Subtotal and Average 249,000.00 Certificates of Deposit - Bank Amort 246,000.00 2.850 Subtotal and Average 246,000.00 ENTERPRISE BANK AND TRUST 29367SJQ8 1607 Certificates of Deposit - Bank Amort Subtotal and Average 249,000.00 1 800 249,000.00 237,730.26 09/30/2022 1,100 03/29/2024 545 237,730.26 1.100 545 228,616.32 09/30/2022 1.000 03/31/2025 912 228,616.32 1.000 912 246,016.98 09130/2022 2.250 06/21/2023 263 246,016.98 2.250 263 240,917.46 09/30/2022 2.300 06/20/2024 628 240,917.46 2.300 628 244,733.10 09/30/2022 2.850 03/29/2023 179 244,733.10 2.850 179 236,465.34 09/30/2022 1.800 11/08/2024 769 236,465.34 1.800 769 Portfolio ENCI Data Updated. SET _QTR: 10/31/2022 15:24 AC Run Date: 10/31/2022 - 15:24 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 3 Investment Current Market YTM Redemption Days To Call CUSIP Investment# Security Type Class Remaining Cost Rota Market Value oat. 365 Date Maturity Mate Collateral EVERGREEN BANK GROUP 300185JF3 1615 Certificates of Deposit - Bank Amort 249,000.00 1.000 229,500.81 09/30/2022 1.000 03/26/2025 907 Subtotal and Average 249,000.00 229,500.81 1.000 907 First Bank Puerto Rico 33767GAMO 1608 FEDERAL FARM CREDIT BANK 3133EHST1 1591 3133EHN25 1606 Negotiable CDs Amort Subtotal and Average Federal Agency Coupon Securities Amort Federal Agency Coupon Securities Amort Subtotal and Average 249,000.00 1.850 249,000.00 990,790.00 2010 2,032,840.00 2.200 3,023,630.00 Federal Farm Credit 3133EC4Q4 1558 3133EJBP3 1590 3133EDWW8 1600 3133EKSN7 1605 Federal Agency Coupon Securities Fair Federal Agency Coupon Securities Amort Federal Agency Coupon Securities Amort Federal Agency Coupon Securities Amort Subtotal and Average 1,922,000.00 2,021,250.00 1.025,860.00 3,995,388.00 8,964,498.00 1.820 2.500 2.600 1.770 Federal Home Loan Bank 3130AN4T4 1637 Federal Agency Coupon Securities Amort 2.010.100.00 0.875 Subtotal and Average 2,010,100.00 FIRST SERVICE BANK 33640VDE5 1609 Certificates of Deposit - Bank Amort 249,000.00 1.700 Subtotal and Average 249,000.00 FLAGSTAR BANK FSB 33847E4E4 1626 Certificates of Deposit - Bank Amort 249,000.00 0.400 Subtotal and Average 249,000.00 Federal Nat'l Mortgage Assoc. 3135GOT78 1589 Federal Agency Coupon Securities Amort 1,987,180.00 2.000 3135GOU43 1602 Federal Agency Coupon Securities Amort 2,086,700.00 2.875 3135GOT78 1603 Federal Agency Coupon Securities Amort 1.008,231.00 2.000 236,925.99 09/30/2022 1.852 10/25/2024 755 236,925.99 1.852 755 981.770.00 09/30/2022 2.234 07/26/2023 298 1,956.720.00 09/30/2022 1.805 11/01/2023 396 2,938,490.00 1.937 361 1,995,560.00 09/30/2022 2.700 11/23/2022 53 1,990.840.00 09/30/2022 2.210 02/02/2023 124 999,950.00 09/30/2022 1.784 10/06/2022 5 3,926,080.00 09/30/2022 1.800 06/26/2023 268 8,912,430.00 2.097 159 1,772.880.00 09/30/2022 0.770 06/12/2026 1,350 1,772,880.00 0.769 1,348 242,254.59 09/30/2022 1.700 11/15/2023 410 242,254.59 1.700 410 230,554.08 09/30/2022 0.400 09/30/2024 730 230,554.08 0.400 730 1,999.840.00 09/30/2022 2.190 10/05/2022 4 1.971,340.00 09/30/2022 1.801 09/12/2023 346 999,920.00 09/30/2022 1.740 10/05/2022 4 Portfolio ENCI Data Updated: SET _QTR: 10/31/2022 15:24 AC Run Date: 10/31/2022 - 15:24 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 4 Sorted by Fund Investment Current Market YTM Redemption Days To Call CUSIP Investment# Security Type Class Remaining Cost Rate Market Value Date 365 DateM,aturity Date Collateral 3135G06G3 1658 Federal Agency Coupon Securities Amort 953,700.00 0.500 890,540.00 09/30/2022 1.813 11/07/2025 1,133 Subtotal and Average 6,036,811.00 5,861,640.00 1.905 298 FORTUNE BANK ARNOLD 34969RCS5 1616 Certificates of Deposit - Bank Amort 249,000.00 1.000 237,416.52 09/30/2022 1.000 03/27/2024 543 Subtotal and Average 249,000.00 237,416.52 1.000 543 First State Bank Dequeen 336460CQ1 1598 Certificates of Deposit - Bank Amort 249,000.00 2.300 240,802.92 09/30/2022 2.300 06/28/2024 636 Subtotal and Average 249,000.00 240,802.92 2.300 636 1ST SECURITY BK OF WASH 33625CDVB 1629 First Source Bank 33646CJP0 1569 Industrial & Comm Bank China 45581EAS0 1564 KS STATEBANK 50116CCP2 1631 CA LAW SYS1012 1012 LCA Bank Corp 501798LT7 1566 LANDMARK COMMUNITY BANK 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 Local Agency Investment Funds Amort Subtotal and Average Certificates of Deposit - Bank Amort Subtotal and Average 249,000.00 0.400 249,000.00 246,000.00 2.850 246,000.00 249,000.00 2 900 249,000.00 249,000.00 0.450 249,000.00 12, 824,102.31 0.990 12,824,102.31 246,000.00 2.800 246,000.00 221,024.85 09/30/2022 0.400 10/15/2025 1,110 221,024.85 0.400 1,110 244,649.46 09/30/2022 2.850 04/11/2023 192 244,649.46 2.850 192 247,774.92 09/30/2022 2.900 03/29/2023 179 247 774.92 2.900 179 220,345.08 09/30/2022 0450 11/28/2025 1,154 220,345.08 0.450 1,154 12,824,102.31 09/30/2022 0 990 1 12,824,102.31 0.990 1 244,671.60 09/30/2022 2.800 03/29/2023 179 244.671.60 2.800 179 Portfolio ENCI Data Updated: SET _QTR: 10/31/2022 15:24 AC Run Date: 10/31/2022 - 15:24 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# _ _ Securi Type Class Security YP Remaining Cost Rate Market Value Date 365 Date Maturity ❑ata Collateral 51507LBZ6 1628 Certificates of Deposit - Bank Amort 249,000.00 0.400 220,691,19 09/30/2022 0.400 10/29/2025 1.124 Subtotal and Average 249,000.00 220,691.19 0.400 1,124 LEGENDS BANK 52465JHT7 1618 Certificates of Deposit - Bank Amort 249,000.00 1.000 233,258.22 09/30/2022 1.000 09/30/2024 730 Subtotal and Average 249,000.00 233,258.22 1.000 730 LIVE OAK BANKING COMPANY 538036KU7 1622 Certificates of Deposit - Bank Amort 249,000.00 1.100 229,983.87 09/30/2022 1.100 03/31/2025 912 Subtotal and Average 249,000.00 229,983.87 1.100 912 LUANA SAVINGS BANK 549104SS7 1627 Certificates of Deposit - Bank Amort 249,000.00 0.400 221,567.67 09/30/2022 0.400 10/02/2025 1,097 Subtotal and Average 249,000.00 221,567.67 0.400 1,097 Medallion Bank UT 58404DBL4 1561 Certificates of Deposit - Bank Amort 249,000.00 2.900 247.789.86 09/30/2022 2.900 03/28/2023 178 Subtotal and Average 249,000.00 247,789.86 2.900 178 Merrick Bank 59013KAR7 1597 Certificates of Deposit - Bank Amort 249.000.00 2.400 243.614.13 09/30/2022 2.400 12/28/2023 453 Subtotal and Average 249,000.00 243,614.13 2.400 453 MORGAN STANLEY PRIVATE BANK 61760AG52 1593 Certificates of Deposit - Bank Amort 246.000.00 2.600 239,360.46 09/30/2022 2.600 06/13/2024 621 Subtotal and Average 246,000.00 239,360.46 2.600 621 MIDCOUNTRY BANK 59565QCS2 1617 Certificates of Deposit - Bank Amort 249,000.00 1.000 229,480.89 09/30/2022 1.000 03/27/2025 908 Subtotal and Average 249,000.00 229,480.89 1.000 908 Morgan Stanley Bank 61747MR37 1565 Certificates of Deposit - Bank Amort 246.000.00 2.900 244.792.14 09/30/2022 2,900 03/29/2023 179 Subtotal and Average 246,000.00 244,792.14 2.900 179 NICOLET NATIONAL BANK Portfolio ENCI Data Updated: SET _QTR: 10/31/2022 15:24 AC Run Date: 10/31/2022 - 15:24 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# Security Type Class Remaining Cost Rate Market Value Date 365 Dsito MatWroty Dal- Collateral 654062JR0 1625 Certificates of Deposit - Bank Amort 249,000.00 1.150 237,931.95 09/30/2022 1.150 03/28/2024 544 Subtotal and Average 249,000.00 237,931.95 1.150 544 NELNET BANK INC 64034KAJ0 1651 Certificates of Deposit - Bank Amort 248,000.00 1.450 219,51720 09/30/2022 1.450 02/02/2027 1,585 Subtotal and Average 248,000.00 219,517.20 1.450 1,585 NEW YORK COMMUNITY BANK 649447UZ0 1633 Certificates of Deposit - Bank Amort 249,000.00 0.700 217,817.73 09/30/2022 0.700 07/01/2026 1,369 Subtotal and Average 249,000.00 217,817.73 0.700 1,369 PACIFIC ENTERPRISE BANK 694231AD3 1621 Certificates of Deposit - Bank Amort 249,000.00 1.150 230,2B0.18 09/30/2022 1.150 03/31/2025 912 Subtotal and Average 249,000.00 230,280.18 1.150 912 PADUCAH BANK AND TRUST 695292FP2 1613 Certificates of Deposit- Bank Amort 249,000.00 1.650 235,713.36 09/30/2022 1.650 11/08/2024 769 Subtotal and Average 249,000.00 235,713.36 1.650 769 PEOPLES BANK/SARDIS TN 710673AC8 1624 POPPY BANK 73319FAD1 1611 REVERE BANK 761400BY1 1599 STATE BANK OF INDIA 856285C41 1650 Sallie Mae Bank/Murray 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 249,000 00 1.000 249,000.00 249,000.00 1.650 249,000=00 247,000.00 2.300 247,000.00 248,000.00 1.400 248,000.00 233,25822 09/30/2022 1.000 09/30/2024 730 233,258.22 1.000 730 235,783.08 09/30/2022 1.650 11/04/2024 765 235,783.08 1.650 765 238,918.16 09/30/2022 2.300 06/28/2024 636 238,918.16 2.300 636 219,408.08 09/30/2022 1.400 01/13/2027 1,565 219,408.08 1.400 1,565 Portfolio ENCI Data Updated: SET _QTR: 10/31/2022 15:24 AC Run Date: 10/31/2022 - 15:24 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 Market Value Date 365 Collateral 795450S89 1570 Certificates of Deposit - Bank Amort 245,000.00 3.300 243,865.65 09/30/2022 3.300 06/27/2023 269 Subtotal and Average 245,000.00 243,865.65 3.300 269 TOYOTA FINANCIAL SVGS BK 89235MMP3 1649 Certificates of Deposit - Bank Amort 248,000.00 1.350 218,929.44 09/30/2022 1.350 01/13/2027 1,565 Subtotal and Average 248,000.00 218,929.44 1.350 1,565 TRIAD BANK FRONTENAC MO 89579NCB7 1612 Union Bank Checking Acct. SYS1010 1010 US BANK SYS1004 1004 UBS BANK USA 90348JN48 1632 GREENSTATE CREDIT UNION 39573LCE6 1648 FIRST US BANK 33744AAW9 1630 U.S. Treasury Notes 912828592 1592 9128282D1 1604 912828Y87 1634 91282CBT7 1635 91282CAP6 1636 Certificates of Deposit - Bank Amort Subtotal and Average Passbook/Checking Accounts Amort Subtotal and Average Money Market Funds 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 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 249,000.00 1.800 236,465.34 09/30/2022 1.800 11/08/2024 769 249,000.00 236,465.34 1.800 769 6,713,510.03 6,713,510.03 O8/31/2022 1 6,713,510.03 6,713,510.03 1 13.214,285.39 1.370 13,214,285.39 09/30/2022 1.370 1 13,214,285.39 13,214,285.39 1.370 1 249.000.00 0.750 218.183.76 09/30/2022 0.750 06/23/2026 1.361 249,000.00 218,183.76 0.750 1,361 248,000.00 1.350 218,708.72 09/30/2022 1.350 01/14/2027 1,566 248,000.00 218,708.72 1.350 1,566 249,000.00 0.400 220.238.01 09/30/2022 0.400 11/18/2025 1,144 249,000.00 220,238.01 0.400 1,144 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 2,927,100.00 09/30/2022 2.181 07/31/2023 303 1,947.820.00 09/30/2022 1.729 08/31/2023 334 5.734,440.00 09/30/2022 0.394 07/31/2024 669 1.775,860.00 09/30/2022 0.736 03/31/2026 1,277 1,915,780.00 09/30/2022 0.249 10/15/2023 379 Portfolio ENCI Data Updated: SET _QTR: 10/31/2022 15:24 AC Run Date: 10/31/2022 - 15:24 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 Days To Call CUSIP Investment# Security Type Class Remaining Cost Rate Market Value Data 365 Date Maturity Dato Collateral 91282CBM2 1638 U.S. Treasury Coupon Securities Amort 1,990,859.38 0.125 1,889,140.00 09/30/2022 0.301 02/15/2024 502 91282CBQ3 1639 U.S. Treasury Coupon Securities Amort 1,979,921.88 0.500 1,764,760.00 09/30/2022 0.720 02/28/2026 1,246 91282CAB7 1640 U.S. Treasury Coupon Securities Amort 5,910,000.00 0.250 5,362,980.00 09/30/2022 0.624 07/31/2025 1,034 912828ZC7 1641 U.S. Treasury Coupon Securities Amort 2,042,812.50 1.125 1,857,340.00 09/30/2022 0.531 02/28/2025 881 912828YH7 1642 U.S. Treasury Coupon Securities Amort 2.068,437.50 1.500 1,896,020.00 09/30/2022 0.432 09/30/2024 730 91282CAJO 1643 U.S. Treasury Coupon Securities Amort 1,968,437.50 0.250 1,781,640.00 09/30/2022 0.636 08/31/2025 1,065 91282CAM3 1644 U.S. Treasury Coupon Securities Amort 1,966,875.00 0.250 1,777,500.00 09/30/2022 0.648 09/30/2025 1,095 912828ZW3 1645 U.S. Treasury Coupon Securities Amort 1,972,500.00 0.250 1,795,080.00 09/30/2022 0,600 06/30/2025 1,003 912828YE4 1646 U.S. Treasury Coupon Securities Amort 2,051,875.00 1.250 1,890,320.00 09/30/2022 0.419 08/31/2024 700 912828YM6 1647 U.S. Treasury Coupon Securities Amort 1,034,375.00 1.500 945,630.00 09/30/2022 0.453 10/31/2024 761 912828ZFO 1652 U.S. Treasury Coupon Securities Amort 964,218.75 0.500 912,310.00 09/30/2022 1.705 03/31/2025 912 91282CDH1 1653 U.S. Treasury Coupon Securities Amort 975,468.75 0.750 929.220.00 09/30/2022 1.688 11/15/2024 776 91282CCJB 1654 U.S. Treasury Coupon Securities Amort 963,281.25 0.875 885,310.00 09/30/2022 1.763 06/30/2026 1,368 91282CBR1 1655 U.S. Treasury Coupon Securities Amort 973,750.00 0.250 943,010.00 09/30/2022 1.578 03/15/2024 531 91282CCG4 1656 U.S. Treasury Coupon Securities Amort 1,938,906.25 0.250 1.868,040.00 09/30/2022 1.627 06/15/2024 623 91282CATB 1657 U.S. Treasury Coupon Securities Amort 946,953.13 0.250 885,590.00 09/30/2022 1.759 10/31/2025 1,126 91282CCP4 1659 U.S. Treasury Coupon Securities Amort 3.804,375.00 0.625 3,498,280.00 09/30/2022 1.787 07/31/2026 1,399 Subtotal and Average 48,652,421.89 45,183,170.00 0.932 852 Total and Average 116,153,917.29 111,473,498.82 1.188 493 Portfolio ENCI Data Updated: SET _QTR: 10/31/2022 15:24 AC Run Date: 10/31/2022 - 15:24 No fiscal year history available DI (PRF_DI) 7.1.1 Report Ver. 7.3.6.1