Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Quarterly Investment Report for the 6 months ended 12-31-22
CITY OF ENCINITAS INVESTMENT REPORT MEMORANDUM Six Months ended December 31, 2022 TO: City Council VIA: Pamela Antil, City Manager FROM: Teresa S. McBroome, Director of Finance/City Treasurer DATE: February 22, 2023 SUBJECT: City of Encinitas Investment Report for the six (6) months ended December 31, 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 $129.7 million at December 31, 2022, compared to an average investable balance of $111.8 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 �155,000,000 - - $145,OOQ000 -- F- e235,0W,0W s' FY 22-23 125,O0%030 FY 21-22 $115,000,000 — FY 20-21 $105,000,000 FY 19-20 FY 18-19 $95,C00,000 $85,000,ODO 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 $53.1 million at December 31, 2022. FY 2022-23 I June 30, 2023 March 31, 2023 Dec. 31, 2022 Sep. 30, 2022 Book Value $ 129,743,266 $ 116,194,740 Market Value $ 125,375,418 $ 111,473,499 Unrealized Gain/(Loss) $ (4,367,848) $ (4,721,241) Unrealized Gain/Loss as % of Book Value -3.37% -4.06% Effective Rate of Return 1.57% 1.42% Average Yield To Maturity 2.09% 1.53% Average Maturity (Years) 1.21 1.44 Investment Earnings Year to Date $ 882,449 $ 412,347 The Pool earned $882,449 the first six months of FY 2022-23 for an annualized return of 1.57 percent. The average yield for the City over the twelve months ended December 31, 2022, is 1.56 percent. This compares to the City's adopted performance benchmark of the one (1) year constant maturity Treasury index which averaged a 3.14 percent yield over the twelve months ended December 31, 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% 1.00% 0.00% eC a�' ;c e9' 1C a�' zlc eQ. ec ac �p eQ e,_ a� �p eQ eC at' oc eQ ec o Is > S o�> S o �r > 5 0�> 5 0�> S o City Portfolio-YTD Rate — — — 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,367,848 as of December 31, 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 December 31, 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 11,888,290.15 11,888,290.15 11,888,290.15 10.04 2 290 1 1 Managed Pool Accounts 2,321,947.66 2,321,947.66 2,321,947.66 1.96 3.592 1 1 Money Market Funds 27,524,895.68 27,524,895.68 27,524,895.68 2325 4.110 1 1 Certificates of Deposit - Bank 13,389,000.00 12,768,329.09 13,389,000.00 11.31 2.074 1,694 681 Negotiable CDs 498,000.00 479,947.50 498,000.00 0.42 1.727 1,643 483 U.S. Treasury Coupon Securities 49,000,000.00 45,466,680.00 48,753,297.52 41.19 0.931 1,329 759 Federal Agency Coupon Securities 14,000,000.00 13,547,870.00 13,990,377.08 11.82 1.744 1,532 402 Investments Cash Passbook/Checking (not included in yield calculations) Total Cash and Investments 118,622,133.49 11,377,458 20 129,999,591.69 Total Earnings December 31 Period Ending Current Year 882,449.11 Average Daily Balance 111,758,946.64 Effective Rate of Return 1.57% 113, 997, 9 60.08 118, 365, 808.0 9 100.00% 11, 377, 458.20 11,377,458.20 125,375,418.28 129,743, 266.29 2.088 927 440 0.000 2.088 927 440 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 exp r ouirements. source oft market values of investments s owned i US Bank Custody Services. � 2�3 Teresa*Broome, Finance Director\Treasurer Reporting period 07101/2022-12/31/2022 Data Updated: SET_QTR: 02/15/2023 12:47 Run Dale: 02/15/2023 - 12:47 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 December 31, 2022 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 11,888,290.15 11,888,290,15 11,888,290.15 2.290 2.290 NR Subtotal and Average 15,428,796.92 11,888,290.15 11,888,290.15 11,888,290.15 2.290 Managed Pool Accounts SYS1003 1003 CA Asset Management Program SYS1584 1584 SD County Investment Pool Subtotal and Average 2,311,200.51 Money Market Funds SYS1004 1004 US BANK Subtotal and Average 12,261,021.50 Certificates of Deposit - Bank 58404DBL4 1561 05580AM B7 1562 17312QH69 1563 29278TAU4 1568 45581EASO 1564 501798LT7 1566 61747MR37 1565 33646CJPO 1569 249398BT4 1596 02589AAM4 1580 795450S89 1570 20033AZK5 1571 020080BUO 1619 33640VDE5 1609 59013KAR7 1597 06251AW48 1585 34969RCS5 1616 654062JRO 1625 219255AK2 1623 397129AJ6 1663 61760AG52 1593 27002YEQ5 1594 200056QRZB 1595 336460C Q 1 1598 761400BY1 1599 1,085,822.95 1,085,822.95 1,236,124.71 1,236,124.71 2,321,947.66 2,321,947.66 27,524,895.68 27,524,895.68 27,524,895.68 27,524,895.68 1,085.822.95 4.300 4.300 AAA 1,236,124.71 2.970 2.970 AAA 2,321,947.66 3.592 27,524,895.68 4.110 4.110 AAA 27,524,895.68 4.110 Medallion Bank UT 03/28/2018 249,000.00 248,267.94 249,000.00 2.900 2.900 03/28/2023 BMW Bank North America 03/29/2018 246,000.00 245,259.54 246,000.00 2.900 2.900 03/29/2023 Citi Bank NA 03/29/2018 246,000.00 245,230.02 246,000.00 2.850 2.850 03/2912023 Enerbank USA 03/29/2018 246,000.00 245,230.02 246,000.00 2.850 2.850 03/29/2023 Industrial & Comm Bank China 03/29/2018 249,000.00 248,257.98 249,000.00 2.900 2.900 03/29/2023 LCA Bank Corp 03/2912018 246,000.00 245,200.50 246,000.00 2.800 2.800 03129/2023 Morgan Stanley Bank 03129/2018 246,000.00 245,259.54 246,000.00 2.900 2900 03/29/2023 First Source Bank 04/11/2018 246,000.00 245,104.56 246,000.00 2.850 2.850 04/1112023 Denver Savings Bank 06/21/2019 249,000.00 246,641.97 249,000.00 2.250 2.250 06/21/2023 American Express National Bank 06/26/2018 245,000.00 243,850.95 245,000.00 3.300 3.300 NR NR 06/26/2023 Sallie Mae Bank/Murray 06/27/2018 245,000.00 243,843.60 245,000.00 3.300 3.300 NR NR 06/27/2023 Comenity Capital Bank 06/29/2018 245,000.00 243,821.55 245,000.00 3.300 3,300 NR NR 06/29/2023 ALMA BANK 03/30/2020 249,000.00 242,306.88 249,000.00 0.900 0.900 09/29/2023 FIRST SERVICE BANK 11/15/2019 249,000.00 242,809.86 249,000.00 1.700 1.700 11/15/2023 Merrick Bank 06/28/2019 249,000.00 243,589.23 249,000.00 2.400 2.400 12/28/2023 BANK HAPOALIM BM NY 03/25/2019 246,000.00 240,939.78 246,000.00 2.900 2.900 03/25/2024 FORTUNE BANK ARNOLD 03/27/2020 249,000.00 238,098.78 249,000.00 1.000 1.000 03/27/2024 NICOLET NATIONAL BANK 03/31/2020 249,000.00 238,546.98 249,000.00 1.150 1.150 03/2812024 CORNHUSKER BANK 03/30/2020 249,000.00 238,375.17 249,000.00 1.100 1.100 03/29/2024 GREENWOOD CREDIT UNION 11/28/2022 248,000.00 249,113.52 248,000.00 4.950 4.950 05/28/2024 MORGAN STANLEY PRIVATE BANK 06/13/2019 246,000.00 239,067.72 246,000.00 2.600 2.600 06/13/2024 EAGLEBANK 06/20/2019 249,000.00 240,783.00 249,000.00 2.300 2.300 06/20/2024 COMMERCE BANK GENEVA MN 06/26/2019 249,000.00 240,693.36 249,000.00 2.300 2.300 06/26/2024 First State Bank Dequeen 06/28/2019 249,000.00 240,665.97 249,000.00 2.300 2.300 06/28/2024 REVERE BANK 06/28/2019 247,000.00 238,792.19 247,000.00 2.300 2.300 06/28/2024 Data Updated: SET _QTR: 02/15/2023 12:47 Run Date: 02115/2023 - 12:47 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 December 31, 2022 Page 2 Average Purchase Stated YTM Maturity CUSIP Investment # Issuer Balance Date Par Value Market Value Book Value Rate S&P Moodv's Date Certificates of Deposit - Bank 33847E4E4 1626 FLAGSTAR BANK FSB 09/30/2020 249,000.00 231,570.00 249,000.00 0.400 0.400 09/30/2024 52465JHT7 1618 LEGENDS BANK 03/30/2020 249,000.00 233,895.66 249,000.00 1.000 1.000 09/30/2024 710673AC8 1624 PEOPLES BANK/SARDIS TN 03/31/2020 249,000.00 233,895.66 249,000.00 1.000 1.000 09/30/2024 73319FAD1 1611 POPPY BANK 11/04/2019 249,000.00 235,992.24 249,000.00 1.650 1.650 11/04/2024 203522AT4 1610 COMMUNITY BANK 11/08/2019 249,000.00 235,917.54 249.000.00 1.650 1.650 11/08/2024 29367SJ08 1607 ENTERPRISE BANK AND TRUST 11/08/2019 249,000.00 236,582.37 249,000.00 1.800 1.800 11/08/2024 695292FP2 1613 PADUCAH BANK AND TRUST 11/08/2019 249,000.00 235,917.54 249,000.00 1,650 1.650 11/08/2024 89579NCB7 1612 TRIAD BANK FRONTENAC MO 11/08/2019 249,000.00 236,582.37 249,000.00 1.800 1.800 11/08/2024 01025RAD1 1661 ALABAMA CREDIT UNION 11/22/2022 248,000.00 249,331.76 248,000.00 4.900 4.900 11/22/2024 300185JF3 1615 EVERGREEN BANK GROUP 03/26/2020 249,000.00 229,971.42 249.000.00 1.000 1.000 03/26/2025 59565QCS2 1617 MIDCOUNTRY BANK 03/27/2020 249,000.00 229,949.01 249.000.00 1.000 1.000 03/27/2025 15201QCJ4 1620 CENTERSTATE BANK NA 03/30/2020 248,000.00 229,127.20 248,000.00 1.000 1.000 03/31/2025 538036KU7 1622 LIVE OAK BANKING COMPANY 03/31/2020 249,000.00 230,394.72 249,000,00 1.100 1.100 03/31/2025 694231AD3 1621 PACIFIC ENTERPRISE BANK 03/30/2020 249,000.00 230,681.07 249,000.00 1.150 1.150 03/31/2025 549104SS7 1627 LUANA SAVINGS BANK 10/02/2020 249,000.00 222,307.20 249,000.00 0.400 0.400 10/02/2025 33625CDV8 1629 1ST SECURITY BK OF WASH 11/13/2020 249,000.00 221,746.95 249.000.00 0.400 0.400 10/15/2025 51507LBZ6 1628 LANDMARK COMMUNITY BANK 10/29/2020 249,000.00 221,398.35 249.000.00 0.400 0.400 10/29/2025 02007GD26 1662 Ally Bank 11/17/2022 244,000.00 245,434.72 244,000.00 4.800 4.800 11/17/2025 33744AAW9 1630 FIRST US BANK 11/18/2020 249,000.00 220,925.25 249,000.00 0.400 0.400 11/18/2025 50116CCP2 1631 KS STATEBANK 11/30/2020 249,000.00 220,989.99 249,000.00 0.450 0.450 11/28/2025 90348JN48 1632 UBS BANK USA 06/23/2021 249,000.00 218,343.12 249,000.00 0.750 0.750 06/23/2026 649447UZO 1633 NEW YORK COMMUNITY BANK 06/30/2021 249,000.00 218,009.46 249,000.00 0.700 0.700 07/01/2026 07181JAU8 1660 BAXTER CREDIT UNION 11/22/2022 248,000.00 251,662.96 248,000.00 5.000 5.000 11/23/2026 052392CC9 1665 AUSTIN TELCO FCU 11/28/2022 248,000 00 252,114.32 248,000.00 5.050 5 050 11/27/2026 8562B5C41 1650 STATE BANK OF INDIA 01/13/2022 248,000.00 219,155.12 248,000.00 1.400 1.400 NR NR 01/13/2027 89235MMP3 1649 TOYOTA FINANCIAL SVGS BK 01/13/2022 248,000.00 218,701.28 248,000.00 1.350 1.350 01/13/2027 39573LCE6 1648 GREENSTATE CREDIT UNION 01/14/2022 248,000.00 218,430.96 248,000.00 1.350 1.350 01/14/2027 64034KAJO 1651 NELNET BANK INC 02/02/2022 248.000.00 219,244.40 248,000.00 1.450 1.450 02/02/2027 87165FT53 1664 Synchrony Bank 11/18/2022 244,000.00 240,305.84 244,000.00 4.250 4.250 11/18/2027 Subtotal and Average 12,293,010.87 13,389,000.00 12,768,329.09 13,389,000.00 2.074 Negotiable CDs 15118RSN8 1614 CELTIC BANK 10/30/2019 249,000.00 242,921.91 249,000,00 1.600 1.601 10/30/2023 33767GAMO 1608 First Bank Puerto Rico 10/28/2019 249,000.00 237,025.59 249.000.00 1.850 1.852 NR NR 10/25/2024 Subtotal and Average 498,000.00 498,000.00 479,947.50 498,000.00 1.727 Portfolio ENCI Data Updated: SET_QTR: 02/15/2023 12:47 AC Run Date: 02/15/2023 - 12:47 PM (PRF_PM2) 7.3.0 City of Encinitas - Qtr Inv Report Portfolio Management Portfolio Details - Investments December 31, 2022 Page 3 Average Purchase Stated YTM Maturity CUSIP Investment # Issuer Balance Date Par Value Market Value Book Value Rate S&P MoodSCs Date U.S. Treasury Coupon Securities 912828S92 1592 U.S. Treasury Notes 03/27/2019 3,000,000.00 2,940,930.00 2,984,668.60 1.250 2.181 07/31/2023 9128282D1 1604 U.S. Treasury Notes 06/26/2019 2,000,000.00 1,955,240.00 1,995,493.21 1.375 1.729 08/31/2023 91282CAP6 1636 U.S. Treasury Notes 07/08/2021 2,000,000.00 1,929,460.00 1,998,052.62 0,125 0,249 AAA Aaa 10/15/2023 91282CBM2 1638 U.S. Treasury Notes 07/08/2021 2,000,000.00 1.900,240.00 1,996,063.39 0.125 0.301 02/15/2024 91282CBR1 1655 U.S. Treasury Notes 03/09/2022 1,000,000.00 948,010.00 984,363.98 0.250 1.578 03/15/2024 91282CCG4 1656 U.S. Treasury Notes 03/09/2022 2,000.000.00 1,877,040.00 1,960,867.57 0.250 1.627 06/15/2024 912828Y87 1634 U.S. Treasury Notes 07/08/2021 6,000,000.00 5,739,120,00 6,127,620.64 1.750 0.394 07/31/2024 912828YE4 1646 U.S. Treasury Notes 07/08/2021 2,000,000.00 1,893,360.00 2,027,426.09 1-250 0.419 08/31/2024 912828YH7 1642 U.S. Treasury Notes 07/08/2021 2,000,000.00 1,899,140.00 2,037,002.65 1.500 0.432 09/30/2024 912828YM6 1647 U.S. Treasury Notes 07/08/2021 1,000,000.00 947,460.00 1,018,989.99 1.500 0.453 10/31/2024 91282CDH1 1653 U.S. Treasury Notes 03/09/2022 1,000,000-00 933,360.00 982,913.06 0.750 1.688 11/15/2024 912828ZC7 1641 U.S. Treasury Notes 07/08/2021 2,000,000.00 1,866,960.00 2,025,378.71 1,125 0.531 02/28/2025 912828ZFO 1652 U.S. Treasury Notes 03/09/2022 1,000,000.00 918,440.00 973,756.15 0.500 1.705 03/31/2025 912828ZW3 1645 U.S. Treasury Notes 07/08/2021 2,000,000.00 1,811,800.00 1,982,758.09 0.250 0.600 06/30/2025 91282CAB7 1640 U.S. Treasury Notes 07/08/2021 6,000,000.00 5,414,280.00 5,942,870.62 0.250 0.624 07/31/2025 91282CAJO 1643 U.S. Treasury Notes 07/08/2021 2,000.000,00 1,798,440.00 1,979,729.17 0.250 0.636 08/31/2025 91282CAM3 1644 U.S. Treasury Notes 07/08/2021 2,000,000.00 1,795,780.00 1,978,495.55 0.250 0.648 09/30/2025 91282CAT8 1657 U.S. Treasury Notes 03/09/2022 1,000,000.00 894,180.00 958,820.97 0.250 1.759 10/31/2025 91282CBQ3 1639 U.S. Treasury Notes 07/08/2021 2,000,000.00 1,782,120.00 1,986.338.35 0.500 0.720 02/28/2026 91282CBT7 1635 U.S. Treasury Notes 07/08/2021 2,000,000.00 1,792,580.00 2,000,857.70 0.750 0.736 AAA Aaa 03/31/2026 91282CCJB 1654 U.S. Treasury Notes 03/09/2022 1,000,000.00 894,220.00 970,233.08 0.875 1.763 06/30/2026 91282CCP4 1659 U.S. Treasury Notes 03/10/2022 4,000,000.00 3,534,520.00 3,840,597.33 0.625 1.787 07/31/2026 Subtotal and Average 51,037,572.84 49,000,000.00 45,466,680.00 48,753,297.52 0.931 Federal Agency Coupon Securities 3133EJBP3 1590 Federal Farm Credit 03/27/2019 2,000,000.00 1,996,600.00 2,000,475.63 2.500 2.210 AAA Aaa 02/02/2023 3133EKSN7 1605 Federal Farm Credit 06/26/2019 4,000,000.00 3,946,680.00 3,999,439.51 1,770 1.800 AAA Aaa 06/26/2023 3133EHST1 1591 FEDERAL FARM CREDIT BANK 03/27/2019 1,000,000.00 985.220.00 998.788.94 2.010 2.234 07/26/2023 3135GOU43 1602 Federal Nat'l Mortgage Assoc. 06/26/2019 2,000,000.00 1,974,300.00 2,014,354.68 2.875 1.801 09/12/2023 3133EHN25 1606 FEDERAL FARM CREDIT BANK 06/26/2019 2,000,000.00 1,958,840.00 2,006,295.21 2.200 1.805 11/01/2023 3135GO6G3 1658 Federal Nat'l Mortgage Assoc. 03/09/2022 1,000,000.00 899,250.00 963,957.66 0.500 1.813 11/07/2025 3130AN4T4 1637 Federal Home Loan Bank 07/08/2021 2,000,000.00 1,786,980.00 2,007,065.45 0.875 0.770 06/12/2026 Subtotal and Average 17,661,699.29 14,000,000.00 13.547,870.00 13,990,377.08 1.744 Portfolio ENCI Data Updated: SET _QTR: 02/15/2023 12:47 AC Run Dale: 02/15/2023 - 12:47 PM (PRF _PM2) 7.3.0 City of Encinitas - Qtr Inv Report Portfolio Management Portfolio Details - Investments December 31, 2022 Average Purchase Stated YTM CUSIP Investment # Issuer Balance Date Par Value Market Value Book Value Rate S&P Moody's Total and Average 111,758,946.64 118,622,133.49 113,997,960.08 118,365,808.09 2.088 Data Updated: SET_QTR: 02/15/2023 12:47 Run Date: 02/15/2023 - 12:47 Page 4 Portfolio ENCI AC PM (PRF_PM2) 7.3.0 City of Encinitas - Qtr Inv Report Portfolio Management Portfolio Details - Cash December 31, 2022 Average Purchase Stated YTM CUSIP Investment # Issuer Balance Date Par Value Market Value Book Value _ r _ Rate S&P Moody's Passbook/Checking Accounts SYS1010 1010 Union Bank Checking Acct. 11,377,458.20 11,377,458.20 11,377.45820 0.000 Average Balance 0.00 Total Cash and Investments 111,758,946.64 129,999,591.69 125,375,418.28 129,743,266.29 2.088 Page 5 Portfolio ENCI Data Updated: SET _QTR: 02/15/2023 12:47 AC Run Date: 02/15/2023 - 12:47 PM (PRF_PM2) 7.3 0 City of Encinitas - Qtr Inv Report Portfolio Management Page 1 Activity By Type July 1, 2022 through December 31, 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 49,246,626.37 43,446,327.01 Subtotal 49,246,626.37 43,446,327.01 0.00 Local Agency Investment Funds (Monthly Summary) SYS1012 1012 CA LAIF 0.990 121,832.94 22,500,000.00 Subtotal 121,832.94 22,500,000.00 11,888,290.15 Managed Pool Accounts (Monthly Summary) SYS1003 1003 CA Asset Management Program SYS1584 1584 SD County Investment Pool Subtotal Money Market Funds (Monthly Summary) SYS1004 1004 US BANK Subtotal Certificates of Deposit - Bank 01025RAD1 1661 02007GD26 1662 052392CC9 1665 07181 JAU 8 1660 14042RGN5 1552 1404203Q1 1553 397129AJ6 1663 87165FT53 1664 87270LAD5 1554 Negotiable CDs ALABAMA CREDIT UNION Ally Bank AUSTIN TELCO FCU BAXTER CREDIT UNION Capital One NA Capital One Bank USA, NA GREENWOOD CREDIT UNION Synchrony Bank TIAA FSB Subtotal 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 1.140 1.130 1.370 4.900 11/22/2022 4.800 11/17/2022 5.050 11 /28/2022 5.000 11 /22/2022 2.300 07/19/2022 2.300 07/19/2022 4.950 11 /28/2022 4.250 11 / 18/2022 2.150 07/19/2022 13,261.24 7,497.40 20,758.64 29,925,937.43 29,925,937.43 248,000.00 244,000.00 248,000.00 248,000.00 0.00 0.00 248,000.00 244,000.00 0.00 0.00 0.00 0.00 6,482,946.00 6,482,946.00 0.00 0.00 0.00 0.00 245,000.00 245,000.00 0.00 0.00 245,000.00 2,321,947.66 27,524,895.68 1,480,000.00 735,000.00 13,389,000.00 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 0.00 8,000,000.00 498,000.00 48,753,297.52 Portfolio ENCI Data Updated: SET _QTR: 02/15/2023 12:47 AC Run Date: 02/15/2023 -12:47 PM (PRF_PM3) 7.3.0 Report Ver. 7.3-6.1 City of Encinitas - Qtr Inv Report Portfolio Management Activity By Type July 1, 2022 through December 31, 2022 Page 2 Stated Transaction Purchases Redemptions CUSIP Investment# Issuer Rate Date or Deposits or Withdrawals Balance Federal Agency Coupon Securities 3133EC4Q4 1558 Federal Farm Credit 1.820 11/23/2022 0.00 2,000,000.00 3133EDWW8 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 Subtotal Total 0.00 6,000,000.00 13,990,377.08 80,795,155.38 87,164,273.01 118,365,808.09 Portfolio ENCI Data Updated: SET_QTR: 02/15/2023 12:47 AC Run Date: 02/15/2023 - 12,47 PM (PRF_PM3) 7.3.0 City of Encinitas - Qtr Inv Report Portfolio Management Page 1 Interest Earnings Summary December 31, 2022 December 31Month Ending Fiscal Year To Date CD/Coupon/Discount Investments: Interest Collected 570,430.62 570,430.62 Plus Accrued Interest at End of Period 220,032.23 220,032.23 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 498,627.88 498,627.88 Adjusted by Premiums and Discounts 41,631.68 41,631.68 Adjusted by Capital Gains or Losses 0.00 0.00 Earnings during Periods 540,259.56 540,259.56 Pass Through Securities: Interest Collected 0.00 0.00 Plus Accrued Interest at End of Period 0.00 0.00 Less Accrued Interest at Beginning of Period ( 0.00) ( 0.00) Less Accrued Interest at Purchase During Period ( 0.00) ( 0.00) Interest Earned during Period 0.00 0.00 Adjusted by Premiums and Discounts 000 0.00 Adjusted by Capital Gains or Losses 0.00 0.00 Earnings during Periods 0.00 0.00 Cash/Checking Accounts: Interest Collected 261,902.39 261,902.39 Plus Accrued Interest at End of Period 144,229.14 144,229.14 Less Accrued Interest at Beginning of Period ( 63,941.98) ( 63,941.98) Interest Earned during Period 342,189.55 342,189.55 Total Interest Earned during Period 840,817.43 840,817.43 Total Adjustments from Premiums and Discounts 41,631.68 41,631.68 Total Capital Gains or Losses 0.00 0.00 Total Earnings during Period 882,449.11 882,449.11 Portfolio ENCI Data Updated: SET_QTR: 02/15/2023 12:47 AC Run Date. 02/15/2023 - 12.47 No fiscal year history available PM (PRF_PM6) 7.3.0 Report Ver. 7.3.6 1 CITY OF ENCINITAS - "— a+ City of Encinitas - Qtr Inv Report 505 S. VULCAN Investments by Type Encinitas, CA 92024 (760)633-2641 y Active Investments December 31, 2022 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. 11,377,458.20 100.0000000 11,377,458.20 Subtotal 11,377,458.20 11,377,458.20 Local Agency Investment Funds SYS1012 1012 001 CA LAIF 11,888,290.15 100.0000000 11,888,290.15 0.990 Subtotal 11,888,290.15 11,888,290.15 Managed Pool Accounts SYS1003 1003 001 CA Asset Management Program 1,085,822.95 100.0000000 1,085,822.95 1.140 SYS1584 1584 001 SD County Investment Pool 1,236,124.71 100.0000000 1,236,124.71 1.130 Subtotal 2,321, 947.66 2,321,947.66 Money Market Funds SYS1004 1004 001 US BANK 27,524,895.68 100.0000000 27,524,895.68 1.370 Subtotal 27, 524,895.68 27,524,895.68 Certificates of Deposit - Bank 01025RAD1 1661 001 ALABAMA CREDIT UNION 248,000.00 100.0000000 248,000.00 4.900 11/22/2024 02007GD26 1662 001 Ally Bank 244,000.00 100.0000000 244,000.00 4.800 11/17/2025 020080BUO 1619 001 ALMA BANK 249,000.00 100.0000000 249,000-00 0.900 09/29/2023 02589AAM4 1580 001 American Express National Bank 245,000.00 100.0000000 245.000.00 3.300 06/26/2023 052392CC9 1665 001 AUSTIN TELCO FCU 248,000.00 100.0000000 248,000.00 5.050 11/27/2026 07181JAU8 1660 001 BAXTER CREDIT UNION 248,000.00 100.0000000 248,000.00 5.000 11/23/2026 06251AW48 1585 001 BANK HAPOALIM BM NY 246,000.00 100.0000000 246,000.00 2.900 03/25/2024 05580AMB7 1562 001 BMW Bank North America 246,000.00 100.0000000 246,000.00 2.900 03/29/2023 17312QH69 1563 001 Citi Bank NA 246,000.00 100.0000000 246,000= 2,850 03/29/2023 200056QRZ8 1595 001 COMMERCE BANK GENEVA MN 249,000.00 100.0000000 249,000-00 2.300 06/26/2024 203522AT4 1610 001 COMMUNITY BANK 249,000.00 100.0000000 249,000,00 1,650 11/08/2024 20033AZK5 1571 001 Comenity Capital Bank 245,000.00 100.0000000 245.000.00 3.300 06/29/2023 219255AK2 1623 001 CORNHUSKER BANK 249,000.00 100.0000000 249,000-00 1.100 03/29/2024 15201QCJ4 1620 001 CENTERSTATE BANK NA 248,000.00 100.0000000 248,000.00 1.000 03/31/2025 249398BT4 1596 001 Denver Savings Bank 249.000.00 100.0000000 249,000.00 2.250 06/21/2023 27002YEQ5 1594 001 EAGLEBANK 249,000.00 100.0000000 249,000.00 Z300 06/20/2024 Portfolio ENCI Data Updated: SET_QTR: 02/15/2023 12:47 AC Run Date: 02/15/2023 - 12:47 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 2 December 31, 2022 Purchase Current Maturity Call Call CUSIP Investment # Fund Issuer Par Value Price Remaining Cost Rate Date Date Price Certificates of Deposit - Bank 29278TAU4 1568 001 Enerbank USA 246,000.00 100.0000000 246,000 00 2.850 03/29/2023 29367SJQ8 1607 001 ENTERPRISE BANK AND TRUST 249,000.00 100.0000000 249,000.00 1.800 11/08/2024 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 33625CDVB 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 397129AJ6 1663 001 GREENWOOD CREDIT UNION 248,000.00 100.0000000 248,000.00 4.950 05/28/2024 45581EASO 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 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 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 13,389,000.00 13,389,000.00 Portfolio ENCI Data Updated: SET _QTR: 02/15/2023 12:47 AC Run Date: 02/15/2023 - 12:47 No fiscal year history avaflable DT (PRF_DT) 7.1.1 Report Ver, 7.3.6.1 City of Encinitas - Qtr Inv Report Investments by Type December 31, 2022 Page 3 Purchase Current Maturity Call Call CUSIP Investment # Fund Issuer Par Value Price Remaining Cost Rate Date Date Price Negotiable CDs 15118RSN8 1614 001 CELTIC BANK 33767GAMO 1608 001 First Bank Puerto Rico U.S. Treasury Coupon Securities 912828S92 1592 9128282D1 1604 912828Y87 1634 91282CBT7 1635 91282CAP6 1636 91282CBM2 1638 91282CBQ3 1639 91282CAB7 1640 912828ZC7 1641 912828YH7 1642 91282CAJO 1643 91282CAM3 1644 912828ZW3 1645 912828YE4 1646 912828YM6 1647 912828ZFO 1652 91282CDH1 1653 91282CCJ8 1654 91282CBR1 1655 91282CCG4 1656 91282CAT8 1657 91282CCP4 1659 Federal Agency Coupon Securities 3133EHST1 1591 3133EHN25 1606 3133EJBP3 1590 3133EKSN7 1605 3130AN4T4 1637 3135GOU43 1602 3135GO6G3 1658 001 001 001 001 001 001 001 001 001 001 001 001 001 001 001 001 001 001 001 001 001 001 U.S. Treasury Notes U.S. Treasury Notes U.S. Treasury Notes U.S. Treasury Notes U.S. Treasury Notes U.S. Treasury Notes U.S. Treasury Notes U.S. Treasury Notes U.S. Treasury Notes U.S. Treasury Notes U.S. Treasury Notes U.S. Treasury Notes U.S. Treasury Notes U.S. Treasury Notes U.S. Treasury Notes U.S. Treasury Notes U.S. Treasury Notes U.S. Treasury Notes U.S. Treasury Notes U.S. Treasury Notes U.S. Treasury Notes U.S. Treasury Notes Subtotal Subtotal 249,000.00 100.0000000 249,000.00 1.600 10/30/2023 249.000.00 100.0000000 249.000.00 1.850 10/25/2024 498,000.00 3,000,000.00 2,000,000.00 6,000,000.00 2, 000, 000.00 2,000,000.00 2,000,000.00 2,000,000.00 6,000,000.00 2,000,000.00 2,000,000.00 2,000,000.00 2,000,000.00 2, 000, 000.00 2,000,000.00 1, 000, 000.00 1, 000, 000.00 1, 000, 000.00 1, 000, 000.00 1, 000, 000.00 2,000,000.00 1,000,000.00 4,000,000.00 49,000,000.00 96.1562500 98.5781250 104,1250000 100.0625000 99.7187500 99,5429690 98.9960940 98.5000000 102.1406250 103.4218750 98.4218750 98.3437500 98.6250000 102.5937500 103.4375000 96.4218750 97.5468750 96.3281250 97.3750000 96.9453125 94.6953130 95.1093750 4UG,000.UU 2,884,687.50 1,971,562.50 6, 247, 500.00 2, 001, 250.00 1, 994, 375.00 1, 990, 859.38 1, 979, 921.88 5,910,000.00 2,042,812 50 2,068,437 50 1,968,437.50 1, 966, 875.00 1, 972, 500.00 2,051,875.00 1,034,375.00 964, 218.75 975,468.75 963,281.25 973,750.00 1, 938, 906.25 946,953.13 3, 804, 375.00 48,652,421.89 1.250 1.375 1.750 0.750 0.125 0,125 0.500 0.250 1.125 1.500 0.250 0.250 0.250 1.250 1.500 0.500 0.750 0.875 0.250 0.250 0.250 0.625 07/31/2023 0813112023 07/31/2024 03/31 /2026 10/15/2023 02/15/2024 02/28/2026 07/31/2025 02/28/2025 09/30/2024 08131 /2025 09/30/2025 06/30/2025 08/31 /2024 10/31 /2024 03/31 /2025 11 /15/2024 06/30/2026 03/15/2024 06115/2024 10/31 /2025 07/31 /2026 001 FEDERAL FARM CREDIT BANK 1,000,000.00 99.0790000 990,790.00 2.010 07/26/2023 001 FEDERAL FARM CREDIT BANK 2,000,000.00 101.6420000 2,032,840.00 2.200 11/01/2023 001 Federal Farm Credit 2,000,000.00 101.0625000 2,021,250.00 2.500 02/02/2023 001 Federal Farm Credit 4,000,000.00 99.8847000 3,995,388.00 1.770 06/26/2023 001 Federal Home Loan Bank 2,000,000.00 100.5050000 2,010,100.00 0.875 06/12/2026 001 Federal Nat'l Mortgage Assoc. 2,000,000.00 104.3350000 2,086,700.00 2.875 09/12/2023 001 Federal Nat'l Mortgage Assoc. 1,000,000.00 95,3700000 953,700.00 0,500 11/07/2025 Subtotal 14,000,000.00 14,090,768.00 Portfolio ENCI Data Updated: SET _QTR: 02/15/2023 12:47 AC Run Date: 02/15/2023 - 12:47 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 December 31, 2022 Page 4 Current Maturity Call Call CUSIP Investment # Fund Issuer Par Value Price Remaining Cost Rate Date Date Price Purchase Total 129,999,591.69 129,742,781.68 Portfolio ENCI Data Updated: SET_QTR: 02/15/2023 12:47 AC Run Dale. 02/15/2023 - 12:47 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 Sorted by Fund - Fund (760)633-2641 July 1, 2022 - December 31, 2022 Yield on Beginning Book Value CUSIP Investment # Fund Issuer Ending Par Value Beginning Book Value Ending Book Value Maturity Date Current Rate Annualized Yield Interest Earned Adjusted Interest Earnings Amortization/ Adjusted Interest Accretion Earnings Fund: General Investments SYS1012 1012 001 LAIF 11,888,290.15 34,266,457.21 11,888,290.15 2.290 0.735 126,899.14 0.00 126,899.14 SYS1584 1584 001 COUNTY 1,236,124.71 1,228.627.31 1,236,124.71 2.970 1.924 11,918.04 0.00 11,918.04 SYS1003 1003 001 CAMP 1,085,822.95 1,072,561.71 1,085,822.95 4.300 3.001 16,226.16 0.00 16,226.16 SYS1004 1004 001 UBCUST 27,524,895.68 4,081,904.25 27,524,895.68 4.110 9.095 187,146.21 0.00 187,146.21 SYS1010 1010 001 UBCKG 11,377,458.20 5,577,158.84 11,377,458.20 0.00 0.00 0.00 3130AN4T4 1637 001 FHLB 2,000,000.00 2,008,090.25 2,007,065.45 06/12/2026 0.875 0.763 8,750,.00 -1,024.80 7,725.20 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 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 3135GOU43 1602 001 FNMA 2,000,000.00 2,024,648.88 2,014,354.68 09/12/2023 2.875 1.808 28,750.00 -10,294.20 18,455.80 3135GO6G3 1658 001 FNMA 1,000,000.00 957,634.45 963,957.66 11/07/2025 0.500 1.828 2,500.00 6,323.21 8,823.21 3133EJBP3 1590 001 FFCRED 2,000.000.00 2,003,237.36 2,000,475.63 02/02/2023 2.500 2.202 25,000.00 -2,761-73 22,238.27 3133EKSN7 1605 001 FFCRED 4,000,000.00 3,998,863.01 3,999,439.51 06/26/2023 1,770 1.785 35,400.00 576.50 35,976.50 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 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 91282CATB 1657 001 UST 1,000,000.00 951,493.18 958,820.97 10/31/2025 0.250 1.790 1,256.98 7,327.79 8,584.77 91282CAM3 1644 001 UST 2,000,000.00 1,974,550.57 1,978,495.55 09/30/2025 0.250 O.650 2,520.64 3,944.98 6,465.62 912828ZFO 1652 001 UST 1,000,000.00 967,867.29 973,756.15 03/31/2025 0.500 1.724 2,520.64 5,888.86 8,409.50 91282CCP4 1659 001 UST 4,000,000.00 3,820,780.87 3,840,597.33 07/31/2026 0.625 1.816 12,533.78 22,440.77 34,974.55 912828YM6 1647 001 UST 1,000,000.00 1,024,212.94 1,018,989.99 10/31/2024 1,500 0.449 7,541.89 -5,222.95 2.318.94 91282CCG4 1656 001 UST 2,000,000.00 1,947,307.56 1,960,867,57 06/15/2024 0.250 1.638 2,514.94 13,560.01 16,074.95 91282CAB7 1640 001 UST 6,000,000.00 5,931,711.59 5,942,870.62 07/31/2025 0.250 0.625 7,520.26 11,159.03 18,679.29 91282CBQ3 1639 001 UST 2,000,000.00 1,984,160.07 1,986,338.35 02/28/2026 0.500 0.723 5,055.40 2,178.28 7,233.68 912828YH7 1642 001 UST 2,000,000.00 2,047,67426 2,037,002.65 09/30/2024 1.500 0.431 15,123.86 -10,671.61 4,452.25 912828ZC7 1641 001 UST 2,000,000.00 2,031,297.19 2,025,378.71 02/28/2025 1.125 0.533 11,374.65 -5,918.48 5,456.17 91282CBM2 1638 001 UST 2,000,000.00 1,994,296.71 1,996,063.39 02/15/2024 0.125 0.301 1,255.06 1,766.68 3,021.74 91282CAJO 1643 001 UST 2,000,000.00 1,975,895.83 1,979,729.17 08/31/2025 0.250 0.639 2,527.70 3,833.34 6,361.04 91282CBT7 1635 001 UST 2,000,000.00 2.000,990.88 2,000,857.70 03/31/2026 0.750 0.736 7,561.93 -133.18 7,428.75 91282CAP6 1636 001 UST 2,000,000.00 1,996,804.13 1,998,052.62 10/15/2023 0.125 0.249 1,259.75 1,248.49 2,508.24 91282CDH1 1653 001 UST 1,000,000.00 978,316.57 982,913.06 11/15/2024 0,750 1.696 3,765.88 4,596.49 8,362.37 91282CCJ8 1654 001 UST 1,000,000.00 965,940.68 970,233.08 06/30/2026 0.875 1.780 4,375.39 4,292,40 8,667.79 912828ZW3 1645 001 UST 2,000,000.00 1,979,275.64 1.982,758.09 06/30/2025 0.250 0.600 2.500.22 3,482.45 5,982.67 912828YE4 1646 001 UST 2,000,000.00 2,035,726.09 2,027,426.09 08/31/2024 1.250 0.423 12.638.50 -8,300.00 4,338.50 Portfolio ENCI Data Updated: SET _QTR: 02/15/2023 12:47 AC Run Dale: 02/15/2023 - 12:47 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 2 July 1, 2022 - December 31, 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 91282CBR1 1655 001 UST 1,000,000.00 977,810.38 984,363.98 03/15/2024 0,250 1.586 1.262.16 6,553.60 7,815.76 912828Y87 1634 001 UST 6,000,000.00 6.168,317.69 6,127,620.64 07/31/2024 1.750 0.384 52,641.88 -40,697.05 11,944.83 9128282D1 1604 001 UST 2,000,000.00 1,992,066.55 1,995,493.21 08/31/2023 1.375 1.726 13,902.34 3,426.66 17,329.00 91282BS92 1592 001 UST 3,000,000.00 2,971,299.03 2,984,668.60 07/31/2023 1.250 2.148 18,800.66 13,369 57 32,170.23 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 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 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 795450S89 1570 001 SMAEBN 245,000.00 245,000.00 245,000,00 06/27/2023 3.300 3.300 4,075.73 0.00 4,075.73 02007GD26 1662 001 ALLYBK 244,000.00 0.00 244,00000 11/17/2025 4,800 4.800 1,443.95 0,00 1,443.95 05580AMB7 1562 001 BMWBNK 246,000.00 246,000.00 246,000-00 03/29/2023 2.900 2.900 3,596.32 0,00 3,596.32 20033AZK5 1571 001 COMNTY 245,000.00 245,000.00 245,000,00 06/29/2023 3.300 3.300 4,075.72 0.00 4,075.72 87165FT53 1664 001 SYNCHR 244,000.00 0.00 244,000.00 11/18/2027 4.250 4.250 1,250.08 0.00 1,250.08 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 2,322.20 0„00 2,322.20 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 3,640.18 0.00 3,640.18 17312QH69 1563 001 CITIBK 246,000.00 246,000.00 246,000.00 03/29/2023 2.850 2.850 3,534.31 0.00 3,534.31 45581EAS0 1564 001 INDUST 249,000.00 249,000.00 249.000.00 03/29/2023 2.900 2.900 3,640.19 0.00 3,640.19 61747MR37 1565 001 MORSTN 246,000.00 246,000.00 246.000.00 03/29/2023 2.900 2.900 3,596.32 0.00 3,596.32 501798LT7 1566 001 LCABNK 246,000.00 246,000.00 246,000.00 03/29/2023 2.800 2.800 3,472.30 0.00 3,472.30 29278TAU4 1568 001 ENERBK 246,000.00 246,000.00 246,000.00 03/29/2023 2.850 2,850 3,534.31 0.00 3,534.31 33646CJP0 1569 001 FSRCBK 246,000.00 246,000.00 246.000.00 04/11/2023 2.850 2.850 3,534.32 0.00 3,534.32 02589AAM4 1580 001 AMEXNL 245,000.00 245,000.00 245,000.00 06/26/2023 3.300 3.300 4,075.73 0.00 4,075.73 06251AW48 1585 001 BKHAPO 246,000.00 246,000.00 246,000.00 03/25/2024 2.900 2,900 3,596.32 0.00 3,596.32 3133EHN25 1606 001 FFCB 2,000,000.00 2,010,072.33 2,006,295.21 11/01/2023 2.200 1.798 22,000.00 -3,777.12 18,222 88 3133EHST1 1591 001 FFCB 1,000.000.00 997.725.56 998,788.94 07/26/2023 2.010 2.210 10,050.00 1,063.38 11,113.38 27002YEQ5 1594 001 EGLEBK 249,000.00 249.000.00 249,000.00 06/2012024 2.300 2.300 2,887.02 0.00 2.887.02 200056QRZ8 1595 001 CMBKGN 249.000.00 249,000.00 249,000.00 06/26/2024 2.300 2.300 2,887.02 0.00 2,887.02 61760AG52 1593 001 MGSTPB 246,000.00 246,000.00 246,000.00 06/13/2024 2.600 2.600 3,224.2E 0.00 3,224.28 249398BT4 1596 001 DENSVB 249,000.00 249,000.00 249,000.00 06/21/2023 2.250 2.250 2,824.28 0.00 2,824.28 59013KAR7 1597 001 MERRBK 249.000.00 249,000.00 249,000.00 12/28/2023 2.400 2.400 3,012.56 0.00 3,012.56 336460CQ1 1598 001 FSBDQ 249.000.00 249,000.00 249,000.00 06/28/2024 2.300 2.300 2,887.02 0.00 2,887.02 761400BY1 1599 001 RVBANK 247,000.00 247,000.00 247,000.00 06/2812024 2.300 2.300 2,863.85 0.00 2,863.85 15118RSNB 1614 001 CELTIC 249,000.00 249,000.00 249,000.00 10/30/2023 1.600 1.600 2,008.37 0.00 2.008.37 29367SJQ8 1607 001 ENTERB 249,000.00 249,000.00 249,000.00 11/08/2024 1.800 1.800 2,259.40 0.00 2.259.40 33640VDE5 1609 001 FIRSTS 249,000.00 249,000.00 249,000.00 11/15/2023 1.700 1.700 2,133.92 0.00 2,133.92 203522AT4 1610 001 COMMSK 249,000.00 249,000.00 249,000.00 11/08/2024 1.650 1.650 2,071.12 0.00 2,071.12 73319FAD1 1611 001 POPBK 249,000.00 249,000.00 249,000.00 11/04/2024 1.650 1.650 2,071.12 0.00 2.071.12 89579NCB7 1612 001 TRIADB 249,000.00 249,000.00 249,000.00 11/08/2024 1.800 1,800 2,259.40 0.00 2.259.40 Portfolio ENCI Data Updated: SET _QTR: 02/15/2023 12:47 AC Run Date: 02/1512023 - 12:47 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 - December 31, 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 695292FP2 1613 001 PADUCA 249,000.00 249,000.00 249,000.00 11/08/2024 1.650 1.650 2,071.12 0.00 2,071.12 300185JF3 1615 001 EVRGRN 249,000.00 249,000.00 249,000.00 03/26/2025 1.000 1.000 1,255.24 0.00 1,255.24 34969RCS5 1616 001 FORTUB 249,000.00 249,000.00 249,000.00 03/27/2024 1.000 1.000 1,255.24 0.00 1,255.24 59565QCS2 1617 001 MIDCBK 249,000.00 249,000.00 249,000.00 03/27/2025 1.000 1.000 1,255.24 0.00 1,255.24 52465JHT7 1618 001 LEGEND 249,000.00 249,000.00 249,000.00 09/30/2024 1.000 1.000 1,255.24 0.00 1,255.24 020080BUO 1619 001 ALMABK 249,000.00 249,000.00 249,000.00 09/29/2023 0.900 0.900 1,129.70 0.00 1,129.70 15201QCJ4 1620 001 CTRSTE 248,000.00 248,000.00 248,000.00 03/31/2025 1,000 1.000 1,250.19 0.00 1,250.19 694231AD3 1621 001 PACENT 249,000.00 249,000.00 249,000,00 03/31/2025 1,150 1.150 1,443.53 0.00 1,443.53 538036KU7 1622 001 LIVOAK 249,000.00 249,000.00 249,000.00 03/31/2025 1.100 1.100 1,380.76 0.00 1,380.76 219255AK2 1623 001 CRNHSK 249,000.00 249,000.00 249,000.00 03/29/2024 1.100 1.100 1,380.75 0.00 1,380.75 710673ACB 1624 001 PEBATN 249,000.00 249,000.00 249,000.00 09/30/2024 1.000 1.000 1,255.24 0.00 1,255.24 654062JRO 1625 001 NCBS 249,000.00 249,000.00 249,000.00 03/28/2024 1.150 1.150 1,443.53 0.00 1,443.53 549104SS7 1627 001 LUANSB 249,000.00 249,000.00 249,000.00 10/02/2025 0.400 0.400 502.09 0.00 502.09 33847E4E4 1626 001 FLGSB 249,000.00 249,000.00 249,000.00 09/30/2024 0.400 0.400 502.10 0.00 502.10 51507LBZ6 1628 001 LDMCB 249,000.00 249,000,00 249,000.00 10/29/2025 0.400 0.400 502.08 0.00 502.08 33625CDVB 1629 001 FSECWA 249,000.00 249,000.00 249,000.00 10/15/2025 0.400 0.400 502.08 0.00 502.08 33744AAW9 1630 001 USBI 249,000.00 249,000.00 249,000.00 11/18/2025 0.400 0.400 502.08 0.00 502.08 50116CCP2 1631 001 KANBNK 249,000.00 249,000.00 249,000.00 11/28/2025 0.450 0.450 564.88 0.00 564.88 90348JN48 1632 001 UBS 249,000.00 249,000.00 249,000.00 06/23/2026 0.750 0.750 941.42 0.00 941.42 649447UZO 1633 001 NYCB 249,000.00 249,000,00 249,000.00 07/01/2026 0.700 0.700 878.66 0.00 878.66 39573LCE6 1648 001 UNIICC 248,000.00 248,000.00 248,000.00 01/14/2027 1.350 1.350 1,687;76 000 1,687.76 89235MMP3 1649 001 TOYFBN 248,000.00 248,000.00 248,000.00 01/13/2027 1.350 1.350 1,687.76 0.00 1,687.76 856285C41 1650 001 SBIIN 248,000.00 248,000.00 248,000.00 01/13/2027 1.400 1.400 1,750.27 0.00 1,750.27 64034KAJO 1651 001 NELNTB 248,000.00 248.000.00 248,000.00 02/02/2027 1.450 1.450 1,812.78 0.00 1,812.78 052392CC9 1665 001 AUSFCU 248,000.00 0.00 248,000.00 11/27/2026 5.050 5.050 1,132.31 0.00 1,132.31 07181JAU8 1660 001 BAXTCU 248,000.00 0.00 248,000.00 11/23/2026 5.000 5.000 1,324.93 0.00 1,324.93 01025RAD1 1661 001 ALABAM 248,000.00 0.00 248,000.00 11/22/2024 4.900 4.900 1,298.43 0.00 1,298.43 397129AJ6 1663 001 GRNWCU 248,000.00 0.00 248,000.00 05/28/2024 4.950 4.950 1,109.89 0.00 1,109.89 Subtotal 129,999,591.69 136,073,376.55 129,743,266.29 1.371 840,817.43 41,631.68 882,449.11 Total 129,999,591.69 136,073,376.55 129,743,266.29 1.371 840,817.43 41,631.68 882,449.11 Portfolio ENCI Data Updated: SET _QTR: 02/15/2023 12:47 AC Run Date: 02/15/2023 - 12:47 No fiscal year history available IE (PRF_IE) 7.2.0 Report Ver. 7.3.6.1 Cityof Encinitas - Qtr Inv Report CITY OF TA u� p 505 S. ULCAN S. VUL Investments by Issuer Encinitas, CA 92024 �r (760)633-2641 r Active Investments Sorted by Fund December 31, 2022 Investment Current Market YTM Redemption Days To Call CUSIP Investment# SecurityType Class Remaining Cost pate Market Value DatA 365 DateMaturit•, Gate Collateral ALABAMA CREDIT UNION 01025RAD1 1661 Certificates of Deposit - Bank Amort 248,000.00 4.900 249,331.76 12/31/2022 4.900 11/22/2024 691 Subtotal and Average 248,000.00 249,331.76 4.900 691 Ally Bank 02007GD26 1662 Certificates of Deposit - Bank Amort 244,000.00 4.800 245,434.72 12/31/2022 4.800 11/17/2025 1.051 Subtotal and Average 244,000.00 245,434.72 4.800 1,051 ALMA BANK 020080BUO 1619 Certificates of Deposit - Bank Amort 249.000.00 0.900 242,306.88 12/31/2022 0,900 09/29/2023 271 Subtotal and Average 249,000.00 242,306.88 0.900 271 American Express National Bank 02589AAM4 1580 Certificates of Deposit- Bank Amort 245,000.00 3.300 243,850.95 12/31/2022 3.300 06/26/2023 176 Subtotal and Average 245,000.00 243,850.95 3.300 176 AUSTIN TELCO FCU 052392CC9 1665 Certificates of Deposit - Bank Amort Subtotal and Average BAXTER CREDIT UNION 07181 JAU8 1660 Certificates of Deposit - Bank Amort Subtotal and Average BANK HAPOALIM BM NY 06251AW48 1585 Certificates of Deposit - Bank Amort Subtotal and Average BMW Bank North America 05580AMB7 1562 Certificates of Deposit - Bank Amort Subtotal and Average CA Asset Management Program SYS1003 1003 Managed Pool Accounts Amort Data Updated. SET_QTR: 02/15/2023 12:47 Run Dale, 02/15/2023 - 12:47 248,000.00 5.050 248,000.00 248,000.00 5.000 248,000.00 252,114.32 12/31/2022 5.050 11/27/2026 1,426 252,114.32 5.050 1,426 251,662.96 12/31/2022 5.000 11/23/2026 1,422 251,662.96 5.000 1,422 246,000.00 2.900 240,939.78 12/31/2022 2.900 03/25/2024 449 246,000.00 240,939.78 2.900 449 246,000.00 2.900 245,259.54 12/31/2022 2.900 03/29/2023 87 246,000.00 245,259.54 2.900 87 1, 085, 822.95 1.140 1, 085, 822.95 12/31/2022 1 A 40 1 Portfolio ENCI AC 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 CI&ss Remaining Cost Rat- Market Value QatQ 365 DateMadurity fi.}e Collateral Subtotal and Average 1,085,822.95 1,085,822.95 1.140 1 CELTIC BANK 15118RSN8 1614 Negotiable CDs Amort 249,000.00 1.600 242,921.91 12/31/2022 1.601 10/30/2023 302 Subtotal and Average 249,000.00 242,921.91 1.601 302 Citi Bank NA 17312QH69 1563 Certificates of Deposit- Bank Amort 246,000 00 2.850 245,230.02 12/31/2022 2.850 03/29/2023 87 Subtotal and Average 246,000.00 245,230.02 2.850 87 COMMERCE BANK GENEVA MN 200056QRZ8 1595 Certificates of Deposit - Bank Amort 249,000.00 2.300 240,693 36 12/31/2022 2.300 06/26/2024 542 Subtotal and Average 249,000.00 240,693.36 2.300 542 COMMUNITY BANK 203522AT4 1610 Certificates of Deposit - Bank Amort Subtotal and Average Comenity Capital Bank 20033AZK5 1571 Certificates of Deposit - Bank Amort Subtotal and Average SD County Investment Pool SYS1584 1584 CORNHUSKER BANK 219255AK2 1623 CENTERSTATE BANK NA 15201QCJ4 1620 Denver Savings Bank 249398BT4 1596 Managed Pool Accounts Amort Subtotal and Average 249,000.00 1.650 249,000.00 245,000.00 3.300 245,000.00 235,917.54 12/31/2022 1.650 11/08/2024 677 235,917.54 1.650 677 243,821.55 12/31/2022 3.300 06/29/2023 179 243,821.55 3.300 179 1,236,124.71 1.130 1,236,124.71 12/31/2022 1.130 1 1,236,124.71 1,236,124.71 1.130 1 Certificates of Deposit - Bank Amort 249,000.00 1.100 Subtotal and Average 249,000.00 Certificates of Deposit - Bank Amort Subtotal and Average Certificates of Deposit - Bank Amort Subtotal and Average 248,000.00 1.000 248,000.00 249,000.00 2.250 249,000.00 238,375.17 12/31/2022 1.100 03/29/2024 453 238,375.17 1.100 453 229,127.20 12/31/2022 1.000 03/31/2025 820 229,127.20 1.000 820 246,641.97 12/31/2022 2.250 06/21/2023 171 246,641.97 2.250 171 Portfolio ENCI Data Updated: SET_QTR: 02/15/2023 12:47 AC Run Date: 02/15/2023 - 12:47 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 a o Market Value Market Date YTM 365 Page 3 Redemption Days To Call Collateral EAGLEBANK 27002YEQ5 1594 Certificates of Deposit - Bank Amort 249,000.00 2.300 240,783.00 12/31/2022 2 300 06/20/2024 536 Subtotal and Average 249,000.00 240,783.00 2.300 536 Enerbank USA 29278TAU4 1568 Certificates of Deposit - Bank Amort 246.000.00 2 850 245,230.02 12/31/2022 2.850 03/29/2023 87 Subtotal and Average 246,000.00 245,230.02 2.850 87 ENTERPRISE BANK AND TRUST 29367SJQ8 1607 Certificates of Deposit - Bank Amort 249,000.00 1.800 236,582.37 12/31/2022 1.800 11/08/2024 677 Subtotal and Average 249,000.00 236,582.37 1.800 677 EVERGREEN BANK GROUP 300185JF3 1615 First Bank Puerto Rico 33767GAMO 1608 FEDERAL FARM CREDIT BANK 3133EHST1 1591 3133EHN25 1606 Federal Farm Credit 3133EJBP3 1590 3133EKSN7 1605 Federal Home Loan Bank 3130AN4T4 1637 FIRST SERVICE BANK 33640VDE5 1609 Certificates of Deposit - Bank Amort Subtotal and Average 249,000.00 1.000 229,971.42 12/31/2022 1.000 03/26/2025 815 249,000.00 229,971.42 1.000 815 Negotiable CDs Amort 249,000.00 1.850 Subtotal and Average 249,000.00 Federal Agency Coupon Securities Amort 990,790.00 2.010 Federal Agency Coupon Securities Amort 2,032,840.00 2.200 Subtotal and Average 3,023,630.00 Federal Agency Coupon Securities Amort 2,021,250.00 2.500 Federal Agency Coupon Securities Amort 3,995,388.00 1.770 Subtotal and Average 6,016,638.00 Federal Agency Coupon Securities Amort 2,010,100.00 0.875 Subtotal and Average 2,010,100.00 Certificates of Deposit - Bank Amort 249,000.00 1.700 Subtotal and Average 249,000.00 237,025.59 237,025.59 12/31/2022 1.852 1.852 10/25/2024 663 663 985,220.00 12/31/2022 2.234 07/26/2023 206 1,958,840.00 12/31/2022 1.805 11/01/2023 304 2,944,060.00 1.936 269 1,996,600.00 12/31/2022 2.210 02/02/2023 32 3,946,680.00 12/31/2022 1.800 06/26/2023 176 5,943,280.00 1.931 127 1,786,980.00 12/31/2022 0.770 06/12/2026 1,258 1,786,980.00 0.769 1,256 242,809.86 12/31/2022 1.700 11/16/2023 318 242,809.86 1.700 318 Portfolio ENCI Data Updated: SET_QTR: 02/15/2023 12:47 AC Run Date: 02/15/2023 - 12:47 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 rife 365 n, . M.t—ity C P Collateral FLAGSTAR BANK FSB 33847E4E4 1626 Certificates of Deposit - Bank Amort 249,000.00 0.400 231,570.00 12/31/2022 0.400 09/30/2024 638 Subtotal and Average 249,000.00 231,570.00 0.400 638 Federal Nat'l Mortgage Assoc. 3135GOU43 1602 Federal Agency Coupon Securities Amort 2,086,700.00 2.875 1,974,300.00 12/31/2022 1.801 09/12/2023 254 3135GO6G3 1658 Federal Agency Coupon Securities Amort 953,700.00 0.500 899,250.00 12/31/2022 1.813 11/07/2025 1,041 Subtotal and Average 3,040,400.00 2,873,550.00 1.768 498 FORTUNE BANK ARNOLD 34969RCS5 1616 First State Bank Dequeen 336460C Q 1 1598 1ST SECURITY BK OF WASH 33625CDVB 1629 First Source Bank 33646CJPO 1569 GREENWOOD CREDIT UNION 397129AJ6 1663 Industrial & Comm Bank China 45581EASO 1564 KS STATEBANK 50116CCP2 1631 CA LAIF 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 2.300 249,000.00 Certificates of Deposit - Bank Amort 249,000.00 0.400 Subtotal and Average 249,000.00 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 246,000.00 2.850 246,000.00 248,000.00 4.950 248,000.00 249,000.00 2,900 249,000.00 249,000.00 0.450 249,000.00 238,098.78 12/31/2022 1.000 03/27/2024 451 238,098.78 1.000 451 240,665.97 12/31/2022 2.300 06/28/2024 544 240,665.97 2.300 544 221,746.95 12/31/2022 0.400 10/15/2025 1,018 221,746.95 0.400 1,018 245,104.56 12/31/2022 2..850 04/11/2023 100 245,104.56 2.850 100 249.113.52 12/31/2022 4.950 05/28/2024 513 249,113.52 4.950 513 248,257.98 12/31/2022 2.900 03/29/2023 87 248,257.98 2.900 87 220,989.99 12/31/2022 0.450 11/28/2025 1,062 220,989.99 0.450 1,062 Portfolio ENCI Data Updated: SET _QTR: 02/1512023 12:47 AC Run Date: 02/15/2023 - 12:47 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 Cost Rate Market Value Date 365 o,te tuaturity Date Collateral SYS1012 1012 Local Agency Investment Funds Amort 11,888,290.15 0.990 11,888,290.15 12/31/2022 0.990 1 Subtotal and Average 11,888,290.15 11,888,290.15 0.990 1 LCA Bank Corp 501798LT7 1566 Certificates of Deposit- Bank Amort 246,000.00 2.800 245,200.50 12/31/2022 2.800 03/29/2023 87 Subtotal and Average 246,000.00 245,200.50 2.800 87 LANDMARK COMMUNITY BANK 51507LBZ6 1628 Certificates of Deposit - Bank Amort 249,000.00 0.400 221,398.35 12/31/2022 0.400 10/29/2025 1,032 Subtotal and Average 249,000.00 221,398.35 0.400 1,032 LEGENDS BANK 52465JHT7 1618 Certificates of Deposit - Bank Amort 249,000.00 1.000 233,895.66 12/31/2022 1.000 09/30/2024 638 Subtotal and Average 249,000.00 233,895.66 1.000 638 LIVE OAK BANKING COMPANY 538036KU7 1622 Certificates of Deposit - Bank Amort 249,000.00 1,100 230,394.72 12/31/2022 1.100 03/31/2025 820 Subtotal and Average 249,000.00 230,394.72 1.100 820 549104SS7 1627 Medallion Bank UT 58404DBL4 1561 Merrick Bank 59013KAR7 1597 Certificates of Deposit - Bank Amort Subtotal and Average Certificates of Deposit - Bank Amort Subtotal and Average Certificates of Deposit - Bank Amort Subtotal and Average MORGAN STANLEY PRIVATE BANK 61760AG52 1593 Certificates of Deposit - Bank Amort Subtotal and Average MIDCOUNTRY BANK 59565QCS2 1617 Certificates of Deposit - Bank Amort Subtotal and Average 249,000.00 0.400 249,000.00 249,000.00 2,900 249,000.00 249,000.00 2.400 249,000.00 246,000.00 2.600 246,000.00 249,000.00 1.000 249,000.00 222,307.20 12/31/2022 0.400 10/02/2025 1,005 222,307.20 0.400 1,005 248,267.94 12/31/2022 2 900 03/28/2023 86 248,267.94 2.900 86 243,589.23 12/31/2022 2.400 12/28/2023 361 243,589.23 2.400 361 239,067.72 12/31/2022 2.600 06/13/2024 529 239,067.72 2.600 529 229,949.01 12/31/2022 1.000 03/27/2025 816 229,949.01 1.000 816 Portfolio ENCI Data Updated: SET _QTR: 02/15/2023 12:47 AC Run Date: 02/15/2023 - 12:47 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 „FjgtA Market Value Date 365 ❑arn Maturity Warn Collateral Morgan Stanley Bank 61747MR37 1565 Certificates of Deposit- Bank Amort 246,000.00 2.900 245,259.54 12/31/2022 2.900 03/29/2023 87 Subtotal and Average 246,000.00 245,259.54 2.900 87 NICOLET NATIONAL BANK 654062JR0 1625 Certificates of Deposit- Bank Amort 249,000.00 1.150 238.546 98 12/31/2022 1.150 03/28/2024 452 Subtotal and Average 249,000.00 238,546.98 1.150 452 NELNET BANK INC 64034KAJ0 1651 Certificates of Deposit - Bank Amort 248,000.00 1.450 219,244.40 12/31/2022 1.450 02/02/2027 1,493 Subtotal and Average 248,000.00 219,244.40 1.450 1,493 NEW YORK COMMUNITY BANK 649447UZ0 1633 Certificates of Deposit - Bank Amort 249,000.00 0,700 218,009.46 12/31/2022 0.700 07/01/2026 1,277 Subtotal and Average 249,000.00 218,009.46 0.700 1,277 PACIFIC ENTERPRISE BANK 694231AD3 1621 Certificates of Deposit- Bank Amort Subtotal and Average PADUCAH BANK AND TRUST 695292FP2 1613 Certificates of Deposit - Bank Amort Subtotal and Average PEOPLES BANK/SARDIS TN 710673AC8 1624 Certificates of Deposit - Bank Amort Subtotal and Average POPPY BANK 73319FAD1 1611 Certificates of Deposit - Bank Amort Subtotal and Average REVERE BANK 761400BY1 1599 Certificates of Deposit - Bank Amort Subtotal and Average STATE BANK OF INDIA 856285C41 1650 Certificates of Deposit - Bank Amort 249,000.00 1.150 249,000.00 230,681.07 12/31/2022 1.150 03/31/2025 820 230,681.07 1.150 820 249,000.00 1.650 235,917.54 12/31/2022 1.650 11/08/2024 677 249,000.00 235,917.54 1.650 677 249,000.00 1.000 249,000.00 249,000.00 1.650 249,000.00 247,000.00 2.300 247,000.00 233,895.66 12/31/2022 1.000 09/30/2024 638 233,895.66 1.000 638 235,992.24 12/31/2022 1.650 11/04/2024 673 235,992.24 1.650 673 238,792.19 12/31/2022 2.300 06/28/2024 544 238,792.19 2.300 544 248,000.00 1.400 219,155.12 12/31/2022 1.400 01/13/2027 1,473 Portfolio ENCI Data Updated: SET _QTR: 02/15/2023 12:47 AC Run Date: 02/15/2023 - 12:47 No fiscal year history available DI (PRF_DI) 7.1.1 Report Ver. 7.3 6.1 City of Encinitas - Qtr Inv Report CUSIP Investment # Investment Security Type class Investments by Issuer Sorted by Fund Current Remaining Cost Market Value Market Date. YTM 3n5 Page 7 Redemption Days To Call Collateral Subtotal and Average 248,000.00 219,155.12 1.400 1,473 Sallie Mae Bank/Murray 795450S89 1570 Certificates of Deposit- Bank Amort 245,000.00 3.300 243,643.60 12/31/2022 3.300 06/27/2023 177 Subtotal and Average 245,000.00 243,843.60 3.300 177 Synchrony Bank 87165FT53 1664 Certificates of Deposit- Bank Amort 244.000.00 4.250 240,305.84 12/31/2022 4.250 11/18/2027 1,782 Subtotal and Average 244,000.00 240,305.84 4.250 1,782 TOYOTA FINANCIAL SVGS BK 89235MMP3 1649 Certificates of Deposit- Bank Amort 248,000.00 1.350 218,701.28 12/31/2022 1.350 01/13/2027 1,473 Subtotal and Average 248,000.00 218,701.28 1.350 1,473 TRIAD BANK FRONTENAC MO 89579NCB7 1612 Certificates of Deposit- Bank Amort 249,000.00 1.800 236,582.37 12/31/2022 1.800 11/08/2024 677 Subtotal and Average 249,000.00 236,582.37 1.800 677 Union Bank Checking Acct. SYS1010 1010 Passbook/Checking Accounts Amort 11,377,458.20 11,377,458.20 12/31/2022 1 Subtotal and Average 11,377,458.20 11,377,458.20 1 US BANK SYS1004 1004 Money Market Funds Amort 27,524,895.68 1.370 27.524,895 68 12/31/2022 1.370 1 Subtotal and Average 27,524,895.68 27,524,895.68 1.370 1 UBS BANK USA 90348JN48 1632 Certificates of Deposit - Bank Amort 249,000.00 0.750 218,343.12 12/31/2022 0.750 06/23/2026 1,269 Subtotal and Average 249,000.00 218,343.12 0.750 1,269 GREENSTATE CREDIT UNION 39573LCE6 1648 Certificates of Deposit- Bank Amort 248,000.00 1 350 218,430.96 12/31/2022 1.350 01/14/2027 1,474 Subtotal and Average 248,000.00 218,430.96 1.350 1,474 FIRST US BANK 33744AAW9 1630 Certificates of Deposit - Bank Amort 249,000.00 0.400 220,925.25 12/31/2022 0.400 11/18/2025 1,052 Subtotal and Average 249,000.00 220,925.25 0.400 1,052 Portfolio ENCI Data Updated: SET QTR: 02/15/2023 12:47 AC Run Date: 02/15/2023 - 12:47 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 CostRntp Market Value 365 Collateral U.S. Treasury Notes 912828S92 1592 U.S. Treasury Coupon Securities Fair 2,884,687.50 1.250 2,940,930,00 12/31/2022 2-181 07/31/2023 211 9128282D1 1604 U.S. Treasury Coupon Securities Amort 1,971,562.50 1.375 1.955,240.00 12/31/2022 1.729 08/31/2023 242 912828Y87 1634 U.S. Treasury Coupon Securities Amort 6,247,500.00 1.750 5,739,120.00 12/31/2022 0.394 07/31/2024 577 91282CBT7 1635 U.S. Treasury Coupon Securities Amort 2,001,250.00 0.750 1,792,580.00 12/31/2022 0.736 03/31/2026 1,185 91282CAP6 1636 U.S. Treasury Coupon Securities Amort 1,994,375.00 0.125 1,929,460.00 12/31/2022 0.249 10/15/2023 287 91282CBM2 1638 U.S. Treasury Coupon Securities Amort 1,990,859.38 0.125 1,900,240.00 12/31/2022 0.301 02/15/2024 410 91282CB03 1639 U.S. Treasury Coupon Securities Amort 1,979,921.88 0.500 1,782,120.00 12/31/2022 0.720 02/28/2026 1,154 91282CAB7 1640 U.S. Treasury Coupon Securities Amort 5,910,000.00 0.250 5,414,280.00 12/31/2022 0.624 07/31/2025 942 912828ZC7 1641 U-S. Treasury Coupon Securities Amort 2,042,812.50 1.125 1,866,960.00 12/31/2022 0.531 02/28/2025 789 912828YH7 1642 U.S. Treasury Coupon Securities Amort 2,068,437.50 1,500 1,899,140.00 12/31/2022 0.432 09/30/2024 638 91282CAJO 1643 U.S. Treasury Coupon Securities Amort 1,968,437.50 0.250 1,798,440.00 12/31/2022 0.636 08/31/2025 973 91282CAM3 1644 U.S. Treasury Coupon Securities Amort 1,966,875.00 0.250 1,795,780.00 12/31/2022 0.648 09/30/2025 1,003 912828ZW3 1645 U.S. Treasury Coupon Securities Amort 1,972,500.00 0.250 1,811,800.00 12/31/2022 0.600 06/30/2025 911 912828YE4 1646 U.S. Treasury Coupon Securities Amort 2,051,875.00 1.250 1,893,360.00 12/31/2022 0.419 08/31/2024 608 912828YM6 1647 U.S. Treasury Coupon Securities Amort 1,034.375.00 1.500 947,460.00 12/31/2022 0.453 10/31/2024 669 912828ZFO 1652 U.S. Treasury Coupon Securities Amort 964,218.75 0.500 918,440.00 12/31/2022 1.705 03/31/2025 820 91282CDHJ 1653 U.S. Treasury Coupon Securities Amort 975,468.75 0.750 933,360.00 12/31/2022 1.688 11/15/2024 684 91282CCJ8 1654 U.S. Treasury Coupon Securities Amort 963,281.25 0.875 894,220.00 12/31/2022 1.763 06/30/2026 1,276 91282CBR1 1655 U.S. Treasury Coupon Securities Amort 973,750.00 0.250 948,010.00 12/31/2022 1.578 03/15/2024 439 91282CCG4 1656 U.S. Treasury Coupon Securities Amort 1,938,906.25 0,250 1,877,040.00 12/31/2022 1.627 06/15/2024 531 91282CAT8 1657 U.S. Treasury Coupon Securities Amort 946,953.13 0.250 894,180.00 12/31/2022 1.759 10/31/2025 1,034 91282CCP4 1659 U.S. Treasury Coupon Securities Amort 3,804,375.00 0.625 3,534,520.00 12/31/2022 1.787 07/31/2026 1,307 Subtotal and Average 48,652,421.89 45,466,680.00 0.933 760 Total and Average 129,742,781.58 125,375,418.28 1.160 401 Data Updated: SET QTR: 02/15/2023 12:47 Portfolio ENCIAC Run Date: 02/15/2023 - 12:47 No fiscal year history available DI (PRF_DI) 7.1.1 Report Ver. 7.3.6.1