The URL can be used to link to this page

Quarterly Investment Report for the 9 months ended 03-31-22CITY OF ENCINITAS INVESTMENT REPORT MEMORANDUM Nine Months ended March 31, 2022 TO: City Council VIA: Pamela Antil, City Manager FROM: Teresa S. McBroome, Director of Finance/City Treasurer DATE: May 9, 2022 SUBJECT: City of Encinitas Investment Report for the nine (9) months ended March 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 $121.3 million at March 31, 2022, compared to an average investable balance for the nine months ended March 31, 2022, of $109.3 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 $135,",OW $125,OW,OW 115,000,000 $105,OW,OW - $95,000,000 $85,OW,OW $75,000,000 - - Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun End of Month Blanca — FY 21-22 FY 20-21 FY 19-20 FY 18-19 FY 17-18 The City utilizes a variety of investment vehicles, including direct investments and indirect investments. Direct investments are primarily fixed income securities issued by the US Treasury and several US Gov't Agencies, such as the Federal National Mortgage Association (FNMA) and the Federal Home Loan Mortgage Corporation (FHLMC). Indirect investments include money market funds and pooled investments funds managed by other agencies, such as the California Local Agency Investment Fund. Indirect investment balances are generally available to the City on a next day basis and are classified as "liquid" meaning available to pay current demands. Monies invested in direct securities can only be accessed via the maturity of a security or selling the security prior to maturity. The final maturities on the City's direct securities vary from less than two months to under five years. The City has overnight liquidity of 28.8 million at March 31, 2022. FY 2021-22 June 30, 2022 March 31, 2022 Dec. 31, 2021 Sep. 30, 2021 Book Value $ 121,316,026 $ 113,540,519 $ 108,584,422 Market Value $ 118,954,232 $ 113,821,823 $ 109,637,863 Unrealized Gain/(Loss) $ (2,361,794) $ 281,304 $ 1,053,441 Unrealized Gain/Loss as % of Book Value -1.95% 0.25% 0.97% Effective Rate of Return 1.29% 1.33% 1.32% Average Yield To Maturity 1.25% 1.23% 1.31% Average Maturity (Years) 1.76 1.71 1.90 Investment Earnings Year to Date $ 1,056,642 $ 724,153 $ 388,307 The Pool earned $1,056,642 the first nine months of FY 2021-22 for an annualized return of 1.29 percent. This compares to the City's adopted performance benchmark of the one (1) year constant maturity Treasury index which averaged a 0.48 percent yield over the twelve months ended March 31, 2022, and was 1.89 percent as of March 31, 2022. City Portfolio Yield Compared to Treasury Indexes 3.50 % -- 3.00% ..... - �_ 2.00% 1.50%-- 1.00 0.50% - 0.00% In r- n 00 .-i •-1 r-1 c-I '-1 00 00 00 01 01 Ol � 'i .-I i-1 ."'� � M 0 0 0 0 r1 N N N N 11 H .-4 .1 N N N N N N C Q c.i f9 -_-y GJ f0 � Ln 0 C Q u C C y 61 f0 y of 0 Vf V C G u Cl 07 y GJ O V1 0 C fl. c f0 y OJ IC to City Portfolio 2 Yr Treasury 1 Yr Treasury 6 Mth Treasury The City utilizes a laddered maturity investment strategy in that as securities mature, new investments are directed to the 49-60-month segment to take advantage of higher rates further out on the yield curve. The market value of the City's direct investments is less than their carrying value by $2,361,794 as of March 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 March 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 18,251,600.85 18,251,600.85 18,251,600.85 15.98 0,365 1 1 Managed Pool Accounts 2,297,806.24 2,297,806.24 2,297,806.24 2.01 0.207 1 1 Money Market Funds 1,111,597.19 1,111,597.19 1,111,597.19 0.97 0.150 1 1 Certificates of Deposit - Bank 13,379,000.00 13,138,156.38 13,379,000.00 11.71 1.786 1,765 810 Negotiable CDs 498,000.00 494,093.19 498,000.00 0.44 1.727 1,643 758 U.S. Treasury Coupon Securities 57,000,000.00 54,695,244.57 56,681,844.62 49.63 1.179 1,356 909 Federal Agency Coupon Securities 22,000,000.00 21,869,254.44 21,999,698.03 19.26 1.967 1,490 492 114,538,004.28 111,857,752.86 114,219,546.93 100.00% 1.245 1,174 644 Investments Cash Passbook/Checking 7,096,478.91 7,096,478.91 7,096,478.91 0.000 1 1 (not included in yield calculations) Total Cash and Investments 121,634,483.19 118,954,231.77 121,316,025.84 1.245 1,174 644 Total Earnings Current Year Average Daily Balance Effective Rate of Return March 31 Period Ending 1,056,641.85 109,292,332.62 1.29% 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 ex nditure r 'tame T �sourcemarket values of investments wne is S Bank Custody Services. TeresafMcBroome, Finance Director\Treasurer Reporting period 07/01/2021-03131/2022 Data Updated: SET_QTR: 05/02/2022 11:29 Run Date: 05/02/2022 -11:29 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 March 31, 2022 Page 1 Average Purchase Stated YTM Maturity CUSIP Investment # Issuer Balance Date Par Value Market Value Book Value Rate S&P Mood 's 138te Local Agency Investment Funds SYS1012 1012 CA LAIF 18,251,600.85 18,251,600.85 18,251,600.85 0.365 0.365 NR Managed Pool Accounts SYS1003 1003 SYS1584 1584 Subtotal and Average 13,041,362.44 CA Asset Management Program SD County Investment Pool Subtotal and Average 3,670,892.55 Money Market Funds SYS1004 1004 US BANK Subtotal and Average Certificates of Deposit - Bank 38148PKX4 1528 06653ABM5 1533 949763JG2 1535 14042RGN5 1552 1404203Q1 1553 87270LAD5 1554 58404DBL4 1561 05580AM B7 1562 17312QH69 1563 29278TAU4 1568 45581EAS0 1564 501798LT7 1566 61747MR37 1565 33646CJPO 1569 249398BT4 1596 02589AAM4 1580 79545OS89 1570 20033AZK5 1571 020080BUO 1619 33640VDE5 1609 59013KAR7 1597 06251 AW48 1585 34969RCS5 1616 2,303,109.21 18,251,600.85 1,071,145.95 1,226,660.29 2,297,806.24 18,251,600.85 1,071,145.95 z'zv['ou0.c4 1,111,oul.19 1,1 "I 1,O9I Au 18,251,600.85 0.365 1,071,145.95 1,226,660.29 2,297,806.24 0250 0.250 AAA 0A 70 0.170 AAA 0.207 1,111,597.19 0.150 0.150 AAA 1,111,597.19 0.150 Goldman Sachs Bank USA 06/21/2017 245,000.00 246,058.40 245,000.00 2.350 2.350 BankVista 06130/2017 245,000.00 245,945.70 245,000.00 2.000 2.000 Wells Fargo Bank 06/30/2017 245,000.00 246,100.05 245,000.00 2.250 2.250 Capital One NA 07/19/2017 245,000.00 246,313.20 245,000.00 2.300 2.300 Capital One Bank USA, NA 07/19/2017 245,000.00 246,313.20 245,000.00 2.300 2.300 TIAA FSB 07/1912017 245,000.00 246,200.50 245,000.00 2.150 2.150 Medallion Bank UT 03/28/2018 249,000.00 252,961.59 249,000.00 2.900 2.900 BMW Bank North America 03129/2018 246,000.00 249,938A6 246,000.00 2.900 2.900 Citi Bank NA 03/29/2018 246,000.00 249,815.46 246,000.00 2.850 2.850 Enerbank USA 03/29/2018 246,000.00 249,815.46 246,000.00 2.850 2.850 Industrial & Comm Bank China 03/29/2018 249,000.00 252,964.08 249,000.00 2,900 2.900 LCA Bank Corp 03/29/2018 246,000.00 249,692.46 246,000.00 2.800 2.800 Morgan Stanley Bank 03129/2018 246,000.00 249,938.46 246,000.00 2.900 2.900 First Source Bank 04/11/2018 246.000.00 249,827.76 246,000.00 2.850 2.850 Denver Savings Bank 06/21/2019 249,000.00 251,310.72 249,000.00 2.250 2.250 American Express National Bank 06/26/2018 245,000.00 250,412.05 245,000.00 3.300 3.300 Sallie Mae Bank/Murray 06/27/2018 245,000.00 250,416.95 245,000.00 3.300 3.300 Comenity Capital Bank 06/29/2018 245.000.00 250.436.55 245,000.00 3.300 3.300 ALMA BANK 03/30/2020 249,000.00 246,016.98 249,000.00 0.900 0.900 FIRST SERVICE BANK 11115/2019 249,000.00 248.531.88 249,000.00 1.700 1.700 Merrick Bank 06/2812019 249,000.00 251,071.68 249,000.00 2.400 2.400 BANK HAPOALIM BM NY 03/2512019 246,000.00 249,768.72 246,000.00 2.900 2.900 FORTUNE BANK ARNOLD 03127/2020 249,000.00 243,58425 249,000.00 1.000 1.000 Data Updated: SET_QTR: 05/02/2022 11:29 Run Date: 05/02/2022 - 11 29 NR NR NR NR NR P-1 06/21/2022 06/30/2022 06/30/2022 07/19/2022 07/19/2022 NR 07/19/2022 03/28/2023 03/29/2023 03/29/2023 03/2912023 03/29/2023 03/29/2023 03/29/2023 04/11 /2023 06/21/2023 NR 06/26/2023 NR 06/27/2023 NR 06/29/2023 09/29/2023 11/15/2023 12/28/2023 03/25/2024 03/27/2024 Portfolio ENCI AC PM (PRF_PM2) 7.3.0 Report Ver. 7.3.6.1 City of Encinitas - Qtr Inv Report Portfolio Management Portfolio Details - Investments March 31, 2022 Page 2 CUSIP Average Investment # Issuer ce Balan Purchase Date Par Value Market Value Book Value Stated Rate YTM Maturity S&P Moody's Date Certificates of Deposit - Bank 654062JRO 1625 NICOLET NATIONAL BANK 03/31/2020 249,000.00 244,301 37 249,000.00 1.150 1.150 03/28/2024 219255AK2 1623 CORNHUSKER BANK 03/30/2020 249,000.00 244,042.41 249,000.00 1.100 1.100 03/29/2024 61760AG52 1593 MORGAN STANLEY PRIVATE BANK 06/13/2019 246,000.00 248,044.26 246,000.00 2.600 2.600 06/13/2024 27002YEQ5 1594 EAGLEBANK 06/20/2019 249,000.00 249,435.75 249,000.00 2.300 2.300 06/20/2024 200056QRZ8 1595 COMMERCE BANK GENEVA MN 06/26/2019 249,000.00 249,400.89 249,000.00 2.300 2.300 06/26/2024 336460CQ1 1598 First State Bank Dequeen 06/28/2019 249,000.00 249.390.93 249,000.00 2.300 2.300 06/28/2024 761400BY1 1599 REVERE BANK 06/28/2019 247,000.00 247.382.85 247,000.00 2.300 2.300 06/28/2024 33847E4E4 1626 FLAGSTAR BANK FSB 09/30/2020 249,000.00 237,311.94 249,000.00 0.400 0.400 09/30/2024 52465JHT7 1618 LEGENDS BANK 03/30/2020 249,000.00 240,919.95 249,000.00 1.000 1.000 09/30/2024 710673AC8 1624 PEOPLES BANK/SARDIS TN 03/31/2020 249,000.00 240,919.95 249,000.00 1.000 1 000 09/30/2024 73319FAD1 1611 POPPY BANK 11/04/2019 249,000.00 244,443.30 249,000.00 1.650 1.650 11/04/2024 203522AT4 1610 COMMUNITY BANK 11/08/2019 249,000.00 244,395.99 249,000.00 1.650 1.650 11/08/2024 29367SJQ8 1607 ENTERPRISE BANK AND TRUST 11/08/2019 249,000.00 245,33721 249,000.00 1 800 1.800 11/08/2024 695292FP2 1613 PADUCAH BANK AND TRUST 11/08/2019 249,000.00 244,395.99 249,000.00 1.650 1.650 11/08/2024 89579NCB7 1612 TRIAD BANK FRONTENAC MO 11/08/2019 249,000.00 245.337.21 249,000.00 1.800 1.800 11/08/2024 300185JF3 1615 EVERGREEN BANK GROUP 03/26/2020 249,000.00 237,944.40 249,000.00 1.000 1.000 03/26/2025 59565QCS2 1617 MIDCOUNTRY BANK 03/27/2020 249,000.00 237,926.97 249,000.00 1.000 1.000 03/27/2025 15201QCJ4 1620 CENTERSTATE BANK NA 03/30/2020 248,000.00 236,936 72 248,000.00 1.000 1.000 03/31/2025 538036KU7 1622 LIVE OAK BANKING COMPANY 03/31/2020 249,000.00 238,574.37 249,000.00 1.100 1 100 03/31/2025 694231AD3 1621 PACIFIC ENTERPRISE BANK 03/30/2020 249,000.00 238,942 89 249,000.00 1.150 1.150 03/31/2025 549104SS7 1627 LUANA SAVINGS BANK 10/02/2020 249,000.00 230,954.97 249,000.00 0.400 0.400 10/02/2025 33625CDV8 1629 1ST SECURITY BK OF WASH 11/13/2020 249.000.00 230.668.62 249,000.00 0.400 0.400 10/15/2025 51507LBZ6 1628 LANDMARK COMMUNITY BANK 10/29/2020 249,000.00 230,461.95 249.000.00 0.400 0.400 10/29/2025 33744AAW9 1630 FIRST US BANK 11/18/2020 249,000.00 230,178 09 249,000.00 0.400 0.400 11/18/2025 50116CCP2 1631 KS STATEBANK 11/30/2020 249,000.00 230,464.44 249,000.00 0.450 0.450 11/28/2025 90348JN48 1632 UBS BANK USA 06/23/2021 249.000.00 230,454.48 249,000.00 0.750 0.750 06/23/2026 649447UZO 1633 NEW YORK COMMUNITY BANK 06/30/2021 249,000.00 229.936.56 249,000.00 0.700 0.700 07/01/2026 856285C41 1650 STATE BANK OF INDIA 01/13/2022 248,000.00 234,253.36 248,000.00 1.400 1.400 NR NR 01/13/2027 89235MMP3 1649 TOYOTA FINANCIAL SVGS BK 01/13/2022 248,000.00 233,700 32 248,000.00 1.350 1.350 01/13/2027 39573LCE6 1648 GREENSTATE CREDIT UNION 01/14/2022 248,000.00 233,628.40 248,000.00 1.350 1.350 01/14/2027 64034KAJO 1651 NELNET BANK INC 02/02/2022 248,000.00 234,635.28 248,000.00 1.450 1.450 02/02/2027 Subtotal and Average 13,006,251.82 13,379,000.00 13,138,156.38 13,379,000.00 1.786 Negotiable CDs 15118RSN8 1614 CELTIC BANK 10/30/2019 249,000.00 248,295.33 249,000.00 1.600 1 601 10/30/2023 33767GAMO 1608 First Bank Puerto Rico 10/28/2019 249,000.00 245.797.86 249,000.00 1.850 1.852 NR NR 10/2512024 Portfolio ENCI Data Updated: SET _QTR: 05/02/2022 11:29 AC Run Date: 05/02/2022 - 1129 PM (PRF_PM2) 7.3.0 City of Encinitas - Qtr Inv Report Portfolio Management Portfolio Details - Investments March 31, 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 Subtotal and Average 498,000.00 498,000.00 494,093.19 498,000.00 1.727 U.S. Treasury Coupon Securities 912828XQ8 1578 U.S. Treasury Notes 06/26/2018 4,000,000.00 4,016,240.00 3,991,204.04 2.000 2.705 Aaa 07/31/2022 91282BL24 1572 U.S. Treasury Notes 06/26/2018 2,000,000.00 2,007,820.00 1,993,467.58 1.875 2.710 Aaa 08131/2022 9128282W9 1579 U.S. Treasury Notes 06/26/2018 2,000,000.00 2,008,040.00 1,992.182.88 1.875 2.711 Aaa 09/30/2022 912828S92 1592 U.S. Treasury Notes 03/27/2019 3,000,000.00 2,968,950.00 2,964,686.91 1.250 2,181 07/31/2023 9128282D1 1604 U.S. Treasury Notes 06/26/2019 2,000.000.00 1,980,160.00 1,990,371.85 1.375 1.729 08/31/2023 91282CAP6 1636 U.S. Treasury Notes 07/08/2021 2,000.000.00 1,938,360.00 1,996,186.67 0.125 0.249 AAA Aaa 10/1512023 91282CBM2 1638 U.S. Treasury Notes 07/08/2021 2,000.000.00 1.920,540 00 1,993,422.98 0.125 0.301 02/15/2024 91282CBR1 1655 U.S. Treasury Notes 03/09/2022 1,000,000.00 960,630 00 974,569.20 0.250 1.578 03/15/2024 91282CCG4 1656 U.S. Treasury Notes 03/09/2022 2,000,000.00 1,908,653,85 1,941,755.10 0.250 1.627 06/15/2024 912828Y87 1634 U.S. Treasury Notes 07/08/2021 6,000,000-00 5,906,280.00 6,188,445.04 1.750 0.394 07/31/2024 912828YE4 1646 U.S. Treasury Notes 07/08/2021 2,000,000.00 1,943,360.00 2,039,830.98 1,250 0.419 08/31/2024 912828YH7 1642 U.S. Treasury Notes 07/08/2021 2,000,000.00 1,952,900.00 2,052,952.07 1.500 0,432 09/30/2024 912826YM6 1647 U.S. Treasury Notes 07/08/2021 1.000,000.00 975,630.00 1,026,796.04 1.500 0.453 10/31/2024 91282CDH1 1653 U.S. Treasury Notes 03/09/2022 1,000,000.00 958,181.88 978,405.19 0.750 1.688 11115/2024 912828ZC7 1641 U.S. Treasury Notes 07/08/2021 2,000,000.00 1,922,580.00 2,034,224.27 1.125 0.531 02/28/2025 912828ZFO 1652 U.S. Treasury Notes 03/09/2022 1.000,000.00 942,070.00 964,954.86 0.500 1.705 03/31/2025 912828ZW3 1645 U.S. Treasury Notes 07/08/2021 2,000,000.00 1,858,040.00 1,977,553.34 0.250 0.600 06/30/2025 91282CAB7 1640 U.S. Treasury Notes 07/08/2021 6,000,000.00 5,562.660.00 5,926,192.72 0.250 0.624 07/31/2025 91282CAJO 1643 U.S. Treasury Notes 07/08/2021 2,000,000.00 1.850,460.00 1,974,000.00 0.250 0.636 08/31/2025 91282CAM3 1644 U.S. Treasury Notes 07/08/2021 2,000,000.00 1,847,500.00 1,972,599.51 0.250 0.648 09/30/2025 91282CAT8 1657 U.S. Treasury Notes 03/09/2022 1,000,000.00 922,880.88 948,759.98 0.250 1,759 10/3112025 91282CBQ3 1639 U.S. Treasury Notes 07/08/2021 2,000,000.00 1,849.060.00 1,983,082.76 0.500 0.720 02/28/2026 91282CBT7 1635 U.S. Treasury Notes 07/08/2021 2,000,000.00 1,865,080.00 2,001,056.75 0.750 0.736 AAA Aaa 03/3112026 91282CCJB 1654 U.S. Treasury Notes 03/09/2022 1,000,000.00 935,623.65 965,461.45 0.875 1.763 06/30/2026 91282CCP4 1659 U.S. Treasury Notes 03/1012022 4,000,000.00 3,693,544.31 3,809,682.45 0.625 1.787 07/31/2026 Subtotal and Average 47,908,284.89 57,000,000.00 54,695,244.57 56,681,844.62 1.179 Federal Agency Coupon Securities 3130AEBM1 1573 Federal Home Loan Bank 06/26/2018 2,000,000.00 2,009,100.00 1,999,888.26 2.750 2.780 AA+ Aaa 06/1012022 3135GOT78 1589 Federal Nat'l Mortgage Assoc. 03/27/2019 2,000,000.00 2,008.480.00 1.998,139.68 2000. 2.190 10/05/2022 3135GOT78 1603 Federal Nat'l Mortgage Assoc. 06/26/2019 1,000,000.00 1,004.240.00 1.001,284.57 2000. 1.740 10/05/2022 3133EDWW8 1600 Federal Farm Credit 06/26/2019 1,000,000.00 1,007,660.00 1,004,054.32 2.600 1.784 10/06/2022 3133EC4Q4 1558 Federal Farm Credit 02/23/2018 2,000,000.00 2.007,220.00 1,989,417.54 1.820 2.700 AA+ Aaa 11/23/2022 3133EJBP3 1590 Federal Farm Credit 03/2712019 2,000,000.00 2,015,980.00 2,004,618.23 2.500 2210 AAA Aaa 02/02/2023 Data Updated: SET _QTR: 05/02/2022 11:29 Run Date: 05/02/2022 - 11:29 Portfolio ENCI AC PM (PRF_PM2) 7.3.0 City of Encinitas - Qtr Inv Report Portfolio Management Portfolio Details - Investments March 31, 2022 Page 4 Average Purchase Stated YTM Maturity CUSIP Investment # Issuer Balance c_ Date Par Value Market Value Book Value Ra`e S&P Moody's Date Federal Agency Coupon Securities 3133EKSN7 1605 Federal Farm Credit 06/26/2019 4,000,000.00 3,990,640.00 3,998,574.76 1.770 1.800 AAA Aaa 06/26/2023 3133EHST1 1591 FEDERAL FARM CREDIT BANK 03/27/2019 1,000,000.00 1,000,300.00 997,193.87 2.010 2.234 07/26/2023 3135GOU43 1602 Federal Nat'l Mortgage Assoc. 06/26/2019 2,000,000.00 2,020,280.00 2,029,795.98 2.875 1.801 09/12/2023 3133EHN25 1606 FEDERAL FARM CREDIT BANK 06/26/2019 2,000,000.00 2,004,240.00 2,011,960.89 2.200 1.805 11/01/2023 3135GO6G3 1658 Federal Nat'l Mortgage Assoc. 03/09/2022 1,000,000.00 932,674.44 956,167.28 0.500 1.813 11/07/2025 3130AN4T4 1637 Federal Home Loan Bank 07/08/2021 2,000,000.00 1,868,440.00 2,008,602.65 0.875 0.770 06/12/2026 Subtotal and Average 28,610,240.68 22,000,000.00 21,869,254.44 21,999,698.03 1.967 Total and Average 109,292,332.62 114,538,004.28 111,857,752.86 114,219,546.93 1.245 Portfolio ENCI Data Updated: SET _QTR: 05/02/2022 11:29 AC Run Date: 05/02/2022-11:29 PM (PRF_PM2) 7.3.0 City of Encinitas - Qtr Inv Report Portfolio Management Portfolio Details - Cash March 31, 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. 7,096,478.91 7,096,478.91 7,096,478.91 0.000 Average Balance 0.00 Total Cash and Investments 109,292,332.62 121,634,483.19 118,954,231.77 121,316,025.84 1.245 Page 5 Portfolio ENCI Data Updated: SET _QTR: 05/02/2022 11:29 AC Run Date: 05102/2022 - 11:29 PM (PRF_PM2) 7.3.0 City of Encinitas - Qtr Inv Report Portfolio Management Activity By Type July 1, 2021 through March 31, 2022 Page 1 Stated Transaction Purchases Redemptions CUSIP Investment # Issuer Rate Date or Deposits or Withdrawals Balance Passbook/Checking Accounts (Monthly Summary) SYS1010 1010 Union Bank Checking Acct. 69,648,337.73 67,590,007.44 Subtotal 69,648,337.73 67,590,007.44 0.00 Local Agency Investment Funds (Monthly Summary) SYS1012 1012 CA LAIF 0.262 21,042,009.64 40,725,000.00 Subtotal 21,042,009.64 40,725,000.00 18,251,600.85 Managed Pool Accounts (Monthly Summary) SYS1003 1003 CA Asset Management Program 0.050 416.05 0.00 SYS1584 1584 SD County Investment Pool 0 060 18.244.29 3,000,000.00 Subtotal 18,660.34 3,000,000.00 2,297,806.24 Money Market Funds (Monthly Summary) SYS1004 1004 US BANK Subtotal Certificates of Deposit - Bank 17670DAC8 1530 17801GSB7 1551 64034KAJO 1651 856285C41 1650 89235M M P3 1649 39573LCE6 1648 Negotiable CDs Citizens State Bankl City National Bank Metropolis NELNET BANK INC STATE BANK OF INDIA TOYOTA FINANCIAL SVGS BK GREENSTATE CREDIT UNION Subtotal 0 030 46,693,036.49 64,961,628.84 46,693,036.49 64,961,628.84 1,111,597.19 1.900 12/30/2021 0.00 245,000.00 2.000 02/03/2022 0.00 245,000.00 1.450 02/02/2022 248,000.00 0.00 1.400 01/13/2022 248,000.00 0.00 1.350 01/13/2022 248,000.00 0.00 1.350 01/14/2022 248,000.00 0.00 992,000.00 490,000.00 13,379,000.00 Subtotal 498,000.00 U.S. Treasury Coupon Securities 912828S76 1523 U.S Treasury Notes 1.125 07/31/2021 0.00 2,000,000.00 91282BT34 1556 U.S Treasury Notes 1.125 09/30/2021 0.00 2,000,000.00 912828F96 1574 U.S. Treasury Notes 2000. 10/31/2021 0.00 2,000,000.00 91282BY87 1634 U.S. Treasury Notes 1.750 07/08/2021 6,247,500.00 0.00 91282CBT7 1635 U.S. Treasury Notes 0.750 07/08/2021 2,001,250.00 0.00 91282CAP6 1636 U.S. Treasury Notes 0.125 07/08/2021 1,994,375.00 0.00 Portfolio ENCI Data Updated: SET _QTR: 05/02/2022 11:29 AC Run Date, 05/02/2022 - 11:29 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, 2021 through March 31, 2022 Page 2 Stated Transaction Purchases Redemptions CUSIP Investment# Issuer Rate Date or Deposits or Withdrawals Balance U.S. Treasury Coupon Securities 91282CBM2 1638 U.S. Treasury Notes 0.125 07/08/2021 1,990,859.38 0.00 91282CBQ3 1639 U.S. Treasury Notes 0.500 07/08/2021 1,979,921.88 0.00 91282CAB7 1640 U.S. Treasury Notes 0.250 07/08/2021 5,910,000.00 0.00 912828ZC7 1641 U.S. Treasury Notes 1.125 07/08/2021 2,042,812.50 0.00 912828YH7 1642 U.S. Treasury Notes 1.500 07/08/2021 2,068,437.50 0.00 91282CAJO 1643 U.S. Treasury Notes 0.250 07/08/2021 1,968,437.50 0.00 91282CAM3 1644 U.S. Treasury Notes 0.250 07/08/2021 1,966,875.00 0.00 912828ZW3 1645 U.S. Treasury Notes 0.250 07/08/2021 1,972,500.00 0.00 912828YE4 1646 U.S. Treasury Notes 1.250 07/08/2021 2,051,875.00 0.00 912828YM6 1647 U.S. Treasury Notes 1.500 07/08/2021 1,034,375.00 0.00 912828ZFO 1652 U.S. Treasury Notes 0.500 03/09/2022 964,218.75 0.00 91282CDH1 1653 U.S. Treasury Notes 0.750 03/09/2022 975,468.75 0.00 91282CCJ8 1654 U.S. Treasury Notes 0.875 03/09/2022 963,281.25 0.00 91282CBR1 1655 U.S. Treasury Notes 0.250 03/09/2022 973,750.00 0.00 91282CCG4 1656 U.S. Treasury Notes 0250 03/09/2022 1,938,906.25 0.00 91282CATB 1657 U.S. Treasury Notes 0.250 03/09/2022 946,953.13 0.00 91282CCP4 1659 U.S. Treasury Notes 0.625 03/10/2022 3,804,375.00 0.00 S u btota I Federal Agency Coupon Securities 43,796,171.89 6,000,000.00 56,681,844.62 3133EKNM4 1601 FEDERAL FARM CREDIT BANK 2.200 02/28/2022 0.00 2,000,000.00 3133EHCT8 1536 Federal Farm Credit 2.150 03/15/2022 0.00 2,000,000.00 3130A8QS5 1524 Federal Home Loan Bank 1.125 07/14/2021 0.00 2,000,000.00 3130AABG2 1555 Federal Home Loan Bank 1.875 11/29/2021 0.00 2,000,000.00 313378JP7 1575 Federal Home Loan Bank 2.375 09/10/2021 0.00 2,000,000.00 3130AG3Y9 1588 Federal Home Loan Bank 2.420 02/15/2022 000 2,000,000.00 3130AN4T4 1637 Federal Home Loan Bank 0.875 07/08/2021 2,010,100.00 0.00 3134G9N94 1537 Federal Home Loan Mortgage 1.875 07/27/2021 0.00 2,000,000.00 3137EAEC9 1557 Federal Home Loan Mortgage 1.125 08/12/2021 0.00 2,000,000.00 3135G06G3 1658 Federal Nat'l Mortgage Assoc. 0.500 03/09/2022 953,700.00 0.00 Subtotal 2,963,800.00 16,000,000.00 Total 21,999,698.03 185,154,016.09 198,766,636.28 114,219,546.93 Portfolio ENCI Data Updated: SET _QTR: 05/02/2022 11:29 AC Run Date: 05/02/2022 - 11:29 PM (PRF_PM3) 7.3.0 City of Encinitas - Qtr Inv Report Portfolio Management Page 1 Interest Earnings Summary March 31, 2022 March 31Month Ending Fiscal Year To Date CD/Coupon/Discount Investments: Interest Collected 1,198,989.24 1,198,989.24 Plus Accrued Interest at End of Period 224,934.01 224,934.01 Less Accrued Interest at Beginning of Period ( 308,383.33) ( 308,383.33) Less Accrued Interest at Purchase During Period ( 106,577.27) ( 106,577.27) Interest Earned during Period 1,008,962.65 1,008,962.65 Adjusted by Premiums and Discounts 6,611.66 6,611.66 Adjusted by Capital Gains or Losses 0.00 000 Earnings during Periods 1,015,574.31 1,015,574.31 Pass Through Securities: Interest Collected 0.00 0.00 Plus Accrued Interest at End of Period 0.00 0.00 Less Accrued Interest at Beginning of Period ( 0.00) ( 0.00) Less Accrued Interest at Purchase During Period ( 0.00) ( 0.00) Interest Earned during Period 0.00 0.00 Adjusted by Premiums and Discounts 0.00 0.00 Adjusted by Capital Gains or Losses 0.00 0.00 Earnings during Periods 0.00 0.00 Cash/Checking Accounts: Interest Collected 61,362.89 61,362.89 Plus Accrued Interest at End of Period 17,156.84 17,156.84 Less Accrued Interest at Beginning of Period ( 37,452.19) ( 37,452.19) Interest Earned during Period 41,067.54 41,067.54 Total Interest Earned during Period 1,050,030.19 1,050,030.19 Total Adjustments from Premiums and Discounts 6,611.66 6,611.66 Total Capital Gains or Losses 0.00 0.00 Total Earnings during Period 1,056,641.85 1,056,641.85 Portfolio ENCI Data Updated: SET_QTR: 05/02/2022 11:29 AC Run Date. 05/02/2022 - 11:29 No fiscal year history available PM (PRF_PM6) 7.3.0 Report Ver. 7.3.6.1 _. CITY OF ENCINITAS 4City of Encinitas - Qtr Inv Report 505 S. VULCAN Encinitas, CA 92024 4'L Investments by Type r�y (760)633-2641 Active Investments March 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. Subtotal Local Agency Investment Funds SYS1012 1012 001 CA LAIF Subtotal Managed Pool Accounts SYS1003 1003 001 CA Asset Management Program SYS1584 1584 001 SD County Investment Pool Subtotal 7, 096, 478.91 100.0000000 7,096,478.91 18.251,600. 85 100.0000000 18,261,600.85 1,071,145.95 100.0000000 1,226,660.29 100.0000000 2,297,806.24 Money Market Funds SYS1004 1004 001 US BANK Subtotal 1,111,597.19 1,111,597.19 100.0000000 Certificates of Deposit - Bank 020080BUO 1619 001 ALMA BANK 249,000.00 100.0000000 02589AAM4 1580 001 American Express National Bank 245,000.00 100.0000000 06251AW48 1585 001 BANK HAPOALIM BM NY 246,000.00 100.0000000 06653ABM5 1533 001 BankVista 245,000.00 100.0000000 05580AMB7 1562 001 BMW Bank North America 246,000.00 100.0000000 14042RGN5 1552 001 Capital One NA 245,000.00 100.0000000 1404203Q1 1553 001 Capital One Bank USA, NA 245,000.00 100.0000000 17312QH69 1563 001 Citi Bank NA 246,000.00 100.0000000 200056QRZ8 1595 001 COMMERCE BANK GENEVA MN 249,000.00 100.0000000 203522AT4 1610 001 COMMUNITY BANK 249,000.00 100.0000000 20033AZK5 1571 001 Comenity Capital Bank 245,000.00 100.0000000 219255AK2 1623 001 CORNHUSKER BANK 249,000.00 100.0000000 15201QCJ4 1620 001 CENTERSTATE BANK NA 248,000.00 100.0000000 249398BT4 1596 001 Denver Savings Bank 249,000.00 100.0000000 7,096,478,91 7,096,478.91 18,251,600.85 0.262 18,251,600.85 1,071,145.95 0.050 1,226,66029 0.060 2,297,806.24 1,111,597.19 0.030 1,111,597.19 249,000.00 0.900 09/29/2023 245,000.00 3.300 06/26/2023 246,000.00 2.900 03/25/2024 245,000.00 2.000 06/30/2022 246,000.00 2.900 03/29/2023 245.000.00 2.300 07/19/2022 245.000.00 2.300 07/19/2022 246,000.00 2.850 03/29/2023 249,000.00 2.300 06/26/2024 249,000.00 1.650 11 /08/2024 245,000.00 3.300 06/29/2023 249,000.00 1.100 03/29/2024 248.000.00 1.000 03/31/2025 249.000.00 2,250 06/21/2023 Portfolio ENCI Data Updated: SET _QTR: 05/02/2022 11:29 AC Run Date: 05/02/2022 - 11:29 No fiscal year history available DT (PRF_DT) 7.1.1 Report Ver. 7 3 6.1 City of Encinitas - Qtr Inv Report Investments by Type Page 2 March 31, 2022 Purchase Current Maturity Call Call CUSIP Investment# Fund Issuer Par Value Price Remaining Cost Rate Date Date Price Certificates of Deposit - Bank 27002YEQ5 1594 001 EAGLEBANK 249,000 00 100.0000000 249,000.00 2.300 06/20/2024 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/2812024 33625CDV8 1629 001 1 ST SECURITY BK OF WASH 249,000.00 100.0000000 249,000.00 0.400 10/15/2025 33646CJP0 1569 001 First Source Bank 246,000 00 100.0000000 246,000.00 2.850 04/11/2023 38148PKX4 1528 001 Goldman Sachs Bank USA 245,000.00 100.0000000 245,000.00 2.350 06/21/2022 45581EAS0 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 654062JR0 1625 001 NICOLET NATIONAL BANK 249,000.00 100.0000000 249,000.00 1.150 03/28/2024 64034KAJ0 1651 001 NELNET BANK INC 248,000.00 100.0000000 248,000.00 1.450 02/02/2027 649447UZ0 1633 001 NEW YORK COMMUNITY BANK 249,000.00 100.0000000 249.000.00 0.700 0710112026 694231AD3 1621 001 PACIFIC ENTERPRISE BANK 249,000.00 100.0000000 249,000.00 1.150 03/31/2025 695292FP2 1613 001 PADUCAH BANK AND TRUST 249,000.00 100.0000000 249,000.00 1.650 11/08/2024 710673AC8 1624 001 PEOPLES BANK/SARDIS TN 249,000.00 100.0000000 249,000.00 1.000 0913012024 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 06128/2024 856285C41 1650 001 STATE BANK OF INDIA 248,000.00 100.0000000 248,000.00 1.400 01/13/2027 795450589 1570 001 Sallie Mae Bank/Murray 245,000.00 100.0000000 245,000.00 3.300 06/27/2023 87270LAD5 1554 001 TIAA FSB 245,000.00 100.0000000 245,000.00 2.150 07/19/2022 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 Portfolio ENCI Data Updated: SET _QTR: 05/02/2022 11:29 AC Run Date: 05/02/2022 - 11:29 No fiscal year history available DT (PRF_DT) 7.1.1 Report Ver. 7.3.6.1 City of Encinitas - Qtr Inv Report Investments by Type March 31, 2022 Page 3 Purchase Current Maturity Call Call CUSIP Investment # Fund Issuer Par Value price Remaining Cost Rate Date Date Price Certificates of Deposit - Bank 33744AAW9 1630 001 FIRST US BANK 249,000.00 100.0000000 249,000.00 0.400 11/18/2025 949763JG2 1535 001 Wells Fargo Bank 245,000.00 100.0000000 245,000.00 2250 06/30/2022 Negotiable CDs 15118RSNB 1614 001 CELTIC BANK 33767GAMO 1608 001 First Bank Puerto Rico Subtotal 13, 379,000.00 249, 000.00 100.0000000 249.000.00 100.0000000 Subtotal 498,000.00 13,379,000.00 249, 000.00 1.600 10/30/2023 249, 000.00 1.850 10/25/2024 498,000.00 U.S. Treasury Coupon Securities 91282BL24 1572 001 U.S. Treasury Notes 2,000,000.00 96,7187500 1,934,375.00 1.875 08/31/2022 912828XQ8 1578 001 U.S. Treasury Notes 4,000,000.00 97.2812500 3,891,250.00 2.000 07/31/2022 9128282W9 1579 001 U.S. Treasury Notes 2,000,000.00 96.6562500 1,933.125.00 1.875 09/30/2022 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 1250 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.5468750 975,468.75 0.750 11/15/2024 91282CCJ8 1654 001 U.S. Treasury Notes 1,000,000.00 96.3281250 963,281.25 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 91282CAT8 1657 001 U.S. Treasury Notes 1,000,000,00 94.6953130 946,953.13 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 57,000,000.00 56,411,171.89 Portfolio ENCI Data Updated: SET _QTR: 05/02/2022 11:29 AC Run Date: 05/02/2022 - 11:29 No fiscal year history available DT (PRF_DT) 7.1.1 Report Ver. 7.3.6.1 City of Encinitas - Qtr Inv Report Investments by Type March 31, 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 3133EHST1 1591 3133EHN25 1606 3133EC4Q4 1558 3133EJBP3 1590 3133EDWW8 1600 3133EKSN7 1605 3130AEB M 1 1573 3130AN4T4 1637 3135GOT78 1589 3135GOU43 1602 3135GOT78 1603 3135GO6G3 1658 001 FEDERAL FARM CREDIT BANK 1,000,000.00 99.0790000 990,790.00 2010 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 96.1000000 1,922,000.00 1.820 11/23/2022 001 Federal Farm Credit 2,000,000.00 101.0625000 2,021,250.00 2.500 02/02/2023 001 Federal Farm Credit 1,000,000.00 102.5860000 1,025,860 00 2.600 10/06/2022 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 99.8847000 1,997,694.00 2.750 06/10/2022 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 99.3590000 1,987,180.00 2.000 10/05/2022 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 100.8231000 1,008,231.00 2,000 10/05/2022 001 Federal Nat'l Mortgage Assoc. 1,000,000.00 95.3700000 953,700.00 0.500 11/07/2025 Subtotal 22,000,000.00 22,031,733.00 Total 121,634,483.19 121,077,388.08 Portfolio ENCI Data Updated: SET _QTR: 05/02/2022 11:29 AC Run Date: 05/02/2022 - 11:29 No fiscal year history available DT (PRF_DT) 7.1.1 Report Ver 7.3.6.1 CITY OF ENCINITAS City of Encinitas - Qtr Inv Report 505 S. VULCAN Interest Earnings Encinitas, CA 92024 (760)633-2641 Sorted by Fund - Fund July 1, 2021 - March 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 18.251,600.85 37,934,591.21 18,251,600.85 0.365 0.095 27,061.02 0.00 27,061.02 SYS1584 1584 001 COUNTY 1,226,660.29 4.208,416.00 1,226,660.29 0.170 0.409 12,930.46 0.00 12,930.46 SYS1003 1003 001 CAMP 1,071,145.95 1,070,729.90 1,071,145.95 0.250 0.075 601.85 0.00 601.85 SYS1004 1004 001 UBCUST 1,111,597.19 19,380,189.54 1,111,597.19 0.150 0.003 474.21 0.00 474.21 SYS1010 1010 001 UBCKG 7,096,478.91 5,038,148.62 7,096,478.91 0.00 0.00 0.00 3130AG3Y9 1588 001 FHLB 0.00 2,002,343.58 0.00 02/15/2022 2.420 2.211 30,115.56 -2,343.58 27,771.98 3130AABG2 1555 001 FHLB 0-00 1,994,967.35 0.00 11/29/2021 1.875 2.478 15,416.67 5,032.65 20,449.32 3130AEBM1 1573 001 FHLB 2,000,000.00 1,999,451.03 1.999,888.26 06/10/2022 2.750 2.777 41,250.00 43723 41,687.23 3130AN4T4 1637 001 FHLB 2,000,000.00 0.00 2,008,602.65 06/12/2026 0.875 0.768 12,784.72 -1,497.35 11,287.37 313OA8QS5 1524 001 FHLB 0.00 1,999,540.14 0.00 07/14/2021 1.125 1.787 812.50 459.86 1,272.36 313378JP7 1575 001 FHLB 0.00 1,998,811.81 0.00 09/10/2021 2.375 2.647 9,104.17 1,188.19 10.292.36 3135GOT78 1603 001 FNMA 1,000.000.00 1,003,169.53 1,001,284.57 10/05/2022 2.000 1.742 15,000.00 -1.884.96 13,115.04 3135GOT78 1589 001 FNMA 2,000,000.00 1,995,409.87 1,998.139.68 10/05/2022 2.000 2.185 30,000.00 2,729.81 32,729.81 3135GOU43 1602 001 FNMA 2,000,000.00 2,045,237.27 2,029.795.98 09/12/2023 2.875 1.803 43,125.00 -15,441.29 27,683.71 3135GO6G3 1658 001 FNMA 1,000,000.00 0.00 956,167.28 11/07/2025 0.500 1.794 305.56 772.84 1,078.40 3137EAEC9 1557 001 FHLMC 0.00 1,997.032.37 0.00 08/12/2021 1.125 2,407 2,562.50 2,967.63 5,530.13 3134G9N94 1537 001 FHLMC 0.00 2.000,228.99 0.00 07/27/2021 1.875 1.740 2,708.33 -228.99 2,479.34 3133EJBP3 1590 001 FFCRED 2,000,000.00 2,008,760.83 2,004,618.23 02/02/2023 2.500 2212 37,500.00 -4,142.60 33,357.40 3133EHCT8 1536 001 FFCRED 0.00 2,004,369.64 0.00 03/15/2022 2.150 1.840 30,338.89 -4,369.64 25,969.25 3133EDWW8 1600 001 FFCRED 1,000,000.00 1,009,971.44 1,004,054.32 10/06/2022 2.600 1,792 19,500.00 -5,917.12 13,582.88 3133EC4Q4 1558 001 FFCRED 2,000,000.00 1,977,101.75 1,989,417.54 11/23/2022 1820 2.669 27,300.00 12,315.79 39,615.79 3133EKSN7 1605 001 FFCRED 4,000,000.00 3,997,710.01 3,998,574.76 06/26/2023 1.770 1.798 53,100.00 864.75 53,964.75 91282CAP6 1636 001 UST 2,000,000.00 0.00 1,996,186,67 10/15/2023 0.125 0.250 1,830.08 1,811.67 3,641.75 91282CBM2 1638 001 UST 2,000,000.00 0.00 1,993,422.98 02/15/2024 0.125 0.301 1,823.20 2,563.60 4,386.80 91282CBT7 1635 001 UST 2,000,000.00 0.00 2,001,056.75 03/31/2026 0.750 0.737 10,983.60 -193.25 10,790.35 912828Y87 1634 001 UST 6,000,000.00 0.00 6,188,445.04 07/31/2024 1,750 0.383 76,574.58 -59,054.96 17,519.62 912828ZW3 1645 001 UST 2,000,000.00 0.00 1,977,553.34 06/30/2025 0.250 0.603 3,648.21 5,053.34 8,701.55 91282CBQ3 1639 001 UST 2,000,000.00 0.00 1,983,082.76 02/28/2026 0.500 0.725 7,336.96 3,160.88 10,497.84 91282CCG4 1656 001 UST 2,000,000.00 0.00 1,941,755.10 06/15/2024 0.250 1.646 315.93 1,695.00 2,010.93 91282CBR1 1655 001 UST 1,000,000.00 0.00 974,569.20 03/15/2024 0.250 1.591 156.93 819.20 976.13 Portfolio ENCI Data Updated: SET _QTR: 05/02/2022 11:29 AC Run Date: 05/02/2022 - 11:29 No fiscal year history available IE (PRF_IE) 7.2.0 Report Ver. 7.3.6.1 C] (JI O A N w W O W W O V W (D (D (O W W W W 0 W (O W W W W W W W W W T 0 D) O 0 V w V A V A w V w W A O 0 w > V A w w O V O O N N N N N N N N N N N N N N N NC C O) N O (D N U) N N N N V A w O V A O V (n V A w A W w A w w w w w w w w w w w w w w w w w w w CO 7 W V N A O N o/ W O w V N W O N N N N N N N N N N N N N N N N N N N N N a m D D W O (On - m D 7Tc D W N y (w/1 X nCwCi rw- -wl N N D D D N 0 N n D n o-a A A O Z m x �> W D C A m A p w V (wO N (w0 w A N O V V= V O o V w w A N w (O V w w w O \ CD N O. O (n N m -i O) N O) N w O) N O) Dt (J) Ot N N N w w T W W W w w w w w m w A A A A A A N N N � Zf M W W W 0 w N w Q7 w w w w w w W W W N O N - w V N V V V V m COw O M N j w Ut A W A N (J) W O w w W N O W A w (D N w N A w O W A N W V N A V (O 3 A N O � N 7 O N � N O N N o 0 0 0 0 0 0 0 0 0 0 o O 0 0 0 0 0 0 O o O O o O o O O O O 0 O O O O 0 0 O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O T C N 7 a C C C C C C C C C C C C H O O m D D Z T _.{ (n D O M M M (n W W 0 M M W W W W 0 W W M 0 W M c co �' � w z ZT. Z z m m > - Z m Z z D� 71 m< A Z A N N W N N w N N N N A N N N N N N N N N N N N N N N O O o o o o o o O O O O O o 0 o O d A A A A A A A A A A A A A A A O 0 O O O O O O O O O O O O O O 0 w w w O O O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 m w (D (O U) Vt O) um Vt w w N w o 0 0 0 0 0 0 0 0 o G= 0 o 0 o O o 0 0 0 0 0 0 0 0 o O o o 0 0 O O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o O o 0 0 0 0 0 0 0 d y O O o 0 0 0 0 0 0 0 0 0 o O o O o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o O o 0 0 o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 c 4VU2 0 o O o O o 0 o O O o 0 o O O o 0 0 0 0 0 o O o o O o 0 0 0 0 o O o 0 0 0 0 L - Z > > > > > > W N C l< 0 0 N N N N N N N N N N N N N N N N N N N w (D 10 (D (D W W A A A A A A A A A A A A A A A A A w m w w 0 A w O) w (O w (O w (!( N N N N N w N N w N w (!( O W A N O W (D _ ' m N 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 w N w W V N 0 x (O2. N 7 0 O o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o w w w (O M V w O O O O O O O O O O O O O O O O O N (O N A N O V (O 0 0 0 0 0 0 0 0 0 0 0 0 G N O CD =� CD O o 0 0 0 0 0 0 0 0 0 0 0 0 0 o 0 A w w N o > w 0 0 0 0 0 0 0 o O O o 0 C ..� O O O O O O O O O O O O O O O O O W W W w A V w > O O 0 0 0 0 O O O O O O D (C y N g m °1 o d D) 7 3 N' i (0 W>> N> N N>> N N > W N G v N N N N N N N N N N N N N N N (O (O (D to (D o to iO w o o (D o (O (n w m W C N C W A A A A A A 4. A A A A AAW N V V W [n V NM w A 0 w w N A O w A N A N w w A U) w (O CD w (O (O Ut U) N Vt U) (O Ut ut Q7 O) W (O P0 CN m .0 0 0 0 0 0 0 0 0 0 O O O O O O N > A w W w > O N N (O A V W A V w O O O O O w w W O O N N 0 M w Jw G 0O j N O OO O Vw O O (O A N w A 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 w 0 (D w V ON O> O w A A C O O O O O O O O O O O O O O O O O O O A M W - V V A w w w w 0 > N w N 0 (O w w 0 3 (D (O O O 0 O O O O O O O O O O O O O O O O O O O O O O O O O O O O _ W W W W W" N w w N w 0w � � W w0(O w � (O T- \o \ w (O N (O O W w 0 \ N N N N N>> o w w w N N> N N N W w !� w N w w w w w w (D (O (O ((O (O W O O O> N O w w V O O C, w O O SE! w y N N N N N N N N N N N N" N N N N N N N N N N N N N N N N N N NN N N N N N N O O O O O O O O O O O O O O O O O O O O O 0 O O O O O O O O O O O O O O o N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N W W W W W N N N N N > N A N W W W > n C w w (O w w W O N O w W m W W (D W> O O w w> N (J N N N N> in V (J) N w N w 0 0 0 N O w O O w O O w 0 O O o 0 N 0 0 V V N (J) V O) U ( w N O 0 O O V U) N W (p 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 w O O N w N O 0 O O O O N 0 0 0 0 0 0 (!( a _ _ _ N N N N N N N N N N N N W N W N N N N N N O O O O O O O C w fD to m W W o N o 6 W OJ W W fD W J M D) M 01 A �4 X. 01 M M N A V A V ao 47 N N 0 0 0 N O (T 0 0 N O O w w O O O O w 0 V w w w j !� N N A m W N > 0 j 0 0 W 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 w V V V W A O w N 0 w 0 0 O w � N (p a o. MNM N N N_ _ _ w 0 W W w O W A N A (D N (D w W W A N o W O w N w N T O T W W w w N (D A (O W N (n _ m V w N w N (n W> W V N (n W w w w O) w w V N (O V (O A W w w O w V W> N (n > O N O W O A O W w w N w 0 (O N (D A O (O w w A W (D N (O w w V w N Ut w W (O d W V W V O V N > > W > 0 0 N W N w w N N WN N V W N A N > N N w w Mw W A > w > N O A > W N A W V w > w w w A V O W 0 w O N 0 W w 0 Ut N N A 0 A A A G r a+a a 3111W 0 > > > A f0 w (O N N w N w w N V N N 7 O> (O V V w O> N A (J) Ot V O w 0> M N W W W w V A O O A Co O) N w w V V W W w 0 0 V O w w w w N A N N A w V) A w w w C p 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 N 0 0 0 0 0 0 0 0 C 0 0 0 0 0 0 0 0 M A w w w 0 V O V U (J) N A (J) w 0 W> » > O O O O O O O O O O O O O O O O O V V > N A W w Am N O > W W w m w V A m D a M o a 0 � N to N T �- o > V W A> A N N m CL w V m N N N (!) Ut (J A N A W N A W A O) (JI O) N V (D (D O N V (T w V (O (D V w> W>>> A D) � W V Z D W A N A tD N (D > O) W W A N O W O (O W w f0 O N w w N> N w w A O A O O O N V 0 N w N N W W V N U) W M 0 w 0 (O O A O A w 0 W� W w w 0 Ut w V O �� (D O) N > Ci j O U) O W O A O W w w N w 0 (D w (O N V A N A N N w O V) (O w -+ N A N j N W O V N >> W> 0 0 N W N N W w w A O N A W (O (D - w V O w (D A w A (D ut O A> W N 4 W V w> w CO WA 0 A W W w V (J) w N (O w w V (D W (O w» City of Encinitas - Qtr Inv Report Interest Earnings Page 3 July 1, 2021 - March 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 29278TAU4 1568 001 ENERBK 246,000.00 246,000.00 246,000.00 03/29/2023 2.850 2.850 5,263.05 0.00 5,263.05 33646CJPO 1569 001 FSRCBK 246,000.00 246,000.00 246,000.00 04/11/2023 2.850 2.850 5,263.06 0.00 5,263.06 02589AAM4 1580 001 AMEXNL 245.000.00 245,000.00 245,000.00 06/26/2023 3.300 3.300 6,069.29 0.00 6,069.29 06251AW48 1585 001 BKHAPO 246,000.00 246,000.00 246,000.00 03/25/2024 2.900 2.900 5,355.39 0.00 5,355.39 3133EKNM4 1601 001 FFCB 0.00 2.005,637.74 0.00 02/28/2022 2.200 1.754 28.966.67 -5,637.74 23,328.93 3133EHN25 1606 001 FFCB 2,000,000.00 2,017,626.58 2,011.960.89 11/01/2023 2.200 1.505 33,000.00 -5,665.69 27,334.31 3133EHST1 1591 001 FFCB 1,000,000.00 995,598.81 997,193.87 07/26/2023 2.010 2.230 15,075.00 1,595.06 16.670.06 27002YEQ5 1594 001 EGLEBK 249,000.00 249,000.00 249,000.00 06/20/2024 2.300 2,300 4,299.15 0.00 4,299.15 200056QRZ8 1595 001 CMBKGN 249,000.00 249,000.00 249,000.00 06/26/2024 2.300 2.300 4,299.15 0.00 4,299.15 61760AG52 1593 001 MGSTPB 246,000.00 246,000.00 246,000.00 06/13/2024 2.600 2.600 4,801.38 0.00 4,801.38 249398BT4 1596 001 DENSVB 249,000.00 249,000.00 249,000.00 06/21/2023 2.250 2,250 4,205.72 0.00 4.205.72 59013KAR7 1597 001 MERRBK 249,000.00 249,000.00 249,000.00 12/28/2023 2,400 2.400 4,486.09 0.00 4,486.09 336460CQ1 1598 001 FSBDQ 249,000.00 249,000.00 249.000.00 06/28/2024 2.300 2.300 4.299.15 0.00 4,299.15 761400BY1 1599 001 RVBANK 247,000.00 247,000,00 247,000.00 06/28/2024 2.300 2.300 4,264.64 0.00 4,264.64 15118RSN8 1614 001 CELTIC 249,000.00 249,000.00 249,000.00 10/30/2023 1.600 1.600 2,990.74 0.00 2,990.74 29367SJ08 1607 001 ENTERB 249,000.00 249,000.00 249,000.00 11/08/2024 1-800 1.800 3,36C54 0.00 3,364.54 33640VDE5 1609 001 FIRSTS 249,000.00 249,000.00 249,000.00 11/15/2023 1.700 1.700 3,177.68 0.00 3,177.68 203522AT4 1610 001 COMMBK 249,000.00 249,000.00 249,000.00 11/08/2024 1.650 1.650 3,084.17 0.00 3,084.17 73319FAD1 1611 001 POPBK 249,000.00 249,000.00 249,000.00 11/04/2024 1.650 1.650 3,084.17 0.00 3,084.17 89579NCB7 1612 001 TRIADB 249.000.00 249,000.00 249,000.00 11/08/2024 1.800 1.800 3,364.54 0.00 3,364.54 695292FP2 1613 001 PADUCA 249,000.00 249,000,00 249,000.00 11/08/2024 1.650 1.650 3,084.17 0.00 3,084.17 300185JF3 1615 001 EVRGRN 249,000.00 249,000.00 249,000.00 03/26/2025 1.000 1,000 1,869.21 0.00 1,869.21 34969RCS5 1616 001 FORTUB 249,000.00 249,000.00 249,000.00 03/27/2024 1,000 1.000 1,869.21 0.00 1,869.21 59565QCS2 1617 001 MIDCBK 249,000.00 249,000.00 249,000.00 03/27/2025 1.000 1.000 1,869.21 0.00 1,869.21 52465JHT7 1618 001 LEGEND 249,000.00 249,000.00 249,000.00 09/30/2024 1.000 1.000 1,869.22 0.00 1,869.22 020080BUO 1619 001 ALMABK 249,000.00 249,000.00 249,000.00 09/29/2023 0.900 0.900 1,682.27 0.00 1,68227 15201QCJ4 1620 001 CTRSTE 248,000.00 248,000.00 248,000.00 03/31/2025 1.000 1.000 1,861.70 0.00 1,861.70 694231AD3 1621 001 PACENT 249,000.00 249,000.00 249,000.00 03/31/2025 1.150 1.150 2,149.60 0.00 2,149.60 538036KU7 1622 001 LIVOAK 249,000.00 249,000.00 249,000.00 03/31/2025 1.100 1.100 2.056,14 0.00 2,056.14 219255AK2 1623 001 CRNHSK 249,000.00 249,000.00 249,000.00 03/29/2024 1.100 1.100 2.056.12 0.00 2,056.12 710673AC8 1624 001 PEBATN 249,000.00 249,000.00 249,000.00 09/30/2024 1.000 1.000 1.869.22 0.00 1,869.22 654062JRO 1625 001 NCBS 249.000.00 249,000.00 249,000.00 03/28/2024 1.150 1.150 2,149.60 0.00 2,149.60 549104SS7 1627 001 LUANSB 249,000.00 249,000.00 249,000.00 10/02/2025 0.400 0.400 747.68 0.00 747.68 33847E4E4 1626 001 FLGSB 249,000.00 249,000.00 249,000.00 09/30/2024 0,400 0.400 747.69 0.00 747.69 51507LBZ6 1628 001 LDMCB 249,000.00 249,000.00 249,000.00 10/29/2025 0.400 0.400 747.66 0.00 747.66 33625CDV8 1629 001 FSECWA 249,000.00 249,000.00 249,000.00 10/15/2025 0.400 0.400 747.67 0.00 747.67 33744AAW9 1630 001 USBI 249.000.00 249,000.00 249,000.00 11/18/2025 0.400 0.400 747.67 0.00 747.67 Portfolio ENCI Data Updated: SET _QTR: 05/02/2022 11:29 AC Run Date: 05/02/2022 - 11:29 No fiscal year history available IE (PRF_IE) 7.2.0 Report Ver. 7.3.6.1 City of Encinitas - Qtr Inv Report Interest Earnings July 1, 2021 - March 31, 2022 Adjusted Interest Earnings Page 4 Ending Beginning Ending Maturity Current Annualized Interest Amortization/ Adjusted Interest CUSIP Investment # Fund Issuer Par Value Book Value Book Value Date Rate Yield Earned Accretion Earnings Fund: General Investments 50116CCP2 1631 001 KANBNK 249,000.00 249,000.00 249,000.00 11/28/2025 0.450 0.450 841.18 0.00 84118 90348JN48 1632 001 UBS 249,00000 249.000.00 249,000.00 06/23/2026 0.750 0.750 1,401.90 0.00 1,401.90 649447UZ0 1633 001 NYCB 249,000.00 249,000.00 249,000.00 07/01/2026 0,700 0.700 1,308.44 0.00 1,308A4 39573LCE6 1648 001 UNIICC 248.000.00 0.00 248,000.00 01/14/2027 1.350 1.350 697.12 0.00 697.12 89235MMP3 1649 001 TOYFBN 248,000.00 0.00 248,000.00 01/13/2027 1.350 1.350 715.46 0.00 715.46 856285C41 1650 001 SBIIN 248,000.00 0.00 248,000.00 01/13/2027 1.400 1.400 741.96 0.00 74196 64034KAJ0 1651 001 NELNTB 248,000.00 0.00 248,000.00 02/02/2027 1.450 1.450 571.42 0.00 571.42 Subtotal 121,634,483.19 134,911,665.36 121,316,025.84 0.893 1,050,030.19 6,611.66 1,056,641.85 Total 121,634,483.19 134,911,665.36 121,316,025.84 0.893 1,050,030.19 6,611.66 1,056,641.85 Portfolio ENCI Data Updated: SET _QTR: 05/02/2022 11:29 AC Run Date: 05/02/2022 - 11,29 No fiscal year history available IE (PRF_IE) 7.2.0 Report Ver. 7.3.6.1 CITY OF ENCINITAS505 - City of Encinitas - Qtr Inv Report S. VULCAN Investments by Issuer Encinitas, CA 92024 (760)633-2641 Active Investments Sorted by Fund March 31, 2022 Investment Current Market YTM Redemption Days To Call CUSIP Investment# Security Type Class Remaining Cost Rat, Market Value oat¢ 365 Date AAahfrtty Darr_ Collateral ALMA BANK 020080BU0 1619 Certificates of Deposit - Bank Amort 249,000.00 0.900 246,016.98 03/31/2022 0.900 09/29/2023 546 Subtotal and Average 249,000.00 246,016.98 0.900 546 American Express National Bank 02589AAM4 1580 Certificates of Deposit - Bank Amort 245.000.00 3.300 250,412.05 03/31/2022 3.300 06/26/2023 451 Subtotal and Average 245,000.00 250,412.05 3.300 451 BANK HAPOALIM BM NY 06251AW48 1585 Certificates of Deposit - Bank Amort 246,000.00 2.900 249,768.72 03/31/2022 2.900 03/25/2024 724 Subtotal and Average 246,000.00 249,768.72 2.900 724 BankVista 06653ABM5 1533 Certificates of Deposit - Bank Amort 245,000.00 2.000 245,945.70 03/31/2022 2.000 06/30/2022 90 Subtotal and Average 245,000.00 245,945.70 2.000 90 BMW Bank North America 05580AMB7 1562 Certificates of Deposit - Bank Amort Subtotal and Average CA Asset Management Program SYS1003 1003 Capital One NA 14042RGN5 1552 Capital One Bank USA, NA 1404203Q1 1553 Managed Pool Accounts Amort Subtotal and Average Certificates of Deposit - Bank Amort Subtotal and Average Certificates of Deposit - Bank Amort Subtotal and Average Data Updated: SET_QTR: 05/02/2022 11:29 Run Dale: 05/02/2022 - 11:29 246.000.00 2.900 246,000.00 1,071,145.95 0.050 1,071,145.95 245,000.00 2.300 245,000.00 245,000.00 2.300 245,000.00 No fiscal year history available 249,938.46 03/31/2022 2.900 03/29/2023 362 249,938.46 2.900 362 1,071,145.95 09/30/2021 0.050 1 1,071,145.95 0.050 1 246,313.20 03/31/2022 2.300 07/19/2022 109 246.313.20 2.300 109 246,313.20 03/31/2022 2.300 07/19/2022 109 246,313.20 2.300 109 Portfolio ENCI AC DI (PRF_DI) 7.1.1 Report Ver. 7 3.6.1 City of Encinitas - Qtr Inv Report Investments by Issuer Page 2 Sorted by Fund Investment Current Market YTM Redemption Days To Call CUSIP Investment# Security Tvpe Class Remaining Cost Rate Market Value Hate 365 ❑ateMaturity ')ate Collateral CELTIC BANK 15118RSN8 1614 Negotiable CDs Amort 249,000.00 1.600 248,295.33 03/31/2022 1.601 10/30/2023 577 Subtotal and Average 249,000.00 248,295.33 1.601 577 Citi Bank NA 17312QH69 1563 Certificates of Deposit - Bank Amort 246,000.00 2.850 249,815.46 03/31/2022 2.850 03/29/2023 362 Subtotal and Average 246,000.00 249,815.46 2.850 362 COMMERCE BANK GENEVA MN 200056QRZ8 1595 Certificates of Deposit - Bank Amort 249,000.00 2.300 249,400.89 03/31/2022 2.300 06126/2024 817 Subtotal and Average 249,000.00 249,400.89 2.300 817 COMMUNITY BANK 203522AT4 1610 Certificates of Deposit - Bank Amort 249,000.00 1.650 244,395.99 03/31/2022 1.650 11/08/2024 952 Subtotal and Average 249,000.00 244,395.99 1.650 952 Comenity Capital Bank 20033AZK5 1571 Certificates of Deposit - Bank Amort 245,000.00 3.300 250,436.55 03/31/2022 3.300 06/29/2023 454 Subtotal and Average 245,000.00 250,436.55 3.300 454 SD County Investment Pool SYS1584 1584 Managed Pool Accounts Amort 1,226,660.29 0.060 1,226,660.29 08/31/2021 0,060 1 Subtotal and Average 1,226,660.29 1,226,660.29 0.060 1 CORNHUSKER BANK 219255AK2 1623 Certificates of Deposit - Bank Amort 249,000.00 1.100 244,042.41 03/31/2022 1.100 03/29/2024 728 Subtotal and Average 249,000.00 244,042.41 1.100 728 CENTERSTATE BANK NA 15201QCJ4 1620 Certificates of Deposit - Bank Amort 248,000.00 1.000 236,936.72 03/31/2022 1.000 03/31/2025 1,095 Subtotal and Average 248,000.00 236,936.72 1.000 1,095 Denver Savings Bank 249398BT4 1596 Certificates of Deposit - Bank Amort 249,000.00 2.250 251,310.72 03/31/2022 2.250 06/21/2023 446 Subtotal and Average 249,000.00 251,310.72 2.250 446 Portfolio ENCI Data Updated: SET _QTR: 05/02/2022 11:29 AC Run Date: 05/0212022 - 11:29 No fiscal year history available DI (PRF_DI) 7.1.1 Report Ver. 7.3.6.1 City of Encinitas - Qtr Inv Report Investments by Issuer Page 3 Sorted by Fund Investment Current Market YTM Redemption Days To Call CUSIP Investment# Security Type Class Remaining Cost Rato Market Value nt.Collateral EAGLEBANK 27002YEQ5 1594 Certificates of Deposit - Bank Amort 249.000.00 2.300 249,435.75 03/31/2022 2.300 06/20/2024 811 Subtotal and Average 249,000.00 249,435.75 2.300 811 Enerbank USA 29278TAU4 1568 Certificates of Deposit - Bank Amort 246.000.00 2.850 249,815.46 03/31/2022 2.850 03/29/2023 362 Subtotal and Average 246,000.00 249,815.46 2.850 362 ENTERPRISE BANK AND TRUST 29367SJQ8 1607 EVERGREEN BANK GROUP 300185JF3 1615 First Bank Puerto Rico 33767GAMO 1608 FEDERAL FARM CREDIT BANK 3133EHST1 1591 3133EHN25 1606 Federal Farm Credit 3133EC4Q4 1558 3133EJBP3 1590 3133EDWWB 1600 3133EKSN7 1605 Federal Home Loan Bank 3130AEBM1 1573 3130AN4T4 1637 Certificates of Deposit - Bank Amort Subtotal and Average Certificates of Deposit - Bank Amort Subtotal and Average Negotiable CDs Amort Subtotal and Average Federal Agency Coupon Securities Amort Federal Agency Coupon Securities Amort Subtotal and Average Federal Agency Coupon Securities Fair Federal Agency Coupon Securities Amort Federal Agency Coupon Securities Amort Federal Agency Coupon Securities Amort Subtotal and Average Federal Agency Coupon Securities Fair Federal Agency Coupon Securities Amort Subtotal and Average Data Updated: SET _QTR: 05/02/2022 11:29 Run Date: 05/02/2022 - 11:29 249, 000.00 1,800 249,000.00 249,000.00 1.000 249,000.00 249.000.00 1.850 249,000.00 990,790.00 2.010 2,032,840.00 2.200 3,023,630.00 1, 922, 000.00 1.820 2,021,250.00 2.500 1,025,860.00 2.600 3.995,388.00 1.770 8,964,498.00 1,997,694.00 2.750 2,010,100.00 0.875 4,007,794.00 No fiscal year history available 245,337.21 03/31/2022 1.800 11/08/2024 952 245,337.21 1.800 952 237.944.40 03/31/2022 1.000 03/26/2025 1,090 237,944.40 1.000 1,090 245.797.86 03/31/2022 1,852 10/25/2024 938 245.797.86 1.852 938 1.000,300.00 03/31/2022 2.234 07/26/2023 481 2,004,240.00 03/31/2022 1.805 11/01/2023 579 3,004,540.00 1.938 543 2,007,220.00 03/31/2022 2.700 11/23/2022 236 2,015,980.00 03/31/2022 2.210 02/02/2023 307 1,007,660.00 03/31/2022 1.784 10/06/2022 188 3.990,640.00 03/31/2022 1.800 06/26/2023 451 9,021,500.00 2.096 343 2,009,100.00 03/31/2022 2,780 06/10/2022 70 1,868,440.00 03/31/2022 0.770 06/12/2026 1,533 3,877,540.00 1.773 803 Portfolio ENCI AC DI (PRF_DI) T1.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 tY Y Remaining Cost Ra F Market Value Dais -- 365 o,�� na�r��r�±u o�r� Collateral FIRST SERVICE BANK 33640VDE5 1609 Certificates of Deposit - Bank Amort 249.000.00 1.700 248,531.88 03/31/2022 1.700 11/15/2023 593 Subtotal and Average 249,000.00 248,531.88 1.700 593 FLAGSTAR BANK FSB 33847E4E4 1626 Certificates of Deposit - Bank Amort 249,000.00 0.400 237,311.94 03/31/2022 0.400 09/30/2024 913 Subtotal and Average 249,000.00 237,311.94 0.400 913 Federal Nat'l Mortgage Assoc. 3135GOT78 1589 Federal Agency Coupon Securities Amort 1,987,180.00 2.000 2,008,480.00 03/31/2022 2.190 10/05/2022 187 3135GOU43 1602 Federal Agency Coupon Securities Amort 2,086,700.00 2.875 2,020,280.00 03/31/2022 1.801 09/12/2023 529 3135GOT78 1603 Federal Agency Coupon Securities Amort 1,008,231.00 2.000 1,004,240,00 03/31/2022 1.740 10/05/2022 187 3135G06G3 1658 Federal Agency Coupon Securities Amort 953,700.00 0.500 932,674.44 03/31/2022 1.813 11/07/2025 1,316 Subtotal and Average 6,035,811.00 5,965,674.44 1.906 479 FORTUNE BANK ARNOLD 34969RCS5 1616 Certificates of Deposit - Bank Amort 249.000.00 1.000 243,584.25 03/31/2022 1.000 03/27/2024 726 Subtotal and Average 249,000.00 243,584.25 1.000 726 First State Bank Dequeen 336460CQ1 1598 Certificates of Deposit - Bank Amort 249,000 00 2.300 249,390.93 03/31/2022 2.300 06/28/2024 819 Subtotal and Average 249,000.00 249,390.93 2.300 819 1ST SECURITY BK OF WASH 33625CDV8 1629 Certificates of Deposit - Bank Amort 249,000.00 0.400 230,668.62 03/31/2022 0.400 10/15/2025 1,293 Subtotal and Average 249,000.00 230,668.62 0.400 1,293 First Source Bank 33646CJP0 1569 Certificates of Deposit - Bank Amort 246 000 00 2 850 249 827 76 03/31/2022 2 850 04/11/2023 375 Goldman Sachs Bank USA 38148PKX4 1528 Industrial & Comm Bank China Subtotal and Average Certificates of Deposit - Bank Amort Subtotal and Average 246,000.00 245,000.00 2.350 245,000.00 249,827.76 2.850 375 246,058.40 03/31/2022 2.350 06/21/2022 81 246,058.40 2.350 81 Portfolio ENCI Data Updated: SET _QTR: 05/02/2022 11:29 AC Run Dale: 05/02/2022 - 11,29 No fiscal year history available DI (PRF_DI) 7.1.1 Report Ver. 7.3.6.1 City of Encinitas - Qtr Inv Report Investments by Issuer Page 5 Sorted by Fund Investment Current Market YTM Redemption Days To Call CUSIP Investment # Security Type Class Remaining Cost Rare Market Value Mtn 365 r]at Mwrnriry nare Collateral 45581EAS0 1564 Certificates of Deposit - Bank Amort 249.000.00 2.900 252,964.08 03/31/2022 2.900 03/29/2023 362 Subtotal and Average 249,000.00 252,964.08 2.900 362 KS STATEBANK 50116CCP2 1631 Certificates of Deposit- Bank Amort 249.000.00 0.450 230,464.44 03/31/2022 0.450 11/28/2025 1,337 Subtotal and Average 249,000.00 230,464.44 0.450 1,337 CA LAIF SYS1012 1012 Local Agency Investment Funds Amort 18,251,600.85 0.262 18,251,600.85 07/31/2021 0.262 1 Subtotal and Average 18,251,600.85 18,251,600.85 0.262 1 LCA Bank Corp 501798LT7 1566 Certificates of Deposit - Bank Amort 246,000.00 2.800 249.692.46 03/31/2022 2.800 03/29/2023 362 Subtotal and Average 246,000.00 249,692.46 2.800 362 LANDMARK COMMUNITY BANK 51507LBZ6 1628 Certificates of Deposit - Bank Amort 249,000.00 0.400 230,461.95 03/31/2022 0.400 10/29/2025 1,307 Subtotal and Average 249,000.00 230,461.95 0.400 1,307 LEGENDS BANK 52465JHT7 1618 Certificates of Deposit - Bank Amort 249.000.00 1.000 240.919.95 03/31/2022 1.000 09/30/2024 913 Subtotal and Average 249,000.00 240,919.95 1.000 913 LIVE OAK BANKING COMPANY 538036KU7 1622 Certificates of Deposit - Bank Amort 249,000.00 1.100 238,574.37 03/31/2022 1.100 03/31/2025 1,095 Subtotal and Average 249,000.00 238,574.37 1.100 1,095 LUANA SAVINGS BANK 549104SS7 1627 Certificates of Deposit - Bank Amort 249,000.00 0.400 230,954.97 03/31/2022 0.400 10/02/2025 1,280 Subtotal and Average 249,000.00 230,954.97 0.400 1,280 Medallion Bank UT 58404DBL4 1561 Certificates of Deposit - Bank Amort 249,000.00 2.900 252,961.59 03/31/2022 2.900 03/28/2023 361 Subtotal and Average 249,000.00 252,961.59 2.900 361 Merrick Bank Portfolio ENCI Data Updated: SET _QTR: 05/02/2022 11:29 AC Run Date, 05/02/2022 - 11:29 No fiscal year history available DI (PRF_DI) 7.1.1 Report Ver. 7.3.6.1 City of Encinitas - Qtr Inv Report Investments by Issuer Page 6 Sorted by Fund Investment Current Market YTM Redemption Days To Call CUSIP Investment# Security Type Class Remaining Cost Ratp Market Value ❑.tr 365 Qat.M.turity Date Collateral 59013KAR7 1597 Certificates of Deposit - Bank Amort 249,000.00 2.400 251,071.68 03/31/2022 2.400 12/28/2023 636 Subtotal and Average 249,000.00 251,071.68 2.400 636 MORGAN STANLEY PRIVATE BANK 61760AG52 1593 Certificates of Deposit - Bank Amort 246,000.00 2.600 248,04426 03/31/2022 2.600 06/13/2024 804 Subtotal and Average 246,000.00 248,044.26 2.600 804 MIDCOUNTRY BANK 595650CS2 1617 Certificates of Deposit - Bank Amort 249,000.00 1.000 237,926.97 03/31/2022 1.000 03/27/2025 1.091 Subtotal and Average 249,000.00 237,926.97 1.000 1,091 Morgan Stanley Bank 61747MR37 1565 Certificates of Deposit - Bank Amort 246,000.00 2.900 249.938.46 03/31/2022 2.900 03/29/2023 362 Subtotal and Average 246,000.00 249,938.46 2.900 362 NICOLET NATIONAL BANK 654062JRO 1625 Certificates of Deposit - Bank Amort 249,000.00 1.150 244,301.37 03/31/2022 1.150 03/28/2024 727 Subtotal and Average 249,000.00 244,301.37 1.150 727 NELNET BANK INC 64034KAJO 1651 Certificates of Deposit - Bank Amort 248,000.00 1 450 234,635.28 03/31/2022 1.450 02/02/2027 1,768 Subtotal and Average 248,000.00 234,635.28 1.450 1,768 NEW YORK COMMUNITY BANK 649447UZO 1633 Certificates of Deposit - Bank Amort 249,000.00 0.700 229.936.56 03/31/2022 0.700 07/01/2026 1,552 Subtotal and Average 249,000.00 229,936.56 0.700 1,552 PACIFIC ENTERPRISE BANK 694231AD3 1621 PADUCAH BANK AND TRUST 695292FP2 1613 PEOPLES BANK/SARDIS TN Certificates of Deposit - Bank Amort Subtotal and Average Certificates of Deposit - Bank Amort Subtotal and Average 249,000.00 1.150 249,000.00 249,000.00 1.650 249,000.00 238,942.89 03/31/2022 1.150 03/31/2025 1,095 238,942.89 1.150 1,095 244,395.99 03/31/2022 1.650 11/08/2024 952 244,395.99 1.650 952 Portfolio ENCI Data Updated: SET _QTR: 05/02/2022 11:29 AC Run Date: 05/02/2022 - 11:29 No fiscal year history available DI (PRF_DI) 7.1.1 Report Ver. 7.3.6.1 City of Encinitas - Qtr Inv Report Investments by Issuer Page 7 Sorted by Fund Investment Current Market YTM Redemption Days To Call CUSIP Investment # Security Type Class Remaining Cost Rate Market Value Date 365 D Collateral 710673AC8 1624 Certificates of Deposit - Bank Amort 249,000.00 1.000 240,919.95 03/31/2022 1.000 09/30/2024 913 Subtotal and Average 249,000.00 240,919.95 1.000 913 POPPY BANK 73319FAD1 1611 Certificates of Deposit - Bank Amort 249,000.00 1.650 244,443.30 03/31/2022 1.650 11/04/2024 948 Subtotal and Average 249,000.00 244,443.30 1.650 948 REVERE BANK 761400BY1 1599 STATE BANK OF INDIA 856285C41 1650 Sallie Mae Bank/Murray 795450S89 1570 TIAA FSB 87270LAD5 1554 TOYOTA FINANCIAL SVGS BK 89235MMP3 1649 Certificates of Deposit - Bank Amort Subtotal and Average Certificates of Deposit - Bank Amort Subtotal and Average Certificates of Deposit - Bank Amort Subtotal and Average Certificates of Deposit - Bank Amort Subtotal and Average Certificates of Deposit - Bank Amort Subtotal and Average TRIAD BANK FRONTENAC MO 89579NCB7 1612 Certificates of Deposit - Bank Amort Subtotal and Average Union Bank Checking Acct. SYS1010 1010 US BANK Passbook/Checking Accounts Amort Subtotal and Average 247,000.00 2.300 247,000.00 248, 000.00 1,400 248,000.00 245.000.00 3.300 245,000.00 245,000.00 2,150 245,000.00 248,000.00 1.350 248,000.00 249.000.00 1.800 249,000.00 7,096,478.91 7,096,478.91 247,382.85 03/31/2022 2.300 06/28/2024 819 247,382.85 2.300 819 234,253.36 03/31/2022 1.400 01/13/2027 1,748 234,253.36 1.400 1,748 250,416.95 03/31/2022 3.300 06/27/2023 452 250,416.95 3.300 452 246,200.50 03/31/2022 2.150 07/19/2022 109 246,200.50 2.150 109 233,700.32 03/31/2022 1.350 01/13/2027 1,748 233,700.32 1.350 1,748 245,337 21 03/31/2022 1.800 11/08/2024 952 245,337.21 1.800 952 7,096,478.91 06/30/2018 1 7,096,478.91 1 Portfolio ENCI Data Updated: SET_QTR: 05/02/2022 11:29 AC Run Dale: 05/02/2022 - 11:29 No fiscal year history available DI (PRF_DI) 7.1.1 Report Ver. 7.3.6.1 City of Encinitas - Qtr Inv Report Investments by Issuer Sorted by Fund Page 8 Investment Current Market YTM Redemption Days To Call CUSIP Investment# Security Type Class Remaining CostRate Market Value Date 365 Collateral SYS1004 1004 Money Market Funds Amort 1,111,597.19 0.030 1,111,597.19 04/30/2019 0.030 1 Subtotal and Average 1,111,597.19 1,111,597.19 0.030 1 UBS BANK USA 90348JN48 1632 Certificates of Deposit - Bank Amort Subtotal and Average GREENSTATE CREDIT UNION 39573LCE6 1648 FIRST US BANK 33744AAW9 1630 U.S. Treasury Notes 912828L24 912828XQB 9128282W9 912828S92 9128282131 912828Y87 91282CBT7 91282CAP6 91282CBM2 91282CBQ3 91282CAB7 912828ZC7 912828YH7 91282CAJO 91282CAM3 912828ZW3 912828YE4 912828YM6 912828ZFO 91282CDH1 91282CCJ8 Certificates of Deposit - Bank Amort Subtotal and Average Certificates of Deposit - Bank Amort Subtotal and Average 249,000.00 0.750 249,000.00 248.000.00 1.350 248,000.00 249,000.00 0.400 249,000.00 230,454 48 03/31/2022 0.750 06/23/2026 1,544 230,454.48 0.750 1,544 233.628,40 03/31/2022 1.350 01/14/2027 1,749 233,628.40 1.350 1,749 230,178.09 03/31/2022 0.400 11/18/2025 1,327 230,178.09 0.400 1,327 1572 U.S. Treasury Coupon Securities Fair 1,934.375.00 1.875 2,007.820.00 03/31/2022 2.710 08/31/2022 152 1578 U.S. Treasury Coupon Securities Fair 3,891,250.00 2.000 4,016,240.00 03/31/2022 2.705 07/31/2022 121 1579 U.S. Treasury Coupon Securities Fair 1,933,125.00 1.875 2,008,040.00 03/31/2022 2.711 09/30/2022 182 1592 U.S. Treasury Coupon Securities Fair 2,884,687.50 1.250 2.968,950.00 03/31/2022 2.181 07/31/2023 486 1604 U.S. Treasury Coupon Securities Amort 1,971,562.50 1.375 1,980,160.00 03/31/2022 1.729 08/31/2023 517 1634 U.S. Treasury Coupon Securities Amort 6,247,500.00 1.750 5,906,280.00 03/31/2022 0.394 07/31/2024 852 1635 U.S. Treasury Coupon Securities Amort 2,001,250.00 0.750 1,865,080.00 03/31/2022 0.736 03/31/2026 1,460 1636 U,S. Treasury Coupon Securities Amort 1,994,375.00 0.125 1,938,360.00 03/31/2022 0.249 10/15/2023 562 1638 U.S. Treasury Coupon Securities Amort 1,990,859.38 0.125 1,920,540.00 03/31/2022 0.301 02/15/2024 685 1639 U.S. Treasury Coupon Securities Amort 1,979,921.88 0.500 1,849,060.00 03/31/2022 0.720 02/28/2026 1,429 1640 U.S. Treasury Coupon Securities Amort 5,910,000.00 0.250 5,562,660.00 03/31/2022 0.624 07/31/2025 1,217 1641 U.S. Treasury Coupon Securities Amort 2.042,812.50 1.125 1,922,580.00 03/31/2022 0.531 02/28/2025 1,064 1642 U.S. Treasury Coupon Securities Amort 2,068,437,50 1,500 1,952.900,00 03/31/2022 0.432 09/30/2024 913 1643 U.S. Treasury Coupon Securities Amort 1.968,437.50 0.250 1,850,460.00 03/31/2022 0.636 08/31/2025 1,248 1644 U.S. Treasury Coupon Securities Amort 1,966,875.00 0.250 1,847,500.00 03/31/2022 0.648 09/30/2025 1,278 1645 U.S. Treasury Coupon Securities Amort 1.972,500.00 0.250 1,858,040.00 03/31/2022 0.600 06/30/2025 1,186 1646 U.S. Treasury Coupon Securities Amort 2,051.875.00 1.250 1,943,360.00 03/31/2022 0.419 08/31/2024 883 1647 U.S. Treasury Coupon Securities Amort 1,034.375.00 1.500 975,630,00 03/31/2022 0.453 10/31/2024 944 1652 U.S. Treasury Coupon Securities Amort 964.218.75 0.500 942,070.00 03/31/2022 1.705 03/31/2025 1,095 1653 U.S. Treasury Coupon Securities Amort 975,468.75 0.750 958,181.88 03/31/2022 1.688 11/15/2024 959 1654 U.S. Treasury Coupon Securities Amort 963,281.25 0.875 935,623,65 03/31/2022 1.763 06/30/2026 1,551 Portfolio ENCI Data Updated: SET _QTR: 05/02/2022 11:29 AC Run Date: 05/02/2022 - 11:29 No fiscal year history available DI (PRF_DI) 7.1.1 Report Ver. 7.3.6.1 City of Encinitas - Qtr Inv Report Investments by Issuer Sorted by Fund Page 9 Investment Current Market YTM Redemption Days To Call CUSIP Investment# Security Type Class Remaining Cost Rate Market Value Dae 365 oal_fx—�ty Date Collateral 91282CBR1 1655 U.S. Treasury Coupon Securities Amort 973,750.00 0.250 960,630.00 03/31/2022 1.578 03/15/2024 714 91282CCG4 1656 U.S. Treasury Coupon Securities Amort 1,938,906.25 0.250 1,908,653.85 03/31/2022 1.627 06/15/2024 806 91282CAT8 1657 U.S. Treasury Coupon Securities Amort 946,953.13 0,250 922,880.88 03/31/2022 1.759 10/31/2025 1,309 91282CCP4 1659 U.S. Treasury Coupon Securities Amort 3,804,375.00 0.625 3,693,544.31 03/31/2022 1.787 07/31/2026 1,582 Subtotal and Average 56,411,171.89 54,695,244.57 1.185 913 Wells Fargo Bank 949763JG2 1535 Certificates of Deposit - Bank Amort Subtotal and Average Total and Average 245,000.00 2.250 245,000.00 121,077,388.08 246,100 05 03/31/2022 2.250 06/30/2022 90 246,100.05 2.250 90 118,954,231.77 1.155 607 Portfolio ENCI Data Updated: SET _QTR: 05/02/2022 11:29 AC Run Date: 05/02/2022 - 11:29 No fiscal year history available DI (PRF_DI) 7.1.1 Report Ver. 7.3.6 1