The URL can be used to link to this page

Home My WebLink AboutItem 05 - Quarterly Report of InvestmentsFinance and Management Services www.santa-ana.org/finance Item # 5 City of Santa Ana 20 Civic Center Plaza, Santa Ana, CA 92701 Staff Report August 29, 2023 TOPIC: Periodic Quarterly Report of Investments as of June 30, 2023 AGENDA TITLE Receive and File Quarterly Report of Investments as of June 30, 2023 RECOMMENDED ACTION Receive and file. DISCUSSION California Code Section 53646 (b) states that if a quarterly report is rendered to the legislative body, the quarterly investment report shall be submitted within 45 days following the end of the quarter covered by the report. In an effort to meet the statutory requirement, Finance & Management Services Agency ("FMSA") submits the Report via email for review and distribution to the City Council in advance. The report was emailed for distribution on August 2, 2023. The legislation specifies that this quarterly report contain the seven major elements listed below: 1. Type of investments 2. Date of maturity 3. Par and dollar amounts invested in each security 4. Weighted average maturity of the investments 5. Market value as of the date of the report 6. Source of the market value information 7. Any funds, investments, or programs, including loans, under the management of contracted parties These specifications include a statement outlining the ability of the City to meet the budgeted expenditures for the subsequent six months be submitted to the City Council on a quarterly basis. Staff performs an end -of -month expenditure analysis to comply with the expenditure requirement and a statement confirming the ability to meet this requirement in the monthly and quarter -ending Treasurer's Report. The information is in compliance with State law and the City's Investment Policy. The attached Treasurer's Report (Exhibit 1) accurately reflects all pooled investments held on behalf of the City as of June 30, 2023. Quarterly Report of Investments August 29, 2023 Page 2 The attached Cash held by Bank and Cash held by Fund(s) Listing (Exhibit 2) is a schedule of cash by funds added to the monthly and quarterly Report of Investments to enhance FMSA's reporting and transparency. The following two tables represent: (1) percentage limits set by the City's Investment Policy and State Law and shows respective City investment portfolio investment types, amounts, and percentages; and (2) the restricted cash balance as of June 30, 2023. Type of Investment Amounts Invested $ o Portfolio COSA Policy Limits State Law Limits Certificates of Deposit (CDs) $6,696,000 1.20% 30% 30% Federal Farm Credit Bank (FFCB) $55,936,550 10.00% None None Federal Home Loan Bank (FHLB) $249,738,720 44.63% None None Federal Home Loan Mortgage Corp. (FHLMC) $44,993,750 8.04% None None Federal National Mortgage Association (FNMA) $59,484,750 10.63% None None Local Agency Investment Fund (LAIF) $73,244,242 13.09% None None Local Agency Investment Fund (LAIF — ARPA) $59,582,074 10.65% None None U.S. Treasury $9,915,500 1.76% None None Sub- Total: $559,591,586 100% None None Cash : $22,170,181 Total: $581,761,767 Restricted Cash In $ Restricted Cash t, $13,417,418 Total $13,417,418 t Restricted cash is held by various Trustees such as Bank of New York Mellon; US Bank; Signature Bank; and State of California Condemnation Fund. Restricted Cash is segregated from cash used for daily operations. The following City investment portfolio graph represents percentages within the resoectl, D.S. Treasury 1.76% Local Agency Investment Fund (ARPA) 10.65% Local Agency Investment Fund (LA1F) 13.09% Federal National Mortgage Ass( (FNMA) 10.63% Federal 8.04% 'e Investment types as oT .June jU, LULj. City of Santa Ana Investment Portfolio Certificates of Deposit (CD) June 2023 ' 1.20% Federal Farm Credit Bank (FFCB) 10.00% Federal Home Loan Bank(FHLB) 44.63% Quarterly Report of Investments August 29, 2023 Page 3 The following two tables represent, as of June 30, 2023: (1) the aggregate Average Market Yield To Date (AMTD); and (2) the breakdown of by investment type. Aggregate Average Market Yield To Date Average Month To Date (AMTD) 11.877% Investments Book Value of Investments YTM % of Portfolio Certificates of Deposit $6,696,000 1.181 % 1.19% 0.014% LAIF $73,244,242 3.167% 13.20% 0.418% LAIF ARPA $59,582,074 3.167% 10.77% 0.341 % Federal Agency Securities $410,153,770 1.436% 73.07% 1.049% U.S. Treasury $9,915,500 3.100% 1.77% 0.055% $559,591,586 1.877% 100% 1.877% Cash held by Bank and Cash by Fund(s) Listing (Exhibit 2) The above -referenced exhibit (Exhibit 2) includes a comparison of bank balances between each City Cash account including Investments; Cash held at a City designated financial institution; Cash on Hand; and Restricted Cash versus the Cash held by various Fund(s). FISCAL IMPACT There is no fiscal impact associated with this action. EXHIBIT(S) 1. Treasurer's Report 2. Cash Held by Bank and Cash Fund(s) Listing Submitted By: Kathryn Downs, FMSA Executive Director Approved By: Kristine Ridge, City Manager EXHIBIT 1 City of Santa Ana Portfolio Management Portfolio Summary June 30, 2023 Par Market Book % of Days to YTM/C Investments Value Value Value Portfolio Term Maturity Certificates of Deposit 6,696,000.00 6,053,719.80 6,696,000.00 1.20 1,653 1,097 1.181 Local Agency Investment Funds 73,244,241.78 73,244,241.78 73,244,241.78 13.09 1 1 3.167 Cash in Banks 59,582,074.22 59,582,074.22 59,582,074.22 10.65 1 1 3.167 Federal Agency Coupon Securities 410,175,000.00 380,896,995.50 410,153,770.25 73.30 1,492 266 1.436 Treasury Coupon Securities 5,000,000.00 4,822,650.00 4,990,000.00 0.89 837 365 1.839 Treasury Strips 5,000,000.00 4,984,750.00 4,925,500.00 0.88 116 24 4.759 559,697,316.00 529,584,431.30 559,591,586.25 100.00% 1,122 212 1.877 Investments Cash Passbook/Checking (not included in yield calculations) Total Cash and Investments 22,170,180.59 22,170,180.59 22,170,180.59 581,867,496.59 551,754,611.89 581,761,766.84 0.000 1,122 212 1.877 Total Earnings June 30 Month Ending Fiscal Year To Date Fiscal Year Ending Current Year 841,523.86 7,705,815.45 7,705,815.45 Average Daily Balance 595,430,414.28 541,168,891.64 Effective Rate of Return 1.72% 1.42% This report contains all the required information in SB 866 and SB 564 and accurately reflects all pooled investments held during this reporting period on behalf of the City and the City of Santa Ana acting on behalf of the Community Redevelopment Agency. The information reported herein is in compliance with State law and the City's Investment Policy. Based on liquidity of investments, the City of Santa Ana is able to meet budgeted expenditure requirements for the next six months, barring any catastrophic natural disasters. Market pricings are obtained through the City's third party trust services at BNY Mellon Trust. Finance & Mgmt Services Agency, Reporting period 06/01/2023-06130/2023 Run Date: 07/24/2023 - 08:34 Portfolio COSA CID PM (PRF_PM1) 7.3.11 Report Ver. 7.3.11 City of Santa Ana Portfolio Management Portfolio Details - Investments June 30, 2023 Page 1 CUSIP Investment # Average Issuer Balance Purchase Date Par Value Market Value Book Value Stated Rate YTM/C 360 YTM/C 365 Days to Maturity Maturity Date Certificates of Deposit 06417NF73 14051 BANK OZK 11/12/2021 248,000.00 220,271.69 248,000.00 0.600 0.592 0.600 1,046 05/12/2026 02568KAJ4 14043 American Equity Bank 11/26/2021 248,000.00 220,583.35 248,000.00 0.700 0.690 0.700 1,061 05/27/2026 70962LAV4 14050 PENTAGON FCU 11/10/2021 248,000.00 220,159.67 248,000.00 1.000 0.986 1.000 1,228 11/10/2026 549104ZS9 14046 LUANA SAVINGS BK 11/05/2021 248,000.00 217,402.78 248,000.00 0.600 0.592 0.600 1,223 11/05/2026 87165FD76 14047 SYNCHRONY BANK 11/05/2021 248,000.00 221,265.45 248,000.00 1.100 1.085 1.100 1,223 11/05/2026 02589ABT8 14078 AMERICA EXPRESS NATL BK 03/16/2022 248,000.00 227,032.20 248,000.00 2.000 1.973 2.000 1,354 03/16/2027 15721UET2 14044 CFBANK 11/10/2021 248,000.00 221,069.18 248,000.00 0.850 0.838 0.850 1,105 07/10/2026 32022EAUO 14065 FIRST FEDERAL 12/29/2021 248,000.00 226,400.99 248,000.00 0.850 0.838 0.850 790 08/29/2025 88413QDE5 14056 THIRD FEDERAL S&L 11/24/2021 248,000.00 228,064.25 248,000.00 0.800 0.789 0.800 692 05/23/2025 07371AH22 14084 BEAL BANK PLANO TX 03/30/2022 248,000.00 229,054.81 248,000.00 2.250 2.219 2.250 1,362 03/24/2027 38149MR47 14064 GOLDMAN SACHS 12/22/2021 248,000.00 225,348.90 248,000.00 1.000 0.986 1.000 905 12/22/2025 856285YQ8 14057 ST BK INDIA NY 11/29/2021 248,000.00 221,337.35 248,000.00 1.150 1.134 1.150 1,248 11/30/2026 14042TEP8 14079 CAPITAL ONE BANK 03/16/2022 248,000.00 227,032.20 248,000.00 2.000 1.973 2.000 1,354 03/16/2027 59013KPNO 14049 MERRICK BANK 11/09/2021 248,000.00 220,962.72 248,000.00 1.100 1.085 1.100 1,227 11/09/2026 30781JAW0 14054 FARMERS & MERCHANTS 11/19/2021 248,000.00 218,789.34 248,000.00 0.850 0.838 0.850 1,237 11/19/2026 05580AH64 14061 BMW BANK OF NA 12/17/2021 248,000.00 231,599.88 248,000.00 0.950 0.937 0.950 535 12/17/2024 45776NEN2 14062 INSBANK 12/20/2021 248,000.00 221,657.34 248,000.00 0.900 0.888 0.900 1,084 06/19/2026 58404DMQ1 14063 MEDALLION BK UT 12/20/2021 248,000.00 221,502.71 248,000.00 1.250 1.233 1.250 1,269 12/21/2026 89235MMB4 14052 TOYOTA FINANCIAL 11/12/2021 248,000.00 221,125.36 248,000.00 1.100 1.085 1.100 1,230 11/12/2026 292079AR1 14045 EMPIRE ST BK NA 11/12/2021 248,000.00 221,591.92 248,000.00 0.900 0.888 0.900 1,108 07/13/2026 07371CT25 14085 BEAL BANK USA 03/30/2022 248,000.00 229,054.81 248,000.00 2.250 2.219 2.250 1,362 03/24/2027 73319FBJ7 14053 POPPY BANK 11/17/2021 248,000.00 218,439.54 248,000.00 0.800 0.789 0.800 1,235 11/17/2026 320337EZ7 14048 FIRST GENERAL BK 11/05/2021 248,000.00 228,801.80 248,000.00 0.500 0.493 0.500 585 02/05/2025 39573LCCO 14055 GREENSTATE CU 11/23/2021 248,000.00 225,034.58 248,000.00 0.900 0.888 0.900 877 11/24/2025 61768U3U9 14082 MORGAN STANLEY PVT BANK 03/31/2022 248,000.00 229,166.98 248,000.00 2.250 2.219 2.250 1,368 03/30/2027 61773TCX9 14083 MORGAN STANLEY PVT BANK 03/31/2022 248,000.00 229,166.98 248,000.00 2.250 2.219 2.250 1,368 03/30/2027 795451BA0 14060 SALLIE MAE BANK 12/15/2021 248,000.00 231,803.02 248,000.00 1.000 0.986 1.000 534 12/16/2024 Subtotal and Average 6,696,000.00 6,696,000.00 6,053,719.80 6,696,000.00 1.165 1.181 1,097 Local Agency Investment Funds LAIFCITY LAIFCITY Local Agency Investment Fund 73,244,241.78 73,244,241.78 73,244,241.78 3.167 3.124 3.167 1 Subtotal and Average 74,092,975.11 73,244,241.78 73,244,241.78 73,244,241.78 3.124 3.167 1 Cash in Banks LAIF ARPA LAIF ARPA Local Agency Investment Fund 59,582,074.22 59,582,074.22 59,582,074.22 3.167 3.124 3.167 1 Run Date: 07/24/2023 - 08,34 Portfolio COSA CID PM (PRF_PM2) 7.3.11 Report Ver. 7.3.11 City of Santa Ana Portfolio Management Portfolio Details - Investments June 30, 2023 Page 2 CUSIP Investment # Average Issuer Balance Purchase Date Par Value Market Value Book Value Stated Rate YTM/C 360 YTM/C 365 Days to Maturity Maturity Date Subtotal and Average 94,572,168.92 59,582,074.22 59,582,074.22 59,582,074.22 3.124 3.167 1 Federal Agency Coupon Securities 3133EJ5W5 13868 Federal Farm Credit Bank 01/29/2019 925,000.00 917,193.00 924,195.25 2.650 2.634 2.670 114 10/23/2023 3133EKBW5 13876 Federal Farm Credit Bank 03/04/2019 3,000,000.00 2,944,920.00 2,998,740.00 2.610 2.583 2.619 241 02/27/2024 3133EKPG5 13897 Federal Farm Credit Bank 06/10/2019 1,500,000.00 1,490,955.00 1,512,465.00 2.125 1.894 1.920 66 09/05/2023 3133EK3M6 13934 Federal Farm Credit Bank 10/23/2019 5,000,000.00 4,942,000.00 5,003,650.00 1.625 1.584 1.606 114 10/23/2023 3133ELX33 13974 Federal Farm Credit Bank 07/22/2020 6,000,000.00 5,471,160.00 6,000,000.00 0.690 0.681 0.690 752 07/22/2025 3133EMBH4 13988 Federal Farm Credit Bank 09/29/2020 5,000,000.00 4,538,250.00 5,000,000.00 0.530 0.523 0.530 821 09/29/2025 3133EMFR8 13991 Federal Farm Credit Bank 11/03/2020 5,000,000.00 4,533,450.00 4,997,500.00 0.540 0.543 0.550 856 11/03/2025 3133EMSU7 14005 Federal Farm Credit Bank 03/09/2021 4,000,000.00 3,600,240.00 4,000,000.00 0.800 0.789 0.800 982 03/09/2026 3133EMUP5 14006 Federal Farm Credit Bank 04/01/2021 6,000,000.00 5,555,220.00 6,000,000.00 0.710 0.692 0.701 640 04/01/2025 3133EMWH1 14016 Federal Farm Credit Bank 04/21/2021 5,000,000.00 4,620,400.00 5,000,000.00 0.710 0.700 0.710 660 04/21/2025 3133EM2C5 14032 Federal Farm Credit Bank 08/10/2021 6,000,000.00 5,319,600.00 6,000,000.00 0.710 0.700 0.710 40 08/10/2026 3133ENPB0 14075 Federal Farm Credit Bank 02/16/2022 3,500,000.00 3,220,840.00 3,500,000.00 2.180 2.150 2.180 230 02/16/2027 3133ENUH1 14086 Federal Farm Credit Bank 04/12/2022 2,000,000.00 1,905,480.00 2,000,000.00 3.330 3.284 3.330 1,381 04/12/2027 3133ENVV9 14088 Federal Farm Credit Bank 05/03/2022 3,000,000.00 2,876,190.00 3,000,000.00 3.630 3.580 3.630 1,402 05/03/2027 3130AFW94 13873 Federal Home Loan Bank 02/27/2019 2,000,000.00 1,964,980.00 1,996,220.00 2.500 2.506 2.541 227 02/13/2024 3130AB3H7 13889 Federal Home Loan Bank 04/29/2019 3,000,000.00 2,938,950.00 2,999,250.00 2.375 2.348 2.380 251 03/08/2024 3130AKPQ3 13996 Federal Home Loan Bank 01/28/2021 4,000,000.00 3,593,760.00 4,000,000.00 0.580 0.572 0.580 27 01/28/2026 3130AKU53 13997 Federal Home Loan Bank 01/28/2021 5,000,000.00 4,485,050.00 5,000,000.00 0.520 0.513 0.520 27 01/28/2026 3130AKN69 13998 Federal Home Loan Bank 01/28/2021 6,000,000.00 5,379,180.00 6,000,000.00 0.500 0.493 0.500 211 01/28/2026 3130ALA53 13999 Federal Home Loan Bank 02/25/2021 5,000,000.00 4,447,850.00 5,000,000.00 0.600 0.592 0.600 55 02/25/2026 3130ALBM5 14001 Federal Home Loan Bank 02/24/2021 5,000,000.00 4,451,300.00 5,000,000.00 0.625 0.616 0.625 54 02/24/2026 3130ALB52 14002 Federal Home Loan Bank 02/25/2021 5,000,000.00 4,591,150.00 5,000,000.00 0.375 0.370 0.375 55 02/25/2025 3130ALDZ4 14003 Federal Home Loan Bank 03/10/2021 4,000,000.00 3,677,400.00 4,000,000.00 0.500 0.493 0.500 71 03/10/2025 3130ALKN3 14004 Federal Home Loan Bank 03/24/2021 4,000,000.00 3,751,400.00 4,000,000.00 0.500 0.493 0.500 85 09/24/2024 3130ALLP7 14007 Federal Home Loan Bank 03/29/2021 6,000,000.00 5,526,180.00 5,997,000.00 0.650 0.661 0.670 78 03/17/2025 3130ALW67 14008 Federal Home Loan Bank 04/22/2021 5,000,000.00 4,464,600.00 5,000,000.00 1.100 1.085 1.100 21 04/22/2026 3130AMYU0 14024 Federal Home Loan Bank 06/30/2021 6,000,000.00 5,388,300.00 6,000,000.00 1.050 1.036 1.050 91 06/30/2026 3130AMYC0 14025 Federal Home Loan Bank 06/30/2021 6,000,000.00 5,416,320.00 6,000,000.00 1.000 0.986 1.000 91 03/30/2026 3130AMSF0 14026 Federal Home Loan Bank 06/28/2021 6,000,000.00 5,703,240.00 6,000,000.00 0.400 0.395 0.400 89 06/28/2024 3130ANFU9 14027 Federal Home Loan Bank 07/29/2021 5,000,000.00 4,455,850.00 5,000,000.00 0.850 0.838 0.850 1,124 07/29/2026 3130ANFG0 14028 Federal Home Loan Bank 08/18/2021 5,000,000.00 4,486,900.00 5,000,000.00 0.875 0.863 0.875 48 05/18/2026 3130ANE30 14029 Federal Home Loan Bank 07/29/2021 5,000,000.00 4,492,250.00 5,000,000.00 0.500 0.493 0.500 28 07/29/2026 3130ANHV5 14033 Federal Home Loan Bank 08/19/2021 5,000,000.00 4,660,800.00 5,000,000.00 0.550 0.542 0.550 537 12/19/2024 3130ANPE4 14034 Federal Home Loan Bank 08/26/2021 6,000,000.00 5,482,560.00 6,000,000.00 0.700 0.690 0.700 56 08/26/2025 3130ANQ78 14035 Federal Home Loan Bank 08/27/2021 6,000,000.00 5,344,380.00 6,000,000.00 0.900 0.888 0.900 1,153 08/27/2026 Portfolio COSA CID Run Date: 07/24/2023 - 08:34 PM (PRF_PM2) 7.3.11 City of Santa Ana Portfolio Management Portfolio Details - Investments June 30, 2023 Page 3 CUSIP Investment # Issuer Average Balance Purchase Date Par Value Market Value Book Value Stated Rate YTM/C 360 YTM/C 365 Days to Maturity Maturity Date Federal Agency Coupon Securities 3130AP3E3 14036 Federal Home Loan Bank 09/30/2021 5,000,000.00 4,428,650.00 5,000,000.00 0.820 0.809 0.820 1,187 09/30/2026 3130ANX62 14037 Federal Home Loan Bank 09/30/2021 5,000,000.00 4,586,900.00 5,000,000.00 0.650 0.641 0.650 91 06/30/2025 3130APB79 14038 Federal Home Loan Bank 09/30/2021 5,000,000.00 4,459,650.00 5,000,000.00 1.000 0.986 1.000 1,187 09/30/2026 3130AP3A1 14039 Federal Home Loan Bank 09/29/2021 5,000,000.00 4,463,200.00 4,998,750.00 0.850 0.851 0.863 90 06/29/2026 3130APB46 14040 Federal Home Loan Bank 10/13/2021 10,000,000.00 8,912,800.00 10,000,000.00 0.950 0.937 0.950 104 10/13/2026 3130APQC2 14041 Federal Home Loan Bank 11/23/2021 5,000,000.00 4,791,150.00 5,000,000.00 0.750 0.740 0.750 53 05/23/2024 3130APQB4 14042 Federal Home Loan Bank 11/23/2021 5,000,000.00 4,527,050.00 5,000,000.00 1.500 1.479 1.500 22 11/23/2026 3130APVC6 14058 Federal Home Loan Bank 12/14/2021 5,000,000.00 4,506,350.00 4,997,500.00 1.375 1.382 1.401 62 12/01/2026 3130AQAB9 14059 Federal Home Loan Bank 12/30/2021 3,750,000.00 3,402,937.50 3,750,000.00 1.625 1.603 1.625 91 12/30/2026 3130AQLQ4 14069 Federal Home Loan Bank 01/27/2022 5,000,000.00 4,526,700.00 5,000,000.00 1.650 1.627 1.650 26 01/27/2027 3130AQKM4 14070 Federal Home Loan Bank 01/28/2022 1,500,000.00 1,362,510.00 1,500,000.00 1.750 1.726 1.750 27 01/28/2027 3130AQNR0 14071 Federal Home Loan Bank 01/27/2022 3,000,000.00 2,725,260.00 3,000,000.00 1.750 1.726 1.750 26 01/27/2027 3130AQSA2 14072 Federal Home Loan Bank 02/10/2022 5,000,000.00 4,549,100.00 5,000,000.00 1.830 1.805 1.830 40 02/10/2027 3130AQW33 14073 Federal Home Loan Bank 02/24/2022 5,000,000.00 4,575,350.00 5,000,000.00 2.020 1.992 2.020 54 02/24/2027 3130AQYA5 14074 Federal Home Loan Bank 02/28/2022 1,500,000.00 1,383,000.00 1,500,000.00 2.250 2.219 2.250 54 02/24/2027 3130ARA35 14076 Federal Home Loan Bank 03/24/2022 3,000,000.00 2,831,700.00 3,000,000.00 2.000 1.973 2.000 85 03/24/2025 3130ARC82 14077 Federal Home Loan Bank 03/29/2022 3,000,000.00 2,752,320.00 3,000,000.00 2.100 2.071 2.100 1,367 03/29/2027 3130ARD65 14080 Federal Home Loan Bank 03/28/2022 2,000,000.00 1,981,660.00 2,000,000.00 1.625 1.548 1.570 89 09/28/2023 3130ARR60 14087 Federal Home Loan Bank 04/29/2022 2,000,000.00 1,927,380.00 2,000,000.00 3.100 3.058 3.100 28 04/29/2025 3130ASHV4 14089 Federal Home Loan Bank 06/28/2022 20,000,000.00 19,966,200.00 20,000,000.00 3.050 3.010 3.051 27 07/28/2023 3130ASLJ6 14090 Federal Home Loan Bank 06/29/2022 20,000,000.00 19,758,800.00 20,000,000.00 3.100 2.028 2.056 84 12/29/2023 3130AV5C2 14091 Federal Home Loan Bank 03/15/2023 12,000,000.00 11,988,360.00 12,000,000.00 5.150 5.079 5.150 76 09/15/2023 3130AVCN0 14092 Federal Home Loan Bank 03/13/2023 2,000,000.00 1,998,120.00 2,000,000.00 5.375 5.301 5.375 256 03/13/2024 3130AVDB5 14093 Federal Home Loan Bank 03/30/2023 2,000,000.00 1,993,220.00 2,000,000.00 6.000 5.918 6.000 271 03/28/2028 3130AWBL3 14102 Federal Home Loan Bank 05/30/2023 10,000,000.00 9,997,900.00 10,000,000.00 5.250 5.250 5.323 121 10/30/2023 3134GVQX9 13962 Federal Home Loan Mortgage Co. 05/05/2020 5,000,000.00 4,615,000.00 4,995,000.00 0.700 0.711 0.720 674 05/05/2025 3134GVVX3 13964 Federal Home Loan Mortgage Co. 05/28/2020 5,000,000.00 4,609,850.00 4,998,750.00 0.750 0.747 0.757 58 05/28/2025 3134GVR26 13967 Federal Home Loan Mortgage Co. 06/25/2020 6,000,000.00 5,512,260.00 6,000,000.00 0.700 0.690 0.700 360 06/25/2025 3134GVT99 13968 Federal Home Loan Mortgage Co. 06/30/2020 6,000,000.00 5,511,300.00 6,000,000.00 0.650 0.641 0.650 730 06/30/2025 3134GV5R5 13979 Federal Home Loan Mortgage Co. 07/15/2020 6,000,000.00 5,701,140.00 6,000,000.00 0.570 0.562 0.570 14 07/15/2024 3134GWUE4 13987 Federal Home Loan Mortgage Co. 09/30/2020 5,000,000.00 4,534,700.00 5,000,000.00 0.500 0.493 0.500 91 09/30/2025 3134GW4Z6 13989 Federal Home Loan Mortgage Co. 10/27/2020 6,000,000.00 5,414,040.00 6,000,000.00 0.540 0.533 0.540 118 10/27/2025 3134GXJL9 13995 Federal Home Loan Mortgage Co. 12/30/2020 6,000,000.00 5,357,160.00 6,000,000.00 0.500 0.493 0.500 182 12/30/2025 3135GOX24 13940 Federal NaVI Mtg. Assoc. 01/15/2020 5,000,000.00 4,740,100.00 4,990,750.00 1.625 1.641 1.664 556 01/07/2025 3135GOW66 13941 Federal Nafl Mtg. Assoc. 01/15/2020 5,000,000.00 4,769,950.00 4,994,000.00 1.625 1.629 1.651 472 10/15/2024 3136G4WV1 13965 Federal Nafl Mtg. Assoc. 06/16/2020 5,000,000.00 4,601,650.00 5,000,000.00 0.750 0.740 0.750 716 06/16/2025 Portfolio COSA CP Run Date: 07/24/2023 - 08:34 PM (PRF_PM2) 7.3.11 City of Santa Ana Portfolio Management Portfolio Details - Investments June 30, 2023 Page 4 Average Purchase Stated YTM/C YTM/C Days to Maturity CUSIP Investment # Issuer Balance Date Par Value Market Value Book Value Rate 360 365 Maturity Date Federal Agency Coupon Securities 3136G4D42 13976 Federal NaVI Mtg. Assoc. 07/28/2020 8,000,000.00 7,262,560.00 8,000,000.00 0.510 0.503 0.510 27 07/28/2025 3136G4C43 13977 Federal NaVI Mtg. Assoc. 08/14/2020 6,000,000.00 5,456,340.00 6,000,000.00 0.650 0.641 0.650 775 08/14/2025 3136G4G98 13978 Federal Nafl Mtg. Assoc. 08/12/2020 6,000,000.00 5,473,200.00 6,000,000.00 0.560 0.552 0.560 42 08/12/2025 3136G45Q2 13990 Federal Nafl Mtg. Assoc. 10/28/2020 6,000,000.00 5,433,060.00 6,000,000.00 0.530 0.523 0.530 27 10/28/2025 3135GA4V0 13992 Federal NaVI Mtg. Assoc. 11/25/2020 5,000,000.00 4,534,150.00 5,000,000.00 0.625 0.616 0.625 55 11/25/2025 3135GAAN1 13993 Federal NaVI Mtg. Assoc. 12/17/2020 6,000,000.00 5,416,680.00 6,000,000.00 0.600 0.592 0.600 78 12/17/2025 3135G06J7 13994 Federal Nafl Mtg. Assoc. 12/10/2020 6,000,000.00 5,426,880.00 6,000,000.00 0.650 0.641 0.650 71 12/10/2025 3135GAG62 14094 Federal Nafl Mtg. Assoc. 03/30/2023 1,500,000.00 1,492,410.00 1,500,000.00 5.220 9.748 9.883 91 04/26/2024 Subtotal and Average 410,153,770.25 410,175,000.00 380,896,995.50 410,153,770.25 1.418 1.438 266 Treasury Coupon Securities 9128286Z8 14081 Treasury Strips 912797FZ5 14095 Run Date: 07/24/2023 - 08:34 U.S. Treasury Subtotal and Average U.S. Treasury Subtotal and Average 03/16/2022 4,990,000.00 03/31 /2023 4,925,500.00 5,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 4,822,650.00 4,822,650.00 4,984,750.00 4,984,750.00 4,990,000.00 1.750 1.814 1.839 365 06/30/2024 4,990,000.00 1.814 1.839 365 4,925,500.00 4.759 4.825 24 07/25/2023 4,925,500.00 4.759 4.825 24 Total and Average 595,430,414.28 559,697,316.00 529,584,431.30 559,591,586.25 1.853 1.879 212 Portfolio COSA CID PM (PRF_PM2) 7.3.11 City of Santa Ana Portfolio Management Portfolio Details - Cash June 30, 2023 Page 5 Average Purchase Stated YTM/C YTM/C Days to CUSIP Investment # Issuer Balance Date Par Value Market Value Book Value Rate 360 365 Maturity Cash in Banks PETTY CASH PETTY CASH CITY OF SANTA ANA 83,811.00 83,811.00 83,811.00 0.000 0.000 1 HOUSING 13943 JP MORGAN CHASE 4,243,033.72 4,243,033.72 4,243,033.72 0.000 0.000 1 WORKERS COMPENS 37983 JP MORGAN CHASE 1,764,661.55 1,764,661.55 1,764,661.55 0.000 0.000 1 GENERAL LIABILI 38130 JP MORGAN CHASE 1,259,953.07 1,259,953.07 1,259,953.07 0.000 0.000 1 PROPERTY MANAGE 8695 JP MORGAN CHASE 35,084.30 35,084.30 35,084.30 0.000 0.000 1 PROPERTY MGMT 2 PROP MGMT 2 JP MORGAN CHASE 1,492.50 1,492.50 1,492.50 0.000 0.000 1 HEALTHCARE SPEN 0112 JPMorgan Chase 300,053.40 300,053.40 300,053.40 0.000 0.000 1 COMMISSARY 7962 JPMorgan Chase 372,165.99 372,165.99 372,165.99 0.000 0.000 1 GENERAL ACCOUNT 9500 JPMorgan Chase 13,428,486.53 13,428,486.53 13,428,486.53 0.000 0.000 1 FSS FSS Santa Ana Federal Credit Union 681,438.53 681,438.53 681,438.53 0.000 0.000 1 Average Balance 0.00 1 Total Cash and Investments 595,430,414.28 581,867,496.59 551,754,611.89 581,761,766.84 1.853 1.879 212 Run Date: 07/24/2023 - 08:34 Portfolio COSA CID PM (PRF_PM2) 7.3.11 CASH/SECURITIES HELD IN TRUST Portfolio Management Page 1 Portfolio Details - Investments June 30, 2023 Digitally signed by Carey Li Carey I Date:2023.07.13 CUSIP Investment # Issuer Par Value Market Value Book Value 07:48:47-07'00' Money Market Accounts X9USDDTPC 80364 Dreyfus Treasury 10,571.42 10,571.42 10,571.42 X9USDDTPC 80365 Dreyfus Treasury 5,322.51 5,322.51 5,322.51 SYS80464 80366 Dreyfus Treasury 129.83 129.83 129.83 9AMMF05B2-- 80406 US BANK MONEY MARKET 0.76 0.76 0.76 SYS80418 80418 US BANK MONEY MARKET 495,414.58 495,414.58 495,414.58 SYS80419 80419 US BANK MONEY MARKET 105,347.70 105,347.70 105,347.70 SYS80421 80421 US BANK MONEY MARKET 0.01 0.01 0.01 31846V401 80430 US BANK MONEY MARKET 6,740.53 6,740.53 6,740.53 31846V401- 80432 US BANK MONEY MARKET 11,529.13 11,529.13 11,529.13 X9USDMOR3 80248 MORGAN STANLEY GOVT INSTIL 143.93 143.93 143.93 X9USDMOR3 80465 MORGAN STANLEY GOVT INSTIL 0.62 0.62 0.62 X9USDMOR3 80466 MORGAN STANLEY GOVT INSTIL 28.34 28.34 28.34 Subtotal and Average 635,229.36 635,229.36 635,229.36 Other S86209710 80225 MBIA INSURANCE POLICY 1.00 1.00 1.00 981NP5PV2 80396 ASSURED GUARANTY MUNI CORP 1.00 1.00 1.00 SYS80420 80437 US Bank Mutual Funds 9,941,792.06 9,988,082.95 9,941,792.06 Subtotal and Average 9,941,794.06 9,988,084.95 9,941,794.06 Cash in Bank SYS80414 80414 FLAGSTAR BANK 1,268,869.87 1,268,869.87 1,268,869.87 SYS80415 80415 CONDEMNATION DEPOSIT FUND 1,571,525.00 1,571,525.00 1,571,525.00 Subtotal and Average 2,840,394.87 2,840,394.87 2,840,394.87 Total and Average 13,417,418.29 13,463,709.18 13,417,418.29 Run Date: 07/12/2023 - 14:10 Portfolio TRST AC PM (PRF_PM2) 7.3.11 Report Ver. 7.3.11 EXHIBIT 2 Investments Bank of New York Mellon - Investment Custodian Local Agency Investment Fund (L.A.I.F) Local Agency Investment Fund (L.A.I.F) - ARPA Total - Investments Cash Held at City Financial Institution(s) and Cash on Hand General Account General Liability Account Housing Account Workers Compensation Account Santa Ana Federal Credit Union - Family Self Sufficiency (FSS-Housing; Commissary Account Flexible Benefit Spending Account Property Management Account Property Management - Phase 2 Account Amount 426,765,270 73,244,242 59, 582, 074 Amount 13,428,487 1,259,953 4,243,034 1,764,662 681,439 372,166 300,053 35,084 1,493 559,591,586 Petty Cash 83,811 Total - Cash Held at City Financial Institution(s) and Cash on Hand 22,170,181 Restricted Cash Amount Signature Bank - Streetlight Project 1,268,869.87 US Bank - Pension Stability Funds (Section 115 Trust with PARS) 10,439,807.31 Bank of New York Mellon - Various 31,864.00 US Bank - Warner Industrial Community 105,347.71 State of California Condemnation Fund - Right of Way Deposits 1,571,525.00 US Bank - Gas Tax Bonds 3.84 Total - Restricted Cash Total Cash Held City at Financial Institution(s), Cash on Hand and Restricted Cash Cash by Fund(s) - Total (see below for listing) Fund Fund description Amount O11 GENERAL FUND 152,759,359 012 CANNABIS PUBLIC BENEFIT 24,419,895 016 CASP CERTIFICATION &TRAINING 432,151 020 OTS-TRAFFIC OFFENDER PROGRAM 27,693 021 PRCSA CAN FUND 1,823,100 022 PRCSA FEE & DONATION 1,025,397 023 INMATE WELFARE FUND 2,074,093 024 PD ATHLETIC ACTIVITIES LEAGUE (236,625) 025 IDB & EZ VOUCHER MONITORING 197,247 026 ASSET FORFEITURE FUND 163,192 027 PARKING FUND 3,611,142 029 SPECIAL GAS TAX 30,086,124 030 PROP 1B BOND ACT OF 2006 155,157 031 AIR QUALITY IMPR. (AB 2766) 1,303,977 032 MEASURE M-STREET CONSTRUCTION (10,934,194) 033 NEW TRANSPO SYS IMPR AREA B 580,689 034 NEW TRANSPO SYS IMPR AREA E 1,733,333 035 NEW TRANSPO SYS IMPR AREA F 1,881,782 040 GENERAL FIXED ASSETS - 041 TRANSP SYS IMPR AREA A-2 706,183 042 TRANSPO SYS IMPR AREA B 9,669 048 TRANSPO SYS IMPR AREA C-2 215,970 049 TRANSPO SYS IMPR AREA G 99,544 051 CAPITAL OUTLAY FUND 3,941,870 053 CITY SERVICES 8,383,839 054 SANITARY SEWER CAPITAL 10,604,438 055 SEWER CONNECTION FEE 5,144,354 056 SANITARY SEWER SERVICE 8,800,990 057 FED CLEAN WATER PROTECTION ENT 8,334,738 058 RESIDENTIAL STREET IMPROVEMENT 6,046,840 059 SELECT STREET CONSTRUCTION 19,994,615 060 WATER REVENUE 20,319,231 066 ACQUISITION & CONSTRUCTION 5,955,629 067 REGIONAL TRANSP CENTER 463,169 068 SANITATION FUND 5,289,528 069 REFUSE COLLECTION SERVICE 5,242,639 070 EQUIPMENT REPLACEMENT FUND 7,565,091 071 CENTRAL SERVICES (6,247) 073 BUILDING MAINT FUND 1,745,965 13,417,418 .b `J.b,1 / q,1 ts.b Jy 3,l/y,la3 074 075 076 078 080 081 082 083 085 086 087 088 089 090 093 094 095 096 097 100 101 103 104 106 107 109 110 111 120 121 122 123 124 125 127 128 130 131 133 135 136 137 138 139 140 142 143 144 145 147 148 149 152 153 154 155 157 158 160 161 162 164 165 166 167 169 170 172 175 176 177 178 179 180 181 182 183 CIVIC CENTER MAINTENANCE (190,224) FLEET MAINTENANCE/STORES 1,015,747 STORES & PROPERTY CONTROL (468,986) RETIREMENT SYSTEM 1,033,922 LIABILITY AND PROPERTY INS FND 16,193,640 EMPLOYEE GROUP INSURANCE 1,324,557 WORKERS COMPENSATION FUND 18,845,386 PAYROLL REVOLVING 6,688,712 CITY YARD OPERATION (571,877) PUB WKS ENG/PROJ MGMT (1,037,626) PT RETIREMENT FUND 11,894 QUALITY SERVICE TRAINING 45,230 CA SEISMIC HAZARD PROGRAM 18,453 ORANGE CO SANITATION DIST 2&3 576,371 BUSINESS IMPROVEMENT DISTRICT 55,848 INTEREST AGENCY - POLICE COMMISSARY ACCOUNT 333,186 SA TOURISM MARKETING DISTRICT 123,509 POLICE SEIZED ASSETS 2,083,924 SECTION 457 FIDUCIARY ADMIN 84,366 PUB WKS-ADMIN & PLANNING 3,137,831 PMA RETIREE HEALTH INSURANCE 16,187 SEIU RETIREE HEALTH INSURANCE 22,632 MGMT RETIREE HEALTH INSURANCE 5,776 UC RETIREE HEALTH INSURANCE 2,111 INFO SYS STRATEGIC PLAN 12,905,248 STRONG MOTION INSTRUMENTATION 107,208 OPIOID REMEDIATION 1,178,971 FIRE FACILITIES FUND 2,506,118 SPECIAL REPAIR/DEMOLITION 707,777 EMERGENCY & HEALTH GRANTS 11,368,696 WORKFORCE INVESTMENT ACT (668,444) ORANGE COUNTY SSA GRANTS (83,007) OES UASI (2,896,745) D.O.J. GRANT FUND 41,059 POLICE BLOCK GRANTS 2,160,686 HOME PROGRAM FEDERAL GRANT 2,090,932 MISC GRANTS 1,248 HOUSING AUTHORITY -ISSUER FEE 2,643,376 COMMUNITY DEV BLOCK GRANT (425,855) HOUSING AUTHORITY -VOUCHER HAP 1,035,278 HOUSING AUTHORITY- MAINSTREAM - HOUSING AUTHORITY -MS 5 (25,618) HOUSING AUTHORITY -NEW CONSTR 317,725 HOUSING AUTHORITY -VOUCHER ADM 3,000,136 NSP FEDERAL GRANT 141,149 CALHOME MFGD HSG LOAN 714,103 PRISON TO EMPLOYMENT PROGRAM - RENTAL REHABILITATION GRANT 48,749 FEDERAL AID SAFETY PROGRAM (576,247) TRAFFIC SYSTEM MGMT GRANT (2,623,378) WIC ASSESSMENT DIST ST IMPRV 33,133 PUBLIC LIBRARY GRANT FUND 4,671,479 LIBRARY GRANTS - LIBRARY SVCS & TECHNOLOGY ACT OCJP GRANT HSG ADMIN CARES ACT COVID-19 - PLANNING GRANTS PROGRAM 6,892,752 HSG HAP CARES ACT COVID-19 - PRCSA CAPITAL GRANTS (1,691,370) ENERGY CONSERVATION PROGRAM (59,446) PUB WKS-WTR QUALITY & CONTROL (4,291,562) OFFICE OF SAFETY GRANT 97,803 US DO] ASSET FORFEITURE FUND 1,606,478 US TREASURY ASSET FORFEITURE 207,554 RECREATION GRANTS FUND 647,275 MS5 HAP CARES ACT COVID-19 - NATL RECREATION TRAILS FND ACT 17,329 CARES ACT - CESF - CARES ACT - State - EMERGENCY RENTAL ASSISTANCE PG 3,285,238 COVID RELIEF FUND (656,492) GENERAL FIXED ASSETS (27,879) ARPA EHV ADMIN FEES (61,797) AMERICAN RESCUE PLAN ACT 99,393,123 HOME -ARP PROGRAM FEDERAL GRANT (9,705) ARPA - CA FOR ALL YOUTH WDP (513,339) 201 202 203 204 205 206 207 209 210 211 212 213 221 222 223 224 225 226 301 311 312 313 314 315 400 403 404 406 417 418 607 652 654 655 658 670 671 980 981 991 992 993 998 999 LOCAL DRAINAGE AREA NO 1 134 LOCAL DRAINAGE AREA NO 2 1,447 LOCAL DRAINAGE AREA NO 3 764,239 LOCAL DRAINAGE AREA NO 4 1,068 LOCAL DRAINAGE AREA NO 5 607 LOCAL DRAINAGE AREA NO 6 891 LOCAL DRAINAGE AREA NO 7 196,540 LOCAL DRAINAGE AREA NO 9 741 LOCAL DRAINAGE AREA NO 10 17,379 LOCAL DRAINAGE AREA NO 11 225 LOCAL DRAINAGE AREA NO 12 13 LOCAL DRAINAGE AREA NO 13 2,730 LOCAL DRAINAGE AREA 1 1,082,824 LOCAL DRAINAGE AREA II 285,310 LOCAL DRAINAGE AREA III 426,045 LOCAL DRAINAGE AREA IV 519,908 LOCAL DRAINAGE AREA V 284,443 LOCAL DRAINAGE AREA VI 387,294 REC/COMM SVS 6,115 RESIDENTIAL DEVELOP DISTRICT 1 987,594 RESIDENTIAL DEVELOP DISTRICT 2 3,574,654 RESIDENTIAL DEVELOP DISTRICT 3 14,132,733 RESIDENTIAL DEVELOP DISTRICT 4 376,282 RESIDENTIAL DEVELOP HARBOR SPECFIC 1,689,750 POLICE UUT LEASE REVENUE BONDS 20,938 SCAG GRANTS - COSA 2014 LEASE FINANCING 71,222 2021 PENSION OBLIGATION BONDS 18,270 INCLUSIONARY HOUSING FEE 12,965,582 CDA - PEEBLER CAPITAL FUND 348,173 HOUSING AUTHORITY LMIHF 5,077,949 2003A SERIES TAX ALLOC BOND - 2011A SERIES TAX ALLOC BOND - 2018A SERIES TAX ALLOC BOND 11,781 2003B SERIES ALLOC BOND - COSA RDA 567,552 COSA RDA OBLIGATION RETIREMENT 10,919,031 SAN JUANQUIN TRANS CORRIDOR - EASTERN FOOTHILL TRANS CORRIDO - TRAN SYS IMP AUT C-2 TUSTIN 2,629,731 TRAN SYS IMP AUT AREA D-TUSTIN 11,011,190 WIC ASSESSMENT DISTRICT 421,332 TREASURERS AGENCY COLLECTIONS - Lawson Clearing 2,078 Reconciling Item(s) - Outstanding Checks * 4,280,023 Reconciling Item(s) - Bank Direct Deposits* 155,999 Reconciling Item(s) - Deposits in Transit* (1,116,519.90) Reconciling Item(s) - Withdrawals in Transit* - Reconciling Item(s) - Condemnation FUND JE 395,000 Reconciling Item(s) - Various* 139,016