The URL can be used to link to this page

Home My WebLink AboutItem 08 - Quarterly Report of Investments as of September 30, 20238. Receive and File Quarterly Report of Investments as of September 30, 2023 Department(s): Recommended Action: Receive and file Quarterly Report of Investments as of September 30, 2023. Finance and Management Services www.santa-ana.org/finance Item # 8 City of Santa Ana 20 Civic Center Plaza, Santa Ana, CA 92701 Staff Report November 21, 2023 TOPIC: Periodic Quarterly Report of Investments as of September 30, 2023 AGENDA TITLE Receive and File Quarterly Report of Investments as of September 30, 2023 RECOMMENDED ACTION Receive and file Quarterly Report of Investments as of September 30, 2023. GOVERNMENT CODE §84308 APPLIES: No 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 October 30, 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 September 30, 2023. Quarterly Report of Investments November 21, 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 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 September 30, 2023. Type of Investment Amounts Invested $ Portfolio % COSA Policy Limits State Law Limits a Certificates of Deposit (CDs) $6,696,000 1.44% 30% 30% Federal Farm Credit Bank (FFCB) $54,424,085 11.70% None None Federal Home Loan Bank (FHLB) $229,371,209 49.30% None None Federal Home Loan Mortgage Corp. (FHLMC) $48,971,750 10.53% None None Federal National Mortgage Association (FNMA) $59,484,750 12.79% None None Local Agency Investment Fund (LAIF) $13,702,036 2.95% None None Local Agency Investment Fund (LAIF — ARPA) $47,589,190 10.23% None None U.S. Treasury $4,990,000 1.07% None None Sub- Total: $465,229,020 100% None None Cash : $32,346,231 Total: $497,575,251 Restricted Cash In $ Restricted Cash t $13,542,964 Total $13,542,964 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 respective investment tvges as of September 30. 2023. U.S. Treasury 1.07% LAIF 2.95% LAIF(ARPA) 10.23% FNMA 12.79% 10.53% City of Santa Ana Investment Portfolio September 2023 :4 N14 Co 1.44 % FFCB 11.70% FHLB 49.30% Quarterly Report of Investments November 21, 2023 Page 3 The following table represents, as of September 30, 2023, the aggregate Average Market. Aggregate Average Market Yield To Date Average Month To Date (AMTD) 1 1.663% 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). 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: Steven A. Mendoza, Acting City Manager EXHIBIT 1 City of Santa Ana Portfolio Management Portfolio Summary September 30, 2023 Par Market Book % of Days to YTM/C Investments Value Value Value Portfolio Term Maturity Certificates of Deposit 6,696,000.00 5,991,173.67 6,696,000.00 1.44 1,653 1,005 1.181 Local Agency Investment Funds 13,702,035.99 13,702,035.99 13,702,035.99 2.95 1 1 3.534 Cash in Banks 47,589,190.42 47,589,190.42 47,589,190.42 10.23 1 1 3.353 Federal Agency Coupon Securities 382,675,000.00 354,313,132.25 382,610,705.25 82.24 1,576 283 1.296 Federal Agency Discount Securities 10,000,000.00 9,743,100.00 9,641,088.89 2.07 248 187 5.482 Treasury Coupon Securities 5,000,000.00 4,864,050.00 4,990,000.00 1.07 837 273 1.839 465,662,226.41 436,202,682.33 465,229,020.55 100.00% 1,334 254 1.663 Investments Cash Passbook/Checking (not included in yield calculations) Total Cash and Investments 32,346,230.73 32,346,230.73 32,346,230.73 498,008,457.14 468,548,913.06 497,575,251.28 Total Earnings September 30 Month Ending Fiscal Year To Date Current Year 678,351.41 2,358,463.66 0.000 1,334 254 1.663 Average Daily Balance 521,417,323.42 557,988,023.95 Effective Rate of Return 1.58% 1.68% 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 09/01/2023-09130/2023 Run Date: 10/20/2023 - 10:48 Portfolio COSA CID PM (PRF_PM1) 7.3.11 Report Ver. 7.3.11 City of Santa Ana Portfolio Management Portfolio Details - Investments September 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 218,534.33 248,000.00 0.600 0.592 0.600 954 05/12/2026 02568KAJ4 14043 American Equity Bank 11/26/2021 248,000.00 218,758.07 248,000.00 0.700 0.690 0.700 969 05/27/2026 70962LAV4 14050 PENTAGON FCU 11/10/2021 248,000.00 216,904.35 248,000.00 1.000 0.986 1.000 1,136 11/10/2026 549104ZS9 14046 LUANA SAVINGS BK 11/05/2021 248,000.00 214,497.66 248,000.00 0.600 0.592 0.600 1,131 11/05/2026 87165FD76 14047 SYNCHRONY BANK 11/05/2021 248,000.00 218,005.62 248,000.00 1.100 1.085 1.100 1,131 11/05/2026 02589ABT8 14078 AMERICA EXPRESS NATL BK 03/16/2022 248,000.00 222,112.02 248,000.00 2.000 1.973 2.000 1,262 03/16/2027 15721UET2 14044 CFBANK 11/10/2021 248,000.00 218,267.75 248,000.00 0.850 0.838 0.850 1,013 07/10/2026 32022EAUO 14065 FIRST FEDERAL 12/29/2021 248,000.00 226,624.83 248,000.00 0.850 0.838 0.850 698 08/29/2025 88413QDE5 14056 THIRD FEDERAL S&L 11/24/2021 248,000.00 229,277.84 248,000.00 0.800 0.789 0.800 600 05/23/2025 07371AH22 14084 BEAL BANK PLANO TX 03/30/2022 248,000.00 223,957.19 248,000.00 2.250 2.219 2.250 1,270 03/24/2027 38149MR47 14064 GOLDMAN SACHS 12/22/2021 248,000.00 224,598.15 248,000.00 1.000 0.986 1.000 813 12/22/2025 856285YQ8 14057 ST BK INDIA NY 11/29/2021 248,000.00 217,810.61 248,000.00 1.150 1.134 1.150 1,156 11/30/2026 14042TEP8 14079 CAPITAL ONE BANK 03/16/2022 248,000.00 222,107.96 248,000.00 2.000 1.973 2.000 1,262 03/16/2027 59013KPNO 14049 MERRICK BANK 11/09/2021 248,000.00 217,602.07 248,000.00 1.100 1.085 1.100 1,135 11/09/2026 30781JAW0 14054 FARMERS & MERCHANTS 11/19/2021 248,000.00 215,571.50 248,000.00 0.850 0.838 0.850 1,145 11/19/2026 05580AH64 14061 BMW BANK OF NA 12/17/2021 248,000.00 234,375.90 248,000.00 0.950 0.937 0.950 443 12/17/2024 45776NEN2 14062 INSBANK 12/20/2021 248,000.00 219,433.48 248,000.00 0.900 0.888 0.900 992 06/19/2026 58404DMQ1 14063 MEDALLION BK UT 12/20/2021 248,000.00 217,809.92 248,000.00 1.250 1.233 1.250 1,177 12/21/2026 89235MMB4 14052 TOYOTA FINANCIAL 11/12/2021 248,000.00 217,850.22 248,000.00 1.100 1.085 1.100 1,138 11/12/2026 292079AR1 14045 EMPIRE ST BK NA 11/12/2021 248,000.00 219,493.74 248,000.00 0.900 0.888 0.900 1,016 07/13/2026 07371CT25 14085 BEAL BANK USA 03/30/2022 248,000.00 223,957.19 248,000.00 2.250 2.219 2.250 1,270 03/24/2027 73319FBJ7 14053 POPPY BANK 11/17/2021 248,000.00 215,313.20 248,000.00 0.800 0.789 0.800 1,143 11/17/2026 320337EZ7 14048 FIRST GENERAL BK 11/05/2021 248,000.00 231,396.05 248,000.00 0.500 0.493 0.500 493 02/05/2025 39573LCCO 14055 GREENSTATE CU 11/23/2021 248,000.00 224,580.81 248,000.00 0.900 0.888 0.900 785 11/24/2025 61768U3U9 14082 MORGAN STANLEY PVT BANK 03/31/2022 248,000.00 223,931.40 248,000.00 2.250 2.219 2.250 1,276 03/30/2027 61773TCX9 14083 MORGAN STANLEY PVT BANK 03/31/2022 248,000.00 223,931.40 248,000.00 2.250 2.219 2.250 1,276 03/30/2027 795451BA0 14060 SALLIE MAE BANK 12/15/2021 248,000.00 234,470.41 248,000.00 1.000 0.986 1.000 442 12/16/2024 Subtotal and Average 6,696,000.00 6,696,000.00 5,991,173.67 6,696,000.00 1.165 1.181 1,005 Local Agency Investment Funds LAIFCITY LAIFCITY Local Agency Investment Fund 13,702,035.99 13,702,035.99 13,702,035.99 3.534 3.486 3.534 1 Subtotal and Average 23,368,702.66 13,702,035.99 13,702,035.99 13,702,035.99 3.486 3.534 1 Cash in Banks LAIF ARPA LAIF ARPA Local Agency Investment Fund 47,589,190.42 47,589,190.42 47,589,190.42 3.353 3.307 3.353 1 Run Date: 10/20/2023 - 10:48 Portfolio COSA CID PM (PRF_PM2) 7.3.11 Report Ver. 7.3.11 City of Santa Ana Portfolio Management Portfolio Details - Investments September 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 86,509,164.62 47,589,190.42 47,589,190.42 47,589,190.42 3.307 3.353 1 Federal Agency Coupon Securities 3133EJ5W5 13868 Federal Farm Credit Bank 01/29/2019 925,000.00 923,492.25 924,195.25 2.650 2.634 2.670 22 10/23/2023 3133EKBW5 13876 Federal Farm Credit Bank 03/04/2019 3,000,000.00 2,965,620.00 2,998,740.00 2.610 2.583 2.619 149 02/27/2024 3133EK3M6 13934 Federal Farm Credit Bank 10/23/2019 5,000,000.00 4,989,100.00 5,003,650.00 1.625 1.584 1.606 22 10/23/2023 3133ELX33 13974 Federal Farm Credit Bank 07/22/2020 6,000,000.00 5,524,380.00 6,000,000.00 0.690 0.681 0.690 660 07/22/2025 3133EMBH4 13988 Federal Farm Credit Bank 09/29/2020 5,000,000.00 4,558,150.00 5,000,000.00 0.530 0.523 0.530 729 09/29/2025 3133EMFR8 13991 Federal Farm Credit Bank 11/03/2020 5,000,000.00 4,533,550.00 4,997,500.00 0.540 0.543 0.550 764 11/03/2025 3133EMSU7 14005 Federal Farm Credit Bank 03/09/2021 4,000,000.00 3,598,440.00 4,000,000.00 0.800 0.789 0.800 890 03/09/2026 3133EMUP5 14006 Federal Farm Credit Bank 04/01/2021 6,000,000.00 5,592,180.00 6,000,000.00 0.710 0.692 0.701 548 04/01/2025 3133EMWH1 14016 Federal Farm Credit Bank 04/21/2021 5,000,000.00 4,657,600.00 5,000,000.00 0.710 0.700 0.710 568 04/21/2025 3133EM2C5 14032 Federal Farm Credit Bank 08/10/2021 6,000,000.00 5,301,780.00 6,000,000.00 0.710 0.700 0.710 1,044 08/10/2026 3133ENPB0 14075 Federal Farm Credit Bank 02/16/2022 3,500,000.00 3,182,375.00 3,500,000.00 2.180 2.150 2.180 138 02/16/2027 3133ENUH1 14086 Federal Farm Credit Bank 04/12/2022 2,000,000.00 1,890,200.00 2,000,000.00 3.330 3.284 3.330 1,289 04/12/2027 3133ENVV9 14088 Federal Farm Credit Bank 05/03/2022 3,000,000.00 2,839,260.00 3,000,000.00 3.630 3.580 3.630 1,310 05/03/2027 3130AFW94 13873 Federal Home Loan Bank 02/27/2019 2,000,000.00 1,977,820.00 1,996,220.00 2.500 2.506 2.541 135 02/13/2024 3130AB3H7 13889 Federal Home Loan Bank 04/29/2019 3,000,000.00 2,959,620.00 2,999,250.00 2.375 2.348 2.380 159 03/08/2024 3130AKPQ3 13996 Federal Home Loan Bank 01/28/2021 4,000,000.00 3,595,000.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,487,250.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,382,120.00 6,000,000.00 0.500 0.493 0.500 119 01/28/2026 3130ALA53 13999 Federal Home Loan Bank 02/25/2021 5,000,000.00 4,481,800.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,485,050.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,655,450.00 5,000,000.00 0.375 0.370 0.375 147 02/25/2025 3130ALDZ4 14003 Federal Home Loan Bank 03/10/2021 4,000,000.00 3,725,800.00 4,000,000.00 0.500 0.493 0.500 70 03/10/2025 3130ALKN3 14004 Federal Home Loan Bank 03/24/2021 4,000,000.00 3,807,240.00 4,000,000.00 0.500 0.493 0.500 84 09/24/2024 3130ALLP7 14007 Federal Home Loan Bank 03/29/2021 6,000,000.00 5,596,260.00 5,997,000.00 0.650 0.658 0.667 77 03/17/2025 3130ALW67 14008 Federal Home Loan Bank 04/22/2021 5,000,000.00 4,514,350.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,375,400.00 6,000,000.00 1.050 1.036 1.050 90 06/30/2026 3130AMYC0 14025 Federal Home Loan Bank 06/30/2021 6,000,000.00 5,413,800.00 6,000,000.00 1.000 0.986 1.000 90 03/30/2026 3130AMSF0 14026 Federal Home Loan Bank 06/28/2021 6,000,000.00 5,774,880.00 6,000,000.00 0.400 0.395 0.400 88 06/28/2024 3130ANFU9 14027 Federal Home Loan Bank 07/29/2021 5,000,000.00 4,442,250.00 5,000,000.00 0.850 0.838 0.850 1,032 07/29/2026 3130ANFG0 14028 Federal Home Loan Bank 08/18/2021 5,000,000.00 4,479,300.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,483,000.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,709,750.00 5,000,000.00 0.550 0.542 0.550 445 12/19/2024 3130ANPE4 14034 Federal Home Loan Bank 08/26/2021 6,000,000.00 5,506,860.00 6,000,000.00 0.700 0.690 0.700 330 08/26/2025 3130ANQ78 14035 Federal Home Loan Bank 08/27/2021 6,000,000.00 5,323,020.00 6,000,000.00 0.900 0.888 0.900 1,061 08/27/2026 3130AP3E3 14036 Federal Home Loan Bank 09/30/2021 5,000,000.00 4,446,450.00 5,000,000.00 0.820 0.809 0.820 1,095 09/30/2026 Portfolio COSA CID Run Date: 10/20/2023 - 10:48 PM (PRF_PM2) 7.3.11 City of Santa Ana Portfolio Management Portfolio Details - Investments September 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 3130ANX62 14037 Federal Home Loan Bank 09/30/2021 5,000,000.00 4,611,050.00 5,000,000.00 0.650 0.641 0.650 90 06/30/2025 3130APB79 14038 Federal Home Loan Bank 09/30/2021 5,000,000.00 4,435,100.00 5,000,000.00 1.000 0.986 1.000 1,095 09/30/2026 3130AP3A1 14039 Federal Home Loan Bank 09/29/2021 5,000,000.00 4,454,850.00 4,998,750.00 0.850 0.848 0.860 89 06/29/2026 3130APB46 14040 Federal Home Loan Bank 10/13/2021 10,000,000.00 8,844,500.00 10,000,000.00 0.950 0.937 0.950 12 10/13/2026 3130APQC2 14041 Federal Home Loan Bank 11/23/2021 5,000,000.00 4,847,650.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,480,700.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,460,900.00 4,997,500.00 1.375 1.382 1.401 61 12/01/2026 3130AQAB9 14059 Federal Home Loan Bank 12/30/2021 3,750,000.00 3,364,800.00 3,750,000.00 1.625 1.603 1.625 90 12/30/2026 3130AQLQ4 14069 Federal Home Loan Bank 01/27/2022 5,000,000.00 4,473,900.00 5,000,000.00 1.650 1.628 1.650 26 01/27/2027 3130AQKM4 14070 Federal Home Loan Bank 01/28/2022 1,500,000.00 1,346,505.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,693,280.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,495,850.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,519,500.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,366,155.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,852,880.00 3,000,000.00 2.000 1.973 2.000 84 03/24/2025 3130ARC82 14077 Federal Home Loan Bank 03/29/2022 3,000,000.00 2,738,760.00 3,000,000.00 2.100 2.071 2.100 1,275 03/29/2027 3130ARR60 14087 Federal Home Loan Bank 04/29/2022 2,000,000.00 1,929,560.00 2,000,000.00 3.100 3.058 3.100 28 04/29/2025 3130ASLJ6 14090 Federal Home Loan Bank 06/29/2022 20,000,000.00 19,885,400.00 20,000,000.00 3.100 2.028 2.056 89 12/29/2023 3130AVCN0 14092 Federal Home Loan Bank 03/13/2023 2,000,000.00 1,998,460.00 2,000,000.00 5.375 5.301 5.375 164 03/13/2024 3130AVDB5 14093 Federal Home Loan Bank 03/30/2023 2,000,000.00 1,982,160.00 2,000,000.00 6.000 5.918 6.000 179 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 29 10/30/2023 3130AVB84 14103 Federal Home Loan Bank 07/28/2023 4,000,000.00 3,990,840.00 3,991,400.00 5.250 5.368 5.443 348 09/13/2024 3134GVQX9 13962 Federal Home Loan Mortgage Co. 05/05/2020 5,000,000.00 4,642,950.00 4,995,000.00 0.700 0.711 0.720 582 05/05/2025 3134GVVX3 13964 Federal Home Loan Mortgage Co. 05/28/2020 5,000,000.00 4,635,550.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,540,940.00 6,000,000.00 0.700 0.690 0.700 268 06/25/2025 3134GVT99 13968 Federal Home Loan Mortgage Co. 06/30/2020 6,000,000.00 5,545,380.00 6,000,000.00 0.650 0.641 0.650 638 06/30/2025 3134GV5R5 13979 Federal Home Loan Mortgage Co. 07/15/2020 6,000,000.00 5,768,700.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,554,900.00 5,000,000.00 0.500 0.493 0.500 90 09/30/2025 3134GW4Z6 13989 Federal Home Loan Mortgage Co. 10/27/2020 6,000,000.00 5,451,420.00 6,000,000.00 0.540 0.533 0.540 26 10/27/2025 3134GXJL9 13995 Federal Home Loan Mortgage Co. 12/30/2020 6,000,000.00 5,400,600.00 6,000,000.00 0.500 0.493 0.500 90 12/30/2025 3134GYZ21 14105 Federal Home Loan Mortgage Co. 08/02/2023 4,000,000.00 3,952,680.00 3,978,000.00 5.000 5.221 5.294 305 08/01/2025 3135GOX24 13940 Federal Nafl Mtg. Assoc. 01/15/2020 5,000,000.00 4,771,850.00 4,990,750.00 1.625 1.641 1.664 464 01/07/2025 3135GOW66 13941 Federal NaVI Mtg. Assoc. 01/15/2020 5,000,000.00 4,805,450.00 4,994,000.00 1.625 1.629 1.651 380 10/15/2024 3136G4WV1 13965 Federal NaVI Mtg. Assoc. 06/16/2020 5,000,000.00 4,625,450.00 5,000,000.00 0.750 0.740 0.750 624 06/16/2025 3136G4D42 13976 Federal Nafl Mtg. Assoc. 07/28/2020 8,000,000.00 7,336,560.00 8,000,000.00 0.510 0.503 0.510 666 07/28/2025 3136G4C43 13977 Federal Nafl Mtg. Assoc. 08/14/2020 6,000,000.00 5,508,480.00 6,000,000.00 0.650 0.641 0.650 683 08/14/2025 Portfolio COSA CP Run Date: 10/20/2023 - 10:48 PM (PRF_PM2) 7.3.11 City of Santa Ana Portfolio Management Portfolio Details - Investments September 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 3136G4G98 13978 Federal Nat'I Mtg. Assoc. 08/12/2020 6,000,000.00 5,500,080.00 6,000,000.00 0.560 0.552 0.560 42 08/12/2025 3136G45Q2 13990 Federal Nat'I Mtg. Assoc. 10/28/2020 6,000,000.00 5,444,880.00 6,000,000.00 0.530 0.523 0.530 27 10/28/2025 3135GA4V0 13992 Federal Nat'l Mtg. Assoc. 11/25/2020 5,000,000.00 4,530,700.00 5,000,000.00 0.625 0.616 0.625 55 11/25/2025 3135GAAN1 13993 Federal Nat'l Mtg. Assoc. 12/17/2020 6,000,000.00 5,420,700.00 6,000,000.00 0.600 0.592 0.600 77 12/17/2025 3135G06J7 13994 Federal Nat'l Mtg. Assoc. 12/10/2020 6,000,000.00 5,431,140.00 6,000,000.00 0.650 0.641 0.650 70 12/10/2025 3135GAG62 14094 Federal Nat'I Mtg. Assoc. 03/30/2023 1,500,000.00 1,495,425.00 1,500,000.00 5.220 5.148 5.220 90 04/26/2024 Subtotal and Average 390,212,367.25 382,675,000.00 354,313,132.25 382,610,705.25 1.280 1.298 283 Federal Agency Discount Securities 313384VE6 14104 Federal Home Loan Bank 08/01/2023 10,000,000.00 9,743,100.00 9,641,088.89 5.210 5.482 5.558 187 04/05/2024 Subtotal and Average 9,641,088.89 10,000,000.00 9,743,100.00 9,641,088.89 5.482 5.558 187 Treasury Coupon Securities 9128286Z8 14081 U.S. Treasury 03/16/2022 5,000,000.00 4,864,050.00 4,990,000.00 1.750 1.814 1.839 273 06/30/2024 Subtotal and Average 4,990,000.00 5,000,000.00 4,864,050.00 4,990,000.00 1.814 1.839 273 Total and Average 521,417,323.42 465,662,226.41 436,202,682.33 465,229,020.55 Run Date: 10/20/2023 - 10:48 1.644 1.667 254 Portfolio COSA CID PM (PRF_PM2) 7.3.11 City of Santa Ana Portfolio Management Portfolio Details - Cash September 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,344.00 83,344.00 83,344.00 0.000 0.000 1 HOUSING 13943 JP MORGAN CHASE 4,758,973.68 4,758,973.68 4,758,973.68 0.000 0.000 1 WORKERS COMPENS 37983 JP MORGAN CHASE 2,481,220.09 2,481,220.09 2,481,220.09 0.000 0.000 1 GENERAL LIABILI 38130 JP MORGAN CHASE 2,166,229.69 2,166,229.69 2,166,229.69 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 333,336.51 333,336.51 333,336.51 0.000 0.000 1 COMMISSARY 7962 JPMorgan Chase 363,185.04 363,185.04 363,185.04 0.000 0.000 1 GENERAL ACCOUNT 9500 JPMorgan Chase 21,366,917.64 21,366,917.64 21,366,917.64 0.000 0.000 1 FSS FSS Santa Ana Federal Credit Union 756,447.28 756,447.28 756,447.28 0.000 0.000 1 Average Balance 0.00 1 Total Cash and Investments 521,417,323.42 498,008,457.14 468,548,913.06 497,575,251.28 1.644 1.667 254 Run Date: 10/20/2023 - 10:48 Portfolio COSA CID PM (PRF_PM2) 7.3.11 CUSIP Investment # Issuer CASH/SECURITIES HELD IN TRUST Portfolio Management Portfolio Details - Investments September 30, 2023 Par Value Market Value Book Value Page 1 Digitally signed Carey Li Li Da Carey 3 Date: 202.10.11 08:08:47-07'00' Money Market Accounts X9USDDTPC 80364 Dreyfus Treasury 10,571.40 10,571.40 10,571.40 X9USDDTPC 80365 Dreyfus Treasury 11,287.02 11,287.02 11,287.02 SYS80464 80366 Dreyfus Treasury 131.53 131.53 131.53 X9USDDEFU--- 80107 INSTIL RES THE AND AGNY CASH 9,640.08 9,640.08 9,640.08 X9USDDEFU 80389 INSTIL RES THE AND AGNY CASH 2,834.69 2,834.69 2,834.69 X9USDDEFU 80391 INSTIL RES THE AND AGNY CASH 182.79 182.79 182.79 9AMMF05B2-- 80406 US BANK MONEY MARKET 0.76 0.76 0.76 9AMMF05B2- 80407 US BANK MONEY MARKET 0.87 0.87 0.87 SYS80418 80418 US BANK MONEY MARKET 500,994.99 500,994.99 500,994.99 SYS80419 80419 US BANK MONEY MARKET 105,343.76 105,343.76 105,343.76 SYS80421 80421 US BANK MONEY MARKET 5.37 5.37 5.37 31846V401 80430 US BANK MONEY MARKET 6,911.21 6,911.21 6,911.21 31846V401- 80432 US BANK MONEY MARKET 11,664.28 11,664.28 11,664.28 X9USDMOR3 80248 MORGAN STANLEY GOVT INSTIL 1.02 1.02 1.02 X9USDMOR3 80465 MORGAN STANLEY GOVT INSTIL 655.98 655.98 655.98 X9USDMOR3 80466 MORGAN STANLEY GOVT INSTIL 28.34 28.34 28.34 Subtotal and Average 660,254.09 660,254.09 660,254.09 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 10,042,313.38 9,688,646.88 10,042,313.38 Subtotal and Average 10,042,315.38 9,688,648.88 10,042,315.38 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 Run Date: 10/10/2023 - 09:04 13, 542,964.34 13,189,297.84 13, 542, 964.34 Portfolio TRST AC PM (PRF_PM2) 7.3.11 Report Ver. 7.3.11 EXHIBIT 2 Investments Amount Bank of New York Mellon - Investment Custodian 403,937,794 Local Agency Investment Fund (L.A.I.F) 13,702,036 Local Agency Investment Fund (L.A.I.F) - ARPA 47,589,190 Total - Investments 465,229,021 Cash Held at City Financial Institution(s) and Cash on Hand Amount General Account 21,366,918 General Liability Account 2,166,230 Housing Account 4,758,974 Workers Compensation Account 2,481,220 Santa Ana Federal Credit Union - Family Self Sufficiency (FSS-Housinc 756,447 Commissary Account 363,185 Flexible Benefit Spending Account 333,337 Property Management Account 35,084 Property Management - Phase 2 Account 1,493 Petty Cash 83,344 Total - Cash Held at City Financial Institution(s) and Cash on Hand 32,346,231 Restricted Cash Amount Signature Bank - Streetlight Project 1,268,870 US Bank - Pension Stability Funds (Section 115 Trust with PARS) 10,543,308 State of California Condemnation Fund - Right of Way Deposits 1,571,525 Various US Bank & BNY 159,261 Total - Restricted Cash 13,542,964 Total Cash Held City at Financial Institution(s), Cash on Hand and Restricted Cash 511,118,216 Cash by Fund(s) - Total (see below for listing) 511,118,216 Fund Fund description Amount 011 GENERAL FUND 111,607,989 012 CANNABIS PUBLIC BENEFIT 23,526,575 016 CASP CERTIFICATION & TRAINING 440,545 020 OTS-TRAFFIC OFFENDER PROGRAM 31,200 021 PRCSA CAN FUND 1,852,257 022 PRCSA FEE & DONATION 985,571 023 INMATE WELFARE FUND 2,183,346 024 PD ATHLETIC ACTIVITIES LEAGUE (170,718) 025 IDB & EZ VOUCHER MONITORING 187,928 026 ASSET FORFEITURE FUND 163,549 027 PARKING FUND 3,787,887 029 SPECIAL GAS TAX 31,551,841 030 PROP 1B BOND ACT OF 2006 155,720 031 AIR QUALITY IMPR. (AB 2766) 1,353,443 032 MEASURE M-STREET CONSTRUCTION (9,853,267) 033 NEW TRANSPO SYS IMPR AREA B 582,798 034 NEW TRANSPO SYS IMPR AREA E 1,740,865 035 NEW TRANSPO SYS IMPR AREA F 2,119,128 041 TRANSP SYS IMPR AREA A-2 708,748 042 TRANSPO SYS IMPR AREA B 9,704 048 TRANSPO SYS IMPR AREA C-2 216,754 049 TRANSPO SYS IMPR AREA G 99,906 051 CAPITAL OUTLAY FUND 3,331,619 053 CITY SERVICES 8,212,981 054 SANITARY SEWER CAPITAL 9,243,543 055 SEWER CONNECTION FEE 4,906,074 056 SANITARY SEWER SERVICE 8,807,162 057 FED CLEAN WATER PROTECTION ENT 8,350,422 058 RESIDENTIAL STREET IMPROVEMENT 6,238,487 059 SELECT STREET CONSTRUCTION 21,971,265 060 WATER REVENUE 12,259,196 066 ACQUISITION & CONSTRUCTION 4,751,620 067 REGIONAL TRANSP CENTER 479,757 068 SANITATION FUND 4,709,207 069 REFUSE COLLECTION SERVICE 5,928,435 070 EQUIPMENT REPLACEMENT FUND 7,925,243 073 BUILDING MAINT FUND 1,796,943 074 CIVIC CENTER MAINTENANCE (512,184) 075 FLEET MAINTENANCE/STORES 1,190,738 076 STORES & PROPERTY CONTROL (411,486) 078 RETIREMENT SYSTEM (5,039,391) 080 LIABILITY AND PROPERTY INS FND 8,559,710 081 EMPLOYEE GROUP INSURANCE 1,687,021 082 WORKERS COMPENSATION FUND 18,629,772 083 PAYROLL REVOLVING 9,727,237 085 CITY YARD OPERATION (544,614) 086 PUB WKS ENG/PROJ MGMT (1,850,768) 087 PT RETIREMENT FUND 10,179 088 QUALITY SERVICE TRAINING 31,038 089 CA SEISMIC HAZARD PROGRAM 30,828 090 ORANGE CO SANITATION DIST 2&3 557,169 093 BUSINESS IMPROVEMENT DISTRICT 57,276 095 POLICE COMMISSARY ACCOUNT 318,082 096 SA TOURISM MARKETING DISTRICT 135,689 097 POLICE SEIZED ASSETS 2,300,384 100 SECTION 457 FIDUCIARY ADMIN 96,404 101 PUB WKS-ADMIN & PLANNING 3,208,817 103 104 106 107 109 110 111 120 121 122 123 124 125 127 128 130 131 133 135 136 138 139 140 142 143 145 147 148 149 152 158 161 162 164 165 166 167 169 172 177 178 179 180 181 182 183 186 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 404 406 417 418 607 655 670 671 991 992 993 999 PMA RETIREE HEALTH INSURANCE 8,291 SEIU RETIREE HEALTH INSURANCE 53,285 MGMT RETIREE HEALTH INSURANCE 59,496 UC RETIREE HEALTH INSURANCE (3,443) INFO SYS STRATEGIC PLAN 13,347,795 STRONG MOTION INSTRUMENTATION 107,208 OPIOID REMEDIATION 610,015 FIRE FACILITIES FUND 2,353,147 SPECIAL REPAIR/DEMOLITION 709,542 EMERGENCY & HEALTH GRANTS 13,426,142 WORKFORCE INVESTMENT ACT (1,271,348) ORANGE COUNTY SSA GRANTS (175,589) DES UASI (748,190) D.O.J. GRANT FUND 39,051 POLICE BLOCK GRANTS 1,989,031 HOME PROGRAM FEDERAL GRANT 2,210,891 MISC GRANTS 1,248 HOUSING AUTHORITY -ISSUER FEE 2,600,023 COMMUNITY DEV BLOCK GRANT (1,551,468) HOUSING AUTHORITY -VOUCHER HAP 777,484 HOUSING AUTHORITY -MS 5 (41,034) HOUSING AUTHORITY -NEW CONSTR 361,889 HOUSING AUTHORITY -VOUCHER ADM 3,017,238 NSP FEDERAL GRANT 238,822 CALHOME MFGD HSG LOAN 764,812 RENTAL REHABILITATION GRANT 48,926 FEDERAL AID SAFETY PROGRAM (1,218,567) TRAFFIC SYSTEM MGMT GRANT (2,470,900) WIC ASSESSMENT DIST ST IMPRV 33,253 PUBLIC LIBRARY GRANT FUND 4,679,705 PLANNING GRANTS PROGRAM (108,260) PRCSA CAPITAL GRANTS (902,991) ENERGY CONSERVATION PROGRAM (59,446) PUB WKS-WTR QUALITY & CONTROL (5,727,863) OFFICE OF SAFETY GRANT 7,224 US DOI ASSET FORFEITURE FUND 1,584,565 US TREASURY ASSET FORFEITURE 208,308 RECREATION GRANTS FUND 681,024 NATL RECREATION TRAILS FND ACT 17,329 EMERGENCY RENTAL ASSISTANCE PG 3,094,965 COVID RELIEF FUND (590,191) GENERAL FIXED ASSETS (18,516) ARPA EHV ADMIN FEES 128,909 AMERICAN RESCUE PLAN ACT 94,113,737 HOME -ARP PROGRAM FEDERAL GRANT (803) ARPA - CA FOR ALL YOUTH WDP (1,131,651) HCV F S S FORFEITURES 153,865 LOCAL DRAINAGE AREA NO 1 135 LOCAL DRAINAGE AREA NO 2 1,452 LOCAL DRAINAGE AREA NO 3 767,014 LOCAL DRAINAGE AREA NO 4 1,072 LOCAL DRAINAGE AREA NO 5 609 LOCAL DRAINAGE AREA NO 6 894 LOCAL DRAINAGE AREA NO 7 197,254 LOCAL DRAINAGE AREA NO 9 744 LOCAL DRAINAGE AREA NO 10 17,442 LOCAL DRAINAGE AREA NO 11 226 LOCAL DRAINAGE AREA NO 12 13 LOCAL DRAINAGE AREA NO 13 2,740 LOCAL DRAINAGE AREA I 1,102,734 LOCAL DRAINAGE AREA II 286,346 LOCAL DRAINAGE AREA III 427,592 LOCAL DRAINAGE AREA IV 582,786 LOCAL DRAINAGE AREA V 286,903 LOCAL DRAINAGE AREA VI 388,701 REC/COMM SVS 6,138 RESIDENTIAL DEVELOP DISTRICT 1 1,069,200 RESIDENTIAL DEVELOP DISTRICT 2 4,352,531 RESIDENTIAL DEVELOP DISTRICT 3 13,182,868 RESIDENTIAL DEVELOP DISTRICT 4 465,450 RESIDENTIAL DEVELOP HARBOR SPECFIC 1,433,250 POLICE UUT LEASE REVENUE BONDS 1,176,914 COSA 2014 LEASE FINANCING 1,358,909 2021 PENSION OBLIGATION BONDS 25,316 INCLUSIONARY HOUSING FEE 8,954,418 CDA - PEEBLER CAPITAL FUND 530,063 HOUSING AUTHORITY LMIHF 3,786,365 2018A SERIES TAX ALLOC BOND 16,024 COSA RDA 558,562 COSA RDA OBLIGATION RETIREMENT 337,365 TRAN SYS IMP AUT C-2 TUSTIN 2,640,701 TRAN SYS IMP AUT AREA D-TUSTIN 11,133,785 WIC ASSESSMENT DISTRICT 337,068 Lawson Clearing 26,086 Reconciling Item(s) - Outstanding Checks * 3,747,771 Reconciling Item(s) - Bank Direct Deposits* 781,908 Reconciling Item(s) - Deposits in Transit* (431,375.55) Reconciling Item(s) - Withdrawals in Transit* - Reconciling Item(s) - Various* (218,348) Reconciling Item(s) - Various: A difference between Cash held by Financial Institution, Fiscal Agent and Cash on Hand exists when comparing to Cash by Fund due, to reconciling items such as timing of payments; outstanding checks; and deposits in transit