The URL can be used to link to this page

Home My WebLink AboutItem 09 - Receive and File Quarterly Report of Investments as of March 31, 2024 Finance and Management Services www.santa-ana.org/finance Item # 9 City of Santa Ana 20 Civic Center Plaza, Santa Ana, CA 92701 Staff Report May 21, 2024 TOPIC: Quarterly Report of Investments AGENDA TITLE Receive and File Quarterly Report of Investments as of March 31, 2024 RECOMMENDED ACTION Receive and file. 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 and 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 April 23, 2024. 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 March 31, 2024. Quarterly Report of Investments May 21, 2024 Page 2 4 2 5 8 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 March 31, 2024. Type of Investment Amounts Invested $Portfolio % COSA Policy Limits % State Law Limits % Certificates of Deposit (CDs)$6,696,000 1.51%30%30% Federal Farm Credit Bank (FFCB)$47,484,969 10.73%None None Federal Home Loan Bank (FHLB)$217,337,857 49.11%None None Federal Home Loan Mortgage Corp. (FHLMC)$48,971,750 11.07%None None Federal National Mortgage Association (FNMA)$59,484,750 13.44%None None Local Agency Investment Fund (LAIF)$18,659,544 4.22%None None Local Agency Investment Fund (LAIF – ARPA)$28,099,742 6.35%None None California CLASS $2,026,322 0.46%None None U.S. Treasury $13,765,720 3.11%None None Sub- Total:$442,526,654 100%None None Cash :$36,855,021 Total:$479,381,675 Restricted Cash In $ Restricted Cash †,$32,250,225 Total $32,250,225 † 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 types as of March 31, 2024. CD 1.51% FFCB 10.73% FHLB 49.11% FHLMC 11.07% FNMA 13.44 % LAIF 4.22 % LAIF (ARPA) 6.35% California CLASS .46% U.S. Treasury 3.11% CITY OF SANTA ANA INVESTMENT PORTFOLIO MARCH 2024 Quarterly Report of Investments May 21, 2024 Page 3 4 2 5 8 The following table represents, as of March 31, 2024: the aggregate Average Market. Aggregate Average Market Yield To Date Average Month To Date (AMTD)1.853% 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: Alvaro Nuñez, Acting City Manager EXHIBIT 1 City of Santa Ana Portfolio Management Portfolio Summary March 31, 2024 Par Value Market Value Book Value % of Days to Maturity YTM/CInvestmentsTerm 1,653 1 Portfolio Certificates of Deposit 6,696,000.00 6,201,751.23 18,659,544.44 30,126,063.69 343,891,277.50 9,988,500.00 4,955,350.00 8,799,120.00 6,696,000.00 18,659,544.44 30,126,063.69 363,638,237.00 9,641,088.89 4,990,000.00 8,775,720.00 1.51 822 1.181 4.122 4.211 1.376 5.482 1.839 5.241 Local Agency Investment Funds Cash in Banks 18,659,544.44 30,126,063.69 363,750,000.00 10,000,000.00 5,000,000.00 9,000,000.00 4.22 6.81 82.17 2.18 1.13 1.98 1 11 Federal Agency Coupon Securities Federal Agency Discount Securities Treasury Coupon Securities Treasury Strips 1,577 248 837 178 267 4 90 157 443,231,608.13 422,621,606.86 442,526,654.02 100.00%1,340 236 1.853 Investments Cash Passbook/Checking 36,855,021.36 36,855,021.36 36,855,021.36 1 1 0.000 (not included in yield calculations) Total Cash and Investments 480,086,629.49 459,476,628.22 479,381,675.38 1,340 236 1.853 Total Earnings March 31 Month Ending Fiscal Year To Date Current Year 630,742.45 6,408,742.59 Average Daily Balance Effective Rate of Return 490,400,907.46 1.51% 519,435,623.39 1.64% 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 03/01/2024-03/31/2024 Portfolio COSA CP Run Date: 04/19/2024 - 10:21 PM (PRF_PM1) 7.3.11 Report Ver. 7.3.11 City of Santa Ana P o rtfo lio Management P o rtfo lio De ta ils - Inves tments March 31, 2024 Page 1 Average Balance Purchas e Stated Rate YTM/C YTM/C Days to Maturity DateCUSIPInves tment #Is s uer Par Value Market Value Book ValueDate 360 365 Maturity Certificates of Depos it 06417NF73 02568KAJ4 70962LAV4 549104ZS9 87165FD76 02589ABT8 15721UET2 32022EAU0 88413QDE5 07371AH22 38149MR47 856285YQ8 14042TEP8 59013KPN0 30781JAW0 05580AH64 45776NEN2 58404DMQ1 89235MMB4 292079AR1 07371CT25 73319FBJ7 320337EZ7 39573LCC0 61768U3U9 61773TCX9 795451BA0 14051 BANK OZK 11/12/2021 11/26/2021 11/10/2021 11/05/2021 11/05/2021 03/16/2022 11/10/2021 12/29/2021 11/24/2021 03/30/2022 12/22/2021 11/29/2021 03/16/2022 11/09/2021 11/19/2021 12/17/2021 12/20/2021 12/20/2021 11/12/2021 11/12/2021 03/30/2022 11/17/2021 11/05/2021 11/23/2021 03/31/2022 03/31/2022 12/15/2021 248,000.00 248,000.00 248,000.00 248,000.00 248,000.00 248,000.00 248,000.00 248,000.00 248,000.00 248,000.00 248,000.00 248,000.00 248,000.00 248,000.00 248,000.00 248,000.00 248,000.00 248,000.00 248,000.00 248,000.00 248,000.00 248,000.00 248,000.00 248,000.00 248,000.00 248,000.00 248,000.00 226,845.33 227,049.51 225,280.87 223,139.76 226,204.47 230,059.73 226,881.73 233,720.95 236,273.05 231,645.02 231,772.59 226,184.21 229,921.20 226,031.22 224,214.44 240,327.70 227,479.86 226,175.53 226,166.01 227,601.78 231,645.02 223,914.09 237,481.70 231,875.36 231,708.33 231,708.33 240,443.44 248,000.00 248,000.00 248,000.00 248,000.00 248,000.00 248,000.00 248,000.00 248,000.00 248,000.00 248,000.00 248,000.00 248,000.00 248,000.00 248,000.00 248,000.00 248,000.00 248,000.00 248,000.00 248,000.00 248,000.00 248,000.00 248,000.00 248,000.00 248,000.00 248,000.00 248,000.00 248,000.00 0.600 0.700 1.000 0.600 1.100 2.000 0.850 0.850 0.800 2.250 1.000 1.150 2.000 1.100 0.850 0.950 0.900 1.250 1.100 0.900 2.250 0.800 0.500 0.900 2.250 2.250 1.000 0.592 0.690 0.986 0.592 1.085 1.973 0.838 0.838 0.789 2.219 0.986 1.134 1.973 1.085 0.838 0.937 0.888 1.233 1.085 0.888 2.219 0.789 0.493 0.888 2.219 2.219 0.986 0.600 0.700 1.000 0.600 1.100 2.000 0.850 0.850 0.800 2.250 1.000 1.150 2.000 1.100 0.850 0.950 0.900 1.250 1.100 0.900 2.250 0.800 0.500 0.900 2.250 2.250 1.000 771 05/12/2026 786 05/27/2026 953 11/10/2026 948 11/05/2026 948 11/05/2026 1,079 03/16/2027 830 07/10/2026 515 08/29/2025 417 05/23/2025 1,087 03/24/2027 630 12/22/2025 973 11/30/2026 1,079 03/16/2027 952 11/09/2026 962 11/19/2026 260 12/17/2024 809 06/19/2026 994 12/21/2026 955 11/12/2026 833 07/13/2026 1,087 03/24/2027 960 11/17/2026 310 02/05/2025 602 11/24/2025 1,093 03/30/2027 1,093 03/30/2027 259 12/16/2024 14043 14050 14046 14047 14078 14044 14065 14056 14084 14064 14057 14079 14049 14054 14061 14062 14063 14052 14045 14085 14053 14048 14055 14082 14083 14060 American Equity Bank PENTAGON FCU LUANA SAVINGS BK SYNCHRONY BANK AMERICA EXPRESS NATL BK CFBANK FIRST FEDERAL THIRD FEDERAL S&L BEAL BANK PLANO TX GOLDMAN SACHS ST BK INDIA NY CAPITAL ONE BANK MERRICK BANK FARMERS & MERCHANTS BMW BANK OF NA INSBANK MEDALLION BK UT TOYOTA FINANCIAL EMPIRE ST BK NA BEAL BANK USA POPPY BANK FIRST GENERAL BK GREENSTATE CU MORGAN STANLEY PVT BANK MORGAN STANLEY PVT BANK SALLIE MAE BANK Subtotal and Average 6,696,000.00 6,696,000.00 6,201,751.23 6,696,000.00 1.165 1.181 822 Local Agency Inves tment Funds LAIFCITY LAIFCITY Local Agency Investment Fund Subtotal and Average 18,659,544.44 18,659,544.44 18,659,544.44 18,659,544.44 4.122 4.066 4.122 1 18,659,544.44 18,659,544.44 18,659,544.44 4.066 4.122 1 Cas h in Banks CLAS S CLAS S CALIFORNIA CLAS S 01/01/2024 2,026,321.57 28,099,742.12 2,026,321.57 28,099,742.12 2,026,321.57 28,099,742.12 5.440 4.122 5.365 4.066 5.440 4.122 1 1LAIF ARPA LAIF ARPA Local Agency Investment Fund Portfolio COSA CP Run Date: 04/19/2024 - 10:21 PM (PRF_PM2) 7.3.11 Report Ver. 7.3.11 City of Santa Ana P o rtfo lio Management P o rtfo lio De ta ils - Inves tments March 31, 2024 Page 2 Average Balance Purchas e Stated Rate YTM/C YTM/C Days to Maturity DateCUSIPInves tment #Is s uer Par Value Market Value 30,126,063.69 Book ValueDate 360 365 Maturity Subtotal and Average 64,361,371.30 30,126,063.69 30,126,063.69 4.153 4.211 1 Repurchas e Agreements Subtotal and Average 11,663,766.79 Federal Agency Coupon Securities 3133ELX33 3133EMBH4 3133EMFR8 3133EMSU7 3133EMUP5 3133EMWH1 3133EM2C5 3133ENPB0 3133ENUH1 3133ENVV9 3133EPW84 3133EPW68 3130AKPQ3 3130AKU53 3130AKN69 3130ALA53 3130ALBM5 3130ALB52 3130ALDZ4 3130ALKN3 3130ALLP7 3130ALW67 3130AMYU0 3130AMYC0 3130AMSF0 3130ANFU9 3130ANFG0 3130ANE30 3130ANHV5 3130ANPE4 3130ANQ78 13974 13988 13991 14005 14006 14016 14032 14075 14086 14088 14123 14125 13996 13997 13998 13999 14001 14002 14003 14004 14007 14008 14024 14025 14026 14027 14028 14029 14033 14034 14035 Federal Farm Credit Bank Federal Farm Credit Bank Federal Farm Credit Bank Federal Farm Credit Bank Federal Farm Credit Bank Federal Farm Credit Bank Federal Farm Credit Bank Federal Farm Credit Bank Federal Farm Credit Bank Federal Farm Credit Bank Federal Farm Credit Bank Federal Farm Credit Bank Federal Home Loan Bank Federal Home Loan Bank Federal Home Loan Bank Federal Home Loan Bank Federal Home Loan Bank Federal Home Loan Bank Federal Home Loan Bank Federal Home Loan Bank Federal Home Loan Bank Federal Home Loan Bank Federal Home Loan Bank Federal Home Loan Bank Federal Home Loan Bank Federal Home Loan Bank Federal Home Loan Bank Federal Home Loan Bank Federal Home Loan Bank Federal Home Loan Bank Federal Home Loan Bank 07/22/2020 09/29/2020 11/03/2020 03/09/2021 04/01/2021 04/21/2021 08/10/2021 02/16/2022 04/12/2022 05/03/2022 01/26/2024 01/29/2024 01/28/2021 01/28/2021 01/28/2021 02/25/2021 02/24/2021 02/25/2021 03/10/2021 03/24/2021 03/29/2021 04/22/2021 06/30/2021 06/30/2021 06/28/2021 07/29/2021 08/18/2021 07/29/2021 08/19/2021 08/26/2021 08/27/2021 6,000,000.00 5,000,000.00 5,000,000.00 4,000,000.00 6,000,000.00 5,000,000.00 6,000,000.00 3,500,000.00 2,000,000.00 3,000,000.00 1,000,000.00 1,000,000.00 4,000,000.00 5,000,000.00 6,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 4,000,000.00 4,000,000.00 6,000,000.00 5,000,000.00 6,000,000.00 6,000,000.00 6,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 6,000,000.00 6,000,000.00 5,681,160.00 4,685,550.00 4,672,200.00 3,702,920.00 5,746,380.00 4,773,400.00 5,458,080.00 3,272,850.00 1,928,700.00 2,900,670.00 983,290.00 6,000,000.00 5,000,000.00 4,997,500.00 4,000,000.00 6,000,000.00 5,000,000.00 6,000,000.00 3,500,000.00 2,000,000.00 3,000,000.00 992,169.00 0.690 0.530 0.540 0.800 0.710 0.710 0.710 2.180 3.330 3.630 3.875 4.125 0.580 0.520 0.500 0.600 0.625 0.375 0.500 0.500 0.650 1.100 1.050 1.000 0.400 0.850 0.875 1.250 0.550 0.700 0.900 0.681 0.523 0.543 0.789 0.692 0.700 0.700 2.150 3.284 3.580 3.995 4.315 0.572 0.513 0.493 0.592 0.616 0.370 0.493 0.493 0.655 1.085 1.036 0.986 0.395 0.838 0.863 0.863 0.542 0.690 0.888 0.690 0.530 0.550 0.800 0.701 0.710 0.710 2.180 3.330 3.630 4.050 4.375 0.580 0.520 0.500 0.600 0.625 0.375 0.500 0.500 0.665 1.100 1.050 1.000 0.400 0.850 0.875 0.875 0.550 0.700 0.900 477 07/22/2025 546 09/29/2025 581 11/03/2025 707 03/09/2026 365 04/01/2025 385 04/21/2025 861 08/10/2026 1,051 02/16/2027 1,106 04/12/2027 1,127 05/03/2027 1,753 01/18/2029 661 01/22/2026 27 01/28/2026 27 01/28/2026 302 01/28/2026 54 02/25/2026 53 02/24/2026 146 02/25/2025 70 03/10/2025 84 09/24/2024 77 03/17/2025 21 04/22/2026 90 06/30/2026 90 03/30/2026 88 06/28/2024 849 07/29/2026 47 05/18/2026 849 07/29/2026 262 12/19/2024 147 08/26/2025 878 08/27/2026 989,880.00 995,300.00 3,704,560.00 4,625,550.00 5,548,560.00 4,617,850.00 4,620,550.00 4,789,450.00 3,830,320.00 3,910,160.00 5,748,720.00 4,644,150.00 5,535,540.00 5,565,840.00 5,930,580.00 4,568,550.00 4,605,450.00 4,629,750.00 4,835,900.00 5,660,580.00 5,473,440.00 4,000,000.00 5,000,000.00 6,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 4,000,000.00 4,000,000.00 5,997,000.00 5,000,000.00 6,000,000.00 6,000,000.00 6,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 6,000,000.00 6,000,000.00 Portfolio COSA CP Run Date: 04/19/2024 - 10:21 PM (PRF_PM2) 7.3.11 City of Santa Ana P o rtfo lio Management P o rtfo lio De ta ils - Inves tments March 31, 2024 Page 3 Average Balance Purchas e Stated Rate YTM/C YTM/C Days to Maturity DateCUSIPInves tment #Is s uer Par Value Market Value Book ValueDate 360 365 Maturity Federal Agency Coupon Securities 3130AP3E3 3130ANX62 3130APB79 3130AP3A1 3130APB46 3130APQC2 3130APQB4 3130APVC6 3130AQAB9 3130AQLQ4 3130AQKM4 3130AQNR0 3130AQSA2 3130AQW33 3130AQYA5 3130ARA35 3130ARC82 3130ARR60 3130AVB84 3130AVRG9 3130AYDW3 3130AFFX0 3130AYPS9 3134GVQX9 3134GVVX3 3134GVR26 3134GVT99 3134GV5R5 3134GWUE4 3134GW4Z6 3134GXJL9 3134GYZ21 3135G0X24 3135G0W66 3136G4WV1 3136G4D42 14036 14037 14038 14039 14040 14041 14042 14058 14059 14069 14070 14071 14072 14073 14074 14076 14077 14087 14103 14113 14122 14124 14126 13962 13964 13967 13968 13979 13987 13989 13995 14105 13940 13941 13965 13976 Federal Home Loan Bank Federal Home Loan Bank Federal Home Loan Bank Federal Home Loan Bank Federal Home Loan Bank Federal Home Loan Bank Federal Home Loan Bank Federal Home Loan Bank Federal Home Loan Bank Federal Home Loan Bank Federal Home Loan Bank Federal Home Loan Bank Federal Home Loan Bank Federal Home Loan Bank Federal Home Loan Bank Federal Home Loan Bank Federal Home Loan Bank Federal Home Loan Bank Federal Home Loan Bank Federal Home Loan Bank Federal Home Loan Bank Federal Home Loan Bank Federal Home Loan Bank 09/30/2021 09/30/2021 09/30/2021 09/29/2021 10/13/2021 11/23/2021 11/23/2021 12/14/2021 12/30/2021 01/27/2022 01/28/2022 01/27/2022 02/10/2022 02/24/2022 02/28/2022 03/24/2022 03/29/2022 04/29/2022 07/28/2023 11/03/2023 01/05/2024 01/26/2024 01/30/2024 05/05/2020 05/28/2020 06/25/2020 06/30/2020 07/15/2020 09/30/2020 10/27/2020 12/30/2020 08/02/2023 01/15/2020 01/15/2020 06/16/2020 07/28/2020 5,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 10,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 3,750,000.00 5,000,000.00 1,500,000.00 3,000,000.00 5,000,000.00 5,000,000.00 1,500,000.00 3,000,000.00 3,000,000.00 2,000,000.00 4,000,000.00 10,000,000.00 12,000,000.00 1,000,000.00 4,000,000.00 5,000,000.00 5,000,000.00 6,000,000.00 6,000,000.00 6,000,000.00 5,000,000.00 6,000,000.00 6,000,000.00 4,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 8,000,000.00 4,559,200.00 4,746,750.00 4,564,250.00 4,583,600.00 9,090,400.00 4,967,700.00 4,621,450.00 4,601,900.00 3,445,087.50 4,612,150.00 1,386,360.00 2,775,180.00 4,632,750.00 4,657,850.00 1,406,655.00 2,910,990.00 2,804,550.00 1,960,940.00 3,998,760.00 9,999,600.00 12,000,840.00 957,290.00 5,000,000.00 5,000,000.00 5,000,000.00 4,998,750.00 10,000,000.00 5,000,000.00 5,000,000.00 4,997,500.00 3,750,000.00 5,000,000.00 1,500,000.00 3,000,000.00 5,000,000.00 5,000,000.00 1,500,000.00 3,000,000.00 3,000,000.00 2,000,000.00 3,991,400.00 9,993,000.00 12,000,000.00 969,118.00 0.820 0.650 1.000 0.850 0.950 0.750 1.500 1.375 1.625 1.650 1.750 1.750 1.830 2.020 2.250 2.000 2.100 3.100 5.250 5.300 5.230 3.250 4.800 0.700 0.750 0.700 0.650 0.570 0.500 0.540 0.500 5.000 1.625 1.625 0.750 0.510 0.809 0.641 0.986 0.847 0.937 0.740 1.479 1.377 1.603 1.628 1.726 1.726 1.805 1.992 2.219 1.973 2.071 3.058 5.368 5.371 5.158 3.907 4.734 0.711 0.746 0.690 0.641 0.562 0.493 0.533 0.493 5.498 1.641 1.629 0.740 0.503 0.820 0.650 1.000 0.858 0.950 0.750 1.500 1.396 1.625 1.650 1.750 1.750 1.830 2.020 2.250 2.000 2.100 3.100 5.443 5.446 5.230 3.961 4.800 0.720 0.756 0.700 0.650 0.570 0.500 0.540 0.500 5.575 1.664 1.651 0.750 0.510 912 09/30/2026 90 06/30/2025 912 09/30/2026 89 06/29/2026 12 10/13/2026 52 05/23/2024 22 11/23/2026 61 12/01/2026 90 12/30/2026 26 01/27/2027 27 01/28/2027 26 01/27/2027 39 02/10/2027 53 02/24/2027 53 02/24/2027 84 03/24/2025 1,092 03/29/2027 28 04/29/2025 165 09/13/2024 18 04/19/2024 64 06/04/2024 1,690 11/16/2028 304 01/30/2026 399 05/05/2025 57 05/28/2025 85 06/25/2025 455 06/30/2025 14 07/15/2024 90 09/30/2025 209 10/27/2025 273 12/30/2025 122 08/01/2025 281 01/07/2025 197 10/15/2024 441 06/16/2025 483 07/28/2025 3,976,960.00 4,773,000.00 4,762,900.00 5,691,780.00 5,688,420.00 5,916,420.00 4,685,750.00 5,606,040.00 5,567,640.00 3,987,200.00 4,868,000.00 4,905,350.00 4,760,450.00 7,554,480.00 4,000,000.00 4,995,000.00 4,998,750.00 6,000,000.00 6,000,000.00 6,000,000.00 5,000,000.00 6,000,000.00 6,000,000.00 3,978,000.00 4,990,750.00 4,994,000.00 5,000,000.00 8,000,000.00 Federal Home Loan Mortgage Co. Federal Home Loan Mortgage Co. Federal Home Loan Mortgage Co. Federal Home Loan Mortgage Co. Federal Home Loan Mortgage Co. Federal Home Loan Mortgage Co. Federal Home Loan Mortgage Co. Federal Home Loan Mortgage Co. Federal Home Loan Mortgage Co. Federal Nat'l Mtg. Assoc. Federal Nat'l Mtg. Assoc. Federal Nat'l Mtg. Assoc. Federal Nat'l Mtg. Assoc. Portfolio COSA CP Run Date: 04/19/2024 - 10:21 PM (PRF_PM2) 7.3.11 City of Santa Ana P o rtfo lio Management P o rtfo lio De ta ils - Inves tments March 31, 2024 Page 4 Average Balance Purchas e Stated Rate YTM/C YTM/C Days to Maturity DateCUSIPInves tment #Is s uer Par Value Market Value Book ValueDate 360 365 Maturity Federal Agency Coupon Securities 3136G4C43 3136G4G98 3136G45Q2 3135GA4V0 3135GAAN1 3135G06J7 3135GAG62 13977 13978 13990 13992 13993 13994 14094 Federal Nat'l Mtg. Assoc. Federal Nat'l Mtg. Assoc. Federal Nat'l Mtg. Assoc. Federal Nat'l Mtg. Assoc. Federal Nat'l Mtg. Assoc. Federal Nat'l Mtg. Assoc. Federal Nat'l Mtg. Assoc. 08/14/2020 08/12/2020 10/28/2020 11/25/2020 12/17/2020 12/10/2020 03/30/2023 6,000,000.00 6,000,000.00 6,000,000.00 5,000,000.00 6,000,000.00 6,000,000.00 1,500,000.00 5,663,700.00 5,658,420.00 5,594,220.00 4,651,550.00 5,562,960.00 5,591,280.00 1,499,925.00 6,000,000.00 6,000,000.00 6,000,000.00 5,000,000.00 6,000,000.00 6,000,000.00 1,500,000.00 0.650 0.560 0.530 0.625 0.600 0.650 5.220 0.641 0.552 0.523 0.616 0.592 0.641 5.152 0.650 0.560 0.530 0.625 0.600 0.650 5.224 500 08/14/2025 41 08/12/2025 27 10/28/2025 54 11/25/2025 77 12/17/2025 70 12/10/2025 25 04/26/2024 Subtotal and Average 368,444,293.45 9,641,088.89 4,990,000.00 363,750,000.00 343,891,277.50 363,638,237.00 1.358 1.376 267 Federal Agency Dis count Securities 313384VE6 14104 Federal Home Loan Bank 08/01/2023 03/16/2022 03/11/2024 10,000,000.00 9,988,500.00 9,641,088.89 5.210 1.750 5.040 5.482 5.558 4 04/05/2024 Subtotal and Average 10,000,000.00 9,988,500.00 9,641,088.89 5.482 5.558 4 Treas ury Coupon Securities 9128286Z8 14081 14134 U.S. Treasury 5,000,000.00 4,955,350.00 4,990,000.00 1.814 1.839 90 06/30/2024 Subtotal and Average 5,000,000.00 4,955,350.00 4,990,000.00 1.814 1.839 90 Treas ury Strips 912797GL5 US Treasury 9,000,000.00 8,799,120.00 8,775,720.00 5.241 5.313 157 09/05/2024 Subtotal and Average 5,944,842.58 9,000,000.00 8,799,120.00 8,775,720.00 5.241 5.313 157 Total and Average 490,400,907.46 443,231,608.13 422,621,606.86 442,526,654.02 1.831 1.857 236 Portfolio COSA CP Run Date: 04/19/2024 - 10:21 PM (PRF_PM2) 7.3.11 City of Santa Ana P o rtfo lio Management P o rtfo lio De ta ils - Cas h March 31, 2024 Page 5 Average Balance Purchas e Date Stated Rate YTM/C YTM/C Days to CUSIP Inves tment #Is s uer Par Value Market Value Book Value 360 365 Maturity Cas h in Banks PETTY CASH HOUSING PETTY CASH 13943 CITY OF SANTA ANA JP MORGAN CHASE JP MORGAN CHASE JP MORGAN CHASE JP MORGAN CHASE JP MORGAN CHASE JPMorgan Chase 80,625.00 9,679,851.93 1,338,007.22 2,284,777.46 35,084.30 80,625.00 9,679,851.93 1,338,007.22 2,284,777.46 35,084.30 80,625.00 9,679,851.93 1,338,007.22 2,284,777.46 35,084.30 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 1 1 1 1 1 1 1 1 1 1 WORKERS COMPENS 37983 GENERAL LIABILI 38130 PROPERTY MANAGE 8695 PROPERTY MGMT 2 HEALTHCARE SPEN COMMISSARY PROP MGMT 2 1,492.50 1,492.50 1,492.50 0112 7962 297,006.46 324,151.07 22,028,683.86 785,341.56 297,006.46 324,151.07 22,028,683.86 785,341.56 297,006.46 324,151.07 22,028,683.86 785,341.56 JPMorgan Chase GENERAL ACCOUNT 9500 JPMorgan Chase FSS FSS Santa Ana Federal Credit Union Average Balance 0.00 490,400,907.46 1 Total Cas h and Inves tments 480,086,629.49 459,476,628.22 479,381,675.38 1.831 1.857 236 Portfolio COSA CP Run Date: 04/19/2024 - 10:21 PM (PRF_PM2) 7.3.11 CASH/SECURITIES HELD IN TRUST Portfolio Management Page 1 Portfolio Details - Investments March 31, 2024 CUSIP Investment #Issuer Par Value Market Value Book Value Money Market Accounts X9USDDTPC X9USDDTPC SYS80464 80364 Dreyfus Treasury 10,571.39 11,832.88 649.34 292.22 2,909.69 326.40 42.05 10,571.39 11,832.88 649.34 292.22 2,909.69 326.40 42.05 10,571.39 11,832.88 649.34 292.22 2,909.69 326.40 42.05 80365 80366 80106 80389 80391 80107 80405 80406 80407 80418 80419 80421 80430 80432 80248 80465 80466 Dreyfus Treasury Dreyfus Treasury X9USDDEFU- X9USDDEFU X9USDDEFU CUX9USDDEFU 9AMMF05B2 9AMMF05B2-- 9AMMF05B2- SYS80418 INSTL RES TRE & AGNY CASH ADV INSTL RES TRE & AGNY CASH ADV INSTL RES TRE & AGNY CASH ADV DREYFUS INS PRE TSY OBL HAMIL US BANK MONEY MARKET US BANK MONEY MARKET US BANK MONEY MARKET US BANK MONEY MARKET US BANK MONEY MARKET US BANK MONEY MARKET US BANK MONEY MARKET US BANK MONEY MARKET MORGAN STANLEY GOVT INSTL MORGAN STANLEY GOVT INSTL MORGAN STANLEY GOVT INSTL 2.92 2.92 2.92 0.80 0.80 0.80 0.49 0.49 0.49 1,207,083.92 105,346.39 0.01 1,207,083.92 105,346.39 0.01 1,207,083.92 105,346.39 0.01 SYS80419 SYS80421 31846V401 6,569.68 11,946.25 3.10 6,569.68 11,946.25 3.10 6,569.68 11,946.25 3.10 31846V401- X9USDMOR3 X9USDMOR3 X9USDMOR3 95.81 95.81 95.81 59.46 59.46 59.46 Subtotal and Average 1,357,732.80 1,357,732.80 1,357,732.80 Other S86209710 98INP5PV2 SYS80420 80225 80396 80437 MBIA INSURANCE POLICY ASSURED GUARANTY MUNI CORP US Bank Mutual Funds 1.00 1.00 1.00 1.00 1.00 1.00 28,582,095.63 29,099,828.64 28,582,095.63 Subtotal and Average 28,582,097.63 29,099,830.64 28,582,097.63 Cash in Bank SYS80414 SYS80415 80414 80415 FLAGSTAR BANK 1,268,869.87 1,041,525.00 1,268,869.87 1,041,525.00 1,268,869.87 1,041,525.00CONDEMNATION DEPOSIT FUND Subtotal and Average 2,310,394.87 2,310,394.87 2,310,394.87 Portfolio TRST AC Run Date: 04/09/2024 - 09:03 PM (PRF_PM2) 7.3.11 Report Ver. 7.3.11 Investments Amount Bank of New York Mellon - Investment Custodian 393,741,046 Local Agency Investment Fund (L.A.I.F)18,659,544 Local Agency Investment Fund (L.A.I.F) - ARPA 28,099,742 California CLASS 2,026,322 Total ‐ Investments 442,526,654.02$ Cash Held at City Financial Institution(s) and Cash on Hand Amount General Account 22,028,683.86 General Liability Account 2,284,777.46 Housing Account 9,679,851.93 Workers Compensation Account 1,338,007.22 Santa Ana Federal Credit Union - Family Self Sufficiency (FSS-Housing)785,341.56 Commissary Account 324,151.07 Flexible Benefit Spending Account 297,006.46 Property Management Account 35,084.30 Property Management - Phase 2 Account 1,492.50 Petty Cash 80,625.00 Total ‐ Cash Held at City Financial Institution(s) and Cash on Hand 36,855,021.36$ Restricted Cash Amount Signature Bank - Streetlight Project 1,268,869.87 US Bank - Pension Stability Funds (Section 115 Trust with PARS)29,789,179.55 State of California Condemnation Fund - Right of Way Deposits 1,041,525.00 Various US Bank & BNY 150,650.88 Total ‐ Restricted Cash 32,250,225.30$ Total Cash Held City at Financial Institution(s), Cash on Hand and Restricted Cash 511,631,900.68$ Cash by Fund(s) - Total (see below for listing)511,631,900.68$ Fund Fund description Amount 011 GENERAL FUND 139,242,235 012 CANNABIS PUBLIC BENEFIT 21,320,093 016 CASP CERTIFICATION & TRAINING 493,639 020 OTS-TRAFFIC OFFENDER PROGRAM 36,604 021 PRCSA CATV FUND 2,171,501 022 PRCSA FEE & DONATION 813,821 023 INMATE WELFARE FUND 2,352,733 024 PD ATHLETIC ACTIVITIES LEAGUE (192,713) 025 IDB & EZ VOUCHER MONITORING 177,916 026 ASSET FORFEITURE FUND 182,498 027 PARKING FUND 3,961,253 029 SPECIAL GAS TAX 27,539,115 030 PROP 1B BOND ACT OF 2006 156,665 031 AIR QUALITY IMPR. (AB 2766)1,313,048 032 MEASURE M-STREET CONSTRUCTION (11,291,632) 033 NEW TRANSPO SYS IMPR AREA B 586,335 034 NEW TRANSPO SYS IMPR AREA E 1,761,256 035 NEW TRANSPO SYS IMPR AREA F 2,480,776 041 TRANSP SYS IMPR AREA A-2 713,049 042 TRANSPO SYS IMPR AREA B 9,763 048 TRANSPO SYS IMPR AREA C-2 218,070 049 TRANSPO SYS IMPR AREA G 100,512 051 CAPITAL OUTLAY FUND 2,837,527 053 CITY SERVICES 7,393,344 054 SANITARY SEWER CAPITAL 7,718,406 055 SEWER CONNECTION FEE 4,770,665 056 SANITARY SEWER SERVICE 10,306,178 057 FED CLEAN WATER PROTECTION ENT 7,732,719 058 RESIDENTIAL STREET IMPROVEMENT 6,010,990 059 SELECT STREET CONSTRUCTION 23,854,606 060 WATER REVENUE 4,082,980 066 ACQUISITION & CONSTRUCTION 4,722,676 067 REGIONAL TRANSP CENTER 516,416 068 SANITATION FUND 4,009,657 069 REFUSE COLLECTION SERVICE 5,528,298 070 EQUIPMENT REPLACEMENT FUND 7,855,088 073 BUILDING MAINT FUND 1,521,599 074 CIVIC CENTER MAINTENANCE (523,089) 075 FLEET MAINTENANCE/STORES 1,361,548 076 STORES & PROPERTY CONTROL (1,002,366) 078 RETIREMENT SYSTEM (263,022) 080 LIABILITY AND PROPERTY INS FND 13,784,739 081 EMPLOYEE GROUP INSURANCE 2,028,945 082 WORKERS COMPENSATION FUND 20,034,436 083 PAYROLL REVOLVING 7,504,020 085 CITY YARD OPERATION (982,859) 086 PUB WKS ENG/PROJ MGMT (1,019,929) 087 PT RETIREMENT FUND 11,442 088 QUALITY SERVICE TRAINING 31,038 089 CA SEISMIC HAZARD PROGRAM 10,494 090 ORANGE CO SANITATION DIST 2&3 564,487 093 BUSINESS IMPROVEMENT DISTRICT 57,624 094 INTEREST AGENCY - 095 POLICE COMMISSARY ACCOUNT 277,778 096 SA TOURISM MARKETING DISTRICT 99,688 097 POLICE SEIZED ASSETS 2,156,459 Exhibit 2 100 SECTION 457 FIDUCIARY ADMIN 46,496 101 PUB WKS-ADMIN & PLANNING 3,557,962 103 PMA RETIREE HEALTH INSURANCE 7,551 104 SEIU RETIREE HEALTH INSURANCE 57,683 106 MGMT RETIREE HEALTH INSURANCE 6,098 107 UC RETIREE HEALTH INSURANCE 5,514 109 INFO SYS STRATEGIC PLAN 13,627,957 110 STRONG MOTION INSTRUMENTATION 114,445 111 OPIOID REMEDIATION 418,827 120 FIRE FACILITIES FUND 2,886,703 121 SPECIAL REPAIR/DEMOLITION 711,980 122 EMERGENCY & HEALTH GRANTS 9,863,254 123 WORKFORCE INVESTMENT ACT (480,417) 124 ORANGE COUNTY SSA GRANTS (166,105) 125 OES UASI (1,994,441) 127 D.O.J. GRANT FUND 53,179 128 POLICE BLOCK GRANTS 2,505,943 130 HOME PROGRAM FEDERAL GRANT 3,061,460 131 MISC GRANTS 1,248 133 HOUSING AUTHORITY-ISSUER FEE 2,571,857 135 COMMUNITY DEV BLOCK GRANT (359,937) 136 HOUSING AUTHORITY-VOUCHER HAP 864,694 137 HOUSING AUTHORITY - NED 4,703.00$ 138 HOUSING AUTHORITY-MS 5 8,036 139 HOUSING AUTHORITY-NEW CONSTR 446,209 140 HOUSING AUTHORITY-VOUCHER ADM 3,487,069 142 NSP FEDERAL GRANT 240,313 143 CALHOME MFGD HSG LOAN 780,375 144 PRISON TO EMPLOYMENT PROGRAM (6,606) 145 RENTAL REHABILITATION GRANT 49,223 147 FEDERAL AID SAFETY PROGRAM (925,106) 148 TRAFFIC SYSTEM MGMT GRANT (6,687,268) 149 WIC ASSESSMENT DIST ST IMPRV 33,455 152 PUBLIC LIBRARY GRANT FUND 5,161,880 158 PLANNING GRANTS PROGRAM 9,385 161 PRCSA CAPITAL GRANTS (2,206,428) 162 ENERGY CONSERVATION PROGRAM - 164 PUB WKS-WTR QUALITY & CONTROL (6,410,986) 165 OFFICE OF SAFETY GRANT 70,038 166 US DOJ ASSET FORFEITURE FUND 1,594,181 167 US TREASURY ASSET FORFEITURE 209,572 169 RECREATION GRANTS FUND 686,172 172 NATL RECREATION TRAILS FND ACT 17,329 177 EMERGENCY RENTAL ASSISTANCE PG 730,409 178 COVID RELIEF FUND - 179 GENERAL FIXED ASSETS 14,514 180 ARPA EHV ADMIN FEES 149,947 181 AMERICAN RESCUE PLAN ACT 68,677,830 182 HOME-ARP PROGRAM FEDERAL GRANT (2,517) 183 ARPA - CA FOR ALL YOUTH WDP (760,852) 185 RENT STABILIZATION 1,488,524 186 HCV F S S FORFEITURES 153,865 201 LOCAL DRAINAGE AREA NO 1 135 202 LOCAL DRAINAGE AREA NO 2 1,461 203 LOCAL DRAINAGE AREA NO 3 771,669 204 LOCAL DRAINAGE AREA NO 4 1,079 205 LOCAL DRAINAGE AREA NO 5 613 206 LOCAL DRAINAGE AREA NO 6 900 207 LOCAL DRAINAGE AREA NO 7 198,451 209 LOCAL DRAINAGE AREA NO 9 749 210 LOCAL DRAINAGE AREA NO 10 17,548 211 LOCAL DRAINAGE AREA NO 11 228 212 LOCAL DRAINAGE AREA NO 12 13 213 LOCAL DRAINAGE AREA NO 13 2,757 221 LOCAL DRAINAGE AREA I 1,140,141 222 LOCAL DRAINAGE AREA II 291,133 223 LOCAL DRAINAGE AREA III 249,201 224 LOCAL DRAINAGE AREA IV 635,702 225 LOCAL DRAINAGE AREA V 384,372 226 LOCAL DRAINAGE AREA VI 460,722 301 REC/COMM SVS 6,175 311 RESIDENTIAL DEVELOP DISTRICT 1 1,236,239 312 RESIDENTIAL DEVELOP DISTRICT 2 6,435,891 313 RESIDENTIAL DEVELOP DISTRICT 3 14,263,475 314 RESIDENTIAL DEVELOP DISTRICT 4 492,638 315 RESIDENTIAL DEVELOP HARBOR SPECFIC 1,027,264 400 POLICE UUT LEASE REVENUE BONDS 3,362,891 404 COSA 2014 LEASE FINANCING 3,109,377 406 2021 PENSION OBLIGATION BONDS 32,251 417 INCLUSIONARY HOUSING FEE 8,662,817 418 CDA - PEEBLER CAPITAL FUND 216,227 607 HOUSING AUTHORITY LMIHF 3,988,655 655 2018A SERIES TAX ALLOC BOND 16,024 670 COSA RDA 651,187 671 COSA RDA OBLIGATION RETIREMENT 358,790 980 SAN JUAQUIN TRANS CORRIDOR - 981 EASTERN FOOTHILL TRANS CORRIDO 104,408 991 TRAN SYS IMP AUT C-2 TUSTIN 3,192,192 992 TRAN SYS IMP AUT AREA D-TUSTIN 10,642,938 993 WIC ASSESSMENT DISTRICT 411,226 999 Lawson Clearing 24,391 Reconciling Item(s) - Outstanding Checks *3,582,805 Reconciling Item(s) - Bank Direct Deposits*5,403,667 Reconciling Item(s) - Deposits in Transit*(522,971.72) Withdrawals in Transit - Reconciling Item(s) - Various*(737,870)